Slide 1: Q4 FY16 Financial presentation to accompany management transcript
Q4 FY16 Financial presentation to accompany management transcript February 18, 2016
Slide 2: Wal-Mart Stores, Inc. consolidated results
Wal-Mart Stores, Inc. (Amounts in millions, except share data) Q4 $ Δ1 % Δ1 YTD $ Δ1 % Δ1 Total revenue $129,667 -$1,898 -1.4% $482,130 -$3,521 -0.7% Total revenue, constant $134,445 $2,880 2.2% $499,358 $13,707 2.8% currency2 Net sales $128,684 -$1,966 -1.5% $478,614 -$3,615 -0.7% Net sales, consta
Slide 3: Wal-Mart Stores, Inc. margins, tax rate and ROI
Wal-Mart Stores, Inc. Q4 bps Δ1 YTD bps Δ1 Gross profit rate 24.6% 48 bps 24.6% 29 bps Operating expenses as a percentage 20.2% 147 bps 20.3% 91 bps of net sales Effective tax rate 22.1% -745 bps 30.3% -189 bps Debt to total capitalization2 NP NP 38.3% 20 bps Return on investment3,4 NP NP 15.5% -140
Slide 4: Receivables, inventories and accounts payable
Wal-Mart Stores, Inc. (Amounts in millions) Q4 $ Δ1 % Δ1 Receivables, net $5,624 -$1,154 -17.0% Inventories $44,469 -$672 -1.5% Accounts payable $38,487 $77 0.2% 1 4 Change versus prior year comparable period
Slide 5: Cash flow, dividends and share repurchases
Wal-Mart Stores, Inc. (Amounts in millions) YTD $ Δ1 Operating cash flow $27,389 -$1,175 Capital expenditures $11,477 -$697 Free cash flow2 $15,912 -$478 (Amounts in millions) Q4 % Δ1 YTD % Δ1 Dividends $1,566 1.3% $6,294 1.8% Share repurchases3 $2,392 N/A $4,112 305.1% Total $3,958 156.0% $10,406 4
Slide 6: Walmart U.S.
Walmart U.S. (Amounts in millions) Q4 Δ1 YTD Δ1 Net sales $81,462 2.4% $298,378 3.6% Comparable store 0.6% -90 bps 1.2% 70 bps sales2 • Comp traffic 0.7% -70 bps NP NP • Comp ticket -0.1% -20 bps NP NP E-commerce impact3 ~0.3% NP NP NP Neighborhood Market4 7.0% NP NP NP Gross profit rate5 Increase 6
Slide 7: Walmart U.S. category comps
Walmart U.S. Category Comp Grocery1 + low single-digit General merchandise2 - low single-digit Health & wellness + low single-digit Apparel + low single-digit Home + low single-digit 1 Includes food and consumables 2 Includes entertainment, toys, hardlines and seasonal 7
Slide 8: Walmart International
Walmart International (Amounts in Constant Constant millions) Reported currency1 Reported currency1 1 Q4 Δ2 Q4 Δ2 YTD Δ2 YTD Δ2 Net sales $32,682 -9.7% $37,413 3.3% $123,408 -9.4% $140,488 3.2% Gross profit rate Increase 4 bps NP NP Increase 23 bps NP NP Operating $1,661 -19.0% $1,890 -7.8% $5,346 -
Slide 9: Walmart International country results
Walmart International 1,2 Comp3 Net Gross Country profit sales3 Sales Traffic Ticket rate3 United Kingdom4 -5.5% -5.7% 0.2% -4.4% Increase Walmex5 8.0% 1.2% 6.8% 9.3% Decrease Canada 4.3% 2.0% 2.3% 5.8% Decrease Brazil 0.8% -3.5% 4.3% 1.2% Decrease China -3.0% -8.5% 5.5% 0.3% Increase 1 Results are
Slide 10: Sam's Club
Sam's Club (Amounts in Without fuel1 With fuel Without fuel1 With fuel millions) Q4 Δ 2 Q4 Δ 2 YTD Δ 2 YTD Δ2 Net sales $13,637 -0.1% $14,540 -2.2% $52,330 1.4% $56,828 -2.1% Comparable club -0.5% -250 bps -2.7% -230 bps 0.4% -10 bps -3.0% -290 bps sales3 • Comp traffic -1.4% -290 bps NP NP NP NP NP
Slide 11: Sam's Club category comps
Sam's Club Category Comp Fresh / Freezer / Cooler - low single-digit Grocery and beverage - low single-digit Consumables + low single-digit Home and apparel + low single-digit Technology, office and entertainment - low single-digit Health and wellness + mid single-digit 11
Slide 12: Guidance
Guidance Total Walmart Sam's company FY17 Q1 EPS: U.S. comps 13-week period1: Club comps 13-week period1: • $0.80 - $0.95 • around 50 • around flat basis points Full Year EPS: • $4.00 - $4.30 1 13-week period from January 30, 2016 through April 29, 2016, compared to 13-week period ended May 1, 2015
Slide 13: FCPA and Compliance-Related Expenses
FCPA and Compliance-Related Expenses Q4 YTD (Amounts in millions) FY16 FY15 FY16 FY15 Ongoing inquiries and $25 $26 $95 $121 investigations Global compliance program and $8 $10 $31 $52 organizational enhancements Total $33 $36 $126 $173 • In fiscal year 2017, we expect our FCPA-related expenses to r
Slide 14: Additional resources at stock.walmart.com
Additional resources at stock.walmart.com • Reconciliations for our non-GAAP financial measures (ROI, free cash flow, constant currency, adjusted EPS, and Sam’s Club comparable measures) • Unit counts & square footage • Comparable store sales • Terminology • FY 17 earnings dates 14