My Excel mortgage spreadsheet

kazd

Locoblade wrote: »

Does anybody actually read the instructions or comments in the first post?

I did read it honest I did, I was certain I had the right copy of Excel but have just taken another look and realised we are using the older version that is not supported on the spreadsheet.

Locoblade

No worries, it was only a light hearted dig, its just that question has probably been asked about 20 times either on here or via PM

cheers

mark55man

Hey Loco

Thanks very much for by far the best mortgage spreadsheet I have used (and I have used a few).

I did read the instructions and I don't have any comments other than a thank you.

Possibly unusually with 14 years left I have been mucking around with the years repayment figure - very illuminating. My debate is between a 5 year fix or 10 year fix - leaving only small interest for last few years and thus less bopthered about rates then.

In the short term nowhere near as much upside on the tracker, and a lot of downside (but I guess that's the subject for another thread).

Thinks - if only I could be told if the SVR was going to average more or less than 6.5% in 5 -15 years time!!

dazzaofdagenham

_dave_ wrote: »

Looks like it might drop to around £920, if base stays at 1.5% :-

http://calc-calc-calc.net/get/calc/Mortgage-Comparison/v1/?L=155650&I1=6.59&Yrs1=1.5&SVR1=3.49&Term1=20&Yrs2=19.99999&SVR2=6.59

[I entered 155,650 to get your monthly payment of 1169, for better comparison...]

HTH!

any chance of working it out for me now ?

Looks like i will be paying base rate 0.5% + 1.99% premium...

darren

_dave__4

dazzaofdagenham wrote: »

any chance of working it out for me now ?

Looks like i will be paying base rate 0.5% + 1.99% premium...

darren

Looks like it might be around £842 each month - that's down £327 from £1169!

http://calc-calc-calc.net/get/calc/Mortgage-Comparison/v1/?L=155650&I1=6.59&Yrs1=1.5&SVR1=2.49&Term1=20&Yrs2=19.99999&SVR2=6.59

dazzaofdagenham

_dave_ wrote: »

Looks like it might be around £842 each month - that's down £327 from £1169!

http://calc-calc-calc.net/get/calc/Mortgage-Comparison/v1/?L=155650&I1=6.59&Yrs1=1.5&SVR1=2.49&Term1=20&Yrs2=19.99999&SVR2=6.59[/quote]


Thank you for that.

A nice saving each month of £300+

Lets get the economy moving my spending it all......


Darren

cake21

Thank you very much Loco :T:T

mikehollywood

Great spreadsheet!! Is there any way of adding indexation as a way of overpayment.

Also could the graph show months ans show original line as well as new and also include saving on the same page.:j

Kittikins

Thank you for this, it's fabulous, just what my non-techy brain was looking for and wasn't able to work out for myself (you're a genius!!)
. I'm hoping to start overpaying my mortgage soon (once I've got my 3 months' bills savings under my belt and ensure I stop wasting money on "stuff" every flipping month!)

Locoblade

mikehollywood wrote: »

Great spreadsheet!! Is there any way of adding indexation as a way of overpayment.

Also could the graph show months ans show original line as well as new and also include saving on the same page.:j

Hi Mike

Sorry I missed this question originally. I assume by indexation you mean rising overpaypayments linked to an inflation rate? If so, you could put in a calculation into the cell yourself. For example in the first monthly overpayment cell (cell M12 on Mortgage 1 Monthly Table sheet) put in say £100 as your initial overpayment. In the cell below (month two), rather than typing in another number, type in "=M12+M12*(5%/12)". This example uses a 5% annual inflation rate divided by 12 to give a monthly rate to inflate the second value slightly (in this case it will give a value of £100.42), so obviously change the 5% value to the one you want to use. Now just highlight the second cell, hover over the bottom right corner until the cursor goes to a + sign, then drag down to the bottom of the spreadsheet and the monthly payments will be recalculated and increased based on the equation, so month 3 will be £100.84 etc etc. Sorry if this amount of detail is teaching you to suck eggs

As for the graphing, if I do another version then I'll try and remember to plot the original line as well, but dont hold your breath as I've got loads on at the moment (DIYing a new kitchen/bathroom, baby arriving in July, etc etc!) so the spreadsheet is pretty much as developed as its going to get, for a while at least. The graphs I put in don't show months because they'd crowd the sheet too much, the graphs are only there as a rough guide to see what the loan is doing rather than for reading accurate figures from, so that level of granularity isnt really of any value on such a small formatted graph. If you wanted to plot your own larger graphs though you could do that yourself as well, just open a new spreadsheet with the mortgage one also open and plot the graphs you want in the new spreadsheet using data highlighted in the original spreadsheet.

cheers