Agent skill

Excel Dcf Modeler

by jeremylongshore in jeremylongshore/tons-of-skills-marketplace

Build discounted cash flow (DCF) valuation models in Excel. An agent skill from jeremylongshore/tons-of-skills-marketplace.

MITAuto-check passedBusiness, Finance & HR

Install Excel Dcf Modeler

skills CLI

$ npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-dcf-modeler -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI

$ gh skill install jeremylongshore/tons-of-skills-marketplace excel-dcf-modeler --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy

$ git clone --depth 1 https://github.com/jeremylongshore/tons-of-skills-marketplace.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/.curated/excel-dcf-modeler .claude/skills/excel-dcf-modeler && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Paste into Claude Code

Install the "excel-dcf-modeler" agent skill from https://github.com/jeremylongshore/tons-of-skills-marketplace/tree/main/skills/.curated/excel-dcf-modeler into .claude/skills/excel-dcf-modeler/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "excel-dcf-modeler", then confirm the skill loads.

Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

$skill-installer

$skill-installer install https://github.com/jeremylongshore/tons-of-skills-marketplace/tree/main/skills/.curated/excel-dcf-modeler

Type this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.

skills CLI

$ npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-dcf-modeler -a codex

Project install goes to .agents/skills/; add -g for ~/.codex/skills/.

GitHub CLI

$ gh skill install jeremylongshore/tons-of-skills-marketplace excel-dcf-modeler --agent codex

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/jeremylongshore/tons-of-skills-marketplace.git skills-src && mkdir -p .agents/skills && cp -r skills-src/skills/.curated/excel-dcf-modeler .agents/skills/excel-dcf-modeler && rm -rf skills-src

Use ~/.agents/skills/ instead of .agents/skills for a personal install.

Codex skills documentation · loads skills from .agents/skills/

Paste into Codex

Install the "excel-dcf-modeler" agent skill from https://github.com/jeremylongshore/tons-of-skills-marketplace/tree/main/skills/.curated/excel-dcf-modeler into .agents/skills/excel-dcf-modeler/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "excel-dcf-modeler", then confirm the skill loads.

Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

skills CLI

$ npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-dcf-modeler -a cursor

Project install goes to .agents/skills/; add -g for ~/.cursor/skills/.

GitHub CLI

$ gh skill install jeremylongshore/tons-of-skills-marketplace excel-dcf-modeler --agent cursor

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/jeremylongshore/tons-of-skills-marketplace.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/skills/.curated/excel-dcf-modeler .cursor/skills/excel-dcf-modeler && rm -rf skills-src

Use ~/.cursor/skills/ instead of .cursor/skills for a personal install.

Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/

Paste into Cursor

Install the "excel-dcf-modeler" agent skill from https://github.com/jeremylongshore/tons-of-skills-marketplace/tree/main/skills/.curated/excel-dcf-modeler into .cursor/skills/excel-dcf-modeler/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "excel-dcf-modeler", then confirm the skill loads.

Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

gemini skills install

$ gemini skills install https://github.com/jeremylongshore/tons-of-skills-marketplace.git --path skills/.curated/excel-dcf-modeler

--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.

skills CLI

$ npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-dcf-modeler -a gemini-cli

Project install goes to .agents/skills/; add -g for ~/.gemini/skills/.

GitHub CLI

$ gh skill install jeremylongshore/tons-of-skills-marketplace excel-dcf-modeler --agent gemini-cli

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/jeremylongshore/tons-of-skills-marketplace.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/skills/.curated/excel-dcf-modeler .gemini/skills/excel-dcf-modeler && rm -rf skills-src

Use ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.

Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/

Paste into Gemini CLI

Install the "excel-dcf-modeler" agent skill from https://github.com/jeremylongshore/tons-of-skills-marketplace/tree/main/skills/.curated/excel-dcf-modeler into .gemini/skills/excel-dcf-modeler/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "excel-dcf-modeler", then confirm the skill loads.

Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

GitHub CLI

$ gh skill install jeremylongshore/tons-of-skills-marketplace excel-dcf-modeler

Installs for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).

skills CLI

$ npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-dcf-modeler -a github-copilot

Project install goes to .agents/skills/; add -g for ~/.copilot/skills/.

Manual copy

$ git clone --depth 1 https://github.com/jeremylongshore/tons-of-skills-marketplace.git skills-src && mkdir -p .github/skills && cp -r skills-src/skills/.curated/excel-dcf-modeler .github/skills/excel-dcf-modeler && rm -rf skills-src

Use ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.

GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/

Paste into GitHub Copilot

Install the "excel-dcf-modeler" agent skill from https://github.com/jeremylongshore/tons-of-skills-marketplace/tree/main/skills/.curated/excel-dcf-modeler into .github/skills/excel-dcf-modeler/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "excel-dcf-modeler", then confirm the skill loads.

GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

skills CLI

$ npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-dcf-modeler -a opencode

OpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.

GitHub CLI

$ gh skill install jeremylongshore/tons-of-skills-marketplace excel-dcf-modeler --agent opencode

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/jeremylongshore/tons-of-skills-marketplace.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/skills/.curated/excel-dcf-modeler .opencode/skills/excel-dcf-modeler && rm -rf skills-src

Use ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.

OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/

Paste into OpenCode

Install the "excel-dcf-modeler" agent skill from https://github.com/jeremylongshore/tons-of-skills-marketplace/tree/main/skills/.curated/excel-dcf-modeler into .opencode/skills/excel-dcf-modeler/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "excel-dcf-modeler", then confirm the skill loads.

OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

Facts

Skill name: excel-dcf-modeler
GitHub stars: 2.8k
Token cost: ~593 tokens
SKILL.md length: 228 words
Files: 6 (incl. scripts, references, assets)
Skills in repo: 3,342
Repo updated: Oct 10, 2026
First seen: Oct 8, 2026
Licence: MIT

At a glance

Build discounted cash flow (DCF) valuation models in Excel. An agent skill from jeremylongshore/tons-of-skills-marketplace.

Works in 6 steps: Create assumptions sheet with revenue… → Build free cash flow projections (5-year… → Calculate terminal value using Gordon… → …
Creating DCF models
SKILL.md covers Overview, Prerequisites, Instructions and Output, plus 3 more sections
Calculating enterprise value

What it does

Excel Dcf Modeler is an agent skill from jeremylongshore/tons-of-skills-marketplace. 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'.

Its SKILL.md is about 590 tokens, which your agent loads only when the skill is triggered. The skill folder holds 9 other files, including scripts, reference files and assets (for example `assets/README.md`, `references/README.md` and `references/dcf-formulas.md`). Compatibility notes: Designed for Claude Code

It sits in Business, Finance & HR, covering Financial modeling and Excel spreadsheets. It works with Microsoft Excel. The repository describes itself as: Model-agnostic agent-skills platform with a harness-free canonical layer, verified adapters, and the ccpi package manager. Explore at tonsofskills.com. The licence is MIT.

When your agent uses it

Creating DCF models
Calculating enterprise value
Valuing companies
With phrases like excel dcf

Example prompts

“excel dcf”
“build dcf model”
“calculate enterprise value”
“/excel-dcf-modeler”

Requirements

Compatibility (from SKILL.md): Designed for Claude Code
Pre-approved tools (allowed-tools): Read, Write, Edit, Grep, Glob, Bash(cmd:*)

Workflow steps

6 steps, taken from the first numbered list in SKILL.md.

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

What it can do on your machine

Read from SKILL.md and the folder at commit cfae287. It shows what the files ask for, not the result of running them.

Tool permissions
Pre-approves these tools, so the agent can use them without asking each time:
- Read
- Write
- Edit
- Grep
- Glob
- Bash(cmd:*)
From allowed-tools in the SKILL.md frontmatter.
Runs code
Ships 1 file in scripts/, which the agent can run.
From the folder's file list and the shell code blocks in SKILL.md.
Network
Links to these hosts (documentation or services it may open):
- pages.stern.nyu.edu
- wallstreetoasis.com
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Compatibility
Designed for Claude Code
From compatibility in the SKILL.md frontmatter.

Context cost

Excel Dcf Modeler loads about 593 tokens when it runs, and up to ~1.2k if it reads all its reference files. Until then it costs about 62 tokens; SKILL.md has 228 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it: ~62
When it runs · the whole SKILL.md, loaded when a task matches: ~593
With references · SKILL.md plus every file in references/, read only if the agent opens them: ~1.2k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); the scripts in this folder are not scanned.

SKILL.md

The full file from jeremylongshore/tons-of-skills-marketplace at commit cfae287, republished under its MIT licence (© jeremylongshore). 228 words, ~593 tokens.

Download SKILL.mdSave it as .claude/skills/excel-dcf-modeler/SKILL.md (or your agent's skills folder). This skill also uses 5 other files; get the full folder from GitHub.

name: excel-dcf-modeler
description: 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'.
allowed-tools: Read, Write, Edit, Grep, Glob, Bash(cmd:*)
compatibility: Designed for Claude Code
version: 1.21.0
author: Jeremy Longshore <jeremy@intentsolutions.io>
license: MIT
tags: business, excel-dcf

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
${CLAUDE_SKILL_DIR}/references/dcf-formulas.md for Excel formula templates

Files

SKILL.md and 5 other files (scripts, references, assets) in skills/.curated/excel-dcf-modeler of jeremylongshore/tons-of-skills-marketplace.

SKILL.md
assets/README.md
references/README.md
references/dcf-formulas.md
resources/REFERENCE.md
scripts/README.md

Open the folder on GitHubat commit cfae287

Compare with similar skills

Excel Dcf Modeler next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Excel Dcf Modeler compared with similar skills
Skill	Stars	Used in	Tokens	Auto-check	Licence	Repo updated
Excel Dcf Modeler this skilljeremylongshore/tons-of-skills-marketplace	2.8k	—	~593	Automated safety check: Pass	MIT	yesterday
Build Modeldaloopa/investing	489	—	~1.3k	Automated safety check: Pass	Apache-2.0	3 days ago
Three-Statement Model Builderginlix-ai/LangAlpha	1.8k	—	~5.4k	Automated safety check: Pass	Apache-2.0	yesterday
Dcf ModelWind-Alice/AliceMarket	134	2 repos	~12k	Automated safety check: Pass	None	1 mo ago
Startupblueprintbuildfastwithai/gen-ai-experiments	785	—	~2.2k	Automated safety check: Pass	MIT	18 days ago
Dcf ModelLuciole-Studio/Misaka-Agent	171	2 repos	~12k	Automated safety check: Pass	Apache-2.0	2 days ago

Similar skills

Build Model
daloopa/investing
Build a multi-tab Excel financial model
489 GitHub stars~1.3k tokensUpdated 3 days ago
Business, Finance & HRAuto-check passed
Three-Statement Model Builder
ginlix-ai/LangAlpha
Builds or repairs an integrated income statement, balance sheet and cash flow model in Excel with live formulas, supporting schedules, scenarios and a Checks sheet.
1.8k GitHub stars~5.4k tokensUpdated yesterday
Business, Finance & HRAuto-check passed
Dcf Model
Wind-Alice/AliceMarket
Real DCF (Discounted Cash Flow) model creation for equity valuation.
134 GitHub starsUsed in 2 repos~12k tokens
Business, Finance & HRAuto-check passed
Startupblueprint
buildfastwithai/gen-ai-experiments
Turn a startup, SaaS, app, developer tool, website, repository, or product idea into an evidence-backed business plan, monetization strategy, pricing architecture, editable 12-month financial model…
785 GitHub stars~2.2k tokensUpdated 18 days ago
Business, Finance & HRAuto-check passed
Dcf Model
Luciole-Studio/Misaka-Agent
Build discounted cash flow valuation workbooks in Excel. An agent skill from Luciole-Studio/Misaka-Agent.
171 GitHub starsUsed in 2 repos~12k tokens
Business, Finance & HRAuto-check passed
Officecli Financial Model
FerroxLabs/wayland
A skill your agent uses when the user wants to build a financial model - 3-statement model, DCF valuation, LBO, SaaS unit economics, sensitivity / scenario analysis, debt schedule, or fundraising…
608 GitHub starsUsed in 4 repos~12k tokens
Business, Finance & HRAuto-check passed

Questions about Excel Dcf Modeler

What does Excel Dcf Modeler do?

Build discounted cash flow (DCF) valuation models in Excel. An agent skill from jeremylongshore/tons-of-skills-marketplace. Excel Dcf Modeler is an agent skill from jeremylongshore/tons-of-skills-marketplace. Build discounted cash flow (DCF) valuation models in Excel.

When should I use Excel Dcf Modeler?

Excel Dcf Modeler fits situations like: creating DCF models; calculating enterprise value; valuing companies; with phrases like excel dcf.

How do I install Excel Dcf Modeler in Claude Code?

Run `npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-dcf-modeler -a claude-code`. Or copy the skill folder (skills/.curated/excel-dcf-modeler in jeremylongshore/tons-of-skills-marketplace) into .claude/skills/excel-dcf-modeler in your project. Claude Code loads it when a task matches its description.

How do I install Excel Dcf Modeler in Codex?

Run `npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-dcf-modeler -a codex`. Or copy the skill folder (skills/.curated/excel-dcf-modeler in jeremylongshore/tons-of-skills-marketplace) into .agents/skills/excel-dcf-modeler in your project. Codex loads it when a task matches its description.

Can I use Excel Dcf Modeler in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-dcf-modeler -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/excel-dcf-modeler, .gemini/skills/excel-dcf-modeler, .github/skills/excel-dcf-modeler and .opencode/skills/excel-dcf-modeler in your project.

What does Excel Dcf Modeler need to run?

SKILL.md names no scripts, command-line tools or credentials: Excel Dcf Modeler is instructions for the agent only. Its frontmatter pre-approves these tools: Read, Write, Edit, Grep, Glob, Bash(cmd:*). Compatibility (from SKILL.md): Designed for Claude Code.

Does Excel Dcf Modeler access the network?

SKILL.md names 2 domains. As links in the text: pages.stern.nyu.edu and wallstreetoasis.com. This is read from the text; nothing was executed.

Is Excel Dcf Modeler safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. The check reads SKILL.md only: the scripts in the folder are not scanned, so read them before running anything.

What licence does Excel Dcf Modeler use?

Excel Dcf Modeler is published under the MIT licence (declared in SKILL.md). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Excel Dcf Modeler use?

About 593 tokens (SKILL.md is roughly 2.4k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 558 tokens, read only when the agent opens those files.

What are the alternatives to Excel Dcf Modeler?

Skills that share tags, products or a category with Excel Dcf Modeler: Build Model (daloopa/investing, 489 stars), Three-Statement Model Builder (ginlix-ai/LangAlpha, 1.8k stars), Dcf Model (Wind-Alice/AliceMarket, 134 stars) and Startupblueprint (buildfastwithai/gen-ai-experiments, 785 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Excel Dcf Modeler?

jeremylongshore (a GitHub user) maintains it in jeremylongshore/tons-of-skills-marketplace, which has 2,827 GitHub stars. The repository holds 3,342 skills in this directory. The repository was last updated on October 10, 2026.

Source: jeremylongshore/tons-of-skills-marketplace on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.

Install Excel Dcf Modeler

Facts

At a glance

What it does

When your agent uses it

Example prompts

Requirements

Workflow steps

What it can do on your machine

Tool permissions

Runs code

Network

Credentials

Compatibility

Context cost

Safety

SKILL.md

Excel DCF Modeler

Overview

Prerequisites

Instructions

Output

Error Handling

Examples

Resources

Files

Compare with similar skills

Similar skills

More from jeremylongshore/tons-of-skills-marketplace

Related

Questions about Excel Dcf Modeler