ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
64 Units (StreetSide Townhomes) in MICHENER PARK (Edmonton) — 4705 120 St NW (Lot 6 Block 2 Plan 2422229) — Bulk purchase $18.5M — LEASEHOLD
2
CASH COSTSRATETOTAL64 StreetSide townhomes in MICHENER PARK (south-central Edmonton) — 4705 120 St NW
3
Down Payment5%$925,000MLI Select: 25% affordable (16 of 64). All 16 Brooke/Willow 2-bed / 2-bath (952 sf) designated at $1,650 (Joshua's ~$1,650–$1,665 cap; $200/unit below the $1,850 market rent). Confirm the current CMHC Edmonton threshold at application.Projected RentRent# Of UnitsTotal
4
Mortgage Broker Fee1.00%$185,000LEASEHOLD — GROUND RENT IS NOT INCLUDED. 99-year ground lease from University of Alberta Properties Trust; ground rent and lease terms are unknown. At this $18.5M ask and the 25% affordable rent roll, the deal can absorb about $171,700/year ($14,310/mo) of ground rent before DSCR hits 1.10. A no-affordable (all-market $131,300/mo) variant at the same price and assumptions is DSCR ~1.32, cash flow ~$24,765/mo. 34 garage + 53 surface stalls (87 total) are included; no separate parking income.Market 3-bed — Abbey 19 @ $2,150, Bentley 13 @ $2,250, Hazel III 10 @ $2,100$2,16942$91,100
5
CMHC Screening Fee$1,500Market 2-bed — Nero II 5 @ $1,750, Parker 1 @ $1,850$1,7676$10,600
6
Appraisal & Environmental Fee$5,500Affordable — 16 Brooke/Willow 2-bed / 2-bath (952 sf) @ $1,650 (25% of 64)$1,65016$26,400
7
Lender Fee0.75%$138,750Total Rent$128,100
8
Legal Fees$6,000
9
Total Cash Needed$1,261,750
Total Investment
Investor Requirements To Qualify
10
Refund on Closing (if applicable)$0Networth (Assets less Liabilities)25%$4,625,000
11
Total Investment After Refund$1,261,750$18,500,000
12
DEBT SERVICE
Liquidity (Cash, Savings, Lines of Credit, Stocks etc)
10%$1,850,000
13
Loan to Value Ratio95%Monthly Cashflow"CASH" - ROI Yr 3THREE YEAR ROI
14
Mortgage$17,575,000$21,94925.90%254.09%Sensitivity AnalysisMort RateMonthly PaymentYearly MortgageDSCRMonthly Cashflow
15
CMHC Fee5.35%$940,262.50Worst4.90%$82,783$993,4011.19$15,552.94
16
Total Mortgage$18,515,263DSCRNetworth Req'dLiquidity Req'dLittle worse4.65%$79,561$954,7381.24$18,774.86
17
Interest Rate (annual)4.40%1.29$4,625,000$1,850,000BASE RATE4.40%$76,387$916,6491.29$21,948.95
18
Interest Rate (monthly)0.3667%Little Better4.15%$73,264$879,1641.34$25,072.67
19
Amortization period (in years)50Best3.90%$70,193$842,3141.40$28,143.48
20
Monthly Mortgage Payment$76,387
21
OPERATING EXPENSES (Monthly)
22
Property Management5%$6,405.00Sensitivity AnalysisINVESTMENTMonthly MortgageYearly MortgageDSCRMonthly Cashflow
23
Property Tax (flat $129,500/yr = 0.7% of $18,500,000)
$10,792High$19,500,000$80,516$966,1971.22$17,820
24
Insurance (64 units — $675/unit, $43,200/yr)
$3,600$19,000,000$78,452$941,4231.25$19,884
25
Utilities$0
LONG TERM ECONOMICS (estimated)
ASKING PRICE ($18.5M)$18,500,000$76,387$916,6491.29$21,949
26
Repairs & Maintenance3%$3,843.00Initial Value$18,500,000$18,000,000$74,323$891,8741.32$24,013
27
Vacancy4%$5,124.00
Market Growth Rate
3.50%Low$17,500,000$72,258$867,1001.36$26,078
28
Condo Fees$0
Rental Growth Rate
2.50%
29
Other (GROUND RENT NOT INCLUDED — unknown leasehold)$0
Expense Growth Rate
2.00%
30
Total Expenses$29,763.67YearAsset ValueLoan BalanceCash Flow Generated YearlyTotal Equity In PropertyTotal Return On Cash Investedz
31
Rental Income (Monthly)1$19,147,500 $ 17,476,225.57 $ 263,387.41 $1,023,77480.0%
32
Monthly Rent$128,100.002$19,817,663 $ 17,373,016.32 $ 294,674.13 $1,126,984164.7%
33
Net Income (Monthly)3$20,511,281 $ 17,265,173.19 $ 326,778.74 $1,234,827254.1%
34
Estimated Cap Rate (Annual)6.38%4$21,229,176 $ 17,152,488.08 $359,722.39$1,347,512348.4%
35
Estimated Cash Flow$21,9495$21,972,197 $ 17,034,743.58 $393,526.79$1,802,006474.5%
36
37
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 LISTED ON THIS PAGE
38
ARE FOR THE PURPOSES OF ACADEMIC EVALUATION ONLY, AND ANY INTERESTED INVESTOR IS RESPONSIBLE FOR THEIR OWN MODEL ASSUMPTIONS, AND SHOULD DO THEIR OWN RESEARCH AND EVALUATION BEFORE MAKING AN INVESTMENT
39
© New Homes Alberta & Michael Hale. All rights reserved.
40
This document is protected by copyright law. Any reproduction, distribution, or unauthorized use of this content without the express written consent of New Homes Alberta and Michael Hale is strictly prohibited and may result in legal action.
41
42
Cash Flow Calc
Total Returns Calculator
43
Projected Monthly Rental GrowthExpense GrowthMortgage PaymentNet Op Cash (Monthly)Net Op Cash (Yearly)Cash ROI On Money Out of PocketNet Op Cash From RentingHouse Appreciation ValueGrowth In Equity (YoY)Total Yearly ReturnTotal Return Rate on Initial Cash Invested
44
Year 1$128,100.00$29,763.67$76,387$21,948.95$263,387.4120.87%Year 1 $ 263,387.41 $ 647,500.00 $ 98,774.43 $ 1,009,661.84 80.02%
45
Year 2$131,302.50$30,358.94$76,387$24,556.18$294,674.1323.35%Year 2 $ 294,674.13 $ 670,162.50 $ 103,209.25 $ 1,068,045.88 84.65%
46
Year 3$134,585.06$30,966.12$76,387$27,231.56$326,778.7425.90%Year 3 $ 326,778.74 $ 693,618.19 $ 107,843.13 $ 1,128,240.05 89.42%
47
Year 4$137,949.69$31,585.44$76,387$29,976.87$359,722.3928.51%Year 4 $ 359,722.39 $ 717,894.82 $ 112,685.11 $ 1,190,302.32 94.34%
48
Year 5$141,398.43$32,217.15$76,387$32,793.90$393,526.7931.19%Year 5 $ 393,526.79 $ 743,021.14 $ 454,494.50 $ 1,591,042.43 126.10%
49
50
51
Annualized Rate of Return
(Assuming Sales At Different End Of Year Periods)
52
YearInitial Cash InvestmentCash Collected From SaleProfit From Sale of HouseRental Profits (Pre-Tax) (Cash)Profit After Mortgage Payback (Cash)Total Cash In PocketReturn on Initial Cash InvestedAnnualized ROIEstimated Taxes on Rental Profits (30%)Capital GainTaxable Capital GainEstimated Capital Gains TaxTotal TaxesNet Profit (Cash Left In Your Pocket)"Pure Profit" After Removing Initial InvestmentReturn Rate
53
1$1,261,750$19,147,500$647,500$263,387.41$1,671,274$1,934,662153.3%153.3%$79,016.22$647,500$323,750$97,125$176,141$1,758,521$496,77139.4%
54
2$1,261,750$19,817,663$1,317,663$294,674.13$2,444,646$2,739,320217.1%78.1%$88,402.24$1,317,663$658,831$197,649$286,052$2,453,269$1,191,51994.4%
55
3$1,261,750$20,511,281$2,011,281$326,778.74$3,246,107$3,572,886283.2%56.5%$98,033.62$2,011,281$1,005,640$301,692$399,726$3,173,161$1,911,411151.5%
56
4$1,261,750$21,229,176$2,729,176$359,722.39$4,076,687$4,436,410351.6%45.8%$107,916.72$2,729,176$1,364,588$409,376$517,293$3,919,117$2,657,367210.6%
57
5$1,261,750$21,972,197$3,472,197$393,526.79$4,937,453$5,330,980422.5%39.2%$118,058.04$3,472,197$1,736,098$520,829$638,888$4,692,092$3,430,342271.9%
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100