ABCDEFGHIJKLMNOPQRSTUV
1
// Made by The Rental Wire
// We run a free weekly newsletter sharing a curated list of the best (highest cash-on-cash return) single-family rentals for sale in the US.
2
Input
3
4
Assumed %Manual InputMonthlyAssumed %Manual Input
5
Purchase Price$80,000Rent$1,000
6
Down Payment$16,00020.00%Property Mgmt$12212.17%
7
Closing Costs$3,2004.00%Vacancy$505.00%
8
Interest Rate7.0%Maintenance/Repairs$10010.00%
9
Term in years30CapEx$10010.00%
10
Financed Amount$64,000Insurance$440.06%
11
Payment$425.79Property Taxes$440.06%
12
Renovations/Repairs$11,429Expenses Subtotal$460
13
Out of Pocket Costs$30,629Annual % Increase
(rent + expenses)		3.0%
14
15
16
Output
17
18
Monthly Expenses$885.49
19
Monthly Net Cash Flow$115
20
Initial Cash on Cash4.49%
21
22
Years15102030
23
Investment$30,629
24
Cash Return$115$201$300$550$886
25
CoC4.5%7.9%11.8%21.6%34.7%
26
Annual Equity$650$859$1,218$2,449$4,921
27
Total Return %6.6%10.7%15.7%29.5%50.8%
28
Total Return $$2,024$3,266$4,822$9,049$15,549
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