House Flipping Math: ARV, the 70% Rule, Rehab Budgets & Holding Costs
Run a fix-and-flip deal end to end in a live spreadsheet: ARV from comps, maximum offer, rehab budget, holding and hard-money costs, profit, annualised ROI and a stress test. Fictional property, illustrative costs. Educational only, not investment advice.
The first lesson is free — no account needed.
About this course
A house flipping course that runs one fictional fix-and-flip deal, 418 Juniper Street, from the first offer to the sale in a spreadsheet, for new real estate investors, agents, lenders and real estate students. You estimate the after-repair value from five comparable sales with an adjusted price per square foot, calculate the maximum allowable offer with the 70% rule and with a refined version built from the deal's own costs, build a rehab budget by line item and by trade with SUMIFS and a contingency, total the monthly holding costs over the project timeline, size a hard-money loan with points, fees and interest-only payments, subtract the selling costs to find the net profit, measure the ROI and the annualised return, and stress-test the deal for a lower ARV, a rehab overrun and a two-month delay with a chart. Illustrative costs. Educational only, not investment advice. The first lab is free.
Lessons
- After-Repair Value from Comparables (Adjusted Price per Sq Ft)Free
- Maximum Allowable Offer: the 70% Rule and a Refined Version Pro
- Rehab Budget: Line Items, Cost by Trade (SUMIFS) and Contingency Pro
- Holding Costs per Month × the Project Timeline Pro
- Financing with a Hard-Money Loan: Points, Fees and Interest-Only Pro
- Selling Costs and Net Profit Pro
- ROI and Annualised Return: Why Time Matters Pro
- Sensitivity: ARV −5%, Rehab +15%, Two Months Late (Chart) Pro