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.
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
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Sold within the group | pcs | 7,500 | Units 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,300 | The 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,200 | Full 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 | % | 30 | The 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,000 | The 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 | % | 25 | For tax on unrealized profit (a deferred tax asset). Check the procedure with an accountant. The example value is illustrative. |
How it is calculated
| Step | Formula |
|---|---|
| Turnover | units × internal price: eliminated from the seller’s revenue and the buyer’s cost of sales |
| Unrealised profit | turnover × share in the buyer’s stock × (price − cost) ÷ price |
| Tax on it | unrealised profit × rate: a deferred tax asset |
| P&L | revenue − turnover; EBITDA − unrealised profit; profit − (unrealised − tax) |
| Balance sheet | receivables and payables − the intra-group balance; inventory − unrealised; other assets + tax; equity − (unrealised − tax) |
| Check | assets − 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
| Line | Brand (seller) | Retailer (buyer) | Sum | Eliminations | Consolidated |
|---|---|---|---|---|---|
| Revenue | 206.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 profit | 116.4 m ₽ | 246.4 m ₽ | 362.8 m ₽ | −2.48 m ₽ | 360.4 m ₽ |
| EBITDA | 35 m ₽ | 34.8 m ₽ | 69.8 m ₽ | −2.48 m ₽ | 67.4 m ₽ |
| Net profit | 21.1 m ₽ | 11.7 m ₽ | 32.7 m ₽ | −1.86 m ₽ | 30.9 m ₽ |
| Cash | 14.4 m ₽ | 1.77 m ₽ | 16.1 m ₽ | 0 ₽ | 16.1 m ₽ |
| Receivables | 22.5 m ₽ | 3.41 m ₽ | 25.9 m ₽ | −2.6 m ₽ | 23.3 m ₽ |
| Net inventory | 55.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 assets | 116.3 m ₽ | 176.3 m ₽ | 292.7 m ₽ | −4.45 m ₽ | 288.2 m ₽ |
| Payables | 9.78 m ₽ | 54.6 m ₽ | 64.4 m ₽ | −2.6 m ₽ | 61.8 m ₽ |
| Loans | 24 m ₽ | 50 m ₽ | 74 m ₽ | 0 ₽ | 74 m ₽ |
| Other liabilities | 7.01 m ₽ | 17.1 m ₽ | 24.1 m ₽ | 0 ₽ | 24.1 m ₽ |
| Equity | 75.5 m ₽ | 54.7 m ₽ | 130.2 m ₽ | −1.86 m ₽ | 128.3 m ₽ |
| Check: assets − liabilities − equity | 0 ₽ | 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.