Calculate Financial Ratios
AI-generatedSummary
Calculate selected financial ratios from a single aggregated financial data object, using an allowlisted set of predefined ratio formulas with optional customization of burn rate source, currency, and percentage format inclusion.
Inputs
- burnRateSource — Selects source data for burn rate and runway calculations. Options are 'auto' (default, uses cashOutflows if available, otherwise monthlyExpenses), 'cashOutflows', or 'monthlyExpenses'.
- currency — Optional ISO currency code override. If left empty, the node uses the currency field present in the input data.
- includePercentages — Boolean flag (default true) to include margin, return, growth, and operating expense ratios also as formatted percentage strings in output.
- ratios — Multi-select list of predefined financial ratios to calculate from the input data. Only allowlisted ratios supported; defaults to all ratios.
Output shape
A single JSON object containing calculated financial ratios keyed by ratio name, each with its value, input fields used, formula, category, unit, and optional percentage representation plus metadata; also includes lists of omitted ratios and calculation summary.
Input must be a single aggregated financial data object with required fields for selected ratios. If required fields are missing or invalid, the affected ratios are omitted with warnings. The node outputs a detailed audit trail, warnings, and errors. Dataset (multi-record) input is unsupported in this version; only one aggregated object is accepted.
Examples
Example 1: Calculating default financial ratios with percentage fields included and automatic currency detection.
Use default parameters: burnRateSource 'auto', no currency override, includePercentages true, calculate all ratios.
Example 2: Calculate only 'current_ratio' and 'debt_to_equity' with specified currency and no percentage fields.
Set 'ratios' to ['current_ratio', 'debt_to_equity'], 'currency' to e.g. 'USD', and 'includePercentages' to false.