I recently created a retirement spreadsheet using excel and am having a hard time understanding how, given the power of inflation, you could ever retire with relative certainty that’d you’d be ok in the long run.
Suppose you retire at age 65 with optimistically $1.5 million in savings. Suppose that generates 5% per year in interest income that you plan to live on = $75K/yr. Suppose you pay 30% total income tax on that (fed/state) leaving you with ~$50K/yr or roughly $4,000/mo. Clearly today $4,000/mo is plenty to live on comfortably.
But ~30 years from now (I am 36), assuming 3.2% annual inflation, $4,000/mo is worth only about $1,500 in today’s dollars. Still maybe ok if you live frugally; maybe have a place to live for free at that point (assuming you didn’t need your home equity to get to the original $1.5M nest egg).
But the thing that really has me scratching my head is what if you live to be 95? That $4K/mo is now worth only ~$600/mo. That’s tough to live on. AND the thing that is even harder for me to understand is how much money it would take to make a material difference — suppose you double the $1.5M nest egg to $3.0M. By 95, that is still only giving you ~$1,200/mo in today’s dollars worth of purchasing power?
Clearly you might have additional income — SSI and/or work pension etc. But for the sake of simplicity, assume you don’t have those additional sources (because 1.5M as a nest egg is a stretch as is, so in coming up with the above numbers, I already shifted them to assume some of that original $4k/mo includes those sources).
How does one responsibly plan to live into deep old age (the universe willing) given the power of inflation? Once you stop working and start living on interest income, your dollars seem to devalue rapidly. Is the only solution kids/other family support by ppl working who make salaries inflated to 60-years-from-now levels? Or just enjoy the first 10-15 years of retirement while your money is still competitive? Is the advice on so many finance websites to aim for 1M to 1.5M in retirement savings dated (keyed to today’s dollars or even 30 years from now dollars, rather than 40/50/60 years from now dollars)? Or the advice that you should save X times your current salary to sustain X quality of life somewhat incomprehensible, since retirement is not a static situation, but rather a dynamic one in which X quality of life takes increasingly more income to sustain every year?
I’d really appreciate any help with reorienting my thinking about this if possible. I thought the retirement spreadsheet drafting process would make me feel more secure, and instead I feel less secure.
TL;DR - draft retirement spreadsheet has me confused as to how one can ever reasonably expect to live 30 years post-retirement on interest income alone without many millions in savings given the power of inflation. Please help :)
Submitted March 03, 2018 at 11:20AM by georgefrost310 http://ift.tt/2FknRqJ
