Rearrange the data and ratios into a report format that groups similar data and ratios together, to make it easier to analyze the data. Using the given financial data for The Coca-Cola Company, discuss the company's: Ability to pay current liabilities. Ability to sell inventory and collect receivables. Ability to pay long-term debt; and Profitability. Using the given financial data for PepsiCo, Inc., discuss the company's: Ability to pay current liabilities. Ability to sell inventory and collect receivables; Ability to pay long-term debt; and Profitability. Now compare Coca-Cola's financial position to PepsiCo's financial position. How do the two companies compare in the following areas? Ability to pay current liabilities Ability to sell inventory and collect receivables Ability to pay long-term debt Profitability What conclusions can you draw from your analysis of the two companies? Which company do you think is in a stronger financial position?
A 14-48 Using financial statement ratios to analyze Coca-Cola and PepsiCo (Learning Objectives 1, 2, 3, & 4) The Coca-Cola Company and PepsiCo, Inc., are fierce competitors in the beverage and snack markets. A perennial question among consumers is "Coke or Pepsi"? In this case, we will be looking at the financial positions of both companies to answer the question of which company is in a stronger financial position, Coke or Pepsi. Following is a table of various financial data and ratios for both Coca-Cola and PepsiCo. The data are arranged in alphabetic order.
Requirements
- Rearrange the data and ratios into a report format that groups similar data and ratios together, to make it easier to analyze the data.
- Using the given financial data for The Coca-Cola Company, discuss the company's:
- Ability to pay current liabilities.
- Ability to sell inventory and collect receivables.
- Ability to pay long-term debt; and
- Profitability.
- Using the given financial data for PepsiCo, Inc., discuss the company's:
- Ability to pay current liabilities.
- Ability to sell inventory and collect receivables;
- Ability to pay long-term debt; and
- Profitability.
- Now compare Coca-Cola's financial position to PepsiCo's financial position. How do the two companies compare in the following areas?
- Ability to pay current liabilities
- Ability to sell inventory and collect receivables
- Ability to pay long-term debt
- Profitability
- What conclusions can you draw from your analysis of the two companies? Which company do you think is in a stronger financial position?
|
|
2015 |
2014 |
2013 |
|
2015 |
2014 |
2013 |
|
Acid-test ratio |
0.58 |
0.56 |
0.62 |
|
0.68 |
0.48 |
0.54 |
|
|
1.24 |
1.02 |
1.13 |
|
1.31 |
1.14 |
1.24 |
|
Debt ratio |
0.71 |
0.67 |
0.63 |
|
0.83 |
0.75 |
0.69 |
|
Earnings per share |
1.69 |
1.62 |
1.94 |
|
3.71 |
4.31 |
4.37 |
|
Inventory turnover |
5.83 |
5.61 |
5.63 |
|
9.68 |
9.43 |
8.94 |
|
Net income (in $ millions) |
$ 7, 351 |
$ 7,098 |
$8,584 |
|
$ 5,452 |
$ 6,513 |
$ 6,740 |
|
|
16.60% |
15.43% |
18.32% |
|
8.65% |
9.77% |
10.15% |
|
Receivables turnover |
10.54 |
9.85 |
9.73 |
|
9.64 |
9.80 |
9.49 |
|
Return on assets |
9.01% |
8.33% |
10.27% |
|
9.16% |
10.03% |
10.06% |
|
Operating income percentage |
19.70% |
21.11% |
21.83% |
|
13.25% |
14.37% |
14.61% |
|
Revenue ($ millions) |
$ 44,294 |
$ 45,998 |
$ 46,854 |
|
$63,056 |
$ 66,683 |
$66,415 |
|
Times-interest-earned ratio |
10.20 |
20.10 |
22.09 |
|
8.61 |
10.54 |
10.65 |
|
|
$ 6,465 |
$ 612 |
$3,493 |
|
$5,453 |
$2,571 |
$4,364 |
Trending now
This is a popular solution!
Step by step
Solved in 5 steps
