My Excel mortgage spreadsheet

18911131448

Comments

  • benjdr
    benjdr Posts: 219 Forumite
    Stu78 wrote: »
    I am getting a "the cell you are trying to change is protected" error when i try to put in manual over payments or extra borrowing.

    Is it possible that you inadvertantly protected all the cells, and not just the ones you need to protect?

    Cheers

    Stu.

    Hi Stu, this has already been discussed on page 2 of this thread.http://forums.moneysavingexpert.com/showpost.html?p=14185487&postcount=23
  • Hi Stu

    See the first post, you need Excel 2002 (XP) or later, otherwise Excel protects all the cells because it doesnt know how to cope with selective protection.

    cheers
    My Excel Mortgage Calculator Spreadsheet: http://forums.moneysavingexpert.com/showthread.html?t=1157173
  • Wow, what a spreadsheet! I have an offset mortgage and it showed that if I put £100 in there every month it would shave 10 years off the mortgage and reduce the interest by £60k over the term! Wow! What an incentive to get saving!
  • Just uploaded v1.6, its only a bug fix for the additional borrowing column which didnt work previously. Other than that, no more changes.

    http://www.locostfireblade.co.uk/Downloads/Mortgage%20Schedule%20Calculator%20v1.6.xls
    My Excel Mortgage Calculator Spreadsheet: http://forums.moneysavingexpert.com/showthread.html?t=1157173
  • Stu78
    Stu78 Posts: 25 Forumite
    benjdr wrote: »
    Hi Stu, this has already been discussed on page 2 of this thread.http://forums.moneysavingexpert.com/showpost.html?p=14185487&postcount=23

    My laziness showing through. :embarasse I skim read the first and last pages of the thread, but didn't bother with the middle pages!

    Thanks for the link, and thanks to Locoblade for your efforts.

    I will endevour to find a copy of Excel 2002/3/7 to run it on, or even try OOv3.

    Cheers

    Stu
  • great mortgage sheet, the best I have seen so far, thanks for your help and advice on other matters
  • britboi
    britboi Posts: 31 Forumite
    What a brilliant calculator. I just have one query though. How can I use it to analyse the repayment options on my flexible mortgage which is part interest-only and part capital & interest?
  • Hiya

    Basically what you have with a part-interest only and part repayment is an interest only where you're obliged to overpay a certain amount, but obviously not enough that it covers the capital entirely.

    If you have two seperate mortgage pots and you want to see the payments going off each seperately, the only way to do it really is put the interest only part in one, and the capital repayment part in the second mortgage page (and ignore the comparison page obviously).

    If its all in one pot you'd just put it in as interest only then manually set the monthly payment to whatever you pay now overall. You could actually do it this way even if you have seperate pots, just add up the total capital owed and add up the total repayment you pay each month and adjust the payment accordingly to see what overpayments will do. At the end of the day, regardless of how its shown by your bank and whether you pay one payment or two or overpay onto one or the other, an overpayment of x amount each month onto either side will have the same effect and reduce the capital by the same amount.
    My Excel Mortgage Calculator Spreadsheet: http://forums.moneysavingexpert.com/showthread.html?t=1157173
  • Good spreadsheet Locoblade!

    I noticed a small error in the comparison sheet - where the different mortgages have different introductory periods, it does not make a like for like comparison. E.g. it compares the total cost of the first 2 years of a 2 yr introductory offer in mortgage 1 to the first 5 years of mortgage 2, if that had a 5 yr offer etc.

    Perhaps you could change it to look at the average cost for the first 3 years or something, since many people will buy new products every 2 or 3 yrs.

    Keep up the good work!
  • I might have known someone with a nick "Mathsguy" would find an error :D

    I don't have access to it at work to check, but I thought I based the comparison on whatever length the intro rate was on the first mortgage, eg if Mortgage 1 was 2 years and Mortgage 2 was 5 years, it would compare the cost of both after 2 years, but I'll check later.

    cheers
    My Excel Mortgage Calculator Spreadsheet: http://forums.moneysavingexpert.com/showthread.html?t=1157173
Meet your Ambassadors

Categories

  • All Categories
  • 343K Banking & Borrowing
  • 250.1K Reduce Debt & Boost Income
  • 449.6K Spending & Discounts
  • 235.1K Work, Benefits & Business
  • 607.8K Mortgages, Homes & Bills
  • 173K Life & Family
  • 247.8K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 15.9K Discuss & Feedback
  • 15.1K Coronavirus Support Boards