GURUFOCUS.COM » STOCK LIST » Technology » Software » Constellation Software Inc (OTCPK:CNSWF) » Definitions » Cyclically Adjusted PB Ratio

Constellation Software (Constellation Software) Cyclically Adjusted PB Ratio : 65.72 (As of Apr. 28, 2024)


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

What is Constellation Software Cyclically Adjusted PB Ratio?

As of today (2024-04-28), Constellation Software's current share price is $2656.205. Constellation Software's Cyclically Adjusted Book per Share for the quarter that ended in Dec. 2023 was $40.42. Constellation Software's Cyclically Adjusted PB Ratio for today is 65.72.

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

CNSWF' s Cyclically Adjusted PB Ratio Range Over the Past 10 Years
Min: 27.85   Med: 53.84   Max: 72.53
Current: 68.02

During the past years, Constellation Software's highest Cyclically Adjusted PB Ratio was 72.53. The lowest was 27.85. And the median was 53.84.

CNSWF's Cyclically Adjusted PB Ratio is ranked worse than
99.15% of 1288 companies
in the Software industry
Industry Median: 2.495 vs CNSWF: 68.02

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.

Constellation Software's adjusted book value per share data for the three months ended in Dec. 2023 was $88.526. 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 $40.42 for the trailing ten years ended in Dec. 2023.

Shiller PE for Stocks: The True Measure of Stock Valuation


Constellation Software Cyclically Adjusted PB Ratio Historical Data

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

Constellation Software Cyclically Adjusted PB Ratio Chart

Constellation Software 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 51.58 59.51 69.91 48.14 61.48

Constellation Software Quarterly Data
Mar19 Jun19 Sep19 Dec19 Mar20 Jun20 Sep20 Dec20 Mar21 Jun21 Sep21 Dec21 Mar22 Jun22 Sep22 Dec22 Mar23 Jun23 Sep23 Dec23
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 48.14 55.76 57.00 55.19 61.48

Competitive Comparison of Constellation Software's Cyclically Adjusted PB Ratio

For the Software - Application subindustry, Constellation Software'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.


Constellation Software's Cyclically Adjusted PB Ratio Distribution in the Software Industry

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

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



Constellation Software 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.

Constellation Software's Cyclically Adjusted PB Ratio for today is calculated as

Cyclically Adjusted PB Ratio=Share Price/ Cyclically Adjusted Book per Share
=2656.205/40.42
=65.72

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

Constellation Software's Cyclically Adjusted Book per Share for the quarter that ended in Dec. 2023 is calculated as:

For example, Constellation Software's adjusted Book Value per Share data for the three months ended in Dec. 2023 was:

Adj_Book=Book Value per Share/CPI of Dec. 2023 (Change)*Current CPI (Dec. 2023)
=88.526/125.4675*125.4675
=88.526

Current CPI (Dec. 2023) = 125.4675.

Constellation Software Quarterly Data

Book Value per Share CPI Adj_Book
201403 11.980 98.604 15.244
201406 12.111 99.473 15.276
201409 11.841 99.394 14.947
201412 12.261 98.367 15.639
201503 12.244 99.789 15.395
201506 12.843 100.500 16.034
201509 13.885 100.421 17.348
201512 15.916 99.947 19.980
201603 15.969 101.054 19.827
201606 17.548 102.002 21.585
201609 19.965 101.765 24.615
201612 21.589 101.449 26.700
201703 22.621 102.634 27.654
201706 24.292 103.029 29.583
201709 25.899 103.345 31.443
201712 28.511 103.345 34.614
201803 30.104 105.004 35.971
201806 31.433 105.557 37.362
201809 33.625 105.636 39.938
201812 40.865 105.399 48.646
201903 23.783 106.979 27.893
201906 26.614 107.690 31.007
201909 28.927 107.611 33.727
201912 32.419 107.769 37.743
202003 33.929 107.927 39.443
202006 37.468 108.401 43.367
202009 42.564 108.164 49.373
202012 49.454 108.559 57.156
202103 38.553 110.298 43.855
202106 42.375 111.720 47.589
202109 45.820 112.905 50.918
202112 50.020 113.774 55.161
202203 68.282 117.646 72.822
202206 69.179 120.806 71.848
202209 70.972 120.648 73.807
202212 80.787 120.964 83.795
202303 67.244 122.702 68.760
202306 72.388 124.203 73.125
202309 77.956 125.230 78.104
202312 88.526 125.468 88.526

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.


Constellation Software  (OTCPK:CNSWF) 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.


Constellation Software Cyclically Adjusted PB Ratio Related Terms

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


Constellation Software (Constellation Software) Business Description

Traded in Other Exchanges
Address
20 Adelaide Street East, Suite 1200, Toronto, ON, CAN, M5C 2T6
Constellation Software Inc is a Canada-based company that develops and customizes software for public- and private-sector markets. The firm acquires, manages, and builds vertical-specific businesses. The portfolio companies serve various markets including communications, credit unions, beverage distribution, tour operators, auto clubs, textiles and apparel, hospitality, and community care. The firm has operations in Canada; USA; UK/Europe and Other.