The Discounted Cash Flow (DCF) Modelling
Imagine a stranger offers you a choice: they will either give you $10,000 right now or give you $10,000 exactly five years from today. Which one do you take? Unless you dislike immediate wealth, you would choose the cash today. Why? Because you intuitively understand that money today is worth more than the same amount in the future. You could put that $10,000 into a high-yield savings account, buy stocks, or invest in real estate, and by year five, it would have grown significantly. Alternatively, inflation might affect the purchasing power of that future $10,000, making it buy far less in five years than it does today.
This is the foundation of one of the relevant tools in corporate finance and investing: Discounted Cash Flow (DCF) Modelling.
While the name sounds complicated, the concept is simple. In the subsequent paragraphs, we will explain the concept of DCF modelling in bite-sized, everyday concepts. Whether you are an aspiring entrepreneur, an investor, or a financial expert, this article can help you understand the concept of DCF.
What is Discounted Cash Flow (DCF)?
Basically, a Discounted Cash Flow (DCF) model is a valuation method. It is used by investors, investment bankers, and corporate executives to estimate an investment's value today based on the future cash flows it is expected to generate.
It is more like a time machine. It tries to evaluate future cash flows by discounting them to their present value. It adjusts their value downward or discounts to account for time, inflation, and risk.
DCF model can be applied to anything that makes money:
A local retail shop you are thinking of acquiring.
A giant tech company like Apple and Microsoft, whose stock you want to trade.
A new product line that your company is thinking of introducing.
An estate company that engages in the rental business.
If it generates cash over time, a DCF can tell you what it is worth right now. If the total value derived from the DCF model is higher than the current cost of the investment, it is generally considered a good deal. If it is lower, you are overpaying.
The Time Value of Money (TVM)
For us to understand DCF properly, we have to look at the mathematical side of finance: The Time Value of Money (TVM). As we indicated with our $10,000 introduction, a dollar today is worth more than a dollar tomorrow. Financially, we quantify this using an interest rate or a rate of return. If you invest $100 today at a 10% annual interest rate, you will have $110 next year.
DCF simply does this process in reverse. Instead of asking, What will this amount grow into in the future? DCF postulates, What is a future payment of the same amount worth to me right now? (Discounting).
If someone promises to give you $110 next year, and your alternative investment option yields 10%, then that future $110 is worth exactly $100 to you today. The $100 is the Present Value (PV), and the $110 is the Future Value (FV).
Features of DCF Model
DCF model has various features, and each of them is important when building the model, omission of can lead to incorrect results. For every DCF, you need to understand the following features or concepts:
1. Free Cash Flows (FCF)
When evaluating a business, novice investors look at net income or accounting profit, but professional investors look at Free Cash Flow. Profits on an income statement can be manipulated by accountants using depreciation, amortization, and various reporting standards. Free Cash Flow, however, is the actual cash a business has left over after paying all its operational bills, taxes, and funding any necessary equipment upgrades (Capital Expenditures). FCF is the money that can actually be pulled out of the business to pay dividends, buy back shares, or reinvest in expansion.
2. The Forecast Period
You cannot predict the future until the end of time. Usually, a DCF model projects cash flows for a period, typically 5 to 10 years.
For big companies such as a utility provider, a 10-year forecast might make sense.
With tech startups, a 5-year projection feels like trying to look into infinity.
3. The Discount Rate (WACC)
This is the most complicated part, and it is the section that people spend more time trying to decipher the model. The Discount Rate is the interest rate used to reverse the future cash flows to the present day. It represents the opportunity cost of your capital, as well as the riskiness of the investment.
For a company, the discount rate is usually calculated as the Weighted Average Cost of Capital (WACC). WACC uses the cost of a company’s debt (the interest paid on loans) and its cost of equity (the return shareholders expect).
Rule of Thumb: The riskier the investment, the higher the discount rate. If you are investing in a government bond, your discount rate might be 4%. If you are investing in a volatile cryptocurrency startup, your discount rate might be 25%. A higher discount rate aggressively shrinks future cash flows, making the investment worth less today because of the added risk.
4. Terminal Value (TV)
What happens after your 5- or 10-year forecast period ends? Does the business just stop operating? Of course not. It keeps running. Because we can’t map out every single year of operations into infinity, we calculate a lump-sum value for all cash flows beyond our forecast window. This is called the Terminal Value. It usually accounts for the majority (often 60% to 80%) of the total value calculated by the DCF model.
The DCF Formula
Before your eyes glaze over, take a deep breath. We are going to look at the formula, but we will break down exactly what it means. It looks far more complex than it actually is.
The fundamental formula for a DCF model spanning n years is expressed as follows:
DCF = [FCF₁ / (1 + r)¹] + [FCF₂ / (1 + r)²] + [FCF₃ / (1 + r)³] + ... + [(FCFₙ + TV) / (1 + r)ⁿ]
Where:
FCF = Free Cash Flow for a given year (Year 1, Year 2, etc.)
r = The discount rate (expressed as a decimal, so 10% becomes 0.10)
TV = Terminal Value (added to the final year's cash flow)
n = The final year of our projection period
Looking at the denominators: (1 + r)¹, (1 + r)², (1 + r)³ indicates that the exponent increases every year. This means that cash further out in the future is heavily penalized. A dollar earned in Year 5 is divided by a much larger number than a dollar earned in Year 1, shrinking its present value significantly.
How to Build a DCF Mode
Study Historical Performance
Before looking forward, you must look backward. Analysts study a company’s financial records from the past 3 to 5 years. They look at how fast revenues grew, what the profit margins were, and how much cash was spent on equipment. This gives a realistic baseline. If a company has grown at 5% per year for half a decade, projecting a sudden 40% growth rate next year may be over-projection or extrapolation, and it will require exceptionally hard work.
Project Future Free Cash Flows
This is where you utilise your financial expertise most. Based on industry trends, economic conditions, and company strategy, you project out the financial statements for the next 5 to 10 years. You use these projections to calculate the expected Free Cash Flow for each year.
Determine the Discount Rate
Next, you determine the discount rate. If the company is funded half by bank loans at a 6% interest rate and half by investors expecting a 12% return, the WACC will be between the two or somewhere in the middle (adjusted for corporate tax perks). Let's assume your final calculated discount rate is 9%.
Calculate the Terminal Value
To calculate the value of the company beyond your forecast period, you must calculate the Terminal Value. Analysts use one of two main methods to do this:
Perpetual Growth Method: This assumes the business will grow at a steady, tiny rate (usually matching the long-term rate of inflation or GDP growth, around 2% to 3%) forever.
Exit Multiple Method: This assumes the business will be sold at the end of the forecast period to another buyer for a multiple of its earnings (e.g., 10 times its final year's EBITDA).
Discount to the Present
This is where you can use Excel to do most of the work. You take the expected cash flow from Year 1 and divide it by (1 + r)¹. You take Year 2 and divide it by (1 + r)², and so on. Finally, you take the massive Terminal Value from the end of the timeline and discount it all the way back to Day One.
The Fair Value
When you add up all these discounted numbers, you get the Enterprise Value (the total value of the operating business).
To find out what the stock price should be, you take that Enterprise Value, add any extra cash the company has sitting in the bank, subtract its total outstanding debt, and divide the final number by the total number of stock shares outstanding. You have calculated the Intrinsic Value per share of the stock.
If your calculated intrinsic value is $50, and the stock is currently trading on the market for $35, the asset is undervalued; it is a buy! If the market price is $70, the asset is overvalued.
The Limitations of DCF
While the DCF model sounds incredibly precise and mathematical, it has some flaws. It is sensitive to the assumptions you feed into it. In the finance community, this is known as the Garbage In, Garbage Out principle.
Because you are projecting numbers years into the future, a tiny tweak to your baseline numbers can completely swing the final valuation.
Sensitivity Analysis
Consider how highly reactive the model is to minor adjustments:
If you change a company's projected revenue growth rate from 8% to 6%, your final stock valuation might drop by 20%.
If you change your discount rate from 9% to 10%, the present value of your terminal value drops dramatically, slashing the estimated worth of the business.
Because of this vulnerability, good analysts never rely on a single, static DCF number. Instead, they build a Sensitivity Table (or a matrix) that shows a wide range of values based on different combinations of growth rates and discount rates.
Furthermore, a DCF model works horribly for companies that are losing massive amounts of money unpredictably, such as early-stage biotech startups or fast-growing tech companies with erratic cash cycles. If you cannot project cash flows with a reasonable degree of confidence, your DCF model becomes nothing more than structured guessing.
For an advanced look at how professional financial institutions handle these systemic model risks, read through the valuation guides published by Damodaran Online from New York University, curated by Professor Aswath Damodaran, widely known as the "Dean of Valuation."
Alternative Valuation Methods
Because a DCF model relies heavily on projections, smart investors cross-reference their DCF results with alternative valuation techniques to see if their numbers align with broader market realities.
Comparable Companies Analysis (CCA)
Commonly called "Comps," this technique ignores future projections entirely and looks at what similar businesses are currently selling for in the open market. It uses ratios like Price-to-Earnings (P/E) or Enterprise Value-to-Sales (EV/Sales) to establish a baseline.
Analogy: If you are trying to sell your house, a DCF model calculates the value based on the potential future rent you could collect. A "Comps" approach simply looks at what three similar houses on your street sold for last month.
Precedent Transactions
This approach looks at historical mergers and acquisitions. It analyzes what price tag real-world corporate buyers paid to acquire similar companies in recent years. This helps capture the acquisition premium the extra fee a buyer is usually willing to pay to take complete control of a business.
Conclusion
Discounted Cash Flow modelling might seem like an elite technique reserved exclusively for Wall Street suits and math geniuses, but it is ultimately driven by common-sense principles. It forces you to look past market hype and ask the ultimate investment question: How much real cash will this asset generate for me, and what is that cash stream worth today?
By understanding how cash flows, discount rates, and terminal values interact, you gain a massive advantage. You cease viewing stocks as volatile lottery tickets on a screen and start viewing them for what they truly are—fractional ownership stakes in real businesses with real economic boundaries.
