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

•

Data Science & ML

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

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.

Key Features

01Automated 4-sheet Excel workbook creation including Assumptions, FCF, Valuation, and Sensitivity

02Professional financial formatting with currency styling, frozen panes, and conditional formatting

03Two-way sensitivity analysis for Enterprise Value based on WACC and Terminal Growth variations

04Dynamic 5-year free cash flow (FCF) projections with customizable growth and margin inputs

05Integrated WACC and terminal growth rate logic following industry best practices

063 GitHub stars

Use Cases

01Generating intrinsic company valuations for investment research and pitch decks

02Performing rapid 'what-if' analysis on business valuations by adjusting key financial drivers

03Automating corporate finance modeling tasks to ensure formula consistency and professional output

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bbgnsurftech/claude-skills-collection excel-dcf-modeler

For use in Claude.ai and ChatGPT

Download Skill