Hold or Sell Methodology
A comprehensive guide to understanding how the Hold or Sell analysis tool calculates your returns, breakevens, and ROE
Overview
✅ Included
- •Property appreciation (manual or auto market data)
- •Future rental income increases (configurable %)
- •Future operating expense inflation
- •Mortgage principal paydown (amortization)
- •Selling costs (agent, legal, land transfer, etc.)
- •Historical net cash flow since purchase
- •Future projected annual cash flow
- •Capital gains tax (optional)
- •Alternative investment comparison (optional)
- •Mortgage break penalty (optional)
- •Return on Equity (ROE) — cash-only and with appreciation
❌ Excluded
- •Income taxes on rental income
- •Depreciation tax benefits
- •Major renovations or capital improvements
- •Mortgage renewal at different rates
- •Rent control or legal restrictions
- •Vacancy beyond the base cash flow input
Property Value
The property's future value is calculated using cumulative appreciation from today, not from the original purchase price.
Mortgage Balance
The current mortgage balance is the starting point. Monthly amortization is run forward year-by-year to track the remaining balance.
Selling Costs
Covers realtor commissions, legal fees, land transfer tax, and other transaction costs deducted from the sale proceeds.
Equity at Sale
The net proceeds you'd receive at closing after paying off the mortgage and all selling costs.
Future Annual Cash Flow
Projects how your net annual cash flow will change over time as rent and expenses grow at different rates.
Cash at Closing
The actual cash in your pocket after all deductions. Optional adjustments (penalty and tax) are subtracted here.
Total Profit / Loss
The all-in return on your original investment: what you walk away with after the sale, accounting for all cash flow received since purchase.
ROE measures how efficiently your trapped equity is generating returns. A low ROE signals that your capital might work harder elsewhere — for example, by selling and redeploying the proceeds into a higher-returning investment.
Equity (denominator) = Current Property Value − Current Mortgage Balance. This is the total capital currently locked in the property.
This measures the real cash-based return on your equity — combining what the property actually puts in your pocket each year (after all expenses and mortgage payments) with the equity built through principal reduction. Appreciation is intentionally excluded. A negative cash-only ROE means the property costs you money annually even if its market value is rising.
Includes the unrealized paper gain from appreciation. While this is the complete economic return, appreciation isn't cash until you sell, so treat this number with appropriate caution.
⚠️ Note on Principal Paydown: Including principal in the numerator is intentional and correct. The denominator (equity) is a snapshot of your existing investment today. The principal paydown in the numerator is new equity being created over the next 12 months — it's the return your property generates on that capital going forward, not a recount of what's already in the denominator.
You specify the total cumulative appreciation expected over 1, 3, and 5 years. The tool interpolates between these milestones and then uses the "ongoing rate" beyond year 5.
- • Default: 3% for all three timeframes
- • Months 0–12: Curve from 0% to your 1-year rate
- • Months 13–36: Curve from 1-year to 3-year rate
- • Months 37–60: Curve from 3-year to 5-year rate
- • Months 61+: Ongoing annual rate (compounded)
When city and province are provided, the tool looks up historical 1-year, 3-year, and 5-year appreciation rates from our database and uses the same interpolation curve above.
1. Investment Breakeven
The point in time when your Total Profit/Loss turns positive — meaning you've fully recovered your original down payment plus all losses since purchase.
2. Hold vs. Sell Today Breakeven
The point where holding the property produces a better net outcome than selling today and pocketing the cash. Compares your total hold outcome against a fixed lump sum — what you'd receive if you sold right now.
If this breakeven is many years away, it may signal a good time to sell and redeploy capital.
3. Sell Today & Invest (the orange dashed line)
This is not a breakeven metric — it's a hypothetical alternative scenario shown on the chart. It answers: "If I sold today and invested those proceeds elsewhere at a chosen annual return, what would that money grow to over time?"
Unlike the Hold vs. Sell Breakeven (which compares against a fixed amount), this line keeps growing as your alternative investment compounds over time.
💡 Why Can These Numbers Look So Different?
This is the most common source of confusion. Here's a real example:
The Key Insight:
- • Hold vs. Sell Breakeven = "When does holding beat doing nothing with today's cash?" (fixed comparison)
- • Sell Today & Invest = "When does holding beat actively investing today's cash?" (growing comparison)
- • The gap between them reflects the cost of choosing real estate over a liquid alternative investment — essentially, the return rate your alternative investment is earning on your money over time.
The two breakeven metrics can tell very different stories — and understanding why helps you make a smarter sell vs. hold decision.
Investment Breakeven — "When am I whole?"
This looks backward and forward: it measures when your Total Profit/Loss turns positive — meaning you've fully recovered your original down payment plus all cash flow losses since purchase.
Why it can be far out: If the property had significant upfront costs, years of negative cash flow, or you paid a premium price, it can take many years before the total is in the black relative to your original investment.
Hold vs. Sell Today Breakeven — "Is holding better than selling right now?"
This is purely forward-looking: it asks when holding the property will generate more total wealth than selling today and pocketing the cash. It doesn't care about sunk costs — only the opportunity from this point forward.
Why it can be much sooner: If you have substantial equity and positive cash flow, holding is already generating strong returns on that equity. Even if your total investment is still negative (the Investment Breakeven hasn't passed yet), holding can still be the smarter financial move compared to selling today.
A Concrete Example
Imagine you bought a property that bled cash for the first 3 years. Your Investment Breakeven is still 4 years away because you're digging out of those early losses. But today, the property has strong equity and positive cash flow — so the Hold vs. Sell Breakeven is only 1 year away, because holding beats selling from this point forward.
- • Investment Breakeven: 7 years from purchase (4 years from now)
- • Hold vs. Sell Breakeven: 1 year from now
- • Takeaway: Selling today would be a mistake — holding for just 1 more year beats selling, even though you're not yet "whole" on the full investment.
The Bottom Line
- • Investment Breakeven tells you when the overall investment pays off from day one — useful for evaluating the full historical picture.
- • Hold vs. Sell Breakeven is the most actionable metric for a sell decision — it tells you whether holding or selling from today is the better financial move, regardless of what happened in the past.
- • Sunk costs don't matter. Money already spent is gone. The Hold vs. Sell Breakeven correctly ignores the past and focuses purely on future outcomes.
| Adjustment | What It Does | Formula |
|---|---|---|
| Capital Gains Tax | Tax owed on profit above purchase price | (Sale Price − Purchase Price) × Inclusion Rate × Tax Rate |
| Alternative Investment Comparison | Shows what your net sale proceeds today would grow to if invested at a chosen annual return rate — displayed as the orange dashed line on the chart and a column in the table. Not subtracted from results. | Cash at Closing(today) × (1 + Alt. Return)^t |
| Mortgage Break Penalty | Cost to break your mortgage early (3-mo interest or IRD) | max(3 months interest, IRD) or either method |
Important Notes
1. This is a projection tool, not a guarantee. Actual results will depend on market conditions, tenant stability, interest rate changes, and many other factors.
2. Be conservative. Use realistic rent increases, expense inflation, and appreciation rates. Overestimating any of these will produce overly optimistic results.
3. Tax implications are estimates only. Capital gains tax calculations are simplified estimates. Consult a CPA for your actual tax situation, including depreciation recapture and principal residence exemptions.
4. Beta feature. All projections should be independently verified before making investment decisions.