Blog · Territory, capacity and quota planning · Financial services
An affluent customer segment needs a documented eligibility rule rather than an assumed level of wealth. This guide compares balances, revenue and servicing costs across declared bands using financial-services exports.
An affluent customer segment uses documented eligibility bands to compare revenue, contribution and service workload. Balances alone do not establish profitability.
Start with the institution's approved classification. Specify whether the rule uses individual customers, households or legal entities; which accounts qualify; and whether it measures a closing balance or a period average. Record the effective date so a reviewer can reproduce the assignment.
Do not infer wealth from an address, job title or product purchase. Income, total wealth and assets held with one institution are different concepts. The Federal Reserve's Survey of Consumer Finances collects balance-sheet and income information separately; a provider's eligible balance is a narrower operational measure, not a substitute for a complete household balance sheet.
For the illustrative US institution below, the comparison unit is an approved household ID, and the eligibility measure is average eligible assets held with the firm during the quarter. The following internal bands are invented for the worked example, not market definitions:
| Internal band | Documented example rule (USD) |
|---|---|
| Core | Eligible balance below 250,000 |
| Affluent A | Eligible balance at least 250,000 and below 1,000,000 |
| Affluent B | Eligible balance at least 1,000,000 |
| Unknown | Eligibility balance unavailable |
These affluent bands compare balance levels. They do not specify service entitlements: segments and tiers answer different questions.
Bring an eligibility export, a revenue file and direct-cost and service-activity files with matching household IDs. Include the quarter, currency and rule version. Revenue must cover the same period as costs; an asset balance belongs in its own column and is never added to revenue.
Use the institution's authorized relationship mapping. Count a jointly held account's eligible balance only once under that mapping. If an account cannot be assigned confidently, place it on an exception list rather than duplicating it across households.
| Household ID | Eligible average balance (USD) | Quarterly revenue (USD) | Direct cost (USD) | Service hours |
|---|---|---|---|---|
| H101 | 150,000 | 1,800 | 600 | 6 |
| H102 | 300,000 | 4,000 | 1,000 | 10 |
| H103 | 800,000 | 8,000 | 2,000 | 30 |
| H104 | 1,200,000 | 12,000 | 3,000 | 50 |
| H105 | 2,000,000 | 18,000 | 4,000 | 80 |
| H106 | 2,200 | 700 | 5 |
The blank balance for H106 is unknown, not zero. Its revenue and costs still belong in the financial totals. The declared service rate is $100 per recorded hour; direct costs exclude this service pool and corporate overhead.
Put the source table in A:E, with the first household on row 2 and the hourly rate in L2. Service cost in F2 is:
=E2*$L$2
Assign the segment in G2 using the disclosed boundaries:
=IF(B2="","Unknown",IF(B2<250000,"Core",IF(B2<1000000,"Affluent A","Affluent B")))
Microsoft documents IF as returning different results according to whether a logical comparison is true or false. Check for invalid text and negative balances before applying this example's classification; those records need review rather than an automatic band.
Contribution in H2 is:
=C2-D2-F2
Fill the formulas down through row 7. H104's service cost is 50 × 100 = $5,000, leaving 12,000 − 3,000 − 5,000 = $4,000 of contribution. This is contribution under the stated cost boundary, not household net profit after every institutional expense.
List the four band names in N2:N5. Contribution for the band named in N2 can be aggregated with Microsoft's SUMIFS function:
=SUMIFS($H$2:$H$7,$G$2:$G$7,N2)
Covirage is not affiliated with Microsoft. The same grouping approach sums revenue, direct costs and service hours. Divide each band's total contribution by its total revenue to obtain its contribution margin.
| Band | Households | Known eligible balance (USD) | Revenue (USD) | Service hours | Direct plus service cost (USD) | Contribution (USD) | Contribution margin |
|---|---|---|---|---|---|---|---|
| Core | 1 | 150,000 | 1,800 | 6 | 1,200 | 600 | 33.3% |
| Affluent A | 2 | 1,100,000 | 12,000 | 40 | 7,000 | 5,000 | 41.7% |
| Affluent B | 2 | 3,200,000 | 30,000 | 130 | 20,000 | 10,000 | 33.3% |
| Unknown | 1 | Unknown | 2,200 | 5 | 1,200 | 1,000 | 45.5% |
| Total | 6 | 4,450,000 | 46,000 | 181 | 29,400 | 16,600 | 36.1% |
Money is in whole dollars; margins use unrounded totals, displayed to one decimal place. Total margin is 16,600 ÷ 46,000, never the average of the four percentages.
Known eligible balances total $4,450,000. Show that as a known-balance total covering five households; do not present H106's missing balance as a confirmed absence of assets. Household counts reconcile as 1 + 2 + 2 + 1 = 6.
Direct costs total $11,300. The 181 service hours at $100 produce $18,100 of service cost. Together they give $29,400, and 46,000 − 29,400 = $16,600 of contribution. Independently, the band contributions sum to 600 + 5,000 + 10,000 + 1,000 = $16,600.
Affluent B produces more contribution dollars but consumes 130 service hours against Affluent A's 40. Contribution per recorded service hour is 10,000 ÷ 130 = $76.92 for B and 5,000 ÷ 40 = $125.00 for A, rounded to cents. This comparison informs workload discussions; it is not an instruction to withdraw agreed service or a return on invested assets.
Review the comparison norm before treating a band's average as an individual target. When eligibility changes, use segment migration to separate reclassification from genuine changes in commercial performance.
Bring your eligibility export, authorized grouping rules, revenue and service-cost files. Covirage maps the columns, and its tools compute and check the supplied segment comparisons; the external AI model explains the economics with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.
See Covirage for financial services for the supporting industry context.
Use the institution's approved eligibility rule and disclose the assets, ownership relationships and measurement window it includes. A balance held with the firm is not automatically total household wealth, and another provider's threshold may define a different population.
Choose the unit that matches the approved commercial question. If eligibility is assessed by household, consolidate eligible accounts under an authorized household identifier and count each household once. Keep account-level records underneath for reconciliation and review.
Balances alone do not settle coverage. Compare contribution, service workload, contractual commitments and customer needs. A high-balance group may earn more dollars while requiring substantially more effort, so the coverage decision needs both economics and service obligations.