Valuation isn't just about plugging numbers into an Excel sheet; it’s about telling a compelling story with data. Whether you're an aspiring investment banker, an equity research analyst, or just someone looking to understand what a company is truly worth, the Discounted Cash Flow (DCF) model is the holy grail of intrinsic valuation. At The Valuation School, we believe that learning finance should be practical, not just theoretical. Reading about a DCF in a textbook is completely different from…
Valuation isn't just about plugging numbers into an Excel sheet; it’s about telling a compelling story with data. Whether you're an aspiring investment banker, an equity research analyst, or just someone looking to understand what a company is truly worth, the Discounted Cash Flow (DCF) model is the holy grail of intrinsic valuation.
At The Valuation School, we believe that learning finance should be practical, not just theoretical. Reading about a DCF in a textbook is completely different from building one for a live, publicly traded company.
Today, we are going to break down the DCF model into simple, understandable steps—no confusing financial jargon, just practical application.
What is a DCF Model?
The core philosophy behind a DCF is simple: The value of any business today is the sum of all the cash it will generate in the future, discounted back to today's value. Money today is worth more than money tomorrow (Time Value of Money). The DCF model helps you figure out exactly how much that future cash is worth right now. Here is the step-by-step framework to build one.
Step 1: Forecasting Free Cash Flows (FCFF)
You cannot value a company based on its accounting profits (Net Income) because profits can be manipulated. Cash cannot. Your first step is to calculate the Free Cash Flow to Firm (FCFF).
- Start with EBIT (Earnings Before Interest and Taxes).
- Subtract Taxes to get NOPAT (Net Operating Profit After Tax).
- Add back Non-Cash Expenses like Depreciation and Amortization.
- Subtract Capital Expenditures (CapEx)—the money spent on buying physical assets.
- Subtract Changes in Net Working Capital (money tied up in daily operations).
Pro Tip: Forecasting these line items requires a deep understanding of how to read financial statements. If you struggle to analyze annual reports or spot red flags, our Equity Research Cohort will teach you how to analyze businesses like a pro.
Step 2: Calculating the Discount Rate (WACC)
Now that you know how much cash the company will make, you need to discount it back to the present day. We use the Weighted Average Cost of Capital (WACC) for this. WACC represents the blended cost of a company's debt and equity.
- Cost of Debt: The effective interest rate a company pays on its borrowed money (adjusted for tax benefits).
- Cost of Equity: Calculated using the Capital Asset Pricing Model (CAPM). You'll need the Risk-Free Rate, the stock's Beta (volatility compared to the market), and the Equity Risk Premium.
(Note: These concepts are heavily tested in the CFA Level 1 Program. If you are preparing for the exam, understanding WACC conceptually is critical to passing).
Step 3: Calculating the Terminal Value
You can't forecast cash flows year-by-year into infinity; it's impossible. Usually, we forecast 5 to 10 years into the future. But what happens after year 10? The company doesn't just disappear.
This is where the Terminal Value comes in. It represents the value of the company for all the years beyond your forecast period. Most analysts use the Gordon Growth Model, assuming the company will grow at a steady, stable rate forever (usually in line with GDP inflation).
Warning: The Terminal Value often makes up 60-80% of your total valuation. A small tweak here drastically changes the final price!
Step 4: Discounting to Present Value
Take your forecasted Free Cash Flows (from Step 1) and your Terminal Value (from Step 3), and discount them back to "Year 0" using your WACC (from Step 2).
Add them all together, and you get the Enterprise Value (the total value of the firm's operations). To find the intrinsic value per share:
- Add Cash and Equivalents.
- Subtract Total Debt.
- Divide by the total number of shares outstanding.
Compare this final number to the current market price of the stock. If your value is higher, the stock is undervalued (a buy). If it's lower, the stock is overvalued (a sell).
Step 5: The Golden Rule - GIGO (Garbage In, Garbage Out)
A financial model is only as good as the assumptions you feed into it. If your growth assumptions are unrealistic, your final valuation will be useless. This is why technical chart analysis can sometimes complement fundamental valuation by showing you the market's current psychology and entry/exit points. (Learn more in our 10-hour Chart Reading Workshop).
Ready to Build Your First Model?
Stop reading about valuation and start doing it.
If you want to master Excel shortcuts, build full-scale DCF and Relative Valuation models from scratch using real company data, and write professional pitchbooks that will get you hired, it's time to take the next step.
👉 Join the Advanced Valuation and Financial Modelling (AVFM) Program
The finance industry rewards those with practical skills. Make sure your resume and LinkedIn profile reflect this expertise to attract top recruiters. (Need help optimizing your profile for jobs? Check out our LinkedIn Mentoring Program).
Have questions about which cohort is right for your career goals? Contact Us today, and let's map out your path to success!
