Wayfair inc. (W)
CashFlow / TTM
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

-1,070,060

-984,584

-798,207

-677,898

-596,694

-504,080

-433,006

-357,709

-295,850

-244,614

-215,799

-200,310

-209,709

-194,375

-165,914

-120,452

-91,512

-77,443

-134,502

-143,167

-147,208

-148,098

0

0

0

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

219,679

192,419

170,288

152,582

137,163

123,542

111,858

102,227

92,630

87,020

79,632

72,182

65,437

55,572

47,623

41,367

36,189

32,446

30,916

27,256

24,549

22,003

0

0

0

Equity-based compensation

239,840

227,451

201,430

173,598

150,224

127,564

109,248

93,591

78,611

67,840

60,954

57,402

53,316

49,402

44,462

37,243

33,088

31,015

77,022

69,515

63,897

60,809

0

0

0

Amortization of discount and issuance costs on convertible notes

69,182

62,111

49,623

36,247

30,760

22,585

18,655

15,183

10,111

5,830

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Other non-cash adjustments

950

1,691

1,892

1,784

1,541

56

-462

-463

-1,555

-1,198

-1,378

-791

-241

-331

-1,498

-2,686

-2,640

-3,027

-1,077

-1,200

-726

-570

0

0

0

Changes in operating assets and liabilities:
Accounts receivable, net

53,833

49,187

34,944

43,503

30,372

12,792

12,632

10,391

9,511

18,172

11,141

9,722

9,927

9,217

6,974

7,052

3,846

4,033

4,467

498

2,128

-1,741

0

0

0

Inventories

13,035

15,631

33,278

15,038

9,401

18,319

17,173

16,144

20,039

9,454

-597

-2,792

-3,303

-1,351

-3,363

-3,925

-2,251

131

1,458

1,543

4,445

4,835

0

0

0

Prepaid expenses and other current assets

14,253

32,590

57,467

65,273

58,512

65,195

48,724

30,258

28,142

39,124

31,462

35,749

35,736

16,179

13,587

21,630

22,829

29,513

35,841

26,473

25,879

20,143

0

0

0

Accounts payable and accrued expenses

169,071

330,325

313,117

317,932

297,637

285,064

247,225

200,064

160,654

104,184

117,262

116,128

132,698

126,013

128,958

143,165

123,558

135,855

120,969

65,265

49,199

59,521

0

0

0

Unearned revenue and other liabilities

83,200

75,888

76,578

97,408

105,951

134,705

111,413

102,905

79,245

81,354

68,808

59,712

69,918

51,914

42,660

39,310

42,806

47,031

45,965

43,712

34,046

32,616

0

0

0

Other assets

601

1,329

3,241

8,019

8,625

8,157

8,116

3,773

2,609

2,428

854

2,108

1,621

1,998

2,403

-4

229

136

-3,033

-1,880

-598

59

0

0

0

Net cash used in operating activities

-371,760

-196,818

-117,993

-33,748

16,590

84,861

79,210

96,158

66,655

33,634

70,249

61,118

67,920

62,814

79,686

115,569

119,119

135,121

99,717

37,147

-6,645

4,125

0

0

0

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

372,342

115,468

130,581

116,586

87,614

61,068

56,510

51,706

64,210

71,095

98,290

97,950

108,465

119,810

136,941

164,491

153,216

133,596

143,770

112,017

125,040

125,019

0

0

0

Purchase of short- and long-term investments

-

-

-

-

-

-

-

-

-

54,551

59,293

44,391

75,848

88,112

142,452

168,047

131,559

207,303

166,309

178,311

229,233

135,000

0

0

0

Purchase of property and equipment

271,080

271,742

232,669

213,452

198,468

159,205

134,427

115,996

109,862

100,451

91,391

80,819

84,732

96,707

89,797

80,880

56,524

44,648

37,382

32,728

32,549

31,855

0

0

0

Site and software development costs

142,664

129,138

111,678

93,043

74,439

62,750

57,312

52,351

48,662

46,428

44,820

41,766

36,848

31,379

25,873

21,373

18,872

17,536

16,594

16,408

15,528

14,130

0

0

0

Other investing activities, net

18,529

15,567

15,976

-2,642

-2,707

398

399

267

267

0

0

0

0

-

-

-

-

4,697

-3,848

-3,845

-4,240

-531

0

0

0

Net cash provided by (used in) investing activities

-613,789

-854,837

-328,744

-286,269

-281,588

-260,287

-142,540

-146,125

-132,907

-130,335

-97,214

-68,518

-88,455

-95,880

-125,672

-107,948

-55,878

-137,728

-69,807

-111,585

-148,030

-55,435

0

0

0

Cash flows from financing activities:
Proceeds from borrowings

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Taxes paid related to net share settlement of equity awards

2,071

2,236

1,697

1,073

1,058

1,284

1,382

945

1,361

1,562

3,943

9,970

15,063

21,092

24,638

23,648

21,481

19,111

0

0

0

-

-

-

-

Deferred financing costs

0

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net proceeds from exercise of stock options

171

113

124

144

176

138

135

156

219

244

256

241

212

209

287

353

531

495

0

0

0

-

-

-

-

Net proceeds from issuance of Series B convertible redeemable preferred units

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Repurchase of common units

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

23,500

0

0

0

Dividends paid to Series A convertible redeemable preferred holders

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

39,516

0

0

0

Repurchase of employee equity

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

5,528

0

0

0

Net cash provided by (used in) financing activities

887,518

786,504

1,255,663

466,889

466,936

467,463

-1,247

375,500

375,147

374,971

372,602

-9,729

-14,851

-20,883

-24,351

-23,295

-20,950

-18,616

217,879

222,839

225,194

341,150

0

0

0

Effect of exchange rate changes on cash and cash equivalents

152

-1,557

-2,177

-1,213

-1,604

-1,536

-508

109

723

850

-260

640

-1,004

-387

-9

-601

425

-460

594

392

468

730

0

0

0

Net increase (decrease) in cash and cash equivalents

-97,879

-266,708

806,749

145,659

200,334

290,501

-65,085

325,642

309,618

279,120

345,377

-16,489

-36,390

-54,336

-70,346

-16,275

42,716

-21,683

248,383

148,793

70,987

290,570

0

0

0

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

12,401

7,763

4,528

4,528

1,617

1,554

1,554

746

746

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

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

83,533

41,181

38,891

5,179

13,799

15,383

9,798

10,020

1,736

8,533

4,847

7,017

-6,326

1,336

8,366

7,241

18,456

5,258

8,124

8,092

8,839

7,567

0

0

0

Construction costs capitalized under finance lease obligations and other leases

-

-

-

-

-

125,796

95,531

91,728

67,210

47,276

40,321

55,483

49,206

53,894

48,334

35,232

30,472

27,295

0

0

0

-

-

-

-

Accretion of preferred unit dividends

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

2,071

0

0

0

Purchase of employee equity included in accounts payable and accrued expenses

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0