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
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
Q: When do estimates update? A: Estimates update continuously as analysts revise their models. Major updates often occur around earnings reports.
Q: How accurate are consensus estimates? A: Consensus estimates are often close but not exact. Companies frequently beat or miss by small amounts.
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?