DCF Valuation Skill

Workflow Checklist

Copy and track progress:

DCF Analysis Progress:

• Step 1: Gather financial data
• Step 2: Calculate FCF growth rate
• Step 3: Estimate discount rate (WACC)
• Step 4: Project future cash flows (Years 1-5 + Terminal)
• Step 5: Calculate present value and fair value per share
• Step 6: Run sensitivity analysis
• Step 7: Validate results
• Step 8: Present results with caveats

Step 1: Gather Financial Data

Call the financial_search tool with these queries:

1.1 Cash Flow History

Query: "[TICKER] annual cash flow statements for the last 5 years"

Extract: free_cash_flow , net_cash_flow_from_operations , capital_expenditure

Fallback: If free_cash_flow missing, calculate: net_cash_flow_from_operations - capital_expenditure

1.2 Financial Metrics

Query: "[TICKER] financial metrics snapshot"

Extract: market_cap , enterprise_value , free_cash_flow_growth , revenue_growth , return_on_invested_capital , debt_to_equity , free_cash_flow_per_share

1.3 Balance Sheet

Query: "[TICKER] latest balance sheet"

Extract: total_debt , cash_and_equivalents , current_investments , outstanding_shares

Fallback: If current_investments missing, use 0

1.4 Analyst Estimates

Query: "[TICKER] analyst estimates"

Extract: earnings_per_share (forward estimates by fiscal year)

Use: Calculate implied EPS growth rate for cross-validation

1.5 Current Price

Query: "[TICKER] price snapshot"

Extract: price

1.6 Company Facts

Query: "[TICKER] company facts"

Extract: sector , industry , market_cap

Use: Determine appropriate WACC range from sector-wacc.md

Step 2: Calculate FCF Growth Rate

Calculate 5-year FCF CAGR from cash flow history.

Cross-validate with: free_cash_flow_growth (YoY), revenue_growth , analyst EPS growth

Growth rate selection:

• Stable FCF history → Use CAGR with 10-20% haircut

• Volatile FCF → Weight analyst estimates more heavily

• Cap at 15% (sustained higher growth is rare)

Step 3: Estimate Discount Rate (WACC)

Use the sector from company facts to select the appropriate base WACC range from sector-wacc.md.

Default assumptions:

• Risk-free rate: 4%

• Equity risk premium: 5-6%

• Cost of debt: 5-6% pre-tax (~4% after-tax at 30% tax rate)

Calculate WACC using debt_to_equity for capital structure weights.

Reasonableness check: WACC should be 2-4% below return_on_invested_capital for value-creating companies.

Sector adjustments: Apply adjustment factors from sector-wacc.md based on company-specific characteristics.

Step 4: Project Future Cash Flows

Years 1-5: Apply growth rate with 5% annual decay (multiply growth rate by 0.95, 0.90, 0.85, 0.80 for years 2-5). This reflects competitive dynamics.

Terminal value: Use Gordon Growth Model with 2.5% terminal growth (GDP proxy).

Step 5: Calculate Present Value

Discount all FCFs → sum for Enterprise Value → subtract Net Debt → divide by outstanding_shares for fair value per share.

Step 6: Sensitivity Analysis

Create 3×3 matrix: WACC (base ±1%) vs terminal growth (2.0%, 2.5%, 3.0%).

Step 7: Validate Results

Before presenting, verify these sanity checks:

EV comparison: Calculated EV should be within 30% of reported enterprise_value

• If off by >30%, revisit WACC or growth assumptions

Terminal value ratio: Terminal value should be 50-80% of total EV for mature companies

• If >90%, growth rate may be too high

• If <40%, near-term projections may be aggressive

Per-share cross-check: Compare to free_cash_flow_per_share × 15-25 as rough sanity check

If validation fails, reconsider assumptions before presenting results.

Step 8: Output Format

Present a structured summary including:

• Valuation Summary: Current price vs. fair value, upside/downside percentage

• Key Inputs Table: All assumptions with their sources

• Projected FCF Table: 5-year projections with present values

• Sensitivity Matrix: 3×3 grid varying WACC (±1%) and terminal growth (2.0%, 2.5%, 3.0%)

• Caveats: Standard DCF limitations plus company-specific risks