Loan Amortisation in SQL Server (PMT, FV, IPMT, PPMT)
March 17th, 2010 in .Net, Blog, SQL ServerWhilst designing a data warehouse for a banking client recently, I needed to calculate projected future loan payments (including breaking this down by interest and capital payments) for every customer throughout the life of the loan. In Excel this is a pretty simple job, as Microsoft helpfully provide a number of functions to do just that (namely PMT, FV, IPMT and PPMT). In SQL Server however we do not have the luxury of having ready made…
» Read more