House Flipping Calculator Formula
Understand the math behind the house flipping calculator. Each variable explained with a worked example.
Formulas Used
Net Profit
net_profit = profitReturn on Investment
roi = total_investment > 0 ? profit / total_investment * 100 : 0Total Investment
total_investment_amt = total_investmentTotal Selling Costs
total_sell_costs = total_selling_costsTotal Holding Costs
holding_cost_total = total_holdingProfit Margin (% of ARV)
profit_margin = arv > 0 ? profit / arv * 100 : 0Variables
| Variable | Description | Default |
|---|---|---|
purchase_price | Purchase Price(USD) | 200000 |
rehab_cost | Total Rehab Cost(USD) | 50000 |
arv | After Repair Value (ARV)(USD) | 320000 |
holding_months | Holding Period(months) | 6 |
monthly_holding_costs | Monthly Holding Costs(USD) | 2000 |
buying_closing_costs | Purchase Closing Costs(USD) | 5000 |
selling_commission_pct | Selling Commission(%) | 5 |
selling_closing_costs | Other Selling Costs(USD) | 3000 |
total_holding | Derived value= monthly_holding_costs * holding_months | calculated |
selling_commission | Derived value= arv * selling_commission_pct / 100 | calculated |
total_investment | Derived value= purchase_price + rehab_cost + buying_closing_costs + total_holding | calculated |
total_selling_costs | Derived value= selling_commission + selling_closing_costs | calculated |
total_cost | Derived value= total_investment + total_selling_costs | calculated |
profit | Derived value= arv - total_cost | calculated |
How It Works
House Flip Profitability Analysis
Flipping houses requires careful analysis of all costs to ensure profitability. Many new flippers underestimate holding costs and selling costs.
Profit Formula
Net Profit = ARV - Purchase Price - Rehab - Closing Costs (buy & sell) - Holding Costs - Commission
Cost Categories
Rules of Thumb
Worked Example
Buy at $200,000, rehab $50,000, sell at ARV $320,000. 6-month hold at $2,000/month. Buy closing $5,000, sell at 5% commission + $3,000.
purchase_price = 200000rehab_cost = 50000arv = 320000holding_months = 6monthly_holding_costs = 2000buying_closing_costs = 5000selling_commission_pct = 5selling_closing_costs = 3000
- 01Total holding costs: $2,000 x 6 = $12,000
- 02Total investment: $200,000 + $50,000 + $5,000 + $12,000 = $267,000
- 03Selling commission: $320,000 x 5% = $16,000
- 04Total selling costs: $16,000 + $3,000 = $19,000
- 05Total cost: $267,000 + $19,000 = $286,000
- 06Net profit: $320,000 - $286,000 = $34,000
- 07ROI: $34,000 / $267,000 = 12.7%
- 08Profit margin: $34,000 / $320,000 = 10.6% of ARV
Ready to run the numbers?
Open House Flipping Calculator