Les, Check out the Mortgage Payment Calculator in the Calulator section of http://www.firstshorefederal.com. If this looks like what you're looking for just email me off list and I'll forward the code. This is straight CF, with special attention paid to how and when the numbers are rounded. There is also a custom tag that is has a js based calc listed in the tag section of benforta.com.
Cutter Les Mizzell wrote: >Does anybody have a formula to calculate Mortgage APR written in Cold Fusion >that I could have a look at? > >All I've been able to find so far is the below, which doesn't exactly give >me a complete formula like I need: > >APR - Annual Percentage Rate >The formula used to calculate the APR uses the same principles as the IRR >although the assumptions about the term are forced by the legislation, as is >the resulting 1 decimal place rounding and 0.1% variation. The Consumer >Credit Act lays down the fundamental formula for calculating APR, slightly >simplified as follows:- > >Loan = Initial Fees + P1 / (1 + i) a + P2 / (1 + i) b + P3 / (1 + i) c + ... > >Where P1, P2 etc are the periodic payments and a, b etc are the periods, >usually 1,2 etc up to say 36 for a three year loan. The payments include >fees and costs where relevant, as prescribed by the Act. > >The trick is to find i, which is the APR per period, and an iterative >solution is essential. If you assume the periods are months, i will give >you the monthly APR, which is then easily changed to the annual APR with >formula > >(1 + i) 12 - 1 where i is the monthly rate. > >The iterative procedures used to calculate IRR rely on a formula similar to >this same, fundamental formula. The results for the IRR and the APR are >identical, given the same assumptions and accuracy restrictions. > >I would not recommend you use this 'official' formula to calculate the APR >in practise, because the simpler, automatic spreadsheet functions come up >with the same result. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
