EBITDA margin: formula and Excel example

The formulas

• EBITDA (top-down) = EBIT + depreciation + amortization
• EBITDA (bottom-up) = net income + interest + income tax + depreciation + amortization
• EBITDA margin = EBITDA ÷ revenue
• EBIT margin (operating margin) = EBIT ÷ revenue

Both routes must give the same number, and checking that they do is a quick test that nothing was double-counted. The top-down route is safer when the income statement shows operating profit clearly. The bottom-up route is handy when you start from net income, for example in a cash flow statement. Note that if the company has other non-operating items, such as investment gains, the bottom-up route also needs to remove them, otherwise the two will differ.

Depreciation and amortization (D&A) are not always shown as separate lines. Many companies include them inside cost of sales or administrative expenses and disclose the amounts only in the notes or the cash flow statement. Take D&A from there, otherwise EBITDA comes out too low.

Step by step in Excel

1. Enter revenue, cost of goods sold, operating expenses without D&A, depreciation and amortization in rows 2–6, one column per year.
2. EBIT in row 7: =B2-B3-B4-B5-B6
3. Net income in row 10: =B7-B8-B9, after interest and tax
4. EBITDA in row 11: =B7+B5+B6, and the cross-check in row 12: =B10+B8+B9+B5+B6
5. EBITDA margin in row 13: =B11/B2, formatted as a percentage
6. Fill everything right to the other years and add =IF(ROUND(D11-D12,2)=0,"OK","Check") as a guard.

ROUND inside the check avoids a false alarm from tiny floating-point differences. Put the margin rows directly under the amounts, so the trend is visible in one row.

Worked example: EBITDA margin over three years

A fictional company's income statement for three years (yellow). EBITDA is calculated top-down from operating profit and bottom-up from net income as a cross-check, then expressed as margins on revenue.

Worked example: EBITDA margin over three years

	A	B	C	D
1	Income statement line	FY2024	FY2025	FY2026
2	Revenue	4,000,000	4,600,000	5,200,000
3	Cost of goods sold	2,400,000	2,714,000	3,016,000
4	Operating expenses (without D&A)	920,000	1,058,000	1,196,000
5	Depreciation	180,000	210,000	290,000
6	Amortization	40,000	40,000	60,000
7	EBIT (operating profit)	460,000	578,000	638,000
8	Interest expense	60,000	70,000	110,000
9	Income tax	80,000	101,600	105,600
10	Net income	320,000	406,400	422,400
11	EBITDA, top-down (EBIT + D&A)	680,000	828,000	988,000
12	EBITDA, bottom-up (net income + interest + tax + D&A)	680,000	828,000	988,000
13	EBITDA margin	17.0%	18.0%	19.0%
14	Gross margin	40.0%	41.0%	42.0%
15	EBIT margin	11.5%	12.6%	12.3%
16	Net profit margin	8.0%	8.8%	8.1%
17	D&A as % of revenue	5.5%	5.4%	6.7%
18
19	Checks			Value
20	Top-down and bottom-up EBITDA agree (FY2026)			OK
21	EBITDA margin change FY2024 to FY2026 (percentage points)			2.0
22	EBIT margin change FY2024 to FY2026 (percentage points)			0.8
23	EBITDA growth per year (CAGR, two years)			20.5%

Fictional figures for illustration only. EBITDA is not defined by IFRS or US GAAP. This is a calculation guide, not accounting, tax or investment advice.

Reading the example

The EBITDA margin improves every year: 17.0%, 18.0%, 19.0%. Gross margin rose from 40% to 42% and operating expenses grew more slowly than revenue. On EBITDA alone it looks like a steady improvement.

The EBIT margin tells a different story. It rose from 11.5% to 12.6% in FY2025 but fell back to 12.3% in FY2026, because depreciation and amortization jumped from $250,000 to $350,000, from 5.4% to 6.7% of revenue. The company invested heavily in equipment. Whether that investment pays off is exactly what EBITDA hides: the machines have to be paid for, and eventually replaced. Read EBITDA margin together with EBIT margin and capital expenditure, not instead of them.

Why EBITDA is used, and what it leaves out

EBITDA is popular for comparing companies with different financing, tax positions and asset ages. Two firms with the same operations but different debt have different net income and the same EBITDA. It is also the basis of common ratios such as net debt ÷ EBITDA and enterprise value ÷ EBITDA (see the EV to equity value bridge).

EBITDA is not cash flow. It ignores capital expenditure, changes in working capital, interest and tax payments, all of which use real cash. The cash flow statement shows how far apart the two can be. It is also not defined by accounting standards, so companies calculate it in different ways. Lease accounting is a well-known example: under IFRS 16 most lease costs move out of operating expenses into depreciation and interest, which raises EBITDA without any change in the business.

Adjusted EBITDA and comparing margins

Many reports show an adjusted EBITDA that adds back items described as one-off, such as restructuring costs, share-based compensation or legal settlements. Check each adjustment: costs that come back every year are not one-off. When comparing companies, use the same definition for all of them, ideally rebuilt from the reported figures as in the example.

A good EBITDA margin depends on the industry. Asset-heavy businesses such as telecoms or utilities often report high EBITDA margins because a large part of their costs is depreciation, while retailers and distributors report low ones. Compare with the company's own history and with direct peers. To break profitability down further, combine margins with asset turnover in a DuPont analysis.

Common mistakes

• Missing hidden D&A. When depreciation sits inside cost of sales or admin expenses, take it from the notes or the cash flow statement and add it back.
• Treating EBITDA as cash flow. It ignores capital expenditure, working capital, interest and tax payments.
• Accepting every adjustment. Recurring costs labelled as one-off inflate adjusted EBITDA. Compare reported and adjusted figures.
• Comparing different definitions. Leases, capitalised development costs and other income are handled differently across companies and standards.
• Double-counting in the bottom-up route. Adding back interest income or non-operating gains the wrong way makes the two EBITDA figures disagree. Use the cross-check.