EPS Estimate Current Year
Returns the analyst consensus estimate for Earnings Per Share (EPS) for the current fiscal year. This represents the average of analyst forecasts.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
Understanding EPS Estimates
- Consensus estimate: Average of all analyst forecasts
- Updated regularly as analysts revise estimates
- Used to calculate forward P/E ratio
- Earnings surprises = Actual EPS vs Estimate
Syntax
=EPSEstimateCurrentY(Symbol)Examples
=EPSEstimateCurrentY("AAPL")=EPSEstimateCurrentY("MSFT")=Last("AAPL")/EPSEstimateCurrentY("AAPL")=EPSEstimateCurrentY(A1)When to Use
- Calculating forward P/E ratios
- Valuation analysis
- Comparing expected vs actual earnings
- Building earnings estimate models
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need actual reported EPS | EarningsPerShare() |
| Need next year estimate | EPSEstimateNextY() |
| Need quarterly estimate | EPSEstimateCurrentQ() |
Common Issues & FAQ
What is "consensus" estimate?
It's the average of all analyst forecasts covering the stock.
How often are estimates updated?
Estimates update as analysts revise their forecasts, typically around earnings announcements.
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 EPSEstimateCurrentY used in a complete workbook: Earnings Surprise Screener Excel: Track Q1 2026 Earnings Beats and Misses in Real Time
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?