90.2K

Verified Solution

Link Copied!

Coca Cola vs Pepsi Cola

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.

FINAL PART ONE

Refer to document : Other Financial Data Coca Cola and Pepsi Cola:

to answer the following:

The price earnings ratio for Coca Cola is and for Pepsi cola is ______.

Based on this price ratio only, all other things about the companies being the same, which stock is a better bargain? ________. Given a choice, which stock would you buy? _______ Why?

List the Operating Revenue for Coca Cola and Pepsi Cola for 2018, 2017 and 2016.

Calculate the Year to Year percentage increase in Operating Revenue for each company:

List the Earnings per Share for Coca Cola and Pepsi Cola for 2018, 2017 and 2016.

Calculate the Year to Year percentage increase in Earnings per Share for each company:

Common Stock Outstanding as of 2018 for Coca Cola equals _______ issued shares less _______ treasury shares.

Common Stock Outstanding as of 2018 for Pepsi Cola equals _______ issued shares less _______ treasury shares.

What was the estimated average cost of the treasury stock of Coca Cola as of FY2018?

What was the estimated average cost of the treasury stock of Pepsi Cola as of FY2018?

a. What is the par value of Coca Cola common stock?

b. What is the recent price of Coca Cola Common stock?

c. What is the estimated book value of Coca Cola Common Stock as FY2018?

a. What is the par value of Pepsi Cola common stock?

b. What is the recent price of Pepsi Cola Common stock?

c. What is the estimated book value of Pepsi Cola Common Stock as FY2018? Divide by 1,409 Shares.

Complete the following for Coca Cola and Pepsi Cola for FY2018:

a.Coke: Cur Debt ______+ L/T Debt ______+ Def Tx $1,933+ OL $1,738= Total Debt________.

b.Pepsi: Cur Debt _____ +L/T Debt _______+ Def Tx $3499+ OL $9,114 = Total Debt________.

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?

Coca Cola 4/7/2020 2017 2016 Pepsi Cola 47720 2015 in millions except EPS Opti He 35.410 Op Revenue $35 S01,856 SI.SI 4259 $6414 41.865 51.51 4317 $6522 Shares standing Net Inc w to CS 4272 S1248 Share winding Net Inco CS $12515 54857 56 $396 1667 57.140 40:46 Days in Collectie 7520 RON Total As $7.96 Total Ass 3216 5292 525 364 STE 21 59 Se 513395 LT Debt $31.152 49 tp 4 LTD Come si 25 par 11200 A700 Iss $1.766 $1.760 1409 & 1420 Treasury Stack 2772, 2781 -$51.219 550667 Treasury Stock Stock $16.95 o ck $14SIS S103 Equity to controlling Equity to controlling Total quity $17.072 S105 SIR 977 Equity to cooling C Equity to ling Total quity $19.058 Total Liabilities & Equity Total L & Equity $22.128.00 520 52.00 $29.223 $25 $27.194 01.12 51.913 52 522 $68 919 Retained Eamings Capital Surplus Accumulated Compensive Inc Treasury Stock $6314 SI520 -S12814 -551,719 51,760 560.410 SS24 $10.05 -350 677 $1.760 PS Rapunched Retained amings Capital Suples Accumulate Conc e Long-Term Dube Long-Term Debt US Dollar Notes de 2019-2003 US Dollar Debymunede 300-2098 Euro Notes 2010-2016 Swiss Franc 2000-2008 58433 2019 11.11 20301 53.784 2021 20 S $16151 $1.257 SI LT Debt 3115 $32348 537516 S5 533 Company "Coca Cola is the w o rst walhati beverage espany We own or lace more than 500 non-alcoholic beverage brands We make our branded products to consumers thout the world through our network of independent bottling partners, distributor wholesalers , as well as company own r olled bottling Pepsi Cola is a global food and beverage s boldogs include Frito Lay, Galade, Colla Quake and Tropicas Que padeces cereal, nice and past These are reportable spe s e 2018. Netts Reven FroLay US NA and Canada Quaker US & Canada NABUS & Canada 1072 Bev Food ASLA 37354 Bev Food & Son Europe and SubSahar A ESSA) SI1.523 There are operating sement ELI, ME & Africa Latin America 2013. Net Opating Revue 57.702 Asia Pacific Bolig Investment Adjustment S11.763 55.197 St 175 $31.456 Coca Cola 4/7/2020 2017 2016 Pepsi Cola 47720 2015 in millions except EPS Opti He 35.410 Op Revenue $35 S01,856 SI.SI 4259 $6414 41.865 51.51 4317 $6522 Shares standing Net Inc w to CS 4272 S1248 Share winding Net Inco CS $12515 54857 56 $396 1667 57.140 40:46 Days in Collectie 7520 RON Total As $7.96 Total Ass 3216 5292 525 364 STE 21 59 Se 513395 LT Debt $31.152 49 tp 4 LTD Come si 25 par 11200 A700 Iss $1.766 $1.760 1409 & 1420 Treasury Stack 2772, 2781 -$51.219 550667 Treasury Stock Stock $16.95 o ck $14SIS S103 Equity to controlling Equity to controlling Total quity $17.072 S105 SIR 977 Equity to cooling C Equity to ling Total quity $19.058 Total Liabilities & Equity Total L & Equity $22.128.00 520 52.00 $29.223 $25 $27.194 01.12 51.913 52 522 $68 919 Retained Eamings Capital Surplus Accumulated Compensive Inc Treasury Stock $6314 SI520 -S12814 -551,719 51,760 560.410 SS24 $10.05 -350 677 $1.760 PS Rapunched Retained amings Capital Suples Accumulate Conc e Long-Term Dube Long-Term Debt US Dollar Notes de 2019-2003 US Dollar Debymunede 300-2098 Euro Notes 2010-2016 Swiss Franc 2000-2008 58433 2019 11.11 20301 53.784 2021 20 S $16151 $1.257 SI LT Debt 3115 $32348 537516 S5 533 Company "Coca Cola is the w o rst walhati beverage espany We own or lace more than 500 non-alcoholic beverage brands We make our branded products to consumers thout the world through our network of independent bottling partners, distributor wholesalers , as well as company own r olled bottling Pepsi Cola is a global food and beverage s boldogs include Frito Lay, Galade, Colla Quake and Tropicas Que padeces cereal, nice and past These are reportable spe s e 2018. Netts Reven FroLay US NA and Canada Quaker US & Canada NABUS & Canada 1072 Bev Food ASLA 37354 Bev Food & Son Europe and SubSahar A ESSA) SI1.523 There are operating sement ELI, ME & Africa Latin America 2013. Net Opating Revue 57.702 Asia Pacific Bolig Investment Adjustment S11.763 55.197 St 175 $31.456

Answer & Explanation Solved by verified expert

See Answer