dcf-model
Real DCF (Discounted Cash Flow) model creation for equity valuation. Retrieves financial data from SEC filings and analyst reports, builds comprehensive cash flow projections with proper WACC calculations, performs sensitivity analysis, and outputs professional Excel models with executive summaries. Use when users need to value a company using DCF methodology, request intrinsic value analysis, or ask for detailed financial modeling with growth projections and terminal value calculations.
npx skills add majiayu000/claude-skill-registry --skill dcf-model --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
What it does
Creates institutional-quality DCF models for equity valuation, producing a detailed Excel model with scenario-based projections and built-in sensitivity analyses. It emphasizes using data from MCP servers, user data, and the web, and delivers outputs suitable for executive summaries.
How it works
- Data retrieval and validation: fetch data from MCP servers, user data, and the web; validate key items such as net debt vs net cash, diluted shares, margins, revenue growth, and tax rate.
- Historical analysis (3-5 years): analyze revenue growth, margins, capital intensity, working capital efficiency, and returns; generate summary tables of historical metrics.
- Build revenue projections: start from latest revenue and apply growth rates for each year; present both dollar amounts and growth percentages; support Bear/Base/Bull scenarios.
- Operating expense modeling: model S&M, R&D, and G&A as % of revenue with operating leverage; compute EBIT from gross profit minus operating expenses; plan margin progression to target state by year.
- Free cash flow calculation: compute NOPAT, add D&A, subtract CapEx and ΔNWC to derive Unlevered FCF; model CapEx and working capital as % of revenue; distinguish maintenance vs growth CapEx.
- WACC research: compute cost of equity via CAPM, estimate after-tax debt cost, and determine weights to derive WACC; handle cases with net debt or no debt.
- Discounting: apply mid-year convention, compute PV of FCF for each projection year, and determine PV of terminal value.
- Terminal value: use Perpetuity Growth Method with terminal growth rate; ensure terminal growth < WACC; provide an optional Exit Multiple method:
- Terminal Value via EBITDA × Exit Multiple; discount to present value.
- Bridge to equity value: assemble EV, subtract net debt (or add net cash), use diluted shares to derive implied price per share and compare to current price.
- Sensitivity analysis: build three 2D grids at the bottom of the DCF sheet (WACC vs terminal growth; revenue growth vs EBIT margin; beta vs risk-free rate), each containing a full recalculation per cell.
When to use it
Use when a user needs to value a company using DCF methodology, requests intrinsic value analysis, or asks for detailed financial modeling with growth projections and terminal value calculations.
What it can touch
- Uses tools declared as claude-code for data access and model construction.
- References to data sources, consolidation columns, and scenario blocks are implemented through INDEX-based references as described in the instructions.
Caveats
- The model requires completing and maintaining detailed scenario blocks (Bear/Base/Bull) with explicit year headers and consolidation columns; misalignment can break calculations.
- Terminal growth must be less than WACC to yield finite value; this constraint is explicitly stated.
- All sensitivity grids must populate every cell with a full DCF recalculation; partial or placeholder values are not allowed.
- The workflow expects stepwise execution: define block positions, then write formulas, then test for errors, and finally run the recalc script.
# DCF Model Builder ## Overview This skill creates institutional-quality DCF models for equity valuation following investment banking standards. Each analysis produces a detailed Excel model (with sensitivity analysis included at the bottom of the DCF sheet). ## Tools - Default to using all of the information provided by the user and MCP servers available for data sourcing. ## Critical Constraints - Read These First These constraints apply throughout all DCF model building. Review before starting: **Sensitivity Tables:** - Populate ALL 75 cells (3 tables × 25 cells) with full DCF recalculation formulas - Use openpyxl loops to write formulas programmatically - NO placeholder text, NO linear approximations, NO manual steps required - Each cell must recalculate full DCF for that assumption combination **Cell Comments:** - Add cell comments AS each hardcoded value is created - Format: "Source: [System/Document], [Date], [Reference], [URL if applicable]" - Every blue input must have a comment before moving to next section - Do not defer to end or write "TODO: add source" **Model Layout Planning:** - Define ALL section row positions BEFORE writing any formulas - Write ALL headers and lab
- Overview
- Tools
- Critical Constraints - Read These First
- DCF Process Workflow
- Step 1: Data Retrieval and Validation
- Step 2: Historical Analysis (3-5 years)
- Step 3: Build Revenue Projections
- Step 4: Operating Expense Modeling
- Step 5: Free Cash Flow Calculation
- Step 6: Cost of Capital (WACC) Research
- Step 7: Discount Rate Application (5-10 Year Forecast)
- Step 8: Terminal Value Calculation
- Step 9: Enterprise to Equity Value Bridge
- Step 10: Sensitivity Analysis
python recalc.py [path_to_excel_file] [timeout_seconds] python recalc.py AAPL_DCF_Model_2025-10-12.xlsx 30
What does the dcf-model skill do?
Real DCF (Discounted Cash Flow) model creation for equity valuation. Retrieves financial data from SEC filings and analyst reports, builds comprehensive cash flow projections with proper WACC calculations, performs sensitivity analysis, and outputs professional Excel models with executive summaries. Use when users need to value a company using DCF methodology, request intrinsic value analysis, or ask for detailed financial modeling with growth projections and terminal value calculations.
How do I install it?
Run `npx skills add majiayu000/claude-skill-registry --skill dcf-model --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From majiayu000/claude-skill-registry, a repository with 534 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.