On 29/07/2012 5:09 PM, sldfghtrike wrote:
So I just wanted a simple calculator that would help me determine how
long it would be before I finished paying of my mortgage and then I just
kept adding things and so I came up with this. You may do as you wish
with this workbook. If you have any suggestions or questions feel free
to to let me know and I'll see if I can do something about it.


+-------------------------------------------------------------------+
|Filename: Mortgage Calculator.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=510|
+-------------------------------------------------------------------+



Hi

Where as this is a handy calculator to have if you have a fixed interest
rate throughout the life of the mortgage, it unfortunately falls over if
you have an interest rate change as once you change the rate in B5 it
has a widespread effect on the overall figures.

I would be more inclined to have a column dedicated to the rate and
applying it to each monthly payment thus localising it to said monthl
and not corrupting previous or post figures.

HTH
Mick.