dcf-modeler

# DCF Modeler ## Overview The DCF Modeler skill builds Discounted Cash Flow valuation models for venture capital analysis. While DCF is less common for early-stage VC, it supports late-stage growth investments, exit analysis, and LP return modeling where cash flow projections are meaningful. ## Capabilities ### Cash Flow Projection - Project operating cash flows - Model capital expenditure requirements - Estimate working capital changes - Handle loss-making growth phase transitions ### Discount Rate Calculation - Calculate WACC for appropriate structures - Apply venture-appropriate discount rates - Adjust for stage and risk profile - Model cost of equity with VC premiums ### Terminal Value Estimation - Calculate terminal value via exit multiple - Apply perpetuity growth method - Hybrid terminal value approaches - Terminal value sanity checks ### Sensitivity Analysis - Build sensitivity tables - Model key assumption impacts - Calculate value driver sensitivities - Create scenario matrices ## Usage ### Build DCF Model ``` Input: Financial projections, assumptions Process: Build cash flow model, calculate value Output: DCF valuation, model outputs ``` ### Calculate Discount Rate ``` Input: Company profile, capital structure Process: Calculate appropriate discount rate Output: WACC/discount rate, methodology notes ``` ### Estimate Terminal Value ``` Input: Terminal year financials, exit assumptions Process: Calculate terminal value Output: Terminal value, percentage of...