Question
1) PepsiCo Coca-Cola Total Assets 69667 90093 Accounts (notes) Receivable 6437 13129 Net Revenues 63056 44294 Net Income 5501 7351 2. What conclusions concerning the
1)
| PepsiCo | Coca-Cola |
Total Assets | 69667 | 90093 |
Accounts (notes) Receivable | 6437 | 13129 |
Net Revenues | 63056 | 44294 |
Net Income | 5501 | 7351 |
2. What conclusions concerning the two companies can be drawn from the data you extracted in Question 1?
3)
| PepsiCo | Coca-Cola |
Net Increase (decrease) in PP&E | 927 Decrease | 2062 decrease |
Increase (decrease) in Selling, G&A Expenses | 1271 decrease | 791 decrease |
Increase (decrease) in LT Debt | 5392 increase | 9344 increase |
Increase (decrease) in N/I | 1057 decrease | 253 increase |
Increase (decrease) in Cash and Cash Equiv. | 2962 increase | 1649 decrease |
4. What conclusions concerning the two companies can be drawn from the data you extracted in Question 3?
5)
Total Current Assets | 23031 | 33395 |
Net amount of PP&E | 16317 | 12571 |
Total Current Liabilities | 17578 | 26930 |
Total Equity | 12030 | 25764 |
6. What conclusions concerning the companies' respective financial positions can be drawn from the data you extracted in Question 5?
7)
| PepsiCo | Coca-Cola |
Gross Profit 2015 | 34672 | 26812 |
Gross Profit Rate for 2015 | 34672/63056*100=54.99% | 26812/44294* 100 = 60.53% |
Operating Income for 2015 | 8353 | 8728 |
% Change in Operating Income from 2014 to 2015 | -12.82% | -10.02% |
8. What conclusions concerning the relative profitability of the two companies can you draw from the data you extracted in Question 7?
9)
| PepsiCo | Coca-Cola |
Inventory Turnover | 9.68 | 5.83 |
Average Days in Inventory | 37.71 | 62.61 |
10. What conclusions concerning the management of the inventory can you draw from the data you extracted in Question 9?
11)
| PepsiCo | Coca-Cola |
A/R Turnover | 9.64 | 10.54 |
Average Collection Period for A/R | 38 | 35 |
12. What conclusions about managing accounts receivable can you draw from the data you extracted in Question 11?
13)
| PepsiCo | Coca-Cola |
Asset Turnover | .9 | .49 |
14. What conclusions concerning the efficiency of assets can be drawn from the data you extracted in Question 13?
15)
| PepsiCo | Coca-Cola |
Largest Current Liability Account | 29213 | 13129 |
Total Current Liabilities | 57637 | 26930 |
Working Capital Value | 5453 | 6465 |
Current Ratio | 1.31 | 1.24 |
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