Jump to content


Photo

Historic Interest Rates, Historic Average


  • Please log in to reply
34 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,616 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.

#33 barrybert

barrybert

    HPC Newbie

  • New Members
  • Pip
  • 10 posts

Posted 18 May 2010 - 06:37 AM

Thanks to Charlie the Tramp for adding in additional information!


Resume Writing Services

#34 Johnkarner

Johnkarner

    HPC Newbie

  • New Members
  • Pip
  • 1 posts

Posted 17 June 2011 - 08:00 AM

A most useful data set. Thank you for sharing i keep sharing More detail

#35 Haribol2332

Haribol2332

    HPC Newbie

  • New Members
  • Pip
  • 1 posts

Posted 01 December 2013 - 04:23 PM

This looks like a great set of data, but being new here, I'm a little confused as to the terminology.

What does columns showing data such as "2.9%-M-1.0" as for example in November 2003 mean?

I take it M represents the inflation adjusted value of sterling at the time - ie in November 2003 a pound is worth the same as it is now?

What does the 2.9% represent, is this the average mortgage rates margin over base rate?

Are average mortgage rates shown as fixeds or SVR? If fixed what length of fixed?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users