{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Change Log","Index","Input|Rate of return","Calc|RfR","Calc|Rate of return","Output|Rate of return","Lookup|Tables","Check|List"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":3221,"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":"Change Log","index":0,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,"Rate of Return Model"]
[null,"Change Log"]
[]
[null,"Model change log"]
[]
[null,null,"Starting model name ---->","JGN - Att 7.13M - Rate of return model - 20240628 - Public.xlsb"]
[]
[null,null,"Model changes to above model"]
[]
[null,null,"Model sheet","Reference","Cell reference","Type","Legend","Comments"]
[]
[null,null,"Input|Rate of return",1,"Q12:R13, Q19:R20","Input",null,"Updated FY24 CPI for actuals and FY25 CPI to align with Nov 2024 RBA MPS"]
[null,null,"Input|Rate of return",{"$f":"D12+1","v":2},"S26","Input",null,"Updated forecast to align with Nov 2024 RBA MPS"]
[null,null,"Input|Rate of return",{"$f":"D13+1","v":3},"J52:J56","Input",null,"Placeholder cost of debt observations updated to reflect more recent observations"]
[null,null,"Input|Rate of return",{"$f":"+D14+1","v":4},"J83","Input",null,"For consistency, updated to match PTRM value from AER Draft Decision"]
[]
[]
[null,null,"Model sheet","Reference","Cell reference","Type","Legend","Comments"]
[]
[null,null,"Calc|RfR",{"$f":"+D15+1","v":5},"All highlighted cells","Input",null,"Updated risk-free rate inputs for more recent bond series and observations"]
[]
[null,"End"]

{"sheet":"Index","index":1,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,2,0,4],[1,2,1,4]]}
[null,null,"JGN - Rate of Return Model",null,null,null,null,null,null,null,"Overall Check:",{"$f":"'Check|List'!$V$1","v":"OK"}]
[null,null,"Index"]
[]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Model Index"]
[]
[null,null,"Sheet Name","Sheet Description"]
[null,null,"Index","Model index with hyperlinks"]
[null,null,"Input|Rate of return","Data for forecast inflation and bond yield"]
[null,null,"Calc|RfR","Inputs and calculation for the placeholder risk free rate"]
[null,null,"Calc|Rate of return","Estimates the rate of return and forecast inflation expectation"]
[null,null,"Output|Rate of return","Summary of the rate of return and forecast inflation expectation"]
[null,null,"Lookup|Tables","Source for named ranges used for units, basis, etc"]
[null,null,"Check|List","Check for errors"]
[]
[null,"End"]

{"sheet":"Input|Rate of return","index":2,"n_rows":85,"n_cols":23,"rows_kept":85,"cut":false,"hidden":false,"merged":[[2,13,2,17],[0,2,0,4],[1,2,1,4],[2,8,2,12],[2,18,2,22]]}
[null,null,{"$f":"Index!$C$1","v":"JGN - Rate of Return Model"},null,null,"Back to Index",null,"Key:","Input (hard code)","External Link","Internal Link","Drop down Selection","Calculation","Unique calculation","Empty cell","JGN RP",null,"Section Check:",{"$f":"IF(COUNTA($A$8:$A$85)=COUNTIF($A$8:$A$85,\"OK\"),\"OK\",\"Check\")","v":"OK"},null,"Overall Check:",{"$f":"'Check|List'!$V$1","v":"OK"}]
[null,null,{"$f":"RIGHT(CELL(\"filename\",C1),LEN(CELL(\"filename\",C1))-FIND(\"]\",CELL(\"filename\",C1)))","v":"Input|Rate of return"}]
[null,null,null,null,null,null,null,null,"Prior",null,null,null,null,"Current Regulatory Period",null,null,null,null,"Next Regulatory Period"]
[null,null,null,"Source","Unit","Basis",null,{"$f":"+I4-1","v":2015},{"$f":"+J4-1","v":2016},{"$f":"+K4-1","v":2017},{"$f":"+L4-1","v":2018},{"$f":"+M4-1","v":2019},2020,{"$f":"+M4+1","v":2021},{"$f":"+N4+1","v":2022},2023,2024,2025,2026,2027,2028,2029,2030]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Input | Inflation"]
[]
[null,null,"Opex Inflation (year to Jun, no lag)","Source","Unit","Basis",null,{"$f":"\"RY\"&RIGHT(H$4,2)","v":"RY15"},"RY16","RY17","RY18","RY19","RY20","RY21","RY22","RY23","RY24","RY25"]
[]
[null,null,"Actual inflation","ABS","Per cent","n/a",null,null,1.0232558139534831E-2,1.9337016574585641E-2,2.0776874435411097E-2,1.5929203539823078E-2,-3.4843205574912606E-3,3.8461538461538325E-2,6.1447811447811418E-2,6.0269627279936566E-2,3.8145100972326373E-2]
[null,null,"Forecast inflation","Placeholder","Per cent","n/a",null,null,null,null,null,null,null,null,null,null,null,2.5000000000000001E-2]
[]
[{"$f":"IF(SUM(M15:AB15)=0,\"Ok\",\"Check\")","v":"Ok"},null,"Check: Only one active input per period",null,null,null,null,null,{"$f":"+IF(OR(COUNTBLANK(I12:I13)=2,COUNTBLANK(I12:I13)=1),0,1)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,"Capex Inflation (year to Dec, no lag)","Source","Unit","Basis",null,{"$f":"\"RY\"&RIGHT(H$4,2)","v":"RY15"},"RY16","RY17","RY18","RY19","RY20","RY21","RY22","RY23","RY24","RY25"]
[]
[null,null,"Actual inflation","ABS","Per cent","n/a",null,1.7175572519083859E-2,1.6885553470919357E-2,1.4760147601476037E-2,1.9090909090909047E-2,1.7841213202497874E-2,1.8404907975460238E-2,8.6058519793459354E-3,3.4982935153583528E-2,7.8318219291014124E-2,4.0519877675840865E-2]
[null,null,"Forecast inflation (Jun end from RY26)","Placeholder","Per cent","n/a",null,null,null,null,null,null,null,null,null,null,null,2.5999999999999999E-2]
[]
[{"$f":"IF(SUM(M22:AB22)=0,\"Ok\",\"Check\")","v":"Ok"},null,"Check: Only one active input per period",null,null,null,null,{"$f":"+IF(OR(COUNTBLANK(H19:H20)=2,COUNTBLANK(H19:H20)=1),0,1)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"PTRM Forecast Inflation (year to June, no lag)","Source","Unit","Basis",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"RY\"&RIGHT(S$4,2)","v":"RY26"},{"$f":"\"RY\"&RIGHT(T$4,2)","v":"RY27"},{"$f":"\"RY\"&RIGHT(U$4,2)","v":"RY28"},{"$f":"\"RY\"&RIGHT(V$4,2)","v":"RY29"},{"$f":"\"RY\"&RIGHT(W$4,2)","v":"RY30"}]
[]
[null,null,"Forecast inflation (Jun end from RY26)","RBA","Per cent","n/a",null,null,null,null,null,null,null,null,null,null,null,null,3.1E-2,{"$f":"S26+(($W26-S26)/(5-COUNTA($S26:S26)))","v":2.9499999999999998E-2},{"$f":"T26+(($W26-T26)/(5-COUNTA($S26:T26)))","v":2.8000000000000001E-2},{"$f":"U26+(($W26-U26)/(5-COUNTA($S26:U26)))","v":2.6500000000000003E-2},2.5000000000000001E-2]
[]
[null,null,"Source (actuals): ABS, all groups CPI inflation series A2325846C, weighted average for the eight capital cities. "]
[null,null,"Source (forecasts): Placeholder"]
[]
[null,"Input | Placeholder risk-free rate"]
[]
[null,null,"Item","Source","Unit","Basis",null,null,null,"Parameter"]
[]
[null,null,"Placeholder risk-free rate","Placeholder","Per cent","n/a",null,null,null,{"$f":"'Calc|RfR'!Q40","v":4.5635167097263209E-2}]
[]
[null,"Input | Annual return on debt observations"]
[]
[null,null,"Yields by date (annualised)","Source","Unit","Basis",null,null,null,"Parameter"]
[]
[null,null,"Return on debt observations"]
[{"$f":"IF(OR(ISERROR(J42),ISNUMBER(J42)),\"Ok\",\"Check\")","v":"Ok"},null,2016,"AER","Per cent","Nominal",null,null,null,4.2735624825770813E-2]
[{"$f":"IF(OR(ISERROR(J43),ISNUMBER(J43)),\"Ok\",\"Check\")","v":"Ok"},null,{"$f":"+C42+1","v":2017},"AER","Per cent","Nominal",null,null,null,5.422642326395756E-2]
[{"$f":"IF(OR(ISERROR(J44),ISNUMBER(J44)),\"Ok\",\"Check\")","v":"Ok"},null,{"$f":"+C43+1","v":2018},"AER","Per cent","Nominal",null,null,null,5.0687061901486696E-2]
[{"$f":"IF(OR(ISERROR(J45),ISNUMBER(J45)),\"Ok\",\"Check\")","v":"Ok"},null,{"$f":"+C44+1","v":2019},"AER","Per cent","Nominal",null,null,null,4.5733962345167502E-2]
[{"$f":"IF(OR(ISERROR(J46),ISNUMBER(J46)),\"Ok\",\"Check\")","v":"Ok"},null,{"$f":"+C45+1","v":2020},"AER","Per cent","Nominal",null,null,null,4.52009852763465E-2]
[{"$f":"IF(OR(ISERROR(J47),ISNUMBER(J47)),\"Ok\",\"Check\")","v":"Ok"},null,{"$f":"TRANSPOSE(N4:W4)","v":2021},"AER","Per cent","Nominal",null,null,null,2.5611204276113811E-2]
["Ok",null,2022,"AER","Per cent","Nominal",null,null,null,2.22842697332436E-2]
["Ok",null,2023,"AER","Per cent","Nominal",null,null,null,3.86082146457623E-2]
["Ok",null,2024,"AER","Per cent","Nominal",null,null,null,6.2438377714279999E-2]
["Ok",null,2025,"AER","Per cent","Nominal",null,null,null,5.8338789850762497E-2]
["Ok",null,2026,"Placeholder","Per cent","Nominal",null,null,null,5.9499999999999997E-2]
["Ok",null,2027,"Placeholder","Per cent","Nominal",null,null,null,5.2491102626821724E-2]
["Ok",null,2028,"Placeholder","Per cent","Nominal",null,null,null,{"$f":"+J53","v":5.2491102626821724E-2}]
["Ok",null,2029,"Placeholder","Per cent","Nominal",null,null,null,{"$f":"+J54","v":5.2491102626821724E-2}]
["Ok",null,2030,"Placeholder","Per cent","Nominal",null,null,null,{"$f":"+J55","v":5.2491102626821724E-2}]
[]
[null,null,"Weights used in return on debt transition"]
[null,null,"New observations","AER","Per cent","Nominal",null,null,null,0.1,"<- This is the weight applied to each new observation"]
[null,null,"Initial observation","AER","Per cent","Nominal",null,null,null,1]
[]
[null,"Input | Return on equity"]
[]
[null,null,"Parameters","Source","Unit","Basis",null,null,null,"Parameter"]
[]
[{"$f":"IF(ISERROR(J66),\"Check\",\"Ok\")","v":"Ok"},null,"Market risk premium","AER","Per cent","n/a",null,null,null,6.2E-2]
[{"$f":"IF(ISERROR(J67),\"Check\",\"Ok\")","v":"Ok"},null,"Equity beta","AER","Per cent","n/a",null,null,null,0.6]
[]
[null,"Input | Other parameters"]
[]
[null,null,"Rate of return","Source","Unit","Basis",null,null,null,"Parameter"]
[]
[{"$f":"IF(ISERROR(J73),\"Check\",\"Ok\")","v":"Ok"},null,"Leverage ratio","AER","Per cent","n/a",null,null,null,0.6]
[{"$f":"IF(ISERROR(J74),\"Check\",\"Ok\")","v":"Ok"},null,"Gamma","AER","Per cent","n/a",null,null,null,0.56999999999999995]
[{"$f":"IF(ISERROR(J75),\"Check\",\"Ok\")","v":"Ok"},null,"Tax rate","ATO","Per cent","n/a",null,null,null,0.3]
[]
[null,null,"Debt and equity raising costs"]
[]
[{"$f":"IF(ISERROR(J79),\"Check\",\"Ok\")","v":"Ok"},null,"Dividend / imputation payout ratio","AER","Per cent","n/a",null,null,null,0.878670689]
[{"$f":"IF(ISERROR(J80),\"Check\",\"Ok\")","v":"Ok"},null,"Benchmark SEO raising cost","AER","Per cent","n/a",null,null,null,0.03]
[{"$f":"IF(ISERROR(J81),\"Check\",\"Ok\")","v":"Ok"},null,"Benchmark DRP cost","AER","Per cent","n/a",null,null,null,0.01]
[{"$f":"IF(ISERROR(J82),\"Check\",\"Ok\")","v":"Ok"},null,"Benchmark DRP takeup","AER","Per cent","n/a",null,null,null,0.3]
[{"$f":"IF(ISERROR(J83),\"Check\",\"Ok\")","v":"Ok"},null,"Debt raising costs","AER","Per cent","n/a",null,null,null,8.4082594037438818E-4,"<- Updated from AER DD"]
[]
[null,"End"]

{"sheet":"Calc|RfR","index":3,"n_rows":42,"n_cols":27,"rows_kept":42,"cut":false,"hidden":false,"merged":[[2,17,2,21],[2,22,2,26],[9,7,9,9],[9,10,9,12],[0,2,0,4],[1,2,1,4],[2,11,2,16]]}
[null,null,{"$f":"Index!$C$1","v":"JGN - Rate of Return Model"},null,null,"Back to Index",null,null,null,null,null,"Key:","Input (hard code)","External Link","Internal Link","Drop down Selection","Calculation","Unique calculation","Empty cell","JGN RP",null,"Section Check:",{"$f":"IF(COUNTA($A$8:$A$42)=COUNTIF($A$8:$A$42,\"OK\"),\"OK\",\"Check\")","v":"OK"},null,"Overall Check:",{"$f":"'Check|List'!$V$1","v":"OK"}]
[null,null,{"$f":"RIGHT(CELL(\"filename\",C1),LEN(CELL(\"filename\",C1))-FIND(\"]\",CELL(\"filename\",C1)))","v":"Calc|RfR"}]
[null,null,null,null,null,null,null,null,null,null,null,"Prior",null,null,null,null,null,"Current Regulatory Period",null,null,null,null,"Next Regulatory Period"]
[null,null,null,"Source","Unit","Basis",null,null,null,null,null,{"$f":"+M4-1","v":2015},{"$f":"+N4-1","v":2016},{"$f":"+O4-1","v":2017},{"$f":"+P4-1","v":2018},{"$f":"+Q4-1","v":2019},{"$f":"+'Input|Rate of return'!$M$4","v":2020},{"$f":"Q4+1","v":2021},{"$f":"R4+1","v":2022},2023,2024,2025,2026,2027,2028,2029,2030]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Calc | Risk-free rate"]
[]
[null,null,null,null,null,null,null,"170 (RBA F16)",null,null,"168 (RBA F16)",null,null,null,null,"Interpolation"]
[null,null,"Yields on government bonds",{"$f":"+D$4","v":"Source"},{"$f":"+E$4","v":"Unit"},{"$f":"+F$4","v":"Basis"},null,"Date","Yield","Weight","Date","Yield","Weight",null,"Date","Yield","Annualised"]
[]
[null,null,"2024-11-01","RBA",{"$f":"+Percent","v":"Per cent"},{"$f":"+Nominal","v":"Nominal"},null,"2034-06-21",4.5159999999999999E-2,{"$f":"+_xlfn.LET(\n_xlpm.futureday,O13,\n_xlpm.maturitydate_1,H13,\n_xlpm.maturitydate_2,K13,\nIF(_xlpm.futureday>=_xlpm.maturitydate_2,0,1-(_xlpm.futureday-_xlpm.maturitydate_1)/(_xlpm.maturitydate_2-_xlpm.maturitydate_1)))","v":0.27322404371584696},"2034-12-21",4.5370000000000001E-2,{"$f":"1-J13","v":0.72677595628415304},null,{"$f":"+DATE(YEAR(C13)+10,MONTH(C13),DAY(C13))","v":"2034-11-01"},{"$f":"+I13*J13+L13*M13","v":4.531262295081967E-2},{"$f":"+(1+P13/2)^2-1","v":4.5825931400490738E-2}]
[null,null,"2024-11-04","RBA","Per cent","Nominal",null,{"$f":"+H13","v":"2034-06-21"},4.5359999999999998E-2,0.25683060109289613,{"$f":"+K13","v":"2034-12-21"},4.5570000000000006E-2,0.74316939890710387,null,"2034-11-04",4.5516065573770491E-2,4.6033993630099523E-2]
[null,null,"2024-11-05","RBA","Per cent","Nominal",null,{"$f":"+H14","v":"2034-06-21"},4.5410000000000006E-2,0.25136612021857918,{"$f":"+K14","v":"2034-12-21"},4.5609999999999998E-2,0.74863387978142082,null,"2034-11-05",4.5559726775956287E-2,4.6078648951931145E-2]
[null,null,"2024-11-06","RBA","Per cent","Nominal",null,"2034-06-21",4.6029999999999995E-2,0.24590163934426235,"2034-12-21",4.6260000000000003E-2,0.75409836065573765,null,"2034-11-06",4.6203442622950827E-2,4.6737132150504124E-2]
[null,null,"2024-11-07","RBA","Per cent","Nominal",null,"2034-06-21",4.6130000000000004E-2,0.2404371584699454,"2034-12-21",4.6349999999999995E-2,0.7595628415300546,null,"2034-11-07",4.6297103825136611E-2,4.6832959280785458E-2]
[null,null,"2024-11-08","RBA","Per cent","Nominal",null,"2034-06-21",4.5530000000000001E-2,0.23497267759562845,"2034-12-21",4.5759999999999995E-2,0.76502732240437155,null,"2034-11-08",4.5705956284152999E-2,4.6228214894115327E-2]
[null,null,"2024-11-11","RBA","Per cent","Nominal",null,"2034-06-21",4.5540000000000004E-2,0.21857923497267762,"2034-12-21",4.5759999999999995E-2,0.78142076502732238,null,"2034-11-11",4.5711912568306007E-2,4.6234307305969224E-2]
[null,null,"2024-11-12","RBA","Per cent","Nominal",null,"2034-06-21",4.5400000000000003E-2,0.21311475409836067,"2034-12-21",4.5609999999999998E-2,0.78688524590163933,null,"2034-11-12",4.5565245901639344E-2,4.6084293810158661E-2]
[null,null,"2024-11-13","RBA","Per cent","Nominal",null,"2034-06-21",4.6440000000000002E-2,0.20765027322404372,"2034-12-21",4.6649999999999997E-2,0.79234972677595628,null,"2034-11-13",4.6606393442622948E-2,4.7149432420055204E-2]
[null,null,"2024-11-14","RBA","Per cent","Nominal",null,"2034-06-21",4.6740000000000004E-2,0.20218579234972678,"2034-12-21",4.6950000000000006E-2,0.79781420765027322,null,"2034-11-14",4.6907540983606562E-2,4.7457620333888562E-2]
[null,null,"2024-11-15","RBA","Per cent","Nominal",null,"2034-06-21",4.6130000000000004E-2,0.19672131147540983,"2034-12-21",4.6349999999999995E-2,0.80327868852459017,null,"2034-11-15",4.630672131147541E-2,4.684279942113001E-2]
[null,null,"2024-11-18","RBA","Per cent","Nominal",null,"2034-06-21",4.5780000000000001E-2,0.18032786885245899,"2034-12-21",4.6010000000000002E-2,0.81967213114754101,null,"2034-11-18",4.5968524590163942E-2,4.6496800903413016E-2]
[null,null,"2024-11-19","RBA","Per cent","Nominal",null,"2034-06-21",4.5380000000000004E-2,0.17486338797814205,"2034-12-21",4.5620000000000001E-2,0.82513661202185795,null,"2034-11-19",4.5578032786885249E-2,4.60973720550657E-2]
[null,null,"2024-11-20","RBA","Per cent","Nominal",null,"2034-06-21",4.5339999999999998E-2,0.1693989071038251,"2034-12-21",4.5560000000000003E-2,0.8306010928961749,null,"2034-11-20",4.552273224043716E-2,4.6040812028095957E-2]
[null,null,"2024-11-21","RBA","Per cent","Nominal",null,"2034-06-21",4.5540000000000004E-2,0.16393442622950816,"2034-12-21",4.5769999999999998E-2,0.83606557377049184,null,"2034-11-21",4.5732295081967217E-2,4.6255155785333457E-2]
[null,null,"2024-11-22","RBA","Per cent","Nominal",null,"2034-06-21",4.5190000000000001E-2,0.15846994535519121,"2034-12-21",4.5419999999999995E-2,0.84153005464480879,null,"2034-11-22",4.5383551912568307E-2,4.589846860861857E-2]
[null,null,"2024-11-25","RBA","Per cent","Nominal",null,"2034-06-21",4.4580000000000002E-2,0.14207650273224048,"2034-12-21",4.4829999999999995E-2,0.85792349726775952,null,"2034-11-25",4.4794480874316936E-2,4.5296117253516677E-2]
[null,null,"2024-11-26","RBA","Per cent","Nominal",null,"2034-06-21",4.4189999999999993E-2,0.13661202185792354,"2034-12-21",4.444E-2,0.86338797814207646,null,"2034-11-26",4.4405846994535515E-2,4.4898816806361097E-2]
[null,null,"2024-11-27","RBA","Per cent","Nominal",null,"2034-06-21",4.3890000000000005E-2,0.13114754098360659,"2034-12-21",4.4150000000000002E-2,0.86885245901639341,null,"2034-11-27",4.4115901639344264E-2,4.4602454833707172E-2]
[null,null,"2024-11-28","RBA","Per cent","Nominal",null,"2034-06-21",4.3339999999999997E-2,{"$f":"+_xlfn.LET(\n_xlpm.futureday,O32,\n_xlpm.maturitydate_1,H32,\n_xlpm.maturitydate_2,K32,\nIF(_xlpm.futureday>=_xlpm.maturitydate_2,0,1-(_xlpm.futureday-_xlpm.maturitydate_1)/(_xlpm.maturitydate_2-_xlpm.maturitydate_1)))","v":0.12568306010928965},"2034-12-21",4.3589999999999997E-2,0.87431693989071035,null,"2034-11-28",4.3558579234972673E-2,4.4032916691215229E-2]
[null,null,"2024-11-29","RBA","Per cent","Nominal",null,{"$f":"+H32","v":"2034-06-21"},4.3120000000000006E-2,{"$f":"+_xlfn.LET(\n_xlpm.futureday,O33,\n_xlpm.maturitydate_1,H33,\n_xlpm.maturitydate_2,K33,\nIF(_xlpm.futureday>=_xlpm.maturitydate_2,0,1-(_xlpm.futureday-_xlpm.maturitydate_1)/(_xlpm.maturitydate_2-_xlpm.maturitydate_1)))","v":0.1202185792349727},{"$f":"+K32","v":"2034-12-21"},4.3380000000000002E-2,{"$f":"1-J33","v":0.8797814207650273},null,{"$f":"+DATE(YEAR(C33)+10,MONTH(C33),DAY(C33))","v":"2034-11-29"},{"$f":"+I33*J33+L33*M33","v":4.3348743169398907E-2},{"$f":"+(1+P33/2)^2-1","v":4.3818521552990486E-2}]
[null,null,"2024-12-02","RBA","Per cent","Nominal",null,{"$f":"+H33","v":"2034-06-21"},4.308E-2,{"$f":"+_xlfn.LET(\n_xlpm.futureday,O34,\n_xlpm.maturitydate_1,H34,\n_xlpm.maturitydate_2,K34,\nIF(_xlpm.futureday>=_xlpm.maturitydate_2,0,1-(_xlpm.futureday-_xlpm.maturitydate_1)/(_xlpm.maturitydate_2-_xlpm.maturitydate_1)))","v":0.10382513661202186},{"$f":"+K33","v":"2034-12-21"},4.333E-2,{"$f":"1-J34","v":0.89617486338797814},null,{"$f":"+DATE(YEAR(C34)+10,MONTH(C34),DAY(C34))","v":"2034-12-02"},{"$f":"+I34*J34+L34*M34","v":4.3304043715847E-2},{"$f":"+(1+P34/2)^2-1","v":4.3772853766382847E-2}]
[null,null,"2024-12-03","RBA","Per cent","Nominal",null,{"$f":"+H34","v":"2034-06-21"},4.2779999999999999E-2,{"$f":"+_xlfn.LET(\n_xlpm.futureday,O35,\n_xlpm.maturitydate_1,H35,\n_xlpm.maturitydate_2,K35,\nIF(_xlpm.futureday>=_xlpm.maturitydate_2,0,1-(_xlpm.futureday-_xlpm.maturitydate_1)/(_xlpm.maturitydate_2-_xlpm.maturitydate_1)))","v":9.8360655737704916E-2},{"$f":"+K34","v":"2034-12-21"},4.3029999999999999E-2,{"$f":"1-J35","v":0.90163934426229508},null,{"$f":"+DATE(YEAR(C35)+10,MONTH(C35),DAY(C35))","v":"2034-12-03"},{"$f":"+I35*J35+L35*M35","v":4.3005409836065572E-2},{"$f":"+(1+P35/2)^2-1","v":4.3467776154857418E-2}]
[null,null,"2024-12-04","RBA","Per cent","Nominal",null,{"$f":"+H35","v":"2034-06-21"},4.2380000000000001E-2,{"$f":"+_xlfn.LET(\n_xlpm.futureday,O36,\n_xlpm.maturitydate_1,H36,\n_xlpm.maturitydate_2,K36,\nIF(_xlpm.futureday>=_xlpm.maturitydate_2,0,1-(_xlpm.futureday-_xlpm.maturitydate_1)/(_xlpm.maturitydate_2-_xlpm.maturitydate_1)))","v":9.289617486338797E-2},{"$f":"+K35","v":"2034-12-21"},4.2630000000000001E-2,{"$f":"1-J36","v":0.90710382513661203},null,{"$f":"+DATE(YEAR(C36)+10,MONTH(C36),DAY(C36))","v":"2034-12-04"},{"$f":"+I36*J36+L36*M36","v":4.2606775956284156E-2},{"$f":"+(1+P36/2)^2-1","v":4.3060610295631463E-2}]
[]
[null,null,"Item",{"$f":"+D11","v":"Source"},{"$f":"+E11","v":"Unit"},{"$f":"+F11","v":"Basis"},null,null,null,null,null,null,null,null,null,null,"Rf Estimate"]
[]
[{"$f":"+IF(ISERROR(Q40),\"Check\",\"Ok\")","v":"Ok"},null,"Risk-free rate placeholder","Calculated","Per cent","Nominal",null,null,null,null,null,null,null,null,null,null,{"$f":"+AVERAGE(Q13:Q36)","v":4.5635167097263209E-2}]
[]
[null,"End"]

{"sheet":"Calc|Rate of return","index":4,"n_rows":40,"n_cols":28,"rows_kept":40,"cut":false,"hidden":false,"merged":[[2,11,2,16],[0,2,0,4],[1,2,1,4],[2,17,2,21],[2,22,2,26]]}
[null,null,{"$f":"Index!$C$1","v":"JGN - Rate of Return Model"},null,null,"Back to Index",null,null,null,null,null,"Key:","Input (hard code)","External Link","Internal Link","Drop down Selection","Calculation","Unique calculation","Empty cell",null,null,"Section Check:",{"$f":"IF(COUNTA($A$8:$A$40)=COUNTIF($A$8:$A$40,\"OK\"),\"OK\",\"Check\")","v":"OK"},null,"Overall Check:",{"$f":"'Check|List'!$V$1","v":"OK"}]
[null,null,{"$f":"RIGHT(CELL(\"filename\",C1),LEN(CELL(\"filename\",C1))-FIND(\"]\",CELL(\"filename\",C1)))","v":"Calc|Rate of return"}]
[null,null,null,null,null,null,null,null,null,null,null,"Prior",null,null,null,null,null,"Current Regulatory Period",null,null,null,null,"Next Regulatory Period"]
[null,null,null,"Source","Unit","Basis",null,null,null,null,null,{"$f":"+M4-1","v":2015},{"$f":"+N4-1","v":2016},{"$f":"+O4-1","v":2017},{"$f":"+P4-1","v":2018},{"$f":"+Q4-1","v":2019},{"$f":"+'Input|Rate of return'!$M$4","v":2020},{"$f":"Q4+1","v":2021},{"$f":"R4+1","v":2022},2023,2024,2025,2026,2027,2028,2029,2030]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Calc | Forecast Inflation"]
[]
[null,null,"Inflation",{"$f":"+D$4","v":"Source"},{"$f":"+E$4","v":"Unit"},{"$f":"+F$4","v":"Basis"},null,null,null,null,null,{"$f":"+\"FY\"&RIGHT(L$4,2)","v":"FY15"},"FY16","FY17","FY18","FY19","FY20","FY21","FY22","FY23","FY24","FY25","FY26","FY27","FY28","FY29","FY30"]
[]
[null,null,"Expected inflation - Glide Path","Input|Rate of Return","Per cent","n/a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(1+'Input|Rate of return'!S26:W26)^(1/COUNT('Input|Rate of return'!S26:W26))-1","v":2.7997811278454687E-2},{"$f":"+W12","v":2.7997811278454687E-2},{"$f":"+X12","v":2.7997811278454687E-2},{"$f":"+Y12","v":2.7997811278454687E-2},{"$f":"+Z12","v":2.7997811278454687E-2}]
[null,null,"Inflation (Capex)","Input|Rate of Return","Per cent","n/a",null,null,null,null,null,{"$f":"+'Input|Rate of return'!H19","v":1.7175572519083859E-2},{"$f":"+'Input|Rate of return'!I19","v":1.6885553470919357E-2},{"$f":"+'Input|Rate of return'!J19","v":1.4760147601476037E-2},{"$f":"+'Input|Rate of return'!K19","v":1.9090909090909047E-2},{"$f":"+'Input|Rate of return'!L19","v":1.7841213202497874E-2},{"$f":"+'Input|Rate of return'!M19","v":1.8404907975460238E-2},{"$f":"+'Input|Rate of return'!N19","v":8.6058519793459354E-3},{"$f":"+'Input|Rate of return'!O19","v":3.4982935153583528E-2},{"$f":"+'Input|Rate of return'!P19","v":7.8318219291014124E-2},4.0519877675840865E-2,2.5999999999999999E-2,{"$f":"+W12","v":2.7997811278454687E-2},{"$f":"+X12","v":2.7997811278454687E-2},{"$f":"+Y12","v":2.7997811278454687E-2},{"$f":"+Z12","v":2.7997811278454687E-2},{"$f":"+AA12","v":2.7997811278454687E-2}]
[null,null,"Inflation (Opex)","Input|Rate of Return","Per cent","n/a",null,null,null,null,null,null,{"$f":"+SUM('Input|Rate of return'!I12:I13)","v":1.0232558139534831E-2},{"$f":"+SUM('Input|Rate of return'!J12:J13)","v":1.9337016574585641E-2},{"$f":"+SUM('Input|Rate of return'!K12:K13)","v":2.0776874435411097E-2},{"$f":"+SUM('Input|Rate of return'!L12:L13)","v":1.5929203539823078E-2},{"$f":"+SUM('Input|Rate of return'!M12:M13)","v":-3.4843205574912606E-3},{"$f":"+SUM('Input|Rate of return'!N12:N13)","v":3.8461538461538325E-2},{"$f":"+SUM('Input|Rate of return'!O12:O13)","v":6.1447811447811418E-2},{"$f":"+SUM('Input|Rate of return'!P12:P13)","v":6.0269627279936566E-2},3.8145100972326373E-2,2.5000000000000001E-2,{"$f":"+W$13","v":2.7997811278454687E-2},{"$f":"+X$13","v":2.7997811278454687E-2},{"$f":"+Y$13","v":2.7997811278454687E-2},{"$f":"+Z$13","v":2.7997811278454687E-2},{"$f":"+AA$13","v":2.7997811278454687E-2}]
[]
[null,"Calc | Return on debt"]
[]
[null,null,"Estimates","Source","Unit","Basis",null,null,null,null,null,null,{"$f":"M$4","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[]
[null,null,"Observations"]
[null,null,"Annual observations","Input|Rate of return","Per cent","Nominal",null,null,null,null,null,null,{"$f":"+TRANSPOSE('Input|Rate of return'!$J$42:$J$56)","v":4.2735624825770813E-2},5.422642326395756E-2,5.0687061901486696E-2,4.5733962345167502E-2,4.52009852763465E-2,2.5611204276113811E-2,2.22842697332436E-2,3.86082146457623E-2,6.2438377714279999E-2,5.8338789850762497E-2,5.9499999999999997E-2,5.2491102626821724E-2,5.2491102626821724E-2,5.2491102626821724E-2,5.2491102626821724E-2]
[]
[null,null,"Weights"]
[null,null,"New observation","Input|Rate of return","Per cent","n/a",null,null,null,null,null,null,{"$f":"IF(ISNUMBER(M$21),Weight_New,NA())","v":0.1},0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1]
[null,null,{"$f":"M18&\" observation\"","v":"2016 observation"},"Input|Rate of return","Per cent","n/a",null,null,null,null,null,null,{"$f":"IF(ISNUMBER(M$21),MAX(Weight_Initial-SUM($M24:M24),0),NA())","v":0.9},{"$f":"IF(ISNUMBER(N$21),MAX(Weight_Initial-SUM($M24:N24),0),NA())","v":0.8},{"$f":"IF(ISNUMBER(O$21),MAX(Weight_Initial-SUM($M24:O24),0),NA())","v":0.7},{"$f":"IF(ISNUMBER(P$21),MAX(Weight_Initial-SUM($M24:P24),0),NA())","v":0.6},{"$f":"IF(ISNUMBER(Q$21),MAX(Weight_Initial-SUM($M24:Q24),0),NA())","v":0.5},{"$f":"IF(ISNUMBER(R$21),MAX(Weight_Initial-SUM($M24:R24),0),NA())","v":0.4},{"$f":"IF(ISNUMBER(S$21),MAX(Weight_Initial-SUM($M24:S24),0),NA())","v":0.30000000000000004},{"$f":"IF(ISNUMBER(T$21),MAX(Weight_Initial-SUM($M24:T24),0),NA())","v":0.20000000000000007},{"$f":"IF(ISNUMBER(U$21),MAX(Weight_Initial-SUM($M24:U24),0),NA())","v":0.10000000000000009},{"$f":"IF(ISNUMBER(V$21),MAX(Weight_Initial-SUM($M24:V24),0),NA())","v":1.1102230246251565E-16},{"$f":"IF(ISNUMBER(W$21),MAX(Weight_Initial-SUM($M24:W24),0),NA())","v":0},{"$f":"IF(ISNUMBER(X$21),MAX(Weight_Initial-SUM($M24:X24),0),NA())","v":0},{"$f":"IF(ISNUMBER(Y$21),MAX(Weight_Initial-SUM($M24:Y24),0),NA())","v":0},{"$f":"IF(ISNUMBER(Z$21),MAX(Weight_Initial-SUM($M24:Z24),0),NA())","v":0},{"$f":"IF(ISNUMBER(AA$21),MAX(Weight_Initial-SUM($M24:AA24),0),NA())","v":0}]
[]
[]
[{"$f":"IF(ISERROR(AA28),\"Check\",\"Ok\")","v":"Ok"},null,"Return on debt (pre-tax)","Calculated","Per cent","Nominal",null,null,null,null,null,null,{"$f":"IFERROR($M21*M25+SUMPRODUCT($M21:M21,$M24:M24),G28)","v":4.273562482577082E-2},{"$f":"IFERROR($M21*N25+SUMPRODUCT($M21:N21,$M24:N24),M28)","v":4.3884704669589492E-2},{"$f":"IFERROR($M21*O25+SUMPRODUCT($M21:O21,$M24:O24),N28)","v":4.4679848377161074E-2},{"$f":"IFERROR($M21*P25+SUMPRODUCT($M21:P21,$M24:P24),O28)","v":4.4979682129100744E-2},{"$f":"IFERROR($M21*Q25+SUMPRODUCT($M21:Q21,$M24:Q24),P28)","v":4.5226218174158311E-2},{"$f":"IFERROR($M21*R25+SUMPRODUCT($M21:R21,$M24:R24),Q28)","v":4.3513776119192618E-2},{"$f":"IFERROR($M21*S25+SUMPRODUCT($M21:S21,$M24:S24),R28)","v":4.1468640609939891E-2},{"$f":"IFERROR($M21*T25+SUMPRODUCT($M21:T21,$M24:T24),S28)","v":4.1055899591939046E-2},{"$f":"IFERROR($M21*U25+SUMPRODUCT($M21:U21,$M24:U24),T28)","v":4.3026174880789962E-2},{"$f":"IFERROR($M21*V25+SUMPRODUCT($M21:V21,$M24:V24),U28)","v":4.4586491383289135E-2},{"$f":"IFERROR(SUMPRODUCT(N21:W21,N24:W24),V28)","v":4.6262928900712055E-2},{"$f":"IFERROR(SUMPRODUCT(O21:X21,O24:X24),W28)","v":4.6089396836998461E-2},{"$f":"IFERROR(SUMPRODUCT(P21:Y21,P24:Y24),X28)","v":4.6269800909531963E-2},{"$f":"IFERROR(SUMPRODUCT(Q21:Z21,Q24:Z24),Y28)","v":4.6945514937697386E-2},{"$f":"IFERROR(SUMPRODUCT(R21:AA21,R24:AA24),Z28)","v":4.767452667274491E-2},"<- Return on debt estimated using a 10-year transition from 2016"]
[]
[null,"Calc | Return on equity"]
[]
[null,null,"Estimates","Source","Unit","Basis",null,null,null,null,null,null,null,null,"Returns"]
[]
[null,null,"Risk-free rate","Input|Rate of return","Per cent","Nominal",null,null,null,null,null,null,null,null,{"$f":"+'Calc|RfR'!Q40","v":4.5635167097263209E-2}]
[null,null,"Market risk premium","Input|Rate of return","Per cent","Nominal",null,null,null,null,null,null,null,null,{"$f":"+MRP","v":6.2E-2}]
[null,null,"Equity beta","Input|Rate of return","Per cent","Nominal",null,null,null,null,null,null,null,null,{"$f":"+Equity_Beta","v":0.6}]
[]
[{"$f":"IF(ISERROR(O38),\"Check\",\"Ok\")","v":"Ok"},null,"Return on equity (post-tax) estimate","Calculated","Per cent","Nominal",null,null,null,null,null,null,null,null,{"$f":"O34+O35*O36","v":8.2835167097263213E-2}]
[]
[null,"End"]

{"sheet":"Output|Rate of return","index":5,"n_rows":43,"n_cols":25,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,2,0,4],[1,2,1,4],[2,20,2,24],[2,15,2,19],[2,9,2,14]]}
[null,null,{"$f":"Index!$C$1","v":"JGN - Rate of Return Model"},null,null,"Back to Index",null,null,null,"Key:","Input (hard code)","External Link","Internal Link","Drop down Selection","Calculation","Unique calculation","Empty cell",null,"Section Check:",{"$f":"IF(COUNTA($A$8:$A$43)=COUNTIF($A$8:$A$43,\"OK\"),\"OK\",\"Check\")","v":"OK"},null,"Overall Check:",{"$f":"'Check|List'!$V$1","v":"OK"}]
[null,null,{"$f":"RIGHT(CELL(\"filename\",C1),LEN(CELL(\"filename\",C1))-FIND(\"]\",CELL(\"filename\",C1)))","v":"Output|Rate of return"}]
[null,null,null,null,null,null,null,null,null,"Prior Regulatory Period",null,null,null,null,null,"Current Regulatory Period",null,null,null,null,"Next Regulatory Period"]
[null,null,null,"Source","Unit","Basis",null,null,null,{"$f":"+K4-1","v":2015},{"$f":"+L4-1","v":2016},{"$f":"+M4-1","v":2017},{"$f":"+N4-1","v":2018},{"$f":"+O4-1","v":2019},{"$f":"+'Input|Rate of return'!$M$4","v":2020},{"$f":"O4+1","v":2021},2022,2023,2024,2025,2026,2027,2028,2029,2030]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Outputs | PTRM inputs"]
[]
[null,null,"Rate of return","Source","Unit","Basis",null,null,null,{"$f":"\"RY\"&RIGHT(J$4,2)","v":"RY15"},"RY16","RY17","RY18","RY19","RY20","RY21","RY22","RY23","RY24","RY25",{"$f":"\"RY\"&RIGHT(U$4,2)","v":"RY26"},{"$f":"\"RY\"&RIGHT(V$4,2)","v":"RY27"},{"$f":"\"RY\"&RIGHT(W$4,2)","v":"RY28"},{"$f":"\"RY\"&RIGHT(X$4,2)","v":"RY29"},{"$f":"\"RY\"&RIGHT(Y$4,2)","v":"RY30"}]
[]
[{"$f":"IF(ISERROR(U12),\"Check\",\"Ok\")","v":"Ok"},null,"Return on equity (post-tax)","Calc|Rate of return","Per cent","Nominal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Cost_of_Equity","v":8.2835167097263213E-2},{"$f":"Cost_of_Equity","v":8.2835167097263213E-2},{"$f":"Cost_of_Equity","v":8.2835167097263213E-2},{"$f":"Cost_of_Equity","v":8.2835167097263213E-2},{"$f":"Cost_of_Equity","v":8.2835167097263213E-2}]
[{"$f":"IF(ISERROR(U13),\"Check\",\"Ok\")","v":"Ok"},null,"Gamma","Input|Rate of return","Per cent","Nominal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Gamma","v":0.56999999999999995},{"$f":"Gamma","v":0.56999999999999995},{"$f":"Gamma","v":0.56999999999999995},{"$f":"Gamma","v":0.56999999999999995},{"$f":"Gamma","v":0.56999999999999995}]
[{"$f":"IF(ISERROR(U14),\"Check\",\"Ok\")","v":"Ok"},null,"Leverage","Input|Rate of return","Per cent","Nominal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Leverage","v":0.6},{"$f":"Leverage","v":0.6},{"$f":"Leverage","v":0.6},{"$f":"Leverage","v":0.6},{"$f":"Leverage","v":0.6}]
[{"$f":"IF(ISERROR(U15),\"Check\",\"Ok\")","v":"Ok"},null,"Tax rate","Input|Rate of return","Per cent","Nominal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Tax","v":0.3},{"$f":"Tax","v":0.3},{"$f":"Tax","v":0.3},{"$f":"Tax","v":0.3},{"$f":"Tax","v":0.3}]
[{"$f":"IF(ISERROR(U16),\"Check\",\"Ok\")","v":"Ok"},null,"Return on debt (pre-tax)","Calc|Rate of return","Per cent","Nominal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+_xlfn.XLOOKUP(RIGHT(U$10,2),RIGHT('Calc|Rate of return'!$M$18:$AA$18,2),'Calc|Rate of return'!$M$28:$AA$28)","v":4.6262928900712055E-2},{"$f":"+_xlfn.XLOOKUP(RIGHT(V$10,2),RIGHT('Calc|Rate of return'!$M$18:$AA$18,2),'Calc|Rate of return'!$M$28:$AA$28)","v":4.6089396836998461E-2},{"$f":"+_xlfn.XLOOKUP(RIGHT(W$10,2),RIGHT('Calc|Rate of return'!$M$18:$AA$18,2),'Calc|Rate of return'!$M$28:$AA$28)","v":4.6269800909531963E-2},{"$f":"+_xlfn.XLOOKUP(RIGHT(X$10,2),RIGHT('Calc|Rate of return'!$M$18:$AA$18,2),'Calc|Rate of return'!$M$28:$AA$28)","v":4.6945514937697386E-2},{"$f":"+_xlfn.XLOOKUP(RIGHT(Y$10,2),RIGHT('Calc|Rate of return'!$M$18:$AA$18,2),'Calc|Rate of return'!$M$28:$AA$28)","v":4.767452667274491E-2}]
[]
[null,null,"Nominal vanilla WACC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U12*(1-U14)+U16*U14","v":6.0891824179332518E-2},{"$f":"V12*(1-V14)+V16*V14","v":6.0787704941104366E-2},{"$f":"W12*(1-W14)+W16*W14","v":6.0895947384624463E-2},{"$f":"X12*(1-X14)+X16*X14","v":6.1301375801523721E-2},{"$f":"Y12*(1-Y14)+Y16*Y14","v":6.1738782842552235E-2}]
[]
[null,null,"Debt and equity raising costs","Source","Unit","Basis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimates"]
[]
[{"$f":"IF(ISERROR(U22),\"Check\",\"Ok\")","v":"Ok"},null,"Dividend / imputation payout ratio","Input|Rate of return","Per cent","n/a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input|Rate of return'!J79","v":0.878670689}]
[{"$f":"IF(ISERROR(U23),\"Check\",\"Ok\")","v":"Ok"},null,"Benchmark SEO raising cost","Input|Rate of return","Per cent","n/a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input|Rate of return'!J80","v":0.03}]
[{"$f":"IF(ISERROR(U24),\"Check\",\"Ok\")","v":"Ok"},null,"Benchmark DRP cost","Input|Rate of return","Per cent","n/a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input|Rate of return'!J81","v":0.01}]
[{"$f":"IF(ISERROR(U25),\"Check\",\"Ok\")","v":"Ok"},null,"Benchmark DRP takeup","Input|Rate of return","Per cent","n/a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input|Rate of return'!J82","v":0.3}]
[{"$f":"IF(ISERROR(U26),\"Check\",\"Ok\")","v":"Ok"},null,"Debt raising costs","Input|Rate of return","Per cent","n/a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input|Rate of return'!J83","v":8.4082594037438818E-4}]
[]
[null,"Outputs | Inflation"]
[]
[null,null,null,null,null,null,null,null,null,"Australian Bureau of Statistics (ABS) Data",null,null,null,null,null,null,null,null,null,"RBA Forecast"]
[null,null,"Inflation","Source","Unit","Basis",null,null,null,{"$f":"\"RY\"&RIGHT(J$4,2)","v":"RY15"},"RY16","RY17","RY18","RY19","RY20","RY21","RY22","RY23","RY24","RY25","RY26","RY27","RY28","RY29","RY30"]
[]
[{"$f":"+IF(ISNUMBER(SUM(J33:Y33)),\"Ok\",\"Check\")","v":"Ok"},null,"Inflation Rate (Opex)","Calc|Rate of return","Per cent","n/a",null,null,null,null,{"$f":"+'Calc|Rate of return'!M14","v":1.0232558139534831E-2},{"$f":"+'Calc|Rate of return'!N14","v":1.9337016574585641E-2},{"$f":"+'Calc|Rate of return'!O14","v":2.0776874435411097E-2},{"$f":"+'Calc|Rate of return'!P14","v":1.5929203539823078E-2},{"$f":"+'Calc|Rate of return'!Q14","v":-3.4843205574912606E-3},{"$f":"+'Calc|Rate of return'!R14","v":3.8461538461538325E-2},{"$f":"+'Calc|Rate of return'!S14","v":6.1447811447811418E-2},{"$f":"+'Calc|Rate of return'!T14","v":6.0269627279936566E-2},{"$f":"+'Calc|Rate of return'!U14","v":3.8145100972326373E-2},{"$f":"+'Calc|Rate of return'!V14","v":2.5000000000000001E-2}]
[{"$f":"+IF(ISNUMBER(SUM(J34:Y34)),\"Ok\",\"Check\")","v":"Ok"},null,"Inflation Rate (Capex)","Calc|Rate of return","Per cent","n/a",null,null,null,{"$f":"+'Calc|Rate of return'!L13","v":1.7175572519083859E-2},{"$f":"+'Calc|Rate of return'!M13","v":1.6885553470919357E-2},{"$f":"+'Calc|Rate of return'!N13","v":1.4760147601476037E-2},{"$f":"+'Calc|Rate of return'!O13","v":1.9090909090909047E-2},{"$f":"+'Calc|Rate of return'!P13","v":1.7841213202497874E-2},{"$f":"+'Calc|Rate of return'!Q13","v":1.8404907975460238E-2},{"$f":"+'Calc|Rate of return'!R13","v":8.6058519793459354E-3},{"$f":"+'Calc|Rate of return'!S13","v":3.4982935153583528E-2},{"$f":"+'Calc|Rate of return'!T13","v":7.8318219291014124E-2},{"$f":"+'Calc|Rate of return'!U13","v":4.0519877675840865E-2},{"$f":"+'Calc|Rate of return'!V13","v":2.5999999999999999E-2}]
[{"$f":"+IF(ISNUMBER(SUM(J35:Y35)),\"Ok\",\"Check\")","v":"Ok"},null,"Inflation Rate (PTRM)","Calc|Rate of return","Per cent","n/a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'Calc|Rate of return'!W$13","v":2.7997811278454687E-2},{"$f":"+'Calc|Rate of return'!X$13","v":2.7997811278454687E-2},{"$f":"+'Calc|Rate of return'!Y$13","v":2.7997811278454687E-2},{"$f":"+'Calc|Rate of return'!Z$13","v":2.7997811278454687E-2},{"$f":"+'Calc|Rate of return'!AA$13","v":2.7997811278454687E-2}]
[]
[null,"Outputs | Risk-free Rate"]
[]
[null,null,"Risk-free rate","Source","Unit","Basis",null,null,null,"Value"]
[]
[null,null,"Risk-free rate","Calc|Rate of return","Per cent","n/a",null,null,null,{"$f":"+'Calc|RfR'!Q40","v":4.5635167097263209E-2}]
[]
[null,"End"]

{"sheet":"Lookup|Tables","index":6,"n_rows":84,"n_cols":22,"rows_kept":84,"cut":false,"hidden":false,"merged":[[0,2,0,6],[1,2,1,4]]}
[null,null,{"$f":"Index!$C$1","v":"JGN - Rate of Return Model"},null,null,null,null,null,null,"Back to Index",null,"Key:","Input","External Link","Internal Link",null,null,null,null,null,"Overall Check:",{"$f":"+'Check|List'!V1","v":"OK"}]
[null,null,{"$f":"RIGHT(CELL(\"filename\",C1),LEN(CELL(\"filename\",C1))-FIND(\"]\",CELL(\"filename\",C1)))","v":"Lookup|Tables"}]
[]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Lookup table"]
[]
[null,null,"Financial Unit Denomination","Source",null,null,"Ref"]
[null,null,"Dollars","JGN",null,null,"$dollars"]
[null,null,"Thousands","JGN",null,null,"$000"]
[null,null,"Millions","JGN",null,null,"$millions"]
[]
[null,null,"Non-financial Unit Denomination"]
[null,null,"Percent","JGN",null,null,"Per cent"]
[null,null,"Unit","JGN",null,null,"unit"]
[null,null,"Number","JGN",null,null,"number"]
[null,null,"Factor","JGN",null,null,"factor"]
[null,null,"Mains","JGN",null,null,"mains"]
[null,null,"Kilometres","JGN",null,null,"kms"]
[null,null,"Metres","JGN",null,null,"metres"]
[]
[null,null,"Periodicity"]
[null,null,"Actuals","JGN",null,null,"Actual"]
[null,null,"Forecast","JGN",null,null,"Fcast"]
[null,null,"Date","JGN",null,null,"date"]
[null,null,"Month","JGN",null,null,"month"]
[null,null,"Quarter","JGN",null,null,"quarter"]
[null,null,"Year","JGN",null,null,"year"]
[null,null,"Option","JGN",null,null,"option"]
[null,null,"Yes/No","JGN",null,null,"yes/no"]
[null,null,"Actuals/Forecast","JGN",null,null,"(A)/(F)"]
[]
[null,null,"Time Intervals"]
[null,null,"Number of months in a year","JGN",null,null,12]
[null,null,"Number of days in a year","JGN",null,null,365]
[null,null,"Number of weeks in a year","JGN",null,null,52]
[null,null,"Number of periods (years) in reg period","JGN",null,null,5]
[]
[null,null,"Cash flow timing"]
[null,null,"Start-year","JGN",null,null,-0.5]
[null,null,"Mid-year","JGN",null,null,0]
[null,null,"End-year","JGN",null,null,0.5]
[null,null,"Adjustment to mid-year","JGN",null,null,0.5]
[null,null,"Adjustment to end-year","JGN",null,null,1]
[]
[null,null,"Timing"]
[null,null,"Mid-year","JGN",null,null,"Mid-year"]
[null,null,"End-year","JGN",null,null,"End-year"]
[]
[null,null,"Yes/No",null,null,null,"[Select]"]
[null,null,"Yes","JGN",null,null,"Yes"]
[null,null,"No","JGN",null,null,"No"]
[]
[null,null,"Dollar base"]
[null,null,2015,"JGN",null,null,2015]
[null,null,2016,"JGN",null,null,2016]
[null,null,2017,"JGN",null,null,2017]
[null,null,2018,"JGN",null,null,2018]
[null,null,2019,"JGN",null,null,2019]
[null,null,2020,"JGN",null,null,2020]
[null,null,2021,"JGN",null,null,2021]
[null,null,2022,"JGN",null,null,2022]
[null,null,2023,"JGN",null,null,2023]
[null,null,2024,"JGN",null,null,2024]
[null,null,2025,"JGN",null,null,2025]
[null,null,2026,"JGN",null,null,2026]
[null,null,2027,"JGN",null,null,2027]
[null,null,2028,"JGN",null,null,2028]
[null,null,2029,"JGN",null,null,2029]
[null,null,2030,"JGN",null,null,2030]
[null,null,"Nominal","JGN",null,null,"Nominal"]
[null,null,"Real","JGN",null,null,"Real"]
[null,null,"Not Applicable","JGN",null,null,"n/a"]
[]
[null,null,"Numeric Converters"]
[null,null,"Thousands","JGN",null,null,1000]
[null,null,"Millions","JGN",null,null,1000000]
[]
[null,null,"Rounding and Error Handling"]
[null,null,"Rounding units","JGN",null,null,5]
[null,null,"Very Small Number","JGN",null,null,9.9999999999999995E-8]
[]
[null,"End"]

{"sheet":"Check|List","index":7,"n_rows":15,"n_cols":22,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,2,0,6],[1,2,1,4]]}
[null,null,{"$f":"Index!$C$1","v":"JGN - Rate of Return Model"},null,null,null,null,null,null,"Back to Index",null,"Key:","Input","External Link","Internal Link",null,null,null,null,null,"Overall Check:",{"$f":"IF(COUNTA($G$10:$G$13)=COUNTIF($G$10:$G$13,\"OK\"),\"OK\",\"Check\")","v":"OK"}]
[null,null,{"$f":"RIGHT(CELL(\"filename\",C1),LEN(CELL(\"filename\",C1))-FIND(\"]\",CELL(\"filename\",C1)))","v":"Check|List"}]
[]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Check List"]
[]
[null,null,"Sheet",null,null,null,"Status"]
[null,null,"Input | Rate of return",null,null,null,{"$f":"'Input|Rate of return'!$S$1","v":"OK"}]
[null,null,"Calc | Placeholder RfR",null,null,null,{"$f":"+'Calc|Rate of return'!W1","v":"OK"}]
[null,null,"Calc | Rate of return",null,null,null,{"$f":"'Calc|Rate of return'!W1","v":"OK"}]
[null,null,"Output | Rate of return",null,null,null,{"$f":"'Output|Rate of return'!T1","v":"OK"}]
[]
[null,"End"]