Incresing % per annum

[Guest]

Hi
could anyone help, how would I get a cell containing a total figure to
increase by 5% per annum, thanks

 

[Guest]

Let's say your total figure is in cell A1. In A2 enter this formula:

=1.05*A1

and copy down the column. Each cell down the column will 5% more than the
cell above it.