excel-dcf-modeler
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 with Tessl CLI
npx tessl i github:jeremylongshore/claude-code-plugins-plus-skills --skill excel-dcf-modeler71
Does it follow best practices?
If you maintain this skill, you can automatically optimize it using the tessl CLI to improve its score:
npx tessl skill review --optimize ./path/to/skillValidation for skill structure
Discovery
89%Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.
This is a well-structured skill description with strong completeness and trigger term coverage. The explicit 'Use when' clause and trigger phrases make it easy for Claude to select appropriately. The main weakness is that the capabilities could be more specific about what actions the skill performs beyond just 'build'.
Suggestions
Expand the capabilities to list specific actions like 'project free cash flows, calculate WACC, determine terminal value, build sensitivity tables' to improve specificity
| Dimension | Reasoning | Score |
|---|---|---|
Specificity | Names the domain (DCF valuation models in Excel) and the core action (build), but doesn't list multiple specific concrete actions like 'project cash flows, calculate WACC, determine terminal value, compute enterprise value'. | 2 / 3 |
Completeness | Clearly answers both what (build DCF valuation models in Excel) and when (creating DCF models, calculating enterprise value, valuing companies) with explicit 'Use when' clause and additional trigger phrases. | 3 / 3 |
Trigger Term Quality | Includes natural keywords users would say: 'DCF', 'dcf model', 'enterprise value', 'valuing companies', 'excel dcf', 'build dcf model'. Good coverage of variations including the explicit trigger phrases. | 3 / 3 |
Distinctiveness Conflict Risk | Clear niche combining Excel + DCF/valuation domain with specific financial terminology. Unlikely to conflict with general Excel skills or other financial skills due to the specific DCF focus. | 3 / 3 |
Total | 11 / 12 Passed |
Implementation
42%Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.
This skill provides a reasonable high-level framework for DCF modeling but fails to deliver actionable, executable guidance. The instructions read like a checklist of concepts rather than specific implementation steps with formulas and cell references. For a technical Excel modeling skill, the lack of concrete formulas (e.g., actual WACC calculation, Gordon Growth formula, NPV syntax) significantly limits its utility.
Suggestions
Add concrete Excel formulas for each calculation step (e.g., '=FCF/(1+WACC)^year' for discounting, '=Terminal_FCF*(1+g)/(WACC-g)' for Gordon Growth)
Include a sample sheet structure with specific cell references showing how the 4 sheets connect (e.g., 'Assumptions!B5 feeds into Projections!C3')
Add validation checkpoints such as 'Verify: Sum of discounted FCFs + PV of terminal value = Enterprise Value' and 'Check: Terminal value should be 60-80% of total EV for mature companies'
Provide a concrete worked example with actual numbers showing inputs and expected outputs for at least one calculation
| Dimension | Reasoning | Score |
|---|---|---|
Conciseness | Reasonably efficient but includes some unnecessary context like the prerequisites section (Claude knows Excel is needed for Excel modeling) and the overview restates what's in the description. Could be tighter. | 2 / 3 |
Actionability | Instructions are vague and abstract - 'Build free cash flow projections' and 'Calculate terminal value' describe tasks without providing concrete formulas, cell references, or executable Excel guidance. No actual Excel formulas or specific implementation details. | 1 / 3 |
Workflow Clarity | Steps are listed in sequence but lack validation checkpoints. For a financial model with potential calculation errors, there's no guidance on verifying outputs (e.g., checking that FCF ties to income statement, validating WACC inputs). Error handling table is helpful but reactive rather than preventive. | 2 / 3 |
Progressive Disclosure | Good structure with clear sections, references to external resources including a local formula templates file, and appropriate organization. Content is well-organized without being monolithic or deeply nested. | 3 / 3 |
Total | 8 / 12 Passed |
Validation
81%Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.
Validation — 9 / 11 Passed
Validation for skill structure
| Criteria | Description | Result |
|---|---|---|
allowed_tools_field | 'allowed-tools' contains unusual tool name(s) | Warning |
frontmatter_unknown_keys | Unknown frontmatter key(s) found; consider removing or moving to metadata | Warning |
Total | 9 / 11 Passed | |
- Reviewed
Table of Contents
Is this your skill?
If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.