Skip to content

modeling · 9 min read

How investors stress-test your financial model in due diligence

Sergei MochtchenkovSergei Mochtchenkov, CFA

Published · Updated

A navy spreadsheet grid sheared out of alignment along a single gold stress line

In brief

The eight things a diligence team does to your model in the first hour, and how to make sure none of them produce a surprise. Start with reconciled records and transparent assumptions, then test the drivers that change cash needs or valuation. Separate formula checks from evidence supporting the forecast. The approach below helps organize review questions and identify limitations; it is educational guidance, not an assurance conclusion or an investment recommendation.

Key takeaways

  • Reconcile source records before relying on model outputs.
  • Document assumptions and test the downside.
  • Match the method to the decision and disclose its limits.

What happens in the first hour

An analyst opening your model for the first time is not reading your forecast. They are testing whether the file can be trusted at all, and they have a routine for it that takes under an hour. Everything that follows in diligence depends on how that hour goes.

The routine is remarkably consistent across funds, because analysts learn it from each other. Knowing it is not gaming the process — it is the difference between a model that answers questions and one that generates them.

  1. Press F5 or open the name manager to find errors, external links and broken references.
  2. Trace precedents on three or four headline cells to see whether outputs derive from inputs.
  3. Check whether the balance sheet ties to zero, and whether a plug is doing the work.
  4. Recompute one or two metrics independently — usually net revenue retention and gross margin.
  5. Change a single driver and watch what moves, and more importantly what does not.
  6. Look for hardcoded constants inside formula cells.
  7. Compare the model's historical period against the accounts they already have.
  8. Push a driver to a plausible extreme and see whether the model still behaves.

Test one: does the output derive from the input?

The single fastest way to assess a model is to select the year-five revenue cell and trace precedents. If the chain leads back through a volume build, a price assumption and a retention curve, the model is doing work. If it leads to last year's revenue multiplied by a growth rate typed into a cell, the forecast is an assertion with a spreadsheet wrapped around it.

This is why driver-based builds matter beyond neatness. A driver-based model can be interrogated. When an investor disputes your growth rate, you can show them the three assumptions underneath it and argue about those instead — which is a much better conversation than defending a single number you chose.

Test two: the plug

A balance sheet that ties only because a line called 'other assets' or 'balancing figure' absorbs the difference is the most damaging finding in diligence, and it is common. It means something in the model does not reconcile and the author either did not know or chose not to resolve it.

The problem is not the plug itself; it is what it implies about everything downstream. If cash is derived from a balance sheet held together by a plug, the cash-out date — the number the entire investment decision rests on — is unreliable. Once an analyst finds a plug, they stop reading the model and start auditing it, and the timetable slips.

Test three: independent recomputation

Analysts recompute two or three metrics from the raw data rather than accepting the model's own calculation. Net revenue retention is nearly always one of them, because it is both heavily cited and easy to compute incorrectly.

The most frequent error: applying expansion and churn to total current revenue rather than to the prior-period cohort base. That overstates retention, and because retention compounds, the effect on year-five revenue is large — commonly 15% to 25%. When an analyst's recomputation comes out ten points below yours, every other metric in the file becomes suspect.

  • Net revenue retention, computed on the prior-year cohort base only
  • Gross margin, including the costs founders often exclude — support, hosting, inference, payment fees
  • CAC payback, on fully loaded acquisition cost rather than paid media alone
  • Burn multiple: net burn divided by net new ARR, which cannot be flattered by presentation

Test four: does it survive being pushed?

The last test is to break it. An analyst sets growth to zero, doubles churn, delays the raise by six months, or pushes a cost line to a plausible worst case, and watches what happens. Two failures are common. Either the model produces an absurd result — negative headcount, revenue from customers who have all churned — or nothing moves at all, revealing that the driver was never actually connected.

A downside case that still shows healthy profitability is treated as evidence of unseriousness rather than of resilience. Investors have seen hundreds of them. A downside case that shows the company surviving on specific, named actions — a hiring freeze at a stated month, a pricing change, a facility drawn — is the version that builds confidence.

What to do before the data room opens

Run the same routine on yourself. Trace precedents on your headline outputs. Confirm the balance sheet ties without a plug. Recompute retention on a clean cohort base. Remove every hardcoded constant from a formula cell. Push each major driver to an extreme and watch for nonsense.

Then have someone who did not build the model do it again, because the author is structurally the worst person to find their own errors. Two days of independent review before the data room opens is materially cheaper than two weeks of re-opened diligence after an analyst finds something — and a correction you disclose yourself is a housekeeping item rather than a credibility problem.

Frequently asked questions

No. This educational guide explains a method. The appropriate analysis depends on the actual records, agreement and intended use.

Treat examples as hypothetical illustrations, reconcile your own inputs and document differences before making a decision.

Educational content — not an audit, assurance opinion, or investment or legal advice.

Related guides

Abstract navy and gold composition illustrating how to build an integrated three-statement financial model

How to build an integrated three-statement financial model

An integrated model connects operating assumptions to the income statement, balance sheet and cash flow statement.

6 min read · Updated 2026-10-18

Abstract navy and gold composition illustrating scenario vs. sensitivity analysis: building a usable downside case

Scenario vs. sensitivity analysis: building a usable downside case

Sensitivity analysis changes one assumption while a scenario changes a coherent group of assumptions.

6 min read · Updated 2026-10-18

A gold curve decaying toward the right beside a row of ivory comparable bars, one highlighted in gold

DCF vs. comparables: which valuation method fits your stage

Why a DCF on a pre-revenue company is theatre, why comparables break at the top of a cycle, and how to weight both honestly.

10 min read · Updated 2026-10-18

Investor-Ready Model Checklist

  • ✓ Reconcile opening balances to the accounts.
  • ✓ Separate inputs, calculations and outputs.
  • ✓ Link the income statement, balance sheet and cash flow.
  • ✓ Document revenue, cost and working-capital drivers.
  • ✓ Include downside and funding scenarios.
  • ✓ Test balance checks and cash roll-forwards.
  • ✓ Reconcile enterprise value to equity value.
  • ✓ Track actuals against plan and document changes.
Download checklist →
Get a quoteFree health check