Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Please see files attached. Instructions are in red font, toward the end, on the word document.

1 answer below »
Pandemic’s Impact on Coca-Cola
A Financial Statement Analysis Case

The Situation
The year 2020 will always be remembered as the year when an unexpected pandemic immobilized the world. The COVID-19 pandemic is an infectious disease that is exceedingly contagious (Centers for Disease Control, XXXXXXXXXXCOVID-19 was first found in Wuhan, China, at the end of 2019, and in the next few months, it had already spread worldwide. The World Health Organization (WHO) officially declared COVID-19 a pandemic on March 11, 2020 (World Health Organization, XXXXXXXXXXSince then, there has been a total of over 53 million cases and 820 thousand deaths in the United States alone (Centers for Disease Control, 2021b).
In response to the pandemic, there has been a worldwide shutdown that impacted all areas of life. The U.S. Bureau of Labor Statistics reported that the Pandemic shutdown caused about 56% of businesses to face reduced demand for their products or services (Bureau of Labor Statistics, XXXXXXXXXXThe Coca-Cola Company is a global beverage business that distributes its product in multiple ways, including grocery stores, restaurants, movie theaters, and amusement parks (The Coca-Cola Company, 2022c). Many of these channels were closed due to Covid-19. The Stock Price for Coca-Cola fell sharply at the beginning of the Pandemic as seen in Figure 1.

Figure 1: Coca-Cola Stock Price
0
10
20
30
40
50
60
70
2/2018
1
3
2/2018
5
2/2018
2/2018
7
2/2018
9
11
2/2018
1
2/2019
3
2/2019
5
2/2019
7
2/2019
2/2019
9
11
2/2019
1
2/2020
3
2/2020
5
2/2020
7
2/2020
9
2/2020
11
2/2020
Stock Price in USD
Date
Source: Yahoo!Finance

Coca-Cola's cu
ent Chief Executive Officer and Chairman of the board, James Quincey, would like to know how the company faired financially (The Coca-Cola Company, 2022a). Prepare a report of the COVID-19 pandemic's impact on Coca-Cola and any recommendations on facing some common challenges plaguing many beverage companies.
Introduction to Coca Cola
The first Coca-Cola was sold back on May 8, 1886, by Dr. John Pemberton in his Pharmacy, Jacobs's Pharmacy, for five cents a glass (The Coca-Cola Company, 2022b).
Originally, Coca-Cola was made using coca leaf and kola nut, which inspired the name (Britannica, XXXXXXXXXXPemberton marketed his drink as a remedy for common illnesses. Before passing away, Pemberton sold a majority of his business to another pharmacist Asa Candler, who then incorporated Coca-Cola in 1892.

When Coca-Cola was first invented, about nine glasses were sold per day; by 1900 Coca Cola extended to every state (The Coca-Cola Company, 2022d). While distribution was done through fountain drinks only, in 1899, Coca-Cola negotiated with a bottling company which helped increase popularity and distribution. Coca-Cola's mission statement "is to craft the
ands and choice of drinks that people love, to refresh them in body & spirit. And done in ways that create a more sustainable business and better-shared future that makes a difference in people's lives, communities, and our planet (The Coca-Cola Company, 2022e)."
Today, the Coca-Cola Company has about 200 different
ands sold in over 200 countries with more than 1.9 billion servings a day. Other than their flagship
and, Coca-Cola, they also sell other Sparkling flavors (such as Sprite and Fanta); Nutrition, Juice, Dairy and Plant drinks (such as the Simply
and and Minute Maid); and Hydration, Sports, Tea, and Coffee drinks (such as SmartWater, Powerade, FuzeTea, and Costa Coffee). They are ever-changing and growing their beverage portfolio by discontinuing
ands that are not in demand and identifying product opportunities to fill in the gap. For example, in 2020, they launched their new product AHA, sparkling water with eight different flavors. They have also


Beverage Industry
Coca-Cola belongs to the non-alcoholic beverage industry, including ca
onated and nonca
onated soft drinks, bottled water, and ice (First Research, XXXXXXXXXXIn the Non-Alcoholic beverage, most of the revenue comes from soft drink sales (86%), as shown in Figure 2. Soft drinks are not only ca
onated soft drinks (CSD) but also include sports and energy drinks, ca
onated water, tea, and coffee drinks.

Figure 2: Revenue of Non-Alcoholic Beverage by segment, 2019
Soft Drinks
86
%
Bottled
Wate
12
%
Ice
2
%
         Source(s): First Research Industry Profile
First Research classifies the non-alcoholic beverage industry with low growth ratings because of the many challenges that limit its growth. Since geographical regions and different demographics vary in consumer taste, providing a product with high demand can prove challenging. Beverage companies also have significant expenses; the average soft drink manufacturers have a gross margin of about 30% of net revenue. Beverage companies have a high cost for manufacturing their product. Many material costs are expansive and can vary from time to time. High marketing spending is also required to promote the
and and product.
Another challenge that the beverage industry faces, specifically the soft drink industry, is health and obesity concerns. Many health groups blame soda companies like Coca-Cola for contributing to the "obesity pandemic" in the United States. There have been calls to remove products in the school cafeteria in order to limit children's high sugar and calorie intake. Even sales for diet sodas have taken a hit. Even bottled water companies receive backlash from environmentalists and face lawsuits for their overuse of many communities' natural spring water.
According to Statista (2021), in 2020, the non-alcoholic beverage industry earned a revenue of 1.038 trillion U.S. dollars, as shown in Figure 3. The industry receives its most significant share of revenue from the United States. It is estimated that the U.S. consumes about 145 billion liters of non-alcoholic beverages. Although this was a drop of 7.7% from the previous year, sales are expected to recover and continue to increase in the upcoming years.

Figure 3: Worldwide non-alcoholic beverage market revenue from 2012 to 2025 (in million U.S. dollars)
0
200,000
400,000
600,000
800,000
1,000,000
1,200,000
1,400,000
1,600,000
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
Sales in million U.S. dollars
Source(s): Statista; Statista Consumer Market Outlook
In terms of volume growth by different segments, there is an immediate rebound in 2021 after the pandemic, as seen in Figure 4. In the upcoming years, there seems to be a positive average growth of 2% across beverage segments. This positive outlook on the non-alcoholic beverage industry may be due to the number of opportunities presented to companies to innovate on their product.

Figure 4: Non-Alcoholic Beverage Market Volume Growth Worldwide from 2013 to 2026, by segment

-6
%
-4
%
%
-2
0
%
2
%
4
%
%
6
%
8
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
Volume change
Bottled Wate
Soft Drinks
Juices
Source(s): Statista; Statista Consumer Market Outlook
First Research XXXXXXXXXXhas identified opportunities such as ready-to-drink tea and coffees, creating healthy alternatives, taking advantage of emerging markets like Latin America, and Ecommerce sales. Many companies are already tackling some of the challenges and accusations they face. They are veering towards more healthy drinking options such as sparkling water and using all-natural sweeteners. Many
ands promote business sustainability and packaging their product in more environmentally friendly, recyclable material.
In terms of sales, Anheuser-Busch is the leading beverage company with about 46 billion U.S. dollars in sales, as shown in figure 5 (Statista, XXXXXXXXXXWith multiple mergers and acquisitions, Anheuser-Busch's portfolio holds over 405 of the beer market in the United States.

Figure 5: Leading Beverage Companies Worldwide in 2020, based on sales
0
10000
20000
30000
40000
50000
Anheuser-Busch InBev
Nestlé SA
The Coca-Cola Co.
PepsiCo Inc.
Heineken N.V.
Suntory Holdings Ltd.
Sta
ucks Corp.
Diageo PLC
Keurig Dr Peppe
Molson Coors Brewing Co.
Beverage Companies Sales
         Source(s): Statista; Beverage Industry Magazine
Although Coca-Cola sits in third place of leading beverage companies with a sale of over 33 billion U.S. dollars, they are first for
and value in the non-alcoholic beverage
and industry. According to Statista, Coca-Cola's
and value is over 33 billion. This by far surpasses their next competitor Pepsico who has a
and value of 18 billion. Coca-Cola also outspends Pepsico in advertising its product. Coca-Cola has a majority share of the United States CSD market with about 45 percent, while PepsiCo has about 26 percent and Keurig Dr. Pepper about 21 percent.
Figure 6: Most Valuable Non-Alcoholic beverage
ands of 2020 (in million U.S. dollars)
0
5,000
10,000
15,000
20,000
25,000
30,000
35,000
Coca-Cola
Pepsi
Red Bull
Nescafé
Monste
Sprite
Gatorade
Dr. Peppe
Mountain Dew
Lipton
Source(s): Statista, Brand Finance

Coca-Cola’s response to COVID-19
The COVID-19 Pandemic affected most businesses around the world, including Coca-Cola.
Coca-Cola responded by supporting their stakeholders in the following ways:
· Protect employees by allowing office employees to work from home and install all necessary and recommended safeguards in the production and distribution facilities.
· Working with suppliers to make sure demands were met. They also accelerated 1billion dollars in payment to aid suppliers during the crisis.
· Helping customers receive their product with limited contact delivery and boosting up ecommerce. They also rolled out their innovative touch-free fountain dispenser, allowing consumers to choose which Coca-Cola product they wished without contact.
· Support communities by making large donations and producing hand sanitizer and personal protective equipment for first responders and healthcare workers.

Discussion Questions
Financial statement is provided in Exhibits 1 and 2 for the last 3 years. The industry averages can be found in Exhibit 3.
Provide a summary of the issue that Coca-Cola face. Prepare a 3-5-pages report that analyzes the financial condition of Coca-Cola. Included in the memo should be a section describing the company’s liquidity, asset management, debt management, profitability, market value and your recommendations to Coca-Cola. Make sure that you include the heading of each section in your report. Also include the following financial exhibits in excel:
o Vertical (common size) analysis of income statement and balance sheet o Horizontal (percent-change) analysis of income statement and balance sheet o Complete Ratio Analysis (for all 3 years) and Industry comparison. For each area, the students need to determine if the pandemic and strategic changes made have resulted in an improved and worsening financial position for the company.
Answered 8 days After May 25, 2022

Solution

Prateek answered on May 30 2022
99 Votes
Issue faced by Coca Cola
Coca-Cola, a soft drink manufacturing company is a widely known
and across the globe. The company has been the face of soft drinks for a period more than one could imagine. With times and economic tu
ulences, this company also gets affected by these unprecedented times. This, as a result, has affected the growth of the company to a large extent. Even though, the overall revenue has increased over the past years, yet given the demand and supply dynamics and the effect of the pandemic, there has been a manufacturing cut in the production of soft drinks. With nation-wide lockdowns in major economies, the manufacturing and thus, the supply of soft drinks shrank dramatically. There were no logistics available, shortage of daily wage workers, increased fuel costs, among others have affected the topline. All these issues can be seen in the company’s financial statements wherein the sales declined by approx. 11% in 2020 compared to the sales revenue in 2019. This hit can also be seen in the net income of the company which declined to $7,768 million in 2020 from a high of $8,985 million in 2019.
Company Analysis
The following table shows the common size income statement for Coca-Cola:
    Common Size Income Statement
    (In Millions)
    2020
    2019
    2018
    Sales
    100.00%
    100.00%
    100.00%
    Cost of goods sold
    40.69%
    39.23%
    38.10%
    Gross Profit
    59.31%
    60.77%
    61.90%
    Selling, and administrative expenses
    29.48%
    32.48%
    32.08%
    Other operating expenses
    2.58%
    1.23%
    3.15%
    Operating Income (EBIT)
    27.25%
    27.06%
    26.68%
    Non-operating income (loss)
    6.63%
    4.42%
    0.07%
    Interest Expense
    4.35%
    2.54%
    2.77%
    Earnings before taxes (taxable income)
    29.53%
    28.94%
    23.98%
    Income Taxes
    6.00%
    4.83%
    5.10%
    Net income
    23.53%
    24.11%
    18.88%
Here, it can be seen that the net income margin has declined to 23.53% from a high of 24.11%. However, the EBIT margin has remained constant. This could be due to the fact that the company already has manufacturing units in most of the countries in which it operates, but the affect could be seen on an absolute basis.
Vertical Analysis
The following table presents the common size balance of Coca-Cola:
    Common Size Balance Sheet
    Assets
    2020
    2019
    2018
    Cash and cash equivalents
    7.78%
    7.50%
    10.91%
    Short-term investment
    4.72%
    5.44%
    8.46%
    Accounts receivable
    3.60%
    4.60%
    4.43%
    Inventories
    3.74%
    3.91%
    3.69%
    Prepaid expenses and other cu
ent assets
    2.19%
    2.18%
    2.47%
    Total Cu
ent Assets
    22.04%
    23.63%
    29.96%
    Gross plant and equipment
    22.57%
    21.90%
    21.16%
    Less accumulated depreciation
    10.22%
    9.36%
    9.63%
    Net plant and equipment
    12.35%
    12.55%
    11.53%
    Goodwill and other intangible assets
    32.70%
    30.99%
    25.94%
    Other Assets
    32.91%
    32.84%
    32.57%
    Total Assets
    100.00%
    100.00%
    100.00%
     
     
     
     
    Liabilities and Equity
    2020
    2019
    2018
    Accounts Payable
    4.03%
    4.40%
    3.27%
    Accrued Liabilities
    0.70%
    1.18%
    1.54%
    Short-term Notes
    3.43%
    17.98%
    22.64%
    Other Cu
ent Liabilities
    8.57%
    7.66%
    7.14%
    Total Cu
ent liabilities
    16.73%
    31.23%
    34.59%
    Long-term Debt
    45.96%
    31.85%
    30.49%
    Other Liabilities
    10.83%
    9.85%
    9.19%
    Defe
ed income tax liability
    2.10%
    2.64%
    2.83%
    Total Liabilities
    75.62%
    75.58%
    77.10%
    Stockholders' Equity:
     
     
     
    Common Stock
    2.02%
    2.04%
    2.11%
    Paid-in capital
    20.16%
    19.86%
    19.85%
    Retained earnings
    76.24%
    76.24%
    75.99%
    Treasury Stock
    -59.59%
    -60.48%
    -62.15%
    Other Equity
    -16.73%
    -15.68%
    -15.40%
    Minority Interest
    2.27%
    2.45%
    2.50%
    Total...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here