Question

In: Accounting

1. What amount is reported in the balance sheets as property, plant, and equipment (net) of...

1. What amount is reported in the balance sheets as property, plant, and equipment (net) of Coca-Cola at December 31, 2017, and of PepsiCo at December 31, 2017? What percentage of total assets is invested in property, plant, and equipment by each company?

2. What depreciation methods are used by Coca-Cola and PepsiCo for property, plant, and equipment? How much depreciation and amortization was reported by Coca-Cola and PepsiCo in 2017? In 2016? (Use cash flow statement amounts.)

3. Compute and compare the following ratios for Coca-Cola and PepsiCo for 2017.

a. Asset turnover.

b. Profit margin on sales.

c. Return on assets.

4. What amount was spent in 2017 for capital expenditures by Coca-Cola and PepsiCo?

Solutions

Expert Solution

(1)

Property, plant, and equipment, net of accumulated depreciation:

Coca-Cola at 12/31/17 $8,203 million
PepsiCo at 12/31/17 $17,240 million

Percent of total assets:

Coca-Cola ($8,203 ÷ $87,896) 9.33%
PepsiCo ($17,240 ÷ $79,804) 21.60%

(2)

Coca-Cola and PepsiCo depreciate property, plant, and equipment principally by the straight-line method over the estimated useful lives of the assets. Depreciation expense was reported by (in the cash flow statement) Coca-Cola (includes amortization) and PepsiCo as follows:

  Coca-Cola PepsiCo
2017 $1,260 million $2,369 million
2016 1,787 million 2,368 million
2015 1,970 million 2,416 million

(3)

(1) Asset turnover:

(2) Profit margin on sales:

(3) Return on assets:

With the exception of profit margin, each of PepsiCo’s ratios are stronger compared to Coca-Cola’s. PepsiCo’s lower profit margin is primarily due to its large food business which experiences larger investments in property, plant, and equipment and lower margins compared to the beverage segment. Coca-Cola sales are derived almost entirely from higher margin beverages.

(4)

Coca-Cola’s capital expenditures were $1,675 million in 2017 while PepsiCo’s capital expenditures were $2,969 million in 2017.


Related Solutions

What is the total amount of property, plant, and equipment that will appear on the Balance Sheet?
These are selected account balances on December 31, 2017: Land (location of the corporation’s office building) $400,000, Land held for investment $600,000, Office Building $2,900,000, Inventory $800,000, Equipment $1,800,000, Office Furniture $400,000, Accumulated Depreciation $1,200,000. What is the total amount of property, plant, and equipment that will appear on the Balance Sheet? $5,700,000 $6,900,000 $4,300,000 $4,900,000
A firm's Net Property, Plant & Equipment balance is $14,300,000 on January 1, 2018 and $12,850,000...
A firm's Net Property, Plant & Equipment balance is $14,300,000 on January 1, 2018 and $12,850,000 on December 31, 2018. The firm's Accumulated Depreciation balance is $4,500,000 on January 1, 2018 and $5,650,000 on December 31, 2018. What is the net purchases or net sales of Property, Plant and Equipment in 2018? Multiple Choice $1,450,000 net purchase $1,450,000 net sale $300,000 net sale $300,000 net purchase
A recent annual report for Naomi reported that the (gross) balance of property, plant, and equipment...
A recent annual report for Naomi reported that the (gross) balance of property, plant, and equipment at the end of the current year was $16,774 million. At the end of the previous year it was $15,667 million. During the current year, the company bought $2,118 million worth of new equipment. The balance of accumulated depreciation at the end of the current year was $8,146 million and at the end of the previous year was $7,654 million. Depreciation expense for the...
This year ABC Company reported net property, plant, and equipment (PP&E) of $17,607 after having reported...
This year ABC Company reported net property, plant, and equipment (PP&E) of $17,607 after having reported net PP&E of $11,825 last year. During the year the company sold PP&E with a net book value of $1,428 for $1,112. ABC also charged $7,851 in depreciation expenses against its earnings. How much did ABC spend to acquire PP&E during the year? Assume that all new PP&E was acquired for cash. Note that your answer will represent a cash outflow for purchasing new...
The plant assets section of the comparative balance sheets of Anders Company is reported below.
  The plant assets section of the comparative balance sheets of Anders Company is reported below. ANDERS COMPANY Comparative Balance Sheets       2017       2016   Plant assets                 Equipment   $ 255,000     $ 345,000   Accum. Depr.—Equipment     (130,000 )     (240,000 ) Equipment, net   $ 125,000     $ 105,000   Buildings   $ 455,000     $ 475,000   Accum. Depr.—Buildings...
U.S. GAAP and IFRS require property, plant, and equipment to be accounted for and reported differently....
U.S. GAAP and IFRS require property, plant, and equipment to be accounted for and reported differently. Explain the major differences between the two and how this affects the financial statements. Select one or the other method, explain your reason for your selection, providing support why your selection provides a benefit to the company.
U.S. GAAP and IFRS require property, plant, and equipment to be accounted for and reported differently....
U.S. GAAP and IFRS require property, plant, and equipment to be accounted for and reported differently. Explain the major differences between the two and how this affects the financial statements. Select one or the other method, explain your reason for your selection, providing support why your selection provides a benefit to the company. *PLEASE DO NOT GIVE THE SAME ANSWER AS THE OTHER ANSWER ON CHEGG FOR THIS QUESTION*
The assets of the Bermuda Corporation consist exclusively of Net Property, Plant and Equipment (PPE), and...
The assets of the Bermuda Corporation consist exclusively of Net Property, Plant and Equipment (PPE), and Current Assets. The firm has the total Assets of $50,000, while its Gross PPE equals $40,000 with the Depreciation of $10,000. It has the Notes Payable of $5,000, in addition to the Long-Term Debt of $15,000, and the Common Equity of $25,000. The company finances its needs with debt and common equity and does not have preferred stock on its balance sheet. Calculate the...
Problem 9-4A At January 1, 2017, Oriole Company reported the following property, plant, and equipment accounts:...
Problem 9-4A At January 1, 2017, Oriole Company reported the following property, plant, and equipment accounts: Accumulated depreciation—buildings $62,700,000 Accumulated depreciation—equipment 54,100,000 Buildings 97,400,000 Equipment 150,900,000 Land 23,000,000 The company uses straight-line depreciation for buildings and equipment, its year-end is December 31, and it makes adjusting entries annually. The buildings are estimated to have a 40-year useful life and no salvage value; the equipment is estimated to have a 10-year useful life and no salvage value. During 2017, the following...
At January 1, 2017, Blossom Company reported the following property, plant, and equipment accounts: Accumulated depreciation-buildings...
At January 1, 2017, Blossom Company reported the following property, plant, and equipment accounts: Accumulated depreciation-buildings $60,400,000 Accumulated depreciation-equipment 53,500,000 Buildings Equipment Land 97,600,000 150,000,000 21,850,000 The company uses straight-line depreciation for buildings and equipment, its year-end is December 31, and it makes adjusting entries annually. The buildings are estimated to have a 40-year useful life and no salvage value; the equipment is estimated to have a 10-year useful life and no salvage value During 2017, the following selected transactions...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT