You wouldnt need to programme anything.

Simply create a new workbook.

In column A put weeks 1-52.

Col B put your income from your pension
Col C put a formula that looks at the amount in your savings and
calculates your monthly interest payment (e.g. in col C =F1*0.05/52)
where F1 is the cell that has your current savings balance, 0.05 = 5%
annual interest and 52 is the number of weeks in a year).
Col D put in your expenditure (as a minus figure).
Col E put = SUM(A2:E2).

At the bottom of Col E put a sum formula e.g. =sum(E2:E53)

This would be your first sheet. Then copy this sheet, name it as next
year... change the entry in the savings amount to equal a formula that
says =2005!E53+2005!F1

Now copy this sheet and rename it 2007, 2008, 2009 etc etc changing
the formula in teh savings cell (F1) to be the result of hte sum in E54
+ F1 from sheet 2005.

I've emailed you a start,... note it needs formatting etc.

This solution would be oversimplified as it assumes that you don't earn
any interest from any money you have left each month.. but as a rough
guide would do.

The only thing programming would help in is to reduce the mundane task
of copying the sheet and changing the formula....

Hope this helps