Cash Flow Analysis Workflow

cash-flow-analysis

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

majiayu000/claude-skill-registry·0installs663starsFinance & Trading

SKILL.md

Full skill instructions

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:

Phase	Name	Description
1	Position Assessment	Establish current cash position
2	Forecasting	Build cash flow forecast
3	Liquidity Analysis	Assess liquidity and runway
4	Risk Identification	Identify cash flow risks
5	Recommendations	Provide actionable guidance

Phase 1: Position Assessment

MANDATORY: Establish current position before forecasting

Position Requirements

Item	Description
Bank balances	All accounts, same day
Credit availability	Undrawn facilities
Restricted cash	Identify any restrictions
Intercompany	IC positions and netting

Verification Checklist

Check	Validation
All accounts included	Complete bank list
Same-day balance	No stale data
Reconciled	Ties to bank statement
FX converted	Consistent 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

Type	Horizon	Granularity	Use Case
13-Week	13 weeks	Weekly	Short-term liquidity
Monthly	12 months	Monthly	Operating planning
Annual	1-5 years	Annual	Strategic planning

Forecast Components

Component	Description
Opening balance	Current position
Operating receipts	Customer collections, other
Operating disbursements	Payroll, vendors, other
Investing	CapEx, acquisitions
Financing	Debt, equity, dividends
Closing balance	Calculated position

Methodology Options

Method	Description
Receipts/Disbursements	Bottom-up from transactions
Adjusted Net Income	Top-down from P&L
Balance Sheet Method	From B/S changes

Phase 3: Agent Dispatch

Dispatch to specialist with full context

Agent Dispatch

Task tool:
  subagent_type: "ring: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

Element	Requirement
Treasury Summary	Current position and highlights
Cash Position	All accounts with reconciliation
Forecast	Period-by-period projection
Liquidity Analysis	Runway and ratios
Risk Assessment	Identified risks and mitigations
Recommendations	Actionable next steps

Phase 4: Liquidity Analysis

MANDATORY: Assess liquidity comprehensively

Liquidity Metrics

Metric	Formula	Threshold
Cash Runway	Cash / Monthly Burn	>6 months
Current Ratio	Current Assets / Current Liabilities	>1.5x
Quick Ratio	(CA - Inventory) / CL	>1.0x
Cash Ratio	Cash / Current Liabilities	>0.5x

Stress Testing

Scenario	Description
Base Case	Expected forecast
Delayed Receipts	AR delayed 30 days
Accelerated Payments	AP paid early
Revenue Shortfall	10-20% revenue decline
Combined Stress	Multiple adverse factors

Phase 5: Risk Identification

MANDATORY: Document all cash flow risks

Risk Categories

Category	Examples
Collection Risk	Customer concentration, aging
Payment Risk	Vendor demands, timing
Operational Risk	Seasonality, cyclicality
Financing Risk	Covenant compliance, renewal
FX Risk	Currency exposure

Risk Assessment Framework

Element	Documentation
Risk description	Clear statement
Probability	High/Medium/Low
Impact	Quantified if possible
Mitigation	Specific action

Pressure Resistance

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

Cash Flow-Specific Pressures

Pressure Type	Request	Agent 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

Rationalization	Why It's WRONG	Required Action
"Cash is cash, simple analysis"	Cash has many components	ANALYZE by category
"Forecast is same as last month"	Each forecast is independent	BUILD fresh forecast
"We always collect in 45 days"	Actual may differ	USE actual aging
"Covenant is not close"	Still needs monitoring	CALCULATE covenant

Execution Report

Upon completion, report:

Metric	Value
Duration	Xm Ys
Accounts Reconciled	N
Forecast Periods	N
Risks Identified	N
Recommendations	N
Result	COMPLETE/PARTIAL

Quality Indicators

Indicator	Status
Position same-day	YES/NO
All accounts included	YES/NO
Forecast documented	YES/NO
Risks assessed	YES/NO
Covenants calculated	YES/NO

Install skill

Copy and run in your terminal

npx -y skills add https://github.com/majiayu000/claude-skill-registry --skill cash-flow-analysis

View on GitHub

skills/data/cash-flow-analysis/SKILL.md

More Finance & Trading skills

View all

Finance & Trading

stripe-projects

stripe projects

1.9K 66.8K

View

Finance & Trading

Harvest every `ponytail:` comment in the codebase into a debt ledger, so the deliberate shortcuts and deferrals ponytail leaves behind get tracked instead of rotting into "later means never". One-shot report, changes nothing.

155.5K 27.9K

View

Finance & Trading

okx-dex-market

okx dex market

341 18.5K

View

Finance & Trading

okx-agentic-wallet

okx agentic wallet

341 16.7K

View

Finance & Trading

gmgn-portfolio

gmgn portfolio

596 15.7K

View

Finance & Trading

okx-dapp-discovery

okx dapp discovery

341 13.8K

View

Finance & Trading

okx-agent-payments-protocol

okx agent payments protocol

341 13K

View

Finance & Trading

stripe-integration

Stripe payment processing with checkout sessions, subscriptions, webhooks, and customer management.

40.2K 12.9K

View

Finance & Trading

startup-financial-modeling

Build comprehensive 3-5 year financial models with revenue projections, cost structures, cash flow analysis, and scenario planning for early-stage startups. Use this skill when creating financial projections, calculating burn rate or runway, modeling fundraising scenarios, or preparing investor-r...

40.2K 12K

View

Finance & Trading

stock-analysis

Stock and cryptocurrency analysis with portfolio management and multi-dimensional scoring.

46 11.9K

View

Finance & Trading

coinglass

Real-time crypto derivatives positioning, whale tracking, liquidations, and institutional ETF flows across 37 specialized tools.

27 11.5K

View

Finance & Trading

dbt-transformation-patterns

Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building data transformations, creating data models, or implementing analytics engineering best practices.

40.2K 10.5K

View