Mercadolibre, inc. (MELI)
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'14Dec'13Sep'13Jun'13Mar'13Dec'12Sep'12Jun'12Mar'12Dec'11Sep'11Jun'11Mar'11Dec'10Sep'10Jun'10Mar'10
Cash flows from operations:
Net (loss) income

-204,972

-171,999

-120,337

15,667

-11,802

-36,585

-101,969

-64,225

-47,657

13,780

132,849

144,095

154,637

136,366

123,982

130,710

134,315

105,789

100,970

89,095

44,038

72,581

79,198

74,718

130,290

117,507

106,933

103,692

99,092

101,247

92,662

92,915

82,357

76,780

71,113

63,608

60,462

56,025

0

0

0

Adjustments to reconcile net (loss) income to net cash (used in) provided by operating activities:
Net income attributable to Redeemable Noncontrolling Interest

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

72

128

4

40

19

2

165

138

98

0

0

0

-

-

-

0

-

-

-

-

Unrealized devaluation loss, net

60,945

44,326

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

14,717

6,080

10,862

27,328

13,808

13,808

13,808

-2,657

6,421

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Impairment of Long-Lived Assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

16,226

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Depreciation and amortization

79,176

73,320

64,449

56,201

50,402

45,792

44,829

44,404

43,002

40,921

38,277

34,927

31,773

29,022

26,951

25,417

24,380

23,209

21,557

20,334

18,509

16,947

15,631

14,005

12,776

11,879

11,140

10,357

9,614

8,959

8,431

8,019

7,693

7,268

6,576

6,040

5,515

4,921

0

0

0

Accrued interest

67,962

54,309

46,103

34,719

22,063

17,811

15,059

17,107

18,960

20,192

21,542

20,806

19,596

17,794

16,115

14,932

13,880

12,783

11,412

10,587

9,790

9,029

13,577

11,108

9,370

9,883

6,407

6,668

809

-2,538

6,103

3,486

7,113

7,354

-4,704

-2,820

-852

-504

0

0

0

Non cash interest, convertible notes amortization of debt discount and amortization of debt issuance costs and other charges

104,463

86,694

62,791

12,864

7,363

11,408

20,007

15,741

13,692

10,855

9,949

9,930

9,632

9,837

13,477

13,415

17,719

17,272

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Financial results on derivative instruments

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Stock-based compensation expense - restricted shares

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

37

0

0

0

LTRP accrued compensation

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

0

LTRP accrued compensation

-

-

-

-

-

-

-

0

42,280

-

32,466

34,925

28,969

22,983

21,432

11,876

10,076

10,213

13,573

18,384

14,413

11,852

7,958

9,278

10,700

11,645

11,101

6,537

4,303

4,442

4,890

3,978

4,758

4,079

3,207

4,266

4,325

3,479

0

0

0

Deferred income taxes

26,710

16,453

12,330

-72,510

-76,440

-92,585

-85,081

-68,942

-52,378

-24,575

-15,062

-14,658

-7,090

-6,188

-7,747

-5,363

-3,660

4,354

2,484

-3,829

-9,444

-20,237

-20,356

-14,704

-12,382

-7,848

-3,685

-2,453

-441

-492

-964

-315

515

1,022

1,071

-4,469

-6,328

-7,053

0

0

0

Changes in assets and liabilities:
Accounts receivable

-18,904

507

10,750

12,198

17,421

27,105

23,328

38,459

29,859

21,817

26,399

17,760

-6,187

15,428

-11,220

19,967

31,473

36,476

46,748

32,673

54,633

36,120

45,102

37,334

31,179

22,764

21,966

13,835

11,449

8,651

6,808

12,145

7,092

9,274

7,306

2,649

4,421

7,063

0

0

0

Credit card receivables

98,511

29,315

13,273

116,004

-112,418

-42,655

22,153

194,627

307,016

257,563

201,295

68,097

102,465

180,592

79,622

134,920

116,920

109,139

121,552

82,796

90,413

45,521

66,052

11,366

31,451

27,315

4,277

40,986

21,188

15,570

30,158

23,526

20,090

19,494

9,634

4,351

2,286

2,324

0

0

0

Prepaid expenses

12,712

17,956

7,194

4,342

3,862

23,342

4,940

6,935

7,841

-8,670

2,061

3,680

7,399

9,133

-743

1,571

1,843

3,907

2,505

956

2,646

157

2,351

1,998

1,967

2,075

2,173

1,772

1,295

898

1,182

773

1,181

436

497

778

320

333

0

0

0

Inventory

11,072

4,148

2,939

-2,093

491

3,015

6,392

7,950

3,148

1,549

911

48

-98

787

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other assets

50,101

49,390

24,413

5,827

9,693

17,617

40,715

57,147

63,317

54,780

40,088

38,795

22,159

24,425

5,116

5,922

6,772

2,340

12,992

11,591

9,213

5,982

22,972

19,878

17,606

23,127

9,950

7,117

10,898

5,809

3,397

8,053

5,968

6,532

6,271

840

3,620

3,643

0

0

0

Payables and accrued expenses

100,885

143,495

128,062

89,150

66,859

90,123

129,400

159,353

159,624

150,215

105,922

96,746

46,968

47,980

10,622

7,561

47,649

63,668

61,089

75,984

87,420

68,780

82,647

47,431

35,548

26,037

25,170

24,754

26,681

18,061

15,390

22,257

9,187

10,808

7,419

-2,028

392

8,987

0

0

0

Funds payable to customers

182,219

267,293

187,568

261,306

218,515

175,398

173,311

211,386

248,721

242,037

215,373

167,915

154,305

164,060

118,737

126,656

94,354

119,353

113,596

91,109

102,389

61,072

63,492

47,571

46,069

47,558

52,383

48,382

48,903

39,889

31,807

34,618

24,644

27,875

24,117

17,438

18,112

15,458

0

0

0

Provisions

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

Other liabilities

511

45,452

40,238

11,576

37,896

28,202

10,054

28,391

10,598

7,680

3,522

23

-1,074

-45

-325

1,851

2,736

1,765

1,944

-328

1,538

1,675

2,477

2,003

1,006

2,986

2,688

2,938

1,882

1,153

1,147

608

1,838

490

3,107

2,121

598

-89

0

0

0

Interest received from investments

60,894

49,625

41,122

25,959

16,357

16,733

15,044

19,826

22,445

22,548

22,861

18,857

15,348

15,719

13,134

12,723

11,248

9,686

10,612

10,045

10,260

9,682

9,749

9,331

10,233

11,473

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Net cash (used in) provided by operating activities

227,069

451,091

407,623

289,678

406,284

230,907

222,722

149,850

127,247

269,010

284,966

371,718

306,818

190,259

257,773

169,394

171,389

221,370

169,633

205,717

207,344

196,793

158,103

171,258

140,049

142,513

179,031

140,564

150,996

139,891

110,840

114,182

93,242

89,425

88,200

75,536

71,610

67,896

0

0

0

Cash flows from investing activities:
Purchase of investments

4,190,083

4,490,678

4,624,299

4,260,170

4,167,570

3,176,078

3,187,432

3,615,573

4,288,794

4,553,649

4,133,856

4,128,716

3,757,613

3,501,283

3,062,174

2,558,228

2,170,958

1,949,769

2,299,297

2,753,349

2,610,445

2,577,130

2,047,158

1,498,383

1,386,173

1,135,941

996,885

745,952

589,218

539,355

426,213

383,425

366,633

379,044

333,498

258,009

185,981

121,266

0

0

0

Proceeds from sale and maturity of investments

4,163,854

3,353,606

2,938,788

2,358,548

2,418,603

2,662,800

3,306,871

3,904,475

4,521,803

4,713,934

4,354,718

4,143,129

3,725,024

3,508,293

2,976,484

2,514,794

2,103,189

1,875,516

2,256,016

2,510,782

2,382,752

2,330,836

1,870,545

1,471,515

1,408,096

1,174,790

955,649

735,417

535,701

472,871

388,741

352,581

339,595

336,835

293,447

220,296

144,162

76,062

0

0

0

Receipts from settlements of derivative instruments

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payment for acquired businesses, net of cash acquired

0

-

-

-

0

-

-

-

-

-

-

-

-

7,284

0

0

0

-

-

-

-

-

-

-

-

3,423

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of intangible assets

131

72

25

-16

129

192

166

201

113

33

466

456

437

431

293

428

815

1,746

1,816

273

1,655

857

0

0

0

-

-

-

-

1,390

1,503

1,562

238

280

522

512

476

416

0

0

0

Changes in principal loans receivable, net

158,489

173,848

151,814

88,071

47,598

57,232

81,153

118,730

119,679

72,244

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Advance for property and equipment

-

-

-

-

-

4,426

11,344

15,770

20,580

19,695

15,060

11,800

10,045

8,412

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of property and equipment

149,045

136,798

128,735

122,405

106,522

93,136

81,009

71,101

64,430

55,156

52,297

62,084

64,243

68,527

75,597

55,435

46,387

39,150

29,043

36,097

34,775

34,426

88,273

90,296

117,860

113,756

54,993

46,517

15,912

16,747

13,522

14,000

19,734

18,924

19,743

22,555

14,703

13,214

0

0

0

Net cash used in investing activities

-337,787

-1,447,790

-1,967,999

-2,116,277

-1,908,447

-672,459

-92,312

47,302

-7,591

-22,641

99,489

-86,669

-124,167

-84,243

-180,594

-127,451

-186,070

-183,538

-145,615

-340,106

-304,937

-322,391

-272,046

-151,888

-96,740

-78,789

-125,670

-60,289

-74,012

-84,622

-52,497

-51,875

-52,479

-66,882

-65,785

-60,780

-56,999

-58,834

0

0

0

Cash flows from financing activities:
Purchase of convertible note capped calls

-

-

-

-

-

148,943

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from loans payable and other financial liabilities

1,345,531

629,891

252,401

185,810

189,925

236,873

190,827

186,771

124,540

47,905

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments on loans payable and other financing liabilities

1,042,578

472,897

149,179

164,165

143,055

123,822

79,405

16,928

6,712

5,004

4,496

3,354

8,898

6,684

10,929

10,920

9,581

9,059

9,017

9,416

7,261

7,704

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payment of finance lease obligations

1,831

1,929

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Loans paid

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

Dividends paid

-

-

-

-

-

6,624

13,249

19,873

26,496

26,496

26,495

26,494

26,495

24,419

22,343

20,268

18,192

20,974

23,792

26,538

29,319

28,303

27,250

26,270

25,255

23,754

22,252

20,750

19,249

17,968

0

0

0

-

-

-

-

-

-

-

-

Dividends paid of preferred stock

3,844

2,844

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from issuance of convertible redeemable preferred stock, net

0

98,688

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from issuance of common stock, net

715

1,867,215

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Stock options exercised

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

3

0

0

0

-

-

-

-

11

11

23

17

18

0

0

0

Net cash provided by financing activities

200,881

2,021,012

1,979,373

2,445,600

2,559,543

608,882

598,013

36,970

-21,668

-50,903

-77,603

-10,613

-19,668

-19,668

-29,362

-26,155

-25,454

-27,714

-30,508

-39,327

263,724

264,297

271,738

287,483

-11,332

-9,246

-9,738

-21,756

-19,240

-17,962

-16,681

-15,403

-14,114

-10,582

-7,151

-3,513

230

-2,981

0

0

0

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

-131,041

-37,584

-39,762

-14,690

-101,530

-90,895

-111,891

-92,902

-48,965

-41,346

-33,649

-35,661

-6,480

-19,089

-32,846

-42,163

-34,748

-66,381

-57,990

-41,414

-77,503

-55,840

-48,387

-52,523

-23,003

-15,682

-13,697

-14,922

-11,451

-3,199

-2,572

-3,558

-1,742

-1,409

-631

1,438

1,491

946

0

0

0

Net (decrease) increase in cash, cash equivalents, restricted cash and cash equivalents

-40,878

986,729

379,235

604,311

955,850

76,435

616,532

141,220

49,023

154,120

273,203

238,775

156,503

67,259

14,971

-26,375

-74,883

-56,263

-64,480

-215,130

88,628

82,859

109,407

254,329

8,972

38,796

29,925

43,595

46,292

34,107

39,088

43,345

24,906

10,551

14,631

12,681

16,333

7,027

0

0

0

Supplemental cash flow information:
Cash paid for interest

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

53

2,962

5,781

0

0

0

Cash paid for income tax

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

26,683

25,216

22,253

0

0

0