three-statement-model-builder

Generate integrated three-statement operating model workbooks from plan.json files.

8|12|Updated Sep 19, 2025
One-click install
npx skills add https://github.com/xpert-ai/xpert-plugins --skill three-statement-model-builder-xpert-ai
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: three-statement-model-builder
Source: https://github.com/xpert-ai/xpert-plugins/tree/main/community/roles/financial-markets/skills/three-statement-model-builder
Command: npx skills add https://github.com/xpert-ai/xpert-plugins --skill three-statement-model-builder-xpert-ai

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

Manually building public company three-statement operating models is time-consuming, error-prone, and often fails to meet the rigorous tie-out, source provenance, and senior review standards required for investment decisions, leading to unreliable forecasts and wasted diligence time.

Core Features & Use Cases

  • Formula-First Workflow: Generates live-formula banker-style workbooks with full integrated income statement, balance sheet, and cash flow linkage, plus working capital, PP&E, debt, cash sweep, and scenario modeling.
  • Built-In QA & Provenance: Includes mechanical tie-out checks, source-to-cell citation ledgers, and senior review standards to ensure model reliability for public equity investment use cases.
  • Use Case: For a public industrials company, use this skill to build a decision-ready operating model from a normalized plan.json, complete with base/downside/upside scenarios and audit artifacts for portfolio manager review.

Quick Start

Use the three-statement-model-builder skill to generate a decision-ready public-equity operating model workbook from your provided plan.json file, including full financial statement integration, scenario analysis, and QA checks.

Frequently Asked Questions about three-statement-model-builder

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

FAQPage Schema
How do I build a public-equity three-statement operating model with integrated financials?

This skill builds a three-statement operating model by generating a live-formula workbook with full income statement, balance sheet, and cash flow linkage. It integrates working capital, PP&E, debt schedules, and cash sweeps for public-equity forecasting.

What is source-to-cell provenance in financial forecasting models?

Source-to-cell provenance in financial forecasting tracks the origin of every data point entered into the workbook. This skill generates citation ledgers and mechanical tie-out checks to ensure model reliability for senior investment committee review.

Can I generate scenario analysis for a public industrials company forecast?

Yes, you can generate scenario analysis for a public industrials company forecast using this skill. It creates base, downside, and upside scenarios from a normalized plan.json file, outputting decision-ready operating models for portfolio manager review.

Do I need a plan.json file to start building a three-statement model?

Yes, you need a normalized plan.json file to start building a three-statement model with this skill. The plan.json provides the baseline data required to generate integrated financial statements, scenario analysis, and audit artifacts.

What is the best way to ensure QA checks pass on an integrated financial model?

The best way to ensure QA checks pass on an integrated financial model is using a formula-first workflow with built-in mechanical tie-outs. This skill automatically applies senior review standards and source provenance to prevent manual forecasting errors.

Why does my manually built operating model fail investment committee review?

Manually built operating models often fail investment committee review due to lacking mechanical tie-outs and source provenance. This skill resolves the issue by generating auditable, decision-ready workbooks that meet senior finance and investment standards.