| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | |||||||
2 | Building Cost | Amount | Monthly | Yearly | |||
3 | |||||||
4 | Building Cost | $528,800.00 | |||||
5 | Down Payment | $158,640.00 | |||||
6 | Mortgage Amount | $370,160.00 | $2,152.87 | $25,834.43 | 0.004123915465 | ||
7 | Closing Costs | $1,000.00 | |||||
8 | Mortgage Rate | 5.00% | |||||
9 | Amortization Period (years) | 25 | |||||
10 | |||||||
11 | Deferred Maintenance Expense | $0 | |||||
12 | |||||||
13 | REVENUE | Monthly Rent | Monthly | Yearly | |||
14 | |||||||
15 | Suite 1 | $700.00 | |||||
16 | Suite 2 | $700.00 | |||||
17 | Suite 3 | $700.00 | |||||
18 | Suite 4 | $700.00 | |||||
19 | Commercial 1 | $925.00 | |||||
20 | |||||||
21 | |||||||
22 | Total Revenue | $3,725.00 | $44,700.00 | ||||
23 | |||||||
24 | EXPENSES | Monthly/Yearly | Amount | Monthly | Yearly | ||
25 | Property Taxes | Y | $4,759.00 | $396.58 | $4,759.00 | ||
26 | Leasehold Improvements | Y | $0.00 | $0.00 | $0.00 | ||
27 | Insurance | Y | $4,974.00 | $414.50 | $4,974.00 | ||
28 | Hydro | M | $0.00 | $0.00 | $0.00 | ||
29 | Gas | M | $0.00 | $0.00 | $0.00 | ||
30 | Water | Y | $0.00 | $0.00 | $0.00 | ||
31 | Water Heater | Y | $0.00 | $0.00 | $0.00 | ||
32 | Phone, Internet & Satellite | M | $200.00 | $200.00 | $2,400.00 | ||
33 | $0.00 | ||||||
34 | $0.00 | ||||||
35 | $0.00 | ||||||
36 | Property Management | 8% | $298.00 | $3,576.00 | |||
37 | Building Maintenance | 10% | $372.50 | $4,470.00 | |||
38 | Vacancy Allowance | 5% | $186.25 | $2,235.00 | |||
39 | |||||||
40 | Total Expenses | $1,867.83 | $22,414.00 | ||||
41 | |||||||
42 | The Math | Monthly | Yearly | ||||
43 | Net Operating Income (NOI) | $1,857.17 | $22,286.00 | ||||
44 | Mortgage Payments | ($2,152.87) | ($25,834.43) | ||||
45 | Net Profit | -0.67% | ($295.70) | ($3,548.43) | |||
46 | |||||||
47 | Cash Outlay | $159,640.00 | |||||
48 | Cap Rate | 4.21% | |||||
49 | Return on Investment (ROI) | -2.22% | |||||
50 | Years to recover outlay | (44.99) | |||||
51 | Desired cap rate: | ||||||
52 | Purchase Price | 7.00% | $318,371.43 | ||||
53 |