Public Quick N Dirty Investment Analysis
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQRST
1
Whatever St
2
3
SettingsInitial ExpensesMonth Cashflow1Cumulative180Flip12
4
Purchase Date2/1/2011Purchase Price200,000IncomeIncomePurchase Price
5
Est. Market Value250,000Purchase Fees4,500Rent1,450Rent329,110
6
Purchase Price200,000Initial Cap Investment0Total1,450Total329,110
7
Purchase Fees4,500Remodel2,050
8
Initial Cap Investment0Total206,550ExpensesExpences
9
Down Payment ($ or %)10%Property Tax199Vacancy23,038
10
Mortgage Term (years)30FinancingHOA Fees0Turnover4,729
11
Interest Rate3.75%Down Payment20,000Property Management0Property Management0
12
Payments per Month1Mortgage180,000Insurance60Maintenance19,747
13
Monthly Rent1,450Interest Rate3.75%Total Fixed Costs259Property Tax38,661
14
Vacancy Rate7%Periods360Maintenance87HOA Fees0
15
Avg Tenancy (months)24Period Rate0.31%Vacancy102Insurance13,618
16
Turnover Cost500Period Payment834Turnover21
17
Reserve Months3Monthly Payments834Total Variable Costs209
18
HOA Fees0Total Payments300,099Total Expenses469Total Hard Costs52,279
19
Monthly Insurance60Total Interest120,099Total Soft Costs47,513
20
Net Operating Income (NOI)982Total99,792
21
Annual Appreciation3%Cash
22
Property Tax1.195%Cash Investment26,550MortgageNet Operating Income (NOI)229,318
23
Property Tax Annual Increase1%Required Reserve4,350Principal271
24
Annual Inflation3%Total30,900Interest563Mortgage
25
Maintenance6%Total834Principal65,371
26
Property Management0%ROIInterest84,678
27
HOA Annual Increase5%Cap Rate (selected month)5.70%SummaryTotal150,049
28
Cash CAGR9.66%Cash Flow148
29
Income Tax Rate35%Cash + Equity CAGR13.23%Equity Increase271Summary
30
Capital Gains Tax15%Appreciation CAGR15.00%Appreciation627Cash Flow79,269
31
Sales Fee5%Total CAGR19.00%Total1,046Equity65,371
32
Investment Horizon15Appreciation189,492
33
Selected Month180Total334,131
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Overview
Annual Projections
Annual Amounts Graph
Value Over Time Graph
Annual ROI Graph
Remodel