This "look-ahead" post discusses how I came up with an estimate for Procter & Gamble's earnings for fiscal 2021's second quarter, which ended on December 31, 2020, by predicting each element of its Income Statement, from top-line Revenue to bottom-line Earnings Per Share (EPS) and everything in between.
Once the company’s official results become available later this month, I will compare the published Income Statement to the prediction and identify any surprises, positive or negative. Examining these differences can identify what factors (e.g., profit margins, non-GAAP expenses, tax rates, share buybacks) are driving changes to a company's financial performance.
But, before we get into the details, let's take a step back and start with background information about Procter & Gamble.
P&G, which owns brands familiar to shoppers around the world, is a long-time giant of the consumer products industry. COVID-19 increased consumer and business demand for cleaning products and this has boosted P&G's sales, as did the greater amount of time people are spending at home. Note that P&G acquired in November 2018 the over-the-counter (OTC) consumer healthcare business of Germany's Merck for $3.7 billion in cash.
Shares of P&G now trade for about $139 each, giving the company a market value of $364 billion. These shares can be found in the Dow Jones Industrial Average, Standard and Poors 500, Standard and Poors 100, Standard and Poors Dividend Aristocrats, New York Stock Exchange Composite, and Russell 1000 stock indices.
P&G recorded profits of $14 billion on revenue of $72 billion during the last year. In the quarter that ended on 30 September 2020, P&G earned $1.63 per share, which significantly beat the $1.42 Wall Street consensus forecast. See https://tinyurl.com/yxf89wdr for P&G's most recent quarterly report.
Revenue in the September 2020 quarter totaled $19.3 billion, 9% more than last year's $17.8 billion. The Fabric and Home Care business was responsible for 34% of overall revenue, and this unit's revenue grew by 14.0% compared to the year-earlier result. The Baby, Feminine and Family Care business contributed 24% of revenue, and this unit's revenue increased by 3.0%. The Beauty unit supplied 20% of revenue, and the value rose by 7.0%.
My starting point, if available, when estimating earnings is guidance provided by the company's management to financial analysts. It's true that the company may downplay expectations somewhat to avoid disappointments, but the top managers ought to know better than anyone else how well their products and services are selling. I also look for other information about the company in the news, and I take advantage of trends in the company's historical results. While it makes my task a little more difficult, I also try to estimate earnings that conform to Generally Accepted Accounting Principles (GAAP). Non-GAAP results, which most professionals focus on, are somewhat arbitrary and often exclude meaningful items.
P&G management updated their expectations for fiscal 2021 in October 2020 when they last reported quarterly results.
P&G raised its outlook for fiscal 2021 all-in sales growth from a range of one to three percent to a range of three to four percent versus the prior fiscal year. The revised range includes an estimated one percent negative impact from foreign exchange. The Company raised its outlook for organic sales growth from a range of two to four percent to a range of four to five percent.The Company said it now expects fiscal 2021 GAAP diluted net earnings per share growth in a range of four to nine percent versus fiscal 2020 GAAP EPS of $4.96. GAAP EPS guidance now includes non-core charges in the range of $0.15 to $0.20 per share from the early debt retirement project that was initiated earlier this month. P&G raised guidance for core earnings per share growth from a range of three to seven percent to a range of five to eight percent versus fiscal 2020 core EPS of $5.12. The Company said its current outlook includes headwinds of approximately $325 million after-tax from foreign exchange impacts and $50 million after-tax from higher freight costs. The outlook also includes an estimated $150 million after tax headwind for the combined impacts of higher interest expense and lower interest income. These headwinds should be partially offset by approximately $175 million after-tax benefit from lower commodity costs.
P&G did not provide any specific guidance for the December 2020 quarter.
Revenue is predicted to rise between 3 and 4 percent for the fiscal year, but this figure grew 8.5 percent in the September quarter. This may indicate that management is somewhat concerned that the overall economic impact of COVID-19 might start to have more of a negative effect on P&G. I'm going to assume that P&G's revenue in the December 2020 quarter will only be 3 percent more than in the December 2019 period.
GAAP EPS for the fiscal year is expected to increase between 4 and 9 percent from last year's $4.96, which sets the range as $5.16 to $5.41. The reported EPS for the September quarter was $1.63, which leaves $3.53 to $3.78 for the final nine months of the fiscal year. It's also worth noting that operating earnings per share will have to be $0.15 to $0.20 higher than this range to compensate for an early debt retirement charge.
For the Gross Margin and Sales, General and Administrative (SG&A) expenses, I'm assuming their values as a percent of sales will be consistent with P&G recent quarters. I'm not sure if forecast for the early debt retirement charge will be fully recognized in the December quarter, but I reduced my estimate of non-operating gains by $400 million to account of this charge.
For the other lines of the Income Statement, I tried to choose values consistent with historical results. I end up with an earnings estimate of $3.15 billion, or $1.20 per share.
The following Income Statement results from estimates made as discussed above.
Please note that my organization of revenues, expenses, gains, and losses, which I use for all analyses, can and often does differ in material respects from company-used formats. The standardization facilitates cross-company comparisons.
#p&g #pg #gauges #gcfr #gcfr2 #lookahead #nac_financialanalysis