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. The EPS formula indicates a company’s ability to produce net profits for common shareholders. 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. These methods of valuation are used in investment banking, equity research, private equity, corporate development, mergers & acquisitions, leveraged buyouts and finance, 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 gives investors a better sense of the value of a company. The P/E shows the expectations of the market and is the price you must pay per unit of current (or future) earnings 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, legal, financial modeling, financial analysis, business planning and business analysis.
