officecli-financial-model

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

Updated Jul 10, 2026
One-click install
npx skills add https://github.com/Grong/openhub-client --skill officecli-financial-model-grong
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: officecli-financial-model
Source: https://github.com/Grong/openhub-client/tree/main/crates/backend/openhub-app/assets/builtin-skills/officecli-financial-model
Command: npx skills add https://github.com/Grong/openhub-client --skill officecli-financial-model-grong

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 formula values, and sensitivity grids that actually recompute. This Skill encodes those rules so an AI agent produces a decision-grade .xlsx model instead of a fragile spreadsheet. ## 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 sweep, MOIC/IRR returns). - Three-zone architecture enforcement: Inputs / Calc / Outputs zones with tab colors, CFO 4-color font code, named ranges, and executable audits that reject hardcoded numbers on calculation sheets. - Delivery gates: Balance-check and cash-reconciliation rows, cache-drift spot checks on valuation cells, circular-reference handling with iterative calculation, and print-ready board/IC output scoped to the Outputs zone. - 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 — all formula-driven and audit-ready. ## 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 AI?▼

This Skill generates a 3-statement model via OfficeCLI with Assumptions, P&L, Balance Sheet, Cash Flow, and Summary sheets. It enforces build order (P&L before BS before CF), live retained-earnings formulas, and balance-check 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 × growth sensitivity grid where each cell is an explicit formula, since Excel Data Tables are not reliably supported.

Does this skill handle circular references in LBO models?▼

Yes. Legitimate circularity like interest-to-cash loops is enabled with calc.iterate=true, iterateCount=100, and a convergence delta. Accidental circular references are treated as broken algebra to fix, never papered over with iteration settings.

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

Route simple budget trackers, CSV-to-report dumps, operational KPI sheets, and cap tables without forecast logic to the base officecli-xlsx skill instead. This skill is only for 3-statement, DCF, LBO, unit economics, sensitivity, and scenario modeling requests.

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

New formulas ship without cached values, and NPV with cross-sheet ranges can silently cache 0. The skill uses SUMPRODUCT instead of NPV, re-sets valuation cells non-resident after the build, and spot-checks cachedValue before delivery.