Discounted Cash Flow (DCF) Calculator
Understanding Discounted Cash Flow (DCF)
Discounted Cash Flow (DCF) is a valuation method used to estimate the value of an investment based on its expected future cash flows. DCF analysis attempts to figure out the value of an investment today, based on projections of how much money it will generate in the future.
This is a fundamental concept in finance, often referred to as "Intrinsic Value" modeling. Whether you are analyzing a stock, a private business, or a real estate project, the DCF method provides a rigorous framework for determining if the current price is justified by future earnings potential.
The Core Principle: Time Value of Money
The DCF method is built on the Time Value of Money (TVM). A dollar today is worth more than a dollar tomorrow because that dollar can be invested and earn interest. Therefore, when we look at cash flows occurring 5 or 10 years from now, we must "discount" them back to their present value to understand what they are worth to us right now.
The DCF Formula
The DCF calculation involves two primary components: the present value of projected cash flows for a specific period (usually 5-10 years) and the "Terminal Value," which represents the value of the business beyond the projection period.
Net Present Value (NPV)
Where:
- = Cash flow in year
- = Discount rate (often the Weighted Average Cost of Capital, or WACC)
- = Number of years in the projection period
- = Terminal Value
Terminal Value (Gordon Growth Model)
Where:
- = Perpetual growth rate (usually aligned with long-term GDP growth)
How to Use This Calculator
- Initial Investment: Enter the current cost of the investment or the current market capitalization of the company.
- Discount Rate: This is your required rate of return. For a company, this is usually the WACC (Weighted Average Cost of Capital). Higher risk investments require a higher discount rate.
- Cash Flows: Enter the expected free cash flow for each year. You can add multiple years to increase the accuracy of your projection.
- Terminal Growth Rate: This is the rate at which you expect the company to grow indefinitely after the projection period. It is typically between 1% and 3%.
Worked Examples
Example 1: Small Business Acquisition
Suppose you are looking to buy a local bakery.
- Initial Investment: $500,000
- Projected Cash Flows: 60k, $70k (3 years)
- Discount Rate: 10%
- Terminal Growth: 2%
Calculation:
- PV Year 1: 45,454
- PV Year 2: 49,586
- PV Year 3: 52,592
- Terminal Value: (892,500
- PV of TV: 670,548
- Enterprise Value: 49,586 + 670,548 = $818,180
- NPV: 500,000 = $318,180 (A profitable investment)
Limitations of DCF Analysis
While DCF is a powerful tool, it is highly sensitive to its inputs—a phenomenon often called "Garbage In, Garbage Out."
- Sensitivity: Small changes in the discount rate or terminal growth rate can lead to massive swings in valuation.
- Projection Error: Forecasting cash flows 5-10 years into the future is inherently difficult and often inaccurate.
- Complexity: It requires a deep understanding of the business's capital structure to calculate an accurate WACC.
Frequently Asked Questions
What is a good discount rate to use?
For most established large-cap companies, a discount rate between 7% and 10% is common. For startups or riskier ventures, investors often use 15% to 30%.
Why can't the growth rate be higher than the discount rate?
If the terminal growth rate () is higher than the discount rate (), the formula for terminal value results in a negative number, which is mathematically impossible for a perpetual valuation. In reality, no company can grow faster than the overall economy forever.
What is the difference between Enterprise Value and Equity Value?
Enterprise Value is the value of the entire business (to both debt and equity holders). To get Equity Value (what shareholders own), you must subtract the company's debt and add its cash from the Enterprise Value.
Is DCF better than P/E ratios?
DCF is considered more theoretically sound because it focuses on cash generation rather than accounting earnings. However, P/E ratios are faster and easier to use for quick comparisons.
How many years should I project?
Most analysts use 5 or 10 years. Projecting more than 10 years is usually considered too speculative to be useful.