Home > IT Answers > Development > Can anyone suggest a good loan APR formula in SQL
Nrate
5 pts.
 Can anyone suggest a good loan APR formula in SQL
Excel Rate function, SQL, SQL IIR
I am getting a rather large error with an Excel RATE function, and so am wondering if someone can suggest a SQL formula or a solution?

Software/Hardware used:
ASKED: February 6, 2008  6:38 PM
UPDATED: July 25, 2011  9:28 PM
RELATED QUESTIONS
Answer Wiki:
Select download for mortgage template from Microsoft Excel site ... works beautifully
Last Wiki Answer Submitted:  February 6, 2008  9:05 pm  by  Bitbucket49   30 pts.
All Answer Wiki Contributors:  Bitbucket49   30 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Here’s a blog article with an example of how to do the Excel RATE calculation in SQL. Very easy and very fastt.

Somesqlguy
 20 pts.
 

Oops, left off the link.

Somesqlguy
 20 pts.
 
Drewloanonline5
 95 pts.