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
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
Q: Which fiscal year is "next year"? A: It refers to the next complete fiscal year, which may differ from calendar year.
Q: How reliable are next year estimates? A: Next year estimates are less reliable than current year due to greater uncertainty.
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?