Most rental property analysis stops at year one. You calculate cash flow, DSCR, and cap rate on today's numbers, decide whether the deal works, and move on. If you have not run that year-one analysis yet, see How to Analyze a Rental Property in Canada first. That is necessary but not sufficient. The real question is not whether the property cash flows in month one — it is whether it builds meaningful wealth over a 10 to 30 year hold.
The 30-Year View in Rental Analyst is designed to answer that question. This tutorial walks through every section of the tab using a real case study: a duplex in Kitchener purchased in 2023.
The Property: Kitchener Duplex, Purchased 2023
| Purchase price | $685,000 |
| Down payment | $137,000 (20%) |
| Closing costs | $12,000 |
| Mortgage balance | $548,000 |
| Mortgage rate | 5.29% (5-year fixed) |
| Amortization | 25 years |
| Monthly rent | $3,400 (both units combined) |
| Monthly expenses | $1,050 (tax, insurance, maintenance, capex reserve) |
| Current estimated value | $710,000 |
| Annual appreciation assumption | 3% |
At current inputs, this property runs roughly breakeven to slightly negative on monthly cash flow after the higher-rate renewal. The interesting story is what happens over 10 to 30 years. Open the 30-Year View tab to see it.
Section 1: The KPI Summary Cards
At the top of the 30-Year View, six KPI cards summarise the 10-year projection. They use your current property inputs and any rate overrides you have applied from the Renewal tab.
Equity built
The increase in your equity position from today to year 10. For the Kitchener duplex, this comes to roughly $287,000 — the combination of mortgage principal paid down ($98,000) and property appreciation ($189,000 at 3% per year on a $710,000 base). This is the number that makes a marginally negative cash flow property worth holding.
Cumulative cash flow
The total net cash in or out over 10 years after all expenses and mortgage payments. For this duplex, cumulative cash flow is roughly -$18,000 over 10 years — about $1,800 per year out of pocket on average, declining as rent grows. A negative number here is not automatically a problem; the equity built number tells you whether the wealth creation justifies the carrying cost.
Net gain
Equity built plus cumulative cash flow. For the duplex: $287,000 minus $18,000 equals roughly $269,000. This is the total economic gain from the investment over 10 years — the number that captures both the appreciation and principal paydown engine against the carrying cost.
Projected yield on capital (annualised)
Net gain divided by total cash invested (down payment plus closing costs), annualised over 10 years. Total cash invested was $149,000 ($137,000 down payment plus $12,000 closing costs). Net gain of $269,000 on $149,000 over 10 years annualises to roughly 6.1% per year. This is the return on your actual capital deployed, not the return on the property value — and it benefits from leverage.
Projected ending equity
Your estimated equity position at year 10. For the duplex, projected ending equity is approximately $390,000. The capital multiple shown alongside it (roughly 2.6x) means every dollar of original capital deployed is projected to become $2.60 in equity at year 10.
Cash flow breakeven year
The year in which annual net cash flow turns positive. For the Kitchener duplex at current inputs, this is around Year 4 or 5 as rent growth gradually outpaces the fixed mortgage payment. A green badge means breakeven happens within 5 years; amber within 15; red means it takes longer or may not happen within the 30-year window under current assumptions.
Section 2: The Wealth Trajectory Chart
Below the KPI cards, the wealth trajectory chart plots three lines across 10 years:
- Equity — your projected ownership stake (property value minus remaining mortgage balance) at the end of each year. This line rises consistently if appreciation and principal paydown are both working in your favour.
- Cumulative cash flow — the running total of net cash received or spent. For a property running slightly negative, this line starts below zero and may cross into positive territory once rent growth catches the mortgage payment. For the Kitchener duplex it stays mildly negative through year 5 before turning positive.
- Total wealth — equity plus cumulative cash flow. This is the single line that captures the full economic picture: what you would walk away with if you sold at that year (before selling costs), accounting for the cash you have put in or taken out over the hold period.
Renewal markers appear on the chart as vertical dashed lines at the year a modelled renewal term takes effect. If you have used the Renewal tab to model a rate change at Year 5, a marker appears at Year 5 and the chart adjusts the mortgage payment and cash flow trajectory from that point forward. This is how you see the effect of a renewal assumption on the full 10-year picture.
If you have modelled a renewal rate on the Renewal tab and toggled Apply on, a note appears below the chart confirming which year the modelled rate kicks in and what rate is being used. This keeps the projection transparent — you always know what assumptions are driving the lines.
Section 3: Assumption Override Sliders
On the right side of the view (or below the chart on smaller screens), three sliders let you adjust the assumptions driving the projection without changing your saved property inputs.
Rent growth (%/yr)
The annual rate at which rent increases. The default pulls from your property's saved rent growth assumption. Try moving this from 2% to 3.5% and watch the CF breakeven year move earlier and cumulative cash flow improve. For the Kitchener duplex, the difference between 2% and 3.5% annual rent growth over 10 years is roughly $22,000 in cumulative cash flow.
Vacancy (months/yr)
The expected vacancy expressed as months per year. One month equals roughly 8.3% vacancy. A duplex typically has lower vacancy risk than a single-unit property because one unit can cover costs while the other turns over. Moving this from 0.5 months to 1.5 months on the Kitchener duplex moves cumulative 10-year cash flow by approximately $40,000 — a meaningful sensitivity that most year-one analyses miss entirely.
Expense growth (%/yr)
The rate at which operating expenses grow annually. Property tax, insurance, and maintenance all tend to increase over time. The default is typically 2%. Moving this to 3.5% to reflect inflationary pressure on insurance and municipal tax adds roughly $11,000 to cumulative expenses over 10 years on this property.
Section 4: The Year-by-Year Breakdown Table
Below the chart, the breakdown table shows every year from 1 to 30 (or your amortization length). Each row is a complete annual income statement and balance sheet for the property. The columns are:
| Column | What it shows |
|---|---|
| Gross rental income | Total rent collected at full occupancy for the year, grown at your rent growth rate |
| Vacancy loss | Rent lost to vacancy, expressed as a negative number |
| Effective rent | Gross rental income minus vacancy loss — what actually comes in |
| Operating expenses | Property tax + insurance + maintenance + capex reserve + management fees + condo fees, grown at your expense growth rate |
| NOI | Effective rent minus operating expenses — net operating income before debt service |
| Mortgage interest | The interest portion of all mortgage payments that year |
| Mortgage principal | The principal portion — equity being built with every payment |
| Annual mortgage payment | Total debt service for the year (interest + principal) |
| Beginning balance | Mortgage balance at the start of the year |
| Principal paid | Total principal paid during the year |
| Ending balance | Mortgage balance at end of year — this is what you would owe if you sold |
| Net cash flow | NOI minus total mortgage payment — money in your pocket (or out of it) |
| Cumulative cash flow | Running total of net cash flow from Year 1 through this year |
| Est. property value | Projected value at year-end using your appreciation rate |
| Equity | Estimated property value minus ending mortgage balance |
For the Kitchener duplex, some numbers worth noting from the table:
- By Year 5, annual rent has grown to roughly $3,940/month and the property crosses into positive annual cash flow — the fixed mortgage payment stays constant while income rises.
- By Year 10, the mortgage balance is down to approximately $450,000 and the property value is around $954,000. Equity is roughly $504,000 — nearly 3.5x the original capital invested.
- The mortgage interest column shrinks every year while the principal column grows. By Year 15, principal paydown exceeds interest paid — every dollar of mortgage payment is doing more equity-building work than interest-servicing work.
- By Year 25, the mortgage is paid off and net cash flow equals NOI in full — roughly $5,800 per month at that point. This is the payoff of a long hold strategy.
How the 30-Year View Works with the Renewal Tab
The most powerful use of the 30-Year View is in combination with the Renewal tab. For a full walkthrough of how to model your renewal scenarios, see What Happens to Your Cash Flow at Renewal. Here is the workflow:
- Go to the Renewal tab and model your next renewal rate. For the Kitchener duplex, the 5-year term ends in 2028. Model it at 4.5%, 5%, and 5.5% using the scenario table.
- Click Model on the rate you want to project. The rate is saved as a modelled term starting at Year 5 of the projection.
- Toggle Apply to on. Return to the 30-Year View. The wealth trajectory chart now shows a renewal marker at Year 5 and recalculates all projections from that point using the modelled rate.
- Read the KPI cards again. The CF breakeven year, cumulative cash flow, and net gain all update to reflect the renewal assumption. At 4.5% the breakeven shifts earlier; at 5.5% it shifts later. You are now seeing the 10-year wealth impact of different renewal outcomes — before you sign anything.
What the Numbers Can and Cannot Tell You
The 30-Year View is a projection, not a prediction. Every figure beyond Year 1 is a modelled output based on the assumptions you feed in. Two assumptions drive the long-run numbers more than any others:
Appreciation rate
This single assumption drives most of the equity story. The difference between 2% and 4% annual appreciation on a $710,000 property over 10 years is roughly $108,000 in projected value. Be conservative here unless you have strong market-specific evidence for a higher rate. The tool defaults to what you entered in your property inputs.
Future mortgage rate
After your current term expires, the projection needs a renewal rate assumption. Without one modelled, it projects forward at your current rate, which may be optimistic or pessimistic depending on where rates go. Always model at least one renewal scenario before reading the 10-year numbers seriously. If you are approaching a renewal decision, see Hold, Sell, or Refinance? Run the Numbers to model all three exit strategies alongside it.
See your property's 30-year picture
Run the full projection in Rental Analyst
Enter your property once. The 30-Year View, wealth trajectory chart, and year-by-year breakdown table update automatically from your inputs.
Related tools
This article is for informational purposes only and does not constitute financial, tax, mortgage, or investment advice. All projections are estimates based on user-provided inputs and simplified assumptions. Actual results will differ. Always consult qualified professionals before making investment decisions.