EX-99.3 4 dex993.htm PRO FORMA FINANCIAL INFORMATION PRO FORMA FINANCIAL INFORMATION

Exhibit 99.3

 

INDEX TO PRO FORMA FINANCIAL INFORMATION

 

     Page

Pro Forma Financial Information

   2

Unaudited Pro Forma Condensed Combined Balance Sheet

   3

Unaudited Pro Forma Condensed Combined Statement of Operations

   4

Notes to Unaudited Pro Forma Condensed Combined Financial Statements

   5


MAGMA DESIGN AUTOMATION, INC.

UNAUDITED PRO FORMA CONDENSED COMBINED FINANCIAL INFORMATION

 

The Unaudited Pro Forma Condensed Combined Balance Sheet as of March 31, 2004 and the Unaudited Pro Forma Condensed Combined Statement of Operations for the year ended March 31, 2004 combine the historical Magma Design Automation, Inc. (“Magma” or the “Company”) and Mojave, Inc. (“Mojave”) balance sheets and statements of operations as if the acquisition of Mojave, which occurred on April 29, 2004, had been completed on March 31, 2004 for purposes of the presentation of the Unaudited Pro Forma Condensed Combined Balance Sheet and on April 1, 2003 for purposes of the presentation of the Unaudited Pro Forma Condensed Combined Statement of Operations. The Unaudited Pro Forma Condensed Combined Balance Sheet combines Magma’s consolidated balance sheet as of March 31, 2004 with Mojave’s balance sheet as of December 31, 2003. The Unaudited Pro Forma Condensed Combined Statement of Operations combines Magma’s consolidated statement of operations for the year ended March 31, 2004 with Mojave’s statement of operations for the year ended December 31, 2003. The Unaudited Pro Forma Condensed Combined Financial Statements should be read together with the financial statements including the notes to these statements of Magma included in Magma’s Annual Report on Form 10-K for the year ended March 31, 2004 and the historical financial statements of Mojave included in Exhibit 99.2 of this Current Report on Form 8-K/A.

 

The total initial purchase price of the Mojave acquisition is currently estimated to be approximately $25.1 million and has been accounted for as a purchase business combination under Statement of Financial Accounting Standards No. 141, “Business Combinations.” We acquired all of the outstanding common stock of Mojave in exchange for initial consideration of $24.6 million, which consisted of 607,554 shares of Magma common stock and $12.4 million in cash. In addition to the initial merger consideration, we have agreed to pay contingent consideration of up to $115 million, half in stock and half in cash, based on product orders over a period ending March 31, 2009, but such payments are contingent on the achievement of certain technology milestones. We did not assume any stock options or warrants.

 

The pro forma adjustments reflecting the consummation of the Mojave acquisition are based on the purchase method of accounting, available financial information, and certain estimates and assumptions set forth in the notes to the Unaudited Pro Forma Condensed Combined Financial Statements. An appraisal firm assisted us with the valuation of the identified intangible assets in the Unaudited Pro Forma Condensed Combined Financial Statements and has issued a draft report thereon. The valuation resulted in the allocation of $12.7 million to existing technology intangible asset, which will be amortized over its estimated economic life of five years. The valuation also resulted in the identification of $2.9 million of in-process research and development (“IPR&D”) costs, which were immediately expensed on the closing date. The final purchase price allocation will be based on the closing date (April 29, 2004) balance sheet of Mojave and is also subject to adjustment for payments of contingent consideration in future periods. Until these matters are completed, the purchase price is preliminary and subject to adjustment. The pro forma adjustments do not reflect any operating efficiencies or additional costs that may result with respect to the combined business of Magma and Mojave.

 

The Unaudited Pro Forma Condensed Combined Financial Statements as of and for the year ended March 31, 2004 do not purport to represent what the actual financial condition or results of operations of the combined businesses would have been if the acquisition of Mojave had occurred on the dates indicated in these pro forma condensed combined financial statements nor does this information purport to project our results or financial position for any future periods.

 

2


MAGMA DESIGN AUTOMATION, INC.

UNAUDITED PRO FORMA CONDENSED COMBINED BALANCE SHEET

(in thousands)

 

     Historical
Magma
March 31,
2004


    Historical
Mojave
December 31,
2003


    Pro Forma
Adjustments


    Pro Forma
Combined


 

Assets

                                

Current assets:

                                

Cash and cash equivalents

   $ 72,684     $ 1,072     $ (11,079 )(A)   $ 62,677  

Restricted cash

     2,662       —         —         2,662  

Accounts receivable, net

     34,237       —         —         34,237  

Prepaid expenses and other current assets

     9,588       47       —         9,635  
    


 


 


 


Total current assets

     119,171       1,119       (11,079 )     109,211  

Property and equipment, net

     15,196       20       —         15,216  

Intangibles, net

     62,793               12,700 (B)     75,493  

Goodwill

     33,529               11,394 (B)     44,923  

Long-term investments

     78,158               —         78,158  

Other assets

     5,628       3       1,320 (C)     6,951  
    


 


 


 


Total assets

   $ 314,475     $ 1,142     $ 14,335     $ 329,952  
    


 


 


 


Liabilities and Stockholders’ Equity

                                

Current liabilities:

                                

Accounts payable

   $ 1,658     $ 25     $ —       $ 1,683  

Accrued expenses

     19,132       61       551 (A)     21,064  
                       1,320 (D)        

Deferred revenue

     19,947               —         19,947  
    


 


 


 


Total current liabilities

     40,737       86       1,871       42,694  

Convertible subordinated notes

     150,000       —         —         150,000  

Deferred income taxes

     5,102       —         5,080 (B)     10,182  

Other long-term liabilities

     897       —         —         897  
    


 


 


 


Total liabilities

     196,736       86       6,951       203,773  
    


 


 


 


Redeemable convertible preferred stock

     —         1,815       (1,815 )(E)     —    

Stockholders’ equity

                                

Common stock

     3       1       (1 )(E)     3  

Additional paid-in capital

     226,586       1,027       (1,027 )(E)        
                       12,194 (A)     238,780  

Deferred stock-based compensation

     (718 )     (674 )     674 (E)     (2,017 )
                       (1,299 )(C)        

Accumulated deficit

     (107,063 )     (1,113 )     1,113  (E)     (109,963 )
                       (2,900 )(F)        

Accumulated other comprehensive loss

     (1,069 )     —         —         (1,069 )
    


 


 


 


Total stockholders’ equity

     117,739       (759 )     8,754       125,734  
    


 


 


 


Total liabilities and stockholders’ equity

   $ 314,475     $ 1,142       13,890     $ 329,507  
    


 


 


 


 

See accompanying notes to unaudited pro forma condensed combined financial statements

 

3


MAGMA DESIGN AUTOMATION, INC.

UNAUDITED PRO FORMA CONDENSED COMBINED STATEMENT OF OPERATIONS

(in thousands, except per share data)

 

    

Historical

Magma

Year Ended

March 31,

2004


   

Historical

Mojave

Year Ended

December 31,

2003


   

Pro Forma

Adjustments


   

Pro Forma

Combined


 
        
        
        
        

Revenue:

                                

Licenses

   $ 100,387     $ —       $ —       $ 100,387  

Services

     13,342       —         —         13,342  
    


 


 


 


Total revenue

     113,729       —         —         113,729  

Cost of revenue

     16,647       —         2,540 (G)     19,187  
    


 


 


 


Gross profit

     97,082       —         (2,540 )     94,542  
    


 


 


 


Operating expenses:

                                

Research and development

     26,097       668       839 (H)     27,604  

In-process research and development

     200       —         —         200  

Sales and marketing

     36,973       —         —         36,973  

General and administrative

     11,348       58       —         11,406  

Amortization of intangible assets

     1,745       —         —         1,745  

Stock-based compensation

     7,086       316       825 (H)     8,227  
    


 


 


 


Total operating expenses

     83,449       1,042       1,664       86,155  
    


 


 


 


Operating profit (loss)

     13,633       (1,042 )     (4,204 )     8,387  

Other income, net

     1,418       20       (363 )(I)     1,075  
    


 


 


 


Income (loss) before income taxes

     15,051       (1,022 )     (4,567 )     9,462  

Provision for income taxes

     (3,576 )     —         —         (3,576 )
    


 


 


 


Net income (loss)

   $ 11,475     $ (1,022 )   $ (4,567 )   $ 5,886  
    


 


 


 


Net income per share - basic

   $ 0.36                     $ 0.18  
    


                 


Net income per share - diluted

   $ 0.29                     $ 0.14  
    


                 


Shares used in calculation - basic

     31,648               608       32,256  
    


         


 


Shares used in calculation - diluted

     40,245               608       40,853  
    


         


 


 

See accompanying notes to unaudited pro forma condensed combined financial statements.

 

4


Note 1. Basis of Pro Forma Presentation

 

The Unaudited Pro Forma Condensed Combined Balance Sheet as of March 31, 2004 and the Unaudited Pro Forma Condensed Combined Statement of Operations for the year ended March 31, 2004 combine the historical Magma Design Automation, Inc. (“Magma” or the “Company”) and Mojave, Inc. (“Mojave”) balance sheets and statements of operations as if the acquisition of Mojave, which occurred on April 29, 2004, had been completed on March 31, 2004 for purposes of the presentation of the Unaudited Pro Forma Condensed Combined Balance Sheet and on April 1, 2003 for purposes of the presentation of the Unaudited Pro Forma Condensed Combined Statement of Operations. The Unaudited Pro Forma Condensed Combined Balance Sheet combines Magma’s consolidated balance sheet as of March 31, 2004 with Mojave’s balance sheet as of December 31, 2003. The Unaudited Pro Forma Condensed Combined Statement of Operations combines Magma’s consolidated statement of operations for the year ended March 31, 2004 with Mojave’s statement of operations for the year ended December 31, 2003. The Unaudited Pro Forma Condensed Combined Financial Statements should be read together with the financial statements including the notes to these statements of Magma included in Magma’s Annual Report on Form 10-K for the year ended March 31, 2004 and the historical financial statements of Mojave included in Exhibit 99.2 of this Current Report on Form 8-K/A.

 

The acquisition of Mojave will allow Magma to more comprehensively address its customers’ needs of designing and verifying semiconductors that are manufacturable with desirable yield and performance. Manufacturability is a key design parameter as semiconductor process technology moves to sub-90nm geometries. The total initial purchase price of the Mojave acquisition is currently estimated to be approximately $25.1 million and has been accounted for as a purchase business combination under Statement of Financial Accounting Standards No. 141, “Business Combinations.” We acquired all of the outstanding common stock of Mojave in exchange for initial consideration of $24.6 million, which consisted of 607,554 shares of Magma common and $12.4 million in cash. In addition to the initial merger consideration, we have agreed to pay contingent consideration of up to $115 million, half in stock and half in cash, based on product orders over a period ending March 31, 2009, but such payments are contingent on the achievement of certain technology milestones. We did not assume any stock options or warrants.

 

The pro forma adjustments reflecting the consummation of the Mojave acquisition are based on the purchase method of accounting, available financial information, and certain estimates and assumptions set forth in the notes to the Unaudited Pro Forma Condensed Combined Financial Statements. An appraisal firm assisted us with the valuation of the identified intangible assets in the Unaudited Pro Forma Condensed Combined Financial Statements and has issued a draft report thereon. The valuation resulted in the allocation of $12.7 million to existing technology intangible asset, which will be amortized over its estimated economic life of five years. The valuation also resulted in the identification of $2.9 million of in-process research and development (“IPR&D”) costs, which were immediately expensed on the closing date. The final purchase price allocation will be based on the closing date (April 29, 2004) balance sheet of Mojave and is also subject to adjustment for payments of contingent consideration in future periods. Until these matters are completed, the purchase price is preliminary and subject to adjustment. The pro forma adjustments do not reflect any operating efficiencies or additional costs that may result with respect to the combined business of Magma and Mojave.

 

The Unaudited Pro Forma Condensed Combined Financial Statements as of and for the year ended March 31, 2004 do not purport to represent what the actual financial condition or results of operations of the combined businesses would have been if the acquisition of Mojave had occurred on the dates indicated in these pro forma condensed combined financial statements nor does this information purport to project our results or financial position for any future periods.

 

5


Magma allocated initial purchase price of $24.6 million and $0.5 million of legal, other professional expenses and other costs directly associated with the acquisition to the fair values of the assets acquired and liabilities assumed. The fair value of existing technology intangible asset, goodwill and in-process research and development were determined by management with the assistance of independent appraisal. A summary of the purchase price allocation and the amortization periods of the intangible assets acquired is as follows (in thousands):

 

    

Amount

Allocated


 

Allocation of purchase price:

        

Net tangible assets acquired

   $ 611  

Intangible assets acquired:

        

Existing technology

     12,700  

In-process research and development

     2,900  

Goodwill

     11,394  

Deferred compensation

     1,320  

Deferred stock-based compensation

     1,299  
    


Deferred tax liabilities

     (5,080 )
    


Total purchase price

   $ 25,144  
    


Amortization period of existing technology

     5 years  

 

The value assigned to existing technology was based upon future discounted cash flows related to the existing technology’s projected income streams using discount rate of 16%. The Company believes this rate was appropriate given the business risks inherent in marketing and selling this technology. Factors considered in estimating the discounted cash flows to be derived from the existing technology included risks related to the characteristics and applications of the technology, existing and future markets and an assessment of the age of the technology within its life span.

 

The valuation method used to value in-process research and development is a form of discounted cash flow method.. This approach is a widely recognized appraisal method and is commonly used to value technology assets. The value of the in-process technology is the sum of the discounted expected future cash flows attributable to the in-process technology, taking into consideration the percentage of completion of products utilizing this technology, utilization of pre-existing technology, the risks related to the characteristics and applications of the technology, existing and future markets and the technological risk associated with completing the development of the technology. The cash flows derived from the in-process technology project were discounted at a rate of 30%. The Company believes the rate used was appropriate given the risks associated with the technologies for which commercial feasibility had not been established. The percentage of completion for the in-process project was determined by identifying the elapsed time and costs invested in the project as a ratio of the total time and costs required to bring the project to technical and commercial feasibility, as well as consideration of engineering milestones required to complete the project. The percentage of completion for the in-process project acquired was 12.4%. Schedules were based on management’s estimate of tasks completed and the tasks to be completed to bring the project to technical and commercial feasibility. Revenue resulting from IPR&D project is expected to commence in calendar year 2005.

 

Development of in-process technology remains a substantial risk to the Company due to a variety of factors including the remaining effort to achieve technical feasibility, rapidly changing customer requirements and competitive threats from other companies and technologies. Additionally, the value of other intangible assets acquired may become impaired. The in-process research and development valuation, as well as the valuation of other intangible assets was prepared and determined by management with the assistance of an independent appraisal firm, based on input from the Company and the acquired companies’ management, using valuation methods that are recognized by the United States Securities and Exchange Commission staff.

 

Existing technology intangible asset of $12.7 million will be amortized over its estimated economic life of five years. The estimated future amortization expense related to the existing technology intangible asset is as follows (in thousands) :

 

Fiscal year


   Estimated
Amortization
Expense


2005

   $ 2,328

2006

     2,540

2007

     2,540

2008

     2,540

2009 and after

     2,752
    

     $ 12,700
    

 

6


In accordance with Statement of Financial Accounting Standards No. 142, “Goodwill and Other Intangible Assets,” goodwill will not be amortized and will be tested for impairment at least annually. The preliminary purchase price allocation for Mojave is subject to revision as more detailed analysis is completed and additional information on the fair values of Mojave’s assets and liabilities become available. Any change in the fair value of the net assets of Mojave will change the amount of the purchase price allocable to goodwill. Final purchase accounting adjustments may therefore differ materially from the pro forma adjustments presented here.

 

2. Pro Forma Adjustments

 

Certain reclassifications have been made to conform Mojave’s historical amounts to Magma’s financial statement presentation. The following pro form adjustments have been made to the Unaudited Condensed Combined Pro Forma Financial Information:

 

  (A) To record cash paid and 607,554 shares of Magma common stock issued to acquire Mojave, and estimated transaction costs incurred in connection with the acquisition.

 

  (B) To allocate the purchase price to intangible assets and related deferred tax liabilities, assuming the acquisition of Mojave occurred on March 31, 2004.

 

  (C) To record deferred compensation and deferred stock-based compensation related to unvested cash and stock consideration, respectively, given to the Mojave shareholders in the acquisition.

 

  (D) To record cash consideration payable to the Mojave shareholders for unvested equity interest exchanged in the acquisition.

 

  (E) To reflect the elimination of the redeemable convertible preferred stock and the stockholders’ equity accounts of Mojave.

 

  (F) To record one-time charge for in-process research and development.

 

  (G) To record amortization of intangible assets associated with the acquisition of Mojave.

 

  (H) To record amortization of deferred compensation and deferred stock-based compensation related to unvested cash and stock consideration, respectively, given to the Mojave shareholders in the acquisition.

 

  (I) To record a reduction in interest income earned due to cash consideration paid in connection with the acquisition.

 

The one-time charge to expense for the fair value of the in-process research and development acquired in the Merger has been excluded from the unaudited pro forma condensed combined consolidated statement of operations due to its non-recurring nature.

 

7