← All toolsFinance & Analysisanalyst_toolsAll editions

CREATE_THREE_STATEMENT_MODEL

Builds a dynamically linked 3-Statement Financial Model (Income Statement, Balance Sheet, Cash Flow Statement) in Excel based on historical data and growth assumptions.

Parameters

NameTypeRequiredDescription
input_pathstringyesAbsolute path to the historical financials CSV/Excel file.
output_pathstringyesAbsolute path to save the generated Excel (.xlsx) model.
revenue_growth_ratenumberyesAssumed Go-Forward annual revenue growth rate (e.g. 0.10 for 10%).
ebitda_marginnumberyesAssumed Go-Forward EBITDA margin (e.g. 0.25 for 25%).

How to use it

You normally trigger this by describing what you want in chat — the agent selects CREATE_THREE_STATEMENT_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_THREE_STATEMENT_MODEL",
  "args": {
    "input_path": "/Users/me/Documents/file.txt",
    "output_path": "/Users/me/Documents/file.txt",
    "revenue_growth_rate": 1,
    "ebitda_margin": 1
  },
  "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_THREE_STATEMENT_MODEL","args":{"input_path":"/Users/me/Documents/file.txt","output_path":"/Users/me/Documents/file.txt","revenue_growth_rate":1,"ebitda_margin":1}}'

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