{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["App.2-FA Proposed REG Invest.","App.2-FB Calc of REG Improvemnt","App.2-FC Calc of REG Expansion"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":6,"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":"App.2-FA Proposed REG Invest.","index":0,"n_rows":87,"n_cols":14,"rows_kept":87,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[3,0,3,6],[4,0,4,6],[5,0,5,5],[48,0,48,6],[49,0,49,6],[8,0,8,6],[9,0,9,6],[6,0,6,5]]}
["Appendix 2-FA"]
["Renewable Generation Connection Investment Summary (over the rate setting period)"]
[]
["Enter the details of the Renewable Generation Connection projects as described in Section 2.5.2.5 of the Filing Requirements."]
["All costs entered on this page will be transferred to the appropriate cells in the appendices that follow."]
["For Part A, Renewable Enabling Improvements (REI), these amounts will be transferred to Appendix 2 - FB"]
["For Part B, Expansions, these amounts will be transferred to Appendix 2 - FC"]
[]
["If there are more than five projects proposed to be in-service in a certain year, please amend the tables below and ensure that the formulae for the Total Amounts in any given rate year are updated."]
["Based on the current methodology and allocation, amounts allocated represent 6% for REI Connection Investments and 17% for Expansion Investments. (pg 15, EB-2009-0349)"]
[]
[]
["Part A"]
["REI Investments (Direct Benefit at 6%)",null,2015,2016,2017,2018,2019,{"$f":"G14+1","v":2020},{"$f":"H14+1","v":2021},{"$f":"I14+1","v":2022},{"$f":"J14+1","v":2023},{"$f":"K14+1","v":2024},{"$f":"L14+1","v":2025},{"$f":"M14+1","v":2026}]
["Project 1"]
["Name: OPA FIT/MicroFIT Program Management"]
["Capital Costs"]
["OM&A (Start-Up)",null,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Ongoing)",null,117500,122500,110000,110000,110000,0,0,0,0,0,0,0]
[]
["Project 2"]
["Name: Maintenance of Connected REG Infrastructure"]
["Capital Costs",null,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Start-Up)",null,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Ongoing)",null,70000,76000,82000,88000,94000,0,0,0,0,0,0,0]
[]
["Project 3"]
["Name: Remote Monitoring and Control of  REG"]
["Capital Costs",null,180000,180000,180000,180000,180000,0,0,0,0,0,0,0]
["OM&A (Start-Up)",null,{"$f":"0.05*C29","v":9000},{"$f":"0.05*D29","v":9000},9000,9000,9000,0,0,0,0,0,0,0]
["OM&A (Ongoing)"]
[]
["Project 4"]
["Name: REI Connection Project"]
["Capital Costs",null,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Start-Up)",null,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Ongoing)",null,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Project 5"]
["Name: REI Connection Project"]
["Capital Costs",null,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Start-Up)",null,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Ongoing)",null,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Total Capital Costs",null,{"$f":"SUM(C41,C35,C29,C23,C17)","v":180000},{"$f":"SUM(D41,D35,D29,D23,D17)","v":180000},180000,180000,180000,{"$f":"SUM(H41,H35,H29,H23,H17)","v":0},{"$f":"SUM(I41,I35,I29,I23,I17)","v":0},0,0,0,0,0]
["Total OM&A (Start-Up)",null,{"$f":"SUM(C42,C36,C30,C24,C18)","v":9000},9000,9000,9000,9000,{"$f":"SUM(H42,H36,H30,H24,H18)","v":0},{"$f":"SUM(I42,I36,I30,I24,I18)","v":0},0,0,0,0,0]
["Total OM&A (Ongoing)",null,{"$f":"SUM(C43,C37,C31,C25,C19)","v":187500},198500,192000,198000,{"$f":"SUM(G43,G37,G31,G25,G19)","v":204000},{"$f":"SUM(H43,H37,H31,H25,H19)","v":0},{"$f":"SUM(I43,I37,I31,I25,I19)","v":0},0,0,0,0,0]
[]
["Appendix 2-FA"]
["Renewable Generation Connection Investment Summary (over the rate setting period)"]
[]
[]
["Part B"]
["Expansion Investments (Direct Benefit at 17%)",null,{"$f":"C14","v":2015},{"$f":"D14","v":2016},2017,2018,2019,2020,2021,{"$f":"J14","v":2022},2023,2024,2025,2026]
["Project 1"]
["Name: Transformer Replacement"]
["Capital Costs",null,60000,60000,60000,60000,60000,0,0,0,0,0,0,0]
["OM&A (Start-Up)",null,{"$f":"0.1*C57","v":6000},{"$f":"0.1*D57","v":6000},6000,6000,6000,0,0,0,0,0,0,0]
["OM&A (Ongoing)",null,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Project 2"]
["Name: Rebuilding Existing Line"]
["Capital Costs",null,38000,10000,12000,14000,16000,0,0,0,0,0,0,0]
["OM&A (Start-Up)",null,{"$f":"0.1*C63","v":3800},{"$f":"0.1*D63","v":1000},1200,1400,1600,0,0,0,0,0,0,0]
["OM&A (Ongoing)",null,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Project 3"]
["Name: Expansion Connection Project"]
["Capital Costs",null,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Start-Up)",null,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Ongoing)",null,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Project 4"]
["Name: Expansion Connection Project"]
["Capital Costs",null,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Start-Up)",null,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Ongoing)",null,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Project 5"]
["Name: Expansion Connection Project"]
["Capital Costs",null,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Start-Up)",null,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Ongoing)",null,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Total Capital Costs",null,{"$f":"SUM(C81,C75,C69,C63,C57)","v":98000},{"$f":"SUM(D81,D75,D69,D63,D57)","v":70000},72000,74000,76000,{"$f":"SUM(H81,H75,H69,H63,H57)","v":0},{"$f":"SUM(I81,I75,I69,I63,I57)","v":0},0,0,0,0,0]
["Total OM&A (Start-Up)",null,{"$f":"SUM(C82,C76,C70,C64,C58)","v":9800},7000,7200,7400,7600,{"$f":"SUM(H82,H76,H70,H64,H58)","v":0},{"$f":"SUM(I82,I76,I70,I64,I58)","v":0},0,0,0,0,0]
["Total OM&A (Ongoing)",null,{"$f":"SUM(C83,C77,C71,C65,C59)","v":0},0,0,0,0,{"$f":"SUM(H83,H77,H71,H65,H59)","v":0},{"$f":"SUM(I83,I77,I71,I65,I59)","v":0},0,0,0,0,0]

{"sheet":"App.2-FB Calc of REG Improvemnt","index":1,"n_rows":88,"n_cols":42,"rows_kept":88,"cut":false,"hidden":false,"merged":[[7,39,7,41],[41,40,41,41],[7,12,7,14],[7,15,7,17],[0,0,0,6],[1,0,1,6],[3,0,3,6],[4,0,4,6],[5,0,5,6],[7,21,7,23],[41,22,41,23],[57,0,57,6],[58,0,58,6],[41,16,41,17],[38,0,38,11],[41,4,41,5],[41,7,41,8],[41,10,41,11],[41,13,41,14],[7,18,7,20],[41,19,41,20],[7,3,7,5],[7,6,7,8],[37,0,37,15],[7,9,7,11],[7,33,7,35],[41,34,41,35],[7,36,7,38],[41,37,41,38],[7,24,7,26],[41,25,41,26],[7,27,7,29],[41,28,41,29],[7,30,7,32],[41,31,41,32]]}
["Appendix 2-FB"]
["Calculation of Renewable Generation Connection Direct Benefits/Provincial Amount: Renewable Enabling Improvement Investments"]
[]
["This table will calculate the distributor/provincial shares of the investments entered in Part A of Appendix 2-FA."]
["Enter values in green shaded cells: WCA percentage, debt percentages, interest rates, kWh, tax rates, amortization period, CCA Class and percentage."]
["Rate Riders are not calculated for Test Year as these assets and costs are already in the distributor's rate base/revenue requirement."]
[]
[null,null,null,"2015Test Year",null,null,2016,null,null,2017,2016,null,2018,null,null,2019,null,null,2020,null,null,{"$f":"+S8+1","v":2021},null,null,{"$f":"+V8+1","v":2022},null,null,{"$f":"+Y8+1","v":2023},null,null,{"$f":"+AB8+1","v":2024},null,null,{"$f":"+AE8+1","v":2025},null,null,{"$f":"+AH8+1","v":2026},null,null,{"$f":"+AK8+1","v":2027}]
[null,null,null,null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial"]
[null,null,null,"Total",0.06,0.94,"Total",0.06,0.94,"Total",0.06,0.94,"Total",0.06,0.94,"Total",0.06,0.94,"Total",0.06,0.94,"Total",0.06,0.94,"Total",0.06,0.94,"Total",0.06,0.94,"Total",0.06,0.94,"Total",0.06,0.94,"Total",0.06,0.94,"Total",0.06,0.94]
["Net Fixed Assets (average)",null,null,null,{"$f":"D11*E10","v":0},{"$f":"D11*F10","v":0},{"$f":"E75","v":255000},{"$f":"G11*H10","v":15300},{"$f":"G11*I10","v":239700},{"$f":"F75","v":411000},{"$f":"J11*K10","v":24660},{"$f":"J11*L10","v":386340},{"$f":"G75","v":555000},{"$f":"M11*N10","v":33300},{"$f":"M11*O10","v":521699.99999999994},{"$f":"H75","v":687000},{"$f":"P11*Q10","v":41220},{"$f":"P11*R10","v":645780},{"$f":"I75","v":720000},{"$f":"S11*T10","v":43200},{"$f":"S11*U10","v":676800},{"$f":"J75","v":660000},{"$f":"V11*W10","v":39600},{"$f":"V11*X10","v":620400},{"$f":"K75","v":600000},{"$f":"Y11*Z10","v":36000},{"$f":"Y11*AA10","v":564000},{"$f":"L75","v":540000},{"$f":"AB11*AC10","v":32400},{"$f":"AB11*AD10","v":507600},{"$f":"M75","v":480000},{"$f":"AE11*AF10","v":28800},{"$f":"AE11*AG10","v":451200},{"$f":"N75","v":420000},{"$f":"AH11*AI10","v":25200},{"$f":"AH11*AJ10","v":394800},{"$f":"O75","v":360000},{"$f":"AK11*AL10","v":21600},{"$f":"AK11*AM10","v":338400},{"$f":"P75","v":300000},{"$f":"AN11*AO10","v":18000},{"$f":"AN11*AP10","v":282000}]
["Incremental OM&A (on-going, N/A for Provincial Recovery)",null,null,{"$f":"'App.2-FA Proposed REG Invest.'!C47","v":187500},{"$f":"D12","v":187500},null,{"$f":"'App.2-FA Proposed REG Invest.'!D47","v":198500},{"$f":"G12","v":198500},null,{"$f":"'App.2-FA Proposed REG Invest.'!E47","v":192000},{"$f":"J12","v":192000},null,{"$f":"'App.2-FA Proposed REG Invest.'!F47","v":198000},{"$f":"M12","v":198000},null,{"$f":"'App.2-FA Proposed REG Invest.'!G47","v":204000},{"$f":"P12","v":204000},null,{"$f":"'App.2-FA Proposed REG Invest.'!H47","v":0},{"$f":"S12","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!I47","v":0},{"$f":"V12","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!J47","v":0},{"$f":"Y12","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!K47","v":0},{"$f":"AB12","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!L47","v":0},{"$f":"AE12","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!M47","v":0},{"$f":"AH12","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!N47","v":0},{"$f":"AK12","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!Q47","v":0},{"$f":"AN12","v":0}]
["Incremental OM&A (start-up, applicable for Provincial Recovery)",null,null,{"$f":"'App.2-FA Proposed REG Invest.'!C46","v":9000},{"$f":"D13*E10","v":540},{"$f":"D13*F10","v":8460},{"$f":"'App.2-FA Proposed REG Invest.'!D46","v":9000},{"$f":"G13*H10","v":540},{"$f":"G13*I10","v":8460},{"$f":"'App.2-FA Proposed REG Invest.'!E46","v":9000},{"$f":"J13*K10","v":540},{"$f":"J13*L10","v":8460},{"$f":"'App.2-FA Proposed REG Invest.'!F46","v":9000},{"$f":"M13*N10","v":540},{"$f":"M13*O10","v":8460},{"$f":"'App.2-FA Proposed REG Invest.'!G46","v":9000},{"$f":"P13*Q10","v":540},{"$f":"P13*R10","v":8460},{"$f":"'App.2-FA Proposed REG Invest.'!H46","v":0},{"$f":"S13*T10","v":0},{"$f":"S13*U10","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!I46","v":0},{"$f":"V13*W10","v":0},{"$f":"V13*X10","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!J46","v":0},{"$f":"Y13*Z10","v":0},{"$f":"Y13*AA10","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!K46","v":0},{"$f":"AB13*AC10","v":0},{"$f":"AB13*AD10","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!L46","v":0},{"$f":"AE13*AF10","v":0},{"$f":"AE13*AG10","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!M46","v":0},{"$f":"AH13*AI10","v":0},{"$f":"AH13*AJ10","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!N46","v":0},{"$f":"AK13*AL10","v":0},{"$f":"AK13*AM10","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!Q46","v":0},{"$f":"AN13*AO10","v":0},{"$f":"AN13*AP10","v":0}]
["WCA",0.13,null,null,{"$f":"(E12+E13)*$B$14","v":24445.200000000001},{"$f":"F13*$B$14","v":1099.8},null,{"$f":"(H12+H13)*$B$14","v":25875.200000000001},{"$f":"I13*$B$14","v":1099.8},null,{"$f":"(K12+K13)*$B$14","v":25030.2},{"$f":"L13*$B$14","v":1099.8},null,{"$f":"(N12+N13)*$B$14","v":25810.2},{"$f":"O13*$B$14","v":1099.8},null,{"$f":"(Q12+Q13)*$B$14","v":26590.2},{"$f":"R13*$B$14","v":1099.8},null,{"$f":"(T12+T13)*$B$14","v":0},{"$f":"U13*$B$14","v":0},null,{"$f":"(W12+W13)*$B$14","v":0},{"$f":"X13*$B$14","v":0},null,{"$f":"(Z12+Z13)*$B$14","v":0},{"$f":"AA13*$B$14","v":0},null,{"$f":"(AC12+AC13)*$B$14","v":0},{"$f":"AD13*$B$14","v":0},null,{"$f":"(AF12+AF13)*$B$14","v":0},{"$f":"AG13*$B$14","v":0},null,{"$f":"(AI12+AI13)*$B$14","v":0},{"$f":"AJ13*$B$14","v":0},null,{"$f":"(AL12+AL13)*$B$14","v":0},{"$f":"AM13*$B$14","v":0},null,{"$f":"(AO12+AO13)*$B$14","v":0},{"$f":"AP13*$B$14","v":0}]
["Rate Base",null,null,null,{"$f":"SUM(E11+E14)","v":24445.200000000001},{"$f":"SUM(F11+F14)","v":1099.8},null,{"$f":"SUM(H11+H14)","v":41175.199999999997},{"$f":"SUM(I11+I14)","v":240799.8},null,{"$f":"SUM(K11+K14)","v":49690.2},{"$f":"SUM(L11+L14)","v":387439.8},null,{"$f":"SUM(N11+N14)","v":59110.2},{"$f":"SUM(O11+O14)","v":522799.79999999993},null,{"$f":"SUM(Q11+Q14)","v":67810.2},{"$f":"SUM(R11+R14)","v":646879.80000000005},null,{"$f":"SUM(T11+T14)","v":43200},{"$f":"SUM(U11+U14)","v":676800},null,{"$f":"SUM(W11+W14)","v":39600},{"$f":"SUM(X11+X14)","v":620400},null,{"$f":"SUM(Z11+Z14)","v":36000},{"$f":"SUM(AA11+AA14)","v":564000},null,{"$f":"SUM(AC11+AC14)","v":32400},{"$f":"SUM(AD11+AD14)","v":507600},null,{"$f":"SUM(AF11+AF14)","v":28800},{"$f":"SUM(AG11+AG14)","v":451200},null,{"$f":"SUM(AI11+AI14)","v":25200},{"$f":"SUM(AJ11+AJ14)","v":394800},null,{"$f":"SUM(AL11+AL14)","v":21600},{"$f":"SUM(AM11+AM14)","v":338400},null,{"$f":"SUM(AO11+AO14)","v":18000},{"$f":"SUM(AP11+AP14)","v":282000}]
[null,null,null,{"$f":"+D11/25/2","v":0}]
[]
["Deemed ST Debt",0.04,null,null,{"$f":"E15*$B$18","v":977.80799999999999},{"$f":"F15*$B$18","v":43.991999999999997},null,{"$f":"H15*$B$18","v":1647.0079999999998},{"$f":"I15*$B$18","v":9631.9920000000002},null,{"$f":"K15*$B$18","v":1987.6079999999999},{"$f":"L15*$B$18","v":15497.592000000001},null,{"$f":"N15*$B$18","v":2364.4079999999999},{"$f":"O15*$B$18","v":20911.991999999998},null,{"$f":"Q15*$B$18","v":2712.4079999999999},{"$f":"R15*$B$18","v":25875.192000000003},null,{"$f":"T15*$B$18","v":1728},{"$f":"U15*$B$18","v":27072},null,{"$f":"W15*$B$18","v":1584},{"$f":"X15*$B$18","v":24816},null,{"$f":"Z15*$B$18","v":1440},{"$f":"AA15*$B$18","v":22560},null,{"$f":"AC15*$B$18","v":1296},{"$f":"AD15*$B$18","v":20304},null,{"$f":"AF15*$B$18","v":1152},{"$f":"AG15*$B$18","v":18048},null,{"$f":"AI15*$B$18","v":1008},{"$f":"AJ15*$B$18","v":15792},null,{"$f":"AL15*$B$18","v":864},{"$f":"AM15*$B$18","v":13536},null,{"$f":"AO15*$B$18","v":720},{"$f":"AP15*$B$18","v":11280}]
["Deemed LT Debt",0.56000000000000005,null,null,{"$f":"E15*$B$19","v":13689.312000000002},{"$f":"F15*$B$19","v":615.88800000000003},null,{"$f":"H15*$B$19","v":23058.112000000001},{"$f":"I15*$B$19","v":134847.88800000001},null,{"$f":"K15*$B$19","v":27826.512000000002},{"$f":"L15*$B$19","v":216966.288},null,{"$f":"N15*$B$19","v":33101.712},{"$f":"O15*$B$19","v":292767.88799999998},null,{"$f":"Q15*$B$19","v":37973.712},{"$f":"R15*$B$19","v":362252.68800000008},null,{"$f":"T15*$B$19","v":24192.000000000004},{"$f":"U15*$B$19","v":379008.00000000006},null,{"$f":"W15*$B$19","v":22176.000000000004},{"$f":"X15*$B$19","v":347424.00000000006},null,{"$f":"Z15*$B$19","v":20160.000000000004},{"$f":"AA15*$B$19","v":315840.00000000006},null,{"$f":"AC15*$B$19","v":18144},{"$f":"AD15*$B$19","v":284256},null,{"$f":"AF15*$B$19","v":16128.000000000002},{"$f":"AG15*$B$19","v":252672.00000000003},null,{"$f":"AI15*$B$19","v":14112.000000000002},{"$f":"AJ15*$B$19","v":221088.00000000003},null,{"$f":"AL15*$B$19","v":12096.000000000002},{"$f":"AM15*$B$19","v":189504.00000000003},null,{"$f":"AO15*$B$19","v":10080.000000000002},{"$f":"AP15*$B$19","v":157920.00000000003}]
["Deemed Equity",0.4,null,null,{"$f":"E15*$B$20","v":9778.08},{"$f":"F15*$B$20","v":439.92},null,{"$f":"H15*$B$20","v":16470.079999999998},{"$f":"I15*$B$20","v":96319.92},null,{"$f":"K15*$B$20","v":19876.080000000002},{"$f":"L15*$B$20","v":154975.92000000001},null,{"$f":"N15*$B$20","v":23644.080000000002},{"$f":"O15*$B$20","v":209119.91999999998},null,{"$f":"Q15*$B$20","v":27124.080000000002},{"$f":"R15*$B$20","v":258751.92000000004},null,{"$f":"T15*$B$20","v":17280},{"$f":"U15*$B$20","v":270720},null,{"$f":"W15*$B$20","v":15840},{"$f":"X15*$B$20","v":248160},null,{"$f":"Z15*$B$20","v":14400},{"$f":"AA15*$B$20","v":225600},null,{"$f":"AC15*$B$20","v":12960},{"$f":"AD15*$B$20","v":203040},null,{"$f":"AF15*$B$20","v":11520},{"$f":"AG15*$B$20","v":180480},null,{"$f":"AI15*$B$20","v":10080},{"$f":"AJ15*$B$20","v":157920},null,{"$f":"AL15*$B$20","v":8640},{"$f":"AM15*$B$20","v":135360},null,{"$f":"AO15*$B$20","v":7200},{"$f":"AP15*$B$20","v":112800}]
[]
["ST Interest",2.1600000000000001E-2,null,null,{"$f":"E18*$B22","v":21.120652800000002},{"$f":"F18*$B22","v":0.95022719999999994},null,{"$f":"H18*$B22","v":35.575372799999997},{"$f":"I18*$B22","v":208.05102720000002},null,{"$f":"K18*$B22","v":42.932332800000005},{"$f":"L18*$B22","v":334.74798720000001},null,{"$f":"N18*$B22","v":51.071212799999998},{"$f":"O18*$B22","v":451.69902719999999},null,{"$f":"Q18*$B22","v":58.588012800000001},{"$f":"R18*$B22","v":558.90414720000012},null,{"$f":"T18*$B22","v":37.324800000000003},{"$f":"U18*$B22","v":584.75520000000006},null,{"$f":"W18*$B22","v":34.214400000000005},{"$f":"X18*$B22","v":536.02560000000005},null,{"$f":"Z18*$B22","v":31.104000000000003},{"$f":"AA18*$B22","v":487.29600000000005},null,{"$f":"AC18*$B22","v":27.993600000000001},438.56640000000004,null,{"$f":"AF18*$B22","v":24.883200000000002},389.83680000000004,null,{"$f":"AI18*$B22","v":21.7728},{"$f":"AJ18*$B22","v":341.10720000000003},null,{"$f":"AL18*$B22","v":18.662400000000002},{"$f":"AM18*$B22","v":292.37760000000003},null,{"$f":"AO18*$B22","v":15.552000000000001},{"$f":"AP18*$B22","v":243.64800000000002}]
["LT Interest",6.0728710462287103E-2,null,null,{"$f":"E19*$B23","v":831.33426487591248},37.402084029197084,null,{"$f":"H19*$B23","v":1400.2894074549879},8189.1383468029198,null,{"$f":"K19*$B23","v":1689.8681904233576},13176.082884029196,null,{"$f":"N19*$B23","v":2010.2242838540144},17779.416303007296,null,{"$f":"Q19*$B23","v":2306.0945612262772},21999.138603737232,null,{"$f":"T19*$B23","v":1469.1489635036498},23016.667094890512,null,{"$f":"W19*$B23","v":1346.719883211679},21098.611503649638,null,{"$f":"Z19*$B23","v":1224.2908029197083},19180.555912408763,null,1101.8617226277372,17262.500321167881,null,979.43264233576656,15344.444729927009,null,{"$f":"AI19*$B23","v":857.00356204379568},13426.389138686132,null,{"$f":"AL19*$B23","v":734.57448175182492},11508.333547445256,null,{"$f":"AO19*$B23","v":612.14540145985416},9590.2779562043816]
["ROE",9.2999999999999999E-2,null,null,909.36144000000002,40.912559999999999,null,1531.7174399999999,8957.752559999999,null,1848.4754400000002,14412.760560000001,null,2198.8994400000001,19448.152559999999,null,2522.53944,24063.928560000004,null,{"$f":"T20*$B24","v":1607.04},25176.959999999999,null,{"$f":"W20*$B24","v":1473.12},23078.880000000001,null,{"$f":"Z20*$B24","v":1339.2},20980.799999999999,null,1205.28,18882.72,null,1071.3599999999999,16784.64,null,{"$f":"AI20*$B24","v":937.43999999999994},14686.56,null,{"$f":"AL20*$B24","v":803.52},12588.48,null,{"$f":"AO20*$B24","v":669.6},10490.4]
["Cost of Capital Total",null,null,null,{"$f":"SUM(E22:E24)","v":1761.8163576759125},{"$f":"SUM(F22:F24)","v":79.264871229197084},null,{"$f":"SUM(H22:H24)","v":2967.582220254988},{"$f":"SUM(I22:I24)","v":17354.94193400292},null,{"$f":"SUM(K22:K24)","v":3581.2759632233578},{"$f":"SUM(L22:L24)","v":27923.591431229197},null,{"$f":"SUM(N22:N24)","v":4260.1949366540139},{"$f":"SUM(O22:O24)","v":37679.267890207295},null,{"$f":"SUM(Q22:Q24)","v":4887.2220140262771},{"$f":"SUM(R22:R24)","v":46621.971310937239},null,{"$f":"SUM(T22:T24)","v":3113.5137635036499},{"$f":"SUM(U22:U24)","v":48778.382294890514},null,{"$f":"SUM(W22:W24)","v":2854.0542832116789},{"$f":"SUM(X22:X24)","v":44713.517103649639},null,{"$f":"SUM(Z22:Z24)","v":2594.5948029197084},{"$f":"SUM(AA22:AA24)","v":40648.651912408764},null,{"$f":"SUM(AC22:AC24)","v":2335.135322627737},{"$f":"SUM(AD22:AD24)","v":36583.786721167882},null,{"$f":"SUM(AF22:AF24)","v":2075.6758423357664},{"$f":"SUM(AG22:AG24)","v":32518.921529927007},null,{"$f":"SUM(AI22:AI24)","v":1816.2163620437955},{"$f":"SUM(AJ22:AJ24)","v":28454.056338686132},null,{"$f":"SUM(AL22:AL24)","v":1556.7568817518249},{"$f":"SUM(AM22:AM24)","v":24389.191147445257},null,{"$f":"SUM(AO22:AO24)","v":1297.2974014598542},{"$f":"SUM(AP22:AP24)","v":20324.325956204382}]
[]
["OM&A",null,null,null,{"$f":"E12+E13","v":188040},{"$f":"F13","v":8460},null,{"$f":"H12+H13","v":199040},{"$f":"I13","v":8460},null,{"$f":"K12+K13","v":192540},{"$f":"L13","v":8460},null,{"$f":"N12+N13","v":198540},{"$f":"O13","v":8460},null,{"$f":"Q12+Q13","v":204540},{"$f":"R13","v":8460},null,{"$f":"T12+T13","v":0},{"$f":"U13","v":0},null,{"$f":"W12+W13","v":0},{"$f":"X13","v":0},null,{"$f":"Z12+Z13","v":0},{"$f":"AA13","v":0},null,{"$f":"AC12+AC13","v":0},{"$f":"AD13","v":0},null,{"$f":"AF12+AF13","v":0},{"$f":"AG13","v":0},null,{"$f":"AI12+AI13","v":0},{"$f":"AJ13","v":0},null,{"$f":"AL12+AL13","v":0},{"$f":"AM13","v":0},null,{"$f":"AO12+AO13","v":0},{"$f":"AP13","v":0}]
["Amortization",null,null,{"$f":"D70","v":6000},{"$f":"D28*E$10","v":360},{"$f":"D28*F$10","v":5640},{"$f":"E69+E70","v":18000},{"$f":"G28*H$10","v":1080},{"$f":"G28*I$10","v":16920},{"$f":"F69+F70","v":30000},{"$f":"J28*K$10","v":1800},{"$f":"J28*L$10","v":28200},{"$f":"G69+G70","v":42000},{"$f":"M28*N$10","v":2520},{"$f":"M28*O$10","v":39480},{"$f":"H69+H70","v":54000},{"$f":"P28*Q$10","v":3240},{"$f":"P28*R$10","v":50760},{"$f":"I69+I70","v":60000},{"$f":"S28*T$10","v":3600},{"$f":"S28*U$10","v":56400},{"$f":"J69+J70","v":60000},{"$f":"V28*W$10","v":3600},{"$f":"V28*X$10","v":56400},{"$f":"K69+K70","v":60000},{"$f":"Y28*Z$10","v":3600},{"$f":"Y28*AA$10","v":56400},{"$f":"L69+L70","v":60000},{"$f":"AB28*AC$10","v":3600},{"$f":"AB28*AD$10","v":56400},{"$f":"M69+M70","v":60000},{"$f":"AE28*AF$10","v":3600},{"$f":"AE28*AG$10","v":56400},{"$f":"N69+N70","v":60000},{"$f":"AH28*AI$10","v":3600},{"$f":"AH28*AJ$10","v":56400},{"$f":"O69+O70","v":60000},{"$f":"AK28*AL$10","v":3600},{"$f":"AK28*AM$10","v":56400},{"$f":"P69+P70","v":60000},{"$f":"AN28*AO$10","v":3600},{"$f":"AN28*AP$10","v":56400}]
["Grossed-up PILs",null,null,null,{"$f":"E55","v":301.90582530612249},{"$f":"F55","v":-391.94309061224499},null,{"$f":"H55","v":486.83472326530614},{"$f":"I55","v":2204.7973175510219},null,{"$f":"K55","v":585.50601306122451},{"$f":"L55","v":3928.2032930612258},null,{"$f":"N55","v":718.32544946938799},{"$f":"O55","v":5845.143497469393},null,{"$f":"Q55","v":861.73732933224528},{"$f":"R55","v":7928.0319826677587},null,{"$f":"T55","v":602.97315186729816},{"$f":"U55","v":9446.5793792543336},null,{"$f":"W55","v":656.64067114648572},{"$f":"X55","v":10287.370514628279},null,{"$f":"Z55","v":702.15206235272603},{"$f":"AA55","v":11000.382310192712},null,{"$f":"AC55","v":740.15981573185479},{"$f":"AD55","v":11595.837113132395},null,{"$f":"AF55","v":771.2642223100413},{"$f":"AG55","v":12083.139482857314},null,{"$f":"AI55","v":796.01754983136016},{"$f":"AJ55","v":12470.941614024647},null,{"$f":"AL55","v":814.92788462036208},{"$f":"AM55","v":12767.203525719002},null,{"$f":"AO55","v":828.46266609563099},{"$f":"AP55","v":12979.248435498213}]
[]
["Revenue Requirement",null,null,null,{"$f":"SUM(E25:E29)","v":190463.72218298202},{"$f":"SUM(F25:F29)","v":13787.321780616952},null,{"$f":"SUM(H25:H29)","v":203574.41694352031},{"$f":"SUM(I25:I29)","v":44939.73925155394},null,{"$f":"SUM(K25:K29)","v":198506.78197628458},{"$f":"SUM(L25:L29)","v":68511.794724290434},null,{"$f":"SUM(N25:N29)","v":206038.52038612339},{"$f":"SUM(O25:O29)","v":91464.411387676693},null,{"$f":"SUM(Q25:Q29)","v":213528.95934335853},{"$f":"SUM(R25:R29)","v":113770.003293605},null,{"$f":"SUM(T25:T29)","v":7316.4869153709478},{"$f":"SUM(U25:U29)","v":114624.96167414484},null,{"$f":"SUM(W25:W29)","v":7110.694954358165},{"$f":"SUM(X25:X29)","v":111400.88761827792},null,{"$f":"SUM(Z25:Z29)","v":6896.7468652724338},{"$f":"SUM(AA25:AA29)","v":108049.03422260148},null,{"$f":"SUM(AC25:AC29)","v":6675.2951383595919},{"$f":"SUM(AD25:AD29)","v":104579.62383430028},null,{"$f":"SUM(AF25:AF29)","v":6446.9400646458071},{"$f":"SUM(AG25:AG29)","v":101002.06101278431},null,{"$f":"SUM(AI25:AI29)","v":6212.2339118751552},{"$f":"SUM(AJ25:AJ29)","v":97324.997952710779},null,{"$f":"SUM(AL25:AL29)","v":5971.6847663721874},{"$f":"SUM(AM25:AM29)","v":93556.394673164265},null,{"$f":"SUM(AO25:AO29)","v":5725.760067555485},{"$f":"SUM(AP25:AP29)","v":89703.574391702597}]
[]
[]
["Provincial Rate Protection",null,null,null,null,{"$f":"F31","v":13787.321780616952},null,null,{"$f":"I31","v":44939.73925155394},null,null,{"$f":"L31","v":68511.794724290434},null,null,{"$f":"O31","v":91464.411387676693},null,null,{"$f":"R31","v":113770.003293605},null,null,{"$f":"U31","v":114624.96167414484},null,null,{"$f":"X31","v":111400.88761827792},null,null,{"$f":"AA31","v":108049.03422260148},null,null,{"$f":"AD31","v":104579.62383430028},null,null,{"$f":"AG31","v":101002.06101278431},null,null,{"$f":"AJ31","v":97324.997952710779},null,null,{"$f":"AM31","v":93556.394673164265},null,null,{"$f":"AP31","v":89703.574391702597}]
[]
["Monthly Amount Paid by IESO",null,null,null,null,{"$f":"F34/12","v":1148.9434817180793},null,null,{"$f":"I34/12","v":3744.9782709628284},null,null,{"$f":"L34/12","v":5709.3162270242028},null,null,{"$f":"O34/12","v":7622.0342823063911},null,null,{"$f":"R34/12","v":9480.8336078004158},null,null,{"$f":"U34/12","v":9552.0801395120707},null,null,{"$f":"X34/12","v":9283.4073015231606},null,null,{"$f":"AA34/12","v":9004.0861852167891},null,null,{"$f":"AD34/12","v":8714.968652858357},null,null,{"$f":"AG34/12","v":8416.8384177320258},null,null,{"$f":"AJ34/12","v":8110.4164960592316},null,null,{"$f":"AM34/12","v":7796.3662227636887},null,null,{"$f":"AP34/12","v":7475.2978659752162}]
[]
["Note 1: The difference between the actual costs of approved eligible investments and revenue received from the IESO should be recorded in a variance account.  The Board regulatory accounting guidance regarding a variance account either in an individual proceeding or on a generic basis. "]
["Note 2: For the 2014 Test Year, Costs and Revenues of the Direct Benefit are to be included in the test year applicant Rate Base and Revenues.  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+U34+'App.2-FC Calc of REG Expansion'!U35","v":143159.89708025384},null,null,{"$f":"+X34+'App.2-FC Calc of REG Expansion'!X35","v":139883.23557965836},null,null,{"$f":"+AA34+'App.2-FC Calc of REG Expansion'!AA35","v":136430.29454382902},null,null,{"$f":"+AD34+'App.2-FC Calc of REG Expansion'!AD35","v":132815.17633558449},null,null,{"$f":"+AG34+'App.2-FC Calc of REG Expansion'!AG35","v":129050.85512871803},null,null,{"$f":"+AJ34+'App.2-FC Calc of REG Expansion'!AJ35","v":125149.26716311938},null,null,{"$f":"+AM34+'App.2-FC Calc of REG Expansion'!AM35","v":121121.39377948712},null,null,{"$f":"+AP34+'App.2-FC Calc of REG Expansion'!AP35","v":116977.33781126392}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+U36+'App.2-FC Calc of REG Expansion'!U37","v":11929.991423354488},null,null,{"$f":"+X36+'App.2-FC Calc of REG Expansion'!X37","v":11656.936298304865},null,null,{"$f":"+AA36+'App.2-FC Calc of REG Expansion'!AA37","v":11369.19121198575},null,null,{"$f":"+AD36+'App.2-FC Calc of REG Expansion'!AD37","v":11067.93136129871},null,null,{"$f":"+AG36+'App.2-FC Calc of REG Expansion'!AG37","v":10754.237927393169},null,null,{"$f":"+AJ36+'App.2-FC Calc of REG Expansion'!AJ37","v":10429.105596926614},null,null,{"$f":"+AM36+'App.2-FC Calc of REG Expansion'!AM37","v":10093.449481623926},null,null,{"$f":"+AP36+'App.2-FC Calc of REG Expansion'!AP37","v":9748.1114842719944}]
["PILs Calculation"]
[null,null,null,null,2015,null,null,2016,null,null,2017,null,null,2018,null,null,2019,null,null,2020,null,null,{"$f":"V8","v":2021},null,null,{"$f":"Y8","v":2022},null,null,{"$f":"AB8","v":2023},null,null,{"$f":"AE8","v":2024},null,null,{"$f":"AH8","v":2025},null,null,{"$f":"AK8","v":2026},null,null,{"$f":"AN8","v":2027}]
["Income Tax",null,null,null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total"]
["Net Income - ROE on Rate Base",null,null,null,{"$f":"E24","v":909.36144000000002},{"$f":"F24","v":40.912559999999999},null,{"$f":"H24","v":1531.7174399999999},{"$f":"I24","v":8957.752559999999},null,{"$f":"K24","v":1848.4754400000002},{"$f":"L24","v":14412.760560000001},null,{"$f":"N24","v":2198.8994400000001},{"$f":"O24","v":19448.152559999999},null,{"$f":"Q24","v":2522.53944},{"$f":"R24","v":24063.928560000004},null,{"$f":"T24","v":1607.04},{"$f":"U24","v":25176.959999999999},null,{"$f":"W24","v":1473.12},{"$f":"X24","v":23078.880000000001},null,{"$f":"Z24","v":1339.2},{"$f":"AA24","v":20980.799999999999},null,{"$f":"AC24","v":1205.28},{"$f":"AD24","v":18882.72},null,{"$f":"AF24","v":1071.3599999999999},{"$f":"AG24","v":16784.64},null,{"$f":"AI24","v":937.43999999999994},{"$f":"AJ24","v":14686.56},null,{"$f":"AL24","v":803.52},{"$f":"AM24","v":12588.48},null,{"$f":"AO24","v":669.6},{"$f":"AP24","v":10490.4}]
["Amortization (6% DB and 94% P)",null,null,null,{"$f":"E28","v":360},{"$f":"F28","v":5640},null,{"$f":"H28","v":1080},{"$f":"I28","v":16920},null,{"$f":"K28","v":1800},{"$f":"L28","v":28200},null,{"$f":"N28","v":2520},{"$f":"O28","v":39480},null,{"$f":"Q28","v":3240},{"$f":"R28","v":50760},null,{"$f":"T28","v":3600},{"$f":"U28","v":56400},null,{"$f":"W28","v":3600},{"$f":"X28","v":56400},null,{"$f":"Z28","v":3600},{"$f":"AA28","v":56400},null,{"$f":"AC28","v":3600},{"$f":"AD28","v":56400},null,{"$f":"AF28","v":3600},{"$f":"AG28","v":56400},null,{"$f":"AI28","v":3600},{"$f":"AJ28","v":56400},null,{"$f":"AL28","v":3600},{"$f":"AM28","v":56400},null,{"$f":"AO28","v":3600},{"$f":"AP28","v":56400}]
["CCA (6% DB and 94% P)",null,null,null,{"$f":"-D87*E$10","v":-432},{"$f":"-D87*F$10","v":-6768},null,{"$f":"-E87*H$10","v":-1261.44},{"$f":"-E87*I$10","v":-19762.559999999998},null,{"$f":"-F87*K$10","v":-2024.5248000000001},{"$f":"-F87*L$10","v":-31717.555199999999},null,{"$f":"-G87*N$10","v":-2726.5628159999997},{"$f":"-G87*O$10","v":-42716.15078399999},null,{"$f":"-H87*Q$10","v":-3372.4377907199996},{"$f":"-H87*R$10","v":-52834.85872127999},null,{"$f":"-I87*T$10","v":-3534.6427674623997},{"$f":"-I87*U$10","v":-55376.070023577595},null,{"$f":"-J87*W$10","v":-3251.8713460654076},{"$f":"-J87*X$10","v":-50945.984421691384},null,{"$f":"-K87*Z$10","v":-2991.7216383801747},{"$f":"-K87*AA$10","v":-46870.305667956069},null,{"$f":"-L87*AC$10","v":-2752.3839073097611},{"$f":"-L87*AD$10","v":-43120.681214519587},null,{"$f":"-M87*AF$10","v":-2532.1931947249795},{"$f":"-M87*AG$10","v":-39671.026717358014},null,{"$f":"-N87*AI$10","v":-2329.6177391469819},{"$f":"-N87*AJ$10","v":-36497.34457996938},null,{"$f":"-O87*AL$10","v":-2143.2483200152228},{"$f":"-O87*AM$10","v":-33577.557013571823},null,{"$f":"-P87*AO$10","v":-1971.7884544140052},{"$f":"-P87*AP$10","v":-30891.35245248608}]
["Taxable income",null,null,null,{"$f":"SUM(E45:E47)","v":837.36144000000013},{"$f":"SUM(F45:F47)","v":-1087.0874400000002},null,{"$f":"SUM(H45:H47)","v":1350.2774399999998},{"$f":"SUM(I45:I47)","v":6115.1925600000031},null,{"$f":"SUM(K45:K47)","v":1623.95064},{"$f":"SUM(L45:L47)","v":10895.205360000004},null,{"$f":"SUM(N45:N47)","v":1992.3366240000005},{"$f":"SUM(O45:O47)","v":16212.001776000012},null,{"$f":"SUM(Q45:Q47)","v":2390.1016492800009},{"$f":"SUM(R45:R47)","v":21989.06983872001},null,{"$f":"SUM(T45:T47)","v":1672.3972325376003},{"$f":"SUM(U45:U47)","v":26200.889976422397},null,{"$f":"SUM(W45:W47)","v":1821.2486539345923},{"$f":"SUM(X45:X47)","v":28532.89557830862},null,{"$f":"SUM(Z45:Z47)","v":1947.4783616198251},{"$f":"SUM(AA45:AA47)","v":30510.494332043934},null,{"$f":"SUM(AC45:AC47)","v":2052.8960926902387},{"$f":"SUM(AD45:AD47)","v":32162.038785480414},null,{"$f":"SUM(AF45:AF47)","v":2139.1668052750201},{"$f":"SUM(AG45:AG47)","v":33513.613282641985},null,{"$f":"SUM(AI45:AI47)","v":2207.8222608530177},{"$f":"SUM(AJ45:AJ47)","v":34589.215420030618},null,{"$f":"SUM(AL45:AL47)","v":2260.2716799847776},{"$f":"SUM(AM45:AM47)","v":35410.922986428173},null,{"$f":"SUM(AO45:AO47)","v":2297.8115455859952},{"$f":"SUM(AP45:AP47)","v":35999.04754751391}]
[]
["Tax Rate  (to be entered)",null,null,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001]
[]
["Income Taxes Payable",null,null,null,{"$f":"E48*E50","v":221.90078160000004},{"$f":"F48*F50","v":-288.07817160000008},null,{"$f":"H48*H50","v":357.82352159999999},{"$f":"I48*I50","v":1620.526028400001},null,{"$f":"K48*K50","v":430.34691960000004},{"$f":"L48*L50","v":2887.2294204000009},null,{"$f":"N48*N50","v":527.96920536000016},{"$f":"O48*O50","v":4296.1804706400035},null,{"$f":"Q48*Q50","v":633.37693705920026},{"$f":"R48*R50","v":5827.1035072608029},null,{"$f":"T48*T50","v":443.1852666224641},{"$f":"U48*U50","v":6943.2358437519351},null,{"$f":"W48*W50","v":482.630893292667},{"$f":"X48*X50","v":7561.2173282517851},null,{"$f":"Z48*Z50","v":516.08176582925364},{"$f":"AA48*AA50","v":8085.2809979916428},null,{"$f":"AC48*AC50","v":544.01746456291323},{"$f":"AD48*AD50","v":8522.9402781523095},null,{"$f":"AF48*AF50","v":566.87920339788036},{"$f":"AG48*AG50","v":8881.1075199001261},null,{"$f":"AI48*AI50","v":585.07289912604972},{"$f":"AJ48*AJ50","v":9166.1420863081148},null,{"$f":"AL48*AL50","v":598.97199519596609},{"$f":"AM48*AM50","v":9383.8945914034666},null,{"$f":"AO48*AO50","v":608.92005958028881},{"$f":"AP48*AP50","v":9539.7476000911865}]
["Gross Up"]
["Income Taxes Payable",null,null,null,{"$f":"E52/(1-E50)","v":301.90582530612249},{"$f":"F52/(1-F50)","v":-391.94309061224499},null,{"$f":"H52/(1-H50)","v":486.83472326530614},{"$f":"I52/(1-I50)","v":2204.7973175510219},null,{"$f":"K52/(1-K50)","v":585.50601306122451},{"$f":"L52/(1-L50)","v":3928.2032930612258},null,{"$f":"N52/(1-N50)","v":718.32544946938799},{"$f":"O52/(1-O50)","v":5845.143497469393},null,{"$f":"Q52/(1-Q50)","v":861.73732933224528},{"$f":"R52/(1-R50)","v":7928.0319826677587},null,{"$f":"T52/(1-T50)","v":602.97315186729816},{"$f":"U52/(1-U50)","v":9446.5793792543336},null,{"$f":"W52/(1-W50)","v":656.64067114648572},{"$f":"X52/(1-X50)","v":10287.370514628279},null,{"$f":"Z52/(1-Z50)","v":702.15206235272603},{"$f":"AA52/(1-AA50)","v":11000.382310192712},null,{"$f":"AC52/(1-AC50)","v":740.15981573185479},{"$f":"AD52/(1-AD50)","v":11595.837113132395},null,{"$f":"AF52/(1-AF50)","v":771.2642223100413},{"$f":"AG52/(1-AG50)","v":12083.139482857314},null,{"$f":"AI52/(1-AI50)","v":796.01754983136016},{"$f":"AJ52/(1-AJ50)","v":12470.941614024647},null,{"$f":"AL52/(1-AL50)","v":814.92788462036208},{"$f":"AM52/(1-AM50)","v":12767.203525719002},null,{"$f":"AO52/(1-AO50)","v":828.46266609563099},{"$f":"AP52/(1-AP50)","v":12979.248435498213}]
["Grossed Up PILs",null,null,null,{"$f":"SUM(E54:E54)","v":301.90582530612249},{"$f":"SUM(F54:F54)","v":-391.94309061224499},null,{"$f":"SUM(H54:H54)","v":486.83472326530614},{"$f":"SUM(I54:I54)","v":2204.7973175510219},null,{"$f":"SUM(K54:K54)","v":585.50601306122451},{"$f":"SUM(L54:L54)","v":3928.2032930612258},null,{"$f":"SUM(N54:N54)","v":718.32544946938799},{"$f":"SUM(O54:O54)","v":5845.143497469393},null,{"$f":"SUM(Q54:Q54)","v":861.73732933224528},{"$f":"SUM(R54:R54)","v":7928.0319826677587},null,{"$f":"SUM(T54:T54)","v":602.97315186729816},{"$f":"SUM(U54:U54)","v":9446.5793792543336},null,{"$f":"SUM(W54:W54)","v":656.64067114648572},{"$f":"SUM(X54:X54)","v":10287.370514628279},null,{"$f":"SUM(Z54:Z54)","v":702.15206235272603},{"$f":"SUM(AA54:AA54)","v":11000.382310192712},null,{"$f":"SUM(AC54:AC54)","v":740.15981573185479},{"$f":"SUM(AD54:AD54)","v":11595.837113132395},null,{"$f":"SUM(AF54:AF54)","v":771.2642223100413},{"$f":"SUM(AG54:AG54)","v":12083.139482857314},null,{"$f":"SUM(AI54:AI54)","v":796.01754983136016},{"$f":"SUM(AJ54:AJ54)","v":12470.941614024647},null,{"$f":"SUM(AL54:AL54)","v":814.92788462036208},{"$f":"SUM(AM54:AM54)","v":12767.203525719002},null,{"$f":"SUM(AO54:AO54)","v":828.46266609563099},{"$f":"SUM(AP54:AP54)","v":12979.248435498213}]
[]
[]
["Appendix 2-FB"]
["Calculation of Renewable Generation Connection Direct Benefits/Provincial Amount: Renewable Enabling Improvement Investments"]
[]
[null,null,null,2015,2016,2017,2018,2019,2020,{"$f":"+I61+1","v":2021},2022,2023,2024,2025,2026,2027]
["Net Fixed Assets",null,null,{"$f":"(180000/25)/2","v":3600}]
[null,"Enter applicable amortization in years:",15]
["Opening Gross Fixed Assets",null,null,null,{"$f":"D66","v":180000},{"$f":"E66","v":360000},{"$f":"F66","v":540000},{"$f":"G66","v":720000},{"$f":"H66","v":900000},{"$f":"I66","v":900000},900000,900000,900000,900000,900000,900000]
["Gross Capital Additions",null,null,{"$f":"'App.2-FA Proposed REG Invest.'!C45","v":180000},{"$f":"'App.2-FA Proposed REG Invest.'!D45","v":180000},{"$f":"'App.2-FA Proposed REG Invest.'!E45","v":180000},{"$f":"'App.2-FA Proposed REG Invest.'!F45","v":180000},{"$f":"'App.2-FA Proposed REG Invest.'!G45","v":180000},{"$f":"'App.2-FA Proposed REG Invest.'!H45","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!I45","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!J45","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!K45","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!L45","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!M45","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!N45","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!O45","v":0}]
["Closing Gross Fixed Assets",null,null,{"$f":"SUM(D64:D65)","v":180000},{"$f":"SUM(E64:E65)","v":360000},540000,720000,900000,{"$f":"SUM(I64:I65)","v":900000},900000,{"$f":"SUM(K64:K65)","v":900000},900000,900000,900000,900000,{"$f":"SUM(P64:P65)","v":900000}]
[]
["Opening Accumulated Amortization",null,null,null,{"$f":"D71","v":6000},{"$f":"E71","v":24000},{"$f":"F71","v":54000},{"$f":"G71","v":96000},{"$f":"H71","v":150000},{"$f":"I71","v":210000},270000,330000,390000,450000,510000,570000]
["Current Year Amortization (before additions)",null,null,null,{"$f":"IF(ISERROR(E64/$C$63), 0, E64/$C$63)","v":12000},{"$f":"IF(ISERROR(F64/$C$63), 0, F64/$C$63)","v":24000},{"$f":"IF(ISERROR(G64/$C$63), 0, G64/$C$63)","v":36000},{"$f":"IF(ISERROR(H64/$C$63), 0, H64/$C$63)","v":48000},{"$f":"IF(ISERROR(I64/$C$63), 0, I64/$C$63)","v":60000},{"$f":"IF(ISERROR(J64/$C$63), 0, J64/$C$63)","v":60000},60000,{"$f":"IF(ISERROR(L64/$C$63), 0, L64/$C$63)","v":60000},60000,60000,60000,{"$f":"IF(ISERROR(P64/$C$63), 0, P64/$C$63)","v":60000}]
["Additions (half year)",null,null,{"$f":"D65/C63/2","v":6000},{"$f":"E65/C63/2","v":6000},{"$f":"F65/C63/2","v":6000},{"$f":"G65/C63/2","v":6000},{"$f":"H65/C63/2","v":6000},{"$f":"I65/$C$63/2","v":0},{"$f":"J65/$C$63/2","v":0},0,{"$f":"L65/$C$63/2","v":0},0,0,0,{"$f":"P65/$C$63/2","v":0}]
["Closing Accumulated Amortization",null,null,{"$f":"SUM(D68+D70)","v":6000},{"$f":"SUM(E68:E70)","v":24000},{"$f":"SUM(F68:F70)","v":54000},{"$f":"SUM(G68:G70)","v":96000},{"$f":"SUM(H68:H70)","v":150000},{"$f":"SUM(I68:I70)","v":210000},{"$f":"SUM(J68:J70)","v":270000},330000,{"$f":"SUM(L68:L70)","v":390000},450000,510000,570000,{"$f":"SUM(P68:P70)","v":630000}]
[]
["Opening Net Fixed Assets",null,null,{"$f":"D64-D68","v":0},{"$f":"D74","v":174000},{"$f":"E74","v":336000},{"$f":"F74","v":486000},{"$f":"G74","v":624000},{"$f":"H74","v":750000},{"$f":"I74","v":690000},630000,570000,510000,450000,390000,330000]
["Closing Net Fixed Assets",null,null,{"$f":"D66-D71","v":174000},336000,486000,624000,750000,690000,{"$f":"J66-J71","v":630000},570000,{"$f":"L66-L71","v":510000},450000,390000,330000,{"$f":"P66-P71","v":270000}]
["Average Net Fixed Assets",null,null,{"$f":"SUM(D73:D74)/2","v":87000},255000,411000,555000,687000,720000,{"$f":"SUM(J73:J74)/2","v":660000},600000,{"$f":"SUM(L73:L74)/2","v":540000},480000,420000,360000,{"$f":"SUM(P73:P74)/2","v":300000}]
[]
["UCC for PILs Calculation"]
[null,null,null,{"$f":"D61","v":2015},2016,2017,{"$f":"G61","v":2018},{"$f":"H61","v":2019},2020,2021,{"$f":"K61","v":2022},2023,2024,2025,2026,{"$f":"P61","v":2027}]
[]
["Opening UCC",null,null,null,{"$f":"D88","v":172800},{"$f":"E88","v":331776},{"$f":"F88","v":478033.91999999998},{"$f":"G88","v":612591.20639999991},{"$f":"H88","v":736383.90988799988},{"$f":"I88","v":677473.19709695992},623275.3413292031,573413.31402286689,527540.2489010375,485337.02898895449,446510.06666983815,410789.2613362511]
["Capital Additions (from Appendix 2-FA)",null,null,{"$f":"D65","v":180000},{"$f":"E65","v":180000},{"$f":"F65","v":180000},180000,180000,{"$f":"I65","v":0},0,{"$f":"K65","v":0},0,0,0,0,{"$f":"P65","v":0}]
["UCC Before Half Year Rule",null,null,{"$f":"SUM(D80:D81)","v":180000},352800,511776,658033.91999999993,792591.20639999991,736383.90988799988,{"$f":"SUM(J80:J81)","v":677473.19709695992},623275.3413292031,{"$f":"SUM(L80:L81)","v":573413.31402286689},527540.2489010375,485337.02898895449,446510.06666983815,{"$f":"SUM(P80:P81)","v":410789.2613362511}]
["Half Year Rule (1/2 Additions - Disposals)",null,null,{"$f":"D81/2","v":90000},90000,90000,90000,90000,0,{"$f":"J81/2","v":0},0,{"$f":"L81/2","v":0},0,0,0,{"$f":"P81/2","v":0}]
["Reduced UCC",null,null,{"$f":"D82-D83","v":90000},262800,421776,568033.91999999993,702591.20639999991,736383.90988799988,{"$f":"J82-J83","v":677473.19709695992},623275.3413292031,{"$f":"L82-L83","v":573413.31402286689},527540.2489010375,485337.02898895449,446510.06666983815,{"$f":"P82-P83","v":410789.2613362511}]
["CCA Rate Class (to be entered)",null,47,{"$f":"C85","v":47},{"$f":"C85","v":47},{"$f":"C85","v":47},{"$f":"C85","v":47},{"$f":"C85","v":47},{"$f":"D85","v":47},{"$f":"E85","v":47},47,47,47,47,47,47]
["CCA Rate  (to be entered)",null,0.08,{"$f":"C86","v":0.08},{"$f":"C86","v":0.08},{"$f":"C86","v":0.08},{"$f":"C86","v":0.08},{"$f":"C86","v":0.08},{"$f":"D86","v":0.08},0.08,0.08,0.08,0.08,0.08,0.08,0.08]
["CCA",null,null,{"$f":"D84*D86","v":7200},{"$f":"E84*E86","v":21024},33742.080000000002,45442.713599999995,{"$f":"H84*H86","v":56207.296511999994},{"$f":"I84*I86","v":58910.712791039994},{"$f":"J84*J86","v":54197.855767756795},49862.027306336247,{"$f":"L84*L86","v":45873.06512182935},42203.219912082997,38826.962319116363,35720.80533358705,{"$f":"P84*P86","v":32863.140906900087}]
["Closing UCC",null,null,{"$f":"D82-D87","v":172800},331776,478033.91999999998,612591.20639999991,736383.90988799988,677473.19709695992,{"$f":"J82-J87","v":623275.3413292031},573413.31402286689,{"$f":"L82-L87","v":527540.2489010375},485337.02898895449,446510.06666983815,410789.2613362511,{"$f":"P82-P87","v":377926.12042935099}]

{"sheet":"App.2-FC Calc of REG Expansion","index":2,"n_rows":86,"n_cols":42,"rows_kept":86,"cut":false,"hidden":false,"merged":[[8,39,8,41],[42,40,42,41],[8,21,8,23],[42,22,42,23],[8,18,8,20],[42,19,42,20],[0,0,0,5],[1,0,1,5],[3,0,3,5],[4,0,4,5],[5,0,5,5],[57,0,57,5],[58,0,58,5],[42,16,42,17],[8,6,8,8],[8,9,8,11],[8,12,8,14],[8,15,8,17],[39,0,39,12],[8,3,8,5],[40,0,40,1],[42,4,42,5],[42,7,42,8],[42,10,42,11],[42,13,42,14],[8,33,8,35],[42,34,42,35],[8,36,8,38],[42,37,42,38],[8,24,8,26],[42,25,42,26],[8,27,8,29],[42,28,42,29],[8,30,8,32],[42,31,42,32]]}
["Appendix 2-FC"]
["Calculation of Renewable Generation Connection Direct Benefits/Provincial Amount: Renewable Expansion Investments"]
[]
["This table will calculate the distributor/provincial shares of the investments entered in Part B of Appendix 2-FA."]
["Enter values in green shaded cells: WCA percentage, debt percentages, interest rates, kWh, tax rates, amortization period, CCA Class and percentage."]
["Rate Riders are not calculated for Test Year as these assets and costs are already in the distributors rate base."]
[]
[]
[null,null,null,"2015 Test Year",null,null,2016,null,null,2017,2016,null,2018,null,null,2019,null,null,2020,null,null,{"$f":"+S9+1","v":2021},null,null,{"$f":"+V9+1","v":2022},null,null,{"$f":"+Y9+1","v":2023},null,null,{"$f":"+AB9+1","v":2024},null,null,{"$f":"+AE9+1","v":2025},null,null,{"$f":"+AH9+1","v":2026},null,null,{"$f":"+AK9+1","v":2027}]
[null,null,null,null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial"]
[null,null,null,"Total",0.17,0.83,"Total",0.17,0.83,"Total",0.17,0.83,"Total",0.17,0.83,"Total",0.17,0.83,"Total",0.17,0.83,"Total",0.17,0.83,"Total",0.17,0.83,"Total",0.17,0.83,"Total",0.17,0.83,"Total",0.17,0.83,"Total",0.17,0.83,"Total",0.17,0.83]
["Net Fixed Assets (average)",null,null,{"$f":"D73","v":48416.666666666664},{"$f":"D12*E11","v":8230.8333333333339},{"$f":"D12*F11","v":40185.833333333328},{"$f":"E73","v":130250},{"$f":"G12*H11","v":22142.5},{"$f":"G12*I11","v":108107.5},{"$f":"F73","v":197238.09523809524},{"$f":"J12*K11","v":33530.476190476191},{"$f":"J12*L11","v":163707.61904761902},{"$f":"G73","v":264511.90476190479},{"$f":"M12*N11","v":44967.023809523816},{"$f":"M12*O11","v":219544.88095238098},{"$f":"H73","v":332023.80952380953},{"$f":"P12*Q11","v":56444.047619047626},{"$f":"P12*R11","v":275579.76190476189},{"$f":"I73","v":361190.47619047621},{"$f":"S12*T11","v":61402.380952380961},{"$f":"S12*U11","v":299788.09523809527},{"$f":"J73","v":351904.76190476189},{"$f":"V12*W11","v":59823.809523809527},{"$f":"V12*X11","v":292080.95238095237},{"$f":"K73","v":342619.04761904757},{"$f":"Y12*Z11","v":58245.238095238092},{"$f":"Y12*AA11","v":284373.80952380947},{"$f":"L73","v":333333.33333333337},{"$f":"AB12*AC11","v":56666.666666666679},{"$f":"AB12*AD11","v":276666.66666666669},{"$f":"M73","v":324047.61904761905},{"$f":"AE12*AF11","v":55088.095238095244},{"$f":"AE12*AG11","v":268959.52380952379},{"$f":"N73","v":314761.90476190473},{"$f":"AH12*AI11","v":53509.523809523809},{"$f":"AH12*AJ11","v":261252.38095238092},{"$f":"O73","v":305476.19047619042},{"$f":"AK12*AL11","v":51930.952380952374},{"$f":"AK12*AM11","v":253545.23809523802},{"$f":"P73","v":296190.47619047621},{"$f":"AN12*AO11","v":50352.380952380961},{"$f":"AN12*AP11","v":245838.09523809524}]
["Incremental OM&A (on-going, N/A for Provincial Recovery)",null,null,{"$f":"'App.2-FA Proposed REG Invest.'!C87","v":0},{"$f":"D13","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!D87","v":0},{"$f":"G13","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!E87","v":0},{"$f":"J13","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!F87","v":0},{"$f":"M13","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!G87","v":0},{"$f":"P13","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!H87","v":0},{"$f":"S13","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!I87","v":0},{"$f":"V13","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!J87","v":0},{"$f":"Y13","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!K87","v":0},{"$f":"AB13","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!L87","v":0},{"$f":"AE13","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!M87","v":0},{"$f":"AH13","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!N87","v":0},{"$f":"AK13","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!Q87","v":0},{"$f":"AN13","v":0}]
["Incremental OM&A (start-up, applicable for Provincial Recovery)",null,null,{"$f":"'App.2-FA Proposed REG Invest.'!C86","v":9800},{"$f":"D14*E11","v":1666.0000000000002},{"$f":"D14*F11","v":8134},{"$f":"'App.2-FA Proposed REG Invest.'!D86","v":7000},{"$f":"G14*H11","v":1190},{"$f":"G14*I11","v":5810},{"$f":"'App.2-FA Proposed REG Invest.'!E86","v":7200},{"$f":"J14*K11","v":1224},{"$f":"J14*L11","v":5976},{"$f":"'App.2-FA Proposed REG Invest.'!F86","v":7400},{"$f":"M14*N11","v":1258},{"$f":"M14*O11","v":6142},{"$f":"'App.2-FA Proposed REG Invest.'!G86","v":7600},{"$f":"P14*Q11","v":1292},{"$f":"P14*R11","v":6308},{"$f":"'App.2-FA Proposed REG Invest.'!H86","v":0},{"$f":"S14*T11","v":0},{"$f":"S14*U11","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!I86","v":0},{"$f":"V14*W11","v":0},{"$f":"V14*X11","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!J86","v":0},{"$f":"Y14*Z11","v":0},{"$f":"Y14*AA11","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!K86","v":0},{"$f":"AB14*AC11","v":0},{"$f":"AB14*AD11","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!L86","v":0},{"$f":"AE14*AF11","v":0},{"$f":"AE14*AG11","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!M86","v":0},{"$f":"AH14*AI11","v":0},{"$f":"AH14*AJ11","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!N86","v":0},{"$f":"AK14*AL11","v":0},{"$f":"AK14*AM11","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!Q86","v":0},{"$f":"AN14*AO11","v":0},{"$f":"AN14*AP11","v":0}]
["WCA",0.13,null,null,{"$f":"(E13+E14)*$B$15","v":216.58000000000004},{"$f":"F14*$B$15","v":1057.42},null,{"$f":"(H13+H14)*$B$15","v":154.70000000000002},{"$f":"I14*$B$15","v":755.30000000000007},null,{"$f":"(K13+K14)*$B$15","v":159.12},{"$f":"L14*$B$15","v":776.88},null,{"$f":"(N13+N14)*$B$15","v":163.54},{"$f":"O14*$B$15","v":798.46},null,{"$f":"(Q13+Q14)*$B$15","v":167.96},{"$f":"R14*$B$15","v":820.04000000000008},null,{"$f":"(T13+T14)*$B$15","v":0},{"$f":"U14*$B$15","v":0},null,{"$f":"(W13+W14)*$B$15","v":0},{"$f":"X14*$B$15","v":0},null,{"$f":"(Z13+Z14)*$B$15","v":0},{"$f":"AA14*$B$15","v":0},null,{"$f":"(AC13+AC14)*$B$15","v":0},{"$f":"AD14*$B$15","v":0},null,{"$f":"(AF13+AF14)*$B$15","v":0},{"$f":"AG14*$B$15","v":0},null,{"$f":"(AI13+AI14)*$B$15","v":0},{"$f":"AJ14*$B$15","v":0},null,{"$f":"(AL13+AL14)*$B$15","v":0},{"$f":"AM14*$B$15","v":0},null,{"$f":"(AO13+AO14)*$B$15","v":0},{"$f":"AP14*$B$15","v":0}]
["Rate Base",null,null,null,{"$f":"SUM(E12+E15)","v":8447.4133333333339},{"$f":"SUM(F12+F15)","v":41243.253333333327},null,{"$f":"SUM(H12+H15)","v":22297.200000000001},{"$f":"SUM(I12+I15)","v":108862.8},null,{"$f":"SUM(K12+K15)","v":33689.596190476193},{"$f":"SUM(L12+L15)","v":164484.49904761903},null,{"$f":"SUM(N12+N15)","v":45130.563809523817},{"$f":"SUM(O12+O15)","v":220343.34095238097},null,{"$f":"SUM(Q12+Q15)","v":56612.007619047625},{"$f":"SUM(R12+R15)","v":276399.80190476187},null,{"$f":"SUM(T12+T15)","v":61402.380952380961},{"$f":"SUM(U12+U15)","v":299788.09523809527},null,{"$f":"SUM(W12+W15)","v":59823.809523809527},{"$f":"SUM(X12+X15)","v":292080.95238095237},null,{"$f":"SUM(Z12+Z15)","v":58245.238095238092},{"$f":"SUM(AA12+AA15)","v":284373.80952380947},null,{"$f":"SUM(AC12+AC15)","v":56666.666666666679},{"$f":"SUM(AD12+AD15)","v":276666.66666666669},null,{"$f":"SUM(AF12+AF15)","v":55088.095238095244},{"$f":"SUM(AG12+AG15)","v":268959.52380952379},null,{"$f":"SUM(AI12+AI15)","v":53509.523809523809},{"$f":"SUM(AJ12+AJ15)","v":261252.38095238092},null,{"$f":"SUM(AL12+AL15)","v":51930.952380952374},{"$f":"SUM(AM12+AM15)","v":253545.23809523802},null,{"$f":"SUM(AO12+AO15)","v":50352.380952380961},{"$f":"SUM(AP12+AP15)","v":245838.09523809524}]
[]
[]
["Deemed ST Debt",0.04,null,null,{"$f":"E16*$B$19","v":337.89653333333337},{"$f":"F16*$B$19","v":1649.730133333333},null,{"$f":"H16*$B$19","v":891.88800000000003},{"$f":"I16*$B$19","v":4354.5120000000006},null,{"$f":"K16*$B$19","v":1347.5838476190477},{"$f":"L16*$B$19","v":6579.3799619047613},null,{"$f":"N16*$B$19","v":1805.2225523809527},{"$f":"O16*$B$19","v":8813.7336380952383},null,{"$f":"Q16*$B$19","v":2264.4803047619052},{"$f":"R16*$B$19","v":11055.992076190476},null,{"$f":"T16*$B$19","v":2456.0952380952385},{"$f":"U16*$B$19","v":11991.523809523811},null,{"$f":"W16*$B$19","v":2392.9523809523812},{"$f":"X16*$B$19","v":11683.238095238095},null,{"$f":"Z16*$B$19","v":2329.8095238095239},{"$f":"AA16*$B$19","v":11374.95238095238},null,{"$f":"AC16*$B$19","v":2266.6666666666674},{"$f":"AD16*$B$19","v":11066.666666666668},null,{"$f":"AF16*$B$19","v":2203.5238095238096},{"$f":"AG16*$B$19","v":10758.380952380952},null,{"$f":"AI16*$B$19","v":2140.3809523809523},{"$f":"AJ16*$B$19","v":10450.095238095237},null,{"$f":"AL16*$B$19","v":2077.238095238095},{"$f":"AM16*$B$19","v":10141.809523809521},null,{"$f":"AO16*$B$19","v":2014.0952380952385},{"$f":"AP16*$B$19","v":9833.5238095238092}]
["Deemed LT Debt",0.56000000000000005,null,null,{"$f":"E16*$B$20","v":4730.5514666666677},{"$f":"F16*$B$20","v":23096.221866666667},null,{"$f":"H16*$B$20","v":12486.432000000001},{"$f":"I16*$B$20","v":60963.168000000005},null,{"$f":"K16*$B$20","v":18866.173866666672},{"$f":"L16*$B$20","v":92111.319466666668},null,{"$f":"N16*$B$20","v":25273.115733333339},{"$f":"O16*$B$20","v":123392.27093333335},null,{"$f":"Q16*$B$20","v":31702.724266666672},{"$f":"R16*$B$20","v":154783.88906666666},null,{"$f":"T16*$B$20","v":34385.333333333343},{"$f":"U16*$B$20","v":167881.33333333337},null,{"$f":"W16*$B$20","v":33501.333333333336},{"$f":"X16*$B$20","v":163565.33333333334},null,{"$f":"Z16*$B$20","v":32617.333333333336},{"$f":"AA16*$B$20","v":159249.33333333331},null,{"$f":"AC16*$B$20","v":31733.333333333343},{"$f":"AD16*$B$20","v":154933.33333333337},null,{"$f":"AF16*$B$20","v":30849.333333333339},{"$f":"AG16*$B$20","v":150617.33333333334},null,{"$f":"AI16*$B$20","v":29965.333333333336},{"$f":"AJ16*$B$20","v":146301.33333333331},null,{"$f":"AL16*$B$20","v":29081.333333333332},{"$f":"AM16*$B$20","v":141985.33333333331},null,{"$f":"AO16*$B$20","v":28197.333333333339},{"$f":"AP16*$B$20","v":137669.33333333334}]
["Deemed Equity",0.4,null,null,{"$f":"E16*$B$21","v":3378.9653333333335},{"$f":"F16*$B$21","v":16497.301333333333},null,{"$f":"H16*$B$21","v":8918.880000000001},{"$f":"I16*$B$21","v":43545.120000000003},null,{"$f":"K16*$B$21","v":13475.838476190478},{"$f":"L16*$B$21","v":65793.799619047611},null,{"$f":"N16*$B$21","v":18052.225523809528},{"$f":"O16*$B$21","v":88137.336380952387},null,{"$f":"Q16*$B$21","v":22644.803047619051},{"$f":"R16*$B$21","v":110559.92076190475},null,{"$f":"T16*$B$21","v":24560.952380952385},{"$f":"U16*$B$21","v":119915.23809523811},null,{"$f":"W16*$B$21","v":23929.523809523813},{"$f":"X16*$B$21","v":116832.38095238095},null,{"$f":"Z16*$B$21","v":23298.095238095237},{"$f":"AA16*$B$21","v":113749.52380952379},null,{"$f":"AC16*$B$21","v":22666.666666666672},{"$f":"AD16*$B$21","v":110666.66666666669},null,{"$f":"AF16*$B$21","v":22035.238095238099},{"$f":"AG16*$B$21","v":107583.80952380953},null,{"$f":"AI16*$B$21","v":21403.809523809527},{"$f":"AJ16*$B$21","v":104500.95238095237},null,{"$f":"AL16*$B$21","v":20772.38095238095},{"$f":"AM16*$B$21","v":101418.09523809521},null,{"$f":"AO16*$B$21","v":20140.952380952385},{"$f":"AP16*$B$21","v":98335.238095238106}]
[]
["ST Interest",2.1600000000000001E-2,null,null,{"$f":"E19*$B$23","v":7.298565120000001},{"$f":"F19*$B$23","v":35.634170879999992},null,{"$f":"H19*$B$23","v":19.2647808},{"$f":"I19*$B$23","v":94.057459200000025},null,{"$f":"K19*$B$23","v":29.107811108571433},{"$f":"L19*$B$23","v":142.11460717714286},null,{"$f":"N19*$B$23","v":38.992807131428577},{"$f":"O19*$B$23","v":190.37664658285715},null,{"$f":"Q19*$B$23","v":48.912774582857153},{"$f":"R19*$B$23","v":238.80942884571428},null,{"$f":"T19*$B$23","v":53.051657142857152},{"$f":"U19*$B$23","v":259.01691428571434},null,{"$f":"W19*$B$23","v":51.687771428571438},{"$f":"X19*$B$23","v":252.35794285714289},null,{"$f":"Z19*$B$23","v":50.323885714285716},{"$f":"AA19*$B$23","v":245.69897142857141},null,{"$f":"AC19*$B$23","v":48.960000000000022},{"$f":"AD19*$B$23","v":239.04000000000005},null,{"$f":"AF19*$B$23","v":47.596114285714293},{"$f":"AG19*$B$23","v":232.38102857142857},null,{"$f":"AI19*$B$23","v":46.232228571428571},{"$f":"AJ19*$B$23","v":225.72205714285712},null,{"$f":"AL19*$B$23","v":44.868342857142856},{"$f":"AM19*$B$23","v":219.06308571428568},null,{"$f":"AO19*$B$23","v":43.504457142857156},{"$f":"AP19*$B$23","v":212.40411428571429}]
["LT Interest",6.0728710462287103E-2,null,null,{"$f":"E20*$B$24","v":287.28029034614764},{"$f":"F20*$B$24","v":1402.6037705135441},null,{"$f":"H20*$B$24","v":758.28491363503656},{"$f":"I20*$B$24","v":3702.2145783357664},null,{"$f":"K20*$B$24","v":1145.7184102799679},{"$f":"L20*$B$24","v":5593.8016501904294},null,{"$f":"N20*$B$24","v":1534.8037278494733},{"$f":"O20*$B$24","v":7493.4534947944858},null,{"$f":"Q20*$B$24","v":1925.2655628561236},{"$f":"R20*$B$24","v":9399.8259833563661},null,{"$f":"T20*$B$24","v":2088.1769521492301},{"$f":"U20*$B$24","v":10195.216884022711},null,{"$f":"W20*$B$24","v":2034.4927721005679},{"$f":"X20*$B$24","v":9933.1117696674773},null,{"$f":"Z20*$B$24","v":1980.8085920519061},{"$f":"AA20*$B$24","v":9671.0066553122451},null,{"$f":"AC20*$B$24","v":1927.1244120032447},{"$f":"AD20*$B$24","v":9408.9015409570184},null,{"$f":"AF20*$B$24","v":1873.4402319545827},{"$f":"AG20*$B$24","v":9146.7964266017843},null,{"$f":"AI20*$B$24","v":1819.7560519059207},{"$f":"AJ20*$B$24","v":8884.6913122465521},null,{"$f":"AL20*$B$24","v":1766.0718718572587},{"$f":"AM20*$B$24","v":8622.5861978913199},null,{"$f":"AO20*$B$24","v":1712.3876918085973},{"$f":"AP20*$B$24","v":8360.4810835360913}]
["ROE",9.2999999999999999E-2,null,null,{"$f":"E21*$B$25","v":314.24377600000003},{"$f":"F21*$B$25","v":1534.249024},null,{"$f":"H21*$B$25","v":829.45584000000008},{"$f":"I21*$B$25","v":4049.6961600000004},null,{"$f":"K21*$B$25","v":1253.2529782857146},{"$f":"L21*$B$25","v":6118.8233645714281},null,{"$f":"N21*$B$25","v":1678.8569737142861},{"$f":"O21*$B$25","v":8196.7722834285723},null,{"$f":"Q21*$B$25","v":2105.9666834285717},{"$f":"R21*$B$25","v":10282.072630857141},null,{"$f":"T21*$B$25","v":2284.1685714285718},{"$f":"U21*$B$25","v":11152.117142857143},null,{"$f":"W21*$B$25","v":2225.4457142857145},{"$f":"X21*$B$25","v":10865.411428571428},null,{"$f":"Z21*$B$25","v":2166.7228571428568},{"$f":"AA21*$B$25","v":10578.705714285712},null,{"$f":"AC21*$B$25","v":2108.0000000000005},{"$f":"AD21*$B$25","v":10292.000000000002},null,{"$f":"AF21*$B$25","v":2049.2771428571432},{"$f":"AG21*$B$25","v":10005.294285714286},null,{"$f":"AI21*$B$25","v":1990.5542857142859},{"$f":"AJ21*$B$25","v":9718.5885714285705},null,{"$f":"AL21*$B$25","v":1931.8314285714284},{"$f":"AM21*$B$25","v":9431.8828571428548},null,{"$f":"AO21*$B$25","v":1873.1085714285718},{"$f":"AP21*$B$25","v":9145.1771428571446}]
["Cost of Capital Total",null,null,null,{"$f":"SUM(E23:E25)","v":608.82263146614764},{"$f":"SUM(F23:F25)","v":2972.4869653935439},null,{"$f":"SUM(H23:H25)","v":1607.0055344350367},{"$f":"SUM(I23:I25)","v":7845.9681975357671},null,{"$f":"SUM(K23:K25)","v":2428.0791996742537},{"$f":"SUM(L23:L25)","v":11854.739621938999},null,{"$f":"SUM(N23:N25)","v":3252.6535086951881},{"$f":"SUM(O23:O25)","v":15880.602424805915},null,{"$f":"SUM(Q23:Q25)","v":4080.1450208675524},{"$f":"SUM(R23:R25)","v":19920.708043059221},null,{"$f":"SUM(T23:T25)","v":4425.397180720659},{"$f":"SUM(U23:U25)","v":21606.350941165569},null,{"$f":"SUM(W23:W25)","v":4311.6262578148544},{"$f":"SUM(X23:X25)","v":21050.881141096048},null,{"$f":"SUM(Z23:Z25)","v":4197.8553349090489},{"$f":"SUM(AA23:AA25)","v":20495.411341026527},null,{"$f":"SUM(AC23:AC25)","v":4084.0844120032452},{"$f":"SUM(AD23:AD25)","v":19939.941540957021},null,{"$f":"SUM(AF23:AF25)","v":3970.3134890974402},{"$f":"SUM(AG23:AG25)","v":19384.4717408875},null,{"$f":"SUM(AI23:AI25)","v":3856.5425661916352},{"$f":"SUM(AJ23:AJ25)","v":18829.00194081798},null,{"$f":"SUM(AL23:AL25)","v":3742.7716432858297},{"$f":"SUM(AM23:AM25)","v":18273.532140748459},null,{"$f":"SUM(AO23:AO25)","v":3629.000720380026},{"$f":"SUM(AP23:AP25)","v":17718.062340678953}]
[]
["OM&A",null,null,null,{"$f":"E13+E14","v":1666.0000000000002},{"$f":"F14","v":8134},null,{"$f":"H13+H14","v":1190},{"$f":"I14","v":5810},null,{"$f":"K13+K14","v":1224},{"$f":"L14","v":5976},null,{"$f":"N13+N14","v":1258},{"$f":"O14","v":6142},null,{"$f":"Q13+Q14","v":1292},{"$f":"R14","v":6308},null,{"$f":"T13+T14","v":0},{"$f":"U14","v":0},null,{"$f":"W13+W14","v":0},{"$f":"X14","v":0},null,{"$f":"Z13+Z14","v":0},{"$f":"AA14","v":0},null,{"$f":"AC13+AC14","v":0},{"$f":"AD14","v":0},null,{"$f":"AF13+AF14","v":0},{"$f":"AG14","v":0},null,{"$f":"AI13+AI14","v":0},{"$f":"AJ14","v":0},null,{"$f":"AL13+AL14","v":0},{"$f":"AM14","v":0},null,{"$f":"AO13+AO14","v":0},{"$f":"AP14","v":0}]
["Amortization",null,null,{"$f":"D69","v":1166.6666666666667},{"$f":"D29*E$11","v":198.33333333333337},{"$f":"D29*F$11","v":968.33333333333337},{"$f":"E67+E68","v":3166.666666666667},{"$f":"G29*H$11","v":538.33333333333337},{"$f":"G29*I$11","v":2628.3333333333335},{"$f":"F67+F68","v":4857.1428571428569},{"$f":"J29*K$11","v":825.71428571428578},{"$f":"J29*L$11","v":4031.4285714285711},{"$f":"G67+G68","v":6595.2380952380954},{"$f":"M29*N$11","v":1121.1904761904764},{"$f":"M29*O$11","v":5474.0476190476193},{"$f":"H67+H68","v":8380.9523809523816},{"$f":"P29*Q$11","v":1424.761904761905},{"$f":"P29*R$11","v":6956.1904761904761},{"$f":"I67+I68","v":9285.7142857142862},{"$f":"S29*T$11","v":1578.5714285714287},{"$f":"S29*U$11","v":7707.1428571428569},{"$f":"J67+J68","v":9285.7142857142862},{"$f":"V29*W$11","v":1578.5714285714287},{"$f":"V29*X$11","v":7707.1428571428569},{"$f":"K67+K68","v":9285.7142857142862},{"$f":"Y29*Z$11","v":1578.5714285714287},{"$f":"Y29*AA$11","v":7707.1428571428569},{"$f":"L67+L68","v":9285.7142857142862},{"$f":"AB29*AC$11","v":1578.5714285714287},{"$f":"AB29*AD$11","v":7707.1428571428569},{"$f":"M67+M68","v":9285.7142857142862},{"$f":"AE29*AF$11","v":1578.5714285714287},{"$f":"AE29*AG$11","v":7707.1428571428569},{"$f":"N67+N68","v":9285.7142857142862},{"$f":"AH29*AI$11","v":1578.5714285714287},{"$f":"AH29*AJ$11","v":7707.1428571428569},{"$f":"O67+O68","v":9285.7142857142862},{"$f":"AK29*AL$11","v":1578.5714285714287},{"$f":"AK29*AM$11","v":7707.1428571428569},{"$f":"P67+P68","v":9285.7142857142862},{"$f":"AN29*AO$11","v":1578.5714285714287},{"$f":"AN29*AP$11","v":7707.1428571428569}]
["Grossed-up PILs",null,null,null,{"$f":"E55","v":-55.459953777777791},{"$f":"F55","v":-270.77506844444446},null,{"$f":"H55","v":-139.78257015873012},{"$f":"I55","v":-682.46784253968201},null,{"$f":"K55","v":-180.87843461224494},{"$f":"L55","v":-883.11235722449021},null,{"$f":"N55","v":-204.4103975826369},{"$f":"O55","v":-998.00370584463883},null,{"$f":"Q55","v":-211.60653504991004},{"$f":"R55","v":-1033.1377887730921},null,{"$f":"T55","v":-159.4637670769896},{"$f":"U55","v":-778.55839219941902},null,{"$f":"W55","v":-56.46376658546604},{"$f":"X55","v":-275.6760368584504},null,{"$f":"Z55","v":36.602458939621677},{"$f":"AA55","v":178.70612305815476},null,{"$f":"AC55","v":120.52961149558958},{"$f":"AD55","v":588.46810318434882},null,{"$f":"AF55","v":196.04881691996539},{"$f":"AG55","v":957.17951790336053},null,{"$f":"AI55","v":263.83271098327788},{"$f":"AJ55","v":1288.1244124477678},null,{"$f":"AL55","v":324.50011859441145},{"$f":"AM55","v":1584.3241084315378},null,{"$f":"AO55","v":378.62035866954079},{"$f":"AP55","v":1848.5582217395222}]
[]
["Revenue Requirement",null,null,null,{"$f":"SUM(E26:E30)","v":2417.6960110217037},{"$f":"SUM(F26:F30)","v":11804.045230282434},null,{"$f":"SUM(H26:H30)","v":3195.5562976096398},{"$f":"SUM(I26:I30)","v":15601.83368832942},null,{"$f":"SUM(K26:K30)","v":4296.9150507762952},{"$f":"SUM(L26:L30)","v":20979.055836143081},null,{"$f":"SUM(N26:N30)","v":5427.4335873030277},{"$f":"SUM(O26:O30)","v":26498.646338008894},null,{"$f":"SUM(Q26:Q30)","v":6585.3003905795467},{"$f":"SUM(R26:R30)","v":32151.760730476606},null,{"$f":"SUM(T26:T30)","v":5844.5048422150976},{"$f":"SUM(U26:U30)","v":28534.935406109005},null,{"$f":"SUM(W26:W30)","v":5833.7339198008167},{"$f":"SUM(X26:X30)","v":28482.347961380452},null,{"$f":"SUM(Z26:Z30)","v":5813.0292224200994},{"$f":"SUM(AA26:AA30)","v":28381.260321227535},null,{"$f":"SUM(AC26:AC30)","v":5783.1854520702636},{"$f":"SUM(AD26:AD30)","v":28235.552501284226},null,{"$f":"SUM(AF26:AF30)","v":5744.9337345888343},{"$f":"SUM(AG26:AG30)","v":28048.794115933717},null,{"$f":"SUM(AI26:AI30)","v":5698.9467057463416},{"$f":"SUM(AJ26:AJ30)","v":27824.269210408602},null,{"$f":"SUM(AL26:AL30)","v":5645.8431904516692},{"$f":"SUM(AM26:AM30)","v":27564.999106322852},null,{"$f":"SUM(AO26:AO30)","v":5586.1925076209955},{"$f":"SUM(AP26:AP30)","v":27273.763419561328}]
[]
[]
["Provincial Rate Protection",null,null,null,null,{"$f":"F32","v":11804.045230282434},null,null,{"$f":"I32","v":15601.83368832942},null,null,{"$f":"L32","v":20979.055836143081},null,null,{"$f":"O32","v":26498.646338008894},null,null,{"$f":"R32","v":32151.760730476606},null,null,{"$f":"U32","v":28534.935406109005},null,null,{"$f":"X32","v":28482.347961380452},null,null,{"$f":"AA32","v":28381.260321227535},null,null,{"$f":"AD32","v":28235.552501284226},null,null,{"$f":"AG32","v":28048.794115933717},null,null,{"$f":"AJ32","v":27824.269210408602},null,null,{"$f":"AM32","v":27564.999106322852},null,null,{"$f":"AP32","v":27273.763419561328}]
[]
["Monthly Amount Paid by IESO",null,null,null,null,{"$f":"F35/12","v":983.67043585686952},null,null,{"$f":"I35/12","v":1300.1528073607849},null,null,{"$f":"L35/12","v":1748.2546530119234},null,null,{"$f":"O35/12","v":2208.2205281674078},null,null,{"$f":"R35/12","v":2679.3133942063837},null,null,{"$f":"U35/12","v":2377.9112838424171},null,null,{"$f":"X35/12","v":2373.5289967817043},null,null,{"$f":"AA35/12","v":2365.1050267689611},null,null,{"$f":"AD35/12","v":2352.9627084403523},null,null,{"$f":"AG35/12","v":2337.3995096611429},null,null,{"$f":"AJ35/12","v":2318.6891008673833},null,null,{"$f":"AM35/12","v":2297.0832588602375},null,null,{"$f":"AP35/12","v":2272.8136182967773}]
[]
["Note 1: The difference between the actual costs of approved eligible investments and revenue received from the IESO should be recorded in a variance account.  The Board may provide regulatory accounting guidance regarding a variance account either in an individual proceeding or on a generic basis."]
["Note 2: For the 2014 Test Year, Costs and Revenues of the Direct Benefit are to be included in the test year applicant Rate Base and Revenues."]
[]
["PILs Calculation"]
[null,null,null,null,2015,null,null,2016,null,null,2017,null,null,2018,null,null,2019,null,null,{"$f":"S9","v":2020},null,null,{"$f":"V9","v":2021},null,null,{"$f":"Y9","v":2022},null,null,{"$f":"AB9","v":2023},null,null,{"$f":"AE9","v":2024},null,null,{"$f":"AH9","v":2025},null,null,{"$f":"AK9","v":2026},null,null,{"$f":"AN9","v":2027}]
["Income Tax",null,null,null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total"]
["Net Income - ROE on Rate Base",null,null,null,{"$f":"E25","v":314.24377600000003},{"$f":"F25","v":1534.249024},null,{"$f":"H25","v":829.45584000000008},{"$f":"I25","v":4049.6961600000004},null,{"$f":"K25","v":1253.2529782857146},{"$f":"L25","v":6118.8233645714281},null,{"$f":"N25","v":1678.8569737142861},{"$f":"O25","v":8196.7722834285723},null,{"$f":"Q25","v":2105.9666834285717},{"$f":"R25","v":10282.072630857141},null,{"$f":"T25","v":2284.1685714285718},{"$f":"U25","v":11152.117142857143},null,{"$f":"W25","v":2225.4457142857145},{"$f":"X25","v":10865.411428571428},null,{"$f":"Z25","v":2166.7228571428568},{"$f":"AA25","v":10578.705714285712},null,{"$f":"AC25","v":2108.0000000000005},{"$f":"AD25","v":10292.000000000002},null,{"$f":"AF25","v":2049.2771428571432},{"$f":"AG25","v":10005.294285714286},null,{"$f":"AI25","v":1990.5542857142859},{"$f":"AJ25","v":9718.5885714285705},null,{"$f":"AL25","v":1931.8314285714284},{"$f":"AM25","v":9431.8828571428548},null,{"$f":"AO25","v":1873.1085714285718},{"$f":"AP25","v":9145.1771428571446}]
["Amortization (17% DB and 83% P)",null,null,null,{"$f":"E29","v":198.33333333333337},{"$f":"F29","v":968.33333333333337},null,{"$f":"H29","v":538.33333333333337},{"$f":"I29","v":2628.3333333333335},null,{"$f":"K29","v":825.71428571428578},{"$f":"L29","v":4031.4285714285711},null,{"$f":"N29","v":1121.1904761904764},{"$f":"O29","v":5474.0476190476193},null,{"$f":"Q29","v":1424.761904761905},{"$f":"R29","v":6956.1904761904761},null,{"$f":"T29","v":1578.5714285714287},{"$f":"U29","v":7707.1428571428569},null,{"$f":"W29","v":1578.5714285714287},{"$f":"X29","v":7707.1428571428569},null,{"$f":"Z29","v":1578.5714285714287},{"$f":"AA29","v":7707.1428571428569},null,{"$f":"AC29","v":1578.5714285714287},{"$f":"AD29","v":7707.1428571428569},null,{"$f":"AF29","v":1578.5714285714287},{"$f":"AG29","v":7707.1428571428569},null,{"$f":"AI29","v":1578.5714285714287},{"$f":"AJ29","v":7707.1428571428569},null,{"$f":"AL29","v":1578.5714285714287},{"$f":"AM29","v":7707.1428571428569},null,{"$f":"AO29","v":1578.5714285714287},{"$f":"AP29","v":7707.1428571428569}]
["CCA (17% DB and 83% P)",null,null,null,{"$f":"-D85*E$11","v":-666.40000000000009},{"$f":"-D85*F$11","v":-3253.6},null,{"$f":"-E85*H$11","v":-1755.4880000000001},{"$f":"-E85*I$11","v":-8570.9119999999984},null,{"$f":"-F85*K$11","v":-2580.6489600000004},{"$f":"-F85*L$11","v":-12599.63904},null,{"$f":"-G85*N$11","v":-3366.9970432000005},{"$f":"-G85*O$11","v":-16438.867916800002},null,{"$f":"-H85*Q$11","v":-4117.6372797440008},{"$f":"-H85*R$11","v":-20103.758483456004},null,{"$f":"-I85*T$11","v":-4305.0262973644813},{"$f":"-I85*U$11","v":-21018.657804779523},null,{"$f":"-J85*W$11","v":-3960.6241935753224},{"$f":"-J85*X$11","v":-19337.165180397158},null,{"$f":"-K85*Z$11","v":-3643.7742580892968},{"$f":"-K85*AA$11","v":-17790.191965965387},null,{"$f":"-L85*AC$11","v":-3352.2723174421526},{"$f":"-L85*AD$11","v":-16366.976608688155},null,{"$f":"-M85*AF$11","v":-3084.0905320467809},{"$f":"-M85*AG$11","v":-15057.618479993105},null,{"$f":"-N85*AI$11","v":-2837.3632894830384},{"$f":"-N85*AJ$11","v":-13853.009001593657},null,{"$f":"-O85*AL$11","v":-2610.3742263243953},{"$f":"-O85*AM$11","v":-12744.768281466164},null,{"$f":"-P85*AO$11","v":-2401.5442882184439},{"$f":"-P85*AP$11","v":-11725.186818948872}]
["Taxable income",null,null,null,{"$f":"SUM(E46:E48)","v":-153.82289066666669},{"$f":"SUM(F46:F48)","v":-751.01764266666669},null,{"$f":"SUM(H46:H48)","v":-387.69882666666649},{"$f":"SUM(I46:I48)","v":-1892.882506666665},null,{"$f":"SUM(K46:K48)","v":-501.6816960000001},{"$f":"SUM(L46:L48)","v":-2449.3871040000013},null,{"$f":"SUM(N46:N48)","v":-566.94959329523817},{"$f":"SUM(O46:O48)","v":-2768.0480143238092},null,{"$f":"SUM(Q46:Q48)","v":-586.90869155352402},{"$f":"SUM(R46:R48)","v":-2865.4953764083875},null,{"$f":"SUM(T46:T48)","v":-442.28629736448056},{"$f":"SUM(U46:U48)","v":-2159.3978047795208},null,{"$f":"SUM(W46:W48)","v":-156.60705071817938},{"$f":"SUM(X46:X48)","v":-764.61089468287173},null,{"$f":"SUM(Z46:Z48)","v":101.52002762498842},{"$f":"SUM(AA46:AA48)","v":495.65660546318395},null,{"$f":"SUM(AC46:AC48)","v":334.29911112927675},{"$f":"SUM(AD46:AD48)","v":1632.1662484547032},null,{"$f":"SUM(AF46:AF48)","v":543.7580393817907},{"$f":"SUM(AG46:AG48)","v":2654.8186628640378},null,{"$f":"SUM(AI46:AI48)","v":731.76242480267638},{"$f":"SUM(AJ46:AJ48)","v":3572.7224269777707},null,{"$f":"SUM(AL46:AL48)","v":900.02863081846181},{"$f":"SUM(AM46:AM48)","v":4394.2574328195478},null,{"$f":"SUM(AO46:AO48)","v":1050.1357117815564},{"$f":"SUM(AP46:AP48)","v":5127.1331810511274}]
[]
["Tax Rate  (to be entered)",null,null,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001]
["Income Taxes Payable",null,null,null,{"$f":"E49*E51","v":-40.763066026666678},{"$f":"F49*F51","v":-199.01967530666667},null,{"$f":"H49*H51","v":-102.74018906666663},{"$f":"I49*I51","v":-501.61386426666627},null,{"$f":"K49*K51","v":-132.94564944000004},{"$f":"L49*L51","v":-649.08758256000033},null,{"$f":"N49*N51","v":-150.24164222323813},{"$f":"O49*O51","v":-733.53272379580949},null,{"$f":"Q49*Q51","v":-155.53080326168387},{"$f":"R49*R51","v":-759.35627474822275},null,{"$f":"T49*T51","v":-117.20586880158736},{"$f":"U49*U51","v":-572.24041826657299},null,{"$f":"W49*W51","v":-41.500868440317539},{"$f":"X49*X51","v":-202.62188709096102},null,{"$f":"Z49*Z51","v":26.902807320621932},{"$f":"AA49*AA51","v":131.34900044774375},null,{"$f":"AC49*AC51","v":88.589264449258337},{"$f":"AD49*AD51","v":432.52405584049637},null,{"$f":"AF49*AF51","v":144.09588043617455},{"$f":"AG49*AG51","v":703.52694565897002},null,{"$f":"AI49*AI51","v":193.91704257270925},{"$f":"AJ49*AJ51","v":946.77144314910925},null,{"$f":"AL49*AL51","v":238.50758716689239},{"$f":"AM49*AM51","v":1164.4782196971803},null,{"$f":"AO49*AO51","v":278.28596362211249},{"$f":"AP49*AP51","v":1358.6902929785488}]
["Gross Up"]
["Income Taxes Payable",null,null,null,{"$f":"E52/(1-E51)","v":-55.459953777777791},{"$f":"F52/(1-F51)","v":-270.77506844444446},null,{"$f":"H52/(1-H51)","v":-139.78257015873012},{"$f":"I52/(1-I51)","v":-682.46784253968201},null,{"$f":"K52/(1-K51)","v":-180.87843461224494},{"$f":"L52/(1-L51)","v":-883.11235722449021},null,{"$f":"N52/(1-N51)","v":-204.4103975826369},{"$f":"O52/(1-O51)","v":-998.00370584463883},null,{"$f":"Q52/(1-Q51)","v":-211.60653504991004},{"$f":"R52/(1-R51)","v":-1033.1377887730921},null,{"$f":"T52/(1-T51)","v":-159.4637670769896},{"$f":"U52/(1-U51)","v":-778.55839219941902},null,{"$f":"W52/(1-W51)","v":-56.46376658546604},{"$f":"X52/(1-X51)","v":-275.6760368584504},null,{"$f":"Z52/(1-Z51)","v":36.602458939621677},{"$f":"AA52/(1-AA51)","v":178.70612305815476},null,{"$f":"AC52/(1-AC51)","v":120.52961149558958},{"$f":"AD52/(1-AD51)","v":588.46810318434882},null,{"$f":"AF52/(1-AF51)","v":196.04881691996539},{"$f":"AG52/(1-AG51)","v":957.17951790336053},null,{"$f":"AI52/(1-AI51)","v":263.83271098327788},{"$f":"AJ52/(1-AJ51)","v":1288.1244124477678},null,{"$f":"AL52/(1-AL51)","v":324.50011859441145},{"$f":"AM52/(1-AM51)","v":1584.3241084315378},null,{"$f":"AO52/(1-AO51)","v":378.62035866954079},{"$f":"AP52/(1-AP51)","v":1848.5582217395222}]
["Grossed Up PILs",null,null,null,{"$f":"SUM(E54:E54)","v":-55.459953777777791},{"$f":"SUM(F54:F54)","v":-270.77506844444446},null,{"$f":"SUM(H54:H54)","v":-139.78257015873012},{"$f":"SUM(I54:I54)","v":-682.46784253968201},null,{"$f":"SUM(K54:K54)","v":-180.87843461224494},{"$f":"SUM(L54:L54)","v":-883.11235722449021},null,{"$f":"SUM(N54:N54)","v":-204.4103975826369},{"$f":"SUM(O54:O54)","v":-998.00370584463883},null,{"$f":"SUM(Q54:Q54)","v":-211.60653504991004},{"$f":"SUM(R54:R54)","v":-1033.1377887730921},null,{"$f":"SUM(T54:T54)","v":-159.4637670769896},{"$f":"SUM(U54:U54)","v":-778.55839219941902},null,{"$f":"SUM(W54:W54)","v":-56.46376658546604},{"$f":"SUM(X54:X54)","v":-275.6760368584504},null,{"$f":"SUM(Z54:Z54)","v":36.602458939621677},{"$f":"SUM(AA54:AA54)","v":178.70612305815476},null,{"$f":"SUM(AC54:AC54)","v":120.52961149558958},{"$f":"SUM(AD54:AD54)","v":588.46810318434882},null,{"$f":"SUM(AF54:AF54)","v":196.04881691996539},{"$f":"SUM(AG54:AG54)","v":957.17951790336053},null,{"$f":"SUM(AI54:AI54)","v":263.83271098327788},{"$f":"SUM(AJ54:AJ54)","v":1288.1244124477678},null,{"$f":"SUM(AL54:AL54)","v":324.50011859441145},{"$f":"SUM(AM54:AM54)","v":1584.3241084315378},null,{"$f":"SUM(AO54:AO54)","v":378.62035866954079},{"$f":"SUM(AP54:AP54)","v":1848.5582217395222}]
[]
[]
["Appendix 2-FC"]
["Calculation of Renewable Generation Connection Direct Benefits/Provincial Amount: Renewable Expansion Investments"]
["Net Fixed Assets",null,null,2015,2016,2017,2018,2019,2020,{"$f":"+I60+1","v":2021},{"$f":"+J60+1","v":2022},2023,2024,2025,{"$f":"+N60+1","v":2026},2027]
[null,"Enter applicable amortization in years:",42]
["Opening Gross Fixed Assets",null,null,null,{"$f":"D64","v":98000},168000,240000,314000,390000,390000,{"$f":"J64","v":390000},{"$f":"K64","v":390000},{"$f":"L64","v":390000},{"$f":"M64","v":390000},390000,390000]
["Gross Capital Additions",null,null,{"$f":"'App.2-FA Proposed REG Invest.'!C85","v":98000},{"$f":"'App.2-FA Proposed REG Invest.'!D85","v":70000},{"$f":"'App.2-FA Proposed REG Invest.'!E85","v":72000},{"$f":"'App.2-FA Proposed REG Invest.'!F85","v":74000},{"$f":"'App.2-FA Proposed REG Invest.'!G85","v":76000},{"$f":"'App.2-FA Proposed REG Invest.'!H85","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!I85","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!J85","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!K85","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!L85","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!M85","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!N85","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!O85","v":0}]
["Closing Gross Fixed Assets",null,null,{"$f":"SUM(D62:D63)","v":98000},168000,240000,314000,390000,390000,{"$f":"SUM(J62:J63)","v":390000},390000,390000,390000,390000,{"$f":"SUM(O62:O63)","v":390000},390000]
[]
["Opening Accumulated Amortization",null,null,null,{"$f":"D69","v":1166.6666666666667},4333.333333333333,9190.476190476189,15785.714285714286,24166.666666666668,33452.380952380954,{"$f":"J69","v":42738.095238095237},{"$f":"K69","v":52023.809523809527},{"$f":"L69","v":61309.523809523816},{"$f":"M69","v":70595.238095238106},79880.952380952396,89166.666666666686]
["Current Year Amortization (before additions)",null,null,null,{"$f":"E62/$C$61","v":2333.3333333333335},4000,5714.2857142857147,7476.1904761904761,9285.7142857142862,9285.7142857142862,{"$f":"K62/$C$61","v":9285.7142857142862},9285.7142857142862,9285.7142857142862,9285.7142857142862,{"$f":"O62/$C$61","v":9285.7142857142862},9285.7142857142862]
["Additions (half year)",null,null,{"$f":"D63/C61/2","v":1166.6666666666667},{"$f":"E63/C61/2","v":833.33333333333337},{"$f":"F63/C61/2","v":857.14285714285711},{"$f":"G63/C61/2","v":880.95238095238096},{"$f":"H63/C61/2","v":904.76190476190482},{"$f":"I63/$C$61/2","v":0},0,{"$f":"K63/$C$61/2","v":0},0,0,0,{"$f":"O63/$C$61/2","v":0},0]
["Closing Accumulated Amortization",null,null,{"$f":"SUM(D66+D68)","v":1166.6666666666667},{"$f":"SUM(E66:E68)","v":4333.333333333333},9190.476190476189,15785.714285714286,24166.666666666668,33452.380952380954,42738.095238095237,{"$f":"SUM(K66:K68)","v":52023.809523809527},61309.523809523816,70595.238095238106,79880.952380952396,{"$f":"SUM(O66:O68)","v":89166.666666666686},98452.380952380976]
[]
["Opening Net Fixed Assets",null,null,{"$f":"D62-D66","v":0},{"$f":"D72","v":96833.333333333328},163666.66666666666,230809.52380952382,298214.28571428574,365833.33333333331,356547.61904761905,{"$f":"J72","v":347261.90476190473},{"$f":"K72","v":337976.19047619047},{"$f":"L72","v":328690.47619047621},{"$f":"M72","v":319404.76190476189},310119.04761904757,300833.33333333331]
["Closing Net Fixed Assets",null,null,{"$f":"D64-D69","v":96833.333333333328},163666.66666666666,230809.52380952382,298214.28571428574,365833.33333333331,356547.61904761905,{"$f":"J64-J69","v":347261.90476190473},337976.19047619047,328690.47619047621,319404.76190476189,310119.04761904757,{"$f":"O64-O69","v":300833.33333333331},291547.61904761905]
["Average Net Fixed Assets",null,null,{"$f":"SUM(D71:D72)/2","v":48416.666666666664},130250,197238.09523809524,264511.90476190479,332023.80952380953,361190.47619047621,{"$f":"SUM(J71:J72)/2","v":351904.76190476189},342619.04761904757,333333.33333333337,324047.61904761905,314761.90476190473,{"$f":"SUM(O71:O72)/2","v":305476.19047619042},296190.47619047621]
[]
["UCC for PILs Calculation"]
[null,null,null,2015,2016,2017,2018,2019,2020,{"$f":"J60","v":2021},{"$f":"K60","v":2022},2023,2024,2025,{"$f":"O60","v":2026},2027]
[]
["Opening UCC",null,null,null,{"$f":"D86","v":94080},153753.60000000001,210573.31200000001,264767.44704000006,316546.05127680005,291222.36717465601,{"$f":"J86","v":267924.57780068356},{"$f":"K86","v":246490.61157662887},{"$f":"L86","v":226771.36265049857},{"$f":"M86","v":208629.65363845869},191939.281347382,176584.13883959144]
["Capital Additions (from Appendix 2-FA)",null,null,{"$f":"D63","v":98000},70000,72000,74000,76000,0,{"$f":"J63","v":0},0,0,0,0,{"$f":"O63","v":0},0]
["UCC Before Half Year Rule",null,null,{"$f":"SUM(D78:D79)","v":98000},164080,225753.60000000001,284573.31200000003,340767.44704000006,316546.05127680005,{"$f":"SUM(J78:J79)","v":291222.36717465601},267924.57780068356,246490.61157662887,226771.36265049857,208629.65363845869,{"$f":"SUM(O78:O79)","v":191939.281347382},176584.13883959144]
["Half Year Rule (1/2 Additions - Disposals)",null,null,{"$f":"D79/2","v":49000},35000,36000,37000,38000,0,{"$f":"J79/2","v":0},0,0,0,0,{"$f":"O79/2","v":0},0]
["Reduced UCC",null,null,{"$f":"D80-D81","v":49000},129080,189753.60000000001,247573.31200000003,302767.44704000006,316546.05127680005,{"$f":"J80-J81","v":291222.36717465601},267924.57780068356,246490.61157662887,226771.36265049857,208629.65363845869,{"$f":"O80-O81","v":191939.281347382},176584.13883959144]
["CCA Rate Class (to be entered)",null,47,{"$f":"C83","v":47},{"$f":"C83","v":47},{"$f":"C83","v":47},{"$f":"C83","v":47},{"$f":"C83","v":47},{"$f":"D83","v":47},{"$f":"$C$83","v":47},{"$f":"$C$83","v":47},47,47,47,47,47]
["CCA Rate  (to be entered)",null,0.08,{"$f":"C84","v":0.08},{"$f":"C84","v":0.08},{"$f":"C84","v":0.08},{"$f":"C84","v":0.08},{"$f":"C84","v":0.08},{"$f":"D84","v":0.08},{"$f":"$C$84","v":0.08},{"$f":"$C$84","v":0.08},0.08,0.08,0.08,0.08,0.08]
["CCA",null,null,{"$f":"D82*D$84","v":3920},{"$f":"E82*E$84","v":10326.4},15180.288,19805.864960000003,24221.395763200006,{"$f":"I82*I$84","v":25323.684102144005},23297.789373972482,{"$f":"K82*K$84","v":21433.966224054686},19719.248926130309,18141.709012039886,16690.372291076696,{"$f":"O82*O$84","v":15355.142507790561},14126.731107167316]
["Closing UCC",null,null,{"$f":"D80-D85","v":94080},153753.60000000001,210573.31200000001,264767.44704000006,316546.05127680005,291222.36717465601,{"$f":"J80-J85","v":267924.57780068356},246490.61157662887,226771.36265049857,208629.65363845869,191939.281347382,{"$f":"O80-O85","v":176584.13883959144},162457.40773242412]