ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
NEW HOMES ALBERTA · LEDUC 10 UNITS · MLI SELECT PROFORMA
2
CASH COSTSRATETOTAL
Leduc Stacked
PROJECTED RENTRENTUNITSTOTALSITE ROLLUPBLDG ABLDG BBLDG CSITE
3
Down Payment5.0%$155,000
5 townhomes stacked — Building C
3 bed 2.5 bath — primary suite$2,1005$10,500Lots56516
4
Mortgage Broker Fee1.00%$31,000
Deer Valley Drive at Creekside Circle, Leduc, AB T9E
2 bed 2.5 bath — secondary$1,8504$7,4003-bed units56516
5
CMHC Screening Fee$1,500Affordable secondary suitediscount10.8%$1,6501$1,6502-bed suites56516
6
Parking$505$250Total doors10121032
7
Appraisal & Environmental$5,500Pet fees / storage / other—0—Bedrooms25302580
8
Lender Fee$6,000Total Rent$19,800Gross sq ft13,75616,73513,78444,275
9
Legal Fees$6,000Total legal doors10Parking20242064
10
Total Cash Needed$205,000DEAL SUMMARYStalls per lot4
11
Refund on Closing—
INVESTOR REQUIREMENTS TO QUALIFY
OF PRICEAMOUNT
12
Total Investment After Refund$205,000PURCHASE PRICE$3,100,000TOTAL FINANCED$3,096,668
MONTHLY PAYMENT
$12,566Net worth (assets less liabilities)25.0%$775,000
13
DEBT SERVICERATETOTALLiquidity (cash, savings, LOC, stocks)10.0%$310,000
14
Loan to Value Ratio95.0%DSCRMONTHLY CASHFLOWCAP RATETotal cash to close$205,000
15
Mortgage$2,945,0001.17x$2,0775.67%
16
CMHC Fee5.15%$151,668SENSITIVITY · INTEREST RATE rebuilt live from F17 / F18 / F20
17
Total Mortgage$3,096,6683-YEAR TOTAL RETURNYEAR-1 CASH-ON-CASHOPEX RATIOSCENARIOMORT RATE
MONTHLY PAYMENT
YEARLY MORTGAGE
DSCR
18
Interest Rate (annual)4.30%235.3%12.2%26.0%Worst4.80%$13,629$163,5481.07x
19
Interest Rate (monthly)0.3583%Little worse4.55%$13,093$157,1191.12x
20
Amortization (years)50BASE RATE4.30%$12,566$150,7891.17x
21
Monthly Mortgage Payment$12,565.74GATE CHECKSPASS · clears CMHC 1.10POINTS SHORT · rerun at achievable tierLittle better4.05%$12,047$144,5611.22x
22
OPERATING EXPENSES (Monthly)RATETOTAL% GROSSNet worth req'd$775,000Liquidity req'd$310,000Total cash to close$205,000Best3.80%$11,537$138,4421.27x
23
Property Management5.0%$990.00
24
Property Tax (annual)$25,000$2,083.33SENSITIVITY · PURCHASE PRICE NOI held constant
25
Insurance ($/door/yr)$600$500.00LONG TERM ECONOMICS · estimatedSCENARIOPURCHASE PRICETOTAL FINANCED
MONTHLY PAYMENT
DSCRCASH TO CLOSE
26
Utilities—Initial Value$3,100,000+$100K$3,200,000$3,196,560$12,9711.13x$211,000
27
Repairs & Maintenance3.0%$594.00Market Growth Rate3.50%+$50K$3,150,000$3,146,614$12,7681.15x$208,000
28
Vacancy5.0%$990.00Rental Growth Rate2.50%BASE$3,100,000$3,096,668$12,5661.17x$205,000
29
Condo Fees—Expense Growth Rate2.00%−$50K$3,050,000$3,046,721$12,3631.18x$202,000
30
Other—−$100K$3,000,000$2,996,775$12,1601.20x$199,000
31
Total Expenses$5,157.3326.0%YEARASSET VALUELOAN BALANCECASHFLOW / YREQUITY IN PROPERTY
CUM. RETURN ON CASH
32
INCOME & RESULTS (Monthly)1$3,208,500$3,078,684$24,923$172,98473.9%SENSITIVITY · RENT only the soft line moves
33
Monthly Rent$19,800.002$3,320,798$3,059,911$29,625$191,756152.2%SCENARIOPRIMARY (HELD)SECONDARY (SOFT)TOTAL RENTTOTAL EXPENSESDSCRCASHFLOW/MO
34
Net Operating Income$14,642.673$3,437,025$3,040,315$34,451$211,352235.3%BASE$2,100$1,850$19,800$5,1571.17x$2,077
35
Net Operating Income (Annual)$175,7124$3,557,321$3,019,860$39,404$231,808323.2%−$100$2,100$1,750$19,400$5,1051.14x$1,729
36
Estimated Cap Rate (Annual)5.67%5$3,681,828$2,998,508$44,488$253,160416.0%−$200$2,100$1,650$19,000$5,0531.11x$1,381
37
Estimated Cash Flow$2,076.93−$300$2,100$1,550$18,600$5,0011.08x$1,033
38
DSCR1.17x−$400$2,100$1,450$18,200$4,9491.05x$685
39
The rent at which DSCR reaches 1.10 is the deal's floor.
40
41
MLI SELECT POINT SCORE · verify before trusting F14 and F20
42
CRITERIONBASISPOINTS
43
CASH FLOW CALCTOTAL RETURNS CALCULATOR
1 of 10 doors at 10.8% below market
0
44
YEARMONTHLY RENT
MONTHLY EXPENSES
MORTGAGENET OP CASH / MONET OP CASH / YR
CASH ROI ON CASH OUT
YEARNET OP CASHAPPRECIATION
EQUITY GROWTH (YOY)
TOTAL YEARLY RETURN
CUM. RETURN ON CASH
% improvement over code — TBD
0
45
1$19,800.00$5,157.33$12,566$2,076.93$24,923.1612.16%1$24,923.16$108,500.00$17,983.82$151,406.9873.86%
units meeting standard — TBD
0
46
2$20,295.00$5,260.48$12,566$2,468.78$29,625.4014.45%2$29,625.40$112,297.50$18,772.55$160,695.45152.25%0
47
3$20,802.38$5,365.69$12,566$2,870.95$34,451.3816.81%3$34,451.38$116,227.91$19,595.87$170,275.17235.31%100
48
4$21,322.43$5,473.00$12,566$3,283.69$39,404.3319.22%4$39,404.33$120,295.89$20,455.30$180,155.52323.19%SHORT — rerun at achievable tier
49
5$21,855.50$5,582.46$12,566$3,707.29$44,487.5421.70%5$44,487.54$124,506.25$21,352.42$190,346.21416.04%
50
51
52
ANNUALIZED RATE OF RETURN · assuming sale at end of each year
TAX ASSUMPTIONS
53
YEARCASH INSALE PROCEEDSGAIN ON SALERENTAL PROFITAFTER MORTGAGE PAYBACKTOTAL IN POCKETRETURN ON CASHANNUALIZEDTAX ON RENTCAPITAL GAINTAXABLE GAINCG TAXTOTAL TAXNET PROFITPURE PROFITRETURN RATE
Rental profit tax
30.0%
54
1$205,000$3,208,500$108,500$24,923$129,816$154,73975.5%75.5%$7,477$108,500$54,250$16,275$23,752$130,988($74,012)-36.1%
Cap gains inclusion
50.0%
55
2$205,000$3,320,798$220,798$54,549$260,886$315,435153.9%76.9%$16,365$220,798$110,399$33,120$49,484$265,951$60,95129.7%
Cap gains tax rate
30.0%
56
3$205,000$3,437,025$337,025$89,000$396,710$485,710236.9%79.0%$26,700$337,025$168,513$50,554$77,254$408,456$203,45699.2%
57
4$205,000$3,557,321$457,321$128,404$537,461$665,866324.8%81.2%$38,521$457,321$228,661$68,598$107,119$558,746$353,746172.6%
58
5$205,000$3,681,828$581,828$172,892$683,320$856,212417.7%83.5%$51,868$581,828$290,914$87,274$139,142$717,070$512,070249.8%
59
60
61
MODEL NOTES · what changed from the original sheet
62
COLOUR KEY
Blue on cream = input you can change. Black = formula. Green = subtotal. Dark card = headline result.
63
64
01 OPEX ratio is a sanity check, not a target
Around 30% is where deals should land. It is reported as an output, never solved backwards to. A ratio that drifts is a signal that tax or insurance needs explaining — if it always reads 30% the field carries no information.
65
02 Everything is a formulaNo result is typed in. Change any blue cell and the whole model recalculates, including all three sensitivity tables.
66
03 Interest rate sensitivity — REBUILT
Original was hardcoded to a ~$3.51M principal from an earlier price and showed DSCR 0.89–1.06 while the live model showed 1.16. It said the deal failed CMHC at every rate.
67
04 Purchase price sensitivity — REBUILT
Original was anchored at $3,500,000 and never repointed to $2,800,000.
68
05 Rent sensitivity — REBUILTOriginal showed expenses falling as rent rose, which is impossible when 13% of expenses are a percentage of gross. It was running on a different building.
69
06 Loan balance — CORRECTEDOriginal amortized the base mortgage ($2,660,000) at a payment sized for that base, while cashflow used the payment on the total financed ($2,796,990). Understated debt by the ~$137,000 CMHC premium in every year. The same fault exists in the 69 Ave template.
70
07 Year 5 equity — CORRECTEDOriginal jumped to $65,342 against an ~$18,000 trend.
71
08 Tax block — REALIGNEDOriginal had the capital-gains columns offset one row, producing a −100% return in year 5.
72
09 Cash ROI vs total return — SEPARATED
Both cells previously showed the same cumulative figure. Year-1 cash-on-cash (11.5%) and 3-year total return (231.6%) are different measures.
73
10 Insurance — now $600/door/year, from a real quote
Was a flat $2,000/mo with no stated basis. Now $600/door/yr, derived from an actual binder: $4,200/yr on a 7-plex in Edmonton, September 2026. Scales with door count. The reference building is an existing walk-up; new-build fee-simple townhomes typically insure cheaper, so this is likely conservative.
74
11 Affordable discount — now derived
Original labelled it 10%; $1,650 against $1,850 is 10.8%. S5 now computes the actual discount, which is what CMHC scores.
75
12 MLI Select point score — ADDED
Untested in the original. 95% LTV over 50 years is the top tier and every headline number depends on reaching it. Fill T43:T45 before circulating.
76
13 Monthly rate convention — UNCHANGED
Still annual/12 rather than Canadian semi-annual compounding. Slightly overstates the payment, so the model runs conservative. Retained deliberately to match your existing numbers.
77
14 SourceRebuilt from 'Leduc 10 Units' and 'Stacked Townhomes w/ Garden Suites (69 Ave Edmonton)', supplied by Josh Clark, September 2026. Rent comps as researched September 2026.
78
79
DISCLAIMER: EVERY INVESTMENT INVOLVES RISK, AND ANY PURCHASER OF REAL ESTATE IS RESPONSIBLE FOR THEIR OWN DUE DILIGENCE. NOTHING IS GUARANTEED BY NEW HOMES ALBERTA. ALL FIGURES ARE FOR THE PURPOSES OF ACADEMIC EVALUATION ONLY, AND ANY INTERESTED INVESTOR SHOULD DO THEIR OWN RESEARCH BEFORE MAKING AN INVESTMENT. © New Homes Alberta & Michael Hale. All rights reserved.
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100