GURUFOCUS.COM » STOCK LIST » USA » NYSE » Walmart Inc (NYSE:WMT) » Definitions » Shiller PE Ratio
Switch to:

Walmart (NYSE:WMT) Shiller PE Ratio

: 28.03 (As of Today)
View and export this data going back to 1970. Start your Free Trial

As of today (2023-02-02), Walmart's current share price is $143.81. Walmart's E10 for the quarter that ended in Oct. 2022 was $5.13. Walmart's Shiller PE Ratio for today is 28.03.

The historical rank and industry rank for Walmart's Shiller PE Ratio or its related term are showing as below:

WMT' s Shiller PE Ratio Range Over the Past 10 Years
Min: 12.94   Med: 20.19   Max: 30.74
Current: 28.12

During the past years, Walmart's highest Shiller PE Ratio was 30.74. The lowest was 12.94. And the median was 20.19.

WMT's Shiller PE Ratio is ranked worse than
64.84% of 182 companies
in the Retail - Defensive industry
Industry Median: 19.83 vs WMT: 28.12

E10 is a concept invented by Prof. Robert Shiller, who uses E10 for his Shiller PE Ratio calculation. E10 is the average of the inflation adjusted earnings of a company over the past 10 years.

Walmart's adjusted earnings per share data for the three months ended in Oct. 2022 was $-0.660. Add all the adjusted EPS for the past 10 years together and divide 10 will get our E10, which is $5.13 for the trailing ten years ended in Oct. 2022.

Shiller PE for Stocks: The True Measure of Stock Valuation


Walmart Shiller PE Ratio Historical Data

The historical data trend for Walmart's Shiller PE Ratio can be seen below:

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.

* Premium members only.

Walmart Annual Data
Trend Jan13 Jan14 Jan15 Jan16 Jan17 Jan18 Jan19 Jan20 Jan21 Jan22
Shiller PE Ratio
Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only 22.86 20.98 24.04 29.45 27.60

Walmart Quarterly Data
Jan18 Apr18 Jul18 Oct18 Jan19 Apr19 Jul19 Oct19 Jan20 Apr20 Jul20 Oct20 Jan21 Apr21 Jul21 Oct21 Jan22 Apr22 Jul22 Oct22
Shiller PE Ratio Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only 29.64 27.60 29.73 24.87 27.72

Competitive Comparison

For the Discount Stores subindustry, Walmart's Shiller PE Ratio, along with its competitors' market caps and Shiller PE Ratio data, can be viewed below:

* Competitive companies are chosen from companies within the same industry, with headquarter located in same country, with closest market capitalization; x-axis shows the market cap, and y-axis shows the term value; the bigger the dot, the larger the market cap. Note that "N/A" values will not show up in the chart.

   

Walmart Shiller PE Ratio Distribution

For the Retail - Defensive industry and Consumer Defensive sector, Walmart's Shiller PE Ratio distribution charts can be found below:

* The bar in red indicates where Walmart's Shiller PE Ratio falls in comparison to its industry or sector. The grey bar indicates the Shiller PE Ratio's extreme value range as defined by GuruFocus.



Walmart Shiller PE Ratio Calculation

For Shiller PE Ratio, the earnings of the past 10 years are inflation-adjusted and averaged. The result is used for P/E calculation. Since it looks at the average over the last 10 years, the Shiller PE Ratio is also called PE10.

The Shiller PE Ratio was first used by professor Robert Shiller to measure the valuation of the overall market. The same calculation is applied here to individual companies.

Walmart's Shiller PE Ratio for today is calculated as

Shiller PE Ratio=Share Price/ E10
=143.81/5.13
=28.03

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.

Walmart's E10 for the quarter that ended in Oct. 2022 is calculated as:

For example, Walmart's adjusted earnings per share data for the three months ended in Oct. 2022 was:

Adj_EPS=Earnings per Share (Diluted)/CPI of Oct. 2022 (Change)*Current CPI (Oct. 2022)
=-0.66/125.7344*125.7344
=-0.660

Current CPI (Oct. 2022) = 125.7344.

Walmart Quarterly Data

Earnings per Share (Diluted) CPI Adj_EPS
201301 1.670 97.158 2.161
201304 1.140 98.107 1.461
201307 1.240 98.557 1.582
201310 1.140 98.536 1.455
201401 1.360 98.692 1.733
201404 1.110 100.023 1.395
201407 1.260 100.520 1.576
201410 1.150 100.176 1.443
201501 1.530 98.604 1.951
201504 1.030 99.824 1.297
201507 1.080 100.691 1.349
201510 1.030 100.346 1.291
201601 1.430 99.957 1.799
201604 0.980 100.947 1.221
201607 1.210 101.524 1.499
201610 0.980 101.988 1.208
201701 1.220 102.456 1.497
201704 1.000 103.167 1.219
201707 0.960 103.278 1.169
201710 0.580 104.070 0.701
201801 0.730 104.578 0.878
201804 0.720 105.708 0.856
201807 -0.290 106.324 -0.343
201810 0.580 106.695 0.683
201901 1.270 106.200 1.504
201904 1.330 107.818 1.551
201907 1.260 108.250 1.464
201910 1.150 108.577 1.332
202001 1.450 108.841 1.675
202004 1.400 108.173 1.627
202007 2.270 109.318 2.611
202010 1.800 109.861 2.060
202101 -0.740 110.364 -0.843
202104 0.970 112.673 1.082
202107 1.520 115.183 1.659
202110 1.110 116.696 1.196
202201 1.280 118.619 1.357
202204 0.740 121.978 0.763
202207 1.880 125.002 1.891
202210 -0.660 125.734 -0.660

Add all the adjusted EPS together and divide 10 will get our E10.

Please note that we use the CPI data of the country/region where the company is headquartered. If the CPI data for that country/region is not available, then we will use the CPI data of the United States as default.


Walmart  (NYSE:WMT) Shiller PE Ratio Explanation

Compared with the regular PE Ratio, which works poorly for cyclical businesses, the Shiller PE Ratio smoothed out the fluctuations of profit margins during business cycles. Therefore it is more accurate in reflecting the valuation of the company.

If a company has consistent business performance, the Shiller PE Ratio should give similar results to regular PE Ratio.

Compared with the PS Ratio, the Shiller PE Ratio makes the comparison between different industries more meaningful.


Be Aware

Shiller PE Ratio assumes that over the long term, businesses and profitability revert to their means. If a company's business model does not work in the future compared with the past, Shiller PE Ratio and PS Ratio will give false valuations.


Walmart Shiller PE Ratio Related Terms

Thank you for viewing the detailed overview of Walmart's Shiller PE Ratio provided by GuruFocus.com. Please click on the following links to see related term pages.


Walmart (NYSE:WMT) Business Description

Walmart logo
Address
702 Southwest 8th Street, Bentonville, AR, USA, 72716
America's largest retailer by sales, Walmart operated over 10,500 stores under 46 banners at the end of fiscal 2022, selling a variety of general merchandise and grocery items. Its home market accounted for 82% of sales in fiscal 2022, with Mexico and Central America (6%) and Canada (4%) its largest external markets. In the United States at the namesake banner, around 56% of sales come from grocery, 32% from general merchandise, and 11% from health and wellness items. The company operates several e-commerce properties apart from its eponymous site, including Flipkart and shoes.com (it also owns a roughly 10% stake in Chinese online retailer JD.com). Combined, e-commerce accounted for about 13% of fiscal 2022 sales.
Executives
John D Rainey officer: Executive Vice President C/O PAYPAL HOLDINGS, INC., 2211 NORTH FIRST STREET, SAN JOSE CA 95131
Randall L Stephenson director 208 S. AKARD ST., DALLAS TX 75202
Donna Morris officer: Executive Vice President 345 PARK AVENUE, SAN JOSE CA 95110
Kathryn J. Mclay officer: Executive Vice President 702 S.W. 8TH STREET, BENTONVILLE AR 72716
Suresh Kumar officer: Chief Technology Officer 860 W. CALIFORNIA AVE., SUNNYVALE CA 94086
Cesar Conde director ONE OWENS CORNING PARKWAY, TOLEDO OH 43659
Stephen Easterbrook director MCDONALD'S CORPORATION, 110 NORTH CARPENTER STREET, CHICAGO IL 60607
Rachel L Brand officer: Executive Vice President 702 S.W. 8TH STREET, BENTONVILLE AR 72716
Sarah Friar director C/O NEXTDOOR HOLDINGS, INC., 420 TAYLOR STREET, SAN FRANCISCO CA 94102
Judith J Mckenna officer: Executive Vice President 702 S.W. 8TH STREET, BENTONVILLE AR 72716
Carla A Harris director 702 SW 8TH STREET, BENTONVILLE AR 72716
John R. Furner officer: Executive Vice President 702 SW 8TH STREET, BENTONVILLE AR 72716
David Chojnowski officer: Senior Vice President 5505 BLUE LAGOON DRIVE, MIAMI FL 33126
Marc E. Lore officer: Executive Vice President 443 GREENWICH STREET, PHA, NEW YORK NY 10013
Steuart L Walton director 702 SW 8TH STREET, BENTONVILLE AR 72716

Walmart (NYSE:WMT) Headlines

Get WordPress Plugins for easy affiliate links on Stock Tickers and Guru Names | Earn affiliate commissions by embedding GuruFocus Charts
GuruFocus Affiliate Program: Earn up to $400 per referral. ( Learn More)
premium membership