Wooble
Build your proof

Wooble FastTrack · Level 3: Advanced

13-week cash flow forecast exercise

Cash flow forecast and runway, at PagdandiSimulation

The Series A won't land before January. Build a 13-week cash forecast and find the week the money runs below the board's minimum.

  • You're the AI-enabled Data & Finance Analyst
  • About 90 minutes, no timer
  • 7 days to hand in
  • Checked the moment you hand in
  • Free
Join the track

Free. Level 3 opens once you pass 2 Level 2 problems. Start at Level 1.

The situation

Aditi JoshiCo-founder & CEO, Pagdandi

Morning, and welcome!

We're raising our Series A, but the money won't land before January. Until then we live on what's in the bank, and the board has one rule: never close a week below ₹20,00,000.

I need a 13-week cash forecast, starting this week. From it:

  • What we'll have at the end of week 4, and at the end of week 13.
  • The lowest we'll get to, week by week.
  • How much we'd need (raised, borrowed or cut) to never close a week below ₹20,00,000.
  • The first week we'd close below ₹20,00,000, if we do nothing.
  • For every open invoice, the week we can expect its money.

Our customers rarely pay on the due date, and everyone knows who's slow. Use their payment history, not hope.

Use any tools you like, AI included. And write me a short note: what should we do before that week arrives?

Thanks, Aditi

When you start, you get Pagdandi's handbook and your own data: the same story as everyone else's, with different records, so your answers are yours alone.

What you hand in

  1. 1End of week 4: Cash at the close of week 4 (Sunday 1 November) (in whole rupees)
  2. 2End of week 13: Cash at the close of week 13 (Sunday 3 January) (in whole rupees)
  3. 3The lowest close: The lowest of the 13 weekly closing balances (negative if we'd be overdrawn) (in whole rupees)
  4. 4What we'd need: How much more cash it takes for no week to close below ₹20,00,000 (in whole rupees)
  5. 5Receipts: A table with two columns, invoice_id and expected, uploaded as a CSV or pasted.
  6. 6The first week below ₹20,00,000: If we do nothing, which is the first week to close below ₹20,00,000?
  7. 7Your working: The spreadsheet, SQL or notebook that produces your answers, as a link anyone can open.
  8. 8A note to Aditi: 200 words at most.
  9. 9How you used AI: Your prompts or the chat, if you used it.

Your figures, your week and your receipts are checked against your own data the moment you hand in. The pass mark is 70 of 100, and the lowest close must be right. Hand in as often as you need; every hand-in is counted.

What passing earns

  • A step to your AI-enabled Data & Finance Analyst · Level 3 badge: 1 of the 2 passes it needs.
  • A badge page that anyone can check, which you can add to LinkedIn as a certification.
  • A project on your Wooble profile made from your hand-in, when you choose to add it.
  • 50 points for the pass.
  • Finish every level for the track certificate: Wooble FastTrack Certified: AI-enabled Data & Finance Analyst.

Level 3 opens once you pass 2 Level 2 problems.

More in Level 3