3-statement-model - Complete integrated three-statement financial models
Populate three-statement model templates with historical data, formula-driven projections, statement linkages, checks, and optional scenario or metric analysis.
Tags
Updated: 2026-10-08Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Review template tabs
- Map model structure
- Populate historical actuals
- Build formula-driven projections
- Link financial statements
- Apply model formatting
- Validate balance checks
- Validate cash tie-outs
- Build scenario toggles
- Calculate optional margins
- Calculate credit metrics
- Extract SEC filing data
Inputs
- Financial model template
- Historical financial data
- Projection assumptions
- Scenario assumptions
- SEC filings
Outputs
- Populated Excel model
- Linked financial statements
- Formula-driven projections
- Formatted model cells
- Balance check results
- Cash tie-out results
- Margin metrics
- Credit metrics
- Scenario analysis results
Requirements
- Excel or Office JS environment
- Python and openpyxl for standalone XLSX files
- Excel formula recalculation for generated files
- Workbook write permissions