Financial functions (SQL SERVER)

financial-functions.md

Financial Functions

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

Thanks for sharing these financial functions. I did test and use your PMT function in production so I made sure to credit your work.