We've all heard of EPS, EBIT, EBITDA, Free Cash Flow and Operating Cash Flow. They are all used by analysts in trying to value a stock. What the analysts are trying to get at is cash flow. Ultimately, every financial valuation ends with a cash projection into the future, then discounting it back into today's dollars. Hence the term discounted cash flow (or DCF).
In my weekly stock analyses one of the methods I use to value a stock is using a 20-Year DCF. The model looks at cash flow from dividends and assumes the stock is sold in year 20. The Excel model [20-Year-DCF.xls] is available in my Toolbox which can always be accessed by clicking Tools on the menu above.
The model is divided into four sections. Each are described below:
I. Input: All cells requiring your input are shaded yellow. They include:
In addition, certain calculated fields can be over-written when better information is available. They include:
You will also need to enter historical information for these items:
Note on Cost of Capital: The DCF calculation is very sensitive to the Cost of Capital. The default 15% is a rate that I have found fairly consistent with what the market has historically used. In short, the discount rate is inversely related to the calculated fair value of the stock. Its derivation can be quite complex and is beyond the scope of this article. For those interested, I will refer you this detailed explanation on Wikipedia.
II. Projected Information: This section projects 20 years dividends and EPS using the EPS Growth Rate and Div. Growth Rate above.
III. Share Price Value Based on Discounted Cash Flow: This section calculates the estimated fair value of the stock (i.e. the answer).
IV. Disclaimer: This model is for illustrative and educational purposes only. The author and Dividends4Life makes no claims or assertions as to the model's accuracy, completeness, appropriateness of use, or any other claim or assertion. You should not rely on this model or base any financial decisions on it.
A DCF model is a great tool in helping to determine an entry (or sales) point for a stock. As with with any model, it is only as good as its inputs. Since it is forward looking, there are no hard and fast sources for the inputs. I hope you enjoy using it as much as I do!
Related Articles:
________________________________________________________________
Subscribe to:
Post Comments (Atom)
~
Popular Posts Last 30 Days
-
When shares trade at a 40% discount to book value, they should have substantial flaws. This REIT isn’t perfect, but it deserves a higher rat...
-
The best dividend stock nobody is talking about is an undervalued, high-dividend chemical company poised to grow at an exponential rate. Wit...
-
If any investor has stood the test of time, it is Warren Buffett. For years, the “Oracle of Omaha” has had a rock-star-like presence in the ...
-
Last week, we found out that the consumer price index (CPI) went up by 8.3% in April, more than the 8.1% estimate. Meanwhile, the ongoing wa...
-
A full-blown recession, or the late-year rally in Wilson’s view – the natural move for investors will be toward defensive stocks, moves to p...
-
If any investor has stood the test of time, it is Warren Buffett, and with good reason. For years, the “Oracle of Omaha” has had a rock-star...
-
When a retailer has a sale, it's often celebrated with banners, signs, and commercials telling customers not to miss out on the spectacu...
-
The Dividend Kings, which are those stocks with at least 50 years of dividend growth, is an excellent place to find high quality names. Ther...
-
Mid-cap dividend stocks are the best bargain on the board right now. I love them because lame income investors don’t consider them. They fix...
-
5 big yields, all with upside. But I've got 1 more share to mention. With most of the earnings releases out, the charts are updated to s...
Great post and I always wanted to know about the DCF model. Will be adding to my stock review/research and analysis process.
D4L,
Great tutorial. Very simple and easy. It was of great help to me. I never understood it fully so did not use in my analysis. Now I do. Thanks for the spreadsheet.
DT
Andy & Dividend Treee: Thanks for the kind words. I hope you find the DCF model useful in your investing endevors.
Best Wishes,
D4L
I was wondering how to come up with high / low PE numbers. I have Morningstar and S&P so I have EPS and dividend numbers but no historical high or low prices or PE'S. I hacked the formula and used 8 years of average PE's to come up with a work around but I was wondering if you could point me to a solution.
BW: Most of my data is pulled directly from an S&P report. My broker provides access to S&P company reports. I try to validate the dividends with Yahoo Finance.
Best Wishes,
LD
Interesting discounted cash flow model. Why did you decide to go out 20 years? Wouldn't 10 be enough? Great pointers, though.