Dupont Analysis

The DuPont analysis is a method of using financial ratios to assess the financial performance of a business.

The original DuPont analysis was used to analyse return on assets (ROA) into component parts.

ROA = Net income / Assets
ROA = (Net income / Revenue) x (Revenue / Assets)
ROA = Profit margin x Asset turnover

This original DuPont analysis formula showed that the return on assets is a function of the profitability of the business represented by the profit margin ratio, and the operational efficiency of the business represented by the asset turnover ratio.

This formula however does not show the effect of the financial leverage (the amount of debt) within the business, and so the DuPont analysis was extended to analyse the return on equity (ROE)

ROE = Net income / Equity
ROE = (Net income / Revenue) x (Revenue / Assets) x (Assets / Equity)
ROE = Net profit margin x Asset turnover x Equity multiplier
or alternatively
ROE = ROA x Equity multiplier

This extended DuPont analysis shows that the return on equity to an investor is a function of the profitability (indicated by the net profit margin ratio), the operational efficiency represented by the asset turnover ratio, and the financial leverage represented by the ratio of assets to equity, and known as the equity multiplier.

Using the DuPont analysis, an investor can see which elements of the business contribute to their total return on equity by looking at:

  1. How efficiently sales are being used to generate profits (net profit margin)
  2. How well assets are being used to generate revenue (Asset turnover)
  3. How much the business is using financial leverage (Equity multiplier)

DuPont Analysis Example

As an example of DuPont analysis, suppose the accounts of two businesses show the following financial information:

Information from Accounts
Business A Business B
Net income 30,000 63,000
Revenue 350,000 600,000
Assets 300,000 630,000
Equity 100,000 210,000

Using the DuPont analysis we can calculate the return on equity for both of these businesses as follows:

Dupont Financial Analysis Model
Business A Business B
Net profit margin 9% 11%
Asset Turnover 3.50 0.95
Equity multiplier 1.0 3.0
Return on equity (ROE) 30% 30%

Both businesses have the same return on equity for investors, however, the DuPont analysis shows that despite having similar profitability, business A has no leverage and gets its return from efficient use of its assets shown by the higher asset turnover ratio, whereas business B generates the investor return using financial leverage shown by the higher equity multiplier.

A further extension of the first term of the DuPont analysis produces the five ratio formula

ROE = (Net income / Revenue) x (Revenue / Assets) x (Assets / Equity)
ROE = (Operating income / Revenue) x (Revenue / Assets) x (Income before tax / Operating income) x (Assets / Equity) x (Net income / Income before tax)
ROE = Operating margin x Asset turnover x Financial cost ratio x Equity multiplier x Tax effect ratio 

The first two terms, operating margin and asset turnover represent the operational aspects of the business, how much profit can be obtained from revenue, how well assets are managed. The next two terms, financial cost ratio, and equity multiplier show how the return on equity is effected by the capital structure and finance costs of the business. And finally the tax effect ratio shows the impact of taxation on the return on equity.

DuPont Analysis Summary

The formulas developed on this page are summarized for easy reference in the diagram below.

dupont analysis v 1.0
DuPont Analysis Summary Preview

The DuPont analysis summary is available for download in PDF format by following the link below.

Dupont Analysis November 6th, 2016Team

You May Also Like

Related pages

easy bookkeeping spreadsheetswhat is a sundry expensetransfer of receivables with recourseprovision for obsolete inventoryrule of 78 loan calculatorcash payback period calculatorformat of asset registerinterest accrual journal entrynet credit sales formulahow to calculate double declining depreciation rateadjusting entries examplereceivables assignmentaccounting revenue recognition principlebookkeeping for a small business templateaverage account receivables formulacomparative common size income statementdifferentiate between trade discount and cash discountcash float definitionadjustments for unearned revenuefifo formulaaccounting templates exceldefine debtorsinternal control checklist templatebalance sheet reconciliations examplesavailable for sale vs trading securitiesmargin formula calculatortotal debt to equity ratio interpretationtwo column journal accountingwhat is the difference between markup and gross marginhow to calculate number of days sales in receivablesaccounts reconciliation templaterent revenue journal entryunearned revenue meaningaccounting debits and creditscash received receipt templatecalculation of gearing ratiointerest accrualsannuity immediate and annuity dueinterest payable journal entry examplediscount amortization schedulethe effective interest amortization methodrevenue projections templatecogs to salesaccounting trial balance worksheetbook keeping templatesjournal entry unearned revenuepv formula in excelperpetuity formula excelfixed manufacturing overhead costsfv in exceldiscounting of debtorsgeneral ledger examplesbookkeeping reconciliationgross sales equationcalculate beginning inventoryallowance doubtful accountswhat is the journal entry for accrued expensespresent value calculator compounded continuouslywip calculation formulacalculate asset turnovertvm calculatorsaccount recievable turnovercalculation of irr in excelgoods on consignment definitionhow to prepare a multiple step income statementnoncontrollable coststhe calculation of depreciation using the declining balance methoddouble entry for hire purchase of motor vehiclefuture value of an annuity calculator9 steps of the accounting cycleledger paper templateaged receivable reportexample of closing entriesfixed asset turnover ratiocompound and simple interest formulashow to determine predetermined overhead ratedistinguish between capital receipt and revenue receiptfinancial leverage formula accountingallowance to reduce inventory to marketcost of finished goods manufactured formulapresent value of annuity tablefreight prepaid definition