đź§ Overview / What This Guide Covers
High customer concentration can turn a good unlisted assets thesis into a fragile one overnight. This guide shows CFOs, investors, and financial adviser teams how to quantify customer concentration risk, model its impact on cash, and design practical mitigations. You’ll learn how to connect customer‑level revenue, margin, and cash collection patterns into your broader post‑acquisition model, as part of a modern unlisted asset management approach. The outcome is a clear view of which customers pose outsized risk, how various shock scenarios hit cash, and what diversification or contractual moves will make the asset more resilient – and more attractive to future buyers.
âś… Before You Begin
To model high customer concentration properly, assemble the following:
- At least 12-24 months of customer‑level revenue, gross margin, and receipts.
- Contract details: terms, pricing, volume commitments, indexation, and renewal dates.
- Basic customer attributes: sector, geography, ownership type, and whether they’re investment‑grade.
- Existing cash forecasts and budget vs actuals reports, ideally with revenue and receipts split by major customer or segment.
You’ll also want clarity on lender covenants and investor expectations, so you can translate customer concentration risk into “how much headroom do we lose if this customer changes behaviour?” If you’re using Model Reef, check that your post‑acquisition cash plan and revenue‑to‑receipts model are in place. Finally, ensure you can run and save scenarios easily – either in your own model or via dedicated scenario analysis tooling. This lets you explore downside cases without rebuilding your model each time.
🛠️ Step-by-Step Implementation
Step 1 – Define or Prepare the Essential Starting Point
Begin by defining what “concentration” means for your unlisted assets. Common thresholds are any customer over 10-15% of revenue, or the top three customers exceeding 50%. Construct a simple table showing each customer’s share of revenue, gross margin, and receipts over the past 12-24 months. Then overlay qualitative flags: strategic importance, contractual protections, switching costs, and relationship strength. Plug this table into your broader post‑acquisition cash model so customer‑level flows tie to the asset’s bank balance. This foundation creates a shared language with boards and lenders: you can now talk about high customer concentration with clear percentages, not vague references to “key accounts”.
Step 2 – Walk Through the First Major Action
Next, project customer‑level revenue and cash collection forward. Use your base case revenue plan, then split it by customer or segment using historic shares, pipeline insight, and known contract changes. Map each customer’s invoices to expected payment dates, layering in real‑world behaviour like early/late payment and disputes. This gives you a baseline “concentration in cash”, not just on paper. For unlisted infrastructure, where a small number of offtakers often dominate, this step reveals whether cash risk is more concentrated than revenue due to terms and behaviour. Validate the model against budget vs actuals and recent collections so stakeholders trust the outputs.
Step 3 – Introduce the Next Progression in the Workflow
With a baseline in place, start modeling downside scenarios for customer concentration risk. For each major customer, design a set of shocks: volume reduction, price pressure, term extensions, delayed payments, or full churn. Use scenario tools to apply these shocks over different time horizons and severities, and measure the effect on cash, covenants, and distributions. Link each scenario back to your bank balance and headroom calculations in the broader unlisted asset management model. You’re not just asking “what if they churn?” but “how many weeks of run‑rate cash do we lose, and when?” This clarity drives better risk decisions with boards, lenders, and buyers.
Step 4 – Guide the Reader Through an Advanced or Detail-heavy Action
Now design mitigations. These usually fall into four buckets: diversify, strengthen, re‑price, or insure. Diversify by accelerating business development into new segments, smaller customers, or adjacent geographies; use your working capital and revenue‑to‑receipts models to test the cash effect of that growth. Strengthen key relationships by improving service quality, extending terms that support both parties, or co‑investing in projects that increase stickiness in unlisted infrastructure. Re‑price risk via higher margins for concentrated customers, or via structured pricing that rewards prepayment and flexibility. Finally, consider credit insurance or other risk transfer mechanisms where appropriate. Use headcount and go‑to‑market investments wisely – model their cash cost against the reduction in customer concentration risk.
Step 5 – Bring Everything Together and Prepare for the Outcome or Completion
Close the loop by embedding customer concentration metrics into your regular reporting and governance. Build a simple dashboard that shows concentration by revenue, margin, and receipts, plus scenario‑based headroom under key shocks. Agree on thresholds that trigger action (for example, any single customer above 25% of receipts, or a deterioration in payment behaviour). Connect your concentration analysis to exit‑readiness work so you can tell a coherent story to buyers: “Here’s our current exposure, how we model it, and how we are actively reducing it.” Finally, ensure your financial adviser and investor partners have access to the same view, so risk conversations are grounded in shared facts rather than anecdotes or sales narratives.
⚠️ Tips, Edge Cases & Gotchas
- Don’t look only at revenue – concentration in gross margin or free cash can be worse than it appears at the top line.
- Watch “hidden concentration”: multiple contracts with entities in the same group, sector, or geography can create correlated risk.
- For infrastructure‑like unlisted assets, regulatory or political changes can affect several “independent” customers simultaneously.
- Link concentration work to budget vs actuals and collections performance; behaviour often changes before contracts do.
- Make sure growth initiatives don’t accidentally increase high customer concentration – for example, by upselling the same dominant customer rather than genuinely diversifying.
Use your budgeting and forecasting rhythm to review customer concentration risk quarterly, not just during transactions. This reduces surprises and builds a stronger risk narrative over time.
📌 Example / Quick Illustration
A fund acquires an unlisted infrastructure asset where one industrial offtaker represents 42% of revenue and 55% of cash receipts. Using the approach above, the CFO models a scenario where the customer cuts volumes by 25% and extends terms by 30 days. The result: headroom to covenants shrinks to less than eight weeks. By modeling mitigations – adding two mid‑sized customers, negotiating a prepayment structure, and tightening working capital – they demonstrate a path to reducing exposure below 25% within 18 months while keeping cash positive. When they later present the asset to buyers, they can show not just the risk, but the concrete actions underway to manage it.
🚀 Next Steps
You now have a practical way to quantify high customer concentration, link it to cash, and design mitigations. The next step is to embed this into your ongoing unlisted asset management workflow: refresh the analysis regularly, tie it to budgeting and forecasting, and integrate it with headcount, capex, and working capital planning. When you do, lenders and buyers will see an asset that understands its revenue risks and is actively managing them, rather than one hoping key customers never change their behaviour.