3-statement-model

Generate linked IS/BS/CF templates with D&A, working-capital, and debt schedules.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill provides a headless financial-modeling workflow that creates fully linked income statement, balance sheet, and cash flow templates with schedules for D&A, working capital, and debt, enabling scalable forecasting and scenario planning.

Core Features & Use Cases

  • Integrated Template: IS/BS/CF linkage with D&A, working capital, and debt schedules.
  • Formula-Driven Projections: All forecast cells use formulas instead of hard-coded values to preserve scenario sensitivity.
  • Use Case: Finance teams can convert historical data into a repeatable five-year forecast and stress test Base/Upside/Downside scenarios while validating balance sheet integrity.

Quick Start

Load the 3-statement-model template, enter historical data, and begin adjusting assumptions to generate projections.

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 model in Excel with linked schedules?

To build an integrated 3-statement model in Excel, you need templates that link the income statement, balance sheet, and cash flow statement with supporting D&A, working capital, and debt schedules. This approach automates linkage to ensure formula integrity across projections.

Can I generate Excel financial models with openpyxl without using hardcoded values?

Yes, you can generate Excel financial models with openpyxl using formula-driven inputs instead of hardcoded values. This headless execution method preserves scenario sensitivity and ensures that all forecast cells dynamically update when assumptions change.

What is the best way to stress test forecast scenarios in a corporate finance model?

The best way to stress test forecast scenarios in corporate finance modeling is using scenario toggles within an integrated 3-statement template. This allows you to compare Base, Upside, and Downside cases while running validation checks on balance sheet integrity.

How does a 3-statement model handle working capital and debt schedules for startup FP&A?

A 3-statement model handles working capital and debt schedules for startup FP&A by integrating them directly into the core financial statements. This maps historical data into a five-year forecast, linking cash flows and balance sheet balances automatically through formulas.

Does headless Excel modeling support validation checks for five-year projections?

Headless Excel modeling supports validation checks for five-year projections by verifying formula integrity across linked IS, BS, and CF statements. This ensures that balance sheets balance correctly and scenario toggles function properly without manual intervention.

Why use formula-driven inputs instead of hardcoded values for financial forecasting in Excel?

Formula-driven inputs are used instead of hardcoded values for financial forecasting to preserve scenario sensitivity across a five-year projection. This ensures that adjusting core assumptions automatically updates linked D&A, working capital, and debt schedules correctly.