I used simplified inputs with a very basic scenario. After populating and looking at the Tabular Projections summary page, the total income column is projected out to full life expectancy but the total expenses, cashflow, and several others are only populated to 2024. This is with 2024 v 1.6. Here are the inputs
Assumptions | Names and Demographics | Expenses | |||||||||||||
Inflation (%) | 3.0% | Your Names | Bob | Kit | Recurring Annual Expenses (in today's $) | ||||||||||
Home State | AZ | Your Birthdates | 3/15/1999 | 3/15/1999 | Period 1 Expenses | 20,000 | |||||||||
Average Real Rate of Return (%) | 2.0% | Retirement Age | 65 | 60 | Period 2 Expenese | Year | |||||||||
Amount of Current Savings | Life Expectancy | 100 | 100 | Period 3 Expenses | Year | ||||||||||
Your Tax-Deferred Accounts | 0 | Pre-Retirement Employment Income (in today's $) | One-Time Expenses (in today's $) | ||||||||||||
Spouse's Tax-Deferred Accounts | 0 | Annual Income Amount | 70,000 | Expense1 | Year | ||||||||||
Roth Accounts | 0 | Annual Percentage Increase | Expense2 | Year | |||||||||||
Regular Investment Accounts | 5,000 | Contributions to 401K ($) | Expense3 | Year | |||||||||||
Regular Cash Accounts | 1,000 | Company Contributions to 401k ($) | |||||||||||||
Contributions to Roth IRA ($) | | ||||||||||||||
Contributions to a Defined Benefit Plan ($) | |||||||||||||||
Post-Retirement Employment Income (in today's $) | |||||||||||||||
Annual Amount | |||||||||||||||
Number of Years You Plan to Work | |||||||||||||||
Pension Benefits (in future $) | |||||||||||||||
Annual Amount | |||||||||||||||
Maximum Cost of Living (COLA) Adjustments | | ||||||||||||||
Social Security Benefits (in today's $) | |||||||||||||||
Annual Benefit Amount at FRA | 20,000 | 12,000 | |||||||||||||
Age at which you plan to start benefits | 70 | 62 |
And an example of the outputs:
| Total Income | Total Expenses | Cash Flow | Overall Withdrawal Rate | 529 Plan Balance | Cash Balance | Regular Investments Balance | Unrealized LTCG in Regular Investment Account | Bob's Tax-Deferred Savings Balance | ||||||||||||
2023 | - | - | - | - | - | 1,000 | 5,000 | - | - | ||||||||||||
2024 / 24 / 24 | 70,000 | 30,842 | 39,158 | - | - | - | 44,086 | 125 | - | ||||||||||||
2025 / 25 / 25 | 67,961 | - | |||||||||||||||||||
2026 / 26 / 26 | 65,982 | - | |||||||||||||||||||
2027 / 27 / 27 | 64,060 | - | |||||||||||||||||||
2028 / 28 / 28 | 62,194 | - | |||||||||||||||||||
2029 / 29 / 29 | 60,383 | - | |||||||||||||||||||
2030 / 30 / 30 | 58,624 | - |
@reed981 This is a case of exceeding the maximum length of the modeling period the tool can handle, given the fact that it's an Excel model with fixed-length internal tables. The maximum period it can model is 70 years.
Stuart
@smatthews51 Thanks! I was banging my head against the wall. I 'll adjust the life expectancy. I was trying to show my son how cool the calculator is but I had never tried do do it for someone so young.
@reed981 Yeah; I had never really imagined that a person in their early 20's would concern themselves with a retirement calculator. Anyway, the web version of the tool (due to be released in late March) will support a longer modeling period because we do hope to attract a younger audience as we move forward.
Stuart