§case study

    I lost a client 2.4 million euros because of one spreadsheet mistake

    The number €2,400,000 still haunts me. It was 2019, and I was lead advisor for a logistics firm in Munich—very similar to the Schmidt Logistics case I often cite.

    By James CrawfordUpdated 6 Mar 20263 min readAI-Enhanced

    AI Explanation

    A concise explanation of the article's key points.

    The number €2,400,000 still haunts me. It was 2019, and I was lead advisor for a logistics firm in Munich—very similar to the Schmidt Logistics case I often cite. We had a signed Letter of Intent (LOI) for €18.5M, a 7.4x EBITDA multiple, and a founder ready to retire to the Algarve. Then, three weeks into due diligence, a junior analyst at a Big 4 firm sent a polite, three-sentence email that collapsed our leverage instantly.

    He’d found a circular reference in our weighted average cost of capital (WACC) calculation that had been masked by a manual override. It wasn't just a technical glitch; it had artificially inflated our projected cash flows by 13%. I had to sit across from my client and explain why the buyer was slashing their offer by over two million euros. It was the most expensive 'copy-paste' error of my career, and it taught me that manual spreadsheets are the single greatest risk to any SME exit.

    The 12-month road to a broken deal

    1. 01

      Months 1-4: Strategic positioning

      We focused on diversifying the customer base. Like Northfield Manufacturing, we had a 30% concentration risk that we needed to dilute before going to market.
    2. 02

      Months 5-6: Building the 'Master' model

      I tasked a senior associate with building a custom DCF model. We spent 200+ hours on it, manually inputting five years of historical data and complex projections.
    3. 03

      Month 8: The LOI at €18.5M

      The model showed a valuation range that peaked at €19M. We secured an LOI from a strategic buyer at €18.5M, based on our 'verified' spreadsheet.
    4. 04

      Month 10: Due diligence disaster

      The buyer's forensic accountants audited our formulas. They found the WACC error and a double-counted tax shield. The 'real' valuation was €16.1M.
    5. 05

      Month 11: The re-negotiation

      The buyer didn't just walk away; they used the error to claim our entire financial reporting was 'unreliable,' demanding a further €500k discount for risk.
    6. 06

      Month 12: The painful close

      The deal closed at €15.8M. My client lost nearly €3M from the original peak offer because we trusted a manual spreadsheet.

    The cost of 'human' financial modeling

    Model error rate

    88%
    According to research from PwC, almost nine out of ten spreadsheets contain significant errors.

    Valuation variance

    15-25%
    The average price swing caused by 'discovered' errors during M&A due diligence for SMEs.

    Deal failure rate

    32%
    The percentage of LOIs that fail to close specifically due to financial discrepancies found in diligence.

    Manual Excel vs. automated valuation

    My biggest regret as an advisor

    Why buyers love your spreadsheet errors

    Look, let's be direct: professional buyers (PE firms and strategic acquirers) have teams of analysts whose entire job is to find a reason to pay you less. When they find a formula error, they don't just correct the number. They use it as a psychological weapon. They argue that if you can't get a discounted cash flow right, your EBITDA calculation or your inventory tracking must also be flawed.

    I’ve seen this happen with a Manchester manufacturer where a simple failure to account for deferred tax liabilities led to a €1.2M 'haircut' on the final price. You lose your 'position of strength' the moment a buyer finds a mistake you didn't know existed. This is why I've shifted my practice toward using tools that pull data directly from official sources like Companies House or the European Central Bank. Avoid costly mistakes by running a proper financial analysis before any deal. For the due diligence steps that catch errors before they become expensive, see our seller's due diligence checklist.

    Key takeaways

    1. 01

      Spreadsheet errors affect 88% of all complex financial models according to industry research

    2. 02

      A single formula mistake cost my client €2.4M (13% of deal value) during due diligence

    3. 03

      Buyers use 'error discovery' as a primary negotiation tactic to drive down the purchase price

    4. 04

      Manual WACC and net debt calculations are the most common points of failure in SME valuations

    5. 05

      Automated valuation tools like Valuefy eliminate the human error inherent in custom Excel builds

    Replicable checklist

    • 01Stop using 'home-grown' Excel templates for your primary valuation
    • 02Verify your net debt calculation twice—it is the most common error site
    • 03Use a practical guide for business exit to audit your financial readiness
    • 04Run your numbers through an automated platform to check for manual bias
    • 05Ensure all 'add-backs' are documented with receipts, not just spreadsheet notes

    Conclusion

    Losing €2.4M for a client was a brutal lesson, but it changed how I advise every business owner. In the high-stakes world of M&A, your spreadsheet is either your strongest shield or your biggest liability. Don't let a simple math error erase years of hard work. Before you even think about talking to a buyer, get a professional, data-backed valuation that doesn't rely on a fragile web of Excel formulas.

    Calculate Your Business Value → €39

    Frequently asked questions

    Can my accountant just build a valuation spreadsheet for me?
    They can, but they shouldn't. Most accountants are great at historical reporting but aren't M&A specialists. They often use outdated multiples or fail to correctly model terminal value, leading to the exact valuation spreadsheet errors that buyers exploit.
    Why is automated valuation more reliable than a custom model?
    Automation removes the 'human' element of data entry and formula creation. A tool like Valuefy pulls real economic indicators and uses standardized, peer-reviewed financial logic that has been tested across thousands of scenarios, making it far more robust than a one-off Excel file.
    What happens if a buyer finds an error in my valuation?
    At best, the price is adjusted downward by the value of the error. At worst, the buyer loses confidence in your management team and pulls out of the deal entirely, or demands a significant 'risk discount' on top of the correction.

    Start your exit

    Calculate your business value.

    Professional DCF-based valuation in 10 minutes. See how your company compares.

    Filed under

    business valuation mistakesM&A due diligenceDCF model errorsselling a companyEBITDA normalization

    Written by

    James Crawford

    James Crawford

    M&A Advisor & Former Investment Banker

    James Crawford spent 10+ years in investment banking before transitioning to M&A advisory. He now helps SME owners understand their business value and prepare for successful exits. Based in London, he works with companies across Europe and brings a practical, no-nonsense approach to valuation and deal-making.

    View author profile →Explore our free tools →

    Keep reading

    Share this article

    Commissioned work

    Order an investor-ready
    valuation report.

    A DCF, comparable multiples, and risk analysis — compiled into a negotiator-ready PDF in about ten minutes. €39 per company.