{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Index","Input | General","Input | Inflation and Disc Rate","Input | Reported Capex","Calc | CESS Revenue Increments","Output | Models"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Index","index":0,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Input | General'!$B$1","v":"NSW TNSP 2023-28 Regulatory Proposal - Capital expenditure sharing scheme model"}]
[null,"Index"]
[]
[null,null,"Model index"]
[]
[null,null,"Sheet Name","Sheet Description"]
[null,null,"Input | General","Inputs NSP name, regulatory years for the prior and forecast regulatory control period etc."]
[null,null,"Input | Inflation and Disc Rate","Inputs the inflation and discount rate"]
[null,null,"Input | Reported Capex","Inputs the reported capital expenditure from the prior regulatory control period as well as the AER's forecast etc."]
[null,null,"Calc | CESS Revenue Increments","Calculates the CESS payments from the prior regulatory control period"]
[null,null,"Output | Models","Outputs the CESS revenue increments needed as a post tax revenue model input"]
[]
[null,null,"End"]

{"sheet":"Input | General","index":1,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"$D$6&\" \"&$D$8&\" \"&D7&\" - \"&\"Capital expenditure sharing scheme model\"","v":"NSW TNSP 2023-28 Regulatory Proposal - Capital expenditure sharing scheme model"},null,null,null,null,"Key:","Input","Internal Link"]
[null,"Input | General"]
[]
[null,"Input | General"]
[]
[null,null,"NSP Name","NSW TNSP"]
[null,null,"Determination stage","Regulatory Proposal"]
[null,null,"Determination years","2023-28"]
[null,null,"Base regulatory year","2023-24"]
[]
[null,null,"Regulatory control period details"]
[null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,null,"Regulatory control period CESS applied in (regulatory years)",{"$f":"IF(LEN(E13)>4,CONCATENATE(LEFT(E13,4)-1&\"–\"&IF(RIGHT(E13,2)=\"00\",\"99\",IF(RIGHT(E13,2)-1<10,\"0\",\"\")&RIGHT(E13,2)-1)),E13-1)","v":"2018–19"},{"$f":"IF(LEN(F13)>4,CONCATENATE(LEFT(F13,4)-1&\"–\"&IF(RIGHT(F13,2)=\"00\",\"99\",IF(RIGHT(F13,2)-1<10,\"0\",\"\")&RIGHT(F13,2)-1)),F13-1)","v":"2019–20"},"2020–21",{"$f":"IF(LEN(H13)>4,CONCATENATE(LEFT(H13,4)-1&\"–\"&IF(RIGHT(H13,2)=\"00\",\"99\",IF(RIGHT(H13,2)-1<10,\"0\",\"\")&RIGHT(H13,2)-1)),H13-1)","v":"2021–22"},{"$f":"IF(LEN(D9)>4,CONCATENATE(LEFT(D9,4)-1&\"–\"&IF(RIGHT(D9,2)=\"00\",\"99\",IF(RIGHT(D9,2)-1<10,\"0\",\"\")&RIGHT(D9,2)-1)),D9-1)","v":"2022–23"}]
[null,null,"CESS to apply to this year's expenditure (Yes/No)","Yes","Yes","Yes","Yes","Yes"]
[null,null,"Actual or estimate year","Actual","Actual","Actual","Estimate","Estimate"]
[]
[null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,null,"Regulatory control period CESS revenue increment applied in (regulatory years)",{"$f":"D9","v":"2023-24"},{"$f":"IF(LEN(D18)>4,CONCATENATE(LEFT(D18,4)+1&\"–\"&IF(RIGHT(D18,2)+1>9,\"\",\"0\")&RIGHT(D18,2)+1),D18+1)","v":"2024–25"},{"$f":"IF(LEN(E18)>4,CONCATENATE(LEFT(E18,4)+1&\"–\"&IF(RIGHT(E18,2)+1>9,\"\",\"0\")&RIGHT(E18,2)+1),E18+1)","v":"2025–26"},"2026–27","2027–28"]
[]
[null,"End"]

{"sheet":"Input | Inflation and Disc Rate","index":2,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Input | General'!$B$1","v":"NSW TNSP 2023-28 Regulatory Proposal - Capital expenditure sharing scheme model"},null,null,null,null,null,null,"Key:","Input","Internal Link"]
[null,null,"Input | Inflation and Discount rate"]
[]
[null,null,"Input | Inflation"]
[]
[null,null,null,"Source","Unit"]
[null,null,null,null,null,{"$f":"IF(LEN(G7)>4,CONCATENATE(LEFT(G7,4)-1&\"–\"&IF(RIGHT(G7,2)=\"00\",\"99\",IF(RIGHT(G7,2)-1<10,\"0\",\"\")&RIGHT(G7,2)-1)),G7-1)","v":"2017–18"},{"$f":"'Input | General'!D13","v":"2018–19"},{"$f":"'Input | General'!E13","v":"2019–20"},{"$f":"'Input | General'!F13","v":"2020–21"},{"$f":"'Input | General'!G13","v":"2021–22"},{"$f":"'Input | General'!H13","v":"2022–23"},{"$f":"'Input | General'!D18","v":"2023-24"},{"$f":"'Input | General'!E18","v":"2024–25"},{"$f":"'Input | General'!F18","v":"2025–26"},{"$f":"'Input | General'!G18","v":"2026–27"},{"$f":"'Input | General'!H18","v":"2027–28"}]
[null,null,"Actual CPI Inflation Rate","TNSP","Per cent",null,1.9090909090909047E-2,1.7841213202497874E-2,1.8404907975460238E-2,8.6058519793459354E-3,3.2500000000000001E-2]
[null,null,"Forecast CPI Inflation Rate","TNSP","Per cent",null,null,null,null,null,null,2.349953872603594E-2,{"$f":"L9","v":2.349953872603594E-2},2.349953872603594E-2,2.349953872603594E-2,2.349953872603594E-2]
[null,null,{"$f":"\"CPI Index (base year \"&F7&\")\"","v":"CPI Index (base year 2017–18)"},"TNSP","Index",1,{"$f":"IF(G7<>\"\",(F10*(1+G8)),\"\")","v":1.019090909090909},{"$f":"IF(H7<>\"\",(G10*(1+H8)),\"\")","v":1.0372727272727273},{"$f":"IF(I7<>\"\",(H10*(1+I8)),\"\")","v":1.0563636363636366},{"$f":"IF(J7<>\"\",(I10*(1+J8)),\"\")","v":1.0654545454545457},{"$f":"IF(K7<>\"\",(J10*(1+K8)),\"\")","v":1.1000818181818184},{"$f":"IF(L7<>\"\",(K10*(1+L9)),\"\")","v":1.1259332334699901},1.1523921450928489,1.1794728289340379,1.2071898963538805,1.2355583020729279]
[]
[]
[null,null,"Actual CPI Inflation Rate","AER","Per cent",null,{"$f":"G8","v":1.9090909090909047E-2},1.7841213202497874E-2,1.8404907975460238E-2,8.6058519793459354E-3,3.2500000000000001E-2]
[null,null,"Forecast CPI Inflation Rate","AER","Per cent",null,null,null,null,null,null,2.349953872603594E-2,{"$f":"L14","v":2.349953872603594E-2},2.349953872603594E-2,2.349953872603594E-2,2.349953872603594E-2]
[null,null,{"$f":"\"CPI Index (base year \"&F7&\")\"","v":"CPI Index (base year 2017–18)"},"AER","Index",1,{"$f":"IF(G7<>\"\",(F15*(1+G13)),\"\")","v":1.019090909090909},{"$f":"IF(H7<>\"\",(G15*(1+H13)),\"\")","v":1.0372727272727273},{"$f":"IF(I7<>\"\",(H15*(1+I13)),\"\")","v":1.0563636363636366},{"$f":"IF(J7<>\"\",(I15*(1+J13)),\"\")","v":1.0654545454545457},{"$f":"IF(K7<>\"\",(J15*(1+K13)),\"\")","v":1.1000818181818184},{"$f":"IF(L7<>\"\",(K15*(1+L14)),\"\")","v":1.1259332334699901},1.1523921450928489,1.1794728289340379,1.2071898963538805,1.2355583020729279]
[]
[null,null,"Input | Discount rate"]
[]
[null,null,null,"Source","Unit",null,{"$f":"G7","v":"2018–19"},{"$f":"H7","v":"2019–20"},"2020–21","2021–22","2022–23","2023-24","2024–25","2025–26","2026–27","2027–28"]
[null,null,"Real Vanilla WACC","AER","Per cent",null,3.993698958963017E-2,3.8768911813005374E-2,3.6676965385035398E-2,3.4025171303287666E-2,3.4025171303287666E-2]
[null,null,"Forecast Real Vanilla WACC","AER","Per cent",null,null,null,null,null,null,2.2993694731479095E-2,2.2993694731479095E-2,2.2993694731479095E-2,2.2993694731479095E-2,2.2993694731479095E-2]
[null,null,"Nominal Vanilla WACC (fixed, real, time varying)","Calculated","Per cent",null,{"$f":"IF(AND(G13<>\"\",G20<>\"\"),((1+G20)*(1+G13)-1),\"\")","v":5.9790332118159428E-2},{"$f":"IF(AND(H13<>\"\",H20<>\"\"),((1+H20)*(1+H13)-1),\"\")","v":5.7301809436788087E-2},{"$f":"IF(AND(I13<>\"\",I20<>\"\"),((1+I20)*(1+I13)-1),\"\")","v":5.5756909533226429E-2},{"$f":"IF(AND(J13<>\"\",J20<>\"\"),((1+J20)*(1+J13)-1),\"\")","v":4.29238388704416E-2},{"$f":"IF(AND(K13<>\"\",K20<>\"\"),((1+K20)*(1+K13)-1),\"\")","v":6.7630989370644601E-2},{"$f":"IF(AND(L14<>\"\",L21<>\"\"),((1+L21)*(1+L14)-1),\"\")","v":4.7033574677312062E-2},{"$f":"IF(AND(M14<>\"\",M21<>\"\"),((1+M21)*(1+M14)-1),\"\")","v":4.7033574677312062E-2},4.7033574677312062E-2,4.7033574677312062E-2,4.7033574677312062E-2]
[]
[null,"End"]

{"sheet":"Input | Reported Capex","index":3,"n_rows":31,"n_cols":12,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Input | General'!$B$1","v":"NSW TNSP 2023-28 Regulatory Proposal - Capital expenditure sharing scheme model"},null,null,null,null,null,null,"Key:","Input","Internal Link"]
[null,"Input | Capex"]
[]
[null,"Input | Capex Allowance"]
[]
[null,null,null,"Source","Unit","Basis",null,{"$f":"IF('Input | General'!D14=\"Yes\",'Input | General'!D13,\"n/a\")","v":"2018–19"},{"$f":"IF('Input | General'!E14=\"Yes\",'Input | General'!E13,\"n/a\")","v":"2019–20"},{"$f":"IF('Input | General'!F14=\"Yes\",'Input | General'!F13,\"n/a\")","v":"2020–21"},{"$f":"IF('Input | General'!G14=\"Yes\",'Input | General'!G13,\"n/a\")","v":"2021–22"},{"$f":"IF('Input | General'!H14=\"Yes\",'Input | General'!H13,\"n/a\")","v":"2022–23"}]
[]
[null,null,"Total capex allowance","AER","$millions",{"$f":"'Input | Inflation and Disc Rate'!$F$7","v":"2017–18"},null,221.85620239677593,359.86535298196645,600.41313490425318,1240.7562185115657,907.67204607306189]
[null,null,"Asset Disposals","AER","$millions",{"$f":"'Input | Inflation and Disc Rate'!$F$7","v":"2017–18"},null,2.5648828446675327,2.5648828446675327,2.5648828446675327,2.8999624131099253,2.5648828446675327]
[]
[null,null,"Total capex allowance applicable to CESS","Calculated","$millions",{"$f":"'Input | Inflation and Disc Rate'!$F$7","v":"2017–18"},null,{"$f":"IF(H6=\"\", \"\", H8-H9)","v":219.2913195521084},{"$f":"IF(I6=\"\", \"\", I8-I9)","v":357.30047013729893},597.84825205958566,1237.8562560984558,905.10716322839437]
[]
[null,"Input | Actual / Estimate Capex"]
[]
[null,null,null,"Source","Unit","Basis",null,{"$f":"H6","v":"2018–19"},{"$f":"I6","v":"2019–20"},{"$f":"J6","v":"2020–21"},{"$f":"K6","v":"2021–22"},{"$f":"L6","v":"2022–23"}]
[]
[null,null,"Total capex","AER","$millions","nominal",null,216.54694857849694,323.90478146958299,781.53356055757752,724.84168519302079,941.23212496658039]
[null,null,"Asset Disposals","AER","$millions","nominal",null,4.1814481327272723,2.1650702372727273,3.82439741,4.2515327252999997,4.347192211619249]
[null,null,"Other excludable capex","AER","$millions","nominal",null,6.3319466300000009,7.4530970400000003,1.4042736299999996,0,0]
[]
[null,null,"Total actual capex applicable to CESS","Calculated","$millions","nominal",null,{"$f":"IF(H15=\"\", \"\", H17-H18-H19)","v":206.03355381576966},{"$f":"IF(I15=\"\", \"\", I17-I18-I19)","v":314.28661419231025},776.30488951757752,720.59015246772083,936.88493275496114]
[]
[null,"Input | Capex Deferred to following regulatory period"]
[]
[null,null,null,null,null,null,null,{"$f":"'Input | General'!D18","v":"2023-24"},{"$f":"'Input | General'!E18","v":"2024–25"},{"$f":"'Input | General'!F18","v":"2025–26"},{"$f":"'Input | General'!G18","v":"2026–27"},{"$f":"'Input | General'!H18","v":"2027–28"}]
[]
[null,null,"Capex deferred and re-proposed","TNSP","$millions","nominal",null,462.57,78.264788868324516,0,0,0]
[null,null,"Capex deferred and re-proposed","Calculated","$millions",{"$f":"'Input | Inflation and Disc Rate'!$F$7","v":"2017–18"},null,{"$f":"IF(H27<>\"\",H27/('Input | Inflation and Disc Rate'!K10*(1+'Input | Inflation and Disc Rate'!L9)^0.5),\"\")","v":415.63168767601701},{"$f":"IF(I27<>\"\",I27/('Input | Inflation and Disc Rate'!L10*(1+'Input | Inflation and Disc Rate'!M9)^0.5),\"\")","v":68.708418814510082},{"$f":"IF(J27<>\"\",J27/('Input | Inflation and Disc Rate'!M10*(1+'Input | Inflation and Disc Rate'!N9)^0.5),\"\")","v":0},{"$f":"IF(K27<>\"\",K27/('Input | Inflation and Disc Rate'!N10*(1+'Input | Inflation and Disc Rate'!O9)^0.5),\"\")","v":0},{"$f":"IF(L27<>\"\",L27/('Input | Inflation and Disc Rate'!O10*(1+'Input | Inflation and Disc Rate'!P9)^0.5),\"\")","v":0}]
[null,null,"Capex deferred and re-proposed","AER","$millions","nominal",null,{"$f":"IF(H27<>\"\",H28*'Input | Inflation and Disc Rate'!K15*(1+'Input | Inflation and Disc Rate'!L14)^0.5,\"\")","v":462.57000000000005},{"$f":"IF(I27<>\"\",I28*'Input | Inflation and Disc Rate'!L15*(1+'Input | Inflation and Disc Rate'!M14)^0.5,\"\")","v":78.26478886832453},{"$f":"IF(J27<>\"\",J28*'Input | Inflation and Disc Rate'!M15*(1+'Input | Inflation and Disc Rate'!N14)^0.5,\"\")","v":0},{"$f":"IF(K27<>\"\",K28*'Input | Inflation and Disc Rate'!N15*(1+'Input | Inflation and Disc Rate'!O14)^0.5,\"\")","v":0},{"$f":"IF(L27<>\"\",L28*'Input | Inflation and Disc Rate'!O15*(1+'Input | Inflation and Disc Rate'!P14)^0.5,\"\")","v":0}]
[]
[null,"End"]

{"sheet":"Calc | CESS Revenue Increments","index":4,"n_rows":47,"n_cols":13,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Input | General'!$B$1","v":"NSW TNSP 2023-28 Regulatory Proposal - Capital expenditure sharing scheme model"},null,null,null,null,null,null,null,null,"Key:","Input","Internal Link"]
[null,"Input | CESS Payments"]
[]
[null,"Calc | NPV of CESS payments"]
[]
[null,null,"Regulatory period 1"]
[null,null,"Year",{"$f":"IF('Input | General'!D14=\"Yes\",'Input | General'!D13,\"n/a\")","v":"2018–19"},{"$f":"IF('Input | General'!E14=\"Yes\",'Input | General'!E13,\"n/a\")","v":"2019–20"},{"$f":"IF('Input | General'!F14=\"Yes\",'Input | General'!F13,\"n/a\")","v":"2020–21"},{"$f":"IF('Input | General'!G14=\"Yes\",'Input | General'!G13,\"n/a\")","v":"2021–22"},{"$f":"IF('Input | General'!H14=\"Yes\",'Input | General'!H13,\"n/a\")","v":"2022–23"}]
[null,null,"Discount rate (Real WACC)",{"$f":"'Input | Inflation and Disc Rate'!G20","v":3.993698958963017E-2},{"$f":"'Input | Inflation and Disc Rate'!H20","v":3.8768911813005374E-2},{"$f":"'Input | Inflation and Disc Rate'!I20","v":3.6676965385035398E-2},{"$f":"'Input | Inflation and Disc Rate'!J20","v":3.4025171303287666E-2},{"$f":"'Input | Inflation and Disc Rate'!K20","v":3.4025171303287666E-2}]
[null,null,"Discount rate (Nominal, fixed real WACC)",{"$f":"'Input | Inflation and Disc Rate'!G22","v":5.9790332118159428E-2},{"$f":"'Input | Inflation and Disc Rate'!H22","v":5.7301809436788087E-2},{"$f":"'Input | Inflation and Disc Rate'!I22","v":5.5756909533226429E-2},{"$f":"'Input | Inflation and Disc Rate'!J22","v":4.29238388704416E-2},{"$f":"'Input | Inflation and Disc Rate'!K22","v":6.7630989370644601E-2}]
[null,null,"Capex allowance",{"$f":"'Input | Reported Capex'!H$11*'Input | Inflation and Disc Rate'!G$15*(1+'Input | Inflation and Disc Rate'!G$20)^0.5","v":227.89661852263546},{"$f":"'Input | Reported Capex'!I$11*'Input | Inflation and Disc Rate'!H$15*(1+'Input | Inflation and Disc Rate'!H$20)^0.5","v":377.73394877147791},{"$f":"'Input | Reported Capex'!J$11*'Input | Inflation and Disc Rate'!I$15*(1+'Input | Inflation and Disc Rate'!I$20)^0.5","v":643.02244302245549},{"$f":"'Input | Reported Capex'!K$11*'Input | Inflation and Disc Rate'!J$15*(1+'Input | Inflation and Disc Rate'!J$20)^0.5","v":1341.1294456045382},{"$f":"'Input | Reported Capex'!L$11*'Input | Inflation and Disc Rate'!K$15*(1+'Input | Inflation and Disc Rate'!K$20)^0.5","v":1012.4895379165787}]
[null,null,"Actual capex",{"$f":"'Input | Reported Capex'!H21*(1+D$9)^0.5","v":212.10354653064687},{"$f":"'Input | Reported Capex'!I21*(1+E$9)^0.5","v":323.16578367199742},{"$f":"'Input | Reported Capex'!J21*(1+F$9)^0.5","v":797.65352312713992},{"$f":"'Input | Reported Capex'!K21*(1+G$9)^0.5","v":735.89291229837647},{"$f":"'Input | Reported Capex'!L21*(1+H$9)^0.5","v":968.04788442943379}]
[null,null,"Underspend",{"$f":"(D10-D11)","v":15.793071991988597},{"$f":"(E10-E11)","v":54.568165099480495},{"$f":"(F10-F11)","v":-154.63108010468443},605.23653330616173,44.44165348714489]
[null,null,"Year 1 benefit",null,{"$f":"$D$12*$E$8","v":0.61228021531385102},{"$f":"$D$12*$F$8*(1+'Input | Inflation and Disc Rate'!H13)","v":0.58957633398448406},{"$f":"$D$12*$G$8*(1+'Input | Inflation and Disc Rate'!H13)*(1+'Input | Inflation and Disc Rate'!I13)","v":0.55701571871689792},{"$f":"$D$12*$H$8*(1+'Input | Inflation and Disc Rate'!H13)*(1+'Input | Inflation and Disc Rate'!I13)*(1+'Input | Inflation and Disc Rate'!J13)","v":0.56180931354234454}]
[null,null,"Year 2 benefit",null,null,{"$f":"$E$12*F$8","v":2.0013947024785428},{"$f":"$E$12*G$8*(1+'Input | Inflation and Disc Rate'!I13)","v":1.890863395250556},{"$f":"$E$12*H$8*(1+'Input | Inflation and Disc Rate'!I13)*(1+'Input | Inflation and Disc Rate'!J13)","v":1.9071358857432459}]
[null,null,"Year 3 benefit",null,null,null,{"$f":"$F$12*G$8","v":-5.2613489893742846},{"$f":"$F$12*$H$8*(1+'Input | Inflation and Disc Rate'!J13)","v":-5.3066273799885213}]
[null,null,"Year 4 benefit",null,null,null,null,{"$f":"$G$12*$H$8","v":20.593276724750122}]
[null,null,"Year 5 benefit"]
[null,null,"Total financing benefit",{"$f":"SUM(D13:D17)","v":0},{"$f":"SUM(E13:E17)","v":0.61228021531385102},{"$f":"SUM(F13:F17)","v":2.590971036463027},-2.8134698754068306,17.755594544047192]
[null,null,"Discount factor (end of year)",{"$f":"E19*(1+E$9)","v":1.2429013898581205},1.1755407763088943,{"$f":"G19*(1+G$9)","v":1.1134578099314802},{"$f":"H19*(1+H$9)","v":1.0676309893706446},1]
[null,null,"NPV underspend",{"$f":"D12*D19","v":19.629231128971984},{"$f":"E12*E19","v":64.147103162795219},{"$f":"F12*F19","v":-172.17518380070121},646.16927885691655,44.44165348714489]
[null,null,"NPV financing benefit",{"$f":"D18*D19","v":0},{"$f":"E18*E19","v":0.71976035962862139},{"$f":"F18*F19","v":2.8849369358560195},-3.0037476266450986,17.755594544047192]
[]
[null,null,"Regulatory period 2"]
[null,null,"Year",{"$f":"'Input | General'!$D$18","v":"2023-24"},{"$f":"'Input | General'!$E$18","v":"2024–25"},{"$f":"'Input | General'!$F$18","v":"2025–26"},{"$f":"'Input | General'!$G$18","v":"2026–27"},{"$f":"'Input | General'!$H$18","v":"2027–28"}]
[null,null,"Discount rate:",{"$f":"'Input | Inflation and Disc Rate'!L$22","v":4.7033574677312062E-2},{"$f":"'Input | Inflation and Disc Rate'!M$22","v":4.7033574677312062E-2},{"$f":"'Input | Inflation and Disc Rate'!N$22","v":4.7033574677312062E-2},{"$f":"'Input | Inflation and Disc Rate'!O$22","v":4.7033574677312062E-2},{"$f":"'Input | Inflation and Disc Rate'!P$22","v":4.7033574677312062E-2}]
[null,null,"Increase in forecast capex in regulatory period 2 attributable to capex deferred in regulatory period 1",{"$f":"'Input | Reported Capex'!H29","v":462.57000000000005},{"$f":"'Input | Reported Capex'!I29","v":78.26478886832453},{"$f":"'Input | Reported Capex'!J29","v":0},{"$f":"'Input | Reported Capex'!K29","v":0},{"$f":"'Input | Reported Capex'!L29","v":0}]
[null,null,"Discount factor (middle of year 5)",{"$f":"1/(1+D25)^(0.5)","v":0.97728154112535626},{"$f":"1/((1+E25)^(0.5)*(1+D25))","v":0.93338128285575461},{"$f":"1/((1+F25)^(0.5)*(1+E25)*(1+D25))","v":0.89145305884141857},{"$f":"1/((1+G25)^(0.5)*(1+F25)*(1+E25)*(1+D25))","v":0.85140828374692545},{"$f":"1/((1+H25)^(0.5)*(1+G25)*(1+F25)*(1+E25)*(1+D25))","v":0.81316235156004724}]
[null,null,"NPV of increase in forecast capex from deferred capex",{"$f":"D26*D27","v":452.06112247835608},{"$f":"E26*E27","v":73.050889036351535},0,0,{"$f":"H26*H27","v":0}]
[]
[null,null,"CESS calculation (post-adjustment)"]
[null,null,"Total underspend (NPV) adjusted for deferrals",{"$f":"SUM(D20:H20)-SUM(D28:H28)","v":77.100071320419829}]
[null,null,"Relevant sharing ratio",0.3]
[null,null,"Consumer share",{"$f":"(1-D32)*D31","v":53.970049924293875}]
[null,null,"NSP share",{"$f":"D32*D31","v":23.130021396125947}]
[null,null,"Total NSP financing benefit (NPV)",{"$f":"SUM(D21:H21)","v":18.356544212886735}]
[null,null,"NPV of CESS payments (post-adjustment)",{"$f":"D34-D35","v":4.773477183239212}]
[]
[null,"Calc | Total CESS Payments"]
[]
[null,null,null,{"$f":"'Input | General'!D18","v":"2023-24"},{"$f":"'Input | General'!E18","v":"2024–25"},{"$f":"'Input | General'!F18","v":"2025–26"},{"$f":"'Input | General'!G18","v":"2026–27"},{"$f":"'Input | General'!H18","v":"2027–28"}]
[null,null,"Discount factor",{"$f":"1/(1+'Input | Inflation and Disc Rate'!L21)","v":0.97752313152085013},{"$f":"D41/(1+'Input | Inflation and Disc Rate'!M21)","v":0.95555147265832929},{"$f":"E41/(1+'Input | Inflation and Disc Rate'!N21)","v":0.93407366788233004},{"$f":"F41/(1+'Input | Inflation and Disc Rate'!O21)","v":0.91307861689950176},{"$f":"G41/(1+'Input | Inflation and Disc Rate'!P21)","v":0.89255546891632753}]
[null,null,{"$f":"CONCATENATE(\"CESS Payment Per Year ($\", 'Output | Models'!$F$8,\" million)\")","v":"CESS Payment Per Year ($2022–23 million)"},{"$f":"D36/(SUM(D41:H41))","v":1.0215492222085034},{"$f":"D42","v":1.0215492222085034},{"$f":"E42","v":1.0215492222085034},1.0215492222085034,1.0215492222085034]
[]
[null,null,{"$f":"CONCATENATE(\"Total CESS Payment ($\", 'Output | Models'!$F$8,\" million)\")","v":"Total CESS Payment ($2022–23 million)"},{"$f":"SUM(D42:H42)","v":5.1077461110425171}]
[]
[]
[null,"End"]

{"sheet":"Output | Models","index":5,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,9,2,11],[2,13,2,19]]}
[null,{"$f":"'Input | General'!$B$1","v":"NSW TNSP 2023-28 Regulatory Proposal - Capital expenditure sharing scheme model"},null,null,null,null,null,null,null,null,"Key:","Input","Internal Link"]
[null,"Output | Models"]
[]
[null,"Inputs for Post Tax Revenue Model",null,null,null,null,null,null,null,"Note. The dollar base should be consistent with the post tax revenue model"]
[]
[null,null,"Revenue Adjustments","Source","Unit","Basis",null,null,null,{"$f":"'Calc | CESS Revenue Increments'!D40","v":"2023-24"},{"$f":"'Calc | CESS Revenue Increments'!E40","v":"2024–25"},{"$f":"'Calc | CESS Revenue Increments'!F40","v":"2025–26"},{"$f":"'Calc | CESS Revenue Increments'!G40","v":"2026–27"},{"$f":"'Calc | CESS Revenue Increments'!H40","v":"2027–28"},"Total"]
[]
[null,null,"CESS increments as per NER 6A.5.4(a)(5)","Calc | CESS Revenue Increments","$millions",{"$f":"IF(LEN(J6)>4,CONCATENATE(LEFT(J6,4)-1&\"–\"&IF(RIGHT(J6,2)=\"00\",\"99\",IF(RIGHT(J6,2)-1<10,\"0\",\"\")&RIGHT(J6,2)-1)),J6-1)","v":"2022–23"},null,null,null,{"$f":"'Calc | CESS Revenue Increments'!D42","v":1.0215492222085034},{"$f":"'Calc | CESS Revenue Increments'!E42","v":1.0215492222085034},{"$f":"'Calc | CESS Revenue Increments'!F42","v":1.0215492222085034},{"$f":"'Calc | CESS Revenue Increments'!G42","v":1.0215492222085034},{"$f":"'Calc | CESS Revenue Increments'!H42","v":1.0215492222085034},{"$f":"SUM(J8:N8)","v":5.1077461110425171}]
[]
[]
[null,"End"]