Reversing a column

[Don Kline]

I need to take a column of calculated numbers and then reverse it .

I need to apply a compound interest factor. Using a 6% annual increase the
value at the end of the first year is 1.06. The next year it is 1.1236 =
1.06^2 and so on. In this example I end up in Year 40 with a factor of
10.28571794. Then I need to reverse or flip this over so that the 10.28571794
is in the first year and it ends with the 1.06 on year 40. I'm stumped and
would appreciate a helping hand.

PY Age Compound int ToRetirement Compound int
1 26 1.06 40 10.28571794
2 27 1.1236 39 9.703507488

 

[Per Jessen]

Hi

Your formula should look like this for year 1:

=A1*(1/1,06^39)

Regards,
Per

 

[Don Kline]

Thanks for the help to get me over the hump on this one.