skills.rest
vivekgoquest
vivekgoquestCOMMUNITY
Explore all skills by this author →
GitHub

3-statement-model

Build integrated income statement, balance sheet, and cash flow workbooks in Excel.

Updated Aug 22, 2026
Search Tags:#financial modeling#Excel#openpyxl#cash flow#balance sheet#SEC filings#three-statement
One-click install
npx skills add https://github.com/vivekgoquest/hermes-agent-stable --skill 3-statement-model-vivekgoquest
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: 3-statement-model
Source: https://github.com/vivekgoquest/hermes-agent-stable/tree/main/optional-skills/finance/3-statement-model
Command: npx skills add https://github.com/vivekgoquest/hermes-agent-stable --skill 3-statement-model-vivekgoquest

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, and includes references (resource) components.

What problem does it solve? Building a three-statement financial model by hand is error-prone: broken cross-statement linkages, hardcoded projections, and unbalanced balance sheets silently corrupt analysis. This Skill produces a fully linked IS/BS/CF Excel workbook with formula-driven projections and built-in integrity checks. ## Core Features & Use Cases - Integrated Statement Construction: Populates Income Statement, Balance Sheet, and Cash Flow tabs with live Excel formulas via openpyxl, never hardcoded projection values. - Validation & Audit Checks: Enforces balance sheet balance, cash tie-out, retained earnings roll-forward, NOL schedule rules, and scenario hierarchy checks with a master pass/fail status. - Scenario & Credit Analysis: Supports Base/Upside/Downside toggles, margin analysis, leverage and coverage metrics, and covenant threshold flagging. - Use Case: An analyst receives a blank model template and three years of 10-K data; the Skill maps the tabs, extracts historicals from SEC filings, builds five-year projections, and delivers a recalculated .xlsx where Assets = Liabilities + Equity in every period. ## Quick Start Use the 3-statement-model skill to build a five-year integrated financial model in Excel from the attached historical financials and assumptions.

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 a 3-statement financial model in Excel with Python?▼

Use openpyxl to write Excel formula strings into projection cells rather than computed values, linking the Income Statement, Balance Sheet, and Cash Flow tabs. Only historical actuals and assumption drivers should be hardcoded; everything else must be a live formula.

How to link income statement, balance sheet, and cash flow statements?▼

Net Income flows from the IS to the top of cash flow from operations, CF ending cash becomes BS cash, and retained earnings rolls forward as prior RE plus net income minus dividends. The model validates with Assets minus Liabilities minus Equity equaling zero every period.

Can I populate a financial model from SEC 10-K filings?▼

Yes, extract three years of historicals from EDGAR filings using the line-item mapping in references/sec-filings.md, covering the income statement, balance sheet, and cash flow statement. Verify IS net income matches CF starting net income and BS cash matches CF ending cash for each year.

Why does my balance sheet not balance in a financial model?▼

Common causes are broken cash tie-outs, incorrect working capital sign conventions, or retained earnings not rolling forward with net income and dividends. Use the checks tab to isolate the failing section, then trace precedents on the source tab.

How do I handle circular references from interest expense in Excel models?▼

Interest creates circularity through net income, cash, and debt balances. Enable iterative calculation in Excel options with 100 maximum iterations and 0.001 maximum change, and add a circuit breaker toggle in the Assumptions tab.

Related Skills

Explore More Finance & Accounting Skills→
nferrer-devnferrer-dev

edgartools

Extract SEC EDGAR filings and financial data using the edgartools library.

Community
Advanced
open-nekoopen-neko
11

lbo-model

Build formula-driven LBO models in Excel with openpyxl.

Official
Advanced
ldzhhxxldzhhxx
1

excel-author

Create Excel workbooks with formulas, named ranges, and balance checks using openpyxl.

Community
Intermediate
MicroTools-HubMicroTools-Hub

officecli-financial-model

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

Community
Advanced