Price to EPS Estimate Current Year

Calculates the forward P/E ratio using analyst consensus EPS estimates for the current fiscal year.

Syntax

=Price_EPSEstimateCurrentYear(Symbol)
Excel Desktop (Windows)

Examples

=Price_EPSEstimateCurrentYear("AAPL")

When to Use

  • Forward valuation analysis
  • Growth stock comparison

When NOT to Use

Scenario Use Instead
Trailing P/E PERatio()

Market data in your Excel sheets

1 billion usable data points on stocks, options, ETFs, and fundamentals, with simple Excel formulas.

See plans
MarketXLS Excel Add-in Tutorial - How to Use Price to EPS Estimate Current Year and Other Financial Formulas
▶
How does MarketXLS work?