{"id":368,"date":"2023-06-18T18:26:39","date_gmt":"2023-06-18T18:26:39","guid":{"rendered":"http:\/\/www.dealsplus.io\/blog\/?p=368"},"modified":"2023-08-21T08:43:23","modified_gmt":"2023-08-21T08:43:23","slug":"the-cap-table-data-challenge-for-private-equity-funds","status":"publish","type":"post","link":"https:\/\/www.dealsplus.io\/blog\/the-cap-table-data-challenge-for-private-equity-funds\/","title":{"rendered":"The cap table data challenge for private equity funds"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"368\" class=\"elementor elementor-368\" data-elementor-settings=\"{&quot;ha_cmc_init_switcher&quot;:&quot;no&quot;}\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3b9a52a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3b9a52a\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7b53439\" data-id=\"7b53439\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-69f07c8 elementor-widget elementor-widget-image\" data-id=\"69f07c8\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"800\" height=\"431\" src=\"https:\/\/www.dealsplus.io\/blog\/wp-content\/uploads\/2023\/06\/Image-18-06-2023-at-19.48-1024x552.jpeg\" class=\"attachment-large size-large wp-image-380\" alt=\"\" srcset=\"https:\/\/www.dealsplus.io\/blog\/wp-content\/uploads\/2023\/06\/Image-18-06-2023-at-19.48-1024x552.jpeg 1024w, https:\/\/www.dealsplus.io\/blog\/wp-content\/uploads\/2023\/06\/Image-18-06-2023-at-19.48-300x162.jpeg 300w, https:\/\/www.dealsplus.io\/blog\/wp-content\/uploads\/2023\/06\/Image-18-06-2023-at-19.48-768x414.jpeg 768w, https:\/\/www.dealsplus.io\/blog\/wp-content\/uploads\/2023\/06\/Image-18-06-2023-at-19.48-1536x828.jpeg 1536w, https:\/\/www.dealsplus.io\/blog\/wp-content\/uploads\/2023\/06\/Image-18-06-2023-at-19.48.jpeg 1843w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2994e36 elementor-widget elementor-widget-text-editor\" data-id=\"2994e36\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif; text-indent: -18pt;\"><b>1.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-weight: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: 'Times New Roman';\">&nbsp;&nbsp;&nbsp;&nbsp; <\/span><\/b><b>Private Equity ownership structures<\/b><\/p>\n<p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif;\">Private equity funds use management equity plans to incentivise and align interest with management teams. For commercial and tax reasons, management equity plans are implemented by issuing different instruments in a portfolio company\u2019s capital structure \u2013 generally referred to as strip and sweet equity instruments. Each instrument has different terms that determine their value under a distribution waterfall (for example, strip equity will have a built-in return before sweet equity can participate).<\/p>\n<p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif;\"><br><\/p>\n<p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif;\">\n<\/p><p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif;\">\n<\/p><p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif; text-indent: -18pt;\"><b>2.&nbsp; Ownership data<\/b><\/p>\n<p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif;\">Due to the ownership structure described above, each private equity portfolio company has multiple instruments held across many shareholders (fund entities, management shareholders, and co-investors).<\/p>\n<p style=\"margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;\">\n<\/p><table style=\"margin-left: 36pt; border: none;\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td style=\"width: 105.5pt; border-width: 1pt; border-color: windowtext; padding: 0cm 5.4pt;\" valign=\"top\" width=\"141\">\n<p style=\"margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;\"><b>Portfolio type<\/b><\/p>\n<\/td>\n<td style=\"width: 99.25pt; border-top-width: 1pt; border-top-color: windowtext; border-right-width: 1pt; border-right-color: windowtext; border-bottom-width: 1pt; border-bottom-color: windowtext; border-left: none; padding: 0cm 5.4pt;\" valign=\"top\" width=\"132\">\n<p style=\"margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;\"><b>Number of instruments<\/b><\/p>\n<p style=\"margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;\"><b>(Strip &amp; Sweet equity)<\/b><\/p>\n<\/td>\n<td style=\"width: 99.2pt; border-top-width: 1pt; border-top-color: windowtext; border-right-width: 1pt; border-right-color: windowtext; border-bottom-width: 1pt; border-bottom-color: windowtext; border-left: none; padding: 0cm 5.4pt;\" valign=\"top\" width=\"132\">\n<p style=\"margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;\"><b>Number of shareholders (fund entities, management, co-invest)<\/b><\/p>\n<\/td>\n<td style=\"width: 92.15pt; border-top-width: 1pt; border-top-color: windowtext; border-right-width: 1pt; border-right-color: windowtext; border-bottom-width: 1pt; border-bottom-color: windowtext; border-left: none; padding: 0cm 5.4pt;\" valign=\"top\" width=\"123\">\n<p style=\"margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;\"><b>Average shareholdings in the portfolio<\/b><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 105.5pt; border-right-width: 1pt; border-right-color: windowtext; border-bottom-width: 1pt; border-bottom-color: windowtext; border-left-width: 1pt; border-left-color: windowtext; border-top: none; padding: 0cm 5.4pt;\" valign=\"top\" width=\"141\">\n<p style=\"margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;\">Ownership thinly spread<\/p>\n<\/td>\n<td style=\"width: 99.25pt; border-top: none; border-left: none; border-bottom-width: 1pt; border-bottom-color: windowtext; border-right-width: 1pt; border-right-color: windowtext; padding: 0cm 5.4pt;\" valign=\"top\" width=\"132\">\n<p style=\"margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;\">3 \u2013 5<\/p>\n<\/td>\n<td style=\"width: 99.2pt; border-top: none; border-left: none; border-bottom-width: 1pt; border-bottom-color: windowtext; border-right-width: 1pt; border-right-color: windowtext; padding: 0cm 5.4pt;\" valign=\"top\" width=\"132\">\n<p style=\"margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;\">20<\/p>\n<\/td>\n<td style=\"width: 92.15pt; border-top: none; border-left: none; border-bottom-width: 1pt; border-bottom-color: windowtext; border-right-width: 1pt; border-right-color: windowtext; padding: 0cm 5.4pt;\" valign=\"top\" width=\"123\">\n<p style=\"margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;\">80<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 105.5pt; border-right-width: 1pt; border-right-color: windowtext; border-bottom-width: 1pt; border-bottom-color: windowtext; border-left-width: 1pt; border-left-color: windowtext; border-top: none; padding: 0cm 5.4pt;\" valign=\"top\" width=\"141\">\n<p style=\"margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;\">Ownership moderately spread<\/p>\n<\/td>\n<td style=\"width: 99.25pt; border-top: none; border-left: none; border-bottom-width: 1pt; border-bottom-color: windowtext; border-right-width: 1pt; border-right-color: windowtext; padding: 0cm 5.4pt;\" valign=\"top\" width=\"132\">\n<p style=\"margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;\">3 \u2013 5<\/p>\n<\/td>\n<td style=\"width: 99.2pt; border-top: none; border-left: none; border-bottom-width: 1pt; border-bottom-color: windowtext; border-right-width: 1pt; border-right-color: windowtext; padding: 0cm 5.4pt;\" valign=\"top\" width=\"132\">\n<p style=\"margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;\">50<\/p>\n<\/td>\n<td style=\"width: 92.15pt; border-top: none; border-left: none; border-bottom-width: 1pt; border-bottom-color: windowtext; border-right-width: 1pt; border-right-color: windowtext; padding: 0cm 5.4pt;\" valign=\"top\" width=\"123\">\n<p style=\"margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;\">200<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 105.5pt; border-right-width: 1pt; border-right-color: windowtext; border-bottom-width: 1pt; border-bottom-color: windowtext; border-left-width: 1pt; border-left-color: windowtext; border-top: none; padding: 0cm 5.4pt;\" valign=\"top\" width=\"141\">\n<p style=\"margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;\">Ownership broadly spread<\/p>\n<p style=\"margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;\">\n<\/p><\/td>\n<td style=\"width: 99.25pt; border-top: none; border-left: none; border-bottom-width: 1pt; border-bottom-color: windowtext; border-right-width: 1pt; border-right-color: windowtext; padding: 0cm 5.4pt;\" valign=\"top\" width=\"132\">\n<p style=\"margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;\">3 \u2013 5<\/p>\n<\/td>\n<td style=\"width: 99.2pt; border-top: none; border-left: none; border-bottom-width: 1pt; border-bottom-color: windowtext; border-right-width: 1pt; border-right-color: windowtext; padding: 0cm 5.4pt;\" valign=\"top\" width=\"132\">\n<p style=\"margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;\">100+<\/p>\n<\/td>\n<td style=\"width: 92.15pt; border-top: none; border-left: none; border-bottom-width: 1pt; border-bottom-color: windowtext; border-right-width: 1pt; border-right-color: windowtext; padding: 0cm 5.4pt;\" valign=\"top\" width=\"123\">\n<p style=\"margin: 0cm; font-size: 12pt; font-family: Calibri, sans-serif;\">400<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif;\"><span style=\"font-size: 12pt;\"><b><u>*Note:<\/u><\/b><\/span><span style=\"font-size: 12pt;\"> A shareholding is a shareholder\u2019 interest in one instrument; one shareholder may have multiple shareholdings in a portfolio if they are invested in more than one instrument.<i><\/i><\/span><\/p>\n<p><\/p>\n<p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif;\"><i style=\"font-size: 12pt; color: var( --e-global-color-text ); font-weight: var( --e-global-typography-text-font-weight ); background-color: var(--bs-body-bg); display: inline !important;\"><\/i>Extrapolating the above across all the portfolios held by a fund, there would be thousands of shareholdings (assuming a fund has 10 or more portfolios). This data is rarely available in one place and exists in a fragmented form across multiple files and systems. This can lead to wasted time and cost during portfolio valuations and exit events. &nbsp;<\/p>\n<p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif;\"><br><\/p>\n<p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif;\">\n<\/p><p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif;\">\n<\/p><p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif; text-indent: -18pt;\"><b>3.&nbsp; Ownerships and economics are changing<\/b><\/p>\n<p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif;\">The ownership position and cap table economics at the portfolio level will change throughout the holding period due to events at the portfolio level \u2013 e.g., drawdowns, distributions, resets, joiners, leavers, buybacks, interest accruals on hurdle tracking instruments such as preference shares or loans. Without a standardised system, it can be difficult to track and monitor these changes efficiently across a fund\u2019s portfolio.<\/p>\n<p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif;\"><br><\/p>\n<p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif;\">\n<\/p><p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif;\">\n<\/p><p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif;\">\n<\/p><p style=\"margin: 0cm 0cm 0cm 36pt; text-indent: -18pt;\"><span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; line-height: normal;\"><span style=\"font-family: Calibri, sans-serif;\"><b>4.&nbsp;<\/b><\/span><\/span><span style=\"font-family: 'Times New Roman'; font-size: 7pt; font-weight: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; line-height: normal;\">&nbsp;&nbsp;<\/span><b style=\"font-family: Calibri, sans-serif; font-size: 12pt;\">Impact on valuations and waterfall<\/b><\/p>\n<p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif;\">As each instrument in the cap table has separate terms and rights under the distribution waterfall, the equity value of a portfolio needs to be run through the waterfall to determine the value split between each instrument and shareholding (e.g. to determine the value of what the fund holds versus the non-fund shareholders). This requires accurate ownership data at the valuation (or exit) date. In addition, coupon bearing strip equity instruments such as preference shares and loans require detailed interest schedules tracking each event to determine their value.<\/p>\n<p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif;\"><br><\/p>\n<p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif;\">\n<\/p><p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif;\">\n<\/p><p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif; text-indent: -18pt;\"><b>5.&nbsp; Data quality and availability<\/b><\/p>\n<p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif;\">Most private equity funds and their portfolios do not have real time reliable ownership records available to them. At best, they have static records maintained in excel and other fragmented systems that come at a high time cost and are prone to error.<\/p>\n<p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif;\"><br><\/p>\n<p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif;\">\n<\/p><p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif;\">\n<\/p><p style=\"margin: 0cm 0cm 0cm 36pt; text-indent: -18pt;\"><span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; line-height: normal;\"><span style=\"font-family: Calibri, sans-serif;\"><b>6.&nbsp;&nbsp;<\/b><\/span><\/span><span style=\"font-family: 'Times New Roman'; font-size: 7pt; font-weight: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-kerning: auto; font-optical-sizing: auto; font-feature-settings: normal; font-variation-settings: normal; font-stretch: normal; line-height: normal;\">&nbsp;<\/span><b style=\"font-family: Calibri, sans-serif; font-size: 12pt;\">A single source of truth<\/b><\/p>\n<p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif;\">Real time and reliable records require a single source of truth system that can digitise, administer, and validate private equity portfolio ownership structures and cap tables. Such a system will have the necessary intelligence, workflows, and access controls to help administer and validate these structures at both the fund and portfolio level. &nbsp;<\/p>\n<p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif;\"><br><\/p>\n<p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif;\">\n<\/p><p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif;\">\n<\/p><p style=\"margin: 0cm 0cm 0cm 36pt; font-size: 12pt; font-family: Calibri, sans-serif;\"><em><b style=\"font-size: medium;\"><span style=\"font-size: 12pt;\">DealsPlus helps private equity fund and portfolios digitise, administer, and validate ownership structures and cap tables. &nbsp;Our platform adds value across valuation, finance, tax, legal, and transaction workflows for both the fund and its portfolios.<\/span><\/b><\/em><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>1.&nbsp;&nbsp;&nbsp;&nbsp; Private Equity ownership structures Private equity funds use management equity plans to incentivise and align interest with management teams. For commercial and tax reasons, management equity plans are implemented by issuing different instruments in a portfolio company\u2019s capital structure \u2013 generally referred to as strip and sweet equity instruments. Each instrument has different terms [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-368","post","type-post","status-publish","format-standard","hentry","category-private-equity"],"_links":{"self":[{"href":"https:\/\/www.dealsplus.io\/blog\/wp-json\/wp\/v2\/posts\/368","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dealsplus.io\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dealsplus.io\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dealsplus.io\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dealsplus.io\/blog\/wp-json\/wp\/v2\/comments?post=368"}],"version-history":[{"count":18,"href":"https:\/\/www.dealsplus.io\/blog\/wp-json\/wp\/v2\/posts\/368\/revisions"}],"predecessor-version":[{"id":411,"href":"https:\/\/www.dealsplus.io\/blog\/wp-json\/wp\/v2\/posts\/368\/revisions\/411"}],"wp:attachment":[{"href":"https:\/\/www.dealsplus.io\/blog\/wp-json\/wp\/v2\/media?parent=368"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dealsplus.io\/blog\/wp-json\/wp\/v2\/categories?post=368"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dealsplus.io\/blog\/wp-json\/wp\/v2\/tags?post=368"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}