{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["1. Info","2. Table of Contents","3. Data_Input_Sheet","4. Rate_Base","5. Utility Income","6. Taxes_PILs","7. Cost_of_Capital","8. Rev_Def_Suff","9. Rev_Reqt","10. Tracking_Sheet","Not part of Model ==>","Data"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":2,"defined_names":13,"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":"1. Info","index":0,"n_rows":98,"n_cols":29,"rows_kept":98,"cut":false,"hidden":false,"merged":[[27,1,27,3],[34,1,40,11],[0,2,1,12],[2,2,3,12],[27,4,27,9],[25,6,25,10],[21,1,21,2],[15,6,15,12],[17,6,17,10],[19,6,19,10],[21,6,21,10],[23,6,23,10],[23,1,23,2],[25,1,25,3]]}
[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,null,{"$f":"IF('3. Data_Input_Sheet'!M12=0, \"\", '3. Data_Input_Sheet'!M12)","v":"Close of Discovery"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version",4]
[]
[]
[]
[]
[null,null,null,null,null,"Utility Name   ","Oshawa PUC Networks Inc."]
[]
[null,null,null,null,null,"Service Territory","Oshawa"]
[]
[null,null,null,null,null,"Assigned EB Number","EB-2014-0101",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Company Name"]
[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,1,"Algoma Power Inc."]
[null,null,null,null,null,"Name and Title","David Savage, Corporate Controller",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Atikokan Hydro Inc."]
[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,3,"Attawapiskat Power Corporation"]
[null,null,null,null,null,"Phone Number   ","905-743 5219",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Bluewater Power Distribution Corp."]
[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,5,"Brant County Power"]
[null,null,null,null,null,"Email Address   ","dsavage@opuc.on.ca",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Brantford Power Inc."]
[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,7,"Burlington Hydro Inc."]
[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,8,"Cambridge and North Dumfries Hydro"]
[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,9,"Canadian Niagara Power Inc. – Eastern Ontario Power/Fort Erie/Port Colborne"]
[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,10,"Centre Wellington Hydro Ltd."]
[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,11,"Chapleau Public Utilities Corporation"]
[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,12,"COLLUS Power Corp."]
[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,13,"Cooperative Hydro Embrun Inc."]
[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,14,"E.L.K. Energy Inc."]
[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,15,"Enersource Hydro Mississauga Inc."]
[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,16,"Entegrus Powerlines Inc."]
[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,17,"ENWIN Utilities Ltd."]
[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,18,"Erie Thames Powerlines Corp."]
[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,19,"Espanola Regional Hydro Distribution Corporation"]
[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,20,"Essex Powerlines Corporation"]
[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,21,"Festival Hydro Inc."]
[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,22,"Fort Albany Power Corporation"]
[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,23,"Fort Frances Power Corporation"]
[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,24,"Greater Sudbury Hydro Inc."]
[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,25,"Grimsby Power Inc."]
[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,26,"Guelph Hydro Electric Systems Inc."]
[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,27,"Haldimand County Hydro Inc."]
[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,28,"Halton Hills Hydro Inc."]
[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,29,"Hearst Power Distribution Co. Ltd."]
[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,30,"Horizon Utilities Corporation"]
[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,31,"Hydro 2000 Inc."]
[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,32,"Hydro Hawkesbury Inc."]
[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,33,"Hydro One Brampton Networks Inc."]
[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,34,"Hydro One Networks Inc."]
[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,35,"Hydro One Remote Communities Inc."]
[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,36,"Hydro Ottawa Limited"]
[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,37,"Innisfil Hydro Dist. Systems Limited"]
[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,38,"Kashechewan Power Corporation"]
[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,39,"Kenora Hydro Electric Corporation Ltd."]
[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,40,"Kingston Hydro Corporation"]
[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,41,"Kitchener-Wilmot Hydro Inc."]
[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,42,"Lakefront Utilities Inc."]
[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,43,"Lakeland Power Distribution Ltd."]
[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,44,"London Hydro Inc."]
[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,45,"Midland Power Utility Corporation"]
[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,46,"Milton Hydro Distribution Inc."]
[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,47,"Newmarket – Tay Power Distribution Ltd."]
[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,48,"Niagara Peninsula Energy Inc."]
[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,49,"Niagara-on-the-Lake Hydro Inc."]
[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,50,"Norfolk Power Distribution Ltd."]
[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,51,"North Bay Hydro Distribution Limited"]
[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,52,"Northern Ontario Wires Inc."]
[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,53,"Oakville Hydro Distribution Inc."]
[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,54,"Orangeville Hydro Limited"]
[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,55,"Orillia Power Distribution Corp."]
[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,56,"Oshawa PUC Networks Inc."]
[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,57,"Ottawa River Power Corporation"]
[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,58,"Parry Sound Power Corporation"]
[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,59,"Peterborough Distribution Inc."]
[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,60,"PowerStream Inc. - Barrie"]
[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,61,"PowerStream Inc. - South"]
[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,62,"PUC Distribution Inc."]
[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,63,"Renfrew Hydro Inc."]
[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,64,"Rideau St. Lawrence Distribution Inc."]
[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,65,"St. Thomas Energy Inc."]
[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,66,"Sioux Lookout Hydro Inc."]
[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,67,"Thunder Bay Hydro Electricity Distribution Inc."]
[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,68,"Tillsonburg Hydro Inc."]
[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,69,"Toronto Hydro-Electric System Limited"]
[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,70,"Veridian Connections Inc."]
[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,71,"Wasaga Distribution Inc."]
[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,72,"Waterloo North Hydro Inc."]
[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,73,"Welland Hydro-Electric System Corp."]
[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,74,"Wellington North Power Inc."]
[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,75,"West Coast Huron Energy Inc."]
[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,76,"Westario Power Inc."]
[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,77,"Whitby Hydro Electric Corporation"]
[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,78,"Woodstock Hydro Services Inc."]

{"sheet":"2. Table of Contents","index":1,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,2,0,4],[1,3,1,6],[3,3,3,4],[28,1,28,11],[24,1,24,7],[25,1,25,7],[26,1,26,7],[27,1,27,11]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"1. Info",null,null,null,null,"6. Taxes_PILs"]
[]
[null,null,null,"2. Table of Contents",null,null,null,null,"7. Cost_of_Capital"]
[]
[null,null,null,"3. Data_Input_Sheet",null,null,null,null,"8. Rev_Def_Suff"]
[]
[null,null,null,"4. Rate_Base",null,null,null,null,"9. Rev_Reqt"]
[]
[null,null,null,"5. Utility Income"]
[]
[]
[]
[]
["Notes:"]
["(1)","Pale green cells represent inputs"]
["(2)","Pale green boxes at the bottom of each page are for additional notes"]
["(3)","Pale yellow cells represent drop-down lists"]
["(4)","Please note that this model uses MACROS.  Before starting, please ensure that macros have been enabled."]
["(5)","Completed versions of the Revenue Requirement Work Form are required to be filed in working Microsoft Excel format."]

{"sheet":"3. Data_Input_Sheet","index":2,"n_rows":78,"n_cols":23,"rows_kept":78,"cut":false,"hidden":false,"merged":[[79,2,79,20],[77,2,78,20],[0,2,0,12],[7,4,7,20],[19,24,20,24],[68,2,68,20],[3,2,3,10],[1,2,1,10],[2,2,2,10],[11,14,12,14],[11,6,12,6],[11,16,12,16],[11,4,12,4],[11,8,12,8],[11,20,12,20],[11,12,12,12],[87,2,88,20],[70,2,70,20],[71,2,71,20],[69,2,69,20],[86,2,86,20],[74,2,74,20],[80,2,80,20],[72,2,72,20],[75,2,75,20],[76,2,76,20],[81,2,81,20],[82,2,82,20],[83,2,83,20],[84,2,84,20],[85,2,85,20],[73,2,73,20]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE('2. Table of Contents'!$F$6,\" \",'2. Table of Contents'!$G$6)","v":" "}]
[]
[]
[]
[]
[]
[]
[]
[null,"Data Input (1)"]
[]
[]
[null,null,null,null,"Initial Application",null,"(2)",null,{"$f":"IF(ISBLANK(M12),\"\",\"Adjustments\")","v":"Adjustments"},null,null,null,"Close of Discovery",null,"(6)",null,{"$f":"IF(ISBLANK(M12),\"\",\"Adjustments\")","v":"Adjustments"},null,null,null,"Per Board Decision"]
[]
[]
[null,1,"Rate Base"]
[null,null,"   Gross Fixed Assets (average)",null,193294.95235111908,null,null,null,-892.02853610171587,null,null,null,{"$f":"IF(ISBLANK(E16),0,E16+I16)","v":192402.92381501736},null,null,null,{"$f":"Data!C5-M16","v":-5050.0000248849101},null,null,null,{"$f":"IF(ISBLANK(E16),\"\",E16+I16+Q16)","v":187352.92379013245}]
[null,null,"   Accumulated Depreciation (average)",null,-91145.939590779191,null,"(5)",null,-92.909145970217651,null,null,null,{"$f":"IF(ISBLANK(E17),0,E17+I17)","v":-91238.848736749409},null,null,null,{"$f":"Data!C6-M17","v":-124.55797439120943},null,null,null,{"$f":"IF(ISBLANK(E17),\"\",E17+I17+Q17)","v":-91363.406711140618}]
[null,null,"Allowance for Working Capital:"]
[null,null,"   Controllable Expenses",null,12886.687744033659,null,null,null,133.83766874000139,null,null,null,{"$f":"IF(ISBLANK(E19),0,E19+I19)","v":13020.525412773661},null,null,null,{"$f":"Data!C8-M19","v":0},null,null,null,{"$f":"IF(ISBLANK(E19),\"\",E19+I19+Q19)","v":13020.525412773661}]
[null,null,"   Cost of Power",null,123586.73946759697,null,null,null,1716.7144246843236,null,null,null,{"$f":"IF(ISBLANK(E20),0,E20+I20)","v":125303.45389228129},null,null,null,{"$f":"Data!C9-M20","v":-4413.6678868334129},null,null,null,{"$f":"IF(ISBLANK(E20),\"\",E20+I20+Q20)","v":120889.78600544788}]
[null,null,"   Working Capital Rate (%)",null,0.13,null,"(9)",null,null,null,null,null,0.1002,null,"(9)",null,null,null,null,null,{"$f":"Data!C10","v":9.3700000000000006E-2},null,"(9)"]
[]
[null,2,"Utility Income"]
[null,null,"Operating Revenues:"]
[null,null,"   Distribution Revenue at Current Rates",null,23950.683116249802,null,null,null,{"$f":"IF(ISBLANK(M25),\"\",IF(ISBLANK(E25),\"\",M25-E25))","v":-649.27251861739205},null,null,null,23301.41059763241,null,null,null,{"$f":"IF(ISBLANK(U25),\"\",IF(ISBLANK(M25),\"\",U25-M25))","v":-711.04398206115729},null,null,null,{"$f":"Data!C14","v":22590.366615571253}]
[null,null,"   Distribution Revenue at Proposed Rates",null,24391.238721013513,null,null,null,{"$f":"IF(ISBLANK(M26),\"\",IF(ISBLANK(E26),\"\",M26-E26))","v":-687.03691378584335},null,null,null,23704.20180722767,null,null,null,{"$f":"IF(ISBLANK(U26),\"\",IF(ISBLANK(M26),\"\",U26-M26))","v":-625.20262954845384},null,null,null,{"$f":"Data!C15","v":23078.999177679216}]
[null,null,"   Other Revenue:"]
[null,null,"      Specific Service Charges",null,1019.924020218933,null,null,null,{"$f":"IF(ISBLANK(M28),\"\",IF(ISBLANK(E28),\"\",M28-E28))","v":-12.890021018284529},null,null,null,1007.0339992006485,null,null,null,{"$f":"IF(ISBLANK(U28),\"\",IF(ISBLANK(M28),\"\",U28-M28))","v":-18.265827611042369},null,null,null,{"$f":"Data!C17","v":988.76817158960614}]
[null,null,"      Late Payment Charges",null,309.75434141684508,null,null,null,{"$f":"IF(ISBLANK(M29),\"\",IF(ISBLANK(E29),\"\",M29-E29))","v":-5.2886624555090407},null,null,null,304.46567896133604,null,null,null,{"$f":"IF(ISBLANK(U29),\"\",IF(ISBLANK(M29),\"\",U29-M29))","v":-7.4943087034757809},null,null,null,{"$f":"Data!C18","v":296.97137025786026}]
[null,null,"      Other Distribution Revenue",null,173.51338247352678,null,null,null,{"$f":"IF(ISBLANK(M30),\"\",IF(ISBLANK(E30),\"\",M30-E30))","v":-3.2901461348140515},null,null,null,170.22323633871272,null,null,null,{"$f":"IF(ISBLANK(U30),\"\",IF(ISBLANK(M30),\"\",U30-M30))","v":-5.3136000000000081},null,null,null,{"$f":"Data!C19","v":164.90963633871272}]
[null,null,"      Other Income and Deductions",null,128,null,null,null,{"$f":"IF(ISBLANK(M31),\"\",IF(ISBLANK(E31),\"\",M31-E31))","v":0},null,null,null,128,null,null,null,{"$f":"IF(ISBLANK(U31),\"\",IF(ISBLANK(M31),\"\",U31-M31))","v":0},null,null,null,{"$f":"Data!C20","v":128}]
[]
[null,null,null,"Total Revenue Offsets",1631.1917441093049,null,"(7)",null,{"$f":"IF(ISBLANK(M33),\"\",IF(ISBLANK(E33),\"\",M33-E33))","v":-21.468829608607621},null,null,null,1609.7229145006972,null,null,null,{"$f":"IF(ISBLANK(U33),\"\",IF(ISBLANK(M33),\"\",U33-M33))","v":-31.073736314518101},null,null,null,{"$f":"Data!C22","v":1578.6491781861791}]
[]
[null,null,"Operating Expenses:"]
[null,null,"   OM+A Expenses",null,12690.387638452215,null,null,null,{"$f":"Data!C25-E36","v":133.83766874000139},null,null,null,{"$f":"IF(ISBLANK(E36),\"\",E36+I36)","v":12824.225307192217},null,null,null,0,null,null,null,{"$f":"IF(ISBLANK(E36),\"\",E36+I36+Q36)","v":12824.225307192217}]
[null,null,"   Depreciation/Amortization",null,5000.9720499314644,null,null,null,{"$f":"Data!C26-E37","v":-181.28718657993068},null,null,null,{"$f":"IF(ISBLANK(E37),\"\",E37+I37)","v":4819.6848633515337},null,null,null,0,null,null,null,{"$f":"IF(ISBLANK(E37),\"\",E37+I37+Q37)","v":4819.6848633515337}]
[null,null,"   Property taxes",null,165.00737199945598,null,null,null,{"$f":"Data!C27-E38","v":0},null,null,null,{"$f":"IF(ISBLANK(E38),\"\",E38+I38)","v":165.00737199945598},null,null,null,0,null,null,null,{"$f":"IF(ISBLANK(E38),\"\",E38+I38+Q38)","v":165.00737199945598}]
[null,null,"   Capital taxes",null,{"$f":"IF(ISBLANK(E48),\"\",E48)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(M48),\"\",M48)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U48),\"\",U48)","v":""}]
[null,null,"   Other expenses",null,31.292733581986994,null,null,null,{"$f":"Data!C29-E40","v":0},null,null,null,{"$f":"IF(ISBLANK(E40),\"\",E40+I40)","v":31.292733581986994},null,null,null,0,null,null,null,{"$f":"IF(ISBLANK(E40),\"\",E40+I40+Q40)","v":31.292733581986994}]
[]
[null,3,"Taxes/PILs"]
[null,null,"Taxable Income:"]
[null,null,null,"Adjustments required to arrive at taxable income",-2912.0633584876014,null,"(3)",null,null,null,null,null,-2691.2164912781263,null,null,null,null,null,null,null,{"$f":"Data!C33","v":-2419.8485092103365}]
[null,null,"Utility Income Taxes and Rates:"]
[null,null,"   Income taxes (not grossed up)",null,365.184333701009,null,null,null,null,null,null,null,325.73558028938277,null,null,null,null,null,null,null,{"$f":"Data!C35","v":321.04163187930641}]
[null,null,"   Income taxes (grossed up)",null,{"$f":"IF(ISBLANK(E46),\"\",E46/(1-SUM(E49:E50)))","v":482.02039737109214},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(M46),\"\",M46/(1-SUM(M49:M50)))","v":430.27257135742173},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U46),\"\",U46/(1-SUM(U49:U50)))","v":423.93293545647953}]
[null,null,"   Capital Taxes"]
[null,null,"   Federal tax (%)",null,0.15000000000000002,null,null,null,null,null,null,null,0.15000000000000002,null,null,null,null,null,null,null,{"$f":"Data!C38","v":0.15000000000000002}]
[null,null,"   Provincial tax (%)",null,9.2388214912272296E-2,null,null,null,null,null,null,null,9.2955275392633457E-2,null,null,null,null,null,null,null,{"$f":"Data!C39","v":9.2706557975691536E-2}]
[null,null,"Income Tax Credits",null,-10,null,null,null,null,null,null,null,-60,null,null,null,null,null,null,null,{"$f":"Data!C40","v":-60}]
[null,null,"   "]
[null,4,"Capitalization/Cost of Capital"]
[null,null,"Capital Structure:"]
[null,null,"   Long-term debt Capitalization Ratio (%)",null,0.56000000000000005,null,null,null,null,null,null,null,0.56000000000000005,null,null,null,null,null,null,null,{"$f":"Data!C44","v":0.56000000000000005}]
[null,null,"   Short-term debt Capitalization Ratio (%)",null,0.04,null,"(8)",null,null,null,null,null,0.04,null,"(8)",null,null,null,null,null,{"$f":"Data!C45","v":0.04},null,"(8)"]
[null,null,"   Common Equity Capitalization Ratio (%)",null,0.39999999999999991,null,null,null,null,null,null,null,0.39999999999999991,null,null,null,null,null,null,null,{"$f":"Data!C46","v":0.39999999999999991}]
[null,null,"   Prefered Shares Capitalization Ratio (%)",null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,{"$f":"Data!C47","v":0}]
[null,null,null,null,{"$f":"SUM(E55:E58)","v":1},null,null,null,null,null,null,null,{"$f":"SUM(M55:M58)","v":1},null,null,null,null,null,null,null,{"$f":"SUM(U55:U58)","v":1}]
[null,null,null,null,{"$f":"IF(ISBLANK(E57),\"\",IF(SUM(E55:E58)=100%,\"\",\"Capital Structure must total 100%\"))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(M57),\"\",IF(SUM(M55:M58)=100%,\"\",\"Capital Structure must total 100%\"))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U57),\"\",IF(SUM(U55:U58)=100%,\"\",\"Capital Structure must total 100%\"))","v":""}]
[null,null,"Cost of Capital"]
[null,null,"   Long-term debt Cost Rate (%)",null,4.6012739013764056E-2,null,null,null,null,null,null,null,3.9590495675276352E-2,null,null,null,null,null,null,null,{"$f":"Data!C51","v":3.8368346309157683E-2}]
[null,null,"   Short-term debt Cost Rate (%)",null,2.1600000000000001E-2,null,null,null,null,null,null,null,2.1600000000000001E-2,null,null,null,null,null,null,null,{"$f":"Data!C52","v":1.6500000000000001E-2}]
[null,null,"   Common Equity Cost Rate (%)",null,9.2999999999999999E-2,null,null,null,null,null,null,null,9.2999999999999999E-2,null,null,null,null,null,null,null,{"$f":"Data!C53","v":9.1899999999999996E-2}]
[null,null,"   Prefered Shares Cost Rate (%)",null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,{"$f":"Data!C54","v":0}]
[]
[]
["Notes:"]
[null,"General","Data inputs are required on Sheets 3. Data from Sheet 3 will automatically complete calculations on sheets 4 through 9 (Rate Base through Revenue Requirement).  Sheets 4 through 9 do not require any inputs except for notes that the Applicant may wish to enter to support the results.  Pale green cells are available on sheets 4 through 9 to enter both footnotes beside key cells and the related text for the notes at the bottom of each sheet."]
[null,"(1)","All inputs are in dollars ($) except where inputs are individually identified as percentages (%)"]
[null,"(2)","Data in column E is for Application as originally filed.  For updated revenue requirement as a result of interrogatory responses, technical or settlement conferences, etc., use colimn M and Adjustments in column I"]
[null,"(3)","Net of addbacks and deductions to arrive at taxable income."]
[null,"(4)","Average of Gross Fixed Assets at beginning and end of the Test Year"]
[null,"(5)","Average of Accumulated Depreciation at the beginning and end of the Test Year.  Enter as a negative amount."]
[null,"(6)","Select option from drop-down list by clicking on cell M10.  This column allows for the application update reflecting the end of discovery or Argument-in-Chief.  Also, the outcome of any Settlement Process can be reflected."]
[null,"(7)","Input total revenue offsets for deriving the base revenue requirement from the service revenue requirement"]
[null,"(8)","4.0% unless an Applicant has proposed or been approved for another amount."]
[null,"(9)","Starting with 2013, default Working Capital Allowance factor is 13% (of Cost of Power plus controllable expenses).  Alternatively, WCA factor based on lead-lag study or approved WCA factor for another distributor, with supporting rationale."]

{"sheet":"4. Rate_Base","index":3,"n_rows":35,"n_cols":23,"rows_kept":35,"cut":false,"hidden":false,"merged":[[33,3,33,22],[34,3,34,22],[35,3,35,22],[40,3,40,22],[41,3,41,22],[36,3,36,22],[37,3,37,22],[38,3,38,22],[39,3,39,22],[2,2,2,6],[3,2,3,6],[0,2,0,10],[1,2,1,22],[32,1,32,22],[17,6,18,6],[17,10,18,10],[17,22,18,22],[17,3,18,3],[21,3,21,22],[17,14,18,14],[17,18,18,18]]}
[]
[]
[]
[]
[]
[null,"Rate Base and Working Capital"]
[]
[]
[]
[null,null,null,"Rate Base"]
[null,"Line No.",null,"Particulars",null,null,"Initial Application",null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M12),\"\",'3. Data_Input_Sheet'!I12)","v":"Adjustments"},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M12),\" \",'3. Data_Input_Sheet'!M12)","v":"Close of Discovery"},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!Q12),\"\",'3. Data_Input_Sheet'!Q12)","v":"Adjustments"},null,null,null,{"$f":"'3. Data_Input_Sheet'!U12","v":"Per Board Decision"}]
[]
[null,1,null,"Gross Fixed Assets (average)","(3)",null,{"$f":"'3. Data_Input_Sheet'!E16","v":193294.95235111908},null,null,null,{"$f":"'3. Data_Input_Sheet'!I16","v":-892.02853610171587},null,null,null,{"$f":"G13+K13","v":192402.92381501736},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q16","v":-5050.0000248849101},null,null,null,{"$f":"G13+K13+S13","v":187352.92379013245}]
[null,2,null,"Accumulated Depreciation (average)","(3)",null,{"$f":"'3. Data_Input_Sheet'!E17","v":-91145.939590779191},null,null,null,{"$f":"'3. Data_Input_Sheet'!I17","v":-92.909145970217651},null,null,null,{"$f":"G14+K14","v":-91238.848736749409},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q17","v":-124.55797439120943},null,null,null,{"$f":"G14+K14+S14","v":-91363.406711140618}]
[null,3,null,"Net Fixed Assets (average)","(3)",null,{"$f":"SUM(G13:G14)","v":102149.01276033989},null,null,null,{"$f":"SUM(K13:K14)","v":-984.93768207193352},null,null,null,{"$f":"SUM(O13:O14)","v":101164.07507826795},null,null,null,{"$f":"SUM(S13:S14)","v":-5174.5579992761195},null,null,null,{"$f":"SUM(W13:W14)","v":95989.517078991834}]
[]
[null,4,null,"Allowance for Working Capital","(1)",null,{"$f":"G30","v":17741.545537511982},null,null,null,{"$f":"K30","v":-3881.4828111454754},null,null,null,{"$f":"O30","v":13860.062726366506},null,null,null,{"$f":"S30","v":-1312.6665464791477},null,null,null,{"$f":"W30","v":12547.396179887359}]
[null,null,null,"Total Rate Base",null,null,{"$f":"G17+G15","v":119890.55829785187},null,null,null,{"$f":"K17+K15","v":-4866.4204932174089},null,null,null,{"$f":"O17+O15","v":115024.13780463446},null,null,null,{"$f":"S17+S15","v":-6487.2245457552672},null,null,null,{"$f":"W15+W17","v":108536.9132588792}]
[null,5]
[null,null,"(1)","Allowance for Working Capital - Derivation"]
[]
[]
[]
[null,6,null,"Controllable Expenses",null,null,{"$f":"'3. Data_Input_Sheet'!E19","v":12886.687744033659},null,null,null,{"$f":"'3. Data_Input_Sheet'!I19","v":133.83766874000139},null,null,null,{"$f":"G24+K24","v":13020.525412773661},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q19","v":0},null,null,null,{"$f":"G24+K24+S24","v":13020.525412773661}]
[null,7,null,"Cost of Power",null,null,{"$f":"'3. Data_Input_Sheet'!E20","v":123586.73946759697},null,null,null,{"$f":"'3. Data_Input_Sheet'!I20","v":1716.7144246843236},null,null,null,{"$f":"G25+K25","v":125303.45389228129},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q20","v":-4413.6678868334129},null,null,null,{"$f":"G25+K25+S25","v":120889.78600544788}]
[null,8,null,"Working Capital Base",null,null,{"$f":"SUM(G24:G25)","v":136473.42721163062},null,null,null,{"$f":"K24+K25","v":1850.552093424325},null,null,null,{"$f":"SUM(O24:O25)","v":138323.97930505496},null,null,null,{"$f":"S24+S25","v":-4413.6678868334129},null,null,null,{"$f":"SUM(W24:W25)","v":133910.31141822154}]
[]
[null,9,null,"Working Capital Rate % ","(2)",null,{"$f":"'3. Data_Input_Sheet'!E21","v":0.13},null,null,null,{"$f":"O28-G28","v":-2.9800000000000007E-2},null,null,null,{"$f":"'3. Data_Input_Sheet'!M21","v":0.1002},null,null,null,{"$f":"W28-O28","v":-6.4999999999999919E-3},null,null,null,{"$f":"'3. Data_Input_Sheet'!U21","v":9.3700000000000006E-2}]
[]
[null,10,null,"Working Capital Allowance",null,null,{"$f":"G26*G28","v":17741.545537511982},null,null,null,{"$f":"O30-G30","v":-3881.4828111454754},null,null,null,{"$f":"O26*O28","v":13860.062726366506},null,null,null,{"$f":"W30-O30","v":-1312.6665464791477},null,null,null,{"$f":"W26*W28","v":12547.396179887359}]
[]
[]
[null,"Notes"]
[null,"(2)",null,"Some Applicants may have a unique rate as a result of a lead-lag study.  The default rate for 2014 cost of service applications is 13%."]
[null,"(3)",null,"Average of opening and closing balances for the year."]

{"sheet":"5. Utility Income","index":4,"n_rows":49,"n_cols":22,"rows_kept":49,"cut":false,"hidden":false,"merged":[[47,9,48,9],[47,13,48,13],[47,17,48,17],[34,9,35,9],[36,9,37,9],[26,9,27,9],[34,21,35,21],[34,5,35,5],[36,21,37,21],[36,5,37,5],[36,17,37,17],[0,2,0,11],[2,2,2,7],[3,2,3,7],[1,2,1,21],[17,21,18,21],[17,13,18,13],[17,17,18,17],[7,5,7,21],[17,5,18,5],[17,9,18,9],[56,3,56,21],[54,3,54,21],[55,3,55,21],[51,3,51,21],[26,5,27,5],[53,3,53,21],[52,3,52,21],[47,5,48,5],[47,21,48,21],[41,1,41,21],[36,13,37,13],[26,21,27,21],[26,13,27,13],[34,13,35,13],[26,17,27,17],[34,17,35,17]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Utility Income"]
[]
[null,"Line No.",null,"Particulars                                ",null,"Initial Application   ",null,null,null,{"$f":"IF(N13=\"\",\"\",\"Adjustments\")","v":"Adjustments"},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M12),\"\",'3. Data_Input_Sheet'!M12)","v":"Close of Discovery"},null,null,null,{"$f":"IF(N13=\"\",\"\",\"Adjustments\")","v":"Adjustments"},null,null,null,{"$f":"'3. Data_Input_Sheet'!U12","v":"Per Board Decision"}]
[]
[null,null,null,"Operating Revenues:"]
[null,1,null,"Distribution Revenue (at Proposed Rates)",null,{"$f":"'3. Data_Input_Sheet'!E26","v":24391.238721013513},null,null,null,{"$f":"N16-F16","v":-687.03691378584335},null,null,null,{"$f":"'3. Data_Input_Sheet'!M26","v":23704.20180722767},null,null,null,{"$f":"V16-N16","v":-625.20262954845384},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U26),'5. Utility Income'!N16,'3. Data_Input_Sheet'!U26)","v":23078.999177679216}]
[null,2,null,"Other Revenue","(1)",{"$f":"F48","v":1631.1917441093049},null,null,null,{"$f":"N17-F17","v":-21.468829608607621},null,null,null,{"$f":"N48","v":1609.7229145006972},null,null,null,{"$f":"V17-N17","v":-31.073736314518101},null,null,null,{"$f":"V48","v":1578.6491781861791}]
[null,null,null,null,null,{"$f":"SUM(F16:F17)","v":26022.430465122819},null,null,null,{"$f":"SUM(J16:J17)","v":-708.50574339445097},null,null,null,{"$f":"SUM(N16:N17)","v":25313.924721728366},null,null,null,{"$f":"SUM(R16:R17)","v":-656.27636586297194},null,null,null,{"$f":"SUM(V16:V17)","v":24657.648355865396}]
[null,3,null,"Total Operating Revenues"]
[]
[null,null,null,"Operating Expenses:"]
[null,4,null,"OM+A Expenses",null,{"$f":"'3. Data_Input_Sheet'!E36","v":12690.387638452215},null,null,null,{"$f":"'3. Data_Input_Sheet'!I36","v":133.83766874000139},null,null,null,{"$f":"'3. Data_Input_Sheet'!M36","v":12824.225307192217},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q36","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!U36","v":12824.225307192217}]
[null,5,null,"Depreciation/Amortization",null,{"$f":"'3. Data_Input_Sheet'!E37","v":5000.9720499314644},null,null,null,{"$f":"'3. Data_Input_Sheet'!I37","v":-181.28718657993068},null,null,null,{"$f":"'3. Data_Input_Sheet'!M37","v":4819.6848633515337},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q37","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!U37","v":4819.6848633515337}]
[null,6,null,"Property taxes",null,{"$f":"'3. Data_Input_Sheet'!E38","v":165.00737199945598},null,null,null,{"$f":"'3. Data_Input_Sheet'!I38","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!M38","v":165.00737199945598},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q38","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!U38","v":165.00737199945598}]
[null,7,null,"Capital taxes",null,{"$f":"'6. Taxes_PILs'!G25","v":0},null,null,null,{"$f":"N25-F25","v":0},null,null,null,{"$f":"'6. Taxes_PILs'!K25","v":0},null,null,null,{"$f":"V25-N25","v":0},null,null,null,{"$f":"'6. Taxes_PILs'!O25","v":0}]
[null,8,null,"Other expense",null,{"$f":"'3. Data_Input_Sheet'!E40","v":31.292733581986994},null,null,null,{"$f":"'3. Data_Input_Sheet'!I40","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!M40","v":31.292733581986994},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q40","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!U40","v":31.292733581986994}]
[null,null,null,null,null,{"$f":"SUM(F22:F26)","v":17887.659793965122},null,null,null,{"$f":"SUM(J22:J26)","v":-47.449517839929285},null,null,null,{"$f":"SUM(N22:N26)","v":17840.210276125192},null,null,null,{"$f":"SUM(R22:R26)","v":0},null,null,null,{"$f":"SUM(V22:V26)","v":17840.210276125192}]
[null,9,null,"Subtotal (lines 4 to 8)"]
[]
[null,10,null,"Deemed Interest Expense",null,{"$f":"'7. Cost_of_Capital'!P19","v":3192.8215051065172},null,null,null,{"$f":"N30-F30","v":-543.27757707152068},null,null,null,{"$f":"'7. Cost_of_Capital'!P35","v":2649.5439280349965},null,null,null,{"$f":"V30-N30","v":-245.85571514767207},null,null,null,{"$f":"'7. Cost_of_Capital'!P51","v":2403.6882128873244}]
[]
[null,11,null,"Total Expenses (lines 9 to 10)",null,{"$f":"F27+F30","v":21080.481299071638},null,null,null,{"$f":"J30+J27","v":-590.72709491144997},null,null,null,{"$f":"N30+N27","v":20489.754204160188},null,null,null,{"$f":"R30+R27","v":-245.85571514767207},null,null,null,{"$f":"V27+V30","v":20243.898489012518}]
[]
[null,12,null,"Utility income before income taxes",null,{"$f":"F18-(F32)","v":4941.9491660511812},null,null,null,{"$f":"J18-(J32)","v":-117.77864848300101},null,null,null,{"$f":"N18-(N32)","v":4824.1705175681782},null,null,null,{"$f":"R18-(R32)","v":-410.42065071529987},null,null,null,{"$f":"V18-(V32)","v":4413.7498668528788}]
[null,null,null,null,null,{"$f":"'6. Taxes_PILs'!G31","v":482.02039737109214},null,null,null,{"$f":"N35-F35","v":-51.747826013670419},null,null,null,{"$f":"'6. Taxes_PILs'!K31","v":430.27257135742173},null,null,null,{"$f":"V35-N35","v":-6.3396359009421985},null,null,null,{"$f":"IF('6. Taxes_PILs'!O31=0,N35,'6. Taxes_PILs'!O31)","v":423.93293545647953}]
[null,13,null,"Income taxes (grossed-up)"]
[null,null,null,null,null,{"$f":"F34-F35","v":4459.928768680089},null,null,null,{"$f":"J34-J35","v":-66.030822469330587},null,null,null,{"$f":"N34-N35","v":4393.8979462107563},null,null,null,{"$f":"R34-R35","v":-404.08101481435767},null,null,null,{"$f":"V34-V35","v":3989.816931396399}]
[null,14,null,"Utility net income"]
[]
[]
[]
[null,"Notes"]
[]
[null,"(1)",null,"  Specific Service Charges",null,{"$f":"'3. Data_Input_Sheet'!E28","v":1019.924020218933},null,null,null,{"$f":"'3. Data_Input_Sheet'!I28","v":-12.890021018284529},null,null,null,{"$f":"'3. Data_Input_Sheet'!M28","v":1007.0339992006485},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q28","v":-18.265827611042369},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U28),N44,'3. Data_Input_Sheet'!U28)","v":988.76817158960614}]
[null,null,null,"  Late Payment Charges",null,{"$f":"'3. Data_Input_Sheet'!E29","v":309.75434141684508},null,null,null,{"$f":"'3. Data_Input_Sheet'!I29","v":-5.2886624555090407},null,null,null,{"$f":"'3. Data_Input_Sheet'!M29","v":304.46567896133604},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q29","v":-7.4943087034757809},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U29),N45,'3. Data_Input_Sheet'!U29)","v":296.97137025786026}]
[null,null,null,"  Other Distribution Revenue",null,{"$f":"'3. Data_Input_Sheet'!E30","v":173.51338247352678},null,null,null,{"$f":"'3. Data_Input_Sheet'!I30","v":-3.2901461348140515},null,null,null,{"$f":"'3. Data_Input_Sheet'!M30","v":170.22323633871272},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q30","v":-5.3136000000000081},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U30),N46,'3. Data_Input_Sheet'!U30)","v":164.90963633871272}]
[null,null,null,"  Other Income and Deductions",null,{"$f":"'3. Data_Input_Sheet'!E31","v":128},null,null,null,{"$f":"'3. Data_Input_Sheet'!I31","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!M31","v":128},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q31","v":0},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U31),N47,'3. Data_Input_Sheet'!U31)","v":128}]
[null,null,null,null,null,{"$f":"SUM(F44:F47)","v":1631.1917441093049},null,null,null,{"$f":"SUM(J44:J47)","v":-21.468829608607621},null,null,null,{"$f":"SUM(N44:N47)","v":1609.7229145006972},null,null,null,{"$f":"SUM(R44:R47)","v":-31.073736314518158},null,null,null,{"$f":"SUM(V44:V47)","v":1578.6491781861791}]
[null,null,null,"Total Revenue Offsets"]

{"sheet":"6. Taxes_PILs","index":5,"n_rows":45,"n_cols":15,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,3,44,14],[51,3,51,14],[52,3,52,14],[45,3,45,14],[49,3,49,14],[50,3,50,14],[0,3,0,12],[2,2,2,6],[3,2,3,6],[1,2,1,14],[43,1,43,14],[8,1,8,12],[25,6,26,6],[25,14,26,14],[15,3,15,4],[17,3,17,4],[19,3,19,4],[32,3,32,4],[25,10,26,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Taxes/PILs"]
[]
[]
[null,"Line No.",null,"Particulars ",null,null,"Application",null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M12),\"\",'3. Data_Input_Sheet'!M12)","v":"Close of Discovery"},null,null,null,{"$f":"'3. Data_Input_Sheet'!U12","v":"Per Board Decision"}]
[]
[null,null,null,"Determination of Taxable Income"]
[]
[null,1,null,"Utility net income before taxes",null,null,{"$f":"'7. Cost_of_Capital'!P22","v":4459.9287686800881},null,null,null,{"$f":"'7. Cost_of_Capital'!P38","v":4278.8979263324009},null,null,null,{"$f":"'7. Cost_of_Capital'!P54","v":3989.8169313963981}]
[]
[null,2,null,"Adjustments required to arrive at taxable utility income",null,null,{"$f":"'3. Data_Input_Sheet'!E44","v":-2912.0633584876014},null,null,null,{"$f":"'3. Data_Input_Sheet'!M44","v":-2691.2164912781263},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U44),G18,'3. Data_Input_Sheet'!U44)","v":-2419.8485092103365}]
[]
[null,3,null,"Taxable income",null,null,{"$f":"G16+G18","v":1547.8654101924867},null,null,null,{"$f":"K16+K18","v":1587.6814350542745},null,null,null,{"$f":"O16+O18","v":1569.9684221860616}]
[]
[null,null,null,"Calculation of Utility income Taxes"]
[]
[null,4,null,"Income taxes",null,null,{"$f":"'3. Data_Input_Sheet'!E46","v":365.184333701009},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M46),'6. Taxes_PILs'!G24,'3. Data_Input_Sheet'!M46)","v":325.73558028938277},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U46),'6. Taxes_PILs'!K24,'3. Data_Input_Sheet'!U46)","v":321.04163187930641}]
[null,5,null,"Capital taxes",null,null,{"$f":"'3. Data_Input_Sheet'!E48","v":0},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M48),'6. Taxes_PILs'!G25,'3. Data_Input_Sheet'!M48)","v":0},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U48),'6. Taxes_PILs'!K25,'3. Data_Input_Sheet'!U48)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G24:G25)","v":365.184333701009},null,null,null,{"$f":"SUM(K24:K25)","v":325.73558028938277},null,null,null,{"$f":"SUM(O24:O25)","v":321.04163187930641}]
[null,6,null,"Total taxes"]
[]
[null,7,null,"Gross-up of Income Taxes",null,null,{"$f":"(G24/(1-G41))-G24","v":116.83606367008315},null,null,null,{"$f":"(K24/(1-K41))-K24","v":104.53699106803896},null,null,null,{"$f":"(O24/(1-O41))-O24","v":102.89130357717312}]
[]
[null,8,null,"Grossed-up Income Taxes",null,null,{"$f":"G24+G29","v":482.02039737109214},null,null,null,{"$f":"K24+K29","v":430.27257135742173},null,null,null,{"$f":"O24+O29","v":423.93293545647953}]
[]
[null,9,null,"PILs / tax Allowance (Grossed-up Income taxes + Capital taxes)",null,null,{"$f":"G26+G29","v":482.02039737109214},null,null,null,{"$f":"K29+K26","v":430.27257135742173},null,null,null,{"$f":"O29+O26","v":423.93293545647953}]
[]
[null,10,null,"Other tax Credits",null,null,{"$f":"'3. Data_Input_Sheet'!E51","v":-10},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M51),G35,'3. Data_Input_Sheet'!M51)","v":-60},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U51),K35,'3. Data_Input_Sheet'!U51)","v":-60}]
[]
[null,null,null,"Tax Rates"]
[]
[null,11,null,"Federal tax (%)",null,null,{"$f":"'3. Data_Input_Sheet'!E49","v":0.15000000000000002},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M49),G39,'3. Data_Input_Sheet'!M49)","v":0.15000000000000002},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U49),K39,'3. Data_Input_Sheet'!U49)","v":0.15000000000000002}]
[null,12,null,"Provincial tax (%)",null,null,{"$f":"'3. Data_Input_Sheet'!E50","v":9.2388214912272296E-2},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M50),G40,'3. Data_Input_Sheet'!M50)","v":9.2955275392633457E-2},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U50),K40,'3. Data_Input_Sheet'!U50)","v":9.2706557975691536E-2}]
[null,13,null,"Total tax rate (%)",null,null,{"$f":"G39+G40","v":0.2423882149122723},null,null,null,{"$f":"K39+K40","v":0.24295527539263348},null,null,null,{"$f":"O39+O40","v":0.24270655797569157}]
[]
[]
[null,"Notes"]
[null,null,null,"Capital Taxes not applicable after July 1, 2010 (i.e. for 2011 and later test years)"]

{"sheet":"7. Cost_of_Capital","index":6,"n_rows":62,"n_cols":16,"rows_kept":62,"cut":false,"hidden":false,"merged":[[13,3,13,15],[29,3,29,15],[44,5,44,9],[28,5,28,9],[66,3,66,15],[60,1,60,15],[45,3,45,15],[67,3,67,15],[65,3,65,15],[61,3,61,15],[62,3,62,15],[63,3,63,15],[64,3,64,15],[0,2,0,13],[2,2,2,13],[3,2,3,9],[1,2,1,17],[12,5,12,9],[4,1,4,13],[10,5,10,9]]}
[]
[]
[]
[]
[null,"Capitalization/Cost of Capital"]
[]
[]
[]
[]
[]
[null,"Line No.",null,"Particulars",null,"Capitalization Ratio",null,null,null,null,null,"Cost Rate",null,null,null,"Return"]
[]
[null,null,null,null,null,"Initial Application"]
[]
[null,null,null,null,null,"(%)",null,null,null,"($)",null,"(%)",null,null,null,"($)"]
[null,null,null,"Debt"]
[null,1,null,"  Long-term Debt",null,{"$f":"'3. Data_Input_Sheet'!E55","v":0.56000000000000005},null,null,null,{"$f":"$J$26*F17","v":67138.712646797052},null,{"$f":"'3. Data_Input_Sheet'!E62","v":4.6012739013764056E-2},null,null,null,{"$f":"L17*J17","v":3089.2360627371731}]
[null,2,null,"  Short-term Debt",null,{"$f":"'3. Data_Input_Sheet'!E56","v":0.04},null,null,null,{"$f":"$J$26*F18","v":4795.6223319140745},null,{"$f":"'3. Data_Input_Sheet'!E63","v":2.1600000000000001E-2},null,null,null,{"$f":"L18*J18","v":103.58544236934401}]
[null,3,null,"Total Debt",null,{"$f":"SUM(F17:F18)","v":0.60000000000000009},null,null,null,{"$f":"SUM(J17:J18)","v":71934.334978711122},null,{"$f":"IF(F19=0,0,SUMPRODUCT(F17:F18,L17:L18)/F19)","v":4.438522307951312E-2},null,null,null,{"$f":"SUM(P17:P18)","v":3192.8215051065172}]
[]
[null,null,null,"Equity"]
[null,4,null,"  Common Equity",null,{"$f":"'3. Data_Input_Sheet'!E57","v":0.39999999999999991},null,null,null,{"$f":"$J$26*F22","v":47956.223319140736},null,{"$f":"'3. Data_Input_Sheet'!E64","v":9.2999999999999999E-2},null,null,null,{"$f":"L22*J22","v":4459.9287686800881}]
[null,5,null,"  Preferred Shares",null,{"$f":"'3. Data_Input_Sheet'!E58","v":0},null,null,null,{"$f":"$J$26*F23","v":0},null,{"$f":"'3. Data_Input_Sheet'!E65","v":0},null,null,null,{"$f":"L23*J23","v":0}]
[null,6,null,"Total Equity",null,{"$f":"SUM(F22:F23)","v":0.39999999999999991},null,null,null,{"$f":"SUM(J22:J23)","v":47956.223319140736},null,{"$f":"IF(F24=0,0,SUMPRODUCT(F22:F23,L22:L23)/F24)","v":9.2999999999999999E-2},null,null,null,{"$f":"SUM(P22:P23)","v":4459.9287686800881}]
[]
[null,7,null,"Total",null,{"$f":"SUM(F19,F24)","v":1},null,null,null,{"$f":"'4. Rate_Base'!G18","v":119890.55829785187},null,{"$f":"(L19*F19)+(L24*F24)","v":6.383113384770786E-2},null,null,null,{"$f":"P19+P24","v":7652.7502737866052}]
[]
[]
[null,null,null,null,null,{"$f":"'1. Info'!AC1","v":"Close of Discovery"}]
[]
[null,null,null,null,null,"(%)",null,null,null,"($)",null,"(%)",null,null,null,"($)"]
[null,null,null,"Debt"]
[null,1,null,"  Long-term Debt",null,{"$f":"'3. Data_Input_Sheet'!M55","v":0.56000000000000005},null,null,null,{"$f":"$J$42*F33","v":64413.517170595303},null,{"$f":"'3. Data_Input_Sheet'!M62","v":3.9590495675276352E-2},null,null,null,{"$f":"L33*J33","v":2550.1630729717922}]
[null,2,null,"  Short-term Debt",null,{"$f":"'3. Data_Input_Sheet'!M56","v":0.04},null,null,null,{"$f":"$J$42*F34","v":4600.9655121853784},null,{"$f":"'3. Data_Input_Sheet'!M63","v":2.1600000000000001E-2},null,null,null,{"$f":"L34*J34","v":99.38085506320418}]
[null,3,null,"Total Debt",null,{"$f":"SUM(F33:F34)","v":0.60000000000000009},null,null,null,{"$f":"SUM(J33:J34)","v":69014.482682780683},null,{"$f":"IF(F35=0,0,SUMPRODUCT(F33:F34,L33:L34)/F35)","v":3.8391129296924592E-2},null,null,null,{"$f":"SUM(P33:P34)","v":2649.5439280349965}]
[]
[null,null,null,"Equity"]
[null,4,null,"  Common Equity",null,{"$f":"'3. Data_Input_Sheet'!M57","v":0.39999999999999991},null,null,null,{"$f":"$J$42*F38","v":46009.655121853772},null,{"$f":"'3. Data_Input_Sheet'!M64","v":9.2999999999999999E-2},null,null,null,{"$f":"L38*J38","v":4278.8979263324009}]
[null,5,null,"  Preferred Shares",null,{"$f":"'3. Data_Input_Sheet'!M58","v":0},null,null,null,{"$f":"$J$42*F39","v":0},null,{"$f":"'3. Data_Input_Sheet'!M65","v":0},null,null,null,{"$f":"L39*J39","v":0}]
[null,6,null,"Total Equity",null,{"$f":"SUM(F38:F39)","v":0.39999999999999991},null,null,null,{"$f":"SUM(J38:J39)","v":46009.655121853772},null,{"$f":"IF(F40=0,0,SUMPRODUCT(F38:F39,L38:L39)/F40)","v":9.2999999999999999E-2},null,null,null,{"$f":"SUM(P38:P39)","v":4278.8979263324009}]
[]
[null,7,null,"Total",null,{"$f":"F35+F40","v":1},null,null,null,{"$f":"'4. Rate_Base'!O18","v":115024.13780463446},null,{"$f":"(L35*F35)+(L40*F40)","v":6.0234677578154747E-2},null,null,null,{"$f":"P35+P40","v":6928.4418543673974}]
[]
[]
[null,null,null,null,null,"Per Board Decision"]
[]
[null,null,null,null,null,"(%)",null,null,null,"($)",null,"(%)",null,null,null,"($)"]
[null,null,null,"Debt"]
[null,8,null,"  Long-term Debt",null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U55),F33,'3. Data_Input_Sheet'!U55)","v":0.56000000000000005},null,null,null,{"$f":"$J$58*F49","v":60780.671424972359},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U62),L17,'3. Data_Input_Sheet'!U62)","v":3.8368346309157683E-2},null,null,null,{"$f":"L49*J49","v":2332.053850136464}]
[null,9,null,"  Short-term Debt",null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U56),F34,'3. Data_Input_Sheet'!U56)","v":0.04},null,null,null,{"$f":"$J$58*F50","v":4341.4765303551676},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U63),L18,'3. Data_Input_Sheet'!U63)","v":1.6500000000000001E-2},null,null,null,{"$f":"L50*J50","v":71.634362750860262}]
[null,10,null,"Total Debt",null,{"$f":"SUM(F49:F50)","v":0.60000000000000009},null,null,null,{"$f":"SUM(J49:J50)","v":65122.147955327528},null,{"$f":"IF(F51=0,0,SUMPRODUCT(F49:F50,L49:L50)/F51)","v":3.6910456555213834E-2},null,null,null,{"$f":"SUM(P49:P50)","v":2403.6882128873244}]
[]
[null,null,null,"Equity"]
[null,11,null,"  Common Equity",null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U57),F38,'3. Data_Input_Sheet'!U57)","v":0.39999999999999991},null,null,null,{"$f":"$J$58*F54","v":43414.765303551671},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U64),L22,'3. Data_Input_Sheet'!U64)","v":9.1899999999999996E-2},null,null,null,{"$f":"L54*J54","v":3989.8169313963981}]
[null,12,null,"  Preferred Shares",null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U58),F39,'3. Data_Input_Sheet'!U58)","v":0},null,null,null,{"$f":"$J$58*F55","v":0},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U65),L23,'3. Data_Input_Sheet'!U65)","v":0},null,null,null,{"$f":"L55*J55","v":0}]
[null,13,null,"Total Equity",null,{"$f":"SUM(F54:F55)","v":0.39999999999999991},null,null,null,{"$f":"SUM(J54:J55)","v":43414.765303551671},null,{"$f":"IF(F56=0,0,SUMPRODUCT(F54:F55,L54:L55)/F56)","v":9.1899999999999982E-2},null,null,null,{"$f":"SUM(P54:P55)","v":3989.8169313963981}]
[]
[null,14,null,"Total",null,{"$f":"F51+F56","v":1},null,null,null,{"$f":"'4. Rate_Base'!W18","v":108536.9132588792},null,{"$f":"(L51*F51)+(L56*F56)","v":5.8906273933128292E-2},null,null,null,{"$f":"P51+P56","v":6393.505144283723}]
[]
[]
[null,"Notes"]
[null,"(1)",null,{"$f":"'3. Data_Input_Sheet'!C71","v":"Data in column E is for Application as originally filed.  For updated revenue requirement as a result of interrogatory responses, technical or settlement conferences, etc., use colimn M and Adjustments in column I"}]

{"sheet":"8. Rev_Def_Suff","index":7,"n_rows":56,"n_cols":16,"rows_kept":56,"cut":false,"hidden":false,"merged":[[59,3,59,15],[55,3,55,15],[57,3,57,15],[58,3,58,15],[7,5,7,15],[14,7,15,7],[14,15,15,15],[14,5,15,5],[12,13,12,15],[14,13,15,13],[12,9,12,11],[14,9,15,9],[14,11,15,11],[56,3,56,15],[0,2,0,14],[1,2,1,14],[2,2,2,14],[3,2,3,7],[54,1,54,8],[14,3,15,3],[14,1,15,1],[12,5,12,7]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE('2. Table of Contents'!$F$6,\" \",'2. Table of Contents'!$G$6)","v":" "}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Revenue Deficiency/Sufficiency"]
[]
[]
[null,null,null,null,null,"Initial Application",null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M12),\"\",'3. Data_Input_Sheet'!M12)","v":"Close of Discovery"},null,null,null,{"$f":"'3. Data_Input_Sheet'!U12","v":"Per Board Decision"}]
[]
[null,"Line No.",null,"Particulars",null,"At Current Approved Rates",null,"At Proposed Rates",null,"At Current Approved Rates",null,"At Proposed Rates",null,"At Current Approved Rates",null,"At Proposed Rates"]
[]
[]
[]
[null,1,null,"Revenue Deficiency from Below",null,null,null,{"$f":"F52","v":440.55560476370971},null,null,null,{"$f":"J52","v":287.79118971690423},null,null,null,{"$f":"N52","v":488.63256210796197}]
[null,2,null,"Distribution Revenue",null,{"$f":"'3. Data_Input_Sheet'!E25","v":23950.683116249802},null,{"$f":"'3. Data_Input_Sheet'!E26-H19","v":23950.683116249802},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M25),'3. Data_Input_Sheet'!E25,'3. Data_Input_Sheet'!M25)","v":23301.41059763241},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M26),'3. Data_Input_Sheet'!E26-L19,'3. Data_Input_Sheet'!M26-L19)","v":23416.410617510766},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U25),'3. Data_Input_Sheet'!M25,'3. Data_Input_Sheet'!U25)","v":22590.366615571253},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U26),'3. Data_Input_Sheet'!M26-P19,'3. Data_Input_Sheet'!U26-P19)","v":22590.366615571253}]
[null,3,null,"Other Operating Revenue Offsets - net",null,{"$f":"'5. Utility Income'!F48","v":1631.1917441093049},null,{"$f":"'5. Utility Income'!F48","v":1631.1917441093049},null,{"$f":"'5. Utility Income'!N48","v":1609.7229145006972},null,{"$f":"J21","v":1609.7229145006972},null,{"$f":"'5. Utility Income'!V48","v":1578.6491781861791},null,{"$f":"'5. Utility Income'!V48","v":1578.6491781861791}]
[null,4,null,"Total Revenue",null,{"$f":"SUM(F20:F21)","v":25581.874860359108},null,{"$f":"SUM(H19:H21)","v":26022.430465122819},null,{"$f":"SUM(J20:J21)","v":24911.133512133107},null,{"$f":"SUM(L19:L21)","v":25313.924721728366},null,{"$f":"SUM(N20:N21)","v":24169.015793757433},null,{"$f":"SUM(P19:P21)","v":24657.648355865396}]
[]
[null,5,null,"Operating Expenses",null,{"$f":"'5. Utility Income'!F27","v":17887.659793965122},null,{"$f":"'5. Utility Income'!F27","v":17887.659793965122},null,{"$f":"'5. Utility Income'!N27","v":17840.210276125192},null,{"$f":"'5. Utility Income'!N27","v":17840.210276125192},null,{"$f":"'5. Utility Income'!V27","v":17840.210276125192},null,{"$f":"'5. Utility Income'!V27","v":17840.210276125192}]
[null,6,null,"Deemed Interest Expense",null,{"$f":"'5. Utility Income'!F30","v":3192.8215051065172},null,{"$f":"'5. Utility Income'!F30","v":3192.8215051065172},null,{"$f":"'5. Utility Income'!N30","v":2649.5439280349965},null,{"$f":"'5. Utility Income'!N30","v":2649.5439280349965},null,{"$f":"'5. Utility Income'!V30","v":2403.6882128873244},null,{"$f":"'5. Utility Income'!V30","v":2403.6882128873244}]
[null,8,null,"Total Cost and Expenses",null,{"$f":"SUM(F24:F25)","v":21080.481299071638},null,{"$f":"SUM(H24:H25)","v":21080.481299071638},null,{"$f":"SUM(J24:J25)","v":20489.754204160188},null,{"$f":"SUM(L24:L25)","v":20489.754204160188},null,{"$f":"SUM(N24:N25)","v":20243.898489012518},null,{"$f":"SUM(P24:P25)","v":20243.898489012518}]
[]
[null,9,null,"Utility Income Before Income Taxes",null,{"$f":"F22-F26","v":4501.3935612874702},null,{"$f":"H22-H26","v":4941.9491660511812},null,{"$f":"J22-J26","v":4421.3793079729185},null,{"$f":"L22-L26","v":4824.1705175681782},null,{"$f":"N22-N26","v":3925.1173047449156},null,{"$f":"P22-P26","v":4413.7498668528788}]
[null,null,null,"   "]
[null,10,null,"Tax Adjustments to Accounting               Income per 2013 PILs model",null,{"$f":"'3. Data_Input_Sheet'!E44","v":-2912.0633584876014},null,{"$f":"'3. Data_Input_Sheet'!E44","v":-2912.0633584876014},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M44),'3. Data_Input_Sheet'!E44,'3. Data_Input_Sheet'!M44)","v":-2691.2164912781263},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M44),'3. Data_Input_Sheet'!E44,'3. Data_Input_Sheet'!M44)","v":-2691.2164912781263},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U44),'3. Data_Input_Sheet'!M44,'3. Data_Input_Sheet'!U44)","v":-2419.8485092103365},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U44),'3. Data_Input_Sheet'!M44,'3. Data_Input_Sheet'!U44)","v":-2419.8485092103365}]
[null,11,null,"Taxable Income",null,{"$f":"SUM(F28:F30)","v":1589.3302027998689},null,{"$f":"SUM(H28:H30)","v":2029.8858075635799},null,{"$f":"SUM(J28+J30)","v":1730.1628166947921},null,{"$f":"L28+L30","v":2132.9540262900518},null,{"$f":"SUM(N28+N30)","v":1505.2687955345791},null,{"$f":"P28+P30","v":1993.9013576425423}]
[]
[null,12,null,"Income Tax Rate",null,{"$f":"'6. Taxes_PILs'!G41","v":0.2423882149122723},null,{"$f":"'6. Taxes_PILs'!G41","v":0.2423882149122723},null,{"$f":"'6. Taxes_PILs'!K41","v":0.24295527539263348},null,{"$f":"'6. Taxes_PILs'!K41","v":0.24295527539263348},null,{"$f":"'6. Taxes_PILs'!O41","v":0.24270655797569157},null,{"$f":"'6. Taxes_PILs'!O41","v":0.24270655797569157}]
[null,13,null,"Income Tax on Taxable Income",null,{"$f":"F31*F33","v":385.23491076281994},null,{"$f":"H31*H33","v":492.02039737109243},null,{"$f":"J31*J33","v":420.35218360417764},null,{"$f":"L31*L33","v":518.21243285712592},null,{"$f":"N31*N33","v":365.33860819241272},null,{"$f":"P31*P33","v":483.93293545647981}]
[null,14,null,"Income Tax Credits",null,{"$f":"'3. Data_Input_Sheet'!E51","v":-10},null,{"$f":"'3. Data_Input_Sheet'!E51","v":-10},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M51),'3. Data_Input_Sheet'!E51,'3. Data_Input_Sheet'!M51)","v":-60},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M51),'3. Data_Input_Sheet'!E51,'3. Data_Input_Sheet'!M51)","v":-60},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U51),'3. Data_Input_Sheet'!M51,'3. Data_Input_Sheet'!U51)","v":-60},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U51),'3. Data_Input_Sheet'!M51,'3. Data_Input_Sheet'!U51)","v":-60}]
[null,15,null,"Utility Net Income ",null,{"$f":"F28-SUM(F34:F35)","v":4126.1586505246505},null,{"$f":"'5. Utility Income'!F37","v":4459.928768680089},null,{"$f":"J28-SUM(J34:J35)","v":4061.0271243687407},null,{"$f":"'5. Utility Income'!N37","v":4393.8979462107563},null,{"$f":"N28-SUM(N34:N35)","v":3619.7786965525029},null,{"$f":"'5. Utility Income'!V37","v":3989.816931396399}]
[]
[null,16,null,"Utility Rate Base",null,{"$f":"'4. Rate_Base'!G18","v":119890.55829785187},null,{"$f":"'4. Rate_Base'!G18","v":119890.55829785187},null,{"$f":"'4. Rate_Base'!O18","v":115024.13780463446},null,{"$f":"'4. Rate_Base'!O18","v":115024.13780463446},null,{"$f":"'4. Rate_Base'!W18","v":108536.9132588792},null,{"$f":"'4. Rate_Base'!W18","v":108536.9132588792}]
[]
[null,17,null,"Deemed Equity Portion of Rate Base ",null,{"$f":"'7. Cost_of_Capital'!J24","v":47956.223319140736},null,{"$f":"F40","v":47956.223319140736},null,{"$f":"'7. Cost_of_Capital'!J40","v":46009.655121853772},null,{"$f":"J40","v":46009.655121853772},null,{"$f":"'7. Cost_of_Capital'!J56","v":43414.765303551671},null,{"$f":"N40","v":43414.765303551671}]
[]
[null,18,null,"Income/(Equity Portion of Rate Base)",null,{"$f":"IF(F40=0,0,F36/F40)","v":8.6040108351855549E-2},null,{"$f":"IF(H40=0,0,H36/H40)","v":9.3000000000000013E-2},null,{"$f":"IF(J40=0,0,J36/J40)","v":8.8264672134867286E-2},null,{"$f":"IF(L40=0,0,L36/L40)","v":9.5499475807279688E-2},null,{"$f":"IF(N40=0,0,N36/N40)","v":8.33766731489477E-2},null,{"$f":"IF(P40=0,0,P36/P40)","v":9.1900000000000009E-2}]
[null,19,null,"Target Return - Equity on Rate Base",null,{"$f":"'7. Cost_of_Capital'!L24","v":9.2999999999999999E-2},null,{"$f":"'7. Cost_of_Capital'!L24","v":9.2999999999999999E-2},null,{"$f":"'7. Cost_of_Capital'!L40","v":9.2999999999999999E-2},null,{"$f":"'7. Cost_of_Capital'!L40","v":9.2999999999999999E-2},null,{"$f":"'7. Cost_of_Capital'!L56","v":9.1899999999999982E-2},null,{"$f":"'7. Cost_of_Capital'!L56","v":9.1899999999999982E-2}]
[null,20,null,"Deficiency/Sufficiency in Return on Equity",null,{"$f":"F42-F43","v":-6.9598916481444506E-3},null,{"$f":"H42-H43","v":0},null,{"$f":"J42-J43","v":-4.735327865132713E-3},null,{"$f":"L42-L43","v":2.4994758072796885E-3},null,{"$f":"N42-N43","v":-8.5233268510522819E-3},null,{"$f":"P42-P43","v":0}]
[]
[null,21,null,"Indicated Rate of Return",null,{"$f":"IF(F38=0,0,(F36+F25)/F38)","v":6.104717718845009E-2},null,{"$f":"IF(H38=0,0,(H36+H25)/H38)","v":6.3831133847707874E-2},null,{"$f":"IF(J38=0,0,(J36+J25)/J38)","v":5.834054643210166E-2},null,{"$f":"IF(L40=0,0,(L36+L25)/L38)","v":6.1234467901066625E-2},null,{"$f":"IF(N38=0,0,(N36+N25)/N38)","v":5.5496943192707378E-2},null,{"$f":"IF(P40=0,0,(P36+P25)/P38)","v":5.8906273933128299E-2}]
[null,22,null,"Requested Rate of Return on Rate Base",null,{"$f":"'7. Cost_of_Capital'!L26","v":6.383113384770786E-2},null,{"$f":"'7. Cost_of_Capital'!L26","v":6.383113384770786E-2},null,{"$f":"'7. Cost_of_Capital'!L42","v":6.0234677578154747E-2},null,{"$f":"'7. Cost_of_Capital'!L42","v":6.0234677578154747E-2},null,{"$f":"'7. Cost_of_Capital'!L58","v":5.8906273933128292E-2},null,{"$f":"'7. Cost_of_Capital'!L58","v":5.8906273933128292E-2}]
[null,23,null,"Deficiency/Sufficiency in Rate of Return",null,{"$f":"F46-F47","v":-2.7839566592577705E-3},null,{"$f":"H46-H47","v":0},null,{"$f":"J46-J47","v":-1.8941311460530866E-3},null,{"$f":"L46-L47","v":9.9979032291187819E-4},null,{"$f":"N46-N47","v":-3.4093307404209142E-3},null,{"$f":"P46-P47","v":0}]
[]
[null,24,null,"Target Return on Equity",null,{"$f":"H50","v":4459.9287686800881},null,{"$f":"'7. Cost_of_Capital'!P24","v":4459.9287686800881},null,{"$f":"L50","v":4278.8979263324009},null,{"$f":"'7. Cost_of_Capital'!P40","v":4278.8979263324009},null,{"$f":"P50","v":3989.8169313963981},null,{"$f":"'7. Cost_of_Capital'!P56","v":3989.8169313963981}]
[null,25,null,"Revenue Deficiency/(Sufficiency)",null,{"$f":"F50-F36","v":333.77011815543756}," ",{"$f":"H38*H48","v":0},null,{"$f":"J50-J36","v":217.87080196366014},null,{"$f":"L38*L48","v":115.00001987835586},null,{"$f":"N50-N36","v":370.03823484389522},null,{"$f":"P38*P48","v":0}]
[null,26,null,"Gross Revenue Deficiency/(Sufficiency)",null,{"$f":"F51/(1-F33)","v":440.55560476370971},"(1)",null,null,{"$f":"J51/(1-J33)","v":287.79118971690423},"(1)",null,null,{"$f":"N51/(1-N33)","v":488.63256210796197},"(1)"]
[]
[]
[null,"Notes:"]
[null,"(1)",null,"Revenue Deficiency/Sufficiency divided by (1 - Tax Rate)"]

{"sheet":"9. Rev_Reqt","index":8,"n_rows":39,"n_cols":17,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,2,0,13],[0,14,0,16],[19,13,19,14],[30,13,30,14],[17,13,17,14],[18,13,18,14],[21,13,21,14],[22,13,22,14],[29,13,29,14],[26,13,26,14],[27,13,27,14],[1,2,1,17],[2,2,2,17],[3,2,3,13],[14,13,14,14],[13,13,13,14],[12,13,12,14],[7,5,7,14],[41,3,41,16],[32,13,33,14],[34,13,35,14],[42,3,42,16],[43,3,43,16],[44,3,44,16],[15,13,15,14],[16,13,16,14],[20,13,20,14],[24,13,24,14],[39,3,39,16],[40,3,40,16],[37,1,37,14],[31,13,31,14],[32,9,33,9],[34,9,35,9],[34,5,35,5],[32,5,33,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Revenue Requirement"]
[]
[null,"Line No.",null,"Particulars",null,"Application   ",null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M12),\"\",'3. Data_Input_Sheet'!M12)","v":"Close of Discovery"},null,null,null,{"$f":"'3. Data_Input_Sheet'!U12","v":"Per Board Decision"}]
[]
[null,1,null,"OM&A Expenses",null,{"$f":"'5. Utility Income'!F22","v":12690.387638452215},null,null,null,{"$f":"'5. Utility Income'!N22","v":12824.225307192217},null,null,null,{"$f":"'5. Utility Income'!V22","v":12824.225307192217}]
[null,2,null,"Amortization/Depreciation",null,{"$f":"'5. Utility Income'!F23","v":5000.9720499314644},null,null,null,{"$f":"'5. Utility Income'!N23","v":4819.6848633515337},null,null,null,{"$f":"'5. Utility Income'!V23","v":4819.6848633515337}]
[null,3,null,"Property Taxes",null,{"$f":"'5. Utility Income'!F24","v":165.00737199945598},null,null,null,{"$f":"'5. Utility Income'!N24","v":165.00737199945598},null,null,null,{"$f":"'5. Utility Income'!V24","v":165.00737199945598}]
[null,4,null,"Capital Taxes",null,{"$f":"'6. Taxes_PILs'!G25","v":0},null,null,null,{"$f":"'6. Taxes_PILs'!K25","v":0},null,null,null,{"$f":"'6. Taxes_PILs'!O25","v":0}]
[null,5,null,"Income Taxes (Grossed up)",null,{"$f":"'6. Taxes_PILs'!G33-F18","v":482.02039737109214},null,null,null,{"$f":"'6. Taxes_PILs'!K33-J18","v":430.27257135742173},null,null,null,{"$f":"'6. Taxes_PILs'!O33-N18","v":423.93293545647953}]
[null,6,null,"Other Expenses",null,{"$f":"'5. Utility Income'!F26","v":31.292733581986994},null,null,null,{"$f":"'5. Utility Income'!N26","v":31.292733581986994},null,null,null,{"$f":"'5. Utility Income'!V26","v":31.292733581986994}]
[null,7,null,"Return"]
[null,null,null,"Deemed Interest Expense",null,{"$f":"'8. Rev_Def_Suff'!F25","v":3192.8215051065172},null,null,null,{"$f":"'8. Rev_Def_Suff'!L25","v":2649.5439280349965},null,null,null,{"$f":"'8. Rev_Def_Suff'!P25","v":2403.6882128873244}]
[null,null,null,"Return on Deemed Equity",null,{"$f":"'8. Rev_Def_Suff'!F50","v":4459.9287686800881},null,null,null,{"$f":"'8. Rev_Def_Suff'!L50","v":4278.8979263324009},null,null,null,{"$f":"'8. Rev_Def_Suff'!P50","v":3989.8169313963981}]
[]
[null,8,null,"Service Revenue Requirement (before Revenues)",null,{"$f":"SUM(F15:F23)","v":26022.430465122819},null,null,null,{"$f":"SUM(J15:J23)","v":25198.92470185001},null,null,null,{"$f":"SUM(N15:O23)","v":24657.648355865396}]
[]
[null,9,null,"Revenue Offsets",null,{"$f":"'3. Data_Input_Sheet'!E33","v":1631.1917441093049},null,null,null,{"$f":"'3. Data_Input_Sheet'!M33","v":1609.7229145006972},null,null,null,{"$f":"'3. Data_Input_Sheet'!U33","v":1578.6491781861791}]
[null,10,null,"Base Revenue Requirement",null,{"$f":"F25-F27","v":24391.238721013513},null,null,null,{"$f":"J25-J27","v":23589.201787349313},null,null,null,{"$f":"N25-N27","v":23078.999177679216}]
[null,null,null,"(excluding Tranformer Owership Allowance credit adjustment)"]
[]
[null,11,null,"Distribution revenue",null,{"$f":"'5. Utility Income'!F16","v":24391.238721013513},null,null,null,{"$f":"'5. Utility Income'!N16","v":23704.20180722767},null,null,null,{"$f":"'5. Utility Income'!V16","v":23078.999177679216}]
[null,12,null,"Other revenue",null,{"$f":"'5. Utility Income'!F17","v":1631.1917441093049},null,null,null,{"$f":"'5. Utility Income'!N17","v":1609.7229145006972},null,null,null,{"$f":"'5. Utility Income'!V17","v":1578.6491781861791}]
[null,null,null,null,null,{"$f":"SUM(F31:F32)","v":26022.430465122819},null,null,null,{"$f":"SUM(J31:J32)","v":25313.924721728366},null,null,null,{"$f":"SUM(N31:N32)","v":24657.648355865396}]
[null,13,null,"Total revenue"]
[null,null,null,null,null,{"$f":"F33-F25","v":0},null,null,null,{"$f":"J33-J25","v":115.0000198783564},null,null,null,{"$f":"N33-N25","v":0}]
[null,14,null,"Difference (Total Revenue Less Distribution Revenue Requirement before Revenues)",null,null,null,"(1)",null,null,null,"(1)",null,null,null,null,"(1)"]
[]
[null,"Notes"]
[null,"(1)",null,"Line 11 - Line 8"]

{"sheet":"10. Tracking_Sheet","index":9,"n_rows":203,"n_cols":19,"rows_kept":203,"cut":false,"hidden":false,"merged":[[52,18,52,20],[22,0,24,0],[22,1,23,1],[25,0,27,0],[25,1,26,1],[28,0,30,0],[28,1,29,1],[14,1,14,14],[15,1,15,14],[17,3,17,4],[17,5,17,7],[17,8,17,10],[17,11,17,14],[40,0,42,0],[40,1,41,1],[43,0,45,0],[43,1,44,1],[46,0,48,0],[46,1,47,1],[31,0,33,0],[31,1,32,1],[34,0,36,0],[34,1,35,1],[37,0,39,0],[67,0,69,0],[67,1,68,1],[70,0,72,0],[70,1,71,1],[73,0,75,0],[73,1,74,1],[37,1,38,1],[58,0,60,0],[58,1,59,1],[61,0,63,0],[61,1,62,1],[64,0,66,0],[64,1,65,1],[49,0,51,0],[49,1,50,1],[52,0,54,0],[52,1,53,1],[55,0,57,0],[55,1,56,1],[85,0,87,0],[85,1,86,1],[88,0,90,0],[88,1,89,1],[91,0,93,0],[91,1,92,1],[76,0,78,0],[76,1,77,1],[79,0,81,0],[79,1,80,1],[82,0,84,0],[82,1,83,1],[103,0,105,0],[103,1,104,1],[106,0,108,0],[106,1,107,1],[109,0,111,0],[109,1,110,1],[94,0,96,0],[94,1,95,1],[97,0,99,0],[97,1,98,1],[100,0,102,0],[100,1,101,1],[121,0,123,0],[121,1,122,1],[124,0,126,0],[124,1,125,1],[127,0,129,0],[127,1,128,1],[112,0,114,0],[112,1,113,1],[115,0,117,0],[115,1,116,1],[118,0,120,0],[118,1,119,1],[139,0,141,0],[139,1,140,1],[142,0,144,0],[142,1,143,1],[145,0,147,0],[145,1,146,1],[130,0,132,0],[130,1,131,1],[133,0,135,0],[133,1,134,1],[136,0,138,0],[136,1,137,1],[172,1,173,1],[157,0,159,0],[157,1,158,1],[160,0,162,0],[160,1,161,1],[163,0,165,0],[163,1,164,1],[148,0,150,0],[148,1,149,1],[151,0,153,0],[151,1,152,1],[154,0,156,0],[154,1,155,1],[193,0,195,0],[193,1,194,1],[196,0,198,0],[196,1,197,1],[199,1,200,1],[199,0,200,0],[61,18,62,20],[184,0,186,0],[184,1,185,1],[187,0,189,0],[187,1,188,1],[190,0,192,0],[190,1,191,1],[175,0,177,0],[175,1,176,1],[178,0,180,0],[178,1,179,1],[181,0,183,0],[181,1,182,1],[166,0,168,0],[166,1,167,1],[169,0,171,0],[169,1,170,1],[172,0,174,0]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Tracking Form"]
[null,"The last row shown is the most current estimate of the cost of service data reflecting the original application and any updates provided by the applicant distributor (for updated evidence, responses to interrogatories, undertakings, etc.)\nPlease ensure a Reference (Column B) and/or Item Description (Column C) is entered.  Please note that unused rows will automatically be hidden and the PRINT AREA set when the PRINT BUTTON on Sheet 1 is activated.\n(1) Short reference to evidence material (interrogatory response, undertaking, exhibit number, Board Decision, Code, Guideline, Report of the Board, etc.)\n(2) Short description of change, issue, etc.\n\n60 Tracking Rows have been provided below.  If you require more, please contact Industry Relations @ IndustryRelations@ontarioenergyboard.ca. "]
[null,"Summary of Proposed Changes - 2017"]
[]
[null,null,null,"Cost of Capital",null,"Rate Base and Capital Expenditures",null,null,"Operating Expenses",null,null,"Revenue Requirement"]
[null,"Reference (1)","Item / Description (2)","Regulated Return on Capital","Regulated Rate of Return","Rate Base","Working Capital","Working Capital Allowance ($)","Amortization / Depreciation","Taxes / PILs","OM&A","Service Revenue Requirement","Other Revenues","Base Revenue Requirement","Grossed up Revenue Deficiency / Sufficiency"]
[]
[null,null,"Original Application",7652.7502737866052,6.383113384770786E-2,119890.55829785187,136473.42721163062,17741.545537511982,5000.9720499314644,482.02039737109214,12690.387638452215,26022.430465122819,1631.1917441093049,24391.238721013513,440.55560476370971]
[]
[1,"Multiple Interrogatories","2014 Actuals Updated",7683.9893517927449,6.3815232664906463E-2,120409.95591352526,136473.42721163062,17741.545537511982,4999.6057172939627,483.53992843543102,12690.387638452215,26053.822741555796,1630.3067441093049,24423.515997446491,627.87037644622126,null,{"$f":"IF(AND(ISBLANK(B23), ISBLANK(C23)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D23=\"\",\"\",D23-D21)","v":31.239078006139607},{"$f":"IF(E23=\"\",\"\",E23-E21)","v":-1.590118280139774E-5},519.39761567339883,0,0,-1.3663326375017277,1.519531064338878,0,31.39227643297636,-0.88499999999999091,32.277276432978397,187.31477168251155]
[]
[2,"4-Energy Probe-50 & 54","Tax Updates (CCA Class 10 to 50, Adjusted Tax Credits)",7684.1117561870524,6.3816249228639738E-2,120409.95591352526,136473.42721163062,17741.545537511982,4999.6057172939627,416.30372192346363,12690.387638452215,25986.708939438136,1630.3067441093049,24356.402195328832,663.16249179783495,null,{"$f":"IF(AND(ISBLANK(B26), ISBLANK(C26)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D26=\"\",\"\",D26-D23)","v":0.12240439430752303},{"$f":"IF(E26=\"\",\"\",E26-E23)","v":1.0165637332748556E-6},0,0,0,0,-67.236206511967396,0,-67.113802117659361,0,-67.113802117659361,35.292115351613688]
[]
[3,"4.0-Staff-31","Updated Post-Retirement Benefits Actuarial Valuation",7683.2893937478857,6.3802711041016549E-2,120422.61634946147,136570.81518037064,17754.205973448185,4999.6057172939627,492.67249808016669,12787.775607192216,26159.64332189567,1630.3067441093049,24529.336577786366,690.4692085916771,null,{"$f":"IF(AND(ISBLANK(B29), ISBLANK(C29)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D29=\"\",\"\",D29-D26)","v":-0.82236243916668172},{"$f":"IF(E29=\"\",\"\",E29-E26)","v":-1.3538187623188258E-5},12.660435936209979,97.38796874001855,12.660435936202703,0,76.368776156703063,97.38796874000036,172.9343824575335,0,172.9343824575335,27.306716793842156]
[]
[4,"3.0-Staff-25; 3.0-Energy Probe-33/34; 3.0-VECC-26/27/31;1.0-CCC-17; ","Updated Load Forecast",7688.1585332738741,6.380376941352997E-2,120496.93308000003,137142.48233835955,17828.522703986742,4999.6057172939627,493.663374307504,12787.775607192216,26165.503337648999,1627.8906667777319,24537.612670871269,664.46359555975823,null,{"$f":"IF(AND(ISBLANK(B32), ISBLANK(C32)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D32=\"\",\"\",D32-D29)","v":4.8691395259884303},{"$f":"IF(E32=\"\",\"\",E32-E29)","v":1.058372513421113E-6},74.316730538557749,571.667157988908,74.316730538557749,0,0.99087622733730996,0,5.8600157533292077,-2.4160773315729784,8.2760930849035503,-26.00561303191887]
[]
[5,"2.0-Staff-6 & Multiple Others","DSP/Capital Updates to capacity solutions (HONI TS contributions & new MS9 substation) and changes to timing of In Service dates",7600.3435086596983,6.3787320683998838E-2,119151.32078225473,137142.48233835955,17828.522703986742,4934.6848832298865,485.26141829981083,12787.775607192216,26004.365522963053,1627.8906667777319,24376.474856185319,542.52924236118952,null,{"$f":"IF(AND(ISBLANK(B35), ISBLANK(C35)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D35=\"\",\"\",D35-D32)","v":-87.815024614175854},{"$f":"IF(E35=\"\",\"\",E35-E32)","v":-1.6448729531132189E-5},-1345.6122977453051,0,0,-64.920834064076189,-8.4019560076931725,0,-161.13781468594607,0,-161.13781468594971,-121.93435319856872]
[]
[6,"Undertaking TC2.5","Adjustment for CDM Activities",7606.7102340482361,6.3786863136636882E-2,119251.98794858457,137916.84515628152,17929.189870316597,4934.6848832298865,486.60344833132024,12787.775607192216,26012.074278383097,1627.8906667777319,24384.183611605367,516.56580929468726,null,{"$f":"IF(AND(ISBLANK(B38), ISBLANK(C38)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D38=\"\",\"\",D38-D35)","v":6.3667253885378159},{"$f":"IF(E38=\"\",\"\",E38-E35)","v":-4.5754736195668944E-7},100.66716632984753,774.36281792196678,100.66716632985481,0,1.3420300315094096,0,7.7087554200443265,0,7.7087554200479644,-25.963433066502262]
[]
[7,"Update June 2015","Revised Working Capital Proposal (to 10.91% from 13.0%)",7424.3341281574958,6.3799642317921346E-2,116369.5258848183,137916.84515628152,15046.727806550314,4934.6848832298865,448.19063063317282,12787.775607192216,25791.285354794214,1627.8906667777319,24163.39468801648,540.24062428204172,null,{"$f":"IF(AND(ISBLANK(B41), ISBLANK(C41)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D41=\"\",\"\",D41-D38)","v":-182.37610589074029},{"$f":"IF(E41=\"\",\"\",E41-E38)","v":1.2779181284464092E-5},-2882.4620637662738,0,-2882.4620637662829,0,-38.412817698147421,0,-220.78892358888334,0,-220.78892358888697,23.674814987354466]
[]
[8,"Update June 2015","Revised Load Forecast",7426.9318702734463,6.3799793317196901E-2,116409.96755817947,138287.52960505497,15087.169479911498,4934.6848832298865,448.72935459132918,12787.775607192216,25794.42182086832,1581.0022186420572,24213.419602226262,507.33245173850224,null,{"$f":"IF(AND(ISBLANK(B44), ISBLANK(C44)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D44=\"\",\"\",D44-D41)","v":2.5977421159504956},{"$f":"IF(E44=\"\",\"\",E44-E41)","v":1.5099927555550785E-7},40.441673361172434,370.68444877344882,40.441673361183348,0,0.53872395815636764,0,3.1364660741055559,-46.888448135674707,50.024914209781855,-32.908172543539479]
[]
[9,"Update June 2015","Move MS9 Land to WIP in 2015 ($158.7k), Added back to Land 2018",7416.8731419630831,6.3800376246735249E-2,116251.24455817945,138287.52960505497,15087.169479911498,4934.6848832298865,446.61504173678958,12787.775607192216,25782.248779703419,1581.0022186420572,24201.246561061362,498.39138083314714,null,{"$f":"IF(AND(ISBLANK(B47), ISBLANK(C47)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D47=\"\",\"\",D47-D44)","v":-10.058728310363222},{"$f":"IF(E47=\"\",\"\",E47-E44)","v":5.8292953834804262E-7},-158.72300000002724,0,0,0,-2.1143128545396053,0,-12.173041164900496,0,-12.173041164900496,-8.9410709053551045]
[]
[10,"Update June 2015","Update Regulatory Expenses (higher rate application costs partially offset by lower forecast OEB assessment fees)",7417.1374452551117,6.3800467345809214E-2,116255.22122044946,138323.97930505496,15091.146142181497,4934.6848832298865,446.66801270160437,12824.225307192217,25819.015753960262,1581.0022186420572,24238.013535318205,512.08294517588263,null,{"$f":"IF(AND(ISBLANK(B50), ISBLANK(C50)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D50=\"\",\"\",D50-D47)","v":0.26430329202867142},{"$f":"IF(E50=\"\",\"\",E50-E47)","v":9.1099073964984179E-8},3.9766622700117296,36.449699999997392,3.9766622699989966,0,5.2970964814790023E-2,36.44970000000103,36.766974256843241,0,36.766974256843241,13.691564342735489]
[]
[11,"Update June 2015","Update Interest Rates for 2015 Loan ($15m loan drawn June 2015 at 2.71%)",7002.5957669908275,6.0234677578154747E-2,116255.22122044946,138323.97930505496,15091.146142181497,4934.6848832298865,446.66801270160437,12824.225307192217,25404.474075695976,1581.0022186420572,23823.471857053919,389.86328650739904,null,{"$f":"IF(AND(ISBLANK(B53), ISBLANK(C53)), \"X\", \"\")","v":""},null,"Numbers going into Oral Hearing 30 June 2015"]
[null,null,"          Change",{"$f":"IF(D53=\"\",\"\",D53-D50)","v":-414.5416782642842},{"$f":"IF(E53=\"\",\"\",E53-E50)","v":-3.5657897676544675E-3},0,0,0,0,0,0,-414.54167826428602,0,-414.54167826428602,-122.21965866848359]
[]
[12,"Oral Hearing J2.12","Correct 2015 weighted debt rate - to 4.11% from 4.24%",7002.5957669908275,6.0234677578154747E-2,116255.22122044946,138323.97930505496,15091.146142181497,4934.6848832298865,446.66801270160437,12824.225307192217,25404.474075695976,1581.0022186420572,23823.471857053919,392.45241638793493,null,{"$f":"IF(AND(ISBLANK(B56), ISBLANK(C56)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D56=\"\",\"\",D56-D53)","v":0},{"$f":"IF(E56=\"\",\"\",E56-E53)","v":0},0,0,0,0,0,0,0,0,0,2.5891298805358929]
[]
[13,"Oral Hearing J3.2","Correct Other Revenue for 2016-2019",7002.5957669908275,6.0234677578154747E-2,116255.22122044946,138323.97930505496,15091.146142181497,4934.6848832298865,446.66801270160437,12824.225307192217,25404.474075695976,1609.7229145006972,23794.75116119528,375.65265312937413,null,{"$f":"IF(AND(ISBLANK(B59), ISBLANK(C59)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D59=\"\",\"\",D59-D56)","v":0},{"$f":"IF(E59=\"\",\"\",E59-E56)","v":0},0,0,0,0,0,0,0,28.720695858640056,-28.720695858639374,-16.799763258560802]
[]
[14,"Oral Hearing J1.1","Reduce cost of power expense lead to 20.89 from 22.64 ",6928.4418543673974,6.0234677578154747E-2,115024.13780463446,138323.97930505496,13860.062726366506,4934.6848832298865,430.27257135742173,12824.225307192217,25313.924721728363,1609.7229145006972,23704.201807227666,402.79120959525704,null,{"$f":"IF(AND(ISBLANK(B62), ISBLANK(C62)), \"X\", \"\")","v":""},null,"At end of Oral Hearing, filed 8 July 2015, Exhibit K4.1"]
[null,null,"          Change",{"$f":"IF(D62=\"\",\"\",D62-D59)","v":-74.153912623430188},{"$f":"IF(E62=\"\",\"\",E62-E59)","v":0},-1231.0834158149955,0,-1231.0834158149901,0,-16.395441344182643,0,-90.54935396761357,0,-90.54935396761357,27.138556465882914]
[]
[15,"Board Decision","Working Cap Allowance to 9.37%",6879.4190216412098,6.0279667876098647E-2,114125.03193915161,138323.97930505496,12960.956860883651,4934.6848832298865,418.30256909435667,12824.225307192217,25252.931886739112,1609.7229145006972,23643.208972238415,381.73675156538587,null,{"$f":"IF(AND(ISBLANK(B65), ISBLANK(C65)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D65=\"\",\"\",D65-D62)","v":-49.022832726187517},{"$f":"IF(E65=\"\",\"\",E65-E62)","v":4.4990297943900415E-5},-899.1058654828521,0,-899.10586548285573,0,-11.970002263065055,0,-60.992834989250696,0,-60.992834989250696,-21.054458029871171]
[]
[16,"Board Decision","Update Cost of Capital with 2016 OEB parameters for 2016-2019 ",6726.8154227614032,5.8942506376234438E-2,114125.03193915161,138323.97930505496,12960.956860883651,4934.6848832298865,400.3387009830729,12824.225307192217,25082.364419748021,1609.7229145006972,23472.641505247324,368.94776486016679,null,{"$f":"IF(AND(ISBLANK(B68), ISBLANK(C68)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D68=\"\",\"\",D68-D65)","v":-152.60359887980667},{"$f":"IF(E68=\"\",\"\",E68-E65)","v":-1.337161499864209E-3},0,0,0,0,-17.963868111283773,0,-170.56746699109135,0,-170.56746699109135,-12.788986705219088]
[]
[17,"Board Decision","Reduce Capital Budget by $400k in 2015, 2016 & 2017 to match new connection costs with 1.5% customer growth",6660.654634406179,5.8861787813483994E-2,113157.53193755972,138323.97930505496,12960.956860883651,4909.6848700062847,405.49533106719895,12824.225307192217,24996.360248253321,1609.7229145006972,23386.637333752624,374.36671226523322,null,{"$f":"IF(AND(ISBLANK(B71), ISBLANK(C71)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D71=\"\",\"\",D71-D68)","v":-66.160788355224213},{"$f":"IF(E71=\"\",\"\",E71-E68)","v":-8.0718562750443923E-5},-967.50000159189221,0,0,-25.000013223601854,5.15663008412605,0,-86.004171494700131,0,-86.004171494700131,5.418947405066433]
[]
[18,"Board Decision","Move HONI Enfield TS contributions from capital in 2015 ($1.35m) and 2018 ($5.4m), adding back in 2018. ",6432.1063098786708,5.8903403727294953E-2,109197.53193987548,138323.97930505496,12960.956860883651,4819.6848633515337,432.62476162352823,12824.225307192217,24704.941347627388,1609.7229145006972,23095.218433126691,147.51041426624857]
[null,null,"          Change",{"$f":"IF(D74=\"\",\"\",D74-D71)","v":-228.54832452750816},{"$f":"IF(E74=\"\",\"\",E74-E71)","v":4.1615913810959249E-5},-3959.9999976842373,0,0,-90.000006654750905,27.129430556329282,0,-291.41890062593302,0,-291.41890062593302,-226.85629799898464]
[]
[19,"Board Decision","Adjust Rate Base for Depreciation Expense Deferral Account",{"$f":"IF($C77=\"\",\"\",'7. Cost_of_Capital'!$P$58)","v":6393.505144283723},{"$f":"IF($C77=\"\",\"\",'7. Cost_of_Capital'!$L$58)","v":5.8906273933128292E-2},{"$f":"IF($C77=\"\",\"\",'4. Rate_Base'!$W$18)","v":108536.9132588792},{"$f":"IF($C77=\"\",\"\",'4. Rate_Base'!$W$26)","v":133910.31141822154},{"$f":"IF($C77=\"\",\"\",'4. Rate_Base'!$W$30)","v":12547.396179887359},{"$f":"IF($C77=\"\",\"\",'9. Rev_Reqt'!$N$16)","v":4819.6848633515337},{"$f":"IF($C77=\"\",\"\",'9. Rev_Reqt'!$N$19)","v":423.93293545647953},{"$f":"IF($C77=\"\",\"\",'9. Rev_Reqt'!$N$15)","v":12824.225307192217},{"$f":"IF($C77=\"\",\"\",'9. Rev_Reqt'!$N$25)","v":24657.648355865396},{"$f":"IF($C77=\"\",\"\",'9. Rev_Reqt'!$N$32)","v":1578.6491781861791},{"$f":"IF($C77=\"\",\"\",'9. Rev_Reqt'!$N$28)","v":23078.999177679216},{"$f":"IF($C77=\"\",\"\",'8. Rev_Def_Suff'!$N$52)","v":488.63256210796197}]
[null,null,"          Change",{"$f":"IF(D77=\"\",\"\",D77-D74)","v":-38.601165594947815},{"$f":"IF(E77=\"\",\"\",E77-E74)","v":2.8702058333385239E-6},-660.61868099628191,-4413.6678868334275,-413.56068099629192,0,-8.6918261670487027,0,-47.292991761991289,-31.073736314518101,-16.219255447475007,341.1221478417134]
[]
[20]
[null,null,"          Change"]
[]
[21]
[null,null,"          Change"]
[]
[22]
[null,null,"          Change"]
[]
[23]
[null,null,"          Change"]
[]
[24]
[null,null,"          Change"]
[]
[25]
[null,null,"          Change"]
[]
[26]
[null,null,"          Change"]
[]
[27]
[null,null,"          Change"]
[]
[28]
[null,null,"          Change"]
[]
[29]
[null,null,"          Change"]
[]
[30]
[null,null,"          Change"]
[]
[31]
[null,null,"          Change"]
[]
[32]
[null,null,"          Change"]
[]
[33]
[null,null,"          Change"]
[]
[34]
[null,null,"          Change"]
[]
[35]
[null,null,"          Change"]
[]
[36]
[null,null,"          Change"]
[]
[37]
[null,null,"          Change"]
[]
[38]
[null,null,"          Change"]
[]
[39]
[null,null,"          Change"]
[]
[40]
[null,null,"          Change"]
[]
[41]
[null,null,"          Change"]
[]
[42]
[null,null,"          Change"]
[]
[43]
[null,null,"          Change"]
[]
[44]
[null,null,"          Change"]
[]
[45]
[null,null,"          Change"]
[]
[46]
[null,null,"          Change"]
[]
[47]
[null,null,"          Change"]
[]
[48]
[null,null,"          Change"]
[]
[49]
[null,null,"          Change"]
[]
[50]
[null,null,"          Change"]
[]
[51]
[null,null,"          Change"]
[]
[52]
[null,null,"          Change"]
[]
[53]
[null,null,"          Change"]
[]
[54]
[null,null,"          Change"]
[]
[55]
[null,null,"          Change"]
[]
[56]
[null,null,"          Change"]
[]
[57]
[null,null,"          Change"]
[]
[58]
[null,null,"          Change"]
[]
[59]
[null,null,"          Change"]
[]
[60]
[null,null,"          Change"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page Break 4"]

{"sheet":"Not part of Model ==>","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Data","index":11,"n_rows":54,"n_cols":6,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[null,"LINKED DIRECTLY TO \"Data for OEB RRWF' TAB in MASTER WORKING FILE - NO ACTION REQUIRED"]
[]
[]
[null,"Rate Base"]
[null,"   Gross Fixed Assets (average)",187352.92379013245]
[null,"   Accumulated Depreciation (average)",-91363.406711140618]
[null,"Allowance for Working Capital:"]
[null,"   Controllable Expenses",13020.525412773661]
[null,"   Cost of Power",120889.78600544788]
[null,"   Working Capital Rate (%)",9.3700000000000006E-2]
[]
[null,"Utility Income"]
[null,"Operating Revenues:",null,null,null,"Deficiency"]
[null,"   Distribution Revenue at Current Rates",22590.366615571253,null,null,{"$f":"C15-C14","v":488.63256210796317}]
[null,"   Distribution Revenue at Proposed Rates",23078.999177679216]
[null,"   Other Revenue:"]
[null,"      Specific Service Charges",988.76817158960614]
[null,"      Late Payment Charges",296.97137025786026]
[null,"      Other Distribution Revenue",164.90963633871272]
[null,"      Other Income and Deductions",128]
[]
[null,"Total Revenue Offsets",1578.6491781861791]
[]
[null,"Operating Expenses:"]
[null,"   OM+A Expenses",12824.225307192217]
[null,"   Depreciation/Amortization",4819.6848633515337]
[null,"   Property taxes",165.00737199945598]
[null,"   Capital taxes"]
[null,"   Other expenses",31.292733581986994]
[]
[null,"Taxes/PILs"]
[null,"Taxable Income:"]
[null,"Adjustments required to arrive at taxable income",-2419.8485092103365]
[null,"Utility Income Taxes and Rates:"]
[null,"   Income taxes (not grossed up)",321.04163187930641]
[null,"   Income taxes (grossed up)",423.93293545647953]
[null,"   Capital Taxes"]
[null,"   Federal tax (%)",0.15000000000000002]
[null,"   Provincial tax (%)",9.2706557975691536E-2]
[null,"Income Tax Credits",-60]
[null,"   "]
[null,"Capitalization/Cost of Capital"]
[null,"Capital Structure:"]
[null,"   Long-term debt Capitalization Ratio (%)",0.56000000000000005]
[null,"   Short-term debt Capitalization Ratio (%)",0.04]
[null,"   Common Equity Capitalization Ratio (%)",0.39999999999999991]
[null,"   Prefered Shares Capitalization Ratio (%)",0]
[null,null,1]
[]
[null,"Cost of Capital"]
[null,"   Long-term debt Cost Rate (%)",3.8368346309157683E-2]
[null,"   Short-term debt Cost Rate (%)",1.6500000000000001E-2]
[null,"   Common Equity Cost Rate (%)",9.1899999999999996E-2]
[null,"   Prefered Shares Cost Rate (%)"]