Attached files

file filename
8-K/A - 8-K/A - OMNICELL, Inca12-15583_18ka.htm
EX-99.1 - EX-99.1 - OMNICELL, Inca12-15583_1ex99d1.htm
EX-23.1 - EX-23.1 - OMNICELL, Inca12-15583_1ex23d1.htm

Exhibit 99.2

 

Unaudited Pro Forma Condensed Combined Financial Statements

 

On May 21, 2012, Omnicell, Inc. (“Omnicell”), completed its merger with MedPak Holdings, Inc. (“MedPak”) pursuant to an Agreement and Plan of Merger (the “Merger Agreement”) under which Mercury Acquisition Corp (“Merger Sub”), a newly formed Omnicell subsidiary, was merged with and into MedPak, with MedPak surviving the merger as a wholly-owned subsidiary of Omnicell. MedPak is the parent company of MTS Medication Technologies, Inc., a worldwide provider of medication adherence packaging systems and solutions. On May 21, 2012, MedPak filed a Certificate of Merger with the Secretary of State of the State of Delaware whereupon Merger Sub was merged with and into MedPak.

 

This exhibit provides the unaudited pro forma condensed combined balance sheet as of March 31, 2012, giving effect to the acquisition of MedPak by Omnicell, as if it had been completed on March 31, 2012. Additionally, this exhibit provides the unaudited pro forma condensed combined statements of operations for the twelve months ended December 31, 2011 and the three months ended March 31, 2012, giving effect to the acquisition of MedPak by Omnicell, as if it had been completed on January 1, 2011.

 

The unaudited pro forma condensed combined financial statements are based on the historical consolidated financial statements of Omnicell and MedPak. There were no significant intercompany balances or transactions between Omnicell and MedPak as of the dates and for the periods presented in these unaudited pro forma condensed combined financial statements. Certain reclassification adjustments have been made to conform MedPak’s historical reported balances to the unaudited pro forma condensed combined financial statement’s basis of presentation.

 

The acquisition is reflected in the unaudited pro forma condensed combined financial statements according to the acquisition method required by the Financial Accounting Standards Board’s (FASB) Accounting Standard Codification Topic 805 Business Combinations (“ASC 805”). Under the acquisition method, the acquisition-date fair value of consideration transferred to effect the transaction, as described in Note 2, is allocated to the assets acquired and the liabilities assumed based on their fair values. Omnicell has made significant estimates and assumptions in determining the preliminary allocation of the acquisition consideration in the unaudited pro forma condensed combined financial statements. These estimates are based on key assumptions of the acquisition. Due to the fact that the unaudited pro forma condensed combined financial statements have been prepared based on preliminary estimates, the final amounts recorded may differ materially from the information presented. The initial estimate of acquisition consideration and allocation of the consideration are subject to change based on further review of the fair value of the assets acquired and liabilities assumed. In accordance with ASC 805, any subsequent changes to the acquisition consideration allocation during the acquisition measurement period that result in material changes to our consolidated financial statements will be adjusted retrospectively.

 

These unaudited pro forma condensed combined financial statements should be read in conjunction with the accompanying notes to the unaudited pro forma condensed combined financial statements, and  are prepared by management only for informational purposes in accordance with Article 11 of Regulation S-X and are not necessarily indicative of the financial position or results of operations that would have been realized if the acquisition had been completed on the dates indicated, nor are they indicative of future operating results or financial position. The unaudited pro forma condensed combined financial statements do not give effect to any anticipated synergies, operating efficiencies or cost savings that may be associated with the acquisition  and also do not include any integration costs or any additional expenses that may be incurred.

 



 

OMNICELL, INC.

 

UNAUDITED PRO FORMA CONDENSED COMBINED BALANCE SHEET (1)

AS OF MARCH 31, 2012

(In thousands)

 

 

 

Historical

 

 

 

 

 

 

 

 

 

Omnicell
Inc.

 

MedPak
Holdings
Inc.

 

Pro Forma
Adjustments

 

 

 

Pro
Forma
Combined

 

ASSETS

 

 

 

 

 

 

 

 

 

 

 

Current Assets:

 

 

 

 

 

 

 

 

 

 

 

Cash and Cash Equivalents

 

$

201,420

 

$

1,897

 

$

(160,145

)

(a)

 

$

43,172

 

Short-term Investments

 

8,117

 

 

 

 

 

8,117

 

Accounts Receivable, Net

 

38,973

 

8,305

 

 

 

 

47,278

 

Inventories

 

16,993

 

9,391

 

1,512

 

(b)

 

27,896

 

Prepaid Expenses

 

9,904

 

642

 

 

 

 

10,546

 

Deferred Tax Assets

 

10,352

 

502

 

 

 

 

10,854

 

Other Current Assets

 

6,046

 

 

 

 

 

6,046

 

Total Current Assets

 

291,805

 

20,737

 

(158,633

)

 

 

153,909

 

 

 

 

 

 

 

 

 

 

 

 

 

Property and Equipment, Net

 

17,112

 

9,292

 

1,808

 

(c)

 

28,212

 

Non-Current Net Investment in Sales-Type Leases

 

11,361

 

 

 

 

 

11,361

 

Goodwill

 

28,543

 

11,977

 

70,796

 

(d)

 

111,316

 

Other Intangible Assets

 

4,157

 

10,841

 

72,659

 

(e)

 

87,657

 

Non-Current Deferred Tax Assets

 

11,801

 

 

 

 

 

11,801

 

Other Assets

 

9,149

 

1,286

 

(1,147

)

(f)

 

9,288

 

Total Assets

 

$

373,928

 

$

54,133

 

$

(14,517

)

 

 

$

413,544

 

 

 

 

 

 

 

 

 

 

 

 

 

LIABILITIES AND STOCKHOLDERS’ EQUITY

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Current Liabilities:

 

 

 

 

 

 

 

 

 

 

 

Accounts Payable

 

$

10,610

 

$

6,105

 

$

(2,252

)

(g)

 

$

14,463

 

Accrued Compensation

 

7,727

 

 

1,934

 

(h)

 

9,661

 

Accrued Liabilities

 

8,253

 

 

251

 

(i)

 

8,504

 

Customer Deposits

 

 

251

 

(251

)

(j)

 

 

Deferred Service Revenue

 

19,835

 

 

185

 

(k)

 

20,020

 

Deferred Gross Profit

 

15,877

 

 

 

 

 

15,877

 

Current Maturities of Long-Term Debt

 

 

440

 

(440

)

(l)

 

 

Total Current Liabilities

 

62,302

 

6,796

 

(573

)

 

 

68,525

 

 

 

 

 

 

 

 

 

 

 

 

 

Long-Term Deferred Service Revenue

 

19,003

 

 

 

 

 

19,003

 

Long-Term Debt, Less Current Portion

 

 

41,450

 

(41,450

)

(m)

 

 

Non-Current Deferred Tax Liabilities

 

 

5,992

 

26,997

 

(n)

 

32,989

 

Other Long-Term Liabilities

 

1,733

 

704

 

(300

)

(o)

 

2,137

 

Total Liabilities

 

83,038

 

54,942

 

(15,326

)

 

 

122,654

 

 

 

 

 

 

 

 

 

 

 

 

 

Stockholders’ Equity:

 

 

 

 

 

 

 

 

 

 

 

Total Stockholders’ Equity (deficit)

 

290,890

 

(809

)

809

 

(p)

 

290,890

 

 

 

 

 

 

 

 

 

 

 

 

 

Total Liabilities and Stockholders’ Equity

 

$

373,928

 

$

54,133

 

$

(14,517

)

 

 

$

413,544

 

 

See Notes to Unaudited Pro Forma Condensed Combined Financial Statements

 


(1) Assumes acquisition date of March 31, 2012.

 



 

OMNICELL, INC.

 

UNAUDITED PRO FORMA CONDENSED COMBINED STATEMENT OF OPERATIONS(1)

FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2011

(In thousands, except per share data)

 

 

 

Historical

 

 

 

 

 

 

 

 

 

Omnicell,
Inc.

 

MedPak
Holdings,

Inc.(2)

 

 

 

 

 

 

 

 

 

Twelve
Months
Ended
December 31,

 

Twelve
Months
Ended
March 31, 2012

 

Pro Forma
Adjustments

 

 

 

Pro Forma
Combined

 

Revenues:

 

 

 

 

 

 

 

 

 

 

 

Product

 

$

185,864

 

$

 74,870

 

$

(2,846

)

Y1

 

$

 257,888

 

Services and Other Revenues

 

59,671

 

 

2,846

 

Y2

 

62,517

 

Total Revenue

 

245,535

 

74,870

 

 

 

 

320,405

 

 

 

 

 

 

 

 

 

 

 

 

 

Cost of Revenues:

 

 

 

 

 

 

 

 

 

 

 

Cost of Product Revenues

 

79,567

 

43,436

 

(171

)

Y3

 

122,832

 

Cost of Services and Other Revenues

 

30,184

 

 

1,755

 

Y4

 

31,939

 

Total Cost of Revenues

 

109,751

 

43,436

 

1,584

 

 

 

154,771

 

 

 

 

 

 

 

 

 

 

 

 

 

Gross Profit

 

135,784

 

31,434

 

(1,584

)

 

 

165,634

 

 

 

 

 

 

 

 

 

 

 

 

 

Operating Expenses:

 

 

 

 

 

 

 

 

 

 

 

Research and Development

 

22,042

 

1,203

 

1,547

 

Y5

 

24,792

 

Selling, General and Administrative

 

97,520

 

18,753

 

2,842

 

Y6

 

119,115

 

Depreciation and Amortization

 

 

5,952

 

(5,952

)

Y7

 

 

Total Operating Expenses

 

119,562

 

25,908

 

(1,563

)

 

 

143,907

 

Income From Operations

 

16,222

 

5,526

 

(21)

 

 

 

21,727

 

Interest Income

 

266

 

 

(190

)

Y8

 

76

 

Interest Expense

 

(62

)

(3,729

)

3,729

 

Y9

 

(62

)

Other Income (Expense), Net

 

(337

)

 

 

 

 

(337

)

Income Before Provision For Income Taxes

 

16,089

 

1,797

 

3,518

 

 

 

21,404

 

Provision For Income Taxes

 

5,700

 

1,077

 

1,337

 

Y10

 

8,114

 

Net Income

 

$

 10,389

 

$

 720

 

$

2,181

 

 

 

$

13,290

 

 

 

 

 

 

 

 

 

 

 

 

 

Net Income Per Share:

 

 

 

 

 

 

 

 

 

 

 

Basic

 

$

 0.31

 

 

 

 

 

 

 

$

 0.40

 

Diluted

 

$

 0.30

 

 

 

 

 

 

 

$

 0.39

 

 

 

 

 

 

 

 

 

 

 

 

 

Weighted Average Shares Outstanding:

 

 

 

 

 

 

 

 

 

 

 

Basic

 

33,123

 

 

 

 

 

 

 

33,123

 

Diluted

 

34,103

 

 

 

 

 

 

 

34,103

 

 

See Notes to Unaudited Pro Forma Condensed Combined Financial Statements

 


(1) Assumes acquisition date of January 1, 2011.

(2) As fiscal years differ by less than 93 days, SEC Rule 11-02(c)-2 permits combination without recasting of periods.

 



 

OMNICELL, INC.

 

UNAUDITED PRO FORMA CONDENSED COMBINED STATEMENT OF OPERATIONS (1)

FOR THE THREE MONTHS ENDED MARCH 31, 2012

(In thousands, except per share data)

 

 

 

Historical

 

 

 

 

 

 

 

 

 

Omnicell,
Inc.

 

MedPak
Holdings,
Inc.(2)

 

Pro Forma
Adjustments

 

 

 

Pro Forma
Combined

 

Revenues:

 

 

 

 

 

 

 

 

 

 

 

Product

 

$

48,524

 

$

18,923

 

$

(739

)

Q1

 

$

66,708

 

Services and Other Revenues

 

15,619

 

 

739

 

Q2

 

16,358

 

Total Revenue

 

64,143

 

18,923

 

 

 

 

83,066

 

 

 

 

 

 

 

 

 

 

 

 

 

Cost of Revenues:

 

 

 

 

 

 

 

 

 

 

 

Cost of Product Revenues

 

20,296

 

11,225

 

(32

)

Q3

 

31,489

 

Cost of Services and Other Revenues

 

8,098

 

 

446

 

Q4

 

8,544

 

Total Cost of Revenues

 

28,394

 

11,225

 

(414

)

 

 

40,033

 

 

 

 

 

 

 

 

 

 

 

 

 

Gross Profit

 

35,749

 

7,698

 

(414

)

 

 

43,033

 

Operating Expenses:

 

 

 

 

 

 

 

 

 

 

 

Research and Development

 

6,494

 

560

 

289

 

Q5

 

7,343

 

Selling, General and Administrative

 

25,620

 

4,913

 

869

 

Q6

 

31,402

 

Depreciation and Amortization

 

 

1,274

 

(1,274

)

Q7

 

 

Total Operating Expenses

 

32,114

 

6,747

 

(116

)

 

 

38,745

 

Income From Operations

 

3,635

 

951

 

(298

)

 

 

4,288

 

Interest Income

 

33

 

 

 

(28

)

Q8

 

5

 

Interest Expense

 

(3

)

(780

)

780

 

Q9

 

(3

)

Other Income (Expense), net

 

66

 

 

 

 

 

66

 

Income Before Provision For Income Taxes

 

3,731

 

171

 

454

 

 

 

4,356

 

Provision For Income Taxes

 

1,380

 

506

 

173

 

Q10

 

2,059

 

Net Income (Loss)

 

$

2,351

 

$

(335

)

$

281

 

 

 

$

2,297

 

 

 

 

 

 

 

 

 

 

 

 

 

Net Income Per Share:

 

$

0.07

 

 

 

 

 

 

 

$

0.07

 

Basic

 

$

0.07

 

 

 

 

 

 

 

$

0.07

 

Diluted

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Weighted Average Shares Outstanding:

 

33,365

 

 

 

 

 

 

 

33,365

 

Basic

 

34,341

 

 

 

 

 

 

 

34,341

 

Diluted

 

 

 

 

 

 

 

 

 

 

 

 

See Notes to Unaudited Pro Forma Condensed Combined Financial Statements

 


(1) Assumes acquisition date of January 1, 2011.

(2) MedPak operating results for the three months ended March 31, 2012 are also included in the unaudited pro forma condense combined statement of operations for the twelve months ended December 21, 2011, per SEC Rule 11-02(c)-2.

 



 

Notes to Unaudited Pro Forma Condensed Combined Financial Statements

 

1.              Description of the Transaction and Basis of Presentation

 

On May 21, 2012, Omnicell acquired 100% of the outstanding common and preferred stock and voting interests of MedPak for $160.1 million in cash, which included certain adjustments.

 

The acquisition is reflected in the unaudited pro forma condensed combined financial statements according to the acquisition method required by the Financial Accounting Standards Board’s (FASB) Accounting Standard Codification Topic 805 Business Combinations (“ASC 805”). Under the acquisition method, the acquisition-date fair value of consideration transferred to effect the transaction, as described in Note 2, is allocated to the assets acquired and the liabilities assumed based on their fair values. Omnicell has made significant estimates and assumptions in determining the preliminary allocation of the acquisition consideration in the unaudited pro forma condensed combined financial statements. These estimates are based on key assumptions of the acquisition. Due to the fact that the unaudited pro forma condensed combined financial statements have been prepared based on preliminary estimates, the final amounts recorded may differ materially from the information presented. The initial estimate of acquisition consideration and allocation of the consideration are subject to change based on further review of the fair value of the assets acquired and liabilities assumed. In accordance with ASC 805, any subsequent changes to the acquisition consideration allocation during the acquisition measurement period that result in material changes to our consolidated financial statements will be adjusted retrospectively.

 

The unaudited pro forma condensed combined balance sheet as of March 31, 2012 assumes the acquisition of MedPak was completed on March 31, 2012. The unaudited pro forma condensed combined statements of operations for the twelve months ended December 31, 2011, which combines the historical operating results of Omnicell for the year ended December 31, 2011 and MedPak for the year ended March 31, 2012, and the unaudited pro forma condensed combined statements of operations for the three months ended March 31, 2012 assume the acquisition of MedPak was completed on January 1, 2011. Because of their differing fiscal year ends, in compiling the unaudited pro forma condensed statements of operations, the unaudited historical operating results of MedPak for the three months ended March 31, 2012 and the audited historical operating results for the twelve months ended March 31, 2012 were included both in the twelve months ended December 31, 2011 and three months ended March 31, 2012 presentation. Total unaudited revenue and net income (loss) for MedPak for the three months ended March 31, 2012 were $18.3 million and $(0.3) million, respectively. The unaudited pro forma condensed combined financial statements are based on the historical consolidated financial statements of Omnicell and MedPak and related adjustments.

 

Under ASC 805, acquisition-related costs (such as advisory, legal, valuation, other professional fees) that are not expected to recur are not included as a component of consideration transferred and are excluded from the unaudited pro forma condensed combined statement of operations. Omnicell expects to incur total acquisition-related costs of approximately $2.3 million and MedPak expects to incur total acquisition-related costs of approximately $2.5 million.

 

The unaudited pro forma condensed combined financial statements also do not give effect to any anticipated synergies, operating efficiencies or cost savings that may be associated with the merger. Certain reclassification adjustments have been made in the unaudited pro forma condensed combined financial statement’s to conform MedPak’s historical basis of presentation to Omnicell’s. The adjustments were primarily to reclassify depreciation and amortization of purchased intangibles and interest expense to individual lines in the combined statement of operations and to reclassify certain costs between costs of revenue, research and development and selling, general and administrative to be consistent with Omnicell’s historical presentation.

 

The pro forma adjustments are based on information available as of the date of this report. Except as disclosed in Note 3 below, there were no other material differences from conforming accounting policies. Assumptions and estimates underlying the pro forma adjustments are described in the accompanying notes. In accordance with ASC 805, any subsequent changes to the allocation of consideration transferred that result in material changes to our consolidated financial statements during the measurement period will be adjusted retrospectively.

 



 

The unaudited pro forma condensed combined statements of operations are not necessarily indicative of what the actual results of operations would have been had the acquisition taken place on the date indicated, nor are they indicative of the future consolidated results of operations of the combined companies. They should be read in conjunction with the historical consolidated financial statements and notes thereto of Omnicell and MedPak.

 

2.              Merger Consideration and Estimated Fair Value of Assets Acquired and Liabilities Assumed

 

Total consideration to be transferred, or anticipated to be transferred, pursuant to certain adjustments provided for in the Merger Agreement to acquire MedPak is $160.1 million.

 

The preliminary allocation of the consideration transferred to the tangible and intangible assets acquired and liabilities assumed is based on various preliminary estimates. Since these unaudited pro forma condensed combined financial statements have been prepared based on preliminary estimates the actual amounts recorded for the acquisition may differ from the information presented.

 

The preliminary allocation of consideration for MedPak, assuming a March 31, 2012 acquisition date, is as follows (in thousands):

 

 

 

Allocation of
Consideration
Transferred

 

Cash including restricted cash

 

$

1,897

 

Accounts receivable

 

8,305

 

Inventory

 

10,903

 

Deferred tax assets and other current assets

 

1,144

 

Total current assets

 

22,249

 

Property and equipment

 

11,100

 

Definite-lived intangibles

 

83,500

 

Goodwill

 

82,773

 

Other non-current assets

 

139

 

Total assets acquired

 

199,761

 

Current liabilities

 

(6,223

)

Deferred tax and other non-current liabilities

 

(33,393

)

Net assets acquired

 

160,145

 

 

 

 

 

Total consideration

 

$

160,145

 

 

Details of acquired definite-lived intangibles are as follows (in thousands, except for years):

 

 

 

Intangible Fair
Value Acquired

 

Useful life
(years)

 

First Year
Amortization

 

Trade name

 

$

6,800

 

12

 

$

567

 

Customer relationships

 

50,100

 

28 to 30

 

1,693

 

Developed technology

 

26,600

 

20

 

1,330

 

Intangibles acquired

 

$

83,500

 

 

 

$

3,590

 

 

 

 

 

 

 

 

 

Weighted average life of intangibles

 

 

 

25.1

 

 

 

 

The amortization of the definite-lived identifiable intangible assets for the first five years after acquisition and thereafter is as follows (in thousands):

 

 

 

Amortization
Expense

 

2012 (from April 1, 2012)

 

$

2,692

 

2013

 

3,590

 

2014

 

3,590

 

2015

 

3,590

 

2016

 

3,590

 

2017

 

3,590

 

Thereafter

 

62,858

 

Total intangibles future amortization

 

$

83,500

 

 



 

Identifiable Intangible Assets - Developed technology relates to MedPak’s products across all of its product lines that have reached technological feasibility, primarily the OnDemand technology. Trade name is primarily related to the MTS and OnDemand brand names. Customer relationships represent existing contracted relationships with pharmacies, institutional care facilities and others. Developed technology, customer relationships, and trade names will be amortized on a straight-line basis over their estimated useful lives which management believes is the best representation of their expected impact on related cash flows.

 

The estimated fair values of the developed technology, trade names and customer relationships were primarily determined using either the relief-from-royalty or excess earnings methods. The rates utilized to discount net cash flows to their present values were determined after consideration of the overall enterprise rate of return and the relative risk and importance of the assets to the generation of future cash flows.

 

The acquisition will be treated for tax purposes as a non-taxable transaction and, as such, the historical tax bases of the acquired assets and assumed liabilities, net operating losses, and other tax attributes of MedPak will carryover. As a result, no new tax-deductible goodwill will be created in connection with the acquisition as there is no step-up to fair value of the underlying tax bases of the acquired net assets. Acquisition accounting includes the establishment of net deferred tax assets and liabilities resulting from book-tax basis differences related to assets acquired and liabilities assumed on the date of acquisition.

 

Goodwill - Approximately $82.8 million has been allocated to goodwill. Goodwill represents the excess of the consideration transferred over the fair value of the underlying net tangible and identifiable intangible assets acquired. In accordance with ASC Topic 350, Goodwill and Other Intangible Assets, goodwill will not be amortized, but instead will be tested for impairment at least annually or more frequently if certain indicators are present. In the event our management determines that the value of goodwill has become impaired, we may incur an accounting charge for the amount of impairment during the quarter in which the determination is made.  The MedPak acquisition enhances our portfolio of product offerings and diversifies our revenue mix providing a more robust product and service solution to our current customers while expanding our international presence. We believe these factors support the amount of goodwill recorded.

 

3.              Adjustments to Unaudited Pro Forma Combined Balance Sheet

 

The unaudited pro forma condensed combined financial information has been prepared to illustrate the effect of the acquisition and has been prepared for informational purposes only. The unaudited pro forma condensed combined financial information is based upon the historical consolidated financial statements of Omnicell and MedPak and should be read in conjunction with the historical financial statements of Omnicell and MedPak.

 

The historical consolidated financial statements have been adjusted in the unaudited pro forma condensed combined financial information to give effect to pro forma events that are (1) directly attributable to the acquisition, (2) factually supportable, and (3) with respect to the statements of operations, expected to have a continuing impact on the combined results of Omnicell and MedPak.

 

There were no significant intercompany balances or transactions between Omnicell and MedPak as of the dates and for the periods of these unaudited pro forma combined financial statements.

 

The pro forma combined consolidated provision for income taxes does not necessarily reflect the amounts that would have resulted had Omnicell and MedPak filed consolidated income tax returns during the periods presented.

 

The pro forma basic and diluted earnings per share amounts presented in the unaudited pro forma condensed combined consolidated statements of operations are based upon the weighted-average number of Omnicell’s common shares outstanding, assuming the transaction occurred on January 1, 2011.

 

The accompanying unaudited pro forma combined balance sheet gives effect to the acquisition as if it had taken place on March 31, 2012. The unaudited pro forma combined statements of operations for the twelve months ended December 31, 2011 and for the three months ended March 31, 2012, reflect the acquisition as if it had taken place on January 1, 2011.

 



 

The pro forma adjustments included in the unaudited pro forma condensed combined balance sheet as of March 31, 2012 are as follows:

 

SCHEDULE OF ADJUSTMENTS - BALANCE SHEET

 

 

 

 

 

Adjustments

 

 

 

 

 

(Dollars in thousands)

 

(a)

 

To reflect cash used to purchase MedPak

 

$

(160,145

)

 

 

 

 

 

 

(b)

 

To adjust inventory acquired to fair value less estimated selling costs

 

$

1,512

 

 

 

 

 

 

 

(c)

 

To adjust fixed assets acquired to fair value

 

$

 1,808

 

 

 

 

 

 

 

(d)

 

To record adjustments to goodwill:

 

 

 

 

 

To eliminate MedPak’s historical goodwill

 

$

(11,977

)

 

 

To record estimate of goodwill from Omnicell’s acquisition of MedPak

 

82,773

 

 

 

 

 

$

70,796

 

(e)

 

Adjustments to acquired intangible assets, net:

 

 

 

 

 

To eliminate MedPak’s historical identifiable intangible assets

 

$

(10,841

)

 

 

To record the fair value of MedPak’s identifiable intangible assets acquired

 

83,500

 

 

 

 

 

$

 72,659

 

 

 

 

 

 

 

(f)

 

To eliminate deferred financing costs related MedPak’s former credit facility

 

$

(1,147

)

 

 

 

 

 

 

(g)

 

Adjustments to MedPak’s accounts payable:

 

 

 

 

 

To reflect MedPak’s accrued compensation expense separately to conform to Omnicell’s historical presentation

 

$

(1,934

)

 

 

To reflect MedPak’s deferred revenue separately to conform to Omnicell’s historical presentation

 

(185

)

 

 

To eliminate MedPak’s deferred rent obligation

 

(133

)

 

 

 

 

$

(2,252

)

 

 

 

 

 

 

(h)

 

To reclassify MedPak’s accrued compensation expense separately to conform to Omnicell’s historical presentation

 

$

 1,934

 

 

 

 

 

 

 

(i)

 

To reclassify MedPak’s customer deposits separately to conform to Omnicell’s historical presentation

 

$

 251

 

 

 

 

 

 

 

(j)

 

To reclassify MedPak’s customer deposits separately to conform to Omnicell’s  historical presentation

 

$

(251

)

 

 

 

 

 

 

(k)

 

To reclassify MedPak’s deferred revenue separately to conform to Omnicell’s historical presentation

 

$

 185

 

 

 

 

 

 

 

(l)

 

To eliminate current portion of MedPak’s long-term debt, paid from sellers’ proceeds in the acquisition

 

$

(440

)

 

 

 

 

 

 

(m)

 

To eliminate MedPak’s long-term debt, less current portion, paid from sellers’ proceeds in the acquisition

 

$

(41,450

)

 

 

 

 

 

 

(n)

 

To record noncurrent deferred tax liabilities related to identifiable intangibles acquired

 

$

 26,997

 

 

 

 

 

 

 

(o)

 

To eliminate MedPak’s dividend obligation, paid from sellers’ proceeds in the acquisition

 

$

(300

)

 

 

 

 

 

 

(p)

 

To eliminate MedPak’s historical stockholders’ deficit

 

$

 809

 

 



 

4.              Adjustments to Unaudited Pro Forma Combined Statements of Operations

 

The pro forma adjustments included in the unaudited pro forma condensed statements of operations are as follows:

 

SCHEDULE OF ADJUSTMENTS — STATEMENT OF OPERATIONS

 

 

 

 

 

Adjustments
(Dollars in Thousands)

 

 

 

 

 

Twelve months
ended December
31, 2011

 

 

 

Three months
ended March
31, 2012

 

Product Revenues

 

 

 

 

 

 

 

 

 

To present MedPak’s services revenue separately to conform with Omnicell’s historical presentation

 

Y1

 

$

(2,846

)

Q1

 

$

(739

)

 

 

 

 

 

 

 

 

 

 

Services and other revenues

 

 

 

 

 

 

 

 

 

To present MedPak’s services revenue separately to conform with Omnicell’s historical presentation

 

Y2

 

$

2,846

 

Q2

 

$

739

 

 

 

 

 

 

 

 

 

 

 

Cost of product revenues

 

 

 

 

 

 

 

 

 

To reclassify MedPak’s product shipping costs to selling, general and administrative expense to conform to Omnicell’s historical accounting policy

 

 

 

$

(2,693

)

 

 

$

(773

)

 

 

 

 

 

 

 

 

 

 

To record depreciation of fixed assets acquired from MedPak

 

 

 

1,929

 

 

 

575

 

 

 

 

 

 

 

 

 

 

 

To record amortization of identifiable intangible assets related to technology acquired from MedPak

 

 

 

1,330

 

 

 

318

 

 

 

 

 

 

 

 

 

 

 

To reclassify MedPak’s salary and related benefit expenses attributable to engineering personnel from cost of goods sold to research and development expense to conform to Omnicell’s historical accounting policy

 

 

 

(422

)

 

 

(81

)

 

 

 

 

 

 

 

 

 

 

To reclassify a portion of MedPak’s facility expense to selling, general, and administrative expense to conform to Omnicell’s historical accounting policy

 

 

 

(265

)

 

 

(66

)

 

 

 

 

 

 

 

 

 

 

To reclassify MedPak’s salary and related benefit expenses attributable to product installers from selling, general, and administrative expense to product cost of goods sold to conform to Omnicell’s historical accounting policy

 

 

 

775

 

 

 

201

 

 

 

 

 

 

 

 

 

 

 

To reclassify MedPak’s salary and related benefit expenses attributable to service and support personnel from product cost of goods sold to service cost of goods sold to conform to Omnicell’s historical accounting policy

 

 

 

(825

)

 

 

(206

)

 

 

Y3

 

$

(171

)

Q3

 

$

(32

)

 

 

 

 

 

 

 

 

 

 

Cost of services and other revenues

 

 

 

 

 

 

 

 

 

To reclassify MedPak’s salary and related benefit expenses attributable to service and support personnel from selling, general, and administrative expense to service cost of goods sold to conform to Omnicell’s historical accounting policy

 

 

 

$

930

 

 

 

$

240

 

 

 

 

 

 

 

 

 

 

 

To reclassify MedPak’s salary and related benefit expenses attributable to service and support personnel from product cost of goods sold to service cost of goods sold to conform to Omnicell’s historical accounting policy

 

 

 

825

 

 

 

206

 

 

 

Y4

 

$

1,755

 

Q4

 

$

446

 

 



 

Research and development

 

 

 

 

 

 

 

 

 

To reclassify MedPak ‘s salary and related benefit expenses attributable to engineering personnel from cost of goods sold to research and development expense to conform to Omnicell’s historical accounting policy

 

 

 

$

422

 

 

 

$

81

 

 

 

 

 

 

 

 

 

 

 

To reclassify MedPak’s salary and related benefit expenses attributable to software engineering personnel from selling, general, and administrative expense to research and development expense to conform to Omnicell’s historical accounting policy

 

 

 

1,125

 

 

 

208

 

 

 

Y5

 

$

1,547

 

Q5

 

$

289

 

 

 

 

 

 

 

 

 

Selling, general, and administrative

 

 

 

 

 

 

 

 

 

To reclassify MedPak’s product shipping costs to selling, general and administrative expense to conform to Omnicell’s historical accounting policy

 

 

 

$

2,693

 

 

 

$

773

 

 

 

 

 

 

 

 

 

 

 

To reclassify MedPak’s salary and related benefit expenses attributable to software engineering personnel from selling, general, and administrative expense to research and development expense to conform to Omnicell’s historical accounting policy

 

 

 

(1,125

)

 

 

(208

)

 

 

 

 

 

 

 

 

 

 

To reclassify a portion of MedPak’s facility expense to selling, general, and administrative expense to conform to Omnicell’s historical accounting policy

 

 

 

265

 

 

 

66

 

 

 

 

 

 

 

 

 

 

 

To reclassify MedPak’s salary and related benefit expenses attributable to product installers from selling, general, and administrative expense to product cost of goods sold to conform to Omnicell’s historical accounting policy

 

 

 

(775

)

 

 

(201

)

 

 

 

 

 

 

 

 

 

 

To reclassify MedPak’s salary and related benefit expenses attributable to service and support personnel from selling, general, and administrative expense to service cost of goods sold to conform to Omnicell’s historical accounting policy

 

 

 

(930

)

 

 

(240

)

 

 

 

 

 

 

 

 

 

 

To record depreciation of fixed assets acquired from MedPak

 

 

 

788

 

 

 

196

 

 

 

 

 

 

 

 

 

 

 

To record amortization of identifiable intangible assets acquired from MedPak

 

 

 

2,260

 

 

 

565

 

 

 

 

 

 

 

 

 

 

 

To eliminate management fees paid by MedPak to an affiliate

 

 

 

(334

)

 

 

(82

)

Net change

 

Y6

 

$

2,842

 

Q6

 

$

869

 

 

 

 

 

 

 

 

 

 

 

Depreciation and amortization

 

 

 

 

 

 

 

 

 

To eliminate MedPak’s historical depreciation

 

 

 

(3,312

)

 

 

(811

)

To eliminate MedPak’s historical intangibles amortization

 

 

 

(2,640

)

 

 

(463

)

 

 

Y7

 

$

(5,952

)

Q7

 

$

(1,274

)

 

 

 

 

 

 

 

 

 

 

To reflect forgone interest income on cash used to acquire MedPak

 

Y8

 

$

(190

)

Q8

 

$

(28

)

 

 

 

 

 

 

 

 

 

 

Interest expense

 

 

 

 

 

 

 

 

 

To eliminate MedPak’s interest expense

 

Y9

 

$

3,729

 

Q9

 

$

780

 

 

 

 

 

 

 

 

 

 

 

Provision for (benefit from) income taxes

 

 

 

 

 

 

 

 

 

To record provision for tax expense on pretax adjustments at 38%

 

Y10

 

$

1,337

 

Q10

 

$

173

 

 



 

5.              Adjustments Not Reflected in the Accompanying Unaudited Pro Forma Statements of Operations

 

The unaudited pro forma combined statements of operations for the periods presented herein have been adjusted to give effect to pro forma events that are expected to have a continuing impact on the combined results which are directly attributable to the acquisition and factually supportable. As such, acquisition-related events which have a one-time impact are not reflected in the accompanying unaudited pro forma combined statements of operations. This includes the step-up valuation for inventory of $1.5 million, expected to be realized in cost of sales mostly in the initial quarter following the acquisition and $4.8 million of acquisition related costs incurred by Omnicell and MedPak Holdings.