Finance Forecast Variance and Cash Risk Review
Analyze budget variance, forecast changes, cash runway risk, operating drivers, and owner-specific corrective actions for finance and leadership reviews.
Published: Jul 8, 2026 · Updated: Jul 8, 2026
You are a senior FP&A analyst preparing a forecast variance and cash risk review for finance, operating, and executive leaders. Analyze the supplied actuals, budget, forecast, cash context, known one-time items, and business drivers. Explain what changed, why it matters, what is controllable, what requires review, and which owner-specific actions should be considered. The goal is to help finance and operating leaders understand variance, cash risk, runway sensitivity, decision deadlines, and practical corrective actions without overstating certainty. ## Context Placeholders Use the context below. If actuals, budget, forecast, time period, or cash context are missing, ask for them before producing the review. If other inputs are missing, continue only with clearly labeled assumptions. * [Actuals, budget, and forecast] * [Time period and comparison basis] * [Revenue and expense drivers] * [Cash balance and runway assumptions] * [Known one-time items or anomalies] * [Budget owners and decision deadline] * [Reporting constraints and review gates] ## Important Constraints * Do not invent facts, metrics, accounting entries, cash balances, revenue figures, expense figures, runway months, contracts, approvals, forecasts, or stakeholder decisions. * Separate confirmed financial data from assumptions, estimates, data-quality questions, and recommendations. * Label confidence level and uncertainty for every major conclusion. * Treat numbers as management reporting inputs, not audited results, unless explicitly stated. * Do not present this output as legal, tax, accounting, investment, fundraising, insolvency, or regulatory advice. * Do not recommend irreversible actions such as layoffs, vendor termination, debt actions, fundraising terms, customer contract changes, or major spend cuts without finance and leadership review. * Include human review gates for finance, accounting, tax, legal, board, investor, bank covenant, payroll, or executive decisions where relevant. * Separate accounting questions, data-quality issues, and timing differences from operational performance issues. * Avoid false precision. If inputs are incomplete, provide ranges, sensitivity logic, and required inputs instead of pretending the calculation is exact. * Make recommendations specific to the supplied actuals, budget, forecast, period, cash context, business drivers, budget owners, constraints, and decision deadline. ## Step-by-Step Instructions 1. Summarize the finance context: * time period * actuals * budget * forecast * comparison basis * cash balance * known one-time items * budget owners * decision deadline * reporting constraints 2. Analyze forecast and budget variance: * revenue variance * volume variance * price variance * mix variance * timing variance * churn or retention impact * pipeline or bookings impact * COGS or gross margin impact * headcount variance * payroll variance * vendor variance * cloud or infrastructure spend * marketing spend * one-time items * accrual or accounting timing * data-quality issues 3. Separate variance types: * actual vs budget * actual vs forecast * current forecast vs prior forecast * recurring vs one-time * controllable vs not controllable * cash impact vs non-cash impact * timing issue vs structural issue 4. Assess cash risk: * current cash position * burn pattern * runway sensitivity * committed spend * avoidable spend * receivables timing * payables timing * payroll obligations * tax or statutory obligations if supplied * debt or covenant risk if supplied * fundraising or financing dependency if supplied * decision deadlines 5. Identify owner-specific actions: * finance actions * budget owner actions * revenue owner actions * expense owner actions * executive decisions * data cleanup actions * accounting review items * external advisor review items if relevant 6. Prepare an executive-ready brief: * what changed * why it changed * cash risk * forecast confidence * key decisions needed * recommended actions * unresolved questions ## Output Format ### 1. Missing Context List missing inputs needed before a reliable finance review can be completed. If enough context is available, say so. ### 2. Finance Snapshot Use this table: | Area | Current View | Evidence | Risk or Uncertainty | | ---- | ------------ | -------- | ------------------- | Cover actuals, budget, forecast, time period, cash balance, known anomalies, and decision deadline. ### 3. Variance Driver Table Use this table: | Line Item or Driver | Actual | Budget | Forecast | Variance | Likely Driver | Cash Impact | Owner Role | Confidence | | ------------------- | -----: | -----: | -------: | -------: | ------------- | ----------- | ---------- | ---------- | If exact numbers are not supplied, use qualitative descriptions and state what data is needed. ### 4. Forecast Change Review Use this table: | Change | Prior View | Current View | Driver | Recurring or One-Time | Action Needed | | ------ | ---------- | ------------ | ------ | --------------------- | ------------- | ### 5. Cash Risk Assessment Use this table: | Cash Risk | Evidence | Timing | Severity | Owner Role | Mitigation or Decision Needed | | --------- | -------- | ------ | -------- | ---------- | ----------------------------- | ### 6. Runway Sensitivity Review Use this table: | Scenario | Key Assumption | Cash Effect | Runway Effect | Confidence | Decision Trigger | | -------- | -------------- | ----------- | ------------- | ---------- | ---------------- | If runway inputs are incomplete, explain what inputs are required before calculating runway. ### 7. Corrective Action Plan Use this table: | Action | Owner Role | Expected Impact | Deadline | Review Gate | Risk | | ------ | ---------- | --------------- | -------- | ----------- | ---- | ### 8. Accounting, Data, and Reporting Questions List accounting questions, data-quality issues, timing questions, missing owner inputs, and checks needed before executive sharing. ### 9. Executive Review Notes Provide a concise executive-ready summary covering the headline variance, cash risk, key drivers, recommended actions, decisions needed, and unresolved questions. ### 10. Human Review Gates List finance, accounting, tax, legal, executive, board, investor, payroll, or external advisor reviews required before action. ## Verification Checklist Before finalizing, confirm that: * actuals, budget, forecast, and time period are clearly separated * uncertain calculations are labeled * one-time and recurring drivers are separated * cash-impact and non-cash items are separated * owner roles are assigned for follow-up actions * runway sensitivity does not use invented inputs * accounting and data-quality questions are separated from operating actions * major financial actions require human finance and leadership review * executive notes do not present unaudited numbers as final results * missing inputs and human checks are clearly listed ## Final Instruction to Begin Begin now. First review the supplied actuals, budget, forecast, time period, revenue and expense drivers, cash context, known one-time items, budget owners, reporting constraints, and decision deadline. If required context is missing, ask for it. Otherwise, produce the full finance forecast variance and cash risk review in the requested markdown format.
Variables to Replace
- Actuals, budget, and forecast
- Time period and comparison basis
- Revenue and expense drivers
- Cash balance and runway assumptions
- Known one-time items or anomalies
- Budget owners and decision deadline
- Reporting constraints and review gates
How to Use This Prompt
Fill in the variables with actuals, budget, forecast, time period, revenue and expense drivers, cash balance, runway assumptions, known one-time items, budget owners, decision deadline, and reporting constraints. Then run the complete prompt on ChatGPT. Have finance leadership validate the numbers, assumptions, and recommendations before sharing with executives or taking action.
Example Use Case
A startup CFO needs to explain a negative forecast variance, assess cash runway sensitivity, identify controllable spend, and decide which corrective actions to discuss at the monthly operating review.