Next Year EPS Estimate

Returns the consensus analyst estimate for full-year earnings per share in the next fiscal year. Useful for forward P/E and growth calculations.

Notes

  • Looking one full fiscal year ahead
  • Used for forward P/E calculations
  • Shows expected earnings growth trajectory

Examples

=NextYearEPSEstimate("AAPL")
Next FY estimate
=(NextYearEPSEstimate("AAPL")-CurrentYearEPSEstimate("AAPL"))/CurrentYearEPSEstimate("AAPL")*100
YoY growth %

When to Use

  • Forward earnings projections
  • Calculating forward P/E ratio
  • Year-over-year growth expectations

When NOT to Use

Scenario Use Instead
Need current year CurrentYearEPSEstimate()
Need quarterly data NextQuarterEPSEstimate()
Need 5-year growth rate EPSGrowth5Y()

Common Issues & FAQ

Q: How far ahead is next year? A: It's the fiscal year following the current fiscal year, typically 1-2 years from now depending on where in the current FY.

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

Related Functions