Q2 2016 · NASDAQ · Aug 19, 2016

MELI A Third Venezuela Impairment Landed - and Free Cash Flow Recovered Anyway

MercadoLibre's Q2 2016 10-Q shows net income down 18.5% to $15.9 million as the SIMADI exchange rate weakened 130% (from 273 to 628 BsF/USD) within the quarter, forcing a fresh $13.7 million Venezuelan real-estate impairment plus a $4.9 million FX loss - the third such Venezuela charge this coverage has now tracked. But unlike Q1's negative free cash flow, this quarter's free cash flow snapped back to a positive $29.1 million, almost exactly reversing Q1's $(29.1) million reading and leaving the first half of 2016 roughly breakeven on a free-cash-flow basis. Ex-impairment, operating margin actually improved 0.55 percentage points to 23.0%, and the local-currency-versus-reported revenue gap narrowed to 43.1 points from Q1's record 68.6.

The Venezuela Charge Is Now a Recurring Line Item, Not a One-Time Event

Last quarter flagged that MercadoLibre's free cash flow had gone negative for the first time in this coverage, and that Venezuela had just gone through a fourth currency-regime change (the March 2016 DIPRO/DICOM overlay) without triggering a new impairment. That reprieve didn't last: between March 31 and June 30, 2016, the SIMADI rate MercadoLibre actually uses to re-measure its Venezuelan balance sheet weakened from 273 to 628 BsF per U.S. dollar - a 130% devaluation inside a single quarter. That forced a fresh $13.7 million impairment of Venezuelan offices and commercial property under construction, plus a $4.9 million foreign-exchange re-measurement loss, an $18.6 million combined pretax hit. This is the third distinct Venezuela impairment event this coverage has now tracked (Q2 2014's $49.5 million, Q1 2015's $16.2 million, and now Q2 2016's $13.7 million), and each one has hit a different, smaller pool of remaining Venezuelan assets as the prior write-downs shrink what's left to impair.

Net income fell 18.5% to $15.9 million, from $19.5 million a year earlier, and both the blended tax rate (43.8%, up from 41.9%) and effective tax rate (46.0%, up from 36.8%) rose because the impairment is non-deductible and this quarter's FX loss was deemed an unrecoverable tax loss carryforward. Strip the impairment out, though, and the underlying business actually improved: ex-impairment operating margin was 23.0%, up 0.55 percentage points from Q2 2015's 22.45% - a genuinely better quarter of core execution sitting underneath a worse headline number, the same pattern this coverage saw in Q1 2015's post-impairment reads.

The more encouraging reversal is on cash flow. Free cash flow was positive $29.1 million this quarter, almost exactly offsetting Q1's negative $29.1 million reading, leaving the first half of 2016 at essentially break-even free cash flow ($(0.0) million on a six-month basis, versus $26.7 million in H1 2015). The credit-card-receivables build that drove Q1's cash burn continued (receivables grew a further $22.4 million in Q2, on top of Q1's $62.5 million), but this quarter's stronger operating cash flow ($56.7 million, more than double Q1's negative reading) absorbed it. One quarter of data isn't enough to call the funding dynamic resolved, but it does mean Q1's negative reading looks more like a lumpy single quarter than the start of a structural cash drain.

The Prescription

MercadoLibre should start disclosing a standalone measure of Venezuela's actual remaining exposure - carrying value of real estate, cash held locally, and expected future impairment risk - rather than making a reader reconstruct it from three separate quarterly write-downs with no cumulative accounting. Three Venezuela impairments in nine quarters is now a pattern the Company itself should be quantifying proactively (a "maximum remaining Venezuela impairment exposure" disclosure, similar to how it already discloses maximum buyer-protection-program exposure), instead of treating each devaluation as a fresh, isolated event.

What it should stop doing: letting the credit-receivables funding story go undisclosed a second consecutive quarter. Free cash flow swung $58.2 million from Q1 to Q2 with essentially no qualitative explanation of what changed in the underlying funding mechanics - a reader is left to infer from the balance sheet delta and the operating cash flow line why the number recovered, the same disclosure gap flagged last quarter. If this volatility is going to keep recurring as MercadoPago's credit book scales, it deserves a real explanation, not just two data points a reader has to reconcile independently.

Key Financial Metrics

Three months ended June 30, 2016 vs. three months ended June 30, 2015 - consolidated, reported in USD (MercadoLibre reports natively in dollars; no FX conversion is needed)

Metric Q2 2016 Q2 2015 YoY
Net revenues $199.6M $154.3M ✅ +29.4% reported (✅ +72.5% at local currency - a 43.1pp gap, narrower than Q1's record 68.6pp)
Cost of net revenues $(73.3)M $(50.3)M ⚠️ +45.7% - collection fees, sales taxes, and MPOS costs all growing with TPV penetration
Gross profit (63.3% margin) $126.3M $104.0M (67.4% margin) ✅ +21.4%, margin -4.1pp
Product and technology development $(24.2)M $(19.6)M ⚠️ +23.3% - slower than revenue growth for the first time in several quarters
Sales and marketing $(35.3)M $(29.1)M ✅ +21.4% - also slower than revenue growth
General and administrative $(20.8)M $(20.6)M ✅ +1.1% - essentially flat, well below revenue growth
Impairment of long-lived assets $(13.7)M $0.0M 🔴 Fresh Venezuela real estate write-down after SIMADI weakened 130% intra-quarter
Income from operations (16.1% margin) $32.2M $34.6M (22.5% margin) 🔴 -7.1%, margin -6.3pp (ex-impairment: 23.0% margin, ✅ +0.55pp - the underlying business actually improved)
Foreign currency losses $(5.4)M $(0.6)M 🔴 Mostly the $4.9M Venezuela SIMADI re-measurement loss
Blended tax rate 43.8% 41.9% 🔴 +1.9pp - the impairment and FX loss are non-deductible
Effective tax rate 46.0% 36.8% 🔴 +9.2pp, same drivers
Net income $15.9M $19.5M 🔴 -18.5%
Diluted EPS $0.36 $0.44 🔴 -18.2%
Net cash provided by operating activities $56.7M $58.6M ⚠️ -3.2%, despite a further $22.4M credit-card-receivables build
Free cash flow» $29.1M $(3.3)M ✅ A $32.4M swing, almost exactly reversing Q1's $(29.1)M reading
Capital expenditures (Company's own metric, includes acquisitions) $27.6M $61.9M ✅ -55.4% - Q2 2015 included the $45.0M KPL Soluções/Metros Cúbicos acquisitions
Cash, ST & LT investments (period end) $553.3M n/a Down from $556.6M at December 31, 2015
Loans payable and other financial liabilities (period end) $297.5M n/a Almost entirely the $330M convertible notes, carrying value $295.6M as the debt discount amortizes

Six months ended June 30, 2016: net revenue grew 18.1% to $357.3M, net income grew 117.7% to $46.1M (almost entirely a base-effect comparison against H1 2015's $36.6M Q1 Venezuela charge, not a genuine acceleration), and free cash flow was essentially break-even at $(0.0)M versus H1 2015's $26.7M, as Q1's negative $29.1M and Q2's positive $29.1M nearly cancelled out.

Key Operational Metrics

Three months ended June 30, 2016 vs. three months ended June 30, 2015

Metric Q2 2016 Q2 2015 YoY
Gross merchandise volume» (GMV, excludes motor vehicles/vessels/aircraft/real estate) $2,004.7M $1,653.5M ✅ +21.2%
Total payment volume» (TPV) $1,816.9M $1,206.0M ✅ +50.7%
Total payment transactions 31.9M 18.1M ✅ +76.2%
Confirmed registered users (cumulative, period end) 158.6M 132.3M ✅ +19.9%
New confirmed registered users (in period) 7.1M 5.6M ✅ +26.8%
Items sold 43.7M 30.2M ✅ +44.7%
Items shipped 20.3M 10.0M ✅ +103.0%
TPV as % of GMV 90.6% 72.9% ✅ +17.7pp

Items shipped more than doubling (+103.0%) is the standout operational number this quarter - MercadoEnvios is scaling faster than every other metric in this table, including TPV's own strong 50.7% growth. TPV climbing to 90.6% of GMV, up 17.7 points in a year, confirms MercadoPago is now processing nearly everything that moves through the Marketplace; combined with the credit-receivables dynamics flagged above, that penetration is the direct driver of both this quarter's revenue mix shift (non-marketplace revenue grew 41.3% against marketplace's 21.5%) and the cash flow volatility this coverage has now tracked for two consecutive quarters.

Five Country Segments - Every Segment Grew Local-Currency Revenue Faster Than 60%, and Currency Ate Most of It

MercadoLibre reports the same five geographic segments adopted in 2010 - Brazil, Argentina, Mexico, Venezuela, and Other Countries. The Company's own segment footnote discloses only six-month cumulative figures; the three-month (Q2-standalone) revenue and margin figures below are derived by subtracting the already-reported Q1 2016 and Q1 2015 segment figures from these six-month totals, and are corroborated by the Company's own separately-disclosed Q2-standalone revenue-by-segment table in its MD&A section.

Segment Q2 2016 Revenue YoY Revenue Local-currency revenue growth Direct contribution margin, Q2 2016 Direct contribution margin, Q2 2015 Margin change
Brazil $102.9M ✅ +41.2% 61.4% 40.3% 39.6% ✅ +0.6pp
Argentina $67.7M ✅ +19.1% 89.1% 43.2% 48.9% 🔴 -5.6pp
Mexico $11.5M ✅ +14.6% 35.3% 19.6% 33.5% 🔴 -13.9pp
Venezuela $7.5M ✅ +30.6% 184.6% -138.8% headline (45.1% ex-impairment) 54.0% 🔴 -8.9pp ex-impairment
Other Countries $10.1M ✅ +13.8% 29.7% 29.6% 33.7% 🔴 -4.0pp
Total $199.6M ✅ +29.4% 72.5% 32.9% headline (39.7% ex-impairment) 42.8% 🔴 -3.1pp ex-impairment

Brazil, now 51.6% of consolidated revenue, is the only segment to both grow revenue fast (41.2% reported, on a 63.8% local-currency volume increase) and improve margin (+0.6pp) at the same time - the same pattern Q1 showed and the clearest evidence this business's growth engine right now is concentrated in one market. Argentina grew revenue a healthy 19.1% but lost 5.6 points of margin despite the peso's continued slide (a further 37.1% devaluation this quarter, on top of Q1's 40.6%), because take rate actually rose 5.6% even as direct costs grew faster than revenue. Mexico's 13.9-point margin loss continues Q1's worst-in-coverage reading, now two consecutive quarters of double-digit margin compression on a 15.3% peso devaluation. Venezuela's ex-impairment margin (45.1%) fell 8.9 points from a year ago even before the write-down - the underlying Venezuelan business, not just the one-time charge, is genuinely less profitable than it was, a distinction from Q1's read where the ex-impairment comparison showed relatively less deterioration.

Beyond the Usual

A third Venezuela impairment landed after the SIMADI rate devalued 130% inside a single quarter

Between March 31 and June 30, 2016, the SIMADI exchange rate MercadoLibre uses to re-measure its Venezuelan bolivar balance sheet moved from 273 to 628 BsF per U.S. dollar - more than doubling. That triggered a $4.9 million foreign-exchange re-measurement loss plus a fresh $13.7 million impairment of Venezuelan offices and commercial property under construction (carrying value written down to an estimated $12.5 million), on top of the real estate already impaired in Q1 2015 and the office buildings impaired in Q2 2014.

This is the third distinct Venezuela impairment event this coverage has tracked in nine quarters (Q2 2014: $49.5M; Q1 2015: $16.2M; Q2 2016: $13.7M), each one landing within roughly a year of the last and each one hitting a smaller remaining pool of assets as prior write-downs shrink what's left. The pattern is now well-established enough that a reader shouldn't be surprised by the next one - the open question is no longer whether Venezuela will produce another currency-driven charge, but how much smaller the exposure has to get before it stops being large enough to matter to the consolidated numbers at all.

The 2016 Long-Term Retention Plan was approved as a subsequent event, becoming a sixth overlapping stock-price-linked compensation tranche

On August 2, 2016 - after quarter-end but before this filing's August 5, 2016 signature date - the Board adopted the 2016 Long-Term Retention Plan, a cash-settled award paid over six years starting March 2017, with a variable component indexed to MercadoLibre's own average closing stock price over the final 60 trading days of the prior year (set against a $111.02 baseline from 2015). This joins the 2009 through 2015 LTRP tranches already accruing, all still vesting simultaneously.

Six overlapping, stock-price-linked, multi-year compensation tranches accruing at once is a genuinely unusual level of overlap for one company's executive compensation structure, though the mechanism itself - paying out based on the Company's own stock performance - is a standard alignment tool, not a governance red flag on its own.

Axado, a Brazilian logistics software company, was acquired for $5.5 million on June 1, 2016

MercadoLibre's Brazilian subsidiary acquired 100% of Axado Informação e Tecnologia S.A., a developer of logistics software for e-commerce, for $5.5 million ($4.7 million cash at closing plus an $0.8 million escrow, with an additional $0.8 million payable to sellers over two years contingent on continued employment). This is the second bolt-on acquisition disclosed this year, after Q1's Monits S.A. purchase, continuing the small, capability-focused acquisition pattern this coverage has tracked repeatedly.

The Company continues to disclose zero off-balance-sheet arrangements, while its litigation docket kept growing

As of June 30, 2016, MercadoLibre again states it has no off-balance-sheet arrangements with a material current or future effect - a clean, consistent disclosure. Separately, its litigation reserve grew to $5.4 million (from $4.7 million at March 31, 2016) against a docket that also kept growing: 56 Argentine lawsuits (up from 51) plus 1,307 consumer-agency claims, 677 Brazilian ordinary-court lawsuits (up from 642) plus 2,566 consumer-court claims, and 6 Mexican lawsuits (up from 2) plus 102 consumer-agency claims. Reasonably-possible unreserved exposure also grew, to $4.5 million from $4.0 million. The steady growth in both reserve and case count together, rather than diverging, suggests the docket is scaling roughly in proportion with the business rather than signaling any new specific legal problem.

Coverage Table

Theme Q2 2016 Q2 2015 YoY Why it matters
Net revenue, reported (USD) $199.6M $154.3M ✅ +29.4% Local-currency growth was 72.5% - a 43.1pp gap, narrower than Q1's record 68.6pp
Net income $15.9M $19.5M 🔴 -18.5% Entirely the fresh $13.7M Venezuela impairment plus $4.9M FX loss; ex-impairment operating margin actually improved
Free cash flow $29.1M $(3.3)M ✅ +$32.4M swing Almost exactly reverses Q1's $(29.1)M, leaving H1 2016 roughly break-even
Venezuela SIMADI rate 628 BsF/USD, from 273 at Q1-end n/a 🔴 A 130% devaluation inside one quarter; third Venezuela impairment this coverage has tracked
Ex-impairment operating margin 23.0% 22.45% ✅ +0.55pp The underlying business improved even as the headline number fell
2016 LTRP Approved August 2, 2016 (subsequent event) n/a ⚠️ Sixth overlapping stock-price-linked compensation tranche

Target Valuation Range

DCF fair-value range: roughly $3,189 million (base case) to $6,326 million (bull case) enterprise value, against a $5,955.8 million actual enterprise value - still inside the fair-value band, but now near the top of it. The valuation gap widened again this quarter - not because the underlying business deteriorated, but because the stock rallied 19.4% while trailing free cash flow grew more slowly, leaving both the base and bull cases covering a smaller share of enterprise value than they did in Q1.

The stock closed Q2 2016 at $140.67, up 19.4% from March 2016's $117.85 (MercadoLibre has never split its common stock since its August 2007 IPO, so no split adjustment applies) - essentially all of the enterprise-value increase is the stock's own rally.

Market cap → enterprise value Q2 2016
Share price (period-end) $140.67
Shares outstanding 44,157,341
Market capitalization $6,211.6 million
Plus: loans payable $297.5 million
Less: cash & investments $553.3 million
Enterprise value $5,955.8 million

Trailing-twelve-month net revenue is FY2015's $651.8 million, less H1 2015's $302.4 million, plus H1 2016's $357.3 million; trailing FCF is a more representative reading than Q1's distorted figure, since Q2's recovery brought it back toward FY2015's underlying run rate (though still depressed relative to FY2015's own $117.1 million FCF).

Valuation multiples Q1 2016 Q2 2016 Change
TTM Net Revenue $661.3 million $706.7 million ⬆ up
Enterprise value $4,974.6 million $5,955.8 million ⬆ up
EV/Sales 7.52x 8.43x ⬆ up
P/E (TTM) 38.7x 47.5x ⬆ up
EV/FCF (TTM) 85.6x 65.9x ⬇ down (improving as trailing FCF normalizes)
Scenario Key assumption Implied EV % of actual EV
Current (Q2 2016 close) actual market price $5,955.8 million 100%
Base Revenue growth 20%→10% over 5yrs; FCF margin 15%→26%; 13% discount, 4% terminal growth $3,189 million 53.5%
Bull Revenue growth 24/20/17/14/11%; FCF margin 20%→32%; 11% discount, 5% terminal growth $6,326 million 106.2%

The base case's coverage fell from Q1's ~60.0% as the stock rallied faster than the trailing cash flow base grew; the bull case still clears the actual price, but by a much thinner margin than Q1's ~119.0%.

Reverse DCF: holding the 13% discount rate and solving for the perpetual FCF growth rate that would justify today's $5,955.8 million enterprise value on the $90.4 million trailing FCF base gives roughly 11.3%, forever - up from the 10.4%-11.7% range this coverage measured last quarter (itself split across two different FCF bases because of Q1's distortion), now converging to a single, more reliable reading since this quarter's trailing FCF figure isn't dominated by one anomalous quarter the way Q1's was.

Whether Venezuela produces a fourth impairment event before its remaining asset base finally shrinks below materiality, and whether free cash flow settles into a genuinely stable quarterly pattern now that Q1's burn and Q2's recovery have roughly offset each other, are the two clearest swing factors for this valuation gap going forward.


MercadoLibre, Inc.'s Quarterly Report on Form 10-Q for the quarter ended June 30, 2016, filed with the U.S. Securities and Exchange Commission and signed August 5, 2016. Historical MELI share price data covers month-end closes from June 2014 through June 2016; MercadoLibre has never split its common stock since its August 2007 IPO, so no split adjustment applies to these figures. No presentation, press release, or transcript was located for this filing, so this post does not include a management-commentary section.