← Filings of CSGP
Tables in the 10-Q of COSTAR GROUP, INC.
28 tables with numbers, filed Jul 28, 2016. 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 | 3 |
| | Condensed Consolidated Statements of Operations | 3 |
| | Condensed Consolidated Statements of Comprehensive Income (Loss) | 4 |
| | Condensed Consolidated Balance Sheets | 5 |
| | Condensed Consolidated Statements of Cash Flows | 6 |
| | Notes to Condensed Consolidated Financial Statements | 7 |
| 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 June 30, | Six Months Ended June 30, | | | | |
| 2016 | 2015 | | 2016 | 2015 | |
| Revenues | $206,869 | | $170,657 | | $406,608 | $329,677 |
| Cost of revenues | 42,679 | | 44,634 | | 85,579 | 90,030 |
| Gross margin | 164,190 | | 126,023 | | 321,029 | 239,647 |
| Operating expenses: | | | | | | |
| Selling and marketing | 80,468 | | 92,434 | | 155,672 | 161,912 |
| Software development | 19,547 | | 16,844 | | 37,182 | 31,992 |
First 8 of 21 rows. The CSV has all of them.
| Three Months Ended June 30, | Six Months Ended June 30, | | | | |
| 2016 | 2015 | | 2016 | 2015 | |
| Net income (loss) | $15,576 | | $(14,966) | | $32,297 | $(21,093) |
| Other comprehensive income (loss), net of tax | | | | | | |
| Foreign currency translation adjustment | (1,925) | | 1,507 | | (2,458) | 246 |
| Net decrease in unrealized loss on investments | — | | 80 | | 229 | 248 |
| Total other comprehensive income (loss) | (1,925) | | 1,587 | | (2,229) | 494 |
| Total comprehensive income (loss) | $13,651 | | $(13,379) | | $30,068 | $(20,599) |
| June 30, 2016 | December 31, 2015 | |
| ASSETS | (unaudited) | | |
| Current assets: | | | |
| Cash and cash equivalents | $464,151 | | $421,818 |
| Short-term investments | 1,130 | | — |
| Accounts receivable, net of allowance for doubtful accounts of approximately $8,588 and $7,478 as of June 30, 2016 and December 31, 2015, respectively | 45,890 | | 40,276 |
| Income tax receivable | 154 | | 430 |
| Prepaid expenses and other current assets | 12,894 | | 10,209 |
First 8 of 34 rows. The CSV has all of them.
| Six Months Ended June 30, | | |
| 2016 | 2015 | |
| Operating activities: | | | |
| Net income (loss) | $32,297 | | $(21,093) |
| Adjustments to reconcile net income (loss) to net cash provided by operating activities: | | | |
| Depreciation | 11,257 | | 9,184 |
| Amortization | 23,704 | | 27,303 |
| Amortization of debt issuance costs | 1,610 | | 1,656 |
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
| June 30, 2016 | December 31, 2015 | |
| Foreign currency translation adjustment | $(9,617) | | $(7,159) |
| Accumulated net unrealized loss on investments, net of tax | (206) | | (435) |
| Total accumulated other comprehensive loss | $(9,823) | | $(7,594) |
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 June 30, | Six Months Ended June 30, | | | | |
| Numerator: | 2016 | 2015 | | 2016 | 2015 | |
| Net income (loss) | $15,576 | | $(14,966) | | $32,297 | $(21,093) |
| Denominator: | | | | | | |
| Denominator for basic net income (loss) per share — weighted-average outstanding shares | 32,186 | | 31,991 | | 32,135 | 31,911 |
| Effect of dilutive securities: | | | | | | |
| Stock options and restricted stock | 262 | | — | | 280 | — |
| Denominator for diluted net income (loss) per share — weighted-average outstanding shares | 32,448 | | 31,991 | | 32,415 | 31,911 |
First 8 of 10 rows. The CSV has all of them.
Table 8 after “when calculating the diluted net loss per share because the inclusion of the potentially dilutive common shares would have an anti-dilutive ”
Download CSV
| Three Months Ended June 30, | Six Months Ended June 30, | | | | |
| 2016 | 2015 | | 2016 | 2015 | |
| Performance-based restricted stock awards | 72 | | 55 | | 72 | 55 |
| Service-based restricted stock units | 1 | | 1 | | 1 | 1 |
| Total shares excluded from computation | 73 | | 56 | | 73 | 56 |
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 June 30, | Six Months Ended June 30, | | | | |
| 2016 | 2015 | | 2016 | 2015 | |
| Cost of revenues | $1,432 | | $1,339 | | $2,813 | $2,709 |
| Selling and marketing | 1,733 | | 1,202 | | 3,244 | 2,184 |
| Software development | 1,684 | | 1,446 | | 3,218 | 2,716 |
| General and administrative | 4,490 | | 4,428 | | 8,395 | 8,248 |
| Total stock-based compensation | $9,339 | | $8,415 | | $17,670 | $15,857 |
Table 10 after “The Company applied the acquisition method to account for the Apartment Finder transaction, which requires that, among other things, assets ”
Download CSV
| Cash and cash equivalents | $39 |
| Accounts receivable | 4,556 |
| Goodwill | 107,692 |
| Acquired trade names and other intangible assets | 23,642 |
| Acquired customer base | 21,856 |
| Acquired database technology | 4,076 |
| Acquired building photography | 2,425 |
| Deferred income taxes, net | 9,290 |
First 8 of 10 rows. The CSV has all of them.
Table 11 after “are as follows (in thousands):”
Download CSV
| Maturity | Fair Value |
| Due: | |
| July 1, 2016 — June 30, 2017 | $1,130 |
| July 1, 2017 — June 30, 2021 | — |
| July 1, 2021 — June 30, 2026 | — |
| After June 30, 2026 | 9,906 |
| Available-for-sale investments | $11,036 |
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 | | Gross UnrealizedLosses | FairValue | |
| Auction rate securities | $11,242 | | $687 | | $(893) | $11,036 |
| Available-for-sale investments | $11,242 | | $687 | | $(893) | $11,036 |
Table 13 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 | $15,942 | | $610 | | $(1,045) | $15,507 |
| Available-for-sale investments | $15,942 | | $610 | | $(1,045) | $15,507 |
Table 14 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
| June 30, 2016 | December 31, 2015 | | | | |
| AggregateFair Value | GrossUnrealizedLosses | | AggregateFair Value | GrossUnrealizedLosses | |
| Auction rate securities | $9,906 | | $(893) | | $14,455 | $(1,045) |
| Investments in an unrealized loss position | $9,906 | | $(893) | | $14,455 | $(1,045) |
| Level 1 | Level 2 | | Level 3 | Total | |
| Assets: | | | | | | |
| Cash | $220,977 | | $— | | $— | $220,977 |
| Money market funds | 175,227 | | — | | — | 175,227 |
| Commercial paper | 67,947 | | — | | — | 67,947 |
| Auction rate securities | — | | — | | 11,036 | 11,036 |
| Total assets measured at fair value | $464,151 | | $— | | $11,036 | $475,187 |
| Level 1 | Level 2 | | Level 3 | Total | |
| Assets: | | | | | | |
| Cash | $405,597 | | $— | | $— | $405,597 |
| Money market funds | 5,043 | | — | | — | 5,043 |
| Commercial paper | 11,178 | | — | | — | 11,178 |
| Auction rate securities | — | | — | | 15,507 | 15,507 |
| Total assets measured at fair value | $421,818 | | $— | | $15,507 | $437,325 |
| Three Months Ended June 30, | Six Months Ended June 30, | | | | |
| 2016 | 2015 | | 2016 | 2015 | |
| Balance at beginning of period | $11,036 | | $16,669 | | $15,507 | $17,151 |
| Decrease in unrealized loss included in accumulated other comprehensive loss | — | | 80 | | 229 | 248 |
| Settlements | — | | (700) | | (4,700) | (1,350) |
| Balance at end of period | $11,036 | | $16,049 | | $11,036 | $16,049 |
| AuctionRateSecurities |
| Balance at December 31, 2014 | $17,151 |
| Decrease in unrealized loss included in accumulated other comprehensive loss | 256 |
| Settlements | (1,900) |
| Balance at December 31, 2015 | 15,507 |
| Decrease in unrealized loss included in accumulated other comprehensive loss | 229 |
| Settlements | (4,700) |
| Balance at June 30, 2016 | $11,036 |
Table 19 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, 2014 | $1,114,363 | | $24,442 | | $1,138,805 |
| Acquisition | 112,947 | | 2,400 | | 115,347 |
| Effect of foreign currency translation | — | | (1,207) | | (1,207) |
| Goodwill, December 31, 2015 | 1,227,310 | | 25,635 | | 1,252,945 |
| Acquisitions | 467 | | 5,933 | | 6,400 |
| Effect of foreign currency translation | — | | (2,405) | | (2,405) |
| Goodwill, June 30, 2016 | $1,227,777 | | $29,163 | | $1,256,940 |
Table 20 after “Intangible assets consist of the following (in thousands, except amortization period data):”
Download CSV
| June 30, 2016 | December 31, 2015 | | Weighted-AverageAmortizationPeriod (in years) | |
| Capitalized product development cost | $2,275 | | $2,243 | | 4 |
| Accumulated amortization | (2,194) | | (2,172) | | |
| Capitalized product development cost, net | 81 | | 71 | | |
| Building photography | 17,447 | | 17,677 | | 4 |
| Accumulated amortization | (16,103) | | (15,875) | | |
| Building photography, net | 1,344 | | 1,802 | | |
| Acquired database technology | 78,317 | | 77,905 | | 5 |
First 8 of 17 rows. The CSV has all of them.
Table 21 after “The following table represents the Company's long-term debt (in thousands):”
Download CSV
| June 30, 2016 | December 31, 2015 | |
| Term loan facility | $345,000 | | $365,000 |
| Debt issuance costs, net | (8,278) | | (9,888) |
| Total debt | 336,722 | | 355,112 |
| Current maturities of long-term debt | (15,000) | | (20,000) |
| Current debt issuance costs, net | 3,188 | | 3,254 |
| Total long-term debt, less current portion | $324,910 | | $338,366 |
Table 22 after “Summarized information by operating segment consists of the following (in thousands):”
Download CSV
| Three Months Ended June 30, | Six Months Ended June 30, | | | | |
| 2016 | 2015 | | 2016 | 2015 | |
| Revenues | | | | | | |
| North America | $199,859 | | $164,486 | | $393,120 | $317,503 |
| International | | | | | | |
| External customers | 7,010 | | 6,171 | | 13,488 | 12,174 |
| Intersegment revenue | 10 | | 13 | | 21 | 21 |
| Total International revenue | 7,020 | | 6,184 | | 13,509 | 12,195 |
First 8 of 14 rows. The CSV has all of them.
Table 23 after “The reconciliation of net income (loss) to EBITDA consists of the following (in thousands):”
Download CSV
| Three Months Ended June 30, | Six Months Ended June 30, | | | | |
| 2016 | 2015 | | 2016 | 2015 | |
| Net income (loss) | $15,576 | | $(14,966) | | $32,297 | $(21,093) |
| Purchase amortization in cost of revenues | 5,687 | | 6,576 | | 11,383 | 12,923 |
| Purchase amortization in operating expenses | 5,829 | | 6,965 | | 12,052 | 14,107 |
| Depreciation and other amortization | 5,924 | | 5,133 | | 11,526 | 9,457 |
| Interest income | (159) | | (137) | | (243) | (431) |
| Interest expense | 2,455 | | 2,354 | | 4,964 | 4,697 |
First 8 of 10 rows. The CSV has all of them.
Table 24 after “Summarized information by operating segment consists of the following (in thousands):”
Download CSV
| June 30, 2016 | December 31, 2015 | |
| Property and equipment, net | | | |
| North America | $84,392 | | $86,191 |
| International | 2,116 | | 2,120 |
| Total property and equipment, net | $86,508 | | $88,311 |
| Goodwill | | | |
| North America | $1,227,777 | | $1,227,310 |
| International | 29,163 | | 25,635 |
First 8 of 26 rows. The CSV has all of them.
Table 25 after “The Company provides information, analytics and online marketplaces to the commercial real estate industry. The revenue by type of service c”
Download CSV
| Three Months Ended June 30, | Six Months Ended June 30, | | | | |
| 2016 | 2015 | | 2016 | 2015 | |
| Information and analytics | | | | | | |
| CoStar Suite(1) | $101,074 | | $88,771 | | $198,708 | $175,581 |
| Information services(2) | 19,425 | | 18,752 | | 38,850 | 37,289 |
| Online marketplaces | | | | | | |
| Multifamily(3) | 54,860 | | 34,742 | | 107,098 | 60,875 |
| Commercial property and land(4) | 31,510 | | 28,392 | | 61,952 | 55,932 |
First 8 of 9 rows. The CSV has all of them.
Table 26 after “The following table shows our net income (loss) reconciled to our EBITDA and our net cash flows from operating, investing and financing acti”
Download CSV
| Three Months Ended June 30, | Six Months Ended June 30, | | | | |
| 2016 | 2015 | | 2016 | 2015 | |
| Net income (loss) | $15,576 | | $(14,966) | | $32,297 | $(21,093) |
| Purchase amortization in cost of revenues | 5,687 | | 6,576 | | 11,383 | 12,923 |
| Purchase amortization in operating expenses | 5,829 | | 6,965 | | 12,052 | 14,107 |
| Depreciation and other amortization | 5,924 | | 5,133 | | 11,526 | 9,457 |
| Interest income | (159) | | (137) | | (243) | (431) |
| Interest expense | 2,455 | | 2,354 | | 4,964 | 4,697 |
First 8 of 14 rows. The CSV has all of them.
Table 27 after “ISSUER PURCHASES OF EQUITY SECURITIES”
Download CSV
| Month, 2016 | Total Number ofSharesPurchased | AveragePrice Paidper Share | | Total Number ofSharesPurchased asPart of PubliclyAnnouncedPlans orPrograms | MaximumNumber of Sharesthat May Yet BePurchased Underthe Plans orPrograms | |
| April 1 through April 30 | 190 | | $178.69 | | — | — |
| May 1 through May 31 | 45,117 | | 202.22 | | — | — |
| June 1 through June 30 | — | | — | | — | — |
| Total | 45,307 | (1) | $202.13 | | — | — |
| Exhibit No. | Description |
| 2.1 | Agreement and Plan of Merger, dated as of April 27, 2015, by and among CoStar Realty Information, Inc., Orange, LLC, Network Communications, Inc., and Shareholder Representative Services LLC (Incorporated by reference to Exhibit 2.1 to the Registrant's Current Report on Form 8-K filed with the Commission on April 29, 2015). |
| 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). |
| 10.1 | CoStar Group, Inc. 2016 Stock Incentive Plan (Incorporated by reference to Exhibit 4.4 to the Registrant’s Registration Statement on Form S-8 filed June 28, 2016). |
| 10.2 | CoStar Group, Inc. 2016 Cash Incentive Plan (filed herewith). |
| 10.3 | Form of 2016 Plan Restricted Stock Grant Agreement between the Registrant and certain of its officers, directors and employees (filed herewith). |
| 10.4 | Form of 2016 Plan Restricted Stock Grant Agreement for Service Awards between the Registrant and certain of its officers and employees (filed herewith). |
First 8 of 18 rows. The CSV has all of them.