How to find the stock value of a company?

How to find the stock value of a company?

To find the true value of the stock price of a company is a difficult task. In this excel sheet, we will find out the true value of stock price according to its growth rate. If predicted is less than the current market price of the stock share is overpriced but if the share value is less than the predicted price it is fairly priced in and in discount. As a thumb rule, it is suggested to find the stock with lower valuation and 30  discount from its true value

Procedure to find the stock value of the company:

1. This method is based on the growth method
2. Download the excel sheet from the link 
3. Enter the Actual Present share price in the excel sheet 
4. Enter the EPS growth assumption from this link 
5. Enter the future PE assumption in excel sheet
6. Enter the earning per share from the link 
7. Enter dividend given in the year 
8. Enter the expected return per by company

Example to find the stock value of the company:

1.  Actual Present share price is 1224
2.  EPS growth assumption is 15 percent
3. Future PE assumption is 10
4.  Earning per share for 2019 is 66
5. The dividend is given in the year 2019 is 6.64
6. Expected return by the company is 10 %
7. Learn how to accumulate stock link
8. Learn why trend line works from this link 

Conclusion: Good value of reliance industries is 1144 and the stock is overvalued at current market