officecli-financial-model

Generate Excel financial models with interconnected statements from an Assumptions sheet.

Updated Apr 14, 2026
One-click install
npx skills add https://github.com/gerald-ica/opencode-config-snapshot --skill officecli-financial-model-gerald-ica
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: officecli-financial-model
Source: https://github.com/gerald-ica/opencode-config-snapshot/tree/main/opencode/skills/officecli-financial-model
Command: npx skills add https://github.com/gerald-ica/opencode-config-snapshot --skill officecli-financial-model-gerald-ica

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Automate the creation of end-to-end Excel financial models from a centralized set of assumptions, generating a fully linked 4- to 10-sheet workbook.

Core Features & Use Cases

  • 3-statement model (Income Statement, Balance Sheet, Cash Flow) driven entirely by formulas referencing a single Assumptions sheet.
  • DCF valuation, cap table, scenario analysis, and forecasting with built-in checks and dashboards.
  • Use case: a founder wants a ready-to-run model to project revenue, expenses, and cash flow for a fundraising process.

Quick Start

Provide a concise set of assumptions and trigger the model generation to produce a ready-to-use Excel workbook.

Frequently Asked Questions about officecli-financial-model

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create a 3-statement financial model in Excel from assumptions?▼

You can create a 3-statement financial model in Excel by providing a centralized Assumptions sheet, which automates the generation of interconnected Income Statement, Balance Sheet, and Cash Flow sheets driven entirely by formulas.

What is the best way to build a DCF valuation and cap table in Excel?▼

The best way to build a DCF valuation and cap table in Excel is to use automated model generation that creates optional valuation sheets directly from your core financial assumptions and projections.

Can I run scenario analysis and multi-year projections in a single Excel workbook?▼

Yes, you can run scenario analysis and multi-year projections in a single Excel workbook by generating a fully linked 4- to 10-sheet file with built-in checks and dashboards from your input assumptions.

Does this financial modeling approach require a specific Excel template to start?▼

This financial modeling approach requires an Assumptions sheet as input, serving as the single source of truth that drives the formulas across all generated statement and valuation sheets.

How do I automate end-to-end financial modeling for a fundraising process?▼

You automate end-to-end financial modeling for fundraising by triggering model generation from a concise set of assumptions, producing a ready-to-run Excel workbook projecting revenue, expenses, and cash flow.

What are the limitations of generating financial models from assumptions in Excel?▼

A key limitation of generating financial models from assumptions in Excel is that the entire multi-sheet workbook depends on the accuracy of the initial Assumptions sheet, requiring correct formula linking across all generated statements.