What problem does it solve? Building a discounted cash flow valuation model by hand is slow and error-prone: sourcing financial data, computing WACC, projecting free cash flows, and wiring hundreds of live Excel formulas. This Skill automates the full workflow and produces an auditable, formula-driven Excel model. ## Core Features & Use Cases - End-to-end DCF construction: Retrieves financial data from SEC filings, analyst reports, MCP servers, or user inputs, then builds revenue projections, FCF schedules, WACC via CAPM, terminal value, and an equity value bridge. - Scenario and sensitivity analysis: Creates Bear/Base/Bull assumption blocks with a case selector, plus three 5x5 sensitivity tables (WACC vs terminal growth, revenue growth vs EBIT margin, beta vs risk-free rate) where every cell recalculates the full DCF. - Validation and quality control: Ships a validate_dcf.py script that checks for formula errors (#REF!, #DIV/0!), verifies terminal growth is below WACC, and confirms terminal value proportion of enterprise value. - Use Case: Ask for an intrinsic value analysis of a public company; the Skill gathers data, confirms assumptions with you at each stage, and delivers a professional .xlsx model with sourced cell comments and zero formula errors. ## Quick Start Build a DCF valuation model for Apple (AAPL) using consensus growth estimates and a 5-year projection period.
