MercadoLibre, Inc. MELI Cash Flow

Mercadolibre, inc. (MELI)

CashFlow / Quarterly

Mar'20	Dec'19	Sep'19	Jun'19	Mar'19	Dec'18	Sep'18	Jun'18	Mar'18	Dec'17	Sep'17	Jun'17	Mar'17	Dec'16	Sep'16	Jun'16	Mar'16	Dec'15	Sep'15	Jun'15	Mar'15	Dec'14	Sep'14	Jun'14	Mar'14	Dec'13	Sep'13	Jun'13	Mar'13	Dec'12	Sep'12	Jun'12	Mar'12	Dec'11	Sep'11	Jun'11	Mar'11	Dec'10	Sep'10	Jun'10	Mar'10
Cash flows from operations:
Net (loss) income
-21,109	-53,998	-146,082	16,217	11,864	-2,336	-10,078	-11,252	-12,919	-67,720	27,666	5,316	48,518	51,349	38,912	15,858	30,247	38,965	45,640	19,463	1,721	34,146	33,765	-25,594	30,264	40,763	29,284	29,978	17,480	30,190	26,043	25,379	19,634	21,605	26,295	14,820	14,057	15,939	18,790	11,673	9,620
Adjustments to reconcile net (loss) income to net cash (used in) provided by operating activities:
Net income attributable to Redeemable Noncontrolling Interest
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	16	-14	6	64	72	-137	42	42	55	24	15	2	-	-	-	0	-	-	-	-
Unrealized devaluation loss, net
18,505	-1,531	32,491	11,480	1,886	-	-	-	-	-	-	-	-	-	-	-	-	8,637	-4,782	0	10,862	0	0	16,466	-2,658	0	0	0	6,420	-	-	-	-	-	-	-	-	-	-	-	-
Impairment of Long-Lived Assets
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	16,226	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Depreciation and amortization
21,550	20,802	19,543	17,281	15,694	11,931	11,295	11,482	11,084	10,968	10,870	10,080	9,003	8,324	7,520	6,926	6,252	6,253	5,986	5,889	5,081	4,601	4,763	4,064	3,519	3,285	3,137	2,834	2,621	2,547	2,354	2,090	1,966	2,018	1,943	1,764	1,541	1,327	1,406	1,240	946
Accrued interest
22,352	14,759	14,797	16,054	8,699	6,553	3,413	3,398	4,447	3,801	5,461	5,251	5,679	5,151	4,725	4,041	3,877	3,472	3,542	2,989	2,780	2,101	2,717	2,192	2,019	6,649	247	454	2,531	3,174	507	-5,404	-816	11,816	-2,108	-1,777	-575	-242	-224	190	-228
Non cash interest, convertible notes amortization of debt discount and amortization of debt issuance costs and other charges
20,787	16,925	58,629	8,122	3,018	-6,978	8,702	2,621	7,063	1,621	4,436	572	4,226	715	4,417	274	4,431	4,355	4,355	4,578	3,984	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Financial results on derivative instruments
16,767	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Stock-based compensation expense - restricted shares
179	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	16	21
LTRP accrued compensation
15,664	-	-	-	13,441	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	0
LTRP accrued compensation
-	-	-	-	-	-	-	1,055	15,737	-	6,666	12,892	9,176	3,732	9,125	6,936	3,190	2,181	-431	5,136	3,327	5,541	4,380	1,165	766	1,647	5,699	2,586	1,710	1,104	1,135	353	1,849	1,551	223	1,132	1,170	680	1,282	1,191	324
Deferred income taxes
-4,199	-13,187	64,383	-20,287	-14,456	-17,310	-20,457	-24,217	-30,601	-9,806	-4,318	-7,653	-2,798	-293	-3,914	-85	-1,896	-1,852	-1,530	1,618	6,118	-3,722	-7,843	-3,997	-4,675	-3,841	-2,191	-1,674	-140	321	-959	336	-190	-151	-310	1,167	316	-102	-5,851	-691	-407
Changes in assets and liabilities:
Accounts receivable
-19,748	1,971	-8,364	7,237	-337	12,214	-6,916	12,460	9,347	8,437	8,215	3,860	1,305	13,019	-424	-20,087	22,920	-13,629	30,763	-8,581	27,923	-3,357	16,688	13,379	9,410	5,625	8,920	7,224	994	4,827	789	4,838	-1,803	2,984	6,125	-214	378	1,015	1,469	1,557	3,020
Credit card receivables
33,303	95,283	-127,530	97,455	-35,893	79,241	-24,799	-130,967	33,870	144,049	147,675	-18,578	-15,583	87,781	14,477	15,790	62,544	-13,189	69,775	-2,210	54,763	-776	31,019	5,407	9,871	19,755	-23,666	25,491	5,734	-3,282	13,041	5,694	116	11,306	6,408	2,258	-479	1,446	1,125	193	-441
Prepaid expenses
-8,560	27,294	-481	-5,541	-3,316	16,532	-3,333	-6,021	16,164	-1,870	-1,338	-5,115	-347	8,861	281	-1,396	1,387	-1,015	2,595	-1,124	3,451	-2,417	1,046	566	962	-222	693	534	1,069	-123	291	57	673	159	-116	465	-71	220	165	6	-58
Inventory
5,272	-1,791	4,748	2,843	-1,652	-3,000	-284	5,427	872	377	1,274	625	-727	-261	411	479	158	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Other assets
5,796	25,131	11,608	7,566	5,085	154	-6,978	11,432	13,009	23,252	9,454	17,602	4,472	8,560	8,161	966	6,738	-10,749	8,967	1,816	2,306	-97	7,566	-562	-925	16,893	4,471	-2,833	4,595	3,716	1,639	947	-493	1,304	6,295	-1,137	70	1,043	864	1,642	92
Payables and accrued expenses
-43,101	54,577	47,120	42,289	-491	39,144	8,208	19,998	22,773	78,421	38,161	20,269	13,364	34,128	28,985	-29,509	14,376	-3,230	25,924	10,579	30,395	-5,809	40,819	22,015	11,755	8,058	5,603	10,131	2,243	7,191	5,187	12,058	-6,375	4,520	12,054	-1,011	-4,754	1,131	2,606	1,408	3,840
Funds payable to customers
-21,344	172,214	-23,342	54,691	63,730	92,489	50,396	11,900	20,613	90,402	88,471	49,235	13,929	63,738	41,013	35,625	23,684	18,415	48,932	3,323	48,683	12,658	26,445	14,603	7,366	15,078	10,523	13,100	8,854	19,904	6,522	13,620	-159	11,823	9,333	3,646	3,072	8,064	2,654	4,320	418
Provisions
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	18	-	-	-	-
Other liabilities
-32,206	27,339	14,526	-9,148	12,735	22,125	-14,136	17,172	3,041	3,977	4,201	-621	123	-181	702	-1,718	1,152	-461	2,878	-833	181	-282	606	1,033	318	520	131	36	2,297	223	381	-1,019	1,568	217	-157	210	220	2,834	-1,143	-1,312	-467
Interest received from investments
14,805	14,250	18,083	13,756	3,536	5,747	2,920	4,154	3,912	4,058	7,702	6,773	4,015	4,371	3,698	3,264	4,386	1,786	3,287	1,789	2,824	2,712	2,720	2,004	2,246	2,779	2,301	2,905	3,485	-	-	-	-	-	-	-	-	-	-	-	-
Net cash (used in) provided by operating activities
-85,651	78,274	206,892	27,554	138,371	34,806	88,947	144,160	-37,006	26,621	16,075	121,557	104,757	42,577	102,827	56,657	-11,802	110,091	14,448	58,652	38,179	58,354	50,532	60,279	27,628	19,664	63,686	29,070	30,091	56,183	25,219	39,502	18,986	27,131	28,561	18,563	15,168	25,906	15,897	14,637	11,454
Cash flows from investing activities:
Purchase of investments
1,323,631	1,228,041	930,093	708,318	1,624,226	1,361,662	565,964	615,718	632,734	1,373,016	994,105	1,288,939	897,589	953,223	988,965	917,836	641,259	514,114	485,019	530,566	420,070	863,642	939,071	387,662	386,755	333,670	390,295	275,452	136,522	194,615	139,362	118,718	86,658	81,474	96,574	101,926	99,069	35,927	21,085	29,897	34,354
Proceeds from sale and maturity of investments
1,249,960	1,113,138	1,154,007	646,749	439,712	698,320	573,767	706,804	683,909	1,342,391	1,171,371	1,324,132	876,040	983,175	959,782	906,027	659,309	451,366	498,092	494,422	431,636	831,866	752,858	366,392	379,720	371,575	353,827	302,973	146,413	152,435	133,595	103,257	83,583	68,305	97,435	90,270	80,823	24,917	24,284	14,136	12,723
Receipts from settlements of derivative instruments
3,668	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payment for acquired businesses, net of cash acquired
7,561	-	-	-	0	-	-	-	-	-	-	-	-	0	0	5,446	1,838	-	-	-	-	-	-	-	-	198	0	0	3,224	-	-	-	-	-	-	-	-	-	-	-	-
Purchases of intangible assets
93	22	16	0	34	-25	-25	145	97	-51	10	57	17	382	0	38	11	244	135	425	942	314	-1,408	1,807	144	-	-	-	-	48	-48	1,359	31	161	10	35	73	403	0	-0	12
Changes in principal loans receivable, net
27,250	23,406	52,974	54,859	42,609	1,372	-10,769	14,386	52,243	25,293	26,808	15,335	4,808	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Advance for property and equipment
-	-	-	-	-	0	0	1,036	3,390	6,918	4,426	5,846	2,505	2,283	1,166	4,091	872	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Purchases of property and equipment
45,175	36,066	29,371	38,433	32,928	28,003	23,041	22,550	19,542	15,876	13,133	15,879	10,268	13,017	22,920	18,038	14,552	20,087	2,758	8,990	7,315	9,980	9,812	7,668	6,966	63,827	11,834	35,232	2,861	5,064	3,358	4,627	3,696	1,839	3,836	10,361	2,886	2,659	6,648	2,509	1,396
Net cash used in investing activities
-150,082	-174,397	141,553	-154,861	-1,260,085	-694,606	-6,725	52,969	-24,097	-114,459	132,889	-1,924	-39,147	7,671	-53,269	-39,422	777	-88,680	-126	-98,041	3,309	-50,757	-194,617	-62,872	-14,145	-412	-74,458	-7,724	3,806	-47,294	-9,077	-21,447	-6,802	-15,170	-8,454	-22,052	-21,205	-14,073	-3,449	-18,270	-23,040
Cash flows from financing activities:
Purchase of convertible note capped calls
-	-	-	-	-	11,467	91,784	0	45,692	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from loans payable and other financial liabilities
749,617	458,288	76,000	61,626	33,977	80,798	9,409	65,741	80,925	34,752	5,353	3,510	4,290	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payments on loans payable and other financing liabilities
593,497	368,835	48,826	31,420	23,816	45,117	63,812	10,310	4,583	700	1,335	94	2,875	192	193	5,638	661	4,437	184	4,299	139	4,395	583	2,144	582	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payment of finance lease obligations
564	513	527	227	662	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Loans paid
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	3,213
Dividends paid
-	-	-	-	-	0	0	0	6,624	6,625	6,624	6,623	6,624	6,624	6,623	6,624	4,548	4,548	4,548	4,548	7,330	7,366	7,294	7,329	6,314	6,313	6,313	6,313	4,812	4,812	4,812	4,812	3,531	-	-	-	-	-	-	-	-
Dividends paid of preferred stock
1,000	1,000	1,000	844	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from issuance of convertible redeemable preferred stock, net
0	0	0	0	98,688	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from issuance of common stock, net
0	0	0	715	1,866,500	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Stock options exercised
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-0	0	0	3	-	-	-	-	0	0	9	0	0	12	3	1
Net cash provided by financing activities
154,556	79,935	24,902	-58,512	1,974,687	38,296	491,129	55,431	24,026	27,427	-69,914	-3,207	-5,209	727	-2,924	-12,262	-5,209	-8,967	283	-11,561	-7,469	-11,761	-8,536	291,490	-6,896	-4,319	7,209	-7,326	-4,809	-4,812	-4,808	-4,809	-3,531	-3,531	-3,530	-3,520	0	-101	108	223	-3,211
Effect of exchange rate changes on cash, cash equivalents, restricted cash and cash equivalents
-104,864	10,647	-44,704	7,880	-11,407	8,469	-19,632	-78,960	-772	-12,527	-643	-35,023	6,847	-4,830	-2,655	-5,842	-5,762	-18,587	-11,972	1,573	-37,395	-10,196	4,604	-34,516	-15,732	-2,743	468	-4,996	-8,410	-759	-757	-1,524	-158	-132	-1,742	291	173	646	326	344	-371
Net (decrease) increase in cash, cash equivalents, restricted cash and cash equivalents
-186,041	-5,541	328,643	-177,939	841,566	-613,035	553,719	173,600	-37,849	-72,938	78,407	81,403	67,248	46,145	43,979	-869	-21,996	-6,143	2,633	-49,377	-3,376	-14,360	-148,017	254,381	-9,145	12,188	-3,094	9,023	20,678	3,317	10,576	11,720	8,493	8,298	14,833	-6,718	-5,862	12,378	12,883	-3,065	-15,169
Supplemental cash flow information:
Cash paid for interest
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	12	13	15	11	2,921	2,832
Cash paid for income tax
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	6,908	7,898	5,650	6,225	5,441	4,935