Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The above chart reflects the inventory turnover for Coca Cola (in blue) and Pepsi Cola (in red) for 2014 through 2018. The inventory turnover is

The above chart reflects the inventory turnover for Coca Cola (in blue) and Pepsi Cola (in red) for 2014 through 2018. The inventory turnover is calculated by dividing the cost of goods sold (or sales) by the average inventory. It is a measure of the speed at which inventory is sold. The ratio for Coca Cola fell between 5.61 in 2014 and 4.34 in 2018. The average inventory turnover value for Coca Cola over the five-year period was 5.33. The ratio of Pepsi Cola fell between 9.43 in 2014 and 9.67 in 2018. The average inventory turnover value for Pepsi Cola over the five-year period was 9.86. Pepsi Cola experienced an inventory turnover ratio that was 85% higher than that of Coca Cola.

The chart above reflects the days in inventory for Coca Cola (in blue) and Pepsi Cola (in red) for 2014 through 2018. The days in inventory is a measure of the number of days it takes to sell inventory. The number of days in inventory for Coca Cola fell between 65 days in 2014 and 84 days in 2018. The average number of days in inventory for Coca Cola over the five-year period was 69 days. The number of days in inventory for Pepsi Cola fell between 39 in 2014 and 38 in 2018. The average number of days in inventory for Pepsi Cola over the five-year period was 37 days.

The above chart reflects the accounts receivable turnover for Coca Cola (in blue) and Pepsi Cola (in red) for 2014 through 2018. The accounts receivable turnover is calculated by dividing net sales by the average accounts receivable. This ratio is a measure of the speed at which accounts receivable turn over. The ratio for Coca Cola fell between 9.85 in 2014 and 9.02 in 2018. The average accounts receivable turnover value for Coca Cola over the five-year period was 9.91. The ratio of Pepsi Cola fell between 11.12 in 2014 and 12.75 in 2018. The average inventory turnover value for Pepsi Cola over the five-year period was 11.02. Pepsi Cola experienced an inventory turnover ratio that was 11% higher than that of Coca Cola.

The chart above reflects the days in accounts receivable for Coca Cola (in blue) and Pepsi Cola (in red) for 2014 through 2018. The days in accounts receivable is a measure of the number of days it takes to collect accounts receivable. The number of days in accounts receivable for Coca Cola fell between 37.05 days in 2014 and 40.46 days in 2018. The average number of days in inventory for Coca Cola over the five-year period was 37 days. The number of days in accounts receivable for Pepsi Cola fell between 32.83 in 2014 and 33.97 in 2018. The average number of days in accounts receivable for Pepsi Cola over the five-year period was 33.13 days.

Coke: Tot Debt __+Tot EQ to Com. _______+ Tot EQ to non Cont______= TA $83,216

Pepsi : Tot Debt ________+Tot EQ to Com. _______+ Tot EQ to non Cont______= TA $77,648

Coke : FY2018 Current Debt = _______% of Total Debt, LTDebt = _______% of Total Debt.

Pepsi : FY2018 Current Debt = _______% of Total Debt, LTDebt = _______% of Total De

Which operating segment of Coca Cola generated the largest operating revenue in FY2018?

Which operating segment of Pepsi Cola generated the largest operating revenue in FY2018?image text in transcribed

2:177 ..1 Other Financial Data...& Pepsi Cola 2.xlsx 3 Coca Cola 4/7/2020 Price 2018 2017 2016 Pepsi Cola 2018 2017 2016 46.93 31.07947 14.806561 (in millions es except EPS) Operating Revenue EPS Shares outstanding Net Inc attrib to CS $31.856 $1.51 4.259 $6,434 $35.410 $0.29 4.272 SL.248 $41,863 S1.51 4.317 S6,527 4/7/2020 Price 130.89 (in millions except EPS) Operating Revenue EPS Shares outstanding Net Inc atinib to CS 564,661 $8.84 1,415 $12,515 $63.525 $3.40 1,425 $4,857 $62,799 $4.39 1,439 $6,329 $3,667 AR Inventory 2018 9.02 A/R Turnover AR Inventory $7,024 S2.947 $2.766 $7,142 $3,128 $2,655 Total Assets 40.46 Days in Collection 7.52% ROA $77.648 Current Liabilities LT Debt 583.216 S29,223 $25,364 $87,896 $27,194 $31,182 Total Assets Current Liabilities LT Dcht S22,138 $28,295 $79,804 $20.502 S33.790 1.49 LTD to Equity 12/3 cents Common Stock 25 par 11200 Auth7040 Iss $1,760 $1,760 Common Stock 1409 & 1420 S23 $24 Treasury Stack 2772, 2781 -S51,719 -$50,667 -S35.286 -S32.757 Equity to controlling Comm Stock Equity to non controlling Total Equity $16.981 $2,077 $19,058 $17,072 $1,905 $18.977 Treasury Stock 458 & 446 Equity to controlling Comm Stock Equity to non-ontrolling Total Equity $14.518 884 $14,602 S10.889 $92 S10,981 Total Liabilities & Equity Total Liabilities & Equity $29,223 S25,364 $7,638 $1.933 S64.15 $27,194 $31,182 $8,021 $2.522 $68.919 $22,138.00 $28,295.00 $3,499.00 $9,114.00 $63,046,00 $20,502.00 $33.796.00 $3,242.00 S11.283.00 $68,823.00 Retained Earnings Capital Surplus Accumulated Comprehensive Inc. Treasury Stock $63,234 $16.520 $12.814 -S51,719 $1,700 $16.981 $60,430 SI5,864 $10,305 -$50.677 S1,760 $17,072 P/S P/S Repurchased Retained Eamings Capital Surplus Accumulated Comprehensive Ine Treasury Stock Common Stock 59947 3953 -15119 -34286 23 14518 41 -197 52839 3996 -13057 -32757 24 10889 16854 1559 Long-Term Debt US Dollar Notes due 2019-2093 U.S. Dollar Debentures due 2020-2098 Euro Notes 2019-2036 Swiss Frane 2020-2028 Other Total Current LT Debt 13619 1390 12994 1128 1230 30361 4997 25364 Long-Term Debt 2018 2.40% 2019 3.1-3.2% 2020 3.9-3.1% 2021 3.1-2.4% 2022 2.8-2.6% 2023 2.9-2.444 2024-47 2.7% 3.8% 1256 34480 3298 31182 SO $3,948 53,784 $3.257 $3,802 $1,270 $16,161 S26 $32,248 $3,953 $28,295 $4.016 $3.933 53.792 $3,300 $3.853 $1,257 SI 7,634 $31 S37,816 $4,020 S33,796 Current LT Debt Company "Coca Cola is the world's largest non-alcoholic beverage company. We own or license more than 500 non-alcoholic beverage brands. We make our branded products available to consumers througout the work through our network of independent bottling partners, distributors, wholesalers and retailers, as well as company owned or controlled bottling and distribution operations." There are 5 operating segments: 2018 - Net Operating Revenue EU. ME & Africa $7,702 Latin America $4,014 NA $11.768 Asia Pacific 55,197 Bottling Investment 3771 $3,175 Adjustments -596 Total $31,856 Company Pepsi Cola is a global food and beverage company. It's holdings include Frito Lay, Gatorade, Persi-Cola, Quaker, and Tropicana. Quaker produces cereal, rice and pasta There are 6 reportable operating segments: 2018. Net Operating Revenue Frito Lay U.S. NA and Canada $16,346 Quaker. U.S. & Canada S2,465 NA Bev U.S. & Canada $21,072 Bev Food & Sery-Latin America $7,354 Bev Food & Sery - Europe and Sub Saharan Africa (ESSA) S11,523 Bev Food & Sery - Asia, Middle East and No. Africa $5,901 Total $64,661 Auditor Ernst & Young LLP Auditor KPMG LLP

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_2

Step: 3

blur-text-image_3

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

Social Media Audit And Stats Audit And Statistics For Social Media Platforms

Authors: Virtual Desk Tools

1st Edition

B09JDX8Z9M, 979-8492994938

More Books

Students also viewed these Accounting questions

Question

Discuss five types of employee training.

Answered: 1 week ago

Question

Identify the four federally mandated employee benefits.

Answered: 1 week ago