skills.rest
ruiyangruiyi
ruiyangruiyiCOMMUNITY
Explore all skills by this author →
GitHub

3-statement-model

Complete integrated Excel 3-statement financial models with formula-based linkages.

Updated May 26, 2026
Search Tags:#financial modeling#openpyxl#excel#working capital#3-statement model#depreciation schedule#cash flow tie-out
One-click install
npx skills add https://github.com/ruiyangruiyi/hermes-agent --skill 3-statement-model-ruiyangruiyi
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: 3-statement-model
Source: https://github.com/ruiyangruiyi/hermes-agent/tree/main/optional-skills/finance/3-statement-model
Command: npx skills add https://github.com/ruiyangruiyi/hermes-agent --skill 3-statement-model-ruiyangruiyi

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill completes and links integrated 3-statement financial models (Income Statement, Balance Sheet, and Cash Flow) so that cash, retained earnings, and roll-forwards reconcile correctly across projection periods.

Core Features & Use Cases

  • Fully integrated 3-statement completion: Populate IS, BS, and CF with working-capital schedules, D&A roll-forwards, debt schedules, and the formula “plugs” that ensure ties between statements.
  • Formula integrity guardrails: Enforces the rule that projection logic must be written as Excel formulas (no hardcoded computed outputs) to preserve scenario toggle behavior.
  • Stepwise validation workflow: Prompts for user confirmation after mapping the template, after historicals, after each statement (IS → BS → CF), and before finalizing to catch errors early.
  • Optional analytical sections: Supports margin analysis, credit metrics, scenario analysis (Base/Upside/Downside), and (when applicable) SEC filing-driven data extraction.

Quick Start

Use the 3-statement-model skill to complete the linked IS, BS, and CF sections of an Excel template by having it populate the model using only cell formulas and reconcile the cash and retained earnings tie-outs.

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 statements?▼

To build an integrated 3-statement financial model in Excel, you link the Income Statement, Balance Sheet, and Cash Flow using schedules and reconciliation plugs to ensure cash and retained earnings roll-forwards tie out correctly across projection periods.

What is the best way to tie out cash flow and balance sheet balances in financial modeling?▼

The best way to tie out cash flow and balance sheet balances in financial modeling is by using formula-based reconciliation plugs for retained earnings roll-forwards and cash tie-outs, ensuring projection logic remains dynamic for scenario toggles.

Can I automate working capital and depreciation schedules for a 3-statement model?▼

Yes, you can automate working capital and depreciation schedules for a 3-statement model by integrating D&A roll-forwards and debt schedules directly into the Excel projection formulas to maintain statement balance and integrity checks.

Does financial modeling with openpyxl support dynamic scenario toggles and formula-based outputs?▼

Financial modeling with openpyxl supports dynamic scenario toggles by enforcing that projection logic is written strictly as Excel formulas, preventing hardcoded computed outputs and preserving scenario toggle behavior across Base, Upside, and Downside cases.

How do I validate a 3-statement model step by step to catch Excel integration errors early?▼

To validate a 3-statement model step by step, you prompt for user confirmation after mapping the template, entering historicals, completing each statement sequentially (IS, BS, CF), and finalizing to catch balance sheet and cash flow integration errors early.

Related Skills

Explore More Finance & Accounting Skills→
mouseqiao85mouseqiao85
1

3-statement-model

Populate 3-statement financial model templates with Excel formulas and SEC filing data.

Community
Advanced
r9412460971-cloudr9412460971-cloud
31

3-statement-model

Populate pre-built 3-statement financial model templates with cross-statement linkages.

Community
Advanced
open-nekoopen-neko
11

3-statement-model

Automate creation of integrated 3-statement financial models with Excel formulas.

Official
Advanced
davpatel605-beepdavpatel605-beep

3-statement-model

Build integrated three-statement financial models with linked Excel formulas and validation checks.

Community
Advanced