ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Based Mortgage Calculator (https://www.excelbanter.com/excel-discussion-misc-queries/230557-excel-based-mortgage-calculator.html)

Paul Calcagno

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


Eduardo

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



Paul Calcagno

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