DNO actuals v Ofgem Allocation.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Parent
Electricity North West
Northern PowerGrid
Western Power
UKPN
Scottish Power
SSE
2
License Area ENWLNPgNNPgYCombinedWMIDEMIDSWALESSWESTCombinedLPNSPNEPNCombinedSPDSPMWCombinedSSEHSSESCombined
3
2016
4
OFGEM PREDICTED
2016 Revenue (£m 12/13 prices) (row 36)
372249.1324.9574387.3390199.2286.71263.2366.5321.2497.81185.5339.2303.7642.9245.8470.5716.3
5
2016 Tax (user interface = 31 Mar 2017 selected)
20.916.923.840.712.311.26.710.340.51813.72960.710.24.214.48.926.135
6
2016 Dividends (finance and tax worksheet, row 155: 'notional dividends'
29.522.129.251.35150.722.232.3156.227.728.244.4100.329.430.359.718.438.957.3
7
8
2016 Revenue with RPI402.50269.53351.54621.07419.06421.98215.53310.211,366.78396.55347.54538.621,282.71367.01328.60695.62265.96509.08775.04
9
2016 Tax with RPI22.6118.2925.7544.0413.3112.127.2511.1443.8219.4814.8231.3865.6811.044.5415.589.6328.2437.87
10
2016 Dividends with RPI31.9223.9131.5955.5155.1854.8624.0234.95169.0129.9730.5148.04108.5231.8132.7864.6019.9142.0962.00
11
12
DNO REPORTED
2016 Revenue485.5776.31480.61633.52397.2397.7794.9332.3623.8956.1
13
2016 Tax4.524.3947.691.610.815.626.46.319.525.8
14
2016 Dividends301000145.6654511050200250
15
16
Pound Differences
2016 Tax-18.11-18.29-25.75-19.65-13.31-12.12-7.25-11.143.78-19.48-14.82-31.3825.92-0.2411.0610.82-3.33-8.74-12.07
17
2016 Dividends-1.92-23.91-31.5944.49-55.18-54.86-24.02-34.95-169.01-29.97-30.51-48.0437.0833.1912.2245.4030.09157.91188.00
18
% differences2016 Tax 19.900.000.0055.380.000.000.000.00108.620.000.000.00139.4797.86343.28169.4465.4269.0568.13
19
2016 Dividends93.990.000.00180.160.000.000.000.000.000.000.000.00134.16204.33137.26170.29251.15475.17403.23
20
21
2017
22
OFGEM PREDICTED
2017 Revenue377.7246.5321.9568.4397.3400.7203290.31291.3386.1323.6507.21216.9345.4308.3653.7255.8469.1724.9
23
2017 Tax24.516.122.93910.911.65.97.936.321.712.729.263.69.11.610.710.72535.7
24
2017 Dividends30.523.230.653.853.353.423.734.7165.12929.946.2105.130.732.463.119.140.559.6
25
26
2017 Revenue with RPI410.56267.95349.91617.85431.87435.56220.66315.561,403.64419.69351.75551.331,322.77375.45335.12710.57278.05509.91787.97
27
2017 Tax with RPI26.6317.5024.8942.3911.8512.616.418.5939.4623.5913.8031.7469.139.891.7411.6311.6327.1838.81
28
2017 Dividends with RPI33.1525.2233.2658.4857.9458.0525.7637.72179.4631.5232.5050.22114.2433.3735.2268.5920.7644.0264.79
29
30
DNO REPORTED
2017 Revenue450.8768.41664.61702.3404359.5763.5382.5690.11072.6
31
2017 Tax105.847109.295.320.115.93613.334.647.9
32
2017 Dividends810313.821769269550100150
33
34
Pound Differences
2017 Tax-16.63-17.50-24.89-36.55-11.85-12.61-6.41-8.5969.74-23.59-13.80-31.7426.1710.2114.1624.371.677.439.09
35
2017 Dividends47.85-25.22-33.26-58.48-57.94-58.05-25.76-37.72134.34-31.52-32.50-50.22102.7635.63-9.2226.4129.2455.9885.21
36
% differences2017 Tax40.820.000.0014.990.000.000.000.00300.830.000.000.00149.84220.88993.75336.45124.30138.40134.17
37
2017 Dividends265.570.000.000.000.000.000.000.00190.070.000.000.00206.47224.7680.25150.55261.78246.91251.68
38
39
Combined
40
Combined £ Differences
Tax-34.75-35.79-50.64-56.19-25.16-24.73-13.66-19.7373.52-43.06-28.63-63.1252.099.9725.2235.19-1.66-1.32-2.98
41
Dividends45.93-49.13-64.86-13.99-113.12-112.90-49.78-72.67-34.67-61.49-63.01-98.26139.8368.823.0071.8159.33213.89273.22
42
Combined % differences
Tax31.940.000.0037.940.000.000.000.00204.170.000.000.00150.36160.10543.10248.61100.00105.87104.24
43
Dividends185.000.000.0095.150.000.000.000.0097.670.000.000.00176.53222.96113.24166.94266.67377.83342.17
44
45
Note
Uses a calendar financial reporting period
Due to an extended 15-month reporting period, the 2016 UKPN figures have been adjusted to reflect a 'normal' year
Uses a calendar financial reporting period
46
47
Notes2016 RPI multiplier = 1.082
48
2017 RPI multiplier = 1.087
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Predicted v Actuals
 
 
Main menu