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:
![Forward P/E Ratio Template Screenshot]()
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)Earnings Per Share Formula (EPS)EPS is a financial ratio, which divides net earnings available to common shareholders by the average outstanding shares over a certain period of time. of that company. For valuation purposesValuation MethodsWhen valuing a company as a going concern there are three main valuation methods used: DCF analysis, comparable companies, and precedent transactions, 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 ratioPrice Earnings RatioThe Price Earnings Ratio (P/E Ratio is the relationship between a company’s stock price and earnings per share. It provides a better sense of the value of a company. 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 TemplatesExcel & Financial Model TemplatesDownload free financial model templates - CFI's spreadsheet library includes a 3 statement financial model template, DCF model, debt schedule, depreciation schedule, capital expenditures, interest, budgets, expenses, forecasting, charts, graphs, timetables, valuation, comparable company analysis, more Excel templates
- PowerPoint Presentation Templates
- Transaction Document TemplatesTemplatesFree business templates to use in your personal or professional life. Templates include Excel, Word, and PowerPoint. These can be used for transactions,
