Cash Runway: Time until cash runs out at current burn rate.
Formula
Runway = Current cash / Monthly burn rateComputable definition
The canonical formula in the GASP formula grammar. The MCP server compiles it to SQL over the datasets listed below.
sum(field.cash_balance) at period_end / metric.burn_rateUnit: months
Data requirements
Grain: End-of-month snapshot · Frequency: Monthly · Aggregation: snapshot (month) · Staged: no · Main source: Finance / ERP.
| Field | Dataset | Type |
|---|---|---|
cash_balance | balance_sheet | decimal |
snapshot_date | balance_sheet | date |
Example SQL (Postgres)
SELECT (CAST((SELECT COALESCE(SUM(cash_balance), 0) FROM balance_sheet WHERE snapshot_date = :period_end) AS DOUBLE PRECISION) / NULLIF(((CAST(((SELECT COALESCE(SUM(cash_balance), 0) FROM balance_sheet WHERE snapshot_date = :period_start) - (SELECT COALESCE(SUM(cash_balance), 0) FROM balance_sheet WHERE snapshot_date = :period_end)) AS DOUBLE PRECISION) / NULLIF((CAST((:period_end - :period_start + 1) AS DOUBLE PRECISION) / 30.4375), 0))), 0)) AS cash_runway From an agent: with the GASP MCP server, call
lookup_metric({ "name": "Cash Runway" }) or generate_query({ "metric": "Cash Runway", "adapter": "<your adapter JSON>" }).