A | B | C | D | E | F | G | |
---|---|---|---|---|---|---|---|
1 | Go to File > Make a Copy to play with this spreadsheet yourself | ||||||
2 | |||||||
3 | BASIC PURCHASE INFORMATION | FINANCIAL PERFORMANCE SUMMARY | |||||
4 | Property Value (est.) | $70,000 | Capitalization Rate | 12.4% | |||
5 | Purchase Price | $53,000 | Cash-on-Cash Return | 28.5% | |||
6 | Down Payment | $10,600 | Total Equity (Year 5) | $46,230 | |||
7 | Equity at Purchase | $27,600 | |||||
8 | |||||||
9 | |||||||
10 | MORTGAGE CALCULATION | CALCULATION ASSUMPTIONS | |||||
11 | Interest Rate | 5.00% | Rental Income (mo.) | $750 | |||
12 | Down Payment | 20% | Vacancy Allowance | 5% | |||
13 | Loan Term (Fixed) | 30 | Maintenance Reserve | 3% | |||
14 | Loan Amount | $42,400 | Management Fee | 10% | |||
15 | Annual Payment | $2,731 | Property Taxes | $80 | |||
16 | Monthly Payment | $228 | Insurance | $25 | |||
17 | Homeowners Assoc. | $0 | |||||
18 | Utilities | $0 | |||||
26 | Misc Expenses | $0 | |||||
37 | Rental Income Increase | 3% | |||||
38 | Property Tax Increase | 3% | |||||
39 | Utilities Increase | 4% | |||||
40 | Misc Expenses Increase | 4% | |||||
41 | CASH TO PURCHASE | Building to Land Value Ratio | 75% | ||||
42 | Down Payment | $10,600 | Appreciation Rate | 4% | |||
43 | Closing Costs | $1,272 | Closing Costs (Buy) | 3% | |||
44 | Total Cash Required | $11,872 | Closing Costs (Sell) | 8% | |||
45 | |||||||
46 |