The Spreadsheet Problem
You've spent weeks building a valuation model. You've color-coded it, added formulas, maybe even printed it on nice paper. Then you send it to a serious buyer, and the conversation stalls.
This happens more often than you'd think, and it's rarely about the numbers themselves.
The real issue: a spreadsheet—no matter how accurate—doesn't tell a buyer a story. It doesn't prove anything. It just sits there, asking them to trust you on faith.
Buyers don't work on faith. They work on evidence.
What Buyers Actually See When They Look at Your Numbers
When a potential buyer opens your valuation spreadsheet, they're not just checking your math. They're asking themselves three questions:
- Is this real? Can I verify these numbers independently?
- Are you hiding something? Why are some line items vague or rounded?
- Will I get what I'm paying for? Do these numbers match what I'll actually inherit?
A spreadsheet answers none of these well. It's one-sided. It lacks context. And it invites skepticism instead of confidence.
Worse, a buyer who doubts your numbers will either lowball you or walk away entirely.
The Documentation Gap Between DIY and Professional Valuations
When a business broker or valuation firm presents numbers, they package them inside a formal document: a confidential information memorandum (CIM). That document isn't just prettier—it's structured to build trust through transparency.
A CIM includes:
- Audited or reviewed financial statements (or at minimum, a clear explanation of why they're unaudited)
- Detailed add-back justifications—every owner expense is explained and sourced
- Historical context—3–5 years of P&Ls showing trends, not just last year's snapshot
- Market comparables—what similar businesses sold for, and why yours fits that range
- Risk disclosures—what could go wrong, and how you're accounting for it
- Professional language and formatting—it signals that someone serious prepared this
A spreadsheet has none of this scaffolding. It's naked numbers with no frame.
Why Buyers Distrust Uncontextualized Valuations
Here's a specific example: You claim your business generated $150,000 in SDE last year. A buyer sees that number in your spreadsheet. But they don't know:
- Whether that $150,000 is consistent year-over-year, or a one-year spike
- Which expenses you've added back and why—are they truly non-recurring, or are you inflating your earnings?
- How much of that SDE is dependent on you personally (your relationships, your time, your expertise)
- Whether the business has grown, shrunk, or plateaued over the past three years
- What the actual cash flow looks like—SDE is a paper calculation, not cash in the bank
Without that context, a buyer's default assumption is: This number is optimistic. They'll mentally discount it by 20–40% just to be safe. That directly reduces their offer.
The Add-Back Credibility Problem
Add-backs are where most DIY valuations lose credibility fastest.
You might legitimately have $20,000 in owner health insurance or $15,000 in a family member's salary that a new owner won't need to pay. Those are real adjustments. But when a buyer sees a list of add-backs in a spreadsheet with minimal explanation, they wonder: Are these real, or is the seller just inflating the numbers?
A formal memorandum addresses this by explaining each add-back in narrative form:
Owner health insurance ($18,500): Current owner carries family coverage under the business plan. A new owner would likely obtain coverage independently or through a spouse's employer. This expense is non-recurring and has been added back to SDE.
That single paragraph does what a spreadsheet cell never can—it builds credibility by showing your thinking, not just your claim.
What Professional Buyers Expect to See
If you're selling to a sophisticated buyer—a competitor, a private equity firm, or someone with M&A experience—they'll expect documentation that matches what they're used to seeing. A spreadsheet signals that you're either inexperienced or trying to hide something. Neither helps your deal.
Professional buyers want:
- Tax returns (at least 2–3 years) showing reported income
- Accountant-prepared financial statements or a clear explanation of why the business uses cash-basis accounting
- A narrative summary explaining the business, its market position, and its growth trajectory
- Organized add-back schedules with source documents (invoices, receipts, payroll records) available for verification
- A valuation memo that shows your methodology and reasoning, not just a final number
A spreadsheet alone doesn't satisfy any of these expectations.
How to Move Beyond the Spreadsheet
You don't need to hire a broker or a valuation firm to create professional-grade documentation. Here's what you can do yourself:
1. Start with Your Financials
Pull together 3 years of tax returns and P&Ls. If your business uses a bookkeeper or accountant, ask them to prepare a simple financial summary. If you do your own books, export your P&L directly from your accounting software (QuickBooks, Xero, Wave, etc.). The key: use actual data, not memory.
2. Create a Detailed Add-Back Schedule
List every add-back. For each one, write a one-sentence explanation of why it won't recur for a new owner. Attach source documents (invoices, receipts, payroll records) so a buyer can verify.
3. Write a Business Summary
Spend 30 minutes writing 2–3 paragraphs about your business: what you do, who your customers are, how long you've been in business, and what makes you different. This narrative context is invisible in a spreadsheet but essential for buyer confidence.
4. Show Historical Trends
Don't just present last year's numbers. Create a simple table showing revenue, expenses, and SDE for the past 3 years. This shows whether the business is growing, stable, or declining—critical context for valuation.
5. Package It Professionally
Put all of this into a formatted document—a PDF or Word file with a title page, table of contents, and clean layout. This doesn't require design skills; it just requires treating your valuation like a professional deliverable, not an afterthought.
If you're selling without a broker, tools like ExitKit can help you generate these documents automatically—taking your numbers and creating a formal confidential information memorandum, teaser, and listing copy all at once. The point isn't the tool; it's that your documentation needs to match what buyers expect to see.
The Real Cost of a Weak Valuation Package
Let's say your business is worth $500,000 based on a reasonable 3.5x SDE multiple. A buyer who distrusts your spreadsheet might mentally discount that valuation by 15–25%, bringing their offer down to $425,000–$425,000. That's a $75,000–$125,000 loss on a single deal, caused entirely by presentation and credibility, not by the actual strength of your business.
Professional documentation doesn't change your business's fundamentals. But it removes friction from the buyer's decision-making process. It answers their skepticism before they even ask the question. And it typically results in faster, higher offers.
The Bottom Line
Your spreadsheet is accurate. Your numbers are real. But buyers don't buy spreadsheets—they buy confidence. They buy the story that your numbers tell when they're properly contextualized, verified, and presented as a coherent package.
If you're selling your business, invest the time to move beyond the spreadsheet. Gather your documentation, write your narrative, and package it professionally. The difference in buyer response—and in your final sale price—will be worth far more than the effort it takes.
