I like to be able to view the projections using present values. In column V and X I added a formula to show the present value of the withdrawal amount (column L) and balance (column S). In W28 I added an inflation % assumption (3.5%). The formula I used for column L is: =PV($W$28,(E37-$E$25),0,L37)*(-1).
Here is the formula I used in column S: =PV($W$28,(E37-$E$25),0,S37)*(-1).
@dtchura - Please share a screenshot as some people (myself being one of them) may have edited the Retirement Planner sheet so our column letters may be different than yours.
Thanks.
