* HILAIRE * - NPER Excel Function in MSSQL
Posted on 2004-08-04
I was searching through EE and viewed the question posted by ktrimmer: Payment function in MSSQL asked by ktrimmer on 11/26/2003 04:36AM PST - Q_20809063.html
The solution was very informative and was of extreme assistance to me.
I am now looking for a function the equivalent of the excel NPER Function.
The following parameters are known.
Capital Amount - R 5000
Interest Rate - 20.3% .
Payment Amount - R 500 per month.
I want a function that can give me the number of months (taking into account interest) that a person will have to pay R500 for in order to settle a debt.
The excel funtion of NPER needs to be applied in MSSQL.
B5 = 20.3% B6 = 500, B3 = 5000
Hilaire .. your solution in previously asked question as mentioned above calculates rate as well as payment amount. Is there a formulae/function in sql that will calculate No of Periods
Your assistance in this regard will be greatly appreciated