Fix-and-Flip Deal Analyzer, Excel and Google Sheets, Rehab Budget, MAO and ROI

Know your numbers before you make the offer.

The Dwell Logic Fix-and-Flip Deal Analyzer is a professional Excel model that turns a purchase price, a rehab budget and a sale price into a clear answer: how much you will make, what return you earn on your cash, and the most you can afford to pay.

Built by a real estate investor with an MBA in urban land economics. Clean charcoal-and-white design with a proper dashboard: no clutter, no macros, nothing to install.

WHAT'S INCLUDED

One Excel workbook (.xlsx) with seven tabs:

• Instructions: quick start, cell legend and assumptions
• Inputs: purchase, closing costs, holding period, financing (cash or hard money / private lender with rate, points and interest-only or amortising), carrying costs (taxes, insurance, utilities, HOA/condo) and selling costs (ARV, commission, closing, staging)
• Rehab Budget: 30 line items by trade, quantity x unit cost, contingency %, running total, % of budget
• Analysis: total project cost, all-in basis, net profit, profit margin, ROI on cash, annualised ROI, maximum allowable offer at your target profit, MAO by the 70% rule, break-even ARV, ARV cushion
• Sensitivity: three two-way tables (ARV vs rehab overrun, holding months vs interest rate, ROI vs overrun) built from live formulas so they work in Google Sheets too
• Timeline: Gantt-style week-by-week schedule by trade; bars draw automatically from start week and duration, and weeks beyond your holding period are flagged
• Summary: one-page dashboard with 12 key metrics on dark tiles, a plain-English deal verdict and four live charts (where the money goes, cost mix, net profit vs sale price, net profit by holding period). The workbook opens on this tab.

WHO IT'S FOR

• First-time and experienced house flippers
• Wholesalers who need a defensible MAO
• BRRRR investors checking the rehab side of a deal
• Anyone comparing several properties quickly and consistently

HOW IT WORKS

1. Enter the deal on the Inputs tab (shaded cells only).
2. Price the renovation on the Rehab Budget tab.
3. Set start weeks and durations on the Timeline tab.
4. Read the Analysis and Summary tabs, then stress-test the deal on the Sensitivity tab before you sign.

Every formula is live and locked against accidental edits. Sheet protection uses no password, so you can unlock any tab in one click if you want to customise it.

WORKS WITH YOUR CURRENCY

Enter $, £ or € once and the model works unchanged for Canada, the United States, the United Kingdom and the Eurozone. Number formats are symbol-free by design.

COMPATIBILITY

Microsoft Excel 2010 or later (Windows and Mac), Google Sheets (upload and open), LibreOffice Calc and Apple Numbers. No macros.

FAQ

Is this an instant download? Yes. Etsy emails the download link as soon as payment clears; you can also download from your Purchases page. No physical item is shipped.

Does it work in Google Sheets? Yes. Upload the file to Google Drive and open it with Google Sheets; formulas, conditional formatting and charts carry across. Sheet protection converts to Google's protected ranges.

Can I add my own rehab line items? Yes: four blank rows are provided, and the subtotal picks them up automatically. Unprotect the sheet to insert more.

What if my lender only funds the purchase, not the rehab? Set "Loan: % of rehab budget funded" to 0%.

Does it handle cash deals? Yes. Choose Cash and financing costs drop to zero; ROI is then calculated on your full outlay.

Can I change the 70% rule? Yes, the percentage is an input: use 75 to 80% in expensive or low-margin markets.

Can I get a refund? Digital files cannot be returned once downloaded, in line with Etsy policy. If something does not work as described, message us and we will fix it or make it right.

LICENCE

Personal-use licence. One purchase covers unlimited personal deals on your own devices. You may not resell, share, redistribute or republish this file, or a modified version of it, in whole or in part. All rights reserved by Dwell Logic Investing Inc.

DISCLAIMER

This tool is for education and planning. It is not financial, legal, tax or investment advice. Verify all figures with your own professionals before acting on them.

© 2026 Dwell Logic Investing Inc. | dwellogic.com