officecli-financial-model

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

284|54|Updated Jun 23, 2026
One-click install
npx skills add https://github.com/nomifun/nomifun-desktop --skill officecli-financial-model-nomifun
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: officecli-financial-model
Source: https://github.com/nomifun/nomifun-desktop/tree/main/crates/backend/nomifun-app/assets/builtin-skills/officecli-financial-model
Command: npx skills add https://github.com/nomifun/nomifun-desktop --skill officecli-financial-model-nomifun

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Building an auditable financial model in Excel requires strict discipline: assumptions separated from calculations, statements that balance every period, correct cached values, and sensitivity grids that actually recompute. This Skill encodes those rules so an AI agent can produce a decision-grade, formula-driven .xlsx model instead of a fragile spreadsheet full of hardcodes and cached zeros. ## Core Features & Use Cases - Three model recipes: Runnable skeletons for 3-statement models (P&L + Balance Sheet + Cash Flow with balance checks), DCF valuations (WACC panel, terminal value, equity bridge, WACC × g sensitivity grid), and LBO models (Sources & Uses, multi-tranche debt schedules, cash sweeps, MOIC/IRR returns). - Three-zone architecture enforcement: Inputs, Calc, and Outputs zones with tab colors, CFO 4-color font conventions, named ranges, and executable audits that reject hardcoded numbers on calculation sheets. - Delivery gates and cache discipline: Balance-check and cash-reconciliation rows, cache-refresh passes to avoid shipping zero-valued NPV/IRR cells, circular-reference handling with iterative calculation, and print-ready Outputs-only delivery for board or IC audiences. - Use Case: Ask for a 5-year DCF valuation of a company and receive a single .xlsx with an Assumptions sheet, 10-year FCF build, WACC panel, implied per-share value, and a 5×5 sensitivity grid — every figure traceable to a blue-font input. ## Quick Start Use the officecli-financial-model skill to build a 3-statement financial model in Excel with assumptions, balance checks, and a summary dashboard.

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 with an AI agent?▼

This Skill generates a 3-statement model via OfficeCLI with Assumptions, P&L, Balance Sheet, Cash Flow, and Summary sheets. It enforces a strict build order, live formulas for every row, and balance-check plus cash-reconciliation rows that must read OK before delivery.

How to create a DCF valuation spreadsheet with sensitivity analysis?▼

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

Does this skill work without the officecli-xlsx base skill?▼

No, it is a scene layer on top of officecli-xlsx and inherits all its rules, including shell quoting, batch execution, number formats, and the delivery cycle. You should read the officecli-xlsx SKILL.md first before using this financial-model layer.

Why does my Excel model show zero for NPV or IRR cells?▼

New formulas written through the CLI can cache 0 before upstream values exist, and NPV with cross-sheet ranges silently caches 0 on v1.0.63. The skill fixes this with a cache-refresh pass that re-sets valuation cells non-resident and uses SUMPRODUCT instead of NPV.

When should I not use the financial-model skill?▼

Do not use it for simple budget trackers, CSV-to-report dumps, operational KPI sheets, or cap tables without forecast logic. Those tasks route to the officecli-xlsx base skill; this layer is only for 3-statement, DCF, LBO, unit economics, and sensitivity or scenario models.

How are circular references handled in LBO models?▼

Legitimate circularity like interest-to-cash loops is enabled with calc.iterate=true, iterateCount=100, and iterateDelta=0.001 set before writing ring formulas. Accidental circularity is treated as broken algebra and must be fixed rather than papered over with iteration.