3-statement-model - Build integrated three-statement Excel models
Completes Excel templates with linked income statement, balance sheet, cash flow statement, and supporting financial schedules.
Tags
Updated: 2026-10-15Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Map template tabs and sections
- Populate historical financials
- Build income statement projections
- Build balance sheet schedules
- Build cash flow statement
- Link working capital schedules
- Build D&A roll-forwards
- Build debt schedules
- Add scenario toggles
- Run balance and cash checks
- Recalculate Excel workbooks
- Verify models step by step
Inputs
- Excel model template
- Historical financial data
- Assumption drivers
- Scenario selections
- SEC filing data
Outputs
- Completed .xlsx workbook
- Linked financial statements
- Supporting financial schedules
- Balance checks
- Cash tie-out checks
- Scenario analysis outputs
Requirements
- Headless openpyxl environment
- Write access to output path
- Python recalculation script
- excel-author conventions