Balance Sheet Disclosures
in million € | Concessions, favourable contracts, industrial property rights and similar rights as well as licenses to such rights | Customer relationships | Goodwill | Prepayments and assets under development | Total |
---|---|---|---|---|---|
Cost | |||||
As at 1 Jan. 2016 | 720.9 | 9.7 | 1,747.5 | 28.8 | 2,506.9 |
Currency translation | -2.9 | 0.0 | 4.5 | 0.0 | 1.6 |
Additions to/disposals from scope of consolidation | 0.0 | 0.0 | -0.6 | 0.0 | -0.6 |
Reclassifications of assets held for sale | -0.3 | 0.0 | 0.0 | 0.0 | -0.3 |
Additions from acquisitions | 11.7 | 0.4 | 186.3 | 0.6 | 199.0 |
Additions | 99.8 | 0.0 | 5.2 | 30.4 | 135.4 |
Disposals | -35.3 | 0.0 | -61.4 | -1.4 | -98.1 |
Reclassifications | 29.6 | 0.0 | 0.0 | -25.8 | 3.8 |
As at 31 Dec. 2016/1 Jan. 2017 | 823.5 | 10.1 | 1,881.5 | 32.6 | 2,747.7 |
Currency translation | -0.9 | 0.1 | 2.2 | 0.0 | 1.4 |
Additions to/disposals from scope of consolidation | 5.5 | 0.0 | -7.6 | 0.0 | -2.1 |
Reclassifications of assets held for sale | 59.3 | 0.0 | 24.5 | 0.0 | 83.8 |
Additions from acquisitions | 33.0 | 54.7 | 70.6 | 0.0 | 158.3 |
Additions | 67.8 | 0.0 | 1.7 | 35.2 | 104.7 |
Disposals | -18.4 | 0.0 | -0.5 | -1.5 | -20.4 |
Reclassifications | 24.6 | 0.0 | 0.0 | -21.7 | 2.9 |
As at 31 Dec. 2017 | 994.4 | 64.9 | 1,972.4 | 44.6 | 3,076.3 |
Depreciation, amortisation and impairments | |||||
As at 1 Jan. 2016 | 419.5 | 2.5 | 461.2 | 0.3 | 883.5 |
Currency translation | -0.1 | 0.0 | 0.0 | 0.0 | -0.1 |
Additions to/disposals from scope of consolidation | 0.0 | 0.0 | -0.6 | 0.0 | -0.6 |
Reclassifications of assets held for sale | -0.1 | 0.0 | 0.0 | 0.0 | -0.1 |
Additions | 71.3 | 0.6 | 0.0 | 0.0 | 71.9 |
Impairments | 39.8 | 0.0 | 137.0 | 0.0 | 176.8 |
Disposals | -11.5 | 0.0 | -59.9 | 0.0 | -71.4 |
Reclassifications | -0.1 | 0.0 | 0.0 | 0.0 | -0.1 |
As at 31 Dec. 2016/1 Jan. 2017 | 518.8 | 3.1 | 537.7 | 0.3 | 1,059.9 |
Currency translation | 0.8 | 0.2 | 0.0 | 0.0 | 1.0 |
Additions to/disposals from scope of consolidation | 0.0 | 0.0 | -7.6 | 0.0 | -7.6 |
Reclassifications of assets held for sale | 59.3 | 0.0 | 24.5 | 0.0 | 83.8 |
Additions | 73.9 | 1.8 | 0.0 | 0.0 | 75.7 |
Disposals | -11.6 | 0.0 | 0.0 | 0.0 | -11.6 |
As at 31 Dec. 2017 | 641.2 | 5.1 | 554.6 | 0.3 | 1,201.2 |
Carrying amount as at 1 Jan. 2016 | 301.4 | 7.2 | 1,286.3 | 28.5 | 1,623.4 |
Carrying amount as at 31 Dec. 2016/1 Jan. 2017 | 304.7 | 7.0 | 1,343.8 | 32.3 | 1,687.8 |
Carrying amount as at 31 Dec. 2017 | 353.2 | 59.8 | 1,417.8 | 44.3 | 1,875.1 |
Favourable contracts were recognised as intangible assets if contracts were taken over in connection with a business combination whose terms and conditions were more favourable than the market conditions at the date of the business combination.
The additions to customer relationships resulted primarily from the first-time consolidation of REWE Dortmund SE & Co. KG, Dortmund, (see also note 4 "Acquisitions" for this and for all other additions from acquisitions).
Internally generated intangible assets in use amounting to 89.7 million euros are presented in the financial year (previous year: 66.4 million euros). In addition, there are internally generated intangible assets still in development. The internally generated intangible assets primarily concern software products. Additional research and development expenses of 70.4 million euros (previous year: 59.1 million euros) were incurred in the financial year. These expenses were not capitalised as internally generated intangible assets because the recognition requirements were not satisfied.
The cumulative cost and/or cumulative depreciation was reclassified if it was attributable to assets that were recognised under other items of non-current assets and that must now be presented in other items.
With regard to the impairment losses during the financial year, please see the remarks under note 13 "Depreciation, Amortisation and Impairments".
As in the previous year, no intangible assets were pledged as collateral for liabilities. In addition, purchase commitments in the amount of 0.3 million euros (previous year: 0.7 million euros) were entered into for intangible assets.
Group of cash-generating units in million € | 31 Dec. 2017 | 31 Dec. 2016* |
---|---|---|
REWE (new business segment structure)* | 677.0 | 615.8 |
Travel and Tourism Central Europe | 344.2 | 348.9 |
PENNY Czech Republic | 198.7 | 187.7 |
Travel and Tourism Northern Europe | 65.0 | 67.1 |
BILLA Czech Republic | 54.9 | 51.9 |
BILLA Russia | 54.1 | 58.4 |
PENNY Italy | 8.8 | 0.0 |
EHA | 7.1 | 7.1 |
Digital | 7.0 | 7.0 |
toom Baumarkt DIY stores | 1.0 | 0.0 |
Total goodwill | 1,417.8 | 1,343.9 |
- * Prior-year amounts adjusted in accordance with the provisions relating to business combinations (IFRS 3).
The National Full-Range Stores and National Discount Stores business segments were combined during the financial year to form the new Retail Germany business segment as part of the project to implement the new management structure. The goodwill formerly allocated to the former CGU National Full-Range Stores was allocated in full to the new REWE group of CGUs according to expected synergy potential and future management. Due to the adjustment in the percentage share in the Supermärkte Nord companies during the financial year, the goodwill allocated to the National Full-Range Stores group of CGUs was increased with retrospective effect from the previous year by 19.3 million euros to 186.3 million euros (see note 4 "Acquisitions").
The significant increase in goodwill for the REWE group of CGUs during the financial year was due primarily to the acquisition of 64 store locations and a logistics facility of the Kaiser's Tengelmann Group and the establishment of the joint venture with REWE DORTMUND Großhandel eG, Dortmund. The acquisition of the stores resulted in goodwill amounting to 60.3 million euros as at the balance sheet date, and the formation of the joint venture resulted in goodwill amounting to 1.6 million euros reflecting the expected synergy potential and advantageous locations for the REWE group of CGUs (see also note 4 "Acquisitions").
At the PENNY Czech Republic CGU group, the advantageous exchange rate changes resulted in an increase in goodwill of 11.0 million euros.
Following the elimination of the goodwill for the PENNY Italy CGU group during the previous year, the acquisition of seven grocery store chains during the financial year resulted in goodwill in the amount of 8.8 million euros (see also note 4 "Acquisitions").
The decline in goodwill amounting to 4.7 million euros at the Travel and Tourism Central Europe group of CGUs was due primarily to a negative exchange rate development for the KUONI Switzerland business unit. At the Travel and Tourism Northern Europe CGU group, too, the negative exchange rate changes resulted in a decrease in goodwill of 2.1 million euros overall.
The advantageous exchange rate development from the previous year for the BILLA Russia group of CGUs reversed during the financial year, resulting in a decrease in goodwill amounting to 4.3 million euros. This was offset by the advantageous exchange rate trend for the BILLA Czech Republic group of CGUs, which resulted in a 3.0 million euro increase.
The addition of goodwill amounting to 1.0 million euros at the toom Baumarkt CGU group resulted from the acquisition of three store locations.
Measurement Model and Material Measurement Parameters
The recoverable amount of the CGU groups is determined based on the fair value less costs to sell using the discounted cash flow method.
The key measurement parameters used to calculate the fair value of CGUs are the capital charges (WACC) used to calculate the discount rate, the growth discount in the discount rate used for calculating the perpetual annuity and the change in EBIT in the planning period as the basis for forecasting the cash flows of the CGUs.
The measurement of the fair value of the CGU groups is based on the forecasted cash flows, which are derived on the basis of the three-year plan approved by the management. This three-year plan was prepared on the basis of internal Company experience and expectations regarding future market development and is used for internal purposes. Country-specific parameters, such as economic growth, consumer prices, private consumption and the unemployment rate, are considered in the three-year plan. The last planning year in the three-year plan is generally used as a basis for the perpetual annuity in the measurement model.
A growth discount is factored into the discount rate for the perpetual annuity in the measurement model. Growth rates forecast by international organisations for gross domestic product up to 2022 were used when determining the country-specific growth discounts. The discount rates used reflect the special risks of the corresponding CGU groups. Capital charges (WACC) are determined based on fair values. The specific beta coefficients were derived from capital market data for several comparable companies.
Group of cash-generating units | Discount rate per year (WACC) | Growth discount | ||||
---|---|---|---|---|---|---|
2017 | 2016 | 2016* | 2017 | 2016 | ||
REWE | 4.8% | 4.5% | 6.5% | 0.5% | 0.5% | |
Travel and Tourism Central Europe | 5.8% | – | 5.7% - 7.6% | 0.5% | 0% - 0.5% | |
PENNY Czech Republic | 5.5% | 5.0% | 6.0% | 0.8% | 0.8% | |
Travel and Tourism Northern Europe | 6.4% | – | 6.8% - 8.8% | 0.8% | 0.5% - 1.0% | |
BILLA Russia | 11.5% | 12.3% | 14.5% | 2.5% | 2.5% | |
BILLA Czech Republic | 5.5% | 5.0% | 6.0% | 0.8% | 0.8% | |
EHA | 4.8% | 4.5% | 6.2% | 0.5% | 0.5% | |
Digital | 4.8% | 4.5% | 6.0% | 0.5% | 0.5% | |
PENNY Italy | – | 6.0% | 8.1% | – | 0.5% | |
toom Baumarkt DIY stores | – | 4.5% | 6.9% | – | 0.5% |
- *Discount rate per year before taxes
Impairment tests were conducted in euros for the Travel and Tourism Central Europe and Travel and Tourism Northern Europe groups of CGUs and average discount and growth rates were used; the average of the country-specific parameters was calculated based on revenue ratios. In the previous year, measurement models with country-specific parameters were added up for these CGU groups.
The three-year plans for internal management purposes are used for the forecast of future cash flows of the CGU groups. The detailed planning period was expanded for some CGU groups. This is done if the most recent budget year does not reflect long term results as a basis for the perpetual annuity. This is primarily due to restructuring and expansion plans in the CGU groups.
The following assumptions were made in the detailed planning period with respect to the future development of EBIT and revenue for the individual CGU groups:
Group of cash-generating units | Forecast development EBIT/Revenue | Detailed planning period | ||
---|---|---|---|---|
EBIT | Revenue | 2017 | 2016 | |
REWE | strong growth | slight growth | 10 years | 10 Jahre |
Travel and Tourism Central Europe | strong growth | slight growth | 3 years | 3 years |
PENNY Czech Republic | slight growth | slight growth | 3 years | 3 years |
Travel and Tourism Northern Europe | solid growth | slight growth | 3 years | 3 years |
BILLA Russia | strong growth | strong growth | 3 years | 3 years |
BILLA Czech Republic | solid growth | solid growth | 3 years | 3 years |
EHA | slight growth | slight growth | 3 years | 3 years |
Digital | strong growth | strong growth | 10 years | 10 years |
PENNY Italy | – | – | – | 3 years |
toom Baumarkt DIY stores | – | – | – | 10 years |
Sensitivity of Material Measurement Parameters
As part of sensitivity analyses, the potential effects from changes in the weighted cost of capital (WACC), country-specific growth discounts or in the EBIT for the last planning year are analysed, as are combinations of these significant measurement parameters to future cash flows.
At the following CGU groups, the sensitivity analyses showed the potential impairments of goodwill in the event of changes in parameters presented in the table below:
WACC | Impairments | |
---|---|---|
Group of cash-generating units | Increase in percentage points | in million € |
REWE | 1.0 | 550.9 |
PENNY Czech Republic | 1.0 | 0.0 |
EBIT perpetual annuity | Impairments | |
---|---|---|
Group of cash-generating units | Decrease in percentage points | in million € |
REWE | 10.0 | 0.0 |
PENNY Czech Republic | 10.0 | 0.0 |
Growth discount | Impairments | |
---|---|---|
Group of cash-generating units | Decrease in percentage points | in million € |
REWE | 0.5 | 0.0 |
PENNY Czech Republic | 0.5 | 0.0 |
WACC | Growth discount | Impairments | |
---|---|---|---|
Group of cash-generating units | Increase in percentage points | Decrease in percentage points | in million € |
REWE | 1.0 | 0.5 | 866.6 |
PENNY Czech Republic | 1.0 | 0.5 | 10.3 |
WACC | EBIT perpetual annuity | Impairments | |
---|---|---|---|
Group of cash-generating units | Increase in percentage points | Decrease in percentage points | in million € |
REWE | 1.0 | 10.0 | 907.8 |
PENNY Czech Republic | 1.0 | 10.0 | 15.0 |
EBIT perpetual annuity | Growth discount | Impairments | |
---|---|---|---|
Group of cash-generating units | Decrease in percentage points | Decrease in percentage points | in million € |
REWE | 10.0 | 0.5 | 276.0 |
PENNY Czech Republic | 10.0 | 0.5 | 0.0 |
No realistic changes in parameters are expected for any of the CGU groups which would result in an impairment.