Cash Flow Sensitivity Analysis
Cash Flow & Treasury
Quick Answer
Enter your cash position and key cash flow drivers. Paste into Claude or ChatGPT. Get sensitivity analysis showing how each variable affects your cash position and the trigger thresholds for management action.
What You Get
A cash flow sensitivity analysis covering the key variables affecting cash position, scenario modeling for changes in each variable, identification of cash trigger thresholds, and a risk-ranked list of cash flow sensitivities with monitoring recommendations.
Who Is This For
CFOs stress-testing cash forecasts for board presentations, finance teams preparing lender covenants analysis, and founders who want to understand their cash risk exposure.
About This Template
Cash flow sensitivity analysis tests how your cash position responds to changes in the key variables that drive it — revenue timing, customer payment speed, supplier terms, and unexpected costs. This template guides CFOs through identifying the key variables that affect their cash position, then uses AI to model how changes in each variable affect the cash position and identify the specific threshold at which each variable requires management action.
Fill In Your Details
Your company name
e.g. 2400000
e.g. 850000
e.g. 720000
e.g. 300000
e.g. customer payment speed, revenue volume, key customer concentration, supplier payment terms, seasonality
e.g. 18 months at $130K net burn per month
Gather these details then use them to fill in the prompt below.
AI Prompts
Generate cash flow sensitivity analysis
Paste this prompt into Claude or ChatGPT with your data filled in.
You are a CFO conducting a cash flow sensitivity analysis. Using the data below, produce a comprehensive sensitivity analysis showing how cash position responds to changes in key variables. Company: [company_name] Current cash: [current_cash] Monthly revenue: [monthly_revenue] Monthly costs: [monthly_costs] Minimum cash reserve: [minimum_cash] Key variables: [key_variables] Current runway: [current_runway] For each key variable produce: 1. Base Case — current position and runway 2. Adverse Scenario — what happens if this variable moves 20 percent against you 3. Severe Scenario — what happens if this variable moves 40 percent against you 4. Cash Trigger Threshold — at what point does this variable require management action 5. Time to Trigger — how long until cash hits the minimum reserve in the adverse scenario Then produce: - Sensitivity Ranking — rank variables from highest to lowest cash impact - Monitoring Dashboard — what to track weekly to get early warning on each variable - Hedging Actions — any actions that would reduce sensitivity to the highest-risk variable Show calculations for each scenario.
Sample Output
This is an example of what AI produces when you use this template.
Revenue Volume Sensitivity
Base case: $850K monthly revenue, $130K net burn, 18-month runway. Adverse scenario (20% revenue decline to $680K): net burn increases from $130K to $300K per month. Runway reduces from 18 months to 7 months. Cash trigger threshold: revenue below $750K per month for 2 consecutive months. Time to trigger: 2 months at adverse revenue level before action required. Severe scenario (40% decline to $510K): net burn $470K per month, runway 5 months, requiring immediate cost action within 30 days of detection.
Sensitivity Ranking
Ranked by cash impact of 20 percent adverse move: 1. Revenue volume — $170K additional monthly burn, 11-month runway reduction. HIGHEST RISK. 2. Customer payment speed — DSO extending from 16 to 25 days ties up additional $220K in AR permanently. 3. Key customer loss — largest customer at 18% of revenue represents $153K monthly exposure. 4. Supplier terms shortening — if Net 30 terms removed, $95K monthly cash acceleration required. 5. Unexpected costs — one-time events up to $200K would reduce runway by 1.5 months. LOWEST RISK given $2.4M cash buffer. Monitor weekly: MRR growth rate (revenue volume), DSO trend (payment speed), and customer health scores (concentration risk).