Does it support multi-scenario analysis?

Yes, the model includes Bear, Base, and Bull cases for revenue growth and operating margins, controlled by a central scenario selector cell.

How does the skill source financial data?

It leverages MCP servers (like Daloopa), user-provided documents, and real-time web searches to gather historical financials, stock beta, and treasury yields.

How is the terminal value calculated?

The model defaults to the Perpetuity Growth Method (Gordon Growth) but can be configured for Exit Multiple methods, including sanity checks against enterprise value percentages.

What kind of Excel file does it produce?

It generates a fully functional .xlsx file containing live formulas, dynamic scenario blocks, and comprehensive sensitivity grids rather than static values.

Are the formulas editable after the model is created?

Absolutely. The skill uses programmatic Excel writing to ensure every cell contains the actual underlying math, allowing for manual adjustments in Excel later.

DCF Model Builder

Name: DCF Model Builder
Author: dgkngk

bydgkngk

0•

分析と監視

Builds institutional-quality Discounted Cash Flow models in Excel for comprehensive equity valuation and financial analysis.

The DCF Model Builder skill transforms Claude into a sophisticated financial analyst capable of generating professional-grade equity valuations. It automates the extraction of historical financial data from SEC filings and analyst reports to construct multi-scenario revenue and expense projections. By implementing rigorous sensitivity analysis, mid-year discounting conventions, and detailed WACC calculations, this skill provides investors and analysts with a robust, formula-driven Excel model that adheres to investment banking standards, complete with a full valuation bridge and source-documented inputs.

主な機能

01Programmatic Excel generation featuring 75-cell sensitivity tables for risk assessment.

02Institutional-standard WACC calculation using CAPM and current market risk-free rates.

03Audit-ready documentation with source comments for every hardcoded financial input.

04Automated financial data retrieval from SEC filings and market data providers.

050 GitHub stars

06Multi-scenario modeling (Bear, Base, Bull) with dynamic formula-based switching.

ユースケース

01Performing rapid sensitivity testing on company valuations based on varying growth and margin assumptions.

02Generating detailed financial projections and cash flow models for M&A or corporate finance.

03Valuing publicly traded companies for investment research and intrinsic value analysis.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add dgkngk/super-kit dcf-model

For use in Claude.ai and ChatGPT