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.

📨 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!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide

excel mortgage calculator

Hi - a few years ago I downloaded an excel spreadsheet someone shared on here where you could punt your figures in and it would let you know all the things you might need to know re your mortgage - I cannot for the life of me find it now and wanted to do some comparisons. Does anyone know the file I'm talking about? I've tried other calculators but none come close - I think it may have been created by a forum member?

Many thanks!

Comments

  • silvercar
    silvercar Posts: 50,510 Ambassador
    Part of the Furniture 10,000 Posts Academoney Grad Name Dropper
    I'm a Forum Ambassador on the housing, mortgages & student money saving boards. I volunteer to help get your forum questions answered and keep the forum running smoothly. Forum Ambassadors are not moderators and don't read every post. If you spot an illegal or inappropriate post then please report it to forumteam@moneysavingexpert.com (it's not part of my role to deal with this). Any views are mine and not the official line of MoneySavingExpert.com.
  • silvercar
    silvercar Posts: 50,510 Ambassador
    Part of the Furniture 10,000 Posts Academoney Grad Name Dropper
    I’m guessing it was this one that you saw previously:

    https://forums.moneysavingexpert.com/discussion/1157173/my-excel-mortgage-spreadsheet/p1

    The spreadsheet link is on the first post on that thread.
    I'm a Forum Ambassador on the housing, mortgages & student money saving boards. I volunteer to help get your forum questions answered and keep the forum running smoothly. Forum Ambassadors are not moderators and don't read every post. If you spot an illegal or inappropriate post then please report it to forumteam@moneysavingexpert.com (it's not part of my role to deal with this). Any views are mine and not the official line of MoneySavingExpert.com.
  • tacpot12
    tacpot12 Posts: 9,501 Forumite
    Tenth Anniversary 1,000 Posts Name Dropper
    edited 28 October 2025 at 9:49AM
    Excel also comes with a Loan Amortization template which can be used for mortgage calculations. It's results match the Nationwide Mortgage illustrations exactly because I was looking at these on Sunday fro my step-son.
    The comments I post are my personal opinion. While I try to check everything is correct before posting, I can and do make mistakes, so always try to check official information sources before relying on my posts.
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
  • 353.6K Banking & Borrowing
  • 254.2K Reduce Debt & Boost Income
  • 455.1K Spending & Discounts
  • 246.6K Work, Benefits & Business
  • 603K Mortgages, Homes & Bills
  • 178.1K Life & Family
  • 260.7K 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.