Yext, inc. (YEXT)
CashFlow / Quarterly
Jan'20Oct'19Jul'19Apr'19Jan'19Oct'18Jul'18Apr'18Jan'18Oct'17Jul'17Apr'17Jan'17Oct'16Jul'16Apr'16
Operating activities:
Net loss

-30,577

-42,717

-29,291

-18,959

-15,460

-22,940

-19,396

-17,041

-16,998

-17,062

-16,399

-16,106

-14,573

-10,222

-9,012

-9,343

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

2,233

2,014

1,881

1,941

1,785

1,787

1,665

1,576

1,372

1,366

1,209

1,176

1,133

1,000

981

968

Provision for bad debts

949

278

-21

40

190

-51

277

76

157

152

90

79

331

132

169

21

Stock-based compensation expense

16,853

21,092

16,609

13,216

12,290

12,922

11,028

7,993

7,358

5,937

5,003

4,062

3,535

2,517

2,201

1,598

Change in fair value of convertible preferred stock warrant liability

-

-

-

-

-

-

-

-

0

0

0

491

147

64

-2

44

Deferred income taxes

-

0

-61

3

-

3

-35

-22

-

-19

19

-13

36

8

-6

-7

Amortization of deferred financing costs

-

70

70

47

-

32

32

34

-

36

35

34

104

-36

36

0

Amortization of (discount) premium on marketable securities

-

7

47

82

-

108

-8

-39

-

-64

-44

0

-

-

-

-

Amortization of operating lease right-of-use assets

3,085

3,329

3,132

1,578

-

-

-

-

-

-

-

-

-

-

-

-

Changes in operating assets and liabilities:
Restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-5,789

Accounts receivable

42,889

2,019

4,268

-22,195

22,587

5,503

3,804

-20,293

20,665

9,539

-4,631

-8,537

11,609

4,977

-1,994

-10,475

Prepaid expenses and other current assets

620

-816

-12

-60

3,420

-365

3,311

379

2,054

-582

1,294

1,277

-514

230

863

1,063

Costs to obtain revenue contracts

12,148

3,633

2,198

365

9,957

2,201

3,823

836

3,268

665

122

365

3,066

1,959

143

405

Other long term assets

948

623

-855

1,913

-511

415

15

79

197

42

-101

220

25

-49

452

2

Accounts payable, accrued expenses and other current liabilities

5,106

3,722

5,777

-6,338

13,297

-1,377

8,780

-3,074

3,320

881

1,488

-4,994

5,318

2,323

1,037

-2,641

Unearned revenue

69,876

-15,326

-2,497

-9,708

53,989

-4,588

4,511

-6,908

29,490

2,138

-118

243

17,400

2,372

-1,052

2,222

Operating lease liabilities

532

823

-1,157

-1,242

-

-

-

-

-

-

-

-

-

-

-

-

Deferred rent

-

-

-

-

-

-

-

-

-

278

310

-7

153

74

149

214

Other long term liabilities

87

364

-232

346

248

-490

-342

-263

-1,142

69

18

2

3

2

3

9

Net cash (used in) provided by operating activities

11,666

-31,817

-11,436

819

30,820

-22,564

-4,425

1,409

-2,079

-16,381

-5,605

-8,344

-6,694

-9,031

-5,258

7,451

Investing activities:
Maturities of marketable securities

0

5,400

21,100

24,697

27,900

27,353

17,844

13,223

12,654

7,500

0

0

-

-

-

-

Capital expenditures

4,542

2,898

3,618

831

949

1,618

1,131

1,572

927

861

808

1,078

607

1,261

808

829

Net cash provided by (used in) investing activities

-4,542

2,502

17,482

23,866

26,951

-2,489

-7,979

11,651

7,238

971

-95,254

-1,078

-607

-1,261

-1,106

-829

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

-

-

-

-

-

-

-

-

0

0

0

123,527

0

0

0

0

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

0

0

0

147,000

0

0

0

0

-

-

-

-

-

-

-

-

Payments of deferred offering costs

0

0

322

208

0

0

0

0

0

0

2,294

1,969

170

0

0

0

Proceeds from exercise of stock options

2,380

3,346

4,167

5,000

3,836

4,879

5,217

4,948

6,924

2,305

241

2,140

474

156

205

486

Repayments on Revolving Line

-

-

-

-

-

-

-

-

0

0

0

5,000

0

0

0

0

Payments of deferred financing costs

0

0

97

163

0

0

159

0

-

-

-

-

183

-180

95

85

Proceeds, net from employee stock purchase plan withholdings

2,192

1,431

1,779

1,868

1,716

1,468

1,258

1,221

1,026

1,387

1,337

0

-

-

-

-

Net cash provided by financing activities

4,572

4,777

5,527

153,497

5,552

6,347

6,316

6,169

7,950

3,692

-736

118,698

5,121

336

110

401

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

-374

491

-435

-174

95

-112

-160

-193

146

-49

237

41

83

-24

-93

4

Net increase in cash, cash equivalents and restricted cash

11,322

-24,047

11,138

178,008

63,418

-18,818

-6,248

19,036

13,255

-11,767

-101,358

109,317

-2,097

-9,980

-6,347

7,027

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

-

-

-

-

-

-

-

-

-

-

-

-

-180

183

0

0

Conversion of convertible preferred stock warrants to common stock warrants

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Cash paid on income taxes

-

-

-

-

-

-

-

-

-

-

-

-

15

-2

6

0

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

-

-

-

-

-

-

-

-

-

-

-

-

8

-24

-10

138

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