you're saying that an annual rate of 6.5% is 0.125% weekly? If you are, either you're wrong or the UK Government is wrong! They state that 6.5% pa is 0.1212% pw. And I've just realised that the reason for the difference is that 7 x 52 = 364. There are 365 days in a year - in fact 365.25 accounting for leap years. I didn't ask for an approximate weekly rate. My calculation covers a period of 10 years at interest rates between 0.5% and 5.75% (bank base rate) so approximately won't do. Jennie

I am sending you the excel sheet which showing the rate calculated as needed by you, now you can find many rates by just chnages the bank base rate for 0.5% use 1.005 and for 5.75% use 1.0575