ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
2
CASH COSTSRATETOTAL
Stacked Townhomes
3
Down Payment5%$90,000
Projected Rent
Rent# Of UnitsTotal
4
Mortgage Broker Fee1%$18,000
Confirm SqFt - 2 Bedroom - 1 Bathroom Basement
Main Units$2,3002$4,600
5
Confirm SqFt - 4 Bedroom 3.5 Bathroom - Main Unit (Upper)
Basement Units
$1,3752$2,750
6
CMHC Screening Fee$1,500
Confirm SqFt - 2 Bedroom 1 Bathroom - Garage Suite
Garage Units$1,7352$3,470
7
8
Appraisal & Environmental Fee$5,500Parking Pad$753$225
9
Lender Fee$3,000Total Rent$11,045
10
Legal Fees$6,000
11
Total Cash Needed$124,000
Total Investment
Investor Requirements To Qualify
12
Refund on Closing (if applicable)$0
Networth (Assets less Liabilities)
25%$450,000
13
Total Investment After Refund$124,000$1,800,000
14
DEBT SERVICE
Liquidity (Cash, Savings, Lines of Credit, Stocks etc)
10%$180,000
15
Loan to Value Ratio95%Monthly Cashflow"CASH" - ROI Yr 3THREE YEAR ROI
16
Mortgage$1,710,000$5379.41%204.01%
17
CMHC Fee5.35%$91,485.00
18
Total Mortgage$1,801,485DSCRNetworth Req'dLiquidity Req'd
19
Interest Rate (annual)4.40%1.07$450,000$180,000
20
Interest Rate (monthly)0.3667%
21
Amortization period (in years)50
22
Monthly Mortgage Payment$7,432
23
OPERATING EXPENSES (Monthly)
24
Property Management5%$552.25
25
Property Tax (estimated annual)$15,000$1,250
26
Insurance (landlord insurance)$500
27
Utilities$0
LONG TERM ECONOMICS (estimated)
28
Repairs & Maintenance3%$331.35Initial Value$1,800,000
29
Vacancy4%$441.80
Market Growth Rate
3.50%
30
Condo Fees$0
Rental Growth Rate
2.50%
31
Other$0
Expense Growth Rate
2.00%
32
Total Expenses$3,075.40YearAsset ValueLoan BalanceCash Flow Generated YearlyTotal Equity In PropertyTotal Return On Cash Invested
33
Rental Income (Monthly)1$1,863,000 $ 1,700,389.52 $ 6,447.77 $99,61063.8%
34
Monthly Rent$11,045.002$1,928,205 $ 1,690,347.55 $ 9,023.17 $109,652131.7%
35
Net Income (Monthly)3$1,995,692 $ 1,679,854.72 $ 11,666.65 $120,145204.0%
36
Estimated Cap Rate (Annual)5.31%4$2,065,541 $ 1,668,890.76 $14,379.98$131,109280.8%
37
Estimated Cash Flow$5375$2,137,835 $ 1,657,434.57 $17,164.99$176,565389.6%
38
39
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
40
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
41
© New Homes Alberta & Michael Hale. All rights reserved.
42
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.
43
44
Cash Flow Calc
Total Returns Calculator
45
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
46
Year 1$11,045.00$3,075.40$7,432$537.31$6,447.775.20%Year 1 $ 6,447.77 $ 63,000.00 $ 9,610.48 $ 79,058.25 63.76%
47
Year 2$11,321.13$3,136.91$7,432$751.93$9,023.177.28%Year 2 $ 9,023.17 $ 65,205.00 $ 10,041.97 $ 84,270.14 67.96%
48
Year 3$11,604.15$3,199.65$7,432$972.22$11,666.659.41%Year 3 $ 11,666.65 $ 67,487.17 $ 10,492.83 $ 89,646.66 72.30%
49
Year 4$11,894.26$3,263.64$7,432$1,198.33$14,379.9811.60%Year 4 $ 14,379.98 $ 69,849.23 $ 10,963.96 $ 95,193.17 76.77%
50
Year 5$12,191.61$3,328.91$7,432$1,430.42$17,164.9913.84%Year 5 $ 17,164.99 $ 72,293.95 $ 45,456.19 $ 134,915.13 108.80%
51
52
53
Annualized Rate of Return
(Assuming Sales At Different End Of Year Periods)
54
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
55
1$124,000$1,863,000$63,000$6,447.77$162,610$169,058136.3%136.3%$1,934.33$63,000$31,500$9,450$11,384$157,674$33,67427.2%
56
2$124,000$1,928,205$128,205$9,023.17$237,857$246,881199.1%72.9%$2,706.95$128,205$64,102$19,231$21,938$224,943$100,94381.4%
57
3$124,000$1,995,692$195,692$11,666.65$315,837$327,504264.1%53.8%$3,500.00$195,692$97,846$29,354$32,854$294,650$170,650137.6%
58
4$124,000$2,065,541$265,541$14,379.98$396,651$411,031331.5%44.1%$4,314.00$265,541$132,771$39,831$44,145$366,885$242,885195.9%
59
5$124,000$2,137,835$337,835$17,164.99$480,401$497,566401.3%38.0%$5,149.50$337,835$168,918$50,675$55,825$441,741$317,741256.2%
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