What sheets are included in the generated Excel model?

The skill creates a structured 4-sheet workbook containing Assumptions, Free Cash Flow Projections, Valuation calculations, and a Sensitivity Analysis table.

Does this skill follow standard investment banking practices?

Yes, it incorporates best practices such as tapering growth rates, conservative terminal growth defaults (e.g., 2.5%), and professional cell linking to avoid hard-coded values.

Does it handle errors like a Terminal Growth rate exceeding WACC?

The skill includes built-in validation that flags mathematically invalid inputs, such as terminal growth exceeding the discount rate, and suggests realistic ranges for correction.

Can I customize the financial assumptions used in the model?

Yes, you can provide specific inputs for revenue growth, margins, and WACC, or the skill can provide industry-standard defaults if you are analyzing a specific sector without full data.

Excel DCF Modeler

Name: Excel DCF Modeler
Author: intent-solutions-io

byintent-solutions-io

数据科学与机器学习

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

关于

The Excel DCF Modeler skill automates the creation of comprehensive 4-sheet Excel workbooks following industry standards for corporate finance. It generates detailed free cash flow projections, calculates WACC and terminal values, and builds two-way sensitivity tables to analyze valuation impacts. By gathering key inputs like revenue growth and EBITDA margins, it applies rigorous financial modeling best practices—including revenue tapering and professional formatting—to provide instant, audit-ready intrinsic value assessments for any company.

主要功能

Investment banking-standard formatting with linked cells and audit trails.
Integrated two-way sensitivity analysis for WACC and Terminal Growth rate variables.
Intelligent input validation to ensure financial logic consistency and feasibility.
Automated 4-sheet Excel workbook creation (Assumptions, FCF, Valuation, and Sensitivity).
Dynamic financial formulas for WACC, NOPAT, and Terminal Value calculations.
0 GitHub stars

使用场景

Developing financial projections and 'what-if' scenarios for corporate strategy.
Calculating equity value per share for publicly traded or private companies.
Performing rapid intrinsic valuation analysis for investment banking pitch decks.

关于

主要功能

Investment banking-standard formatting with linked cells and audit trails.
Integrated two-way sensitivity analysis for WACC and Terminal Growth rate variables.
Intelligent input validation to ensure financial logic consistency and feasibility.
Automated 4-sheet Excel workbook creation (Assumptions, FCF, Valuation, and Sensitivity).
Dynamic financial formulas for WACC, NOPAT, and Terminal Value calculations.
0 GitHub stars

使用场景

Developing financial projections and 'what-if' scenarios for corporate strategy.
Calculating equity value per share for publicly traded or private companies.
Performing rapid intrinsic valuation analysis for investment banking pitch decks.