New Model Build

Situation

  • Our client was seeking greater visibility of its near term cash requirements and asked us to develop a comprehensive short term cashflow model.

Swan Activity

  • Reviewed Company information to identify key cashflow data drivers including sales and purchase ledger processes
  • Designed an efficient input process to enable rapid updating
  • Developed sensitivity functionality
  • Analysis of weekly actual cash flows to inform the forecast view

Outcome

  • Model was used weekly by management to manage effectively the cash position