Scenario Modeling: How to Make Better Hold/Sell Decisions With Data
Base case, bull case, bear case. Three projections that replace guesswork with decision confidence.
Most hold/sell decisions in rental real estate come down to one unspoken assumption: things will keep going the way they have been going. The property will appreciate at some rate you have in your head. Rents will keep up. Expenses will stay manageable. You hold because the default feels good enough.
That is not analysis. That is coasting.
Smart investors -- the ones managing institutional money -- never look at an asset through a single version of the future. They sketch out multiple scenarios, take a rough guess at how likely each one is, and make decisions based on the range of what could happen instead of a single prediction. You can do the same thing with straightforward math and a simple framework.
Why "One Best Guess" Thinking Fails
When you make a hold/sell decision using only your best guess of the future, you are basically assuming you can predict what is coming. You are betting that appreciation will be exactly 3%, rent growth exactly 2%, and vacancy exactly 5%. But real estate does not work that way.
The problem gets worse because a single guess gives you false confidence. If your one projection says "hold," you hold with total certainty. If it says "sell," you sell with total certainty. But neither confidence level is earned, because neither one accounts for the range of things that could actually happen.
Scenario modeling -- running your numbers through multiple "what if" versions of the future -- fixes this. It forces you to face the full range of possibilities. Sometimes all three scenarios point in the same direction, and you can feel confident in your decision. Other times, they point in different directions, which tells you the decision is genuinely uncertain and you should be careful.
The Three-Scenario Framework
A practical scenario model for hold/sell decisions uses three projections over a 5-year horizon:
Base Case
Your most realistic estimate of future performance. Start with your actual numbers from the last 12 months and adjust for anything you already know is changing. If you have owned the property for several years, your real track record is a solid foundation.
Bull Case
The optimistic-but-realistic scenario. Not the best thing that could possibly happen -- the best thing that could reasonably happen. Think strong market performance, not winning the lottery.
Bear Case
The pessimistic-but-survivable scenario. What happens if the market cools off, vacancies go up, or expenses rise faster than expected? This is not a worst-case-scenario doomsday exercise. It is the low end of realistic outcomes.
Variables to Test
Four variables drive most of the difference in rental property performance over a 5-year horizon:
| Variable | Base Case | Bull Case | Bear Case |
|---|---|---|---|
| Annual appreciation | 3% | 5% | 0% |
| Annual rent growth | 2% | 4% | 0% |
| Annual expense growth | 3% | 2% | 5% |
| Average vacancy rate | 5% | 3% | 10% |
These ranges are just examples. Your local market should drive the specific numbers you plug in. The point is that each variable changes independently across scenarios, and the combined effect shows you the range of possible outcomes for your equity.
Running the Model: A Worked Example
Consider a property with these current numbers:
| Metric | Current Value |
|---|---|
| Market value | $300,000 |
| Mortgage balance | $180,000 |
| Current equity | $120,000 |
| Annual gross rent | $24,000 |
| Operating expenses | $8,400 |
| Annual debt service | $12,600 |
| Net cash flow | $3,000 |
| Current ROE | 2.5% |
Now project this property forward five years under each scenario:
Base Case (5-Year Projection)
| Year | Property Value | Equity | Net Cash Flow | ROE |
|---|---|---|---|---|
| 1 | $309,000 | $134,400 | $3,060 | 2.3% |
| 2 | $318,300 | $149,400 | $3,096 | 2.1% |
| 3 | $327,800 | $164,900 | $3,102 | 1.9% |
| 4 | $337,600 | $181,100 | $3,072 | 1.7% |
| 5 | $347,700 | $197,800 | $3,000 | 1.5% |
5-Year cumulative cash flow: $15,330 Ending equity: $197,800
Bull Case (5-Year Projection)
| Year | Property Value | Equity | Net Cash Flow | ROE |
|---|---|---|---|---|
| 1 | $315,000 | $140,400 | $3,540 | 2.5% |
| 2 | $330,800 | $161,800 | $4,116 | 2.5% |
| 3 | $347,300 | $184,300 | $4,728 | 2.6% |
| 4 | $364,700 | $208,000 | $5,382 | 2.6% |
| 5 | $382,900 | $232,900 | $6,078 | 2.6% |
5-Year cumulative cash flow: $23,844 Ending equity: $232,900
Bear Case (5-Year Projection)
| Year | Property Value | Equity | Net Cash Flow | ROE |
|---|---|---|---|---|
| 1 | $300,000 | $125,400 | $1,200 | 1.0% |
| 2 | $300,000 | $131,000 | $540 | 0.4% |
| 3 | $300,000 | $136,800 | -$168 | -0.1% |
| 4 | $300,000 | $142,800 | -$930 | -0.7% |
| 5 | $300,000 | $149,000 | -$1,752 | -1.2% |
5-Year cumulative cash flow: -$1,110 Ending equity: $149,000
Reading the Results
The scenario comparison table tells the story:
| Metric | Bear | Base | Bull |
|---|---|---|---|
| 5-Year cumulative cash flow | -$1,110 | $15,330 | $23,844 |
| Year 5 ROE | -1.2% | 1.5% | 2.6% |
| Year 5 equity | $149,000 | $197,800 | $232,900 |
| Cash flow turns negative? | Yes (Year 3) | No | No |
In this example, even the best-case scenario produces an ROE below 3% by year five. The base case shows ROE sliding to 1.5%. And in the bear case, the property is losing money within three years.
When all three scenarios show ROE below the minimum return you would accept, the hold/sell decision gets pretty clear. Your money is underperforming no matter what the future looks like.
When Scenarios Disagree
The more interesting -- and more common -- situation is when your scenarios give you mixed signals:
- Bear case: ROE drops below your minimum, suggesting sell
- Base case: ROE stays borderline, could go either way
- Bull case: ROE stays acceptable, suggesting hold
Mixed signals tell you something valuable: the decision is genuinely uncertain. In these cases, try weighing each scenario by how likely you think it is. If you believe the bear case has a 25% chance, the base case 50%, and the bull case 25%, calculate a weighted average.
Weighted 5-Year ROE: (0.25 x -1.2%) + (0.50 x 1.5%) + (0.25 x 2.6%) = 1.1%
If the weighted average still falls below your minimum, the data leans toward selling and redeploying, even though some individual scenarios favor holding.
The Redeployment Comparison
Scenario modeling gets really powerful when you compare holding against what you could do with the money elsewhere. If you sold and put the $112,000 in net proceeds (after selling costs) into a property or properties with a projected 8% ROE:
| Metric | Hold (Base Case) | Redeploy at 8% ROE |
|---|---|---|
| Year 1 cash flow | $3,060 | $8,960 |
| Year 3 cash flow | $3,102 | $8,960 |
| Year 5 cash flow | $3,000 | $8,960 |
| 5-Year cumulative | $15,330 | $44,800 |
The gap is not subtle. Even if the new investment only hits 6% ROE instead of 8%, the five-year cash flow difference is still significant.
Note: Selling and reinvesting comes with its own risks and transaction costs. This comparison is not meant to say that selling is always the right move. It is meant to put a dollar figure on the cost of keeping your money parked in an underperforming property.
The Psychology Factor
Beyond the math, scenario modeling does something important for your decision-making mindset. It pushes back against several mental traps that mess up hold/sell decisions:
Assuming things will go better than they probably will gets neutralized when you force yourself to write down a bear case. Most of us unconsciously assume things will play out at least as well as expected. Putting the downside on paper makes the risk real instead of abstract.
Sticking with the status quo just because it is comfortable gets harder when all three scenarios show declining performance. It is tough to justify sitting still when your own analysis shows the property underperforming no matter what happens.
Getting anchored to the past is reduced because scenario modeling focuses on future returns, not what the property has already done. What it earned you last year does not matter. What it will earn across a range of futures is the question you need to answer.
Trusting your gut over the numbers gets tempered by the simple act of acknowledging uncertainty. Assigning probabilities to different scenarios forces you to admit that you do not know what is coming -- and that honesty leads to better decisions.
Building Your Own Scenario Model
Follow these steps to run a scenario analysis on any property in your portfolio:
- Gather your actual numbers. Market value, mortgage balance, last 12 months of income and expenses. Use real numbers, not what you hoped the property would do.
- Set your variable ranges. Look at local market data for appreciation trends, rent growth history, and how fast expenses have been climbing. Define base, bull, and bear values for each variable.
- Project five years forward. For each scenario, calculate year-by-year equity, cash flow, and ROE. A spreadsheet handles this in under 30 minutes. Tools like ROE Engine can automate the projections across your entire portfolio.
- Compare against your minimum ROE. If all three scenarios fall below your floor, the decision is pretty clear. If they diverge, calculate weighted averages.
- Model what you would do with the money instead. Estimate the net proceeds from a sale and project what those proceeds would earn at your target ROE. Compare the cumulative cash flow and equity growth paths.
- Write down your decision and why. Whether you hold or sell, document the reasoning. This keeps you accountable and gives you a reference point for the future.
When All Roads Lead to the Same Answer
The biggest payoff from scenario modeling is when all three scenarios agree. When bear, base, and bull cases all point toward the same decision -- whether that is hold, sell, or refinance -- you can act with confidence. The uncertainty that usually makes hold/sell decisions so stressful disappears when the data lines up no matter which future shows up.
This will not happen every time. But when it does, it turns a stressful, gut-wrenching decision into a calm, clear-headed one. And that shift from emotion to analysis is the whole point of a structured approach.
The hard part is not the math. The math is simple. The hard part is running the model before you have already decided what you want the answer to be.
Run Your Portfolio Through ROE Engine
Calculate return on equity, detect capital drag, and model refinance scenarios across every property in your portfolio.
Frequently Asked Questions
How many scenarios should I model for a hold/sell decision?
Three scenarios hit the sweet spot between being thorough and keeping it practical: a base case (what you think will most likely happen), a bull case (things go well but not unrealistically well), and a bear case (things go poorly but you survive it). This gives you the range you need to feel confident in your decision without turning it into a research project.
What variables matter most in rental property scenario modeling?
Four variables drive most of the difference over a 5-year period: how fast the property appreciates, how fast rents grow, how fast expenses grow, and your average vacancy rate. Give each one different values across your base, bull, and bear scenarios based on what is actually happening in your local market and what has happened historically.
What does it mean when my scenarios give mixed signals?
Mixed signals mean the decision is genuinely uncertain -- the right call depends on which version of the future actually plays out. In these cases, take your best guess at how likely each scenario is (for example, 25% bear, 50% base, 25% bull) and calculate a weighted average. If that weighted average still falls below the minimum return you would accept, the numbers lean toward selling and reinvesting elsewhere.
How far into the future should I project my scenarios?
Five years works well for most hold/sell decisions. It is long enough to see meaningful trends in equity growth and ROE changes, but short enough that your projections are still grounded in reality. Beyond five years, there are just too many unknowns stacking on top of each other for the numbers to be very reliable.
Disclaimer: This content is for educational purposes only and does not constitute financial, tax, or legal advice. All scenarios and projections are illustrative examples. Consult qualified professionals before making investment decisions.
Related Articles
The 5-Year Equity Check: A Framework for Portfolio Optimization
A structured review process that reveals which properties are still earning their place in your portfolio.
Use the 5-year equity check framework to evaluate rental property ROE, equity growth, and performance. Score each property and decide whether to hold or act.
Capital Velocity vs. Capital Preservation: Finding Your Strategy
Two valid approaches to portfolio management. Most investors follow one without realizing they chose it.
Compare capital velocity and capital preservation strategies for rental portfolios. Learn how life stage, risk tolerance, and goals shape the right approach.
The Optimal Leverage Point for Rental Properties
Too little leverage creates capital drag. Too much creates cash flow fragility. The math reveals where the sweet spot lives.
Find the optimal LTV for rental properties. Compare ROE and cash flow risk at 50%, 65%, 75%, and 80% leverage to maximize returns without excess risk.