{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["APA VTS Return on debt","Sheet1"],"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":"APA VTS Return on debt","index":0,"n_rows":84,"n_cols":20,"rows_kept":84,"cut":false,"hidden":false,"merged":[]}
[]
[null,"APA VTS"]
[null,"Victorian Transmission System"]
[null,"VTS Access Arrangement revisions proposal 2016"]
[]
[null,"Return on debt"]
[]
[null,"Australian Government Securities (RBA F16 (historical))"]
[]
[null,null,null,"Tenor 7 years",null,null,null,null,null,null,null,null,"Tenor 10 years"]
[null,null,null,null,null,"Days",null,"Days to","Days","Interpolated","Effective",null,null,null,"Days",null,"Days to","Days","Interpolated","Effective"]
[null,null,null,null,null,"to maturity",null,"maturity","7 years","yield","annual rate",null,null,null,"to maturity",null,"maturity","10 years","yield","annual rate"]
[]
[null,"2005-10-31",null,null,"TB117",null,"TB118",null,null,null,null,null,null,"TB119",null,"TB120"]
[null,null,null,null,"2011-06-15",null,"2013-05-15",null,null,null,null,null,null,"2015-04-15",null,"2017-02-15"]
[null,null,null,null,5.4149999999999997E-2,{"$f":"(30+31)+5*365+1+(31+28+31+30+31+15)","v":2053},5.4649999999999997E-2,{"$f":"(30+31)+7*365+2+(31+28+31+30+15)","v":2753},{"$f":"7*365+1","v":2556},{"$f":"E16+(G16-E16)*(I16-F16)/(H16-F16)","v":5.4509285714285712E-2},{"$f":"(1+J16/2)^2-1","v":5.5252101271556331E-2},null,null,5.475E-2,{"$f":"(30+31)+9*365+2+(31+28+31+15)","v":3453},5.5050000000000002E-2,{"$f":"(30+31)+11*365+3+(31+15)","v":4125},{"$f":"10*365+2","v":3652},{"$f":"N16+(P16-N16)*(R16-O16)/(Q16-O16)","v":5.4838839285714286E-2},{"$f":"(1+S16/2)^2-1","v":5.5590663859265588E-2}]
[]
[null,"2006-10-31",null,null,"TB118",null,"TB119",null,null,null,null,null,null,"TB119",null,"TB120"]
[null,null,null,null,"2013-05-15",null,"2015-04-15",null,null,null,null,null,null,"2015-04-15",null,"2017-02-15"]
[null,null,null,null,5.7849999999999999E-2,{"$f":"(30+31)+6*365+2+(31+28+31+30+15)","v":2388},5.7049999999999997E-2,{"$f":"(30+31)+8*365+2+(31+28+31+15)","v":3088},{"$f":"7*365+2","v":2557},{"$f":"E20+(G20-E20)*(I20-F20)/(H20-F20)","v":5.7656857142857142E-2},{"$f":"(1+J20/2)^2-1","v":5.8487935436755345E-2},null,null,5.7049999999999997E-2,{"$f":"(30+31)+8*365+2+(31+28+31+15)","v":3088},5.6599999999999998E-2,{"$f":"(30+31)+10*365+3+(31+15)","v":3760},{"$f":"10*365+3","v":3653},{"$f":"N20+(P20-N20)*(R20-O20)/(Q20-O20)","v":5.6671651785714282E-2},{"$f":"(1+S20/2)^2-1","v":5.747457081474483E-2}]
[]
[null,"2007-10-31",null,null,"TB118",null,"TB119",null,null,null,null,null,null,"TB120",null,"TB122"]
[null,null,null,null,"2013-05-15",null,"2015-04-15",null,null,null,null,null,null,"2017-02-15",null,"2019-03-15"]
[null,null,null,null,6.4649999999999999E-2,{"$f":"(30+31)+5*365+2+(31+28+31+30+15)","v":2023},6.275E-2,{"$f":"(30+31)+7*365+2+(31+28+31+15)","v":2723},{"$f":"7*365+2","v":2557},{"$f":"E24+(G24-E24)*(I24-F24)/(H24-F24)","v":6.3200571428571425E-2},{"$f":"(1+J24/2)^2-1","v":6.4199149485795859E-2},null,null,6.1749999999999999E-2,{"$f":"(30+31)+9*365+3+(31+15)","v":3395},6.1350000000000002E-2,{"$f":"(30+31)+11*365+3+(31+28+15)","v":4153},{"$f":"10*365+3","v":3653},{"$f":"N24+(P24-N24)*(R24-O24)/(Q24-O24)","v":6.1613852242744065E-2},{"$f":"(1+S24/2)^2-1","v":6.2562918939791601E-2}]
[]
[null,"2008-10-31",null,null,"TB119",null,"TB120",null,null,null,null,null,null,"TB120",null,"TB122"]
[null,null,null,null,"2015-04-15",null,"2017-02-15",null,null,null,null,null,null,"2017-02-15",null,"2019-03-15"]
[null,null,null,null,4.895E-2,{"$f":"(30+31)+6*365+1+(31+28+31+15)","v":2357},5.0450000000000002E-2,{"$f":"(30+31)+8*365+2+(31+15)","v":3029},{"$f":"7*365+1","v":2556},{"$f":"E28+(G28-E28)*(I28-F28)/(H28-F28)","v":4.939419642857143E-2},{"$f":"(1+J28/2)^2-1","v":5.0004143088777653E-2},null,null,5.0450000000000002E-2,{"$f":"(30+31)+8*365+2+(31+15)","v":3029},5.1749999999999997E-2,{"$f":"(30+31)+10*365+2+(31+28+15)","v":3787},{"$f":"10*365+2","v":3652},{"$f":"N28+(P28-N28)*(R28-O28)/(Q28-O28)","v":5.1518469656992083E-2},{"$f":"(1+S28/2)^2-1","v":5.2182007835941846E-2}]
[]
[null,"2009-10-30",null,null,"TB119",null,"TB120",null,null,null,null,null,null,"TB122",null,"TB126"]
[null,null,null,null,"2015-04-15",null,"2017-02-15",null,null,null,null,null,null,"2019-03-15",null,"2020-04-15"]
[null,null,null,null,5.3749999999999999E-2,{"$f":"(1+30+31)+5*365+1+(31+28+31+15)","v":1993},5.4600000000000003E-2,{"$f":"(1+30+31)+7*365+2+(31+15)","v":2665},{"$f":"7*365+2","v":2557},{"$f":"E32+(G32-E32)*(I32-F32)/(H32-F32)","v":5.4463392857142856E-2},{"$f":"(1+J32/2)^2-1","v":5.5204958147520911E-2},null,null,5.5399999999999998E-2,{"$f":"(1+30+31)+9*365+2+(31+28+15)","v":3423},5.6149999999999999E-2,{"$f":"(1+30+31)+10*365+2+(31+29+31+15)","v":3820},{"$f":"10*365+2","v":3652},{"$f":"N32+(P32-N32)*(R32-O32)/(Q32-O32)","v":5.5832619647355163E-2},{"$f":"(1+S32/2)^2-1","v":5.6611940001526806E-2}]
[]
[null,"2010-10-29",null,null,"TB120",null,"TB122",null,null,null,null,null,null,"TB126",null,"TB124"]
[null,null,null,null,"2017-02-15",null,"2019-03-15",null,null,null,null,null,null,"2020-04-15",null,"2021-05-15"]
[null,null,null,null,5.1049999999999998E-2,{"$f":"(2+30+31)+6*365+2+(31+15)","v":2301},5.1799999999999999E-2,{"$f":"(2+30+31)+8*365+2+(31+28+15)","v":3059},{"$f":"7*365+2","v":2557},{"$f":"E36+(G36-E36)*(I36-F36)/(H36-F36)","v":5.1303298153034298E-2},{"$f":"(1+J36/2)^2-1","v":5.1961305253378942E-2},null,null,5.2049999999999999E-2,{"$f":"(2+30+31)+9*365+2+(31+29+31+15)","v":3456},5.2350000000000001E-2,{"$f":"(2+30+31)+10*365+3+(31+28+31+30+15)","v":3851},{"$f":"10*365+3","v":3653},{"$f":"N36+(P36-N36)*(R36-O36)/(Q36-O36)","v":5.2199620253164554E-2},{"$f":"(1+S36/2)^2-1","v":5.2880820341808299E-2}]
[]
[null,"2011-10-31",null,null,"TB132",null,"TB122",null,null,null,null,null,null,"TB124",null,"TB128"]
[null,null,null,null,"2018-01-21",null,"2019-03-15",null,null,null,null,null,null,"2021-05-15",null,"2022-07-15"]
[null,null,null,null,4.24E-2,{"$f":"(30+31)+6*365+2+21","v":2274},4.3249999999999997E-2,{"$f":"(30+31)+7*365+2+(31+28+15)","v":2692},{"$f":"7*365+2","v":2557},{"$f":"E40+(G40-E40)*(I40-F40)/(H40-F40)","v":4.2975478468899521E-2},{"$f":"(1+J40/2)^2-1","v":4.3437201406307135E-2},null,null,4.5100000000000001E-2,{"$f":"(30+31)+9*365+3+(31+28+31+30+15)","v":3484},4.5900000000000003E-2,{"$f":"(30+31)+10*365+3+(31+28+31+30+31+30+15)","v":3910},{"$f":"10*365+3","v":3653},{"$f":"N40+(P40-N40)*(R40-O40)/(Q40-O40)","v":4.5417370892018784E-2},{"$f":"(1+S40/2)^2-1","v":4.5933055286704771E-2}]
[]
[null,"2012-10-31",null,null,"TB122",null,"TB126",null,null,null,null,null,null,"TB124",null,"TB133"]
[null,null,null,null,"2019-03-15",null,"2020-04-15",null,null,null,null,null,null,"2021-05-15",null,"2023-04-21"]
[null,null,null,null,2.785E-2,{"$f":"(30+31)+6*365+1+(31+28+15)","v":2326},2.8799999999999999E-2,{"$f":"(30+31)+7*365+1+(31+29+31+15)","v":2723},{"$f":"7*365+1","v":2556},{"$f":"E44+(G44-E44)*(I44-F44)/(H44-F44)","v":2.8400377833753147E-2},{"$f":"(1+J44/2)^2-1","v":2.8602023199028048E-2},null,null,2.9700000000000001E-2,{"$f":"(30+31)+8*365+2+(31+28+31+30+15)","v":3118},3.0550000000000001E-2,{"$f":"(30+31)+10*365+2+(31+28+31+321)","v":4124},{"$f":"10*365+2","v":3652},{"$f":"N44+(P44-N44)*(R44-O44)/(Q44-O44)","v":3.0151192842942348E-2},{"$f":"(1+S44/2)^2-1","v":3.037846645040565E-2}]
[]
[null,"2013-10-31",null,null,"TB126",null,"TB124",null,null,null,null,null,null,"TB133",null,"TB137"]
[null,null,null,null,"2020-04-15",null,"2021-05-15",null,null,null,null,null,null,"2023-04-21",null,"2024-04-21"]
[null,null,null,null,3.5950000000000003E-2,{"$f":"(30+31)+6*365+1+(31+29+31+15)","v":2358},3.7600000000000001E-2,{"$f":"(30+31)+7*365+2+(31+28+31+30+15)","v":2753},{"$f":"7*365+2","v":2557},{"$f":"E48+(G48-E48)*(I48-F48)/(H48-F48)","v":3.6781265822784813E-2},{"$f":"(1+J48/2)^2-1","v":3.7119481201666193E-2},null,null,3.9350000000000003E-2,{"$f":"(31+30+31)+9*365+2+(31+28+31+21)","v":3490},4.02E-2,{"$f":"(30+31)+10*365+2+(31+29+31+21)","v":3825},{"$f":"10*365+2","v":3652},{"$f":"N48+(P48-N48)*(R48-O48)/(Q48-O48)","v":3.9761044776119407E-2},{"$f":"(1+S48/2)^2-1","v":4.0156279946541362E-2}]
[]
[null,"2014-10-31",null,null,"TB124",null,"TB128",null,null,null,null,null,null,"TB137",null,"TB139"]
[null,null,null,null,"2021-05-15",null,"2022-07-15",null,null,null,null,null,null,"2024-04-21",null,"2025-04-21"]
[null,null,null,null,0.03,{"$f":"(30+31)+6*365+2+(31+28+31+30+15)","v":2388},3.125E-2,{"$f":"(30+31)+7*365+2+(31+28+31+30+31+30+15)","v":2814},{"$f":"7*365+2","v":2557},{"$f":"E52+(G52-E52)*(I52-F52)/(H52-F52)","v":3.0495892018779343E-2},{"$f":"(1+J52/2)^2-1","v":3.0728391876284622E-2},null,null,3.2849999999999997E-2,{"$f":"(30+31)+9*365+2+(31+28+31+21)","v":3459},3.3500000000000002E-2,{"$f":"(30+31)+10*365+3+(31+28+31+21)","v":3825},{"$f":"10*365+3","v":3653},{"$f":"N52+(P52-N52)*(R52-O52)/(Q52-O52)","v":3.3194535519125684E-2},{"$f":"(1+S52/2)^2-1","v":3.3470004816208432E-2}]
[]
[null,"2015-10-30",null,null,"TB128",null,"TB133",null,null,null,null,null,null,"TB139",null,"TB142"]
[null,null,null,null,"2022-07-15",null,"2023-04-21",null,null,null,null,null,null,"2025-04-21",null,"2026-04-21"]
[null,null,null,null,2.3E-2,{"$f":"(1+30+31)+6*365+2+(31+28+31+30+31+30+15)","v":2450},2.4E-2,{"$f":"(1+30+31)+7*365+2+(31+28+31+21)","v":2730},{"$f":"7*365+2","v":2557},{"$f":"E56+(G56-E56)*(I56-F56)/(H56-F56)","v":2.3382142857142858E-2},{"$f":"(1+J56/2)^2-1","v":2.3518824008290862E-2},null,null,2.6100000000000002E-2,{"$f":"(1+30+31)+9*365+3+(31+28+31+21)","v":3461},2.6749999999999999E-2,{"$f":"(1+30+31)+10*365+3+(31+28+31+21)","v":3826},{"$f":"10*365+2","v":3652},{"$f":"N56+(P56-N56)*(R56-O56)/(Q56-O56)","v":2.644013698630137E-2},{"$f":"(1+S56/2)^2-1","v":2.6614907197265003E-2}]
[]
[null,"2016-10-31",null,null,"TB133",null,"TB137",null,null,null,null,null,null,"TB142",null,"TB136"]
[null,null,null,null,"2023-04-21",null,"2024-04-21",null,null,null,null,null,null,"2026-04-21",null,"2027-04-21"]
[null,null,null,null,2.0549999999999999E-2,{"$f":"(30+31)+6*365+1+(31+28+31+21)","v":2363},2.18E-2,{"$f":"(30+31)+7*365+1+(31+29+31+21)","v":2729},{"$f":"7*365+2","v":2557},{"$f":"E60+(G60-E60)*(I60-F60)/(H60-F60)","v":2.1212568306010929E-2},{"$f":"(1+J60/2)^2-1","v":2.1325061569545278E-2},null,null,2.3050000000000001E-2,{"$f":"(30+31)+9*365+2+(31+28+31+21)","v":3459},2.3449999999999999E-2,{"$f":"(30+31)+10*365+2+(31+28+31+21)","v":3824},{"$f":"10*365+2","v":3652},{"$f":"N60+(P60-N60)*(R60-O60)/(Q60-O60)","v":2.3261506849315067E-2},{"$f":"(1+S60/2)^2-1","v":2.3396781274540368E-2}]
[]
[]
[]
[null,"BBB non-financial corporate debt yields (RBA F03)"]
[]
[null,null,null,null,"Tenor 7 years",null,null,null,null,null,null,null,null,"Tenor 10 years"]
[null,null,null,null,"Yield","Effective","Spread to",null,null,null,null,null,null,"Yield","Effective","Spread to","Extrapolate","Effective","Adjusted RBA"]
[null,null,null,null,null,"tenor","swap",null,null,null,null,null,null,null,"tenor","swap","tenor","annual rate","spread"]
[null,"October"]
[null,2006,null,null,6.9900000000000004E-2,6.81,7.2449999999999997E-3,null,null,null,null,null,null,6.9599999999999995E-2,8.92,7.8899999999999994E-3,{"$f":"N70+(P70-G70)*(10-O70)/(O70-F70)","v":6.9930142180094787E-2},{"$f":"(1+Q70/2)^2-1","v":7.1152698376426793E-2},{"$f":"Q70-T20","v":1.2455571365349957E-2}]
[null,{"$f":"B70+1","v":2007},null,null,7.8299999999999995E-2,6.4,7.6039999999999996E-3,null,null,null,null,null,null,"#NA","#NA","#NA","#NA","#NA","#NA"]
[null,{"$f":"B71+1","v":2008},null,null,9.6799999999999997E-2,6.57,3.9052999999999997E-2,null,null,null,null,null,null,0.1096,9.92,5.1299999999999998E-2,{"$f":"N72+(P72-G72)*(10-O72)/(O72-F72)","v":0.10989246567164179},{"$f":"(1+Q72/2)^2-1","v":0.11291155417449028},{"$f":"Q72-T28","v":5.7710457835699946E-2}]
[null,2009,null,null,8.8700000000000001E-2,6.62,2.7754000000000001E-2,null,null,null,null,null,null,8.9499999999999996E-2,9.11,2.751E-2,{"$f":"N73+(P73-G73)*(10-O73)/(O73-F73)","v":8.9412787148594366E-2},9.1411448775014614E-2,{"$f":"Q73-T32","v":3.2800847147067561E-2}]
[null,2010,null,null,7.4099999999999999E-2,6.88,{"$f":"0.017672","v":1.7672E-2},null,null,null,null,null,null,7.7299999999999994E-2,9.0500000000000007,2.0195999999999999E-2,7.8404976958525344E-2,7.9941812061492312E-2,{"$f":"Q74-T36","v":2.5524156616717045E-2}]
[null,2011,null,null,7.7499999999999999E-2,7.07,2.7761999999999998E-2,null,null,null,null,null,null,8.1900000000000001E-2,9.07,3.023E-2,8.3047620000000003E-2,8.4771846796916073E-2,{"$f":"Q75-T40","v":3.7114564713295231E-2}]
[null,2012,null,null,5.8000000000000003E-2,7.03,2.3002999999999999E-2,null,null,null,null,null,null,6.4199999999999993E-2,9.24,2.6824000000000001E-2,6.5514009049773753E-2,6.6587030395217184E-2,{"$f":"Q76-T44","v":3.5135542599368103E-2}]
[null,2013,null,null,6.3799999999999996E-2,6.96,2.2928E-2,null,null,null,null,null,null,7.2499999999999995E-2,8.6,2.8218E-2,7.7015853658536582E-2,7.8498714087224863E-2,{"$f":"Q77-T48","v":3.6859573711995219E-2}]
[null,2014,null,null,5.1999999999999998E-2,6.74,1.7741E-2,null,null,null,null,null,null,5.5100000000000003E-2,8.68,1.8270999999999999E-2,5.5460618556701036E-2,5.6229588609373993E-2,{"$f":"Q78-T52","v":2.1990613740492604E-2}]
[null,2015,null,null,5.1499999999999997E-2,6.6,2.5454000000000001E-2,null,null,null,null,null,null,5.3900000000000003E-2,9.11,2.5194000000000001E-2,5.3807808764940242E-2,5.453162883596141E-2,{"$f":"Q79-T56","v":2.7192901567675239E-2}]
[null,{"$f":"B79+1","v":2016},null,null,4.19E-2,6.9,1.8974000000000001E-2,null,null,null,null,null,null,4.58E-2,9.11,2.1257999999999999E-2,4.6719800904977377E-2,4.7265485854127487E-2,{"$f":"Q80-T60","v":2.3323019630437009E-2}]
[]
[null,"Average",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(R72:R80)","v":7.4683234398868689E-2},{"$f":"AVERAGE(S72:S80)","v":3.307240861808311E-2}]
[]
[null,"Return on debt:  trailing average without transition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R82","v":7.4683234398868689E-2}]

{"sheet":"Sheet1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}