CONSTELLATION
BRANDS, INC. AND SUBSIDIARIES
|
|||||||||||||
UNAUDITED
PRO FORMA CONDENSED COMBINED BALANCE SHEET
|
|||||||||||||
AS
OF MAY 31, 2006
|
|||||||||||||
(in
millions)
|
|||||||||||||
Historical
|
Pro
Forma
|
Pro
Forma
|
|||||||||||
Constellation
|
Adjustments
|
Combined
|
|||||||||||
ASSETS
|
|||||||||||||
CURRENT
ASSETS:
|
|||||||||||||
Cash
and cash investments
|
$
|
37.5
|
$
|
(0.1
|
)
|
(a
|
)
|
$
|
37.4
|
||||
Accounts
receivable, net
|
854.2
|
(103.7
|
)
|
(a
|
)
|
750.5
|
|||||||
Inventories
|
1,751.1
|
(56.9
|
)
|
(a
|
)
|
1,694.2
|
|||||||
Prepaid
expenses and other
|
278.7
|
(66.3
|
)
|
(a
|
)
|
212.4
|
|||||||
Total
current assets
|
2,921.5
|
(227.0
|
)
|
2,694.5
|
|||||||||
PROPERTY,
PLANT AND EQUIPMENT, net
|
1,442.7
|
(1.0
|
)
|
(a
|
)
|
1,441.7
|
|||||||
GOODWILL
|
2,204.1
|
(13.0
|
)
|
(a
|
)
|
2,191.1
|
|||||||
INTANGIBLE
ASSETS, net
|
886.9
|
(14.2
|
)
|
(a
|
)
|
872.7
|
|||||||
OTHER
ASSETS, net
|
216.3
|
(0.1
|
)
|
(a
|
)
|
386.6
|
|||||||
170.4
|
(b
|
)
|
|
||||||||||
Total
assets
|
$
|
7,671.5
|
$
|
(84.9
|
)
|
$
|
7,586.6
|
||||||
LIABILITIES
AND STOCKHOLDERS' EQUITY
|
|||||||||||||
CURRENT
LIABILITIES:
|
|||||||||||||
Notes
payable to banks
|
$
|
164.3
|
$
|
-
|
$
|
164.3
|
|||||||
Current
maturities of long-term debt
|
214.3
|
-
|
214.3
|
||||||||||
Accounts
payable
|
365.0
|
(24.1
|
)
|
(a
|
)
|
340.9
|
|||||||
Accrued
excise taxes
|
68.2
|
(8.9
|
)
|
(a
|
)
|
59.3
|
|||||||
Other
accrued expenses and liabilities
|
625.3
|
(51.9
|
)
|
(a
|
)
|
573.4
|
|||||||
Total
current liabilities
|
1,437.1
|
(84.9
|
)
|
1,352.2
|
|||||||||
LONG-TERM
DEBT, less current maturities
|
2,481.8
|
-
|
2,481.8
|
||||||||||
DEFERRED
INCOME TAXES
|
373.6
|
-
|
373.6
|
||||||||||
OTHER
LIABILITIES
|
259.0
|
-
|
259.0
|
||||||||||
STOCKHOLDERS'
EQUITY
|
3,120.0
|
-
|
3,120.0
|
||||||||||
Total
liabilities and stockholders' equity
|
$
|
7,671.5
|
$
|
(84.9
|
)
|
$
|
7,586.6
|
||||||
See
Notes to the Unaudited Pro Forma Statements
|
CONSTELLATION
BRANDS, INC. AND SUBSIDIARIES
|
|||||||||||||
UNAUDITED
PRO FORMA COMBINED STATEMENT OF INCOME
|
|||||||||||||
FOR
THE YEAR ENDED FEBRUARY 28, 2006
|
|||||||||||||
(in
millions, except per share data)
|
|||||||||||||
Historical
|
Pro
Forma
|
Pro
Forma
|
|||||||||||
Constellation
|
Adjustments
|
Combined
|
|||||||||||
SALES
|
$
|
5,706.9
|
$
|
(1,135.4
|
)
|
(c
|
)
|
$
|
4,571.5
|
||||
Less
- Excise taxes
|
(1,103.5
|
)
|
91.9
|
(c
|
)
|
(1,011.6
|
)
|
||||||
Net
sales
|
4,603.4
|
(1,043.5
|
)
|
3,559.9
|
|||||||||
COST
OF PRODUCT SOLD
|
(3,278.8
|
)
|
753.7
|
(c
|
)
|
(2,525.1
|
)
|
||||||
Gross
profit
|
1,324.6
|
(289.8
|
)
|
1,034.8
|
|||||||||
SELLING,
GENERAL AND ADMINISTRATIVE
EXPENSES
|
(612.4
|
)
|
70.6
|
(c)
(d
|
)
|
(541.8
|
)
|
||||||
RESTRUCTURING
AND RELATED CHARGES
|
(29.3
|
)
|
-
|
(29.3
|
)
|
||||||||
ACQUISITION-RELATED
INTEGRATION COSTS
|
(16.8
|
)
|
-
|
(16.8
|
)
|
||||||||
Operating
income
|
666.1
|
(219.2
|
)
|
446.9
|
|||||||||
EQUITY
IN EARNINGS (LOSS) OF EQUITY
METHOD
INVESTEES
|
0.8
|
220.8
|
(e
|
)
|
221.6
|
||||||||
GAIN
ON CHANGE IN FAIR VALUE OF
DERIVATIVE
INSTRUMENT
|
-
|
-
|
-
|
||||||||||
INTEREST
EXPENSE, net
|
(189.6
|
)
|
(1.6
|
)
|
(c
|
)
|
(191.2
|
)
|
|||||
Income
before income taxes
|
477.3
|
0.0
|
477.3
|
||||||||||
PROVISION
FOR INCOME TAXES
|
(152.0
|
)
|
-
|
(f | ) |
(152.0
|
)
|
||||||
NET
INCOME
|
325.3
|
0.0
|
325.3
|
||||||||||
Dividends
on preferred stock
|
(9.8
|
)
|
-
|
(9.8
|
)
|
||||||||
INCOME
AVAILABLE TO COMMON
STOCKHOLDERS
|
$
|
315.5
|
$
|
0.0
|
$
|
315.5
|
|||||||
SHARE
DATA:
|
|||||||||||||
Earnings
per common share:
|
|||||||||||||
Basic
- Class A Common Stock
|
$
|
1.44
|
$
|
1.44
|
|||||||||
Basic
- Class B Common Stock
|
$
|
1.31
|
$
|
1.31
|
|||||||||
Diluted
|
$
|
1.36
|
$
|
1.36
|
|||||||||
Weighted
average common shares outstanding:
|
|||||||||||||
Basic
- Class A Common Stock
|
196.907
|
196.907
|
|||||||||||
Basic
- Class B Common Stock
|
23.904
|
23.904
|
|||||||||||
Diluted
|
238.707
|
238.707
|
|||||||||||
See
Notes to the Unaudited Pro Forma Statements
|
CONSTELLATION
BRANDS, INC. AND SUBSIDIARIES
|
|||||||||||||
UNAUDITED
PRO FORMA COMBINED STATEMENT OF INCOME
|
|||||||||||||
FOR
THE THREE MONTHS ENDED MAY 31, 2006
|
|||||||||||||
(in
millions, except per share data)
|
|||||||||||||
Historical
|
Pro
Forma
|
Pro
Forma
|
|||||||||||
Constellation
|
Adjustments
|
Combined
|
|||||||||||
SALES
|
$
|
1,430.2
|
$
|
(334.8
|
)
|
(c
|
)
|
$
|
1,095.4
|
||||
Less
- Excise taxes
|
(274.3
|
)
|
26.7
|
(c
|
)
|
(247.6
|
)
|
||||||
Net
sales
|
1,155.9
|
(308.1
|
)
|
847.8
|
|||||||||
COST
OF PRODUCT SOLD
|
(837.3
|
)
|
222.8
|
(c
|
)
|
(614.5
|
)
|
||||||
Gross
profit
|
318.6
|
(85.3
|
)
|
233.3
|
|||||||||
SELLING,
GENERAL AND ADMINISTRATIVE
EXPENSES
|
(172.6
|
)
|
20.2
|
(c)
(d
|
)
|
(152.4
|
)
|
||||||
RESTRUCTURING
AND RELATED CHARGES
|
(2.3
|
)
|
-
|
(2.3
|
)
|
||||||||
ACQUISITION-RELATED
INTEGRATION COSTS
|
(0.7
|
)
|
-
|
(0.7
|
)
|
||||||||
Operating
income
|
143.0
|
(65.1
|
)
|
77.9
|
|||||||||
EQUITY
IN EARNINGS (LOSS) OF EQUITY
METHOD
INVESTEES
|
0.1
|
65.7
|
(e
|
)
|
65.8
|
||||||||
GAIN
ON CHANGE IN FAIR VALUE OF
DERIVATIVE
INSTRUMENT
|
52.5
|
-
|
52.5
|
||||||||||
INTEREST
EXPENSE, net
|
(48.7
|
)
|
(0.6
|
)
|
(c
|
)
|
(49.3
|
)
|
|||||
Income
before income taxes
|
146.9
|
(0.0
|
)
|
146.9
|
|||||||||
PROVISION
FOR INCOME TAXES
|
(61.4
|
)
|
-
|
(f | ) |
(61.4
|
)
|
||||||
NET
INCOME
|
85.5
|
(0.0
|
)
|
85.5
|
|||||||||
Dividends
on preferred stock
|
(2.5
|
)
|
-
|
(2.5
|
)
|
||||||||
INCOME
AVAILABLE TO COMMON
STOCKHOLDERS
|
$
|
83.0
|
$
|
(0.0
|
)
|
$
|
83.0
|
||||||
SHARE
DATA:
|
|||||||||||||
Earnings
per common share:
|
|||||||||||||
Basic
- Class A Common Stock
|
$
|
0.38
|
$
|
0.38
|
|||||||||
Basic
- Class B Common Stock
|
$
|
0.34
|
$
|
0.34
|
|||||||||
Diluted
|
$
|
0.36
|
$
|
0.36
|
|||||||||
Weighted
average common shares outstanding:
|
|||||||||||||
Basic
- Class A Common Stock
|
199.571
|
199.571
|
|||||||||||
Basic
- Class B Common Stock
|
23.853
|
23.853
|
|||||||||||
Diluted
|
240.100
|
240.100
|
|||||||||||
See
Notes to the Unaudited Pro Forma Statements
|
(a) |
Reflects
the elimination of the net assets being contributed by the Barton
beer
business to the joint venture for a 50% interest in the joint venture
as
of May 31, 2006.
|
(b) |
Reflects
the recording of the Company’s 50% interest in the joint venture as an
equity method investment equal to the net assets being contributed
in (a)
above. The equity method investment is classified in “Other assets, net”
in the condensed combined balance sheet as of May 31,
2006.
|
(c) |
Reflects
the elimination of sales, cost of product sold, operating expenses,
and
interest income attributable to the historical Barton beer business
to be
disposed of in exchange for a 50% interest in the formation of the
joint
venture with Diblo for the periods
presented.
|
(d) |
Reflects
adjustments to selling, general and administrative expenses calculated
as
direct Barton selling and marketing expenses, plus designating certain
general and administrative expenses from the Constellation Beers
and
Spirits segment that relate to the Barton beer business
for the periods presented. The administrative and support services
designated to the Barton beer business include financial reporting
and
accounting, payroll processing, billing and collection, legal, human
resource support, information technology, facilities costs, and executive
management. The designation of these expenses to the Barton beer
business
were calculated based on the following: (i) specific identification
of
certain costs; (ii) employee headcount in relation to beers and spirits
functions; (iii) facility square footage occupied by beers and spirits
personnel; and (iv) information technology user costs by beer related
personnel. The designation of these general and administrative expenses
reflect costs expected to impact the pending joint venture operations
and
those costs expected to have a continuing impact on the Company’s ongoing
operations.
|
(e) |
Reflects
the Company’s earnings in the joint venture related to its 50% equity
interest for the periods presented. As the historical results of
operations of the assets contributed by Diblo are not readily available,
the joint venture earnings are based upon the historical results
of
operations of the contributed Barton beer business. In addition,
the joint
venture earnings are based upon (i) the understanding that both Diblo
and
Barton are contributing assets of equal value and (ii) certain provisions
in the Joint Venture Agreement are structured with the intent and
expectation that Barton would maintain its historical market position
and
historical profit levels related to the selling of imported beer
products
in the United States.
|
(f) |
Reflects
no income tax expense related directly to the joint venture for the
periods presented as this entity is expected to be operated as a
limited
liability company. The joint venture will be treated as a partnership
for
both federal and state income tax purposes and income tax expense
(benefit) will be recorded by the Company based on the equity in
earnings
(loss) of the joint venture.
|