K
KnowMBAAdvisory
FinanceIntermediate7 min read

Customer Profitability Analysis

Customer Profitability Analysis (CPA) calculates true profit per customer by allocating direct revenue, direct costs (COGS), and indirect cost-to-serve (sales, support, success, payment, returns) to each individual account. It produces a customer P&L. Bain & Company's research consistently shows the same shape: in most B2B portfolios, the top 20% of customers generate 150-200% of profit, the middle 60% generate near-zero profit, and the bottom 20% destroy 50-100% of profit. The fact that most companies have never built this view is one of the most stunning gaps in modern management. Most CFOs can tell you margin by product but not margin by customer โ€” even though the customer is the unit of value.

Also known asCPACustomer P&LCustomer-Level ProfitabilityAccount Profitability Analysis

The Trap

The trap is allocating cost-to-serve uniformly (e.g., as a % of revenue) rather than by actual activity drivers. Uniform allocation hides the bottom-20% problem entirely โ€” every customer looks roughly average. The other trap: running CPA once and getting overwhelmed by the findings. The output is uncomfortable: your sales team's biggest accounts are often unprofitable, your favorite customers may be loss leaders. Companies build the analysis, get scared by it, and shelve the report. The data is only as valuable as the willingness to act on it.

What to Do

Build a customer P&L for the top 100 customers (or top 80% of revenue, whichever covers more). Use Activity-Based Costing for cost-to-serve allocation: support tickets, sales touches, payment terms cost (DSO ร— WACC), returns, customizations. Sort customers by ABC profit and segment into four buckets: Stars (top 20% โ€” invest), Workhorses (next 30% โ€” protect), Drifters (next 30% โ€” improve), Losers (bottom 20% โ€” fix or fire). For Losers, the playbook is: reprice, simplify the relationship (drop custom SLAs), shift to lower-touch service, or graduate them to a competitor.

Formula

Customer Profit = Revenue โˆ’ COGS โˆ’ Direct Cost-to-Serve โˆ’ Allocated Sales/Marketing โˆ’ Working Capital Cost

In Practice

Bain & Company's research on B2B portfolios consistently finds the same 'whale curve': cumulative profit rises sharply with the top 20% of customers, peaks around the 50-60% revenue mark at 150-200% of total profit, then declines as marginal customers consume more cost-to-serve than they contribute. In one widely-cited Bain engagement at a global industrial distributor, the bottom 30% of accounts were destroying $40M of annual profit. After repricing and consolidating those accounts, the company's EBITDA grew 18% on 6% lower revenue. The whale curve appears in nearly every industry Bain has published on โ€” financial services, telecom, industrial distribution, software.

Pro Tips

  • 01

    The single biggest CPA insight: salespeople are paid on revenue, not customer profit. Your top performers are often building unprofitable books because they're closing whatever deals they can find with whatever discounts and SLAs the customer demands. The CPA fix isn't more analysis โ€” it's compensation redesign tied to customer profit, not revenue.

  • 02

    Don't try to make every customer profitable. Some Losers should be fired. Bain's research suggests 5-10% of any customer base is structurally unprofitable and not fixable. The CFO's job is to identify them honestly, not to torture the model into showing they're 'breakeven.'

  • 03

    Track customer profitability monthly, not annually. Customer profitability shifts faster than product profitability โ€” a price concession, a new SLA, a billing dispute can turn a Star into a Drifter in one quarter. Most companies analyze customer profitability once and then go years without refresh.

Myth vs Reality

Myth

โ€œBig customers are our most profitable customersโ€

Reality

Almost universally false. Bain and McKinsey research across hundreds of B2B portfolios shows that big customers extract bigger discounts, demand more custom service, take longer to pay, and require more executive time. On a fully-loaded basis, the most profitable customer segment is usually mid-tier accounts โ€” large enough to be efficient to serve, small enough to lack negotiating leverage.

Myth

โ€œWe need a CRM and BI system before we can do CPAโ€

Reality

First-pass CPA on the top 50 customers can be done in Excel in 2-3 weeks with sales, finance, and CS in a room. The bottleneck is willingness to allocate cost-to-serve honestly, not data infrastructure. Many companies use 'we need better systems' as a stall against an analysis they don't want the answer to.

Try it

Run the numbers.

Pressure-test the concept against your own knowledge โ€” answer the challenge or try the live scenario.

๐Ÿงช

Knowledge Check

A SaaS company has 500 customers. The CFO runs CPA and finds the top 20% generate 180% of profit while the bottom 20% destroy 60% of profit. What is the highest-leverage action?

Industry benchmarks

Is your number good?

Calibrate against real-world tiers. Use these ranges as targets โ€” not absolutes.

Bottom-20% Customers as % of Profit Destruction

B2B portfolios across industries โ€” Bain & Company customer profitability research

Healthy (Profitable Tail)

< 10%

Average (Slight Drag)

10-30%

Concerning

30-60%

Whale Curve Crisis

60-100%

Severe Mispricing

> 100%

Source: Bain & Company Customer Strategy & Marketing Practice

Real-world cases

Companies that lived this.

Verified narratives with the numbers that prove (or break) the concept.

๐Ÿ‹

Bain Whale Curve Research

2000-2020 (multi-engagement)

success

Bain has published the 'whale curve' phenomenon across hundreds of B2B engagements: when customers are sorted from most to least profitable on an ABC-loaded basis, cumulative profit typically peaks at 150-200% of total reported profit around the 50-60% revenue mark, then declines. The bottom 20-30% of customers consume more cost-to-serve than they generate margin. The pattern holds across industrial distribution, financial services, telecom, and software. In one industrial distribution engagement, repricing the bottom 30% of accounts grew EBITDA 18% on 6% lower revenue.

Top-20% Profit Share (Median)

180%

Bottom-20% Profit Share (Median)

-50% to -100%

Industries Confirmed

10+

Typical Profit Lift from Action

15-30%

The whale curve is a near-universal feature of B2B portfolios. The companies that win aren't the ones that grow revenue fastest โ€” they're the ones that consciously prune the unprofitable tail. Most companies have a whale curve and have never measured it.

Source โ†—
๐Ÿฆ

Hypothetical: Regional Bank

2020-2023

success

A $4B-asset community bank ran customer profitability analysis on its 80,000 retail accounts. The findings: 22% of accounts were unprofitable on a fully-loaded basis (deposit costs, branch service, fraud losses, statement fees absorbed). Most were small-balance accounts that nonetheless visited the branch frequently. After redirecting these customers to digital channels and adjusting fee structures, the bank improved retail banking margin by 24% within 18 months while losing only 4% of accounts.

Accounts Analyzed

80,000

% Unprofitable (Fully Loaded)

22%

Margin Improvement

+24%

Account Loss

4%

Customer profitability analysis is most powerful in retail/SMB segments where account count is high and per-account economics vary widely. The action isn't always 'fire' โ€” often it's 'reroute to lower-cost channels.'

Decision scenario

The Whale Curve Reckoning

You are CFO of a $250M B2B distribution company. CPA results just landed: top 20% of accounts generate 195% of profit. Bottom 25% destroy 70% of profit. Your CRO says any action will hurt morale. Your CEO wants you to lead the response.

Total Accounts

1,200

Reported Profit

$30M

Top-20% Profit Share

195%

Bottom-25% Profit Destruction

$21M

Sales Comp

Tied to revenue, not profit

01

Decision 1

You have to decide the action plan. Three paths: Path A: Fire the bottom 25% outright. Path B: Reprice/restructure the bottom 25%, accepting some will churn. Path C: Redesign sales comp to tie 30% to customer profit, then let salespeople work the bottom 25% over 12 months.

Path A: Fire the bottom 25% โ€” clean cut, immediate margin liftReveal
Revenue drops 18% in Q1. EBITDA initially rises sharply (loss customers gone, capacity freed). But by Q3, you discover ~30% of the 'bottom 25%' had latent upside โ€” they were unprofitable due to onboarding costs, not structural mispricing. You lose them permanently to a competitor who later turns them profitable. CRO loses 3 senior reps to resignation. The action was right in spirit but too crude in execution.
Revenue Impact: -18%EBITDA Year 1: +$12MLong-Term Strategic Cost: Moderate
Path B: Reprice/restructure the bottom 25% โ€” offer new terms, accept that 30-40% will churn, retain the rest as profitable customersReveal
Painful but disciplined. You send price increases or service-tier changes to 300 accounts. ~110 churn (37%). The remaining ~190 accept new terms and move from -$70K avg profit to +$15K avg profit. EBITDA improves by $14M in year 1 and $19M in year 2. Sales comp pivots toward profit in year 2. Three senior reps initially complain but stay because the new comp plan rewards what they're already good at: closing deals at fair pricing.
Revenue Impact: -9%EBITDA Year 1: +$14MEBITDA Year 2: +$19M
Path C: Redesign sales comp first, then let salespeople fix the bottom 25% organically over 12 monthsReveal
Sales comp redesign takes 6 months to roll out. By month 12, only ~20% of the bottom 25% has been touched. Most reps are conservative โ€” they avoid hard repricing conversations because their existing relationships matter to their pipeline. You've solved the structural incentive problem but not the immediate profit problem. EBITDA improves by only $3M in year 1. You still have to do Path B in year 2 โ€” you've just delayed it.
Revenue Impact (Yr 1): -1%EBITDA Year 1: +$3MProfit Action Delayed: 12+ months

Related concepts

Keep connecting.

The concepts that orbit this one โ€” each one sharpens the others.

Beyond the concept

Turn Customer Profitability Analysis into a live operating decision.

Use this concept as the framing layer, then move into a diagnostic if it maps directly to a current bottleneck.

Typical response time: 24h ยท No retainer required

Turn Customer Profitability Analysis into a live operating decision.

Use Customer Profitability Analysis as the framing layer, then move into diagnostics or advisory if this maps directly to a current business bottleneck.