Twilio inc. (TWLO)
CashFlow / TTM
Mar'20Dec'19Sep'19Jun'19Mar'19Dec'18Sep'18Jun'18Mar'18Dec'17Sep'17Jun'17Mar'17Dec'16Sep'16Jun'16Mar'16
CASH FLOWS FROM OPERATING ACTIVITIES:
Net loss

-365,351

-307,063

-263,974

-203,296

-134,723

-121,949

-93,710

-90,107

-73,210

-63,708

-57,397

-45,198

-49,083

-41,324

0

0

0

Adjustments to reconcile net loss to net cash provided by (used in) operating activities:
Depreciation and amortization

121,421

110,430

87,144

64,313

41,712

26,095

23,604

21,676

20,440

18,764

16,429

13,510

10,690

8,315

0

0

0

Non-cash reduction to the right-of-use asset

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Amortization of debt discount and issuance costs

24,033

23,696

23,368

23,040

19,894

14,053

0

0

0

-

-

-

-

-

-

-

-

Right-of-use asset amortization

-

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

Net amortization of investment premium and discount

-

-

-

-

-

1,496

0

0

0

-

-

-

-

-

-

-

-

Amortization of bond premium

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

Stock-based compensation

275,019

264,318

229,318

183,791

134,057

93,273

74,933

66,380

57,774

49,619

44,549

38,009

30,585

24,225

0

0

0

Amortization of deferred commissions

-

-

-

-

-

-

-

0

0

-

-

-

-

-

-

-

-

Provision for doubtful accounts

-

-

-

-

-

-

-

0

883

-

535

580

914

1,145

0

0

0

Tax benefit related to release of valuation allowance

4,263

55,745

55,999

53,502

51,644

0

0

0

0

-

-

-

-

-

-

-

-

Allowance for credit losses

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Value of donated common stock

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Other adjustments

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Write-off of internally developed software and intangible assets

-

-

-

-

-

-

-

-

717

-

619

661

652

711

0

0

0

(Gain) loss on lease termination and asset disposals

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

Changes in operating assets and liabilities:
Accounts receivable

74,274

51,357

46,210

54,709

43,828

58,234

45,750

31,963

27,942

15,280

6,152

12,886

7,798

8,254

0

0

0

Prepaid expenses and other current assets

18,967

20,316

22,882

21,580

20,730

8,739

-561

2,566

-5,698

-2,214

7,141

1,610

12,679

13,755

0

0

0

Other long-term assets

20,821

18,021

12,380

9,366

7,095

5,305

4,153

2,960

2,975

1,984

1,582

953

322

129

0

0

0

Accounts payable

-4,709

17,255

9,672

2,720

1,438

6,980

5,663

19,281

11,987

5,433

808

-4,216

-5,486

1,714

0

0

0

Accrued expenses and other current liabilities

86,646

46,154

39,214

31,056

26,679

45,120

37,874

31,039

14,256

-3,312

4,103

9,048

25,510

24,182

0

0

0

Deferred revenue and customer deposits

3,180

2,968

3,909

4,585

5,150

5,958

5,288

4,507

3,860

3,560

4,094

3,868

4,216

4,076

0

0

0

Operating right of use liability

-26,362

-21,138

-15,397

-9,367

-1,784

0

0

0

0

-

-

-

-

-

-

-

-

Long-term liabilities

1,951

-3,501

-2,134

-1,921

-2,356

-597

-2,324

-2,184

-1,646

-841

-193

88

9,454

9,097

0

0

0

Net cash provided by (used in) operating activities

38,696

14,048

-2,826

-25,061

-18,066

7,983

16,632

20,019

11,241

-3,255

-1,376

935

6,515

10,097

0

0

0

CASH FLOWS FROM INVESTING ACTIVITIES:
Purchases of intangible assets

-

-

-

-

-

-

-

-

394

-

345

629

649

785

0

0

0

Acquisitions, net of cash acquired, and other related payments

36,411

-122,749

-146,045

-116,383

-126,209

30,574

29,662

0

0

22,621

0

0

0

-

-

-

-

Purchases of marketable securities and other investments

1,846,949

2,038,422

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

(Increase) decrease in restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Purchases of marketable securities

-

-

-

-

-

-

-

-

165,110

-

0

0

0

-

-

-

-

Proceeds from sale of marketable securities

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

Proceeds from sales and maturities of marketable securities

873,645

697,171

557,260

423,630

308,415

195,497

0

0

0

-

-

-

-

-

-

-

-

Capitalized software development costs

25,197

21,922

21,079

20,108

20,102

19,546

20,275

19,238

18,426

17,280

15,361

14,137

12,683

11,527

0

0

0

Purchases of long-lived assets

49,034

45,368

20,675

10,676

6,822

5,109

4,353

5,081

5,507

9,538

17,505

19,001

18,363

14,174

0

0

0

Net cash provided by (used in) investing activities

-1,083,946

-1,285,792

-1,173,728

-963,166

-248,680

-139,419

-138,185

-129,404

-45,670

-226,748

-250,137

-255,363

-226,146

-34,986

0

0

0

Payments of costs related to public offerings

-

-

-

-

-

-

-

-

-

430

1,100

2,937

3,410

4,606

0

0

0

Principal payments on notes payable

-

-

-

-

-

0

0

0

0

-

-

-

-

-

-

-

-

Principal payments on finance leases and notes payable

6,145

5,646

3,927

2,463

1,455

0

0

0

0

-

-

-

-

-

-

-

-

Proceeds from exercises of stock options

50,383

57,480

53,181

51,419

48,529

39,879

42,193

33,206

31,588

37,645

26,855

22,982

21,082

9,102

0

0

0

Value of equity awards withheld for tax liabilities

6,024

5,412

5,082

4,324

3,345

2,654

1,922

1,277

894

678

0

0

0

-

-

-

-

Net cash provided by financing activities

1,011,937

1,020,145

1,017,858

1,026,640

522,323

515,819

511,425

507,921

30,402

36,437

97,381

91,459

242,185

229,164

0

0

0

Effect of exchange rate changes on cash, cash equivalents and restricted cash

-

-

-

-

-

163

91

850

211

74

0

0

0

-

-

-

-

NET INCREASE (DECREASE) IN CASH, CASH EQUIVALENTS AND RESTRICTED CASH

-33,313

-251,599

-158,638

37,758

255,592

384,546

389,963

399,386

-3,816

-193,492

-154,044

-162,927

22,565

204,275

0

0

0

Cash paid for income taxes, net

1,659

1,368

529

291

512

564

660

553

581

605

561

502

236

225

0

0

0

Cash paid for interest

2,340

2,290

2,147

1,078

889

741

0

0

0

-

-

-

-

-

-

-

-

NON-CASH INVESTING AND FINANCING ACTIVITIES:
Purchases of property, equipment and intangible assets, accrued but not paid

0

-

0

0

0

-

0

0

-476

-

1,952

2,528

4,507

4,201

0

0

0

Purchases of property and equipment through finance leases

-7,768

5,848

5,619

16,094

16,094

2,478

0

0

0

-

-

-

-

-

-

-

-

Value of common stock issued and stock awards assumed in acquisition

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Vesting of early exercised options

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Stock-based compensation capitalized in software development costs

9,600

7,800

7,000

6,000

5,872

5,700

5,888

5,543

4,919

4,200

3,597

2,822

2,346

1,953

0

0

0

Costs related to public offerings, accrued but not paid

-

-

-

-

-

-

-

-

-

-

-

-

-94

430

0

0

0