The Mortgage Free in Three - Take 2 challenge (MFiT-T2)

financialbliss

Daisy_Duck wrote: »

Thanks

How do you equate these figures into percentages? Am I being daft lol?! They are in the 5 hundreds... what do I do next?

Thanks for your help! :beer:

HPI.
I’ve created a little example HPI image. This is a small excel sheet that I’ve simply copied from Excel, pasted into Paint, saved as an image and uploaded to photobucket.

The values in the sheet are my own theoretical house values for January to March 2010.

I’ll try and explain the most important cells.



Rows 2 and 3, plus columns A and B are just titles, so should be fairly obvious. Column ‘C’ is the house price index (HPI) data, from your preferred source.

Cell D6 – Difference in HPI (in numbers) from one month to next.
Formula: =C6-C5 then replicated downwards.

Cell E6 – Percentage difference in HPI. Cell formatting expressed as a percentage.
Formula: =(D6/D5)-1

Cell H6 – Value. Cell formatting expressed as a number to 2DP with thousands separator.
Formula: =INT(H5*E6*100)/100+H5

Cell J6 – Difference in value – calculating comparison of current price against 200k purchase price. Excpressed as a percentage.
Formula: =(H6/200000)-1

Cell L6 – Average mortgage value for month. Own average mortage for the month. Data entered directly – no formula.

Cell M6 – Loan to value (LTV). Expressed as a percentage.
Formula: =L6/H6

The row formulas are then replicated downwards from that entered in January, so that the remainder of the year can be calculated.

Hopefully, there's no errors in there, as I've literally just quickly created a blank sheet, plus attempted to point out the more important cells. Easy enough to follow?

FB.

curlygirl1971

FB, I just love what you do with spreadsheets! What else you got?

I've got a Mortgage OP one. I have one that tracks all my savings balances. I've got one that tracks spending / forecasts cash against budgets. I've got monthly net worth now with HPI And I've got graphs running off all of these. If I could have a spreadsheet with lights and bells on it I probably would.

Am I missing something from my sad/geeky/obsessive portfolio of spreadsheets?

cazmanian_minx

£564.29 paid off today - slowly but surely moving in the right direction again!

Daisy_Duck

financialbliss wrote: »

HPI.
I’ve created a little example HPI image. This is a small excel sheet that I’ve simply copied from Excel, pasted into Paint, saved as an image and uploaded to photobucket.

The values in the sheet are my own theoretical house values for January to March 2010.

I’ll try and explain the most important cells.
FB.

Wow, you are a star! Thank you so much for going to so much trouble :A

Will take a good look at it all when I get home and see if I can follow in your footsteps!

DD

shangaijimmy

At last we've crept under the 155k mark (only a week behind schedule). Big target that was for us, so the next one is to get under 150k and the target is November!!

THRIFTY_GIRL

shangaijimmy wrote: »

At last we've crept under the 155k mark (only a week behind schedule). Big target that was for us, so the next one is to get under 150k and the target is November!!

Well done:beer:

cake21

Well done everyone!! :beer:

Just popped in to say I am having an absolutely fantastic day here in the rain:

1. BMI finally down to below 25 :j
2. Unexpected work-related praise :j
3. Green party finally won a seat :j
4. Letter arrived from Coop - mortgage now below £100k!!! :j:j:j

Hope everyone has a great weekend. So excited!!!!!

setmefree2

cake21 wrote: »

1. letter arrived from Coop - mortgage now below £100k!!! :j:j:j

Hope everyone has a great weekend. So excited!!!!!

Nice milestone

curlygirl1971

The base rate has held!!! DING DONG

financialbliss

curlygirl1971 wrote: »

The base rate has held!!! DING DONG

Hi curlygirl,

Yeah - I've just published two links to BBC and TiM in my diary regarding the base rate being held. Odd that it's been published today - due to election perhaps as it's normally the first Thursday of the month.

FB.