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'.

Quality

62%

Does it follow best practices?

Impact

Pending

No eval scenarios have been run

Securityby

Passed

No known issues

Optimize this skill with Tessl

npx tessl skill review --optimize ./plugins/business-tools/excel-analyst-pro/skills/excel-dcf-modeler/SKILL.md

Quality

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 explicit trigger guidance and a clear niche. Its main weakness is that the 'what' portion could enumerate more specific sub-tasks (e.g., WACC calculation, terminal value, sensitivity analysis) to better differentiate from a generic financial modeling skill. Overall it performs well across most dimensions.

Suggestions

Expand the capability list with more specific actions like 'project free cash flows, calculate WACC, estimate terminal value, build sensitivity tables' to improve specificity.

Dimension	Reasoning	Score
Specificity	Names the domain (DCF valuation models in Excel) and a couple of actions (build DCF models, calculate enterprise value, value companies), but doesn't list granular concrete actions like projecting free cash flows, calculating WACC, computing terminal value, or building sensitivity tables.	2 / 3
Completeness	Clearly answers both 'what' (build DCF valuation models in Excel) and 'when' (explicit 'Use when' clause with triggers, plus a 'Trigger with phrases like' section providing additional guidance).	3 / 3
Trigger Term Quality	Includes strong natural trigger terms: 'excel dcf', 'build dcf model', 'calculate enterprise value', 'valuing companies', 'DCF models'. These are phrases users would naturally say when requesting this type of work.	3 / 3
Distinctiveness Conflict Risk	Highly specific niche combining Excel, DCF modeling, and enterprise valuation. Unlikely to conflict with general Excel skills or other financial analysis skills due to the precise focus on DCF methodology.	3 / 3
	Total	11 / 12 Passed

Implementation

35%

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

This skill reads more like a high-level outline or table of contents for a DCF model rather than actionable instructions Claude could execute. The biggest weakness is the complete absence of concrete Excel formulas, cell references, or sheet layouts — the core content needed to actually build a DCF model. The error handling table is a nice touch, but the examples describe outcomes without showing any of the actual work.

Suggestions

Add concrete Excel formulas for each step (e.g., FCF = EBIT*(1-Tax) + D&A - CapEx - ΔWC, Terminal Value = FCF*(1+g)/(WACC-g), PV = FCF/(1+WACC)^n) with specific cell reference patterns or a sheet layout diagram.

Include an executable example showing the actual Excel structure — sheet names, row/column layout, and key formulas — rather than just describing the output as '4-sheet model with 5-year projections'.

Create the referenced `dcf-formulas.md` bundle file with complete formula templates, or inline the essential formulas directly in the skill.

Add validation checkpoints between steps, such as 'Verify FCF projections are reasonable (compare FCF margin to industry benchmarks) before proceeding to terminal value calculation'.

Dimension	Reasoning	Score
Conciseness	The skill is reasonably concise but includes some unnecessary sections like Prerequisites (Claude knows what's needed for a DCF) and the Resources section with external URLs that may be stale. The examples are vague summaries rather than actionable content.	2 / 3
Actionability	The instructions are entirely abstract — 'Build free cash flow projections' and 'Calculate terminal value using Gordon Growth Model' provide no concrete formulas, Excel cell references, or executable code. There are no actual Excel formulas, VBA snippets, or specific cell layout instructions that Claude could use to build the model.	1 / 3
Workflow Clarity	Steps are listed in a logical sequence and the error handling table provides some validation guidance, but there are no explicit validation checkpoints between steps (e.g., verify projections balance before calculating terminal value) and no feedback loops for catching errors during the multi-step model build process.	2 / 3
Progressive Disclosure	The skill references `${CLAUDE_SKILL_DIR}/references/dcf-formulas.md` for formula templates, which is good progressive disclosure, but no bundle files exist to support this reference. The content that is inline is appropriately sized but the actual formulas and detailed instructions that should be in referenced files are simply missing.	2 / 3
	Total	7 / 12 Passed

Validation

81%

Warnings & errors only

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

Repository: jeremylongshore/claude-code-plugins-plus-skills
Commit: 3a2d27d

Reviewed: 2 days ago

Table of Contents

Discovery Implementation Validation

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.