원문 보기
Peter Lynch is one of the most legendary investors of all time and this spreadsheet brings you one step closer to investing like him Peter's famous for managing Fidelity Miguel and fr from 1977 to 1990 under his 13-year management the fund earned an annual as return of 29.2% more than doubling the S&P 500 performance for that period in his book one up on Wall Street he describes a simple valuation formula anyone can use to value stocks and determine if they are selling at a good or a bad price in this video I will share with you what the formula is why it works and most importantly how you can use it to make some great investment decisions for yourself at the end of the video you will be able to just enter a ticker like this and you will see if the company is overvalued or undervalued right away but the question is what is the formula the formula is simple you take the future growth EPS plus the current dividend yield for that company and then you divide that number by the current PE ratio depending on the result you can see if a company is undervalued or overvalued this formula works because it prevents you from paying too much for a particular company to set up your formula all you need to do is set up the company ticker like this in this case we're going to use apple then in the spreadsheet you need to enter the future EPS growth the dividend yield and the p ratio of the company that you're analyzing for this you can use Yahoo finance and copy paste all the information for every company that you analyze like this or you can use the Y sheets add-on to get the data automatically like this with the following formulas then you need to apply the formula to the data remember you take the sum of the yield and the future EPS growth and then divide it by the PE Ratio now here's the key if a company has a number less than one this is considered overvalued between 1 and 1.5 this is fairly valued close to two would be undervalued and then close to to three would be the ideal scenario where you looking at a company that is very undervalued you can apply this formula that you're looking at right now so that the assessment that you can see right here can be done automatically for you this works because according to Lynch valuation approach a fairly valued company will have a p ratio equal to its growth rate and the dividend yield that it currently pays in other words a price to earning growth ratio of one for example if a company has earnings that are expected to grow at 15% per year and the company doesn't pay a dividend a PE of 15 would be considered a fair deal once you have your template ready you can change the company ticker and voila you can value stocks like Peter Lynch now the key question is does the Peter Lynch formula actually work I was able to back test on only for one year but the results were actually pretty good you can see in this case how you're pretty close to the market return and can perform even better in longer time frames however for every stock that you analyze I recommend that you do other types of valuation methods such as a DCF a dividend discount model earnings power value model Etc there you go now you can use the Peter Lynch formula to find great investment opportunities faster get bragging rights amongst your friends but most importantly build wealth for yourself and for your family I'll see you in the next one
댓글 0