Syntha Lab RU

Consolidation of two entities: eliminating turnover and unrealized profit

Adds up the P&L and balance sheets of two group entities and eliminates intra-group turnover, mutual balances and unrealized profit in the buyer’s stock; shows consolidated revenue, EBITDA, profit, assets and equity and checks that the consolidated balance sheet ties.

Capital, multi-brand and the planning cycle For whom: Chief financial officers, accountants and owners of groups made up of a brand and a retailer (or a producer and an importer).

Calculate on your data →

At a glance

What question does it answer?
What revenue, profit, assets and equity the group shows after eliminating internal sales, balances and profit in stock.
What data is needed?
For two entities: the P&L and the year-end balance sheet.
How to read the result?
On the default data (the brand “Model B” sells to the retailer “Model R”) turnover of 17,250,000 (8.3% of the brand’s revenue) is eliminated; 30% remains in the buyer’s stock at the seller margin of 47.8%, unrealized profit 2,475,000, tax on it 618,750. Consolidated revenue is 699,574,000 against the sum of 716,824,000, EBITDA 67,373,000 (margin 9.63% against 9.74% for the sum), net profit 30,856,750, assets 288,215,750, equity 128,336,750, the balance check is zero. Example on the default values: Intra-group turnover (eliminated): RUB 17.3 million; Turnover share of the seller’s revenue: 8.3%; Seller gross margin on internal sales: 47.8%; Unrealized profit in the buyer’s stock: RUB 2.48 million. The figures are illustrative: enter your own to see your result.

Why and how to reason

A group of two legal entities (a brand sells to a retailer in the same group) shows an investor and a bank the overall picture: how much revenue and profit the group really has. But sales between the group’s own entities create nothing new, and profit on unsold goods is not yet earned. Consolidation is addition with eliminations. Intragroup turnover 7,500 units × 2,300 = 17.25 million is eliminated from the seller’s revenue and from the buyer’s cost. Part of the goods (30%) remained in the buyer’s stock, so the seller’s profit on it is not realized: 17.25 × 30% × (2,300 − 1,200) ÷ 2,300 = 2.48 million. It is eliminated too, but the tax on it (619 thousand) remains as a deferred asset. Group revenue is 716.8 − 17.25 = 699.6 million. The balance must reconcile: assets minus liabilities minus equity equals zero.

When to use it

It comes in handy for the management reporting of a group, when preparing for a loan or an investor and when checking transfer prices. It does not replace consolidated statements under standards: the rules of consolidation and deferred taxes are set by accounting policy and standards, check them. Assumptions: two legal entities, one intragroup flow, the share remaining in stock is known, a single tax rate. It is useful before a deal too: it shows the group to an investor without distortion by internal sales.

How to read the result

First check that the balance reconciles: if the difference is not zero, the input is incomplete. Then compare the sum of revenues before elimination (716.8 million) with group revenue (699.6 million): intragroup turnover of 8.3% of the seller’s revenue measures how much of the group’s sales are “internal”. The group’s EBITDA margin of 9.6% is lower than the brand’s because retail is included. Unrealized profit (2.5 million) is worth showing separately: it becomes real when the goods are sold outside, so until then it cannot be treated as earned. It is worth matching consolidated EBITDA with the sum of the EBITDA of the links: the difference equals unrealized profit and shows how much the group depends on internal prices.

Common mistakes

Typical trap: eliminating turnover but not the profit in stock, eliminating receivables without payables, taking the internal price not from the contract, forgetting tax on unrealized profit, treating interest and dividends inside the group as external. Reconcile price and quantity with the primary documents of both entities.

What data is needed?

  • For two entities: the P&L and the year-end balance sheet.
  • Intra-group sales: units, price, the seller’s cost.
  • The share of internal purchases in the buyer’s stock, the intra-group balance, the tax rate.

Inputs

FieldUnitValue in the exampleMeaning
Sold within the grouppcs7,500Units the first entity (brand, producer) sold to the second (retailer) in the period. The default comes from the end-to-end “Model B” (a brand, illustrative data).
Internal price per unit₽2,300The transfer price excl. VAT at which the intra-group sale takes place. The default comes from the end-to-end “Model B” (a brand, illustrative data).
Seller’s unit cost₽1,200Full production or landed unit cost excl. VAT. For footwear, accessories and children’s the values differ markedly: take your own. The default comes from the end-to-end “Model B” (a brand, illustrative data).
Share of internal purchases still in the buyer’s stock%30The part of the goods bought from the own brand not sold to outside customers at period end: from the buyer’s stock records. The default comes from the end-to-end “Model B” (a brand, illustrative data).
Intra-group balance at the end₽2,595,000The buyer’s debt to the seller (the seller’s receivable equals the buyer’s payable) as booked, including VAT if it is in the balance. The default comes from the end-to-end “Model B” (a brand, illustrative data).
Corporate income tax rate%25For tax on unrealized profit (a deferred tax asset). Check the procedure with an accountant. The example value is illustrative.

How it is calculated

StepFormula
Turnoverunits × internal price: eliminated from the seller’s revenue and the buyer’s cost of sales
Unrealised profitturnover × share in the buyer’s stock × (price − cost) ÷ price
Tax on itunrealised profit × rate: a deferred tax asset
P&Lrevenue − turnover; EBITDA − unrealised profit; profit − (unrealised − tax)
Balance sheetreceivables and payables − the intra-group balance; inventory − unrealised; other assets + tax; equity − (unrealised − tax)
Checkassets − liabilities − equity is zero

Worked numbers

Default values from the app; in the interactive version you enter your own.

Intra-group turnover (eliminated)
17.3 m ₽
Turnover share of the seller’s revenue
8.3 %
Seller gross margin on internal sales
47.8 %
Unrealised profit in the buyer’s stock
2.48 m ₽
Deferred tax on unrealised profit
618,750 ₽
Sum of revenue before elimination
716.8 m ₽
Consolidated revenue
699.6 m ₽
Consolidated EBITDA
67.4 m ₽
Consolidated EBITDA margin
9.6 %Above the sum without eliminations: revenue falls by the turnover while EBITDA falls only by the unrealised profit.
Consolidated net profit
30.9 m ₽
Consolidated assets
288.2 m ₽
Consolidated equity
128.3 m ₽
Consolidated balance check: assets − liabilities − equity
0 ₽

Consolidated statements with eliminations

LineBrand (seller)Retailer (buyer)SumEliminationsConsolidated
Revenue206.7 m ₽510.2 m ₽716.8 m ₽−17.3 m ₽699.6 m ₽
Cost of sales (negative)−90.2 m ₽−263.8 m ₽−354 m ₽14.8 m ₽−339.2 m ₽
Gross profit116.4 m ₽246.4 m ₽362.8 m ₽−2.48 m ₽360.4 m ₽
EBITDA35 m ₽34.8 m ₽69.8 m ₽−2.48 m ₽67.4 m ₽
Net profit21.1 m ₽11.7 m ₽32.7 m ₽−1.86 m ₽30.9 m ₽
Cash14.4 m ₽1.77 m ₽16.1 m ₽0 ₽16.1 m ₽
Receivables22.5 m ₽3.41 m ₽25.9 m ₽−2.6 m ₽23.3 m ₽
Net inventory55.8 m ₽99.7 m ₽155.5 m ₽−2.48 m ₽153 m ₽
Other assets (with the deferred tax asset)23.7 m ₽71.4 m ₽95.1 m ₽618,750 ₽95.7 m ₽
Total assets116.3 m ₽176.3 m ₽292.7 m ₽−4.45 m ₽288.2 m ₽
Payables9.78 m ₽54.6 m ₽64.4 m ₽−2.6 m ₽61.8 m ₽
Loans24 m ₽50 m ₽74 m ₽0 ₽74 m ₽
Other liabilities7.01 m ₽17.1 m ₽24.1 m ₽0 ₽24.1 m ₽
Equity75.5 m ₽54.7 m ₽130.2 m ₽−1.86 m ₽128.3 m ₽
Check: assets − liabilities − equity0 ₽0 ₽0 ₽0 ₽0 ₽

Eliminated: turnover 17.3 m ₽, unrealised profit 2.48 m ₽ (30 % of purchases stay in stock at a margin of 47.8 %), the intra-group balance 2.6 m ₽. Consolidated EBITDA 67.4 m ₽ against the sum 69.8 m ₽.

The calculation is simplified: two companies, one intra-group line, no investment in a subsidiary and no goodwill, no intra-group interest or loans. Check the consolidation procedure, tax on unrealised profit and reporting with an accountant or auditor. Amounts excl. VAT, the balance as booked.

Nuances and limits

  • Eliminate the turnover at both the seller and the buyer: otherwise revenue and cost are overstated.
  • Take the remaining internal purchases from the buyer’s stock records at period end and not by estimate.
  • Without eliminating the balance, group receivables and payables are overstated by the same amount: the balance sheet ties but you overstate working capital.

Terms used

Calculate on your data →