Coca-Cola vs PepsiCo: Working Capital Analysis
Coca-Cola vs PepsiCo: Working Capital Analysis
net/publication/358022325
CITATIONS READS
0 1,465
8 authors, including:
Some of the authors of this publication are also working on these related projects:
Estimating causes of cyber crime: Evidence from panel data FGLS Estimator View project
All content following this page was uploaded by Haitham Nobanee on 22 January 2022.
Abrar Shikder, Yusuf Ahmed Abdi, Mohamed Dhaen Almehairi, Mahmoud Zourob, Abdullah Abuzahra,
Andrew Vaz, Marwan Ashraf Yehya
Supervised by:
Professor Haitham Nobanee
Abstract
This research paper is a comparative study that provides an in-depth financial analysis of the two
industry leaders in the beverage industry: The Coca-Cola Company and PepsiCo. The data for this
study was taken from the financial statements published on Yahoo Finance. The relevant data was
then used to compute, present and discuss the relevant financial ratios for the working capital
management, liquidity, profitability, leverage, and cash flows of the two aforementioned
companies and compares them to arrive at an accurate conclusion regarding their financial
performance over the last four years.
Introduction
The Coca-Cola Company, often referred to as simply ‘Coca-Cola’, is one of the world’s
largest manufacturing, retailing and marketing brands for non-alcoholic beverages. Founded in
1892 in Atlanta, Georgia in the United States, Coca-Cola have established the following vision
statement: “Our vision is to craft the brands 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.” (Purpose & Company
Vision, 2020) After rapid growth over the last century, Coca-Cola currently manufacture and
distribute over 2,800 original products across the globe in over 200 countries (Nganga, 2012).
PepsiCo, Inc., often referred to as PepsiCo, are Coca-Cola’s greatest industry rivals, and their
rivalry is considered among the fiercest across all industries. PepsiCo is also one of the world’s
largest non-alcoholic beverage companies, boasting an array of food and beverage products across
200 countries. Founded in 1965, PepsiCo’s vision is the following: “Be the global leader in
convenient foods and beverages by winning with purpose” (Mission and Vision, 2020).
These two industry leaders and their working capital management will be the subject of
our comparative study over the course of this research paper. Working capital management, in
essence, is the management of working capital done with the objective of maximizing operational
efficiency. Working capital is the difference between a company’s current assets and their current
liabilities, and it serves as an indicator of a company’s operating efficiency as well as their financial
stability. Working capital management, therefore, is considered to be fundamental for a company’s
success both in terms of financial performance as well as operational performance. Working
capital management ratios include the inventory period, receivables period, payables period,
operating cycle, cash conversion cycle and net trade cycle. By using these ratios to maximize
operational efficiency, a business will be able to not only operate more smoothly, but also perform
significantly better financially and competitively (Hawley, 2020). Knowing these benefits as well
as the intense rivalry between Coca-Cola and PepsiCo, it is expected that the findings of this study
will enable us to draw significant and interesting conclusions about the two powerhouses of the
beverage industry.
3
Literature Review
A study published by Fatima and Nobanee (2020) computed various financial data to get a
better understanding of PepsiCo performance after analyzing different ratios, to understand the
reason why people don’t invest in PepsiCo anymore. Hence, in this study they computed the data
of PepsiCo in four years using Yahoo Finance, measuring the ratios in long-term and short-term
firm’s capability. In the end, this study has shown that the main reason that prevents investors from
investing in PepsiCo is the decreases in the financial performance of the company in recent years
and the inefficiency in paying their debts also not utilizing all of the resources to make a profit.
In a similar study published by Nobanee along with Noor (2020), the financial performance
in four years of one of a well-known company that produces beverages all around the world known
as The Coca Cola Company was analyzed. This research focuses on computing different ratios to
analyze the financial state of Coca Cola Company to decide if the company performing is good or
bad in recent years. The results of this research indicate that Coca Cola organization has been
confronting liquidity issues during the previous three years as the current ratio, quick ratio, and
liquidity ratio have kept on declining. However, the organization expanded its usage of resources
to produce income from 2018 and 2019 when contrasted with earlier years, nonetheless, they
encountered a slight decline in effectiveness when gathering receivables. In the end, the Coca-Cola
Company is confronting liquidity and debt issues and most likely will at present be confronting
the issues in the future.
In a comparative study published by Sharma, the in-depth analysis of key financial ratios
of Coca-Cola and PepsiCo in India was used to assess the company's financial power, liquidity
conditions and operating performance. These financial ratios included liquidity ratios, activity
ratios, and profitability ratios. In terms of liquidity, Sharma found that the current ratio for PepsiCo
decreased between 2009 and 2011, before finally rising 2012. Coca-Cola recorded a higher current
ratio in 2010, 2011 and 2012. It was also found that Coca-Cola had a higher quick ratio in 2009
and 2012 due to having fewer liabilities, while PepsiCo recorded a higher quick ratio in 2010 and
2011 due to an increase in their current assets. The activity ratios also yielded mixed conclusions,
as PepsiCo only had a higher account receivable turnover ratio in 2009 and 2012 due to higher net
sales during those years. The inventory turnover generally favored Coca-Cola, as they recorded a
higher inventory turnover in every year except 2010. Finally, the profitability ratios conclusively
4
favored Coca-Cola, as they recorded a higher gross profit ratio and net profit ratio over PepsiCo
every year in the given time period of the comparative study.
For the purposes of this comparative study, we will collect the financial data for The Coca-Cola
Company and PepsiCo in order to calculate various financial ratios for our companies. This means
that our data collection is online secondary research. With this in mind, the following financial
data was collected from the data published in the income statements, balance sheets and cash flow
statements of each company on Yahoo Finance.
Coca-Cola
Item Year
2019 2018 2017 2016
Sales 37,266,000 31,856,000 35,410,000 41,863,000
PepsiCo
Item Year
2019 2018 2017 2016
Sales 67,161,000 64,661,000 63,525,000 62,799,000
Excel file with all ratio calculations and figures (double-click to access):
PepsiCo
Item Year
2019 2018 2017 2016
Inventory 3,338,000 3,128,000 2,947,000 2,723,000
COGS 30,132,000 29,381,000 28,785,000 28,209,000
DIO 35.23325889 37.36859475 38.85912665 40.43442188
Inventory Period
100
90
80
70
60
50
40
30
20
10
0
2019 2018 2017 2016
The inventory period, otherwise referred to as the Days of Inventory Outstanding (DIO), is a
measure of the average number of days that a company’s products are held in their inventory before
being sold to customers. It is desirable for a company to hold products in their inventory for short
periods of time, meaning that lower values for the inventory period are preferable. From the graph
above, it can be observed that PepsiCo consistently has a lower inventory period each year,
indicating that they are more efficient in selling their products to customers than their main
competitors Coca Cola. It should also be noted that both companies have lowered their inventory
periods considerably over the last couple of years.
PepsiCo
Item Year
2019 2018 2017 2016
Receivables 7,822,000 7,142,000 7,024,000 6,694,000
Sales 67,161,000 64,661,000 63,525,000 62,799,000
DSO 38.90682973 40.35828414 40.31533691 42.5102366
9
Receivable Period
45
40
35
30
25
20
15
10
5
0
2019 2018 2017 2016
The receivable period, also known as the Days of Sales Outstanding (DSO), measures the average
number of days required for the company to collect receivables from customers. It is favorable for
the company to have lower values for the receivable period, as it indicates greater liquidity due to
being able to convert receivables to cash quickly. In this regard, it is clear that Coca Cola
consistently possess a lower receivable period than PepsiCo. This suggests that Coca Cola are able
to collect their receivables more quickly than their main competitor.
PepsiCo
Item Year
2019 2018 2017 2016
Accounts Payables 8,013,000 7,213,000 6,727,000 6,158,000
COGS 30,132,000 29,381,000 28,785,000 28,209,000
DPO 79.6791804 85.29980893 89.60705898 97.06441657
10
Payables Period
120
100
80
60
40
20
0
2019 2018 2017 2016
The payables period, also known as the Days of Payables Outstanding (DSO), is a ratio that
measures the average number of days a company takes to pay their suppliers. It is preferable for
companies to have a higher payables period, as this would indicate that the company is able to
hold their cash for longer before paying their suppliers. In this regard, PepsiCo consistently
outperforms Coca Cola by recording higher DSO values than their competitors every year between
2016 and 2019. This means that PepsiCo are able to hold their cash for longer periods than Coca
Cola, which puts them in a better position to spend their cash in other areas.
PepsiCo
Item Year
2016 2017 2018 2019
DSO 38.90682973 40.35828414 40.31533691 42.5102366
11
Operating Cycle
140
120
100
80
60
40
20
0
2019 2018 2017 2016
The operating cycle is a ratio that measures a company’s efficiency in their process of producing
products, selling them to customers, and finally collecting their receivables in the form of cash. A
lower value for the operating cycle indicates greater efficiency in this repetitive process as well as
superior working capital management. From the figure above, it can be observed that PepsiCo
consistently has lower and more favorable values for their operating cycle in comparison to Coca
Cola. Furthermore, while Coca Cola experienced an increase in their operating cycle from 2016 to
2017, PepsiCo has been able to consistently lower their operating cycle every year over the last
four years.
PepsiCo
Item Year
2016 2017 2018 2019
DSO 38.90682973 40.35828414 40.31533691 42.5102366
DIO 35.23325889 37.36859475 38.85912665 40.43442188
DPO 79.6791804 85.29980893 89.60705898 97.06441657
Cash Conversion -5.539091788 -7.572930034 -10.43259543 -14.11975809
Cycle
The cash conversion cycle is a ratio that measures how efficiently a company is able to convert its
inventory into sales and subsequently into cash. The cash conversion cycle is comprised of adding
together the DSO and DIO before subtracting the DPO. Since it is favorable to have lower values
of DSO and DIO, and conversely favorable to have higher values of DPO, it is clear that lower
values for the cash conversion cycle are favorable for a company. From the above figure, it can be
interpreted that PepsiCo not only has lower cash conversion cycle values than Coca Cola every
year, but also that their values are negative. This means that PepsiCo is able to convert their
inventory into sales and then into cash much more efficiently than their industry rival. However,
it should be noted that over the last couple of years, PepsiCo’s cash conversion cycle has been
increasing (from -7.57 in 2018 to -5.539 in 2019), whereas Coca Cola has drastically lowered their
cash conversion cycle over the same period from 47.9 to 33.46.
13
PepsiCo
Item Year
2016 2017 2018 2019
Net Trade Cycle 18.94194175 18.63927588 17.25622864 17.10300621
The net trade cycle is a working capital management ratio that indicates how long it takes for a
company’s cash inputs to go through their trade cycle and come back as cash again. Therefore, it
is favorable to have lower values for the net trade cycle. From the figure above, it can be seen that
PepsiCo possesses a much lower net trade cycle compared to Coca Cola. This indicates that
PepsiCo’s cash inputs spend a shorter amount of time in their trade cycle and comes back into the
company as cash more quickly than Coca Cola. However, it should be noted that PepsiCo’s net
14
trade cycle has been continually increasing since 2016, whereas Coca Cola has been lowering their
net trade cycle every year since 2017.
Liquidity Ratios
Coca-Cola
Item Year
2016 2017 2018 2019
Current Ratio 1.281848334 1.343862617 1.048283886 0.756719683
Quick Ratio 1.181026685 1.246230786 0.953632413 0.631446261
Cash Ratio 0.836763154 0.760278003 0.546282038 0.414303192
PepsiCo
Item Year
2016 2017 2018 2019
Current Ratio 1.281712799 1.51336455 0.988933056 0.862372318
The current ratio measures a company’s ability to meet short-term obligations with its current
assets. Coca Cola has a superior current ratio in 2016 and 2018, but PepsiCo was superior in 2017
and 2019. The quick ratio indicates a company’s ability to cover its current liabilities using its
liquid assets. Coca Cola had a more favorable quick ratio in 2016 and 2018, but PepsiCo was
superior in this regard in 2017 and 2019, although both have decreased considerably since 2017.
Coca Cola consistently has a superior cash ratio, meaning they have a greater ability to pay off
short-term liabilities than PepsiCo (Hayes, 2020).
PepsiCo
Item Year
2016 2017 2018 2019
Debt Ratio 0.84892552 0.86240038 0.81194622 0.81071206
The debt ratio measures the degree to which a company finances its assets using debt. PepsiCo
consistently has a higher debt ratio each year, meaning that they are more reliant on debt. The debt-
to-equity ratio represents a company’s financial leverage in terms of the degree to which debt and
equity is financing its assets. PepsiCo has a higher debt ratio, meaning they rely more debt and
equity to finance their assets. The long-term debt to equity ratio that measures a company’s a long-
term debt against the shareholders’ equity. PepsiCo is higher in this area each year. This suggests
the PepsiCo is generally riskier than Coca Cola.
Profitability Ratios
Coca-Cola
Item Year
2016 2017 2018 2019
Return on Equity 0.281093885 0.065763819 0.337601007 0.42278889
Return on Total 0.074790879 0.014198598 0.077316862 0.103263449
Assets
Profit Margin 0.155913336 0.035244281 0.201971371 0.239360275
PepsiCo
16
Item Year
2016 2017 2018 2019
Return on Equity 0.565139745 0.442309444 0.857074373 0.491928975
The return on equity ratio demonstrates a company’s ability to generate revenue from its equity
investments. PepsiCo is higher each year in this regard, meaning that their investments yield more
returns compared to Coca Cola. The return on total assets ratio indicates the profitability of a
company’s assets. PepsiCo is superior in 2016, 2017, and 2018, but falls short to Coca Cola in
2019. The profit margin is a general measure of profitability (Kenton, 2020). PepsiCo had a higher
profit margin in 2016 and 2017 but fell short to Coca Cola over the last two years.
PepsiCo
Item Year
2016 2017 2018 2019
Operating Income 0.873738727 0.957016665 0.692370908 0.692157654
to Equity
Operating Income 0.131999622 0.131685129 0.130202967 0.131017098
to Total Assets
17
The operating income to equity and operating income to total assets measure a company’s returns
against its equity and total assets respectively, thus being a measure of operational profitability.
PepsiCo recorded higher values in these areas over the last four years. The operating income to
sales ratio is the degree to which sales contribute to income. Coca Cola is higher in this regard,
meaning that their sales have a greater contribution to their operating income when compared to
PepsiCo.
PepsiCo
Item Year
2016 2017 2018 2019
OCF/Total Assets 0.140349931 0.125231818 0.121252318 0.122843648
The operating cash flow to total assets ratio is a cash flow ratio that “measures the amount of
operating cash flow you generate for every dollar of assets you own. The higher the ratio, the more
efficiently you use your assets.” (Keythman, 2017). Therefore, based on the above figures, it can
be interpreted that PepsiCo generates a greater operating cash flow for every dollar of assets owned
by PepsiCo, as they boast a greater operating cash flow to total assets ratio every year over the
course of the given time period. On the other hand, Coca-Cola has recorded a greater operating
cash flow to sales ratio every year since 2016. This means that Coca-Cola has a superior ability to
turn its sales into liquid cash.
18
Conclusion
Based on our findings over the course of this project, several comparative conclusions can
be drawn regarding the working capital management, liquidity, leverage, profitability and cash
flows of Coca-Cola and PepsiCo. Firstly, it can be reasonably concluded based on the working
capital management ratios that PepsiCo has more efficient working capital management. PepsiCo
recorded a lower inventory period, operating cycle, cash conversion cycle and net trade cycle while
also possessing a greater payables period. Coca-Cola only edged PepsiCo in its receivable period,
where Coca-Cola had a lower a DSO over their industry rivals.
The liquidity ratios yielded mixed results, mainly due to the fact that while Coca-Cola
boasted a superior current ratio and quick ratio in 2016 and 2018, PepsiCo were superior in 2017
and 2019. However, Coca-Cola consistently had a greater cash ratio, meaning that they possessed
a greater ability to pay off short-term liabilities over PepsiCo (Al Ghanem et al. 2021).
The debt ratios on the other hand depicted a clear winner, as Coca-Cola was found to
possess a lower debt ratio, debt-to-equity ratio and long-term debt to equity ratio than PepsiCo. It
was thus clear that PepsiCo was not only significantly more reliant on debt than Coca-Cola, but
also that they were riskier, as indicated by their long-term debt to equity ratio (Alali et al. 2021).
The profitability and operational profitability ratios also resulted in mixed conclusions.
PepsiCo recorded a higher return on equity every year between 2016 and 2019, and also recorded
greater return on total assets ratios in every year apart from 2019, thereby suggesting that PepsiCo
generally tends to yield greater returns from their equity and total assets in comparison to Coca-
Cola. PepsiCo also had a greater profit margin in 2016 as well as 2017, but Coca-Cola
outperformed them in this regard during the last two years. Furthermore, PepsiCo also recorded
greater values for their operating income to equity and operating income to total asset ratios for
each of the last four years, indicating that PepsiCo is likely to be a better investment. On the other
hand, Coca-Cola recorded higher values for their operating income to sales ratio each year,
indicating that their sales have a greater contribution to their operating income.
Finally, the two cash flow ratios that were used in this study showed mixed results, which
each company dominating one ratio each over the last four years. PepsiCo recorded a greater
operating cash flow to assets ratio, meaning that they generated more cash for every dollar of their
assets. However, Coca-Cola recorded higher values for the operating cash to sales ratio, indicating
that they are able to turn their sales into cash more efficiently (Alhosnai et al. 2021).
19
References
Coca-Cola Company Financial Statements. (2020, November 12). Retrieved November 08, 2020,
from https://finance.yahoo.com/quote/KO/financials?p=KO
COMPANY: https://investors.coca-colacompany.com/about
Hawley, J. (2020, September 16). Why Working Capital Management Matters. Retrieved
November 06, 2020, from https://www.investopedia.com/ask/answers/100715/why-
working-capital-management-important-company.asp
Al Ghanem, Khuloud and Al Qubaisi, Nashwa and Al Zaabi, Hidayah and Al Dhahmani, Latifa
and Al Naqbi, Ahood and Al Dhanhani, Hind and Al Shamisi, Fatima and Nobanee,
Alali, Easa and Alhammadi, Nouf and Almarar, Mai Saif and Almheiri, Shamsa and Almarar,
Fatima and Almarar, Moza and Alremaithi, Latifa Khamis and Nobanee, Haitham,
Financial Analysis and Performance Evaluation of Moderna (July 30, 2021). Available at
Alhosnai, Khalifa and Kharbanda, Kaushang and Almazrouei, Hessa Saeed and Alzaabi, Asma
Ibrahim and Aldhanhani, Wafaa and Mostafa, Souhail and Alhajiri, Shaima Mohamed
and Nobanee, Haitham, Financial Analysis of Johnson & Johnson in Light of the
Hayes, A. (2020, August 29). What Everyone Needs to Know About Liquidity Ratios. Retrieved
November 09, 2020, from https://www.investopedia.com/terms/l/liquidityratios.asp
Kenton, W. (2020, October 11). The Importance of Profitability Ratios. Retrieved November 09,
2020, from https://www.investopedia.com/terms/p/profitabilityratios.asp
Keythman, B. (2017, November 21). Operating Cash Flow to Total Assets. Retrieved November
08, 2020, from https://smallbusiness.chron.com/operating-cash-flow-total-assets-
73468.html
Nobanee, H., & Fatima, M. (2020, July). Ratio Analysis of PepsiCo. Retrieved November 08,
2020, from
https://www.researchgate.net/publication/342703129_Ratio_Analysis_of_PepsiCo
Nobanee, H., & Noor, H. (2020, July 05). (PDF) Financial Analysis of Coca Cola Company.
Retrieved November 08, 2020, from
https://www.researchgate.net/publication/342703132_Financial_Analysis_of_Coca_Cola_
Company
Operating Cash Flow to Sales Ratio. (n.d.). Retrieved November 12, 2020, from
https://www.readyratios.com/reference/cashflow/operating_cash_flow_sales_ratio.html
Pepsico, Inc. (PEP) Stock Price, News, Quote & History. (2020, November 12). Retrieved
November 08, 2020, from https://finance.yahoo.com/quote/PEP?.tsrc=applewf
Purpose & Company Vision: The Coca-Cola Company. (n.d.). Retrieved November 06, 2020,
from https://www.coca-colacompany.com/company/purpose-and-vision
21