Agent skill · business finance · claude-office-skills
dcf-valuation
Build Discounted Cash Flow (DCF) valuation models. Calculate intrinsic value with customizable assumptions. Generate professional valuation reports.
Why this skill is useful
Provides detailed domain-specific knowledge and formulas for building DCF valuation models that the AI wouldn't reliably generate on its own.
What it needs
About 6k tokens when loaded. Last updated 2026-01-31. 363 stars on the source repository.
What this skill does
DCF Valuation Skill Overview I help you build Discounted Cash Flow (DCF) models to estimate the intrinsic value of companies. DCF is the gold standard for fundamental valuation used by investment banks, hedge funds, and professional investors. What I can do: Build complete DCF models from financial data Calculate WACC (Weighted Average Cost of Capital) Project future free cash flows Estimate terminal value (Gordon Growth or Exit Multiple) Run sensitivity analysis on key assumptions Generate professional valuation summaries What I cannot do: Guarantee accuracy of projections Account for unpredictable future events Provide investment recommendations Replace professional financial due diligence --- How to Use Me Step 1: Provide Financial Data I need: Historical financials (3-5 years of revenue, EBITDA, capex, D&A) Current shares outstanding Current stock price (optional, for comparison) Industry/sector context Step 2: Set Assumptions Key assumptions to specify (or I'll use industry defaults): Revenue growth rates (Year 1-5) EBITDA margin trajectory Capex as % of revenue Working capital changes Terminal growth rate Discount rate (WACC) Step 3: Choose Model Type Standard DCF: 5-year projection + terminal value Two-Stage DCF: High growth + stable growth phases Three-Stage DCF: Growth, transition, maturity phases --- DCF Model Framework Step 1: Project Free Cash Flow (FCF) Step 2: Calculate WACC CAPM Formula for Cost of Equity Step 3: Calculate Terminal Value Method A: Gordon Growth Model Method B: Exit Multiple Step 4: Discount to Present Value --- Output Format --- Example User Request My Response [Complete DCF model with all calculations...] --- Tips for Better Results 1. Provide historical data for more accurate projections 2. Be explicit about growth assumptions rather than using defaults 3. Specify the industry for appropriate comparables 4. Request sensitivity analysis to understand valuation range 5. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills claude-office-skills/dcf-valuation