Overpayment calculator - here

mirry

when they ask for the loan amount info ,

should I put the amount of the original loan , or the balance as of today .

sorry if its a silly question .

StuartGMC

Enter the amount remaining and the remaining term to see "what's left"
HTH

Stuart

border_collie

just noticed a funny thing, I put a random 20 quid extra in and it gave me the saving. I then doubled it to 40 then doubled it to 80 and each time the amount saved was LESS than doubled. If that makes sense.

Was wondering if I should pay 80 off each part of my mortgage, it is three parts, instead of the 250 I was planning on paying off one part.Will this be a very clever trick or have I done something wrong?

plzhelpmesave!

just figured out we need to overpay £8000 a month to finish mortgage in 1 year! wow - better get saving then as haven't managed to overpay a penny yet!!

Locoblade

Hi All

Ive just posted this on the Mortgage forum as that's where I mostly frequent, but I thought it might be worth posting my Excel mortgage calculator here too seeing as this is a thread full of them, as it does do several things that some/most of the others don't seem to take into account, such as

• Interest only / capital repayment mortgages with option to part pay
• Offset mortgages, including average offset current account balance
• Calculation when offset pot could pay off the mortgage remainder.
• Monthly and one off overpayments / offset payments
• Change of rates after introductory period expires
• Ad-hoc rate changes for variable/tracker mortgages
• Additional borrowing at any time
• A few pretty graphs

Full details here:
http://forums.moneysavingexpert.com/showthread.html?t=1157173

cheers

youngmcc

Hi

Does anyone have a good tracker mortgage calculator for making repayments and keeping a track of my payments as interest rates change?

Thanks

Locoblade

Have you looked at my spreadsheet above, you can edit the interest rates for each month rather than just setting it at the start.

youngmcc

Locoblade wrote: »

Have you looked at my spreadsheet above, you can edit the interest rates for each month rather than just setting it at the start.

Excellent mate. By far the best out there.

Just what I need, however, how do I unprotect the sheet to put in my ad-hoc interest rate etc.

Locoblade

youngmcc wrote: »

Excellent mate. By far the best out there.

Just what I need, however, how do I unprotect the sheet to put in my ad-hoc interest rate etc.

You need Excel 2002 or newer, I suspect you've got Excel 2000 or earlier, or are using open office? The way it's written the cells you need to edit are editable in Excel 2002 or newer whilst the rest of the cells are protected, but it seems the old version of Excel etc doesn't support that, it just protects the whole sheet and ignores the exceptions Ive put in to allow certain editable cells.

When I get time I'll see if I can do a "creaky old Excel" compatible version

youngmcc

Locoblade wrote: »

You need Excel 2002 or newer, I suspect you've got Excel 2000 or earlier, or are using open office? The way it's written the cells you need to edit are editable in Excel 2002 or newer whilst the rest of the cells are protected, but it seems the old version of Excel etc doesn't support that, it just protects the whole sheet and ignores the exceptions Ive put in to allow certain editable cells.

When I get time I'll see if I can do a "creaky old Excel" compatible version

Im using Excel 2003 and having no luck editing the cells.

Any chance you can PM me the password or send me through an unprotected version?

Thanks alot
Keep up the good work