Free customer concentration planning tool
Customer Concentration Risk & Revenue-at-Risk Tool
Measure how much revenue depends on your largest customers, then stress-test what happens to sales and gross profit if one or several major accounts shrink or disappear.
Simple concentration snapshot
Loss-scenario modelMap your five largest customers
Company economics
Largest customers
CustomerAnnual revenue
$
$
$
$
$
Custom stress scenario
Simple methodConcentration ratios show the share of total company revenue represented by the largest one, three and five disclosed customers. The loss ladder assumes a 100% loss of the largest customer(s) before replacement. The custom scenario applies the entered loss severity to the selected number of largest customers, then subtracts the entered 12-month recovery amount. Gross-profit-at-risk uses the entered company gross margin.
Customer loss ladder
100% loss before replacementRevenue impact if the largest accounts disappear
| Scenario | Revenue lost | Share of company revenue | 12-month net revenue-at-risk | Gross profit at risk | Revenue remaining |
|---|
Top-customer map
Revenue dependence by disclosed customer
| Customer | Annual revenue | Revenue share | Cumulative share | Gross profit contribution |
|---|
Advanced account exposure model
Customer-specific recovery assumptionsModel ten major customers individually
Company assumptions
Major customer accounts
CustomerAnnual revenueGross marginScenario lossReplacement recovery potentialMonths to replaceRenewal in
Advanced methodScenario revenue-at-risk is calculated per customer from revenue, scenario loss severity and the recovery expected within the planning horizon. The entered recovery potential is time-adjusted when replacement time extends beyond the horizon. Gross-profit-at-risk uses each customer's entered gross margin. Renewal timing is reported separately so near-term contract concentration can be reviewed without pretending that renewal timing predicts churn.
Customer exposure table
Configured revenue and gross-profit exposure by customer
| Customer | Revenue share | Annual revenue | Gross revenue exposed | Recovery in horizon | Net revenue-at-risk | Gross profit at risk | Replacement time | Renewal timing |
|---|
Largest-account loss ladder
Top accounts ranked by revenueFull-loss scenarios before replacement
| Scenario | Revenue lost | Share of company revenue | Gross profit lost | Revenue remaining | Growth target multiple |
|---|
Concentration stress matrix
Largest accounts firstRevenue lost by number of major accounts and loss severity
Recovery sensitivity
Configured revenue-at-risk as replacement improves
| Recovery scale | Revenue recovered | Net revenue-at-risk | Gross profit at risk | Revenue remaining |
|---|
Scope
This tool models exposure, not the probability of customer loss
The calculator does not predict churn, renewal, default or customer behavior. Scenario loss percentages, recovery rates and replacement timing are planning assumptions supplied by the user. Customer concentration should also be considered alongside contract terms, customer profitability, switching costs, strategic value, industry concentration, credit quality and the pipeline available to replace lost revenue.