Question

In: Finance

1. Summary income statements and balance sheets are presented for the three largest companies in the...

1. Summary income statements and balance sheets are presented for the three largest companies in the chemical industry for fiscal year 2016 (in millions).
Income Statement Balance Sheet
DuPont Dow PPG DuPont Dow PPG
Revenues 24594 48158 14751 Cash & Market Securities 5967 6607 1863
COGS 14440 37324 8063 Receivables, net 4789 8831 2692
Gross Profit 10154 10834 6688 Inventories 5673 7363 1546
SG&A Expenses 4319 3304 4630 Total Current Assets 17117 23659 6452
Net Income 2513 4318 877 Fixed Assets, net 9231 23486 2759
Total Assets 39964 79511 15769
Total Current Liabilities 8897 12604 4240
Total Liabilities 29966 53524 10943
Total Equity 9998 25987 4826
Preferred Stock 237 0 0
Working Capital 8220 11055 2212
Common Equity 9761 25987 4826
Complete the following tables using common-size analysis:
6. Given the information above, calculate the DuPont Model for the three chemical companies. Rate DuPont performance for these companies from 1 to 10.
DuPont Dow PPG
Profitability
Activity
Return on Assets DuPont Dow PPG
Solvency Common Equity 2016 9761 25987 4826
Return on Equity Common Equity 2015 9756 21374 4983
Ratings

Solutions

Expert Solution

Answer 1: To complete the following tables using common-size analysis:

  • For Income Statement, we will consider Revenue as 100 % and calculate the % of other items as a percentage of Revenue
  • For Balance Sheet, we will consider Total Asset as 100 % and calculate the % of other items as a percentage of Total Asset
  • See attached the Image for Common Size Statement

Related Solutions

1.                   A summary of data from the income statements and balance sheets of GCS Construction Company appears...
1.                   A summary of data from the income statements and balance sheets of GCS Construction Company appears below.                                                              2008                           2007                 Current Assets                 $366,000.00             $310,000.00                Total assets                        $2,320,000.00         $1,740,000.00                Long- Term Liabilities     $800,000.00              $580,000.00                Current Liabilities              $180,000.00              $120,000.000                Owners Equity                $1,340,000.00           $1,040,000.00                Net Sales                           $4,600.00.00              $3,480,000.00                Net Income                     $ 300,000.00                  $204,000.00 A.                  Compute the following liquidity measures for 2007 and 2007. Working capital and current ratio. Comment on the difference...
Comparative balance sheets and the income statements for Ellis Corporation are presented below: Comparative Balance Sheet...
Comparative balance sheets and the income statements for Ellis Corporation are presented below: Comparative Balance Sheet Ending Balance Beginning Balance Assets: Current assets: Cash and cash equivalents $ 45,900 $ 30,600 Accounts receivable 39,500 40,800 Inventory 73,700 62,400 Total current assets 159,100 133,800 Long-term investments 165,200 208,000 Property, plant, and equipment 294,700 163,500 Less accumulated depreciation 53,000 51,500 Total assets $ 566,000 $ 453,800 Liabilities and stockholders' equity: Current liabilities: Accounts payable $ 39,600 $ 43,200 Accrued liabilities 25,700 30,600...
Comparative balance sheets and the income statements for Ellis Corporation are presented below: Comparative Balance Sheet...
Comparative balance sheets and the income statements for Ellis Corporation are presented below: Comparative Balance Sheet Ending Balance Beginning Balance Assets: Current assets: Cash and cash equivalents $ 48,600 $ 33,000 Accounts receivable 39,900 43,200 Inventory 71,000 61,200 Total current assets 159,500 137,400 Long-term investments 168,500 220,000 Property, plant, and equipment 286,300 159,000 Less accumulated depreciation 53,000 52,500 Total assets $ 561,300 $ 463,900 Liabilities and stockholders' equity: Current liabilities: Accounts payable $ 38,500 $ 42,800 Accrued liabilities 25,000 31,800...
128. Comparative balance sheets and the income statements for Ellis Corporation are presented below: Comparative Balance...
128. Comparative balance sheets and the income statements for Ellis Corporation are presented below: Comparative Balance Sheet Ending Balance Beginning Balance Assets: Current assets: Cash and cash equivalents $ 45,900 $ 31,500 Accounts receivable 39,900 42,800 Inventory 71,000 62,400 Total current assets 156,800 136,700 Long-term investments 176,600 212,000 Property, plant, and equipment 286,300 162,000 Less accumulated depreciation 57,200 53,500 Total assets $ 562,500 $ 457,200 Liabilities and stockholders' equity: Current liabilities: Accounts payable $ 38,200 $ 42,800 Accrued liabilities 25,400...
Comparative balance sheets and the income statements for Ellis Corporation are presented below: Comparative Balance Sheet...
Comparative balance sheets and the income statements for Ellis Corporation are presented below: Comparative Balance Sheet Ending Balance Beginning Balance Assets: Current assets: Cash and cash equivalents $ 49,500 $ 30,600 Accounts receivable 39,100 43,600 Inventory 71,000 63,000 Total current assets 159,600 137,200 Long-term investments 176,600 208,000 Property, plant, and equipment 303,000 165,000 Less accumulated depreciation 57,200 51,000 Total assets $ 582,000 $ 459,200 Liabilities and stockholders' equity: Current liabilities: Accounts payable $ 38,200 $ 42,400 Accrued liabilities 25,400 30,600...
Comparative balance sheets and the income statements for Ellis Corporation are presented below: Comparative Balance Sheet...
Comparative balance sheets and the income statements for Ellis Corporation are presented below: Comparative Balance Sheet Ending Balance Beginning Balance Assets: Current assets: Cash and cash equivalents $ 49,500 $ 32,400 Accounts receivable 38,800 41,200 Inventory 71,000 64,200 Total current assets 159,300 137,800 Long-term investments 175,000 214,000 Property, plant, and equipment 294,700 165,000 Less accumulated depreciation 56,200 52,000 Total assets $ 572,800 $ 464,800 Liabilities and stockholders' equity: Current liabilities: Accounts payable $ 36,700 $ 41,600 Accrued liabilities 25,200 31,800...
Presented here are summarized data from the balance sheets and income statements of Wiper, Inc.: WIPER,...
Presented here are summarized data from the balance sheets and income statements of Wiper, Inc.: WIPER, INC. Condensed Balance Sheets December 31, 2017, 2016, 2015 (in millions) 2017 2016 2015 Current assets $ 829 $ 1,071 $ 933 Other assets 2,433 1,940 1,739 Total assets $ 3,262 $ 3,011 $ 2,672 Current liabilities $ 597 $ 850 $ 752 Long-term liabilities 1,638 1,115 982 Stockholders’ equity 1,027 1,046 938 Total liabilities and stockholders' equity $ 3,262 $ 3,011 $ 2,672...
Presented here are summarized data from the balance sheets and income statements of Wiper, Inc.: WIPER,...
Presented here are summarized data from the balance sheets and income statements of Wiper, Inc.: WIPER, INC. Condensed Balance Sheets December 31, 2017, 2016, 2015 (in millions) 2017 2016 2015 Current assets $ 707 $ 939 $ 793 Other assets 2,419 1,926 1,725 Total assets $ 3,126 $ 2,865 $ 2,518 Current liabilities $ 583 $ 836 $ 724 Long-term liabilities 1,530 997 870 Stockholders’ equity 1,013 1,032 924 Total liabilities and stockholders' equity $ 3,126 $ 2,865 $ 2,518...
Presented here are summarized data from the balance sheets and income statements of Wiper Inc.: WIPER...
Presented here are summarized data from the balance sheets and income statements of Wiper Inc.: WIPER INC. Condensed Balance Sheets December 31, 2020, 2019, 2018 (in millions) 2020 2019 2018 Current assets $ 798 $ 1,031 $ 893 Other assets 2,429 1,936 1,735 Total assets $ 3,227 $ 2,967 $ 2,628 Current liabilities $ 593 $ 846 $ 748 Long-term liabilities 1,611 1,079 946 Stockholders’ equity 1,023 1,042 934 Total liabilities and stockholders' equity $ 3,227 $ 2,967 $ 2,628...
Presented here are summarized data from the balance sheets and income statements of Wiper Inc.: WIPER...
Presented here are summarized data from the balance sheets and income statements of Wiper Inc.: WIPER INC. Condensed Balance Sheets December 31, 2020, 2019, 2018 (in millions) 2020 2019 2018 Current assets $ 722 $ 949 $ 803 Other assets 2,420 1,927 1,726 Total assets $ 3,142 $ 2,876 $ 2,529 Current liabilities $ 584 $ 837 $ 730 Long-term liabilities 1,544 1,006 874 Stockholders’ equity 1,014 1,033 925 Total liabilities and stockholders' equity $ 3,142 $ 2,876 $ 2,529...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT