I am trying to run a future value out 35 years (a retirement calculation)
with all constants, except I want the "PMT" to be variable, specifically, I
want the payment to be 3% of my salary, indexed each year for inflation (I am
using 3.5%). This is not my actual savings, but instead a simulation comaring
the company's pension contribution versus a 3% contributuion to a 401k. So if
my salary is $100,000, in year one, PMT would be $3000, but in year two, PMT
would be $3105 (3% of 103,500) and so on. Any advice would be appreciated.
Thanks!