Mortgage spreadsheet wanted

pstones578

Does anyone know of any mortgage calculator spreadsheets that will let me enter variable interest rates and variable overpaymwents through the life of the mortgage and it will show me what effect that will have on how many months I don't have to pay at the back end of the mortgage?

Rob_K

Not sure about variable overpayments, but you can do variable interest rates on the Smile mortgage calculator..

Hope this helps in some way!

Rachman_2

This is a pretty good one. Very adjustable and presents the information in graphics and numbers.


http://www.jeacle.ie/mortgage/uk/

gallygirl

Peter, if you, or anyone else, PM me with your email address I'll send you a spreadsheet I've got.

It doesn't have pretty colours , and you need to drag down changes to mortgage rate etc, but you can put as many additional payments in as you want and if you scroll down (a long, long way :eek: ) you can see when it will be paid off.

sijones_2

Peter

I downloaded a mortgage spreadsheet which allows you to enter overpayments, and has a summary box describing how much time and money you have saved on your mortgage with these overpayments being made.

As im new i cant post links but you can get the spreadsheet from mortgagerunner.co.uk/tools

hope this helps

regards

simon

financialbliss

Hi,

There's a spreadsheet hidden in my diary. Info here:

Monthly mortgage reduction spreadsheet.
See post no's 534 and 536 linked directly below:
http://forums.moneysavingexpert.com/...&postcount=534
http://forums.moneysavingexpert.com/...&postcount=536

Post 534 explains how to create it, while post 536 shows an image of the sheet.

FB.