Syntha Lab RU

DuPont: return on equity through three levers

Splits return on equity (ROE) into three factors: net profit margin, asset turnover and financial leverage. Compares two periods and shows which lever added or took away points of ROE.

Capital, multi-brand and the planning cycle For whom: Owners, finance directors and investors.

Calculate on your data →

At a glance

What question does it answer?
What changed the return on equity: margin, turnover or leverage.
What data is needed?
Net profit, revenue, average assets and average equity for two periods of the same length.
How to read the result?
ROE rose from 13.3 to 15.0% (+1.67 pp). Margin added 1.37 pp (4.0 → 4.4%), leverage 1.05 pp (2.0 → 2.15), asset turnover took away 0.75 pp (1.67 → 1.58): assets grew faster than revenue. Example on the default values: ROE of the previous period — 13.3%; ROE of the current period — 15%; Change in ROE — 1.7 pp; Contribution of net margin — 1.4 pp

Why and how to reason

ROE (return on equity) looks like one number but consists of three different causes, and DuPont separates them: ROE = net margin × asset turnover × financial leverage. Margin is how much profit per rouble of revenue, turnover how much revenue per rouble of assets, leverage how much assets per rouble of own capital (the more debt, the higher). In the example, previous period: 12 ÷ 300 = 4%, 300 ÷ 180 = 1.67, 180 ÷ 90 = 2, ROE 13.3%. Current: 15 ÷ 340 = 4.41%, 340 ÷ 215 = 1.58, 215 ÷ 100 = 2.15, ROE 15%. The 1.67-point rise is made of: margin +1.37 points, turnover −0.75, leverage +1.05. So ROE grew thanks to margin and debt, while turnover worsened: assets grew faster than revenue.

When to use it

It is useful when analyzing year results to compare two periods and see what changed profitability. Take average assets and equity for the period. It does not fit comparing companies of different sectors (leverage and turnover depend on the model) nor loss-making periods (ROE loses meaning with negative equity). Take data from one accounting method.

How to read the result

Look at the contributions of three levers. Growth from margin is the healthiest: the business earns more per rouble. Growth from turnover is also good: money works faster. Growth from leverage is risky: ROE rises but so does debt and sensitivity to error. In the example leverage gave 1.05 points of 1.67: over half the gain was bought with debt. A fall in turnover (−0.75) says growth in assets (stock, stores) is not matched by revenue: a reason to look at stock and store returns. Write down one action for each lever: what raises margin, what speeds turnover, what debt is acceptable. This turns the decomposition from a report into a plan.

Common mistakes

Typical trap: taking closing rather than average assets and equity; mixing periods of different length (quarter and year); calling ROE good without looking at leverage; comparing with another sector. Contributions are computed in sequence and the order affects the split: look at meaning, not tenths. Do not mix net profit and pre-tax profit across periods.

What data is needed?

  • Net profit, revenue, average assets and average equity for two periods of the same length.

Inputs

FieldUnitValue in the exampleMeaning
Net profit₽12,000,000From the profit and loss report; enter a loss with a minus sign.
Revenue₽300,000,000Revenue for the previous period excl. VAT: from the income statement; profitability and asset turnover are counted from it.
Assets (average for the period)₽180,000,000The average of the start and the end of the period or by month.
Equity (average)₽90,000,000The average; for small companies manual entry from simplified statements is acceptable.
Net profit₽15,000,000A period of the same length and composition as the previous one.
Revenue₽340,000,000Revenue for the current period excl. VAT: from the income statement, a period of the same length as the previous one.
Assets (average for the period)₽215,000,000The average of the start and the end of the period or by month.
Equity (average)₽100,000,000Equity for the current period, the average of the start and end from the balance sheet; financial leverage depends on it.

How it is calculated

StepFormula
ROEnet profit ÷ revenue × revenue ÷ assets × assets ÷ equity
Margin effect(margin after − margin before) × turnover before × leverage before
Turnover effectmargin after × (turnover after − before) × leverage before
Leverage effectmargin after × turnover after × (leverage after − before)

Worked numbers

Default values from the app; in the interactive version you enter your own.

ROE of the previous period
13.3 %
ROE of the current period
15 %
Change in ROE
1.7 p.p.
Contribution of net margin
1.4 p.p.
Contribution of asset turnover
−0.8 p.p.
Contribution of financial leverage
1 p.p.Higher leverage raises ROE but also risk: read it together with the growth of debt.

Three levers by period

IndicatorPreviousCurrentChange
Net profit margin4 %4.41 %0.41 %
Asset turnover1.67×1.58×−0.09×
Financial leverage2×2.15×0.15×
ROE13.33 %15 %1.67 %

Assets grow faster than revenue: stock, receivables and investments pile up. Check stock in “Stock and turnover”.

The main lever of the change: margin. The decomposition is sequential (margin, then turnover, then leverage); the order affects the split but not the total.

Nuances and limits

  • A rise in ROE through leverage is a rise in risk, not in efficiency.
  • The order of decomposition affects how contributions are split but not the total.
  • This is management analysis on simplified data, not an accounting document.

Terms used

Calculate on your data →