← Files Institutional Equity AnalystARCHIVED FILE
skills/full-company-analysis/references/modules/M097-retail-analyst-playbook.md
7.44 KB · Oct 4, 2026 · 12:35 UTC
<!-- Generated loss-aware reference mirror from God_Level_Public_Company_Financial_Analyst_Job_Guide_V6_99_ALL_SUB70_FIXED.docx. Canonical source remains the bundled DOCX. --> <!-- Module: 097 | Title: Retail Analyst Playbook --> ## PART XV - SECTOR PLAYBOOKS | MODULE 097 # Retail Analyst Playbook > Mission. Build a sector-specific research system for Retail that converts operating data into financial outcomes, highlights the accounting areas most likely to distort comparability, and selects valuation methods that reflect the sector's economics. ## Economic engine and binding constraints Model stores, traffic, conversion, units per transaction, AUR, e-commerce, gross margin, markdowns, shrink, inventory turns, occupancy, labor, and working capital. Track inventory composition and promotional intensity by channel. ## Primary KPI stack | KPI | Construction / analyst control | | --- | --- | | comps | Comparable-store sales growth for the constant-store base; reconcile traffic, ticket, calendar, FX, and closure impacts. Validation: Recalculate independently from cited source data; verify definition, period, units, scope, signs, and any reconciliation to reported financial or operating totals. | | traffic | Customer visits or transactions at comparable locations, usually expressed as year-over-year % change using a constant-store base. Validation: Tie physical/operating units to company disclosures or source-system data; reconcile beginning/ending populations where applicable and test scope, ownership, and period consistency. | | ticket | Average sales per transaction/order, equal to comparable sales divided by comparable transaction count. Validation: Recalculate price/cost from underlying dollars and physical units; test mix, rebates, FX, timing, and unit-definition effects; reconcile to reported revenue or expense. | | units | Physical units shipped, sold, or produced for the defined product scope and period; reconcile returns, channel inventory, and product mix. Validation: Tie physical/operating units to company disclosures or source-system data; reconcile beginning/ending populations where applicable and test scope, ownership, and period consistency. | | gross margin | Gross margin = gross profit / revenue | | inventory turns | Annualized COGS divided by average inventory; for retailers also monitor weeks of supply and aged inventory. Validation: Recalculate from same-scope numerator and denominator; confirm period, units, cohort/geography, and issuer definition; reconcile material differences to filings or operating data. | | markdowns | Gross margin reduction from price markdowns divided by gross sales or inventory retail value, with clearance and promotional markdowns separated. Validation: Recalculate independently from cited source data; verify definition, period, units, scope, signs, and any reconciliation to reported financial or operating totals. | | e-commerce mix | Digital/e-commerce sales divided by total retail sales using a consistent fulfillment/revenue-recognition definition. Validation: Recalculate from same-scope numerator and denominator; confirm period, units, cohort/geography, and issuer definition; reconcile material differences to filings or operating data. | ## Sector-specific accounting and comparability traps - Inventory reserves: reconcile issuer treatment with peer treatment and quantify the effect on reported growth, margin, cash flow, capital, or valuation before comparing outputs. - Vendor allowances: reconcile issuer treatment with peer treatment and quantify the effect on reported growth, margin, cash flow, capital, or valuation before comparing outputs. - Leases: reconcile issuer treatment with peer treatment and quantify the effect on reported growth, margin, cash flow, capital, or valuation before comparing outputs. - Gift cards: reconcile issuer treatment with peer treatment and quantify the effect on reported growth, margin, cash flow, capital, or valuation before comparing outputs. - Loyalty: reconcile issuer treatment with peer treatment and quantify the effect on reported growth, margin, cash flow, capital, or valuation before comparing outputs. ## Valuation frameworks - EV/EBITDA: enterprise value divided by normalized EBITDA; adjust leases, pensions, minorities, recurring restructuring and capital intensity before peer comparison. - P/E: common equity value per share divided by normalized diluted EPS; normalize taxes, one-time items, dilution, cyclicality, and non-operating income. - FCF yield: normalized levered free cash flow divided by equity value; reconcile SBC, working capital, maintenance capex, taxes, and cycle before comparing companies. - DCF: forecast FCFF from operating drivers, discount at a capital-structure-consistent WACC, model terminal growth/ROIC coherently, and bridge enterprise value to common equity. ## Sector diligence questions - What is the most important leading indicator for Retail, and how many months does it lead reported revenue or cash flow? ## Sector stress and falsification - Stress comps and traffic together in the direction most likely to break the equity story; flow the result through working capital, capex, liquidity, financing, dilution, and valuation. - Explicitly test inventory reserves. Determine whether it can make the reported sector comparison look better or worse without equivalent economic change. ## 99-point standalone execution extension ### Model architecture and forecast chain Model stores, square footage, traffic, conversion, units per transaction, ASP, e-commerce, gross margin, shrink, inventory turns, rent, labor, and capex. ### Leading-indicator dashboard Track foot traffic, card spend, promotions, inventory, markdowns, freight, vendor terms, store openings/closures, and consumer credit. ### Primary-source map SEC filings; Census retail sales; company inventory and traffic disclosures; public pricing/promotions; import/shipping data where lawful and reliable; lease/credit disclosures. ### Accounting normalization test Lease obligations, vendor allowances, gift cards, inventory reserves, private-label credit, and supplier finance can distort cash/margins. ### Valuation implementation Use mid-cycle FCF, EV/EBIT, and SOTP for credit/e-commerce where relevant. Inventory and lease intensity matter. ### Worked numerical mini-case > Illustrative inventory case. Sales $10bn, gross margin 35%, and inventory rises 18% while sales rise 3%. If markdowns reduce gross margin 150 bp, gross profit falls $150m before fixed-cost leverage. Track traffic, conversion, units per transaction, AUR, weeks of supply and lease obligations. Inventory quality matters more than inventory growth alone. ### Monitoring and falsification cadence Breaks include sustained traffic loss, markdown cycle, inventory obsolescence, lease burden, e-commerce economics, or vendor tightening. At every quarterly update, rebuild the driver bridge from operating units to revenue, margin, cash flow and valuation; compare leading indicators with the prior forecast; record definition changes; and precommit the threshold that would trigger a thesis reset rather than a cosmetic estimate change. ## Sector exit standard The Retail work is complete only when the analyst can explain the business in its native operating units, reproduce the KPI history, identify the binding growth constraint and marginal price setter, normalize sector-specific accounting, quantify a coherent adverse case, and translate the current market price into the operating expectations that must be met or exceeded.
SHA-256: 1e329048adfdf5a682166b3366ea8f70536db0b727d7472dcad5571763fa0393