← Filings of CSGP

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

37 tables with numbers, filed Jul 27, 2022. 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 June 30,	Six Months Ended June 30,
	2022	2021		2022	2021
Revenues	$536,308		$480,333		$1,052,133	$938,030
Cost of revenues	100,971		89,566		196,450	178,314
Gross profit	435,337		390,767		855,683	759,716
Operating expenses:
Selling and marketing (excluding customer base amortization)	181,344		164,612		325,341	303,299
Software development	51,587		48,573		105,608	95,357

	June 30, 2022	December 31, 2021
ASSETS
Current assets:
Cash, cash equivalents and restricted cash	$3,964,116		$3,827,126
Accounts receivable	161,811		138,191
Less: Allowance for credit losses	(9,638)		(13,374)
Accounts receivable, net	152,173		124,817
Income tax receivable	9,278		—

	Common Stock	AdditionalPaid-In Capital		Accumulated Other Comprehensive Loss	Retained Earnings	Total Stockholders’ Equity
	Shares	Amount
Balance at December 31, 2021	394,936		$3,946		$4,253,318		$(5,758)	$1,460,166	$5,711,672
Net income	—		—		—		—	89,318	89,318
Other comprehensive loss	—		—		—		(6,356)	—	(6,356)
Restricted stock grants	1,277		13		(13)		—	—	—
Restricted stock grants surrendered	(403)		(4)		(19,455)		—	—	(19,459)
Stock-based compensation expense	—		—		18,005		—	—	18,005

	Common Stock	AdditionalPaid-In Capital(1)		Accumulated Other Comprehensive (Loss) Income	Retained Earnings	Total Stockholders’ Equity
	Shares(1)	Amount(1)
Balance at December 31, 2020	394,285		$3,943		$4,204,703		$(889)	$1,167,602	$5,375,359
Net income	—		—		—		—	74,212	74,212
Other comprehensive income	—		—		—		323	—	323
Exercise of stock options	206		2		6,339		—	—	6,341
Restricted stock grants	766		8		(7)		—	—	1
Restricted stock grants surrendered	(358)		(4)		(27,663)		—	—	(27,667)

	June 30, 2022	December 31, 2021
Foreign currency translation adjustment	$(29,956)		$(5,758)
Total accumulated other comprehensive loss	$(29,956)		$(5,758)

	Three Months Ended June 30,	Six Months Ended June 30,
Numerator:	2022	2021		2022	2021
Net income	$83,473		$61,148		$172,791	$135,360
Denominator:
Denominator for basic net income per share — weighted-average outstanding shares	393,342		392,306		393,119	391,942
Effect of dilutive securities:
Stock options, restricted stock awards and restricted stock units	1,136		1,792		1,237	1,964
Denominator for diluted net income per share — weighted-average outstanding shares	394,478		394,098		394,356	393,906

Balance at December 31, 2021(1)	$96,724
Revenue recognized in the current period from the amounts in the beginning balance	(68,766)
New deferrals, net of amounts recognized in the current period	79,158
Effects of foreign currency	(1,766)
Balance at June 30, 2022(2)	$105,350
__________________________

Balance	Balance Sheet Caption	June 30, 2022	December 31, 2021
Current portion	Prepaid expenses and other current assets	$2,994		$3,094
Non-current portion	Deposits and other assets	6,964		6,146
Total contract assets		$9,958		$9,240

	Six Months Ended June 30, 2022
	CoStar	Information Services		Multifamily	LoopNet		Other Marketplaces	Total
Beginning balance at December 31, 2021	$5,380		$1,820		$3,393	$1,968		$813	$13,374
Current-period provision for expected credit losses(1), (2)	3,422		(1,063)		2,676	1,805		50	6,890
Write-offs charged against the allowance, net of recoveries and other	(4,708)		9		(2,849)	(3,078)		—	(10,626)
Ending balance at June 30, 2022	$4,094		$766		$3,220	$695		$863	$9,638
__________________________

	Six Months Ended June 30,
	2022	2021
Operating activities:
Net income	$172,791		$135,360
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation and amortization	64,127		68,516
Amortization of deferred commissions costs	35,996		30,847
Amortization of Senior Notes discount and issuance costs	1,178		1,159

	Three Months Ended June 30,
	2022	2021
	North America	International		Total	North America	International		Total
CoStar	$197,380		$9,186		$206,566		$167,845		$9,134	$176,979
Information Services	30,511		7,991		38,502		28,096		7,061	35,157
Multifamily	182,359		—		182,359		171,357		—	171,357
LoopNet(1)	54,603		1,694		56,297		50,731		364	51,095
Residential(1)	20,154		—		20,154		18,087		—	18,087

	Six Months Ended June 30,
	2022	2021
	North America	International		Total	North America	International		Total
CoStar	$386,484		$18,731		$405,215		$331,399		$17,764	$349,163
Information Services	60,782		14,935		75,717		55,782		14,071	69,853
Multifamily	357,836		—		357,836		337,504		—	337,504
LoopNet(1)	107,291		3,453		110,744		99,667		658	100,325
Residential(1)	38,214		—		38,214		29,192		—	29,192

	Three Months Ended June 30,	Six Months Ended June 30,
	2022	2021		2022	2021
Commissions incurred	$38,423		$27,299		$75,238	$53,646
Commissions capitalized in the current period	(28,326)		(16,844)		(54,155)	(31,922)
Amortization of deferred commissions costs	18,413		15,530		35,996	30,847
Total commissions expense	$28,510		$25,985		$57,079	$52,571

	Six Months Ended June 30, 2021
	CoStar	Information Services		Multifamily	LoopNet(3)		Other Marketplaces(3)	Total
Beginning balance at December 31, 2020	$5,531		$2,739		$4,387	$1,667		$786	$15,110
Current-period provision for expected credit losses(1), (2)	2,890		16		1,698	1,482		—	6,086
Write-offs charged against the allowance, net of recoveries and other	(2,857)		(304)		(2,852)	(750)		—	(6,763)
Ending balance at June 30, 2021	$5,564		$2,451		$3,233	$2,399		$786	$14,433
__________________________

	Preliminary: May 24, 2021	Measurement Period Adjustments		Final: May 24, 2021
Cash, cash equivalents and restricted cash	$—		$—		$—
Accounts receivable	1,798		—		1,798
Lease right-of-use assets	371		—		371
Goodwill	91,875		—		91,875
Intangible assets	53,400		—		53,400
Deferred tax assets	7,862		—		7,862
Lease liabilities	(371)		—		(371)

	Estimated Fair Value	Estimated Useful Life		Amortization Method
Customer base	$32,000		8		Accelerated
Trade name	21,000		15		Straight-line
Technology	400		2		Straight-line
Total intangible assets	$53,400

	Three Months Ended June 30,	Six Months Ended June 30,
Operating lease costs:	2022	2021		2022	2021
Cost of revenues	$1,725		$2,405		$4,278	$4,729
Software development	1,345		1,610		3,129	3,003
Selling and marketing (excluding customer base amortization)	1,931		2,774		4,941	5,424
General and administrative	4,258		1,467		5,911	2,775
Total operating lease costs	$9,259		$8,256		$18,259	$15,931

Balance	Balance Sheet Location	June 30, 2022	December 31, 2021
Operating lease liabilities		$134,639		$134,150
Less: imputed interest		(7,624)		(8,512)
Present value of lease liabilities		127,015		125,638
Less: current portion of lease liabilities	Lease liabilities	35,426		26,268
Long-term lease liabilities	Lease and other long-term liabilities	$91,589		$99,370
Weighted-average remaining lease term in years		3.9	4.0
Weighted-average discount rate		3.1%		3.1%

	June 30, 2022	December 31, 2021		Weighted- Average Amortization Period (in years)
Acquired technology and data	$39,679		$41,979		5
Accumulated amortization	(16,911)		(15,333)
Acquired technology and data, net	22,768		26,646
Acquired customer base	485,309		569,666		10
Accumulated amortization	(267,345)		(319,039)
Acquired customer base, net	217,964		250,627
Acquired trade names and other intangible assets	252,052		262,136		12

	June 30, 2022	December 31, 2021
2.800% Senior Notes due July 15, 2030	$1,000,000		$1,000,000
2020 Credit Agreement, due July 1, 2025	—		—
Total face amount of long-term debt	1,000,000		1,000,000
Senior Notes unamortized discount and issuance costs	(11,428)		(12,056)
Long-term debt, net	$988,572		$987,944

Year Ending December 31,	Operating lease obligations	Long-term debt principal payments		Long-term interest payments
Remainder of 2022	$18,328		$—		$14,000
2023	40,286		—		28,000
2024	35,378		—		28,000
2025	18,080		—		28,000
2026	9,114		—		28,000
Thereafter	13,453		1,000,000		112,000
Total	$134,639		$1,000,000		$238,000

	June 30, 2022	December 31, 2021
Property and equipment, net:
North America	$297,443		$269,792
International	918		1,639
Total property and equipment, net	$298,361		$271,431
Goodwill:
North America	$2,149,247		$2,145,846
International	164,929		175,169

2022	Total Number ofSharesPurchased (1)	AveragePrice Paidper Share		Total Number of Shares Purchased as Part of Publicly Announced Plans or Programs	Maximum Number of Shares that May Yet Be Purchased Under the Plans or Programs
April 1 through 30	49		$61.82		—	—
May 1 through 31	4,184		61.58		—	—
June 1 through 30	5,440		60.13		—	—
Total	9,673		$60.40		—	—
__________________________

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 “NOTES TO CONDENSED CONSOLIDATED FINANCIAL STATEMENTS (unaudited)”

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

Table 12 after “NOTES TO CONDENSED CONSOLIDATED FINANCIAL STATEMENTS (unaudited)”

Table 13 after “As of September 30, 2021, Commercial Property and Land revenue has been further disaggregated into LoopNet, Residential and Other Marketplac”

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

Table 15 after “Contract assets as of June 30, 2022 and December 31, 2021 were as follows (in thousands):”

Table 16 after “deferred commissions were impaired as of June 30, 2022:”

Table 17 after “NOTES TO CONDENSED CONSOLIDATED FINANCIAL STATEMENTS (unaudited)”

Table 18 after “Credit loss expense related to contract assets was not material for the six months ended June 30, 2022.”

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

Table 20 after “The following table summarizes the fair values of the identifiable intangible assets acquired in the Homes.com acquisition included in the C”

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

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

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

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

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

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

Table 27 after “The table below presents the components of outstanding debt (in thousands):”

Table 28 after “The Company recognized interest expense as follows (in thousands):”

Table 29 after “The following summarizes the Company's significant contractual obligations, including related payments due by period, as of June 30, 2022 (i”

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

Table 31 after “NOTES TO CONDENSED CONSOLIDATED FINANCIAL STATEMENTS (unaudited)”

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

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 ”

Table 34 after “The following table provides a comparison of our selected consolidated results of operations for the three months ended June 30, 2022 and Ju”

Table 35 after “The following table provides a comparison of our selected consolidated results of operations for the six months ended June 30, 2022 and 2021”

Table 36 after “ISSUER PURCHASES OF EQUITY SECURITIES”

Table 37 after “Exhibits”

Exhibit No.	Description
3.1	Fourth 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 Securities and Exchange Commission on June 7, 2021).
3.2	Fourth 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 Securities and Exchange Commission on May 6, 2022).
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 (furnished 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 (furnished herewith).
101.INS	The following financial statements from the Company’s Quarterly Report on Form 10-Q for the quarter ended June 30, 2022, formatted in Inline XBRL: (i) Condensed Consolidated Statements of Operations; (ii) Condensed Consolidated Statements of Comprehensive Income; (iii) Condensed Consolidated Balance Sheets; (iv) Condensed Consolidated Statements of Changes in Stockholders’ Equity (v) Condensed Consolidated Statements of Cash Flows; and (vi) Notes to Condensed Consolidated Financial Statements, tagged as blocks of text and including detailed tags.