XML 473 R46.htm IDEA: XBRL DOCUMENT v3.23.2
Impairment losses (Tables)
12 Months Ended
Mar. 31, 2023
Impairment losses  
Schedule of carrying value of goodwill

2023

2022

€m

€m

Germany

 

20,335

 

20,335

Italy

 

2,481

 

2,481

Vantage Towers Germany

2,565

Other

 

4,799

 

6,503

 

27,615

 

31,884

Schedule of key assumptions used in the value in use calculations

Key assumptions used in the value in use calculations

The key assumptions used in determining the value in use are:

Assumption

    

How determined

Projected adjusted EBITDAaL

Projected adjusted EBITDAaL has been based on past experience adjusted for the following:

 In Europe, mobile revenue is expected to benefit from increased usage as customers transition to higher data bundles, and new products and services are introduced. Fixed revenue is expected to continue to grow as penetration is increased and more products and services are sold to customers;

 Outside of Europe, revenue is expected to continue to grow as the penetration of faster data-enabled devices rises along with higher data bundle attachment rates, and new products and services are introduced; and

 Margins are expected to be impacted by negative factors such as the cost of acquiring and retaining customers in increasingly competitive markets and by positive factors such as the efficiencies expected from the implementation of Group initiatives.

Projected capital expenditure

The cash flow forecasts for capital expenditure are based on past experience and include the ongoing capital expenditure required to maintain our networks, provide products and services in line with customer expectations, including of higher data volumes and speeds, and to meet the population coverage requirements of certain of the Group’s licences. In Europe, capital expenditure is required to roll out capacity-building next generation 5G and gigabit networks. Outside of Europe, capital expenditure will be required for the continued rollout of current and next generation mobile networks in emerging markets. Capital expenditure includes cash outflows for the purchase of owned property, plant and equipment and computer software.

Projected licence and spectrum payments

To enable the continued provision of products and services, the cash flow forecasts for licence and spectrum payments for each relevant cash-generating unit include amounts for expected renewals and newly available spectrum. Beyond the five year forecast period, a long-run cost of spectrum is assumed.

Long-term growth rate

For the purposes of the Group’s value in use calculations, a longterm growth rate into perpetuity is applied immediately at the end of the five year forecast period and is based on the lower of:

 the nominal GDP growth rate forecasts for the country of operation; and

 the long-term compound annual growth rate in adjusted EBITDAaL as estimated by management.

Long-term compound annual growth rates determined by management may be lower than forecast nominal GDP growth rates due to the following market-specific factors: competitive intensity levels, maturity of business, regulatory environment or sector-specific inflation expectations.

Pre-tax discount rate

The pre-tax discount rate for each cash-generating unit is derived such that when applied to pre-tax cash flows it gives the same result as when the observable post-tax weighted average cost of capital is applied to post-tax cash flows.

The assumptions used to develop discount rates for each cash-generating unit are benchmarked to externally available data.

– The risk free rate is derived from an average yield of a ten year bond issued by the government in each cash-generating unit’s respective country of operations.

– The forward-looking equity market risk premium (an investor’s required rate return over and above a risk free rate) is based on studies by independent economists, the long-term average equity market risk premium and the market risk premiums typically used by valuation practitioners.

– The asset beta reflecting the systematic risk of the telecommunications segment relative to the market as a whole is determined from betas observed for comparable listed telecommunications companies.

– The region-specific leverage ratios are estimated from ratios observed for comparable listed telecommunications companies.

Each cash-generating unit’s discount rate is determined in nominal terms in order to match their nominal estimates of future cash flows.

Rising risk free interest rates and lower asset betas have, respectively, increased and decreased the cash-generating unit discount rates in the current year.

Schedule of assumptions used in valuation of impairment loss

Assumptions used in value in use calculations

    

Germany

    

Italy

%

  

%

Pre-tax discount rate

7.8

 

8.9

Long-term growth rate

0.6

 

1.5

Projected adjusted EBITDAaL CAGR1

1.8

 

1.0

Projected capital expenditure2

19.4-19.8

 

16.5-17.9

    

Change required for carrying value to equal recoverable amount

    

Germany

    

Italy

    

UK

    

Spain

pps

pps

pps

pps

Pre-tax discount rate

0.6

 

0.2

 

1.6

 

0.5

Long-term growth rate

(0.6)

 

(0.2)

 

(1.9)

 

(0.6)

Projected adjusted EBITDAaL CAGR1

(1.8)

 

(0.5)

 

(4.1)

 

(1.5)

Projected capital expenditure2

5.5

 

0.9

 

4.2

 

2.2

Notes:

1

Projected adjusted EBITDAaL CAGR is expressed as the compound annual growth rates in the initial five years for all cash-generating units of the plans used for impairment testing.

2

Projected capital expenditure, which excludes licences and spectrum, is expressed as capital expenditure as a percentage of revenue in the initial five years for all cash-generating units of the plans used for impairment testing.

Recoverable amount less carrying value

Italy

Spain

    

€bn

    

€bn

Base case as at 31 March 2023

0.2

0.4

Change in pre-tax discount rate

Decrease by 1pps

1.4

1.3

Increase by 1pps

(0.8)

(0.3)

Change in projected adjusted EBITDAaL CAGR1

Decrease by 5pps

(1.6)

(0.8)

Increase by 5pps

2.3

1.8

Note:

1

Projected adjusted EBITDAaL CAGR is expressed as the compound annual growth rates in the initial five years for all cash-generating units of the plans used for impairment testing.

Assumptions used in value in use calculations

Vantage Towers

Germany

Italy

 Germany

Other

%

%

%

%

Pre-tax discount rate

    

7.4

    

9.3

    

6.1

    

6.2-22.5

Long-term growth rate

 

0.5

 

1.5

 

1.5

 

1.0-8.9

Projected adjusted EBITDAaL CAGR1

 

(0.1)

 

(0.2)

 

11.0

 

(5.4)-13.0

Projected capital expenditure2

 

19.6-21.8

 

15.0-16.3

 

32.0-62.1

 

10.0-51.4

Notes:

1Projected adjusted EBITDAaL CAGR is expressed as the compound annual growth rates in the initial five years for all cash-generating units of the plans used for impairment testing. For the purposes of this disclosure, Italy’s adjusted EBITDAaL for the year ended 31 March 2022 excludes the TIM settlement.
2Projected capital expenditure, which excludes licences and spectrum, is expressed as capital expenditure as a percentage of revenue in the initial five years for all cash-generating units of the plans used for impairment testing.

Change required for carrying value to equal recoverable amount

Germany

Italy

UK

Spain

    

pps

    

pps

    

pps

    

pps

Pre-tax discount rate

1.4

    

0.3

    

1.3

    

0.1

Long-term growth rate

(1.4)

 

(0.3)

(1.5)

(0.1)

Projected adjusted EBITDAaL CAGR1

(4.1)

 

(0.9)

(3.1)

(0.4)

Projected capital expenditure2

12.6

 

1.8

4.3

0.5

Recoverable amount less carrying value

Germany

Italy

UK

Spain

    

€bn

    

€bn

    

€bn

    

€bn

Base case as at 31 March 2022

 

7.3

 

0.4

 

1.3

 

0.1

Change in pre-tax discount rate

 

  

 

  

 

  

 

  

Decrease by 1pps

 

14.9

 

1.7

 

2.8

 

1.0

Increase by 1pps

 

1.7

 

(0.7)

 

0.3

 

(0.6)

Change in long-term growth rate

Decrease by 1pps

1.6

(0.6)

0.4

(0.5)

Increase by 1pps

15.6

1.7

2.8

0.9

Change in projected adjusted EBITDAaL CAGR1

 

  

 

  

 

  

 

  

Decrease by 5pps

 

(1.4)

 

(1.6)

 

(0.7)

 

(1.1)

Increase by 5pps

 

17.9

 

2.8

 

3.8

 

1.5

Notes:

1

Projected adjusted EBITDAaL CAGR is expressed as the compound annual growth rates in the initial five years for all cash-generating units of the plans used for impairment testing. For the purposes of this disclosure, Italy’s adjusted EBITDAaL for the year ended 31 March 2022 excludes the TIM settlement.

2

Projected capital expenditure, which excludes licences and spectrum, is expressed as capital expenditure as a percentage of revenue in the initial five years for all cash-generating units of the plans used for impairment testing.

Assumptions used in value in use calculation

    

    

    

    

    

    

Vantage Towers

Germany

Italy

Spain

Ireland

Romania

Germany

%

  

%

  

%

  

%

  

%

  

%

Pre-tax discount rate

 

7.4

10.5

9.2

7.7

9.9

6.0

Long-term growth rate

 

0.5

0.5

0.5

0.5

1.0

1.5

Projected adjusted EBITDAaL CAGR1

 

1.2

2.1

4.9

0.5

0.9

8.4

Projected capital expenditure2

 

19.7-21.5

14.4-15.9

15.7-17.6

12.6-15.1

12.3-15.2

39.1-56.2

Notes:

1

Projected adjusted EBITDAaL CAGR is expressed as the compound annual growth rates in the initial five years for all cash-generating units of the plans used for impairment testing. A pro-rata adjustment has been made to true-up 31 March 2021 adjusted EBITDAaL to a full year where the towers business carve-out occurred during the year.

2

Projected capital expenditure, which excludes licences and spectrum, is expressed as capital expenditure as a percentage of revenue in the initial five years for all cash-generating units of the plans used for impairment testing.

Change required for carrying value to equal recoverable amount

    

Vantage Towers

Germany

Italy

Spain

Ireland

Romania

Germany

pps

pps

pps

pps

pps

pps

Pre-tax discount rate

 

1.3

 

0.7

0.4

0.7

0.7

5.2

Long-term growth rate

 

(1.3)

 

(0.8)

(0.5)

(0.7)

(0.9)

(4.9)

Projected adjusted EBITDAaL CAGR1

 

(4.0)

 

(1.5)

(1.5)

(1.6)

(1.9)

(19.3)

Projected capital expenditure2

 

12.7

 

3.0

1.6

2.8

1.9

162.6

Recoverable amount less carrying value

Vantage Towers

Germany

Italy

Spain

Ireland

Romania

Germany

    

€bn

    

€bn

    

€bn

    

€bn

    

€bn

€bn

Base case as at 31 March 2021

 

7.4

 

0.6

 

0.3

 

0.1

 

0.1

3.5

Change in projected adjusted EBITDAaL CAGR1

 

  

 

  

 

  

 

  

 

  

Decrease by 5pps

 

(1.6)

 

(1.3)

 

(0.6)

 

(0.2)

 

(0.1)

2.4

Increase by 5pps

 

18.2

 

2.9

 

1.4

 

0.5

 

0.3

5.0

Change in long-term growth rate

 

  

 

  

 

  

 

  

 

  

  

Decrease by 1pps

 

1.5

 

(0.1)

 

(0.3)

 

 

2.2

Increase by 1pps

 

16.0

 

1.6

 

1.0

 

0.3

 

0.2

6.1

Change required for carrying value to equal recoverable amount

    

UK

    

Portugal

    

Czech Republic

    

Hungary

pps

pps

pps

pps

Pre-tax discount rate

 

0.8

 

0.9

 

1.2

 

0.3

Long-term growth rate

 

(0.8)

 

(1.0)

 

(1.3)

 

(0.4)

Projected adjusted EBITDAaL CAGR1

 

(1.7)

 

(2.2)

 

(3.0)

 

(0.7)

Projected capital expenditure2

 

2.5

 

3.7

 

7.5

 

1.5

Notes:

1Projected adjusted EBITDAaL CAGR is expressed as the compound annual growth rates in the initial five years for all cash-generating units of the plans used for impairment testing. A pro-rata adjustment has been made to true up 31 March 2021 adjusted EBITDAaL to a full year where the towers business carve-out occurred during the year.
2Projected capital expenditure, which excludes licences and spectrum, is expressed as capital expenditure as a percentage of revenue in the initial five years for all cash-generating units of the plans used for impairment testing.