ABCDEFG
1
2
3
BASIC PURCHASE INFORMATION
FINANCIAL PERFORMANCE SUMMARY
4
$100,000Monthly Cashflow$764.02
5
Property Repairs (est.)$0Capitalization Rate15.9%
6
Purchase Price$100,000Cash-on-Cash Return33.6%
7
Down Payment$25,000Total Equity (Year 5)-$67,836
8
Equity at Purchase-$75,000
9
10
11
MORTGAGE CALCULATION
CALCULATION ASSUMPTIONS
12
Interest Rate4.00%Rental Income (mo.)$2,000
13
Down Payment25%Vacancy Allowance10%
14
Loan Term (Fixed)30Maintenance Reserve10%
15
Loan Amount$75,000Management Fee10%
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 Increase2%
39
Property Tax Increase3%
40
Utilities Increase4%
41
Misc Expenses Increase4%
42
CASH TO PURCHASEBuilding to Land Value Ratio75%
43
Down Payment$25,000Appreciation Rate0%
44
Closing Costs$2,250Closing Costs (Buy)3%
45
Total Cash Required$27,250Closing Costs (Sell)8%
46
47