Revenue and costs Updated November 2026

Operating leverage

Operating leverage measures how much operating profit changes when sales change, driven by fixed costs. Degree of operating leverage (DOL) = contribution margin / EBIT, or % change in EBIT / % change in sales. A DOL of 4 means a 10% sales increase raises EBIT by 40%.

Syntax

DOL = (Sales - Variable costs) / EBIT = %change EBIT / %change Sales

Examples

Sales 1,000, variable costs 600, fixed costs 300
CM = 400, EBIT = 100
=400 / 100

Result: DOL = 4.0

Sales rise 10% to 1,100
EBIT = 1100 - 660 - 300

Result: 140, up 40%

Same business, sales fall 10% to 900
EBIT = 900 - 540 - 300

Result: 60, down 40%

Common mistakes

Treating all costs as variable in a forecast, which hides the margin expansion (or collapse) that fixed costs create.
Computing DOL at one sales level and applying it far away: DOL changes as EBIT changes, so recompute near each point.
Confusing operating leverage with financial leverage: the second comes from interest, measured by EBIT / (EBIT - interest).

Practice Operating leverage

These drills check your answer on live data, free, no account needed.

Fixed and variable operating costsOperating expenses have a fixed part that rises with inflation and a variable part tied to revenue. Fill row 9: fixed costs grown by inflation for the number of years in row 7, plus the variable share of revenue.
Break-even by productFor each product line, fill the contribution margin per unit (column E), the break-even units rounded up to a whole unit with ROUNDUP (column F) and the break-even revenue (column G).
Profit grid by price and volumeFill the grid B6:F9 with operating profit for every combination of price (column A) and units (row 5): (price less variable cost) times units, less fixed costs. One formula, filled right and down.

Questions

Is high operating leverage good or bad?

Good when sales grow, because profit grows faster; dangerous in a downturn, because the same fixed costs turn a small sales drop into a large profit drop.

How do I model operating leverage in Excel?

Split costs into variable (percent of revenue or per unit) and fixed (an amount growing with inflation). Margins then expand automatically as revenue grows.

Break-even pointBreak-even units = fixed costs / (price - variable cost per unit); break-even revenue = fixed costs / contribution margin ratio. Examples, margin of safety.
EBITDA marginEBITDA margin = EBITDA / revenue, the share of each sales dollar left as operating profit before D&A. Formula, exact examples, what is a good margin, errors.
COGS as a percent of revenueCOGS % = cost of goods sold / revenue, and forecast COGS = revenue x COGS %. How to compute the historical ratio, project it and link it to gross margin.
Sensitivity tableHow to build a sensitivity table with Data, What-If Analysis, Data Table: layout, row and column input cells, exact NPV examples and fixing wrong results.