skills.rest
ZardLi1115
ZardLi1115COMMUNITY
Explore all skills by this author →
GitHub

dcf-model

Generate Excel DCF valuation models with Bear/Base/Case and sensitivity tables.

4|Updated May 18, 2026
Search Tags:#openpyxl#excel#valuation#sensitivity analysis#dcf#equity modeling#wacc
One-click install
npx skills add https://github.com/ZardLi1115/zedclaw --skill dcf-model-zardli1115
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dcf-model
Source: https://github.com/ZardLi1115/zedclaw/tree/main/optional-skills/finance/dcf-model
Command: npx skills add https://github.com/ZardLi1115/zedclaw --skill dcf-model-zardli1115

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, requests, and includes scripts (resource) components.

What problem does it solve?

This Skill helps you produce institutional-quality Discounted Cash Flow (DCF) valuation spreadsheets quickly while keeping the model fully formula-driven, auditable, and client-ready.

Core Features & Use Cases

  • Institutional DCF Excel build: Creates a full unlevered DCF model with projection schedule, FCF build, WACC inputs, terminal value, and equity bridge.
  • Three-scenario underwriting: Builds Bear/Base/Bull blocks with a case selector so outputs update consistently.
  • Recalculation-first sensitivity analysis: Generates complete WACC/terminal growth, growth/margin, and beta/risk-free sensitivity grids where every cell recalculates the full DCF logic.
  • Guardrails and validation workflow: Enforces non-negotiable constraints like “formulas over hardcodes,” step-by-step user confirmation checkpoints, and error-free recalculation.

Quick Start

Tell the agent to generate an Excel DCF model using your company’s historical inputs and your desired assumptions, and then recalculate the output spreadsheet before review.

Frequently Asked Questions about dcf-model

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I build a fully formula-driven DCF model in Excel?▼

You can build a formula-driven DCF model in Excel by generating projection schedules, FCF builds, and WACC inputs with openpyxl. This approach ensures the spreadsheet remains auditable without hardcoded values.

How do I add Bear, Base, and Bull scenarios to an Excel valuation?▼

To add Bear, Base, and Bull scenarios to an Excel valuation, build distinct underwriting blocks with a case selector. This mechanism ensures outputs update consistently across the entire financial model.

Can I create WACC and terminal growth sensitivity tables that recalculate the full DCF?▼

Yes, you can create sensitivity tables for WACC and terminal growth that recalculate the full DCF. The grids are fully populated so every cell recalculates the logic, with the center cell matching the base-case implied value.

Does openpyxl support institutional-grade Excel DCF models with mid-year discounting?▼

openpyxl supports institutional-grade Excel DCF models with mid-year discounting by constructing formula-driven spreadsheets programmatically. It enforces constraints like terminal growth being less than WACC.

What is the best way to generate audit-ready equity intrinsic value spreadsheets?▼

The best way to generate audit-ready equity intrinsic value spreadsheets is to use formula-driven construction with step-by-step confirmation checkpoints. This workflow enforces non-negotiable constraints and error-free recalculation.

Related Skills

Explore More Finance & Accounting Skills→
claude-office-skillsclaude-office-skills
368

financial-modeling

Build integrated 3-statement financial models with projections for income statement, balance sheet, and cash flow.

Official
Advanced
ruiyangruiyiruiyangruiyi

dcf-model

Generate Excel DCF valuation models with live formulas and sensitivity grids.

Community
Advanced
519lab519lab
2

dcf-model

Automate DCF valuation model construction and analysis with financial calculations.

Official
Advanced
projectedanxprojectedanx
1

dcf-model

Generate institutional-quality DCF valuation models in Excel with openpyxl.

Community
Advanced