Adjusted EPS Financial Overview

Made public by

sourced by PitchSend

1 of 37

Creator

Walmart logo
Walmart

Category

Financial

Published

Apr 30, 2023

Slides

Transcriptions

#1Financial presentation to accompany management commentary Q1 FY24#2Guidance The following guidance reflects the Company's expectations for the second quarter and fiscal year 2024 and is provided on a non-GAAP basis as the Company cannot predict certain elements that are included in reported GAAP results, such as the changes in fair value of the Company's equity and other investments. Growth rates reflect an adjusted basis for prior year results. Additionally, the Company's guidance assumes a generally stable consumer and continued pressure from its mix of products and formats globally. The Company's fiscal year guidance is based on the following previously disclosed FY23 figures: Net sales: $605.9 billion, adjusted operating income': $24.6 billion, adjusted EPS' $6.29. Metric Consolidated net sales (cc) Q2 Increase approximately 4.0% Consolidated operating income (cc) Adjusted EPS Decline approximately 2.0% $1.63 to $1.68 Metric Consolidated net sales (cc) Consolidated operating income (cc) Interest, net Effective tax rate Non-controlling interest Adjusted EPS Capital expenditures FY24 Increase approximately 3.5% Increase approximately 4.0%-4.5%, including an expected 100bps impact from LIFO Increase approximately $600M v. LY Approximately 26.5% Approximately $0.20 headwind to EPS v. LY $6.10 to $6.20, including an expected $0.14 impact from LIFO Flat to up slightly v. LY, unchanged from prior guidance 2 For relevant reconciliations, see Q4 FY23 earnings release furnished on Form 8-K on February 21, 2023. Our expectations are for Walmart U.S. and International to grow slightly faster than our prior view and for Sam's Club growth to be consistent with our February guidance CC Constant currency#3Sweetener Join Walmart Free delivery from this store Begin Total Revenue Total Revenue (cc)' $152.5 billion, up +7.7% $152.9 $152.8 $141.6 $164 $152.3 • • • Total revenue reached $152.3 billion with strength across all operating segments Negatively affected by $0.2 billion from currency fluctuations eCommerce net sales up 26% globally led by omnichannel, including pickup and delivery Q1 FY23 Q2 FY23 Q3 FY23 Q4 FY23 Q1 FY24 • Strong growth in membership income, globally Y/Y Change +2.4% +8.4% +8.7% +7.3% +7.6% • Y/Y Change (cc) +2.6% +9.1% +9.8% +7.9% +7.7% Other income negatively affected by a decline in sustainability income Walmart+ 'See additional information at the end of this presentation regarding non-GAAP financial measures.#4YOUNG MEN Women's Apparel Gross Profit Rate Gross Profit Rate -18bps to 23.7% 23.8% 23.7% 23.7% 23.5% 22.9% Q1 FY23 Q2 FY23 Q3 FY23 Q4 FY23 Q1 FY24 Y/Y Change -87bps -132bps -89bps -83bps -18bps • Gross profit rate declined primarily due to mix of sales globally, partially offset by normalization of supply chain and freight costs in the U.S., and favorable business mix from higher margin initiatives Sales mix negatively affected by a shift from general merchandise to grocery and health & wellness, including nearly 360 bps shift in Walmart U.S.#5Pharmacy 12:524 Store Assistant Search online and stores W+Kayia Member since March 2020 Mobile scan & go Check out as you shop to make store shopping fast & contact-free. See all your benefits Your store: 1501 S Range Line Rd NEW Go to map Hours and info !!! Lists [*] Walmart Pay Item Finder Γ [U] Price check Scan codes 7 D: Start Shop Services My Items Cart LTE [] Operating Expenses As a percentage of net sales, -58bps to 20.4% 22.8% 20.4% 19.9% 20.3% 21.0% اس Y/Y Change Q1 FY23 +45bps Q2 FY23 -45bps Q3 FY23 +144bps Q4 FY23 -44bps Q1 FY24 -58bps • Leverage driven by strong net sales growth and operating discipline#6Operating Income 5.3 Operating Income 6.9 2.7 5.6 6.2 5.3 Adjusted Operating Income' 6.9 6.4 6.2 6.0 Q1 FY24 • • • Operating income up 17.3% relative to 7.6% growth in net sales Net income margin decreased ~40bps and EBITDA margin' increased ~30bps over last year Q3 FY23 and Q4 FY23 negatively affected by discrete charges of $3.3B and $0.8B, respectively, associated with the opioid legal settlement frameworks, and business reorganization and restructurings Q1 FY23 Q2 FY23 Q3 FY23 Q4 FY23 Q1 FY24 Q1 FY23 Q2 FY23 Q3 FY23 Q4 FY23 Y/Y Change Y/Y Change (cc)' -23.0% -22.7% -6.8% -53.5% -5.5% +17.3% -6.0% -52.8% -6.5% +16.0% Y/Y Change Y/Y Change (cc) -23.0% -6.8% +3.9% +6.9% +17.3% -22.7% -6.0% +4.6% +6.3% +16.0% 'See additional information at the end of this presentation regarding non-GAAP financial measures.#7EPS Adjusted EPS' of $1.47, up 13.1% $0.74 $1.88 EPS $2.32 $0.62 $1.30 $1.77 Adjusted EPS¹ $1.71 $1.50 $1.47 Q1 FY23 Q2 FY23 Q3 FY23 Q4 FY23 Q1 FY24 $(0.66) Q1 FY23 Q2 FY23 Q3 FY23 Q4 FY23 Q1 FY24 PY $1.69 $1.78 $1.45 $1.53 $1.30 Y/Y Change -23.7% +23.7% NM +81.3% -16.2% Y/Y Change -23.1% -0.6% +3.4% +11.8% +13.1% 'See additional information at the end of this presentation regarding non-GAAP financial measures. NM = not meaningful • Adjusted EPS excludes the effects of $0.85 from net losses on equity and other investments#8Cash Flow Amounts in billions, except as noted. Dollar changes may not recalculate due to rounding. $(3.8) Operating Cash Flow $9.2 $15.7 $28.8 Free Cash Flow¹ $1.7 $4.6 $3.6 $12.0 Q1 FY23 YTD Q2 FY23 YTD Q3 FY23 YTD Q4 FY23 YTD Q1 FY24 YTD $(7.3) Q1 FY23 YTD Q2 FY23 YTD Q3 FY23 YTD Q4 FY23 YTD $0.2 Q1 FY24 YTD PY $2.9 $12.4 $16.3 $24.2 $(3.8) PY $0.6 $7.4 $7.7 $11.1 $(7.3) Y/Y Change NM -25.6% -3.6% +19.3% NM Y/Y Change NM -76.4% -52.8% +8.2% NM 'See additional information at the end of this presentation regarding non-GAAP financial measures. NM not meaningful • Operating cash flow increased primarily due to moderated levels of inventory purchases and timing of certain payments Free cash flow increased due to the improvement in operating cash flow, partially offset by an increase of $0.9B in capital expenditures to support the company's growth strategy#9FRESH FR Walmart GAIL Returns to Shareholders Through dividends and share repurchases Amounts in billions, except as noted. Dollar changes may not recalculate due to rounding. $3.3 $3.0 $2.4 $1.2 $0.7 $1.5 $1.5 $1.5 $1.5 $1.5 Q1 FY23 Q2 FY23 Q3 FY23 Q4 FY23 Q1 FY24 Dividends Share Repurchase Returns to $4.0 $4.9 $4.5 $2.7 $2.2 Shareholders • Share repurchases during quarter totaled $686 million representing 4.8 million shares at an average price of $143.46 per share Remaining share repurchase authorization is $18.6 billion#10Returns Return on Assets (ROA) 5.5% 5.8% 3.7% 4.6% 4.5% Return on Investment (ROI)' 13.9% 13.8% 12.8% 12.7% 12.7% Q1 FY23 Q2 FY23 Q3 FY23 Q4 FY23 Q1 FY24 Q1 FY23 Q2 FY23 Q3 FY23 Q4 FY23 Q1 FY24 Y/Y Change +20bps +140bps +40bps -100bps -100bps Y/Y Change -50bps -100bps -170bps -220bps -120bps 'See additional information at the end of this presentation regarding non-GAAP financial measures. • ROI declined on a trailing 12-month basis as a result of discrete charges for the opioid legal settlement frameworks in Q3 FY23 and business reorganization and restructurings in Q4 FY23 Discrete charges totaled 140 bps headwind to ROI#11Walmart U.S. Comp Sales Net Sales +7.2%, eCommerce +27% 3.0% 6.5% 8.2% 8.3% ill Q1 FY23 Q2 FY23 Q3 FY23 7.4% Q4 FY23 Q1 FY24 eCommerce Contribution ~-30bps ~100bps ~80bps ~140bps ~270bps • • • • Comp sales +7.4% with strength in grocery and health & wellness, offset by softness in general merchandise Monthly comp sales growth moderated as the quarter progressed Strength in food categories, private brand sales, and higher average ticket and store transactions Strong market share gains in grocery, including higher-income households Strong growth for eCommerce in store-fulfilled pickup and delivery as well as nearly 40% growth in advertising 'Comp sales for the 13-week period ended April 28, 2023 compared to the 13-week period ended April 29, 2022, and excludes fuel. MEN#12Gross profit rate -41 bps · • Unfavorable product mix shifts as grocery and health & wellness, which have a lower margin rate than general merchandise, increased nearly 360 bps as a portion of sales mix • Partly offset by lower supply chain and freight costs Operating expenses as a percentage of net sales -65 bps Aided by strong net sales growth • Also, lapping last year's COVID-related wage expenses Continued investment in associates; raised average wage to $17.50 per hour in February Operating income $5.0 billion, +11.7% • ⚫ Operating expense leverage and membership income growth, partially offset by a decline in the gross profit rate Inventory -9.4% • Better efficiency and merchandise flow; in-stock levels improved versus last year Walmart U.S. Store Remodels: 96 Pickup: >4,600 stores Delivery from Store: >3,900#13Walmart U.S. Merchandise category performance details Category Comp Grocery +low double-digit Health & Wellness + high teens General Merchandise - mid single-digit • Comments Strength in food (+LDD) reflected continued market share gains (according to Nielsen), including from higher income households, and growth in private brand penetration (+110bps) Food inflation increased +LDD in Q1 and was up +mid-20s on a two-year stack Food units sold increased year-over-year Consumables led by strength in pet and personal care products due in part to inflation Strong pharmacy sales reflected increased script counts, higher mix of branded versus generic prescriptions, strength in immunizations, and branded drug inflation W+ General merchandise sales reflected softness in discretionary categories including home, electronics and apparel Automotive and seasonal performed well THERMOKING,#14CUMA eneficios Bodega Aur Walmart International Net Sales en Net Sales (cc) $26.8 billion, +12.9% CUMULA COMPRAS Alcanza -Encuentr de artículos Paga mo quieras Pickup Bodega Aurrera en ned Compra aquí -=Recibe donde quieras Net sales $25.3 $24.4 $23.8 $27.6 $26.6 • Q1 FY24 • Strong sales growth (cc) led by double digit growth in China, Walmex and Flipkart eCommerce sales grew 25% with particular strength in store-fulfilled and advertising Sales negatively affected by $0.2 billion due to currency rate fluctuations Q1 FY23 Q2 FY23 Q3 FY23 Q4 FY23 urrera en linea Y/Y Change -13.0% +5.7% +7.1% +2.1% +12.0% Net Sales (cc) 1,2 $23.8 $25.3 $26.8 $28.5 $26.8 spens a tu cas Y/Y Change (cc)' -11.6% +9.9% +13.3% +5.5% +12.9% tu ped O 5463 22 BodegaAurrer 'See additional information at the end of this presentation regarding non-GAAP financial measures. 2For Q1 FY23, net sales constant currency reflects reported results for comparison to current quarter growth in constant currency.#15Walmart International Strong local businesses powered by Walmart Gross profit rate +12 bps • Increase primarily due to lapping higher markdowns from slower sales growth last year • Partially offset by ongoing format and channel mix changes • Operating expenses as a percentage of net sales -111 bps Leverage driven by strong sales growth driving fixed cost leverage across most markets . Strong operating efficiencies • Operating income $1.2 billion, +50.8%; $1.1 billion (cc)', +41.5% 41.5% increase driven by widespread growth as all markets improved operating income Inventory +1.7% 'See additional information at the end of this presentation regarding non-GAAP financial measures.#16E Value Great 12 AGUA 100% PODR TERMINAL B CAJERO Walmex¹,2 Net Sales (cc): $10.1 billion, +10.6% Comparable sales growth 9.2% 11.5% 11.7% 10.6% 9.3% Q1 FY23 Q2 FY23 Q3 FY23 Q4 FY23 Q1 FY24 Net sales growth +10.4% +12.7% +12.9% +11.8% +10.6% eCommerce net sales growth +19% +17% +17% +14% +17% Sales Double-digit growth with continued strength in food and consumables In Mexico, comp sales grew 8.7% driven by Sam's Club and Bodega Opened more than 120 new stores in the past twelve months, including 12 new stores in the quarter Gross profit rate Increase • Primarily from efficiencies in logistics and lower imports costs Operating expense rate Increase • Primarily due to planned investments in associates and strategic priorities Operating income $ Increase 'Walmex includes the consolidated results of Mexico and Central America Results are presented on a constant currency basis. Net sales and comparable sales are presented on a nominal, calendar basis and include eCommerce results. Change is calculated as the change versus the prior year comparable period.#17Produce Freat Every Day Canada' Net Sales (cc): $5.5 billion, +6.7% Vilitar Villitá ° 6416 Wal Comparable sales growth 7.7% 10.3% 5.2% 6.3% 5.7% ilm Sales Continued momentum in food and consumables with softness in GM Continued strength in private brands which grew over 7% year over year Gross profit rate Relatively flat Primarily from efficiencies in logistics and lower import costs offset by category mix impact Operating expense rate Relatively flat Driven by balanced expense • management in line with sales growth Q1 FY23 Q2 FY23 Q3 FY23 Q4 FY23 Q1 FY24 Operating income $ Increase Net sales growth +6.9% +10.0% +5.5% +5.9% +6.7% eCommerce net -4% -9% +3% -3% -2% sales growth Results are presented on a constant currency basis. Net sales and comparable sales are presented on a nominal, calendar basis and include eCommerce results. Change is calculated as the change versus the prior year comparable period.#18Benefits 微信扫码了解更多 Scan QR Code To Learn More 2% 【购物返利 请咨询我 INTARRY 卓越个人会员卡 Premium Advantage Member 年費680元 内含:主卡1张、亲友卡1张 Annual fee of 680 yvan, 内容: An Which includes one primary cord Which and one complementary cord and 卓越商业会员卡 Premium Business Member 年费680元 内含:主卡1张、公司卡1张 Annual fee of 680 yuan, Which includes one primary card and one company card 街电 123 LAN Sam's KE CLUB China¹ Net Sales (cc): $5.3 billion, +28.3% 14.1% Comparable 5.6% sales growth 4.4% 13.3% 25.5% Q1 FY23 Q2 FY23 Q3 FY23 Q4 FY23 Q1 FY24 Net sales growth +7.2% +15.9% +6.9% +13.5% +28.3% eCommerce net sales growth +89% +77% +63% +70% +54% Sales • • Strength in both formats and eCommerce Post-covid reopening helped fuel a strong Chinese New Year season and sustained momentum through the entire quarter Members Mark private brand was particularly strong, growing 46% • eCommerce penetration at 40% Gross profit rate Increase • Lapping higher markdowns from slower sales growth last year, partially offset by higher mix of Sam's Club and eCommerce sales Operating expense rate Decrease • Driven by strong sales growth, operational efficiencies, and higher penetration of Sam's Club Operating income $ Increase Results are presented on a constant currency basis. Net sales and comparable sales are presented on a nominal, calendar basis and include eCommerce results. Change is calculated as the change versus the prior year comparable period.#19Sam's Club Comp Sales' 1 Net sales with fuel +4.5%, Net sales without fuel +7.4%, eCommerce +19% 17.5% 17.0% 12.7% 11.9% 12.2% • 10.2% 9.5% 10.0% 4.2% 7.0% Comparable sales Strong comp sales driven by solid increases in ticket and transactions as well as unit growth о Ticket without fuel +4.0% • Q1 FY23 Q2 FY23 Q3 FY23 Q4 FY23 Q1 FY24 With fuel Without fuel eComm Cont. without fuel ~150bps ~170bps ~120bps ~120bps ~160bps • о Transactions without fuel +2.9% Strength led by food and consumables eCommerce +19%, led by curbside Scan & Go penetration increased more than 600 bps y/y 'Comp sales for the 13-week period ended April 28, 2023 compared to the 13-week period ended April 29, 2022. GARDENOI New Holds an er Thickp yuk & Year Resistant Member's Mark. NEW LONGER BAG 4 ECIPE 28 g) POUNDDS 200 Pr all Kitchen Bags 28 CIPE POUNDS Member's Mark CHICKEN BROT 6.PACK#20• Gross profit rate +36 bps, without fuel +26 bps Rate increase primarily due to lapping elevated supply chain costs last year LIFO expense $48M Operating expenses as a percentage of net sales +47 bps, without fuel +23 bps • Lower fuel sales negatively affected expense leverage Without fuel, deleverage primarily due to elevated technology investments Membership income +6.3% • Continued strength primarily due to Plus membership growth, acquisitions, and renewals • Membership count and Plus penetration reached all-time highs in the quarter Operating income $458M, -0.4%, without fuel $354M, +5.7% Sam's Club Celebrating 40 years of Member Obsession • LIFO reduced operating income by 10.0% y/y Inventory -6.0% • Better inventory efficiency and merchandise flow as well as a LIFO reserve adjustment#21Sam's Club Category comparable sales Category Comp Fresh/Freezer / Cooler +high single-digit Grocery and Beverage +low double-digit • Consumables +low double-digit Home and Apparel - low single-digit Technology, Office and Entertainment low double-digit Health and Wellness + mid-teens • 100 C Comments Cooler, prepared foods, produce & floral, and bakery performed well Drinks, dry grocery, and snacks showed strength Paper goods, tabletop & bags, laundry & home care, and pet supplies performed well Softness in outdoor living, toys and sporting goods, partially offset by strength in tires, auto, and apparel Softness in consumer electronics, partially offset by strength in gift cards Pharmacy and over the counter performed well NEW LOOK SAME GREAT SNACKS! MMember's Mark FIOITY SMACKS NATURALLY & ARTIFICIALLY FLAVORED FRUIT FLAVORED SNACKS Member's Mark ORANGE EN Member's Mark 2.5 SALIFORNIA ALMONDS ROT S PULLED CHICKEN sam's club> Orange SO#22Safe harbor and non-GAAP measures This presentation and related management commentary contains statements that may be "forward-looking statements" as defined in, and are intended to enjoy the protection of the safe harbor for forward- looking statements within the meaning of Section 21E of the Securities Exchange Act of 1934, as amended. Assumptions on which such forward-looking statements are based are also forward-looking statements. Our actual results may differ materially from those expressed in or implied by any of these forward-looking statements as a result of changes in circumstances, assumptions not being realized or other risks, uncertainties and factors including: the impact of the COVID-19 pandemic on our business and the global economy; economic, capital markets and business conditions; trends and events around the world and in the markets in which we operate; currency exchange rate fluctuations, changes in market interest rates and market levels of wages; changes in the size of various markets, including eCommerce markets; unemployment levels; inflation or deflation, generally and in particular product categories; consumer confidence, disposable income, credit availability, spending levels, shopping patterns, debt levels and demand for certain merchandise; the effectiveness of the implementation and operation of our strategies, plans, programs and initiatives; unexpected changes in our objectives and plans; the impact of acquisitions, investments, divestitures, store or club closures, and other strategic decisions; our ability to successfully integrate acquired businesses, including within the eCommerce space; changes in the trading prices of certain equity investments we hold; initiatives of competitors, competitors' entry into and expansion in our markets, and competitive pressures; customer traffic and average ticket in our stores and clubs and on our eCommerce websites; the mix of merchandise we sell, the cost of goods we sell and the shrinkage we experience; trends in consumer shopping habits around the world and in the markets in which we operate; our gross profit margins; the financial performance of Walmart and each of its segments, including the amounts of our cash flow during various periods; changes in the credit ratings assigned to our commercial paper and debt securities by credit rating agencies; the amount of our net sales and operating expenses denominated in the U.S. dollar and various foreign currencies; transportation, energy and utility costs; commodity prices and the price of gasoline and diesel fuel; supply chain disruptions and disruptions in seasonal buying patterns; the availability of goods from suppliers and the cost of goods acquired from suppliers; consumer acceptance of and response to our stores, clubs, eCommerce platforms, programs, merchandise offerings and delivery methods; cyber security events affecting us and related costs and impact to the business; developments in, outcomes of, and costs incurred in legal or regulatory proceedings to which we are a party or are subject, and the liabilities, obligations and expenses, if any, that we may incur in connection therewith; casualty and accident-related costs and insurance costs; the turnover in our workforce and labor costs, including healthcare and other benefit costs; consumer enrollment in health and drug insurance programs and such programs' reimbursement rates and drug formularies; our effective tax rate and the factors affecting our effective tax rate, including assessments of certain tax contingencies, valuation allowances, changes in law, administrative audit outcomes, impact of discrete items and the mix of earnings between the U.S. and Walmart's international operations; changes in existing tax, labor and other laws and regulations and changes in tax rates including the enactment of laws and the adoption and interpretation of administrative rules and regulations; the imposition of new taxes on imports, new tariffs and changes in existing tariff rates; the imposition of new trade restrictions and changes in existing trade restrictions; adoption or creation of new, and modification of existing, governmental policies, programs, initiatives and actions in the markets in which Walmart operates and elsewhere and actions with respect to such policies, programs and initiatives; changes in accounting estimates or judgments; the level of public assistance payments; natural disasters, changes in climate, geopolitical events and catastrophic events; and changes in generally accepted accounting principles in the United States. Our most recent annual report on Form 10-K filed with the SEC discusses other risks and factors that could cause actual results to differ materially from those expressed or implied by any forward-looking statement in the presentations. We urge you to consider all of the risks, uncertainties and factors identified above or discussed in such reports carefully in evaluating the forward-looking statements in this release. Walmart cannot assure you that the results reflected in or implied by any forward-looking statement will be realized or, even if substantially realized, that those results will have the forecasted or expected consequences and effects for or on our operations or financial performance. The forward-looking statements made in the presentation are as of the date of this meeting. Walmart undertakes no obligation to update these forward-looking statements to reflect subsequent events or circumstances. This presentation includes certain non-GAAP measures as defined under SEC rules, including net sales, revenue, and operating income on a constant currency basis, adjusted EPS, free cash flow, return on investment, and EBITDA and EBITDA margin. Refer to information about the non-GAAP measures contained in this presentation. Additional information as required by Regulation G and Item 10(e) of Regulation S-K regarding non-GAAP measures can be found in our most recent Form 10-K and our Form 8-K furnished as of the date of this presentation with the SEC, which are available at stock.walmart.com.#23Non-GAAP measures - ROI We include Return on Assets ("ROA"), which is calculated in accordance with U.S. generally accepted accounting principles ("GAAP") as well as Return on Investment ("ROI") as measures to assess returns on assets. Management believes ROI is a meaningful measure to share with investors because it helps investors assess how effectively Walmart is deploying its assets. Trends in ROI can fluctuate over time as management balances long-term strategic initiatives with possible short-term impacts. We consider ROA to be the financial measure computed in accordance with GAAP that is the most directly comparable financial measure to our calculation of ROI. ROA was 4.5% percent and 5.5% percent for the trailing twelve months ended April 30, 2023 and 2022, respectively. The decrease in ROA was primarily due to the decrease in net income, which was driven by lower operating income, partially offset by lapping debt extinguishment charges. ROI was 12.7% and 13.9% for the trailing 12 months ended April 30, 2023 and 2022, respectively. The decrease in ROI was primarily due to the decrease in operating income which included opioid legal charges and reorganization and restructuring charges recorded in Q3 and Q4 of fiscal 2023. We define ROI as operating income plus interest income, depreciation and amortization, and rent expense for the trailing twelve months divided by average invested capital during that period. We consider average invested capital to be the average of our beginning and ending total assets, plus average accumulated depreciation and average amortization, less average accounts payable and average accrued liabilities for that period. Our calculation of ROI is considered a non-GAAP financial measure because we calculate ROI using financial measures that exclude and include amounts that are included and excluded in the most directly comparable GAAP financial measure. For example, we exclude the impact of depreciation and amortization from our reported operating income in calculating the numerator of our calculation of ROI. As mentioned above, we consider ROA to be the financial measure computed in accordance with generally accepted accounting principles most directly comparable to our calculation of ROI. ROI differs from ROA (which is consolidated net income for the period divided by average total assets for the period) because ROI: adjusts operating income to exclude certain expense items and adds interest income; adjusts total assets for the impact of accumulated depreciation and amortization, accounts payable and accrued liabilities to arrive at total invested capital. Because of the adjustments mentioned above, we believe ROI more accurately measures how we are deploying our key assets and is more meaningful to investors than ROA. Although ROI is a standard financial measure, numerous methods exist for calculating a company's ROI. As a result, the method used by management to calculate our ROI may differ from the methods used by other companies to calculate their ROI.#24Non-GAAP measures - ROI (cont.) The calculation of ROA and ROI, along with a reconciliation of ROI to the calculation of ROA, is as follows: (Dollars in millions) CALCULATION OF RETURN ON ASSETS Apr 30, Jul 31, Trailing Twelve Months Ending Oct 31, Jan 31, Apr 30, 2022 2022 2022 2023 2023 Numerator Consolidated net income $ 13,232 $ 14,015 $ 9,116 $ 11,292 $ 11,085 Denominator Average total assets' Return on assets (ROA) $ 241,362 5.5 % $ 242,876 $ 246,254 5.8 % $ 244,029 $ 245,598 3.7 % 4.6 % 4.5 % Certain Balance Sheet Data April 30, 2021 Jul 31, 2021 Oct 31, 2021 Jan 31, 2022 April 30, 2022 Jul 31, 2022 Oct 31, 2022 Jan 31, April 30, 2023 2023 Total assets $ 236,581 $ 238,552 $ 244,851 $ 244,860 $ 246,142 Accumulated depreciation and amortization 96,334 98,346 Accounts payable 48,151 49,601 Accrued liabilities 21,371 23,915 100,168 57,156 24,474 102,211 104,295 $ 247,199 105,963 $ 247,656 $ 243,197 $ 245,053 107,628 110,286 113,164 55,261 52,926 54,191 57,263 53,742 54,268 26,060 21,061 23,843 27,443 31,126 27,527 1The average is based on the addition of the account balance at the end of the current period to the account balance at the end of the prior period and dividing by 2#25Non-GAAP measures - ROI (cont.) The calculation of ROA and ROI, along with a reconciliation of ROI to the calculation of ROA, is as follows: (Dollars in millions) Numerator Operating income + Interest income + Depreciation and amortization + Rent ROI operating income CALCULATION OF RETURN ON INVESTMENT Apr 30, Jul 31, Trailing Twelve Months Ending Oct 31, Jan 31, Apr 30, 2022 2022 2022 2023 2023 Denominator Average total assets' + Average accumulated depreciation and amortization 1 - Average accounts payable - Average accrued liabilities' Average invested capital Return on investment (ROI) $ 24,351 163 23,851 155 20,754 20,428 21,350 196 254 323 10,679 $ 2,270 37,463 10,733 2,302 $ 37,041 10,840 10,945 11,110 2,296 $ 34,086 $ 2,306 33,933 2,301 $ 35,084 $ 241,362 $ 242,876 100,315 102,155 $ 246,254 103,898 $ 244,029 245,598 106,249 108,730 50,539 21,216 51,896 57,210 54,502 53,597 23,878 25,959 28,593 24,294 $ 269,922 $ 269,257 $ 266,983 267,183 276,437 13.9 % 13.8 % 12.8 % 12.7 % 12.7 % The average is based on the addition of the account balance at the end of the current period to the account balance at the end of the prior period and dividing by 2#26Non-GAAP measures - - free cash flow We define free cash flow as net cash provided by or used in operating activities in a period minus payments for property and equipment made in that period. Net cash provided by operating activities was $4.6 billion for the three months ended April 30, 2023, which represents an increase of $8.4 billion when compared to the same period in the prior year. The increase is primarily due to moderated levels of inventory purchases and timing of certain payments. Free cash flow for the three months ended April 30, 2023 was $0.2 billion, which represents an increase of $7.5 billion when compared to the same period in the prior year. The increase in free cash flow is due to the increase in operating cash flows described above, partially offset by an increase of $0.9 billion in capital expenditures to support our investment strategy. Free cash flow is considered a non-GAAP financial measure. Management believes, however, that free cash flow, which measures our ability to generate additional cash from our business operations, is an important financial measure for use in evaluating the Company's financial performance. Free cash flow should be considered in addition to, rather than as a substitute for, consolidated net income as a measure of our performance and net cash provided by operating activities as a measure of our liquidity. Additionally, Walmart's definition of free cash flow is limited, in that it does not represent residual cash flows available for discretionary expenditures, due to the fact that the measure does not deduct the payments required for debt service and other contractual obligations or payments made for business acquisitions. Therefore, we believe it is important to view free cash flow as a measure that provides supplemental information to our Condensed Consolidated Statements of Cash Flows. Although other companies report their free cash flow, numerous methods may exist for calculating a company's free cash flow. As a result, the method used by Walmart's management to calculate our free cash flow may differ from the methods used by other companies to calculate their free cash flow.#27Non-GAAP measures free cash flow (cont.) - The following table sets forth a reconciliation of free cash flow, a non-GAAP financial measure, to net cash provided by operating activities, which we believe to be the GAAP financial measure most directly comparable to free cash flow. (Dollars in millions) Net cash provided by (used in) operating activities Payments for property and equipment (capital expenditures) Free cash flow (Dollars in millions) Net cash provided by (used in) operating activities Payments for property and equipment (capital expenditures) Free cash flow Y/Y Change in Free Cash Flow NM = not meaningful Year to Date Period Ended Q1 FY23 Q2 FY23 Q3 FY23 Q4 FY23 Q1 FY24 (3,758) $ $ (3,539) (7,297) $ 9,240 $ (7,492) 1,748 $ 15,698 $ (12,061) 3,637 $ 28,841 $ (16,857) 11,984 $ 4,633 (4,429) 204 Year to Date Period Ended Q1 FY22 Q2 FY22 Q3 FY22 Q4 FY22 Q1 FY23 2,858 $ 12,423 $ (2,214) (5,019) 16,291 $ (8,588) 24,181 $ (3,758) (13,106) (3,539) 644 $ 7,404 $ 7,703 $ 11,075 $ (7,297) NM -76.4% -52.8% +8.2% NM#28Non-GAAP measures constant currency - In discussing our operating results, the term currency exchange rates refers to the currency exchange rates we use to convert the operating results for countries where the functional currency is not the U.S. dollar into U.S. dollars. We calculate the effect of changes in currency exchange rates as the difference between current period activity translated using the current period's currency exchange rates and the comparable prior year period's currency exchange rates. Additionally, no currency exchange rate fluctuations are calculated for non-USD acquisitions until owned for 12 months. Throughout our discussion, we refer to the results of this calculation as the impact of currency exchange rate fluctuations. When we refer to constant currency operating results, this means operating results without the impact of the currency exchange rate fluctuations. The disclosure of constant currency amounts or results permits investors to better understand Walmart's underlying performance without the effects of currency exchange rate fluctuations. The table below reflects the calculation of constant currency for net sales for the Walmart International segment for the trailing five quarters and operating income for the current quarter. (Dollars in millions) Net sales: As reported Currency exchange rate fluctuations Net sales (cc) PY Reported % change (cc) Operating income: As reported Currency exchange rate fluctuations Operating income (cc) PY Reported % change (cc) Q1 FY23 Three Months Ended Walmart International Q2 FY23 Q3 FY23 Q4 FY23 Q1 FY24 23,763 $ 376 24,139 $ 24,350 $ 956 25,306 $ 25,295 $ 1,473 26,768 $ 27,575 $ 901 28,476 $ 26,604 226 26,830 $ 27,300 $ 23,035 $ 23,627 $ 26,997 $ 23,763 -11.6% +9.9% +13.3% +5.5% +12.9% $ 1,164 (72) $ 1,092 $ 772 +41.5%#29Non-GAAP measures – constant currency (cont.) - - The table below reflects the calculation of constant currency for total revenues, net sales and operating income for the trailing five quarters. (Dollars in millions) Total Revenue: Q1 FY23 Q2 FY23 Three Months Ended Consolidated Q3 FY23 Q4 FY23 Q1 FY24 141,569 $ 377 141,946 $ 152,859 $ 996 153,855 $ 152,813 $ 1,491 154,304 $ 164,048 $ 917 164,965 152,301 230 152,531 $ 138,310 $ +2.6% 141,048 $ +9.1% 140,525 $ +9.8% 152,871 $ +7.9% 141,569 +7.7% As reported Total Revenue (cc) $ Currency exchange rate fluctuations PY Reported % change (cc) Net sales: As reported $ 140,288 $ Currency exchange rate fluctuations 376 Net sales (cc) $ 140,664 $ 151,381 $ 956 152,337 $ 151,469 $ 1,473 152,942 $ 162,743 $ 901 163,644 $ 151,004 226 151,230 PY Reported $ 137,159 $ 139,871 $ % change (cc) +2.6% +8.9% 139,207 $ +9.9% 151,525 $ 140,288 +8.0% +7.8% Operating income: As reported $ 5,318 $ 6,854 $ 2,695 $ 5,561 $ 6,240 Currency exchange rate fluctuations 20 62 38 (57) (72) Operating income (cc) 5,338 $ 6,916 $ 2,733 $ 5,504 $ 6,168 PY Reported $ 6,909 $ 7,354 $ 5,792 $ 5,887 $ 5,318 % change (cc) -22.7% -6.0% -52.8% -6.5% +16.0%#30Non-GAAP measures - Adjusted Operating Income Adjusted operating income is considered a non-GAAP financial measure under the SEC's rules because it excludes certain charges included in operating income calculated in accordance with GAAP. Management believes that adjusted operating income is a meaningful measure to share with investors because it best allows comparison of the performance with that of the comparable period. In addition, adjusted operating income affords investors a view of what management considers Walmart's core earnings performance and the ability to make a more informed assessment of such core earnings performance as compared with that of the prior year. When we refer to adjusted operating income in constant currency, this means adjusted operating results without the impact of the currency exchange rate fluctuations. The disclosure of constant currency amounts or results permits investors to better understand Walmart's underlying performance without the effects of currency exchange rate fluctuations. The table below reflects the calculation of adjusted operating income and adjusted operating income in constant currency, when applicable, for the trailing five quarters. Three Months Ended (Dollars in millions) Q1 FY23 Q1 FY22 Q2 FY23 Q2 FY22 Q3 FY23 Q3 FY22 Q4 FY23 Q4 FY22 Q1 FY24 Q1 FY23 Operating income: Operating income, as reported $ 5,318 $ 6,909 $ 6,854 $ 7,354 $ 2,695 $ 5,792 $ Business reorganization and restructuring charges¹ 5,561 $ 849 5,887 108 $ 6,240 $ 5,318 Opioid legal charges² 3,325 Adjusted operating income $ 5,318 6,909 $ Percent change³ -23.0% NP Currency exchange rate fluctuations $ 20 6,854 -6.8% 62 7,354 NP $ 6,020 5,792 $ 6,410 5,995 6,240 $ 5,318 +3.9% NP +6.9% NP 38 Adjusted operating income, constant currency Percent change³ $ 5,338 $ -22.7% 6,909 $ NP 6,916 $ -6.0% 7,354 $ NP 6,058 $ +4.6% 5,792 $ (39) 6,371 $ +17.3% (72) NP 5,995 $ 6,168 $ 5,318 NP +6.3% NP +16.0% NP 'Business reorganization and restructuring charges in the fourth quarter of fiscal 2023 primarily relate to compensation expenses incurred in connection with the strategic decisions made in the Walmart International segment. Business restructuring charges in the fourth quarter of fiscal 2022 primarily consist of severance and store closure related costs due to strategic decisions made in the Walmart International segment. 2 The opioid legal charges are recorded in Corporate and support. 3 Change versus prior year comparable period. NP not provided#31Non-GAAP measures - adjusted EPS Adjusted diluted earnings per share attributable to Walmart (Adjusted EPS) is considered a non-GAAP financial measure under the SEC's rules because it excludes certain amounts included in the diluted earnings per share attributable to Walmart calculated in accordance with GAAP (EPS), the most directly comparable financial measure calculated in accordance with GAAP. Management believes that Adjusted EPS is a meaningful measure to share with investors because it best allows comparison of the performance with that of the comparable period. In addition, Adjusted EPS affords investors a view of what management considers Walmart's core earnings performance and the ability to make a more informed assessment of such core earnings performance with that of the prior year. We adjust for the unrealized and realized gains and losses on our equity and other investments each quarter because although the investments are strategic decisions for the company's retail operations, management's measurement of each strategy is primarily focused on the operational results rather than the fair value of such investments. Additionally, management does not forecast changes in the fair value of its equity and other investments. Accordingly, management adjusts EPS each quarter for the realized and unrealized gains and losses related to those equity investments. We have calculated Adjusted EPS for the trailing five quarters as well as the prior year comparable periods by adjusting EPS for the relevant adjustments for each period presented. Three Months Ended Apr 30, 2023 Three Months Ended Apr 30, 2022 Percent Change Diluted earnings per share: Reported EPS Adjustments: $0.62 $0.74 -16.2% Pre-Tax Impact Tax NCI Impact¹² Impact4 Unrealized and realized (gains) and losses on equity and other investments $1.13 $(0.27) $(0.01) Net Impact $0.85 Pre-Tax Impact Tax $0.71 Impact¹³ $(0.15) 1.3 NCI Impact Net Impact $0.56 Adjusted EPS $1.47 $1.30 +13.1% Tax impact calculated based on nature of item, including any realizable deductions, and statutory rate in effect for relevant jurisdictions. 2 3 4 The reported effective tax rate was 29.5% for the three months ended April 30, 2023. Adjusted for the above item, the effective tax rate was 26.5% for the three months ended April 30, 2023. The reported effective tax rate was 27.5% for the three months ended April 30, 2022. Adjusted for the above item, the effective tax rate was 24.9% for the three months ended April 30, 2022. Calculated based on the ownership percentages of our noncontrolling interests.#32Non-GAAP measures – adjusted EPS (cont.) - Percent Three Months Ended Jan 31, 2023 Three Months Ended Jan 31, 2022 Change Diluted earnings per share: Reported EPS $2.32 $1.28 +81.3% Adjustments: Pre-Tax Impact Tax Unrealized and realized (gains) and losses on equity and other investments Business reorganization and restructuring charges $(1.43) Impact¹² $0.27 NCI Impact³ $- Pre-Tax Tax Net Impact $(1.16) 0.31 0.40 (0.16) Net Adjustments 0.55 $(0.61) Impact $0.22 0.08 Impact $(0.05) (0.02) NCI Impact³ $0.02 Net Impact $0.19 0.06 $0.25 Adjusted EPS $1.71 $1.53 +11.8% Three Months Ended Oct 31, 2022 Three Months Ended Oct 31, 2021 Percent Change Diluted earnings per share: Reported EPS Adjustments: $(0.66) $1.11 NM Unrealized and realized (gains) and losses on equity and other investments Opioid legal charges Pre-Tax Impact $1.34 Tax Impact' $(0.24) NCI Impact³ $0.01 Net Impact $1.11 Pre-Tax Impact $(0.42) Tax Impact $0.09 NCI Impact Net Impact $(0.33) 1.22 (0.17) 1.05 0.86 Loss on extinguishment of debt (0.19) Net Adjustments $2.16 0.67 $0.34 Adjusted EPS4 Tax impact calculated based on nature of item, including any realizable deductions, and statutory rate in effect for relevant jurisdictions. Business reorganization and restructuring charges include tax amounts incurred on separation of Flipkart and Phone Pe.. $1.50 3 Calculated based on the ownership percentages of our noncontrolling interests. 4 Adjusted EPS for the three months ended October 31, 2022 was calculated using weighted average shares outstanding of 2,720 million, which includes the dilutive impact of share-based payment awards. NM not meaningful $1.45 +3.4%#33Non-GAAP measures – adjusted EPS (cont.) - Three Months Ended Jul 31, 2022 Three Months Ended Jul 31, 2021 Percent Change Diluted earnings per share: Reported EPS Adjustments: $1.88 $1.52 +23.7% Unrealized and realized (gains) and losses on equity and other investments Gain on sale of equity method investment in Brazil Pre-Tax Impact $0.14 Tax NCI Impact¹² $(0.02) Impact³ $(0.01) Net Impact $0.11 Pre-Tax Impact $0.34 Tax Impact $(0.08) NCI Impact Net Impact $0.26 (0.16) (0.16) Discrete tax item Net Adjustments (0.06) (0.06) $(0.11) $0.26 Adjusted EPS $1.77 $1.78 -0.6% Three Months Ended Apr 30, 2022 Three Months Ended Apr 30, 2021 Percent Change Diluted earnings per share: Reported EPS Adjustments: $0.74 $0.97 -23.7% Pre-Tax Impact Tax Unrealized and realized (gains) and losses on equity and other investments Incremental loss on sale of our operations in the U.K. and Japan $0.71 Impact' $(0.15) NCI Impact Net Impact $0.56 Pre-Tax Impact $0.74 0.15 Tax Impact $(0.17) NCI Impact Net Impact $0.57 0.15 $0.56 $0.72 Net Adjustments Adjusted EPS 1 2 3 Calculated based on the ownership percentages of our noncontrolling interests. Tax impact calculated based on nature of item, including any realizable deductions, and statutory rate in effect for relevant jurisdictions. No tax expense was incurred in connection with the gain on sale of equity method investment in Brazil. $1.30 $1.69 -23.1%#34Non-GAAP measures - EBITDA and EBITDA Margin We include net income and net income margin, which are calculated in accordance with U.S. generally accepted accounting principle as well as EBITDA and EBITDA margin to provide meaningful information about our operational efficiency compared with our competitors by excluding the impact of certain items. We calculate EBITDA as earnings before interest, taxes, depreciation and amortization. We also exclude other gains and losses, which is primarily comprised of fair value adjustments on our investments which management does not believe are indicative of our core business performance. From time to time, we will adjust EBITDA ("Adjusted EBITDA") for certain items that we adjust from operating income, which we believe is meaningful because it best allows comparison of the performance with that of the comparable period. EBITDA or Adjusted EBITDA margin is calculated by dividing EBITDA or Adjusted EBITDA by consolidated net sales. EBITDA and EBITDA margin are considered non-GAAP financial measures. Management believes, however, that these measures provide meaningful information about our operational efficiency by excluding the impact of differences in tax jurisdictions and structures, debt levels, capital investments and other items which management does not believe are indicative of our core business performance. We consider net income to be the financial measure computed in accordance with GAAP that is the most directly comparable financial measure to our calculation of EBITDA. We consider net income margin to be the financial measure computed in accordance with GAAP that is the most directly comparable financial measure to our calculation of EBITDA margin. Although EBITDA and EBITDA margin are standard financial measures, numerous methods exist for calculating a company's EBITDA and EBITDA margin. As a result, the method used by management to calculate our EBITDA and EBITDA margin may differ from the methods used by other companies to calculate similarly titled measures. Net income margin was 1.1% and 1.5% for the three months ended April 30, 2023 and 2022, respectively. The decrease in net income margin was primarily due to the decrease in net income, which was impacted by higher unrealized losses on our equity and other investments, when compared to the same period in the previous year. EBITDA margin was 6.0% and 5.7% for the 3 months ended April 30, 2023 and 2022, respectively. The increase in EBITDA margin was due to higher operating income driven primarily by an increase in net sales when compared to the same period in the previous year.#35Non-GAAP measures - EBITDA & EBITDA margin The calculation of net income margin and EBITDA margin, along with a reconciliation of EBITDA margin to the calculation of net income margin, is as follows: (Amounts in millions) Consolidated net income attributable to Walmart Consolidated net income attributable to noncontrolling interest Provision for income taxes Other (gains) and losses Interest, Net Operating Income + Depreciation and Amortization EBITDA Net Sales Consolidated net income margin EBITDA margin Three Months Ended Q1 FY24 Q1 FY23 2023 2022 1,673 2,054 (223) (49) 792 798 2,995 1,998 557 419 $ 6,240 $ 5,318 2,845 2,680 9,085 $ 7,998 151,004 $ 140,288 1.1% 1.5% 6.0% 5.7%

Download to PowerPoint

Download presentation as an editable powerpoint.

Related

Sumitomo Mitsui Financial Group 2021 Financial Overview image

Sumitomo Mitsui Financial Group 2021 Financial Overview

Financial

Organic Capital Generation and IFRS Transition Outlook image

Organic Capital Generation and IFRS Transition Outlook

Financial

Acquisition of Marshall & Ilsley Corp. image

Acquisition of Marshall & Ilsley Corp.

Financial

SMBC Group's Financial and Credit Portfolio image

SMBC Group's Financial and Credit Portfolio

Financial

Blue Stripe Fund Summary image

Blue Stripe Fund Summary

Financial

BRI Performance Highlights and Green Initiatives image

BRI Performance Highlights and Green Initiatives

Financial

Latvia Stability Programme Report image

Latvia Stability Programme Report

Financial

International Banking Volume & Growth Summary image

International Banking Volume & Growth Summary

Financial