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.
My Excel mortgage spreadsheet
Comments
-
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.0
-
Great tool and easy to use.
Thanks Locoblade! :T0 -
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
My Excel Mortgage Calculator Spreadsheet: http://forums.moneysavingexpert.com/showthread.html?t=11571730 -
Locoblade
Any chance you could provide a current link to version 1.4
cheers0 -
The link is on the first postI am a Mortgage AdviserYou 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.0
-
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.xlsMy Excel Mortgage Calculator Spreadsheet: http://forums.moneysavingexpert.com/showthread.html?t=11571730 -
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 months0 -
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!0
-
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.0 -
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?'0
Confirm your email address to Create Threads and Reply

Categories
- All Categories
- 348.2K Banking & Borrowing
- 252.1K Reduce Debt & Boost Income
- 452.4K Spending & Discounts
- 240.8K Work, Benefits & Business
- 617K Mortgages, Homes & Bills
- 175.6K Life & Family
- 254K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 15.1K Coronavirus Support Boards