Master DCF spreadsheet building for financial analysis
These guides cover the fundamentals of discounted cash flow analysis — from building your first projection model to understanding terminal value calculations. We're focused on practical spreadsheet techniques that actually work, with step-by-step walkthroughs you can follow along with. Whether you're preparing for interviews or building models for real investments, you'll find the core concepts explained clearly.
Explore guides on DCF modelling and financial analysis
Walk through creating a complete DCF spreadsheet from scratch, including revenue projections, expense assumptions, and cash flow calculations. This covers the essentials you need to get started.
Learn how to calculate weighted average cost of capital and why it matters for your valuation. We break down the components and show you how to apply them in your model without getting lost in theory.
Terminal value often represents most of your enterprise value. We cover both the perpetual growth and exit multiple approaches, with real examples showing when to use each method.
See how changing your key assumptions affects valuation. This guide shows you how to build sensitivity tables and scenario analyses that help you understand the range of possible outcomes.
