3-statement-model

Build integrated 3-statement financial models in Excel with openpyxl formulas and validation checks.

Updated Jun 7, 2026
One-click install
npx skills add https://github.com/Chensihakniroth/ANAKOT-AGENT --skill 3-statement-model-chensihakniroth
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: 3-statement-model
Source: https://github.com/Chensihakniroth/ANAKOT-AGENT/tree/main/optional-skills/finance/3-statement-model
Command: npx skills add https://github.com/Chensihakniroth/ANAKOT-AGENT --skill 3-statement-model-chensihakniroth

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve? Building a fully-linked Income Statement, Balance Sheet, and Cash Flow model in Excel is error-prone: hardcoded values break when assumptions change, statements fail to tie, and balance checks silently drift. This Skill produces formula-driven .xlsx models where cash and retained earnings tie out across all three statements. ## Core Features & Use Cases - Formula-First Model Building: Writes Excel formula strings via openpyxl instead of computed values, so the model flexes when scenario toggles or assumption drivers change. - Integrated Schedules: Builds working capital, D&A roll-forward, debt, NOL, and retained earnings schedules that feed the three statements with verified linkages. - Built-In Audit Checks: Includes balance sheet balance, cash tie-out, RE roll-forward, scenario hierarchy, and credit metric threshold checks with a master pass/fail status. - Use Case: Ask the agent to build a 5-year projection model for a company from its 10-K filings; it extracts historicals from SEC EDGAR, populates the Assumptions tab, and delivers a balanced model with a Checks dashboard. ## Quick Start Build a 3-statement model in Excel for this company using the attached historical financials, with base, upside, and downside scenarios.

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 cells rather than computed values, linking the Income Statement, Balance Sheet, and Cash Flow through schedules for working capital, D&A, and debt. Recalculate the workbook before delivery to verify all checks pass.

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

Net Income flows from the IS to the top of CFO and into retained earnings; ending cash from the CF becomes BS cash; D&A, CapEx, and working capital changes link through their supporting schedules. The model balances when Assets minus Liabilities minus Equity equals zero.

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

Common causes are hardcoded projection cells, incorrect working capital sign conventions, or a broken retained earnings roll-forward. Check that CF ending cash equals BS cash and that prior RE plus net income minus dividends equals ending RE.

Can I extract data from SEC 10-K filings for a financial model?▼

Yes, pull three years of historicals from SEC EDGAR 10-K filings, mapping line items from the consolidated statements of operations, balance sheets, and cash flows. Use the notes for debt maturity schedules and PP&E detail, and verify IS net income matches CF starting net income.

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

Interest creates circularity because it affects net income, cash, and debt balance. Enable iterative calculation in Excel options with 100 max iterations, add a circuit breaker toggle in the Assumptions tab, or compute interest on the beginning debt balance.