Builds DCF valuation models in Excel with FCF projections, WACC, terminal value, enterprise/equity value, and sensitivity analysis on key assumptions.
From excel-analyst-pronpx claudepluginhub nickloveinvesting/nick-love-plugins --plugin excel-analyst-proThis skill is limited to using the following tools:
assets/README.mdreferences/README.mdreferences/dcf-formulas.mdresources/REFERENCE.mdscripts/README.mdProvides UI/UX resources: 50+ styles, color palettes, font pairings, guidelines, charts for web/mobile across React, Next.js, Vue, Svelte, Tailwind, React Native, Flutter. Aids planning, building, reviewing interfaces.
Fetches up-to-date documentation from Context7 for libraries and frameworks like React, Next.js, Prisma. Use for setup questions, API references, and code examples.
Calculates TAM/SAM/SOM using top-down, bottom-up, and value theory methodologies for market sizing, revenue estimation, and startup validation.
Creates professional DCF valuation models following investment banking standards with WACC calculations and sensitivity analysis.
| Error | Cause | Solution |
|---|---|---|
| #DIV/0! in terminal value | WACC equals terminal growth | Terminal growth must be less than WACC |
| Negative FCF | High CapEx or WC needs | Review assumptions, may need different model |
| Unrealistic EV | Extreme growth assumptions | Benchmark against industry comparables |
Example: Value a SaaS Company Request: "Create a DCF model for a $50M ARR SaaS company growing 30%" Result: 4-sheet model with 5-year projections, 12% WACC, 3% terminal growth, sensitivity tables
Example: M&A Valuation Request: "DCF analysis for acquisition target" Result: Model with synergy adjustments, scenario analysis, and per-share valuation
${CLAUDE_SKILL_DIR}/references/dcf-formulas.md for Excel formula templates