DCF & Valuation

Analyze, Value & Invest Like a Top Investment Professional – Master the art of discounted cash flow modeling used by equity research analysts and M&A advisors.

Course Curriculum

Module 1
Introduction to Valuation

Purpose of Valuation – Why it matters
03:37
Key Valuation Approaches (DCF, Comparable Companies, Precedent Transactions, LBO, NAV)
Enterprise Value vs. Equity Value
Overview of the DCF Method
00:00
DCF Strengths and Limitations
04:07

Module 2
Understanding the Business & Key Drivers

Module 3
Building a 3-Statement Forecast Model

Module 4
Calculating Free Cash Flows

Module 5
Discounting Cash Flows

Module 6
Terminal Value & Enterprise Value

Module 7
Valuation Analysis & Sensitivities

Module 8
Valuation in Practice (Mini Cases)

Module 9
Common Pitfalls & Real-World Adjustments

Module 10
Final Assessment & Certification

Course Features

Excel DCF Templates

Professional valuation models used by top investment banks

Step-by-Step Videos

Detailed screen recordings of model building process

Real Company Cases

Actual public company valuations and analysis

Advanced Formulas

Custom Excel functions for complex calculations

Industry Recognition

Certificate recognized by leading financial institutions

Practical Application

Build models you can use in real deal scenarios

DCF & Valuation

Course Curriculum

Module 1 Introduction to Valuation

Purpose of Valuation – Why it matters

Key Valuation Approaches (DCF, Comparable Companies, Precedent Transactions, LBO, NAV)

Enterprise Value vs. Equity Value

Overview of the DCF Method

DCF Strengths and Limitations

Module 2 Understanding the Business & Key Drivers

Industry analysis & competitive positioning

Business model mapping

Identifying value drivers: Revenue, cost structure, margins, capital intensity

Using investor presentations and filings for forecasting

Module 3 Building a 3-Statement Forecast Model

Best practices in Excel modeling

Building Revenue & COGS Forecast

Forecasting Operating Expenses, EBITDA & Capex

Modeling Working Capital and Depreciation

Building the Cash Flow Statement

Module 4 Calculating Free Cash Flows

FCFF (Free Cash Flow to Firm) vs. FCFE (Free Cash Flow to Equity)

Deriving FCFF from the 3-statement model

Adjusting for non-cash items, tax shield, and changes in NWC

FCFE in levered valuation scenarios

Module 5 Discounting Cash Flows

Cost of Equity (CAPM)

Cost of Debt and Tax Shield

Calculating and understanding WACC

Choosing the right discount rate for each scenario

Present value of FCFs

Module 6 Terminal Value & Enterprise Value

Terminal Value – Gordon Growth vs. Exit Multiple methods

Choosing a growth rate or exit multiple

Discounting Terminal Value

Summing up Enterprise Value and adjusting for cash/debt

Deriving Equity Value per Share

Module 7 Valuation Analysis & Sensitivities

Sensitivity tables for WACC, growth, exit multiples

Scenario analysis (Base, Upside, Downside)

Creating valuation dashboards

Cross-checking against market comps

Valuation sanity checks

Module 8 Valuation in Practice (Mini Cases)

Tech growth company (high capex, low margin)

Industrial firm (predictable cash flow)

Startup / pre-profit company

Value each case using DCF

Adjust assumptions based on real-world filings

Module 9 Common Pitfalls & Real-World Adjustments

Dealing with negative FCFs

Negative working capital or capex assumptions

Adjusting for minority interest, preferred stock

Non-operating income and one-offs

Valuing cyclical companies

Module 10 Final Assessment & Certification

Build a full DCF valuation model from scratch

Submit a video walkthrough of your model and key assumptions

Take the final quiz (20–25 questions)

Earn Certificate of Completion

Course Features

Excel DCF Templates

Step-by-Step Videos

Real Company Cases

Advanced Formulas

Industry Recognition

Practical Application

LBO Financial Models

DCF & Valuation

Project Finance Modeling

Real Estate Models

Consolidation Models

Module 1
Introduction to Valuation

Module 2
Understanding the Business & Key Drivers

Module 3
Building a 3-Statement Forecast Model

Module 4
Calculating Free Cash Flows

Module 5
Discounting Cash Flows

Module 6
Terminal Value & Enterprise Value

Module 7
Valuation Analysis & Sensitivities

Module 8
Valuation in Practice (Mini Cases)

Module 9
Common Pitfalls & Real-World Adjustments

Module 10
Final Assessment & Certification