← Filings of CSGP
Tables in the 10-Q of COSTAR GROUP, INC.
36 tables with numbers, filed Apr 24, 2019. 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 Changes in Stockholders’ Equity | 7 |
| | Condensed Consolidated Statements of Cash Flows | 8 |
| | Notes to Condensed Consolidated Financial Statements | 9 |
First 8 of 20 rows. The CSV has all of them.
| Three Months Ended March 31, | | |
| 2019 | 2018 | |
| Revenues | $328,425 | | $273,718 |
| Cost of revenues | 71,153 | | 62,477 |
| Gross profit | 257,272 | | 211,241 |
| Operating expenses: | | | |
| Selling and marketing (excluding customer base amortization) | 88,094 | | 88,490 |
| Software development | 27,928 | | 22,913 |
First 8 of 21 rows. The CSV has all of them.
| Three Months Ended March 31, | | |
| 2019 | 2018 | |
| Net income | $85,169 | | $52,231 |
| Other comprehensive income, net of tax | | | |
| Foreign currency translation adjustment | 380 | | 951 |
| Total other comprehensive income | 380 | | 951 |
| Total comprehensive income | $85,549 | | $53,182 |
| March 31, 2019 | December 31, 2018 | |
| ASSETS | | | |
| Current assets: | | | |
| Cash and cash equivalents | $1,232,817 | | $1,100,416 |
| Accounts receivable, less allowance of $4,790 and $5,709 as of March 31, 2019 and December 31, 2018, respectively | 92,841 | | 89,192 |
| Prepaid expenses and other current assets | 20,713 | | 23,690 |
| Total current assets | 1,346,371 | | 1,213,298 |
| Long-term investments | 10,070 | | 10,070 |
First 8 of 36 rows. The CSV has all of them.
| Common Stock | AdditionalPaid-In Capital | | AccumulatedOtherComprehensive Loss | RetainedEarnings | TotalStockholders’Equity | | | |
| Shares | Amount | | | | | | | |
| Balance at December 31, 2018 | 36,446 | | $364 | | $2,419,812 | | $(11,688) | $613,454 | $3,021,942 |
| Cumulative effect of adoption of new accounting standard, net of tax | — | | — | | — | | — | 12,057 | 12,057 |
| Balance at January 1, 2019 | 36,446 | | $364 | | $2,419,812 | | $(11,688) | $625,511 | $3,033,999 |
| Net income | — | | — | | — | | — | 85,169 | 85,169 |
| Other comprehensive income | — | | — | | — | | 380 | — | 380 |
| Exercise of stock options | 79 | | 1 | | 10,637 | | — | — | 10,638 |
First 8 of 14 rows. The CSV has all of them.
| Common Stock | AdditionalPaid-In Capital | | AccumulatedOtherComprehensive Loss | RetainedEarnings | TotalStockholders’Equity | | | |
| Shares | Amount | | | | | | | |
| Balance at December 31, 2017 | 36,107 | | $361 | | $2,339,253 | | $(9,020) | $320,656 | $2,651,250 |
| Cumulative effect of adoption of new accounting standard, net of tax | — | | — | | — | | — | 54,464 | 54,464 |
| Balance at January 1, 2018 | 36,107 | | $361 | | $2,339,253 | | $(9,020) | $375,120 | $2,705,714 |
| Net income | — | | — | | — | | — | 52,231 | 52,231 |
| Other comprehensive income | — | | — | | — | | 951 | — | 951 |
| Exercise of stock options | 111 | | 1 | | 9,327 | | — | — | 9,328 |
First 8 of 14 rows. The CSV has all of them.
| Three Months Ended March 31, | | |
| 2019 | 2018 | |
| Operating activities: | | | |
| Net income | $85,169 | | $52,231 |
| Adjustments to reconcile net income to net cash provided by operating activities: | | | |
| Depreciation and amortization | 19,659 | | 16,983 |
| Amortization of deferred commissions costs | 12,407 | | 12,006 |
| Amortization of debt issuance costs | 219 | | 219 |
First 8 of 36 rows. The CSV has all of them.
Table 8 after “The components of accumulated other comprehensive loss were as follows (in thousands):”
Download CSV
| March 31, 2019 | December 31, 2018 | |
| Foreign currency translation adjustment | $(10,578) | | $(10,958) |
| Net unrealized loss on investments, net of tax | (730) | | (730) |
| Total accumulated other comprehensive loss | $(11,308) | | $(11,688) |
Table 9 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: | 2019 | 2018 | |
| Net income | $85,169 | | $52,231 |
| Denominator: | | | |
| Denominator for basic net income per share — weighted-average outstanding shares | 36,237 | | 35,893 |
| Effect of dilutive securities: | | | |
| Stock options and restricted stock awards | 330 | | 457 |
| Denominator for diluted net income per share — weighted-average outstanding shares | 36,567 | | 36,350 |
First 8 of 10 rows. The CSV has all of them.
Table 10 after “The following table summarizes the shares underlying the performance-based restricted stock awards excluded from the basic and diluted earni”
Download CSV
| Three Months Ended March 31, | | |
| 2019 | 2018 | |
| Performance-based restricted stock awards | 89 | | 84 |
Table 11 after “Stock-based compensation expense for stock options and restricted stock awards issued under equity incentive plans and stock purchases under”
Download CSV
| Three Months Ended March 31, | | |
| 2019 | 2018 | |
| Cost of revenues | $2,058 | | $1,431 |
| Selling and marketing (excluding customer base amortization) | 1,638 | | 1,835 |
| Software development | 2,056 | | 1,729 |
| General and administrative | 6,277 | | 5,417 |
| Total stock-based compensation expense | $12,029 | | $10,412 |
Table 12 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, | | | | | | | | | |
| 2019 | 2018 | | | | | | | | |
| North America | International | | Total | North America | International | | Total | | |
| Information and analytics | | | | | | | | | | |
| CoStar Suite | $140,973 | | $6,728 | | $147,701 | | $123,886 | | $6,475 | $130,361 |
| Information services | 16,591 | | 2,259 | | 18,850 | | 12,612 | | 2,448 | 15,060 |
| Online marketplaces | | | | | | | | | | |
| Multifamily | 114,268 | | — | | 114,268 | | 87,683 | | — | 87,683 |
First 8 of 10 rows. The CSV has all of them.
Table 13 after “Changes in deferred revenue for the period were as follows (in thousands):”
Download CSV
| Balance at December 31, 2018 | $51,459 |
| Revenue recognized in the current period from the amounts in the beginning balance | (30,015) |
| New deferrals, net of amounts recognized in the current period | 38,723 |
| Effects of foreign currency | 134 |
| Balance at March 31, 2019(1) | $60,301 |
| __________________________ | |
Table 14 after “was as follows (in thousands):”
Download CSV
| Three Months Ended March 31, | | |
| 2019 | 2018 | |
| Commissions incurred | $18,551 | | $23,595 |
| Commissions capitalized in the current period | (13,729) | | (16,263) |
| Amortization of deferred commissions costs | 12,407 | | 12,006 |
| Total commissions expense | $17,229 | | $19,338 |
Table 15 after “The following table summarizes the amounts recorded for acquired assets and assumed liabilities recorded at their fair values as of the Acqu”
Download CSV
| Final:February 21, 2018 |
| Cash and cash equivalents | $59 |
| Accounts receivable | 8,769 |
| Indemnification asset | 5,443 |
| Goodwill | 266,595 |
| Intangible assets | 141,300 |
| Deferred tax liabilities | (34,032) |
| Contingent sales tax liability | (6,260) |
First 8 of 11 rows. The CSV has all of them.
Table 16 after “The unaudited pro forma financial information was as follows (in thousands, except per share data):”
Download CSV
| Three Months Ended March 31, |
| 2018 |
| Revenue | $287,470 |
| Net income | $52,839 |
| Net income per share - basic | 1.47 |
| Net income per share - diluted | 1.45 |
Table 17 after “are as follows (in thousands):”
Download CSV
| Maturity | Fair Value |
| Due: | |
| April 1, 2019 — March 31, 2020 | $— |
| April 1, 2020 — March 31, 2024 | — |
| April 1, 2024 — March 31, 2029 | — |
| After March 31, 2029 | 10,070 |
| Available-for-sale investments | $10,070 |
Table 18 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 | | $— | | $(730) | $10,070 |
| Available-for-sale investments | $10,800 | | $— | | $(730) | $10,070 |
Table 19 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 | | $— | | $(730) | $10,070 |
| Available-for-sale investments | $10,800 | | $— | | $(730) | $10,070 |
Table 20 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, 2019 | December 31, 2018 | | | | |
| AggregateFair Value | GrossUnrealizedLosses | | AggregateFair Value | GrossUnrealizedLosses | |
| Auction rate securities | $10,070 | | $(730) | | $10,070 | $(730) |
| Investments in an unrealized loss position | $10,070 | | $(730) | | $10,070 | $(730) |
| Level 1 | Level 2 | | Level 3 | Total | |
| Assets: | | | | | | |
| Money market funds | $594,036 | | $— | | $— | $594,036 |
| Auction rate securities | — | | — | | 10,070 | 10,070 |
| Total assets measured at fair value | $594,036 | | $— | | $10,070 | $604,106 |
| Level 1 | Level 2 | | Level 3 | Total | |
| Assets: | | | | | | |
| Money market funds | $590,567 | | $— | | $— | $590,567 |
| Auction rate securities | — | | — | | 10,070 | 10,070 |
| Total assets measured at fair value | $590,567 | | $— | | $10,070 | $600,637 |
| AuctionRateSecurities |
| Balance at December 31, 2017 | $10,070 |
| Decrease in unrealized loss included in accumulated other comprehensive loss | — |
| Balance at December 31, 2018 | 10,070 |
| Decrease in unrealized loss included in accumulated other comprehensive loss | — |
| Balance at March 31, 2019 | $10,070 |
Table 24 after “Lease costs related to the Company's operating leases included in the condensed consolidated statement of operations were as follows (in tho”
Download CSV
| Three Months Ended March 31, 2019 |
| Operating lease costs: | |
| Cost of revenues | $3,238 |
| Software development | 952 |
| Selling and marketing (excluding customer base amortization) | 2,191 |
| General and administrative | 292 |
| Total operating lease costs | $6,673 |
Table 25 after “Supplemental balance sheet information related to operating leases was as follows (in thousands):”
Download CSV
| Balance | Balance Sheet Location | March 31, 2019 |
| Long-term lease liabilities | Lease and other long-term liabilities | $119,172 |
| Weighted average remaining lease term in years | | 5.7 |
| Weighted average discount rate | | 4.2% |
Table 26 after “were as follows (in thousands):”
Download CSV
| April 1, 2019 - March 31, 2020 | $31,652 |
| April 1, 2020 - March 31, 2021 | 30,116 |
| April 1, 2021 - March 31, 2022 | 27,193 |
| April 1, 2022 - March 31, 2023 | 26,377 |
| April 1, 2023 - March 31, 2024 | 24,421 |
| Thereafter | 23,941 |
| Total lease payments | 163,700 |
| Less imputed interest | (18,466) |
First 8 of 9 rows. The CSV has all of them.
Table 27 after “were as follows (in thousands):”
Download CSV
| 2019 | $30,485 |
| 2020 | 29,255 |
| 2021 | 27,421 |
| 2022 | 25,634 |
| 2023 | 24,515 |
| Thereafter | 31,768 |
| Total future minimum lease payments | $169,078 |
Table 28 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, 2017 | $1,253,494 | | $29,963 | | $1,283,457 |
| Acquisitions | 319,594 | | 10,344 | | 329,938 |
| Effect of foreign currency translation | — | | (1,860) | | (1,860) |
| Goodwill, December 31, 2018 | 1,573,088 | | 38,447 | | 1,611,535 |
| Effect of foreign currency translation | — | | 530 | | 530 |
| Goodwill, March 31, 2019 | $1,573,088 | | $38,977 | | $1,612,065 |
Table 29 after “Intangible assets consist of the following (in thousands, except amortization period data):”
Download CSV
| March 31, 2019 | December 31, 2018 | | Weighted-AverageAmortizationPeriod (in years) | |
| Capitalized product development cost | $2,173 | | $2,173 | | 4 |
| Accumulated amortization | (2,173) | | (2,173) | | |
| Capitalized product development cost, net | — | | — | | |
| Building photography | 9,087 | | 9,035 | | 2 |
| Accumulated amortization | (8,949) | | (8,809) | | |
| Building photography, net | 138 | | 226 | | |
| Acquired technology | 101,887 | | 103,128 | | 5 |
First 8 of 17 rows. The CSV has all of them.
Table 30 after “Summarized information by operating segment consists of the following (in thousands):”
Download CSV
| Three Months Ended March 31, | | |
| 2019 | 2018 | |
| EBITDA | | | |
| North America | $115,268 | | $71,055 |
| International | (2,117) | | (627) |
| Total EBITDA | $113,151 | | $70,428 |
Table 31 after “The reconciliation of net income to EBITDA consists of the following (in thousands):”
Download CSV
| Three Months Ended March 31, | | |
| 2019 | 2018 | |
| Net income | $85,169 | | $52,231 |
| Amortization of acquired intangible assets in cost of revenues | 5,513 | | 4,608 |
| Amortization of acquired intangible assets in operating expenses | 7,682 | | 5,803 |
| Depreciation and other amortization | 6,464 | | 6,572 |
| Interest and other income | (4,945) | | (2,987) |
| Interest and other expense | 732 | | 690 |
First 8 of 10 rows. The CSV has all of them.
Table 32 after “Summarized information by operating segment consists of the following (in thousands):”
Download CSV
| March 31, 2019 | December 31, 2018 | |
| Property and equipment, net | | | |
| North America | $81,867 | | $79,493 |
| International | 4,111 | | 3,810 |
| Total property and equipment, net | $85,978 | | $83,303 |
| Goodwill | | | |
| North America | $1,573,088 | | $1,573,088 |
| International | 38,977 | | 38,447 |
First 8 of 17 rows. The CSV has all of them.
Table 33 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, | | |
| 2019 | 2018 | |
| Net income | $85,169 | | $52,231 |
| Amortization of acquired intangible assets in cost of revenues | 5,513 | | 4,608 |
| Amortization of acquired intangible assets in operating expenses | 7,682 | | 5,803 |
| Depreciation and other amortization | 6,464 | | 6,572 |
| Interest and other income | (4,945) | | (2,987) |
| Interest and other expense | 732 | | 690 |
First 8 of 14 rows. The CSV has all of them.
| Three Months Ended March 31, | | | | | |
| 2019 | 2018 | | Increase (Decrease) ($) | Increase (Decrease) (%) | |
| Revenues: | | | | | | |
| CoStar Suite | $147,701 | | $130,361 | | $17,340 | 13% |
| Information services | 18,850 | | 15,060 | | 3,790 | 25 |
| Multifamily | 114,268 | | 87,683 | | 26,585 | 30 |
| Commercial property and land | 47,606 | | 40,614 | | 6,992 | 17 |
| Total revenues | 328,425 | | 273,718 | | 54,707 | 20 |
First 8 of 24 rows. The CSV has all of them.
Table 35 after “ISSUER PURCHASES OF EQUITY SECURITIES”
Download CSV
| Month, 2019 | 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 | 1,625 | | $363.76 | | — | — |
| February 1 through February 28 | 9,598 | | 451.05 | | — | — |
| March 1 through March 31 | 29,728 | | 462.77 | | — | — |
| Total | 40,951 | (1) | $456.09 | | — | — |
| 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, 2019, formatted in XBRL (eXtensible Business Reporting Language): (i) Unaudited Condensed Consolidated Statements of Operations for the three months ended March 31, 2019 and 2018, respectively; (ii) Unaudited Condensed Consolidated Statements of Comprehensive Income for the three months ended March 31, 2019 and 2018, respectively; (iii) Unaudited Condensed Consolidated Balance Sheets at March 31, 2019 and December 31, 2018, respectively; (iv) Unaudited Condensed Consolidated Statements of Changes in Stockholders' Equity at March 31, 2019 and March 31, 2018; (v) Unaudited Condensed Consolidated Statements of Cash Flows for the three months ended March 31, 2019 and 2018, respectively; and (vi) Notes to the Unaudited Condensed Consolidated Financial Statements that have been detail tagged. |