← All toolsFinance & Analysisanalyst_toolsAll editions

CREATE_DCF_MODEL

Generates a Discounted Cash Flow (DCF) valuation model in Excel. Calculates WACC, FCF, Terminal Value, Enterprise Value, and implied Share Price.

Parameters

NameTypeRequiredDescription
output_pathstringyesOutput path for the .xlsx file
company_namestringyes
waccnumberyesWeighted Average Cost of Capital (e.g., 0.10 for 10%)
terminal_growth_ratenumberGordon Growth rate (e.g., 0.025 for 2.5%)
shares_outstandingnumberyes
cash_equivalentsnumberCurrent cash on balance sheet
total_debtnumberCurrent total debt
yearsintegerNumber of projection years (default 5)
projected_fcfarrayyesList of projected Free Cash Flows for each year

How to use it

You normally trigger this by describing what you want in chat — the agent selects CREATE_DCF_MODEL automatically. For example:

Try saying
“create a analyst tools document”

In a workflow

As a step in a multi-step workflow DAG:

json
{
  "id": "s1",
  "agent": "analyst_tools",
  "action": "CREATE_DCF_MODEL",
  "args": {
    "output_path": "/Users/me/Documents/file.txt",
    "company_name": "…",
    "wacc": 1,
    "shares_outstanding": 1,
    "projected_fcf": []
  },
  "depends_on": [],
  "outputs": []
}

Direct call

For scripting, call it directly via POST /execute_tool. Every tool returns { success, message, data }.

bash
curl -X POST http://127.0.0.1:8000/execute_tool \
  -H "Content-Type: application/json" \
  -d '{"tool_name":"CREATE_DCF_MODEL","args":{"output_path":"/Users/me/Documents/file.txt","company_name":"…","wacc":1,"shares_outstanding":1,"projected_fcf":[]}}'

Part of the analyst_tools plugin. Browse the full Plugin & Tool Catalog or the relevant feature guide.