I searched for a library of common Financial Functions, but came up blank (maybe there's already one there, but I couldn't find it). So, here's my version. I hope you find it useful.
Also included is a small app that demonstrates how to use each function.
If you do find any issues, please let me know and I'll post an update.
| Function | Description |
|---|---|
| PresentValue | Returns the total amount that a series of future payments is worth now |
| FutureValue | Returns the future value of a series of regular payment amounts with a constant interest rate |
| RateOfReturnAnnuity | Returns the Interest Rate percentage of a loan or investment |
| RateOfReturnLoan | Returns the Annual Interest Rate percentage of a loan or investment |
| Payment | Returns the regular Payment Amount for a loan based on a constant interest rate |
| SimpleInterest | Returns the Interest Amount earned on a loan or savings account where interest is not compounded (i.e. simple interest) |
| CompoundInterest | Returns the Interest Amount on a loan or a deposit, where interest is earned on both the original amount and any interest already earned on that amount |
| NetPresentValue | Returns the Present Value of an asset less the initial purchase price |
| NumberPeriods | Number of payments required to pay off a loan |
Also included is a small app that demonstrates how to use each function.
If you do find any issues, please let me know and I'll post an update.
