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

0•

データサイエンスとML

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

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.

主な機能

010 GitHub stars

02Investment banking standard Excel formatting and structure

03Automated 5-year unlevered free cash flow (UFCF) projections

04Two-way sensitivity tables for WACC and Terminal Growth assessment

05Dynamic WACC and Terminal Value calculation engines

06Built-in financial input validation and reasonability checks

ユースケース

01Creating professional valuation templates for investment pitch decks

02Performing sensitivity analysis on business valuations for risk management

03Rapidly generating intrinsic value estimates for public or private companies

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add intent-solutions-io/plugins-nixtla excel-dcf-modeler

For use in Claude.ai and ChatGPT

Download Skill