Looks like this one is a winner... I put the formula in Excel and ran it and then compared the result to an online mortgage calculator and the results were the same...
Thanks, everyone! Rick -----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 05, 2006 1:40 PM To: CF-Talk Subject: RE: Mortgage Formula Is there a consensus on this one? M = P * ( J / (1 - (1 + J) ^ -N)) Rick -----Original Message----- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 05, 2006 12:13 PM To: CF-Talk Subject: RE: Mortgage Formula M = P * ( J / (1 - (1 + J) ^ -N)) maybe? ....:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 05, 2006 12:09 PM To: CF-Talk Subject: RE: Mortgage Formula Might this be it? M = P * ( J / (1 - (1 + J) * (-N * -N))) I'm not all that great at math so that's probably not right...just a guess. <!----------------//------ andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> -----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 05, 2006 10:56 AM To: CF-Talk Subject: Mortgage Formula Can anyone help write this in CF? It's a mortgage calculation formula and I want to build a CF-based calculator. Here's the formula I found: M = P * ( J / (1 - (1 + J) ** -N)) M is Mortgage Payment P is Principal J is monthly interest in decimal form = I / (12 x 100) N is the number of months of the loan I'm not sure how to handle the ** -N part.the exponent. How would this be written using CF? Thanks for anyone's help. Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245431 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
