My Excel mortgage spreadsheet

Locoblade

grn.w.nv wrote: »

Thanks so much for this Locoblade. I got the link from the MFW board, I'm 6 months into my first mortgage. The spreadsheet is so handy and informative, though I havea question about it. On the key figures sheet input 11 'manual input initial month payment' has a n/a next to it. I can't change it, so when I go to the monthly table I can't alter monthly overpayments, they're just stuck at one figure.

Can you help me out?

Thanks again!

Sorry I missed this one originally, you may have worked this one out by now but to edit option 11 you need to set option 10 to "Manual". It's N/A when option 10 is set to "Calculated" because when the spreadsheet is calculating your montly payment for you, obviously it doesn't need/want an input from you.

cococoladebt

Thanks v. much... That has actually worked. It's a very good calculator.

whitedot

Just wanted to add my thanks for this spreadsheet. First time buyers and it's very useful.

Cheers.

de1amo

Thanks for the spreadsheet--i am new to these things and finding difficulty! my mortgage is 55k and i pay 2pc svr therefore 92 quid approx but the spreadsheet seems to want to make it 50.1 quid and i cant seem to override it manually--its int only!

Locoblade

de1amo wrote: »

Thanks for the spreadsheet--i am new to these things and finding difficulty! my mortgage is 55k and i pay 2pc svr therefore 92 quid approx but the spreadsheet seems to want to make it 50.1 quid and i cant seem to override it manually--its int only!

Can you post up or email me more details so I can put the figures in and try and work out whats going on. As well as the above I need the length of the mortgage and when it was taken out, plus what options you've selected on the main page.

eddiemacthedog

Fantastic tool. cheers!

sharmav

Hi
That was an excellent spreadsheet.

Is is possible to do daily interest calculations with data from midway in a mortgage period for a few months.

In other words if there was a facility to put in dates instead of days one could copy data from a bank statement of offsetting account and occasional withdrawals and deposits to come up with the end of the month interest for the mortgage account.

regards

Locoblade

Hi

I'm afraid not, daily calculations are several orders of magnitude more complicated as Excel has no inbuilt function to calculate it unlike the basic monthly, so if you try to do it manually there's obviously around 30 times more calculations to do then you get different days in the month and leap years etc that need to be taken into consideration and what's otherwise a simple one line equation suddenly becomes ridiculous. When I first started I did try but all the equations just gets way too complicated and long.

chichee

Thank you very much! Really clear and easy to use!

GregH

Thank you very much!

I have used this spreadsheet for a few years now and it is excellent for keeping track of my mortgage.

I make extra payments as and when i can and add them into the monthly overpayment column, but, with your new V10 it doesn't seem to calculate the interest amount saved, i've not had this issue with previous versions.

Regards