agentsclimarketplace

Excel dcf modeler

Skill jeremylongshore/claude-code-plugins-plus-skills/plugins/business-tools/excel-analyst-pro/skills/excel-dcf-modeler

425 plugins, 2,810 skills, 200 agents for Claude Code. Open-source marketplace at tonsofskills.com with the ccpi CLI package manager.

Install
npx -y skills add jeremylongshore/claude-code-plugins-plus-skills --skill excel-dcf-modeler

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

What its author says it does

Copied from the file, not written here

'Build discounted cash flow (DCF) valuation models in Excel. Use when creating

The file declares its own license as MIT. That is the author’s claim about this one file, and it is not the same thing as the license GitHub reports for the repository, which is listed with the other numbers below.

SKILL.md

2.4 KB, as published. Nobody here has run it

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

ErrorCauseSolution
#DIV/0! in terminal valueWACC equals terminal growthTerminal growth must be less than WACC
Negative FCFHigh CapEx or WC needsReview assumptions, may need different model
Unrealistic EVExtreme growth assumptionsBenchmark 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

Keep looking

Skills are one crate of 328,083. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.