Blog · Finance metrics and formulas · Finance and FP&A teams
The ROCE DuPont formula separates operating return into EBIT margin and capital turnover. Build both components from financial-statement exports, reconcile the identity, and explain a return change without confusing sales growth with capital productivity.
The ROCE DuPont formula is operating margin multiplied by capital turnover: (EBIT / Revenue) × (Revenue / Average capital employed). Revenue cancels, leaving the ordinary ROCE calculation, EBIT divided by average capital employed. The decomposition shows whether a return moved because each sales dollar earned less profit, because each capital dollar supported fewer sales, or because both changed.
ROCE = EBIT margin × Capital turnover.
EBIT margin = EBIT / Revenue.
Capital turnover = Revenue / Average capital employed.
Average capital employed = (Opening capital employed + Closing capital employed) / 2.
This article uses capital employed equal to total assets less current liabilities and EBIT equal to operating profit before interest and tax. Keep those definitions unchanged across the direct ratio and the decomposed version.
ACCA's performance-analysis guidance explains ROCE movements through profit margin and asset turnover. The same cancellation principle appears in OpenStax's operating ROI decomposition: income over sales multiplied by sales over the chosen capital base reproduces income over that capital base. Here the chosen base is average capital employed.
This is a two-part operating identity. The broader financial ratios guide covers other ratios and the ROE DuPont approach; do not add an equity multiplier to this formula and still call the result the same ROCE measure.
Start with a full-year P&L and the opening and closing balance sheets for the same company or business unit. Keep the ledger account mapping with the calculation, especially the treatment of depreciation, corporate allocations and current liabilities.
| Source | Rows needed | Use |
|---|---|---|
| P&L export | Net revenue | Both margin denominator and turnover numerator |
| P&L export | Operating costs, including depreciation | Revenue less these costs gives EBIT |
| Balance-sheet export | Total assets at both dates | Capital-employed calculation |
| Balance-sheet export | Current liabilities at both dates | Deduction from total assets under this definition |
| Mapping schedule | Unit, period, account and adjustment labels | Keeps scope consistent and explains changes |
Do not combine revenue for one unit with a shared capital balance for several units. If finance allocates shared assets or operating costs, show the allocation in both years. A change in allocation policy can move a ratio without changing the underlying business.
For the operating-profit calculation itself, the operating margin guide covers the P&L detail. This decomposition starts once revenue and EBIT have been agreed.
An illustrative US industrial distributor reports the following annual results and balance-sheet totals. Year 2 opening balances equal Year 1 closing balances. All money is USD.
| Statement row (USD) | Year 1 | Year 2 |
|---|---|---|
| Annual revenue | 12,000,000 | 15,000,000 |
| Annual operating costs, including depreciation | 10,800,000 | 13,800,000 |
| EBIT: revenue less operating costs | 1,200,000 | 1,200,000 |
| Opening total assets | 9,000,000 | 11,000,000 |
| Opening current liabilities | 2,000,000 | 2,000,000 |
| Closing total assets | 11,000,000 | 17,000,000 |
| Closing current liabilities | 2,000,000 | 2,000,000 |
Calculate capital employed at each date, average it, then work both factors. These balance-sheet amounts assume no current interest-bearing debt; a real calculation should state how that debt is treated.
| Step | Year 1 calculation | Year 2 calculation |
|---|---|---|
| Opening capital employed (USD) | 9,000,000 - 2,000,000 = 7,000,000 | 11,000,000 - 2,000,000 = 9,000,000 |
| Closing capital employed (USD) | 11,000,000 - 2,000,000 = 9,000,000 | 17,000,000 - 2,000,000 = 15,000,000 |
| Average capital employed (USD) | (7,000,000 + 9,000,000) / 2 = 8,000,000 | (9,000,000 + 15,000,000) / 2 = 12,000,000 |
| EBIT margin | 1,200,000 / 12,000,000 = 10.00% | 1,200,000 / 15,000,000 = 8.00% |
| Capital turnover | 12,000,000 / 8,000,000 = 1.50× | 15,000,000 / 12,000,000 = 1.25× |
| Decomposed ROCE | 10.00% × 1.50 = 15.00% | 8.00% × 1.25 = 10.00% |
| Direct ROCE check | 1,200,000 / 8,000,000 = 15.00% | 1,200,000 / 12,000,000 = 10.00% |
Returns and margins are displayed to two decimal places, and turnover to two decimal places. Retain full precision in the workbook; do not multiply rounded presentation cells when the underlying ratios contain more digits.
Revenue increased by 15,000,000 / 12,000,000 - 1 = 25.00%. Average capital employed increased by 12,000,000 / 8,000,000 - 1 = 50.00%. EBIT did not increase, so the higher sales base and larger capital base both reduced the return components.
The direct and decomposed ROCE values must match. If revenue is B2, EBIT is C2, opening capital employed is D2 and closing capital employed is E2, these workbook formulas should give the same result:
=C2/AVERAGE(D2:E2)
=(C2/B2)*(B2/AVERAGE(D2:E2))
Subtract one result from the other. The difference should be zero, apart from numerical precision. A nonzero difference often means one formula references another unit, period or capital definition.
The algebra check does not prove the input mapping is correct. Reconcile revenue and operating costs to the P&L, and each assets-less-current-liabilities balance to its balance sheet. For example, using gross revenue in both places would still cancel mathematically while misdescribing the margin and turnover components.
The return fell from 15.00% to 10.00%, a decline of 5.00 percentage points. To explain it, change margin first while holding turnover at its Year 1 level, then change turnover at the Year 2 margin.
| Bridge step | Calculation | ROCE | Change from prior step |
|---|---|---|---|
| Year 1 | 10.00% × 1.50 | 15.00% | — |
| Substitute Year 2 margin | 8.00% × 1.50 | 12.00% | -3.00 percentage points |
| Substitute Year 2 turnover | 8.00% × 1.25 | 10.00% | -2.00 percentage points |
The two effects add to the total decline. This is an arithmetic bridge, not proof of independent causes. Reversing the order changes how the interaction is allocated, so use one stated order consistently.
Finance should investigate pricing, cost and mix behind the margin decline, then inspect inventory, receivables and fixed assets behind the turnover decline. A new facility awaiting volume needs a different response from excess stock or slower collections. For a change in after-tax capital return, use ROCE versus ROIC rather than quietly replacing EBIT with NOPAT here.
Bring a sample of your own P&L and capital balances: Covirage maps the columns, and its tools compute and check the figures for the direct return and its components. The external AI model explains the changes with every figure traced to its rows. Create a free Covirage account, then set up your business and bring your file.
See Covirage for finance teams for the supporting context.
No. This ROCE identity uses EBIT and capital employed, so it measures operating return before financing and tax. A ROE decomposition uses net income and equity and may include leverage and tax effects. Keep each numerator matched to its own denominator.
For this ROCE decomposition, it means revenue divided by the same capital-employed balance used in ROCE. Total-asset turnover uses a different denominator. Substituting that measure would produce return on total assets rather than the ROCE identity unless the two bases happen to be equal.
Yes. A lower EBIT margin, capital growing faster than revenue, or both can reduce ROCE. Work margin and capital turnover separately, then multiply them. Revenue growth alone says nothing about how much operating profit remains or how much capital was required to earn it.