Dupont Analysis

Breaks return on equity into its three drivers, net profit margin, asset turnover and equity multiplier, so it is clear whether a high ROE comes from pricing power, asset efficiency or leverage. Net income, revenue, total assets, average assets and total liabilities are pulled per company and the decomposition is calculated in visible cells rather than one opaque formula. Reported return on equity sits next to the reconstructed figure as a check. Copy the block down for several tickers and the same ROE can be compared by source across a peer group.