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
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
Q: What is "consensus" estimate? A: It's the average of all analyst forecasts covering the stock.
Q: How often are estimates updated? A: Estimates update as analysts revise their forecasts, typically around earnings announcements.
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?