Purchase Price$150,000
ARV$245,000
Rehab Budget$40,000
Contingency10% ($4,000)
Seasoning6 months
Purchase Closing3% ($4,500)
Phase 1 Holding$600/mo × 6 = $3,600
HM Terms80% LTC, 12% rate, 3pts
HM Covers RehabYes
Refi Terms75% LTV, 7.5%, 30yr, 2.5% closing
Monthly Rent$1,950
Vacancy7%
Year 1 Expenses$7,500/year
Step-by-Step Calculation
1.HM Loan = (130K + 40K) × 80%: $136,000
2.Down Payment = 130K × 20%: $26,000
3.HM Points = 136K × 3%: $4,080
4.Monthly HM Interest = 136K × 1%: $1,360/mo
5.Total HM Interest (6 months): $8,160
6.Phase 1 Holding = $600 × 6 mo: $3,600
7.Purchase Closing = 130K × 3%: $3,900
8.Rehab Contingency = 40K × 10%: $4,000
9.All-In Cost = 130K + 3.9K + 40K + 4K + 3.6K + 4.08K + 8.16K: $193,740
10.Total Cash Invested = 26K + 3.9K + 3.6K + 4.08K + 8.16K: $45,740 (rehab financed by HM)
11.New Loan = 240K × 75%: $180,000
12.Refi Closing = 180K × 2.5%: $4,500
13.HM Loan Payoff = principal only: $136,000
14.Refi Proceeds = 180K − 136K − 4.5K: $39,500
15.Capital Left = 45,740 − 39,500: $6,240
16.Capital Recovery % = 39,500 ÷ 45,740 × 100: 86.4%
17.Year 1 Rent Revenue = $2,100 × 12: $25,200
18.Year 1 NOI = 25,200 × (1−7%) − 7,500: $15,936
19.Monthly Payment (180K, 7.5%, 360mo amortization): $1,259/mo
20.Annual Debt Service = 1,259 × 12: $15,108
21.Year 1 Cash Flow = 15,936 − 15,108: $828
22.Post-Refi DSCR = 15,936 ÷ 15,108: 1.055x
23.Post-Refi CoC = 828 ÷ 6,240 × 100: 13.3%