Yext, inc. (YEXT)

CashFlow / TTM
Jan'20Oct'19Jul'19Apr'19Jan'19Oct'18Jul'18Apr'18Jan'18Oct'17Jul'17Apr'17Jan'17Oct'16Jul'16Apr'16
Operating activities:
Net loss

-121,544

-106,427

-86,650

-76,755

-74,837

-76,375

-70,497

-67,500

-66,565

-64,140

-57,300

-49,913

-43,150

0

0

0

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

8,069

7,621

7,394

7,178

6,813

6,400

5,979

5,523

5,123

4,884

4,518

4,290

4,082

0

0

0

Provision for bad debts

1,246

487

158

456

492

459

662

475

478

652

632

711

653

0

0

0

Stock-based compensation expense

67,770

63,207

55,037

49,456

44,233

39,301

32,316

26,291

22,360

18,537

15,117

12,315

9,851

0

0

0

Change in fair value of convertible preferred stock warrant liability

-

-

-

-

-

-

-

-

491

638

702

700

253

0

0

0

Deferred income taxes

-

0

0

-18

-

0

0

-138

-

23

50

25

31

0

0

0

Amortization of deferred financing costs

-

0

0

143

-

0

0

140

-

209

137

138

104

0

0

0

Amortization of (discount) premium on marketable securities

-

0

0

291

-

0

0

-195

-

0

0

0

-

-

-

-

Amortization of operating lease right-of-use assets

11,124

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Changes in operating assets and liabilities:
Restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Accounts receivable

26,981

6,679

10,163

9,699

11,601

9,679

13,715

5,280

17,036

7,980

3,418

6,055

4,117

0

0

0

Prepaid expenses and other current assets

-268

2,532

2,983

6,306

6,745

5,379

5,162

3,145

4,043

1,475

2,287

1,856

1,642

0

0

0

Costs to obtain revenue contracts

18,344

16,153

14,721

16,346

16,817

10,128

8,592

4,891

4,420

4,218

5,512

5,533

5,573

0

0

0

Other long term assets

2,629

1,170

962

1,832

-2

706

333

217

358

186

95

648

430

0

0

0

Accounts payable, accrued expenses and other current liabilities

8,267

16,458

11,359

14,362

17,626

7,649

9,907

2,615

695

2,693

4,135

3,684

6,037

0

0

0

Unearned revenue

42,345

26,458

37,196

44,204

47,004

22,505

29,231

24,602

31,753

19,663

19,897

18,963

20,942

0

0

0

Operating lease liabilities

-1,044

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Deferred rent

-

-

-

-

-

-

-

-

-

734

530

369

590

0

0

0

Other long term liabilities

565

726

-128

-238

-847

-2,237

-1,678

-1,318

-1,053

92

25

10

17

0

0

0

Net cash (used in) provided by operating activities

-30,768

-11,614

-2,361

4,650

5,240

-27,659

-21,476

-22,656

-32,409

-37,024

-29,674

-29,327

-13,532

0

0

0

Investing activities:
Maturities of marketable securities

51,197

79,097

101,050

97,794

86,320

71,074

51,221

33,377

20,154

0

0

0

-

-

-

-

Capital expenditures

11,889

8,296

7,016

4,529

5,270

5,248

4,491

4,168

3,674

3,354

3,754

3,754

3,505

0

0

0

Net cash provided by (used in) investing activities

39,308

70,801

65,810

40,349

28,134

8,421

11,881

-75,394

-88,123

-95,968

-98,200

-4,052

-3,803

0

0

0

Financing activities:
Proceeds from initial public offering, net of underwriting discounts and commissions

-

-

-

-

-

-

-

-

123,527

123,527

123,527

123,527

0

0

0

0

Proceeds from common stock offering, net of underwriting discounts and commissions

147,000

147,000

147,000

147,000

0

0

0

0

-

-

-

-

-

-

-

-

Payments of deferred offering costs

530

530

530

208

0

0

0

2,294

4,263

4,433

4,433

2,139

170

0

0

0

Proceeds from exercise of stock options

14,893

16,349

17,882

18,932

18,880

21,968

19,394

14,418

11,610

5,160

3,011

2,975

1,321

0

0

0

Repayments on Revolving Line

-

-

-

-

-

-

-

-

5,000

5,000

5,000

5,000

0

0

0

0

Payments of deferred financing costs

260

260

260

322

159

0

0

0

-

-

-

-

183

0

0

0

Proceeds, net from employee stock purchase plan withholdings

7,270

6,794

6,831

6,310

5,663

4,973

4,892

4,971

3,750

0

0

0

-

-

-

-

Net cash provided by financing activities

168,373

169,353

170,923

171,712

24,384

26,782

24,127

17,075

129,604

126,775

123,419

124,265

5,968

0

0

0

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

-492

-23

-626

-351

-370

-319

-256

141

375

312

337

7

-30

0

0

0

Net increase in cash, cash equivalents and restricted cash

176,421

228,517

233,746

216,360

57,388

7,225

14,276

-80,834

9,447

-5,905

-4,118

90,893

-11,397

0

0

0

Supplemental disclosures of non-cash investing and financing activities:
Cash paid on interest

-

-

-

-

-

-

-

-

-

-

-

-

3

0

0

0

Conversion of convertible preferred stock warrants to common stock warrants

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Cash paid on income taxes

-

-

-

-

-

-

-

-

-

-

-

-

19

0

0

0

Non-cash capital expenditures in accounts payable, accrued expenses and other current liabilities

-

-

-

-

-

-

-

-

-

-

-

-

112

0

0

0

Deferred offering costs in accounts payable, accrued expenses and other current liabilities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

Common stock issued for the acquisition of Inner Balloons

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0