GURUFOCUS.COM » STOCK LIST » Utilities » Utilities - Independent Power Producers » Celsia SA Esp (BOG:CELSIA) » Definitions » Graham Number

Celsia Esp (BOG:CELSIA) Graham Number : COP2,928.02 (As of Mar. 2024)


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

What is Celsia Esp Graham Number?

Graham Number is a figure that measures a stock's fundamental value by taking into account the company's earnings per share and book value per share. The Graham number is the upper bound of the price range that a defensive investor should pay for the stock. According to the theory, any stock price below the Graham number is considered undervalued, and thus worth investing in.

As of today (2024-05-24), the stock price of Celsia Esp is COP4390.00. Celsia Esp's graham number for the quarter that ended in Mar. 2024 was COP2,928.02. Therefore, Celsia Esp's Price to Graham Number ratio for today is 1.50.

The historical rank and industry rank for Celsia Esp's Graham Number or its related term are showing as below:

BOG:CELSIA' s Price-to-Graham-Number Range Over the Past 10 Years
Min: 0.39   Med: 1   Max: 6.81
Current: 1.5

During the past 13 years, the highest Price to Graham Number ratio of Celsia Esp was 6.81. The lowest was 0.39. And the median was 1.00.

BOG:CELSIA's Price-to-Graham-Number is ranked worse than
62.85% of 288 companies
in the Utilities - Independent Power Producers industry
Industry Median: 1.12 vs BOG:CELSIA: 1.50

Graham Number is a combination of asset valuation and earnings power valuation. It is a very conservative way of valuing a stock.


Celsia Esp Graham Number Historical Data

The historical data trend for Celsia Esp's Graham Number 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.

Celsia Esp Graham Number Chart

Celsia Esp Annual Data
Trend Dec14 Dec15 Dec16 Dec17 Dec18 Dec19 Dec20 Dec21 Dec22 Dec23
Graham Number
Get a 7-Day Free Trial Premium Member Only Premium Member Only 4,219.71 4,610.33 6,151.84 8,737.22 5,577.00

Celsia Esp Quarterly Data
Jun19 Sep19 Dec19 Mar20 Jun20 Sep20 Dec20 Mar21 Jun21 Sep21 Dec21 Mar22 Jun22 Sep22 Dec22 Mar23 Jun23 Sep23 Dec23 Mar24
Graham Number 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 5,860.35 5,022.19 3,623.70 3,620.47 2,928.02

Competitive Comparison of Celsia Esp's Graham Number

For the Utilities - Renewable subindustry, Celsia Esp's Price-to-Graham-Number, along with its competitors' market caps and Price-to-Graham-Number 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.


Celsia Esp's Price-to-Graham-Number Distribution in the Utilities - Independent Power Producers Industry

For the Utilities - Independent Power Producers industry and Utilities sector, Celsia Esp's Price-to-Graham-Number distribution charts can be found below:

* The bar in red indicates where Celsia Esp's Price-to-Graham-Number falls into.



Celsia Esp Graham Number Calculation

Graham Number is a concept based on Ben Graham's conservative valuation of companies.

Celsia Esp's Graham Number for the fiscal year that ended in Dec. 2023 is calculated as

Graham Number
=sqrt of (22.5* Tangible Book per Share *EPS without NRI)
=sqrt of (22.5*3221.62*429.086)
=5,577.00

Celsia Esp's Graham Number for the quarter that ended in Mar. 2024 is calculated as

Graham Number
=sqrt of (22.5*Tangible Book per Share*EPS without NRI (TTM))
=sqrt of (22.5*2920.477*130.47)
=2,928.02

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


Celsia Esp  (BOG:CELSIA) Graham Number Explanation

Ben Graham actually did not publish a formula like this. But he wrote in The Intelligent Investor (1948 version) regarding to the criteria for purchases:

Current price should not be more than 15 times average earnings of the past three years.

Current price should not be more than 1.5 times the book value last reported. However, a multiplier of earnings below 15 could justify a correspondingly higher multiplier of assets. As a rule of thumb we suggest that the product of the multiplier times the ratio of price to book value should not exceed 22.5. (This figure corresponds to 15 times earnings and 1.5 times book value. It would admit an issue selling at only 9 times earnings and 2.5 times asset value, etc.)

Unlike valuation methods such as DCF or Discounted Earnings, the Graham number does not take growth into the valuation. Unlike the valuation methods based on book value alone, it takes into account the earnings power. Therefore, the Graham Number is a combination of asset valuation and earnings power valuation.

In general, the Graham number is a very conservative way of valuing a stock. It cannot be applied to companies with negative book values.

Celsia Esp's Price to Graham number Ratio for today is calculated as

Price to Graham number=Share Price (Today)/Graham number (Q: Mar. 2024 )
=4390.00/2,928.02
=1.50

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


Be Aware

Please keep these in mind:

1. Graham Number does not take growth into account. Therefore it underestimates the values of the companies that have good earnings growth. We feel that if the earnings per share grows more than 10% a year, Graham Number underestimates the value.
2. Graham Number punishes the companies that have temporarily low earnings. Therefore, an average of earnings makes more sense in the calculation of Graham Number.
3. Graham Numbers underestimates companies that are light with book.


Celsia Esp Graham Number Related Terms

Thank you for viewing the detailed overview of Celsia Esp's Graham Number provided by GuruFocus.com. Please click on the following links to see related term pages.


Celsia Esp (BOG:CELSIA) Business Description

Traded in Other Exchanges
N/A
Address
Carrera 43A No. 1A Sur - 143, Floor 5, Medellin, COL
Celsia SA Esp is a Latin American public utility company. Celsia is involved in the generation and sale of electrical energy and natural gas in Colombia, Panama, and Costa Rica. Through its principal subsidiary, Celsia Colombia S.A. E.S.P, the company owns and operates a portfolio of thermal, hydroelectric, and wind power plants. The company has two geographical operating segments namely Colombia and Central America. It generates maximum revenue from the Colombia segment. The company projects include Porvenir II and ReverdeC.

Celsia Esp (BOG:CELSIA) Headlines

No Headlines