We’d like to remind Forumites to please avoid political debate on the Forum.

This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

The MSE Forum Team would like to wish you all a very Happy New Year. However, we know this time of year can be difficult for some. If you're struggling during the festive period, here's a list of organisations that might be able to help
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Has MSE helped you to save or reclaim money this year? Share your 2025 MoneySaving success stories!

My Excel mortgage spreadsheet

1…5681011…48

Comments

  • sleepless_saver
    sleepless_saver Posts: 2,741 Forumite
    Part of the Furniture
    Great spreadsheet, many thanks. I can use it on OpenOffice 1.3 with no apparent problems so far. I had to remove the protection on the monthly sheet to be able to change figures but that is all.
  • uzubairu
    uzubairu Posts: 1,209 Forumite
    Part of the Furniture 1,000 Posts Combo Breaker Home Insurance Hacker!
    Great tool and easy to use.

    Thanks Locoblade! :T
  • Locoblade
    Locoblade Posts: 795 Forumite
    Part of the Furniture 500 Posts Name Dropper
    Version 1.4 just uploaded, this might be the last for a bit as I think there's a danger it could become too complicated to use in its current guise if I add much more.

    This one adds the following:
    • Comparison for savings account/ISA against offset/overpayments on Mortgage 1
    • Comparison of two mortgages with differing fees added to loan, showing break even month
    • Seperated out fees added to loan
    Ive also realised that the fairly conservative colour scheme I chose in Excel 2007 gets converted into a rather painful colour scheme in Excel 2003, so although Ive not changed the colours, I have allowed editing of the formats so you can pick your own if you find it really offensive :D
    My Excel Mortgage Calculator Spreadsheet: http://forums.moneysavingexpert.com/showthread.html?t=1157173
  • tightasaduckas
    tightasaduckas Posts: 3 Newbie
    Locoblade

    Any chance you could provide a current link to version 1.4

    cheers
  • herbiesjp
    herbiesjp Posts: 8,499 Forumite
    The link is on the first post
    I am a Mortgage Adviser
    You should note that this site doesn't check my status as a Mortgage Adviser, so you need to take my word for it. This signature is here as I follow MSE's Mortgage Adviser Code of Conduct. Any posts on here are for information and discussion purposes only and shouldn't be seen as financial advice.
  • Locoblade
    Locoblade Posts: 795 Forumite
    Part of the Furniture 500 Posts Name Dropper
    tightasaduckas wrote: »
    Locoblade

    Any chance you could provide a current link to version 1.4

    cheers

    Sorry, yep I updated the first post but meant to put it in the new post too

    http://www.locostfireblade.co.uk/Downloads/Mortgage%20Schedule%20Calculator%20v1.4.xls
    My Excel Mortgage Calculator Spreadsheet: http://forums.moneysavingexpert.com/showthread.html?t=1157173
  • BARGAINHUNTER!
    BARGAINHUNTER! Posts: 848 Forumite
    Wow! What an amazing spreadsheet and totally addictive! I have just spent the last half hour playing around with it! Thank you so much for developing it and sharing it with us!
    MFW 2011 challenge - Aim: Overpay £414.26 a month/£5,000 a year. Overpayment Total to date: £414.26:jMortgage start 28/9/07 £46,217.00 :TMortgage balance as of 25/05/11 £24,490.58 :T
    Interest saved as of 25/05/11: £2,849.84 Projected term reduction as of 25/05/11: 9 years 11 months
  • beniamino
    beniamino Posts: 56 Forumite
    Part of the Furniture 10 Posts Combo Breaker
    This looks really useful. Would you mind releasing a version with all cells unlocked for editing? The locking doesn't seem to work properly on Mac Office 2008, so it's not possible to edit the yellow columns. Thanks!
  • excited
    excited Posts: 21 Forumite
    Locoblade, Thanks for making the calculator available, Can I ask say i want to make a one off payent do i jut lower the mortgage amount.

    thanks
    excited.
  • Kavanne
    Kavanne Posts: 5,093 Forumite
    Thanks to your new sheet I can see how even £200 a month overpayments on my mortgage would shave off 2 yrs!! MF in 16 yrs here I come lol!!
    Kavanne
    Nuns! Nuns! Reverse!
    'I do my job, do you do yours?'
★ ★ ★ Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 353K Banking & Borrowing
  • 253.9K Reduce Debt & Boost Income
  • 454.8K Spending & Discounts
  • 246K Work, Benefits & Business
  • 602.1K Mortgages, Homes & Bills
  • 177.8K Life & Family
  • 260K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16K Discuss & Feedback
  • 37.7K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.
Update Your Picture