Real Estate Wholesaling Spreadsheet: Analyze, Track & Close Profitable Deals

Written by

Alex Martinez — Founder & CEO, Real Estate Skills. Has wholesaled and flipped houses across the country for over a decade, personally acquiring 33+ residential investment properties.

RZ

Reviewed by

Ryan Zomorodi — Co-Founder & COO, Real Estate Skills. Reviewed and verified the deal-analysis math, assignment-fee figures, and offer calculations in this guide before publication.

✓ Updated June 2026 ✓ Fact-Checked 📊 Free Deal Calculator Inside Watch on YouTube

Publication history: Originally published October 17, 2025. Updated June 2026 with a free interactive ARV & maximum offer calculator, a full worked deal example, a breakdown of why the 70% rule leaves money on the table, a populated deal-tracker layout, an expanded KPI section, and a rebuilt FAQ. Deal-analysis math and figures verified by Ryan Zomorodi, Co-Founder & COO of Real Estate Skills.

Most wholesalers don't lose deals because they can't find them. They lose them because they can't keep track of them. Five sellers in the pipeline, two under contract, and somewhere in a pile of texts and notes is the one number that actually matters on each: the price you can pay and still get paid. Miss it, and you either overpay and kill your own spread, or you fumble the follow-up and watch the deal go cold.

That's the entire job of a wholesaling spreadsheet. One place that tells you whether a deal works before you offer, then keeps every lead, contract, and deadline in front of you until you close. The analysis side answers the only question that counts at the offer stage — what's the most I can pay and still make my fee? The tracking side makes sure no deal slips through the cracks while you're busy on the next one.

Below, you can run a real deal yourself. There's an interactive calculator that takes a property from comps to your maximum offer to your contract price, a full worked example with real numbers, and the exact tracking structure — leads, contracts, KPIs — that turns a one-off calculation into a business you can scale. If you want a copy to keep and build on, you can grab the free Deal Calculator spreadsheet further down.

How To Analyze Wholesale Deals & Calculate Offer Price!

Alex Martinez analyzes a real wholesale deal start to finish and shows how to reverse-engineer your offer price to lock in your assignment fee.

 

What Is a Real Estate Wholesaling Spreadsheet?

At its core, a wholesaling spreadsheet does two jobs that have nothing to do with each other except that both decide whether you make money. Before you offer, it's a calculator: enter what a property is worth fixed up and what the repairs run, and it tells you the most you can pay and still collect your fee. After you're under contract, it's a tracker: every lead, every deadline, every buyer, in one place so nothing slips while you're chasing the next deal.

Most beginners try to run a wholesaling business out of their phone — a deal in their texts, a number in their notes app, a buyer's contact buried in their email. It works until you've got more than two deals going, and then it doesn't. The spreadsheet exists because the business has too many moving parts to hold in your head, and the deals that fall apart are almost always the ones nobody was tracking.

A complete wholesaling spreadsheet has four parts, each doing one job:

A deal analyzer takes a property's after-repair value and repair estimate and returns your maximum offer and your assignment fee. This is the part you use before you ever pick up the phone — the go/no-go.

A lead tracker logs every motivated seller, where they came from, and where the follow-up stands, so you can see which marketing actually produces deals.

A contract tracker holds every deal under contract — dates, deposits, deadlines, buyer, title status — so a deal moves from signed to closed without a missed date killing it.

And a KPI tab turns all that deal data into a scoreboard: leads-to-contracts, average assignment fee, cost per deal, so you can see whether the business is actually working.

You don't need all four to start. A single tab that calculates your offer will get you making offers today. The rest is what turns a one-off calculation into a business you can run and scale.

Core Deal Analysis: ARV, MAO & Your Assignment Fee

Every wholesale deal is a reverse-engineering problem. You're not guessing at an offer and hoping it works — you start from what the house is worth fixed up and subtract your way down to the highest price you can pay and still get paid. Four numbers do all the work: the after-repair value, the repair cost, your assignment fee (the profit you collect for putting the deal together, without ever owning the property), and the offer price you're solving for. Get those four in the right order and the offer protects itself.

One thing before the math: you don't analyze every property. That's a beginner mistake that buries you in busywork. You analyze a property after you've had a good call with the listing agent and you know there's a real chance — that's how you spend your time on deals that can actually close instead of underwriting houses nobody will sell you.

Start With the ARV (After-Repair Value)

This is what your property will sell for once it's renovated, and it's the ceiling every other number works back from. You find it with comps — recently sold, renovated homes near your subject property that match it closely: same property type, within about 20% of the square footage, same bed/bath count, sold in the last six months, in the same city and zip, ideally within a half-mile. Find three to five that fit, look at what they sold for, and you've got your ARV.

On a real example: three solid comps come in around $595,000, $600,000, and $605,000 — apples to apples — so you set the ARV at $600,000. That's the ceiling. Comping takes practice to master; for the full step-by-step on pulling comps and setting an ARV, see our guide on real estate comps.

Then the Repair Cost — and Here's Where Wholesaling Is Different

As a wholesaler, you never pay for repairs. Your cash buyer does — they're the one renovating and reselling. So you're not building a contractor's line-item estimate; you're ballparking repairs just well enough to reverse-engineer your offer. The fastest way to do that is a dollar-per-square-foot rule you get from your cash buyers. Talk to the people who actually buy your deals and you'll learn their numbers — say $40 a square foot for a cosmetic renovation in your area. On a 1,478 sq ft house, round to 1,500, times $40, and you've got roughly $60,000 in repairs. That covers it as long as the work is cosmetic — no new roof, no cracked slab.

For deeper repair estimating, our house flipping rehab estimator breaks it down by line item — but as a wholesaler you rarely need that level. Your buyer does.

Now Reverse-Engineer the Offer

You've got a $600,000 ARV and $60,000 in repairs. You know from talking to your cash buyers what profit they need to say yes. And you know the fee you want — let's say a $10,000 assignment fee. Run those through a deal calculator that also accounts for the costs a buyer factors in (property taxes, insurance, closing, utilities), and it hands you your number: on this deal, you can offer around $445,000 and still lock in your $10,000 fee. That's your maximum offer — the most you can pay and still get paid.

Why the 70% Rule Leaves Money on the Table

Here's the part almost no one shows you, and it's the difference between winning deals and getting beaten on every one.

Most beginners don't use a real calculator. They use the 70% rule: take the ARV, multiply by 70%, subtract repairs, subtract your fee, and call that your maximum offer. On our deal that math is $600,000 × 70% = $420,000, minus $60,000 repairs, minus a $10,000 fee — which lets the beginner offer just $350,000.

But the pro, running real numbers and knowing the cash buyers' actual minimums, can offer $445,000 on the same house and still make the same $10,000 fee. That's $95,000 more than the beginner can offer — on the identical property. When you can beat every other wholesaler's offer by tens of thousands of dollars and still hit your fee, you win the deal. Every time.

The 70% rule isn't useless — it's a fast gut check for screening, and it deliberately pads in costs like closing and HOA fees with one rough multiplier. But it's blunt. It bundles every cost into a single percentage and leaves real offer room on the table. If you're submitting 70%-rule offers and losing every deal to someone who offers more, that's why: you're using paper-napkin math against people running the real numbers. A quick upgrade if you're not ready for a full calculator is to run 80% instead of 70% — on this deal that lifts your offer to about $410,000, still well above the beginner's $350,000. But the real answer is to run the actual numbers, which is exactly what the calculator below does.

Build your ARV from comps, set your repair budget and your rule, then enter your assignment fee at the bottom to see the exact contract price that pays your fee and still leaves your buyer at their maximum offer:

Lead & Marketing Tracking

In wholesaling, nothing happens until a motivated seller raises their hand, and motivated sellers come from marketing you have to track or you're flying blind. A lead tracker is just a running list of every seller who comes in, with enough detail attached that you can tell, weeks later, which channel and which follow-up actually turned into a contract. Without it, you're spending on direct mail or cold calls and guessing whether any of it works.

Keep the columns simple and useful: lead source (direct mail, cold call, PPC, text), contact attempts, last contact date, a motivation score, and follow-up status. The motivation score is the one that earns its keep — rate each motivated seller 1 to 5, and give the high numbers to the ones showing real urgency: pre-foreclosure, a vacant property, an inherited house they don't want. That score tells you who to call first on a Monday when you've got twenty leads and three hours. Most deals come from the fifth or sixth contact, not the first, so the follow-up column is what catches the money everyone else leaves on the table by quitting after one call.

The reason to track all this isn't the leads themselves — it's the math underneath them. A handful of numbers tell you whether your marketing turns dollars into contracts:

• Cost per lead — marketing spend ÷ leads generated. What each channel charges to put a seller in front of you.
• Cost per deal — marketing spend ÷ closed deals. The number that actually matters; the one you scale or cut against.
• Conversion ratio — leads ÷ signed contracts. How well your leads and offers turn into deals.
• Response rate — responses ÷ outreach attempts. Whether your message and list are landing.
• Marketing ROI — assignment fee ÷ marketing spend. The return on a channel, in plain terms.

Here's how that plays out on a real channel. You spend $1,200 on direct mail and it generates 40 leads — that's $30 a lead. Three of those leads turn into contracts, so your cost per contract is $400. One of those closes with a $10,000 assignment fee. That channel didn't cost you $30 or $400 — it returned roughly eight times what you put in. The point of the tracker is that you know that, instead of guessing, so you can pour more into what works and cut what doesn't. (Illustrative numbers; results vary by market and channel.)

That last part is the discipline: cost per lead is interesting, but cost per deal is what you manage to. A channel that produces cheap leads that never close is more expensive than a channel with pricey leads that close — and only the tracker tells you which is which. Review it weekly, sort by follow-up date so no seller goes cold, and the patterns show up fast: which channels deserve more budget, and where your next deal is most likely coming from.

Contract & Transaction Management

Once a property is under contract, the job changes. You're not finding deals anymore — you're protecting one, and the way deals die at this stage is boring: a missed inspection deadline, an earnest-money deposit that didn't go in on time, a contract you assumed was assignable that wasn't. Every one of those is preventable, and the tracker is how you prevent them. Think of it as a timeline that surfaces the next deadline before it becomes an emergency.

Here's the structure that does the work. Each deal is a row; each column is a thing that can sink you if you lose track of it. Below is a two-deal tracker showing one deal closed and one mid-pipeline:

A few of these columns carry more weight than the rest:

Assignable? (Y/N) is the one to check before you market the deal, not after. Most contracts are assignable by default, but some prohibit it or require the seller's written consent — and finding that out after you've promised the deal to a buyer is how you lose the buyer and your reputation at once. Confirm it the day you go under contract. For how assignability actually works — and the contract language that protects your fee — see our guide on the wholesale real estate contract.

EMD due date and inspection deadline are the two dates that protect your money. Your earnest money is refundable while your inspection contingency is alive; once that window closes, it's at risk. Miss the deadline to act and you can lose your leverage and your deposit at the same time. Set a reminder a few days before each — not the day of.

Status is what turns a list of rows into a pipeline. Tag every deal Active, Under Contract, Assigned, or Closed, and at a glance you can see where your money is and what needs attention this week. This single column is the difference between "I have some deals going" and knowing exactly where each one stands.

The move that separates people who hit their closings from people who scramble: build the timeline backward from the closing date. Closing is the 20th; the assignment needs to be at title by the 12th; title needs to be clear by the 16th; your inspection window closes on the 11th. Work backward and set a reminder on each, and the deal runs on rails instead of on adrenaline.

The tracker above uses illustrative deals for demonstration. This is educational, not legal advice — assignment rules, contingencies, and disclosure requirements vary by state, so confirm the specifics with a licensed real estate attorney or title company in your market.

KPI Reporting & Profit Tracking

Deal analysis tells you whether one property works. KPIs tell you whether your business works. This is the section most beginners skip, and it's the one that separates people who do a deal from people who build something repeatable. The point isn't to drown in metrics — it's to track the few numbers that actually drive the business, look at them on a schedule, and let them tell you where to put your time and money.

Here's what to track and why each one matters. Build these as formulas in your sheet so they calculate themselves every time you log a deal — the whole value of a KPI dashboard is that the math is already done when you open it.

A few of these deserve a closer look, because they're the ones that change how you run the business:

Leads-to-contracts is your front end. If you're generating plenty of leads but almost none turn into signed contracts, the problem isn't lead volume — it's your offers, your follow-up, or the leads themselves. A low ratio here is usually a sign you're either offering too low (remember the 70%-rule trap above — beginners lose deals they could've won) or not following up enough.

Marketing cost per deal is the number that tells you whether to scale a channel or kill it. Spend $1,200 on direct mail, close one deal from it, and that channel cost you $1,200 per deal — fine if the fee was $10,000, a problem if it was $4,000. Track this per channel and the spreadsheet tells you exactly where your next marketing dollar should go.

Average assignment fee is the one to watch over time. If it's climbing, you're getting better at locking up deals with room in them. If it's flat or falling, you're either competing too hard on price or taking thin deals to stay busy. This single number, tracked across months, is the clearest read on whether your business is getting stronger or just busier.

The discipline that makes all of this work is reviewing on a schedule — weekly for the active pipeline, monthly for the trends. Numbers you log but never look at don't run a business. Numbers you review every Friday do.

Excel vs. Google Sheets & Common Questions

You don't need to buy software to wholesale. A spreadsheet you build or download does everything the analysis and tracking require, and the only real decision is which program to run it in.

Excel is the more powerful tool for heavy formulas and works without an internet connection, which suits people who already live in it. Google Sheets is free, opens in any browser, saves automatically, and — the part that matters most for wholesaling — lets more than one person work in the same file from any device. When your cash buyer, your partner, or your virtual assistant can open the live pipeline and see exactly where every deal stands, you stop emailing versions back and forth and wondering which one's current. For a business that's often run partly or entirely virtual, that shared-access piece is usually the deciding factor. Most good templates, including ours, open in both — so you're not locked in either way.

A few questions almost everyone asks before they download one:

Is a wholesaling spreadsheet free? Yes. You can build your own in Excel or Google Sheets at no cost, use the free calculator on this page, or download our free Deal Calculator spreadsheet below. Paid software exists and adds automation, but nothing about analyzing or tracking a wholesale deal requires you to pay for a tool.

What should it include? At minimum, four things: a deal analyzer (ARV, repairs, your maximum offer, and assignment fee), a lead tracker, a contract/transaction tracker, and a KPI tab. Those four take a deal from first seller contact all the way to your fee at closing — which is exactly the order this guide walks through.

Can one spreadsheet handle multiple deals? Yes — that's the whole point of running it as a system instead of a one-off calculation. Give each property its own row (or its own tab for detail), and you can compare deals, watch deadlines across your whole pipeline, and track your numbers as you scale. A single calculation tells you about one house; a spreadsheet runs the business.

Stop Guessing. Calculate Your Exact Offer in Seconds.

Wholesaling is a numbers game. If your math is off by even a few percent, your assignment fee disappears. Don't risk your deal on back-of-the-napkin math. Download our free Deal Calculator spreadsheet to instantly determine your Maximum Allowable Offer (MAO), factor in your costs, and lock in your profit spread with total confidence before you ever make an offer.

Real Estate Wholesaling Spreadsheet FAQs

Final Thoughts on Real Estate Wholesaling Spreadsheets

A wholesaling spreadsheet doesn't find deals and it doesn't close them. What it does is tell you the truth about a deal before your name is on a contract, and keep every deal you've got in front of you so none of them slip. That's it — and that's most of the job. The wholesalers who last aren't the ones with the biggest marketing budget or the hottest market. They're the ones who know their numbers cold, so when a deal gets tight — an inspection clock running, a buyer wavering, a seller getting nervous — they already know exactly where they stand and what to do next.

Everything on this page comes back to one move: work backward from the after-repair value to the offer that pays you and still leaves your buyer a deal. Get that number right and you can outbid the wholesaler down the street by tens of thousands and still make your fee. Get it wrong — or skip the tracking and let a contract fall through the cracks — and a deal that worked on paper turns into a lost deposit or a blown spread.

So start with one deal. Run a real property through the calculator above. Build the four tabs — analyzer, leads, contracts, KPIs — even if it's just a few rows to begin. And the next time you're staring at a property, you won't be guessing at an offer; you'll know your number before you pick up the phone. That's the difference between talking about wholesaling and running it as a business.

About The Author

Alex Martinez

Founder & CEO, Real Estate Skills

Alex Martinez is the Founder and CEO of Real Estate Skills. With more than a decade of investing experience and 33+ residential properties acquired, he has personally wholesaled and flipped houses across the country. Through Real Estate Skills, Alex and his team have helped thousands of students learn how to analyze deals, calculate their offers, and close profitable wholesale transactions.

Full Bio LinkedIn YouTube Instagram

Real Estate Skills is not a law firm or a financial advisor, and the information in this article is provided for educational purposes only — it does not constitute legal, tax, or financial advice. Wholesale real estate laws, contract requirements, and market values vary by state and change over time, and the figures here are illustrative planning estimates, not guarantees. Real estate investing carries risk, and past results do not guarantee future outcomes. Always run your own numbers and consult a licensed real estate attorney and your own tax and financial advisors before entering into any contract or transaction.