Valuing Electric Utility Stocks with the Graham Number

Screen for undervalued utilities with the Graham Number and a web-connected spreadsheet with live financial updates.

Utility companies are a core component of long-term investment planning. They’re stable, pay consistent dividends and sell a product that people will always want.

The Graham Number is a simple method of screening for undervalued stocks. Introduced by Benjamin Graham in his seminal book “The Intelligent Investor”, it’s equal to the square root of (22.5 x EPS x Book value per share). A stock is undervalued if the current market price is lower than its Graham Number

This web-connected spreadsheet has a list of electric utilities traded on the NYSE (and a few others). It downloads the market capitalization, last trade price, PE ratio, book value and EPS.

A spreadsheet with a list of electric utility companies, financial data, and the Graham Number

Some VBA then calculate the Graham Number for each utility. Undervalued utilities are highlighted in green, while those that are overvalued are highlighted in red. If you update the spreadsheet, you get the latest Graham Number.

Here’s a summary of the results, correct as of 21st February 2015.

Of course, the Graham Number shouldn’t be used in isolation. Benjamin Graham dictated that a company should meet several criteria before being valued by the Graham Number. These include uninterrupted earnings for the last ten years, a current ratio of over 2, consistent dividends for the last twenty years, and several others.

Get Spreadsheet to Value Electric Utility Stocks with Graham Number

It's only fair to share...Share on FacebookShare on Google+Tweet about this on Twitter

Leave a Reply

Your email address will not be published. Required fields are marked *