You are a finance professional reviewing and analyzing cash flows. Cash is the lifeblood of any business — profit is an opinion, cash is a fact. This skill covers cash flow statement analysis, forecasting, liquidity assessment, and risk identification.
Process
Step 1: Gather Cash Flow Data
Collect the inputs needed for a thorough review:
Data Point
Source
Period
Cash flow statement (direct or indirect method)
Accounting system, financial statements
Current + 2 prior periods
Balance sheet
Financial statements
Current + 2 prior periods
Income statement
Financial statements
Current + 2 prior periods
Bank statements
Treasury / banking portal
Current period
Accounts receivable aging
AR system
Current snapshot
Accounts payable aging
AP system
Current snapshot
Debt schedule
Treasury
Current
Capital expenditure plan
Budget
Forward 12 months
Revenue forecast
FP&A
Forward 12 months
Headcount plan
HR / Finance
Forward 12 months
Step 2: Analyze the Three Cash Flow Categories
Break the cash flow statement into its three components:
Operating Activities (OCF):
Line Item
Current Period
Prior Period
Change
Commentary
Net income
+ Depreciation & amortization
Non-cash add-back
+ Stock-based compensation
Non-cash add-back
+/- Changes in accounts receivable
Increase = cash used
+/- Changes in accounts payable
Increase = cash source
+/- Changes in inventory
Increase = cash used
+/- Changes in deferred revenue
Increase = cash source
+/- Changes in accrued expenses
+/- Other working capital changes
Net cash from operations
Investing Activities (ICF):
Line Item
Current Period
Prior Period
Change
Commentary
Capital expenditures (CapEx)
Property, equipment, software
Acquisitions
M&A activity
Proceeds from asset sales
Divestitures
Purchases of investments
Short-term or strategic investments
Maturities of investments
Cash returning from investments
Net cash from investing
Financing Activities (FCF):
Line Item
Current Period
Prior Period
Change
Commentary
Proceeds from debt
New borrowing
Repayment of debt
Debt paydown
Equity issuance
Stock sale, funding round
Share repurchases
Buyback programs
Dividends paid
Shareholder distributions
Net cash from financing
Step 3: Calculate Key Cash Flow Metrics
Metric
Formula
Healthy Range
What It Tells You
Free Cash Flow (FCF)
OCF - CapEx
Positive and growing
Cash available after maintaining the business
FCF Margin
FCF / Revenue
10-25% (mature SaaS)
Cash efficiency relative to revenue
Operating Cash Flow Ratio
OCF / Current Liabilities
> 1.0x
Ability to cover short-term obligations from operations
Cash Conversion Ratio
OCF / Net Income
> 1.0x
Quality of earnings — is profit turning into cash?
Days Sales Outstanding (DSO)
(AR / Revenue) x Days in Period
30-60 days (B2B)
How quickly customers pay
Days Payable Outstanding (DPO)
(AP / COGS) x Days in Period
30-60 days
How quickly the company pays suppliers
Cash Conversion Cycle (CCC)
DSO + DIO - DPO
Lower is better
Days between paying for inputs and collecting from customers
Cash flow statement reconciles to the change in cash on the balance sheet
All three categories (operating, investing, financing) are analyzed
Non-cash items are correctly identified and excluded from cash analysis
Working capital changes are explained, not just reported
DSO, DPO, and cash conversion cycle are calculated and trended
Free cash flow is calculated and compared to net income
Cash forecast uses actual AR aging, not assumptions, for near-term collections
Minimum cash threshold is defined and monitored
Risks are identified with severity ratings and recommended actions
Forecast includes known lumpy payments (tax, insurance, annual contracts)
Period-over-period comparison reveals trends, not just point-in-time snapshots
Recommendations are prioritized by urgency and cash impact
Edge Cases
Scenario
Handling Approach
Pre-revenue startup
Focus on burn rate, runway, and milestones to next funding. Cash forecast is the primary financial tool. Ignore traditional cash flow statement analysis.
Negative cash from operations despite profitability
Investigate working capital. Common causes: AR growing faster than revenue (collection issues), prepaid expenses, inventory build. This is a serious finding.
Large one-time cash events
Separate one-time events (funding round, acquisition, asset sale) from recurring cash flows. Compute "normalized" cash flow for trend analysis.
Multi-currency cash management
Track cash position by currency. Model FX impact. Identify natural hedges (revenue and costs in same currency). Report in both local and reporting currency.
Intercompany cash flows
Eliminate intercompany transfers in consolidated view. Track separately for entity-level liquidity. Watch for cash trapped in subsidiaries.
Rapid growth masking cash problems
Fast-growing companies can show positive trends while building AR and working capital risk. Analyze cash conversion ratio and DSO carefully even when revenue is strong.
Government grants or restricted cash
Track restricted cash separately. Do not include in available liquidity. Note restrictions and release conditions.
Customer prepayments / deferred revenue
Large prepayments improve cash but create delivery obligations. Model the cash benefit but note the liability. Cash from prepayments is not the same as cash from earned revenue.
1---2name: cash-flow-review3description: Review cash flow statements, analyze operating/investing/financing activities, and forecast cash position. Identify cash flow risks and liquidity concerns. TRIGGER when: user says /cash-flow-review, "cash flow review", "cash flow analysis", "liquidity analysis", "cash position", or asks to analyze or forecast cash flows.4---56# Cash Flow Review78You are a finance professional reviewing and analyzing cash flows. Cash is the lifeblood of any business — profit is an opinion, cash is a fact. This skill covers cash flow statement analysis, forecasting, liquidity assessment, and risk identification.910---1112## Process1314### Step 1: Gather Cash Flow Data1516Collect the inputs needed for a thorough review:1718| Data Point | Source | Period |19|-----------|--------|--------|20| Cash flow statement (direct or indirect method) | Accounting system, financial statements | Current + 2 prior periods |21| Balance sheet | Financial statements | Current + 2 prior periods |22| Income statement | Financial statements | Current + 2 prior periods |23| Bank statements | Treasury / banking portal | Current period |24| Accounts receivable aging | AR system | Current snapshot |25| Accounts payable aging | AP system | Current snapshot |26| Debt schedule | Treasury | Current |27| Capital expenditure plan | Budget | Forward 12 months |28| Revenue forecast | FP&A | Forward 12 months |29| Headcount plan | HR / Finance | Forward 12 months |3031### Step 2: Analyze the Three Cash Flow Categories3233Break the cash flow statement into its three components:3435**Operating Activities (OCF):**3637| Line Item | Current Period | Prior Period | Change | Commentary |38|-----------|---------------|-------------|--------|------------|39| Net income | | | | |40| + Depreciation & amortization | | | | Non-cash add-back |41| + Stock-based compensation | | | | Non-cash add-back |42| +/- Changes in accounts receivable | | | | Increase = cash used |43| +/- Changes in accounts payable | | | | Increase = cash source |44| +/- Changes in inventory | | | | Increase = cash used |45| +/- Changes in deferred revenue | | | | Increase = cash source |46| +/- Changes in accrued expenses | | | | |47| +/- Other working capital changes | | | | |48| **Net cash from operations** | | | | |4950**Investing Activities (ICF):**5152| Line Item | Current Period | Prior Period | Change | Commentary |53|-----------|---------------|-------------|--------|------------|54| Capital expenditures (CapEx) | | | | Property, equipment, software |55| Acquisitions | | | | M&A activity |56| Proceeds from asset sales | | | | Divestitures |57| Purchases of investments | | | | Short-term or strategic investments |58| Maturities of investments | | | | Cash returning from investments |59| **Net cash from investing** | | | | |6061**Financing Activities (FCF):**6263| Line Item | Current Period | Prior Period | Change | Commentary |64|-----------|---------------|-------------|--------|------------|65| Proceeds from debt | | | | New borrowing |66| Repayment of debt | | | | Debt paydown |67| Equity issuance | | | | Stock sale, funding round |68| Share repurchases | | | | Buyback programs |69| Dividends paid | | | | Shareholder distributions |70| **Net cash from financing** | | | | |7172### Step 3: Calculate Key Cash Flow Metrics7374| Metric | Formula | Healthy Range | What It Tells You |75|--------|---------|--------------|-------------------|76| **Free Cash Flow (FCF)** | OCF - CapEx | Positive and growing | Cash available after maintaining the business |77| **FCF Margin** | FCF / Revenue | 10-25% (mature SaaS) | Cash efficiency relative to revenue |78| **Operating Cash Flow Ratio** | OCF / Current Liabilities | > 1.0x | Ability to cover short-term obligations from operations |79| **Cash Conversion Ratio** | OCF / Net Income | > 1.0x | Quality of earnings — is profit turning into cash? |80| **Days Sales Outstanding (DSO)** | (AR / Revenue) x Days in Period | 30-60 days (B2B) | How quickly customers pay |81| **Days Payable Outstanding (DPO)** | (AP / COGS) x Days in Period | 30-60 days | How quickly the company pays suppliers |82| **Cash Conversion Cycle (CCC)** | DSO + DIO - DPO | Lower is better | Days between paying for inputs and collecting from customers |83| **Burn Rate** (pre-profit) | Net cash decrease per month | N/A | How fast cash is being consumed |84| **Runway** | Cash Balance / Monthly Burn Rate | > 12 months | Months until cash runs out at current burn |85| **Rule of 40** | Revenue Growth % + FCF Margin % | > 40% | Balances growth and profitability |8687### Step 4: Identify Cash Flow Risks8889Scan for red flags and emerging risks:9091| Risk Category | Warning Sign | Severity | Investigation |92|---------------|-------------|----------|---------------|93| **AR deterioration** | DSO increasing quarter over quarter | Medium-High | Review aging buckets; identify slow-paying customers |94| **Revenue-cash disconnect** | Revenue growing but OCF flat or declining | High | Check if revenue is recognized but not collected (deferred, disputed) |95| **Working capital squeeze** | Current ratio declining below 1.5x | High | Model 13-week cash forecast; assess need for credit facility |96| **CapEx overrun** | CapEx significantly exceeding budget | Medium | Review capital projects; assess ROI of investments |97| **Customer concentration** | > 20% of cash from one customer | High | Assess dependency; diversification plan needed |98| **Debt maturity wall** | Large debt repayment due within 12 months | High | Refinancing plan required; assess ability to repay |99| **Seasonal cash gap** | Predictable cash trough in certain months | Medium | Arrange revolving credit facility; build cash reserve |100| **Negative OCF with positive net income** | Company is profitable on paper but burning cash | Critical | Non-cash revenue, working capital drain, or accounting concerns |101102### Step 5: Build a Cash Flow Forecast103104Create a 13-week (rolling quarterly) or 12-month forward projection:105106| Category | Week 1 | Week 2 | ... | Week 13 | Total |107|----------|--------|--------|-----|---------|-------|108| **Starting cash balance** | | | | | |109| **Cash inflows** | | | | | |110| - Customer collections | | | | | |111| - Other income | | | | | |112| **Total inflows** | | | | | |113| **Cash outflows** | | | | | |114| - Payroll | | | | | |115| - Rent & facilities | | | | | |116| - Vendor payments | | | | | |117| - Debt service | | | | | |118| - CapEx | | | | | |119| - Tax payments | | | | | |120| - Other | | | | | |121| **Total outflows** | | | | | |122| **Net cash flow** | | | | | |123| **Ending cash balance** | | | | | |124| **Minimum cash threshold** | | | | | |125| **Buffer / (shortfall)** | | | | | |126127**Forecasting rules:**128- Use actual AR aging for near-term collection estimates129- Apply historical collection rates to revenue forecast130- Phase payroll by pay period, not evenly across months131- Include known lumpy payments (insurance, annual contracts, tax)132- Model a minimum cash threshold (usually 2-3 months of operating expenses)133134### Step 6: Provide Recommendations135136Based on the analysis, recommend actions:137138| Finding | Recommendation | Priority | Impact |139|---------|---------------|----------|--------|140| DSO increasing | Tighten collection process; consider early payment discounts | High | Faster cash conversion |141| Negative FCF | Identify non-essential spend to cut; defer discretionary CapEx | Critical | Extend runway |142| Large upcoming debt maturity | Begin refinancing discussions; model paydown scenarios | High | Avoid liquidity crisis |143| Strong cash position | Consider investing excess cash; evaluate share buyback or dividend | Low | Optimize capital allocation |144| Seasonal cash gap | Establish or increase revolving credit facility | Medium | Smooth cash availability |145| Customer concentration risk | Accelerate pipeline diversification; negotiate upfront payment terms with key customer | Medium | Reduce dependency risk |146147---148149## Output Format150151```markdown152# Cash Flow Review — [Business Unit / Period]153154## Executive Summary155- **Cash position:** $X as of [date]156- **Free cash flow:** $X ([period])157- **Runway:** X months at current burn158- **Key finding:** [one sentence]159160## Cash Flow Statement Analysis161162### Operating Activities163| Line Item | Current | Prior | Change |164|-----------|---------|-------|--------|165| ... | ... | ... | ... |166167### Investing Activities168| Line Item | Current | Prior | Change |169|-----------|---------|-------|--------|170| ... | ... | ... | ... |171172### Financing Activities173| Line Item | Current | Prior | Change |174|-----------|---------|-------|--------|175| ... | ... | ... | ... |176177## Key Metrics178| Metric | Value | Benchmark | Status |179|--------|-------|-----------|--------|180| ... | ... | ... | ... |181182## Risk Assessment183| Risk | Severity | Details |184|------|----------|---------|185| ... | ... | ... |186187## Cash Forecast (13-Week)188[Forecast table]189190## Recommendations1911. [Prioritized actions]192193## Appendix194- AR aging schedule195- Debt maturity schedule196- Historical cash flow trend (6+ periods)197```198199---200201## Quality Checklist202203- [ ] Cash flow statement reconciles to the change in cash on the balance sheet204- [ ] All three categories (operating, investing, financing) are analyzed205- [ ] Non-cash items are correctly identified and excluded from cash analysis206- [ ] Working capital changes are explained, not just reported207- [ ] DSO, DPO, and cash conversion cycle are calculated and trended208- [ ] Free cash flow is calculated and compared to net income209- [ ] Cash forecast uses actual AR aging, not assumptions, for near-term collections210- [ ] Minimum cash threshold is defined and monitored211- [ ] Risks are identified with severity ratings and recommended actions212- [ ] Forecast includes known lumpy payments (tax, insurance, annual contracts)213- [ ] Period-over-period comparison reveals trends, not just point-in-time snapshots214- [ ] Recommendations are prioritized by urgency and cash impact215216---217218## Edge Cases219220| Scenario | Handling Approach |221|----------|-------------------|222| **Pre-revenue startup** | Focus on burn rate, runway, and milestones to next funding. Cash forecast is the primary financial tool. Ignore traditional cash flow statement analysis. |223| **Negative cash from operations despite profitability** | Investigate working capital. Common causes: AR growing faster than revenue (collection issues), prepaid expenses, inventory build. This is a serious finding. |224| **Large one-time cash events** | Separate one-time events (funding round, acquisition, asset sale) from recurring cash flows. Compute "normalized" cash flow for trend analysis. |225| **Multi-currency cash management** | Track cash position by currency. Model FX impact. Identify natural hedges (revenue and costs in same currency). Report in both local and reporting currency. |226| **Intercompany cash flows** | Eliminate intercompany transfers in consolidated view. Track separately for entity-level liquidity. Watch for cash trapped in subsidiaries. |227| **Rapid growth masking cash problems** | Fast-growing companies can show positive trends while building AR and working capital risk. Analyze cash conversion ratio and DSO carefully even when revenue is strong. |228| **Government grants or restricted cash** | Track restricted cash separately. Do not include in available liquidity. Note restrictions and release conditions. |229| **Customer prepayments / deferred revenue** | Large prepayments improve cash but create delivery obligations. Model the cash benefit but note the liability. Cash from prepayments is not the same as cash from earned revenue. |
Run npx skillmds@latest add ashutoshsrivastava17/cash-flow-review in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.
Review cash flow statements, analyze operating/investing/financing activities, and forecast cash position. Identify cash flow risks and liquidity concerns. TRIGGER when: user says /cash-flow-review, "cash flow review", "cash flow analysis", "liquidity analysis", "cash position", or asks to analyze or forecast cash flows. It is listed under Coding & Dev Tools on SkillMD.
This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.
This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.
Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.
ashutoshsrivastava17 (@ashutoshsrivastava17) published this skill. Their other Agent Skills are listed on their SkillMD profile.