Skip to content
Kitbay
Skill

3-statement-model

Apache-2.0Updated on Oct 28, 202641,222GitHub starsIncludes scripts

A skill from Anthropic's financial services plugins for completing an existing three-statement model template in Excel, linking the income statement, balance sheet and cash flow statement.

What the skill teaches

A skill from Anthropic's financial services plugins for completing an existing three-statement model template in Excel, linking the income statement, balance sheet and cash flow statement. It works either inside live Excel through Office JS, writing formulas so Excel calculates them, or on a standalone .xlsx file with openpyxl followed by a recalculation script. Projections, roll-forwards and subtotals must stay formulas, with hardcoded numbers only for historical actuals and assumption drivers. The agent works in stages and asks the user to confirm after mapping the template, the historicals, each statement, the balance check and the cash tie-out. It covers optional margin and credit metrics, scenario toggles, circular interest with a breaker switch, and SEC filings as a data source.

Capabilities

  • Fill income statement, balance sheet and cash flow tabs
  • Keep projections as live Excel formulas
  • Check that the balance sheet balances
  • Add base, upside and downside scenarios