Финансовые модели в Excel: DCF, LBO, SaaS
★ 7.7 · financial-analysis
officecli-financial-model is a Claude Code skill that builds decision-grade financial models in Excel: 3-statement models (P&L, Balance Sheet, Cash Flow), DCF valuations with WACC and terminal value, LBOs with debt schedules and cash sweeps, SaaS unit economics (CAC/LTV, ARR roll-forward), and manual sensitivity and scenario grids. Every output traces an unbroken chain to blue assumption cells, statements balance each period, and valuation cells — NPV, IRR, XIRR, MOIC — are verified with a cached-value readback. Built as a scene layer on top of officecli-xlsx, it inherits the CFO 4-color code, number-format standards, circular-reference discipline via calc.iterate, named ranges for reused drivers, and a 6-gate delivery cycle. Designed for analysts, CFOs, and advisors who need an auditable investment model rather than a simple budget tracker or KPI sheet.
- #financial-modeling
- #excel
- #dcf-valuation
- #3-statement-model
- #lbo-analysis
- #sensitivity-analysis