Q2 2017 · NASDAQ · Aug 18, 2017

MELI Mexico's Direct Contribution Just Went to Negative 112% - Is This a Segment or a Sinkhole?

MercadoLibre's Q2 2017 10-Q shows net revenue up 58.6% to $316.5 million, but net income fell 66.5% to just $5.3 million as a fourth Venezuelan currency-regime change (SIMADI to DICOM, a 3.6x devaluation) forced a $22.0 million FX loss plus a $2.8 million impairment, and Mexico's direct-contribution margin - already negative last quarter - collapsed further to -112.0%, losing $22.6 million on just $20.2 million of revenue. Brazil's margin also reversed, down 7.0 points after three straight periods of improvement. Free cash flow still grew sharply year-over-year despite all of this, and the stock's rally pushed it $95.12 above its own convertible-note dilution-hedge cap price, up from $55.72 last quarter.

A Fourth Venezuelan Currency Regime in Three Years, and Mexico's Losses Just Got Much Worse

Venezuela struck again. On May 19, 2017, Venezuela's central bank replaced SIMADI - the exchange mechanism FY2016's post and Q1 2017's post both cited without incident - with a new auction-based system called DICOM. SIMADI closed at 728.0 BsF per U.S. dollar just before its disappearance; MercadoLibre's re-measurement at the June 1, 2017 DICOM closing rate of 2,640.0 BsF per U.S. dollar - a 3.6x devaluation - forced a $22.0 million foreign-exchange loss plus a fresh $2.8 million impairment of the same Caracas real estate this coverage has tracked being written down repeatedly since 2014. Net income fell 66.5% to just $5.3 million for the quarter (from $15.9 million a year ago), even as net revenue grew a strong 58.6% to $316.5 million.

The currency shock is the headline, but it isn't the worst news in this filing. Q1 2017's post flagged Mexico's direct-contribution margin turning negative (-8.4%) for the first time in this coverage. This quarter it got dramatically worse: Mexico's direct contribution fell to negative $22.6 million on just $20.2 million of revenue - a -112.0% margin, versus +19.7% a year ago. Brazil, the segment that has carried this coverage's margin story since FY2016, also reversed: its own margin fell 7.0 points to 33.3%, the first Brazil margin decline since Q1 2016. Two of the portfolio's largest, previously-strongest segments both moved the wrong way in the same quarter.

The Prescription

MercadoLibre needs a genuine operational response to Mexico now, not another quarter of MD&A commentary alongside four other segments. A segment that lost more money than it generated in revenue - $22.6 million of negative direct contribution on $20.2 million of revenue - isn't a margin-compression story anymore; it's a business unit actively destroying value on every transaction it processes, and the filing gives no specific explanation beyond generic references to rising costs. Investors deserve a dedicated disclosure of what's driving Mexico's economics (competitive pricing pressure, a deliberate loss-leader strategy, a cost-structure problem specific to that market) rather than folding it into the same segment table as four profitable countries.

What it should stop doing: treating each new Venezuelan exchange-rate regime as an isolated, non-recurring event. This is the fourth currency mechanism in roughly three years (SICAD 1, SICAD 2, SIMADI, now DICOM), and every single transition has produced its own re-measurement loss and its own real-estate impairment - a pattern predictable enough that continuing to treat each one as a discrete surprise, rather than disclosing a standing sensitivity analysis for the next inevitable devaluation, understates the risk to a reader who hasn't followed every prior filing.

Key Financial Metrics

Three months ended June 30, 2017 vs. three months ended June 30, 2016 - consolidated, reported in USD (MercadoLibre reports natively in dollars; no FX conversion is needed). MercadoLibre does not disclose an Adjusted EBITDA figure in this filing.

Metric Q2 2017 Q2 2016 YoY
Net revenues $316.5M $199.6M ✅ +58.6%
Cost of net revenues $(145.0)M $(73.3)M ⚠️ +97.7% - collection fees, sales taxes, and customer-support costs all rising with MercadoPago penetration
Gross profit (54.2% margin) $171.6M $126.3M (63.3% margin) ✅ +35.9%, margin -9.1pp
Product and technology development $(30.3)M $(24.2)M ⚠️ +25.3% - slower than revenue growth
Sales and marketing $(76.9)M $(35.3)M 🔴 +117.5% - portal deals, chargebacks, and buyer-protection-program costs all rising faster than revenue
General and administrative $(31.5)M $(20.8)M ⚠️ +51.2%
Impairment of long-lived assets $(2.8)M $(13.7)M ✅ -79.3% - a smaller Venezuela real-estate write-down than a year ago, though the underlying devaluation was far larger
Income from operations (9.5% margin) $30.0M $32.2M (16.1% margin) 🔴 -6.7%, margin -6.6pp
Foreign currency losses $(21.8)M $(5.4)M 🔴 The DICOM re-measurement loss described above
Blended tax rate 57.2% 43.8% 🔴 +13.4pp - the non-deductible Venezuela FX loss and Mexico's non-deductible pre-tax losses both compressed the tax base
Effective tax rate 118.5% 46.0% 🔴 +72.5pp, same drivers, now exceeding pre-tax income itself
Net income $5.3M $15.9M 🔴 -66.5%
Diluted EPS $0.12 $0.36 🔴 -66.7%
Operating cash flow ~$121.6M ~$56.7M ✅ +114.5%
Free cash flow» ~$105.6M ~$38.6M ✅ +173.7%
Cash, ST & LT investments (period end) $775.3M n/a Up 21.0% from $641.3M at December 31, 2016
Loans payable and other financial liabilities (period end) $324.9M n/a Almost entirely the $330M convertible notes

A 118.5% effective tax rate - a tax expense larger than pre-tax income itself - is the clearest single number showing how distorted this quarter's bottom line is relative to the underlying business: Mexico's losses generate no offsetting tax benefit, and Venezuela's FX loss isn't tax-deductible, so both problems hit net income without any tax cushion. Free cash flow, unaffected by either item, kept growing at triple-digit rates.

Key Operational Metrics

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

Metric Q2 2017 Q2 2016 YoY
Gross merchandise volume» (GMV, excludes motor vehicles/vessels/aircraft/real estate) $2,722.4M $2,004.7M ✅ +35.8%
Total payment volume» (TPV) $3,152.0M $1,816.9M ✅ +73.5%
Total volume of payments on marketplace $2,201.6M $1,335.4M ✅ +64.9%
Confirmed registered users (cumulative, period end) 191.2M 158.6M ✅ +20.6%
New confirmed registered users (in period) 9.0M 7.0M ✅ +28.6%
Items sold 61.5M 43.7M ✅ +40.7%
Items shipped 33.4M 20.4M ✅ +63.7%
Unique buyers 14.6M 11.9M ✅ +22.7%
Unique sellers 4.2M 3.7M ✅ +13.5%
Take rate» (net revenues / GMV) 11.63% 9.96% ✅ +1.67pp
TPV as % of GMV 115.8% 90.6% ✅ +25.2pp - TPV now exceeds GMV by a wider margin than Q1 2017's first-ever crossover

Every operational metric grew strongly this quarter - the currency shock and Mexico's losses are financial-statement-level problems, not signs of a slowing platform. TPV growing 73.5% against GMV's 35.8% continues the pattern this coverage has tracked since Q1 2017: MercadoPago's off-Marketplace payment and financing volume keeps outgrowing the Marketplace GMV that originally seeded it.

Five Country Segments - Two of the Portfolio's Strongest Segments Both Reversed

MercadoLibre reports the same five geographic segments adopted in Q3 2010 - Brazil, Argentina, Mexico, Venezuela, and Other Countries.

Segment Q2 2017 Revenue YoY Revenue Direct contribution margin, Q2 2017 Direct contribution margin, Q2 2016 Margin change
Brazil $180.1M ✅ +75.0% 33.3% 40.3% 🔴 -7.0pp
Argentina $88.0M ✅ +30.0% 43.5% 43.2% ⚠️ +0.3pp
Mexico $20.2M ✅ +75.7% -112.0% 19.7% 🔴 -131.7pp
Venezuela $14.2M ✅ +89.3% 39.7% -138.7% ✅ +178.4pp (both figures include impairment; ex-impairment: 59.2% vs. 45.3%, ✅ +13.9pp)
Other Countries $14.1M ✅ +39.6% 8.5% 29.6% 🔴 -21.1pp
Total $316.5M ✅ +58.6% 26.1% 32.9% 🔴 -6.8pp

Mexico's direct contribution turning to -$22.6 million on $20.2 million of revenue is, in dollar terms, the single largest segment-level deterioration this coverage has measured - a segment that used to be modestly profitable is now losing more than its own entire revenue base in direct costs. Brazil's reversal is smaller in magnitude but more concerning structurally, since it's the segment that carried FY2016's and Q1 2017's margin gains almost single-handedly; a reversal there removes the one consistent offsetting strength this coverage has been able to point to. Venezuela's headline margin actually improved sharply (+178.4pp) purely because this year's $2.8 million impairment is much smaller than last year's $13.7 million charge - stripping out impairment in both periods, Venezuela's underlying margin still improved (59.2% vs. 45.3%), a genuine result distinct from the accounting-driven headline swing.

Beyond the Usual

The convertible-note dilution-hedge gap widened again - the stock is now $95.12 above the cap price, up from $55.72 last quarter

Q1 2017's post flagged the stock trading $55.72 above the $155.78 cap price of the capped-call hedge protecting MercadoLibre's $330 million convertible notes from dilution. This quarter's continued rally (the stock closed at $250.90 on June 30, 2017, up another 18.6% from March) pushed that gap to $95.12 - the if-converted value of the notes now exceeds their principal by $327.0 million, up from $223.8 million last quarter.

This is the third consecutive filing this coverage has measured the same gap widening, purely from the stock's own continued appreciation: $0.36 above the cap at FY2016 year-end, $55.72 above it at Q1 2017, now $95.12 above it. Every dollar the stock climbs from here dilutes existing shareholders with no offsetting hedge protection whatsoever - a real, growing, and entirely predictable cost of the stock's own success that doesn't appear anywhere on the income statement.

The buyer protection program's disclosed maximum exposure is now 577 times its recorded reserve

This filing discloses, for the first time in this coverage, a specific dollar figure for MercadoLibre's buyer protection program (BPP) - a guarantee reimbursing buyers for undelivered or misrepresented items purchased through MercadoPago. As of June 30, 2017, management's own estimate of maximum potential BPP exposure is $564.2 million, against a recorded allowance of just $978 thousand - a ratio of roughly 577 to 1.

The Company does recover some of this exposure from third-party shipping carriers and, for high-volume sales events, from insurance contracts - so the $564.2 million figure is a ceiling, not an expected loss. But the sheer size of the gap between a maximum-exposure disclosure and the actual reserve is a genuinely interesting scale marker for how large MercadoLibre's implicit guarantee obligation has become as GMV and TPV have both grown into the billions.

A fourth Venezuelan currency-regime change in roughly three years followed the exact same script as the prior three

DICOM's introduction - a 3.6x devaluation from SIMADI's final rate, forcing a $22.0 million FX loss and a $2.8 million real-estate impairment - is mechanically identical to the pattern this coverage has tracked since Q2 2014's SICAD 2 shift: a forced re-measurement at a much weaker official rate, followed immediately by a review (and usually a write-down) of the same Caracas real estate. The carrying value of that real estate is now down to approximately $9.7 million, from over $50 million before the first devaluation this coverage tracked - a Venezuelan operation that keeps shrinking in dollar terms with each new currency regime, even as it remains, on an ex-impairment basis, one of the portfolio's highest-margin segments.

Coverage Table

Theme Q2 2017 Q2 2016 YoY Why it matters
Net revenue $316.5M $199.6M ✅ +58.6% Continuing acceleration despite a currency shock and Mexico's losses
Net income $5.3M $15.9M 🔴 -66.5% Almost entirely the $22.0M Venezuela FX loss plus Mexico's negative direct contribution
Free cash flow ~$105.6M ~$38.6M ✅ +173.7% Unaffected by either non-cash/non-deductible item weighing on net income
Mexico direct-contribution margin -112.0% +19.7% 🔴 -131.7pp Largest single-quarter segment deterioration in dollar terms this coverage has measured
Convertible-note cap-price gap Stock $95.12 above the $155.78 cap Stock $0.36 above the cap (FY2016 year-end) 🔴 Third straight filing this gap has widened purely on the stock's own rally

Target Valuation Range

DCF fair-value range: roughly $6,159 million (base case) to $12,284 million (bull case) enterprise value, against a $10,627.9 million actual enterprise value - inside the fair-value band, still closer to the bull case. Base case still shows a meaningful gap to enterprise value even as the stock keeps rallying; the bull case continues to clear enterprise value, though by a slightly narrower margin than last quarter as the price outran even free cash flow's own rapid growth this quarter.

The stock closed Q2 2017 at $250.88 (MercadoLibre has never split its common stock since its August 2007 IPO, so no split adjustment applies).

Market cap → enterprise value Q2 2017
Share price (period-end) $250.88
Shares outstanding 44,157,364
Market capitalization $11,078.2 million
Plus: loans payable $324.9 million
Less: cash & investments $775.3 million
Enterprise value $10,627.9 million

Enterprise value is up 19.1% from Q1 2017's ~$8,922.1 million. Trailing-twelve-month net revenue of $1,077.6 million is FY2016's $844.4 million, less H1 2016's $357.3 million, plus H1 2017's $590.5 million.

Valuation multiples Q1 2017 Q2 2017 Change
Enterprise value $8,922.1 million $10,627.9 million ⬆ up
EV/Sales 9.29x 9.86x ⬆ up
P/E (TTM) 60.4x 76.9x ⬆ up sharply (currency- and Mexico-depressed net income dragging the trailing figure down)
EV/FCF (TTM) 36.8x 34.4x ⬇ down (FCF kept growing faster than EV)
Scenario Key assumption Implied EV % of actual EV
Current (Q2 2017 close) actual market price $10,627.9 million 100%
Base Revenue growth 20%→10% over 5yrs; FCF margin 28.7%→32%; 13% discount, 4% terminal growth $6,159 million 58.0%
Bull Revenue growth 24/20/17/14/11%; FCF margin 32%→40%; 11% discount, 5% terminal growth $12,284 million 115.6%

Both cases are essentially flat versus Q1 2017's ~57.3% / ~116.5%.

Reverse DCF: holding the 13% discount rate and solving for the perpetual FCF growth rate that would justify today's $10,627.9 million enterprise value on the $309.3 million trailing FCF base gives roughly 9.8% growth, forever - down slightly from Q1 2017's ~10.0%, as enterprise value grew marginally faster than trailing free cash flow this quarter.

Whether Mexico's negative direct contribution stabilizes, worsens further, or gets a genuine operational response, and whether Brazil's margin reversal this quarter is a one-off or the start of a real trend, are the two clearest swing factors for this valuation gap heading into the second half of 2017.


MercadoLibre, Inc.'s Quarterly Report on Form 10-Q for the quarter ended June 30, 2017, filed with the U.S. Securities and Exchange Commission and signed August 4, 2017. Historical MELI share price data covers month-end closes from June 2015 through June 2017; 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.