3-statement-model - Build integrated three-statement financial models
Build and populate Excel models linking the income statement, balance sheet, and cash flow statement with supporting schedules and integrity checks.
Tags
Updated: 2026-10-15Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Build integrated financial models
- Populate historical financials
- Project income statements
- Build balance sheet schedules
- Build cash flow statements
- Create working capital schedules
- Roll forward D&A
- Build debt schedules
- Link statement formulas
- Validate balance sheet ties
- Validate cash flow ties
- Format model workbooks
- Recalculate Excel workbooks
Inputs
- Excel model template
- Historical financial data
- Assumption drivers
- Scenario selection
- SEC filing data
Outputs
- Completed .xlsx model
- Formula-linked statements
- Supporting schedules
- Balance checks
- Cash tie-out checks
- User review messages
Requirements
- Headless openpyxl environment
- excel-author conventions
- Excel formula support
- Workbook recalculation script