CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

dcf-model

Real DCF (Discounted Cash Flow) model creation for equity valuation. Retrieves financial data from SEC filings and analyst reports, builds comprehensive cash flow projections with proper WACC calculations, performs sensitivity analysis, and outputs professional Excel models with executive summaries. Use when users need to value a company using DCF methodology, request intrinsic value analysis, or ask for detailed financial modeling with growth projections and terminal value calculations.

Quality

72%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide
SecuritybySnyk

Low

Low-risk findings worth noting

Fix and improve this skill with Tessl

tessl review fix ./plugins/vertical-plugins/financial-analysis/skills/dcf-model/SKILL.md

The canonical home for this skill is dcf-model in anthropics/financial-services

SKILL.md
Quality
Evals
Security

Quality

Content

45%Weight 40%Scale 1-5

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

The body delivers genuinely skill-specific, high-value constraints (formulas-over-hardcodes, Office JS pitfalls, recalc gating, sensitivity-table construction) with strong sequencing and validation, but buries them in a 1,263-line monolith that re-explains standard DCF finance, repeats its own rules 3–5 times, and mismanages the bundle — a validation script never linked from the doc and a troubleshooting reference that is dead. Content quality is high; structure and token efficiency are poor.

Suggestions

Cut Steps 2–9's textbook finance explanations (CAPM, WACC, terminal value formulas Claude already knows) down to the skill-specific calibration ranges (e.g., 'Tax rate 21-28%', 'ERP 5.0-6.0%', 'Terminal value 50-70% of EV'), and de-duplicate the sensitivity-table, cell-comment, consolidation-column, and recalc.py rules that each appear 3-5 times across Critical Constraints, correct_patterns, common_mistakes, Workflow Integration, and the Final Output Checklist — this alone should cut the body by well over half.

Move the <correct_patterns> and <common_mistakes> sections and the detailed DCF/WACC sheet layout CSVs into separate reference files (e.g., references/patterns.md, references/layout.md) linked one level deep from SKILL.md, keeping the main body as an overview plus workflow.

Fix the bundle wiring: either add the referenced TROUBLESHOOTING.md or remove its two dead links, and reference the existing scripts/validate_dcf.py from the body (e.g., in the pre-delivery validation step) so the bundle file is discoverable.

DimensionReasoningScore

Conciseness

The 1,263-line body extensively explains textbook finance Claude already knows (CAPM: 'Cost of Equity = Risk-Free Rate + Beta × Equity Risk Premium', 'Net Debt = Total Debt - Cash', 'Market Cap = Price × Shares', Gordon-growth terminal value) across Steps 2–9, and is heavily padded by repetition — the sensitivity-table rules, cell-comment requirements, consolidation-column pattern, and recalc.py invocation each appear 3–5 times across Critical Constraints, correct_patterns, common_mistakes, Workflow Integration, and the Final Output Checklist. Both conditions of the anchor-1 example (known-concept explanation plus padding) hold; generic filler sections like 'Best Practices' ('Build incrementally', 'Version control') add more.

1 / 5

Actionability

Mostly executable: exact openpyxl assignments ('ws["D20"] = "=D19*(1+$B$8)"'), a complete Office JS merged-cell snippet with WRONG/CORRECT variants, the full 'python recalc.py model.xlsx 30' command with expected JSON output, exact RGB values, border weights, and cell-by-cell layout CSVs. Not score 5 because the single hardest piece — the sensitivity-cell formula — is left as pseudocode ('formula = f"=<DCF recalc using {wacc_value} and {term_growth_value}>"' and '=([SUM of PV FCFs using $A88...] - [Net Debt]) / [Shares]') with no executable example; not score 3 because everything else is concrete and copy-paste ready.

4 / 5

Workflow Clarity

Steps 1–10 are clearly sequenced with a stage-gate protocol ('After data retrieval → show the user the raw inputs block... confirm before projecting'), an explicit recalc.py feedback loop ('Fix errors and re-run recalc.py until status is success'), and a Final Output Checklist — matching most of anchor 5. Held at 4 because the error-recovery path links to a TROUBLESHOOTING.md that does not exist in the bundle, and Workflow Integration's 'Apply fill colors only if requested' directly contradicts Formatting Standards' mandatory default fill palette, muddying two checkpoints.

4 / 5

Progressive Disclosure

Scored against the actual bundle: the body references './TROUBLESHOOTING.md' twice but that file does not exist, 'recalc.py' is invoked repeatedly but belongs to the external xlsx skill rather than this bundle, and the one real bundle file (scripts/validate_dcf.py) is never referenced from SKILL.md at all. Meanwhile ~350 lines of <correct_patterns>/<common_mistakes> and detailed sheet-layout CSVs that clearly belong in separate reference files are inlined in the monolithic body — matching anchor 2 ('content that clearly belongs in separate files is inlined; or references are buried').

2 / 5

Total

11

/

20

Passed

Description

88%Weight 40%Scale 1-5

Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.

A strong description: third-person voice, concrete action list spanning the whole DCF workflow, and an explicit, multi-phrase 'Use when' trigger clause. The only weaknesses are a few missing natural trigger synonyms (fair value, target price) and slight overlap risk from the broad 'financial modeling' phrasing.

DimensionReasoningScore

Specificity

The description lists multiple concrete actions covering the full workflow — 'Retrieves financial data from SEC filings and analyst reports', 'builds comprehensive cash flow projections with proper WACC calculations', 'performs sensitivity analysis', 'outputs professional Excel models with executive summaries' — with named sources and outputs. Not score 4 because coverage spans the entire DCF pipeline rather than leaving gaps; the mild buzz in 'Real' and 'professional' does not undermine the concrete action list.

5 / 5

Completeness

Both questions are explicitly answered: the 'what' via five concrete capability statements, and the 'when' via the explicit trigger clause 'Use when users need to value a company using DCF methodology, request intrinsic value analysis, or ask for detailed financial modeling with growth projections and terminal value calculations'. Clearly matches the anchor-5 example pattern.

5 / 5

Trigger Term Quality

Strong keyword coverage including the abbreviation/expansion pair 'DCF (Discounted Cash Flow)' plus natural phrases like 'value a company', 'intrinsic value analysis', 'financial modeling', 'growth projections', and 'terminal value calculations'. Not score 5 because a few natural user phrasings are missing — e.g., 'fair value', 'target price', or 'how much is company X worth'.

4 / 5

Distinctiveness Conflict Risk

DCF equity valuation is a clear niche with distinct triggers ('DCF methodology', 'intrinsic value analysis'), so it is well above anchor 3. Not score 5 because the trigger phrase 'ask for detailed financial modeling' and 'outputs professional Excel models' create minor overlap risk with generic financial-modeling or spreadsheet skills.

4 / 5

Total

18

/

20

Passed

Validation

87%

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation — 14 / 16 Passed

Validation for skill structure

CriteriaDescriptionResult

skill_md_line_count

SKILL.md is long (1264 lines); consider splitting into references/ and linking

Warning

relative_links

Relative link issues: 2 missing

Warning

Total

14

/

16

Passed

Repository

anthropics/financial-services

Path

plugins/vertical-plugins/financial-analysis/skills/dcf-model/SKILL.md

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.