Detect Product-Mix Concentration and Growth Dependency Across Reporting Periods

A company can appear diversified at the corporate level while depending heavily on one product or business line for incremental growth. That distinction matters because concentration in the revenue mix is not the same as concentration in the sources of growth.

For an equity research team, the more useful question is not only which segment is largest, but how much of total company growth is being generated by that segment and whether its share of revenue is increasing over time. Product-mix concentration also provides a different view from revenue quality across cash conversion and margins: it asks where growth came from, not whether that growth converted into cash.

This workflow uses Claude with Financial Modeling Prep's MCP server to track product-level revenue across completed annual reporting periods, compare it with consolidated revenue, and measure changes in concentration and growth dependency.

The objective is to classify whether a business is diversifying, stable, becoming more concentrated, or requires further review. The screen does not explain why a product mix changed or make an investment recommendation. Those questions remain part of the analyst's follow-up work.

Defining Product-Mix Growth Dependency

The framework separates three related questions: how concentrated revenue is, which product line contributes most to incremental company growth, and whether the underlying product data is comparable enough to support those conclusions.

For each company, the workflow uses the latest three completed annual reporting periods. Three years provide two year-to-year transitions and enough history to identify directional changes while keeping the analysis compact. Because the calculation depends on equivalent periods, the same care used to align fiscal periods and reported results also applies here.

The key calculations are:

• Largest segment revenue share: largest reported product-line revenue divided by consolidated company revenue for each fiscal year.
• Change in concentration: latest largest-segment share minus the earliest share, expressed in percentage points.
• Absolute segment revenue change: latest product-line revenue minus earliest comparable product-line revenue.
• Absolute company revenue change: latest consolidated revenue minus earliest consolidated revenue.
• Product-line contribution to total growth: absolute product-line revenue change divided by absolute company revenue change.

Growth contribution is calculated for every product line whose label can be matched reliably between the earliest and latest fiscal years. The workflow then identifies the largest revenue segment and the largest contributor to company growth separately because they may not be the same business line.

The contribution-to-growth metric is not capped at 100%. A value above 100% can occur when one product line grows more than the company overall while other lines contract. A negative contribution can occur when a product line declines while other areas drive company growth.

Before calculating these metrics, the workflow validates whether reported product revenue reconciles with consolidated revenue:

Reconciliation gap = summed product revenue - consolidated revenue

Reconciliation gap % = absolute reconciliation gap / consolidated revenue × 100

For this analysis, an absolute reconciliation gap of 1% or less is treated as acceptable for the screen. A gap above 1% triggers Review Required unless a clearly disclosed reconciliation item explains the difference. The 1% threshold is an illustrative screening tolerance, not an accounting materiality standard.

A separate safeguard applies when consolidated company growth is very small. If revenue increases by less than 1% of the earliest-year revenue, the contribution denominator is considered too small for normal interpretation and the result becomes Review Required: Small Denominator. Flat or declining consolidated revenue also triggers Review Required rather than forcing a standard contribution percentage.

For concentration, a 2 percentage-point tolerance is used:

• Diversifying: concentration falls by at least 2 percentage points.
• Stable: concentration changes by less than 2 percentage points in either direction.
• Becoming More Concentrated: concentration rises by at least 2 percentage points.
• Review Required: product history cannot be compared reliably.

When the growth denominator is valid, each comparable product line is interpreted as:

• Majority Growth Contributor: more than 50% of total company growth.
• Meaningful Growth Contributor: 25% to 50%.
• Limited Growth Contributor: less than 25%, including negative contributions.

Product-label comparability is treated as a separate validation requirement. Labels are preserved exactly as returned by FMP rather than being silently renamed or remapped. If a material taxonomy change prevents reliable matching across periods, the broader product-mix analysis returns Review Required.

These thresholds are illustrative screening rules designed to make the workflow reproducible. They are not universal definitions of diversification or growth dependency.

FMP Segment Data and Claude MCP Setup

The analysis was run on August 29, 2026, using the connected FMP MCP server. It uses two FMP datasets:

FMP Tool or Dataset	Returned Fields Used	Purpose
Revenue Product Segmentation	symbol, fiscalYear, period, reportedCurrency, date, data	Product-line revenue, raw product labels, and fiscal-period alignment
Income Statement	revenue, fiscalYear, period, date	Consolidated revenue and fiscal-period reconciliation

The Revenue Product Segmentation tool returns one object per fiscal period. Within each object, the data field contains product or business-line revenue as key-value pairs. Each key is the raw label returned by FMP, and each value is that line's reported revenue.

The workflow preserves these labels exactly as returned. It does not assume that FMP applies a standardized product taxonomy across reporting periods because companies may rename, combine, split, or otherwise change their reported product categories.

The Income Statement tool provides consolidated company revenue for the corresponding fiscal year. Claude aligns the two datasets using fiscalYear, period, and date before performing the calculations. For every annual period, it sums the reported product-line revenue and compares the result with consolidated revenue.

The reconciliation output includes the product-revenue total, consolidated revenue, absolute reconciliation gap, and reconciliation gap percentage. High confidence is assigned only when all three annual periods pass the reconciliation check and the required product labels remain comparable.

To use these datasets through Claude, connect FMP through its MCP server. An active FMP API key is required. In Claude, open Settings, select Connectors, choose Add custom connector, and enter:

https://financialmodelingprep.com/mcp?apikey=YOUR_FMP_API_KEY

Once connected, start a new Claude conversation with the FMP connector enabled.

For this analysis, annual data only is requested for FY2023 through FY2025. No missing product revenue is estimated, no product labels are silently renamed or remapped, and no unavailable value is replaced with another metric. When the reporting taxonomy prevents reliable period-to-period comparison, the workflow returns Review Required.

Building the Growth-Dependency Prompt

The prompt uses AAPL, GOOGL, and AMZN as a three-company sample with different product-reporting structures. The companies are evaluated independently rather than compared as peers.

The analysis covers FY2023 through FY2025. In addition to identifying the largest revenue segment, Claude calculates the contribution to total company growth for every product line that can be matched reliably between the earliest and latest periods. This allows the largest growth contributor to be identified separately from the largest revenue segment.

The prompt also requires annual product-revenue reconciliation, exact preservation of FMP product labels, and a small-denominator safeguard before a normal growth-dependency interpretation is assigned.

Using the connected Financial Modeling Prep (FMP) MCP server, evaluate product-mix concentration and growth dependency for: Apple Inc. (AAPL) Alphabet Inc. (GOOGL) Amazon.com, Inc. (AMZN) Evaluate each company independently. Do not rank the companies as peers. Use annual data for FY2023-FY2025 only. Use: revenue-product-segmentation income-statement Do not estimate missing values or silently combine, rename, normalize, or remap product labels. Data validation For each company and fiscal year: align product-segmentation and consolidated revenue by fiscal year; sum all reported product-line revenues; calculate reconciliation gap = summed product revenue − consolidated revenue; calculate reconciliation gap % = absolute reconciliation gap / consolidated revenue × 100; treat an absolute gap of 1% or less as acceptable; return Review Required for an unexplained gap above 1%. The 1% threshold is an illustrative screening tolerance, not accounting materiality. Preserve the exact raw labels returned by FMP. If product taxonomy changes materially and exact period-to-period comparability cannot be established, return Review Required rather than mapping categories manually. Concentration For each fiscal year: largest segment share = largest reported product revenue / consolidated revenue Across FY2023-FY2025: change in concentration = FY2025 largest-segment share − FY2023 largest-segment share Classify: Diversifying: decline of at least 2 percentage points Stable: change of less than 2 percentage points in either direction Becoming More Concentrated: increase of at least 2 percentage points Review Required: product history cannot be compared reliably Product-line growth contribution For every product line that can be matched reliably between FY2023 and FY2025, calculate: absolute segment revenue change = FY2025 product revenue − FY2023 product revenue absolute company revenue change = FY2025 consolidated revenue − FY2023 consolidated revenue contribution to total growth = absolute segment revenue change / absolute company revenue change Do not cap the contribution at 100%. Report every comparable product line separately and identify: the largest revenue segment in FY2025; the largest contributor to total company growth across FY2023-FY2025. Do not assume these are the same product line. Interpret contribution when the denominator is valid: More than 50%: Majority Growth Contributor 25%-50%: Meaningful Growth Contributor Less than 25%: Limited Growth Contributor Negative contributions are allowed when a product line contracts while consolidated revenue grows. Small-denominator safeguard Always report the absolute segment revenue change and absolute consolidated revenue change. If FY2025 consolidated revenue exceeds FY2023 revenue but the increase is less than 1% of FY2023 revenue, return: Review Required — Small Denominator Do not interpret the percentage normally. If consolidated revenue is flat or declining, also return Review Required for growth dependency. Confidence High: All three annual periods are available; Reconciliation gap is 1% or less in each period; Required product labels are comparable; Calculations are reproducible. Medium: Calculations remain usable but a minor disclosed reporting or reconciliation issue remains. Review Required: Reconciliation gap exceeds 1%; Product taxonomy materially prevents comparison; Required history is incomplete; The growth denominator fails the safeguard. Return only three compact tables Table 1 — Product-Revenue Reconciliation | Company | Fiscal Year | Summed Product Revenue | Consolidated Revenue | Reconciliation Gap | Gap % | Status | Table 2 — Product-Line Growth Contribution | Company | Product Line | FY2023 Revenue | FY2025 Revenue | Absolute Segment Change | Absolute Company Revenue Change | Contribution to Growth | Classification | Include every product line that can be matched reliably across FY2023 and FY2025. Table 3 — Product-Mix and Growth-Dependency Summary | Company | FY2025 Largest Revenue Segment | FY2025 Share | Change in Concentration | Largest Growth Contributor | Growth Contributor % | Concentration Classification | Growth-Dependency Interpretation | Confidence | Analyst Follow-Up | For Alphabet, also list the exact FY2025 raw labels returned by FMP and state whether they are comparable with FY2023-FY2024. Do not add unsupported business explanations. Keep analyst follow-up to one specific question or action tied to the returned data. Keep the response concise.

Growth-Dependency Results and Interpretation

The analysis separates the largest revenue segment from the product line contributing the most incremental revenue. It also validates annual product-revenue reconciliation before assigning confidence.

Table 1: Product-Revenue Reconciliation

Company	Fiscal Year	Summed Product Revenue	Consolidated Revenue	Reconciliation Gap	Gap %	Status
AAPL	FY2025	$416,161M	$416,161M	$0M	0.00%	Pass
AAPL	FY2024	$391,035M	$391,035M	$0M	0.00%	Pass
AAPL	FY2023	$383,285M	$383,285M	$0M	0.00%	Pass
GOOGL	FY2025	$402,836M	$402,836M	$0M	0.00%	Pass
GOOGL	FY2024	$349,807M	$350,018M	-$211M	0.06%	Pass
GOOGL	FY2023	$307,158M	$307,394M	-$236M	0.08%	Pass
AMZN	FY2025	$716,924M	$716,924M	$0M	0.00%	Pass
AMZN	FY2024	$637,959M	$637,959M	$0M	0.00%	Pass
AMZN	FY2023	$574,785M	$574,785M	$0M	0.00%	Pass

All three companies remain within the illustrative 1% reconciliation tolerance in every year. AAPL and AMZN reconcile exactly, while Alphabet's largest gap is 0.08%.

Table 2: Product-Line Growth Contribution

The results are grouped by company so the product labels and calculations remain readable.

Apple

Product Line	FY2023 Revenue	FY2025 Revenue	Absolute Segment Change	Absolute Company Revenue Change	Contribution to Growth	Classification
Mac	$29,357M	$33,708M	$4,351M	$32,876M	13.24%	Limited
Service	$85,200M	$109,158M	$23,958M	$32,876M	72.87%	Majority
Wearables, Home and Accessories	$39,845M	$35,686M	-$4,159M	$32,876M	-12.65%	Limited (negative)
iPad	$28,300M	$28,023M	-$277M	$32,876M	-0.84%	Limited (negative)
iPhone	$200,583M	$209,586M	$9,003M	$32,876M	27.39%	Meaningful

Alphabet

Product Line	FY2023 Revenue	FY2025 Revenue	Absolute Segment Change	Absolute Company Revenue Change	Contribution to Growth	Classification
Google Search & Other	$175,033M	$224,532M	$49,499M	$95,442M	51.86%	Majority
Google Network	$31,312M	$29,792M	-$1,520M	$95,442M	-1.59%	Limited (negative)
Google Cloud	$33,088M	$58,705M	$25,617M	$95,442M	26.84%	Meaningful
Other Bets	$1,527M	$1,537M	$10M	$95,442M	0.01%	Limited

Amazon

Product Line	FY2023 Revenue	FY2025 Revenue	Absolute Segment Change	Absolute Company Revenue Change	Contribution to Growth	Classification
Advertising Services	$46,906M	$68,635M	$21,729M	$142,139M	15.29%	Limited
Amazon Web Services	$90,757M	$128,725M	$37,968M	$142,139M	26.71%	Meaningful
Online Stores	$231,872M	$269,287M	$37,415M	$142,139M	26.32%	Meaningful
Other Services	$4,958M	$5,935M	$977M	$142,139M	0.69%	Limited
Physical Stores	$20,030M	$22,561M	$2,531M	$142,139M	1.78%	Limited
Subscription Services	$40,209M	$49,619M	$9,410M	$142,139M	6.62%	Limited
Third-Party Seller Services	$140,053M	$172,162M	$32,109M	$142,139M	22.59%	Limited

Alphabet includes only product lines whose labels match exactly between FY2023 and FY2025. Product lines affected by the FY2025 taxonomy change are excluded rather than manually remapped.

No company triggered the small-denominator safeguard. Consolidated revenue increased by 8.58% of FY2023 revenue for AAPL, 31.06% for GOOGL, and 24.73% for AMZN. All three results are above the illustrative 1% floor.

Table 3: Product-Mix and Growth-Dependency Summary

The summary separates concentration, growth dependency, and analyst follow-up so each result remains clear.

Concentration

Company	FY2025 Largest Revenue Segment	FY2025 Share	Change in Concentration	Concentration Classification
AAPL	iPhone	50.36%	-1.97pp	Stable
GOOGL	Google Search & Other	55.74%	-1.20pp	Review Required
AMZN	Online Stores	37.56%	-2.78pp	Diversifying

Growth Dependency

Company	Largest Growth Contributor	Growth Contributor %	Growth-Dependency Interpretation	Confidence
AAPL	Service	72.87%	Majority Growth Contributor (Service)	High
GOOGL	Review Required	N/A	Review Required	Review Required
AMZN	Amazon Web Services	26.71%	Meaningful Growth Contributor (AWS)	High

Analyst Follow-Up

Company	Analyst Follow-Up
AAPL	The largest revenue segment and largest growth contributor differ. Determine whether Services growth is concentrated in one sub-line before treating it as a durable driver.
GOOGL	FY2025 taxonomy changes prevent identification of the overall largest growth contributor. Verify the raw product mappings before interpretation.
AMZN	AWS and Online Stores contributed similar amounts of incremental revenue. Monitor the next period to confirm which remains the largest growth contributor.

Apple: Largest Revenue Segment and Growth Driver Diverge

Apple remains Stable under the illustrative 2 percentage-point concentration rule. iPhone's share declined from 52.33% in FY2023 to 50.36% in FY2025, a 1.97 percentage-point decrease.

However, iPhone was not Apple's largest contributor to incremental revenue. Service revenue increased by $23,958 million and accounted for 72.87% of total company revenue growth, compared with 27.39% from iPhone.

This demonstrates why growth dependency should be calculated across every comparable product line rather than inferred from the largest revenue segment alone.

Alphabet: Product Taxonomy Requires Review

Alphabet's reported product revenue reconciles with consolidated revenue within the 1% tolerance, but reconciliation alone is not enough to support a normal classification.

The exact FY2025 raw labels returned by FMP were:

• Google Network
• Google Search & Other
• YouTube Advertising Revenue
• Google Inc.
• Google Cloud
• Other Bets
• Other Segments

FY2023 and FY2024 instead included labels such as YouTube Ads and Google Subscriptions Platforms And Devices. Because Google Inc. and Other Segments have no exact prior-period counterparts and other labels changed, the broader FY2025 taxonomy cannot be matched reliably without introducing an undocumented mapping.

Google Search & Other remains an exact matched line and contributed 51.86% of total company growth. However, because several other FY2025 product lines cannot be matched reliably with FY2023, the analysis cannot establish whether Search was the overall largest growth contributor across the complete product taxonomy. Alphabet's broader concentration and growth-dependency conclusion is therefore Review Required.

Amazon: AWS Becomes the Largest Growth Contributor

Amazon remains Diversifying under the concentration rule. Online Stores' share declined from 40.34% in FY2023 to 37.56% in FY2025, a 2.78 percentage-point decrease.

Online Stores remains Amazon's largest revenue line, but Amazon Web Services generated the largest absolute revenue increase across the period. AWS revenue increased by $37,968 million, representing 26.71% of total company growth. Online Stores increased by $37,415 million, representing 26.32%.

The difference is narrow, but the result demonstrates why the largest revenue segment and the largest contributor to incremental growth should be measured separately.

Monitoring Concentration Across Future Reporting Periods

Once the initial screen is validated, the same analysis can be repeated when new annual product disclosures become available. Because the workflow depends on completed annual data, there is little value in rerunning it daily. A more practical approach is to refresh the analysis after a new fiscal-year disclosure becomes available.

This annual review can sit alongside a broader post-earnings data refresh checklist without forcing all datasets onto the same schedule. Each refresh can:

1. Add the newest completed fiscal year.
2. Reconcile summed product revenue with consolidated revenue.
3. Recalculate the largest product-line revenue share.
4. Calculate absolute revenue growth for every comparable product line.
5. Identify the largest contributor to incremental company revenue.
6. Compare both concentration and growth dependency with the previous window.
7. Flag changes in product taxonomy, confidence, or classification for analyst review.

The distinction between the largest revenue segment and largest growth contributor should remain explicit as the screen is refreshed. As the Apple and Amazon results demonstrate, the business line with the greatest revenue share may not be the one generating the most incremental growth.

The same validation rules should remain in place as the workflow scales. If product labels change materially, annual revenue fails the reconciliation tolerance, or the company-growth denominator becomes too small for reliable interpretation, the analysis should return Review Required rather than carrying forward an earlier classification.

For a larger research universe, companies can be processed in small batches while keeping the calculation, reconciliation, and classification rules fixed. The same controls that turn an API test into a repeatable financial data workflow also help keep the output consistent as coverage expands.

When an Analyst Needs to Step In

The workflow can standardize reconciliation, concentration, and growth-contribution calculations, but it should not force a conclusion when the underlying product structure or denominator is unreliable.

Analyst review is required when:

• Summed product revenue differs from consolidated revenue by more than the illustrative 1% reconciliation tolerance.
• A product line is renamed, combined, split, added, or removed and exact period-to-period comparability cannot be established.
• The largest revenue segment changes and its prior-period label cannot be matched reliably.
• Consolidated revenue growth is positive but less than 1% of earliest-period revenue, creating a small denominator that can distort contribution percentages.
• Consolidated revenue is flat or declines across the analysis window.
• A contribution exceeds 100% or becomes negative and the offsetting product-line movements require investigation.
• The largest revenue segment and largest growth contributor differ materially and the analyst needs to understand what is driving the change.
• Required history is incomplete or another data issue triggers Review Required.

Alphabet illustrates why taxonomy validation must be separate from reconciliation. Its product revenues remain within the reconciliation tolerance, but FY2025 introduces raw labels that cannot be matched reliably with prior periods. The broader product-mix and growth-dependency analysis therefore remains Review Required.

Apple and Amazon illustrate a different analytical follow-up. Their data passes reconciliation and comparability checks, but the largest revenue segment is not the largest contributor to incremental growth. In those cases, the analyst should investigate whether the emerging growth contributor represents a durable shift or a temporary reporting-period effect.

For clean cases, the workflow can identify where revenue concentration and incremental growth dependency are changing. The analyst must then determine the business explanation behind those movements.

From Segment Mix to Growth-Dependency Monitoring

Product-mix concentration becomes more informative when the largest revenue segment is analyzed separately from the business line contributing the most incremental growth.

Using FMP product-segmentation data through Claude MCP, this workflow measures four things together: annual product-revenue reconciliation, changes in the largest segment's revenue share, each comparable product line's contribution to total company growth, and the reliability of the underlying product taxonomy.

The results show why these distinctions matter. Apple's iPhone remains its largest revenue line, while Service generated the majority of incremental revenue across the analysis window. Amazon's Online Stores remains its largest reported line, while AWS contributed slightly more absolute growth. Alphabet, meanwhile, demonstrates that clean reconciliation does not guarantee reliable period-to-period comparability when the reported product taxonomy changes.

This creates a more reliable first-pass research process that distinguishes revenue concentration from growth dependency while identifying cases where the data requires analyst review. As new annual reporting periods become available, the same methodology can be refreshed to monitor whether growth is becoming broader, increasingly dependent on one product line, or less comparable because of reporting changes.