Intermediate

13-week cash flow forecast with receipts/disbursements

Builds a 13-week cash forecast structure and assumptions, including a weekly receipts/disbursements schedule. Useful for liquidity management and turnaround planning.

Build a 13-week cash flow forecast for {company_name}.

Inputs:
- Starting cash: {starting_cash}
- AR collections assumptions: {ar_collections}
- AP payment plan: {ap_payment_plan}
- Payroll and taxes schedule: {payroll_taxes}
- Debt service: {debt_service}
- Other cash items: {other_cash_items}
- Seasonality/events: {seasonality_events}

Output:
1) Weekly cash forecast table: Beg cash, Inflows, Outflows, Net, End cash.
2) Assumptions register and “what changed this week” section.
3) Liquidity risks and mitigation actions.
4) Data needed to improve forecast accuracy (top 5).

Make it simple enough to update weekly.

Related Prompts