MercadoLibre, Inc. MELI Cash Flow

Mercadolibre, inc. (MELI)

CashFlow / Yearly

Dec'19	Dec'18	Dec'17	Dec'16	Dec'15	Dec'14	Dec'13	Dec'12	Dec'11	Dec'10	Dec'09	Dec'08
Cash flows from operations:
Net (loss) income
-171,999	-36,585	13,780	136,366	105,789	72,581	117,507	101,247	76,780	56,025	33,208	18,811
Adjustments to reconcile net (loss) income to net cash (used in) provided by operating activities:
Net income attributable to Redeemable Noncontrolling Interest
-	-	-	-	-	72	19	98	16	-	-	-
Unrealized devaluation loss, net
44,326	11,131	28,463	4,967	14,717	13,808	6,421	-	-	-	-	-
Impairment of Long-Lived Assets
-	-	2,837	13,717	16,226	49,496	-	-	-	-	-	-
Loss on deconsolidation of Venezuelan subsidiaries
-	-	-85,761	-	-	-	-	-	-	-	-	-
Depreciation and amortization
73,320	45,792	40,921	29,022	23,209	16,947	11,879	8,959	7,268	4,921	3,893	3,335
Accrued interest
54,309	17,811	20,192	17,794	12,783	9,029	9,883	-2,538	7,354	-504	90	57
Non cash interest, convertible notes amortization of debt discount and amortization of debt issuance costs and other charges
86,694	11,408	10,855	9,837	17,272	7,874	-	-	-	-	-	-
Stock-based compensation expense - restricted shares
395	-	-	-	-	-	-	-	-	37	74	105
Foreign currency gains
-	-	-	-	-	-	-	-	-	-	-	-7,827
Interest expense
-	-	-	-	-	-	-	-	-	-	213	300
LTRP accrued compensation
51,662	27,525	35,719	-	-	-	-	-	-	0	1	4
LTRP accrued compensation
-	-	-	22,983	10,213	11,852	11,645	4,442	4,079	3,479	1,924	839
Deferred income taxes
16,453	-92,585	-24,575	-6,188	4,354	-20,237	-7,848	-492	1,022	-7,053	-3,607	-2,151
Changes in assets and liabilities:
Accounts receivable
507	27,105	21,817	15,428	36,476	36,120	22,764	8,651	9,274	7,063	2,974	-4,026
Credit card receivables
29,315	-42,655	257,563	180,592	109,139	45,521	27,315	15,570	19,494	2,324	942	-26,573
Prepaid expenses
17,956	23,342	-8,670	9,133	3,907	157	2,075	898	436	333	287	153
Inventory
4,148	3,015	1,549	787	237	-	-	-	-	-	-	-
Other assets
49,390	17,617	54,780	24,425	2,340	5,982	23,127	5,809	6,532	3,643	2,591	1,415
Payables and accrued expenses
143,495	90,123	150,215	47,980	63,668	68,780	26,037	18,061	10,808	8,987	8,686	10,610
Funds payable to customers
267,293	175,398	242,037	164,060	119,353	61,072	47,558	39,889	27,875	15,458	12,421	2,294
Provisions
-	-	-	-	-	-	-	-	-	-	302	-1,277
Other liabilities
45,452	28,202	7,680	-45	1,765	1,675	2,986	1,153	490	-89	-713	1,645
Interest received from investments
49,625	16,733	22,548	15,719	9,686	9,682	11,473	-	4,177	-	-	-
Net cash (used in) provided by operating activities
451,091	230,907	269,010	190,259	221,370	196,793	142,513	139,891	89,425	67,896	49,700	55,779
Cash flows from investing activities:
Purchase of investments
4,490,678	3,176,078	4,553,649	3,501,283	1,949,769	2,577,130	1,135,941	539,355	379,044	121,266	80,060	110,056
Proceeds from sale and maturity of investments
3,353,606	2,662,800	4,713,934	3,508,293	1,875,516	2,330,836	1,174,790	472,871	336,835	76,062	81,728	115,342
Payment for acquired businesses, net of cash acquired
-	4,195	8,568	7,284	45,009	36,814	3,423	-	5,468	-	-	39,181
Reduction of cash due to Venezuela deconsolidation
-	-	27,230	-	-	-	-	-	-	-	-	-
Payment of remaining amount from business acquisition
-	-	-	-	-	4,000	-	-	-	-	-	-
Purchases of intangible assets
72	192	33	431	1,746	857	459	1,390	280	416	955	58
Changes in principal loans receivable, net
173,848	57,232	72,244	6,599	-	-	-	-	-	-	-	-
Advance for property and equipment
-	4,426	19,695	8,412	23,380	-	-	-	-	-	-	-
Purchases of property and equipment
136,798	93,136	55,156	68,527	39,150	34,426	113,756	16,747	18,924	13,214	3,798	4,904
Net cash used in investing activities
-1,447,790	-672,459	-22,641	-84,243	-183,538	-322,391	-78,789	-84,622	-66,882	-58,834	-3,086	-38,858
Cash flows from financing activities:
Funds received from the issuance of convertible notes
-	880,000	-	-	-	330,000	-	-	-	-	-	-
Transaction costs from the issuance of convertible notes
-	16,264	-	-	-	8,084	-	-	-	-	-	-
Payments on convertible note
25	348,123	-	-	-	-	-	-	-	-	-	-
Purchase of convertible note capped calls
96,367	148,943	67,308	-	-	19,668	-	-	-	-	-	-
Unwind of convertible note capped calls
-	136,108	-	-	-	-	-	-	-	-	-	-
Proceeds from loans payable and other financial liabilities
629,891	236,873	47,905	11,435	5,033	-	31,454	-	-	-	-	-
Payments on loans payable and other financing liabilities
472,897	123,822	5,004	6,684	9,059	7,704	15,937	-	-	-	-	-
Payment of finance lease obligations
1,929	323	-	-	-	-	-	-	-	-	-	-
Decrease in short term debt
-	-	-	-	-	-	-	-	-	3,000	310	9,137
Loans paid
-	-	-	-	-	-	-	-	-	-	15,000	-
Dividends paid
-	6,624	26,496	24,419	20,974	28,303	23,754	17,968	10,593	-	-	-
Common Stock repurchased
720	-	-	-	2,714	1,944	1,012	-	-	-	-	-
Dividends paid of preferred stock
2,844	-	-	-	-	-	-	-	-	-	-	-
Proceeds from issuance of convertible redeemable preferred stock, net
98,688	-	-	-	-	-	-	-	-	-	-	-
Proceeds from issuance of common stock, net
1,867,215	-	-	-	-	-	-	-	-	-	-	-
Repurchase of Treasury Stock
-	-	-	-	-	-	-	-	-	-	-	-2,598
Stock options exercised
-	-	-	-	-	-	3	5	11	18	28	83
Net cash provided by financing activities
2,021,012	608,882	-50,903	-19,668	-27,714	264,297	-9,246	-17,962	-10,582	-2,981	-15,282	-11,652
Effect of exchange rate changes on cash, cash equivalents, restricted cash and cash equivalents
-37,584	-90,895	-41,346	-19,089	-66,381	-55,840	-15,682	-3,199	-1,409	946	996	-3,471
Net (decrease) increase in cash, cash equivalents, restricted cash and cash equivalents
986,729	76,435	154,120	67,259	-56,263	82,859	38,796	34,107	10,551	7,027	32,329	1,796
Supplemental cash flow information:
Cash paid for interest
40,523	19,511	7,734	8,059	7,977	4,751	658	68	58	5,781	12,332	7,138
Cash paid for income tax
94,954	99,488	110,913	74,008	65,550	67,662	55,996	38,837	31,050	22,253	11,650	7,921
Convertible senior notes, amount converted
-	343,000	-	-	-	-	-	-	-	-	-	-
Stock-based compensation-restricted shares issued
1	-	-	56	279	118	58	-	-	-	-	-
LTRP shares issued
-	-	-	-	2,713	1,930	1,032	-	-	-	-	-
Exercise of convertible notes
65,957	1	-	3	-	-	-	-	-	-	-	-
Finance lease obligations
2,567	7,125	-	-	-	-	-	-	-	-	-	-
Contingent considerations and escrows from acquired business
-	5,206	-	1,215	6,841	5,807	-	-	-	-	-	-
Property and equipment acquired under finance leases
4,496	7,448	-	-	-	-	-	-	-	-	-	-
Cash and cash equivalents
-	507	165	93	752	1,102	31	-	3	-	-	-
Accounts receivable
-	1,145	471	609	1,039	5,932	538	-	-	-	-	-
Tax credits
-	-	-	21	179	814	-	-	-	-	-	-
Other current assets
-	202	18	224	50	19	15	-	-	-	-	-
Non current assets
-	-	-	-	-	236	94	-	99	-	-	-
Fixed Assets
-	90	1	71	238	564	6	-	-	-	-	-
Total assets acquired
-	1,944	655	1,018	2,258	8,667	684	-	153	-	-	-
Accounts payable and accrued expenses
-	149	26	434	381	4,372	143	-	-	-	-	-
Financial liabilities
-	-	-	-	-	2,160	-	-	-	-	-	-
Taxes payable
-	-	-	-	-	71	181	-	-	-	-	-
Payroll and social security payable
-	-	-	-	-	527	123	-	-	-	-	-
Other liabilities
-	1,341	429	389	727	-	-	-	-	-	-	-
Total liabilities assumed
-	1,490	455	823	1,108	7,130	447	-	-	-	-	-
Net assets acquired
-	454	200	195	1,150	1,537	237	-	153	-	-	-
Goodwill, Identifiable Intangible Assets and deferred tax liabilities
-	7,022	5,966	6,874	34,297	21,193	2,669	-	8,966	-	-	-
Escrow for employment relationship
-	-	-	-	-	-	548	-	-	-	-	-
Non-controlling interest
-	-	-	-	-	-	-	-	3,648	-	-	-
Total purchase price
-	9,908	8,733	8,592	52,602	42,758	3,454	-	5,472	-	-	-
Cash and cash equivalents acquired
-	507	165	93	752	1,102	31	-	3	-	-	-
Payment for acquired businesses, net of cash acquired
-	9,401	8,568	8,499	51,850	41,656	3,423	-	-	-	-	-
Trademarks [Member]
Intangible assets
-	1,020	328	251	-	-	-	-	-	-	-	-
Customer Lists [Member]
Intangible assets
-	475	1,280	676	-	-	-	-	-	-	-	-
Software [Member]
Intangible assets
-	-	709	282	-	-	-	-	-	-	-	-
Non-Solicitation And Non-Compete Agreements [Member]
Intangible assets
-	937	250	-	-	-	-	-	-	-	-	-
Non-Solicitation Agreements [Member]
Intangible assets
-	-	-	314	-	-	-	-	-	-	-	-