excel-dcf-modeler

Creates a professional 4-sheet DCF model with sensitivity analysis and valuation outputs.

• Builds DCF valuation models using investment banking standards
• Generates 4-sheet Excel models with assumptions, FCF, valuation, and sensitivity
• Calculates enterprise and equity value with sensitivity analysis
• Provides valuation insights and key driver commentary

• 4-sheet structure: Assumptions, FCF Projections, Valuation, Sensitivity
• Two-way sensitivity table for WACC and terminal growth
• Professional formatting with conditional formatting and borders
• Validates inputs for reasonableness and model stability
• Includes terminal value and PV of FCF calculations
• Returns enterprise, equity, and per-share values
• Provides qualitative insights on value drivers and sensitivity
• Uses industry defaults when inputs are missing

1. 1.Ask user for company name, revenue, growth rates, margins, and other inputs
2. 2.Validate inputs for reasonableness and model stability
3. 3.Build model in Excel with correct formulas and structure
4. 4.Return valuation results and sensitivity analysis
5. 5.Provide brief insights on value drivers and sensitivity