Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Financial Analysis Project Use the provided Financial Data (Excel file) for Coke and Pepsi to complete the following analysis: 1. Calculate the current ratio and

Financial Analysis Project

Use the provided Financial Data (Excel file) for Coke and Pepsi to complete the following analysis: 1. Calculate the current ratio and quick ratio for both companies for 2020 and 2021. Write a paragraph describing what these ratios indicate about the liquidity of each company in 2021 compared to 2020. Write a paragraph describing what these ratios indicate about the liquidity of Pepsi compared to Coke for both years. Which company seems to be more liquid? What are the advantages and disadvantages of liquidity? 2. Calculate the accounts receivable turnover and the average collection period for both companies for 2020 and 2021. Write a paragraph comparing 2021 with 2020 and Coke with Pepsi using these two ratios to indicate the effectiveness of their accounts receivable collections. Which of the two companies seem to be doing a better job with receivables? How does this collection process affect the overall success of the company? 3. Calculate the inventory turnover and the average sales period for both companies for 2020 and 2021. Write a paragraph comparing 2021 with 2020 and Coke with Pepsi using these two ratios to indicate how they manage their inventory. Which one of the two companies has a better approach to inventory management? Why? What are the problems that come with poor inventory management? 4. Calculate the gross margin percentage, net profit margin percentage, and return on assets for both companies for 2020 and 2021. Explain in a paragraph what these ratios show about each companys profitability compared to the year before and compared to each other. Indicate which company shows the best prospects for future profits and explain in detail why you think the ratios support your observations. 5. Prepare a vertical analysis on the income statement and the balance sheet for Pepsi and Coca Cola for 2020 and 2021. Write a paragraph highlighting what you have learned from the percentages of sales or total assets calculated from the financial statements. Write also about the comparison between 2020 and 2021 and between Coke and Pepsi. 6. Prepare a horizontal analysis on the income statement and the balance sheet for Pepsi and Coca Cola for 2020 and 2021. Be sure to calculate the change in dollars and percentages for all of the revenues and expenses. What do the changes indicate about Pepsis success in 2021 relative to 2020? Do the same comparison for Cokes income statement. What do the changes indicate about Cokes improvement or lack thereof between 2021 and 2020? With this comparison of both companies over time now compare Coke vs. Pepsi and explain why one company seems to do better than the other, financially speaking. 7. Based on all of your calculations and observations described above, make a recommendation as to which company would be a better investment. Give the reasons for your conclusion.

COCA-COLA 12 Months Ended
CONSOLIDATED STATEMENTS OF INCOME - USD ($) shares in Millions, $ in Millions 2021 2020 2019
Net Operating Revenues $ 38,655 $ 33,014 $ 37,266
Cost of goods sold 15,357 13,433 14,619
Gross Profit 23,298 19,581 22,647
Selling, general and administrative expenses 12,144 9,731 12,103
Other operating charges 846 853 458
Operating Income 10,308 8,997 10,086
Interest income 276 370 563
Interest expense 1,597 1,437 946
Equity income (loss) net 1,438 978 1,049
Other income (loss) net 2,000 841 34
Income Before Income Taxes 12,425 9,749 10,786
Income taxes 2,621 1,981 1,801
Consolidated Net Income 9,804 7,768 8,985
Less: Net income (loss) attributable to noncontrolling interests 33 21 65
Net Income Attributable to Shareowners of The Coca-Cola Company $ 9,771 $ 7,747 $ 8,920
Basic Net Income Per Share1 $ 2.26 $ 1.80 $ 2.09
Diluted Net Income Per Share1 $ 2.25 $ 1.79 $ 2.07
Average Shares Outstanding Basic 4,315 4,295 4,276
Effect of dilutive securities 25 28 38
Average Shares Outstanding Diluted 4,340 4,323 4,314

References/Works Cited. APA or MLA format:

Introduction (One to two paragraphs briefly introducing the assignment and what your work will be comprised of) Body (This is likely several pages answering ALL questions, show your work, explain your analysis) NOTE: If you use Excel for your calculations, copy/paste your work in this section where appropriate. Conclusion (One to two paragraphs summarizing your analysis and conclusions)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Outsourcing Dilemma Whats Best For Internal Auditing

Authors: Larry E. Rittenberg, Institute Of Internal Auditors Research Foundation, Lee A. Campbell

1st Edition

0894133845, 978-0894133848

More Books

Students also viewed these Accounting questions