Rental Real Estate Analysis
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFG
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,000Capitalization Rate12.4%
5
Purchase Price$53,000Cash-on-Cash Return28.5%
6
Down Payment$10,600Total Equity (Year 5)$46,230
7
Equity at Purchase$27,600
8
9
10
MORTGAGE CALCULATION
CALCULATION ASSUMPTIONS
11
Interest Rate5.00%Rental Income (mo.)$750
12
Down Payment20%Vacancy Allowance5%
13
Loan Term (Fixed)30Maintenance Reserve3%
14
Loan Amount$42,400Management Fee10%
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 Increase3%
38
Property Tax Increase3%
39
Utilities Increase4%
40
Misc Expenses Increase4%
41
CASH TO PURCHASE
Building to Land Value Ratio
75%
42
Down Payment$10,600Appreciation Rate4%
43
Closing Costs$1,272Closing Costs (Buy)3%
44
Total Cash Required
$11,872Closing Costs (Sell)8%
45
46
Loading...
 
 
 
Financial Summary
Financial Analysis
 
 
Main menu