The comparison between Acquidex and manual spreadsheet analysis in SMB acquisitions is not a question of computational power — both can do the math. The distinction is methodological enforcement. SBA lenders calculate SDE from filed tax returns using SBA SOP 50 10 8 normalization standards, and calculate DSCR using global cash flow that includes the buyer's personal debt obligations. Most buyer spreadsheets do neither. They start from broker-adjusted P&L figures, apply add-backs based on buyer judgment rather than lender standards, and omit personal debt from the coverage calculation. The resulting SDE figure can be 20–35% higher than what an SBA underwriter will produce from the same deal — a gap that determines whether the deal closes at the agreed price or requires restructuring after 90 days of work. Acquidex addresses this by enforcing the normalization methodology by default: tax return inputs, SOP 50 10 8 add-back logic, and personal debt inclusion in DSCR. What it does not do is replace post-LOI diligence, CPA final review, or the analytical depth a sophisticated operator with CPA support can build in a custom model. The right tool depends on the buyer's profile, deal volume, and whether the analytical gap is a feature or a risk.
The Frame That Actually Matters
Spreadsheets are not wrong. The question is whether the model you've built produces the same number the lender will produce.
This matters because the SBA underwriter will recalculate everything from the filed tax returns. They will apply SBA SOP 50 10 8 add-back standards, strip the categories that don't survive that test, benchmark owner compensation against NAICS data, and run the DSCR against the buyer's global cash flow — which includes personal debt obligations, not just the acquisition loan. If your model starts from the broker's recast and the lender starts from the tax return, the two calculations will diverge. That divergence is not a surprise. It is structural and predictable.
The question is not whether you use Excel. It's whether your model enforces the methodology the lender will use. If it does, a spreadsheet is fine. If it doesn't, the methodology gap will surface at underwriting regardless of how clean your model looks.
For foundational context before going further, what SDE actually means and how brokers present it differently than lenders measure it are worth reading first.
Where Spreadsheets Win
Spreadsheets are the right tool for a meaningful slice of the SMB buyer market. It's worth being direct about that.
Full flexibility. A custom model can accommodate any deal structure, any industry, any add-back scenario. No software product matches the flexibility of a blank spreadsheet and a CPA who knows what they're doing.
No learning curve. If you know Excel, you know how to build the model. There is no onboarding friction, no platform to learn, no export format to navigate.
Free. For operators managing deal flow across multiple targets simultaneously, the cost of analytical tooling adds up. A well-constructed spreadsheet template carries no marginal cost per deal.
Shareable in any format. Excel files, PDFs, Google Sheets — a spreadsheet output moves through any workflow without compatibility constraints.
Right for: Operators running ten or more deals per year with a CPA on retainer who reviews every model. At that level of deal volume and analytical support, the methodology lives in the CPA's review layer, not in the tool. The spreadsheet is the execution surface. The CPA is the methodology enforcement.
If that description fits your situation, the spreadsheet is not the problem. Keep using it.
Where Spreadsheet Models Break Down
For most buyers — particularly first acquisitions and SBA-financed deals — there are five places where a self-constructed spreadsheet model creates real pricing risk.
Confirmation Bias
Buyers build models with an outcome in mind. The deal they're looking at is interesting. They've spent time on it. The model they construct reflects, in ways that are often unconscious, what they want to see. Without an external methodology enforcing which add-backs are acceptable, the inputs trend toward the number that makes the deal work.
This is not a character flaw. It is a predictable outcome of self-constructed models in high-stakes decisions. A tool with enforced methodology removes that drift by applying the same standards regardless of the buyer's preferences.
SBA SOP 50 10 8 Compliance
Most buyer models don't follow lender add-back standards. They add back meals and entertainment, personal auto, cell phone, and travel expenses — categories that appear in nearly every broker CIM and are routinely stripped at SBA underwriting.
A buyer can build a spreadsheet showing $400,000 SDE using the broker's add-back categories. An SBA underwriter reviewing the same deal will calculate $290,000. At a 3x multiple, that's a $330,000 difference in supportable offer price. The deal that penciled in the buyer's model doesn't pencil at the bank — and that discovery happens after the LOI is signed.
For the specific categories that consistently get challenged at underwriting, how brokers construct SDE and which add-backs SBA lenders actually accept are the relevant references.
Global DSCR
Most buyer models calculate DSCR as: normalized business cash flow ÷ annual acquisition debt service. That is not the calculation a lender runs.
SBA lenders calculate DSCR using global cash flow — the buyer's complete financial picture, including personal income sources and personal debt obligations. A buyer carrying $3,500 per month in personal debt (mortgage, car payment, student loans) has a materially different DSCR profile than a buyer carrying $800 per month, even if they're looking at identical businesses at identical prices. A model that omits personal debt from the denominator produces a DSCR that looks like a commitment and functions like a guess.
The mechanics of how lenders construct this calculation are covered in detail in how to calculate DSCR for SMB acquisitions.
Version Control
You're running six deals. Which version of the SDE model is current? Which one did you send the lender last week? Which one reflects the broker's updated recast from Tuesday?
In a spreadsheet-driven process, version control is manual at best and absent at worst. By the time a deal reaches the lender, there may be four or five iterations of the analysis with no clean record of which assumptions changed between them. That ambiguity creates problems — both in lender conversations and in later negotiations.
Auditability
At some point in the deal process, your model will be reviewed by someone who wasn't in the room when you built it — an attorney, a lender, a seller who wants to understand the offer. The question is whether they can reconstruct your methodology in ten minutes or whether it requires a thirty-minute walkthrough of your add-back logic.
A model built on lender-standard methodology with disclosed inputs can explain itself. A personal spreadsheet with custom add-back categories and no source documentation cannot.
The Methodology Gap: A Worked Example
To make the gap concrete, here is the same deal analyzed two ways.
The deal: A service business listed at $930,000. The broker's CIM shows $400,000 SDE at a 2.3x multiple. The buyer builds their own model and produces a similar figure. They proceed to LOI.
The lender's calculation:
| Line Item | Buyer Model | Lender Calculation | Status |
|---|---|---|---|
| Net income (starting point) | $195,000 (recast) | $172,000 (tax return) | Gap: CIM vs. filed return |
| Owner compensation add-back | +$110,000 | +$110,000 | Accepted |
| Replacement manager (market rate) | Not modeled | −$85,000 | Applied by lender |
| Meals & entertainment | +$28,000 | $0 | Rejected — not lender-defensible |
| Personal auto | +$19,000 | $0 | Rejected — operational |
| Non-recurring items (stated) | +$31,000 | $0 | Rejected — recurring in returns |
| Depreciation / amortization | +$17,000 | +$17,000 | Accepted |
| Normalized SDE | $400,000 | $214,000 |
At a 3x multiple on the buyer's SDE, the supportable offer price is $1,200,000. At 3x on the lender's SDE, the supportable price is $642,000 — a $558,000 difference derived entirely from methodology, not from any factual dispute about the business.
The buyer signed an LOI at $930,000. The lender's underwriter calculated SDE at $214,000. The deal required restructuring at the worst possible moment — after exclusivity, after engagement letter fees, after 60 days of due diligence.
That outcome is not the result of a bad business or a bad broker. It is the result of a methodology gap that was discoverable before the LOI and wasn't discovered until after.
What Acquidex Actually Does Differently
An honest list — including what Acquidex does not do.
What it does:
- Enforces SBA SOP 50 10 8 add-back methodology. Not buyer judgment — the same standard the lender's underwriter will apply. Add-backs that don't survive that test are flagged before the LOI, not after.
- Includes personal debt in the DSCR calculation by default. The lender's global cash flow calculation is the starting model, not an afterthought.
- Produces output formatted for lender review from day one. The analysis can be shared with the lender, attorney, or seller without translation or apology.
- Versions deal analyses automatically. When you're running multiple deals simultaneously, there is no ambiguity about which analysis applies to which deal at which stage.
- Runs in two minutes from CIM inputs. For volume-based screening, the normalization overhead doesn't scale linearly with deal count.
What it does not do:
- It is not a CRM. It does not track deal pipeline, contact records, or broker relationships.
- It does not source deals. There is no marketplace, no broker integration, no listing aggregation.
- It does not replace a CPA for final diligence. The pre-LOI Prescore is designed to surface what a lender will find before the offer is signed — not to function as a Quality of Earnings engagement. Post-LOI, a QoE from a qualified provider is the appropriate next step.
- It does not produce legal opinions. Any structural analysis about deal terms, representations, or warranties requires attorney review.
Who Should Use What
| Buyer Type | Right Tool | Why |
|---|---|---|
| First acquisition, SBA-financed | Acquidex | Methodology guard rails matter most when lender alignment is the constraint and there's no CPA model to backstop the buyer's assumptions |
| Experienced operator, CPA on retainer | Spreadsheet + CPA review | Methodology lives in the CPA relationship; the spreadsheet is a capable execution surface |
| Self-funded searcher, 20+ deals screened | Acquidex for screening, CPA for final | Volume makes manual normalization impractical; Acquidex provides lender-standard output at screening speed |
| Traditional search fund | Both — Acquidex pre-LOI, CPA model for LP reporting | Acquidex surfaces the lender gap early; the CPA model provides the documentation depth that LP reporting requires |
The decision is not about preference or sophistication. It's about whether the analytical gap between your model and the lender's model is visible before the LOI or after it.
For operators with CPA support who have internalized lender methodology, a spreadsheet is a legitimate tool. For everyone else — particularly first-time buyers running SBA-financed deals without a CPA actively reviewing each model — the methodology enforcement that a purpose-built tool provides is not a convenience feature. It is the difference between a number that survives underwriting and one that doesn't.
FAQ
Is a spreadsheet good enough for SMB acquisition analysis?
For initial screening and deal flow management, yes. For offer pricing on an SBA-financed deal, the honest answer is: only if the methodology baked into that spreadsheet matches what the lender will apply. Most buyer spreadsheets don't follow SBA SOP 50 10 8 add-back standards, don't include personal debt in the DSCR calculation, and don't carry version control that survives due diligence. The risk isn't that spreadsheets are wrong — it's that the buyer's model and the lender's model produce different numbers, and that discrepancy surfaces at the worst possible moment: after LOI, during underwriting.
What does Acquidex do that Excel can't?
Excel can do the arithmetic. What it can't do is enforce the methodology. Acquidex applies SBA SOP 50 10 8 add-back standards by default, includes the buyer's personal debt obligations in the DSCR calculation, and produces output structured for lender review from day one. It also versions deal analyses automatically, so there's no ambiguity about which model was sent to which party at which stage. What Acquidex doesn't do: it's not a CRM, doesn't source deals, and doesn't replace your CPA for final diligence.
How do I know if my SDE model matches what the lender will calculate?
The practical test is to run your model against the lender's inputs — three years of filed tax returns — not the broker's recast. Apply only the add-backs that SBA SOP 50 10 8 accepts: depreciation, amortization, documented above-market owner compensation with a market replacement rate deducted, and interest on debt being retired. Then include your personal monthly debt obligations in the DSCR denominator. If your SDE figure survives that process and your DSCR clears 1.25x, your model is close to what the lender will produce. If you haven't done that reconciliation, the gap is structural — and it will be discovered at underwriting regardless.
Disclaimer
This article is for informational purposes only and does not constitute financial, legal, or investment advice. Always consult with a qualified professional before making any acquisition decisions.
Avery Hastings, CPA
Founder, Acquidex • CPA • Tokyo, Japan
Avery Hastings is a CPA based in Tokyo, Japan and the founder of Acquidex. She focuses on helping buyers evaluate small-business deals with clear cash-flow logic, realistic downside analysis, and practical diligence frameworks.
Keep up with Avery →