Calculate forward P/E from estimates

You can use underlying SheetsFinance data to calculate a forward P/E ratio. Combine the current real-time price with the average analyst EPS estimate to build it yourself.

The formula

Forward P/E = current stock price ÷ estimated EPS.

=SF("AAPL") / SF("AAPL", "estimates", "epsAvg")

Or with explicit cell references:

=A2 / B2

where A2 is the current price and B2 is the estimate.

Where to get the inputs

• Current price: =SF("SYMBOL") returns the real-time price by default.

• EPS estimate: =SF("SYMBOL", "estimates", "epsAvg") returns the average analyst estimate for the next fiscal year.

Quarterly estimates

For a quarterly forward P/E, target a specific fiscal quarter:

=SF("AAPL") / SF("AAPL", "estimatesQ", "epsAvg", "2026", "calYear")

Pre-built alternatives

SheetsFinance does provide a forward P/E growth ratio directly:

=SF("AAPL", "ratios", "forwardPriceToEarningsGrowthRatio", "ttm")

For a trailing P/E, use:

=SF("AAPL", "ratios", "priceToEarningsRatio", "ttm")

For an annual trailing P/E, replace ttm with a year:

=SF("AAPL", "ratios", "priceToEarningsRatio", "2023")

For a quarterly P/E, use ratiosQ1, ratiosQ2, ratiosQ3, or ratiosQ4 as the type and pass a year:

=SF("AAPL", "ratiosQ4", "priceToEarningsRatio", "2023")

What is next

For more on analyst estimates, read Analyst Estimates. For other custom calculations, see Financial Formulas.