ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
2
CASH COSTSRATETOTAL
13012 120 Street NW Edmonton
3
Down Payment5%$90,000
Projected Rent
Rent# Of UnitsTotal
4
Mortgage Broker Fee (adding to price)
0.85%$15,300
~1267 SqFt - 3 Bed 2.5 Bath Upper
Upper Floor - 3 Bed 2.5 Bath
$1,9004$7,600
5
CMHC Screening Fee$1,500
~487 SqFt - 1Bed 1 Bath Legal Suites
Basement Suite - 2 Bed 1 Bath
$1,0004$4,000
6
Appraisal & Environmental Fee$5,500Garage$04$0
7
Lender Fee0.75%$13,500Total Rent$11,600
8
Legal Fees$6,000
9
Total Cash Needed$131,800
Total Investment
Investor Requirements To Qualify
10
Refund on Closing (if applicable)$0
Networth (Assets less Liabilities)
25%$450,000
11
Total Investment After Refund$131,800$1,800,000
12
DEBT SERVICE
Liquidity (Cash, Savings, Lines of Credit, Stocks etc)
10%$180,000
13
Loan to Value Ratio95%Monthly Cashflow"CASH" - ROI Yr 3THREE YEAR ROI
14
Mortgage$1,710,000$1,01913.38%206.81%
Sensitivity Analysis
Mort RateMonthly PaymentYearly MortgageDSCRMonthly Cashflow
15
CMHC Fee5.35%$91,485.00Worst4.50%$11,570$138,8400.71
16
Total Mortgage$1,801,485DSCRNetworth Req'dLiquidity Req'dLittle worse4.25%$11,102$133,2240.74
17
Interest Rate (annual)4.20%1.14$450,000$180,000BASE RATE4.00%$10,641$127,6920.77
18
Interest Rate (monthly)0.3500%Little Better3.75%$10,188$122,2560.81
19
Amortization period (in years)50Best3.50%$9,744$116,9280.84
20
Monthly Mortgage Payment$7,189
21
OPERATING EXPENSES (Monthly)
22
Property Management5%$580.00
Sensitivity Analysis
INVESTMENTMonthly MortgageYearly MortgageDSCRMonthly Cashflow
23
Property Tax (estimated $19k / year)
$1,500
ASKING PRICE
$2,950,000$12,009$144,1080.68
24
Insurance (landlord insurance)$500$2,900,000$11,805$141,6600.70
25
Utilities$0
LONG TERM ECONOMICS (estimated)
$2,850,000$11,602$139,2240.71
26
Repairs & Maintenance3%$348.00Initial Value$1,800,000$2,800,000$11,398$136,7760.72
27
Vacancy4%$464.00
Market Growth Rate
3.50%$2,750,000$11,195$134,3400.73
28
Condo Fees$0
Rental Growth Rate
2.50%
29
Other$0
Expense Growth Rate
2.00%
30
Total Expenses$3,392.00YearAsset ValueLoan BalanceCash Flow Generated YearlyTotal Equity In PropertyTotal Return On Cash Invested
31
Rental Income (Monthly)1$1,863,000 $ 1,699,739.95 $ 12,231.14 $100,26064.9%
32
Monthly Rent$11,600.002$1,928,205 $ 1,689,040.58 $ 14,897.06 $110,959133.8%
33
Net Income (Monthly)3$1,995,692 $ 1,677,883.09 $ 17,633.70 $122,117206.8%
34
Estimated Cap Rate (Annual)5.47%4$2,065,541 $ 1,666,247.85 $20,442.91$133,752284.1%
35
Estimated Cash Flow$1,0195$2,137,835 $ 1,654,114.42 $23,326.58$187,686397.6%
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$11,600.00$3,392.00$7,189$1,019.26$12,231.149.28%Year 1 $ 12,231.14 $ 63,000.00 $ 10,260.05 $ 85,491.19 64.86%
45
Year 2$11,890.00$3,459.84$7,189$1,241.42$14,897.0611.30%Year 2 $ 14,897.06 $ 65,205.00 $ 10,699.37 $ 90,801.43 68.89%
46
Year 3$12,187.25$3,529.04$7,189$1,469.47$17,633.7013.38%Year 3 $ 17,633.70 $ 67,487.17 $ 11,157.49 $ 96,278.36 73.05%
47
Year 4$12,491.93$3,599.62$7,189$1,703.58$20,442.9115.51%Year 4 $ 20,442.91 $ 69,849.23 $ 11,635.24 $ 101,927.37 77.33%
48
Year 5$12,804.23$3,671.61$7,189$1,943.88$23,326.5817.70%Year 5 $ 23,326.58 $ 72,293.95 $ 53,933.43 $ 149,553.96 113.47%
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$131,800$1,863,000$63,000$12,231.14$163,260$175,491133.1%133.1%$3,669.34$63,000$31,500$9,450$13,119$162,372$30,57223.2%
54
2$131,800$1,928,205$128,205$14,897.06$239,164$254,061192.8%71.1%$4,469.12$128,205$64,102$19,231$23,700$230,362$98,56274.8%
55
3$131,800$1,995,692$195,692$17,633.70$317,809$335,443254.5%52.5%$5,290.11$195,692$97,846$29,354$34,644$300,799$168,999128.2%
56
4$131,800$2,065,541$265,541$20,442.91$399,294$419,736318.5%43.0%$6,132.87$265,541$132,771$39,831$45,964$373,772$241,972183.6%
57
5$131,800$2,137,835$337,835$23,326.58$483,721$507,048384.7%37.1%$6,997.97$337,835$168,918$50,675$57,673$449,374$317,574241.0%
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