← 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 ↗
| PART I | | FINANCIAL INFORMATION | |
| Item 1. | | Financial Statements | 4 |
| | Condensed Consolidated Statements of Operations | 4 |
| | Condensed Consolidated Statements of Comprehensive Income | 5 |
| | Condensed Consolidated Balance Sheets | 6 |
| | Condensed Consolidated Statements of Cash Flows | 7 |
| | Notes to Condensed Consolidated Financial Statements | 8 |
| Item 2. | | Management’s Discussion and Analysis of Financial Condition and Results of Operations | 24 |
First 8 of 19 rows. The CSV has all of them.
| Three Months Ended March 31, | | |
| 2017 | 2016 | |
| Revenues | $226,553 | | $199,739 |
| Cost of revenues | 51,346 | | 42,900 |
| Gross margin | 175,207 | | 156,839 |
| Operating expenses: | | | |
| Selling and marketing | 76,402 | | 75,204 |
| Software development | 22,374 | | 17,635 |
First 8 of 21 rows. The CSV has all of them.
| Three Months Ended March 31, | | |
| 2017 | 2016 | |
| Net income | $22,130 | | $16,721 |
| Other comprehensive income (loss), net of tax | | | |
| Foreign currency translation adjustment | 411 | | (533) |
| Net decrease in unrealized loss on investments | — | | 229 |
| Total other comprehensive income (loss) | 411 | | (304) |
| Total comprehensive income | $22,541 | | $16,417 |
| March 31, 2017 | December 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, respectively | 49,557 | | 48,537 |
| Income tax receivable | 129 | | 129 |
| Prepaid expenses and other current assets | 12,005 | | 11,602 |
| Total current assets | 634,163 | | 627,491 |
First 8 of 34 rows. The CSV has all of them.
| Three Months Ended March 31, | | |
| 2017 | 2016 | |
| Operating activities: | | | |
| Net income | $22,130 | | $16,721 |
| Adjustments to reconcile net income to net cash provided by operating activities: | | | |
| Depreciation and amortization | 17,298 | | 17,521 |
| Amortization of debt issuance costs | 772 | | 811 |
| Stock-based compensation expense | 9,357 | | 8,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, 2017 | December 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: | 2017 | 2016 | |
| Net income | $22,130 | | $16,721 |
| Denominator: | | | |
| Denominator for basic net income per share — weighted-average outstanding shares | 32,276 | | 32,085 |
| Effect of dilutive securities: | | | |
| Stock options and restricted stock | 287 | | 297 |
| Denominator for diluted net income per share — weighted-average outstanding shares | 32,563 | | 32,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, | | |
| 2017 | 2016 | |
| Performance-based restricted stock awards | 85 | | 72 |
| Service-based restricted stock units | 1 | | 1 |
| Total shares excluded from computation | 86 | | 73 |
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, | | |
| 2017 | 2016 | |
| Cost of revenues | $1,171 | | $1,381 |
| Selling and marketing | 1,652 | | 1,511 |
| Software development | 1,810 | | 1,534 |
| General and administrative | 4,724 | | 3,905 |
| Total stock-based compensation | $9,357 | | $8,331 |
Table 10 after “are as follows (in thousands):”
Download CSV
| Maturity | Fair Value |
| Due: | |
| April 1, 2017 — March 31, 2018 | $— |
| April 1, 2018 — March 31, 2022 | — |
| April 1, 2022 — March 31, 2027 | — |
| After March 31, 2027 | 9,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
| AmortizedCost | GrossUnrealizedGains | | Gross UnrealizedLosses | FairValue | |
| 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
| AmortizedCost | GrossUnrealizedGains | | GrossUnrealizedLosses | FairValue | |
| 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, 2017 | December 31, 2016 | | | | |
| AggregateFair Value | GrossUnrealizedLosses | | AggregateFair Value | GrossUnrealizedLosses | |
| Auction rate securities | $9,952 | | $(848) | | $9,952 | $(848) |
| Investments in an unrealized loss position | $9,952 | | $(848) | | $9,952 | $(848) |
| Level 1 | Level 2 | | Level 3 | Total | |
| Assets: | | | | | | |
| Money market funds | $175,537 | | $— | | $— | $175,537 |
| Commercial paper | 13,048 | | — | | — | 13,048 |
| Auction rate securities | — | | — | | 9,952 | 9,952 |
| Total assets measured at fair value | $188,585 | | $— | | $9,952 | $198,537 |
| Level 1 | Level 2 | | Level 3 | Total | |
| Assets: | | | | | | |
| Money market funds | $175,344 | | $— | | $— | $175,344 |
| Commercial paper | 6,383 | | — | | — | 6,383 |
| Auction rate securities | — | | — | | 9,952 | 9,952 |
| Total assets measured at fair value | $181,727 | | $— | | $9,952 | $191,679 |
| Three Months Ended March 31, | | |
| 2017 | 2016 | |
| 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 |
| AuctionRateSecurities |
| Balance at December 31, 2015 | $15,507 |
| Decrease in unrealized loss included in accumulated other comprehensive loss | 395 |
| Settlements | (5,950) |
| Balance at December 31, 2016 | 9,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 America | International | | Total | |
| Goodwill, December 31, 2015 | $1,227,310 | | $25,635 | | $1,252,945 |
| Acquisition | 467 | | 5,933 | | 6,400 |
| Effect of foreign currency translation | — | | (4,479) | | (4,479) |
| Goodwill, December 31, 2016 | 1,227,777 | | 27,089 | | 1,254,866 |
| Acquisitions | 8,275 | | — | | 8,275 |
| Effect of foreign currency translation | — | | 343 | | 343 |
| 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, 2017 | December 31, 2016 | | Weighted-AverageAmortizationPeriod (in years) | |
| Capitalized product development cost | $2,275 | | $2,275 | | 4 |
| Accumulated amortization | (2,228) | | (2,217) | | |
| Capitalized product development cost, net | 47 | | 58 | | |
| Building photography | 18,566 | | 17,271 | | 4 |
| Accumulated amortization | (16,780) | | (16,351) | | |
| Building photography, net | 1,786 | | 920 | | |
| Acquired database technology | 80,404 | | 78,151 | | 5 |
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, 2017 | December 31, 2016 | |
| Term loan facility | $310,000 | | $345,000 |
| Debt issuance costs, net | (5,889) | | (6,661) |
| Total debt | 304,111 | | 338,339 |
| Current maturities of long-term debt | (10,000) | | (35,000) |
| Current debt issuance costs, net | 3,039 | | 3,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, | | |
| 2017 | 2016 | |
| Revenues | | | |
| North America | $219,341 | | $193,261 |
| International | | | |
| External customers | 7,212 | | 6,478 |
| Intersegment revenue | 11 | | 11 |
| Total International revenue | 7,223 | | 6,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, | | |
| 2017 | 2016 | |
| Net income | $22,130 | | $16,721 |
| Amortization of acquired intangible assets in cost of revenues | 6,119 | | 5,696 |
| Amortization of acquired intangible assets in operating expenses | 4,774 | | 6,223 |
| Depreciation and other amortization | 6,405 | | 5,602 |
| Interest and other income | (429) | | (84) |
| Interest and other expense | 2,686 | | 2,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, 2017 | December 31, 2016 | |
| Property and equipment, net | | | |
| North America | $82,710 | | $84,727 |
| International | 2,794 | | 2,841 |
| Total property and equipment, net | $85,504 | | $87,568 |
| Goodwill | | | |
| North America | $1,236,052 | | $1,227,777 |
| International | 27,432 | | 27,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, | | |
| 2017 | 2016 | |
| Information and analytics | | | |
| CoStar Suite(1) | $109,979 | | $97,634 |
| Information services(2) | 18,336 | | 19,425 |
| Online marketplaces | | | |
| Multifamily(3) | 63,991 | | 52,238 |
| Commercial property and land(4) | 34,247 | | 30,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, | | |
| 2017 | 2016 | |
| Net income | $22,130 | | $16,721 |
| Amortization of acquired intangible assets in cost of revenues | 6,119 | | 5,696 |
| Amortization of acquired intangible assets in operating expenses | 4,774 | | 6,223 |
| Depreciation and other amortization | 6,405 | | 5,602 |
| Interest and other income | (429) | | (84) |
| Interest and other expense | 2,686 | | 2,509 |
First 8 of 14 rows. The CSV has all of them.
| Three Months Ended March 31, | | | | | |
| 2017 | 2016 | | Increase (Decrease) ($) | Increase (Decrease) (%) | |
| Revenues: | | | | | | |
| CoStar Suite | $109,979 | | $97,634 | | $12,345 | 13% |
| Information services | 18,336 | | 19,425 | | (1,089) | (6) |
| Multifamily | 63,991 | | 52,238 | | 11,753 | 22 |
| Commercial property and land | 34,247 | | 30,442 | | 3,805 | 12 |
| Total revenues | 226,553 | | 199,739 | | 26,814 | 13 |
First 8 of 24 rows. The CSV has all of them.
Table 27 after “ISSUER PURCHASES OF EQUITY SECURITIES”
Download CSV
| Month, 2017 | Total Number ofSharesPurchased | AveragePrice Paidper Share | | Total Number ofSharesPurchased asPart of PubliclyAnnouncedPlans orPrograms | MaximumNumber of Sharesthat May Yet BePurchased Underthe Plans orPrograms | |
| January 1 through January 31 | 4,407 | | $199.37 | | — | — |
| February 1 through February 28 | 4,845 | | 203.71 | | — | — |
| March 1 through March 31 | 19,009 | | 206.00 | | — | — |
| Total | 28,261 | (1) | $204.57 | | — | — |
| Exhibit No. | Description |
| 3.1 | Third 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.2 | Third 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.1 | Certification of Principal Executive Officer pursuant to Section 302 of the Sarbanes-Oxley Act of 2002 (filed herewith). |
| 31.2 | Certification of Principal Financial Officer pursuant to Section 302 of the Sarbanes-Oxley Act of 2002 (filed herewith). |
| 32.1 | Certification 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.2 | Certification 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). |
| 101 | The 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. |