| A | B | C | I | U | V | W | X | Y | Z | AA | AB | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | Bungalow with Construction | SFH with no Construction | Delta | 8% of rent + 10 lease up fee on any lease sign regardless of length (10 days / 8 months) | ||||||||
3 | Purchase Price | $325,000 | $325,000 | |||||||||
4 | House Value Growth Rate | 5.0% | 5.0% | |||||||||
5 | Gross Rent % | 12.00% | 17.19% | |||||||||
6 | Rooms | 6 | 6 | |||||||||
7 | Rent Per Room / Month | $600 | $800 | |||||||||
9 | Total Gross Rent | $3,600 | $4,800 | -$1,200 | ||||||||
12 | Expense Assumptions | |||||||||||
15 | Management Fees | 15% | 15% | 0% | ||||||||
17 | Monthly CAPEX, Utilities, Repairs & Maintance | $200 | $1,200 | -$1,000 | ||||||||
18 | Capital Expenses and Repairs | $35,000 | $10,000 | $25,000 | BOOK A CALL | |||||||
19 | Occupancy % | 94% | 94% | |||||||||
21 | Insurance | $150 | $150 | |||||||||
22 | Taxes | 1.25% | 1.25% | |||||||||
28 | Debt | |||||||||||
29 | LTV (1 - Down Payment Percentage) | 80% | 80% | |||||||||
30 | Loan Amount | $260K | $260K | |||||||||
31 | Interest Rate | 7.90% | 7.90% | |||||||||
32 | Monthly Interest Rate | 0.66% | 0.66% | |||||||||
33 | Monthly Payment | -$1,889.69 | -$1,889.69 | |||||||||
34 | Summary | |||||||||||
36 | Annual IRR | 18.40% | 22.44% | IRR on Improvements | ||||||||
37 | Y1 CoC | 4.32% | 5.09% | -6.14% | ||||||||
41 | Cap Rate | 7.50% | 8.30% | |||||||||