skills.rest
gaogg521
gaogg521COMMUNITY
Explore all skills by this author →
GitHub

officecli-financial-model

Automate Excel financial modeling from business assumptions into linked statements.

33|6|Updated Apr 8, 2026
Search Tags:#dashboard#excel#financial-modeling#dcf#scenario-analysis#3-statement
One-click install
npx skills add https://github.com/gaogg521/1ONE-ClaudeCode --skill officecli-financial-model-gaogg521
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: officecli-financial-model
Source: https://github.com/gaogg521/1ONE-ClaudeCode/tree/main/src/process/resources/skills/officecli-financial-model
Command: npx skills add https://github.com/gaogg521/1ONE-ClaudeCode --skill officecli-financial-model-gaogg521

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Building robust, Excel-based financial models usually requires manual setup of inputs, risky cross-sheet formulas, and scattered outputs. This skill centralizes assumptions, automates the creation of a fully interconnected 3-statement model (Income Statement, Balance Sheet, Cash Flow), and provides valuation, scenario analysis, and dashboards to accelerate decision making.

Core Features & Use Cases

  • Automated, formula-driven 3-statement model with cross-sheet references and error checks.
  • Valuation support (DCF), cap table handling, scenario analysis, and sensitivity grids, all output from a single model.
  • Dashboard-ready outputs and built-in validation to ensure consistency, traceability, and auditability for finance teams and startups.

Quick Start

Create a new financial model by providing your business assumptions, and the skill will output a fully linked Excel workbook with 3-statement IS/BS/CF, optional valuation, and a 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 from business assumptions?▼

You can build a 3-statement financial model by inputting business assumptions, which automates generation of interconnected Income Statement, Balance Sheet, and Cash Flow statements with cross-sheet formulas, named ranges, and validation checks.

What is the best way to automate DCF valuation and scenario analysis in Excel?▼

Automating DCF valuation and scenario analysis in Excel is best achieved using an assumptions-first architecture that outputs formula-driven valuation sheets, sensitivity grids, and dashboards from a single interconnected model.

Can I generate a financial dashboard and cap table for a startup in Excel?▼

Yes, you can generate a financial dashboard and cap table for a startup in Excel by inputting business assumptions to produce a fully linked workbook featuring valuation support, scenario analysis, and dashboard-ready outputs.

Does this financial modeling approach support sensitivity analysis and built-in validation?▼

This financial modeling approach supports sensitivity analysis and built-in validation by utilizing formula-driven sheets with named ranges and error checks to ensure consistency, traceability, and auditability across the generated workbook.

How do centralized assumptions improve formula-driven financial modeling?▼

Centralized assumptions improve formula-driven financial modeling by replacing risky cross-sheet formulas and scattered outputs with an automated, interconnected architecture that ensures traceability and accelerates decision making.

Related Skills

Explore More Finance & Accounting Skills→
rezosndrezosnd

excel-generator

Generate styled Excel workbooks with formulas, charts, and data validation.

Community
Intermediate
MicroTools-HubMicroTools-Hub

officecli-financial-model

Generate formula-driven multi-sheet Excel financial models from assumptions.

Community
Advanced
2nth-ai2nth-ai
1

Management Accounts

Generate monthly income statements, balance sheets, and cash flow statements from accounting data.

Official
Intermediate
InverterNetworkInverterNetwork

dcf-model

Generate Excel DCF valuation models with WACC and sensitivity analysis.

Official
Advanced