Wholesale Deal Analyzer Pro
Comps to MAO to a scored verdict before you make the offer
A 6-sheet Excel workbook for wholesalers: enter three comps and a 50-line rehab estimate, get ARV, maximum allowable offer, buyer equity, a rental check, and an automatic deal verdict.
A wholesale deal dies in one of two places: you offer too much and no cash buyer will take the assignment, or you guess at repairs and the spread you promised evaporates on the walk-through. Most new wholesalers run these numbers on a napkin, in a hurry, with a seller waiting on the phone. The math is not hard, but it has to be done the same way every time, and it has to include the assignment fee you intend to earn.
The Wholesale Deal Analyzer Pro is a 6-sheet Excel workbook with 38 live formulas and a step-by-step How To Use sheet. The Rehab Estimator holds 50 line items across 12 categories (roof, foundation, HVAC, plumbing, electrical, windows and doors, kitchen, bathrooms, flooring, paint, exterior, permits) with category subtotals and a contingency percentage; the total flows into the Deal Analyzer automatically. On the Deal Analyzer you type three comparable sales with square footage, the sheet averages price per square foot and estimates ARV (with an override cell), then computes MAO as ARV times your percentage rule minus repairs minus assignment fee. It also shows your offer as a percentage of ARV, the spread versus MAO, and the equity your end buyer sees after your fee. The Deal Scorecard runs four tests (offer within MAO, offer within the ARV rule, fee at least $5,000, buyer equity at least $20,000) and returns STRONG DEAL, WORKABLE, or PASS. The Rental Analysis sheet gives a buy-and-hold exit check with mortgage payment, NOI, cap rate, and cash-on-cash. A 25-row Pipeline sheet tracks address, status, ARV, repairs, offer, next action, and follow-up date.
The result is an offer you can defend to a seller and a spread you can defend to a buyer. First 15 minutes: read the How To Use sheet, enter your three comps and the subject square footage, then walk the Rehab Estimator with your repair numbers and read the verdict. Yellow cells are inputs; everything else calculates. Works in Microsoft Excel and Google Sheets.
Who it's for
For wholesalers and new investors who need a repeatable way to turn comps and a repair walk-through into an offer and a buyer-ready spread. Not for flippers modeling their own hold and sale costs, who should use the Fix & Flip Profit Calculator, or landlords underwriting a long-term hold, who want the Rental Property Cash Flow Calculator.
Use it when
- A seller is on the phone and you need a defensible offer number in the next ten minutes
- You walked the property and want the repair list turned into a total with contingency
- A cash buyer asks what equity is left after your fee, and you want the answer on one sheet
- You are juggling a dozen leads and need every offer, status, and follow-up date in one place
- A buyer says they will hold it as a rental and you want to check the cap rate before you pitch
What you download
Every file in the XLSX download.
Inside the files
- Deal Analyzer: 3 comps to ARV, MAO, buyer equity, spread vs MAO
- Rehab Estimator: 50 line items in 12 categories with contingency
- Deal Scorecard: 4 automatic tests, STRONG / WORKABLE / PASS verdict
- Rental Analysis: mortgage payment, NOI, cap rate, cash-on-cash
- Pipeline: 25 deal rows with status, numbers, next action, follow-up
- How To Use sheet: 5 steps, yellow cells mark every input
What changes once you use it
- 1Know your maximum offer before the seller asks for a number
- 2Repair estimate built line by line, not guessed as a lump sum
- 3Assignment fee is inside the math, so the spread you quote is real
- 4Scorecard flags thin equity before you send the deal to buyers
- 5Rental check shows whether a landlord buyer can hold the property
- 6One workbook for the deal, the rehab, and your active pipeline
Common questions
What software do I need?
Microsoft Excel or Google Sheets. The file is a standard .xlsx with no macros, so it also opens in LibreOffice and Numbers.
How is MAO calculated?
ARV times your percentage rule (70% by default, editable) minus the rehab total from the estimator minus your assignment fee. The scorecard uses the same rule cell, so if you change 70% to 75% every test updates with it.
Why not a free template or ChatGPT?
Free MAO calculators stop at ARV x 70% minus repairs and leave out the assignment fee, which is the number that decides whether a buyer takes the deal. This workbook ties a 50-line rehab estimate, the fee, the buyer's equity, and a rental exit into one verdict, and every formula is visible so you can audit it.
Can I use it for more than one deal?
Yes. Duplicate the Deal Analyzer and Rehab Estimator tabs per property, or keep the analysis for the deal in front of you and log the rest on the 25-row Pipeline sheet. For a BRRRR exit, pair it with the BRRRR Strategy Analyzer.
Is it a one-time purchase?
Yes. Pay once, keep the file, and future updates to this product are included.
💰 Fund: Line up cash buyers and private money
Got this handled? Here's what comes next in the deal.
Cash Buyer Deal Presentation Template
Turn a deal into a one-read packet cash buyers can say yes to
- ✓Cover page with property, buyer, and your contact fields
- ✓At-a-glance block: price, ARV, repairs, flip profit, cash flow
- ✓Fix & Flip and Rental analyses laid out side by side
Cash Buyer & Investor Email Swipe File
30 fill-in-the-brackets emails to build and work a cash buyer list
- ✓8 Cold Outreach emails to introduce yourself to new investors
- ✓6 Deal Submission emails: flip, rental, pocket deal, price drop
- ✓5 Follow-Up emails to re-engage quiet buyers, ending in a last call
Private Money Pitch Deck Template
A 12-slide lender pitch with the security and downside slides investors ask for
- ✓Confidential cover: target amount, rate, term, and secured property
- ✓Opportunity, Track Record, and Team slides with bracketed proof points
- ✓Deal and Numbers slides: all-in cost, ARV, loan-to-ARV, worst case