3-statement-model - Build an integrated three-statement Excel model
Build formula-driven integrated income statement, balance sheet, and cash flow models with supporting schedules and tie-out checks.
Tags
Updated: 2026-10-12Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Build integrated financial statements
- Populate historical actuals
- Create working capital schedules
- Build D&A roll-forwards
- Build debt schedules
- Link statements with formulas
- Add scenario toggles
- Validate balance and cash tie-outs
- Recalculate Excel workbooks
Inputs
- Excel model template
- Historical financial data
- Assumption drivers
- Scenario parameters
- SEC filings
Outputs
- Completed Excel workbook
- Integrated statement formulas
- Balance and cash tie-out checks
- Stepwise review confirmations
Requirements
- Python environment
- Headless openpyxl
- excel-author conventions
- Workbook recalculation support
- Output file write access