| 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 COSTS | RATE | TOTAL | 64 StreetSide townhomes in MICHENER PARK (south-central Edmonton) — 4705 120 St NW | ||||||||||||||||||||||||
3 | Down Payment | 5% | $925,000 | MLI 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 Rent | Rent | # Of Units | Total | ||||||||||||||||||||
4 | Mortgage Broker Fee | 1.00% | $185,000 | LEASEHOLD — 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,169 | 42 | $91,100 | ||||||||||||||||||||
5 | CMHC Screening Fee | $1,500 | Market 2-bed — Nero II 5 @ $1,750, Parker 1 @ $1,850 | $1,767 | 6 | $10,600 | ||||||||||||||||||||||
6 | Appraisal & Environmental Fee | $5,500 | Affordable — 16 Brooke/Willow 2-bed / 2-bath (952 sf) @ $1,650 (25% of 64) | $1,650 | 16 | $26,400 | ||||||||||||||||||||||
7 | Lender Fee | 0.75% | $138,750 | Total 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) | $0 | Networth (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 Ratio | 95% | Monthly Cashflow | "CASH" - ROI Yr 3 | THREE YEAR ROI | |||||||||||||||||||||||
14 | Mortgage | $17,575,000 | $21,949 | 25.90% | 254.09% | Sensitivity Analysis | Mort Rate | Monthly Payment | Yearly Mortgage | DSCR | Monthly Cashflow | |||||||||||||||||
15 | CMHC Fee | 5.35% | $940,262.50 | Worst | 4.90% | $82,783 | $993,401 | 1.19 | $15,552.94 | |||||||||||||||||||
16 | Total Mortgage | $18,515,263 | DSCR | Networth Req'd | Liquidity Req'd | Little worse | 4.65% | $79,561 | $954,738 | 1.24 | $18,774.86 | |||||||||||||||||
17 | Interest Rate (annual) | 4.40% | 1.29 | $4,625,000 | $1,850,000 | BASE RATE | 4.40% | $76,387 | $916,649 | 1.29 | $21,948.95 | |||||||||||||||||
18 | Interest Rate (monthly) | 0.3667% | Little Better | 4.15% | $73,264 | $879,164 | 1.34 | $25,072.67 | ||||||||||||||||||||
19 | Amortization period (in years) | 50 | Best | 3.90% | $70,193 | $842,314 | 1.40 | $28,143.48 | ||||||||||||||||||||
20 | Monthly Mortgage Payment | $76,387 | ||||||||||||||||||||||||||
21 | OPERATING EXPENSES (Monthly) | |||||||||||||||||||||||||||
22 | Property Management | 5% | $6,405.00 | Sensitivity Analysis | INVESTMENT | Monthly Mortgage | Yearly Mortgage | DSCR | Monthly Cashflow | |||||||||||||||||||
23 | Property Tax (flat $129,500/yr = 0.7% of $18,500,000) | $10,792 | High | $19,500,000 | $80,516 | $966,197 | 1.22 | $17,820 | ||||||||||||||||||||
24 | Insurance (64 units — $675/unit, $43,200/yr) | $3,600 | $19,000,000 | $78,452 | $941,423 | 1.25 | $19,884 | |||||||||||||||||||||
25 | Utilities | $0 | LONG TERM ECONOMICS (estimated) | ASKING PRICE ($18.5M) | $18,500,000 | $76,387 | $916,649 | 1.29 | $21,949 | |||||||||||||||||||
26 | Repairs & Maintenance | 3% | $3,843.00 | Initial Value | $18,500,000 | $18,000,000 | $74,323 | $891,874 | 1.32 | $24,013 | ||||||||||||||||||
27 | Vacancy | 4% | $5,124.00 | Market Growth Rate | 3.50% | Low | $17,500,000 | $72,258 | $867,100 | 1.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.67 | Year | Asset Value | Loan Balance | Cash Flow Generated Yearly | Total Equity In Property | Total Return On Cash Invested | z | |||||||||||||||||||
31 | Rental Income (Monthly) | 1 | $19,147,500 | $ 17,476,225.57 | $ 263,387.41 | $1,023,774 | 80.0% | |||||||||||||||||||||
32 | Monthly Rent | $128,100.00 | 2 | $19,817,663 | $ 17,373,016.32 | $ 294,674.13 | $1,126,984 | 164.7% | ||||||||||||||||||||
33 | Net Income (Monthly) | 3 | $20,511,281 | $ 17,265,173.19 | $ 326,778.74 | $1,234,827 | 254.1% | |||||||||||||||||||||
34 | Estimated Cap Rate (Annual) | 6.38% | 4 | $21,229,176 | $ 17,152,488.08 | $359,722.39 | $1,347,512 | 348.4% | ||||||||||||||||||||
35 | Estimated Cash Flow | $21,949 | 5 | $21,972,197 | $ 17,034,743.58 | $393,526.79 | $1,802,006 | 474.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 Growth | Expense Growth | Mortgage Payment | Net Op Cash (Monthly) | Net Op Cash (Yearly) | Cash ROI On Money Out of Pocket | Net Op Cash From Renting | House Appreciation Value | Growth In Equity (YoY) | Total Yearly Return | Total Return Rate on Initial Cash Invested | |||||||||||||||||
44 | Year 1 | $128,100.00 | $29,763.67 | $76,387 | $21,948.95 | $263,387.41 | 20.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.13 | 23.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.74 | 25.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.39 | 28.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.79 | 31.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 | Year | Initial Cash Investment | Cash Collected From Sale | Profit From Sale of House | Rental Profits (Pre-Tax) (Cash) | Profit After Mortgage Payback (Cash) | Total Cash In Pocket | Return on Initial Cash Invested | Annualized ROI | Estimated Taxes on Rental Profits (30%) | Capital Gain | Taxable Capital Gain | Estimated Capital Gains Tax | Total Taxes | Net Profit (Cash Left In Your Pocket) | "Pure Profit" After Removing Initial Investment | Return Rate | |||||||||||
53 | 1 | $1,261,750 | $19,147,500 | $647,500 | $263,387.41 | $1,671,274 | $1,934,662 | 153.3% | 153.3% | $79,016.22 | $647,500 | $323,750 | $97,125 | $176,141 | $1,758,521 | $496,771 | 39.4% | |||||||||||
54 | 2 | $1,261,750 | $19,817,663 | $1,317,663 | $294,674.13 | $2,444,646 | $2,739,320 | 217.1% | 78.1% | $88,402.24 | $1,317,663 | $658,831 | $197,649 | $286,052 | $2,453,269 | $1,191,519 | 94.4% | |||||||||||
55 | 3 | $1,261,750 | $20,511,281 | $2,011,281 | $326,778.74 | $3,246,107 | $3,572,886 | 283.2% | 56.5% | $98,033.62 | $2,011,281 | $1,005,640 | $301,692 | $399,726 | $3,173,161 | $1,911,411 | 151.5% | |||||||||||
56 | 4 | $1,261,750 | $21,229,176 | $2,729,176 | $359,722.39 | $4,076,687 | $4,436,410 | 351.6% | 45.8% | $107,916.72 | $2,729,176 | $1,364,588 | $409,376 | $517,293 | $3,919,117 | $2,657,367 | 210.6% | |||||||||||
57 | 5 | $1,261,750 | $21,972,197 | $3,472,197 | $393,526.79 | $4,937,453 | $5,330,980 | 422.5% | 39.2% | $118,058.04 | $3,472,197 | $1,736,098 | $520,829 | $638,888 | $4,692,092 | $3,430,342 | 271.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 | ||||||||||||||||||||||||||||