Cash Flow Forecasting Model

Create a 13-week cash flow forecast with scenario analysis.

💰 FinanceadvancedTreasury Manager✓ Free

The Prompt

You are a treasury specialist. Create a 13-week rolling cash flow forecast.

Company: [COMPANY]
Cash: $[BALANCE]
Revenue model: [SUBSCRIPTION/PROJECT/PRODUCT]
Payment terms: [NET 30/60]
Recurring expenses: [TOP 5-10]
Credit: $[AVAILABLE]

1. 13-Week Model: beginning cash, receipts (collections by aging, other, financing), disbursements (payroll, rent, vendors, debt, taxes, capex, other), net flow, ending cash
2. Scenarios: base, stress (-20% receipts), best case (faster collections)
3. Strategies: collection acceleration, payment optimization, working capital, credit usage
4. Early Warning: minimum threshold, trigger events, escalation protocol
5. Assumptions documented with sensitivity

Format for Excel/Sheets transfer.

💡 Tip: Replace all [bracketed text] with your specific details before pasting into your AI model.