excel-dcf-modeler

Build discounted cash flow (DCF) valuation models in Excel with free cash flow projections, WACC calculations, and sensitivity analysis for investment banking and corporate finance teams

1.17x

Quality

58%

Does it follow best practices?

Impact

92%

1.17x

Average score across 6 eval scenarios

Securityby

Passed

No known issues

Optimize this skill with Tessl

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

Evaluation results

85%

DCF Valuation for Brightwell Consumer Brands

4-sheet DCF structure & FCF waterfall

Criteria

Without context

With context

Sheet names

50%

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

75%

20%

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

100%

Default CapEx

100%

Default NWC

100%

Default WACC or terminal growth

Tapering growth rates

Validation report

100%

97%

19%

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%

100%

Enterprise Value as output

100%

Conditional formatting green/red

40%

100%

Currency format

100%

62%

Percentage format

100%

Bold headers & frozen panes

50%

100%

Key value drivers

100%

WACC sensitivity commentary

100%

Terminal value proportion

100%

Equity Valuation for NovaMed Diagnostics

Equity value bridge & per-share output

Criteria

Without context

With context

Equity Value formula

100%

Non-operating assets included

100%

Per-share calculation

100%

EV reported

100%

Equity Value reported

100%

Per-share value reported

100%

Key assumptions listed

100%

Sensitivity reference

100%

Net debt used correctly

100%

12%

DCF Model for Meridian Industrial Partners

Color-coding & cell borders for auditability

Criteria

Without context

With context

Blue for input cells

100%

Black for formula cells

100%

Green for positive values

100%

Red for negative values

66%

100%

Cell borders on sections

100%

Formatting guide documents colors

100%

Formatting guide documents borders

100%

Default D&A applied

100%

Default CapEx applied

100%

19%

DCF Analysis for Hyperion Growth Fund

Multi-constraint input validation

Criteria

Without context

With context

Revenue growth violation detected

100%

Tax rate violation detected

100%

WACC violation detected

100%

Corrected values in model

66%

100%

Passing inputs confirmed

100%

Explanation per violation

100%

Corrected values documented

100%

EBITDA margin not flagged

100%

Repository: jeremylongshore/claude-code-plugins-plus-skills
Commit: c8a915c

Evaluated: about 1 month ago
Agent: Claude Code
Model: Claude Sonnet 4.6

Table of Contents

DCF Valuation for Brightwell Consumer Brands Quick Valuation for Nexora Diagnostics Investment Committee Memo: Valuation of Orion Software Equity Valuation for NovaMed Diagnostics DCF Model for Meridian Industrial Partners DCF Analysis for Hyperion Growth Fund

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.