Tried to make a quick copy of your spreadsheet with the Roth. Since the Roth is tax free, you should have more funds then AND your distributions won't be conflicting (tax wise) with your social security, pension (if you have one) or rental income or any other income that might then bump you up a bracket.
What I illustrate to the people I talk to (who get a pension) is since they're going to have a pension (lifetime income that's 100% taxable), Social Security (lifetime income that's 100% taxable) "to me" it makes a lot of sense for them to also build a bucket of tax free money. What I urge them to consider is doing the Roth....and when they retire, to NOT dip into it to "fix their roof" type thing....but rather to maybe put it into INCOME PRODUCING investments and then simply peel the income off....tax free to augment their other/taxable income. If they can keep the 'golden goose' alive for the rest of their life, then they'll have that extra tax free income for the rest of their life.... if they need to dip into the golden goose, they can do so but now, it might only be a golden chicken with golden eggs.....then I'll ask if they'd rather have a gold goose egg or a gold chicken egg.
Invest | 10000 | | |
Post Tax: | 0.8 | | |
Return | 1.07 | | |
| | | |
| Year | IRA | Roth |
| 1 | 10,000.00 | 10,000.00 |
| 2 | 10,700.00 | 10,700.00 |
| 3 | 11,449.00 | 11,449.00 |
| 4 | 12,250.43 | 12,250.43 |
| 5 | 13,107.96 | 13,107.96 |
| 6 | 14,025.52 | 14,025.52 |
| 7 | 15,007.30 | 15,007.30 |
| 8 | 16,057.81 | 16,057.81 |
| 9 | 17,181.86 | 17,181.86 |
| 10 | 18,384.59 | 18,384.59 |
| 11 | 19,671.51 | 19,671.51 |
| 12 | 21,048.52 | 21,048.52 |
| 13 | 22,521.92 | 22,521.92 |
| 14 | 24,098.45 | 24,098.45 |
| 15 | 25,785.34 | 25,785.34 |
| 16 | 27,590.32 | 27,590.32 |
| 17 | 29,521.64 | 29,521.64 |
| 18 | 31,588.15 | 31,588.15 |
| 19 | 33,799.32 | 33,799.32 |
| 20 | 36,165.28 | 36,165.28 |
| Post Tax | 28,932.22 | 36,165.28 |