| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | NEW HOMES ALBERTA · LEDUC 10 UNITS · MLI SELECT PROFORMA | ||||||||||||||||||||||||||||
2 | CASH COSTS | RATE | TOTAL | Leduc Stacked | PROJECTED RENT | RENT | UNITS | TOTAL | SITE ROLLUP | BLDG A | BLDG B | BLDG C | SITE | ||||||||||||||||
3 | Down Payment | 5.0% | $155,000 | 5 townhomes stacked — Building C | 3 bed 2.5 bath — primary suite | $2,100 | 5 | $10,500 | Lots | 5 | 6 | 5 | 16 | ||||||||||||||||
4 | Mortgage Broker Fee | 1.00% | $31,000 | Deer Valley Drive at Creekside Circle, Leduc, AB T9E | 2 bed 2.5 bath — secondary | $1,850 | 4 | $7,400 | 3-bed units | 5 | 6 | 5 | 16 | ||||||||||||||||
5 | CMHC Screening Fee | $1,500 | Affordable secondary suite | discount | 10.8% | $1,650 | 1 | $1,650 | 2-bed suites | 5 | 6 | 5 | 16 | ||||||||||||||||
6 | Parking | $50 | 5 | $250 | Total doors | 10 | 12 | 10 | 32 | ||||||||||||||||||||
7 | Appraisal & Environmental | $5,500 | Pet fees / storage / other | — | 0 | — | Bedrooms | 25 | 30 | 25 | 80 | ||||||||||||||||||
8 | Lender Fee | $6,000 | Total Rent | $19,800 | Gross sq ft | 13,756 | 16,735 | 13,784 | 44,275 | ||||||||||||||||||||
9 | Legal Fees | $6,000 | Total legal doors | 10 | Parking | 20 | 24 | 20 | 64 | ||||||||||||||||||||
10 | Total Cash Needed | $205,000 | DEAL SUMMARY | Stalls per lot | 4 | ||||||||||||||||||||||||
11 | Refund on Closing | — | INVESTOR REQUIREMENTS TO QUALIFY | OF PRICE | AMOUNT | ||||||||||||||||||||||||
12 | Total Investment After Refund | $205,000 | PURCHASE PRICE | $3,100,000 | TOTAL FINANCED | $3,096,668 | MONTHLY PAYMENT | $12,566 | Net worth (assets less liabilities) | 25.0% | $775,000 | ||||||||||||||||||
13 | DEBT SERVICE | RATE | TOTAL | Liquidity (cash, savings, LOC, stocks) | 10.0% | $310,000 | |||||||||||||||||||||||
14 | Loan to Value Ratio | 95.0% | DSCR | MONTHLY CASHFLOW | CAP RATE | Total cash to close | $205,000 | ||||||||||||||||||||||
15 | Mortgage | $2,945,000 | 1.17x | $2,077 | 5.67% | ||||||||||||||||||||||||
16 | CMHC Fee | 5.15% | $151,668 | SENSITIVITY · INTEREST RATE rebuilt live from F17 / F18 / F20 | |||||||||||||||||||||||||
17 | Total Mortgage | $3,096,668 | 3-YEAR TOTAL RETURN | YEAR-1 CASH-ON-CASH | OPEX RATIO | SCENARIO | MORT RATE | MONTHLY PAYMENT | YEARLY MORTGAGE | DSCR | |||||||||||||||||||
18 | Interest Rate (annual) | 4.30% | 235.3% | 12.2% | 26.0% | Worst | 4.80% | $13,629 | $163,548 | 1.07x | |||||||||||||||||||
19 | Interest Rate (monthly) | 0.3583% | Little worse | 4.55% | $13,093 | $157,119 | 1.12x | ||||||||||||||||||||||
20 | Amortization (years) | 50 | BASE RATE | 4.30% | $12,566 | $150,789 | 1.17x | ||||||||||||||||||||||
21 | Monthly Mortgage Payment | $12,565.74 | GATE CHECKS | PASS · clears CMHC 1.10 | POINTS SHORT · rerun at achievable tier | Little better | 4.05% | $12,047 | $144,561 | 1.22x | |||||||||||||||||||
22 | OPERATING EXPENSES (Monthly) | RATE | TOTAL | % GROSS | Net worth req'd | $775,000 | Liquidity req'd | $310,000 | Total cash to close | $205,000 | Best | 3.80% | $11,537 | $138,442 | 1.27x | ||||||||||||||
23 | Property Management | 5.0% | $990.00 | ||||||||||||||||||||||||||
24 | Property Tax (annual) | $25,000 | $2,083.33 | SENSITIVITY · PURCHASE PRICE NOI held constant | |||||||||||||||||||||||||
25 | Insurance ($/door/yr) | $600 | $500.00 | LONG TERM ECONOMICS · estimated | SCENARIO | PURCHASE PRICE | TOTAL FINANCED | MONTHLY PAYMENT | DSCR | CASH TO CLOSE | |||||||||||||||||||
26 | Utilities | — | Initial Value | $3,100,000 | +$100K | $3,200,000 | $3,196,560 | $12,971 | 1.13x | $211,000 | |||||||||||||||||||
27 | Repairs & Maintenance | 3.0% | $594.00 | Market Growth Rate | 3.50% | +$50K | $3,150,000 | $3,146,614 | $12,768 | 1.15x | $208,000 | ||||||||||||||||||
28 | Vacancy | 5.0% | $990.00 | Rental Growth Rate | 2.50% | BASE | $3,100,000 | $3,096,668 | $12,566 | 1.17x | $205,000 | ||||||||||||||||||
29 | Condo Fees | — | Expense Growth Rate | 2.00% | −$50K | $3,050,000 | $3,046,721 | $12,363 | 1.18x | $202,000 | |||||||||||||||||||
30 | Other | — | −$100K | $3,000,000 | $2,996,775 | $12,160 | 1.20x | $199,000 | |||||||||||||||||||||
31 | Total Expenses | $5,157.33 | 26.0% | YEAR | ASSET VALUE | LOAN BALANCE | CASHFLOW / YR | EQUITY IN PROPERTY | CUM. RETURN ON CASH | ||||||||||||||||||||
32 | INCOME & RESULTS (Monthly) | 1 | $3,208,500 | $3,078,684 | $24,923 | $172,984 | 73.9% | SENSITIVITY · RENT only the soft line moves | |||||||||||||||||||||
33 | Monthly Rent | $19,800.00 | 2 | $3,320,798 | $3,059,911 | $29,625 | $191,756 | 152.2% | SCENARIO | PRIMARY (HELD) | SECONDARY (SOFT) | TOTAL RENT | TOTAL EXPENSES | DSCR | CASHFLOW/MO | ||||||||||||||
34 | Net Operating Income | $14,642.67 | 3 | $3,437,025 | $3,040,315 | $34,451 | $211,352 | 235.3% | BASE | $2,100 | $1,850 | $19,800 | $5,157 | 1.17x | $2,077 | ||||||||||||||
35 | Net Operating Income (Annual) | $175,712 | 4 | $3,557,321 | $3,019,860 | $39,404 | $231,808 | 323.2% | −$100 | $2,100 | $1,750 | $19,400 | $5,105 | 1.14x | $1,729 | ||||||||||||||
36 | Estimated Cap Rate (Annual) | 5.67% | 5 | $3,681,828 | $2,998,508 | $44,488 | $253,160 | 416.0% | −$200 | $2,100 | $1,650 | $19,000 | $5,053 | 1.11x | $1,381 | ||||||||||||||
37 | Estimated Cash Flow | $2,076.93 | −$300 | $2,100 | $1,550 | $18,600 | $5,001 | 1.08x | $1,033 | ||||||||||||||||||||
38 | DSCR | 1.17x | −$400 | $2,100 | $1,450 | $18,200 | $4,949 | 1.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 | CRITERION | BASIS | POINTS | ||||||||||||||||||||||||||
43 | CASH FLOW CALC | TOTAL RETURNS CALCULATOR | 1 of 10 doors at 10.8% below market | 0 | |||||||||||||||||||||||||
44 | YEAR | MONTHLY RENT | MONTHLY EXPENSES | MORTGAGE | NET OP CASH / MO | NET OP CASH / YR | CASH ROI ON CASH OUT | YEAR | NET OP CASH | APPRECIATION | 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.16 | 12.16% | 1 | $24,923.16 | $108,500.00 | $17,983.82 | $151,406.98 | 73.86% | units meeting standard — TBD | 0 | ||||||||||||||
46 | 2 | $20,295.00 | $5,260.48 | $12,566 | $2,468.78 | $29,625.40 | 14.45% | 2 | $29,625.40 | $112,297.50 | $18,772.55 | $160,695.45 | 152.25% | 0 | |||||||||||||||
47 | 3 | $20,802.38 | $5,365.69 | $12,566 | $2,870.95 | $34,451.38 | 16.81% | 3 | $34,451.38 | $116,227.91 | $19,595.87 | $170,275.17 | 235.31% | 100 | |||||||||||||||
48 | 4 | $21,322.43 | $5,473.00 | $12,566 | $3,283.69 | $39,404.33 | 19.22% | 4 | $39,404.33 | $120,295.89 | $20,455.30 | $180,155.52 | 323.19% | SHORT — rerun at achievable tier | |||||||||||||||
49 | 5 | $21,855.50 | $5,582.46 | $12,566 | $3,707.29 | $44,487.54 | 21.70% | 5 | $44,487.54 | $124,506.25 | $21,352.42 | $190,346.21 | 416.04% | ||||||||||||||||
50 | |||||||||||||||||||||||||||||
51 | |||||||||||||||||||||||||||||
52 | ANNUALIZED RATE OF RETURN · assuming sale at end of each year | TAX ASSUMPTIONS | |||||||||||||||||||||||||||
53 | YEAR | CASH IN | SALE PROCEEDS | GAIN ON SALE | RENTAL PROFIT | AFTER MORTGAGE PAYBACK | TOTAL IN POCKET | RETURN ON CASH | ANNUALIZED | TAX ON RENT | CAPITAL GAIN | TAXABLE GAIN | CG TAX | TOTAL TAX | NET PROFIT | PURE PROFIT | RETURN RATE | Rental profit tax | 30.0% | ||||||||||
54 | 1 | $205,000 | $3,208,500 | $108,500 | $24,923 | $129,816 | $154,739 | 75.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,435 | 153.9% | 76.9% | $16,365 | $220,798 | $110,399 | $33,120 | $49,484 | $265,951 | $60,951 | 29.7% | Cap gains tax rate | 30.0% | ||||||||||
56 | 3 | $205,000 | $3,437,025 | $337,025 | $89,000 | $396,710 | $485,710 | 236.9% | 79.0% | $26,700 | $337,025 | $168,513 | $50,554 | $77,254 | $408,456 | $203,456 | 99.2% | ||||||||||||
57 | 4 | $205,000 | $3,557,321 | $457,321 | $128,404 | $537,461 | $665,866 | 324.8% | 81.2% | $38,521 | $457,321 | $228,661 | $68,598 | $107,119 | $558,746 | $353,746 | 172.6% | ||||||||||||
58 | 5 | $205,000 | $3,681,828 | $581,828 | $172,892 | $683,320 | $856,212 | 417.7% | 83.5% | $51,868 | $581,828 | $290,914 | $87,274 | $139,142 | $717,070 | $512,070 | 249.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 formula | No 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 — REBUILT | Original 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 — CORRECTED | Original 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 — CORRECTED | Original jumped to $65,342 against an ~$18,000 trend. | |||||||||||||||||||||||||||
71 | 08 Tax block — REALIGNED | Original 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 Source | Rebuilt 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 | |||||||||||||||||||||||||||||