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-modeler

What are skills?

Review — 66%

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/skill

Learn more

Validation — 9 / 11 Passed

Validation for skill structure

SKILL.md

Review

Evals

Evaluation results

85%

DCF Valuation for Brightwell Consumer Brands

4-sheet DCF structure & FCF waterfall

Criteria

Without context

With context

Sheet names

20%

100%

Revenue to EBITDA

100%

EBITDA to EBIT

100%

EBIT to NOPAT

100%

NOPAT to FCF

100%

Terminal Value formula

100%

PV of Terminal Value

100%

Enterprise Value

100%

No hardcoded projections

Without context: $0.3734 · 1m 44s · 14 turns · 14 in / 7,908 out tokens

With context: $0.9068 · 3m 9s · 29 turns · 2,067 in / 14,439 out tokens

55%

Quick Valuation for Nexora Diagnostics

Input validation & default values

Criteria

Without context

With context

Terminal growth vs WACC

100%

Corrected model values

100%

Default D&A

Default CapEx

Default NWC

100%

Default WACC or terminal growth

Tapering growth rates

Validation report

100%

Without context: $0.6391 · 2m 46s · 23 turns · 24 in / 11,919 out tokens

With context: $0.7134 · 3m · 27 turns · 1,078 in / 12,450 out tokens

81%

-3%

Investment Committee Memo: Valuation of Orion Software

Sensitivity analysis & post-build insights

Criteria

Without context

With context

WACC as row variable

100%

Terminal growth as column variable

66%

Enterprise Value as output

100%

Conditional formatting green/red

70%

20%

Currency format

75%

62%

Percentage format

100%

Bold headers & frozen panes

62%

50%

Key value drivers

100%

WACC sensitivity commentary

100%

Terminal value proportion

66%

100%

Without context: $0.7860 · 3m 52s · 24 turns · 24 in / 15,742 out tokens

With context: $0.9117 · 4m 1s · 30 turns · 1,051 in / 17,157 out tokens

100%

Valuing a Healthcare Tech Startup for Series C Investors

WACC derivation & per-share equity value

Criteria

Without context

With context

WACC formula structure

100%

CAPM for cost of equity

100%

10Y Treasury as risk-free rate

100%

Capital structure weights

100%

Equity value formula

100%

Per-share value formula

100%

FCF positive by Year 3-5

100%

Terminal value proportion documented

100%

WACC in valid range

100%

No hard-coded WACC

100%

Without context: $0.6809 · 3m 40s · 17 turns · 18 in / 16,396 out tokens

With context: $1.0346 · 4m 27s · 30 turns · 1,051 in / 19,147 out tokens

73%

Board-Ready DCF Model for an Industrial Equipment Manufacturer

Color-coding, assumption documentation & comps benchmarking

Criteria

Without context

With context

Blue input cells

90%

Black formula cells

100%

50%

Green for positive values

50%

37%

Red for negative values

Assumptions sourced

100%

91%

Industry comps benchmark

100%

Reasonableness narrative

100%

90%

Borders around sections

100%

87%

Frozen panes

100%

Subtotals labeled

100%

FCF sign check

25%

Without context: $0.8945 · 4m 30s · 30 turns · 31 in / 16,910 out tokens

With context: $1.4320 · 6m 23s · 41 turns · 3,527 in / 26,485 out tokens

68%

Investment Committee Memo: Acquisition Target Valuation

Multi-scenario analysis & multiple exit methods

Criteria

Without context

With context

Three scenario columns

100%

Upside growth rate delta

16%

58%

Upside margin delta

30%

Downside growth rate delta

16%

41%

Downside margin delta

30%

Gordon Growth terminal value

100%

Exit multiple terminal value

100%

Exit method comparison

100%

Base case labeled

100%

EV per scenario

100%

Without context: $0.9119 · 3m 44s · 29 turns · 29 in / 16,911 out tokens

With context: $0.9883 · 3m 50s · 32 turns · 2,906 in / 17,159 out tokens

Evaluated: 2 days ago
Agent: Claude Code

Table of Contents

DCF Valuation for Brightwell Consumer Brands Quick Valuation for Nexora Diagnostics Investment Committee Memo: Valuation of Orion Software Valuing a Healthcare Tech Startup for Series C Investors Board-Ready DCF Model for an Industrial Equipment Manufacturer Investment Committee Memo: Acquisition Target Valuation

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.