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.

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 ↗

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 Changes in Stockholders’ Equity7
Condensed Consolidated Statements of Cash Flows8
Notes to Condensed Consolidated Financial Statements9

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

Table 2 after “(unaudited)”

Download CSV
Three Months Ended March 31,
20192018
Revenues$328,425$273,718
Cost of revenues71,15362,477
Gross profit257,272211,241
Operating expenses:
Selling and marketing (excluding customer base amortization)88,09488,490
Software development27,92822,913

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

Table 3 after “(unaudited)”

Download CSV
Three Months Ended March 31,
20192018
Net income$85,169$52,231
Other comprehensive income, net of tax
Foreign currency translation adjustment380951
Total other comprehensive income380951
Total comprehensive income$85,549$53,182

Table 4 after “(unaudited)”

Download CSV
March 31, 2019December 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, respectively92,84189,192
Prepaid expenses and other current assets20,71323,690
Total current assets1,346,3711,213,298
Long-term investments10,07010,070

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

Table 5 after “(unaudited)”

Download CSV
Common StockAdditionalPaid-In CapitalAccumulatedOtherComprehensive LossRetainedEarningsTotalStockholders’Equity
SharesAmount
Balance at December 31, 201836,446$364$2,419,812$(11,688)$613,454$3,021,942
Cumulative effect of adoption of new accounting standard, net of tax————12,05712,057
Balance at January 1, 201936,446$364$2,419,812$(11,688)$625,511$3,033,999
Net income————85,16985,169
Other comprehensive income———380—380
Exercise of stock options79110,637——10,638

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

Table 6 after “See accompanying notes.”

Download CSV
Common StockAdditionalPaid-In CapitalAccumulatedOtherComprehensive LossRetainedEarningsTotalStockholders’Equity
SharesAmount
Balance at December 31, 201736,107$361$2,339,253$(9,020)$320,656$2,651,250
Cumulative effect of adoption of new accounting standard, net of tax————54,46454,464
Balance at January 1, 201836,107$361$2,339,253$(9,020)$375,120$2,705,714
Net income————52,23152,231
Other comprehensive income———951—951
Exercise of stock options11119,327——9,328

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

Table 7 after “(unaudited)”

Download CSV
Three Months Ended March 31,
20192018
Operating activities:
Net income$85,169$52,231
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation and amortization19,65916,983
Amortization of deferred commissions costs12,40712,006
Amortization of debt issuance costs219219

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, 2019December 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:20192018
Net income$85,169$52,231
Denominator:
Denominator for basic net income per share — weighted-average outstanding shares36,23735,893
Effect of dilutive securities:
Stock options and restricted stock awards330457
Denominator for diluted net income per share — weighted-average outstanding shares36,56736,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,
20192018
Performance-based restricted stock awards8984

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,
20192018
Cost of revenues$2,058$1,431
Selling and marketing (excluding customer base amortization)1,6381,835
Software development2,0561,729
General and administrative6,2775,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,
20192018
North AmericaInternationalTotalNorth AmericaInternationalTotal
Information and analytics
CoStar Suite$140,973$6,728$147,701$123,886$6,475$130,361
Information services16,5912,25918,85012,6122,44815,060
Online marketplaces
Multifamily114,268—114,26887,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 period38,723
Effects of foreign currency134
Balance at March 31, 2019(1)$60,301
__________________________

Table 14 after “was as follows (in thousands):”

Download CSV
Three Months Ended March 31,
20192018
Commissions incurred$18,551$23,595
Commissions capitalized in the current period(13,729)(16,263)
Amortization of deferred commissions costs12,40712,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 receivable8,769
Indemnification asset5,443
Goodwill266,595
Intangible assets141,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 - basic1.47
Net income per share - diluted1.45

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

Download CSV
MaturityFair Value
Due:
April 1, 2019 — March 31, 2020$—
April 1, 2020 — March 31, 2024—
April 1, 2024 — March 31, 2029—
After March 31, 202910,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
AmortizedCostGrossUnrealizedGainsGross UnrealizedLossesFairValue
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
AmortizedCostGrossUnrealizedGainsGrossUnrealizedLossesFairValue
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, 2019December 31, 2018
AggregateFair ValueGrossUnrealizedLossesAggregateFair ValueGrossUnrealizedLosses
Auction rate securities$10,070$(730)$10,070$(730)
Investments in an unrealized loss position$10,070$(730)$10,070$(730)

Table 21 after “(in thousands):”

Download CSV
Level 1Level 2Level 3Total
Assets:
Money market funds$594,036$—$—$594,036
Auction rate securities——10,07010,070
Total assets measured at fair value$594,036$—$10,070$604,106

Table 22 after “(in thousands):”

Download CSV
Level 1Level 2Level 3Total
Assets:
Money market funds$590,567$—$—$590,567
Auction rate securities——10,07010,070
Total assets measured at fair value$590,567$—$10,070$600,637

Table 23 after “(in thousands):”

Download CSV
AuctionRateSecurities
Balance at December 31, 2017$10,070
Decrease in unrealized loss included in accumulated other comprehensive loss—
Balance at December 31, 201810,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 development952
Selling and marketing (excluding customer base amortization)2,191
General and administrative292
Total operating lease costs$6,673

Table 25 after “Supplemental balance sheet information related to operating leases was as follows (in thousands):”

Download CSV
BalanceBalance Sheet LocationMarch 31, 2019
Long-term lease liabilitiesLease and other long-term liabilities$119,172
Weighted average remaining lease term in years5.7
Weighted average discount rate4.2%

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

Download CSV
April 1, 2019 - March 31, 2020$31,652
April 1, 2020 - March 31, 202130,116
April 1, 2021 - March 31, 202227,193
April 1, 2022 - March 31, 202326,377
April 1, 2023 - March 31, 202424,421
Thereafter23,941
Total lease payments163,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
202029,255
202127,421
202225,634
202324,515
Thereafter31,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 AmericaInternationalTotal
Goodwill, December 31, 2017$1,253,494$29,963$1,283,457
Acquisitions319,59410,344329,938
Effect of foreign currency translation—(1,860)(1,860)
Goodwill, December 31, 20181,573,08838,4471,611,535
Effect of foreign currency translation—530530
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, 2019December 31, 2018Weighted-AverageAmortizationPeriod (in years)
Capitalized product development cost$2,173$2,1734
Accumulated amortization(2,173)(2,173)
Capitalized product development cost, net——
Building photography9,0879,0352
Accumulated amortization(8,949)(8,809)
Building photography, net138226
Acquired technology101,887103,1285

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,
20192018
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,
20192018
Net income$85,169$52,231
Amortization of acquired intangible assets in cost of revenues5,5134,608
Amortization of acquired intangible assets in operating expenses7,6825,803
Depreciation and other amortization6,4646,572
Interest and other income(4,945)(2,987)
Interest and other expense732690

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, 2019December 31, 2018
Property and equipment, net
North America$81,867$79,493
International4,1113,810
Total property and equipment, net$85,978$83,303
Goodwill
North America$1,573,088$1,573,088
International38,97738,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,
20192018
Net income$85,169$52,231
Amortization of acquired intangible assets in cost of revenues5,5134,608
Amortization of acquired intangible assets in operating expenses7,6825,803
Depreciation and other amortization6,4646,572
Interest and other income(4,945)(2,987)
Interest and other expense732690

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

Table 34 after “(in thousands):”

Download CSV
Three Months Ended March 31,
20192018Increase (Decrease) ($)Increase (Decrease) (%)
Revenues:
CoStar Suite$147,701$130,361$17,34013%
Information services18,85015,0603,79025
Multifamily114,26887,68326,58530
Commercial property and land47,60640,6146,99217
Total revenues328,425273,71854,70720

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

Table 35 after “ISSUER PURCHASES OF EQUITY SECURITIES”

Download CSV
Month, 2019Total Number ofSharesPurchasedAveragePrice Paidper ShareTotal Number ofSharesPurchased asPart of PubliclyAnnouncedPlans orProgramsMaximumNumber of Sharesthat May Yet BePurchased Underthe Plans orPrograms
January 1 through January 311,625$363.76——
February 1 through February 289,598451.05——
March 1 through March 3129,728462.77——
Total40,951(1)$456.09——

Table 36 after “41”

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, 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.