Build FCF projection formulas (link to assumptions)
Calculate PV of FCF and terminal value
Create sensitivity table
Apply professional formatting
4. Return Results
Provide:
Enterprise value
Equity value (if net debt provided)
Key assumptions used
Link to sensitivity analysis
Example Usage
User: /build-dcf
Claude: I'll build a DCF model. What company would you like to value?
User: Apple
Claude: What base year revenue should we use?
User: $383 billion (2023)
Claude: What revenue growth rates for Years 1-5?
User: 8%, 7%, 6%, 5%, 4%
Claude: [Builds complete DCF model]
✅ DCF Model Complete!
Enterprise Value: $3.24 trillion
📁 Saved to: Apple_DCF_Model.xlsx
Notes
This command manually triggers the excel-dcf-modeler Skill
Users can also just say "Create a DCF model" for auto-invocation
Use this command when you want explicit control over when the Skill loads
1---2name: 2126-build-dcf-39ac5e653description: Build DCF Model4---5# Build DCF Model67Build a discounted cash flow (DCF) valuation model in Excel with professional formatting and investment banking-grade structure.89## What This Command Does1011Creates a complete 4-sheet DCF model:121. **Assumptions** - Revenue growth, margins, WACC, terminal growth132. **FCF Projections** - 5-year free cash flow forecast143. **Valuation** - Present value calculations and enterprise value154. **Sensitivity** - Two-way sensitivity table (WACC vs terminal growth)1617## Instructions for Claude1819When the user types `/build-dcf`, follow these steps:2021### 1. Gather Inputs2223Ask the user for:24- Company name and ticker25- Base year revenue (most recent fiscal year)26- Revenue growth rates for Years 1-527- EBITDA margin %28- Tax rate %29- Optional: WACC, terminal growth, D&A %, CapEx %, NWC %3031### 2. Validate Inputs3233Ensure:34- Revenue growth rates are reasonable (0-30%)35- EBITDA margin is positive36- Tax rate is 0-40%37- Terminal growth < WACC3839### 3. Build Model4041Use Excel MCP server to:421. Create new workbook432. Create 4 sheets443. Populate assumptions454. Build FCF projection formulas (link to assumptions)465. Calculate PV of FCF and terminal value476. Create sensitivity table487. Apply professional formatting4950### 4. Return Results5152Provide:53- Enterprise value54- Equity value (if net debt provided)55- Key assumptions used56- Link to sensitivity analysis5758## Example Usage5960```61User: /build-dcf6263Claude: I'll build a DCF model. What company would you like to value?6465User: Apple6667Claude: What base year revenue should we use?6869User: $383 billion (2023)7071Claude: What revenue growth rates for Years 1-5?7273User: 8%, 7%, 6%, 5%, 4%7475Claude: [Builds complete DCF model]7677✅ DCF Model Complete!78Enterprise Value: $3.24 trillion79📁 Saved to: Apple_DCF_Model.xlsx80```8182## Notes8384- This command manually triggers the excel-dcf-modeler Skill85- Users can also just say "Create a DCF model" for auto-invocation86- Use this command when you want explicit control over when the Skill loads
Run npx skillmds@latest add tools-only/2126-build-dcf-39ac5e65 in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.
Build DCF Model It is listed under AI & ML on SkillMD.
This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.
This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.
Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.
tools-only (@tools-only) published this skill. Their other Agent Skills are listed on their SkillMD profile.
tools-only