Model Adaptation and Upgrade

Situation

  • Our client required ongoing reporting of their 13 week cash flow forecast to support their refinancing exercise. The company had started to put a short term cash flow process in place, however no individual in the business had full ownership of the forecast

Swan Activity

  • Obtained an understanding of current reporting and key contributors to the existing process
  • Adapted the existing forecast to improve quality of outputs and provide greater clarity on week on week variances
  • Improved the weekly update process
  • Developed functionality to enable risks to be better understood
  • Improved the weekly update process to be quicker and more accurate

Outcome

  • The model provided management with more time to review than prepare it and gave potential lenders the necessary visibility to enable them to agree a new financing arrangement.
  • The model continues to be used on a weekly basis