From excel-analyst-pro
Builds DCF valuation models in Excel with FCF projections, WACC, terminal value, enterprise/equity value, and sensitivity analysis on key assumptions.
npx claudepluginhub jeremylongshore/claude-code-plugins-plus-skillsThis skill is limited to using the following tools:
Creates professional DCF valuation models following investment banking standards with WACC calculations and sensitivity analysis.
Builds DCF models for equity valuation using SEC data, cash flow projections, WACC calculations, sensitivity analysis, and Excel outputs.
Builds DCF models with sensitivity analysis, Monte Carlo simulations, and scenario planning for investment valuation and risk assessment.
Performs DCF valuation using DDM, FCFE, or FCFF models with configurable growth stages, year-by-year cash flow projections, terminal value, equity bridge, per-share value, and sensitivity analysis.
Share bugs, ideas, or general feedback.
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