Enterprise Ranking - Total Revenue
3
As shown in the table, PepsiCo, Inc. is the largest food & beverage business in the U.S with over USD60,000 million total revenue (2018). This makes the Company very interesting subject for this project since I wanted to gain insight on how the Company is able to maintain its competitive advantage.
3/49
Stock Price Comparison (Top 5 Players)
4
The above table shows the stock prices of the top 5 players in the food & beverage industry (PEP=PepsiCo; KO - Coca Cola; PM=Philip Morris; ADM= Archer Daniels; TSN= Tyson Foods). It can be seen the PepsiCo stocks are pretty much stable over the last 5 years as compared to the other top 5 players.
4/49
Enterprise Distribution
6
Food & Beverage and Tobacco industries come mostly from New York.
6/49
Typical Firm Performance by Region - Profit Distribution
7
The firms in Illinois are bigger than those in Arkansas, Georgia and New York in terms of median Revenue.
7/49
Concentration and Competition Intensity - Total Revenue
8
US Consumer F&B and Tobacco industry is heavily concentrated by competition. Few large firms dominate although the intensity of the competition is very high.
8/49
Industrial Trend - Industry Total Size
10
China still lags behind US F&B and Tobacco industries in terms of total revenue, total operating income, total net income and percentage of profitable enterprises. While this is the case, we can still see that China's trend for these metrics are upward compared to the US firms which is experiencing some decline.
10/49
Industrial Trend - Profitability
11
Typical company performance for US F&B and Tobacco firms is going up while for China, the trend seems to be relatively flat with some downward trends for median net margin.
11/49
Industrial Trend - Efficiency
12
US vs. China, 2018, F&B and Tobacco industry efficiency. China has a higher inventory days. Cash conversion cycle is around the same level. US has the higher asset turnover and return on assets. Overall, US has the better utilization.
12/49
Industrial Trend - Financial Health
13
US vs. China, 2018, F&B and Tobacco industry financial health. China has a better current ratio and liability-asset ratio, but US firms
13/49
Industrial Comparison - Profitability
15
Supply Chain: Capital Goods -> Transportation -> F&B Tobacco -> Food & Staples Retailing. Food & Staples retailing has the higher revenue but lowest operating and net margin and profitability among the 4 industries. F&B and Tobacco does not have high revenue but has a good operating and net margin as well as profitability.
15/49
Industrial Comparison - Growth
16
Capital goods has the better overall growth among the 4 industries.
16/49
Industrial Comparison - Efficiency
17
F&B and Tobacco has a good ROA, return on capital and productivity.
17/49
Revenue vs. Cost (US Firms)
19
PEP and ADM are the largest in terms of revenue, however, ADM has the highest cost among the industries. TSN is the third largest but the gap in terms of revenue and costs are much wider compared to PEP and ADM.
19/49
Revenue vs. Cost (US vs China)
20
US Firms have generally larger revenue and costs compared to China Firms.
20/49
Operating Income vs. Cost (US Firms)
21
PEP is both large and highly profitable. ADM and TSN are large but not profitable.
21/49
Operating Income vs. Cost (US vs China)
22
Generally, China company profits are way below their US counterparts except for GZMT which is small but considered highly profitable.
22/49
Operating Income vs. Total Assets (US Firms)
23
KHC is the largest in terms of asset, but operating profit/ asset < 10%. PM has the highest operating profit with lesser assets. PEP results are also good - high profitability.
23/49
Operating Income vs. Total Assets (US vs China)
24
Compared to US Firms, China firms generally have lower operating income and total assets. Exception is GZMT which has the highest operating income and assets among the Chinese Firms.
24/49
Operating Margin vs. Revenue
26
ADM has a very high revenue but very low profitability. PEP on the other hand has almost the same revenue but with significantly higher profitability. MO has the highest profitability but lower revenue.
26/49
Return on Assets vs. Liability Asset Ratio
27
PM has a good ROA but worst financial health. KHC on the other hand had the worst ROA but good financial health. PEP's ROA and financial health are generally good.
27/49
Enterprise Ranking - Total Revenue
29
PepsiCo, Inc. is ranked no. 1 in terms of total revenue in 2018 followed closely by Archer-Daniels-Midland Co.
29/49
Enterprise Ranking - Operating Margin
30
Altria Group is ranked no. 1 in terms of operating margin, whereas PepsiCo, Inc is ranked at No. 10.
30/49
Enterprise Ranking - Return on Assets
31
Monster Beverage has the highest return on asset (ranked no. 1). PepsiCo is ranked No. 3 in terms of ROA. Surprisingly, Kraft Heinz Co has a negative ROA and is ranked the last among the F&B and Tobacco companies in the US.
31/49
Profitability Distribution by Industry
32
Based on the above probability distribution matrix, the return on assets range from -0.1 to 0.3. Most of the F&B and Tobacco firms' ROA fall within the 2nd and 3rd quartiles.
32/49
Enterprise Comparison - Size
34
PepsiCo Inc. has a high gross profit, net income and total revenue among the top 5 players. It was the second highest in terms of operating income and profit before tax.
34/49
Enterprise Comparison - Profitability
35
PepsiCo Inc has the third highest margins (operating, net and gross margins). It has the second highest in terms of ROA.
35/49
Enterprise Comparison - Return on Investment
36
Based on the table, PepsiCo Inc has the very good overall return of investment among the top 5 competitors. It has the highest ROE while second highest in terms of ROC and ROA.
36/49
Enterprise Comparison - Key Indicators
37
PepsiCo Inc. has a good overall results in terms of key indicators. It has the highest in terms of return to equity, growth of total revenue and payable/receivable days ratio. It was the second in terms of ROA and inventory turnover ratio, while the third best in terms of liabilities asset ratio, net margin and gross margin.
37/49
KPI Examination
38
PepsiCo's rank in terms of profitability is High and it's Financial Health is assessed to be Normal. However, there's a mixed assessment in terms of PepsiCo's Growth and Operational Efficiency where it ranked High in Net Income while Low for Free Cash Flow (Growth). In terms of Operational Efficiency, the cost to total revenue was ranked high, however, inventory days and cash conversion cycle are ranked Low.
38/49
Enterprise Trend - Market Share
40
PepsiCo's total revenue and operating income trend are somewhat stable. Coca-Cola's revenue is declining, however, operating income has been increasing since 2018.
40/49
Enterprise Trend - Profitability
41
PepsiCo's gross and operating margins are somewhat stable. Net margin and ROA on the other hand had seen some increase in 2018. Overall, PepsiCo's profitability is good as it is within the top 3 among the competition.
41/49
Enterprise Trend - Financial Health
42
In terms of Financial Health, the trend is generally the same for all companies except for the current ratio of Archer Daniels which had shown an increase in 2018. PepsiCo's ratios are generally in line with competition.
42/49
Enterprise Trend - Financial Health
43
Inventory Days and Cash Conversion Cycle are generally stable for most companies except for Philip Morris which has seen a decline over the past few years. Archer-Daniels total revenue/number of employees has been decreasing compared to the other players which has been relatively stable.
43/49
Value Driver Analysis
45
A higher liability asset ratio may lead to higher operating margin
45/49
Value Driver Analysis
46
A higher liability asset ratio may lead to higher ROA ratio.
46/49
Enterprise Breakdown - Revenue
47
PepsiCo has the lower cost of revenue vs. industry and competition. However, it has one of the highest in terms of SG&A Expenses, Income Tax and Net Income.
47/49
Enterprise Breakdown - Liability-Equity
48
PepsiCo's total current and non-current liabilities are higher that industry average, while stockholders' equity are lower than industry average and the other 2 competitors shown in the table. This implies that PepsiCo's financial health is not good.
48/49
Enterprise Breakdown - Detailed Asset
49
22.65% of PepsiCo's total assets are invested in Property Plant and Equipment which is significantly higher than the industry average. It has high cash and cash equivalents which implies that PepsiCo is very very liquid.
49/49