GURUFOCUS.COM » STOCK LIST » Utilities » Utilities - Regulated » Xcel Energy Inc (NAS:XEL) » Definitions » Graham Number

Xcel Energy (Xcel Energy) Graham Number

: $48.84 (As of Dec. 2023)
View and export this data going back to 1993. Start your Free Trial

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-18), the stock price of Xcel Energy is $53.20. Xcel Energy's graham number for the quarter that ended in Dec. 2023 was $48.84. Therefore, Xcel Energy's Price to Graham Number ratio for today is 1.09.

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

XEL' s Price-to-Graham-Number Range Over the Past 10 Years
Min: 1.09   Med: 1.39   Max: 1.7
Current: 1.09

During the past 13 years, the highest Price to Graham Number ratio of Xcel Energy was 1.70. The lowest was 1.09. And the median was 1.39.

XEL's Price-to-Graham-Number is ranked better than
52.44% of 410 companies
in the Utilities - Regulated industry
Industry Median: 1.125 vs XEL: 1.09

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


Xcel Energy Graham Number Historical Data

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

Xcel Energy Annual Data
Trend Dec14 Dec15 Dec16 Dec17 Dec18 Dec19 Dec20 Dec21 Dec22 Dec23
Graham Number
Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only 37.38 41.26 43.72 46.52 48.92

Xcel Energy Quarterly Data
Mar19 Jun19 Sep19 Dec19 Mar20 Jun20 Sep20 Dec20 Mar21 Jun21 Sep21 Dec21 Mar22 Jun22 Sep22 Dec22 Mar23 Jun23 Sep23 Dec23
Graham Number 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 Premium Member Only Premium Member Only Premium Member Only 46.17 46.92 46.63 47.53 48.84

Competitive Comparison

For the Utilities - Regulated Electric subindustry, Xcel Energy'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.


Xcel Energy Price-to-Graham-Number Distribution

For the Utilities - Regulated industry and Utilities sector, Xcel Energy's Price-to-Graham-Number distribution charts can be found below:

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



Xcel Energy Graham Number Calculation

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

Xcel Energy'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*31.744*3.35)
=48.92

Xcel Energy'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*31.744*3.34)
=48.84

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


Xcel Energy  (NAS:XEL) 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.

Xcel Energy's Price to Graham number Ratio for today is calculated as

Price to Graham number=Share Price (Today)/Graham number (Q: Dec. 2023 )
=53.20/48.84
=1.09

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


Xcel Energy Graham Number Related Terms

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


Xcel Energy (Xcel Energy) Business Description

Traded in Other Exchanges
Address
414 Nicollet Mall, Minneapolis, MN, USA, 55401
Xcel Energy manages utilities serving 3.8 million electric customers and 2.1 million natural gas customers in eight states. Its utilities are Northern States Power, which serves customers in Minnesota, North Dakota, South Dakota, Wisconsin, and Michigan; Public Service Company of Colorado; and Southwestern Public Service Company, which serves customers in Texas and New Mexico. It is one of the largest renewable energy owners and suppliers in the U.S. with more than half of its electricity sales coming from carbon-free energy.
Executives
Robert Frenzel director, officer: Chairman, President and CEO 414 NICOLLET MALL, MINNEAPOLIS MN 55401
Amanda J Rome officer: EVP, Group President Utilities 414 NICOLLET MALL, MINNEAPOLIS MN 55401
Timothy A Welsh director 800 NICOLLET MALL, MINNEAPOLIS MN 55402
Netha N. Johnson director 3489 CRESTMOOR DRIVE, WOODBURY MN 55125
Patricia L Kampling director PO BOX 2568, MADISON WI 53701
Megan D Burkhart director 1717 MAIN STREET, DALLAS TX 75201
George J Kehl director 414 NICOLLET MALL, MINNEAPOLIS MN 55401
James T Prokopanko director 25990 BIRCH BLUFF ROAD, EXCELSIOR MN 55331
Lynn Casey director 414 NICOLLET MALL, MINNEAPOLIS MN 55401
Kim Williams director C/O WEYERHAEUSER COMPANY, 220 OCCIDENTAL AVENUE SOUTH, SEATTLE WA 98104
Richard T Obrien director 6363 SOUTH FIDDLERS GREEN CIRCLE, GREENWOOD VILLAGE CO 80111
Charles G Pardee director 10 SOUTH DEARBORN STREET, 54TH FLOOR, CHICAGO IL 60603
Daniel Yohannes director 414 NICOLLET MALL, MINNEAPOLIS MN 55014
Christopher J. Policinski director 4001 LEXINGTON AVENUE N., ARDEN HILLS MN 55126
Brett C Carter officer: EVP, Group President Utilitie, other: Chief Customer Officer 414 NICOLLET MALL, 401-9, MINNEAPOLIS MN 55401

Xcel Energy (Xcel Energy) Headlines

From GuruFocus

Q4 2020 Xcel Energy Inc Earnings Call Transcript

By GuruFocus Research 01-23-2024

Q1 2019 Xcel Energy Inc Earnings Call Transcript

By GuruFocus Research 01-23-2024

Q2 2019 Xcel Energy Inc Earnings Call Transcript

By GuruFocus Research 01-23-2024

Xcel Energy Inc Annual Shareholders Meeting Transcript

By GuruFocus Research 01-23-2024

Q2 2022 Xcel Energy Inc Earnings Call Transcript

By GuruFocus Research 01-23-2024

Xcel Energy Inc's Dividend Analysis

By GuruFocus Research 12-26-2023

Q3 2023 Xcel Energy Inc Earnings Call Transcript

By GuruFocus Research 01-23-2024

Q3 2021 Xcel Energy Inc Earnings Call Transcript

By GuruFocus Research 01-23-2024

Q2 2020 Xcel Energy Inc Earnings Call Transcript

By GuruFocus Research 01-23-2024

Q4 2019 Xcel Energy Inc Earnings Call Transcript

By GuruFocus Research 01-23-2024