AGENT SKILL

managing-cash-flow-forecasting

Structures short and long-term cash flow forecasting with variance analysis and liquidity planning. Use when forecasting cash flows, planning liquidity, or analyzing cash flow variances.

License 许可
Apache-2.0
最近更新
2026-11-09
Stars
★ 0
Forks
0

01 前言 Front Matter

name
managing-cash-flow-forecasting
tags
[ "management", "corporate-finance" ]
source
https://github.com/CaseMark/skills
license
Apache-2.0
language
en
metadata
{ "author": "casemark", "skill_modes": [ "Management", "Coordination" ], "document_types": [ "Management Report" ], "practice_areas": [ "Corporate Finance", "Treasury", "Financial Planning" ] }
description
Structures short and long-term cash flow forecasting with variance analysis and liquidity planning. Use when forecasting cash flows, planning liquidity, or analyzing cash flow variances.
imported_at
2026-09-20
source_path
skills/finance/managing-cash-flow-forecasting/SKILL.md
source_repository
CaseMark/skills

03 SKILL.md 正文

Managing Cash Flow Forecasting

When To Use

  • Building or refreshing a short-term (13-week) or long-term (12–24 month) cash flow forecast
  • Preparing liquidity analyses for board reporting, lender covenant compliance, or capital planning
  • Performing variance analysis on prior forecast periods to improve future accuracy
  • Stress-testing cash positions under downside scenarios (revenue shortfall, delayed collections, accelerated payables)
  • Supporting treasury decisions on draw-downs, investments, or debt repayment timing

Inputs To Gather

  • Historical cash flow data: Minimum 12 months of actual bank statements or ERP cash ledger exports (operating, investing, financing categories)
  • Revenue pipeline: Booked revenue, contracted backlog, and probabilistic pipeline by expected collection date
  • Payables schedule: Committed expenditures, vendor payment terms, payroll calendar, tax due dates, debt service schedule
  • Working capital metrics: Current DSO, DPO, DIO; any recent trend shifts or seasonal patterns
  • Capital expenditure plan: Approved and pending capex with expected disbursement timing
  • Financing facilities: Revolver availability, term loan amortization, letter-of-credit commitments, covenant thresholds (minimum liquidity, fixed charge coverage) [VERIFY specific covenant definitions per credit agreement]
  • Assumptions register: FX rates, interest rate curves, intercompany settlement timing, dividend policy

Workflow

  1. Define forecast horizon and granularity

    • 13-week forecast: weekly buckets, direct-method (receipts and disbursements)
    • 12–24 month forecast: monthly buckets, indirect-method starting from EBITDA or net income
    • Confirm reporting currency and any multi-currency consolidation requirements
  2. Build the receipts model

    • Map booked receivables to expected collection weeks using historical DSO distribution (not a single-point average)
    • Layer in probabilistic pipeline receipts with weighted probability haircuts
    • Add non-operating inflows: asset disposals, tax refunds, insurance proceeds, intercompany loans
  3. Build the disbursements model

    • Slot committed payables by contractual due date and actual payment behavior (early-pay discounts vs. stretch)
    • Include payroll, benefits, and tax withholding on their fixed calendar dates
    • Schedule debt service (principal + interest), capex draws, and dividend payments
    • Add contingency line items for unplanned outflows (litigation reserves, warranty claims) with probability weighting
  4. Calculate net cash flow and cumulative position

    • Net weekly/monthly cash flow = total receipts minus total disbursements
    • Cumulative cash = opening cash + net cash flow + any facility draws/repayments
    • Flag any period where projected cumulative cash falls below minimum liquidity threshold or covenant floor
  5. Run scenario and sensitivity analysis

    • Base case: Management's best estimate
    • Downside case: Revenue delayed by X days, top-customer default, capex acceleration
    • Upside case: Accelerated collections, deferred discretionary spend
    • Identify the breakeven assumptions that would trigger a liquidity shortfall
  6. Perform variance analysis on prior periods

    • Compare each line item's forecast vs. actual for the most recent 4–8 periods
    • Compute forecast accuracy metrics: Mean Absolute Percentage Error (MAPE) by line item
    • Identify systematic biases (e.g., consistently over-forecasting collections) and adjust current model inputs accordingly
  7. Document liquidity action triggers

    • Define thresholds that trigger specific treasury actions (e.g., draw on revolver if projected cash < $X for 2+ consecutive weeks)
    • Specify escalation path: treasury analyst -> CFO -> board if minimum liquidity is breached under base case

Output

The deliverable is a Cash Flow Forecast Report containing:

  • Executive summary: Current liquidity position, forecast horizon covered, key risks and recommended actions
  • Forecast schedule: Tabular receipts/disbursements by period with net and cumulative cash rows
  • Scenario comparison table: Base, downside, and upside cumulative cash by period with covenant headroom noted
  • Variance analysis: Prior-period forecast vs. actual with MAPE and bias direction per major line item
  • Assumptions register: Every material assumption documented with source and last-validated date
  • Action trigger matrix: Liquidity thresholds mapped to specific treasury responses and responsible parties

Quality Checks

  • Confirm opening cash balance ties to the most recent bank reconciliation or treasury report
  • Verify debt service amounts match the amortization schedule in the credit agreement [VERIFY]
  • Ensure covenant calculations use the same definitions as the credit agreement (e.g., whether cash includes restricted cash) [VERIFY]
  • Check that FX conversion rates are sourced consistently and dated appropriately
  • Validate that the sum of weekly buckets in the 13-week forecast reconciles to the corresponding monthly totals in the long-term forecast
  • Confirm no double-counting of intercompany flows in consolidated forecasts
  • Review that probability weights on pipeline receipts reflect current sales team assessments, not stale data
  • Ensure variance analysis covers enough periods (minimum 4) to identify trends rather than one-off anomalies

04 同仓库更多 Skills