本文へスキップ
Kitbay
スキル

dcf-model

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

A skill from Anthropic's financial services plugins for building a discounted cash flow valuation of a company in Excel.

スキルの内容

A skill from Anthropic's financial services plugins for building a discounted cash flow valuation of a company in Excel. It gathers data from a financial data MCP server, the user or a web search, with SEC filings as a fallback, and checks it before projecting revenue, operating costs and free cash flow, building a cost of capital sheet, discounting with a mid-year convention and adding a terminal value and the bridge from enterprise to equity value. The model has bear, base and bull cases, three five-by-five sensitivity tables made of real formulas, source comments on every input and fixed colour rules. It works in live Excel through Office JS or on a file with openpyxl and a recalculation script, pausing for the user to confirm each stage.

できること

  • Project revenue, costs and free cash flow
  • Build a cost of capital sheet
  • Add bear, base and bull scenarios
  • Create sensitivity tables with live formulas