What standards does the model follow?

The models are built according to investment banking standards, utilizing a 4-sheet structure: Assumptions, Projections, Valuation, and Sensitivity Analysis.

What is the Excel DCF Modeler skill?

It is a specialized Claude Code skill that automates the creation of professional-grade Discounted Cash Flow (DCF) valuation models directly in Excel files.

Can I use this for M&A valuation?

Absolutely. The skill is designed to handle acquisition target analysis, including scenario modeling and synergy adjustments to determine equity value.

Does this skill include sensitivity analysis?

Yes, the modeler automatically generates sensitivity tables that demonstrate how the valuation changes based on fluctuations in WACC and terminal growth rates.

What happens if the terminal growth rate exceeds the WACC?

The skill includes built-in error handling for financial logic, alerting you that terminal growth must be lower than WACC to prevent mathematical errors like #DIV/0!.

Excel DCF Financial Modeler

Name: Excel DCF Financial Modeler
Author: Jst-Well-Dan

byJst-Well-Dan

•

数据科学与机器学习

Builds investment-grade discounted cash flow valuation models in Excel with automated projections and sensitivity analysis.

关于

This skill transforms Claude into a sophisticated financial analyst capable of generating comprehensive DCF valuation models from scratch. It automates the creation of professional multi-sheet Excel workbooks that include five-year free cash flow projections, WACC calculations, Gordon Growth terminal value estimations, and equity value bridge calculations. It is an essential tool for investment bankers, corporate finance professionals, and investors who need to rapidly prototype company valuations while adhering to rigorous industry standards and best practices.

主要功能

Automated 5-year free cash flow (FCF) projections based on growth assumptions
Integrated sensitivity analysis tables for key variables like WACC and growth rates
Multi-sheet organization with dedicated tabs for assumptions, projections, and valuation
4 GitHub stars
Dynamic WACC calculation and terminal value estimation using Gordon Growth Model
Standardized enterprise value to equity value bridge with net debt adjustments

使用场景

Conducting M&A valuation analysis for potential acquisition targets including synergy adjustments
Valuing high-growth SaaS companies for venture capital or private equity investment
Performing rapid equity value-per-share estimations for public company analysis

关于

主要功能

Automated 5-year free cash flow (FCF) projections based on growth assumptions
Integrated sensitivity analysis tables for key variables like WACC and growth rates
Multi-sheet organization with dedicated tabs for assumptions, projections, and valuation
4 GitHub stars
Dynamic WACC calculation and terminal value estimation using Gordon Growth Model
Standardized enterprise value to equity value bridge with net debt adjustments

使用场景

Conducting M&A valuation analysis for potential acquisition targets including synergy adjustments
Valuing high-growth SaaS companies for venture capital or private equity investment
Performing rapid equity value-per-share estimations for public company analysis