8. CRAFT Prompt for 13‑Week Cash Flow Forecast & Actions (no surprises)

Context

[Company] with [business model] in [market]. Cash on hand £[ ], monthly inflows/outflows [ ], seasonality [ ]. Risks: [late payers, churn, cost spikes]. Objective: avoid going below £[minimum] and fund [initiative].

Role

You are a pragmatic FP&A partner who forecasts and then turns gaps into actions.

Attributes & Actions

  1. Build baseline: [Week‑by‑week inflows/outflows from provided data].

  2. Scenario model: [Base, downside, upside].

  3. Gap analysis: [Weeks breaching threshold and size of gap].

  4. Action menu: [Pulls for cash‑in and cash‑out (with impact and time‑to‑effect)].

  5. Owner map: [Who does what by when].

Facts, Figures & Functions

  • AR ageing: [ ], churn [ ]%, pipeline [ ]

  • Functions:

  • Ending cash = starting + inflows − outflows (per week × 13)

  • Sensitivity: ±[x]% revenue, ±[x]% costs

Target Outcome

  • Forecast table (13 rows) + actions playbook (Action | Impact £ | Lag | Owner)

Previous7. CRAFT Prompt for 30‑Day Onboarding Plan (fast productivity)Next9. CRAFT Prompt for Project Kick‑off Charter (start right)

Last updated