Can I use my own financial assumptions with this skill?

Yes, the skill allows you to provide specific inputs for revenue growth, margins, and discount rates, or it can provide industry-standard defaults if you are missing data.

Does the generated model include sensitivity analysis?

Absolutely. Every model includes a two-way sensitivity table that tracks how Enterprise Value changes in response to fluctuations in WACC and Terminal Growth Rates.

What does the Excel DCF Modeler skill do?

It automates the creation of a standardized 4-sheet investment banking valuation model in Excel, covering assumptions, FCF projections, valuation summaries, and sensitivity analysis.

Are the formulas hard-coded or dynamic?

Following best practices, all formulas are dynamic and link back to the Assumptions sheet, ensuring the model remains easy to audit and update manually.

Excel DCF Modeler

Name: Excel DCF Modeler
Author: intent-solutions-io

byintent-solutions-io

Data Science & ML

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

About

This skill transforms Claude into an automated investment banking analyst capable of constructing comprehensive 4-sheet Excel DCF models. It streamlines the financial modeling process by calculating Year 1-5 unlevered free cash flow projections, WACC, and terminal values while ensuring all formulas are logically linked to a centralized assumptions sheet. Ideal for corporate finance teams and equity researchers, the skill follows industry best practices to generate audit-ready models complete with two-way sensitivity tables and professional formatting.

Key Features

0 GitHub stars
Investment banking standard Excel formatting and structure
Automated 5-year unlevered free cash flow (UFCF) projections
Two-way sensitivity tables for WACC and Terminal Growth assessment
Dynamic WACC and Terminal Value calculation engines
Built-in financial input validation and reasonability checks

Use Cases

Creating professional valuation templates for investment pitch decks
Performing sensitivity analysis on business valuations for risk management
Rapidly generating intrinsic value estimates for public or private companies

About

Key Features

0 GitHub stars
Investment banking standard Excel formatting and structure
Automated 5-year unlevered free cash flow (UFCF) projections
Two-way sensitivity tables for WACC and Terminal Growth assessment
Dynamic WACC and Terminal Value calculation engines
Built-in financial input validation and reasonability checks

Use Cases

Creating professional valuation templates for investment pitch decks
Performing sensitivity analysis on business valuations for risk management
Rapidly generating intrinsic value estimates for public or private companies