| 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 | ||||||||||||||||||||||||||||
2 | CASH COSTS | RATE | TOTAL | 14807 80 Ave NW Edmonton | ||||||||||||||||||||||||
3 | Down Payment | 5% | $130,000 | Projected Rent | Rent | # Of Units | Total | |||||||||||||||||||||
4 | Mortgage Broker Fee (adding to price) | 0.85% | $22,100 | ~1650 SqFt - 3 Bed 2.5 Bath Upper | Upper Floor - 3 Bed 2.5 Bath | $2,000 | 4 | $8,000 | ||||||||||||||||||||
5 | CMHC Screening Fee | $1,500 | ~608 SqFt - 2Bed 1 Bath Legal Suites | Basement Suite - 2 Bed 1 Bath | $2,000 | 4 | $8,000 | |||||||||||||||||||||
6 | Appraisal & Environmental Fee | $5,500 | Garage | $100 | 4 | $400 | ||||||||||||||||||||||
7 | Lender Fee | 0.75% | $19,500 | Total Rent | $16,400 | |||||||||||||||||||||||
8 | Legal Fees | $6,000 | ||||||||||||||||||||||||||
9 | Total Cash Needed | $184,600 | Total Investment | Investor Requirements To Qualify | ||||||||||||||||||||||||
10 | Refund on Closing (if applicable) | $0 | Networth (Assets less Liabilities) | 25% | $650,000 | |||||||||||||||||||||||
11 | Total Investment After Refund | $184,600 | $2,600,000 | |||||||||||||||||||||||||
12 | DEBT SERVICE | Liquidity (Cash, Savings, Lines of Credit, Stocks etc) | 10% | $260,000 | ||||||||||||||||||||||||
13 | Loan to Value Ratio | 95% | Monthly Cashflow | "CASH" - ROI Yr 3 | THREE YEAR ROI | |||||||||||||||||||||||
14 | Mortgage | $2,470,000 | $2,048 | 17.67% | 224.70% | Sensitivity Analysis | Mort Rate | Monthly Payment | Yearly Mortgage | DSCR | Monthly Cashflow | |||||||||||||||||
15 | CMHC Fee | 5.35% | $132,145.00 | Worst | 4.50% | $11,570 | $138,840 | 1.07 | ||||||||||||||||||||
16 | Total Mortgage | $2,602,145 | DSCR | Networth Req'd | Liquidity Req'd | Little worse | 4.25% | $11,102 | $133,224 | 1.12 | ||||||||||||||||||
17 | Interest Rate (annual) | 4.20% | 1.20 | $650,000 | $260,000 | BASE RATE | 4.00% | $10,641 | $127,692 | 1.17 | ||||||||||||||||||
18 | Interest Rate (monthly) | 0.3500% | Little Better | 3.75% | $10,188 | $122,256 | 1.22 | |||||||||||||||||||||
19 | Amortization period (in years) | 50 | Best | 3.50% | $9,744 | $116,928 | 1.28 | |||||||||||||||||||||
20 | Monthly Mortgage Payment | $10,384 | ||||||||||||||||||||||||||
21 | OPERATING EXPENSES (Monthly) | |||||||||||||||||||||||||||
22 | Property Management | 5% | $820.00 | Sensitivity Analysis | INVESTMENT | Monthly Mortgage | Yearly Mortgage | DSCR | Monthly Cashflow | |||||||||||||||||||
23 | Property Tax (estimated $19k / year) | $1,500 | ASKING PRICE | $2,950,000 | $12,009 | $144,108 | 1.04 | |||||||||||||||||||||
24 | Insurance (landlord insurance) | $500 | $2,900,000 | $11,805 | $141,660 | 1.05 | ||||||||||||||||||||||
25 | Utilities | $0 | LONG TERM ECONOMICS (estimated) | $2,850,000 | $11,602 | $139,224 | 1.07 | |||||||||||||||||||||
26 | Repairs & Maintenance | 3% | $492.00 | Initial Value | $2,600,000 | $2,800,000 | $11,398 | $136,776 | 1.09 | |||||||||||||||||||
27 | Vacancy | 4% | $656.00 | Market Growth Rate | 3.50% | $2,750,000 | $11,195 | $134,340 | 1.11 | |||||||||||||||||||
28 | Condo Fees | $0 | Rental Growth Rate | 2.50% | ||||||||||||||||||||||||
29 | Other | $0 | Expense Growth Rate | 2.00% | ||||||||||||||||||||||||
30 | Total Expenses | $3,968.00 | Year | Asset Value | Loan Balance | Cash Flow Generated Yearly | Total Equity In Property | Total Return On Cash Invested | ||||||||||||||||||||
31 | Rental Income (Monthly) | 1 | $2,691,000 | $ 2,455,179.97 | $ 24,579.20 | $144,820 | 70.6% | |||||||||||||||||||||
32 | Monthly Rent | $16,400.00 | 2 | $2,785,185 | $ 2,439,725.35 | $ 28,546.88 | $160,275 | 145.5% | ||||||||||||||||||||
33 | Net Income (Monthly) | 3 | $2,882,666 | $ 2,423,609.01 | $ 32,618.52 | $176,391 | 224.7% | |||||||||||||||||||||
34 | Estimated Cap Rate (Annual) | 5.74% | 4 | $2,983,560 | $ 2,406,802.60 | $36,796.80 | $193,197 | 308.4% | ||||||||||||||||||||
35 | Estimated Cash Flow | $2,048 | 5 | $3,087,984 | $ 2,389,276.57 | $41,084.49 | $265,323 | 426.3% | ||||||||||||||||||||
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 | $16,400.00 | $3,968.00 | $10,384 | $2,048.27 | $24,579.20 | 13.31% | Year 1 | $ 24,579.20 | $ 91,000.00 | $ 14,820.03 | $ 130,399.23 | 70.64% | |||||||||||||||
45 | Year 2 | $16,810.00 | $4,047.36 | $10,384 | $2,378.91 | $28,546.88 | 15.46% | Year 2 | $ 28,546.88 | $ 94,185.00 | $ 15,454.62 | $ 138,186.50 | 74.86% | |||||||||||||||
46 | Year 3 | $17,230.25 | $4,128.31 | $10,384 | $2,718.21 | $32,618.52 | 17.67% | Year 3 | $ 32,618.52 | $ 97,481.47 | $ 16,116.34 | $ 146,216.33 | 79.21% | |||||||||||||||
47 | Year 4 | $17,661.01 | $4,210.87 | $10,384 | $3,066.40 | $36,796.80 | 19.93% | Year 4 | $ 36,796.80 | $ 100,893.33 | $ 16,806.41 | $ 154,496.54 | 83.69% | |||||||||||||||
48 | Year 5 | $18,102.53 | $4,295.09 | $10,384 | $3,423.71 | $41,084.49 | 22.26% | Year 5 | $ 41,084.49 | $ 104,424.59 | $ 72,126.03 | $ 217,635.11 | 117.90% | |||||||||||||||
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 | $184,600 | $2,691,000 | $91,000 | $24,579.20 | $235,820 | $260,399 | 141.1% | 141.1% | $7,373.76 | $91,000 | $45,500 | $13,650 | $21,024 | $239,375 | $54,775 | 29.7% | |||||||||||
54 | 2 | $184,600 | $2,785,185 | $185,185 | $28,546.88 | $345,460 | $374,007 | 202.6% | 74.0% | $8,564.07 | $185,185 | $92,593 | $27,778 | $36,342 | $337,665 | $153,065 | 82.9% | |||||||||||
55 | 3 | $184,600 | $2,882,666 | $282,666 | $32,618.52 | $459,057 | $491,676 | 266.3% | 54.2% | $9,785.56 | $282,666 | $141,333 | $42,400 | $52,186 | $439,490 | $254,890 | 138.1% | |||||||||||
56 | 4 | $184,600 | $2,983,560 | $383,560 | $36,796.80 | $576,757 | $613,554 | 332.4% | 44.2% | $11,039.04 | $383,560 | $191,780 | $57,534 | $68,573 | $544,981 | $360,381 | 195.2% | |||||||||||
57 | 5 | $184,600 | $3,087,984 | $487,984 | $41,084.49 | $698,708 | $739,792 | 400.8% | 38.0% | $12,325.35 | $487,984 | $243,992 | $73,198 | $85,523 | $654,269 | $469,669 | 254.4% | |||||||||||
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 | ||||||||||||||||||||||||||||