SG&A Ratio

Goal of the analysis:

Measure Selling, General & Administrative expense as a percentage of revenue (SG&A Ratio) and explain movements over time and across business units. The analysis separates structural cost changes from denominator effects (revenue shortfalls), decomposes SG&A into Sales & Marketing (S&M) and General & Administrative (G&A), and links spend to productivity (growth, efficiency) to guide cost programs and investment choices. Executives use SG&A Ratio to benchmark against peers, set operating model targets, enforce spending discipline, and improve planning credibility while safeguarding growth-critical investments.

Data required:

• Financial statements and policies:
  • P&L by month/quarter: Revenue, COGS, S&M, G&A, R&D, D&A, Other OpEx/Income.
  • Accounting policies: capitalization (software, commissions), lease accounting (IFRS 16/ASC 842), stock-based compensation (SBC) treatment, one-off/restructuring classification.
  • FX rates and constant-currency methodology; M&A/divestiture flags.
• Cost-center and segment detail:
  • Cost centers mapped to functions (Sales, Marketing, Customer Success if in SG&A, Finance, HR, IT, Legal, Facilities).
  • P&L by product/region/channel/business unit; allocation keys for shared services.
• Headcount and compensation:
  • FTE by cost center/region; fully loaded cost (salary, benefits, SBC), contractors.
  • Span of control, quota carrying vs non-quota headcounts.
• Vendor and program spend:
  • Top vendor categories (media, software/SaaS, agencies, travel & entertainment, facilities, professional services), contract terms and renewal dates.
  • Marketing program ROAS, event spend, sales enablement/tools, outsourcing/BPO.
• Planning and targets:
  • Budget/forecast versions with owner and timestamp; savings program targets; hiring plans; KPI targets (quota coverage, CAC payback, invoice automation rates).
• Reference and normalization:
  • Fiscal calendar, reclassification logs, cost taxonomy, one-off registry, peer benchmark set (if available).

Detailed step-by-step instruction on how to conduct the analysis:

1. Define scope and metrics.
   • SG&A Ratio (%) = (S&M + G&A) ÷ Revenue.
   • Produce: Total SG&A Ratio, S&M % of revenue, G&A % of revenue. Create Reported vs Adjusted (ex one-offs), Reported vs Constant Currency (CC), and Organic (ex M&A) views.
   • Document function boundaries (e.g., Customer Success in SG&A vs COGS; rent in SG&A vs D&A under IFRS 16).
2. Assemble and reconcile datasets.
   • Extract GL/P&L by month/quarter, cost center, and segment; convert to CC using treasury policy.
   • Apply allocation keys for shared services; reconcile to consolidated financials; tag one-offs/reclasses.
3. Compute baseline ratios and productivity.
   • SG&A Ratio, S&M %, G&A % by company and segment.
   • Operating leverage: ΔSG&A$ ÷ ΔRevenue$; Bps change = (Actual ratio − Prior/Plan) × 10,000.
   • Productivity overlays: Revenue per FTE (total and by function), Quota coverage, CAC payback, Invoice per FTE in Finance, Tickets per Support FTE (if in SG&A).
4. Decompose variance vs prior period and vs plan.
   • Build $ and bps bridges:
     • Start with SG&A$ variance = Actual − Prior/Plan.
     • Split into S&M (headcount, programs, tools, T&E, commissions policy) and G&A (people, facilities/leases, professional services, IT/SaaS).
     • Separate rate vs activity: identify denominator effect (revenue shortfall) by recomputing SG&A Ratio holding SG&A constant.
     • Show FX and one-offs as distinct lines; provide “Underlying” variance excluding them.
5. Segment and drill down.
   • By region/product/channel/business unit; rank segments by bps drag/benefit and SG&A$ variance contribution.
   • Cost-center heatmap: top movers (e.g., “Marketing Programs +$1.8m; G&A IT SaaS +$0.6m; Facilities −$0.4m”).
6. Headcount and vendor diagnostics.
   • FTE bridge: opening → hires → attrition → transfers; cost per FTE trends; contractor vs FTE mix.
   • Vendor Pareto: top-20 vendors by spend; renewal calendar; unit-price vs usage drivers (e.g., SaaS seats, media CPMs).
7. Link spend to outcomes.
   • S&M: correlate spend to pipeline, bookings, CAC payback; isolate low-ROI programs.
   • G&A: tie finance/HR automation to cost per transaction, close cycle time; legal outside counsel spend to case load/severity.
8. Trend, seasonality, and policy effects.
   • Plot 12–16 quarters of SG&A, S&M, G&A ratios (reported/CC/adjusted) with annotations (lease changes, reorganizations, savings programs, M&A).
   • Highlight IFRS 16/ASC 842 impacts (rent → D&A/interest) and any capitalization shifts that move costs out of SG&A.
9. Forecast refresh and targets.
   • Update latest forecast with identified run-rate changes; set quarterly SG&A ratio targets and savings owner-by-owner, with value tracking.
10. Integrity checks.
    • Ensure consistent cost taxonomy across periods; confirm allocations roll to total; reconcile adjusted vs reported; suppress thin slices or show confidence bands.

Format of the output of analysis:

• Executive scorecard: SG&A Ratio, S&M %, G&A % (reported/adjusted/CC), bps vs plan and prior year, operating leverage, revenue per FTE.
• Bridges: SG&A$ and bps waterfalls by driver (headcount, programs, IT/SaaS, facilities, FX, one-offs), with S&M vs G&A split.
• Heatmaps: SG&A Ratio by segment and cost-center variance; vendor Pareto with renewal dates.
• Headcount dashboard: FTE bridge, cost per FTE, span of control, quota coverage.
• Trend charts: 12–16 quarter SG&A ratios with annotations; adjusted vs reported lines.
• Value-tracking board: initiatives, owners, timing, savings realized vs target (bps and $).

How to interpret results:

• SG&A Ratio up while SG&A$ flat/down: Denominator effect—revenue shortfall; protect growth engines, pursue targeted revenue acceleration and short-cycle cost flex.
• S&M % rising with weak pipeline/bookings: Inefficient spend; cut low-ROI programs, improve quota coverage, and tighten CAC payback thresholds.
• G&A % elevated with stable activity: Structural overhead; pursue automation, shared services, vendor rationalization, and facilities optimization.
• Adjusted vs reported gap wide: Reliance on one-offs; normalize operations and improve planning discipline.
• Rapid ratio decline: Positive operating leverage; verify sustainability (not deferred spend) and consider reinvesting in durable growth.
• Cross-segment divergence: Fund segments demonstrating leverage; fix/resize overhead in lagging units.

Steps a company can take to improve on this measure:

• Operating model and governance:
  • Adopt driver-based and zero-based budgeting (ZBB) for S&M and G&A; require owner-level business cases and KPIs.
  • Institute quarterly cost councils; lock policy on one-offs and capitalization to avoid optic-driven shifts.
• S&M efficiency:
  • Rebalance to high-ROI channels/partners; standardize playbooks; improve quota coverage and territories; consolidate overlapping tools.
  • Set CAC payback guardrails (e.g., SMB ≤12m, MM ≤18m, ENT ≤30m) and pause spend breaching thresholds.
• G&A productivity and automation:
  • Automate finance/HR/IT workflows (AP, close, payroll, ticketing); expand shared services; digitize customer support if it sits in SG&A.
  • Rationalize facilities/leases and move to hybrid/hub models; renegotiate professional services and outsource non-core processes.
• Procurement and vendor management:
  • Consolidate vendors, negotiate enterprise SaaS contracts, eliminate shelfware; implement demand management for T&E and events.
  • Introduce tooling utilization KPIs (active seats, cost per active user).
• Policy and span-of-control:
  • Set travel, events, and marketing commitment policies; enforce approvals by ROI tier.
  • Optimize spans/layers; reduce management overhead while protecting frontline capacity.
• Scenario guidance:
  • If SG&A Ratio rose 180 bps on revenue shortfall, freeze non-critical hiring, cut low-ROI marketing 20%, and accelerate pipeline in top-converting segments; target ≤100 bps recovery next quarter.
  • If G&A % is 3 pts above peers, implement AP/close automation and consolidate SaaS; aim for −100–150 bps within 12 months.
  • If S&M % up with CAC payback > threshold, pivot to partner/online for SMB and raise quota coverage; monitor bookings/SG&A leverage monthly.

Benchmark comparisons:

General benchmarks (directional, mature businesses):

• B2B SaaS/software: SG&A (S&M + G&A) 33–50% of revenue at scale; S&M 25–35%, G&A 8–15% (lower for best-in-class).
• Consumer packaged goods: SG&A 20–30% (brand spend drives variability).
• Retail (multi-category): SG&A 20–30% (store ops and fulfillment often included; compare definitions carefully).
• Industrial/manufacturing: SG&A 10–20% (lean back-office and sales coverage models).
• IT/managed services: SG&A 15–25% depending on scale and delivery model.

Constructing internal benchmarks:

• Build 12–16 quarter histories of SG&A, S&M, and G&A ratios (reported/adjusted/CC) by segment; publish quartiles and set target bands.
• Track operating leverage (ΔSG&A$ ÷ ΔRevenue$) and revenue/FTE by function; adopt top-quartile segments as references.
• Normalize for policy changes (IFRS 16, capitalization); maintain a one-off registry to preserve comparability.
• Benchmark vendor categories (SaaS per user, media CPMs, professional services rates) internally and vs market during renewals.