Blog · Finance metrics and formulas · Finance and FP&A teams
Calculate a net liquidity position from unrestricted liquid assets and obligations due within a stated horizon. Reconcile the result by entity and distinguish it from working capital and liquidity ratios.
The net liquidity position formula used here is unrestricted eligible liquid assets minus cash obligations due within the next 30 calendar days. It is a dollar measure of treasury coverage under a stated convention. A positive result means the included assets exceed the included obligations; payment timing and entity access still need separate checks.
Net liquidity position = Eligible unrestricted liquid assets − In-scope cash obligations due within the stated horizon
Eligible unrestricted liquid assets = Reported cash − Restricted cash + Eligible liquid investments
This article uses a company treasury measure, not a universal accounting definition or regulatory formula. The measurement date is September 30, 2026, and the horizon runs from October 1 through October 30, 2026, inclusive. All balances are USD.
The SEC's financial statement guide describes current assets and liabilities using a generally one-year horizon. That is broader than this 30-day cash test. Inventory can be a current asset without being cash available to pay next week's obligations; the separate financial ratios guide covers ratio-based liquidity comparisons.
Write an eligibility note alongside the output. It should say which investments can be converted into available cash within the horizon, which balances are restricted or pledged, whether transaction costs reduce proceeds and which obligations are covered. Keep that note consistent between periods or explain the change.
The treasury asset export needs entity, account or security ID, currency, balance date, reported cash, restricted amount, eligible investment proceeds and expected availability date. Report cash gross and subtract the restricted portion once. If the export already excludes restricted balances, do not subtract them again.
The obligation schedule needs entity, obligation ID, category, outstanding amount, due date, payment currency and a source reference. Bring supplier invoices, payroll and tax schedules, debt principal and interest, lease payments and other committed cash payments within the horizon. An omitted category needs an explicit explanation, not an empty cell interpreted as zero.
For the example below, supplier balances cover the trade invoices due in the horizon. Payroll and taxes include all scheduled employee and tax payments. Debt and lease amounts include all scheduled financing and lease cash payments; the company has no other committed payments in this example. There are no intercompany obligations, currency conversions or overlapping payment IDs.
Receivables collections and future sales are excluded. They may support a separate cash-flow forecast, but they are not liquid assets already available on the measurement date. Undrawn facilities are also disclosed separately rather than added to cash.
A US distributor has two legal entities. Reported cash includes the restricted portion. The eligible investment column is the treasury-approved cash proceeds available within the horizon, after any required deductions; no further valuation adjustment is assumed in this example.
| Entity | Reported cash (USD) | Restricted cash (USD) | Eligible investments (USD) | Eligible liquid assets (USD) |
|---|---|---|---|---|
| East | 480,000 | 60,000 | 120,000 | 540,000 |
| West | 160,000 | 20,000 | 40,000 | 180,000 |
| Total | 640,000 | 80,000 | 160,000 | 720,000 |
East's eligible assets are $480,000 − $60,000 + $120,000 = $540,000. West's are $160,000 − $20,000 + $40,000 = $180,000. All amounts are exact whole dollars, with no rounding.
Now aggregate the due-date-filtered payment rows:
| Entity | Supplier payments (USD) | Payroll and taxes (USD) | Debt and leases (USD) | Total obligations (USD) | Net liquidity position (USD) |
|---|---|---|---|---|---|
| East | 210,000 | 90,000 | 80,000 | 380,000 | 160,000 |
| West | 110,000 | 50,000 | 40,000 | 200,000 | -20,000 |
| Total | 320,000 | 140,000 | 120,000 | 580,000 | 140,000 |
East has $540,000 − $380,000 = $160,000. West has $180,000 − $200,000 = −$20,000. The total position is $720,000 − $580,000 = $140,000, which agrees with $160,000 − $20,000.
That identity proves the arithmetic and aggregation. It does not establish that West can access East's surplus. Record transfer permissions, required approvals and settlement timing before treating the group's cash as available to either entity.
For the asset table above, use columns A:E and place East on row 2. Eligible assets in E2 are:
=B2-C2+D2
For payment detail on an Obligations sheet, use entity in A, due date in B and outstanding payment amount in C. On the summary sheet, put entity in A2, eligible assets in B2, measurement date in H1 and horizon end in H2. Total in-scope obligations in C2 are:
=SUMIFS(Obligations!$C$2:$C$9999,Obligations!$A$2:$A$9999,$A2,Obligations!$B$2:$B$9999,">"&$H$1,Obligations!$B$2:$B$9999,"<"&($H$2+1))
This formula assumes normalized date-only due dates, positive cash payments and no overdue unpaid items at the measurement date. If overdue obligations exist, include them in a separately reconciled immediate-payment bucket; excluding them simply because their due date is earlier would overstate coverage. Extend the ranges to the final source row and compute D2 as =B2-C2.
Sum entity positions and compare them with total eligible assets minus total obligations. Both should equal $140,000 in this example. Then tie reported cash to the reconciled balance sheet, the restriction schedule to its supporting agreements, and payment subtotals to their source schedules.
Ignoring restrictions would give $640,000 + $160,000 − $580,000 = $220,000. The overstatement is exactly the $80,000 restricted-cash total shown above. Restrictions affect the asset pool even when the money appears in the bank balance.
For a sensitivity check, suppose treasury determines that $30,000 of East's eligible investments cannot become available within the horizon. The revised group position is $140,000 − $30,000 = $110,000. No obligation changed; the movement comes entirely from asset availability.
Also inspect daily or weekly timing. A positive horizon-end total can coexist with an earlier payment shortfall. The OCC's Liquidity handbook, written for banks, discusses projected funding sources and needs, asset marketability and multiple time horizons. Those considerations help frame this company review without turning its calculation into a bank regulatory measure.
Bring the treasury asset file, restriction schedule and obligation detail to Covirage; its tools compute the position under your stated scope and check the entity totals. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own schedules; see Covirage for finance teams for the supporting reporting context.
No single formula fits every treasury policy or regulatory context. State the convention used, including the time horizon, eligible assets, restrictions and obligations. A company cash-availability calculation should not be presented as a bank regulatory liquidity ratio or a substitute for one.
Under the convention used here, undrawn facilities are excluded from liquid assets because they are not cash already held. Report approved available borrowing separately, with conditions and availability dates. If management chooses an expanded measure that includes facilities, label it clearly and reconcile the addition.
Yes. Cash may sit in one entity while obligations fall due in another. Analyze each entity before aggregating and document whether transfers are permitted and timely. A group surplus alone does not establish that every company can meet its own payments.
No. Working capital generally subtracts current liabilities from current assets, which can include inventory and receivables. This net liquidity convention uses a narrower pool of available liquid assets and a specifically defined payment horizon, so the amounts answer different questions.