# Finance Forecast Variance and Cash Risk Review

Public URL: https://amo.ng/prompts/finance-forecast-variance-cash-risk-review

Summary: Analyze budget variance, forecast changes, cash runway risk, operating drivers, and owner-specific corrective actions for finance and leadership reviews.

Use this for: Use this for reviewing finance forecast variance, cash runway risk, budget drivers, controllable actions, owner follow-ups, and executive-ready finance updates.

Category: Data Analysis
Tool: ChatGPT
Difficulty: Expert
Prompt type: analytics review

## Best Use Cases

1. Monthly forecast variance review
2. Cash runway risk assessment
3. Budget owner follow-up planning
4. Finance business partner review
5. Executive finance update preparation
6. Runway sensitivity review
7. Operating spend control planning

## Prompt Body

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

1. Actuals, budget, and forecast
2. Time period and comparison basis
3. Revenue and expense drivers
4. Cash balance and runway assumptions
5. Known one-time items or anomalies
6. Budget owners and decision deadline
7. Reporting constraints and review gates

## How to Use

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.

## Tags

1. finance
2. forecasting
3. variance-analysis
4. cash-risk
5. fp-and-a
6. budget
7. runway
8. executive-brief
9. risk-management
10. human-review
11. cash-flow
12. budget-owners
13. operating-review

## Dates

Published: 2026-07-08
Updated: 2026-07-08