dcf-valuation-modeler

# DCF Valuation Modeler ## Overview The DCF Valuation Modeler skill provides comprehensive Discounted Cash Flow analysis capabilities for company valuations. It combines free cash flow projections with weighted average cost of capital (WACC) calculations and terminal value estimation to produce robust enterprise valuations. ## Capabilities ### Free Cash Flow Projection - Revenue and expense forecasting models - Working capital requirement projections - Capital expenditure modeling - Depreciation and amortization schedules - Tax effect calculations - Unlevered free cash flow computation ### WACC Calculation - Cost of equity via Capital Asset Pricing Model (CAPM) - Cost of debt determination with tax shield - Capital structure weighting - Beta estimation and adjustment - Risk-free rate selection - Equity risk premium calculation ### Terminal Value Estimation - Perpetuity growth method implementation - Exit multiple methodology - Terminal value reasonability checks - Fade period modeling - Long-term growth rate validation ### Sensitivity Analysis - Two-variable sensitivity tables - Tornado chart generation - Key driver identification - Break-even analysis - Scenario comparison matrices ### Monte Carlo Simulation - Probability distribution assignment - Correlation matrix handling - Convergence analysis - Confidence interval generation - Value at Risk integration ### Multi-Scenario Analysis - Base, bull, and bear case modeling - Probability-weighted valuation - Scenario d...