Does it create an actual downloadable Excel file?

Yes, the skill uses the Excel MCP server to generate a fully formatted .xlsx workbook with multiple sheets, cell borders, frozen panes, and currency formatting.

Is the model structure following investment banking standards?

Yes, it follows standard IB practices, including Unlevered FCF calculation (NOPAT + D&A - CapEx - ΔNWC) and discounting using the mid-year convention logic where appropriate.

Can I use my own financial assumptions in the model?

Yes, the skill explicitly asks for specific inputs like revenue growth, EBITDA margins, and tax rates, while providing sensible industry defaults if you don't have all the data ready.

What components are included in the sensitivity analysis?

The model includes a two-way data table that tests Enterprise Value sensitivity against variations in the Weighted Average Cost of Capital (WACC) and the Terminal Growth Rate.

Excel DCF Modeler

Name: Excel DCF Modeler
Author: jeremylongshore

byjeremylongshore

•

883

生産性とワークフロー

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

概要

The Excel DCF Modeler is a specialized skill designed for investment banking and corporate finance workflows. It automates the creation of comprehensive four-sheet financial models, including detailed assumptions, five-year unlevered free cash flow projections, WACC calculations, and intrinsic valuation. By integrating professional formatting and linked formula structures, it allows analysts to quickly move from raw financial data to a robust enterprise value assessment, complete with a two-way sensitivity analysis for stress-testing key variables.

主な機能

883 GitHub stars
Dynamic WACC and Terminal Value calculations based on industry standards
Professional Excel workbook generation with linked formulas and audit trails
Comprehensive Equity Value and per-share price calculations
Automated 5-year Unlevered Free Cash Flow (FCF) projection modeling
Two-way sensitivity analysis for WACC and Terminal Growth rate impact

ユースケース

Rapidly building valuation models for investment pitch decks and presentations
Standardizing financial modeling templates across corporate finance teams
Performing quick 'back-of-the-envelope' intrinsic value checks on public companies

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

GitHub

概要