What inputs do I need to start a DCF model?

At minimum, you need a company name and base revenue. The skill can provide industry-standard defaults for growth rates, tax rates, WACC, and margins if you don't have specific data.

Is this model suitable for professional investment banking?

It is designed for initial valuation analysis and pitch decks. For official fairness opinions, additional granularity like detailed debt schedules and professional reviews are recommended.

Are the formulas in the Excel sheet hard-coded?

No, the skill follows financial modeling best practices where all formulas link back to the Assumptions sheet, ensuring a clear audit trail and easy updates.

Does the generated Excel file include sensitivity analysis?

Yes, it automatically generates a two-way sensitivity table comparing Enterprise Value against variations in WACC and Terminal Growth rates.

How do I activate the DCF modeler?

Simply prompt Claude with phrases like 'Create a DCF model for [Company]' or 'Calculate enterprise value' to trigger the skill workflow.

Excel DCF Modeler

Name: Excel DCF Modeler
Author: jeremylongshore

byjeremylongshore

•

883

•

Productivity & Workflow

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

This skill empowers financial analysts and corporate finance teams by automating the creation of comprehensive DCF models following investment banking standards. It structures multi-sheet Excel workbooks including assumptions, 5-year free cash flow projections, intrinsic valuation calculations, and two-way sensitivity tables. The skill handles complex calculations like WACC and terminal value while ensuring proper formatting and audit-friendly formula linking, making it an essential tool for quick valuations, pitch deck preparation, and strategic corporate planning.

Key Features

01Smart input validation with industry-standard defaults for missing financial data.

02Built-in financial logic for WACC, Terminal Value, and Enterprise Value calculations.

03Automated 4-sheet Excel workbook generation including Assumptions and FCF Projections.

04Professional financial formatting with currency styling and conditional color scales.

05Dynamic two-way sensitivity analysis for WACC and Terminal Growth variables.

06883 GitHub stars

Use Cases

01Valuing public or private companies for investment research and equity analysis.

02Generating foundational financial models for investment banking pitch decks.

03Performing 'what-if' scenario analysis for corporate strategic planning and budgeting.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills excel-dcf-modeler

For use in Claude.ai and ChatGPT

Download Skill