Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Common-size Analysis. Summary income statements and balance sheets are presented for the three largest companies in the chemical industry for fiscal year 20xx (current year,

Common-size Analysis. Summary income statements and balance sheets are presented for the three largest companies in the chemical industry for fiscal year 20xx (current year, in millions) and for fiscal year 20yy (prior year, in millions). For additional information, their web sites (ticker symbols) are www.dupont.com (DD); www.dow.com (DOW); and www.ppg.com (PPG). Hint: Use the Dow and PPG calculations as a guide. You can use the ratios from the textbook but if the ratios require information not provided below then assume that item is zero.

Income Statement

Du Pont

Dow

PPG

Revenues

$24,726

$27,805

$8,169

COGS

16,727

22,015

5,137

Gross Profit

7,999

5,790

3,032

SG&A Expenses

4,513

2,807

1,764

Net Income

4,339

-385

387

Balance Sheet

Du Pont

Dow

PPG

Cash & MS

$5,763

$220

$108

Receivables, net

3,903

5,098

1,416

Inventories

4,215

4,440

904

Total Current Assets

14,801

10,308

2,703

Fixed Assets, net

13,287

13,579

2,752

Total Assets

40,319

35,515

8,452

Total Current Liabilities

8,067

8,125

1,955

Total Liabilities

25,867

25,522

5,372

Total Equity

14,452

9,993

3,080

Additional Inforamtion for prior year (20yy)

DuPont

Dow

PPG

Inventory

$4,658

$3,463

$1,121

Receivables, net

4,552

5,385

1,563

Working Capital

2,401

1,387

550

Fixed Assets, net

13,287

13,579

2,752

Total Assets

39,426

27,645

9,125

Total Equity

13,299

9,686

3,097

Complete these tables using common-size analysis for Du Pont: (Use Dow and PPG results as a guide)

Common - Size Income Statement

Du Pont

Dow

PPG

Revenues

100.00%

100.00%

COGS

79.18%

62.88%

Gross Profit

20.82%

37.12%

SG&A Expenses

10.10%

21.59%

Net Income

-1.38%

4.74%

Common Size Balance Sheet

Du Pont

Dow

PPG

Cash & MS

0.62%

1.28%

Receivables, net

14.35%

16.75%

Inventories

12.50%

10.70%

Total Current Assets

29.02%

31.98%

Fixed Assets, net

38.23%

32.56%

Total Assets

100.00%

100.00%

Total Current Liabilities

22.88%

23.13%

Total Liabilities

71.86%

63.56%

Total Equity

28.14%

36.44%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Practical Guide To Auditing SAP Systems

Authors: Martin Metz, Sebastian Mayer

1st Edition

3960126409, 978-3960126409

More Books

Students also viewed these Accounting questions