← Filings of CSGP

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

29 tables with numbers, filed Jul 25, 2014. 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	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	26

	Three Months Ended June 30,	Six Months Ended June 30,
	2014	2013		2014	2013
Revenues	$147,708		$108,999		$266,784	$213,032
Cost of revenues	39,481		32,101		73,124	65,707
Gross margin	108,227		76,898		193,660	147,325
Operating expenses:
Selling and marketing	40,889		23,536		68,634	50,514
Software development	15,143		11,488		27,494	23,590

	June 30, 2014	December 31, 2013
ASSETS	(unaudited)
Current assets:
Cash and cash equivalents	$444,857		$255,953
Accounts receivable, less allowance for doubtful accounts of approximately $4,853 and $3,397 as of June 30, 2014 and December 31, 2013, respectively	39,661		20,761
Deferred and other income taxes, net	32,436		22,506
Prepaid expenses and other current assets	10,698		6,597
Debt issuance costs, net	3,362		2,649

	June 30, 2014	December 31, 2013
Foreign currency translation adjustment	$(3,042)		$(4,003)
Accumulated net unrealized loss on investments, net of tax	(1,328)		(1,527)
Total accumulated other comprehensive loss	$(4,370)		$(5,530)

	Three Months Ended June 30,	Six Months Ended June 30,
Numerator:	2014	2013		2014	2013
Net income	$8,249		$8,293		$17,989	$5,883
Denominator:
Denominator for basic net income per share — weighted-average outstanding shares	29,061		27,636		28,667	27,532
Effect of dilutive securities:
Stock options and restricted stock	425		532		496	500
Denominator for diluted net income per share — weighted-average outstanding shares	29,486		28,168		29,163	28,032

Accounts receivable	$11,402
Goodwill	421,724
Acquired trade names and other	71,779
Acquired customer base	69,684
Acquired database technology	11,489
Acquired building photography	1,006
Other assets and liabilities	(2,866)
Fair value of identifiable net assets acquired	$584,218

Maturity	Fair Value
Due:
July 1, 2014 — June 30, 2015	$—
July 1, 2015 — June 30, 2019	850
July 1, 2019 — June 30, 2024	—
After June 30, 2024	20,789
Available-for-sale investments	$21,639

	AmortizedCost	GrossUnrealizedGains		Gross UnrealizedLosses	FairValue
Auction rate securities	$22,967		$408		$(1,736)	$21,639
Available-for-sale investments	$22,967		$408		$(1,736)	$21,639

	AmortizedCost	GrossUnrealizedGains		GrossUnrealizedLosses	FairValue
Auction rate securities	$23,517		$411		$(1,938)	$21,990
Available-for-sale investments	$23,517		$411		$(1,938)	$21,990

	June 30, 2014	December 31, 2013
	AggregateFair Value	GrossUnrealizedLosses		AggregateFair Value	GrossUnrealizedLosses
Auction rate securities	$20,789		$(1,736)		$21,137	$(1,938)
Investments in an unrealized loss position	$20,789		$(1,736)		$21,137	$(1,938)

	Six Months Ended June 30,
	2014	2013
Operating activities:
Net income	$17,989		$5,883
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation	7,161		5,917
Amortization	23,360		14,298
Amortization of debt issuance costs	1,555		1,513

	Three Months Ended June 30,	Six Months Ended June 30,
	2014	2013		2014	2013
Cost of revenues	$1,056		$891		$2,264	$2,292
Selling and marketing	674		1,011		1,775	2,819
Software development	1,241		1,400		2,688	3,831
General and administrative	3,409		3,854		7,532	15,540
Total stock-based compensation	$6,380		$7,156		$14,259	$24,482

	Level 1	Level 2		Level 3	Total
Assets:
Cash	$134,989		$—		$—	$134,989
Money market funds	50,593		—		—	50,593
Commercial paper	70,371		—		—	70,371
Auction rate securities	—		—		21,990	21,990
Total assets measured at fair value	$255,953		$—		$21,990	$277,943
Liabilities:

	North America	International		Total
Goodwill, December 31, 2012	$692,639		$25,439		$718,078
Effect of foreign currency translation	—		509		509
Goodwill, December 31, 2013	692,639		25,948		718,587
Acquisition	421,724		—		421,724
Effect of foreign currency translation	—		876		876
Goodwill, June 30, 2014	$1,114,363		$26,824		$1,141,187

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

	DeferredConsideration
Balance at December 31, 2012	$2,304
Accretion for 2013	384
Payments made in 2013	(1,344)
Balance at December 31, 2013	1,344
Payments made from January 1, 2014 – June 30, 2014	(1,344)
Balance at June 30, 2014	$—

	June 30, 2014	December 31, 2013		Weighted-AverageAmortizationPeriod (in years)
Capitalized product development cost	$2,140		$2,140		4
Accumulated amortization	(2,124)		(2,029)
Capitalized product development cost, net	16		111
Building photography	14,944		13,743		5
Accumulated amortization	(12,414)		(12,005)
Building photography, net	2,530		1,738
Acquired database technology	88,926		77,368		4

Reconciliation of EBITDA to net income
EBITDA	$37,579	$25,332	$64,571	$32,900
Purchase amortization in cost of revenues	(7,880)	(3,026)	(10,757)	(6,053)
Purchase amortization in operating expenses	(9,036)	(3,894)	(12,335)	(8,019)
Depreciation and other amortization	(3,754)	(3,129)	(7,429)	(6,143)
Interest income	62	83	199	187
Interest expense	(3,753)	(1,758)	(5,368)	(3,513)
Income tax expense, net	(4,969)	(5,315)	(10,892)	(3,476)

	June 30, 2014	December 31, 2013
Property and equipment, net
North America	$61,171		$53,733
International	3,469		3,986
Total property and equipment, net	$64,640		$57,719
Goodwill
North America	$1,114,363		$692,639
International	26,824		25,948

Month, 2014	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,084		$188.22		—	—
May 1 through May 31	36,421		157.60		—	—
June 1 through June 30	819		159.05		—	—
Total	44,324	(1)	$162.52		—	—

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

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 per share (in thousands, except per share data):”

Table 8 after “Employee stock options with exercise prices greater than the average market price of the Company’s common stock for the period are excluded ”

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

Table 10 after “The Company applied the acquisition method to account for the Apartments.com transaction, which requires that, among other things, assets ac”

Table 11 after “The following unaudited pro forma amounts present consolidated information as if the acquisition had been completed as of January 1, 2013 (i”

Table 12 after “are 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 “, the amortized cost basis and fair value of investments classified as available-for-sale were as follows (in thousands):”

Table 15 after “The components of the Company’s investments in an unrealized loss position for twelve months or longer were as follows (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 “(in thousands):”

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

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

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 “Summarized information by operating segment consists of the following (in thousands):”

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

Table 28 after “ISSUER PURCHASES OF EQUITY SECURITIES”

Table 29 after “INDEX TO EXHIBITS”