| The Clorox Company |  |
| | |
SupplementalInformation –VolumeGrowth
Reportable
Segment
| % Change vs. Prior Year | |
| FY11(2) | FY12(2) | Major Drivers of Change |
| Q1 | Q2 | Q3 | Q4 | FY | Q1 | Q2 | YTD | |
| Cleaning | 1% | -6% | 4% | 4% | 1% | -1% | 0% | -1% | Q2 primarily driven by higher shipments in the Away From Home business and Clorox®disinfecting bathroom cleaners, offset by lower shipments due to the impact of price increases in Laundry. |
| Household | -9% | -1% | -3% | 2% | -2% | 5% | 1% | 3% | Q2 increase primarily driven by higher shipments of Fresh Step®and Scoop Away®cat litter due to new product innovation, partially offset by lower shipments of Glad®products due to the impact of pricing. |
| Lifestyle(1) | 1% | 3% | 3% | 3% | 3% | 6% | 2% | 4% | Q2 increase primarily driven by growth behind the new Brita®on-the-go bottle and higher shipments of Burt’s Bees®natural personal care products due to new product innovation. |
| International | -2% | 3% | 0% | 0% | 0% | 3% | -1% | 1% | Q2 decrease primarily driven by lower shipments in Latin America. |
| Total Company | -2% | -2% | 1% | 2% | 0% | 2% | 0% | 1% | |
| |
SupplementalInformation –SalesGrowth
Reportable
Segment
| % Change vs. Prior Year | |
| FY11(2) | FY12(2) | Major Drivers of Change |
| Q1 | Q2 | Q3 | Q4 | FY | Q1 | Q2 | YTD | |
| Cleaning | -1% | -6% | 3% | 4% | 0% | -2% | 5% | 1% | Q2 variance between changes in volume and sales was primarily driven by the benefit of price increases. |
| Household | -7% | -4% | -3% | 1% | -3% | 3% | 4% | 4% | Q2 variance between changes in volume and sales was primarily driven by the benefit of price increases on Glad®products, partially offset by unfavorable mix. |
| Lifestyle(1) | 1% | 3% | 0% | 5% | 2% | 6% | 6% | 6% | Q2 variance between changes in volume and sales was primarily driven by the benefit of price increases on Hidden Valley®salad dressing partially offset by trade promotion spending. |
| International | -2% | -1% | 8% | 9% | 3% | 9% | 0% | 4% | Q2 variance between changes in volume and sales was primarily driven by the benefit of price increases, offset by unfavorable foreign currency exchange rates, unfavorable country mix and higher trade spending. |
| Total Company | -3% | -3% | 1% | 4% | 0% | 3% | 4% | 3% | |
| |
| (1) | | Lifestyle includes results of the worldwide Burt’s Bees business. |
| (2) | | Volume and sales growth percentage changes for the Cleaning and International reportable segments and Total Company reflect the reclassification of the Auto Care businesses to discontinued operations in Q1 fiscal 2011 for all periods presented. |
| The Clorox Company | |
| | |
Earnings (Losses) From Continuing Operations Before Interest and Taxes (EBIT), Earnings (Losses) From Continuing Operations Before Interest, Taxes, Depreciation and Amortization (EBITDA)(1)
Reconciliation of earnings (losses) from continuing operations before income taxes to EBIT and EBITDA
Dollars in millions and percentages based on rounded numbers
| | FY 2011 | | | FY2012 |
| | Q1 | | Q2 | | Q3 | | Q4 | | FY | | | Q1 | | Q2 |
| | 9/30/10 | | 12/31/10 | | 3/31/2011 | | 6/30/11 | | 6/30/11 | | | 9/30/11 | | 12/31/11 |
| Earnings (losses) from continuing | | $ | 202 | | | $ | (112 | ) | | $ | 219 | | | $ | 254 | | | $ | 563 | | | | $ | 187 | | | $ | 155 | |
| operations before income taxes | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| Goodwill impairment(2) | | | - | | | | 258 | | | | - | | | | - | | | | 258 | | | | | - | | | | - | |
| Interest income | | | (1 | ) | | | (1 | ) | | | - | | | | (1 | ) | | | (3 | ) | | | | (1 | ) | | | (1 | ) |
| Interest expense | | | 32 | | | | 33 | | | | 29 | | | | 29 | | | | 123 | | | | | 29 | | | | 30 | |
| EBIT(3) | | | 233 | | | | 178 | | | | 248 | | | | 282 | | | | 941 | | | | | 215 | | | | 184 | |
| EBITDA margin(3) | | | 18.4 | % | | | 15.1 | % | | | 19.0 | % | | | 19.0 | % | | | 18.0 | % | | | | 16.5 | % | | | 15.1 | % |
| Depreciation and amortization | | | 45 | | | | 43 | | | | 42 | | | | 43 | | | | 173 | | | | | 46 | | | | 43 | |
| EBITDA(4) | | $ | 278 | | | $ | 221 | | | $ | 290 | | | $ | 325 | | | $ | 1,114 | | | | $ | 261 | | | $ | 227 | |
| EBITDA margin(4) | | | 22.0 | % | | | 18.7 | % | | | 22.2 | % | | | 21.9 | % | | | 21.3 | % | | | | 20.0 | % | | | 18.6 | % |
| Net sales | | $ | 1,266 | | | $ | 1,179 | | | $ | 1,304 | | | $ | 1,482 | | | $ | 5,231 | | | | $ | 1,305 | | | $ | 1,221 | |
| (1) | | In accordance with SEC's Regulation G, this schedule provides the definition of certain non-GAAP measures and the reconciliation to the most closely related GAAP measure. Management believes the presentation of EBIT, EBIT margin, EBITDA and EBITDA margin provides additional useful information to investors about current trends in the business. These non-GAAP financial measures may not be the same as similar measures presented by other companies. |
| | | Note: The calculation of EBITDA for compliance with the Company’s debt covenants uses net earnings and includes other items as defined by its revolving credit agreement. |
| (2) | | The goodwill impairment represents a $258 million noncash charge recognized in Q2 fiscal 2011 to adjust the carrying value of the goodwill related to the acquisition of Burt’s Bees to estimated fair value. |
| (3) | | EBIT (a non-GAAP measure) represents earnings before income taxes (a GAAP measure), excluding goodwill impairment, interest income and interest expense, as reported above. EBIT margin is a measure of EBIT as a percentage of net sales. |
| (4) | | EBITDA (a non-GAAP measure) represents earnings before income taxes (a GAAP measure), excluding goodwill impairment, interest income, interest expense, depreciation and amortization, as reported above. EBITDA margin is a measure of EBITDA as a percentage of net sales. |
| The Clorox Company | |
| | |
Supplemental Information – Balance Sheet
(Unaudited)
As of December 31, 2011
Working Capital Update
| Q2 | | | | |
| FY 2012 | FY 2011 | Change | Days(5) | Days(5) | |
| ($ millions) | ($ millions) | ($ millions) | FY 2012 | FY 2011 | Change |
| Receivables, net | $489 | | $440 | | $49 | | 34 | 35 | - 1 days |
| Inventories, net | $451 | | $412 | | $39 | | 54 | 51 | + 3 days |
| Accounts payable(1) | $345 | | $326 | | $19 | | 42 | 44 | - 2 days |
| Accrued liabilities | $438 | | $443 | | -$5 | | | | |
| Total WC(2) | $240 | | $92 | | $148 | | | | |
| Total WC % net sales(3) | 4.9 | % | 2.0 | % | | | | | |
| Average WC(2) | $190 | | $82 | | $108 | | | | |
| Average WC % net sales(4) | 3.9 | % | 1.7 | % | | | | | |
- Receivables increased primarily due to increase in sales.
- Inventories increased primarily due to inventory builds for current year product launches.
- Total working capital increased due to a decrease in income taxes payables.
Supplemental Information – Cash Flow
(Unaudited)
For the quarter ended December 31, 2011
Capital expendituresfor the second quarter were $45 million versus $55 million in the year-ago quarter.
Depreciation and amortizationwas $43 million for both the current and year-ago quarter.
Net cash provided by continuingoperations in the second quarter decreased to $37 million from $44 million in the year-ago quarter. The year-over-year decrease was primarily due to changes in working capital.
| (1) | | Days of accounts payable is calculated as follows: average accounts payable / [(cost of products sold + change in inventory) / 90]. |
| (2) | | Working capital (WC) is defined in this context as current assets minus current liabilities excluding cash, assets held for sale, and short-term debt, based on end of period balances. Average working capital represents a two-point average of working capital. |
| (3) | | Represents working capital at the end of the period divided by annualized net sales(current quarter net sales x 4). |
| (4) | | Represents a two-point average of working capital divided by annualized net sales(current quarter net sales x 4). |
| (5) | | Days calculations based on a two-point average. |
| The Clorox Company | |
| | |
SupplementalInformation –GrossMarginDriversThe table belowprovides details on the drivers of the grossmarginchange versus the prior year.
| | Gross Margin Change vs. Prior Year (basis points) |
| Driver | FY10 | FY11 | FY12 |
| FY | Q1 | Q2 | Q3 | Q4 | FY | Q1 | Q2 |
| Cost Savings | +180 | +200 | +180 | +180 | +110 | +170 | +160 | +180 |
| Price Changes | +90 | +80 | +100 | +60 | +70 | +80 | +170 | +240 |
| Market Movement (commodities) | +30 | -180 | -150 | -150 | -170 | -160 | -320 | -240 |
| Manufacturing & Logistics(1) | -30 | +20 | -60 | -70 | -40 | -30 | -220 | -170 |
| All other(2) | -140 | -160 | -250 | -70 | -50 | -140 | -40 | -30 |
| | | | | | | | | |
| Change vs prior year | +130 | -40 | -180 | -50 | -80 | -80 | -250 | -20 |
| Gross Margin (%) | 44.3% | 44.3% | 41.7% | 44.1% | 43.5% | 43.5% | 41.7% | 41.5% |
| (1) | | “Manufacturing & Logistics” includes the change in the cost of diesel fuel. |
| (2) | | “All Other” includes all other drivers of gross margin change. Examples of drivers included: volume change, product mix, trade and consumer spending, restructuring and acquisition-related costs, foreign currency, etc. If a driver included in all other is deemed to be material in a given period, it will be disclosed as part of the company’s earnings release. |
| The Clorox Company | |
| | |
U.S. Pricing Actions from CY2008 - CY2011
| Brand / Product | | Average Price Change | | Effective Date |
| Home Care | | | | | | |
| Pine-Sol®cleaners | | | +13% | | | May 2008 |
| Clorox Clean-Up®cleaners | | | +8% | | | August 2008 |
| Formula 409®, Tilex®, and Clorox®Disinfecting Bathroom cleaners | | | +12% | | | August 2008 |
| Liquid-Plumr®products | | | +9% | | | August 2008 |
| Clorox®Toilet Bowl Cleaner and Clorox®ToiletWandTMproducts | | | +8 to +13% | | | August 2008 |
| Green Works®cleaners | | | -7 to -21% | | | May 2010 |
| Formula 409® | | | +6% | | | August 2011 |
| Clorox Clean-Up®cleaners | | | +8% | | | August 2011 |
| Clorox®Toilet Bowl Cleaner | | | +5% | | | August 2011 |
| Liquid-Plumr®products | | | +5% | | | August 2011 |
| | | | | | | |
| Laundry | | | | | | |
| Clorox®liquid bleach | | | +10% | | | August 2008 |
| Green Works®liquid detergent | | | approx. -30% | | | May 2010 |
| Clorox®liquid bleach | | | +12% | | | August 2011 |
| Clorox 2®stain fighter and color booster | | | +5% | | | August 2011 |
| | | | | | | |
| Glad | | | | | | |
| Glad®trash bags | | | +7% | | | February 2008 |
| GladWare®disposable containers | | | +7% | | | February 2008 |
| Glad®trash bags | | | +10% | | | October 2008 |
| Glad®trash bags | | | -10% | | | December 2008 |
| GladWare®disposable containers | | | -7% | | | April 2009 |
| Glad®trash bags | | | -7% | | | May 2009 |
| Glad®trash bags | | | +5% | | | August 2010 |
| Glad®trash bags | | | +10% | | | May 2011 |
| Glad®wraps | | | +7% | | | August 2011 |
| Glad®food bags | | | +10% | | | November 2011 |
| | | | | | | |
| Litter | | | | | | |
| Cat litter | | | +7 to +8% | | | August 2008 |
| Cat litter | | | -8 to -9% | | | March 2010 |
| | | | | | | |
| Food | | | | | | |
| Hidden Valley Ranch®salad dressing | | | +7% | | | August 2008 |
| Hidden Valley Ranch®salad dressing | | | +7% | | | August 2011 |
| | | | | | | |
| Charcoal | | | | | | |
| Charcoal | | | +6% | | | January 2008 |
| Charcoal and lighter fluid | | | +7 to +16% | | | January 2009 |
| | | | | | | |
| Brita | | | | | | |
| Brita®pitchers | | | +3% | | | August 2011 |
Notes:
- Individual SKUs vary within the range.
- This communication reflects pricing actions on primary items.
