EPS Estimate Next Quarter
Returns the analyst consensus estimate for Earnings Per Share (EPS) for the next fiscal quarter.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
Use Cases
- Pre-earnings analysis
- Quarterly trend monitoring
- Earnings surprise predictions
Syntax
=EPSEstimateNextQ(Symbol)Returns
number
Analyst consensus EPS estimate for next quarter
Examples
=EPSEstimateNextQ("AAPL")=EPSEstimateNextQ("MSFT")=EPSEstimateNextQ(A1)When to Use
- Pre-earnings season analysis
- Short-term earnings trends
- Quarterly earnings forecasting
- Earnings calendar preparations
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need current quarter estimate | EPSEstimateCurrentQ() |
| Need annual estimate | EPSEstimateNextY() |
| Need actual reported EPS | EarningsPerShare() |
Common Issues & FAQ
When does "next quarter" change?
After a company reports earnings, the next quarter shifts forward.
How accurate are quarterly estimates?
Accuracy varies; estimates typically become more accurate closer to earnings dates.
Excel Templates Using EPS Estimate Next Quarter
These ready-made MarketXLS templates call EPSEstimateNextQ() in their worksheet formulas. Open one to see the function working inside a complete model.
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 EPSEstimateNextQ used in a complete workbook: Industrials Earnings Tracker Excel: Q1 2026 Tariff Exposure Watchlist Built in MarketXLS
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?