ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
2
CASH COSTSRATETOTAL
Spruce Ave 8 plex
3
Down Payment5%$108,650
Projected Rent
Rent# Of UnitsTotal
4
Mortgage Broker Fee 0.85%$18,471
~1332 SqFt - 3 Bed 2 Bath Upper
Upper Floor - 3 Bed 2 Bath
$2,0504$8,200
5
CMHC Screening Fee$1,500
~ 725 SqFt - 2 Bed 1 Bath Legal Suites
Basement Suite - 2 Bed 1 Bath
$1,3504$5,400
6
Appraisal & Environmental Fee$5,500Pads$504$200
7
Total Rent$13,800
8
Legal Fees$6,000
9
Total Cash Needed$140,121
Total Investment
Investor Requirements To Qualify
10
Lender Fee - Covered by builder$10,000
Networth (Assets less Liabilities)
25%$543,250
11
GST Rebate5%$108,650$2,173,000
12
Total Investment After Refund$31,471
Liquidity (Cash, Savings, Lines of Credit, Stocks etc)
10%$217,300
13
DEBT SERVICEMonthly Cashflow"CASH" - ROI Yr 3THREE YEAR ROI
14
Loan to Value Ratio95%$1,10763.02%1025.92%
Sensitivity Analysis
Mort RateMonthly PaymentYearly MortgageDSCRMonthly Cashflow
15
Mortgage$2,064,350Worst4.50%$11,570$138,8400.86
16
CMHC Fee5.35%$110,442.73DSCRNetworth Req'dLiquidity Req'dLittle worse4.25%$11,102$133,2240.90
17
Total Mortgage$2,174,7931.12$543,250$217,300BASE RATE4.00%$10,641$127,6920.94
18
Interest Rate (annual)4.35%Little Better3.75%$10,188$122,2560.98
19
Interest Rate (monthly)0.3625%Best3.50%$9,744$116,9281.03
20
Amortization period (in years)50
21
Monthly Mortgage Payment$8,899
True Purchase Price
2,060,000Lender Fee10,000
22
OPERATING EXPENSES (Monthly)
GST 5%103000
Sensitivity Analysis
INVESTMENTMonthly MortgageYearly MortgageDSCRMonthly Cashflow
23
Property Management5%$690.00
Purchase Price
2,163,000
ASKING PRICE
$2,950,000$12,009$144,1080.83
24
Property Tax (estimated $19k / year)
$1,500$2,900,000$11,805$141,6600.85
25
Insurance (landlord insurance)$500
LONG TERM ECONOMICS (estimated)
$2,850,000$11,602$139,2240.86
26
Utilities$0Initial Value$2,173,000$2,800,000$11,398$136,7760.88
27
Repairs & Maintenance3%$414.00
Market Growth Rate
3.50%$2,750,000$11,195$134,3400.89
28
Vacancy5%$690.00
Rental Growth Rate
2.50%
29
Condo Fees$0
Expense Growth Rate
2.00%
30
Other$0YearAsset ValueLoan BalanceCash Flow Generated YearlyTotal Equity In PropertyTotal Return On Cash Invested
31
Total Expenses$3,794.001$2,249,055 $ 2,052,556.00 $ 13,289.33 $120,444321.4%
32
Rental Income (Monthly)2$2,327,772 $ 2,040,238.62 $ 16,518.77 $132,761663.1%
33
Monthly Rent$13,800.003$2,409,244 $ 2,027,374.62 $ 19,833.50 $145,6251025.9%
34
Net Income (Monthly)4$2,493,567 $ 2,013,939.74 $23,235.74$159,0601410.4%
35
Estimated Cap Rate (Annual)5.53%5$2,580,842 $ 1,999,908.65 $26,727.78$204,5621917.2%
36
Estimated Cash Flow$1,107
37
38
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
39
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
40
© New Homes Alberta & Michael Hale. All rights reserved.
41
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.
42
Total Returns Calculator
43
Cash Flow CalcNet 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 1Projected Monthly Rental GrowthExpense GrowthMortgage Payment$1,107.44$13,289.3342.23%Year 1 $ 13,289.33 $ 76,055.00 $ 11,794.00 $ 101,138.33 321.38%
45
Year 2$13,800.00$3,794.00$8,899$1,376.56$16,518.7752.49%Year 2 $ 16,518.77 $ 78,716.92 $ 12,317.38 $ 107,553.08 341.76%
46
Year 3$14,145.00$3,869.88$8,899$1,652.79$19,833.5063.02%Year 3 $ 19,833.50 $ 81,472.02 $ 12,864.00 $ 114,169.52 362.78%
47
Year 4$14,498.63$3,947.28$8,899$1,936.31$23,235.7473.83%Year 4 $ 23,235.74 $ 84,323.54 $ 13,434.88 $ 120,994.16 384.47%
48
Year 5$14,861.09$4,026.22$8,899$2,227.31$26,727.7884.93%Year 5 $ 26,727.78 $ 87,274.86 $ 45,501.59 $ 159,504.23 506.84%
49
$15,232.62$4,106.75$8,899
50
51
52
Year
Annualized Rate of Return
(Assuming Sales At Different End Of Year Periods)
Rental 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
1Initial Cash InvestmentCash Collected From SaleProfit From Sale of House$13,289.33$196,499$209,788149.7%149.7%$3,986.80$76,055$38,028$11,408$15,395$194,393$54,27338.7%
54
2$140,121$2,249,055$76,055$16,518.77$287,533$304,052217.0%78.0%$4,955.63$154,772$77,386$23,216$28,171$275,881$135,76096.9%
55
3$140,121$2,327,772$154,772$19,833.50$381,869$401,703286.7%57.0%$5,950.05$236,244$118,122$35,437$41,387$360,316$220,196157.1%
56
4$140,121$2,409,244$236,244$23,235.74$479,628$502,863358.9%46.4%$6,970.72$320,567$160,284$48,085$55,056$447,808$307,687219.6%
57
5$140,121$2,493,567$320,567$26,727.78$580,934$607,661433.7%39.8%$8,018.33$407,842$203,921$61,176$69,195$538,467$398,346284.3%
58
$140,121$2,580,842$407,842
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