All posts
retail4 min read

Retail Sector Due Diligence: Financial Analysis Priorities for Transaction Services

Retail due diligence demands focus on seasonality adjustments, inventory valuation, lease normalization, and same-store sales analysis to assess earnings quality.

Datapack Team

Retail Sector Due Diligence: Financial Analysis Priorities for Transaction Services

Retail targets present unique challenges for financial due diligence teams. Seasonality, inventory complexity, lease structures, and channel mix all affect how earnings quality is assessed.

Transaction Services teams that run retail engagements regularly develop sector-specific playbooks. Those that do not often underestimate the time required to normalize financials properly.

Revenue Quality in Retail

Revenue analysis in retail goes beyond top-line growth trends. The core question is whether reported revenue reflects sustainable customer demand or temporary factors.

Same-store sales (SSS) analysis is the starting point. Comparable store performance strips out the effect of new openings and closures to reveal organic growth. Calculating SSS requires a clean store-level revenue dataset, which means extracting data from POS systems (Oracle Retail, SAP Retail, Shopify POS) and reconciling against GL revenue accounts (4000-series in most retail COAs).

Channel mix trends matter increasingly. A retailer shifting from wholesale to DTC e-commerce may show flat total revenue but fundamentally different margin profiles. Diligence teams need to decompose revenue by channel, assess gross margin by channel, and identify any revenue quality risks in the transition.

Gift card and loyalty program liabilities are frequently misstated. Breakage estimates vary widely, and the timing of revenue recognition under ASC 606 creates adjustment opportunities. Check GL accounts in the 2500-2600 range for deferred revenue balances tied to these programs.

Inventory Adjustments

Inventory is where retail deals get complicated. Three areas require close attention.

Obsolescence reserves: Retailers often under-reserve for slow-moving stock. Analyze inventory aging by SKU category, not just in aggregate. Compare the reserve methodology to actual write-offs over the trailing 12-24 months. If the target uses weighted average cost, verify that cost layers are not masking margin erosion on aging inventory.

Shrinkage normalization: Retail shrinkage (theft, damage, administrative errors) typically runs 1-2% of revenue. If the target's reported shrinkage falls materially below or above this range, it warrants investigation. Shrinkage adjustments directly affect EBITDA normalization.

Seasonal inventory builds: Working capital analysis must account for seasonal inventory loading. A snapshot taken during peak season (e.g., October for apparel retailers) will overstate normalized net working capital. Use trailing 12-month average balances or analyze month-end balances across a full cycle.

Lease and Occupancy Cost Normalization

Under ASC 842 / IFRS 16, lease accounting has become more transparent but also more complex for diligence purposes.

Right-of-use asset and lease liability validation: Verify the completeness of the lease schedule against physical locations. Missed leases are common, especially for pop-up locations and storage facilities. Reconcile the lease schedule to GL accounts 1700-1800 (ROU assets) and 2700-2800 (lease liabilities).

Percentage rent adjustments: Retail leases often include percentage rent clauses tied to store revenue thresholds. These create variable occupancy costs that need to be modeled under different revenue scenarios for the buyer's underwriting.

Lease renewal assumptions: If a significant portion of the store portfolio comes up for renewal within 2-3 years of close, the buyer needs to understand the renewal risk. Market rent comparisons against current lease rates reveal whether occupancy costs are likely to increase.

EBITDA Adjustments Specific to Retail

Common EBITDA adjustments in retail transactions include:

  • Store opening/closing costs: One-time costs for new store buildouts, relocation expenses, and store closure charges. These are typically normalized out of run-rate EBITDA but must be separated from ongoing capex.
  • Pre-opening payroll: Staff hired and trained before a store opens represent a non-recurring cost that depresses earnings in the period.
  • E-commerce platform migration: Replatforming costs (moving from Magento to Shopify Plus, for example) are one-time but can span multiple periods.
  • COVID-era adjustments: Even years later, pandemic-period revenue and cost patterns may affect trailing averages. Clearly delineate any periods excluded from run-rate calculations.

Data Extraction Challenges

Retail targets run diverse technology stacks. POS systems, e-commerce platforms, inventory management systems, and the ERP (often SAP, Oracle, or NetSuite) may all contain financial data relevant to the analysis.

The ERP data extraction process for retail deals must account for this fragmentation. GL data from the ERP may not capture the detail needed for SKU-level analysis or store-level performance. Supplementary data pulls from operational systems are almost always necessary.

Teams that have standardized their data workflows for retail targets can handle this complexity efficiently. Teams approaching it ad hoc will lose time reconciling data across systems.

Building a Retail Diligence Playbook

Retail is a repeat sector for most Transaction Services practices. Investing in a sector-specific playbook that codifies GL mapping templates, common adjustment categories, and data request lists reduces delivery time on subsequent deals and improves deal knowledge retention across the team.