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.
- 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
Frequently Asked Questions
What is the 70% rule in house flipping?
The 70% rule states you should pay no more than 70% of the ARV minus repair costs. For a $320,000 ARV with $50,000 in repairs: $320,000 x 0.70 - $50,000 = $174,000 maximum purchase price. This rule provides a margin for profit and unexpected costs.
What are typical holding costs?
Holding costs include hard money loan interest (10-14%), property taxes, insurance, utilities, HOA fees, and lawn care. On a $200,000 property with a hard money loan, expect $1,500-$3,000/month. Every month of delays erodes profit.
How much rehab contingency should I budget?
Budget 10-20% above your estimated rehab costs for contingency. Unexpected issues like plumbing problems, structural repairs, or permit delays are common. On a $50,000 rehab, keep $5,000-$10,000 in reserve.
Ready to run the numbers?
Open House Flipping Calculator