Margin Analysis in Due Diligence: Decomposing Profitability to Identify Real Trends

Margin analysis is at the heart of Quality of Earnings work. The buyer needs to understand not just what the target's margins are but why they are at that level and whether they are sustainable. A reported EBITDA margin of 18 percent is a data point. Understanding whether that margin is expanding due to genuine operational improvement, contracting due to input cost pressures, or inflated by one-time items is the analytical work that drives deal decisions.

For Transaction Services teams, margin analysis requires decomposing profitability at multiple levels and across multiple dimensions. The depth of analysis depends on the quality and granularity of the underlying data.

Levels of Margin Analysis

Gross Margin

Gross margin (revenue minus cost of goods sold, divided by revenue) measures the target's pricing power and production efficiency. Key questions include:

Is gross margin stable, improving, or deteriorating?
What is the mix effect? Are higher-margin products or customers growing relative to lower-margin ones?
Have input costs changed, and has the target passed those changes through to customers?
Are there intercompany purchases that distort the cost structure?

Gross margin analysis requires revenue data disaggregated by product, customer, or segment, and cost of sales data with similar disaggregation. This often means working with sub-ledger data from the target's ERP system rather than just GL totals.

EBITDA Margin

EBITDA margin adds the operating cost structure to the analysis. The decomposition examines:

Personnel costs: Headcount trends, average compensation, temporary versus permanent staff mix
Occupancy costs: Rent, utilities, maintenance (noting the impact of IFRS 16 lease treatment)
Professional fees: Legal, audit, consulting, and advisory costs
Other operating expenses: Marketing, travel, insurance, IT costs

Each category should be analyzed as a percentage of revenue and in absolute terms. A cost line that is flat in absolute terms but declining as a percentage of revenue reflects operating leverage. A cost line growing faster than revenue signals a structural issue.

Net Margin

For some engagements, particularly those involving leveraged buyouts, the analysis extends to net margin to assess the impact of financing costs, tax structure, and depreciation and amortization.

Decomposing Margin Trends

A margin trend over three to five years tells a story. The analytical work is understanding what that story is.

Volume vs. Price vs. Mix

Revenue margin changes can be decomposed into three drivers:

Volume effect: Higher volumes spread fixed costs across more units, improving margins
Price effect: Price increases (or decreases) directly impact revenue per unit without changing cost per unit
Mix effect: Shifts in the proportion of high-margin versus low-margin products or customers change the blended margin even if individual product margins are stable

This decomposition requires product-level or customer-level revenue data and corresponding cost data. Without this granularity, the analysis can identify that margins changed but cannot explain why.

Fixed vs. Variable Cost Behavior

Understanding which costs are fixed, variable, and semi-variable is essential for assessing margin sustainability under different revenue scenarios:

Variable costs (raw materials, direct labor, sales commissions) scale with revenue. Changes in these costs relative to revenue signal pricing or efficiency changes.
Fixed costs (rent, management salaries, depreciation) remain constant within a range. Operating leverage means margins improve as revenue grows but deteriorate sharply if revenue declines.
Semi-variable costs (utilities, maintenance, temporary staff) have both fixed and variable components.

One-Time Items and Normalizations

Reported margins may be distorted by items that do not represent ongoing profitability. The EBITDA adjustments process identifies these items, but the margin analysis must integrate those adjustments into the trend:

Non-recurring costs: Restructuring charges, litigation expenses, one-time consulting projects
Non-recurring income: Insurance recoveries, asset sale gains, government grants
Owner-related items: Above-market management compensation, personal expenses, related party transactions at non-market rates

Sector-Specific Considerations

Margin analysis is inherently sector-specific. The relevant metrics and drivers vary significantly:

Manufacturing: Gross margin focus, raw material cost exposure, labor productivity, capacity utilization
Professional services: Utilization rate, revenue per consultant, blended billing rate versus cost
Software: Gross margin by revenue type (license versus SaaS versus services), customer acquisition cost recovery
Distribution: Gross margin by product category, warehousing and logistics costs as a percentage of revenue
Retail: Same-store margin trends, e-commerce versus physical store margins, markdown patterns

Data Requirements

Comprehensive margin analysis requires:

Monthly income statement data at the GL account level for 36+ months
Revenue disaggregation by product, customer, or segment (from sub-ledger or management reporting data)
Cost of sales detail sufficient to separate material costs, labor, and overhead
Headcount data to normalize personnel costs
Understanding of the target's cost allocation methodology for multi-segment or multi-entity businesses

The quality of the margin analysis is directly proportional to the granularity of the data. Teams that invest in thorough data extraction and normalization early in the engagement produce deeper margin insights within the same timeline.

Margin Analysis as a Deal Driver

Margin trends are often the most important single finding in a due diligence report. A target with expanding margins supports a higher multiple. A target with declining margins raises questions about pricing power, competitive position, and management effectiveness.

The advisory team's ability to decompose margins into their component drivers, supported by granular data analysis, is what transforms a observation into an insight that informs the deal decision.