Is there a formula I can apply to the table, similar to the one below, that will accurately adjust for the compounding affect of inflation or the Future value of money? I am attempting to calculate the true value of future income in today’s dollars, over the 30-year period as shown in the table below. Any help would be greatly appreciated.


Time Income

Year 1 10.00
Year 2 12.00
Year 3 12.00
Year 4 13.00
Year 5 14.00
Year 6 14.00
Year 7 10.00
Year 8 12.00
Year 9 12.00
Year 10 13.00
Year 11 14.00
Year 12 14.00
Year 13 15.00
Year 14 16.00
Year 15 17.00
Year 16 18.00
Year 17 19.00
Year 18 20.00
Year 19 22.00
Year 20 23.00
Year 21 24.00
Year 22 26.00
Year 23 28.00
Year 24 30.00
Year 25 32.00
Year 26 35.00
Year 27 38.00
Year 28 42.00
Year 29 46.00
Year 30 50.00