![]() |
Excel Based Mortgage Calculator
Older versions of Excel used to have a nice mortgage calculator. It was
obviously a macro that allowed one to enter data like the principal, interest rate, term, etc. and then it would calculate the monthly payment and offer a graph of how the principal would be reduced over time, how much interest was paid over time, etc. Does anyone know of such a thing in Office 2007? Perhaps it's part of an Add-In. Thanks in advance................Paul |
Excel Based Mortgage Calculator
Hi
Go to the microsoft web there you have lots of examples http://office.microsoft.com/en-ca/te...gage&av=TPL000 "Paul Calcagno" wrote: Older versions of Excel used to have a nice mortgage calculator. It was obviously a macro that allowed one to enter data like the principal, interest rate, term, etc. and then it would calculate the monthly payment and offer a graph of how the principal would be reduced over time, how much interest was paid over time, etc. Does anyone know of such a thing in Office 2007? Perhaps it's part of an Add-In. Thanks in advance................Paul |
Excel Based Mortgage Calculator
Hi Eduardo. That was a great tip and I got exactly what I was looking for.
Thanks so much............Paul C. "Eduardo" wrote in message ... Hi Go to the microsoft web there you have lots of examples http://office.microsoft.com/en-ca/te...gage&av=TPL000 "Paul Calcagno" wrote: Older versions of Excel used to have a nice mortgage calculator. It was obviously a macro that allowed one to enter data like the principal, interest rate, term, etc. and then it would calculate the monthly payment and offer a graph of how the principal would be reduced over time, how much interest was paid over time, etc. Does anyone know of such a thing in Office 2007? Perhaps it's part of an Add-In. Thanks in advance................Paul |
All times are GMT +1. The time now is 02:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com