{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Front Sheet","RIIO-2 Summary","EE MOD0186 RIIO-GD1","LO MOD0186 RIIO-GD1","NW MOD0186 RIIO-GD1","WM MOD0186 RIIO-GD1","EE MOD0186 RIIO2","LO MOD0186 RIIO2","NW MOD0186 RIIO2","WM MOD0186 RIIO2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Front Sheet","index":0,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[[2,3,2,13]]}
[]
[]
[null,null,null,"There remains significant uncertainty over the revenue forecast pending Final Determinations and RIIO-1 Close out. \n\nWe would expect to see a change from Ofgem by Final Determination so advise Shippers to use caution when assessing pricing for RIIO-2 based on the Draft Determination outputs from our MOD186 report.\n\n"]

{"sheet":"RIIO-2 Summary","index":1,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,3,16,6],[15,3,15,6]]}
[]
[]
[null,null,null,"All in £m Nominal Prices for all networks unless stated"]
[null,null,null,null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
[]
[null,null,null,"June-20 Mod0186 Allowed Revenue",1974,2036,1979,1992,2011]
[]
[null,null,null,"Ofgem’s Draft Determination Cost of Capital assumptions (Note A) ",-31.547224773669011,-40.442052093675962,-48.607024131774835,-56.018793622023914,-62.821166484913618]
[]
[null,null,null,"Change in Inflation forecast (Note B) & other items including RIIO-1 performance outturn",-18.385054500715796,-0.81812344600257347,12.788031660891647,15.052349769042848,17.697019684980205]
[]
[null,null,null,"Sept-20 Mod0186 Allowed Revenue",1924.0677207256151,1994.7398244603214,1943.1810075291169,1951.033556147019,1965.8758532000666]
[null,null,null,"Delta (June to September)",-49.932279274384882,-41.260175539678585,-35.818992470883131,-40.966443852981001,-45.124146799933442]
[]
[]
[null,null,"Note A:","https://www.ofgem.gov.uk/system/files/docs/2020/07/draft_determinations_-_cadent_annex_0.pdf"]
[null,null,"Note B:","https://www.gov.uk/government/statistics/forecasts-for-the-uk-economy-august-2020"]

{"sheet":"EE MOD0186 RIIO-GD1","index":2,"n_rows":124,"n_cols":34,"rows_kept":124,"cut":false,"hidden":false,"merged":[[52,3,52,4],[75,3,75,4],[63,3,63,4],[64,3,64,4],[66,3,66,4],[68,3,68,4],[70,3,70,4],[72,3,72,4],[74,3,74,4],[69,3,69,4],[53,3,53,4],[55,3,55,4],[61,3,61,4],[67,3,67,4],[82,3,82,4],[84,3,84,4],[76,3,76,4],[78,3,78,4],[80,3,80,4],[79,3,79,4],[81,3,81,4],[0,24,0,31],[4,3,4,4],[0,3,0,4],[0,6,0,13],[0,15,0,22],[42,3,42,4],[44,3,44,4],[46,3,46,4],[48,3,48,4],[51,3,51,4],[43,3,43,4],[45,3,45,4],[50,3,50,4],[121,3,121,4],[123,3,123,4],[96,3,96,4],[101,3,101,4],[103,3,103,4],[116,3,116,4],[118,3,118,4],[119,3,119,4]]}
[null,null,null,"CADENT GAS LTD\nEAST OF ENGLAND DISTRIBUTION NETWORK",null,null,"CURRENT (SEPT-2020)",null,null,null,null,null,null,null,null,"PREVIOUS (JUN 2020)",null,null,null,null,null,null,null,null,"MOVEMENT"]
[]
[null,null,null,"DESCRIPTION","LICENCE \nTERM",null,"2013/14","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21",null,"2013/14","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21",null,"2013/14","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21"]
[]
[null,"ROW REF",null,"TABLE 1: TOTAL CHARGE ELEMENTS (LDZ + CUSTOMER + ECN)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTES (RIIO GD-1)"]
[]
[null,1,null,"FORECAST RPI FACTOR","RPIFt",null,1.1630163330372321,1.2050838144310987,1.2266528212575318,1.2327332873088215,1.270922538158505,1.314024254388422,1.358590304925267,1.3798395491512827,null,1.1630163330372321,1.2050838144310987,1.2266528212575318,1.2327332873088215,1.270922538158505,1.314024254388422,1.358590304925267,1.3798395491512827,null,0,0,0,0,0,0,0,0,null,"BASED ON AUG-2020 HMT 'FORECASTS FOR THE UK ECONOMY'. "]
[null,2,null,"ASSUMED ANNUAL INFLATION FOR PRICE SETTING","GRPIFt",null,2.6500000000000003E-2,3.075E-2,2.6000000000000002E-2,2.325E-2,3.4000000000000002E-2,3.3250000000000002E-2,3.175E-2,2.4750000000000001E-2,null,2.6500000000000003E-2,3.075E-2,2.6000000000000002E-2,2.325E-2,3.4000000000000002E-2,3.3250000000000002E-2,3.175E-2,2.4750000000000001E-2,null,0,0,0,0,0,0,0,0,null,"BASED ON AUG-2020 HMT 'FORECASTS FOR THE UK ECONOMY'. "]
[null,3,null,"ACTUAL / FORECAST ANNUAL INFLATION",null,null,2.8847791287762714E-2,1.9597457627118731E-2,1.0779220779220777E-2,2.1424900424001248E-2,3.7422560457875953E-2,3.0555639758707454E-2,2.5884636879724532E-2,1.4551366229893725E-2,null,2.8847791287762714E-2,1.9597457627118731E-2,1.0779220779220777E-2,2.1424900424001248E-2,3.7422560457875953E-2,3.0555639758707454E-2,2.5884636879724532E-2,1.6856811078934664E-2,null,0,0,0,0,0,0,0,-2.3054448490409385E-3,null,"BASED ON RPI DATA UP TO JULY 2020"]
[null,4,null,"DIFFERENCE (DRIVES t+2 RPI TRUE UP)",null,null,2.3477912877627113E-3,-1.1152542372881269E-2,-1.5220779220779225E-2,-1.8250995759987523E-3,3.4225604578759505E-3,-2.6943602412925483E-3,-5.8653631202754686E-3,-1.0198633770106276E-2,null,2.3477912877627113E-3,-1.1152542372881269E-2,-1.5220779220779225E-2,-1.8250995759987523E-3,3.4225604578759505E-3,-2.6943602412925483E-3,-5.8653631202754686E-3,-7.8931889210653375E-3,null,0,0,0,0,0,0,0,-2.3054448490409385E-3]
[]
[null,5,null,"OPENING BASE REVENUE ALLOWANCE (2009/10 PRICES)","PUt",null,525500000,506400000,509700000,500200000,499000000,497900000,495100000,496200000,null,525500000,506400000,509700000,500200000,499000000,497900000,495100000,496200000,null,0,0,0,0,0,0,0,0,null,"FIXED PER LICENCE"]
[null,6,null,"PRICE CONTROL FINANCIAL MODEL ITERATION ADJUSTMENT (2009/10 PRICES)","MODt",null,null,-3200000,-7600000,-13600000,-12300000,-13100000,-21500000,-34000000,null,null,-3200000,-7600000,-13600000,-12300000,-13100000,-21500000,-34000000,null,0,0,0,0,0,0,0,0]
[null,7,null,"RPI TRUE UP (2009/10 PRICES)","TRUt",null,null,null,1797021.82,-7112090.1100000003,-10970125.9,-1927175.15,1284333.29,-393416.36,null,null,null,1797021.82,-7112090.1100000003,-10970125.9,-1927175.15,1284333.29,-393416.36,null,0,0,0,0,0,0,0,0]
[null,8,null,"UPLIFT TO NOMINAL PRICES USING RPIFt",null,null,85665083.00999999,103198175.41999996,114209681.62000006,111592797.49000001,128885944.97000003,151633778.78999996,170288917.87999994,175412404.51999998,null,85665083.00999999,103198175.41999996,114209681.62000006,111592797.49000001,128885944.97000003,151633778.78999996,170288917.87999994,175412404.51999998,null,0,0,0,0,0,0,0,0]
[null,9,null,"BASE REVENUE (NOMINAL)","BRt",null,611165083.00999999,606398175.41999996,618106703.44000006,591080707.38,604615819.07000005,634506603.63999999,645173251.16999996,637218988.15999997,null,611165083.00999999,606398175.41999996,618106703.44000006,591080707.38,604615819.07000005,634506603.63999999,645173251.16999996,637218988.15999997,null,0,0,0,0,0,0,0,0]
[]
[null,10,null,"BUSINESS RATES ADJUSTMENT","RBt",null,null,null,1577580.34,1831950.92,2730877.39,1947708.51,-1668506.58,-1838667.35,null,null,null,1577580.34,1831950.92,2730877.39,1947708.51,-1668506.58,-1838667.35,null,0,0,0,0,0,0,0,0]
[null,11,null,"LICENCE FEES ADJUSTMENT","LFt",null,null,null,32628.080000000002,-26048.37,37707.46,-461047.27,132347.07999999999,161116.98000000001,null,null,null,32628.080000000002,-26048.37,37707.46,-461047.27,132347.07999999999,161116.98000000001,null,0,0,0,0,0,0,0,0]
[null,12,null,"PENSION DEFICIT ADJUSTMENT","PDt",null,null,null,11339.38,152084.35999999999,3606354.9,3515906.82,-1312443.8700000001,-1301450.98,null,null,null,11339.38,152084.35999999999,3606354.9,3515906.82,-1312443.8700000001,-1301450.98,null,0,0,0,0,0,0,0,0]
[null,13,null,"OTHER PASS THROUGH: \nTHIRD PARTY DAMAGE & WATER INGRESS, THEFT OF GAS, MISC PASS THROUGH","TPWIt + TGt + MPt",null,104145.16,22955.129999999997,788.18000000000029,-9571.8700000000008,-426554.55,958255.2300000001,812622.17,1419155.14,null,104145.16,22955.129999999997,788.18000000000029,-9571.8700000000008,-426554.55,958255.2300000001,1072992.57,1419155.14,null,0,0,0,0,0,0,-260370.40000000002,0,null,"2019/20 NETT THEFT OF GAS VALUES CONFIRMED"]
[null,14,null,"PASS THROUGH","PTt",null,104145.16,22955.129999999997,1622335.98,1948415.0399999996,5948385.2000000002,5960823.29,-2035981.2000000002,-1559846.2100000002,null,104145.16,22955.129999999997,1622335.98,1948415.0399999996,5948385.2000000002,5960823.29,-1775610.8,-1559846.2100000002,null,0,0,0,0,0,0,-260370.40000000014,0]
[]
[null,15,null,"NTS EXIT CAPACITY INCENTIVE REVENUE ADJUSTMENT","EIt",null,null,null,2055924.78,6236102.3600000003,13323121.6,9553788,9916262.5,10413501.41,null,null,null,2055924.78,6236102.3600000003,13323121.6,9553788,9916262.5,10413501.41,null,0,0,0,0,0,0,0,0]
[null,16,null,"NTS EXIT CAPACITY COST ADJUSTMENT",null,null,null,null,-2296509.87,-4109472.34,-7584859.2199999997,-6492637.8300000001,-6827289.6200000001,-14356864.65,null,null,null,-2296509.87,-4109472.34,-7584859.2199999997,-6492637.8300000001,-6827289.6200000001,-14356864.65,null,0,0,0,0,0,0,0,0]
[null,17,null,"NTS EXIT CAPACITY REVENUE ADJUSTMENT","EXt",null,0,0,-240585.09000000008,2126630.0200000005,5738262.3799999999,3061150.17,3088972.88,-3943363.24,null,0,0,-240585.09000000008,2126630.0200000005,5738262.3799999999,3061150.17,3088972.88,-3943363.24,null,0,0,0,0,0,0,0,0]
[]
[null,18,null,"SHRINKAGE INCENTIVE REVENUE ADJUSTMENT","SHRRt",null,null,null,823776.85,633008.81000000006,560299.23,350248.71,391734.66,733582.73,null,null,null,823776.85,633008.81000000006,560299.23,350248.71,391734.66,733582.73,null,0,0,0,0,0,0,0,0,null,"GAS PRICES UPDATED THROUGH TO AUG 2020"]
[null,19,null,"SHRINKAGE COST ADJUSTMENT","SHRAt",null,null,null,-2590624.13,-6074715.9900000002,-7956633.3399999999,-4325952.38,-3247141.57,-1786498.8,null,null,null,-2590624.13,-6074715.9900000002,-7956633.3399999999,-4325952.38,-3247141.57,-1786498.8,null,0,0,0,0,0,0,0,0,null,"GAS PRICES UPDATED THROUGH TO AUG 2020"]
[null,20,null,"SHRINKAGE REVENUE ADJUSTMENT","SHRt",null,0,0,-1766847.2799999998,-5441707.1799999997,-7396334.1099999994,-3975703.67,-2855406.9099999997,-1052916.07,null,0,0,-1766847.2799999998,-5441707.1799999997,-7396334.1099999994,-3975703.67,-2855406.9099999997,-1052916.07,null,0,0,0,0,0,0,0,0]
[]
[null,21,null,"BROAD MEASURE OF CUSTOMER SATISFACTION REVENUE ADJUSTMENT","BMt",null,null,null,2557872.7000000002,1686110.66,3096094.67,4119661.68,4235106.8099999996,4233790.8099999996,null,null,null,2557872.7000000002,1686110.66,3096094.67,4119661.68,4235106.8099999996,4233790.8099999996,null,0,0,0,0,0,0,0,0]
[null,22,null,"ENVIRONMENTAL EMISSIONS INCENTIVE REVENUE ADJUSTMENT","EEIt",null,null,null,2559508.14,2840096.11,3143224.33,2120643.4700000002,2104054.44,3199231.06,null,null,null,2559508.14,2840096.11,3143224.33,2120643.4700000002,2104054.44,3199231.06,null,0,0,0,0,0,0,0,0]
[null,23,null,"DISCRETIONARY REWARD SCHEME REVENUE ADJUSTMENT","DRSt",null,327248.09999999998,305027.55,null,201688.64,null,null,210856.31,null,null,327248.09999999998,305027.55,null,201688.64,null,null,210856.31,null,null,0,0,0,0,0,0,0,0,null,"NO FURTHER CHANGE ANTICIPATED"]
[null,24,null,"NETWORK INNOVATION ALLOWANCE REVENUE ADJUSTMENT","NIAt",null,922455.14,2516232.62,3145633.28,2504250,2420238.0699999998,1603326.75,2008314.1,2995013.58,null,922455.14,2516232.62,3145633.28,2504250,2420238.0699999998,1603326.75,2008314.1,2995013.58,null,0,0,0,0,0,0,0,0]
[null,25,null,"CORRECTION TERM REVENUE ADJUSTMENT","-Kt",null,5937970.5700000003,0,-2902563.08,-313431.3,133937.20000000001,-4703397.6500000004,-1848735.31,-3387918.69,null,5937970.5700000003,0,-2902563.08,-313431.3,133937.20000000001,-4703397.6500000004,-1848735.31,-3387918.69,null,0,0,0,0,0,0,0,0]
[]
[null,26,null,"MAXIMUM ALLOWED REVENUE","ARt",null,618456901.98000002,609242390.71999991,623082058.09000003,596632759.37,617699626.81000018,642693107.67999995,650080432.28999996,637702979.39999974,null,618456901.98000002,609242390.71999991,623082058.09000003,596632759.37,617699626.81000018,642693107.67999995,650340802.69000006,637702979.39999974,null,0,0,0,0,0,0,-260370.40000009537,0]
[]
[null,27,null,"COLLECTABLE REVENUE","Rt",null,621246755,609543651.10000002,622953114.89999998,601167362.51999998,619476279.38999999,645937282.05999994,651787797.97000003,635402985.53999996,null,621246755,609543651.10000002,622953114.89999998,601167362.51999998,619476279.38999999,645937282.05999994,652349726.87,635707139.80999994,null,0,0,0,0,0,0,-561928.89999997616,-304154.26999998093,null,"REFLECTS ACTUAL COLLECTED REVENUE TO JULY 2020"]
[null,28,null,"UNDER / OVER RECOVERY CARRIED FORWARDS","ARt - Rt",null,2789853.0199999809,301260.38000011444,-128943.19000005722,4534603.1499999762,1776652.5799998045,3244174.3799999952,1707365.6800000668,-2299993.8599997759,null,2789853.0199999809,301260.38000011444,-128943.19000005722,4534603.1499999762,1776652.5799998045,3244174.3799999952,2008924.1799999475,-1995839.589999795,null,0,0,0,0,0,0,-301558.49999988079,-304154.26999998093]
[]
[null,29,null,"YEAR ON YEAR MOVEMENT IN ALLOWED REVENUE",null,null,null,-1.4899197066925329E-2,2.2716192406842417E-2,-4.2449141933372125E-2,3.6197246984567721E-2,4.2562053803007149E-2,1.2101138501105169E-2,-1.9039879182948027E-2,null,null,-1.4899197066925329E-2,2.2716192406842417E-2,-4.2449141933372125E-2,3.6197246984567721E-2,4.2562053803007149E-2,1.2101138501105169E-2,-1.9432616310904316E-2,null,null,0,0,0,0,0,0,3.9273712795628857E-4]
[null,30,null,"ADJUSTMENT FOR PRIOR YEAR OVER / UNDER RECOVERY",null,null,null,-4.5109901936064099E-3,-4.9448361537037216E-4,2.0694415498870332E-4,-7.6003254578045311E-3,-3.9791287917074141E-4,-2.5817160386905217E-3,-2.626391435880681E-3,null,null,-4.5109901936064099E-3,-4.9448361537037216E-4,2.0694415498870332E-4,-7.6003254578045311E-3,-3.9791287917074141E-4,-2.5817160386905217E-3,-3.0890329680845008E-3,null,null,0,0,0,0,0,0,4.6264153220381982E-4]
[null,31,null,"IMPACT OF CHANGE IN ANNUAL LOAD FACTORS",null,null,null,3.8522782335911276E-3,3.2406286001118332E-3,1.1085806589531215E-3,-8.1317558819166899E-3,-5.7127957825795495E-3,6.5322483491523364E-3,6.1000000000000004E-3,null,null,3.8522782335911276E-3,3.2406286001118332E-3,1.1085806589531215E-3,-8.1317558819166899E-3,-5.7127957825795495E-3,6.5322483491523364E-3,6.1000000000000004E-3,null,null,0,0,0,0,0,0,0]
[null,32,null,"YEAR ON YEAR MOVEMENT IN AGGREGATE DEMAND",null,null,null,1.1557909026940609E-2,1.1208990117689499E-2,9.1718611800789482E-3,-2.6458009685796299E-4,-5.3859837416966802E-3,-2.166039304211885E-2,4.9524133517581705E-3,null,null,1.1557909026940609E-2,1.1208990117689499E-2,9.1718611800789482E-3,-2.6458009685796299E-4,-5.3859837416966802E-3,-2.166039304211885E-2,5.807792011918278E-3,null,null,0,0,0,0,0,0,-8.5537866016010752E-4,null,"BASED ON JAN 2020 SUPPLY POINT DATA PROVIDED BY XOSERVE"]
[null,33,null,"TOTAL DISTRIBUTION CHARGES ARITHMETICAL PRICE CHANGE",null,null,null,-4.0000000000000001E-3,3.6671327509273377E-2,-3.1961755939351355E-2,2.0200585547988537E-2,3.1065361399560176E-2,-5.6087222305518658E-3,-1.0613857267070537E-2,null,null,-4.0000000000000001E-3,3.6671327509273377E-2,-3.1961755939351355E-2,2.0200585547988537E-2,3.1065361399560176E-2,-5.6087222305518658E-3,-1.0613857267070537E-2,null,null,0,0,0,0,0,0,0]
[]
[null,null,null,"TABLE 2: DOMESTIC CUSTOMER BILL IMPACT (EXCL ECN CHARGES)"]
[]
[null,34,null,"AVERAGE AQ PER DOMESTIC CUSTOMER (Kwh)",null,null,14436.284236490006,14331.469212323407,13954.907021858491,13783.00003769457,13806.362917479473,13852.469095334813,14090.393228563897,13895.897352371838,null,14436.284236490006,14331.469212323407,13954.907021858491,13783.00003769457,13806.362917479473,13852.469095334813,14090.393228563897,13895.897352371838,null,0,0,0,0,0,0,0,0,null,"BASED ON JAN 2020 DEMAND DATA PROVIDED BY XOSERVE"]
[null,35,null,"TOTAL ANNUAL CHARGE (EXCL. ECN) (NOMINAL)",null,null,123.16,121.33,122.33,116.43,120.64,125.04,126.25,124.26,null,123.16,121.33,122.33,116.43,120.64,125.04,126.25,124.26,null,0,0,0,0,0,0,0,0]
[null,36,null,"TOTAL ANNUAL CHARGE (EXCL. ECN) (19/20 PRICES)",null,null,142.19581965042372,137.39046785714285,137.04559328022611,127.69989968237991,127.5443717602837,128.27661499544078,126.25,122.47778095430915,null,142.19581965042372,137.39046785714285,137.04559328022611,127.69989968237991,127.5443717602837,128.27661499544078,126.25,122.20009606677472,null,0,0,0,0,0,0,0,0.27768488753443421,null,"BASED ON RPI DATA UPTO APRIL 2020"]
[null,37,null,"% MOVEMENT IN DOMESTIC CUSTOMER BILL (19/20 PRICES)",null,null,null,-3.379390340091859E-2,-2.5101783427605717E-3,-6.8194046770525873E-2,-1.2179173396615894E-3,5.7410862200435453E-3,-1.5798787608425791E-2,-2.9878962738145276E-2,null,null,-3.379390340091859E-2,-2.5101783427605717E-3,-6.8194046770525873E-2,-1.2179173396615894E-3,5.7410862200435453E-3,-1.5798787608425791E-2,-3.2078446995843835E-2,null,0,0,0,0,0,0,0,2.1994842576985585E-3]
[]
[null,null,null,"TABLE 3: ECN CHARGE ELEMENTS (NTS EXIT CAPACITY ONLY)"]
[]
[null,38,null,"INITIAL ALLOWED REVENUE (2009/10 PRICES)","AEXt",null,24700000,24700000,24700000,24700000,24700000,24700000,24700000,24700000,null,24700000,24700000,24700000,24700000,24700000,24700000,24700000,24700000,null,0,0,0,0,0,0,0,0]
[null,39,null,"INFLATED BASE REVENEUE (NOMINAL)","AEXt",null,28726503.43,29765570.219999999,30298324.690000001,30448512.199999999,31391786.690000001,32456399.079999998,33557180.530000001,34082036.859999999,null,28726503.43,29765570.219999999,30298324.690000001,30448512.199999999,31391786.690000001,32456399.079999998,33557180.530000001,34082036.859999999,null,0,0,0,0,0,0,0,0]
[null,40,null,"ECN COST TRUE UP",null,null,0,0,-2296509.87,-4109472.34,-7584859.2199999997,-6492637.8300000001,-6827289.6200000001,-14356864.65,null,0,0,-2296509.87,-4109472.34,-7584859.2199999997,-6492637.8300000001,-6827289.6200000001,-14356864.65,null,0,0,0,0,0,0,0,0]
[null,41,null,"CORRECTION FACTOR (ECN)",null,null,-218393.03,0,-462808.05066000234,-166335.24009600218,-701390.13196210726,-214270.55460428839,49785.26194346221,-154598.73231697766,null,-218393.03,0,-462808.05066000234,-166335.24009600218,-701390.13196210726,-214270.55460428839,49785.26194346221,-154598.73231697766,null,0,0,0,0,0,0,0,0]
[null,42,null,"TOTAL ALLOWED REVENUE (ECN)",null,null,28508110.399999999,29765570.219999999,27539006.77,26172704.620000001,23105537.34,25749490.699999999,26779676.170000002,19570573.48,null,28508110.399999999,29765570.219999999,27539006.77,26172704.620000001,23105537.34,25749490.699999999,26779676.170000002,19570573.48,null,0,0,0,0,0,0,0,0]
[]
[null,43,null,"COLLECTABLE REVENUE (ECN)",null,null,28952947.050000001,29925446.460000001,28214244.75,26379285.48,23057693.219999999,25897530.039999999,26802344.390000001,19404566.800000001,null,28952947.050000001,29925446.460000001,28214244.75,26379285.48,23057693.219999999,25897530.039999999,26812215.390000001,19384204.710000001,null,0,0,0,0,0,0,-9871,20362.089999999851]
[null,44,null,"UNDER / OVER RECOVERY CARRIED FORWARDS (ECN)",null,null,444836.65000000224,159876.24000000209,675237.98000000045,206580.8599999994,-47844.120000001043,148039.33999999985,22668.219999998808,-166006.6799999997,null,444836.65000000224,159876.24000000209,675237.98000000045,206580.8599999994,-47844.120000001043,148039.33999999985,32539.219999998808,-186368.76999999955,null,0,0,0,0,0,0,-9871,20362.089999999851]
[]
[null,45,null,"YEAR ON YEAR MOVEMENT IN ALLOWED REVENUE",null,null,null,4.4108844899099386E-2,-7.4803319188689099E-2,-4.9613341592566029E-2,-0.11718954248450919,0.11442942534051448,4.0007994022188687E-2,-0.26920051774472231,null,null,4.4108844899099386E-2,-7.4803319188689099E-2,-4.9613341592566029E-2,-0.11718954248450919,0.11442942534051448,4.0007994022188687E-2,-0.26920051774472231,null,null,0,0,0,0,0,0,0]
[null,46,null,"ADJUSTMENT FOR PRIOR YEAR OVER / UNDER RECOVERY",null,null,null,-1.5603863032605705E-2,-5.3711801527181391E-3,-2.4519329460188824E-2,-7.892988630687393E-3,6.0115316928612082E-3,-5.2446746063214084E-3,-8.4647102736040312E-4,null,null,-1.5603863032605705E-2,-5.3711801527181391E-3,-2.4519329460188824E-2,-7.892988630687393E-3,6.0115316928612082E-3,-5.2446746063214084E-3,-1.2150714517022783E-3,null,null,0,0,0,0,0,0,3.6860042434187518E-4]
[null,47,null,"IMPACT OF CHANGE IN ANNUAL LOAD FACTORS",null,null,null,3.8522782335911276E-3,3.2406286001118332E-3,1.1085806589531215E-3,-8.1317558819166899E-3,-6.1951066955738803E-3,6.5322483491523364E-3,6.1000000000000004E-3,null,null,3.8522782335911276E-3,3.2406286001118332E-3,1.1085806589531215E-3,-8.1317558819166899E-3,-6.1951066955738803E-3,6.5322483491523364E-3,6.1000000000000004E-3,null,null,0,0,0,0,0,0,0]
[null,48,null,"YEAR ON YEAR MOVEMENT IN AGGREGATE DEMAND",null,null,null,1.164273989991519E-2,1.6537612032070576E-2,2.5946380168061473E-2,-6.1577699808351427E-3,-6.2703175230133662E-3,-1.5305348688486743E-2,-5.4731855142738373E-3,null,null,1.164273989991519E-2,1.6537612032070576E-2,2.5946380168061473E-2,-6.1577699808351427E-3,-6.2703175230133662E-3,-1.5305348688486743E-2,-5.1045850899319456E-3,null,null,0,0,0,0,0,0,-3.6860042434189166E-4]
[null,49,null,"ECN CHARGES ARITHMETICAL PRICE CHANGE",null,null,null,4.3999999999999997E-2,-6.0396258709224826E-2,-4.7077710225740255E-2,-0.13937205697794841,0.10797553281478844,2.5990219076532872E-2,-0.26942017428635656,null,null,4.3999999999999997E-2,-6.0396258709224826E-2,-4.7077710225740255E-2,-0.13937205697794841,0.10797553281478844,2.5990219076532872E-2,-0.26942017428635656,null,null,0,0,0,0,0,0,0]
[]
[null,null,null,"TABLE 4: LDZ & CUSTOMER CHARGE ELEMENTS"]
[]
[null,50,null,"DN ALLOWED REVENUE LESS ECN REVENUE",null,null,589948791.58000004,579476820.49999988,595543051.32000005,570460054.75,594594089.47000015,616943616.9799999,623300756.12,618132405.91999972,null,589948791.58000004,579476820.49999988,595543051.32000005,570460054.75,594594089.47000015,616943616.9799999,623561126.5200001,618132405.91999972,null,0,0,0,0,0,0,-260370.40000009537,0,null,"IMPACTED BY NETT THEFT OF GAS VALUES"]
[null,51,null,"DN COLLECTABLE REVENUE LESS ECN REVENUE",null,null,592293807.95000005,579618204.63999999,594738870.14999998,574788077.03999996,596418586.16999996,620039752.01999998,624985453.58000004,615998418.74000001,null,592293807.95000005,579618204.63999999,594738870.14999998,574788077.03999996,596418586.16999996,620039752.01999998,625537511.48000002,616322935.0999999,null,0,0,0,0,0,0,-552057.89999997616,-324516.3599998951,null,"BASED ON ACTUAL COLLECTED REVENUE POSTIONS TO JULY 2020"]
[null,52,null,"UNDER / OVER RECOVERY CARRIED FORWARDS (LDZ & CUSTOMER)",null,null,2345016.3700000048,141384.1400001049,-804181.17000007629,4328022.2899999619,1824496.6999998093,3096135.0400000811,1684697.4600000381,-2133987.1799997091,null,2345016.3700000048,141384.1400001049,-804181.17000007629,4328022.2899999619,1824496.6999998093,3096135.0400000811,1976384.9599999189,-1809470.819999814,null,0,0,0,0,0,0,-291687.49999988079,-324516.3599998951]
[]
[null,53,null,"YEAR ON YEAR MOVEMENT IN ALLOWED REVENUE",null,null,null,-1.7750644173630925E-2,2.7725407214972853E-2,-4.2117856155662436E-2,4.3234632161595732E-2,3.9771819978710266E-2,1.093928901656871E-2,-8.2919042681303123E-3,null,null,-1.7750644173630925E-2,2.7725407214972853E-2,-4.2117856155662436E-2,4.3234632161595732E-2,3.9771819978710266E-2,1.093928901656871E-2,-8.7059958825483896E-3,null,null,0,0,0,0,0,0,4.1409161441807729E-4]
[null,54,null,"ADJUSTMENT FOR PRIOR YEAR OVER / UNDER RECOVERY",null,null,null,-3.9749490184047753E-3,-2.43985842053375E-4,1.35033255482981E-3,-7.5868980728136812E-3,-6.4675805963648216E-4,-2.4708487631996119E-3,-2.7028644574204471E-3,null,null,-3.9749490184047753E-3,-2.43985842053375E-4,1.35033255482981E-3,-7.5868980728136812E-3,-6.4675805963648216E-4,-2.4708487631996119E-3,-3.1695127806151469E-3,null,null,0,0,0,0,0,0,4.666483231946998E-4]
[null,55,null,"IMPACT OF CHANGE IN ANNUAL LOAD FACTORS",null,null,null,3.8522782335911276E-3,3.2406286001118332E-3,1.1085806589531215E-3,-8.1317558819166899E-3,-6.1951066955738803E-3,6.5322483491523364E-3,6.1000000000000004E-3,null,null,3.8522782335911276E-3,3.2406286001118332E-3,1.1085806589531215E-3,-8.1317558819166899E-3,-6.1951066955738803E-3,6.5322483491523364E-3,6.1000000000000004E-3,null,null,0,0,0,0,0,0,0]
[null,56,null,"YEAR ON YEAR MOVEMENT IN AGGREGATE DEMAND",null,null,null,1.0873314958444576E-2,1.0922747739526933E-2,8.4016135832185174E-3,6.718065559729175E-5,-4.834464062179418E-3,-2.1916481273151461E-2,5.421779202344359E-3,null,null,1.0873314958444576E-2,1.0922747739526933E-2,8.4016135832185174E-3,6.718065559729175E-5,-4.834464062179418E-3,-2.1916481273151461E-2,6.3025191399571348E-3,null,null,0,0,0,0,0,0,-8.8073993761277579E-4,null,"BASED ON JAN 2020 SUPPLY POINT DATA PROVIDED BY XOSERVE"]
[null,57,null,"LDZ & CUSTOMER CHARGES ARITHMETICAL PRICE CHANGE",null,null,null,-6.9999999999999993E-3,4.1644797712558246E-2,-3.125732935866099E-2,2.7583158862462653E-2,2.8095491161320485E-2,-6.9157926706300277E-3,5.2701047679359903E-4,null,null,-6.9999999999999993E-3,4.1644797712558246E-2,-3.125732935866099E-2,2.7583158862462653E-2,2.8095491161320485E-2,-6.9157926706300277E-3,5.2701047679359903E-4,null,null,0,0,0,0,0,0,0]
[]
[null,null,null,"TABLE 5: PCFM ADJUSTMENTS"]
[]
[null,null,null,"DESCRIPTION","PCFM TERM",null,"FREQENCY","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21",null,"FREQENCY","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21",null,"FREQENCY","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21"]
[]
[null,58,null,"COST OF DEBT","CDE",null,"ANNUAL",2.7199999999999998E-2,2.5499999999999998E-2,2.3800000000000002E-2,2.2200000000000001E-2,1.9100000000000002E-2,1.5800000000000002E-2,1.09E-2,null,"ANNUAL",2.7199999999999998E-2,2.5499999999999998E-2,2.3800000000000002E-2,2.2200000000000001E-2,1.9100000000000002E-2,1.5800000000000002E-2,1.09E-2,null,"ANNUAL",0,0,0,0,0,0,0]
[null,59,null,"CORPORATION TAX RATE","CT",null,"ANNUAL",0.21,0.2,0.2,0.19,0.19,0.19,0.19,null,"ANNUAL",0.21,0.2,0.2,0.19,0.19,0.19,0.19,null,"ANNUAL",0,0,0,0,0,0,0]
[]
[null,60,null,"COST OF DEBT ADJUSTMENT","CDE £ IMPACT",null,"ANNUAL",-3107658.8385885088,-7060000,-8559152.5141329505,-11148962.490910865,-14220970.056575198,-23420668.439535916,-29186758.223751351,null,"ANNUAL",-3107658.8385885088,-7060000,-8559152.5141329505,-11148962.490910865,-14220970.056575198,-23420668.439535916,-29186758.223751351,null,"ANNUAL",0,0,0,0,0,0,0]
[null,61,null,"TAX TRIGGER EVENT","TTE",null,"AT ANY TIME",0,-400000,-393455.66175363341,-2417800.872433702,-2297603.9204066237,-2409425.1351929754,-4014565.2699293997,null,"AT ANY TIME",0,-400000,-393455.66175363341,-2417800.872433702,-2297603.9204066237,-2409425.1351929754,-4014565.2699293997,null,"AT ANY TIME",0,0,0,0,0,0,0]
[null,62,null,"TAX LIABILITY - GEARING/INTEREST COSTS","TGIE",null,"AT ANY TIME",0,0,0,0,0,0,0,null,"AT ANY TIME",0,0,0,0,0,0,0,null,"AT ANY TIME",0,0,0,0,0,0,0]
[null,63,null,"PENSION SCHEME ESTABLISHED DEFICIT","EDE",null,"3 YEARLY REVIEW",0,-900000,-935763.36200054944,-869541.95199882635,5802830.298241986,5802830.2982419292,5802830.2982417587,null,"3 YEARLY REVIEW",0,-900000,-935763.36200054944,-869541.95199882635,5802830.298241986,5802830.2982419292,5802830.2982417587,null,"3 YEARLY REVIEW",0,0,0,0,0,0,0,null,"NO FURTHER CHANGE EXPECTED IN RIIO-GD1"]
[null,64,null,"PENSION SCHEME ADMINISTRATION & PPF LEVY","APFE",null,"3 YEARLY REVIEW",0,0,0,0,528469.66576282738,528469.66576282738,528469.66576294112,null,"3 YEARLY REVIEW",0,0,0,0,528469.66576282738,528469.66576282738,528469.66576294112,null,"3 YEARLY REVIEW",0,0,0,0,0,0,0,null,"NO FURTHER CHANGE EXPECTED IN RIIO-GD1"]
[null,65,null,"SPECIFIED FINANCIAL ADJUSTMENTS",null,null,null,-3107658.8385885088,-8360000,-9888371.5378871337,-14436305.315343393,-10187274.01297701,-19498793.610724136,-26870023.529676054,null,null,-3107658.8385885088,-8360000,-9888371.5378871337,-14436305.315343393,-10187274.01297701,-19498793.610724136,-26870023.529676054,null,null,0,0,0,0,0,0,0]
[null,66,null,"LEGACY CAPEX RAV ADJUSTMENT","LRAV",null,"ONE OFF",-405237.68136586115,-200000,-311912.00328663626,-301926.25840021489,-293025.92774712364,-284262.50728614378,-275638.01205337769,null,"ONE OFF",-405237.68136586115,-200000,-311912.00328663626,-301926.25840021489,-293025.92774712364,-284262.50728614378,-275638.01205337769,null,"ONE OFF",0,0,0,0,0,0,0,null,"NO CHANGE EXPECTED IN RIIO-GD1"]
[null,67,null,"LEGACY ALLOWED REVENUE ADJUSTMENT","LAR",null,"ONE OFF",312896.51978488563,0,178380.59369194071,186694.28891149664,196364.12802753967,206486.58671012754,217080.96185409432,null,"ONE OFF",312896.51978488563,0,178380.59369194071,186694.28891149664,196364.12802753967,206486.58671012754,217080.96185409432,null,"ONE OFF",0,0,0,0,0,0,0,null,"NO CHANGE EXPECTED IN RIIO-GD1"]
[null,68,null,"LEGACY IFI CAP ADJUSTMENT","IFIAR",null,"ONE OFF",0,0,0,0,0,0,0,null,"ONE OFF",0,0,0,0,0,0,0,null,"ONE OFF",0,0,0,0,0,0,0,null,"NO CHANGE EXPECTED IN RIIO-GD1"]
[null,69,null,"LEGACY STREETWORKS COST ADJUSTMENT","IAEAR",null,"ONE OFF",0,0,0,0,0,0,0,null,"ONE OFF",0,0,0,0,0,0,0,null,"ONE OFF",0,0,0,0,0,0,0,null,"NO CHANGE EXPECTED IN RIIO-GD1"]
[null,70,null,"OVERALL LEGACY ADJUSTMENTS",null,null,null,-92341.161580975517,-200000,-133531.40959469555,-115231.96948871826,-96661.799719583971,-77775.920576016244,-58557.050199283374,null,null,-92341.161580975517,-200000,-133531.40959469555,-115231.96948871826,-96661.799719583971,-77775.920576016244,-58557.050199283374,null,null,0,0,0,0,0,0,0,null,"FIXED FOR RIIO GD-1"]
[]
[null,71,null,"TOTEX INCENTIVE MECHANISM",null,null,null,0,160000,265665.64266144193,-4080599.5079090851,-4406518.0397291789,-1573154.6228566393,1252814.035670137,null,null,0,160000,265665.64266144193,-4080599.5079090851,-4406518.0397291789,-1573154.6228566393,1252814.035670137,null,null,0,0,0,0,0,0,0,null,"ALIGNED TO 2018/19 RRP ACTUALS AND FORECAST"]
[]
[null,72,null,"ENHANCED PHYSICAL SITE SECURITY (CNI)","IAEEPS",null,"2 RE-OPENERS",0,0,1438908.9701647398,11236261.832828689,8063477.727041686,-1427233.6486033055,-1864421.6809329351,null,"2 RE-OPENERS",0,0,1438908.9701647398,11236261.832828689,8063477.727041686,-1427233.6486033055,-1864421.6809329351,null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"NO FURTHER CHANGE EXPECTED"]
[null,73,null,"SPECIFIED STREETWORKS","IAESW",null,"2 RE-OPENERS",0,0,0,0,0,7821187.1751926765,911474.61658795236,null,"2 RE-OPENERS",0,0,0,0,0,7821187.1751926765,911474.61658795236,null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"NO FURTHER CHANGE EXPECTED"]
[null,74,null,"CHANGE TO CONNECTION CHARGING BOUNDARY","IAECCB",null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"NO IMPACT IN RIIO GD-1"]
[null,75,null,"SMART METERING ROLL-OUT","IAESM",null,"RE-OPENER > REV DRIVER",0,0,0,0,0,0,0,null,"RE-OPENER > REV DRIVER",0,0,0,0,0,0,0,null,"RE-OPENER > REV DRIVER",0,0,0,0,0,0,0,null,"UPDATED FOR LATEST COST FORECAST IN 2018/19 RRP"]
[null,76,null,"LARGE LOAD CONNECTIONS","IAELLC",null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"NO IMPACT IN RIIO GD-1"]
[null,77,null,"FUEL POOR NETWORK EXTENSIONS","IAEFP",null,"1 RE-OPENER (FLEXIBLE)",0,0,383474.85287276539,385471.27143777971,258682.4198573936,268440.10654679098,278100.51757023757,null,"1 RE-OPENER (FLEXIBLE)",0,0,383474.85287276539,385471.27143777971,258682.4198573936,268440.10654679098,278100.51757023757,null,"1 RE-OPENER (FLEXIBLE)",0,0,0,0,0,0,0,null,"NO FURTHER CHANGE EXPECTED"]
[null,78,null,"AGENCY COSTS (FGO)","IAECA",null,"1 RE-OPENER (FLEXIBLE)",0,0,0,-1542895.5957145831,-2826643.136325913,-3467203.2821999891,-3879541.9253609679,null,"1 RE-OPENER (FLEXIBLE)",0,0,0,-1542895.5957145831,-2826643.136325913,-3467203.2821999891,-3879541.9253609679,null,"1 RE-OPENER (FLEXIBLE)",0,0,0,0,0,0,0,null,"NO FURTHER CHANGE EXPECTED"]
[null,79,null,"MAINS & SERVICES (REPEX T2)","RE",null,"ANNUAL",0,800000,-257455.28576997234,-275726.46701526083,-413114.998128151,-39778.784142129094,-293288.05239189835,null,"ANNUAL",0,800000,-257455.28576997234,-275726.46701526083,-413114.998128151,-39778.784142129094,-293288.05239189835,null,"ANNUAL",0,0,0,0,0,0,0,null,"UPDATED ANNUALLY. REFLECTS 2018/19 RRP"]
[null,80,null,"INNOVATION ROLL-OUT MECHANISM","IRM",null,"ANNUAL",0,0,0,0,0,0,0,null,"ANNUAL",0,0,0,0,0,0,0,null,"ANNUAL",0,0,0,0,0,0,0,null,"NO IMPACT IN RIIO GD-1"]
[null,81,null,"NTS EXIT CAPACITY COST ALLOWANCE","AEX",null,"ANNUAL",0,0,0,0,0,0,0,null,"ANNUAL",0,0,0,0,0,0,0,null,"ANNUAL",0,0,0,0,0,0,0,null,"NO IMPACT IN RIIO GD-1"]
[null,82,null,"SHRINKAGE COST ALLOWANCE","ALSC",null,"ANNUAL",0,0,-5408691.22856359,-3470974.2487112293,-3491948.1642348841,-3505687.4126372575,-3476556.9356679292,null,"ANNUAL",0,0,-5408691.22856359,-3470974.2487112293,-3491948.1642348841,-3505687.4126372575,-3476556.9356679292,null,"ANNUAL",0,0,0,0,0,0,0,null,"NO FURTHER CHANGE EXPECTED"]
[null,83,null,"UNCERTAIN COSTS",null,null,null,0,800000,-3843762.6912960568,6332136.7928253943,1590453.8482101327,-350275.84584321314,-8324233.4601955405,null,null,0,800000,-3843762.6912960568,6332136.7928253943,1590453.8482101327,-350275.84584321314,-8324233.4601955405,null,null,0,0,0,0,0,0,0]
[]
[null,84,null,"TOTAL POTENTIAL IMPACT OF REVENUE ADJUSTMENTS SHOWN IN TABLE 5",null,null,null,-3200000.0001694844,-7600000,-13599999.996116444,-12299999.999915801,-13100000.004215639,-21500000.000000007,-34000000.004400745,null,null,-3200000.0001694844,-7600000,-13599999.996116444,-12299999.999915801,-13100000.004215639,-21500000.000000007,-34000000.004400745,null,0,0,0,0,0,0,0,0]
[null,85,null,"TOTAL VALUE INCLUDED IN TABLE 1 IN THIS FORECAST",null,null,null,-3200000,-7600000,-13600000,-12300000,-13100000,-21500000,-34000000,null,null,-3200000,-7600000,-13600000,-12300000,-13100000,-21500000,-34000000,null,0,0,0,0,0,0,0,0]
[]
[null,null,null,"TABLE 6: RISKS AND SENSITIVITIES",null,null,"2013/14","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21",null,"2013/14","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21",null,"2013/14","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21"]
[]
[null,86,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]

{"sheet":"LO MOD0186 RIIO-GD1","index":3,"n_rows":124,"n_cols":34,"rows_kept":124,"cut":false,"hidden":false,"merged":[[52,3,52,4],[75,3,75,4],[63,3,63,4],[64,3,64,4],[66,3,66,4],[68,3,68,4],[70,3,70,4],[72,3,72,4],[74,3,74,4],[69,3,69,4],[53,3,53,4],[55,3,55,4],[61,3,61,4],[67,3,67,4],[82,3,82,4],[84,3,84,4],[76,3,76,4],[78,3,78,4],[80,3,80,4],[79,3,79,4],[81,3,81,4],[0,24,0,31],[4,3,4,4],[0,3,0,4],[0,6,0,13],[0,15,0,22],[42,3,42,4],[44,3,44,4],[46,3,46,4],[48,3,48,4],[51,3,51,4],[43,3,43,4],[45,3,45,4],[50,3,50,4],[121,3,121,4],[123,3,123,4],[96,3,96,4],[101,3,101,4],[103,3,103,4],[116,3,116,4],[118,3,118,4],[119,3,119,4]]}
[null,null,null,"CADENT GAS LTD\nLONDON DISTRIBUTION NETWORK",null,null,"CURRENT (SEPT-2020)",null,null,null,null,null,null,null,null,"PREVIOUS (JUN-2020)",null,null,null,null,null,null,null,null,"MOVEMENT"]
[]
[null,null,null,"DESCRIPTION","LICENCE \nTERM",null,"2013/14","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21",null,"2013/14","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21",null,"2013/14","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21"]
[]
[null,"ROW REF",null,"TABLE 1: TOTAL CHARGE ELEMENTS (LDZ + CUSTOMER + ECN)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTES (RIIO GD-1)"]
[]
[null,1,null,"FORECAST RPI FACTOR","RPIFt",null,1.1630163330372321,1.2050838144310987,1.2266528212575318,1.2327332873088215,1.270922538158505,1.314024254388422,1.358590304925267,1.3798395491512827,null,1.1630163330372321,1.2050838144310987,1.2266528212575318,1.2327332873088215,1.270922538158505,1.314024254388422,1.358590304925267,1.3798395491512827,null,0,0,0,0,0,0,0,0,null,"BASED ON AUG-2020 HMT 'FORECASTS FOR THE UK ECONOMY'. "]
[null,2,null,"ASSUMED ANNUAL INFLATION FOR PRICE SETTING","GRPIFt",null,2.6500000000000003E-2,3.075E-2,2.6000000000000002E-2,2.325E-2,3.4000000000000002E-2,3.3250000000000002E-2,3.175E-2,2.4750000000000001E-2,null,2.6500000000000003E-2,3.075E-2,2.6000000000000002E-2,2.325E-2,3.4000000000000002E-2,3.3250000000000002E-2,3.175E-2,2.4750000000000001E-2,null,0,0,0,0,0,0,0,0,null,"BASED ON AUG-2020 HMT 'FORECASTS FOR THE UK ECONOMY'. "]
[null,3,null,"ACTUAL / FORECAST ANNUAL INFLATION",null,null,2.8847791287762714E-2,1.9597457627118731E-2,1.0779220779220777E-2,2.1424900424001248E-2,3.7422560457875953E-2,3.0555639758707454E-2,2.5884636879724532E-2,1.4551366229893725E-2,null,2.8847791287762714E-2,1.9597457627118731E-2,1.0779220779220777E-2,2.1424900424001248E-2,3.7422560457875953E-2,3.0555639758707454E-2,2.5884636879724532E-2,1.6856811078934664E-2,null,0,0,0,0,0,0,0,-2.3054448490409385E-3,null,"BASED ON RPI DATA UP TO JULY 2020"]
[null,4,null,"DIFFERENCE (DRIVES t+2 RPI TRUE UP)",null,null,2.3477912877627113E-3,-1.1152542372881269E-2,-1.5220779220779225E-2,-1.8250995759987523E-3,3.4225604578759505E-3,-2.6943602412925483E-3,-5.8653631202754686E-3,-1.0198633770106276E-2,null,2.3477912877627113E-3,-1.1152542372881269E-2,-1.5220779220779225E-2,-1.8250995759987523E-3,3.4225604578759505E-3,-2.6943602412925483E-3,-5.8653631202754686E-3,-7.8931889210653375E-3,null,0,0,0,0,0,0,0,-2.3054448490409385E-3]
[]
[null,5,null,"OPENING BASE REVENUE ALLOWANCE (2009/10 PRICES)","PUt",null,353100000,346400000,368500000,358900000,354000000,353000000,347600000,347200000,null,353100000,346400000,368500000,358900000,354000000,353000000,347600000,347200000,null,0,0,0,0,0,0,0,0,null,"FIXED PER LICENCE"]
[null,6,null,"PRICE CONTROL FINANCIAL MODEL ITERATION ADJUSTMENT (2009/10 PRICES)","MODt",null,null,-2800000,-1700000,-4500000,-20700000,-23900000,-26600000,-31900000,null,null,-2800000,-1700000,-4500000,-20700000,-23900000,-26600000,-31900000,null,0,0,0,0,0,0,0,0]
[null,7,null,"RPI TRUE UP (2009/10 PRICES)","TRUt",null,null,null,1207475.56,-4856347.7,-8021361.2999999998,-1406705.17,880006.46,-266752.8,null,null,null,1207475.56,-4856347.7,-8021361.2999999998,-1406705.17,880006.46,-266752.8,null,0,0,0,0,0,0,0,0]
[null,8,null,"UPLIFT TO NOMINAL PRICES USING RPIFt",null,null,57561067.199999988,70466798.639999986,83409932.579999983,81350443.25999999,88125314.410000026,102903642.58000004,115423049.67000002,119662086.57999998,null,57561067.199999988,70466798.639999986,83409932.579999983,81350443.25999999,88125314.410000026,102903642.58000004,115423049.67000002,119662086.57999998,null,0,0,0,0,0,0,0,0]
[null,9,null,"BASE REVENUE (NOMINAL)","BRt",null,410661067.19999999,414066798.63999999,451417408.13999999,430894095.56,413403953.11000001,430596937.41000003,437303056.13,434695333.77999997,null,410661067.19999999,414066798.63999999,451417408.13999999,430894095.56,413403953.11000001,430596937.41000003,437303056.13,434695333.77999997,null,0,0,0,0,0,0,0,0]
[]
[null,10,null,"BUSINESS RATES ADJUSTMENT","RBt",null,null,null,722574.58,839558.35,1250823.3,892608.33,25508853.920000002,25627175.690000001,null,null,null,722574.58,839558.35,1250823.3,892608.33,25508853.920000002,25627175.690000001,null,0,0,0,0,0,0,0,0]
[null,11,null,"LICENCE FEES ADJUSTMENT","LFt",null,null,null,18005.400000000001,6050.77,8346.7000000000007,-275311.34999999998,53512.83,66358.039999999994,null,null,null,18005.400000000001,6050.77,8346.7000000000007,-275311.34999999998,53512.83,66358.039999999994,null,0,0,0,0,0,0,0,0]
[null,12,null,"PENSION DEFICIT ADJUSTMENT","PDt",null,null,null,21329.360000000001,103651.38,2103172,2050451.17,-764383.07,-757974.75,null,null,null,21329.360000000001,103651.38,2103172,2050451.17,-764383.07,-757974.75,null,0,0,0,0,0,0,0,0]
[null,13,null,"OTHER PASS THROUGH: \nTHIRD PARTY DAMAGE & WATER INGRESS, THEFT OF GAS, MISC PASS THROUGH","TPWIt + TGt + MPt",null,40796.39,-95590.37,-772591.59,-274110,-691040.08,197265.07,-125375.41999999993,803084.84,null,40796.39,-95590.37,-772591.59,-274110,-691040.08,197265.07,608270.9,803084.84,null,0,0,0,0,0,0,-733646.32,0,null,"2019/20 NETT THEFT OF GAS VALUES CONFIRMED"]
[null,14,null,"PASS THROUGH","PTt",null,40796.39,-95590.37,-10682.25,675150.5,2671301.92,2865013.2199999997,24672608.259999998,25738643.82,null,40796.39,-95590.37,-10682.25,675150.5,2671301.92,2865013.2199999997,25406254.579999998,25738643.82,null,0,0,0,0,0,0,-733646.3200000003,0]
[]
[null,15,null,"NTS EXIT CAPACITY INCENTIVE REVENUE ADJUSTMENT","EIt",null,null,null,1487693.08,1671932.52,6077661.0899999999,4581794.18,4576997.55,4544958.5599999996,null,null,null,1487693.08,1671932.52,6077661.0899999999,4581794.18,4576997.55,4544958.5599999996,null,0,0,0,0,0,0,0,0]
[null,16,null,"NTS EXIT CAPACITY COST ADJUSTMENT",null,null,null,null,-1637965.33,-711534.26,-2012120.17,-2663820.0699999998,-2549104.5099999998,-7504069.7199999997,null,null,null,-1637965.33,-711534.26,-2012120.17,-2663820.0699999998,-2549104.5099999998,-7504069.7199999997,null,0,0,0,0,0,0,0,0]
[null,17,null,"NTS EXIT CAPACITY REVENUE ADJUSTMENT","EXt",null,0,0,-150272.25,960398.26,4065540.92,1917974.1099999999,2027893.04,-2959111.16,null,0,0,-150272.25,960398.26,4065540.92,1917974.1099999999,2027893.04,-2959111.16,null,0,0,0,0,0,0,0,0]
[]
[null,18,null,"SHRINKAGE INCENTIVE REVENUE ADJUSTMENT","SHRRt",null,null,null,556566.09,405947.35,296003.17,251661.94,415901.29,761638.17,null,null,null,556566.09,405947.35,296003.17,251661.94,415901.29,761638.17,null,0,0,0,0,0,0,0,0,null,"GAS PRICES UPDATED THROUGH TO AUG 2020"]
[null,19,null,"SHRINKAGE COST ADJUSTMENT","SHRAt",null,null,null,-953632.87,-2808171.22,-3709866.96,-2426198.56,-1951682.17,-1249150.43,null,null,null,-953632.87,-2808171.22,-3709866.96,-2426198.56,-1951682.17,-1249150.43,null,0,0,0,0,0,0,0,0,null,"GAS PRICES UPDATED THROUGH TO AUG 2020"]
[null,20,null,"SHRINKAGE REVENUE ADJUSTMENT","SHRt",null,0,0,-397066.78,-2402223.87,-3413863.79,-2174536.62,-1535780.88,-487512.25999999989,null,0,0,-397066.78,-2402223.87,-3413863.79,-2174536.62,-1535780.88,-487512.25999999989,null,0,0,0,0,0,0,0,0]
[]
[null,21,null,"BROAD MEASURE OF CUSTOMER SATISFACTION REVENUE ADJUSTMENT","BMt",null,null,null,507101.28,100074.61,1149572.71,1110066.1399999999,1112203.08,1453668.32,null,null,null,507101.28,100074.61,1149572.71,1110066.1399999999,1112203.08,1453668.32,null,0,0,0,0,0,0,0,0]
[null,22,null,"ENVIRONMENTAL EMISSIONS INCENTIVE REVENUE ADJUSTMENT","EEIt",null,null,null,1752038.52,1785841.02,1681221.11,1515607.6,2179784.4,3234266.85,null,null,null,1752038.52,1785841.02,1681221.11,1515607.6,2179784.4,3234266.85,null,0,0,0,0,0,0,0,0]
[null,23,null,"DISCRETIONARY REWARD SCHEME REVENUE ADJUSTMENT","DRSt",null,190894.73,174734.33,null,114430.45,null,null,119631.84,null,null,190894.73,174734.33,null,114430.45,null,null,119631.84,null,null,0,0,0,0,0,0,0,0,null,"NO FURTHER CHANGE ANTICIPATED"]
[null,24,null,"NETWORK INNOVATION ALLOWANCE REVENUE ADJUSTMENT","NIAt",null,530981.15,1433046.76,1788245.25,1428750,1370736.68,907448.55,1133705.95,1695113.45,null,530981.15,1433046.76,1788245.25,1428750,1370736.68,907448.55,1133705.95,1695113.45,null,0,0,0,0,0,0,0,0]
[null,25,null,"CORRECTION TERM REVENUE ADJUSTMENT","-Kt",null,-3564488.71,0,-12376483.9,-1311344.76,-3412387.35,-4299306.9800000004,-1333607.02,-2374584.2999999998,null,-3564488.71,0,-12376483.9,-1311344.76,-3412387.35,-4299306.9800000004,-1333607.02,-2374584.2999999998,null,0,0,0,0,0,0,0,0]
[]
[null,26,null,"MAXIMUM ALLOWED REVENUE","ARt",null,407859250.75999999,415578989.35999995,442530288.00999999,432245171.76999998,417516075.31,432439203.43000007,465679494.79999995,460995818.49999994,null,407859250.75999999,415578989.35999995,442530288.00999999,432245171.76999998,417516075.31,432439203.43000007,466413141.11999995,460995818.49999994,null,0,0,0,0,0,0,-733646.31999999285,0]
[]
[null,27,null,"COLLECTABLE REVENUE","Rt",null,419755140.70999998,416839413,445815440.5,436390186.17000002,418797684.60000002,434713037.68000001,468199324.82999998,459321657.35000002,null,419755140.70999998,416839413,445815440.5,436390186.17000002,418797684.60000002,434713037.68000001,468130992.91000003,459476161.08999997,null,0,0,0,0,0,0,68331.919999957085,-154503.73999994993,null,"REFLECTS ACTUAL COLLECTED REVENUE TO JULY 2020"]
[null,28,null,"UNDER / OVER RECOVERY CARRIED FORWARDS","ARt - Rt",null,11895889.949999988,1260423.6400000453,3285152.4900000095,4145014.4000000358,1281609.2900000215,2273834.2499999404,2519830.030000031,-1674161.1499999166,null,11895889.949999988,1260423.6400000453,3285152.4900000095,4145014.4000000358,1281609.2900000215,2273834.2499999404,1717851.7900000811,-1519657.4099999666,null,0,0,0,0,0,0,801978.23999994993,-154503.73999994993]
[]
[null,29,null,"YEAR ON YEAR MOVEMENT IN ALLOWED REVENUE",null,null,null,1.8927457414819271E-2,6.4852409144902978E-2,-2.3241609712751687E-2,-3.2317123226151323E-2,3.6963137334040885E-2,7.7975436592610858E-2,-1.0057725006791585E-2,null,null,1.8927457414819271E-2,6.4852409144902978E-2,-2.3241609712751687E-2,-3.2317123226151323E-2,3.6963137334040885E-2,7.7975436592610858E-2,-1.1614858464303435E-2,null,null,0,0,0,0,0,0,1.5571334575118501E-3]
[null,30,null,"ADJUSTMENT FOR PRIOR YEAR OVER / UNDER RECOVERY",null,null,null,-2.9166654741392604E-2,-3.0329339843217849E-3,-7.4235652993897986E-3,-9.5894984391071934E-3,5.7890090401437092E-5,-2.4144890830119377E-3,-5.4110822102704948E-3,null,null,-2.9166654741392604E-2,-3.0329339843217849E-3,-7.4235652993897986E-3,-9.5894984391071934E-3,5.7890090401437092E-5,-2.4144890830119377E-3,-3.6831118991951985E-3,null,null,0,0,0,0,0,0,-1.7279703110752963E-3]
[null,31,null,"IMPACT OF CHANGE IN ANNUAL LOAD FACTORS",null,null,null,-8.6512922015447404E-4,-1.0412868332099687E-3,-1.2446626297904573E-2,-1.0473652744467876E-2,-5.2997493013011701E-3,1.5697033256469095E-2,1.5599999999999999E-2,null,null,-8.6512922015447404E-4,-1.0412868332099687E-3,-1.2446626297904573E-2,-1.0473652744467876E-2,-5.2997493013011701E-3,1.5697033256469095E-2,1.5599999999999999E-2,null,null,0,0,0,0,0,0,0]
[null,32,null,"YEAR ON YEAR MOVEMENT IN AGGREGATE DEMAND",null,null,null,1.2104326546727807E-2,1.7111606669146157E-2,1.8918195187250637E-2,4.9725845862005624E-3,-7.4618163446352401E-3,-1.5162398059227658E-2,-1.7811091711895464E-3,null,null,1.2104326546727807E-2,1.7111606669146157E-2,1.8918195187250637E-2,4.9725845862005624E-3,-7.4618163446352401E-3,-1.5162398059227658E-2,-1.9519460247529926E-3,null,null,0,0,0,0,0,0,1.7083685356344622E-4,null,"BASED ON JAN 2020 SUPPLY POINT DATA PROVIDED BY XOSERVE"]
[null,33,null,"TOTAL DISTRIBUTION CHARGES ARITHMETICAL PRICE CHANGE",null,null,null,1.0000000000000009E-3,7.7889794996517381E-2,-2.4193606122795419E-2,-4.7407689823525834E-2,2.4259461778505909E-2,7.6095582706840359E-2,-1.6499163882516266E-3,null,null,1.0000000000000009E-3,7.7889794996517381E-2,-2.4193606122795419E-2,-4.7407689823525834E-2,2.4259461778505909E-2,7.6095582706840359E-2,-1.6499163882516266E-3,null,null,0,0,0,0,0,0,0]
[]
[null,null,null,"TABLE 2: DOMESTIC CUSTOMER BILL IMPACT (EXCL ECN CHARGES)"]
[]
[null,34,null,"AVERAGE AQ PER DOMESTIC CUSTOMER (Kwh)",null,null,14516.37233294151,14393.872206300652,14164.5209192282,13902.905319735884,13938.992591900907,14040.382700655582,14224.049160081589,14189.865543573089,null,14516.37233294151,14393.872206300652,14164.5209192282,13902.905319735884,13938.992591900907,14040.382700655582,14224.049160081589,14189.865543573089,null,0,0,0,0,0,0,0,0,null,"BASED ON JAN 2020 DEMAND DATA PROVIDED BY XOSERVE"]
[null,35,null,"TOTAL ANNUAL CHARGE (EXCL. ECN) (NOMINAL)",null,null,142.83000000000001,141.55000000000001,151.12,146.84,141.94,147.74,160.27000000000001,160.52000000000001,null,142.83000000000001,141.55000000000001,151.12,146.84,141.94,147.74,160.27000000000001,160.52000000000001,null,0,0,0,0,0,0,0,0]
[null,36,null,"TOTAL ANNUAL CHARGE (EXCL. ECN) (19/20 PRICES)",null,null,164.90604839777541,160.28699188311688,169.29886419118591,161.05345073744451,150.06339628360965,151.56419625261051,160.27000000000001,158.21771606941658,null,164.90604839777541,160.28699188311688,169.29886419118591,161.05345073744451,150.06339628360965,151.56419625261051,160.27000000000001,157.85900064895122,null,0,0,0,0,0,0,0,0.35871542046535865,null,"BASED ON RPI DATA UPTO APRIL 2020"]
[null,37,null,"% MOVEMENT IN DOMESTIC CUSTOMER BILL (19/20 PRICES)",null,null,null,-2.8010231034805599E-2,5.6223354136189618E-2,-4.8703300480681389E-2,-6.8238553123281198E-2,1.0001106240221658E-2,5.7439711769919688E-2,-1.2805165848776667E-2,null,null,-2.8010231034805599E-2,5.6223354136189618E-2,-4.8703300480681389E-2,-6.8238553123281198E-2,1.0001106240221658E-2,5.7439711769919688E-2,-1.5043360273593209E-2,null,0,0,0,0,0,0,0,2.238194424816542E-3]
[]
[null,null,null,"TABLE 3: ECN CHARGE ELEMENTS (NTS EXIT CAPACITY ONLY)"]
[]
[null,38,null,"INITIAL ALLOWED REVENUE (2009/10 PRICES)","AEXt",null,17200000,17100000,17100000,17100000,17100000,17100000,17100000,17100000,null,17200000,17100000,17100000,17100000,17100000,17100000,17100000,17100000,null,0,0,0,0,0,0,0,0]
[null,39,null,"INFLATED BASE REVENEUE (NOMINAL)","AEXt",null,20003880.93,20606933.23,20975763.239999998,21079739.210000001,21732775.399999999,22469814.75,23231894.210000001,23595256.289999999,null,20003880.93,20606933.23,20975763.239999998,21079739.210000001,21732775.399999999,22469814.75,23231894.210000001,23595256.289999999,null,0,0,0,0,0,0,0,0]
[null,40,null,"ECN COST TRUE UP",null,null,0,0,-1637965.33,-711534.26,-2012120.17,-2663820.0699999998,-2549104.5099999998,-7504069.7199999997,null,0,0,-1637965.33,-711534.26,-2012120.17,-2663820.0699999998,-2549104.5099999998,-7504069.7199999997,null,0,0,0,0,0,0,0,0]
[null,41,null,"CORRECTION FACTOR (ECN)",null,null,-919.71,0,51962.663556000625,-432016.13296799798,-96486.533320617178,-163928.5207497261,40989.981378412886,-175864.67433842935,null,-919.71,0,51962.663556000625,-432016.13296799798,-96486.533320617178,-163928.5207497261,40989.981378412886,-175864.67433842935,null,0,0,0,0,0,0,0,0]
[null,42,null,"TOTAL ALLOWED REVENUE (ECN)",null,null,20002961.219999999,20606933.23,19389760.57,19936188.82,19624168.699999999,19642066.16,20723779.68,15915321.9,null,20002961.219999999,20606933.23,19389760.57,19936188.82,19624168.699999999,19642066.16,20723779.68,15915321.9,null,0,0,0,0,0,0,0,0]
[]
[null,43,null,"COLLECTABLE REVENUE (ECN)",null,null,19953016.329999998,21022173.649999999,19482649.489999998,20094234.309999999,19584776.93,19810469.16,20731727.82,15754814.810000001,null,19953016.329999998,21022173.649999999,19482649.489999998,20094234.309999999,19584776.93,19810469.16,20732864.460000001,15743636.66,null,0,0,0,0,0,0,-1136.640000000596,11178.150000000373]
[null,44,null,"UNDER / OVER RECOVERY CARRIED FORWARDS (ECN)",null,null,-49944.890000000596,415240.41999999806,92888.919999998063,158045.48999999836,-39391.769999999553,168403,7948.140000000596,-160507.08999999985,null,-49944.890000000596,415240.41999999806,92888.919999998063,158045.48999999836,-39391.769999999553,168403,9084.7800000011921,-171685.24000000022,null,0,0,0,0,0,0,-1136.640000000596,11178.150000000373]
[]
[null,45,null,"YEAR ON YEAR MOVEMENT IN ALLOWED REVENUE",null,null,null,3.0194129926929048E-2,-5.9066171875978846E-2,2.8181278877957849E-2,-1.5650941251468375E-2,9.1201111617023045E-4,5.507126954917041E-2,-0.23202610017324787,null,null,3.0194129926929048E-2,-5.9066171875978846E-2,2.8181278877957849E-2,-1.5650941251468375E-2,9.1201111617023045E-4,5.507126954917041E-2,-0.23202610017324787,null,null,0,0,0,0,0,0,0]
[null,46,null,"ADJUSTMENT FOR PRIOR YEAR OVER / UNDER RECOVERY",null,null,null,2.4968748102187541E-3,-2.0150519990790403E-2,-4.7906171747018151E-3,-7.92756787302531E-3,-1.5902620119648838E-3,-8.3827403216525896E-3,-3.8352752841081141E-4,null,null,2.4968748102187541E-3,-2.0150519990790403E-2,-4.7906171747018151E-3,-7.92756787302531E-3,-1.5902620119648838E-3,-8.3827403216525896E-3,-4.383746662182809E-4,null,null,0,0,0,0,0,0,5.4847137807469495E-5]
[null,47,null,"IMPACT OF CHANGE IN ANNUAL LOAD FACTORS",null,null,null,-8.6512922015447404E-4,-1.0412868332099687E-3,-1.2446626297904573E-2,-1.0473652744467876E-2,-5.2725815156402511E-3,1.5697033256469095E-2,1.5599999999999999E-2,null,null,-8.6512922015447404E-4,-1.0412868332099687E-3,-1.2446626297904573E-2,-1.0473652744467876E-2,-5.2725815156402511E-3,1.5697033256469095E-2,1.5599999999999999E-2,null,null,0,0,0,0,0,0,0]
[null,48,null,"YEAR ON YEAR MOVEMENT IN AGGREGATE DEMAND",null,null,null,9.1741244830066751E-3,3.6611880587823636E-2,2.6844968314520802E-2,-3.1049533257688569E-3,2.2514801138059388E-3,-6.3687455117281133E-3,-8.8498225095314798E-3,null,null,9.1741244830066751E-3,3.6611880587823636E-2,2.6844968314520802E-2,-3.1049533257688569E-3,2.2514801138059388E-3,-6.3687455117281133E-3,-8.7949753717239953E-3,null,null,0,0,0,0,0,0,-5.4847137807484403E-5]
[null,49,null,"ECN CHARGES ARITHMETICAL PRICE CHANGE",null,null,null,4.1000000000000002E-2,-4.3646098112155585E-2,3.7789003719872261E-2,-3.7157115194730417E-2,-3.6993522976289661E-3,5.6016816972258798E-2,-0.22565945021119016,null,null,4.1000000000000002E-2,-4.3646098112155585E-2,3.7789003719872261E-2,-3.7157115194730417E-2,-3.6993522976289661E-3,5.6016816972258798E-2,-0.22565945021119016,null,null,0,0,0,0,0,0,0]
[]
[null,null,null,"TABLE 4: LDZ & CUSTOMER CHARGE ELEMENTS"]
[]
[null,50,null,"DN ALLOWED REVENUE LESS ECN REVENUE",null,null,387856289.53999996,394972056.12999994,423140527.44,412308982.94999999,397891906.61000001,412797137.27000004,444955715.11999995,445080496.59999996,null,387856289.53999996,394972056.12999994,423140527.44,412308982.94999999,397891906.61000001,412797137.27000004,445689361.43999994,445080496.59999996,null,0,0,0,0,0,0,-733646.31999999285,0,null,"IMPACTED BY NETT THEFT OF GAS VALUES"]
[null,51,null,"DN COLLECTABLE REVENUE LESS ECN REVENUE",null,null,399802124.38,395817239.35000002,426332791.00999999,416295951.86000001,399212907.67000002,414902568.51999998,447467597.00999999,443566842.54000002,null,399802124.38,395817239.35000002,426332791.00999999,416295951.86000001,399212907.67000002,414902568.51999998,447398128.45000005,443732524.42999995,null,0,0,0,0,0,0,69468.55999994278,-165681.88999992609,null,"BASED ON ACTUAL COLLECTED REVENUE POSTIONS TO JULY 2020"]
[null,52,null,"UNDER / OVER RECOVERY CARRIED FORWARDS (LDZ & CUSTOMER)",null,null,11945834.840000033,845183.22000008821,3192263.5699999928,3986968.9100000262,1321001.0600000024,2105431.2499999404,2511881.8900000453,-1513654.0599999428,null,11945834.840000033,845183.22000008821,3192263.5699999928,3986968.9100000262,1321001.0600000024,2105431.2499999404,1708767.0100001097,-1347972.1700000167,null,0,0,0,0,0,0,803114.87999993563,-165681.88999992609]
[]
[null,53,null,"YEAR ON YEAR MOVEMENT IN ALLOWED REVENUE",null,null,null,1.8346399895794674E-2,7.1317630887610894E-2,-2.5597984091788262E-2,-3.3122975546851396E-2,3.8737801041121012E-2,7.9062313738606171E-2,2.8043572823044371E-4,null,null,1.8346399895794674E-2,7.1317630887610894E-2,-2.5597984091788262E-2,-3.3122975546851396E-2,3.8737801041121012E-2,7.9062313738606171E-2,-1.3661193034376629E-3,null,null,0,0,0,0,0,0,1.6465550316681066E-3]
[null,54,null,"ADJUSTMENT FOR PRIOR YEAR OVER / UNDER RECOVERY",null,null,null,-3.0799641934820418E-2,-2.139855736330641E-3,-7.5442160771344354E-3,-9.6698570122677133E-3,1.3902252721189069E-4,-2.131276169810068E-3,-5.6452401995165224E-3,null,null,-3.0799641934820418E-2,-2.139855736330641E-3,-7.5442160771344354E-3,-9.6698570122677133E-3,1.3902252721189069E-4,-2.131276169810068E-3,-3.8339865337578831E-3,null,null,0,0,0,0,0,0,-1.8112536657586393E-3]
[null,55,null,"IMPACT OF CHANGE IN ANNUAL LOAD FACTORS",null,null,null,-8.6512922015447404E-4,-1.0412868332099687E-3,-1.2446626297904573E-2,-1.0473652744467876E-2,-5.2997493013011701E-3,1.5697033256469095E-2,1.5599999999999999E-2,null,null,-8.6512922015447404E-4,-1.0412868332099687E-3,-1.2446626297904573E-2,-1.0473652744467876E-2,-5.2997493013011701E-3,1.5697033256469095E-2,1.5599999999999999E-2,null,null,0,0,0,0,0,0,0]
[null,56,null,"YEAR ON YEAR MOVEMENT IN AGGREGATE DEMAND",null,null,null,1.2318371259180217E-2,1.6055984704188675E-2,1.8597796159546598E-2,5.3616298478467925E-3,-7.9523210545832251E-3,-1.5586019197315226E-2,-1.5064235933122515E-3,null,null,1.2318371259180217E-2,1.6055984704188675E-2,1.8597796159546598E-2,5.3616298478467925E-3,-7.9523210545832251E-3,-1.5586019197315226E-2,-1.6711222274027847E-3,null,null,0,0,0,0,0,0,1.6469863409053313E-4,null,"BASED ON JAN 2020 SUPPLY POINT DATA PROVIDED BY XOSERVE"]
[null,57,null,"LDZ & CUSTOMER CHARGES ARITHMETICAL PRICE CHANGE",null,null,null,-1.0000000000000009E-3,8.4192473022258962E-2,-2.6991030307280672E-2,-4.7904855455740192E-2,2.5624753212448503E-2,7.704205162794997E-2,8.7287719354016691E-3,null,null,-1.0000000000000009E-3,8.4192473022258962E-2,-2.6991030307280672E-2,-4.7904855455740192E-2,2.5624753212448503E-2,7.704205162794997E-2,8.7287719354016691E-3,null,null,0,0,0,0,0,0,0]
[]
[null,null,null,"TABLE 5: PCFM ADJUSTMENTS"]
[]
[null,null,null,"DESCRIPTION","PCFM TERM",null,"FREQENCY","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21",null,"FREQENCY","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21",null,"FREQENCY","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21"]
[]
[null,58,null,"COST OF DEBT","CDE",null,"ANNUAL",2.7199999999999998E-2,2.5499999999999998E-2,2.3800000000000002E-2,2.2200000000000001E-2,1.9100000000000002E-2,1.5800000000000002E-2,1.09E-2,null,"ANNUAL",2.7199999999999998E-2,2.5499999999999998E-2,2.3800000000000002E-2,2.2200000000000001E-2,1.9100000000000002E-2,1.5800000000000002E-2,1.09E-2,null,"ANNUAL",0,0,0,0,0,0,0]
[null,59,null,"CORPORATION TAX RATE","CT",null,"ANNUAL",0.21,0.2,0.2,0.19,0.19,0.19,0.19,null,"ANNUAL",0.21,0.2,0.2,0.19,0.19,0.19,0.19,null,"ANNUAL",0,0,0,0,0,0,0]
[]
[null,60,null,"COST OF DEBT ADJUSTMENT","CDE £ IMPACT",null,"ANNUAL",-2059267.7105543348,-7450000,-5947528.4555493752,-7837261.7537222253,-9889006.0731719695,-17392110.168269232,-21891080.609186765,null,"ANNUAL",-2059267.7105543348,-7450000,-5947528.4555493752,-7837261.7537222253,-9889006.0731719695,-17392110.168269232,-21891080.609186765,null,"ANNUAL",0,0,0,0,0,0,0]
[null,61,null,"TAX TRIGGER EVENT","TTE",null,"AT ANY TIME",0,-700000,-495102.60294069868,-1963628.3711129751,-1935419.5414603055,-1744256.6882012899,-2251592.9356662659,null,"AT ANY TIME",0,-700000,-495102.60294069868,-1963628.3711129751,-1935419.5414603055,-1744256.6882012899,-2251592.9356662659,null,"AT ANY TIME",0,0,0,0,0,0,0]
[null,62,null,"TAX LIABILITY - GEARING/INTEREST COSTS","TGIE",null,"AT ANY TIME",0,0,0,0,0,0,0,null,"AT ANY TIME",0,0,0,0,0,0,0,null,"AT ANY TIME",0,0,0,0,0,0,0]
[null,63,null,"PENSION SCHEME ESTABLISHED DEFICIT","EDE",null,"3 YEARLY REVIEW",0,-600000,-632582.28705490183,-632582.28705495864,3131473.8647022862,3131473.8647022862,3131473.8647022294,null,"3 YEARLY REVIEW",0,-600000,-632582.28705490183,-632582.28705495864,3131473.8647022862,3131473.8647022862,3131473.8647022294,null,"3 YEARLY REVIEW",0,0,0,0,0,0,0,null,"NO FURTHER CHANGE EXPECTED IN RIIO-GD1"]
[null,64,null,"PENSION SCHEME ADMINISTRATION & PPF LEVY","APFE",null,"3 YEARLY REVIEW",0,0,0,0,257624.91766795394,257624.91766801078,257624.91766795394,null,"3 YEARLY REVIEW",0,0,0,0,257624.91766795394,257624.91766801078,257624.91766795394,null,"3 YEARLY REVIEW",0,0,0,0,0,0,0,null,"NO FURTHER CHANGE EXPECTED IN RIIO-GD1"]
[null,65,null,"SPECIFIED FINANCIAL ADJUSTMENTS",null,null,null,-2059267.7105543348,-8750000,-7075213.3455449762,-10433472.411890158,-8435326.8322620355,-15747268.074100224,-20753574.762482848,null,null,-2059267.7105543348,-8750000,-7075213.3455449762,-10433472.411890158,-8435326.8322620355,-15747268.074100224,-20753574.762482848,null,null,0,0,0,0,0,0,0]
[null,66,null,"LEGACY CAPEX RAV ADJUSTMENT","LRAV",null,"ONE OFF",-581934.13519660453,-1300000,-461232.89796594233,-486469.48949033231,-472128.98470519349,-458009.10634545743,-444113.10135097895,null,"ONE OFF",-581934.13519660453,-1300000,-461232.89796594233,-486469.48949033231,-472128.98470519349,-458009.10634545743,-444113.10135097895,null,"ONE OFF",0,0,0,0,0,0,0,null,"NO CHANGE EXPECTED IN RIIO-GD1"]
[null,67,null,"LEGACY ALLOWED REVENUE ADJUSTMENT","LAR",null,"ONE OFF",-158798.150232883,0,-91868.457056932588,-88972.128547084139,-93589.334905175288,-98423.165045289803,-103482.87375148857,null,"ONE OFF",-158798.150232883,0,-91868.457056932588,-88972.128547084139,-93589.334905175288,-98423.165045289803,-103482.87375148857,null,"ONE OFF",0,0,0,0,0,0,0,null,"NO CHANGE EXPECTED IN RIIO-GD1"]
[null,68,null,"LEGACY IFI CAP ADJUSTMENT","IFIAR",null,"ONE OFF",0,0,0,0,0,0,0,null,"ONE OFF",0,0,0,0,0,0,0,null,"ONE OFF",0,0,0,0,0,0,0,null,"NO CHANGE EXPECTED IN RIIO-GD1"]
[null,69,null,"LEGACY STREETWORKS COST ADJUSTMENT","IAEAR",null,"ONE OFF",0,0,0,0,0,0,0,null,"ONE OFF",0,0,0,0,0,0,0,null,"ONE OFF",0,0,0,0,0,0,0,null,"NO CHANGE EXPECTED IN RIIO-GD1"]
[null,70,null,"OVERALL LEGACY ADJUSTMENTS",null,null,null,-740732.28542948747,-1300000,-553101.35502287489,-575441.61803741648,-565718.31961036881,-556432.27139074728,-547595.97510246746,null,null,-740732.28542948747,-1300000,-553101.35502287489,-575441.61803741648,-565718.31961036881,-556432.27139074728,-547595.97510246746,null,null,0,0,0,0,0,0,0,null,"FIXED FOR RIIO GD-1"]
[]
[null,71,null,"TOTEX INCENTIVE MECHANISM",null,null,null,0,5750000,2142585.8773731925,-13224120.193204671,-14369621.647220392,-5539393.8704340803,-5639898.4234258654,null,null,0,5750000,2142585.8773731925,-13224120.193204671,-14369621.647220392,-5539393.8704340803,-5639898.4234258654,null,null,0,0,0,0,0,0,0,null,"ALIGNED TO 2018/19 RRP ACTUALS AND FORECAST"]
[]
[null,72,null,"ENHANCED PHYSICAL SITE SECURITY (CNI)","IAEEPS",null,"2 RE-OPENERS",0,0,1387968.4656939521,6429703.5627187714,3055952.0558502413,-535897.40984841681,-674160.12143837637,null,"2 RE-OPENERS",0,0,1387968.4656939521,6429703.5627187714,3055952.0558502413,-535897.40984841681,-674160.12143837637,null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"NO FURTHER CHANGE EXPECTED"]
[null,73,null,"SPECIFIED STREETWORKS","IAESW",null,"2 RE-OPENERS",0,0,3479632.2985475878,493567.35882298608,544799.79124687356,541082.6935097361,543449.06503672514,null,"2 RE-OPENERS",0,0,3479632.2985475878,493567.35882298608,544799.79124687356,541082.6935097361,543449.06503672514,null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"NO FURTHER CHANGE EXPECTED"]
[null,74,null,"CHANGE TO CONNECTION CHARGING BOUNDARY","IAECCB",null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"NO IMPACT IN RIIO GD-1"]
[null,75,null,"SMART METERING ROLL-OUT","IAESM",null,"RE-OPENER > REV DRIVER",0,0,0,0,0,0,0,null,"RE-OPENER > REV DRIVER",0,0,0,0,0,0,0,null,"RE-OPENER > REV DRIVER",0,0,0,0,0,0,0,null,"UPDATED FOR LATEST COST FORECAST IN 2018/19 RRP"]
[null,76,null,"LARGE LOAD CONNECTIONS","IAELLC",null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"NO IMPACT IN RIIO GD-1"]
[null,77,null,"FUEL POOR NETWORK EXTENSIONS","IAEFP",null,"1 RE-OPENER (FLEXIBLE)",0,0,-7.5495165674510645E-9,0,0,0,0,null,"1 RE-OPENER (FLEXIBLE)",0,0,-7.5495165674510645E-9,0,0,0,0,null,"1 RE-OPENER (FLEXIBLE)",0,0,0,0,0,0,0,null,"NO FURTHER CHANGE EXPECTED"]
[null,78,null,"AGENCY COSTS (FGO)","IAECA",null,"1 RE-OPENER (FLEXIBLE)",0,0,0,-889968.39815604291,-1652004.6453061355,-2011531.0566511084,-2239677.5452909311,null,"1 RE-OPENER (FLEXIBLE)",0,0,0,-889968.39815604291,-1652004.6453061355,-2011531.0566511084,-2239677.5452909311,null,"1 RE-OPENER (FLEXIBLE)",0,0,0,0,0,0,0,null,"NO FURTHER CHANGE EXPECTED"]
[null,79,null,"MAINS & SERVICES (REPEX T2)","RE",null,"ANNUAL",0,2600000,-1141944.4459155072,-1004661.1348050761,-978641.69226807007,-1270294.8694475254,-1153355.7161823618,null,"ANNUAL",0,2600000,-1141944.4459155072,-1004661.1348050761,-978641.69226807007,-1270294.8694475254,-1153355.7161823618,null,"ANNUAL",0,0,0,0,0,0,0,null,"UPDATED ANNUALLY. REFLECTS 2018/19 RRP"]
[null,80,null,"INNOVATION ROLL-OUT MECHANISM","IRM",null,"ANNUAL",0,0,0,0,0,0,0,null,"ANNUAL",0,0,0,0,0,0,0,null,"ANNUAL",0,0,0,0,0,0,0,null,"NO IMPACT IN RIIO GD-1"]
[null,81,null,"NTS EXIT CAPACITY COST ALLOWANCE","AEX",null,"ANNUAL",0,0,0,0,0,0,0,null,"ANNUAL",0,0,0,0,0,0,0,null,"ANNUAL",0,0,0,0,0,0,0,null,"NO IMPACT IN RIIO GD-1"]
[null,82,null,"SHRINKAGE COST ALLOWANCE","ALSC",null,"ANNUAL",0,0,-2739927.4935017852,-1495607.1618018996,-1499438.7062556597,-1480265.1416376308,-1435186.5244661896,null,"ANNUAL",0,0,-2739927.4935017852,-1495607.1618018996,-1499438.7062556597,-1480265.1416376308,-1435186.5244661896,null,"ANNUAL",0,0,0,0,0,0,0,null,"NO FURTHER CHANGE EXPECTED"]
[null,83,null,"UNCERTAIN COSTS",null,null,null,0,2600000,985728.82482424006,3533034.2267787391,-529333.19673275063,-4756905.7840749454,-4958930.8423411343,null,null,0,2600000,985728.82482424006,3533034.2267787391,-529333.19673275063,-4756905.7840749454,-4958930.8423411343,null,null,0,0,0,0,0,0,0]
[]
[null,84,null,"TOTAL POTENTIAL IMPACT OF REVENUE ADJUSTMENTS SHOWN IN TABLE 5",null,null,null,-2799999.9959838223,-1700000,-4499999.9983704183,-20699999.996353507,-23899999.995825548,-26600000,-31900000.003352314,null,null,-2799999.9959838223,-1700000,-4499999.9983704183,-20699999.996353507,-23899999.995825548,-26600000,-31900000.003352314,null,0,0,0,0,0,0,0,0]
[null,85,null,"TOTAL VALUE INCLUDED IN TABLE 1 IN THIS FORECAST",null,null,null,-2800000,-1700000,-4500000,-20700000,-23900000,-26600000,-31900000,null,null,-2800000,-1700000,-4500000,-20700000,-23900000,-26600000,-31900000,null,0,0,0,0,0,0,0,0]
[]
[null,null,null,"TABLE 6: RISKS AND SENSITIVITIES",null,null,"2013/14","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21",null,"2013/14","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21",null,"2013/14","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21"]
[]
[null,86,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]

{"sheet":"NW MOD0186 RIIO-GD1","index":4,"n_rows":124,"n_cols":34,"rows_kept":124,"cut":false,"hidden":false,"merged":[[52,3,52,4],[75,3,75,4],[63,3,63,4],[64,3,64,4],[66,3,66,4],[68,3,68,4],[70,3,70,4],[72,3,72,4],[74,3,74,4],[69,3,69,4],[53,3,53,4],[55,3,55,4],[61,3,61,4],[67,3,67,4],[82,3,82,4],[84,3,84,4],[76,3,76,4],[78,3,78,4],[80,3,80,4],[79,3,79,4],[81,3,81,4],[0,24,0,31],[4,3,4,4],[0,3,0,4],[0,6,0,13],[0,15,0,22],[42,3,42,4],[44,3,44,4],[46,3,46,4],[48,3,48,4],[51,3,51,4],[43,3,43,4],[45,3,45,4],[50,3,50,4],[121,3,121,4],[123,3,123,4],[96,3,96,4],[101,3,101,4],[103,3,103,4],[116,3,116,4],[118,3,118,4],[119,3,119,4]]}
[null,null,null,"CADENT GAS LTD\nNORTH WEST DISTRIBUTION NETWORK",null,null,"CURRENT (SEPT-2020)",null,null,null,null,null,null,null,null,"PREVIOUS (JUN- 2020)",null,null,null,null,null,null,null,null,"MOVEMENT"]
[]
[null,null,null,"DESCRIPTION","LICENCE \nTERM",null,"2013/14","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21",null,"2013/14","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21",null,"2013/14","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21"]
[]
[null,"ROW REF",null,"TABLE 1: TOTAL CHARGE ELEMENTS (LDZ + CUSTOMER + ECN)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTES (RIIO GD-1)"]
[]
[null,1,null,"FORECAST RPI FACTOR","RPIFt",null,1.1630163330372321,1.2050838144310987,1.2266528212575318,1.2327332873088215,1.270922538158505,1.314024254388422,1.358590304925267,1.3798395491512827,null,1.1630163330372321,1.2050838144310987,1.2266528212575318,1.2327332873088215,1.270922538158505,1.314024254388422,1.358590304925267,1.3798395491512827,null,0,0,0,0,0,0,0,0,null,"BASED ON AUG-2020 HMT 'FORECASTS FOR THE UK ECONOMY'. "]
[null,2,null,"ASSUMED ANNUAL INFLATION FOR PRICE SETTING","GRPIFt",null,2.6500000000000003E-2,3.075E-2,2.6000000000000002E-2,2.325E-2,3.4000000000000002E-2,3.3250000000000002E-2,3.175E-2,2.4750000000000001E-2,null,2.6500000000000003E-2,3.075E-2,2.6000000000000002E-2,2.325E-2,3.4000000000000002E-2,3.3250000000000002E-2,3.175E-2,2.4750000000000001E-2,null,0,0,0,0,0,0,0,0,null,"BASED ON AUG-2020 HMT 'FORECASTS FOR THE UK ECONOMY'. "]
[null,3,null,"ACTUAL / FORECAST ANNUAL INFLATION",null,null,2.8847791287762714E-2,1.9597457627118731E-2,1.0779220779220777E-2,2.1424900424001248E-2,3.7422560457875953E-2,3.0555639758707454E-2,2.5884636879724532E-2,1.4551366229893725E-2,null,2.8847791287762714E-2,1.9597457627118731E-2,1.0779220779220777E-2,2.1424900424001248E-2,3.7422560457875953E-2,3.0555639758707454E-2,2.5884636879724532E-2,1.6856811078934664E-2,null,0,0,0,0,0,0,0,-2.3054448490409385E-3,null,"BASED ON RPI DATA UP TO JULY 2020"]
[null,4,null,"DIFFERENCE (DRIVES t+2 RPI TRUE UP)",null,null,2.3477912877627113E-3,-1.1152542372881269E-2,-1.5220779220779225E-2,-1.8250995759987523E-3,3.4225604578759505E-3,-2.6943602412925483E-3,-5.8653631202754686E-3,-1.0198633770106276E-2,null,2.3477912877627113E-3,-1.1152542372881269E-2,-1.5220779220779225E-2,-1.8250995759987523E-3,3.4225604578759505E-3,-2.6943602412925483E-3,-5.8653631202754686E-3,-7.8931889210653375E-3,null,0,0,0,0,0,0,0,-2.3054448490409385E-3]
[]
[null,5,null,"OPENING BASE REVENUE ALLOWANCE (2009/10 PRICES)","PUt",null,381700000,364700000,367600000,361400000,363100000,361600000,361300000,360600000,null,381700000,364700000,367600000,361400000,363100000,361600000,361300000,360600000,null,0,0,0,0,0,0,0,0,null,"FIXED PER LICENCE"]
[null,6,null,"PRICE CONTROL FINANCIAL MODEL ITERATION ADJUSTMENT (2009/10 PRICES)","MODt",null,null,-2900000,-8600000,4100000,-15400000,-17000000,-25500000,-28800000,null,null,-2900000,-8600000,4100000,-15400000,-17000000,-25500000,-28800000,null,0,0,0,0,0,0,0,0]
[null,7,null,"RPI TRUE UP (2009/10 PRICES)","TRUt",null,null,null,1305277.32,-5113581.49,-7846940.9000000004,-1454147.54,918863.47,-280213.51,null,null,null,1305277.32,-5113581.49,-7846940.9000000004,-1454147.54,918863.47,-280213.51,null,0,0,0,0,0,0,0,0]
[null,8,null,"UPLIFT TO NOMINAL PRICES USING RPIFt",null,null,62223334.319999993,74199324.060000002,81664207.620000005,83873915.879999995,92073853.370000005,107756120.47000003,120744119.92999995,125924326.24000001,null,62223334.319999993,74199324.060000002,81664207.620000005,83873915.879999995,92073853.370000005,107756120.47000003,120744119.92999995,125924326.24000001,null,0,0,0,0,0,0,0,0]
[null,9,null,"BASE REVENUE (NOMINAL)","BRt",null,443923334.31999999,435999324.06,441969484.94,444260334.38999999,431926912.47000003,450901972.93000001,457462983.39999998,457444112.73000002,null,443923334.31999999,435999324.06,441969484.94,444260334.38999999,431926912.47000003,450901972.93000001,457462983.39999998,457444112.73000002,null,0,0,0,0,0,0,0,0]
[]
[null,10,null,"BUSINESS RATES ADJUSTMENT","RBt",null,null,null,817764.48,950214.61,1416964.3,1010257.22,15918192.699999999,15964845.109999999,null,null,null,817764.48,950214.61,1416964.3,1010257.22,15918192.699999999,15964845.109999999,null,0,0,0,0,0,0,0,0]
[null,11,null,"LICENCE FEES ADJUSTMENT","LFt",null,null,null,18120.580000000002,33263.769999999997,16542.16,-318966.19,75162.210000000006,92554.77,null,null,null,18120.580000000002,33263.769999999997,16542.16,-318966.19,75162.210000000006,92554.77,null,0,0,0,0,0,0,0,0]
[null,12,null,"PENSION DEFICIT ADJUSTMENT","PDt",null,null,null,-77038.03,18010.18,2476265,2414138.9900000002,-901601.44,-894057.8,null,null,null,-77038.03,18010.18,2476265,2414138.9900000002,-901601.44,-894057.8,null,0,0,0,0,0,0,0,0]
[null,13,null,"OTHER PASS THROUGH: \nTHIRD PARTY DAMAGE & WATER INGRESS, THEFT OF GAS, MISC PASS THROUGH","TPWIt + TGt + MPt",null,61165.630000000005,21943.16,14622.31,-60832.160000000003,-181775.94,685843.94,596565.26,950106.73,null,61165.630000000005,21943.16,14622.31,-60832.160000000003,-181775.94,685843.94,718642.78,950106.73,null,0,0,0,0,0,0,-122077.52000000002,0,null,"2019/20 NETT THEFT OF GAS VALUES CONFIRMED"]
[null,14,null,"PASS THROUGH","PTt",null,61165.630000000005,21943.16,773469.34,940656.4,3727995.52,3791273.9600000004,15688318.73,16113448.809999999,null,61165.630000000005,21943.16,773469.34,940656.4,3727995.52,3791273.9600000004,15810396.25,16113448.809999999,null,0,0,0,0,0,0,-122077.51999999955,0]
[]
[null,15,null,"NTS EXIT CAPACITY INCENTIVE REVENUE ADJUSTMENT","EIt",null,null,null,1025138.76,1631691.91,5858450.0300000003,4827613.53,5829736.1500000004,5608893.21,null,null,null,1025138.76,1631691.91,5858450.0300000003,4827613.53,5829736.1500000004,5608893.21,null,0,0,0,0,0,0,0,0]
[null,16,null,"NTS EXIT CAPACITY COST ADJUSTMENT",null,null,null,null,-232422.39,2406002.63,123955.39,-1157833.6599999999,-1697680.79,-7810123.96,null,null,null,-232422.39,2406002.63,123955.39,-1157833.6599999999,-1697680.79,-7810123.96,null,0,0,0,0,0,0,0,0]
[null,17,null,"NTS EXIT CAPACITY REVENUE ADJUSTMENT","EXt",null,0,0,792716.37,4037694.54,5982405.4199999999,3669779.87,4132055.3600000003,-2201230.75,null,0,0,792716.37,4037694.54,5982405.4199999999,3669779.87,4132055.3600000003,-2201230.75,null,0,0,0,0,0,0,0,0]
[]
[null,18,null,"SHRINKAGE INCENTIVE REVENUE ADJUSTMENT","SHRRt",null,null,null,351703.7,280983.76,282663.06,265183.75,310807.59000000003,491296.66,null,null,null,351703.7,280983.76,282663.06,265183.75,310807.59000000003,491296.66,null,0,0,0,0,0,0,0,0,null,"GAS PRICES UPDATED THROUGH TO AUG 2020"]
[null,19,null,"SHRINKAGE COST ADJUSTMENT","SHRAt",null,null,null,-2254040.52,-4801953.9000000004,-6278942.7300000004,-3083247.59,-2275775.7400000002,-1162616.1100000001,null,null,null,-2254040.52,-4801953.9000000004,-6278942.7300000004,-3083247.59,-2275775.7400000002,-1162616.1100000001,null,0,0,0,0,0,0,0,0,null,"GAS PRICES UPDATED THROUGH TO AUG 2020"]
[null,20,null,"SHRINKAGE REVENUE ADJUSTMENT","SHRt",null,0,0,-1902336.82,-4520970.1400000006,-5996279.6700000009,-2818063.84,-1964968.1500000001,-671319.45000000019,null,0,0,-1902336.82,-4520970.1400000006,-5996279.6700000009,-2818063.84,-1964968.1500000001,-671319.45000000019,null,0,0,0,0,0,0,0,0]
[]
[null,21,null,"BROAD MEASURE OF CUSTOMER SATISFACTION REVENUE ADJUSTMENT","BMt",null,null,null,1639127.43,1876605.33,2653642.7799999998,2238148.16,2392274.89,2942331.96,null,null,null,1639127.43,1876605.33,2653642.7799999998,2238148.16,2392274.89,2942331.96,null,0,0,0,0,0,0,0,0]
[null,22,null,"ENVIRONMENTAL EMISSIONS INCENTIVE REVENUE ADJUSTMENT","EEIt",null,null,null,1152007.8799999999,1256942.98,1649666.77,1588441.54,1520863.58,2259723.6800000002,null,null,null,1152007.8799999999,1256942.98,1649666.77,1588441.54,1520863.58,2259723.6800000002,null,0,0,0,0,0,0,0,0]
[null,23,null,"DISCRETIONARY REWARD SCHEME REVENUE ADJUSTMENT","DRSt",null,227255.63,205035.08,null,135214.24,null,null,141360.35,null,null,227255.63,205035.08,null,135214.24,null,null,141360.35,null,null,0,0,0,0,0,0,0,0,null,"NO FURTHER CHANGE ANTICIPATED"]
[null,24,null,"NETWORK INNOVATION ALLOWANCE REVENUE ADJUSTMENT","NIAt",null,628113.42000000004,1689747.81,2110566.48,1680750,1621028.38,1073145.47,1343283.88,2004635.2,null,628113.42000000004,1689747.81,2110566.48,1680750,1621028.38,1073145.47,1343283.88,2004635.2,null,0,0,0,0,0,0,0,0]
[null,25,null,"CORRECTION TERM REVENUE ADJUSTMENT","-Kt",null,14502068.029999999,0,6367203.7400000002,3237869.11,-7549773.1699999999,-7805826.1200000001,-638999.1,-1217914.31,null,14502068.029999999,0,6367203.7400000002,3237869.11,-7549773.1699999999,-7805826.1200000001,-638999.1,-1217914.31,null,0,0,0,0,0,0,0,0]
[]
[null,26,null,"MAXIMUM ALLOWED REVENUE","ARt",null,459341937.02999997,437916050.11000001,452902239.36000001,452905096.85000002,434015598.49999994,452638871.97000009,480077172.94,476673787.87,null,459341937.02999997,437916050.11000001,452902239.36000001,452905096.85000002,434015598.49999994,452638871.97000009,480199250.45999998,476673787.87,null,0,0,0,0,0,0,-122077.51999998093,0]
[]
[null,27,null,"COLLECTABLE REVENUE","Rt",null,453221979.56999999,434803911.39999998,460170510.39999998,460430789.19999999,434629682.83999997,453805112,480852532.88999999,475007704.68000001,null,453221979.56999999,434803911.39999998,460170510.39999998,460430789.19999999,434629682.83999997,453805112,480796199.63,475029270.51999998,null,0,0,0,0,0,0,56333.259999990463,-21565.839999973774,null,"REFLECTS ACTUAL COLLECTED REVENUE TO JULY 2020"]
[null,28,null,"UNDER / OVER RECOVERY CARRIED FORWARDS","ARt - Rt",null,-6119957.4599999785,-3112138.7100000381,7268271.0399999619,7525692.3499999642,614084.34000003338,1166240.0299999118,775359.94999998808,-1666083.1899999976,null,-6119957.4599999785,-3112138.7100000381,7268271.0399999619,7525692.3499999642,614084.34000003338,1166240.0299999118,596949.17000001669,-1644517.3500000238,null,0,0,0,0,0,0,178410.77999997139,-21565.839999973774]
[]
[null,29,null,"YEAR ON YEAR MOVEMENT IN ALLOWED REVENUE",null,null,null,-4.6644743692541679E-2,3.4221603081767915E-2,6.3092865338898463E-6,-4.116822714003443E-2,4.4967563373702113E-2,6.1162463483052987E-2,-7.089245775127373E-3,null,null,-4.6644743692541679E-2,3.4221603081767915E-2,6.3092865338898463E-6,-4.116822714003443E-2,4.4967563373702113E-2,6.1162463483052987E-2,-7.3416661659151394E-3,null,null,0,0,0,0,0,0,2.5242039078776646E-4]
[null,30,null,"ADJUSTMENT FOR PRIOR YEAR OVER / UNDER RECOVERY",null,null,null,1.3323315305304421E-2,7.1067016365769214E-3,-1.6048211751548892E-2,-1.6616488536653491E-2,8.7269727168308214E-4,5.8216241629765347E-4,-1.6150735625517702E-3,null,null,1.3323315305304421E-2,7.1067016365769214E-3,-1.6048211751548892E-2,-1.6616488536653491E-2,8.7269727168308214E-4,5.8216241629765347E-4,-1.2431280753315999E-3,null,null,0,0,0,0,0,0,-3.7194548722017029E-4]
[null,31,null,"IMPACT OF CHANGE IN ANNUAL LOAD FACTORS",null,null,null,1.3757124452690627E-2,3.3550280781673232E-3,-3.5786543521089578E-2,-2.6747873071593032E-2,-7.8208905888144098E-4,1.6477466154052545E-2,6.0000000000000001E-3,null,null,1.3757124452690627E-2,3.3550280781673232E-3,-3.5786543521089578E-2,-2.6747873071593032E-2,-7.8208905888144098E-4,1.6477466154052545E-2,6.0000000000000001E-3,null,null,0,0,0,0,0,0,0]
[null,32,null,"YEAR ON YEAR MOVEMENT IN AGGREGATE DEMAND",null,null,null,5.5643039345466289E-3,1.8128827625923931E-2,3.2782092192374372E-2,1.2129435390582533E-2,-1.598502140361395E-2,-2.6638320623840361E-2,5.1486485318931446E-3,null,null,5.5643039345466289E-3,1.8128827625923931E-2,3.2782092192374372E-2,1.2129435390582533E-2,-1.598502140361395E-2,-2.6638320623840361E-2,5.0291234354607403E-3,null,null,0,0,0,0,0,0,1.1952509643240426E-4,null,"BASED ON JAN 2020 SUPPLY POINT DATA PROVIDED BY XOSERVE"]
[null,33,null,"TOTAL DISTRIBUTION CHARGES ARITHMETICAL PRICE CHANGE",null,null,null,-1.4E-2,6.2812160422436092E-2,-1.9046353793730209E-2,-7.2403153357698424E-2,2.9073150182889806E-2,5.158377142956283E-2,2.4443291942140011E-3,null,null,-1.4E-2,6.2812160422436092E-2,-1.9046353793730209E-2,-7.2403153357698424E-2,2.9073150182889806E-2,5.158377142956283E-2,2.4443291942140011E-3,null,null,0,0,0,0,0,0,0]
[]
[null,null,null,"TABLE 2: DOMESTIC CUSTOMER BILL IMPACT (EXCL ECN CHARGES)"]
[]
[null,34,null,"AVERAGE AQ PER DOMESTIC CUSTOMER (Kwh)",null,null,14232.112820844695,14110.195606558467,13604.0298790897,13274.33834127008,13193.952343797637,13342.908831974206,13624.19705274329,13396.990227249858,null,14232.112820844695,14110.195606558467,13604.0298790897,13274.33834127008,13193.952343797637,13342.908831974206,13624.19705274329,13396.990227249858,null,0,0,0,0,0,0,0,0,null,"BASED ON JAN 2020 DEMAND DATA PROVIDED BY XOSERVE"]
[null,35,null,"TOTAL ANNUAL CHARGE (EXCL. ECN) (NOMINAL)",null,null,129.05000000000001,123.23,126.97,126.68,120.26,126.32,133.28,132.99,null,129.05000000000001,123.23,126.97,126.68,120.26,126.32,133.28,132.99,null,0,0,0,0,0,0,0,0]
[null,36,null,"TOTAL ANNUAL CHARGE (EXCL. ECN) (19/20 PRICES)",null,null,148.99618809586863,139.54197110389609,142.24375851214185,138.94205352369568,127.14262390493799,129.58974733064682,133.28,131.08256952449361,null,148.99618809586863,139.54197110389609,142.24375851214185,138.94205352369568,127.14262390493799,129.58974733064682,133.28,130.78537563109907,null,0,0,0,0,0,0,0,0.29719389339453528,null,"BASED ON RPI DATA UPTO APRIL 2020"]
[null,37,null,"% MOVEMENT IN DOMESTIC CUSTOMER BILL (19/20 PRICES)",null,null,null,-6.3452744078858037E-2,1.936182631556882E-2,-2.3211598336417283E-2,-8.4923385825338871E-2,1.9247073487632882E-2,2.8476424604313433E-2,-1.648732349569626E-2,null,null,-6.3452744078858037E-2,1.936182631556882E-2,-2.3211598336417283E-2,-8.4923385825338871E-2,1.9247073487632882E-2,2.8476424604313433E-2,-1.8717169634610786E-2,null,0,0,0,0,0,0,0,2.2298461389145263E-3]
[]
[null,null,null,"TABLE 3: ECN CHARGE ELEMENTS (NTS EXIT CAPACITY ONLY)"]
[]
[null,38,null,"INITIAL ALLOWED REVENUE (2009/10 PRICES)","AEXt",null,31300000,31300000,31300000,31300000,31300000,31300000,31300000,31300000,null,31300000,31300000,31300000,31300000,31300000,31300000,31300000,31300000,null,0,0,0,0,0,0,0,0]
[null,39,null,"INFLATED BASE REVENEUE (NOMINAL)","AEXt",null,36402411.219999999,37719123.390000001,38394233.310000002,38584551.890000001,39779875.439999998,41128959.159999996,42523876.539999999,43188977.890000001,null,36402411.219999999,37719123.390000001,38394233.310000002,38584551.890000001,39779875.439999998,41128959.159999996,42523876.539999999,43188977.890000001,null,0,0,0,0,0,0,0,0]
[null,40,null,"ECN COST TRUE UP",null,null,0,0,-232422.39,2406002.63,123955.39,-1157833.6599999999,-1697680.79,-7810123.96,null,0,0,-232422.39,2406002.63,123955.39,-1157833.6599999999,-1697680.79,-7810123.96,null,0,0,0,0,0,0,0,0]
[null,41,null,"CORRECTION FACTOR (ECN)",null,null,-486313.15,0,-1063733.8415039978,-407184.55243199819,-656862.76704739814,-445205.6941738379,-70399.507411415965,-277156.69274318806,null,-486313.15,0,-1063733.8415039978,-407184.55243199819,-656862.76704739814,-445205.6941738379,-70399.507411415965,-277156.69274318806,null,0,0,0,0,0,0,0,0]
[null,42,null,"TOTAL ALLOWED REVENUE (ECN)",null,null,35916098.07,37719123.390000001,37098077.079999998,40583369.969999999,39246968.060000002,39525919.810000002,40755796.240000002,35101697.240000002,null,35916098.07,37719123.390000001,37098077.079999998,40583369.969999999,39246968.060000002,39525919.810000002,40755796.240000002,35101697.240000002,null,0,0,0,0,0,0,0,0]
[]
[null,43,null,"COLLECTABLE REVENUE (ECN)",null,null,36938525.829999998,38110496.469999999,37730447.950000003,41012598.219999999,39314622.670000002,39791317.159999996,40921935.100000001,34949445.740000002,null,36938525.829999998,38110496.469999999,37730447.950000003,41012598.219999999,39314622.670000002,39791317.159999996,40933778.82,34898301.060000002,null,0,0,0,0,0,0,-11843.719999998808,51144.679999999702]
[null,44,null,"UNDER / OVER RECOVERY CARRIED FORWARDS (ECN)",null,null,1022427.7599999979,391373.07999999821,632370.87000000477,429228.25,67654.609999999404,265397.34999999404,166138.8599999994,-152251.5,null,1022427.7599999979,391373.07999999821,632370.87000000477,429228.25,67654.609999999404,265397.34999999404,177982.57999999821,-203396.1799999997,null,0,0,0,0,0,0,-11843.719999998808,51144.679999999702]
[]
[null,45,null,"YEAR ON YEAR MOVEMENT IN ALLOWED REVENUE",null,null,null,5.0201035660553339E-2,-1.646502501075231E-2,9.3948073979256419E-2,-3.2929791463545022E-2,7.1075999953307267E-3,3.1115694104324021E-2,-0.13873116272111385,null,null,5.0201035660553339E-2,-1.646502501075231E-2,9.3948073979256419E-2,-3.2929791463545022E-2,7.1075999953307267E-3,3.1115694104324021E-2,-0.13873116272111385,null,null,0,0,0,0,0,0,0]
[null,46,null,"ADJUSTMENT FOR PRIOR YEAR OVER / UNDER RECOVERY",null,null,null,-2.8467116834554235E-2,-1.0375985569796091E-2,-1.7045920429685106E-2,-1.0576456571184051E-2,-3.1557772771300696E-3,-6.1023966338911648E-3,-4.0764474093856985E-3,null,null,-2.8467116834554235E-2,-1.0375985569796091E-2,-1.7045920429685106E-2,-1.0576456571184051E-2,-3.1557772771300696E-3,-6.1023966338911648E-3,-4.3670495100109523E-3,null,null,0,0,0,0,0,0,2.9060210062525384E-4]
[null,47,null,"IMPACT OF CHANGE IN ANNUAL LOAD FACTORS",null,null,null,1.3757124452690627E-2,3.3550280781673232E-3,-3.5786543521089578E-2,-2.6747873071593032E-2,-4.992528355030057E-4,1.6477466154052545E-2,6.0000000000000001E-3,null,null,1.3757124452690627E-2,3.3550280781673232E-3,-3.5786543521089578E-2,-2.6747873071593032E-2,-4.992528355030057E-4,1.6477466154052545E-2,6.0000000000000001E-3,null,null,0,0,0,0,0,0,0]
[null,48,null,"YEAR ON YEAR MOVEMENT IN AGGREGATE DEMAND",null,null,null,1.7508956721310268E-2,3.3179745615702451E-2,3.034355436712001E-2,1.1574681632508174E-2,-9.1014752055965081E-3,-2.0100023275196839E-2,3.3007053702896749E-3,null,null,1.7508956721310268E-2,3.3179745615702451E-2,3.034355436712001E-2,1.1574681632508174E-2,-9.1014752055965081E-3,-2.0100023275196839E-2,3.591307470914934E-3,null,null,0,0,0,0,0,0,-2.9060210062525904E-4]
[null,49,null,"ECN CHARGES ARITHMETICAL PRICE CHANGE",null,null,null,5.2999999999999999E-2,9.6937631133213742E-3,7.1459164395601737E-2,-5.8679439473813932E-2,-5.6489053228988562E-3,2.1390740349288562E-2,-0.13350690476020988,null,null,5.2999999999999999E-2,9.6937631133213742E-3,7.1459164395601737E-2,-5.8679439473813932E-2,-5.6489053228988562E-3,2.1390740349288562E-2,-0.13350690476020988,null,null,0,0,0,0,0,0,0]
[]
[null,null,null,"TABLE 4: LDZ & CUSTOMER CHARGE ELEMENTS"]
[]
[null,50,null,"DN ALLOWED REVENUE LESS ECN REVENUE",null,null,423425838.95999998,400196926.72000003,415804162.28000003,412321726.88,394768630.43999994,413112952.16000009,439321376.69999999,441572090.63,null,423425838.95999998,400196926.72000003,415804162.28000003,412321726.88,394768630.43999994,413112952.16000009,439443454.21999997,441572090.63,null,0,0,0,0,0,0,-122077.51999998093,0,null,"IMPACTED BY NETT THEFT OF GAS VALUES"]
[null,51,null,"DN COLLECTABLE REVENUE LESS ECN REVENUE",null,null,416283453.74000001,396693414.92999995,422440062.44999999,419418190.98000002,395315060.16999996,414013794.84000003,439930597.78999996,440058258.94,null,416283453.74000001,396693414.92999995,422440062.44999999,419418190.98000002,395315060.16999996,414013794.84000003,439862420.81,440130969.45999998,null,0,0,0,0,0,0,68176.979999959469,-72710.519999980927,null,"BASED ON ACTUAL COLLECTED REVENUE POSTIONS TO JULY 2020"]
[null,52,null,"UNDER / OVER RECOVERY CARRIED FORWARDS (LDZ & CUSTOMER)",null,null,-7142385.219999969,-3503511.7900000811,6635900.1699999571,7096464.1000000238,546429.73000001907,900842.67999994755,609221.08999997377,-1513831.6899999976,null,-7142385.219999969,-3503511.7900000811,6635900.1699999571,7096464.1000000238,546429.73000001907,900842.67999994755,418966.59000003338,-1441121.1700000167,null,0,0,0,0,0,0,190254.4999999404,-72710.519999980927]
[]
[null,53,null,"YEAR ON YEAR MOVEMENT IN ALLOWED REVENUE",null,null,null,-5.4859458499400438E-2,3.899888909171878E-2,-8.3751816742396734E-3,-4.197910723981213E-2,4.8729184933283154E-2,6.4030675660577518E-2,5.1231605138508662E-3,null,null,-5.4859458499400438E-2,3.899888909171878E-2,-8.3751816742396734E-3,-4.197910723981213E-2,4.8729184933283154E-2,6.4030675660577518E-2,4.8439370061350573E-3,null,null,0,0,0,0,0,0,2.7922350771580895E-4]
[null,54,null,"ADJUSTMENT FOR PRIOR YEAR OVER / UNDER RECOVERY",null,null,null,1.6868090141930834E-2,8.7544695025889904E-3,-1.5959196111970091E-2,-1.7210987530776767E-2,1.2729511378475672E-3,1.2202587596171802E-3,-1.3867321790170786E-3,null,null,1.6868090141930834E-2,8.7544695025889904E-3,-1.5959196111970091E-2,-1.7210987530776767E-2,1.2729511378475672E-3,1.2202587596171802E-3,-9.5340273242592167E-4,null,null,0,0,0,0,0,0,-4.3332944659115694E-4]
[null,55,null,"IMPACT OF CHANGE IN ANNUAL LOAD FACTORS",null,null,null,1.3757124452690627E-2,3.3550280781673232E-3,-3.5786543521089578E-2,-2.6747873071593032E-2,-7.8208905888144098E-4,1.6477466154052545E-2,6.0000000000000001E-3,null,null,1.3757124452690627E-2,3.3550280781673232E-3,-3.5786543521089578E-2,-2.6747873071593032E-2,-7.8208905888144098E-4,1.6477466154052545E-2,6.0000000000000001E-3,null,null,0,0,0,0,0,0,0]
[null,56,null,"YEAR ON YEAR MOVEMENT IN AGGREGATE DEMAND",null,null,null,4.2342439047789796E-3,1.6716055610221034E-2,3.2996335586754244E-2,1.2197235796488612E-2,-1.6704980753400135E-2,-2.7269800612444661E-2,5.3213466708006453E-3,null,null,4.2342439047789796E-3,1.6716055610221034E-2,3.2996335586754244E-2,1.2197235796488612E-2,-1.6704980753400135E-2,-2.7269800612444661E-2,5.1672407319252982E-3,null,null,0,0,0,0,0,0,1.5410593887534713E-4,null,"BASED ON JAN 2020 SUPPLY POINT DATA PROVIDED BY XOSERVE"]
[null,57,null,"LDZ & CUSTOMER CHARGES ARITHMETICAL PRICE CHANGE",null,null,null,-0.02,6.7824442282696129E-2,-2.7124585720545102E-2,-7.3740732045693314E-2,3.2515066258849146E-2,5.4458599961802578E-2,1.5057775005634433E-2,null,null,-0.02,6.7824442282696129E-2,-2.7124585720545102E-2,-7.3740732045693314E-2,3.2515066258849146E-2,5.4458599961802578E-2,1.5057775005634433E-2,null,null,0,0,0,0,0,0,0]
[]
[null,null,null,"TABLE 5: PCFM ADJUSTMENTS"]
[]
[null,null,null,"DESCRIPTION","PCFM TERM",null,"FREQENCY","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21",null,"FREQENCY","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21",null,"FREQENCY","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21"]
[]
[null,58,null,"COST OF DEBT","CDE",null,"ANNUAL",2.7199999999999998E-2,2.5499999999999998E-2,2.3800000000000002E-2,2.2200000000000001E-2,1.9100000000000002E-2,1.5800000000000002E-2,1.09E-2,null,"ANNUAL",2.7199999999999998E-2,2.5499999999999998E-2,2.3800000000000002E-2,2.2200000000000001E-2,1.9100000000000002E-2,1.5800000000000002E-2,1.09E-2,null,"ANNUAL",0,0,0,0,0,0,0]
[null,59,null,"CORPORATION TAX RATE","CT",null,"ANNUAL",0.21,0.2,0.2,0.19,0.19,0.19,0.19,null,"ANNUAL",0.21,0.2,0.2,0.19,0.19,0.19,0.19,null,"ANNUAL",0,0,0,0,0,0,0]
[]
[null,60,null,"COST OF DEBT ADJUSTMENT","CDE £ IMPACT",null,"ANNUAL",-2140393.7179770404,-7310000,-5898746.0101748547,-7828522.636850547,-9975408.1064805854,-16561632.161552314,-20675990.62677151,null,"ANNUAL",-2140393.7179770404,-7310000,-5898746.0101748547,-7828522.636850547,-9975408.1064805854,-16561632.161552314,-20675990.62677151,null,"ANNUAL",0,0,0,0,0,0,0]
[null,61,null,"TAX TRIGGER EVENT","TTE",null,"AT ANY TIME",0,-300000,-198194.6402563017,-1618384.5426044173,-1720310.092520349,-1731812.9919547117,-3286810.8046467393,null,"AT ANY TIME",0,-300000,-198194.6402563017,-1618384.5426044173,-1720310.092520349,-1731812.9919547117,-3286810.8046467393,null,"AT ANY TIME",0,0,0,0,0,0,0]
[null,62,null,"TAX LIABILITY - GEARING/INTEREST COSTS","TGIE",null,"AT ANY TIME",0,0,0,0,0,0,0,null,"AT ANY TIME",0,0,0,0,0,0,0,null,"AT ANY TIME",0,0,0,0,0,0,0]
[null,63,null,"PENSION SCHEME ESTABLISHED DEFICIT","EDE",null,"3 YEARLY REVIEW",0,-700000,-724881.92888419901,-684381.50166707602,3795011.6991440835,3795011.6991440835,3795011.6991440835,null,"3 YEARLY REVIEW",0,-700000,-724881.92888419901,-684381.50166707602,3795011.6991440835,3795011.6991440835,3795011.6991440835,null,"3 YEARLY REVIEW",0,0,0,0,0,0,0,null,"NO FURTHER CHANGE EXPECTED IN RIIO-GD1"]
[null,64,null,"PENSION SCHEME ADMINISTRATION & PPF LEVY","APFE",null,"3 YEARLY REVIEW",0,0,0,0,286859.98118641012,286859.98118635325,286859.98118635325,null,"3 YEARLY REVIEW",0,0,0,0,286859.98118641012,286859.98118635325,286859.98118635325,null,"3 YEARLY REVIEW",0,0,0,0,0,0,0,null,"NO FURTHER CHANGE EXPECTED IN RIIO-GD1"]
[null,65,null,"SPECIFIED FINANCIAL ADJUSTMENTS",null,null,null,-2140393.7179770404,-8310000,-6821822.579315355,-10131288.68112204,-7613846.5186704397,-14211573.473176587,-19880929.751087811,null,null,-2140393.7179770404,-8310000,-6821822.579315355,-10131288.68112204,-7613846.5186704397,-14211573.473176587,-19880929.751087811,null,null,0,0,0,0,0,0,0]
[null,66,null,"LEGACY CAPEX RAV ADJUSTMENT","LRAV",null,"ONE OFF",-1550951.9446189869,-1600000,-1192579.1773956576,-1155551.7641377265,-1121487.8412376947,-1087947.9099074274,-1054939.6822235622,null,"ONE OFF",-1550951.9446189869,-1600000,-1192579.1773956576,-1155551.7641377265,-1121487.8412376947,-1087947.9099074274,-1054939.6822235622,null,"ONE OFF",0,0,0,0,0,0,0,null,"NO CHANGE EXPECTED IN RIIO-GD1"]
[null,67,null,"LEGACY ALLOWED REVENUE ADJUSTMENT","LAR",null,"ONE OFF",791345.66566040111,0,451141.83357856062,472167.97564652778,496623.9372448058,522224.61765461502,549018.82059544965,null,"ONE OFF",791345.66566040111,0,451141.83357856062,472167.97564652778,496623.9372448058,522224.61765461502,549018.82059544965,null,"ONE OFF",0,0,0,0,0,0,0,null,"NO CHANGE EXPECTED IN RIIO-GD1"]
[null,68,null,"LEGACY IFI CAP ADJUSTMENT","IFIAR",null,"ONE OFF",0,0,0,0,0,0,0,null,"ONE OFF",0,0,0,0,0,0,0,null,"ONE OFF",0,0,0,0,0,0,0,null,"NO CHANGE EXPECTED IN RIIO-GD1"]
[null,69,null,"LEGACY STREETWORKS COST ADJUSTMENT","IAEAR",null,"ONE OFF",0,0,0,0,0,0,0,null,"ONE OFF",0,0,0,0,0,0,0,null,"ONE OFF",0,0,0,0,0,0,0,null,"NO CHANGE EXPECTED IN RIIO-GD1"]
[null,70,null,"OVERALL LEGACY ADJUSTMENTS",null,null,null,-759606.27895858581,-1600000,-741437.34381709702,-683383.78849119879,-624863.90399288898,-565723.2922528123,-505920.8616281125,null,null,-759606.27895858581,-1600000,-741437.34381709702,-683383.78849119879,-624863.90399288898,-565723.2922528123,-505920.8616281125,null,null,0,0,0,0,0,0,0,null,"FIXED FOR RIIO GD-1"]
[]
[null,71,null,"TOTEX INCENTIVE MECHANISM",null,null,null,0,-2190000,3634953.1189645194,-2451563.5315281088,-6098511.1449597236,-5931316.5721291741,-3214137.8018178325,null,null,0,-2190000,3634953.1189645194,-2451563.5315281088,-6098511.1449597236,-5931316.5721291741,-3214137.8018178325,null,null,0,0,0,0,0,0,0,null,"ALIGNED TO 2018/19 RRP ACTUALS AND FORECAST"]
[]
[null,72,null,"ENHANCED PHYSICAL SITE SECURITY (CNI)","IAEEPS",null,"2 RE-OPENERS",0,0,6056602.2668840569,1512730.8965448947,2080091.9376538331,199185.68266143667,-160902.11756011285,null,"2 RE-OPENERS",0,0,6056602.2668840569,1512730.8965448947,2080091.9376538331,199185.68266143667,-160902.11756011285,null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"NO FURTHER CHANGE EXPECTED"]
[null,73,null,"SPECIFIED STREETWORKS","IAESW",null,"2 RE-OPENERS",0,0,1999107.6473197732,358275.30803925358,353386.2315869669,355140.82375743781,351635.97255228751,null,"2 RE-OPENERS",0,0,1999107.6473197732,358275.30803925358,353386.2315869669,355140.82375743781,351635.97255228751,null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"NO FURTHER CHANGE EXPECTED"]
[null,74,null,"CHANGE TO CONNECTION CHARGING BOUNDARY","IAECCB",null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"NO IMPACT IN RIIO GD-1"]
[null,75,null,"SMART METERING ROLL-OUT","IAESM",null,"RE-OPENER > REV DRIVER",0,0,0,0,0,0,0,null,"RE-OPENER > REV DRIVER",0,0,0,0,0,0,0,null,"RE-OPENER > REV DRIVER",0,0,0,0,0,0,0,null,"UPDATED FOR LATEST COST FORECAST IN 2018/19 RRP"]
[null,76,null,"LARGE LOAD CONNECTIONS","IAELLC",null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"NO IMPACT IN RIIO GD-1"]
[null,77,null,"FUEL POOR NETWORK EXTENSIONS","IAEFP",null,"1 RE-OPENER (FLEXIBLE)",0,0,4532688.0639302991,770864.47034434974,771143.45262657478,776316.15131178929,809656.76619393891,null,"1 RE-OPENER (FLEXIBLE)",0,0,4532688.0639302991,770864.47034434974,771143.45262657478,776316.15131178929,809656.76619393891,null,"1 RE-OPENER (FLEXIBLE)",0,0,0,0,0,0,0,null,"NO FURTHER CHANGE EXPECTED"]
[null,78,null,"AGENCY COSTS (FGO)","IAECA",null,"1 RE-OPENER (FLEXIBLE)",0,0,0,-1079478.9275051926,-1951097.6271906202,-2378265.0673541641,-2653769.1721118791,null,"1 RE-OPENER (FLEXIBLE)",0,0,0,-1079478.9275051926,-1951097.6271906202,-2378265.0673541641,-2653769.1721118791,null,"1 RE-OPENER (FLEXIBLE)",0,0,0,0,0,0,0,null,"NO FURTHER CHANGE EXPECTED"]
[null,79,null,"MAINS & SERVICES (REPEX T2)","RE",null,"ANNUAL",0,3500000,-975196.02355964179,-997637.3197516182,-1207589.7024791969,-1062134.7989203969,-915149.6158338245,null,"ANNUAL",0,3500000,-975196.02355964179,-997637.3197516182,-1207589.7024791969,-1062134.7989203969,-915149.6158338245,null,"ANNUAL",0,0,0,0,0,0,0,null,"UPDATED ANNUALLY. REFLECTS 2018/19 RRP"]
[null,80,null,"INNOVATION ROLL-OUT MECHANISM","IRM",null,"ANNUAL",0,0,0,0,0,0,0,null,"ANNUAL",0,0,0,0,0,0,0,null,"ANNUAL",0,0,0,0,0,0,0,null,"NO IMPACT IN RIIO GD-1"]
[null,81,null,"NTS EXIT CAPACITY COST ALLOWANCE","AEX",null,"ANNUAL",0,0,0,0,0,0,0,null,"ANNUAL",0,0,0,0,0,0,0,null,"ANNUAL",0,0,0,0,0,0,0,null,"NO IMPACT IN RIIO GD-1"]
[null,82,null,"SHRINKAGE COST ALLOWANCE","ALSC",null,"ANNUAL",0,0,-3584895.1497856253,-2698518.4288907931,-2708712.7292429614,-2681629.4538975284,-2630483.4163643136,null,"ANNUAL",0,0,-3584895.1497856253,-2698518.4288907931,-2708712.7292429614,-2681629.4538975284,-2630483.4163643136,null,"ANNUAL",0,0,0,0,0,0,0,null,"NO FURTHER CHANGE EXPECTED"]
[null,83,null,"UNCERTAIN COSTS",null,null,null,0,3500000,8028306.8047888633,-2133764.0012191059,-2662778.4370454038,-4791386.662441426,-5199011.5831239037,null,null,0,3500000,8028306.8047888633,-2133764.0012191059,-2662778.4370454038,-4791386.662441426,-5199011.5831239037,null,null,0,0,0,0,0,0,0]
[]
[null,84,null,"TOTAL POTENTIAL IMPACT OF REVENUE ADJUSTMENTS SHOWN IN TABLE 5",null,null,null,-2899999.9969356265,-8600000,4100000.0006209305,-15400000.002360452,-17000000.004668456,-25500000,-28799999.99765766,null,null,-2899999.9969356265,-8600000,4100000.0006209305,-15400000.002360452,-17000000.004668456,-25500000,-28799999.99765766,null,0,0,0,0,0,0,0,0]
[null,85,null,"TOTAL VALUE INCLUDED IN TABLE 1 IN THIS FORECAST",null,null,null,-2900000,-8600000,4100000,-15400000,-17000000,-25500000,-28800000,null,null,-2900000,-8600000,4100000,-15400000,-17000000,-25500000,-28800000,null,0,0,0,0,0,0,0,0]
[]
[null,null,null,"TABLE 6: RISKS AND SENSITIVITIES",null,null,"2013/14","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21",null,"2013/14","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21",null,"2013/14","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21"]
[]
[null,86,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]

{"sheet":"WM MOD0186 RIIO-GD1","index":5,"n_rows":124,"n_cols":34,"rows_kept":124,"cut":false,"hidden":false,"merged":[[52,3,52,4],[75,3,75,4],[63,3,63,4],[64,3,64,4],[66,3,66,4],[68,3,68,4],[70,3,70,4],[72,3,72,4],[74,3,74,4],[69,3,69,4],[53,3,53,4],[55,3,55,4],[61,3,61,4],[67,3,67,4],[82,3,82,4],[84,3,84,4],[76,3,76,4],[78,3,78,4],[80,3,80,4],[79,3,79,4],[81,3,81,4],[0,24,0,31],[4,3,4,4],[0,3,0,4],[0,6,0,13],[0,15,0,22],[42,3,42,4],[44,3,44,4],[46,3,46,4],[48,3,48,4],[51,3,51,4],[43,3,43,4],[45,3,45,4],[50,3,50,4],[121,3,121,4],[123,3,123,4],[96,3,96,4],[101,3,101,4],[103,3,103,4],[116,3,116,4],[118,3,118,4],[119,3,119,4]]}
[null,null,null,"CADENT GAS LTD\nWEST MIDLANDS DISTRIBUTION NETWORK",null,null,"CURRENT (SEPT-2020)",null,null,null,null,null,null,null,null,"PREVIOUS (JUN -2020)",null,null,null,null,null,null,null,null,"MOVEMENT"]
[]
[null,null,null,"DESCRIPTION","LICENCE \nTERM",null,"2013/14","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21",null,"2013/14","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21",null,"2013/14","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21"]
[]
[null,"ROW REF",null,"TABLE 1: TOTAL CHARGE ELEMENTS (LDZ + CUSTOMER + ECN)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTES (RIIO GD-1)"]
[]
[null,1,null,"FORECAST RPI FACTOR","RPIFt",null,1.1630163330372321,1.2050838144310987,1.2266528212575318,1.2327332873088215,1.270922538158505,1.314024254388422,1.358590304925267,1.3798395491512827,null,1.1630163330372321,1.2050838144310987,1.2266528212575318,1.2327332873088215,1.270922538158505,1.314024254388422,1.358590304925267,1.3798395491512827,null,0,0,0,0,0,0,0,0,null,"BASED ON AUG-2020 HMT 'FORECASTS FOR THE UK ECONOMY'. "]
[null,2,null,"ASSUMED ANNUAL INFLATION FOR PRICE SETTING","GRPIFt",null,2.6500000000000003E-2,3.075E-2,2.6000000000000002E-2,2.325E-2,3.4000000000000002E-2,3.3250000000000002E-2,3.175E-2,2.4750000000000001E-2,null,2.6500000000000003E-2,3.075E-2,2.6000000000000002E-2,2.325E-2,3.4000000000000002E-2,3.3250000000000002E-2,3.175E-2,2.4750000000000001E-2,null,0,0,0,0,0,0,0,0,null,"BASED ON AUG-2020 HMT 'FORECASTS FOR THE UK ECONOMY'. "]
[null,3,null,"ACTUAL / FORECAST ANNUAL INFLATION",null,null,2.8847791287762714E-2,1.9597457627118731E-2,1.0779220779220777E-2,2.1424900424001248E-2,3.7422560457875953E-2,3.0555639758707454E-2,2.5884636879724532E-2,1.4551366229893725E-2,null,2.8847791287762714E-2,1.9597457627118731E-2,1.0779220779220777E-2,2.1424900424001248E-2,3.7422560457875953E-2,3.0555639758707454E-2,2.5884636879724532E-2,1.6856811078934664E-2,null,0,0,0,0,0,0,0,-2.3054448490409385E-3,null,"BASED ON RPI DATA UP TO JULY 2020"]
[null,4,null,"DIFFERENCE (DRIVES t+2 RPI TRUE UP)",null,null,2.3477912877627113E-3,-1.1152542372881269E-2,-1.5220779220779225E-2,-1.8250995759987523E-3,3.4225604578759505E-3,-2.6943602412925483E-3,-5.8653631202754686E-3,-1.0198633770106276E-2,null,2.3477912877627113E-3,-1.1152542372881269E-2,-1.5220779220779225E-2,-1.8250995759987523E-3,3.4225604578759505E-3,-2.6943602412925483E-3,-5.8653631202754686E-3,-7.8931889210653375E-3,null,0,0,0,0,0,0,0,-2.3054448490409385E-3]
[]
[null,5,null,"OPENING BASE REVENUE ALLOWANCE (2009/10 PRICES)","PUt",null,281900000,276300000,276300000,268500000,271600000,271900000,272200000,270000000,null,281900000,276300000,276300000,268500000,271600000,271900000,272200000,270000000,null,0,0,0,0,0,0,0,0,null,"FIXED PER LICENCE"]
[null,6,null,"PRICE CONTROL FINANCIAL MODEL ITERATION ADJUSTMENT (2009/10 PRICES)","MODt",null,null,-2200000,-5200000,-5400000,-13300000,-11800000,-19800000,-23100000,null,null,-2200000,-5200000,-5400000,-13300000,-11800000,-19800000,-23100000,null,0,0,0,0,0,0,0,0]
[null,7,null,"RPI TRUE UP (2009/10 PRICES)","TRUt",null,null,null,963997.05,-3874053.86,-5932190.75,-1041159.3,675900.07,-211025.45,null,null,null,963997.05,-3874053.86,-5932190.75,-1041159.3,675900.07,-211025.45,null,0,0,0,0,0,0,0,0]
[null,8,null,"UPLIFT TO NOMINAL PRICES USING RPIFt",null,null,45954304.279999971,56213473.540000021,61664072.49000001,60330506.600000024,68372127.430000007,81350759.290000021,90750564.180000007,93702228.870000005,null,45954304.279999971,56213473.540000021,61664072.49000001,60330506.600000024,68372127.430000007,81350759.290000021,90750564.180000007,93702228.870000005,null,0,0,0,0,0,0,0,0]
[null,9,null,"BASE REVENUE (NOMINAL)","BRt",null,327854304.27999997,330313473.54000002,333728069.54000002,319556452.74000001,320739936.68000001,340409599.99000001,343826464.25,340391203.42000002,null,327854304.27999997,330313473.54000002,333728069.54000002,319556452.74000001,320739936.68000001,340409599.99000001,343826464.25,340391203.42000002,null,0,0,0,0,0,0,0,0]
[]
[null,10,null,"BUSINESS RATES ADJUSTMENT","RBt",null,null,null,656834.43000000005,762474.4,1136663.3799999999,810653.98,9998726.3599999994,10012571.15,null,null,null,656834.43000000005,762474.4,1136663.3799999999,810653.98,9998726.3599999994,10012571.15,null,0,0,0,0,0,0,0,0]
[null,11,null,"LICENCE FEES ADJUSTMENT","LFt",null,null,null,12793.51,6330.49,9873.07,-235894.67,54850.54,67445.72,null,null,null,12793.51,6330.49,9873.07,-235894.67,54850.54,67445.72,null,0,0,0,0,0,0,0,0]
[null,12,null,"PENSION DEFICIT ADJUSTMENT","PDt",null,null,null,-25400.45,43798.83,1787728.34,1742865.26,-651281.36,-645842.55000000005,null,null,null,-25400.45,43798.83,1787728.34,1742865.26,-651281.36,-645842.55000000005,null,0,0,0,0,0,0,0,0]
[null,13,null,"OTHER PASS THROUGH: \nTHIRD PARTY DAMAGE & WATER INGRESS, THEFT OF GAS, MISC PASS THROUGH","TPWIt + TGt + MPt",null,26405.730000000003,-18340.53,-126096.98999999999,-42273.11,-60673.649999999994,476150.12000000005,185940.44999999995,693356.34,null,26405.730000000003,-18340.53,-126096.98999999999,-42273.11,-60673.649999999994,476150.12000000005,524758.22,693356.34,null,0,0,0,0,0,0,-338817.77,0,null,"2019/20 NETT THEFT OF GAS VALUES CONFIRMED"]
[null,14,null,"PASS THROUGH","PTt",null,26405.730000000003,-18340.53,518130.50000000012,770330.61,2873591.14,2793774.69,9588235.9899999984,10127530.66,null,26405.730000000003,-18340.53,518130.50000000012,770330.61,2873591.14,2793774.69,9927053.7599999998,10127530.66,null,0,0,0,0,0,0,-338817.77000000142,0]
[]
[null,15,null,"NTS EXIT CAPACITY INCENTIVE REVENUE ADJUSTMENT","EIt",null,null,null,435489.45,1838707.92,2816331.43,2257135.44,2302183.0299999998,2351444.1,null,null,null,435489.45,1838707.92,2816331.43,2257135.44,2302183.0299999998,2351444.1,null,0,0,0,0,0,0,0,0]
[null,16,null,"NTS EXIT CAPACITY COST ADJUSTMENT",null,null,null,null,131001.46,-317640.52,-1108315.3700000001,57493.25,967619.51,-3777682.79,null,null,null,131001.46,-317640.52,-1108315.3700000001,57493.25,967619.51,-3777682.79,null,0,0,0,0,0,0,0,0]
[null,17,null,"NTS EXIT CAPACITY REVENUE ADJUSTMENT","EXt",null,0,0,566490.91,1521067.4,1708016.06,2314628.69,3269802.54,-1426238.69,null,0,0,566490.91,1521067.4,1708016.06,2314628.69,3269802.54,-1426238.69,null,0,0,0,0,0,0,0,0]
[]
[null,18,null,"SHRINKAGE INCENTIVE REVENUE ADJUSTMENT","SHRRt",null,null,null,313002.2,258523.64,289451.19,236128.3,261772.03,412024.22,null,null,null,313002.2,258523.64,289451.19,236128.3,261772.03,412024.22,null,0,0,0,0,0,0,0,0,null,"GAS PRICES UPDATED THROUGH TO AUG 2020"]
[null,19,null,"SHRINKAGE COST ADJUSTMENT","SHRAt",null,null,null,-1346360.58,-3633026.46,-5006423.53,-2692585.58,-1994509.81,-1026989.13,null,null,null,-1346360.58,-3633026.46,-5006423.53,-2692585.58,-1994509.81,-1026989.13,null,0,0,0,0,0,0,0,0,null,"GAS PRICES UPDATED THROUGH TO AUG 2020"]
[null,20,null,"SHRINKAGE REVENUE ADJUSTMENT","SHRt",null,0,0,-1033358.3800000001,-3374502.82,-4716972.34,-2456457.2800000003,-1732737.78,-614964.91,null,0,0,-1033358.3800000001,-3374502.82,-4716972.34,-2456457.2800000003,-1732737.78,-614964.91,null,0,0,0,0,0,0,0,0]
[]
[null,21,null,"BROAD MEASURE OF CUSTOMER SATISFACTION REVENUE ADJUSTMENT","BMt",null,null,null,1077502.48,915763.35,1036589.46,952532.47999999998,739922.21,1558441.06,null,null,null,1077502.48,915763.35,1036589.46,952532.47999999998,739922.21,1558441.06,null,0,0,0,0,0,0,0,0]
[null,22,null,"ENVIRONMENTAL EMISSIONS INCENTIVE REVENUE ADJUSTMENT","EEIt",null,null,null,987928.29,1216834.67,1773746.17,1435189.64,1551274.59,1924625.86,null,null,null,987928.29,1216834.67,1773746.17,1435189.64,1551274.59,1924625.86,null,0,0,0,0,0,0,0,0]
[null,23,null,"DISCRETIONARY REWARD SCHEME REVENUE ADJUSTMENT","DRSt",null,163624.04999999999,148473.68,null,98666.65,null,null,103151.5,null,null,163624.04999999999,148473.68,null,98666.65,null,null,103151.5,null,null,0,0,0,0,0,0,0,0,null,"NO FURTHER CHANGE ANTICIPATED"]
[null,24,null,"NETWORK INNOVATION ALLOWANCE REVENUE ADJUSTMENT","NIAt",null,459193.85,1232888.27,1539636.7,1217250,1182909.26,783103.93,980439.01,1462837.77,null,459193.85,1232888.27,1539636.7,1217250,1182909.26,783103.93,980439.01,1462837.77,null,0,0,0,0,0,0,0,0]
[null,25,null,"CORRECTION TERM REVENUE ADJUSTMENT","-Kt",null,-10727948.23,0,-11779713.380000001,-665892.46,991897.31,-2615565.5299999998,-2120953.25,-1484943.43,null,-10727948.23,0,-11779713.380000001,-665892.46,991897.31,-2615565.5299999998,-2120953.25,-1484943.43,null,0,0,0,0,0,0,0,0]
[]
[null,26,null,"MAXIMUM ALLOWED REVENUE","ARt",null,317775579.68000001,331676494.96000004,325604686.66000009,321255970.14000005,325589713.74000001,343616806.61000007,356205599.06,351938491.74000001,null,317775579.68000001,331676494.96000004,325604686.66000009,321255970.14000005,325589713.74000001,343616806.61000007,356544416.82999998,351938491.74000001,null,0,0,0,0,0,0,-338817.76999998093,0]
[]
[null,27,null,"COLLECTABLE REVENUE","Rt",null,329097872.43000001,332316530,324649773.39999998,323777668.82999998,327627970.39999998,345038746.12,359666239.06,350527363.88999999,null,329097872.43000001,332316530,324649773.39999998,323777668.82999998,327627970.39999998,345038746.12,359679398.31999999,350790071.44,null,0,0,0,0,0,0,-13159.259999990463,-262707.55000001192,null,"REFLECTS ACTUAL COLLECTED REVENUE TO JULY 2020"]
[null,28,null,"UNDER / OVER RECOVERY CARRIED FORWARDS","ARt - Rt",null,11322292.75,640035.03999996185,-954913.26000010967,2521698.689999938,2038256.6599999666,1421939.5099999309,3460640,-1411127.8500000238,null,11322292.75,640035.03999996185,-954913.26000010967,2521698.689999938,2038256.6599999666,1421939.5099999309,3134981.4900000095,-1148420.3000000119,null,0,0,0,0,0,0,325658.50999999046,-262707.55000001192]
[]
[null,29,null,"YEAR ON YEAR MOVEMENT IN ALLOWED REVENUE",null,null,null,4.3744441577286297E-2,-1.8306417223602822E-2,-1.3355816725516001E-2,1.3783412330268252E-2,5.7697984490852727E-2,3.7859152434077004E-2,-1.1979338144208151E-2,null,null,4.3744441577286297E-2,-1.8306417223602822E-2,-1.3355816725516001E-2,1.3783412330268252E-2,5.7697984490852727E-2,3.7859152434077004E-2,-1.2918236473735245E-2,null,null,0,0,0,0,0,0,9.3889832952709362E-4]
[null,30,null,"ADJUSTMENT FOR PRIOR YEAR OVER / UNDER RECOVERY",null,null,null,-3.5629839024765679E-2,-1.9296967066573399E-3,2.9327380689616435E-3,-7.8494998517879919E-3,-4.0145467257323752E-3,-1.9541516559294565E-3,-9.7152880503068185E-3,null,null,-3.5629839024765679E-2,-1.9296967066573399E-3,2.9327380689616435E-3,-7.8494998517879919E-3,-4.0145467257323752E-3,-1.9541516559294565E-3,-8.7926814781530173E-3,null,null,0,0,0,0,0,0,-9.2260657215380119E-4]
[null,31,null,"IMPACT OF CHANGE IN ANNUAL LOAD FACTORS",null,null,null,4.2883491084525866E-3,-2.8988614932914597E-3,1.3124598605203482E-2,-6.0513673960381235E-3,3.1624369359262161E-4,9.7479510134744762E-3,9.5999999999999992E-3,null,null,4.2883491084525866E-3,-2.8988614932914597E-3,1.3124598605203482E-2,-6.0513673960381235E-3,3.1624369359262161E-4,9.7479510134744762E-3,9.5999999999999992E-3,null,null,0,0,0,0,0,0,0]
[null,32,null,"YEAR ON YEAR MOVEMENT IN AGGREGATE DEMAND",null,null,null,1.3597048339026793E-2,1.9429670986438698E-2,2.9733977941312712E-3,4.1908801545701259E-3,-1.8980558135640639E-2,-1.6889155126468748E-2,1.8367329646628138E-3,null,null,1.3597048339026793E-2,1.9429670986438698E-2,2.9733977941312712E-3,4.1908801545701259E-3,-1.8980558135640639E-2,-1.6889155126468748E-2,1.853024722036108E-3,null,null,0,0,0,0,0,0,-1.6291757373294163E-5,null,"BASED ON JAN 2020 SUPPLY POINT DATA PROVIDED BY XOSERVE"]
[null,33,null,"TOTAL DISTRIBUTION CHARGES ARITHMETICAL PRICE CHANGE",null,null,null,2.5999999999999999E-2,-3.7053044371129218E-3,5.6749177427803952E-3,4.0734252370122626E-3,3.5019123323072332E-2,2.8763796665153274E-2,-1.0257893229852155E-2,null,null,2.5999999999999999E-2,-3.7053044371129218E-3,5.6749177427803952E-3,4.0734252370122626E-3,3.5019123323072332E-2,2.8763796665153274E-2,-1.0257893229852155E-2,null,null,0,0,0,0,0,0,0]
[]
[null,null,null,"TABLE 2: DOMESTIC CUSTOMER BILL IMPACT (EXCL ECN CHARGES)"]
[]
[null,34,null,"AVERAGE AQ PER DOMESTIC CUSTOMER (Kwh)",null,null,14339.016354879677,14163.048258255316,13705.041918822551,13566.029332189435,13526.521608347286,13799.629575382241,14013.160699342066,13941.79061421663,null,14339.016354879677,14163.048258255316,13705.041918822551,13566.029332189435,13526.521608347286,13799.629575382241,14013.160699342066,13941.79061421663,null,0,0,0,0,0,0,0,0,null,"BASED ON JAN 2020 DEMAND DATA PROVIDED BY XOSERVE"]
[null,35,null,"TOTAL ANNUAL CHARGE (EXCL. ECN) (NOMINAL)",null,null,127.95,129.13,125.36,123.58,124.14,130.46,135.88,135.12,null,127.95,129.13,125.36,123.58,124.14,130.46,135.88,135.12,null,0,0,0,0,0,0,0,0]
[null,36,null,"TOTAL ANNUAL CHARGE (EXCL. ECN) (19/20 PRICES)",null,null,147.72617021980929,146.22295487012985,140.44008480020557,135.5419874838831,131.24468095425746,133.83690972732887,135.88,133.18201965673791,null,147.72617021980929,146.22295487012985,140.44008480020557,135.5419874838831,131.24468095425746,133.83690972732887,135.88,132.88006583407855,null,0,0,0,0,0,0,0,0.30195382265935677,null,"BASED ON RPI DATA UPTO APRIL 2020"]
[null,37,null,"% MOVEMENT IN DOMESTIC CUSTOMER BILL (19/20 PRICES)",null,null,null,-1.0175687540282974E-2,-3.9548305360539548E-2,-3.4876775553722039E-2,-3.1704615000843317E-2,1.975111489641912E-2,1.5265521871609122E-2,-1.9855610415529079E-2,null,null,-1.0175687540282974E-2,-3.9548305360539548E-2,-3.4876775553722039E-2,-3.1704615000843317E-2,1.975111489641912E-2,1.5265521871609122E-2,-2.2077819884614658E-2,null,0,0,0,0,0,0,0,2.2222094690855787E-3]
[]
[null,null,null,"TABLE 3: ECN CHARGE ELEMENTS (NTS EXIT CAPACITY ONLY)"]
[]
[null,38,null,"INITIAL ALLOWED REVENUE (2009/10 PRICES)","AEXt",null,17400000,17200000,16900000,16900000,16900000,16900000,16900000,16900000,null,17400000,17200000,16900000,16900000,16900000,16900000,16900000,16900000,null,0,0,0,0,0,0,0,0]
[null,39,null,"INFLATED BASE REVENEUE (NOMINAL)","AEXt",null,20236484.190000001,20727441.609999999,20730432.68,20833192.559999999,21478590.890000001,22207009.899999999,22960176.149999999,23319288.379999999,null,20236484.190000001,20727441.609999999,20730432.68,20833192.559999999,21478590.890000001,22207009.899999999,22960176.149999999,23319288.379999999,null,0,0,0,0,0,0,0,0]
[null,40,null,"ECN COST TRUE UP",null,null,0,0,131001.46,-317640.52,-1108315.3700000001,57493.25,967619.51,-3777682.79,null,0,0,131001.46,-317640.52,-1108315.3700000001,57493.25,967619.51,-3777682.79,null,0,0,0,0,0,0,0,0]
[null,41,null,"CORRECTION FACTOR (ECN)",null,null,309258.65999999997,0,238388.06926800188,-270340.08497999923,111518.65351535009,-270082.49112437695,-74502.743799890712,-155533.1795097127,null,309258.65999999997,0,238388.06926800188,-270340.08497999923,111518.65351535009,-270082.49112437695,-74502.743799890712,-155533.1795097127,null,0,0,0,0,0,0,0,0]
[null,42,null,"TOTAL ALLOWED REVENUE (ECN)",null,null,20545742.850000001,20727441.609999999,21099822.210000001,20245211.960000001,20481794.170000002,21994420.66,23853292.920000002,19386072.41,null,20545742.850000001,20727441.609999999,21099822.210000001,20245211.960000001,20481794.170000002,21994420.66,23853292.920000002,19386072.41,null,0,0,0,0,0,0,0,0]
[]
[null,43,null,"COLLECTABLE REVENUE (ECN)",null,null,20316611.68,20987284.059999999,20992461.66,20505601.789999999,20553392.030000001,22143354.800000001,23984189.469999999,19273791.550000001,null,20316611.68,20987284.059999999,20992461.66,20505601.789999999,20553392.030000001,22143354.800000001,23985714.379999999,19283627,null,0,0,0,0,0,0,-1524.910000000149,-9835.4499999992549]
[null,44,null,"UNDER / OVER RECOVERY CARRIED FORWARDS (ECN)",null,null,-229131.17000000179,259842.44999999925,-107360.55000000075,260389.82999999821,71597.859999999404,148934.1400000006,130896.54999999702,-112280.8599999994,null,-229131.17000000179,259842.44999999925,-107360.55000000075,260389.82999999821,71597.859999999404,148934.1400000006,132421.45999999717,-102445.41000000015,null,0,0,0,0,0,0,-1524.910000000149,-9835.4499999992549]
[]
[null,45,null,"YEAR ON YEAR MOVEMENT IN ALLOWED REVENUE",null,null,null,8.8436208574467212E-3,1.7965584320852601E-2,-4.0503196732860069E-2,1.1685835172653869E-2,7.3852245435390929E-2,8.4515627337283128E-2,-0.18727898596568282,null,null,8.8436208574467212E-3,1.7965584320852601E-2,-4.0503196732860069E-2,1.1685835172653869E-2,7.3852245435390929E-2,8.4515627337283128E-2,-0.18727898596568282,null,null,0,0,0,0,0,0,0]
[null,46,null,"ADJUSTMENT FOR PRIOR YEAR OVER / UNDER RECOVERY",null,null,null,1.1152245585513193E-2,-1.2536156409898542E-2,5.088220598802891E-3,-1.2861798163164215E-2,-1.1789826515964689E-3,-5.999136873832943E-3,-5.4875672905624557E-3,null,null,1.1152245585513193E-2,-1.2536156409898542E-2,5.088220598802891E-3,-1.2861798163164215E-2,-1.1789826515964689E-3,-5.999136873832943E-3,-5.5514959902650271E-3,null,null,0,0,0,0,0,0,6.3928699702571479E-5]
[null,47,null,"IMPACT OF CHANGE IN ANNUAL LOAD FACTORS",null,null,null,4.2883491084525866E-3,-2.8988614932914597E-3,1.3124598605203482E-2,-6.0513673960381235E-3,1.7134168257415501E-4,9.7479510134744762E-3,9.5999999999999992E-3,null,null,4.2883491084525866E-3,-2.8988614932914597E-3,1.3124598605203482E-2,-6.0513673960381235E-3,1.7134168257415501E-4,9.7479510134744762E-3,9.5999999999999992E-3,null,null,0,0,0,0,0,0,0]
[null,48,null,"YEAR ON YEAR MOVEMENT IN AGGREGATE DEMAND",null,null,null,1.0715784448587503E-2,2.8357776499501646E-2,7.1176073395407373E-3,2.2124938686366499E-4,-1.9311062339770951E-2,-1.1483928897155077E-2,-7.6425656985681933E-4,null,null,1.0715784448587503E-2,2.8357776499501646E-2,7.1176073395407373E-3,2.2124938686366499E-4,-1.9311062339770951E-2,-1.1483928897155077E-2,-7.0032787015425479E-4,null,null,0,0,0,0,0,0,-6.392869970256454E-5]
[null,49,null,"ECN CHARGES ARITHMETICAL PRICE CHANGE",null,null,null,3.5000000000000003E-2,3.0888342917164247E-2,-1.5172770189312956E-2,-7.006080999684805E-3,5.3533542126597666E-2,7.6780512579769589E-2,-0.1839308098261021,null,null,3.5000000000000003E-2,3.0888342917164247E-2,-1.5172770189312956E-2,-7.006080999684805E-3,5.3533542126597666E-2,7.6780512579769589E-2,-0.1839308098261021,null,null,0,0,0,0,0,0,0]
[]
[null,null,null,"TABLE 4: LDZ & CUSTOMER CHARGE ELEMENTS"]
[]
[null,50,null,"DN ALLOWED REVENUE LESS ECN REVENUE",null,null,297229836.82999998,310949053.35000002,304504864.45000011,301010758.18000007,305107919.56999999,321622385.95000005,332352306.13999999,332552419.32999998,null,297229836.82999998,310949053.35000002,304504864.45000011,301010758.18000007,305107919.56999999,321622385.95000005,332691123.90999997,332552419.32999998,null,0,0,0,0,0,0,-338817.76999998093,0,null,"IMPACTED BY NETT THEFT OF GAS VALUES"]
[null,51,null,"DN COLLECTABLE REVENUE LESS ECN REVENUE",null,null,308781260.75,311329245.94,303657311.73999995,303272067.03999996,307074578.37,322895391.31999999,335682049.59000003,331253572.33999997,null,308781260.75,311329245.94,303657311.73999995,303272067.03999996,307074578.37,322895391.31999999,335693683.94,331506444.44,null,0,0,0,0,0,0,-11634.349999964237,-252872.10000002384,null,"BASED ON ACTUAL COLLECTED REVENUE POSTIONS TO JULY 2020"]
[null,52,null,"UNDER / OVER RECOVERY CARRIED FORWARDS (LDZ & CUSTOMER)",null,null,11551423.920000017,380192.58999997377,-847552.71000015736,2261308.8599998951,1966658.8000000119,1273005.3699999452,3329743.4500000477,-1298846.9900000095,null,11551423.920000017,380192.58999997377,-847552.71000015736,2261308.8599998951,1966658.8000000119,1273005.3699999452,3002560.030000031,-1045974.8899999857,null,0,0,0,0,0,0,327183.42000001669,-252872.10000002384]
[]
[null,53,null,"YEAR ON YEAR MOVEMENT IN ALLOWED REVENUE",null,null,null,4.6156929150577675E-2,-2.0724259587136973E-2,-1.1474714127510333E-2,1.39244899927915E-2,5.6613889193076528E-2,3.4675622605590872E-2,6.0211163365808673E-4,null,null,4.6156929150577675E-2,-2.0724259587136973E-2,-1.1474714127510333E-2,1.39244899927915E-2,5.6613889193076528E-2,3.4675622605590872E-2,-4.1691698404766608E-4,null,null,0,0,0,0,0,0,1.0190286177057528E-3]
[null,54,null,"ADJUSTMENT FOR PRIOR YEAR OVER / UNDER RECOVERY",null,null,null,-3.8863608186841724E-2,-1.2226845070084011E-3,2.7833798699111621E-3,-7.5123855162932919E-3,-4.2048384196617748E-3,-1.6781485690333278E-3,-1.0018716249248553E-2,null,null,-3.8863608186841724E-2,-1.2226845070084011E-3,2.7833798699111621E-3,-7.5123855162932919E-3,-4.2048384196617748E-3,-1.6781485690333278E-3,-9.0250680412269947E-3,null,null,0,0,0,0,0,0,-9.9364820802155807E-4]
[null,55,null,"IMPACT OF CHANGE IN ANNUAL LOAD FACTORS",null,null,null,4.2883491084525866E-3,-2.8988614932914597E-3,1.3124598605203482E-2,-6.0513673960381235E-3,1.7134168257415501E-4,9.7479510134744762E-3,9.5999999999999992E-3,null,null,4.2883491084525866E-3,-2.8988614932914597E-3,1.3124598605203482E-2,-6.0513673960381235E-3,1.7134168257415501E-4,9.7479510134744762E-3,9.5999999999999992E-3,null,null,0,0,0,0,0,0,0]
[null,56,null,"YEAR ON YEAR MOVEMENT IN AGGREGATE DEMAND",null,null,null,1.3418329927811463E-2,1.8825917468794653E-2,2.6772922881444644E-3,4.4628254841559394E-3,-1.8799768024252227E-2,-1.7237106305095715E-2,1.9619589750338746E-3,null,null,1.3418329927811463E-2,1.8825917468794653E-2,2.6772922881444644E-3,4.4628254841559394E-3,-1.8799768024252227E-2,-1.7237106305095715E-2,1.9873393847180693E-3,null,null,0,0,0,0,0,0,-2.5380409684194749E-5,null,"BASED ON JAN 2020 SUPPLY POINT DATA PROVIDED BY XOSERVE"]
[null,57,null,"LDZ & CUSTOMER CHARGES ARITHMETICAL PRICE CHANGE",null,null,null,2.5000000000000001E-2,-6.0198881186421804E-3,7.1105566357487771E-3,4.8235625646160241E-3,3.3780624431736683E-2,2.5508318744936309E-2,2.1453543594434077E-3,null,null,2.5000000000000001E-2,-6.0198881186421804E-3,7.1105566357487771E-3,4.8235625646160241E-3,3.3780624431736683E-2,2.5508318744936309E-2,2.1453543594434077E-3,null,null,0,0,0,0,0,0,0]
[]
[null,null,null,"TABLE 5: PCFM ADJUSTMENTS"]
[]
[null,null,null,"DESCRIPTION","PCFM TERM",null,"FREQENCY","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21",null,"FREQENCY","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21",null,"FREQENCY","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21"]
[]
[null,58,null,"COST OF DEBT","CDE",null,"ANNUAL",2.7199999999999998E-2,2.5499999999999998E-2,2.3800000000000002E-2,2.2200000000000001E-2,1.9100000000000002E-2,1.5800000000000002E-2,1.09E-2,null,"ANNUAL",2.7199999999999998E-2,2.5499999999999998E-2,2.3800000000000002E-2,2.2200000000000001E-2,1.9100000000000002E-2,1.5800000000000002E-2,1.09E-2,null,"ANNUAL",0,0,0,0,0,0,0]
[null,59,null,"CORPORATION TAX RATE","CT",null,"ANNUAL",0.21,0.2,0.2,0.19,0.19,0.19,0.19,null,"ANNUAL",0.21,0.2,0.2,0.19,0.19,0.19,0.19,null,"ANNUAL",0,0,0,0,0,0,0]
[]
[null,60,null,"COST OF DEBT ADJUSTMENT","CDE £ IMPACT",null,"ANNUAL",-1643392.2050104213,-4920000,-4445537.820164727,-5890187.8052938767,-7577699.6421338366,-12690402.647914918,-15739644.451499064,null,"ANNUAL",-1643392.2050104213,-4920000,-4445537.820164727,-5890187.8052938767,-7577699.6421338366,-12690402.647914918,-15739644.451499064,null,"ANNUAL",0,0,0,0,0,0,0]
[null,61,null,"TAX TRIGGER EVENT","TTE",null,"AT ANY TIME",0,-300000,-295176.46744103677,-1435348.9611472697,-1351379.8881325074,-1408348.6183498052,-2701819.4065623474,null,"AT ANY TIME",0,-300000,-295176.46744103677,-1435348.9611472697,-1351379.8881325074,-1408348.6183498052,-2701819.4065623474,null,"AT ANY TIME",0,0,0,0,0,0,0]
[null,62,null,"TAX LIABILITY - GEARING/INTEREST COSTS","TGIE",null,"AT ANY TIME",0,0,0,0,0,0,0,null,"AT ANY TIME",0,0,0,0,0,0,0,null,"AT ANY TIME",0,0,0,0,0,0,0]
[null,63,null,"PENSION SCHEME ESTABLISHED DEFICIT","EDE",null,"3 YEARLY REVIEW",0,-500000,-517591.35549253819,-476917.68212592934,2834786.5274853916,2834786.5274853348,2834786.5274853916,null,"3 YEARLY REVIEW",0,-500000,-517591.35549253819,-476917.68212592934,2834786.5274853916,2834786.5274853348,2834786.5274853916,null,"3 YEARLY REVIEW",0,0,0,0,0,0,0,null,"NO FURTHER CHANGE EXPECTED IN RIIO-GD1"]
[null,64,null,"PENSION SCHEME ADMINISTRATION & PPF LEVY","APFE",null,"3 YEARLY REVIEW",0,0,0,0,187409.04782356438,187409.04782356438,187409.04782356438,null,"3 YEARLY REVIEW",0,0,0,0,187409.04782356438,187409.04782356438,187409.04782356438,null,"3 YEARLY REVIEW",0,0,0,0,0,0,0,null,"NO FURTHER CHANGE EXPECTED IN RIIO-GD1"]
[null,65,null,"SPECIFIED FINANCIAL ADJUSTMENTS",null,null,null,-1643392.2050104213,-5720000,-5258305.6430983013,-7802454.4485670757,-5906883.9549573893,-11076555.690955823,-15419268.282752454,null,null,-1643392.2050104213,-5720000,-5258305.6430983013,-7802454.4485670757,-5906883.9549573893,-11076555.690955823,-15419268.282752454,null,null,0,0,0,0,0,0,0]
[null,66,null,"LEGACY CAPEX RAV ADJUSTMENT","LRAV",null,"ONE OFF",-586552.49445109803,-1000000,-450230.46390883793,-437016.61555280682,-424134.02494958066,-411449.60203513392,-398966.26342977013,null,"ONE OFF",-586552.49445109803,-1000000,-450230.46390883793,-437016.61555280682,-424134.02494958066,-411449.60203513392,-398966.26342977013,null,"ONE OFF",0,0,0,0,0,0,0,null,"NO CHANGE EXPECTED IN RIIO-GD1"]
[null,67,null,"LEGACY ALLOWED REVENUE ADJUSTMENT","LAR",null,"ONE OFF",29944.697115752206,0,17071.307961884944,17866.941883994514,18792.360944871689,19761.096421746061,20774.995058445711,null,"ONE OFF",29944.697115752206,0,17071.307961884944,17866.941883994514,18792.360944871689,19761.096421746061,20774.995058445711,null,"ONE OFF",0,0,0,0,0,0,0,null,"NO CHANGE EXPECTED IN RIIO-GD1"]
[null,68,null,"LEGACY IFI CAP ADJUSTMENT","IFIAR",null,"ONE OFF",0,0,0,0,0,0,0,null,"ONE OFF",0,0,0,0,0,0,0,null,"ONE OFF",0,0,0,0,0,0,0,null,"NO CHANGE EXPECTED IN RIIO-GD1"]
[null,69,null,"LEGACY STREETWORKS COST ADJUSTMENT","IAEAR",null,"ONE OFF",0,0,0,0,0,0,0,null,"ONE OFF",0,0,0,0,0,0,0,null,"ONE OFF",0,0,0,0,0,0,0,null,"NO CHANGE EXPECTED IN RIIO-GD1"]
[null,70,null,"OVERALL LEGACY ADJUSTMENTS",null,null,null,-556607.79733534576,-1000000,-433159.15594695299,-419149.67366881232,-405341.66400470899,-391688.50561338785,-378191.2683713244,null,null,-556607.79733534576,-1000000,-433159.15594695299,-419149.67366881232,-405341.66400470899,-391688.50561338785,-378191.2683713244,null,null,0,0,0,0,0,0,0,null,"FIXED FOR RIIO GD-1"]
[]
[null,71,null,"TOTEX INCENTIVE MECHANISM",null,null,null,0,-380000,-1228785.6004098179,-2323195.875410079,-2145549.761591387,-4734613.365329165,-3615005.1466825013,null,null,0,-380000,-1228785.6004098179,-2323195.875410079,-2145549.761591387,-4734613.365329165,-3615005.1466825013,null,null,0,0,0,0,0,0,0,null,"ALIGNED TO 2018/19 RRP ACTUALS AND FORECAST"]
[]
[null,72,null,"ENHANCED PHYSICAL SITE SECURITY (CNI)","IAEEPS",null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"NO FURTHER CHANGE EXPECTED"]
[null,73,null,"SPECIFIED STREETWORKS","IAESW",null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"NO FURTHER CHANGE EXPECTED"]
[null,74,null,"CHANGE TO CONNECTION CHARGING BOUNDARY","IAECCB",null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"NO IMPACT IN RIIO GD-1"]
[null,75,null,"SMART METERING ROLL-OUT","IAESM",null,"RE-OPENER > REV DRIVER",0,0,0,0,0,0,0,null,"RE-OPENER > REV DRIVER",0,0,0,0,0,0,0,null,"RE-OPENER > REV DRIVER",0,0,0,0,0,0,0,null,"UPDATED FOR LATEST COST FORECAST IN 2018/19 RRP"]
[null,76,null,"LARGE LOAD CONNECTIONS","IAELLC",null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,"NO IMPACT IN RIIO GD-1"]
[null,77,null,"FUEL POOR NETWORK EXTENSIONS","IAEFP",null,"1 RE-OPENER (FLEXIBLE)",0,0,4250513.553436744,717583.03726454638,707246.93298268446,728522.63327581563,751259.65017281263,null,"1 RE-OPENER (FLEXIBLE)",0,0,4250513.553436744,717583.03726454638,707246.93298268446,728522.63327581563,751259.65017281263,null,"1 RE-OPENER (FLEXIBLE)",0,0,0,0,0,0,0,null,"NO FURTHER CHANGE EXPECTED"]
[null,78,null,"AGENCY COSTS (FGO)","IAECA",null,"1 RE-OPENER (FLEXIBLE)",0,0,0,-918834.54543551581,-1575618.2539865903,-1888955.7525070587,-2093059.6019777567,null,"1 RE-OPENER (FLEXIBLE)",0,0,0,-918834.54543551581,-1575618.2539865903,-1888955.7525070587,-2093059.6019777567,null,"1 RE-OPENER (FLEXIBLE)",0,0,0,0,0,0,0,null,"NO FURTHER CHANGE EXPECTED"]
[null,79,null,"MAINS & SERVICES (REPEX T2)","RE",null,"ANNUAL",0,1900000,-785628.99011982617,-800287.82896300755,-712457.00723420666,-682825.93502260628,-586047.54117609863,null,"ANNUAL",0,1900000,-785628.99011982617,-800287.82896300755,-712457.00723420666,-682825.93502260628,-586047.54117609863,null,"ANNUAL",0,0,0,0,0,0,0,null,"UPDATED ANNUALLY. REFLECTS 2018/19 RRP"]
[null,80,null,"INNOVATION ROLL-OUT MECHANISM","IRM",null,"ANNUAL",0,0,0,0,0,0,0,null,"ANNUAL",0,0,0,0,0,0,0,null,"ANNUAL",0,0,0,0,0,0,0,null,"NO IMPACT IN RIIO GD-1"]
[null,81,null,"NTS EXIT CAPACITY COST ALLOWANCE","AEX",null,"ANNUAL",0,0,0,0,0,0,0,null,"ANNUAL",0,0,0,0,0,0,0,null,"ANNUAL",0,0,0,0,0,0,0,null,"NO IMPACT IN RIIO GD-1"]
[null,82,null,"SHRINKAGE COST ALLOWANCE","ALSC",null,"ANNUAL",0,0,-1944634.1671138639,-1753660.6663323937,-1761396.2869936586,-1753883.3838477784,-1759687.8072504865,null,"ANNUAL",0,0,-1944634.1671138639,-1753660.6663323937,-1761396.2869936586,-1753883.3838477784,-1759687.8072504865,null,"ANNUAL",0,0,0,0,0,0,0,null,"NO FURTHER CHANGE EXPECTED"]
[null,83,null,"UNCERTAIN COSTS",null,null,null,0,1900000,1520250.3962030541,-2755200.0034663705,-3342224.615231771,-3597142.4381016279,-3687535.3002315294,null,null,0,1900000,1520250.3962030541,-2755200.0034663705,-3342224.615231771,-3597142.4381016279,-3687535.3002315294,null,null,0,0,0,0,0,0,0]
[]
[null,84,null,"TOTAL POTENTIAL IMPACT OF REVENUE ADJUSTMENTS SHOWN IN TABLE 5",null,null,null,-2200000.0023457669,-5200000,-5400000.0032520182,-13300000.001112338,-11799999.995785255,-19800000.000000004,-23099999.998037808,null,null,-2200000.0023457669,-5200000,-5400000.0032520182,-13300000.001112338,-11799999.995785255,-19800000.000000004,-23099999.998037808,null,0,0,0,0,0,0,0,0]
[null,85,null,"TOTAL VALUE INCLUDED IN TABLE 1 IN THIS FORECAST",null,null,null,-2200000,-5200000,-5400000,-13300000,-11800000,-19800000,-23100000,null,null,-2200000,-5200000,-5400000,-13300000,-11800000,-19800000,-23100000,null,0,0,0,0,0,0,0,0]
[]
[null,null,null,"TABLE 6: RISKS AND SENSITIVITIES",null,null,"2013/14","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21",null,"2013/14","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21",null,"2013/14","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21"]
[]
[null,86,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]

{"sheet":"EE MOD0186 RIIO2","index":6,"n_rows":76,"n_cols":23,"rows_kept":76,"cut":false,"hidden":false,"merged":[[18,1,18,2],[2,10,2,14],[2,16,2,20],[2,1,2,2],[2,4,2,8],[6,1,6,2]]}
[]
[]
[null,"CADENT GAS LTD\nEAST OF ENGLAND DISTRIBUTION NETWORK",null,null,"RIIO-GD2 - Sept-20",null,null,null,null,null,"RIIO-GD2 - June-20",null,null,null,null,null,"Movement"]
[]
[null,"DESCRIPTION","PRICE BASE",null,"2021/22","2022/23","2023/24","2024/25","2025/26",null,"2021/22","2022/23","2023/24","2024/25","2025/26",null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
[]
[null,"KEY FINANCIAL PARAMETERS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTES ON CHANGES FROM LAST FORECAST"]
[]
[null,"INFLATION INDEX (2018/19 TO OUTTURN)",null,null,1.0590808425165079,1.0813215402093543,1.1040292925537509,1.1272139076973788,1.1508853997590243,null,1.0586108585642655,1.0768718958744994,1.0962555900002402,1.1159881906202449,1.1360759780514091,null,4.6998395224240319E-4,4.4496443348549519E-3,7.7737025535107307E-3,1.1225717077133934E-2,1.4809421707615122E-2,null,"LATEST HM TREASURY REPORT"]
[null,"COST OF EQUITY",null,null,3.9259999999999996E-2,3.9369999999999995E-2,3.9469999999999998E-2,3.9619999999999995E-2,3.9779999999999996E-2,null,4.2741620748301866E-2,4.289554656129576E-2,4.3021284755714609E-2,4.3123414767420244E-2,4.3218133167267511E-2,null,-3.4816207483018696E-3,-3.5255465612957643E-3,-3.5512847557146107E-3,-3.5034147674202487E-3,-3.4381331672675153E-3,null,"BASED ON DRAFT DETERMINATION OUTPUT"]
[null,"COST OF DEBT",null,null,1.9730000000000001E-2,1.83E-2,1.7170000000000001E-2,1.6289999999999999E-2,1.5599999999999999E-2,null,2.0299999999999999E-2,1.9599999999999999E-2,1.9099999999999999E-2,1.8800000000000001E-2,1.8599999999999998E-2,null,-5.6999999999999759E-4,-1.2999999999999991E-3,-1.9299999999999977E-3,-2.5100000000000018E-3,-2.9999999999999992E-3,null,"BASED ON DRAFT DETERMINATION OUTPUT"]
[null,"WEIGHTED AVERAGE COST OF CAPITAL (WACC)",null,null,2.7541999999999997E-2,2.6727999999999998E-2,2.6090000000000002E-2,2.5621999999999999E-2,2.5271999999999996E-2,null,2.9276648299320744E-2,2.8918218624518304E-2,2.8668513902285843E-2,2.8529365906968099E-2,2.8447253266907002E-2,null,-1.7346482993207471E-3,-2.1902186245183058E-3,-2.5785139022858408E-3,-2.9073659069680999E-3,-3.1752532669070063E-3,null,"BASED ON DRAFT DETERMINATION OUTPUT"]
[null,"OUTPERFORMANCE",null,null,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,null,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,null,-2.5000000000000001E-3,-2.5000000000000001E-3,-2.5000000000000001E-3,-2.5000000000000001E-3,-2.5000000000000001E-3,null,"BASED ON DRAFT DETERMINATION OUTPUT"]
[null,"GEARING",null,null,0.6,0.6,0.6,0.6,0.6,null,0.6,0.6,0.6,0.6,0.6,null,0,0,0,0,0,null,"NO CHANGE, BASED ON DRAFT DETERMINATION"]
[null,"CORPORATION TAX RATE",null,null,0.19,0.19,0.19,0.19,0.19,null,0.19,0.19,0.19,0.19,0.19,null,0,0,0,0,0,null,"NO CHANGE, BASED ON DRAFT DETERMINATION"]
[null,"OPEX / CAPEX CAPITALISATION RATE (NETWORK SPECIFIC)",null,null,0.30564000000000002,0.30564000000000002,0.30564000000000002,0.30564000000000002,0.30564000000000002,null,0.30564000000000002,0.30564000000000002,0.30564000000000002,0.30564000000000002,0.30564000000000002,null,0,0,0,0,0,null,"NO CHANGE   "]
[null,"REPEX CAPITALISATION RATE",null,null,1,1,1,1,1,null,1,1,1,1,1,null,0,0,0,0,0,null,"NO CHANGE, BASED ON DRAFT DETERMINATION"]
[]
[null,"RIIO-GD2 BASE REVENUE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTES ON CHANGES FROM LAST FORECAST"]
[]
[null,"REGULATORY DEPRECIATION (PRE RIIO-GD2 RAV)","2018/19",null,118.66186903411004,115.3001035541386,111.93833807416719,108.57657259419577,105.21480711422433,null,118.66186903411004,115.3001035541386,111.93833807416719,108.57657259419577,105.21480711422433,null,0,0,0,0,0]
[null,"BUSINESS RATES","2018/19",null,67.451680000360739,67.451680000360739,67.451680000360739,67.451680000360739,67.451680000360739,null,67.451680000360739,67.451680000360739,67.451680000360739,67.451680000360739,67.451680000360739,null,0,0,0,0,0,null,"THIS IS NOT ALIGNED TO OFGEM DRAFT DETERMINTION FOLLOWING RATES REVALUATION BEING DELAYED"]
[null,"EXIT CAPACITY","2018/19",null,51.258685543761175,53.498976909087425,56.662196019107448,56.357446860002241,53.508457165953416,null,51.258685543761175,53.498976909087425,56.662196019107448,56.357446860002241,53.508457165953416,null,0,0,0,0,0,null,"THIS IS NOT ALIGNED TO OFGEM DRAFT DETERMINTION FOLLOWING MOD0678A IMPLEMENTATION"]
[null,"SHRINKAGE","2018/19",null,5.8817717099312095,5.6404256074179475,5.3941215377925076,5.1430579007080857,4.8995824562531674,null,5.8817717099312095,5.6404256074179475,5.3941215377925076,5.1430579007080857,4.8995824562531674,null,0,0,0,0,0]
[null,"LICENCE FEES","2018/19",null,2.9736151138531306,2.9736151138531306,2.9736151138531306,2.9736151138531306,2.9736151138531306,null,2.9736151138531306,2.9736151138531306,2.9736151138531306,2.9736151138531306,2.9736151138531306,null,0,0,0,0,0]
[null,"XOSERVE","2018/19",null,4.968,5.2480000000000011,3.7540000000000004,3.552,3.552,null,4.968,5.2480000000000011,3.7540000000000004,3.552,3.552,null,0,0,0,0,0]
[null,"ESTABLISHED PENSION DEFICIT FUNDING","2018/19",null,17.545157540820313,15.349631083264448,0,0,0,null,17.545157540820313,15.349631083264448,0,0,0,null,0,0,0,0,0]
[null,"OTHER PASS THROUGH COSTS","2018/19",null,3.5364000000000146,3.4891000000000076,3.440700000000021,3.3945000000000221,3.3505000000000393,null,0,0,0,0,0,null,3.5364000000000146,3.4891000000000076,3.440700000000021,3.3945000000000221,3.3505000000000393,null,"INTRODUCTION OF CARBON MONOXIDE PASS THROUGH ITEM"]
[null,"FAST FUNDED TOTEX","2018/19",null,149.9870030795237,152.41372178806461,153.35095765331261,142.55927780867754,136.3760547494287,null,149.9870030795237,152.41372178806461,153.35095765331261,142.55927780867754,136.3760547494287,null,0,0,0,0,0,null,"JUNE REFLECTED CADENT BUSINESS PLAN SUBMISSION, SEPTEMBER'S TOTEX ALIGNED TO DRAFT DETERMINATION"]
[null,"SLOW FUNDED TOTEX","2018/19",null,51.140601570646808,59.173295512291034,66.799707563113785,74.213178196970645,81.202589831159727,null,51.140601570646808,59.173295512291034,66.799707563113785,74.213178196970645,81.202589831159727,null,0,0,0,0,0,null,"JUNE REFLECTED CADENT BUSINESS PLAN SUBMISSION, SEPTEMBER'S TOTEX ALIGNED TO DRAFT DETERMINATION"]
[null,"DEBT FINANCING","2018/19",null,37.872754147258313,35.094037090478487,32.845688569356511,31.034683428242378,29.510449286152536,null,39.225104457366932,38.325518126740349,37.708975676370713,37.394325160181829,37.181432946958559,null,-1.3523503101086192,-3.2314810362618616,-4.8632871070142016,-6.3596417319394511,-7.6709836608060229,null,"BASED ON DRAFT DETERMINATION"]
[null,"EQUITY FINANCING","2018/19",null,58.217284790138592,50.333414945433084,50.336607564841842,50.32102138027269,50.167763786459311,null,63.055198723731571,55.918164873856306,56.624383260714161,57.183368575542517,57.595416503637381,null,-4.8379139335929793,-5.5847499284232214,-6.2877756958723197,-6.8623471952698267,-7.42765271717807,null,"BASED ON DRAFT DETERMINATION"]
[null,"ADDITIONAL INCOME","2018/19",null,3.220451925892196,3.2589726298248598,3.2904865337147227,3.3150997482430702,3.331669618903097,null,6.440903851784392,6.5179452596497196,6.5809730674294453,6.6301994964861404,6.663339237806194,null,-3.220451925892196,-3.2589726298248598,-3.2904865337147227,-3.3150997482430702,-3.331669618903097,null,"ASSUMES 25 BPS OUTPERFORMANCE PER OFGEM GUIDANCE"]
[null,"ADJUSTMENT FROM PREVIOUS PRICE CONTROL","2018/19",null,0,-3.2148977031513062,0,0,0,null,0,-3.2148977031513062,0,0,0,null,0,0,0,0,0,null,"ALLOWANCE FOR RIIO1 CLOSE OUT COST TBD BY OFGEM"]
[null,"TAX ALLOWANCE","2018/19",null,34.512655586159546,33.209594864140314,32.166608476462706,31.166573833879667,29.242111574163282,null,35.628775658382366,34.840954547097205,34.256769850416937,33.663665682215608,32.10727471357184,null,-1.1161200722228202,-1.6313596829568908,-2.0901613739542313,-2.4970918483359412,-2.8651631394085584,null,"REFLECTS DECREASE IN OTHER REVENUE LINES"]
[null,"BASE REVENUE (BEFORE TIMING DIFFERENCES)","2018/19",null,607.2279300424558,599.21967139520325,590.40470710608315,580.05870686540584,570.78128069691149,null,614.21836628427229,609.43713467267014,603.4957178166386,595.69838738919429,588.72624983320725,null,-6.9904362418164965,-10.217463277466891,-13.091010710555452,-15.639680523788456,-17.944969136295754]
[]
[null,"MODT TIMING ADJUSTMENT","2018/19",null,14.894981007719306,22.163335076552936,-0.41435440663886797,-0.42410741148824183,-0.36049788370371666,null,15.474115616367182,19.289070470048532,-0.22930038602905478,-0.27795446019655856,-0.24112717271782241,null,-0.5791346086478768,2.8742646065044042,-0.18505402060981319,-0.14615295129168326,-0.11937071098589425,null,"RELATES TO UPDATED TOTEX PERFORMANCE IN LAST TWO YEARS OF RIIO-GD1"]
[null,"INFLATION TRUE UP","2018/19",null,-5.5908341968135256,-5.5068937531375717,0,-2.5346136318911803E-13,-1.2040077263742189E-13,null,-5.5890715703406002,-4.5810621273144347,0,0,1.3486739885570922E-13,null,-1.7626264729253549E-3,-0.92583162582313694,0,-2.5346136318911803E-13,-2.5526817149313108E-13,null,"REDUCED INFLATION IN FINAL YEARS OF RIIO-1"]
[null,"TOTAL BASE REVENUE","2018/19",null,616.53207685336156,615.87611271861863,589.99035269944432,579.63459945391742,570.42078281320767,null,624.10341033029886,624.14514301540419,603.26641743060952,595.42043292899768,588.48512266048954,null,-7.5713334769372977,-8.2690302967855587,-13.276064731165206,-15.785833475080267,-18.064339847281872]
[null,"BASE REVENUE NOMINAL","NOMINAL",null,652.95731139231054,665.96010678304663,651.36663170430552,653.37218188705526,656.48895065883403,null,660.68264704264379,672.12436345985884,661.334182367724,664.48217160275499,668.56381129521912,null,-7.7253356503332498,-6.1642566768122151,-9.9675506634184785,-11.109989715699726,-12.074860636385097]
[]
[null,"LAGGED RIIO-GD1 REVENUE ADJUSTMENTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTES ON CHANGES FROM LAST FORECAST"]
[]
[null,"BUSINESS RATES PASS THROUGH ADJUSTMENT","NOMINAL",null,11.217922139168046,1.0888949727256299,null,null,null,null,11.218593669915068,1.0859023596823567,null,null,null,null,-6.7153074702197557E-4,2.9926130432731401E-3,0,0,0]
[null,"LICENCE FEE PASS THROUGH ADJUSTMENT","NOMINAL",null,0.40924665388078046,0.41166348600884362,null,null,null,null,0.40893607793419862,0.41053211011995905,null,null,null,null,3.1057594658184806E-4,1.1313758888845671E-3,0,0,0]
[null,"NTS PENSION DEFICIT PASS THROUGH ADJUSTMENT","NOMINAL",null,-9.5890946440952156,-9.7319531749867689,null,null,null,null,-9.5818175115451698,-9.7052068213553557,null,null,null,null,-7.2771325500458062E-3,-2.67463536314132E-2,0,0,0]
[null,"PASS THROUGH ADJUSTMENTS","NOMINAL",null,2.0380741489536103,-8.2313947162522965,null,null,null,null,2.0457122363040963,-8.2087723515530406,null,null,null,null,-7.6380873504859892E-3,-2.2622364699255826E-2,0,0,0,null,"UPDATES TO INFLATION AT THE END OF RIIO-1 PLUS AN INCENTIVE PERFORMANCE RESULTS UPDATE"]
[]
[null,"EXIT CAPACITY COST PASS THROUGH ADJUSTMENT","NOMINAL",null,-12.550363202324807,5.6547116990597877,null,null,null,null,-12.540838772755141,5.5654906519514205,null,null,null,null,-9.5244295696659265E-3,8.9221047108367202E-2,0,0,0]
[null,"EXIT CAPACITY INCENTIVE REVENUE ADJUSTMENT","NOMINAL",null,8.2184207719880398,5.8954826313656996,null,null,null,null,8.0411123668030982,5.9409432936607036,null,null,null,null,0.17730840518494162,-4.5460662295004006E-2,0,0,0]
[null,"EXIT CAPACITY ADJUSTMENTS","NOMINAL",null,-4.3319424303367668,11.550194330425487,null,null,null,null,-4.4997264059520425,11.506433945612123,null,null,null,null,0.16778397561527569,4.3760384813364084E-2,0,0,0,null,"UPDATES TO INFLATION AT THE END OF RIIO-1 PLUS AN INCENTIVE PERFORMANCE RESULTS UPDATE"]
[]
[null,"SHRINKAGE COST PASS THROUGH ADJUSTMENT","NOMINAL",null,-6.102704979742426,-6.7900390598988718,null,null,null,null,-3.7542312690948858,-3.7090987986069868,null,null,null,null,-2.3484737106475402,-3.080940261291885,0,0,0]
[null,"SHRINKAGE INCENTIVE ADJUSTMENT","NOMINAL",null,0.75909904066877809,0.97596866123622594,null,null,null,null,0.39173465999999996,0.71590604000000013,null,null,null,null,0.36736438066877813,0.26006262123622581,0,0,0]
[null,"SHRINKAGE ADJUSTMENTS","NOMINAL",null,-5.3436059390736474,-5.8140703986626461,null,null,null,null,-3.3624966090948858,-2.9931927586069866,null,null,null,null,-1.9811093299787617,-2.8208776400556594,0,0,0,null,"UPDATES TO INFLATION AT THE END OF RIIO-1 PLUS AN INCENTIVE PERFORMANCE RESULTS UPDATE"]
[]
[null,"ENVIRONMENTAL EMISSIONS INCENTIVE","NOMINAL",null,3.499695177074496,6.1637958105321804,null,null,null,null,3.00551718,7.3660954500000004,null,null,null,null,0.49417799707449594,-1.20229963946782,0,0,0]
[null,"CUSTOMER SATISFACTION INCENTIVE REVENUE","NOMINAL",null,3.3365458607407001,3.3255185817782751,null,null,null,null,3.2584628547810626,3.2987468947972509,null,null,null,null,7.8083005959637575E-2,2.6771686981024168E-2,0,0,0]
[null,"COMPLAINTS INCENTIVE REVENUE","NOMINAL",null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,0,0,0]
[null,"STAKEHOLDER INCENTIVE REVENUE","NOMINAL",null,1.2980423405225965,1.3152844268853818,null,null,null,null,1.3097742794906253,1.2936262368363749,null,null,null,null,-1.1731938968028821E-2,2.1658190049006931E-2,0,0,0]
[null,"DISCRETIONARY REWARD SCHEME","NOMINAL",null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,0,0,0]
[null,"NETWORK INNOVATION ALLOWANCE","NOMINAL",null,2.0652076429071897,2.1085770034082394,2.1528571204798133,2.1980671200098891,2.2442265295300969,null,2.1189154945022346,2.1137918444120549,2.1084283762474625,2.1041957334144716,2.1011725214060815,null,-5.3707851595044875E-2,-5.2148410038155291E-3,4.442874423235077E-2,9.3871386595417494E-2,0.14305400812401547,null,"UPDATES TO INFLATION AT THE END OF RIIO-1 PLUS CHANGES TO BASE REVENUE NUMBERS"]
[null,"INCENTIVES ADJUSTMENTS","NOMINAL",null,10.199491021244981,12.913175822604076,2.1528571204798133,2.1980671200098891,2.2442265295300969,null,9.6926698087739229,14.072260426045681,2.1084283762474625,2.1041957334144716,2.1011725214060815,null,0.50682121247105805,-1.1590846034416042,4.442874423235077E-2,9.3871386595417494E-2,0.14305400812401547,null,"UPDATES TO INFLATION AT THE END OF RIIO-1 PLUS AN INCENTIVE PERFORMANCE RESULTS UPDATE"]
[]
[null,"CORRECTION TERM","NOMINAL",null,-1.77315464,2.3741824600000001,null,null,null,null,-2.3725616700000001,1.9878834299999999,null,null,null,null,0.59940703000000006,0.38629903000000021,0,0,0,null,"REFLECTS CHANGES TO COLLECTED INCOME"]
[]
[null,"MAXIMUM ALLOWED REVENUE","NOMINAL",null,653.74617355309874,678.75219428116122,653.5194888247853,655.57024900706517,658.73317718836415,null,662.1862444026749,688.48897615135695,663.44261074397161,666.58636733616947,670.66498381662518,null,-8.4400708495761592,-9.7367818701957276,-9.9231219191863147,-11.016118329104302,-11.931806628261029]
[]
[null,"ARITHMETICAL PRICE CHANGE"]
[]
[null,"ECN CHARGES ARITHMETICAL PRICE CHANGE",null,null,1.4548637361671259,5.1026269932789643E-2,0.21644055807639434,6.8613622514666524E-3,-3.9261079195223487E-2,null,1.1283908114215131,0.50904005572509936,-2.1982685848603103E-2,7.3328463525983338E-3,-3.8654073915657776E-2,null,0.32647292474561285,-0.45801378579230972,0.23842324392499745,-4.7148410113168147E-4,-6.070052795657116E-4]
[null,"LDZ & CUSTOMER CHARGES ARITHMETICAL PRICE CHANGE",null,null,-2.7116678295972564E-2,2.6029710004795897E-2,-6.182567737055996E-2,-6.2271236471573878E-3,-1.5467765890057016E-4,null,4.2853829684165283E-4,2.128997125891539E-3,-4.0029993029312573E-2,-1.6261069014442482E-3,4.0839078242057283E-3,null,-2.7545216592814219E-2,2.3900712878904357E-2,-2.1795684341247387E-2,-4.60101674571314E-3,-4.2385854831062985E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,"TOTAL DISTRIBUTION CHARGES ARITHMETICAL PRICE CHANGE",null,null,1.6510442964944257E-2,2.9603009620725568E-2,-4.5822478046965216E-2,-5.5093170469604161E-3,-3.8226440093251718E-3,null,3.5049804429696907E-2,3.4529055546220482E-2,-4.1570738418847127E-2,-4.5344176201009886E-4,9.266690273062525E-4,null,-1.853936146475265E-2,-4.9260459254949138E-3,-4.2517396281180897E-3,-5.0558752849503173E-3,-4.7493130366314243E-3]
[null,null,null,null,627.54340167700786,640.72424221997687,627.10258133163779,630.22699432885588,637.5125647911467,null,627.54340167700786,640.72424221997687,627.10258133163779,630.22699432885588,637.5125647911467,null,0,0,0,0,0]

{"sheet":"LO MOD0186 RIIO2","index":7,"n_rows":76,"n_cols":23,"rows_kept":76,"cut":false,"hidden":false,"merged":[[69,1,69,8],[2,10,2,14],[2,16,2,20],[2,1,2,2],[2,4,2,8],[6,1,6,2],[18,1,18,2]]}
[]
[]
[null,"CADENT GAS LTD\nLONDON DISTRIBUTION NETWORK",null,null,"RIIO-GD2 - Sept-20",null,null,null,null,null,"RIIO-GD2 - June-20",null,null,null,null,null,"Movement"]
[]
[null,"DESCRIPTION","PRICE BASE",null,"2021/22","2022/23","2023/24","2024/25","2025/26",null,"2021/22","2022/23","2023/24","2024/25","2025/26",null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
[]
[null,"KEY FINANCIAL PARAMETERS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTES ON CHANGES FROM LAST FORECAST"]
[]
[null,"INFLATION INDEX (2018/19 TO OUTTURN)",null,null,1.0590808425165079,1.0813215402093543,1.1040292925537509,1.1272139076973788,1.1508853997590243,null,1.0586108585642655,1.0768718958744994,1.0962555900002402,1.1159881906202449,1.1360759780514091,null,4.6998395224240319E-4,4.4496443348549519E-3,7.7737025535107307E-3,1.1225717077133934E-2,1.4809421707615122E-2,null,"LATEST HM TREASURY REPORT"]
[null,"COST OF EQUITY",null,null,3.9259999999999996E-2,3.9369999999999995E-2,3.9469999999999998E-2,3.9619999999999995E-2,3.9779999999999996E-2,null,4.2741620748301866E-2,4.289554656129576E-2,4.3021284755714609E-2,4.3123414767420244E-2,4.3218133167267511E-2,null,-3.4816207483018696E-3,-3.5255465612957643E-3,-3.5512847557146107E-3,-3.5034147674202487E-3,-3.4381331672675153E-3,null,"BASED ON DRAFT DETERMINATION OUTPUT"]
[null,"COST OF DEBT",null,null,1.9730000000000001E-2,1.83E-2,1.7170000000000001E-2,1.6289999999999999E-2,1.5599999999999999E-2,null,2.0299999999999999E-2,1.9599999999999999E-2,1.9099999999999999E-2,1.8800000000000001E-2,1.8599999999999998E-2,null,-5.6999999999999759E-4,-1.2999999999999991E-3,-1.9299999999999977E-3,-2.5100000000000018E-3,-2.9999999999999992E-3,null,"BASED ON DRAFT DETERMINATION OUTPUT"]
[null,"WEIGHTED AVERAGE COST OF CAPITAL (WACC)",null,null,2.7541999999999997E-2,2.6727999999999998E-2,2.6090000000000002E-2,2.5621999999999999E-2,2.5271999999999996E-2,null,2.9276648299320744E-2,2.8918218624518304E-2,2.8668513902285843E-2,2.8529365906968099E-2,2.8447253266907002E-2,null,-1.7346482993207471E-3,-2.1902186245183058E-3,-2.5785139022858408E-3,-2.9073659069680999E-3,-3.1752532669070063E-3,null,"BASED ON DRAFT DETERMINATION OUTPUT"]
[null,"OUTPERFORMANCE",null,null,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,null,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,null,-2.5000000000000001E-3,-2.5000000000000001E-3,-2.5000000000000001E-3,-2.5000000000000001E-3,-2.5000000000000001E-3,null,"BASED ON DRAFT DETERMINATION OUTPUT"]
[null,"GEARING",null,null,0.6,0.6,0.6,0.6,0.6,null,0.6,0.6,0.6,0.6,0.6,null,0,0,0,0,0,null,"NO CHANGE, BASED ON DRAFT DETERMINATION"]
[null,"CORPORATION TAX RATE",null,null,0.19,0.19,0.19,0.19,0.19,null,0.19,0.19,0.19,0.19,0.19,null,0,0,0,0,0,null,"NO CHANGE, BASED ON DRAFT DETERMINATION"]
[null,"OPEX / CAPEX CAPITALISATION RATE (NETWORK SPECIFIC)",null,null,0.23799999999999999,0.23799999999999999,0.23799999999999999,0.23799999999999999,0.23799999999999999,null,0.23799999999999999,0.23799999999999999,0.23799999999999999,0.23799999999999999,0.23799999999999999,null,0,0,0,0,0,null,"NO CHANGE   "]
[null,"REPEX CAPITALISATION RATE",null,null,1,1,1,1,1,null,1,1,1,1,1,null,0,0,0,0,0,null,"NO CHANGE, BASED ON DRAFT DETERMINATION"]
[]
[null,"RIIO-GD2 BASE REVENUE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTES ON CHANGES FROM LAST FORECAST"]
[]
[null,"REGULATORY DEPRECIATION (PRE RIIO-GD2 RAV)","2018/19",null,76.661687471939032,74.477759984478013,72.293832497016993,70.109905009555973,67.925977522094954,null,76.661687471939032,74.477759984478013,72.293832497016993,70.109905009555973,67.925977522094954,null,0,0,0,0,0]
[null,"BUSINESS RATES","2018/19",null,48.176399769449795,48.176399769449795,48.176399769449795,48.176399769449795,48.176399769449795,null,48.176399769449795,48.176399769449795,48.176399769449795,48.176399769449795,48.176399769449795,null,0,0,0,0,0,null,"THIS IS NOT ALIGNED TO OFGEM DRAFT DETERMINTION FOLLOWING RATES REVALUATION BEING DELAYED"]
[null,"EXIT CAPACITY","2018/19",null,27.410417948161225,28.432795545631517,30.022368250389189,29.785195730506601,28.202626567576711,null,27.410417948161225,28.432795545631517,30.022368250389189,29.785195730506601,28.202626567576711,null,0,0,0,0,0,null,"THIS IS NOT ALIGNED TO OFGEM DRAFT DETERMINTION FOLLOWING MOD0678A IMPLEMENTATION"]
[null,"SHRINKAGE","2018/19",null,3.0295173168978846,2.8720797870683215,2.7081063726214181,2.5437332630291278,2.3816496196937758,null,3.0295173168978846,2.8720797870683215,2.7081063726214181,2.5437332630291278,2.3816496196937758,null,0,0,0,0,0]
[null,"LICENCE FLOS","2018/19",null,1.6886412821808114,1.6886412821808114,1.6886412821808114,1.6886412821808114,1.6886412821808114,null,1.6886412821808114,1.6886412821808114,1.6886412821808114,1.6886412821808114,1.6886412821808114,null,0,0,0,0,0]
[null,"XOSERVE","2018/19",null,2.8040000000000003,2.9620000000000002,2.0169999999999999,2.0049999999999999,1.9980000000000002,null,2.8040000000000003,2.9620000000000002,2.0169999999999999,2.0049999999999999,1.9980000000000002,null,0,0,0,0,0]
[null,"ESTABLISHED PENSION DEFICIT FUNDING","2018/19",null,10.390293312550211,9.04973884833956,0,0,0,null,10.390293312550211,9.04973884833956,0,0,0,null,0,0,0,0,0]
[null,"OTHER PASS THROUGH COSTS","2018/19",null,3.0603999999999871,3.0131000000000085,2.9647000000000077,2.9184999999999945,2.8744999999999976,null,0,0,0,0,0,null,3.0603999999999871,3.0131000000000085,2.9647000000000077,2.9184999999999945,2.8744999999999976,null,"INTRODUCTION OF CARBON MONOXIDE PASS THROUGH ITEM"]
[null,"FAST FUNDED TOTEX","2018/19",null,126.32082687869199,127.49016043395717,127.40204219793627,119.21869476790994,113.71354317136887,null,126.32082687869199,127.49016043395717,127.40204219793627,119.21869476790994,113.71354317136887,null,0,0,0,0,0,null,"JUNE REFLECTED CADENT BUSINESS PLAN SUBMISSION, SEPTEMBER'S TOTEX ALIGNED TO DRAFT DETERMINATION"]
[null,"SLOW FUNDED TOTEX","2018/19",null,46.158438937792539,52.535991861428784,60.224969940349865,67.794690032277757,75.019553817676965,null,46.158438937792539,52.535991861428784,60.224969940349865,67.794690032277757,75.019553817676965,null,0,0,0,0,0,null,"JUNE REFLECTED CADENT BUSINESS PLAN SUBMISSION, SEPTEMBER'S TOTEX ALIGNED TO DRAFT DETERMINATION"]
[null,"DEBT FINANCING","2018/19",null,26.210388785836564,24.045993277093146,22.638719648144274,21.50340472971919,20.548422496360818,null,28.673591849656152,28.430562774086269,28.581049427906837,28.924382177059005,29.310518523970551,null,-2.4632030638195879,-4.384569496993123,-5.9423297797625629,-7.4209774473398156,-8.7620960276097328,null,"BASED ON DRAFT DETERMINATION"]
[null,"EQUITY FINANCING","2018/19",null,40.359454407312619,34.487823508894621,34.694244399621603,34.866580535767305,34.932318243813384,null,46.071896832590703,41.481106436723117,42.917747506287412,44.231139344421734,45.40307859392906,null,-5.7124424252780841,-6.9932829278284956,-8.2235031066658095,-9.3645588086544294,-10.470760350115675,null,"BASED ON DRAFT DETERMINATION"]
[null,"ADDITIONAL INCOME","2018/19",null,2.3541536822377802,2.4175648617420298,2.4939833706724994,2.5642182781080685,2.6263905487428811,null,4.7083073644755604,4.8351297234840596,4.9879667413449988,5.1284365562161369,5.2527810974857623,null,-2.3541536822377802,-2.4175648617420298,-2.4939833706724994,-2.5642182781080685,-2.6263905487428811,null,"ASSUMES 25 BPS OUTPERFORMANCE PER OFGEM GUIDANCE"]
[null,"ADJUSTMENT FROM PREVIOUS PRICE CONTROL","2018/19",null,0,-16.066621984412151,0,0,0,null,0,-16.066621984412151,0,0,0,null,0,0,0,0,0,null,"ALLOWANCE FOR RIIO1 CLOSE OUT COST TBD BY OFGEM"]
[null,"TAX ALLOWANCE","2018/19",null,22.158315912728469,21.069917907633293,20.814322207095465,19.626086342977285,18.909064099236648,null,23.577501755282206,23.118558192080386,23.416394295944627,22.748024704456725,22.516166015265622,null,-1.4191858425537376,-2.0486402844470923,-2.6020720888491624,-3.1219383614794403,-3.6071019160289737,null,"REFLECTS DECREASE IN OTHER REVENUE LINES"]
[null,"BASE REVENUE (BEFORE TIMING DIFFERENCES)","2018/19",null,436.78293570577893,416.65334508348491,428.13932993547814,422.80104974148179,418.9970871381957,null,445.67152071966802,429.48430265449559,444.43651828142822,442.35424263706352,441.5889359806929,null,-8.8885850138890987,-12.830957571010686,-16.297188345950076,-19.553192895581731,-22.5918488424972]
[]
[null,"MODT TIMING ADJUSTMENT","2018/19",null,2.7028497473811846,8.272862868942509,-0.93913194564204705,-0.31907505498900984,-0.2566168833378828,null,16.813362684290706,13.73449717911884,-1.057103689161941,-0.38925663890655293,-0.31598284544208938,null,-14.110512936909521,-5.4616343101763309,0.11797174351989392,7.0181583917543089E-2,5.9365962104206582E-2,null,"RELATES TO UPDATED TOTEX PERFORMANCE IN LAST TWO YEARS OF RIIO-GD1"]
[null,"INFLATION TRUE UP","2018/19",null,-4.048825556619537,-4.0139668440874043,0,-1.7509583982171849E-13,-8.4714639792083185E-14,null,-4.0475490803338658,-3.3437797121326214,0,0,9.9122753437711806E-14,null,-1.2764762856711798E-3,-0.67018713195478297,0,-1.7509583982171849E-13,-1.8383739322979499E-13,null,"REDUCED INFLATION IN FINAL YEARS OF RIIO-1"]
[null,"TOTAL BASE REVENUE","2018/19",null,435.4369598965406,420.91224110834003,427.20019798983611,422.48197468649261,418.74047025485777,null,458.4373343236249,439.87502012148178,443.3794145922663,441.96498599815698,441.27295313525093,null,-23.000374427084296,-18.962779013141756,-16.179216602430188,-19.48301131166437,-22.532482880393161]
[null,"BASE REVENUE NOMINAL","NOMINAL",null,461.16294235005506,455.14147284824134,471.64153236554108,476.22755761806644,481.9222935045438,null,485.30674008624578,473.68904686605367,486.05716173780598,493.22770504158507,501.31960182076381,null,-24.14379773619072,-18.547574017812337,-14.415629372264902,-17.000147423518627,-19.397308316220006]
[]
[null,"LAGGED RIIO-GD1 REVENUE ADJUSTMENTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTES ON CHANGES FROM LAST FORECAST"]
[]
[null,"BUSINESS RATES PASS THROUGH ADJUSTMENT","NOMINAL",null,12.176192016484771,20.285093080834876,null,null,null,null,12.159713328090758,20.229343503824921,null,null,null,null,1.6478688394013119E-2,5.5749577009954976E-2,0,0,0]
[null,"LICENCE FLO PASS THROUGH ADJUSTMENT","NOMINAL",null,0.20375662664310512,0.20793003822229744,null,null,null,null,0.20360199640583398,0.20735858352734671,null,null,null,null,1.5463023727113612E-4,5.7145469495073486E-4,0,0,0]
[null,"NTS PENSION DEFICIT PASS THROUGH ADJUSTMENT","NOMINAL",null,-5.5895634364900557,-5.672836868497928,null,null,null,null,-5.5853215350870613,-5.657246195356576,null,null,null,null,-4.241901402994408E-3,-1.5590673141351985E-2,0,0,0]
[null,"PASS THROUGH ADJUSTMENTS","NOMINAL",null,6.7903852066378212,14.820186250559246,null,null,null,null,6.7779937894095301,14.779455891995694,null,null,null,null,1.2391417228291068E-2,4.0730358563552116E-2,0,0,0,null,"UPDATES TO INFLATION AT THE END OF RIIO-1 PLUS AN INCENTIVE PERFORMANCE RESULTS UPDATE"]
[]
[null,"EXIT CAPACITY COST PASS THROUGH ADJUSTMENT","NOMINAL",null,-6.4171865828154226,0.71172018516876634,null,null,null,null,-6.4123166009146502,0.66418174129872853,null,null,null,null,-4.8699819007724798E-3,4.7538443870037805E-2,0,0,0]
[null,"EXIT CAPACITY INCENTIVE REVENUE ADJUSTMENT","NOMINAL",null,3.5965447854734993,2.6483716222760476,null,null,null,null,3.5974544526544512,2.6473890630653609,null,null,null,null,-9.0966718095186749E-4,9.8255921068668428E-4,0,0,0]
[null,"EXIT CAPACITY ADJUSTMENTS","NOMINAL",null,-2.8206417973419233,3.3600918074448138,null,null,null,null,-2.814862148260199,3.3115708043640897,null,null,null,null,-5.7796490817243473E-3,4.8521003080724157E-2,0,0,0,null,"UPDATES TO INFLATION AT THE END OF RIIO-1 PLUS AN INCENTIVE PERFORMANCE RESULTS UPDATE"]
[]
[null,"SHRINKAGE COST PASS THROUGH ADJUSTMENT","NOMINAL",null,-3.4587706711699573,-3.7708978733455494,null,null,null,null,-2.1735635754067566,-2.1277378190297265,null,null,null,null,-1.2852070957632007,-1.6431600543158229,0,0,0]
[null,"SHRINKAGE INCENTIVE ADJUSTMENT","NOMINAL",null,0.4940314765626585,0.46332976606763859,null,null,null,null,0.41590128999999992,0.74328543999999996,null,null,null,null,7.8130186562658577E-2,-0.27995567393236137,0,0,0]
[null,"SHRINKAGE ADJUSTMENTS","NOMINAL",null,-2.964739194607299,-3.3075681072779108,null,null,null,null,-1.7576622854067567,-1.3844523790297265,null,null,null,null,-1.2070769092005422,-1.9231157282481843,0,0,0,null,"UPDATES TO INFLATION AT THE END OF RIIO-1 PLUS AN INCENTIVE PERFORMANCE RESULTS UPDATE"]
[]
[null,"ENVIRONMENTAL EMISSIONS INCENTIVE","NOMINAL",null,2.384241321611698,2.6769145772369312,null,null,null,null,3.7226613100000003,3.1106295400000001,null,null,null,null,-1.3384199883883023,-0.43371496276306898,0,0,0]
[null,"CUSTOMER SATISFACTION INCENTIVE REVENUE","NOMINAL",null,2.2615347182409082,2.2386508560858998,null,null,null,null,1.3557368486861874,2.2503251063743126,null,null,null,null,0.90579786955472086,-1.1674250288412846E-2,0,0,0]
[null,"COMPLAINTS INCENTIVE REVENUE","NOMINAL",null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,0,0,0]
[null,"STAKEHOLDER INCENTIVE REVENUE","NOMINAL",null,0.87982240588846772,0.8885783654412307,null,null,null,null,0.88777439824368753,0.88248043327518777,null,null,null,null,-7.9519923552198168E-3,6.0979321660429298E-3,0,0,0]
[null,"DISCRETIONARY REWARD SCHEME","NOMINAL",null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,0,0,0]
[null,"NETWORK INNOVATION ALLOWANCE","NOMINAL",null,1.5462580300741013,1.5787294487056562,1.6118827671284759,1.6457323052381736,1.6802926836481753,null,2.1189154945022346,2.1137918444120549,2.1084283762474625,2.1041957334144716,2.1011725214060815,null,-0.57265746442813326,-0.53506239570639869,-0.4965456091189866,-0.45846342817629804,-0.42087983775790616,null,"UPDATES TO INFLATION AT THE END OF RIIO-1 PLUS CHANGES TO BASE REVENUE NUMBERS"]
[null,"INCENTIVES ADJUSTMENTS","NOMINAL",null,7.0718564758151752,7.3828732474697176,1.6118827671284759,1.6457323052381736,1.6802926836481753,null,8.0850880514321091,8.3572269240615551,2.1084283762474625,2.1041957334144716,2.1011725214060815,null,-1.0132315756169339,-0.97435367659183747,-0.4965456091189866,-0.45846342817629804,-0.42087983775790616,null,"UPDATES TO INFLATION AT THE END OF RIIO-1 PLUS AN INCENTIVE PERFORMANCE RESULTS UPDATE"]
[]
[null,"CORRECTION TERM","NOMINAL",null,-2.6169252200000002,1.7281628899999999,null,null,null,null,-2.5630565999999999,1.48784625,null,null,null,null,-5.3868620000000256E-2,0.24031663999999986,0,0,0,null,"REFLECTS CHANGES TO COLLECTED INCOME"]
[]
[null,"MAXIMUM ALLOWED REVENUE","NOMINAL",null,466.62287782055881,479.12521893643719,473.25341513266955,477.87328992330464,483.60258618819199,null,493.03424089342059,500.24069435744542,488.16559011405343,495.33190077499967,503.42077434216981,null,-26.411363072861775,-21.115475421008227,-14.912174981383885,-17.458610851695028,-19.818188153977815]
[]
[null,"ARITHMETICAL PRICE CHANGE"]
[]
[null,"ECN CHARGES ARITHMETICAL PRICE CHANGE",null,null,0.42003029824707816,0.38917217724084602,5.1981389026685372E-2,1.1215004983696927E-2,-3.4967768361238161E-2,null,0.41558711503482176,0.38346778798799064,5.1654475006974523E-2,9.5219354831943097E-3,-3.6525139385152922E-2,null,4.4431832122563963E-3,5.7043892528553797E-3,3.269140197108486E-4,1.693069500502617E-3,1.5573710239147609E-3]
[null,"LDZ & CUSTOMER CHARGES ARITHMETICAL PRICE CHANGE",null,null,-7.8050326686053073E-4,8.0891327057294269E-3,-1.7066794889279008E-2,9.2010061603868196E-3,1.4981123073709333E-2,null,5.2457968375438153E-2,-3.5641202568548859E-3,-2.9659587525363237E-2,1.458545834283939E-2,1.9664913200005137E-2,null,-5.3238471642298682E-2,1.1653252962584314E-2,1.2592792636084229E-2,-5.3844521824525701E-3,-4.6837901262958039E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,"TOTAL DISTRIBUTION CHARGES ARITHMETICAL PRICE CHANGE",null,null,1.048707578444927E-2,2.5074007696020823E-2,-1.3974496681422397E-2,8.0427097093719833E-3,1.0269916216839833E-2,null,6.4997145088757521E-2,1.418053091860067E-2,-2.4574595010366306E-2,1.4244074958110401E-2,1.5894202640586379E-2,null,-5.4510069304308253E-2,1.0893476777420153E-2,1.0600098328943909E-2,-6.2013652487384174E-3,-5.6242864237465457E-3]
[null,null,null,null,455.41421053984243,456.41421053984197,457.41421053984197,458.41421053984197,459.41421053984197,null,455.41421053984243,481.53312458344283,476.75065168294998,484.24182857345124,494.3822273026197,null,0]

{"sheet":"NW MOD0186 RIIO2","index":8,"n_rows":76,"n_cols":23,"rows_kept":76,"cut":false,"hidden":false,"merged":[[69,1,69,8],[2,10,2,14],[2,16,2,20],[2,1,2,2],[2,4,2,8],[6,1,6,2],[18,1,18,2]]}
[]
[]
[null,"CADENT GAS LTD\nNORTH WEST DISTRIBUTION NETWORK",null,null,"RIIO-GD2 - Sept-20",null,null,null,null,null,"RIIO-GD2 - June-20",null,null,null,null,null,"Movement"]
[]
[null,"DESCRIPTION","PRICE BASE",null,"2021/22","2022/23","2023/24","2024/25","2025/26",null,"2021/22","2022/23","2023/24","2024/25","2025/26",null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
[]
[null,"KEY FINANCIAL PARAMETERS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTES ON CHANGES FROM LAST FORECAST"]
[]
[null,"INFLATION INDEX (2018/19 TO OUTTURN)",null,null,1.0590808425165079,1.0813215402093543,1.1040292925537509,1.1272139076973788,1.1508853997590243,null,1.0586108585642655,1.0768718958744994,1.0962555900002402,1.1159881906202449,1.1360759780514091,null,4.6998395224240319E-4,4.4496443348549519E-3,7.7737025535107307E-3,1.1225717077133934E-2,1.4809421707615122E-2,null,"LATEST HM TREASURY REPORT"]
[null,"COST OF EQUITY",null,null,3.9259999999999996E-2,3.9369999999999995E-2,3.9469999999999998E-2,3.9619999999999995E-2,3.9779999999999996E-2,null,4.2741620748301866E-2,4.289554656129576E-2,4.3021284755714609E-2,4.3123414767420244E-2,4.3218133167267511E-2,null,-3.4816207483018696E-3,-3.5255465612957643E-3,-3.5512847557146107E-3,-3.5034147674202487E-3,-3.4381331672675153E-3,null,"BASED ON DRAFT DETERMINATION OUTPUT"]
[null,"COST OF DEBT",null,null,1.9730000000000001E-2,1.83E-2,1.7170000000000001E-2,1.6289999999999999E-2,1.5599999999999999E-2,null,2.0299999999999999E-2,1.9599999999999999E-2,1.9099999999999999E-2,1.8800000000000001E-2,1.8599999999999998E-2,null,-5.6999999999999759E-4,-1.2999999999999991E-3,-1.9299999999999977E-3,-2.5100000000000018E-3,-2.9999999999999992E-3,null,"BASED ON DRAFT DETERMINATION OUTPUT"]
[null,"WEIGHTED AVERAGE COST OF CAPITAL (WACC)",null,null,2.7541999999999997E-2,2.6727999999999998E-2,2.6090000000000002E-2,2.5621999999999999E-2,2.5271999999999996E-2,null,2.9276648299320744E-2,2.8918218624518304E-2,2.8668513902285843E-2,2.8529365906968099E-2,2.8447253266907002E-2,null,-1.7346482993207471E-3,-2.1902186245183058E-3,-2.5785139022858408E-3,-2.9073659069680999E-3,-3.1752532669070063E-3,null,"BASED ON DRAFT DETERMINATION OUTPUT"]
[null,"OUTPERFORMANCE",null,null,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,null,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,null,-2.5000000000000001E-3,-2.5000000000000001E-3,-2.5000000000000001E-3,-2.5000000000000001E-3,-2.5000000000000001E-3,null,"BASED ON DRAFT DETERMINATION OUTPUT"]
[null,"GEARING",null,null,0.6,0.6,0.6,0.6,0.6,null,0.6,0.6,0.6,0.6,0.6,null,0,0,0,0,0,null,"NO CHANGE, BASED ON DRAFT DETERMINATION"]
[null,"CORPORATION TAX RATE",null,null,0.19,0.19,0.19,0.19,0.19,null,0.19,0.19,0.19,0.19,0.19,null,0,0,0,0,0,null,"NO CHANGE, BASED ON DRAFT DETERMINATION"]
[null,"OPEX / CAPEX CAPITALISATION RATE (NETWORK SPECIFIC)",null,null,0.28652,0.28652,0.28652,0.28652,0.28652,null,0.28652,0.28652,0.28652,0.28652,0.28652,null,0,0,0,0,0,null,"NO CHANGE   "]
[null,"REPEX CAPITALISATION RATE",null,null,1,1,1,1,1,null,1,1,1,1,1,null,0,0,0,0,0,null,"NO CHANGE, BASED ON DRAFT DETERMINATION"]
[]
[null,"RIIO-GD2 BASE REVENUE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTES ON CHANGES FROM LAST FORECAST"]
[]
[null,"REGULATORY DEPRECIATION (PRE RIIO-GD2 RAV)","2018/19",null,81.760660720961738,79.430072792916377,77.09948486487103,74.768896936825655,72.438309008780294,null,81.760660720961738,79.430072792916377,77.09948486487103,74.768896936825655,72.438309008780294,null,0,0,0,0,0]
[null,"BUSINESS RATES","2018/19",null,47.676856370612327,47.676856370612327,47.676856370612327,47.676856370612327,47.676856370612327,null,47.676856370612327,47.676856370612327,47.676856370612327,47.676856370612327,47.676856370612327,null,0,0,0,0,0,null,"THIS IS NOT ALIGNED TO OFGEM DRAFT DETERMINTION FOLLOWING RATES REVALUATION BEING DELAYED"]
[null,"EXIT CAPACITY","2018/19",null,32.466614616174084,33.455860513829016,35.45181762364988,35.268983989583205,33.493193921197658,null,32.466614616174084,33.455860513829016,35.45181762364988,35.268983989583205,33.493193921197658,null,0,0,0,0,0,null,"THIS IS NOT ALIGNED TO OFGEM DRAFT DETERMINTION FOLLOWING MOD0678A IMPLEMENTATION"]
[null,"SHRINKAGE","2018/19",null,4.2182512222946409,4.0266092864402392,3.8365934637207704,3.648324828201408,3.4609235785005397,null,4.2182512222946409,4.0266092864402392,3.8365934637207704,3.648324828201408,3.4609235785005397,null,0,0,0,0,0]
[null,"LICENCE FEES","2018/19",null,1.994343302159814,1.994343302159814,1.994343302159814,1.9943433021598143,1.9943433021598143,null,1.994343302159814,1.994343302159814,1.994343302159814,1.9943433021598143,1.9943433021598143,null,0,0,0,0,0]
[null,"XOSERVE","2018/19",null,3.3210000000000002,3.508,2.3889999999999998,2.3740000000000001,2.355,null,3.3210000000000002,3.508,2.3889999999999998,2.3740000000000001,2.355,null,0,0,0,0,0]
[null,"ESTABLISHED PENSION DEFICIT FUNDING","2018/19",null,12.050919761537457,10.503992747208995,0,0,0,null,12.050919761537457,10.503992747208995,0,0,0,null,0,0,0,0,0]
[null,"OTHER PASS THROUGH COSTS","2018/19",null,2.5648000000000053,2.5284999999999798,2.4932999999999907,2.4591999999999956,2.4261999999999802,null,0,0,0,0,0,null,2.5648000000000053,2.5284999999999798,2.4932999999999907,2.4591999999999956,2.4261999999999802,null,"INTRODUCTION OF CARBON MONOXIDE PASS THROUGH ITEM"]
[null,"FAST FUNDED TOTEX","2018/19",null,105.6648032374805,109.56055619164239,108.52026033388938,99.880058183040262,93.860310033034665,null,105.6648032374805,109.56055619164239,108.52026033388938,99.880058183040262,93.860310033034665,null,0,0,0,0,0,null,"JUNE REFLECTED CADENT BUSINESS PLAN SUBMISSION, SEPTEMBER'S TOTEX ALIGNED TO DRAFT DETERMINATION"]
[null,"SLOW FUNDED TOTEX","2018/19",null,38.907318263989652,45.506124085934211,50.814215004102181,55.922811749613032,60.730107918383254,null,38.907318263989652,45.506124085934211,50.814215004102181,55.922811749613032,60.730107918383254,null,0,0,0,0,0,null,"JUNE REFLECTED CADENT BUSINESS PLAN SUBMISSION, SEPTEMBER'S TOTEX ALIGNED TO DRAFT DETERMINATION"]
[null,"DEBT FINANCING","2018/19",null,27.177367997097239,25.503964776273392,23.934115135111576,22.662530703679522,21.58503279094214,null,27.992285096532374,27.468191784455858,26.999630021653356,26.743036496735133,26.558379949273984,null,-0.81491709943513513,-1.9642270081824655,-3.0655148865417807,-4.080505793055611,-4.973347158331844,null,"BASED ON DRAFT DETERMINATION"]
[null,"EQUITY FINANCING","2018/19",null,41.713261833368541,36.578910500615059,36.679461245694192,36.74603914384214,36.694555744601637,null,44.971808910506546,40.076976178392101,40.543063576282378,40.895427481878244,41.139914027046977,null,-3.2585470771380045,-3.498065677777042,-3.8636023305881864,-4.1493883380361041,-4.4453582824453406,null,"BASED ON DRAFT DETERMINATION"]
[null,"ADDITIONAL INCOME","2018/19",null,2.2982171672029867,2.3357305939163142,2.3559886580849354,2.3708365688594983,2.3797831495765225,null,4.5964343344059735,4.6714611878326284,4.7119773161698708,4.7416731377189967,4.759566299153045,null,-2.2982171672029867,-2.3357305939163142,-2.3559886580849354,-2.3708365688594983,-2.3797831495765225,null,"ASSUMES 25 BPS OUTPERFORMANCE PER OFGEM GUIDANCE"]
[null,"ADJUSTMENT FROM PREVIOUS PRICE CONTROL","2018/19",null,0,-1.1784494910807375,0,0,0,null,0,-1.1784494910807375,0,0,0,null,0,0,0,0,0,null,"ALLOWANCE FOR RIIO1 CLOSE OUT COST TBD BY OFGEM"]
[null,"TAX ALLOWANCE","2018/19",null,24.323451548993212,24.284883960836385,23.960340685609196,22.977574093496582,21.413878335525055,null,25.046759004310676,25.286093384012794,25.250783801900031,24.524464926487312,23.194613167692264,null,-0.72330745531746388,-1.0012094231764088,-1.2904431162908345,-1.54689083299073,-1.7807348321672087,null,"REFLECTS DECREASE IN OTHER REVENUE LINES"]
[null,"BASE REVENUE (BEFORE TIMING DIFFERENCES)","2018/19",null,426.13786604187226,425.71595563130381,417.20577668750525,408.75045586991348,400.5084941533139,null,430.66805484096579,431.98668833435607,425.2880256790109,418.43887740285544,411.66151757583486,null,-4.530188799093537,-6.2707327030522606,-8.0822489915056508,-9.688421532941959,-11.15302342252096]
[]
[null,"MODT TIMING ADJUSTMENT","2018/19",null,4.3184908878921613,9.8626669713791948,0.20865580797184624,-0.20294707300265419,-0.16306686427867878,null,3.9010143347563129,5.7963798902011803,0.37430275425419252,-9.144154094311889E-2,-7.1078565930665791E-2,null,0.41747655313584842,4.0662870811780145,-0.16564694628234627,-0.1115055320595353,-9.198829834801299E-2,null,"RELATES TO UPDATED TOTEX PERFORMANCE IN LAST TWO YEARS OF RIIO-GD1"]
[null,"INFLATION TRUE UP","2018/19",null,-4.147927774038763,-4.1304812539814177,0,-1.8108392165314744E-13,-8.5888775708328166E-14,null,-4.1466200537228257,-3.4390724136411883,0,0,9.5161887630289642E-14,null,-1.3077203159372885E-3,-0.69140884034022942,0,-1.8108392165314744E-13,-1.8105066333861781E-13,null,"REDUCED INFLATION IN FINAL YEARS OF RIIO-1"]
[null,"TOTAL BASE REVENUE","2018/19",null,426.30842915572566,431.4481413487016,417.41443249547712,408.54750879691068,400.34542728903511,null,430.42244912199931,434.34399581091606,425.66232843326509,418.34743586191234,411.59043900990429,null,-4.114019966273645,-2.8958544622144586,-8.2478959377879733,-9.7999270650016683,-11.245011720869172]
[null,"BASE REVENUE NOMINAL","NOMINAL",null,451.49509032213496,466.53416872364124,460.837760609707,460.52043387099496,460.75170712723855,null,455.64987841037356,467.73284223060676,466.63470699748501,466.8707979981545,467.5980105547859,null,-4.1547880882386039,-1.1986735069655197,-5.7969463877780072,-6.350364127159537,-6.8463034275473547]
[]
[null,"LAGGED RIIO-GD1 REVENUE ADJUSTMENTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTES ON CHANGES FROM LAST FORECAST"]
[]
[null,"BUSINESS RATES PASS THROUGH ADJUSTMENT","NOMINAL",null,15.820275322888387,15.079301221439648,null,null,null,null,15.804775393275552,15.03785873649019,null,null,null,null,1.5499929612834862E-2,4.1442484949458347E-2,0,0,0]
[null,"LICENCE FEE PASS THROUGH ADJUSTMENT","NOMINAL",null,0.25667561759741675,0.2601753383833163,null,null,null,null,0.25648082731106042,0.25946029778648544,null,null,null,null,1.9479028635632778E-4,7.1504059683086263E-4,0,0,0]
[null,"NTS PENSION DEFICIT PASS THROUGH ADJUSTMENT","NOMINAL",null,-6.5853711324925266,-6.6834801282091183,null,null,null,null,-6.5803735158873007,-6.6651119014222227,null,null,null,null,-4.9976166052259074E-3,-1.8368226786895647E-2,0,0,0]
[null,"PASS THROUGH ADJUSTMENTS","NOMINAL",null,9.4915798079932792,8.6559964316138469,null,null,null,null,9.4808827046993134,8.6322071328544538,null,null,null,null,1.0697103293965782E-2,2.3789298759393063E-2,0,0,0,null,"UPDATES TO INFLATION AT THE END OF RIIO-1 PLUS AN INCENTIVE PERFORMANCE RESULTS UPDATE"]
[]
[null,"EXIT CAPACITY COST PASS THROUGH ADJUSTMENT","NOMINAL",null,-6.6569621804515782,-7.1348446865446205,null,null,null,null,-6.6519102336343012,-7.1840467595502684,null,null,null,null,-5.0519468172769422E-3,4.9202073005647939E-2,0,0,0]
[null,"EXIT CAPACITY INCENTIVE REVENUE ADJUSTMENT","NOMINAL",null,5.1198537643460629,3.9607428633147057,null,null,null,null,5.8130551639029857,4.2801140436033887,null,null,null,null,-0.69320139955692284,-0.31937118028868294,0,0,0]
[null,"EXIT CAPACITY ADJUSTMENTS","NOMINAL",null,-1.5371084161055153,-3.1741018232299147,null,null,null,null,-0.83885506973131552,-2.9039327159468797,null,null,null,null,-0.69825334637419978,-0.270169107283035,0,0,0,null,"UPDATES TO INFLATION AT THE END OF RIIO-1 PLUS AN INCENTIVE PERFORMANCE RESULTS UPDATE"]
[]
[null,"SHRINKAGE COST PASS THROUGH ADJUSTMENT","NOMINAL",null,-4.3190033874718274,-4.7423640584313986,null,null,null,null,-2.6510160680034969,-2.5713765574348986,null,null,null,null,-1.6679873194683306,-2.1709875009965001,0,0,0]
[null,"SHRINKAGE INCENTIVE ADJUSTMENT","NOMINAL",null,0.58337620660187506,0.77414003748863514,null,null,null,null,0.31080759000000002,0.47945819000000001,null,null,null,null,0.27256861660187504,0.29468184748863513,0,0,0]
[null,"SHRINKAGE ADJUSTMENTS","NOMINAL",null,-3.7356271808699524,-3.9682240209427633,null,null,null,null,-2.3402084780034969,-2.0919183674348987,null,null,null,null,-1.3954187028664555,-1.8763056535078646,0,0,0,null,"UPDATES TO INFLATION AT THE END OF RIIO-1 PLUS AN INCENTIVE PERFORMANCE RESULTS UPDATE"]
[]
[null,"ENVIRONMENTAL EMISSIONS INCENTIVE","NOMINAL",null,2.5732235042358824,3.578154480328879,null,null,null,null,2.7779690399999999,4.8760438400000004,null,null,null,null,-0.20474553576411747,-1.2978893596711214,0,0,0]
[null,"CUSTOMER SATISFACTION INCENTIVE REVENUE","NOMINAL",null,2.3657927746595009,2.3668603119913318,null,null,null,null,2.0633402648381258,2.3680906738295633,null,null,null,null,0.30245250982137506,-1.2303618382314419E-3,0,0,0]
[null,"COMPLAINTS INCENTIVE REVENUE","NOMINAL",null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,0,0,0]
[null,"STAKEHOLDER INCENTIVE REVENUE","NOMINAL",null,0.92038274022032607,0.93776063663356035,null,null,null,null,0.92870132413581252,0.92866300576237515,null,null,null,null,-8.3185839154864549E-3,9.0976308711852027E-3,0,0,0]
[null,"DISCRETIONARY REWARD SCHEME","NOMINAL",null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,0,0,0]
[null,"NETWORK INNOVATION ALLOWANCE","NOMINAL",null,2.0652076429071897,2.1085770034082394,2.1528571204798133,2.1980671200098891,2.2442265295300969,null,1.5891866208766756,1.584616994779326,1.5815679396933466,1.5789000920895226,1.576646242339746,null,0.47602102203051411,0.52396000862891334,0.57128918078646662,0.61916702792036649,0.6675802871903509,null,"UPDATES TO INFLATION AT THE END OF RIIO-1 PLUS CHANGES TO BASE REVENUE NUMBERS"]
[null,"INCENTIVES ADJUSTMENTS","NOMINAL",null,7.9246066620228994,8.9913524323620102,2.1528571204798133,2.1980671200098891,2.2442265295300969,null,7.3591972498506131,9.7574145143712645,1.5815679396933466,1.5789000920895226,1.576646242339746,null,0.56540941217228635,-0.7660620820092543,0.57128918078646662,0.61916702792036649,0.6675802871903509,null,"UPDATES TO INFLATION AT THE END OF RIIO-1 PLUS AN INCENTIVE PERFORMANCE RESULTS UPDATE"]
[]
[null,"CORRECTION TERM","NOMINAL",null,-0.80523645999999993,1.7198243700000002,null,null,null,null,-0.7517469,1.6506300199999999,null,null,null,null,-5.3489559999999936E-2,6.9194350000000293E-2,0,0,0,null,"REFLECTS CHANGES TO COLLECTED INCOME"]
[]
[null,"MAXIMUM ALLOWED REVENUE","NOMINAL",null,462.83330473517566,478.75901611344443,462.99061773018684,462.71850099100487,462.99593365676867,null,468.5591479171888,482.77724281445069,468.21627493717853,468.44969809024388,469.17465679712558,null,-5.7258431820131364,-4.018226701006256,-5.2256572069916842,-5.7311970992390115,-6.1787231403569081]
[]
[null,"ARITHMETICAL PRICE CHANGE"]
[]
[null,"ECN CHARGES ARITHMETICAL PRICE CHANGE",null,null,-0.21778139407976069,3.9174979091200018E-2,0.33932838941472787,7.5211179195930969E-3,-3.8620592176437596E-2,null,-0.21534909751947751,3.628414473641612E-2,0.34307114477362699,8.4090311375200344E-3,-3.7597101066000345E-2,null,-2.4322965602831814E-3,2.8908343547838986E-3,-3.7427553588991191E-3,-8.879132179269375E-4,-1.023491110437251E-3]
[null,"LDZ & CUSTOMER CHARGES ARITHMETICAL PRICE CHANGE",null,null,-2.1163085723830157E-2,2.6035499317405779E-2,-6.4839490809371542E-2,-9.5520339123585686E-3,-3.9921927611043699E-3,null,-2.187600827128746E-2,2.6003394883006011E-2,-3.4501737061607009E-2,-3.8423585751882127E-3,-2.793325593134235E-3,null,7.1292254745730296E-4,3.2104434399767706E-5,-3.0337753747764533E-2,-5.7096753371703559E-3,-1.1988671679701349E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,"TOTAL DISTRIBUTION CHARGES ARITHMETICAL PRICE CHANGE",null,null,-3.7248881914112943E-2,2.619583618245426E-2,-4.1149319185161459E-2,-8.8010741372198682E-3,-7.6137659343276515E-3,null,-2.187600827128746E-2,2.6003394883006011E-2,-3.4501737061607009E-2,-3.8423585751882127E-3,-2.793325593134235E-3,null,-1.5372873642825483E-2,1.9244129944824898E-4,-6.6475821235544505E-3,-4.9587155620316554E-3,-4.820440341193416E-3]
[null,null,null,null,460.5540376427262,474.20143426101032,469.96086264494454,469.94035858283115,472.57705201114516,null,460.5540376427262,474.20143426101032,469.96086264494454,469.94035858283115,472.57705201114516,null,0,0,0,0,0]

{"sheet":"WM MOD0186 RIIO2","index":9,"n_rows":76,"n_cols":23,"rows_kept":76,"cut":false,"hidden":false,"merged":[[18,1,18,2],[2,10,2,14],[2,16,2,20],[2,1,2,2],[2,4,2,8],[6,1,6,2]]}
[]
[]
[null,"CADENT GAS LTD\nWEST MIDLANDS DISTRIBUTION NETWORK",null,null,"RIIO-GD2 - Sept-20",null,null,null,null,null,"RIIO-GD2 - June-20",null,null,null,null,null,"Movement"]
[]
[null,"DESCRIPTION","PRICE BASE",null,"2021/22","2022/23","2023/24","2024/25","2025/26",null,"2021/22","2022/23","2023/24","2024/25","2025/26",null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
[]
[null,"KEY FINANCIAL PARAMETERS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTES ON CHANGES FROM LAST FORECAST"]
[]
[null,"INFLATION INDEX (2018/19 TO OUTTURN)",null,null,1.0590808425165079,1.0813215402093543,1.1040292925537509,1.1272139076973788,1.1508853997590243,null,1.0586108585642655,1.0768718958744994,1.0962555900002402,1.1159881906202449,1.1360759780514091,null,4.6998395224240319E-4,4.4496443348549519E-3,7.7737025535107307E-3,1.1225717077133934E-2,1.4809421707615122E-2,null,"LATEST HM TREASURY REPORT"]
[null,"COST OF EQUITY",null,null,3.9259999999999996E-2,3.9369999999999995E-2,3.9469999999999998E-2,3.9619999999999995E-2,3.9779999999999996E-2,null,4.2741620748301866E-2,4.289554656129576E-2,4.3021284755714609E-2,4.3123414767420244E-2,4.3218133167267511E-2,null,-3.4816207483018696E-3,-3.5255465612957643E-3,-3.5512847557146107E-3,-3.5034147674202487E-3,-3.4381331672675153E-3,null,"BASED ON DRAFT DETERMINATION OUTPUT"]
[null,"COST OF DEBT",null,null,1.9730000000000001E-2,1.83E-2,1.7170000000000001E-2,1.6289999999999999E-2,1.5599999999999999E-2,null,2.0299999999999999E-2,1.9599999999999999E-2,1.9099999999999999E-2,1.8800000000000001E-2,1.8599999999999998E-2,null,-5.6999999999999759E-4,-1.2999999999999991E-3,-1.9299999999999977E-3,-2.5100000000000018E-3,-2.9999999999999992E-3,null,"BASED ON DRAFT DETERMINATION OUTPUT"]
[null,"WEIGHTED AVERAGE COST OF CAPITAL (WACC)",null,null,2.7541999999999997E-2,2.6727999999999998E-2,2.6090000000000002E-2,2.5621999999999999E-2,2.5271999999999996E-2,null,2.9276648299320744E-2,2.8918218624518304E-2,2.8668513902285843E-2,2.8529365906968099E-2,2.8447253266907002E-2,null,-1.7346482993207471E-3,-2.1902186245183058E-3,-2.5785139022858408E-3,-2.9073659069680999E-3,-3.1752532669070063E-3,null,"BASED ON DRAFT DETERMINATION OUTPUT"]
[null,"OUTPERFORMANCE",null,null,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,null,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,null,-2.5000000000000001E-3,-2.5000000000000001E-3,-2.5000000000000001E-3,-2.5000000000000001E-3,-2.5000000000000001E-3,null,"BASED ON DRAFT DETERMINATION OUTPUT"]
[null,"GEARING",null,null,0.6,0.6,0.6,0.6,0.6,null,0.6,0.6,0.6,0.6,0.6,null,0,0,0,0,0,null,"NO CHANGE, BASED ON DRAFT DETERMINATION"]
[null,"CORPORATION TAX RATE",null,null,0.19,0.19,0.19,0.19,0.19,null,0.19,0.19,0.19,0.19,0.19,null,0,0,0,0,0,null,"NO CHANGE, BASED ON DRAFT DETERMINATION"]
[null,"OPEX / CAPEX CAPITALISATION RATE (NETWORK SPECIFIC)",null,null,0.26604,0.26604,0.26604,0.26604,0.26604,null,0.26604,0.26604,0.26604,0.26604,0.26604,null,0,0,0,0,0,null,"NO CHANGE   "]
[null,"REPEX CAPITALISATION RATE",null,null,1,1,1,1,1,null,1,1,1,1,1,null,0,0,0,0,0,null,"NO CHANGE, BASED ON DRAFT DETERMINATION"]
[]
[null,"RIIO-GD2 BASE REVENUE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTES ON CHANGES FROM LAST FORECAST"]
[]
[null,"REGULATORY DEPRECIATION (PRE RIIO-GD2 RAV)","2018/19",null,61.73763667003935,59.973489260288083,58.209341850536831,56.445194440785563,54.681047031034311,null,61.73763667003935,59.973489260288083,58.209341850536831,56.445194440785563,54.681047031034311,null,0,0,0,0,0]
[null,"BUSINESS RATES","2018/19",null,35.812579985565691,35.812579985565691,35.812579985565691,35.812579985565691,35.812579985565691,null,35.812579985565691,35.812579985565691,35.812579985565691,35.812579985565691,35.812579985565691,null,0,0,0,0,0,null,"THIS IS NOT ALIGNED TO OFGEM DRAFT DETERMINTION FOLLOWING RATES REVALUATION BEING DELAYED"]
[null,"EXIT CAPACITY","2018/19",null,23.43170378484907,24.709827269183755,26.138644156350626,25.93700616715125,24.545790374678642,null,23.43170378484907,24.709827269183755,26.138644156350626,25.93700616715125,24.545790374678642,null,0,0,0,0,0,null,"THIS IS NOT ALIGNED TO OFGEM DRAFT DETERMINTION FOLLOWING MOD0678A IMPLEMENTATION"]
[null,"SHRINKAGE","2018/19",null,3.7885653248585687,3.6261547556209135,3.4619019014599819,3.2962661102205635,3.1339964788730268,null,3.7885653248585687,3.6261547556209135,3.4619019014599819,3.2962661102205635,3.1339964788730268,null,0,0,0,0,0]
[null,"LICENCE FEES","2018/19",null,1.4551416731562556,1.4551416731562556,1.4551416731562556,1.4551416731562556,1.4551416731562556,null,1.4551416731562556,1.4551416731562556,1.4551416731562556,1.4551416731562556,1.4551416731562556,null,0,0,0,0,0]
[null,"XOSERVE","2018/19",null,2.4239999999999999,2.5609999999999999,1.7440000000000002,1.7340000000000002,1.7190000000000001,null,2.4239999999999999,2.5609999999999999,1.7440000000000002,1.7340000000000002,1.7190000000000001,null,0,0,0,0,0]
[null,"ESTABLISHED PENSION DEFICIT FUNDING","2018/19",null,8.8164783716893194,7.6874991269271824,0,0,0,null,8.8164783716893194,7.6874991269271824,0,0,0,null,0,0,0,0,0]
[null,"OTHER PASS THROUGH COSTS","2018/19",null,1.9586999999999932,1.9300999999999817,1.9036999999999864,1.8761999999999972,1.8498000000000019,null,0,0,0,0,0,null,1.9586999999999932,1.9300999999999817,1.9036999999999864,1.8761999999999972,1.8498000000000019,null,"INTRODUCTION OF CARBON MONOXIDE PASS THROUGH ITEM"]
[null,"FAST FUNDED TOTEX","2018/19",null,82.344309077680279,83.4265106127731,85.492909078393453,79.59684116051244,77.871366251094443,null,82.344309077680279,83.4265106127731,85.492909078393453,79.59684116051244,77.871366251094443,null,0,0,0,0,0,null,"JUNE REFLECTED CADENT BUSINESS PLAN SUBMISSION, SEPTEMBER'S TOTEX ALIGNED TO DRAFT DETERMINATION"]
[null,"SLOW FUNDED TOTEX","2018/19",null,29.650832228968,34.644926913681246,39.304138497478974,43.905217896645325,48.300686074399572,null,29.650832228968,34.644926913681246,39.304138497478974,43.905217896645325,48.300686074399572,null,0,0,0,0,0,null,"JUNE REFLECTED CADENT BUSINESS PLAN SUBMISSION, SEPTEMBER'S TOTEX ALIGNED TO DRAFT DETERMINATION"]
[null,"DEBT FINANCING","2018/19",null,20.431059457492214,19.066826771423969,17.94110345794147,17.048581221623628,16.30823495455159,null,21.219351417356638,20.906184724360287,20.725878140837288,20.712836430120738,20.755124588004929,null,-0.78829195986442357,-1.839357952936318,-2.7847746828958186,-3.6642552084971101,-4.4468896334533383,null,"BASED ON DRAFT DETERMINATION"]
[null,"EQUITY FINANCING","2018/19",null,31.386019450211204,27.346483424078738,27.495063229856335,27.643330796019161,27.723999422737705,null,34.090608500709713,30.502796607579828,31.122300359832529,31.67405093566768,32.150456571599477,null,-2.7045890504985088,-3.1563131835010907,-3.6272371299761943,-4.0307201396485191,-4.4264571488617719,null,"BASED ON DRAFT DETERMINATION"]
[null,"ADDITIONAL INCOME","2018/19",null,1.7421470786007101,1.7777367962891402,1.808540849985802,1.8362443643724062,1.8597781888893306,null,3.4842941572014201,3.5554735925782803,3.617081699971604,3.6724887287448125,3.7195563777786611,null,-1.7421470786007101,-1.7777367962891402,-1.808540849985802,-1.8362443643724062,-1.8597781888893306,null,"ASSUMES 25 BPS OUTPERFORMANCE PER OFGEM GUIDANCE"]
[null,"ADJUSTMENT FROM PREVIOUS PRICE CONTROL","2018/19",null,0,-0.60690857657343444,0,0,0,null,0,-0.60690857657343444,0,0,0,null,0,0,0,0,0,null,"ALLOWANCE FOR RIIO1 CLOSE OUT COST TBD BY OFGEM"]
[null,"TAX ALLOWANCE","2018/19",null,18.72083197903704,17.683229074621572,18.223590237695142,17.194033074964189,16.949349828850327,null,19.343334315940133,18.603457581839621,19.423792243638129,18.648486820342615,18.63718157337917,null,-0.62250233690309287,-0.92022850721804872,-1.2002020059429874,-1.4544537453784265,-1.6878317445288431,null,"REFLECTS DECREASE IN OTHER REVENUE LINES"]
[null,"BASE REVENUE (BEFORE TIMING DIFFERENCES)","2018/19",null,323.70000508214775,321.09459708703622,318.99065491842049,313.78063689101646,312.21077026383085,null,327.59883550801442,326.85813352698079,326.50770958722131,322.89011034891297,322.78192697956416,null,-3.8988304258666631,-5.7635364399445734,-7.5170546688008244,-9.1094734578965131,-10.571156715733309]
[]
[null,"MODT TIMING ADJUSTMENT","2018/19",null,-1.6425526799902426,4.0055007642743767,-1.4614315930225923E-2,-9.8832615588704306E-2,-7.5307526851615569E-2,null,2.2500306615191934,3.0921638856764324,5.6607732221708146E-2,-4.9184815496856493E-2,-3.7005193280578351E-2,null,-3.892583341509436,0.91333687859794432,-7.1222048151934073E-2,-4.9647800091847813E-2,-3.8302333571037218E-2,null,"RELATES TO UPDATED TOTEX PERFORMANCE IN LAST TWO YEARS OF RIIO-GD1"]
[null,"INFLATION TRUE UP","2018/19",null,-3.1160308791259768,-3.0721113093732355,0,-1.3793742752127235E-13,-6.5822096313653474E-14,null,-3.1150484857086109,-2.5584355608863341,0,0,7.3007345947662873E-14,null,-9.8239341736583441E-4,-0.51367574848690145,0,-1.3793742752127235E-13,-1.3882944226131633E-13,null,"REDUCED INFLATION IN FINAL YEARS OF RIIO-1"]
[null,"TOTAL BASE REVENUE","2018/19",null,318.94142152303158,322.02798654193737,318.97604060249029,313.68180427542762,312.13546273697921,null,326.73381768382501,327.3918618517709,326.56431731944303,322.84092553341611,322.74492178628361,null,-7.7923961607934302,-5.3638753098335314,-7.5882767169527483,-9.1591212579884882,-10.609459049304405]
[null,"BASE REVENUE NOMINAL","NOMINAL",null,337.78474942002498,348.21579839804497,352.15889244796386,353.58649237086911,359.23214681101632,null,345.88396726025417,352.5590949661987,357.9979583560517,360.28666034420229,366.66275267947771,null,-8.099217840229187,-4.3432965681537326,-5.8390659080878322,-6.7001679733331798,-7.4306058684613845]
[]
[null,"LAGGED RIIO-GD1 REVENUE ADJUSTMENTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTES ON CHANGES FROM LAST FORECAST"]
[]
[null,"BUSINESS RATES PASS THROUGH ADJUSTMENT","NOMINAL",null,9.8981732182081927,9.3120123354962203,null,null,null,null,9.888037017302544,9.2864201064269931,null,null,null,null,1.0136200905648707E-2,2.5592229069227201E-2,0,0,0]
[null,"LICENCE FEE PASS THROUGH ADJUSTMENT","NOMINAL",null,0.18768477725122315,0.18973838428110465,null,null,null,null,0.18754234388786864,0.18921692575862853,null,null,null,null,1.4243336335451051E-4,5.2145852247612035E-4,0,0,0]
[null,"NTS PENSION DEFICIT PASS THROUGH ADJUSTMENT","NOMINAL",null,-4.7552781197498915,-4.8261223518053695,null,null,null,null,-4.7516693547440028,-4.8128587064950299,null,null,null,null,-3.6087650058886922E-3,-1.3263645310339633E-2,0,0,0]
[null,"PASS THROUGH ADJUSTMENTS","NOMINAL",null,5.3305798757095237,4.6756283679719557,null,null,null,null,5.3239100064464093,4.6627783256905921,null,null,null,null,6.6698692631144141E-3,1.285004228136355E-2,0,0,0,null,"UPDATES TO INFLATION AT THE END OF RIIO-1 PLUS AN INCENTIVE PERFORMANCE RESULTS UPDATE"]
[]
[null,"EXIT CAPACITY COST PASS THROUGH ADJUSTMENT","NOMINAL",null,-3.5567954269360325,-0.43982760862911674,null,null,null,null,-3.5540961865243057,-0.48157295574510955,null,null,null,null,-2.6992404117267554E-3,4.1745347115992815E-2,0,0,0]
[null,"EXIT CAPACITY INCENTIVE REVENUE ADJUSTMENT","NOMINAL",null,2.6758960013352873,2.1472077517201029,null,null,null,null,1.9349319674651355,1.4479046382303769,null,null,null,null,0.74096403387015175,0.69930311348972607,0,0,0]
[null,"EXIT CAPACITY ADJUSTMENTS","NOMINAL",null,-0.88089942560074519,1.7073801430909863,null,null,null,null,-1.6191642190591702,0.96633168248526724,null,null,null,null,0.73826479345842499,0.74104846060571905,0,0,0,null,"UPDATES TO INFLATION AT THE END OF RIIO-1 PLUS AN INCENTIVE PERFORMANCE RESULTS UPDATE"]
[]
[null,"SHRINKAGE COST PASS THROUGH ADJUSTMENT","NOMINAL",null,-3.8991873559021495,-4.2735118064285,null,null,null,null,-2.334160991027018,-2.2824120134375794,null,null,null,null,-1.5650263648751315,-1.9910997929909207,0,0,0]
[null,"SHRINKAGE INCENTIVE ADJUSTMENT","NOMINAL",null,0.57915891700511268,0.56110394720966883,null,null,null,null,0.26177202999999999,0.40209592,null,null,null,null,0.31738688700511269,0.15900802720966883,0,0,0]
[null,"SHRINKAGE ADJUSTMENTS","NOMINAL",null,-3.3200284388970367,-3.712407859218831,null,null,null,null,-2.0723889610270181,-1.8803160934375793,null,null,null,null,-1.2476394778700186,-1.8320917657812517,0,0,0,null,"UPDATES TO INFLATION AT THE END OF RIIO-1 PLUS AN INCENTIVE PERFORMANCE RESULTS UPDATE"]
[]
[null,"ENVIRONMENTAL EMISSIONS INCENTIVE","NOMINAL",null,1.8677278890638507,2.0897469402197206,null,null,null,null,3.8266528599999994,3.2247351099999992,null,null,null,null,-1.9589249709361487,-1.1349881697802786,0,0,0]
[null,"CUSTOMER SATISFACTION INCENTIVE REVENUE","NOMINAL",null,1.778115819894529,1.7440712133851837,null,null,null,null,0.63872788071950004,1.7621327269771878,null,null,null,null,1.139387939175029,-1.8061513592004141E-2,0,0,0]
[null,"COMPLAINTS INCENTIVE REVENUE","NOMINAL",null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,0,0,0]
[null,"STAKEHOLDER INCENTIVE REVENUE","NOMINAL",null,0.69175420611783067,0.69382617994589146,null,null,null,null,0.69800640442731265,0.69103244016056264,null,null,null,null,-6.2521983094819822E-3,2.7937397853288193E-3,0,0,0]
[null,"DISCRETIONARY REWARD SCHEME","NOMINAL",null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,0,0,0]
[null,"NETWORK INNOVATION ALLOWANCE","NOMINAL",null,1.2073521604688189,1.2327065558386632,1.2585933935112756,1.2850238547750121,1.3120093557252877,null,1.2357164552020676,1.2318337616908399,1.2303276486572698,1.2273638120441452,1.2249171195350295,null,-2.8364294733248752E-2,8.727941478232637E-4,2.8265744854005792E-2,5.7660042730866889E-2,8.7092236190258188E-2,null,"UPDATES TO INFLATION AT THE END OF RIIO-1 PLUS CHANGES TO BASE REVENUE NUMBERS"]
[null,"INCENTIVES ADJUSTMENTS","NOMINAL",null,5.5449500755450289,5.7603508893894588,1.2585933935112756,1.2850238547750121,1.3120093557252877,null,6.3991036003488801,6.9097340388285904,1.2303276486572698,1.2273638120441452,1.2249171195350295,null,-0.85415352480385121,-1.1493831494391316,2.8265744854005792E-2,5.7660042730866889E-2,8.7092236190258188E-2,null,"UPDATES TO INFLATION AT THE END OF RIIO-1 PLUS AN INCENTIVE PERFORMANCE RESULTS UPDATE"]
[]
[null,"CORRECTION TERM","NOMINAL",null,-3.59398689,1.4566451899999999,null,null,null,null,-3.6318788399999997,1.1418454499999999,null,null,null,null,3.7891949999999675E-2,0.31479973999999999,0,0,0,null,"REFLECTS CHANGES TO COLLECTED INCOME"]
[]
[null,"MAXIMUM ALLOWED REVENUE","NOMINAL",null,340.86536461678173,358.10339512927851,353.41748584147513,354.87151622564414,360.54415616674163,null,350.28354884696341,364.35946836976552,359.22828600470899,361.51402415624625,367.88766979901283,null,-9.4181842301816801,-6.2560732404870123,-5.8108001632338642,-6.6425079306021075,-7.3435136322711969]
[]
[null,"ARITHMETICAL PRICE CHANGE"]
[]
[null,"ECN CHARGES ARITHMETICAL PRICE CHANGE",null,null,8.9414469372729094E-2,0.22817399746433345,9.0234393986760239E-2,5.2534170772761991E-3,-4.163507397996722E-2,null,8.8566371663235791E-2,0.22441251657917585,9.1639951778000259E-2,5.074057767958517E-3,-4.1676660663083918E-2,null,8.4809770949330343E-4,3.7614808851575976E-3,-1.4055577912400197E-3,1.7935930931768217E-4,4.1586683116698331E-5]
[null,"LDZ & CUSTOMER CHARGES ARITHMETICAL PRICE CHANGE",null,null,-4.4856518874406559E-2,3.1325726476821941E-2,-2.8709635156490582E-2,-3.6063422292690085E-3,1.3407296348244668E-2,null,-1.5267367940114074E-2,-1.0145830869479436E-2,-1.0145830869479436E-2,-1.0145830869479436E-2,-1.0145830869479436E-2,null,-2.9589150934292485E-2,4.1471557346301376E-2,-1.8563804287011147E-2,6.5394886402104276E-3,2.3553127217724103E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,"TOTAL DISTRIBUTION CHARGES ARITHMETICAL PRICE CHANGE",null,null,-3.93336594915763E-2,4.2700961865110909E-2,-2.09557669806682E-2,-3.756213650786649E-3,8.1146387333447777E-3,null,-1.2176876248308682E-2,3.5111442549345298E-2,-1.9155662860008263E-2,1.289997065717711E-3,1.2557508883216724E-2,null,-2.7156783243267618E-2,7.589519315765611E-3,-1.8001041206599372E-3,-5.0462107165043599E-3,-4.4428701498719463E-3]
[null,null,null,null,338.62603098189038,345.21649022240302,352.15671979314999,354.56160220193226,362.5478659459356,null,338.62603098189038,345.21649022240302,352.15671979314999,354.56160220193226,362.5478659459356,null,0,0,0,0,0]