What financial formulas does the model use?

The skill uses standard investment banking formulas for Unlevered Free Cash Flow (UFCF), WACC, Terminal Value via the Gordon Growth Method, and Enterprise/Equity Value calculations.

Is the Excel file formatted for professional use?

Absolutely. The skill applies professional formatting including bold headers, currency/percentage signs, frozen panes for easy navigation, and conditional formatting on sensitivity tables.

Can I customize the assumptions after the model is built?

Yes, the model is generated with a dedicated 'Assumptions' sheet. All calculation formulas in the other sheets are dynamically linked to these cells, allowing you to update inputs and see real-time valuation changes.

Does it support different industries?

While it provides sensible industry-standard defaults, you can provide specific margins, growth rates, and tax rates to tailor the DCF model to any specific sector or company profile.

Excel DCF Modeler

Name: Excel DCF Modeler
Author: BbgnsurfTech

byBbgnsurfTech

•

생산성 및 워크플로

Generates professional investment-grade Discounted Cash Flow (DCF) valuation models directly in Microsoft Excel.

소개

The Excel DCF Modeler is a specialized Claude Code skill designed for finance professionals, investment bankers, and corporate analysts. It automates the creation of comprehensive 4-sheet valuation models, including detailed free cash flow projections, WACC calculations, terminal value estimations, and two-way sensitivity analysis. By following industry best practices and investment banking standards, it provides a structured framework for calculating intrinsic value, enterprise value, and equity value per share, while maintaining a clear audit trail with linked formulas and professional formatting.

주요 기능

Built-in financial logic for WACC, NOPAT, and Terminal Value calculations
Interactive two-way sensitivity tables for WACC and terminal growth rates
Professional formatting including currency styling, frozen panes, and conditional formatting
1 GitHub stars
Intelligent default assumptions based on industry standards and company profiles
Automated 4-sheet Excel model generation (Assumptions, FCF, Valuation, Sensitivity)

사용 사례

Creating standardized financial modeling templates for corporate finance teams
Quickly building initial valuation models for investment pitches or presentations
Conducting 'what-if' sensitivity analysis on key financial drivers like revenue growth and margins

소개

주요 기능

Built-in financial logic for WACC, NOPAT, and Terminal Value calculations
Interactive two-way sensitivity tables for WACC and terminal growth rates
Professional formatting including currency styling, frozen panes, and conditional formatting
1 GitHub stars
Intelligent default assumptions based on industry standards and company profiles
Automated 4-sheet Excel model generation (Assumptions, FCF, Valuation, Sensitivity)

사용 사례

Creating standardized financial modeling templates for corporate finance teams
Quickly building initial valuation models for investment pitches or presentations
Conducting 'what-if' sensitivity analysis on key financial drivers like revenue growth and margins