Mean Target Price
Returns the average price target across all analysts covering the stock. This represents the consensus view of where analysts expect the stock price to be in 12 months.
Notes
- Most commonly referenced analyst target
- Average of all analyst 12-month price targets
- Compare with current price for expected return
Syntax
=TargetPriceMean(Symbol, [ReturnType])Returns
number
Mean analyst 12-month price target in USD
Examples
=TargetPriceMean("AAPL")=TargetPriceMean("MSFT")=(TargetPriceMean("AAPL")-Last("AAPL"))/Last("AAPL")*100When to Use
- Assessing analyst consensus expectations
- Calculating implied upside/downside
- Comparing analyst vs market view
- Stock screening by upside potential
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need price target range | Use both TargetPriceHigh() and TargetPriceLow() |
| Need current price | Last() |
| Need analyst count | AnalystConsensus() |
Common Issues & FAQ
How often do targets update?
Individual analyst targets update continuously. The mean reflects the latest from all covering analysts.
Why does the target differ from current price significantly?
Targets are 12-month projections. Large differences may indicate analysts see significant upside or that targets are stale.
Related Formulas
More MarketXLS Estimates formulas you can use in the same worksheet:
- Previous Earnings Report Date
- Previous Earnings Report Time
- Price to EPS Estimate Current Year
- Price to EPS Estimate Next Year
- Quarterly Earnings Growth YoY
- 5-Year EPS Growth Rate
- Actual EPS
- Earnings Estimates Consensus Eps Estimates Trends Current Est Fr1 Month Year
See TargetPriceMean used in a complete workbook: Analyst Ratings MCP Server: Live Price Targets and Consensus in Excel and AI
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?