AGENT SKILL

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

使用场景电子表格
License 许可
MIT
最近更新
2026-11-15
Stars
★ 2.0k
Forks
233

01 前言 Front Matter

name
excel-dcf-modeler
author
Jeremy Longshore <jeremy@intentsolutions.io>
license
MIT
version
1.0.0
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:*)

02 资源文件 5

03 SKILL.md 正文

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

  1. Create assumptions sheet with revenue growth, margins, WACC, and terminal growth rate
  2. Build free cash flow projections (5-year forecast)
  3. Calculate terminal value using Gordon Growth Model
  4. Discount cash flows and terminal value to present value
  5. Sum to get enterprise value, subtract net debt for equity value
  6. 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

04 同仓库更多 Skills

Dicklesworthstone
Dicklesworthstone/pi_agent_rust

theme-factory

Toolkit for styling artifacts with a theme. These artifacts can be slides, docs, reportings, HTML landing pages, etc. There are 10 pre-set themes with colors/fonts that you can apply to any artifact that has been creating, or can generate a new theme on-the-fly.

视觉设计
★ 2.0k
Dicklesworthstone
Dicklesworthstone/pi_agent_rust

web-artifacts-builder

Suite of tools for creating elaborate, multi-component claude.ai HTML artifacts using modern frontend web technologies (React, Tailwind CSS, shadcn/ui). Use for complex artifacts requiring state management, routing, or shadcn/ui components - not for simple single-file HTML/JSX artifacts.

前端开发
★ 2.0k
Dicklesworthstone
Dicklesworthstone/pi_agent_rust

webapp-testing

Toolkit for interacting with and testing local web applications using Playwright. Supports verifying frontend functionality, debugging UI behavior, capturing browser screenshots, and viewing browser logs.

测试与质量前端开发
★ 2.0k
Dicklesworthstone
Dicklesworthstone/pi_agent_rust

neuropixels-analysis

Neuropixels neural recording analysis. Load SpikeGLX/OpenEphys data, preprocess, motion correction, Kilosort4 spike sorting, quality metrics, Allen/IBL curation, AI-assisted visual analysis, for Neuropixels 1.0/2.0 extracellular electrophysiology. Use when working with neural recordings, spike sorting, extracellular electrophysiology, or when the user mentions Neuropixels, SpikeGLX, Open Ephys, Kilosort, quality metrics, or unit curation.

★ 2.0k
Dicklesworthstone
Dicklesworthstone/pi_agent_rust

skill-creator

Guide for creating effective skills. This skill should be used when users want to create a new skill (or update an existing skill) that extends Claude's capabilities with specialized knowledge, workflows, or tool integrations.

Skill与智能体开发
★ 2.0k
Dicklesworthstone
Dicklesworthstone/pi_agent_rust

notebooklm

Use this skill to query your Google NotebookLM notebooks directly from Claude Code for source-grounded, citation-backed answers from Gemini. Browser automation, library management, persistent auth. Drastically reduced hallucinations through document-only responses.

Skill与智能体开发
★ 2.0k