| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | |||||||
2 | |||||||
3 | BASIC PURCHASE INFORMATION | FINANCIAL PERFORMANCE SUMMARY | |||||
4 | $100,000 | Monthly Cashflow | $764.02 | ||||
5 | Property Repairs (est.) | $0 | Capitalization Rate | 15.9% | |||
6 | Purchase Price | $100,000 | Cash-on-Cash Return | 33.6% | |||
7 | Down Payment | $25,000 | Total Equity (Year 5) | -$67,836 | |||
8 | Equity at Purchase | -$75,000 | |||||
9 | |||||||
10 | |||||||
11 | MORTGAGE CALCULATION | CALCULATION ASSUMPTIONS | |||||
12 | Interest Rate | 4.00% | Rental Income (mo.) | $2,000 | |||
13 | Down Payment | 25% | Vacancy Allowance | 10% | |||
14 | Loan Term (Fixed) | 30 | Maintenance Reserve | 10% | |||
15 | Loan Amount | $75,000 | Management Fee | 10% | |||
16 | Annual Payment | $4,297 | Property Taxes | $200 | |||
17 | Monthly Payment | $358 | Insurance | $50 | |||
18 | Homeowners Assoc. | $0 | |||||
19 | Utilities | $275 | |||||
20 | Electricity | $0 | |||||
21 | Fuel Oil | $0 | |||||
22 | Gas | $0 | |||||
23 | Sewer | $75 | |||||
24 | Telephone | $0 | |||||
25 | Water | $200 | |||||
26 | Other | $0 | |||||
27 | Misc Expenses | $60 | |||||
28 | Accounting | $0 | |||||
29 | Advertising | $0 | |||||
30 | Janitorial Services | $0 | |||||
31 | Lawn/Snow | $60 | |||||
32 | Legal | $0 | |||||
33 | Licenses | $0 | |||||
34 | Miscellaneous | $0 | |||||
35 | Resident Superintendent | $0 | |||||
36 | Supplies | $0 | |||||
37 | Trash Removal | $0 | |||||
38 | Rental Income Increase | 2% | |||||
39 | Property Tax Increase | 3% | |||||
40 | Utilities Increase | 4% | |||||
41 | Misc Expenses Increase | 4% | |||||
42 | CASH TO PURCHASE | Building to Land Value Ratio | 75% | ||||
43 | Down Payment | $25,000 | Appreciation Rate | 0% | |||
44 | Closing Costs | $2,250 | Closing Costs (Buy) | 3% | |||
45 | Total Cash Required | $27,250 | Closing Costs (Sell) | 8% | |||
46 | |||||||
47 |