Working Capital Model

Client: A professional services firm investing heavily in growth with tight cash flow

A professional services firm was investing heavily in growth and found their cash flow tight. They hired Sapling to develop an Excel-based tool to be used by the bookkeeper to assist with identifying upcoming “cash crunches”

3 Key Insights:

  • We developed a flexible working capital tool leveraging data validation and conditional formatting to assist the bookkeeper with keeping it up-to-date with information from the accounting system
  • We provided hands-on training of the bookkeeper and business owner to help them understand the update process and how to interpret model outputs
  • We continually give the company feedback on upcoming issues
Working Capital Model