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

Examples

=EPSEstimateNextQ("AAPL")
Apple's next quarter EPS estimate
=EPSEstimateNextQ("MSFT")
Microsoft's next quarter estimate
Symbol from cell

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

Q: When does "next quarter" change? A: After a company reports earnings, the next quarter shifts forward.

Q: How accurate are quarterly estimates? A: Accuracy varies; estimates typically become more accurate closer to earnings dates.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use EPS Estimate Next Quarter and Other Financial Formulas
How does MarketXLS work?