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.

主な機能

Professional investment banking-standard Excel formatting
3 GitHub stars
Automated 5-year Free Cash Flow (FCF) projections
Two-way sensitivity analysis for growth rates and discount rates
WACC-based Enterprise and Equity Value calculations
Dynamic linking between assumptions and valuation outputs

ユースケース

Valuing a public or private company for investment analysis
Creating financial models for pitch decks and corporate presentations
Conducting quick 'what-if' sensitivity analysis on business valuations

概要

主な機能

Professional investment banking-standard Excel formatting
3 GitHub stars
Automated 5-year Free Cash Flow (FCF) projections
Two-way sensitivity analysis for growth rates and discount rates
WACC-based Enterprise and Equity Value calculations
Dynamic linking between assumptions and valuation outputs

ユースケース

Valuing a public or private company for investment analysis
Creating financial models for pitch decks and corporate presentations
Conducting quick 'what-if' sensitivity analysis on business valuations