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.