Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started