The Spreadsheet Era of Business Acquisition Analysis Is Over
The Spreadsheet Era of Business Acquisition Analysis Is Over
For thirty years, the default tool for evaluating a small business acquisition was a spreadsheet and a broker-supplied income statement. That era is over — not because spreadsheets are wrong, but because they were never the right tool for the job.
A spreadsheet calculates what you put in. It does not tell you what to weight. It does not catch the deal that pencils at 1.4x DSCR on paper but falls apart because 70% of revenue comes from one customer. It does not flag the HVAC company that looks transferable until you discover the technician is the owner's son, who is leaving. It does not tell you whether $300K SDE at a 3.5x multiple is a fair price or a trap.
Spreadsheets were never analysis. They were arithmetic. Acquirers who treated them as the same thing spent thirty years making $500,000 decisions with the wrong tool.
The Problem With How Buyers Have Been Evaluating Deals
Walk into any ETA community — SearchFunder, Acquisition Lab, any deal forum — and ask how someone evaluated their last acquisition. You will hear a version of the same story:
- Broker sent the CIM.
- Buyer opened Excel.
- Buyer typed in the SDE and the asking price.
- Buyer calculated the multiple.
- Buyer decided whether the multiple felt right.
That is it. That is the entire framework most buyers have used for the most consequential financial decision of their career.
The multiple-feel method has three fatal flaws:
It relies on a number you cannot verify. The SDE in the broker's package is almost never the real SDE. It does not subtract an owner replacement salary. It does not account for CapEx reserves. It includes add-backs the seller's accountant classified optimistically. The multiple you calculate from this SDE is a multiple of fiction.
It ignores dimensions that determine whether a business survives a transition. A landscaping company trading at 2.5x SDE sounds cheap. It is not cheap if 80% of the revenue is on month-to-month contracts with three clients, the owner has worked 65 hours per week for eight years, and the only marketing that works is the owner's personal referral network. The multiple does not tell you any of that.
It optimizes for the wrong question. Buyers ask: Is this multiple fair? The real question is: What is the probability this business survives the transition and generates the projected cash flow under my ownership? Those are not the same question, and a spreadsheet cannot answer the second one.
What Changed
Two things changed that made this problem solvable.
First, the information environment. There are now enough closed transactions, SBA default data, and lender underwriting standards documented publicly that we can map what distinguishes acquisitions that generate their projected returns from acquisitions that don't. The signals are not mysterious. They are measurable. SDE margin. DSCR. Owner concentration. Customer concentration. Years of operating history. These inputs correlate with outcomes in ways that multiple-feel analysis never captured.
Second, the tools. Institutional acquirers — private equity, family offices, strategic buyers — have used multi-dimensional scoring frameworks for decades. They did not evaluate targets by multiple alone. They ran deals through checklists, scored dimensions separately, and built weighted verdicts from evidence. That methodology was inaccessible to individual buyers because it required financial modeling sophistication and deal volume that nobody in the ETA space had.
Until recently, you needed to close 50 deals to develop the intuition those frameworks represent. Now you do not.
What a Framework Does That a Spreadsheet Cannot
A scoring framework evaluates a deal across independent dimensions simultaneously. It makes the tradeoffs visible.
Consider the difference between these two outcomes on the same deal:
Spreadsheet view: $450K SDE, $1.35M asking price, 3.0x multiple. Looks reasonable.
Framework view:
- Business quality: 4/5. SDE margin is 24%, business has operated 8 years. Strong.
- Risk/DSCR: 2/5. DSCR at 10% down is 1.12x — below SBA minimums. One top client is 40% of revenue.
- Income return: 2/5. After debt service and owner salary, cash-on-cash return is 11%. Thin.
- Transferability: 1/5. Owner works 55 hours per week. No manager layer. Entirely owner-dependent.
Verdict: Caution. Multiple dimensions are stacked against this deal at the current price.
The spreadsheet said looks reasonable. The framework said the fundamentals do not support this price. Same numbers, different intelligence.
The framework does not tell you to walk away. It tells you where the problems are — so you can decide whether to renegotiate, restructure the terms, or ask harder questions during diligence. That is what analysis is supposed to do.
The DSCR Trap That Kills Deals at Closing
The single most common failure mode I have seen in first-time acquisitions is what I call the DSCR trap: the deal looks fine on the buyer's spreadsheet, looks fine in the broker's CIM, and then gets declined at the SBA lender's desk three months into the process.
Here is how it happens.
The buyer calculates DSCR using SDE in the numerator. SBA lenders do not do that. They subtract an owner replacement salary — what a qualified manager would cost to run the business — before calculating coverage. They add a tax reserve. Sometimes they add a CapEx reserve for aging equipment or aging vehicles.
The buyer sees 1.8x DSCR. The lender sees 1.09x DSCR. The deal is dead.
Twenty-five thousand dollars in due diligence costs. Three months of attorney fees. A seller who is now furious and may not give you another chance. All because the framework the buyer used calculated a different number than the framework the lender used.
A proper acquisition scoring framework uses lender math, not buyer math. It calculates DSCR the way the underwriter will calculate it — not the way it looks flattering on a pitch deck. This is not a technical nicety. It is the difference between closing and walking away empty.
Why the Enemy Is Not a Competitor — It Is a Paradigm
I want to be direct about something: the problem we are solving at BuyBox is not "better than ClearlyAcquired" or "better than a spreadsheet template." The problem is a thirty-year paradigm that taught buyers to evaluate deals with arithmetic when they needed analysis.
The companies and tools that came before us are not the enemy. They were working with the tools available to them. The paradigm is the enemy.
The paradigm says: Get the SDE. Get the multiple. Trust your gut. The paradigm produced deal-makers who closed one or two acquisitions and spent years nursing businesses back to health because the analysis missed something obvious in hindsight. The paradigm produced lender declines that killed deals three months in. The paradigm produced buyers who overpaid — not because they were unsophisticated, but because the method they were taught did not measure what mattered.
We are building the tool for the acquirer who has moved past that paradigm. The acquirer who wants a verdict, not just a calculation. The acquirer who runs deals through a framework before they LOI. The acquirer who knows that an 87/100 BRIT Score on a home services company at 3.2x SDE is more useful information than a 3.2x multiple in isolation.
Score before you LOI.
That is the operating principle. Not because BuyBox says so, but because serious acquirers have always worked this way. We are just making it accessible.
What This Looks Like in Practice
A buyer in the ETA community described how they use the BRIT Score framework:
"I used to do four or five hours of spreadsheet work on every deal just to figure out if it was worth diligencing. Now I run the BRIT Score in ten minutes. If it comes back CAUTION or AVOID, I understand why — and I either pass or I know exactly what to ask the seller. It cut my time per deal by about 70%."
This is not about replacing diligence. It is about concentrating diligence on deals that deserve it.
A framework does not eliminate risk. No tool does. A business is a living system and full diligence is non-negotiable before you close. What a framework does is tell you, before you spend $20,000 on an attorney and a QoE, whether the fundamentals of the deal are worth that investment.
The Acquirers Who Will Win the Next Decade
There are roughly 30,000 active searchers in the ETA community globally. Most of them are using the same methodology their mentors used — the multiple-feel method dressed up with a few more Excel rows.
The acquirers who will win the next decade will be the ones who adopted frameworks before the rest of the market did. Not because frameworks make bad deals good, but because frameworks let you see bad deals faster, reject them more confidently, and spend your diligence budget on deals that actually pencil.
The spreadsheet era produced acquirers who were proud of their gut. The framework era produces acquirers who are proud of their process.
Those two types of buyers are not equal in the market. One of them closes two acquisitions per decade and wonders why it feels so hard. The other builds a disciplined pipeline, knows their criteria cold, and moves quickly when the numbers work.
The tool is not the differentiator. The process is.
But you cannot have a process without a framework. And you cannot have a framework if you are still asking a spreadsheet to be something it was never built to be.
Where to Start
If you are evaluating deals now and want to start with the framework before the LOI, the BRIT Score Quick Check is free and takes 60 seconds. Enter six inputs, get a four-dimensional verdict.
If you want to understand how SDE is calculated before you put numbers into any tool, the SDE Calculator walks through the add-back math step by step.
If you want to understand exactly how the BRIT Score methodology is constructed and what the SBA basis for each dimension is, read The BRIT Score Methodology.
The spreadsheet is still there for calculations. It is a fine calculator. It was never an analyst.
Brandon Quijano is the founder of BuyBox, an acquisition analysis platform for SMB acquirers in the $500K–$2M deal range. BuyBox was built on the premise that serious acquirers deserve institutional-grade analysis tools — without needing an institutional budget to access them.
Brandon Quijano
Acquisition strategist & builder of BuyBox
