Accounting Depreciation
	Opening accounting net book value			0.00	8,112.00	7,316.25	6,450.04	5,504.78	4,478.07	12,322.87	9,633.33	6,854.81	3,984.64	1,020.06	8,339.98	3,447.73	0.00	0.00
	One-off capex	$m		8,840.00	0.00	0.00	0.00	0.00	10,447.94	0.00	0.00	0.00	0.00	12,112.02	0.00	0.00	0.00	0.00
	Regular capex	$m		624.00	648.96	674.92	695.17	716.02	737.50	759.63	782.42	805.89	830.06	854.97	880.62	907.03	934.24	962.27
	Capital expenditure incurred (nominal)	$m		9,464.00	648.96	674.92	695.17	716.02	11,185.44	759.63	782.42	805.89	830.06	12,966.99	880.62	907.03	934.24	962.27
	PP&E - accounting (straight line)	years	7.00
	Capital expenditure assumed to be made on the first day of the period.
	Year
	1			1,352.00	1,352.00	1,352.00	1,352.00	1,352.00	1,352.00	1,352.00	1,352.00	1,352.00	1,352.00	1,352.00	1,352.00	1,352.00	1,352.00	1,352.00
	2			0.00	92.71	92.71	92.71	92.71	92.71	92.71	92.71	92.71	92.71	92.71	92.71	92.71	92.71	92.71
	3			0.00	0.00	96.42	96.42	96.42	96.42	96.42	96.42	96.42	96.42	96.42	96.42	96.42	96.42	96.42
	4			0.00	0.00	0.00	99.31	99.31	99.31	99.31	99.31	99.31	99.31	99.31	99.31	99.31	99.31	99.31
	5			0.00	0.00	0.00	0.00	102.29	102.29	102.29	102.29	102.29	102.29	102.29	102.29	102.29	102.29	102.29
	6			0.00	0.00	0.00	0.00	0.00	1,597.92	1,597.92	1,597.92	1,597.92	1,597.92	1,597.92	1,597.92	1,597.92	1,597.92	1,597.92
	7			0.00	0.00	0.00	0.00	0.00	0.00	108.52	108.52	108.52	108.52	108.52	108.52	108.52	108.52	108.52
	8			0.00	0.00	0.00	0.00	0.00	0.00	0.00	111.77	111.77	111.77	111.77	111.77	111.77	111.77	111.77
	9			0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	115.13	115.13	115.13	115.13	115.13	115.13	115.13
	10			0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	118.58	118.58	118.58	118.58	118.58	118.58
	11			0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	1,852.43	1,852.43	1,852.43	1,852.43	1,852.43
	12			0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	125.80	125.80	125.80	125.80
	13			0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	129.58	129.58	129.58
	14			0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	133.46	133.46
	15			0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	137.47
	Accounting depreciation			1,352.00	1,444.71	1,541.13	1,640.43	1,742.72	3,340.64	3,449.16	3,560.94	3,676.06	3,794.64	5,647.07	5,772.87	4,354.76	934.24	962.27
	Closing accounting net book value		0.00	8,112.00	7,316.25	6,450.04	5,504.78	4,478.07	12,322.87	9,633.33	6,854.81	3,984.64	1,020.06	8,339.98	3,447.73	0.00	0.00	0.00
Taxation Depreciation
	Opening tax net book value			0.00	8,112.00	7,316.25	6,450.04	5,504.78	4,478.07	12,322.87	9,633.33	6,854.81	3,984.64	1,020.06	8,339.98	3,447.73	0.00	0.00
	Capital expenditure incurred			9,464.00	648.96	674.92	695.17	716.02	11,185.44	759.63	782.42	805.89	830.06	12,966.99	880.62	907.03	934.24	962.27
	Tax depreciation			1,892.80	1,752.19	1,598.23	1,429.04	1,244.16	3,132.70	2,616.50	2,083.15	1,532.14	962.94	2,797.41	1,844.12	870.95	186.85	192.45
	Closing tax net book value		0.00	7,571.20	7,008.77	6,392.94	5,716.17	4,976.64	12,530.81	10,466.00	8,332.60	6,128.56	3,851.76	11,189.64	7,376.48	3,483.81	747.40	769.82

Question 5

Analyst comment: Our accounting specialist thinks our year 15 closing net book value (from an accounting perspective) is understated [Error(s) in Calculations!91:120]

What is the closing accounting net book value ($m) in the Year ending June 2030?

1. 6,211.04

2. 6,211.14

3. 6,211.27

4. 6,211.39

5. 6,211.57

6. 6,211.62

PP&E Accounting Depreciation Opening accounting net book value 0.00 8,112.00 7,316.25 6,450.04 5,504.78 4,478.07 12,322.87 9,633.33 6,854.81 3,984.64 1.020.06 8,339.98 3,447.73 0.00 0.00 One-off capex Regular capex Capital expenditure incurred (nominal) 8.840.00 624.00 9,464.00 $m 0.00 648.96 648.96 0.00 674.92 674.92 0.00 695.17 695.17 0.00 716.02 716.02 10,447.94 737.50 11,185.44 0.00 759.63 759.63 0.00 782.42 782.42 0.00 805.89 805.89 0.00 830.06 830.06 12, 112.02 854.97 12,966.99 0.00 880.62 880.62 0.00 907.03 907.03 0.00 934.24 934.24 0.00 962.27 962.27 PP&E - accounting (straight line) years 7.00 Capital expenditure assumed to be made on the first day of the period. Year 1,352.00 1,352.00 92.71 0.00 0.00 0.00 0.00 0.00 1,352.00 92.71 96.42 0.00 ooooooooooo 1,352.00 92.71 96.42 99.31 102.29 0.00 0.00 8 8 8 8 1.352.00 92.71 96.42 99.31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.640.43 OOOOOooooo 1,352.00 92.71 96.42 99.31 102.29 1,597.92 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3,340.64 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3,449.16 1.352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3,560.94 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 0.00 0.00 0.00 0.00 0.00 0.00 3,676.06 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 118.58 0.00 0.00 0.00 0.00 0.00 3.794.64 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 118.58 1,852.43 0.00 0.00 0.00 0.00 5,647.07 1.352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 118.58 1,852.43 125.80 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 118.58 1,852.43 125.80 129.58 0.00 0.00 4,354.76 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 118.58 1,852.43 125.80 129.58 133.46 0.00 934.24 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 118.58 1,852.43 125.80 129.58 133.46 137.47 962.27 8 8 8 0.00 0.00 0.00 0.00 0.00 0.00 1,444.71 0.00 0.00 0.00 1,352.00 0.00 0.00 0.00 0.00 1,742.72 15 Accounting depreciation 0.00 1,541.13 0.00 0.00 5,772.87 Closing accounting net book value 0.00 8,112.00 7.316.25 6.450.04 5,504.78 4.478.07 1 2,322.87 9 ,633.33 6,854.81 3.984.64 1,020.06 8,339.98 3.447. 73 0 .00 0.00 0.00 PP&E Accounting Depreciation Opening accounting net book value 0.00 8,112.00 7,316.25 6,450.04 5,504.78 4,478.07 12,322.87 9,633.33 6,854.81 3,984.64 1.020.06 8,339.98 3,447.73 0.00 0.00 One-off capex Regular capex Capital expenditure incurred (nominal) 8.840.00 624.00 9,464.00 $m 0.00 648.96 648.96 0.00 674.92 674.92 0.00 695.17 695.17 0.00 716.02 716.02 10,447.94 737.50 11,185.44 0.00 759.63 759.63 0.00 782.42 782.42 0.00 805.89 805.89 0.00 830.06 830.06 12, 112.02 854.97 12,966.99 0.00 880.62 880.62 0.00 907.03 907.03 0.00 934.24 934.24 0.00 962.27 962.27 PP&E - accounting (straight line) years 7.00 Capital expenditure assumed to be made on the first day of the period. Year 1,352.00 1,352.00 92.71 0.00 0.00 0.00 0.00 0.00 1,352.00 92.71 96.42 0.00 ooooooooooo 1,352.00 92.71 96.42 99.31 102.29 0.00 0.00 8 8 8 8 1.352.00 92.71 96.42 99.31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.640.43 OOOOOooooo 1,352.00 92.71 96.42 99.31 102.29 1,597.92 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3,340.64 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3,449.16 1.352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3,560.94 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 0.00 0.00 0.00 0.00 0.00 0.00 3,676.06 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 118.58 0.00 0.00 0.00 0.00 0.00 3.794.64 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 118.58 1,852.43 0.00 0.00 0.00 0.00 5,647.07 1.352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 118.58 1,852.43 125.80 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 118.58 1,852.43 125.80 129.58 0.00 0.00 4,354.76 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 118.58 1,852.43 125.80 129.58 133.46 0.00 934.24 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 118.58 1,852.43 125.80 129.58 133.46 137.47 962.27 8 8 8 0.00 0.00 0.00 0.00 0.00 0.00 1,444.71 0.00 0.00 0.00 1,352.00 0.00 0.00 0.00 0.00 1,742.72 15 Accounting depreciation 0.00 1,541.13 0.00 0.00 5,772.87 Closing accounting net book value 0.00 8,112.00 7.316.25 6.450.04 5,504.78 4.478.07 1 2,322.87 9 ,633.33 6,854.81 3.984.64 1,020.06 8,339.98 3.447. 73 0 .00 0.00 0.00