My Excel mortgage spreadsheet

1394042444548

Comments

  • Mr_Black
    Mr_Black Posts: 23 Forumite
    First Post First Anniversary Combo Breaker
    I see! ha thanks for helping me out, quite clearly I'm a bit of a biff.
  • Locoblade
    Locoblade Posts: 795 Forumite
    Name Dropper First Post First Anniversary
    No worries, I could just publish the compatibility version really but it's got extra hidden sheets to compensate so it's quite a bit bigger file size and not quite as pretty.
    My Excel Mortgage Calculator Spreadsheet: http://forums.moneysavingexpert.com/showthread.html?t=1157173
  • Mr_Black
    Mr_Black Posts: 23 Forumite
    First Post First Anniversary Combo Breaker
    Locoblade wrote: »
    No worries, I could just publish the compatibility version really but it's got extra hidden sheets to compensate so it's quite a bit bigger file size and not quite as pretty.

    Would you mind emailing me that please?
  • Locoblade
    Locoblade Posts: 795 Forumite
    Name Dropper First Post First Anniversary
    It's on the website, right next to the regular download!
    My Excel Mortgage Calculator Spreadsheet: http://forums.moneysavingexpert.com/showthread.html?t=1157173
  • always29
    always29 Posts: 477 Forumite
    Locoblade, thank you for this spreadsheet, it is truly awesome. I've just downloaded and working out how to pay my mortgage off by the time husband and I are 50. I think we might have to sell a kidney each or something ;) but it's great to play with the figures!
  • ellie27
    ellie27 Posts: 1,097 Forumite
    First Anniversary First Post Combo Breaker
    Thanks for the spreadsheet! It is great.

    I would be looking to make a lump sum overpayment every year or so, is there anywhere I can input that to see how it changes things? I see there is a monthly overpayment but it was going to be a lumpsum each year perhaps.

    Thanks!
  • Locoblade
    Locoblade Posts: 795 Forumite
    Name Dropper First Post First Anniversary
    Hi

    Thanks, yep just go into the "Mortgage 1 Monthly Payment" page and put the lump sum in the "Monthly Overpayment" column on the month you want it to be paid, then scroll down and repeat for subsequent years leaving all other months as zero :)
    My Excel Mortgage Calculator Spreadsheet: http://forums.moneysavingexpert.com/showthread.html?t=1157173
  • ellie27
    ellie27 Posts: 1,097 Forumite
    First Anniversary First Post Combo Breaker
    Wow, its amazing how much a lumpsum payment every now and again can make in the amount of interest you will have paid by the end of the mortgage! Thanks! :beer:
  • Kudos for such a great tool!

    I have a question - is there a recommended way to update the sheet with the "actuals" from the mortgage payments that the bank takes every month, in case the values aren't always correct 100%?
    Thanks for your help!
  • Locoblade
    Locoblade Posts: 795 Forumite
    Name Dropper First Post First Anniversary
    Hi

    You could adjust it in the monthly detailed section, not directly in the start/end balance but say it was £5 over your actual, you could put -5 in the monthly overpayment or 5 in the additional borrowing to bring the end balance back in line.
    My Excel Mortgage Calculator Spreadsheet: http://forums.moneysavingexpert.com/showthread.html?t=1157173
Meet your Ambassadors

Categories

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