Formula to Calculate Price to Earnings (PE Ratio)
Price Earnings Ratio formula (PE Ratio) 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.
Calculation of Price to Earnings Ratio
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 calculating at the end of the year, how would we find out the weighted average?
Here’s what we will do. We will consider the first 1000 shares for the entire year and another 1000 shares for a halfannual period. The calculation of weighted average would be = [(1000 * 1) + (1000 * 0.5)] = [1000 + 500] = 1500 shares.
Example
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 Price to earnings ratio formula, calculation will be –
 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 a 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 and Relevance
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 ratio formula decodes how much the investors need to pay for that sum of the net earnings of the company.
 Calculating the price to the earnings ratio helps investors decide whether they are entitled to pay the market price for the portion of the net earnings they receive. If it doesn’t seem enough, they won’t invest.
 A higher Price to Earnings indicates that the company has a strong position in the market and vice versa.
Price to Earnings Ratio Calculator
You can use the following Price to Earnings Ratio Calculator.
Market Price per Share  
Earnings per Share  
Price to Earnings Ratio Formula  
Price to Earnings Ratio Formula = 


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 Ratio Formula. Here we learn how to calculate the price to earnings ratio using its formula along with some practical examples, calculator and a downloadable excel template.