Exhibit 99.3
Unaudited pro forma condensed combined financial
data of the Company and LoopNet
The following unaudited pro forma condensed combined financial statements are based upon the historical consolidated financial data of CoStar and LoopNet after giving effect to the acquisition, and after applying the assumptions, reclassifications and adjustments described in the accompanying notes based on current intentions and expectations relating to the combined business.
The unaudited pro forma condensed combined statements of income combine the historical consolidated statements of income of CoStar and LoopNet, giving effect to the acquisition, as if it had occurred on January 1, 2010. The unaudited pro forma condensed combined balance sheet combines the historical consolidated balance sheets of CoStar and LoopNet, giving effect to the acquisition as if it had occurred on March 31, 2011. The historical consolidated financial data have been adjusted in the unaudited pro forma condensed financial data to give effect to pro forma events that are (1) directly attributable to the acquisition, (2) factually supportable, and (3) with respect to the statement of income, expected to have a continuing impact on the combined results. The unaudited pro forma condensed combined financial data should be read in conjunction with the accompanying notes to the unaudited pro forma condensed combined financial data. In addition, the unaudited pro forma condensed combined financial data were based on and should be read in conjunction with the:
| |
• | separate historical financial statements of CoStar for the year ended December 31, 2010 and as of and for the quarterly period ended March 31, 2011 and the related notes included in CoStar’s Annual Report onForm 10-K for the fiscal year ended December 31, 2010 and CoStar’s Quarterly Report onForm 10-Q for the quarterly period ended March 31, 2011, respectively, each of which is incorporated by reference into this prospectus supplement, and |
|
• | separate historical financial statements of LoopNet for the year ended December 31, 2010 and as of and for the quarterly period ended March 31, 2011 and the related notes included in our Current Report onForm 8-K filed May 23, 2011, which is incorporated by reference into this prospectus supplement. |
The unaudited pro forma condensed combined financial data have been presented for informational purposes only. The pro forma information is not necessarily indicative of what the combined company’s financial position or results of operations actually would have been had the acquisition been completed as of the dates indicated. In addition, the unaudited pro forma condensed combined financial data do not purport to project the future financial position or operating results of the combined company.
The unaudited pro forma condensed combined financial data have been prepared using the acquisition method of accounting under existing U.S. generally accepted accounting principles, or GAAP standards, which are subject to change and interpretation. The acquisition accounting is dependent upon certain valuations and other studies that have yet to commence or progress to a stage where there is sufficient information for a definitive measurement. Accordingly, the pro forma adjustments are preliminary and have been made solely for the purpose of providing unaudited pro forma condensed combined financial data. Differences between these preliminary estimates and the final acquisition accounting will occur and these differences could have a material impact on the accompanying unaudited pro forma condensed combined financial data and the combined company’s future results of operations and financial position.
The unaudited pro forma condensed combined financial data do not reflect any cost savings, operating synergies or revenue enhancements that the combined company may achieve as a result of the acquisition or the costs to integrate the operations of CoStar and LoopNet or the costs necessary to achieve these cost savings, operating synergies and revenue enhancements.
Unaudited pro forma condensed combined balance sheet
as of March 31, 2011
| | | | | | | | | | | | | | | | |
| |
| | Historical
| | | Historical
| | | Pro forma
| | | Pro forma
| |
(in thousands) | | CoStar | | | LoopNet | | | adjustments | | | combined | |
| |
|
ASSETS |
Current assets: | | | | | | | | | | | | | | | | |
Cash and cash equivalents | | $ | 292,252 | | | $ | 93,805 | | | $ | (344,192 | )(a) | | $ | 41,865 | |
Short-term investments | | | 3,657 | | | | 3,530 | | | | (7,187 | )(a) | | | – | |
Accounts receivable, net | | | 16,240 | | | | 1,744 | | | | – | | | | 17,984 | |
Deferred income taxes, net | | | 5,494 | | | | 1,315 | | | | – | | | | 6,809 | |
Income tax receivable | | | 4,940 | | | | – | | | | – | | | | 4,940 | |
Prepaid expenses and other current assets | | | 4,179 | | | | 1,111 | | | | – | | | | 5,290 | |
| | |
| | |
Total current assets | | | 326,762 | | | | 101,505 | | | | (351,379 | ) | | | 76,888 | |
Long-term investments | | | 29,114 | | | | – | | | | – | | | | 29,114 | |
Deferred income taxes, net | | | 12,652 | | | | 16,432 | | | | (29,084 | )(e) | | | – | |
Property and equipment, net | | | 36,886 | | | | 2,556 | | | | – | | | | 39,442 | |
Goodwill | | | 80,488 | | | | 41,507 | | | | 600,569 | (b) | | | 722,564 | |
Intangibles and other assets, net | | | 17,898 | | | | 8,299 | | | | 192,998 | (c) | | | 219,195 | |
Deposits and other assets | | | 2,679 | | | | 6,526 | | | | 6,138 | (d) | | | 15,343 | |
| | |
| | |
Total assets | | $ | 506,479 | | | $ | 176,825 | | | $ | 419,242 | | | $ | 1,102,546 | |
| | |
| | |
|
LIABILITIES AND STOCKHOLDERS’ EQUITY |
Current liabilities: | | | | | | | | | | | | | | | | |
Accounts payable | | $ | 3,351 | | | $ | 820 | | | $ | – | | | $ | 4,171 | |
Accrued wages and commissions | | | 7,581 | | | | 2,531 | | | | – | | | | 10,112 | |
Accrued expenses | | | 17,712 | | | | 3,167 | | | | – | | | | 20,879 | |
Deferred gain on the sale of building | | | 2,523 | | | | – | | | | – | | | | 2,523 | |
Income taxes payable | | | 14,831 | | | | – | | | | – | | | | 14,831 | |
Deferred revenue | | | 18,845 | | | | 9,443 | | | | (6,556 | )(f) | | | 21,732 | |
Current portion of long-term debt | | | – | | | | – | | | | 1,750 | (d) | | | 1,750 | |
| | |
| | |
Total current liabilities | | | 64,843 | | | | 15,961 | | | | (4,806 | ) | | | 75,998 | |
Long-term debt | | | – | | | | – | | | | 173,250 | (d) | | | 173,250 | |
Deferred gain on the sale of building | | | 33,225 | | | | – | | | | – | | | | 33,225 | |
Deferred rent and other long-term liabilities | | | 17,216 | | | | 2,644 | | | | – | | | | 19,860 | |
Deferred income taxes, net | | | – | | | | – | | | | 54,057 | (e) | | | 54,057 | |
Income taxes payable | | | 1,797 | | | | – | | | | – | | | | 1,797 | |
|
Series A convertible preferred stock | | | – | | | | 48,631 | | | | (48,631 | )(g) | | | – | |
|
Stockholders’ equity: | | | | | | | | | | | | | | | | |
Common stock | | | 208 | | | | 40 | | | | 17 | (h) | | | 265 | |
Additional paid in capital | | | 377,320 | | | | 135,172 | | | | 245,732 | (h) | | | 758,224 | |
Other comprehensive loss | | | (7,681 | ) | | | (383 | ) | | | 383 | (h) | | | (7,681 | ) |
Treasury stock | | | – | | | | (86,227 | ) | | | 86,227 | (h) | | | – | |
Retained earnings (accumulated deficit) | | | 19,551 | | | | 60,987 | | | | (86,987 | )(h) | | | (6,449 | ) |
| | |
| | |
Total stockholders’ equity | | | 389,398 | | | | 109,589 | | | | 245,372 | | | | 744,359 | |
| | |
| | |
Total liabilities and stockholders’ equity | | $ | 506,479 | | | $ | 176,825 | | | $ | 419,242 | | | $ | 1,102,546 | |
|
|
Unaudited pro forma condensed combined statement of operations
for year ended December 31, 2010
| | | | | | | | | | | | | | | | |
| |
| | Historical
| | | Historical
| | | Pro forma
| | | Pro forma
| |
(in thousands, except per share data) | | CoStar | | | LoopNet | | | adjustments | | | combined | |
| |
|
Revenues | | $ | 226,260 | | | $ | 78,002 | | | $ | – | | | $ | 304,262 | |
Cost of revenues | | | 83,599 | | | | 12,562 | | | | – | | | | 96,161 | |
| | |
| | |
Gross margin | | | 142,661 | | | | 65,440 | | | | – | | | | 208,101 | |
Operating expenses: | | | | | | | | | | | | | | | | |
Selling and marketing | | | 52,455 | | | | 16,785 | | | | – | | | | 69,240 | |
Software development | | | 17,350 | | | | 12,231 | | | | – | | | | 29,581 | |
General and administrative | | | 47,776 | | | | 15,693 | | | | – | | | | 63,469 | |
Purchase amortization | | | 2,305 | | | | 2,083 | | | | 36,238 | (c) | | | 40,626 | |
| | |
| | |
| | | 119,886 | | | | 46,792 | | | | 36,238 | | | | 202,916 | |
| | |
| | |
Income (loss) from operations | | | 22,775 | | | | 18,648 | | | | (36,238 | ) | | | 5,185 | |
Interest and other income (expense), net | | | 735 | | | | (2,461 | ) | | | (10,572 | )(d) | | | (12,298 | ) |
| | |
| | |
Income (loss) before income taxes | | | 23,510 | | | | 16,187 | | | | (46,810 | ) | | | (7,113 | ) |
Income tax expense (benefit), net | | | 10,221 | | | | 461 | | | | (18,724 | )(e) | | | (8,042 | ) |
| | |
| | |
Net income (loss) | | | 13,289 | | | | 15,726 | | | | (28,086 | ) | | | 929 | |
Convertible preferred stock accretion of discount | | | – | | | | (339 | ) | | | 339 | (g) | | | – | |
| | |
| | |
Net income (loss) applicable to common stockholders | | $ | 13,289 | | | $ | 15,387 | | | $ | (27,747 | ) | | $ | 929 | |
| | |
| | |
Net income per share—basic | | $ | 0.65 | | | | | | | | | | | $ | 0.04 | |
| | |
| | |
Net income per share—diluted | | $ | 0.64 | | | | | | | | | | | $ | 0.04 | |
| | |
| | |
Weighted average outstanding shares—basic | | | 20,330 | | | | | | | | 5,724 | (h) | | | 26,054 | |
| | |
| | |
Weighted average outstanding shares—diluted | | | 20,707 | | | | | | | | 5,724 | (h) | | | 26,431 | |
|
|
Unaudited pro forma condensed combined statement of operations
for the three months ended March 31, 2011
| | | | | | | | | | | | | | | | |
| |
| | Historical
| | | Historical
| | | Pro forma
| | | Pro forma
| |
(in thousands, except per share data) | | CoStar | | | LoopNet | | | adjustments | | | combined | |
| |
|
Revenues | | $ | 59,618 | | | $ | 20,713 | | | $ | – | | | $ | 80,331 | |
Cost of revenues | | | 22,566 | | | | 3,157 | | | | – | | | | 25,723 | |
| | |
| | |
Gross margin | | | 37,052 | | | | 17,556 | | | | – | | | | 54,608 | |
Operating expenses: | | | | | | | | | | | | | | | | |
Selling and marketing | | | 13,246 | | | | 5,134 | | | | – | | | | 18,380 | |
Software development | | | 5,268 | | | | 3,659 | | | | – | | | | 8,927 | |
General and administrative | | | 10,899 | | | | 4,924 | | | | – | | | | 15,823 | |
Purchase amortization | | | 543 | | | | 641 | | | | 8,939 | (c) | | | 10,123 | |
| | |
| | |
| | | 29,956 | | | | 14,358 | | | | 8,939 | | | | 53,253 | |
| | |
| | |
Income (loss) from operations | | | 7,096 | | | | 3,198 | | | | (8,939 | ) | | | 1,355 | |
Interest and other income (expense), net | | | 202 | | | | (317 | ) | | | (2,642 | )(d) | | | (2,757 | ) |
| | |
| | |
Income (loss) before income taxes | | | 7,298 | | | | 2,881 | | | | (11,581 | ) | | | (1,402 | ) |
Income tax expense (benefit), net | | | 2,766 | | | | 1,038 | | | | (4,632 | )(e) | | | (828 | ) |
| | |
| | |
Net income (loss) | | | 4,532 | | | | 1,843 | | | | (6,949 | ) | | | (574 | ) |
Convertible preferred stock accretion of discount | | | – | | | | (85 | ) | | | 85 | (g) | | | – | |
| | |
| | |
Net income (loss) applicable to common stockholders | | $ | 4,532 | | | $ | 1,758 | | | $ | (6,864 | ) | | $ | (574 | ) |
| | |
| | |
Net income (loss) per share—basic | | $ | 0.22 | | | | | | | | | | | $ | (0.02 | ) |
| | |
| �� | |
Net income (loss) per share—diluted | | $ | 0.22 | | | | | | | | | | | $ | (0.02 | ) |
| | |
| | |
Weighted average outstanding shares—basic | | | 20,531 | | | | | | | | 5,724 | (h) | | | 26,255 | |
| | |
| | |
Weighted average outstanding shares—diluted | | | 20,965 | | | | | | | | 5,290 | (h) | | | 26,255 | |
|
|
| |
1. | Description of transaction |
On April 27, 2011, CoStar, LoopNet and Lonestar Acquisition Sub, Inc., a Delaware corporation (“merger sub”), entered into an agreement setting forth the proposed terms of the acquisition, which we refer to in this prospectus supplement as the “merger agreement.” Pursuant to the merger agreement, and subject to the terms and conditions set forth therein, merger sub will be merged with and into LoopNet, with LoopNet continuing as the surviving corporation in the acquisition and a wholly-owned subsidiary of CoStar.
As a result of the acquisition, each outstanding share of LoopNet common stock, other than shares owned by CoStar, merger sub or LoopNet (which will be cancelled and retired) and other than those shares with respect to which appraisal rights are properly exercised and not withdrawn, will be converted into a unit consisting of (i) $16.50 in cash (the “cash consideration”), without interest and (ii) 0.03702 shares of CoStar common stock (the “stock consideration”). Each outstanding share of Series A Preferred Stock will be converted into a unit consisting of (i) the product of 148.80952 multiplied by the cash consideration and (ii) the product of 148.80952 multiplied by the stock consideration.
The acquisition is subject to customary closing conditions, including approval by the stockholders of LoopNet and antitrust clearance. The acquisition is not subject to a financing condition. In certain circumstances set forth in the merger agreement, if the acquisition is not consummated or the merger agreement is terminated, LoopNet may be obligated to pay CoStar a termination fee of $25.8 million. Similarly, in certain circumstances set forth in the merger agreement, if the acquisition is not consummated or the merger agreement is terminated, CoStar may be obligated to pay LoopNet a termination fee of $51.6 million.
LoopNet options and RSUs outstanding pursuant to its equity plans, other than one-third of the performance-based RSUs and one-third of the performance-based stock options will be canceled in exchange for the product of the acquisition consideration, less the exercise price per share in the case of stock options, multiplied by the number of options or RSUs subject to the applicable award. The remaining one-third of the performance-based RSUs and one-third of the performance-based stock options will be canceled in exchange for the same consideration as the other options and RSUs, except that portions payable in cash will be paid instead in a number of shares of CoStar common stock calculated based on the volume weighted average price per share of CoStar common stock on Nasdaq for the ten consecutive trading days ending two days prior to closing. If, as a result of the foregoing treatment of LoopNet’s performance-based RSUs and stock options, the number of shares of CoStar common stock issued under the merger agreement would exceed 2,250,000 shares of CoStar common stock, CoStar may choose to pay to the holders of the applicable performance-based RSUs and stock options the amount in excess of 2,250,000 shares of CoStar common stock in cash. In addition, stock options with an exercise price equal to or greater than the per share value of the acquisition consideration (with the stock component of such consideration being valued based on the volume weighted average price per share of CoStar common stock on Nasdaq for the ten consecutive trading days ending two days prior to closing) will be canceled without any payment.
The unaudited pro forma condensed combined financial statements were prepared using the acquisition method of accounting, under existing U.S. GAAP standards, which are subject to change and interpretation, and were based on the historical financial statements of CoStar and LoopNet.
These standards require, among other things, that most assets acquired and liabilities assumed be recognized at their fair value as of the acquisition. These standards also require that consideration transferred be measured at the closing date of the acquisition at the then-current market price; this particular requirement will likely result in a per share equity component that is different from the amount assumed in these unaudited pro forma condensed combined financial statements.
The accounting standards define the term “fair value” and set forth the valuation requirements for any asset or liability measured at fair value and specify a hierarchy of valuation techniques based on the inputs used to develop the fair value measures. Fair value is defined as “the price that would be received to sell an asset or paid to transfer a liability in an orderly transaction between market participants at the measurements date.” This is an exit price concept for the valuation of the asset or liability. In addition, market participants are assumed to be buyers and sellers in the principal (or most advantageous) market for the asset or liability. Fair value measurements for an asset assume the highest and best use by these market participants. As a result, CoStar may be required to record assets which are not intended to be used or soldand/or to value assets at fair value measures that do not reflect CoStar’s intended use of those assets. Many of these fair value measurements can be highly subjective and it is also possible that other professionals, applying reasonable judgment to the same facts and circumstances, could develop and support a range of alternative estimated amounts.
Under the acquisition method of accounting, the assets acquired and liabilities assumed will be recorded as of the completion of the acquisition, primarily at their respective fair values and added to those of CoStar. Financial statements and reported results of operations of CoStar issued after completion of the acquisition will reflect these values, but will not be retroactively restated to reflect the historical financial position or results of operations of LoopNet.
Acquisition-related transaction costs (i.e. advisory, legal, valuation, other professional fees) and certain acquisition-related restructuring charges impacting the target company are not included as a component of consideration transferred but are accounted for as expenses in the periods in which the costs are incurred. Total advisory, legal, regulatory and valuation costs expected to be incurred by CoStar are estimated to be approximately $26.0 million and are reflected in these unaudited pro forma condensed combined financial statements as a reduction to cash and retained earnings.
Upon consummation of the acquisition, CoStar will review LoopNet’s accounting policies. As a result of that review, CoStar may identify differences between the accounting policies of the two companies that, when conformed, could have a material impact on the combined financial statements. At this time, CoStar is not aware of any differences that would have a material impact on the combined financial statements. The unaudited pro forma condensed combined financial statements do not assume any differences in accounting policies.
| |
4. | Estimate of consideration expected to be transferred |
The following is a preliminary estimate of consideration expected to be transferred to effect the acquisition (in thousands, except per share data):
| | | | | | | | | | | | | | | | |
| |
| | | | | | | | | | | Estimated
| |
| | Estimated fair value | | | CoStar
| |
| | | | | | | | CoStar
| | | shares to
| |
| | Conversion
| | | | | | common
| | | be issued @
| |
(in thousands, except per share data) | | calculation | | | Cash | | | stock | | | $68.58 | |
| |
|
Number of shares of LoopNet common stock outstanding as of May 18, 2011 | | | 32,519.2 | | | | | | | | | | | | | |
Multiplied by CoStar’s stock price as of May 18, 2011 multiplied by the exchange ratio of 0.03702 ($68.58x0.03702) | | $ | 2.54 | | | | | | | $ | 82,561 | | | | 1,204 | |
| | |
| | |
Number of shares of LoopNet common stock outstanding as of May 18, 2011 | | | 32,519.2 | | | | | | | | | | | | | |
Multiplied by cash consideration per common share outstanding | | $ | 16.50 | | | $ | 536,567 | | | | | | | | | |
| | |
| | |
Number of shares of LoopNet common stock into which LoopNet Series A Convertible Preferred Stock outstanding at May 18, 2011 is convertible (50,000 actual shares x 148.81) | | | 7,440.5 | | | | | | | | | | | | | |
Multiplied by CoStar’s stock price as of May 18, 2011 multiplied by the exchange ratio of 0.03702 ($68.58x0.03702) | | $ | 2.54 | | | | | | | $ | 18,890 | | | | 276 | |
| | |
| | |
Number of shares of LoopNet common stock into which LoopNet Series A Convertible Preferred Stock outstanding at May 18, 2011 is convertible (50,000 actual shares x 148.81) | | | 7,440.5 | | | | | | | | | | | | | |
Multiplied by cash consideration per common share outstanding | | $ | 16.50 | | | $ | 122,768 | | | | | | | | | |
| | |
| | |
Number of shares of LoopNet stock options vested and unvested, including performance options, as of May 18, 2011 expected to be canceled and exchanged for purchase consideration | | | 9,506.2 | | | | | | | | | | | | | |
Multiplied by the difference between the per share value of the acquisition consideration as of May 18, 2011 and the weighted-average option exercise price ofin-the-money options | | $ | 9.12 | | | $ | 60,244 | | | $ | 26,411 | | | | 385 | |
| | |
| | |
Number of outstanding restricted stock units, including performance share unit awards, as of May 18, 2011, expected to be canceled | | | 1,458.1 | | | | | | | | | | | | | |
Multiplied by the per share value of the acquisition consideration as of May 18, 2011 | | $ | 19.04 | | | $ | 20,264 | | | $ | 7,497 | | | | 109 | |
| | |
| | |
| | | | | | $ | 739,843 | | | $ | 135,359 | | | | 1,974 | |
| | |
| | |
Estimate of consideration expected to be transferred | | | | | | | | | | $ | 875,202 | | | | | |
| | |
| | |
| | | | | | | | | | | | | | | | |
Common stock, par value $0.01 | | | | | | | | | | $ | 20 | | | | | |
Additional paid-in capital | | | | | | | | | | | 135,339 | | | | | |
| | |
| | |
Total stock consideration | | | | | | | | | | $ | 135,359 | | | | | |
|
|
Certain amounts may reflect rounding adjustments.
The estimated consideration expected to be transferred reflected in these unaudited pro forma condensed combined financial statements does not purport to represent what the actual consideration transferred will be when the acquisition is consummated. The fair value of equity securities issued as part of the consideration transferred will be measured on the closing date of the acquisition at the then-current market price. This requirement will likely result in a per share equity component different from the $2.54 assumed in these unaudited pro forma condensed combined financial statements and that difference may be material. CoStar believes that an increase or decrease by as much as 20% in the CoStar common stock price on the closing date of the acquisition from the common stock price assumed in these unaudited pro forma condensed combined financial statements is reasonably possible based upon the historic volatility of CoStar’s common stock price and the time it may take to complete the acquisition. A change of this magnitude would increase or decrease the consideration expected to be transferred by about $26.0 million, which would be reflected in these unaudited pro forma condensed combined financial statements as an increase or decrease to goodwill.
| |
5. | Estimate of assets to be acquired and liabilities to be assumed |
The following is a preliminary estimate of the assets to be acquired and the liabilities to be assumed by CoStar in the acquisition, reconciled to the estimate of consideration expected to be transferred (in thousands):
| | | | |
Book value of net assets acquired as March 31, 2011 | | $ | 158,220 | |
Adjusted for: | | | | |
Elimination of existing goodwill and intangible assets | | | (49,806 | ) |
| | | | |
Adjusted book value of net assets acquired | | | 108,414 | |
Adjustments to: | | | | |
Identifiable intangible assets(i) | | | 201,297 | |
Deferred revenue(ii) | | | 6,556 | |
Taxes (iii) | | | (83,141 | ) |
Goodwill(iv) | | | 642,076 | |
| | | | |
Total estimated consideration | | $ | 875,202 | |
|
|
| | |
(i) | | As of the effective time of the acquisition, identifiable intangible assets are required to be measured at fair value and these acquired assets could include assets that are not intended to be used or sold or that are intended to be used in a manner other than their highest and best use. For purposes of these unaudited pro forma condensed combined financial statements, it is assumed that all assets will be used and that all assets will be used in a manner that represents the highest and best use of those assets, but it is not assumed that any market participant synergies will be achieved. The consideration of synergies has been excluded because they are not considered to be factually supportable, which is a required condition for these pro forma adjustments. |
The fair value of identifiable intangible assets is determined primarily using the “income method,” which starts with a forecast of all expected future net cash flows. Under the HSR Act and other relevant laws and regulations, there are significant limitations regarding what CoStar can learn about the specifics of the LoopNet intangible assets prior to the consummation of the transaction and any such process will take time to complete.
At this time, CoStar does not have sufficient information as to the amount, timing and risk of cash flows of these intangible assets. Some of the more significant assumptions inherent in the development of intangible asset values, from the perspective of a market participant include: the amount and timing of projected future cash flows (including revenue, cost of sales, research and development costs, sales and marketing expenses, and working capital/contributory asset charges); the discount rate selected to measure the risks inherent in the future cash flows; and the assessment of the asset’s life cycle and the competitive trends impacting the asset, as well as other factors. However, for purposes of these unaudited
pro forma condensed combined financial statements and using publicly available information, the fair value of the identifiable intangible assets and their weighted-average useful lives have been estimated as follows (in thousands):
| | | | | | | | |
| |
| | Estimated fair
| | | Estimated
| |
| | value | | | useful life | |
| |
|
Customer relationships | | $ | 52,512 | | | | 5 years | |
Database technology | | | 61,264 | | | | 4 years | |
Trade names | | | 87,521 | | | | 7 years | |
| | |
| | |
Total | | $ | 201,297 | | | | | |
|
|
These preliminary estimates of fair value and useful life will likely be different from the final acquisition accounting, and the difference could have a material impact on the accompanying unaudited pro forma condensed combined financial statements. Once CoStar has full access to the specifics of the LoopNet intangible assets, additional insight will be gained that could impact (a) the estimated total value assigned to intangible assets, (b) the estimated allocation of value between assetsand/or (c) the estimated useful life of each category of intangible assets. The estimated intangible asset values and their useful lives could be impacted by a variety of factors that may become known to us only upon access to additional informationand/or by changes in such factors that may occur prior to the effective time of the acquisition. These factors include but are not limited to the regulatory, legislative, legal, technological and competitive environments. Increased knowledge about theseand/or other elements could result in a change to the estimated fair value of the LoopNet intangible assetsand/or to the estimated useful lives from what we have assumed in these unaudited pro forma condensed combined financial statements. The combined effect of any such changes could then also result in a significant increase or decrease to our estimate of associated amortization expense.
| | |
(ii) | | Reflects the preliminary fair value adjustment to deferred revenues acquired from LoopNet. The preliminary fair value represents an amount equivalent to the estimated cost plus an appropriate profit margin to perform services based on deferred revenue balances of LoopNet as of March 31, 2011. The preliminary estimate of the cost and appropriate margin may be different from the final acquisition accounting and the difference could have a material impact on the accompanying unaudited pro forma condensed combined financial statements. |
|
(iii) | | Reflects CoStar’s estimated income tax rate of 40% applied to the estimated fair value of identifiable intangible assets to be acquired of $201.3 million and the estimated deferred revenue adjustment of $6.6 million. |
|
(iv) | | Goodwill is calculated as the difference between the acquisition date fair value of the consideration expected to be transferred and the values assigned to the assets acquired and liabilities assumed. Goodwill is not amortized. |
Other than the preliminary estimated adjustments identified above, the accompanying unaudited pro forma condensed combined financial statements assume that the book value of the assets acquired and liabilities assumed by CoStar in the acquisition is representative of their fair value. This preliminary estimate of the fair value of assets acquired and liabilities assumed may be different from the final acquisition accounting and the difference could have a material impact on the accompanying unaudited pro forma condensed combined financial statements.
This note should be read in conjunction withNote 1. Description of Transaction;Note 2. Basis of Presentation;Note 4. Estimate of Consideration Expected to be Transferred; andNote 5. Estimate of Assets to be Acquired and Liabilities to be Assumed. Adjustments included in the column under the heading “Pro Forma Adjustments” represent the following:
(a) Reflects a combination of debt and common stock offering proceeds in addition to the existing cash and cash equivalents and short-term investments to fund the acqusition. CoStar has received a commitment letter from JPMorgan Chase Bank, N.A. for a fully committed term loan of $415.0 million and a $50.0 million revolving credit facility, of which $37.5 million is committed, to fund the acquisition and our ongoing working capital needs following the acquisition. However, for purposes of preparing the pro forma condensed combined financial statements, we have assumed that we consummate the acquisition using the net proceeds of this offering, and have correspondingly reduced the estimated borrowings under the term loan to $175.0 million. For purposes of preparing the pro forma condensed combined financial statements, net offering proceeds assume an offering of 3.75 million common shares at $68.58 per share, which was the closing price per share of
CoStar common stock on May 18, 2011. Proceeds are net of the applicable underwriting discount and other fees.
Estimated sources and uses of cash (in thousands):
| | | | |
Sources: | | | | |
Net proceeds from common stock offering | | $ | 245,602 | |
Proceeds from issuance of debt instruments | | | 175,000 | |
Short-term investments | | | 7,187 | |
| | | | |
| | | 427,789 | |
| | | | |
Uses: | | | | |
Cash portion of acquisition consideration | | | (739,843 | ) |
Acquisition related transaction costs | | | (26,000 | ) |
Fees related to debt issuance | | | (6,138 | ) |
| | | | |
| | | (771,981 | ) |
| | | | |
| | $ | (344,192 | ) |
|
|
(b) To adjust goodwill to an estimate of acquisition-date goodwill, as follows (in thousands):
| | | | |
Eliminate LoopNet historical goodwill | | $ | (41,507 | ) |
Estimated transaction goodwill | | | 642,076 | |
| | | | |
Total | | $ | 600,569 | |
|
|
(c) To adjust intangible assets to an estimate of fair value, as follows (in thousands):
| | | | |
Eliminate LoopNet historical intangible assets | | $ | (8,299 | ) |
Estimated fair value of intangible assets acquired | | | 201,297 | |
| | | | |
Total | | $ | 192,998 | |
|
|
To adjust related amortization expense for the periods presented, as follows (in thousands):
| | | | | | | | |
| |
| | | | | For the three
| |
| | For the year ended
| | | months ended
| |
| | December 31, 2010 | | | March 31, 2011 | |
| |
|
Eliminate LoopNet amortization of intangible assets | | $ | (2,083 | ) | | $ | (641 | ) |
Estimated amortization of acquired intangible assets | | | 38,321 | | | | 9,580 | |
| | |
| | |
Total | | $ | 36,238 | | | $ | 8,939 | |
|
|
(d) CoStar has received a commitment letter from JPMorgan Chase Bank, N.A. with respect to the proposed credit facilities. JPMorgan Chase Bank, N.A. has the right to make certain changes to the terms of the proposed credit facilities in connection with achieving a successful syndication of the term loan portion of the proposed credit facilities, including, among other things, by increasing the interest rate margins on such term loan portion (which increase could result in an increase of the issuance costs payable at the closing of the acquisition) and by including a financial maintenance covenant for such term loan portion.
Estimated origination and issuance costs of $6.1 million will be amortized to interest expense over the term of the proposed credit facilities. Amortization of debt issuance costs
are estimated to be $867,000 and $220,000 for the year ended December 31, 2010, and the quarterly period ended March 31, 2011, respectively.
The term loan is expected to have a seven year maturity with 27 quarterly payments of interest and principal payments of 1% per annum of the original principal amount of the term loan and a final payment of all outstanding principal and interest due and payable on the seventh anniversary of the closing date of the acquisition. CoStar expects to have the option to prepay all or any portion of the term loan at any time without penalty other than LIBOR breakage costs.
CoStar expects the term loan to carry an initial interest rate equal to LIBOR plus 3.5% with a LIBOR floor of 1.25%. CoStar anticipates entering into an interest rate swap in order to effectively fix the interest rate on half of the term loan, or $87.5 million, at 5.5%. For purposes of the pro forma financial statements, the resulting blended effective interest rate on the term loan, including the amortization of issuance costs, is approximately 5.46%
The pro forma adjustments to interest and other income (expense), net are as follows (in thousands):
| | | | | | | | |
| |
| | For the year
| | | For the three
| |
| | ended
| | | months ended
| |
| | December 31, 2010 | | | March 31, 2011 | |
| |
|
Eliminate CoStar interest income to reflect change in cash and investment balances | | $ | (735 | ) | | $ | (202 | ) |
Estimated interest expense on the proposed credit facilities | | | (9,837 | ) | | | (2,440 | ) |
| | |
| �� | |
| | $ | (10,572 | ) | | $ | (2,642 | ) |
|
|
CoStar’s historical interest income for the periods presented has been eliminated in these pro forma statements of operations because they assume that the short-term investments which generated those returns will be liquidated.
(e) The pro forma adjustment to the deferred income tax liability is as follows (in thousands):
| | | | |
| |
| | As of
| |
| | March 31, 2011 | |
| |
|
Estimated fair value of intangible assets to be acquired | | $ | 201,297 | |
Estimated fair value of adjustment to deferred revenue | | | 6,556 | |
| | | | |
| | | 207,853 | |
Tax rate | | | 40% | |
| | | | |
Deferred tax liability, gross | | | 83,141 | |
Reclassified CoStar and LoopNet historical net deferred tax assets | | | (29,084 | ) |
| | | | |
Deferred tax liability, net | | $ | 54,057 | |
|
|
The pro forma adjustment to income tax expense represents the estimated income tax impact of the pro forma adjustments at a tax rate of 40%.
(f) Reflects the preliminary fair value adjustment to deferred revenues acquired from LoopNet. The preliminary fair value represents an amount equivalent to the estimated cost
plus an appropriate profit margin to perform services based on deferred revenue balances of LoopNet as of March 31, 2011.
(g) Pro forma adjustment to eliminate LoopNet’s convertible preferred stock and related accretion expense which will be redeemed in the acquisition.
(h) To record the issuance of additional CoStar common stock in this offering and the stock portion of the acquisition consideration and to eliminate LoopNet’s stockholders’ equity, as follows (in thousands):
| | | | | | | | | | | | | | | | | | | | |
| |
| | | | | Additional
| | | Other
| | | | | | Retained earnings | |
| | Common
| | | paid in
| | | comprehensive
| | | Treasury
| | | (accumulated | |
| | stock | | | capital | | | loss | | | stock | | | deficit) | |
| |
|
Eliminate LoopNet, Inc. stockholders’ equity | | $ | (40 | ) | | $ | (135,172 | ) | | $ | 383 | | | $ | 86,227 | | | $ | (60,987 | ) |
Estimated deal costs | | | – | | | | – | | | | – | | | | – | | | | (26,000 | ) |
Estimated CoStar common shares issued to the public in this offering | | | 37 | | | | 245,565 | | | | – | | | | – | | | | – | |
Estimated CoStar common shares issued to LoopNet shareholders | | | 20 | | | | 135,339 | | | | – | | | | – | | | | – | |
| | |
| | |
| | $ | 17 | | | $ | 245,732 | | | $ | 383 | | | $ | 86,227 | | | $ | (86,987 | ) |
|
|
The unaudited pro forma combined and diluted earnings per share for the periods presented are based on the combined and diluted weighted-average shares. The historical basic and diluted weighted average shares of LoopNet were assumed to be replaced by the shares expected to be issued by CoStar as the stock portion of the acquisition consideration and to raise additional capital in this offering of 1.97 million and 3.75 million shares, respectively. Where the pro forma adjustments result in net losses per share any anti-dilutive effects have been eliminated.