EPS Estimate Next Year
Returns the analyst consensus estimate for Earnings Per Share (EPS) for the next fiscal year. Useful for forward-looking valuation analysis.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
Use Cases
- Calculate forward P/E ratio (1-year forward)
- Earnings growth analysis
- Long-term valuation models
- PEG ratio calculations
Syntax
=EPSEstimateNextY(Symbol)Returns
number
Analyst consensus EPS estimate for next fiscal year
Examples
=EPSEstimateNextY("AAPL")=EPSEstimateNextY("MSFT")=(EPSEstimateNextY("AAPL")-EPSEstimateCurrentY("AAPL"))/EPSEstimateCurrentY("AAPL")=EPSEstimateNextY(A1)When to Use
- Forward-looking P/E calculations
- EPS growth analysis
- Long-term valuation models
- Comparing growth expectations across stocks
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need current year estimate | EPSEstimateCurrentY() |
| Need actual reported EPS | EarningsPerShare() |
| Need quarterly estimate | EPSEstimateNextQ() |
Common Issues & FAQ
Which fiscal year is "next year"?
It refers to the next complete fiscal year, which may differ from calendar year.
How reliable are next year estimates?
Next year estimates are less reliable than current year due to greater uncertainty.
Related Formulas
More MarketXLS Estimates formulas you can use in the same worksheet:
- EPS Surprise
- EPS Surprise Percentage
- EPSEstimate Current Quarter
- EPSEstimate Current Year
- EPSEstimate Next Quarter
- EPSEstimate Next Year
- High Target Price
- Low Target Price
See EPSEstimateNextY used in a complete workbook: GARP Screener Excel: Growth at Reasonable Price Dashboard for May 2026
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?