現金流折現(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 的微小改動足以令估值大幅偏離。