GURUFOCUS.COM » STOCK LIST » Consumer Defensive » Retail - Defensive » Walmart Inc (FRA:WMT) » Definitions » Cyclically Adjusted PS Ratio

Walmart (FRA:WMT) Cyclically Adjusted PS Ratio : 0.84 (As of Apr. 28, 2024)


View and export this data going back to 1970. Start your Free Trial

What is Walmart Cyclically Adjusted PS Ratio?

As of today (2024-04-28), Walmart's current share price is €56.22. Walmart's Cyclically Adjusted Revenue per Share for the quarter that ended in Jan. 2024 was €66.75. Walmart's Cyclically Adjusted PS Ratio for today is 0.84.

The historical rank and industry rank for Walmart's Cyclically Adjusted PS Ratio or its related term are showing as below:

FRA:WMT' s Cyclically Adjusted PS Ratio Range Over the Past 10 Years
Min: 0.44   Med: 0.68   Max: 0.9
Current: 0.84

During the past years, Walmart's highest Cyclically Adjusted PS Ratio was 0.90. The lowest was 0.44. And the median was 0.68.

FRA:WMT's Cyclically Adjusted PS Ratio is ranked worse than
71.37% of 227 companies
in the Retail - Defensive industry
Industry Median: 0.37 vs FRA:WMT: 0.84

The Shiller PE Ratio was first used by professor Robert Shiller. He uses E10 for his Shiller PE Ratio calculation. E10 is the average of the inflation adjusted earnings per share of a company over the past 10 years. The similar calculation is applied by GuruFocus to calculate the Cyclically Adjusted PS Ratio. The Cyclically Adjusted Revenue per Share is the average of the inflation adjusted revenue per share of a company over the past 10 years.

Walmart's adjusted revenue per share data for the three months ended in Jan. 2024 was €19.639. Add all the adjusted revenue per share for the past 10 years together and divide 10 will get our Cyclically Adjusted Revenue per Share, which is €66.75 for the trailing ten years ended in Jan. 2024.

Shiller PE for Stocks: The True Measure of Stock Valuation


Walmart Cyclically Adjusted PS Ratio Historical Data

The historical data trend for Walmart's Cyclically Adjusted PS 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 Cyclically Adjusted PS Ratio Chart

Walmart Annual Data
Trend Jan15 Jan16 Jan17 Jan18 Jan19 Jan20 Jan21 Jan22 Jan23 Jan24
Cyclically Adjusted PS Ratio
Get a 7-Day Free Trial Premium Member Only Premium Member Only 0.70 0.82 0.74 0.70 0.77

Walmart Quarterly Data
Apr19 Jul19 Oct19 Jan20 Apr20 Jul20 Oct20 Jan21 Apr21 Jul21 Oct21 Jan22 Apr22 Jul22 Oct22 Jan23 Apr23 Jul23 Oct23 Jan24
Cyclically Adjusted PS Ratio Get a 7-Day Free Trial 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 0.70 0.72 0.75 0.76 0.77

Competitive Comparison of Walmart's Cyclically Adjusted PS Ratio

For the Discount Stores subindustry, Walmart's Cyclically Adjusted PS Ratio, along with its competitors' market caps and Cyclically Adjusted PS 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's Cyclically Adjusted PS Ratio Distribution in the Retail - Defensive Industry

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

* The bar in red indicates where Walmart's Cyclically Adjusted PS Ratio falls into.



Walmart Cyclically Adjusted PS Ratio Calculation

Like the Shiller PE Ratio, the Cyclically Adjusted PS Ratio takes the Revenue per Share from the past 10 years, adjusts it for inflation, and then calculates the average. This average is then used for the P/S calculation. Because it considers this 10-year average, it's often referred to as the CAPS Ratio.

The Shiller PE Ratio was first used by professor Robert Shiller to measure the valuation of the overall market. The similar calculation is applied by GuruFocus to calculate the Cyclically Adjusted PS Ratio.

Walmart's Cyclically Adjusted PS Ratio for today is calculated as

Cyclically Adjusted PS Ratio=Share Price/ Cyclically Adjusted Revenue per Share
=56.22/66.75
=0.84

* 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 Cyclically Adjusted Revenue per Share for the quarter that ended in Jan. 2024 is calculated as:

For example, Walmart's adjusted Revenue per Share data for the three months ended in Jan. 2024 was:

Adj_RevenuePerShare=Revenue per Share/CPI of Jan. 2024 (Change)*Current CPI (Jan. 2024)
=19.639/129.4194*129.4194
=19.639

Current CPI (Jan. 2024) = 129.4194.

Walmart Quarterly Data

Revenue per Share CPI Adj_RevenuePerShare
201404 8.542 100.023 11.052
201407 9.130 100.520 11.755
201410 9.660 100.176 12.480
201501 11.643 98.604 15.282
201504 10.905 99.824 14.138
201507 11.275 100.691 14.492
201510 10.833 100.346 13.972
201601 12.538 99.957 16.234
201604 10.792 100.947 13.836
201607 11.689 101.524 14.901
201610 11.538 101.988 14.641
201701 13.338 102.456 16.848
201704 11.997 103.167 15.050
201707 11.801 103.278 14.788
201710 11.663 104.070 14.504
201801 12.511 104.578 15.483
201804 11.234 105.708 13.754
201807 12.400 106.324 15.093
201810 12.315 106.695 14.938
201901 13.917 106.200 16.960
201904 12.739 107.818 15.291
201907 13.512 108.250 16.154
201910 13.481 108.577 16.069
202001 14.898 108.841 17.715
202004 14.491 108.173 17.337
202007 14.026 109.318 16.605
202010 13.397 109.861 15.782
202101 14.649 110.364 17.178
202104 13.624 112.673 15.649
202107 14.145 115.183 15.893
202110 14.436 116.696 16.010
202201 16.198 118.619 17.673
202204 15.804 121.978 16.768
202207 18.247 125.002 18.892
202210 19.071 125.734 19.630
202301 18.746 126.223 19.221
202304 17.123 127.992 17.314
202307 18.019 128.974 18.081
202310 18.779 129.810 18.723
202401 19.639 129.419 19.639

Add all the adjusted revenue per share together and divide 10 will get our Cyclically Adjusted Revenue per Share.

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  (FRA:WMT) Cyclically Adjusted PS Ratio Explanation

Compared with the regular PS Ratio, which works poorly for cyclical businesses, the Cyclically Adjusted PS Ratio smoothed out the fluctuations of revenue during business cycles. Therefore it is more accurate in reflecting the valuation of the company.

If a company has consistent business performance, the Cyclically Adjusted PS Ratio should give similar results to regular PS Ratio.


Walmart Cyclically Adjusted PS Ratio Related Terms

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


Walmart (FRA:WMT) Business Description

Address
702 S.W. 8th Street, Bentonville, AR, USA, 72716
Walmart serves as the preeminent retailer in the United States, with its strategy predicated on superior operating efficiency and offering the lowest priced goods to consumers to drive robust store traffic and product turnover. Walmart augmented its low-price business strategy by offering a convenient one-stop shopping destination with the opening of its first supercenter in 1988.Today, Walmart operates over 4,700 stores in the United States (5,300 including Sam's Club) and over 10,000 stores globally. Walmart generated over $420 billion in domestic namesake sales last year, with Sam's Club contributing another $84 billion to the firm's top line. Internationally, Walmart generated $100 billion in sales. The company serves around 240 million customers globally each week.