返回 Skill 市集

Fundamentals & Valuation

DCF Valuation

Build a discounted cash flow valuation with transparent assumptions, sensitivity tables, and scenario analysis. Use when the user asks for intrinsic valuation, fair value ranges, or assumption-driven valuation work.

由 Alphio 審核71 天前更新1 分鐘內設定完

總覽

Build a discounted cash flow valuation with transparent assumptions, sensitivity tables, and scenario analysis.

Build a discounted cash flow valuation with transparent assumptions, sensitivity tables, and scenario analysis.

Skill.md

這個 Skill 如何運作

Build a discounted cash flow valuation with transparent assumptions, sensitivity tables, and scenario analysis. Use when the user asks for intrinsic valuation, fair value ranges, or assumption-driven valuation work.

SKILL.mdALPHIO / 已驗證

Use This Skill When

  • The user wants an intrinsic valuation anchored in explicit cash flow assumptions.
  • The task requires understanding how long-term growth, margins, reinvestment, and discount rate drive value.
  • The analysis needs a valuation range, sensitivity framing, and scenario logic rather than a single target price.
  • The output should make assumption risk visible and auditable.

Required Inputs

  • company and, if available, ticker
  • forecast horizon: usually 5 to 10 years
  • revenue assumptions: growth path, segment mix, pricing, volume, or TAM constraints
  • profitability assumptions: gross margin, operating margin, tax rate
  • reinvestment assumptions: capex, working capital, capitalized R&D if relevant, acquisitions if explicitly modeled
  • discount rate inputs: cost of equity, WACC, debt, capital structure, country or size risk if relevant
  • terminal value approach: perpetual growth or exit multiple, plus rationale
  • share count, net debt, minority interest, or other equity bridge items if equity value is needed
  • If important inputs are missing, use a clearly labeled placeholder range, reduce confidence in the output, and explain which assumption dominates the result.

Workflow

  1. Define the valuation objective, forecast horizon, and whether the model is FCFF, FCFE, or another structure.
  2. Lay out the operating forecast:
    • revenue growth path
    • margin path
    • tax path
    • reinvestment needs
  3. Translate operating assumptions into cash flow, making the reinvestment burden explicit.
  4. Define the discount rate and why it is appropriate for the business and risk profile.
  5. Define terminal assumptions and explain why they are economically plausible.
  6. Build bull, base, and bear cases with a concise narrative behind each case.
  7. Run sensitivities around the variables that matter most, usually growth, margin, WACC, and terminal assumptions.
  8. Conclude with a valuation range, the dominant drivers, and the assumptions that would invalidate the current range.

Output Requirements

  • Show every major assumption explicitly.
  • State whether the valuation is enterprise value or equity value and show the bridge if needed.
  • Highlight terminal value dependence.
  • Use ranges when the underlying data quality or business uncertainty is high.
  • Mark Fact, Assumption, and Inference distinctly.
  • If placeholders are used, say so prominently and avoid presenting the result as investment-grade precision.

Output Template

Scope

  • Company:
  • Model type:
  • Forecast horizon:
  • Valuation date / reference period:

Key Assumptions

  • Revenue growth path:
  • Margin path:
  • Tax rate:
  • Reinvestment assumptions:
  • Discount rate:
  • Terminal value method:

Forecast Summary

  • Revenue:
  • Operating profit:
  • Cash flow:
  • Key inflection points:

Discounting And Terminal Value

  • Present value of forecast period:
  • Present value of terminal value:
  • Terminal value share of total value:

Bull / Base / Bear Range

  • Bull case:
  • Base case:
  • Bear case:

Sensitivity Analysis

  • WACC sensitivity:
  • Terminal growth or exit multiple sensitivity:
  • Margin sensitivity:
  • Revenue growth sensitivity:

Equity Bridge

  • Enterprise value:
  • Net debt / other adjustments:
  • Equity value:
  • Implied value per share:

Evidence Classification

  • Facts:
  • Assumptions:
  • Inferences:

Main Model Risks

  • [3-5 model or business risks.]

Quality Checks

  • Verify the cash flow build is internally consistent with the revenue and margin assumptions.
  • Check that the discount rate and terminal assumptions are economically plausible together.
  • Confirm that the terminal value does not dominate without explicit warning.
  • Ensure the bull, base, and bear cases differ in narrative and assumptions, not just arbitrary percentages.
  • Re-read the output and remove any valuation precision that the inputs cannot support.

Guardrails

  • Do not hide key assumptions inside prose; surface them explicitly.
  • Separate facts, assumptions, and inferences clearly.
  • Do not invent consensus estimates, share counts, or net debt figures.
  • Do not use a terminal growth rate that exceeds plausible long-run economic growth without justification.
  • Avoid presenting a DCF as objective truth; it is an assumption-sensitive framework.

Example Prompts

  • Build a DCF valuation for this company and show the main sensitivities.
  • Estimate fair value using a base, bull, and bear DCF framework.
  • Create an auditable DCF with explicit operating assumptions, an equity bridge, and a sensitivity range.

最適合用於

何時使用

Build a discounted cash flow valuation with transparent assumptions, sensitivity tables, and scenario analysis. Use when the user asks for intrinsic valuation, fair value ranges, or assumption-driven valuation work.

01 · 會前準備

準備決策簡報

The user wants an intrinsic valuation anchored in explicit cash flow assumptions. The task requires understanding how long-term growth, margins, reinvestment, and discount rate drive value. The analysis needs a valuation range, sensitivity framing, and scenario logic rather than a single target price. The output should make assumption risk visible and auditable.

02 · 團隊協作

統一交接標準

讓分析師、投資組合經理與 Agent 產出一致的研究結果。

03 · 即時更新

更新投資邏輯

出現新催化劑、KPI 發布或財報結果後,更新情境假設。

社群回饋

越用越好用。

隨著 Skill 被使用與評審,回饋將顯示在這裡。

提交回饋

探索更多

相關 Skills

查看全部
免費開始