GURUFOCUS.COM » STOCK LIST » Consumer Defensive » Retail - Defensive » Coles Group Ltd (ASX:COL) » Definitions » Graham Number

Coles Group (ASX:COL) Graham Number : A$4.30 (As of Dec. 2023)


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

What is Coles Group 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-04-29), the stock price of Coles Group is A$16.27. Coles Group's graham number for the quarter that ended in Dec. 2023 was A$4.30. Therefore, Coles Group's Price to Graham Number ratio for today is 3.78.

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

ASX:COL' s Price-to-Graham-Number Range Over the Past 10 Years
Min: 3.65   Med: 4.42   Max: 4.84
Current: 3.78

During the past 6 years, the highest Price to Graham Number ratio of Coles Group was 4.84. The lowest was 3.65. And the median was 4.42.

ASX:COL's Price-to-Graham-Number is ranked worse than
89.83% of 236 companies
in the Retail - Defensive industry
Industry Median: 1.265 vs ASX:COL: 3.78

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


Coles Group Graham Number Historical Data

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

Coles Group Graham Number Chart

Coles Group Annual Data
Trend Jun18 Jun19 Jun20 Jun21 Jun22 Jun23
Graham Number
Get a 7-Day Free Trial 5.05 3.49 3.76 4.08 4.15

Coles Group Semi-Annual Data
Dec18 Jun19 Dec19 Jun20 Dec20 Jun21 Dec21 Jun22 Dec22 Jun23 Dec23
Graham Number Get a 7-Day Free Trial Premium Member Only Premium Member Only Premium Member Only 3.88 4.09 4.58 4.17 4.30

Competitive Comparison of Coles Group's Graham Number

For the Grocery Stores subindustry, Coles Group'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.


Coles Group's Price-to-Graham-Number Distribution in the Retail - Defensive Industry

For the Retail - Defensive industry and Consumer Defensive sector, Coles Group's Price-to-Graham-Number distribution charts can be found below:

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



Coles Group Graham Number Calculation

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

Coles Group's Graham Number for the fiscal year that ended in Jun. 2023 is calculated as

Graham Number
=sqrt of (22.5* Tangible Book per Share *EPS without NRI)
=sqrt of (22.5*0.991*0.773)
=4.15

Coles Group's Graham Number for the quarter that ended in Dec. 2023 is calculated as

Graham Number
=sqrt of (22.5*Tangible Book per Share*EPS without NRI (TTM))
=sqrt of (22.5*1.082*0.76)
=4.30

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


Coles Group  (ASX:COL) 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.

Coles Group's Price to Graham number Ratio for today is calculated as

Price to Graham number=Share Price (Today)/Graham number (Q: Dec. 2023 )
=16.27/4.30
=3.78

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


Coles Group Graham Number Related Terms

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


Coles Group (ASX:COL) Business Description

Traded in Other Exchanges
Address
800-838 Toorak Road, Hawthorn East, Melbourne, VIC, AUS, 3123
Coles Group Limited is one of Australia's largest retailers, operating the second-largest supermarket chain behind market leader Woolworths, and is the country's third-largest liquor retailer. The group has an extensive store network of about 2,500 store outlets and roughly 80% of Australian live within a 10-minute drive from their nearest Coles store. The retailer employs some 110,000 people, who process over 20 million individual customer transactions a week. This compares with Woolworths processing almost 30 million customer transactions per week from Australia's population of 25 million.

Coles Group (ASX:COL) Headlines

From GuruFocus

Rockwell Collins Inc: Fundamental Stock Research Analysis

By FAST Graphs FAST Graphs 12-13-2012

Fairfax's Prem Watsa Goes 2 for 2 in 3rd Quarter

By Sydnee Gatewood Sydnee Gatewood 11-14-2018

Tudor Investment buys Verizon, PayPal, Electronic Arts

By Tiziano Frateschi Tiziano Frateschi 11-29-2017

The Best Dividends on May 10, 2012

By Dividend Dividend 05-09-2012

Rockwell Collins Inc. (COL) Sr. VP and CFO Patrick E Allen sells 19,000 Shares

By GuruFocus Research GuruFocus Editor 04-30-2010

Westport Funds Portfolio Review as of Dec. 31, 2013

By Holly LaFon Holly LaFon 03-26-2014