In: Finance

# DuPont system of analysis Use the following ratio information for Johnson International and the industry averages for Johnson's line of business to

DuPont system of analysis

Use the following ratio information for Johnson International and the industry averages for Johnson's line of business to:

a. Construct the DuPont system of analysis for both Johnson and the industry.

b. Evaluate Johnson (and the industry) over the 3 -year period.

c. Indicate in which areas Johnson requires further analysis. Why?

$$\begin{array}{llll} \text { Johnson } & 2013 & 2014 & 2015 \\ \hline \text { Financial leverage multiplier } & 1.75 & 1.75 & 1.85 \\ \text { Net profit margin } & 0.059 & 0.058 & 0.049 \\ \text { Total asset turnover } & 2.11 & 2.18 & 2.34 \\ \hline \text { Industry averages } & & & \\ \hline \text { Financial leverage multiplier } & 1.67 & 1.69 & 1.64 \\ \text { Net profit margin } & 0.054 & 0.047 & 0.041 \\ \text { Total asset turnover } & 2.05 & 2.13 & 2.15 \end{array}$$

## Solutions

##### Expert Solution

a) DuPont sytem of analysis examines the return on equity (ROE) analyzing profit margin, total asset turnover, and financial leverage

Johnson

2013

ROE = Profit Margin x Total Asset Turnover x Leverage Factor

ROE = 0.059*2.11*1.75

ROE = 0.2179

ROE = 21.79%

2014

ROE = Profit Margin x Total Asset Turnover x Leverage Factor

ROE = 0.058*2.18*1.75

ROE = 0.2213

ROE = 22.13%

2015

ROE = Profit Margin x Total Asset Turnover x Leverage Factor

ROE = 0.049*2.34*1.85

ROE = 0.2121

ROE = 21.21%

Industry Average

2013

ROE = Profit Margin x Total Asset Turnover x Leverage Factor

ROE = 0.054*2.05*1.67

ROE = 0.1849

ROE = 18.49%

2014

ROE = Profit Margin x Total Asset Turnover x Leverage Factor

ROE = 0.047*2.13*1.69

ROE = 0.1692

ROE = 16.92%

2015

ROE = Profit Margin x Total Asset Turnover x Leverage Factor

ROE = 0.041*2.15*1.64

ROE = 0.1446

ROE = 14.46%

b) Johnson has performed better than Industry over the 3 years compared to Industry Individually, it has been decreased from the Year 2014 to 2015.

c) Johnson Requires to increase the Net Profit Margin area where the company performance would increase, leading to an increase in ROE.

## Related Solutions

##### Risk Assessment and Business Impact Analysis
Describe the differences and similarities between risk assesment and business impact analysis.
##### Calculate the unit product cost under absorption costing using the following information.
Calculate the unit product cost under absorption costing using the following information. Direct materials: $50/unit Direct labor:$75/Unit Variable manufacturing overhead:$27/Unit Fixed manufacturing overhead:$30,000 Units produced: 10,000 Units sold: 6,000
##### Classify the following phase changes by the signs of the system\'s ΔH and ΔS.
Classify the following phase changes by the signs of the system\'s ΔH and ΔS.
##### Use the table of standard reduction potentials given above to calculate the equilibrium constant at standard temperature (25 ∘C) for the following reaction:
Standard reduction potentials Reduction half-reaction E∘ (V) Ag+(aq)+e−→Ag(s) 0.80 Cu2+(aq)+2e−→Cu(s) 0.34 Sn4+(aq)+4e−→Sn(s) 0.15 2H+(aq)+2e−→H2(g) 0 Ni2+(aq)+2e−→Ni(s) −0.26 Fe2+(aq)+2e−→Fe(s) −0.45 Zn2+(aq)+2e−→Zn(s) −0.76 Al3+(aq)+3e−→Al(s) −1.66 Mg2+(aq)+2e−→Mg(s) −2.37 Part A Use the table of standard reduction potentials given above to calculate the equilibrium constant at standard temperature (25 ∘C) for the following reaction: Fe(s)+Ni2+(aq)→Fe2+(aq)+Ni(s) Express your answer numerically. Part B Calculate the standard cell potential (E∘) for the reaction X(s)+Y+(aq)→X+(aq)+Y(s) if K = 3.04×10−3. Express your answer to three significant figures and include the appropriate...