Excel DCF Modeler

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

majiayu000/claude-skill-registry·0installs663starsFinance & Trading

SKILL.md

Full skill instructions

Excel DCF Modeler

Overview

Creates professional DCF valuation models following investment banking standards with WACC calculations and sensitivity analysis.

Prerequisites

Excel or compatible spreadsheet software
Historical financial data for target company
Industry comparables for WACC estimation

Instructions

Create assumptions sheet with revenue growth, margins, WACC, and terminal growth rate
Build free cash flow projections (5-year forecast)
Calculate terminal value using Gordon Growth Model
Discount cash flows and terminal value to present value
Sum to get enterprise value, subtract net debt for equity value
Add sensitivity tables for key assumptions

Output

Complete 4-sheet DCF model with assumptions, projections, valuation, and sensitivity
Enterprise value and equity value per share
Sensitivity analysis on WACC and terminal growth rate

Error Handling

Error	Cause	Solution
#DIV/0! in terminal value	WACC equals terminal growth	Terminal growth must be less than WACC
Negative FCF	High CapEx or WC needs	Review assumptions, may need different model
Unrealistic EV	Extreme growth assumptions	Benchmark against industry comparables

Examples

Example: Value a SaaS Company Request: "Create a DCF model for a $50M ARR SaaS company growing 30%" Result: 4-sheet model with 5-year projections, 12% WACC, 3% terminal growth, sensitivity tables

Example: M&A Valuation Request: "DCF analysis for acquisition target" Result: Model with synergy adjustments, scenario analysis, and per-share valuation

Resources

Damodaran Online DCF Resources
WSO DCF Modeling Guide
{baseDir}/references/dcf-formulas.md for Excel formula templates

Install skill

Copy and run in your terminal

npx -y skills add https://github.com/majiayu000/claude-skill-registry --skill excel-dcf-modeler

View on GitHub

skills/data/excel-dcf-modeler/SKILL.md

More Finance & Trading skills

View all

Finance & Trading

stripe-projects

stripe projects

1.9K 66.8K

View

Finance & Trading

ponytail-debt

Harvest every `ponytail:` comment in the codebase into a debt ledger, so the deliberate shortcuts and deferrals ponytail leaves behind get tracked instead of rotting into "later means never". One-shot report, changes nothing.

155.5K 27.9K

View

Finance & Trading

okx-dex-market

okx dex market

341 18.5K

View

Finance & Trading

okx-agentic-wallet

okx agentic wallet

341 16.7K

View

Finance & Trading

gmgn-portfolio

gmgn portfolio

596 15.7K

View

Finance & Trading

okx-dapp-discovery

okx dapp discovery

341 13.8K

View

Finance & Trading

okx-agent-payments-protocol

okx agent payments protocol

341 13K

View

Finance & Trading

stripe-integration

Stripe payment processing with checkout sessions, subscriptions, webhooks, and customer management.

40.2K 12.9K

View

Finance & Trading

startup-financial-modeling

Build comprehensive 3-5 year financial models with revenue projections, cost structures, cash flow analysis, and scenario planning for early-stage startups. Use this skill when creating financial projections, calculating burn rate or runway, modeling fundraising scenarios, or preparing investor-r...

40.2K 12K

View

Finance & Trading

stock-analysis

Stock and cryptocurrency analysis with portfolio management and multi-dimensional scoring.

46 11.9K

View

Finance & Trading

coinglass

Real-time crypto derivatives positioning, whale tracking, liquidations, and institutional ETF flows across 37 specialized tools.

27 11.5K

View

Finance & Trading

dbt-transformation-patterns

Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building data transformations, creating data models, or implementing analytics engineering best practices.

40.2K 10.5K

View