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.