Share your opinion and earn yourself a free Motley Fool premium report!

We are looking for Fools to join a 75 minute online independent market research forum on 15th / 16th December.

To find out more and express your interest please click here

Play The Percentages With National Grid plc

How reliable are earnings forecasts for National Grid plc (LON:NG) — and is the stock attractively priced right now?

| More on:

The content of this article was relevant at the time of publishing. Circumstances change continuously and caution should therefore be exercised when relying upon any content contained within this article.

You’re reading a free article with opinions that may differ from The Motley Fool’s Premium Investing Services. Become a Motley Fool member today to get instant access to our top analyst recommendations, in-depth research, investing resources, and more. Learn More.

The price-to-earnings (P/E) ratio is probably the single most popular valuation measure used by investors. It’s easy to calculate: share price divided by earnings per share (EPS), with EPS typically being the consensus of City analysts’ forecasts for the current year.

Now, the consensus is a useful shorthand, but it can pay investors to take a closer look at the analysts’ forecasts, and — what I call — ‘play the percentages’. Today, I’m analysing National Grid (LSE: NG) (NYSE: NGG.US).

The spread

By playing the percentages, I mean looking beyond the consensus EPS forecast to the spread between the most bullish and bearish EPS scenarios. The spread varies from company to company, giving different magnitudes of variance in the potential P/E.

The table below shows the effect of different EPS spreads on a company with a consensus P/E of 14 (the long-term FTSE 100 average).

EPS spread Bull extreme P/E Consensus P/E Bear extreme P/E
Narrow 10% (+ and – 5%) 13.3 14.0 14.7
Average 40% (+ and – 20%) 11.7 14.0 17.5
Wide 100% (+ and – 50%) 9.3 14.0 28.0

In the case of the narrow spread, you probably wouldn’t be too unhappy if the bear analyst’s EPS forecast panned out, and you found you’d bought on a P/E of 14.7, rather than the expected 14. But how about if the bear analyst was on the button in the case of the wide spread? Not so happy, I’d imagine!

National Grid

The table below summarises my playing-the-percentages data for National Grid.

Share price: 820p Forecast EPS +/- consensus P/E
Consensus 52.0p n/a 15.8
Bull extreme 53.5p +3% 15.3
Bear extreme 50.3p -3% 16.3

As you can see, the most bullish EPS forecast is just 3% higher than the consensus, while the most bearish is just 3% lower. This 6% spread between the extremes is currently the narrowest among the companies I’m looking at. It means that, barring any major unforeseen events, we can have a high degree of confidence in the earnings multiple we’re paying: a P/E somewhere within a tight band of 15.3 to 16.3.

national gridAs a regulated utility, National Grid’s management — and City analysts — have good visibility on earnings; the current UK regulatory pricing regime runs to 2021. Furthermore, National Grid, with its focus on electricity wires and gas pipes, is not mired in the current political hullabaloo and uncertainty surrounding UK consumer-facing utilities, such as Centrica (British Gas) and SSE (Southern Electric and other brands).

The price investors have to pay for National Grid’s good earnings visibility and level of confidence in the earnings multiple is a P/E at a premium to both the long-term FTSE 100 average and the current consensus ratings of Centrica and SSE.

National Grid’s P/E seems a little rich to me right now — the stock was more attractively-valued for much of last year — and I suspect a good chunk of institutional money has moved out of Centrica and SSE, and found its way into National Grid, pushing up the price and rating.

G A Chester does not own any shares mentioned in this article.

More on Investing Articles

Group of four young adults toasting with Flying Horse cans in Brazil
Investing Articles

Down 56% with a 4.8% yield and P/E of 13 – are Diageo shares a generational bargain?

When Harvey Jones bought Diageo shares he never dreamed they'd perform this badly. Now he's wondering if they're just too…

Read more »

Number three written on white chat bubble on blue background
Investing Articles

Could these 3 holdings in my Stocks and Shares ISA really increase in value by 25% in 2026?

James Beard’s been looking at the 12-month share price forecasts for some of the positions in his Stocks and Shares…

Read more »

National Grid engineers at a substation
Investing Articles

2 reasons I‘m not touching National Grid shares with a bargepole!

Many private investors like the passive income prospects they see in National Grid shares. So why does our writer not…

Read more »

Number 5 foil balloon and gold confetti on black.
Investing Articles

£10,000 invested in Greggs shares 5 years ago would have generated this much in dividends…

Those who invested in Greggs shares five years ago have seen little share price growth. However, the dividends have been…

Read more »

Rolls-Royce Hydrogen Test Rig at Loughborough University
Growth Shares

Here is the Rolls-Royce share price performance for 2023, 2024, and 2025

Where will the Rolls-Royce share price be at the end of 2026? Looking at previous years might help us find…

Read more »

Investing Articles

This FTSE 250 stock could rocket 49%, say brokers

Ben McPoland takes a closer look at a market-leading FTSE 250 company that generates plenty of cash and has begun…

Read more »

Portrait of elderly man wearing white denim shirt and glasses looking up with hand on chin. Thoughtful senior entrepreneur, studio shot against grey background.
Investing Articles

Does ChatGPT suggest selling this S&P 500 stock, down 30% in 2025?

The share price of this S&P 500 stalwart has crashed by over 30% in the last 12 months. Yes, I'm…

Read more »

Young mixed-race couple sat on the beach looking out over the sea
Investing Articles

How big a Stocks and Shares ISA is needed to earn £1,000 of passive income each month?

Christopher Ruane does the maths and explains how a Stocks and Shares ISA could potentially generate a four-figure monthly passive…

Read more »