Jump to content


Photo

Historic Interest Rates, Historic Average


  • Please log in to reply
31 replies to this topic

#31 MELANIE

MELANIE

    HPC Newbie

  • New Members
  • Pip
  • 2 posts

Posted 30 October 2009 - 04:33 PM

Spreadsheet updated with 0.5% rates (5th March 09) on first post.

http://www.bankofeng...ws/2009/019.htm



Posted Today, 04:30 PM

Hi Jason
I am new to all of this and have looked at the spreadsheet with interest
i want to be able to calculate what 30,000 would be worth at October 2008 if I had invested it in August 2005
Assuming interest is compounded quarterly

Am i right that - according to your spreadsheet - the average interest is 5.14663
Thus 30000 x (1=(5.14663%/4))^(4*3)
ie based on the A=P(1+r/n)^nt formala

- or have I got it all confused?

Any clarification is gratefully appreciated
Thanks
Mel

#32 Jason

Jason

    HPC Vindicated

  • Moderators
  • PipPipPipPipPipPipPip
  • 7,593 posts
  • Location:South East - FTBer

Posted 04 November 2009 - 01:25 PM

Hi Jason
I am new to all of this and have looked at the spreadsheet with interest
i want to be able to calculate what 30,000 would be worth at October 2008 if I had invested it in August 2005
Assuming interest is compounded quarterly

Am i right that - according to your spreadsheet - the average interest is 5.14663
Thus 30000 x (1=(5.14663%/4))^(4*3)
ie based on the A=P(1+r/n)^nt formala

- or have I got it all confused?

Any clarificationis gratefully appreciated
Thanks
Mel


You're testing me now... The average is 5.14663, between 04aug05 and 07oct08 so your forumla should work fine. However, only use it as an estimate.

To be accurate you would need to work out the average for each 12month period (assuming annual interest) and compound that way.

Hope that helps, I haven't looked at the spreadsheet for such a long time. I originally did it as posters kept saying average rates are 'x' and not backing it up.
House Price changes
NO LONGER UPDATED.

----------------------- Peak ---------- Trough -(% trough fall) - Current - (% from peak) - (% from Trough)
Halifax: -------------- Aug07 199,612 - Apr09 154,490 (-22.60%) - Oct09 165,528 (-17.08%) - (+07.14%)
Nationwide: ----------- Oct07 186,044 - Feb09 147,746 (-20.59%) - Oct09 162,038 (-12.90%) - (+09.67%)
Rightmove: ------------ May08 242,500 - Jan09 213,570 (-11.93%) - Nov09 226,440 (-06.62%) - (+06.03%)
DCLG (formerly ODPM): - Jan08 221,758 - Mar09 187,193 (-15.59%) - Jul09 196,338 (-11.46%) - (+04.89%)
Land Registry (Mth): -- Nov07 186,009 - Apr09 152,803 (-17.85%) - Sep09 158,377 (-14.86%) - (+03.64%)
FT HPI: --------------- Feb08 231,804 - Apr09 199,953 (-13.74%) - Aug09 205,338 (-11.42%) - (+02.69%)
Land Registry (Qtr): -- Q307 230,474 -- Q109 198,939  (-13.68%) - Q209 224,064  (-02.78%) -- (+12.63%)

Topic Link: http://www.housepric...howtopic=127421
Links: Halifax, Nationwide, Rightmove, Land Registry (monthly), Land Registry (Raw data - Quarterly).
____________________________________________

Read what the papers said during the last crash: Here.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users