Articles

How wide should an earnings guidance range be?

A range is a promise about how often the company will land inside it. Set the width from the size of your own forecasting errors, not from what looks tidy.

A company's internal forecast for next quarter is $1.20 of earnings per share, and its forecasts have missed by a standard deviation of $0.0475. A range meant to hold the result 80% of the time is $1.14 to $1.26, $0.12 wide, with a 10.3% chance of landing below it. A $0.06 range, plus or minus $0.03, would be missed on the low side 26.4% of the time.

The assumptions

Illustrative quarterly forecasting record, invented figures
QuarterActual less forecast, $Squared error, cents squared
Q1+0.0416
Q2−0.039
Q3+0.0525
Q4−0.0636
Q5+0.024
Q6−0.0416
Q7+0.0636
Q8−0.0416
Sum of squares158

The internal forecast for next quarter is $1.20. The errors average $0.00, so the forecast is unbiased on this record, and they are assumed to follow a normal distribution. Eight quarters is a thin sample; the figures below are only as good as the standard deviation, and a longer record would be better.

Step 1: the size of the company's own error

Sample variance = sum of squared errors ÷ (n − 1) = 158 ÷ 7 = 22.6 cents squared

Standard deviation = 4.75 cents, or $0.0475

Excel: =STDEV.S(B2:B9)

Step 2: the range that holds 80% of outcomes

Leave 10% of outcomes below the range and 10% above it, so the multiple of the standard deviation is NORM.S.INV(0.90) = 1.2816

Half-width = 1.2816 × 0.0475 = $0.0609

Range = 1.20 ± 0.0609 = 1.1391 to 1.2609, quoted as $1.14 to $1.26

Excel: =NORM.INV(0.10,1.2,0.0475)

Rounding to whole cents moves the coverage slightly: the quoted range holds 79.3% of outcomes, with 10.3% below it and 10.3% above it.

Step 3: what a narrower range costs

Chance of landing inside or below the range, by half-width
RangeWidth, $InsideBelow the low end
$1.17 to $1.230.0647.2%26.4%
$1.14 to $1.260.1279.3%10.3%
$1.11 to $1.290.1894.2%2.9%

Halving the width from $0.12 to $0.06 cuts the chance of landing inside the range from 79.3% to 47.2% and raises the chance of missing the low end from 10.3% to 26.4%. About 26.4% of quarters would then come in below the company's own guidance.

What if: guiding for the year instead of the quarter

If the four quarterly errors are independent, the annual standard deviation is 0.0475 × √4 = $0.0950

Annual half-width = 1.2816 × 0.0950 = $0.1218 around $4.80

As a share of the midpoint: quarterly ±5.1%, annual ±2.5%

Errors do not usually cancel that cleanly, because a bad assumption on pricing or costs carries from one quarter to the next. If they are correlated, the annual range has to be wider than 2.5%.

The common mistakes

Takeaway

Questions readers ask

How do you set the width of an earnings guidance range?

Take the standard deviation of past forecast errors and multiply it by the normal multiple for the coverage you want. Here $0.0475 times 1.2816 gives a half-width of $0.0609 for 80% coverage.

How often will the company miss the low end of its range?

With this range, 10.3% of the time. With a range of $1.17 to $1.23 it rises to 26.4%.

Should annual guidance be as wide as quarterly guidance?

Proportionally narrower if quarterly errors are independent: plus or minus 2.5% of the midpoint against 5.1%. If errors carry from quarter to quarter, it must be wider.

The workbooks behind this article

The free companion files for The Investor Relations Officer rebuild a fictional US listed company's earnings, guidance, consensus and shareholder base with live formulas. The forecasting record in this article is invented and is not in them. No account and no email address.

Open the companion files →

Not on Amazon: 19 paperbacks by Julian R. Sterling on markets, funds and compliance, printed on demand and shipped worldwide. Browse the bookshop →

Also on this site

Reading guide: corporate finance, valuation and markets → · All 1908 articles →