Question

In: Accounting

The common-size balance sheets from five companies follow: Alcoa, a major producer of aluminum products; Delta...

The common-size balance sheets from five companies follow: Alcoa, a major producer of
aluminum products; Delta Air Lines, a major airline; Duke Energy, a leading energy company
focused on electric power and gas distribution; JCPenney, a national retailer; and Pfizer, Inc.,
a global research-driven pharmaceutical company.

Required:
Based on your general business knowledge, the economic activities of these five firms, and
information derived from the following balance sheet analysis, match the company with its
respective balance sheet. Explain your reasoning for the choices that you make.
A B C D E
Assets
Current assets:
Cash and marketable securities 0.71 5.25 13.91 9.53 6.47
Current receivables 2.02 5.10 4.88 0.00 4.03
Inventories 3.14 9.42 4.49 28.82 0.00
Other current assets 0.99 2.00 2.88 4.20 6.55
Total current assets 6.87 21.77 26.16 42.55 17.04
Noncurrent assets:
Property, plant, and equipment, net 62.49 40.56 8.22 51.01 43.36
Goodwill and intangibles, net 13.49 14.79 52.91 0.00 27.58
Other assets, net 17.15 22.88 12.71 6.44 12.01
Total assets 100.00 100.00 100.00 100.00 100.00
Liabilities and Stockholders’ Equity
Current liabilities 9.41 14.27 17.56 25.55 32.98
Long-term debt 30.95 24.76 17.21 49.54 12.73
Other long-term liabilities 26.82 22.29 26.42 11.05 33.86
Stockholders’ Equity:
Preferred stock 0.00 0.16 0.02 0.00 0.00
Common stock and additional paid-in capital 31.34 31.24 48.65 50.91 20.47
Retained earnings 2.12 24.18 42.99 (31.85) 14.35
Treasury stock 0.00 (7.73) (47.33) 0.00 (0.70)
Other comprehensive income (0.67) (14.87) (5.69) (5.20) (13.69)
Total parent company common equity 32.79 32.82 38.63 13.86 20.42
Noncontrolling interests 0.04 5.71 0.17 0.00 0.00
Total equity 32.83 38.69 38.81 13.86 20.42
Total liabilities and stockholders’ equity 100.00 100.00 100.00 100.00 100.00
Note: Amounts are rounded.

Solutions

Expert Solution

Company E has no inventory, so we can immediately rule out Alcoa and Pfizer, two manufacturing concerns, as well retailer JCPenney. That leaves only Duke Energy and Delta Air Lines as possibilities. However, Company E does not have significant debt, so it is unlikely to be a utility like Duke Energy. Rate-regulated utilities have a predictable and stable earnings stream. As a result, they tend to finance their investments in PP&E with significant amounts of debt. So, Company E is Delta Air Lines.

Company A has significant PP&E and debt, which is consistent with it being the utility – Duke Energy. Although Companies B and D also have significant amounts of PP&E and debt, those two companies also carry significant inventories, which one would not expect for Duke Energy. So, Company A is Duke Energy.

Company D has very large inventories and no receivables. The large inventories suggest the retailer – JCPenney. The lack of receivables is consistent with the company not providing any credit on its own, but rather accepting cash or credit cards. In contrast, manufacturers such as the other remaining companies – Alcoa and Pfizer – typically offer trade credit to their customers. Company D is JCPenney.

That leaves Companies B and C for Alcoa and Pfizer. Company B has significantly more PP&E while Company C has far more intangible assets. Pfizer, a highly successful pharmaceutical company, also acquires organizations and purchases intangibles such as patents. In contrast, Alcoa would be expected to be more tangible asset intensive. So, Company B is Alcoa and Company C is Pfizer.

If you like the answer , please rate


Related Solutions

Common-Size Balance Sheets Following is the balance sheet for Target Corporation. Prepare Target’s common-size balance sheets...
Common-Size Balance Sheets Following is the balance sheet for Target Corporation. Prepare Target’s common-size balance sheets as of January 31, 2015 and February 1, 2014. (Round your answers to one decimal place.) ($ millions) January 31, 2015 February 1, 2014 Assets Cash and cash equivalents $2,210 $670 Inventory 8,790 8,278 Other current assets 3,087 2,625 Total current assets 14,087 11,573 Property and equipment, net 25,958 26,412 Other noncurrent assets 1,359 6,568 Total assets $41,404 $44,553 Liabilities and shareholders’ investment Accounts...
Below is the asset section of common-size balance sheets for Nike for a consecutive five-year period....
Below is the asset section of common-size balance sheets for Nike for a consecutive five-year period.          NIKE (NKE) 2019      2018     2017       2016        2015 Current Assets Cash and Equivalents 15.8%    10.5%      9.4%       8.9%        5.2% Receivables 25.7%    26.9%   31.3%     28.0%      27.9% Inventories 20.6%    20.7%   22.6%     21.3%      24.5% Other Current Assets 10.1% 11.8% 6.4% 6.2% 4.7% Total Current Assets 72.2% 69.8%    69.7%      64.5%     62.3% Non-Current Assets P P & E, Net 18.3% 20.1% 24.1% 25.1% 27.8% Intangibles      ...
AMERICAN APPAREL: DROWNING IN DEBT?1 Prepare the company’s common-size balance sheets and common-size income statements for...
AMERICAN APPAREL: DROWNING IN DEBT?1 Prepare the company’s common-size balance sheets and common-size income statements for the recent three years 2011-2013 (including all subtotals and totals and round to 2 numbers after the decimal). Analyze three major components based on the common-size balance sheets and the trends of those components over the three years. Analyze two major components based on the common-size income statements and the trends of those components over the three years. Use 10.00% as a threshold.
Following is the balance sheet for Target Corporation. Prepare Target’s common-size balance sheets as of February...
Following is the balance sheet for Target Corporation. Prepare Target’s common-size balance sheets as of February 3, 2018 and January 28, 2017. ($ millions) February 3, 2018 January 28, 2017 Assets Cash and cash equivalents $2,643 $2,512 Inventory 8,657 8,309 Other current assets 1,264 1,169 Total current assets 12,564 11,990 Property and equipment, net 25,018 24,658 Other noncurrent assets 1,417 783 Total assets $38,999 $37,431 Liabilities and shareholders’ investment Accounts payable $8,677 $7,252 Accrued and other current liabilities 4,254 3,737...
Exercise 13-6 Common-size percents LO P2 Simon Company's year-end balance sheets follow. At December 31 Current...
Exercise 13-6 Common-size percents LO P2 Simon Company's year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 29,670 $ 34,681 $ 37,989 Accounts receivable, net 86,861 60,079 50,155 Merchandise inventory 105,935 81,821 53,955 Prepaid expenses 9,748 9,472 4,262 Plant assets, net 275,747 251,844 229,839 Total assets $ 507,961 $ 437,897 $ 376,200 Liabilities and Equity Accounts payable $ 130,277 $ 72,525 $ 48,169 Long-term notes payable secured by mortgages on plant...
Exercise 17-6 Common-size percents LO P2 Simon Company's year-end balance sheets follow. At December 31 Current...
Exercise 17-6 Common-size percents LO P2 Simon Company's year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 35,402 $ 40,967 $ 41,017 Accounts receivable, net 102,605 73,866 55,794 Merchandise inventory 127,716 97,608 60,616 Prepaid expenses 11,287 11,080 4,511 Plant assets, net 323,019 293,745 256,562 Total assets $ 600,029 $ 517,266 $ 418,500 Liabilities and Equity Accounts payable $ 153,889 $ 89,166 $ 55,242 Long-term notes payable secured by mortgages on plant...
Following are data from the statements of two companies selling similar products: Current Year-End Balance Sheets...
Following are data from the statements of two companies selling similar products: Current Year-End Balance Sheets Dodger Company Brave Company Cash..................................................................... $ 21,900 $ 20,000 Notes receivable—short-term................................ 7,700 3,200 Accounts receivable, net....................................... 42,000 64,000 Inventory............................................................... 58,800 87,680 Prepaid expenses................................................. 1,680 1,520 Plant and equipment, net...................................... 232,120 264,400 Total assets.......................................................... $364,200 $440,800 Current liabilities................................................... $ 66,000 $ 78,000 Mortgage payable.................................................. 70,000 70,000 Common stock, $10 par value............................... 140,000 160,000 Retained earnings.................................................    88,200 132,800 Total liabilities and stockholders’ equity................. $364,200 $440,800...
Below is the balance sheet information on two companies. Prepare a common-size balance sheet for each...
Below is the balance sheet information on two companies. Prepare a common-size balance sheet for each company. Review each company's percentage of total assets. Are these companies operating with similar philosophies or in similar industries? What appears to be the major difference in financing for these two companies? Account Balance Sheet Company 1 Balance. Sheet Company 2 Current Assets Cash $5,377 $299 Investments $4,146 $354 Accts. Rec. $8,100 $221 Inventory $5,372 $494 Total Current $22,995 $1,368 Long Inv. $84 $307...
​Use your knowledge of balance sheets and common-size statements to fill in the missing dollar amounts....
​Use your knowledge of balance sheets and common-size statements to fill in the missing dollar amounts. Assets Cash $25,000 3.4% Accounts receivable $125,000 Inventory 27.1% Total current assets $350,000 Gross plant and equipment 95.0% Less: accumulated depreciation $313,000 42.5% Net plant and equipment Total assets $737,000 100.0% Liabilities Accounts payable 15.7% Notes payable $29,000 3.9% Total current liabilities Long-term debt $248,000 33.6% Total liabilities $393,000 Common stock ($.01 par, 450,000 shares) $4,500 0.6% Paid-in capital $220,500 29.9% Retained earnings Total...
Use your knowledge of balance sheets and common-size statements to fill in the missing dollar amounts....
Use your knowledge of balance sheets and common-size statements to fill in the missing dollar amounts. Assets Cash $25,000 3.4% Accounts receivable $125,000 Inventory 27.1% Total current assets $350,000 Gross plant and equipment 95.0% Less: accumulated depreciation $313,000 42.5% Net plant and equipment Total assets $737,000 100.0% Liabilities Accounts payable 15.7% Notes payable $29,000 3.9% Total current liabilities Long-term debt $248,000 33.6% Total liabilities $393,000 Common stock  ($.01 par, 450,000 shares) $4,500 0.6% Paid-in capital $220,500 29.9% Retained earnings Total stockholders’...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT