|
|
þ
|
QUARTERLY REPORT PURSUANT TO SECTION 13 OR 15(d) OF THE SECURITIES EXCHANGE ACT OF 1934
|
|
|
¨
|
TRANSITION REPORT PURSUANT TO SECTION 13 OR 15(d) OF THE SECURITIES EXCHANGE ACT OF 1934
|
|
Illinois
|
36-1924025
|
|
(State of Incorporation)
|
(I.R.S. Employer Identification No.)
|
|
200 Wilmot Road, Deerfield, Illinois
|
60015
|
|
(Address of principal executive offices)
|
(Zip Code)
|
|
Yes
þ
No
¨
|
|
Large accelerated filer
þ
Accelerated Filer
¨
Non-accelerated filer
¨
(Do not check if a smaller reporting company) Smaller reporting company
¨
|
|
Yes
¨
No
þ
|
|
Item 1.
|
Consolidated Condensed Financial Statements (Unaudited)
|
||
|
a)
|
Balance Sheets
|
||
|
b)
|
Statements of Earnings
|
||
|
c)
|
Statements of Cash Flows
|
||
|
d)
|
Notes to Financial Statements
|
||
|
Item 2.
|
Management’s Discussion and Analysis of Financial Condition and Results of Operations
|
||
|
Item 3.
|
Quantitative and Qualitative Disclosure about Market Risk
|
||
|
Item 4.
|
Controls and Procedures
|
||
|
Item 1.
|
Legal Proceedings
|
|
|
Item 1A.
|
Risk Factors
|
|
|
Item 2.
|
Unregistered Sales of Equity Securities and Use of Proceeds
|
|
|
Item 6.
|
Exhibits
|
|
WALGREEN CO. AND SUBSIDIARIES
|
||||||||||||
|
CONSOLIDATED CONDENSED BALANCE SHEETS
|
||||||||||||
|
(UNAUDITED)
|
||||||||||||
|
(In millions, except per share amounts)
|
||||||||||||
|
November 30,
|
August 31,
|
November 30,
|
||||||||||
|
2010
|
2010
|
2009
|
||||||||||
|
Assets
|
||||||||||||
|
Current Assets:
|
||||||||||||
|
Cash and cash equivalents
|
$ | 2,062 | $ | 1,880 | $ | 2,552 | ||||||
|
Short-term investments
|
- | - | 600 | |||||||||
|
Accounts receivable, net
|
2,472 | 2,450 | 2,577 | |||||||||
|
Inventories
|
7,909 | 7,378 | 7,474 | |||||||||
|
Other current assets
|
220 | 214 | 170 | |||||||||
|
Total Current Assets
|
12,663 | 11,922 | 13,373 | |||||||||
|
Non-Current Assets:
|
||||||||||||
|
Property and equipment, at cost, less accumulated depreciation and amortization
|
11,197 | 11,184 | 10,865 | |||||||||
|
Goodwill
|
1,896 | 1,887 | 1,467 | |||||||||
|
Other non-current assets
|
1,288 | 1,282 | 843 | |||||||||
|
Total Non-Current Assets
|
14,381 | 14,353 | 13,175 | |||||||||
|
Total Assets
|
$ | 27,044 | $ | 26,275 | $ | 26,548 | ||||||
|
Liabilities & Shareholders' Equity
|
||||||||||||
|
Current Liabilities:
|
||||||||||||
|
Short-term borrowings
|
$ | 13 | $ | 12 | $ | 13 | ||||||
|
Trade accounts payable
|
4,955 | 4,585 | 5,043 | |||||||||
|
Accrued expenses and other liabilities
|
2,780 | 2,763 | 2,446 | |||||||||
|
Income taxes
|
401 | 73 | 320 | |||||||||
|
Total Current Liabilities
|
8,149 | 7,433 | 7,822 | |||||||||
|
Non-Current Liabilities:
|
||||||||||||
|
Long-term debt
|
2,389 | 2,389 | 2,366 | |||||||||
|
Deferred income taxes
|
360 | 318 | 275 | |||||||||
|
Other non-current liabilities
|
1,783 | 1,735 | 1,464 | |||||||||
|
Total Non-Current Liabilities
|
4,532 | 4,442 | 4,105 | |||||||||
|
Commitments and Contingencies (see Note 13)
|
||||||||||||
|
Shareholders' Equity:
|
||||||||||||
|
Preferred stock $.0625 par value; authorized 32 million shares, none issued
|
- | - | - | |||||||||
|
Common stock $.078125 par value; authorized 3.2 billion shares; issued 1,025,400,000 at November 30, 2010, August 31, 2010 and November 30, 2009
|
80 | 80 | 80 | |||||||||
|
Paid-in capital
|
708 | 684 | 633 | |||||||||
|
Employee stock loan receivable
|
(74 | ) | (87 | ) | (127 | ) | ||||||
|
Retained earnings
|
17,266 | 16,848 | 15,679 | |||||||||
|
Accumulated other comprehensive (loss) income
|
(23 | ) | (24 | ) | 36 | |||||||
|
Treasury stock, at cost; 102,984,568 shares at November 30, 2010, 86,794,947 at August 31, 2010 and 40,226,063 at November 30, 2009
|
(3,594 | ) | (3,101 | ) | (1,680 | ) | ||||||
|
Total Shareholders' Equity
|
14,363 | 14,400 | 14,621 | |||||||||
|
Total Liabilities & Shareholders' Equity
|
$ | 27,044 | $ | 26,275 | $ | 26,548 | ||||||
|
WALGREEN CO. AND SUBSIDIARIES
|
||||||||
|
CONSOLIDATED CONDENSED STATEMENTS OF EARNINGS
|
||||||||
|
(UNAUDITED)
|
||||||||
|
(In millions, except per share amounts)
|
||||||||
|
Three Months Ended
|
||||||||
|
November 30, 2010
|
November 30, 2009
|
|||||||
|
Net sales
|
$ | 17,344 | $ | 16,364 | ||||
|
Cost of sales
|
12,399 | 11,826 | ||||||
|
Gross Profit
|
4,945 | 4,538 | ||||||
|
Selling, general and administrative expenses
|
4,004 | 3,741 | ||||||
|
Operating Income
|
941 | 797 | ||||||
|
Interest expense, net
|
20 | 21 | ||||||
|
Earnings Before Income Tax Provision
|
921 | 776 | ||||||
|
Income tax provision
|
341 | 287 | ||||||
|
Net Earnings
|
$ | 580 | $ | 489 | ||||
|
Net earnings per common share – basic
|
$ | .62 | $ | .49 | ||||
|
Net earnings per common share – diluted
|
$ | .62 | $ | .49 | ||||
|
Dividends declared
|
$ | .1750 | $ | .1375 | ||||
|
Average shares outstanding
|
928.8 | 988.4 | ||||||
|
Dilutive effect of stock options
|
5.5 | 5.0 | ||||||
|
Average shares outstanding assuming dilution
|
934.3 | 993.4 | ||||||
|
WALGREEN CO. AND SUBSIDIARIES
|
||||||||
|
CONSOLIDATED CONDENSED STATEMENTS OF CASH FLOWS
|
||||||||
|
(UNAUDITED)
|
||||||||
|
(In millions)
|
||||||||
|
Three Months Ended November 30,
|
||||||||
|
2010
|
2009
|
|||||||
|
Cash Flows from Operating Activities
:
|
||||||||
|
Net earnings
|
$ | 580 | $ | 489 | ||||
|
Adjustments to reconcile net earnings to net cash provided by operating activities -
|
||||||||
|
Depreciation and amortization
|
273 | 257 | ||||||
|
Deferred income taxes
|
(1 | ) | (4 | ) | ||||
|
Stock compensation expense
|
26 | 24 | ||||||
|
Income tax savings from employee stock plans
|
- | 3 | ||||||
|
Other
|
4 | 5 | ||||||
|
Changes in operating assets and liabilities -
|
||||||||
|
Accounts receivable, net
|
(30 | ) | (54 | ) | ||||
|
Inventories
|
(526 | ) | (682 | ) | ||||
|
Other assets
|
17 | 3 | ||||||
|
Trade accounts payable
|
370 | 735 | ||||||
|
Accrued expenses and other liabilities
|
76 | 65 | ||||||
|
Income taxes
|
327 | 259 | ||||||
|
Other non-current liabilities
|
49 | 68 | ||||||
|
Net cash provided by operating activities
|
1,165 | 1,168 | ||||||
|
Cash Flows from Investing Activities
:
|
||||||||
|
Purchases of short-term investments held to maturity
|
- | (600 | ) | |||||
|
Proceeds from short-term investments held to maturity
|
- | 500 | ||||||
|
Additions to property and equipment
|
(273 | ) | (304 | ) | ||||
|
Proceeds from sale of assets
|
13 | 5 | ||||||
|
Business and intangible asset acquisitions, net of cash received
|
(63 | ) | (32 | ) | ||||
|
Other
|
(11 | ) | - | |||||
|
Net cash used for investing activities
|
(334 | ) | (431 | ) | ||||
|
Cash Flows from Financing Activities
:
|
||||||||
|
Stock purchases
|
(510 | ) | (195 | ) | ||||
|
Proceeds related to employee stock plans
|
29 | 63 | ||||||
|
Cash dividends paid
|
(166 | ) | (136 | ) | ||||
|
Other
|
(2 | ) | (4 | ) | ||||
|
Net cash used for financing activities
|
(649 | ) | (272 | ) | ||||
|
Changes in Cash and Cash Equivalents
:
|
||||||||
|
Net increase in cash and cash equivalents
|
182 | 465 | ||||||
|
Cash and cash equivalents at September 1
|
1,880 | 2,087 | ||||||
|
Cash and cash equivalents at November 30
|
$ | 2,062 | $ | 2,552 | ||||
|
Three Months Ended
November 30,
|
||||||||
|
2010
|
2009
|
|||||||
|
Severance and other benefits
|
$ | 2 | $ | 7 | ||||
|
Inventory charges
|
- | 19 | ||||||
|
Restructuring expense
|
2 | 26 | ||||||
|
Consulting
|
5 | 7 | ||||||
|
Restructuring and restructuring related expenses
|
$ | 7 | $ | 33 | ||||
|
Cost of sales
|
$ | - | $ | 19 | ||||
|
Selling, general and administrative expenses
|
7 | 14 | ||||||
| $ | 7 | $ | 33 | |||||
|
Severance and Other Benefits
|
||||
|
November 30, 2009 reserve balance
|
$ | 1 | ||
|
Charges
|
10 | |||
|
Cash payments
|
(11 | ) | ||
|
August 31, 2010 reserve balance
|
- | |||
|
Charges
|
2 | |||
|
Cash payments
|
(2 | ) | ||
|
November 30, 2010 reserve balance
|
$ | - | ||
|
November 30,
|
August 31,
|
November 30,
|
||||||||||
|
2010
|
2010
|
2009
|
||||||||||
|
Balance – beginning of period
|
$ | 151 | $ | 99 | $ | 99 | ||||||
|
Provision for present value of non-cancellable lease
payments of closed facilities
|
14 | 77 | 18 | |||||||||
|
Assumptions about future sublease income, terminations, and changes in interest rates
|
(7 | ) | (9 | ) | (2 | ) | ||||||
|
Interest accretion
|
5 | 22 | 6 | |||||||||
|
Cash payments, net of sublease income
|
(12 | ) | (45 | ) | (10 | ) | ||||||
|
Reserve acquired through acquisition
|
- | 7 | - | |||||||||
|
Balance – end of period
|
$ | 151 | $ | 151 | $ | 111 | ||||||
|
Three Months Ended November 30,
|
||||||||
|
Components of Net Periodic Benefit Costs (In millions):
|
2010
|
2009
|
||||||
|
Service cost
|
$ | 4 | $ | 3 | ||||
|
Interest cost
|
5 | 5 | ||||||
|
Amortization of actuarial loss
|
4 | 2 | ||||||
|
Amortization of prior service cost
|
(3 | ) | (3 | ) | ||||
|
Total postretirement benefit cost
|
$ | 10 | $ | 7 | ||||
|
November 30,
2010
|
August 31,
2010
|
November 30,
2009
|
||||||||||
|
Short-Term Borrowings -
|
||||||||||||
|
Current maturities of loans assumed through the purchase of land, buildings and equipment; various interest rates from 5.00% to 8.75%; various maturities from 2015 to 2035
|
$ | 8 | $ | 7 | $ | 9 | ||||||
|
Other
|
5 | 5 | 4 | |||||||||
|
Total short-term borrowings
|
$ | 13 | $ | 12 | $ | 13 | ||||||
|
Long-Term Debt -
|
||||||||||||
|
4.875% unsecured notes due 2013 net of unamortized discount and interest rate swap fair market value adjustment (see Note 11)
|
$ | 1,348 | $ | 1,348 | $ | 1,325 | ||||||
|
5.250% unsecured notes due 2019 net of unamortized discount
|
996 | 995 | 995 | |||||||||
|
Loans assumed through the purchase of land, buildings and equipment; various interest rates from 5.00% to 8.75%; various maturities from 2015 to 2035
|
53 | 53 | 55 | |||||||||
| 2,397 | 2,396 | 2,375 | ||||||||||
|
Less current maturities
|
(8 | ) | (7 | ) | (9 | ) | ||||||
|
Total-long term debt
|
$ | 2,389 | $ | 2,389 | $ | 2,366 | ||||||
|
Net book value – December 1, 2009
|
||||
|
Goodwill
|
$ | 1,479 | ||
|
Accumulated impairment losses
|
(12 | ) | ||
|
Total
|
1,467 | |||
|
Acquisitions
|
435 | |||
|
Impairment charges
|
(16 | ) | ||
|
Other
|
1 | |||
|
Net book value – August 31, 2010
|
1,887 | |||
|
Acquisitions
|
33 | |||
|
Other
|
(24 | ) | ||
|
Net book value – November 30, 2010
|
$ | 1,896 | ||
|
November 30,
2010
|
August 31,
2010
|
November 30,
2009
|
||||||||||
|
Gross Intangible Assets
|
||||||||||||
|
Purchased prescription files
|
$ | 778 | $ | 749 | $ | 589 | ||||||
|
Favorable lease interests
|
383 | 377 | 81 | |||||||||
|
Purchasing and payor contracts
|
280 | 280 | 273 | |||||||||
|
Trade name
|
44 | 44 | 25 | |||||||||
|
Other amortizable intangible assets
|
108 | 103 | 64 | |||||||||
|
Total gross intangible assets
|
1,593 | 1,553 | 1,032 | |||||||||
|
Accumulated amortization
|
||||||||||||
|
Purchased prescription files
|
(316 | ) | (293 | ) | (221 | ) | ||||||
|
Favorable lease interests
|
(48 | ) | (38 | ) | (21 | ) | ||||||
|
Purchasing and payor contracts
|
(74 | ) | (68 | ) | (51 | ) | ||||||
|
Trade name
|
(5 | ) | (3 | ) | (13 | ) | ||||||
|
Other amortizable intangibles
|
(40 | ) | (37 | ) | (25 | ) | ||||||
|
Total accumulated amortization
|
(483 | ) | (439 | ) | (331 | ) | ||||||
|
Total intangible assets, net
|
$ | 1,110 | $ | 1,114 | $ | 701 | ||||||
|
2011
|
2012
|
2013
|
2014
|
2015
|
||||||||||||||
| $ | 213 | $ | 194 | $ | 169 | $ | 140 | $ | 110 | |||||||||
|
Notional Amount
|
||||
|
Derivatives designated as hedges:
|
||||
|
Interest rate swaps
|
$ | 1,300 | ||
|
Location in Consolidated Condensed Balance Sheet
|
November 30,
2010
|
August 31,
2010
|
November 30,
2009
|
||||||||||
|
Asset derivatives designated as hedges:
|
|||||||||||||
|
Interest rate swaps
|
Other non-current assets
|
$ | 47 | $ | 44 | $ | 28 | ||||||
|
Level 1 -
|
Quoted prices in active markets that are accessible at the measurement date for identical assets and liabilities. The fair value hierarchy gives the highest priority to Level 1 inputs.
|
|
Level 2 -
|
Observable inputs other than quoted prices in active markets.
|
|
Level 3 -
|
Unobservable inputs for which there is little or no market data available. The fair value hierarchy gives the lowest priority to Level 3 inputs.
|
|
November 30, 2010
|
Level 1
|
Level 2
|
Level 3
|
|||||||||||||
|
Assets:
|
||||||||||||||||
|
Money market funds
|
$ | 1,382 | $ | 1,382 | - | - | ||||||||||
|
Interest rate swaps
|
47 | - | $ | 47 | - | |||||||||||
|
August 31, 2010
|
Level 1
|
Level 2
|
Level 3
|
|||||||||||||
|
Assets:
|
||||||||||||||||
|
Money market funds
|
$ | 1,030 | $ | 1,030 | - | - | ||||||||||
|
Liabilities:
|
||||||||||||||||
|
Interest rate swaps
|
44 | - | $ | 44 | - | |||||||||||
|
November 30, 2009
|
Level 1
|
Level 2
|
Level 3
|
|||||||||||||
|
Assets:
|
||||||||||||||||
|
Money market funds
|
$ | 1,964 | $ | 1,964 | - | - | ||||||||||
|
Interest rate swaps
|
28 | - | $ | 28 | - | |||||||||||
|
August 31, 2010
|
Level 1
|
Level 2
|
Level 3
|
|||||||||||||
|
Assets:
|
||||||||||||||||
|
Goodwill
|
$ | 3 | - | - | $ | 3 | ||||||||||
|
Accounts receivable
|
$ | 52 | ||
|
Inventory
|
228 | |||
|
Other current assets
|
99 | |||
|
Property and equipment
|
219 | |||
|
Other non-current assets
|
3 | |||
|
Intangible assets
|
445 | |||
|
Goodwill
|
401 | |||
|
Total assets acquired
|
1,447 | |||
|
Liabilities assumed
|
313 | |||
|
Debt assumed
|
574 | |||
|
Net cash paid
|
$ | 560 |
|
Three Months Ended
November 30, 2010
|
||||
|
Net sales
|
$ | 458 | ||
|
Net loss
|
(5 | ) | ||
|
Net earnings per common share:
|
||||
|
Basic
|
$ | 0.00 | ||
|
Diluted
|
$ | 0.00 | ||
|
Three Months Ended
November 30,
|
||||||||
|
2010
|
2009
|
|||||||
|
Depreciation expense
|
$ | 208 | $ | 207 | ||||
|
Intangible asset amortization
|
52 | 39 | ||||||
|
System development costs amortization
|
13 | 11 | ||||||
|
Total depreciation and amortization expense
|
$ | 273 | $ | 257 | ||||
|
Number of Locations
|
||||||||
|
Location Type
|
November 30, 2010
|
November 30, 2009
|
||||||
|
Drugstores
|
7,651 | 7,147 | ||||||
|
Worksite Facilities
|
370 | 382 | ||||||
|
Home Care Facilities
|
100 | 104 | ||||||
|
Specialty Pharmacies
|
10 | 14 | ||||||
|
Mail Service Facilities
|
2 | 2 | ||||||
|
Total
|
8,133 | 7,649 | ||||||
|
Three Months Ended
November 30,
|
||||||||
|
2010
|
2009
|
|||||||
|
Severance and other benefits
|
$ | 2 | $ | 7 | ||||
|
Inventory charges
|
- | 19 | ||||||
|
Restructuring expense
|
2 | 26 | ||||||
|
Consulting
|
5 | 7 | ||||||
|
Restructuring and restructuring related expenses
|
$ | 7 | $ | 33 | ||||
|
Cost of sales
|
$ | - | $ | 19 | ||||
|
Selling, general and administrative expenses
|
7 | 14 | ||||||
| $ | 7 | $ | 33 | |||||
|
Severance and Other Benefits
|
||||
|
November 30, 2009 reserve balance
|
$ | 1 | ||
|
Charges
|
10 | |||
|
Cash payments
|
(11 | ) | ||
|
August 31, 2010 reserve balance
|
- | |||
|
Charges
|
2 | |||
|
Cash payments
|
(2 | ) | ||
|
November 30, 2010 reserve balance
|
$ | - | ||
|
Percentage Increases/(Decreases)
|
||||||||
|
Three Months Ended November 30,
|
||||||||
|
2010
|
2009
|
|||||||
|
Net Sales
|
6.0 | 9.5 | ||||||
|
Net Earnings
|
18.8 | 19.6 | ||||||
|
Comparable Drugstore Sales
|
0.8 | 4.9 | ||||||
|
Prescription Sales
|
5.3 | 10.0 | ||||||
|
Comparable Drugstore Prescription Sales
|
0.9 | 6.1 | ||||||
|
Front-End Sales
|
7.3 | 8.5 | ||||||
|
Comparable Drugstore Front-End Sales
|
0.4 | 2.7 | ||||||
|
Gross Profit
|
9.0 | 9.3 | ||||||
|
Selling, General and Administrative Expenses
|
7.0 | 7.4 | ||||||
|
Percent to Net Sales
|
||||||||
|
Three Months Ended November 30,
|
||||||||
|
2010
|
2009
|
|||||||
|
Gross Margin
|
28.5 | 27.7 | ||||||
|
Selling, General and Administrative Expenses
|
23.1 | 22.8 | ||||||
|
Other Statistics
|
||||||||
|
Three Months Ended November 30,
|
||||||||
|
2010
|
2009
|
|||||||
|
Prescription Sales as a % of Net Sales
|
65.8 | 66.2 | ||||||
|
Third Party Sales as a % of Total Prescription Sales
|
95.3 | 94.7 | ||||||
|
Total Number of Prescriptions (in millions)
|
181 | 174 | ||||||
|
30 Day Equivalent Prescriptions (in millions) *
|
202 | 194 | ||||||
|
Total Number of Locations
|
8,133 | 7,649 | ||||||
|
Goodwill and other intangible asset impairment -
|
|
|
Goodwill and other indefinite-lived intangible assets are not amortized, but are evaluated for impairment annually during the fourth quarter, or more frequently if an event occurs or circumstances change that would more likely than not reduce the fair value of a reporting unit below its carrying value. As part of our impairment analysis for each reporting unit, we engaged a third party appraisal firm to assist in the determination of estimated fair value for each unit. This determination included estimating the fair value using both the income and market approaches. The income approach requires management to estimate a number of factors for each reporting unit, including projected future operating results, economic projections, anticipated future cash flows and discount rates. The market approach estimates fair value using comparable marketplace fair value data from within a comparable industry grouping.
The determination of the fair value of the reporting units and the allocation of that value to individual assets and liabilities within those reporting units requires us to make significant estimates and assumptions. These estimates and assumptions primarily include, but are not limited to: the selection of appropriate peer group companies; control premiums appropriate for acquisitions in the industries in which we compete; the discount rate; terminal growth rates; and forecasts of revenue, operating income, depreciation and amortization and capital expenditures. The allocation requires several analyses to determine fair value of assets and liabilities including, among other things, purchased prescription files, customer relationships and trade names. Although we believe our estimates of fair value are reasonable, actual financial results could differ from those estimates due to the inherent uncertainty involved in making such estimates. Changes in assumptions concerning future financial results or other underlying assumptions could have a significant impact on either the fair value of the reporting units, the amount of the goodwill impairment charge, or both. We also compared the sum of the estimated fair values of the reporting units to the Company’s total value as implied by the market value of the Company’s equity and debt securities. This comparison indicated that, in total, our assumptions and estimates were reasonable. However, future declines in the overall market value of the Company’s equity and debt securities may indicate that the fair value of one or more reporting units has declined below its carrying value.
We have not made any material changes to the method of evaluating goodwill and intangible asset impairments during the last three years. Based on current knowledge, we do not believe there is a reasonable likelihood that there will be a material change in the estimates or assumptions used to determine impairment.
|
|
|
Allowance for doubtful accounts -
|
|
|
The provision for bad debt is based on both specific receivables and historic write-off percentages. We have not made any material changes to the method of estimating our allowance for doubtful accounts during the last three years. Based on current knowledge, we do not believe there is a reasonable likelihood that there will be a material change in the estimates or assumptions used to determine the allowance.
|
|
|
Vendor allowances -
|
|
|
Vendor allowances are principally received as a result of purchases, sales or promotion of vendors' products. Allowances are generally recorded as a reduction of inventory and are recognized as a reduction of cost of sales when the related merchandise is sold. Those allowances received for promoting vendors' products are offset against advertising expense and result in a reduction of selling, general and administrative expenses to the extent of advertising incurred, with the excess treated as a reduction of inventory costs. We have not made any material changes to the method of estimating our vendor allowances during the last three years. Based on current knowledge, we do not believe there is a reasonable likelihood that there will be a material change in the estimates or assumptions used to determine vendor allowances.
|
|
|
Liability for closed locations -
|
|
|
The liability is based on the present value of future rent obligations and other related costs (net of estimated sublease rent) to the first lease option date. We have not made any material changes to the method of estimating our liability for closed locations during the last three years. Based on current knowledge, we do not believe there is a reasonable likelihood that there will be a material change in the estimates or assumptions used to determine the liability.
|
|
|
Liability for insurance claims -
|
|
|
The liability for insurance claims is recorded based on estimates for claims incurred and is not discounted. The provisions are estimated in part by considering historical claims experience, demographic factors and other actuarial assumptions. We have not made any material changes to the method of estimating our liability for insurance claims during the last three years. Based on current knowledge, we do not believe there is a reasonable likelihood that there will be a material change in the estimates or assumptions used to determine the liability.
|
|
|
Cost of sales -
|
|
|
Drugstore cost of sales is derived based on point-of-sale scanning information with an estimate for shrinkage and adjusted based on periodic inventories. Inventories are valued at the lower of cost or market determined by the last-in, first-out (LIFO) method. We have not made any material changes to the method of estimating cost of sales during the last three years. Based on current knowledge, we do not believe there is a reasonable likelihood that there will be a material change in the estimates or assumptions used to determine cost of sales.
|
|
|
Income taxes -
|
|
|
We are subject to routine income tax audits that occur periodically in the normal course of business. U.S. federal, state and local and foreign tax authorities raise questions regarding our tax filing positions, including the timing and amount of deductions and the allocation of income among various tax jurisdictions. In evaluating the tax benefits associated with our various tax filing positions, we record a tax benefit for uncertain tax positions using the highest cumulative tax benefit that is more likely than not to be realized. Adjustments are made to our liability for unrecognized tax benefits in the period in which we determine the issue is effectively settled with the tax authorities, the statute of limitations expires for the return containing the tax position or when more information becomes available. Our liability for unrecognized tax benefits, including accrued penalties and interest, is included in other long-term liabilities on our consolidated balance sheets and in income tax expense in our consolidated statements of earnings.
In determining our provision for income taxes, we use an annual effective income tax rate based on full-year income, permanent differences between book and tax income, and statutory income tax rates. The effective income tax rate also reflects our assessment of the ultimate outcome of tax audits. Discrete events such as audit settlements or changes in tax laws are recognized in the period in which they occur. Based on current knowledge, we do not believe there is a reasonable likelihood that there will be a material change in the estimates or assumptions used to determine the amounts recorded for income taxes.
|
|
|
Drugstores
|
Worksites
|
Home Care
|
Specialty Pharmacy
|
Mail Service
|
Total
|
|||||||||||||||||||
|
August 31, 2010
|
7,562 | 367 | 101 | 14 | 2 | 8,046 | ||||||||||||||||||
|
New/Relocated
|
109 | 5 | - | 1 | - | 115 | ||||||||||||||||||
|
Acquired
|
12 | - | 4 | - | - | 16 | ||||||||||||||||||
|
Closed/Replaced
|
(32 | ) | (2 | ) | (5 | ) | (5 | ) | - | (44 | ) | |||||||||||||
|
November 30, 2010
|
7,651 | 370 | 100 | 10 | 2 | 8,133 | ||||||||||||||||||
|
Rating Agency
|
Long-Term Debt Rating
|
Outlook
|
Commercial Paper Rating
|
Outlook
|
||||||
|
Moody's
|
A2 |
Stable
|
P-1 |
Stable
|
||||||
|
Standard & Poor's
|
A |
Stable
|
A-1 |
Stable
|
||||||
|
Payments Due by Period (In millions)
|
||||||||||||||||||||
|
Total
|
Less than 1 Year
|
1-3 Years
|
3-5 Years
|
Over 5 Years
|
||||||||||||||||
|
Operating leases (1)
|
$ | 36,107 | $ | 2,286 | $ | 4,587 | $ | 4,398 | $ | 24,836 | ||||||||||
|
Purchase obligations (2):
|
||||||||||||||||||||
|
Open inventory purchase orders
|
1,579 | 1,579 | - | - | - | |||||||||||||||
|
Real estate development
|
353 | 189 | 140 | 24 | - | |||||||||||||||
|
Other corporate obligations
|
851 | 375 | 363 | 93 | 20 | |||||||||||||||
|
Long-term debt*(3)
|
2,354 | 9 | 1,304 | 9 | 1,032 | |||||||||||||||
|
Interest payment on long-term debt
|
636 | 113 | 232 | 105 | 186 | |||||||||||||||
|
Insurance*
|
574 | 226 | 175 | 83 | 90 | |||||||||||||||
|
Retiree health*
|
446 | 12 | 27 | 33 | 374 | |||||||||||||||
|
Closed location obligations*
|
151 | 42 | 39 | 22 | 48 | |||||||||||||||
|
Capital lease obligations *(1)
|
95 | 4 | 6 | 6 | 79 | |||||||||||||||
|
Other long-term liabilities reflected on the balance sheet*(4)
|
895 | 94 | 184 | 152 | 465 | |||||||||||||||
|
Total
|
$ | 44,041 | $ | 4,929 | $ | 7,057 | $ | 4,925 | $ | 27,130 | ||||||||||
|
(1)
|
Amounts for operating leases and capital leases do not include certain operating expenses under the leases such as common area maintenance, insurance and real estate taxes. These expenses for the Company's most recent fiscal year were $375 million.
|
|
(2)
|
The purchase obligations include agreements to purchase goods or services that are enforceable and legally binding and that specify all significant terms, including open purchase orders.
|
|
(3)
|
Total long-term debt on the Consolidated Condensed Balance Sheet includes a $51 million fair market value adjustment and $7 million of unamortized discount.
|
|
(4)
|
Includes $79 million ($31 million due in 1-3 years, $34 million due in 3-5 years and $14 million due in over 5 years) of unrecognized tax benefits recorded under ASC topic 740.
|
|
Insurance
|
$ | 233 | ||
|
Inventory obligations
|
83 | |||
|
Real estate development
|
19 | |||
|
Total
|
$ | 335 |
|
PART II. OTHER INFORMATION
|
|
Item 2. UNREGISTERED SALES OF EQUITY SECURITIES AND USE OF PROCEEDS
|
|
(c)
|
The following table provides information about purchases by the Company during the quarter ended November 30, 2010 of equity securities that are registered by the Company pursuant to Section 12 of the Exchange Act:
|
|
Issuer Purchases of Equity Securities
|
||||||||||||||||||
|
Period
|
Total Number of
Shares Purchased (1)
|
Average Price
Paid per Share
|
Total Number of Shares Purchased as Part of Publicly Announced Repurchase
Programs (2)
|
Approximate Dollar Value of Shares that May Yet Be Purchased Under the Plans or
Program (2)
|
||||||||||||||
|
9/1/2010 – 9/30/2010
|
12,361,469 | $ | 29.12 | 12,361,469 | $ | - | ||||||||||||
|
10/1/2010 - 10/31/2010
|
- | $ | - | - | $ | 1,000,000,000 | ||||||||||||
|
11/1/2010 -
11/30/2010
|
4,316,600 | $ | 34.68 | 4,316,600 | $ | 850,317,849 | ||||||||||||
|
Total
|
16,678,069 | $ | 30.56 | 16,678,069 | $ | 850,317,849 | ||||||||||||
| (1) |
The Company did not purchase any shares of its common stock in open-market transactions to satisfy the requirements of the Company's employee stock purchase and option plans, as well as the Company's Nonemployee Director Stock Plan.
|
|||||||||||||||
| (2) |
On October 14, 2009, the Board of Directors approved a share repurchase program (2009 repurchase program). The 2009 repurchase program, which was completed in September 2010, authorized the repurchase of up to $2,000 million of the Company’s common stock prior to its expiration on December 31, 2013. On October 13, 2010, the Board of Directors approved a new share repurchase program (2011 repurchase program) which allows for the repurchase of up to $1,000 million of the Company’s common stock prior to its expiration on December 31, 2012. The total remaining authorization under the 2011 repurchase program is $850 million as of November 30, 2010.
|
|||||||||||||||
| * | Management contract or compensatory plan or arrangement. |
| ** | In accordance with Rule 406T under Regulation S-T, the XBRL-related information in Exhibit 101 to this Annual Report on Form 10-K shall be deemed to be “furnished” and not “filed”. |
|
WALGREEN CO.
|
|
|
(Registrant)
|
|
|
Dated: 1/03/11
|
/s/ W.D. Miquelon
|
|
W.D. Miquelon
|
|
|
Executive Vice President
|
|
|
(Chief Financial Officer)
|
|
|
Dated: 1/03/11
|
/s/ M.M. Scholz
|
|
M.M. Scholz
|
|
|
Controller
|
|
|
(Chief Accounting Officer)
|
|
|
Three Months Ended
|
Fiscal Year Ended
|
|||||||||||
|
11/30/2010
|
11/30/2009
|
8/31/2010
|
||||||||||
|
Income before income taxes and minority interest
|
$ | 921 | $ | 776 | $ | 3,373 | ||||||
|
Add:
|
||||||||||||
|
Minority interest
|
- | - | - | |||||||||
|
Fixed charges
|
291 | 263 | 1,100 | |||||||||
|
Less: Capitalized interest
|
(3 | ) | (3 | ) | (12 | ) | ||||||
|
Earnings as defined
|
$ | 1,209 | $ | 1,036 | $ | 4,461 | ||||||
|
Interest expense, net of capitalized interest
|
$ | 20 | $ | 21 | $ | 90 | ||||||
|
Capitalized interest
|
3 | 3 | 12 | |||||||||
|
Portions of rentals representative of the interest factor
|
268 | 239 | 998 | |||||||||
|
Fixed charges as defined
|
$ | 291 | $ | 263 | $ | 1,100 | ||||||
|
Ratio of earnings to fixed charges
|
4.2 | 3.94 | 4.06 | |||||||||
|
1.
|
I have reviewed this quarterly report on Form 10-Q of Walgreen Co.;
|
|||
|
2.
|
Based on my knowledge, this report does not contain any untrue statement of a material fact or omit to state a material fact necessary to make the statements made, in light of the circumstances under which such statements were made, not misleading with respect to the period covered by this report;
|
|||
|
3.
|
Based on my knowledge, the financial statements, and other financial information included in this report, fairly present in all material respects the financial condition, results of operations and cash flows of the registrant as of, and for, the periods presented in this report;
|
|||
|
4.
|
The registrant's other certifying officer(s) and I are responsible for establishing and maintaining disclosure controls and procedures (as defined in Exchange Act Rules 13a-15(e) and 15d-15(e)) and internal control over financial reporting (as defined in Exchange Act Rule 13a-15(f) and 15d-15(f)) for the registrant and have:
|
|||
|
a)
|
Designed such disclosure controls and procedures, or caused such disclosure controls and procedures to be designed under our supervision, to ensure that material information relating to the registrant, including its consolidated subsidiaries, is made known to us by others within those entities, particularly during the period in which this report is being prepared;
|
|||
|
b)
|
Designed such internal control over financial reporting, or caused such internal control over financial reporting to be designed under our supervision, to provide reasonable assurance regarding the reliability of financial reporting and the preparation of financial statements for external purposes in accordance with generally accepted accounting principles;
|
|||
|
c)
|
Evaluated the effectiveness of the registrant's disclosure controls and procedures and presented in this report our conclusions about the effectiveness of the disclosure controls and procedures, as of the end of the period covered by this report based on such evaluation; and
|
|||
|
d)
|
Disclosed in this report any change in the registrant's internal control over financial reporting that occurred during the registrant's most recent fiscal quarter (the registrant's fourth fiscal quarter in the case of an annual report) that has materially affected, or is reasonably likely to materially affect, the registrant's internal control over financial reporting; and
|
|||
|
5.
|
The registrant's other certifying officer(s) and I have disclosed, based on our most recent evaluation of internal control over financial reporting, to the registrant's auditors and the audit committee of the registrant's board of directors (or persons performing the equivalent functions):
|
|||
|
a)
|
All significant deficiencies and material weaknesses in the design or operation of internal control over financial reporting which are reasonably likely to adversely affect the registrant's ability to record, process, summarize and report financial information; and
|
|||
|
b)
|
Any fraud, whether or not material, that involves management or other employees who have a significant role in the registrant's internal control over financial reporting.
|
|||
|
/s/
|
Gregory D. Wasson
|
President and Chief Executive Officer
|
Date: January 3, 2011
|
|
|
Gregory D. Wasson
|
||||
|
1.
|
I have reviewed this quarterly report on Form 10-Q of Walgreen Co.;
|
|||
|
2.
|
Based on my knowledge, this report does not contain any untrue statement of a material fact or omit to state a material fact necessary to make the statements made, in light of the circumstances under which such statements were made, not misleading with respect to the period covered by this report;
|
|||
|
3.
|
Based on my knowledge, the financial statements, and other financial information included in this report, fairly present in all material respects the financial condition, results of operations and cash flows of the registrant as of, and for, the periods presented in this report;
|
|||
|
4.
|
The registrant's other certifying officer(s) and I are responsible for establishing and maintaining disclosure controls and procedures (as defined in Exchange Act Rules 13a-15(e) and 15d-15(e)) and internal control over financial reporting (as defined in Exchange Act Rule 13a-15(f) and 15d-15(f)) for the registrant and have:
|
|||
|
a)
|
Designed such disclosure controls and procedures, or caused such disclosure controls and procedures to be designed under our supervision, to ensure that material information relating to the registrant, including its consolidated subsidiaries, is made known to us by others within those entities, particularly during the period in which this report is being prepared;
|
|||
|
b)
|
Designed such internal control over financial reporting, or caused such internal control over financial reporting to be designed under our supervision, to provide reasonable assurance regarding the reliability of financial reporting and the preparation of financial statements for external purposes in accordance with generally accepted accounting principles;
|
|||
|
c)
|
Evaluated the effectiveness of the registrant's disclosure controls and procedures and presented in this report our conclusions about the effectiveness of the disclosure controls and procedures, as of the end of the period covered by this report based on such evaluation; and
|
|||
|
d)
|
Disclosed in this report any change in the registrant's internal control over financial reporting that occurred during the registrant's most recent fiscal quarter (the registrant's fourth fiscal quarter in the case of an annual report) that has materially affected, or is reasonably likely to materially affect, the registrant's internal control over financial reporting; and
|
|||
|
5.
|
The registrant's other certifying officer(s) and I have disclosed, based on our most recent evaluation of internal control over financial reporting, to the registrant's auditors and the audit committee of the registrant's board of directors (or persons performing the equivalent functions):
|
|||
|
a)
|
All significant deficiencies and material weaknesses in the design or operation of internal control over financial reporting which are reasonably likely to adversely affect the registrant's ability to record, process, summarize and report financial information; and
|
|||
|
b)
|
Any fraud, whether or not material, that involves management or other employees who have a significant role in the registrant's internal control over financial reporting.
|
|||
|
/s/
|
Wade D. Miquelon
|
Executive Vice President and Chief Financial Officer
|
Date: January 3, 2011
|
|
|
Wade D. Miquelon
|
||||