Fix and Flip Deal Analyzer: ARV, 70% Rule MAO & Profit (Sheets)
Know your numbers before you make an offer on a flip. Enter the ARV, repair budget and price, plus your hard money points and rate, holding costs and selling costs. The spreadsheet calculates the 70% rule max allowable offer, total project cost, net profit, cash invested, ROI and annualized ROI, and the highest price that still hits your profit target. A stress test shows what happens if the ARV drops, repairs run over or the project takes longer. A Comps tab turns sold comps into an ARV estimate.
What's inside:
- Deal Analyzer tab with MAO, profit and ROI
- Hard money points and interest
- Stress test (ARV, repairs, time)
- Comps tab with $ per sq ft ARV
- PDF guide, comps and offer worksheets
Good to know:
- Works in Google Sheets, Excel and LibreOffice.
- Example numbers are made up. Educational only, not financial, tax or legal advice.
Estimates only, based on the numbers you enter. Not investment, tax, legal, or lending advice, and not a loan offer or rate quote. Verify figures with qualified professionals.