Lesson Objective:Â To standardize financial statements as a percentage of revenue (vertical) and to analyze growth trends over time (horizontal) to identify structural shifts in a company’s cost base, capital intensity, and operational efficiency.
In-Depth Notes:
1. Vertical Analysis (Common-Sizing the P&L):
Vertical analysis expresses every line item on the income statement as a percentage of Net Revenue. This normalizes the company’s financials, allowing for comparison across different-sized companies and against industry averages.
-
Gross Margin = Gross Profit / Net Revenue:Â This is the most critical metric. A declining gross margin indicates rising input costs, pricing pressure from competitors, or a shift in product mix toward lower-margin offerings. In Europe, where energy and raw material costs are highly volatile, gross margin analysis is performed on a quarterly sequential basis to detect early warning signs.
-
Operating Margin = EBIT / Net Revenue:Â Measures the efficiency of core business operations before financing costs. A stable or expanding operating margin suggests effective cost control.
-
EBITDA Margin = EBITDA / Net Revenue:Â Used extensively in credit analysis (especially in Europe under Basel III) to assess a company’s ability to service debt, as it approximates operating cash generation before discretionary spending.
-
Net Income Margin = Net Income / Net Revenue:Â While important, this is often distorted by one-off tax benefits or financing costs, making it less reliable than EBITDA margin for operational analysis.
2. Vertical Analysis (Common-Sizing the Balance Sheet):
Each balance sheet line item is expressed as a percentage of Total Assets. This reveals the company’s capital structure and asset intensity.
-
Working Capital Composition:Â If Accounts Receivable as a percentage of Total Assets is increasing, it suggests the company is relaxing credit terms to boost sales, which may lead to future bad debts.
-
Capital Intensity:Â PP&E as a percentage of Total Assets indicates whether the company is asset-heavy (manufacturing, utilities) or asset-light (software, services). Under IFRS, if a company leases assets, the Right-of-Use asset increases total assets, making the company appear more capital-intensive than it actually is; a footnote adjustment must be made for a true “look-through” analysis.
-
Leverage Structure:Â Total Debt as a percentage of Total Assets (Total Debt Ratio) and Equity as a percentage of Total Assets (Equity Ratio) show how the company is financed. European companies often have higher debt-to-total-asset ratios due to bank-centric financing models compared to US companies, which rely more on equity markets.
3. Horizontal Analysis (Trend Analysis):
Horizontal analysis calculates the year-over-year (YoY) or quarter-over-quarter (QoQ) growth rate for every line item on the income statement and balance sheet. This is typically presented as an “Annual Growth Rate” row directly beneath the historical data.
-
Revenue Growth vs. Cost Growth:Â If revenue is growing at 5% but COGS is growing at 8%, gross margin is under pressure, indicating that the company cannot pass rising costs to customers.
-
Working Capital Velocity:Â If Inventory is growing at 15% while Revenue is growing at 5%, inventory is piling up. This is a major red flag under the European inventory impairment standards (IAS 2), requiring the modeler to test for lower-of-cost-or-net-realizable-value (LCNRV) adjustments.
-
CAPEX vs. Depreciation:Â If a company’s CAPEX consistently exceeds depreciation over a 3-year horizontal trend, it is investing in growth. If CAPEX is consistently below depreciation, it is under-investing in its asset base, which will eventually lead to a loss of competitive advantage and a “stale” asset base.