现金流折现(DCF)计算器
分类: UncategorizedEstimate 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.
| 内在价值 | Discount Rate | ||||||
|---|---|---|---|---|---|---|---|
| Terminal Growth | 8.0% | 9.0% | 10.0% | 11.0% | 12.0% | 13.0% | 14.0% |
Sensitivity Analysis Chart
DCF Calculation Breakdown
| 年 | Projected FCF | 增长率 | 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 | |||
| 已发行股数 | 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.
风险评估
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
- 安全边际: 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.
Uncategorized 相关工具
没有相关工具。
本工具计算什么
将预期未来现金流折算为现值。
- 公式
DCF = Σ CFₜ ÷(1 + r)ᵗ,另加终值 CF·(1+g) ÷(r − g)- 计算示例
- 三年后收取 100 港元,以 8% 折现,现值为 100 ÷ 1.08³ ≈ 79.38 港元。
- 何时使用
- 按资产实际能产生的现金估值,而非按他人愿付的价格。
- 常见错误
- 终值往往主导整个结果,却是最不可靠的输入。r 或 g 的微小改动足以令估值大幅偏离。