How to Sanity Check Your DCF Analysis and Avoid the Top 3 Errors

Поділитися
Вставка
  • Опубліковано 28 гру 2024

КОМЕНТАРІ •

  • @Mike-uz9hs
    @Mike-uz9hs 9 років тому +6

    This is the most helpful video I've learned from this week...I was able to fix my DCF thanks to your example. Thanks alot

  • @Abbas-oj6ne
    @Abbas-oj6ne Рік тому +1

    Thanks Brian, I have a question though,
    To calculate WACC we tend to assume the Capital Structure of the industry/comps which can be different from the current capital structure of that entity, so when we are to calculate implied Equity Value from implied TEV, should we add current Debt of the entity or the industry Debt of the industry/comps which we considered for WACC calculation?

    • @financialmodeling
      @financialmodeling  Рік тому

      Thanks. You don't normally do this because the DCF itself is still based on the subject company's current or expected capital structure. Only the Discount Rate is based on the comparable companies - because the argument there is that the company's actual risk and potential returns might be closer to those of the comps.
      With the cash flow projections and Terminal Value, you're making a direct forecast based on the company's history and expectations, so there's no reason to link them to the comps.

  • @prasitrattanapiseth1058
    @prasitrattanapiseth1058 6 років тому +1

    I do not understand the double counting items ,would you please explain in writing so that I can read them throughtly.Thank you in advace for your kind help.

    • @financialmodeling
      @financialmodeling  6 років тому

      If you include an item that affects FCF, then you should not include its corresponding Balance Sheet item at the end in the Equity Value to Enterprise Value bridge. For example, the Interest Expense reduces FCF. Therefore, if you include the Interest Expense in the calculations, then you should NOT also include Debt at the end. But if you exclude Interest Expense, then you SHOULD include Debt in the bridge at the end.

    • @prasitrattanapiseth1058
      @prasitrattanapiseth1058 6 років тому

      Thx for your kind help.

  • @fitnnut9015
    @fitnnut9015 Рік тому

    okay so i have a question, please can you tell me if the DCF model is impacted more from the initial years of cash flow or the later years of cash flow, and my answer to this is:
    if the time period of the project is limited lets say 5 years then in this case initial years cash flow will have greater impact on the valuation because of there is high initial cash flow in the beginning cause of the higher growth rate in initial years and lower cash flow in later years cause of lower growth rate in later years, then the pv would be high and vice versa.
    but if the project's time period is indefinite then the later years cash inflow would highly impact the valuation cause in this case we would have to use the terminal value of the project and if the project as lower cash inflow in the later years than it would have lower terminal value and hence low valuation.
    am i right or please correct me if i am wrong

    • @financialmodeling
      @financialmodeling  Рік тому +2

      The initial cash flows should almost always impact the DCF by more than the later cash flows because of the time value of money. Money today is worth more than money tomorrow, end of story.
      There is some nuance to this because of cases where the company does not generate any positive cash flow today / in the near-term, cases where cash flow spikes up suddenly in later years or declines, etc., so it is not quite that simple for all real-life scenarios, but at a high level, this question is testing your understanding of the time value of money.

  • @giobilkis
    @giobilkis 5 років тому

    From which case study/course is that? I mean, I would like to go through the whole thingy with the cost of capital, net debt, etc...

    • @financialmodeling
      @financialmodeling  5 років тому

      Excel & Fundamentals (breakingintowallstreet.com/biws/excel-financial-modeling-fundamentals/)

  • @RezaArdhiansyah
    @RezaArdhiansyah 11 місяців тому

    good video