What is PE Ratio Formula?
Price Earnings Ratio formula calculates how much market price an investor is paying for a portion of the earnings of the company. No matter what investors look at, PE Multiple is one of the first ratios they check if investing in a company crosses their minds, ever.
Let’s see the PE Ratio formula –
Explanation of Price to Earnings Formula
In the above Price to Earnings ratio formula, there are two parts.
- The first part is the market price per share. All an investor needs to do is to see how much they need to pay for an equity share of the company. That is the market price per share.
- And the second part is a ratio itself – earnings per share.
If we break down the earnings per share ratio, we get the following –
Earnings per share = (Net Income – Preferred Dividend) / Weighted Average Number of Shares Outstanding
- The numerator is “net income – preferred dividend”. You may wonder why we are deducting the preferred dividend from the net income. It is simply because this is a measure of common shares.
- The denominator is tricky. Here we need to find out the number of common shares outstanding at a different time period and find out the weighted average of that number.
For example, let’s say that a company issues 1000 common shares at the beginning of the year and 1000 again at the middle of the year. If we’re Price to Earnings calculation at the end of the year, how would we find out the weighted average?
Here’s what we will do. We will consider first 1000 shares for the entire year and another 1000 shares for a half-annual period. Price to Earnings calculation of weighted average would be = [(1000 * 1) + (1000 * 0.5)] = [1000 + 500] = 1500 shares.
Example of PE Ratio Formula
Let’s take a simple example to find out the PE Ratio formula.
Solid Stuff Inc. has the following information –
- The market price per share – $25 per share.
- The earnings per share – $10 per share.
Find out the PE Multiple of Solid Stuff Inc.
By using the PE ratio formula, we get –
- P/E Ratio = Market Price per Share / Earnings per Share
- Or, P/E Ratio = $25 / $10 = 2.5.
Now the investors need to see whether the companies in the same industry have the similar PE Ratio or less or more. Depending on that they would be able to understand whether the PE Multiple of Solid Stuff Inc. is good enough for investment.
PE Ratio of Google and Apple
Let us now have a look at the P/E ratios of Google and Apple.
We note that Google has a PE Multiple of 47.42x as compared to Apple PE Multiple of 16.08x. When we compared the two stocks only on the basis of PE Multiple, we find that Google shares are expensive as compared to Apple.
Use of Price to Earnings Formula
There’s no free lunch in business. Every investor wants to know for how many portions of net earnings they are paying the market price for.
- In simple terms, the price to earnings formula decodes how much the investors need to pay for that sum of the net earnings of the company.
- Doing price to earnings calculation helps the investors decide whether it’s the right to pay the market price for the portion of net earnings they are receiving. If it doesn’t seem enough, they won’t invest.
- A higher Price to Earnings calculation which indicates that the company has a strong position in the market and vice versa.
PE Ratio Calculator
You can use the following Price to Earnings PE Ratio Calculator.
PE Ratio Formula in Excel (with excel template)
Let us now do the same example above PE Ratio Formula in Excel.
PE Ratio Formula is very simple. You need to provide the two inputs of Market Price per Share and Earnings per Share.
You can easily calculate the ratio in the template provided.
Recommended Articles –
This has been a guide to Price to Earnings formula, its uses along with practical examples. Here we also provide you with PE Ratio Calculator with downloadable excel template.