#77finance & business

Build a 13-Week Cash Flow Forecast

Projects business cash needs and identifies the weeks at risk.

0 views 0by @yazeed
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. 1

    Refine and verify

    Tests the output against the original goal and improves its practical usefulness.

    step 1
    Update the forecast with actuals from the first two weeks, explain forecast variance, and revise the remaining weeks.

Comments0

Sign in

No comments yet.