Login     Register

        Contact Us     Search

New SQL Server loan functions in XLeratorDB/financial 1.13

Sep 25

Written by: Charles Flock
9/25/2014 5:34 PM  RssIcon

We added 7 new table-valued functions to XLeratorDB/financial and XLeratorDB/financial 2008 that generate principal and interest payment schedules for different types of loans. This article provides insight into some of the calculations used in these new functions.
On September 19, 2014 we added 7 new table-valued functions to the XLeratorDB financial library that generate cash flow projections for a wide variety of loan types. Using these functions is as easy as using SQL and doesn't require any advanced knowledge of financial calculations. The functions insulate the user from the complexity of the calculations for these type of loans. The purpose of this article is to explore some of those complexities in more detail, especially the calculations of the principal payment, interest payment and grace interest amounts. We will do that by using SQL and other XLeratorDB functions. Knowing the how of the calculations, of course, is not necessary to use the functions and all of the examples provided in this article are really the hard way of doing things. Nothing could be easier than just using the new functions.