Store / House Flip Deal Analyzer
House Flip Deal Analyzer
Know your max offer before you make it.
A house-flip spreadsheet that works out the highest price you can pay and still make the profit you want, with hard-money costs, comps and the downside built in. For Excel and Google Sheets.
Excel + Google Sheets · No macros · .xlsx download
$19 one payment · no subscription
Five reasons to use it
- Know your max offer Type the profit you want. The sheet works out the highest purchase price that still leaves it, counting the purchase, rehab, loan, holding and selling costs you enter.
- Real hard-money math Enter the loan as a % of price and a % of rehab, plus rate, points and lender fees. Interest is counted for every month you hold.
- ARV from your comps Enter up to 5 sold comps with your own adjustments. The sheet turns them into an adjusted price per square foot and an ARV. Or type your own ARV.
- See the downside first It shows profit if the sale price drops 5–10%, the rehab runs 10–30% over, or the project takes 1–3 extra months.
- Works in Excel and Google Sheets No macros or add-ins. The formulas are locked so you can't break them by accident.
What you get
- One .xlsx workbook with three tabs:
- How to use: one page.
- Inputs: property, purchase, 5 comps, a 15-line rehab budget with contingency, financing, holding costs, selling costs and your rules.
- Results: net profit, a verdict and the max offer for your target; a 70%-rule check; a cost breakdown, the cash you put in and the return on that cash (also per year); a sale-price × rehab-overrun grid and a delay table.
- A filled-in sample deal, with invented numbers, so you can see it work before you type in yours.
Honest limits
- It gives estimates, not financial advice. It can't see the house, the market or your lender's fine print, and a result is only as good as the numbers you type in.
- Interest is counted on the full loan for every month. Loans that pay out the rehab money in stages usually cost a little less, so the sheet errs on the cautious side.
- It handles one deal per file. Save a copy for each property.
- It covers flips only: no rentals, refinances or partner splits.
- The ARV from comps is a simple adjusted price-per-square-foot average. It is not an appraisal.
Questions
- Does it work in Google Sheets?
- Yes. Upload the .xlsx to Google Drive and open it. It uses only functions that Google Sheets supports. Google Sheets doesn't keep the cell locks, so avoid typing over the grey cells.
- Which Excel do I need?
- Desktop Excel or Excel for the web. It's a standard .xlsx with no macros or add-ins. We haven't tested Apple Numbers.
- Can I change the sample deal?
- Yes. Type over every yellow cell. The sample numbers are invented.
- Can I unlock the formulas?
- Yes. In Excel, go to Review > Unprotect sheet. There's no password.
- Is the max offer a guarantee of profit?
- No. It's the highest price that hits your target if your numbers hold. The what-if tables show how much room you have if they don't.
More from the store
Spreadsheets for estimating, not advice. The sample data is invented.