ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
2
3
Cashflow Calculator by Nelson Lin
SubtleRE.com
4
If you're interested in a calculator for commercial properties or just investing in them,
feel free to reach out to me at nelson@subtlerealestate.com.
5
Copyright © Subtle Asian Real Estate
6
Please create a copy and edit your own version. You can create a copy by going to "File" in the upper left hand corner and clicking on "Make a copy"
7
Version 01/2023
8
9
Fixed
10
Adjustable
11
12
Line ItemProperty 1
Scenario A		Property 1
Scenario B		Property 2
Scenario A		Property 2
Scenario B		FactorsNote
13
Purchase$1,000,000$600,000$2,500,000$2,500,000
14
Interest Rate7.00%7.00%7.00%7.00%
15
Down Payment50%50%25%25%
16
Rehab costs$30,000$30,000$160,000$160,000
17
Closing costs$30,000$18,000$75,000$75,0003.0%
18
Total cash needed$560,000$348,000$860,000$860,000
19
20
Monthly Rent income$6,000$6,000$17,620$20,800
21
Garage$0$0$0$0
22
Laundry$0$0$100$100
23
Total Income$6,000$6,000$17,720$20,900
24
25
Mortgage$3,327$1,996$12,474$12,474
26
PMI$0$0$0$0
27
Property Taxes$1,689$1,689$4,600$4,600
28
Home Insurance$904$904$2,400$2,400
29
Flood Insurance$0$0$0$0
30
Liability insurance$0$0$0$0
31
Vacancy$300$300$886$1,0455.0%
32
Repairs$300$300$886$1,0455.0%
33
Capital Expenditure $300$300$886$1,0455.0%
34
Property Manager$0$0$0$00.0%
35
Water$0$0$1,200$1,200
36
Sewer$0$0$0$0
37
Garbage$0$0$0$0
38
Gas $0$0$0$0
39
Electricity$0$0$0$0
40
HOA$0$0$0$0
41
Snow Removal$0$0$0$0
42
Lawn$50$50$0$0
43
Wifi $0$0$0$0
44
Cleaning$0$0$200$200
45
Monthly Expenses$6,870$5,539$23,532$24,009
46
47
Monthly Cash flow -$870$461-$5,812-$3,109
48
Net Operating Income$2,457$2,457$6,662$9,365
49
Reserves$20,609$16,617$70,597$72,0283.0
50
COC ROI -1.86%1.59%-8.11%-4.34%
51
COC ROI w/ reserves-1.80%1.52%-7.50%-4.00%
52
Cap Rates2.95%4.91%3.20%4.50%
53
DSCR0.741.230.530.75
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