cash-liquidity-forecast

Builds 13-week direct cash forecasts with liquidity headroom and scenario analysis.

Updated Jun 21, 2026
One-click install
npx skills add https://github.com/lwokeray/cowork-plugins --skill cash-liquidity-forecast-lwokeray
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: cash-liquidity-forecast
Source: https://github.com/lwokeray/cowork-plugins/tree/main/plugins/finance-cowork/skills/cash-liquidity-forecast
Command: npx skills add https://github.com/lwokeray/cowork-plugins --skill cash-liquidity-forecast-lwokeray

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Treasury and finance teams need a reliable short-term view of cash to avoid minimum-cash breaches, but forecasts built from rough P&L percentages miss timing and hide risk. This Skill builds a traceable direct cash forecast linking every inflow and outflow to AR aging, AP due dates, payroll, tax, debt, and capex sources. ## Core Features & Use Cases - Direct Cash Roll-Forward: Constructs weekly beginning-to-ending cash bridges separating committed, scheduled, forecast, and contingent flows across entities, banks, and currencies. - Scenario & Risk Analysis: Produces Base, Downside, and Action cases showing first breach week, peak funding need, facility headroom, and covenant status. - Forecast Accuracy Tracking: Compares forecast versus actual by category to surface bias, timing shifts, and recurring misses. - Use Case: Ask what happens if your top five customers pay two weeks late, and receive the exact week cash falls below minimum, the peak funding need, and decision deadlines for mitigation actions. ## Quick Start Build a 13-week cash forecast and identify any week where available cash falls below the minimum cash requirement.

Frequently Asked Questions about cash-liquidity-forecast

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I build a 13-week cash flow forecast?▼

Confirm entities, bank accounts, currencies, opening cash, and minimum cash, then roll forward weekly inflows and outflows from AR aging, AP due dates, payroll, tax, debt, and capex schedules. Each week beginning cash equals the prior week ending cash, and every flow is tagged committed, scheduled, forecast, or contingent.

How to model downside scenarios in a cash forecast?▼

Create a Downside case that changes specific drivers such as customer collection delays, revenue misses, cost or FX shocks, and capex timing. The output shows the first minimum-cash breach week, peak funding need, and minimum headroom without altering approved payment dates or terms.

Can this skill execute payments or bank transfers?▼

No. It only performs treasury analysis, scenarios, and action recommendations. Any transfer, payment release, debt draw, repayment, investment, hedge, or bank master change must be executed by authorized personnel through approved systems.

Why does my forecast opening cash not match the GL balance?▼

Differences usually come from bank timing, book adjustments, or stale extracts. Reconcile or bridge the variance first, classify it as bank timing, book adjustment, or unexplained, and mark the forecast status as opening cash unverified if it cannot be resolved.

When should I not use a direct cash forecast?▼

Avoid it for long-term integrated budget planning, DSO/DIO/DPO working capital analysis, or bank reconciliation, which belong to dedicated skills. It is also unsuitable for executing actual funding, payment, or hedging transactions.