Need Some Help Regarding Overpayment Facility

[LittleSteroid]

Hi. I am thinking about taking on a mortgage. 10 years fixed with overpayment facility. The only problem is I can't find a tool (spreasheet?) which could help me to calculate how much would my capital change thus my monthly repayments if I was to pay couple of hundreds quid more a month. Can someone post a link? Thanks.

[EmmaRoid]

Have a play with this

http://www.drcalculator.com/mortgage/uk/

[LittleSteroid]

Have a play with this

http://www.drcalcula...om/mortgage/uk/

this is it! thanks man!

[EmmaRoid]

Also should be available as an app on your preferred smartphone platform.

[fatsam]

http://www.bankrate.com/calculators/mortgages/amortization-calculator.aspx

This is also a handy calculator, allows you to see what you have paid off at different points.

Edit: May be he same as the above calculator, was unable to check due to java issue.

Edited May 15, 2011 by fatsam

[SaintJay]

there's a free download in excel - in the search box type' loan amortisation' and a template appears - fill in the boxes and it does it all for you.