calculate_dcf_valuation
Calculate a stock's intrinsic value using discounted cash flow analysis. Get 5-year projections, terminal value, and investment recommendation with upside/downside.
Instructions
DCF Valuation | Intrinsic Value | Investment Analysis - Calculate intrinsic value using Discounted Cash Flow (DCF) analysis. Get 5-year cash flow projections, terminal value, and investment recommendations.
What DCF Analysis Provides:
Intrinsic Value: Fair value per share based on future cash flows
Investment Recommendation: Strong Buy, Buy, Hold, Sell, Strong Sell
Upside/Downside: Percentage difference vs current market price
5-Year Projections: Revenue and free cash flow forecasts
Sensitivity Analysis: How valuation changes with different assumptions
Key Inputs (customizable):
Revenue growth rates (5-year projection)
Free cash flow margin
WACC (Weighted Average Cost of Capital)
Terminal growth rate
Shares outstanding, debt, cash
Investment Recommendations:
Strong Buy: >30% upside
Buy: 15-30% upside
Hold: -10% to 15%
Sell: -25% to -10%
Strong Sell: <-25% downside
Sensitivity Analysis: Tests valuation sensitivity to:
WACC changes (+/- 2%)
Terminal growth rate changes (+/- 1%)
Free cash flow margin changes (+/- 5%)
Use Cases:
"Calculate intrinsic value for Apple"
"Is Tesla overvalued or undervalued?"
"DCF analysis for NVDA with sensitivity"
"What is Microsoft worth based on DCF?"
"Should I buy this stock?" (based on DCF)
Returns: Intrinsic value, current price comparison, recommendation, projections, optional sensitivity analysis.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| symbol | Yes | Stock ticker symbol to value (e.g., "AAPL", "TSLA"). Required. | |
| customInputs | No | Optional custom inputs to override default assumptions. If not provided, defaults are calculated from historical data and market conditions. | |
| includeSensitivity | No | When true, includes sensitivity analysis showing how valuation changes with: WACC (+/- 2%), terminal growth rate (+/- 1%), and FCF margin (+/- 5%). Useful for understanding valuation robustness. Default: false. |