DCF-модель в Excel с живыми формулами

★ 7.1 · financial-analysis

dcf-model is a Claude Code skill that builds institutional-quality discounted cash flow valuation workbooks in Excel (.xlsx) using the openpyxl library. Every projection, discount factor, and sensitivity cell must be a live Excel formula — computing values in Python and writing them as hardcoded numbers is explicitly prohibited. The model is assembled in mandatory step-by-step checkpoints: raw inputs → revenue → FCF schedule → WACC → equity bridge → sensitivity tables (5×5 or 7×7, center cell equals the base case and is highlighted in medium blue). Bear/Base/Bull scenarios are driven by IF formulas, and every hardcoded input receives a source comment at creation time. Before delivery, recalc.py is run to eliminate all formula errors (#REF!, #DIV/0!, etc.). Designed for analysts and teams that follow investment banking modeling standards.