本文へスキップ
Kitbay
スキル

3-statement-model

Apache-2.02026年10月28日 更新41,222GitHubスタースクリプトあり

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.

スキルの内容

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.

できること

  • 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