CDW (HAM:CDW) Cyclically Adjusted PS Ratio: (As of Sep. 14, 2026)

Author: Vera Yuan Vera Yuan
Vera Yuan
Vera Yuan
Director of Data and Quant Analytics at GuruFocus
Focused on building reliable datasets, financial models, and research tools for value-minded investors. Committed to turning complex data into practical guidance for value-investing and long-term wealth.
Reviewed by: Charlie Tian Charlie Tian
Charlie Tian
Charlie Tian
Founder & CEO of GuruFocus
Dr. Charlie Tian is the founder and CEO of GuruFocus.com, a leading global investment research platform established in 2004. With a Ph.D. in physics, Dr. Tian transitioned from science to finance, applying a data-driven, disciplined approach to value investing.

HAM:CDW CDW Corp HAM:CDW
66 GF Score
Price €121.80
GF Value €168.60
Valuation Modestly Undervalued
! 7 Warning Signs
View Full Analysis

What is CDW Cyclically Adjusted PS Ratio?

Note: If the price history is too short, we do not calculate current Cyclically Adjusted PS Ratio for this stock. All the historical data is shown as the company's primary share's data instead.

Shiller PE for Stocks: The True Measure of Stock Valuation


CDW  (HAM:CDW) 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.


CDW Cyclically Adjusted PS Ratio Related Terms


CDW Cyclically Adjusted PS Ratio Historical Data

* Premium members only.

The historical data trend for CDW'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.

CDW Cyclically Adjusted PS Ratio Chart

CDW Annual Data
Trend Dec16 Dec17 Dec18 Dec19 Dec20 Dec21 Dec22 Dec23 Dec24 Dec25
Cyclically Adjusted PS Ratio
Get a 7-Day Free Trial Premium Member Only Premium Member Only 1.90 1.45 1.69 1.21 0.88

CDW Quarterly Data
Sep21 Dec21 Mar22 Jun22 Sep22 Dec22 Mar23 Jun23 Sep23 Dec23 Mar24 Jun24 Sep24 Dec24 Mar25 Jun25 Sep25 Dec25 Mar26 Jun26
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 1.18 1.04 0.88 0.76 0.86

HAM:CDW vs LDOS, BR, FIS: Cyclically Adjusted PS Ratio Comparison

For the Information Technology Services subindustry, CDW'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.


CDW Cyclically Adjusted PS Ratio vs Software Industry

For the Software industry and Technology sector, CDW's Cyclically Adjusted PS Ratio distribution charts can be found below:

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


HAM:CDW
66GF Score
CDW Corp HAM:CDW
Cyclically Adjusted PS Ratio is just one metric. See GF Score™, valuation, warning signs, and more.
View Full Analysis

CDW 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.

CDW's Cyclically Adjusted Revenue per Share for the quarter that ended in Jun. 2026 is calculated as:

For example, CDW's adjusted Revenue per Share data for the three months ended in Jun. 2026 was:

Adj_RevenuePerShare=Revenue per Share/CPI of Jun. 2026 (Change)*Current CPI (Jun. 2026)
=44.778/333.9520*333.9520
=44.778

Current CPI (Jun. 2026) = 333.9520.

CDW Quarterly Data

Revenue per Share CPI Adj_RevenuePerShare
201609 20.036 241.428 27.715
201612 18.479 241.432 25.560
201703 18.700 243.801 25.615
201706 21.784 244.955 29.699
201709 21.126 246.819 28.584
201712 20.429 246.524 27.674
201803 18.894 249.554 25.284
201806 23.283 251.989 30.856
201809 24.384 252.439 32.258
201812 23.549 251.233 31.303
201903 23.477 254.202 30.842
201906 27.630 256.143 36.023
201909 30.273 256.759 39.374
201912 27.853 256.974 36.197
202003 27.414 258.115 35.469
202006 26.866 257.797 34.802
202009 27.888 260.280 35.782
202012 28.077 260.474 35.997
202103 28.396 264.877 35.801
202106 30.145 271.696 37.052
202109 32.317 274.310 39.344
202112 35.560 278.802 42.594
202203 39.516 287.504 45.900
202206 42.499 296.311 47.898
202209 45.789 296.808 51.519
202212 37.391 296.797 42.072
202303 34.714 301.836 38.408
202306 38.155 305.109 41.762
202309 38.806 307.789 42.105
202312 33.838 306.746 36.839
202403 32.962 312.332 35.244
202406 37.156 314.175 39.495
202409 36.845 315.301 39.024
202412 36.877 315.605 39.021
202503 36.024 319.799 37.618
202506 39.137 322.561 40.519
202509 37.089 324.800 38.134
202512 36.037 324.054 37.138
202603 37.938 330.213 38.368
202606 44.778 333.952 44.778

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.

Is CDW (HAM:CDW) Overvalued in 2026?

Based on GuruFocus' analysis, CDW stock appears to be undervalued. The current stock price of €121.80 is trading 27.8% below its estimated GF Value™ of €168.60. GuruFocus considers CDW to be Modestly Undervalued.

Key valuation signals for HAM:CDW:

  • Cyclically Adjusted PS Ratio:
  • GF Value™: €168.60 vs. price of €121.80 (27.8% below fair value)
  • GF Score™: 66/100 with 7 warning signs

No single metric tells the full story. See the HAM:CDW stock analysis page for a complete view including 30-year financials, guru trades, and insider activity.


CDW Business Description

Address 200 North Milwaukee Avenue, Vernon Hills, IL, USA, 60061
CDW Corp is a multi-brand provider of information technology (IT) solutions to businesses, government, education, and healthcare customers in the United States, the United Kingdom, and Canada. The company's offerings range from hardware and software products to integrated IT solutions and services, including on-premise and cloud capabilities across hybrid infrastructure, digital experience, and security. Its reportable segments are Corporate, Small Business, Public, and Other. The Corporate and Small Business segments serve US private sector business customers, while the Public segment consists of government agencies and education and healthcare institutions in the US. The Corporate segment generates the majority of its revenue in the United States.
66GF Score

Get the complete analysis for HAM:CDW

Cyclically Adjusted PS Ratio is just one metric. See GF Value™, 30-year financials, guru trades, warning signs, and more.

€121.80
Price
€168.60
GF Value