Forward PE Ratio
Returns the forward price-to-earnings ratio, which compares the current stock price to analysts' estimated earnings per share for the next fiscal year.
Forward P/E = Current Price / Estimated Future EPS
Forward vs Trailing P/E
| Type | Based On | Use Case |
|---|---|---|
| Forward P/E | Future EPS estimates | Future expectations |
| Trailing P/E | Past 12 months EPS | Historical performance |
Interpretation
| Range | General Interpretation |
|---|---|
| < 15 | Potentially undervalued or low growth expected |
| 15 - 25 | Fair value for moderate growth |
| 25 - 40 | High growth expected |
| > 40 | Very high growth expected or speculative |
Notes
- Based on analyst consensus estimates
- Can be volatile as estimates change
- Compare with industry peers for context
Examples
When to Use
- Valuation analysis based on future expectations
- Comparing valuation across growth companies
- Screening for undervalued stocks
- Growth investing analysis
- Earnings expectations assessment
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need historical P/E | PE_ratio() or trailingPE() |
| Adjusting for growth | PEG_ratio() |
| Need EPS estimates | EPSEstimateCurrentY() |
| Companies with no earnings | Price_to_Sales() |
Common Issues & FAQ
Q: Why is forward P/E different from trailing P/E? A: Forward P/E uses estimated future earnings, while trailing P/E uses actual past earnings. Growing companies typically have lower forward P/E.
Q: Why might forward P/E be "NA"? A: Possible reasons:
- No analyst coverage for the stock
- Company has estimated negative earnings
- Insufficient data for estimates
Q: Which P/E should I use? A: Use forward P/E for growth analysis and trailing P/E for value analysis. Compare both for a complete picture.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?