December 18, 2007

DCF Valuation Template

In a previous post I have discussed a valuation methodology of Discounted Value of Free Cash flow, however I failed in include the template I use.

By clicking here you can download the Excel template that I use for this valuation methodology. The template is straight forward and follow the outline I have made in the article. yo need to have several input into the template among them:
  1. Common size statements (balance Sheet and Income statement) I suggest to have an average of 5-7 years rather than latest statements to normalize the results of cyclical businesses,
  2. cost of debt,
  3. cost of equity, or beta and risk premium,
  4. number of shares outstanding, and
  5. Judgment, that comes from detail knowledge of the company and industry, of the company's ability to sustain revenue growth and expense and asset relationship to revenue over time. (This is the most important input you can put into any valuation tool)
If you have any questions on it leave me a comment or drop me an email.

hope the spread sheet will help you.

your value seeking investor,
Sami

3 comments:

Anonymous said...

Very nice. Great Thought.

Sami said...

thanks

Vinesh said...

It's an excellently built sheet!