ABCDEFGHIJKLMNOPQRSTUVWX
1
2
3
4
5
6
7
 BRRRR Calculator
8
9
INSTRUCTIONS: MAKE A COPY before using this. DO NOT EDIT THIS VERSION. Thank you 😊
10
11
 Part 1: Data Inputs
12
13
 **READ THIS FIRST**
14
15
Black =
Formula / Do not change
16
Blue =User inputs
17
Green =
Formula / Optional to change
18
19
20
 Step 1: Property Info Step 2: Short Term Loan DetailsStep 3: Input Rent/IncomeStep 4: Refinance Information
21
Property Price $ 355,000.00 Down payment %20%Unit 1 $ 2,000.00
22
Estimated Rehab Costs $ 7,820.00 Financed amount $ 284,000.00 Unit 2 $ - Estimated ARV $ 380,000.00
23
Closing Costs $ 3,000.00 Points1.00%Unit 3 $ -
Amount Pulled Out (New Loan Amt)
 $ 285,000.00
24
Estimated Annual Appreciation3.00%Interest rate10.00%Unit 4 $ - Cost of Cash Out Refinance $ 8,550.00
25
Estimated ARV $ 380,000.00 Interest Only?YesUnit 5 $ - Repayment of Original Note $ 286,840.00
26
Annual Rent Increase2.00%Months Needed12Unit 6 $ - Interest Paid on Original Note $ 28,400.00
27
Months to Cash Flow5PMI0.00%
Subtotal Estimated Rent
 $ 2,000.00
Additonal Cash Pulled Out (Left in)
 $ (120,610.00)
28
Loan Term in Years 1.00 Percent of Cash Out $ 0.85
29
Payments Made Per Year 12.00 Pet Rent $ -
30
Estimated Monthly Insurance
 $ 83.33 Garage Parking $ - Refinance Interest Rate3.25%
31
Estimated Monthly Taxes $ 80.00 Carport Parking $ - PMI0.00%
32
Optional Extra Payments $ - Extra Storage $ - Loan Term in Years30
33
Laundry $ - Payments Per Year12
34
Utility Fee $ -
35
Subtotal Other Income $ - Estimated Insurance $ 83.33
36
Estimated Taxes $ 80.00
37
Total Monthly Income $ 2,000.00 PMI $ -
38
Optional extra payments $ -
39
 Step 5: FInal Property Expenses (Post Refinance)
40
Principal & Interest $ 1,240.34 Cash Pulled Out $ 276,450.00
41
Taxes $ 80.00
42
Insurance $ 83.33
43
PMI $ -
44
Subtotal Monthly Payment $ 1,403.67
45
46
Vacancy $ 80.00 4%***
47
Capital Expenditures $ 100.00 5%***
48
Maintenance $ 100.00 5%***
49
Property Management $ 140.00 7%***
50
Subtotal Reserves $ 420.00
51
52
Total Monthly Expenses $ 1,823.67
53
54
55
Part 2: Deal Analysis
56
57
Year 1 CoC Return-44.82%
58
Down Payment$71,000
59
Rehab Costs$7,820
60
Closing Costs $ 3,000
61
Initial Investment $ 81,820
62
63
Amount Pulled out $ 285,000
64
Cost of Cash Out Refinance $ 8,550
65
Cost of Note $ 315,240
66
Net Cashed Pulled Out $ (38,790)
67
68
Monthly Income $ 2,000
69
Monthly Expenses $ 1,824
70
Monthly Cash Flow $ 176
71
Cash Flow COC Return3%
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