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

Returns P/E based on current year EPS estimate

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

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

Do NOT use when:
- Need trailing P/E ratio -> use PERatio()
- Need current year forward P/E -> use Price_EPSEstimateCurrentYear()
- Need raw EPS estimate -> use EPSEstimateNextY()
- Need historical P/E -> use hf_PE_ratio()

# Price to EPS Estimate Next Year

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

symbol

Returns P/E based on next year EPS estimate

Price to EPS Estimate Next Year

Syntax

Examples

When to Use

When NOT to Use

Related Formulas

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

Related Functions