Fix and Flip Calculator, Fix and Flip Analyzer Excel Spreadsheet, 70% Rule Max Offer, Profit and ROI, House Flipping Calculator

Excel fix and flip calculator: enter purchase, rehab and sale price to see profit and ROI. Example: $209,000 buy, $67,409 net profit, 70% rule PASS.

Change the blue cells to your numbers. Everything else updates on its own.

WHAT IT SHOWS
- Total project cost: purchase, closing costs, loan points and fees, rehab with contingency, and holding costs for every month you hold (taxes, insurance, utilities, HOA or other, and loan interest).
- Sale: agent commission, seller closing costs, concessions and net sale proceeds.
- Results: net profit, profit margin, cash-on-cash ROI, ROI on total cost, annualized ROI, profit per month held, break-even sale price and your cushion.
- The 70% rule check: max allowable offer = rule percent x ARV - rehab, compared with your price. The percent is an input, and it is a rule of thumb, not a guarantee.
- Rehab budget by item and category (demo, structural, kitchen, bathrooms, flooring, paint, mechanical, exterior, landscaping, permits, other) plus a contingency percent.
- Hard money, conventional or all cash. Interest-only or amortizing.
- What-if tables: net profit and ROI for ARVs and rehab budgets around yours, and profit for different months held (1 to 18).
- Built-in checks so a typo does not quietly give you a wrong answer.

WORKED EXAMPLE
Buy at $209,000. Rehab $55,000 with 10% contingency. Hold 6 months on a hard money loan. Sell at $385,000.
Total cost: $290,566. Net profit: $67,409. Cash you put in: $57,916. Cash-on-cash return: 116%.
Break-even sale price: $312,905. The 70% rule max offer: $214,500, so this deal passes.
These are fake numbers on the Summary tab. Type your own deal over them.

WHY NOT A FREE CALCULATOR?
Free is fine for a quick guess. This is for a real deal. It adds a rehab budget by category, loan interest and points, holding costs month by month, break-even price and a what-if table. It is an Excel file you keep.

HOW IT WORKS
Blue text = inputs. Black = formulas. Yellow = key assumptions. No macros, no add-ins. Built as an Excel (.xlsx) file.

WHAT YOU GET
- 1 Excel workbook (.xlsx) with 6 tabs: Start Here, Summary, Inputs, Rehab, Holding, Sensitivity
- 1-page HOW-TO-USE PDF
- Instant digital download, delivered as one .zip file

GOOD TO KNOW
- This is a pre-tax screening tool. It does not model income tax, depreciation or local rules.
- Interest is charged every month on the loan balance you set (the price loan plus the share of the rehab loan you say is drawn on average).
- Annualized ROI stretches a short hold to a year, so a quick flip can look very high (the example shows 368%); read it next to the plain ROI and the profit in dollars.
- Not financial, tax or investment advice. Verify every assumption with your lender and contractor before you buy.

Digital download. Nothing ships. You get the file right after purchase. Personal use license, one per buyer, no resale or sharing. Because this is a digital file, I do not offer returns or exchanges, but if the file is damaged, will not open, or is not as described, message me and I will make it right.

Calculator only, not financial, tax or legal advice.

Educational tool, not legal, tax, investment or appraisal advice.

Pairs with: BRRRR Calculator Spreadsheet and Rental Property Analysis Spreadsheet.

Designed by Cap Rate Studio with the help of AI tools. The formulas were recalculated and checked against an independent calculation of the example numbers before release.