This is a list of Financial Functions that i've developed in the past years. You can use them to do amortization schedule calculations and so. Please make good use of them, you can do whatever you like, there's no copyright.
- Interest Payment (IPMT).
- Future Value (FV).
- Payment (PMT).
- Effective Annual Interest Rate (EFFECT).
- Principal Payment (PPMT).
- Cumulative Interest.
If you need help you can e-mail me @: AzsaturnDx@gmail.com
With ❤️ by: AzsaturnDx
Thanks for the script, I have converted it to plsql. Hope it's useful :
https://gist.github.com/si294r/e42f9817f3404ef874a393834dfa161d