Take-two interactive software, inc. (TTWO)
CashFlow / Quarterly
Mar'20Dec'19Sep'19Jun'19Mar'19Dec'18Sep'18Jun'18Mar'18Dec'17Sep'17Jun'17Mar'17Dec'16Sep'16Jun'16Mar'16Dec'15Sep'15Jun'15Mar'15Dec'14Sep'14Jun'14Mar'14Dec'13Sep'13Jun'13Mar'13Dec'12Sep'12Jun'12Mar'12Dec'11Sep'11Jun'11Mar'11Dec'10Sep'10Jun'10
Operating activities:
Net income

122,722

163,642

71,815

46,280

56,830

179,947

25,367

71,693

90,853

25,140

-2,736

60,276

99,280

-29,842

36,432

-38,567

46,399

-42,413

54,735

-67,023

-242,791

40,093

-41,369

-35,403

-30,787

578,426

-124,120

-61,914

22,473

71,365

-12,491

-110,838

-66,836

14,104

-47,371

-8,713

-22,054

40,859

3,339

26,314

Adjustments to reconcile net income to net cash provided by operating activities:
Amortization and impairment of software development costs and licenses

52,102

43,318

42,007

30,498

41,054

139,898

13,411

6,858

15,652

23,373

20,656

18,206

91,892

66,560

22,425

41,034

51,416

42,337

17,129

23,590

43,685

79,632

2,881

7,255

13,304

168,068

40,923

43,238

41,429

47,033

46,798

95,488

33,542

32,797

11,895

72,466

20,466

30,936

38,767

53,642

Loss from discontinued operations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-13

-18

-25

-30

1,303

488

-54

-66

-831

-81

-110

-94

362

39

-4,699

-1,048

Stock-based compensation

81,283

63,399

55,767

57,432

69,091

123,668

30,343

24,598

20,238

13,028

59,012

24,071

26,458

22,088

18,233

15,100

15,852

18,738

16,320

19,086

12,772

28,628

13,867

9,979

20,524

36,328

15,319

5,947

12,987

8,681

7,091

7,006

10,031

10,803

4,612

8,048

5,135

5,916

6,493

11,221

Amortization of intellectual property

5,009

5,354

5,067

5,560

6,094

5,513

5,411

6,861

8,360

9,184

9,105

8,181

5,340

1,398

0

0

0

0

128

32

24

61

154

105

183

333

2,903

139

322

1,734

735

4,209

4

263

411

305

1,131

1,053

1,704

39

Depreciation

12,382

12,209

11,903

11,134

10,957

10,016

9,623

9,130

8,969

7,864

7,626

7,743

8,378

7,460

7,491

7,378

7,338

7,534

7,353

6,575

5,934

5,845

5,130

4,148

3,522

3,413

3,367

3,057

2,806

2,509

2,550

2,769

2,740

2,854

3,284

3,245

3,728

3,501

4,005

3,765

Amortization of discount on Convertible Notes

-

-

-

-

-

-

-

-

238

1,509

8,678

5,237

3,352

4,889

6,883

6,098

6,003

5,910

5,817

5,727

5,637

5,549

5,463

5,377

5,294

5,211

6,950

5,346

4,891

4,772

4,656

4,543

4,434

3,234

2,063

1,997

1,934

1,872

1,813

1,755

Amortization of debt issuance costs

-

-

-

-

-

-

-

-

-

72

294

188

149

299

398

381

386

389

394

398

403

407

422

431

437

440

573

497

500

504

506

511

513

388

313

313

312

313

313

313

Gain on redemption of Convertible Notes

-

-

-

-

-

-

-

-

45

714

3,038

1,103

0

0

0

0

-

-

-

-

-

-

-

-

0

0

5,372

-1,911

-

-

-

-

-

-

-

-

-

-

-

-

Other, net

-1,932

2,516

-3,004

-1,321

-4,496

2,298

-1,366

2,980

-3,521

-2,238

-10,863

9,669

-194

692

-259

3,171

-15

-1,471

-919

-183

194

-2,081

-47

-134

-206

1,579

-423

-742

-43

-373

219

-581

-453

-687

-341

250

572

-508

2,160

-1,127

Changes in assets and liabilities:
Restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

-

-89,568

49,605

57,335

57,080

-11,137

-14,767

60,315

138,377

-46,242

15,706

-132,002

358,242

-152,994

-36,867

17,969

-

-

-

-

-

-

-

-

-

-

-

-

Accounts receivable

-54,225

-213,310

507,060

-44,041

-427,906

292,745

294,591

-61,355

-179,086

-3,114

199,904

9,294

-118,139

-51,937

240,258

-28,226

-95,575

23,559

109,866

-87,198

-217,849

410,282

-17,738

-9,978

-136,376

-821,872

976,189

-154,394

95,355

-60,710

83,244

26,672

-8,239

33,702

-127,122

62,477

372

-20,805

-72,656

103,171

Inventory

-4,801

-15,752

16,093

-4,029

-11,949

427

29,617

-3,692

-16,893

-5,745

24,172

-5,451

-10,934

-46,679

65,251

-2,696

-4,183

-3,381

12,096

-8,341

-4,566

-31,331

32,801

-6,633

-15,255

-38,998

56,181

-2,366

531

-30,881

32,581

5,510

-39

-22,561

19,136

1,363

-4,014

-17,293

21,456

-50

Software development costs and licenses

29,882

-33,380

-5,036

56,968

49,121

24,702

78,345

54,663

38,896

40,364

74,180

71,829

58,529

45,910

86,120

62,392

49,143

52,115

74,828

43,131

33,318

50,962

61,502

42,990

41,082

143,409

-34,204

42,070

66,414

39,162

54,985

56,332

43,908

59,731

41,954

45,630

37,821

35,430

40,213

43,318

Prepaid expenses, other current and other non-current assets

44,757

84,005

-66

131,121

132,882

136,237

-14,783

21,464

35,411

-5,956

21,890

23,199

-9,305

22,900

4,693

3,867

5,758

-6,736

-7,443

20,693

-57,490

46,245

3,225

2,622

-359,184

322,875

58,111

-3,378

5,220

8,710

-6,131

-2,105

5,215

-18,859

-11,329

26,063

-4,956

-41,678

40,689

-10,998

Deferred revenue

43,709

-54,397

82,019

-15,871

-633,038

315,724

107,676

-95,075

-436,987

172,919

133,554

-67,883

-429,013

221,815

117,359

-36,446

-32,630

71,913

21,139

91,903

111,405

409,858

20,589

26,176

9,829

-1,103,053

1,126,436

1,064

571

-11,936

23,936

484

2,070

-5,399

1,879

1,880

3,022

-3,541

3,715

-1,706

Deferred cost of goods sold

-13,578

-3,315

332

-15,619

-12,399

44,148

1,542

-8,409

-21,619

37,957

27,854

-32,233

-51,533

49,215

34,510

-17,223

-13,274

92,858

-39,683

1,243

133,991

-61,559

-1,869

225

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accounts payable, accrued expenses and other liabilities

37,672

-116,944

282,424

96,581

-92,539

322,025

1,263

-29,597

34,647

-82,386

175,191

71,281

-40,723

-73,723

267,396

36,394

-20,395

133,396

4,793

52,368

113,150

110,127

64,252

-208,944

-150,946

61,856

375,901

-92,583

36,662

-49,003

66,591

29,484

19,826

-51,753

-35,983

28,162

-846

-36,188

-4,471

82,722

Net cash used in discontinued operations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-284

-314

-348

-372

951

-409

-404

-410

-427

-419

-741

-420

-458

-1,103

-401

-7,666

Net cash provided by operating activities

245,703

295,817

35,623

108,535

453,316

596,234

-194,852

-11,183

252,454

108,721

82,462

49,890

168,301

290,411

-3,561

-47,248

72,482

168,809

-85,468

105,482

152,288

192,348

-44,306

-87,516

-30,531

595,672

127,920

7,201

-46,029

123,780

-29,802

-52,516

-30,359

-44,373

18,174

-28,406

-20,373

89,924

28,114

37,133

Investing activities:
Change in bank time deposits

-

-

-126,583

133,303

-

-

63,444

-29,840

-50,918

50,000

-15,001

-24,999

22,235

0

-11,850

78,691

7,181

-27,163

24,644

-187,045

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from available-for-sale securities

157,465

106,099

54,647

82,424

140,591

70,276

62,878

51,388

68,087

61,445

49,275

62,205

54,579

28,970

42,592

29,795

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of available-for-sale securities

187,996

170,751

112,996

28,248

102,964

83,682

51,780

44,108

87,402

148,323

93,125

41,148

117,314

29,805

43,716

30,836

124,733

20,781

4,543

444

20,439

30,086

30,176

19,415

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of commercial paper

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from commercial paper

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of fixed assets

18,594

9,258

15,561

9,971

23,323

14,502

14,855

14,289

14,079

14,761

16,625

16,092

6,798

6,086

4,053

4,230

8,701

2,786

7,024

18,769

12,922

13,525

14,662

8,392

6,358

8,003

7,458

7,994

4,503

4,296

4,731

3,290

2,802

3,204

2,380

2,400

1,407

2,572

3,495

2,179

Proceeds from sale of long-term investment

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-1,350

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchase of long-term investments

1,749

21,642

2,500

2,000

0

0

0

0

-

-

-

-

0

0

0

1,885

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Asset acquisition

-

-

-

-

-

-

-

-

0

0

584

25,381

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Business acquisition

0

3,325

0

8,715

25,000

0

0

3,149

0

9,401

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

500

500

Cash received from sale of business

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

2,315

760

Net cash used in discontinued operations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-1,475

-

-

-

-

Net cash provided by (used in) investing activities

31,126

9,123

-202,993

166,793

-245,854

2,589

59,687

-39,998

-89,312

-61,040

-76,060

-45,415

-177,217

-7,671

-17,027

72,885

-99,619

-31,716

13,077

-206,258

-120,861

-48,611

-22,862

-27,807

-6,358

-9,003

-7,458

-7,994

-4,503

-4,296

-4,731

-3,290

-4,703

-3,204

-2,380

-3,875

-1,407

-2,572

-1,680

-1,919

Financing activities:
Tax payment related to net share settlements on restricted stock awards

16,708

9,782

9,360

52,118

15,456

21,870

5,564

58,403

17,954

8,805

28,436

57,689

15,028

6,113

5,455

25,166

8,410

4,120

3,845

6,541

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from exercise of employee stock options

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1

43

33

162

630

17

0

87

Repurchase of common stock

0

0

0

0

100,000

108,892

0

153,500

44,656

110,136

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Excess tax benefit from stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

491

356

256

887

-88

-8,020

1,463

8,066

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from issuance of 1.00% Convertible Notes

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

36,938

246,250

-

-

-

-

-

-

-

-

-

-

-

-

Payment of debt issuance costs for the issuance of 1.00% Convertible Notes

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

772

2,043

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in financing activities

-16,708

733

-9,360

-52,118

-115,456

-130,762

-5,564

-211,903

-76,401

-118,941

-28,436

-57,689

-14,537

-5,757

-5,199

-24,279

-8,498

-12,140

-28,934

1,525

-

-

-

-

0

-276,836

-101,055

244,207

-

-

-

-

1

243,168

33

162

630

17

0

87

Effects of foreign currency exchange rates on cash, cash equivalents, and restricted cash and cash equivalents

-9,163

6,358

-4,862

-3,201

4,485

-5,660

-361

-9,103

10,369

1,794

6,313

6,448

4,068

-7,556

-538

-3,772

-864

-1,425

-2,746

3,915

-8,335

-6,204

-5,265

1,923

119

414

-3,799

399

4,311

955

-4,239

2,583

2,024

-12,015

5,154

519

4,391

4,930

-4,158

1,404

Net change in cash, cash equivalents, and restricted cash and cash equivalents

250,958

312,031

-181,592

220,009

96,491

462,401

-141,090

-272,187

97,110

-69,466

-15,721

-46,766

-19,385

269,427

-26,325

-2,414

-36,499

123,528

-104,071

-95,336

13,668

143,042

-67,590

-113,400

-36,770

310,247

15,608

243,813

-46,221

120,439

-38,772

-53,223

-33,037

183,576

20,981

-31,600

-16,759

92,299

22,276

36,705