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 27, 2017. 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 Statements4
Condensed Consolidated Statements of Operations4
Condensed Consolidated Statements of Comprehensive Income5
Condensed Consolidated Balance Sheets6
Condensed Consolidated Statements of Cash Flows7
Notes to Condensed Consolidated Financial Statements8
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,
20172016
Revenues$226,553$199,739
Cost of revenues51,34642,900
Gross margin175,207156,839
Operating expenses:
Selling and marketing76,40275,204
Software development22,37417,635

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

Table 3 after “(unaudited)”

Download CSV
Three Months Ended March 31,
20172016
Net income$22,130$16,721
Other comprehensive income (loss), net of tax
Foreign currency translation adjustment411(533)
Net decrease in unrealized loss on investments—229
Total other comprehensive income (loss)411(304)
Total comprehensive income$22,541$16,417

Table 4 after “(in thousands)”

Download CSV
March 31, 2017December 31, 2016
ASSETS(unaudited)
Current assets:
Cash and cash equivalents$572,472$567,223
Accounts receivable, net of allowance for doubtful accounts of approximately $7,504 and $6,344 as of March 31, 2017 and December 31, 2016, respectively49,55748,537
Income tax receivable129129
Prepaid expenses and other current assets12,00511,602
Total current assets634,163627,491

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

Table 5 after “(unaudited)”

Download CSV
Three Months Ended March 31,
20172016
Operating activities:
Net income$22,130$16,721
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation and amortization17,29817,521
Amortization of debt issuance costs772811
Stock-based compensation expense9,3578,331

First 8 of 31 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, 2017December 31, 2016
Foreign currency translation adjustment$(11,780)$(12,191)
Accumulated net unrealized loss on investments, net of tax(848)(848)
Total accumulated other comprehensive loss$(12,628)$(13,039)

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

Download CSV
Three Months Ended March 31,
Numerator:20172016
Net income$22,130$16,721
Denominator:
Denominator for basic net income per share — weighted-average outstanding shares32,27632,085
Effect of dilutive securities:
Stock options and restricted stock287297
Denominator for diluted net income per share — weighted-average outstanding shares32,56332,382

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

Table 8 after “, respectively, were not included in the computation of diluted net income per share because the inclusion of the potentially dilutive commo”

Download CSV
Three Months Ended March 31,
20172016
Performance-based restricted stock awards8572
Service-based restricted stock units11
Total shares excluded from computation8673

Table 9 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,
20172016
Cost of revenues$1,171$1,381
Selling and marketing1,6521,511
Software development1,8101,534
General and administrative4,7243,905
Total stock-based compensation$9,357$8,331

Table 10 after “are as follows (in thousands):”

Download CSV
MaturityFair Value
Due:
April 1, 2017 — March 31, 2018$—
April 1, 2018 — March 31, 2022—
April 1, 2022 — March 31, 2027—
After March 31, 20279,952
Available-for-sale investments$9,952

Table 11 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$10,800$—$(848)$9,952
Available-for-sale investments$10,800$—$(848)$9,952

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

Download CSV
AmortizedCostGrossUnrealizedGainsGrossUnrealizedLossesFairValue
Auction rate securities$10,800$—$(848)$9,952
Available-for-sale investments$10,800$—$(848)$9,952

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

Download CSV
March 31, 2017December 31, 2016
AggregateFair ValueGrossUnrealizedLossesAggregateFair ValueGrossUnrealizedLosses
Auction rate securities$9,952$(848)$9,952$(848)
Investments in an unrealized loss position$9,952$(848)$9,952$(848)

Table 14 after “(in thousands):”

Download CSV
Level 1Level 2Level 3Total
Assets:
Money market funds$175,537$—$—$175,537
Commercial paper13,048——13,048
Auction rate securities——9,9529,952
Total assets measured at fair value$188,585$—$9,952$198,537

Table 15 after “(in thousands):”

Download CSV
Level 1Level 2Level 3Total
Assets:
Money market funds$175,344$—$—$175,344
Commercial paper6,383——6,383
Auction rate securities——9,9529,952
Total assets measured at fair value$181,727$—$9,952$191,679

Table 16 after “(in thousands):”

Download CSV
Three Months Ended March 31,
20172016
Balance at beginning of period$9,952$15,507
Decrease in unrealized loss included in accumulated other comprehensive loss—229
Settlements—(4,700)
Balance at end of period$9,952$11,036

Table 17 after “(in thousands):”

Download CSV
AuctionRateSecurities
Balance at December 31, 2015$15,507
Decrease in unrealized loss included in accumulated other comprehensive loss395
Settlements(5,950)
Balance at December 31, 20169,952
Decrease in unrealized loss included in accumulated other comprehensive loss—
Settlements—
Balance at March 31, 2017$9,952

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

Download CSV
North AmericaInternationalTotal
Goodwill, December 31, 2015$1,227,310$25,635$1,252,945
Acquisition4675,9336,400
Effect of foreign currency translation—(4,479)(4,479)
Goodwill, December 31, 20161,227,77727,0891,254,866
Acquisitions8,275—8,275
Effect of foreign currency translation—343343
Goodwill, March 31, 2017$1,236,052$27,432$1,263,484

Table 19 after “Intangible assets consist of the following (in thousands, except amortization period data):”

Download CSV
March 31, 2017December 31, 2016Weighted-AverageAmortizationPeriod (in years)
Capitalized product development cost$2,275$2,2754
Accumulated amortization(2,228)(2,217)
Capitalized product development cost, net4758
Building photography18,56617,2714
Accumulated amortization(16,780)(16,351)
Building photography, net1,786920
Acquired database technology80,40478,1515

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

Table 20 after “The following table represents the Company's long-term debt (in thousands):”

Download CSV
March 31, 2017December 31, 2016
Term loan facility$310,000$345,000
Debt issuance costs, net(5,889)(6,661)
Total debt304,111338,339
Current maturities of long-term debt(10,000)(35,000)
Current debt issuance costs, net3,0393,134
Total long-term debt, less current portion$297,150$306,473

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

Download CSV
Three Months Ended March 31,
20172016
Revenues
North America$219,341$193,261
International
External customers7,2126,478
Intersegment revenue1111
Total International revenue7,2236,489

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

Table 22 after “The reconciliation of net income to EBITDA consists of the following (in thousands):”

Download CSV
Three Months Ended March 31,
20172016
Net income$22,130$16,721
Amortization of acquired intangible assets in cost of revenues6,1195,696
Amortization of acquired intangible assets in operating expenses4,7746,223
Depreciation and other amortization6,4055,602
Interest and other income(429)(84)
Interest and other expense2,6862,509

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

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

Download CSV
March 31, 2017December 31, 2016
Property and equipment, net
North America$82,710$84,727
International2,7942,841
Total property and equipment, net$85,504$87,568
Goodwill
North America$1,236,052$1,227,777
International27,43227,089

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

Table 24 after “The Company provides information, analytics and online marketplaces to the commercial real estate industry and related professionals. The re”

Download CSV
Three Months Ended March 31,
20172016
Information and analytics
CoStar Suite(1)$109,979$97,634
Information services(2)18,33619,425
Online marketplaces
Multifamily(3)63,99152,238
Commercial property and land(4)34,24730,442

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

Table 25 after “The following table shows our net income reconciled to our EBITDA and our net cash flows from operating, investing and financing activities ”

Download CSV
Three Months Ended March 31,
20172016
Net income$22,130$16,721
Amortization of acquired intangible assets in cost of revenues6,1195,696
Amortization of acquired intangible assets in operating expenses4,7746,223
Depreciation and other amortization6,4055,602
Interest and other income(429)(84)
Interest and other expense2,6862,509

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

Table 26 after “(in thousands of dollars):”

Download CSV
Three Months Ended March 31,
20172016Increase (Decrease) ($)Increase (Decrease) (%)
Revenues:
CoStar Suite$109,979$97,634$12,34513%
Information services18,33619,425(1,089)(6)
Multifamily63,99152,23811,75322
Commercial property and land34,24730,4423,80512
Total revenues226,553199,73926,81413

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

Table 27 after “ISSUER PURCHASES OF EQUITY SECURITIES”

Download CSV
Month, 2017Total Number ofSharesPurchasedAveragePrice Paidper ShareTotal Number ofSharesPurchased asPart of PubliclyAnnouncedPlans orProgramsMaximumNumber of Sharesthat May Yet BePurchased Underthe Plans orPrograms
January 1 through January 314,407$199.37——
February 1 through February 284,845203.71——
March 1 through March 3119,009206.00——
Total28,261(1)$204.57——

Table 28 after “INDEX TO EXHIBITS”

Download CSV
Exhibit No.Description
3.1Third Amended 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 6, 2013).
3.2Third Amended 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 September 24, 2013).
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).
32.2Certification of Principal Financial Officer pursuant to 18 U.S.C. Sec. 1350, as adopted pursuant to Section 906 of the Sarbanes-Oxley Act of 2002 (filed herewith).
101The following materials from CoStar Group, Inc.'s Quarterly Report on Form 10-Q for the quarter ended March 31, 2017, formatted in XBRL (eXtensible Business Reporting Language): (i) Unaudited Condensed Consolidated Statement of Operations for the three months ended March 31, 2017 and 2016, respectively; (ii) Unaudited Condensed Consolidated Statements of Comprehensive Income for the three months ended March 31, 2017 and 2016, respectively; (iii) Unaudited Condensed Consolidated Balance Sheets at March 31, 2017 and December 31, 2016, respectively; (iv) Unaudited Condensed Consolidated Statements of Cash Flows for the three months ended March 31, 2017 and 2016, respectively; and (v) Notes to the Unaudited Condensed Consolidated Financial Statements that have been detail tagged.