Key takeaways
- A financial model buyers can interrogate is more valuable than a polished presentation they cannot.
- Bottom-up revenue and cost assumptions are the difference between a credible model and a spreadsheet.
- Every forward projection should be traceable to a specific operating driver management can defend.
- The model is tested in diligence, so build it as if a skeptical buyer will stress-test every assumption.
- Historical model vs. actual variance reveals the quality of your own forecasting discipline.
36 months
Minimum historical period buyers want to see
3-5 years
Typical forward projection period
6x-8x
EBITDA multiple range where model precision matters most
$600K
Enterprise value impact of a 1x multiple on $100K EBITDA error
A financial model that cannot explain its own assumptions is a liability in an M&A process, not an asset. Buyers will build their own model regardless of what the seller provides, but the quality of the seller's model signals management sophistication, controls the opening anchor on valuation, and determines how much buyer diligence is required to get comfortable with forward projections.
The model build sequence
Financial Model Build Sequence
The model build sequence starts with historical data, not projections. Buyers evaluate the projections in the context of the historical performance. A three-year forward model that is not anchored to a credible, documented historical baseline will not be taken seriously regardless of the quality of the projection assumptions.
What buyers evaluate in the model
In 2024, 64% of lower-middle-market QoE engagements identified at least one material difference between the seller's adjusted EBITDA and the QoE-adjusted EBITDA, with a median difference of $180K.
Sellers whose financial models included documented revenue categorization (recurring vs. transactional) and customer-level revenue detail received LOIs with 15 to 20% less variance in valuation ranges compared to sellers who provided summary P&Ls only.
The most common model deficiency identified by PE diligence teams in 2024 was insufficient documentation of growth assumptions, specifically the absence of bottoms-up revenue build showing how projected revenue growth would be achieved by customer segment, channel, or product category.
Buyers evaluate four things in the financial model: whether the historical EBITDA is properly normalized, whether the revenue categorization is accurate, whether the forward projections are defensible with documented assumptions, and whether the cash flow characteristics support the purchase price at the proposed debt structure.
$180K
Median QoE EBITDA adjustment in LMM transactions 2024
15-20%
LOI valuation range compression for sellers with revenue documentation
64%
QoE engagements finding material EBITDA differences
36 months
Historical period that most credibly supports forward projections
Making projections defensible
The most common model problem in founder-owned businesses is revenue projections that reflect ambition rather than evidence. A buyer will not accept a projection that shows 25% revenue growth in year one when the business has grown at 8% per year for three years, unless the model documents specifically what will change, why it will change, and what evidence supports the assumption.
Defensible projections are built bottoms-up by revenue category, with explicit assumptions about customer additions, retention rates, pricing changes, and product or service expansion. Every material assumption should have a supporting data point or a clearly documented rationale. Projections that cannot be explained in a management presentation will not survive a diligence Q&A.
Frequently asked questions
What time period should my financial model cover?
The standard in lower-middle-market M&A is 36 months of historical data plus a 3 to 5 year forward projection. Buyers typically underwrite based on LTM EBITDA (last twelve months) but evaluate the trend over the full historical period. A business showing consistent growth is valued differently than one showing a recent spike, even at the same LTM EBITDA.
How detailed should the revenue build be?
At minimum, revenue should be categorized by type (recurring, transactional, project) and by major customer or customer segment. Sellers who provide customer-level revenue detail with contract tenure, renewal dates, and historical growth rates receive significantly less pushback on revenue quality during diligence.
What is the most important thing to get right in the model?
The EBITDA bridge. Every buyer will rebuild your EBITDA figure and test every addback. The bridge from GAAP EBITDA to adjusted EBITDA should be explicit, fully documented, and internally consistent with the addback schedule in the CIM. Inconsistencies between the model and the CIM are the most common cause of management credibility concerns in financial diligence.
Work with Glacier Lake Partners
Request a Financial Model Review
Most useful when preparing for a process or completing a management presentation.
Start a Conversation →Explore adjacent topics
