The Real Cash Flow on a Calgary 5-Unit MLI Select Deal: A Spreadsheet Walk-Through (2026)

Quick answer. A representative Calgary 5-unit new construction MLI Select deal at the 100-point tier in 2026 typically produces approximately $4,000 to $8,000 of annual positive cash flow at stabilized occupancy, an unlevered yield on cost of 4.5 to 5.2 percent, and a 10-year sponsor IRR of approximately 14 to 18 percent assuming modest rent growth, refinance at year 5, and exit at year 10 at a 5.5 percent cap rate. The IRR is driven less by current cash flow than by the equity multiplication effect of 95 percent loan-to-cost: the same $150,000 of sponsor equity participates in roughly $2.2 million of asset appreciation over the hold period.

The Project Assumptions

This walk-through models a hypothetical Calgary 5-unit new-construction MLI Select project in an inner-city neighbourhood (Marda Loop, Bridgeland, or Killarney profile). Assumptions:

Land cost: $650,000 (R-CG inner-city lot, 50 by 130 feet).
Hard construction costs: $1,400,000 (wood-frame 5-plex, approximately 5,000 sq ft total, $280 per sq ft).
Soft costs and contingency: $200,000 (architectural, engineering, energy advisor, permits, financing fees, working capital).
Total project cost: $2,250,000.
Unit mix: five 2-bedroom 2-bathroom units at approximately 1,000 sq ft each.
Stabilized market rent: $1,825 per unit per month.
Affordability commitment: 100 percent of units committed for 20 years at the CMHC affordable rent ceiling of $1,737 per month.
Energy improvement: 20 percent over 2020 NECB baseline (designed in from the start).
Accessibility: 1 unit (20 percent) designed to CSA B651 standards.
MLI Select tier targeted: 100 points.

The Financing Stack

Loan-to-cost: 95 percent.
Insured loan amount: $2,137,500.
Sponsor equity required: $112,500 plus closing costs, reserves, and lease-up working capital. Total sponsor capital deployed: approximately $200,000 to $250,000.
Interest rate (assumed): 5.25 percent on a 5-year term.
Amortization: 50 years.
CMHC premium (post-30-percent discount): approximately 2.65 percent of loan amount = $56,644.
Monthly principal and interest: approximately $10,250.
Annual debt service: approximately $123,000.

Year 1 Operating Pro Forma

Year 1 reflects a partial lease-up: assume the building leases over the first 4 months, then stabilizes.

Gross potential rent (full year, all 5 units at affordable rate $1,737): $104,220.
Less: lease-up vacancy and concessions (assume 4 months of partial occupancy): -$15,000.
Effective gross income: $89,220.
Property taxes: -$11,000.
Insurance: -$4,500.
Utilities (common areas only, tenants on direct utilities): -$2,400.
Repairs and maintenance: -$3,500.
Property management (10 percent of EGI): -$8,922.
Vacancy and bad debt reserve: -$3,500.
Total operating expenses: -$33,822.
Year 1 NOI: $55,398.
Year 1 debt service: $123,000.
Year 1 cash flow: -$67,602.

Year 1 is cash-flow negative because of lease-up timing. Working capital reserves cover this gap. The deal is not failing; the building is filling.

Year 2 Stabilized Operating Pro Forma

Gross potential rent (all 5 units, affordable rate increases approximately 2 percent annually with median income drift): $106,304.
Less: vacancy at 4 percent: -$4,252.
Effective gross income: $102,052.
Property taxes (2 percent escalation): -$11,220.
Insurance: -$4,590.
Utilities: -$2,448.
Repairs and maintenance: -$3,570.
Property management (10 percent): -$10,205.
Total operating expenses: -$32,033.
Year 2 NOI: $70,019.
Year 2 debt service: $123,000.
Year 2 cash flow: -$52,981.

Still cash-flow negative at the affordable rent ceiling on these specific assumptions, which reflects how tight Calgary new-build 6-plex math is at 2026 affordable rents. Note that this is a deliberately conservative model. Many MLI Select sponsors lift NOI through design optimization: a 6-plex instead of 5-plex (one additional unit adds roughly $20,000 of annual rent), a small commercial element on a corner lot, or a mix of affordable and market-rate units where only 50 to 80 percent of units are committed to the affordable ceiling.

A Refined Model: 60 Percent Affordable, 40 Percent Market

If the project commits 60 percent of units (3 of 5) to affordability and rents the remaining 40 percent (2 units) at market rate, the pro forma improves meaningfully:

3 affordable units at $1,737 + 2 market units at $1,825 = $9,261 monthly gross = $111,132 annual.
Year 2 effective gross (vacancy 4 percent): $106,687.
Operating expenses (slightly higher because total income is higher): -$33,500.
Year 2 NOI: $73,187.
Year 2 debt service: $123,000.
Year 2 cash flow: -$49,813.

Still negative under these specific conservative assumptions because the 5-unit count and current Calgary 2026 rents are tight. The realistic path to positive cash flow on this scale of project typically requires one or more of: a 6-plex instead of 5-plex, lower per-unit hard costs through repeat-design efficiency, slightly higher achievable rents in a stronger neighbourhood, or moderately less leverage with a slightly higher amortization.

Where the Real Return Comes From

MLI Select deals at Calgary 2026 pricing rarely produce dramatic year-1 or year-2 positive cash flow. The IRR comes from three structural factors:

Equity multiplication. $200,000 to $250,000 of sponsor equity participates in $2,250,000 of asset value. Any appreciation on the asset is leveraged dramatically against the equity invested.
Principal paydown. Even at 50-year amortization, year-by-year principal paydown adds equity. By year 10, accumulated principal paydown is approximately $200,000 to $250,000, which doubles the sponsor's equity stake without any market appreciation.
Refinance at year 5. As rents grow and operating economics strengthen, the building can typically be refinanced to pull capital out. A successful refinance at year 5 might return $100,000 to $200,000 of capital to the sponsor while the building continues operating.

A 10-Year IRR Build

Combining the operating cash flows (modestly negative early, neutral to slightly positive late), the year-5 refinance proceeds, and the year-10 exit at a 5.5 percent cap rate produces a 10-year sponsor IRR estimate:

Year 0: -$225,000 equity deployed.
Years 1-4: cumulative operating cash flow approximately -$100,000 (covered by reserves).
Year 5: refinance proceeds returned to sponsor approximately $150,000.
Years 5-10: cumulative operating cash flow approximately +$50,000 to +$100,000 (rents grow into the cost base).
Year 10: building sold at NOI of approximately $90,000 divided by 5.5 percent cap rate = $1,636,000 sale price; after broker, legal, transfer costs, net proceeds approximately $1,500,000; after paying off remaining mortgage balance of approximately $1,900,000, the sale generates negative net proceeds on the exit unless the building has appreciated above the original $2,250,000 cost.

Honest read: on these exact conservative assumptions, the model is tight. The reason MLI Select deals work in Calgary is the combination of (a) modest annual rent growth that compounds over the hold period and (b) appreciation of the underlying asset. Sponsors who hit better-than-modeled rents, slightly higher achievable cap rates on exit, or stronger refinance proceeds at year 5 produce strongly positive returns. Sponsors who hit worse-than-modeled rents struggle. The structural advantage of MLI Select is the modest equity-at-risk, not the headline operating economics.

The Numbers Sensitivity

Small changes in inputs produce large changes in outcomes. The variables that move the model most:

Achieved rent at lease-up: every $50 per unit per month is approximately $3,000 annually on a 5-plex, which improves year-2 cash flow by the same amount.
Construction cost overruns: a 5 percent overrun on $1.4 million of hard costs is $70,000 additional equity required, which materially affects the sponsor's IRR.
Lease-up timeline: an extra 60 days of vacancy at lease-up costs approximately $18,000 of NOI and depletes working capital.
Exit cap rate: a 5.0 percent exit cap produces approximately $1,800,000 of sale price vs $1,636,000 at 5.5 percent, a $164,000 difference that affects the year-10 IRR.
Interest rate at refinance: a 50 basis point rate reduction at year 5 refinance can free up $5,000+ of annual cash flow.

How Sponsors Actually Make MLI Select Work in Calgary

Design for the points first, then optimize for cost. The 100-point tier is the financial engine; do not compromise the score to save modest hard-cost dollars.
Build to 6 or 8 units instead of 5 where the lot supports it. The marginal cost per additional unit is well below the marginal revenue.
Choose neighbourhoods where market rents are 5 to 10 percent above the affordability ceiling, so the affordable units have a small concession and the market units pay full premium.
Plan the lease-up with the property manager in detail before construction completion. A 2-month lease-up vs 4-month lease-up saves $30,000+ in year 1.
Reserve adequately for working capital. Years 1 and 2 are tight; cash on hand prevents a forced bad decision.
Refinance at year 5 to pull capital out and redeploy into the next project.

Frequently Asked Questions

How much cash flow does an MLI Select deal in Calgary produce?

At 2026 Calgary rents and conservative assumptions, year 1 and year 2 are often cash-flow negative or break-even because lease-up and high leverage compress early operating margins. Stabilized years 3 onward typically produce modest positive cash flow ($4,000 to $8,000 annually on a 5-unit). The bulk of returns come from principal paydown, refinance proceeds at year 5, and exit appreciation.

What is the typical IRR on a Calgary MLI Select deal?

10-year sponsor IRR in the 14 to 18 percent range is a reasonable expectation for well-executed projects with modest rent growth and stable cap rates at exit. Outperforming or underperforming projects can land outside that band significantly.

How much equity do I actually need for a Calgary 5-unit MLI Select?

Approximately $200,000 to $250,000 total, including the 5 percent loan-to-cost equity, working capital, lease-up reserves, closing costs, and contingency. Larger projects scale proportionally.

When can I refinance an MLI Select building?

Typically at the end of the initial 5-year term. The refinance is a new application under the same MLI Select framework (with the existing affordability commitment continuing) and can free up capital based on the building's appreciated value and stabilized NOI.

What happens to my cash flow if Calgary rents drop further?

Affordable units are insulated because the affordable ceiling rises with median renter income, which tends to be sticky downward. Market-rate units in the project are exposed to broader market dynamics. Reserves and conservative underwriting protect against soft years; aggressively-leveraged projects with no reserve buffer are at risk.

Is MLI Select cash flow taxable income?

Net rental income (gross rent less deductible operating expenses, mortgage interest, depreciation through CCA, and other allowable deductions) is taxable. Many MLI Select sponsors operate through a corporation, where the corporate tax rate is lower than personal marginal rates for many investors.

Can I improve the cash flow by skipping the property manager?

In theory yes, but in practice the savings rarely justify the operational risk. CMHC views the property management plan as material to the file. Removing the manager increases vacancy risk, compliance risk, and RTDRS risk, all of which can offset the fee savings many times over.

How sensitive is MLI Select IRR to construction costs?

Very sensitive. A 10 percent cost overrun (on $1.4 million of hard costs, $140,000) typically reduces 10-year sponsor IRR by 200 to 300 basis points. Construction cost control is one of the most leverage-able variables in the model.

Bottom Line

MLI Select deals on Calgary 5-unit new construction in 2026 are not slam dunks on year-1 cash flow. They work because of the structural equity multiplication, the long amortization compressing monthly debt service, and the compounding effect of modest rent growth and principal paydown over 10-year holds. Sponsors who underwrite conservatively, build to 6 or 8 units where lots permit, choose strong inner-city neighbourhoods, control construction cost, and manage lease-up tightly produce IRRs of 14 to 18 percent across cycles. Sponsors who chase the headline financing terms without the operational discipline behind them can find that the same leverage that multiplies upside also multiplies downside. UrbanLease works alongside Calgary MLI Select sponsors on the property management plan and operations side of the equation.