{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Inflated_data","Debt","Borrow Limits","Fin (capex inf 30yrs)"],"not_rendered":{"charts":7,"images":0,"macros":0,"external_links":1,"defined_names":26,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Inflated_data","index":0,"n_rows":330,"n_cols":36,"rows_kept":330,"cut":false,"hidden":false,"merged":[]}
[null,null,"Last Year Base","Current Year Base","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated"]
[null,null,"2017/18","2018/19","2019/20","2020/21","2021/22","2022/23","2023/24","2024/25","2025/26","2026/27","2027/28","2028/29","2029/30","2030/31","2031/32","2032/33","2033/34","2034/35","2035/36","2036/37","2037/38","2038/39","2039/40","2040/41","2041/42","2042/43","2043/44","2044/45","2045/46","2046/47","2047/48","2048/49","2049/50","2050/51"]
["Total Rates & Levies","WRC - Mgmt",154910329.88855088,165180306.3688778,174285447.99147132,184835883.22220033,198638978.55482537,212269853.58936787,221310675.84029648,230762194.32711747,236561117.08005291,245582118.82010174,249845751.36738664,254266483.30765936,258187274.13803804,257871968.09908241,259986032.48587045,267274342.53958675,271662013.63634855,277281969.44273162,281491293.76372081,289318244.86101723,295768432.72369415,305739883.03548217,316462085.24175692,320168789.41962731,328118800.47709256,339004895.63754475,355432722.55586612,365680915.18387645,374307060.38076526,384816820.6254288,390858099.98899567,396176125.31126338,506241112.41783512,510098583.21749258]
["Bulk Water Levies","WRC - Mgmt",30862765.437637679,33068898.040148415,34230480.133181691,35891638.607580863,38304663.522572353,41213707.572876036,44125836.128492907,47240404.975647599,47906128.108436257,48336405.475834668,48426995.721397474,49663289.762344345,50689410.552301653,51673197.201758124,53158936.329155117,53965569.457102209,55215987.247118801,58004625.923600197,61427050.082008675,65517081.879000828,70784897.03686367,76055667.900311857,81987117.732406408,86459854.141207024,88201601.000360563,90184443.889240071,94413001.563217163,100574587.93329556,106543660.33478376,112163760.57724524,117470610.78964779,122230945.8358487,127827561.67461663,129544833.83534123]
["Warm Greater Wellington rate",{"$f":"+$B$3","v":"WRC - Mgmt"},3268007.0725560002,3237058,3555642.3680000002,3801941.2993280003,3680251.8756105602,3673085.7336868723,3916686.9428622006,4223164.9933703179,4391789.6764753647,4632220.7245088629,4790365.9048662335,4442946.2333970694,4028126.9800096401,3624133.3193646413,3169626.1049739448,2674627.3750121542,2085425.8402431877,1450894.2727860766,754793.54896897729,0,-4.3655745685100555E-11,1.0913936421275139E-10,1.3096723705530172E-10,-4.8021320253610611E-10,-2.328306436538696E-10,-1.4551915228366849E-11,-7.2759576141834259E-11,-8.0035533756017685E-11,-1.2369127944111819E-10,0,0,0,0,"0"]
["External Interest Revenue","WRC - Mgmt",2943166.8398951786,2720810.4638230624,2883687.8438423518,3292574.6675652112,3952038.9664025884,4435877.1512250192,4869291.8743666802,5222229.5363614019,5481685.811656761,5752168.9786521737,6323856.1860460425,6644350.7166529782,6979230.6961766751,7329141.8319976479,7694758.8154455032,8076786.6228333665,8475961.8748945128,8893054.2572429087,9328868.0045970101,9784243.4516291749,10260058.653431512,10757231.07872327,11276719.379065147,11819525.237492476,12386695.300132472,12979323.194530673,13598551.638578994,14245574.644112594,14921639.819425197,15628050.775143439,16147293.638100069,16918543.678054091,17200312.052323703,15986347.810883455]
["Total Government Subsidies","WRC - Mgmt",96552550.642737716,105713206.96930616,106511708.61506155,109178941.26724622,102649003.74183016,100729209.72470681,101508577.00261143,105062869.14246088,110476212.35133883,114325356.69796851,123837779.57902738,133123032.53930926,183876482.1136094,130651815.57858129,120841276.28495497,126714610.17572388,131105691.17729166,134768818.77945718,145162055.36247516,152159617.12906086,152436121.23253429,177782513.36858752,165643156.42475113,163752876.47204074,288394551.89439249,296248402.36652946,306227692.64419514,184118522.88829672,196240568.56833935,201926635.54798418,212593309.60529718,220938183.57257766,231942733.44943979,212514099.4047001]
["Transport Fare Revenue","WRC - Mgmt",48062802.763453662,94119980.099999994,97447321.221300006,99738134.662467211,100049886.41971922,103028512.11486818,106200282.88117783,109469861.22188261,112951127.6450146,124391026.49196208,120367958.00996971,124318372.93650639,136726773.33473754,141107889.6006228,145630996.28883719,150300748.54257792,155121955.81751961,160099587.04936039,165238775.99599338,170544826.76025134,176023219.499376,181679616.32757428,187519867.41824406,193550017.31267399,199776311.44225931,206205202.87151533,212843359.26941988,219697670.1168758,226775254.15835178,234083467.10603571,241629909.60512209,249422435.46915102,257469160.19462222,179524873.95110714]
["Total Operating Revenue","WRC - Mgmt",343965012.92782873,407297637.3978141,420849297.36554456,430526895.89753997,438111693.89424181,451341923.02818757,464578736.79792291,481260923.64020032,494505293.90272194,517875865.2662133,528463394.59220803,546716311.97337675,614599327.14651012,566312836.17234695,564065874.78855729,582764143.77924109,597284418.45828605,612543278.70951712,633331838.43020511,654447995.66967249,667745284.66416252,709821862.05811322,715437432.50761735,724422164.14638174,864422633.68993664,890850165.42132974,925221903.86421275,822069368.79804075,851270359.87102664,876216793.99480438,904210062.7501905,924175519.12477183,1053873684.8250618,935785871.35765207]
["General Rates","WRC - Mgmt",42479338.788984604,47283313.907157809,52131847.833036602,51490578.671021245,55195810.833993889,57236923.425062336,58324507.976456136,60093415.743038878,62672238.56080994,64956322.573417693,67995137.084257215,69943357.232734799,67608629.923904657,70184761.219895333,71993393.360083953,75007512.426710039,77716551.576716423,79624103.381568789,80840093.344654933,83765035.215005666,83838170.565262079,85887929.705627725,87275559.311412171,89560608.45189108,90733401.716371894,91234342.746584237,94510799.273298815,94760776.379303187,96183071.863655031,99169841.049004227,98239184.93630828,99997917.375502482,190166611.7406925,104423754.52871783]
["Total Financial Costs","WRC - Mgmt",19686329.831413895,22528343.738359496,23712469.206757665,23432043.082525887,27023088.331279755,30424428.522567257,34017336.699965373,35823044.170454077,35854129.567717977,35508958.61628893,36233271.146146551,35657799.869224988,36039234.37664976,36331902.467992835,35386369.375526741,34566884.838285029,34360363.218285739,34687368.15458627,35306710.99750144,36355135.291461274,37934170.748803906,40314428.211194687,42954487.479542039,43900651.712752484,46280745.710376516,51799010.144191355,58954164.39714098,64391271.334556684,66742186.462012604,68926699.144883245,71383466.415668815,74173420.583336622,165249361.39013124,150656375.65389135]
["Depreciation","WRC - Mgmt",17893584.773125004,26674015.818312708,30352840.46819428,35254004.972274199,39121496.257234931,42080884.303453371,41882635.246388197,43492709.775224894,44800156.734040894,46817466.657931998,47883565.767939977,48075875.480867848,48802369.525955059,45194894.256377831,43715921.367745288,43773142.240021028,43841537.902875088,44163859.990393102,44802821.718648657,45593457.451400332,47211485.186055288,47201439.766638435,49347824.192674257,51453739.543910325,52118037.401883759,51820267.054230303,52066653.989718817,52330835.746181525,52031826.995570406,52751122.831368938,55069845.111527964,55965395.611496575,53658579.203739069,59006686.113182709]
["Grants - Capital Works",{"$f":"+B12","v":"WRC - Mgmt"},8362250,2381480,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Operating Expenses",{"$f":"+$B$3","v":"WRC - Mgmt"},327843950.52413464,385901281.02815747,385695246.28729391,391580730.40820682,418119196.32847816,428805720.90296185,441059640.75749916,455437855.30898017,464592992.72041833,481636935.40114254,492487632.81846005,502103460.24542761,636508235.9696126,523957791.59452683,531436224.80048949,542373687.15293884,556892544.99672377,570208000.07234299,585662218.20429671,601110456.86932695,618460424.71752572,636080296.90945923,657039474.37097418,676187354.22817075,695474908.49990857,716886515.4832592,743359979.00247085,765731824.23925722,786465307.44163179,808431917.37799585,833674234.20482934,847254629.64684594,954718198.60646605,876878648.63273919]
[]
["Capital Expenditure",{"$f":"+$B$3","v":"WRC - Mgmt"},-64126094.682865776,-96807810.690363809,-83946799.941473588,-81421329.430466488,-96451432.990231201,-86984728.747758687,-88784245.006473854,-54350274.296217561,-55133288.407102048,-44016046.950707339,-43497127.440143615,-58772266.071931452,-26782458.967913784,-38763968.606388621,-32764848.00854937,-48013545.354964659,-57366056.499201141,-71098676.414684013,-73663028.997660801,-95992548.092616498,-108738766.32690351,-139770347.6383521,-109583470.70853108,-66468204.37899705,-57519814.541436121,-72886952.063734472,-124874712.50006673,-125472834.86946899,-125451920.53189138,-133869633.45571902,-147408699.14610356,-147056949.94909984,-175217374.95375869,-124005669.73450246]
["Investment in Subsidiary - Additions",{"$f":"+$B$3","v":"WRC - Mgmt"},17989733.483199999,30748482.82,20693422.053248003,26651059.880552396,19068267.040224001,33541324.940114096,29742493.068736784,12863577.109931791,14276523.141702875,22874404.820854161,18070757.837263968,18628707.178564437,20492192.34921591,26465639.400776096,10300388.982011186,18073877.471703451,18561872.163439445,17698638.816865835,20761582.980114605,21322145.720577698,10630818.302114638,32499237.081943233,30825295.261723015,10832873.30422725,255861447.20629263,262769706.28086248,269864488.35044575,18476217.84733212,18975075.729210086,13235908.338765239,15992990.865474401,24942477.667318054,18666646.687537137,13607049.839502614]
[]
["Closing Bal External Debt",{"$f":"+$B$3","v":"WRC - Mgmt"},396168384.85962641,444292590.07466459,496159553.8761155,541402939.28112435,608150904.58823919,674000748.75112081,737308835.74961722,745664133.48509181,751220964.86310863,746620940.973351,735523432.15129018,727833477.7638346,757171443.80321062,744712503.84214246,722239886.36513531,715434410.71874058,716595480.94377327,729349514.39110339,742950495.53590834,773963314.13407505,810143493.72070134,875250865.72517192,922486441.30995047,915513173.52136099,1023767036.9535263,1150332936.6624181,1328241686.0152128,1381699189.3184052,1428280627.609082,1474657175.8235385,1532823915.7276165,1593378629.76685,1657230128.5439501,1657230128.5439501]
["Finance Lease liabiity",{"$f":"+$B$3","v":"WRC - Mgmt"},"0",29424623.158926308,27893291.054522552,26291441.92828279,24615417.103928059,22861349.023386862,21025148.526154097,19102491.323045321,17088803.612146884,14979246.781333588,12768701.138069181,10451748.603306852,8022654.3021491626,5475346.9794943091,2803398.1641681287,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9]
["Closing Bal Internal Debt",{"$f":"+$B$3","v":"WRC - Mgmt"},-2609.2944685816765,4.1723251342773438E-7,5.9604644775390625E-7,5.9604644775390625E-7,5.9604644775390625E-7,4.76837158203125E-7,2.384185791015625E-7,5.9604644775390625E-7,5.9604644775390625E-7,7.152557373046875E-7,7.152557373046875E-7,8.3446502685546875E-7,8.3446502685546875E-7,8.3446502685546875E-7,7.152557373046875E-7,5.9604644775390625E-7,7.152557373046875E-7,8.3446502685546875E-7,9.5367431640625E-7,9.5367431640625E-7,8.3446502685546875E-7,8.3446502685546875E-7,9.5367431640625E-7,8.3446502685546875E-7,9.5367431640625E-7,9.5367431640625E-7,9.5367431640625E-7,1.1920928955078125E-6,1.1920928955078125E-6,9.5367431640625E-7,1.1920928955078125E-6,1.1920928955078125E-6,1.430511474609375E-6,36185656.695626259]
["Closing Bal Other Investments",{"$f":"+$B$3","v":"WRC - Mgmt"},88849745.053056329,93821758.342469424,98352337.258496493,103431873.16845764,109038304.03971532,115118012.22383636,121651975.21358342,128609359.13658854,135941807.65586498,143628485.27536401,151910065.77399853,160603716.48103368,169726242.66623509,179295156.42411548,189328706.9706291,199845912.24935117,210866591.90361148,222411401.67345262,234501869.27877295,247160431.85261214,260410474.99124253,274276373.49052918,288783533.84095794,303958438.55676192,319828692.41773856,336423070.70564425,353771569.52045846,371905458.26537037,390857334.39302707,410661180.50941229,430910380.79605269,452262826.10907912,475114090.56472015,495442526.43802977]
[]
["C/Balance Current Account",{"$f":"+$B$3","v":"WRC - Mgmt"},-30.728975939507052,1026769.2070574955,874732.11709646357,875661.44454872434,877603.87781818735,881380.17568758596,886978.64089592372,891329.73377883947,897416.29212305252,903372.80381810351,909700.04368058592,924650.67075523839,939757.98487010249,950178.27026651322,958610.0163322438,966851.37455096364,990895.68663254543,1010059.6398788908,1035018.4164288702,1058813.7598521516,1073365.8462193669,1110213.4934700225,1142426.5388396673,1160672.0154397923,1178018.1845110259,1198978.2259970142,1273742.5813128434,1319108.0457993802,1326221.1658077748,1315071.2061061517,1314304.2230996431,1354728.0556695908,1324398.5281557501,-4745841.2084298749]
["C/Balance Bank","WRC - Mgmt",2096186.15,-719185.01999999979,-719185.01999999979,-719185.01999999979,-719185.01999999979,-719185.01999999979,-719185.01999999979,-719185.01999999979,-719185.01999999979,-719185.01999999979,-719185.01999999979,-719185.01999999979,-719185.01999999979,-719185.01999999979,-719185.01999999979,-719185.01999999979,-719185.01999999979,-719185.01999999979,-719185.01999999979,-719185.01999999979,-719185.01999999979,-719185.01999999979,-719185.01999999979,-719185.01999999979,-719185.01999999979,-719185.01999999979,-719185.01999999979,-719185.01999999979,-719185.01999999979,-719185.01999999979,-719185.01999999979,-719185.01999999979,-719185.01999999979,-719185.01999999979]
["C/Balance Debtors","WRC - Mgmt",17150907.75,21779632.82,21779632.82,21779632.82,21779632.82,21779632.82,21779632.82,21779632.82,21779632.82,21779632.82,21779632.82,21779632.82,21779632.82,21779632.82,21779632.82,21779632.82,21779632.82,21779632.82,21779632.82,21779632.82,21779632.82,21779632.82,21779632.82,21779632.82,21779632.82,21779632.82,21779632.82,21779632.82,21779632.82,21779632.82,21779632.82,21779632.82,21779632.82,21779632.82]
["C/Balance Doubtful Debtors","WRC - Mgmt",-885718.37,-1031923.0599999999,-1031923.0599999999,-1031923.0599999999,-1031923.0599999999,-1031923.0599999999,-1031923.0599999999,-1031923.0599999999,-1031923.0599999999,-1031923.0599999999,-1031923.0599999999,-1031923.0599999999,-1031923.0599999999,-1031923.0599999999,-1031923.0599999999,-1031923.0599999999,-1031923.0599999999,-1031923.0599999999,-1031923.0599999999,-1031923.0599999999,-1031923.0599999999,-1031923.0599999999,-1031923.0599999999,-1031923.0599999999,-1031923.0599999999,-1031923.0599999999,-1031923.0599999999,-1031923.0599999999,-1031923.0599999999,-1031923.0599999999,-1031923.0599999999,-1031923.0599999999,-1031923.0599999999,-1031923.0599999999]
["C/Balance Accrued Revenue","WRC - Mgmt",28247917.410029914,25173024.076018702,24620321.763686053,24618618.770590529,25123078.788362052,25655839.078007061,26361988.615309004,27141308.159286145,27989802.41763914,29115585.254047345,29527822.673849959,26121794.910482157,22961629.746253759,20091637.07095927,17548559.638130434,15417348.172221528,13745396.921706971,12594301.20179346,12027863.331644177,12007216.85526434,11985112.897559045,11961448.571634907,11936113.727580732,11908990.439754697,11879952.457878008,11848864.619379997,11815582.220259333,11779950.341532933,11741803.128137348,11700963.016926205,11657239.910170214,11878070.990720257,11810604.463748761,11810604.463748761]
["Warm GW advances","WRC - Mgmt","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0"]
["C/Balance Stock","WRC - Mgmt",3092825.29,3104719.9399999995,3104719.9399999995,3104719.9399999995,3104719.9399999995,3104719.9399999995,3104719.9399999995,3104719.9399999995,3104719.9399999995,3104719.9399999995,3104719.9399999995,3104719.9399999995,3104719.9399999995,3104719.9399999995,3104719.9399999995,3104719.9399999995,3104719.9399999995,3104719.9399999995,3104719.9399999995,3104719.9399999995,3104719.9399999995,3104719.9399999995,3104719.9399999995,3104719.9399999995,3104719.9399999995,3104719.9399999995,3104719.9399999995,3104719.9399999995,3104719.9399999995,3104719.9399999995,3104719.9399999995,3104719.9399999995,3104719.9399999995,3104719.9399999995]
["Total Current Assets","WRC - Mgmt",{"$f":"SUM(C24:C30)","v":49702087.501053974},49333037.963076197,48628298.560782522,48627524.895139247,49133927.346180238,49670463.933694646,50382211.936204925,51165882.573064983,52020463.389762193,53152202.737865448,53570767.397530541,50179690.261237398,47034632.411123857,44175060.02122578,41640414.334462672,39517444.226772495,37869537.288339511,36737605.521672353,36196126.428073049,36199275.295116492,36191723.423778415,36204906.745104931,36211784.946420401,36202907.135194488,36191215.322389036,36181087.525377013,36222569.481572174,36232303.067332312,36201268.973945126,36149278.903032355,36104788.813269854,36366043.726389848,36268247.671904512,30198007.935318887]
[]
["C/Balance Creditors",{"$f":"+$B$3","v":"WRC - Mgmt"},26689144.810000002,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995]
["C/Balance Accrued Expenses",{"$f":"+$B$3","v":"WRC - Mgmt"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(C33:C34)","v":26689144.810000002},42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995,42641644.879999995]
["Working Capital",{"$f":"+$B$3","v":"WRC - Mgmt"},{"$f":"+C31-C35","v":23012942.691053972},6691393.0830762014,5986653.6807825267,5985880.0151392519,6492282.4661802426,7028819.0536946505,7740567.0562049299,8524237.6930649877,9378818.5097621977,10510557.857865453,10929122.517530546,7538045.3812374026,4392987.5311238617,1533415.141225785,-1001230.5455373228,-3124200.6532275006,-4772107.5916604847,-5904039.3583276421,-6445518.4519269466,-6442369.5848835036,-6449921.4562215805,-6436738.1348950639,-6429859.9335795939,-6438737.7448055074,-6450429.5576109588,-6460557.3546229824,-6419075.3984278217,-6409341.8126676828,-6440375.9060548693,-6492365.9769676402,-6536856.0667301416,-6275601.1536101475,-6373397.2080954835,-12443636.944681108]
[]
[]
["Closing Bal Reserve Investments",{"$f":"+$B$3","v":"WRC - Mgmt"},3.2741809263825417E-10,-5.579204298555851E-8,-5.8091245591640472E-8,-6.1147147789597511E-8,-5.1048118621110916E-8,-5.2736140787601471E-8,-5.9430021792650223E-8,-6.4319465309381485E-8,-5.8382283896207809E-8,-5.7974830269813538E-8,-5.8964360505342484E-8,-6.0652382671833038E-8,-5.8789737522602081E-8,-6.7811924964189529E-8,-5.6752469390630722E-8,-5.3085386753082275E-8,-5.3842086344957352E-8,-6.6705979406833649E-8,-5.1688402891159058E-8,-6.0827005654573441E-8,-5.6927092373371124E-8,-4.1211023926734924E-8,-5.5471900850534439E-8,-4.0687154978513718E-8,-5.2212271839380264E-8,-4.7555658966302872E-8,-4.871981218457222E-8,-5.9313606470823288E-8,-6.4843334257602692E-8,-4.6216882765293121E-8,-4.5169144868850708E-8,-5.0407834351062775E-8,500164.30717990501,2867523.9275977551]
["Closing Bal Forestry Investments","WRC - Mgmt",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Closing Bal Investment in Subsidiary","WRC - Mgmt",271527202.48320001,289412426.81999999,310105848.87324798,336756908.75380039,355825175.79402441,389366500.73413849,419108993.80287528,431972570.91280711,446249094.05450994,469123498.87536407,487194256.71262807,505822963.8911925,526315156.24040842,552780795.64118457,563081184.62319565,581155062.09489918,599716934.25833869,617415573.07520449,638177156.05531907,659499301.77589679,670130120.07801151,702629357.15995467,733454652.42167771,744287525.72590494,1000148972.9321976,1262918679.2130599,1532783167.5635056,1551259385.4108377,1570234461.1400478,1583470369.4788129,1599463360.3442874,1624405838.0116055,1643072484.6991427,1656679534.5386453]
["Closing Bal Financial Instruments","WRC - Mgmt",-25758412.410958901,-17651815,-10520768,-6785336,-4285594,-2741053,-1595564,-851225,-297793,-15191,13296,14224,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Closing Bal FX Investment","WRC - Mgmt",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Closing Bal Other Investments","WRC - Mgmt",88849745.053056329,93821758.342469424,98352337.258496493,103431873.16845764,109038304.03971532,115118012.22383636,121651975.21358342,128609359.13658854,135941807.65586498,143628485.27536401,151910065.77399853,160603716.48103368,169726242.66623509,179295156.42411548,189328706.9706291,199845912.24935117,210866591.90361148,222411401.67345262,234501869.27877295,247160431.85261214,260410474.99124253,274276373.49052918,288783533.84095794,303958438.55676192,319828692.41773856,336423070.70564425,353771569.52045846,371905458.26537037,390857334.39302707,410661180.50941229,430910380.79605269,452262826.10907912,475114090.56472015,495442526.43802977]
[null,null,{"$f":"SUM(C39:C44)","v":334618535.12529743},365582370.16246939,397937418.13174438,433403445.92225796,460577885.83373964,501743459.95797479,539165405.01645863,559730705.04939556,581893108.71037483,612736793.15072799,639117618.48662651,666440904.37222612,696041398.90664339,732075952.06529999,752409891.59382474,781000974.34425032,810583526.16195011,839826974.74865699,872679025.33409202,906659733.62850881,930540595.06925404,976905730.65048385,1022238186.2626357,1048245964.2826669,1319977665.349936,1599341749.918704,1886554737.0839641,1923164843.676208,1961091795.5330749,1994131549.9882252,2030373741.1403401,2076668664.1206846,2118686739.5710428,2154989584.904273]
[]
["Capex Project C/Balance",{"$f":"+$B$3","v":"WRC - Mgmt"},0,9208752.1399999987,9208752.1399999987,9208752.1399999987,9208752.1399999987,9208752.1399999987,9208752.1399999987,9208752.1399999987,9208752.1399999987,9208752.1399999987,9208752.1399999987,9208752.1399999987,9208752.1399999987,9208752.1399999987,9208752.1399999987,9208752.1399999987,9208752.1399999987,9208752.1399999987,9208752.1399999987,9208752.1399999987,9208752.1399999987,9208752.1399999987,9208752.1399999987,9208752.1399999987,9208752.1399999987,9208752.1399999987,9208752.1399999987,9208752.1399999987,9208752.1399999987,9208752.1399999987,9208752.1399999987,9208752.1399999987,9208752.1399999987,9208752.1399999987]
["Closing Bal Total Assets",{"$f":"+$B$3","v":"WRC - Mgmt"},1094655893.9910483,1388710459.2645097,1472079009.2859831,1553689173.6918511,1649316310.1602077,1866502846.5627911,1954979329.0608635,2010764028.7138691,2065027052.7771728,2108313413.0776567,2302827669.3945003,2360975156.3544884,2389257404.2821956,2426983414.7542114,2458929230.4826479,2677894599.1447506,2734748998.7715173,2807220226.5972586,2879735718.3827701,2975007556.3701944,3275177584.4493108,3414355285.9849296,3525845072.2336993,3591250452.3777952,3647438461.1654425,3935210469.8836703,4059454544.2293873,4186776441.1495619,4311219106.8088846,4443694141.8219023,4760214943.0401821,4905996474.8120127,5080267210.3362598,5203882730.424736]
["Dep C/Bal Total Assets",{"$f":"+$B$3","v":"WRC - Mgmt"},-105279599.03312501,-128391076.77081272,-158052249.83900696,-192539037.27837801,-230780635.64817351,-272158899.54807943,-312889483.22461289,-355578840.10818481,-399397317.23036879,-445123795.66277212,-491980679.48415655,-538975905.47567654,-586416481.4021343,-629958255.04900682,-672209849.1984365,-715102698.59385955,-757785264.81086636,-800698676.74522161,-844229179.8774581,-889110722.26910281,-935043663.50833428,-981124865.96167374,-1029439405.9027611,-1079563898.6596956,-1130252981.9055212,-1180773057.9460661,-1231770890.9499295,-1282703020.7421799,-1333613564.0412128,-1384890963.5611634,-1437846857.6736963,-1492631995.9081433,-1545286861.4821172,-1604006661.8452349]
[null,null,{"$f":"SUM(C47:C49)","v":989376294.95792329},1269528134.633697,1323235511.5869763,1370358888.5534732,1427744426.6520343,1603552699.1547117,1651298597.9762506,1664393940.7456844,1674838487.6868041,1672398369.5548847,1820055742.0503435,1831208003.0188117,1812049675.020061,1806233911.8452044,1795928133.4242113,1972000652.6908908,1986172486.1006508,2015730301.9920368,2044715290.6453118,2095105586.2410915,2349342673.0809765,2442439172.1632557,2505614418.4709382,2520895305.8580995,2526394231.3999214,2763646164.0776043,2836892405.4194574,2913282172.5473819,2986814294.9076719,3068011930.4007392,3331576837.5064859,3422573231.04387,3544189100.994143,3609084820.7195015]
[]
["Closing Bal Internal Debt",{"$f":"+$B$3","v":"WRC - Mgmt"},-2609.2944685816765,4.1723251342773438E-7,5.9604644775390625E-7,5.9604644775390625E-7,5.9604644775390625E-7,4.76837158203125E-7,2.384185791015625E-7,5.9604644775390625E-7,5.9604644775390625E-7,7.152557373046875E-7,7.152557373046875E-7,8.3446502685546875E-7,8.3446502685546875E-7,8.3446502685546875E-7,7.152557373046875E-7,5.9604644775390625E-7,7.152557373046875E-7,8.3446502685546875E-7,9.5367431640625E-7,9.5367431640625E-7,8.3446502685546875E-7,8.3446502685546875E-7,9.5367431640625E-7,8.3446502685546875E-7,9.5367431640625E-7,9.5367431640625E-7,9.5367431640625E-7,1.1920928955078125E-6,1.1920928955078125E-6,9.5367431640625E-7,1.1920928955078125E-6,1.1920928955078125E-6,1.430511474609375E-6,36185656.695626259]
[]
["Finance Lease liabiity",{"$f":"+$B$3","v":"WRC - Mgmt"},"0",29424623.158926308,27893291.054522552,26291441.92828279,24615417.103928059,22861349.023386862,21025148.526154097,19102491.323045321,17088803.612146884,14979246.781333588,12768701.138069181,10451748.603306852,8022654.3021491626,5475346.9794943091,2803398.1641681287,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9]
["Closing Bal External Debt",{"$f":"+$B$3","v":"WRC - Mgmt"},396168384.85962641,444292590.07466459,496159553.8761155,541402939.28112435,608150904.58823919,674000748.75112081,737308835.74961722,745664133.48509181,751220964.86310863,746620940.973351,735523432.15129018,727833477.7638346,757171443.80321062,744712503.84214246,722239886.36513531,715434410.71874058,716595480.94377327,729349514.39110339,742950495.53590834,773963314.13407505,810143493.72070134,875250865.72517192,922486441.30995047,915513173.52136099,1023767036.9535263,1150332936.6624181,1328241686.0152128,1381699189.3184052,1428280627.609082,1474657175.8235385,1532823915.7276165,1593378629.76685,1657230128.5439501,1657230128.5439501]
["Debt (right hand scale)",null,{"$f":"SUM(C52:C55)","v":396165775.56515783},473717213.23359132,524052844.93063867,567694381.20940769,632766321.69216788,696862097.77450812,758333984.2757715,764766624.80813777,768309768.47525609,761600187.75468528,748292133.28936005,738285226.36714232,765194098.10536063,750187850.82163763,725043284.52930415,715434410.71874118,716595480.94377398,729349514.39110422,742950495.5359093,773963314.134076,810143493.72070217,875250865.72517276,922486441.30995142,915513173.52136183,1023767036.9535272,1150332936.6624191,1328241686.0152137,1381699189.3184063,1428280627.6090832,1474657175.8235395,1532823915.7276177,1593378629.7668512,1657230128.5439515,1693415785.2395763]
["Net.Assets",{"$f":"+$B$3","v":"WRC - Mgmt"},950841997.20911753,1168084684.6456513,1203106738.4688644,1242053833.2814627,1262048273.2597859,1415462880.3918729,1439870585.7731421,1467882258.6800067,1497800646.4316852,1534045532.8087931,1721810349.7651403,1766901726.405133,1747289963.352468,1789655428.2300925,1822293509.9431944,2034443015.6631722,2075388423.7271669,2120303722.9912617,2167998301.9915681,2221359636.150641,2463289852.9733062,2537657298.9536724,2598936303.4900422,2647189358.8745995,2816154430.2387195,3206194419.9792657,3388786381.0897799,3448338485.0925174,3513185086.9256105,3580993938.5884581,3822589806.8524804,3899587664.2440939,3999272314.8131404,4058214983.439518]
[]
["Retained Earnings C/F",{"$f":"+$B$3","v":"WRC - Mgmt"},373083668.42038047,386091943.83379203,423667003.42509764,462250140.68525809,484696027.76974422,505986602.74146295,528339461.90117425,552473142.68318725,580957196.19277704,615902925.87980258,650124881.92753029,693264243.35272229,669996873.61491203,710549010.1783123,741513766.41947794,780312367.73393047,818594617.87132204,859137948.95372307,905174669.43191421,955535709.32735693,1003750055.0248586,1075705816.283519,1131766873.9280853,1177857955.3138547,1344772174.9082608,1516129999.4178905,1695671208.4724474,1749759672.7212825,1811846500.8997676,1877157826.4858656,1945341942.2419543,2019403214.2927265,2115447846.9574642,2171987710.0619597]
["Share Capital (gwrl only)",{"$f":"+$B$3","v":"WRC - Mgmt"},"0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0"]
["Closing Bal. Asset\\Reval",{"$f":"+$B$3","v":"WRC - Mgmt"},553385730.79875135,752990967.96234918,752990967.96288371,752990967.95868301,752990967.95448244,883865596.65138996,884748607.54151142,886932861.02597523,886932861.02177453,886932861.01757383,1038715588.958948,1039179163.2361223,1041461201.6879481,1041461201.6837474,1041461201.6795467,1213212009.407047,1213741499.6843703,1216302356.35467,1216302356.3504694,1216302356.3462687,1408933161.1372931,1409522194.3247342,1412371027.685286,1412371027.6810853,1412371027.6768847,1628426407.4473894,1629081679.3395052,1632250873.308923,1632250873.3047225,1632250873.3005219,1803275852.4927874,1803275852.4885867,1803798071.4085867,1804320290.3285868]
["Closing Bal Reserves",{"$f":"+$B$3","v":"WRC - Mgmt"},24559129.961584002,29021812.690574098,26448053.077217322,26811081.306390069,24357691.787667464,25603318.941174485,26769555.821886964,28458943.371094484,29887191.043808438,31180391.221853476,32934196.947873753,34407687.250630744,35766148.165338613,37569056.179758526,39233949.926660858,40825805.238510586,42935428.562681429,44727376.117454655,46360275.865171716,49336774.770074703,50407289.01920969,52193092.909202784,54529993.401280068,56673721.933722414,58707227.529343322,61313052.957784601,63633768.764970414,65882849.074918196,68601073.325828299,71074624.356538147,73426337.145810589,76285954.572965145,79396808.12682274,81764167.747240603]
["Close Balance S/F Reserve",{"$f":"+$B$3","v":"WRC - Mgmt"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Net Equity",null,{"$f":"SUM(C59:C64)","v":951028529.1807158},1168104724.4867153,1203106024.4651988,1242052189.9503312,1262044687.5118942,1415455518.3340273,1439857625.2645726,1467864947.0802569,1497777248.2583599,1534016178.11923,1721774667.8343523,1766851093.8394754,1747224223.4681988,1789579268.0418181,1822208918.0256855,2034350182.379488,2075271546.1183736,2120167681.4258478,2167837301.6475554,2221174840.4437003,2463090505.1813617,2537421103.5174561,2598667895.0146513,2646902704.9286623,2815850430.1144886,3205869459.8230648,3388386656.5769229,3447893395.105124,3512698447.5303183,3580483324.1429257,3822044131.8805523,3898965021.3542781,3998642726.4928737,4058072168.1377873]
[]
["balance check",null,{"$f":"C57-C65","v":-186531.97159826756},-20039.841063976288,714.00366568565369,1643.3311314582825,3585.747891664505,7362.0578455924988,12960.508569478989,17311.599749803543,23398.173325300217,29354.689563035965,35681.930788040161,50632.565657615662,65739.884269237518,76160.188274383545,84591.917508840561,92833.283684253693,116877.60879325867,136041.56541395187,161000.34401273727,184795.70694065094,199347.79194450378,236195.43621635437,268408.4753909111,286653.94593715668,304000.12423086166,324960.15620088577,399724.5128569603,445089.98739337921,486639.3952922821,510614.44553232193,545674.97192811966,622642.88981580734,629588.32026672363,142815.30173063278]
[]
[]
["Total Rates & Levies","Public Transport Group",64656396.127130874,68109677.793629244,70192874.667466745,78511420.218576699,85537166.686427489,92653204.217633054,96392518.543414399,99885368.528609082,101388559.19537042,106534371.13874438,106533992.46587329,106824593.73536459,114601650.70239203,110165172.48984727,108634112.39777812,109942287.51185121,109907840.16473469,111181951.68905306,111098621.99498963,112205410.28095879,112654603.01920894,114592069.3770096,117479258.25941789,113820204.67566589,117879731.056381,126409868.90424328,134730096.16876641,138333408.67198712,139107721.73452577,140622766.53699902,142295716.94181061,139777837.26677987,153853536.33625147,243213132.16774353]
["Bulk Water Levies",{"$f":"+B70","v":"Public Transport Group"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"0","0","0"]
["Warm Greater Wellington rate",{"$f":"+$B$70","v":"Public Transport Group"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"0","0","0"]
["External Interest Revenue",{"$f":"+$B$70","v":"Public Transport Group"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"0","0","0"]
["Total Government Subsidies",{"$f":"+$B$70","v":"Public Transport Group"},94606003.642737716,103555260.45322034,104876743.0777673,107776594.69067483,101208128.18777962,99183287.842529505,99856015.742385849,103515796.93864012,108853479.88772507,112639941.99378772,122172725.52352373,131392895.44548596,182074710.89931774,128866957.28717077,118964200.62490305,124762376.5236478,129172631.95899798,132734023.27859193,143044228.73347855,150063054.68924114,150226270.43067977,175480523.49595329,163361112.84273478,161352076.12111247,285896993.90865529,293777291.62275255,303630054.02900088,181418050.97111481,193569331.37189665,199298713.71774995,209858630.51601639,218264928.4432815,229146060.62638247,210479367.25308529]
["Transport Fare Revenue",{"$f":"+$B$70","v":"Public Transport Group"},48062802.763453662,94119980.099999994,97447321.221300006,99738134.662467211,100049886.41971922,103028512.11486818,106200282.88117783,109469861.22188261,112951127.6450146,124391026.49196208,120367958.00996971,124318372.93650639,136726773.33473754,141107889.6006228,145630996.28883719,150300748.54257792,155121955.81751961,160099587.04936039,165238775.99599338,170544826.76025134,176023219.499376,181679616.32757428,187519867.41824406,193550017.31267399,199776311.44225931,206205202.87151533,212843359.26941988,219697670.1168758,226775254.15835178,234083467.10603571,241629909.60512209,249422435.46915102,257469160.19462222,179524873.95110714]
["Total Operating Revenue",{"$f":"+$B$70","v":"Public Transport Group"},209597577.67125612,273398294.96775693,278708194.4421792,288786103.36691922,289580494.09372574,297720902.9716776,305355947.66562742,315840421.70409435,326205485.01010627,346632777.2236129,352226134.96855354,365774272.97242361,436716089.57947797,383552931.28290641,376736128.99643672,388605843.78760272,397899900.76003206,407835725.50279671,423313124.94369757,436871116.73918802,443090134.60304821,476071117.45473397,472799686.83942229,473317570.35719192,608257250.95621037,631234284.52687776,656173099.56306231,545140776.78928268,565290767.50246048,580027179.52013254,599947143.11340439,613789860.76303291,646948902.32539344,639898396.35262179]
[]
["Total Financial Costs",{"$f":"+$B$70","v":"Public Transport Group"},13562242.678636817,14265123.269194841,14323498.627946213,14731304.479005592,15485991.369700296,16098079.106653644,17190073.272806108,17441867.828309499,16951728.583369773,16397613.596726572,15686685.878961999,15090893.367125532,15541460.125094915,15947698.868708052,15089216.750870185,13991044.797176275,13028670.461610915,12140650.859278886,11369893.51069467,10821325.407743473,10223600.214234821,10001301.772118153,9852953.7305233646,9322032.5245082695,11846444.245412035,17217612.553517409,22637511.527375251,25063615.657395419,24602818.72879431,24266658.030647911,23979981.981445912,23880864.195308302,24208535.6435108,24010543.920994833]
["Depreciation",{"$f":"+$B$70","v":"Public Transport Group"},1669625.3800000059,4615381.2410000078,6063996.1020000074,9388696.8153333329,12572045.819,14019532.484058,14576038.221646544,15420159.115590975,16500343.564141309,18210837.818705514,19430197.769427989,19461017.86464699,20844953.554356247,17530240.402208883,15647412.046158219,15444000.023222972,15231679.469413588,14962790.513717836,14687763.150023116,14702083.359635025,14880326.254268764,13547426.844931461,14374113.04598714,14437467.604423225,14813501.631179046,14241872.308199177,13617643.637413371,13031452.006275153,12435476.038183864,12058166.551676875,12500440.800370498,13016197.035897799,11683250.070101172,17004005.26687802]
["Grants - Capital Works",{"$f":"+B79","v":"Public Transport Group"},8362250,2381480,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Operating Expenses",{"$f":"+$B$70","v":"Public Transport Group"},193886289.94026127,250282459.30117014,244935221.87415609,250452542.17801788,271339562.07740223,276752825.31441492,285226467.1967777,294246112.56916523,300494763.51238465,315174720.76331329,322938585.02160007,329042228.5198431,462895371.52900606,349175596.33838457,353077300.59827411,361626016.8416729,373953932.34722781,382904865.9074437,394198722.09203714,405093385.22572494,415623233.76333123,426573323.79866046,441176270.13101995,452985088.94817275,468916607.11436331,487939118.94254392,507360218.7079497,523434983.89102304,538011757.58634484,552019074.27886784,569464421.47516286,579341536.96108162,594355177.68178749,619339171.54893208]
[]
["Capital Expenditure",{"$f":"+$B$70","v":"Public Transport Group"},-19349900,-46026632.710000001,-35984593,-32355503.109999999,-21521660.989243999,-17954180.221903425,-18231571.678396285,-19263979.109910175,-24621429.921492726,-12749880.303726573,-14999067.789698577,-27534408.96659337,-2577062.3434604849,-13352875.920662738,-5429057.6235033534,-2752532.2151162,-2865781.6660246672,-2942885.2534396304,-10626590.240808867,-14446658.306655899,-16894716.7700519,-35983158.654934488,-3316847.5878624893,-17381386.976262067,-7132066.5771630071,-3639357.7193765142,-3689837.9234540346,-3789463.5473872931,-13920073.762112226,-18907328.325372744,-21997369.180989586,-22591298.148876298,-56504511.809751391,-3876276.1166461674]
["Investment in Subsidiary - Additions",{"$f":"+$B$70","v":"Public Transport Group"},"0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0"]
[]
["Closing Bal External Debt",{"$f":"+$B$70","v":"Public Transport Group"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Finance Lease liabiity",{"$f":"+$B$70","v":"Public Transport Group"},"0",29424623.158926308,27893291.054522552,26291441.92828279,24615417.103928059,22861349.023386862,21025148.526154097,19102491.323045321,17088803.612146884,14979246.781333588,12768701.138069181,10451748.603306852,8022654.3021491626,5475346.9794943091,2803398.1641681287,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9]
["Closing Bal Internal Debt",{"$f":"+$B$70","v":"Public Transport Group"},247206645.89702931,250270994.75629142,266390264.65290752,279433237.38728672,287667377.18239033,306092595.45629781,321382190.4971922,318608422.03550237,317487865.32446551,305733759.69364256,292494103.78240812,284984564.57553345,316014709.40610731,306676257.68534988,285993085.90532815,267427168.55468196,249899024.16847706,230875297.24006042,218709832.14452669,208254556.28676009,193682087.85655764,199375839.51760423,187799088.00135833,181530115.08323148,290649438.16466832,399809673.41396302,511245865.66276574,499095751.94393492,492590868.78247231,484991552.96772772,480348985.35604113,480778631.92348146,492043658.65224165,472345351.92841148]
["Closing Bal Other Investments",{"$f":"+$B$70","v":"Public Transport Group"},40312545.483199999,40417770,61078192.462048002,87729252.34260039,106797519.38282441,140338844.32293847,170081337.39167529,182944914.50160709,197221437.64330992,220095842.46416408,238166600.30142805,256795307.47999248,277287499.82920837,303753139.22998452,314053528.21199566,332127405.68369913,350689277.84713858,368387916.66400445,389149499.64411908,410471645.36469668,421102463.66681129,453601700.74875456,484426996.0104776,495259869.3147049,751121316.52099752,1013891022.8018601,1283755511.1523058,1302231728.9996381,1321206804.728848,1334442713.0676134,1350435703.9330878,1375378181.6004059,1394044828.2879429,1407651878.1274457]
[]
["C/Balance Current Account",{"$f":"+$B$70","v":"Public Transport Group"},-0.36522110179066658,-595961.87538133317,-595961.8503402085,-595961.85034008126,-595961.85034024296,-595961.85034009325,-595961.8503402638,-595961.85034021735,-595961.8503401638,-595961.8503400808,-595961.85034027731,-595961.85034018313,-595961.85034037288,-595961.85034031444,-595961.85034036939,-595961.85034022934,-595961.8503402659,-595961.85033990582,-595961.85034022527,-595961.85033977847,-595961.85033996869,-595961.85034010315,-595961.85034004366,-595961.85033975891,-595961.8503402028,-595961.85033980815,-595961.85033960559,-595961.85033970326,-595961.85033928731,-595961.85033963004,-595961.8503400546,-595961.85033892212,-595961.85033961758,-595961.85033919185]
["C/Balance Bank","Public Transport Group",300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300]
["C/Balance Debtors","Public Transport Group",82349.87000000001,15676517.77,15676517.77,15676517.77,15676517.77,15676517.77,15676517.77,15676517.77,15676517.77,15676517.77,15676517.77,15676517.77,15676517.77,15676517.77,15676517.77,15676517.77,15676517.77,15676517.77,15676517.77,15676517.77,15676517.77,15676517.77,15676517.77,15676517.77,15676517.77,15676517.77,15676517.77,15676517.77,15676517.77,15676517.77,15676517.77,15676517.77,15676517.77,15676517.77]
["C/Balance Doubtful Debtors","Public Transport Group",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["C/Balance Accrued Revenue","Public Transport Group",7973822.459999999,9741293.1100000013,9741293.1100000013,9741293.1100000013,9741293.1100000013,9741293.1100000013,9741293.1100000013,9741293.1100000013,9741293.1100000013,9741293.1100000013,9741293.1100000013,9741293.1100000013,9741293.1100000013,9741293.1100000013,9741293.1100000013,9741293.1100000013,9741293.1100000013,9741293.1100000013,9741293.1100000013,9741293.1100000013,9741293.1100000013,9741293.1100000013,9741293.1100000013,9741293.1100000013,9741293.1100000013,9741293.1100000013,9741293.1100000013,9741293.1100000013,9741293.1100000013,9741293.1100000013,9741293.1100000013,9741293.1100000013,9741293.1100000013,9741293.1100000013]
["Warm GW advances","Public Transport Group","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0"]
["C/Balance Stock","Public Transport Group",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Current Assets","Public Transport Group",{"$f":"SUM(C91:C97)","v":8056471.9647788974},24822149.004618667,24822149.029659793,24822149.029659919,24822149.029659756,24822149.029659908,24822149.029659737,24822149.029659785,24822149.029659837,24822149.029659919,24822149.029659726,24822149.029659815,24822149.029659629,24822149.029659688,24822149.029659629,24822149.02965977,24822149.029659733,24822149.029660095,24822149.029659778,24822149.029660225,24822149.029660031,24822149.029659897,24822149.029659957,24822149.02966024,24822149.0296598,24822149.029660195,24822149.029660396,24822149.029660299,24822149.029660713,24822149.02966037,24822149.029659946,24822149.029661078,24822149.029660381,24822149.02966081]
[]
["C/Balance Creditors",{"$f":"+$B$70","v":"Public Transport Group"},11270016.950000001,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996]
["C/Balance Accrued Expenses",{"$f":"+$B$70","v":"Public Transport Group"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(C100:C101)","v":11270016.950000001},18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996,18475323.909999996]
["Working Capital",{"$f":"+$B$70","v":"Public Transport Group"},{"$f":"+C98-C102","v":-3213544.9852211038},6346825.0946186706,6346825.1196597964,6346825.119659923,6346825.1196597591,6346825.1196599118,6346825.1196597405,6346825.1196597889,6346825.1196598411,6346825.119659923,6346825.1196597293,6346825.1196598187,6346825.1196596324,6346825.119659692,6346825.1196596324,6346825.119659774,6346825.1196597368,6346825.1196600981,6346825.1196597815,6346825.1196602285,6346825.1196600348,6346825.1196599007,6346825.1196599603,6346825.1196602434,6346825.1196598038,6346825.1196601987,6346825.1196603999,6346825.119660303,6346825.1196607165,6346825.1196603738,6346825.1196599491,6346825.1196610816,6346825.119660385,6346825.1196608134]
[]
[]
["Closing Bal Reserve Investments",{"$f":"+$B$70","v":"Public Transport Group"},8469656.9657085054,11158831.370752741,8938722.3709399458,9095540.9927617349,5886941.3617982073,6060606.131971254,6245454.6189963771,6435940.9848757666,6625801.2439296022,6817949.4800035609,7015670.0149236647,7219124.445356451,7428479.0542717883,7643904.9468456693,7865578.1903041946,8093679.9578230157,8328396.6765998835,8569920.1802212801,8818447.8654476963,9074182.8535456788,9337334.1562985033,9608116.8468311615,9886752.2353892662,10173468.050215555,10468498.623671805,10772085.083758287,11084475.551187277,11405925.342171708,11736697.177094687,12077061.395230433,12427296.175692115,12787687.764787188,13158530.709966017,13540128.100555032]
["Closing Bal Forestry Investments","Public Transport Group",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Closing Bal Investment in Subsidiary","Public Transport Group",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Closing Bal Financial Instruments","Public Transport Group",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Closing Bal FX Investment","Public Transport Group",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Closing Bal Other Investments","Public Transport Group",40312545.483199999,40417770,61078192.462048002,87729252.34260039,106797519.38282441,140338844.32293847,170081337.39167529,182944914.50160709,197221437.64330992,220095842.46416408,238166600.30142805,256795307.47999248,277287499.82920837,303753139.22998452,314053528.21199566,332127405.68369913,350689277.84713858,368387916.66400445,389149499.64411908,410471645.36469668,421102463.66681129,453601700.74875456,484426996.0104776,495259869.3147049,751121316.52099752,1013891022.8018601,1283755511.1523058,1302231728.9996381,1321206804.728848,1334442713.0676134,1350435703.9330878,1375378181.6004059,1394044828.2879429,1407651878.1274457]
[null,null,{"$f":"SUM(C106:C111)","v":48782202.448908508},51576601.370752737,70016914.832987949,96824793.335362121,112684460.74462262,146399450.45490971,176326792.01067168,189380855.48648286,203847238.88723952,226913791.94416764,245182270.31635171,264014431.92534894,284715978.88348019,311397044.17683017,321919106.40229988,340221085.64152217,359017674.52373844,376957836.8442257,397967947.50956678,419545828.21824235,430439797.82310981,463209817.5955857,494313748.24586689,505433337.36492044,761589815.14466929,1024663107.8856183,1294839986.7034931,1313637654.3418097,1332943501.9059427,1346519774.4628439,1362863000.1087799,1388165869.3651931,1407203358.9979088,1421192006.2280006]
[]
["Capex Project C/Balance",{"$f":"+$B$70","v":"Public Transport Group"},0,416464.45,416464.45,416464.45,416464.45,416464.45,416464.45,416464.45,416464.45,416464.45,416464.45,416464.45,416464.45,416464.45,416464.45,416464.45,416464.45,416464.45,416464.45,416464.45,416464.45,416464.45,416464.45,416464.45,416464.45,416464.45,416464.45,416464.45,416464.45,416464.45,416464.45,416464.45,416464.45,416464.45]
["Closing Bal Total Assets",{"$f":"+$B$70","v":"Public Transport Group"},42539200.189999998,83406890.857871324,119391483.85787129,151746986.96787131,173237678.72873133,191160363.24536824,209391934.92376453,230840167.52233905,255428337.53321707,268144325.98802733,283143393.77772588,310677802.74431926,315500937.24260134,328817127.53603518,334246185.15953857,336998717.37465477,339825567.95957911,345289600.18479675,355916190.4256056,370362848.73226148,387215425.24810684,423155600.84375066,429321281.79636562,446702668.77262765,453789121.383407,457381952.857072,461071790.78052604,468030448.30153191,481901148.03948522,500758114.86021584,522755484.04120541,545346782.19008172,601851293.99983299,605727570.11647928]
["Dep C/Bal Total Assets",{"$f":"+$B$70","v":"Public Transport Group"},-5765021.2700000145,-10045787.611000014,-16109783.71300002,-25498480.528333351,-38049792.711381346,-52048239.087676167,-66624277.309322707,-82044436.424913689,-98522512.760762155,-116710660.27383724,-136140858.04326522,-155601875.90791219,-176422750.32841101,-193928430.01408526,-209575842.06024349,-225019842.08346647,-240225457.5240078,-255161662.72827595,-269849425.87829906,-284551509.23793405,-299403622.94913232,-312922273.00013196,-327296386.04611903,-341733853.65054226,-356516817.11778647,-370727540.49877203,-384345184.13618535,-397376636.14246058,-409779056.6898939,-421803506.64100534,-434303947.44137579,-447320144.47727358,-459003394.54737478,-476007399.81425279]
[null,null,{"$f":"SUM(C114:C116)","v":36774178.919999987},73777567.69687131,103698164.59487128,126664970.88953795,135604350.46734998,139528588.60769206,143184122.0644418,149212195.54742533,157322289.22245491,151850130.16419008,147419000.18446064,155492391.28640705,139494651.36419031,135305161.97194991,125086807.54929507,112395339.74118829,100016574.8855713,90544401.906520784,86483228.997306526,86227803.944327414,88228266.748974502,110649792.29361868,102441360.20024657,105385279.57208538,97688768.715620518,87070876.808299959,77143071.094340682,71070276.609071314,72538555.799591303,79371072.669210494,88868001.049829602,98443102.16280818,143264363.90245825,130136634.75222653]
[]
["Closing Bal Internal Debt",{"$f":"+$B$70","v":"Public Transport Group"},247206645.89702931,250270994.75629142,266390264.65290752,279433237.38728672,287667377.18239033,306092595.45629781,321382190.4971922,318608422.03550237,317487865.32446551,305733759.69364256,292494103.78240812,284984564.57553345,316014709.40610731,306676257.68534988,285993085.90532815,267427168.55468196,249899024.16847706,230875297.24006042,218709832.14452669,208254556.28676009,193682087.85655764,199375839.51760423,187799088.00135833,181530115.08323148,290649438.16466832,399809673.41396302,511245865.66276574,499095751.94393492,492590868.78247231,484991552.96772772,480348985.35604113,480778631.92348146,492043658.65224165,472345351.92841148]
["Finance Lease liabiity",{"$f":"+$B$70","v":"Public Transport Group"},"0",29424623.158926308,27893291.054522552,26291441.92828279,24615417.103928059,22861349.023386862,21025148.526154097,19102491.323045321,17088803.612146884,14979246.781333588,12768701.138069181,10451748.603306852,8022654.3021491626,5475346.9794943091,2803398.1641681287,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9,1.6298145055770874E-9]
["Closing Bal External Debt",{"$f":"+$B$70","v":"Public Transport Group"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(C119:C121)","v":247206645.89702931},279695617.91521776,294283555.70743006,305724679.31556952,312282794.28631842,328953944.47968465,342407339.0233463,337710913.35854769,334576668.93661237,320713006.47497612,305262804.92047727,295436313.17884028,324037363.70825648,312151604.66484421,288796484.06949627,267427168.55468196,249899024.16847706,230875297.24006042,218709832.14452669,208254556.28676009,193682087.85655764,199375839.51760423,187799088.00135833,181530115.08323148,290649438.16466832,399809673.41396302,511245865.66276574,499095751.94393492,492590868.78247231,484991552.96772772,480348985.35604113,480778631.92348146,492043658.65224165,472345351.92841148]
["Net.Assets",{"$f":"+$B$70","v":"Public Transport Group"},-164863809.51334184,-147994623.75297511,-114221651.15991086,-75888089.971009597,-57647157.954686061,-36679080.297423244,-16549599.828573257,7228962.795020178,32939684.292741671,64397740.75304161,93685290.699994907,130417335.15257563,106520091.65907398,140897426.60359555,164556255.00175852,191536081.94768834,215482050.36049253,242973766.63034594,272088169.48200679,303865900.99546981,331332801.8351866,380830595.49126011,415302845.5644151,435635326.97343481,574975970.81528139,718271136.39961541,867084017.2547282,891959004.12660658,919238014.0427227,947246119.28398681,977728840.92222834,1012177164.7241811,1064770889.3677863,1085330114.1714764]
[]
["Retained Earnings C/F",{"$f":"+$B$70","v":"Public Transport Group"},-2868906.8993155193,-23673038.581599191,12320043.011277869,50496785.578357518,71946317.225644454,92740730.112734288,112685362.09455903,134089184.8636089,159610046.10227668,190875954.32650238,219965783.73853564,256494373.76068339,230105737.20223999,264267646.25418788,287704801.40889221,314456526.58730304,338167778.28133065,362857114.37306243,391722989.53949642,423244986.06486171,450448735.60182577,499675746.56736636,531020527.88721085,551066293.48140419,690111906.74979436,833103485.87404239,981603976.26172626,1002988319.3690014,1029936557.4501944,1057604298.4733227,1087736785.3311028,1121824717.5439601,1174047599.2423871,1194225226.655488]
["Share Capital (gwrl only)",{"$f":"+$B$70","v":"Public Transport Group"},"0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0"]
["Closing Bal. Asset\\Reval",{"$f":"+$B$70","v":"Public Transport Group"},-311260.4700000002,866875.13787132152,866875.13787132152,866875.13787132152,866875.13787132152,866875.13787132152,866875.13787132152,3051128.6265356494,3051128.6265356494,3051128.6265356494,3051128.6265356494,3051128.6265356494,5333167.0825620675,5333167.0825620675,5333167.0825620675,5333167.0825620675,5333167.0825620675,7894023.7570623886,7894023.7570623886,7894023.7570623886,7894023.7570623886,7894023.7570623886,10742857.121814933,10742857.121814933,10742857.121814933,10742857.121814933,10742857.121814933,13912051.095433507,13912051.095433507,13912051.095433507,13912051.095433507,13912051.095433507,13912051.095433507,13912051.095433507]
["Closing Bal Reserves",{"$f":"+$B$70","v":"Public Transport Group"},8469656.9657085054,11158831.370752741,8938722.3709399458,9095540.9927617349,5886941.3617982073,6060606.131971254,6245454.6189963771,6435940.9848757666,6625801.2439296022,6817949.4800035609,7015670.0149236647,7219124.445356451,7428479.0542717883,7643904.9468456693,7865578.1903041946,8093679.9578230157,8328396.6765998835,8569920.1802212801,8818447.8654476963,9074182.8535456788,9337334.1562985033,9608116.8468311615,9886752.2353892662,10173468.050215555,10468498.623671805,10772085.083758287,11084475.551187277,11405925.342171708,11736697.177094687,12077061.395230433,12427296.175692115,12787687.764787188,13158530.709966017,13540128.100555032]
["Close Balance S/F Reserve",{"$f":"+$B$70","v":"Public Transport Group"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Net Equity",null,{"$f":"SUM(C125:C130)","v":5289489.5963929854},-11647332.072975129,22125640.520089135,60459201.708990574,78700133.725313991,99668211.382576868,119797691.85142674,143576254.47502032,169286975.97274193,200745032.4330416,230032582.37999496,266764626.8325755,242867383.33907384,277244718.28359562,300903546.68175852,327883373.62768817,351829342.04049259,379321058.31034607,408435461.1620065,440213192.67546976,467680093.51518667,517177887.17125988,551650137.24441504,571982618.65343475,711323262.4952811,854618428.07961559,1003431308.9347285,1028306295.8066065,1055585305.7227225,1083593410.9639866,1114076132.6022284,1148524456.4041808,1201118181.0477865,1221677405.8514764]
[]
["balance check",null,{"$f":"C123-C131","v":-170153299.10973483},-136347291.67999998,-136347291.68000001,-136347291.68000019,-136347291.68000007,-136347291.68000013,-136347291.68000001,-136347291.68000013,-136347291.68000025,-136347291.68000001,-136347291.68000007,-136347291.67999989,-136347291.67999986,-136347291.68000007,-136347291.68000001,-136347291.67999983,-136347291.68000007,-136347291.68000013,-136347291.67999971,-136347291.67999995,-136347291.68000007,-136347291.67999977,-136347291.67999995,-136347291.67999995,-136347291.67999971,-136347291.68000019,-136347291.68000031,-136347291.67999995,-136347291.67999983,-136347291.67999983,-136347291.68000007,-136347291.67999971,-136347291.68000019,-136347291.68000007]
[]
[]
[]
[]
["Total Rates & Levies","Flood Protection",17989103.941146348,19480457.997674562,20507481.928696185,21993908.657685407,23598364.449844401,25868468.266897812,27668110.021421298,29385053.20756289,30718399.494863525,32601761.954062399,34058884.841689162,36555833.165438928,31931923.553661406,33917330.984137647,35054069.509100899,39696264.607678585,41343025.003274433,42108002.605877668,42620087.228285849,43683751.749299265,44182757.579178028,45476309.290158026,45926578.175135829,46735494.104613863,48459748.062100179,47563696.835215844,48428652.196744993,48689907.390165299,49400034.548168361,50215661.189452045,50486562.955658726,51555506.726827435,51387781.18564903,36565327.113215044]
["Bulk Water Levies",{"$f":"+B138","v":"Flood Protection"},"0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0"]
["Warm Greater Wellington rate",{"$f":"+$B$138","v":"Flood Protection"},"0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0"]
["External Interest Revenue",{"$f":"+$B$138","v":"Flood Protection"},146407.50029915135,159355.22554010927,185173.01679647321,220680.85518216959,275188.76134799398,316576.97177860909,354044.12986836367,386122.18924001884,411032.3822827196,437001.25852973526,485912.57964159007,516435.68943564087,548317.07761552685,581617.18756941776,616399.15241625695,652728.91469878028,690675.35140287597,730310.40454030398,771709.2175423475,814950.27772298199,860115.5650816547,907290.70772778837,956565.14422167488,1008032.2931395394,1061789.7301842486,1117939.3731774478,1176587.6752838443,1237845.8268339753,1301829.9661280874,1368661.3996207872,1438466.8319039121,1511378.6059236364,1587534.9538872382,1653521.8915056607]
["Total Government Subsidies",{"$f":"+$B$138","v":"Flood Protection"},"0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0"]
["Transport Fare Revenue",{"$f":"+$B$138","v":"Flood Protection"},"0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0"]
["Total Operating Revenue",{"$f":"+$B$138","v":"Flood Protection"},21151889.568679206,24045432.451243598,25461367.137956735,27247642.299401298,29128759.548293695,31177372.158420429,33139867.289912343,35004937.248089656,34442541.211228251,35042316.570853725,36592038.995856114,39061279.076149262,34529136.658542015,36608047.758347414,37841988.573065132,42586932.525876425,44340082.968807526,45214079.706840351,45837201.108465791,47013811.724598385,47629786.832057461,49044660.984198943,49619809.148799568,50558806.719695076,52418144.108968638,51661783.58693476,52671011.444879763,53081096.222393945,53945154.760873429,54919808.20464389,55355016.888802446,56593550.048993051,56492567.981045209,39684738.23518613]
[]
["Total Financial Costs",{"$f":"+$B$138","v":"Flood Protection"},4384537.5946652526,5342484.3062213995,5759744.0893383808,6352591.2366113681,7105216.9826847222,7742678.3198039085,8596869.9093623031,9282227.9633800089,9738581.9800436087,10224496.701496255,10571471.863500647,10714727.976982074,10834124.394239863,10793007.296034716,10769125.76840334,10989194.854220096,11322477.305808878,11545681.605418894,11528458.069853641,11301786.718464013,11090437.15108189,10948308.370692007,10754335.034612799,10697442.990642585,10754507.115679592,10818130.498555139,10958503.585033534,11098111.957747363,11272250.064332459,11473419.148852983,11692559.997432085,11963833.804774242,12260915.323483918,12593220.537166147]
["Depreciation",{"$f":"+$B$138","v":"Flood Protection"},978493.66645832732,1327793.5214960349,1525880.2232942688,1784508.9663979886,2003589.3128109858,2220634.0783104105,2411450.3919855617,2571542.4154197811,2807049.2761866013,3024942.846156755,3179305.436184044,3324491.6500614607,3375141.0490171062,3426425.873169688,3350968.647346756,3429000.3231254029,3460487.7899367493,3480741.9554998437,3550063.0632478865,3595449.4911638526,3618013.9874250721,3639373.3968377188,3692917.1773199085,3737023.1613767059,3746802.1662537511,3821414.3281857064,3903674.9738045484,3943269.517780262,3996929.9952915735,4025274.3816913962,4101372.8362384816,4128094.9081148687,3669805.5919951042,3796588.4653317886]
["Grants - Capital Works",{"$f":"+B147","v":"Flood Protection"},"0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0"]
["Total Operating Expenses",{"$f":"+$B$138","v":"Flood Protection"},16811188.330738589,20017636.123927511,20958764.511284087,22270139.396869838,23800486.199378744,24761335.482065514,26073746.771973904,27364582.065126497,27458292.178797569,27951771.549984988,28578329.21715444,29395008.162485413,29079457.979611758,29429056.503330126,29843169.524365518,30826681.017733935,31571797.16772981,32102376.278428972,32577906.193892945,32942459.040785246,32839884.46311764,33463535.846242823,33398348.060123257,33790062.849948987,34497125.552918121,34811270.292640015,35670630.48219303,35983143.903941274,36710410.619184397,37603646.984638937,38025384.12545304,38934785.16120331,38866994.430244014,22315057.888461672]
[]
["Capital Expenditure",{"$f":"+$B$138","v":"Flood Protection"},-21302880.682865776,-17846007.710363809,-20929774.229473595,-19149594.293823652,-18030148.858236618,-20907744.340902153,-21507453.668264225,-21818497.390951101,-20295765.887429163,-19257516.01172182,-12100890.136630228,-14007343.935389563,-8393165.1466540787,-4371143.3055507634,-11139557.794296613,-19432377.303813778,-20887973.081660375,-16402637.083956925,-11597931.069103459,-8730505.296501955,-13682257.374511028,-12873241.638537303,-13021121.754116418,-19473926.506109841,-18689063.325302113,-20774055.724797178,-20514653.656864535,-21106956.399869543,-21647100.118111119,-21920948.429227009,-22785823.363072261,-23750094.43644996,-23822334.037382547,-24531201.324366622]
["Investment in Subsidiary - Additions",{"$f":"+$B$138","v":"Flood Protection"},"0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0"]
[]
["Closing Bal External Debt",{"$f":"+$B$138","v":"Flood Protection"},"0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0"]
["Closing Bal Internal Debt",{"$f":"+$B$138","v":"Flood Protection"},85415017.837686315,107177084.81864268,122867158.94369686,136092111.30819947,147691539.94890341,161474240.11279434,175007949.89330205,188257476.39254716,200519471.10318667,211606726.85662526,214467858.67801949,217177851.48992783,219151154.0045222,215311390.52079579,217736899.01864123,224137886.37167823,230941376.54859829,233028679.14481381,230108810.18710268,223409932.15574777,221164516.41776866,217208705.97403654,212965111.49828878,214753838.61465502,214688248.18151522,217796943.49784055,220238967.91424525,223524279.81019714,227322913.27949992,231371789.15583786,236312856.81450078,242006013.28409427,248558415.780633,255635947.83299902]
["Closing Bal Other Investments",{"$f":"+$B$138","v":"Flood Protection"},6222223.8390400214,6633564.2471444802,7019837.2639409536,7442742.3191231228,7921304.2128711175,8442481.8990949262,9002382.5598407313,9595701.8366992474,10215361.233790928,10862513.809514657,11560201.791914478,12290080.819982823,13053554.206374135,13852086.923056286,14687208.323871318,15560514.987675641,16473673.687409911,17428424.490686554,18426583.997731127,19470048.722772889,20560798.625250932,21700900.797484811,22892513.315754242,24137889.262040824,25439380.924007092,26799444.181124669,28220643.085215028,29705654.64403329,31257273.816909246,32878418.731860086,34572136.134007968,36515884.082493834,38547462.351192482,40653190.614466079]
[]
["C/Balance Current Account",{"$f":"+$B$138","v":"Flood Protection"},-30.651780675528244,-439441.87183596141,-439369.93660215638,-439149.83117463742,-438937.9333491397,-436793.96633059706,-432950.7042718039,-432275.53255001624,-431463.98790708929,-430814.18839102518,-430050.33366717387,-420706.19130774087,-413823.97527528956,-412687.22276047245,-411415.30411894503,-410002.5001581196,-393496.40642143076,-391783.81402997609,-389911.90081445081,-375987.05684143072,-373776.61307777517,-348481.20226159424,-345904.15884716436,-343132.68784942856,-340159.06130039622,-336975.25971716235,-281121.73106214986,-277492.48747845605,-273627.4275204803,-269517.41661552817,-265153.03711134952,-216168.19850871596,-211265.54961966621,93041.29412200494]
["C/Balance Bank","Flood Protection",650,600.5,600.5,600.5,600.5,600.5,600.5,600.5,600.5,600.5,600.5,600.5,600.5,600.5,600.5,600.5,600.5,600.5,600.5,600.5,600.5,600.5,600.5,600.5,600.5,600.5,600.5,600.5,600.5,600.5,600.5,600.5,600.5,600.5]
["C/Balance Debtors","Flood Protection",549112.97,777871.77999999991,777871.77999999991,777871.77999999991,777871.77999999991,777871.77999999991,777871.77999999991,777871.77999999991,777871.77999999991,777871.77999999991,777871.77999999991,777871.77999999991,777871.77999999991,777871.77999999991,777871.77999999991,777871.77999999991,777871.77999999991,777871.77999999991,777871.77999999991,777871.77999999991,777871.77999999991,777871.77999999991,777871.77999999991,777871.77999999991,777871.77999999991,777871.77999999991,777871.77999999991,777871.77999999991,777871.77999999991,777871.77999999991,777871.77999999991,777871.77999999991,777871.77999999991,777871.77999999991]
["C/Balance Doubtful Debtors","Flood Protection",-34973.89,-14426.09,-14426.09,-14426.09,-14426.09,-14426.09,-14426.09,-14426.09,-14426.09,-14426.09,-14426.09,-14426.09,-14426.09,-14426.09,-14426.09,-14426.09,-14426.09,-14426.09,-14426.09,-14426.09,-14426.09,-14426.09,-14426.09,-14426.09,-14426.09,-14426.09,-14426.09,-14426.09,-14426.09,-14426.09,-14426.09,-14426.09,-14426.09,-14426.09]
["C/Balance Accrued Revenue","Flood Protection",53599.490000000005,111583.51999999999,111583.51999999999,111583.51999999999,111583.51999999999,111583.51999999999,111583.51999999999,111583.51999999999,111583.51999999999,111583.51999999999,111583.51999999999,111583.51999999999,111583.51999999999,111583.51999999999,111583.51999999999,111583.51999999999,111583.51999999999,111583.51999999999,111583.51999999999,111583.51999999999,111583.51999999999,111583.51999999999,111583.51999999999,111583.51999999999,111583.51999999999,111583.51999999999,111583.51999999999,111583.51999999999,111583.51999999999,111583.51999999999,111583.51999999999,111583.51999999999,111583.51999999999,111583.51999999999]
["Warm GW advances","Flood Protection","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0"]
["C/Balance Stock","Flood Protection",124206.55,123902.15,123902.15,123902.15,123902.15,123902.15,123902.15,123902.15,123902.15,123902.15,123902.15,123902.15,123902.15,123902.15,123902.15,123902.15,123902.15,123902.15,123902.15,123902.15,123902.15,123902.15,123902.15,123902.15,123902.15,123902.15,123902.15,123902.15,123902.15,123902.15,123902.15,123902.15,123902.15,123902.15]
["Total Current Assets","Flood Protection",{"$f":"SUM(C158:C164)","v":692564.46821932448},560089.98816403851,560161.92339784349,560382.02882536245,560593.92665086023,562737.89366940281,566581.15572819603,567256.32744998368,568067.87209291058,568717.67160897469,569481.526332826,578825.668692259,585707.88472471037,586844.63723952742,588116.55588105484,589529.35984188027,606035.45357856911,607748.04597002384,609619.95918554906,623544.80315856915,625755.24692222476,651050.65773840563,653627.70115283551,656399.17215057136,659372.79869960365,662556.60028283752,718410.12893785001,722039.37252154388,725904.43247951963,730014.4433844717,734378.82288865035,783363.66149128403,788266.3103803338,1092573.154122005]
[]
["C/Balance Creditors",{"$f":"+$B$138","v":"Flood Protection"},961701.08000000019,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998]
["C/Balance Accrued Expenses",{"$f":"+$B$138","v":"Flood Protection"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(C167:C168)","v":961701.08000000019},1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998,1527382.5299999998]
["Working Capital",{"$f":"+$B$138","v":"Flood Protection"},{"$f":"+C165-C169","v":-269136.61178067571},-967292.54183596128,-967220.6066021563,-967000.50117463735,-966788.60334913956,-964644.63633059699,-960801.37427180377,-960126.20255001611,-959314.65790708922,-958664.8583910251,-957901.00366717379,-948556.86130774079,-941674.64527528943,-940537.89276047237,-939265.97411894496,-937853.17015811952,-921347.07642143068,-919634.48402997595,-917762.57081445074,-903837.72684143065,-901627.28307777504,-876331.87226159417,-873754.82884716429,-870983.35784942843,-868009.73130039615,-864825.92971716227,-808972.40106214979,-805343.15747845592,-801478.09752048017,-797368.0866155281,-793003.70711134945,-744018.86850871576,-739116.21961966599,-434809.37587799481]
[]
[]
["Closing Bal Reserve Investments",{"$f":"+$B$138","v":"Flood Protection"},10233318.134597283,10622751.881231712,11016649.419519279,11438211.062518004,11846164.986945758,12820645.673359305,13836915.72257535,14884132.162091926,15934820.466831852,17008351.052280877,18073179.300970629,19132529.868438382,20222539.422094986,21263310.144084398,22466788.986898199,23744875.098335873,25046690.814389512,26346401.696198113,27620921.200085659,28879364.061008744,30253858.327764399,31628434.64175057,33056133.101059131,34591531.946336657,36158197.936055414,37796816.088692121,39456435.328684196,41177442.93856284,42948359.784345455,44770633.203438282,46645752.566902287,48561990.949544951,50560211.998807855,52001486.229273282]
["Closing Bal Forestry Investments","Flood Protection",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Closing Bal Investment in Subsidiary","Flood Protection",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Closing Bal Financial Instruments","Flood Protection",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Closing Bal FX Investment","Flood Protection",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Closing Bal Other Investments","Flood Protection",6222223.8390400214,6633564.2471444802,7019837.2639409536,7442742.3191231228,7921304.2128711175,8442481.8990949262,9002382.5598407313,9595701.8366992474,10215361.233790928,10862513.809514657,11560201.791914478,12290080.819982823,13053554.206374135,13852086.923056286,14687208.323871318,15560514.987675641,16473673.687409911,17428424.490686554,18426583.997731127,19470048.722772889,20560798.625250932,21700900.797484811,22892513.315754242,24137889.262040824,25439380.924007092,26799444.181124669,28220643.085215028,29705654.64403329,31257273.816909246,32878418.731860086,34572136.134007968,36515884.082493834,38547462.351192482,40653190.614466079]
[null,null,{"$f":"SUM(C173:C178)","v":16455541.973637305},17256316.128376193,18036486.683460232,18880953.381641127,19767469.199816875,21263127.572454229,22839298.282416083,24479833.998791173,26150181.700622782,27870864.861795533,29633381.092885107,31422610.688421205,33276093.628469121,35115397.067140684,37153997.310769513,39305390.086011514,41520364.50179942,43774826.186884671,46047505.197816789,48349412.783781633,50814656.953015327,53329335.439235382,55948646.416813374,58729421.208377481,61597578.86006251,64596260.269816786,67677078.413899228,70883097.582596123,74205633.601254702,77649051.935298368,81217888.700910255,85077875.032038778,89107674.350000337,92654676.843739361]
[]
["Capex Project C/Balance",{"$f":"+$B$138","v":"Flood Protection"},0,4741973.2999999989,4741973.2999999989,4741973.2999999989,4741973.2999999989,4741973.2999999989,4741973.2999999989,4741973.2999999989,4741973.2999999989,4741973.2999999989,4741973.2999999989,4741973.2999999989,4741973.2999999989,4741973.2999999989,4741973.2999999989,4741973.2999999989,4741973.2999999989,4741973.2999999989,4741973.2999999989,4741973.2999999989,4741973.2999999989,4741973.2999999989,4741973.2999999989,4741973.2999999989,4741973.2999999989,4741973.2999999989,4741973.2999999989,4741973.2999999989,4741973.2999999989,4741973.2999999989,4741973.2999999989,4741973.2999999989,4741973.2999999989,4741973.2999999989]
["Closing Bal Total Assets",{"$f":"+$B$138","v":"Flood Protection"},380138465.47533971,447595727.0232296,468343613.25270313,487236053.5225268,505160101.50802737,562153073.6461314,583343638.15492415,604957070.46152747,625044933.84609818,644021907.45617604,701229722.38938379,715042636.67745805,723286794.82664406,727345420.48561013,738352635.28046381,809486127.19045329,829996586.84326661,846164433.1203146,857646407.09025311,866110755.43703234,937220109.20220315,949795272.46031809,962735280.72878778,981815660.70549536,1000242418.9117354,1085000604.3534017,1105094539.5840447,1125919696.0708344,1147399811.9576564,1169141844.7407684,1191675464.2323604,1214809276.0350974,1238559321.033077,1262700372.7114182]
["Dep C/Bal Total Assets",{"$f":"+$B$138","v":"Flood Protection"},-12701051.846458327,-11648986.481496036,-12984366.704790302,-14518818.407188291,-16401680.219519278,-18509329.530093752,-20676234.454577677,-23040320.798400234,-25552288.143792093,-28072144.138938256,-30962018.576781724,-34187898.733011469,-36862558.623743884,-39421259.942626849,-42042747.439938538,-45369064.950163588,-48522723.033123165,-51746024.966736674,-55161251.995881222,-58555033.271500193,-61963037.656867929,-65427564.710828252,-69009017.344563812,-72312701.134478614,-75752188.866197705,-79447946.218300149,-83180294.206625596,-86828205.653664425,-90597479.947302222,-94417893.971127376,-98249649.805466846,-101891526.57946748,-105493394.8431343,-109003097.55840136]
[null,null,{"$f":"SUM(C181:C183)","v":367437413.62888139},440688713.84173357,460101219.84791285,477459208.41533852,493500394.58850813,548385717.41603756,567409377.00034642,586658722.96312714,604234619.00230598,620691736.61723769,675009677.112602,685596711.24444652,691166209.50290012,692666133.84298325,701051861.14052522,768859035.54028964,786215837.11014342,799160381.45357788,807227128.39437187,812297695.46553206,879999044.84533513,889109681.04948974,898468236.68422389,914244932.87101674,929232203.34553766,1010294631.4351015,1026656218.6774191,1043833463.7171699,1061544305.3103541,1079465924.0696411,1098167787.7268934,1117659722.7556298,1137807899.4899426,1158439248.4530168]
[]
["Closing Bal Internal Debt",{"$f":"+$B$138","v":"Flood Protection"},85415017.837686315,107177084.81864268,122867158.94369686,136092111.30819947,147691539.94890341,161474240.11279434,175007949.89330205,188257476.39254716,200519471.10318667,211606726.85662526,214467858.67801949,217177851.48992783,219151154.0045222,215311390.52079579,217736899.01864123,224137886.37167823,230941376.54859829,233028679.14481381,230108810.18710268,223409932.15574777,221164516.41776866,217208705.97403654,212965111.49828878,214753838.61465502,214688248.18151522,217796943.49784055,220238967.91424525,223524279.81019714,227322913.27949992,231371789.15583786,236312856.81450078,242006013.28409427,248558415.780633,255635947.83299902]
["Finance Lease liabiity",{"$f":"+$B$138","v":"Flood Protection"},"0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0"]
["Closing Bal External Debt",{"$f":"+$B$138","v":"Flood Protection"},"0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0"]
[null,null,{"$f":"SUM(C186:C188)","v":85415017.837686315},107177084.81864268,122867158.94369686,136092111.30819947,147691539.94890341,161474240.11279434,175007949.89330205,188257476.39254716,200519471.10318667,211606726.85662526,214467858.67801949,217177851.48992783,219151154.0045222,215311390.52079579,217736899.01864123,224137886.37167823,230941376.54859829,233028679.14481381,230108810.18710268,223409932.15574777,221164516.41776866,217208705.97403654,212965111.49828878,214753838.61465502,214688248.18151522,217796943.49784055,220238967.91424525,223524279.81019714,227322913.27949992,231371789.15583786,236312856.81450078,242006013.28409427,248558415.780633,255635947.83299902]
["Net.Assets",{"$f":"+$B$138","v":"Flood Protection"},298208801.15305173,349800652.60963106,354303326.98107409,359281049.98760557,364609535.23607254,407209960.23936707,414279924.01518875,421920954.36682129,428906014.94183528,435997209.76401722,489217298.52380055,498892913.5816322,504349474.48157191,511529602.49656785,519529693.45853466,583088686.08446503,595873477.98692322,608986894.01161885,622248060.83427155,636333338.36672449,708747558.09750402,724353978.64242709,740578016.77390134,757349532.10688984,775273524.29278457,856229122.27736068,873285356.77601111,890386938.33209062,907625547.53458869,924945818.7624861,942279815.90619183,959987565.63506544,977618041.83969033,995023168.08787906]
[]
["Retained Earnings C/F",{"$f":"+$B$138","v":"Flood Protection"},64732314.874590039,64315336.099013269,68424040.932168692,72979982.191701427,77900301.616188645,83341857.606129989,89391708.074852347,95984846.818298921,101918407.54598974,107935421.98140942,114884303.51142137,123491223.85761744,127850892.98289107,133989113.51591894,140784453.72180471,151266619.11850956,162733089.20353362,174545081.75013644,186529857.16082174,199342766.98371181,212758175.08589593,226964723.90986589,241758486.53923362,256991831.56370217,273346184.13003391,288558079.2716921,303898840.99438673,319275785.70296073,334739612.99886715,350233500.79977942,365688014.19966459,381430540.70481169,397057893.20635009,412986299.32260907]
["Share Capital (gwrl only)",{"$f":"+$B$138","v":"Flood Protection"},"0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0"]
["Closing Bal. Asset\\Reval",{"$f":"+$B$138","v":"Flood Protection"},227637671.77960828,272614202.61000001,272614202.61000001,272614202.61000001,272614202.61000001,308796446.96980262,308796446.96980262,308796446.96980262,308796446.96980262,308796446.96980262,354002062.09933192,354002062.09933192,354002062.09933192,354002062.09933192,354002062.09933192,405799390.41220987,405799390.41220987,405799390.41220987,405799390.41220987,405799390.41220987,463421497.33139586,463421497.33139586,463421497.33139586,463421497.33139586,463421497.33139586,527523398.21999049,527523398.21999049,527523398.21999049,527523398.21999049,527523398.21999049,527523398.21999049,527523398.21999049,527523398.21999049,527523398.21999049]
["Closing Bal Reserves",{"$f":"+$B$138","v":"Flood Protection"},10233318.134597283,10622751.881231712,11016649.419519279,11438211.062518004,11846164.986945758,12820645.673359305,13836915.72257535,14884132.162091926,15934820.466831852,17008351.052280877,18073179.300970625,19132529.868438382,20222539.422094986,21263310.144084398,22466788.986898199,23744875.098335873,25046690.814389512,26346401.696198117,27620921.200085666,28879364.061008744,30253858.327764399,31628434.64175057,33056133.101059139,34591531.946336657,36158197.936055422,37796816.088692121,39456435.328684196,41177442.93856284,42948359.784345455,44770633.203438282,46645752.566902295,48561990.949544951,50560211.998807855,52001486.229273282]
["Close Balance S/F Reserve",{"$f":"+$B$138","v":"Flood Protection"},"0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0"]
[]
["Net Equity",null,{"$f":"SUM(C192:C197)","v":302603304.78879559},347552290.59024501,352054892.96168804,357032395.86421943,362360669.21313441,404958950.2492919,412025070.76723033,419665425.95019346,426649674.98262423,433740220.00349295,486959544.91172391,496625815.82538772,502075494.504318,509254485.75933522,517253304.80803478,580810884.62905526,593579170.43013299,606690873.85854447,619950168.7731173,634021521.4569304,706433530.74505615,722014655.88301229,738236116.97168875,755004860.8414346,772925879.39748526,853878293.5803746,870878674.54306138,887976626.86151409,905211371.00320315,922527532.22320819,939857164.98655736,957515929.87434709,975141503.42514849,992511183.77187288]
[]
["balance check",null,{"$f":"C190-C198","v":-4394503.6357438564},2248362.0193860531,2248434.0193860531,2248654.1233861446,2248866.0229381323,2251009.990075171,2254853.2479584217,2255528.4166278243,2256339.9592110515,2256989.7605242729,2257753.6120766401,2267097.7562444806,2273979.9772539139,2275116.7372326255,2276388.6504998803,2277801.4554097652,2294307.5567902327,2296020.1530743837,2297892.0611542463,2311816.9097940922,2314027.3524478674,2339322.7594147921,2341899.8022125959,2344671.265455246,2347644.8952993155,2350828.6969860792,2406682.2329497337,2410311.4705765247,2414176.531385541,2418286.5392779112,2422650.9196344614,2471635.7607183456,2476538.4145418406,2511984.3160061836]
[]
[]
[]
[]
[]
["Total Rates & Levies","GW Water (Mgmt)",30862765.437637679,33068898.040148415,34230480.133181691,35891638.607580863,38304663.522572353,41213707.572876036,44125836.128492907,47240404.975647599,47906128.108436257,48336405.475834668,48426995.721397474,49663289.762344345,50689410.552301653,51673197.201758124,53158936.329155117,53965569.457102209,55215987.247118801,58004625.923600197,61427050.082008675,65517081.879000828,70784897.03686367,76055667.900311857,81987117.732406408,86459854.141207024,88201601.000360563,90184443.889240071,94413001.563217163,100574587.93329556,106543660.33478376,112163760.57724524,117470610.78964779,122230945.8358487,127827561.67461663,129544833.83534123]
["Bulk Water Levies",{"$f":"+B206","v":"GW Water (Mgmt)"},30862765.437637679,33068898.040148415,34230480.133181691,35891638.607580863,38304663.522572353,41213707.572876036,44125836.128492907,47240404.975647599,47906128.108436257,48336405.475834668,48426995.721397474,49663289.762344345,50689410.552301653,51673197.201758124,53158936.329155117,53965569.457102209,55215987.247118801,58004625.923600197,61427050.082008675,65517081.879000828,70784897.03686367,76055667.900311857,81987117.732406408,86459854.141207024,88201601.000360563,90184443.889240071,94413001.563217163,100574587.93329556,106543660.33478376,112163760.57724524,117470610.78964779,122230945.8358487,127827561.67461663,129544833.83534123]
["Warm Greater Wellington rate",{"$f":"+$B$206","v":"GW Water (Mgmt)"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"0","0","0"]
["External Interest Revenue",{"$f":"+$B$206","v":"GW Water (Mgmt)"},1029757.3724756849,956649.46646062506,1054631.6828093547,1267352.1927885443,1621439.9836426484,1922534.2527479839,2208318.2307052775,2466270.9929971262,2681587.510199504,2906054.9793829825,3323690.3811378814,3590037.7654264038,3868361.0506205186,4159198.7192142424,4463113.4661432356,4780693.2874871483,5112552.6181253884,5459333.5205475576,5821706.9271187158,6200373.9382030973,6596067.1786579732,7009552.2153223101,7441629.038242843,7893133.6085035801,8364939.4756535711,8857959.4678624589,9373147.4580740463,9911500.2095751762,10474059.304550864,11061913.159357198,11676199.13041134,12318105.714773213,12988874.849676825,12749278.093640035]
["Total Government Subsidies",{"$f":"+$B$206","v":"GW Water (Mgmt)"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"0","0","0"]
["Transport Fare Revenue",{"$f":"+$B$206","v":"GW Water (Mgmt)"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"0","0","0"]
["Total Operating Revenue",{"$f":"+$B$206","v":"GW Water (Mgmt)"},32169959.810113363,34308331.112883121,35572419.959965512,37450895.874647461,40222970.966755785,43447183.022418685,46641503.022300817,50019556.907683209,50906541.295515969,51567343.819958583,52091975.158104651,53591336.180447221,54902540.428652175,56184060.123216964,57980747.281587847,59123073.439185679,60701728.729979783,63844612.086178057,67637022.703998297,72113486.825972244,77796993.669865891,83477250.77715674,89849018.045402259,94781664.449958682,97003790.710267171,99501733.491209805,104241064.16500807,110950101.58946195,117491013.35485765,123708433.32643592,129653947.50345823,135051314.62788466,141328744.86310148,142816666.43456545]
[]
["Total Financial Costs",{"$f":"+$B$206","v":"GW Water (Mgmt)"},4417317.3235932011,4957186.4305651663,5193539.1435895804,5782490.9318125602,7423201.5306643425,9372355.7116097528,11374012.70516897,12256218.177893683,11903974.979928663,11648407.416619454,11609147.206926266,11653814.750432186,11697570.479660232,11804847.238823142,11901399.981282398,12130234.416236617,12731279.565585453,13911252.704324346,15473365.272327535,17514950.910235945,20067784.823565707,22916642.374208625,26057215.288769614,27657803.482192617,27729047.589036658,28150271.768939059,30208203.477710512,33462360.029635161,36306762.33565785,38817308.68422284,41712156.841272667,44469212.272784397,47058168.84548644,49649466.474284492]
["Depreciation",{"$f":"+$B$206","v":"GW Water (Mgmt)"},10514302.390000004,15675165.429200001,15951198.509200001,16199792.84764,16669605.602871997,17638324.836230233,16722145.632112605,17434407.272055805,17405155.749900538,17277191.580835111,17170268.842506386,17146856.964932125,17043109.058869623,17115617.997992232,17220880.928742401,17259006.162795343,17441371.324057296,17831145.52002259,18564897.069617264,19238418.373582155,20358042.901486721,21361461.166297145,22529031.40687789,24052808.124280825,24420838.543627951,24599841.050726533,24906786.694898777,25600981.55692751,25795533.187859386,26409404.815241344,27942788.548668705,28163758.172232524,27496338.454581067,27445403.566961337]
["Grants - Capital Works",{"$f":"+B215","v":"GW Water (Mgmt)"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"0","0","0"]
["Total Operating Expenses",{"$f":"+$B$206","v":"GW Water (Mgmt)"},36229857.540192053,42658346.636397243,43525970.23355332,44646627.272138178,47197871.839910254,50716629.171376325,52032780.479061231,55245551.742619149,55537904.491886228,55568759.757717922,55291112.499118149,56172527.433541901,56706083.59441217,57189464.740494728,58258317.837461501,58540668.755276054,59342487.673749208,61529364.489590265,64427202.93094448,67758537.025051311,72302896.590984583,76628716.849672288,81610607.506336749,85948548.41748552,87074859.923853755,88098084.711630389,90957176.74629727,95632202.762976944,99443309.5457277,103354842.66504642,108772834.71481101,111822106.63550958,114582042.53182635,115009991.60123521]
[]
["Capital Expenditure",{"$f":"+$B$206","v":"GW Water (Mgmt)"},-12917708,-14645000,-14732101.022,-23015143.799999997,-48542775.626320004,-40988634.517697036,-42299999.524119519,-5482800.2909976775,-3770755.5079554245,-4887733.5848556329,-8077665.7199629545,-8733389.2683629896,-8558680.9322138131,-12015068.217487635,-9095758.819745278,-18262786.974032402,-25286150.990983225,-43090141.063447222,-42877441.393196322,-64982758.022181205,-66695433.209964253,-80563363.830097914,-82398354.559209526,-21735648.656363174,-22501883.199375357,-37785664.895212226,-91480093.835454926,-90160559.038839042,-78990263.822559074,-80917998.767497614,-89417783.098295599,-85233065.782393634,-87534358.558518246,-90125802.481753901]
["Investment in Subsidiary - Additions",{"$f":"+$B$206","v":"GW Water (Mgmt)"},"0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0"]
[]
["Closing Bal External Debt",{"$f":"+$B$206","v":"GW Water (Mgmt)"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Closing Bal Internal Debt",{"$f":"+$B$206","v":"GW Water (Mgmt)"},82697198.176484123,98636602.140009448,108929586.60920662,126923679.55184589,170168593.31689101,205550120.55121383,241632109.73631328,240347017.13935012,237074172.37404069,234720053.7892912,235362599.33232719,236419414.26317975,236995018.40924534,240538679.47909486,240727798.30885103,249599910.67715386,264967136.01920706,297241118.22088122,328140964.75264072,379813479.79909867,431445825.75196499,495114942.85792041,558609947.95991266,559894676.03167176,561076229.82932413,576506806.32697976,644089157.40483785,708294954.33302271,759105079.21403217,809651138.46141922,867394249.00549674,919173255.79136467,971226011.50625193,1024207395.3720125]
["Closing Bal Other Investments",{"$f":"+$B$206","v":"GW Water (Mgmt)"},32025905.227119796,35543879.375420146,39102411.058229499,43085421.651018046,47482264.519460693,52244035.923359074,57356893.759691209,62797413.308850244,68527605.589115694,74561529.062586352,81097540.387152255,87986631.761479244,95243120.868440673,102881927.10151701,110918597.48439665,119369333.72537206,128251020.4567299,137581254.71156719,147378376.69280148,157661501.89158121,168450554.61485144,179766302.98449054,191630395.47321671,204065399.04536664,217094838.973685,230743240.40643421,245036171.762447,260000290.03520522,275663388.09064507,292054444.04716533,309203672.83026302,327142579.9983452,346227793.66003579,364335453.44433373]
[]
["C/Balance Current Account",{"$f":"+$B$206","v":"GW Water (Mgmt)"},3.7252902984619141E-9,-1.1175870895385742E-8,300.03442638367414,911.43442639708519,1794.349226385355,3012.5123724043369,4525.6060272604227,6401.0745531618595,8655.3595066964626,11362.864978164434,14545.579779267311,18224.376695871353,22420.852921038866,27157.35283228755,32456.991445541382,38343.678569674492,44842.143680334091,51977.961531400681,59777.578530788422,68268.339896440506,77478.517620325089,87437.339260995388,98175.017585873604,109722.78109550476,122112.90544724464,135378.7458088398,149554.77016496658,164676.59360980988,180781.0136474371,197906.04653334618,216090.96468400955,216090.96468400955,216090.96468424797,216090.96468484402]
["C/Balance Bank","GW Water (Mgmt)",86.800000000000011,86.800000000000011,86.800000000000011,86.800000000000011,86.800000000000011,86.800000000000011,86.800000000000011,86.800000000000011,86.800000000000011,86.800000000000011,86.800000000000011,86.800000000000011,86.800000000000011,86.800000000000011,86.800000000000011,86.800000000000011,86.800000000000011,86.800000000000011,86.800000000000011,86.800000000000011,86.800000000000011,86.800000000000011,86.800000000000011,86.800000000000011,86.800000000000011,86.800000000000011,86.800000000000011,86.800000000000011,86.800000000000011,86.800000000000011,86.800000000000011,86.800000000000011,86.800000000000011,86.800000000000011]
["C/Balance Debtors","GW Water (Mgmt)",2832966.08,4181549.5399999996,4181549.5399999996,4181549.5399999996,4181549.5399999996,4181549.5399999996,4181549.5399999996,4181549.5399999996,4181549.5399999996,4181549.5399999996,4181549.5399999996,4181549.5399999996,4181549.5399999996,4181549.5399999996,4181549.5399999996,4181549.5399999996,4181549.5399999996,4181549.5399999996,4181549.5399999996,4181549.5399999996,4181549.5399999996,4181549.5399999996,4181549.5399999996,4181549.5399999996,4181549.5399999996,4181549.5399999996,4181549.5399999996,4181549.5399999996,4181549.5399999996,4181549.5399999996,4181549.5399999996,4181549.5399999996,4181549.5399999996,4181549.5399999996]
["C/Balance Doubtful Debtors","GW Water (Mgmt)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["C/Balance Accrued Revenue","GW Water (Mgmt)",241512.38,285252.51,285252.51,285252.51,285252.51,285252.51,285252.51,285252.51,285252.51,285252.51,285252.51,285252.51,285252.51,285252.51,285252.51,285252.51,285252.51,285252.51,285252.51,285252.51,285252.51,285252.51,285252.51,285252.51,285252.51,285252.51,285252.51,285252.51,285252.51,285252.51,285252.51,285252.51,285252.51,285252.51]
["Warm GW advances","GW Water (Mgmt)","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0"]
["C/Balance Stock","GW Water (Mgmt)",2565243.7400000002,2636873.6399999997,2636873.6399999997,2636873.6399999997,2636873.6399999997,2636873.6399999997,2636873.6399999997,2636873.6399999997,2636873.6399999997,2636873.6399999997,2636873.6399999997,2636873.6399999997,2636873.6399999997,2636873.6399999997,2636873.6399999997,2636873.6399999997,2636873.6399999997,2636873.6399999997,2636873.6399999997,2636873.6399999997,2636873.6399999997,2636873.6399999997,2636873.6399999997,2636873.6399999997,2636873.6399999997,2636873.6399999997,2636873.6399999997,2636873.6399999997,2636873.6399999997,2636873.6399999997,2636873.6399999997,2636873.6399999997,2636873.6399999997,2636873.6399999997]
["Total Current Assets","GW Water (Mgmt)",{"$f":"SUM(C226:C232)","v":5639809.0000000037},7103762.4899999881,7104062.524426383,7104673.9244263964,7105556.8392263846,7106775.0023724036,7108288.0960272597,7110163.5645531612,7112417.8495066958,7115125.3549781637,7118308.0697792666,7121986.8666958706,7126183.3429210382,7130919.8428322868,7136219.4814455407,7142106.1685696738,7148604.6336803334,7155740.4515314,7163540.0685307877,7172030.8298964398,7181241.0076203244,7191199.8292609947,7201937.5075858729,7213485.2710955041,7225875.3954472439,7239141.2358088391,7253317.2601649659,7268439.0836098092,7284543.5036474364,7301668.5365333455,7319853.4546840088,7319853.4546840088,7319853.4546842473,7319853.4546848433]
[]
["C/Balance Creditors",{"$f":"+$B$206","v":"GW Water (Mgmt)"},1839397.6199999999,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6]
["C/Balance Accrued Expenses",{"$f":"+$B$206","v":"GW Water (Mgmt)"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(C235:C236)","v":1839397.6199999999},3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6,3844560.6]
["Working Capital",{"$f":"+$B$206","v":"GW Water (Mgmt)"},{"$f":"+C233-C237","v":3800411.3800000036},3259201.889999988,3259501.9244263829,3260113.3244263963,3260996.2392263846,3262214.4023724035,3263727.4960272596,3265602.9645531611,3267857.2495066957,3270564.7549781636,3273747.4697792665,3277426.2666958706,3281622.7429210381,3286359.2428322867,3291658.8814455406,3297545.5685696737,3304044.0336803333,3311179.8515313999,3318979.4685307876,3327470.2298964397,3336680.4076203243,3346639.2292609946,3357376.9075858728,3368924.671095504,3381314.7954472438,3394580.635808839,3408756.6601649658,3423878.4836098091,3439982.9036474363,3457107.9365333454,3475292.8546840088,3475292.8546840088,3475292.8546842472,3475292.8546848432]
[]
[]
["Closing Bal Reserve Investments",{"$f":"+$B$206","v":"GW Water (Mgmt)"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Closing Bal Forestry Investments","GW Water (Mgmt)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Closing Bal Investment in Subsidiary","GW Water (Mgmt)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Closing Bal Financial Instruments","GW Water (Mgmt)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Closing Bal FX Investment","GW Water (Mgmt)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Closing Bal Other Investments","GW Water (Mgmt)",32025905.227119796,35543879.375420146,39102411.058229499,43085421.651018046,47482264.519460693,52244035.923359074,57356893.759691209,62797413.308850244,68527605.589115694,74561529.062586352,81097540.387152255,87986631.761479244,95243120.868440673,102881927.10151701,110918597.48439665,119369333.72537206,128251020.4567299,137581254.71156719,147378376.69280148,157661501.89158121,168450554.61485144,179766302.98449054,191630395.47321671,204065399.04536664,217094838.973685,230743240.40643421,245036171.762447,260000290.03520522,275663388.09064507,292054444.04716533,309203672.83026302,327142579.9983452,346227793.66003579,364335453.44433373]
[null,null,{"$f":"SUM(C241:C246)","v":32025905.227119796},35543879.375420146,39102411.058229499,43085421.651018046,47482264.519460693,52244035.923359074,57356893.759691209,62797413.308850244,68527605.589115694,74561529.062586352,81097540.387152255,87986631.761479244,95243120.868440673,102881927.10151701,110918597.48439665,119369333.72537206,128251020.4567299,137581254.71156719,147378376.69280148,157661501.89158121,168450554.61485144,179766302.98449054,191630395.47321671,204065399.04536664,217094838.973685,230743240.40643421,245036171.762447,260000290.03520522,275663388.09064507,292054444.04716533,309203672.83026302,327142579.9983452,346227793.66003579,364335453.44433373]
[]
["Capex Project C/Balance",{"$f":"+$B$206","v":"GW Water (Mgmt)"},0,3182547.0100000002,3182547.0100000002,3182547.0100000002,3182547.0100000002,3182547.0100000002,3182547.0100000002,3182547.0100000002,3182547.0100000002,3182547.0100000002,3182547.0100000002,3182547.0100000002,3182547.0100000002,3182547.0100000002,3182547.0100000002,3182547.0100000002,3182547.0100000002,3182547.0100000002,3182547.0100000002,3182547.0100000002,3182547.0100000002,3182547.0100000002,3182547.0100000002,3182547.0100000002,3182547.0100000002,3182547.0100000002,3182547.0100000002,3182547.0100000002,3182547.0100000002,3182547.0100000002,3182547.0100000002,3182547.0100000002,3182547.0100000002,3182547.0100000002]
["Closing Bal Total Assets",{"$f":"+$B$206","v":"GW Water (Mgmt)"},522551075.84351432,695733443.62101936,710465544.64301932,733480688.44301927,782023464.06933928,906020430.71950746,948320430.24362683,953803230.53462458,957573986.04257989,962461719.62743556,1063965994.465901,1072699383.734264,1081258064.6664779,1093273132.8839655,1102368891.7037108,1225784150.3290441,1251070301.3200274,1294160442.3834743,1337037883.7766709,1402020641.798852,1587066108.2456305,1667629472.0757284,1750027826.6349382,1771763475.291301,1794265358.4906764,1965255028.4577162,2056735122.2931712,2146895681.33201,2225885945.1545696,2306803943.9220672,2546144008.2559891,2631377074.0383825,2718911432.5969009,2809037235.0786543]
["Dep C/Bal Total Assets",{"$f":"+$B$206","v":"GW Water (Mgmt)"},-53957487.440000005,-70071942.349199995,-86023140.858400002,-102222933.70604001,-118892539.30891201,-136530864.14514226,-153253009.77725482,-170687417.04931065,-188092572.79921117,-205369764.38004637,-222540033.22255269,-239686890.1874848,-256729999.24635446,-273845617.24434668,-291066498.17308909,-308325504.33588439,-325766875.65994173,-343598021.1799643,-362162918.24958158,-381401336.62316376,-401759379.52465039,-423120840.69094765,-445649872.09782547,-469702680.22210628,-494123518.76573426,-518723359.81646079,-543630146.51135957,-569231128.06828713,-595026661.25614631,-621436066.07138789,-649378854.62005651,-677542612.79228902,-705038951.24687016,-732484354.81383145]
[null,null,{"$f":"SUM(C249:C251)","v":468593588.40351433},628844048.28181934,627624950.79461932,634440301.74697924,666313471.77042723,772672113.58436513,798249967.476372,786298360.49531388,772663960.25336874,760274502.25738919,844608508.25334835,836195040.55677938,827710612.43012345,822610062.64961886,814484940.54062176,920641193.00315976,928485972.67008567,953744968.21351004,978057512.53708935,1023801852.1856883,1188489275.7309802,1247691178.3947806,1307560501.5471127,1305243342.0791948,1303324386.7349422,1449714215.6512554,1516287522.7918115,1580847100.2737229,1634041830.9084234,1688550424.8606796,1899947700.6459327,1957017008.2560937,2017055028.3600311,2079735427.2748232]
[]
["Closing Bal Internal Debt",{"$f":"+$B$206","v":"GW Water (Mgmt)"},82697198.176484123,98636602.140009448,108929586.60920662,126923679.55184589,170168593.31689101,205550120.55121383,241632109.73631328,240347017.13935012,237074172.37404069,234720053.7892912,235362599.33232719,236419414.26317975,236995018.40924534,240538679.47909486,240727798.30885103,249599910.67715386,264967136.01920706,297241118.22088122,328140964.75264072,379813479.79909867,431445825.75196499,495114942.85792041,558609947.95991266,559894676.03167176,561076229.82932413,576506806.32697976,644089157.40483785,708294954.33302271,759105079.21403217,809651138.46141922,867394249.00549674,919173255.79136467,971226011.50625193,1024207395.3720125]
["Finance Lease liabiity",{"$f":"+$B$206","v":"GW Water (Mgmt)"},"0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0"]
["Closing Bal External Debt",{"$f":"+$B$206","v":"GW Water (Mgmt)"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(C254:C256)","v":82697198.176484123},98636602.140009448,108929586.60920662,126923679.55184589,170168593.31689101,205550120.55121383,241632109.73631328,240347017.13935012,237074172.37404069,234720053.7892912,235362599.33232719,236419414.26317975,236995018.40924534,240538679.47909486,240727798.30885103,249599910.67715386,264967136.01920706,297241118.22088122,328140964.75264072,379813479.79909867,431445825.75196499,495114942.85792041,558609947.95991266,559894676.03167176,561076229.82932413,576506806.32697976,644089157.40483785,708294954.33302271,759105079.21403217,809651138.46141922,867394249.00549674,919173255.79136467,971226011.50625193,1024207395.3720125]
["Net.Assets",{"$f":"+$B$206","v":"GW Water (Mgmt)"},421722706.83415025,569010527.4072299,561057277.16806829,553862157.17057776,546888139.21222329,622628243.3588829,617238478.99577737,612014359.62936735,607385250.71795058,603386542.28566253,693617196.77795243,691039684.3217746,689240337.6322397,688239669.51487327,687967398.59761274,793708161.61994767,795073901.14128876,797396284.5557276,800613903.94578063,804977344.50806713,928830685.00148678,935689177.75061238,943938325.96800232,952782989.76398528,962724310.67475069,1107345230.3665185,1120643293.8095858,1135976314.4595156,1154040122.6886837,1174410838.3829591,1345232417.3253841,1368461625.3177583,1395532103.3684998,1423338778.201829]
[]
["Retained Earnings C/F",{"$f":"+$B$206","v":"GW Water (Mgmt)"},158900561.38063562,160741215.62540901,152787665.38624761,145591933.98875695,138617033.11560243,131347586.96664479,125956309.50988421,120730314.67494844,116098951.47857812,112097535.54081875,108898398.19980523,106317206.94671059,104513663.78095064,103508259.16367292,103230688.60779917,103813093.29170895,105172334.34793937,107487581.94452721,110697401.71758097,115052351.518502,120546448.59738326,127394982.52486759,135633393.06393313,144466509.09640652,154395439.88281965,165799088.66239893,179082976.08111012,194400874.90759468,212448578.71672475,232802169.3781141,253683282.1667614,276912490.15913653,303659192.49041128,331465867.32374191]
["Share Capital (gwrl only)",{"$f":"+$B$206","v":"GW Water (Mgmt)"},"0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0"]
["Closing Bal. Asset\\Reval",{"$f":"+$B$206","v":"GW Water (Mgmt)"},263657559.45431617,418033248.77208829,418033248.77262282,418033248.77315736,418033248.77369189,501041580.90669757,501041580.90723211,501041580.90776664,501041580.90830117,501041580.90883571,594468190.02787268,594468190.02840722,594468190.02894175,594468190.02947628,594468190.03001082,699620661.68184614,699620661.68238068,699620661.68291521,699620661.68344975,699620661.68398428,817970694.92133319,817970694.92186773,817970694.92240226,817970694.9229368,817970694.92347133,951174699.9958334,951174699.99636793,951174699.99690247,951174699.997437,951174699.99797153,1101096981.2341325,1101096981.2346671,1101420756.9546671,1101744532.6746671]
["Closing Bal Reserves",{"$f":"+$B$206","v":"GW Water (Mgmt)"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Close Balance S/F Reserve",{"$f":"+$B$206","v":"GW Water (Mgmt)"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Net Equity",null,{"$f":"SUM(C260:C265)","v":422558120.83495176},578774464.3974973,570820914.15887046,563625182.76191425,556650281.88929439,632389167.87334239,626997890.41711628,621771895.58271503,617140532.38687932,613139116.44965446,703366588.22767794,700785396.9751178,698981853.80989242,697976449.19314921,697698878.63780999,803433754.97355509,804792996.03032005,807108243.62744236,810318063.40103078,814673013.20248628,938517143.51871645,945365677.44673538,953604087.9863354,962437204.01934338,972366134.80629098,1116973788.6582322,1130257676.0774779,1145575574.9044971,1163623278.7141619,1183976869.3760858,1354780263.4008939,1378009471.3938036,1405079949.4450784,1433210399.998409]
[]
["balance check",null,{"$f":"C258-C266","v":-835414.00080150366},-9763936.990267396,-9763636.9908021688,-9763025.5913364887,-9762142.6770710945,-9760924.5144594908,-9759411.4213389158,-9757535.953347683,-9755281.6689287424,-9752574.1639919281,-9749391.4497255087,-9745712.6533432007,-9741516.1776527166,-9736779.6782759428,-9731480.0401972532,-9725593.3536074162,-9719094.889031291,-9711959.0717147589,-9704159.455250144,-9695668.6944191456,-9686458.5172296762,-9676499.696123004,-9665762.0183330774,-9654214.2553580999,-9641824.1315402985,-9628558.2917137146,-9614382.2678921223,-9599260.444981575,-9583156.0254781246,-9566030.9931266308,-9547846.0755097866,-9547846.0760452747,-9547846.0765786171,-9871621.7965800762]
[]
[]
[]
["Total Regnl Rates","Regional Leadership",12094113.612934904,14269848.425492309,15302416.80227283,15280735.955120463,16042973.834095733,16141772.877980981,15960218.932465484,16180419.67121858,16513044.100565482,16769732.403289231,16963289.242634468,17397270.931898914,17459087.021206215,17785530.418808926,18512179.078053825,18420046.39445119,19009355.978238218,19582803.566421349,19675997.373266261,20380915.009955887,21050322.108501423,21095830.513695419,21364338.071239986,22348106.858677685,22312477.171612006,22714947.813721668,24364374.279048238,24141181.009529181,24183774.092205618,25079624.224616118,25190006.634121004,24466440.128137156,24308866.768389016,19493096.306357354]
["Total Regnl Rates","PK Parks",6582026.470579654,6205362.5611611865,6502226.5080758408,6524316.5653362768,6737923.3428603113,7059315.62981176,7605312.7659104411,7435343.596890158,7844274.5806861185,8188305.2604594361,8651533.8587572575,9041240.5371076614,8992446.5372854657,9423499.7711487841,9306120.3465217669,9795416.3728524223,10387685.638161678,10472506.566167591,10874163.3351606,11671061.10530436,10440024.618506348,11671979.488043936,11957850.315311233,12138724.207440374,11980296.865124151,12310750.057302795,12702586.831277585,12844411.491075594,12945573.517374821,13452638.034420708,14506333.440110167,14099795.471235991,14428774.443618136,8833328.8509957064]
["Total Regnl Rates","Public Transport",64656396.127130859,67273010.401963174,72101033.010295495,78920230.163954556,86292939.305076674,91627679.666785493,95724325.170245633,99603636.558210179,101488844.15203176,106645543.01355119,106817087.28778119,106937702.71789752,109381852.05104867,111952719.65520748,109554029.08104734,109886814.10810824,110303282.52121782,110913387.89468691,111882733.91791798,113062095.51513185,113319730.65691818,114334408.36808115,116997774.95223491,114261335.31284589,118277657.06362589,126551328.53130862,134627444.07935619,137909436.60482082,138586505.78279579,140020456.54921046,142491556.99320453,139727518.4701162,153544227.42145264,246855748.81436917]
["Total Regnl Rates","Flood protection and control works",17989103.941146348,19633966.913517047,20532121.415334314,21856811.04622573,23396404.953506049,25119612.786268186,26988239.39044426,28765184.206939157,30253360.651121516,32733500.368592151,34231559.60243617,31549420.612875067,32000978.089157689,33986385.543358296,35123124.03456711,39732799.287694387,41411359.3030864,42176336.876361288,42688421.487261824,43752086.049603879,44251091.802818634,45544643.590584792,45994912.439456388,46803828.306609124,48528082.377810448,48286445.207758762,49212291.518532962,49502529.326091811,50139334.846387923,50879281.869243152,51089795.815887928,52096351.75880111,51992528.567860775,36345578.64307712]
["Total Regnl Rates","Environment Management",28377719.644650873,30134181.520204306,31407908.13756391,32796171.76959981,33964262.008747958,34702550.580130778,35166483.442066491,35929232.485032469,36686768.582629971,37382097.134542979,37909585.191889353,38423361.41780486,39129477.629585654,39948119.624067448,40796496.691505089,41436971.461785734,42367449.119342908,43129200.235091351,43689139.533807598,44583302.809695631,45559089.358732238,46548290.003091574,47638328.429832399,48557885.136649877,49394281.92827823,50176573.531650037,51466436.783360392,52087043.841404952,53177422.092847221,54423073.579434589,55291036.647210136,55968142.221957155,57725673.309403211,12483460.679803049]
["Total Regnl Rates","Investments.",-8919802.4180854484,-8665191.5540739745,-7767139.6121386383,-10286433.313777609,-9798464.310625447,-9717472.1373389121,-10137368.851680087,-10157474.631869869,-9546097.6240590997,-9488473.0357163474,-8469863.5581039339,-8802876.8926182762,-8907626.8498652056,-8949256.6181663703,-8932002.8530760892,-9008007.3545151502,-9011467.2249789555,-9009153.8356754612,-9010949.8435489386,-9089459.4353461843,-9352128.4485020079,-10054118.551940192,-10235023.728739336,-10237479.819481008,-10457834.028886098,-10737340.078111421,-11052532.444462892,-11369344.158423509,-11397694.802145235,-11479428.475323949,-14763034.617866594,-12248992.875922915,77063682.420584753,60199625.8898331]
["Total Regnl Rates","GW Water (Mgmt)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"0","0","0"]
[]
[null,null,"Last Year Base","Current Year Base","Current Year Inflated",{"$f":"+E280","v":"Current Year Inflated"},"Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated","Current Year Inflated"]
[null,null,{"$f":"C2","v":"2017/18"},"2018/19","2019/20","2020/21","2021/22","2022/23","2023/24","2024/25","2025/26","2026/27","2027/28","2028/29","2029/30","2030/31","2031/32","2032/33","2033/34","2034/35","2035/36","2036/37","2037/38","2038/39","2039/40","2040/41","2041/42","2042/43","2043/44","2044/45","2045/46","2046/47","2047/48","2048/49","2049/50","2050/51"]
["Total Operating Expenses","Water supply",36229857.540192053,42658346.636397243,43525970.23355332,44646627.272138171,47197871.839910261,50716629.171376325,52032780.479061231,55245551.742619142,55537904.491886228,55568759.757717922,55291112.499118149,56172527.433541909,56706083.59441217,57189464.740494728,58258317.837461494,58540668.755276047,59342487.673749216,61529364.489590257,64427202.93094448,67758537.025051311,72302896.590984583,76628716.849672288,81610607.506336734,85948548.417485505,87074859.923853755,88098084.711630389,90957176.746297285,95632202.762976944,99443309.545727715,103354842.66504642,108772834.71481101,111822106.63550957,114582042.53182632,115009991.60123521]
["Total Operating Expenses","Other Activities",14058284.412636738,3777077.1524028555,2927669.6963147256,3201338.1098436862,2332341.1799895098,2078529.7499699169,3143319.6045624455,2434416.0216349894,2377774.0729520135,3060368.707621769,2316770.5699371835,3236048.2336886185,3715397.7742771846,2739295.2543385462,2905388.2466040584,3705678.1327738445,2915691.2124019535,2961478.4465284231,3692450.4918165812,3090695.2417806345,3248109.3537293528,4070707.255003423,3287641.6147365514,3359813.2164110597,4060557.0698646568,3420817.6205476597,3609114.8962403685,4545496.5785586853,3778568.2942768382,3604706.5311073535,4542404.5485767517,3896147.3493788666,3504389.7325282758,8997689.1863137987]
["Total Operating Expenses","Environment Management",41187866.168540515,41655571.200312778,42430296.200025365,43797190.485272981,45061690.609441787,44662066.110805102,45316614.224628508,46222908.549668759,47123740.033158191,48037026.03284581,49001213.001265131,49677291.450968586,50560689.96980381,51577945.509701118,52753759.707849056,53643167.271874562,54721266.664105408,55664541.151533321,56678259.730565391,57744689.197232991,58962824.024666399,60320770.350026108,61542409.072211966,62852503.207625002,64062265.804343499,65196231.091662884,66564765.144170977,67568820.233922943,68981540.878219455,70411541.564529389,71725949.552312523,72783351.600116804,74718504.259670377,13078698.639046706]
["Total Operating Expenses","PK Parks",8829970.6182738356,8126571.2419331083,8635749.0843386985,8866774.3101744521,8962639.7500277348,9383712.4153308552,9270916.138078928,9418259.6953324769,9513679.5868072566,9679832.0531444307,10189582.372595733,10249099.687562851,10378975.65980895,10667891.699807143,10886163.840622617,11068501.538114786,11567602.944957487,11836375.200650785,11802226.2779488,12132818.812038178,12203224.395382503,12731341.39424053,13297617.676604174,13398060.047086379,13367491.46094097,13649534.421103036,14463916.40487176,14387146.155159205,14810008.423652843,15268672.821612058,15992200.025293903,16095313.66018413,16005778.192216657,9055635.7532963753]
["Total Operating Expenses","Flood protection and control works",16811188.330738589,20017636.123927511,20958764.511284087,22270139.396869842,23800486.199378747,24761335.482065517,26073746.771973908,27364582.065126497,27458292.178797569,27951771.549984988,28578329.217154436,29395008.162485417,29079457.979611762,29429056.50333013,29843169.524365515,30826681.017733935,31571797.16772981,32102376.278428972,32577906.193892937,32942459.040785246,32839884.463117644,33463535.846242823,33398348.060123254,33790062.849948987,34497125.552918121,34811270.292640008,35670630.48219303,35983143.903941274,36710410.619184397,37603646.984638929,38025384.125453047,38934785.161203302,38866994.430244021,22315057.888461672]
["Total Operating Expenses","Public Transport",193886289.94026121,250282459.30117011,244935221.87415612,250452542.17801791,271339562.07740217,276752825.3144148,285226467.19677758,294246112.56916529,300494763.51238465,315174720.76331329,322938585.02159995,329042228.5198431,462895371.529006,349175596.33838445,353077300.59827399,361626016.84167308,373953932.34722787,382904865.90744364,394198722.0920372,405093385.22572494,415623233.76333123,426573323.7986604,441176270.13101995,452985088.94817275,468916607.11436343,487939118.94254386,507360218.7079497,523434983.89102298,538011757.58634484,552019074.27886784,569464421.47516263,579341536.96108162,594355177.68178761,619339171.54893219]
["Total Operating Expenses","Investments.",-3459464.970308804,-4117338.9163247524,-2548169.487068112,-5445110.2399750166,-4139594.1864636997,-3913562.7340699569,-4413419.9538461426,-4426363.360767588,-3887483.8308885833,-3858955.866628598,-2483963.5094798612,-2878601.7994883833,-3488239.8882044759,-3538932.2220389689,-3535350.1598558631,-3650556.3938963427,-3707182.131449685,-3760116.0443385961,-3813946.1822671294,-3946824.8955783751,-4254070.6807219405,-5009002.110521799,-5251457.6538226185,-5321094.4287038101,-5611637.4726624461,-5929825.4559499612,-6323202.4494366255,-6712020.5366985304,-6846278.886018849,-6989145.6013652524,-7651385.4900890542,-8120168.1184282741,80199666.669899404,61468977.634187341]
["Total Operating Expenses","Regional Leadership",20299958.483800367,23520998.128868222,24829744.174689781,23791228.89586493,23564198.858791601,24364185.393069208,24409216.296262559,24932388.026200622,25974322.67532099,26023412.403142959,26656003.646269236,27209858.556825541,26660499.350896969,26717473.770509504,27247475.20516853,26613529.989389021,26526949.118001889,26969114.642506115,26099396.669358566,26294697.222292092,27534322.807035968,27300903.526135296,27978037.963764131,29174371.970144939,29107639.046286754,29701283.859081276,31057359.070184406,30892051.25037371,31575990.980244547,33158578.133559223,32802425.253308393,32501556.39780001,32485645.108293369,27613426.381266117]
[]
[null,{"$f":"+B289","v":"Regional Leadership"},20299958.483800367,23520998.128868222,24829744.174689781,23791228.89586493,23564198.858791601,24364185.393069208,24409216.296262559,24932388.026200622,25974322.67532099,26023412.403142959,26656003.646269236,27717239.916225884,27178023.707574911,27245343.754765876,27785897.488519751,27162715.364826437,27087112.581828278,27540475.477779511,26682178.53097409,26889128.223733015,28140635.608825795,27919335.426023178,28608830.988676522,29817772.969936978,29763899.789327387,30370661.129706737,31740114.768055335,31588452.491771646,32286310.201344289,33883093.195714034,33541419.550385747,33255318.965606093,33254470.73612529,28397615.725631367]
[null,{"$f":"+B287","v":"Public Transport"},193886289.94026121,250282459.30117011,244935221.87415612,250452542.17801791,271339562.07740217,276752825.3144148,285226467.19677758,294246112.56916529,300494763.51238465,315174720.76331329,322938585.02159995,331054521.95447588,343374518.46013892,352512074.00525957,352160010.84619582,360632710.59366566,372893288.1732046,381779902.35836101,392993236.02782297,403778698.75885355,414212053.06748509,425074480.46089917,439484214.36775959,451204884.82891715,467021280.15419579,485951061.84489608,505264997.95619357,521240215.64905053,535725571.29542333,549641432.07771003,566969968.45067441,576710768.43587387,591593540.01949561,616334721.23660469]
[null,{"$f":"+B282","v":"Water supply"},36229857.540192053,42658346.636397243,43525970.23355332,44646627.272138171,47197871.839910261,50716629.171376325,52032780.479061231,55245551.742619142,55537904.491886228,55568759.757717922,55291112.499118149,52247841.029931441,52854625.672223151,53356503.943443432,54458267.119895592,54777082.613277957,55605368.545798019,57835596.486760587,60771686.686619118,64183866.284123704,68809104.088525683,73199196.599035278,78338913.35667178,82755686.010635346,83880185.260598883,85049321.607252523,88204730.86542654,93303834.203687429,97741862.622844145,102552935.14262301,108016496.51767407,112523638.59525819,112799301.44716281,115007807.29425213]
[null,{"$f":"+B284","v":"Environment Management"},41187866.168540515,41655571.200312778,42430296.200025365,43797190.485272981,45061690.609441787,44662066.110805102,45316614.224628508,46222908.549668759,47123740.033158191,48037026.03284581,49001213.001265131,49610073.507507868,50492164.085348174,51508055.987373322,52682587.65826831,53570514.768286183,54647129.224764608,55589002.538996495,56601341.715738863,57666239.459076874,58883087.365426064,60239569.470263116,61459743.645794377,62768201.153420977,63976242.37516138,65108397.577785008,66475281.72153008,67477442.865947381,68888266.541822881,70316528.875605643,71629042.375170231,72683803.162797585,74617016.271356463,13078698.639046719]
[null,{"$f":"+B286","v":"Flood protection and control works"},16811188.330738589,20017636.123927511,20958764.511284087,22270139.396869842,23800486.199378747,24761335.482065517,26073746.771973908,27364582.065126497,27458292.178797569,27951771.549984988,28578329.217154436,28984829.23843779,29228015.880101107,29578207.647292893,29993083.232991677,30979690.185941968,31727199.453098603,32259255.898852732,32736493.792478878,33103000.966966867,33002643.642241277,33628792.719404303,33566086.896263257,33960432.090319678,34662651.477503799,34968818.979468338,35787817.649668343,36057237.67259299,36739518.095950022,37582109.551211551,37962241.908005916,38818762.865710385,38711755.056432173,22122326.668585401]
[null,{"$f":"+B289","v":"Regional Leadership"},20299958.483800367,23520998.128868222,24829744.174689781,23791228.89586493,23564198.858791601,24364185.393069208,24409216.296262559,24932388.026200622,25974322.67532099,26023412.403142959,26656003.646269236,27717239.916225884,27178023.707574911,27245343.754765876,27785897.488519751,27162715.364826437,27087112.581828278,27540475.477779511,26682178.53097409,26889128.223733015,28140635.608825795,27919335.426023178,28608830.988676522,29817772.969936978,29763899.789327387,30370661.129706737,31740114.768055335,31588452.491771646,32286310.201344289,33883093.195714034,33541419.550385747,33255318.965606093,33254470.73612529,28397615.725631367]
[null,{"$f":"+B285","v":"PK Parks"},8829970.6182738356,8126571.2419331083,8635749.0843386985,8866774.3101744521,8962639.7500277348,9383712.4153308552,9270916.138078928,9418259.6953324769,9513679.5868072566,9679832.0531444307,10189582.372595733,10211847.723519472,10339842.770023676,10626804.42402266,10839433.89014329,11022373.173947994,11520706.036981484,11790466.509660594,11757369.294510089,12089088.055470113,12161441.424583582,12690151.657352738,13255930.559987379,13355406.864290806,13323835.473432733,13604892.636252679,14418265.537436604,14340462.318555688,14762267.824750865,15219825.450094813,15942160.643014301,16015225.527512698,15941200.510228176,9046528.9555584881]
[null,null,null,{"$f":"SUM(D291:D297)-D296","v":386261582.63260901},385315746.07804739,393824502.5383383,419926449.33495229,430640753.88706177,442329741.10678273,457429802.64811277,466102702.47835487,482435522.56014943,492654825.75800264]
[]
[null,{"$f":"B291&\" -  6.5%\"","v":"Regional Leadership -  6.5%"},null,{"$f":"D291","v":23520998.128868222},null,{"$f":"F291","v":23791228.89586493}]
[null,{"$f":"B292&\" -  64.7%\"","v":"Public Transport -  64.7%"},null,{"$f":"D292","v":250282459.30117011},null,{"$f":"F292","v":250452542.17801791}]
[null,{"$f":"B293&\" -  10.2%\"","v":"Water supply -  10.2%"},null,{"$f":"D293","v":42658346.636397243},null,{"$f":"F293","v":44646627.272138171}]
[null,{"$f":"B294&\" -  11.2%\"","v":"Environment Management -  11.2%"},null,{"$f":"D294","v":41655571.200312778},null,{"$f":"F294","v":43797190.485272981}]
[null,{"$f":"B295&\" -  5.2%\"","v":"Flood protection and control works -  5.2%"},null,{"$f":"D295","v":20017636.123927511},null,{"$f":"F295","v":22270139.396869842}]
[null,"Park and Forests&\" -  2.2%\"",null,{"$f":"D297","v":8126571.2419331083},null,{"$f":"F297","v":8866774.3101744521}]
[]
[null,null,null,{"$f":"SUM(D300:D306)","v":386261582.63260901},{"$f":"SUM(E300:E306)","v":0}]
[]
[]
[]
[]
[null,"Regional Leadership -  6.5%",null,{"$f":"AVERAGE(D291:F291)","v":24047323.733140979},{"$f":"D312/$D$319","v":6.1903087214224044E-2}]
[null,"Public Transport -  64.7%",null,{"$f":"AVERAGE(D292:F292)","v":248556741.1177814},0.63983958438969324]
[null,"Water supply -  10.2%",null,{"$f":"AVERAGE(D293:F293)","v":43610314.71402958},0.11226251807230596]
[null,"Environment Management -  11.2%",null,{"$f":"AVERAGE(D294:F294)","v":42627685.961870372},0.10973301607785801]
[null,"Flood protection and control works -  5.2%",null,{"$f":"AVERAGE(D295:F295)","v":21082180.010693815},5.4270156727227979E-2]
[null,"Park and Forests&\" -  2.2%\"",null,{"$f":"AVERAGE(D297:F297)","v":8543031.545482086},2.1991637518690713E-2]
[]
[null,null,null,{"$f":"SUM(D312:D318)","v":388467277.08299828},{"$f":"SUM(E312:E318)","v":0.99999999999999989}]
[]
[]
[]
[null,"Regional Leadership -  6.5%",null,{"$f":"AVERAGE(D291:M291)","v":24806569.84984801},{"$f":"D323/$D$330","v":5.6936001980402877E-2}]
[null,"Public Transport -  64.7%",null,{"$f":"AVERAGE(D292:M292)","v":281184325.98084015},0.64537384401823916]
[null,"Water supply -  10.2%",null,{"$f":"AVERAGE(D293:M293)","v":50242155.412377797},0.11531571988282686]
[null,"Environment Management -  11.2%",null,{"$f":"AVERAGE(D294:M294)","v":45330831.644742437},0.10404325692430139]
[null,"Flood protection and control works -  5.2%",null,{"$f":"AVERAGE(D295:M295)","v":24923508.349656314},5.7204399050089304E-2]
[null,"Park and Forests&\" -  2.2%\"",null,{"$f":"AVERAGE(D297:M297)","v":9204771.6647763662},2.1126778144140494E-2]
[]
[null,null,null,{"$f":"SUM(D323:D329)","v":435692162.90224105},{"$f":"SUM(E323:E329)","v":1}]

{"sheet":"Debt","index":1,"n_rows":26,"n_cols":27,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
["Overview - Debt"]
[null,{"$f":"+Inflated_data!C2","v":"2017/18"},{"$f":"+Inflated_data!D2","v":"2018/19"},{"$f":"+Inflated_data!E2","v":"2019/20"},{"$f":"+Inflated_data!F2","v":"2020/21"},{"$f":"+Inflated_data!G2","v":"2021/22"},{"$f":"+Inflated_data!H2","v":"2022/23"},{"$f":"+Inflated_data!I2","v":"2023/24"},{"$f":"+Inflated_data!J2","v":"2024/25"},{"$f":"+Inflated_data!K2","v":"2025/26"},{"$f":"+Inflated_data!L2","v":"2026/27"},{"$f":"+Inflated_data!M2","v":"2027/28"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check"]
[null,"$000s","$000s","$000s","$000s","$000s","$000s","$000s","$000s","$000s","$000s","$000s",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check"]
["Public transport",{"$f":"+Inflated_data!C88","v":247206645.89702931},{"$f":"+Inflated_data!D88+Inflated_data!D87","v":279695617.91521776},{"$f":"+Inflated_data!E88+Inflated_data!E87","v":294283555.70743006},{"$f":"+Inflated_data!F88+Inflated_data!F87","v":305724679.31556952},{"$f":"+Inflated_data!G88+Inflated_data!G87","v":312282794.28631842},{"$f":"+Inflated_data!H88+Inflated_data!H87","v":328953944.47968465},{"$f":"+Inflated_data!I88+Inflated_data!I87","v":342407339.0233463},{"$f":"+Inflated_data!J88+Inflated_data!J87","v":337710913.35854769},{"$f":"+Inflated_data!K88+Inflated_data!K87","v":334576668.93661237},{"$f":"+Inflated_data!L88+Inflated_data!L87","v":320713006.47497612},{"$f":"+Inflated_data!M88+Inflated_data!M87","v":305262804.92047727},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check"]
["Flood Protection and Control Works",{"$f":"+Inflated_data!C155","v":85415017.837686315},{"$f":"+Inflated_data!D155","v":107177084.81864268},{"$f":"+Inflated_data!E155","v":122867158.94369686},{"$f":"+Inflated_data!F155","v":136092111.30819947},{"$f":"+Inflated_data!G155","v":147691539.94890341},{"$f":"+Inflated_data!H155","v":161474240.11279434},{"$f":"+Inflated_data!I155","v":175007949.89330205},{"$f":"+Inflated_data!J155","v":188257476.39254716},{"$f":"+Inflated_data!K155","v":200519471.10318667},{"$f":"+Inflated_data!L155","v":211606726.85662526},{"$f":"+Inflated_data!M155","v":214467858.67801949},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check"]
["Water supply",{"$f":"+Inflated_data!C223","v":82697198.176484123},{"$f":"+Inflated_data!D223","v":98636602.140009448},{"$f":"+Inflated_data!E223","v":108929586.60920662},{"$f":"+Inflated_data!F223","v":126923679.55184589},{"$f":"+Inflated_data!G223","v":170168593.31689101},{"$f":"+Inflated_data!H223","v":205550120.55121383},{"$f":"+Inflated_data!I223","v":241632109.73631328},{"$f":"+Inflated_data!J223","v":240347017.13935012},{"$f":"+Inflated_data!K223","v":237074172.37404069},{"$f":"+Inflated_data!L223","v":234720053.7892912},{"$f":"+Inflated_data!M223","v":235362599.33232719},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check"]
["Other",{"$f":"+Inflated_data!C19-B6-B7-B8","v":-19150477.051573336},{"$f":"+Inflated_data!D19+Inflated_data!D20-C6-C7-C8","v":-11792091.64027898},{"$f":"+Inflated_data!E19+Inflated_data!E20-D6-D7-D8","v":-2027456.3296954632},{"$f":"+Inflated_data!F19+Inflated_data!F20-E6-E7-E8","v":-1046088.9662077874},{"$f":"+Inflated_data!G19+Inflated_data!G20-F6-F7-F8","v":2623394.1400544345},{"$f":"+Inflated_data!H19+Inflated_data!H20-G6-G7-G8","v":883792.63081482053},{"$f":"+Inflated_data!I19+Inflated_data!I20-H6-H7-H8","v":-713414.37719038129},{"$f":"+Inflated_data!J19+Inflated_data!J20-I6-I7-I8","v":-1548782.0823077857},{"$f":"+Inflated_data!K19+Inflated_data!K20-J6-J7-J8","v":-3860543.9385842383},{"$f":"+Inflated_data!L19+Inflated_data!L20-K6-K7-K8","v":-5439599.3662080169},{"$f":"+Inflated_data!M19+Inflated_data!M20-L6-L7-L8","v":-6801129.6414646208},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check"]
["Closing External Debt",{"$f":"SUM(B5:B9)","v":396168384.85962641},{"$f":"SUM(C5:C9)","v":473717213.2335909},{"$f":"SUM(D5:D9)","v":524052844.93063807},567694381.20940709,632766321.69216728,696862097.77450764,758333984.27577138,764766624.80813718,768309768.47525549,761600187.75468445,748292133.28935945,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check"]
["Liquid investments",{"$f":"+Inflated_data!C22","v":88849745.053056329},{"$f":"+Inflated_data!D22","v":93821758.342469424},{"$f":"+Inflated_data!E22","v":98352337.258496493},{"$f":"+Inflated_data!F22","v":103431873.16845764},{"$f":"+Inflated_data!G22","v":109038304.03971532},{"$f":"+Inflated_data!H22","v":115118012.22383636},{"$f":"+Inflated_data!I22","v":121651975.21358342},{"$f":"+Inflated_data!J22","v":128609359.13658854},{"$f":"+Inflated_data!K22","v":135941807.65586498},{"$f":"+Inflated_data!L22","v":143628485.27536401},{"$f":"+Inflated_data!M22","v":151910065.77399853},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check"]
["External debt (less Investments)",{"$f":"+B11-B13","v":307318639.80657005},{"$f":"+C11-C13","v":379895454.89112151},{"$f":"+D11-D13","v":425700507.67214155},464262508.04094946,523728017.65245199,581744085.55067134,636682009.06218791,636157265.6715486,632367960.81939054,617971702.47932041,596382067.51536095,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check"]
["Combined Capex",{"$f":"-Inflated_data!C16+Inflated_data!C17+Inflated_data!C13","v":90478078.166065782},{"$f":"-Inflated_data!D16+Inflated_data!D17+Inflated_data!D13","v":129937773.51036382},{"$f":"-Inflated_data!E16+Inflated_data!E17+Inflated_data!E13","v":104640221.99472159},{"$f":"-Inflated_data!F16+Inflated_data!F17+Inflated_data!F13","v":108072389.31101888},{"$f":"-Inflated_data!G16+Inflated_data!G17+Inflated_data!G13","v":115519700.0304552},{"$f":"-Inflated_data!H16+Inflated_data!H17+Inflated_data!H13","v":120526053.68787278},{"$f":"-Inflated_data!I16+Inflated_data!I17+Inflated_data!I13","v":118526738.07521063},{"$f":"-Inflated_data!J16+Inflated_data!J17+Inflated_data!J13","v":67213851.406149358},{"$f":"-Inflated_data!K16+Inflated_data!K17+Inflated_data!K13","v":69409811.548804924},{"$f":"-Inflated_data!L16+Inflated_data!L17+Inflated_data!L13","v":66890451.771561503},{"$f":"-Inflated_data!M16+Inflated_data!M17+Inflated_data!M13","v":61567885.277407587},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check"]
["Net Debt peak 12-22 LTP",275000000,275000000,275000000,275000000,275000000,275000000,275000000,275000000,275000000,275000000,275000000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check"]
["Overview - Rates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check"]
[null,{"$f":"+B3","v":"2017/18"},{"$f":"+C3","v":"2018/19"},"2019/20","2020/21","2021/22","2022/23","2023/24","2024/25","2025/26","2026/27","2027/28",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check"]
[null,"$000s","$000s","$000s","$000s","$000s","$000s","$000s","$000s","$000s","$000s","$000s",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check"]
[]
["Finance Lease Adj (MK)",30888900,29424623.158926129,27893291.054522369,26291441.928282604,24615417.103927873,22861349.02338668,21025148.526153915,19102491.323045138,17088803.612146705,14979246.781333404,12768701.138068998]
["Inflated Rates",{"$f":"Inflated_data!C3-Inflated_data!C4-Inflated_data!C5","v":120779557.37835719},{"$f":"Inflated_data!D3-Inflated_data!D4-Inflated_data!D5-C1","v":128874350.32872939},{"$f":"Inflated_data!E3-Inflated_data!E4-Inflated_data!E5","v":136499325.49028963},{"$f":"Inflated_data!F3-Inflated_data!F4-Inflated_data!F5","v":145142303.31529146},{"$f":"Inflated_data!G3-Inflated_data!G4-Inflated_data!G5","v":156654063.15664247},{"$f":"Inflated_data!H3-Inflated_data!H4-Inflated_data!H5","v":167383060.28280497},{"$f":"Inflated_data!I3-Inflated_data!I4-Inflated_data!I5","v":173268152.76894134},{"$f":"Inflated_data!J3-Inflated_data!J4-Inflated_data!J5","v":179298624.35809955},{"$f":"Inflated_data!K3-Inflated_data!K4-Inflated_data!K5","v":184263199.29514128},{"$f":"Inflated_data!L3-Inflated_data!L4-Inflated_data!L5","v":192613492.61975822},{"$f":"Inflated_data!M3-Inflated_data!M4-Inflated_data!M5","v":196628389.74112296}]
["* Inflation reflects the estimated additional rates required due to the impacts of inflation on expenditure"]
["This table excludes the  Warm Wellignton Rate which is only charged to ratepayers who participate in the scheme"]

{"sheet":"Borrow Limits","index":2,"n_rows":31,"n_cols":14,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
["Overview - Ratios"]
[null,null,null,{"$f":"+Debt!B3","v":"2017/18"},{"$f":"+Debt!C3","v":"2018/19"},{"$f":"+Debt!D3","v":"2019/20"},{"$f":"+Debt!E3","v":"2020/21"},{"$f":"+Debt!F3","v":"2021/22"},{"$f":"+Debt!G3","v":"2022/23"},{"$f":"+Debt!H3","v":"2023/24"},{"$f":"+Debt!I3","v":"2024/25"},{"$f":"+Debt!J3","v":"2025/26"},{"$f":"+Debt!K3","v":"2026/27"},{"$f":"+Debt!L3","v":"2027/28"}]
[null,null,null,"$000s","$000s","$000s","$000s","$000s","$000s","$000s","$000s","$000s","$000s","$000s"]
[]
["Rates and Levies",null,null,{"$f":"Inflated_data!C3","v":154910329.88855088},{"$f":"Inflated_data!D3","v":165180306.3688778},{"$f":"Inflated_data!E3","v":174285447.99147132},{"$f":"Inflated_data!F3","v":184835883.22220033},{"$f":"Inflated_data!G3","v":198638978.55482537},{"$f":"Inflated_data!H3","v":212269853.58936787},{"$f":"Inflated_data!I3","v":221310675.84029648},{"$f":"Inflated_data!J3","v":230762194.32711747},{"$f":"Inflated_data!K3","v":236561117.08005291},{"$f":"Inflated_data!L3","v":245582118.82010174},{"$f":"Inflated_data!M3","v":249845751.36738664}]
["Total Revenue",null,null,{"$f":"Inflated_data!C9","v":343965012.92782873},{"$f":"Inflated_data!D9","v":407297637.3978141},{"$f":"Inflated_data!E9","v":420849297.36554456},{"$f":"Inflated_data!F9","v":430526895.89753997},{"$f":"Inflated_data!G9","v":438111693.89424181},{"$f":"Inflated_data!H9","v":451341923.02818757},{"$f":"Inflated_data!I9","v":464578736.79792291},{"$f":"Inflated_data!J9","v":481260923.64020032},{"$f":"Inflated_data!K9","v":494505293.90272194},{"$f":"Inflated_data!L9","v":517875865.2662133},{"$f":"Inflated_data!M9","v":528463394.59220803}]
[]
["External Interest Revenue",null,null,{"$f":"-Inflated_data!C6","v":-2943166.8398951786},{"$f":"-Inflated_data!D6","v":-2720810.4638230624},{"$f":"-Inflated_data!E6","v":-2883687.8438423518},{"$f":"-Inflated_data!F6","v":-3292574.6675652112},{"$f":"-Inflated_data!G6","v":-3952038.9664025884},{"$f":"-Inflated_data!H6","v":-4435877.1512250192},{"$f":"-Inflated_data!I6","v":-4869291.8743666802},{"$f":"-Inflated_data!J6","v":-5222229.5363614019},{"$f":"-Inflated_data!K6","v":-5481685.811656761},{"$f":"-Inflated_data!L6","v":-5752168.9786521737},{"$f":"-Inflated_data!M6","v":-6323856.1860460425}]
["Finance costs",null,null,{"$f":"+Inflated_data!C11","v":19686329.831413895},{"$f":"+Inflated_data!D11","v":22528343.738359496},{"$f":"+Inflated_data!E11","v":23712469.206757665},{"$f":"+Inflated_data!F11","v":23432043.082525887},{"$f":"+Inflated_data!G11","v":27023088.331279755},{"$f":"+Inflated_data!H11","v":30424428.522567257},{"$f":"+Inflated_data!I11","v":34017336.699965373},{"$f":"+Inflated_data!J11","v":35823044.170454077},{"$f":"+Inflated_data!K11","v":35854129.567717977},{"$f":"+Inflated_data!L11","v":35508958.61628893},{"$f":"+Inflated_data!M11","v":36233271.146146551}]
["Net Interest",null,null,{"$f":"SUM(D9:D10)","v":16743162.991518717},{"$f":"SUM(E9:E10)","v":19807533.274536435},{"$f":"SUM(F9:F10)","v":20828781.362915315},20139468.414960675,23071049.364877164,25988551.371342238,29148044.825598694,30600814.634092674,30372443.756061215,29756789.637636758,29909414.960100509]
["Finance Lease Adj (MK)",null,null,null,1412999.4156911834,1345944.1523614649,1275427.1305254474,1201251.4324104923,1123208.1762240336,1041075.7595324663,954619.05365645653,863588.54586680164,767719.42595192371,666730.61350081989]
[]
["Cash investments",null,null,{"$f":"+Inflated_data!C22","v":88849745.053056329},{"$f":"+Inflated_data!D22","v":93821758.342469424},{"$f":"+Inflated_data!E22+30000000","v":128352337.25849649},{"$f":"+Inflated_data!F22+30000000","v":133431873.16845764},{"$f":"+Inflated_data!G22+30000000","v":139038304.03971532},{"$f":"+Inflated_data!H22+30000000","v":145118012.22383636},{"$f":"+Inflated_data!I22+30000000","v":151651975.21358341},{"$f":"+Inflated_data!J22+30000000","v":158609359.13658854},{"$f":"+Inflated_data!K22+30000000","v":165941807.65586498},{"$f":"+Inflated_data!L22+30000000","v":173628485.27536401},{"$f":"+Inflated_data!M22+30000000","v":181910065.77399853}]
["Closing Debt",null,null,{"$f":"-Inflated_data!C19-Debt!B23","v":-427057284.85962641},{"$f":"-Inflated_data!D19-Debt!C23","v":-473717213.23359072},{"$f":"-Inflated_data!E19-Debt!D23","v":-524052844.9306379},{"$f":"-Inflated_data!F19-Debt!E23","v":-567694381.20940697},{"$f":"-Inflated_data!G19-Debt!F23","v":-632766321.69216704},{"$f":"-Inflated_data!H19-Debt!G23","v":-696862097.77450752},{"$f":"-Inflated_data!I19-Debt!H23","v":-758333984.27577114},{"$f":"-Inflated_data!J19-Debt!I23","v":-764766624.80813694},{"$f":"-Inflated_data!K19-Debt!J23","v":-768309768.47525537},{"$f":"-Inflated_data!L19-Debt!K23","v":-761600187.75468445},{"$f":"-Inflated_data!M19-Debt!L23","v":-748292133.28935921}]
["Net Debt",null,null,{"$f":"+D14+D15","v":-338207539.80657005},{"$f":"+E14+E15","v":-379895454.89112127},-395700507.67214143,-434262508.04094934,-493728017.65245175,-551744085.5506711,-606682009.06218767,-606157265.67154837,-602367960.81939042,-587971702.47932041,-566382067.51536071]
[]
["Facilites ($35m above ext debt)",null,null,-50000000,{"$f":"+D18","v":-50000000},-50000000,-50000000,-50000000,-50000000,-50000000,-50000000,-50000000,-50000000,-50000000]
["Total External debt + facilities",null,null,{"$f":"+D15+D18","v":-477057284.85962641},-523717213.23359072,-574052844.93063784,-617694381.20940697,-682766321.69216704,-746862097.77450752,-808333984.27577114,-814766624.80813694,-818309768.47525537,-811600187.75468445,-798292133.28935921]
[]
["Ratio",null,null,{"$f":"+D3","v":"2017/18"},{"$f":"+E3","v":"2018/19"},"2019/20","2020/21","2021/22","2022/23","2023/24","2024/25","2025/26","2026/27","2027/28"]
["Net interest / Total revenue",null,"<20%",{"$f":"D11/D7","v":4.8676936206391998E-2},{"$f":"E11/E7","v":4.8631593841508343E-2},4.9492256475894003E-2,4.6778653335873395E-2,5.2660199867767994E-2,5.7580628001443555E-2,6.2740806922201381E-2,6.3584665055770068E-2,6.1419855622488077E-2,5.7459309524571733E-2,5.65969474256212E-2]
["Net interest Limit",null,null,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2]
["Net debt / Total Revenue",null,"<250%",{"$f":"-D16/D7","v":0.98326145711085233},{"$f":"-E16/E7","v":0.93272197039550053},0.94024276658929717,1.0086768380303432,1.1269455358834486,1.2224525518233615,1.3058755405890976,1.2595189758741412,1.2181223704712998,1.1353525852707471,1.0717526952882193]
["Net debt / Total Revenue limit",null,null,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5]
["Net interest / Annual rates and levies ",null,"<30%",{"$f":"D11/D6","v":0.10808293419531458},{"$f":"E11/E6","v":0.11991461760763777},0.11950958386344782,0.10895865058166236,0.11614563029234183,0.12243166390276319,0.13170645616134977,0.13260757345163054,0.12839152998158654,0.12116838872717252,0.11971152119421112]
["Liquidity",null,">110%",{"$f":"+(D19-D14)/D15","v":1.3251314284421964},{"$f":"+(E19-E14)/E15","v":1.3036025593428262},1.3403327335854891,1.3231172955731521,1.2987489971561414,1.2799951566414123,1.2659144643321854,1.272775187056475,1.2810608644016215,1.2936297664719012,1.3099191551761518]
["Liquidity Limit",null,null,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001]
[]
[]
[null,"Net interest / Annual rates and levies (debt secured under debenture) "]

{"sheet":"Fin (capex inf 30yrs)","index":3,"n_rows":9,"n_cols":35,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
["Strategy - Capex"]
[null,{"$f":"+Inflated_data!C2","v":"2017/18"},{"$f":"+Inflated_data!D2","v":"2018/19"},{"$f":"+Inflated_data!E2","v":"2019/20"},{"$f":"+Inflated_data!F2","v":"2020/21"},{"$f":"+Inflated_data!G2","v":"2021/22"},{"$f":"+Inflated_data!H2","v":"2022/23"},{"$f":"+Inflated_data!I2","v":"2023/24"},{"$f":"+Inflated_data!J2","v":"2024/25"},{"$f":"+Inflated_data!K2","v":"2025/26"},{"$f":"+Inflated_data!L2","v":"2026/27"},{"$f":"+Inflated_data!M2","v":"2027/28"},{"$f":"+Inflated_data!N2","v":"2028/29"},{"$f":"+Inflated_data!O2","v":"2029/30"},{"$f":"+Inflated_data!P2","v":"2030/31"},{"$f":"+Inflated_data!Q2","v":"2031/32"},{"$f":"+Inflated_data!R2","v":"2032/33"},{"$f":"+Inflated_data!S2","v":"2033/34"},{"$f":"+Inflated_data!T2","v":"2034/35"},{"$f":"+Inflated_data!U2","v":"2035/36"},{"$f":"+Inflated_data!V2","v":"2036/37"},{"$f":"+Inflated_data!W2","v":"2037/38"},{"$f":"+Inflated_data!X2","v":"2038/39"},{"$f":"+Inflated_data!Y2","v":"2039/40"},{"$f":"+Inflated_data!Z2","v":"2040/41"},{"$f":"+Inflated_data!AA2","v":"2041/42"},{"$f":"+Inflated_data!AB2","v":"2042/43"},{"$f":"+Inflated_data!AC2","v":"2043/44"},{"$f":"+Inflated_data!AD2","v":"2044/45"},{"$f":"+Inflated_data!AE2","v":"2045/46"},{"$f":"+Inflated_data!AF2","v":"2046/47"},{"$f":"+Inflated_data!AG2","v":"2047/48"},{"$f":"+Inflated_data!AH2","v":"2048/49"},{"$f":"+Inflated_data!AI2","v":"2049/50"},{"$f":"+Inflated_data!AJ2","v":"2050/51"}]
["Public transport - Capex & improvements",{"$f":"+Inflated_data!C80-Inflated_data!C83+Inflated_data!C17","v":45701883.483199999},{"$f":"+Inflated_data!D80-Inflated_data!D83+Inflated_data!D17","v":79156595.530000001},{"$f":"+Inflated_data!E80-Inflated_data!E83+Inflated_data!E17","v":56678015.053248003},{"$f":"+Inflated_data!F80-Inflated_data!F83+Inflated_data!F17","v":59006562.990552396},{"$f":"+Inflated_data!G80-Inflated_data!G83+Inflated_data!G17","v":40589928.029468},{"$f":"+Inflated_data!H80-Inflated_data!H83+Inflated_data!H17","v":51495505.162017524},{"$f":"+Inflated_data!I80-Inflated_data!I83+Inflated_data!I17","v":47974064.747133069},{"$f":"+Inflated_data!J80-Inflated_data!J83+Inflated_data!J17","v":32127556.219841965},{"$f":"+Inflated_data!K80-Inflated_data!K83+Inflated_data!K17","v":38897953.063195601},{"$f":"+Inflated_data!L80-Inflated_data!L83+Inflated_data!L17","v":35624285.124580733},{"$f":"+Inflated_data!M80-Inflated_data!M83+Inflated_data!M17","v":33069825.626962543},{"$f":"+Inflated_data!N80-Inflated_data!N83+Inflated_data!N17","v":46163116.145157807},{"$f":"+Inflated_data!O80-Inflated_data!O83+Inflated_data!O17","v":23069254.692676395},{"$f":"+Inflated_data!P80-Inflated_data!P83+Inflated_data!P17","v":39818515.321438834},{"$f":"+Inflated_data!Q80-Inflated_data!Q83+Inflated_data!Q17","v":15729446.605514539},{"$f":"+Inflated_data!R80-Inflated_data!R83+Inflated_data!R17","v":20826409.68681965},{"$f":"+Inflated_data!S80-Inflated_data!S83+Inflated_data!S17","v":21427653.829464111},{"$f":"+Inflated_data!T80-Inflated_data!T83+Inflated_data!T17","v":20641524.070305467},{"$f":"+Inflated_data!U80-Inflated_data!U83+Inflated_data!U17","v":31388173.220923472},{"$f":"+Inflated_data!V80-Inflated_data!V83+Inflated_data!V17","v":35768804.027233601},{"$f":"+Inflated_data!W80-Inflated_data!W83+Inflated_data!W17","v":27525535.07216654},{"$f":"+Inflated_data!X80-Inflated_data!X83+Inflated_data!X17","v":68482395.736877725},{"$f":"+Inflated_data!Y80-Inflated_data!Y83+Inflated_data!Y17","v":34142142.849585503},{"$f":"+Inflated_data!Z80-Inflated_data!Z83+Inflated_data!Z17","v":28214260.280489318},{"$f":"+Inflated_data!AA80-Inflated_data!AA83+Inflated_data!AA17","v":262993513.78345564},{"$f":"+Inflated_data!AB80-Inflated_data!AB83+Inflated_data!AB17","v":266409064.00023898},{"$f":"+Inflated_data!AC80-Inflated_data!AC83+Inflated_data!AC17","v":273554326.27389979},{"$f":"+Inflated_data!AD80-Inflated_data!AD83+Inflated_data!AD17","v":22265681.394719414},{"$f":"+Inflated_data!AE80-Inflated_data!AE83+Inflated_data!AE17","v":32895149.491322313},{"$f":"+Inflated_data!AF80-Inflated_data!AF83+Inflated_data!AF17","v":32143236.664137982},{"$f":"+Inflated_data!AG80-Inflated_data!AG83+Inflated_data!AG17","v":37990360.046463989},{"$f":"+Inflated_data!AH80-Inflated_data!AH83+Inflated_data!AH17","v":47533775.816194355},{"$f":"+Inflated_data!AI80-Inflated_data!AI83+Inflated_data!AI17","v":75171158.497288525},{"$f":"+Inflated_data!AJ80-Inflated_data!AJ83+Inflated_data!AJ17","v":17483325.956148781}]
["Flood Protection and Control Works",{"$f":"-Inflated_data!C151","v":21302880.682865776},{"$f":"-Inflated_data!D151","v":17846007.710363809},{"$f":"-Inflated_data!E151","v":20929774.229473595},{"$f":"-Inflated_data!F151","v":19149594.293823652},{"$f":"-Inflated_data!G151","v":18030148.858236618},{"$f":"-Inflated_data!H151","v":20907744.340902153},{"$f":"-Inflated_data!I151","v":21507453.668264225},{"$f":"-Inflated_data!J151","v":21818497.390951101},{"$f":"-Inflated_data!K151","v":20295765.887429163},{"$f":"-Inflated_data!L151","v":19257516.01172182},{"$f":"-Inflated_data!M151","v":12100890.136630228},{"$f":"-Inflated_data!N151","v":14007343.935389563},{"$f":"-Inflated_data!O151","v":8393165.1466540787},{"$f":"-Inflated_data!P151","v":4371143.3055507634},{"$f":"-Inflated_data!Q151","v":11139557.794296613},{"$f":"-Inflated_data!R151","v":19432377.303813778},{"$f":"-Inflated_data!S151","v":20887973.081660375},{"$f":"-Inflated_data!T151","v":16402637.083956925},{"$f":"-Inflated_data!U151","v":11597931.069103459},{"$f":"-Inflated_data!V151","v":8730505.296501955},{"$f":"-Inflated_data!W151","v":13682257.374511028},{"$f":"-Inflated_data!X151","v":12873241.638537303},{"$f":"-Inflated_data!Y151","v":13021121.754116418},{"$f":"-Inflated_data!Z151","v":19473926.506109841},{"$f":"-Inflated_data!AA151","v":18689063.325302113},{"$f":"-Inflated_data!AB151","v":20774055.724797178},{"$f":"-Inflated_data!AC151","v":20514653.656864535},{"$f":"-Inflated_data!AD151","v":21106956.399869543},{"$f":"-Inflated_data!AE151","v":21647100.118111119},{"$f":"-Inflated_data!AF151","v":21920948.429227009},{"$f":"-Inflated_data!AG151","v":22785823.363072261},{"$f":"-Inflated_data!AH151","v":23750094.43644996},{"$f":"-Inflated_data!AI151","v":23822334.037382547},{"$f":"-Inflated_data!AJ151","v":24531201.324366622}]
["Water supply",{"$f":"-Inflated_data!C219","v":12917708},{"$f":"-Inflated_data!D219","v":14645000},{"$f":"-Inflated_data!E219","v":14732101.022},{"$f":"-Inflated_data!F219","v":23015143.799999997},{"$f":"-Inflated_data!G219","v":48542775.626320004},{"$f":"-Inflated_data!H219","v":40988634.517697036},{"$f":"-Inflated_data!I219","v":42299999.524119519},{"$f":"-Inflated_data!J219","v":5482800.2909976775},{"$f":"-Inflated_data!K219","v":3770755.5079554245},{"$f":"-Inflated_data!L219","v":4887733.5848556329},{"$f":"-Inflated_data!M219","v":8077665.7199629545},{"$f":"-Inflated_data!N219","v":8733389.2683629896},{"$f":"-Inflated_data!O219","v":8558680.9322138131},{"$f":"-Inflated_data!P219","v":12015068.217487635},{"$f":"-Inflated_data!Q219","v":9095758.819745278},{"$f":"-Inflated_data!R219","v":18262786.974032402},{"$f":"-Inflated_data!S219","v":25286150.990983225},{"$f":"-Inflated_data!T219","v":43090141.063447222},{"$f":"-Inflated_data!U219","v":42877441.393196322},{"$f":"-Inflated_data!V219","v":64982758.022181205},{"$f":"-Inflated_data!W219","v":66695433.209964253},{"$f":"-Inflated_data!X219","v":80563363.830097914},{"$f":"-Inflated_data!Y219","v":82398354.559209526},{"$f":"-Inflated_data!Z219","v":21735648.656363174},{"$f":"-Inflated_data!AA219","v":22501883.199375357},{"$f":"-Inflated_data!AB219","v":37785664.895212226},{"$f":"-Inflated_data!AC219","v":91480093.835454926},{"$f":"-Inflated_data!AD219","v":90160559.038839042},{"$f":"-Inflated_data!AE219","v":78990263.822559074},{"$f":"-Inflated_data!AF219","v":80917998.767497614},{"$f":"-Inflated_data!AG219","v":89417783.098295599},{"$f":"-Inflated_data!AH219","v":85233065.782393634},{"$f":"-Inflated_data!AI219","v":87534358.558518246},{"$f":"-Inflated_data!AJ219","v":90125802.481753901}]
["Other capex",{"$f":"+B9-B6-B5-B4","v":10555605.999999993},{"$f":"+C9-C6-C5-C4","v":18290170.270000011},12300331.689999998,6901088.2266428396,8356847.5164305791,7134169.6672560722,6745220.1356938109,7784997.504358612,6445337.0902247354,7120917.0504033193,{"$f":"+L9-L6-L5-L4","v":8319503.7938518599},8497123.9015855268,7253550.5455854088,9024881.1626874879,7100473.7710041199,7565848.8620022833,8326150.7605328746,8663013.0138402283,8561066.2945521586,7832626.4672774374,11466358.972376324,10350583.514782399,10847146.807342649,7877242.240261972,9196801.4395956695,10687873.724348575,9190127.0842932463,10415855.883373108,10894482.82910895,12123357.933621652,13207723.503746115,{"$f":"+AG9-AG6-AG5-AG4","v":15482491.581379935},7356170.5481065065,5472389.8117357641]
[]
["Total Capex and improvements",{"$f":"+Inflated_data!C13-Inflated_data!C16+Inflated_data!C17","v":90478078.166065767},{"$f":"+Inflated_data!D13-Inflated_data!D16+Inflated_data!D17","v":129937773.51036382},{"$f":"+Inflated_data!E13-Inflated_data!E16+Inflated_data!E17","v":104640221.99472159},{"$f":"+Inflated_data!F13-Inflated_data!F16+Inflated_data!F17","v":108072389.31101888},{"$f":"+Inflated_data!G13-Inflated_data!G16+Inflated_data!G17","v":115519700.0304552},{"$f":"+Inflated_data!H13-Inflated_data!H16+Inflated_data!H17","v":120526053.68787278},{"$f":"+Inflated_data!I13-Inflated_data!I16+Inflated_data!I17","v":118526738.07521063},{"$f":"+Inflated_data!J13-Inflated_data!J16+Inflated_data!J17","v":67213851.406149358},{"$f":"+Inflated_data!K13-Inflated_data!K16+Inflated_data!K17","v":69409811.548804924},{"$f":"+Inflated_data!L13-Inflated_data!L16+Inflated_data!L17","v":66890451.771561503},{"$f":"+Inflated_data!M13-Inflated_data!M16+Inflated_data!M17","v":61567885.277407587},{"$f":"+Inflated_data!N13-Inflated_data!N16+Inflated_data!N17","v":77400973.250495881},{"$f":"+Inflated_data!O13-Inflated_data!O16+Inflated_data!O17","v":47274651.317129694},{"$f":"+Inflated_data!P13-Inflated_data!P16+Inflated_data!P17","v":65229608.007164717},{"$f":"+Inflated_data!Q13-Inflated_data!Q16+Inflated_data!Q17","v":43065236.990560554},{"$f":"+Inflated_data!R13-Inflated_data!R16+Inflated_data!R17","v":66087422.826668113},{"$f":"+Inflated_data!S13-Inflated_data!S16+Inflated_data!S17","v":75927928.662640586},{"$f":"+Inflated_data!T13-Inflated_data!T16+Inflated_data!T17","v":88797315.231549844},{"$f":"+Inflated_data!U13-Inflated_data!U16+Inflated_data!U17","v":94424611.97777541},{"$f":"+Inflated_data!V13-Inflated_data!V16+Inflated_data!V17","v":117314693.8131942},{"$f":"+Inflated_data!W13-Inflated_data!W16+Inflated_data!W17","v":119369584.62901814},{"$f":"+Inflated_data!X13-Inflated_data!X16+Inflated_data!X17","v":172269584.72029534},{"$f":"+Inflated_data!Y13-Inflated_data!Y16+Inflated_data!Y17","v":140408765.97025409},{"$f":"+Inflated_data!Z13-Inflated_data!Z16+Inflated_data!Z17","v":77301077.683224306},{"$f":"+Inflated_data!AA13-Inflated_data!AA16+Inflated_data!AA17","v":313381261.74772877},{"$f":"+Inflated_data!AB13-Inflated_data!AB16+Inflated_data!AB17","v":335656658.34459698},{"$f":"+Inflated_data!AC13-Inflated_data!AC16+Inflated_data!AC17","v":394739200.8505125},{"$f":"+Inflated_data!AD13-Inflated_data!AD16+Inflated_data!AD17","v":143949052.71680111},{"$f":"+Inflated_data!AE13-Inflated_data!AE16+Inflated_data!AE17","v":144426996.26110145},{"$f":"+Inflated_data!AF13-Inflated_data!AF16+Inflated_data!AF17","v":147105541.79448426},{"$f":"+Inflated_data!AG13-Inflated_data!AG16+Inflated_data!AG17","v":163401690.01157796},{"$f":"+Inflated_data!AH13-Inflated_data!AH16+Inflated_data!AH17","v":171999427.61641788},{"$f":"+Inflated_data!AI13-Inflated_data!AI16+Inflated_data!AI17","v":193884021.64129582},{"$f":"+Inflated_data!AJ13-Inflated_data!AJ16+Inflated_data!AJ17","v":137612719.57400507}]