Start with a question that the disclosure can answer
Customer concentration asks how much of a company's business depends on particular customers. A useful first question is narrower than whether concentration is good or bad: which customer measure is disclosed, what period does it cover, and how has that measure changed? Preserve those distinctions before building an interpretation.
This tutorial creates an external research worksheet using a fictional business called Meridian Components. Every company name, dollar amount and percentage in the exercise is hypothetical. The worksheet is your own document or spreadsheet; it is not a claim that ThesisMemo offers a customer database or an automatic concentration calculator.
Start from an available source link in a ThesisMemo company factor or timeline, then open the original disclosure. The product's methodology separates reported facts, possible implications and future checkpoints. Apply that same separation to your notes: record the disclosed exposure first, explain a conditional implication second, and identify the evidence still needed third.
Find the disclosure and preserve its scope
Use the annual or quarterly report's own search function to look for customer, concentration, credit risk and receivables. Read surrounding paragraphs and table headings rather than extracting the first percentage. The relevant information may be spread across business discussion, risk factors and financial-statement notes. Save the document URL and the exact section for each observation.
Investor.gov's guide to the 10-K and 10-Q distinguishes business descriptions, risk factors, management discussion and financial statements with accompanying notes. These sections answer different questions. A statement describing potential loss of a customer does not establish that a loss occurred; a numerical note may establish exposure without explaining the relationship's commercial durability.
Create fields for publication date, fiscal period, measurement date when applicable, currency, units, company scope, customer label and the original wording. A group of related buyers may be described differently from an individual legal customer. Retain the company's definition. If the scope is unclear, write unclear rather than choosing the interpretation that makes your calculation easiest.
Calculate revenue concentration with matched amounts
Assume Meridian reports annual consolidated revenue of 1,000 million dollars. Its disclosure says Customer A generated 240 million and Customer B generated 160 million during that same year. Customer A therefore represents 24 percent of revenue, Customer B 16 percent, and the two together 40 percent. The remaining customers contribute 600 million, or 60 percent.
Record both the dollars and the percentages. The arithmetic is customer revenue divided by comparable total revenue, multiplied by 100. Do not divide a full-year customer amount by quarterly sales or use a segment denominator when the customer disclosure covers the consolidated company. The result may look precise while measuring the wrong relationship.
If a real source provides only a rounded percentage, multiplying it by total revenue gives an approximation, not a newly disclosed exact amount. Label the estimate and preserve the rounding limitation. If the source supplies only an inequality or a combined group figure, retain that form; do not manufacture individual customer amounts to fill every cell.
Explain why a falling share can hide growing exposure
In the next hypothetical year, Meridian's total revenue rises to 1,200 million and Customer A revenue reaches 264 million. The customer's share falls from 24 percent to 22 percent even though its purchases rise by 24 million, or 10 percent. Total company revenue rises by 20 percent. The denominator grew faster than this customer's revenue.
A careful note would say that Customer A's relative revenue contribution declined while its absolute contribution increased. It would not say that Meridian lost business with the customer. The two-percentage-point decline in share is also different from the 10 percent increase in customer revenue. Keep the units beside each change rather than calling both a percentage change.
Now test the reverse with a separate scenario: total revenue falls to 800 million while Customer A remains at 240 million. Concentration rises to 30 percent without an increase in customer revenue. These exercises show why your worksheet needs the numerator and denominator. They do not establish whether the real relationship became more or less secure.
Separate revenue from the receivables snapshot
Return to Meridian's first year. Assume year-end receivables total 200 million on the same stated measurement basis, with 70 million attributable to Customer A. The customer's receivables share is 35 percent, compared with its 24 percent annual revenue share. Those percentages describe different measures and different time structures; neither substitutes for the other.
The SEC's financial-statement guide distinguishes a balance sheet at a point in time from an income statement covering a period. Apply that distinction here. The gap between Meridian's two shares is 11 percentage points, but it is not a default probability, an overdue balance or evidence that 11 percent of sales will be lost.
To investigate the gap, look for disclosed payment terms, shipment timing, aging information and credit-loss discussion. A large late-period shipment is one possible explanation, not a fact you can infer from these totals. If customer-specific collection evidence is absent, leave the collection question unresolved. Do not create a customer payment-days estimate using mismatched periods or assumptions hidden inside a formula.
Check customer identity before comparing years
Suppose the following report again lists Customer A. Before treating that as a continuous history, check whether the company explains that customer labels are consistent across periods. An anonymous label alone does not prove that the underlying buyer is unchanged. Record confirmed continuity separately from your assumption; otherwise a trend chart may silently connect unrelated relationships.
Also distinguish the direct customer from the end user. In a hypothetical distribution arrangement, a distributor purchases from Meridian and resells to several users. A large direct-customer share describes the relationship disclosed in the report. It does not establish that one final user consumes that entire amount, or that the end-user demand is fully diversified.
Do not replace an anonymous customer with a recognizable brand based on industry gossip or a photograph of a product. Keep the source's label unless a reliable disclosure identifies the relationship. A name can make a story more appealing while making the evidence less accurate. Your research question can remain useful even when the buyer's identity is unavailable.
Write a bounded sensitivity rather than a prediction
Use Meridian's first-year figures for a deliberately simplified sensitivity. Assume Customer A revenue falls by one quarter, all other customer revenue stays at 760 million, and nothing replaces the lost sales. Customer A revenue becomes 180 million, total revenue becomes 940 million, and the total revenue reduction is 60 million, or 6 percent.
That calculation measures a scenario you specified. It does not predict customer behavior, cancellation rights, future revenue or a stock return. It also says nothing by itself about profit: costs, replacement business, pricing and operating responses would need separate assumptions and evidence. Do not apply the 6 percent revenue decline automatically to earnings or market value.
Keep the assumptions immediately beside the result. A reader should be able to change the customer reduction or replacement-sales assumption without reconstructing your reasoning. For a real company, start by asking whether disclosed contract terms, purchasing patterns or management commentary provide grounds for the scenario. If they do not, present it only as an illustrative sensitivity.
Finish with an evidence record you can update
Your completed row should contain the source, customer definition, reporting period, revenue amount or disclosed share, comparable company total and a separate receivables field where available. Add your calculations, unresolved questions and the next document you plan to check. Preserve the previous row when new information arrives so changes in definition remain visible.
For Meridian, a supported exercise conclusion is that the first year's customer exposure is substantial relative to the fictional totals, while the receivables share answers a different question from the revenue share. Avoid a universal safe concentration threshold. The worksheet organizes evidence; it cannot rank every business model or turn one ratio into an investment decision.
When returning to ThesisMemo, check the displayed research date against the disclosure you just read. A newer report may not yet be reflected in the assessment. Keep your external calculation linked to its own source and period, then use the next review to resolve a specific question, such as whether the same customer's absolute revenue changed or the reporting definition changed.
Product references
Questions & answers
What is customer revenue concentration?
For this worksheet, it is the revenue attributable to a specified customer or customer group divided by comparable company revenue for the same period. Preserve the disclosure's definition and scope. A percentage by itself does not describe contract durability, customer profitability or future purchase commitments.
Can concentration fall while customer revenue grows?
Yes. In the fictional example, customer revenue rises from 240 to 264 while total revenue rises from 1,000 to 1,200. The customer grows 10 percent but its share falls from 24 to 22 percent because total revenue grows faster. Check both amounts before interpreting the change.
Is receivables concentration the same as revenue concentration?
No. The receivables figure is a balance at a specified date, while revenue covers a period. A higher receivables share invites questions about timing and collection evidence; it does not by itself establish overdue payments, default risk or the amount of a future loss.
Should I identify an anonymous customer from online speculation?
No. Preserve the label in the original disclosure unless reliable evidence identifies the buyer. Verify whether anonymous labels are consistent across periods before comparing them. Leave end-user identity unresolved when a source describes only a distributor or another direct customer.
Does ThesisMemo create this worksheet automatically?
This tutorial uses original source links and a separate document or spreadsheet. It does not promise automatic customer mapping, collection monitoring or a concentration calculator. Follow available research links, check the displayed dates and keep your own reproducible record of definitions and calculations.