OverPayment Calculator

keith.bucknall

All,

I am starting to make regular OP's on my SVR with Alliance and Lester, the amount will differ from month to month, so I was going to put the money into an account and every 3 months back off a lump sum.

My question is that I would like to track this and see how my payments are having a positive effect on the mortgage, does anyone know of how to create this in excel or have any templates or software I can use / buy.

Many thanks

Keith

typeractive

Here's a mortgage overpayment calculator. It's pretty handy. I dare say it is possible to recreate a similar item in excel, there is a PMT formula (google it), that will help give a figure for an amount of money paid over a period of time against a percentage. It might be a bit fiddly with your rate adjusting each month, however this might give you a few ideas whilst you're researching:

Link

Good luck!

Mrs_Bumble

Here is quite a clear one

http://whatmortgage.co.uk/calculators/fleximortgage.html

keith.bucknall

thanks guys, but was looking for an off line version.

Cannon_Fodder

Download of a workbook here http://www.thismuchiknow.co.uk/?p=42

Haven't used it myself, but has comments that says its ok.

jamesperrett

There was also one at

http://www.locostfireblade.co.uk/Downloads/Mortgage%20Schedule%20Calculator%20v1.7.xls

which was the subject of a thread here a few weeks ago.

Cheers

James.

samnorris2

Cannon_Fodder wrote: »

Download of a workbook here http://www.thismuchiknow.co.uk/?p=42

Haven't used it myself, but has comments that says its ok.

This is the one I have been using and it's excellent.