| 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 | Spruce Ave 8 plex | ||||||||||||||||||||||||
3 | Down Payment | 5% | $108,650 | Projected Rent | Rent | # Of Units | Total | |||||||||||||||||||||
4 | Mortgage Broker Fee | 0.85% | $18,471 | ~1332 SqFt - 3 Bed 2 Bath Upper | Upper Floor - 3 Bed 2 Bath | $2,050 | 4 | $8,200 | ||||||||||||||||||||
5 | CMHC Screening Fee | $1,500 | ~ 725 SqFt - 2 Bed 1 Bath Legal Suites | Basement Suite - 2 Bed 1 Bath | $1,350 | 4 | $5,400 | |||||||||||||||||||||
6 | Appraisal & Environmental Fee | $5,500 | Pads | $50 | 4 | $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 Rebate | 5% | $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 SERVICE | Monthly Cashflow | "CASH" - ROI Yr 3 | THREE YEAR ROI | ||||||||||||||||||||||||
14 | Loan to Value Ratio | 95% | $1,107 | 63.02% | 1025.92% | Sensitivity Analysis | Mort Rate | Monthly Payment | Yearly Mortgage | DSCR | Monthly Cashflow | |||||||||||||||||
15 | Mortgage | $2,064,350 | Worst | 4.50% | $11,570 | $138,840 | 0.86 | |||||||||||||||||||||
16 | CMHC Fee | 5.35% | $110,442.73 | DSCR | Networth Req'd | Liquidity Req'd | Little worse | 4.25% | $11,102 | $133,224 | 0.90 | |||||||||||||||||
17 | Total Mortgage | $2,174,793 | 1.12 | $543,250 | $217,300 | BASE RATE | 4.00% | $10,641 | $127,692 | 0.94 | ||||||||||||||||||
18 | Interest Rate (annual) | 4.35% | Little Better | 3.75% | $10,188 | $122,256 | 0.98 | |||||||||||||||||||||
19 | Interest Rate (monthly) | 0.3625% | Best | 3.50% | $9,744 | $116,928 | 1.03 | |||||||||||||||||||||
20 | Amortization period (in years) | 50 | ||||||||||||||||||||||||||
21 | Monthly Mortgage Payment | $8,899 | True Purchase Price | 2,060,000 | Lender Fee | 10,000 | ||||||||||||||||||||||
22 | OPERATING EXPENSES (Monthly) | GST 5% | 103000 | Sensitivity Analysis | INVESTMENT | Monthly Mortgage | Yearly Mortgage | DSCR | Monthly Cashflow | |||||||||||||||||||
23 | Property Management | 5% | $690.00 | Purchase Price | 2,163,000 | ASKING PRICE | $2,950,000 | $12,009 | $144,108 | 0.83 | ||||||||||||||||||
24 | Property Tax (estimated $19k / year) | $1,500 | $2,900,000 | $11,805 | $141,660 | 0.85 | ||||||||||||||||||||||
25 | Insurance (landlord insurance) | $500 | LONG TERM ECONOMICS (estimated) | $2,850,000 | $11,602 | $139,224 | 0.86 | |||||||||||||||||||||
26 | Utilities | $0 | Initial Value | $2,173,000 | $2,800,000 | $11,398 | $136,776 | 0.88 | ||||||||||||||||||||
27 | Repairs & Maintenance | 3% | $414.00 | Market Growth Rate | 3.50% | $2,750,000 | $11,195 | $134,340 | 0.89 | |||||||||||||||||||
28 | Vacancy | 5% | $690.00 | Rental Growth Rate | 2.50% | |||||||||||||||||||||||
29 | Condo Fees | $0 | Expense Growth Rate | 2.00% | ||||||||||||||||||||||||
30 | Other | $0 | Year | Asset Value | Loan Balance | Cash Flow Generated Yearly | Total Equity In Property | Total Return On Cash Invested | ||||||||||||||||||||
31 | Total Expenses | $3,794.00 | 1 | $2,249,055 | $ 2,052,556.00 | $ 13,289.33 | $120,444 | 321.4% | ||||||||||||||||||||
32 | Rental Income (Monthly) | 2 | $2,327,772 | $ 2,040,238.62 | $ 16,518.77 | $132,761 | 663.1% | |||||||||||||||||||||
33 | Monthly Rent | $13,800.00 | 3 | $2,409,244 | $ 2,027,374.62 | $ 19,833.50 | $145,625 | 1025.9% | ||||||||||||||||||||
34 | Net Income (Monthly) | 4 | $2,493,567 | $ 2,013,939.74 | $23,235.74 | $159,060 | 1410.4% | |||||||||||||||||||||
35 | Estimated Cap Rate (Annual) | 5.53% | 5 | $2,580,842 | $ 1,999,908.65 | $26,727.78 | $204,562 | 1917.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 Calc | 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 | Projected Monthly Rental Growth | Expense Growth | Mortgage Payment | $1,107.44 | $13,289.33 | 42.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.77 | 52.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.50 | 63.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.74 | 73.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.78 | 84.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 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 | Initial Cash Investment | Cash Collected From Sale | Profit From Sale of House | $13,289.33 | $196,499 | $209,788 | 149.7% | 149.7% | $3,986.80 | $76,055 | $38,028 | $11,408 | $15,395 | $194,393 | $54,273 | 38.7% | |||||||||||
54 | 2 | $140,121 | $2,249,055 | $76,055 | $16,518.77 | $287,533 | $304,052 | 217.0% | 78.0% | $4,955.63 | $154,772 | $77,386 | $23,216 | $28,171 | $275,881 | $135,760 | 96.9% | |||||||||||
55 | 3 | $140,121 | $2,327,772 | $154,772 | $19,833.50 | $381,869 | $401,703 | 286.7% | 57.0% | $5,950.05 | $236,244 | $118,122 | $35,437 | $41,387 | $360,316 | $220,196 | 157.1% | |||||||||||
56 | 4 | $140,121 | $2,409,244 | $236,244 | $23,235.74 | $479,628 | $502,863 | 358.9% | 46.4% | $6,970.72 | $320,567 | $160,284 | $48,085 | $55,056 | $447,808 | $307,687 | 219.6% | |||||||||||
57 | 5 | $140,121 | $2,493,567 | $320,567 | $26,727.78 | $580,934 | $607,661 | 433.7% | 39.8% | $8,018.33 | $407,842 | $203,921 | $61,176 | $69,195 | $538,467 | $398,346 | 284.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 | ||||||||||||||||||||||||||||