P/E Ratio Template
This P/E ratio template will show you how to calculate the Price-to-Earnings multiple using share price and earnings per share.
Here is a screenshot of the template:

Download the Free Template
Enter your name and email in the form below and download the free template now!
What is the Price Earnings Ratio?
The Price Earnings Ratio (P/E ratio) is the relationship between a company’s stock price and earnings per share (EPS)Earnings Per Share Formula (EPS)The Earnings Per Share formula is a financial ratio, which counts net earnings against the total outstanding shares over a fixed period of time. A higher EPS ratio indicates a company’s ability to generate profits for common shareholders.. It is a popular ratio that gives investors a better sense of the valueFair ValueFair value refers to the actual value of an asset - a product, stock, or security - that is agreed upon by both the seller and the buyer. Fair value is applicable to a product that is sold or traded in the market where it belongs or in normal conditions - and not to one that is being liquidated. of the company. The P/E ratio shows the expectations of the market and is the price you must pay per unit of current earningsNet IncomeNet Income is a key line item, not only in the income statement, but in all three core financial statements. While it is arrived at through the income statement, the net profit is also used in both the balance sheet and the cash flow statement. (or future earnings, as the case may be).
Earnings are important when valuing a company’s stock because investors want to know how profitable a company is and how profitableProfit MarginIn accounting and finance, profit margin is a measure of a company's earnings relative to its revenue. The three main profit margin metrics are gross profit (total revenue minus cost of goods sold (COGS) ), operating profit (revenue minus COGS and operating expenses), and net profit (revenue minus all expenses) it will be in the future. Furthermore, if the company doesn’t grow and the current level of earnings remains constant, the P/E can be interpreted as the number of years it will take for the company to pay back the amount paid for each 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.