{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Summary","Revenue Requirement","PILs","Avg Nt Fix Ass &UCC"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":4,"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":"Summary","index":0,"n_rows":22,"n_cols":17,"rows_kept":22,"cut":false,"hidden":false,"merged":[[9,5,9,9],[9,2,9,4]]}
[]
[null,"PowerStream Inc"]
[null,"Renewable Generation Connection Rate Protection "]
[null,"Compensation Amounts under Ontario Regulation 330/09"]
[]
[null,"Summary of Revenue Requirement for Recovery in 2016 - 2026"]
[null,"RGC Eligible Investments "]
[]
[]
[null,null,"Board Approved RR Basis",null,null,"Proposed for Recoveries - TEST YEARS"]
[null,null,"2013 \n(EB-2012-0161)","2014 \n(EB-2013-0166)","2015 \n(EB-2014-0608)",2016,2017,2018,2019,2020,{"$f":"+J11+1","v":2021},{"$f":"+K11+1","v":2022},2023,2024,2025,2026,2027]
[null,"2011 & Prior RGC Investmentt",162683.83820258238,67769.110358616817,53805.465303664176]
[null,"2012 RGC Investment",null,146069.62324442546,61131.519622720516]
[null,"2013 RGC Investment",null,null,146352.67443030427]
[null,"2014 RGC Investment",null,null,null,"$150,269(1)"]
[null,"2015 RGC Investment",null,null,null,"$4,208 (2)"]
[null,"2010-2026 RGC Investment",null,null,null,272792.22369428183,271059.581385269,266079.19364528783,260516.63980962665,256894.31603048395,{"$f":"'Revenue Requirement'!Z26","v":252940.28622054483},{"$f":"'Revenue Requirement'!AB26","v":248681.08686227308},{"$f":"'Revenue Requirement'!AD26","v":244141.13151953527},{"$f":"'Revenue Requirement'!AF26","v":239342.8806710887},{"$f":"'Revenue Requirement'!AH26","v":234306.99795739003},{"$f":"'Revenue Requirement'!AJ26","v":229052.49392765955},{"$f":"'Revenue Requirement'!AL26","v":223596.85828717964}]
[null,null,{"$f":"SUM(C12:C17)","v":162683.83820258238},{"$f":"SUM(D12:D17)","v":213838.73360304226},{"$f":"SUM(E12:E17)","v":261289.65935668896},427270,{"$f":"SUM(G12:G17)","v":271059.581385269},{"$f":"SUM(H12:H17)","v":266079.19364528783},{"$f":"SUM(I12:I17)","v":260516.63980962665},{"$f":"SUM(J12:J17)","v":256894.31603048395},{"$f":"SUM(K12:K17)","v":252940.28622054483},{"$f":"SUM(L12:L17)","v":248681.08686227308},244141.13151953527,239342.8806710887,234306.99795739003,229052.49392765955,{"$f":"SUM(Q12:Q17)","v":223596.85828717964}]
[]
[null,"NOTES:"]
["(1)","Revenue Requirement for 2014 and 2015"]
["(2)","Revenue Requirement for 2015 "]

{"sheet":"Revenue Requirement","index":1,"n_rows":26,"n_cols":38,"rows_kept":26,"cut":false,"hidden":false,"merged":[[5,36,5,37],[5,34,5,35],[5,10,5,11],[5,12,5,13],[5,26,5,27],[5,28,5,29],[5,30,5,31],[5,32,5,33],[5,2,5,3],[5,16,5,17],[5,18,5,19],[5,20,5,21],[5,24,5,25],[5,22,5,23],[5,8,5,9],[5,14,5,15],[5,4,5,5],[5,6,5,7]]}
[]
[null,"PowerStream Inc"]
[null,"Renewable Generation Connection Rate Protection "]
[null,"Compensation Amounts under Ontario Regulation 330/09"]
[]
[null,null,2010,null,2011,null,2012,null,2013,null,2014,null,2015,null,2016,null,2017,null,2018,null,2019,null,2020,null,{"$f":"+W6+1","v":2021},null,{"$f":"+Y6+1","v":2022},null,{"$f":"+AA6+1","v":2023},null,{"$f":"+AC6+1","v":2024},null,{"$f":"+AE6+1","v":2025},null,{"$f":"+AG6+1","v":2026},null,{"$f":"+AI6+1","v":2027}]
[null,"Net Fixed Assets",null,40059.658333333333,null,275565.70513888891,null,747920.5063328353,null,1357994.434395506,null,2165791.3514678655,null,2619173.9807958337,null,2576445.2172389436,null,2501089.326682053,null,2394160.8441129359,null,2288878.7198438179,null,2184419.6376369279,null,{"$f":"'Avg Nt Fix Ass &UCC'!O109","v":2079960.5554300374},null,{"$f":"'Avg Nt Fix Ass &UCC'!P109","v":1975501.4732231472},null,{"$f":"'Avg Nt Fix Ass &UCC'!Q109","v":1871042.391016257},null,{"$f":"'Avg Nt Fix Ass &UCC'!R109","v":1766583.3088093665},null,{"$f":"'Avg Nt Fix Ass &UCC'!S109","v":1662124.2266024761},null,{"$f":"'Avg Nt Fix Ass &UCC'!T109","v":1557665.1443955861},null,{"$f":"'Avg Nt Fix Ass &UCC'!U109","v":1453206.0621886957}]
[null,"OM&A",{"$f":"D22","v":0},null,{"$f":"F22","v":0},null,{"$f":"H22","v":0},null,{"$f":"J22","v":0},null,{"$f":"L22","v":0},null,{"$f":"N22","v":0},null,{"$f":"P22","v":0},null,{"$f":"R22","v":0},null,{"$f":"T22","v":0},null,{"$f":"V22","v":0},null,{"$f":"X22","v":0},null,{"$f":"Z22","v":0},null,{"$f":"AB22","v":0},null,{"$f":"AD22","v":0},null,{"$f":"AF22","v":0},null,{"$f":"AH22","v":0},null,{"$f":"AJ22","v":0},null,{"$f":"AL22","v":0}]
[null,"WCA",0.13,{"$f":"C8*C9","v":0},0.13,{"$f":"E8*E9","v":0},{"$f":"E9","v":0.13},{"$f":"G8*G9","v":0},{"$f":"E9","v":0.13},{"$f":"I8*I9","v":0},{"$f":"E9","v":0.13},{"$f":"K8*K9","v":0},{"$f":"E9","v":0.13},{"$f":"M8*M9","v":0},{"$f":"G9","v":0.13},{"$f":"O8*O9","v":0},{"$f":"I9","v":0.13},{"$f":"Q8*Q9","v":0},{"$f":"K9","v":0.13},{"$f":"S8*S9","v":0},{"$f":"M9","v":0.13},{"$f":"U8*U9","v":0},{"$f":"O9","v":0.13},{"$f":"W8*W9","v":0},{"$f":"Q9","v":0.13},{"$f":"Y8*Y9","v":0},{"$f":"S9","v":0.13},{"$f":"AA8*AA9","v":0},{"$f":"U9","v":0.13},{"$f":"AC8*AC9","v":0},{"$f":"W9","v":0.13},{"$f":"AE8*AE9","v":0},{"$f":"Y9","v":0.13},{"$f":"AG8*AG9","v":0},{"$f":"AA9","v":0.13},{"$f":"AI8*AI9","v":0},{"$f":"AC9","v":0.13},{"$f":"AK8*AK9","v":0}]
[null,"Rate Base",null,{"$f":"SUM(D7:D9)","v":40059.658333333333},null,{"$f":"SUM(F7:F9)","v":275565.70513888891},null,{"$f":"SUM(H7:H9)","v":747920.5063328353},null,{"$f":"SUM(J7:J9)","v":1357994.434395506},null,{"$f":"SUM(L7:L9)","v":2165791.3514678655},null,{"$f":"SUM(N7:N9)","v":2619173.9807958337},null,{"$f":"SUM(P7:P9)","v":2576445.2172389436},null,{"$f":"SUM(R7:R9)","v":2501089.326682053},null,{"$f":"SUM(T7:T9)","v":2394160.8441129359},null,{"$f":"SUM(V7:V9)","v":2288878.7198438179},null,{"$f":"SUM(X7:X9)","v":2184419.6376369279},null,{"$f":"SUM(Z7:Z9)","v":2079960.5554300374},null,{"$f":"SUM(AB7:AB9)","v":1975501.4732231472},null,{"$f":"SUM(AD7:AD9)","v":1871042.391016257},null,{"$f":"SUM(AF7:AF9)","v":1766583.3088093665},null,{"$f":"SUM(AH7:AH9)","v":1662124.2266024761},null,{"$f":"SUM(AJ7:AJ9)","v":1557665.1443955861},null,{"$f":"SUM(AL7:AL9)","v":1453206.0621886957}]
[]
[]
[null,"Deemed ST Debt",0.04,{"$f":"D10*C13","v":1602.3863333333334},{"$f":"C13","v":0.04},{"$f":"F10*E13","v":11022.628205555557},0.04,{"$f":"H10*G13","v":29916.820253313414},0.04,{"$f":"J10*I13","v":54319.777375820246},{"$f":"I13","v":0.04},{"$f":"L10*K13","v":86631.654058714616},{"$f":"K13","v":0.04},{"$f":"N10*M13","v":104766.95923183335},{"$f":"M13","v":0.04},{"$f":"P10*O13","v":103057.80868955774},{"$f":"O13","v":0.04},{"$f":"R10*Q13","v":100043.57306728212},{"$f":"Q13","v":0.04},{"$f":"T10*S13","v":95766.433764517438},{"$f":"S13","v":0.04},{"$f":"V10*U13","v":91555.148793752713},{"$f":"U13","v":0.04},{"$f":"X10*W13","v":87376.785505477121},{"$f":"W13","v":0.04},{"$f":"Z10*Y13","v":83198.4222172015},{"$f":"Y13","v":0.04},{"$f":"AB10*AA13","v":79020.058928925893},{"$f":"AA13","v":0.04},{"$f":"AD10*AC13","v":74841.695640650287},{"$f":"AC13","v":0.04},{"$f":"AF10*AE13","v":70663.332352374666},{"$f":"AE13","v":0.04},{"$f":"AH10*AG13","v":66484.969064099045},{"$f":"AG13","v":0.04},{"$f":"AJ10*AI13","v":62306.605775823446},{"$f":"AI13","v":0.04},{"$f":"AL10*AK13","v":58128.242487547825}]
[null,"Deemed LT Debt",0.56000000000000005,{"$f":"D10*C14","v":22433.40866666667},0.56000000000000005,{"$f":"F10*E14","v":154316.79487777781},0.56000000000000005,{"$f":"H10*G14","v":418835.48354638781},0.56000000000000005,{"$f":"J10*I14","v":760476.88326148351},{"$f":"I14","v":0.56000000000000005},{"$f":"L10*K14","v":1212843.1568220048},{"$f":"K14","v":0.56000000000000005},{"$f":"N10*M14","v":1466737.4292456671},{"$f":"M14","v":0.56000000000000005},{"$f":"P10*O14","v":1442809.3216538085},{"$f":"O14","v":0.56000000000000005},{"$f":"R10*Q14","v":1400610.0229419498},{"$f":"Q14","v":0.56000000000000005},{"$f":"T10*S14","v":1340730.0727032442},{"$f":"S14","v":0.56000000000000005},{"$f":"V10*U14","v":1281772.0831125381},{"$f":"U14","v":0.56000000000000005},{"$f":"X10*W14","v":1223274.9970766797},{"$f":"W14","v":0.56000000000000005},{"$f":"Z10*Y14","v":1164777.9110408211},{"$f":"Y14","v":0.56000000000000005},{"$f":"AB10*AA14","v":1106280.8250049625},{"$f":"AA14","v":0.56000000000000005},{"$f":"AD10*AC14","v":1047783.738969104},{"$f":"AC14","v":0.56000000000000005},{"$f":"AF10*AE14","v":989286.65293324541},{"$f":"AE14","v":0.56000000000000005},{"$f":"AH10*AG14","v":930789.56689738669},{"$f":"AG14","v":0.56000000000000005},{"$f":"AJ10*AI14","v":872292.48086152831},{"$f":"AI14","v":0.56000000000000005},{"$f":"AL10*AK14","v":813795.39482566959}]
[null,"Deemed Equity",0.4,{"$f":"D10*C15","v":16023.863333333335},{"$f":"C15","v":0.4},{"$f":"F10*E15","v":110226.28205555557},{"$f":"E15","v":0.4},{"$f":"H10*G15","v":299168.20253313414},0.4,{"$f":"J10*I15","v":543197.77375820244},{"$f":"I15","v":0.4},{"$f":"L10*K15","v":866316.5405871463},{"$f":"K15","v":0.4},{"$f":"N10*M15","v":1047669.5923183336},{"$f":"M15","v":0.4},{"$f":"P10*O15","v":1030578.0868955775},{"$f":"O15","v":0.4},{"$f":"R10*Q15","v":1000435.7306728213},{"$f":"Q15","v":0.4},{"$f":"T10*S15","v":957664.33764517447},{"$f":"S15","v":0.4},{"$f":"V10*U15","v":915551.48793752724},{"$f":"U15","v":0.4},{"$f":"X10*W15","v":873767.85505477118},{"$f":"W15","v":0.4},{"$f":"Z10*Y15","v":831984.222172015},{"$f":"Y15","v":0.4},{"$f":"AB10*AA15","v":790200.58928925893},{"$f":"AA15","v":0.4},{"$f":"AD10*AC15","v":748416.95640650287},{"$f":"AC15","v":0.4},{"$f":"AF10*AE15","v":706633.32352374669},{"$f":"AE15","v":0.4},{"$f":"AH10*AG15","v":664849.69064099051},{"$f":"AG15","v":0.4},{"$f":"AJ10*AI15","v":623066.05775823444},{"$f":"AI15","v":0.4},{"$f":"AL10*AK15","v":581282.42487547826}]
[]
[null,"ST Interest",1.3299999999999999E-2,21.311738233333333,1.3299999999999999E-2,146.6009551338889,1.3299999999999999E-2,397.8937093690684,2.0799999999999999E-2,1129.8513694170611,2.0799999999999999E-2,1801.9384044212638,2.0799999999999999E-2,2179.1527520221334,2.1600000000000001E-2,2226.0486676944474,0.03,3001.3071920184634,0.03,2872.993012935523,0.03,2746.6544638125811,0.03,{"$f":"W17*X13","v":2621.3035651643136},0.03,{"$f":"Y17*Z13","v":2495.9526665160447},0.03,{"$f":"AA17*AB13","v":2370.6017678677767},0.03,{"$f":"AC17*AD13","v":2245.2508692195083},0.03,{"$f":"AE17*AF13","v":2119.8999705712399},0.03,{"$f":"AG17*AH13","v":1994.5490719229713},0.03,{"$f":"AI17*AJ13","v":1869.1981732747033},0.03,{"$f":"AK17*AL13","v":1743.8472746264347}]
[null,"LT Interest",5.8900000000000001E-2,1321.3277704666668,5.8900000000000001E-2,9089.2592183011129,5.8900000000000001E-2,24669.409980882243,4.1500000000000002E-2,31559.790655351568,4.1500000000000002E-2,50332.991008113204,4.1500000000000002E-2,60869.603313695188,3.9587687426833107E-2,57117.484442152076,4.0058375498905126E-2,56106.162226538749,4.0282170868022167E-2,54007.517876527862,4.0282170868022167E-2,51632.562065799968,4.0282170868022167E-2,{"$f":"W18*X14","v":49276.17245082213},4.0282170868022167E-2,{"$f":"Y18*Z14","v":46919.782835844278},4.0282170868022167E-2,{"$f":"AA18*AB14","v":44563.393220866426},4.0282170868022167E-2,{"$f":"AC18*AD14","v":42207.003605888582},4.0282170868022167E-2,{"$f":"AE18*AF14","v":39850.613990910737},4.0282170868022167E-2,{"$f":"AG18*AH14","v":37494.224375932878},4.0282170868022167E-2,{"$f":"AI18*AJ14","v":35137.83476095504},4.0282170868022167E-2,{"$f":"AK18*AL14","v":32781.445145977188}]
[null,"ROE",8.0100000000000005E-2,1283.5114530000001,8.0100000000000005E-2,8829.1251926500008,8.0100000000000005E-2,23963.373022904045,8.9300000000000004E-2,48507.561196607479,8.9300000000000004E-2,77362.067074432169,8.9300000000000004E-2,93556.894594027195,9.2999999999999999E-2,95843.762081288703,9.2999999999999999E-2,93040.522952572384,9.2999999999999999E-2,89062.78340100123,9.2999999999999999E-2,85146.288378190031,9.2999999999999999E-2,{"$f":"W19*X15","v":81260.410520093719},9.2999999999999999E-2,{"$f":"Y19*Z15","v":77374.532661997393},9.2999999999999999E-2,{"$f":"AA19*AB15","v":73488.654803901081},9.2999999999999999E-2,{"$f":"AC19*AD15","v":69602.77694580477},9.2999999999999999E-2,{"$f":"AE19*AF15","v":65716.899087708443},9.2999999999999999E-2,{"$f":"AG19*AH15","v":61831.021229612117},9.2999999999999999E-2,{"$f":"AI19*AJ15","v":57945.143371515805},9.2999999999999999E-2,{"$f":"AK19*AL15","v":54059.265513419479}]
[null,null,null,{"$f":"SUM(D17:D19)","v":2626.1509617000002},null,{"$f":"SUM(F17:F19)","v":18064.985366085002},null,{"$f":"SUM(H17:H19)","v":49030.676713155357},null,{"$f":"SUM(J17:J19)","v":81197.203221376112},null,{"$f":"SUM(L17:L19)","v":129496.99648696664},null,{"$f":"SUM(N17:N19)","v":156605.65065974451},null,{"$f":"SUM(P17:P19)","v":155187.29519113523},null,{"$f":"SUM(R17:R19)","v":152147.9923711296},null,{"$f":"SUM(T17:T19)","v":145943.2942904646},null,{"$f":"SUM(V17:V19)","v":139525.50490780256},null,{"$f":"SUM(X17:X19)","v":133157.88653608016},null,{"$f":"SUM(Z17:Z19)","v":126790.26816435772},null,{"$f":"SUM(AB17:AB19)","v":120422.64979263529},null,{"$f":"SUM(AD17:AD19)","v":114055.03142091286},null,{"$f":"SUM(AF17:AF19)","v":107687.41304919042},null,{"$f":"SUM(AH17:AH19)","v":101319.79467746796},null,{"$f":"SUM(AJ17:AJ19)","v":94952.176305745554},null,{"$f":"SUM(AL17:AL19)","v":88584.557934023105}]
[]
[null,"OM&A",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Amortization",null,1980.6833333333332,null,20336.223055555554,null,50132.234556551703,null,73341.630718106491,null,104658.83639537368,null,118981.58480689029,null,109962.24230689029,null,107751.79880689029,null,106105.16633134487,null,104459.08220689028,null,104459.08220689028,null,{"$f":"'Avg Nt Fix Ass &UCC'!O110","v":104459.08220689028},null,{"$f":"'Avg Nt Fix Ass &UCC'!P110","v":104459.08220689028},null,{"$f":"'Avg Nt Fix Ass &UCC'!Q110","v":104459.08220689028},null,{"$f":"'Avg Nt Fix Ass &UCC'!R110","v":104459.08220689028},null,{"$f":"'Avg Nt Fix Ass &UCC'!S110","v":104459.08220689028},null,{"$f":"'Avg Nt Fix Ass &UCC'!T110","v":104459.08220689028},null,{"$f":"'Avg Nt Fix Ass &UCC'!U110","v":104459.08220689028}]
[null,"Grossed-up PILs",null,-151.7842827328688,null,-10388.328501577604,null,-11375.16768069878,null,1214.799723808683,null,3430.7160151063381,null,3106.8717526836094,null,7642.686196256338,null,11159.790207249123,null,14030.733023478344,null,16532.052694933802,null,19277.347287513508,null,{"$f":"PILs!N35","v":21690.935849296828},null,{"$f":"PILs!O35","v":23799.354862747503},null,{"$f":"PILs!P35","v":25627.017891732128},null,{"$f":"PILs!Q35","v":27196.385415007997},null,{"$f":"PILs!R35","v":28528.121073031798},null,{"$f":"PILs!S35","v":29641.235415023712},null,{"$f":"PILs!T35","v":30553.218146266277}]
[]
[null,"Provincial Rate Protection - Revenue Requirement",null,{"$f":"SUM(D20:D24)","v":4455.0500123004649},null,{"$f":"SUM(F20:F24)","v":28012.879920062951},null,{"$f":"SUM(H20:H24)","v":87787.743589008271},null,{"$f":"SUM(J20:J24)","v":155753.63366329129},null,{"$f":"SUM(L20:L24)","v":237586.54889744666},null,{"$f":"SUM(N20:N24)","v":278694.10721931839},null,{"$f":"SUM(P20:P24)","v":272792.22369428183},null,{"$f":"SUM(R20:R24)","v":271059.581385269},null,{"$f":"SUM(T20:T24)","v":266079.19364528783},null,{"$f":"SUM(V20:V24)","v":260516.63980962665},null,{"$f":"SUM(X20:X24)","v":256894.31603048395},null,{"$f":"SUM(Z20:Z24)","v":252940.28622054483},null,{"$f":"SUM(AB20:AB24)","v":248681.08686227308},null,{"$f":"SUM(AD20:AD24)","v":244141.13151953527},null,{"$f":"SUM(AF20:AF24)","v":239342.8806710887},null,{"$f":"SUM(AH20:AH24)","v":234306.99795739003},null,{"$f":"SUM(AJ20:AJ24)","v":229052.49392765955},null,{"$f":"SUM(AL20:AL24)","v":223596.85828717964}]

{"sheet":"PILs","index":2,"n_rows":35,"n_cols":20,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,"PowerStream Inc"]
[null,"Renewable Generation Connection Rate Protection "]
[null,"Compensation Amounts under Ontario Regulation 330/09"]
[null,"PILs Calculation"]
[]
[null,null,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,{"$f":"+M6+1","v":2021},{"$f":"+N6+1","v":2022},2023,2024,2025,2026,2027]
[null,"INCOME TAX"]
[null,"Net Income",1283.5114530000001,8829.1251926500008,23963.373022904045,48507.561196607479,77362.067074432169,93556.894594027195,95843.762081288703,93040.522952572384,89062.78340100123,85146.288378190031,81260.410520093719,{"$f":"'Revenue Requirement'!Z19","v":77374.532661997393},{"$f":"'Revenue Requirement'!AB19","v":73488.654803901081},{"$f":"'Revenue Requirement'!AD19","v":69602.77694580477},{"$f":"'Revenue Requirement'!AF19","v":65716.899087708443},{"$f":"'Revenue Requirement'!AH19","v":61831.021229612117},{"$f":"'Revenue Requirement'!AJ19","v":57945.143371515805},{"$f":"'Revenue Requirement'!AL19","v":54059.265513419479}]
[null,"Amortization ",1980.6833333333332,20336.223055555554,50132.234556551703,73341.630718106491,104658.83639537368,118981.58480689029,109962.24230689029,107751.79880689029,106105.16633134487,104459.08220689028,104459.08220689028,{"$f":"'Revenue Requirement'!Z23","v":104459.08220689028},{"$f":"'Revenue Requirement'!AB23","v":104459.08220689028},{"$f":"'Revenue Requirement'!AD23","v":104459.08220689028},{"$f":"'Revenue Requirement'!AF23","v":104459.08220689028},{"$f":"'Revenue Requirement'!AH23","v":104459.08220689028},{"$f":"'Revenue Requirement'!AJ23","v":104459.08220689028},{"$f":"'Revenue Requirement'!AL23","v":104459.08220689028}]
[null,"CCA",-3649.7000000000003,-55549.864000000001,-105645.60095799764,-118479.84173735781,-172505.52131469958,-203921.30680385162,-184608.36531554349,-169839.69609030001,-156252.52040307599,-143752.31877082994,-132252.13326916352,{"$f":"-'Avg Nt Fix Ass &UCC'!O124-'Avg Nt Fix Ass &UCC'!O138","v":-121671.96260763044},{"$f":"-'Avg Nt Fix Ass &UCC'!P124-'Avg Nt Fix Ass &UCC'!P138","v":-111938.20559902},{"$f":"-'Avg Nt Fix Ass &UCC'!Q124-'Avg Nt Fix Ass &UCC'!Q138","v":-102983.14915109839},{"$f":"-'Avg Nt Fix Ass &UCC'!R124-'Avg Nt Fix Ass &UCC'!R138","v":-94744.497219010518},{"$f":"-'Avg Nt Fix Ass &UCC'!S124-'Avg Nt Fix Ass &UCC'!S138","v":-87164.937441489674},{"$f":"-'Avg Nt Fix Ass &UCC'!T124-'Avg Nt Fix Ass &UCC'!T138","v":-80191.742446170509},{"$f":"-'Avg Nt Fix Ass &UCC'!U124-'Avg Nt Fix Ass &UCC'!U138","v":-73776.40305047686}]
[null,"Change in taxable income",{"$f":"SUM(C8:C10)","v":-385.5052136666668},-26384.515751794446,-31549.993378541898,3369.3501773561584,9515.3821551062574,8617.172597065859,{"$f":"SUM(I8:I10)","v":21197.639072635502},30952.625669162662,38915.429329270119,45853.051814250357,53467.359457820479,60161.65226125723,{"$f":"SUM(O8:O10)","v":66009.531411771371},71078.710001596657,75431.484075588203,79125.165995012721,82212.48313223556,{"$f":"SUM(T8:T10)","v":84741.944669832883}]
[null,"Tax Rate",0.28249999999999997,0.28249999999999997,0.26500000000000001,0.26500000000000001,0.26500000000000001,0.26500000000000001,0.26500000000000001,0.26500000000000001,0.26500000000000001,0.26500000000000001,0.26500000000000001,{"$f":"M12","v":0.26500000000000001},{"$f":"N12","v":0.26500000000000001},0.26500000000000001,0.26500000000000001,0.26500000000000001,0.26500000000000001,0.26500000000000001]
[null,"Income Taxes Payable",{"$f":"C11*C12","v":-108.90522286083336},-7453.6256998819308,-8360.7482453136035,892.87779699938199,2521.5762711031584,2283.5507382224528,{"$f":"I11*I12","v":5617.3743542484081},8202.4458023281059,10312.588772256582,12151.058730776345,14168.850256322428,15942.837849233167,{"$f":"O11*O12","v":17492.525824119413},18835.858150423115,19989.343280030876,20968.168988678372,21786.308030042426,{"$f":"T11*T12","v":22456.615337505715}]
[]
[null,"ONTARIO CAPITAL TAX"]
[null,"Closing Net Fixed Assets",80119.316666666666,471012.09361111111,1024828.9190545594,1691159.9497364527,2640422.7531992793,2597925.2083923882,2554965.226085498,2447213.4272786081,2341108.2609472633,2236649.1787403729,2132190.0965334829,{"$f":"'Avg Nt Fix Ass &UCC'!O111","v":2027731.014326592},{"$f":"'Avg Nt Fix Ass &UCC'!P111","v":1923271.932119702},{"$f":"'Avg Nt Fix Ass &UCC'!Q111","v":1818812.8499128115},{"$f":"'Avg Nt Fix Ass &UCC'!R111","v":1714353.7677059213},{"$f":"'Avg Nt Fix Ass &UCC'!S111","v":1609894.6854990309},{"$f":"'Avg Nt Fix Ass &UCC'!T111","v":1505435.6032921409},{"$f":"'Avg Nt Fix Ass &UCC'!U111","v":1400976.5210852507}]
[null,"Less: Exemption",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Deemed Taxable Capital",{"$f":"C16-C17","v":80119.316666666666},471012.09361111111,1024828.9190545594,1691159.9497364527,2640422.7531992793,2597925.2083923882,{"$f":"I16-I17","v":2554965.226085498},2447213.4272786081,2341108.2609472633,2236649.1787403729,2132190.0965334829,2027731.014326592,{"$f":"O16-O17","v":1923271.932119702},1818812.8499128115,1714353.7677059213,1609894.6854990309,1505435.6032921409,{"$f":"T16-T17","v":1400976.5210852507}]
[null,"Ontario Capital Tax Rate"]
[null,"Net Amount (Taxable Capital x Rate)",{"$f":"C18*C19","v":0},0,0,0,0,0,{"$f":"I18*I19","v":0},0,0,0,0,0,{"$f":"O18*O19","v":0},0,0,0,0,{"$f":"T18*T19","v":0}]
[]
[]
[null,"Gross Up",2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,{"$f":"N6","v":2021},{"$f":"O6","v":2022},2023,2024,2025,2026,{"$f":"T6","v":2027}]
[null,null,"PILs Payable","PILs Payable","PILs Payable","PILs Payable","PILs Payable","PILs Payable","PILs Payable","PILs Payable","PILs Payable","PILs Payable","PILs Payable","PILs Payable","PILs Payable","PILs Payable","PILs Payable","PILs Payable","PILs Payable","PILs Payable"]
[null,"Change in Income Taxes Payable",{"$f":"C13","v":-108.90522286083336},-7453.6256998819308,-8360.7482453136035,892.87779699938199,2521.5762711031584,2283.5507382224528,{"$f":"I13","v":5617.3743542484081},8202.4458023281059,10312.588772256582,12151.058730776345,14168.850256322428,15942.837849233167,{"$f":"O13","v":17492.525824119413},18835.858150423115,19989.343280030876,20968.168988678372,21786.308030042426,{"$f":"T13","v":22456.615337505715}]
[null,"Change in OCT",{"$f":"C20","v":0},0,0,0,0,0,{"$f":"I20","v":0},0,0,0,0,0,{"$f":"O20","v":0},0,0,0,0,{"$f":"T20","v":0}]
[null,"PIL's",{"$f":"SUM(C25:C26)","v":-108.90522286083336},-7453.6256998819308,-8360.7482453136035,892.87779699938199,2521.5762711031584,2283.5507382224528,{"$f":"SUM(I25:I26)","v":5617.3743542484081},8202.4458023281059,10312.588772256582,12151.058730776345,14168.850256322428,15942.837849233167,{"$f":"SUM(O25:O26)","v":17492.525824119413},18835.858150423115,19989.343280030876,20968.168988678372,21786.308030042426,{"$f":"SUM(T25:T26)","v":22456.615337505715}]
[]
[]
[]
[null,null,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,{"$f":"N23","v":2021},{"$f":"O23","v":2022},2023,2024,2025,2026,{"$f":"T23","v":2027}]
[null,null,"Grossed Up PILs","Grossed Up PILs","Grossed Up PILs","Grossed Up PILs","Grossed Up PILs","Grossed Up PILs","Grossed Up PILs","Grossed Up PILs","Grossed Up PILs","Grossed Up PILs","Grossed Up PILs","Grossed Up PILs","Grossed Up PILs","Grossed Up PILs","Grossed Up PILs","Grossed Up PILs","Grossed Up PILs","Grossed Up PILs"]
[null,"Change in Income Taxes Payable",{"$f":"C25/(1-C12)","v":-151.7842827328688},-10388.328501577604,-11375.16768069878,1214.799723808683,3430.7160151063381,3106.8717526836094,{"$f":"I25/(1-I12)","v":7642.686196256338},11159.790207249123,14030.733023478344,16532.052694933802,19277.347287513508,21690.935849296828,{"$f":"O25/(1-O12)","v":23799.354862747503},25627.017891732128,27196.385415007997,28528.121073031798,29641.235415023712,{"$f":"T25/(1-T12)","v":30553.218146266277}]
[null,"Change in OCT",{"$f":"C20","v":0},0,0,0,0,0,{"$f":"I20","v":0},0,0,0,0,0,{"$f":"O20","v":0},0,0,0,0,{"$f":"T20","v":0}]
[null,"PIL's",{"$f":"SUM(C33:C34)","v":-151.7842827328688},-10388.328501577604,-11375.16768069878,1214.799723808683,3430.7160151063381,3106.8717526836094,{"$f":"SUM(I33:I34)","v":7642.686196256338},11159.790207249123,14030.733023478344,16532.052694933802,19277.347287513508,21690.935849296828,{"$f":"SUM(O33:O34)","v":23799.354862747503},25627.017891732128,27196.385415007997,28528.121073031798,29641.235415023712,{"$f":"SUM(T33:T34)","v":30553.218146266277}]

{"sheet":"Avg Nt Fix Ass &UCC","index":3,"n_rows":160,"n_cols":21,"rows_kept":160,"cut":false,"hidden":false,"merged":[]}
[null,"PowerStream Inc"]
[null,"Renewable Generation Connection Rate Protection "]
[null,"Compensation Amounts under Ontario Regulation 330/09"]
[null,"Average Net Fixed Assets"]
[]
[null,null,null,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,{"$f":"+N6+1","v":2021},{"$f":"+O6+1","v":2022},2023,2024,2025,2026,2027]
[1818,"Net Fixed Assets/1818/1821"]
[null,null,"Years"]
[null,"Opening Capital Investment",null,0,{"$f":"D11","v":30624},165213,466517.64385888673,885216.61279980373,1316371.3099092154,1316371.3099092154,1316371.3099092154,1316371.3099092154,1316371.3099092154,1316371.3099092154,1316371.3099092154,{"$f":"O11","v":1316371.3099092154},{"$f":"P11","v":1316371.3099092154},{"$f":"Q11","v":1316371.3099092154},{"$f":"R11","v":1316371.3099092154},{"$f":"S11","v":1316371.3099092154},1316371.3099092154]
[null,"Capital Investment",null,30624,134589,301304.64385888673,418698.96894091694,431154.69710941176,0,0]
[null,"Closing Capital Investment",null,{"$f":"SUM(D9:D10)","v":30624},165213,466517.64385888673,885216.61279980373,1316371.3099092154,1316371.3099092154,{"$f":"SUM(J9:J10)","v":1316371.3099092154},1316371.3099092154,1316371.3099092154,1316371.3099092154,1316371.3099092154,1316371.3099092154,{"$f":"SUM(P9:P10)","v":1316371.3099092154},1316371.3099092154,1316371.3099092154,1316371.3099092154,1316371.3099092154,{"$f":"SUM(U9:U10)","v":1316371.3099092154}]
[]
[null,"Opening Accumulated Amortization",null,0,{"$f":"D16","v":382.8},2830.7624999999998,10727.395548236083,27624.073756469712,55143.92279033245,88053.205538062844,120962.48828579322,153871.7710335236,186781.05378125398,219690.33652898436,252599.61927671474,{"$f":"O16","v":285508.90202444512},{"$f":"P16","v":318418.1847721755},{"$f":"Q16","v":351327.46751990588},{"$f":"R16","v":384236.75026763626},{"$f":"S16","v":417146.03301536664},450055.31576309702]
[null,"Amortization Year One",40,{"$f":"D10/$C14/2","v":382.8},{"$f":"E10/$C14/2","v":1682.3625},3766.3080482360842,5233.7371117614621,5389.4337138676474,0,{"$f":"J10/$C14/2","v":0},0,0,0,0,0,{"$f":"P10/$C14/2","v":0},0,0,0,0,{"$f":"U10/$C14/2","v":0}]
[null,"Amortization Thereafter",40,{"$f":"D9/$C15","v":0},765.6,4130.3249999999998,{"$f":"G9/$C15","v":11662.941096472168},22130.415319995092,32909.282747730387,{"$f":"J9/$C15","v":32909.282747730387},32909.282747730387,32909.282747730387,32909.282747730387,32909.282747730387,32909.282747730387,{"$f":"P9/$C15","v":32909.282747730387},32909.282747730387,32909.282747730387,32909.282747730387,32909.282747730387,{"$f":"U9/$C15","v":32909.282747730387}]
[null,"Closing Accumulated Amortization",null,{"$f":"SUM(D13:D15)","v":382.8},2830.7624999999998,10727.395548236083,27624.073756469712,55143.92279033245,88053.205538062844,{"$f":"SUM(J13:J15)","v":120962.48828579322},153871.7710335236,186781.05378125398,219690.33652898436,252599.61927671474,285508.90202444512,{"$f":"SUM(P13:P15)","v":318418.1847721755},351327.46751990588,384236.75026763626,417146.03301536664,450055.31576309702,{"$f":"SUM(U13:U15)","v":482964.5985108274}]
[]
[null,"Opening Net Fixed Assets",null,{"$f":"D9-D13","v":0},30241.200000000001,162382.23749999999,{"$f":"G9-G13","v":455790.24831065064},857592.53904333396,1261227.387118883,{"$f":"J9-J13","v":1228318.1043711526},1195408.8216234222,1162499.5388756918,1129590.2561279614,1096680.9733802311,1063771.6906325007,{"$f":"P9-P13","v":1030862.4078847703},997953.12513703993,965043.84238930955,932134.55964157917,899225.27689384879,{"$f":"U9-U13","v":866315.99414611841}]
[null,"Closing Net Fixed Assets",null,{"$f":"D11-D16","v":30241.200000000001},162382.23749999999,455790.24831065064,{"$f":"G11-G16","v":857592.53904333396},1261227.387118883,1228318.1043711526,{"$f":"J11-J16","v":1195408.8216234222},1162499.5388756918,1129590.2561279614,1096680.9733802311,1063771.6906325007,1030862.4078847703,{"$f":"P11-P16","v":997953.12513703993},965043.84238930955,932134.55964157917,899225.27689384879,866315.99414611841,{"$f":"U11-U16","v":833406.71139838803}]
[null,"Average Net Fixed Assets",null,{"$f":"SUM(D18:D19)/2","v":15120.6},96311.71875,309086.24290532531,656691.39367699227,1059409.9630811084,1244772.7457450177,{"$f":"SUM(J18:J19)/2","v":1211863.4629972875},1178954.1802495569,1146044.8975018268,1113135.6147540961,1080226.332006366,1047317.0492586355,{"$f":"SUM(P18:P19)/2","v":1014407.7665109051},981498.48376317474,948589.20101544436,915679.91826771398,882770.6355199836,{"$f":"SUM(U18:U19)/2","v":849861.35277225322}]
[]
[]
[null,null,null,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,{"$f":"O6","v":2021},{"$f":"P6","v":2022},2023,2024,2025,2026,{"$f":"U6","v":2027}]
[1925,"Net Fixed Assets/Software"]
[]
[null,"Opening Capital Investment",null,0,{"$f":"D28","v":795},71358,102441.26886521225,102441.26886521225,115612.13526521224,115612.13526521224,115612.13526521224,115612.13526521224,115612.13526521224,115612.13526521224,115612.13526521224,{"$f":"O28","v":115612.13526521224},{"$f":"P28","v":115612.13526521224},{"$f":"Q28","v":115612.13526521224},{"$f":"R28","v":115612.13526521224},{"$f":"S28","v":115612.13526521224},115612.13526521224]
[null,"Capital Investment",null,795,70563,31083.268865212238,0,13170.866400000001,0,0]
[null,"Closing Capital Investment",null,{"$f":"SUM(D26:D27)","v":795},71358,102441.26886521225,102441.26886521225,115612.13526521224,115612.13526521224,{"$f":"SUM(J26:J27)","v":115612.13526521224},115612.13526521224,115612.13526521224,115612.13526521224,115612.13526521224,115612.13526521224,{"$f":"SUM(P26:P27)","v":115612.13526521224},115612.13526521224,115612.13526521224,115612.13526521224,115612.13526521224,{"$f":"SUM(U26:U27)","v":115612.13526521224}]
[]
[null,"Opening Accumulated Amortization",null,0,{"$f":"D33","v":99.375},9118.5,30843.408608151531,56453.725824454596,83710.401340757657,103495.11794075766,110673.33454075766,113966.05114075766,115612.13526521224,115612.13526521224,115612.13526521224,{"$f":"O33","v":115612.13526521224},{"$f":"P33","v":115612.13526521224},{"$f":"Q33","v":115612.13526521224},{"$f":"R33","v":115612.13526521224},{"$f":"S33","v":115612.13526521224},115612.13526521224]
[null,"Amortization Year One",4,{"$f":"D27/$C31/2","v":99.375},{"$f":"E27/$C31/2","v":8820.375},{"$f":"F27/$C31/2","v":3885.4086081515297},{"$f":"G27/$C31/2","v":0},{"$f":"H27/$C31/2","v":1646.3583000000001},{"$f":"I27/$C31/2","v":0},0,0,0,0,0,{"$f":"O27/$C31/2","v":0},{"$f":"P27/$C31/2","v":0},0,0,0,0,{"$f":"U27/$C31/2","v":0}]
[null,"Amortization Thereafter",4,{"$f":"D26/$C32","v":0},{"$f":"E26/$C32","v":198.75},{"$f":"F26/$C32","v":17839.5},{"$f":"G26/$C32","v":25610.317216303061},{"$f":"H26/$C32","v":25610.317216303061},{"$f":"8721+7771+H27/4","v":19784.7166},{"$f":"3885.5+H27/4","v":7178.2165999999997},{"$f":"H27/4","v":3292.7166000000002},{"$f":"K36","v":1646.0841244545882},0,0,0,0,0,0,0,0,0]
[null,"Closing Accumulated Amortization",null,{"$f":"SUM(D30:D32)","v":99.375},9118.5,30843.408608151531,56453.725824454596,83710.401340757657,103495.11794075766,{"$f":"SUM(J30:J32)","v":110673.33454075766},113966.05114075766,115612.13526521224,115612.13526521224,115612.13526521224,115612.13526521224,{"$f":"SUM(P30:P32)","v":115612.13526521224},115612.13526521224,115612.13526521224,115612.13526521224,115612.13526521224,{"$f":"SUM(U30:U32)","v":115612.13526521224}]
[]
[null,"Opening Net Fixed Assets",null,{"$f":"D26-D30","v":0},{"$f":"E26-E30","v":695.625},{"$f":"F26-F30","v":62239.5},{"$f":"G26-G30","v":71597.860257060718},{"$f":"H26-H30","v":45987.54304075765},{"$f":"I26-I30","v":31901.733924454587},12117.017324454588,4938.8007244545879,1646.0841244545882,0,0,{"$f":"O26-O30","v":0},{"$f":"P26-P30","v":0},0,0,0,0,{"$f":"U26-U30","v":0}]
[null,"Closing Net Fixed Assets",null,{"$f":"D28-D33","v":695.625},{"$f":"E28-E33","v":62239.5},{"$f":"F28-F33","v":71597.860257060718},{"$f":"G28-G33","v":45987.54304075765},{"$f":"H28-H33","v":31901.733924454587},{"$f":"I28-I33","v":12117.017324454588},{"$f":"J28-J33","v":4938.8007244545879},1646.0841244545882,0,0,0,{"$f":"O28-O33","v":0},{"$f":"P28-P33","v":0},0,0,0,0,{"$f":"U28-U33","v":0}]
[null,"Average Net Fixed Assets",null,{"$f":"SUM(D35:D36)/2","v":347.8125},31467.5625,66918.680128530366,58792.701648909184,38944.638482606118,22009.375624454588,{"$f":"SUM(J35:J36)/2","v":8527.9090244545878},3292.442424454588,823.04206222729408,0,0,0,{"$f":"SUM(P35:P36)/2","v":0},0,0,0,0,{"$f":"SUM(U35:U36)/2","v":0}]
[]
[]
[null,null,null,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,{"$f":"O23","v":2021},{"$f":"P23","v":2022},2023,2024,2025,2026,{"$f":"U23","v":2027}]
[1981,"Net Fixed Assets /1981"]
[]
[null,"Opening Capital Investment",null,0,{"$f":"D45","v":27778},134226,215957.58234187588,246682.43336246719,451389.38145121036,451389.38145121036,451389.38145121036,451389.38145121036,451389.38145121036,451389.38145121036,451389.38145121036,{"$f":"O45","v":451389.38145121036},{"$f":"P45","v":451389.38145121036},{"$f":"Q45","v":451389.38145121036},{"$f":"R45","v":451389.38145121036},{"$f":"S45","v":451389.38145121036},451389.38145121036]
[null,"Capital Investment",null,27778,106448,81731.582341875866,30724.851020591312,204706.94808874317,0,0]
[null,"Closing Capital Investment",null,{"$f":"SUM(D43:D44)","v":27778},134226,215957.58234187588,246682.43336246719,451389.38145121036,451389.38145121036,{"$f":"SUM(J43:J44)","v":451389.38145121036},451389.38145121036,451389.38145121036,451389.38145121036,451389.38145121036,451389.38145121036,{"$f":"SUM(P43:P44)","v":451389.38145121036},451389.38145121036,451389.38145121036,451389.38145121036,451389.38145121036,{"$f":"SUM(U43:U44)","v":451389.38145121036}]
[]
[null,"Opening Accumulated Amortization",null,0,{"$f":"D50","v":925.93333333333328},6326.0666666666666,17998.852744729193,33420.186601540627,56689.247095329876,86781.872525410567,116874.49795549126,146967.12338557193,177059.74881565262,207152.37424573331,237244.999675814,{"$f":"O50","v":267337.62510589469},{"$f":"P50","v":297430.25053597538},{"$f":"Q50","v":327522.87596605608},{"$f":"R50","v":357615.50139613677},{"$f":"S50","v":387708.12682621746},417800.75225629815]
[null,"Amortization Year One",15,{"$f":"D44/$C48/2","v":925.93333333333328},3548.2666666666669,2724.3860780625287,1024.1617006863771,6823.5649362914392,0,{"$f":"J44/$C48/2","v":0},0,0,0,0,0,{"$f":"P44/$C48/2","v":0},0,0,0,0,{"$f":"U44/$C48/2","v":0}]
[null,"Amortization Thereafter",15,{"$f":"D43/$C49","v":0},1851.8666666666666,8948.4,14397.172156125058,16445.495557497812,30092.62543008069,{"$f":"J43/$C49","v":30092.62543008069},30092.62543008069,30092.62543008069,30092.62543008069,30092.62543008069,30092.62543008069,{"$f":"P43/$C49","v":30092.62543008069},30092.62543008069,30092.62543008069,30092.62543008069,30092.62543008069,{"$f":"U43/$C49","v":30092.62543008069}]
[null,"Closing Accumulated Amortization",null,{"$f":"SUM(D47:D49)","v":925.93333333333328},6326.0666666666666,17998.852744729193,33420.186601540627,56689.247095329876,86781.872525410567,{"$f":"SUM(J47:J49)","v":116874.49795549126},146967.12338557193,177059.74881565262,207152.37424573331,237244.999675814,267337.62510589469,{"$f":"SUM(P47:P49)","v":297430.25053597538},327522.87596605608,357615.50139613677,387708.12682621746,417800.75225629815,{"$f":"SUM(U47:U49)","v":447893.37768637884}]
[]
[null,"Opening Net Fixed Assets",null,{"$f":"D43-D47","v":0},26852.066666666666,127899.93333333333,197958.72959714668,213262.24676092656,394700.13435588049,{"$f":"J43-J47","v":364607.5089257998},334514.88349571911,304422.25806563842,274329.63263555773,244237.00720547704,214144.38177539635,{"$f":"P43-P47","v":184051.75634531566},153959.13091523497,123866.50548515428,93773.88005507359,63681.2546249929,{"$f":"U43-U47","v":33588.62919491221}]
[null,"Closing Net Fixed Assets",null,{"$f":"D45-D50","v":26852.066666666666},127899.93333333333,197958.72959714668,213262.24676092656,394700.13435588049,364607.5089257998,{"$f":"J45-J50","v":334514.88349571911},304422.25806563842,274329.63263555773,244237.00720547704,214144.38177539635,184051.75634531566,{"$f":"P45-P50","v":153959.13091523497},123866.50548515428,93773.88005507359,63681.2546249929,33588.62919491221,{"$f":"U45-U50","v":3496.0037648315192}]
[null,"Average Net Fixed Assets",null,{"$f":"SUM(D52:D53)/2","v":13426.033333333333},77376,162929.33146524001,205610.48817903662,303981.1905584035,379653.82164084015,{"$f":"SUM(J52:J53)/2","v":349561.19621075946},319468.57078067877,289375.94535059808,259283.31992051739,229190.6944904367,199098.06906035601,{"$f":"SUM(P52:P53)/2","v":169005.44363027532},138912.81820019463,108820.19277011394,78727.567340033245,48634.941909952555,{"$f":"SUM(U52:U53)/2","v":18542.316479871864}]
[]
[]
[null,null,null,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,{"$f":"O40","v":2021},{"$f":"P40","v":2022},2023,2024,2025,2026,{"$f":"U40","v":2027}]
[1822,"Net Fixed Assets /P&C systems"]
[]
[null,"Opening Capital Investment",null,0,{"$f":"D62","v":22903},110667,178047.11924409258,203379.00657754994,434743.72816078353,511227.76816078351,578230.02816078346,578230.02816078346,578230.02816078346,578230.02816078346,578230.02816078346,{"$f":"O62","v":578230.02816078346},{"$f":"P62","v":578230.02816078346},{"$f":"Q62","v":578230.02816078346},{"$f":"R62","v":578230.02816078346},{"$f":"S62","v":578230.02816078346},578230.02816078346]
[null,"Capital Investment",null,22903,87764,67380.119244092581,25331.887333457358,231364.72158323362,76484.039999999994,67002.259999999995]
[null,"Closing Capital Investment",null,{"$f":"SUM(D60:D61)","v":22903},110667,178047.11924409258,203379.00657754994,434743.72816078353,511227.76816078351,{"$f":"SUM(J60:J61)","v":578230.02816078346},578230.02816078346,578230.02816078346,578230.02816078346,578230.02816078346,578230.02816078346,{"$f":"SUM(P60:P61)","v":578230.02816078346},578230.02816078346,578230.02816078346,578230.02816078346,578230.02816078346,{"$f":"SUM(U60:U61)","v":578230.02816078346}]
[]
[null,"Opening Accumulated Amortization",null,{"$f":"C67","v":0},572.57500000000005,3911.8250000000003,11129.677981102315,20665.331126643378,36618.399495101716,{"$f":"I67","v":60267.686903140893},87504.131811180065,116415.63321921923,145327.13462725841,174238.63603529759,203150.13744333677,{"$f":"O67","v":232061.63885137596},{"$f":"P67","v":260973.14025941514},{"$f":"Q67","v":289884.64166745433},{"$f":"R67","v":318796.14307549351},{"$f":"S67","v":347707.6444835327},376619.14589157188]
[null,"Amortization Year One",20,{"$f":"D61/$C65/2","v":572.57500000000005},2194.1,1684.5029811023146,633.29718333643393,5784.1180395808406,1912.1009999999999,{"$f":"J61/$C65/2","v":1675.0564999999999},0,0,0,0,0,{"$f":"P61/$C65/2","v":0},0,0,0,0,{"$f":"U61/$C65/2","v":0}]
[null,"Amortization Thereafter",20,{"$f":"D60/$C66","v":0},1145.1500000000001,5533.35,8902.3559622046287,10168.950328877498,21737.186408039175,{"$f":"J60/$C66","v":25561.388408039176},28911.501408039174,28911.501408039174,28911.501408039174,28911.501408039174,28911.501408039174,{"$f":"P60/$C66","v":28911.501408039174},28911.501408039174,28911.501408039174,28911.501408039174,28911.501408039174,{"$f":"U60/$C66","v":28911.501408039174}]
[null,"Closing Accumulated Amortization",null,{"$f":"SUM(D64:D66)","v":572.57500000000005},3911.8250000000003,11129.677981102315,20665.331126643378,36618.399495101716,60267.686903140893,{"$f":"SUM(J64:J66)","v":87504.131811180065},116415.63321921923,145327.13462725841,174238.63603529759,203150.13744333677,232061.63885137596,{"$f":"SUM(P64:P66)","v":260973.14025941514},289884.64166745433,318796.14307549351,347707.6444835327,376619.14589157188,{"$f":"SUM(U64:U66)","v":405530.64729961107}]
[]
[null,"Opening Net Fixed Assets",null,{"$f":"D60-D64","v":0},22330.424999999999,106755.175,166917.44126299027,182713.67545090656,398125.32866568182,{"$f":"J60-J64","v":450960.0812576426},490725.89634960343,461814.39494156424,432902.89353352506,403991.39212548587,375079.89071744669,{"$f":"P60-P64","v":346168.3893094075},317256.88790136832,288345.38649332913,259433.88508528995,230522.38367725076,{"$f":"U60-U64","v":201610.88226921158}]
[null,"Closing Net Fixed Assets",null,{"$f":"D62-D67","v":22330.424999999999},106755.175,166917.44126299027,182713.67545090656,398125.32866568182,450960.0812576426,{"$f":"J62-J67","v":490725.89634960343},461814.39494156424,432902.89353352506,403991.39212548587,375079.89071744669,346168.3893094075,{"$f":"P62-P67","v":317256.88790136832},288345.38649332913,259433.88508528995,230522.38367725076,201610.88226921158,{"$f":"U62-U67","v":172699.38086117239}]
[null,"Average Net Fixed Assets",null,{"$f":"SUM(D69:D70)/2","v":11165.2125},64542.8,136836.30813149514,174815.55835694843,290419.50205829419,424542.70496166218,{"$f":"SUM(J69:J70)/2","v":470842.98880362301},476270.14564558386,447358.64423754462,418447.14282950549,389535.64142146625,360624.14001342712,{"$f":"SUM(P69:P70)/2","v":331712.63860538788},302801.13719734875,273889.63578930951,244978.13438127036,216066.63297323117,{"$f":"SUM(U69:U70)/2","v":187155.13156519199}]
[]
[]
[null,null,null,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,{"$f":"O57","v":2021},{"$f":"P57","v":2022},2023,2024,2025,2026,{"$f":"U57","v":2027}]
[1912,"Net Fixed Assets /1912"]
[]
[null,"Opening Capital Investment",null,0,{"$f":"D79","v":0},1873,1873,43701.992753426486,82005.385249765066,82005.385249765066,82005.385249765066,82005.385249765066,82005.385249765066,82005.385249765066,82005.385249765066,{"$f":"O79","v":82005.385249765066},{"$f":"P79","v":82005.385249765066},{"$f":"Q79","v":82005.385249765066},{"$f":"R79","v":82005.385249765066},{"$f":"S79","v":82005.385249765066},82005.385249765066]
[null,"Capital Investment",null,0,1873,0,41828.992753426486,38303.39249633858,0,0]
[null,"Closing Capital Investment",null,{"$f":"SUM(D77:D78)","v":0},1873,1873,43701.992753426486,82005.385249765066,82005.385249765066,{"$f":"SUM(J77:J78)","v":82005.385249765066},82005.385249765066,82005.385249765066,82005.385249765066,82005.385249765066,82005.385249765066,{"$f":"SUM(P77:P78)","v":82005.385249765066},82005.385249765066,82005.385249765066,82005.385249765066,82005.385249765066,{"$f":"SUM(U77:U78)","v":82005.385249765066}]
[]
[null,"Opening Accumulated Amortization",null,{"$f":"C84","v":0},0,18.73,56.19,511.93992753426483,1769.0137075661803,{"$f":"I84","v":3409.1214125614815},5049.2291175567825,6689.3368225520835,8329.4445275473845,9969.5522325426864,11609.659937537988,{"$f":"O84","v":13249.76764253329},{"$f":"P84","v":14889.875347528592},{"$f":"Q84","v":16529.983052523894},{"$f":"R84","v":18170.090757519196},{"$f":"S84","v":19810.198462514498},21450.3061675098]
[null,"Amortization Year One",50,{"$f":"D78/$C82/2","v":0},18.73,0,418.28992753426485,383.0339249633858,0,{"$f":"J78/$C82/2","v":0},0,0,0,0,0,{"$f":"P78/$C82/2","v":0},0,0,0,0,{"$f":"U78/$C82/2","v":0}]
[null,"Amortization Thereafter",50,{"$f":"D77/$C83","v":0},0,37.46,37.46,874.03985506852973,1640.1077049953012,{"$f":"J77/$C83","v":1640.1077049953012},1640.1077049953012,1640.1077049953012,1640.1077049953012,1640.1077049953012,1640.1077049953012,{"$f":"P77/$C83","v":1640.1077049953012},1640.1077049953012,1640.1077049953012,1640.1077049953012,1640.1077049953012,{"$f":"U77/$C83","v":1640.1077049953012}]
[null,"Closing Accumulated Amortization",null,{"$f":"SUM(D81:D83)","v":0},18.73,56.19,511.93992753426483,1769.0137075661803,3409.1214125614815,{"$f":"SUM(J81:J83)","v":5049.2291175567825},6689.3368225520835,8329.4445275473845,9969.5522325426864,11609.659937537988,13249.76764253329,{"$f":"SUM(P81:P83)","v":14889.875347528592},16529.983052523894,18170.090757519196,19810.198462514498,21450.3061675098,{"$f":"SUM(U81:U83)","v":23090.413872505102}]
[]
[null,"Opening Net Fixed Assets",null,{"$f":"D77-D81","v":0},0,1854.27,1816.81,43190.05282589222,80236.371542198889,{"$f":"J77-J81","v":78596.263837203587},76956.156132208285,75316.048427212983,73675.940722217681,72035.83301722238,70395.725312227078,{"$f":"P77-P81","v":68755.617607231776},67115.509902236474,65475.402197241172,63835.29449224587,62195.186787250568,{"$f":"U77-U81","v":60555.079082255266}]
[null,"Closing Net Fixed Assets",null,{"$f":"D79-D84","v":0},1854.27,1816.81,43190.05282589222,80236.371542198889,78596.263837203587,{"$f":"J79-J84","v":76956.156132208285},75316.048427212983,73675.940722217681,72035.83301722238,70395.725312227078,68755.617607231776,{"$f":"P79-P84","v":67115.509902236474},65475.402197241172,63835.29449224587,62195.186787250568,60555.079082255266,{"$f":"U79-U84","v":58914.971377259964}]
[null,"Average Net Fixed Assets",null,{"$f":"SUM(D86:D87)/2","v":0},927.13499999999999,1835.54,22503.431412946109,61713.212184045551,79416.317689701245,{"$f":"SUM(J86:J87)/2","v":77776.209984705929},76136.102279710642,74495.994574715325,72855.886869720038,71215.779164724721,69575.671459729434,{"$f":"SUM(P86:P87)/2","v":67935.563754734118},66295.45604973883,64655.348344743521,63015.240639748219,61375.132934752917,{"$f":"SUM(U86:U87)/2","v":59735.025229757615}]
[]
[]
[null,null,null,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,{"$f":"O74","v":2021},{"$f":"P74","v":2022},2023,2024,2025,2026,{"$f":"U74","v":2027}]
[1845,"Net Fixed Assets /1845"]
[]
[null,"Opening Capital Investment",null,0,{"$f":"D96","v":0},9992,132441.4456899325,355529.40704154037,490750.42122201301,490750.42122201301,490750.42122201301,490750.42122201301,490750.42122201301,490750.42122201301,490750.42122201301,{"$f":"O96","v":490750.42122201301},{"$f":"P96","v":490750.42122201301},{"$f":"Q96","v":490750.42122201301},{"$f":"R96","v":490750.42122201301},{"$f":"S96","v":490750.42122201301},490750.42122201301]
[null,"Capital Investment",null,0,9992,122449.44568993252,223087.9613516079,135221.01418047264,0,0]
[null,"Closing Capital Investment",null,{"$f":"SUM(D94:D95)","v":0},9992,132441.4456899325,355529.40704154037,490750.42122201301,490750.42122201301,{"$f":"SUM(J94:J95)","v":490750.42122201301},490750.42122201301,490750.42122201301,490750.42122201301,490750.42122201301,490750.42122201301,{"$f":"SUM(P94:P95)","v":490750.42122201301},490750.42122201301,490750.42122201301,490750.42122201301,490750.42122201301,{"$f":"SUM(U94:U95)","v":490750.42122201301}]
[]
[null,"Opening Accumulated Amortization",null,0,{"$f":"D101","v":0},111.02222222222223,1693.6160632214724,7115.5144269045049,16518.623629832873,27424.188545877609,38329.753461922344,49235.31837796708,60140.883294011815,71046.448210056551,81952.013126101287,{"$f":"O101","v":92857.578042146022},{"$f":"P101","v":103763.14295819076},{"$f":"Q101","v":114668.70787423549},{"$f":"R101","v":125574.27279028023},{"$f":"S101","v":136479.83770632496},147385.4026223697]
[null,"Amortization Year One",45,{"$f":"D95/$C99/2","v":0},111.02222222222223,1360.5493965548058,2478.7551261289768,1502.4557131163626,0,{"$f":"J95/$C99/2","v":0},0,0,0,0,0,{"$f":"P95/$C99/2","v":0},0,0,0,0,{"$f":"U95/$C99/2","v":0}]
[null,"Amortization Thereafter",45,{"$f":"D94/$C100","v":0},0,222.04444444444445,2943.1432375540558,7900.653489812008,10905.564916044734,{"$f":"J94/$C100","v":10905.564916044734},10905.564916044734,10905.564916044734,10905.564916044734,10905.564916044734,10905.564916044734,{"$f":"P94/$C100","v":10905.564916044734},10905.564916044734,10905.564916044734,10905.564916044734,10905.564916044734,{"$f":"U94/$C100","v":10905.564916044734}]
[null,"Closing Accumulated Amortization",null,{"$f":"SUM(D98:D100)","v":0},111.02222222222223,1693.6160632214724,7115.5144269045049,16518.623629832873,27424.188545877609,{"$f":"SUM(J98:J100)","v":38329.753461922344},49235.31837796708,60140.883294011815,71046.448210056551,81952.013126101287,92857.578042146022,{"$f":"SUM(P98:P100)","v":103763.14295819076},114668.70787423549,125574.27279028023,136479.83770632496,147385.4026223697,{"$f":"SUM(U98:U100)","v":158290.96753841444}]
[]
[null,"Opening Net Fixed Assets",null,{"$f":"D94-D98","v":0},0,9880.9777777777781,130747.82962671103,348413.89261463587,474231.79759218014,{"$f":"J94-J98","v":463326.23267613538},452420.66776009067,441515.10284404596,430609.5379280012,419703.97301195643,408798.40809591173,{"$f":"P94-P98","v":397892.84317986702},386987.27826382226,376081.71334777749,365176.14843173278,354270.58351568808,{"$f":"U94-U98","v":343365.01859964331}]
[null,"Closing Net Fixed Assets",null,{"$f":"D96-D101","v":0},9880.9777777777781,130747.82962671103,348413.89261463587,474231.79759218014,463326.23267613538,{"$f":"J96-J101","v":452420.66776009067},441515.10284404596,430609.5379280012,419703.97301195643,408798.40809591173,397892.84317986702,{"$f":"P96-P101","v":386987.27826382226},376081.71334777749,365176.14843173278,354270.58351568808,343365.01859964331,{"$f":"U96-U101","v":332459.45368359855}]
[null,"Average Net Fixed Assets",null,{"$f":"SUM(D103:D104)/2","v":0},4940.4888888888891,70314.403702244395,239580.86112067345,411322.84510340798,468779.01513415773,{"$f":"SUM(J103:J104)/2","v":457873.45021811302},446967.88530206832,436062.32038602361,425156.75546997879,414251.19055393408,403345.62563788937,{"$f":"SUM(P103:P104)/2","v":392440.06072184467},381534.49580579984,370628.93088975514,359723.36597371043,348817.80105766573,{"$f":"SUM(U103:U104)/2","v":337912.2361416209}]
[]
[null,"TOTALS"]
[null,"Additions",null,{"$f":"+D10+D27+D44+D61+D78+D95","v":82100},{"$f":"+E10+E27+E44+E61+E78+E95","v":411229},603949.05999999994,739672.66139999998,1053921.6398581997,76484.039999999994,67002.259999999995,0,0,0,0,{"$f":"+O10+O27+O44+O61+O78+O95","v":0},{"$f":"+P10+P27+P44+P61+P78+P95","v":0},0,0,0,0,{"$f":"+U10+U27+U44+U61+U78+U95","v":0}]
[null,"Average Net Fixed Assets",null,{"$f":"D20+D37+D54+D71+D88+D105","v":40059.658333333333},275565.70513888891,747920.5063328353,{"$f":"G20+G37+G54+G71+G88+G105","v":1357994.434395506},2165791.3514678655,2619173.9807958337,{"$f":"J20+J37+J54+J71+J88+J105","v":2576445.2172389436},2501089.326682053,2394160.8441129359,2288878.7198438179,2184419.6376369279,2079960.5554300374,{"$f":"P20+P37+P54+P71+P88+P105","v":1975501.4732231472},1871042.391016257,1766583.3088093665,1662124.2266024761,1557665.1443955861,{"$f":"U20+U37+U54+U71+U88+U105","v":1453206.0621886957}]
[null,"Total Amortization",null,{"$f":"SUM(D99:D100,D82:D83,D65:D66,D48:D49,D31:D32,D14:D15)","v":1980.6833333333332},20336.223055555554,50132.234556551703,73341.630718106491,104658.83639537368,118981.58480689029,{"$f":"SUM(J99:J100,J82:J83,J65:J66,J48:J49,J31:J32,J14:J15)","v":109962.24230689029},107751.79880689029,106105.16633134487,104459.08220689028,104459.08220689028,104459.08220689028,{"$f":"SUM(P99:P100,P82:P83,P65:P66,P48:P49,P31:P32,P14:P15)","v":104459.08220689028},104459.08220689028,104459.08220689028,104459.08220689028,104459.08220689028,{"$f":"SUM(U99:U100,U82:U83,U65:U66,U48:U49,U31:U32,U14:U15)","v":104459.08220689028}]
[null,"Closing NFA",null,{"$f":"SUM(D19,D36,D53,D70,D87,D104)","v":80119.316666666666},{"$f":"SUM(E19,E36,E53,E70,E87,E104)","v":471012.09361111111},1024828.9190545594,1691159.9497364527,2640422.7531992793,2597925.2083923882,2554965.226085498,2447213.4272786081,2341108.2609472633,2236649.1787403729,2132190.0965334829,{"$f":"SUM(O19,O36,O53,O70,O87,O104)","v":2027731.014326592},{"$f":"SUM(P19,P36,P53,P70,P87,P104)","v":1923271.932119702},1818812.8499128115,1714353.7677059213,1609894.6854990309,1505435.6032921409,{"$f":"SUM(U19,U36,U53,U70,U87,U104)","v":1400976.5210852507}]
[]
[null,"For PILs Calculation"]
[null,null,null,{"$f":"D6","v":2010},{"$f":"E6","v":2011},2012,2013,2014,2015,2016,2017,2018,2019,2020,{"$f":"O91","v":2021},{"$f":"P91","v":2022},2023,2024,2025,2026,{"$f":"U91","v":2027}]
[null,"UCC / Class 47"]
[]
[null,"Opening UCC",null,0,{"$f":"D125","v":78052.800000000003},398847.93599999999,916891.26060939615,1553625.7147046444,2428456.4000481451,2307604.5664442936,2122996.2011287501,1953156.50503845,1796903.984635374,1653151.665864544,1520899.5325953804,{"$f":"O125","v":1399227.5699877499},{"$f":"P125","v":1287289.3643887299},{"$f":"Q125","v":1184306.2152376315},{"$f":"R125","v":1089561.718018621},{"$f":"S125","v":1002396.7805771313},922205.03813096078]
[null,"Capital Additions",null,81305,340666,572865.79113478772,739672.66139999998,1040750.7734581998,76484.039999999994]
[null,"UCC Before Half Year Rule",null,{"$f":"SUM(D117:D118)","v":81305},418718.8,971713.72713478771,1656563.9220093961,2594376.4881628444,2504940.4400481451,{"$f":"SUM(J117:J118)","v":2307604.5664442936},2122996.2011287501,1953156.50503845,1796903.984635374,1653151.665864544,1520899.5325953804,{"$f":"SUM(P117:P118)","v":1399227.5699877499},1287289.3643887299,1184306.2152376315,1089561.718018621,1002396.7805771313,{"$f":"SUM(U117:U118)","v":922205.03813096078}]
[null,"Half Year Rule (1/2 Additions - Disposals)",null,{"$f":"D118/2","v":40652.5},170333,286432.89556739386,369836.33069999999,520375.3867290999,38242.019999999997,{"$f":"J118/2","v":0},0,0,0,0,0,{"$f":"P118/2","v":0},0,0,0,0,{"$f":"U118/2","v":0}]
[null,"Reduced UCC",null,{"$f":"D119-D120","v":40652.5},248385.8,685280.83156739385,1286727.5913093961,2074001.1014337447,2466698.4200481451,{"$f":"J119-J120","v":2307604.5664442936},2122996.2011287501,1953156.50503845,1796903.984635374,1653151.665864544,1520899.5325953804,{"$f":"P119-P120","v":1399227.5699877499},1287289.3643887299,1184306.2152376315,1089561.718018621,1002396.7805771313,{"$f":"U119-U120","v":922205.03813096078}]
[null,"CCA Rate Class",47]
[null,"CCA Rate ",0.08,{"$f":"$C$123","v":0.08},0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[null,"CCA",null,{"$f":"D121*$C$123","v":3252.2000000000003},19870.863999999998,54822.466525391508,102938.20730475169,165920.08811469958,197335.87360385162,{"$f":"J121*$C$123","v":184608.36531554349},169839.69609030001,156252.52040307599,143752.31877082994,132252.13326916352,121671.96260763044,{"$f":"P121*$C$123","v":111938.20559902},102983.14915109839,94744.497219010518,87164.937441489674,80191.742446170509,{"$f":"U121*$C$123","v":73776.40305047686}]
[null,"Closing UCC",null,{"$f":"D119-D124","v":78052.800000000003},398847.93599999999,916891.26060939615,1553625.7147046444,2428456.4000481451,2307604.5664442936,{"$f":"J119-J124","v":2122996.2011287501},1953156.50503845,1796903.984635374,1653151.665864544,1520899.5325953804,1399227.5699877499,{"$f":"P119-P124","v":1287289.3643887299},1184306.2152376315,1089561.718018621,1002396.7805771313,922205.03813096078,{"$f":"U119-U124","v":848428.63508048397}]
[]
[]
[null,"UCC / Class 12",null,{"$f":"D23","v":2010},{"$f":"E23","v":2011},2012,2013,2014,2015,2016,2017,2018,2019,2020,{"$f":"O114","v":2021},{"$f":"P114","v":2022},2023,2024,2025,2026,{"$f":"U114","v":2027}]
[]
[]
[null,"Opening UCC",null,0,{"$f":"D139","v":397.5},35281.5,15541.634432606123,0,6585.4332000000004,0,0,0,0,0,0,{"$f":"O139","v":0},{"$f":"P139","v":0},{"$f":"Q139","v":0},{"$f":"R139","v":0},{"$f":"S139","v":0},0]
[null,"Capital Additions",null,795,70563,31083.268865212238,0,13170.866400000001,0]
[null,"UCC Before Half Year Rule",null,{"$f":"SUM(D131:D132)","v":795},70960.5,66364.768865212245,15541.634432606123,13170.866400000001,6585.4332000000004,{"$f":"SUM(J131:J132)","v":0},0,0,0,0,0,{"$f":"SUM(P131:P132)","v":0},0,0,0,0,{"$f":"SUM(U131:U132)","v":0}]
[null,"Half Year Rule (1/2 Additions - Disposals)",null,{"$f":"D132/2","v":397.5},35281.5,{"$f":"F132/2","v":15541.634432606119},0,6585.4332000000004,0,{"$f":"J132/2","v":0},0,0,0,0,0,{"$f":"P132/2","v":0},0,0,0,0,{"$f":"U132/2","v":0}]
[null,"Reduced UCC",null,{"$f":"D133-D134","v":397.5},35679,50823.134432606123,15541.634432606123,6585.4332000000004,6585.4332000000004,{"$f":"J133-J134","v":0},0,0,0,0,0,{"$f":"P133-P134","v":0},0,0,0,0,{"$f":"U133-U134","v":0}]
[null,"CCA Rate Class",12]
[null,"CCA Rate ",1,{"$f":"$C$137","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"CCA",null,{"$f":"D135*$C$137","v":397.5},35679,50823.134432606123,15541.634432606123,6585.4332000000004,6585.4332000000004,{"$f":"J135*$C$137","v":0},0,0,0,0,0,{"$f":"P135*$C$137","v":0},0,0,0,0,{"$f":"U135*$C$137","v":0}]
[null,"Closing UCC",null,{"$f":"D133-D138","v":397.5},35281.5,15541.634432606123,0,6585.4332000000004,0,{"$f":"J133-J138","v":0},0,0,0,0,0,{"$f":"P133-P138","v":0},0,0,0,0,{"$f":"U133-U138","v":0}]
[]
[null,"Totals"]
[null,"Additions",null,{"$f":"+D118+D132","v":82100},411229,603949.05999999994,739672.66139999998,1053921.6398581997,76484.039999999994,0,0,0,0,0,{"$f":"+O118+O132","v":0},{"$f":"+P118+P132","v":0},0,0,0,0,{"$f":"+U118+U132","v":0}]
[null,"CCA",null,{"$f":"+D124+D138","v":3649.7000000000003},55549.864000000001,105645.60095799764,118479.84173735781,172505.52131469958,203921.30680385162,184608.36531554349,169839.69609030001,156252.52040307599,143752.31877082994,132252.13326916352,{"$f":"+O124+O138","v":121671.96260763044},{"$f":"+P124+P138","v":111938.20559902},102983.14915109839,94744.497219010518,87164.937441489674,80191.742446170509,{"$f":"+U124+U138","v":73776.40305047686}]
[]
[]
[null,"Summary for Fixed Assets Schedule",null,{"$f":"D128","v":2010},{"$f":"E128","v":2011},2012,2013,2014,2015,2016,2017,2018,2019,2020]
[null,{"$f":"B11","v":"Closing Capital Investment"},null,{"$f":"D11+D28+D45+D62+D79+D96","v":82100},{"$f":"E11+E28+E45+E62+E79+E96","v":493329},1097278.06,1836950.7213999999,2890872.3612581999,2967356.4012581999,3034358.6612581997,3034358.6612581997,3034358.6612581997,3034358.6612581997,3034358.6612581997]
[null,"Accumulated Amortization",null,{"$f":"D16+D33+D50+D101+D84+D67","v":1980.6833333333334},{"$f":"E16+E33+E50+E101+E84+E67","v":22316.906388888889},72449.140945440595,{"$f":"G16+G33+G50+G101+G84+G67","v":145790.77166354706},250449.60805892077,369431.19286581111,479393.43517270125,587145.23397959152,693250.40031093638,797709.4825178266,902168.56472471717]
[null,"Amortization Expense",null,{"$f":"D14+D15+D31+D32+D48+D49+D65+D66+D82+D83+D99+D100","v":1980.6833333333334},{"$f":"E14+E15+E31+E32+E48+E49+E65+E66+E82+E83+E99+E100","v":20336.223055555554},50132.234556551703,73341.630718106491,104658.83639537368,118981.5848068903,109962.2423068903,107751.79880689029,106105.16633134488,104459.08220689029,{"$f":"N14+N15+N31+N32+N48+N49+N65+N66+N82+N83+N99+N100","v":104459.08220689029}]
[]
[]
[null,"Amortization Expense Breakdown"]
[null,5705,1818,{"$f":"SUM(D14:D15)","v":382.8},{"$f":"SUM(E14:E15)","v":2447.9625000000001},7896.6330482360845,16896.678208233629,27519.849033862738,32909.282747730387,32909.282747730387,32909.282747730387,32909.282747730387,32909.282747730387,32909.282747730387]
[null,5705,1822,{"$f":"SUM(D65:D66)","v":572.57500000000005},{"$f":"SUM(E65:E66)","v":3339.25},7217.8529811023145,9535.6531455410623,15953.068368458338,23649.287408039174,27236.444908039175,28911.501408039174,28911.501408039174,28911.501408039174,28911.501408039174]
[null,5705,1845,{"$f":"SUM(D99:D100)","v":0},{"$f":"SUM(E99:E100)","v":111.02222222222223},1582.5938409992502,5421.8983636830326,9403.10920292837,10905.564916044734,10905.564916044734,10905.564916044734,10905.564916044734,10905.564916044734,10905.564916044734]
[null,5705,1912,{"$f":"SUM(D82:D83)","v":0},{"$f":"SUM(E82:E83)","v":18.73},37.46,455.74992753426483,1257.0737800319155,1640.1077049953012,1640.1077049953012,1640.1077049953012,1640.1077049953012,1640.1077049953012,1640.1077049953012]
[null,5705,1981,{"$f":"SUM(D48:D49)","v":925.93333333333328},{"$f":"SUM(E48:E49)","v":5400.1333333333332},11672.786078062529,15421.333856811434,23269.060493789249,30092.62543008069,30092.62543008069,30092.62543008069,30092.62543008069,30092.62543008069,30092.62543008069]
[null,5715,1925,{"$f":"SUM(D31:D32)","v":99.375},{"$f":"SUM(E31:E32)","v":9019.125},21724.908608151531,25610.317216303061,27256.675516303061,19784.7166,7178.2165999999997,3292.7166000000002,1646.0841244545882,0,0]
[null,null,null,{"$f":"SUM(D153:D158)","v":1980.6833333333334},{"$f":"SUM(E153:E158)","v":20336.223055555554},50132.234556551703,73341.630718106491,104658.83639537367,118981.58480689029,109962.24230689029,107751.79880689029,106105.16633134488,104459.08220689029,104459.08220689029]
[null,null,"check",{"$f":"D159-D149","v":0},{"$f":"E159-E149","v":0},0,0,0,0,0,0,0,0,0]