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.