Forward P/E Ratio Template

Forward P/E Ratio Template

This forward P/E ratio template helps you find out the forward P/E ratio given the share price and earnings per share of stocks.

This is what the forward P/E ratio template looks like:

Download the Free Template

Enter your name and email in the form below and download the free template now!

The forward P/E ratio (or forward price-to-earnings ratio) divides the current share price of a company by the estimated future (“forward”) earnings per share (EPS) of that company.  For valuation purposes, a forward P/E ratio is typically considered more relevant than a historical P/E ratio.

The formula to calculate the forward P/E ratio is the same as the regular P/E ratio formula, however, estimated (or forecasted) earnings per share are used instead of historical figures.

Forward P/E formula:

Forward P/E = Current Share Price / Estimated Future Earnings per Share

More Free Templates

For more resources, check out our business templates library to download numerous free Excel modeling, PowerPoint presentation, and Word document templates.

• Excel Modeling Templates
• PowerPoint Presentation Templates
• Transaction Document Templates
• See all financial modeling resources
• See all Excel resources