Three-Statement Model Filler
Complete and validate integrated three-statement templates with formulas, linkages, and audit checks.
The evidence shows staged user confirmation, formula-first behavior, preservation of existing formulas, and documentation of original formulas before intentional modification. It does not define sensitive financial-data handling, least-privilege access, authorization for external data access, complete rollback/recovery, or source-traceability procedures, so points are deducted.
The document gives fairly detailed Office JS and Python/openpyxl paths, formula rules, validation checks, and error categories. However, there are no tests or executable reproduction artifacts covering key paths; recalc.py is referenced but not supplied; and some formula, cash-flow, and retained-earnings rules require manual accounting validation. The static ceiling and these uncertainties limit the score.
Triggers, target workflow, and several non-fit conditions are reasonably explicit, including optional margin/credit/SEC analysis and Excel versus standalone xlsx environments. Chinese-language interaction, non-Excel boundaries, and applicability across complex or industry-specific templates are not addressed, so points are deducted.
The skill is layered across principles, template discovery, population, validation, audit, and reference files, with Apache-2.0 licensing and repository CI/maintenance signals. It lacks skill versioning, a changelog, named maintenance responsibility, explicit installation/dependency notes, FAQs, and a systematic troubleshooting path, so points are deducted.
It provides directly usable guidance for three-statement modeling, formulas, formatting, and integrity checks, covering the core task fairly broadly. No actual template output, key-path result, or execution evidence is provided, and template variation, formula defects, and accounting-policy adaptation still require substantial human review. The static ceiling and rework risk limit the score.
Formula references, check formulas, linked reference files, and repository-level plugin validation provide some auditability. The CI workflow validates plugin structure rather than the skill's modeling paths, and there is no independently reproducible result or third-party execution evidence, so only limited credit is justified.
- Do not treat the documented formulas and accounting rules as a validated model implementation; verify formulas, units, sign conventions, tax treatment, and retained-earnings logic in the target template before delivery.
- recalc.py is referenced but not present in the supplied material; recalculation and formula results for standalone xlsx workflows require additional confirmation.
- SEC EDGAR and other external data sources or connectors may introduce network, credential, compliance, and sensitive-data risks; obtain authorization and record provenance before use.
- The skill requires staged user confirmation but does not define concrete handling for refusal, failure recovery, or reversal of already-written cells.
What it does & when to use it
This skill completes existing three-statement financial model templates covering the Income Statement, Balance Sheet, and Cash Flow Statement. It requires historical data and assumption drivers to be hardcoded while projections, subtotals, roll-forwards, and linkages use formulas. The workflow analyzes the template first, then completes historicals, the Income Statement, Balance Sheet, and Cash Flow in stages with user confirmation and validation after each stage. It also covers scenario analysis, margins, credit metrics, and model integrity checks, with some analyses performed only when requested or required by the template.
Reviews workbook tabs, row and column structures, units, period labels, input cells, formulas, named ranges, and cross-sheet dependencies; writes formulas through Office JS in Excel or uses Python/openpyxl to generate a standalone .xlsx file and then runs recalc.py; populates historical data and assumption drivers; builds formula linkages across the Income Statement, Balance Sheet, Cash Flow Statement, and supporting schedules; and performs balance-sheet, cash tie-out, net-income linkage, retained-earnings, scenario-hierarchy, and formula-error checks.
- An investment-banking or financial-analysis professional needs to populate historicals and forecast assumptions in an existing three-statement template.
- A model builder needs to complete partially blank Income Statement, Balance Sheet, and Cash Flow sections without breaking the template layout or existing formulas.
- A finance team needs to verify that forecast formulas reference assumption drivers and that the statements reconcile across tabs.
- An analyst needs to toggle Base, Upside, and Downside scenarios and check whether statements and key metrics remain consistent.
- A user generating an Excel workbook with Python/openpyxl needs projection cells to contain formulas rather than precomputed values.
Pros & cons
- Clearly requires formulas for projections, roll-forwards, subtotals, and cross-statement linkages.
- Supports both Office JS and Python/openpyxl workflows.
- Includes concrete checks for balance-sheet balance, cash tie-out, net-income linkage, and retained earnings.
- Provides a restrained blue/grey formatting scheme plus scenario-analysis and credit-metric guidance.
- It is guidance for completing and auditing templates, not a standalone modeling application.
- No scripts, test suite, or implementation of recalc.py is included in the supplied source.
- SEC-filings extraction depends on references/sec-filings.md, whose contents are not provided.
- Office JS and standalone .xlsx workflows require different runtime environments, and the skill does not document their setup.
How to install
This skill is part of the financial-analysis plugin in the anthropics/financial-services repository. In Cowork, open Settings → Plugins → Add plugin, paste https://github.com/anthropics/financial-services, and select the relevant vertical from the marketplace list. In Claude Code, run claude plugin marketplace add anthropics/financial-services, then claude plugin install financial-analysis@claude-for-financial-services. The source does not document a standalone installation command for this individual skill.
How to use
After installing the collection, submit a request such as: “Complete this three-statement financial model template. First map the tabs and input areas, then populate historicals, the Income Statement, Balance Sheet, and Cash Flow step by step.” Provide the template and data source, and follow the required confirmation points after each stage. The skill is designed for staged completion rather than unconfirmed end-to-end population.