Skip to main content
Track Linear regression
15 / 43
Library

1993issue C081-13

Auditing an index price-earnings multiple with short-rate regression

A historical least-squares workflow used a scatterplot screen to decide which interest-rate pairing could enter a linear model of an index price-earnings multiple, then treated the fit statistics as a check on the contemporaneous valuation setting.

  • A scatterplot screen dropped the long-term yield pairing as nonlinear and kept the short-term yield pairing as linear enough for least-squares.
  • A one-variable short-rate fit reported an adjusted R-squared of 0.76, a standard error of 0.06, and a negative coefficient, and it followed the multiple's broad direction without capturing every turning point.
  • Adding index dividend yield raised adjusted R-squared to 0.88, lowered the standard error to 0.04, kept both coefficients negative, and left residuals described as largely random.
  • The two-variable specification was characterized as better for judging the contemporaneous valuation setting than for producing a forecast, and the write-up recommended repeating the exercise under different interest-rate regimes.
Entries in this reading1 entry

A linear fit for an index multiple

A least-squares linear regression was used to relate ordered interest-rate and equity-yield observations to a broad equity-index price-earnings multiple. The candidate inputs were a 30-year constant-maturity Treasury yield, a 90-day Treasury-bill yield, the index dividend yield, and the same index price-earnings multiple.

Which pairing survived the screen

A scatter of long-term yields against the index multiple was judged nonlinear, so that pairing was not carried into the linear specification. A scatter of short-term yields against the index multiple was judged linear enough to justify further least-squares work.

Reading the one-variable fit

A one-variable fit of short-term rates to the multiple produced an adjusted R-squared of 0.76, a standard error of 0.06, and a negative short-rate coefficient. A visual overlay of that one-variable fit followed the multiple's broad direction but did not capture every turning point.

Adding dividend yield

Adding the index dividend yield produced a multiple linear regression against the same price-earnings multiple. Adjusted R-squared rose from 0.76 to 0.88 and the regression standard error fell from 0.06 to 0.04, with both coefficients remaining negative.

Residual plots for the two-variable fit were described as largely random, which was taken as informal evidence that leftover errors were not strongly correlated.

Short-rate and S&P yield coefficients for the S&P 500 P/E

In the two-variable least-squares model both terms keep a negative sign, so lower short rates and a thinner S&P 500 dividend yield line up with a richer contemporaneous multiple. The yield coefficient is larger in magnitude than the short-rate coefficient, which is the specification check the article asks a trader to read before treating the multiple as justified by the rate setting. Figures are the Excel regression coefficients printed in the Model 2 table (119 monthly observations), not a redigitized curve.
In the two-variable least-squares model both terms keep a negative sign, so lower short rates and a thinner S&P 500 dividend yield line up with a richer contemporaneous multiple. The yield coefficient is larger in magnitude than the short-rate coefficient, which is the specification check the article asks a trader to read before treating the multiple as justified by the rate setting. Figures are the Excel regression coefficients printed in the Model 2 table (119 monthly observations), not a redigitized curve.S&P 500 · Monthly · 1983-02-01T00:00:00.000Z to 1993-02-28T00:00:00.000Z

The printed table reports R-square and adjusted R-square of 0.89 and a standard error of 0.04; the article prose rounds the fit to 0.88. Karczewski treats the equation as a check on the current multiple, not a turning-point forecast, and notes that an unusually low rate regime can change the coefficients if the sample is lengthened.

A contemporaneous check, not a turning-point tool

The two-variable specification was characterized as more suitable for judging the contemporaneous valuation setting than for producing a forecast.

The write-up recommended repeating the least-squares exercise under different interest-rate regimes because the method tends to force a fit toward the bulk of the sample.

Educational research material, not investment advice. Historical source context does not establish present-day performance.
15 of 43 in the Linear regression track
19941-2 pp.Next on Linear regressionRegression-seeded nested exponential price filterA linear fit on an initial block of closes can supply the intercept and slope that open both exponential averages.
All readings on this track · 43 readings
  1. 1990Constructing dollar baselines from rates, inflation, and residuals
  2. 1990Constructing a nominal index value from forward earnings and fitted yield
  3. 1990Constructing a nominal index price from earnings and a fitted yield
  4. 1990Endpoint-pinned price paths are not forecasts
  5. 1990Constructing least-squares polynomial smoothers
  6. 1991Endpoint growth rates versus linear-regression consistency
  7. 1991Out-of-sample checks for linear growth fits
  8. 1991Trend as persistence, not a straight line
  9. 1991Quadratic trend, residual oscillator, and a secondary cycle calendar
  10. 1991Time-origin offset and residual-price divergence on a quadratic least-squares fit
  11. 1991A least-squares trendline from ordered prices
  12. 1992Constructing log-linear growth and reliability screens
  13. 1992Constructing log-linear growth-rate baselines
  14. 1992Next-session high, low, and close from rolling linear regression
  15. 1993Auditing an index price-earnings multiple with short-rate regression
  16. 1994Regression-seeded nested exponential price filter
  17. 1994Constructing the double exponential average from lag cancellation
  18. 1994Evaluating money supply as a linear leading-index baseline
  19. 1995Constructing least-squares trend channels
  20. 1995Linear baseline holdout checks for annual bill-rate forecasts
  21. 1995Projection bands from high and low regression slopes
  22. 1995Evaluating a least-squares end-point moving average on a known test series
  23. 1996Constructing an endpoint moving average from a least-squares line
  24. 1996Scoring equity path consistency with a k-ratio overlay
  25. 1996Evaluating month-end yield gaps for equity regimes
  26. 1996Constructing session-indexed standard error bands
  27. 1998Evaluating linear regression baselines for index valuation
  28. 1998R-squared as a two-state trend filter from a price-time fit
  29. 2000Second-order moving-average lag correction
  30. 2002Price regression line versus beta for index tracking
  31. 2003Regression slope with an r-squared trend confidence gate
  32. 2003Constructing finite-volume-element divergence with slope comparison
  33. 2004Building a daily score from regression, retracement, and volume
  34. 2004Constructing least-squares trendlines from ordered prices
  35. 2007Rectangle breakout targets beyond height
  36. 2007Confirming a price trend with regression slope and r-squared
  37. 2008A linear-regression angle assembled as one trend filter
  38. 2010A two-state swing machine from four running extremes
  39. 2016Score oil-complex tightness before divergence or regression
  40. 2017Nikkei-yen intermarket divergence as a regime case study
  41. 2017Constructing Calmar ratio and linear regression baselines
  42. 2019Pair-trade layer construction versus average-spread management
  43. 2020A convolution slope built from nested linear regression
All 112 readings tagged Linear regression
Also on Linear regression5 readings