officecli-financial-model

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

1|Updated Jul 22, 2026
One-click install
npx skills add https://github.com/IceHeartGitH/Hermes-Agent-Android-Termux --skill officecli-financial-model-iceheartgith
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: officecli-financial-model
Source: https://github.com/IceHeartGitH/Hermes-Agent-Android-Termux/tree/main/custom-skills/productivity/officecli-financial-model
Command: npx skills add https://github.com/IceHeartGitH/Hermes-Agent-Android-Termux --skill officecli-financial-model-iceheartgith

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve? Building an auditable financial model in Excel requires strict discipline: assumptions separated from calculations, statements that balance every period, and valuation cells with correct cached values. This Skill encodes that discipline as executable recipes and delivery gates so the output is a decision-grade .xlsx rather than a fragile 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 grid), and LBO models (Sources & Uses, multi-tranche debt schedules, cash sweep, MOIC/IRR returns). - Three-zone architecture with audits: Enforces Inputs / Calc / Outputs sheet separation, CFO 4-color code, named ranges, and zero-hardcode rules verified by executable zone audits. - Delivery gates and cache discipline: Balance checks, cash reconciliation, cache-refresh passes, and sensitivity/scenario protocols that refuse delivery on imbalanced statements. - Use Case: Ask for a DCF valuation of a company and receive a single .xlsx with an Assumptions sheet, 10-year FCF build, WACC panel, equity bridge, and a 5x5 WACC-by-growth sensitivity grid. ## Quick Start Ask the agent to build a 3-statement financial model in Excel with revenue growth, margin, and tax assumptions for the next four 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?▼

Use Recipe A, which builds Assumptions, P&L, Balance Sheet, Cash Flow, and Summary sheets in mandatory dependency order. Every statement row is a formula tracing back to blue-font assumption cells, with balance-check and cash-reconciliation rows verified before delivery.

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

Recipe B produces a 10-year FCF build, a WACC panel, an NPV and terminal-value equity bridge, and a 5x5 WACC-by-growth sensitivity grid. Each grid cell is an explicit formula because Excel Data Tables are not reliably supported through the CLI.

Does this skill work without the officecli binary installed?▼

No, real execution requires the officecli binary verified on the host. In the Hermes adaptation, the skill acts as a workflow reference unless officecli is present; it will not auto-install the tool and falls back to base xlsx skills otherwise.

Why does my Excel model show blank or wrong values in preview?▼

New formulas ship without cached values, so non-recalculating viewers show blanks. The skill mandates a cache-refresh pass that re-sets summary and valuation cells non-resident, then spot-checks cachedValue via JSON readback.

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 base officecli-xlsx skill, which this skill inherits rather than replaces.

How are circular references handled in an LBO model?▼

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