TL;DR: Consolidated growth can conceal contraction in a profitable business when a smaller, lower-margin division expands quickly. Reconstruct revenue contributions, segment margins, mix effects, corporate costs, and capital needs before extrapolating the headline growth rate. A company can grow sales, improve every segment's margin, and still report a lower overall margin.
The worksheet below examines a fictional company called Rook Industries. It has a mature equipment division and a newer services division. Management reports eight-percent revenue growth and improving segment margins. Those statements are accurate in the example, yet they leave an investor with an incomplete picture of the earnings trajectory.
The accounting context comes from the IFRS Foundation's IFRS 8 overview, which describes segment and related disclosures, and its explanations of revenue recognition and foreign-currency effects. The SEC's non-GAAP interpretations provide a separate U.S. reference for reading adjusted measures. All company figures are invented for analytical instruction, not presented as an issuer's results or an investment recommendation.
Worksheet A: Write the two businesses on separate lines
In the prior period, Rook's equipment division generated revenue of 800 and a segment profit margin of thirty percent, producing profit of 240. Services generated revenue of 200 at a five-percent margin, producing profit of ten. Total segment revenue was 1,000 and total segment profit was 250.
In the current period, equipment revenue falls to 720 while its margin rises to thirty-two percent. Its profit is 230.4. Services revenue rises to 360 and its margin improves to six percent, producing profit of 21.6. Consolidated segment revenue is 1,080, while combined segment profit is 252.
The arithmetic supports the headline: revenue grew eight percent. It also shows that segment profit grew only 0.8 percent. The mature division's 9.6 profit decline consumed most of the newer division's 11.6 profit increase. A reader who sees only the top-line growth rate could miss that dependence.
The first worksheet therefore records revenue, profit, and margin for each disclosed segment in both periods. It uses consistent definitions and marks any restatements. Before creating a thesis about the company's growth engine, the analyst needs to know which engine is shrinking and how much profit it currently supplies.
The four operating lines can be checked directly:
| Division and period | Revenue | Segment margin | Segment profit |
|---|---|---|---|
| Equipment, prior | 800 | 30% | 240 |
| Services, prior | 200 | 5% | 10 |
| Equipment, current | 720 | 32% | 230.4 |
| Services, current | 360 | 6% | 21.6 |
The table is intentionally limited to segment results. Corporate costs enter a later bridge, so a reader should not mistake either total for the company's final operating profit. Keeping that boundary visible prevents a common spreadsheet error: using a segment subtotal as the numerator while attaching a valuation multiple intended for consolidated earnings.
A second reviewer should be able to reproduce every margin from the revenue and profit columns without referring to the narrative. If a company's disclosed figures do not reconcile because of eliminations, rounding, or different measurement definitions, those differences should appear as named lines. Forcing the subtotal to match through an unexplained adjustment would remove the evidence that the analyst most needs to investigate.
Worksheet B: A growth rate is weighted by the starting business
Equipment's revenue decline is ten percent, while services grows eighty percent. Averaging those percentages would produce thirty-five percent, which has no useful relationship to the company's eight-percent growth. The divisions began at very different sizes.
Using prior-period revenue weights, equipment contributes eighty percent times minus ten percent, or minus eight percentage points. Services contributes twenty percent times eighty percent, or sixteen percentage points. Together they produce eight percentage points of consolidated growth.
The contribution view is useful because it expresses both businesses in units of the group result. It prevents a small division's dramatic percentage from dominating the narrative while a large division quietly loses more revenue in absolute terms. It also makes the amount of new growth required to offset future contraction visible.
The analyst should not assume that the same weights will hold next period. As services expands, it becomes a larger share of the company. Forecasting the group by repeatedly applying last year's consolidated rate can conceal that changing composition. A segment model makes the transition explicit and allows each business to follow a different trajectory.
Worksheet C: Every margin improves, yet the group margin falls
Rook's prior combined segment margin was 250 divided by 1,000, or twenty-five percent. The current margin is 252 divided by 1,080, or about 23.3 percent. Both segment margins improved, but the group margin declined because the lower-margin services business became a larger share of revenue.
This is a mix effect, not an arithmetic contradiction. The investor needs to distinguish within-segment improvement from the changing weights applied to those margins. A company can execute better inside each division while moving toward a business mix that produces less profit per dollar of reported sales.
The result does not automatically make the strategy unattractive. Services may have better growth prospects, lower risk, or different capital requirements. Its margin may also improve with scale. Those possibilities require analysis. The current group-margin decline should be explained by the mix rather than dismissed or treated as proof that every operation deteriorated.
The worksheet helps management's statements coexist accurately. “Segment margins improved” and “group margin fell” can both be true. The analyst's job is to show how they fit together and what the changing composition means for future earnings, cash, and valuation.
Worksheet D: Separate scale, mix, and margin
A transparent bridge begins with the prior segment profit of 250. If total revenue rises to 1,080 while retaining the old eighty-twenty revenue mix and old margins, profit becomes 270. That is a twenty-unit scale contribution at the prior group margin.
Next apply the actual current revenue mix while retaining old segment margins. Equipment contributes 720 times thirty percent, or 216. Services contributes 360 times five percent, or eighteen. Total profit becomes 234, a negative 36-unit mix contribution relative to the constant-mix case.
Finally apply the new segment margins. Equipment's two-percentage-point improvement adds 14.4, and services' one-point improvement adds 3.6. The combined margin improvement contributes eighteen, bringing profit to 252. The bridge is 250 plus twenty minus 36 plus eighteen.
This is one explicit decomposition convention. Other orders of calculation can allocate interaction effects differently. The analyst should state the convention rather than present one bridge as a uniquely ordained breakdown. What matters is that it reconciles exactly and reveals the economic forces hidden inside the consolidated result.
Worksheet E: The corporate line changes the conclusion
Segment profit is not necessarily consolidated operating profit. Suppose Rook's unallocated corporate costs rise from 25 to forty. Prior operating profit is then 225, and current operating profit is 212. The company has eight-percent revenue growth and slightly higher combined segment profit, yet operating profit falls by about 5.8 percent.
The corporate line may include necessary shared functions, central research, or other costs not allocated to segment measures. The analyst reads the reconciliation instead of assuming those costs are optional or irrelevant. A growth strategy can require a larger central platform even when individual divisions report attractive contribution margins.
The next question is whether the increase is temporary, recurring, or a reclassification. A one-time investment can have a different implication from a permanently higher cost base, but the label should be supported by the nature of the expenditure and subsequent evidence. Repeatedly excluding the same necessary costs would overstate sustainable profit.
Rook's investment committee receives both segment and consolidated bridges. That prevents a favorable divisional story from bypassing the actual earnings available to fund taxes, investment, and financing. Segment detail is valuable precisely because it can be reconciled back to the whole business.
The segment definition can change beneath the spreadsheet
Management reorganizes equipment maintenance into the services division. The next report shows faster services growth and a smaller equipment business. Without recast comparative figures, the analyst could mistake a reporting-boundary change for an economic shift.
IFRS 8 provides the relevant disclosure framework, but the analyst still needs to inspect how the issuer defines and measures its segments. Segment labels can reflect management's operating structure and may change as that structure changes. A long time series assembled from labels alone can therefore combine unlike businesses.
Rook's worksheet records the effective date of each definition and whether prior periods were restated. If the company provides a bridge, the analyst uses it. If it does not, the model marks the break and avoids computing a clean growth rate across incomparable boundaries.
The same issue affects margins and assets. Moving a cost center between segments can improve one margin and worsen another without changing group profit. A genuine operating improvement should survive a consistent-boundary comparison. The analyst should ask for that comparison before attributing the change to better execution.
Acquisitions add revenue before organic growth is understood
Suppose forty units of Rook's current revenue came from an acquired business, while currency translation reduced reported revenue by ten relative to the chosen constant-currency comparison. In a simplified bridge with no disposals or other adjustments, current comparable revenue is 1,080 minus forty plus ten, or 1,050. Against 1,000 in the prior period, that implies five-percent comparable growth.
The example shows why reported growth and organic or constant-currency growth can differ. It does not establish a universal formula for every company's adjusted measure. Acquisition timing, disposals, accounting changes, and the choice of currency rates can affect the calculation. The analyst reads the definition and reconciliation.
The acquired revenue also came with a purchase price. A segment can grow quickly through acquisitions while earning an inadequate return on the capital spent to obtain that growth. The revenue bridge should therefore connect to acquisition cash outflows, integration costs, and the acquired business's contribution.
Rook's model separates existing-business growth from purchased growth and states how each is forecast. Combining them into one recurring rate would implicitly assume that future acquisitions arrive without cost or execution risk. A disciplined forecast makes the capital required to sustain the growth story visible.
Currency translation is not the same as local demand
A foreign division can grow in its local currency while reporting lower revenue in the group's presentation currency. Conversely, a favorable exchange-rate movement can raise reported revenue without any increase in local sales. IAS 21 provides the accounting context for foreign-currency effects, while an analyst's constant-currency view is a defined analytical comparison.
The useful question depends on the decision. Local-currency growth helps assess customer demand and operating performance in that market. Reported-currency results matter to the consolidated statements and shareholders. Neither view should erase the other, especially when costs and financing are exposed to different currencies.
Rook's worksheet keeps local operating trends separate from translation assumptions. It also asks whether management has changed the rates or methodology used in its adjusted comparison. A constant-currency measure can be informative, but consistency across periods is necessary for a meaningful trend.
The analyst avoids forecasting exchange rates with unwarranted precision simply to complete the model. Scenario analysis can show how a range of translation outcomes affects the group. The core business thesis should identify which conclusions depend on local execution and which depend on currency movements outside management's control.
Price, volume, and mix are different growth engines
Equipment revenue declines ten percent, but that figure alone does not show whether unit volume fell, prices changed, or customers shifted toward cheaper products. A division with stable units and lower prices faces a different problem from one losing customers while raising prices on the remaining base.
The analyst seeks a price-volume-mix bridge where the business can disclose it meaningfully. For heterogeneous services, a simple unit count may not exist. In that case, contracts, customer cohorts, usage, or another operational measure can provide context, but the analyst should not force a manufacturing-style decomposition onto an unsuitable business.
The bridge should also distinguish contractual price increases from realized revenue per unit. Discounts, product configuration, and customer mix can offset list-price changes. A statement that prices rose does not establish that the average economics of delivered work improved.
Rook's forecast uses the available operational evidence to define scenarios. One case assumes equipment volume stabilizes while pricing holds; another assumes further volume decline. Services growth is modeled through its own drivers. This produces a more informative earnings range than extending the consolidated eight-percent rate without understanding what created it.
Gross and net revenue can make unlike margins look comparable
Consider two simplified businesses that each facilitate 1,000 of customer spending. One acts as a reseller and reports 1,000 of revenue with 900 of related cost, leaving 100 of gross profit. Another earns a 100 commission and reports that amount as revenue under its applicable principal-agent assessment, with the example ignoring other costs.
The first appears to have a ten-percent gross margin and the second a hundred-percent margin in this deliberately simplified presentation. Their revenue bases describe different things. Comparing the percentages as though they measured identical economics would be misleading.
IFRS 15's revenue framework is the starting point for understanding what an issuer recognizes as revenue. The analyst should examine the business model and accounting policy before comparing segments that include marketplaces, reselling, services, or pass-through activity. Transaction volume and recognized revenue are not interchangeable.
Rook's services expansion includes some intermediary activity. The model therefore tracks the underlying activity measure separately from recognized revenue where disclosed. A change in presentation or business model can alter the revenue mix without a proportionate change in economic value captured. The analysis should follow the value retained, not just the largest reported top line.
Customer concentration can hide inside a diversified group
Rook appears diversified because it operates two divisions across several regions. The services division, however, may depend heavily on a small number of customers. Its rapid growth could reflect one large contract rather than broad adoption. Group-level diversification does not automatically protect each growth engine.
IFRS 8 includes related disclosures concerning major customers and geographic areas. The analyst uses those disclosures to investigate concentration without assuming that undisclosed customer identities can be inferred. The relevant questions concern exposure, contract duration, renewal conditions, and the cost of serving large accounts.
A large contract can be attractive while still making the forecast more sensitive to a single decision. The model can show the effect of delayed renewal or lower usage rather than simply adding a generic risk discount. Concrete scenarios make the concentration's financial consequence visible.
The analyst also checks whether the same customer contributes to several segments. Apparent divisional diversification may still depend on one underlying relationship. Where public information does not resolve that issue, the limitation belongs in the committee discussion rather than being filled with speculation.
Capital intensity decides how valuable the growth is
Services grows faster than equipment, but it may require investment in staff, software, facilities, or working capital. A higher revenue contribution is not automatically a higher contribution to shareholder value. The analyst needs to connect incremental profit with the resources required to produce it.
Suppose the illustrative services profit increase of 11.6 required 300 of additional capital committed during the expansion. The simple ratio of the profit change to that capital is about 3.9 percent. That is not a complete incremental ROIC estimate because timing, taxes, maturation, and the definition of capital matter. It is a prompt to investigate whether the growth has yet earned an adequate return.
Alternatively, the new services revenue may use an existing platform with little incremental capital, producing attractive economics despite a low initial margin. The same revenue and profit figures can support different conclusions depending on the investment path. Segment assets and cash-flow disclosures are therefore valuable companions to the income statement.
Rook's forecast includes an explicit maturation period and investment schedule. It does not assume that today's low margin is permanent, nor that future scale automatically creates high margins. The evidence required for each improvement is named so the thesis can be revised when actual results arrive.
Shared costs create an allocation question
A central technology platform supports both divisions. Management allocates its cost according to revenue, but the equipment division uses more of its capacity. Services' rapid revenue growth changes the allocation even if underlying usage does not change. Reported segment margins can move because of the allocation rule.
The analyst asks how shared costs are assigned and whether the basis changed. A segment profit measure can be useful for management decisions without representing a fully standalone business. Valuing a division as if it could operate independently may require additional costs that are currently held centrally or allocated differently.
The model distinguishes reported segment profit from an estimated standalone contribution where such an estimate is necessary. It labels the latter as analysis and avoids claiming precision unsupported by disclosure. A sum-of-the-parts valuation is particularly vulnerable to counting each division's favorable contribution while forgetting the central costs needed to support them all.
The reconciliation back to group profit remains the discipline. If the modeled parts produce much more earnings than the consolidated company, the analyst must explain the difference. It cannot be dismissed as an accounting nuisance when shareholders ultimately receive the economics of the whole organization.
The adjusted metric needs a stable definition
Rook presents an adjusted services margin excluding selected integration and platform costs. The analyst reads the reconciliation and compares the treatment with prior periods. An adjustment can improve comparability, but it can also remove expenditures that recur as part of the company's strategy.
The SEC's non-GAAP interpretations warn that some adjustments, including exclusions of normal recurring operating expenses or inconsistent treatment across periods, can be misleading in the relevant U.S. context. This is a source for reading disclosure carefully, not a legal conclusion about the fictional company or every IFRS issuer.
The analyst asks whether gains and losses receive symmetrical treatment and whether the excluded costs are necessary to sustain the forecast. If acquisitions are a recurring growth strategy, excluding every integration cost from sustainable earnings may overstate the economics of that strategy.
Rook's committee sees reported results, management's adjusted measure, and the analyst's chosen forecast basis separately. The model explains why each adjustment is retained or reversed. This preserves the useful information in management's presentation without treating the adjusted label as an automatic instruction to ignore a real cost.
The forecast must survive a slower growth division
The services division's eighty-percent growth rate is unlikely to remain mechanically constant as its base expands. The analyst tests a slower-growth case while equipment continues to contract. This reveals how much of the group's future depends on services replacing lost mature-business revenue and profit.
A simple forecast might hold equipment revenue at 720 and grow services from 360 to 432, a twenty-percent increase. Group revenue becomes 1,152, about 6.7 percent above 1,080. If equipment instead falls another ten percent to 648, the same services outcome leaves total revenue at 1,080, with no group growth.
The profit result then depends on each margin and corporate costs. A consolidated growth assumption would hide this fork. The segment model makes it clear which operating result must improve for the investment case to work and how much room exists if one division disappoints.
The analyst avoids presenting either case as a prediction without evidence. Scenarios are tools for understanding dependence. The committee can then judge whether the current valuation requires a particular favorable combination of stabilization, growth, and margin expansion.
The reconstruction changes the headline
Rook's eight-percent revenue growth is real, but its meaning changes after reconstruction. The mature high-margin business shrank, the lower-margin business expanded, combined segment profit barely grew, and higher corporate costs reduced operating profit. Improving segment margins did not prevent a lower group margin because the revenue mix changed.
The analyst's final report leads with those mechanisms rather than a verdict that growth is good or bad. It identifies the evidence needed to support the transition: durable services demand, acceptable incremental returns, equipment stabilization, and a central cost base that does not absorb every new profit contribution.
The worksheet remains useful next quarter because it is built from reconciliations rather than slogans. Changes in segment boundaries, acquisitions, currency, and accounting presentation are recorded before the growth rates are compared. The committee can see whether the business is improving or merely being described through a different lens.
A diversified company's headline is the sum of businesses with different economics. Reading those businesses separately, and then reconciling them back together, turns an attractive percentage into a testable investment argument.