Forward PE uses the forecasted earnings per share of the company over the period of next 12 months for calculating the price-earnings ratio and is calculated by dividing Price per share by forecasted earnings per share of the company over the period of next 12 months.
What is Forward PE Ratio?
There is only one difference between PE ratio of a company and the forward PE ratio of the same firm. The difference is only the earnings that we use to calculate. In PE ratio, we use the earnings of the previous year. However, in the forward PE, we use the projected earnings for the next year.
Like PE ratio, the forward PE is also a great measure of whether a company is financially healthy or not. But every investor needs to look at a bunch of other financial ratios along with the forward price earning ratio to come to the conclusion that whether they should invest in a company or not.
Forward PE Ratio Formula
As stated above, the formula of the forward price earning ratio is just an extension of the formula of PE ratio.
Let’s have a look at the formula below –
Here we need to consider two components.
- The first component is the market price per share. As per the market price (at which the potential shareholder would buy the stocks of the company) can change over time, at different times, the market price would vary. We need to divide the market price by the number of outstanding shares of the company to find out the market price per share.
- The second component is projected earnings per share. As an investor, you can look at different publications to find out about the projected earnings. Or, you can hire a financial analyst and take her help to find out an estimate.
We can calculate Forward Earnings per Share by using the following formula –
Using this formula will also help investors know how much a company will earn per share. Then they can use the same formula to find out about the Forward PE Ratio.
Forward PE Ratio Examples
Now let’s take two examples of forward price to earnings ratio. The first one would be simplistic where everything would be given. The second example would be a bit complex.
Example # 1
Jill is new in stock investing. She wants to know whether she should invest in Burban Ltd., a biscuit company. So she asks her brother who is in stock investment for quite a while. Her brother, Jack advises that she should look at a bunch of financial ratios. Jill figured out all the ratios except the forward price earning ratio. Help Jill find out the ratio by using the following information –
- Total Market Price of the stock – $1 million
- Number of shares outstanding – 100,000
- Projected Earnings for the next year – $500,000
We will calculate the forward PE ratio by splitting the example into two parts.
First, we will calculate the market price per share and then we will find out forward EPS.
- Market price per share = Total market price of the stock / Number of shares outstanding
- Or, Market price per share = $1,000,000 / 100,000 = $10 per share.
To find out the forward EPS, we need to use the formula.
- Forward EPS = Projected Earnings for the next year / Number of shares outstanding
- Or, Forward EPS = $500,000 / 100,000 = $5 per share.
Now, if we use the formula of the forward price earning ratio, we would get –
- Forward PE Ratio = Market price per share / Forward EPS
- Or, Forward Price Earning Ratio = $10 / $5 = 2.
Example # 2
Mr Amit wants to calculate the forward price earning ratio of Buddha Jeans Ltd. The issue is he doesn’t have all the information. He only knows the PE ratio of the company and also the EPS. He also has a consensus report that says that the projected earnings of Buddha Jeans Ltd. would be $1 million in the coming year. Help Mr Amit find out the forward price earning ratio by using the following information –
- PE Ratio – 4.
- EPS – $15 per share.
- The number of outstanding shares – 100,000.
We have been given the PE Ratio and EPS. So, let’s break them down.
- PE Ratio = Market Price per Share / EPS
- We know that the PE Ratio is 4 and the EPS is $15 per share.
So, using the same information, we now get –
- 4 = Market Price per Share / $15
- Or, Market Price per Share = 4 * $15 = $60 per share.
Now, to find out the forward price earning ratio, we need to calculate the last piece of information i.e. forward EPS.
To find out the forward EPS, we will use the following formula –
- Forward EPS = Projected Earnings / Number of Shares Outstanding
- Or, Forward EPS = $1 million / 100,000 = $10 per share.
Now, we have all the information we need to find out the forward price earning ratio.
- Forward PE Ratio = Market price per share / Forward EPS
- Or, Forward Price Earning Ratio = $60 per share / $10 per share = 6.
Forward PE Ratio of Amazon
Amazon Current Share Price = 1,586.51 (as of 20th March, 2018)
Forward EPS (2018) of Amazon = $8.31
Forward EPS (2019) of Amazon = $15.39
- Forward Price Earning Ratio (2018) = Current Price / EPS (2018) = 1,586.51/8.31 = 190.91x
- Forward Price Earning Ratio (2019) = Current Price / EPS (2019) = 1,586.51/15.39 = 103.08x
Forward PE Ratio Calculator
You can use the following Forward PE Ratio Calculator.
|Forward PE Ratio Formula =||
Forward PE Ratio in Excel (with excel template)
Let us now do the same example above in Excel. This is very simple. First, we need to calculate the market price share and forward EPS and then we will calculate the forward PE ratio, by using the formula. You can easily calculate the ratio in the template provided.
We will calculate it by splitting the example into two parts.
Now, if we use the formula of the forward PE ratio, we would get –
Now, we have all the information we need to find out the forward PE ratio.
You can download this Forward PE Ratio Template here – Forward PE Ratio Excel Template
Foward PE Ratio Video
This has been a guide to Forward PE Ratio Formula, its uses along with practical examples. Here we also provide you with Forward Price Earnings Calculator with downloadable excel template. You may also have a look the following valuation articles to learn more –