Jst-Well-Dan/excel-dcf-modeler
business-analyst/excel-dcf-modeler/SKILL.md
Build discounted cash flow (DCF) valuation models in Excel. Use when creating DCF models, calculating enterprise value, or valuing companies. Trigger with phrases like 'excel dcf', 'build dcf model', 'calculate enterprise value'.
$ install --global
skillsauthnpx skillsauth add Jst-Well-Dan/Skill-Box excel-dcf-modelerInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 24, 2026, 8:39 PM1.8s1 file scanned
SKILL.md
- name:
- excel-dcf-modeler
- description:
- |
- allowed-tools:
- Read, Write, Edit, Grep, Glob, Bash(cmd:*)
- version:
- 1.0.0
- author:
- Jeremy Longshore <[email protected]>
- license:
- MIT
Excel DCF Modeler
Overview
Creates professional DCF valuation models following investment banking standards with WACC calculations and sensitivity analysis.
Prerequisites
- Excel or compatible spreadsheet software
- Historical financial data for target company
- Industry comparables for WACC estimation
Instructions
- Create assumptions sheet with revenue growth, margins, WACC, and terminal growth rate
- Build free cash flow projections (5-year forecast)
- Calculate terminal value using Gordon Growth Model
- Discount cash flows and terminal value to present value
- Sum to get enterprise value, subtract net debt for equity value
- Add sensitivity tables for key assumptions
Output
- Complete 4-sheet DCF model with assumptions, projections, valuation, and sensitivity
- Enterprise value and equity value per share
- Sensitivity analysis on WACC and terminal growth rate
Error Handling
| 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 |
Examples
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
Resources
- Damodaran Online DCF Resources
- WSO DCF Modeling Guide
{baseDir}/references/dcf-formulas.mdfor Excel formula templates
Related Skills
Jst-Well-Dan/video-frames
tools
VerifiedTrustedCommunity
Extract frames or short clips from videos using ffmpeg.
7SKILL.mdUpdated Apr 6, 2026
Jst-Well-Dan/theme-factory
tools
VerifiedTrustedCommunity
Toolkit for styling artifacts with a theme. These artifacts can be slides, docs, reportings, HTML landing pages, etc. There are 10 pre-set themes with colors/fonts that you can apply to any artifact that has been creating, or can generate a new theme on-the-fly.
7SKILL.mdUpdated Apr 6, 2026
Jst-Well-Dan/slack-gif-creator
tools
VerifiedTrustedCommunity
Toolkit for creating animated GIFs optimized for Slack, with validators for size constraints and composable animation primitives. This skill applies when users request animated GIFs or emoji animations for Slack from descriptions like "make me a GIF for Slack of X doing Y".
7SKILL.mdUpdated Apr 6, 2026
Jst-Well-Dan/remotion-best-practices
development
VerifiedTrustedCommunity
Best practices for Remotion - Video creation in React
7SKILL.mdUpdated Apr 6, 2026