Calculation of Intrinsic Value

I have created an excel sheet that could be usefull when calculating Intrinsic values of stocks.
All you have to do is open the excel sheet, and fill in the red numbers in the excel sheet, which you can find on the links next to each box.
Excel will then automatically calculate the intrinsic value of the stock you are analyzing.

If you want to change the ticker, open a hyperlink in a box next to a red number, and change the ticker in the web address.
For example, if you are looking at http://finance.yahoo.com/q/ks?s=PEP+Key+Statistics and you would like to see the data of Coca Cola co. instead of Pepsico, change the ticker from PEP (which is the ticker of Pepsico) to KO (which is the ticker of Coca Cola).
The link to visit then becomes: http://finance.yahoo.com/q/ks?s=KO+Key+Statistics for example.

Method number one is a very simplistic model, which calculates a price target for the next 5 years based on historical valuations, the last 4 quarters results and future growth.
Method number 2 is more advanced, and takes into account Free cash flow, net cash position and future growth.
This method discounts the future values at a discount rate of 9% per year, which is the return you can expect over the long run in the stock market (7% price appreciation per year + 2% dividend yield per year).

To open the excel sheet, please click here: Calculate_Intrinsic_Value

Please be aware that calculating an intrinsic value is not an exact science. It is based on subjective estimates.
The best thing you can do is to use methods used by the biggest value investors in the world, such as Warren buffet, Joel Greenblatt, Monish Pabrai and the likes…

http://profitimes.com/value-investing/calculation-of-intrinsic-value/