This post describes our model of PepsiCo's (NYSE: PEP) Income Statement for fiscal 2010's 16-week fourth quarter, which will end on 25 December 2010.
The purpose of the model is to establish a baseline for identifying surprises, positive or negative, in the quarterly results the company will report. Estimates for each line of the Income Statement are derived from management's guidance, the company's historical financial results, and other publicly available data.
We begin by reviewing background information about PepsiCo and the business environment in which it is currently operating.
PepsiCo, Inc., is a leading global purveyor of beverages and snacks. The company, which has a market value over $100 billion, is well regarded for good management, steady growth, and significant international exposure.
Businesses, such as PepsiCo, that sell consumer staples are considered defensive investments because they are relatively less affected by economic slumps. These firms also tend to pay generous dividends, and this is true for PepsiCo. The company hiked its annual dividend this year by 7 percent, from $1.80 to $1.92 per share.
While famously locked in a battle with Coca-Cola (NYSE: KO) for the soft-drink market, it is important to recognize the importance of PepsiCo's other product lines. Frito-Lay North America had Revenue in 2009 of $13.2 billion, which was 30.6 percent of PepsiCo's total revenue.
On 26 February 2010, PepsiCo completed acquisitions of Pepsi Bottling Group, Inc., and PepsiAmericas, Inc., for $7.8 billion in total. These transactions give PepsiCo, according to statements made during a conference call, "one vertically integrated value chain [for beverages] just like [the] snacks business." PepsiCo will be "making decisions which benefit the total system without concern as to how the cost and benefits are shared between the brand and bottling operations."
The newly combined company would have earned $6.75 billion ($4.09 per diluted share) on a pro forma basis in fiscal 2009 on Revenue of $57.5 billion. The pro forma results eliminate the transactions that occurred between the three entities. The acquisitions effectively added $800 million (13.6 percent) to PepsiCo's annual Net Income and $14.2 billion (33 percent) to Revenue.
This month, PepsiCo reached an agreement to buy Wimm-Bill-Dann Foods (NYSE: WBD), a Russian dairy and juice firm. PepsiCo will pay $3.8 billion for 66 percent of Wimm-Bill-Dann, and it will offer to purchase the remaining shares at a later date.
In 2008, PepsiCo acquired Russian juice-maker Lebedyansky.
PepsiCo changed its organizational structure after it acquired its bottlers. For financial data reporting, PepsiCo now has six main divisions.
- Frito-Lay North America
- Quaker Foods North America
- Latin American Food
- PepsiCo Americas Beverages
- PepsiCo Europe
- PepsiCo Asia, Middle East and Africa.
PepsiCo earned $1.19 per diluted share on a GAAP basis in the 12-week, September-ending third quarter of fiscal 2010, up 9.5 percent from $1.09 in the same three months of last year. Core earnings, which exclude certain items, increased from $1.08 to $1.22 per share.
Core earnings adjusted to exclude currency fluctuations were $1.24 per share in the latest period. The Core figures are intended to provide better insight than the reported GAAP results into the company's fundamental financial performance.
Now, we are ready to look ahead to PepsiCo's results for the December 2010 quarter.
When the company announced its third-quarter results on 7 October 2010, it updated its expectations for fiscal 2010 Core earnings:
For fiscal 2010, the company is targeting an 11 to 12 percent growth rate for core constant currency EPS from its fiscal 2009 core EPS of $3.71, which is within the previous guidance range of 11 to 13 percent. Based on current spot rates, foreign exchange translation would represent a one percentage point unfavorable impact on the company’s full-year, core EPS. As a result, growth in core EPS for the year is expected to be in the 10 to 11 percent range.
PepsiCo has not provided guidance for its GAAP-compliant results. It's important to understand that Core earnings exclude the following:
- Commodity mark-to-market expenses,
- Integration costs related to the mergers with PBG and PAS.
- The gain or loss on previously held equity interests in PBG and PAS,
- The post-merger one-time impact of fair value adjustments to acquired inventory,
- The one-time charge related to hyperinflationary accounting and devaluation in Venezuela,
- A contribution to the PepsiCo Foundation, Inc.,
- Any additional restructuring or impairment costs and transaction costs related to the mergers with PBG and PAS.
Before we can estimate PepsiCo's Revenue in 2010's fourth quarter, we need to establish a year-earlier amount that includes the newly acquired bottlers.
In the fourth quarter of 2009, PepsiCo reported Revenue of $13.3 billion, PBG reported Revenue of $3.8 billion, and PAS reported 13-week Revenue of $970 million. We will exclude 18.2 percent of PBG's Revenue and 22.5 percent of PAS's Revenue -- these percentages are estimates based on annual data -- as inter-party transactions.
4Q-2009 Pro forma Revenue estimate:
= $13.3 billion + [(1 - 0.182) * $3.8 billion] + [(16/13)*(1 - 0.225)*$0.97 billion]
= $17.3 billion
To approximate Revenue in the fourth quarter of 2010, we have added 4 percent to the pro forma figure. The result is $18.0 billion.
We assume, based on historical data, that the Gross Margin in the fourth quarter will be around 53.5 percent. Our Revenue and Gross Margin estimates would translate into a projection for the Cost of Goods Sold of (1 - 0.535) * $18.0 billion = $8.4 billion.
Similarly, the fourth quarters from previous years suggest the Sales, General and Administrative expense might be around 40 percent of Revenue, or 0.40 * $18.0 billion = $7.2 billion.
We're also estimating a $40 million charge for amortization of intangible assets, based on historical data.
These assumptions lead to estimated Operating Income, as we define it, of $2.4 billion. Note that this estimate does not include Productivity for Growth charges, mark-to-market commodity hedge costs, nor acquisition costs.
With the completion of the bottler acquisitions, Bottler equity income should become insignificant. We're assuming interest expenses around $175 million.
Applying a 25 percent effective income tax rate to pretax income of $2.23 billion would result in a tax provision of $560 million.
Rolling up these figures, we obtain an estimate for Net Income of $1.67 billion, about $1.04 per share.
Please click here to see a full-sized, normalized depiction of the projected results next to PepsiCo's quarterly Income Statements for the last couple of years. Please note that our organization of revenues, expenses, gains, and losses, which we use for all analyses, can and often does differ in material respects from company-used formats. The standardization facilitates cross-company comparisons.
Full disclosure: Long PEP at time of writing. No position in any other security mentioned.