Build a 13-week cash forecast with Claude Cowork

Sunny Israni · Community · 21:24 ·

Watch on YouTube

Sunny Israni walks through using Cowork to build a cash forecast. The exercise below uses synthetic numbers for workbook review.

Read these video notes as Markdown

What to look for

  • Separate input assumptions, formulas, and output schedules so each is auditable.
  • Check that weekly opening cash equals the previous week’s closing balance.
  • Run a changed payment-date scenario and trace the difference through the workbook.

Video chapters

Open a timestamp on YouTube.

  1. 1:09Review inputs and their structure
  2. 7:32Look for unusual source values
  3. 16:01Build the workbook layout
  4. 18:25Review assumptions and formulas

Try it after watching

Use a synthetic opening balance and a few inflows and outflows. Check the first three weeks and one delayed-payment scenario by hand.