← Filings of CSGP

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

28 tables with numbers, filed Jul 24, 2013. 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

	Three Months Ended June 30,	Six Months Ended June 30,
	2013	2012		2013	2012
Revenues	$108,999		$85,223		$213,032	$153,852
Cost of revenues	32,101		28,172		65,707	52,506
Gross margin	76,898		57,051		147,325	101,346
Operating expenses:
Selling and marketing	23,536		20,016		50,514	35,566
Software development	11,488		7,977		23,590	12,992

	June 30, 2013	December 31, 2012
ASSETS	(unaudited)
Current assets:
Cash and cash equivalents	$190,101		$156,027
Short-term investments	—		37
Accounts receivable, less allowance for doubtful accounts of approximately $3,151 and $2,935 as of June 30, 2013 and December 31, 2012, respectively	24,808		16,392
Deferred income taxes, net	16,721		9,256
Income tax receivable	1,796		5,357

	June 30, 2013	December 31, 2012
Foreign currency translation adjustment	$(6,245)		$(4,613)
Accumulated net unrealized loss on investments, net of tax	(1,842)		(1,905)
Total accumulated other comprehensive loss	$(8,087)		$(6,518)

	Three Months Ended June 30,	Six Months Ended June 30,
Numerator:	2013	2012		2013	2012
Net income (loss)	$8,293		$(6,710)		$5,883	$(1,578)
Denominator:
Denominator for basic net income (loss) per share — weighted-average outstanding shares	27,636		26,465		27,532	25,797
Effect of dilutive securities:
Stock options and restricted stock	532		—		500	—
Denominator for diluted net income (loss) per share — weighted-average outstanding shares	28,168		26,465		28,032	25,797

Cash	$746,393
Equity interest (1,880,300 shares at $72.89)	137,055
Fair value of total consideration transferred	$883,448

Cash and cash equivalents	$105,464
Accounts receivable	3,021
Goodwill	625,174
Acquired trade names and other	48,700
Acquired customer base	71,500
Acquired database technology	52,100
Deferred income taxes, net	(32,623)
Other assets and liabilities	10,112

Maturity	Fair Value
Due:
July 1, 2013 — June 30, 2014	$—
July 1, 2014 — June 30, 2018	606
July 1, 2018 — June 30, 2023	—
After June 30, 2023	21,069
Available-for-sale investments	$21,675

	AmortizedCost	GrossUnrealizedGains		Gross UnrealizedLosses	FairValue
Auction rate securities	$23,517		$164		$(2,006)	$21,675
Available-for-sale investments	$23,517		$164		$(2,006)	$21,675

	AmortizedCost	GrossUnrealizedGains		GrossUnrealizedLosses	FairValue
Government-sponsored enterprise obligations	$37		$—		$—	$37
Auction rate securities	23,567		101		(2,006)	21,662
Available-for-sale investments	$23,604		$101		$(2,006)	$21,699

	Six Months Ended June 30,
	2013	2012
Operating activities:
Net income (loss)	$5,883		$(1,578)
Adjustments to reconcile net income (loss) to net cash provided by operating activities:
Depreciation	5,917		4,472
Amortization	14,298		7,032
Amortization of debt issuance costs	1,513		472

	Three Months Ended June 30,	Six Months Ended June 30,
	2013	2012		2013	2012
Cost of revenues	$891		$556		$2,292	$935
Selling and marketing	1,011		530		2,819	838
Software development	1,400		425		3,831	756
General and administrative	3,854		1,230		15,540	2,399
Total stock-based compensation	$7,156		$2,741		$24,482	$4,928

	Level 1	Level 2		Level 3	Total
Assets:
Cash	$101,583		$—		$—	$101,583
Money market funds	54,153		—		—	54,153
Commercial paper	34,365		—		—	34,365
Auction rate securities	—		—		21,675	21,675
Total assets measured at fair value	$190,101		$—		$21,675	$211,776
Liabilities:

	DeferredConsideration
Balance at December 31, 2011	$—
Deferred consideration upon acquisition	2,011
Accretion for 2012	293
Balance at December 31, 2012	2,304
Accretion from January 1, 2013 – March 31, 2013	126
Payments made from January 1, 2013 – March 31, 2013	(1,344)
Balance at March 31, 2013	1,086

	June 30, 2013	December 31, 2012
	AggregateFair Value	GrossUnrealizedLosses		AggregateFair Value	GrossUnrealizedLosses
Government-sponsored enterprise obligations	$—		$—		$37	$—
Auction rate securities	21,069		(2,006)		21,119	(2,006)
Investments in an unrealized loss position	$21,069		$(2,006)		$21,156	$(2,006)

	AuctionRateSecurities
Balance at December 31, 2007	$53,975
Change in unrealized loss included in accumulated other comprehensive loss	(3,710)
Settlements	(20,925)
Balance at December 31, 2008	29,340
Change in unrealized gain included in accumulated other comprehensive loss	684
Settlements	(300)
Balance at December 31, 2009	29,724

	United States	International		Total
Goodwill, December 31, 2011	$67,465		$24,319		$91,784
Acquisitions	625,174		—		625,174
Effect of foreign currency translation	—		1,120		1,120
Goodwill, December 31, 2012	692,639		25,439		718,078
Effect of foreign currency translation	—		(1,498)		(1,498)
Goodwill, June 30, 2013	$692,639		$23,941		$716,580

	June 30, 2013	December 31, 2012		Weighted-AverageAmortizationPeriod (in years)
Capitalized product development cost	$2,140		$2,140		4
Accumulated amortization	(1,933)		(1,838)
Capitalized product development cost, net	207		302
Building photography	13,132		12,474		5
Accumulated amortization	(11,605)		(11,639)
Building photography, net	1,527		835
Acquired database technology	77,210		77,328		5

Reconciliation of EBITDA to net income (loss)
EBITDA	$25,332	$8,171	$32,900	$20,093
Purchase amortization in cost of revenues	(3,026)	(2,158)	(6,053)	(2,580)
Purchase amortization in operating expenses	(3,894)	(3,580)	(8,019)	(4,214)
Depreciation and other amortization	(3,129)	(2,446)	(6,143)	(4,710)
Interest income	83	131	187	381
Interest expense	(1,758)	(1,200)	(3,513)	(1,200)
Income tax expense, net	(5,315)	(5,628)	(3,476)	(9,348)

	June 30, 2013	December 31, 2012
Property and equipment, net
United States	$46,832		$42,480
International	2,861		3,828
Total property and equipment, net	$49,693		$46,308
Goodwill
United States	$692,639		$692,639
International	23,941		25,439

Month, 2013	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	7,278		$107.73		—	—
May 1 through May 31	28,339		112.01		—	—
June 1 through June 30	855		111.81		—	—
Total	36,472	(1)	$111.15		—	—

Exhibit No.	Description
2.1	Agreement and Plan of Merger, dated as of April 27, 2011, by and among CoStar Group, Inc., Lonestar Acquisition Sub, Inc. and LoopNet, Inc. (Incorporated by reference to Exhibit 2.1 to the Registrant's Current Report on Form 8-K filed with the Commission on April 28, 2011).
2.2	Amendment No. 1 to the Agreement and Plan of Merger, dated as of May 20, 2011, among LoopNet, Inc., the Registrant and Lonestar Acquisition Sub, Inc. (Incorporated by reference to Exhibit 2.1 to the Registrant's Current Report on Form 8-K filed with the Commission on May 23, 2011).
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	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 April 6, 2011).
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).

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 “(in thousands)”

Table 5 after “(unaudited)”

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

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):”

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

Table 9 after “The following table summarizes the consideration paid for LoopNet (in thousands except share and per share data):”

Table 10 after “The Company has applied the acquisition method to account for the LoopNet transaction, which requires that, among other things, assets acqui”

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

Table 12 after “, the amortized cost basis and fair value of investments classified as available-for-sale were as follows (in thousands):”

Table 13 after “, the amortized cost basis and fair value of investments classified as available-for-sale were as follows (in thousands):”

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

Table 15 after “(in thousands):”

Table 16 after “(in thousands):”

Table 17 after “(in thousands):”

Table 18 after “(in thousands):”

Table 19 after “(in thousands):”

Table 20 after “(in thousands):”

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

Table 22 after “Intangibles and other assets consist of the following (in thousands, except amortization period data):”

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

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

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

Table 26 after “The following table shows our EBITDA reconciled to our net income (loss) and our net cash flows from operating, investing and financing acti”

Table 27 after “ISSUER PURCHASES OF EQUITY SECURITIES”

Table 28 after “INDEX TO EXHIBITS”