Most personal finance projections assume the next 10 years will produce something close to a long-run average return. The forecast looks fine. Then a sideways decade actually happens and the spreadsheet that promised $640,000 at year 10 quietly delivers $470,000, and the plan that depended on the higher number was making decisions the lower number cannot support.
The fix is to build a stress test directly into the model from the start. A flat-decade scenario, paired with the base case, tells you whether the plan is robust or whether it secretly needs returns to cooperate every year.
This is a practical walkthrough of how to set one up in a spreadsheet, why the assumptions are what they are, and how to read the output.
Photo by Artem Podrez on Pexels
What a flat-decade scenario actually represents
A flat decade is not a recession. A recession is one or two years of negative growth, usually followed by recovery. A flat decade is a stretch where the cumulative real return on equities is roughly zero across the entire 10-year window. Long-run market data, available from sources like the Bureau of Economic Analysis, shows that this has happened before. The 2000 to 2009 stretch is the frequently cited modern example: the S&P 500 in real terms was effectively flat across that decade.
A projection that does not account for this possibility is implicitly assuming it will not happen again in any specific 10-year window. That is not a defensible assumption. A projection that does account for it tells you what your plan looks like in that world, which is the more useful question.
Worth being clear: a flat decade is not a worst-case scenario. It is a within-the-range scenario. The model's job is to show what happens if the next 10 years land in that range, not to declare it the most likely outcome. The plan should be robust to it; the household should hope it does not occur.
Step 1: Build the base case first
Before you stress test anything, you need a clean base case. A simple two-column spreadsheet works:
- Column A: year (0 through 10).
- Column B: starting balance per bucket, growing at the bucket's expected return rate.
For a five-bucket model, this expands to one row per bucket per year, plus a contribution row and a debt amortization row. The total at the bottom of each year is the projected net worth for that year.
Use realistic per-bucket rates. A blended 7 percent across the whole balance sheet hides too much. The hub article on this projection method, how to project your net worth 10 years out, walks through what defensible rates look like by bucket.
The starting snapshot should come from a clean source. Pulling balances out of a half-dozen account statements works fine for the first run. After that, the Federal Reserve Survey of Consumer Finances is a useful peer comparison to sanity-check the buckets.
Step 2: Duplicate the columns for the flat-decade scenario
Copy the base case into a parallel set of columns. In the duplicated version, change only one thing: the equity return rate goes to 0 percent for years 1 through 5, then resumes at the base case rate for years 6 through 10. Keep cash, real estate, vehicles, and contribution assumptions the same as the base case. The point of the test is to isolate the equity return path.
A more aggressive version of the test runs the 0 percent rate for the entire 10 years. That is closer to a true flat-decade scenario, but the half-decade version is closer to what 2000 to 2009 actually delivered, so it is a defensible middle ground.
Some households like to run a third variant: equities at minus 2 percent real for years 1 through 3, then recovery at 8 percent for years 4 through 10. That mimics a recession-and-recovery shape. The model becomes a small library of scenarios rather than a single forecast, and the household gets to see the spread.
Step 3: Read the gap
The output of the stress test is a single number: the difference between the base case projected net worth at year 10 and the flat-decade projected net worth at year 10. That gap tells you how much of your projection depends on equity returns showing up.
A small gap means contributions and debt paydown are doing most of the heavy lifting. The plan is robust to return uncertainty. A large gap means the projection is fragile. Most of the projected wealth comes from market returns, which the model has no power to guarantee.
If the gap is uncomfortable, the model is pointing at one of three levers: contribution rate up, expense base down to free more contributions, or asset mix shifted to include sources of growth that are less correlated with equity markets.
Step 4: Add a contribution interruption test
While you are stress testing, run a second scenario alongside the flat-decade one. Take the base case and set contributions to zero for two consecutive years somewhere in the middle of the 10-year window. This simulates a job change, an extended medical event, or a major family expense.
In a 10-year window, the probability of at least one such interruption is high enough that the model should reflect it. The Bureau of Labor Statistics job tenure data shows median tenure in the U.S. is well under five years, which means at least one transition during the projection window is likely.
This test usually catches households by surprise. Two zero-contribution years in the middle of the decade can cost six figures of year-10 net worth, because the missed contributions are also missing several years of compound growth on top. The longer the projection horizon, the more painful the missed contributions become.
Step 5: Look at all three numbers together
You now have three year-10 projections: base case, flat-decade stress, contribution-interruption stress. The base case is what happens if the next decade is average. The two stress tests are what happens if reality does not cooperate.
A plan worth trusting produces a livable number in all three scenarios. A plan that only works in the base case is not really a plan; it is a forecast with implicit assumptions that have not been examined.
If only one of the three stress tests breaks the plan, the model has just told you exactly where to focus. Build the emergency fund up. Diversify the asset mix away from concentration in any single source of growth. Pay down the high-interest debt that compounds against you. The stress test does not just diagnose; it points at the specific lever.
Where to start with the current snapshot
The projection only works if the starting balance is accurate. The Net Worth Tracker & Analyzer at evvytools.com captures assets and liabilities in the right buckets, produces the current snapshot, and computes liquidity and debt-to-asset ratios alongside the net worth figure. The tools directory carries the rest of the everyday calculators in the same series.
The Vanguard investor education library carries explanations of why per-bucket return assumptions beat blended rates for forecasting. The Consumer Financial Protection Bureau has plain-language explanations of how amortization, contribution limits, and inflation interact in a long-term financial plan.
A short checklist for the stress test
- Base case uses per-bucket return rates, not a blended single rate.
- Flat-decade scenario sets equity returns to 0 percent for years 1 through 5.
- Contribution-interruption scenario sets contributions to zero for two consecutive years.
- All three projections are reported in both nominal and inflation-adjusted dollars.
- The gap between scenarios is examined explicitly, not just the headline number.
A stress test takes 30 minutes to build once and then re-runs in seconds whenever the inputs change. It is the cheapest single improvement you can make to a personal financial projection.
Top comments (0)