← Filings of CSGP

Tables in the 10-Q of COSTAR GROUP, INC.

32 tables with numbers, filed Apr 29, 2020. 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	9
	Notes to Condensed Consolidated Financial Statements	10

	Three Months Ended March 31,
	2020	2019
Revenues	$391,847		$328,425
Cost of revenues	78,909		71,153
Gross profit	312,938		257,272
Operating expenses:
Selling and marketing (excluding customer base amortization)	125,107		88,094
Software development	41,610		27,928

	March 31, 2020	December 31, 2019
ASSETS
Current assets:
Cash, cash equivalents and restricted cash	$1,927,923		$1,070,731
Accounts receivable	120,559		96,788
Less: Allowance for credit losses	(8,311)		(4,548)
Accounts receivable, net	112,248		92,240
Prepaid expenses and other current assets	30,219		36,194

	Common Stock	AdditionalPaid-In Capital		AccumulatedOtherComprehensive Loss	RetainedEarnings	TotalStockholders’Equity
	Shares	Amount
Balance at December 31, 2019	36,668		366		$2,473,338		$(8,585)	$940,474	$3,405,593
Net income	—		—		—		—	72,793	72,793
Other comprehensive loss	—		—		—		(12,219)	—	(12,219)
Exercise of stock options	41		1		9,232		—	—	9,233
Restricted stock grants	83		1		(1)		—	—	—
Restricted stock grants surrendered	(56)		(1)		(30,144)		—	—	(30,145)

	March 31, 2020	December 31, 2019
Foreign currency translation adjustment	$(20,804)		$(7,855)
Net unrealized loss on investments, net of tax	—		(730)
Total accumulated other comprehensive loss	$(20,804)		$(8,585)

	Three Months Ended March 31,
Numerator:	2020	2019
Net income	$72,793		$85,169
Denominator:
Denominator for basic net income per share — weighted-average outstanding shares	36,471		36,237
Effect of dilutive securities:
Stock options, restricted stock awards and restricted stock units	305		330
Denominator for diluted net income per share — weighted-average outstanding shares	36,776		36,567

Balance at December 31, 2019	$70,620
Revenue recognized in the current period from the amounts in the beginning balance	(38,354)
New deferrals, net of amounts recognized in the current period	56,602
Effects of foreign currency	(824)
Balance at March 31, 2020(1)	$88,044
__________________________

	Three Months Ended March 31, 2020
	CoStar Suite	Information services		Multifamily	Commercial property and land	Total
Beginning balance at December 31, 2019	$1,264		$624		$1,195		$1,465	$4,548
Current-period provision for expected credit losses(1), (2)	2,634		1,247		1,403		899	6,183
Write-offs charged against the allowance, net of recoveries and other	(1,372)		—		(565)		(483)	(2,420)
Ending balance at March 31, 2020	$2,526		$1,871		$2,033		$1,881	$8,311
__________________________

	Preliminary:October 22, 2019	Measurement Period Adjustments		Updated Preliminary:October 22, 2019
Cash and cash equivalents	$11,710		$(90)			$11,620
Accounts receivable	8,067					8,067
Lease right-of-use assets	7,306					7,306
Goodwill	261,436		432			261,868
Intangible assets	178,000					178,000
Lease liabilities	(7,306)				(7,306)
Deferred revenue	(10,966)				(10,966)

	North America	International
	Estimated Fair Value	Estimated Useful Life		Estimated Fair Value		Estimated Useful Life	Amortization Method
Customer base	$97,000		13		$42,000		10		Accelerated
Trade name	24,000		15					Straight-line
Other intangible assets	10,000		5		5,000		5		Straight-line
Total intangible assets	$131,000				$47,000

	Three Months Ended March 31,
	2020	2019
Commissions incurred	$22,437		$18,551
Commissions capitalized in the current period	(16,523)		(13,729)
Amortization of deferred commissions costs	14,747		12,407
Total commissions expense	$20,661		$17,229

	December 31, 2019
	AmortizedCost	GrossUnrealizedGains		Gross UnrealizedLosses	FairValue	Level 1		Level 2	Level 3
Cash equivalents	$576,761		$—		$—		$576,761		$576,761	$—	$—
Auction rate securities	10,800		—		(730)		10,070		—	—	10,070
Total cash equivalents and long-term investments	$587,561		$—		$(730)		$586,831		$576,761	$—	$10,070

Balance	Balance Sheet Location	March 31, 2020	December 31, 2019
Long-term lease liabilities	Lease and other long-term liabilities	$116,785		$120,153
Weighted-average remaining lease term in years		4.8		5.0
Weighted-average discount rate		3.9%		4.0%

	Three Months Ended March 31,
Cash paid for amounts included in the measurement of lease liabilities:	2020	2019
Operating cash flows used in operating leases	$8,709		$7,716
ROU assets obtained in exchange for lease obligations:
Operating leases	$5,080		$170

	Three Months EndedMarch 31, 2019
Revenue	$340,180
Net income	$79,423
Net income per share - basic	$2.19
Net income per share - diluted	$2.17

	Three Months Ended March 31,
Operating lease costs:	2020	2019
Cost of revenues	$2,894		$3,238
Software development	1,396		952
Selling and marketing (excluding customer base amortization)	2,539		2,191
General and administrative	1,174		292
Total operating lease costs	$8,003		$6,673

2020(1)	$26,214
2021	32,115
2022	31,915
2023	30,674
2024	25,040
Thereafter	12,981
Total lease payments	158,939
Less imputed interest	(14,473)

	March 31, 2020	December 31, 2019		Weighted-AverageAmortizationPeriod (in years)
Acquired technology and data	$104,933		$105,168		5
Accumulated amortization	(91,929)		(90,542)
Acquired technology and data, net	13,004		14,626
Acquired customer base	484,131		487,532		11
Accumulated amortization	(243,803)		(233,202)
Acquired customer base, net	240,328		254,330
Acquired trade names and other intangible assets	237,821		236,358		12

	March 31, 2020	December 31, 2019
Property and equipment, net:
North America	$102,843		$103,383
International	3,566		4,146
Total property and equipment, net	$106,409		$107,529
Goodwill:
North America	$1,738,679		$1,738,360
International	135,308		143,660

Month, 2020	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	2,002		$651.69		—	—
February 1 through February 29	14,537		670.83		—	—
March 1 through March 31	29,432		639.59		—	—
Total	45,971	(1)	$651.52		—	—
__________________________

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).
10.1	Asset Purchase Agreement, dated as of the Petition Date (on or about February 12, 2020), among CSGP Holdings, LLC, CoStar Group, Inc. (solely for the specified purposes), RentPath Holdings, Inc. and the other Sellers named therein (Incorporated by reference to Exhibit 10.1 to the Registrant’s Current Report on Form 8-K filed with the Commission on February 13, 2020).
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).

Tables in the 10-Q of COSTAR GROUP, INC.

Table 1 after “TABLE OF CONTENTS”

Table 2 after “(unaudited)”

Table 3 after “(unaudited)”

Table 4 after “(unaudited)”

Table 5 after “(unaudited)”

Table 6 after “(unaudited)”

Table 7 after “(unaudited)”

Table 8 after “The components of accumulated other comprehensive loss were as follows (in thousands):”

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

Table 10 after “The following table summarizes the shares underlying the unvested performance-based restricted stock and anti-dilutive securities excluded f”

Table 11 after “Stock-based compensation expense for stock options and restricted stock awards issued under equity incentive plans and stock purchases under”

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

Table 13 after “Changes in deferred revenue for the period were as follows (in thousands):”

Table 14 after “:”

Table 15 after “The following table details the activity related to the allowance for credit losses for trade receivables by portfolio segment (in thousands”

Table 16 after “The following table summarizes the amounts recorded for acquired assets and assumed liabilities recorded at their fair values as of the acqu”

Table 17 after “The following table summarizes the fair values (in thousands) of the identifiable intangible assets included in each of the Company's operat”

Table 18 after “The unaudited pro forma financial information, in the aggregate, was as follows (in thousands, except per share data):”

Table 19 after “(in thousands):”

Table 20 after “Lease costs related to the Company's operating leases included in the condensed consolidated statements of operations were as follows (in th”

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

Table 22 after “Supplemental cash flow information related to leases was as follows (in thousands):”

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

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

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

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

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

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

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

Table 30 after “(in thousands):”

Table 31 after “ISSUER PURCHASES OF EQUITY SECURITIES”

Table 32 after “44”