Toolkit
Cashflow Calculator
Model a duplex, triplex, or single rental in Waterloo Region. See monthly cashflow, cap rate, and cash-on-cash return before you fall in love with the deal.
Better than back of the napkin.
Property
Purchase price
$650,000
Down payment — $130,000
20%
Interest rate
5.0%
Amortization
25yr
Rental income
Upper / main unit ($/mo)
$2,200
Lower / second unit ($/mo)
$1,750
Vacancy allowance
5%
Monthly expenses
Property tax /mo
$500
Insurance /mo
$180
Maintenance reserve (% of value/yr)
1%
$542/moProperty management (% of rent)
0%
Self-managedMonthly cashflow
-$494
-$5,922 / year
Cap rate
4.67%
NOI ÷ purchase price
Cash-on-cash
-4.56%
Annual return on down payment
Monthly breakdown
| Gross rent | $3,950 |
| Vacancy (5%) | −$198 |
| Effective income | $3,753 |
| Property tax | −$500 |
| Insurance | −$180 |
| Maintenance (1%/yr) | −$542 |
| Net operating income | $2,531 |
| Mortgage (5.0%, 25yr) | −$3,024 |
| Net cashflow | −$494 |
Negative cashflow.This property doesn't cover its own costs today. That's common in KW at current rates — but run a 3-year scenario: what do rents look like when the mortgage renews?
Mortgage uses Canadian semi-annual compounding. Estimates only — does not include principal paydown, appreciation, or tax treatment. Confirm with your accountant and mortgage broker.
Looking at a specific property?
I own and operate investment properties in Waterloo Region myself. Send me the address and I'll tell you what the numbers actually look like — including the things a calculator can't model.
Talk to William →