Discounted Cash Flow (DCF) Calculator
Category: Fundamental & Economic ToolsEstimate the intrinsic value of a stock based on projected future cash flows discounted to their present value
Company Information
Valuation Inputs
Growth Assumptions
Discount Rate
Valuation Results
Projected Cash Flows
Value Breakdown
Sensitivity Analysis
The table below shows how the estimated intrinsic value changes based on different combinations of discount rates and terminal growth rates.
| Intrinsic Value | Discount Rate | ||||||
|---|---|---|---|---|---|---|---|
| Terminal Growth | 8.0% | 9.0% | 10.0% | 11.0% | 12.0% | 13.0% | 14.0% |
Sensitivity Analysis Chart
DCF Calculation Breakdown
| Year | Projected FCF | Growth Rate | Discount Factor | Present Value |
|---|---|---|---|---|
| Terminal Value | $2,591M | 2.5% | 0.3855 | $159.1B |
| Sum of Present Values | $215.4B | |||
| Net Cash/(Debt) | $0.0B | |||
| Equity Value | $215.4B | |||
| Shares Outstanding | 1.0B | |||
| Intrinsic Value Per Share | $215.37 | |||
Valuation Analysis
Valuation Assessment
Based on the DCF analysis, the stock appears to be undervalued by 43.6% compared to the current market price. This suggests potential for capital appreciation if the market eventually recognizes the company's intrinsic value.
Sensitivity Analysis
The intrinsic value is moderately sensitive to changes in the discount rate and terminal growth rate. Even with more conservative assumptions (discount rate of 12% and terminal growth of 1.5%), the stock still appears undervalued.
Risk Assessment
73.8% of the estimated value comes from the terminal value, indicating moderate to high uncertainty in the valuation. Consider the margin of safety price of $161.53 as a more conservative entry point.
Investment Perspective
The DCF valuation suggests a buy opportunity at the current price. However, investors should also consider qualitative factors such as competitive position, management quality, and industry trends that may not be fully captured in this quantitative analysis.
Understanding DCF Valuation
Discounted Cash Flow (DCF) analysis is a valuation method used to estimate the intrinsic value of an investment based on its expected future cash flows, discounted to reflect their present value.
Key Components of DCF
- Free Cash Flow (FCF): Cash generated by the business after accounting for operating expenses and capital expenditures
- Growth Rate: Expected annual growth of cash flows during the forecast period
- Discount Rate: Rate used to discount future cash flows to present value, typically using WACC or a risk-adjusted required return
- Terminal Value: The value of all cash flows beyond the explicit forecast period
- Margin of Safety: A discount applied to the estimated intrinsic value to account for valuation uncertainties
Interpreting DCF Results
- Undervalued (IV > Market Price): The stock may be considered for purchase as it trades below estimated intrinsic value
- Fairly Valued (IV ≈ Market Price): The stock is trading close to its estimated intrinsic value
- Overvalued (IV < Market Price): The stock may be considered expensive relative to its estimated intrinsic value
- High Terminal Value %: Greater dependence on uncertain long-term projections
- Sensitivity Analysis: Shows how changes in key assumptions impact the valuation
DCF Calculation Method
Limitations of DCF Valuation
While DCF is a powerful valuation method, it has several important limitations:
- Forecasting Uncertainty: Projections far into the future are inherently uncertain
- Terminal Value Sensitivity: Small changes in terminal growth rate can significantly impact the valuation
- Discount Rate Subjectivity: The choice of discount rate involves judgment and can dramatically affect results
- Cash Flow Stability: DCF works best for companies with predictable, stable cash flows
- Growth Assumptions: Assumes growth rates will behave as projected, which may not be realistic
For best results, use DCF in combination with other valuation methods and qualitative business analysis.
What this calculates
Present value of expected future cash flows.
- Formula
DCF = Σ CFₜ ÷ (1 + r)ᵗ, plus a terminal value of CF·(1+g) ÷ (r − g)- Worked example
- 100 HKD received in three years, discounted at 8%, is worth 100 ÷ 1.08³ ≈ 79.38 today.
- When to use it
- To value an asset from what it will actually produce rather than what others pay for it.
- Common mistake
- Terminal value often dominates the answer, and it is the least reliable input. Small changes to r or g swing the valuation enormously.