What is the Excel DCF Modeler skill?

It is a specialized capability for Claude Code that allows the AI to build structured, 4-sheet discounted cash flow valuation models directly in Excel files.

What sheets are included in the generated Excel file?

The generated workbook includes an Assumptions sheet, Free Cash Flow Projections, a Valuation summary, and a Sensitivity Analysis table.

Is the output suitable for professional presentations?

Yes, the model follows investment banking formatting standards, including specific currency/percentage formats, bold headers, and professional borders.

Can it build a model if I don't have all the financial data?

Yes, the skill is programmed with industry-standard defaults for various sectors, allowing it to create a baseline model that you can refine later.

Are the formulas hard-coded or dynamic?

The skill creates dynamic Excel formulas that link back to the Assumptions sheet, ensuring that any changes to your inputs automatically update the entire valuation.

Excel DCF Valuation Modeler

Name: Excel DCF Valuation Modeler
Author: BbgnsurfTech

byBbgnsurfTech

•

Ciencia de Datos y ML

Builds professional investment banking-standard discounted cash flow (DCF) models in Excel with automated financial projections and sensitivity analysis.

Acerca de

The Excel DCF Modeler skill empowers Claude to function as a sophisticated financial analyst by constructing comprehensive 4-sheet valuation models. It automates the complex process of projecting five-year free cash flows, calculating Weighted Average Cost of Capital (WACC), and determining terminal values. Designed for investment banking and corporate finance workflows, it ensures professional formatting, mathematical accuracy, and includes a dynamic two-way sensitivity table to analyze valuation impacts across different financial scenarios.

Características Principales

Automated 4-sheet Excel workbook creation including Assumptions, FCF, Valuation, and Sensitivity
Professional financial formatting with currency styling, frozen panes, and conditional formatting
Two-way sensitivity analysis for Enterprise Value based on WACC and Terminal Growth variations
Dynamic 5-year free cash flow (FCF) projections with customizable growth and margin inputs
Integrated WACC and terminal growth rate logic following industry best practices
3 GitHub stars

Casos de Uso

Generating intrinsic company valuations for investment research and pitch decks
Performing rapid 'what-if' analysis on business valuations by adjusting key financial drivers
Automating corporate finance modeling tasks to ensure formula consistency and professional output

Acerca de

Características Principales

Automated 4-sheet Excel workbook creation including Assumptions, FCF, Valuation, and Sensitivity
Professional financial formatting with currency styling, frozen panes, and conditional formatting
Two-way sensitivity analysis for Enterprise Value based on WACC and Terminal Growth variations
Dynamic 5-year free cash flow (FCF) projections with customizable growth and margin inputs
Integrated WACC and terminal growth rate logic following industry best practices
3 GitHub stars

Casos de Uso

Generating intrinsic company valuations for investment research and pitch decks
Performing rapid 'what-if' analysis on business valuations by adjusting key financial drivers
Automating corporate finance modeling tasks to ensure formula consistency and professional output