3-statement-model

Create integrated Excel financial models with linked schedules and formula-driven calculations.

Updated May 20, 2026
One-click install
npx skills add https://github.com/SriRamkunamsetty/SITA2.0-HermesAgent --skill 3-statement-model-sriramkunamsetty
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: 3-statement-model
Source: https://github.com/SriRamkunamsetty/SITA2.0-HermesAgent/tree/main/hermes-agent/optional-skills/finance/3-statement-model
Command: npx skills add https://github.com/SriRamkunamsetty/SITA2.0-HermesAgent --skill 3-statement-model-sriramkunamsetty

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Automates the creation of fully-integrated Income Statement, Balance Sheet, and Cash Flow models in Excel with linked schedules, reducing manual errors and speeding up finance workflow.

Core Features & Use Cases

  • Integrated IS/BS/CF: End-to-end modeling with working capital schedules, D&A roll-forwards, debt schedules, and Retained Earnings linkage.
  • Formula-driven design: Enforces a no-hard-codes rule so projections auto-update with scenario changes and inputs.
  • NOL and tax planning support: Includes NOL schedule and DTA linkage to reflect tax implications and cash effects.
  • Scenario-ready framework: Supports multiple scenarios (Base/Upside/Downside) with consistent linkages across statements and schedules.
  • Excel-author compatible workflow: Tailored for headless OpenPyXL environments, enabling automated model generation and validation.

Quick Start

Open the template, map historical data, and begin populating inputs according to the golden rules to validate formulas and linkages.

Frequently Asked Questions about 3-statement-model

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

FAQPage Schema
How do I build an integrated 3-statement financial model in Excel with linked schedules?

To build an integrated 3-statement financial model, link the Income Statement, Balance Sheet, and Cash Flow statements using formula-driven working capital, D&A roll-forwards, and debt schedules to ensure projections auto-update without hard-coded values.

What is the best way to automate Excel financial modeling with NOL and DTA schedules?

Automating Excel financial modeling with NOL and DTA schedules requires headless OpenPyXL conventions to enforce formula-driven calculations, maintaining cross-statement consistency between tax implications and cash flow effects.

Can I use OpenPyXL to generate scenario-ready three-statement models for corporate finance?

Yes, you can use OpenPyXL to generate scenario-ready three-statement models for corporate finance by creating a framework that supports Base, Upside, and Downside scenarios with consistent linkages across all statements and schedules.

How do you link Retained Earnings and equity flows in a 3-statement Excel model?

To link Retained Earnings and equity flows in a 3-statement Excel model, use formula-driven calculations to connect SBC flows and historical mapping directly to the Balance Sheet, ensuring cross-statement consistency.

Does openpyxl support creating financial models with no hard-coded values?

OpenPyXL supports creating financial models with no hard-coded values by enforcing formula-driven calculations, enabling automated generation where projections dynamically update with scenario changes and historical inputs.