{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Front Sheet","NIC Funding Request"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":2,"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":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[16,3,16,4],[14,3,14,9]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Electricity Network Innovation Competition Full Submission "]
[null,null,null,null,null," Spreadsheet "]
[]
[null,null,null,null,null,"(2020 version 1.0)"]
[null,null,null,null,null,"Appendix A"]
[]
[]
[]
[null,null,"Licensee Name:","Electricity North West Ltd"]
[]
[null,null,"Submission Date:","2020-07-31"]
[]
[]
[]
[null,"Input cells",null," "]
[null,"Totals cells (of formula within worksheet)"]
[null,"Referencing to other worksheets"]
[null,"Check cells"]
[null,"No Input"]
[null,"Descriptions and pack data"]
[null,"Ofgem Input cells"]

{"sheet":"NIC Funding Request","index":1,"n_rows":94,"n_cols":12,"rows_kept":94,"cut":false,"hidden":false,"merged":[]}
["NIC Funding Request"]
[null," ","2020/21","2021/22","2022/23","2023/24","2024/25","2025/26","2026/27","Total"]
["Total Project Cost","From Project Cost Summary sheet"]
[null,"Labour",40633.801812972968,211279.45422469784,467238.63477800053,912867.54841877893,341776.08276811178,14847.151943361003,0,1988642.6739459229]
[null,"Equipment",0,321331.7,207245.1,35409,0,0,0,563985.80000000005]
[null,"Contractors",0,596891.4177618121,424005.7040590258,560018.14067984244,678677.35957959178,18467.822453061228,0,2278060.4445333332]
[null,"IT",0,1589221.4329411765,1531713.9770588232,416064.0675,157556.5625,0,0,3694556.0399999996]
[null,"IPR Costs",0,0,0,0,0,0,0,0]
[null,"Travel & Expenses",0,3687.5224499999999,2188.8537000000001,10208.40475,0,0,0,16084.7809]
["Payments to users & Contingency",null,0,130085.18061,292622.81796000001,214686.24147201754,91166.834157543868,0,0,728561.07419956138]
[null,"Decommissioning",0,0,0,0,0,29020.873870499996,0,29020.873870499996]
[null,"Other",0,93372.485000000001,73664.595000000001,98219.695000000007,94139.294999999984,16592.400000000001,0,375988.47000000003]
[null,"Total",40633.801812972968,2945869.1929876865,2998679.6825558497,2247473.0978206387,1363316.1340052474,78928.248266922223,0,9674900.1574493181]
[]
["External funding","Any funding that will be received from Project Partners and/or External Funders - from Project Cost Summary sheet"]
[null,"Labour"]
[null,"Equipment"]
[null,"Contractors"]
[null,"IT"]
[null,"IPR Costs"]
[null,"Travel & Expenses"]
["Payments to users & Contingency"]
[null,"Decommissioning"]
[null,"Other"]
[null,"Total"]
[]
["Licensee extra contribution","Any funding from the Licensee which is in excess of the Licensee Compulsory Contribution - from Project Cost Summary sheet"]
[null,"Labour"]
[null,"Equipment"]
[null,"Contractors"]
[null,"IT"]
[null,"IPR Costs"]
[null,"Travel & Expenses"]
["Payments to users & Contingency"]
[null,"Decommissioning"]
[null,"Other"]
[null,"Total"]
[]
["Initial Net Funding Required"]
[null,"Labour",40633.801812972968,211279.45422469784,467238.63477800053,912867.54841877893,341776.08276811178,14847.151943361003,0,1988642.6739459229]
[null,"Equipment",0,321331.7,207245.1,35409,0,0,0,563985.80000000005]
[null,"Contractors",0,475345.24120997539,344062.03460718907,468810.6947375295,572796.4067848979,16709.521840408168,0,1877723.8991799999]
[null,"IT",0,1459204.7896470588,1372063.5793529409,369675.66075000004,138721.90625,0,0,3339665.9359999998]
[null,"IPR Costs",0,0,0,0,0,0,0,0]
[null,"Travel & Expenses",0,3687.5224499999999,2188.8537000000001,10208.40475,0,0,0,16084.7809]
["Payments to users & Contingency",null,0,130085.18061,292622.81796000001,214118.74147201754,90681.834157543868,0,0,727508.57419956138]
[null,"Decommissioning",0,0,0,0,0,29020.873870499996,0,29020.873870499996,"Check Total = to Initial Net Funding request "]
[null,"Other",0,93350.634999999995,73664.595000000001,97073.07,93277.819999999978,16592.400000000001,0,373958.52,"in Project Cost Summary"]
[null,"Total",40633.801812972968,2694284.523141732,2759085.6153981304,2108163.1201283261,1237254.0499605534,77169.947654269155,0,8916591.0580959842,"OK"]
[]
["Direct Benefits","from Direct Benefits sheet"]
[null,"Total",0,0]
[]
[]
[]
["Licensee Compulsory Contribution / Direct Benefits",null,"from Project Cost Summary sheet"]
[null,"Labour"]
[null,"Equipment"]
[null,"Contractors"]
[null,"IT"]
[null,"IPR Costs"]
[null,"Travel & Expenses"]
["Payments to users & Contingency"]
[null,"Decommissioning",null,null,null,null,null,null,null,null,"of Total Initial Net Funding Required"]
[null,"Other",null,null,null,null,null,null,null,null,"OK"]
[null,"Total",null,null,null,null,null,null,null,null,"Check that Total is = or > than "]
[null,null,null,null,null,null,0,0,null,null,"Total Direct Benefits"]
[null,null,null,6139.0368995510216,222093.79546765759,650367.69480979873,214663.10967362529,3989.6091339555987,null,null,"OK"]
["Outstanding Funding required"]
[null,"Labour",0,6139.0368995510216,233727.17512765757,638428.20234979864,214663.10967362529,3989.6091339555987,0,1096947.133184588]
[null,"Equipment",0,321331.7,207245.1,35409,0,0,0,563985.80000000005]
[null,"Contractors",0,475345.24120997539,344062.03460718907,468810.6947375295,572796.4067848979,16709.521840408168,0,1877723.8991800002]
[null,"IT",0,1459204.7896470588,1372063.5793529409,369675.66075000004,138721.90625,0,0,3339665.9359999998]
[null,"IPR Costs",0,0,0,0,0,0,0,0]
[null,"Travel & Expenses",0,3687.5224499999999,2188.8537000000001,10208.40475,0,0,0,16084.7809]
["Payments to users & Contingency",null,0,130085.18061,292622.81796000001,214118.74147201754,90681.834157543868,0,0,727508.57419956138]
[null,"Decommissioning",0,0,0,0,0,29020.873870499996,0,29020.873870499996,"Check that Total is =to "]
[null,"Other",0,93350.634999999995,73664.595000000001,97073.07,93277.819999999978,16592.400000000001,0,373958.52,"Total Outstanding Funding required"]
[null,"Total",0,2489144.105816585,2525574.1557477876,1833723.7740593459,1110141.076866067,66312.404844863748,0,8024895.5173346484,"OK"]
[]
["balance",7946019.121716762,0,5456875.0159001769,2971509.5425652401,1163070.9221812903,65333.586709462921,2706.3953912714328,2910.5153375736359,-1041122.2766299319,7946019.121716762]
["interest",null,0,40208.682412850823,25285.153675396254,12403.741394239591,3685.2135266722594,204.11994630220306,16.850732186535208,-2927.3660697614068,78876.395617886257]
[null,null,null,null,null,null,null,null,null,null,8024895.5173346484,0]
[]
[null,"Bank of England interest rate",null,1E-3,null,null,"NIC FUNDING REQUEST   £",null,7946019.121716762]
[null,"interest rate used in calculation",null,6.0000000000000001E-3]
[null,"RPI adjustment","2020/21","2021/22","2022/23","2023/24","2024/25","2025/26","2026/27"]
[null,"Annual inflation ",1.7000000000000001E-2,2.1299999999999999E-2,2.58E-2,2.8000000000000001E-2,2.8000000000000001E-2,2.8000000000000001E-2,2.1000000000000001E-2]
["n.b the NIC Funding Request calculation should use the Bank of England Base rate plus 0.5% on 30 June of the year in which the Full Submission is made."]
[]
[]
[null,null,null,"Bank of England Base Rate: https://www.bankofengland.co.uk/boeapps/iadb/Repo.asp "]
[null,null,null,"RPI Forecast 2020/21 - 2026/27 : https://www.gov.uk/government/statistics/forecasts-for-the-uk-economy-may-2020"]
[null,null,null,"RPI for 2025/26 and thereafter is an extension from 2024/25 as no further consistent forecast is available. "]