Discounted Cash Flow Calculator
Estimate the present value of an investment or business based on projected future cash flows.
Yearly Breakdown
| Year | Cash Flow | Discount Factor | Present Value |
|---|
Sensitivity Analysis
| Growth \ Discount | -1% | Base | +1% |
|---|
What Is a Discounted Cash Flow (DCF) Calculator?
A Discounted Cash Flow (DCF) calculator estimates the present value of an investment based on its projected future cash flows. It applies the core principle that money today is worth more than the same amount in the future due to its potential earning capacity. This tool helps you determine what a stream of future earnings is worth right now, providing a data-driven foundation for investment decisions, business valuations, or financial planning.
How the DCF Calculation Works
The DCF formula discounts each future cash flow back to its present value using a specific rate of return, known as the discount rate. The sum of all these discounted values represents the total present value of the investment.
The core formula for a single cash flow is:
Present Value = Future Cash Flow / (1 + Discount Rate)^Number of Periods
For a multi-period investment, the total DCF value is the sum of the present values for each period. The calculator handles this summation automatically. The discount rate is the most critical input; it reflects the risk of the investment and the opportunity cost of capital. A higher discount rate reduces the present value, reflecting greater risk or higher expected returns from alternative investments.
How to Use the DCF Calculator
- Enter the Discount Rate: Input your required rate of return or the cost of capital as a percentage. This rate should reflect the risk profile of the investment.
- Input Cash Flows: Enter the projected cash flow for each future period. You can typically add or remove periods to match your forecast horizon.
- Review the Result: The calculator will display the total present value of all entered cash flows. This number represents the maximum price you should pay today to achieve your target rate of return.
Understanding Your Results
The final DCF value is a single number: the sum of all discounted cash flows. This is your estimate of the investment's intrinsic value today.
To make a decision, compare this value to the current market price or asking price of the investment:
- If DCF Value > Market Price: The investment may be undervalued and could be a good opportunity.
- If DCF Value < Market Price: The investment may be overvalued, suggesting you should wait for a better price or look elsewhere.
Remember that the DCF is only as good as its inputs. Small changes in the discount rate or cash flow projections can significantly alter the result.
Common Mistakes in DCF Analysis
- Using an Inappropriate Discount Rate: Applying a rate that does not match the investment's risk profile can lead to a misleading valuation. A stable utility company and a high-growth tech startup require very different discount rates.
- Overly Optimistic Cash Flow Projections: Assuming consistent high growth without considering market competition, economic cycles, or operational risks inflates the valuation.
- Ignoring Terminal Value: For businesses with indefinite lifespans, failing to account for cash flows beyond the forecast period can severely undervalue the asset.
- Confusing Cash Flow with Profit: DCF uses free cash flow, not net income. Non-cash charges like depreciation must be added back to get an accurate picture of cash generation.
Limitations of the DCF Model
While powerful, the DCF model has inherent limitations. It is highly sensitive to assumptions, making it less reliable for investments with unpredictable cash flows, such as early-stage startups or companies in volatile industries. The model also assumes a constant discount rate over time, which may not reflect changing market conditions. DCF is best used as one tool in a broader analysis, not as a standalone decision-maker.
Practical Use Cases for DCF
- Business Valuation: Estimating the fair value of a company for acquisition, investment, or sale.
- Project Evaluation: Assessing whether a capital project (e.g., building a new factory) will generate sufficient returns to justify the initial investment.
- Real Estate Investment: Valuing a rental property based on projected rental income and future sale price.
- Stock Analysis: Determining if a publicly traded stock is undervalued or overvalued compared to its current share price.
Frequently Asked Questions
What is a good discount rate to use?
There is no single "good" rate. It depends on the investment's risk. A common starting point is the Weighted Average Cost of Capital (WACC) for a company. For individual investments, you might use your required rate of return, which could be based on the return of a broad market index (like 8-10%) plus a risk premium.
What is the difference between DCF and Net Present Value (NPV)?
DCF calculates the present value of future cash flows. NPV takes that DCF value and subtracts the initial investment cost. If the NPV is positive, the investment is expected to generate more value than it costs. This calculator provides the DCF value, which you can then compare to the initial cost to find the NPV.
Can I use this calculator for a business valuation?
Yes, but with caution. For a complete business valuation, you would typically project cash flows for 5-10 years and then calculate a "terminal value" to account for all cash flows beyond that period. This calculator is best suited for shorter-term, discrete investment analysis. For a full business valuation, you would need to manually add a terminal value calculation.
Why does a higher discount rate lower the present value?
A higher discount rate implies a higher required return or greater perceived risk. To achieve that higher return, you must pay less for the investment today. The discount rate acts as a hurdle; the higher the hurdle, the lower the price you are willing to pay for the same future cash flows.