
Learn how discounted cash flow (DCF) values a business from its expected future cash flows using the time value of money and a discount rate.
Analyze a company's financial statements—P and L, balance sheet, and cash flow—to forecast cash flows, project revenue and expenses, and compute free cash flow for DCF valuation.
Discover how free cash flow, the most accurate metric for DCF, underpins valuation by forecasting revenue, expenses, capex, and working capital using the three key financial statements.
Determine discount rate for a DCF by mastering the weighted average cost of capital, calculating the cost of equity and debt with CAPM, and converting cash flows to present value.
Explain why debt is cheaper than equity due to the tax shield on interest and the lower risk for debt holders, and show how Capm estimates the cost of equity.
Explore selecting the forecast horizon and calculating terminal value using the Gordon growth model or exit multiple method, while adjusting for inflation and macro factors.
Learn to compute terminal value with Gordon growth model or exit multiples, use the WACC with projected EBITDA or EBIT, and adjust cash flows for inflation and macroeconomic factors.
Build a clear, modifiable dcf model in Excel by organizing inputs and forecasts, discounting cash flows with WACC, applying terminal value methods, and deriving enterprise and equity value.
Learn to build a structured DCF model in Excel, discount cash flows, adjust for debt, and estimate intrinsic share price, while avoiding common valuation mistakes and applying sensitivity analysis.
Explore how changes in revenue growth, operating margins, discount rate (WACC), and terminal growth affect a DCF valuation, and master sensitivity, scenario, and Monte Carlo analyses.
Monte Carlo simulation reveals uncertainty beyond standard sensitivity and scenario analysis. It estimates valuation probabilities across thousands of simulations, highlighting sensitive variables and updating assumptions with market conditions.
Analyze real-world DCF applications in tech and traditional businesses, focusing on high-growth asset-light models, growth assumptions, profitability timelines, R&D and capex, terminal value sensitivity, and common mistakes.
Analyze how terminal value and discount rate mistakes influence DCF outcomes, extend forecasts to capture value, and apply WACC with real versus nominal cash flows across tech and traditional industries.
Build a full dcf valuation model from scratch for a real or hypothetical company, forecast cash flows, calculate wacc and terminal value, and earn a final project certificate.
This comprehensive course is designed to take you from the basics to advanced techniques in Discounted Cash Flow (DCF) analysis, a powerful tool used to evaluate the value of businesses, projects, and investments. Whether you’re an aspiring investor, business analyst, or entrepreneur, this course will equip you with the practical skills to make data-driven decisions and assess the financial health of companies.
Throughout the course, you’ll learn the key principles behind DCF, how to forecast future cash flows, and how to build a robust financial model to evaluate the present value of a business. We’ll walk you through every step of the process, from understanding financial statements like profit & loss, balance sheets, and cash flow reports, to calculating free cash flow (FCF) and determining the correct discount rate. You’ll also gain a deep understanding of how to use the Weighted Average Cost of Capital (WACC) and apply it to your models.
In addition to mastering the mechanics of DCF modeling, you’ll learn how to interpret the results, perform sensitivity analysis, and apply real-world case studies to test your skills. The course includes practical examples from both traditional businesses and high-growth startups, making it ideal for anyone looking to break into investment analysis or enhance their existing skills.
By the end of the course, you’ll be confident in your ability to build DCF models, assess business valuations, and make informed decisions based on financial data—skills that are essential in today’s fast-paced financial landscape.