Course Highlights
  • Build a complete, working discounted cash flow (DCF) model in Excel from scratch
  • Value a company using the DCF and multiples approach
  • Use IRR, ROE, and NPV to analyze a project's feasibility
  • Calculate the weighted average cost of capital (WACC)
  • Calculate the cost of equity using the Capital Asset Pricing Model (CAPM)
  • Determine the terminal value of a cash flow stream
Curriculum

3 Topics
Welcome to the course!
Intro to the case study
Resources

5 Topics
Intro to the DCF approach
Intro to the multiples approach
Understanding unlevered free cash flow
Calculating unlevered free cash flow
Quiz #1

9 Topics
Intro to the discount rate
Calculating the weighted average cost of capital (WACC)
Determining the cost of equity using the CAPM
Calculating the cost of equity
Determining the beta in the CAPM
Calculating the cost of debt and equity
Finalizing the WACC calculation
Calculating the unlevered beta
Quiz #2

5 Topics
Discounting the free cash flows
Determining the terminal value
Completing our DCF model
Calculating value using the Multiples approach
Quiz #3

5 Topics
Sensitizing our assumptions pt. I
Sensitizing our assumptions pt. II
Creating a football field valuation chart pt. I
Creating a football field valuation chart pt. II
Quiz #4

7 Topics
Intro to the project valuation case study
Refining our case study assumptions
Projecting revenue
Projecting direct costs
Projecting indirect costs
Calculating free cash flow
Question #5

8 Topics
Understanding Return on Investment (ROI)
Understanding Internal Rate of Return (IRR)
Understanding Net Present Value (NPV)
Understanding breakeven
Calculating ROI and IRR
Calculating NPV and breakeven
Creating and analyzing a sensitivity table
Quiz #6

1 Topic
Final Thoughts

  Write a Review

Financial Analysis - Business Valuation, DCF, IRR, and more

Go to Paid Course