Monday, March 15, 2021

PepsiCo Valuation Part 2: Revenues and Operating Margins by Segment

PepsiCo operates seven divisions, divided by product category in North America, and by geographic region outside North America. The company formerly operated six divisions. The table attempts to show the structure both before and after the reorganization in 2019.

Revenue by Division, GAAP
in millions of US$
2014201520162017201820192020
FLNA14,50214,78215,54915,79816,34617,08218,277
QFNA2,5682,5432,5642,5032,4652,4902,739
NAB20,17120,61821,31220,93621,072
PBNA21,70422,572
LatAm9,4258,2286,8207,2087,3547,5756,969
ESSA13,39910,51010,21611,05011,523
Europe12,33012,576
AMENA6,6186,3756,3386,0305,9015,9817,239
AMESA??
APAC??
source'16 AR'16 AR'16 AR'18 AR'18 AR'19 AR'20 10K
total66,68363,05662,79963,52564,66167,16170,372

Revenue Changes
'19 chg'20 chg
FLNA4.5%7%
QFNA1%10%
NAB
PBNA3%4%
LatAm3%-8%
ESSA
Europe7%2%
AMENA
AMESA0%25%
APAC4.5%18%

Frito-Lay is clearly the star division, growing revenues every year and by a significant amount. Over six years FLNA revenue has grown 26%, for a CAGR of 3.93%. Every other division has had challenges at some point, including the namesake soft drink and beverage business in the U.S. Nevertheless, the other divisions are not struggling like some of the other large name brand packaged foods companies.

In years prior to 2019, the Division Review section of the PepsiCo's annual report broke out revenue, GAAP operating profit, and non-GAAP operating profit, along with adjustments and special one-time charges by division. Starting in 4Q19 PepsiCo appears to have ceased reporting revenues by Division, publishing only year-over-year net changes in the revenue. The numbers for 2019 are calculated using the percentage changes shown in the 2019 annual report from the 2018 revenues reported in the 2018 annual report, but these numbers may not match PepsiCo's internal figures. 

The 2020 10K appears to use the same structure used in the 2019 10K, meaning that revenues by Division are not available for 2020 either, and the 10K does not provide more detailed information than the annual report. Therefore 2020 revenues by division are also calculated by extrapolation: the 2019 extrapolated division revenue and the 2020 revenue change figures are used to calculate the 2020 division revenues. Red shaded cells indicate extrapolated figures. Since we don't have base 2018 figures for APAC, and we don't know how AMENA may have contributed to the definition of APAC, we don't have revenue figures for AMESA or APAC in FY19 or FY20. The back-calculated totals are shown in italics on the AMENA line for '19 and '20. These should be correct, but based on what we get from the published reports, we can only be 85% sure.

Operating Profit by Division, GAAP
in millions of US$
2014201520162017201820192020
FLNA4,0544,3044,6594,7935,0085,2585,340
QFNA621560653640637544669
NAB2,4212,7852,9592,7002,276
PBNA2,1791,937
LatAm1,636-206887*9241,0491,1411,033
ESSA1,3891,0811,108a1,199b1,256c
Europe1,3271,353
AMENA9819416191,0731,172
AMESA789661671600
APAC401619477590
source'16 AR'16 AR'16 AR'18 AR'18 AR'19 AR'20 10K
total11,1029,4658,89011,32011,42211,59711,522
* revised to 904 in the FY18 AR
a revised up from 1,061 in FY18 AR to 1,108 in FY19 AR
b revised down from 1,316 in FY18 AR to 1,199 in FY19 AR
c revised down from 1,364 in FY18 AR to 1,256 in FY19 AR
AMESA and APAC op profit figures for FY 17, 18, 19
are from the FY19 AR

Looking at GAAP operating profits, which include special adjustments such as currency exchange, discontinued operations, restructuring, impairment charges, mark-to-market, and merger charges, FLNA is still the clear star of the portfolio. Total operating profit grew 31.7%, for a CAGR of 4.7%. In contrast, PBNA (NAB) is seeing dwindling profits as the U.S. retreats from soda pop. Quaker (QFNA) is only holding its own, but it is dwarfed by Frito-Lay, which is generating profits nearly ten times the size of Quaker's. FLNA generates half of PEP's operating profits.

Computing operating margins by division, it's clear that PEP's prospects are driven by the growth of Frito-Lay and its profitability. QFNA is also reasonably profitable, but even if it were growing rapidly, its contribution would still be small relative to FLNA.

Operating Margin by Division, Calculated
2014201520162017201820192020
FLNA28.0%29.1%30.0%30.3%30.6%30.8%29.2%
QFNA24.2%22.0%25.5%25.6%25.8%21.9%24.4%
NAB12.0%13.5%13.9%12.9%10.8%
PBNA10.0%8.6%
LatAm17.4%-2.5%13.0%12.8%14.3%15.1%14.8%
ESSA10.4%10.3%10.8%10.9%10.9%
Europe10.8%10.8%
AMENA14.8%14.8%9.8%17.8%19.9%
AMESAunk.unk.
APACunk.unk.

FLNA maintains 30% margins consistently, QFNA is less consistent but still manages average margins of 24%. The rest of the divisions manage about 12% operating margins, which is not quite adequate for a world-class food business.

Since we don't have reliable revenue figures for AMESA and APAC, we've skipped computing operating margins for those segments, but they are probably similar to the margins of the other regional segments.

Investment Valuation

Does any of this new information change the valuation we computed in part 1? Probably not. FLNA is stable, and although the other segments are not stellar performers, they have room for improvement. The other regional businesses have the potential to grow their snack businesses into a shape that resembles the success of FLNA, with greatly improved sales growth and operating margins. PEP can even suffer a few more years of sluggish beverage sales in PBNA, and still not see any substantial change to the overall cash generation of the business.

Potential obstacles:

  • Activist investors attempt to break up the company, which then hinders the economy of scale of the regional businesses and makes it more difficult for snacks and beverages to growth in Latin America, Europe, and Asia.
  • Large acquisitions that soak up capital or diminish FLNA by taking management attention away from organic growth of snacks in overseas markets.
  • Excess diversification in food products. Quaker doesn't seem to have injured PEP, but other attempts to gain revenue through expensive acquisitions could be problematic.
  • Excess worldwide diversification. Does PepsiCo focus on doing the right thing in each country market? Does it build product integrity, or does it just fling its products into markets hoping that some will stick?

Reference: Division Alignments

PepsiCo divisions were realigned in 2019. This action appears to have created a new division, APAC, and resulted in the renaming of several others. The company calls these reportable segments and describes them as follows:

  1. FLNA: branded food and snack businesses in the United States and Canada;
  2. QFNA: cereal, rice, pasta and other branded food businesses in the United States and Canada;
  3. PBNA: beverage businesses in the United States and Canada;
  4. LatAm: beverage, food and snack businesses in Latin America;
  5. Europe: beverage, food and snack businesses in Europe;
  6. AMESA: beverage, food and snack businesses in Africa, the Middle East and South Asia; 
  7. APAC: beverage, food and snack businesses in Asia Pacific, Australia and New Zealand and China.

Some of the former division descriptions:

  • Europe Sub-Saharan Africa (ESSA): beverage, food and snack businesses in Europe and Sub-Saharan Africa;
  • Asia, Middle East and North Africa (AMENA): beverage, food and snack businesses in Asia, Middle East and North Africa.

No comments:

Post a Comment