excel_add_formula_with_documentation
Insert validated financial formulas into Excel cells with automated documentation for investment analysis, accounting workflows, and financial reporting.
Instructions
Add a financial formula to a cell with complete documentation and validation
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| addDocumentation | No | Add explanation in adjacent cells | |
| cell | Yes | Cell address (e.g., 'A1') | |
| formulaType | Yes | ||
| parameters | Yes | Parameters specific to the formula type | |
| worksheetName | Yes |
Input Schema (JSON Schema)
{
"properties": {
"addDocumentation": {
"default": true,
"description": "Add explanation in adjacent cells",
"type": "boolean"
},
"cell": {
"description": "Cell address (e.g., 'A1')",
"type": "string"
},
"formulaType": {
"enum": [
"npv",
"loan_payment",
"straight_line_depreciation",
"declining_balance_depreciation",
"sum_of_years_depreciation",
"current_ratio",
"quick_ratio",
"cash_ratio",
"roa",
"roe",
"debt_to_equity",
"debt_to_assets",
"cap_rate",
"noi",
"cash_on_cash",
"dscr",
"working_capital",
"gross_margin",
"operating_margin",
"net_margin",
"ebitda",
"free_cash_flow",
"wacc",
"break_even",
"inventory_turnover",
"days_sales_outstanding",
"price_to_earnings",
"interest_coverage"
],
"type": "string"
},
"parameters": {
"description": "Parameters specific to the formula type",
"type": "object"
},
"worksheetName": {
"type": "string"
}
},
"required": [
"worksheetName",
"cell",
"formulaType",
"parameters"
],
"type": "object"
}