{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":92,"n_cols":18,"rows_kept":92,"cut":false,"hidden":false,"merged":[[48,0,48,1],[50,4,50,5],[50,7,50,8],[50,10,50,11],[50,13,50,14],[50,16,50,17],[16,6,16,8],[16,9,16,11],[16,12,16,14],[16,15,16,17],[46,0,46,11],[47,0,47,12],[8,0,8,5],[9,0,9,5],[11,0,11,5],[12,0,12,5],[13,0,13,5],[16,3,16,5]]}
[null,null,null,null,"File Number:","EB-2012-0160"]
[null,null,null,null,"Exhibit:"]
[null,null,null,null,"Tab:"]
[null,null,null,null,"Schedule:"]
[null,null,null,null,"Page:"]
[]
[null,null,null,null,"Date:"]
[]
["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,"2013 Test Year",null,null,2014,null,null,2015,2016,null,2016,null,null,2017]
[null,null,null,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]
["Net Fixed Assets (average)",null,null,102504.80769230769,17425.817307692309,85078.990384615376,203019.23076923075,34513.269230769227,168505.9615384615,199038.46153846156,33836.538461538468,165201.92307692309,195057.69230769231,33159.807692307695,161897.88461538462,191076.92307692306,32483.076923076922,158593.84615384613]
["Incremental OM&A (on-going, N/A for Provincial Recovery)",null,null,15000,15000,null,0,0,null,0,0,null,0,0,null,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]
["WCA",0.13,null,null,1950,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Rate Base",null,null,null,19375.817307692309,85078.990384615376,null,34513.269230769227,168505.9615384615,null,33836.538461538468,165201.92307692309,null,33159.807692307695,161897.88461538462,null,32483.076923076922,158593.84615384613]
[]
[]
["Deemed ST Debt",0.04,null,null,775.0326923076924,3403.1596153846149,null,1380.530769230769,6740.2384615384599,null,1353.4615384615388,6608.0769230769238,null,1326.3923076923079,6475.9153846153849,null,1299.323076923077,6343.7538461538452]
["Deemed LT Debt",0.56000000000000005,null,null,10850.457692307693,47644.234615384616,null,19327.43076923077,94363.338461538457,null,18948.461538461543,92513.076923076937,null,18569.492307692311,90662.815384615402,null,18190.523076923077,88812.553846153838]
["Deemed Equity",0.4,null,null,7750.3269230769238,34031.596153846149,null,13805.307692307691,67402.38461538461,null,13534.615384615388,66080.769230769234,null,13263.923076923078,64759.153846153851,null,12993.23076923077,63437.538461538454]
[]
["ST Interest",2.07E-2,null,null,16.043176730769233,70.445404038461533,null,28.57698692307692,139.5229361538461,null,28.016653846153851,136.78719230769232,null,27.456320769230771,134.05144846153846,null,26.895987692307692,131.31570461538459]
["LT Interest",4.1099999999999998E-2,null,null,445.95381115384617,1958.1780426923076,null,794.35740461538467,3878.3332107692304,null,778.78176923076933,3802.2874615384617,null,763.20613384615399,3726.241712307693,null,747.63049846153842,3650.1959630769225]
["ROE",8.9800000000000005E-2,null,null,695.97935769230776,3056.0373346153842,null,1239.7166307692307,6052.7341384615384,null,1215.408461538462,5934.0530769230772,null,1191.1002923076924,5815.3720153846161,null,1166.7921230769232,5696.6909538461532]
["Cost of Capital Total",null,null,null,1157.9763455769232,5084.6607813461533,null,2062.6510223076921,10070.590285384615,null,2022.2068846153852,9873.1277307692308,null,1981.762746923077,9675.6651761538469,null,1941.3186092307692,9478.2026215384612]
[]
["OM&A",null,null,null,15000,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Amortization",null,null,1990.3846153846155,338.36538461538464,1652.0192307692307,3980.7692307692309,676.73076923076928,3304.0384615384614,3980.7692307692309,676.73076923076928,3304.0384615384614,3980.7692307692309,676.73076923076928,3304.0384615384614,3980.7692307692309,676.73076923076928,3304.0384615384614]
["Grossed-up PILs",null,null,null,-109.11131983716727,0,null,0,0,null,0,0,null,0,0,null,0,0]
[]
["Revenue Requirement",null,null,null,16387.23041035514,6736.6800121153838,null,2739.3817915384616,13374.628746923076,null,2698.9376538461547,13177.166192307692,null,2658.493516153846,12979.703637692308,null,2618.0493784615383,12782.241083076922]
[]
[null,"Test Year"]
["Provincial Rate Protection","kWh",null,null,null,6736.6800121153838,null,null,13374.628746923076,null,null,13177.166192307692,null,null,12979.703637692308,null,null,12782.241083076922]
["Rate Adder ($/kWh)(for non-test years)",822696978,null,null,"N/A",null,null,-1.658915613376263E-5,null,null,-1.6638316564363247E-5,null,null,-1.6687476994963867E-5,null,null,-1.6736637425564484E-5]
["Monthly Adder Amount Paid by IESO",null,null,null,null,561.39000100961528,null,null,1114.5523955769229,null,null,1098.0971826923076,null,null,1081.6419698076922,null,null,1065.1867569230769]
[]
["Note 1: Revenue collected to be recorded in Account 1533 Renewable Generation Connection Funding Adder Deferral - Subaccount Revenue Collected from IESO."]
["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.  For new projects in subsequent years, applicant revenues are to be collected through a rate adder."]
[]
["PILs Calculation"]
[null,null,null,null,2013,null,null,2014,null,null,2015,null,null,2016,null,null,2017]
["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,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,"Total"]
["Net Income - ROE on Rate Base",null,null,null,695.97935769230776,3056.0373346153842,null,1239.7166307692307,6052.7341384615384,null,1215.408461538462,5934.0530769230772,null,1191.1002923076924,5815.3720153846161,null,1166.7921230769232,5696.6909538461532]
["Amortization (6% DB and 94% P)",null,null,null,338.36538461538464,1652.0192307692307,null,676.73076923076928,3304.0384615384614,null,676.73076923076928,3304.0384615384614,null,676.73076923076928,3304.0384615384614,null,676.73076923076928,3304.0384615384614]
["CCA (6% DB and 94% P)",null,null,null,-1407.6000000000001,-6872.4,null,-2702.5920000000001,-13195.008,null,-2486.3846400000002,-12139.407359999999,null,-2287.4738688000002,-11168.2547712,null,-2104.4759592960004,-10274.794389504001]
["Taxable income",null,null,null,-373.25525769230785,-2164.3434346153845,null,-786.14460000000008,-3838.2353999999996,null,-594.24540923076893,-2901.315821538461,null,-419.64280726153856,-2048.8442942769216,null,-260.95306698830791,-1274.0649741193865]
[]
["Tax Rate  (to be entered)",null,null,null,0.22620000000000001,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Income Taxes Payable",null,null,null,-84.430339290000035,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Gross Up"]
["Income Taxes Payable",null,null,null,-109.11131983716727,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Grossed Up PILs",null,null,null,-109.11131983716727,0,null,0,0,null,0,0,null,0,0,null,0,0]
[]
[]
["Net Fixed Assets",null,null,2013,2014,2015,2016,2017]
[null,"Enter applicable amortization in years:",52]
["Opening Gross Fixed Assets",null,null,0,207000,207000,207000,207000]
["Gross Capital Additions",null,null,207000,0,0,0,0]
["Closing Gross Fixed Assets",null,0,207000,207000,207000,207000,207000]
[]
["Opening Accumulated Amortization",null,null,0,1990.3846153846155,5971.1538461538466,9951.923076923078,13932.692307692309]
["Current Year Amortization (before additions)",null,null,"-",3980.7692307692309,3980.7692307692309,3980.7692307692309,3980.7692307692309]
["Additions (half year)",null,null,1990.3846153846155,0,0,0,0]
["Closing Accumulated Amortization",null,0,1990.3846153846155,5971.1538461538466,9951.923076923078,13932.692307692309,17913.461538461539]
[]
["Opening Net Fixed Assets",null,null,0,205009.61538461538,201028.84615384616,197048.07692307694,193067.30769230769]
["Closing Net Fixed Assets",null,null,205009.61538461538,201028.84615384616,197048.07692307694,193067.30769230769,189086.53846153847]
["Average Net Fixed Assets",null,null,102504.80769230769,203019.23076923075,199038.46153846156,195057.69230769231,191076.92307692306]
[]
["UCC for PILs Calculation"]
[null,null,null,2013,2014,2015,2016,2017]
[]
["Opening UCC",null,null,0,198720,182822.39999999999,168196.60800000001,154740.87936000002]
["Capital Additions (from Appendix 2-FA)",null,null,207000,0,0,0,0]
["UCC Before Half Year Rule",null,null,207000,198720,182822.39999999999,168196.60800000001,154740.87936000002]
["Half Year Rule (1/2 Additions - Disposals)",null,null,103500,0,0,0,0]
["Reduced UCC",null,null,103500,198720,182822.39999999999,168196.60800000001,154740.87936000002]
["CCA Rate Class (to be entered)",null,47,47,47,47,47,47]
["CCA Rate  (to be entered)",null,0.08,0.08,0.08,0.08,0.08,0.08]
["CCA",null,null,8280,15897.6,14625.791999999999,13455.728640000001,12379.270348800002]
["Closing UCC",null,null,198720,182822.39999999999,168196.60800000001,154740.87936000002,142361.60901120002]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}