{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["2019-2021","2022-2028","Rate Application","Exhibit 5","ROE Summary","CVVA Summary","Check"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":106,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"2019-2021","index":0,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,2019,2020,2021,null,2021]
[null,"Regulatory Net Income",null,-912456,-2466084.91,-2543600.8800000013,null,{"$f":"-2543600.88+'CVVA Summary'!C21","v":-2422612.4327610722}]
[null,"Addback: Interest per FS","A",{"$f":"D28","v":-90},{"$f":"E28","v":-46553},{"$f":"F28","v":872882.85},null,{"$f":"H28","v":872882.85}]
[null,"Subtract: Deemed interest","B",{"$f":"-D26","v":-1404.917572799983},{"$f":"-E26","v":-623535.27474735992},{"$f":"-F26","v":-1406960.25321576},null,{"$f":"-H26","v":-1406960.25321576}]
[null,"Deemed Net Income",null,{"$f":"SUM(D3:D5)","v":-913950.91757279995},{"$f":"SUM(E3:E5)","v":-3136173.1847473602},-3077678.2832157612,null,{"$f":"SUM(H3:H5)","v":-2956689.8359768321}]
[]
[null,"Balance Sheet Equity",null,11093050.699999999,13401613.84,26531479.049999997,null,26531479.049999997]
[]
[null,"Return on Equity based on BS",null,{"$f":"D3/D8","v":-8.2254739897655027E-2},{"$f":"E3/E8","v":-0.18401402543322351},-9.5871054727346666E-2,null,{"$f":"H3/H8","v":-9.1310869936633718E-2}]
[]
[]
[null,"Opening Ratebase",null,0,{"$f":"D14","v":122039.39999999851},{"$f":"E14","v":54041900.379999995},null,{"$f":"F13","v":54041900.379999995}]
[null,"Closing Ratebase",null,{"$f":"(D32-D33)+(D34-D35)","v":122039.39999999851},{"$f":"(E32-E33)+(E34-E35)","v":54041900.379999995},68174938.849999994,null,{"$f":"(H32-H33)+(H34-H35)","v":68174938.849999994}]
[null,"Average Ratebase",null,{"$f":"AVERAGE(D13:D14)","v":61019.699999999255},{"$f":"AVERAGE(E13:E14)","v":27081969.889999997},61108419.614999995,null,{"$f":"AVERAGE(H13:H14)","v":61108419.614999995}]
[]
[null,"Equity",null,0.36,0.36,0.36,null,0.36]
[null,"ST - 1.76%",null,0.04,0.04,0.04,null,0.04]
[null,"LTD - 3.72%",null,0.6,0.6,0.6,null,0.6]
[null,"Weighted Debt",null,{"$f":"D18*1.76%/64%+(D19*3.72%/64%)","v":3.5975E-2},{"$f":"E18*1.76%/64%+(E19*3.72%/64%)","v":3.5975E-2},3.5975E-2,null,{"$f":"H18*1.76%/64%+(H19*3.72%/64%)","v":3.5975E-2}]
[]
[null,"Equity Ratebase",null,{"$f":"D15*D17","v":21967.091999999731},{"$f":"E15*E17","v":9749509.1603999976},21999031.061399996,null,{"$f":"H15*H17","v":21999031.061399996}]
[null,"Debt Ratebase",null,{"$f":"D15*(D19+D18)","v":39052.607999999527},{"$f":"E15*(E19+E18)","v":17332460.729599997},{"$f":"F15*(F19+F18)","v":39109388.553599998},null,{"$f":"H15*(H19+H18)","v":39109388.553599998}]
[null,null,null,{"$f":"SUM(D22:D23)","v":61019.699999999255},{"$f":"SUM(E22:E23)","v":27081969.889999993},61108419.614999995,null,{"$f":"SUM(H22:H23)","v":61108419.614999995}]
[]
[null,"Deemed Interest","B",{"$f":"D20*D23","v":1404.917572799983},{"$f":"E20*E23","v":623535.27474735992},{"$f":"F20*F23","v":1406960.25321576},null,{"$f":"H20*H23","v":1406960.25321576}]
[]
[null,"LT & ST interest per statements","A",-90,-46553,{"$f":"844997.85+27885","v":872882.85},null,{"$f":"844997.85+27885","v":872882.85}]
[]
[null,"Return on Equity based on deemed equity",null,{"$f":"D6/D22","v":-41.605457726166534},{"$f":"E6/E22","v":-0.32167498210942663},-0.1399006290152445,null,{"$f":"H6/H22","v":-0.13440091191855752}]
[]
[null,"PP&E & intangibles per FS",null,38974880.979999997,73465690.219999999,93648611.379999995,null,93648611.379999995]
[null,"CWIP",null,38852841.579999998,6441862,7412824,null,7412824]
[null,"Deferred Revenue per FS",null,-5180212.62,-23276572,-22443427,null,-22443427]
[null,"CWIP",null,-5180212.62,-10294644.16,-4382578.47,null,-4382578.47]

{"sheet":"2022-2028","index":1,"n_rows":66,"n_cols":23,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
["WITHOUT CVVA",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},2022,2023,2024,2025,2026,2027,2028,null,"WITH CVVA",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},2022,2023,2024,2025,2026,2027,2028]
[]
["Income Statement",null,null,null,null,null,null,null,null,null,null,null,"Income Statement"]
["Non-distribution Revenue",318.87926475446204,1273.1955389395298,2046.5599350801338,2677.6682705582916,3093.303447811254,3390.6540544822051,3497.3477698779989,3543.6050403359959,3587.933854427657,3627.3502319756631,null,"Non-distribution Revenue",318.87926475446204,1273.1955389395298,2046.5599350801338,2677.6682705582916,3093.303447811254,3390.6540544822051,3497.3477698779989,3543.6050403359959,3587.933854427657,3627.3502319756631]
["Less: Non-distribution Cost",-318.87926475446204,-1273.1955389395298,-2046.5599350801335,-2677.6682705582912,-3093.3034478112545,-3390.6540544822037,-3497.3477698779984,-3543.6050403359955,-3587.9338544276579,-3627.3502319756631,null,"Less: Non-distribution Cost",-318.87926475446204,-1273.1955389395298,-2046.5599350801335,-2677.6682705582912,-3093.3034478112545,-3390.6540544822037,-3497.3477698779984,-3543.6050403359955,-3587.9338544276579,-3627.3502319756631]
["Net Non-distribution Revenue",{"$f":"SUM(B4:B5)","v":0},0,0,0,0,0,0,0,0,0,null,"Net Non-distribution Revenue",{"$f":"SUM(N4:N5)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Distribution Revenue",null,null,null,null,null,null,null,null,null,null,null,"Distribution Revenue"]
["Rate 1",315.79079230606334,1609.0504368403242,2863.9280272904416,{"$f":"('CVVA Summary'!D3+'CVVA Summary'!D6+'CVVA Summary'!D9)/1000","v":1903.5044943694697},{"$f":"('CVVA Summary'!E3+'CVVA Summary'!E6+'CVVA Summary'!E9)/1000","v":3111.8875927426852},{"$f":"('CVVA Summary'!F3+'CVVA Summary'!F6+'CVVA Summary'!F9)/1000","v":4227.2522730543669},{"$f":"('CVVA Summary'!G3+'CVVA Summary'!G6+'CVVA Summary'!G9)/1000","v":4699.6168854823163},{"$f":"('CVVA Summary'!H3+'CVVA Summary'!H6+'CVVA Summary'!H9)/1000","v":4803.8794635394534},{"$f":"('CVVA Summary'!I3+'CVVA Summary'!I6+'CVVA Summary'!I9)/1000","v":4920.3319149352237},{"$f":"('CVVA Summary'!J3+'CVVA Summary'!J6+'CVVA Summary'!J9)/1000","v":5029.3082107536684},null,"Rate 1",315.79079230606334,1609.0504368403242,2863.9280272904416,{"$f":"('CVVA Summary'!D4+'CVVA Summary'!D7+'CVVA Summary'!D10)/1000","v":2397.9161744025655},{"$f":"('CVVA Summary'!E4+'CVVA Summary'!E7+'CVVA Summary'!E10)/1000","v":3920.896749124237},{"$f":"('CVVA Summary'!F4+'CVVA Summary'!F7+'CVVA Summary'!F10)/1000","v":5357.3867290343887},{"$f":"('CVVA Summary'!G4+'CVVA Summary'!G7+'CVVA Summary'!G10)/1000","v":5976.6144998221089},{"$f":"('CVVA Summary'!H4+'CVVA Summary'!H7+'CVVA Summary'!H10)/1000","v":6108.7899703739067},{"$f":"('CVVA Summary'!I4+'CVVA Summary'!I7+'CVVA Summary'!I10)/1000","v":6255.9935177715988},{"$f":"('CVVA Summary'!J4+'CVVA Summary'!J7+'CVVA Summary'!J10)/1000","v":6395.5136051158515}]
["Rate 6",57.80412219547523,234.47365323515845,468.6701682339687,{"$f":"('CVVA Summary'!D12+'CVVA Summary'!D15)/1000","v":231.49774078289175},{"$f":"('CVVA Summary'!E12+'CVVA Summary'!E15)/1000","v":399.25344444141263},{"$f":"('CVVA Summary'!F12+'CVVA Summary'!F15)/1000","v":544.5087518497412},{"$f":"('CVVA Summary'!G12+'CVVA Summary'!G15)/1000","v":545.294703428606},{"$f":"('CVVA Summary'!H12+'CVVA Summary'!H15)/1000","v":553.21656792205647},{"$f":"('CVVA Summary'!I12+'CVVA Summary'!I15)/1000","v":562.23165512403352},{"$f":"('CVVA Summary'!J12+'CVVA Summary'!J15)/1000","v":670.36879814829967},null,"Rate 6",57.80412219547523,234.47365323515845,468.6701682339687,{"$f":"('CVVA Summary'!D13+'CVVA Summary'!D16)/1000","v":156.1138250791721},{"$f":"('CVVA Summary'!E13+'CVVA Summary'!E16)/1000","v":405.14077025759747},{"$f":"('CVVA Summary'!F13+'CVVA Summary'!F16)/1000","v":548.67484071819149},{"$f":"('CVVA Summary'!G13+'CVVA Summary'!G16)/1000","v":563.89811829266739},{"$f":"('CVVA Summary'!H13+'CVVA Summary'!H16)/1000","v":572.08934815755742},{"$f":"('CVVA Summary'!I13+'CVVA Summary'!I16)/1000","v":581.67589063743912},{"$f":"('CVVA Summary'!J13+'CVVA Summary'!J16)/1000","v":687.36000591043035}]
["Rate 11",26.17873339468413,54.261951417593224,121.39448684889666,207.25711828189452,231.1143725749975,292.7885615877006,297.16941553032501,301.615948111428,306.12914399829344,310.71000262053394,null,"Rate 11",26.17873339468413,54.261951417593224,121.39448684889666,207.25711828189452,231.1143725749975,292.7885615877006,297.16941553032501,301.615948111428,306.12914399829344,310.71000262053394]
["Rate 16",189.58380930806595,1151.9491421176701,1166.5788962225645,1181.3944482045908,1475.8263637797986,1495.4967780885277,1515.4620951826564,1535.7267363037233,1556.2951889774058,1577.1720080072625,null,"Rate 16",189.58380930806595,1151.9491421176701,1166.5788962225645,1181.3944482045908,1475.8263637797986,1495.4967780885277,1515.4620951826564,1535.7267363037233,1556.2951889774058,1577.1720080072625]
["Total Distribution Revenue",{"$f":"SUM(B9:B12)","v":589.35745720428872},{"$f":"SUM(C9:C12)","v":3049.7351836107464},4620.571578595871,3523.6538016388472,5218.0817735388937,6560.0463645803356,7057.5430996239038,7194.4387158766613,7344.9879030349566,7587.5590195297646,null,"Total Distribution Revenue",{"$f":"SUM(N9:N12)","v":589.35745720428872},{"$f":"SUM(O9:O12)","v":3049.7351836107464},4620.571578595871,3942.6815659682234,6032.9782557366307,7694.3469094288084,8353.1441288277565,8518.2220029466152,8700.0937413847369,8970.7556216540779]
[]
["Less: Distribution O&M",-555.34957334659305,-1442.8862210751663,-1715.4280713511516,-1813.2549083450426,-1894.8909293396111,-2067.255337024063,-2103.1564577674349,-2136.7368221419506,-2170.608204842858,-2460.716292267899,null,"Less: Distribution O&M",-555.34957334659305,-1442.8862210751663,-1715.4280713511516,-1813.2549083450426,-1894.8909293396111,-2067.255337024063,-2103.1564577674349,-2136.7368221419506,-2170.608204842858,-2460.716292267899]
["Property Taxes",-331.21868117170538,-490.17623927389241,-546.70121917476592,-565.32438303426841,-581.58689612004218,-590.05543848634511,-623.740951711972,-626.27688618403852,-628.75961726743731,-630.02476084022021,null,"Property Taxes",-331.21868117170538,-490.17623927389241,-546.70121917476592,-565.32438303426841,-581.58689612004218,-590.05543848634511,-623.740951711972,-626.27688618403852,-628.75961726743731,-630.02476084022021]
["EBITDA",{"$f":"SUM(B13:B16)+B6","v":-297.21079731400971},{"$f":"SUM(C13:C16)+C6","v":1116.6727232616877},2358.4422880699535,1145.0745102595361,2741.6039480792406,3902.7355890699273,4330.6456901444963,4431.4250075506725,4545.6200809246611,4496.817966421645,null,"EBITDA",{"$f":"SUM(N13:N16)+N6","v":-297.21079731400971},{"$f":"SUM(O13:O16)+O6","v":1116.6727232616877},2358.4422880699535,1564.1022745889122,3556.5004302769776,5037.0361339184001,5626.2467193483499,5755.2082946206256,5900.7259192744414,5880.0145685459584]
[]
["Less: Depreciation",-691.59075188952829,-1326.5202759774097,-1709.4101848011926,-1778.3644763652239,-1826.1573494465777,-1860.6678506872286,-1878.2673119835229,-1888.2338572473548,-1925.3781532291621,-1934.1999034804492,null,"Less: Depreciation",-691.59075188952829,-1326.5202759774097,-1709.4101848011926,-1778.3644763652239,-1826.1573494465777,-1860.6678506872286,-1878.2673119835229,-1888.2338572473548,-1925.3781532291621,-1934.1999034804492]
["Less; Depreciation (Out of CIP Scope)",null,null,null,{"$f":"E51*E66","v":-28.136663910379301},{"$f":"F51*F66","v":-96.94875577364769},-208.18019128733667,-300.76917041029327,-343.79984495085552,-395.6374786958919,-452.19953408876819,null,"Less; Depreciation (Out of CIP Scope)",null,null,null,{"$f":"E20","v":-28.136663910379301},{"$f":"F20","v":-96.94875577364769},-208.18019128733667,-300.76917041029327,-343.79984495085552,-395.6374786958919,-452.19953408876819]
["Add: Capitalized IDC",650.51563192223,180.13277853046256,45.190147077752435,26.769041156253962,23.558037530176222,13.029480263344169,6.1678630498306406,5.1423156697694248,12.530688619247645,2.9388122668529215,null,"Add: Capitalized IDC",650.51563192223,180.13277853046256,45.190147077752435,26.769041156253962,23.558037530176222,13.029480263344169,6.1678630498306406,5.1423156697694248,12.530688619247645,2.9388122668529215]
["EBIT",{"$f":"SUM(B19:B21)+B17","v":-338.285917281308},-29.714774185259557,694.22225034651342,-634.65758885981336,842.05588038919154,1846.9170273587065,2157.7770708005105,2204.5336210222313,2237.1351376188545,2113.3573411192806,null,"EBIT",{"$f":"SUM(N19:N21)+N17","v":-338.285917281308},-29.714774185259557,694.22225034651342,-215.62982453043719,1656.9523625869285,2981.2175722071793,3453.3781000043641,3528.3169080921843,3592.2409759686348,3496.5539432435939]
[]
["Less: Interest Expense",-563.51469447392287,-1248.3448819323614,-1385.8300439496243,-1403.2090415624027,-1401.933455414666,-1388.9112589451249,-1361.1766344787241,-1326.7983343563717,-1296.8476121699189,-1265.0774750282249,null,"Less: Interest Expense",-563.51469447392287,-1248.3448819323614,-1385.8300439496243,-1403.2090415624027,-1401.933455414666,-1388.9112589451249,-1361.1766344787241,-1326.7983343563717,-1296.8476121699189,-1265.0774750282249]
["Less: Cash Tax",0,0,0,0,0,0,0,0,0,0,null,"Less: Cash Tax",0,0,0,0,0,0,0,0,0,0]
["Net Income",{"$f":"SUM(B24:B25)+B22","v":-901.80061175523088},-1278.059656117621,-691.60779360311085,-2037.8666304222161,-559.87757502547447,458.00576841358156,796.60043632178645,877.73528666585958,940.28752544893564,848.27986609105574,null,"Net Income",{"$f":"SUM(N24:N25)+N22","v":-901.80061175523088},-1278.059656117621,-691.60779360311085,-1618.8388660928399,255.01890717226252,1592.3063132620543,2092.2014655256398,2201.5185737358124,2295.3933637987157,2231.4764682153691]
[]
["Balance Sheet",null,null,null,null,null,null,null,null,null,null,null,"Balance Sheet"]
["Cash",0,2.9103830456733704E-11,1.4551915228366852E-11,2.5011104298755527E-12,2.5011104298755527E-12,-1.3415046851150692E-11,7.0485839387401938E-12,1.7507773009128869E-11,-1.2960299500264227E-11,1.3869794202037156E-11,null,"Cash",0,2.9103830456733704E-11,1.4551915228366852E-11,2.5011104298755527E-12,2.5011104298755527E-12,-1.3415046851150692E-11,7.0485839387401938E-12,1.7507773009128869E-11,-1.2960299500264227E-11,1.3869794202037156E-11]
["NWC",180.81712789091404,300.12157200237419,346.18181183853341,412.2553224521069,423.21186853852925,483.98285596036243,449.65392094324835,496.33889135604926,461.75636012464366,545.95733263792363,null,"NWC",180.81712789091404,300.12157200237419,346.18181183853341,412.2553224521069,423.21186853852925,483.98285596036243,449.65392094324835,496.33889135604926,461.75636012464366,545.95733263792363]
["PP&E",57313.200113579209,80778.907960518045,81547.531545041857,80996.598733986597,80179.879194981244,78613.869275272285,76564.427225982377,74435.394597087958,72770.8115936213,70446.217883123201,null,"PP&E",57313.200113579209,80778.907960518045,81547.531545041857,80996.598733986597,80179.879194981244,78613.869275272285,76564.427225982377,74435.394597087958,72770.8115936213,70446.217883123201]
["Assets",{"$f":"SUM(B29:B31)","v":57494.017241470123},81079.02953252045,81893.713356880398,81408.854056438708,80603.09106351978,79097.852131232634,77014.08114692563,74931.733488444021,73232.567953745936,70992.175215761134,null,"Assets",{"$f":"SUM(N29:N31)","v":57494.017241470123},81079.02953252045,81893.713356880398,81408.854056438708,80603.09106351978,79097.852131232634,77014.08114692563,74931.733488444021,73232.567953745936,70992.175215761134]
[]
["Deferred Revenue",61.463363703984385,477.16100833388731,825.57112250829266,1033.6489050756416,1136.7888397346794,1126.2307580731608,1079.3550988577324,1032.8530535282343,986.8378888111522,939.84560839157348,null,"Deferred Revenue",61.463363703984385,477.16100833388731,825.57112250829266,1033.6489050756416,1136.7888397346794,1126.2307580731608,1079.3550988577324,1032.8530535282343,986.8378888111522,939.84560839157348]
["Assets and Regulatory Assets",{"$f":"B32+B34","v":57555.480605174111},81556.190540854339,82719.284479388691,82442.502961514343,81739.879903254463,80224.082889305791,78093.436245783363,75964.586541972254,74219.405842557084,71932.020824152714,null,"Assets and Regulatory Assets",{"$f":"N32+N34","v":57555.480605174111},81556.190540854339,82719.284479388691,82442.502961514343,81739.879903254463,80224.082889305791,78093.436245783363,75964.586541972254,74219.405842557084,71932.020824152714]
[]
["Contribution from Grant",8543.8179299757794,21590.653276575438,21000.744585929548,20410.835895283657,19820.92720463777,19231.018513991876,18641.109823345989,18051.201132700098,17461.292442054211,16871.383751408321,null,"Contribution from Grant",8543.8179299757794,21590.653276575438,21000.744585929548,20410.835895283657,19820.92720463777,19231.018513991876,18641.109823345989,18051.201132700098,17461.292442054211,16871.383751408321]
["ST Operating Debt",1958.0079724597731,2379.5350502377996,2435.7187508380339,2439.9207264462011,2431.2865543552798,2394.6733446896296,2334.9188529431854,2275.2212942297565,2230.8510204676681,2164.8316585741127,null,"ST Operating Debt",1958.0079724597731,2379.5350502377996,2435.7187508380339,2439.9207264462011,2431.2865543552798,2394.6733446896296,2334.9188529431854,2275.2212942297565,2230.8510204676681,2164.8316585741127]
["LT Debt",29431.582950600579,36170.186761900884,37361.352385078797,37632.459801768659,37606.087155063869,37046.330928417599,36103.137893005507,35161.172466974582,34449.603195826174,33412.320487003264,null,"LT Debt",29431.582950600579,36170.186761900884,37361.352385078797,37632.459801768659,37606.087155063869,37046.330928417599,36103.137893005507,35161.172466974582,34449.603195826174,33412.320487003264]
["Liabilities",{"$f":"SUM(B37:B39)","v":39933.408853036133},60140.375088714121,60797.815721846375,60483.216423498518,59858.300914056919,58672.022787099108,57079.166569294684,55487.594893904432,54141.746658348056,52448.535896985697,null,"Liabilities",{"$f":"SUM(N37:N39)","v":39933.408853036133},60140.375088714121,60797.815721846375,60483.216423498518,59858.300914056919,58672.022787099108,57079.166569294684,55487.594893904432,54141.746658348056,52448.535896985697]
[]
["Retained Earnings",-901.80061175523088,-2179.8602678728521,-2871.4680614759632,-2586.5867142588163,-1621.8752276857761,-326.07347737471719,1168.3267996630987,2789.1291762930591,4506.7940884431455,6065.9446308967945,null,"Retained Earnings",-901.80061175523088,-2179.8602678728521,-2871.4680614759632,-2586.5867142588163,-1621.8752276857761,-326.07347737471719,1168.3267996630987,2789.1291762930591,4506.7940884431455,6065.9446308967945]
["Share Capital",18523.872363893188,23595.675720013049,24792.936819018265,24545.873252274629,23503.454216883292,21878.133579581383,19845.942876825568,17687.862471774748,15570.865095765868,13417.540296270219,null,"Share Capital",18523.872363893188,23595.675720013049,24792.936819018265,24545.873252274629,23503.454216883292,21878.133579581383,19845.942876825568,17687.862471774748,15570.865095765868,13417.540296270219]
["Equities",{"$f":"SUM(B42:B43)","v":17622.071752137956},21415.815452140196,21921.468757542301,21959.286538015811,21881.578989197515,21552.060102206666,21014.269676488668,20476.991648067808,20077.659184209013,19483.484927167014,null,"Equities",{"$f":"SUM(N42:N43)","v":17622.071752137956},21415.815452140196,21921.468757542301,21959.286538015811,21881.578989197515,21552.060102206666,21014.269676488668,20476.991648067808,20077.659184209013,19483.484927167014]
[]
["Liabilities and Equities",{"$f":"B40+B44","v":57555.480605174089},81556.190540854324,82719.284479388676,82442.502961514328,81739.879903254434,80224.082889305777,78093.436245783349,75964.58654197224,74219.405842557069,71932.020824152714,null,"Liabilities and Equities",{"$f":"N40+N44","v":57555.480605174089},81556.190540854324,82719.284479388676,82442.502961514328,81739.879903254434,80224.082889305777,78093.436245783349,75964.58654197224,74219.405842557069,71932.020824152714]
[]
[]
["ROE Calculation",null,null,null,null,null,null,null,null,null,null,null,"ROE Calculation"]
["Net Fixed Assets (CIP)",{"$f":"B31","v":57313.200113579209},{"$f":"C31","v":80778.907960518045},81547.531545041857,80996.598733986597,80179.879194981244,78613.869275272285,76564.427225982377,74435.394597087958,72770.8115936213,70446.217883123201,null,{"$f":"A50","v":"Net Fixed Assets (CIP)"},{"$f":"N31","v":57313.200113579209},{"$f":"O31","v":80778.907960518045},81547.531545041857,80996.598733986597,80179.879194981244,78613.869275272285,76564.427225982377,74435.394597087958,72770.8115936213,70446.217883123201]
["Net Fixed Assets (Out of CIP Scope)",{"$f":"B19","v":-691.59075188952829},{"$f":"C19","v":-1326.5202759774097},-1709.4101848011926,1281.5,4256.6647000000003,8795.6860960000013,12260.352460363751,13552.811280823376,14953.353642902464,16469.728308714166,null,{"$f":"A51","v":"Net Fixed Assets (Out of CIP Scope)"},{"$f":"N19","v":-691.59075188952829},{"$f":"O19","v":-1326.5202759774097},-1709.4101848011926,{"$f":"E51","v":1281.5},{"$f":"F51","v":4256.6647000000003},8795.6860960000013,12260.352460363751,13552.811280823376,14953.353642902464,16469.728308714166]
["Accumulated Depreciation (Out of CIP Scope)",null,null,null,{"$f":"E20","v":-28.136663910379301},{"$f":"SUM($E$20:F20)","v":-125.08541968402699},{"$f":"SUM($E$20:G20)","v":-333.26561097136369},{"$f":"SUM($E$20:H20)","v":-634.03478138165701},{"$f":"SUM($E$20:I20)","v":-977.83462633251247},{"$f":"SUM($E$20:J20)","v":-1373.4721050284043},{"$f":"SUM($E$20:K20)","v":-1825.6716391171724},null,"Accumulated Depreciation (Out of CIP Scope)",null,null,null,{"$f":"Q20","v":-28.136663910379301},{"$f":"SUM($Q$20:R20)","v":-125.08541968402699},{"$f":"SUM($Q$20:S20)","v":-333.26561097136369},{"$f":"SUM($Q$20:T20)","v":-634.03478138165701},{"$f":"SUM($Q$20:U20)","v":-977.83462633251247},{"$f":"SUM($Q$20:V20)","v":-1373.4721050284043},{"$f":"SUM($Q$20:W20)","v":-1825.6716391171724}]
["Contribution from Grant",{"$f":"-B37","v":-8543.8179299757794},{"$f":"-C37","v":-21590.653276575438},{"$f":"-D37","v":-21000.744585929548},{"$f":"-E37","v":-20410.835895283657},{"$f":"-F37","v":-19820.92720463777},{"$f":"-G37","v":-19231.018513991876},{"$f":"-H37","v":-18641.109823345989},{"$f":"-I37","v":-18051.201132700098},{"$f":"-J37","v":-17461.292442054211},{"$f":"-K37","v":-16871.383751408321},null,"Contribution from Grant",{"$f":"-N37","v":-8543.8179299757794},{"$f":"-O37","v":-21590.653276575438},{"$f":"-P37","v":-21000.744585929548},{"$f":"-Q37","v":-20410.835895283657},{"$f":"-R37","v":-19820.92720463777},{"$f":"-S37","v":-19231.018513991876},{"$f":"-T37","v":-18641.109823345989},{"$f":"-U37","v":-18051.201132700098},{"$f":"-V37","v":-17461.292442054211},{"$f":"-W37","v":-16871.383751408321}]
["Net Fixed Assets (Total)",{"$f":"B50+B51+B53","v":48077.791431713908},{"$f":"C50+C51+C53","v":57861.734407965196},{"$f":"D50+D51+D53","v":58837.376774311117},{"$f":"E50+E51+E53+E52","v":61839.12617479256},{"$f":"F50+F51+F53+F52","v":64490.531270659434},67845.271246309057,69549.635081618471,68959.170118878726,68889.400689441158,68218.890801311878,null,"Net Fixed Assets",{"$f":"N50+N51+N53","v":48077.791431713908},{"$f":"O50+O51+O53","v":57861.734407965196},{"$f":"P50+P51+P53","v":58837.376774311117},{"$f":"Q50+Q51+Q53+Q52","v":61839.12617479256},{"$f":"R50+R51+R53+R52","v":64490.531270659434},67845.271246309057,69549.635081618471,68959.170118878726,68889.400689441158,68218.890801311878]
["Allowance for Working Captial",{"$f":"B30","v":180.81712789091404},{"$f":"C30","v":300.12157200237419},{"$f":"D30","v":346.18181183853341},{"$f":"E30","v":412.2553224521069},{"$f":"F30","v":423.21186853852925},{"$f":"G30","v":483.98285596036243},{"$f":"H30","v":449.65392094324835},{"$f":"I30","v":496.33889135604926},{"$f":"J30","v":461.75636012464366},{"$f":"K30","v":545.95733263792363},null,"Allowance for Working Captial",{"$f":"N30","v":180.81712789091404},{"$f":"O30","v":300.12157200237419},{"$f":"P30","v":346.18181183853341},{"$f":"Q30","v":412.2553224521069},{"$f":"R30","v":423.21186853852925},{"$f":"S30","v":483.98285596036243},{"$f":"T30","v":449.65392094324835},{"$f":"U30","v":496.33889135604926},{"$f":"V30","v":461.75636012464366},{"$f":"W30","v":545.95733263792363}]
["Rate Base",{"$f":"SUM(B54:B55)","v":48258.608559604821},{"$f":"SUM(C54:C55)","v":58161.855979967571},59183.558586149651,62251.381497244663,64913.743139197963,68329.25410226942,69999.289002561723,69455.509010234775,69351.157049565794,68764.848133949796,null,"Rate Base",{"$f":"SUM(N54:N55)","v":48258.608559604821},{"$f":"SUM(O54:O55)","v":58161.855979967571},59183.558586149651,62251.381497244663,64913.743139197963,68329.25410226942,69999.289002561723,69455.509010234775,69351.157049565794,68764.848133949796]
[]
["Net Income (After Interest Expense)",{"$f":"B26","v":-901.80061175523088},{"$f":"C26","v":-1278.059656117621},{"$f":"D26","v":-691.60779360311085},{"$f":"E26","v":-2037.8666304222161},{"$f":"F26","v":-559.87757502547447},{"$f":"G26","v":458.00576841358156},{"$f":"H26","v":796.60043632178645},{"$f":"I26","v":877.73528666585958},{"$f":"J26","v":940.28752544893564},{"$f":"K26","v":848.27986609105574},null,"Net Income (After Interest Expense)",{"$f":"N26","v":-901.80061175523088},{"$f":"O26","v":-1278.059656117621},{"$f":"P26","v":-691.60779360311085},{"$f":"Q26","v":-1618.8388660928399},{"$f":"R26","v":255.01890717226252},{"$f":"S26","v":1592.3063132620543},{"$f":"T26","v":2092.2014655256398},{"$f":"U26","v":2201.5185737358124},{"$f":"V26","v":2295.3933637987157},{"$f":"W26","v":2231.4764682153691}]
[]
[]
["ROE WACC Allocation (36%)",{"$f":"B56*0.36","v":17373.099081457734},{"$f":"C56*0.36","v":20938.268152788325},21306.081091013875,22410.497339008078,23368.947530111265,24598.531476816992,25199.744040922218,25003.983243684517,24966.416537843685,24755.345328221927,null,"ROE WACC Allocation (36%)",{"$f":"N56*0.36","v":17373.099081457734},{"$f":"O56*0.36","v":20938.268152788325},21306.081091013875,22410.497339008078,23368.947530111265,24598.531476816992,25199.744040922218,25003.983243684517,24966.416537843685,24755.345328221927]
["ROE%",{"$f":"B58/B61","v":-5.1907872483022928E-2},{"$f":"C58/C61","v":-6.1039415809918514E-2},-3.2460582058650177E-2,-9.0933574547454252E-2,-2.3958185292857679E-2,1.8619232162100059E-2,3.1611449506319424E-2,3.5103818384119141E-2,3.7662093958244394E-2,3.426653334235609E-2,null,"ROE%",{"$f":"N58/N61","v":-5.1907872483022928E-2},{"$f":"O58/O61","v":-6.1039415809918514E-2},-3.2460582058650177E-2,-7.2235740314208138E-2,1.0912725395256527E-2,6.473176314458981E-2,8.3024710970400512E-2,8.8046714488655323E-2,9.1939240071533535E-2,9.0141197330477582E-2]
[]
[]
[]
[null,null,null,null,{"$f":"E19/E50","v":-2.1956038946842997E-2},{"$f":"F19/F50","v":-2.277575581032908E-2},-2.3668442576868495E-2,-2.4531853499533879E-2,-2.5367419189059097E-2,-2.6458110210192166E-2,-2.7456405206727576E-2,null,null,null,null,null,{"$f":"Q19/Q50","v":-2.1956038946842997E-2},{"$f":"R19/R50","v":-2.277575581032908E-2},-2.3668442576868495E-2,-2.4531853499533879E-2,-2.5367419189059097E-2,-2.6458110210192166E-2,-2.7456405206727576E-2]

{"sheet":"Rate Application","index":2,"n_rows":65,"n_cols":11,"rows_kept":65,"cut":false,"hidden":true,"merged":[]}
[null,2019,{"$f":"B1+1","v":2020},2021,2022,2023,2024,2025,2026,2027,2028]
["CVVA Adjustment",0,0,73.538775609914282,127.16885902898944,835.17476677424713,1146.5140593072476,1360.9527747311838,1389.1660789291225,1421.5516709214805,1456.3246177869496]
[]
[]
[]
["NON-ADJUSTED",{"$f":"B1","v":2019},{"$f":"C1","v":2020},2021,2022,2023,2024,2025,2026,2027,2028]
[]
["Income Statement"]
["Non-distribution Revenue",318.87926475446204,1273.1955389395298,2046.5599350801338,2677.6682705582916,3093.303447811254,3390.6540544822051,3497.3477698779989,3543.6050403359959,3587.933854427657,3627.3502319756631]
["Less: Non-distribution Cost",-318.87926475446204,-1273.1955389395298,-2046.5599350801335,-2677.6682705582912,-3093.3034478112545,-3390.6540544822037,-3497.3477698779984,-3543.6050403359955,-3587.9338544276579,-3627.3502319756631]
["Net Non-distribution Revenue",{"$f":"SUM(B9:B10)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Distribution Revenue"]
["Rate 1",315.79079230606334,1609.0504368403242,2863.9280272904416,3717.5597788973419,4348.8942776394188,4795.0336973736703,5001.9713676854717,5109.9555081372409,5211.4337275375901,5298.9918434404808]
["Rate 6",57.80412219547523,234.47365323515845,468.6701682339687,712.05376998400288,873.29035107639368,953.01208154562971,992.67749799434523,1005.2845022188733,1018.0516153970528,1030.9808709125955]
["Rate 11",26.17873339468413,54.261951417593224,121.39448684889666,207.25711828189452,227.13929295115895,230.02396197163864,232.94526628867848,235.90367117054464,238.89964779441055,241.93367332139951]
["Rate 16",189.58380930806595,1151.9491421176701,1166.5788962225645,1181.3944482045908,1196.3981576967892,1211.5924142995384,1226.9796379611425,1242.5622793632488,1258.3428203111623,1274.3237741291139]
["Total Distribution Revenue",{"$f":"SUM(B14:B17)","v":589.35745720428872},{"$f":"SUM(C14:C17)","v":3049.7351836107464},4620.571578595871,5818.2651153678307,6645.7220793637607,7189.6621551904764,7454.5737699296387,7593.7059608899071,7726.7278110402158,7846.2301618035899]
[]
["Less: Distribution O&M",-555.34957334659305,-1442.8862210751663,-1715.4280713511516,-1813.2549083450426,-1894.8909293396111,-2067.255337024063,-2103.1564577674349,-2136.7368221419506,-2170.608204842858,-2460.716292267899]
["Property Taxes",-331.21868117170538,-490.17623927389241,-546.70121917476592,-565.32438303426841,-581.58689612004218,-590.05543848634511,-623.740951711972,-626.27688618403852,-628.75961726743731,-630.02476084022021]
["EBITDA",{"$f":"SUM(B18:B21)+B11","v":-297.21079731400971},{"$f":"SUM(C18:C21)+C11","v":1116.6727232616877},2358.4422880699535,3439.6858239885196,4169.2442539041076,4532.351379680068,4727.6763604502321,4830.6922525639175,4927.3599889299203,4755.4891086954703]
[]
["Less: Depreciation",-691.59075188952829,-1326.5202759774097,-1709.4101848011926,-1778.3644763652239,-1826.1573494465777,-1860.6678506872286,-1878.2673119835229,-1888.2338572473548,-1925.3781532291621,-1934.1999034804492]
["Add: Capitalized IDC",650.51563192223,180.13277853046256,45.190147077752435,26.769041156253962,23.558037530176222,13.029480263344169,6.1678630498306406,5.1423156697694248,12.530688619247645,2.9388122668529215]
["EBIT",{"$f":"SUM(B24:B25)+B22","v":-338.285917281308},-29.714774185259557,694.22225034651342,1688.0903887795496,2366.6449419877063,2684.7130092561838,2855.5769115165399,2947.6007109863322,3014.5125243200059,2824.2280174818743]
[]
["Less: Interest Expense",-563.51469447392287,-1248.3448819323614,-1385.8300439496243,-1403.2090415624027,-1401.933455414666,-1388.9112589451249,-1361.1766344787241,-1326.7983343563717,-1296.8476121699189,-1265.0774750282249]
["Less: Cash Tax",0,0,0,0,0,0,0,0,0,0]
["Net Income",{"$f":"SUM(B28:B29)+B26","v":-901.80061175523088},-1278.059656117621,-691.60779360311085,284.88134721714687,964.71148657304025,1295.8017503110589,1494.4002770378158,1620.8023766299605,1717.664912150087,1559.1505424536495]
[]
["Balance Sheet"]
["Cash",0,2.9103830456733704E-11,1.4551915228366852E-11,2.5011104298755527E-12,2.5011104298755527E-12,-1.3415046851150692E-11,7.0485839387401938E-12,1.7507773009128869E-11,-1.2960299500264227E-11,1.3869794202037156E-11]
["NWC",180.81712789091404,300.12157200237419,346.18181183853341,412.2553224521069,423.21186853852925,483.98285596036243,449.65392094324835,496.33889135604926,461.75636012464366,545.95733263792363]
["PP&E",57313.200113579209,80778.907960518045,81547.531545041857,80996.598733986597,80179.879194981244,78613.869275272285,76564.427225982377,74435.394597087958,72770.8115936213,70446.217883123201]
["Assets",{"$f":"SUM(B33:B35)","v":57494.017241470123},81079.02953252045,81893.713356880398,81408.854056438708,80603.09106351978,79097.852131232634,77014.08114692563,74931.733488444021,73232.567953745936,70992.175215761134]
[]
["Deferred Revenue",61.463363703984385,477.16100833388731,825.57112250829266,1033.6489050756416,1136.7888397346794,1126.2307580731608,1079.3550988577324,1032.8530535282343,986.8378888111522,939.84560839157348]
["Assets and Regulatory Assets",{"$f":"B36+B38","v":57555.480605174111},81556.190540854339,82719.284479388691,82442.502961514343,81739.879903254463,80224.082889305791,78093.436245783363,75964.586541972254,74219.405842557084,71932.020824152714]
[]
["Contribution from Grant",8543.8179299757794,21590.653276575438,21000.744585929548,20410.835895283657,19820.92720463777,19231.018513991876,18641.109823345989,18051.201132700098,17461.292442054211,16871.383751408321]
["ST Operating Debt",1958.0079724597731,2379.5350502377996,2435.7187508380339,2439.9207264462011,2431.2865543552798,2394.6733446896296,2334.9188529431854,2275.2212942297565,2230.8510204676681,2164.8316585741127]
["LT Debt",29431.582950600579,36170.186761900884,37361.352385078797,37632.459801768659,37606.087155063869,37046.330928417599,36103.137893005507,35161.172466974582,34449.603195826174,33412.320487003264]
["Liabilities",{"$f":"SUM(B41:B43)","v":39933.408853036133},60140.375088714121,60797.815721846375,60483.216423498518,59858.300914056919,58672.022787099108,57079.166569294684,55487.594893904432,54141.746658348056,52448.535896985697]
[]
["Retained Earnings",-901.80061175523088,-2179.8602678728521,-2871.4680614759632,-2586.5867142588163,-1621.8752276857761,-326.07347737471719,1168.3267996630987,2789.1291762930591,4506.7940884431455,6065.9446308967945]
["Share Capital",18523.872363893188,23595.675720013049,24792.936819018265,24545.873252274629,23503.454216883292,21878.133579581383,19845.942876825568,17687.862471774748,15570.865095765868,13417.540296270219]
["Equities",{"$f":"SUM(B46:B47)","v":17622.071752137956},21415.815452140196,21921.468757542301,21959.286538015811,21881.578989197515,21552.060102206666,21014.269676488668,20476.991648067808,20077.659184209013,19483.484927167014]
[]
["Liabilities and Equities",{"$f":"B44+B48","v":57555.480605174089},81556.190540854324,82719.284479388676,82442.502961514328,81739.879903254434,80224.082889305777,78093.436245783349,75964.58654197224,74219.405842557069,71932.020824152714]
[]
[]
["ROE Calculation"]
["Gross Fixed Assets",{"$f":"B35","v":57313.200113579209},{"$f":"C35","v":80778.907960518045},81547.531545041857,80996.598733986597,80179.879194981244,78613.869275272285,76564.427225982377,74435.394597087958,72770.8115936213,70446.217883123201]
["Less:Depreciation",{"$f":"B24","v":-691.59075188952829},{"$f":"C24","v":-1326.5202759774097},-1709.4101848011926,-1778.3644763652239,-1826.1573494465777,-1860.6678506872286,-1878.2673119835229,-1888.2338572473548,-1925.3781532291621,-1934.1999034804492]
["Contribution from Grant",{"$f":"-B41","v":-8543.8179299757794},{"$f":"-C41","v":-21590.653276575438},-21000.744585929548,-20410.835895283657,-19820.92720463777,-19231.018513991876,-18641.109823345989,-18051.201132700098,-17461.292442054211,-16871.383751408321]
["Net Fixed Assets",{"$f":"B54+B55+B56","v":48077.791431713908},{"$f":"C54+C55+C56","v":57861.734407965196},58837.376774311117,58807.398362337713,58532.794640896886,57522.182910593183,56045.050090652861,54495.95960714051,53384.140998337927,51640.634228234434]
["Allowance for Working Captial",{"$f":"B34","v":180.81712789091404},{"$f":"C34","v":300.12157200237419},346.18181183853341,412.2553224521069,423.21186853852925,483.98285596036243,449.65392094324835,496.33889135604926,461.75636012464366,545.95733263792363]
["Rate Base",{"$f":"SUM(B57:B58)","v":48258.608559604821},{"$f":"SUM(C57:C58)","v":58161.855979967571},59183.558586149651,59219.653684789817,58956.006509435414,58006.165766553546,56494.704011596106,54992.298498496559,53845.897358462571,52186.591560872359]
[]
["Net Income (After Interest Expense)",{"$f":"B30","v":-901.80061175523088},{"$f":"C30","v":-1278.059656117621},-691.60779360311085,284.88134721714687,964.71148657304025,1295.8017503110589,1494.4002770378158,1620.8023766299605,1717.664912150087,1559.1505424536495]
[]
[]
["ROE WACC Allocation (36%)",{"$f":"B59*0.36","v":17373.099081457734},{"$f":"C59*0.36","v":20938.268152788325},21306.081091013875,21319.075326524333,21224.162343396747,20882.219675959277,20338.093444174596,19797.227459458762,19384.523049046526,18787.17296191405]
["ROE%",{"$f":"B61/B64","v":-5.1907872483022928E-2},{"$f":"C61/C64","v":-6.1039415809918514E-2},-3.2460582058650177E-2,1.3362744061545155E-2,4.545345399099724E-2,6.2052874187644658E-2,7.3477894136918437E-2,8.1870169949255694E-2,8.8610119929392564E-2,8.2990162788962915E-2]

{"sheet":"Exhibit 5","index":3,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["EXHIBIT 5 - Capital Structure and Cost of Capital"]
[]
[null,null,"Capital Structure"]
[]
[null,null,"Col. 1","Col. 2"]
[null,null,"Capital Component","Weighting"]
[null,"Row 1","Equity",0.36]
[null,"Row 2","Long-term Debt",0.6]
[null,"Row 3","Short-term Debt",0.04]
[]
[]
[null,null,"Cost of Capital"]
[]
[null,null,"Col. 1","Col. 2"]
[null,null,"Capital Component","Annual Cost"]
[null,"Row 1","Equity",8.7800000000000003E-2]
[null,"Row 2","Long-term Debt",3.7199999999999997E-2]
[null,"Row 3","Short-term Debt",1.7600000000000001E-2]
[null,"Row 4","WACC",5.4631999999999993E-2]

{"sheet":"ROE Summary","index":4,"n_rows":6,"n_cols":11,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028]
["ROE Rate Application",{"$f":"'Rate Application'!B65","v":-5.1907872483022928E-2},{"$f":"'Rate Application'!C65","v":-6.1039415809918514E-2},{"$f":"'Rate Application'!D65","v":-3.2460582058650177E-2},{"$f":"'Rate Application'!E65","v":1.3362744061545155E-2},{"$f":"'Rate Application'!F65","v":4.545345399099724E-2},{"$f":"'Rate Application'!G65","v":6.2052874187644658E-2},{"$f":"'Rate Application'!H65","v":7.3477894136918437E-2},{"$f":"'Rate Application'!I65","v":8.1870169949255694E-2},{"$f":"'Rate Application'!J65","v":8.8610119929392564E-2},{"$f":"'Rate Application'!K65","v":8.2990162788962915E-2}]
[]
["ROE (Without CVVA)",{"$f":"'2019-2021'!D30","v":-41.605457726166534},{"$f":"'2019-2021'!E30","v":-0.32167498210942663},{"$f":"'2019-2021'!F30","v":-0.1399006290152445},{"$f":"'2022-2028'!E62","v":-9.0933574547454252E-2},{"$f":"'2022-2028'!F62","v":-2.3958185292857679E-2},{"$f":"'2022-2028'!G62","v":1.8619232162100059E-2},{"$f":"'2022-2028'!H62","v":3.1611449506319424E-2},{"$f":"'2022-2028'!I62","v":3.5103818384119141E-2},{"$f":"'2022-2028'!J62","v":3.7662093958244394E-2},{"$f":"'2022-2028'!K62","v":3.426653334235609E-2}]
["ROE (With CVVA)",{"$f":"B4","v":-41.605457726166534},{"$f":"C4","v":-0.32167498210942663},{"$f":"'2019-2021'!H30","v":-0.13440091191855752},{"$f":"'2022-2028'!Q62","v":-7.2235740314208138E-2},{"$f":"'2022-2028'!R62","v":1.0912725395256527E-2},{"$f":"'2022-2028'!S62","v":6.473176314458981E-2},{"$f":"'2022-2028'!T62","v":8.3024710970400512E-2},{"$f":"'2022-2028'!U62","v":8.8046714488655323E-2},{"$f":"'2022-2028'!V62","v":9.1939240071533535E-2},{"$f":"'2022-2028'!W62","v":9.0141197330477582E-2}]
["Variance",{"$f":"B5-B4","v":0},{"$f":"C5-C4","v":0},5.4997170966869791E-3,1.8697834233246113E-2,3.4870910688114209E-2,4.6112530982489755E-2,5.1413261464081088E-2,5.2942896104536182E-2,5.427714611328914E-2,5.5874663988121492E-2]

{"sheet":"CVVA Summary","index":5,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[[11,0,13,0],[11,11,13,11],[14,0,16,0],[14,11,16,11],[18,0,20,0],[18,11,20,11],[2,0,4,0],[2,11,4,11],[5,0,7,0],[5,11,7,11],[8,0,10,0],[8,11,10,11]]}
[null,null,2021,{"$f":"C1+1","v":2022},{"$f":"D1+1","v":2023},2024,2025,2026,2027,2028,null,"SUM"]
[null,null,"ACTUAL","ESTIMATE","FORECAST","FORECAST","FORECAST","FORECAST","FORECAST","FORECAST"]
["R1 \nRES","NAC REV",712871.42508466227,1826041.852110401,2975357.9401201247,4050974.743329253,4500916.7822583979,4600675.6253572721,4712534.0945982812,4817055.0520057688,null,{"$f":"SUM(C5:J5)","v":7768287.3529657479}]
[null,"CIP REV",842161.20618206006,2316477.7725739912,3776447.5095815975,5170089.3736826135,5764585.0859103138,5891911.6144473338,6034168.7030280456,6168873.6024239529]
[null,"DIFFERENCE",{"$f":"C4-C3","v":129289.78109739779},490435.92046359018,801089.5694614728,1119114.6303533604,1263668.3036519159,1291235.9890900617,1321634.6084297644,1351818.5504181841]
["R1 \nCOM","NAC REV",17501.734511906427,72540.795271720985,126185.94933083052,163354.81969537801,185592.72967189038,189909.03115502893,194312.76833253837,198575.00809158347,null,{"$f":"SUM(C8:J8)","v":110791.26003615888}]
[null,"CIP REV",23095.182922248296,78830.157800489324,137314.68184628105,178523.69981024283,203129.90128889086,207851.09836607485,212667.89607139808,217351.47799141071]
[null,"DIFFERENCE",{"$f":"C7-C6","v":5593.448410341869},6289.362528768339,11128.732515450523,15168.88011486482,17537.17161700048,17942.067211045913,18355.127738859708,18776.469899827236]
["R1 \nAg","NAC REV",null,4921.8469873477979,10343.703291729851,12922.710029735834,13107.373552026811,13294.807027152152,13485.052004404375,13678.15065631538,null,{"$f":"SUM(C11:J11)","v":-26864.972726691984}]
[null,"CIP REV",null,2608.2440280854935,7134.5576963583444,8773.6555415313087,8899.512622904278,9027.2575604978429,9156.9186721553087,9288.5247004876383]
[null,"DIFFERENCE",null,{"$f":"D10-D9","v":-2313.6029592623045},{"$f":"E10-E9","v":-3209.1455953715067},-4149.0544882045251,-4207.860929122533,-4267.5494666543091,-4328.1333322490664,-4389.6259558277416]
["R6 \nM COMM","NAC REV",7403.7903807210168,56592.469013694688,125630.89227950592,171657.6721185901,180430.94760349829,183062.67729548618,186708.27767397877,195982.96292097346,null,{"$f":"SUM(C14:J14)","v":198725.39584130613}]
[null,"CIP REV",10754.686610419549,66371.415878712782,148684.58346447154,202138.58902127238,212339.25686604471,215432.53785528534,219844.66222638299,230629.35320516527]
[null,"DIFFERENCE",{"$f":"C13-C12","v":3350.8962296985319},{"$f":"D13-D12","v":9778.9468650180934},{"$f":"E13-E12","v":23053.691184965617},30480.916902682278,31908.30926254642,32369.860559799155,33136.384552404226,34646.390284191817]
["R6 \nL COMM","NAC REV",37739.66626600008,174905.27176919708,273622.55216190673,372851.07973115111,364863.75582510768,370153.89062657021,375523.37745005474,474385.83522732626,null,{"$f":"SUM(C17:J17)","v":-204039.04075410386}]
[null,"CIP REV",20493.987767489627,89742.409200459311,256456.18679312587,346536.25169691909,351558.86142662278,356656.81030227215,361831.2284110561,456730.65270526509]
[null,"DIFFERENCE",{"$f":"C16-C15","v":-17245.678498510453},{"$f":"D16-D15","v":-85162.862568737764},{"$f":"E16-E15","v":-17166.365368780855},-26314.828034232021,-13304.894398484903,-13497.080324298062,-13692.149038998643,-17655.182522061164]
[]
["TOTAL","NAC REV",{"$f":"SUM(C3,C6,C9,C12,C15)","v":775516.61624328978},2135002.2351523614,3511141.0371840978,4771761.0249041086,5244911.5889109224,5357096.0314615099,5482563.5700592566,5699677.0089019677,null,{"$f":"SUM(C21:J21)","v":7846899.9953624178}]
[null,"CIP REV",896505.06348221749,2554029.9994817376,4326037.5193818342,5906061.5697525796,6540512.618114776,6680879.3185314648,6837669.4084090376,7082873.6110262815]
[null,"DIFFERENCE",120988.44723892774,419027.76432937657,814896.48219773662,1134300.5448484709,1295601.0292038554,1323783.2870699547,1355105.8383497808,1383196.6021243143]

{"sheet":"Check","index":6,"n_rows":39,"n_cols":22,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
[]
["Rate Case",2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,"Total - 2023-2028",null,null,null,null,"2023-2028","Rate App","CIP Revenues","Var","NAC Revenues","Var"]
["Rate 1",{"$f":"'Rate Application'!B14","v":315.79079230606334},{"$f":"'Rate Application'!C14","v":1609.0504368403242},{"$f":"'Rate Application'!D14","v":2863.9280272904416},{"$f":"'Rate Application'!E14","v":3717.5597788973419},{"$f":"'Rate Application'!F14","v":4348.8942776394188},{"$f":"'Rate Application'!G14","v":4795.0336973736703},{"$f":"'Rate Application'!H14","v":5001.9713676854717},{"$f":"'Rate Application'!I14","v":5109.9555081372409},{"$f":"'Rate Application'!J14","v":5211.4337275375901},{"$f":"'Rate Application'!K14","v":5298.9918434404808},{"$f":"SUM(F3:K3)","v":29766.28042181387},null,null,null,null,"Rate 1",{"$f":"L3","v":29766.28042181387},{"$f":"L11","v":34015.195071242095},{"$f":"S3-R3","v":4248.9146494282249},{"$f":"L27","v":26792.276340507713},{"$f":"U3-R3","v":-2974.0040813061569}]
["Rate 6",{"$f":"'Rate Application'!B15","v":57.80412219547523},{"$f":"'Rate Application'!C15","v":234.47365323515845},{"$f":"'Rate Application'!D15","v":468.6701682339687},{"$f":"'Rate Application'!E15","v":712.05376998400288},{"$f":"'Rate Application'!F15","v":873.29035107639368},{"$f":"'Rate Application'!G15","v":953.01208154562971},{"$f":"'Rate Application'!H15","v":992.67749799434523},{"$f":"'Rate Application'!I15","v":1005.2845022188733},{"$f":"'Rate Application'!J15","v":1018.0516153970528},{"$f":"'Rate Application'!K15","v":1030.9808709125955},{"$f":"SUM(F4:K4)","v":5873.2969191448901},null,null,null,null,"Rate 6",{"$f":"L4","v":5873.2969191448901},{"$f":"L12","v":3358.8389739738832},{"$f":"S4-R4","v":-2514.4579451710069},{"$f":"L28","v":3274.8739209141495},{"$f":"U4-R4","v":-2598.4229982307406}]
["Rate 11",{"$f":"'Rate Application'!B16","v":26.17873339468413},{"$f":"'Rate Application'!C16","v":54.261951417593224},{"$f":"'Rate Application'!D16","v":121.39448684889666},{"$f":"'Rate Application'!E16","v":207.25711828189452},null,null,null,null,null,null,0,null,null,null,null,"Total",{"$f":"SUM(R3:R4)","v":35639.577340958756},{"$f":"SUM(S3:S4)","v":37374.03404521598},1734.4567042572235,{"$f":"SUM(U3:U4)","v":30067.150261421863},{"$f":"U5-R5","v":-5572.4270795368939}]
["Rate 16",{"$f":"'Rate Application'!B17","v":189.58380930806595},{"$f":"'Rate Application'!C17","v":1151.9491421176701},{"$f":"'Rate Application'!D17","v":1166.5788962225645},{"$f":"'Rate Application'!E17","v":1181.3944482045908},null,null,null,null,null,null,0]
[null,{"$f":"SUM(B3:B6)","v":589.35745720428872},{"$f":"SUM(C3:C6)","v":3049.7351836107464},4620.571578595871,5818.2651153678307,5222.1846287158123,5748.0457789192997,5994.6488656798174,6115.240010356114,6229.4853429346431,6329.9727143530763,35639.577340958756]
[]
[]
["CIP Revenue",null,null,null,null,2023,2024,2025,2026,2027,2028,"Total - 2023-2028"]
["Rate 1",null,null,null,null,{"$f":"('CVVA Summary'!E4+'CVVA Summary'!E7+'CVVA Summary'!E10)/1000","v":3920.896749124237},{"$f":"('CVVA Summary'!F4+'CVVA Summary'!F7+'CVVA Summary'!F10)/1000","v":5357.3867290343887},{"$f":"('CVVA Summary'!G4+'CVVA Summary'!G7+'CVVA Summary'!G10)/1000","v":5976.6144998221089},{"$f":"('CVVA Summary'!H4+'CVVA Summary'!H7+'CVVA Summary'!H10)/1000","v":6108.7899703739067},{"$f":"('CVVA Summary'!I4+'CVVA Summary'!I7+'CVVA Summary'!I10)/1000","v":6255.9935177715988},{"$f":"('CVVA Summary'!J4+'CVVA Summary'!J7+'CVVA Summary'!J10)/1000","v":6395.5136051158515},{"$f":"SUM(B11:K11)","v":34015.195071242095}]
["Rate 6",null,null,null,null,{"$f":"('CVVA Summary'!E13+'CVVA Summary'!E16)/1000","v":405.14077025759747},{"$f":"('CVVA Summary'!F13+'CVVA Summary'!F16)/1000","v":548.67484071819149},{"$f":"('CVVA Summary'!G13+'CVVA Summary'!G16)/1000","v":563.89811829266739},{"$f":"('CVVA Summary'!H13+'CVVA Summary'!H16)/1000","v":572.08934815755742},{"$f":"('CVVA Summary'!I13+'CVVA Summary'!I16)/1000","v":581.67589063743912},{"$f":"('CVVA Summary'!J13+'CVVA Summary'!J16)/1000","v":687.36000591043035},{"$f":"SUM(B12:K12)","v":3358.8389739738832}]
["Rate 11",null,null,null,null,null,null,null,null,null,null,0]
["Rate 16",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"SUM(F11:F14)","v":4326.0375193818345},{"$f":"SUM(G11:G14)","v":5906.06156975258},{"$f":"SUM(H11:H14)","v":6540.5126181147762},{"$f":"SUM(I11:I14)","v":6680.8793185314644},{"$f":"SUM(J11:J14)","v":6837.6694084090377},{"$f":"SUM(K11:K14)","v":7082.8736110262817},{"$f":"SUM(L11:L14)","v":37374.03404521598}]
[]
[]
["Variance",null,null,null,null,2023,2024,2025,2026,2027,2028,"Total - 2023-2028"]
["Rate 1",null,null,null,null,{"$f":"F11-F3","v":-427.99752851518178},{"$f":"G11-G3","v":562.35303166071844},974.64313213663718,998.83446223666579,1044.5597902340087,1096.5217616753707,{"$f":"SUM(B19:K19)","v":4248.9146494282195}]
["Rate 6",null,null,null,null,{"$f":"F12-F4","v":-468.14958081879621},-404.33724082743822,-428.77937970167784,-433.19515406131586,-436.37572475961372,-343.62086500216515,{"$f":"SUM(B20:K20)","v":-2514.4579451710069}]
["Rate 11",null,null,null,null,null,null,null,null,null,null,0]
["Rate 16",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"SUM(F19:F22)","v":-896.14710933397805},{"$f":"SUM(G19:G22)","v":158.01579083328022},{"$f":"SUM(H19:H22)","v":545.86375243495934},{"$f":"SUM(I19:I22)","v":565.63930817534992},{"$f":"SUM(J19:J22)","v":608.18406547439497},{"$f":"SUM(K19:K22)","v":752.90089667320558},{"$f":"SUM(L19:L22)","v":1734.4567042572126}]
[]
[]
["NAC Revenue",null,null,null,null,2023,2024,2025,2026,2027,2028,"Total - 2023-2028"]
["Rate 1",null,null,null,null,{"$f":"('CVVA Summary'!E3+'CVVA Summary'!E6+'CVVA Summary'!E9)/1000","v":3111.8875927426852},{"$f":"('CVVA Summary'!F3+'CVVA Summary'!F6+'CVVA Summary'!F9)/1000","v":4227.2522730543669},{"$f":"('CVVA Summary'!G3+'CVVA Summary'!G6+'CVVA Summary'!G9)/1000","v":4699.6168854823163},{"$f":"('CVVA Summary'!H3+'CVVA Summary'!H6+'CVVA Summary'!H9)/1000","v":4803.8794635394534},{"$f":"('CVVA Summary'!I3+'CVVA Summary'!I6+'CVVA Summary'!I9)/1000","v":4920.3319149352237},{"$f":"('CVVA Summary'!J3+'CVVA Summary'!J6+'CVVA Summary'!J9)/1000","v":5029.3082107536684},{"$f":"SUM(B27:K27)","v":26792.276340507713}]
["Rate 6",null,null,null,null,{"$f":"('CVVA Summary'!E12+'CVVA Summary'!E15)/1000","v":399.25344444141263},{"$f":"('CVVA Summary'!F12+'CVVA Summary'!F15)/1000","v":544.5087518497412},{"$f":"('CVVA Summary'!G12+'CVVA Summary'!G15)/1000","v":545.294703428606},{"$f":"('CVVA Summary'!H12+'CVVA Summary'!H15)/1000","v":553.21656792205647},{"$f":"('CVVA Summary'!I12+'CVVA Summary'!I15)/1000","v":562.23165512403352},{"$f":"('CVVA Summary'!J12+'CVVA Summary'!J15)/1000","v":670.36879814829967},{"$f":"SUM(B28:K28)","v":3274.8739209141495}]
["Rate 11",null,null,null,null,{"$f":"F13","v":0},{"$f":"G13","v":0},0,0,0,0,0]
["Rate 16",null,null,null,null,{"$f":"F14","v":0},{"$f":"G14","v":0},0,0,0,0,0]
[null,null,null,null,null,{"$f":"SUM(F27:F30)","v":3511.141037184098},{"$f":"SUM(G27:G30)","v":4771.7610249041081},{"$f":"SUM(H27:H30)","v":5244.9115889109225},{"$f":"SUM(I27:I30)","v":5357.0960314615095},{"$f":"SUM(J27:J30)","v":5482.5635700592575},{"$f":"SUM(K27:K30)","v":5699.6770089019683},{"$f":"SUM(L27:L30)","v":30067.150261421863}]
[]
[]
["Variance",null,null,null,null,2023,2024,2025,2026,2027,2028,"Total - 2023-2028"]
["Rate 1",null,null,null,null,{"$f":"F27-F3","v":-1237.0066848967335},{"$f":"G27-G3","v":-567.78142431930337},-302.35448220315538,-306.07604459778759,-291.10181260236641,-269.68363268681242,{"$f":"SUM(B35:K35)","v":-2974.0040813061587}]
["Rate 6",null,null,null,null,{"$f":"F28-F4","v":-474.03690663498105},-408.50332969588851,-447.38279456573923,-452.06793429681682,-455.81996027301932,-360.61207276429582,{"$f":"SUM(B36:K36)","v":-2598.4229982307406}]
["Rate 11",null,null,null,null,null,null,null,null,null,null,0]
["Rate 16",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"SUM(F35:F38)","v":-1711.0435915317146},{"$f":"SUM(G35:G38)","v":-976.28475401519188},{"$f":"SUM(H35:H38)","v":-749.73727676889462},{"$f":"SUM(I35:I38)","v":-758.1439788946044},{"$f":"SUM(J35:J38)","v":-746.92177287538573},{"$f":"SUM(K35:K38)","v":-630.29570545110823},{"$f":"SUM(L35:L38)","v":-5572.4270795368993}]