Price to EPS Estimate Current Year
Calculates the forward P/E ratio using analyst consensus EPS estimates for the current fiscal year.
Syntax
=Price_EPSEstimateCurrentYear(Symbol)Examples
=Price_EPSEstimateCurrentYear("AAPL")When to Use
- Forward valuation analysis
- Growth stock comparison
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Trailing P/E | PERatio() |
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_EPSEstimateCurrentYear used in a complete workbook: Earnings Surprise Screener Excel: Track Q1 2026 Earnings Beats and Misses in Real Time
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?