monthly mortgage payment calculator
I tried to make a mortgage calcultor but my numbers do not jive with the
realtors web sites. My formula= (100,000*.06)/12 does not include the interest so my calculations were too low. How would I figure out a monthly payment for a $100,000 loan at 6% over 30 years? Is there a special formula? Thanks. -Raza |
monthly mortgage payment calculator
Try this: http://www.officearticles.com/downlo...calculator.zip
I created it for a "real" realtor, so I assume it's accurate. ************ Anne Troy www.OfficeArticles.com "Raza" wrote in message ... I tried to make a mortgage calcultor but my numbers do not jive with the realtors web sites. My formula= (100,000*.06)/12 does not include the interest so my calculations were too low. How would I figure out a monthly payment for a $100,000 loan at 6% over 30 years? Is there a special formula? Thanks. -Raza |
monthly mortgage payment calculator
Hi,
Mnthly paymt= 100000*(0.06/12)*((1+0.06/12)^360)/(((1+0.06/12)^360)-1) Regards, B. R. Ramachandran "Raza" wrote: I tried to make a mortgage calcultor but my numbers do not jive with the realtors web sites. My formula= (100,000*.06)/12 does not include the interest so my calculations were too low. How would I figure out a monthly payment for a $100,000 loan at 6% over 30 years? Is there a special formula? Thanks. -Raza |
All times are GMT +1. The time now is 08:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com