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
| Name | Type | Required | Description |
|---|---|---|---|
output_path | string | yes | Output path for the .xlsx file |
company_name | string | yes | — |
wacc | number | yes | Weighted Average Cost of Capital (e.g., 0.10 for 10%) |
terminal_growth_rate | number | — | Gordon Growth rate (e.g., 0.025 for 2.5%) |
shares_outstanding | number | yes | — |
cash_equivalents | number | — | Current cash on balance sheet |
total_debt | number | — | Current total debt |
years | integer | — | Number of projection years (default 5) |
projected_fcf | array | yes | List 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.