Skip to content
All library documents

Choosing an Earnings Measure for Weekly P/E Ratios

Article Quant Q&A · Author: Sunv

Summary

The document asks how to pair weekly share prices with earnings when calculating price-to-earnings ratios. The responses explain that the earnings measure depends on the purpose of the analysis and the data available. Trailing twelve-month earnings are presented as a practical choice when analyst estimates are unavailable; forward P/E needs next fiscal year estimates, while next-twelve-month P/E needs quarterly estimates. Cyclically adjusted P/E is mentioned for longer horizon analysis.

The discussion emphasizes that P/E is not a single mechanically precise measure: adjustments, such as excluding one-off items, and the chosen horizon reflect an investment thesis. Backward-looking and forward-looking measures may capture different assumptions about how the market values current earnings or anticipated growth. The exchange suggests comparing candidate measures in a backtest when forecasting returns, but gives no results or specific empirical procedure. It does not establish that one measure is universally preferable, and weekly sampling of prices does not itself determine the appropriate earnings period.

Key ideas

  • Trailing twelve-month earnings are a practical denominator when forward estimates are unavailable.
  • Forward P/E and next-twelve-month P/E require different forecast inputs.
  • Cyclically adjusted P/E may suit analysis over longer horizons.
  • The chosen earnings measure should follow the investment thesis and the assumptions being tested.
  • Candidate P/E definitions can be compared by their predictive performance in a backtest.

Tags

Full text
# Calculation of weekly P/E ratio


# Calculation of weekly P/E ratio












The P/E-ratio is defined as $$ \frac{\text{Market value per share}}{\text{Earnings per share (EPS)}} $$ I have weekly observations of stock prices, but what measure should I use for EPS? Should it for example be the EPS of the previous 12 months? What is the typical approach?

References to journal papers computing weekly P/E-ratios are very welcome.

## Answer by ProbablePattern (score 1)

https://quant.stackexchange.com/a/14678

I strongly recommend reading an undergraduate finance textbook like Investments by Bodie, Kane, and Marcus. Your methodology may be limited by your data. For example, using forward P/E requires next fiscal year's EPS estimates. NTM (next twelve months) requires quarterly EPS estimates. If you do not have estimates, the best method is TTM (trailing twelve months). For longer time horizons, you may want to look at CAPE (cyclically adjusted P/E).

## Answer by pincopallino (score 1)

https://quant.stackexchange.com/a/14692

I think you are confusing the goal with the means. The calculation of the PE is not the goal, the true goal is assessing whether a particular stock is an interesting investment opportunity (cheap) under an investment thesis (set of hypotheses).

Therefore, there is an infinite number of ways to calculate PE ratios, as a results of a set of different assumptions as well as a result of an infinite adjustments deemed necessary by the analyst (removing the contribution of one-off items, for example). This also explains why the definition of PE ratio, as per textbooks, is not really "precise" as you may otherwise expect coming from a more technical background.

It is hard to recommend a PE calculation methodology without knowing your investment thesis.

EDIT

I believe that even under a panel data model framework the choice of PE should be motivate and interpreted through a fundamental approach. Let me make a couple of examples:

- Trailing 12M PE and Last FY: backward looking metrics tend to favor an "as-it-is" approach, ie assuming company bottom line might not change. Does the market "revalues" current bottom lines? What is the pattern there?

- Forward looking PE metrics: How far does the market look? 1-qr, 1-yr and 2-yr growth assumptions might offer different performances, although probably correlated as intuition suggests. @ProbablyPattern suggests the use of CAPE, it is a great hint.



Bottom Line:

- Different PEs might try to capture different market dynamics. You might even try to combine a few metrics - For example backward looking PEs and EPS growth expectations

- I guess it is important to understand what the choice of PE implies

## Answer by emcor (score 0)

https://quant.stackexchange.com/a/14700

As your model is to predict stock returns via P/E, I suggest you try out all possible P/E's in a backtest and select the one with best forecast ability(lowest forecast error).

Shown in full with attribution under the source's licence. Licence: CC BY-SA 4.0 (Stack Exchange)

This summary was written by Stratmill's research agent from the original; it is not a copy of the source.