XML 26 R46.htm IDEA: XBRL DOCUMENT v2.4.0.8
Guarantor Subsidiaries (Tables)
12 Months Ended
Dec. 31, 2013
Guarantor Subsidiaries [Abstract]  
Schedule Of Guarantor Subsidiaries
The following condensed consolidating financial information reflects CoreLogic, Inc.'s (the "Parent's") separate accounts, the combined accounts of the guarantor subsidiaries, the combined accounts of the non-guarantor subsidiaries, the combined consolidating adjustments and eliminations and the Parent's consolidated accounts for the dates and periods indicated.

 
 
Condensed Balance Sheet
 
 
As of December 31, 2013
 
 
Parent
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiaries
 
Consolidating/Eliminating Adjustments
 
Total
Assets:
 
 
 
 
 
 
 
 
 
 
Cash and cash equivalents
 
$
104,632

 
$

 
$
30,109

 
$

 
$
134,741

Accounts receivable
 

 
174,518

 
21,764

 

 
196,282

Other current assets
 
57,368

 
249,680

 
3,543

 

 
310,591

Property and equipment, net
 
20,076

 
147,951

 
27,618

 

 
195,645

Goodwill, net
 

 
1,228,855

 
161,819

 

 
1,390,674

Other intangible assets, net
 
348

 
135,326

 
40,134

 

 
175,808

Capitalized data and database cost, net
 

 
249,472

 
80,716

 

 
330,188

Investment in affiliates, net
 

 
95,343

 

 

 
95,343

Deferred income tax assets, long-term
 
58,998

 

 

 
(58,998
)
 

Restricted cash
 
10,335

 
306

 
1,409

 

 
12,050

Investment in subsidiaries
 
2,209,926

 

 

 
(2,209,926
)
 

Intercompany receivable
 
63,647

 
555,216

 
9,170

 
(628,033
)
 

Other assets
 
118,708

 
41,221

 
2,104

 

 
162,033

Total assets
 
$
2,644,038

 
$
2,877,888

 
$
378,386

 
$
(2,896,957
)
 
$
3,003,355

 
 
 
 
 
 
 
 
 
 
 
Liabilities and equity:
 
 
 
 
 
 
 
 
 
 
Current liabilities
 
$
107,340

 
$
397,481

 
$
33,206

 
$

 
$
538,027

Long-term debt, net of current
 
806,395

 
5,381

 

 

 
811,776

Deferred revenue, net of current
 

 
377,077

 
9

 

 
377,086

Deferred income tax liabilities, long term
 

 
109,003

 
24,303

 
(58,998
)
 
74,308

Intercompany payable
 
564,386

 

 
63,647

 
(628,033
)
 

Other liabilities
 
121,544

 
22,768

 
3,271

 

 
147,583

Redeemable noncontrolling interest
 

 

 
10,202

 

 
10,202

Total CoreLogic stockholders' equity
 
1,044,373

 
1,966,178

 
243,748

 
(2,209,926
)
 
1,044,373

Total liabilities and equity
 
$
2,644,038

 
$
2,877,888

 
$
378,386

 
$
(2,896,957
)
 
$
3,003,355


 
 
Condensed Balance Sheet
 
 
As of December 31, 2012
 
 
Parent
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiaries
 
Consolidating/Eliminating Adjustments
 
Total
Assets:
 
 
 
 
 
 
 
 
 
 
Cash and cash equivalents
 
$
111,305

 
$
5,889

 
$
34,792

 
$

 
$
151,986

Accounts receivable
 

 
195,078

 
14,065

 

 
209,143

Other current assets
 
59,977

 
309,438

 
16,667

 
(441
)
 
385,641

Property and equipment, net
 
14,921

 
134,411

 
31,865

 

 
181,197

Goodwill, net
 

 
1,186,413

 
168,410

 

 
1,354,823

Other intangible assets, net
 

 
122,461

 
48,573

 

 
171,034

Capitalized data and database cost, net
 

 
238,598

 
83,691

 

 
322,289

Investment in affiliates, net
 

 
88,647

 
5,580

 

 
94,227

Deferred income tax assets, long-term
 
59,523

 

 

 
(59,523
)
 

Restricted cash
 
18,299

 
306

 
3,513

 

 
22,118

Investment in subsidiaries
 
2,076,244

 

 

 
(2,076,244
)
 

Intercompany receivable
 
65,025

 
347,411

 

 
(412,436
)
 

Other assets
 
107,976

 
27,456

 
2,438

 

 
137,870

Total assets
 
$
2,513,270

 
$
2,656,108

 
$
409,594

 
$
(2,548,644
)
 
$
3,030,328

 
 
 
 
 
 
 
 
 
 
 
Liabilities and equity:
 
 
 
 
 
 
 
 
 
 
Current liabilities
 
$
82,668

 
$
423,146

 
$
28,833

 
$
(441
)
 
$
534,206

Long-term debt, net of current
 
783,470

 
8,854

 

 

 
792,324

Deferred revenue, net of current
 

 
309,418

 

 

 
309,418

Deferred income taxes liabilities, long term
 

 
99,071

 
20,673

 
(59,523
)
 
60,221

Intercompany payable
 
347,410

 

 
65,026

 
(412,436
)
 

Other liabilities
 
130,421

 
27,537

 
5,255

 

 
163,213

Total CoreLogic stockholders' equity
 
1,169,301

 
1,788,082

 
288,162

 
(2,076,244
)
 
1,169,301

Noncontrolling interests
 

 

 
1,645

 

 
1,645

Total liabilities and equity
 
$
2,513,270

 
$
2,656,108

 
$
409,594

 
$
(2,548,644
)
 
$
3,030,328


 
 
Condensed Statement of Operations
 
 
For the year ended December 31, 2013
 
 
Parent
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiaries
 
Consolidating/Eliminating Adjustments
 
Total
Operating revenue
 
$

 
$
1,229,344

 
$
101,286

 
$

 
$
1,330,630

Intercompany revenue
 

 

 
631

 
(631
)
 

Cost of services (exclusive of depreciation and amortization below)
 

 
632,055

 
38,804

 
(631
)
 
670,228

Selling, general and administrative expenses
 
63,205

 
262,453

 
34,848

 

 
360,506

Depreciation and amortization
 
3,767

 
99,358

 
23,895

 

 
127,020

Operating (loss)/income
 
(66,972
)
 
235,478

 
4,370

 

 
172,876

Total interest expense, net
 
(45,270
)
 
(49
)
 
(2,330
)
 

 
(47,649
)
Gain on investments and other, net
 
3,785

 
1,250

 
6,997

 

 
12,032

(Benefit)/Provision for income taxes
 
(40,392
)
 
73,185

 
1,680

 

 
34,473

Equity in earnings of affiliates, net of tax
 

 
26,566

 
795

 

 
27,361

Equity in earnings of subsidiary, net of tax
 
175,793

 

 

 
(175,793
)
 

Net income/(loss) from continuing operations
 
107,728

 
190,060

 
8,152

 
(175,793
)
 
130,147

Loss from discontinued operations, net of tax
 

 
(15,292
)
 
(172
)
 

 
(15,464
)
(Loss)/gain from sale of discontinued operations, net of tax
 

 
(8,514
)
 
1,506

 

 
(7,008
)
Net income/(loss)
 
107,728

 
166,254

 
9,486

 
(175,793
)
 
107,675

Less: Net loss attributable to noncontrolling interests
 

 

 
(53
)
 

 
(53
)
Net income/(loss) attributable to CoreLogic
 
$
107,728

 
$
166,254

 
$
9,539

 
$
(175,793
)
 
$
107,728

 
 
 
 
 
 
 
 
 
 
 
Net income
 
$
107,728

 
$
166,254

 
$
9,486

 
$
(175,793
)
 
$
107,675

Total other comprehensive (loss)/income
 
(38,075
)
 

 
(43,337
)
 
43,337

 
(38,075
)
Less: Comprehensive loss attributable to noncontrolling interests
 

 

 
(53
)
 

 
(53
)
Comprehensive income/(loss) attributable to CoreLogic
 
$
69,653

 
$
166,254

 
$
(33,798
)
 
$
(132,456
)
 
$
69,653


 
 
Condensed Statement of Operations
 
 
For the year ended December 31, 2012
 
 
Parent
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiaries
 
Consolidating/Eliminating Adjustments
 
Total
Operating revenue
 
$

 
$
1,146,040

 
$
89,343

 
$

 
$
1,235,383

Intercompany revenue
 

 

 
1,955

 
(1,955
)
 

Cost of services (exclusive of depreciation and amortization below)
 

 
576,622

 
34,732

 
(1,955
)
 
609,399

Selling, general and administrative expenses
 
65,637

 
235,273

 
33,318

 

 
334,228

Depreciation and amortization
 
2,937

 
95,849

 
22,998

 

 
121,784

Operating (loss)/income
 
(68,574
)
 
238,296

 
250

 

 
169,972

Total interest expense, net
 
(50,222
)
 
(192
)
 
(2,339
)
 

 
(52,753
)
Gain/(loss) on investments and other, net
 
3,492

 
(6,008
)
 

 

 
(2,516
)
(Benefit)/provision for income taxes
 
(44,908
)
 
100,471

 
4,939

 

 
60,502

Equity in earnings of affiliates, net of tax
 

 
35,153

 
830

 

 
35,983

Equity in earnings/(losses) of subsidiary, net of tax
 
182,689

 

 

 
(182,689
)
 

Net income/(loss) from continuing operations
 
112,293

 
166,778

 
(6,198
)
 
(182,689
)
 
90,184

Income from discontinued operations, net of tax
 

 
21,933

 
(4,310
)
 

 
17,623

Loss on sale of discontinued operations, net of tax
 

 
3,841

 

 

 
3,841

Net income/(loss)
 
112,293

 
192,552

 
(10,508
)
 
(182,689
)
 
111,648

Less: Net loss attributable to noncontrolling interests
 

 

 
(645
)
 

 
(645
)
Net income/(loss) attributable to CoreLogic
 
$
112,293

 
$
192,552

 
$
(9,863
)
 
$
(182,689
)
 
$
112,293

 
 
 
 
 
 
 
 
 
 
 
Net income/(loss)
 
$
112,293

 
$
192,552

 
$
(10,508
)
 
$
(182,689
)
 
$
111,648

Total other comprehensive income/(loss)
 
4,802

 

 
5,921

 
(5,921
)
 
4,802

Less: Comprehensive income attributable to noncontrolling interests
 

 

 
(645
)
 

 
(645
)
Comprehensive income/(loss) attributable to CoreLogic
 
$
117,095

 
$
192,552

 
$
(3,942
)
 
$
(188,610
)
 
$
117,095


 
 
Condensed Statement of Operations
 
 
For the year ended December 31, 2011
 
 
Parent
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiaries
 
Consolidating/Eliminating Adjustments
 
Total
Operating revenue
 
$

 
$
956,984

 
$
53,195

 
$

 
$
1,010,179

Intercompany revenue
 

 

 
45,678

 
(45,678
)
 

Cost of services (exclusive of depreciation and amortization below)
 

 
497,602

 
63,523

 
(43,251
)
 
517,874

Selling, general and administrative expenses
 
97,780

 
230,320

 
21,709

 
(2,427
)
 
347,382

Depreciation and amortization
 
3,702

 
85,651

 
18,710

 

 
108,063

Operating (loss)/income
 
(101,482
)
 
143,411

 
(5,069
)
 

 
36,860

Total interest expense, net
 
(55,564
)
 
(1,263
)
 
(1,678
)
 

 
(58,505
)
Gain/(loss) on investments and other, net
 
64,984

 
(4,316
)
 
82

 

 
60,750

(Benefit)/provision for income taxes
 
(65,471
)
 
113,379

 
(371
)
 

 
47,537

Equity in earnings of affiliates, net of tax
 

 
30,323

 
192

 

 
30,515

Equity in losses of subsidiary, net of tax
 
(48,018
)
 

 

 
48,018

 

Net (loss)/income from continuing operations
 
(74,609
)
 
54,776

 
(6,102
)
 
48,018

 
22,083

Loss from discontinued operations, net of tax
 

 
(98,980
)
 
3,268

 

 
(95,712
)
Net loss
 
(74,609
)
 
(44,204
)
 
(2,834
)
 
48,018

 
(73,629
)
Less: Net income attributable to noncontrolling interests
 

 

 
980

 

 
980

Net loss attributable to CoreLogic
 
$
(74,609
)
 
$
(44,204
)
 
$
(3,814
)
 
$
48,018

 
$
(74,609
)
 
 
 
 
 
 
 
 
 
 
 
Net loss
 
$
(74,609
)
 
$
(44,204
)
 
$
(2,834
)
 
$
48,018

 
$
(73,629
)
Total other comprehensive loss
 
(36,259
)
 
(14,093
)
 
(12,612
)
 
26,705

 
(36,259
)
Less: Comprehensive income attributable to noncontrolling interests
 

 

 
980

 

 
980

Comprehensive loss attributable to CoreLogic
 
$
(110,868
)
 
$
(58,297
)
 
$
(16,426
)
 
$
74,723

 
$
(110,868
)

 
 
Condensed Statement of Cash Flows
 
 
For the year ended December 31, 2013
 
 
Parent
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiaries
 
Consolidating/Eliminating Adjustments
 
Total
Cash flows from operating activities:
 
 
 
 
 
 
 
 
 
 
Net cash (used in)/provided by operating activities - continuing operations
 
$
(52,150
)
 
$
328,483

 
$
26,080

 
$

 
$
302,413

Net cash provided by operating activities - discontinued operations
 

 
49,902

 
1,506

 

 
51,408

Total cash (used in)/provided by operating activities
 
$
(52,150
)
 
$
378,385

 
$
27,586

 
$

 
$
353,821

Cash flow from investing activities:
 
 
 
 
 
 
 
 
 


Purchases of property and equipment
 
$
(8,870
)
 
$
(51,655
)
 
$
(8,215
)
 
$

 
$
(68,740
)
Purchases of capitalized data and other intangible assets
 
(348
)
 
(23,171
)
 
(14,322
)
 

 
(37,841
)
Cash paid for acquisitions, net of cash acquired
 

 
(92,591
)
 
542

 

 
(92,049
)
Cash received from sale of subsidiary, net
 

 
2,263

 

 

 
2,263

Purchases of investments
 

 
(2,351
)
 

 

 
(2,351
)
Change in restricted cash
 
7,964

 

 
2,104

 

 
10,068

Net cash used in investing activities - continuing operations
 
(1,254
)
 
(167,505
)
 
(19,891
)
 

 
(188,650
)
Net cash used in investing activities - continuing operations
 

 
1,857

 

 

 
1,857

Total cash used in by investing activities
 
$
(1,254
)
 
$
(165,648
)
 
$
(19,891
)
 
$

 
$
(186,793
)
Cash flow from financing activities:
 
 
 
 
 
 
 
 
 


Proceeds from long-term debt
 
$
50,000

 
$
1,647

 
$

 
$

 
$
51,647

Debt issuance costs
 

 
(10,436
)
 

 

 
(10,436
)
Repayments of long-term debt
 
(4,375
)
 
(291
)
 

 

 
(4,666
)
Shares repurchased and retired
 
(241,161
)
 

 

 

 
(241,161
)
Proceeds from issuance of stock related to stock options and employee benefit plans
 
28,232

 

 

 

 
28,232

Minimum tax withholding paid on behalf of employees for restricted stock units
 
(8,665
)
 

 

 

 
(8,665
)
Tax benefit related to stock options
 
5,146

 

 

 

 
5,146

Intercompany loan payments
 

 
(208,194
)
 
(10,262
)
 
218,456

 

Intercompany loan proceeds
 
218,456

 

 

 
(218,456
)
 

Net cash provided by/(used in) financing activities - continuing operations
 
47,633

 
(217,274
)
 
(10,262
)
 

 
(179,903
)
Net cash used in financing activities - discontinued operations
 

 

 

 

 

Total cash provided by/(used in) financing activities
 
$
47,633

 
$
(217,274
)
 
$
(10,262
)
 
$

 
$
(179,903
)
Effect of Exchange Rate on cash
 

 

 
(2,116
)
 

 
(2,116
)
Net decrease in cash and cash equivalents
 
(5,771
)
 
(4,537
)
 
(4,683
)
 

 
(14,991
)
Cash and cash equivalents at beginning of period
 
111,305

 
5,889

 
34,792

 

 
151,986

Less: Change in cash and cash equivalents - discontinued operations
 

 
51,759

 
1,506



 
53,265

Plus: Cash swept (to)/from discontinued operations
 
(902
)
 
50,407

 
1,506

 

 
51,011

Cash and cash equivalents at end of year
 
$
104,632

 
$

 
$
30,109

 
$

 
$
134,741


 
 
Condensed Statement of Cash Flows
 
 
For the year ended December 31, 2012
 
 
Parent
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiaries
 
Consolidating/Eliminating Adjustments
 
Total
Cash flows from operating activities:
 
 
 
 
 
 
 
 
 
 
Net cash (used in)/provided by operating activities - continuing operations
 
$
(60,340
)
 
$
363,358

 
$
16,927

 
$

 
$
319,945

Net cash provided by operating activities - discontinued operations
 

 
43,200

 

 

 
43,200

Total cash (used in)/provided by operating activities
 
$
(60,340
)
 
$
406,558

 
$
16,927

 
$

 
$
363,145

Cash flow from investing activities:
 
 
 
 
 
 
 
 
 


Purchases of property and equipment
 
$
(3,195
)
 
$
(33,618
)
 
$
(11,453
)
 
$

 
$
(48,266
)
Purchases of capitalized data and other intangible assets
 

 
(28,792
)
 
(3,397
)
 

 
(32,189
)
Cash paid for acquisitions, net of cash acquired
 

 
(78,354
)
 

 

 
(78,354
)
Cash received from sale of discontinued operations
 

 
10,000

 

 

 
10,000

Proceeds from sale of property and equipment
 

 
1,863

 

 

 
1,863

Proceeds from sale of investments
 

 
8,000

 

 

 
8,000

Change in restricted cash
 
(1
)
 
(184
)
 
271

 

 
86

Net cash used in investing activities - continuing operations
 
(3,196
)
 
(121,085
)
 
(14,579
)
 

 
(138,860
)
Net cash used in investing activities - discontinued operations
 

 
(8,482
)
 

 

 
(8,482
)
Total cash used in investing activities
 
$
(3,196
)
 
$
(129,567
)
 
$
(14,579
)
 
$

 
$
(147,342
)
Cash flow from financing activities:
 
 
 
 
 
 
 
 
 


Proceeds from long-term debt
 
$
50,000

 
$

 
$

 
$

 
$
50,000

Repayments of long-term debt
 
(103,368
)
 
(11,020
)
 
(52,327
)
 

 
(166,715
)
Shares repurchased and retired
 
(226,629
)
 

 

 

 
(226,629
)
Proceeds from issuance of stock related to stock options and employee benefit plans
 
13,497

 

 

 

 
13,497

Minimum tax withholding paid on behalf of employees for restricted stock units
 
(3,466
)
 

 

 

 
(3,466
)
Distribution to noncontrolling interests
 

 

 
(10
)
 

 
(10
)
Tax benefit related to stock options
 
935

 

 

 

 
935

Intercompany loan payments
 
(66,765
)
 
(278,231
)
 

 
344,996

 

Intercompany loan proceeds
 
278,231

 

 
66,765

 
(344,996
)
 

Net cash (used in)/provided by financing activities - continuing operations
 
(57,565
)
 
(289,251
)
 
14,428

 

 
(332,388
)
Net cash used in financing activities - discontinued operations
 

 
(79
)
 

 

 
(79
)
Total cash (used in)/provided by financing activities
 
$
(57,565
)
 
$
(289,330
)
 
$
14,428

 
$

 
$
(332,467
)
Effect of Exchange Rate on cash
 

 

 
(153
)
 

 
(153
)
Net (decrease)/increase in cash and cash equivalents
 
(121,101
)
 
(12,339
)
 
16,623

 

 
(116,817
)
Cash and cash equivalents at beginning of period
 
229,871

 
11,989

 
18,169

 

 
260,029

Less: Change in cash and cash equivalents - discontinued operations
 

 
34,639

 

 

 
34,639

Plus: Cash swept from discontinued operations
 
2,535

 
40,878

 

 

 
43,413

Cash and cash equivalents at end of year
 
$
111,305

 
$
5,889

 
$
34,792

 
$

 
$
151,986


 
 
Condensed Statement of Cash Flows
 
 
For the year ended December 31, 2011
 
 
Parent
 
Guarantor
Subsidiaries
 
Non-Guarantor
Subsidiaries
 
Consolidating/Eliminating Adjustments
 
Total
Cash flows from operating activities:
 
 
 
 
 
 
 
 
 
 
Net cash (used in)/provided by operating activities - continuing operations
 
$
(11,053
)
 
$
151,801

 
$
2,995

 
$

 
$
143,743

Net cash (used in)/provided by operating activities - discontinued operations
 
(19
)
 
19,272

 

 

 
19,253

Total cash (used in)/provided by operating activities
 
$
(11,072
)
 
$
171,073

 
$
2,995

 
$

 
$
162,996

Cash flow from investing activities:
 
 
 
 
 
 
 
 
 


Purchases of property and equipment
 
$
(785
)
 
$
(34,862
)
 
$
(5,506
)
 
$

 
$
(41,153
)
Purchases of capitalized data and other intangible assets
 

 
(26,447
)
 
(562
)
 

 
(27,009
)
Cash paid for acquisitions, net of cash acquired
 
(219,317
)
 
4,220

 
882

 

 
(214,215
)
Cash received from sale of subsidiary, net
 

 
5,300

 
22,754

 

 
28,054

Proceeds from sale of property and equipment
 

 
25,042

 

 

 
25,042

Purchases of investments
 
(725
)
 
(25,673
)
 

 

 
(26,398
)
Proceeds from sale of investments
 

 
74,621

 

 

 
74,621

Change in restricted cash
 
2,674

 
(1
)
 
(582
)
 

 
2,091

Net cash (used in)/provided by investing activities - continuing operations
 
(218,153
)
 
22,200

 
16,986

 

 
(178,967
)
Net cash used in investing activities - discontinued operations
 

 
(8,706
)
 

 

 
(8,706
)
Total cash (used in)/provided by investing activities
 
$
(218,153
)
 
$
13,494

 
$
16,986

 
$

 
$
(187,673
)
Cash flow from financing activities:
 
 
 
 
 
 
 
 
 


Purchases of redeemable noncontrolling interests
 
$

 
$
(72,000
)
 
$

 
$

 
$
(72,000
)
Proceeds from long-term debt
 
750,000

 
54,544

 
53,610

 

 
858,154

Debt issuance cost
 
(22,810
)
 

 

 

 
(22,810
)
Repayments of long-term debt
 
(575,787
)
 
(107,109
)
 
(50,511
)
 

 
(733,407
)
Shares repurchased and retired
 
(176,512
)
 

 

 

 
(176,512
)
Proceeds from issuance of stock related to stock options and employee benefit plans
 
3,087

 

 

 

 
3,087

Minimum tax withholding paid on behalf of employees for restricted stock units
 
(2,023
)
 

 

 

 
(2,023
)
Distribution to noncontrolling interests
 

 
(4,290
)
 
(545
)
 

 
(4,835
)
Tax benefit related to stock options
 
344

 

 

 

 
344

Intercompany loan payments
 

 
(78,584
)
 
(53,247
)
 
131,831

 

Intercompany loan proceeds
 
131,831

 

 

 
(131,831
)
 

Net cash provided by/(used in) financing activities - continuing operations
 
108,130

 
(207,439
)
 
(50,693
)
 

 
(150,002
)
Net cash provided by financing activities - discontinued operations
 

 
64

 

 

 
64

Total cash provided by/(used in) financing activities
 
$
108,130

 
$
(207,375
)
 
$
(50,693
)
 
$

 
$
(149,938
)
Effect of Exchange Rate on cash
 

 

 
65

 

 
65

Net decrease in cash and cash equivalents
 
(121,095
)
 
(22,808
)
 
(30,647
)
 

 
(174,550
)
Cash and cash equivalents at beginning of period
 
355,974

 
18,178

 
45,549

 

 
419,701

Less: Change in cash and cash equivalents - discontinued operations
 
(19
)
 
10,630

 

 

 
10,611

Plus: Cash swept (to)/from discontinued operations
 
(5,027
)
 
27,249

 
3,267

 

 
25,489

Cash and cash equivalents at end of year
 
$
229,871

 
$
11,989

 
$
18,169

 
$

 
$
260,029