officecli-financial-model

Name: officecli-financial-model
Author: iOfficeAI

21installs1.4kforks

How to install officecli-financial-model?

iofficeai/officecli/officecli-financial-model

$npx -y skills add iOfficeAI/OfficeCLI --skill officecli-financial-model

Installs into the current project.

Summary

Use this skill when the user wants to build a financial model — 3-statement model, DCF valuation, LBO, SaaS unit economics, sensitivity / scenario analysis, debt schedule, or fundraising projections — in Excel. Trigger on: 'financial model', '3-statement model', 'P&L + BS + CF',

Files · 1

View on GitHub

SKILL.md

1	# OfficeCLI Financial-Model Skill
2
3	This skill is a scene layer on top of `officecli-xlsx`. Every xlsx hard rule — shell quoting, incremental execution, Help-First Rule, visual delivery floor, CFO 4-color code (blue input / black formula / green cross-sheet / yellow-fill assumption), number-format standards (years as text, zero as `-`, `%` one decimal, negatives in parens), assumption-cell discipline, CSV batch import, chart data-feed forms (a/b/c), the 5-gate Delivery cycle, cache-drift guidance, Known Issues (the cross-sheet `!` trap, batch + resident for formulas, renderer caveats) — is inherited, not re-taught. This file adds only what a financial model requires on top: three-zone architecture, 3 model-type recipes (3-statement / DCF / LBO), sensitivity + scenario protocols, financial-function patterns, circular-reference discipline, and model-specific Delivery Gates 4–6.
4
5	When the xlsx base rules cover it, the text here says `→ see xlsx v2 §X`. Read `skills/officecli-xlsx/SKILL.md` first if you have not.
6
7	## Setup
8
9	If `officecli` is missing:
10
11	- macOS / Linux: `curl -fsSL https://d.officecli.ai/install.sh \| bash`
12	- Windows (PowerShell): `irm https://d.officecli.ai/install.ps1 \| iex`
13
14	Verify with `officecli --version` (open a new terminal if PATH hasn't picked up). If install fails, download a binary from https://github.com/iOfficeAI/OfficeCLI/releases.
15
16	## Help-First Rule
17
18	This skill teaches what a financial model requires, not every CLI flag. When a prop name / alias / enum is uncertain, consult help BEFORE guessing: `officecli help xlsx [element] [--json]`. Help is authoritative for the installed version — when this skill and help disagree, help wins. Every `--prop X=` below was verified against `officecli help xlsx <element>`.
19
20	## Mental Model & Inheritance
21
22	Inherits xlsx v2. Read `skills/officecli-xlsx/SKILL.md` first. This skill assumes you know `create` / `open` / `close`, `set` values/formulas, `batch` heredocs for cross-sheet formulas, `/SheetName/A1` paths, named ranges, the 5-gate Delivery cycle, the cross-sheet `!` trap, and that cross-sheet formulas go non-resident (single batch OR individual `set`), never batch-while-resident.
23
24	## Shell & Execution Discipline
25
26	Shell quoting, incremental execution, `$FILE` convention → see xlsx v2 §Shell & Execution Discipline. Same rules: quote every `[N]` path, single-quote any prop containing `$` (every number format here — `$#,##0;($#,##0);"-"` — needs single quotes), no hand-written `\$`/`\t`/`\n`, one command at a time. Examples below use `$FILE` (`FILE="model.xlsx"`).
27
28	## Core Principles (identity)
29
30	A financial model is an xlsx with a decision-grade, formula-driven layer: every output traces an unbroken chain to blue-font assumptions, every statement balances every period, every valuation is re-auditable. Eight deltas on top of a general xlsx:
31
32	1. Three-zone architecture mandatory: Inputs → Calc → Outputs. Collapsing zones → unauditable.
33	2. Assumptions live in cells, never inside formulas. `=B5(1+Assumptions!GrowthRate)`, never `=B51.05`.
34	3. Statements balance every period. `Assets − Liab − Equity = 0`, `CF.EndingCash = BS.Cash`. Gate 4 fails on `IMBALANCED`.
35	4. Hardcodes audited. Calc sheets carry zero hardcoded numbers; Gate 6 counts.
36	5. Sensitivity / scenario is first-class. 2-axis grid, dropdown `INDEX/MATCH` switch, or Base/Upside/Downside cols. Excel Data Tables not reliably supported — manual grids only.
37	6. Cached values on valuation cells load-bearing. A valuation cell that ships with no cached result (or the `#OCLI_NOTEVAL!` sentinel) sends a blank/wrong number to non-recalculating readers. The evaluator now computes NPV / XNPV / IRR / XIRR; verify the cached value with a readback. Gate 5 spot-checks.
38	7. Circularity is a design choice. Legitimate rings (interest ↔ cash, revolver plug ↔ ending cash) use `calc.iterate=true`. Accidental circularity is broken algebra — never papered with `iterate`.
39	8. Named ranges for ≥ 3-use assumptions. `WACC`, `TaxRate`, `TerminalGrowth`, `ExitMultiple`, `ChurnRate`. Dec

People who liked this also viewed

6 picks

Type

officecli-financial-model

21installs1.4kforks

View on GitHub

How to install officecli-financial-model?

iofficeai/officecli/officecli-financial-model

$npx -y skills add iOfficeAI/OfficeCLI --skill officecli-financial-model

Installs into the current project.

Summary

Files · 1

View on GitHub

SKILL.md

1	# OfficeCLI Financial-Model Skill
2
3	This skill is a scene layer on top of `officecli-xlsx`. Every xlsx hard rule — shell quoting, incremental execution, Help-First Rule, visual delivery floor, CFO 4-color code (blue input / black formula / green cross-sheet / yellow-fill assumption), number-format standards (years as text, zero as `-`, `%` one decimal, negatives in parens), assumption-cell discipline, CSV batch import, chart data-feed forms (a/b/c), the 5-gate Delivery cycle, cache-drift guidance, Known Issues (the cross-sheet `!` trap, batch + resident for formulas, renderer caveats) — is inherited, not re-taught. This file adds only what a financial model requires on top: three-zone architecture, 3 model-type recipes (3-statement / DCF / LBO), sensitivity + scenario protocols, financial-function patterns, circular-reference discipline, and model-specific Delivery Gates 4–6.
4
5	When the xlsx base rules cover it, the text here says `→ see xlsx v2 §X`. Read `skills/officecli-xlsx/SKILL.md` first if you have not.
6
7	## Setup
8
9	If `officecli` is missing:
10
11	- macOS / Linux: `curl -fsSL https://d.officecli.ai/install.sh \| bash`
12	- Windows (PowerShell): `irm https://d.officecli.ai/install.ps1 \| iex`
13
14	Verify with `officecli --version` (open a new terminal if PATH hasn't picked up). If install fails, download a binary from https://github.com/iOfficeAI/OfficeCLI/releases.
15
16	## Help-First Rule
17
18	This skill teaches what a financial model requires, not every CLI flag. When a prop name / alias / enum is uncertain, consult help BEFORE guessing: `officecli help xlsx [element] [--json]`. Help is authoritative for the installed version — when this skill and help disagree, help wins. Every `--prop X=` below was verified against `officecli help xlsx <element>`.
19
20	## Mental Model & Inheritance
21
22	Inherits xlsx v2. Read `skills/officecli-xlsx/SKILL.md` first. This skill assumes you know `create` / `open` / `close`, `set` values/formulas, `batch` heredocs for cross-sheet formulas, `/SheetName/A1` paths, named ranges, the 5-gate Delivery cycle, the cross-sheet `!` trap, and that cross-sheet formulas go non-resident (single batch OR individual `set`), never batch-while-resident.
23
24	## Shell & Execution Discipline
25
26	Shell quoting, incremental execution, `$FILE` convention → see xlsx v2 §Shell & Execution Discipline. Same rules: quote every `[N]` path, single-quote any prop containing `$` (every number format here — `$#,##0;($#,##0);"-"` — needs single quotes), no hand-written `\$`/`\t`/`\n`, one command at a time. Examples below use `$FILE` (`FILE="model.xlsx"`).
27
28	## Core Principles (identity)
29
30	A financial model is an xlsx with a decision-grade, formula-driven layer: every output traces an unbroken chain to blue-font assumptions, every statement balances every period, every valuation is re-auditable. Eight deltas on top of a general xlsx:
31
32	1. Three-zone architecture mandatory: Inputs → Calc → Outputs. Collapsing zones → unauditable.
33	2. Assumptions live in cells, never inside formulas. `=B5(1+Assumptions!GrowthRate)`, never `=B51.05`.
34	3. Statements balance every period. `Assets − Liab − Equity = 0`, `CF.EndingCash = BS.Cash`. Gate 4 fails on `IMBALANCED`.
35	4. Hardcodes audited. Calc sheets carry zero hardcoded numbers; Gate 6 counts.
36	5. Sensitivity / scenario is first-class. 2-axis grid, dropdown `INDEX/MATCH` switch, or Base/Upside/Downside cols. Excel Data Tables not reliably supported — manual grids only.
37	6. Cached values on valuation cells load-bearing. A valuation cell that ships with no cached result (or the `#OCLI_NOTEVAL!` sentinel) sends a blank/wrong number to non-recalculating readers. The evaluator now computes NPV / XNPV / IRR / XIRR; verify the cached value with a readback. Gate 5 spot-checks.
38	7. Circularity is a design choice. Legitimate rings (interest ↔ cash, revolver plug ↔ ending cash) use `calc.iterate=true`. Accidental circularity is broken algebra — never papered with `iterate`.
39	8. Named ranges for ≥ 3-use assumptions. `WACC`, `TaxRate`, `TerminalGrowth`, `ExitMultiple`, `ChurnRate`. Dec

People who liked this also viewed

6 picks

Type