{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["App.2-L_OM&A_per_Cust_FTEE_exp","Sheet19","App.2-FA Proposed REG Invest","App.2-FB Calc of REG Improvemnt"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":5,"defined_names":87,"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-L_OM&A_per_Cust_FTEE_exp","index":0,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":true,"merged":[[37,1,38,11],[36,1,36,11],[32,1,33,11],[19,0,19,1],[18,0,18,1],[20,0,20,1],[26,0,26,1],[8,0,8,11],[9,0,9,11],[34,1,34,6],[35,1,35,6],[21,0,21,1],[22,0,22,1],[25,0,25,1],[14,0,14,1],[13,0,13,1],[11,7,11,11],[15,0,15,1],[16,0,16,1],[17,0,17,1]]}
[null,null,null,null,null,null,null,null,null,null,"File Number:",{"$f":"EBNUMBER","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,"Exhibit:"]
[null,null,null,null,null,null,null,null,null,null,"Tab:"]
[null,null,null,null,null,null,null,null,null,null,"Schedule:"]
[null,null,null,null,null,null,null,null,null,null,"Page:"]
[]
[null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
["Appendix 2-L"]
["Recoverable OM&A Cost per Customer and per FTE 1"]
[]
[null,null,null,null,null,null,null,"5-year Distribution System Plan Period"]
[null,null,{"$f":"\"Last Rebasing Year - \"&RebaseYear&\"- Board Approved\"","v":{"$error":"#REF!"}},{"$f":"\"Last Rebasing Year - \"&RebaseYear&\"-  Actual\"","v":{"$error":"#REF!"}},{"$f":"BridgeYear -2 & \" Actuals\"","v":{"$error":"#REF!"}},{"$f":"BridgeYear -1 & \" Actuals\"","v":{"$error":"#REF!"}},{"$f":"BridgeYear & \" Bridge Year\"","v":{"$error":"#REF!"}},{"$f":"TestYear & \" Test Year\"","v":{"$error":"#REF!"}},{"$f":"TestYear+1 & \" Year\"","v":{"$error":"#REF!"}},{"$f":"TestYear+2 & \" Year\"","v":{"$error":"#REF!"}},{"$f":"TestYear+3 & \" Year\"","v":{"$error":"#REF!"}},{"$f":"TestYear+4 & \" Year\"","v":{"$error":"#REF!"}}]
["Reporting Basis"]
["OM&A Costs"]
["     O&M"]
["     Admin Expenses"]
["Total Recoverable OM&A from Appendix 2-JB 5",null,{"$f":"SUM(C16:C17)","v":0},{"$f":"SUM(D16:D17)","v":0},0,0,0,0,0,0,0,0]
["Number of Customers 2,4"]
["Number of FTEs 3,4"]
["Customers/FTEs",null,{"$f":"IF(C20=0,\"\",C19/C20)","v":""},{"$f":"IF(D20=0,\"\",D19/D20)","v":""},"","","","","","","",""]
["OM&A cost per customer"]
["     O&M per customer",null,{"$f":"IF(C19=0,\"\",C16/C19)","v":""},{"$f":"IF(D19=0,\"\",D16/D19)","v":""},"","","","","","","",""]
["     Admin per customer",null,{"$f":"IF(C19=0,\"\",C17/C19)","v":""},{"$f":"IF(D19=0,\"\",D17/D19)","v":""},"","","","","","","",""]
["     Total OM&A per customer",null,{"$f":"IF(C19=0,\"\",C18/C19)","v":""},{"$f":"IF(D19=0,\"\",D18/D19)","v":""},"","","","","","","",""]
["OM&A cost per FTE"]
["     O&M per FTE",null,{"$f":"IF(C20=0,\"\",C16/C20)","v":""},{"$f":"IF(D20=0,\"\",D16/D20)","v":""},"","","","","","","",""]
["     Admin per FTE",null,{"$f":"IF(C20=0,\"\",C17/C20)","v":""},{"$f":"IF(D20=0,\"\",D17/D20)","v":""},"","","","","","","",""]
["     Total OM&A per FTE",null,{"$f":"IF(C20=0,\"\",C18/C20)","v":""},{"$f":"IF(D20=0,\"\",D18/D20)","v":""},"","","","","","","",""]
[]
["Notes:"]
[]
[1,"If it has been more than three years since the applicant last filed a cost of service application, additional years of historical actuals should be incorporated into the table, as necessary, to go back to the last cost of service application.  If the applicant last filed a cost of service application less than three years ago, a minimum of three years of actual information is required."]
[]
[2,"The method of calculating the number of customers must be identified. Should be linked back to Appendix 2-IA"]
[3,"The method of calculating the number of FTEs must be identified.  See also Appendix 2-K"]
[4,"The number of customers and the number of FTEs should correspond to mid-year or average of January 1 and December 31 figures."]
[5,"For the test year and in the subsequent four years of the DSP period, the applicant should take into account the system O&M (line X of Appendix 2-AB) in developing its forecasted OM&A. Admin expenses beyond the test year also need to be forecasted (separately)."]

{"sheet":"Sheet19","index":1,"n_rows":72,"n_cols":9,"rows_kept":72,"cut":false,"hidden":true,"merged":[]}
[null,"CGAAP","CGAAP","CGAAP","MIFRS","USGAAP","ASPE","ASPE","ASPE"]
[null,"N/A",2012,2013,null,null,"N/A",2012,2013]
["LDC Info","x","x","x","x","x","x","x","x"]
["Table of Contents","x","x","x","x","x","x","x","x"]
["COS Flowchart","x","x","x","x","x","x","x","x"]
["List of Key References","x","x","x","x","x","x","x","x"]
["App.2-AA_Capital Projects","x","x","x","x","x","x","x","x"]
["App.2-AB_Capital Expenditures","x","x","x","x","x","x","x","x"]
["App.2-BA1_Fix Asset Cont.CGAAP","x","x","x","n","x","x","x","x"]
["App.2-BA2_Fix Asset Cont.MIFRS","n","n","n","x","n","n","n","n"]
["Appendix 2-BB Service Life Comp","x","x","x","x","x","x","x","x"]
["Instruction for App. 2-C MIFRS","n","n","n","x","n","n","n","n"]
["App.2-CA_CGAAP_DepExp_2011","n","n","n","x","n","n","n","n"]
["App.2-CB_MIFRS_DepExp_2011","n","n","n","x","n","n","n","n"]
["App.2-CC_MIFRS_DepExp_2012","n","n","n","x","n","n","n","n"]
["App.2-CD_MIFRS_DepExp_2013","n","n","n","x","n","n","n","n"]
["App.2-CE_MIFRS_DepExp_2014","n","n","n","x","n","n","n","n"]
["App.2-CF_CGAAP_DepExp_2012","n","n","n","x","n","n","n","n"]
["App.2-CG_MIFRS_DepExp_2012","n","n","n","x","n","n","n","n"]
["App.2-CH_MIFRS_DepExp_2013","n","n","n","x","n","n","n","n"]
["App.2-CI_MIFRS_DepExp_2014","n","n","n","x","n","n","n","n"]
["App.2-CJ_CGAAP_DepExp_2012","n","n","n","x","n","n","n","n"]
["App.2-CK_CGAAP_DepExp_2013","n","n","n","x","n","n","n","n"]
["App.2-CL_MIFRS_DepExp_2013","n","n","n","x","n","n","n","n"]
["App.2-CM_MIFRS_DepExp_2014","n","n","n","x","n","n","n","n"]
["Instruction for App. 2-C CGAAP","x","x","x","n","n","x","x","x"]
["App.2-CN_OldCGAAP_DepExp_2012","x","x","n","n","n","x","x","n"]
["App.2-CO_NewCGAAP_DepExp_2012","x","x","n","n","n","x","x","n"]
["App.2-CP_NewCGAAP_DepExp_2013","x","x","n","n","n","x","x","n"]
["App.2-CQ NewCGAAP_DepExp_2014","x","x","n","n","n","x","x","n"]
["App.2-CR_OldCGAAP_DepExp_2012","x","n","x","n","n","x","n","x"]
["App.2-CS_OldCGAAP_DepExp_2013","x","n","x","n","n","x","n","x"]
["App.2-CT_NewCGAAP_DepExp_2013","x","n","x","n","n","x","n","x"]
["App.2-CU_NewCGAAP_DepExp_2014","x","n","x","n","n","x","n","x"]
["App.2-CV_USGAAP_DepExp","n","n","n","n","x","n","n","n"]
["App.2-DA_Overhead","n","n","n","x","n","n","n","n"]
["App.2-DB_Overhead","x","x","x","n","n","x","x","x"]
["App.2-EA_PP&E Deferral Account","n","n","n","x","x","n","n","n"]
["App.2-EB_PP&E Deferral Account","n","n","n","x","x","n","n","n"]
["App.2-EC_PP&E Deferral Account","n","n","n","x","x","n","n","n"]
["App.2-ED_Account 1576 (2012)","x","x","n","x","x","x","x","n"]
["App.2-EE_Account 1576 (2013)","x","n","x","x","x","x","n","x"]
["App.2-FA Proposed REG Invest.","o","o","o","o","o","o","o","o"]
["App.2-FB Calc of REG Improvemnt","o","o","o","o","o","o","o","o"]
["App.2-FC Calc of REG Expansion","o","o","o","o","o","o","o","o"]
["App.2-G SQI","x","x","x","x","x","x","x","x"]
["App.2-H_Other_Oper_Rev","x","x","x","x","x","x","x","x"]
["App.2-I LF_CDM_WF","x","x","x","x","x","x","x","x"]
["App.2-JA_OM&A_Summary_Analys","x","x","x","x","x","x","x","x"]
["App.2-JB_OM&A_Cost _Drivers","x","x","x","x","x","x","x","x"]
["App.2-JC_OMA Programs","x","x","x","x","x","x","x","x"]
["App.2-K_Employee Costs","x","x","x","x","x","x","x","x"]
["App.2-L_OM&A_per_Cust_FTEE","x","x","x","x","x","x","x","x"]
["App.2-M_Regulatory_Costs","x","x","x","x","x","x","x","x"]
["App.2-N_Corp_Cost_Allocation","x","x","x","x","x","x","x","x"]
["App.2-OA Capital Structure","x","x","x","x","x","x","x","x"]
["App.2-OB_Debt Instruments","x","x","x","x","x","x","x","x"]
["App.2-P_Cost_Allocation","x","x","x","x","x","x","x","x"]
["App.2-Q_Cost of Serv. Emb. Dx","e","e","e","e","e","e","e","e"]
["App.2-R_Loss Factors","x","x","x","x","x","x","x","x"]
["App.2-S_Stranded Meters","x","x","x","x","x","x","x","x"]
["App.2-TA_1592_Tax_Variance","x","x","x","x","x","x","x","x"]
["App.2-TB_1592_HST-OVAT","x","x","x","x","x","x","x","x"]
["App.2-U_IFRS Transition Costs","x","x","x","x","x","x","x","x"]
["App.2-V_Rev_Reconciliation","x","x","x","x","x","x","x","x"]
["App.2-W_Bill Impacts","x","x","x","x","x","x","x","x"]
["App.2-YA_MIFRS Summary Impacts","n","n","n","x","n","n","n","n"]
["App. 2-YB_CGAAP Summary Impacts","x","x","x","n","n","x","x","x"]
["App. 2-Z_Tariff","x","x","x","x","x","x","x","x"]
["lists","n","n","n","n","n","n","n","n"]
["lists2","n","n","n","n","n","n","n","n"]
["Sheet19","n","n","n","n","n","n","n","n"]

{"sheet":"App.2-FA Proposed REG Invest","index":2,"n_rows":101,"n_cols":12,"rows_kept":101,"cut":false,"hidden":false,"merged":[[16,0,16,10],[17,0,17,9],[18,0,18,8],[8,0,8,11],[9,0,9,11],[11,0,11,7],[12,0,12,7],[13,0,13,6],[14,0,14,6]]}
[null,null,null,null,null,null,null,null,null,null,"File Number:","EB-2023-0195"]
[null,null,null,null,null,null,null,null,null,null,"Exhibit:","2A"]
[null,null,null,null,null,null,null,null,null,null,"Tab:",5]
["TO BE UPDATED AT DRAFT RATE ORDER STAGE",null,null,null,null,null,null,null,null,null,"Schedule:",2]
[null,null,null,null,null,null,null,null,null,null,"Page:"]
[]
[null,null,null,null,null,null,null,null,null,null,"Date:","ORIGINAL"]
[]
["Appendix 2-FA"]
["Renewable Generation Connection Investment Summary (past investments or over the future rate setting period)"]
[]
["Enter the details of the Renewable Generation Connection projects as described in the appropriate section 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. (EB-2009-0349, 6-10-2010, p. 15, note 9)"]
["Ensure that OM&A costs below are not included in Recoverable OM&A (App. 2-JA)"]
["There are two scenarios described below.  Separate sets of spreadsheets (2-FA, 2-FB, 2-FC) should be submited for each scenario as required."]
["Scenario 1:  ","Past Investments with No Recovery.  The distributor has made investments in the past (during the IRM Years), but has not received approval for these projects and therefore did not receive"]
[null,"revenue from the IESO under Regulation 330/09 and did not receive ratepayer revenue for the direct benefit portion of the investment."]
[null,"The WCA percentage, debt percentages, interest rates, kWh, tax rates, amortization period, CCA Class and percentage should correspond to the distributor's last Cost of Service approval. "]
[null,"The Direct Benefit portion of the calculated Revenue Requirement for each year should be summed and can be applied for recovery from the distributor's ratepayers through a rate rider."]
[null,"The Provincial Recovery portion of the calculated Revenue Requirement for each year should be summed and can be applied for recovery from the IESO through a separate order."]
[]
["Scenario 2:","Investments in the Test Year and Beyond.  Distributor plans to make investments in the Test Year and/or beyond.  These investments should be added to 2-FA in the appropriate year."]
[null,"The WCA percentage, debt percentages, interest rates, kWh, tax rates, amortization period, CCA Class and percentage should correspond to the distributor's current application. "]
[]
["Part A",null,"","","","","","Test Year","","","",""]
["REI Investments (Direct Benefit at 6%)",null,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029]
["Project 1"]
["Energy Storage"]
["Capital Costs",null,0,-1535.3208,-51881,0,0,3557331.4970029211,3636486.9611893264,7548426.1858626306,3801288.1985153444,4004646.8811134552]
["Incremental OM&A (Start-Up)",null,0,0,0,0,0,0,0,0,0,0]
["Incremental OM&A (Ongoing)",null,0,0,0,0,0,0,0,0,0,0]
[]
["Project 2"]
["Name: REI Connection Project"]
["Capital Costs",null,0,0,0,0,0,0,0,0,0,0]
["Incremental OM&A (Start-Up)",null,0,0,0,0,0,0,0,0,0,0]
["Incremental OM&A (Ongoing)",null,0,0,0,0,0,0,0,0,0,0]
[]
["Project 3"]
["Name: REI Connection Project"]
["Capital Costs",null,0,0,0,0,0,0,0,0,0,0]
["Incremental OM&A (Start-Up)",null,0,0,0,0,0,0,0,0,0,0]
["Incremental OM&A (Ongoing)",null,0,0,0,0,0,0,0,0,0,0]
[]
["Project 4"]
["Name: REI Connection Project"]
["Capital Costs",null,0,0,0,0,0,0,0,0,0,0]
["Incremental OM&A (Start-Up)",null,0,0,0,0,0,0,0,0,0,0]
["Incremental OM&A (Ongoing)",null,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]
["Incremental OM&A (Start-Up)",null,0,0,0,0,0,0,0,0,0,0]
["Incremental OM&A (Ongoing)",null,0,0,0,0,0,0,0,0,0,0]
[]
["Total Capital Costs",null,0,-1535.3208,-51881,0,0,3557331.4970029211,3636486.9611893264,7548426.1858626306,3801288.1985153444,4004646.8811134552]
["Total Incremental OM&A (Start-Up)",null,0,0,0,0,0,0,0,0,0,0]
["Total Incremental OM&A (Ongoing)",null,0,0,0,0,0,0,0,0,0,0]
[]
[]
["Part B",null,"","","","","","Test Year","","","",""]
["Expansion Investments (Direct Benefit at 17%)",null,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029]
["Project 1"]
["Name: Expansion Connection Project"]
["Capital Costs",null,0,0,0,0,0,0,0,0,0,0]
["Incremental OM&A (Start-Up)",null,0,0,0,0,0,0,0,0,0,0]
["Incremental OM&A (Ongoing)",null,0,0,0,0,0,0,0,0,0,0]
[]
["Project 2"]
["Name: Expansion Connection Project"]
["Capital Costs",null,0,0,0,0,0,0,0,0,0,0]
["Incremental OM&A (Start-Up)",null,0,0,0,0,0,0,0,0,0,0]
["Incremental OM&A (Ongoing)",null,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]
["Incremental OM&A (Start-Up)",null,0,0,0,0,0,0,0,0,0,0]
["Incremental OM&A (Ongoing)",null,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]
["Incremental OM&A (Start-Up)",null,0,0,0,0,0,0,0,0,0,0]
["Incremental OM&A (Ongoing)",null,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]
["Incremental OM&A (Start-Up)",null,0,0,0,0,0,0,0,0,0,0]
["Incremental OM&A (Ongoing)",null,0,0,0,0,0,0,0,0,0,0]
[]
["Total Capital Costs",null,0,0,0,0,0,0,0,0,0,0]
["Total Incremental OM&A (Start-Up)",null,0,0,0,0,0,0,0,0,0,0]
["Total Incremental OM&A (Ongoing)",null,0,0,0,0,0,0,0,0,0,0]

{"sheet":"App.2-FB Calc of REG Improvemnt","index":3,"n_rows":96,"n_cols":33,"rows_kept":96,"cut":false,"hidden":false,"merged":[[15,18,15,20],[16,21,16,23],[8,0,8,21],[9,0,9,21],[11,0,11,21],[12,0,12,21],[14,0,14,21],[16,24,16,26],[16,27,16,29],[16,30,16,32],[16,33,16,35],[50,0,50,1],[47,0,48,15],[16,3,16,5],[16,6,16,8],[16,9,16,11],[16,12,16,14],[16,15,16,17],[16,18,16,20],[51,16,51,17],[51,19,51,20],[52,4,52,5],[52,7,52,8],[52,10,52,11],[52,13,52,14],[52,16,52,17],[52,19,52,20],[52,22,52,23],[52,25,52,26],[52,28,52,29],[52,31,52,32],[52,34,52,35]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Number:","EB-2023-0195"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exhibit:","2A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tab:",5]
["TO BE UPDATED AT DRAFT RATE ORDER STAGE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule:",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:","ORIGINAL"]
[]
["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."]
["For historical investments, enter these variables that were approved in your last cost of service test year.  For test year and beyond, enter variables as in the application."]
["Rate Riders related to the direct benefit portion of the renewable investments are not calculated for the Test Year as these assets and costs are already in the distributor's rate base/revenue requirement."]
[]
[null,"2020",null,2020,null,null,2021,null,null,2022,null,null,2023,null,null,2024,null,null,2025,null,null,2026,null,null,2027,2016,null,2028,null,null,2029]
[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,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]
["Net Fixed Assets (average)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,7125418.2446265249,427525.09467759146,6697893.1499489332,13759428.334451221,825565.70006707322,12933862.634384148,16549480.646668147,992968.83880008885,15556511.807868058]
["Incremental OM&A (on-going, N/A for Provincial Recovery)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Incremental OM&A (start-up, applicable for Provincial Recovery)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Rebasing Year vs. Test Year",2020,2025]
["Allowance for Working Capital (enter rate)",7.2999999999999995E-2,7.0199999999999999E-2,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Rate Base",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,427525.09467759146,6697893.1499489332,null,825565.70006707322,12933862.634384148,null,992968.83880008885,15556511.807868058]
[]
["Rebasing Year vs. Test Year",2020,2025]
["Deemed ST Debt ",0.04,0.04,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,17101.003787103658,267915.72599795734,null,33022.628002682926,517354.5053753659,null,39718.753552003553,622260.47231472237]
["Deemed LT Debt ",0.56000000000000005,0.56000000000000005,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,239414.05301945124,3750820.1639714031,null,462316.79203756107,7242963.0752551239,null,556062.54972804978,8711646.6124061141]
["Deemed Equity ",0.4,0.4,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,171010.03787103659,2679157.2599795735,null,330226.28002682934,5173545.0537536591,null,397187.53552003554,6222604.7231472237]
[]
["ST Interest (enter rate)",2.6100000000000002E-2,5.2499999999999998E-2,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,897.80269882294203,14065.575614892759,null,1733.6879701408536,27161.111532206709,null,2085.2345614801866,32668.674796522922]
["LT Interest (enter rate)",3.7100000000000001E-2,3.9547993430507078E-2,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,9468.34539598433,148337.41120375454,null,18283.701454314571,286444.65611759498,null,21991.158063595929,344528.14299633622]
["Return on Equity (enter rate)",8.5199999999999998E-2,9.3600000000000003E-2,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,16006.539544729025,250769.11953408809,null,30909.179810511228,484243.81703134254,null,37176.75332467533,582435.8020865802]
["Cost of Capital Total",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,26372.687639536296,413172.10635273543,null,50926.56923496665,797849.58468114422,null,61253.145949751444,959632.61987943936]
[]
["OM&A",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Amortization",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,491408.15480182931,29484.489288109758,461923.66551371955,982816.30960365862,58968.978576219517,923847.3310274391,1243014.1455912853,74580.84873547712,1168433.2968558082]
["Grossed-up PILs",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,-31435.552156964091,-492490.31712577073,null,-48917.984948077356,-766381.76418654528,null,-41962.030279589977,-657405.14104690962]
[]
["Revenue Requirement",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,24421.624770681963,382605.45474068425,null,60977.562863108818,955315.15152203804,null,93871.964405638588,1470660.7756883381]
[]
[]
["Provincial Rate Protection",null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,382605.45474068425,null,null,955315.15152203804,null,null,1470660.7756883381]
[]
["Monthly Amount Paid by IESO",null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,31883.787895057019,null,null,79609.595960169841,null,null,122555.06464069484]
[]
["Note 1: The distributor should follow the regulatory accounting set out in the Accounting Procedure Handbook Guidance FAQs issued in March 2015. Q10 of the APH FAQs states that: “For approved eligible investments as defined under O.Reg. 330/09 under the OEB Act, a variance account will continue to be used for the purpose of recording variances between the revenue requirement based on actual costs of approved eligible investments and the revenue received from the IESO.” The answer for Q10 provides the accounting guidance for this variance account: “Distributors that have included eligible investments to connect qualifying facilities in their DS plans are to establish the variance Account 1533 Renewable Generation Connection Funding Adder Deferral Account, Sub-account Provincial Rate Protection Payment Variances following OEB approval for investments forecast to enter service beyond the test year for purposes of implementing rate protection pursuant to O.Reg. 330/09. The purpose of this variance account is to track the variance between the distributor’s revenue requirement associated with the portion of the actual capital and/or operating costs that are eligible for rate protection, as incurred by the distributor for eligible renewable enabling and expansion investments, and the rate protection payments collected from the IESO.” The answer further provides the journal entries to record the variances. Distributors should follow the instructions in the answer for recording the journal entries in the variance account 1533."]
[]
["Note 2: For the 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,2020,null,null,2021,null,null,2022,null,null,2023,null,null,2024,null,null,2025,null,null,2026,null,null,2027,null,null,2028,null,null,2029]
["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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,"Total"]
["Net Income - ROE on Rate Base",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,16006.539544729025,250769.11953408809,null,30909.179810511228,484243.81703134254,null,37176.75332467533,582435.8020865802]
["Amortization (6% DB and 94% P)",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,29484.489288109758,461923.66551371955,null,58968.978576219517,923847.3310274391,null,74580.84873547712,1168433.2968558082]
["CCA (6% DB and 94% P)",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,-132680.2017964939,-2078656.4948117379,null,-225556.34305403964,-3533716.0411799541,null,-228142.8558544869,-3574238.0750536281]
["Taxable income",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,-87189.172963655117,-1365963.7097639302,null,-135678.18466730887,-2125624.8931211727,null,-116385.25379433445,-1823368.9761112398]
[null,2020,2025]
["Tax Rate  (to be entered)",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,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,-23105.130835368607,-361980.3830874415,null,-35954.718936836856,-563290.59667711076,null,-30842.092255498632,-483192.77866947855]
["Gross Up"]
["Income Taxes Payable",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,-31435.552156964091,-492490.31712577073,null,-48917.984948077356,-766381.76418654528,null,-41962.030279589977,-657405.14104690962]
["Grossed Up PILs",null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,-31435.552156964091,-492490.31712577073,null,-48917.984948077356,-766381.76418654528,null,-41962.030279589977,-657405.14104690962]
[]
[]
[null,null,null,null,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029]
["Net Fixed Assets"]
["Enter applicable amortization in years:",15]
["Opening Gross Fixed Assets",null,null,null,null,0,0,0,0,0,0,0,14742244.644054879,14742244.644054879]
["Capital Additions",null,null,null,0,0,0,0,0,0,0,14742244.644054879,0,7805935.0796288]
["Closing Gross Fixed Assets",null,null,null,0,0,0,0,0,0,0,14742244.644054879,14742244.644054879,22548179.723683678]
[]
["Opening Accumulated Amortization",null,null,null,null,0,0,0,0,0,0,0,491408.15480182931,1474224.464405488]
["Current Year Amortization (before additions)",null,null,null,0,0,0,0,0,0,0,0,982816.30960365862,982816.30960365862]
["Capital Additions Amortization (half year)",null,null,null,0,0,0,0,0,0,0,491408.15480182931,0,260197.83598762666]
["Closing Accumulated Amortization",null,null,null,0,0,0,0,0,0,0,491408.15480182931,1474224.464405488,2717238.6099967733]
[]
["Opening Net Fixed Assets",null,null,null,0,0,0,0,0,0,0,0,14250836.48925305,13268020.17964939]
["Closing Net Fixed Assets",null,null,null,0,0,0,0,0,0,0,14250836.48925305,13268020.17964939,19830941.113686904]
["Average Net Fixed Assets",null,null,null,0,0,0,0,0,0,0,7125418.2446265249,13759428.334451221,16549480.646668147]
[]
["UCC for PILs Calculation",null,null,null,null,null,null,null,null,"Test Year"]
[null,null,null,null,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029]
[]
["Opening UCC",null,null,null,0,0,0,0,0,0,0,0,12530907.947446646,8771635.5632126518]
["Capital Additions",null,null,null,0,0,0,0,0,0,0,14742244.644054879,0,7805935.0796288]
["UCC Before Half Year Rule",null,null,null,0,0,0,0,0,0,0,14742244.644054879,12530907.947446646,16577570.642841451]
["Capital Additions (half year)",null,null,null,0,0,0,0,0,0,0,7371122.3220274393,0,3902967.5398144]
["Reduced UCC",null,null,null,0,0,0,0,0,0,0,7371122.3220274393,12530907.947446646,12674603.103027051]
["CCA Rate Class (to be entered)",43.1]
["CCA Rate  (to be entered)",0.3]
["CCA",null,null,null,0,0,0,0,0,0,0,2211336.6966082319,3759272.3842339939,3802380.9309081151]
["Closing UCC",null,null,null,0,0,0,0,0,0,0,12530907.947446646,8771635.5632126518,12775189.711933335]