We use cookies on our website to help you navigate efficiently and perform certain functions. A Cookie is a small piece of data (text file) stored on your computer or mobile device by your web browser. We may use Cookies to personalize the content that you see on our Website and to identify the areas of our Website that you have visited.Those cookies are set by us and called first-party cookies. We also use third-party cookies that help us analyze how you use this website, store your preferences, and provide the content and advertisements that are relevant to you and aide our marketing efforts. Most web browsers can be set to disable the use of Cookies. However, if you disable Cookies, you may not be able to access functionality on our Website correctly or at all.
Necessary cookies are required to enable the basic features of this site, such as providing secure log-in or adjusting your consent preferences. These cookies do not store any personally identifiable data.
Functional cookies help perform certain functionalities like sharing the content of the website on social media platforms, collecting feedback, and other third-party features.
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics such as the number of visitors, bounce rate, traffic source, etc.
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Advertisement cookies are used to provide visitors with customized advertisements based on the pages you visited previously and to analyze the effectiveness of the ad campaigns.
In addition to cookies, some information may automatically be collected as you browse our Website, such as type of browser, operating system, domain name or IP address.
The client, an Endowment Fund asked the TresVista team to create a performance scorecard to perform quantitative and qualitative analysis of any fund manager. The analysis was a part of the standard due diligence process of underwriting a new fund and/or re-investing in an existing fund manager. The client wanted comprehensive intel on each of the firm’s portfolio companies which can provide quick guidance in the initial due diligence process. The final deliverable was expected to generate actionable insights which can help in the due diligence process
To design a performance scorecard to perform quantitative and qualitative analysis of any fund manager.
The TresVista team followed the following process:
• The team had multiple discussions with the client and came up with metrics that could be considered while building the template
• The team performed desk research and started building the template
• Once the team had all the metrics, the workbook was divided into three segments: Data Input tabs, Calculation tabs, Output tabs. For segment, there were further tabs which were interlinked and made the whole template more dynamic
The major hurdles faced by the TresVista team were:
• Developing an in-depth and comprehensive template and come up with the performance metrics
• The information pertaining to the portfolio companies was not readily available in the dataroom provided by the client. The team spent considerable amount of time on research for the data relevant to analysis
• Understanding the scoring criteria provided by the client and making a comprehensive list of various metrics (including asset class, loss ratio, investment pace etc.)
• Another hurdle was to make the workbook more efficient and automated
The team carried out desk research and referred to the previous models the team had worked on to come up with the excel template. The team also scheduled regular calls and follow-ups with the client regarding the performance metrics. The team spent a considerable amount of time on research to find out the missing data relevant to portfolio company analysis. With time and regular discussions with the client, the team came up with the set metrics for different asset classes to rank the scorecard.
The TresVista team aimed to create a template that would be dynamic and catered to all types of fund managers (Buyout funds, Venture funds, etc.). Post discussion with the client, the team included a few qualitative aspects along with the quantitative ones and added a new tab related to summary of key terms, alignment between team members, portfolio companies’ operational milestones since inception, etc. The TresVista team helped to reduce the total hours to analyze one underwriting from 80 to 24 hours.
