{"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":3,"defined_names":17,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"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 - Consolidated"]
[]
[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",41681.748250000019,42875.176956250019,44285.975380156262,45742.223764660164,47227.798358776665,48408.493317746077,49618.705650689728,50859.173291956969,52130.65262425589,53433.918939862284]
[null,"Interest & Investment Revenue",1421.4132,1259.6332372997369,1238.812797957765,1295.3449511524211,1351.9675707595743,1440.1668321400703,1559.9603294569058,1670.8462212251318,1791.2221260769024,1914.5829870289153]
[null,"Other Revenues",7083.982,7261.0815499999999,7442.6085887499994,7628.6738034687487,7819.3906485554671,8014.8754147693535,8215.2473001385861,8420.6284826420506,8631.1441947081021,8846.9227995758047]
[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":127728.86231000001},130994.32602504976,134673.37780440151,138531.86069973724,142477.79258237861,146209.89238575555,150064.0490369529,154002.00956174944,158044.47641376202,162187.30673282681]
[]
[null,"Operating Expenses"]
[null,"Employee Benefits & On-Costs",46765.957247500031,48616.396145401632,50288.735859330263,51947.149458803913,53044.325146928975,54831.994724875534,56385.123341367711,58488.485700255165,59288.921603138566,61612.78036744491]
[null,"Borrowing Costs",767.30475156842624,750.40954275797799,657.83076299418826,576.55786149042717,501.91673038217237,468.53131458837538,450.84408484848177,432.4911502040805,413.9254489218149,389.71054821228387]
[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",15739.995322365827,16014.778723286925,16507.009322668466,17183.090693736805,17356.269494696829,17535.565841933159,17721.097404830107,17912.985332160082,18111.354328068221,18316.332730117228]
[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",14393.338899999997,14754.197372499995,15123.052306812493,15529.628614482803,15939.369329844871,16537.85356309099,17001.299902168263,17476.332399722469,18013.240709715526,18463.571727458413]
[null,"Total Operating Expenses",{"$f":"SUM(C23:C28)","v":118042.44821343428},{"$f":"SUM(D23:D28)","v":122045.91323554654},{"$f":"SUM(E23:E28)","v":125041.91951753541},128807.7753981592,131536.75336855682,135946.38207011373,138789.51598828408,142778.74758983069,145612.82479935433,150416.58735194805]
[]
[null,"Operating Surplus / (Deficit) ",{"$f":"C20-C29","v":9686.414096565728},{"$f":"D20-D29","v":8948.4127895032143},9631.4582868660946,9724.0853015780449,10941.039213821787,10263.510315641819,11274.533048668818,11223.26197191875,12431.651614407689,{"$f":"L20-L29","v":11770.719380878756}]
[]
[null,"Other Comprehensive Income",0,0,0,0,0,0,0,0,0,0]
[]
[null,"Total Comprehensive Income",{"$f":"SUM(C31:C34)","v":9686.414096565728},{"$f":"SUM(D31:D34)","v":8948.4127895032143},9631.4582868660946,9724.0853015780449,10941.039213821787,10263.510315641819,11274.533048668818,11223.26197191875,12431.651614407689,{"$f":"SUM(L31:L34)","v":11770.719380878756}]
[]
[null,"Net Operating Result before Capital Grants",{"$f":"+C35-C18","v":3820.9040965657277},2965.5925895032142,3528.9816828660942,3499.5591654980444,4592.0225550201867,3787.5133236641868,4669.0161168516333,4485.634701465221,5559.27179854509,4760.8919686989047]
[]
[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",-4091.7970970573588,-4194.6291949780107,-4299.9182937605483,-4407.4516320003504,-4518.0946170629322,-4631.1151883226912,-4746.8383239242312,-4865.1147479596439,-5000.2390542303556,-5177.4597310869158]
[null,"Local election costs",0,500,0,0,0,550,0,0,0,600]
[null,"NAP dividend ",1984.8617384622914,2097.3145974890053,2149.9591468802741,2203.7258160001752,2259.0473085314661,2315.5575941613456,2373.4191619621156,2432.5573739798219,2500.1195271151778,2588.7298655434579]
[null,"Underlying result",{"$f":"SUM(C37:C44)","v":677.29373797066023},122.25474201421048,103.11858848581733,-10.847716427134856,994.59374858596857,650.92278666300854,890.93302376449219,613.77347842662039,1584.1693068993686,{"$f":"SUM(L37:L44)","v":1260.4296496889883}]

{"sheet":"Standard - balance sheet","index":1,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Balance Sheet - Standard Scenario - Consolidated"]
[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":"'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,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",9144.3294919894761,8311.5119183105999,10572.798046096841,12837.702830382976,16365.673285602801,21157.413178276231,25592.848849005262,30407.885043076101,35342.319481156606,41400.163564903953]
[null,"Investments",41241,41241,41241,41241,41241,41241,41241,41241,41241,41241]
[null,"Receivables",11310.795711000002,11624.079103775002,11963.947981369376,12313.331580903608,12670.741770426197,13002.88531468685,13343.332447554021,13692.290758742873,14049.973027711441,14416.597353404226]
[null,"Inventories",3875,3875,3875,3875,3875,3875,3875,3875,3875,3875]
[]
[null,"Total Current Assets",65571.125202989482,{"$f":"SUM(D14:D17)","v":65051.591022085602},67652.746027466215,70267.034411286586,74152.415056029,79276.298492963077,84052.181296559284,89216.175801818972,94508.292508868049,100932.76091830818]
[]
[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",906558.78418782423,912400.53272391227,916748.03964210325,920929.68541124731,925460.90525332338,930348.42313314881,935599.16183771892,941220.24731818389,947219.01314955577,953603.0051108941]
[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",957471.52523582429,{"$f":"SUM(D22:D27)","v":964435.35381231224},969918.06636032334,975252.50219749822,980957.87508681824,987044.14960530389,993521.06531541178,1000398.232575166,1007685.2103727205,1015392.5698127515]
[null,"Total Assets",1023042.6504388137,{"$f":"D28+D19","v":1029486.9448343979},1037570.8123877896,1045519.5366087848,1055110.2901428472,1066320.448098267,1077573.2466119709,1089614.408376985,1102193.5028815886,1116325.3307310597]
[]
[null,"LIABILITIES"]
[null,"Current Liabilities"]
[null,"Trade & Other Payables",7220.3598864000014,7490.8688835600005,7585.8906056489996,7780.6678707902238,7979.0545675599778,8313.5309317489773,8428.8942050427013,8648.616560168768,8882.8319741729847,9212.9027735273103]
[null,"Borrowings",3237.4962206077612,2410.5365582468007,2497.3698959221224,2013.929462281825,652.45885969100516,677.19158012023377,702.86874023968358,787.58088336596643,521.05180833899226,521.05180833899226]
[null,"Provisions",13443.907269070003,13631.508548319873,14073.096125751497,14250.313845956376,14339.542820740264,15208.503727146979,15318.475105540865,15913.194355939739,15594.865954373479,17131.636444178675]
[null,"Other Current Liabilities",0,0,0,0,0,0,0,0,0,1]
[null,"Total Current Liabilities",23901.763376077768,{"$f":"SUM(D33:D36)","v":23532.913990126675},24156.356627322617,24044.911179028422,22971.056247991248,24199.226239016192,24450.238050823253,25349.391799474473,24998.749736885457,{"$f":"SUM(L33:L36)","v":26866.591026044978}]
[]
[null,"Non Current Liabilities"]
[null,"Trade & Other Payables",3564,3018.5,2473,1927.5,1382,836.5,291,0,0,0]
[null,"Borrowings",18650.138319168167,16239.601760921365,13742.231864999241,11728.302402717418,11075.843543026413,10398.651962906179,9695.7832226664941,8908.2023393005275,8387.150530961535,7866.0987226225434]
[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",23024.149450492368,{"$f":"SUM(D40:D43)","v":20888.880442524445},18717.847071853925,17053.931439565491,16777.500690843139,16495.978339596215,16223.231992824489,16141.978037268316,{"$f":"SUM(K40:K43)","v":16640.062990053237},{"$f":"SUM(L40:L43)","v":17134.330169486002}]
[null,"Total Liabilities",46925.912826570137,{"$f":"D44+D37","v":44421.794432651121},42874.203699176542,41098.842618593917,39748.556938834387,40695.204578612407,40673.470043647743,41491.369836742786,41638.81272693869,{"$f":"L44+L37","v":44000.92119553098}]
[null,"Net Assets",976116.73761224363,{"$f":"D29-D45","v":985065.15040174674},994696.60868861305,1004420.6939901909,1015361.7332040129,1025625.2435196545,1036899.7765683231,1048123.0385402422,1060554.69015465,{"$f":"L29-L45","v":1072324.4095355286}]
[]
[null,"EQUITY"]
[null,"Accumulated Surplus",607558.18567507807,616505.5984645813,626138.05675144738,635862.14205302543,646803.18126684718,657065.69158248906,668341.22463115794,679564.48660307669,691996.13821748435,703764.85759836307]
[null,"Asset Revaluation Reserves",368559,368559,368559,368559,368559,368559,368559,368559,368559,368559]
[null,"Total Equity",976117.18567507807,{"$f":"SUM(D49:D50)","v":985064.5984645813},994697.05675144738,1004421.1420530254,1015362.1812668472,1025624.6915824891,1036900.2246311579,1048123.4866030767,1060555.1382174843,1072323.857598363]

{"sheet":"Standard - Cashflow","index":2,"n_rows":68,"n_cols":12,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Cashflow Statement - Standard Scenario - Consolidated"]
[]
[]
[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",58558.808040280623,60404.439682224998,62049.547274280616,63753.517956137628,65501.813905041054,67327.311152667069,69164.243931483739,71047.100029770838,72977.027530515101,74954.20321877797]
[null,"User Charges & Fees",41681.748250000019,42875.176956250019,44285.975380156262,45742.223764660164,47227.798358776665,48408.493317746077,49618.705650689728,50859.173291956969,52130.65262425589,53433.918939862284]
[null,"Interest & Investment Revenue Received",1421.4132,1259.6332372997369,1238.812797957765,1295.3449511524211,1351.9675707595743,1440.1668321400703,1559.9603294569058,1670.8462212251318,1791.2221260769024,1914.5829870289153]
[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",6297.3070000000007,6265.0583000000015,6416.7046412499967,6571.9927375437446,6731.0091506527151,6893.8424719295208,7060.5833690135605,7231.3246335832719,7406.1612301775585,7585.1903461093461]
[null,"Payments:"]
[null,"Employee Benefits & On-Costs",-48815.244125073128,-49624.764974930382,-51602.159962013495,-53019.88100900218,-54055.082232681518,-56642.124860155556,-57470.717113229555,-60080.531878463837,-59989.729962696219,-64163.869845021865]
[null,"Materials & Contracts",-40132.929094600011,-41340.947239159999,-41693.358420138997,-42875.209880642469,-43980.967627658523,-45975.259318349992,-46397.053301308733,-47976.592133841448,-49583.281937187472,-51513.863985617158]
[null,"Borrowing Costs",-767.30475156842624,-750.40954275797799,-657.83076299418826,-576.55786149042717,-501.91673038217237,-468.53131458837538,-450.84408484848177,-432.4911502040805,-413.9254489218149,-389.71054821228387]
[null,"Bonds & Deposits Refunded"]
[null,"Other",-10255.1279156538,-13287.441719122511,-13397.160657268032,-14085.61098380381,-14612.081764800285,-13339.640564152971,-15690.385811857072,-14434.795333052974,-16143.193162591797,-12699.251173595891]
[null,"Net Cash provided (or used in) Operating Activities",24051.586463385276,{"$f":"'[2]cashflow note'!D62","v":22246.615906303883},{"$f":"'[2]cashflow note'!E62","v":23478.558376892412},{"$f":"'[2]cashflow note'!F62","v":24045.428763339107},{"$f":"'[2]cashflow note'!G62","v":25313.382852710769},{"$f":"'[2]cashflow note'!H62","v":25716.21876095378},{"$f":"'[2]cashflow note'!I62","v":25897.697759653347},{"$f":"'[2]cashflow note'!J62","v":26828.852205834697},{"$f":"'[2]cashflow note'!K62","v":27571.98627475875},{"$f":"'[2]cashflow note'!L62","v":28981.366119231418}]
[]
[]
[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",-20728.475374999998,-19671.687259374998,-18625.97944085937,-19091.62892688085,-19568.919650052867,-20058.142641304188,-20559.596207336792,-21073.58611252021,-21600.425765333213,-22140.43640946654]
[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",-20888.475374999998,{"$f":"SUM(D31:D39)","v":-19841.937259374998},{"$f":"SUM(E31:E39)","v":-18806.735690859368},{"$f":"SUM(F32:F39)","v":-19283.154083130852},{"$f":"SUM(G32:G39)","v":-19771.482935209118},-20272.020008589345,-20785.070508804078,-21310.947271524175,-21849.97095331228,-22402.470227145081]
[]
[]
[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.8135230587031,-3237.4962206077612,-2410.5365582468025,-2497.3698959221206,-2013.929462281825,-652.45885969100516,-677.19158012023559,-702.86874023968358,-787.58088336596643,-521.05180833899226]
[null,"Net Cash Flow provided (used in) Financing Activities",3198.1864769412969,{"$f":"SUM(D45:D50)","v":-3237.4962206077612},-2410.5365582468025,-2497.3698959221206,-2013.929462281825,-652.45885969100516,-677.19158012023559,-702.86874023968358,-787.58088336596643,-521.05180833899226]
[]
[null,"Net Increase/(Decrease) in Cash & Cash Equivalents",6361.2975653265748,{"$f":"+D26+D40+D51","v":-832.81757367887576},2261.2861277862407,2264.9047842861341,3527.9704552198255,4791.7398926734295,4435.4356707290335,4815.0361940708381,4934.4344380805032,6057.8440837473445]
[]
[null,"plus: Cash - beginning of year",2783.0319266629012,{"$f":"C57","v":9144.3294919894761},8311.5119183105999,10572.798046096841,12837.702830382976,16365.673285602801,21157.413178276231,25592.848849005262,{"$f":"J57","v":30407.885043076101},{"$f":"K57","v":35342.319481156606}]
[]
[null,"Cash - end of the year",9144.3294919894761,{"$f":"+D55+D53","v":8311.5119183105999},10572.798046096841,12837.702830382976,16365.673285602801,21157.413178276231,25592.848849005262,{"$f":"+J55+J53","v":30407.885043076101},{"$f":"+K55+K53","v":35342.319481156606},{"$f":"+L55+L53","v":41400.163564903953}]
[null,"plus: Investments - end of the year",41241,{"$f":"'Standard - balance sheet'!D15+'Standard - balance sheet'!D22","v":41241},{"$f":"'Standard - balance sheet'!E15+'Standard - balance sheet'!E22","v":41241},{"$f":"'Standard - balance sheet'!F15+'Standard - balance sheet'!F22","v":41241},{"$f":"'Standard - balance sheet'!G15+'Standard - balance sheet'!G22","v":41241},{"$f":"'Standard - balance sheet'!H15+'Standard - balance sheet'!H22","v":41241},{"$f":"'Standard - balance sheet'!I15+'Standard - balance sheet'!I22","v":41241},{"$f":"'Standard - balance sheet'!J15+'Standard - balance sheet'!J22","v":41241},{"$f":"'Standard - balance sheet'!K15+'Standard - balance sheet'!K22","v":41241},{"$f":"'Standard - balance sheet'!L15+'Standard - balance sheet'!L22","v":41241}]
[null,"Total Cash & Investments - end of the year",50385.329491989476,{"$f":"+D57+D58","v":49552.5119183106},51813.798046096839,54078.702830382972,57606.673285602803,62398.413178276227,66833.84884900527,71648.885043076094,76583.319481156606,82641.163564903953]
[]
[null,"Representing:"]
[null,"- External Restrictions"]
[null,"- Internal Restricitons"]
[null,"- Unrestricted"]
[]
[]
[null,"Less restricted Cash (NAL)",-13296.458336874732,{"$f":"[2]NAL!G24/1000","v":-13794.052862488737},{"$f":"[2]NAL!H24/1000","v":-15841.798935697136},{"$f":"[2]NAL!I24/1000","v":-17940.756351183642},{"$f":"[2]NAL!J24/1000","v":-20092.416049188596},{"$f":"[2]NAL!K24/1000","v":-22297.901342560264},{"$f":"[2]NAL!L24/1000","v":-24558.496396212966},{"$f":"[2]NAL!M24/1000","v":-26875.409059175632},{"$f":"[2]NAL!N24/1000","v":-29256.992757498232},{"$f":"[2]NAL!O24/1000","v":-31724.223398529291}]
[null,"Cash, Cash Equivalents & Investments - end of the year",37088.871155114743,{"$f":"D59+D67","v":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":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Ratios - Standard Scenario - Consolidated"]
[]
[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":2.3043165288923313E-2},1.3893771540546371E-2,1.7699656577153937E-2,1.6739443972399799E-2,2.413852315649671E-2,1.7464804775061779E-2,2.2979678256475865E-2,2.0890308340297811E-2,2.7283684600743912E-2,{"$f":"(L13-L14-L15)/(L13-L14)","v":2.1144331651482735E-2}]
[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":126692.18731000001},{"$f":"'Standard - P&L'!D20+'Standard - P&L'!D41-'Standard - P&L'!D19","v":129748.30277504976},{"$f":"'Standard - P&L'!E20+'Standard - P&L'!E41-'Standard - P&L'!E19","v":133397.47385690152},{"$f":"'Standard - P&L'!F20+'Standard - P&L'!F41-'Standard - P&L'!F19","v":137225.17963381225},{"$f":"'Standard - P&L'!G20+'Standard - P&L'!G41-'Standard - P&L'!G19","v":141139.41108447587},{"$f":"'Standard - P&L'!H20+'Standard - P&L'!H41-'Standard - P&L'!H19","v":144838.85944291571},{"$f":"'Standard - P&L'!I20+'Standard - P&L'!I41-'Standard - P&L'!I19","v":148659.38510582788},{"$f":"'Standard - P&L'!J20+'Standard - P&L'!J41-'Standard - P&L'!J19","v":152562.70571269066},{"$f":"'Standard - P&L'!K20+'Standard - P&L'!K41-'Standard - P&L'!K19","v":156569.49344923149},{"$f":"'Standard - P&L'!L20+'Standard - P&L'!L41-'Standard - P&L'!L19","v":160675.57427936036}]
[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":118042.44821343428},{"$f":"'Standard - P&L'!D29","v":122045.91323554654},{"$f":"'Standard - P&L'!E29","v":125041.91951753541},{"$f":"'Standard - P&L'!F29","v":128807.7753981592},{"$f":"'Standard - P&L'!G29","v":131536.75336855682},{"$f":"'Standard - P&L'!H29","v":135946.38207011373},{"$f":"'Standard - P&L'!I29","v":138789.51598828408},{"$f":"'Standard - P&L'!J29","v":142778.74758983069},{"$f":"'Standard - P&L'!K29","v":145612.82479935433},{"$f":"'Standard - P&L'!L29","v":150416.58735194805}]
[]
[null,"Own Source Revenue ",{"$f":"+C19/C20","v":0.8563059313558552},0.85640882533314622,0.85706952062588804,0.85780512966458422,0.85851285791626952,0.85889903992079586,0.85930626123989773,0.85969504719405976,0.8600829115134051,{"$f":"+L19/L20","v":0.86046382866565529}]
[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":108487.27145000001},{"$f":"'Standard - P&L'!D13+'Standard - P&L'!D14+'Standard - P&L'!D16+'Standard - P&L'!D15+'Standard - P&L'!D41","v":111117.59156854976},{"$f":"'Standard - P&L'!E13+'Standard - P&L'!E14+'Standard - P&L'!E16+'Standard - P&L'!E15+'Standard - P&L'!E41","v":114330.90897123901},{"$f":"'Standard - P&L'!F13+'Standard - P&L'!F14+'Standard - P&L'!F16+'Standard - P&L'!F15+'Standard - P&L'!F41","v":117712.46300902819},{"$f":"'Standard - P&L'!G13+'Standard - P&L'!G14+'Standard - P&L'!G16+'Standard - P&L'!G15+'Standard - P&L'!G41","v":121169.99917475259},{"$f":"'Standard - P&L'!H13+'Standard - P&L'!H14+'Standard - P&L'!H16+'Standard - P&L'!H15+'Standard - P&L'!H41","v":124401.9573187434},{"$f":"'Standard - P&L'!I13+'Standard - P&L'!I14+'Standard - P&L'!I16+'Standard - P&L'!I15+'Standard - P&L'!I41","v":127743.9404135111},{"$f":"'Standard - P&L'!J13+'Standard - P&L'!J14+'Standard - P&L'!J16+'Standard - P&L'!J15+'Standard - P&L'!J41","v":131157.40248772505},{"$f":"'Standard - P&L'!K13+'Standard - P&L'!K14+'Standard - P&L'!K16+'Standard - P&L'!K15+'Standard - P&L'!K41","v":134662.74577999403},{"$f":"'Standard - P&L'!L13+'Standard - P&L'!L14+'Standard - P&L'!L16+'Standard - P&L'!L15+'Standard - P&L'!L41","v":138255.5198174713}]
[null,"Total operating Revenue*",{"$f":"C13","v":126692.18731000001},129748.30277504976,133397.47385690152,137225.17963381225,141139.41108447587,144838.85944291571,148659.38510582788,152562.70571269066,156569.49344923149,{"$f":"L13","v":160675.57427936036}]
[]
[null,"Capital Expenditure Ratio",{"$f":"C24/C25","v":1.3209287632353728},1.2319560878549156,1.1324108852138828,1.1143649743042663,1.1296853672626332,1.1450921321052707,1.1605518600530369,1.1760365801051791,1.1915227271349313,{"$f":"L24/L25","v":1.2069903173915171}]
[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":21138.475374999998},{"$f":"-'Standard - Cashflow'!D38-'Standard - Cashflow'!D39","v":20091.937259374998},{"$f":"-'Standard - Cashflow'!E38-'Standard - Cashflow'!E39","v":19056.735690859368},{"$f":"-'Standard - Cashflow'!F38-'Standard - Cashflow'!F39","v":19533.154083130852},{"$f":"-'Standard - Cashflow'!G38-'Standard - Cashflow'!G39","v":20021.482935209118},{"$f":"-'Standard - Cashflow'!H38-'Standard - Cashflow'!H39","v":20522.020008589345},{"$f":"-'Standard - Cashflow'!I38-'Standard - Cashflow'!I39","v":21035.070508804078},{"$f":"-'Standard - Cashflow'!J38-'Standard - Cashflow'!J39","v":21560.947271524175},{"$f":"-'Standard - Cashflow'!K38-'Standard - Cashflow'!K39","v":22099.97095331228},{"$f":"-'Standard - Cashflow'!L38-'Standard - Cashflow'!L39","v":22652.470227145081}]
[null,"Depreciation",{"$f":"'Standard - P&L'!C26+'Standard - P&L'!C27","v":16002.736834365827},{"$f":"'Standard - P&L'!D26+'Standard - P&L'!D27","v":16308.971932886925},{"$f":"'Standard - P&L'!E26+'Standard - P&L'!E27","v":16828.463890348467},{"$f":"'Standard - P&L'!F26+'Standard - P&L'!F27","v":17528.506847880806},{"$f":"'Standard - P&L'!G26+'Standard - P&L'!G27","v":17723.06123051203},{"$f":"'Standard - P&L'!H26+'Standard - P&L'!H27","v":17921.71951339782},{"$f":"'Standard - P&L'!I26+'Standard - P&L'!I27","v":18125.058631884647},{"$f":"'Standard - P&L'!J26+'Standard - P&L'!J27","v":18333.568560933596},{"$f":"'Standard - P&L'!K26+'Standard - P&L'!K27","v":18547.670514395162},{"$f":"'Standard - P&L'!L26+'Standard - P&L'!L27","v":18767.731522569615}]
[]
[null,"Debt Service Coverage ratio",{"$f":"C28/(C29+C30)","v":4.2676451159490663},{"$f":"D28/(D29+D30)","v":4.2049408963309265},5.8150563344353312,5.9942983213800023,7.8004509075689992,16.858339614109958,17.578744275522759,17.359300216613669,17.345507603484766,{"$f":"L28/(L29+L30)","v":22.071957526761683}]
[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":17365.552730931558},{"$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":16768.908035090401},{"$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":17842.728827756793},{"$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":18426.039996301428},{"$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":19624.734716869891},{"$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":18898.033062082104},{"$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":19829.450488154351},{"$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":19709.053192114905},{"$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":20840.737222332806},{"$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":20102.308050773147}]
[null,"Principal repayments",{"$f":"-'Standard - Cashflow'!C50","v":3301.8135230587031},{"$f":"-'Standard - Cashflow'!D50","v":3237.4962206077612},{"$f":"-'Standard - Cashflow'!E50","v":2410.5365582468025},{"$f":"-'Standard - Cashflow'!F50","v":2497.3698959221206},{"$f":"-'Standard - Cashflow'!G50","v":2013.929462281825},{"$f":"-'Standard - Cashflow'!H50","v":652.45885969100516},{"$f":"-'Standard - Cashflow'!I50","v":677.19158012023559},{"$f":"-'Standard - Cashflow'!J50","v":702.86874023968358},{"$f":"-'Standard - Cashflow'!K50","v":787.58088336596643},{"$f":"-'Standard - Cashflow'!L50","v":521.05180833899226}]
[null,"Interest expense",{"$f":"'Standard - P&L'!C24","v":767.30475156842624},{"$f":"'Standard - P&L'!D24","v":750.40954275797799},{"$f":"'Standard - P&L'!E24","v":657.83076299418826},{"$f":"'Standard - P&L'!F24","v":576.55786149042717},{"$f":"'Standard - P&L'!G24","v":501.91673038217237},{"$f":"'Standard - P&L'!H24","v":468.53131458837538},{"$f":"'Standard - P&L'!I24","v":450.84408484848177},{"$f":"'Standard - P&L'!J24","v":432.4911502040805},{"$f":"'Standard - P&L'!K24","v":413.9254489218149},{"$f":"'Standard - P&L'!L24","v":389.71054821228387}]
[null,"Debt Service Coverage ratio Min Target",2,2,2,2,2,2,2,2,2,2]
[]
[null,"Debt Service Ratio",{"$f":"(C36+C37)/(C34-C35)","v":3.367731667558118E-2},3.2221469834673215E-2,2.4104382634495491E-2,2.3464980329016148E-2,1.8664877444596231E-2,8.1018139869495024E-3,7.9409007263844152E-3,7.7857656760561399E-3,8.0262491582199363E-3,5.9269054758083767E-3]
[null,"Operating Revenue",{"$f":"C13","v":126692.18731000001},129748.30277504976,133397.47385690152,137225.17963381225,141139.41108447587,144838.85944291571,148659.38510582788,152562.70571269066,156569.49344923149,160675.57427936036]
[null,"Capital Grants",5865.51,5982.8202000000001,6102.4766040000004,6224.5261360800005,6349.0166588016,6475.9969919776322,6605.5169318171847,6737.6272704535286,6872.3798158625987,7009.8274121798513]
[null,"Principal repayments",{"$f":"C29","v":3301.8135230587031},3237.4962206077612,2410.5365582468025,2497.3698959221206,2013.929462281825,652.45885969100516,677.19158012023559,702.86874023968358,787.58088336596643,521.05180833899226]
[null,"Interest expense",767.30475156842624,750.40954275797799,657.83076299418826,576.55786149042717,501.91673038217237,468.53131458837538,450.84408484848177,432.4911502040805,413.9254489218149,389.71054821228387]
[]
[null,"Cash Expense Cover Ratio",{"$f":"C41/(C42/12)","v":5.8546508095616101},5.4935728150352059,5.6647198361257933,5.7400960587239016,6.0025720935141393,6.3955727185035078,6.6453848084790899,6.9546674959738333,7.2409108521933065,{"$f":"L41/(L42/12)","v":7.6704404169983595}]
[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":50385.329491989476},{"$f":"'Standard - Cashflow'!D59","v":49552.5119183106},{"$f":"'Standard - Cashflow'!E59","v":51813.798046096839},{"$f":"'Standard - Cashflow'!F59","v":54078.702830382972},{"$f":"'Standard - Cashflow'!G59","v":57606.673285602803},{"$f":"'Standard - Cashflow'!H59","v":62398.413178276227},{"$f":"'Standard - Cashflow'!I59","v":66833.84884900527},{"$f":"'Standard - Cashflow'!J59","v":71648.885043076094},{"$f":"'Standard - Cashflow'!K59","v":76583.319481156606},{"$f":"'Standard - Cashflow'!L59","v":82641.163564903953}]
[null,"Total Expenses - Depreciation and Interest Cost",{"$f":"-SUM('Standard - Cashflow'!C21:C25)-'Standard - Cashflow'!C50","v":103272.41940995406},{"$f":"-SUM('Standard - Cashflow'!D21:D25)-'Standard - Cashflow'!D50","v":108241.05969657862},{"$f":"-SUM('Standard - Cashflow'!E21:E25)-'Standard - Cashflow'!E50","v":109761.04636066151},{"$f":"-SUM('Standard - Cashflow'!F21:F25)-'Standard - Cashflow'!F50","v":113054.629630861},{"$f":"-SUM('Standard - Cashflow'!G21:G25)-'Standard - Cashflow'!G50","v":115163.97781780433},{"$f":"-SUM('Standard - Cashflow'!H21:H25)-'Standard - Cashflow'!H50","v":117078.01491693789},{"$f":"-SUM('Standard - Cashflow'!I21:I25)-'Standard - Cashflow'!I50","v":120686.19189136408},{"$f":"-SUM('Standard - Cashflow'!J21:J25)-'Standard - Cashflow'!J50","v":123627.27923580202},{"$f":"-SUM('Standard - Cashflow'!K21:K25)-'Standard - Cashflow'!K50","v":126917.71139476326},{"$f":"-SUM('Standard - Cashflow'!L21:L25)-'Standard - Cashflow'!L50","v":129287.74736078619}]
[]
[null,"Rates and Annual Charges Outstanding",{"$f":"C45/C46","v":2.8999720292366849E-2},{"$f":"D45/D46","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 - Consolidated"]
[]
[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,{"$f":"C19*1.0275","v":501.42},515.20905000000005,529.37729887500006,543.93517459406257,558.8933918953993,574.26296017252287,590.05519157726724,606.28170934564218,622.95445635264741]
[null,"- Stormwater Drainage",2643,{"$f":"C20*1.0275","v":2715.6825000000003},2790.3637687500004,2867.0987723906255,2945.943988631368,3026.9574483187307,3110.1987781474959,3195.7292445465523,3283.6117987715829,3373.9111232378018]
[null,"- Other Infrastructure",560,{"$f":"C21*1.0275","v":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,{"$f":"C22*1.0275","v":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*'Standard - P&L'!D$26","v":5736.4965275963168},{"$f":"$M26*'Standard - P&L'!E$26","v":5912.8136140149372},{"$f":"$M26*'Standard - P&L'!F$26","v":6154.9860788687056},{"$f":"$M26*'Standard - P&L'!G$26","v":6217.0187555310395},{"$f":"$M26*'Standard - P&L'!H$26","v":6281.2427383348931},{"$f":"$M26*'Standard - P&L'!I$26","v":6347.7001764742208},{"$f":"$M26*'Standard - P&L'!J$26","v":6416.4344654603965},{"$f":"$M26*'Standard - P&L'!K$26","v":6487.4902743399243},{"$f":"$M26*'Standard - P&L'!L$26","v":6560.9135736501148},0.35820017414632999]
[null,"- Other Structures",234,{"$f":"$M27*'Standard - P&L'!D$26","v":264.94691931543338},{"$f":"$M27*'Standard - P&L'!E$26","v":273.09033379229362},{"$f":"$M27*'Standard - P&L'!F$26","v":284.27535729877803},{"$f":"$M27*'Standard - P&L'!G$26","v":287.14041029750484},{"$f":"$M27*'Standard - P&L'!H$26","v":290.10667137832144},{"$f":"$M27*'Standard - P&L'!I$26","v":293.17608725191366},{"$f":"$M27*'Standard - P&L'!J$26","v":296.3506621916207},{"$f":"$M27*'Standard - P&L'!K$26","v":299.63245929051749},{"$f":"$M27*'Standard - P&L'!L$26","v":303.0236017525807},1.6543901348457395E-2]
[null,"- Roads",2690,{"$f":"$M28*'Standard - P&L'!D$26","v":3041.0479259690346},{"$f":"$M28*'Standard - P&L'!E$26","v":3134.5176434850878},{"$f":"$M28*'Standard - P&L'!F$26","v":3262.8988023383208},{"$f":"$M28*'Standard - P&L'!G$26","v":3295.7837420918431},{"$f":"$M28*'Standard - P&L'!H$26","v":3329.8303433167498},{"$f":"$M28*'Standard - P&L'!I$26","v":3365.06095026414},{"$f":"$M28*'Standard - P&L'!J$26","v":3401.4985678864678},{"$f":"$M28*'Standard - P&L'!K$26","v":3439.1668762662662},{"$f":"$M28*'Standard - P&L'!L$26","v":3478.090245436093},0.18989009954580752]
[null,"- Bridges",12,{"$f":"$M29*'Standard - P&L'!D$26","v":13.567694303493029},{"$f":"$M29*'Standard - P&L'!E$26","v":13.984711261056285},{"$f":"$M29*'Standard - P&L'!F$26","v":14.557486291260323},{"$f":"$M29*'Standard - P&L'!G$26","v":14.704203087781183},{"$f":"$M29*'Standard - P&L'!H$26","v":14.856102659487297},{"$f":"$M29*'Standard - P&L'!I$26","v":15.01328469568832},{"$f":"$M29*'Standard - P&L'!J$26","v":15.17585183342581},{"$f":"$M29*'Standard - P&L'!K$26","v":15.343909721847266},{"$f":"$M29*'Standard - P&L'!L$26","v":15.517567088325611},8.4719836208316658E-4]
[null,"- Footpaths",119,{"$f":"$M30*'Standard - P&L'!D$26","v":134.16942144565328},{"$f":"$M30*'Standard - P&L'!E$26","v":138.29325580377883},{"$f":"$M30*'Standard - P&L'!F$26","v":143.95736443579656},{"$f":"$M30*'Standard - P&L'!G$26","v":145.40823053472505},{"$f":"$M30*'Standard - P&L'!H$26","v":146.9103485215966},{"$f":"$M30*'Standard - P&L'!I$26","v":148.46470421291784},{"$f":"$M30*'Standard - P&L'!J$26","v":150.07231257498859},{"$f":"$M30*'Standard - P&L'!K$26","v":151.73421836048965},{"$f":"$M30*'Standard - P&L'!L$26","v":153.45149676233106},8.3778504694890926E-3]
[null,"- Stormwater Drainage",188,{"$f":"$M31*'Standard - P&L'!D$26","v":212.56054408805744},{"$f":"$M31*'Standard - P&L'!E$26","v":219.09380975654847},{"$f":"$M31*'Standard - P&L'!F$26","v":228.06728522974507},{"$f":"$M31*'Standard - P&L'!G$26","v":230.36584837523853},{"$f":"$M31*'Standard - P&L'!H$26","v":232.74560833196765},{"$f":"$M31*'Standard - P&L'!I$26","v":235.20812689911702},{"$f":"$M31*'Standard - P&L'!J$26","v":237.75501205700434},{"$f":"$M31*'Standard - P&L'!K$26","v":240.38791897560716},{"$f":"$M31*'Standard - P&L'!L$26","v":243.10855105043456},1.3272774339302943E-2]
[null,"- Other Open Space/Recreational Assets",1115,{"$f":"$M32*'Standard - P&L'!D$26","v":1261.0418094302131},{"$f":"$M32*'Standard - P&L'!E$26","v":1299.8012188748423},{"$f":"$M32*'Standard - P&L'!F$26","v":1353.0374758488067},{"$f":"$M32*'Standard - P&L'!G$26","v":1366.6739869921064},{"$f":"$M32*'Standard - P&L'!H$26","v":1380.7922082956802},{"$f":"$M32*'Standard - P&L'!I$26","v":1395.4014053270309},{"$f":"$M32*'Standard - P&L'!J$26","v":1410.5111176289654},{"$f":"$M32*'Standard - P&L'!K$26","v":1426.1311647028042},{"$f":"$M32*'Standard - P&L'!L$26","v":1442.2716521538191},7.8742381098063197E-2]
[null,"- Other Infrastructure",270,{"$f":"$M33*'Standard - P&L'!D$26","v":304.89624143127389},{"$f":"$M33*'Standard - P&L'!E$26","v":314.26753917207043},{"$f":"$M33*'Standard - P&L'!F$26","v":327.13906693415561},{"$f":"$M33*'Standard - P&L'!G$26","v":330.43611938930496},{"$f":"$M33*'Standard - P&L'!H$26","v":333.84964032014511},{"$f":"$M33*'Standard - P&L'!I$26","v":337.38186996699591},{"$f":"$M33*'Standard - P&L'!J$26","v":341.03511481226332},{"$f":"$M33*'Standard - P&L'!K$26","v":344.81174902706778},{"$f":"$M33*'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},{"$f":"E40","v":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,{"$f":"C43*1.0275","v":1033.6650000000002},1062.0907875000003,1091.2982841562502,1121.3089869705473,1152.1449841122374,1183.8289711753239,1216.3842678826454,1249.8348352494183,1284.2052932187773]
[null,"- Other Infrastructure",839.33333333333337,{"$f":"C44*1.0275","v":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},{"$f":"D45*1.0275","v":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},{"$f":"D46*1.0275","v":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*'Standard - balance sheet'!C$24","v":90274.132959139592},{"$f":"$M50*'Standard - balance sheet'!D$24","v":90855.847893966609},{"$f":"$M50*'Standard - balance sheet'!E$24","v":91288.767881527208},{"$f":"$M50*'Standard - balance sheet'!F$24","v":91705.171597133944},{"$f":"$M50*'Standard - balance sheet'!G$24","v":92156.385516876762},{"$f":"$M50*'Standard - balance sheet'!H$24","v":92643.079205823597},{"$f":"$M50*'Standard - balance sheet'!I$24","v":93165.942027537603},{"$f":"$M50*'Standard - balance sheet'!J$24","v":93725.683576446419},{"$f":"$M50*'Standard - balance sheet'!K$24","v":94323.034121934936},{"$f":"$M50*'Standard - balance sheet'!L$24","v":94958.745064435207},9.957890710861643E-2]
[null,"- Other Structures",{"$f":"$M51*'Standard - balance sheet'!C$24","v":3436.8055157757017},{"$f":"$M51*'Standard - balance sheet'!D$24","v":3458.9518497374743},{"$f":"$M51*'Standard - balance sheet'!E$24","v":3475.4334458754429},{"$f":"$M51*'Standard - balance sheet'!F$24","v":3491.2862548659705},{"$f":"$M51*'Standard - balance sheet'!G$24","v":3508.4643150404036},{"$f":"$M51*'Standard - balance sheet'!H$24","v":3526.9931172546858},{"$f":"$M51*'Standard - balance sheet'!I$24","v":3546.8989061086659},{"$f":"$M51*'Standard - balance sheet'!J$24","v":3568.208696406728},{"$f":"$M51*'Standard - balance sheet'!K$24","v":3590.9502900647453},{"$f":"$M51*'Standard - balance sheet'!L$24","v":3615.1522934737704},3.7910454078879142E-3]
[null,"- Roads",{"$f":"$M52*'Standard - balance sheet'!C$24","v":407593.27957316692},{"$f":"$M52*'Standard - balance sheet'!D$24","v":410219.75839152507},{"$f":"$M52*'Standard - balance sheet'!E$24","v":412174.41884340084},{"$f":"$M52*'Standard - balance sheet'!F$24","v":414054.50730847003},{"$f":"$M52*'Standard - balance sheet'!G$24","v":416091.76599275204},{"$f":"$M52*'Standard - balance sheet'!H$24","v":418289.21802383597},{"$f":"$M52*'Standard - balance sheet'!I$24","v":420649.97592073824},{"$f":"$M52*'Standard - balance sheet'!J$24","v":423177.24354607641},{"$f":"$M52*'Standard - balance sheet'!K$24","v":425874.31811117567},{"$f":"$M52*'Standard - balance sheet'!L$24","v":428744.59223534272},0.44960490889548338]
[null,"- Bridges",{"$f":"$M53*'Standard - balance sheet'!C$24","v":11417.759327407563},{"$f":"$M53*'Standard - balance sheet'!D$24","v":11491.333904147277},{"$f":"$M53*'Standard - balance sheet'!E$24","v":11546.089082225017},{"$f":"$M53*'Standard - balance sheet'!F$24","v":11598.755302901851},{"$f":"$M53*'Standard - balance sheet'!G$24","v":11655.824274620822},{"$f":"$M53*'Standard - balance sheet'!H$24","v":11717.380683133528},{"$f":"$M53*'Standard - balance sheet'!I$24","v":11783.511718280459},{"$f":"$M53*'Standard - balance sheet'!J$24","v":11854.307128676524},{"$f":"$M53*'Standard - balance sheet'!K$24","v":11929.859277879337},{"$f":"$M53*'Standard - balance sheet'!L$24","v":12010.263202074908},1.2594615513694023E-2]
[null,"- Footpaths",{"$f":"$M54*'Standard - balance sheet'!C$24","v":28872.455469486435},{"$f":"$M54*'Standard - balance sheet'!D$24","v":29058.505869542118},{"$f":"$M54*'Standard - balance sheet'!E$24","v":29196.967050535703},{"$f":"$M54*'Standard - balance sheet'!F$24","v":29330.145817720604},{"$f":"$M54*'Standard - balance sheet'!G$24","v":29474.45796315969},{"$f":"$M54*'Standard - balance sheet'!H$24","v":29630.117634438484},{"$f":"$M54*'Standard - balance sheet'!I$24","v":29797.34531131266},{"$f":"$M54*'Standard - balance sheet'!J$24","v":29976.367943993122},{"$f":"$M54*'Standard - balance sheet'!K$24","v":30167.41909518055},{"$f":"$M54*'Standard - balance sheet'!L$24","v":30370.739085937061},3.1848409582565504E-2]
[null,"- Stormwater Drainage",{"$f":"$M55*'Standard - balance sheet'!C$24","v":193092.21203966092},{"$f":"$M55*'Standard - balance sheet'!D$24","v":194336.47348931778},{"$f":"$M55*'Standard - balance sheet'!E$24","v":195262.46940081654},{"$f":"$M55*'Standard - balance sheet'!F$24","v":196153.13776740647},{"$f":"$M55*'Standard - balance sheet'!G$24","v":197118.2635571569},{"$f":"$M55*'Standard - balance sheet'!H$24","v":198159.27893890557},{"$f":"$M55*'Standard - balance sheet'!I$24","v":199277.65842955935},{"$f":"$M55*'Standard - balance sheet'!J$24","v":200474.91981891249},{"$f":"$M55*'Standard - balance sheet'!K$24","v":201752.62511954035},{"$f":"$M55*'Standard - balance sheet'!L$24","v":203112.38154235479},0.21299469533313281]
[null,"- Other Open Space/Recreational Assets",{"$f":"$M56*'Standard - balance sheet'!C$24","v":21523.29005094503},{"$f":"$M56*'Standard - balance sheet'!D$24","v":21661.983371598857},{"$f":"$M56*'Standard - balance sheet'!E$24","v":21765.200784557404},{"$f":"$M56*'Standard - balance sheet'!F$24","v":21864.480363939812},{"$f":"$M56*'Standard - balance sheet'!G$24","v":21972.0594428111},{"$f":"$M56*'Standard - balance sheet'!H$24","v":22088.097659848409},{"$f":"$M56*'Standard - balance sheet'!I$24","v":22212.759374114881},{"$f":"$M56*'Standard - balance sheet'!J$24","v":22346.213768145812},{"$f":"$M56*'Standard - balance sheet'!K$24","v":22488.634953829856},{"$f":"$M56*'Standard - balance sheet'!L$24","v":22640.202081150659},2.3741747834066271E-2]
[null,"- Other Infrastructure",{"$f":"$M57*'Standard - balance sheet'!C$24","v":5799.1596211763062},{"$f":"$M57*'Standard - balance sheet'!D$24","v":5836.5286620134075},{"$f":"$M57*'Standard - balance sheet'!E$24","v":5864.3391989719621},{"$f":"$M57*'Standard - balance sheet'!F$24","v":5891.0887398924751},{"$f":"$M57*'Standard - balance sheet'!G$24","v":5920.0744687841561},{"$f":"$M57*'Standard - balance sheet'!H$24","v":5951.3393981310755},{"$f":"$M57*'Standard - balance sheet'!I$24","v":5984.9278122615169},{"$f":"$M57*'Standard - balance sheet'!J$24","v":6020.8852951231465},{"$f":"$M57*'Standard - balance sheet'!K$24","v":6059.2587588112729},{"$f":"$M57*'Standard - balance sheet'!L$24","v":6100.0964728678136},6.3968930888157549E-3]
[]
[null,"Asset Maintanenace Ratio",{"$f":"C60/C61","v":0.87454451610894335},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,84257.116860000038,87538.279871045379,89664.431541824204,92328.817180821308,94449.923899763075,98015.427241085345,100126.8845443879,103366.07736128835,105380.52736040336,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},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},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},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 infrastrcuture",35,{"$f":"D57*$M$74","v":35.225535511132087},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},3886.1933476281674,3903.9197929189909,3923.1281202297218,3943.8468331690015,3966.1052781740214,3989.9336629166387,4015.3630752085455,4042.4255024171716,{"$f":"C75/C56","v":0.178550769464321}]
[null,"- Buidlings",1575,{"$f":"D50*$M$76","v":1585.1490980009439},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 - Consolidated"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Special Schedule 7 Graphs - Standard Scenario - Consolidated"]

{"sheet":"Strategic - P&L","index":6,"n_rows":48,"n_cols":12,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Profit & Loss Statement - Strategic Scenario - Consolidated"]
[]
[null,"For the period ended 30 June",2020,{"$f":"C9+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",41681.748250000019,42875.176956250019,44285.975380156262,45742.223764660164,47227.798358776665,48408.493317746077,49618.705650689728,50859.173291956969,52130.65262425589,53433.918939862284]
[null,"Interest & Investment Revenue",1421.4132,1229.5597984069309,1209.9643001371119,1265.4203776925669,1307.4962023816261,1355.208251808514,1441.2571018306799,1474.1546569001703,1517.8862298373151,1531.2208769936524]
[null,"Other Revenues",7083.982,7261.0815499999999,7442.6085887499994,7628.6738034687487,7819.3906485554671,8014.8754147693535,8215.2473001385861,8420.6284826420506,8631.1441947081021,8846.9227995758047]
[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(C12:C18)","v":129747.88833040469},{"$f":"SUM(D12:D18)","v":135294.64276950405},141513.63439537637,148155.50812947241,155136.92725099361,162165.47683208867,169632.70026331089,173984.85631275832,178455.16729073963,183005.07206533919]
[]
[null,"Operating Expenses"]
[null,"Employee Benefits & On-Costs",47967.327083455901,49325.270331900487,51761.44521334819,55087.586100662826,58404.15712573941,61140.221114806234,64096.929282093857,67381,70171.815594264481,72887]
[null,"Borrowing Costs",1317.3047515684264,1822.909542757978,2173.8833945731358,2408.3853468705438,2725.9896577987533,2903.5996840414196,2723.5745630046567,2692.883737063386,2500.4416829457891,2302.3504294009267]
[null,"Materials & Contracts",40113.11048000001,41615.938242000004,42143.83669805,43225.932615501246,44327.368430888775,46186.552641660986,46828.441457702509,48048,49349.120681498694,51183]
[null,"Depreciation & Amortisation",16293.388652568608,16822.604174294807,17952.899608761327,18245.531243017442,18525.197083397252,19264.581600943853,19582.044130090111,19836.45119126905,20144.207002986161,20395.310417842917]
[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",14394.338899999997,14754.197372499995,15123.052306812493,15501.128614482803,15938.656829844871,16337.123250590992,16745.551331855764,17164.190115152156,17593.29486803096,18034]
[null,"Total Operating Expenses",{"$f":"SUM(C22:C27)","v":120348.21137959295},{"$f":"SUM(D22:D27)","v":124635.11287305327},{"$f":"SUM(E22:E27)","v":129476.57178922514},134813.98007467884,140288.16086348426,146218.23196350815,150380.50199180143,155543.1082722581,160195.19601605303,165253.05963969624]
[]
[null,"Operating Surplus / (Deficit) ",{"$f":"C19-C28","v":9399.6769508117432},{"$f":"D19-D28","v":10659.529896450782},12037.06260615123,13341.528054793569,14848.766387509357,15947.244868580514,19252.198271509464,18441.748040500213,18259.971274686599,{"$f":"L19-L28","v":17752.012425642955}]
[]
[null,"Other Comprehensive Income",0,0,0,0,0,0,0,0,0,0]
[]
[null,"Total Comprehensive Income",{"$f":"SUM(C30:C33)","v":9399.6769508117432},{"$f":"SUM(D30:D33)","v":10659.529896450782},12037.06260615123,13341.528054793569,14848.766387509357,15947.244868580514,19252.198271509464,18441.748040500213,18259.971274686599,{"$f":"SUM(L30:L33)","v":17752.012425642955}]
[]
[null,"Net Operating Result before Capital Grants",{"$f":"+C34-C17","v":3534.1669508117429},4676.7096964507818,5934.5860021512299,7117.0019187135686,8499.7497287077567,9471.2478766028817,12646.681339692279,11704.120770046684,11387.591458824001,10742.185013463104]
[]
[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",-4011.7410724999977,-4111.3401961437485,-4213.2490387564503,-4317.5203861864702,-4424.2082076074239,-4533.3676813524717,-4645.0552212914008,-4759.3285037612004,-4876.2464950610229,-5230.2884395227547]
[null,"Local election costs",0,500,0,0,0,550,0,0,0,600]
[null,"NAP dividend ",1984.8617384622914,2055.6700980718742,2106.6245193782252,2158.7601930932351,2212.104103803712,2266.6838406762358,2322.5276106457004,2379.6642518806002,2438.1232475305114,2615.1442197613774]
[null,"Underlying result",{"$f":"SUM(C36:C43)","v":470.6126167740365},1875.0163483789092,2552.057535273002,3651.5606596953294,4949.2641270012928,6383.5310930868127,8919.489797921553,7885.152669107305,7474.4852467629462,{"$f":"SUM(L36:L43)","v":7215.3083402352677}]
[]
[null,"Less: SRV loan repayments",{"$f":"-[3]SRV!D91/1000","v":-550},{"$f":"-[3]SRV!E91/1000","v":-1128.9473684210525},{"$f":"-[3]SRV!F91/1000","v":-1684.5029239766081},{"$f":"-[3]SRV!G91/1000","v":-2155.0911592707257},{"$f":"-[3]SRV!H91/1000","v":-2780.0911592707257},{"$f":"-[3]SRV!I91/1000","v":-3246.7578259373922},{"$f":"-[3]SRV!J91/1000","v":-3246.7578259373922},{"$f":"-[3]SRV!K91/1000","v":-3477.5270567066232},{"$f":"-[3]SRV!L91/1000","v":-3477.5270567066232},{"$f":"-[3]SRV!M91/1000","v":-3477.5270567066232}]
[]
[null,"Revised underlying result",{"$f":"C44+C46","v":-79.387383225963504},{"$f":"D44+D46","v":746.06897995785675},867.55461129639389,1496.4695004246037,2169.1729677305671,3136.7732671494205,5672.7319719841607,4407.6256124006813,3996.958190056323,3737.7812835286445]

{"sheet":"Strategic - Balance Sheet","index":7,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Balance Sheet - Strategic Scenario - Consolidated"]
[]
[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",{"$f":"'Strategic - P&L'!C9","v":2020},{"$f":"'Strategic - P&L'!D9","v":2021},{"$f":"'Strategic - P&L'!E9","v":2022},{"$f":"'Strategic - P&L'!F9","v":2023},{"$f":"'Strategic - P&L'!G9","v":2024},{"$f":"'Strategic - P&L'!H9","v":2025},{"$f":"'Strategic - P&L'!I9","v":2026},{"$f":"'Strategic - P&L'!J9","v":2027},{"$f":"'Strategic - P&L'!K9","v":2028},{"$f":"'Strategic - P&L'!L9","v":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.3919362772303,7157.5720054844751,9375.8151077026687,11058.848095265046,12967.330072340555,16409.284073227183,17725.186276006811,19474.449193492597,20007.835079746095,24258.484102193892]
[null,"Investments",41241,41241,41241,41241,41241,41241,41241,41241,41241,41241]
[null,"Receivables",6907.6189878242812,7234.2708732658275,7590.5150941493548,7967.2132687338644,8364.6614244752964,8764.1637704119912,9187.2407357714656,9426.146754165753,9671.0254230198971,9922.0260585953929]
[null,"Inventories",2675,2675,2675,2675,2675,2675,2675,2675,2675,2675]
[]
[null,"Total Current Assets",{"$f":"SUM(C14:C17)","v":58765.010924101509},58307.8428787503,60882.330201852026,62942.06136399891,65247.991496815855,69089.44784363918,70828.427011778273,72816.595947658352,73594.860502765994,{"$f":"SUM(L14:L17)","v":78096.510160789287}]
[]
[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",927505.48285762139,944889.4530927015,960291.11805354955,975010.3728103817,992872.71583915025,1009581.2700047428,1022971.1153299501,1039168.7896308507,1052384.7588338377,1064439.830555147]
[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":978418.22390562145},996924.27418110147,1013461.1447717696,1029333.1895966326,1048369.6856726451,1066276.996476898,1080893.0188076429,1098346.774887833,1112850.9560570025,1126229.3952570045]
[null,"Total Assets",{"$f":"C28+C19","v":1037183.2348297229},1055232.1170598518,1074343.4749736218,1092275.2509606315,1113617.677169461,1135366.4443205371,1151721.4458194212,1171163.3708354915,1186445.8165597685,1204325.9054177939]
[]
[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.4435890288096,4095.0394822234139,4652.4610551928508,4794.0206215525495,3899.2166856283993,3923.9494060576185,4180.3957969463099,4265.1079400725885,3998.5788650456147,3998.5788650456147]
[null,"Provisions",15815.286166033435,15962.275837969417,16686.060509298994,17343.722733837367,18003.374658987443,19943.257026489377,20410.59424329787,21628.886506486451,21635.365987984907,24345.758794950649]
[null,"Other Current Liabilities",0,0,0,0,0,0,0,0,0,1]
[null,"Total Current Liabilities",{"$f":"SUM(C33:C36)","v":29006.614060662247},29212.821733432829,30610.165638062845,31641.178530800189,31654.612399411373,33984.028013712414,34836.707160938735,36395.854495270956,36398.351402960237,{"$f":"SUM(L33:L36)","v":39510.854373674214}]
[]
[null,"Non Current Liabilities"]
[null,"Trade & Other Payables",3564,3018.5,2473,1927.5,1382,836.5,291,0,0,0]
[null,"Borrowings",27971.190950747117,34876.151468523705,40223.690413330856,43429.669791778302,49530.453106149907,52606.503700092289,48426.107903145974,47160.999963073387,43162.421098027771,39163.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":32346.620302571122},39529.764963478738,45206.716366467263,48765.951405946398,55246.177358655194,58718.284026849826,54968.408106998322,54410.035509162124,{"$f":"SUM(K40:K43)","v":51431.013051063746},{"$f":"SUM(L40:L43)","v":48448.184359873354}]
[null,"Total Liabilities",{"$f":"C44+C37","v":61353.234363233365},68742.586696911574,75816.882004530111,80407.129936746584,86900.789758066559,92702.312040562247,89805.115267937057,90805.89000443308,87829.364454023977,{"$f":"L44+L37","v":87959.038733547568}]
[null,"Net Assets",{"$f":"C29-C45","v":975830.00046648958},986489.53036294016,998526.59296909161,1011868.121023885,1026716.8874113945,1042664.1322799749,1061916.3305514841,1080357.4808310585,1098616.4521057445,{"$f":"L29-L45","v":1116366.8666842463}]
[]
[null,"EQUITY"]
[null,"Accumulated Surplus",607271.44852932415,617930.97842577496,629968.04103192617,643308.56908671977,658158.33547422918,674105.58034280967,693356.77861431916,711798.92889389303,730056.90016857965,747807.31474708114]
[null,"Asset Revaluation Reserves",368559,368559,368559,368559,368559,368558,368559,368558,368559,368560]
[null,"Total Equity",{"$f":"SUM(C49:C50)","v":975830.44852932415},986489.97842577496,998527.04103192617,1011867.5690867198,1026717.3354742292,1042663.5803428097,1061915.7786143192,1080356.928893893,1098615.9001685795,1116367.3147470811]

{"sheet":"Strategic - Cashflow","index":8,"n_rows":67,"n_cols":12,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Cashflow Statement - Strategic Scenario - Consolidated"]
[]
[null,"For the period ended 30 June",2020,{"$f":"C9+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",60667.890483348761,64721.461372905556,68902.277019786969,73379.775384282344,78165.38197581518,83300.495377655738,88768.968552975683,91336.690637899243,93773.857903846729,96270.954351442895]
[null,"User Charges & Fees",41681.748250000019,42875.176956250019,44285.975380156262,45742.223764660164,47227.798358776665,48408.493317746077,49618.705650689728,50859.173291956969,52130.65262425589,53433.918939862284]
[null,"Interest & Investment Revenue Received",1421.4132,1229.5597984069309,1209.9643001371119,1265.4203776925669,1307.4962023816261,1355.208251808514,1440,1473,1517,1529]
[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",6297.3070000000007,6265.0583000000015,6416.7046412499967,6571.9927375437446,6731.0091506527151,6893.8424719295208,7060.5833690135605,7231.3246335832719,7406.1612301775585,7585.1903461093461]
[null,"Payments:"]
[null,"Employee Benefits & On-Costs",-48789.776005739935,-50295.9441469675,-53360.142342859137,-56633,-60000,-63945,-65519,-69576,-71157,-76608]
[null,"Materials & Contracts",-40258.555453400011,-41401.06034964,-41714.474358380998,-42918,-44024,-46050,-46424,-48025,-49635,-51587]
[null,"Borrowing Costs",-1317.3047515684264,-1822.909542757978,-2173.8833945731358,-2408.3853468705438,-2725.9896577987533,-2903.5996840414196,-2723.5745630046567,-2692.883737063386,-2500.4416829457891,-2302.3504294009267]
[null,"Bonds & Deposits Refunded"]
[null,"Other",-12458.551108631924,-13242.605527085969,-12784.382727128574,-13025,-13354,-11000,-14710,-12820,-15051,-9783]
[null,"Net Cash provided (or used in) Operating Activities",{"$f":"SUM(C13:C24)","v":23307.087474008484},{"$f":"SUM(D13:D24)","v":24774.608067611047},27620.066604050979,29214.63600609234,30978.53825283068,34131.400778816351,36014.887799927557,36731.123351236951,35881.283350465004,38398.879387913672]
[]
[]
[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",-31478.521374999997,-32021.734409374996,-31126.027769609373,-30691.678463849603,-34068.970425445841,-33608.194686081988,-30559.64955323403,-33573.640792064878,-30850.481811866499,-29890.493857163161]
[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(C30:C38)","v":-31638.521374999997},{"$f":"SUM(D30:D38)","v":-32191.984409374996},{"$f":"SUM(E30:E38)","v":-31306.784019609371},{"$f":"SUM(F31:F38)","v":-30883.203620099604},{"$f":"SUM(G31:G38)","v":-34271.533710602089},-33822.072053367141,-30785.123854701316,-33811.001951068843,-31100.026999845566,-30152.527674841702]
[]
[]
[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.4435890288059,-4095.0394822234139,-4652.4610551928581,-4794.0206215525423,-3899.2166856283993,-3923.9494060576258,-4180.3957969463099,-4265.1079400725885,-3998.5788650456147]
[null,"Net Cash Flow provided (used in) Financing Activities",{"$f":"SUM(C44:C49)","v":13648.186476941295},6633.5564109711941,5904.9605177765861,3347.5389448071419,5205.9793784474577,3100.7833143716007,-3923.9494060576258,-1180.3957969463099,-4265.1079400725885,-3998.5788650456147]
[]
[null,"Net Increase/(Decrease) in Cash & Cash Equivalents",{"$f":"+C25+C39+C50","v":5316.7525759497821},{"$f":"+D25+D39+D50","v":-783.81993079275526},2218.2431022181936,1678.9713307998773,1912.9839206760489,3410.1120398208104,1305.8145391686153,1739.7256032217974,516.14841054684985,4247.7728480263559]
[]
[null,"plus: Cash - beginning of year",2624.6393603274482,{"$f":"C56","v":7941.3919362772303},7157.5720054844751,9375.8151077026687,11054.786438502546,12967.770359178594,16377.882398999405,17683.696938168021,19423.422541389817,19939.570951936665]
[]
[null,"Cash - end of the year",{"$f":"+C54+C52","v":7941.3919362772303},7157.5720054844751,9375.8151077026687,11054.786438502546,12967.770359178594,16377.882398999405,17683.696938168021,{"$f":"+J54+J52","v":19423.422541389817},{"$f":"+K54+K52","v":19939.570951936665},{"$f":"+L54+L52","v":24187.343799963019}]
[null,"plus: Investments - end of the year",41241,41241,41241,41241,41241,41241,41241,41241,41241,41241]
[null,"Total Cash & Investments - end of the year",{"$f":"+C56+C57","v":49182.391936277229},48398.572005484471,50616.815107702671,52295.786438502546,54208.770359178598,57618.882398999405,58924.696938168025,60664.422541389817,61180.570951936665,65428.343799963019]
[]
[null,"Representing:"]
[null,"- External Restrictions"]
[null,"- Internal Restricitons"]
[null,"- Unrestricted"]
[]
[]
[null,"Less restricted Cash (NAL)",-13936.977161249999,-14362.984374946873,-16336.704437840724,-18359.237563037477,-20431.708922247293,-22555.269199714789,-24731.095158071526,-26960.390216355943,-29244.385040450365,-31701.547626189749]
[null,"Cash, Cash Equivalents & Investments - end of the year",{"$f":"C58+C66","v":35245.414775027231},{"$f":"D58+D66","v":34035.5876305376},34280.110669861948,33936.548875465072,33777.061436931304,35063.61319928462,34193.601780096498,33704.03232503387,31936.1859114863,33726.796173773269]

{"sheet":"Strategic - Ratios","index":9,"n_rows":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Ratios - Strategic Scenario - Consolidated"]
[]
[null,null,{"$f":"'Strategic - P&L'!C9","v":2020},{"$f":"'Strategic - P&L'!D9","v":2021},{"$f":"'Strategic - P&L'!E9","v":2022},{"$f":"'Strategic - P&L'!F9","v":2023},{"$f":"'Strategic - P&L'!G9","v":2024},{"$f":"'Strategic - P&L'!H9","v":2025},{"$f":"'Strategic - P&L'!I9","v":2026},{"$f":"'Strategic - P&L'!J9","v":2027},{"$f":"'Strategic - P&L'!K9","v":2028},{"$f":"'Strategic - P&L'!L9","v":2029}]
[]
[null,"Operating Performance",{"$f":"(C13-C14-C15)/(C13-C14)","v":2.0330315860494639E-2},2.6788467058966758E-2,3.4731227780532711E-2,4.1318042574913685E-2,4.8568267900167834E-2,5.2490256975922751E-2,6.9557246417615265E-2,6.1907878703774032E-2,5.8272508559068209E-2,{"$f":"(L13-L14-L15)/(L13-L14)","v":5.2901574731213513E-2}]
[null,"Operating Perfomance Min Target",0,0,0,0,0,0,0,0,0,0]
[null,"Operating Revenue*",{"$f":"'Strategic - P&L'!C19+'Strategic - P&L'!C40-'Strategic - P&L'!C18","v":128711.21333040469},{"$f":"'Strategic - P&L'!D19+'Strategic - P&L'!D40-'Strategic - P&L'!D18","v":134048.61951950405},{"$f":"'Strategic - P&L'!E19+'Strategic - P&L'!E40-'Strategic - P&L'!E18","v":140237.73044787638},{"$f":"'Strategic - P&L'!F19+'Strategic - P&L'!F40-'Strategic - P&L'!F18","v":146848.82706354742},{"$f":"'Strategic - P&L'!G19+'Strategic - P&L'!G40-'Strategic - P&L'!G18","v":153798.54575309088},{"$f":"'Strategic - P&L'!H19+'Strategic - P&L'!H40-'Strategic - P&L'!H18","v":160794.44388924883},{"$f":"'Strategic - P&L'!I19+'Strategic - P&L'!I40-'Strategic - P&L'!I18","v":168228.03633218587},{"$f":"'Strategic - P&L'!J19+'Strategic - P&L'!J40-'Strategic - P&L'!J18","v":172545.55246369954},{"$f":"'Strategic - P&L'!K19+'Strategic - P&L'!K40-'Strategic - P&L'!K18","v":176980.1843262091},{"$f":"'Strategic - P&L'!L19+'Strategic - P&L'!L40-'Strategic - P&L'!L18","v":181493.33961187274}]
[null,"Capital Grants",{"$f":"'Strategic - P&L'!C17","v":5865.51},{"$f":"'Strategic - P&L'!D17","v":5982.8202000000001},{"$f":"'Strategic - P&L'!E17","v":6102.4766040000004},{"$f":"'Strategic - P&L'!F17","v":6224.5261360800005},{"$f":"'Strategic - P&L'!G17","v":6349.0166588016},{"$f":"'Strategic - P&L'!H17","v":6475.9969919776322},{"$f":"'Strategic - P&L'!I17","v":6605.5169318171847},{"$f":"'Strategic - P&L'!J17","v":6737.6272704535286},{"$f":"'Strategic - P&L'!K17","v":6872.3798158625987},{"$f":"'Strategic - P&L'!L17","v":7009.8274121798513}]
[null,"Operating Expenses",{"$f":"'Strategic - P&L'!C28","v":120348.21137959295},{"$f":"'Strategic - P&L'!D28","v":124635.11287305327},{"$f":"'Strategic - P&L'!E28","v":129476.57178922514},{"$f":"'Strategic - P&L'!F28","v":134813.98007467884},{"$f":"'Strategic - P&L'!G28","v":140288.16086348426},{"$f":"'Strategic - P&L'!H28","v":146218.23196350815},{"$f":"'Strategic - P&L'!I28","v":150380.50199180143},{"$f":"'Strategic - P&L'!J28","v":155543.1082722581},{"$f":"'Strategic - P&L'!K28","v":160195.19601605303},{"$f":"'Strategic - P&L'!L28","v":165253.05963969624}]
[]
[null,"Own Source Revenue ",{"$f":"+C19/C20","v":0.85855998565356118},0.8610152698828113,0.864041119142689,0.86712378290675651,0.87015864284060096,0.87290044587455562,0.87567206306196921,0.87594404538784698,0.87621920638946205,{"$f":"+L19/L20","v":0.87646899599822892}]
[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'!C12+'Strategic - P&L'!C13+'Strategic - P&L'!C15+'Strategic - P&L'!C14+'Strategic - P&L'!C40","v":110506.29747040469},{"$f":"'Strategic - P&L'!D12+'Strategic - P&L'!D13+'Strategic - P&L'!D15+'Strategic - P&L'!D14+'Strategic - P&L'!D40","v":115417.90831300407},{"$f":"'Strategic - P&L'!E12+'Strategic - P&L'!E13+'Strategic - P&L'!E15+'Strategic - P&L'!E14+'Strategic - P&L'!E40","v":121171.16556221386},{"$f":"'Strategic - P&L'!F12+'Strategic - P&L'!F13+'Strategic - P&L'!F15+'Strategic - P&L'!F14+'Strategic - P&L'!F40","v":127336.11043876332},{"$f":"'Strategic - P&L'!G12+'Strategic - P&L'!G13+'Strategic - P&L'!G15+'Strategic - P&L'!G14+'Strategic - P&L'!G40","v":133829.13384336763},{"$f":"'Strategic - P&L'!H12+'Strategic - P&L'!H13+'Strategic - P&L'!H15+'Strategic - P&L'!H14+'Strategic - P&L'!H40","v":140357.54176507652},{"$f":"'Strategic - P&L'!I12+'Strategic - P&L'!I13+'Strategic - P&L'!I15+'Strategic - P&L'!I14+'Strategic - P&L'!I40","v":147312.59163986912},{"$f":"'Strategic - P&L'!J12+'Strategic - P&L'!J13+'Strategic - P&L'!J15+'Strategic - P&L'!J14+'Strategic - P&L'!J40","v":151140.24923873396},{"$f":"'Strategic - P&L'!K12+'Strategic - P&L'!K13+'Strategic - P&L'!K15+'Strategic - P&L'!K14+'Strategic - P&L'!K40","v":155073.43665697164},{"$f":"'Strategic - P&L'!L12+'Strategic - P&L'!L13+'Strategic - P&L'!L15+'Strategic - P&L'!L14+'Strategic - P&L'!L40","v":159073.28514998368}]
[null,"Total operating Revenue*",{"$f":"C13","v":128711.21333040469},134048.61951950405,140237.73044787638,146848.82706354742,153798.54575309088,160794.44388924883,168228.03633218587,172545.55246369954,176980.1843262091,{"$f":"L13","v":181493.33961187274}]
[]
[null,"Capital Expenditure Ratio",{"$f":"C24/C25","v":1.9260854473857596},1.8953302818142639,1.7268344322827724,1.6746431989180484,1.827310721012865,1.7338828079989224,1.5528427667316118,1.6814406909122128,1.5232862017873661,{"$f":"L24/L25","v":1.4583849838432623}]
[null,"Capital Expenditure Ratio Min Target",1,1,1,1,1,1,1,1,1,1]
[null,"Capital Expenditure",{"$f":"-'Strategic - Cashflow'!C37-'Strategic - Cashflow'!C38","v":31888.521374999997},{"$f":"-'Strategic - Cashflow'!D37-'Strategic - Cashflow'!D38","v":32441.984409374996},{"$f":"-'Strategic - Cashflow'!E37-'Strategic - Cashflow'!E38","v":31556.784019609371},{"$f":"-'Strategic - Cashflow'!F37-'Strategic - Cashflow'!F38","v":31133.203620099604},{"$f":"-'Strategic - Cashflow'!G37-'Strategic - Cashflow'!G38","v":34521.533710602089},{"$f":"-'Strategic - Cashflow'!H37-'Strategic - Cashflow'!H38","v":34072.072053367141},{"$f":"-'Strategic - Cashflow'!I37-'Strategic - Cashflow'!I38","v":31035.123854701316},{"$f":"-'Strategic - Cashflow'!J37-'Strategic - Cashflow'!J38","v":34061.001951068843},{"$f":"-'Strategic - Cashflow'!K37-'Strategic - Cashflow'!K38","v":31350.026999845566},{"$f":"-'Strategic - Cashflow'!L37-'Strategic - Cashflow'!L38","v":30402.527674841702}]
[null,"Depreciation",{"$f":"'Strategic - P&L'!C25+'Strategic - P&L'!C26","v":16556.130164568607},{"$f":"'Strategic - P&L'!D25+'Strategic - P&L'!D26","v":17116.797383894806},{"$f":"'Strategic - P&L'!E25+'Strategic - P&L'!E26","v":18274.354176441328},{"$f":"'Strategic - P&L'!F25+'Strategic - P&L'!F26","v":18590.947397161442},{"$f":"'Strategic - P&L'!G25+'Strategic - P&L'!G26","v":18891.988819212453},{"$f":"'Strategic - P&L'!H25+'Strategic - P&L'!H26","v":19650.735272408514},{"$f":"'Strategic - P&L'!I25+'Strategic - P&L'!I26","v":19986.005357144651},{"$f":"'Strategic - P&L'!J25+'Strategic - P&L'!J26","v":20257.034420042564},{"$f":"'Strategic - P&L'!K25+'Strategic - P&L'!K26","v":20580.523189313102},{"$f":"'Strategic - P&L'!L25+'Strategic - P&L'!L26","v":20846.709210295303}]
[]
[null,"Debt Service Coverage ratio",{"$f":"C28/(C29+C30)","v":3.411067028960995},{"$f":"D28/(D29+D30)","v":3.1211539591637143},3.4652000603421111,3.276639450122639,3.2906684869279861,3.880119721009637,4.4808812728633196,4.2261771168187323,4.2827629783671952,{"$f":"L28/(L29+L30)","v":4.5304334581976464}]
[null,"EBITDA",{"$f":"'Strategic - P&L'!C36+'Strategic - P&L'!C25+'Strategic - P&L'!C26+'Strategic - P&L'!C40-'Strategic - P&L'!C18-'Strategic - P&L'!C14","v":17632.208915380354},{"$f":"'Strategic - P&L'!D36+'Strategic - P&L'!D25+'Strategic - P&L'!D26+'Strategic - P&L'!D40-'Strategic - P&L'!D18-'Strategic - P&L'!D14","v":19317.924031938655},{"$f":"'Strategic - P&L'!E36+'Strategic - P&L'!E25+'Strategic - P&L'!E26+'Strategic - P&L'!E40-'Strategic - P&L'!E18-'Strategic - P&L'!E14","v":21723.071930955444},{"$f":"'Strategic - P&L'!F36+'Strategic - P&L'!F25+'Strategic - P&L'!F26+'Strategic - P&L'!F40-'Strategic - P&L'!F18-'Strategic - P&L'!F14","v":23135.84787225744},{"$f":"'Strategic - P&L'!G36+'Strategic - P&L'!G25+'Strategic - P&L'!G26+'Strategic - P&L'!G40-'Strategic - P&L'!G18-'Strategic - P&L'!G14","v":24745.860847635831},{"$f":"'Strategic - P&L'!H36+'Strategic - P&L'!H25+'Strategic - P&L'!H26+'Strategic - P&L'!H40-'Strategic - P&L'!H18-'Strategic - P&L'!H14","v":26395.741954363049},{"$f":"'Strategic - P&L'!I36+'Strategic - P&L'!I25+'Strategic - P&L'!I26+'Strategic - P&L'!I40-'Strategic - P&L'!I18-'Strategic - P&L'!I14","v":29786.765663881222},{"$f":"'Strategic - P&L'!J36+'Strategic - P&L'!J25+'Strategic - P&L'!J26+'Strategic - P&L'!J40-'Strategic - P&L'!J18-'Strategic - P&L'!J14","v":29047.6966841303},{"$f":"'Strategic - P&L'!K36+'Strategic - P&L'!K25+'Strategic - P&L'!K26+'Strategic - P&L'!K40-'Strategic - P&L'!K18-'Strategic - P&L'!K14","v":28975.245453769247},{"$f":"'Strategic - P&L'!L36+'Strategic - P&L'!L25+'Strategic - P&L'!L26+'Strategic - P&L'!L40-'Strategic - P&L'!L18-'Strategic - P&L'!L14","v":28545.940893298299}]
[null,"Principal repayments",{"$f":"-'Strategic - Cashflow'!C49","v":3851.813523058705},{"$f":"-'Strategic - Cashflow'!D49","v":4366.4435890288059},{"$f":"-'Strategic - Cashflow'!E49","v":4095.0394822234139},{"$f":"-'Strategic - Cashflow'!F49","v":4652.4610551928581},{"$f":"-'Strategic - Cashflow'!G49","v":4794.0206215525423},{"$f":"-'Strategic - Cashflow'!H49","v":3899.2166856283993},{"$f":"-'Strategic - Cashflow'!I49","v":3923.9494060576258},{"$f":"-'Strategic - Cashflow'!J49","v":4180.3957969463099},{"$f":"-'Strategic - Cashflow'!K49","v":4265.1079400725885},{"$f":"-'Strategic - Cashflow'!L49","v":3998.5788650456147}]
[null,"Interest expense",{"$f":"'Strategic - P&L'!C23","v":1317.3047515684264},{"$f":"'Strategic - P&L'!D23","v":1822.909542757978},{"$f":"'Strategic - P&L'!E23","v":2173.8833945731358},{"$f":"'Strategic - P&L'!F23","v":2408.3853468705438},{"$f":"'Strategic - P&L'!G23","v":2725.9896577987533},{"$f":"'Strategic - P&L'!H23","v":2903.5996840414196},{"$f":"'Strategic - P&L'!I23","v":2723.5745630046567},{"$f":"'Strategic - P&L'!J23","v":2692.883737063386},{"$f":"'Strategic - P&L'!K23","v":2500.4416829457891},{"$f":"'Strategic - P&L'!L23","v":2302.3504294009267}]
[null,"Debt Service Coverage ratio Min Target",2,2,2,2,2,2,2,2,2,2]
[]
[null,"Debt Service Ratio",{"$f":"(C36+C37)/(C34-C35)","v":4.2078136511818555E-2},4.8329477227134779E-2,4.6735833400614553E-2,5.0210712910176987E-2,5.1000571690822345E-2,4.4082975862233829E-2,4.1129936556644951E-2,4.1453263021046904E-2,3.9772129459274018E-2,3.611188939866853E-2]
[null,"Operating Revenue",{"$f":"C13","v":128711.21333040469},134048.61951950405,140237.73044787638,146848.82706354742,153798.54575309088,160794.44388924883,168228.03633218587,172545.55246369954,176980.1843262091,181493.33961187274]
[null,"Capital Grants",5865.51,5982.8202000000001,6102.4766040000004,6224.5261360800005,6349.0166588016,6475.9969919776322,6605.5169318171847,6737.6272704535286,6872.3798158625987,7009.8274121798513]
[null,"Principal repayments",{"$f":"C29","v":3851.813523058705},4366.4435890288059,4095.0394822234139,4652.4610551928581,4794.0206215525423,3899.2166856283993,3923.9494060576258,4180.3957969463099,4265.1079400725885,3998.5788650456147]
[null,"Interest expense",1317.3047515684264,1822.909542757978,2173.8833945731358,2408.3853468705438,2725.9896577987533,2903.5996840414196,2723.5745630046567,2692.883737063386,2500.4416829457891,2302.3504294009267]
[]
[null,"Cash Expense Cover Ratio",{"$f":"C41/(C42/12)","v":5.5325349523297165},{"$f":"D41/(D42/12)","v":5.2262060904252472},5.3221137213758087,5.245452852819489,5.2082914920357828,5.4103161417716423,5.3045280108735824,5.3022826076038276,5.1481264858522788,{"$f":"L41/(L42/12)","v":5.4418211268897814}]
[null,"Cash Expense Cover Ratio Min Target",3,3,3,3,3,3,3,3,3,3]
[null,"Cash & Cash Equivalents",{"$f":"'Strategic - Cashflow'!C58","v":49182.391936277229},{"$f":"'Strategic - Cashflow'!D58","v":48398.572005484471},{"$f":"'Strategic - Cashflow'!E58","v":50616.815107702671},{"$f":"'Strategic - Cashflow'!F58","v":52295.786438502546},{"$f":"'Strategic - Cashflow'!G58","v":54208.770359178598},{"$f":"'Strategic - Cashflow'!H58","v":57618.882398999405},{"$f":"'Strategic - Cashflow'!I58","v":58924.696938168025},{"$f":"'Strategic - Cashflow'!J58","v":60664.422541389817},{"$f":"'Strategic - Cashflow'!K58","v":61180.570951936665},{"$f":"'Strategic - Cashflow'!L58","v":65428.343799963019}]
[null,"Total Expenses - Depreciation and Interest Cost",{"$f":"-SUM('Strategic - Cashflow'!C20:C24)-'Strategic - Cashflow'!C49","v":106676.00084239901},{"$f":"-SUM('Strategic - Cashflow'!D20:D24)-'Strategic - Cashflow'!D49","v":111128.96315548023},{"$f":"-SUM('Strategic - Cashflow'!E20:E24)-'Strategic - Cashflow'!E49","v":114127.92230516524},{"$f":"-SUM('Strategic - Cashflow'!F20:F24)-'Strategic - Cashflow'!F49","v":119636.84640206341},{"$f":"-SUM('Strategic - Cashflow'!G20:G24)-'Strategic - Cashflow'!G49","v":124898.01027935129},{"$f":"-SUM('Strategic - Cashflow'!H20:H24)-'Strategic - Cashflow'!H49","v":127797.81636966982},{"$f":"-SUM('Strategic - Cashflow'!I20:I24)-'Strategic - Cashflow'!I49","v":133300.52396906228},{"$f":"-SUM('Strategic - Cashflow'!J20:J24)-'Strategic - Cashflow'!J49","v":137294.27953400969},{"$f":"-SUM('Strategic - Cashflow'!K20:K24)-'Strategic - Cashflow'!K49","v":142608.54962301839},{"$f":"-SUM('Strategic - Cashflow'!L20:L24)-'Strategic - Cashflow'!L49","v":144278.92929444654}]
[]
[null,"Rates and Annual Charges Outstanding",{"$f":"C45/C46","v":2.8731413086763177E-2},{"$f":"D45/D46","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'!C12","v":61105.829020404672},{"$f":"'Strategic - P&L'!D12","v":65048.113258347104},{"$f":"'Strategic - P&L'!E12","v":69258.521240670496},{"$f":"'Strategic - P&L'!F12","v":73756.473558866855},{"$f":"'Strategic - P&L'!G12","v":78562.830131556606},{"$f":"'Strategic - P&L'!H12","v":83699.997723592431},{"$f":"'Strategic - P&L'!I12","v":89192.045518335159},{"$f":"'Strategic - P&L'!J12","v":91575.596656293535},{"$f":"'Strategic - P&L'!K12","v":94018.736572700873},{"$f":"'Strategic - P&L'!L12","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":77,"n_cols":13,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Special Schedule Ratios - Strategic Scenario - Consolidated"]
[]
[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":"C16/C25","v":1.3598227169655741},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*'Strategic - P&L'!D$25","v":6025.8597448271776},{"$f":"$M26*'Strategic - P&L'!E$25","v":6430.7317662898868},{"$f":"$M26*'Strategic - P&L'!F$25","v":6535.5524686411527},{"$f":"$M26*'Strategic - P&L'!G$25","v":6635.7288213679803},{"$f":"$M26*'Strategic - P&L'!H$25","v":6900.5764843142724},{"$f":"$M26*'Strategic - P&L'!I$25","v":7014.2916175393966},{"$f":"$M26*'Strategic - P&L'!J$25","v":7105.4202711577491},{"$f":"$M26*'Strategic - P&L'!K$25","v":7215.6584565093626},{"$f":"$M26*'Strategic - P&L'!L$25","v":7305.6037434397913},0.35820017414632999]
[null,"- Other Structures",234,{"$f":"$M27*'Strategic - P&L'!D$25","v":278.31150388368087},{"$f":"$M27*'Strategic - P&L'!E$25","v":297.01100004610674},{"$f":"$M27*'Strategic - P&L'!F$25","v":301.8522689346778},{"$f":"$M27*'Strategic - P&L'!G$25","v":306.47903300845479},{"$f":"$M27*'Strategic - P&L'!H$25","v":318.71133752532251},{"$f":"$M27*'Strategic - P&L'!I$25","v":323.96340628935002},{"$f":"$M27*'Strategic - P&L'!J$25","v":328.17229161184531},{"$f":"$M27*'Strategic - P&L'!K$25","v":333.26377340030763},{"$f":"$M27*'Strategic - P&L'!L$25","v":337.41800352395859},1.6543901348457395E-2]
[null,"- Roads",2690,{"$f":"$M28*'Strategic - P&L'!D$25","v":3194.4459812765581},{"$f":"$M28*'Strategic - P&L'!E$25","v":3409.0778938435774},{"$f":"$M28*'Strategic - P&L'!F$25","v":3464.6457440027229},{"$f":"$M28*'Strategic - P&L'!G$25","v":3517.7515182720072},{"$f":"$M28*'Strategic - P&L'!H$25","v":3658.1533179115604},{"$f":"$M28*'Strategic - P&L'!I$25","v":3718.4363091732071},{"$f":"$M28*'Strategic - P&L'!J$25","v":3766.7456913456322},{"$f":"$M28*'Strategic - P&L'!K$25","v":3825.1854730683949},{"$f":"$M28*'Strategic - P&L'!L$25","v":3872.8675255118364},0.18989009954580752]
[null,"- Bridges",12,{"$f":"$M29*'Strategic - P&L'!D$25","v":14.252082702436002},{"$f":"$M29*'Strategic - P&L'!E$25","v":15.209667143186119},{"$f":"$M29*'Strategic - P&L'!F$25","v":15.457584184421618},{"$f":"$M29*'Strategic - P&L'!G$25","v":15.694516626322006},{"$f":"$M29*'Strategic - P&L'!H$25","v":16.32092197853714},{"$f":"$M29*'Strategic - P&L'!I$25","v":16.589875713252628},{"$f":"$M29*'Strategic - P&L'!J$25","v":16.805408958785819},{"$f":"$M29*'Strategic - P&L'!K$25","v":17.066139178394128},{"$f":"$M29*'Strategic - P&L'!L$25","v":17.278873580174263},8.4719836208316658E-4]
[null,"- Footpaths",119,{"$f":"$M30*'Strategic - P&L'!D$25","v":140.93726227964493},{"$f":"$M30*'Strategic - P&L'!E$25","v":150.40670841595164},{"$f":"$M30*'Strategic - P&L'!F$25","v":152.85833249039158},{"$f":"$M30*'Strategic - P&L'!G$25","v":155.20133108251764},{"$f":"$M30*'Strategic - P&L'!H$25","v":161.3957840099784},{"$f":"$M30*'Strategic - P&L'!I$25","v":164.05543760883157},{"$f":"$M30*'Strategic - P&L'!J$25","v":166.18682192577089},{"$f":"$M30*'Strategic - P&L'!K$25","v":168.76515409745306},{"$f":"$M30*'Strategic - P&L'!L$25","v":170.86886095950106},8.3778504694890926E-3]
[null,"- Stormwater Drainage",188,{"$f":"$M31*'Strategic - P&L'!D$25","v":223.28262900483068},{"$f":"$M31*'Strategic - P&L'!E$25","v":238.28478524324919},{"$f":"$M31*'Strategic - P&L'!F$25","v":242.16881888927202},{"$f":"$M31*'Strategic - P&L'!G$25","v":245.88076047904477},{"$f":"$M31*'Strategic - P&L'!H$25","v":255.69444433041517},{"$f":"$M31*'Strategic - P&L'!I$25","v":259.90805284095785},{"$f":"$M31*'Strategic - P&L'!J$25","v":263.28474035431117},{"$f":"$M31*'Strategic - P&L'!K$25","v":267.36951379484134},{"$f":"$M31*'Strategic - P&L'!L$25","v":270.70235275606342},1.3272774339302943E-2]
[null,"- Other Open Space/Recreational Assets",1115,{"$f":"$M32*'Strategic - P&L'!D$25","v":1324.6519089541905},{"$f":"$M32*'Strategic - P&L'!E$25","v":1413.654062808354},{"$f":"$M32*'Strategic - P&L'!F$25","v":1436.6965744742981},{"$f":"$M32*'Strategic - P&L'!G$25","v":1458.7181286575951},{"$f":"$M32*'Strategic - P&L'!H$25","v":1516.9390261162573},{"$f":"$M32*'Strategic - P&L'!I$25","v":1541.9367815706469},{"$f":"$M32*'Strategic - P&L'!J$25","v":1561.9693993360372},{"$f":"$M32*'Strategic - P&L'!K$25","v":1586.2028247474097},{"$f":"$M32*'Strategic - P&L'!L$25","v":1605.9753055350855},7.8742381098063197E-2]
[null,"- Other Infrastructure",270,{"$f":"$M33*'Strategic - P&L'!D$25","v":320.27596961863128},{"$f":"$M33*'Strategic - P&L'!E$25","v":341.79501996771029},{"$f":"$M33*'Strategic - P&L'!F$25","v":347.3662668110303},{"$f":"$M33*'Strategic - P&L'!G$25","v":352.69066529706953},{"$f":"$M33*'Strategic - P&L'!H$25","v":366.76738557323739},{"$f":"$M33*'Strategic - P&L'!I$25","v":372.81137366726045},{"$f":"$M33*'Strategic - P&L'!J$25","v":377.65488465715907},{"$f":"$M33*'Strategic - P&L'!K$25","v":383.5140720922459},{"$f":"$M33*'Strategic - P&L'!L$25","v":388.29468684336052},1.9038429859035606E-2]
[]
[null,"Infrastructure Backlog Ratio",{"$f":"C40/C49","v":1.8926720739104098E-2},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},{"$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":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*'Standard - balance sheet'!C$24","v":90274.132959139592},{"$f":"$M50*'Strategic - Balance Sheet'!D$24","v":94091.059077429498},{"$f":"$M50*'Strategic - Balance Sheet'!E$24","v":95624.740041883822},{"$f":"$M50*'Strategic - Balance Sheet'!F$24","v":97090.467344022472},{"$f":"$M50*'Strategic - Balance Sheet'!G$24","v":98869.179941226452},{"$f":"$M50*'Strategic - Balance Sheet'!H$24","v":100532.99950440129},{"$f":"$M50*'Strategic - Balance Sheet'!I$24","v":101866.34566823885},{"$f":"$M50*'Strategic - Balance Sheet'!J$24","v":103479.29237282385},{"$f":"$M50*'Strategic - Balance Sheet'!K$24","v":104795.32414243843},{"$f":"$M50*'Strategic - Balance Sheet'!L$24","v":105995.7550095624},9.957890710861643E-2]
[null,"- Other Structures",{"$f":"$M51*'Standard - balance sheet'!C$24","v":3436.8055157757017},{"$f":"$M51*'Strategic - Balance Sheet'!D$24","v":3582.1188221088087},{"$f":"$M51*'Strategic - Balance Sheet'!E$24","v":3640.5072333324601},{"$f":"$M51*'Strategic - Balance Sheet'!F$24","v":3696.308596485881},{"$f":"$M51*'Strategic - Balance Sheet'!G$24","v":3764.0255499992127},{"$f":"$M51*'Strategic - Balance Sheet'!H$24","v":3827.3684375411285},{"$f":"$M51*'Strategic - Balance Sheet'!I$24","v":3878.1299491735854},{"$f":"$M51*'Strategic - Balance Sheet'!J$24","v":3939.5360679504784},{"$f":"$M51*'Strategic - Balance Sheet'!K$24","v":3989.6384073082504},{"$f":"$M51*'Strategic - Balance Sheet'!L$24","v":4035.3397315990796},3.7910454078879142E-3]
[null,"- Roads",{"$f":"$M52*'Standard - balance sheet'!C$24","v":407593.27957316692},{"$f":"$M52*'Strategic - Balance Sheet'!D$24","v":424826.93647404719},{"$f":"$M52*'Strategic - Balance Sheet'!E$24","v":431751.60064560804},{"$f":"$M52*'Strategic - Balance Sheet'!F$24","v":438369.44983956293},{"$f":"$M52*'Strategic - Balance Sheet'!G$24","v":446400.4469496723},{"$f":"$M52*'Strategic - Balance Sheet'!H$24","v":453912.6949230688},{"$f":"$M52*'Strategic - Balance Sheet'!I$24","v":459932.83511063323},{"$f":"$M52*'Strategic - Balance Sheet'!J$24","v":467215.38898900832},{"$f":"$M52*'Strategic - Balance Sheet'!K$24","v":473157.35361848283},{"$f":"$M52*'Strategic - Balance Sheet'!L$24","v":478577.37304147065},0.44960490889548338]
[null,"- Bridges",{"$f":"$M53*'Standard - balance sheet'!C$24","v":11417.759327407563},{"$f":"$M53*'Strategic - Balance Sheet'!D$24","v":11900.5193646472},{"$f":"$M53*'Strategic - Balance Sheet'!E$24","v":12094.497413099814},{"$f":"$M53*'Strategic - Balance Sheet'!F$24","v":12279.880767410226},{"$f":"$M53*'Strategic - Balance Sheet'!G$24","v":12504.850110031279},{"$f":"$M53*'Strategic - Balance Sheet'!H$24","v":12715.287925536648},{"$f":"$M53*'Strategic - Balance Sheet'!I$24","v":12883.927879195468},{"$f":"$M53*'Strategic - Balance Sheet'!J$24","v":13087.931359231352},{"$f":"$M53*'Strategic - Balance Sheet'!K$24","v":13254.381409983795},{"$f":"$M53*'Strategic - Balance Sheet'!L$24","v":13406.210403303692},1.2594615513694023E-2]
[null,"- Footpaths",{"$f":"$M54*'Standard - balance sheet'!C$24","v":28872.455469486435},{"$f":"$M54*'Strategic - Balance Sheet'!D$24","v":30093.226312342671},{"$f":"$M54*'Strategic - Balance Sheet'!E$24","v":30583.744846269208},{"$f":"$M54*'Strategic - Balance Sheet'!F$24","v":31052.529700514926},{"$f":"$M54*'Strategic - Balance Sheet'!G$24","v":31621.416917399431},{"$f":"$M54*'Strategic - Balance Sheet'!H$24","v":32153.557793997701},{"$f":"$M54*'Strategic - Balance Sheet'!I$24","v":32580.003072162104},{"$f":"$M54*'Strategic - Balance Sheet'!J$24","v":33095.873237582178},{"$f":"$M54*'Strategic - Balance Sheet'!K$24","v":33516.780837789483},{"$f":"$M54*'Strategic - Balance Sheet'!L$24","v":33900.715699516943},3.1848409582565504E-2]
[null,"- Stormwater Drainage",{"$f":"$M55*'Standard - balance sheet'!C$24","v":193092.21203966092},{"$f":"$M55*'Strategic - Balance Sheet'!D$24","v":201256.44118497043},{"$f":"$M55*'Strategic - Balance Sheet'!E$24","v":204536.91412092926},{"$f":"$M55*'Strategic - Balance Sheet'!F$24","v":207672.03730339149},{"$f":"$M55*'Strategic - Balance Sheet'!G$24","v":211476.62161473997},{"$f":"$M55*'Strategic - Balance Sheet'!H$24","v":215035.45501869748},{"$f":"$M55*'Strategic - Balance Sheet'!I$24","v":217887.42104429778},{"$f":"$M55*'Strategic - Balance Sheet'!J$24","v":221337.43974712343},{"$f":"$M55*'Strategic - Balance Sheet'!K$24","v":224152.37108104571},{"$f":"$M55*'Strategic - Balance Sheet'!L$24","v":226720.03740954507},0.21299469533313281]
[null,"- Other Open Space/Recreational Assets",{"$f":"$M56*'Standard - balance sheet'!C$24","v":21523.29005094503},{"$f":"$M56*'Strategic - Balance Sheet'!D$24","v":22433.32712639571},{"$f":"$M56*'Strategic - Balance Sheet'!E$24","v":22798.98957212094},{"$f":"$M56*'Strategic - Balance Sheet'!F$24","v":23148.450406863027},{"$f":"$M56*'Strategic - Balance Sheet'!G$24","v":23572.533650777641},{"$f":"$M56*'Strategic - Balance Sheet'!H$24","v":23969.223930448978},{"$f":"$M56*'Strategic - Balance Sheet'!I$24","v":24287.122261697201},{"$f":"$M56*'Strategic - Balance Sheet'!J$24","v":24671.683360447518},{"$f":"$M56*'Strategic - Balance Sheet'!K$24","v":24985.453568647623},{"$f":"$M56*'Strategic - Balance Sheet'!L$24","v":25271.662041576532},2.3741747834066271E-2]
[null,"- Other Infrastructure",{"$f":"$M57*'Standard - balance sheet'!C$24","v":5799.1596211763062},{"$f":"$M57*'Strategic - Balance Sheet'!D$24","v":6044.3568121836006},{"$f":"$M57*'Strategic - Balance Sheet'!E$24","v":6142.8796163279058},{"$f":"$M57*'Strategic - Balance Sheet'!F$24","v":6237.0371153544038},{"$f":"$M57*'Strategic - Balance Sheet'!G$24","v":6351.3006140251891},{"$f":"$M57*'Strategic - Balance Sheet'!H$24","v":6458.1834486911721},{"$f":"$M57*'Strategic - Balance Sheet'!I$24","v":6543.8368577123028},{"$f":"$M57*'Strategic - Balance Sheet'!J$24","v":6647.4516485026215},{"$f":"$M57*'Strategic - Balance Sheet'!K$24","v":6731.9927905592112},{"$f":"$M57*'Strategic - Balance Sheet'!L$24","v":6809.1077955384335},6.3968930888157549E-3]
[]
[null,"Asset Maintenance Ratio",{"$f":"C60/C61","v":0.88701410254874102},0.87880193413958674,0.89302534555406521,0.92135201332258632,0.9459052016588898,0.97233053261861258,0.99194495098279134,1.016500527144786,1.0395461732276798,1.0671988344614489]
[null,"Actual Asset Maintenance",{"$f":"C64","v":10682.310836994488},{"$f":"D64","v":11030.894257193029},11392.142611980267,11933.65672783503,12476.130422321694,13040.490414814511,13479.992739350197,14032.41495540552,14533.059438730594,15090.553708803567]
[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.130422321694,13040.490414814511,13479.992739350197,14032.41495540552,14533.059438730594,15090.553708803567]
[]
[null,null,85458.4866959559,88247.154057544234,91137.140895842138,95469.253822680243,99809.043378573551,104323.92331851608,107839.94191480157,112259.31964324416,116264.47550984475,120724.42967042854,"<<< 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":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}]
[null,"- Depreciable Land Improvement Assets"]

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