EX-99.2 4 b55014ccexv99w2.htm EX-99.2 - UNAUDITED PROFORMA COMBINED CONDENSED FINANCIAL STATEMENTS EX-99.2 - Uaudited Comb Condensed Finanial Stmnts
 

Exhibit 99.2

CONCORD COMMUNICATIONS, INC.

APRISMA HOLDINGS, INC.

UNAUDITED PRO FORMA
COMBINED CONDENSED FINANCIAL STATEMENTS

On February 22, 2005, Concord Communications, Inc. (the “Company” or “Concord”) acquired privately held Aprisma Holdings Inc. (“Aprisma”), from Gores Technology Group, LLC (“Gores”). The Company’s cash payment to acquire Aprisma on February 22, 2005 was $82.4 million, plus transaction costs of $2.2 million and payments of $2.8 million immediately due upon the acquisition under Aprisma’s Equity Participation and Retention Plan (“EPP”), for a total of $87.4 million. Transactions costs include investment banking fees, accounting consulting and legal costs. Aprisma’s EPP was an incentive compensation plan set up by Gores, Aprisma’s parent company, for certain directors, officers and employees; under the plan, participants would get cash compensation upon the sale of Aprisma. The purchase price was funded primarily with the proceeds received from the sale of certain of the Company’s marketable security investments.

This unaudited combined condensed pro forma information should be read in conjunction with the consolidated financial statements of Concord included in the Company’s Annual Report on Form 10-K for the year ended December 31, 2004, filed on March 16, 2005. In addition, this unaudited combined condensed pro forma information should be read in conjunction with the financial statements of Aprisma for the years ended December 31, 2004, 2003 and 2002 included within this Amendment to Current Report on Form 8-K/A.

The following unaudited combined condensed pro forma statement of operations for the year ended December 31, 2004 has been prepared to give effect to the February 22, 2005 acquisition of Aprisma as if the transaction had occurred on January 1, 2004. The pro forma statement of operations combines the results of operations of Concord for the year ended December 31, 2004 with the results of operations of Aprisma for the year ended December 31, 2004.

The following unaudited combined condensed pro forma balance sheet has been prepared to give effect to the February 22, 2005 acquisition of Aprisma as if the transaction had occurred on December 31, 2004, and combines the consolidated balance sheet of Concord as of December 31, 2004 with the Aprisma balance sheet as of December 31, 2004, as adjusted to reflect the application of purchase accounting to record the Aprisma assets and liabilities at their fair values.

 


 

Under the purchase method of accounting, the estimated cost of approximately $87.4 million to acquire Aprisma, which includes the direct acquisition costs, the transaction costs and the EPP payments, was allocated to Aprisma’s underlying net assets in proportion to their respective fair values. As more fully described in the notes to the pro forma combined condensed financial statements, a valuation of the acquired intangible assets (core technology and completed technology, sales backlog, direct maintenance customer relationships, direct subscription customer relationships, reseller relationships, product name/trademark, non-competition agreements) and acquired in-process research and development has been completed.

The following are identified intangible assets acquired and the respective estimated useful lives over which the assets will be amortized:

                 
            Amortization  
    Amount     Period  
    (In thousands)     (In years)  
Core Technology
  $ 7,530       5  
Completed technology
    1,280       3  
Direct Maintenance Customer Relationships
    5,090       7  
Direct Subscription Customer Relationships
    860       6  
Reseller Agreements
    4,600       5  
Product Name/Trademark
    980       6  
Non-Competition Agreements
    210       5  
Sales Backlog
    399        
 
           
 
  $ 20,949          
 
               
In-process research and development
    1,400        
 
           
 
               
 
  $ 22,349          
 
           

These unaudited combined condensed pro forma financial statements are prepared for informational purposes only and are not necessarily indicative of future results or of actual results that would have been achieved had the acquisition of Aprisma been consummated as of January 1, 2004.

 


 

CONCORD COMMUNICATIONS, INC.
PRO FORMA COMBINED CONDENSED STATEMENT OF OPERATIONS
YEAR ENDED DECEMBER 31, 2004
(UNAUDITED)

(In thousands, except share and per share data)

                                         
                    PRO FORMA             PRO FORMA  
    CONCORD (G)     APRISMA (H)     ADJUSTMENTS             COMBINED  
 
                                       
Total revenues
  $ 106,188     $ 43,928                     $ 150,116  
 
                                 
 
                                       
Cost of revenues
    20,978       5,384       2,332       J       28,694  
 
                               
 
                                       
Gross Profit
    85,210       38,544       (2,332 )             121,422  
 
                               
 
                                       
Operating Expenses:
                                       
Research and development
    25,218       7,709       163       J       33,090  
Sales and marketing
    49,911       19,595       1,832       J       71,338  
General and administrative
    11,676       7,568       (2,961 )     J,L       16,283  
 
                                   
 
                                       
Acquired in-process research and development
    100                           100  
 
                               
 
                                       
Total operating expenses
    86,905       34,872       (966             120,811  
 
                               
Operating (loss) income
    (1,695 )     3,672       (1,366 )             611
 
                               
 
                                       
Other Income (Expense):
                                       
Interest income
    4,471             (2,622 )     K       1,849  
Settlement of litigation
          507                       507  
Interest expense
    (3,283 )     (566 )     566       G       (3,283 )
Other expense
    (139 )     (398 )                     (537 )
 
                               
 
                                       
Total other income (loss), net
    1,049       (457 )     (2,056 )             (1,464 )
 
                               
 
                                       
(Loss) income before income taxes
    (646 )     3,215       (3,422 )             (853 )
(Benefit from)provision for income taxes
    (112 )     1,935       (990 )     H       833  
 
                               
 
                                       
Net (loss) income
  $ (534 )   $ 1,280     $ (2,432 )           $ (1,686 )
 
                               
 
                                       
Net (loss) per common and potential common share:
                                       
Basic
    (0.03 )                             (0.09 )
Diluted
    (0.03 )                             (0.09 )
 
                                       
Weighted average common and potential common shares outstanding:
                                       
Basic
    18,280,294                               18,280,294  
Diluted
    18,280,294                               18,280,294  

See accompanying notes to the unaudited pro forma combined condensed financial information

 


 

CONCORD COMMUNICATIONS, INC.
PRO FORMA COMBINED CONDENSED BALANCE SHEET
DECEMBER 31, 2004
(UNAUDITED)
(In thousands)

                                         
                    PRO FORMA             CONCORD COMM  
    CONCORD (A)     APRISMA (B)     ADJUSTMENTS             PRO FORMA  
                              COMBINED  
ASSETS
                                       
 
                                       
Current assets:
                                       
Cash and cash equivalents
  $ 15,816     $ 3,213       (4,899 )     D     $ 14,130  
Marketable securities
    143,639             (84,291 )     D       59,348  
Restricted cash
    66                             66  
Accounts receivable, net
    24,183       8,572                       32,755  
Deferred tax assets
    1,763       542       1,421       I       3,726  
Prepaid expenses and other current assets
    8,170       557                       8,727  
 
                               
 
                                       
Total current assets
    193,637       12,884       (87,769 )             118,752  
 
                                 
 
                                       
Equipment and improvements, net
    6,226       4,367       (305 )     B       10,288  
 
                                       
Goodwill
    6,225       4,186       (4,186 )     A       82,722  
 
                    76,497       C          
 
                                       
Other intangible assets, net
    2,191       9,852       (9,852 )     A       23,140  
 
                    20,949       C          
 
                                       
Deferred tax assets
    12,211             (1,751 )     I       10,460  
Unamortized debt issuance costs and other long term assets
    3,001       525                       3,526  
 
                               
 
                                       
Total assets
  $ 223,491     $ 31,814     $ (6,417 )           $ 248,888  
 
                               
 
                                       
LIABILITIES AND STOCKHOLDERS’ EQUITY
                                       
 
                                       
Current liabilities:
                                       
Accounts payable
  $ 6,334     $ 2,068     $             $ 8,402  
Income taxes payable
    292       1,265       (897 )     I       660  
Other accrued liabilities
    11,879       7,996       3,937       E       23,812  
Deferred revenue
    27,207       13,064       (2,868 )     F       37,403  
 
                                       
Short term debt and other current liabilities
          5,459       (4,899 )     D       560  
 
                               
 
                                       
Total current liabilities
    45,712       29,852       (4,727 )             70,837  
Convertible senior notes
    86,250                             86,250  
Deferred revenue (long term) and tax liabilities
          1,672                       1,672  
 
                               
Total liabilities
    131,962       31,524       (4,727 )             158,759  
Commitments and contingencies
                                       
Stockholders’ Equity:
                                       
Preferred Stock, $0.01 par value:
                                 
Common Stock, $0.01 par value:
    184       1       (1 )     A       184  
Additional paid-in capital
    117,113                             117,113  
Accumulated other comprehensive (loss) income
    (427 )     (86 )     86       A       (427 )
Accumulated (deficit) earnings
    (25,341 )     375       (375 )     A       (26,741 )
 
                                     
 
                    (1,400 )     M          
 
                                   
 
                                       
Total stockholders’ equity
    91,529       290       (1,690 )             90,129  
 
                               
Total liabilities and stockholders’ equity
  $ 223,491     $ 31,814     $ (6,417 )           $ 248,888  
 
                               

See accompanying notes to the unaudited pro forma combined condensed financial information

 


 

See accompanying notes to the unaudited pro forma combined condensed financial information

Note 1 – Basis of Presentation

The unaudited pro forma combined condensed statements of operations for the year ended December 31, 2004 gives effect to the acquisition of Aprisma by Concord as if the acquisition had occurred on January 1, 2004. The unaudited pro forma combined condensed balance sheet as of December 31, 2004 gives effect to the above-mentioned acquisition as if it had occurred on December 31, 2004.

The unaudited combined condensed pro forma financial information has been prepared on the same basis as Concord’s audited financial statements.

The acquisition has been accounted for under the purchase method and, accordingly, the respective assets acquired and liabilities assumed have been recorded at their fair value. The Company paid $87.4 million to acquire the net assets of Aprisma. The purchase price includes $2.2 million for transaction costs and $2.8 million for payments under the EPP. Aprisma’s EPP was an incentive compensation plan set up by Gores for certain directors, officers and employees; under the plan, participants receive cash compensation if Aprisma is sold. Three equal payments are to be made to the participants: at the acquisition date, six months after the acquisition date and one year after the acquisition date. The $2.8 million reflects the portion immediately due and is without regard to future employment; accordingly, such amount is reflected as a component of the acquisition purchase price. The second and third payments, amounting to $6.1 million, are payable to the participants if they remain employed with the acquirer at each anniversary date or if they are terminated without cause by the acquirer prior to the anniversary dates. If the participants terminate their employment with the acquirer or are terminated with cause prior to the anniversary dates, then the payments are made to the original owners of Aprisma. With regard to the second and third payment, one person was identified by Concord for termination at the time of the acquisition. This person’s second and third payments, totaling $0.6 million, have been recorded as a liability at the acquisition date. The remaining payments, amounting to $5.5 million, will be recorded as compensation expense over the service period by Concord assuming the employment conditions, as described above, are met. If the participants terminate their employment or Concord terminates them with cause, such the payments are made to the original owners of Aprisma, then, these payments will be recorded as additional purchase consideration for which goodwill would be increased. It is assumed that the majority of the transaction costs will not be deductible for tax purposes. However, the EPP will be deductible for tax purposes, with the exception of compensation for an Aprisma officer which will exceed the Section 162 (m) limitation of $1.0 million.

 


 

     In accordance with the purchase accounting method, the acquired net assets of Aprisma will be adjusted to their fair values and consolidated into the net assets of Concord. A summary of the preliminary purchase price allocation for the acquisition as of December 31, 2004 is as follows (in thousands):

         
Purchase Price:
       
Cash
  $ 82,350  
EPP payments
    2,846  
Transaction costs paid
    1,941  
Transaction costs accrued
    269  
 
     
Total purchase price
  $ 87,406  
 
     

Allocation of Purchase Price:

         
Fair value of tangible assets acquired, excluding fixed assets
  $ 8,180  
Fixed assets at fair value
    4,062  
Identifiable intangibles
    20,949  
In-process research and development
    1,400  
Goodwill
    76,497  
 
     
Total assets acquired:
    111,088  
Less: fair value of assumed liabilities, including deferred revenue of $10,196
    23,682  
 
     
Total purchase price
  $ 87,406  
 
     

     Based upon a purchase price allocation, as of December 31, 2004, the total purchase price exceeded the net assets acquired and liabilities assumed when adjusted to fair market value and resulted in goodwill in the pro forma combined condensed financial information of approximately $76.5 million. The identified intangible assets acquired, including core technology and completed technology, direct maintenance customer relationships, direct subscription customer relationships, reseller relationships, product name/trademark, non-competition agreements, and sales backlog were assigned fair values based upon an appraisal and amounted to $20.95 million in the aggregate. The portion of the purchase price allocated to in-process research and development costs was $1.4 million; such amount will be expensed in the statement of operations in the period that the acquisition is completed

     As of the date of the closing of the Aprisma acquisition pursuant to an agreement between the Company and Aprisma’s parent company, Gores, the Company became responsible for the then outstanding principal loan balance owed by Aprisma to an affiliate of the parent company. The outstanding principal loan balance under the Loan Agreement was $2.2 million as of December 31, 2004. The Company repaid the balance immediately following the acquisition. As a result, the Company’s repayment of the

 


 

entire loan balance has been reflected in the pro forma condensed combined financial information.

Note 2 – Pro Forma Adjustments

     Adjustments have been made to the unaudited pro forma combined financial information to reflect the following:

     (A) The elimination of the historical stockholders’ equity, deferred income taxes, goodwill and intangible asset accounts of Aprisma.

     (B) The fixed assets were recorded at estimated fair market value of $4.1 million

     (C) The amounts allocated to goodwill of $76.5 million and intangible assets of $20.95 million (see Note 1 – Basis of Presentation).

     (D) Cash was reduced by $4.9 million for the repayment of the outstanding balances under the affiliate loan and the term loan held by Aprisma, which were settled in connection with the acquisition Marketable securities were reduced by $84.3 million reflecting the $82.4 million consideration paid for the net assets of Aprisma and transaction costs through the closing date of $1.9 million.

     (E) Reflects accruals for direct costs of the acquisition of $3.1 million, comprised of the EPP payments due at the acquisition date of $2.8 million and unpaid transaction costs of $0.3 million, $1.1 million of severance costs, which includes $559 of accrued EPP severance, and the adjustment of accruals to fair market value.

     (F) Represents adjustment of deferred revenue to fair market value.

     (G) Interest expense was reduced by $0.6 million to eliminate the interest expense related to the Affiliate loan and the term loan agreement that was repaid at the time of the acquisition.

     (H) Represents the tax effect of the transaction to reflect the estimated tax provision as if the Company and Aprisma had been combined.

     (I) The amounts allocated to deferred income taxes increased the short-term deferred tax asset by $1,421. This related almost entirely to accrued expenses related to the purchase. The amounts allocated to long-term deferred tax assets decreased by $1.75 million due mainly to the liability of $3.1 million associated with identified intangibles. The deferred tax assets represent the tax effect of the book and tax basis difference attributable to the fair value adjustments.

 


 

     (J) Represents the amortization expense of $4.3 million related to the identified intangible assets acquired . The amortization recorded by Aprisma in its historical financial statements of $1.8 million for the year ended December 31, 2004 was eliminated.

     (K) Interest income was reduced by $2.6 million to reflect the sale of certain of the Company’s investments in marketable securities to fund the purchase price.

     (L) Represents the reversal of management fees paid to the parent company of Aprisma, Gores . The agreement between Aprisma and Gores was terminated upon the close of the acquisition of Aprisma by Concord .

     (M) Represents the acquired in-process research and development, totaling $1.4 million, which will be expensed in the period the acquisition is completed. Based upon the status of ongoing research and development (“R&D”) efforts related to Aprisma and a review of the typical technology development cycle and standards for establishing technological feasibility of products, the Company identified SPECTRUM Version 8.0 as a project which represents development efforts in areas where the technologically feasibility has not yet been established. The SPECTRUM Version 8.0 project is a major release to the existing Aprisma product, which includes various architectural changes, such as removal of the dependency to link product on-site and the addition of Linux support. Since this in-process technology is being developed for a highly specific application, the Company believes that there is no alternate future use for the in-process technology beyond the stated purpose of the specific R&D project. Given the riskier nature of the cash flows related to the IPR&D, the level of completion of the project and its perceived risk, a discount rate of 40% was applied to value the in-process R&D.