music-and-ski
Recycles dryer sheets
My mom's pension isn't indexed to inflation. So, I uncheck the box "Inflation adj". When I download the detailed spreadsheet, it shows a column of pension adjusted for inflation regardless of the state of that checkbox. But, the year-by-year starting balances seems to be correct.
Here's an example. I put in $10000 non-inflation adjusted. The spreadsheet downloaded shows the value increasing in the "Withdrawal Change 1" column.
I was terrified for a moment! I'm glad I was able to check the "Starting Portfolio" calculation, which I think is correct. It's just the data year-by-year in the column that's misleading:
Withdrawal Change 1
10364.9635
11338.19951
12676.39903
13527.98054
14233.57664
15206.81265
16618.00487
18929.44039
21167.88321
22944.03893
23795.62044
24793.18735
Here's an example. I put in $10000 non-inflation adjusted. The spreadsheet downloaded shows the value increasing in the "Withdrawal Change 1" column.
I was terrified for a moment! I'm glad I was able to check the "Starting Portfolio" calculation, which I think is correct. It's just the data year-by-year in the column that's misleading:
Withdrawal Change 1
10364.9635
11338.19951
12676.39903
13527.98054
14233.57664
15206.81265
16618.00487
18929.44039
21167.88321
22944.03893
23795.62044
24793.18735