Re: Recalc needed for successive years

[Mr Warwick]

Thanks for your sample spreadsheet Savings.xls which I am starting to
understand. One question.

At the bottom there are three tabs labelled in the original master
spreadsheet Sheet 1, Sheet 2, Sheet 3. You have relabelled these 2005, 2006,
2007 and I understand why. This will do mef for three years. But I want the
programme to predict *30* years ahead. How do I do this; do I complete
another worksheet with formulas referring back to the first sheet, or what?
Grateful advice.

Mr W



"Mr Warwick" <[email protected]> wrote in message
news:[email protected]...
> Thanks, will reflect
>
> Mr W
>
>
> "cheesey_toastie" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >
>
>

[cheesey_toastie]

I would create a sheet (copying the last) 30 or however many times you
wish. So a sheet for 2008, 2009 ... 2029, 2030. If however you are
just trying to get the final calculation then this isn't necessary I
just assumed that at the end of each year you wanted a review of the
year. Also your expenditure, interest rates, savings etc are all
variables that may change from year to year and this could then be
adjusted whilst keeping the history.

Hope the helps.