GURUFOCUS.COM » STOCK LIST » Technology » Hardware » Celestica Inc (FRA:CTW0) » Definitions » Cyclically Adjusted PS Ratio

Celestica (FRA:CTW0) Cyclically Adjusted PS Ratio : 0.91 (As of May. 15, 2024)


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

What is Celestica Cyclically Adjusted PS Ratio?

As of today (2024-05-15), Celestica's current share price is €43.38. Celestica's Cyclically Adjusted Revenue per Share for the quarter that ended in Mar. 2024 was €47.71. Celestica's Cyclically Adjusted PS Ratio for today is 0.91.

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

FRA:CTW0' s Cyclically Adjusted PS Ratio Range Over the Past 10 Years
Min: 0.09   Med: 0.3   Max: 0.96
Current: 0.94

During the past years, Celestica's highest Cyclically Adjusted PS Ratio was 0.96. The lowest was 0.09. And the median was 0.30.

FRA:CTW0's Cyclically Adjusted PS Ratio is ranked better than
53.86% of 1918 companies
in the Hardware industry
Industry Median: 1.06 vs FRA:CTW0: 0.94

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.

Celestica's adjusted revenue per share data for the three months ended in Mar. 2024 was €17.034. 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 €47.71 for the trailing ten years ended in Mar. 2024.

Shiller PE for Stocks: The True Measure of Stock Valuation


Celestica Cyclically Adjusted PS Ratio Historical Data

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

Celestica Cyclically Adjusted PS Ratio Chart

Celestica Annual Data
Trend Dec14 Dec15 Dec16 Dec17 Dec18 Dec19 Dec20 Dec21 Dec22 Dec23
Cyclically Adjusted PS Ratio
Get a 7-Day Free Trial Premium Member Only Premium Member Only 0.23 0.21 0.26 0.25 0.57

Celestica Quarterly Data
Jun19 Sep19 Dec19 Mar20 Jun20 Sep20 Dec20 Mar21 Jun21 Sep21 Dec21 Mar22 Jun22 Sep22 Dec22 Mar23 Jun23 Sep23 Dec23 Mar24
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.28 0.30 0.50 0.57 0.87

Competitive Comparison of Celestica's Cyclically Adjusted PS Ratio

For the Electronic Components subindustry, Celestica'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.


Celestica's Cyclically Adjusted PS Ratio Distribution in the Hardware Industry

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

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



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

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

Cyclically Adjusted PS Ratio=Share Price/ Cyclically Adjusted Revenue per Share
=43.38/47.71
=0.91

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

Celestica's Cyclically Adjusted Revenue per Share for the quarter that ended in Mar. 2024 is calculated as:

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

Adj_RevenuePerShare=Revenue per Share/CPI of Mar. 2024 (Change)*Current CPI (Mar. 2024)
=17.034/125.4675*125.4675
=17.034

Current CPI (Mar. 2024) = 125.4675.

Celestica Quarterly Data

Revenue per Share CPI Adj_RevenuePerShare
201406 5.951 99.473 7.506
201409 6.149 99.394 7.762
201412 6.500 98.367 8.291
201503 6.884 99.789 8.655
201506 7.566 100.500 9.446
201509 8.637 100.421 10.791
201512 9.571 99.947 12.015
201603 8.370 101.054 10.392
201606 9.175 102.002 11.286
201609 9.683 101.765 11.938
201612 10.918 101.449 13.503
201703 9.623 102.634 11.764
201706 9.528 103.029 11.603
201709 8.826 103.345 10.715
201712 9.119 103.345 11.071
201803 8.476 105.004 10.128
201806 10.313 105.557 12.258
201809 10.453 105.636 12.415
201812 11.008 105.399 13.104
201903 9.285 106.979 10.890
201906 9.759 107.690 11.370
201909 10.726 107.611 12.506
201912 10.375 107.769 12.079
202003 9.251 107.927 10.754
202006 10.265 108.401 11.881
202009 10.197 108.164 11.828
202012 8.829 108.559 10.204
202103 8.041 110.298 9.147
202106 9.239 111.720 10.376
202109 9.939 112.905 11.045
202112 10.714 113.774 11.815
202203 11.409 117.646 12.168
202206 13.101 120.806 13.607
202209 15.767 120.648 16.397
202212 15.753 120.964 16.339
202303 14.116 122.702 14.434
202306 14.880 124.203 15.031
202309 16.008 125.230 16.038
202312 16.398 125.468 16.398
202403 17.034 125.468 17.034

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.


Celestica  (FRA:CTW0) 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.


Celestica Cyclically Adjusted PS Ratio Related Terms

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


Celestica (FRA:CTW0) Business Description

Industry
Traded in Other Exchanges
Address
5140 Yonge Street, Suite 1900, Toronto, ON, CAN, M2N 6L7
Celestica Inc offers supply chain solutions. The company has two operating and reportable segments: Advanced Technology Solutions (ATS) and Connectivity & Cloud Solutions (CCS). The ATS segment consists of the ATS end market and is comprised of the Aerospace and Defense, Industrial, health tech, and Capital Equipment businesses. Its Capital Equipment business is comprised of the semiconductor, display, and robotics equipment businesses, and the CCS segment consists of Communications and Enterprise end markets, Enterprise end market is comprised of its servers and storage businesses. The company generates a majority of its revenue from the Connectivity & Cloud Solutions segment.

Celestica (FRA:CTW0) Headlines

No Headlines