Returns the Price to Earnings (P/E) ratio for a stock

Returns P/E based on next year EPS estimate

Returns the forward price-to-earnings ratio calculated using analyst consensus EPS estimates for the current fiscal year, providing a valuation metric based on expected near-term earnings.

Use when user asks for:
- Forward P/E ratio for current year
- Price to current year expected earnings
- Valuation using current fiscal year EPS estimates
- P/E based on analyst estimates for this year

Do NOT use when:
- Need trailing P/E ratio -> use PERatio()
- Need next year forward P/E -> use Price_EPSEstimateNextYear()
- Need raw EPS estimate -> use EPSEstimateCurrentY()
- Need historical P/E -> use hf_PE_ratio()

Calculates the forward P/E ratio using analyst consensus EPS estimates for the current fiscal year.

symbol

Returns P/E based on current year EPS estimate

Examples

When to Use

When NOT to Use

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Related Functions