Marketplace

cash-flow-analysis

Cash flow analysis and treasury management workflow covering liquidity assessment, cash forecasting, working capital optimization, and treasury operations.

$ 安裝

git clone https://github.com/LerianStudio/ring /tmp/ring && cp -r /tmp/ring/finance-team/skills/cash-flow-analysis ~/.claude/skills/ring

// tip: Run this command in your terminal to install the skill


name: cash-flow-analysis description: | Cash flow analysis and treasury management workflow covering liquidity assessment, cash forecasting, working capital optimization, and treasury operations.

trigger: |

  • Cash flow forecasting (13-week, monthly)
  • Liquidity assessment
  • Working capital analysis
  • Treasury operations review

skip_when: |

  • Financial statement analysis → use financial-analysis
  • Creating budgets → use budget-creation
  • Building valuation models → use financial-modeling

related: similar: [financial-analysis, budget-creation] uses: [treasury-specialist]

Cash Flow Analysis Workflow

This skill provides a structured workflow for cash flow analysis and treasury management using the treasury-specialist agent.

Workflow Overview

The cash flow analysis workflow follows 5 phases:

PhaseNameDescription
1Position AssessmentEstablish current cash position
2ForecastingBuild cash flow forecast
3Liquidity AnalysisAssess liquidity and runway
4Risk IdentificationIdentify cash flow risks
5RecommendationsProvide actionable guidance

Phase 1: Position Assessment

MANDATORY: Establish current position before forecasting

Position Requirements

ItemDescription
Bank balancesAll accounts, same day
Credit availabilityUndrawn facilities
Restricted cashIdentify any restrictions
IntercompanyIC positions and netting

Verification Checklist

CheckValidation
All accounts includedComplete bank list
Same-day balanceNo stale data
ReconciledTies to bank statement
FX convertedConsistent currency

Blocker Check

If ANY of these are unclear, STOP and ask:

  • Current cash position
  • Credit facility terms
  • FX rate source for conversion
  • Restricted cash items

Phase 2: Forecasting

MANDATORY: Build forecast with documented methodology

Forecast Types

TypeHorizonGranularityUse Case
13-Week13 weeksWeeklyShort-term liquidity
Monthly12 monthsMonthlyOperating planning
Annual1-5 yearsAnnualStrategic planning

Forecast Components

ComponentDescription
Opening balanceCurrent position
Operating receiptsCustomer collections, other
Operating disbursementsPayroll, vendors, other
InvestingCapEx, acquisitions
FinancingDebt, equity, dividends
Closing balanceCalculated position

Methodology Options

MethodDescription
Receipts/DisbursementsBottom-up from transactions
Adjusted Net IncomeTop-down from P&L
Balance Sheet MethodFrom B/S changes

Phase 3: Agent Dispatch

Dispatch to specialist with full context

Agent Dispatch

Task tool:
  subagent_type: "treasury-specialist"
  model: "opus"
  prompt: |
    Perform cash flow analysis per these specifications:

    **Current Position**: [from Phase 1]
    **Forecast Type**: [13-week/monthly/annual]
    **Methodology**: [receipts-disbursements/adjusted NI]

    **Data Provided**:
    - Bank balances as of [date]
    - Credit facility details
    - AR aging
    - AP aging
    - Payroll schedule
    - Known commitments

    **Required Output**:
    - Current position summary
    - Cash flow forecast
    - Liquidity analysis
    - Risk assessment
    - Recommendations

Required Output Elements

ElementRequirement
Treasury SummaryCurrent position and highlights
Cash PositionAll accounts with reconciliation
ForecastPeriod-by-period projection
Liquidity AnalysisRunway and ratios
Risk AssessmentIdentified risks and mitigations
RecommendationsActionable next steps

Phase 4: Liquidity Analysis

MANDATORY: Assess liquidity comprehensively

Liquidity Metrics

MetricFormulaThreshold
Cash RunwayCash / Monthly Burn>6 months
Current RatioCurrent Assets / Current Liabilities>1.5x
Quick Ratio(CA - Inventory) / CL>1.0x
Cash RatioCash / Current Liabilities>0.5x

Stress Testing

ScenarioDescription
Base CaseExpected forecast
Delayed ReceiptsAR delayed 30 days
Accelerated PaymentsAP paid early
Revenue Shortfall10-20% revenue decline
Combined StressMultiple adverse factors

Phase 5: Risk Identification

MANDATORY: Document all cash flow risks

Risk Categories

CategoryExamples
Collection RiskCustomer concentration, aging
Payment RiskVendor demands, timing
Operational RiskSeasonality, cyclicality
Financing RiskCovenant compliance, renewal
FX RiskCurrency exposure

Risk Assessment Framework

ElementDocumentation
Risk descriptionClear statement
ProbabilityHigh/Medium/Low
ImpactQuantified if possible
MitigationSpecific action

Pressure Resistance

See shared-patterns/pressure-resistance.md for universal pressures.

Cash Flow-Specific Pressures

Pressure TypeRequestAgent Response
"Use yesterday's balance""Treasury needs current data. I'll get today's position."
"Skip the forecast, just need position""Position without forecast lacks context. I'll include projections."
"Estimate the AR collections""Collections forecast needs AR aging basis. I'll use actual data."
"We never have liquidity issues""Past performance ≠ future results. I'll assess current risk."

Anti-Rationalization Table

See shared-patterns/anti-rationalization.md for universal anti-rationalizations.

Cash Flow-Specific Anti-Rationalizations

RationalizationWhy It's WRONGRequired Action
"Cash is cash, simple analysis"Cash has many componentsANALYZE by category
"Forecast is same as last month"Each forecast is independentBUILD fresh forecast
"We always collect in 45 days"Actual may differUSE actual aging
"Covenant is not close"Still needs monitoringCALCULATE covenant

Execution Report

Upon completion, report:

MetricValue
DurationXm Ys
Accounts ReconciledN
Forecast PeriodsN
Risks IdentifiedN
RecommendationsN
ResultCOMPLETE/PARTIAL

Quality Indicators

IndicatorStatus
Position same-dayYES/NO
All accounts includedYES/NO
Forecast documentedYES/NO
Risks assessedYES/NO
Covenants calculatedYES/NO