Jason Posted February 15, 2009 Author Report Share Posted February 15, 2009 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? Many Thanks Jason, The Dark Knight The additional figures are inflation data. This was added by another member so I'm not the author of that part. The 'M' is confusing, so I'm not sure what that is. Quote Link to post Share on other sites
Hatchet Man Posted February 25, 2009 Report Share Posted February 25, 2009 The additional figures are inflation data. This was added by another member so I'm not the author of that part. The 'M' is confusing, so I'm not sure what that is. What does columns showing data such as "2.9%-M-1.0" as for example in November 2003 mean? Simple really. http://safalra.com/other/historical-uk-inf...ice-conversion/ Hi ho hi ho a little do we know, why the UK people are kidded and taken for a ride. Quote Link to post Share on other sites
Jason Posted March 6, 2009 Author Report Share Posted March 6, 2009 Spreadsheet updated with 0.5% rates (5th March 09) on first post. http://www.bankofengland.co.uk/publication...ws/2009/019.htm Quote Link to post Share on other sites
Charlie The Tramp Returns Posted June 25, 2009 Report Share Posted June 25, 2009 Even with the very low IRs simple average is still slightly over 9%. Watch, listen, and learn during the next 36 months. Quote Link to post Share on other sites
MELANIE Posted October 30, 2009 Report Share Posted October 30, 2009 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 Quote Link to post Share on other sites
MELANIE Posted October 30, 2009 Report Share Posted October 30, 2009 Spreadsheet updated with 0.5% rates (5th March 09) on first post. http://www.bankofengland.co.uk/publication...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 Quote Link to post Share on other sites
Jason Posted November 4, 2009 Author Report Share Posted November 4, 2009 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. Quote Link to post Share on other sites
barrybert Posted May 18, 2010 Report Share Posted May 18, 2010 Thanks to Charlie the Tramp for adding in additional information! Resume Writing Services Quote Link to post Share on other sites
Johnkarner Posted June 17, 2011 Report Share Posted June 17, 2011 A most useful data set. Thank you for sharing i keep sharing More detail Quote Link to post Share on other sites
Haribol2332 Posted December 1, 2013 Report Share Posted December 1, 2013 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? Quote Link to post Share on other sites
Thatcherschild Posted February 9, 2017 Report Share Posted February 9, 2017 We live in interesting times. Inflation is nudging up, for a variety of different reasons, and conservative forecasts are of inflation of 3 or 4% at some point in 2018. In other words, comfortably above the BoE target. It would be really helpful if admin could update the CPI and RPI graphs on this site. I have used this site, which used to be excellent in its heyday, as a resource for economics data and interesting HPC articles and viewpoints. However, it has become run down and it's a real shame. Admin, could you help? Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.