EPS Estimate
Returns the consensus analyst earnings per share (EPS) estimate for the current quarter. This is what analysts collectively expect the company to earn.
Return Value
Returns the consensus EPS estimate in USD.
Notes
- Updates as analysts revise their estimates
- Compare with
EPSActual()after earnings to see surprise - Based on current quarter expectations
Syntax
=EPSEstimate(Symbol, [ReturnType])Examples
=EPSEstimate("AAPL")=EPSEstimate("MSFT")=EPSActual("AAPL")-EPSEstimate("AAPL")When to Use
- Pre-earnings analysis
- Setting expectations before earnings reports
- Calculating potential earnings surprise
- Comparing company performance vs expectations
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need actual reported EPS | EPSActual() |
| Need next quarter estimate | NextQuarterEPSEstimate() |
| Need annual estimate | CurrentYearEPSEstimate() |
| Need surprise amount | EPSSurprise() |
Common Issues & FAQ
When do estimates update?
Estimates update continuously as analysts revise their models. Major updates often occur around earnings reports.
How accurate are consensus estimates?
Consensus estimates are often close but not exact. Companies frequently beat or miss by small amounts.
Related Formulas
More MarketXLS Estimates formulas you can use in the same worksheet:
- EPS Estimate Current Quarter
- EPS Estimate Current Year
- EPS Estimate Next Quarter
- EPS Estimate Next Year
- EPSEstimate Current Quarter
- EPSEstimate Current Year
- EPSEstimate Next Quarter
- EPSEstimate Next Year
See EPSEstimate used in a complete workbook: Regional Bank Earnings Tracker Excel: A Yield Curve Watchlist for Q1 2026
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?