10% reserve accumulated
12220
24318
36355
48332
60249
72106
83904
95643
107323
118945
130509
142015
153464
164855
176189
187467
198688
209853
220963
232017
243015
253959
264847
275682
286462
297188
307861
318480
329046
339560
350020



So essentially I want to calculate this list with 1% interest compounding annually. Each number is the new balance after a deposit each year. I want 1% interest compounding annually; what is the formula to use to automatically compound the entire column 1% annually if there is one? I could do it slowly 1 cell at a time and re-add all 31 columns but that seems excessive.

just make a new column

=12220*1.01+24318-12220
pull down

Not working for some reason; idk

edit: These are the numbers im adding each year to an account (deposits); but i want to compound them as they accrue and are added; the top numbers were just the numbers added up each year.

12,220
12,098
12,037
11,977
11,917
11,857
11,798
11,739
11,680
11,622
11,564
11,506
11,449
11,391
11,334
11,278
11,221
11,165
11,109
11,054
10,999
10,944
10,889
10,834
10,780
10,726
10,673
10,619
10,566
10,513
10,461


This post was edited by Blankey on Sep 15 2015 08:18am

Up