{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["CoverSheet","Description","Table of Contents","Waterfall","DetailsOfChanges","WfallCht","Inputs","EDB data","TIMING","RAB","TAX","BBAR","REV","MAR","Reconciliation"],"not_rendered":{"charts":3,"images":18,"macros":1,"external_links":2,"defined_names":36,"comments":2,"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":"CoverSheet","index":0,"n_rows":17,"n_cols":1,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Electricity Distribution Business"]
["Price-Quality Regulation 1 April 2020 DPP Reset"]
["MAR waterfall model (draft to final)"]
["Final determination"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["For publication 27 November 2019"]

{"sheet":"Description","index":1,"n_rows":90,"n_cols":3,"rows_kept":90,"cut":false,"hidden":false,"merged":[[89,2,90,5],[23,2,23,5],[17,2,17,5],[20,2,20,5],[16,2,16,5],[67,2,67,5],[68,2,68,5],[63,2,63,5],[53,2,53,5],[55,2,55,5],[56,2,56,5],[57,2,57,5],[58,2,58,5],[59,2,59,5],[60,2,60,5],[61,2,61,5],[12,1,12,5],[18,2,18,5],[19,2,19,5],[49,2,49,5],[51,2,51,5],[50,2,50,5],[62,2,62,5],[64,2,64,5],[65,2,65,5],[86,2,86,5],[77,2,77,5],[75,2,75,5],[76,2,76,5],[66,2,66,5],[85,2,85,5],[69,2,69,5],[73,2,73,5],[74,2,74,5],[81,2,81,5],[84,2,84,5]]}
["Description"]
[null,"This Excel workbook is one of a suite of models that accompanies the final determination of the default price-quality path for electricity distribution 2020-2025."]
[]
["Method for creating this model"]
[null,"1","This model has been adapted from the MAR waterfall model that shows the changes from the 2015 EDB reset decision to the DPP3 Final models."]
[null,{"$f":"B5+1","v":2},"Panel D (starting at AM10) in the Inputs sheet has been populated with values from the draft decision financial model inputs sheet."]
[null,{"$f":"B6+1","v":3},"Changes have been made to the Waterfall sheet and Reconciliation sheet to include Orion, which had not been able to be included in the"]
[null,null,"waterfall model from the 2015 EDB reset decision to the Final decision models."]
[null,4,"The sheet \"DetailsOfChanges\" has been added, which displays for a chosen EDB a chart similar to the charts on the WfallCht sheet but with"]
[null,null,"the minimum and maximum values of vertical axis restricted to 85% to 110%. The chart includes data labels to show the numerical value of"]
[null,null,"each of the rises and falls of the waterfall."]
["Purpose"]
[null,"This waterfall model produces a waterfall chart for each of 15 non-exempt EDB to show a breakdown of the  drivers of the change in the building blocks allowable revenue (BBAR) from the draft decision to the Final decision models. A waterfall chart for each of the 15 EDBs is on the 'WaterfallCht' sheet. There is also a chart for the totals for the 15 EDBs. There are waterfall charts for only 15 of the 17 non-exempt EDBs. This is because the comparison of the DPP values between the draft and the final models is only meaningful if the EDB is on a default price path for the 2020 EDB reset. Wellington Electricity and Powerco do not feature as they are on CPPs."]
[]
[]
["Overview of model structure"]
[null,1,"This model incorporates a copy of much of the 2015 EDB DPP reset financial model. The sheets from 'Inputs' to 'MAR' are the copied sheets."]
[null,2,"The modifications extend the capability of the 2015 model to take into account accelerated depreciation. With this modification, the copied sheets can perform the calculations for the 2020 reset."]
[null,3,"The model inputs include both the set of inputs used for the draft decision and the set used for the 2020 reset. When all the draft decision inputs are used, then the results reconcile with the Draft decision financial model. When the final inputs are used, the results reconcile with the final financial model. The reconciliation is demonstrated on the Reconciliation sheet."]
[null,4,"For each EDB, the model recalculates the MAR values for 15 different sets of input data, each of these 15 sets being a combination of input data from the Draft decision for some inputs and input data from the Final decision for the rest of the data. Arranging the sequence of these data combinations allows for the impact of various inputs to be determined for the waterfall charts."]
[null,5,"We discuss the 15 sets of input data combinations below in the context of the waterfall chart for one EDB."]
[]
["Waterfall chart"]
[null,null,"The chart below is an example of the waterfall charts that this model prepares for each non-exempt EDB.\nA full set of 15 charts is available on the sheet 'WfallCht' plus a chart for the totals of the 15 EDBs."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,6,"The chart starts at its left hand with the brown column, indicating the value of the draft decision MAR (ie the MAR for the first year of the 2020 EDB reset as calculated for the draft decision) as 100%. All subsequent MAR values shown in the chart are relative to this value."]
[null,7,"The chart ends at its right hand end with another brown column, this one indicating the 2020/21 MAR for the Final decision. Between these 2 columns, there are a series of rises and falls, indicating the impact of the various input categories listed along the x axis."]
[null,8,"Consider, for example, the green rise column above the word 'Opex' on the x axis. The lower edge of this rise indicates the MAR if all the inputs for the parameters listed to the left of this Opex rise are at their Final decision values. These parameters are: CPI for revals; RAB, Depn; Tax; Capex and Disposals. The Opex values themselves will be set to their draft decision values for this MAR value, as will all the other parameters to the right of the Opex rise.\nThe MAR represented by the upper edge of the Opex rise will reflect the same input values as the lower edge, except that the Final decision Opex values will be used. The height of the green rise therefore represents the impact of the change in opex forecasts from the Draft decision to the Final decision."]
[null,null,"Input categories"]
[null,null,"The 15 input data categories are listed below, with commentary for some categories. The numbers in the \"Mode\" column below indicate the mode number used on Row 4 and Column D of the Inputs sheet to manage whether Draft decision data or Final decision data is used for the category. Note that there is a Mode 0."]
[null,"Mode"]
[null,0,"Draft decision financial model inputs\nAll inputs in Mode Zero are the same as for the Draft decision financial model."]
[null,1,"CPI for revals\nThis is the forecast change in CPI from one quarter to the quarter 1 year later, and is used for calculating CPI indexed revaluations. There is just one row of inputs in the Inputs sheet for this category, being the one with the row heading \"Forecast change in CPI used for revaluations\"."]
[null,2,"RAB, Depn\nSix rows of inputs are in this category, the main ones being Opening RAB, Total depreciation and Closing RAB. These are all for the base year. \nThe impact of these inputs is entirely driven by information disclosure data and input methodologies, so there is no impact from Commission decisions taken as part of the 2020 reset.\nThe opening RAB divided by total depreciation gives the average remaining life for existing assets, so is a key determinant of the depreciation building block. The Closing RAB for the base year is the key determinant of the starting RAB at the start of the regulatory period, and so is in turn a key determinant of the return on  the RAB and depreciation throughout the regulatory period."]
[null,3,"Tax\nFive rows of inputs are in this category, being Opening RAB excluding revaluations, Adjusted depreciation, Tax depreciation, Opening regulatory tax asset value and Amortisation of initial differences in asset values.\nThe Tax depreciation divided by the Opening regulatory tax asset value determines the effective average diminishing value depreciation rate for the base year, and this rate is used for determining the tax depreciation throughout the regulatory period.\nThe other three input parameters are used to account for amortisations of differences between regulatory tax and cash tax.\nRises and falls for this 'Tax' category do not reflect all  the changes in the tax allowance building block. That building block will be strongly driven by the BBAR, which is an output of financial modelling rather than an input."]
[null,4,"Capex\nSeven rows of inputs are in this category, being the panel of data of capex for the 5 years of the regulatory period plus two prior years."]
[null,5,"Disposed assets\nSeven rows of inputs are in this category, being the panel of data of Disposed assets for the 5 years of the regulatory period plus two prior years."]
[null,6,"Operating expenditure\nSeven rows of inputs are in this category, being the panel of data of Operating expenditure for the 5 years of the regulatory period plus two prior years."]
[null,7,"Other regulated income\nSeven rows of inputs are in this category, being the panel of data of Other regulated income for the 5 years of the regulatory period plus two prior years.\nOther regulated income was accounted for in the Draft decision and the Final decision by setting the Other Regulated Income to nil. For the 2020 reset, the revenue cap with wash-up process will take account of actual values of other regulated income, and no forecast value will be used when setting the price path."]
[null,8,"TCSD (Term Credit Spread Differential)\nThis is a one row category. "]
[null,9,"Add. Allow. (Additional allowance)\nThis is a one row category. The value has been set to nil for all EDBs for both the Draft decision and the Final decision."]
[null,10,"WACC (Vanilla WACC (67th percentile))\nThis is a single value input. \nIt is a strong determinant of the return on capital building block."]
[null,11,"Accel'ed Depn (Adjustment factor (for accelerated depreciation))\nThis is a one row category.\nIt relates to a mechanism from the 2016 input methodology review for an EDB to apply for an acceleration of the depreciation of its 'existing assets'.\nThe provision for accelerated deprecation did not exist for the 2015 reset, so an additional row has been added to the Inputs sheet to allow for this. The values entered for the Draft decision were nil, and as the Final decision does not reflect any policy decisions they are also set to nil for the Final decision."]
[null,12,"CPI, price path (Forecast changes in the CPI element of the price path)\nThis is the forecast change in CPI from one year to the next and is used for calculating the CPI indexation of the price path. There is just one row of inputs in the Inputs sheet for this category, being the one with the row heading \"Forecast change in CPI used for revaluations\".\nThis CPI change parameter is calculated differently from the 'CPI for revals', in that this calculation is based on the sum of 4 consecutive CPI values divided by the sum of the 4 consecutive CPI values from one year earlier."]
[null,13,"CPRG (Constant price revenue growth)\nSeven rows of inputs are in this category, being the panel of data of CPRG for the 5 years of the regulatory period plus two prior years.\nCPRG was taken into account in the 2015 reset in calculating the profile of the price path. This was because the form of control used at the time of that reset was a weighted average price path. That price path took account of the forecast CPRG values.\nThe form of control was changed to a revenue cap as part of the 2016 input methodologies review, and this means that CPRG will no longer be required for setting the price path.\nWe account for this change in the form of control in this waterfall model by setting the CPRG forecast value for both the Draft decision and the Final decision to nil.\nThis setting of CPRG to nil is a work-around to make the core calculation process of this model (ie the 2015 reset financial model process) reflect a revenue cap rather than a weighted average price cap. A CPRG model forms part of suite of models released with the Draft decision, but that model has no impact on the setting of the final price path. It is only used to estimate DPP2 2020/21 revenues, which continue to be subject to a weighted average price cap."]
[null,14,"X (for CPI-X)\nTwo rows are in this category, being Industry-wide X factor and Alternative X factor.\nA non-zero X can have a significant impact on MAR values, but has no impact on BBAR values.\n"]
[]
["Inputs sheet & overall operation of this workbook"]
[]
[null,1,"The inputs sheet is an adaptation of the Inputs sheet of the 2015 DPP reset financial model on which this workbook is based. It includes all the inputs to this workbook, together with a significant amount of the processing required to produce the waterfall charts."]
[null,2,"The sheet is divided into a number of panels, the panels being separated by rows and columns that have a light yellow fill colour.\n\nThe panels are referred to as Panels A, B, C and D, these being the panels with a top left corner at Cell A1, A9, U9 and AM9 respectively. The panels are labelled with cells with a green fill colour.\n\n"]
[null,3,"Panel A is very simple and sets just the \"mode\", being a number determining the extent to which the Draft decision versus Final decision inputs are to be used (Cell C5).\n\nIf the chosen mode at Cell C5 is less than the mode number in Column A for each line of inputs, then the Draft decision inputs are used for that row of inputs, otherwise the 2020 inputs are used.\n\nA data table is used in the \"Waterfall\" sheet to step through 15 different values of the mode. This generates the data necessary to draw the waterfall chart for the chosen EDB. The macro for preparing the set of 16 waterfall charts steps through the choice of the 15 EDBs plus the chart for the totals of the 15 EDBs. There is a macro button on the \"WfallCht\" sheet to prepare this sheet."]
[null,4,"Panel B consists of most of the used area of the Inputs sheet in the 2015 reset model. The links that transfer data from the Inputs sheet to the 'EDB data' sheet and other sheets from the 2015 model are largely still the same links in this workbook. The key difference in the Inputs sheet in this workbook is that the cells in this panel are no longer values but are instead formulas that reference the data in Panels C and D."]
[null,5,"Panel C consists of links to the inputs to the Final decision financial model, while Panel D consists of values copied from the inputs to the Draft decision financial model. "]
[]
["Reconciliation sheet"]
[]
[null,null,"The \"Reconciliation\" sheet checks that this model produces outputs consistent with the Draft decision and Final decision financial models.\n\nWhen the mode is set to 0, this workbook should produce the same outputs as the Draft decision financial model.\nWhen the mode is set to 14, this workbook should produce the same outputs as the Final decision financial model.\n\nThere are notes on the Reconciliation sheet as to how it operates. See Cells F2, W8, C39 and V39."]
[]
["The \"Totals for selected EDBs\" chart"]
[null,null,"A waterfall chart of the totals for all non-exempt EDBs except those currently on a CPP is prepared by this workbook, and is the last chart on the WfallCht sheet. It is prepared on the Waterfall sheet when 'Totals for selected EDBs' is selected by the waterfall chart macro at Waterfall!D3."]
[null,null,"Data for this chart is prepared in the named range \"IndustryTotals\" on the 'Waterfall' sheet. The values in this table are inserted through the VBA routine \"Regenerate\", which is the routine that also generates the charts on the WfallCht sheet. The VBA code that inserts the data starts with the VBA comment \"Build table on the Waterfall sheet to chart the total for all non-exempts, except Powerco, Wellington.\""]
[null,null,"Note the formula at Waterfall!C21 and below. The formula selects the data from the data table to its immediate left except when \"Totals for selected EDBs\" is selected at D3. When the totals chart is selected, the data for the Column C formulas is taken from the totals column at the right of the named range \"IndustryTotals\"."]
[]
["Model suite"]
[null,null,"Follow the link 'Model map – EDB DPP3 final determination – 27 November 2019' on the Commission's EDB 2020-2025 default price-quality path determination web page for a graphical depiction of interconnections between the models and data sources."]

{"sheet":"Table of Contents","index":2,"n_rows":38,"n_cols":3,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Table of Contents"]
[]
[]
[null,"Sheet Name","Link"]
[null,"Waterfall","Waterfall calculations and chart for chosen EDB"]
[null,null,"EDB names and values of MAR 2019/20"]
[null,null,"Waterfall chart for chosen EDB"]
[null,"DetailsOfChanges","Details of the drivers of change from Draft decision to Final decision"]
[null,"WfallCht","Waterfall charts for 15 EDBs"]
[null,"Inputs","Inputs"]
[null,"EDB data","Inputs for the selected distributor"]
[null,"TIMING","Intra-year timing"]
[null,null,"Inputs"]
[null,null,"Calculations"]
[null,null,"Outputs"]
[null,null,"Check for timing of revenue receipt"]
[null,"RAB","Regulatory asset base"]
[null,null,"Inputs"]
[null,null,"Calculations"]
[null,null,"Outputs"]
[null,"TAX","Tax calculations"]
[null,null,"Inputs"]
[null,null,"Calculations"]
[null,null,"Outputs"]
[null,"BBAR","Building blocks allowable revenue"]
[null,null,"Inputs"]
[null,null,"Calculations"]
[null,null,"Outputs"]
[null,"REV","Revenue growth index"]
[null,null,"Inputs"]
[null,null,"Calculations"]
[null,null,"Outputs"]
[null,"MAR","Maximum allowable revenue"]
[null,null,"Inputs"]
[null,null,"Calculations"]
[null,null,"Outputs"]
[null,"Reconciliation","Reconciliation with financial models outputs"]
[null,null,"Outputs"]

{"sheet":"Waterfall","index":3,"n_rows":63,"n_cols":20,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
["Waterfall calculations and chart for chosen EDB"]
[]
["EDB",null,null,"Total for selected EDBs"]
["Distributor number",null,null,{"$f":"MATCH(WfallEDB,EDBnames,0)","v":16}]
["Chosen mode",null,null,14]
[]
["EDB names and values of MAR 2019/20"]
[]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
[null,"Alpine Energy","Aurora Energy","Centralines","EA Networks","Eastland Network","Electricity Invercargill","Horizon Energy","Nelson Electricity","Network Tasman","Orion NZ","OtagoNet","The Lines Company","Top Energy","Unison Networks","Vector Lines","Total for selected EDBs"]
["Estimated 2019/20 allowable revenue",{"$f":"Inputs!C97","v":49719.82702663089},{"$f":"Inputs!D97","v":67031.770067225996},{"$f":"Inputs!E97","v":14465.452982598339},{"$f":"Inputs!F97","v":37120.373212502302},{"$f":"Inputs!G97","v":27873.521952147665},{"$f":"Inputs!H97","v":13951.543341108681},{"$f":"Inputs!I97","v":23616.338568634361},{"$f":"Inputs!J97","v":6803.15723580746},{"$f":"Inputs!K97","v":28269.633421484999},{"$f":"Inputs!L97","v":167132.99807356339},{"$f":"Inputs!M97","v":27205.404248709074},{"$f":"Inputs!N97","v":40848.168135214502},{"$f":"Inputs!O97","v":48585.636766442934},{"$f":"Inputs!P97","v":112883.51224466226},{"$f":"Inputs!Q97","v":417635.91704348486},{"$f":"SUM(B11:P11)","v":1083143.2543202178}]
[]
["Waterfall chart for chosen EDB"]
[]
[]
["PV(BBAR) for chosen EDB and chosen mode",null,null,null,null,null,{"$f":"BBAR!C57","v":{"$error":"#N/A"}}]
["Starting price for applicable X factor",null,null,null,null,null,{"$f":"MAR!D57","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,"Direction","Base","Fall","Rise","Orange dot"]
[null,{"$f":"G17","v":{"$error":"#N/A"}},{"$f":"B20","v":{"$error":"#N/A"}}]
[0,{"$error":"#N/A"},{"$f":"IF(WfallEDB=$Q$10,T49,B21)","v":1029195.0339673911},"Draft MAR",1,{"$f":"C21/$C$21","v":1},null,0,0,1]
[1,{"$error":"#N/A"},1035691.4831360739,"CPI for revals",{"$f":"A22","v":1},{"$f":"C22/$C$21","v":1.0063121652886722},{"$f":"IF(F22>F21,\">\",\"<\")","v":">"},{"$f":"H21+J21-I22-0.00002%*0","v":0.99999000000000005},{"$f":"IF(F22<F21,F21-F22+0.00001,0.00001)","v":1.0000000000000001E-5},{"$f":"IF(F22>=F21,F22-F21+0.00001,0.00001)","v":6.3221652886721776E-3}]
[2,{"$error":"#N/A"},1017583.7017974271,"RAB, Depn",2,0.98871804489261472,"<",{"$f":"H22+J22-I23-0.00002%*0","v":0.98870804489261477},{"$f":"IF(F23<F22,F22-F23+0.00001,0.00001)","v":1.7604120396057455E-2},{"$f":"IF(F23>=F22,F23-F22+0.00001,0.00001)","v":1.0000000000000001E-5}]
[3,{"$error":"#N/A"},1018950.0838457508,"Tax",3,0.99004566696931329,">",0.98870804489261477,1.0000000000000001E-5,1.3376220766985647E-3]
[4,{"$error":"#N/A"},1034110.9954624079,"Capex",4,1.0047765110914562,">",{"$f":"H24+J24-I25-0.00002%*0","v":0.99003566696931333},1.0000000000000001E-5,1.4740844122142872E-2]
[5,{"$error":"#N/A"},1034315.462429041,"Disposals",5,1.0049751779717702,">",1.0047665110914561,1.0000000000000001E-5,2.0866688031400237E-4]
[6,{"$error":"#N/A"},1038099.1774406518,"Opex",6,1.0086515608600797,">",1.0049651779717701,1.0000000000000001E-5,3.6863828883095151E-3]
[7,{"$error":"#N/A"},1038099.1774406518,"OR Income",7,1.0086515608600797,"<",1.0086415608600796,1.0000000000000001E-5,1.0000000000000001E-5]
[8,{"$error":"#N/A"},1042944.0187361074,"TCSD",8,1.0133589692088933,">",1.0086415608600796,1.0000000000000001E-5,4.7174083488136682E-3]
[9,{"$error":"#N/A"},1042944.0187361074,"Add. Allow.",9,1.0133589692088933,"<",1.0133489692088933,1.0000000000000001E-5,1.0000000000000001E-5]
[10,{"$error":"#N/A"},995244.77594371676,"WACC",10,0.96701280427597747,"<",0.96700280427597751,4.6356164932915882E-2,1.0000000000000001E-5]
[11,{"$error":"#N/A"},995244.77594371676,"Accel'ed Depn",11,0.96701280427597747,"<",0.96700280427597751,1.0000000000000001E-5,1.0000000000000001E-5]
[12,{"$error":"#N/A"},996577.04271315399,"CPI, price path",12,0.96830727881721335,">",0.96700280427597751,1.0000000000000001E-5,1.3044745412358794E-3]
[13,{"$error":"#N/A"},996577.04271315399,"CPRG",13,0.96830727881721335,"<",0.96829727881721339,1.0000000000000001E-5,1.0000000000000001E-5]
[14,{"$error":"#N/A"},1010490.797166163,"X (CPI-X)",14,0.98182634371142841,">",0.96829727881721339,1.0000000000000001E-5,1.352906489421506E-2]
[null,null,null,"Final MAR",null,null,null,0.98182634371142841,null,null,{"$f":"K42/C21","v":1.0524178786064138}]
[null,null,null,null,null,null,"Check value, should = 0",{"$f":"F35-H36","v":0}]
[]
[]
[null,null,null,null,"Text for textbox in chart and data for orange dot"]
[null,null,null,null,null,null,null,null,null,"2020/21 revenue",{"$f":"C35","v":1010490.797166163}]
[null,null,null,null,null,null,null,null,null,"Est 2019/20 allowable revenue",{"$f":"INDEX(B11:Q11,1,SuppNum)","v":1083143.2543202178}]
[null,null,null,null,null,null,null,null,null,"MAR increase, 2020/21 MAR from est 2019/20 allowable rev",{"$f":"(K41-K42)/K42","v":-6.7075575519926545E-2}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"Revenue increase,  est 2019/20 allow. revenue to 2020/21 MAR: \" & TEXT(K43,\"0.00%\")","v":"Revenue increase,  est 2019/20 allow. revenue to 2020/21 MAR: -6.71%"}]
[]
[]
[null,null,null,"Named range, Anchor2",{"$f":"B10","v":"Alpine Energy"},{"$f":"C10","v":"Aurora Energy"},"Centralines","EA Networks",{"$f":"F10","v":"Eastland Network"},"Electricity Invercargill","Horizon Energy","Nelson Electricity","Network Tasman","Orion NZ","OtagoNet","The Lines Company","Top Energy","Unison Networks","Vector Lines","Total for selected EDBs"]
[null,null,null,"MAR 2015/16",45361.380318835836,72030.727522350353,9398.5396333909193,37696.145028874846,25055.110617462473,12291.592306373914,25008.552216993317,5588.2462797242588,28780.562999403519,161170.07066762098,25084.600581412495,33943.504018870779,42189.259503444315,102250.97674098593,403345.76553164725,{"$f":"SUM(E49:S49)","v":1029195.0339673911}]
[null,null,null,"CPI for revals",45513.68117781094,72448.743477733791,9447.8049003171691,37963.389424859408,25209.278040872974,12370.108678346167,25119.116838461545,5626.5302910260998,28936.755733014572,162199.60616970004,25279.892524627357,34124.243188498032,42456.504559119196,102803.83105363858,406191.99707804801,{"$f":"SUM(E50:S50)","v":1035691.4831360739}]
[null,null,null,"RAB, Depn",42389.818901149061,69278.585893469106,8947.2964762251577,36707.585519065644,25163.146258609497,12283.079362588707,26066.806543569553,5602.7653329057412,27607.921636169798,158204.15925428891,25410.247109542492,33939.673515470102,41412.878961014358,103768.81747508582,400800.91955827322,1017583.7017974271]
[null,null,null,"Tax",42985.338985455506,69659.417315276689,8931.0583504652113,36700.412498012171,25152.183293458078,12277.889731248451,26093.474480823064,5603.6543355444046,27556.90709463798,159300.55915685621,25398.81716484276,33856.172393888548,41371.331519714535,103730.59469059265,400332.27283493453,1018950.0838457508]
[null,null,null,"VCA",43362.189820304171,72351.498643468411,9272.9524783121269,36756.012877460475,25279.090733520381,12619.43338480742,26077.587989831103,5623.5321819075562,28482.126346049186,161479.11946893082,25853.995064112929,34555.932952016439,41382.181422204252,104345.56384367369,406669.77825580898,1034110.9954624079]
[null,null,null,"Disposals",43369.403757025051,72333.515882560634,9272.5810762079545,36767.429016058981,25279.71841825833,12619.315690276479,26083.919774997725,5626.0616210750304,28488.291748400163,161492.09775202608,25862.228107897899,34562.614601693283,41382.606809279183,104380.72381537335,406794.95435791084,1034315.462429041]
[null,null,null,"Opex",43869.433145901377,76341.620581250914,9762.0135431706258,35015.067087247124,25053.96378645087,12814.38323947836,24735.318591125917,5757.2985344741292,27569.147501623549,164778.95458618127,27068.153579626021,36133.62156215727,39779.904276884263,103545.48459911555,405874.81282596453,1038099.1774406518]
[null,null,null,"OR Income",43869.433145901377,76341.620581250914,9762.0135431706258,35015.067087247124,25053.96378645087,12814.38323947836,24735.318591125917,5757.2985344741292,27569.147501623549,164778.95458618127,27068.153579626021,36133.62156215727,39779.904276884263,103545.48459911555,405874.81282596453,1038099.1774406518]
[null,null,null,"TCSD",43869.433145901377,76341.620581250914,9762.0135431706258,35015.067087247124,25053.96378645087,12814.38323947836,24735.318591125917,5757.2985344741292,27569.147501623549,165637.83430886859,27068.153579626021,36085.503224450818,39779.904276884263,104036.88871844595,409417.48861710902,1042944.0187361074]
[null,null,null,"Add. Allow.",43869.433145901377,76341.620581250914,9762.0135431706258,35015.067087247124,25053.96378645087,12814.38323947836,24735.318591125917,5757.2985344741292,27569.147501623549,165637.83430886859,27068.153579626021,36085.503224450818,39779.904276884263,104036.88871844595,409417.48861710902,1042944.0187361074]
[null,null,null,"WACC",42595.820724930636,73317.301360960526,9354.5255040720094,33214.443166808545,23996.452698086683,12241.194893448534,23880.295407743772,5494.44402688432,26417.250407602649,158286.56799980343,25745.028327059743,34661.670644963706,37963.931750294818,99886.167035477003,388189.68199558044,995244.77594371676]
[null,null,null,"Accel'ed Depn",42595.820724930636,73317.301360960526,9354.5255040720094,33214.443166808545,23996.452698086683,12241.194893448534,23880.295407743772,5494.44402688432,26417.250407602649,158286.56799980343,25745.028327059743,34661.670644963706,37963.931750294818,99886.167035477003,388189.68199558044,995244.77594371676]
[null,null,null,"CPI, price path",42652.594084747587,73420.787481290943,9366.9935780126234,33258.712663227125,24028.436099748465,12257.510432166828,23912.123990469623,5501.7672347113685,26452.460342221599,158497.53846888477,25779.342298051128,34707.869062223712,38014.531549069543,100019.29918800581,388707.0762403229,996577.04271315399]
[null,null,null,"CPRG",42652.594084747587,73420.787481290943,9366.9935780126234,33258.712663227125,24028.436099748465,12257.510432166828,23912.123990469623,5501.7672347113685,26452.460342221599,158497.53846888477,25779.342298051128,34707.869062223712,38014.531549069543,100019.29918800581,388707.0762403229,996577.04271315399]
[null,null,null,"X (CPI-X)",42652.594084747587,87334.541934299879,9366.9935780126234,33258.712663227125,24028.436099748465,12257.510432166828,23912.123990469623,5501.7672347113685,26452.460342221599,158497.53846888477,25779.342298051128,34707.869062223712,38014.531549069543,100019.29918800581,388707.0762403229,1010490.797166163]

{"sheet":"DetailsOfChanges","index":4,"n_rows":73,"n_cols":13,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
["Details of the drivers of change from Draft decision to Final decision"]
[]
["To select the EDB for which the details chart below is to be displayed, selected the EDB at Cell D3 on the \"Waterfall\" sheet."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Data for the chart above:"]
[null,null,null,null,null,null,{"$f":"Waterfall!G19","v":"Direction"},{"$f":"Waterfall!H19","v":"Base"},{"$f":"Waterfall!I19","v":"Fall"},{"$f":"Waterfall!J19","v":"Rise"},{"$f":"Waterfall!K19","v":"Orange dot"},null,"Data for labels"]
[]
[null,null,null,{"$f":"Waterfall!D21","v":"Draft MAR"},null,{"$f":"Waterfall!F21","v":1},null,{"$f":"Waterfall!H21","v":0},{"$f":"Waterfall!I21","v":0},{"$f":"Waterfall!J21","v":1},null,null,{"$f":"J49","v":1}]
[null,null,null,{"$f":"Waterfall!D22","v":"CPI for revals"},null,{"$f":"Waterfall!F22","v":1.0063121652886722},{"$f":"IF(F50>F49,\">\",\"<\")","v":">"},{"$f":"Waterfall!H22","v":0.99999000000000005},{"$f":"Waterfall!I22","v":1.0000000000000001E-5},{"$f":"Waterfall!J22","v":6.3221652886721776E-3},null,null,{"$f":"F50-F49","v":6.312165288672178E-3}]
[null,null,null,{"$f":"Waterfall!D23","v":"RAB, Depn"},null,{"$f":"Waterfall!F23","v":0.98871804489261472},"<",{"$f":"Waterfall!H23","v":0.98870804489261477},{"$f":"Waterfall!I23","v":1.7604120396057455E-2},{"$f":"Waterfall!J23","v":1.0000000000000001E-5},null,null,{"$f":"F51-F50","v":-1.7594120396057455E-2}]
[null,null,null,{"$f":"Waterfall!D24","v":"Tax"},null,{"$f":"Waterfall!F24","v":0.99004566696931329},">",{"$f":"Waterfall!H24","v":0.98870804489261477},{"$f":"Waterfall!I24","v":1.0000000000000001E-5},{"$f":"Waterfall!J24","v":1.3376220766985647E-3},null,null,1.3276220766985647E-3]
[null,null,null,{"$f":"Waterfall!D25","v":"Capex"},null,{"$f":"Waterfall!F25","v":1.0047765110914562},">",{"$f":"Waterfall!H25","v":0.99003566696931333},{"$f":"Waterfall!I25","v":1.0000000000000001E-5},{"$f":"Waterfall!J25","v":1.4740844122142872E-2},null,null,1.4730844122142872E-2]
[null,null,null,{"$f":"Waterfall!D26","v":"Disposals"},null,{"$f":"Waterfall!F26","v":1.0049751779717702},">",{"$f":"Waterfall!H26","v":1.0047665110914561},{"$f":"Waterfall!I26","v":1.0000000000000001E-5},{"$f":"Waterfall!J26","v":2.0866688031400237E-4},null,null,{"$f":"F54-F53","v":1.9866688031400237E-4}]
[null,null,null,{"$f":"Waterfall!D27","v":"Opex"},null,{"$f":"Waterfall!F27","v":1.0086515608600797},">",{"$f":"Waterfall!H27","v":1.0049651779717701},{"$f":"Waterfall!I27","v":1.0000000000000001E-5},{"$f":"Waterfall!J27","v":3.6863828883095151E-3},null,null,3.6763828883095151E-3]
[null,null,null,{"$f":"Waterfall!D28","v":"OR Income"},null,{"$f":"Waterfall!F28","v":1.0086515608600797},"<",{"$f":"Waterfall!H28","v":1.0086415608600796},{"$f":"Waterfall!I28","v":1.0000000000000001E-5},{"$f":"Waterfall!J28","v":1.0000000000000001E-5},null,null,0]
[null,null,null,{"$f":"Waterfall!D29","v":"TCSD"},null,{"$f":"Waterfall!F29","v":1.0133589692088933},">",{"$f":"Waterfall!H29","v":1.0086415608600796},{"$f":"Waterfall!I29","v":1.0000000000000001E-5},{"$f":"Waterfall!J29","v":4.7174083488136682E-3},null,null,4.7074083488136687E-3]
[null,null,null,{"$f":"Waterfall!D30","v":"Add. Allow."},null,{"$f":"Waterfall!F30","v":1.0133589692088933},"<",{"$f":"Waterfall!H30","v":1.0133489692088933},{"$f":"Waterfall!I30","v":1.0000000000000001E-5},{"$f":"Waterfall!J30","v":1.0000000000000001E-5},null,null,0]
[null,null,null,{"$f":"Waterfall!D31","v":"WACC"},null,{"$f":"Waterfall!F31","v":0.96701280427597747},"<",{"$f":"Waterfall!H31","v":0.96700280427597751},{"$f":"Waterfall!I31","v":4.6356164932915882E-2},{"$f":"Waterfall!J31","v":1.0000000000000001E-5},null,null,-4.6346164932915879E-2]
[null,null,null,{"$f":"Waterfall!D32","v":"Accel'ed Depn"},null,{"$f":"Waterfall!F32","v":0.96701280427597747},"<",{"$f":"Waterfall!H32","v":0.96700280427597751},{"$f":"Waterfall!I32","v":1.0000000000000001E-5},{"$f":"Waterfall!J32","v":1.0000000000000001E-5},null,null,0]
[null,null,null,{"$f":"Waterfall!D33","v":"CPI, price path"},null,{"$f":"Waterfall!F33","v":0.96830727881721335},">",{"$f":"Waterfall!H33","v":0.96700280427597751},{"$f":"Waterfall!I33","v":1.0000000000000001E-5},{"$f":"Waterfall!J33","v":1.3044745412358794E-3},null,null,1.2944745412358794E-3]
[null,null,null,{"$f":"Waterfall!D34","v":"CPRG"},null,{"$f":"Waterfall!F34","v":0.96830727881721335},"<",{"$f":"Waterfall!H34","v":0.96829727881721339},{"$f":"Waterfall!I34","v":1.0000000000000001E-5},{"$f":"Waterfall!J34","v":1.0000000000000001E-5},null,null,0]
[null,null,null,{"$f":"Waterfall!D35","v":"X (CPI-X)"},null,{"$f":"Waterfall!F35","v":0.98182634371142841},">",{"$f":"Waterfall!H35","v":0.96829727881721339},{"$f":"Waterfall!I35","v":1.0000000000000001E-5},{"$f":"Waterfall!J35","v":1.352906489421506E-2},null,null,1.351906489421506E-2]
[null,null,null,{"$f":"Waterfall!D36","v":"Final MAR"},null,null,null,{"$f":"H63+J63-I64-0.00002%*0","v":0.98182634371142841},null,null,{"$f":"Waterfall!K36","v":1.0524178786064138},null,{"$f":"H64","v":0.98182634371142841}]
[]
[]
[]
[null,null,null,null,"Text for textbox in chart and data for orange dot"]
[null,null,null,null,null,null,null,null,null,{"$f":"Waterfall!J41","v":"2020/21 revenue"},{"$f":"Waterfall!K41","v":1010490.797166163}]
[null,null,null,null,null,null,null,null,null,{"$f":"Waterfall!J42","v":"Est 2019/20 allowable revenue"},{"$f":"Waterfall!K42","v":1083143.2543202178}]
[null,null,null,null,null,null,null,null,null,{"$f":"Waterfall!J43","v":"MAR increase, 2020/21 MAR from est 2019/20 allowable rev"},{"$f":"Waterfall!K43","v":-6.7075575519926545E-2}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"Revenue increase,  est 2019/20 allow. revenue to 2020/21 MAR: \" & TEXT(K71,\"0.00%\")","v":"Revenue increase,  est 2019/20 allow. revenue to 2020/21 MAR: -6.71%"}]

{"sheet":"WfallCht","index":5,"n_rows":6,"n_cols":50,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Waterfall charts for 15 EDBs"]
[null,null,null,null,"For a more detailed view of the drivers of the changes from the Draft decision models to the Final decision, see the 'DetailsOfChanges' sheet."]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waterfall Charts"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"An aid to interpreting these charts is on the Description sheet, under the headings 'Waterfall Chart' and 'Input categories'."]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The chart \"Total for selected EDBs\" is for all non-exempt EDBs except those on a CPP in 2020/21, ie, except Powerco and Wellington Electricity."]

{"sheet":"Inputs","index":6,"n_rows":97,"n_cols":73,"rows_kept":97,"cut":false,"hidden":false,"merged":[]}
["Inputs"]
["A","The mode in cell C5 is chosen on the Waterfall sheet cell D5."]
[null,"All input data is entered into this worksheet"]
[null,"Waterfall chart parameters"]
[null,"Chosen mode",{"$f":"Waterfall!D5","v":14}]
[]
[]
[]
[]
["B","Values for chosen mode",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C","Values from Financial model",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D","Values for draft decision 2020 reset model"]
["Mode","Inputs that are the same for all distributors"]
[1,"2020 reset timeline","Value",{"$f":"IF($C$5<$A12,AN12,V12)","v":"2018/19"},"2019/20","2020/21","2021/22","2022/23","2023/24","2024/25",null,null,null,null,null,null,null,null,null,null,null,"2018/19",{"$f":"LEFT(V12,4)+1 & \"/\" & RIGHT(V12,2)+1","v":"2019/20"},{"$f":"LEFT(W12,4)+1 & \"/\" & RIGHT(W12,2)+1","v":"2020/21"},"2021/22","2022/23","2023/24","2024/25",null,null,null,null,null,null,null,null,null,null,null,"2013/14",{"$f":"LEFT(AN12,4)+1 & \"/\" & RIGHT(AN12,2)+1","v":"2014/15"},{"$f":"LEFT(AO12,4)+1 & \"/\" & RIGHT(AO12,2)+1","v":"2015/16"},"2016/17","2017/18","2018/19","2019/20"]
[0,"Year in modelling period",null,1,2,3,4,5,6,7,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7]
[0,"Year in regulatory period",null,null,null,1,2,3,4,5,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5]
[1,"Forecast changes in CPI used for revaluations",null,{"$f":"IF($C$5<$A15,AN15,V15)","v":1.4836795252225476E-2},1.6999999999999904E-2,1.8999999999999906E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Inputs!C7","v":1.4836795252225476E-2},{"$f":"[1]Inputs!D7","v":1.6999999999999904E-2},{"$f":"[1]Inputs!E7","v":1.8999999999999906E-2},{"$f":"[1]Inputs!F7","v":2.0000000000000018E-2},{"$f":"[1]Inputs!G7","v":2.0000000000000018E-2},{"$f":"[1]Inputs!H7","v":2.0000000000000018E-2},{"$f":"[1]Inputs!I7","v":2.0000000000000018E-2},null,null,null,null,null,null,null,null,null,null,null,1.6000000000000014E-2,1.6999999999999904E-2,2.0999999999999908E-2,2.0999999999999908E-2,2.0666666666666611E-2,2.0333333333333314E-2,2.0000000000000018E-2]
[{"$f":"A44+1","v":12},"Forecast changes in the CPI element of the price path",null,null,null,{"$f":"IF($C$5<$A16,AP16,X16)","v":1.7504378984726898E-2},{"$f":"IF($C$5<$A16,AQ16,Y16)","v":1.9502114592602871E-2},{"$f":"IF($C$5<$A16,AR16,Z16)","v":2.0248058977042183E-2},{"$f":"IF($C$5<$A16,AS16,AA16)","v":2.0000000000000018E-2},{"$f":"IF($C$5<$A16,AT16,AB16)","v":2.0000000000000018E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Inputs!E8","v":1.7504378984726898E-2},{"$f":"[1]Inputs!F8","v":1.9502114592602871E-2},{"$f":"[1]Inputs!G8","v":2.0248058977042183E-2},{"$f":"[1]Inputs!H8","v":2.0000000000000018E-2},{"$f":"[1]Inputs!I8","v":2.0000000000000018E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,1.97537947804447E-2,2.0749523987959151E-2,2.0666666666666611E-2,2.0333333333333314E-2,1.9999999999999796E-2]
[0,"Company tax rate",null,0.28000000000000003,{"$f":"IF($C$5<$A17,AO17,W17)","v":0.28000000000000003},0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Inputs!C9","v":0.28000000000000003},{"$f":"[1]Inputs!D9","v":0.28000000000000003},{"$f":"[1]Inputs!E9","v":0.28000000000000003},{"$f":"[1]Inputs!F9","v":0.28000000000000003},{"$f":"[1]Inputs!G9","v":0.28000000000000003},{"$f":"[1]Inputs!H9","v":0.28000000000000003},{"$f":"[1]Inputs!I9","v":0.28000000000000003},null,null,null,null,null,null,null,null,null,null,null,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003]
[0,"Days in a year",{"$f":"IF($C$5<$A18,AM18,U18)","v":365},null,null,null,null,null,null,null,null,null,null,"Working area",null,null,null,null,null,null,{"$f":"[1]Inputs!B10","v":365},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,365]
[0,"Days from mid-year to year-end",182,null,null,null,null,null,null,null,null,null,null,{"$f":"D12","v":"2018/19"},null,null,null,null,null,null,{"$f":"[1]Inputs!B11","v":182},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,182]
[0,"Days from revenue date to year-end",148,null,null,null,null,null,null,null,null,null,null,{"$f":"E12","v":"2019/20"},null,null,null,null,null,null,{"$f":"[1]Inputs!B12","v":148},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,148]
[0,"Last day of year 1 of the DPP period","2021-03-31",null,null,null,null,null,null,null,null,null,null,{"$f":"F12","v":"2020/21"},null,null,null,null,null,null,{"$f":"[1]Inputs!B13","v":"2021-03-31"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-03-31"]
[{"$f":"A45+1","v":10},"Vanilla WACC (67th percentile)",4.5699999999999998E-2,null,null,null,null,null,null,null,null,null,null,{"$f":"G12","v":"2021/22"},null,null,null,null,null,null,{"$f":"[1]Inputs!B14","v":4.5699999999999998E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.1299999999999998E-2]
[{"$f":"A22","v":10},"Cost of debt",2.92E-2,null,null,null,null,null,null,null,null,null,null,{"$f":"H12","v":"2022/23"},null,null,null,null,null,null,{"$f":"[1]Inputs!B15","v":2.92E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.61E-2]
[{"$f":"A31+1","v":3},"Leverage",0.42,null,null,null,null,null,null,null,null,null,null,{"$f":"I12","v":"2023/24"},null,null,null,null,null,null,{"$f":"[1]Inputs!B16","v":0.42},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.42]
[0,"Years of remaining life for newly commissioned assets",44,null,null,null,null,null,null,null,null,null,null,{"$f":"J12","v":"2024/25"},null,null,null,null,null,null,{"$f":"[1]Inputs!B17","v":44},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44]
[{"$f":"A56+1","v":14},"Industry-wide X factor",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]Inputs!B18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Inputs that are specific to individual distributors"]
[null,"Name","Alpine Energy","Aurora Energy","Centralines","EA Networks","Eastland Network","Electricity Invercargill","Horizon Energy","Nelson Electricity","Network Tasman","Orion NZ","OtagoNet","Powerco","The Lines Company","Top Energy","Unison Networks","Vector Lines","Wellington Electricity",null,"Alpine Energy","Aurora Energy","Centralines","EA Networks","Eastland Network","Electricity Invercargill","Horizon Energy","Nelson Electricity","Network Tasman","Orion NZ","OtagoNet","Powerco","The Lines Company","Top Energy","Unison Networks","Vector Lines","Wellington Electricity",null,"Alpine Energy","Aurora Energy","Centralines","EA Networks","Eastland Network","Electricity Invercargill","Horizon Energy","Nelson Electricity","Network Tasman","Orion NZ","OtagoNet","Powerco","The Lines Company","Top Energy","Unison Networks","Vector Lines","Wellington Electricity"]
[null,"Distributor number",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
[null,"Initial conditions"]
[{"$f":"A15+1","v":2},"Opening RAB",{"$f":"IF($C$5<$A31,AM31,U31)","v":199621},{"$f":"IF($C$5<$A31,AN31,V31)","v":394155.20342001849},{"$f":"IF($C$5<$A31,AO31,W31)","v":54013},{"$f":"IF($C$5<$A31,AP31,X31)","v":259359.00095871449},{"$f":"IF($C$5<$A31,AQ31,Y31)","v":154613.20585},{"$f":"IF($C$5<$A31,AR31,Z31)","v":84071.69550885816},{"$f":"IF($C$5<$A31,AS31,AA31)","v":124949.9691070461},{"$f":"IF($C$5<$A31,AT31,AB31)","v":41110.981972024987},{"$f":"IF($C$5<$A31,AU31,AC31)","v":165522},{"$f":"IF($C$5<$A31,AV31,AD31)","v":1051194},{"$f":"IF($C$5<$A31,AW31,AE31)","v":186531.16401204519},{"$f":"IF($C$5<$A31,AX31,AF31)","v":1657736.857110675},{"$f":"IF($C$5<$A31,AY31,AG31)","v":188818.5385963225},{"$f":"IF($C$5<$A31,AZ31,AH31)","v":251488.1610056299},{"$f":"IF($C$5<$A31,BA31,AI31)","v":586195},{"$f":"IF($C$5<$A31,BB31,AJ31)","v":2951716},{"$f":"IF($C$5<$A31,BC31,AK31)","v":611855.08145023219},null,{"$f":"[1]Inputs!B23","v":199621},{"$f":"[1]Inputs!C23","v":394155.20342001849},{"$f":"[1]Inputs!D23","v":54013},{"$f":"[1]Inputs!E23","v":259359.00095871449},{"$f":"[1]Inputs!F23","v":154613.20585},{"$f":"[1]Inputs!G23","v":84071.69550885816},{"$f":"[1]Inputs!H23","v":124949.9691070461},{"$f":"[1]Inputs!I23","v":41110.981972024987},{"$f":"[1]Inputs!J23","v":165522},{"$f":"[1]Inputs!K23","v":1051194},{"$f":"[1]Inputs!L23","v":186531.16401204519},{"$f":"[1]Inputs!M23","v":1657736.857110675},{"$f":"[1]Inputs!N23","v":188818.5385963225},{"$f":"[1]Inputs!O23","v":251488.1610056299},{"$f":"[1]Inputs!P23","v":586195},{"$f":"[1]Inputs!Q23","v":2951716},{"$f":"[1]Inputs!R23","v":611855.08145023219},null,199620.7031798572,393922,54013,259359.00095871461,154613.20583972029,84072.059866410302,124949.9691070461,41110.981972024987,165522,1051194,186531.16401204519,1657736.8593582129,188818.5385963225,251488.1610056299,586194.80000000005,2951716.3108299999,611855.08145023265]
[{"$f":"A31","v":2},"Lost assets",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"A31","v":2},"Found assets",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"A31","v":2},"Total depreciation",12793.13117340678,15058.02417019832,2033,9529.6230377798529,6088.9489571422637,3119.7714543870602,6456.2217299999993,1446.5562303904751,6807,40615.817049999998,7711.9157134074912,67007.59800619095,8412.1005965908771,9155.4759701400144,27555.254000000001,108729,26323.291818737282,null,{"$f":"[1]Inputs!B24","v":12793.13117340678},{"$f":"[1]Inputs!C24","v":15058.02417019832},{"$f":"[1]Inputs!D24","v":2033},{"$f":"[1]Inputs!E24","v":9529.6230377798529},{"$f":"[1]Inputs!F24","v":6088.9489571422637},{"$f":"[1]Inputs!G24","v":3119.7714543870602},{"$f":"[1]Inputs!H24","v":6456.2217299999993},{"$f":"[1]Inputs!I24","v":1446.5562303904751},{"$f":"[1]Inputs!J24","v":6807},{"$f":"[1]Inputs!K24","v":40615.817049999998},{"$f":"[1]Inputs!L24","v":7711.9157134074912},{"$f":"[1]Inputs!M24","v":67007.59800619095},{"$f":"[1]Inputs!N24","v":8412.1005965908771},{"$f":"[1]Inputs!O24","v":9155.4759701400144},{"$f":"[1]Inputs!P24","v":27555.254000000001},{"$f":"[1]Inputs!Q24","v":108729},{"$f":"[1]Inputs!R24","v":26323.291818737282},null,14657.680551792824,15666.766859356219,2638.5059657550169,9907.1626469275907,6020.0525486222032,3178.0373287957814,6206.2418728379353,1471.8149464772139,7299.7088335457856,42205.823490090814,7192.9493362741659,72538.671366874303,9126.4119311671911,9527.5470711652615,27671.4359250296,115387.45967056802,30673.448006297032]
[{"$f":"A31","v":2},"Revaluations",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"A31","v":2},"Closing RAB",201494.54378921399,447072.18120423768,57848,268447.16463339521,161677.5522211091,86604.996813859601,133085.9,41933.729163771379,165472,1088531.37215,194442.08945185869,1787099.8403374299,206316.43741173169,261426.14654201409,620045.32999999996,3075471,629322.99258132093,null,{"$f":"[1]Inputs!B25","v":201494.54378921399},{"$f":"[1]Inputs!C25","v":447072.18120423768},{"$f":"[1]Inputs!D25","v":57848},{"$f":"[1]Inputs!E25","v":268447.16463339521},{"$f":"[1]Inputs!F25","v":161677.5522211091},{"$f":"[1]Inputs!G25","v":86604.996813859601},{"$f":"[1]Inputs!H25","v":133085.9},{"$f":"[1]Inputs!I25","v":41933.729163771379},{"$f":"[1]Inputs!J25","v":165472},{"$f":"[1]Inputs!K25","v":1088531.37215},{"$f":"[1]Inputs!L25","v":194442.08945185869},{"$f":"[1]Inputs!M25","v":1787099.8403374299},{"$f":"[1]Inputs!N25","v":206316.43741173169},{"$f":"[1]Inputs!O25","v":261426.14654201409},{"$f":"[1]Inputs!P25","v":620045.32999999996},{"$f":"[1]Inputs!Q25","v":3075471},{"$f":"[1]Inputs!R25","v":629322.99258132093},null,208993.86587469702,480520.05262190627,55780.401936892929,278029.81255586783,163053.73780080964,86866.632276079428,126856.75876459815,41892.17865882504,173813.52122341454,1113129.1914275265,199434.08661460824,1820403.2583793846,199756.4818942718,268572.30178670579,609185.43669945502,3053381.1146817799,631633.1136820917]
[{"$f":"A24","v":3},"Opening RAB excluding revaluations",170446.47,361569.54422574752,48772,240111.30192480088,141779.87942000001,77250.2,114466.56377703784,37930,150203,965046.96399999992,173737,1517689.7834197362,166614.80105177328,224217.63158074598,536379,2695210,556622.52018648502,null,{"$f":"[1]Inputs!B26","v":170446.47},{"$f":"[1]Inputs!C26","v":361569.54422574752},{"$f":"[1]Inputs!D26","v":48772},{"$f":"[1]Inputs!E26","v":240111.30192480088},{"$f":"[1]Inputs!F26","v":141779.87942000001},{"$f":"[1]Inputs!G26","v":77250.2},{"$f":"[1]Inputs!H26","v":114466.56377703784},{"$f":"[1]Inputs!I26","v":37930},{"$f":"[1]Inputs!J26","v":150203},{"$f":"[1]Inputs!K26","v":965046.96399999992},{"$f":"[1]Inputs!L26","v":173737},{"$f":"[1]Inputs!M26","v":1517689.7834197362},{"$f":"[1]Inputs!N26","v":166614.80105177328},{"$f":"[1]Inputs!O26","v":224217.63158074598},{"$f":"[1]Inputs!P26","v":536379},{"$f":"[1]Inputs!Q26","v":2695210},{"$f":"[1]Inputs!R26","v":556622.52018648502},null,203325.75896758441,361563.5,48747.224288304395,239189.60933261772,141773.74220004317,77208.891745459798,114782.71695959922,37936.33016062274,149927.85257238548,964649.63372234919,171841.69881368813,1514714.9474712948,168225.2524804578,224194.23986715591,536307.9834933409,2687318.4765874529,556618.54348370002]
[{"$f":"$A$36+1","v":3},"Adjusted depreciation",10635.430916170135,13630.7986916892,1934,8731.3741433898904,5287.9484400000001,2844.8539999999998,5022.3270200007209,1354,6290,36341.389000000003,7161,60760.817678568899,7730.9831109175566,7999.2173910088077,25169,99210,23190.279411230553,null,{"$f":"[1]Inputs!B27","v":10635.430916170135},{"$f":"[1]Inputs!C27","v":13630.7986916892},{"$f":"[1]Inputs!D27","v":1934},{"$f":"[1]Inputs!E27","v":8731.3741433898904},{"$f":"[1]Inputs!F27","v":5287.9484400000001},{"$f":"[1]Inputs!G27","v":2844.8539999999998},{"$f":"[1]Inputs!H27","v":5022.3270200007209},{"$f":"[1]Inputs!I27","v":1354},{"$f":"[1]Inputs!J27","v":6290},{"$f":"[1]Inputs!K27","v":36341.389000000003},{"$f":"[1]Inputs!L27","v":7161},{"$f":"[1]Inputs!M27","v":60760.817678568899},{"$f":"[1]Inputs!N27","v":7730.9831109175566},{"$f":"[1]Inputs!O27","v":7999.2173910088077},{"$f":"[1]Inputs!P27","v":25169},{"$f":"[1]Inputs!Q27","v":99210},{"$f":"[1]Inputs!R27","v":23190.279411230553},null,14929.734117870816,14379.829152352095,2381.2756576877605,9136.7191975362621,5520.1324713740314,2918.6003111130931,5701.2363377415049,1358.159184397332,6611.9891604571749,38731.035537366297,6626.499330408541,66280.368424485903,8131.0498575756119,8493.5257583382863,25316.519357247478,105051.71218571953,27904.336288946521]
[3,"Tax depreciation",14782.759912538904,21650,2186,11910.710938979737,6271.2953399997159,3313.98,5404.5006091970481,1297,5114,32004.274999999998,15388,79612.315544819998,4330.0359719999988,11576.768156254197,30035,103486,28793.117962970849,null,{"$f":"[1]Inputs!B28","v":14782.759912538904},{"$f":"[1]Inputs!C28","v":21650},{"$f":"[1]Inputs!D28","v":2186},{"$f":"[1]Inputs!E28","v":11910.710938979737},{"$f":"[1]Inputs!F28","v":6271.2953399997159},{"$f":"[1]Inputs!G28","v":3313.98},{"$f":"[1]Inputs!H28","v":5404.5006091970481},{"$f":"[1]Inputs!I28","v":1297},{"$f":"[1]Inputs!J28","v":5114},{"$f":"[1]Inputs!K28","v":32004.274999999998},{"$f":"[1]Inputs!L28","v":15388},{"$f":"[1]Inputs!M28","v":79612.315544819998},{"$f":"[1]Inputs!N28","v":4330.0359719999988},{"$f":"[1]Inputs!O28","v":11576.768156254197},{"$f":"[1]Inputs!P28","v":30035},{"$f":"[1]Inputs!Q28","v":103486},{"$f":"[1]Inputs!R28","v":28793.117962970849},null,15569.582966180045,24098.090217598266,2146.0176184690158,12197.394749866642,6214.8713698377505,3255.6238891202497,5153.8527008334368,1283.5321696448718,4667.473348166779,46081.940077978019,15134.169144885211,71110.920042551908,4785.5618949446125,11094.771179358815,29192.065302798765,101502.90667691195,29304.368626157408]
[3,"Opening regulatory tax asset value",122940.02874936687,222185.91470027712,24349,134591.63086295308,70250.535713750753,41317.030000000006,51284.962998490366,18165,63134,400019.63159,95268,1025176.28156504,45756,136251.1718910354,313784,1224826,351370.70442136371,null,{"$f":"[1]Inputs!B29","v":122940.02874936687},{"$f":"[1]Inputs!C29","v":222185.91470027712},{"$f":"[1]Inputs!D29","v":24349},{"$f":"[1]Inputs!E29","v":134591.63086295308},{"$f":"[1]Inputs!F29","v":70250.535713750753},{"$f":"[1]Inputs!G29","v":41317.030000000006},{"$f":"[1]Inputs!H29","v":51284.962998490366},{"$f":"[1]Inputs!I29","v":18165},{"$f":"[1]Inputs!J29","v":63134},{"$f":"[1]Inputs!K29","v":400019.63159},{"$f":"[1]Inputs!L29","v":95268},{"$f":"[1]Inputs!M29","v":1025176.28156504},{"$f":"[1]Inputs!N29","v":45756},{"$f":"[1]Inputs!O29","v":136251.1718910354},{"$f":"[1]Inputs!P29","v":313784},{"$f":"[1]Inputs!Q29","v":1224826},{"$f":"[1]Inputs!R29","v":351370.70442136371},null,122940.02874936687,234075,24361,135023.01643917066,70420.646053744218,41298.600000000006,51563.82528558209,18236.934560000002,63876,416309.54044999997,94615.366807225539,1001328.026761567,48557.932816322544,136235.18035103544,316064.48200000002,1230174.594951462,353460.32927010657]
[3,"Amortisation of initial differences in asset values",2756.1747845868776,4989.9524061343209,1254.5,2142.610348679998,1900.5760598863596,1268.3684210526317,4218.9445353069541,693.05,3239.1631535884967,15323.202053922892,1343.5454545454545,10201.180992856574,4085.2698642630403,3399.105263157895,5670.1,34300.677419354841,7150.7843480592637,null,{"$f":"[1]Inputs!B30","v":2756.1747845868776},{"$f":"[1]Inputs!C30","v":4989.9524061343209},{"$f":"[1]Inputs!D30","v":1254.5},{"$f":"[1]Inputs!E30","v":2142.610348679998},{"$f":"[1]Inputs!F30","v":1900.5760598863596},{"$f":"[1]Inputs!G30","v":1268.3684210526317},{"$f":"[1]Inputs!H30","v":4218.9445353069541},{"$f":"[1]Inputs!I30","v":693.05},{"$f":"[1]Inputs!J30","v":3239.1631535884967},{"$f":"[1]Inputs!K30","v":15323.202053922892},{"$f":"[1]Inputs!L30","v":1343.5454545454545},{"$f":"[1]Inputs!M30","v":10201.180992856574},{"$f":"[1]Inputs!N30","v":4085.2698642630403},{"$f":"[1]Inputs!O30","v":3399.105263157895},{"$f":"[1]Inputs!P30","v":5670.1},{"$f":"[1]Inputs!Q30","v":34300.677419354841},{"$f":"[1]Inputs!R30","v":7150.7843480592637},null,2756.1747845868776,4992.5665494726272,1254.5384615384614,2142.6105480844922,1904.4991650282707,1268.3499999999999,4218.9445353069541,693.04545454545462,3239.3603239371623,15348.548132354266,1345,10277.92979391625,4085.2578979855448,3399.1052631578946,5670.0952380952385,34390.625,7150.7843480592637]
[{"$f":"A80+1","v":8},"Term credit spread differential allowance",0,0,0,0,0,0,0,0,0,788.45529410731547,0,1966.526362123079,0,0,440.18873192767637,3983.6873940243322,362.46155455940988,null,{"$f":"[1]Inputs!B31","v":0},{"$f":"[1]Inputs!C31","v":0},{"$f":"[1]Inputs!D31","v":0},{"$f":"[1]Inputs!E31","v":0},{"$f":"[1]Inputs!F31","v":0},{"$f":"[1]Inputs!G31","v":0},{"$f":"[1]Inputs!H31","v":0},{"$f":"[1]Inputs!I31","v":0},{"$f":"[1]Inputs!J31","v":0},{"$f":"[1]Inputs!K31","v":788.45529410731547},{"$f":"[1]Inputs!L31","v":0},{"$f":"[1]Inputs!M31","v":1966.526362123079},{"$f":"[1]Inputs!N31","v":0},{"$f":"[1]Inputs!O31","v":0},{"$f":"[1]Inputs!P31","v":440.18873192767637},{"$f":"[1]Inputs!Q31","v":3983.6873940243322},{"$f":"[1]Inputs!R31","v":362.46155455940988},null,0,0,0,0,0,0,0,0,0,0,0,0,40.474612206885908,0,1.1462629980284458,805.25668261036969,591.63475735585689]
[{"$f":"A37","v":3},"Opening deferred tax balance",-6546.4247455849472,-18008.439662752455,-2740,-12614.867288168751,-7364,-3433.9625072251488,0,-1441,-1612.3519205251705,-43149.148637470855,-12352,-60532.961543424855,-12008,-10180.726118980281,-29786,-83664,-33852.900993842857,null,{"$f":"[1]Inputs!B32","v":-6546.4247455849472},{"$f":"[1]Inputs!C32","v":-18008.439662752455},{"$f":"[1]Inputs!D32","v":-2740},{"$f":"[1]Inputs!E32","v":-12614.867288168751},{"$f":"[1]Inputs!F32","v":-7364},{"$f":"[1]Inputs!G32","v":-3433.9625072251488},{"$f":"[1]Inputs!H32","v":0},{"$f":"[1]Inputs!I32","v":-1441},{"$f":"[1]Inputs!J32","v":-1612.3519205251705},{"$f":"[1]Inputs!K32","v":-43149.148637470855},{"$f":"[1]Inputs!L32","v":-12352},{"$f":"[1]Inputs!M32","v":-60532.961543424855},{"$f":"[1]Inputs!N32","v":-12008},{"$f":"[1]Inputs!O32","v":-10180.726118980281},{"$f":"[1]Inputs!P32","v":-29786},{"$f":"[1]Inputs!Q32","v":-83664},{"$f":"[1]Inputs!R32","v":-33852.900993842857},null,-6558.1194397339423,-22753.598633852336,-2742.750769230769,-12536.519785349728,-7388.3041067579425,-3456.6589199999999,-997.92454777477246,-1471.2759322867371,-1578.9406550414619,-45788.678915590877,-12560.96,-68683.500145583763,-9922.8532241407174,-10333.351396102738,-30234.731706666666,-83246.815000000002,-33671.506440642857]
[{"$f":"A22+1","v":11},"Adjustment factor (for accelerated depreciation)",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,{"$f":"[1]Inputs!B33","v":1},{"$f":"[1]Inputs!C33","v":1},{"$f":"[1]Inputs!D33","v":1},{"$f":"[1]Inputs!E33","v":1},{"$f":"[1]Inputs!F33","v":1},{"$f":"[1]Inputs!G33","v":1},{"$f":"[1]Inputs!H33","v":1},{"$f":"[1]Inputs!I33","v":1},{"$f":"[1]Inputs!J33","v":1},{"$f":"[1]Inputs!K33","v":1},{"$f":"[1]Inputs!L33","v":1},{"$f":"[1]Inputs!M33","v":1},{"$f":"[1]Inputs!N33","v":1},{"$f":"[1]Inputs!O33","v":1},{"$f":"[1]Inputs!P33","v":1},{"$f":"[1]Inputs!Q33","v":1},{"$f":"[1]Inputs!R33","v":1},null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[{"$f":"A42+1","v":9},"Additional allowance in 1 April 2015 PV terms",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"[1]Inputs!B34","v":0},{"$f":"[1]Inputs!C34","v":0},{"$f":"[1]Inputs!D34","v":0},{"$f":"[1]Inputs!E34","v":0},{"$f":"[1]Inputs!F34","v":0},{"$f":"[1]Inputs!G34","v":0},{"$f":"[1]Inputs!H34","v":0},{"$f":"[1]Inputs!I34","v":0},{"$f":"[1]Inputs!J34","v":0},{"$f":"[1]Inputs!K34","v":0},{"$f":"[1]Inputs!L34","v":0},{"$f":"[1]Inputs!M34","v":0},{"$f":"[1]Inputs!N34","v":0},{"$f":"[1]Inputs!O34","v":0},{"$f":"[1]Inputs!P34","v":0},{"$f":"[1]Inputs!Q34","v":0},{"$f":"[1]Inputs!R34","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"A26","v":14},"Alternative X factor",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"[1]Inputs!B35","v":0},{"$f":"[1]Inputs!C35","v":0},{"$f":"[1]Inputs!D35","v":0},{"$f":"[1]Inputs!E35","v":0},{"$f":"[1]Inputs!F35","v":0},{"$f":"[1]Inputs!G35","v":0},{"$f":"[1]Inputs!H35","v":0},{"$f":"[1]Inputs!I35","v":0},{"$f":"[1]Inputs!J35","v":0},{"$f":"[1]Inputs!K35","v":0},{"$f":"[1]Inputs!L35","v":0},{"$f":"[1]Inputs!M35","v":0},{"$f":"[1]Inputs!N35","v":0},{"$f":"[1]Inputs!O35","v":0},{"$f":"[1]Inputs!P35","v":0},{"$f":"[1]Inputs!Q35","v":0},{"$f":"[1]Inputs!R35","v":0},null,0,-8.8999999999999996E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Operating expenditure",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,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,{"$f":"AM28","v":"Alpine Energy"},{"$f":"AN28","v":"Aurora Energy"},"Centralines","EA Networks","Eastland Network","Electricity Invercargill","Horizon Energy","Nelson Electricity","Network Tasman","Orion NZ","OtagoNet","Powerco","The Lines Company","Top Energy","Unison Networks","Vector Lines","Wellington Electricity"]
[{"$f":"A72+1","v":6},{"$f":"\"Operating expenditure, \" & N19","v":"Operating expenditure, 2018/19"},{"$f":"IF($C$5<$A48,AM48,U48)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF($C$5<$A48,AW48,AE48)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"$A$48","v":6},"Operating expenditure, 2019/20",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[6,"Operating expenditure, 2020/21",19420.272954529883,44723.360920152074,4226.3554367558718,11823.138001241525,10615.39048330826,5180.7118078829417,9885.6120036048451,2246.8374172983913,11157.711965454881,64153.54839840129,9162.9239113704207,93422.96777908341,14911.902690078447,16021.47849146213,41582.387166609762,127351.13794047505,35667.657349661255,null,{"$f":"[1]Inputs!B37","v":19420.272954529883},{"$f":"[1]Inputs!C37","v":44723.360920152074},{"$f":"[1]Inputs!D37","v":4226.3554367558718},{"$f":"[1]Inputs!E37","v":11823.138001241525},{"$f":"[1]Inputs!F37","v":10615.39048330826},{"$f":"[1]Inputs!G37","v":5180.7118078829417},{"$f":"[1]Inputs!H37","v":9885.6120036048451},{"$f":"[1]Inputs!I37","v":2246.8374172983913},{"$f":"[1]Inputs!J37","v":11157.711965454881},{"$f":"[1]Inputs!K37","v":64153.54839840129},{"$f":"[1]Inputs!L37","v":9162.9239113704207},{"$f":"[1]Inputs!M37","v":93422.96777908341},{"$f":"[1]Inputs!N37","v":14911.902690078447},{"$f":"[1]Inputs!O37","v":16021.47849146213},{"$f":"[1]Inputs!P37","v":41582.387166609762},{"$f":"[1]Inputs!Q37","v":127351.13794047505},{"$f":"[1]Inputs!R37","v":35667.657349661255},null,18958.276946638656,40108.011823833454,3806.1035610359422,13505.518335269502,10850.673003621854,4993.6381879395394,11291.424244719281,2122.3834934306274,12096.421505489916,61022.970538681177,7993.8429067435736,77973.235454996873,13361.496064728846,17657.336474308046,42559.575262890154,128568.69026643208,36822.095771989247,null,{"$f":"U50/AM50-1","v":2.4369092676069348E-2},{"$f":"V50/AN50-1","v":0.11507299630284917},0.1104152498692248,-0.12456984561891715,-2.1683679918753418E-2,3.7462389725233969E-2,-0.12450265003300176,5.8638754142681382E-2,-7.7602251178913173E-2,5.1301630059711778E-2,0.14624768315632219,0.19814148064951742,0.11603540635260923,-9.2644662756817153E-2,-2.2960475762370924E-2,-9.4700531166173052E-3,-3.1351784794557469E-2]
[6,"Operating expenditure, 2021/22",20012.120279799667,46248.530101285549,4334.1752993991695,12215.64195402153,10898.081808208053,5310.5866354806431,10170.692704882435,2316.9756478733179,11513.079497756995,66487.65442505297,9425.276484157599,96485.788832775754,{"$f":"IF($C$5<$A51,AY51,AG51)","v":15303.187164084151},16537.344449902448,42904.143031967935,132448.68478800423,36792.115466627467,null,{"$f":"[1]Inputs!B38","v":20012.120279799667},{"$f":"[1]Inputs!C38","v":46248.530101285549},{"$f":"[1]Inputs!D38","v":4334.1752993991695},{"$f":"[1]Inputs!E38","v":12215.64195402153},{"$f":"[1]Inputs!F38","v":10898.081808208053},{"$f":"[1]Inputs!G38","v":5310.5866354806431},{"$f":"[1]Inputs!H38","v":10170.692704882435},{"$f":"[1]Inputs!I38","v":2316.9756478733179},{"$f":"[1]Inputs!J38","v":11513.079497756995},{"$f":"[1]Inputs!K38","v":66487.65442505297},{"$f":"[1]Inputs!L38","v":9425.276484157599},{"$f":"[1]Inputs!M38","v":96485.788832775754},{"$f":"[1]Inputs!N38","v":15303.187164084151},{"$f":"[1]Inputs!O38","v":16537.344449902448},{"$f":"[1]Inputs!P38","v":42904.143031967935},{"$f":"[1]Inputs!Q38","v":132448.68478800423},{"$f":"[1]Inputs!R38","v":36792.115466627467},null,19558.637493681341,41758.76769146006,3878.3363917134388,13998.541161294139,11158.752543311444,5127.7120589193073,11609.988003759416,2191.9995034515282,12483.735923206545,63364.75771341793,8233.4095515932786,80518.993761888094,13747.626578897372,18209.314126979465,43930.833229772288,133812.7745187846,38003.600109218081,null,{"$f":"U51/AM51-1","v":2.3185806591324631E-2},0.10751664040947451,0.11753464930470936,-0.12736321497573699,-2.3360203937817126E-2,3.5663971467204014E-2,-0.12397043807546781,5.7014677341396203E-2,-7.7753681383563644E-2,4.9284441767442289E-2,0.14475982581647218,0.1982984923793869,0.11315121022959462,-9.1819475759373992E-2,-2.3370606071467792E-2,-1.0194017243016495E-2,-3.1878154677686954E-2]
[6,"Operating expenditure, 2022/23",20629.432088719677,48129.315518557181,4446.3502257826885,12625.159114988157,11192.331982694157,5445.680405811705,10485.3193626175,2390.165824962854,11880.376540380918,68931.505534761251,9698.6497569249568,99415.113273788185,15708.68537776473,17051.661586794446,44325.326030975797,137800.82316421505,37965.379905078691,null,{"$f":"[1]Inputs!B39","v":20629.432088719677},{"$f":"[1]Inputs!C39","v":48129.315518557181},{"$f":"[1]Inputs!D39","v":4446.3502257826885},{"$f":"[1]Inputs!E39","v":12625.159114988157},{"$f":"[1]Inputs!F39","v":11192.331982694157},{"$f":"[1]Inputs!G39","v":5445.680405811705},{"$f":"[1]Inputs!H39","v":10485.3193626175},{"$f":"[1]Inputs!I39","v":2390.165824962854},{"$f":"[1]Inputs!J39","v":11880.376540380918},{"$f":"[1]Inputs!K39","v":68931.505534761251},{"$f":"[1]Inputs!L39","v":9698.6497569249568},{"$f":"[1]Inputs!M39","v":99415.113273788185},{"$f":"[1]Inputs!N39","v":15708.68537776473},{"$f":"[1]Inputs!O39","v":17051.661586794446},{"$f":"[1]Inputs!P39","v":44325.326030975797},{"$f":"[1]Inputs!Q39","v":137800.82316421505},{"$f":"[1]Inputs!R39","v":37965.379905078691},null,20151.664485930934,43420.908903501382,3946.8296920787952,14490.62342699757,11460.596104652341,5258.5117159874426,11921.954918972449,2260.9429892442176,12866.63177554082,65710.500622341147,8469.0895026924536,83039.307066642708,14126.453378906586,18754.029575690336,45287.070744786346,139088.9347257691,39171.805331207077,null,2.3708592564266828E-2,0.10843639007004113,0.12656247486594641,-0.12873595959535156,-2.3407519077413785E-2,3.5593472056972608E-2,-0.12050335419979707,5.7154398113254734E-2,-7.6652169143034854E-2,4.9018115551001884E-2,0.14518210651116714,0.19720547756983531,0.11200490005656416,-9.0773451221521029E-2,-2.1236628865453189E-2,-9.2610642542753085E-3,-3.0798310568730947E-2]
[6,"Operating expenditure, 2023/24",21237.104508905344,50194.342279207958,4555.1256011520263,13063.733466005098,11497.233733516021,5585.0372989621037,10832.659285539019,2464.9982164724033,12252.618877414719,71320.638016152108,9957.7843427989283,102609.67054767133,16108.546154128071,17569.351795284168,45716.096451782498,142973.17103060253,39168.447023023255,null,{"$f":"[1]Inputs!B40","v":21237.104508905344},{"$f":"[1]Inputs!C40","v":50194.342279207958},{"$f":"[1]Inputs!D40","v":4555.1256011520263},{"$f":"[1]Inputs!E40","v":13063.733466005098},{"$f":"[1]Inputs!F40","v":11497.233733516021},{"$f":"[1]Inputs!G40","v":5585.0372989621037},{"$f":"[1]Inputs!H40","v":10832.659285539019},{"$f":"[1]Inputs!I40","v":2464.9982164724033},{"$f":"[1]Inputs!J40","v":12252.618877414719},{"$f":"[1]Inputs!K40","v":71320.638016152108},{"$f":"[1]Inputs!L40","v":9957.7843427989283},{"$f":"[1]Inputs!M40","v":102609.67054767133},{"$f":"[1]Inputs!N40","v":16108.546154128071},{"$f":"[1]Inputs!O40","v":17569.351795284168},{"$f":"[1]Inputs!P40","v":45716.096451782498},{"$f":"[1]Inputs!Q40","v":142973.17103060253},{"$f":"[1]Inputs!R40","v":39168.447023023255},null,20709.745700797332,44972.792354924939,4003.1421856006937,14960.726799282529,11738.52793141958,5379.5426443404731,12207.886986406404,2324.8093943259764,13221.662226857259,67829.469063978977,8674.7314942292178,85377.367302904866,14453.917895431272,19260.571627431244,46545.184991604692,143907.62483879959,40251.974246870675,null,2.5464282165845731E-2,0.11610464129233034,0.13788753682964794,-0.12679820698071997,-2.0555745943041659E-2,3.8199279791530261E-2,-0.11265075622003329,6.0301211139535793E-2,-7.3292096925159256E-2,5.146979624564274E-2,0.14790692362331326,0.20183690115003294,0.11447610749330517,-8.7807354052691244E-2,-1.781255225372369E-2,-6.4934280531958599E-3,-2.6918610679863897E-2]
[{"$f":"$A$48","v":6},"Operating expenditure, 2024/25",21815.917390452156,51957.912857729047,4656.5817269339068,13485.875623804186,11783.558278263976,5715.7104429980354,11113.449993116894,2536.7168571561815,12609.498185049688,73634.73385941294,10201.98054950084,106186.76391969755,16483.229017258454,18063.176010234187,47028.877622765081,148015.88957073344,40320.616474967421,null,{"$f":"[1]Inputs!B41","v":21815.917390452156},{"$f":"[1]Inputs!C41","v":51957.912857729047},{"$f":"[1]Inputs!D41","v":4656.5817269339068},{"$f":"[1]Inputs!E41","v":13485.875623804186},{"$f":"[1]Inputs!F41","v":11783.558278263976},{"$f":"[1]Inputs!G41","v":5715.7104429980354},{"$f":"[1]Inputs!H41","v":11113.449993116894},{"$f":"[1]Inputs!I41","v":2536.7168571561815},{"$f":"[1]Inputs!J41","v":12609.498185049688},{"$f":"[1]Inputs!K41","v":73634.73385941294},{"$f":"[1]Inputs!L41","v":10201.98054950084},{"$f":"[1]Inputs!M41","v":106186.76391969755},{"$f":"[1]Inputs!N41","v":16483.229017258454},{"$f":"[1]Inputs!O41","v":18063.176010234187},{"$f":"[1]Inputs!P41","v":47028.877622765081},{"$f":"[1]Inputs!Q41","v":148015.88957073344},{"$f":"[1]Inputs!R41","v":40320.616474967421},null,21127.611304526552,46239.737867860451,4030.604862307755,15333.112267591536,11935.258063405265,5463.1066391195845,12409.246761078697,2372.9952275501546,13487.113393674954,69504.648167319683,8820.3780218850552,87139.194813886483,14680.817391510518,19636.115822609016,47488.358818785418,147804.19696153956,41059.393786436354,null,3.2578509515561516E-2,0.12366365497593113,0.15530593695253558,-0.12047369193870161,-1.2710222463175436E-2,4.6238124306348771E-2,-0.10442187127957181,6.8993661557023245E-2,-6.5070648033317524E-2,5.942171928056994E-2,0.15663756408033347,0.21858784840155132,0.1227732474072063,-8.0104427300420888E-2,-9.6756596237345116E-3,1.4322503254016183E-3,-1.7992893789702813E-2]
[null,"Constant price revenue growth",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zeroed"]
[{"$f":"A16+1","v":13},{"$f":"\"Constant price revenue growth, \" & N19","v":"Constant price revenue growth, 2018/19"},{"$f":"IF($C$5<$A56,AM56,U56)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF($C$5<$A56,AW56,AE56)","v":0},0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"$A$56","v":13},"Constant price revenue growth, 2019/20",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[13,"Constant price revenue growth, 2020/21",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[13,"Constant price revenue growth, 2021/22",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[13,"Constant price revenue growth, 2022/23",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[13,"Constant price revenue growth, 2023/24",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[13,"Constant price revenue growth, 2024/25",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Value of commissioned assets",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VCA ex AMPs"]
[{"$f":"A37+1","v":4},{"$f":"\"Value of commissioned assets, \" & N19","v":"Value of commissioned assets, 2018/19"},{"$f":"IF($C$5<$A64,AM64,U64)","v":17961.779926267081},63004.353999999992,5064,16375.665660000061,11755.60458000001,4533.37,12884.01,1659.3481999999999,6557,63636.967999999993,{"$f":"IF($C$5<$A64,AW64,AE64)","v":12936.768609999999},185312.73427243941,23462.783690000011,15378.413930000001,53881.408000000003,203460,37191.001710000019,null,{"$f":"[1]Inputs!B43","v":17961.779926267081},{"$f":"[1]Inputs!C43","v":63004.353999999992},{"$f":"[1]Inputs!D43","v":5064},{"$f":"[1]Inputs!E43","v":16375.665660000061},{"$f":"[1]Inputs!F43","v":11755.60458000001},{"$f":"[1]Inputs!G43","v":4533.37},{"$f":"[1]Inputs!H43","v":12884.01},{"$f":"[1]Inputs!I43","v":1659.3481999999999},{"$f":"[1]Inputs!J43","v":6557},{"$f":"[1]Inputs!K43","v":63636.967999999993},{"$f":"[1]Inputs!L43","v":12936.768609999999},{"$f":"[1]Inputs!M43","v":185312.73427243941},{"$f":"[1]Inputs!N43","v":23462.783690000011},{"$f":"[1]Inputs!O43","v":15378.413930000001},{"$f":"[1]Inputs!P43","v":53881.408000000003},{"$f":"[1]Inputs!Q43","v":203460},{"$f":"[1]Inputs!R43","v":37191.001710000019},null,21003.335899999998,96115.466713262475,3568.1389877000001,25588.00668139648,12171.17963914286,4750.0891795428379,6429.0871782834283,1683,13532,89138,17452.59506560567,220284,17591.638879999999,22622.202911560002,44116.604396382347,181452,40675.693591565563]
[{"$f":"$A$64","v":4},"Value of commissioned assets, 2019/20",14014,76195.241831549603,6913.2636087999999,21629.30733276367,9803.8482899999999,5750.2225108244311,8296.868167577617,1552,15593,66443.232000000004,23187.72481631265,180476,18922.355345399999,31785.322032399999,50412.921529999992,240761,52409.994278901962,null,{"$f":"[1]Inputs!B44","v":14014},{"$f":"[1]Inputs!C44","v":76195.241831549603},{"$f":"[1]Inputs!D44","v":6913.2636087999999},{"$f":"[1]Inputs!E44","v":21629.30733276367},{"$f":"[1]Inputs!F44","v":9803.8482899999999},{"$f":"[1]Inputs!G44","v":5750.2225108244311},{"$f":"[1]Inputs!H44","v":8296.868167577617},{"$f":"[1]Inputs!I44","v":1552},{"$f":"[1]Inputs!J44","v":15593},{"$f":"[1]Inputs!K44","v":66443.232000000004},{"$f":"[1]Inputs!L44","v":23187.72481631265},{"$f":"[1]Inputs!M44","v":180476},{"$f":"[1]Inputs!N44","v":18922.355345399999},{"$f":"[1]Inputs!O44","v":31785.322032399999},{"$f":"[1]Inputs!P44","v":50412.921529999992},{"$f":"[1]Inputs!Q44","v":240761},{"$f":"[1]Inputs!R44","v":52409.994278901962},null,10680.654,75591.46228501889,3757.9375839600002,21189.323630501462,11640.21011946,1899.110302454993,7324.6520518428079,1345.32,12803,59334,16885.660941239988,166854,16746.314709999999,25001.257268959998,44601.058773243793,179966,45090.896687565553]
[4,"Value of commissioned assets, 2020/21",16663.084987074293,50947.773510247447,6059.7473996468661,18050.3141257922,9684.9777776781502,4655.6235108371211,8322.4692415684531,1627.4748243189306,10289.860370686423,72172.38359853992,13989.584671125622,{"$error":"#N/A"},18320.860042033932,14593.153311847902,46746.124751395197,211119.9718515854,37748.022005345745,null,{"$f":"[1]Inputs!B45","v":16663.084987074293},{"$f":"[1]Inputs!C45","v":50947.773510247447},{"$f":"[1]Inputs!D45","v":6059.7473996468661},{"$f":"[1]Inputs!E45","v":18050.3141257922},{"$f":"[1]Inputs!F45","v":9684.9777776781502},{"$f":"[1]Inputs!G45","v":4655.6235108371211},{"$f":"[1]Inputs!H45","v":8322.4692415684531},{"$f":"[1]Inputs!I45","v":1627.4748243189306},{"$f":"[1]Inputs!J45","v":10289.860370686423},{"$f":"[1]Inputs!K45","v":72172.38359853992},{"$f":"[1]Inputs!L45","v":13989.584671125622},{"$f":"[1]Inputs!M45","v":{"$error":"#N/A"}},{"$f":"[1]Inputs!N45","v":18320.860042033932},{"$f":"[1]Inputs!O45","v":14593.153311847902},{"$f":"[1]Inputs!P45","v":46746.124751395197},{"$f":"[1]Inputs!Q45","v":211119.9718515854},{"$f":"[1]Inputs!R45","v":37748.022005345745},null,16681.113444048009,29927.530156225781,2840.1600780067397,19238.755803564592,8521.1039534160755,4512.9760582654108,8241.8965018426552,1491.0124194304078,5449.3569538076672,60621.182211935862,14983.409751209272,{"$error":"#N/A"},12186.895631365316,22807.153782335368,45181.927475964083,169613.40037938426,42385.314000527658]
[4,"Value of commissioned assets, 2021/22",16978.399454502294,50750.308330537278,2773.8307717314538,17941.493243003944,10136.401061103601,5052.9447714077578,6720.079498778955,1709.8203732676643,12261.460641572261,63777.111872759626,13504.173049339088,{"$error":"#N/A"},16919.227905563937,15127.253970962542,52524.928561752349,209600.00629559506,35509.954336362658,null,{"$f":"[1]Inputs!B46","v":16978.399454502294},{"$f":"[1]Inputs!C46","v":50750.308330537278},{"$f":"[1]Inputs!D46","v":2773.8307717314538},{"$f":"[1]Inputs!E46","v":17941.493243003944},{"$f":"[1]Inputs!F46","v":10136.401061103601},{"$f":"[1]Inputs!G46","v":5052.9447714077578},{"$f":"[1]Inputs!H46","v":6720.079498778955},{"$f":"[1]Inputs!I46","v":1709.8203732676643},{"$f":"[1]Inputs!J46","v":12261.460641572261},{"$f":"[1]Inputs!K46","v":63777.111872759626},{"$f":"[1]Inputs!L46","v":13504.173049339088},{"$f":"[1]Inputs!M46","v":{"$error":"#N/A"}},{"$f":"[1]Inputs!N46","v":16919.227905563937},{"$f":"[1]Inputs!O46","v":15127.253970962542},{"$f":"[1]Inputs!P46","v":52524.928561752349},{"$f":"[1]Inputs!Q46","v":209600.00629559506},{"$f":"[1]Inputs!R46","v":35509.954336362658},null,16097.182987487175,30649.844920130683,2668.1653367239569,19088.258317445579,7729.7758315603132,3804.7009313521835,6286.9861607815128,1617.7885931558935,6787.6506601845304,64785.619100677803,15216.954548011972,{"$error":"#N/A"},12286.823555805811,16698.185971781397,44799.497303536431,190827.14293499591,31714.420593331961]
[4,"Value of commissioned assets, 2022/23",15377.140956497071,48245.581949487467,3967.7815608953551,17796.759119063441,8982.1740783163259,5567.5747524279859,8075.3672553967899,1663.731588304842,9042.3641329302391,89623.654410387855,18002.808964582848,{"$error":"#N/A"},15873.676646380469,16514.785707311417,50530.601455491415,213423.98232804175,37677.090517057499,null,{"$f":"[1]Inputs!B47","v":15377.140956497071},{"$f":"[1]Inputs!C47","v":48245.581949487467},{"$f":"[1]Inputs!D47","v":3967.7815608953551},{"$f":"[1]Inputs!E47","v":17796.759119063441},{"$f":"[1]Inputs!F47","v":8982.1740783163259},{"$f":"[1]Inputs!G47","v":5567.5747524279859},{"$f":"[1]Inputs!H47","v":8075.3672553967899},{"$f":"[1]Inputs!I47","v":1663.731588304842},{"$f":"[1]Inputs!J47","v":9042.3641329302391},{"$f":"[1]Inputs!K47","v":89623.654410387855},{"$f":"[1]Inputs!L47","v":18002.808964582848},{"$f":"[1]Inputs!M47","v":{"$error":"#N/A"}},{"$f":"[1]Inputs!N47","v":15873.676646380469},{"$f":"[1]Inputs!O47","v":16514.785707311417},{"$f":"[1]Inputs!P47","v":50530.601455491415},{"$f":"[1]Inputs!Q47","v":213423.98232804175},{"$f":"[1]Inputs!R47","v":37677.090517057499},null,13450.520289414944,30012.270494024629,2700.8873454212771,18058.857349179612,7311.3171231232263,4167.9236209454666,6750.0241916920213,1652.1032567366506,6445.3628322677341,69550.184618945277,15966.67853842666,{"$error":"#N/A"},11928.516513138822,16364.168998721658,44115.774411087514,204070.25061744457,33652.831305661442]
[4,"Value of commissioned assets, 2023/24",14672.777154184731,38772.738517131242,2840.7102307855239,15710.84150223012,9383.3630278770361,5578.0770141048597,8520.7632766490988,1665.5343513423325,10071.951141968706,79929.574002059759,23071.296835907422,{"$error":"#N/A"},16558.302274241945,16264.117073022302,46851.604858224193,209518.18392710513,39911.186049068143,null,{"$f":"[1]Inputs!B48","v":14672.777154184731},{"$f":"[1]Inputs!C48","v":38772.738517131242},{"$f":"[1]Inputs!D48","v":2840.7102307855239},{"$f":"[1]Inputs!E48","v":15710.84150223012},{"$f":"[1]Inputs!F48","v":9383.3630278770361},{"$f":"[1]Inputs!G48","v":5578.0770141048597},{"$f":"[1]Inputs!H48","v":8520.7632766490988},{"$f":"[1]Inputs!I48","v":1665.5343513423325},{"$f":"[1]Inputs!J48","v":10071.951141968706},{"$f":"[1]Inputs!K48","v":79929.574002059759},{"$f":"[1]Inputs!L48","v":23071.296835907422},{"$f":"[1]Inputs!M48","v":{"$error":"#N/A"}},{"$f":"[1]Inputs!N48","v":16558.302274241945},{"$f":"[1]Inputs!O48","v":16264.117073022302},{"$f":"[1]Inputs!P48","v":46851.604858224193},{"$f":"[1]Inputs!Q48","v":209518.18392710513},{"$f":"[1]Inputs!R48","v":39911.186049068143},null,14062.531547511186,28159.610435630806,3232.5638036770256,15819.044084241947,8261.2538549523524,4125.9527914392984,7480.1509314968234,1843.280187770629,4310.2332315997564,66466.179432335528,16984.192369442972,{"$error":"#N/A"},11690.564269775379,16657.702826421766,49989.798441444436,199263.79333104438,35350.25396488516]
[4,"Value of commissioned assets, 2024/25",14150.711147161515,43211.493557946123,2963.6864818674044,14722.518947443514,10052.315192213098,5125.7868259029583,8567.1005445935371,1671.9158090065555,8471.990542954245,84444.365243546883,13934.599644582944,{"$error":"#N/A"},15250.2101420237,16597.07093675133,48041.410078531495,197131.64960191568,42077.362820820395,null,{"$f":"[1]Inputs!B49","v":14150.711147161515},{"$f":"[1]Inputs!C49","v":43211.493557946123},{"$f":"[1]Inputs!D49","v":2963.6864818674044},{"$f":"[1]Inputs!E49","v":14722.518947443514},{"$f":"[1]Inputs!F49","v":10052.315192213098},{"$f":"[1]Inputs!G49","v":5125.7868259029583},{"$f":"[1]Inputs!H49","v":8567.1005445935371},{"$f":"[1]Inputs!I49","v":1671.9158090065555},{"$f":"[1]Inputs!J49","v":8471.990542954245},{"$f":"[1]Inputs!K49","v":84444.365243546883},{"$f":"[1]Inputs!L49","v":13934.599644582944},{"$f":"[1]Inputs!M49","v":{"$error":"#N/A"}},{"$f":"[1]Inputs!N49","v":15250.2101420237},{"$f":"[1]Inputs!O49","v":16597.07093675133},{"$f":"[1]Inputs!P49","v":48041.410078531495},{"$f":"[1]Inputs!Q49","v":197131.64960191568},{"$f":"[1]Inputs!R49","v":42077.362820820395},null,11411.983073433752,29245.390473639211,3322.3280463919573,16277.874948008995,9078.4856815167805,4192.0180076945308,8079.8592314729722,1670.1239205886027,4688.7132078676032,78731.040573509556,16670.846030473411,{"$error":"#N/A"},12254.517658387929,17735.53136962737,48856.480201322804,189811.20633239506,38418.879363791479]
[null,"Disposed assets"]
[{"$f":"A64+1","v":5},{"$f":"\"Value of disposed assets, \" & N19","v":"Value of disposed assets, 2018/19"},{"$f":"IF($C$5<$A72,AM72,U72)","v":0},853.06700000000001,38,773.18725158335349,162.02709496968251,125.5172148877932,142.4,0,393,1377.9363699999999,{"$f":"IF($C$5<$A72,AW72,AE72)","v":79.501966691335895},12095.958583283449,346.58528799999999,15.95,1812,7412,0,null,{"$f":"[1]Inputs!B51","v":0},{"$f":"[1]Inputs!C51","v":853.06700000000001},{"$f":"[1]Inputs!D51","v":38},{"$f":"[1]Inputs!E51","v":773.18725158335349},{"$f":"[1]Inputs!F51","v":162.02709496968251},{"$f":"[1]Inputs!G51","v":125.5172148877932},{"$f":"[1]Inputs!H51","v":142.4},{"$f":"[1]Inputs!I51","v":0},{"$f":"[1]Inputs!J51","v":393},{"$f":"[1]Inputs!K51","v":1377.9363699999999},{"$f":"[1]Inputs!L51","v":79.501966691335895},{"$f":"[1]Inputs!M51","v":12095.958583283449},{"$f":"[1]Inputs!N51","v":346.58528799999999},{"$f":"[1]Inputs!O51","v":15.95},{"$f":"[1]Inputs!P51","v":1812},{"$f":"[1]Inputs!Q51","v":7412},{"$f":"[1]Inputs!R51","v":0},null,160.65942223839079,144.78,25.172123082737485,1137.4278628344375,179.06753107618707,119.37721061283666,308.32278946894792,85.734549767298034,577.23778645635252,1770.935018093214,332.91068143402151,11393.893279464264,536.7708383928607,29.824630741003414,2779.7927707656158,11397.608257833417,4.0403300295599989]
[{"$f":"$A$72","v":5},"Value of disposed assets, 2019/20",130.56285494152584,291.1814713869436,28.185792018269709,1081.6181052012112,178.47885662895501,122.54430261356083,279.52838509019517,69.673769697336382,549.03917777641948,1719.4553983460369,286.71673089558186,11719.776367633081,506.71221055210697,27.481768532562345,2627.6108777379654,10769.994983532757,3.2834490266159988,null,{"$f":"[1]Inputs!B52","v":130.56285494152584},{"$f":"[1]Inputs!C52","v":291.1814713869436},{"$f":"[1]Inputs!D52","v":28.185792018269709},{"$f":"[1]Inputs!E52","v":1081.6181052012112},{"$f":"[1]Inputs!F52","v":178.47885662895501},{"$f":"[1]Inputs!G52","v":122.54430261356083},{"$f":"[1]Inputs!H52","v":279.52838509019517},{"$f":"[1]Inputs!I52","v":69.673769697336382},{"$f":"[1]Inputs!J52","v":549.03917777641948},{"$f":"[1]Inputs!K52","v":1719.4553983460369},{"$f":"[1]Inputs!L52","v":286.71673089558186},{"$f":"[1]Inputs!M52","v":11719.776367633081},{"$f":"[1]Inputs!N52","v":506.71221055210697},{"$f":"[1]Inputs!O52","v":27.481768532562345},{"$f":"[1]Inputs!P52","v":2627.6108777379654},{"$f":"[1]Inputs!Q52","v":10769.994983532757},{"$f":"[1]Inputs!R52","v":3.2834490266159988},null,163.39063241644342,147.24125999999998,25.600049175144022,1156.7641365026229,182.11167910448225,121.40662319325489,313.56427688992005,87.192037113342096,587.05082882611055,1801.0409134007984,338.57016301839985,11587.589465215155,545.89594264553932,30.331649463600471,2827.049247868631,11591.367598216586,4.1090156400625188]
[{"$f":"$A$72","v":5},"Value of disposed assets, 2020/21",133.04354918541483,296.71391934329552,28.721322066616835,1102.1688492000342,181.86995490490517,124.87264436321848,284.8394244069089,70.997571321585767,559.47092215417149,1752.1250509146116,292.16434878259787,11942.452118618108,516.33974255259704,28.00392213468103,2677.535484414987,10974.62488821988,3.3458345581217026,null,{"$f":"[1]Inputs!B53","v":133.04354918541483},{"$f":"[1]Inputs!C53","v":296.71391934329552},{"$f":"[1]Inputs!D53","v":28.721322066616835},{"$f":"[1]Inputs!E53","v":1102.1688492000342},{"$f":"[1]Inputs!F53","v":181.86995490490517},{"$f":"[1]Inputs!G53","v":124.87264436321848},{"$f":"[1]Inputs!H53","v":284.8394244069089},{"$f":"[1]Inputs!I53","v":70.997571321585767},{"$f":"[1]Inputs!J53","v":559.47092215417149},{"$f":"[1]Inputs!K53","v":1752.1250509146116},{"$f":"[1]Inputs!L53","v":292.16434878259787},{"$f":"[1]Inputs!M53","v":11942.452118618108},{"$f":"[1]Inputs!N53","v":516.33974255259704},{"$f":"[1]Inputs!O53","v":28.00392213468103},{"$f":"[1]Inputs!P53","v":2677.535484414987},{"$f":"[1]Inputs!Q53","v":10974.62488821988},{"$f":"[1]Inputs!R53","v":3.3458345581217026},null,166.8218356971887,150.33332645999997,26.137650207822041,1181.0561833691777,185.93602436567636,123.95616228031322,320.14912670460831,89.023069892722262,599.37889623145873,1838.862772582215,345.6801364417862,11830.928843984671,557.35975744109555,30.968614102336076,2886.4172820738722,11834.786317779131,4.1953049685038311]
[5,"Value of disposed assets, 2021/22",135.70442016912315,302.64819773016143,29.295748507949174,1124.212226184035,185.50735400300329,127.37009725048287,290.53621289504707,72.41752274801749,570.66034059725496,1787.167551932904,298.00763575824988,12181.301160990472,526.66653740364904,28.564000577374653,2731.0861941032867,11194.117385984278,3.412751249284137,null,{"$f":"[1]Inputs!B54","v":135.70442016912315},{"$f":"[1]Inputs!C54","v":302.64819773016143},{"$f":"[1]Inputs!D54","v":29.295748507949174},{"$f":"[1]Inputs!E54","v":1124.212226184035},{"$f":"[1]Inputs!F54","v":185.50735400300329},{"$f":"[1]Inputs!G54","v":127.37009725048287},{"$f":"[1]Inputs!H54","v":290.53621289504707},{"$f":"[1]Inputs!I54","v":72.41752274801749},{"$f":"[1]Inputs!J54","v":570.66034059725496},{"$f":"[1]Inputs!K54","v":1787.167551932904},{"$f":"[1]Inputs!L54","v":298.00763575824988},{"$f":"[1]Inputs!M54","v":12181.301160990472},{"$f":"[1]Inputs!N54","v":526.66653740364904},{"$f":"[1]Inputs!O54","v":28.564000577374653},{"$f":"[1]Inputs!P54","v":2731.0861941032867},{"$f":"[1]Inputs!Q54","v":11194.117385984278},{"$f":"[1]Inputs!R54","v":3.412751249284137},null,170.32509424682965,153.49032631565996,26.686540862186302,1205.8583632199304,189.84068087735554,126.55924168819978,326.872258365405,90.892554360469418,611.96585305231929,1877.4788908064413,352.93941930706364,12079.378349708348,569.06431234735851,31.61895499848513,2947.0320449974229,12083.316830452492,4.2834063728424114]
[5,"Value of disposed assets, 2022/23",138.41850857250563,308.70116168476471,29.881663478108159,1146.6964707077157,189.21750108306335,129.91749919549252,296.34693715294804,73.865873202977852,582.07354740920016,1822.9109029715623,303.96778847341488,12424.927184210283,537.19986815172206,29.135280588922146,2785.7079179853531,11417.999733703964,3.48100627426982,null,{"$f":"[1]Inputs!B55","v":138.41850857250563},{"$f":"[1]Inputs!C55","v":308.70116168476471},{"$f":"[1]Inputs!D55","v":29.881663478108159},{"$f":"[1]Inputs!E55","v":1146.6964707077157},{"$f":"[1]Inputs!F55","v":189.21750108306335},{"$f":"[1]Inputs!G55","v":129.91749919549252},{"$f":"[1]Inputs!H55","v":296.34693715294804},{"$f":"[1]Inputs!I55","v":73.865873202977852},{"$f":"[1]Inputs!J55","v":582.07354740920016},{"$f":"[1]Inputs!K55","v":1822.9109029715623},{"$f":"[1]Inputs!L55","v":303.96778847341488},{"$f":"[1]Inputs!M55","v":12424.927184210283},{"$f":"[1]Inputs!N55","v":537.19986815172206},{"$f":"[1]Inputs!O55","v":29.135280588922146},{"$f":"[1]Inputs!P55","v":2785.7079179853531},{"$f":"[1]Inputs!Q55","v":11417.999733703964},{"$f":"[1]Inputs!R55","v":3.48100627426982},null,173.84514619459745,156.66245972618358,27.238062706671482,1230.7794360598089,193.76405494882087,129.17479934975589,333.62761837162338,92.77100048391911,624.61314734873383,1916.2801212164409,360.23350063940961,12329.018835602321,580.82497480253721,32.272413401787155,3007.9373739273697,12333.038711615176,4.3719301045478209]
[5,"Value of disposed assets, 2023/24",141.18687874395573,314.87518491845998,30.479296747670322,1169.63040012187,193.00185110472464,132.51584917940238,302.27387589600698,75.343190667037405,593.71501835738411,1859.3691210309935,310.04714424288318,12673.425727894488,547.94386551475645,29.71798620070059,2841.4220763450598,11646.359728378044,3.5506263997552168,null,{"$f":"[1]Inputs!B56","v":141.18687874395573},{"$f":"[1]Inputs!C56","v":314.87518491845998},{"$f":"[1]Inputs!D56","v":30.479296747670322},{"$f":"[1]Inputs!E56","v":1169.63040012187},{"$f":"[1]Inputs!F56","v":193.00185110472464},{"$f":"[1]Inputs!G56","v":132.51584917940238},{"$f":"[1]Inputs!H56","v":302.27387589600698},{"$f":"[1]Inputs!I56","v":75.343190667037405},{"$f":"[1]Inputs!J56","v":593.71501835738411},{"$f":"[1]Inputs!K56","v":1859.3691210309935},{"$f":"[1]Inputs!L56","v":310.04714424288318},{"$f":"[1]Inputs!M56","v":12673.425727894488},{"$f":"[1]Inputs!N56","v":547.94386551475645},{"$f":"[1]Inputs!O56","v":29.71798620070059},{"$f":"[1]Inputs!P56","v":2841.4220763450598},{"$f":"[1]Inputs!Q56","v":11646.359728378044},{"$f":"[1]Inputs!R56","v":3.5506263997552168},null,177.37999750055425,159.84792974061597,27.791903315040468,1255.8052845930249,197.70392406611353,131.80135360320091,340.4113799451797,94.657344160425467,637.31361467815805,1955.2444836811751,367.55824848574423,12579.708885259566,592.63508262352207,32.928619140956819,3069.0987671972257,12583.810498751351,4.460826016673626]
[5,"Value of disposed assets, 2024/25",144.01061631883488,321.17268861682925,31.088882682623733,1193.0230081243076,196.86188812681914,135.16616616299044,308.31935341392716,76.850054480378162,605.58931872453184,1896.5565034516135,316.24808712774086,12926.894242452379,558.90274282505163,30.312345924714606,2898.2505178719616,11879.286922945606,3.6216389277503214,null,{"$f":"[1]Inputs!B57","v":144.01061631883488},{"$f":"[1]Inputs!C57","v":321.17268861682925},{"$f":"[1]Inputs!D57","v":31.088882682623733},{"$f":"[1]Inputs!E57","v":1193.0230081243076},{"$f":"[1]Inputs!F57","v":196.86188812681914},{"$f":"[1]Inputs!G57","v":135.16616616299044},{"$f":"[1]Inputs!H57","v":308.31935341392716},{"$f":"[1]Inputs!I57","v":76.850054480378162},{"$f":"[1]Inputs!J57","v":605.58931872453184},{"$f":"[1]Inputs!K57","v":1896.5565034516135},{"$f":"[1]Inputs!L57","v":316.24808712774086},{"$f":"[1]Inputs!M57","v":12926.894242452379},{"$f":"[1]Inputs!N57","v":558.90274282505163},{"$f":"[1]Inputs!O57","v":30.312345924714606},{"$f":"[1]Inputs!P57","v":2898.2505178719616},{"$f":"[1]Inputs!Q57","v":11879.286922945606},{"$f":"[1]Inputs!R57","v":3.6216389277503214},null,180.92759745056534,163.04488833542828,28.347741381341276,1280.9213902848853,201.65800254743581,134.43738067526493,347.21960754408332,96.550491043633983,650.0598869717212,1994.3493733547987,374.90941345545912,12831.303062964758,604.48778427599257,33.587191523775957,3130.4807425411705,12835.486708726377,4.5500425370070987]
[null,"Other regulated income",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zeroed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zeroed"]
[{"$f":"A48+1","v":7},{"$f":"\"Other regulated income, \" & N19","v":"Other regulated income, 2018/19"},{"$f":"IF($C$5<$A80,AM80,U80)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF($C$5<$A80,AW80,AE80)","v":0},0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"$A$80","v":7},"Other regulated income, 2019/20",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"$A$80","v":7},"Other regulated income, 2020/21",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[7,"Other regulated income, 2021/22",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[7,"Other regulated income, 2022/23",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[7,"Other regulated income, 2023/24",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[7,"Other regulated income, 2024/25",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Allowable notional revenue "]
[null,"Allowable notional revenue 2014/2015",{"$f":"IF($C$5<$A88,AM88,U88)","v":31278.350875339984},57665.065999999999,9928.8727799999997,21449.537,29790.5601384523,13121,21308.973000000002,6884.4949376431496,29374.553,0,{"$f":"IF($C$5<$A88,AW88,AE88)","v":25230},244422,38054,33930,101327.41,395990,104846.16012433299,null,31278.350875339984,57665.065999999999,9928.8727799999997,21449.537,29790.5601384523,13121,21308.973000000002,6884.4949376431496,29374.553,0,25230,244422,38054,33930,101327.41,395990,104846.16012433299,null,31278.350875339984,57665.065999999999,9928.8727799999997,29790.5601384523,21449.537,13121,21308.973000000002,6884.4949376431496,29374.553,0,25230,244422,38054,33930,101327.41,395990,104846.16012433299]
[null,"Pass-through costs 2014/15",302.10500000000002,1137.5830000000001,88,365,358,193,304.7,84,240,0,235,3076,342,5824,1271,11551,2907,null,302.10500000000002,1137.5830000000001,88,365,358,193,304.7,84,240,0,235,3076,342,5824,1271,11551,2907,null,302.10500000000002,1137.5830000000001,88,358,365,193,304.7,84,240,0,235,3076,342,5824,1271,11551,2907]
[null,"Claw-back"]
[1,"Claw-back 2014/15",{"$f":"IF($C$5<$A91,AM91,U91)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF($C$5<$A91,AW91,AE91)","v":0},0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,415.93299999999999,0,1143.73498176,34.377000000000002,762,-661.99699999999996,474.96927743999998,2793,0,1099,6001,0,0,0,-15780,8050.8540104580597]
[1,"Claw-back 2015/16",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,4983.6535757521096,0,627.85006423413813,0,0,0,0,0,0,0,0,0,0,2132.1835219903965,2009.4171474780235,0,0]
[]
[]
[null,"Estimated 2019/20 allowable revenue ex Revenue change model"]
[null,null,"Alpine Energy","Aurora Energy","Centralines","EA Networks","Eastland Network","Electricity Invercargill","Horizon Energy","Nelson Electricity","Network Tasman","Orion NZ","OtagoNet","The Lines Company","Top Energy","Unison Networks","Vector Lines"]
[null,"Estimated 2019/20 allowable revenue",{"$f":"[2]Outputs!B7","v":49719.82702663089},{"$f":"[2]Outputs!C7","v":67031.770067225996},{"$f":"[2]Outputs!D7","v":14465.452982598339},{"$f":"[2]Outputs!E7","v":37120.373212502302},{"$f":"[2]Outputs!F7","v":27873.521952147665},{"$f":"[2]Outputs!G7","v":13951.543341108681},{"$f":"[2]Outputs!H7","v":23616.338568634361},{"$f":"[2]Outputs!I7","v":6803.15723580746},{"$f":"[2]Outputs!J7","v":28269.633421484999},{"$f":"[2]Outputs!K7","v":167132.99807356339},{"$f":"[2]Outputs!L7","v":27205.404248709074},{"$f":"[2]Outputs!M7","v":40848.168135214502},{"$f":"[2]Outputs!N7","v":48585.636766442934},{"$f":"[2]Outputs!O7","v":112883.51224466226},{"$f":"[2]Outputs!P7","v":417635.91704348486}]

{"sheet":"EDB data","index":7,"n_rows":88,"n_cols":8,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
["Inputs for the selected distributor",null,null,null,null,null,null,{"$f":"EDB_Name","v":"Total for selected EDBs"}]
["Data from the Inputs sheet that relates to the selected distributor. The distributor's name is user-selected in cell C4."]
["Distributor",null,"Scenario"]
["Name",null,{"$f":"Waterfall!D3","v":"Total for selected EDBs"}]
["Distributor number",null,{"$f":"Reconciliation!C6","v":{"$error":"#N/A"}}]
["Distributor number (for output data table)",null,{"$f":"HLOOKUP(EDB_Name,Inputs!$C$28:$S$29,2,FALSE)","v":{"$error":"#N/A"}}]
[]
["General data"]
["Non business-specific single inputs","Value"]
[{"$f":"Inputs!B22","v":"Vanilla WACC (67th percentile)"},{"$f":"Inputs!C22","v":4.5699999999999998E-2}]
[{"$f":"Inputs!B23","v":"Cost of debt"},{"$f":"Inputs!C23","v":2.92E-2}]
[{"$f":"Inputs!B24","v":"Leverage"},{"$f":"Inputs!C24","v":0.42}]
[{"$f":"Inputs!B25","v":"Years of remaining life for newly commissioned assets"},{"$f":"Inputs!C25","v":44},"years"]
[{"$f":"Inputs!B26","v":"Industry-wide X factor"},{"$f":"Inputs!C26","v":0}]
[{"$f":"Inputs!B18","v":"Days in a year"},{"$f":"Inputs!C18","v":365},"days"]
[{"$f":"Inputs!B19","v":"Days from mid-year to year-end"},{"$f":"Inputs!C19","v":182},"days"]
[{"$f":"Inputs!B20","v":"Days from revenue date to year-end"},{"$f":"Inputs!C20","v":148},"days"]
[{"$f":"Inputs!B21","v":"Last day of year 1 of the DPP period"},{"$f":"Inputs!C21","v":"2021-03-31"}]
["General time-series data"]
[null,{"$f":"Inputs!D12","v":"2018/19"},{"$f":"Inputs!E12","v":"2019/20"},{"$f":"Inputs!F12","v":"2020/21"},{"$f":"Inputs!G12","v":"2021/22"},{"$f":"Inputs!H12","v":"2022/23"},{"$f":"Inputs!I12","v":"2023/24"},{"$f":"Inputs!J12","v":"2024/25"}]
[{"$f":"Inputs!B13","v":"Year in modelling period"},{"$f":"Inputs!D13","v":1},{"$f":"Inputs!E13","v":2},{"$f":"Inputs!F13","v":3},{"$f":"Inputs!G13","v":4},{"$f":"Inputs!H13","v":5},{"$f":"Inputs!I13","v":6},{"$f":"Inputs!J13","v":7}]
[{"$f":"Inputs!B14","v":"Year in regulatory period"},null,null,{"$f":"Inputs!F14","v":1},{"$f":"Inputs!G14","v":2},{"$f":"Inputs!H14","v":3},{"$f":"Inputs!I14","v":4},{"$f":"Inputs!J14","v":5}]
[{"$f":"Inputs!B15","v":"Forecast changes in CPI used for revaluations"},{"$f":"Inputs!D15","v":1.4836795252225476E-2},{"$f":"Inputs!E15","v":1.6999999999999904E-2},{"$f":"Inputs!F15","v":1.8999999999999906E-2},{"$f":"Inputs!G15","v":2.0000000000000018E-2},{"$f":"Inputs!H15","v":2.0000000000000018E-2},{"$f":"Inputs!I15","v":2.0000000000000018E-2},{"$f":"Inputs!J15","v":2.0000000000000018E-2}]
[{"$f":"Inputs!B16","v":"Forecast changes in the CPI element of the price path"},{"$f":"Inputs!D16","v":0},{"$f":"Inputs!E16","v":0},{"$f":"Inputs!F16","v":1.7504378984726898E-2},{"$f":"Inputs!G16","v":1.9502114592602871E-2},{"$f":"Inputs!H16","v":2.0248058977042183E-2},{"$f":"Inputs!I16","v":2.0000000000000018E-2},{"$f":"Inputs!J16","v":2.0000000000000018E-2}]
[{"$f":"Inputs!B17","v":"Company tax rate"},{"$f":"Inputs!D17","v":0.28000000000000003},{"$f":"Inputs!E17","v":0.28000000000000003},{"$f":"Inputs!F17","v":0.28000000000000003},{"$f":"Inputs!G17","v":0.28000000000000003},{"$f":"Inputs!H17","v":0.28000000000000003},{"$f":"Inputs!I17","v":0.28000000000000003},{"$f":"Inputs!J17","v":0.28000000000000003}]
["Business-specific data"]
["Initial conditions"]
[{"$f":"Inputs!B31","v":"Opening RAB"},{"$f":"INDEX(Indiv_Data,MATCH(A28,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B32","v":"Lost assets"},{"$f":"INDEX(Indiv_Data,MATCH(A29,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B33","v":"Found assets"},{"$f":"INDEX(Indiv_Data,MATCH(A30,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B34","v":"Total depreciation"},{"$f":"INDEX(Indiv_Data,MATCH(A31,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B35","v":"Revaluations"},{"$f":"INDEX(Indiv_Data,MATCH(A32,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B36","v":"Closing RAB"},{"$f":"INDEX(Indiv_Data,MATCH(A33,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B37","v":"Opening RAB excluding revaluations"},{"$f":"INDEX(Indiv_Data,MATCH(A34,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B38","v":"Adjusted depreciation"},{"$f":"INDEX(Indiv_Data,MATCH(A35,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B39","v":"Tax depreciation"},{"$f":"INDEX(Indiv_Data,MATCH(A36,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B40","v":"Opening regulatory tax asset value"},{"$f":"INDEX(Indiv_Data,MATCH(A37,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B41","v":"Amortisation of initial differences in asset values"},{"$f":"INDEX(Indiv_Data,MATCH(A38,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B42","v":"Term credit spread differential allowance"},{"$f":"INDEX(Indiv_Data,MATCH(A39,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B43","v":"Opening deferred tax balance"},{"$f":"INDEX(Indiv_Data,MATCH(A40,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B44","v":"Adjustment factor (for accelerated depreciation)"},{"$f":"INDEX(Indiv_Data,MATCH(A41,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B45","v":"Additional allowance in 1 April 2015 PV terms"},{"$f":"INDEX(Indiv_Data,MATCH(A42,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B46","v":"Alternative X factor"},{"$f":"IF(ISNUMBER(INDEX(Indiv_Data,MATCH(A43,Inputs!B:B,0),$C$5)),INDEX(Indiv_Data,MATCH(A43,Inputs!B:B,0),$C$5),\"\")","v":""}]
[]
["Operating expenditure"]
[{"$f":"Inputs!B48","v":"Operating expenditure, 2018/19"},{"$f":"INDEX(Indiv_Data,MATCH(A46,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B49","v":"Operating expenditure, 2019/20"},{"$f":"INDEX(Indiv_Data,MATCH(A47,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B50","v":"Operating expenditure, 2020/21"},{"$f":"INDEX(Indiv_Data,MATCH(A48,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B51","v":"Operating expenditure, 2021/22"},{"$f":"INDEX(Indiv_Data,MATCH(A49,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B52","v":"Operating expenditure, 2022/23"},{"$f":"INDEX(Indiv_Data,MATCH(A50,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B53","v":"Operating expenditure, 2023/24"},{"$f":"INDEX(Indiv_Data,MATCH(A51,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B54","v":"Operating expenditure, 2024/25"},{"$f":"INDEX(Indiv_Data,MATCH(A52,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[]
["Constant price revenue growth"]
[{"$f":"Inputs!B56","v":"Constant price revenue growth, 2018/19"},{"$f":"INDEX(Indiv_Data,MATCH(A55,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B57","v":"Constant price revenue growth, 2019/20"},{"$f":"INDEX(Indiv_Data,MATCH(A56,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B58","v":"Constant price revenue growth, 2020/21"},{"$f":"INDEX(Indiv_Data,MATCH(A57,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B59","v":"Constant price revenue growth, 2021/22"},{"$f":"INDEX(Indiv_Data,MATCH(A58,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B60","v":"Constant price revenue growth, 2022/23"},{"$f":"INDEX(Indiv_Data,MATCH(A59,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B61","v":"Constant price revenue growth, 2023/24"},{"$f":"INDEX(Indiv_Data,MATCH(A60,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B62","v":"Constant price revenue growth, 2024/25"},{"$f":"INDEX(Indiv_Data,MATCH(A61,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[]
["Value of commissioned assets"]
[{"$f":"Inputs!B64","v":"Value of commissioned assets, 2018/19"},{"$f":"INDEX(Indiv_Data,MATCH(A64,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B65","v":"Value of commissioned assets, 2019/20"},{"$f":"INDEX(Indiv_Data,MATCH(A65,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B66","v":"Value of commissioned assets, 2020/21"},{"$f":"INDEX(Indiv_Data,MATCH(A66,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B67","v":"Value of commissioned assets, 2021/22"},{"$f":"INDEX(Indiv_Data,MATCH(A67,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B68","v":"Value of commissioned assets, 2022/23"},{"$f":"INDEX(Indiv_Data,MATCH(A68,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B69","v":"Value of commissioned assets, 2023/24"},{"$f":"INDEX(Indiv_Data,MATCH(A69,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B70","v":"Value of commissioned assets, 2024/25"},{"$f":"INDEX(Indiv_Data,MATCH(A70,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[]
["Disposed assets"]
[{"$f":"Inputs!B72","v":"Value of disposed assets, 2018/19"},{"$f":"INDEX(Indiv_Data,MATCH(A73,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B73","v":"Value of disposed assets, 2019/20"},{"$f":"INDEX(Indiv_Data,MATCH(A74,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B74","v":"Value of disposed assets, 2020/21"},{"$f":"INDEX(Indiv_Data,MATCH(A75,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B75","v":"Value of disposed assets, 2021/22"},{"$f":"INDEX(Indiv_Data,MATCH(A76,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B76","v":"Value of disposed assets, 2022/23"},{"$f":"INDEX(Indiv_Data,MATCH(A77,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B77","v":"Value of disposed assets, 2023/24"},{"$f":"INDEX(Indiv_Data,MATCH(A78,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B78","v":"Value of disposed assets, 2024/25"},{"$f":"INDEX(Indiv_Data,MATCH(A79,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[]
["Other regulated income"]
[{"$f":"Inputs!B80","v":"Other regulated income, 2018/19"},{"$f":"INDEX(Indiv_Data,MATCH(A82,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B81","v":"Other regulated income, 2019/20"},{"$f":"INDEX(Indiv_Data,MATCH(A83,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B82","v":"Other regulated income, 2020/21"},{"$f":"INDEX(Indiv_Data,MATCH(A84,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B83","v":"Other regulated income, 2021/22"},{"$f":"INDEX(Indiv_Data,MATCH(A85,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B84","v":"Other regulated income, 2022/23"},{"$f":"INDEX(Indiv_Data,MATCH(A86,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B85","v":"Other regulated income, 2023/24"},{"$f":"INDEX(Indiv_Data,MATCH(A87,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]
[{"$f":"Inputs!B86","v":"Other regulated income, 2024/25"},{"$f":"INDEX(Indiv_Data,MATCH(A88,Inputs!B:B,0),$C$5)","v":{"$error":"#N/A"}}]

{"sheet":"TIMING","index":8,"n_rows":43,"n_cols":15,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Intra-year timing"]
["Derivation of the five timing factors TFopex, TFtax, TFVCA, TFori and TFrev."]
["Inputs"]
[null,"From","Value"]
["Last day of year 1 of the DPP period","EDB data",{"$f":"'EDB data'!B18","v":"2021-03-31"}]
["Days in a year","EDB data",{"$f":"'EDB data'!B15","v":365}]
["Days from mid-year to year-end","EDB data",{"$f":"'EDB data'!B16","v":182}]
["Days from revenue date to year-end","EDB data",{"$f":"'EDB data'!B17","v":148}]
["Vanilla WACC (67th percentile)","EDB data",{"$f":"WACC","v":4.5699999999999998E-2}]
["Calculations"]
[null,null,"Value"]
["Mid-year date",null,{"$f":"EOMONTH(C5,-6)","v":"2020-09-30"}]
["Revenue date",null,{"$f":"C5-C8","v":"2020-11-03"},"As demonstrated below, 12 equal monthly transactions on the 20th of the following month can be approximated by a single payment on the revenue date."]
["Operating expenditure date",null,{"$f":"C12","v":"2020-09-30"},"i.e. mid-year"]
["Tax date",null,{"$f":"C12","v":"2020-09-30"},"i.e. mid-year"]
["Asset commissioning date",null,{"$f":"C12","v":"2020-09-30"},"i.e. mid-year"]
["Interest date",null,{"$f":"C12","v":"2020-09-30"},"i.e. mid-year"]
["Asset disposal date",null,{"$f":"C12","v":"2020-09-30"},"i.e. mid-year"]
["TF for mid-year cash flows",null,{"$f":"(1+$C$9)^(C7/C6)","v":1.0225321432719434},"Intra-year timing factors: discount from mid year to end of year values"]
["TFrev",null,{"$f":"(1+$C$9)^(C8/C6)","v":1.0182846181695255},"Intra-year timing factor: discount from revenue date to end of year values"]
["Outputs"]
[null,null,"Value"]
["TFopex",null,{"$f":"$C$19","v":1.0225321432719434}]
["TFtax",null,{"$f":"$C$19","v":1.0225321432719434}]
["TFVCA",null,1.0225321432719434]
["TFori",null,1.0225321432719434]
["TFrev",null,{"$f":"$C$20","v":1.0182846181695255}]
["Check for timing of revenue receipt"]
["Demonstration that a 4 November receipt date for all revenues in a year ending 31 March is almost identical to"]
["receiving 12 equal revenue amounts on the 20th of the month following the provision of service."]
["Monthly cash flows"]
["Dates of receipt of revenues",null,{"$f":"EDATE(C5,-12)","v":"2020-03-31"},{"$f":"EOMONTH(C32,1)+20","v":"2020-05-20"},{"$f":"EDATE(D32,1)","v":"2020-06-20"},{"$f":"EDATE(E32,1)","v":"2020-07-20"},"2020-08-20","2020-09-20","2020-10-20","2020-11-20","2020-12-20","2021-01-20","2021-02-20",{"$f":"EDATE(M32,1)","v":"2021-03-20"},{"$f":"EDATE(N32,1)","v":"2021-04-20"}]
["Indexed amount of revenue",null,0,1,1,1,1,1,1,1,1,1,1,1,1]
[]
["Equivalent single cash flow"]
["Dates of receipt of revenues",null,{"$f":"C32","v":"2020-03-31"},{"$f":"C13","v":"2020-11-03"}]
["Indexed amount of revenue",null,0,12]
[]
["Present value",null,"Value"]
[{"$f":"\"PV as at \"&TEXT(C5,\"dd mmm yy\")&\" of the series of unit amounts\"","v":"PV as at 31 Mar 21 of the series of unit amounts"},null,{"$f":"XNPV(WACC,C33:O33,C32:O32)","v":11.68469323458495}]
["PV of the equivalent single amount",null,{"$f":"XNPV(WACC,C37:D37,C36:D36)","v":11.685392959772692}]
[{"$f":"\"Difference in PV for a date of \" & TEXT(D36,\"d mmm\")","v":"Difference in PV for a date of 3 Nov"},null,{"$f":"C40-C41","v":-6.9972518774186199E-4}]
["Percentage difference",null,{"$f":"C42/C40","v":-5.9883915965442697E-5}]

{"sheet":"RAB","index":9,"n_rows":95,"n_cols":10,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
["Regulatory asset base",null,null,null,null,null,null,null,null,{"$f":"EDB_Name","v":"Total for selected EDBs"}]
["Calculations involving the roll-forward of asset values."]
["Inputs"]
[null,"From","Value",{"$f":"Inputs!D$12","v":"2018/19"},{"$f":"Inputs!E$12","v":"2019/20"},{"$f":"Inputs!F$12","v":"2020/21"},{"$f":"Inputs!G$12","v":"2021/22"},{"$f":"Inputs!H$12","v":"2022/23"},{"$f":"Inputs!I$12","v":"2023/24"},{"$f":"Inputs!J$12","v":"2024/25"}]
["Opening RAB","EDB data",{"$f":"'EDB data'!B28","v":{"$error":"#N/A"}}]
["Total depreciation","EDB data",{"$f":"'EDB data'!B31","v":{"$error":"#N/A"}}]
["Revaluations","EDB data",{"$f":"'EDB data'!B32","v":{"$error":"#N/A"}}]
["Closing RAB","EDB data",{"$f":"'EDB data'!B33","v":{"$error":"#N/A"}}]
["Disposed assets","EDB data",null,{"$f":"'EDB data'!$B73","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B74","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B75","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B76","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B77","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B78","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B79","v":{"$error":"#N/A"}}]
["Value of commissioned assets","EDB data",null,{"$f":"'EDB data'!$B64","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B65","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B66","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B67","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B68","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B69","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B70","v":{"$error":"#N/A"}}]
["Remaining life of newly commissioned assets","EDB data",{"$f":"'EDB data'!B13","v":44}]
["Forecast changes in CPI used for revaluations","EDB data",null,{"$f":"'EDB data'!B23","v":1.4836795252225476E-2},{"$f":"'EDB data'!C23","v":1.6999999999999904E-2},{"$f":"'EDB data'!D23","v":1.8999999999999906E-2},{"$f":"'EDB data'!E23","v":2.0000000000000018E-2},{"$f":"'EDB data'!F23","v":2.0000000000000018E-2},{"$f":"'EDB data'!G23","v":2.0000000000000018E-2},{"$f":"'EDB data'!H23","v":2.0000000000000018E-2}]
["Adjustment factor (for accelerated depreciation)","EDB data",{"$f":"'EDB data'!B41","v":{"$error":"#N/A"}}]
["Calculations"]
[]
["Roll forward of existing assets"]
[null,null,null,{"$f":"Inputs!D$12","v":"2018/19"},{"$f":"Inputs!E$12","v":"2019/20"},{"$f":"Inputs!F$12","v":"2020/21"},{"$f":"Inputs!G$12","v":"2021/22"},{"$f":"Inputs!H$12","v":"2022/23"},{"$f":"Inputs!I$12","v":"2023/24"},{"$f":"Inputs!J$12","v":"2024/25"}]
["Remaining asset life of existing assets",null,null,null,{"$f":"100%*C5/C6-1","v":{"$error":"#N/A"}},{"$f":"C13*C5/C6-2","v":{"$error":"#N/A"}},{"$f":"F18-1","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Opening RAB value of existing assets",null,null,null,{"$f":"D23","v":{"$error":"#N/A"}},{"$f":"E23","v":{"$error":"#N/A"}},{"$f":"F23","v":{"$error":"#N/A"}},{"$f":"G23","v":{"$error":"#N/A"}},{"$f":"H23","v":{"$error":"#N/A"}},{"$f":"I23","v":{"$error":"#N/A"}}]
["Disposed assets",null,null,null,{"$f":"E9","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Revaluation of existing assets",null,null,null,{"$f":"(E19*0.999-E20)*E28","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Depreciation of existing assets",null,null,null,{"$f":"E19/E18","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Closing RAB value of existing assets",null,null,{"$f":"C8","v":{"$error":"#N/A"}},{"$f":"E19-E20+E21-E22","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
["Individual roll forward of additional assets"]
[null,null,null,{"$f":"Inputs!D$12","v":"2018/19"},{"$f":"Inputs!E$12","v":"2019/20"},{"$f":"Inputs!F$12","v":"2020/21"},{"$f":"Inputs!G$12","v":"2021/22"},{"$f":"Inputs!H$12","v":"2022/23"},{"$f":"Inputs!I$12","v":"2023/24"},{"$f":"Inputs!J$12","v":"2024/25"}]
["Year in modelling period",null,null,1,{"$f":"D27+1","v":2},{"$f":"E27+1","v":3},4,5,{"$f":"H27+1","v":6},{"$f":"I27+1","v":7}]
["Revaluation rate",null,null,{"$f":"D12","v":1.4836795252225476E-2},1.6999999999999904E-2,1.8999999999999906E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2]
["Commissioned assets",null,null,{"$f":"D$10","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[" Assets commissioned in 2014/15:"]
["Year asset is added during modelling period",null,{"$f":"E27","v":2}]
["Opening RAB",null,null,0,{"$f":"D36","v":0},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Years of remaining life",null,null,{"$f":"$C$11+$C31","v":46},{"$f":"D33-1","v":45},{"$f":"E33-1","v":44},43,{"$f":"G33-1","v":42},{"$f":"H33-1","v":41},{"$f":"I33-1","v":40}]
["Revaluation of assets",null,null,{"$f":"D32*D$28","v":0},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Depreciation of assets",null,null,{"$f":"D32/D33","v":0},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Closing RAB",null,null,{"$f":"D32+D34-D35+IF($C31=D$27,D$29,0)","v":0},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[" Assets commissioned in 2015/16:"]
["Year asset is added during modelling period",null,{"$f":"F27","v":3}]
["Opening RAB",null,null,0,{"$f":"D43","v":0},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Years of remaining life",null,null,{"$f":"$C$11+$C38","v":47},{"$f":"D40-1","v":46},45,44,43,42,41]
["Revaluation of assets",null,null,{"$f":"D39*D$28","v":0},0,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Depreciation of assets",null,null,{"$f":"D39/D40","v":0},0,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Closing RAB",null,null,{"$f":"D39+D41-D42+IF($C38=D$27,D$29,0)","v":0},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[" Assets commissioned in 2016/17:"]
["Year asset is added during modelling period",null,{"$f":"G27","v":4}]
["Opening RAB",null,null,0,{"$f":"D50","v":0},0,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Years of remaining life",null,null,{"$f":"$C$11+$C45","v":48},{"$f":"D47-1","v":47},46,45,44,43,42]
["Revaluation of assets",null,null,{"$f":"D46*D$28","v":0},0,0,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Depreciation of assets",null,null,{"$f":"D46/D47","v":0},0,0,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Closing RAB",null,null,{"$f":"D46+D48-D49+IF($C45=D$27,D$29,0)","v":0},0,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[" Assets commissioned in 2017/18:"]
["Year asset is added during modelling period",null,{"$f":"H27","v":5}]
["Opening RAB",null,null,0,{"$f":"D57","v":0},0,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
["Years of remaining life",null,null,{"$f":"$C$11+$C52","v":49},{"$f":"D54-1","v":48},47,46,45,44,43]
["Revaluation of assets",null,null,{"$f":"D53*D$28","v":0},0,0,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
["Depreciation of assets",null,null,{"$f":"D53/D54","v":0},0,0,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
["Closing RAB",null,null,{"$f":"D53+D55-D56+IF($C52=D$27,D$29,0)","v":0},0,0,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[" Assets commissioned in 2018/19:"]
["Year asset is added during modelling period",null,{"$f":"I27","v":6}]
["Opening RAB",null,null,0,{"$f":"D64","v":0},0,0,0,0,{"$error":"#N/A"}]
["Years of remaining life",null,null,{"$f":"$C$11+$C59","v":50},{"$f":"D61-1","v":49},48,47,46,45,44]
["Revaluation of assets",null,null,{"$f":"D60*D$28","v":0},0,0,0,0,0,{"$error":"#N/A"}]
["Depreciation of assets",null,null,{"$f":"D60/D61","v":0},0,0,0,0,0,{"$error":"#N/A"}]
["Closing RAB",null,null,{"$f":"D60+D62-D63+IF($C59=D$27,D$29,0)","v":0},0,0,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[" Assets commissioned in 2019/20:"]
["Year asset is added during modelling period",null,{"$f":"J27","v":7}]
["Opening RAB",null,null,0,{"$f":"D71","v":0},0,0,0,0,0]
["Years of remaining life",null,null,{"$f":"$C$11+$C66","v":51},{"$f":"D68-1","v":50},{"$f":"E68-1","v":49},48,{"$f":"G68-1","v":47},{"$f":"H68-1","v":46},{"$f":"I68-1","v":45}]
["Revaluation of assets",null,null,{"$f":"D67*D$28","v":0},0,0,0,0,0,0]
["Depreciation of assets",null,null,{"$f":"D67/D68","v":0},0,0,0,0,0,0]
["Closing RAB",null,null,{"$f":"D67+D69-D70+IF($C66=D$27,D$29,0)","v":0},0,0,0,0,0,{"$error":"#N/A"}]
[]
["Aggregate roll forward of additional assets"]
[]
["Opening RAB of commissioned additional assets",null,null,{"$f":"D32+D39+D46+D53+D60+D67","v":0},0,{"$f":"F32+F39+F46+F53+F60+F67","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Revaluation of commissioned additional assets",null,null,{"$f":"D34+D41+D48+D55+D62+D69","v":0},0,{"$f":"F34+F41+F48+F55+F62+F69","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Depreciation of commissioned additional assets",null,null,0,0,{"$f":"F35+F42+F49+F56+F63+F70","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Closing RAB of commissioned additional assets",null,null,0,{"$error":"#N/A"},{"$f":"F36+F43+F50+F57+F64+F71","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
["Combined roll forward of existing and additional assets"]
[]
[null,null,null,{"$f":"Inputs!D$12","v":"2018/19"},{"$f":"Inputs!E$12","v":"2019/20"},{"$f":"Inputs!F$12","v":"2020/21"},{"$f":"Inputs!G$12","v":"2021/22"},{"$f":"Inputs!H$12","v":"2022/23"},{"$f":"Inputs!I$12","v":"2023/24"},{"$f":"Inputs!J$12","v":"2024/25"}]
["Aggregate opening RAB value",null,null,{"$f":"C5","v":{"$error":"#N/A"}},{"$f":"E19+E75","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Total revaluation",null,null,{"$f":"C7","v":{"$error":"#N/A"}},{"$f":"E21+E76","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Total depreciation",null,null,{"$f":"C6","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Aggregate closing RAB value",null,null,{"$f":"D23+D78","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Check that closing value is as expected. Should = 0",null,null,null,{"$f":"E83+E29+E84-E85-E20-E86","v":{"$error":"#N/A"}},{"$f":"F83+F29+F84-F85-F20-F86","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Outputs"]
[]
[null,null,null,{"$f":"Inputs!D$12","v":"2018/19"},{"$f":"Inputs!E$12","v":"2019/20"},{"$f":"Inputs!F$12","v":"2020/21"},{"$f":"Inputs!G$12","v":"2021/22"},{"$f":"Inputs!H$12","v":"2022/23"},{"$f":"Inputs!I$12","v":"2023/24"},{"$f":"Inputs!J$12","v":"2024/25"}]
["Remaining asset life of existing assets",null,null,null,{"$f":"E18","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Total depreciation",null,null,{"$f":"D85","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Aggregate opening RAB value",null,null,{"$f":"D83","v":{"$error":"#N/A"}},{"$f":"E83","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Total revaluation",null,null,{"$f":"D84","v":{"$error":"#N/A"}},{"$f":"E84","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Aggregate closing RAB value",null,null,{"$f":"D86","v":{"$error":"#N/A"}},{"$f":"E86","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"TAX","index":10,"n_rows":98,"n_cols":10,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
["Tax calculations",null,null,null,null,null,null,null,null,{"$f":"EDB_Name","v":"Total for selected EDBs"}]
["Calculations involving the roll-forward of adjusted depreciation regulatory asset values, deferred tax and tax adjustments."]
["Inputs"]
[null,"Source","Value",{"$f":"Inputs!D$12","v":"2018/19"},{"$f":"Inputs!E$12","v":"2019/20"},{"$f":"Inputs!F$12","v":"2020/21"},{"$f":"Inputs!G$12","v":"2021/22"},{"$f":"Inputs!H$12","v":"2022/23"},{"$f":"Inputs!I$12","v":"2023/24"},{"$f":"Inputs!J$12","v":"2024/25"}]
["Year in modelling period","EDB data",null,{"$f":"'EDB data'!B21","v":1},{"$f":"'EDB data'!C21","v":2},{"$f":"'EDB data'!D21","v":3},{"$f":"'EDB data'!E21","v":4},{"$f":"'EDB data'!F21","v":5},{"$f":"'EDB data'!G21","v":6},{"$f":"'EDB data'!H21","v":7}]
["Tax rate","EDB data",null,{"$f":"'EDB data'!B25","v":0.28000000000000003},{"$f":"'EDB data'!C25","v":0.28000000000000003},{"$f":"'EDB data'!D25","v":0.28000000000000003},{"$f":"'EDB data'!E25","v":0.28000000000000003},{"$f":"'EDB data'!F25","v":0.28000000000000003},{"$f":"'EDB data'!G25","v":0.28000000000000003},{"$f":"'EDB data'!H25","v":0.28000000000000003}]
["Value of commissioned assets","EDB data",null,{"$f":"'EDB data'!$B64","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B65","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B66","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B67","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B68","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B69","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B70","v":{"$error":"#N/A"}}]
["Remaining life of newly commissioned assets","EDB data",null,{"$f":"'EDB data'!B13","v":44}]
["Amortisation of initial differences in asset values","EDB data",null,{"$f":"'EDB data'!B38","v":{"$error":"#N/A"}}]
["Lost assets","EDB data",null,{"$f":"'EDB data'!B29","v":{"$error":"#N/A"}}]
["Found assets","EDB data",null,{"$f":"'EDB data'!B30","v":{"$error":"#N/A"}}]
["Disposed assets","EDB data",null,{"$f":"'EDB data'!$B73","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B74","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B75","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B76","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B77","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B78","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B79","v":{"$error":"#N/A"}}]
["Opening RAB excluding revaluations","EDB data",null,{"$f":"'EDB data'!B34","v":{"$error":"#N/A"}}]
["Adjusted depreciation","EDB data",null,{"$f":"'EDB data'!B35","v":{"$error":"#N/A"}}]
["Tax depreciation","EDB data",null,{"$f":"'EDB data'!B36","v":{"$error":"#N/A"}}]
["Opening regulatory tax asset value","EDB data",null,{"$f":"'EDB data'!B37","v":{"$error":"#N/A"}}]
["Opening deferred tax balance","EDB data",null,{"$f":"'EDB data'!B40","v":{"$error":"#N/A"}}]
["Cost of debt","EDB data",null,{"$f":"'EDB data'!B11","v":2.92E-2}]
["Leverage","EDB data",null,{"$f":"'EDB data'!B12","v":0.42}]
["Remaining asset life of existing assets","RAB",null,null,{"$f":"RAB!E91","v":{"$error":"#N/A"}},{"$f":"RAB!F91","v":{"$error":"#N/A"}},{"$f":"RAB!G91","v":{"$error":"#N/A"}},{"$f":"RAB!H91","v":{"$error":"#N/A"}},{"$f":"RAB!I91","v":{"$error":"#N/A"}},{"$f":"RAB!J91","v":{"$error":"#N/A"}}]
["Total depreciation","RAB",null,{"$f":"RAB!D92","v":{"$error":"#N/A"}},{"$f":"RAB!E92","v":{"$error":"#N/A"}},{"$f":"RAB!F92","v":{"$error":"#N/A"}},{"$f":"RAB!G92","v":{"$error":"#N/A"}},{"$f":"RAB!H92","v":{"$error":"#N/A"}},{"$f":"RAB!I92","v":{"$error":"#N/A"}},{"$f":"RAB!J92","v":{"$error":"#N/A"}}]
["Term credit spread differential allowance","BBAR",null,{"$f":"BBAR!D58","v":{"$error":"#N/A"}},{"$f":"BBAR!E58","v":{"$error":"#N/A"}},{"$f":"BBAR!F58","v":{"$error":"#N/A"}},{"$f":"BBAR!G58","v":{"$error":"#N/A"}},{"$f":"BBAR!H58","v":{"$error":"#N/A"}},{"$f":"BBAR!I58","v":{"$error":"#N/A"}},{"$f":"BBAR!J58","v":{"$error":"#N/A"}}]
["Opening investment value","BBAR",null,{"$f":"BBAR!D56","v":{"$error":"#N/A"}},{"$f":"BBAR!E56","v":{"$error":"#N/A"}},{"$f":"BBAR!F56","v":{"$error":"#N/A"}},{"$f":"BBAR!G56","v":{"$error":"#N/A"}},{"$f":"BBAR!H56","v":{"$error":"#N/A"}},{"$f":"BBAR!I56","v":{"$error":"#N/A"}},{"$f":"BBAR!J56","v":{"$error":"#N/A"}}]
["Calculations"]
["Adjusted RAB & depreciation of assets commissioned"]
[null,null,"Value",{"$f":"Inputs!D$12","v":"2018/19"},{"$f":"Inputs!E$12","v":"2019/20"},{"$f":"Inputs!F$12","v":"2020/21"},{"$f":"Inputs!G$12","v":"2021/22"},{"$f":"Inputs!H$12","v":"2022/23"},{"$f":"Inputs!I$12","v":"2023/24"},{"$f":"Inputs!J$12","v":"2024/25"}]
["Commissioned assets",null,null,{"$f":"D7","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[" Assets commissioned in 2014/15:",null,{"$f":"E5","v":2}]
["Opening RAB, adjusted depreciation",null,null,0,{"$f":"D32","v":0},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Years of remaining life",null,null,{"$f":"$D$8+$C28","v":46},{"$f":"D30-1","v":45},44,43,42,41,40]
["Adjusted depreciation",null,null,{"$f":"D29/D30","v":0},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Closing RAB, adjusted depreciation",null,null,{"$f":"D29-D31+IF($C28=D$5,D$27,0)","v":0},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[" Assets commissioned in 2015/16:",null,{"$f":"F5","v":3}]
["Opening RAB, adjusted depreciation",null,null,0,{"$f":"D37","v":0},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Years of remaining life",null,null,{"$f":"$D$8+$C33","v":47},{"$f":"D35-1","v":46},45,44,43,42,41]
["Adjusted depreciation",null,null,{"$f":"D34/D35","v":0},0,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Closing RAB, adjusted depreciation",null,null,{"$f":"D34-D36+IF($C33=D$5,D$27,0)","v":0},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[" Assets commissioned in 2016/17:",null,{"$f":"G5","v":4}]
["Opening RAB, adjusted depreciation",null,null,0,{"$f":"D42","v":0},0,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Years of remaining life",null,null,{"$f":"$D$8+$C38","v":48},{"$f":"D40-1","v":47},46,45,44,43,42]
["Adjusted depreciation",null,null,{"$f":"D39/D40","v":0},0,0,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Closing RAB, adjusted depreciation",null,null,{"$f":"D39-D41+IF($C38=D$5,D$27,0)","v":0},0,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[" Assets commissioned in 2017/18:",null,{"$f":"H5","v":5}]
["Opening RAB, adjusted depreciation",null,null,0,{"$f":"D47","v":0},0,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
["Years of remaining life",null,null,{"$f":"$D$8+$C43","v":49},{"$f":"D45-1","v":48},47,46,45,44,43]
["Adjusted depreciation",null,null,{"$f":"D44/D45","v":0},0,0,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
["Closing RAB, adjusted depreciation",null,null,{"$f":"D44-D46+IF($C43=D$5,D$27,0)","v":0},0,0,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[" Assets commissioned in 2018/19:",null,{"$f":"I5","v":6}]
["Opening RAB, adjusted depreciation",null,null,0,{"$f":"D52","v":0},0,0,0,0,{"$error":"#N/A"}]
["Years of remaining life",null,null,{"$f":"$D$8+$C48","v":50},{"$f":"D50-1","v":49},48,47,46,45,44]
["Adjusted depreciation",null,null,{"$f":"D49/D50","v":0},0,0,0,0,0,{"$error":"#N/A"}]
["Closing RAB, adjusted depreciation",null,null,{"$f":"D49-D51+IF($C48=D$5,D$27,0)","v":0},0,0,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[" Assets commissioned in 2019/20:",null,{"$f":"J5","v":7}]
["Opening RAB, adjusted depreciation",null,null,0,{"$f":"D57","v":0},{"$f":"E57","v":0},0,{"$f":"G57","v":0},{"$f":"H57","v":0},{"$f":"I57","v":0}]
["Years of remaining life",null,null,{"$f":"$D$8+$C53","v":51},{"$f":"D55-1","v":50},{"$f":"E55-1","v":49},48,{"$f":"G55-1","v":47},{"$f":"H55-1","v":46},{"$f":"I55-1","v":45}]
["Adjusted depreciation",null,null,{"$f":"D54/D55","v":0},0,0,0,0,0,0]
["Closing RAB, adjusted depreciation",null,null,{"$f":"D54-D56+IF($C53=D$5,D$27,0)","v":0},0,0,0,0,0,{"$error":"#N/A"}]
["Total assets commissioned"]
["Total adjusted depreciation of commissioned assets",null,null,{"$f":"D31+D36+D41+D46+D51+D56","v":0},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Adjusted depreciation of existing assets"]
[null,null,"Value",{"$f":"Inputs!D$12","v":"2018/19"},{"$f":"Inputs!E$12","v":"2019/20"},{"$f":"Inputs!F$12","v":"2020/21"},{"$f":"Inputs!G$12","v":"2021/22"},{"$f":"Inputs!H$12","v":"2022/23"},{"$f":"Inputs!I$12","v":"2023/24"},{"$f":"Inputs!J$12","v":"2024/25"}]
["Opening RAB value of existing assets, adjusted depreciation",null,null,{"$f":"D13","v":{"$error":"#N/A"}},{"$f":"D68","v":{"$error":"#N/A"}},{"$f":"E68","v":{"$error":"#N/A"}},{"$f":"F68","v":{"$error":"#N/A"}},{"$f":"G68","v":{"$error":"#N/A"}},{"$f":"H68","v":{"$error":"#N/A"}},{"$f":"I68","v":{"$error":"#N/A"}}]
["Disposed assets",null,null,{"$f":"D12","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Base year lost assets",null,null,{"$f":"D10","v":{"$error":"#N/A"}}]
["Base year found assets",null,null,{"$f":"D11","v":{"$error":"#N/A"}}]
["Adjusted depreciation of existing assets",null,null,{"$f":"D14","v":{"$error":"#N/A"}},{"$f":"E62/E20","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Base year commissioned assets",null,null,{"$f":"D7","v":{"$error":"#N/A"}}]
["Closing RAB value of existing assets, adjusted depreciation",null,null,{"$f":"D62-D63-D64+D65-D66+D67","v":{"$error":"#N/A"}},{"$f":"E62-E63-E66","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"G62-G63-G66","v":{"$error":"#N/A"}},{"$f":"H62-H63-H66","v":{"$error":"#N/A"}},{"$f":"I62-I63-I66","v":{"$error":"#N/A"}},{"$f":"J62-J63-J66","v":{"$error":"#N/A"}}]
["Regulatory tax asset value"]
[null,null,"Value",{"$f":"Inputs!D$12","v":"2018/19"},{"$f":"Inputs!E$12","v":"2019/20"},{"$f":"Inputs!F$12","v":"2020/21"},{"$f":"Inputs!G$12","v":"2021/22"},{"$f":"Inputs!H$12","v":"2022/23"},{"$f":"Inputs!I$12","v":"2023/24"},{"$f":"Inputs!J$12","v":"2024/25"}]
["Average DV rate",null,{"$f":"D15/D16","v":{"$error":"#N/A"}}]
["Opening regulatory tax asset value",null,null,{"$f":"D16","v":{"$error":"#N/A"}},{"$f":"D75","v":{"$error":"#N/A"}},{"$f":"E75","v":{"$error":"#N/A"}},{"$f":"F75","v":{"$error":"#N/A"}},{"$f":"G75","v":{"$error":"#N/A"}},{"$f":"H75","v":{"$error":"#N/A"}},{"$f":"I75","v":{"$error":"#N/A"}}]
["Tax depreciation",null,null,{"$f":"D15","v":{"$error":"#N/A"}},{"$f":"E72*$C71","v":{"$error":"#N/A"}},{"$f":"F72*$C71","v":{"$error":"#N/A"}},{"$f":"G72*$C71","v":{"$error":"#N/A"}},{"$f":"H72*$C71","v":{"$error":"#N/A"}},{"$f":"I72*$C71","v":{"$error":"#N/A"}},{"$f":"J72*$C71","v":{"$error":"#N/A"}}]
["Value of commissioned assets",null,null,{"$f":"D7","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Closing regulatory tax asset value",null,null,{"$f":"D72-D73+D74","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Depreciation temporary differences"]
[null,null,"Value",{"$f":"Inputs!D$12","v":"2018/19"},{"$f":"Inputs!E$12","v":"2019/20"},{"$f":"Inputs!F$12","v":"2020/21"},{"$f":"Inputs!G$12","v":"2021/22"},{"$f":"Inputs!H$12","v":"2022/23"},{"$f":"Inputs!I$12","v":"2023/24"},{"$f":"Inputs!J$12","v":"2024/25"}]
["Total adjusted depreciation of assets",null,null,{"$f":"D59+D66","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Tax depreciation",null,null,{"$f":"D73","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Depreciation temporary differences",null,null,{"$f":"D78-D79","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Deductions for regulatory tax purposes"]
["Amortisation of initial differences in asset values",null,null,{"$f":"D9","v":{"$error":"#N/A"}},{"$f":"D82","v":{"$error":"#N/A"}},{"$f":"E82","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Notional deductible interest",null,null,{"$f":"(D23*$D$19*$D$18+D22)/(1+$D$18)^0.5","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Amortisation of revaluations",null,null,{"$f":"D21-D78","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Regulatory tax adjustments",null,null,{"$f":"D82+D84-D83","v":{"$error":"#N/A"}},{"$f":"E82+E84-E83","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
["Deferred tax asset value"]
[null,null,"Value",{"$f":"Inputs!D$12","v":"2018/19"},{"$f":"Inputs!E$12","v":"2019/20"},{"$f":"Inputs!F$12","v":"2020/21"},{"$f":"Inputs!G$12","v":"2021/22"},{"$f":"Inputs!H$12","v":"2022/23"},{"$f":"Inputs!I$12","v":"2023/24"},{"$f":"Inputs!J$12","v":"2024/25"}]
["Opening deferred tax",null,null,{"$f":"D17","v":{"$error":"#N/A"}},{"$f":"D92","v":{"$error":"#N/A"}},{"$f":"E92","v":{"$error":"#N/A"}},{"$f":"F92","v":{"$error":"#N/A"}},{"$f":"G92","v":{"$error":"#N/A"}},{"$f":"H92","v":{"$error":"#N/A"}},{"$f":"I92","v":{"$error":"#N/A"}}]
["Depreciation temporary differences",null,null,{"$f":"D80","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Amortisation of initial differences in asset values",null,null,{"$f":"D82","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Closing deferred tax",null,null,{"$f":"D89+(D90-D91)*D6","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Outputs"]
[null,null,"Value",{"$f":"Inputs!D$12","v":"2018/19"},{"$f":"Inputs!E$12","v":"2019/20"},{"$f":"Inputs!F$12","v":"2020/21"},{"$f":"Inputs!G$12","v":"2021/22"},{"$f":"Inputs!H$12","v":"2022/23"},{"$f":"Inputs!I$12","v":"2023/24"},{"$f":"Inputs!J$12","v":"2024/25"}]
["Total adjusted depreciation of commissioned assets",null,null,{"$f":"D59","v":0},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Opening deferred tax",null,null,{"$f":"D89","v":{"$error":"#N/A"}},{"$f":"E89","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Closing deferred tax",null,null,{"$f":"D92","v":{"$error":"#N/A"}},{"$f":"E92","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Regulatory tax adjustments",null,null,{"$f":"D85","v":{"$error":"#N/A"}},{"$f":"E85","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"BBAR","index":11,"n_rows":59,"n_cols":10,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
["Building blocks allowable revenue",null,null,null,null,null,null,null,null,{"$f":"EDB_Name","v":"Total for selected EDBs"}]
["Derivation of BBAR present value, opening investment value, and TCSD allowance."]
["Inputs"]
[null,"Source","Value",{"$f":"Inputs!D$12","v":"2018/19"},{"$f":"Inputs!E$12","v":"2019/20"},{"$f":"Inputs!F$12","v":"2020/21"},{"$f":"Inputs!G$12","v":"2021/22"},{"$f":"Inputs!H$12","v":"2022/23"},{"$f":"Inputs!I$12","v":"2023/24"},{"$f":"Inputs!J$12","v":"2024/25"}]
["Year in regulatory period","EDB data",null,null,null,{"$f":"'EDB data'!D22","v":1},{"$f":"'EDB data'!E22","v":2},{"$f":"'EDB data'!F22","v":3},{"$f":"'EDB data'!G22","v":4},{"$f":"'EDB data'!H22","v":5}]
["Tax rate","EDB data",null,{"$f":"'EDB data'!B25","v":0.28000000000000003},{"$f":"'EDB data'!C25","v":0.28000000000000003},{"$f":"'EDB data'!D25","v":0.28000000000000003},{"$f":"'EDB data'!E25","v":0.28000000000000003},{"$f":"'EDB data'!F25","v":0.28000000000000003},{"$f":"'EDB data'!G25","v":0.28000000000000003},{"$f":"'EDB data'!H25","v":0.28000000000000003}]
["Other regulated income","EDB data",null,{"$f":"'EDB data'!$B82","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B83","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B84","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B85","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B86","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B87","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B88","v":{"$error":"#N/A"}}]
["Term credit spread differential allowance","EDB data",null,{"$f":"'EDB data'!B39","v":{"$error":"#N/A"}}]
["Value of commissioned assets","EDB data",null,{"$f":"'EDB data'!$B64","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B65","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B66","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B67","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B68","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B69","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B70","v":{"$error":"#N/A"}}]
["Operating expenditure","EDB data",null,{"$f":"'EDB data'!$B46","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B47","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B48","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B49","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B50","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B51","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B52","v":{"$error":"#N/A"}}]
["Vanilla WACC (67th percentile)","EDB data",{"$f":"WACC","v":4.5699999999999998E-2}]
["TFopex","TIMING",{"$f":"TIMING!C23","v":1.0225321432719434}]
["TFtax","TIMING",{"$f":"TIMING!C24","v":1.0225321432719434}]
["TFVCA","TIMING",{"$f":"TIMING!C25","v":1.0225321432719434}]
["TFori","TIMING",{"$f":"TIMING!C26","v":1.0225321432719434}]
["TFrev","TIMING",{"$f":"TIMING!C27","v":1.0182846181695255}]
["Aggregate opening RAB value","RAB",null,{"$f":"RAB!D93","v":{"$error":"#N/A"}},{"$f":"RAB!E93","v":{"$error":"#N/A"}},{"$f":"RAB!F93","v":{"$error":"#N/A"}},{"$f":"RAB!G93","v":{"$error":"#N/A"}},{"$f":"RAB!H93","v":{"$error":"#N/A"}},{"$f":"RAB!I93","v":{"$error":"#N/A"}},{"$f":"RAB!J93","v":{"$error":"#N/A"}}]
["Total revaluation","RAB",null,{"$f":"RAB!D94","v":{"$error":"#N/A"}},{"$f":"RAB!E94","v":{"$error":"#N/A"}},{"$f":"RAB!F94","v":{"$error":"#N/A"}},{"$f":"RAB!G94","v":{"$error":"#N/A"}},{"$f":"RAB!H94","v":{"$error":"#N/A"}},{"$f":"RAB!I94","v":{"$error":"#N/A"}},{"$f":"RAB!J94","v":{"$error":"#N/A"}}]
["Total depreciation","RAB",null,{"$f":"RAB!D92","v":{"$error":"#N/A"}},{"$f":"RAB!E92","v":{"$error":"#N/A"}},{"$f":"RAB!F92","v":{"$error":"#N/A"}},{"$f":"RAB!G92","v":{"$error":"#N/A"}},{"$f":"RAB!H92","v":{"$error":"#N/A"}},{"$f":"RAB!I92","v":{"$error":"#N/A"}},{"$f":"RAB!J92","v":{"$error":"#N/A"}}]
["Opening deferred tax","TAX",null,{"$f":"TAX!D96","v":{"$error":"#N/A"}},{"$f":"TAX!E96","v":{"$error":"#N/A"}},{"$f":"TAX!F96","v":{"$error":"#N/A"}},{"$f":"TAX!G96","v":{"$error":"#N/A"}},{"$f":"TAX!H96","v":{"$error":"#N/A"}},{"$f":"TAX!I96","v":{"$error":"#N/A"}},{"$f":"TAX!J96","v":{"$error":"#N/A"}}]
["Closing deferred tax","TAX",null,{"$f":"TAX!D97","v":{"$error":"#N/A"}},{"$f":"TAX!E97","v":{"$error":"#N/A"}},{"$f":"TAX!F97","v":{"$error":"#N/A"}},{"$f":"TAX!G97","v":{"$error":"#N/A"}},{"$f":"TAX!H97","v":{"$error":"#N/A"}},{"$f":"TAX!I97","v":{"$error":"#N/A"}},{"$f":"TAX!J97","v":{"$error":"#N/A"}}]
["Regulatory tax adjustments","TAX",null,{"$f":"TAX!D98","v":{"$error":"#N/A"}},{"$f":"TAX!E98","v":{"$error":"#N/A"}},{"$f":"TAX!F98","v":{"$error":"#N/A"}},{"$f":"TAX!G98","v":{"$error":"#N/A"}},{"$f":"TAX!H98","v":{"$error":"#N/A"}},{"$f":"TAX!I98","v":{"$error":"#N/A"}},{"$f":"TAX!J98","v":{"$error":"#N/A"}}]
["Calculations"]
["Term credit spread differential allowance"]
[null,null,null,{"$f":"Inputs!D$12","v":"2018/19"},{"$f":"Inputs!E$12","v":"2019/20"},{"$f":"Inputs!F$12","v":"2020/21"},{"$f":"Inputs!G$12","v":"2021/22"},{"$f":"Inputs!H$12","v":"2022/23"},{"$f":"Inputs!I$12","v":"2023/24"},{"$f":"Inputs!J$12","v":"2024/25"}]
["Asset base scaling factor",null,null,{"$f":"D17/$D$17","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Term credit spread differential allowance",null,null,{"$f":"IF(D8>0,D8,0)","v":{"$error":"#N/A"}},{"$f":"$D27*E26","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Return on capital"]
[null,null,null,{"$f":"Inputs!D$12","v":"2018/19"},{"$f":"Inputs!E$12","v":"2019/20"},{"$f":"Inputs!F$12","v":"2020/21"},{"$f":"Inputs!G$12","v":"2021/22"},{"$f":"Inputs!H$12","v":"2022/23"},{"$f":"Inputs!I$12","v":"2023/24"},{"$f":"Inputs!J$12","v":"2024/25"}]
["Opening investment value",null,null,{"$f":"D17+D20","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Value of commissioned assets",null,null,{"$f":"D9","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Term credit spread differential allowance",null,null,{"$f":"D27","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Total revaluation",null,null,{"$f":"D18","v":{"$error":"#N/A"}},{"$f":"E18","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Return on capital",null,null,{"$f":"D30*$C$11+D31*($C$14-1)+D32-D33","v":{"$error":"#N/A"}},{"$f":"E30*$C$11+E31*($C$14-1)+E32-E33","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Operating expenditure"]
[null,null,null,{"$f":"Inputs!D$12","v":"2018/19"},{"$f":"Inputs!E$12","v":"2019/20"},{"$f":"Inputs!F$12","v":"2020/21"},{"$f":"Inputs!G$12","v":"2021/22"},{"$f":"Inputs!H$12","v":"2022/23"},{"$f":"Inputs!I$12","v":"2023/24"},{"$f":"Inputs!J$12","v":"2024/25"}]
["Operating expenditure",null,null,{"$f":"D10","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Operating expenditure allowance",null,null,{"$f":"D37*$C$12","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Building block allowable revenue before tax (BBAR before tax)"]
[null,null,null,{"$f":"Inputs!D$12","v":"2018/19"},{"$f":"Inputs!E$12","v":"2019/20"},{"$f":"Inputs!F$12","v":"2020/21"},{"$f":"Inputs!G$12","v":"2021/22"},{"$f":"Inputs!H$12","v":"2022/23"},{"$f":"Inputs!I$12","v":"2023/24"},{"$f":"Inputs!J$12","v":"2024/25"}]
["Increase in deferred tax asset, ΔDT",null,null,{"$f":"D21-D20","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["BBAR before tax in revenue date terms, calculation not referencing tax",null,null,{"$f":"(D34+D19+D38+((D7-D37-D19+D22)*D6+D41)*$C13-D41-D7*$C15)/($C16-D6*$C13)","v":{"$error":"#N/A"}},{"$f":"(E34+E19+E38+((E7-E37-E19+E22)*E6+E41)*$C13-E41-E7*$C15)/($C16-E6*$C13)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Regulatory tax allowance before considering possibility of tax losses",null,null,{"$f":"(D42+D7-D37-D19+D22)*D6","v":{"$error":"#N/A"}},{"$f":"(E42+E7-E37-E19+E22)*E6","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Regulatory tax allowance",null,null,{"$f":"IF(D43<0,#N/A,D43)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["BBAR before tax in year-end terms, direct simple calculation",null,null,{"$f":"D34+D19+D38+(D44+D41)*$C$13-D41-D7*$C$15","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["BBAR before tax in revenue date terms",null,null,{"$f":"D45/$C$16","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Difference between the two BBAR calculations (should = 0)",null,null,{"$f":"D42-D46","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Present value of the building block allowable revenue before tax"]
[null,null,"Value",{"$f":"Inputs!D$12","v":"2018/19"},{"$f":"Inputs!E$12","v":"2019/20"},{"$f":"Inputs!F$12","v":"2020/21"},{"$f":"Inputs!G$12","v":"2021/22"},{"$f":"Inputs!H$12","v":"2022/23"},{"$f":"Inputs!I$12","v":"2023/24"},{"$f":"Inputs!J$12","v":"2024/25"}]
["Number of years to discount the year-end  values to start of the present value period",null,null,null,null,{"$f":"F5","v":1},{"$f":"G5","v":2},{"$f":"H5","v":3},{"$f":"I5","v":4},{"$f":"J5","v":5}]
["BBAR before tax in year-end terms, i.e. Rev * TFrev",null,null,null,null,{"$f":"F45","v":{"$error":"#N/A"}},{"$f":"G45","v":{"$error":"#N/A"}},{"$f":"H45","v":{"$error":"#N/A"}},{"$f":"I45","v":{"$error":"#N/A"}},{"$f":"J45","v":{"$error":"#N/A"}}]
["PV at 1 Apr 2015 of BBAR before tax for each year",null,null,null,null,{"$f":"F51/(1+WACC)^F$50","v":{"$error":"#N/A"}},{"$f":"G51/(1+WACC)^G$50","v":{"$error":"#N/A"}},{"$f":"H51/(1+WACC)^H$50","v":{"$error":"#N/A"}},{"$f":"I51/(1+WACC)^I$50","v":{"$error":"#N/A"}},{"$f":"J51/(1+WACC)^J$50","v":{"$error":"#N/A"}}]
["PV at 1 Apr 2015 of BBAR before tax over the regulatory period",null,{"$f":"SUM(F52:J52)","v":{"$error":"#N/A"}}]
["Outputs"]
[null,null,"Value",{"$f":"Inputs!D$12","v":"2018/19"},{"$f":"Inputs!E$12","v":"2019/20"},{"$f":"Inputs!F$12","v":"2020/21"},{"$f":"Inputs!G$12","v":"2021/22"},{"$f":"Inputs!H$12","v":"2022/23"},{"$f":"Inputs!I$12","v":"2023/24"},{"$f":"Inputs!J$12","v":"2024/25"}]
["Opening investment value",null,null,{"$f":"D30","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["PV at 1 Apr 2015 of BBAR before tax over the regulatory period",null,{"$f":"C53","v":{"$error":"#N/A"}}]
["Term credit spread differential allowance",null,null,{"$f":"D27","v":{"$error":"#N/A"}},{"$f":"E27","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["BBAR before tax in revenue date terms, calculation not referencing tax",null,null,{"$f":"D42","v":{"$error":"#N/A"}},{"$f":"E42","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"REV","index":12,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Revenue growth index",null,null,null,null,null,null,{"$f":"EDB_Name","v":"Total for selected EDBs"}]
["Derivation of the normalised profile of the maximum allowable revenue before tax values."]
["Inputs"]
[null,"Source","Value",{"$f":"Inputs!F$12","v":"2020/21"},{"$f":"Inputs!G$12","v":"2021/22"},{"$f":"Inputs!H$12","v":"2022/23"},{"$f":"Inputs!I$12","v":"2023/24"},{"$f":"Inputs!J$12","v":"2024/25"}]
["Constant price revenue growth","EDB data",null,{"$f":"'EDB data'!$B57","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B58","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B59","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B60","v":{"$error":"#N/A"}},{"$f":"'EDB data'!$B61","v":{"$error":"#N/A"}}]
["Industry-wide X factor","EDB data",{"$f":"'EDB data'!B14","v":0}]
["Alternative X factor","EDB data",{"$f":"'EDB data'!B43","v":""}]
["Forecast changes in the CPI element of the price path","EDB data",null,{"$f":"'EDB data'!D24","v":1.7504378984726898E-2},{"$f":"'EDB data'!E24","v":1.9502114592602871E-2},{"$f":"'EDB data'!F24","v":2.0248058977042183E-2},{"$f":"'EDB data'!G24","v":2.0000000000000018E-2},{"$f":"'EDB data'!H24","v":2.0000000000000018E-2}]
["Calculations"]
[{"$f":"\"Index of price path with industry-wide X factor of \"&TEXT(C6,\"#0.0%\")","v":"Index of price path with industry-wide X factor of 0.0%"}]
[null,null,"Value",{"$f":"Inputs!F$12","v":"2020/21"},{"$f":"Inputs!G$12","v":"2021/22"},{"$f":"Inputs!H$12","v":"2022/23"},{"$f":"Inputs!I$12","v":"2023/24"},{"$f":"Inputs!J$12","v":"2024/25"}]
["X value applied",null,{"$f":"C6","v":0}]
["Index of price path",null,null,1,{"$f":"D13*(1+E$8)*(1-$C$6)","v":1.0195021145926029},{"$f":"E13*(1+F$8)*(1-$C$6)","v":1.0401450535360932},{"$f":"F13*(1+G$8)*(1-$C$6)","v":1.060947954606815},{"$f":"G13*(1+H$8)*(1-$C$6)","v":1.0821669136989513}]
["Index of constant price growth",null,null,1,{"$f":"D14*(1+E$5)","v":{"$error":"#N/A"}},{"$f":"E14*(1+F$5)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"}]
["Indexed maximum allowable revenue before tax",null,null,1,{"$f":"E13*E14","v":{"$error":"#N/A"}},{"$f":"F13*F14","v":{"$error":"#N/A"}},{"$f":"G13*G14","v":{"$error":"#N/A"}},{"$f":"H13*H14","v":{"$error":"#N/A"}}]
[{"$f":"\"CPI minus X revenues with applicable X factor (\" & IF(ISNUMBER(C7),\"alternate X factor of \" & TEXT(C7,\"#0.0%\"), \"industry-wide X factor of \" & TEXT(C6,\"#0.0%\"))&\")\"","v":"CPI minus X revenues with applicable X factor (industry-wide X factor of 0.0%)"}]
[null,null,"Value",{"$f":"Inputs!F$12","v":"2020/21"},{"$f":"Inputs!G$12","v":"2021/22"},{"$f":"Inputs!H$12","v":"2022/23"},{"$f":"Inputs!I$12","v":"2023/24"},{"$f":"Inputs!J$12","v":"2024/25"}]
["X value applied",null,{"$f":"IF(ISNUMBER(C7),C7,C6)","v":0}]
["Index of price path",null,null,1,{"$f":"D19*(1+E$8)*(1-$C$18)","v":1.0195021145926029},{"$f":"E19*(1+F$8)*(1-$C$18)","v":1.0401450535360932},{"$f":"F19*(1+G$8)*(1-$C$18)","v":1.060947954606815},{"$f":"G19*(1+H$8)*(1-$C$18)","v":1.0821669136989513}]
["Index of constant price growth",null,null,1,{"$f":"D20*(1+E$5)","v":{"$error":"#N/A"}},{"$f":"E20*(1+F$5)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"}]
["Indexed maximum allowable revenue before tax",null,null,1,{"$f":"E19*E20","v":{"$error":"#N/A"}},{"$f":"F19*F20","v":{"$error":"#N/A"}},{"$f":"G19*G20","v":{"$error":"#N/A"}},{"$f":"H19*H20","v":{"$error":"#N/A"}}]
[]
["This data block calculates maximum allowable revenues for the regulatory period for the 2014/15 X value that has been applied.  These"]
["Maximum allowable revenues are set PV equivalent to the corresponding maximum allowable revenues for the industry-wide X CPI - X revenues."]
["Outputs"]
[null,null,"Misc.",{"$f":"Inputs!F$12","v":"2020/21"},{"$f":"Inputs!G$12","v":"2021/22"},{"$f":"Inputs!H$12","v":"2022/23"},{"$f":"Inputs!I$12","v":"2023/24"},{"$f":"Inputs!J$12","v":"2024/25"}]
["Indexed maximum allowable revenue before tax—industry wide X factor",null,null,{"$f":"D15","v":1},{"$f":"E15","v":{"$error":"#N/A"}},{"$f":"F15","v":{"$error":"#N/A"}},{"$f":"G15","v":{"$error":"#N/A"}},{"$f":"H15","v":{"$error":"#N/A"}}]
["Indexed maximum allowable revenue before tax—applicable X factor",null,null,{"$f":"D21","v":1},{"$f":"E21","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"MAR","index":13,"n_rows":61,"n_cols":8,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["Maximum allowable revenue",null,null,null,null,null,null,{"$f":"EDB_Name","v":"Total for selected EDBs"}]
["Derivation of starting prices."]
["Inputs"]
[null,"Source","Value",{"$f":"Inputs!F$12","v":"2020/21"},{"$f":"Inputs!G$12","v":"2021/22"},{"$f":"Inputs!H$12","v":"2022/23"},{"$f":"Inputs!I$12","v":"2023/24"},{"$f":"Inputs!J$12","v":"2024/25"}]
["Year in regulatory period","EDB data",null,{"$f":"'EDB data'!D22","v":1},{"$f":"'EDB data'!E22","v":2},{"$f":"'EDB data'!F22","v":3},{"$f":"'EDB data'!G22","v":4},{"$f":"'EDB data'!H22","v":5}]
["Industry-wide X factor","EDB data",{"$f":"'EDB data'!B14","v":0}]
["Additional allowance in 1 April 2015 PV terms","EDB data",{"$f":"'EDB data'!B42","v":{"$error":"#N/A"}}]
["Alternative X factor","EDB data",{"$f":"'EDB data'!B43","v":""}]
["Vanilla WACC (67th percentile)","EDB data",{"$f":"WACC","v":4.5699999999999998E-2}]
["TFrev","TIMING",{"$f":"TIMING!C27","v":1.0182846181695255}]
["Constant price revenue growth 2015","EDB data",{"$f":"'EDB data'!B56","v":{"$error":"#N/A"}}]
["Constant price revenue growth 2016","EDB data",{"$f":"'EDB data'!B57","v":{"$error":"#N/A"}}]
["PV at 1 Apr 2015 of BBAR before tax over the regulatory period","BBAR",{"$f":"BBAR!C57","v":{"$error":"#N/A"}}]
["Indexed maximum allowable revenue before tax—industry wide X factor","REV",null,{"$f":"REV!D27","v":1},{"$f":"REV!E27","v":{"$error":"#N/A"}},{"$f":"REV!F27","v":{"$error":"#N/A"}},{"$f":"REV!G27","v":{"$error":"#N/A"}},{"$f":"REV!H27","v":{"$error":"#N/A"}}]
["Indexed maximum allowable revenue before tax—applicable X factor","REV",null,{"$f":"REV!D28","v":1},{"$f":"REV!E28","v":{"$error":"#N/A"}},{"$f":"REV!F28","v":{"$error":"#N/A"}},{"$f":"REV!G28","v":{"$error":"#N/A"}},{"$f":"REV!H28","v":{"$error":"#N/A"}}]
["Calculations"]
[{"$f":"\"CPI minus X revenues with industry-wide X factor of \"&TEXT(C6,\"#0.0%\")","v":"CPI minus X revenues with industry-wide X factor of 0.0%"}]
[null,null,"PV at \n1-Apr-15",{"$f":"Inputs!F$12","v":"2020/21"},{"$f":"Inputs!G$12","v":"2021/22"},{"$f":"Inputs!H$12","v":"2022/23"},{"$f":"Inputs!I$12","v":"2023/24"},{"$f":"Inputs!J$12","v":"2024/25"}]
["PV at 1 Apr 2015 of BBAR before tax over the regulatory period",null,{"$f":"C13","v":{"$error":"#N/A"}}]
["Additional allowance",null,{"$f":"C7","v":{"$error":"#N/A"}}]
["PV at 1 Apr 2015 of maximum allowable revenue before tax",null,{"$f":"C19+C20","v":{"$error":"#N/A"}}]
["Indexed maximum allowable revenue before tax",null,null,{"$f":"D14","v":1},{"$f":"E14","v":{"$error":"#N/A"}},{"$f":"F14","v":{"$error":"#N/A"}},{"$f":"G14","v":{"$error":"#N/A"}},{"$f":"H14","v":{"$error":"#N/A"}}]
["Present value of indexed maximum allowable revenue for each year",null,null,{"$f":"D22/(1+$C$9)^D$5","v":0.95629721717509797},{"$f":"E22/(1+$C$9)^E$5","v":{"$error":"#N/A"}},{"$f":"F22/(1+$C$9)^F$5","v":{"$error":"#N/A"}},{"$f":"G22/(1+$C$9)^G$5","v":{"$error":"#N/A"}},{"$f":"H22/(1+$C$9)^H$5","v":{"$error":"#N/A"}}]
["Present value of indexed revenue",null,{"$f":"SUM(D23:H23)","v":{"$error":"#N/A"}}]
["Maximum allowable revenue before tax in first year of the regulatory period",null,{"$f":"C21/C24","v":{"$error":"#N/A"}}]
["Maximum allowable revenue before tax in year-end terms",null,null,{"$f":"$C25*D22","v":{"$error":"#N/A"}},{"$f":"$C25*E22","v":{"$error":"#N/A"}},{"$f":"$C25*F22","v":{"$error":"#N/A"}},{"$f":"$C25*G22","v":{"$error":"#N/A"}},{"$f":"$C25*H22","v":{"$error":"#N/A"}}]
["Maximum allowable revenue before tax in revenue-date terms",null,null,{"$f":"D26/$C$10","v":{"$error":"#N/A"}},{"$f":"E26/$C$10","v":{"$error":"#N/A"}},{"$f":"F26/$C$10","v":{"$error":"#N/A"}},{"$f":"G26/$C$10","v":{"$error":"#N/A"}},{"$f":"H26/$C$10","v":{"$error":"#N/A"}}]
["PV at 1 Apr 2015 of maximum allowable revenue before tax in year-end terms in each year",null,null,{"$f":"D26/(1+$C$9)^D5","v":{"$error":"#N/A"}},{"$f":"E26/(1+$C$9)^E5","v":{"$error":"#N/A"}},{"$f":"F26/(1+$C$9)^F5","v":{"$error":"#N/A"}},{"$f":"G26/(1+$C$9)^G5","v":{"$error":"#N/A"}},{"$f":"H26/(1+$C$9)^H5","v":{"$error":"#N/A"}}]
["PV at 1 Apr 2015 of maximum allowable revenue before tax",null,{"$f":"SUM(D28:H28)","v":{"$error":"#N/A"}}]
["Error check for PV equivalence (should = 0)",null,{"$f":"C21-C29","v":{"$error":"#N/A"}}]
["ΔD",null,{"$f":"(1+$C$11)*(1+$C$12)","v":{"$error":"#N/A"}}]
["ANR 2016 (industry-wide X-factor)",null,{"$f":"C29/C31","v":{"$error":"#N/A"}}]
[{"$f":"\"CPI minus X revenues with applicable X factor (\" & IF(ISNUMBER(C8),\"alternate X factor of \" & TEXT(C8,\"#0.0%\"), \"industry-wide X factor of \" & TEXT(C6,\"#0.0%\"))&\")\"","v":"CPI minus X revenues with applicable X factor (industry-wide X factor of 0.0%)"}]
[null,null,"PV at \n1-Apr-15","2015/16","2016/17","2017/18","2018/19","2019/20"]
["PV at 1 Apr 2015 of BBAR before tax over the regulatory period",null,{"$f":"C13","v":{"$error":"#N/A"}}]
["Additional allowance",null,{"$f":"C7","v":{"$error":"#N/A"}}]
["PV at 1 Apr 2015 of maximum allowable revenue before tax",null,{"$f":"C35+C36","v":{"$error":"#N/A"}}]
["Indexed maximum allowable revenue before tax",null,null,{"$f":"D15","v":1},{"$f":"E15","v":{"$error":"#N/A"}},{"$f":"F15","v":{"$error":"#N/A"}},{"$f":"G15","v":{"$error":"#N/A"}},{"$f":"H15","v":{"$error":"#N/A"}}]
["Present value of indexed maximum allowable revenue for each year",null,null,{"$f":"D38/(1+$C$9)^D$5","v":0.95629721717509797},{"$f":"E38/(1+$C$9)^E$5","v":{"$error":"#N/A"}},{"$f":"F38/(1+$C$9)^F$5","v":{"$error":"#N/A"}},{"$f":"G38/(1+$C$9)^G$5","v":{"$error":"#N/A"}},{"$f":"H38/(1+$C$9)^H$5","v":{"$error":"#N/A"}}]
["Present value of indexed revenue",null,{"$f":"SUM(D39:H39)","v":{"$error":"#N/A"}}]
["Maximum allowable revenue before tax in first year of the regulatory period",null,{"$f":"C37/C40","v":{"$error":"#N/A"}}]
["Maximum allowable revenue before tax in year-end terms",null,null,{"$f":"$C41*D38","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"$C41*F38","v":{"$error":"#N/A"}},{"$f":"$C41*G38","v":{"$error":"#N/A"}},{"$f":"$C41*H38","v":{"$error":"#N/A"}}]
["Maximum allowable revenue before tax in revenue-date terms",null,null,{"$f":"D42/$C$10","v":{"$error":"#N/A"}},{"$f":"E42/$C$10","v":{"$error":"#N/A"}},{"$f":"F42/$C$10","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"}]
["PV at 1 Apr 2015 of maximum allowable revenue before tax in year-end terms in each year",null,null,{"$f":"D42/(1+$C$9)^D$5","v":{"$error":"#N/A"}},{"$f":"E42/(1+$C$9)^E$5","v":{"$error":"#N/A"}},{"$f":"F42/(1+$C$9)^F$5","v":{"$error":"#N/A"}},{"$f":"G42/(1+$C$9)^G$5","v":{"$error":"#N/A"}},{"$f":"H42/(1+$C$9)^H$5","v":{"$error":"#N/A"}}]
["PV at 1 Apr 2015 of maximum allowable revenue before tax",null,{"$f":"SUM(D44:H44)","v":{"$error":"#N/A"}}]
["Difference from PV equivalence (incentives etc.)",null,{"$f":"C37-C45","v":{"$error":"#N/A"}}]
["ΔD",null,{"$f":"(1+$C$11)*(1+$C$12)","v":{"$error":"#N/A"}}]
["ANR 2016 (applicable X-factor)",null,{"$f":"D44/C47","v":{"$error":"#N/A"}}]
[]
["This data block uses the applicable 2014/15 X factor to calculate the maximum allowable revenues for the regulatory period.  These allowed"]
["revenues are PV-equivalent to the corresponding revenues calculated with the industry-wide X factor in the previous data block."]
["Outputs"]
[null,null,null,{"$f":"Inputs!F$12","v":"2020/21"},{"$f":"Inputs!G$12","v":"2021/22"},{"$f":"Inputs!H$12","v":"2022/23"},{"$f":"Inputs!I$12","v":"2023/24"},{"$f":"Inputs!J$12","v":"2024/25"}]
["Maximum allowable revenue before tax in revenue-date terms for industry wide X factor",null,null,{"$f":"D27","v":{"$error":"#N/A"}},{"$f":"E27","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Maximum allowable revenue before tax in revenue-date terms for applicable X factor",null,null,{"$f":"D43","v":{"$error":"#N/A"}},{"$f":"E43","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Starting price for industry-wide X factor",null,null,{"$f":"D27","v":{"$error":"#N/A"}}]
["Starting price for applicable X factor",null,null,{"$f":"D43","v":{"$error":"#N/A"}}]
["PV at 1 Apr 2015 of MAR before tax over the regulatory period (industry X )",null,null,{"$f":"C21","v":{"$error":"#N/A"}}]
["PV at 1 Apr 2015 of MAR before tax over the regulatory period (Applicable X)",null,null,{"$f":"C37","v":{"$error":"#N/A"}}]
["ΔD",null,null,{"$f":"C47","v":{"$error":"#N/A"}}]
["ANR 2016 (applicable X-factor)",null,null,{"$f":"C48","v":{"$error":"#N/A"}}]

{"sheet":"Reconciliation","index":14,"n_rows":64,"n_cols":56,"rows_kept":64,"cut":false,"hidden":false,"merged":[[40,31,63,31],[7,22,7,31],[38,21,38,33],[4,2,4,3],[3,2,3,3],[5,2,5,3],[6,2,6,3],[38,2,38,15],[40,11,63,11]]}
["Reconciliation with financial models outputs"]
["Reconciliation of this waterfall model outputs with 2015 and 2020 financial model outputs",null,null,null,null,"How this sheet operates",null,null,null,null,"Mode is set by Cell C5 on the Waterfall chart.",null,null,null,null,{"$f":"\"Currently, mode = \" & Waterfall!D5","v":"Currently, mode = 14"}]
[null,null,null,null,null,"When the mode is set to 14, the panel with a blue fill colour below (see Cell W11) should be filled with zeros."]
["Distributor",null,"Scenario",null,null,"When the mode is set to 0, the panel with a tan fill colour below (see Cell C40) should be filled with zeros."]
["Name",null,{"$f":"EDB_Name","v":"Total for selected EDBs"}]
["Distributor number",null,{"$f":"'EDB data'!C6","v":{"$error":"#N/A"}},null,null,null,"Block below with this fill colour is for data table with first argument set to C5, second argument blank."]
[]
[null,"Active EDB outputs",{"$f":"Inputs!C28","v":"Alpine Energy"},{"$f":"Inputs!D28","v":"Aurora Energy"},{"$f":"Inputs!E28","v":"Centralines"},{"$f":"Inputs!F28","v":"EA Networks"},{"$f":"Inputs!G28","v":"Eastland Network"},{"$f":"Inputs!H28","v":"Electricity Invercargill"},{"$f":"Inputs!I28","v":"Horizon Energy"},{"$f":"Inputs!J28","v":"Nelson Electricity"},{"$f":"Inputs!K28","v":"Network Tasman"},{"$f":"Inputs!L28","v":"Orion NZ"},{"$f":"Inputs!M28","v":"OtagoNet"},{"$f":"Inputs!N28","v":"Powerco"},{"$f":"Inputs!O28","v":"The Lines Company"},{"$f":"Inputs!P28","v":"Top Energy"},{"$f":"Inputs!Q28","v":"Unison Networks"},{"$f":"Inputs!R28","v":"Vector Lines"},{"$f":"Inputs!S28","v":"Wellington Electricity"},null,null,null,"Reconciliation of this waterfall model with the 2020 financial model outputs is achieved when the blue coloured panel below indicates zero values. This requires the \"mode\" setting at cell D5 on the Waterfall sheet to be set to 14. Powerco is not represented in this panel as it is not featured in the outputs of the DPP3 financial model."]
["Distributor number",{"$f":"C6","v":{"$error":"#N/A"}},{"$f":"Inputs!C29","v":1},{"$f":"Inputs!D29","v":2},{"$f":"Inputs!E29","v":3},{"$f":"Inputs!F29","v":4},{"$f":"Inputs!G29","v":5},{"$f":"Inputs!H29","v":6},{"$f":"Inputs!I29","v":7},{"$f":"Inputs!J29","v":8},{"$f":"Inputs!K29","v":9},{"$f":"Inputs!L29","v":10},{"$f":"Inputs!M29","v":11},{"$f":"Inputs!N29","v":12},{"$f":"Inputs!O29","v":13},{"$f":"Inputs!P29","v":14},{"$f":"Inputs!Q29","v":15},{"$f":"Inputs!R29","v":16},{"$f":"Inputs!S29","v":17}]
["Outputs",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,"Alpine Energy","Aurora Energy","Centralines","EA Networks","Eastland Network","Electricity Invercargill","Horizon Energy","Nelson Electricity","Network Tasman","Orion","OtagoNet","The Lines Company","Top Energy","Unison Networks","Vector Lines","Wellington Electricity",null,null,"Alpine Energy","Aurora Energy","Centralines","EA Networks","Eastland Network","Electricity Invercargill","Horizon Energy","Nelson Electricity","Network Tasman","Orion","OtagoNet","The Lines Company","Top Energy","Unison Networks","Vector Lines","Wellington Electricity"]
["PV at 1 Apr 2020 of BBAR",{"$f":"BBAR!C57","v":{"$error":"#N/A"}},197663.65837135509,404731.89102215419,43409.181980635003,154129.87085083392,111354.27249703996,56804.61895783151,110815.25072060908,25496.677575106482,122587.85652703056,734520.4663136201,119468.4454341872,{"$error":"#N/A"},160845.65359569533,176169.62200077286,463516.48731981998,1801373.7352488665,423604.99113666004,null,null,null,{"$f":"C11-AO11","v":0},{"$f":"D11-AP11","v":0},{"$f":"E11-AQ11","v":0},0,0,0,0,0,0,0,{"$f":"M11-AY11","v":0},{"$f":"O11-AZ11","v":0},{"$f":"P11-BA11","v":0},0,0,0,null,null,{"$f":"[1]Outputs!C9","v":197663.65837135509},{"$f":"[1]Outputs!D9","v":404731.89102215419},{"$f":"[1]Outputs!E9","v":43409.181980635003},{"$f":"[1]Outputs!F9","v":154129.87085083392},{"$f":"[1]Outputs!G9","v":111354.27249703996},{"$f":"[1]Outputs!H9","v":56804.61895783151},{"$f":"[1]Outputs!I9","v":110815.25072060908},{"$f":"[1]Outputs!J9","v":25496.677575106482},{"$f":"[1]Outputs!K9","v":122587.85652703056},{"$f":"[1]Outputs!L9","v":734520.4663136201},{"$f":"[1]Outputs!M9","v":119468.4454341872},{"$f":"[1]Outputs!O9","v":160845.65359569533},{"$f":"[1]Outputs!P9","v":176169.62200077286},{"$f":"[1]Outputs!Q9","v":463516.48731981998},{"$f":"[1]Outputs!R9","v":1801373.7352488665},{"$f":"[1]Outputs!S9","v":423604.99113666004}]
["Starting price for industry-wide X factor",{"$f":"MAR!D56","v":{"$error":"#N/A"}},42652.594084747587,87334.541934299879,9366.9935780126234,33258.712663227125,24028.436099748465,12257.510432166828,23912.123990469623,5501.7672347113685,26452.460342221599,158497.53846888477,25779.342298051128,{"$error":"#N/A"},34707.869062223712,38014.531549069543,100019.29918800581,388707.0762403229,91407.049166724333,null,null,null,{"$f":"C12-AO12","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"O12-AZ12","v":0},0,0,0,0,null,null,{"$f":"[1]Outputs!C10","v":42652.594084747587},{"$f":"[1]Outputs!D10","v":87334.541934299879},{"$f":"[1]Outputs!E10","v":9366.9935780126234},{"$f":"[1]Outputs!F10","v":33258.712663227125},{"$f":"[1]Outputs!G10","v":24028.436099748465},{"$f":"[1]Outputs!H10","v":12257.510432166828},{"$f":"[1]Outputs!I10","v":23912.123990469623},{"$f":"[1]Outputs!J10","v":5501.7672347113685},{"$f":"[1]Outputs!K10","v":26452.460342221599},{"$f":"[1]Outputs!L10","v":158497.53846888477},{"$f":"[1]Outputs!M10","v":25779.342298051128},{"$f":"[1]Outputs!O10","v":34707.869062223712},{"$f":"[1]Outputs!P10","v":38014.531549069543},{"$f":"[1]Outputs!Q10","v":100019.29918800581},{"$f":"[1]Outputs!R10","v":388707.0762403229},{"$f":"[1]Outputs!S10","v":91407.049166724333}]
["Starting price for applicable X factor",{"$f":"MAR!D57","v":{"$error":"#N/A"}},42652.594084747587,87334.541934299879,9366.9935780126234,33258.712663227125,24028.436099748465,12257.510432166828,23912.123990469623,5501.7672347113685,26452.460342221599,158497.53846888477,25779.342298051128,{"$error":"#N/A"},34707.869062223712,38014.531549069543,100019.29918800581,388707.0762403229,91407.049166724333,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"[1]Outputs!C11","v":42652.594084747587},{"$f":"[1]Outputs!D11","v":87334.541934299879},{"$f":"[1]Outputs!E11","v":9366.9935780126234},{"$f":"[1]Outputs!F11","v":33258.712663227125},{"$f":"[1]Outputs!G11","v":24028.436099748465},{"$f":"[1]Outputs!H11","v":12257.510432166828},{"$f":"[1]Outputs!I11","v":23912.123990469623},{"$f":"[1]Outputs!J11","v":5501.7672347113685},{"$f":"[1]Outputs!K11","v":26452.460342221599},{"$f":"[1]Outputs!L11","v":158497.53846888477},{"$f":"[1]Outputs!M11","v":25779.342298051128},{"$f":"[1]Outputs!O11","v":34707.869062223712},{"$f":"[1]Outputs!P11","v":38014.531549069543},{"$f":"[1]Outputs!Q11","v":100019.29918800581},{"$f":"[1]Outputs!R11","v":388707.0762403229},{"$f":"[1]Outputs!S11","v":91407.049166724333}]
["PV at 1 Apr 2020 of MAR before tax over the regulatory period (Applicable X)",{"$f":"MAR!D59","v":{"$error":"#N/A"}},197663.65837135509,404731.89102215419,43409.181980635003,154129.87085083392,111354.27249703996,56804.61895783151,110815.25072060908,25496.677575106482,122587.85652703056,734520.4663136201,119468.4454341872,{"$error":"#N/A"},160845.65359569533,176169.62200077286,463516.48731981998,1801373.7352488665,423604.99113666004,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"[1]Outputs!C12","v":197663.65837135509},{"$f":"[1]Outputs!D12","v":404731.89102215419},{"$f":"[1]Outputs!E12","v":43409.181980635003},{"$f":"[1]Outputs!F12","v":154129.87085083392},{"$f":"[1]Outputs!G12","v":111354.27249703996},{"$f":"[1]Outputs!H12","v":56804.61895783151},{"$f":"[1]Outputs!I12","v":110815.25072060908},{"$f":"[1]Outputs!J12","v":25496.677575106482},{"$f":"[1]Outputs!K12","v":122587.85652703056},{"$f":"[1]Outputs!L12","v":734520.4663136201},{"$f":"[1]Outputs!M12","v":119468.4454341872},{"$f":"[1]Outputs!O12","v":160845.65359569533},{"$f":"[1]Outputs!P12","v":176169.62200077286},{"$f":"[1]Outputs!Q12","v":463516.48731981998},{"$f":"[1]Outputs!R12","v":1801373.7352488665},{"$f":"[1]Outputs!S12","v":423604.99113666004}]
["MAR (industry-wide X factor), first year of reg period",{"$f":"MAR!D54","v":{"$error":"#N/A"}},42652.594084747587,87334.541934299879,9366.9935780126234,33258.712663227125,24028.436099748465,12257.510432166828,23912.123990469623,5501.7672347113685,26452.460342221599,158497.53846888477,25779.342298051128,{"$error":"#N/A"},34707.869062223712,38014.531549069543,100019.29918800581,388707.0762403229,91407.049166724333,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"[1]Outputs!C13","v":42652.594084747587},{"$f":"[1]Outputs!D13","v":87334.541934299879},{"$f":"[1]Outputs!E13","v":9366.9935780126234},{"$f":"[1]Outputs!F13","v":33258.712663227125},{"$f":"[1]Outputs!G13","v":24028.436099748465},{"$f":"[1]Outputs!H13","v":12257.510432166828},{"$f":"[1]Outputs!I13","v":23912.123990469623},{"$f":"[1]Outputs!J13","v":5501.7672347113685},{"$f":"[1]Outputs!K13","v":26452.460342221599},{"$f":"[1]Outputs!L13","v":158497.53846888477},{"$f":"[1]Outputs!M13","v":25779.342298051128},{"$f":"[1]Outputs!O13","v":34707.869062223712},{"$f":"[1]Outputs!P13","v":38014.531549069543},{"$f":"[1]Outputs!Q13","v":100019.29918800581},{"$f":"[1]Outputs!R13","v":388707.0762403229},{"$f":"[1]Outputs!S13","v":91407.049166724333}]
["MAR (industry-wide X factor), second year of reg period",{"$f":"MAR!E54","v":{"$error":"#N/A"}},43484.409862260109,89037.750178995091,9549.6697601591986,33907.327888787833,24497.041414046795,12496.55780523497,24378.460972684286,5609.0633297845379,26968.339255071889,161588.57562675045,26282.093985669657,{"$error":"#N/A"},35384.74590194026,38755.89529952361,101969.88702224212,396287.68618411728,93189.679914145483,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"[1]Outputs!C14","v":43484.409862260109},{"$f":"[1]Outputs!D14","v":89037.750178995091},{"$f":"[1]Outputs!E14","v":9549.6697601591986},{"$f":"[1]Outputs!F14","v":33907.327888787833},{"$f":"[1]Outputs!G14","v":24497.041414046795},{"$f":"[1]Outputs!H14","v":12496.55780523497},{"$f":"[1]Outputs!I14","v":24378.460972684286},{"$f":"[1]Outputs!J14","v":5609.0633297845379},{"$f":"[1]Outputs!K14","v":26968.339255071889},{"$f":"[1]Outputs!L14","v":161588.57562675045},{"$f":"[1]Outputs!M14","v":26282.093985669657},{"$f":"[1]Outputs!O14","v":35384.74590194026},{"$f":"[1]Outputs!P14","v":38755.89529952361},{"$f":"[1]Outputs!Q14","v":101969.88702224212},{"$f":"[1]Outputs!R14","v":396287.68618411728},{"$f":"[1]Outputs!S14","v":93189.679914145483}]
["MAR (industry-wide X factor), third year of reg period",{"$f":"MAR!F54","v":{"$error":"#N/A"}},44364.884757733031,90840.591795802538,9743.0320366741798,34593.885463633924,24993.058953361466,12749.588844685386,24872.077488228726,5722.6359748919804,27514.395778821465,164860.43063605714,26814.255374731667,{"$error":"#N/A"},36101.2183238504,39540.626953256447,104034.57930855082,404311.74262584897,95076.590049098799,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"[1]Outputs!C15","v":44364.884757733031},{"$f":"[1]Outputs!D15","v":90840.591795802538},{"$f":"[1]Outputs!E15","v":9743.0320366741798},{"$f":"[1]Outputs!F15","v":34593.885463633924},{"$f":"[1]Outputs!G15","v":24993.058953361466},{"$f":"[1]Outputs!H15","v":12749.588844685386},{"$f":"[1]Outputs!I15","v":24872.077488228726},{"$f":"[1]Outputs!J15","v":5722.6359748919804},{"$f":"[1]Outputs!K15","v":27514.395778821465},{"$f":"[1]Outputs!L15","v":164860.43063605714},{"$f":"[1]Outputs!M15","v":26814.255374731667},{"$f":"[1]Outputs!O15","v":36101.2183238504},{"$f":"[1]Outputs!P15","v":39540.626953256447},{"$f":"[1]Outputs!Q15","v":104034.57930855082},{"$f":"[1]Outputs!R15","v":404311.74262584897},{"$f":"[1]Outputs!S15","v":95076.590049098799}]
["MAR (industry-wide X factor), fourth year of reg period",{"$f":"MAR!G54","v":{"$error":"#N/A"}},45252.18245288769,92657.403631718582,9937.8926774076626,35285.763172906605,25492.920132428691,13004.580621579093,25369.519037993294,5837.0886943898195,28064.683694397896,168157.63924877826,27350.540482226294,{"$error":"#N/A"},36823.242690327403,40331.439492321573,106115.27089472182,412397.97747836594,96978.121850080759,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"[1]Outputs!C16","v":45252.18245288769},{"$f":"[1]Outputs!D16","v":92657.403631718582},{"$f":"[1]Outputs!E16","v":9937.8926774076626},{"$f":"[1]Outputs!F16","v":35285.763172906605},{"$f":"[1]Outputs!G16","v":25492.920132428691},{"$f":"[1]Outputs!H16","v":13004.580621579093},{"$f":"[1]Outputs!I16","v":25369.519037993294},{"$f":"[1]Outputs!J16","v":5837.0886943898195},{"$f":"[1]Outputs!K16","v":28064.683694397896},{"$f":"[1]Outputs!L16","v":168157.63924877826},{"$f":"[1]Outputs!M16","v":27350.540482226294},{"$f":"[1]Outputs!O16","v":36823.242690327403},{"$f":"[1]Outputs!P16","v":40331.439492321573},{"$f":"[1]Outputs!Q16","v":106115.27089472182},{"$f":"[1]Outputs!R16","v":412397.97747836594},{"$f":"[1]Outputs!S16","v":96978.121850080759}]
["MAR (industry-wide X factor), fifth year of reg period",{"$f":"MAR!H54","v":{"$error":"#N/A"}},46157.226101945445,94510.551704352954,10136.650530955818,35991.478436364734,26002.778535077268,13264.672234010673,25876.909418753163,5953.8304682776161,28625.977368285854,171520.79203375385,27897.551291870823,{"$error":"#N/A"},37559.707544133955,41138.068282168002,108237.57631261626,420645.93702793325,98917.684287082389,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"[1]Outputs!C17","v":46157.226101945445},{"$f":"[1]Outputs!D17","v":94510.551704352954},{"$f":"[1]Outputs!E17","v":10136.650530955818},{"$f":"[1]Outputs!F17","v":35991.478436364734},{"$f":"[1]Outputs!G17","v":26002.778535077268},{"$f":"[1]Outputs!H17","v":13264.672234010673},{"$f":"[1]Outputs!I17","v":25876.909418753163},{"$f":"[1]Outputs!J17","v":5953.8304682776161},{"$f":"[1]Outputs!K17","v":28625.977368285854},{"$f":"[1]Outputs!L17","v":171520.79203375385},{"$f":"[1]Outputs!M17","v":27897.551291870823},{"$f":"[1]Outputs!O17","v":37559.707544133955},{"$f":"[1]Outputs!P17","v":41138.068282168002},{"$f":"[1]Outputs!Q17","v":108237.57631261626},{"$f":"[1]Outputs!R17","v":420645.93702793325},{"$f":"[1]Outputs!S17","v":98917.684287082389}]
["MAR (applicable X factor), first year of reg period",{"$f":"MAR!D55","v":{"$error":"#N/A"}},42652.594084747587,87334.541934299879,9366.9935780126234,33258.712663227125,24028.436099748465,12257.510432166828,23912.123990469623,5501.7672347113685,26452.460342221599,158497.53846888477,25779.342298051128,{"$error":"#N/A"},34707.869062223712,38014.531549069543,100019.29918800581,388707.0762403229,91407.049166724333,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"[1]Outputs!C18","v":42652.594084747587},{"$f":"[1]Outputs!D18","v":87334.541934299879},{"$f":"[1]Outputs!E18","v":9366.9935780126234},{"$f":"[1]Outputs!F18","v":33258.712663227125},{"$f":"[1]Outputs!G18","v":24028.436099748465},{"$f":"[1]Outputs!H18","v":12257.510432166828},{"$f":"[1]Outputs!I18","v":23912.123990469623},{"$f":"[1]Outputs!J18","v":5501.7672347113685},{"$f":"[1]Outputs!K18","v":26452.460342221599},{"$f":"[1]Outputs!L18","v":158497.53846888477},{"$f":"[1]Outputs!M18","v":25779.342298051128},{"$f":"[1]Outputs!O18","v":34707.869062223712},{"$f":"[1]Outputs!P18","v":38014.531549069543},{"$f":"[1]Outputs!Q18","v":100019.29918800581},{"$f":"[1]Outputs!R18","v":388707.0762403229},{"$f":"[1]Outputs!S18","v":91407.049166724333}]
["MAR (applicable X factor), second year of reg period",{"$f":"MAR!E55","v":{"$error":"#N/A"}},43484.409862260109,89037.750178995091,9549.6697601591986,33907.327888787833,24497.041414046795,12496.55780523497,24378.460972684286,5609.0633297845379,26968.339255071889,161588.57562675045,26282.093985669657,{"$error":"#N/A"},35384.74590194026,38755.89529952361,101969.88702224212,396287.68618411728,93189.679914145483,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"[1]Outputs!C19","v":43484.409862260109},{"$f":"[1]Outputs!D19","v":89037.750178995091},{"$f":"[1]Outputs!E19","v":9549.6697601591986},{"$f":"[1]Outputs!F19","v":33907.327888787833},{"$f":"[1]Outputs!G19","v":24497.041414046795},{"$f":"[1]Outputs!H19","v":12496.55780523497},{"$f":"[1]Outputs!I19","v":24378.460972684286},{"$f":"[1]Outputs!J19","v":5609.0633297845379},{"$f":"[1]Outputs!K19","v":26968.339255071889},{"$f":"[1]Outputs!L19","v":161588.57562675045},{"$f":"[1]Outputs!M19","v":26282.093985669657},{"$f":"[1]Outputs!O19","v":35384.74590194026},{"$f":"[1]Outputs!P19","v":38755.89529952361},{"$f":"[1]Outputs!Q19","v":101969.88702224212},{"$f":"[1]Outputs!R19","v":396287.68618411728},{"$f":"[1]Outputs!S19","v":93189.679914145483}]
["MAR (applicable X factor), third year of reg period",{"$f":"MAR!F55","v":{"$error":"#N/A"}},44364.884757733031,90840.591795802538,9743.0320366741798,34593.885463633924,24993.058953361466,12749.588844685386,24872.077488228726,5722.6359748919804,27514.395778821465,164860.43063605714,26814.255374731667,{"$error":"#N/A"},36101.2183238504,39540.626953256447,104034.57930855082,404311.74262584897,95076.590049098799,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"[1]Outputs!C20","v":44364.884757733031},{"$f":"[1]Outputs!D20","v":90840.591795802538},{"$f":"[1]Outputs!E20","v":9743.0320366741798},{"$f":"[1]Outputs!F20","v":34593.885463633924},{"$f":"[1]Outputs!G20","v":24993.058953361466},{"$f":"[1]Outputs!H20","v":12749.588844685386},{"$f":"[1]Outputs!I20","v":24872.077488228726},{"$f":"[1]Outputs!J20","v":5722.6359748919804},{"$f":"[1]Outputs!K20","v":27514.395778821465},{"$f":"[1]Outputs!L20","v":164860.43063605714},{"$f":"[1]Outputs!M20","v":26814.255374731667},{"$f":"[1]Outputs!O20","v":36101.2183238504},{"$f":"[1]Outputs!P20","v":39540.626953256447},{"$f":"[1]Outputs!Q20","v":104034.57930855082},{"$f":"[1]Outputs!R20","v":404311.74262584897},{"$f":"[1]Outputs!S20","v":95076.590049098799}]
["MAR (applicable X factor), fourth year of reg period",{"$f":"MAR!G55","v":{"$error":"#N/A"}},45252.18245288769,92657.403631718582,9937.8926774076626,35285.763172906605,25492.920132428691,13004.580621579093,25369.519037993294,5837.0886943898195,28064.683694397896,168157.63924877826,27350.540482226294,{"$error":"#N/A"},36823.242690327403,40331.439492321573,106115.27089472182,412397.97747836594,96978.121850080759,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"[1]Outputs!C21","v":45252.18245288769},{"$f":"[1]Outputs!D21","v":92657.403631718582},{"$f":"[1]Outputs!E21","v":9937.8926774076626},{"$f":"[1]Outputs!F21","v":35285.763172906605},{"$f":"[1]Outputs!G21","v":25492.920132428691},{"$f":"[1]Outputs!H21","v":13004.580621579093},{"$f":"[1]Outputs!I21","v":25369.519037993294},{"$f":"[1]Outputs!J21","v":5837.0886943898195},{"$f":"[1]Outputs!K21","v":28064.683694397896},{"$f":"[1]Outputs!L21","v":168157.63924877826},{"$f":"[1]Outputs!M21","v":27350.540482226294},{"$f":"[1]Outputs!O21","v":36823.242690327403},{"$f":"[1]Outputs!P21","v":40331.439492321573},{"$f":"[1]Outputs!Q21","v":106115.27089472182},{"$f":"[1]Outputs!R21","v":412397.97747836594},{"$f":"[1]Outputs!S21","v":96978.121850080759}]
["MAR (applicable X factor), fifth year of reg period",{"$f":"MAR!H55","v":{"$error":"#N/A"}},46157.226101945445,94510.551704352954,10136.650530955818,35991.478436364734,26002.778535077268,13264.672234010673,25876.909418753163,5953.8304682776161,28625.977368285854,171520.79203375385,27897.551291870823,{"$error":"#N/A"},37559.707544133955,41138.068282168002,108237.57631261626,420645.93702793325,98917.684287082389,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"[1]Outputs!C22","v":46157.226101945445},{"$f":"[1]Outputs!D22","v":94510.551704352954},{"$f":"[1]Outputs!E22","v":10136.650530955818},{"$f":"[1]Outputs!F22","v":35991.478436364734},{"$f":"[1]Outputs!G22","v":26002.778535077268},{"$f":"[1]Outputs!H22","v":13264.672234010673},{"$f":"[1]Outputs!I22","v":25876.909418753163},{"$f":"[1]Outputs!J22","v":5953.8304682776161},{"$f":"[1]Outputs!K22","v":28625.977368285854},{"$f":"[1]Outputs!L22","v":171520.79203375385},{"$f":"[1]Outputs!M22","v":27897.551291870823},{"$f":"[1]Outputs!O22","v":37559.707544133955},{"$f":"[1]Outputs!P22","v":41138.068282168002},{"$f":"[1]Outputs!Q22","v":108237.57631261626},{"$f":"[1]Outputs!R22","v":420645.93702793325},{"$f":"[1]Outputs!S22","v":98917.684287082389}]
["BBAR before tax, first year of reg period",{"$f":"BBAR!F59","v":{"$error":"#N/A"}},41745.646003901988,83163.894085121588,9223.0780517578187,32360.966363715288,23556.880969242549,12031.832896491811,23661.632619176824,5440.1331956028544,25909.179762975014,153176.71291052661,24969.689365800677,{"$error":"#N/A"},33817.403539668296,37177.758507926934,97101.473468586235,375704.61177741969,89348.618865775366,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"[1]Outputs!C23","v":41745.646003901988},{"$f":"[1]Outputs!D23","v":83163.894085121588},{"$f":"[1]Outputs!E23","v":9223.0780517578187},{"$f":"[1]Outputs!F23","v":32360.966363715288},{"$f":"[1]Outputs!G23","v":23556.880969242549},{"$f":"[1]Outputs!H23","v":12031.832896491811},{"$f":"[1]Outputs!I23","v":23661.632619176824},{"$f":"[1]Outputs!J23","v":5440.1331956028544},{"$f":"[1]Outputs!K23","v":25909.179762975018},{"$f":"[1]Outputs!L23","v":153176.71291052661},{"$f":"[1]Outputs!M23","v":24969.689365800685},{"$f":"[1]Outputs!O23","v":33817.403539668296},{"$f":"[1]Outputs!P23","v":37177.758507926934},{"$f":"[1]Outputs!Q23","v":97101.473468586235},{"$f":"[1]Outputs!R23","v":375704.61177741969},{"$f":"[1]Outputs!S23","v":89348.618865775366}]
["BBAR before tax, second year of reg period",{"$f":"BBAR!G59","v":{"$error":"#N/A"}},42930.854638362791,86584.680794345128,9456.0870122644592,33274.877294642938,24152.480400478034,12299.857484397877,24119.659300659976,5545.1429117806429,26619.519370299768,157730.38744265636,25588.280158950452,{"$error":"#N/A"},34837.583687268321,38094.703300851797,100069.66012886327,387546.77095884824,91600.240317022646,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"[1]Outputs!C24","v":42930.854638362791},{"$f":"[1]Outputs!D24","v":86584.680794345128},{"$f":"[1]Outputs!E24","v":9456.0870122644592},{"$f":"[1]Outputs!F24","v":33274.877294642938},{"$f":"[1]Outputs!G24","v":24152.480400478034},{"$f":"[1]Outputs!H24","v":12299.857484397877},{"$f":"[1]Outputs!I24","v":24119.659300659976},{"$f":"[1]Outputs!J24","v":5545.1429117806429},{"$f":"[1]Outputs!K24","v":26619.519370299768},{"$f":"[1]Outputs!L24","v":157730.38744265636},{"$f":"[1]Outputs!M24","v":25588.280158950452},{"$f":"[1]Outputs!O24","v":34837.583687268321},{"$f":"[1]Outputs!P24","v":38094.703300851797},{"$f":"[1]Outputs!Q24","v":100069.66012886327},{"$f":"[1]Outputs!R24","v":387546.77095884824},{"$f":"[1]Outputs!S24","v":91600.240317022646}]
["BBAR before tax, third year of reg period",{"$f":"BBAR!H59","v":{"$error":"#N/A"}},44412.843395391865,91034.349656230959,9752.8855501682701,34609.963116407402,24979.184982626251,12729.668224724233,24815.848056558665,5715.5523022816687,27539.403994378987,164642.08226332854,26669.162391349422,{"$error":"#N/A"},36123.746608190748,39489.708562189764,104145.3725285416,404401.17251959204,94905.19092733039,null,null,null,0,0,{"$f":"E27-AQ27","v":0},{"$f":"F27-AR27","v":0},{"$f":"G27-AS27","v":0},{"$f":"H27-AT27","v":0},{"$f":"I27-AU27","v":0},{"$f":"J27-AV27","v":0},{"$f":"K27-AW27","v":0},{"$f":"L27-AX27","v":0},0,0,{"$f":"P27-BA27","v":0},{"$f":"Q27-BB27","v":0},{"$f":"R27-BC27","v":0},{"$f":"S27-BD27","v":0},null,null,{"$f":"[1]Outputs!C25","v":44412.843395391865},{"$f":"[1]Outputs!D25","v":91034.349656230959},{"$f":"[1]Outputs!E25","v":9752.8855501682719},{"$f":"[1]Outputs!F25","v":34609.963116407402},{"$f":"[1]Outputs!G25","v":24979.184982626251},{"$f":"[1]Outputs!H25","v":12729.668224724239},{"$f":"[1]Outputs!I25","v":24815.848056558665},{"$f":"[1]Outputs!J25","v":5715.5523022816687},{"$f":"[1]Outputs!K25","v":27539.40399437899},{"$f":"[1]Outputs!L25","v":164642.08226332854},{"$f":"[1]Outputs!M25","v":26669.162391349415},{"$f":"[1]Outputs!O25","v":36123.746608190748},{"$f":"[1]Outputs!P25","v":39489.708562189764},{"$f":"[1]Outputs!Q25","v":104145.3725285416},{"$f":"[1]Outputs!R25","v":404401.17251959204},{"$f":"[1]Outputs!S25","v":94905.19092733039}]
["BBAR before tax, fourth year of reg period",{"$f":"BBAR!I59","v":{"$error":"#N/A"}},45837.082962574175,95336.932387233013,10039.019104093895,35908.977734790154,25806.738397623209,13176.304986651054,25588.431814523854,5887.0784803252736,28425.937054102393,171773.51200762848,27997.973831484676,{"$error":"#N/A"},37399.791422303555,40918.534510216938,108026.54481463431,421033.58773150115,98374.023159137563,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"[1]Outputs!C26","v":45837.082962574175},{"$f":"[1]Outputs!D26","v":95336.932387233013},{"$f":"[1]Outputs!E26","v":10039.019104093897},{"$f":"[1]Outputs!F26","v":35908.977734790154},{"$f":"[1]Outputs!G26","v":25806.738397623209},{"$f":"[1]Outputs!H26","v":13176.304986651054},{"$f":"[1]Outputs!I26","v":25588.431814523854},{"$f":"[1]Outputs!J26","v":5887.0784803252736},{"$f":"[1]Outputs!K26","v":28425.937054102393},{"$f":"[1]Outputs!L26","v":171773.51200762848},{"$f":"[1]Outputs!M26","v":27997.973831484676},{"$f":"[1]Outputs!O26","v":37399.791422303555},{"$f":"[1]Outputs!P26","v":40918.534510216938},{"$f":"[1]Outputs!Q26","v":108026.54481463431},{"$f":"[1]Outputs!R26","v":421033.58773150115},{"$f":"[1]Outputs!S26","v":98374.023159137563}]
["BBAR before tax, fifth year of reg period",{"$f":"BBAR!J59","v":{"$error":"#N/A"}},47210.575491864518,99288.600313741976,10299.218389917909,37118.835357009819,26647.628376627057,13601.648646217178,26304.924971588396,6056.0894363182979,29269.34030505758,178752.32469747824,29140.652576453267,{"$error":"#N/A"},38622.57955405031,42336.412719147156,111779.53528667551,437060.05255067465,101924.17557374279,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"[1]Outputs!C27","v":47210.575491864518},{"$f":"[1]Outputs!D27","v":99288.600313741976},{"$f":"[1]Outputs!E27","v":10299.218389917909},{"$f":"[1]Outputs!F27","v":37118.835357009819},{"$f":"[1]Outputs!G27","v":26647.628376627057},{"$f":"[1]Outputs!H27","v":13601.648646217178},{"$f":"[1]Outputs!I27","v":26304.924971588396},{"$f":"[1]Outputs!J27","v":6056.0894363182979},{"$f":"[1]Outputs!K27","v":29269.34030505758},{"$f":"[1]Outputs!L27","v":178752.32469747824},{"$f":"[1]Outputs!M27","v":29140.652576453267},{"$f":"[1]Outputs!O27","v":38622.57955405031},{"$f":"[1]Outputs!P27","v":42336.412719147156},{"$f":"[1]Outputs!Q27","v":111779.53528667551},{"$f":"[1]Outputs!R27","v":437060.05255067465},{"$f":"[1]Outputs!S27","v":101924.17557374279}]
["Closing RAB, first year of reg period",{"$f":"RAB!F95","v":{"$error":"#N/A"}},211061.46981115534,553394.75154536474,68229.085403312449,294732.02536669734,173134.44165370133,93085.174671491375,139169.51474607098,43372.555437704148,181732.8441826269,1173801.9911983507,220927.50622214028,{"$error":"#N/A"},230355.07276033904,297000.9592587169,671907.77517188166,3376593.5866082534,684490.77762947173,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"[1]Outputs!C28","v":211061.46981115534},{"$f":"[1]Outputs!D28","v":553394.75154536474},{"$f":"[1]Outputs!E28","v":68229.085403312449},{"$f":"[1]Outputs!F28","v":294732.02536669734},{"$f":"[1]Outputs!G28","v":173134.44165370133},{"$f":"[1]Outputs!H28","v":93085.174671491375},{"$f":"[1]Outputs!I28","v":139169.51474607098},{"$f":"[1]Outputs!J28","v":43372.555437704148},{"$f":"[1]Outputs!K28","v":181732.8441826269},{"$f":"[1]Outputs!L28","v":1173801.9911983507},{"$f":"[1]Outputs!M28","v":220927.50622214028},{"$f":"[1]Outputs!O28","v":230355.07276033904},{"$f":"[1]Outputs!P28","v":297000.9592587169},{"$f":"[1]Outputs!Q28","v":671907.77517188166},{"$f":"[1]Outputs!R28","v":3376593.5866082534},{"$f":"[1]Outputs!S28","v":684490.77762947173}]
["Closing RAB, second year of reg period",{"$f":"RAB!G95","v":{"$error":"#N/A"}},217099.58281686774,593568.04967242084,69692.995808116422,305969.30779541336,179230.85042852032,96175.871180181523,140497.06040084714,44220.816920450263,189134.64878715193,1210779.5848788929,229010.70313909347,{"$error":"#N/A"},240551.27355218181,306718.52560854488,701380.24774470774,3510716.5258314651,702234.66419308493,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"[1]Outputs!C29","v":217099.58281686774},{"$f":"[1]Outputs!D29","v":593568.04967242084},{"$f":"[1]Outputs!E29","v":69692.995808116422},{"$f":"[1]Outputs!F29","v":305969.30779541336},{"$f":"[1]Outputs!G29","v":179230.85042852032},{"$f":"[1]Outputs!H29","v":96175.871180181523},{"$f":"[1]Outputs!I29","v":140497.06040084714},{"$f":"[1]Outputs!J29","v":44220.816920450263},{"$f":"[1]Outputs!K29","v":189134.64878715193},{"$f":"[1]Outputs!L29","v":1210779.5848788929},{"$f":"[1]Outputs!M29","v":229010.70313909347},{"$f":"[1]Outputs!O29","v":240551.27355218181},{"$f":"[1]Outputs!P29","v":306718.52560854488},{"$f":"[1]Outputs!Q29","v":701380.24774470774},{"$f":"[1]Outputs!R29","v":3510716.5258314651},{"$f":"[1]Outputs!S29","v":702234.66419308493}]
["Closing RAB, third year of reg period",{"$f":"RAB!H95","v":{"$error":"#N/A"}},220955.61980643834,630450.47508118919,72262.805117660057,316667.2037487257,183917.03692457327,99654.37570198474,142899.87063772173,44968.276466470823,193038.31811858466,1271930.6216776019,241256.91562017723,{"$error":"#N/A"},249313.08473676769,317439.60257876385,727649.42448202707,3644110.9673976786,721034.28952064819,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"[1]Outputs!C30","v":220955.61980643834},{"$f":"[1]Outputs!D30","v":630450.47508118919},{"$f":"[1]Outputs!E30","v":72262.805117660057},{"$f":"[1]Outputs!F30","v":316667.2037487257},{"$f":"[1]Outputs!G30","v":183917.03692457327},{"$f":"[1]Outputs!H30","v":99654.37570198474},{"$f":"[1]Outputs!I30","v":142899.87063772173},{"$f":"[1]Outputs!J30","v":44968.276466470823},{"$f":"[1]Outputs!K30","v":193038.31811858466},{"$f":"[1]Outputs!L30","v":1271930.6216776019},{"$f":"[1]Outputs!M30","v":241256.91562017723},{"$f":"[1]Outputs!O30","v":249313.08473676769},{"$f":"[1]Outputs!P30","v":317439.60257876385},{"$f":"[1]Outputs!Q30","v":727649.42448202707},{"$f":"[1]Outputs!R30","v":3644110.9673976786},{"$f":"[1]Outputs!S30","v":721034.28952064819}]
["Closing RAB, fourth year of reg period",{"$f":"RAB!I95","v":{"$error":"#N/A"}},223503.5106577538,657032.45925061149,73610.042315926374,324867.13609531551,188738.94843330627,103008.97097931962,145453.43502986035,45660.516602781856,197688.6402617541,1321564.4985374822,258207.39458497416,{"$error":"#N/A"},258355.17519360123,327502.28771064541,748985.82478657889,3768824.6375683807,740896.4209320877,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"[1]Outputs!C31","v":223503.5106577538},{"$f":"[1]Outputs!D31","v":657032.45925061149},{"$f":"[1]Outputs!E31","v":73610.042315926374},{"$f":"[1]Outputs!F31","v":324867.13609531551},{"$f":"[1]Outputs!G31","v":188738.94843330627},{"$f":"[1]Outputs!H31","v":103008.97097931962},{"$f":"[1]Outputs!I31","v":145453.43502986035},{"$f":"[1]Outputs!J31","v":45660.516602781856},{"$f":"[1]Outputs!K31","v":197688.6402617541},{"$f":"[1]Outputs!L31","v":1321564.4985374822},{"$f":"[1]Outputs!M31","v":258207.39458497416},{"$f":"[1]Outputs!O31","v":258355.17519360123},{"$f":"[1]Outputs!P31","v":327502.28771064541},{"$f":"[1]Outputs!Q31","v":748985.82478657889},{"$f":"[1]Outputs!R31","v":3768824.6375683807},{"$f":"[1]Outputs!S31","v":740896.4209320877}]
["Closing RAB, fifth year of reg period",{"$f":"RAB!J95","v":{"$error":"#N/A"}},224899.78233633237,687202.79090402857,74982.876182036925,331654.38728115568,193950.84892409373,105770.2015985649,147745.66313517909,46299.63478877554,200442.04054940789,1373821.3778168159,265623.99199197174,{"$error":"#N/A"},265664.74425672099,337469.5466945754,770218.9618836788,3876169.2854917636,761689.6057465754,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"[1]Outputs!C32","v":224899.78233633237},{"$f":"[1]Outputs!D32","v":687202.79090402857},{"$f":"[1]Outputs!E32","v":74982.876182036925},{"$f":"[1]Outputs!F32","v":331654.38728115568},{"$f":"[1]Outputs!G32","v":193950.84892409373},{"$f":"[1]Outputs!H32","v":105770.2015985649},{"$f":"[1]Outputs!I32","v":147745.66313517909},{"$f":"[1]Outputs!J32","v":46299.63478877554},{"$f":"[1]Outputs!K32","v":200442.04054940789},{"$f":"[1]Outputs!L32","v":1373821.3778168159},{"$f":"[1]Outputs!M32","v":265623.99199197174},{"$f":"[1]Outputs!O32","v":265664.74425672099},{"$f":"[1]Outputs!P32","v":337469.5466945754},{"$f":"[1]Outputs!Q32","v":770218.9618836788},{"$f":"[1]Outputs!R32","v":3876169.2854917636},{"$f":"[1]Outputs!S32","v":761689.6057465754}]
[]
[]
[]
[]
[null,null,"The data panel below is a copy of the outputs from the 2015 DPP reset model",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reconciliation of the this waterfall model with the 2015 financial model outputs is achieved when the tan coloured panel below indicates zero values. This reconciliation requires the \"mode\" setting at cell D5 on the Waterfall sheet to be set to 0."]
[null,null,"Alpine Energy","Aurora Energy","Centralines","EA Networks","Eastland Network","Electricity Invercargill","Horizon Energy","Nelson Electricity","Network Tasman","Orion","OtagoNet","Powerco","The Lines Company","Top Energy","Unison Networks","Vector Lines","Wellington Electricity",null,null,null,"Alpine Energy","Aurora Energy","Centralines","EA Networks","Eastland Network","Electricity Invercargill","Horizon Energy","Nelson Electricity","Network Tasman","Orion","OtagoNet","Powerco","The Lines Company","Top Energy","Unison Networks","Vector Lines","Wellington Electricity"]
["PV at 1 Apr 2015 of BBAR",null,207660.39820706175,391914.48522305465,43025.685486567651,172569.62712655391,114700.08653558909,56269.825455037448,114486.94628471154,25582.498582936714,131754.87895366907,"No reconciliation for Orion as the 2015 reset model did not produce meaningful outputs for Orion",114835.08898952522,{"$error":"#N/A"},155390.36756724969,193138.70889657168,468095.95294165175,1846481.3393399762,461489.87219018786,null,null,null,{"$f":"C11-C41","v":-9996.7398357066559},{"$f":"D11-D41","v":12817.405799099535},{"$f":"E11-E41","v":383.49649406735261},{"$f":"F11-F41","v":-18439.756275719992},{"$f":"G11-G41","v":-3345.8140385491279},{"$f":"H11-H41","v":534.79350279406208},{"$f":"I11-I41","v":-3671.6955641024542},{"$f":"J11-J41","v":-85.821007830232702},{"$f":"K11-K41","v":-9167.0224266385194},"No reconciliation for Orion as the 2015 reset model did not produce meaningful outputs for Orion",{"$f":"M11-M41","v":4633.3564446619857},{"$error":"#N/A"},{"$f":"O11-O41","v":5455.2860284456401},{"$f":"P11-P41","v":-16969.086895798828},{"$f":"Q11-Q41","v":-4579.4656218317687},{"$f":"R11-R41","v":-45107.604091109708},{"$f":"S11-S41","v":-37884.881053527817}]
["Starting price for industry-wide X factor",null,45361.380318835836,85609.881181761084,9398.5396333909193,37696.145028874846,25055.110617462473,12291.592306373914,25008.552216993317,5588.2462797242588,28780.562999403519,null,25084.600581412495,{"$error":"#N/A"},33943.504018870779,42189.259503444315,102250.97674098593,403345.76553164725,100807.94309580677,null,null,null,-2708.7862340882493,{"$f":"D12-D42","v":1724.6607525387954},-31.546055378295932,-4437.4323656477209,-1026.6745177140074,-34.081874207086003,-1096.4282265236943,-86.47904501289031,-2328.1026571819202,null,694.74171663863308,{"$f":"N12-N42","v":{"$error":"#N/A"}},{"$f":"O12-O42","v":764.36504335293284},{"$f":"P12-P42","v":-4174.7279543747718},{"$f":"Q12-Q42","v":-2231.6775529801234},{"$f":"R12-R42","v":-14638.68929132435},{"$f":"S12-S42","v":-9400.8939290824346}]
["Starting price for applicable X factor",null,45361.380318835836,72030.727522350353,9398.5396333909193,37696.145028874846,25055.110617462473,12291.592306373914,25008.552216993317,5588.2462797242588,28780.562999403519,null,25084.600581412495,{"$error":"#N/A"},33943.504018870779,42189.259503444315,102250.97674098593,403345.76553164725,100807.94309580677,null,null,null,-2708.7862340882493,15303.814411949526,-31.546055378295932,-4437.4323656477209,-1026.6745177140074,-34.081874207086003,-1096.4282265236943,-86.47904501289031,-2328.1026571819202,null,694.74171663863308,{"$error":"#N/A"},764.36504335293284,-4174.7279543747718,-2231.6775529801234,-14638.68929132435,-9400.8939290824346]
["PV at 1 Apr 2015 of MAR (applicable X)",null,207660.39820706175,391914.48522305465,43025.685486567651,172569.62712655391,114700.08653558909,56269.825455037448,114486.94628471154,25582.498582936714,131754.87895366907,null,114835.08898952522,{"$error":"#N/A"},155390.36756724969,193138.70889657168,468095.95294165175,1846481.3393399762,461489.87219018786,null,null,null,-9996.7398357066559,12817.405799099535,383.49649406735261,-18439.756275719992,-3345.8140385491279,534.79350279406208,-3671.6955641024542,-85.821007830232702,-9167.0224266385194,null,4633.3564446619857,{"$error":"#N/A"},5455.2860284456401,-16969.086895798828,-4579.4656218317687,-45107.604091109708,-37884.881053527817]
["MAR (industry-wide X factor) 2016",null,45361.380318835836,85609.881181761084,9398.5396333909193,37696.145028874846,25055.110617462473,12291.592306373914,25008.552216993317,5588.2462797242588,28780.562999403519,null,25084.600581412495,{"$error":"#N/A"},33943.504018870779,42189.259503444315,102250.97674098593,403345.76553164725,100807.94309580677,null,null,null,-2708.7862340882493,1724.6607525387954,-31.546055378295932,-4437.4323656477209,-1026.6745177140074,-34.081874207086003,-1096.4282265236943,-86.47904501289031,-2328.1026571819202,null,694.74171663863308,{"$error":"#N/A"},764.36504335293284,-4174.7279543747718,-2231.6775529801234,-14638.68929132435,-9400.8939290824346]
["MAR (industry-wide X factor) 2017",null,46302.607367888457,87386.245464948355,9593.5548569657494,38478.32209440507,25574.992236240483,12546.636995785233,25527.467771123949,5704.1997299560207,29377.745981746612,null,25605.094102904884,{"$error":"#N/A"},34647.815569745719,43064.666555545264,104372.63583566528,411714.99816898792,102899.65992925002,null,null,null,-2818.1975056283482,1651.5047140467359,-43.885096806550791,-4570.9942056172367,-1077.9508221936885,-50.079190550262865,-1149.0067984396628,-95.136400171482819,-2409.4067266747224,null,676.99988276477234,{"$error":"#N/A"},736.93033219454082,-4308.7712560216532,-2402.7488134231535,-15427.311984870641,-9709.9800151045347]
["MAR (industry-wide X factor) 2018",null,47259.527920158151,89192.227871223964,9791.8216573430418,39273.540751022774,26103.54207578945,12805.934160364794,26055.035438393847,5822.0865243751123,29984.886065369374,null,26134.266047698256,{"$error":"#N/A"},35363.870424853805,43954.669664359863,106529.67030960236,420223.77479781368,105026.2529011212,null,null,null,-2894.64316242512,1648.3639245785744,-48.789620668861971,-4679.6552873888504,-1110.4831224279842,-56.345315679407577,-1182.9579501651206,-99.450549483131908,-2470.4902865479089,null,679.98932703341052,{"$error":"#N/A"},737.34789899659518,-4414.0427111034151,-2495.0910010515363,-15912.032171964704,-9949.662852022404]
["MAR (industry-wide X factor) 2019",null,48220.471654534704,91005.803171272186,9990.9220310423498,40072.102746293567,26634.314097997169,13066.321488292211,26584.821158974519,5940.4689503707395,30594.578748698554,null,26665.662790668121,{"$error":"#N/A"},36082.935790159165,44848.414614201851,108695.7736058976,428768.32488536916,107161.78671011067,null,null,null,-2968.2892016470141,1651.600460446396,-53.029353634687141,-4786.339573386962,-1141.3939655684771,-61.740866713118521,-1215.302120981225,-103.38025598092008,-2529.8950543006576,null,684.87769155817296,{"$error":"#N/A"},740.30690016823792,-4516.9751218802776,-2580.5027111757809,-16370.347407003224,-10183.664860029909]
["MAR (industry-wide X factor) 2020",null,49184.881087625385,92825.91923469762,10190.740471663195,40873.544801219439,27167.00037995711,13327.647918058054,27116.517582154003,6059.2783293781531,31206.470323672518,null,27198.976046481475,{"$error":"#N/A"},36804.594505962341,45745.38290648588,110869.68907801554,437343.69138307648,109305.02244431285,null,null,null,-3027.6549856799393,1684.6324696553347,-54.089940707377536,-4882.0663648547052,-1164.2218448798412,-62.975684047380128,-1239.6081634008406,-105.44786110053701,-2580.4929553866641,null,698.5752453893474,{"$error":"#N/A"},755.11303817161388,-4607.314624317878,-2632.1127653992735,-16697.754355143232,-10387.338157230464]
["MAR (applicable X factor) 2016",null,45361.380318835836,72030.727522350353,9398.5396333909193,37696.145028874846,25055.110617462473,12291.592306373914,25008.552216993317,5588.2462797242588,28780.562999403519,null,25084.600581412495,{"$error":"#N/A"},33943.504018870779,42189.259503444315,102250.97674098593,403345.76553164725,100807.94309580677,null,null,null,-2708.7862340882493,15303.814411949526,-31.546055378295932,-4437.4323656477209,-1026.6745177140074,-34.081874207086003,-1096.4282265236943,-86.47904501289031,-2328.1026571819202,null,694.74171663863308,{"$error":"#N/A"},764.36504335293284,-4174.7279543747718,-2231.6775529801234,-14638.68929132435,-9400.8939290824346]
["MAR (applicable X factor) 2017",null,46302.607367888457,80069.085274899655,9593.5548569657494,38478.32209440507,25574.992236240483,12546.636995785233,25527.467771123949,5704.1997299560207,29377.745981746612,null,25605.094102904884,{"$error":"#N/A"},34647.815569745719,43064.666555545264,104372.63583566528,411714.99816898792,102899.65992925002,null,null,null,-2818.1975056283482,8968.6649040954362,-43.885096806550791,-4570.9942056172367,-1077.9508221936885,-50.079190550262865,-1149.0067984396628,-95.136400171482819,-2409.4067266747224,null,676.99988276477234,{"$error":"#N/A"},736.93033219454082,-4308.7712560216532,-2402.7488134231535,-15427.311984870641,-9709.9800151045347]
["MAR (applicable X factor) 2018",null,47259.527920158151,88997.268697562627,9791.8216573430418,39273.540751022774,26103.54207578945,12805.934160364794,26055.035438393847,5822.0865243751123,29984.886065369374,null,26134.266047698256,{"$error":"#N/A"},35363.870424853805,43954.669664359863,106529.67030960236,420223.77479781368,105026.2529011212,null,null,null,-2894.64316242512,1843.3230982399109,-48.789620668861971,-4679.6552873888504,-1110.4831224279842,-56.345315679407577,-1182.9579501651206,-99.450549483131908,-2470.4902865479089,null,679.98932703341052,{"$error":"#N/A"},737.34789899659518,-4414.0427111034151,-2495.0910010515363,-15912.032171964704,-9949.662852022404]
["MAR (applicable X factor) 2019",null,48220.471654534704,98888.692132415832,9990.9220310423498,40072.102746293567,26634.314097997169,13066.321488292211,26584.821158974519,5940.4689503707395,30594.578748698554,null,26665.662790668121,{"$error":"#N/A"},36082.935790159165,44848.414614201851,108695.7736058976,428768.32488536916,107161.78671011067,null,null,null,-2968.2892016470141,-6231.2885006972501,-53.029353634687141,-4786.339573386962,-1141.3939655684771,-61.740866713118521,-1215.302120981225,-103.38025598092008,-2529.8950543006576,null,684.87769155817296,{"$error":"#N/A"},740.30690016823792,-4516.9751218802776,-2580.5027111757809,-16370.347407003224,-10183.664860029909]
["MAR (applicable X factor) 2020",null,49184.881087625385,109843.58144684482,10190.740471663195,40873.544801219439,27167.00037995711,13327.647918058054,27116.517582154003,6059.2783293781531,31206.470323672518,null,27198.976046481475,{"$error":"#N/A"},36804.594505962341,45745.38290648588,110869.68907801554,437343.69138307648,109305.02244431285,null,null,null,-3027.6549856799393,-15333.029742491868,-54.089940707377536,-4882.0663648547052,-1164.2218448798412,-62.975684047380128,-1239.6081634008406,-105.44786110053701,-2580.4929553866641,null,698.5752453893474,{"$error":"#N/A"},755.11303817161388,-4607.314624317878,-2632.1127653992735,-16697.754355143232,-10387.338157230464]
["BBAR before tax 2016",null,44262.878522362153,82527.268153896948,9298.802075440788,36223.424335650961,24496.129218319184,12027.784585070518,24667.32378647837,5472.0273638009739,28470.034538785116,null,23955.399137851477,{"$error":"#N/A"},33167.501561148158,40709.528521867636,98760.435737246618,386984.52211722697,98150.995840212519,null,null,null,-2517.232518460165,636.62593122464023,-75.724023682969346,-3862.4579719356734,-939.24824907663424,4.048311421292965,-1005.6911673015456,-31.894168198119587,-2560.8547758101013,null,1014.2902279492009,{"$error":"#N/A"},649.90197852013807,-3531.7700139407025,-1658.9622686603834,-11279.910339807277,-8802.376974437153]
["BBAR before tax 2017",null,45842.349477753196,85841.677010257597,9535.8071372043541,37776.652671523159,25292.443195147389,12408.153993275513,25360.674774666026,5637.866458729327,29228.4466924837,null,24984.67506004799,{"$error":"#N/A"},34274.511006861932,42394.893941533403,102597.34802321855,402846.13479992608,101601.47323464847,null,null,null,-2911.4948393904051,743.00378408753022,-79.720124939894959,-4501.7753768802213,-1139.9627946693545,-108.29650887763637,-1241.0154740060498,-92.723546948684088,-2608.9273221839321,null,603.60509890246249,{"$error":"#N/A"},563.07268040638883,-4300.1906406816051,-2527.6878943552874,-15299.363841077837,-10001.232917625821]
["BBAR before tax 2018",null,47412.55837085189,89457.191433608168,9793.8898323841895,39433.858525779375,26134.341687742188,12823.873705555317,26078.697247779692,5827.1252701128151,30082.097188545955,null,26158.101375627015,{"$error":"#N/A"},35458.499053300002,44071.659814773142,106684.19138127562,421172.62508829666,105175.30259814192,null,null,null,-2999.714975460025,1577.1582226227911,-41.004282215919375,-4823.8954093719731,-1155.1567051159363,-94.20548083108406,-1262.8491912210266,-111.57296783114634,-2542.6931941669682,null,511.06101572240732,{"$error":"#N/A"},665.24755489074596,-4581.9512525833779,-2538.8188527340244,-16771.452568704612,-10270.11167081153]
["BBAR before tax 2019",null,48904.224572483836,92909.924131814827,10057.794443939292,40969.102831348493,26975.609223231677,13236.515877653395,26801.976055772535,6018.0970937012989,30818.25531385103,null,27366.030124978275,{"$error":"#N/A"},36565.312168717006,45719.756494741807,110843.80441166132,439140.84367975325,108761.50065432423,null,null,null,-3067.1416099096605,2427.0082554181863,-18.775339845396957,-5060.1250965583386,-1168.8708256084683,-60.210891002341668,-1213.5442412486809,-131.01861337602531,-2392.3182597486375,null,631.94370650640121,{"$error":"#N/A"},834.47925358654902,-4801.2219845248692,-2817.2595970270049,-18107.255948252103,-10387.477495186671]
["BBAR before tax 2020",null,50173.565712733391,96091.477427791455,10307.083629942885,42367.614080205982,27785.274847213597,13612.053684088689,27472.695840126362,6191.1392198801213,31416.675702952332,null,28536.581297371511,{"$error":"#N/A"},37574.555242191687,47285.815185035339,114767.26830430783,455681.22769619693,112212.47050566599,null,null,null,-2962.9902208688727,3197.1228859505209,-7.8652400249757193,-5248.7787231961629,-1137.6464705865401,-10.405037871511013,-1167.7708685379657,-135.04978356182346,-2147.3353978947525,null,604.07127908175607,{"$error":"#N/A"},1048.0243118586222,-4949.4024658881826,-2987.7330176323158,-18621.175145522284,-10288.294931923199]
["Closing RAB 2016",null,210242.77361234347,563446.29080374888,58616.600878049096,304205.35157509177,175604.45450859264,89399.165965896129,133118.25743695081,42982.408750557974,181162.30534720601,null,221918.60848956113,{"$error":"#N/A"},214523.62236139504,305007.2430817472,654966.40486679866,3242790.7052659155,675256.84389506234,null,null,null,818.696198811871,-10051.539258384146,9612.4845252633531,-9473.3262083944282,-2470.0128548913053,3686.0087055952463,6051.2573091201775,390.14668714617437,570.53883542088442,null,-991.10226742085069,{"$error":"#N/A"},15831.450398943998,-8006.2838230303023,16941.370305082994,133802.88134233793,9233.9337344093947]
["Closing RAB 2017",null,212726.19607265212,582641.49273974425,59357.801202328716,316134.41241931182,179507.21132459081,91265.214285023772,134645.27335652505,43733.759167752265,182423.93815870892,null,232410.3509740498,{"$error":"#N/A"},219571.43146523339,315978.955433094,677351.69890141138,3353145.5576923024,684437.55341662758,null,null,null,4373.3867442156188,10926.556932676584,10335.194605787707,-10165.104623898456,-276.3608960704878,4910.6568951577501,5851.7870443220891,487.05775269799778,6710.7106284430192,null,-3399.6478349563258,{"$error":"#N/A"},20979.842086948425,-9260.4298245491227,24028.548843296361,157570.96813916275,17797.110776457353]
["Closing RAB 2018",null,211780.85137443698,600209.19443829008,59998.493347501753,326506.57884829736,182682.69589246029,93339.284490535443,136333.10469842172,44449.284790843434,182983.54100814412,null,243260.53568287386,{"$error":"#N/A"},223790.07013452254,326098.62861960748,697659.55363501876,3470944.2165618516,693984.84165287367,null,null,null,9174.7684320013504,30241.280642899103,12264.311770158303,-9839.3750995716546,1234.3410321129777,6315.0912114492967,6566.7659393000067,518.99167562738876,10054.77711044054,null,-2003.6200626966311,{"$error":"#N/A"},25523.014602245152,-8659.0260408436297,29989.870847008307,173166.75083582709,27049.447867774521]
["Closing RAB 2019",null,210642.14423148416,614884.92131410853,61032.581190174431,334088.91659700341,186487.27253865747,95208.97757571227,138438.23217368504,45283.121571566538,181039.31388073348,null,254712.84931265062,{"$error":"#N/A"},227283.2721964409,335966.87777507177,722396.0456335448,3577850.4847418973,703591.78478934988,null,null,null,12861.36642626964,42147.537936502951,12577.461125751943,-9221.7805016878992,2251.6758946487971,7799.9934036073537,7015.2028561753104,377.39503121531743,16649.326381020626,null,3494.5452723235358,{"$error":"#N/A"},31071.90299716033,-8464.5900644263602,26589.779153034091,190974.15282648336,37304.636142737814]
["Closing RAB 2020",null,206019.30729299877,629562.35640179762,62011.759922168378,341563.09835528152,190773.32516528381,96975.798981147469,140818.63147838827,45867.798131308242,179101.92362138859,null,265410.68662261171,{"$error":"#N/A"},230837.20022203616,346340.00900170126,744488.18913209008,3668968.328598531,714561.80014263908,null,null,null,18880.475043333601,57640.434502230957,12971.116259868548,-9908.7110741258366,3177.5237588099262,8794.402617417436,6927.0316567908158,431.83665746729821,21340.116928019299,null,213.30536936002318,{"$error":"#N/A"},34827.544034684834,-8870.4623071258538,25730.772751588724,207200.95689323265,47127.805603936315]