Wayfair inc. (W)
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'14
Cash flows from operating activities:
Net loss

-285,865

-330,222

-272,035

-181,938

-200,389

-143,845

-151,726

-100,734

-107,775

-72,771

-76,429

-38,875

-56,539

-43,956

-60,940

-48,274

-41,205

-15,495

-15,478

-19,334

-27,136

-72,554

-24,143

-23,375

-28,026

Adjustments to reconcile net loss to net cash used in operating activities
Depreciation and amortization

66,843

58,247

50,250

44,339

39,583

36,116

32,544

28,920

25,962

24,432

22,913

19,323

20,352

17,044

15,463

12,578

10,487

9,095

9,207

7,400

6,744

7,565

5,547

4,693

4,198

Equity-based compensation

59,449

65,437

61,767

53,187

47,060

39,416

33,935

29,813

24,400

21,100

18,278

14,833

13,629

14,214

14,726

10,747

9,715

9,274

7,507

6,592

7,642

55,281

0

974

4,554

Amortization of discount and issuance costs on convertible notes

19,527

21,374

17,722

10,559

12,456

8,886

4,346

5,072

4,281

4,956

874

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Other non-cash adjustments

633

32

64

221

1,374

233

-44

-22

-111

-285

-45

-1,114

246

-465

542

-564

156

-1,632

-646

-518

-231

318

-769

-44

-75

Changes in operating assets and liabilities:
Accounts receivable, net

16,216

23,878

-2,344

16,083

11,570

9,635

6,215

2,952

-6,010

9,475

3,974

2,072

2,651

2,444

2,555

2,277

1,941

201

2,633

-929

2,128

635

-1,336

701

-1,741

Inventories

-5,023

-7,085

23,256

1,887

-2,427

10,562

5,016

-3,750

6,491

9,416

3,987

145

-4,094

-635

1,792

-366

-2,142

-2,647

1,230

1,308

240

-1,320

1,315

4,210

630

Prepaid expenses and other current assets

-7,802

2,942

7,216

11,897

10,535

27,819

15,022

5,136

17,218

11,348

-3,444

3,020

28,200

3,686

843

3,007

8,643

1,094

8,886

4,206

15,327

7,422

-482

3,612

9,591

Accounts payable and accrued expenses

-114,623

114,539

87,175

81,980

46,631

97,331

91,990

61,685

34,058

59,492

44,829

22,275

-22,412

72,570

43,695

38,845

-29,097

75,515

57,902

19,238

-16,800

60,629

2,198

3,172

-6,478

Unearned revenue and other liabilities

2,379

53,506

7,468

19,847

-4,933

54,196

28,298

28,390

23,821

30,904

19,790

4,730

25,930

18,358

10,694

14,936

7,926

9,104

7,344

18,432

12,151

8,038

5,091

8,766

10,721

Other assets

-24

-591

596

620

704

1,321

5,374

1,226

236

1,280

1,031

62

55

-294

2,285

-425

432

111

-122

-192

339

-3,058

1,031

1,090

996

Net cash used in operating activities

-256,290

-36,295

-76,441

-2,734

-81,348

42,530

7,804

47,604

-13,077

36,879

24,752

18,101

-46,098

73,494

15,621

24,903

-51,204

90,366

51,504

28,453

-35,202

54,962

-11,066

-15,339

-24,432

Cash flows from investing activities:
Sale and maturities of short- and long-term investments

294,810

0

33,304

44,228

37,936

15,113

19,309

15,256

11,390

10,555

14,505

27,760

18,275

37,750

14,165

38,275

29,620

54,881

41,715

27,000

10,000

65,055

9,962

40,023

9,979

Purchase of short- and long-term investments

-

-

-

-

-

-

-

-

-

6,912

22,305

9,109

16,225

11,654

7,403

40,566

28,489

65,994

32,998

4,078

104,233

25,000

45,000

55,000

10,000

Purchase of property and equipment

59,964

87,774

68,628

54,714

60,626

48,701

49,411

39,730

21,363

23,923

30,980

33,596

11,952

14,863

20,408

37,509

23,927

7,953

11,491

13,153

12,051

687

6,837

12,974

11,357

Site and software development costs

38,369

34,441

35,831

34,023

24,843

16,981

17,196

15,419

13,154

11,543

12,235

11,730

10,920

9,935

9,181

6,812

5,451

4,429

4,681

4,311

4,115

3,487

4,495

3,431

2,717

Other investing activities, net

124

-410

18,750

65

-2,838

-1

132

0

267

0

0

0

0

-

-

-

-

4,999

0

0

-302

-3,546

3

-395

3,407

Net cash provided by (used in) investing activities

196,353

-675,663

-89,905

-44,574

-44,695

-149,570

-47,430

-39,893

-23,394

-31,823

-51,015

-26,675

-20,822

1,298

-22,319

-46,612

-28,247

-28,494

-4,595

5,458

-110,097

39,427

-46,373

-30,987

-17,502

Cash flows from financing activities:
Proceeds from borrowings

100,000

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Taxes paid related to net share settlement of equity awards

0

726

1,086

259

165

187

462

244

391

285

25

660

592

2,666

6,052

5,753

6,621

6,212

5,062

3,586

4,251

-

-

-

-

Deferred financing costs

0

-

0

0

791

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net proceeds from exercise of stock options

125

23

10

13

67

34

30

45

29

31

51

108

54

43

36

79

51

121

102

257

15

-

-

-

-

Net proceeds from issuance of Series B convertible redeemable preferred units

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

154,774

Repurchase of common units

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

23,500

Dividends paid to Series A convertible redeemable preferred holders

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

24,516

0

0

15,000

Repurchase of employee equity

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

974

4,554

Net cash provided by (used in) financing activities

100,125

-703

788,342

-246

-889

468,456

-432

-199

-362

-254

376,315

-552

-538

-2,623

-6,016

-5,674

-6,570

-6,091

-4,960

-3,329

-4,236

230,404

0

-974

111,720

Effect of exchange rate changes on cash and cash equivalents

1,540

29

-1,722

305

-169

-591

-758

-86

-101

437

-141

528

26

-673

759

-1,116

643

-295

167

-90

-242

759

-35

-14

20

Net increase (decrease) in cash and cash equivalents

41,728

-712,632

620,274

-47,249

-127,101

360,825

-40,816

7,426

-36,934

5,239

349,911

-8,598

-67,432

71,496

-11,955

-28,499

-85,378

55,486

42,116

30,492

-149,777

325,552

-57,474

-47,314

69,806

Supplemental cash flow information:
Cash paid for interest on long-term debt

5,447

3,235

808

2,911

809

0

808

0

746

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Purchase of property and equipment included in accounts payable and accrued expenses and in other liabilities

45,495

7,153

28,769

2,116

3,143

4,863

-4,943

10,736

4,727

-722

-4,721

2,452

11,524

-4,408

-2,551

-10,891

19,186

2,622

-3,676

324

5,988

5,488

-3,708

1,071

4,716

Construction costs capitalized under finance lease obligations and other leases

-

-

-

-

-

61,388

10,265

25,820

28,323

31,123

6,462

1,302

8,389

24,168

21,624

-4,975

13,077

18,608

8,522

-9,735

9,900

-

-

-

-

Accretion of preferred unit dividends

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-14,432

4,748

4,605

7,150

Purchase of employee equity included in accounts payable and accrued expenses

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

4,554