How do you calculate what the fair price of stocks is? Is there an easy-to-use formula to create a fair value for the stock?
The answer is YES, and I will share the same with you here.
Let me help you with a Google sheet for it.
I am sharing a Google sheet, and do not ask for its edit permission. Instead, please copy the above sheet and use it as you like.
I am returning to the original question about how one can calculate the fair price of a share. The critical aspect is the reasonable price of the stock you should invest in.
Earnings are one of the common factors to consider in valuations. A common consensus is to use the earnings per share or EPS and price-to-earnings or PE ratio of the companies to determine whether the stock is overvalued or undervalued.
So we will use some of the same to find a fair price.
Warren Buffett mentions cash flow and not earnings or EPS because profits can be manipulated, but cash flow is challenging.
However, we use the business checklist to eliminate companies that can potentially manipulate earnings. So for our calculation’s sake, we can use the earnings or EPS.
So using the above values, we derive an earnings and share price chart in excel as follows:
If it is too much to understand, the examples below will help you.
So, now we have the Google sheet, and all we need to do is put in the parameters from the screener.
When we add the current EPS and expected growth, we get to the EPS the company would do in the next ten years.
When we put in the expected PE ratio in the future, we get the then price and its back calculation to date.
Then we apply the margin of safety on the above price.
And Voila, we have a fair price for Asian Paints.
Pidilite has been one of my portfolio stocks since 2017. So I am putting parameters a little backdated.
Now we have the EPS of Pidilite in 2026 will be 48.64, and the price at which one should have invested in 2016ish time was around ₹700.
Do you invest in stocks at a fair price? What is your preferred margin of safety percentage? Share your thoughts in the comments below.
Understand US banking crisis. What Happened to SVB Bank? How Safe Are Indian Banks? Can…
The business analysis of Divis Lab in a 3-step process and understand why the share…
Pre-Investing Checklist - the three most important ratios that you should be looking for when…
Should I redeem or switch from my existing mutual funds if they are not the…
How to Find Stocks with Hidden PE ratio of Under 1 - The Mohnish Pabrai…
How can retail investors find which is the best small-cap fund to invest in 2023?…