Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Below are the ratios (with excel formulas) calculated for Pepsi-Co, Inc. for you - all you need to do is calculate the Coca-Cola Company ratios
Below are the ratios (with excel formulas) calculated for Pepsi-Co, Inc. for you - all you need to do is calculate the Coca-Cola Company ratios | |||||||
Pepsi-Co, Inc. | The Coca-Cola Company | ||||||
Selected Financial Data | Selected Financial Data | ||||||
For years ended December 31 | For years ended December 31 | ||||||
2020 | 2019 | 2018 | 2020 | 2019 | 2018 | ||
Acid-test ratio (CA-inventory-prepaid)/CL | 0.77 | 0.66 | 0.82 | ||||
Current ratio | 0.98 | 0.86 | 0.99 | ||||
Debt ratio | 0.85 | 0.81 | 0.81 | ||||
Earnings per share | 5.14 | 5.23 | 8.84 | ||||
Inventory turnover | 8.47 | 9.32 | 9.39 | ||||
Net income ($ in millions) | $ 7,120 | $ 7,314 | $ 12,515 | ||||
Rate of return on assets | 10.97% | 13.05% | 13.40% | ||||
Receivables turnover | 8.67 | 8.98 | 9.05 | ||||
Return on assets | 9.34% | 10.31% | 17.69% | ||||
Operating income percentage | 14.32% | 15.32% | 15.64% | ||||
Revenues ($ in millions) | $ 70,372 | $ 67,161 | $ 64,661 | ||||
Times interest earned ratio | 9.04 | 10.96 | 8.54 | ||||
Working capital ($ in millions) | (371) | (2,816) | (245) | ||||
Notes: | |||||||
Debt ratio = TL/TA | |||||||
Inv. TO= CGS/Avg. Inv. | |||||||
Rate of Return on Assets=EBIT/TA | |||||||
Acciounts receivable TO=SALES/Avg. AR | |||||||
Return on Assets=NI + {Interest Expense * (1-Tax)} / Avg TA | |||||||
Operating Income %=operatinig income /SALES REVENUE | |||||||
TIE Ratio=EBIT/Interest Exp. | |||||||
WC=CA - CL | |||||||
Inventory Turnover, Receivables Turnover, Return on Assets figures for 2018 use ONLY 2018 values in the denominator as we don't have 2017 numbers to average |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started