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 25 par b What is the recent price of Coca Cola Common stock $1,760 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 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 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 2 177 Other Financial Data Pepsi Cola 2 xlsx 3 co Coca Cola 4 7 2020 Price 2018 2017 2016 2018 2017 2016 16 93 31 07947 14 1016561 (in millions except EPS) Operating Revenue EPS Shares outstanding Net Inc attrib to CS $31 856 $1 51 4 259 $6,434 S35,410 $0 29 4,272 S1 248 541,863 $1 51 4,317 56,527 Pepsi Cola 4 7 2020 Price 130 89 (in millions except EPS) Operating Revenue EPS Shares outstanding Net Inc alinib to CS S64,661 S8 84 1 415 S12,515 S63 525 $3,40 1 425 $4 857 S62,799 $4 39 1 439 S6,329 2018 9 02 AR Turnover A R Inventory $3,396 $2 766 $3,667 S2,655 A R Inventory $7 142 $3 128 $7 024 $2 947 40 46 Days in Collection 7 52 ROA Total Assets Current Liabilities LT Debt S83 216 $29,223 $25,364 $87 896 $27 194 $31,182 Total Assets Current Liabilities LT Debt $77 648 S22,138 $28,295 $79,804 $20 502 1 49 LTD to Equity $33,796 12 3 cents Common Stock 25 par 11200 Auth7040 Iss Common Stock 1409 1420 $1,760) SI,760 S23 $24 Treasury Stock 2772, 2781 $51 719 $50 667 $35 286 S32 757 Equity to controlling Comm Stock Equity to non controlling Total Equity $14,518 $16,981 $2 077 $19,058 Treasury Stock 458 446 Equity to controlling Comm Stock Equity to non ontrolling Total Equity $17,072 $1,905 $18 977 $10,889 $92 S10 981 $14,602 Total Liabilities Equity Total Liabilities Equity $29,223 $25,364 $7 638 $1 933 S64 158 $27 194 $31,182 $8,021 $2 522 $68,919 $22,138,00 $28 295 00 $3,499 00 $9,114 00 $63 0146,000 $20,502 00 $33 796 00 $3,242 00 $11,283 00 $68,823,00 PIS 197 52839 1996 Retained Earnings Capital Surplus Accumulated Comprehensive Inc Treasury Stock $63,234 $16 520 SI 2 814 SS1 719 $1,760 $16 981 $60,430 S15 864 $10 305 S50 677 S1 760 $17,072 P S Repurchased Retained Earings Capital Surplus Accumulated Comprehensive Inc Treasury Stock Common Stock 59947 3953 15119 34286 23 14518 13057 32757 10889 $4,016 Long Term Debt US Dollar Notes due 2019 2093 US Dollar Debentures due 2020 2098 Euro Notes 2019 2036 Swiss Franc 2020 2028 Other Total Current LT Debt 13619 1300 12994 1128 1230 30261 4997 25364 16854 1559 13663 1148 1256 34480 3298 31182 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 49 2024 47 2 7 3 8 SO $3 948 $3 784 $3,257 $3,802 S1 270 $16,161 S26 S32,248 $3,953 S28 295 $3 792 $3,300 $3 853 $1,257 SI 7,634 $31 $37,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 world through our network of independent bottling partners, distributors, wholesalers and retailers, as well as company owned or controlled bottling and distribution operations There are s operating segments 2018 Net Operating Revenue EU, ME Africa 7,702 Latin America $4,014 $11 768 Asia Pacific S5 197 Bottling Investment 3771 53 175 Adjustments 596 Total $31 856 Company Pepsi Cola is a global food and beverage company It's holdings include Fnto 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 US Canada S2,465 NA BY US Canada $21,072 Bey 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 NA Auditor Ernst Young LLP Auditor KPMG LLP

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 08, 2024

The price earnings ratio for Coca Cola is and for Pepsi cola is . Based on this price ratio only, all other things about

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? 25 par

b. What is the recent price of Coca Cola Common stock? $1,760

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
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.
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?

2:177 Other Financial Data...& Pepsi Cola 2.xlsx 3 co Coca Cola 4/7/2020 Price 2018 2017 2016 2018 2017 2016 16.93 31.07947 14.1016561 (in millions except EPS) Operating Revenue EPS Shares outstanding Net Inc attrib to CS $31.856 $1.51 4.259 $6,434 S35,410 $0.29 4,272 S1.248 541,863 $1.51 4,317 56,527 Pepsi Cola 4/7/2020 Price 130.89 (in millions except EPS) Operating Revenue EPS Shares outstanding Net Inc alinib to CS S64,661 S8.84 1.415 S12,515 S63.525 $3,40 1.425 $4.857 S62,799 $4.39 1.439 S6,329 2018 9.02 AR Turnover A/R Inventory $3,396 $2.766 $3,667 S2,655 A/R Inventory $7.142 $3.128 $7.024 $2.947 40.46 Days in Collection 7.52% ROA Total Assets Current Liabilities LT Debt S83.216 $29,223 $25,364 $87.896 $27.194 $31,182 Total Assets Current Liabilities LT Debt $77.648 S22,138 $28,295 $79,804 $20.502 1.49 LTD to Equity $33,796 12/3 cents Common Stock 25 par 11200 Auth7040 Iss Common Stock 1409 & 1420 $1,760) SI,760 S23 $24 Treasury Stock 2772, 2781 -$51.719 $50.667 -$35.286 -S32.757 Equity to controlling Comm Stock Equity to non-controlling Total Equity $14,518 $16,981 $2.077 $19,058 Treasury Stock 458 & 446 Equity to controlling Comm Stock Equity to non-ontrolling Total Equity $17,072 $1,905 $18.977 $10,889 $92 S10.981 $14,602 Total Liabilities & Equity Total Liabilities & Equity $29,223 $25,364 $7.638 $1.933 S64.158 $27.194 $31,182 $8,021 $2.522 $68,919 $22,138,00 $28.295.00 $3,499.00 $9,114.00 $63.0146,000 $20,502.00 $33.796.00 $3,242.00 $11,283.00 $68,823,00 PIS -197 52839 1996 Retained Earnings Capital Surplus Accumulated Comprehensive Inc. Treasury Stock $63,234 $16.520 SI 2.814 -SS1.719 $1,760 $16.981 $60,430 S15.864 -$10.305 -S50.677 S1.760 $17,072 P/S Repurchased Retained Earings Capital Surplus Accumulated Comprehensive Inc. Treasury Stock Common Stock 59947 3953 -15119 -34286 23 14518 -13057 -32757 10889 $4,016 Long-Term Debt US Dollar Notes due 2019-2093 US Dollar Debentures due 2020-2098 Euro Notes 2019-2036 Swiss Franc 2020-2028 Other Total Current LT Debt 13619 1300 12994 1128 1230 30261 4997 25364 16854 1559 13663 1148 1256 34480 3298 31182 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.49 2024-47 2.7% 3.8% SO $3.948 $3.784 $3,257 $3,802 S1.270 $16,161 S26 S32,248 $3,953 S28.295 $3.792 $3,300 $3.853 $1,257 SI 7,634 $31 $37,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 world through our network of independent bottling partners, distributors, wholesalers and retailers, as well as company owned or controlled bottling and distribution operations." There are s operating segments: 2018 - Net Operating Revenue EU, ME & Africa 7,702 Latin America $4,014 $11.768 Asia Pacific S5.197 Bottling Investment 3771 53.175 Adjustments -596 Total $31.856 Company Pepsi Cola is a global food and beverage company. It's holdings include Fnto 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. US & Canada S2,465 NA BY US & Canada $21,072 Bey 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 NA Auditor Ernst & Young LLP Auditor KPMG LLP