Skip to main content
Data Dare cash flow planning L1 sticker: the findi360 mascot analysing Mizan Manufacturing: The 13-Week Cash Forecast — Cash Flow Planning.

DD-CFP-001

Mizan Manufacturing: The 13-Week Cash Forecast — Cash Flow Planning

Every line on Mizan Manufacturing's bank account from January 2024 to September 2026 - 20,000 rows, each with what it was for - every customer and supplier invoice with the day its cash moved, the treasury calendar of payroll, tax, interest and dividends up to next year, the customers and suppliers, and a calendar with forecast weeks. On 1 January the treasurer forecasts the next 13 weeks: build that forecast, then see where it went wrong.

  • Cash Flow Planning
  • L1 · XLSX
  • ~20,346 rows
  • 5 tables
  • 30 questions
Get the data 30 questions
Free account: download the data, check your answers and earn a certificate. Create it → More Cash Flow Planning: L2

Get the data

v1.0 · 4 files

Files are for members. A free account takes a minute, and you come straight back here.

Create a free account Sign in
  • Question Book PDF DD-CFP-001_Question_Book.pdf 1.2 MB · v1.0
  • Dataset Documentation / Data Dictionary XLSX DD-CFP-001_Data_Dictionary.xlsx 11.3 KB · v1.0
  • Business Introduction PDF DD-CFP-001_Business_Introduction.pdf 614.3 KB · v1.0
  • Raw fact data DD-CFP-001_CashFlowPlanning.xlsx 2.1 MB · v1.0

Questions

Open one to discuss it
  1. Q001 Easy Cash at the end of 2025
  2. Q002 Easy Cash today
  3. Q003 Easy Collected in 2025
  4. Q004 Easy Paid to suppliers in 2025
  5. Q005 Easy Payroll in 2025
  6. Q006 Easy Money nobody could place
  7. Q007 Easy Net cash flow of 2025
  8. Q008 Easy The 2026 dividend
  9. Q009 Easy The Monday payment run
  10. Q010 Easy What customers owed
  11. Q011 Easy What the company owed
  12. Q012 Easy Open customer invoices
  13. Q013 Easy Payroll planned for 2027
  14. Q014 Easy Tax planned for 2027
  15. Q015 Easy The first week of the year
  16. Q016 Easy Supplier invoices nobody pays
  17. Q017 Easy Interest paid in 2025
  18. Q018 Easy The best month for collections
  19. Q019 Medium How late the biggest customer pays
  20. Q020 Medium Forecast receipts
  21. Q021 Medium Forecast supplier payments
  22. Q022 Medium The known payments
  23. Q023 Medium Where the forecast ends
  24. Q024 Medium Where cash really ended
  25. Q025 Medium Cash the forecast could not see
  26. Q026 Medium The best week
  27. Q027 Medium The tightest month-end
  28. Q028 Hard The forecast low point
  29. Q029 Hard Forecasting on terms
  30. Q030 Very Hard How good was last year's forecast

General discussion

Anything about this dataset that is not one question — loading the files, which tool, how you set it up.

A free account takes a minute. Your draft is kept while you sign in. Need help? Message us

Create a free account Sign in