XML 108 R15.htm IDEA: XBRL DOCUMENT v2.4.1.9
Acquisitions
6 Months Ended
Feb. 28, 2015
Acquisitions [Abstract]  
Acquisitions
7. Acquisitions
Alliance Boots
The Second Step Transaction closed on December 31, 2014, resulting in the acquisition by the Company of 55% of the issued and outstanding share capital of Alliance Boots, increasing its interest to 100%. (See Note 1, Organization, and Note 2, Basis of Presentation.) The Company previously accounted for its 45% interest in Alliance Boots as an equity method investment. As a result of the Second Step Transaction, the Company significantly expanded its operations to include pharmacy-led health and beauty retailing and pharmaceutical wholesaling and distribution businesses in major international markets.

As a result of the closing of the Second Step Transaction, the Company increased its interest in WBAD, a 50/50 joint venture between Walgreens and Alliance Boots, to 100%. Because Walgreens held, prior to the Second Step Transaction, a 50% direct interest and an additional indirect interest in WBAD through its 45% ownership of Alliance Boots, the financial results of WBAD were fully consolidated into the Walgreens consolidated financial statements with the remaining 27.5% effective interest being recorded as a noncontrolling interest. The acquisition of the 27.5% noncontrolling interest has been accounted for as an equity transaction with no gain or loss recorded in the statement of earnings under ASC Topic 805, Business Combinations. On January 1, 2015, WBAD Holdings Limited sold 320 common shares of WBAD, representing approximately 5% of the equity interests in WBAD, to Alliance Healthcare Italia Distribuzione S.p.A. ("AHID"), which is not a member of the Company's consolidated group. Under certain circumstances, AHID has the right to put, and WBAD Holdings Limited has the right to call, the 320 common shares of WBAD currently owned by AHID for a purchase price of $100,000.

The total purchase price of the Second Step Transaction of $15.9 billion included £3.133 billion in cash (approximately $4.9 billion at the December 31, 2014 spot rate of $1.56 to £1.00) and 144.3 million of the Company's common shares at a fair value of $11.0 billion (based on the December 30, 2014 closing market price of $76.05). Of the total purchase price, $13.3 billion was preliminarily allocated to acquire the 55% ownership interest in Alliance Boots and $2.6 billion was preliminarily allocated to acquire the noncontrolling interest in WBAD. The purchase price attributed to the acquisition of the noncontrolling interest in WBAD was determined based on the relative fair value of Alliance Boots and WBAD, respectively.

The preliminary impact of the equity transaction is as follows (in millions):

  
Amount
 
Consideration attributable to WBAD
 
$
2,569
 
Less:  Carrying value of the Company's pre-existing noncontrolling interest
  
130
 
Impact to additional paid in capital
 
$
2,439
 

As of February 28, 2015, the Company had not completed the analysis to assign fair values to all tangible and intangible assets acquired and therefore the purchase price allocation for Alliance Boots and WBAD has not been completed. The preliminary purchase price allocation will be subject to further refinement and may result in material changes. These changes will primarily relate to the allocation of consideration and the fair value assigned to all tangible and intangible assets acquired and identified. The following table summarizes the consideration paid to acquire the remaining 55% interest in Alliance Boots and the preliminary amounts of identified assets acquired and liabilities assumed at the date of the Second Step Transaction (in millions).
 

Consideration paid
  
Cash
 
$
4,874
 
Common stock
  
10,977
 
Total consideration transferred
  
15,851
 
Less: consideration attributed to WBAD
  
(2,569
)
   
13,282
 
Fair value of the investment in Alliance Boots held before the Second Step Transaction
  
8,290
 
Total consideration
 
$
21,572
 
 
Identifiable assets acquired and liabilities assumed including noncontrolling interests
    
Cash and cash equivalents
 
$
413
 
Accounts receivable
  
3,805
 
Inventories
  
3,713
 
Other current assets
  
902
 
Property, plant and equipment
  
3,774
 
Intangible assets
  
11,461
 
Other non-current assets
  
1,760
 
Trade accounts payable, accrued expenses and other liabilities
  
(7,722
)
Borrowings
  
(8,999
)
Deferred income taxes
  
(2,437
)
Other non-current liabilities
  
(456
)
Noncontrolling interests
  
(198
)
Total identifiable net assets and noncontrolling interests
  
6,016
 
Goodwill
 
$
15,556
 

As a result of the Company acquiring the remaining 55% interest in Alliance Boots, the Company's previously held 45% interest was remeasured to fair value, resulting in a gain of $706 million. This gain has been recognized as Gain on previously held equity interest in the Consolidated Condensed Statements of Earnings. This gain is preliminary and may be subject to change as the Company finalizes purchase accounting.

The fair value of the previously held equity interest of $8.3 billion in Alliance Boots was determined using the Income Approach methodology.  The fair value measurement of the previously held equity interest is based on significant inputs not observable in the market, and thus represents Level 3 measurements. The fair value estimates for the previously held equity interest are based on (a) projected discounted cash flows, (b) historical and projected financial information, and (c) synergies including cost savings, as relevant, that market participants would consider when estimating the fair value of the previously held equity interest in Alliance Boots. The fair value for trade names and trademarks was determined using the relief from royalty method of the income approach; pharmacy licenses and customer relationships used the excess earnings method of the income approach; and loyalty card holders used the incremental cash flow method which is a form of the income approach. Personal property fair values were determined primarily using the indirect cost approach. While real property fair values were determined using the income, market and/or cost approach.

The preliminary identified definite and indefinite lived intangible assets were as follows:

Definite-Lived Intangible Assets
 
Weighted-Average
Useful Life
(in years)
  
Amount
(in millions)
 
Customer relationships
  
12
  
$
1,676
 
Loyalty card holders
  
12
   
723
 
Trade names and trademarks
  
15
   
544
 
Favorable lease interests
  
3
   
55
 
Total
     
$
2,998
 

Indefinite-Lived Intangible Assets
 
Amount
(in millions)
 
Trade names and trademarks
 
$
6,192
 
Pharmacy licenses
  
2,271
 
Total
 
$
8,463
 

The preliminary goodwill of $15.6 billion arising from the Second Step Transaction consists of expected purchasing synergies, operating efficiencies by benchmarking performance and applying best practices across the combined company, consolidation of operations, reductions in selling, general and administrative expenses and combining workforces. The Company determined that the preliminary goodwill should be allocated across all segments because each segment will benefit from synergies related to the acquisition that will increase each segment’s overall profitability. The Company determined that $4.7 billion of preliminary goodwill arising from synergies was directly attributable to the Retail Pharmacy USA segment. The Company also allocated $3.6 billion of preliminary goodwill from the acquisition to the Retail Pharmacy USA segment based on a with and without analysis whereby the difference between the fair value of a segment before the acquisition and its fair value after the acquisition represents the amount of goodwill assigned to that segment. Of the remaining preliminary goodwill, $3.8 billion was allocated to the Retail Pharmacy International segment and $3.5 billion was allocated to the Pharmaceutical Wholesale segment. The allocation of the goodwill to the individual reporting units within the respective segments has not been completed. Substantially all of the goodwill recognized is not expected to be deductible for income tax purposes.

The Company incurred legal and other professional services costs related to the Second Step Transaction, which were included in selling, general and administrative expenses, of $59 million and $83 million for the three and six month periods ended February 28, 2015.

The preliminary fair value of the assets acquired includes inventory having an estimated fair value of $3.7 billion. This fair value includes a $106 million "step-up" adjustment to capitalize the estimated profit in acquired finished goods inventory as of the date of the Second Step Transaction, all of which was expensed to cost of sales during the three and six months ended February 28, 2015 over the first inventory turn.

The following table presents supplemental unaudited condensed pro forma consolidated statements of earnings for 2015 and 2014 as if the Second Step Transaction had occurred on September 1, 2013, the first day of the Company's fiscal 2014. As described in Note 3, Change in Accounting Policy, the information has been presented without a lag. The unaudited condensed pro forma statements reflect certain adjustments related to past operating performance and acquisition accounting adjustments, such as increased amortization expense based on the fair valuation of assets acquired, the impact of acquisition financing, transaction costs and the related income tax effects. The unaudited condensed pro forma statements do not include any anticipated synergies which may be achievable subsequent to the date of the Second Step Transaction. The unaudited condensed pro forma statements also exclude certain non-recurring items such as the gain on Walgreens previously held 45% investment in Alliance Boots and other transaction related costs. Accordingly, the unaudited condensed pro forma results have been prepared for comparative purposes only and are not intended to be indicative of what the Company's results would have been had the Second Step Transaction occurred at the beginning of the periods presented or the results which may occur in the future.

  
Pro forma
Three months ended
February 28,
  
Pro forma
Six months ended
February 28,
 
  
2015
  
2014
  
2015
  
2014
 
(in millions, except per share amounts)
        
Net sales
 
$
30,202
  
$
29,276
  
$
59,173
  
$
56,999
 
Net earnings
  
1,253
   
966
   
2,621
   
1,973
 
                 
Net earnings per common share:
                
Basic
 
$
1.20
  
$
0.88
  
$
2.51
  
$
1.80
 
Diluted
  
1.19
   
0.87
   
2.49
   
1.78
 

Actual results from Alliance Boots operations included in the Consolidated Condensed Statements of Earnings since December 31, 2014, the date of the Second Step Transaction, are as follows (in millions, except per share amounts):

  
Three months ended
February 28,
  
Six months ended
February 28,
 
  
2015
  
2015
 
(in millions, except per share amounts)
    
Net sales
 
$
5,525
  
$
5,525
 
Net earnings
  
330
   
330
 
         
Net earnings per common share:
        
Basic
 
$
0.32
  
$
0.33
 
Diluted
  
0.31
   
0.33
 

Other Acquisitions
The aggregate purchase price of all businesses, excluding Alliance Boots, net of cash received was $92 million for the six month period ended February 28, 2015. These acquisitions added $23 million to goodwill and $64 million to intangible assets, primarily pharmacy files. The remaining fair value relates to immaterial amounts of tangible assets, less liabilities assumed. Operating results of the businesses acquired have been included in the Consolidated Condensed Statements of Earnings from their respective acquisition dates forward. Pro forma results of the Company, assuming all of the acquisitions had occurred at the beginning of each period presented, would not be materially different from the results reported.