Untitled spreadsheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
|
 
Still loading...
ABCDEFGHIJKLMNOPQRST
1
2
Purchase Price$300,000.00
3
Cash Down$60,000.00
4
Amount Financed$240,000.00
5
Loan Terms (years)30
6
Yearly Mortgage Payment3.75%$13,337.73
7
Yearly Property Taxes1.25%$3,750.00
8
Yearly Property Insurance$600.00
9
Yearly HOA$0.00
10
11
Monthly Rents$2,200.00
12
13
Yearly Gross Income$26,400.00
14
- Property Taxes-$3,750.00
15
- Operating Expenses10%-$2,640.00
16
- Property Insurance-$600.00
17
18
Cash Flow From Operations$19,410.00
19
- Finance Payments-$13,337.73
20
21
NET CASH FLOW (pre income tax)$6,072.27
22
Gross Return8.80%
23
Cap Rate6.47%
24
Net Return2.02%
25
26
NET CASH FLOW / (Cash Down + Finance Payments + All Expenses)7.56%
27
28
29
30
31
32
33
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...
 
 
 
Sheet1