ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
2
BUYOriginal purchase price$125,000.00
Note: Any cell in Green is editable, ready for your individual numbers
3
Earnest deposit$1,000.00Directions:
4
Down payment %20.00%BUY:
5
Down payment amount$25,000.00Original purchase price
6
Closing cost estimate$1,500.00Earnest deposit
Will be subtracted from down payment
7
1st loan principal$100,000.00Down payment %
Primary Residence: 4% to 6%, Non-Owner Occupied: 20% to 25%
8
9
REHABRehab cost estimate$20,000.00Down payment amount
Automatically calculated
10
1st loan interest %5.25%Closing cost estimate
Typically, a coupe thousand dollars (varies by state)
11
Total interest amount$5,250.001st loan principal
Automatically calculated
12
Loan term length (months)6REHAB:
13
Monthly interest only payment$875.00Rehab cost estimate
14
Estimated rehab timeline (months)21st loan interest %
15
16
REFINANCEEstimated appraisal value$170,000.00Total interest amount
Automatically calculated
17
Loan to value (LTV) %75.00%Loan term length (months)
Typically 6 monts to 18 months
18
Term loan balance$127,500.00Monthly interest only payment
Automatically calculated
19
Interest rate %5.25%Estimated rehab timeline (months)
The time it takes to make improvements
20
Closing cost estimate$1,000.00REFINANCE:
21
Term of loan (years)30Estimated appraisal value
Estimate based on recently sold comps
22
Loan payoff 1st loan$100,000.00Loan to value (LTV) %Typically, 65% to 85%
23
Remaining amount after 1st loan pay off$26,500.00Term loan balance
Automatically calculated
24
Total Investment$49,250.00Total Investment
Down payment + rehab cost + interest payments + closing costs
25
Cash remaining from loan-$22,750.00Cash remaining from loan
If negative, that is the amount out of pocket you will have to pay
26
27
RENTMonthly rental income estimated$1,500.00Interest rate %
28
Monthly principal and interest$704.06Closing cost estimate
Typically, a coupe thousand dollars (varies by state)
29
Annual taxes estimated$2,700.00Term of loan (years)Typically, 15, 20, 30
30
Monthly taxes$225.00Loan payoff 1st loan
Automatically calculated
31
Annual insurance$1,100.00Remaining amount after 1st loan pay off
Automatically calculated
32
Monthly insurance$91.67RENT:
33
Monthly Principle, Insurance, Taxes, Interest (PITI)$1,020.73Monthly rental income estimated
Compare current listings in the ara
34
Property management (PM) %6.00%Monthly principle and interest
Automatically calculated
35
Monthly property managment fee$90.00Annual taxes estimated
36
Monthly PITI + PM$1,110.73Monthly taxes
Automatically calculated
37
Monthly cash flow$389.27Annual insurance
38
39
REPEATMonthly insurance
Automatically calculated
40
Monthly Principle, Insurance, Taxes, Interest (PITI)
Automatically calculated
41
Property management (PM) %
The percentage of the income that will go towards PM
42
Monthly property managment fee
Automatically calculated
43
Monthly PITI + PM
Automatically calculated
44
Monthly cash flow
Automatically calculated
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