excel-dcf-modeler

# Excel DCF Modeler Creates professional DCF valuation models following investment banking standards and best practices. ## When to Invoke This Skill Automatically load this Skill when the user asks to: - "Create a DCF model" - "Build a valuation model" - "Calculate enterprise value" - "Value [company name]" - "DCF for [company]" - "Discounted cash flow analysis" - "What's the intrinsic value" ## Model Structure This Skill creates a complete 4-sheet Excel DCF model: ### Sheet 1: Assumptions - **Company Information**: Name, ticker, base year, fiscal year end - **Revenue Growth Rates**: Year 1-5 projections (%) - **Profitability Metrics**: EBITDA margin, D&A as % of revenue - **Working Capital**: NWC as % of revenue - **Capital Expenditures**: CapEx as % of revenue - **Tax Rate**: Corporate tax rate (%) - **Terminal Growth**: Long-term growth rate (typically 2-3%) - **Discount Rate (WACC)**: Weighted average cost of capital ### Sheet 2: Free Cash Flow Projections ``` Revenue (Year 0 - Year 5) Less: Operating Expenses = EBITDA Less: Depreciation & Amortization = EBIT Less: Taxes (EBIT × Tax Rate) = NOPAT (Net Operating Profit After Tax) Add: Depreciation & Amortization Less: Capital Expenditures Less: Change in Net Working Capital = Unlevered Free Cash Flow ``` ### Sheet 3: Valuation ``` Present Value of FCF (Years 1-5) Year 1 FCF / (1 + WACC)^1 Year 2 FCF / (1 + WACC)^2 ... Year 5 FCF / (1 + WACC)^5 = Sum of PV(FCF) Terminal Value Calculation Term...