BuildCopilot

Generate a Cashflow Forecast

Create a monthly cashflow forecast with cumulative expenditure profile and S-curve data for construction project financial planning.

IntermediateCommercial ManagerBudget Forecasting

Overview

This workflow helps Commercial Managers produce a project cashflow forecast showing monthly income and expenditure profiles. It generates an S-curve expenditure pattern based on project parameters and presents the data in a format ready for financial reporting.

Want all 50 prompts in one downloadable pack?

The Construction AI Prompt Pack includes every workflow prompt, 13 editable templates, and role-specific cheat sheets.

Get the Pack - £29

Instant download

Prompt

You are a Commercial Manager preparing a cashflow forecast for a UK construction project. Generate a monthly cashflow forecast based on the following:

Project Details:
- Project: [PROJECT NAME]
- Contract Value (including approved variations): [VALUE, e.g., £14,200,000]
- Start on Site Date: [DATE, e.g., January 2025]
- Planned Completion Date: [DATE, e.g., March 2026]
- Contract Duration: [MONTHS, e.g., 15 months]
- Current Month: [MONTH, e.g., Month 5 of 15]
- Retention Percentage: [%, e.g., 3%]
- Payment Terms: [TERMS, e.g., Monthly valuations, 14 days for payment]
- Front-End Loading: [YES/NO and brief note, e.g., Yes — significant substructure and steel package in first 4 months]

Expenditure Profile Characteristics:
- Early Works (Months 1-3): [DESCRIPTION, e.g., Enabling works, piling, substructure — moderate spend]
- Peak Construction (Months 4-10): [DESCRIPTION, e.g., Frame, envelope, and M&E rough-in — high spend period]
- Fit-Out & Commissioning (Months 11-15): [DESCRIPTION, e.g., Fit-out, commissioning, external works — declining spend]

Generate:
1. Monthly Cashflow Table with columns:
   - Month Number and Calendar Month
   - Monthly Expenditure (cost)
   - Cumulative Expenditure
   - Monthly Valuation (income)
   - Cumulative Valuation
   - Retention Held
   - Net Cash Position

2. Cashflow Summary showing:
   - Total forecast expenditure vs contract value
   - Peak monthly expenditure month and amount
   - Maximum cash funding requirement and the month it occurs
   - Forecast margin and margin percentage

3. S-Curve Description — describe the shape of the cumulative expenditure curve in text (since we cannot draw a graph), noting the inflection points and the months of peak activity

4. Key Assumptions and Risks to the cashflow forecast

Ensure the expenditure profile follows a realistic S-curve pattern for a UK construction project of this type.

Use Case

Use at project start or during monthly commercial reporting to produce or update the cashflow forecast. Input the project financials and the AI will generate a realistic monthly profile based on the project characteristics.

Recommended Tool

ChatGPT
OpenAI's conversational AI assistant. Ideal for drafting reports, analysing data, and generating construction documentat...
AI AssistantFree / Plus $20/mo
Learn more →

Related Guide

AI for Cost Estimation: A Complete Guide
How to use AI tools to speed up cost estimation, from preliminary budgets to detailed BOQs. Practical workflows for QS a...
Intermediate12 min read
All 50 Prompts

Get every prompt in one pack

Stop copy-pasting one prompt at a time. The Construction AI Prompt Pack includes all 50 workflows as editable documents, organised by role, ready to use offline.

£29one-time
Get the Prompt Pack

Instant download. Editable files.

Try our software

Want these prompts pre-built?

AI Construction Copilot has all these workflows ready to run — no copy-pasting needed. Built specifically for construction professionals.

Try Free
Free newsletter

Get AI Tips Weekly

New construction AI workflows, prompts, and templates delivered to your inbox every week.

Subscribe Free

No spam. Unsubscribe anytime.