tickdelta
Sign in

Tickdelta is free for now. Sign up and get Pro free

← Filings of CSGP

Tables in the 10-Q of COSTAR GROUP, INC.

28 tables with numbers, filed Apr 25, 2013. Each one downloads as a CSV for Excel or Google Sheets, with the filing's address in the last row. Only the layout is tidied (a "$" or ")" in a cell of its own is joined to its number); no value is changed. Open the filing on sec.gov ↗

Table 1 after “TABLE OF CONTENTS”

Download CSV
PART IFINANCIAL INFORMATION
Item 1.Financial Statements3
Condensed Consolidated Statements of Operations3
Condensed Consolidated Statements of Comprehensive Income4
Condensed Consolidated Balance Sheets5
Condensed Consolidated Statements of Cash Flows6
Notes to Condensed Consolidated Financial Statements7
Item 2.Management’s Discussion and Analysis of Financial Condition and Results of Operations24

First 8 of 19 rows. The CSV has all of them.

Table 2 after “(unaudited)”

Download CSV
Three Months Ended March 31,
20132012
Revenues$104,033$68,629
Cost of revenues33,60624,334
Gross margin70,42744,295
Operating expenses:
Selling and marketing26,97815,550
Software development12,1025,015

First 8 of 21 rows. The CSV has all of them.

Table 3 after “(unaudited)”

Download CSV
Three Months Ended March 31,
20132012
Net income (loss)$(2,410)$5,132
Other comprehensive income (loss), net of tax
Foreign currency translation adjustment(1,640)934
Net change in unrealized gain (loss) on investments, net of tax63(38)
Total other comprehensive income (loss)(1,577)896
Total comprehensive income (loss)$(3,987)$6,028

Table 4 after “(in thousands)”

Download CSV
March 31, 2013December 31, 2012
ASSETS(unaudited)
Current assets:
Cash and cash equivalents$167,394$156,027
Short-term investments—37
Accounts receivable, less allowance for doubtful accounts of approximately $2,968 and $2,935 as of March 31, 2013 and December 31, 2012, respectively24,42016,392
Deferred income taxes, net19,2019,256
Income tax receivable1,7965,357

First 8 of 36 rows. The CSV has all of them.

Table 5 after “(unaudited)”

Download CSV
Three Months Ended March 31,
20132012
Operating activities:
Net income (loss)$(2,410)$5,132
Adjustments to reconcile net income (loss) to net cash provided by operating activities:
Depreciation2,9092,144
Amortization7,2571,176
Amortization of debt issuance costs747—

First 8 of 35 rows. The CSV has all of them.

Table 6 after “The components of accumulated other comprehensive loss were as follows (in thousands):”

Download CSV
March 31, 2013December 31, 2012
Foreign currency translation adjustment$(6,253)$(4,613)
Accumulated net unrealized loss on investments, net of tax(1,842)(1,905)
Total accumulated other comprehensive loss$(8,095)$(6,518)

Table 7 after “The following table sets forth the calculation of basic and diluted net income (loss) per share (in thousands, except per share data):”

Download CSV
Three Months Ended March 31,
Numerator:20132012
Net income (loss)$(2,410)$5,132
Denominator:
Denominator for basic net income (loss) per share — weighted-averageoutstanding shares27,42825,128
Effect of dilutive securities:
Stock options and restricted stock—400
Denominator for diluted net income (loss) per share — weighted-averageoutstanding shares27,42825,528

First 8 of 10 rows. The CSV has all of them.

Table 8 after “Stock-based compensation expense for stock options and restricted stock issued under equity incentive plans and stock purchases under the ES”

Download CSV
Three Months Ended March 31,
20132012
Cost of revenues$1,401$379
Selling and marketing1,808308
Software development2,431331
General and administrative11,6861,169
Total stock-based compensation$17,326$2,187

Table 9 after “The following table summarizes the consideration paid for LoopNet (in thousands except share and per share data):”

Download CSV
Cash$746,393
Equity interest (1,880,300 shares at $72.89)137,055
Fair value of total consideration transferred$883,448

Table 10 after “The Company has applied the acquisition method to account for the LoopNet transaction, which requires that, among other things, assets acqui”

Download CSV
Cash and cash equivalents$105,464
Accounts receivable3,021
Goodwill625,174
Acquired trade names and other48,700
Acquired customer base71,500
Acquired database technology52,100
Deferred income taxes, net(32,623)
Other assets and liabilities10,112

First 8 of 9 rows. The CSV has all of them.

Table 11 after “were as follows (in thousands):”

Download CSV
MaturityFair Value
Due:
April 1, 2013 — March 31, 2014$—
April 1, 2014 — March 31, 2018606
April 1, 2018 — March 31, 2023—
After March 31, 202321,069
Available-for-sale investments$21,675

Table 12 after “, the amortized cost basis and fair value of investments classified as available-for-sale were as follows (in thousands):”

Download CSV
AmortizedCostGrossUnrealizedGainsGross UnrealizedLossesFairValue
Auction rate securities$23,517$164$(2,006)$21,675
Available-for-sale investments$23,517$164$(2,006)$21,675

Table 13 after “, the amortized cost basis and fair value of investments classified as available-for-sale were as follows (in thousands):”

Download CSV
AmortizedCostGrossUnrealizedGainsGrossUnrealizedLossesFairValue
Government-sponsored enterprise obligations$37$—$—$37
Auction rate securities23,567101(2,006)21,662
Available-for-sale investments$23,604$101$(2,006)$21,699

Table 14 after “The components of the Company’s investments in an unrealized loss position for more than twelve months were as follows (in thousands):”

Download CSV
March 31, 2013December 31, 2012
AggregateFair ValueGrossUnrealizedLossesAggregateFair ValueGrossUnrealizedLosses
Government-sponsored enterprise obligations$—$—$37$—
Auction rate securities21,069(2,006)21,119(2,006)
Investments in an unrealized loss position$21,069$(2,006)$21,156$(2,006)

Table 15 after “(in thousands):”

Download CSV
Level 1Level 2Level 3Total
Assets:
Cash$137,565$—$—$137,565
Money market funds5,434——5,434
Commercial paper24,395——24,395
Auction rate securities——21,67521,675
Total assets measured at fair value$167,394$—$21,675$189,069
Liabilities:

First 8 of 10 rows. The CSV has all of them.

Table 16 after “(in thousands):”

Download CSV
Level 1Level 2Level 3Total
Assets:
Cash$135,232$—$—$135,232
Money market funds20,775——20,775
Commercial paper20——20
Government-sponsored enterprise obligations—37—37
Auction rate securities——21,66221,662
Total assets measured at fair value$156,027$37$21,662$177,726

First 8 of 11 rows. The CSV has all of them.

Table 17 after “(in thousands):”

Download CSV
Three Months Ended March 31,
20132012
Balance at beginning of period$21,662$24,584
Change in unrealized gain included in accumulated other comprehensive loss63—
Settlements(50)(50)
Balance at end of period$21,675$24,534

Table 18 after “(in thousands):”

Download CSV
AuctionRateSecurities
Balance at December 31, 2007$53,975
Change in unrealized loss included in accumulated other comprehensive loss(3,710)
Settlements(20,925)
Balance at December 31, 200829,340
Change in unrealized gain included in accumulated other comprehensive loss684
Settlements(300)
Balance at December 31, 200929,724

First 8 of 21 rows. The CSV has all of them.

Table 19 after “(in thousands):”

Download CSV
Three Months Ended March 31,
20132012
Balance at beginning of period$2,304$—
Accretion for period126—
Payments made during period(1,344)—
Balance at end of period$1,086$—

Table 20 after “(in thousands):”

Download CSV
DeferredConsideration
Balance at December 31, 2011$—
Deferred consideration upon acquisition2,011
Accretion for 2012293
Balance at December 31, 20122,304
Accretion from January 1, 2013 – March 31, 2013126
Payments made from January 1, 2013 – March 31, 2013(1,344)
Balance at March 31, 2013$1,086

Table 21 after “The changes in the carrying amount of goodwill by operating segment consist of the following (in thousands):”

Download CSV
United StatesInternationalTotal
Goodwill, December 31, 2011$67,465$24,319$91,784
Acquisitions625,174—625,174
Effect of foreign currency translation—1,1201,120
Goodwill, December 31, 2012692,63925,439718,078
Effect of foreign currency translation—(1,509)(1,509)
Goodwill, March 31, 2013$692,639$23,930$716,569

Table 22 after “Intangibles and other assets consist of the following (in thousands, except amortization period data):”

Download CSV
March 31, 2013December 31, 2012Weighted-AverageAmortizationPeriod (in years)
Capitalized product development cost$2,140$2,1404
Accumulated amortization(1,885)(1,838)
Capitalized product development cost, net255302
Building photography12,80012,4745
Accumulated amortization(11,648)(11,639)
Building photography, net1,152835
Acquired database technology77,20977,3285

First 8 of 17 rows. The CSV has all of them.

Table 23 after “Summarized information by operating segment consist of the following (in thousands):”

Download CSV
Three Months Ended March 31,
20132012
Revenues
United States$99,296$63,985
International
External customers4,7374,644
Intersegment revenue116343
Total international revenue4,8534,987

First 8 of 14 rows. The CSV has all of them.

Table 24 after “Summarized information by operating segment consist of the following (in thousands):”

Download CSV
Reconciliation of EBITDA to net income (loss)
EBITDA$7,568$11,922
Purchase amortization in cost of revenues(3,027)(422)
Purchase amortization in operating expenses(4,125)(634)
Depreciation and other amortization(3,014)(2,264)
Interest income104250
Interest expense(1,755)—
Income tax benefit (expense), net1,839(3,720)

First 8 of 9 rows. The CSV has all of them.

Table 25 after “Summarized information by operating segment consist of the following (in thousands):”

Download CSV
March 31, 2013December 31, 2012
Property and equipment, net
United States$45,368$42,480
International3,2853,828
Total property and equipment, net$48,653$46,308
Goodwill
United States$692,639$692,639
International23,93025,439

First 8 of 26 rows. The CSV has all of them.

Table 26 after “The following table shows our EBITDA reconciled to our net income (loss) and our net cash flows from operating, investing and financing acti”

Download CSV
Three Months Ended March 31,
20132012
Net income (loss)$(2,410)$5,132
Purchase amortization in cost of revenues3,027422
Purchase amortization in operating expenses4,125634
Depreciation and other amortization3,0142,264
Interest income(104)(250)
Interest expense1,755—

First 8 of 14 rows. The CSV has all of them.

Table 27 after “ISSUER PURCHASES OF EQUITY SECURITIES”

Download CSV
Month, 2013Total Number ofSharesPurchasedAveragePrice Paidper ShareTotal Number ofSharesPurchased asPart of PubliclyAnnouncedPlans orProgramsMaximumNumber of Sharesthat May Yet BePurchased Underthe Plans orPrograms
January 1 through January 311,299$93.78——
February 1 through February 289,07795.87——
March 1 through March 3120,994102.50——
Total31,370(1)$100.22——

Table 28 after “INDEX TO EXHIBITS”

Download CSV
Exhibit No.Description
2.1Agreement and Plan of Merger, dated as of April 27, 2011, by and among CoStar Group, Inc., Lonestar Acquisition Sub, Inc. and LoopNet, Inc. (Incorporated by reference to Exhibit 2.1 to the Registrant's Current Report on Form 8-K filed with the Commission on April 28, 2011).
2.2Amendment No. 1 to the Agreement and Plan of Merger, dated as of May 20, 2011, among LoopNet, Inc., the Registrant and Lonestar Acquisition Sub, Inc. (Incorporated by reference to Exhibit 2.1 to the Registrant's Current Report on Form 8-K filed with the Commission on May 23, 2011).
3.1Amended and Restated Certificate of Incorporation (Incorporated by reference to Exhibit 3.1 to the Registrant's Current Report on Form 8-K filed with the Commission on June 8, 2012).
3.2Amended and Restated By-Laws (Incorporated by reference to Exhibit 3.1 to the Registrant's Current Report on Form 8-K filed with the Commission on April 6, 2011).
31.1Certification of Principal Executive Officer pursuant to Section 302 of the Sarbanes-Oxley Act of 2002 (filed herewith).
31.2Certification of Principal Financial Officer pursuant to Section 302 of the Sarbanes-Oxley Act of 2002 (filed herewith).
32.1Certification of Principal Executive Officer pursuant to 18 U.S.C. Sec. 1350, as adopted pursuant to Section 906 of the Sarbanes-Oxley Act of 2002 (filed herewith).

First 8 of 10 rows. The CSV has all of them.