Future value of 100 dollars at 3% inflation in 10 years = $74.41:
=100/(1+.03)^10
Formula to copy in cells to calculate inflated value:
Col A Col B
Year Inflated Value
0 =100*(1+.03)^A1
=A1+1 =100*(1+.03)^A2
=A2+1 =100*(1+.03)^A3
=A3+1 =100*(1+.03)^A4
=A4+1 =100*(1+.03)^A5
=A5+1 =100*(1+.03)^A6
=A6+1 =100*(1+.03)^A7
=A7+1 =100*(1+.03)^A8
=A8+1 =100*(1+.03)^A9
=A9+1 =100*(1+.03)^A10
=A10+1 =100*(1+.03)^A11