Skip to content
OpenSmartRoute
Skillv1.0.0

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

by jeremylongshore(0) 0 installs
Free
Sign in to install

Free account. Installing gives you the manifest plus copy-paste snippets.

See reviews

About

Imported from jeremylongshore/tons-of-skills-marketplace (skills/.curated/excel-dcf-modeler/SKILL.md). Install upstream with npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-dcf-modeler. Copyright stays with the author (MIT).

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

Use it

Copy one of these into your project. Installing also returns the manifest and these snippets.

yaml
targets:
  - https://api.opensmartroute.ai/api/v1/registry/jeremylongshore-tons-of-skills-marketplace-excel-dcf-modeler/manifest   # or paste the manifest below

Manifest

An Open Capability Manifest: the router reads it to know what this does, what it costs and when to pick it.

jeremylongshore-tons-of-skills-marketplace-excel-dcf-modeler.ocm.jsonjson
{
  "ocm": "1",
  "id": "jeremylongshore-tons-of-skills-marketplace-excel-dcf-modeler",
  "kind": "skill",
  "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'.",
  "publisher": "jeremylongshore",
  "version": "1.0.0",
  "capabilities": {
    "domains": [
      "finance",
      "math"
    ],
    "tags": [
      "skill-md",
      "business",
      "excel-dcf",
      "skills-sh"
    ],
    "languages": [
      "en"
    ]
  },
  "quality_prior": 0.6,
  "examples": [
    "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'."
  ],
  "primary": false,
  "metadata": {
    "source": {
      "provider": "skills.sh",
      "repository": "https://github.com/jeremylongshore/tons-of-skills-marketplace",
      "path": "skills/.curated/excel-dcf-modeler/SKILL.md",
      "ref": "HEAD",
      "url": "https://github.com/jeremylongshore/tons-of-skills-marketplace/blob/HEAD/skills/.curated/excel-dcf-modeler/SKILL.md",
      "key": "jeremylongshore/tons-of-skills-marketplace/skills/.curated/excel-dcf-modeler/SKILL.md"
    },
    "compatibility": "Designed for Claude Code",
    "allowed_tools": [
      "Read,",
      "Write,",
      "Edit,",
      "Grep,",
      "Glob,",
      "Bash(cmd:*)"
    ],
    "license": "MIT"
  },
  "instructions": "# Excel DCF Modeler\n\n## Overview\n\nCreates professional DCF valuation models following investment banking standards with WACC calculations and sensitivity analysis.\n\n## Prerequisites\n\n- Excel or compatible spreadsheet software\n- Historical financial data for target company\n- Industry comparables for WACC estimation\n\n## Instructions\n\n1. Create assumptions sheet with revenue growth, margins, WACC, and terminal growth rate\n2. Build free cash flow projections (5-year forecast)\n3. Calculate terminal value using Gordon Growth Model\n4. Discount cash flows and terminal value to present value\n5. Sum to ",
  "cost": {
    "context_tokens": 465
  }
}

Fetch it by URL: GET /api/v1/registry/jeremylongshore-tons-of-skills-marketplace-excel-dcf-modeler/manifest?version=1.0.0

Reviews

Star ratings from people who tried it. One review per account; edit yours any time.

No reviews yet. Install it, try it, and be the first to rate it.