officecli-financial-model

Builds formula-driven Excel financial models including 3-statement, DCF, and LBO structures.

Updated Aug 19, 2026
One-click install
npx skills add https://github.com/Dhanuzh/DCode-Core --skill officecli-financial-model-dhanuzh
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: officecli-financial-model
Source: https://github.com/Dhanuzh/DCode-Core/tree/main/crates/dcode-app/assets/builtin-skills/officecli-financial-model
Command: npx skills add https://github.com/Dhanuzh/DCode-Core --skill officecli-financial-model-dhanuzh

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Building a decision-grade financial model in Excel requires strict discipline: assumptions separated from calculations, statements that balance every period, auditable formulas, and cached values that render correctly. This Skill automates that entire workflow, producing a single formula-driven .xlsx file instead of a fragile hand-built spreadsheet. ## Core Features & Use Cases - Three model recipes: Runnable skeletons for 3-statement models (P&L + Balance Sheet + Cash Flow), DCF valuations (WACC, NPV, terminal value, sensitivity grids), and LBO models (debt schedules, cash sweeps, MOIC/IRR returns). - Three-zone architecture enforcement: Inputs, Calc, and Outputs zones with executable audits that reject hardcoded numbers on calculation sheets and verify balance checks. - Sensitivity and scenario analysis: Two-axis WACC × growth sensitivity grids and scenario switches built as explicit formulas. - Use Case: Ask for a DCF valuation of a company and receive an Excel workbook with an assumptions sheet, 10-year FCF forecast, WACC panel, equity bridge, and a color-coded sensitivity table ready for board review. ## Quick Start Ask the AI to build a 3-statement financial model in Excel with revenue growth, margin, and tax assumptions for the next three years.

Frequently Asked Questions about officecli-financial-model

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I build a 3-statement financial model in Excel?

This Skill generates a 3-statement model with Assumptions, P&L, Balance Sheet, Cash Flow, and Summary sheets. It builds in dependency order, links every row to assumption cells, and adds balance-check and cash-reconciliation rows that must read OK before delivery.

How do I create a DCF valuation spreadsheet with sensitivity analysis?

The DCF recipe produces a 10-year FCF forecast, a WACC panel, terminal value via Gordon growth, an equity bridge to per-share value, and a 5x5 WACC-by-growth sensitivity grid. Each grid cell is an explicit formula since Excel Data Tables are not reliably supported.

Does this skill work on Windows?

Yes, but the shell snippets are written for macOS/Linux bash. On Windows you must translate them to PowerShell equivalents, such as replacing heredocs with temp files and grep with Select-String, before running the officecli commands.

Why does my Excel model show blank or wrong values after generation?

New formulas ship without cached values, so non-recalculating viewers show blanks. The skill handles this with a cache-refresh pass that re-sets summary and valuation cells, then verifies plausible cached values via readback queries.

When should I not use the financial model skill?

Do not use it for simple budget trackers, CSV dumps, operational KPI sheets, or cap tables without forecast logic. Those tasks route to the base officecli-xlsx skill, which this skill extends only for decision-grade modeling work.