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

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


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

What is Celestica Cyclically Adjusted PB Ratio?

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

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

FRA:CTW0' s Cyclically Adjusted PB Ratio Range Over the Past 10 Years
Min: 0.4   Med: 1.25   Max: 4.32
Current: 4.22

During the past years, Celestica's highest Cyclically Adjusted PB Ratio was 4.32. The lowest was 0.40. And the median was 1.25.

FRA:CTW0's Cyclically Adjusted PB Ratio is ranked worse than
84.21% of 1862 companies
in the Hardware industry
Industry Median: 1.64 vs FRA:CTW0: 4.22

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 PB Ratio. The Cyclically Adjusted Book per Share is the average of the inflation adjusted book value per share of a company over the past 10 years.

Celestica's adjusted book value per share data for the three months ended in Mar. 2024 was €13.253. Add all the adjusted book value per share for the past 10 years together and divide the count will get our Cyclically Adjusted Book per Share, which is €10.62 for the trailing ten years ended in Mar. 2024.

Shiller PE for Stocks: The True Measure of Stock Valuation


Celestica Cyclically Adjusted PB Ratio Historical Data

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

Celestica Annual Data
Trend Dec14 Dec15 Dec16 Dec17 Dec18 Dec19 Dec20 Dec21 Dec22 Dec23
Cyclically Adjusted PB Ratio
Get a 7-Day Free Trial Premium Member Only Premium Member Only 1.04 0.93 1.15 1.10 2.53

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 PB 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.22 1.31 2.21 2.53 3.92

Competitive Comparison of Celestica's Cyclically Adjusted PB Ratio

For the Electronic Components subindustry, Celestica's Cyclically Adjusted PB Ratio, along with its competitors' market caps and Cyclically Adjusted PB 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 PB Ratio Distribution in the Hardware Industry

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

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



Celestica Cyclically Adjusted PB Ratio Calculation

Like the Shiller PE Ratio, the Cyclically Adjusted PB Ratio takes the Book Value per Share from the past 10 years, adjusts it for inflation, and then calculates the average. This average is then used for the P/B calculation. Because it considers this 10-year average, it's often referred to as the CAPB 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 PB Ratio.

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

Cyclically Adjusted PB Ratio=Share Price/ Cyclically Adjusted Book per Share
=43.38/10.62
=4.08

* 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 Book per Share for the quarter that ended in Mar. 2024 is calculated as:

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

Adj_Book=Book Value per Share/CPI of Mar. 2024 (Change)*Current CPI (Mar. 2024)
=13.253/125.4675*125.4675
=13.253

Current CPI (Mar. 2024) = 125.4675.

Celestica Quarterly Data

Book Value per Share CPI Adj_Book
201406 6.046 99.473 7.626
201409 6.410 99.394 8.091
201412 6.480 98.367 8.265
201503 7.652 99.789 9.621
201506 6.787 100.500 8.473
201509 6.768 100.421 8.456
201512 6.981 99.947 8.764
201603 7.005 101.054 8.697
201606 7.351 102.002 9.042
201609 7.665 101.765 9.450
201612 8.463 101.449 10.467
201703 8.316 102.634 10.166
201706 8.192 103.029 9.976
201709 7.926 103.345 9.623
201712 8.165 103.345 9.913
201803 7.876 105.004 9.411
201806 7.930 105.557 9.426
201809 8.037 105.636 9.546
201812 8.593 105.399 10.229
201903 9.361 106.979 10.979
201906 9.457 107.690 11.018
201909 9.654 107.611 11.256
201912 9.477 107.769 11.033
202003 9.386 107.927 10.911
202006 9.374 108.401 10.850
202009 9.210 108.164 10.683
202012 8.975 108.559 10.373
202103 9.228 110.298 10.497
202106 9.349 111.720 10.499
202109 10.015 112.905 11.129
202112 10.382 113.774 11.449
202203 11.044 117.646 11.778
202206 11.747 120.806 12.200
202209 12.931 120.648 13.448
202212 13.020 120.964 13.505
202303 12.812 122.702 13.101
202306 12.999 124.203 13.131
202309 13.626 125.230 13.652
202312 13.633 125.468 13.633
202403 13.253 125.468 13.253

Add all the adjusted book value per share together and divide the count will get our Cyclically Adjusted Book 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 PB Ratio Explanation

Compared with the regular PB Ratio, which works poorly for cyclical businesses, the Cyclically Adjusted PB Ratio smoothed out the fluctuations of book value 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 PB Ratio should give similar results to regular PB Ratio.


Celestica Cyclically Adjusted PB Ratio Related Terms

Thank you for viewing the detailed overview of Celestica's Cyclically Adjusted PB 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