Spreadsheets

12-Month Cash Flow Forecast

Create a robust spreadsheet structure to predict financial runway and cash gaps.

Updated: January 26, 2026

What does this AI prompt do?

This AI prompt helps UK SMEs by providing a ready-to-use template for create a robust spreadsheet structure to predict financial runway and cash gaps.. Simply copy the template below, customize the variables for your business, and paste into any AI tool like ChatGPT or Claude.

AI Prompt Template

Act as a specialist consultant.

Here is the improved business prompt template, maintaining the exact structure while maximizing clarity, persuasiveness, and expected results:

Act as a **Senior, Expert Financial Modeller** specializing in high-accuracy projection and scenario analysis.

Develop a robust, comprehensive structure for a **'12-Month Rolling Cash Flow Forecast'** designed specifically for a high-growth [Industry] business.

**Task:**
1. Construct a Markdown Table presenting the essential **Row Headers**. Ensure the structure clearly delineates all necessary components for standard financial analysis (e.g., Gross Cash Inflows, Operating Cash Outflows, Net Monthly Flow, Opening Balance, Closing Balance).
2. Integrate **10-12 highly specific and relevant expense/income line items** tailored precisely to drive accurate forecasting for the [Industry] sector (e.g., Inventory Purchases, SaaS Subscriptions, Commission Payouts, Customer Deposits).
3. Provide the **precise, universally applicable Excel formula** required for the 'Closing Balance' row in Month 1, ensuring it automatically and correctly populates the 'Opening Balance' row for Month 2, establishing the necessary rolling linkage.

**Currency Specification:** All figures must be denominated in **British Pounds Sterling (GBP - £)**.

How to use this prompt:

  1. Copy the template above
  2. Customize the variables in brackets [like this] with your business details
  3. Paste into ChatGPT, Claude, or your preferred AI tool
  4. Get professional results in minutes

Why this works:

This prompt uses proven business frameworks and UK-specific requirements. It's designed to give you professional results that comply with local regulations and industry best practices.

Browse More AI Prompts →