theorangedog.net

DCF Valuation Model Added

by theorangedog on Jun.05, 2008, under Skills

I’ve uploaded a new model to the Models page of foquant.com. This model is a standard 5 period DCF.

Keep in mind that this model would be the aggregate tab in a workbook. A relatively more granular model would have probably between 5 to 15 more worksheets that feed into the DCF tab.

:, , ,
2 comments for this entry:
  1. Sam
    June 5th, 2008 on 7:59 pm

    Hi,
    I had a look at the workbook and i like how clean and intuitive it is. Given you are using a post-tax weighted average cost of capital I don’t think you should be including the interest expense in the free cash flow calculation.
    Love the combination of finance and rugby.
    Cheers
    Sam

  2. foq
    June 5th, 2008 on 9:58 pm

    Sam-
    Great point!

    I sat here wondering what the hell you were talking about, then reopening my model I saw the mistake. That was a simple oversight on my part in hastily putting this model together… generally I could pull a slightly more condensed indirect statement and add interest back in (using a model more for aggregation than the calculation), generating a more accurate FCFF value to then discount with tax-adj WACC, but I didn’t do that here as I should have.

    And, doesn’t everyone like rugby? All my friends do… ha ha

    Thanks for stopping by, and I like your Yahoo valuation - especially the stand alone one.

    Matt

Leave a Reply

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Try Google.

Endurance

The best long distance runners eat raw meat, run naked, and sleep in the snow.

Meta