본문으로 건너뛰기
cccskills
무료GitHub에 공개

"biz-dcf"

"Build Discounted Cash Flow (DCF) valuation models to estimate intrinsic value. Use this skill when the user needs to value a company, evaluate an investment, estimate fair share price, or build financial projections — even if they say 'what is this company worth', 'should we acquire them', or 'build me a valuation model'.".

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

실행 점수 미검증

설치 방법 보기

포함된 파일(5)

  • SKILL.md5.3 KB
  • examples/sample_input.json584 B
  • references/comparables.md7.7 KB
  • references/wacc-calculation.md8.9 KB
  • scripts/dcf.py5.4 KB

SKILL.md(원문)

설치하기 전에 에이전트에게 전달되는 지시 내용을 확인할 수 있습니다.

Discounted Cash Flow (DCF) Valuation

Overview

DCF estimates a company's intrinsic value by projecting future free cash flows and discounting them to present value using WACC. It answers "what is this business worth based on its future cash generation ability?"

When to Use

Trigger conditions:

  • User needs to value a company or business unit
  • User evaluating M&A targets or investment opportunities
  • User asks "what's the fair price?" or "build a valuation model"

When NOT to use:

  • For early-stage startups with no revenue → use comparables or venture method
  • For quick relative valuation → use multiples (P/E, EV/EBITDA)
  • For portfolio-level decisions → use BCG Matrix

Framework

IRON LAW: Garbage In, Garbage Out

DCF output is ONLY as good as its assumptions. Every assumption (growth rate,
margin, WACC, terminal growth) must be explicitly stated with justification.
A DCF without an assumptions table is worthless.
IRON LAW: Terminal Value Dominates — Handle with Care

Terminal value typically represents 60-80% of total DCF value. If your
terminal growth rate exceeds long-term GDP growth (~2-3%), you're implying
the company will eventually become larger than the economy. Cap terminal
growth at the risk-free rate or GDP growth.

Step 1: Project Free Cash Flows (5-10 years)

FCF = EBIT × (1 - Tax Rate) + Depreciation - CapEx - ΔWorking Capital

Build projections from:

  • Revenue growth assumptions (top-down or bottom-up)
  • Operating margin trajectory
  • Capital expenditure requirements
  • Working capital changes

Step 2: Calculate WACC

WACC = (E/V × Re) + (D/V × Rd × (1 - Tax))

Where:

  • Re = Cost of equity (use CAPM: Rf + β × Market Risk Premium)
  • Rd = Cost of debt (interest rate on borrowings)
  • E/V = Equity weight, D/V = Debt weight

Step 3: Calculate Terminal Value

Gordon Growth Model (preferred):

TV = FCF_final × (1 + g) / (WACC - g)

Where g = terminal growth rate (cap at 2-3%)

Exit Multiple Method (alternative):

TV = EBITDA_final × EV/EBITDA multiple

Step 4: Discount to Present Value

Enterprise Value = Σ FCFt / (1 + WACC)^t + TV / (1 + WACC)^n
Equity Value = Enterprise Value - Net Debt
Per Share Value = Equity Value / Shares Outstanding

Step 5: Sensitivity Analysis

Test key assumptions: WACC (±1%), terminal growth (±0.5%), revenue growth (±2%). Present as a sensitivity table.

Output Format

# DCF Valuation: {Company}

## Key Assumptions
| Assumption | Value | Justification |
|-----------|-------|---------------|
| Revenue growth (Y1-5) | X% | {basis} |
| Operating margin (terminal) | X% | {basis} |
| WACC | X% | {calculation} |
| Terminal growth | X% | {basis} |

## Projected Free Cash Flows
| Year | Revenue | EBIT | FCF |
|------|---------|------|-----|
| Y1 | ... | ... | ... |

## Valuation Summary
- PV of FCFs: $X
- PV of Terminal Value: $X (X% of total)
- Enterprise Value: $X
- Less: Net Debt: $X
- Equity Value: $X
- Per Share: $X

## Sensitivity Table
| WACC \ Terminal g | 1.5% | 2.0% | 2.5% |
|-------------------|------|------|------|
| 8% | $X | $X | $X |
| 9% | $X | $X | $X |
| 10% | $X | $X | $X |

Examples

Correct Application

Scenario: DCF for a Taiwanese SaaS company (ARR NT$500M, growing 25%)

  • Projected 5 years of FCF with declining growth (25% → 15%)
  • WACC 10.5% (justified: Rf 1.5%, β 1.2, ERP 6%, debt cost 4%)
  • Terminal growth 2.5% (Taiwan GDP growth proxy)
  • TV = 72% of enterprise value — within normal range ✓
  • Sensitivity table shows $X range across ±1% WACC

Incorrect Application

  • Terminal growth rate of 8% → Implies the company outgrows the economy forever. Violates Iron Law.
  • No assumptions table — just "Enterprise Value = NT$2.5B" → No way to validate. Violates Iron Law.

Gotchas

  • Terminal value sensitivity: Small changes in terminal growth or WACC swing valuation 20-30%. Always present a range, not a point estimate.
  • Circular reference in WACC: WACC needs equity value (market cap), but DCF calculates equity value. Iterate or use target capital structure.
  • FCF vs Net Income: DCF uses Free Cash Flow, not earnings. Companies with high capex or working capital needs can have positive earnings but negative FCF.
  • Country risk premium: For Taiwan/emerging market companies, add a country risk premium to WACC (typically 1-3%).
  • Negative FCF in early years: Growth companies may have negative FCF initially. This is fine — the value comes from later years and terminal value.

Scripts

ScriptDescriptionUsage
scripts/dcf.pyCompute DCF enterprise value with terminal valuepython scripts/dcf.py --help

Run python scripts/dcf.py --verify to execute built-in sanity tests.

References

  • For WACC calculation details, see references/wacc-calculation.md
  • For comparable company multiples approach, see references/comparables.md

리뷰

아직 리뷰가 없습니다. 사용해 본 소감을 남겨 주세요.

댓글

로그인 없이 쓸 수 있습니다. 사용 후기, 질문, 작동하지 않은 환경 등을 편하게 남겨 주세요.

아직 댓글이 없습니다. 첫 댓글을 남겨 보세요.

보내면 바로 공개됩니다. 이메일 주소나 전화번호 같은 개인 정보는 쓰지 마세요. URL은 2개까지입니다.

0 / 1,000자

이 양식은 reCAPTCHA로 보호되며 Google 개인정보처리방침 및 서비스 약관이 적용됩니다.

같은 저장소의 스킬

"Implement and select ad bidding strategies from manual CPC to automated target-CPA and target-ROAS. Use this skill when the user needs to choose a bidding strategy, set up automated bidding, or optimize bid parameters — even if they say 'what bidding strategy should I use', 'target CPA setup', or 'smart bidding configuration'.".

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

charlieviettq/awesome-agent-skill262026년 7월 20일 업데이트

"Optimize advertising budget allocation across campaigns using marginal returns analysis. Use this skill when the user needs to distribute budget across multiple campaigns, optimize spend pacing, or maximize overall ROAS under budget constraints — even if they say 'how to split my ad budget', 'campaign budget optimization', or 'diminishing returns on ad spend'.".

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

charlieviettq/awesome-agent-skill262026년 7월 20일 업데이트

"Build CTR prediction models for estimating ad click-through rates from features. Use this skill when the user needs to predict click probability, build an ad ranking model, or evaluate ad creative performance — even if they say 'predict click rate', 'ad relevance scoring', or 'which ad will get more clicks'.".

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

charlieviettq/awesome-agent-skill262026년 7월 20일 업데이트

"Implement Generalized Second Price auction for ad slot allocation and pricing. Use this skill when the user needs to understand search ad auctions, compute ad positions and costs-per-click, or analyze bidding dynamics — even if they say 'how does Google Ads auction work', 'ad rank calculation', or 'second price auction for ads'.".

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

charlieviettq/awesome-agent-skill262026년 7월 20일 업데이트

"Implement VCG mechanism for incentive-compatible ad slot allocation with truthful bidding. Use this skill when the user needs to design a truthful auction mechanism, compute externality-based payments, or understand why platforms may prefer GSP over VCG — even if they say 'truthful auction design', 'VCG payments', or 'incentive-compatible mechanism'.".

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

charlieviettq/awesome-agent-skill262026년 7월 20일 업데이트

"Explain blockchain fundamentals including distributed ledger architecture, consensus mechanisms, and block structure. Use this skill when the user needs to understand blockchain concepts, evaluate whether blockchain fits a use case, or design a blockchain-based solution — even if they say 'how does blockchain work', 'do I need blockchain', or 'distributed ledger'.".

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

charlieviettq/awesome-agent-skill262026년 7월 20일 업데이트

charlieviettq의 스킬 모두 보기

이 스킬의 문제 신고