Course curriculum

    1. Why value a company?

    2. The Investor's perspective

    3. What drives a Firm's value?

    1. Calculating Unlevered free cash flows

    2. Using an appropriate discount factor

    3. Estimating cost of debt

    4. Estimating cost of equity

    5. Forecasting future cash flows

    6. Caclulating Terminal value

    7. Discounting future cash flows

    8. Calculating Enterprise and Equity value of the firm

    1. A quick summary of the various stages of a complete DCF valuation

    2. Let's go through the structure of the DCF model we will create in Excel

    1. Modeling the top line of the financial model

    2. This is how you can build flexible financial models in Excel

    3. Modeling other items: Other revenues and Cogs

    4. Modeling other items: Operating expenses and D&A

    5. Modeling other items: Interest expenses, Extraordinary Items and Taxes

    1. How to forecast balance sheet items - The practical and easy to understand way

    2. A key concept for finance practitioners - the "Days" methodology

    3. Learn how to calculate "Days"

    4. How to use Days in order to project the future development of some BS items

    5. Forecasting Property, plant & equipment, Other assets and Other liabilities

    1. Excel best practices! Create a good-looking and clean output sheet in your model

    2. Applying what we learned in practice - Populating the P&L sheet

    3. This is how you can create a clean output Balance Sheet in your financial model

    4. Completing the Output BS Sheet For the Historical Period

About this course

  • $699.00
  • 82 lessons
  • 3.5 hours of video content

Discover your potential, starting today

Enroll today