Price to EPS Estimate Next Year
Calculates the forward P/E ratio using analyst consensus EPS estimates for the next fiscal year.
Syntax
=Price_EPSEstimateNextYear(Symbol)Examples
=Price_EPSEstimateNextYear("AAPL")When to Use
- Long-term valuation
- Growth projection analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Current year P/E | Price_EPSEstimateCurrentYear() |
Related Formulas
More MarketXLS Estimates formulas you can use in the same worksheet:
- Quarterly Earnings Growth YoY
- Target Price
- 5-Year EPS Growth Rate
- Actual EPS
- Analyst Consensus
- Earnings Estimates Consensus Eps Estimates Trends Current Est Fr1 Month Year
- Earnings Estimates Consensus Eps Estimates Trends Current Est Fr1 Value
- Earnings Estimates Consensus Eps Estimates Trends Current Est Fr2 Month Year
See Price_EPSEstimateNextYear used in a complete workbook: Earnings Surprise Screener Excel: Track Q1 2026 Earnings Beats and Misses in Real Time
Market data in your Excel sheets
1 billion usable data points on stocks, options, ETFs, and fundamentals, with simple Excel formulas.
See plans
▶
How does MarketXLS work?