Build a Complete DCF Model in Excel

This video covers the following learning objectives:

• Build a complete DCF model in Excel

• Structure a multi-tab DCF model with clean, auditable inputs

• Forecast Free Cash Flow to the Firm (FCFF) using operational assumptions

• Calculate and apply discount factors for multi-year cash flows

• Estimate terminal value using the Gordon Growth Model

• Compute enterprise value using the sum of discounted cash flows and terminal value

• Tie all model components together using a logical, integrated Excel structure