Zum Inhalt springen
Kitbay
Skill

dcf-model

Apache-2.0Aktualisiert am 28. Okt. 202641.222GitHub-SterneEnthält Skripte

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

Was der Skill vermittelt

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.

Funktionen

  • 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