nick205
|
posted on 9/4/10 at 09:52 AM |
|
|
Mortgage calculations?
I'm looking for a method of calculating the effect of overpaying on a mortgage.
For example if the mortgage is £100,000 borrowed @ 5% and the monthly repayment is £800 over 15 years how do you calculate the net effect of paying
£1,000 a month or £200 over the normal repayment?
Scratch that...just found what I was looking for here...
http://www.whatmortgage.co.uk/calculators/fleximortgage.html
[Edited on 9/4/10 by nick205]
|
|
|
mads
|
posted on 9/4/10 at 09:55 AM |
|
|
try this calculator:
http://www.whatmortgage.co.uk/calculators/fleximortgage.html
We gain knowledge faster than we do wisdom!
Life is not a journey to the grave with the intention of arriving safely in a pretty and well-preserved body, but rather to skid in
sideways, thoroughly used, totally worn out and loudly proclaiming... "f*ck, what a trip!"
|
|
daviep
|
posted on 9/4/10 at 10:29 AM |
|
|
Scary I just made a spreadsheet that does this yesterday.
It's actually for illustrating benefits of an offset account but it also does over payment.
Enter your data in the blue boxes, enter any overpayments into the colum Offset Credits (£500 is entered as an example)
The left hand colums show mortgage balance without over payment the right hand shows effects of over payment or offsetting.
Unfortunately you can't post attachments in the non-car chat section
I'll email if you want it
Davie
|
|
martinq357
|
posted on 9/4/10 at 01:44 PM |
|
|
Found this quite useful:
http://www.moneysavingexpert.com/mortgages/mortgage-calculator
HTH
Martin.
|
|