#77finance & business
Build a 13-Week Cash Flow Forecast
Projects business cash needs and identifies the weeks at risk.
Base prompt
Using these opening balances, receivables, payables, payroll, taxes, and sales assumptions: [data], build a 13-week cash flow forecast. Separate committed amounts from estimates, show weekly opening and closing cash, and reconcile formulas. Model base, delayed-payment, and lower-sales cases. Flag the first week below [minimum cash], the main drivers, and actions with owners. Do not invent missing balances or payment dates.Follow-up steps
- 1
Refine and verify
Tests the output against the original goal and improves its practical usefulness.
step 1Update the forecast with actuals from the first two weeks, explain forecast variance, and revise the remaining weeks.
Comments0
No comments yet.
