Does this skill require existing Excel templates?

No, the skill uses the Excel MCP server to build a professional workbook from scratch, including all necessary formulas, sheets, and formatting.

Can it calculate the implied share price?

Yes, if you provide the company's net debt and shares outstanding, the skill will calculate the Equity Value and the resulting value per share.

What financial methodology does the model use?

It follows standard investment banking practices for Unlevered Free Cash Flow (UFCF) and uses the Gordon Growth Method for terminal value calculations.

Does it include a sensitivity analysis?

Yes, it automatically generates a two-way data table showing how Enterprise Value changes based on varying WACC and Terminal Growth Rate inputs.

Can I customize the growth and margin assumptions?

Yes, you can provide specific revenue growth rates, EBITDA margins, and tax rates, or the AI can provide industry-standard defaults if you are unsure.

Excel DCF Modeler

Name: Excel DCF Modeler
Author: BbgnsurfTech

byBbgnsurfTech

•

生产力与工作流

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

The Excel DCF Modeler skill transforms raw financial data into a comprehensive, four-sheet valuation workbook following investment banking best practices. It automatically handles complex calculations for Free Cash Flow, Terminal Value, and Weighted Average Cost of Capital (WACC), while generating two-way sensitivity tables to analyze valuation impacts under different scenarios. This tool is ideal for finance professionals, analysts, and students needing to perform rigorous intrinsic value assessments without manual spreadsheet construction.

主要功能

01Professional investment banking-standard Excel formatting

023 GitHub stars

03Automated 5-year Free Cash Flow (FCF) projections

04Two-way sensitivity analysis for growth rates and discount rates

05WACC-based Enterprise and Equity Value calculations

06Dynamic linking between assumptions and valuation outputs

使用场景

01Valuing a public or private company for investment analysis

02Creating financial models for pitch decks and corporate presentations

03Conducting quick 'what-if' sensitivity analysis on business valuations

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