The client, a portfolio company of a Private Equity firm, wanted the TresVista Team to prepare various financial analyses for their presentation for their monthly board meeting. The board meeting required the client to share an update on the company’s financial performance, which entailed financial statements and supplemental information such as customer sales, inventory, raw material purchases, etc.
To perform various financial analyses such as period variances, sales & purchase trends, customer margins, etc., and incorporate them into the monthly board presentation.
The TresVista Team followed the following process:
The major hurdles faced by the TresVista Team were the tight timelines and the unorganized data pull from the client’s ERP, thereby requiring the team to correlate data points across files to create various analyses. The team overcame this issue by creating an automized template that is quick to update.
The TresVista Team built a template for the client that was easy to update each month and tracked metrics in a singular file. The creation of various analyses related to customer buying behavior helped the client provide a better understanding of the business to the board members. The team also helped the client prepare a budget for the entire year and then create a reforecast based on the half-yearly performance of the company.