DCF Valuation with Sensitivity Analysis
Build a DCF (discounted cash flow) valuation for a public company — include WACC, terminal value, and 2-axis sensitivity.
About this project
DCF is the canonical valuation skill. This project teaches the full stack: free-cash-flow forecasting, WACC computation (with proper beta unlevering), terminal value selection (Gordon vs exit multiple), and the sensitivity discipline that catches bad assumptions. Pick a stable public company and produce a defensible valuation.
Why build this in 2026?
DCF interviews are still standard at IB, equity research, and PE shops. Most candidates fudge WACC; demonstrating real rigor is differentiated.
What you'll ship
- Excel DCF model
Sign up to see the full project brief
Full deliverables, success criteria, and AI Career Tutor support — free.
You'll unlock:Complete project brief, AI tutor that knows this project, and progress tracking when you start.