ABCDEFGKLMNOPQRSTUVWXYZ
1
2
Light Blue - Line item
3
Grey- Input CellsAnthony's BRRRR Calculator
4
White - Formula
5
6
To Do: Factor in rent growth and return over time
7
Figure out depreciation calculation for net taxable income
8
9
10
BuyFinancingRefinancingDeal Evaluation
11
12
Deal InfoFinancing OptionsThe Current LoanExecutive Summary
13
Property TypeSFHTotal Cost (purchase + rehab) $ 350,000.00 Total Loan Amount $ 297,500.00 Net Monthly Cash Flow $ 1,385.73
14
Number of Units1Financing $ 297,500.00 Total Monthly Payment: $ 2,231.25 Annual Cash Flow $ 16,628.80
15
Property AddressCash Needed: $ 59,500.00
Total annual exp w/out mortgage
 $ 18,745.00
16
Sq. Ft2096Financing to cost: 85%The REFI Loan
17
Property ARV $ 350,000.00 Capital Recapture / Loss $ (46,425.00)
18
Purchase Price 350,000.00 Annual Pmt: $ 26,775 LTV:75%
19
Rehab Cost - Equity Created -
20
Rehab time (months)4Monthly Pmt: $ 2,231 Amount $ 262,500.00 Equity in Deal $ 87,500.00
21
After Repair Value 350,000.00 Rate7.50%Total Cash Used $ 105,925.00
22
Hard MoneyTerm30
23
Closing Costs 2,500.00 Hard Money Loan-to-Cost85%Cash on Cash return15.70%
24
Interest Rate9%Monthly Loan Payment $ 1,852
25
Discount Points2%Annual Loan Payment $ 22,226 1% rule ?1.37%
26
Rental InformationMonths until Refinance 4
27
Unit 1 $ 4,800.00 Equity CreationNOI (before financing) $ 3,237.92
28
Bed/ Bath - unit 1Hard Money Loan Principle $ 297,500.00 Refi Loan Amount $ 262,500.00 NI after Financing $ 1,385.73
29
Unit 2Hard Money Monthly Payment $ 2,231
30
Bed/ Bath - unit 2Hard Money Discount Points $ 7,000.00 Payoff original financing $ 297,500.00 Cap Rate on purchase price10.81%
31
Unit 3Holding Costs $ 8,925
32
Bed/ Bath - unit 32nd Financing Source (If used)Closing Costs $ 2,500.00 50 % rule? 33%
33
Unit 4Loan Amount $ - Less: Total Costs($308,925.00)
34
Bed/ Bath - unit 4Loan Interest Rate0%
35
Monthly Rent $ 4,800.00 Term: -
Equity left after refinance
 $ (46,425.00)
Have to bring in more cash on the refinance
36
Cash out on refinance $ (105,925.00)
37
Rental Expense BreakdownLoan Monthly Payment0
38
Debt payment $ 1,852.18
39
Electricity -
40
Cable/Internet -
41
Sewer -
42
Pest -
43
Garbage -
44
Taxes 362.08 Annual Property Taxes $4,345.00
45
Insurance
46
Assumptions
47
Vacancy 240.00 5%
48
Repairs and Maintenance 240.00 5%
49
CapEx 240.00 5%
50
Property Management 480.00 10%
51
Total Monthly Expenses $ 3,414.27
52
53
Net Monthly Rent $ 1,385.73
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