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

0•

データサイエンスとML

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.

主な機能

01Investment banking-standard formatting with linked cells and audit trails.

02Integrated two-way sensitivity analysis for WACC and Terminal Growth rate variables.

03Intelligent input validation to ensure financial logic consistency and feasibility.

04Automated 4-sheet Excel workbook creation (Assumptions, FCF, Valuation, and Sensitivity).

05Dynamic financial formulas for WACC, NOPAT, and Terminal Value calculations.

060 GitHub stars

ユースケース

01Developing financial projections and 'what-if' scenarios for corporate strategy.

02Calculating equity value per share for publicly traded or private companies.

03Performing rapid intrinsic valuation analysis for investment banking pitch decks.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add intent-solutions-io/plugins-nixtla excel-dcf-modeler

For use in Claude.ai and ChatGPT

Download Skill