Does it require specific financial data to work?

Yes, it requires basic inputs like revenue, growth rates, and margins. If you don't have these, the skill can provide industry-standard defaults or look up recent financials for public companies.

Can I use this for complex company structures?

This skill provides a high-quality core DCF model. While suitable for many professional uses, extremely complex scenarios involving detailed debt schedules or multi-stage growth may require manual refinement after generation.

What does the Excel DCF Modeler skill do?

It builds a complete, professional-grade Discounted Cash Flow (DCF) model in Excel, including assumptions, cash flow projections, valuation calculations, and sensitivity analysis.

How do I activate this skill in Claude Code?

Simply ask Claude to 'create a DCF model', 'build a valuation model', or 'value [Company Name]' to trigger the automated financial modeling workflow.

Is the generated Excel model editable?

Absolutely. The model is built with linked formulas rather than hard-coded values, allowing you to manually adjust assumptions in the 'Assumptions' sheet after the file is created.

Excel DCF Modeler

Name: Excel DCF Modeler
Author: BbgnsurfTech

byBbgnsurfTech

•

生産性とワークフロー

Generates professional-grade discounted cash flow (DCF) valuation models in Excel following investment banking standards.

概要

This skill empowers finance professionals and analysts to rapidly construct sophisticated valuation models within Excel. It automates the creation of a comprehensive four-sheet workbook featuring detailed revenue and free cash flow projections, WACC calculations, terminal value estimation, and automated two-way sensitivity analysis. By handling the complex formula logic and professional formatting, it allows users to focus on refining financial assumptions and interpreting intrinsic value insights for investment banking, corporate finance, or strategic planning.

主な機能

Standardized investment banking formula logic for Unlevered Free Cash Flow
Professional financial formatting including currency, percentages, and conditional styling
Automated 4-sheet Excel workbook generation (Assumptions, FCF, Valuation, Sensitivity)
Dynamic two-way sensitivity tables for WACC and Terminal Growth
Intelligent validation of financial inputs and reasonableness checks
3 GitHub stars

ユースケース

Performing 'what-if' scenario analysis on business value drivers
Rapidly valuing a public or private company for investment analysis
Creating professional financial models for pitch decks and corporate presentations

概要

主な機能

Standardized investment banking formula logic for Unlevered Free Cash Flow
Professional financial formatting including currency, percentages, and conditional styling
Automated 4-sheet Excel workbook generation (Assumptions, FCF, Valuation, Sensitivity)
Dynamic two-way sensitivity tables for WACC and Terminal Growth
Intelligent validation of financial inputs and reasonableness checks
3 GitHub stars

ユースケース

Performing 'what-if' scenario analysis on business value drivers
Rapidly valuing a public or private company for investment analysis
Creating professional financial models for pitch decks and corporate presentations