excel-dcf-modeler

Name: excel-dcf-modeler
Author: jst-well-dan

github.com/jst-well-danData & databases1064 installsUpdated 31w ago

About excel-dcf-modeler

An investment-modeling skill for building four-sheet DCF valuations in Excel or compatible spreadsheet software. It covers five-year cash flow projections, WACC-based discounting, and sensitivity analysis for company valuation.

Key features

01Four-sheet DCF model
02Five-year free cash flow projections
03WACC and terminal value calculations
04Enterprise and per-share equity value
05WACC and growth sensitivity tables

Use cases

01Valuing a SaaS company
02Assessing an acquisition target

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/jst-well-dan/skill-box --skill excel-dcf-modeler

After installing, type/excel-dcf-modelerin Claude Code to confirm it loaded.

Bundled files

References and scripts installed along with SKILL.md.

assets/

README.md

references/

dcf-formulas.md

README.md

resources/

REFERENCE.md

scripts/

README.md

Details

From the project README

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

Comments

Markdown supported

Details

Author: jst-well-dan
Repository: jst-well-dan/skill-box
Category: Data & databases
Installs: 64
GitHub stars: 10

Report

More skills

All skills

hyperframes-core

github.com/heygen-com

930.6k

The HyperFrames composition contract — build one renderable project. Use for composition structure, the `data-*` timing attributes, `class="clip"`, tracks, sub-compositions, variables, framework-owned media playback, deterministic-render rules, and validation. Also covers Tailwind projects and the STORYBOARD.md / SCRIPT.md plan formats. Read before writing composition HTML.

lark-base

open.feishu.cn

823.2k

Operate on Feishu Base: create tables, fields, records, and views; handle statistics, formulas/lookups, forms, dashboards, app mode (BaseApp/AppMode pages and components), Workspace directories, workflows, role permissions, and the template center (Base template categories, lists, and search). Use when encountering Base/multidimensional tables/bitable, BaseApp/AppMode, or /base/ or /app/ links. Do not use lark-apps for BaseApp; route file import/export to lark-drive and authentication/authorization to lark-shared.

lark-sheets

open.feishu.cn

821.8k

Feishu Spreadsheets: create and operate spreadsheets. Supports worksheets and row/column structures (add/delete/merge/size/hide/freeze/group), cell read/write (values/formulas/styles/comments/cell images), range copy/move/sort/fill, find and replace, bulk updates, and creating and maintaining objects such as charts, pivot tables, conditional formatting, filters and filter views, dropdown lists, sparklines, and floating images. Also supports formula validation, restoring historical versions, and importing/exporting local Excel/CSV files and Feishu spreadsheets. Use when users need to create or edit spreadsheets, summarize and visualize data, format spreadsheets, calculate formulas (including migrating Excel formulas), or build financial models (DCF, three statements, budgets, Sensitivity, etc.). For multidimensional tables (Base/bitable), use lark-base. If users want to search for spreadsheet files in cloud storage (Drive/cloud storage) by name or keyword, use lark-drive's drive +search to locate resources first. When users provide a doubao.com /sheets/ URL/token, use this skill directly; do not fall back to WebFetch because the domain is not Feishu. Routing is based on the URL path pattern and token, not the domain.

remotion-best-practices

github.com/remotion-dev

701.4k

Best practices and domain knowledge for building videos programmatically with Remotion (videos in React/TypeScript, rendered to MP4). Use whenever writing or editing Remotion code — scaffolding a video project, animating with interpolate/spring over useCurrentFrame(), sequencing scenes and transitions, captions/subtitles, audio, GIFs/Lottie/3D, charts, visual effects, dynamic duration via calculateMetadata, or rendering. Consult before reaching for a Remotion API, since its components and props evolve (e.g. @remotion/media).