{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Standard - P&L","Standard - Balance Sheet","Standard - Cashflow","Standard - Ratios","Standard - SS7 Ratios","Standard - Graphs","Strategic - P&L","Strategic - Balance Sheet","Strategic - Cashflow","Strategic - Ratios","Strategic - SS7 Ratios","Strategic - Graphs"],"not_rendered":{"charts":18,"images":1,"macros":0,"external_links":5,"defined_names":17,"comments":1,"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":"Standard - P&L","index":0,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Profit & Loss Statement - Standard Scenario - Unconsolidated"]
[]
[null,"INSTRUCTIONS - HIDE THIS LINE BEFORE PRINT","NY Budget","New Projection","New Projection","New Projection","New Projection","New Projection","New Projection","New Projection","New Projection","New Projection"]
[null,"For the period ended 30 June",2020,{"$f":"C10+1","v":2021},2022,2023,2024,2025,2026,2027,2028,2029]
[null,null,"$'000","$'000","$'000","$'000","$'000","$'000","$'000","$'000","$'000","$'000"]
[null,"Revenue"]
[null,"Rates & Annual Charges",59086.803,60717.723074999994,62389.41615187499,64102.901555671859,65859.224094563644,67659.454696927729,69504.691064350918,71396.058340959687,73334.709799483666,75321.827544470754]
[null,"User Fees and Charges",26455.710475,27268.488236874997,28289.119442796869,29345.446428866788,30421.101589588456,31181.629129328165,31961.169857561366,32760.199104000396,33579.204081600408,34418.684183640413]
[null,"Interest & Investment Revenue",1131.125,927.22422625504316,893.97147889947541,899.30483353696627,903.44385308631763,937.85308304104444,1002.5175914693272,1056.8800285939253,1119.3404927121508,1183.1488648420989]
[null,"Other Revenues",9068.8437384622921,9358.3961474890057,9592.5677356302731,9832.3996194689244,10078.437957086933,10330.433008930699,10588.666462100702,10853.185856621873,11131.263721823279,11435.652665119262]
[null,"Operating Grants and Contributions",12339.405859999997,12647.891006499996,12964.088281662496,13288.190488704058,13620.395250921658,13960.905132194697,14309.927760499564,14667.675954512053,15034.367853374852,15410.227049709221]
[null,"Capital Grants and Contributions",5865.51,5982.8202000000001,6102.4766040000004,6224.5261360800005,6349.0166588016,6475.9969919776322,6605.5169318171847,6737.6272704535286,6872.3798158625987,7009.8274121798513]
[null,"Gain on Sale of assets",250,250,250,250,250,250,250,250,250,250]
[null,"Total Revenue",{"$f":"SUM(C13:C19)","v":114197.39807346229},117152.54289211905,120481.6396948641,123942.7690623286,127481.61940404862,130796.27204239999,134222.48966779906,137721.62655514147,141321.26576485694,145029.36771996156]
[]
[null,"Operating Expenses"]
[null,"Employee Benefits & On-Costs",44144.006380000028,45922.341629045375,47520.594843774204,49102.884565320062,50121.842968874305,51829.144286924355,53299.694516372881,55318.20758257297,56031.460837220111,58265.739430463698]
[null,"Borrowing Costs",532.88579156842627,515.9905827579779,423.41180299418818,342.1389014904272,267.4977703821724,234.11235458837541,216.42512484848174,198.0721902040805,179.50648892181491,155.2915882122839]
[null,"Materials & Contracts",40113.11048000001,41615.938242000004,42143.83669805,43225.932615501246,44328.080930888769,46186.28295416099,46827.190028015008,48047.86977871538,49349.066523183254,51182.793186262832]
[null,"Depreciation & Amortisation",13853.076346923157,14047.41332314672,14487.607195353377,15071.125787130799,15150.686816226889,15234.446133566067,15320.715271875997,15411.365402514199,15520.314822320965,15672.66207798261]
[null,"Amortisation - intangibles",262.741512,294.19320959999999,321.45456767999997,345.41615414399996,366.7917358151999,386.15367146465991,403.96122705454036,420.58322877351503,436.31618632694182,451.39879245238649]
[null,"Other",7712.0988250000019,7905.9262956250013,8103.5744530156253,8334.6638143410146,8564.5304096995405,8978.6436699420283,9253.109761690579,9534.4375057328434,9872.798443376163,10119.618404460565]
[null,"Total Operating Expenses",{"$f":"SUM(C23:C28)","v":106617.91933549164},{"$f":"SUM(D23:D28)","v":110301.80328217508},{"$f":"SUM(E23:E28)","v":113000.4795608674},116422.16183792755,118799.43063188688,122848.78307064649,125321.09592985746,128930.53568851299,131389.46330134926,135847.50347983435]
[]
[null,"Operating Surplus / (Deficit) ",{"$f":"C20-C29","v":7579.478737970654},{"$f":"D20-D29","v":6850.7396099439648},7481.1601339967019,7520.6072244010575,8682.1887721617386,7947.488971753497,8901.393737941602,8791.0908666284813,9931.8024635076872,{"$f":"L20-L29","v":9181.8642401272082}]
[]
[null,"Other Comprehensive Income",0,0,0,0,0,0,0,0,0,0]
[]
[null,"Total Comprehensive Income",{"$f":"SUM(C31:C34)","v":7579.478737970654},{"$f":"SUM(D31:D34)","v":6850.7396099439648},7481.1601339967019,7520.6072244010575,8682.1887721617386,7947.488971753497,8901.393737941602,8791.0908666284813,9931.8024635076872,{"$f":"SUM(L31:L34)","v":9181.8642401272082}]
[]
[null,"Net Operating Result before Capital Grants",{"$f":"+C35-C18","v":1713.9687379706538},867.91940994396464,1378.6835299967015,1296.081088321057,2333.1721133601386,1471.4919797758648,2295.8768061244173,2053.4635961749527,3059.4226476450885,2172.0368279473569]
[]
[null,"Adjustments for Underlying Result"]
[null,"Gain on Sale of assets",-250,-250,-250,-250,-250,-250,-250,-250,-250,-250]
[null,"Investment property fair value increases ",-786.67499999999995,-996.02324999999837,-1025.9039475000027,-1056.6810659250038,-1088.3814979027518,-1121.0329428398327,-1154.6639311250256,-1189.3038490587787,-1224.9829645305433,-1261.7324534664585]
[null,"NAP Profit",0,0,0,0,0,0,0,0,0,0]
[null,"Local election costs",0,500,0,0,0,550,0,0,0,600]
[null,"NAP dividend "]
[null,"Underlying result",{"$f":"SUM(C37:C44)","v":677.29373797065386},{"$f":"SUM(D37:D44)","v":121.89615994396627},102.77958249669882,-10.599977603946854,994.79061545738682,650.45903693603213,891.21287499939172,614.159747116174,1584.4396831145452,{"$f":"SUM(L37:L44)","v":1260.3043744808983}]

{"sheet":"Standard - Balance Sheet","index":1,"n_rows":54,"n_cols":12,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Balance Sheet - Standard Scenario - Unconsolidated"]
[null,{"$f":"'Standard - P&L'!B9","v":"INSTRUCTIONS - HIDE THIS LINE BEFORE PRINT"},"New Projection","New Projection","New Projection","New Projection","New Projection","New Projection","New Projection","New Projection","New Projection","New Projection"]
[]
[null,"As at 30 June",2020,{"$f":"C10+1","v":2021},{"$f":"D10+1","v":2022},{"$f":"E10+1","v":2023},2024,2025,2026,2027,2028,2029]
[null,null,"$'000","$'000","$'000","$'000","$'000","$'000","$'000","$'000",{"$f":"J11","v":"$'000"},{"$f":"K11","v":"$'000"}]
[null,"ASSETS"]
[null,"Current Assets"]
[null,"Cash and Cash Equivalents",9784.9690502017238,8454.8591559790129,8668.193341478649,8833.7541234526998,10210.123321641775,12796.703658773084,14971.201143757011,17469.619708486025,20021.954593683949,23613.241328917738]
[null,"Investments",27304,27304,27304,27304,27304,27304,27304,27304,27304,27304]
[null,"Receivables",9788.1919335000002,10063.410231837501,10364.262387633436,10673.653847324271,10990.072093507377,11280.19889584506,11577.578868241186,11882.393339947215,12194.828173445892,12515.073877782039]
[null,"Inventories",3875,3875,3875,3875,3875,3875,3875,3875,3875,3875]
[]
[null,"Total Current Assets",{"$f":"SUM(C14:C17)","v":50752.160983701724},49697.269387816516,50211.455729112087,50686.407970776971,52379.195415149152,55255.902554618144,57727.780011998198,60531.01304843324,63395.782767129844,{"$f":"SUM(L14:L17)","v":67307.315206699772}]
[]
[null,"Non Current Assets"]
[null,"Investments",0,{"$f":"C22","v":0},0,0,0,0,0,0,0,0]
[null,"Receivables",0,0,0,0,0,0,0,0,0,1]
[null,"Infrastructure, Property, Plant & Equipment",873352.22778826684,877515.52946512005,881682.98094476666,885722.14761551085,890148.14503092587,894968.20738635911,900191.53861030517,905825.75966649828,911864.86854085175,918278.06727998995]
[null,"Inventories",16651,16651,16651,16651,16651,16651,16651,16651,16651,16651]
[null,"Investment Properties",33200.775000000001,34196.79825,35222.702197500003,36279.383263425007,37367.764761327759,38488.797704167591,39643.461635292617,40832.765484351396,42057.748448881939,43319.480902348398]
[null,"Intangibles",1060.966048,1187.0228383999997,1296.3245207199998,1392.4335228259997,1478.2050721670496,1555.9287679875456,1627.4418424002902,1694.219772630742,1757.4487742828662,1818.0837995090221]
[null,"Total Non Current Assets",{"$f":"SUM(C22:C27)","v":924264.9688362669},929550.35055352002,934853.00766298675,940044.96440176177,945645.11486442073,951663.93385851418,958113.44208799803,965003.74492348044,972331.06576401647,980067.63198184734]
[null,"Total Assets",{"$f":"C28+C19","v":975017.1298199686},979247.61994133657,985064.4633920989,990731.37237253878,998024.31027956982,1006919.8364131324,1015841.2220999962,1025534.7579719137,1035726.8485311463,1047374.9471885471]
[]
[null,"LIABILITIES"]
[null,"Current Liabilities"]
[null,"Trade & Other Payables",7220.3598864000014,6850.8688835600005,7585.8906056489996,7780.6678707902238,7979.0545675599778,8313.5309317489773,8428.8942050427013,8648.616560168768,8882.8319741729847,9212.9027735273103]
[null,"Borrowings",3237.496220607763,2410.5365582468007,2497.3698959221215,2013.9294622818259,652.45885969100334,677.19158012023479,702.86874023968255,787.58088336596643,521.0518083389918,521.0518083389918]
[null,"Provisions",12657.322008820003,12823.292193412994,11962.653821084679,11516.034377911221,11020.798167323863,11345.648595761624,10951.846458042413,11340.110920635079,11134.627724597944,12776.524163084314]
[null,"Other Current Liabilities",0,0,0,0,0,0,0,0,0,1]
[null,"Total Current Liabilities",{"$f":"SUM(C33:C36)","v":23115.178115827766},22084.697635219796,22045.914322655801,21310.631710983271,19652.311594574843,20336.371107630835,20083.609403324797,20776.308364169814,20538.511507109921,{"$f":"SUM(L33:L36)","v":22511.478744950618}]
[]
[null,"Non Current Liabilities"]
[null,"Trade & Other Payables",0,0,0,0,0,0,0,0,0,0]
[null,"Borrowings",12400.138319168163,9989.6017609213632,7492.2318649992412,5478.3024027174151,4825.8435430264117,4148.6519629061768,3445.7832226664946,2658.2023393005284,2137.1505309615363,1616.0987226225445]
[null,"Provisions",810.0111313241996,1630.7786816030775,2502.6152068546849,3398.1290368480722,4319.6571478167252,5260.8263766900354,6236.4487701579947,7233.7756979677897,8252.9124590916999,9267.2314468634577]
[null,"Other Non-current Liabilities",0,0,0,0,0,0,0,0,0,1]
[null,"Total Non Current Liabilities",{"$f":"SUM(C40:C43)","v":13210.149450492363},11620.380442524442,9994.8470718539265,8876.4314395654874,9145.5006908431369,9409.4783395962113,9682.2319928244888,9891.9780372683181,{"$f":"SUM(K40:K43)","v":10390.062990053237},{"$f":"SUM(L40:L43)","v":10884.330169486002}]
[null,"Total Liabilities",{"$f":"C44+C37","v":36325.327566320128},33705.078077744241,32040.761394509726,30187.063150548758,28797.812285417982,29745.849447227047,29765.841396149284,30668.286401438134,30928.574497163158,{"$f":"L44+L37","v":33395.808914436624}]
[null,"Net Assets",{"$f":"C29-C45","v":938691.80225364852},945542.54186359234,953023.7019975892,960544.30922199006,969226.4979941519,977173.98696590529,986075.38070384692,994866.47157047549,1004798.2740339831,{"$f":"L29-L45","v":1013979.1382741105}]
[]
[null,"EQUITY"]
[null,"Accumulated Surplus",570134.25031648309,576983.98992642702,584466.15006042377,591986.75728482485,600668.94605698658,608615.43502874009,617517.82876668172,626308.91963331017,636240.7220968178,645420.58633694495]
[null,"Asset Revaluation Reserves",368559,368559,368559,368559,368559,368559,368559,368559,368559,368559]
[null,"Total Equity",{"$f":"SUM(C49:C50)","v":938693.25031648309},945542.98992642702,953025.15006042377,960545.75728482485,969227.94605698658,977174.43502874009,986076.82876668172,994867.91963331017,1004799.7220968178,1013979.586336945]
[]
[]
[null,"Variance",{"$f":"C51-C46","v":1.4480628345627338},0.44806283467914909,1.4480628345627338,1.4480628347955644,1.4480628346791491,0.44806283479556441,1.4480628347955644,1.4480628346791491,1.4480628346791491,0.44806283444631845]

{"sheet":"Standard - Cashflow","index":2,"n_rows":70,"n_cols":12,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Cashflow Statement - Standard Scenario - Unconsolidated"]
[null,{"$f":"'Standard - P&L'!B9","v":"INSTRUCTIONS - HIDE THIS LINE BEFORE PRINT"},"New Projection","New Projection","New Projection","New Projection","New Projection","New Projection","New Projection","New Projection","New Projection","New Projection"]
[]
[null,"For the period ended 30 June",2020,{"$f":"C10+1","v":2021},2022,2023,2024,2025,2026,2027,2028,2029]
[null,"Cash Flows from Operating Activities","$'000","$'000","$'000","$'000","$'000","$'000","$'000","$'000","$'000","$'000"]
[null,"Receipts:"]
[]
[null,"Rates & Annual Charges",60081.411817780623,60442.504776662492,62088.563996079058,63793.510095981022,65542.805848380536,67369.327894590038,69207.311091954791,71091.243869253653,73022.274965984994,75000.581840134604]
[null,"User Charges & Fees",26455.710475,27268.488236874997,28289.119442796869,29345.446428866788,30421.101589588456,31181.629129328165,31961.169857561366,32760.199104000396,33579.204081600408,34418.684183640413]
[null,"Interest & Investment Revenue Received",1131.125,927.22422625504316,893.97147889947541,899.30483353696627,903.44385308631763,937.85308304104444,1002.5175914693272,1056.8800285939253,1119.3404927121508,1183.1488648420989]
[null,"Grants & Contributions",16062.915859999997,16445.871206499996,16838.028085662496,17239.609088784058,17650.842223003259,18071.961043717929,18503.204790253261,18944.818524860821,19397.053275130598,19860.166179900079]
[null,"Bonds & Deposits Received"]
[null,"Other",8282.1687384622928,8362.3728974890073,8566.6637881302704,8775.7185535439203,8990.0564591841812,9209.4000660908659,9434.0025309756766,9663.8820075630938,9906.2807572927359,10173.920211652803]
[null,"Payments:"]
[null,"Employee Benefits & On-Costs",-45406.707997323123,-46909.079363917241,-47531.792996697499,-49551.77895213999,-50548.134869255598,-53095.163944235428,-53881.514772121627,-56703.798972975434,-56845.114402306885,-60921.95485672183]
[null,"Materials & Contracts",-40038.429094600011,-41246.447239159999,-42878.858420138997,-43420.709880642469,-44526.467627658523,-46520.759318349992,-46942.553301308733,-48267.592133841448,-49583.281937187472,-51513.863985617158]
[null,"Borrowing Costs",-532.88579156842627,-515.9905827579779,-423.41180299418818,-342.1389014904272,-267.4977703821724,-234.11235458837541,-216.42512484848174,-198.0721902040805,-179.50648892181491,-155.2915882122839]
[null,"Bonds & Deposits Refunded"]
[null,"Other",-5336.0583611538095,-6671.4328315612656,-6611.1347029910612,-7047.3205104186854,-7315.1732153974517,-5777.6516269418717,-7858.742703605596,-6323.8100146757461,-7777.060485194208,-4145.0459532356581]
[null,"Net Cash provided (or used in) Operating Activities",{"$f":"'[3]cashflow note'!C62","v":20699.250646597531},{"$f":"'[3]cashflow note'!D62","v":18103.511326385051},{"$f":"'[3]cashflow note'!E62","v":19231.14886874643},{"$f":"'[3]cashflow note'!F62","v":19691.640756021166},{"$f":"'[3]cashflow note'!G62","v":20850.976490549016},{"$f":"'[3]cashflow note'!H62","v":21142.483972652379},{"$f":"'[3]cashflow note'!I62","v":21208.969960329978},{"$f":"'[3]cashflow note'!J62","v":22023.750222575156},{"$f":"'[3]cashflow note'!K62","v":22639.19025911051},{"$f":"'[3]cashflow note'!L62","v":23900.344896383063}]
[]
[]
[null,"Cash Flows from Investing Activities"]
[null,"Receipts:"]
[null,"Sale of Investment Securities"]
[null,"Sale of Investment Property"]
[null,"Sale of Real Estate Assets",0,0,0,0,0,0,0,0,0,0]
[null,"Sale of Infrastructure, Property, Plant & Equipment",250,250,250,250,250,250,250,250,250,250]
[null,"Payments:"]
[null,"Purchase of Investment Securities"]
[null,"Purchase of Investment Property"]
[null,"Purchase of Infrastructure, Property, Plant & Equipment",-15635,-16025.874999999998,-16426.521874999995,-16837.184921874992,-17258.114544921864,-17689.56740854491,-18131.806593758531,-18585.101758602494,-19049.729302567554,-19525.972535131739]
[null,"Purchase of Intangible Assets",-409.99999999999994,-420.24999999999989,-430.75624999999985,-441.52515624999984,-452.56328515624978,-463.87736728515597,-475.47430146728482,-487.36115900396692,-499.54518797906604,-512.03381767854262]
[null,"Net Cash provided (or used in) Investing Activities",{"$f":"SUM(C31:C39)","v":-15795},{"$f":"SUM(D31:D39)","v":-16196.124999999998},{"$f":"SUM(E31:E39)","v":-16607.278124999993},{"$f":"SUM(F32:F39)","v":-17028.710078124994},{"$f":"SUM(G32:G39)","v":-17460.677830078115},-17903.444775830067,-18357.280895225816,-18822.462917606459,-19299.274490546621,-19788.006352810284]
[]
[]
[null,"Cash Flows from Financing Activities"]
[null,"Receipts:"]
[null,"Proceeds from Borrowings & Advances",6500,0,0,0,0,0,0,0,0,0]
[null,"Proceeds from Finance Leases"]
[null,"Other Financing Activity Receipts"]
[]
[null,"Payments:"]
[null,"Repayment of Borrowings & Advances",-3301.813523058705,-3237.496220607763,-2410.5365582468007,-2497.3698959221215,-2013.9294622818259,-652.45885969100334,-677.19158012023479,-702.8687402396821,-787.58088336596643,-521.0518083389918]
[null,"Net Cash Flow provided (used in) Financing Activities",{"$f":"SUM(C45:C50)","v":3198.186476941295},-3237.496220607763,-2410.5365582468007,-2497.3698959221215,-2013.9294622818259,-652.45885969100334,-677.19158012023479,-702.8687402396821,-787.58088336596643,-521.0518083389918]
[]
[null,"Net Increase/(Decrease) in Cash & Cash Equivalents",{"$f":"+C26+C40+C51","v":8102.4371235388262},-1330.1098942227104,213.33418549963562,165.56078197405122,1376.3691981890745,2586.5803371313086,2174.4974849839264,2498.4185647290146,2552.3348851979226,3591.286735233788]
[]
[null,"plus: Cash - beginning of year",1682.5319266628976,9784.9690502017238,8454.8591559790129,8668.193341478649,8833.7541234526998,10210.123321641775,12796.703658773084,14971.201143757011,17469.619708486025,20021.954593683949]
[]
[null,"Cash - end of the year",{"$f":"+C55+C53","v":9784.9690502017238},8454.8591559790129,8668.193341478649,8833.7541234526998,10210.123321641775,12796.703658773084,14971.201143757011,{"$f":"+J55+J53","v":17469.619708486025},{"$f":"+K55+K53","v":20021.954593683949},{"$f":"+L55+L53","v":23613.241328917738}]
[null,"plus: Investments - end of the year",27304,27304,27304,27304,27304,27304,27304,27304,27304,27304]
[null,"Total Cash & Investments - end of the year",{"$f":"+C57+C58","v":37088.969050201726},35758.859155979015,35972.193341478647,36137.754123452702,37514.123321641775,40100.703658773084,42275.201143757011,44773.619708486025,47325.954593683949,50917.241328917735]
[]
[null,"Representing:"]
[null,"- External Restrictions"]
[null,"- Internal Restricitons"]
[null,"- Unrestricted"]
[]
[]
[null,"Less restricted Cash (NAL)",0,0,0,0,0,0,0,0,0,0]
[null,"Cash, Cash Equivalents & Investments - end of the year",{"$f":"C59+C67","v":37088.969050201726},{"$f":"D59+D67","v":35758.859155979015},35972.193341478647,36137.754123452702,37514.123321641775,40100.703658773084,42275.201143757011,44773.619708486025,47325.954593683949,50917.241328917735]
[]
[null,null,37088.871155114743,35758.459055821862,35971.999110399702,36137.94647919933,37514.257236414211,40100.511835715966,42275.3524527923,44773.475983900462,47326.326723658378,50916.940166374661]

{"sheet":"Standard - Ratios","index":3,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Ratios - Standard Scenario - Unconsolidated"]
[]
[null,null,{"$f":"'Standard - P&L'!C10","v":2020},{"$f":"'Standard - P&L'!D10","v":2021},{"$f":"'Standard - P&L'!E10","v":2022},{"$f":"'Standard - P&L'!F10","v":2023},{"$f":"'Standard - P&L'!G10","v":2024},{"$f":"'Standard - P&L'!H10","v":2025},{"$f":"'Standard - P&L'!I10","v":2026},{"$f":"'Standard - P&L'!J10","v":2027},{"$f":"'Standard - P&L'!K10","v":2028},{"$f":"'Standard - P&L'!L10","v":2029}]
[]
[null,"Operating Performance",{"$f":"(C13-C14-C15)/(C13-C14)","v":6.3124320141564067E-3},-3.4396935508445863E-3,9.0872343799063341E-4,-9.1056055211009284E-5,8.3041619628996949E-3,8.1707731754974424E-4,7.0612199668841288E-3,4.7409100392023134E-3,1.1915418345655966E-2,{"$f":"(L13-L14-L15)/(L13-L14)","v":4.8371179997674955E-3}]
[null,"Operating Perfomance Min Target",0,0,0,0,0,0,0,0,0,0]
[null,"Operating Revenue*",{"$f":"'Standard - P&L'!C20+'Standard - P&L'!C41-'Standard - P&L'!C19","v":113160.72307346229},{"$f":"'Standard - P&L'!D20+'Standard - P&L'!D41-'Standard - P&L'!D19","v":115906.51964211905},{"$f":"'Standard - P&L'!E20+'Standard - P&L'!E41-'Standard - P&L'!E19","v":119205.7357473641},{"$f":"'Standard - P&L'!F20+'Standard - P&L'!F41-'Standard - P&L'!F19","v":122636.0879964036},{"$f":"'Standard - P&L'!G20+'Standard - P&L'!G41-'Standard - P&L'!G19","v":126143.23790614586},{"$f":"'Standard - P&L'!H20+'Standard - P&L'!H41-'Standard - P&L'!H19","v":129425.23909956016},{"$f":"'Standard - P&L'!I20+'Standard - P&L'!I41-'Standard - P&L'!I19","v":132817.82573667404},{"$f":"'Standard - P&L'!J20+'Standard - P&L'!J41-'Standard - P&L'!J19","v":136282.32270608269},{"$f":"'Standard - P&L'!K20+'Standard - P&L'!K41-'Standard - P&L'!K19","v":139846.28280032641},{"$f":"'Standard - P&L'!L20+'Standard - P&L'!L41-'Standard - P&L'!L19","v":143517.63526649511}]
[null,"Capital Grants",{"$f":"'Standard - P&L'!C18","v":5865.51},{"$f":"'Standard - P&L'!D18","v":5982.8202000000001},{"$f":"'Standard - P&L'!E18","v":6102.4766040000004},{"$f":"'Standard - P&L'!F18","v":6224.5261360800005},{"$f":"'Standard - P&L'!G18","v":6349.0166588016},{"$f":"'Standard - P&L'!H18","v":6475.9969919776322},{"$f":"'Standard - P&L'!I18","v":6605.5169318171847},{"$f":"'Standard - P&L'!J18","v":6737.6272704535286},{"$f":"'Standard - P&L'!K18","v":6872.3798158625987},{"$f":"'Standard - P&L'!L18","v":7009.8274121798513}]
[null,"Operating Expenses",{"$f":"'Standard - P&L'!C29","v":106617.91933549164},{"$f":"'Standard - P&L'!D29","v":110301.80328217508},{"$f":"'Standard - P&L'!E29","v":113000.4795608674},{"$f":"'Standard - P&L'!F29","v":116422.16183792755},{"$f":"'Standard - P&L'!G29","v":118799.43063188688},{"$f":"'Standard - P&L'!H29","v":122848.78307064649},{"$f":"'Standard - P&L'!I29","v":125321.09592985746},{"$f":"'Standard - P&L'!J29","v":128930.53568851299},{"$f":"'Standard - P&L'!K29","v":131389.46330134926},{"$f":"'Standard - P&L'!L29","v":135847.50347983435}]
[]
[null,"Own Source Revenue ",{"$f":"+C19/C20","v":0.83912336926142095},0.83926088658320974,0.84005329302215148,0.84088927701806426,0.84169256916822555,0.8420949247120858,0.84252531935145569,0.8429341179403731,0.84335123372198539,{"$f":"+L19/L20","v":0.84378188492126638}]
[null,"Own Source Revenue Min Target",0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6]
[null,"Operating Revenue**",{"$f":"'Standard - P&L'!C13+'Standard - P&L'!C14+'Standard - P&L'!C16+'Standard - P&L'!C15+'Standard - P&L'!C41","v":94955.807213462293},{"$f":"'Standard - P&L'!D13+'Standard - P&L'!D14+'Standard - P&L'!D16+'Standard - P&L'!D15+'Standard - P&L'!D41","v":97275.808435619052},{"$f":"'Standard - P&L'!E13+'Standard - P&L'!E14+'Standard - P&L'!E16+'Standard - P&L'!E15+'Standard - P&L'!E41","v":100139.17086170161},{"$f":"'Standard - P&L'!F13+'Standard - P&L'!F14+'Standard - P&L'!F16+'Standard - P&L'!F15+'Standard - P&L'!F41","v":103123.37137161953},{"$f":"'Standard - P&L'!G13+'Standard - P&L'!G14+'Standard - P&L'!G16+'Standard - P&L'!G15+'Standard - P&L'!G41","v":106173.8259964226},{"$f":"'Standard - P&L'!H13+'Standard - P&L'!H14+'Standard - P&L'!H16+'Standard - P&L'!H15+'Standard - P&L'!H41","v":108988.33697538782},{"$f":"'Standard - P&L'!I13+'Standard - P&L'!I14+'Standard - P&L'!I16+'Standard - P&L'!I15+'Standard - P&L'!I41","v":111902.38104435729},{"$f":"'Standard - P&L'!J13+'Standard - P&L'!J14+'Standard - P&L'!J16+'Standard - P&L'!J15+'Standard - P&L'!J41","v":114877.01948111709},{"$f":"'Standard - P&L'!K13+'Standard - P&L'!K14+'Standard - P&L'!K16+'Standard - P&L'!K15+'Standard - P&L'!K41","v":117939.53513108895},{"$f":"'Standard - P&L'!L13+'Standard - P&L'!L14+'Standard - P&L'!L16+'Standard - P&L'!L15+'Standard - P&L'!L41","v":121097.58080460606}]
[null,"Total operating Revenue*",{"$f":"C13","v":113160.72307346229},115906.51964211905,119205.7357473641,122636.0879964036,126143.23790614586,129425.23909956016,132817.82573667404,136282.32270608269,139846.28280032641,{"$f":"L13","v":143517.63526649511}]
[]
[null,"Capital Expenditure Ratio",{"$f":"C24/C25","v":1.1366681095178153},1.1467421702337148,1.1383083138379102,1.1207902617813792,1.1413373487632372,1.1621477409582965,1.1833172463987625,1.2046819606219992,1.225150502004567,{"$f":"L24/L25","v":1.2427394385214632}]
[null,"Capital Expenditure Ratio Min Target",1,1,1,1,1,1,1,1,1,1]
[null,"Capital Expenditure",{"$f":"-'Standard - Cashflow'!C38-'Standard - Cashflow'!C39","v":16045},{"$f":"-'Standard - Cashflow'!D38-'Standard - Cashflow'!D39","v":16446.124999999996},{"$f":"-'Standard - Cashflow'!E38-'Standard - Cashflow'!E39","v":16857.278124999993},{"$f":"-'Standard - Cashflow'!F38-'Standard - Cashflow'!F39","v":17278.710078124994},{"$f":"-'Standard - Cashflow'!G38-'Standard - Cashflow'!G39","v":17710.677830078115},{"$f":"-'Standard - Cashflow'!H38-'Standard - Cashflow'!H39","v":18153.444775830067},{"$f":"-'Standard - Cashflow'!I38-'Standard - Cashflow'!I39","v":18607.280895225816},{"$f":"-'Standard - Cashflow'!J38-'Standard - Cashflow'!J39","v":19072.462917606459},{"$f":"-'Standard - Cashflow'!K38-'Standard - Cashflow'!K39","v":19549.274490546621},{"$f":"-'Standard - Cashflow'!L38-'Standard - Cashflow'!L39","v":20038.006352810284}]
[null,"Depreciation",{"$f":"'Standard - P&L'!C26+'Standard - P&L'!C27","v":14115.817858923157},{"$f":"'Standard - P&L'!D26+'Standard - P&L'!D27","v":14341.60653274672},{"$f":"'Standard - P&L'!E26+'Standard - P&L'!E27","v":14809.061763033378},{"$f":"'Standard - P&L'!F26+'Standard - P&L'!F27","v":15416.5419412748},{"$f":"'Standard - P&L'!G26+'Standard - P&L'!G27","v":15517.478552042088},{"$f":"'Standard - P&L'!H26+'Standard - P&L'!H27","v":15620.599805030726},{"$f":"'Standard - P&L'!I26+'Standard - P&L'!I27","v":15724.676498930537},{"$f":"'Standard - P&L'!J26+'Standard - P&L'!J27","v":15831.948631287714},{"$f":"'Standard - P&L'!K26+'Standard - P&L'!K27","v":15956.631008647906},{"$f":"'Standard - P&L'!L26+'Standard - P&L'!L27","v":16124.060870434996}]
[]
[null,"Debt Service Coverage ratio",{"$f":"C28/(C29+C30)","v":3.5627269509192905},{"$f":"D28/(D29+D30)","v":3.4731115758142672},4.9464097717335118,5.108854441075442,6.8416932571576687,16.674583519995934,17.472112702959368,17.081284499117967,16.980606581804896,{"$f":"L28/(L29+L30)","v":23.067004807950426}]
[null,"EBITDA",{"$f":"'Standard - P&L'!C37+'Standard - P&L'!C26+'Standard - P&L'!C27+'Standard - P&L'!C41-'Standard - P&L'!C19-'Standard - P&L'!C15","v":13661.986596893812},{"$f":"'Standard - P&L'!D37+'Standard - P&L'!D26+'Standard - P&L'!D27+'Standard - P&L'!D41-'Standard - P&L'!D19-'Standard - P&L'!D15","v":13036.278466435644},{"$f":"'Standard - P&L'!E37+'Standard - P&L'!E26+'Standard - P&L'!E27+'Standard - P&L'!E41-'Standard - P&L'!E19-'Standard - P&L'!E15","v":14017.869866630601},{"$f":"'Standard - P&L'!F37+'Standard - P&L'!F26+'Standard - P&L'!F27+'Standard - P&L'!F41-'Standard - P&L'!F19-'Standard - P&L'!F15","v":14506.637130133886},{"$f":"'Standard - P&L'!G37+'Standard - P&L'!G26+'Standard - P&L'!G27+'Standard - P&L'!G41-'Standard - P&L'!G19-'Standard - P&L'!G15","v":15608.825314413158},{"$f":"'Standard - P&L'!H37+'Standard - P&L'!H26+'Standard - P&L'!H27+'Standard - P&L'!H41-'Standard - P&L'!H19-'Standard - P&L'!H15","v":14783.205758925715},{"$f":"'Standard - P&L'!I37+'Standard - P&L'!I26+'Standard - P&L'!I27+'Standard - P&L'!I41-'Standard - P&L'!I19-'Standard - P&L'!I15","v":15613.371782460605},{"$f":"'Standard - P&L'!J37+'Standard - P&L'!J26+'Standard - P&L'!J27+'Standard - P&L'!J41-'Standard - P&L'!J19-'Standard - P&L'!J15","v":15389.22834980996},{"$f":"'Standard - P&L'!K37+'Standard - P&L'!K26+'Standard - P&L'!K27+'Standard - P&L'!K41-'Standard - P&L'!K19-'Standard - P&L'!K15","v":16421.7301990503},{"$f":"'Standard - P&L'!L37+'Standard - P&L'!L26+'Standard - P&L'!L27+'Standard - P&L'!L41-'Standard - P&L'!L19-'Standard - P&L'!L15","v":15601.216380073796}]
[null,"Principal repayments",{"$f":"-'Standard - Cashflow'!C50","v":3301.813523058705},{"$f":"-'Standard - Cashflow'!D50","v":3237.496220607763},{"$f":"-'Standard - Cashflow'!E50","v":2410.5365582468007},{"$f":"-'Standard - Cashflow'!F50","v":2497.3698959221215},{"$f":"-'Standard - Cashflow'!G50","v":2013.9294622818259},{"$f":"-'Standard - Cashflow'!H50","v":652.45885969100334},{"$f":"-'Standard - Cashflow'!I50","v":677.19158012023479},{"$f":"-'Standard - Cashflow'!J50","v":702.8687402396821},{"$f":"-'Standard - Cashflow'!K50","v":787.58088336596643},{"$f":"-'Standard - Cashflow'!L50","v":521.0518083389918}]
[null,"Interest expense",{"$f":"'Standard - P&L'!C24","v":532.88579156842627},{"$f":"'Standard - P&L'!D24","v":515.9905827579779},{"$f":"'Standard - P&L'!E24","v":423.41180299418818},{"$f":"'Standard - P&L'!F24","v":342.1389014904272},{"$f":"'Standard - P&L'!G24","v":267.4977703821724},{"$f":"'Standard - P&L'!H24","v":234.11235458837541},{"$f":"'Standard - P&L'!I24","v":216.42512484848174},{"$f":"'Standard - P&L'!J24","v":198.0721902040805},{"$f":"'Standard - P&L'!K24","v":179.50648892181491},{"$f":"'Standard - P&L'!L24","v":155.2915882122839}]
[null,"Debt Service Coverage ratio Min Target",2,2,2,2,2,2,2,2,2,2]
[]
[null,"Cash Expense Cover Ratio",{"$f":"C35/(C36/12)","v":4.7039414434025826},4.3528542043292271,4.3228996545970277,4.215982152327781,4.3007958941328885,4.527736002877413,4.6296673963786281,4.788787089070496,4.9309621410544207,{"$f":"L35/(L36/12)","v":5.2108258875299001}]
[null,"Cash Expense Cover Ratio Min Target",3,3,3,3,3,3,3,3,3,3]
[null,"Cash & Cash Equivalents",{"$f":"'Standard - Cashflow'!C59","v":37088.969050201726},{"$f":"'Standard - Cashflow'!D59","v":35758.859155979015},{"$f":"'Standard - Cashflow'!E59","v":35972.193341478647},{"$f":"'Standard - Cashflow'!F59","v":36137.754123452702},{"$f":"'Standard - Cashflow'!G59","v":37514.123321641775},{"$f":"'Standard - Cashflow'!H59","v":40100.703658773084},{"$f":"'Standard - Cashflow'!I59","v":42275.201143757011},{"$f":"'Standard - Cashflow'!J59","v":44773.619708486025},{"$f":"'Standard - Cashflow'!K59","v":47325.954593683949},{"$f":"'Standard - Cashflow'!L59","v":50917.241328917735}]
[null,"Total Expenses - Depreciation and Interest Cost",{"$f":"-SUM('Standard - Cashflow'!C21:C25)-'Standard - Cashflow'!C50","v":94615.894767704056},{"$f":"-SUM('Standard - Cashflow'!D21:D25)-'Standard - Cashflow'!D50","v":98580.446238004253},{"$f":"-SUM('Standard - Cashflow'!E21:E25)-'Standard - Cashflow'!E50","v":99855.734481068546},{"$f":"-SUM('Standard - Cashflow'!F21:F25)-'Standard - Cashflow'!F50","v":102859.31814061369},{"$f":"-SUM('Standard - Cashflow'!G21:G25)-'Standard - Cashflow'!G50","v":104671.20294497559},{"$f":"-SUM('Standard - Cashflow'!H21:H25)-'Standard - Cashflow'!H50","v":106280.14610380666},{"$f":"-SUM('Standard - Cashflow'!I21:I25)-'Standard - Cashflow'!I50","v":109576.42748200468},{"$f":"-SUM('Standard - Cashflow'!J21:J25)-'Standard - Cashflow'!J50","v":112196.14205193639},{"$f":"-SUM('Standard - Cashflow'!K21:K25)-'Standard - Cashflow'!K50","v":115172.54419697635},{"$f":"-SUM('Standard - Cashflow'!L21:L25)-'Standard - Cashflow'!L50","v":117257.20819212592}]
[]
[null,"Rates and Annual Charges Outstanding",{"$f":"C39/C40","v":2.8999720292366849E-2},{"$f":"D39/D40","v":2.8827331405554917E-2},2.8899552960960081E-2,2.8908868219627286E-2,2.8878584195380759E-2,2.889566845865604E-2,2.8894373624554697E-2,2.8889542092863835E-2,2.8893194725358187E-2,2.8892370147592234E-2]
[null,"Rates, annual and extra charges outstanding",1713.5007599701823,1750.3299252737338,1803.0262362844896,1853.1423335686586,1901.9211480573053,1955.0651710158818,2008.2945122726037,2062.5994327057169,2118.8740503641147,2176.2261216079573]
[null,"Rates, annual and extra charges collectible",{"$f":"'Standard - P&L'!C13","v":59086.803},{"$f":"'Standard - P&L'!D13","v":60717.723074999994},{"$f":"'Standard - P&L'!E13","v":62389.41615187499},{"$f":"'Standard - P&L'!F13","v":64102.901555671859},{"$f":"'Standard - P&L'!G13","v":65859.224094563644},{"$f":"'Standard - P&L'!H13","v":67659.454696927729},{"$f":"'Standard - P&L'!I13","v":69504.691064350918},{"$f":"'Standard - P&L'!J13","v":71396.058340959687},{"$f":"'Standard - P&L'!K13","v":73334.709799483666},{"$f":"'Standard - P&L'!L13","v":75321.827544470754}]
[]
[]
[null,"*Operating revenue excludes 'Investment property fair value increases' and 'Gain on sale of assets'"]
[null,"**Operating revenue excludes all grants and contributions, 'Investment property fair value increases' and 'Gain on sale of assets'"]

{"sheet":"Standard - SS7 Ratios","index":4,"n_rows":76,"n_cols":13,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Special Schedule 7 Ratios - Standard Scenario - Unconsolidated"]
[]
[null,null,2020,{"$f":"C9+1","v":2021},{"$f":"D9+1","v":2022},2023,2024,2025,2026,2027,2028,2029]
[]
[null,"Building and Infrastructure Renewals Ratio",{"$f":"C12/C13","v":1.3598227169655741},1.2358596760323692,1.231979662481524,1.2160529435673446,1.2370270924146627,1.2580492477814078,1.2791122100401586,1.3002088493772523,1.3213321168843843,1.3424750552140565]
[null,"Asset Renewals (Building and Infrastructure)",{"$f":"C16","v":13193},{"$f":"D16","v":13555.807500000003},13928.592206250003,14311.62849192188,14705.198275449731,15109.591228024599,15525.104986795275,15952.045373932147,16390.726621715283,16841.471603812453]
[null,"Depreciation, Amortisation & Impairment",{"$f":"C25","v":9702},{"$f":"D25","v":10968.727083579473},11305.862126160617,11768.918917245568,11887.531296299545,12010.33366115884,12137.406605092023,12268.833104445132,12404.698570684526,12545.090903850794]
[]
[null,"Numerator:"]
[null,"Asset Renewals (Building & Infrastructure)",{"$f":"SUM(C17:C22)","v":13193},13555.807500000003,13928.592206250003,14311.62849192188,14705.198275449731,15109.591228024599,15525.104986795275,15952.045373932147,16390.726621715283,16841.471603812453]
[null,"- Buildings & other structures ",1118,{"$f":"C17*1.0275","v":1148.7450000000001},{"$f":"D17*1.0275","v":1180.3354875000002},1212.7947134062504,1246.1465680249223,1280.4155986456078,1315.6270276083621,1351.8067708675921,1388.981457066451,1427.1784471357785]
[null,"- Roads & bridges",7803,{"$f":"C18*1.0275","v":8017.5825000000004},8238.0660187500016,8464.6128342656266,8697.3896872079313,8936.5679036061501,9182.3235209553204,9434.8374177815931,9694.2954467705877,9960.8885715567794]
[null,"- Footpaths",488,501.42,515.20905000000005,529.37729887500006,543.93517459406257,558.8933918953993,574.26296017252287,590.05519157726724,606.28170934564218,622.95445635264741]
[null,"- Stormwater Drainage",2643,2715.6825000000003,2790.3637687500004,2867.0987723906255,2945.943988631368,3026.9574483187307,3110.1987781474959,3195.7292445465523,3283.6117987715829,3373.9111232378018]
[null,"- Other Infrastructure",560,575.40000000000009,591.22350000000017,607.48214625000026,624.18790527187537,641.35307266685197,658.99028216519048,677.11251492473332,695.73310908516351,714.86576958500552]
[null,"- Other Open Space/Recreational Assets",581,596.97750000000008,613.39438125000015,630.26272673437518,647.59495171957053,665.40381289185882,683.70241774638498,702.50423423441066,721.82310067585706,741.67323594444315]
[]
[null,"Denominator:"]
[null,"Depreciation, Amortisation & Impairment",{"$f":"SUM(C26:C33)","v":9702},10968.727083579473,11305.862126160617,11768.918917245568,11887.531296299545,12010.33366115884,12137.406605092023,12268.833104445132,12404.698570684526,12545.090903850794]
[null,"- Buildings",5074,{"$f":"$M26*'[4]Standard - P&L'!D$26","v":5736.4965275963168},{"$f":"$M26*'[4]Standard - P&L'!E$26","v":5912.8136140149372},{"$f":"$M26*'[4]Standard - P&L'!F$26","v":6154.9860788687056},{"$f":"$M26*'[4]Standard - P&L'!G$26","v":6217.0187555310395},{"$f":"$M26*'[4]Standard - P&L'!H$26","v":6281.2427383348931},{"$f":"$M26*'[4]Standard - P&L'!I$26","v":6347.7001764742208},{"$f":"$M26*'[4]Standard - P&L'!J$26","v":6416.4344654603965},{"$f":"$M26*'[4]Standard - P&L'!K$26","v":6487.4902743399243},{"$f":"$M26*'[4]Standard - P&L'!L$26","v":6560.9135736501148},0.35820017414632999]
[null,"- Other Structures",234,{"$f":"$M27*'[4]Standard - P&L'!D$26","v":264.94691931543338},{"$f":"$M27*'[4]Standard - P&L'!E$26","v":273.09033379229362},{"$f":"$M27*'[4]Standard - P&L'!F$26","v":284.27535729877803},{"$f":"$M27*'[4]Standard - P&L'!G$26","v":287.14041029750484},{"$f":"$M27*'[4]Standard - P&L'!H$26","v":290.10667137832144},{"$f":"$M27*'[4]Standard - P&L'!I$26","v":293.17608725191366},{"$f":"$M27*'[4]Standard - P&L'!J$26","v":296.3506621916207},{"$f":"$M27*'[4]Standard - P&L'!K$26","v":299.63245929051749},{"$f":"$M27*'[4]Standard - P&L'!L$26","v":303.0236017525807},1.6543901348457395E-2]
[null,"- Roads",2690,{"$f":"$M28*'[4]Standard - P&L'!D$26","v":3041.0479259690346},{"$f":"$M28*'[4]Standard - P&L'!E$26","v":3134.5176434850878},{"$f":"$M28*'[4]Standard - P&L'!F$26","v":3262.8988023383208},{"$f":"$M28*'[4]Standard - P&L'!G$26","v":3295.7837420918431},{"$f":"$M28*'[4]Standard - P&L'!H$26","v":3329.8303433167498},{"$f":"$M28*'[4]Standard - P&L'!I$26","v":3365.06095026414},{"$f":"$M28*'[4]Standard - P&L'!J$26","v":3401.4985678864678},{"$f":"$M28*'[4]Standard - P&L'!K$26","v":3439.1668762662662},{"$f":"$M28*'[4]Standard - P&L'!L$26","v":3478.090245436093},0.18989009954580752]
[null,"- Bridges",12,{"$f":"$M29*'[4]Standard - P&L'!D$26","v":13.567694303493029},{"$f":"$M29*'[4]Standard - P&L'!E$26","v":13.984711261056285},{"$f":"$M29*'[4]Standard - P&L'!F$26","v":14.557486291260323},{"$f":"$M29*'[4]Standard - P&L'!G$26","v":14.704203087781183},{"$f":"$M29*'[4]Standard - P&L'!H$26","v":14.856102659487297},{"$f":"$M29*'[4]Standard - P&L'!I$26","v":15.01328469568832},{"$f":"$M29*'[4]Standard - P&L'!J$26","v":15.17585183342581},{"$f":"$M29*'[4]Standard - P&L'!K$26","v":15.343909721847266},{"$f":"$M29*'[4]Standard - P&L'!L$26","v":15.517567088325611},8.4719836208316658E-4]
[null,"- Footpaths",119,{"$f":"$M30*'[4]Standard - P&L'!D$26","v":134.16942144565328},{"$f":"$M30*'[4]Standard - P&L'!E$26","v":138.29325580377883},{"$f":"$M30*'[4]Standard - P&L'!F$26","v":143.95736443579656},{"$f":"$M30*'[4]Standard - P&L'!G$26","v":145.40823053472505},{"$f":"$M30*'[4]Standard - P&L'!H$26","v":146.9103485215966},{"$f":"$M30*'[4]Standard - P&L'!I$26","v":148.46470421291784},{"$f":"$M30*'[4]Standard - P&L'!J$26","v":150.07231257498859},{"$f":"$M30*'[4]Standard - P&L'!K$26","v":151.73421836048965},{"$f":"$M30*'[4]Standard - P&L'!L$26","v":153.45149676233106},8.3778504694890926E-3]
[null,"- Stormwater Drainage",188,{"$f":"$M31*'[4]Standard - P&L'!D$26","v":212.56054408805744},{"$f":"$M31*'[4]Standard - P&L'!E$26","v":219.09380975654847},{"$f":"$M31*'[4]Standard - P&L'!F$26","v":228.06728522974507},{"$f":"$M31*'[4]Standard - P&L'!G$26","v":230.36584837523853},{"$f":"$M31*'[4]Standard - P&L'!H$26","v":232.74560833196765},{"$f":"$M31*'[4]Standard - P&L'!I$26","v":235.20812689911702},{"$f":"$M31*'[4]Standard - P&L'!J$26","v":237.75501205700434},{"$f":"$M31*'[4]Standard - P&L'!K$26","v":240.38791897560716},{"$f":"$M31*'[4]Standard - P&L'!L$26","v":243.10855105043456},1.3272774339302943E-2]
[null,"- Other Open Space/Recreational Assets",1115,{"$f":"$M32*'[4]Standard - P&L'!D$26","v":1261.0418094302131},{"$f":"$M32*'[4]Standard - P&L'!E$26","v":1299.8012188748423},{"$f":"$M32*'[4]Standard - P&L'!F$26","v":1353.0374758488067},{"$f":"$M32*'[4]Standard - P&L'!G$26","v":1366.6739869921064},{"$f":"$M32*'[4]Standard - P&L'!H$26","v":1380.7922082956802},{"$f":"$M32*'[4]Standard - P&L'!I$26","v":1395.4014053270309},{"$f":"$M32*'[4]Standard - P&L'!J$26","v":1410.5111176289654},{"$f":"$M32*'[4]Standard - P&L'!K$26","v":1426.1311647028042},{"$f":"$M32*'[4]Standard - P&L'!L$26","v":1442.2716521538191},7.8742381098063197E-2]
[null,"- Other Infrastructure",270,{"$f":"$M33*'[4]Standard - P&L'!D$26","v":304.89624143127389},{"$f":"$M33*'[4]Standard - P&L'!E$26","v":314.26753917207043},{"$f":"$M33*'[4]Standard - P&L'!F$26","v":327.13906693415561},{"$f":"$M33*'[4]Standard - P&L'!G$26","v":330.43611938930496},{"$f":"$M33*'[4]Standard - P&L'!H$26","v":333.84964032014511},{"$f":"$M33*'[4]Standard - P&L'!I$26","v":337.38186996699591},{"$f":"$M33*'[4]Standard - P&L'!J$26","v":341.03511481226332},{"$f":"$M33*'[4]Standard - P&L'!K$26","v":344.81174902706778},{"$f":"$M33*'[4]Standard - P&L'!L$26","v":348.71421595709501},1.9038429859035606E-2]
[]
[null,"Infrastructure Backlog Ratio",{"$f":"C36/C37","v":1.8926720739104098E-2},1.9145359756453189E-2,1.9578567029292875E-2,1.9599325087261428E-2,1.8378818190326222E-2,1.8278638432411343E-2,1.8675897192410609E-2,1.9074882355470193E-2,1.9475317780802654E-2,1.987692409521305E-2]
[null,"Estimated Cost to bring Assets to a Satisfactory Condition",{"$f":"C40","v":14422.333333333336},{"$f":"D40","v":14682.947500000006},15086.728556250007,15171.613591546884,14296.832965314423,14293.995871860569,14687.080758336737,15090.975479191,15505.977304868751,15932.391680752646]
[null,"Total (written down) value of Infrastructure, Building, Other Structure & Depreciable Land Improvement Assets",{"$f":"C49","v":762009.09455675841},{"$f":"D49","v":766919.3834318486},770573.68568791007,774088.57315233105,777897.29553120176,782005.50466137135,786419.01949991344,791143.82977378054,796186.09972841677,801552.17197763687]
[]
[null,"Numerator:"]
[null,"Estimated Cost to bring Assets to a Satisfactory Condition",{"$f":"SUM(C41:C46)","v":14422.333333333336},{"$f":"SUM(D41:D46)","v":14682.947500000006},15086.728556250007,15171.613591546884,14296.832965314423,14293.995871860569,14687.080758336737,15090.975479191,15505.977304868751,15932.391680752646]
[null,"- Roads",11320.666666666666,{"$f":"C41*1.0275","v":11631.985000000001},{"$f":"D41*1.0275","v":11951.864587500002},{"$f":"E41*1.0275-243-87","v":11950.540863656253},{"$f":"F41*1.0275-950-342","v":10987.180737406801},{"$f":"G41*1.0275-396","v":10893.328207685488},11192.894733396841,11500.699338565255,11816.9685703758,12141.935206061136]
[null,"- Other Structures",2.6666666666666665,{"$f":"C42*1.0275","v":2.74},2.8153500000000005,2.8927721250000009,2.9723233584375013,3.0540622507945328,3.1380489626913826,3.224345309165396,3.3130148051674446,3.4041227123095497]
[null,"- Stormwater Drainage",1006,1033.6650000000002,1062.0907875000003,1091.2982841562502,1121.3089869705473,1152.1449841122374,1183.8289711753239,1216.3842678826454,1249.8348352494183,1284.2052932187773]
[null,"- Other Infrastructure",839.33333333333337,862.41500000000008,886.13141250000012,910.50002634375016,935.53877706820333,961.266093437579,987.7009110071125,1014.8626860598082,1042.7714099264531,1071.4476236994306]
[null,"- Other Open Space/Recreational Assets",{"$f":"293-51","v":242},{"$f":"C45*1.0275-51","v":197.65500000000003},203.09051250000005,208.67550159375006,214.4140778875782,220.31046502948661,226.36900281779751,232.59415039528696,238.99048953115738,245.56272799326422]
[null,"- Buildings",{"$f":"1096.66666666667-85","v":1011.6666666666699},{"$f":"C46*1.0275-85","v":954.48750000000337},980.7359062500035,1007.7061436718786,1035.4180626228554,1063.8920593449839,1093.1490909769709,1123.2106909788376,1154.0989849807559,1185.8367070677268]
[]
[null,"Denominator:"]
[null,"Net carrying amount of infrastructure assets",{"$f":"SUM(C50:C57)","v":762009.09455675841},{"$f":"SUM(D50:D57)","v":766919.3834318486},770573.68568791007,774088.57315233105,777897.29553120176,782005.50466137135,786419.01949991344,791143.82977378054,796186.09972841677,801552.17197763687]
[null,"- Buildings",{"$f":"$M50*'[4]Standard - balance sheet'!C$24","v":90274.132959139592},{"$f":"$M50*'[4]Standard - balance sheet'!D$24","v":90855.847893966609},{"$f":"$M50*'[4]Standard - balance sheet'!E$24","v":91288.767881527208},{"$f":"$M50*'[4]Standard - balance sheet'!F$24","v":91705.171597133944},{"$f":"$M50*'[4]Standard - balance sheet'!G$24","v":92156.385516876762},{"$f":"$M50*'[4]Standard - balance sheet'!H$24","v":92643.079205823597},{"$f":"$M50*'[4]Standard - balance sheet'!I$24","v":93165.942027537603},{"$f":"$M50*'[4]Standard - balance sheet'!J$24","v":93725.683576446419},{"$f":"$M50*'[4]Standard - balance sheet'!K$24","v":94323.034121934936},{"$f":"$M50*'[4]Standard - balance sheet'!L$24","v":94958.745064435207},9.957890710861643E-2]
[null,"- Other Structures",{"$f":"$M51*'[4]Standard - balance sheet'!C$24","v":3436.8055157757017},{"$f":"$M51*'[4]Standard - balance sheet'!D$24","v":3458.9518497374743},{"$f":"$M51*'[4]Standard - balance sheet'!E$24","v":3475.4334458754429},{"$f":"$M51*'[4]Standard - balance sheet'!F$24","v":3491.2862548659705},{"$f":"$M51*'[4]Standard - balance sheet'!G$24","v":3508.4643150404036},{"$f":"$M51*'[4]Standard - balance sheet'!H$24","v":3526.9931172546858},{"$f":"$M51*'[4]Standard - balance sheet'!I$24","v":3546.8989061086659},{"$f":"$M51*'[4]Standard - balance sheet'!J$24","v":3568.208696406728},{"$f":"$M51*'[4]Standard - balance sheet'!K$24","v":3590.9502900647453},{"$f":"$M51*'[4]Standard - balance sheet'!L$24","v":3615.1522934737704},3.7910454078879142E-3]
[null,"- Roads",{"$f":"$M52*'[4]Standard - balance sheet'!C$24","v":407593.27957316692},{"$f":"$M52*'[4]Standard - balance sheet'!D$24","v":410219.75839152507},{"$f":"$M52*'[4]Standard - balance sheet'!E$24","v":412174.41884340084},{"$f":"$M52*'[4]Standard - balance sheet'!F$24","v":414054.50730847003},{"$f":"$M52*'[4]Standard - balance sheet'!G$24","v":416091.76599275204},{"$f":"$M52*'[4]Standard - balance sheet'!H$24","v":418289.21802383597},{"$f":"$M52*'[4]Standard - balance sheet'!I$24","v":420649.97592073824},{"$f":"$M52*'[4]Standard - balance sheet'!J$24","v":423177.24354607641},{"$f":"$M52*'[4]Standard - balance sheet'!K$24","v":425874.31811117567},{"$f":"$M52*'[4]Standard - balance sheet'!L$24","v":428744.59223534272},0.44960490889548338]
[null,"- Bridges",{"$f":"$M53*'[4]Standard - balance sheet'!C$24","v":11417.759327407563},{"$f":"$M53*'[4]Standard - balance sheet'!D$24","v":11491.333904147277},{"$f":"$M53*'[4]Standard - balance sheet'!E$24","v":11546.089082225017},{"$f":"$M53*'[4]Standard - balance sheet'!F$24","v":11598.755302901851},{"$f":"$M53*'[4]Standard - balance sheet'!G$24","v":11655.824274620822},{"$f":"$M53*'[4]Standard - balance sheet'!H$24","v":11717.380683133528},{"$f":"$M53*'[4]Standard - balance sheet'!I$24","v":11783.511718280459},{"$f":"$M53*'[4]Standard - balance sheet'!J$24","v":11854.307128676524},{"$f":"$M53*'[4]Standard - balance sheet'!K$24","v":11929.859277879337},{"$f":"$M53*'[4]Standard - balance sheet'!L$24","v":12010.263202074908},1.2594615513694023E-2]
[null,"- Footpaths",{"$f":"$M54*'[4]Standard - balance sheet'!C$24","v":28872.455469486435},{"$f":"$M54*'[4]Standard - balance sheet'!D$24","v":29058.505869542118},{"$f":"$M54*'[4]Standard - balance sheet'!E$24","v":29196.967050535703},{"$f":"$M54*'[4]Standard - balance sheet'!F$24","v":29330.145817720604},{"$f":"$M54*'[4]Standard - balance sheet'!G$24","v":29474.45796315969},{"$f":"$M54*'[4]Standard - balance sheet'!H$24","v":29630.117634438484},{"$f":"$M54*'[4]Standard - balance sheet'!I$24","v":29797.34531131266},{"$f":"$M54*'[4]Standard - balance sheet'!J$24","v":29976.367943993122},{"$f":"$M54*'[4]Standard - balance sheet'!K$24","v":30167.41909518055},{"$f":"$M54*'[4]Standard - balance sheet'!L$24","v":30370.739085937061},3.1848409582565504E-2]
[null,"- Stormwater Drainage",{"$f":"$M55*'[4]Standard - balance sheet'!C$24","v":193092.21203966092},{"$f":"$M55*'[4]Standard - balance sheet'!D$24","v":194336.47348931778},{"$f":"$M55*'[4]Standard - balance sheet'!E$24","v":195262.46940081654},{"$f":"$M55*'[4]Standard - balance sheet'!F$24","v":196153.13776740647},{"$f":"$M55*'[4]Standard - balance sheet'!G$24","v":197118.2635571569},{"$f":"$M55*'[4]Standard - balance sheet'!H$24","v":198159.27893890557},{"$f":"$M55*'[4]Standard - balance sheet'!I$24","v":199277.65842955935},{"$f":"$M55*'[4]Standard - balance sheet'!J$24","v":200474.91981891249},{"$f":"$M55*'[4]Standard - balance sheet'!K$24","v":201752.62511954035},{"$f":"$M55*'[4]Standard - balance sheet'!L$24","v":203112.38154235479},0.21299469533313281]
[null,"- Other Open Space/Recreational Assets",{"$f":"$M56*'[4]Standard - balance sheet'!C$24","v":21523.29005094503},{"$f":"$M56*'[4]Standard - balance sheet'!D$24","v":21661.983371598857},{"$f":"$M56*'[4]Standard - balance sheet'!E$24","v":21765.200784557404},{"$f":"$M56*'[4]Standard - balance sheet'!F$24","v":21864.480363939812},{"$f":"$M56*'[4]Standard - balance sheet'!G$24","v":21972.0594428111},{"$f":"$M56*'[4]Standard - balance sheet'!H$24","v":22088.097659848409},{"$f":"$M56*'[4]Standard - balance sheet'!I$24","v":22212.759374114881},{"$f":"$M56*'[4]Standard - balance sheet'!J$24","v":22346.213768145812},{"$f":"$M56*'[4]Standard - balance sheet'!K$24","v":22488.634953829856},{"$f":"$M56*'[4]Standard - balance sheet'!L$24","v":22640.202081150659},2.3741747834066271E-2]
[null,"- Other Infrastructure",{"$f":"$M57*'[4]Standard - balance sheet'!C$24","v":5799.1596211763062},{"$f":"$M57*'[4]Standard - balance sheet'!D$24","v":5836.5286620134075},{"$f":"$M57*'[4]Standard - balance sheet'!E$24","v":5864.3391989719621},{"$f":"$M57*'[4]Standard - balance sheet'!F$24","v":5891.0887398924751},{"$f":"$M57*'[4]Standard - balance sheet'!G$24","v":5920.0744687841561},{"$f":"$M57*'[4]Standard - balance sheet'!H$24","v":5951.3393981310755},{"$f":"$M57*'[4]Standard - balance sheet'!I$24","v":5984.9278122615169},{"$f":"$M57*'[4]Standard - balance sheet'!J$24","v":6020.8852951231465},{"$f":"$M57*'[4]Standard - balance sheet'!K$24","v":6059.2587588112729},{"$f":"$M57*'[4]Standard - balance sheet'!L$24","v":6100.0964728678136},6.3968930888157549E-3]
[]
[null,"Asset Maintenance Ratio",{"$f":"C60/C61","v":0.87454451610894335},{"$f":"D60/D61","v":0.90278383754145453},0.92032560835002286,0.94337007694662156,0.96031747546586288,0.99133424415139992,1.0070062737233731,1.0333752877035558,1.0468422874782746,1.0799748187734264]
[null,"Actual Asset Maintenance",{"$f":"C64","v":10532.139607500005},{"$f":"D64","v":10942.284983880672},11208.053942728026,11541.102147602664,11806.240487470384,12251.928405135668,12515.860568048487,12920.759670161044,13172.56592005042,13681.066577090816]
[null,"Required Asset Maintenance",{"$f":"C70","v":12043},{"$f":"D70","v":12120.603547444676},12178.357139080414,12233.90738124471,12294.101470706881,12359.028730641239,12428.781125435791,12503.453318372387,12583.142730870808,12667.949603333334]
[]
[null,"Numerator:"]
[null,"Actual Asset Maintenance",{"$f":"C66*C67","v":10532.139607500005},10942.284983880672,11208.053942728026,11541.102147602664,11806.240487470384,12251.928405135668,12515.860568048487,12920.759670161044,13172.56592005042,13681.066577090816]
[]
[null,null,{"$f":"'Standard - P&L'!C23+'Standard - P&L'!C25","v":84257.116860000038},{"$f":"'Standard - P&L'!D23+'Standard - P&L'!D25","v":87538.279871045379},{"$f":"'Standard - P&L'!E23+'Standard - P&L'!E25","v":89664.431541824204},{"$f":"'Standard - P&L'!F23+'Standard - P&L'!F25","v":92328.817180821308},{"$f":"'Standard - P&L'!G23+'Standard - P&L'!G25","v":94449.923899763075},{"$f":"'Standard - P&L'!H23+'Standard - P&L'!H25","v":98015.427241085345},{"$f":"'Standard - P&L'!I23+'Standard - P&L'!I25","v":100126.8845443879},{"$f":"'Standard - P&L'!J23+'Standard - P&L'!J25","v":103366.07736128835},{"$f":"'Standard - P&L'!K23+'Standard - P&L'!K25","v":105380.52736040336},{"$f":"'Standard - P&L'!L23+'Standard - P&L'!L25","v":109448.53261672653},"<<< total salaries and materials (not including NAP)"]
[null,null,0.125,0.125,0.125,0.125,0.125,0.125,0.125,0.125,0.125,0.125,"<<< per centage for asset maintenance"]
[]
[null,"Denominator:"]
[null,"Required Asset Maintenance",{"$f":"SUM(C71:C76)","v":12043},{"$f":"SUM(D71:D76)","v":12120.603547444676},12178.357139080414,12233.90738124471,12294.101470706881,12359.028730641239,12428.781125435791,12503.453318372387,12583.142730870808,12667.949603333334]
[null,"- Roads",5168,{"$f":"D52*$M$71","v":5201.3019291865885},{"$f":"E52*$M$71","v":5226.0856675884397},5249.9238849350377,5275.7549116178006,5303.6170787971378,5333.549851054735,5365.5938511457698,5399.7908854222651,5436.1839699432594,{"$f":"C71/C52","v":1.2679306207923614E-2}]
[null,"- Other Structures",202,{"$f":"D51*$M$72","v":203.30166209281947},{"$f":"E51*$M$72","v":204.27037632601872},205.20213327338962,206.21178253614468,207.30082235236489,208.47079526181435,209.72328907342211,211.05993785899724,212.4824229737884,{"$f":"C72/C51","v":5.8775510884388156E-2}]
[null,"- Stormwater Drainage",1220,{"$f":"D55*$M$73","v":1227.8615235308898},{"$f":"E55*$M$73","v":1233.7121738502121},1239.33961679968,1245.4374984856263,1252.014867672699,1259.0810406901658,1266.6456072751237,1274.7184365741416,1283.309683307039,{"$f":"C73/C55","v":6.3182247855206788E-3}]
[null,"- Other Infrastructure",35,{"$f":"D57*$M$74","v":35.225535511132087},{"$f":"E57*$M$74","v":35.393382036686418},35.554825072121965,35.729764300817145,35.918459318479073,36.121177396849021,36.338193651335516,36.569791213192595,36.816261406349476,{"$f":"C74/C57","v":6.0353572390374338E-3}]
[null,"- Other Open Space/Recreational Assets",3843,{"$f":"D56*$M$75","v":3867.7637991223023},{"$f":"E56*$M$75","v":3886.1933476281674},3903.9197929189909,3923.1281202297218,3943.8468331690015,3966.1052781740214,3989.9336629166387,4015.3630752085455,4042.4255024171716,{"$f":"C75/C56","v":0.178550769464321}]
[null,"- Buildings",1575,{"$f":"D50*$M$76","v":1585.1490980009439},{"$f":"E50*$M$76","v":1592.7021916508886},1599.9671282454883,1607.8393935367717,1616.3306693315581,1625.4529828582058,1635.2187143100982,1645.6406045936667,1656.7317632857264,{"$f":"C76/C50","v":1.7446858234715871E-2}]

{"sheet":"Standard - Graphs","index":5,"n_rows":72,"n_cols":2,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Graphs - Standard Scenario - Unconsolidated"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Special Schedule 7 Graphs - Standard Scenario - Unconsolidated"]

{"sheet":"Strategic - P&L","index":6,"n_rows":54,"n_cols":12,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Profit & Loss Statement - Strategic Scenario - Unconsolidated"]
[]
[]
[null,"For the period ended 30 June",2020,{"$f":"C10+1","v":2021},2022,2023,2024,2025,2026,2027,2028,2029]
[null,null,"$'000","$'000","$'000","$'000","$'000","$'000","$'000","$'000","$'000","$'000"]
[null,"Revenue"]
[null,"Rates & Annual Charges",61105.829020404672,65048.113258347104,69258.521240670496,73756.473558866855,78562.830131556606,83699.997723592431,89192.045518335159,91575.596656293535,94018.736572700873,96522.954987018398]
[null,"User Fees and Charges",26455.710475,27268.488236874997,28289.119442796869,29345.446428866788,30421.101589588456,31181.629129328165,31961.169857561366,32760.199104000396,33579.204081600408,34418.684183640413]
[null,"Interest & Investment Revenue",1131.125,881.13084785223748,850.89180935355716,857.00184015477976,848.5135315610147,844.41437861271845,877.37472586775993,855.87495518253081,843.88002162628516,800.1125559486137]
[null,"Other Revenues",9068.8437384622921,9433.9611280718746,9666.4425881282259,9904.6434765619852,10148.70423235918,10398.76873544559,10654.984390784288,10917.50221452265,11186.476922238613,11462.067019337183]
[null,"Operating Grants and Contributions",12339.405859999997,12647.891006499996,12964.088281662496,13288.190488704058,13620.395250921658,13960.905132194697,14309.927760499564,14667.675954512053,15034.367853374852,15410.227049709221]
[null,"Capital Grants and Contributions",5865.51,5982.8202000000001,6102.4766040000004,6224.5261360800005,6349.0166588016,6475.9969919776322,6605.5169318171847,6737.6272704535286,6872.3798158625987,7009.8274121798513]
[null,"Gain on Sale of assets",250,250,250,250,250,250,250,250,250,250]
[null,"Total Revenue",{"$f":"SUM(C13:C19)","v":116216.42409386695},{"$f":"SUM(D13:D19)","v":121512.40467764622},127381.53996661164,133626.28192923448,140200.5613947885,146811.71209115122,153851.01918486535,157764.47615496468,161785.04526740365,165873.87320783365]
[]
[null,"Operating Expenses"]
[null,"Employee Benefits & On-Costs",45345.37621595589,46631.21581554423,48993.304197792146,52243.321207178997,55481.674947684769,58137.370676855098,61012.5004570991,64211.592149099102,66915.354828346099,69542.080971892399]
[null,"Borrowing Costs",1082.8857915684264,1588.4905827579778,1939.4644345731356,2173.9663868705438,2491.5706977987534,2669.1807240414196,2489.1556030046568,2458.464777063386,2266.0227229457892,2067.9314694009267]
[null,"Materials & Contracts",40113.11048000001,41615.938242000004,42143.83669805,43225.932615501246,44328.080930888769,46186.28295416099,46827.190028015008,48047.86977871538,49349.066523183254,51182.793186262832]
[null,"Depreciation & Amortisation",14326.413652568588,14872.896273778533,15949.043873816354,16148.935700031407,16333.020007914871,16973.536526628814,17191.392083436851,17341.935580816382,17544.10323824672,17804.569543326492]
[null,"Amortisation - intangibles",262.741512,294.19320959999999,321.45456767999997,345.41615414399996,366.7917358151999,386.15367146465991,403.96122705454036,420.58322877351503,436.31618632694182,451]
[null,"Other",7713.0988250000019,7905.9262956250013,8103.5744530156253,8306.1638143410146,8563.8179096995409,8777.9133574420284,8997.3611913780787,9222.2952211625288,9452.852601691593,9689.1739167338819]
[null,"Total Operating Expenses",{"$f":"SUM(C23:C28)","v":108843.62647709291},{"$f":"SUM(D23:D28)","v":112908.66041930574},{"$f":"SUM(E23:E28)","v":117450.67822492725},122443.73587806719,127564.9562298019,133130.43791059303,136921.56058998825,141702.7407356303,145963.71610074039,150737.54908761653]
[]
[null,"Operating Surplus / (Deficit) ",{"$f":"C20-C29","v":7372.7976167740417},{"$f":"D20-D29","v":8603.7442583404772},9930.8617416843917,11182.546051167286,12635.605164986599,13681.27418055819,16929.458594877098,16061.735419334378,15821.329166663258,{"$f":"L20-L29","v":15136.324120217119}]
[]
[null,"Other Comprehensive Income",0,0,0,0,0,0,0,0,0,0]
[]
[null,"Total Comprehensive Income",{"$f":"SUM(C31:C34)","v":7372.7976167740417},{"$f":"SUM(D31:D34)","v":8603.7442583404772},9930.8617416843917,11182.546051167286,12635.605164986599,13681.27418055819,16929.458594877098,16061.735419334378,15821.329166663258,{"$f":"SUM(L31:L34)","v":15136.324120217119}]
[]
[null,"Net Operating Result before Capital Grants",{"$f":"+C35-C18","v":1507.2876167740415},2620.9240583404771,3828.3851376843913,4958.0199150872859,6286.5885061849986,7205.2771885805578,10323.941663059913,9324.1081488808486,8948.9493508006599,8126.496708037268]
[]
[null,"Adjustments for Underlying Result"]
[null,"Gain on Sale of assets",-250,-250,-250,-250,-250,-250,-250,-250,-250,-250]
[null,"Investment property fair value increases ",-786.67499999999995,-996.02324999999837,-1025.9039475000027,-1056.6810659250038,-1088.3814979027518,-1121.0329428398327,-1154.6639311250256,-1189.3038490587787,-1224.9829645305433,-1261.7324534664585]
[null,"NAP Profit",0,0,0,0,0,0,0,0,0,0]
[null,"Local election costs",0,500,0,0,0,550,0,0,0,600]
[null,"NAP dividend "]
[null,"Underlying result*",{"$f":"SUM(C37:C44)","v":470.6126167740415},1874.9008083404788,2552.4811901843887,3651.3388491622818,4948.2070082822465,6384.2442457407251,8919.2777319348879,7884.8042998220699,7473.9663862701163,{"$f":"SUM(L37:L44)","v":7214.7642545708095}]
[]
[null,"Less: SRV loan repayments",-550,-1128.9473684210525,-1684.5029239766081,-2155.0911592707257,-2780.0911592707257,-3246.7578259373922,-3246.7578259373922,-3477.5270567066232,-3477.5270567066232,-3477.5270567066232]
[]
[null,"Revised underlying result",{"$f":"C45+C47","v":-79.387383225958501},{"$f":"D45+D47","v":745.95343991942627},867.97826620778051,1496.2476898915561,2168.1158490115208,3137.4864198033329,5672.5199059974957,4407.2772431154463,3996.4393295634932,3737.2371978641863]
[]
[null,"Old result before NAL removal",470.6126167740365,1875.0163483789092,2552.057535273002,3651.5606596953294,4949.2641270012928,6383.5310930868127,8919.489797921553,7884.554908180955,7473.4852467629462,7214.7104930938549]
[]
[null,"*The surplus is positive compared to the consolidated model due to the interest earned on the dividend from NAP."]
[null,null,{"$f":"C51-C45","v":-5.0022208597511053E-12},{"$f":"D51-D45","v":0.11554003843048122},-0.42365491138662037,0.2218105330475737,1.0571187190462297,-0.71315265391240246,0.21206598666503851,-0.24939164111492573,-0.48113950717015541,-5.3761476954605314E-2]

{"sheet":"Strategic - Balance Sheet","index":7,"n_rows":58,"n_cols":12,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Balance Sheet - Strategic Scenario - Unconsolidated"]
[null,{"$f":"'Strategic - P&L'!#REF!","v":{"$error":"#REF!"}},"New Projection","New Projection","New Projection","New Projection","New Projection","New Projection","New Projection","New Projection","New Projection","New Projection"]
[]
[null,"As at 30 June",2020,{"$f":"C10+1","v":2021},{"$f":"D10+1","v":2022},{"$f":"E10+1","v":2023},2024,2025,2026,2027,2028,2029]
[null,null,"$'000","$'000","$'000","$'000","$'000","$'000","$'000","$'000",{"$f":"J11","v":"$'000"},{"$f":"K11","v":"$'000"}]
[null,"ASSETS"]
[null,"Current Assets"]
[null,"Cash and Cash Equivalents",7941.2339140895001,6731.6723741422829,6976.0736061911866,6636.5412624405835,6472.5751445087344,7790.9890347103938,6930.9982073012316,6451.2008650514017,4700.5022379445472,6493.6162050079784]
[null,"Investments",27304,27304,27304,27304,27304,27304,27304,27304,27304,27304]
[null,"Receivables",5994.0567213242794,6297.8695501033253,6630.7037379077919,6983.4066285862618,7356.259618324003,7730.551919106917,8127.7885881837656,8340.208302888359,8557.9385104605681,8781.1119732220814]
[null,"Inventories",2675,2675,2675,2675,2675,2675,2675,2675,2675,2675]
[]
[null,"Total Current Assets",{"$f":"SUM(C14:C17)","v":43914.290635413781},43008.541924245612,43585.777344098984,43598.947891026852,43807.834762832739,45500.540953817312,45037.786795484993,44770.409167939761,43237.440748405119,{"$f":"SUM(L14:L17)","v":45253.728178230063}]
[]
[null,"Non-Current Assets"]
[null,"Investments",0,{"$f":"C22","v":0},0,0,0,0,0,0,0,0]
[null,"Receivables",0,0,0,0,0,0,0,0,0,1]
[null,"Infrastructure, Property, Plant & Equipment",894378.98248262133,910066.84835884278,925272.91148877644,939834.31778358866,957578.03278270864,974209.05678985699,987561.76454813941,1003765.470105575,1017030.846610536,1029062.1953320269]
[null,"Inventories",16651,16651,16651,16651,16651,16651,16651,16651,16651,16651]
[null,"Investment Properties",33200.775000000001,34196.79825,35222.702197500003,36279.383263425007,37367.764761327759,38488.797704167591,39643.461635292617,40832.765484351396,42057.748448881939,43319.480902348398]
[null,"Intangibles",1060.966048,1187.0228383999997,1296.3245207199998,1392.4335228259997,1478.2050721670496,1555.9287679875456,1627.4418424002902,1694.219772630742,1757.4487742828662,1818.0837995090221]
[null,"Total Non-Current Assets",{"$f":"SUM(C22:C27)","v":945291.72353062138},962101.66944724275,978442.93820699654,994157.13456983957,1013075.0026162035,1030904.7832620121,1045483.6680258323,1062943.4553625572,1077497.0438337007,1090851.7600338843]
[null,"Total Assets",{"$f":"C28+C19","v":989206.01416603522},1005110.2113714884,1022028.7155510955,1037756.0824608664,1056882.8373790362,1076405.3242158294,1090521.4548213172,1107713.864530497,1120734.4845821059,1136105.4882121144]
[]
[null,"LIABILITIES"]
[null,"Current Liabilities"]
[null,"Trade & Other Payables",8824.8843056000023,9155.5064132400003,9271.6440735710003,9503.4351754102736,9752.0210547955303,10116.821581165417,10245.717120694551,10501.860048711915,10764.406549929712,11165.516713677955]
[null,"Borrowings",4366.4435890288169,4095.0394822234066,4652.4610551928508,4794.0206215525568,3899.2166856283916,3923.9494060576262,4180.3957969463017,4265.1079400725885,3998.5788650456147,3998.5788650456147]
[null,"Provisions",14197.944836383431,13710.535121754037,13802.166923387696,13868.902074313512,13979.831431326678,15414.173860067945,15420.13128979985,16477.180821767233,16659.530896935907,19475.883238897804]
[null,"Other Current Liabilities",0,0,0,0,0,0,0,0,0,1]
[null,"Total Current Liabilities",{"$f":"SUM(C33:C36)","v":27389.27273101225},26961.081017217446,27726.272052151548,28166.357871276341,27631.069171750598,29454.94484729099,29846.244207440704,31244.148810551735,31422.516311911233,{"$f":"SUM(L33:L36)","v":34640.978817621377}]
[]
[null,"Non Current Liabilities"]
[null,"Trade & Other Payables",0,0,0,0,0,0,0,0,0,0]
[null,"Borrowings",21721.19095074711,28626.151468523705,33973.690413330856,37179.669791778295,43280.453106149907,46356.503700092275,42176.107903145974,40910.999963073387,36912.421098027771,32913.842232982155]
[null,"Provisions",811.42935182400333,1635.1134949550315,2510.025953136405,3408.7816141680973,4333.724252505287,5275.2803267575327,6251.3002038523482,7249.0355460887376,8268.5919530359752,9283.3421268912007]
[null,"Other Non-current Liabilities",0,0,0,0,0,0,0,0,0,1]
[null,"Total Non-Current Liabilities",{"$f":"SUM(C40:C43)","v":22532.620302571115},30261.264963478738,36483.716366467263,40588.451405946391,47614.177358655194,51631.784026849811,48427.408106998322,48160.035509162124,{"$f":"SUM(K40:K43)","v":45181.013051063746},{"$f":"SUM(L40:L43)","v":42198.184359873354}]
[null,"Total Liabilities",{"$f":"C44+C37","v":49921.893033583365},57222.345980696184,64209.988418618814,68754.809277222725,75245.246530405799,81086.728874140797,78273.652314439023,79404.184319713851,76603.529362974979,{"$f":"L44+L37","v":76839.163177494731}]
[null,"Net Assets",{"$f":"C29-C45","v":939284.12113245181},947887.86539079226,957818.72713247675,969001.2731836437,981637.59084863041,995318.5953416886,1012247.8025068782,1028309.6802107831,1044130.955219131,{"$f":"L29-L45","v":1059266.3250346198}]
[]
[null,"EQUITY"]
[null,"Accumulated Surplus",570726.56919528637,579330.31345362682,589261.1751953112,600442.7212464785,613080.03891146509,626761.04340452328,643689.25056971295,659752.12827361771,675572.40328196553,690707.7730974569]
[null,"Asset Revaluation Reserves",368559,368559,368559,368559,368559,368558,368559,368558,368559,368560]
[null,"Total Equity",{"$f":"SUM(C49:C50)","v":939285.56919528637},947889.31345362682,957820.1751953112,969001.7212464785,981639.03891146509,995319.04340452328,1012248.250569713,1028310.1282736177,1044131.4032819655,1059267.7730974569]
[]
[]
[null,"Variance",{"$f":"C51-C46","v":1.4480628345627338},1.4480628345627338,1.4480628344463184,0.44806283479556441,1.4480628346791491,0.44806283467914909,0.44806283479556441,0.44806283456273377,0.44806283456273377,1.4480628371238708]
[]
[null,"Total Borrowings",{"$f":"C41+C34","v":26087.634539775929},32721.190950747114,38626.151468523705,41973.690413330849,47179.669791778302,50280.4531061499,46356.503700092275,45176.107903145974,40910.999963073387,36912.421098027771]
[null,"Total current Assets",{"$f":"C19","v":43914.290635413781},43008.541924245612,43585.777344098984,43598.947891026852,43807.834762832739,45500.540953817312,45037.786795484993,44770.409167939761,43237.440748405119,45253.728178230063]
[null,null,{"$f":"C57-C56","v":17826.656095637853},{"$f":"D57-D56","v":10287.350973498498},4959.6258755752788,1625.2574776960028,-3371.835028945563,-4779.9121523325884,-1318.7169046072813,-405.69873520621331,2326.4407853317316,8341.3070802022921]

{"sheet":"Strategic - Cashflow","index":8,"n_rows":68,"n_cols":12,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Cashflow Statement - Strategic Scenario - Unconsolidated"]
[null,{"$f":"'Strategic - P&L'!#REF!","v":{"$error":"#REF!"}},"New Projection","New Projection","New Projection","New Projection","New Projection","New Projection","New Projection","New Projection","New Projection","New Projection"]
[]
[null,"For the period ended 30 June",2020,{"$f":"C10+1","v":2021},2022,2023,2024,2025,2026,2027,2028,2029]
[null,"Cash Flows from Operating Activities","$'000","$'000","$'000","$'000","$'000","$'000","$'000","$'000","$'000","$'000"]
[null,"Receipts:"]
[]
[null,"Rates & Annual Charges",61581.452749848766,64744.300429568058,68925.687052866037,73403.770668188386,78189.977141818861,83325.705422809522,88794.808849258305,91363.176941588943,93801.006365128662,96298.78152425689]
[null,"User Charges & Fees",26455.710475,27268.488236874997,28289.119442796869,29345.446428866788,30421.101589588456,31181.629129328165,31961.169857561366,32760.199104000396,33579.204081600408,34418.684183640413]
[null,"Interest & Investment Revenue Received",1131.125,881.13084785223748,850.89180935355716,857.00184015477976,848.5135315610147,844.41437861271845,877.37472586775993,855.87495518253081,843.88002162628516,800.1125559486137]
[null,"Grants & Contributions",16062.915859999997,16445.871206499996,16838.028085662496,17239.609088784058,17650.842223003259,18071.961043717929,18503.204790253261,18944.818524860821,19397.053275130598,19860.166179900079]
[null,"Bonds & Deposits Received"]
[null,"Other",8282.1687384622928,8437.9378780718762,8640.5386406282232,8847.9624106369811,9060.3227344564275,9277.7357926057575,9500.3204596592623,9728.1983654638716,9961.4939577080695,10200.334565870724]
[null,"Payments:"]
[null,"Employee Benefits & On-Costs",-44550.483808589917,-46967.490244045868,-49959.848457607179,-53237.312019136501,-56517.546943035122,-60714.269179848612,-62250.477763925781,-66578.377023302863,-68537.261310461967,-73803.18348770951]
[null,"Materials & Contracts",-40804.055453400011,-41946.56034964,-42259.974358380998,-43429.223717340516,-44575.954310274028,-46350.353168030873,-46700.336997231643,-47991.870422162428,-49191.66718271649,-51154.458862284402]
[null,"Borrowing Costs",-1082.8857915684264,-1588.4905827579778,-1939.4644345731356,-2173.9663868705438,-2491.5706977987534,-2669.1807240414196,-2489.1556030046568,-2458.464777063386,-2266.0227229457892,-2067.9314694009267]
[null,"Bonds & Deposits Refunded"]
[null,"Other",-7920.9936929319556,-6572.1332233417234,-5938.2106127235602,-5911.5999867474202,-5994.9021602283392,-3296.515298715276,-6775.6154986663569,-4600.4396167202831,-6523.94663502412,-1222.7485576056351]
[null,"Net Cash provided (or used in) Operating Activities",{"$f":"'[5]cashflow note'!C62","v":19154.954076820755},{"$f":"'[5]cashflow note'!D62","v":20703.054199081595},{"$f":"'[5]cashflow note'!E62","v":23446.767168022307},{"$f":"'[5]cashflow note'!F62","v":24941.688326536001},{"$f":"'[5]cashflow note'!G62","v":26590.783109091786},{"$f":"'[5]cashflow note'!H62","v":29671.127396437922},{"$f":"'[5]cashflow note'!I62","v":31421.292819771519},{"$f":"'[5]cashflow note'!J62","v":32023.116051847599},{"$f":"'[5]cashflow note'!K62","v":31063.73985004564},{"$f":"'[5]cashflow note'!L62","v":33329.756632618715}]
[]
[]
[null,"Cash Flows from Investing Activities"]
[null,"Receipts:"]
[null,"Sale of Investment Securities"]
[null,"Sale of Investment Property"]
[null,"Sale of Real Estate Assets",0,0,0,0,0,0,0,0,0,0]
[null,"Sale of Infrastructure, Property, Plant & Equipment",250,250,250,250,250,250,250,250,250,250]
[null,"Payments:"]
[null,"Purchase of Investment Securities"]
[null,"Purchase of Investment Property"]
[null,"Purchase of Infrastructure, Property, Plant & Equipment",-26385.045999999998,-28375.922149999999,-28926.570203749998,-28437.234458843745,-31758.165320314834,-31239.619453322706,-28131.859939655769,-31085.156438147162,-28299.785349100839,-27276.029982828361]
[null,"Purchase of Intangible Assets",-409.99999999999994,-420.24999999999989,-430.75624999999985,-441.52515624999984,-452.56328515624978,-463.87736728515597,-475.47430146728482,-487.36115900396692,-499.54518797906604,-512.03381767854262]
[null,"Net Cash provided (or used in) Investing Activities",{"$f":"SUM(C31:C39)","v":-26545.045999999998},{"$f":"SUM(D31:D39)","v":-28546.172149999999},{"$f":"SUM(E31:E39)","v":-29107.326453749996},{"$f":"SUM(F32:F39)","v":-28628.759615093746},{"$f":"SUM(G32:G39)","v":-31960.728605471086},-31453.496820607863,-28357.334241123055,-31322.517597151127,-28549.330537079906,-27538.063800506905]
[]
[]
[null,"Cash Flows from Financing Activities"]
[null,"Receipts:"]
[null,"Proceeds from Borrowings & Advances",17500,11000,10000,8000,10000,7000,0,3000,0,0]
[null,"Proceeds from Finance Leases"]
[null,"Other Financing Activity Receipts"]
[]
[null,"Payments:"]
[null,"Repayment of Borrowings & Advances",-3851.813523058705,-4366.4435890288132,-4095.0394822234066,-4652.4610551928581,-4794.0206215525495,-3899.2166856283989,-3923.9494060576262,-4180.3957969463017,-4265.1079400725885,-3998.5788650456147]
[null,"Net Cash Flow provided (used in) Financing Activities",{"$f":"SUM(C45:C50)","v":13648.186476941295},6633.5564109711868,5904.9605177765934,3347.5389448071419,5205.9793784474505,3100.7833143716011,-3923.9494060576262,-1180.3957969463017,-4265.1079400725885,-3998.5788650456147]
[]
[null,"Net Increase/(Decrease) in Cash & Cash Equivalents",{"$f":"+C26+C40+C51","v":6258.0945537620519},-1209.5615399472172,244.40123204890369,-339.5323437506031,-163.96611793184911,1318.4138902016598,-859.99082740916219,-479.79734224982985,-1750.6986271068545,1793.1139670661955]
[]
[null,"plus: Cash - beginning of year",1683.1393603274482,7941.2339140895001,6731.6723741422829,6976.0736061911866,6636.5412624405835,6472.5751445087344,7790.9890347103938,6930.9982073012316,6451.2008650514017,4700.5022379445472]
[]
[null,"Cash - end of the year",{"$f":"+C55+C53","v":7941.2339140895001},6731.6723741422829,6976.0736061911866,6636.5412624405835,6472.5751445087344,7790.9890347103938,6930.9982073012316,{"$f":"+J55+J53","v":6451.2008650514017},{"$f":"+K55+K53","v":4700.5022379445472},{"$f":"+L55+L53","v":6493.6162050107432}]
[null,"plus: Investments - end of the year",27304,27304,27304,27304,27304,27304,27304,27304,27304,27304]
[null,"Total Cash & Investments - end of the year",{"$f":"+C57+C58","v":35245.233914089498},34035.672374142283,34280.073606191188,33940.541262440587,33776.575144508737,35094.989034710394,34234.998207301229,33755.200865051404,32004.502237944547,33797.616205010745]
[]
[null,"Representing:"]
[null,"- External Restrictions"]
[null,"- Internal Restricitons"]
[null,"- Unrestricted"]
[]
[]
[null,"Less restricted Cash (NAL)",0,0,0,0,0,0,0,0,0,0]
[null,"Cash, Cash Equivalents & Investments - end of the year",{"$f":"C59+C67","v":35245.233914089498},{"$f":"D59+D67","v":34035.672374142283},34280.073606191188,33940.541262440587,33776.575144508737,35094.989034710394,34234.998207301229,33755.200865051404,32004.502237944547,33797.616205010745]

{"sheet":"Strategic - Ratios","index":9,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Ratios - Strategic Scenario - Unconsolidated"]
[]
[null,null,{"$f":"'Strategic - P&L'!C10","v":2020},{"$f":"'Strategic - P&L'!D10","v":2021},{"$f":"'Strategic - P&L'!E10","v":2022},{"$f":"'Strategic - P&L'!F10","v":2023},{"$f":"'Strategic - P&L'!G10","v":2024},{"$f":"'Strategic - P&L'!H10","v":2025},{"$f":"'Strategic - P&L'!I10","v":2026},{"$f":"'Strategic - P&L'!J10","v":2027},{"$f":"'Strategic - P&L'!K10","v":2028},{"$f":"'Strategic - P&L'!L10","v":2029}]
[]
[null,"Operating Performance",{"$f":"(C13-C14-C15)/(C13-C14)","v":4.3051355493581587E-3},{"$f":"(D13-D14-D15)/(D13-D14)","v":1.2030608720721909E-2},2.1270116575472151E-2,2.8957029900342372E-2,3.7341248879493694E-2,4.1983647608946198E-2,6.115761424963035E-2,5.2710299496882392E-2,4.8710109962087356E-2,{"$f":"(L13-L14-L15)/(L13-L14)","v":4.2037921871450196E-2}]
[null,"Operating Perfomance Min Target",0,0,0,0,0,0,0,0,0,0]
[null,"Operating Revenue*",{"$f":"'Strategic - P&L'!C20+'Strategic - P&L'!C40+'Strategic - P&L'!C41+'Strategic - P&L'!C44","v":115179.74909386695},{"$f":"'Strategic - P&L'!D20+'Strategic - P&L'!D40+'Strategic - P&L'!D41+'Strategic - P&L'!D44","v":120266.38142764622},{"$f":"'Strategic - P&L'!E20+'Strategic - P&L'!E40+'Strategic - P&L'!E41+'Strategic - P&L'!E44","v":126105.63601911164},{"$f":"'Strategic - P&L'!F20+'Strategic - P&L'!F40+'Strategic - P&L'!F41+'Strategic - P&L'!F44","v":132319.60086330949},{"$f":"'Strategic - P&L'!G20+'Strategic - P&L'!G40+'Strategic - P&L'!G41+'Strategic - P&L'!G44","v":138862.17989688576},{"$f":"'Strategic - P&L'!H20+'Strategic - P&L'!H40+'Strategic - P&L'!H41+'Strategic - P&L'!H44","v":145440.67914831138},{"$f":"'Strategic - P&L'!I20+'Strategic - P&L'!I40+'Strategic - P&L'!I41+'Strategic - P&L'!I44","v":152446.35525374033},{"$f":"'Strategic - P&L'!J20+'Strategic - P&L'!J40+'Strategic - P&L'!J41+'Strategic - P&L'!J44","v":156325.1723059059},{"$f":"'Strategic - P&L'!K20+'Strategic - P&L'!K40+'Strategic - P&L'!K41+'Strategic - P&L'!K44","v":160310.06230287312},{"$f":"'Strategic - P&L'!L20+'Strategic - P&L'!L40+'Strategic - P&L'!L41+'Strategic - P&L'!L44","v":164362.1407543672}]
[null,"Capital Grants",{"$f":"'Strategic - P&L'!C18","v":5865.51},{"$f":"'Strategic - P&L'!D18","v":5982.8202000000001},{"$f":"'Strategic - P&L'!E18","v":6102.4766040000004},{"$f":"'Strategic - P&L'!F18","v":6224.5261360800005},{"$f":"'Strategic - P&L'!G18","v":6349.0166588016},{"$f":"'Strategic - P&L'!H18","v":6475.9969919776322},{"$f":"'Strategic - P&L'!I18","v":6605.5169318171847},{"$f":"'Strategic - P&L'!J18","v":6737.6272704535286},{"$f":"'Strategic - P&L'!K18","v":6872.3798158625987},{"$f":"'Strategic - P&L'!L18","v":7009.8274121798513}]
[null,"Operating Expenses",{"$f":"'Strategic - P&L'!C29","v":108843.62647709291},{"$f":"'Strategic - P&L'!D29","v":112908.66041930574},{"$f":"'Strategic - P&L'!E29","v":117450.67822492725},{"$f":"'Strategic - P&L'!F29","v":122443.73587806719},{"$f":"'Strategic - P&L'!G29","v":127564.9562298019},{"$f":"'Strategic - P&L'!H29","v":133130.43791059303},{"$f":"'Strategic - P&L'!I29","v":136921.56058998825},{"$f":"'Strategic - P&L'!J29","v":141702.7407356303},{"$f":"'Strategic - P&L'!K29","v":145963.71610074039},{"$f":"'Strategic - P&L'!L29","v":150737.54908761653}]
[]
[null,"Own Source Revenue ",{"$f":"+C19/C20","v":0.84194343186870724},0.84508795404550796,0.84880481564858135,0.85253343799803827,0.85619257940101567,0.85948290228119728,0.86280128076854379,0.86307193582951258,0.86334764421805832,{"$f":"+L19/L20","v":0.86359356017761446}]
[null,"Own Source Revenue Min Target",0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6]
[null,"Operating Revenue**",{"$f":"'Strategic - P&L'!C13+'Strategic - P&L'!C14+'Strategic - P&L'!C16+'Strategic - P&L'!C15+'Strategic - P&L'!C41","v":96974.833233866957},{"$f":"'Strategic - P&L'!D13+'Strategic - P&L'!D14+'Strategic - P&L'!D16+'Strategic - P&L'!D15+'Strategic - P&L'!D41","v":101635.67022114623},{"$f":"'Strategic - P&L'!E13+'Strategic - P&L'!E14+'Strategic - P&L'!E16+'Strategic - P&L'!E15+'Strategic - P&L'!E41","v":107039.07113344915},{"$f":"'Strategic - P&L'!F13+'Strategic - P&L'!F14+'Strategic - P&L'!F16+'Strategic - P&L'!F15+'Strategic - P&L'!F41","v":112806.88423852542},{"$f":"'Strategic - P&L'!G13+'Strategic - P&L'!G14+'Strategic - P&L'!G16+'Strategic - P&L'!G15+'Strategic - P&L'!G41","v":118892.76798716249},{"$f":"'Strategic - P&L'!H13+'Strategic - P&L'!H14+'Strategic - P&L'!H16+'Strategic - P&L'!H15+'Strategic - P&L'!H41","v":125003.77702413907},{"$f":"'Strategic - P&L'!I13+'Strategic - P&L'!I14+'Strategic - P&L'!I16+'Strategic - P&L'!I15+'Strategic - P&L'!I41","v":131530.91056142357},{"$f":"'Strategic - P&L'!J13+'Strategic - P&L'!J14+'Strategic - P&L'!J16+'Strategic - P&L'!J15+'Strategic - P&L'!J41","v":134919.86908094032},{"$f":"'Strategic - P&L'!K13+'Strategic - P&L'!K14+'Strategic - P&L'!K16+'Strategic - P&L'!K15+'Strategic - P&L'!K41","v":138403.31463363566},{"$f":"'Strategic - P&L'!L13+'Strategic - P&L'!L14+'Strategic - P&L'!L16+'Strategic - P&L'!L15+'Strategic - P&L'!L41","v":141942.08629247814}]
[null,"Total operating Revenue*",{"$f":"C13","v":115179.74909386695},120266.38142764622,126105.63601911164,132319.60086330949,138862.17989688576,145440.67914831138,152446.35525374033,156325.1723059059,160310.06230287312,{"$f":"L13","v":164362.1407543672}]
[]
[null,"Capital Expenditure Ratio",{"$f":"C24/C25","v":1.836641374894332},1.8985957840861587,1.8043286479089624,1.7508271843845342,1.9288078871646306,1.8262708872586733,1.6258459683253799,1.7774797558612736,1.6017051580965984,{"$f":"L24/L25","v":1.52216909664509}]
[null,"Capital Expenditure Ratio Min Target",1,1,1,1,1,1,1,1,1,1]
[null,"Capital Expenditure",{"$f":"-'Strategic - Cashflow'!C38-'Strategic - Cashflow'!C39","v":26795.045999999998},{"$f":"-'Strategic - Cashflow'!D38-'Strategic - Cashflow'!D39","v":28796.172149999999},{"$f":"-'Strategic - Cashflow'!E38-'Strategic - Cashflow'!E39","v":29357.326453749996},{"$f":"-'Strategic - Cashflow'!F38-'Strategic - Cashflow'!F39","v":28878.759615093746},{"$f":"-'Strategic - Cashflow'!G38-'Strategic - Cashflow'!G39","v":32210.728605471086},{"$f":"-'Strategic - Cashflow'!H38-'Strategic - Cashflow'!H39","v":31703.496820607863},{"$f":"-'Strategic - Cashflow'!I38-'Strategic - Cashflow'!I39","v":28607.334241123055},{"$f":"-'Strategic - Cashflow'!J38-'Strategic - Cashflow'!J39","v":31572.517597151127},{"$f":"-'Strategic - Cashflow'!K38-'Strategic - Cashflow'!K39","v":28799.330537079906},{"$f":"-'Strategic - Cashflow'!L38-'Strategic - Cashflow'!L39","v":27788.063800506905}]
[null,"Depreciation",{"$f":"'Strategic - P&L'!C26+'Strategic - P&L'!C27","v":14589.155164568589},{"$f":"'Strategic - P&L'!D26+'Strategic - P&L'!D27","v":15167.089483378533},{"$f":"'Strategic - P&L'!E26+'Strategic - P&L'!E27","v":16270.498441496355},{"$f":"'Strategic - P&L'!F26+'Strategic - P&L'!F27","v":16494.351854175406},{"$f":"'Strategic - P&L'!G26+'Strategic - P&L'!G27","v":16699.811743730072},{"$f":"'Strategic - P&L'!H26+'Strategic - P&L'!H27","v":17359.690198093474},{"$f":"'Strategic - P&L'!I26+'Strategic - P&L'!I27","v":17595.353310491391},{"$f":"'Strategic - P&L'!J26+'Strategic - P&L'!J27","v":17762.518809589896},{"$f":"'Strategic - P&L'!K26+'Strategic - P&L'!K27","v":17980.419424573662},{"$f":"'Strategic - P&L'!L26+'Strategic - P&L'!L27","v":18255.569543326492}]
[]
[null,"Debt Service Coverage ratio",{"$f":"C28/(C29+C30)","v":2.8225919946239086},{"$f":"D28/(D29+D30)","v":2.6298963165813967},2.9782212539962676,2.8255905489200632,2.8548822338147923,3.402583411338528,3.9976355104634669,3.7342926361919488,3.7681845700272194,{"$f":"L28/(L29+L30)","v":3.9677211304288753}]
[null,"EBITDA",{"$f":"'Strategic - P&L'!C37+'Strategic - P&L'!C26+'Strategic - P&L'!C27+'Strategic - P&L'!C41-'Strategic - P&L'!C19-'Strategic - P&L'!C15","v":13928.642781342631},{"$f":"'Strategic - P&L'!D37+'Strategic - P&L'!D26+'Strategic - P&L'!D27+'Strategic - P&L'!D41-'Strategic - P&L'!D19-'Strategic - P&L'!D15","v":15660.859443866771},{"$f":"'Strategic - P&L'!E37+'Strategic - P&L'!E26+'Strategic - P&L'!E27+'Strategic - P&L'!E41-'Strategic - P&L'!E19-'Strategic - P&L'!E15","v":17972.087822327187},{"$f":"'Strategic - P&L'!F37+'Strategic - P&L'!F26+'Strategic - P&L'!F27+'Strategic - P&L'!F41-'Strategic - P&L'!F19-'Strategic - P&L'!F15","v":19288.68886318291},{"$f":"'Strategic - P&L'!G37+'Strategic - P&L'!G26+'Strategic - P&L'!G27+'Strategic - P&L'!G41-'Strategic - P&L'!G19-'Strategic - P&L'!G15","v":20799.505220451305},{"$f":"'Strategic - P&L'!H37+'Strategic - P&L'!H26+'Strategic - P&L'!H27+'Strategic - P&L'!H41-'Strategic - P&L'!H19-'Strategic - P&L'!H15","v":22349.520065221481},{"$f":"'Strategic - P&L'!I37+'Strategic - P&L'!I26+'Strategic - P&L'!I27+'Strategic - P&L'!I41-'Strategic - P&L'!I19-'Strategic - P&L'!I15","v":25637.256316558516},{"$f":"'Strategic - P&L'!J37+'Strategic - P&L'!J26+'Strategic - P&L'!J27+'Strategic - P&L'!J41-'Strategic - P&L'!J19-'Strategic - P&L'!J15","v":24791.448154229434},{"$f":"'Strategic - P&L'!K37+'Strategic - P&L'!K26+'Strategic - P&L'!K27+'Strategic - P&L'!K41-'Strategic - P&L'!K19-'Strategic - P&L'!K15","v":24610.505789217492},{"$f":"'Strategic - P&L'!L37+'Strategic - P&L'!L26+'Strategic - P&L'!L27+'Strategic - P&L'!L41-'Strategic - P&L'!L19-'Strategic - P&L'!L15","v":24070.221241948686}]
[null,"Principal repayments",{"$f":"-'Strategic - Cashflow'!C50","v":3851.813523058705},{"$f":"-'Strategic - Cashflow'!D50","v":4366.4435890288132},{"$f":"-'Strategic - Cashflow'!E50","v":4095.0394822234066},{"$f":"-'Strategic - Cashflow'!F50","v":4652.4610551928581},{"$f":"-'Strategic - Cashflow'!G50","v":4794.0206215525495},{"$f":"-'Strategic - Cashflow'!H50","v":3899.2166856283989},{"$f":"-'Strategic - Cashflow'!I50","v":3923.9494060576262},{"$f":"-'Strategic - Cashflow'!J50","v":4180.3957969463017},{"$f":"-'Strategic - Cashflow'!K50","v":4265.1079400725885},{"$f":"-'Strategic - Cashflow'!L50","v":3998.5788650456147}]
[null,"Interest expense",{"$f":"'Strategic - P&L'!C24","v":1082.8857915684264},{"$f":"'Strategic - P&L'!D24","v":1588.4905827579778},{"$f":"'Strategic - P&L'!E24","v":1939.4644345731356},{"$f":"'Strategic - P&L'!F24","v":2173.9663868705438},{"$f":"'Strategic - P&L'!G24","v":2491.5706977987534},{"$f":"'Strategic - P&L'!H24","v":2669.1807240414196},{"$f":"'Strategic - P&L'!I24","v":2489.1556030046568},{"$f":"'Strategic - P&L'!J24","v":2458.464777063386},{"$f":"'Strategic - P&L'!K24","v":2266.0227229457892},{"$f":"'Strategic - P&L'!L24","v":2067.9314694009267}]
[null,"Debt Service Coverage ratio Min Target",2,2,2,2,2,2,2,2,2,2]
[]
[null,"Cash Expense Cover Ratio",{"$f":"C35/(C36/12)","v":4.3065044974973681},{"$f":"D35/(D36/12)","v":4.0262575628823765},3.9480839391615783,3.7227560109532249,3.5438029657064463,3.6016552038274945,3.3635298970411864,3.2196476180960438,2.936551947096842,{"$f":"L35/(L36/12)","v":3.0667742733557759}]
[null,"Cash Expense Cover Ratio Min Target",3,3,3,3,3,3,3,3,3,3]
[null,"Cash & Cash Equivalents",{"$f":"'Strategic - Cashflow'!C59","v":35245.233914089498},{"$f":"'Strategic - Cashflow'!D59","v":34035.672374142283},{"$f":"'Strategic - Cashflow'!E59","v":34280.073606191188},{"$f":"'Strategic - Cashflow'!F59","v":33940.541262440587},{"$f":"'Strategic - Cashflow'!G59","v":33776.575144508737},{"$f":"'Strategic - Cashflow'!H59","v":35094.989034710394},{"$f":"'Strategic - Cashflow'!I59","v":34234.998207301229},{"$f":"'Strategic - Cashflow'!J59","v":33755.200865051404},{"$f":"'Strategic - Cashflow'!K59","v":32004.502237944547},{"$f":"'Strategic - Cashflow'!L59","v":33797.616205010745}]
[null,"Total Expenses - Depreciation and Interest Cost",{"$f":"-SUM('Strategic - Cashflow'!C21:C25)-'Strategic - Cashflow'!C50","v":98210.232269549015},{"$f":"-SUM('Strategic - Cashflow'!D21:D25)-'Strategic - Cashflow'!D50","v":101441.11798881438},{"$f":"-SUM('Strategic - Cashflow'!E21:E25)-'Strategic - Cashflow'!E50","v":104192.53734550829},{"$f":"-SUM('Strategic - Cashflow'!F21:F25)-'Strategic - Cashflow'!F50","v":109404.56316528784},{"$f":"-SUM('Strategic - Cashflow'!G21:G25)-'Strategic - Cashflow'!G50","v":114373.99473288881},{"$f":"-SUM('Strategic - Cashflow'!H21:H25)-'Strategic - Cashflow'!H50","v":116929.53505626458},{"$f":"-SUM('Strategic - Cashflow'!I21:I25)-'Strategic - Cashflow'!I50","v":122139.53526888607},{"$f":"-SUM('Strategic - Cashflow'!J21:J25)-'Strategic - Cashflow'!J50","v":125809.54763619528},{"$f":"-SUM('Strategic - Cashflow'!K21:K25)-'Strategic - Cashflow'!K50","v":130784.00579122094},{"$f":"-SUM('Strategic - Cashflow'!L21:L25)-'Strategic - Cashflow'!L50","v":132246.90124204609}]
[]
[null,"Rates and Annual Charges Outstanding",{"$f":"C39/C40","v":2.8731413086763177E-2},{"$f":"D39/D40","v":2.8661437324591754E-2},2.8746037527386987E-2,2.8487632704123012E-2,2.8410105896753791E-2,2.8331041761984716E-2,2.8202483807840992E-2,2.8207328211331473E-2,2.8205834444666487E-2,2.8196917561754027E-2]
[null,"Rates, annual and extra charges outstanding",1755.656815594368,1864.3724212370614,1990.9080506756427,2101.1473282963598,2231.9783235862028,2371.3081309851227,2515.437219519064,2583.1029110325808,2651.8769184663111,2721.6498045858525]
[null,"Rates, annual and extra charges collectible",{"$f":"'Strategic - P&L'!C13","v":61105.829020404672},{"$f":"'Strategic - P&L'!D13","v":65048.113258347104},{"$f":"'Strategic - P&L'!E13","v":69258.521240670496},{"$f":"'Strategic - P&L'!F13","v":73756.473558866855},{"$f":"'Strategic - P&L'!G13","v":78562.830131556606},{"$f":"'Strategic - P&L'!H13","v":83699.997723592431},{"$f":"'Strategic - P&L'!I13","v":89192.045518335159},{"$f":"'Strategic - P&L'!J13","v":91575.596656293535},{"$f":"'Strategic - P&L'!K13","v":94018.736572700873},{"$f":"'Strategic - P&L'!L13","v":96522.954987018398}]
[]
[]
[null,"*Operating revenue excludes 'Investment property fair value increases' and 'Gain on sale of assets'"]
[null,"**Operating revenue excludes all grants and contributions, 'Investment property fair value increases' and 'Gain on sale of assets'"]

{"sheet":"Strategic - SS7 Ratios","index":10,"n_rows":76,"n_cols":13,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Special Schedule 7 Ratios - Strategic Scenario - Unconsolidated"]
[]
[null,null,2020,{"$f":"C9+1","v":2021},{"$f":"D9+1","v":2022},2023,2024,2025,2026,2027,2028,2029]
[]
[null,"Building and Infrastructure Renewals Ratio",{"$f":"C12/C13","v":1.3598227169655741},{"$f":"D12/D13","v":1.1765134006382887},1.1327585079346183,1.1452419630532822,1.1589715073764177,1.1451380504305642,1.1575539262011072,1.1741325009732966,1.1879898846552766,1.2056310636817364]
[null,"Asset Renewals (Building and Infrastructure)",{"$f":"C16","v":13193},{"$f":"D16","v":13555.807500000003},13928.592206250003,14311.62849192188,14705.198275449731,15109.591228024599,15525.104986795275,15952.045373932147,16390.726621715283,16841.471603812453]
[null,"Depreciation, Amortisation & Impairment",{"$f":"C25","v":9702},{"$f":"D25","v":11522.01708254715},12296.170903758022,12496.598058427966,12688.14477479099,13194.558701759579,13411.992854402903,13586.23950934729,13797.02540688841,13969.009352149771]
[]
[null,"Numerator:"]
[null,"Asset Renewals (Building & Infrastructure)",{"$f":"SUM(C17:C22)","v":13193},13555.807500000003,13928.592206250003,14311.62849192188,14705.198275449731,15109.591228024599,15525.104986795275,15952.045373932147,16390.726621715283,16841.471603812453]
[null,"- Buildings & other structures ",1118,{"$f":"C17*1.0275","v":1148.7450000000001},{"$f":"D17*1.0275","v":1180.3354875000002},1212.7947134062504,1246.1465680249223,1280.4155986456078,1315.6270276083621,1351.8067708675921,1388.981457066451,1427.1784471357785]
[null,"- Roads & bridges",7803,{"$f":"C18*1.0275","v":8017.5825000000004},8238.0660187500016,8464.6128342656266,8697.3896872079313,8936.5679036061501,9182.3235209553204,9434.8374177815931,9694.2954467705877,9960.8885715567794]
[null,"- Footpaths",488,501.42,515.20905000000005,529.37729887500006,543.93517459406257,558.8933918953993,574.26296017252287,590.05519157726724,606.28170934564218,622.95445635264741]
[null,"- Stormwater Drainage",2643,2715.6825000000003,2790.3637687500004,2867.0987723906255,2945.943988631368,3026.9574483187307,3110.1987781474959,3195.7292445465523,3283.6117987715829,3373.9111232378018]
[null,"- Other Infrastructure",560,575.40000000000009,591.22350000000017,607.48214625000026,624.18790527187537,641.35307266685197,658.99028216519048,677.11251492473332,695.73310908516351,714.86576958500552]
[null,"- Other Open Space/Recreational Assets",581,596.97750000000008,613.39438125000015,630.26272673437518,647.59495171957053,665.40381289185882,683.70241774638498,702.50423423441066,721.82310067585706,741.67323594444315]
[]
[null,"Denominator:"]
[null,"Depreciation, Amortisation & Impairment",{"$f":"SUM(C26:C33)","v":9702},11522.01708254715,12296.170903758022,12496.598058427966,12688.14477479099,13194.558701759579,13411.992854402903,13586.23950934729,13797.02540688841,13969.009352149771]
[null,"- Buildings",5074,{"$f":"$M26*'[4]Strategic - P&L'!D$25","v":6025.8597448271776},{"$f":"$M26*'[4]Strategic - P&L'!E$25","v":6430.7317662898868},{"$f":"$M26*'[4]Strategic - P&L'!F$25","v":6535.5524686411527},{"$f":"$M26*'[4]Strategic - P&L'!G$25","v":6635.7288213679803},{"$f":"$M26*'[4]Strategic - P&L'!H$25","v":6900.5764843142724},{"$f":"$M26*'[4]Strategic - P&L'!I$25","v":7014.2916175393966},{"$f":"$M26*'[4]Strategic - P&L'!J$25","v":7105.4202711577491},{"$f":"$M26*'[4]Strategic - P&L'!K$25","v":7215.6584565093626},{"$f":"$M26*'[4]Strategic - P&L'!L$25","v":7305.6037434397913},0.35820017414632999]
[null,"- Other Structures",234,{"$f":"$M27*'[4]Strategic - P&L'!D$25","v":278.31150388368087},{"$f":"$M27*'[4]Strategic - P&L'!E$25","v":297.01100004610674},{"$f":"$M27*'[4]Strategic - P&L'!F$25","v":301.8522689346778},{"$f":"$M27*'[4]Strategic - P&L'!G$25","v":306.47903300845479},{"$f":"$M27*'[4]Strategic - P&L'!H$25","v":318.71133752532251},{"$f":"$M27*'[4]Strategic - P&L'!I$25","v":323.96340628935002},{"$f":"$M27*'[4]Strategic - P&L'!J$25","v":328.17229161184531},{"$f":"$M27*'[4]Strategic - P&L'!K$25","v":333.26377340030763},{"$f":"$M27*'[4]Strategic - P&L'!L$25","v":337.41800352395859},1.6543901348457395E-2]
[null,"- Roads",2690,{"$f":"$M28*'[4]Strategic - P&L'!D$25","v":3194.4459812765581},{"$f":"$M28*'[4]Strategic - P&L'!E$25","v":3409.0778938435774},{"$f":"$M28*'[4]Strategic - P&L'!F$25","v":3464.6457440027229},{"$f":"$M28*'[4]Strategic - P&L'!G$25","v":3517.7515182720072},{"$f":"$M28*'[4]Strategic - P&L'!H$25","v":3658.1533179115604},{"$f":"$M28*'[4]Strategic - P&L'!I$25","v":3718.4363091732071},{"$f":"$M28*'[4]Strategic - P&L'!J$25","v":3766.7456913456322},{"$f":"$M28*'[4]Strategic - P&L'!K$25","v":3825.1854730683949},{"$f":"$M28*'[4]Strategic - P&L'!L$25","v":3872.8675255118364},0.18989009954580752]
[null,"- Bridges",12,{"$f":"$M29*'[4]Strategic - P&L'!D$25","v":14.252082702436002},{"$f":"$M29*'[4]Strategic - P&L'!E$25","v":15.209667143186119},{"$f":"$M29*'[4]Strategic - P&L'!F$25","v":15.457584184421618},{"$f":"$M29*'[4]Strategic - P&L'!G$25","v":15.694516626322006},{"$f":"$M29*'[4]Strategic - P&L'!H$25","v":16.32092197853714},{"$f":"$M29*'[4]Strategic - P&L'!I$25","v":16.589875713252628},{"$f":"$M29*'[4]Strategic - P&L'!J$25","v":16.805408958785819},{"$f":"$M29*'[4]Strategic - P&L'!K$25","v":17.066139178394128},{"$f":"$M29*'[4]Strategic - P&L'!L$25","v":17.278873580174263},8.4719836208316658E-4]
[null,"- Footpaths",119,{"$f":"$M30*'[4]Strategic - P&L'!D$25","v":140.93726227964493},{"$f":"$M30*'[4]Strategic - P&L'!E$25","v":150.40670841595164},{"$f":"$M30*'[4]Strategic - P&L'!F$25","v":152.85833249039158},{"$f":"$M30*'[4]Strategic - P&L'!G$25","v":155.20133108251764},{"$f":"$M30*'[4]Strategic - P&L'!H$25","v":161.3957840099784},{"$f":"$M30*'[4]Strategic - P&L'!I$25","v":164.05543760883157},{"$f":"$M30*'[4]Strategic - P&L'!J$25","v":166.18682192577089},{"$f":"$M30*'[4]Strategic - P&L'!K$25","v":168.76515409745306},{"$f":"$M30*'[4]Strategic - P&L'!L$25","v":170.86886095950106},8.3778504694890926E-3]
[null,"- Stormwater Drainage",188,{"$f":"$M31*'[4]Strategic - P&L'!D$25","v":223.28262900483068},{"$f":"$M31*'[4]Strategic - P&L'!E$25","v":238.28478524324919},{"$f":"$M31*'[4]Strategic - P&L'!F$25","v":242.16881888927202},{"$f":"$M31*'[4]Strategic - P&L'!G$25","v":245.88076047904477},{"$f":"$M31*'[4]Strategic - P&L'!H$25","v":255.69444433041517},{"$f":"$M31*'[4]Strategic - P&L'!I$25","v":259.90805284095785},{"$f":"$M31*'[4]Strategic - P&L'!J$25","v":263.28474035431117},{"$f":"$M31*'[4]Strategic - P&L'!K$25","v":267.36951379484134},{"$f":"$M31*'[4]Strategic - P&L'!L$25","v":270.70235275606342},1.3272774339302943E-2]
[null,"- Other Open Space/Recreational Assets",1115,{"$f":"$M32*'[4]Strategic - P&L'!D$25","v":1324.6519089541905},{"$f":"$M32*'[4]Strategic - P&L'!E$25","v":1413.654062808354},{"$f":"$M32*'[4]Strategic - P&L'!F$25","v":1436.6965744742981},{"$f":"$M32*'[4]Strategic - P&L'!G$25","v":1458.7181286575951},{"$f":"$M32*'[4]Strategic - P&L'!H$25","v":1516.9390261162573},{"$f":"$M32*'[4]Strategic - P&L'!I$25","v":1541.9367815706469},{"$f":"$M32*'[4]Strategic - P&L'!J$25","v":1561.9693993360372},{"$f":"$M32*'[4]Strategic - P&L'!K$25","v":1586.2028247474097},{"$f":"$M32*'[4]Strategic - P&L'!L$25","v":1605.9753055350855},7.8742381098063197E-2]
[null,"- Other Infrastructure",270,{"$f":"$M33*'[4]Strategic - P&L'!D$25","v":320.27596961863128},{"$f":"$M33*'[4]Strategic - P&L'!E$25","v":341.79501996771029},{"$f":"$M33*'[4]Strategic - P&L'!F$25","v":347.3662668110303},{"$f":"$M33*'[4]Strategic - P&L'!G$25","v":352.69066529706953},{"$f":"$M33*'[4]Strategic - P&L'!H$25","v":366.76738557323739},{"$f":"$M33*'[4]Strategic - P&L'!I$25","v":372.81137366726045},{"$f":"$M33*'[4]Strategic - P&L'!J$25","v":377.65488465715907},{"$f":"$M33*'[4]Strategic - P&L'!K$25","v":383.5140720922459},{"$f":"$M33*'[4]Strategic - P&L'!L$25","v":388.29468684336052},1.9038429859035606E-2]
[]
[null,"Infrastructure Backlog Ratio",{"$f":"C36/C37","v":1.8926720739104098E-2},{"$f":"D36/D37","v":1.8487068919865551E-2},1.8690803867358975E-2,1.8512213603285105E-2,1.713097504701807E-2,1.6844114434229725E-2,1.708078898606142E-2,1.7276948333445129E-2,1.7529131939869311E-2,1.7807201502099645E-2]
[null,"Estimated Cost to bring Assets to a Satisfactory Condition",{"$f":"C40","v":14422.333333333336},14682.947500000006,15086.728556250007,15171.613591546884,14296.832965314423,14293.995871860569,14687.080758336737,15090.975479191,15505.977304868751,15932.391680752646]
[null,"Total (written down) value of Infrastructure, Building, Other Structure & Depreciable Land Improvement Assets",{"$f":"C49","v":762009.09455675841},794227.98517412506,807173.8734895715,819546.16107360541,834560.37534787157,848604.77098238305,859859.62184311042,873474.59678266966,884583.29585625546,894716.20113211276]
[]
[null,"Numerator:"]
[null,"Estimated Cost to bring Assets to a Satisfactory Condition",{"$f":"SUM(C41:C46)","v":14422.333333333336},{"$f":"SUM(D41:D46)","v":14682.947500000006},15086.728556250007,15171.613591546884,14296.832965314423,14293.995871860569,14687.080758336737,15090.975479191,15505.977304868751,15932.391680752646]
[null,"Roads",11320.666666666666,{"$f":"C41*1.0275","v":11631.985000000001},{"$f":"D41*1.0275","v":11951.864587500002},{"$f":"E41*1.0275-243-87","v":11950.540863656253},{"$f":"F41*1.0275-950-342","v":10987.180737406801},{"$f":"G41*1.0275-396","v":10893.328207685488},11192.894733396841,11500.699338565255,11816.9685703758,12141.935206061136]
[null,"Other Structures",2.6666666666666665,{"$f":"C42*1.0275","v":2.74},2.8153500000000005,2.8927721250000009,2.9723233584375013,3.0540622507945328,3.1380489626913826,3.224345309165396,3.3130148051674446,3.4041227123095497]
[null,"Stormwater Drainage",1006,1033.6650000000002,1062.0907875000003,1091.2982841562502,1121.3089869705473,1152.1449841122374,1183.8289711753239,1216.3842678826454,1249.8348352494183,1284.2052932187773]
[null,"Other Infrastructure",839.33333333333337,862.41500000000008,886.13141250000012,910.50002634375016,935.53877706820333,961.266093437579,987.7009110071125,1014.8626860598082,1042.7714099264531,1071.4476236994306]
[null,"Other Open Space/Recreational Assets",{"$f":"293-51","v":242},{"$f":"C45*1.0275-51","v":197.65500000000003},203.09051250000005,208.67550159375006,214.4140778875782,220.31046502948661,226.36900281779751,232.59415039528696,238.99048953115738,245.56272799326422]
[null,"Buildings",{"$f":"1096.66666666667-85","v":1011.6666666666699},{"$f":"C46*1.0275-85","v":954.48750000000337},980.7359062500035,1007.7061436718786,1035.4180626228554,1063.8920593449839,1093.1490909769709,1123.2106909788376,1154.0989849807559,1185.8367070677268]
[]
[null,"Denominator:"]
[null,"Net carrying amount of infrastructure assets",{"$f":"SUM(C50:C57)","v":762009.09455675841},{"$f":"SUM(D50:D57)","v":794227.98517412506},807173.8734895715,819546.16107360541,834560.37534787157,848604.77098238305,859859.62184311042,873474.59678266966,884583.29585625546,894716.20113211276]
[null,"- Buildings",{"$f":"$M50*'[4]Standard - balance sheet'!C$24","v":90274.132959139592},{"$f":"$M50*'[4]Strategic - Balance Sheet'!D$24","v":94091.059077429498},{"$f":"$M50*'[4]Strategic - Balance Sheet'!E$24","v":95624.740041883822},{"$f":"$M50*'[4]Strategic - Balance Sheet'!F$24","v":97090.467344022472},{"$f":"$M50*'[4]Strategic - Balance Sheet'!G$24","v":98869.179941226452},{"$f":"$M50*'[4]Strategic - Balance Sheet'!H$24","v":100532.99950440129},{"$f":"$M50*'[4]Strategic - Balance Sheet'!I$24","v":101866.34566823885},{"$f":"$M50*'[4]Strategic - Balance Sheet'!J$24","v":103479.29237282385},{"$f":"$M50*'[4]Strategic - Balance Sheet'!K$24","v":104795.32414243843},{"$f":"$M50*'[4]Strategic - Balance Sheet'!L$24","v":105995.7550095624},9.957890710861643E-2]
[null,"- Other Structures",{"$f":"$M51*'[4]Standard - balance sheet'!C$24","v":3436.8055157757017},{"$f":"$M51*'[4]Strategic - Balance Sheet'!D$24","v":3582.1188221088087},{"$f":"$M51*'[4]Strategic - Balance Sheet'!E$24","v":3640.5072333324601},{"$f":"$M51*'[4]Strategic - Balance Sheet'!F$24","v":3696.308596485881},{"$f":"$M51*'[4]Strategic - Balance Sheet'!G$24","v":3764.0255499992127},{"$f":"$M51*'[4]Strategic - Balance Sheet'!H$24","v":3827.3684375411285},{"$f":"$M51*'[4]Strategic - Balance Sheet'!I$24","v":3878.1299491735854},{"$f":"$M51*'[4]Strategic - Balance Sheet'!J$24","v":3939.5360679504784},{"$f":"$M51*'[4]Strategic - Balance Sheet'!K$24","v":3989.6384073082504},{"$f":"$M51*'[4]Strategic - Balance Sheet'!L$24","v":4035.3397315990796},3.7910454078879142E-3]
[null,"- Roads",{"$f":"$M52*'[4]Standard - balance sheet'!C$24","v":407593.27957316692},{"$f":"$M52*'[4]Strategic - Balance Sheet'!D$24","v":424826.93647404719},{"$f":"$M52*'[4]Strategic - Balance Sheet'!E$24","v":431751.60064560804},{"$f":"$M52*'[4]Strategic - Balance Sheet'!F$24","v":438369.44983956293},{"$f":"$M52*'[4]Strategic - Balance Sheet'!G$24","v":446400.4469496723},{"$f":"$M52*'[4]Strategic - Balance Sheet'!H$24","v":453912.6949230688},{"$f":"$M52*'[4]Strategic - Balance Sheet'!I$24","v":459932.83511063323},{"$f":"$M52*'[4]Strategic - Balance Sheet'!J$24","v":467215.38898900832},{"$f":"$M52*'[4]Strategic - Balance Sheet'!K$24","v":473157.35361848283},{"$f":"$M52*'[4]Strategic - Balance Sheet'!L$24","v":478577.37304147065},0.44960490889548338]
[null,"- Bridges",{"$f":"$M53*'[4]Standard - balance sheet'!C$24","v":11417.759327407563},{"$f":"$M53*'[4]Strategic - Balance Sheet'!D$24","v":11900.5193646472},{"$f":"$M53*'[4]Strategic - Balance Sheet'!E$24","v":12094.497413099814},{"$f":"$M53*'[4]Strategic - Balance Sheet'!F$24","v":12279.880767410226},{"$f":"$M53*'[4]Strategic - Balance Sheet'!G$24","v":12504.850110031279},{"$f":"$M53*'[4]Strategic - Balance Sheet'!H$24","v":12715.287925536648},{"$f":"$M53*'[4]Strategic - Balance Sheet'!I$24","v":12883.927879195468},{"$f":"$M53*'[4]Strategic - Balance Sheet'!J$24","v":13087.931359231352},{"$f":"$M53*'[4]Strategic - Balance Sheet'!K$24","v":13254.381409983795},{"$f":"$M53*'[4]Strategic - Balance Sheet'!L$24","v":13406.210403303692},1.2594615513694023E-2]
[null,"- Footpaths",{"$f":"$M54*'[4]Standard - balance sheet'!C$24","v":28872.455469486435},{"$f":"$M54*'[4]Strategic - Balance Sheet'!D$24","v":30093.226312342671},{"$f":"$M54*'[4]Strategic - Balance Sheet'!E$24","v":30583.744846269208},{"$f":"$M54*'[4]Strategic - Balance Sheet'!F$24","v":31052.529700514926},{"$f":"$M54*'[4]Strategic - Balance Sheet'!G$24","v":31621.416917399431},{"$f":"$M54*'[4]Strategic - Balance Sheet'!H$24","v":32153.557793997701},{"$f":"$M54*'[4]Strategic - Balance Sheet'!I$24","v":32580.003072162104},{"$f":"$M54*'[4]Strategic - Balance Sheet'!J$24","v":33095.873237582178},{"$f":"$M54*'[4]Strategic - Balance Sheet'!K$24","v":33516.780837789483},{"$f":"$M54*'[4]Strategic - Balance Sheet'!L$24","v":33900.715699516943},3.1848409582565504E-2]
[null,"- Stormwater Drainage",{"$f":"$M55*'[4]Standard - balance sheet'!C$24","v":193092.21203966092},{"$f":"$M55*'[4]Strategic - Balance Sheet'!D$24","v":201256.44118497043},{"$f":"$M55*'[4]Strategic - Balance Sheet'!E$24","v":204536.91412092926},{"$f":"$M55*'[4]Strategic - Balance Sheet'!F$24","v":207672.03730339149},{"$f":"$M55*'[4]Strategic - Balance Sheet'!G$24","v":211476.62161473997},{"$f":"$M55*'[4]Strategic - Balance Sheet'!H$24","v":215035.45501869748},{"$f":"$M55*'[4]Strategic - Balance Sheet'!I$24","v":217887.42104429778},{"$f":"$M55*'[4]Strategic - Balance Sheet'!J$24","v":221337.43974712343},{"$f":"$M55*'[4]Strategic - Balance Sheet'!K$24","v":224152.37108104571},{"$f":"$M55*'[4]Strategic - Balance Sheet'!L$24","v":226720.03740954507},0.21299469533313281]
[null,"- Other Open Space/Recreational Assets",{"$f":"$M56*'[4]Standard - balance sheet'!C$24","v":21523.29005094503},{"$f":"$M56*'[4]Strategic - Balance Sheet'!D$24","v":22433.32712639571},{"$f":"$M56*'[4]Strategic - Balance Sheet'!E$24","v":22798.98957212094},{"$f":"$M56*'[4]Strategic - Balance Sheet'!F$24","v":23148.450406863027},{"$f":"$M56*'[4]Strategic - Balance Sheet'!G$24","v":23572.533650777641},{"$f":"$M56*'[4]Strategic - Balance Sheet'!H$24","v":23969.223930448978},{"$f":"$M56*'[4]Strategic - Balance Sheet'!I$24","v":24287.122261697201},{"$f":"$M56*'[4]Strategic - Balance Sheet'!J$24","v":24671.683360447518},{"$f":"$M56*'[4]Strategic - Balance Sheet'!K$24","v":24985.453568647623},{"$f":"$M56*'[4]Strategic - Balance Sheet'!L$24","v":25271.662041576532},2.3741747834066271E-2]
[null,"- Other Infrastructure",{"$f":"$M57*'[4]Standard - balance sheet'!C$24","v":5799.1596211763062},{"$f":"$M57*'[4]Strategic - Balance Sheet'!D$24","v":6044.3568121836006},{"$f":"$M57*'[4]Strategic - Balance Sheet'!E$24","v":6142.8796163279058},{"$f":"$M57*'[4]Strategic - Balance Sheet'!F$24","v":6237.0371153544038},{"$f":"$M57*'[4]Strategic - Balance Sheet'!G$24","v":6351.3006140251891},{"$f":"$M57*'[4]Strategic - Balance Sheet'!H$24","v":6458.1834486911721},{"$f":"$M57*'[4]Strategic - Balance Sheet'!I$24","v":6543.8368577123028},{"$f":"$M57*'[4]Strategic - Balance Sheet'!J$24","v":6647.4516485026215},{"$f":"$M57*'[4]Strategic - Balance Sheet'!K$24","v":6731.9927905592112},{"$f":"$M57*'[4]Strategic - Balance Sheet'!L$24","v":6809.1077955384335},6.3968930888157549E-3]
[]
[null,"Asset Maintenance Ratio",{"$f":"C60/C61","v":0.88701410254874102},{"$f":"D60/D61","v":0.87880193413958674},0.89302534555406521,0.92135201332258632,0.94591195412773799,0.97232801904950805,0.99194263825520101,1.0165018155219219,1.0395456889863046,1.067202763714088]
[null,"Actual Asset Maintenance",{"$f":"C64","v":10682.310836994488},{"$f":"D64","v":11030.894257193029},11392.142611980267,11933.65672783503,12476.219484821693,13040.456703877011,13479.961310639264,14032.43274097681,14533.052668941169,15090.609269769404]
[null,"Required Asset Maintenance",{"$f":"C70","v":12043},{"$f":"D70","v":12552.196153269855},12756.79651053148,12952.331525059342,13189.620271081676,13411.581738253939,13589.45647739282,13804.631262534313,13980.196178883518,14140.339383352926]
[]
[null,"Numerator:"]
[null,"Actual Asset Maintenance",{"$f":"C66*C67","v":10682.310836994488},11030.894257193029,11392.142611980267,11933.65672783503,12476.219484821693,13040.456703877011,13479.961310639264,14032.43274097681,14533.052668941169,15090.609269769404]
[]
[null,null,{"$f":"'Strategic - P&L'!C23+'Strategic - P&L'!C25","v":85458.4866959559},{"$f":"'Strategic - P&L'!D23+'Strategic - P&L'!D25","v":88247.154057544234},{"$f":"'Strategic - P&L'!E23+'Strategic - P&L'!E25","v":91137.140895842138},{"$f":"'Strategic - P&L'!F23+'Strategic - P&L'!F25","v":95469.253822680243},{"$f":"'Strategic - P&L'!G23+'Strategic - P&L'!G25","v":99809.755878573545},{"$f":"'Strategic - P&L'!H23+'Strategic - P&L'!H25","v":104323.65363101609},{"$f":"'Strategic - P&L'!I23+'Strategic - P&L'!I25","v":107839.69048511412},{"$f":"'Strategic - P&L'!J23+'Strategic - P&L'!J25","v":112259.46192781448},{"$f":"'Strategic - P&L'!K23+'Strategic - P&L'!K25","v":116264.42135152935},{"$f":"'Strategic - P&L'!L23+'Strategic - P&L'!L25","v":120724.87415815523},"<<< total salaries and materials"]
[null,null,0.125,0.125,0.125,0.125,0.125,0.125,0.125,0.125,0.125,0.125,"<<< per centage for asset maintenance"]
[]
[null,"Denominator:"]
[null,"Required Asset Maintenance",{"$f":"SUM(C71:C76)","v":12043},{"$f":"SUM(D71:D76)","v":12552.196153269855},12756.79651053148,12952.331525059342,13189.620271081676,13411.581738253939,13589.45647739282,13804.631262534313,13980.196178883518,14140.339383352926]
[null,"- Roads",5168,{"$f":"D52*$M$71","v":5386.5108129285572},{"$f":"E52*$M$71","v":5474.3107503468145},5558.2204867148293,5660.0479582288554,5755.2980505934038,5831.6292514461593,5923.9669820457793,5999.3069710595382,6068.0290569764938,{"$f":"C71/C52","v":1.2679306207923614E-2}]
[null,"- Other structures",202,{"$f":"D51*$M$72","v":210.54086381802796},{"$f":"E51*$M$72","v":213.97267251742582},217.2524261448134,221.23252468309383,224.95553525926229,227.93906903872374,231.54824504126307,234.4930356335191,237.17915431680569,{"$f":"C72/C51","v":5.8775510884388156E-2}]
[null,"- Stormwater Drainage",1220,{"$f":"D55*$M$73","v":1271.583434940565},{"$f":"E55*$M$73","v":1292.3102003527697},1312.1186133498632,1336.1568322444282,1358.6423416648515,1376.6617040952622,1398.459697773965,1416.2450666974917,1432.4681597351632,{"$f":"C73/C55","v":6.3182247855206788E-3}]
[null,"- Other infrastrcuture",35,{"$f":"D57*$M$74","v":36.479852641737523},{"$f":"E57*$M$74","v":37.07447296094012},37.642747104299353,38.332368138159822,38.977444228090008,39.494393150273922,40.119745427941623,40.629981421649347,41.095398025189105,{"$f":"C74/C57","v":6.0353572390374338E-3}]
[null,"- Other Open Space/Recreational Assets",3843,{"$f":"D56*$M$75","v":4005.4878200627791},{"$f":"E56*$M$75","v":4070.7771311112242},4133.1736320520677,4208.8940215699477,4279.7233762442811,4336.4843679000751,4405.1480479879892,4461.1719600970982,4512.2747031657627,{"$f":"C75/C56","v":0.178550769464321}]
[null,"- Buidlings",1575,{"$f":"D50*$M$76","v":1641.5933688781884},{"$f":"E50*$M$76","v":1668.3512832423053},1693.9236196934708,1724.9565662171919,1753.9849902640501,1777.2476917623264,1805.388544257373,1828.3491639742208,1849.2929111335097,{"$f":"C76/C50","v":1.7446858234715871E-2}]

{"sheet":"Strategic - Graphs","index":11,"n_rows":72,"n_cols":2,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Graphs - Strategic Scenario - Unconsolidated"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Special Schedule 7 Graphs - Strategic Scenario - Unconsolidated"]