Alert - Michigan Public Act 38 of 2010 Supersedes Kmart Decision and Reverses Notice Instructing Federal Disregarded Entities to File Single Business Tax Returns

Data analytics can help private equity firms (PE firms) realize important benefits during due diligence — it can streamline the diligence process, reduce seller deal fatigue, and increase post-merger value creation. Considering the increasing cost of capital, labor costs and inflation, we are seeing fewer exits in 2023 and find that our clients are being more deliberate with acquisitions and are choosing to focus on value creation during these elongated hold periods. Through technology-enabled data gathering and analysis across all transactions, PE firms can better optimize human efforts, accelerate deal throughput, and reduce portfolio risk. To demonstrate, let’s take a look at the following four data analytics use cases:

1. Accelerate traditional due diligence efforts with data analytics

Extracting timely, reliable data from your target’s accounting and ERP systems is often a challenge. Funds that use data analytics tools and services such as application programming interfaces (APIs) spend a lot less time going back to the target for missing data or reformatting reporting extracts. As a result, they’re more likely to identify data quality issues earlier in the process, if not avoid them altogether.

Standardized data models can be built to support like transactions, which allows analysts to eliminate costly data preparation and manipulation of general ledger, sales, customer, vendor, expense, and inventory data. Similarly, pre-built visualizations accelerate analyses of revenue, EBITDA, and cash projections, and support detailed margin analyses by product, customer, geography, and similar dimensions.

With our support, applying even a modest utilization of data management and business intelligence tools can save PE firms several hours in information requests and data prep. As we’ve partnered with our PEG clients over time, we’ve been able to further tailor specific solutions to their investment models, industries, platforms, and decision-making processes. This has cut days and even weeks from the tedious work of cleansing, transforming, and visualizing target data.

Understanding e-commerce growth trends in consumer goods businesses

We’ve seen increased investment activity in consumer packaged goods (CPG). Investors believe many products will experience sustained demand but need to accurately understand the underlying trends driving demand, particularly in new digital and e-commerce channels.

Because e-commerce growth often hasn’t maintained the same net margin as in-store sales, it’s important to understand — quickly — how the changes in mix and volume may or may not support future revenue and profit projections. Combing through large customer sales datasets to identify the impact of pandemic-influenced growth in e-commerce versus cannibalized in-store sales is a critical CPG analysis — an effort made timely with analytics technologies, and without which would be daunting and prohibitive.

Enabling a deeper dive into operational KPIs in healthcare

Some of the highest value creation in the diligence process comes from the ability to create transparency and insight beyond general ledger information, drilling down through financial results into underlying operational source data. However, this data can also be harder to get to, more complex, and less standardized.

Typically, numerous niche applications support the operations in any given industry or sector, with varying levels of maturity in their respective data tables. Often, these aren't well integrated into their sister accounting and financial reporting systems. Physician practice management systems are one common example. By applying some of the data modeling and standardization strategies described above, we’ve been able to consistently serve up timely operational and financial KPI trend data and insights that aren’t possible using traditional tabular analyses performed in spreadsheets.

By focusing in on key performance indicators (KPIs) related to new and active patient data, production per visit, and collection rates, and then drilling down into the underlying medical practice system data, an investor can quickly identify location-specific opportunities and risks that often can influence deal structure, pricing, and terms.

Inventory cost analytics in asset-based transactions

The ability to accelerate the preparation, modeling, and visualization of inventory cost data can also directly impact the structuring of an asset-based deal. If not discovered upfront, inventory valuation issues can result in misstated returns and unforeseen liquidity issues soon after the transaction closes. It usually takes multiple, complex datasets to generate inventory cost insights — insights that are extremely difficult and time-consuming to uncover using spreadsheets.

2. Challenge assumptions

In order to manage the cost and duration of a diligence process relative to the value and risk of the transaction, investors often rely on information that’s been deemed credible or accurate by various parties internal and external to the target company. But PE firms can miss major threats when they assume data quality or don’t adequately scrutinize information.

Analytics technologies can be used in a forensic manner, allowing the PEG to “trust but verify” previously reviewed and even audited financial statements and projections. Using common data discovery, filtering, and validation techniques, we’ve helped our PEG clients retest financials and projections against established fund metrics, benchmarks, and assumptions to quickly identify abnormalities and potential risks. Such efforts can uncover significant adjustments, including revenue recognition and normalizing EBITDA adjustments, that the PEG’s diligence team — or even third-party auditors — might not otherwise identify.

3. Grow advanced analytics capabilities to tap into unrealized value and foresight

The examples above primarily illustrate descriptive analytics, which answer questions such as, “What happened?” or “What’s the accurate value or projected future value?” Diagnostic analytics goes further to uncover root causes — “Why did this happen?” — and predictive analytics focuses on the future: “What will happen?”

These kinds of insights require more complicated data architecture (e.g., complex joins, transformations, data matching, and calculations), and they commonly employ advanced analytics capabilities. These include statistical analysis, what-if scenario modeling, and artificial intelligence, including machine learning. This depth of analysis currently isn’t merited for a prototypical early-stage investment, but we expect that to change as analytics technologies and related skills in the labor market mature. As such, it’s important to have a vision and plan for how you’ll continue to build and mature your capabilities.

Taking the earlier CPG example, the next level of analysis moves beyond identifying what's happening with consumer demand to evaluating why it’s happening and what will happen if the same trends continue. Why are e-commerce margins lower in the first place, and what can be done to increase them?

By presenting sales volume and pricing trends by category alongside marketing investment, trade, and promotional spending as well as supply chain cost data, analysts can quickly identify and evaluate potential long-term profitability risk and opportunities in both in-store and ecommerce channel sales forecasts.

The level and complexity of analysis in this type of margin intelligence is extremely difficult if not impossible to do with spreadsheets and manual data integration and transformation efforts. However, sophisticated data models in high-impact, high-complexity analyses help our clients see the critical story being told by the data. Often, this is the insight needed to signal performance issues bound to arise shortly after closing; in other cases, the insights can point to opportunities for achieving alpha.

4. Leverage data assets from the diligence phase to improve integration outcomes

Any acquisition is disruptive to business, but the faster you can define and align portfolio company leadership with the desired target state and the execution of a plan to get there, the faster you can drive toward profitable growth.

In our experience, a data-driven approach to integration allows for more accurate, timely optimization of business activities, increased accountability and alignment around decision-making, higher change adoption rates, and lower turnover. Digitalization and automation also reduce the post-close risks associated with undocumented processes and loss of significant institutional knowledge.

Let’s revisit the physician practice use case above. Patient leakage data evaluated during the diligence phase can serve as a foundation for a 100-day plan to improve practice economics by practitioner. By investing further in the data, resources, and capabilities necessary to transform this into a robust sensitivity analysis, the acquirer can quickly set post-acquisition retention rate targets, pricing, demand forecasts, and revenue planning. Maintaining continuity of data and analyses from diligence to integration sets the stage for real-time monitoring of the most critical KPIs and drivers of return on investment, and helps proactively identify the need for early corrective actions.

Don’t wait: Realize the benefits of data analytics during due diligence

Whether you rely on an internal resource or a strategic partner — today’s transaction volume, the fierce war for talent, and the rising affordability of relatively low-tech tools make an increasingly irrefutable case for PE firms to deploy analytics. While it does take some investment upfront, successful analytics programs can be built iteratively and nimbly, enabling PE firms to innovate while keeping overhead costs low.

Have questions about how data analytics can streamline your due diligence processes or drive value throughout the investment life cycle? Feel free to reach out — we’re happy to help.

Looking for more?

Are you looking for more insights to help you navigate the fiercely competitive investment landscape of today? Subscribe to our Private Equity Perspectives to get the information you need, delivered right to your inbox.

Learn More External Test

Learn More Internal Test

Image Testing - Right, Left, and Full Width

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Diam quis enim lobortis scelerisque fermentum dui. Aliquet risus feugiat in ante metus dictum at. Viverra nibh cras pulvinar mattis nunc sed blandit libero volutpat. Molestie ac feugiat sed lectus. Diam vulputate ut pharetra sit amet. Lacus luctus accumsan tortor posuere. Nisi est sit amet facilisis magna etiam tempor orci. Nulla facilisi morbi tempus iaculis urna id. Ut placerat orci nulla pellentesque dignissim. Eu lobortis elementum nibh tellus. Aenean et tortor at risus viverra. Aenean pharetra magna ac placerat vestibulum lectus. Egestas erat imperdiet sed euismod.

Mauris rhoncus aenean vel elit scelerisque mauris pellentesque pulvinar. Id diam vel quam elementum pulvinar etiam non quam. Amet consectetur adipiscing elit ut aliquam purus sit amet. Nunc sed velit dignissim sodales ut eu. Justo donec enim diam vulputate ut pharetra sit. Sem integer vitae justo eget magna fermentum iaculis eu. Odio tempor orci dapibus ultrices in iaculis nunc. Molestie ac feugiat sed lectus vestibulum mattis. Dui ut ornare lectus sit amet est placerat in. Maecenas pharetra convallis posuere morbi. Mi bibendum neque egestas congue quisque egestas diam in arcu. Nulla aliquet porttitor lacus luctus accumsan. Convallis convallis tellus id interdum velit laoreet id donec ultrices. Erat nam at lectus urna. Et ultrices neque ornare aenean. A erat nam at lectus urna duis convallis convallis tellus. Neque vitae tempus quam pellentesque nec nam aliquam. 

Tempor id eu nisl nunc mi. Nec ullamcorper sit amet risus nullam. Pharetra massa massa ultricies mi quis hendrerit dolor magna eget. Ultricies leo integer malesuada nunc vel risus commodo. Tincidunt augue interdum velit euismod in. At ultrices mi tempus imperdiet nulla malesuada. Tortor dignissim convallis aenean et tortor at risus. Ut tristique et egestas quis ipsum suspendisse ultrices. Et malesuada fames ac turpis egestas integer eget aliquet nibh. Quis lectus nulla at volutpat. Facilisi etiam dignissim diam quis. Ullamcorper velit sed ullamcorper morbi tincidunt ornare massa eget egestas. Nulla pharetra diam sit amet nisl suscipit adipiscing bibendum. Mauris pharetra et ultrices neque ornare. Dui faucibus in ornare quam viverra orci sagittis eu volutpat. Dui accumsan sit amet nulla facilisi morbi tempus iaculis urna. Nisl nisi scelerisque eu ultrices vitae.

Tortor id aliquet lectus proin nibh. Quis varius quam quisque id diam vel quam. Faucibus et molestie ac feugiat sed. Ornare arcu dui vivamus arcu felis bibendum ut tristique. Velit aliquet sagittis id consectetur purus. Vivamus at augue eget arcu. Cursus risus at ultrices mi tempus. Sed cras ornare arcu dui vivamus. Ultricies mi quis hendrerit dolor magna eget est lorem ipsum. Ornare arcu odio ut sem nulla. Nulla aliquet enim tortor at auctor. Porta lorem mollis aliquam ut porttitor. Aliquet nibh praesent tristique magna sit amet. Ipsum dolor sit amet consectetur adipiscing elit ut aliquam purus.

In aliquam sem fringilla ut. Mi ipsum faucibus vitae aliquet nec ullamcorper. Scelerisque felis imperdiet proin fermentum. Sapien eget mi proin sed libero. Morbi tristique senectus et netus et malesuada fames ac turpis. Dolor sit amet consectetur adipiscing. Mi tempus imperdiet nulla malesuada pellentesque elit eget gravida cum. Orci eu lobortis elementum nibh. Fringilla ut morbi tincidunt augue interdum velit euismod in. Adipiscing commodo elit at imperdiet dui accumsan sit amet. Felis eget velit aliquet sagittis id consectetur purus. Magna fermentum iaculis eu non diam phasellus vestibulum. Consectetur adipiscing elit pellentesque habitant morbi tristique senectus.

Condimentum mattis pellentesque id nibh tortor id. Condimentum id venenatis a condimentum vitae. Fermentum iaculis eu non diam phasellus vestibulum lorem sed risus. Et ligula ullamcorper malesuada proin. Et malesuada fames ac turpis egestas integer eget aliquet. Viverra nam libero justo laoreet sit amet cursus sit amet. Sapien et ligula ullamcorper malesuada proin libero nunc consequat interdum. Mollis nunc sed id semper risus in hendrerit gravida rutrum. Iaculis at erat pellentesque adipiscing. Interdum velit euismod in pellentesque massa placerat duis ultricies. Amet consectetur adipiscing elit ut aliquam purus sit amet luctus. Nisl rhoncus mattis rhoncus urna neque viverra justo nec. At varius vel pharetra vel turpis nunc eget. 

At quis risus sed vulputate odio ut. Condimentum vitae sapien pellentesque habitant. Nisi vitae suscipit tellus mauris a diam maecenas sed. Amet commodo nulla facilisi nullam vehicula. Integer eget aliquet nibh praesent tristique magna sit amet purus. At tellus at urna condimentum mattis pellentesque id nibh tortor. Commodo quis imperdiet massa tincidunt. Purus viverra accumsan in nisl nisi scelerisque. Arcu felis bibendum ut tristique et egestas quis ipsum suspendisse. Nibh tortor id aliquet lectus proin nibh nisl. Arcu non sodales neque sodales ut etiam sit. Quam quisque id diam vel quam elementum. Duis at tellus at urna condimentum mattis pellentesque id nibh. Sit amet dictum sit amet justo donec enim diam vulputate. Facilisis magna etiam tempor orci eu lobortis elementum. Donec adipiscing tristique risus nec feugiat in fermentum. Imperdiet proin fermentum leo vel orci porta non pulvinar.

Pellentesque elit ullamcorper dignissim cras tincidunt lobortis feugiat. Sed enim ut sem viverra aliquet. Ante metus dictum at tempor commodo. Quam id leo in vitae turpis massa sed elementum. Ornare quam viverra orci sagittis eu volutpat odio facilisis. Pharetra convallis posuere morbi leo urna. Sed odio morbi quis commodo odio. Eu feugiat pretium nibh ipsum consequat nisl. Libero volutpat sed cras ornare arcu dui vivamus arcu. Scelerisque viverra mauris in aliquam sem fringilla ut morbi tincidunt. Et malesuada fames ac turpis egestas sed tempus. Fermentum leo vel orci porta non pulvinar neque laoreet suspendisse. Libero id faucibus nisl tincidunt eget nullam non nisi. Elementum curabitur vitae nunc sed velit dignissim. Condimentum lacinia quis vel eros donec ac. Consectetur adipiscing elit duis tristique sollicitudin nibh. Lacinia at quis risus sed vulputate odio ut enim blandit. Vitae aliquet nec ullamcorper sit amet risus nullam eget felis. Enim ut tellus elementum sagittis. Convallis a cras semper auctor. 

2. Challenge assumptions

In order to manage the cost and duration of a diligence process relative to the value and risk of the transaction, investors often rely on information that’s been deemed credible or accurate by various parties internal and external to the target company. But PE firms can miss major threats when they assume data quality or don’t adequately scrutinize information.

Analytics technologies can be used in a forensic manner, allowing the PEG to “trust but verify” previously reviewed and even audited financial statements and projections. Using common data discovery, filtering, and validation techniques, we’ve helped our PEG clients retest financials and projections against established fund metrics, benchmarks, and assumptions to quickly identify abnormalities and potential risks. Such efforts can uncover significant adjustments, including revenue recognition and normalizing EBITDA adjustments, that the PEG’s diligence team — or even third-party auditors — might not otherwise identify.