Question

A company’s assets consist of $254,478 of cash, $579,445 of accounts receivable, $487,009 of inventory, and $2,478,554 of plant and equipment. Its liabilities consist of $332,887 of accounts payable, $139,877 of accruals, and $1,275,000 of long-term debt. The company’s annual sales are $4,765,889, it paid $165,750 of interest, its earnings before taxes are $453,816, and its net income is $272,289. In its industry, the average profit margin is 6.83%, the average total asset turnover is 1.25, and the average equity multiplier is 1.85. Using DuPont analysis, determine if the company’s return on equity is above or below the industry average and what factor causes the difference?

Answer 1

Answer:

The company's Return on Equity is 18.49% therefore is above the industry average of 15.79%

Explanation:

DU PONT ANALYSIS    

ROE = PROFIT MARGIN X ASSET TURNOVER X EQUITY MULTIPLIER

Industry average ROE

0.0683 x 1.25 x 1.85 = 0,15794375 = 15.79%

Company Dupont:

Profit margin:

income  272,289

sales   4,765,889

profit margin: 0,05713288

Assets Turnover:

Sales 4,765,889

Total assets:

Cash  254,478

A/R          487,009

PEE      2,478,554

total       3,220,041

Turnover: 1.48

Equity Multiplier:

Assets 3,220,041

Liabilities:

A/P            332,887

Accrued             139,877

long-term 1,275,000

total          1,747,764

Equity: 3,220,041 - 1,747,764 = 1,472,277

Equity multiplier: 3,220,041 / 1,472,277 =  2.187116  

Company's Dupont Calculation:

ROE = PROFIT MARGIN X ASSET TURNOVER X EQUITY MULTIPLIER

0,05713288   x     1.48    x  2.187116   = 0,184935229 = 18.49%