Next Quarter EPS Estimate

Returns the consensus analyst estimate for earnings per share in the next fiscal quarter. Useful for looking ahead beyond the current quarter.

Notes

  • Forward-looking one quarter ahead
  • Updates continuously as analysts revise
  • Use for modeling future earnings

Examples

=NextQuarterEPSEstimate("AAPL")
Next quarter estimate for Apple
=NextQuarterEPSEstimate("MSFT")
Next quarter for Microsoft

When to Use

  • Forward earnings projections
  • Modeling next quarter expectations
  • Comparing sequential quarter growth expectations

When NOT to Use

Scenario Use Instead
Need current quarter CurrentQuarterEPSEstimate() or EPSEstimate()
Need full year CurrentYearEPSEstimate() or NextYearEPSEstimate()

Common Issues & FAQ

Q: How far ahead is "next quarter"? A: It's the fiscal quarter immediately following the current one being reported.

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 Next Quarter EPS Estimate and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions