{"text_format":"1","workbook":"xlsx","n_sheets":9,"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"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":2,"defined_names":12,"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":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version",4]
[]
[]
[]
[]
[null,null,null,null,null,"Utility Name   ","Horizon Utilities Corporation"]
[]
[null,null,null,null,null,"Service Territory","Hamilton & St Catharines"]
[]
[null,null,null,null,null,"Assigned EB Number","EB-2014-0002",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","Indy Butany-DeSouza, VP Regulatory Affairs",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-317-4765",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   ","indy.butany@horizonutilities.com",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":[[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],[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]]}
[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":""},null,null,null,null,null,"(6)",null,{"$f":"IF(ISBLANK(M12),\"\",\"Adjustments\")","v":""},null,null,null,"Per Board Decision"]
[]
[]
[null,1,"Rate Base"]
[null,null,"   Gross Fixed Assets (average)",null,535997407.02115536,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E16),0,E16+I16)","v":535997407.02115536},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E16),\"\",E16+I16+Q16)","v":535997407.02115536}]
[null,null,"   Accumulated Depreciation (average)",null,-110984931.93609791,null,"(5)",null,null,null,null,null,{"$f":"IF(ISBLANK(E17),0,E17+I17)","v":-110984931.93609791},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E17),\"\",E17+I17+Q17)","v":-110984931.93609791}]
[null,null,"Allowance for Working Capital:"]
[null,null,"   Controllable Expenses",null,64394130.706022486,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E19),0,E19+I19)","v":64394130.706022486},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E19),\"\",E19+I19+Q19)","v":64394130.706022486}]
[null,null,"   Cost of Power",null,541395014.58398044,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E20),0,E20+I20)","v":541395014.58398044},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E20),\"\",E20+I20+Q20)","v":541395014.58398044}]
[null,null,"   Working Capital Rate (%)",null,0.127,null,"(9)",null,null,null,null,null,{"$f":"IF(ISBLANK(E21),0,E21)","v":0.127},null,"(9)",null,null,null,null,null,{"$f":"IF(ISBLANK(M21),IF(ISBLANK(E21),0,E21),M21)","v":0.127},null,"(9)"]
[]
[null,2,"Utility Income"]
[null,null,"Operating Revenues:"]
[null,null,"   Distribution Revenue at Current Rates",null,113328920.06621931,null,null,null,{"$f":"IF(ISBLANK(M25),\"\",IF(ISBLANK(E25),\"\",M25-E25))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U25),\"\",IF(ISBLANK(M25),\"\",U25-M25))","v":""}]
[null,null,"   Distribution Revenue at Proposed Rates",null,118628500.58247563,null,null,null,{"$f":"IF(ISBLANK(M26),\"\",IF(ISBLANK(E26),\"\",M26-E26))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U26),\"\",IF(ISBLANK(M26),\"\",U26-M26))","v":""}]
[null,null,"   Other Revenue:"]
[null,null,"      Specific Service Charges",null,735334.68,null,null,null,{"$f":"IF(ISBLANK(M28),\"\",IF(ISBLANK(E28),\"\",M28-E28))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U28),\"\",IF(ISBLANK(M28),\"\",U28-M28))","v":""}]
[null,null,"      Late Payment Charges",null,825000,null,null,null,{"$f":"IF(ISBLANK(M29),\"\",IF(ISBLANK(E29),\"\",M29-E29))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U29),\"\",IF(ISBLANK(M29),\"\",U29-M29))","v":""}]
[null,null,"      Other Distribution Revenue",null,null,null,null,null,{"$f":"IF(ISBLANK(M30),\"\",IF(ISBLANK(E30),\"\",M30-E30))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U30),\"\",IF(ISBLANK(M30),\"\",U30-M30))","v":""}]
[null,null,"      Other Income and Deductions",null,3956174.56,null,null,null,{"$f":"IF(ISBLANK(M31),\"\",IF(ISBLANK(E31),\"\",M31-E31))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U31),\"\",IF(ISBLANK(M31),\"\",U31-M31))","v":""}]
[]
[null,null,null,"Total Revenue Offsets",5516509.2400000002,null,"(7)",null,{"$f":"IF(ISBLANK(M33),\"\",IF(ISBLANK(E33),\"\",M33-E33))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U33),\"\",IF(ISBLANK(M33),\"\",U33-M33))","v":""}]
[]
[null,null,"Operating Expenses:"]
[null,null,"   OM+A Expenses",null,64089437.490003996,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E36),\"\",E36+I36)","v":64089437.490003996},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E36),\"\",E36+I36+Q36)","v":64089437.490003996}]
[null,null,"   Depreciation/Amortization",null,26487624.058676168,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E37),\"\",E37+I37)","v":26487624.058676168},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E37),\"\",E37+I37+Q37)","v":26487624.058676168}]
[null,null,"   Property taxes",null,304693.21601849998,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E38),\"\",E38+I38)","v":304693.21601849998},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E38),\"\",E38+I38+Q38)","v":304693.21601849998}]
[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,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E40),\"\",E40+I40)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E40),\"\",E40+I40+Q40)","v":""}]
[]
[null,3,"Taxes/PILs"]
[null,null,"Taxable Income:"]
[null,null,null,"Adjustments required to arrive at taxable income",-6329306.3325322717,null,"(3)"]
[null,null,"Utility Income Taxes and Rates:"]
[null,null,"   Income taxes (not grossed up)",null,3164564.9434881494]
[null,null,"   Income taxes (grossed up)",null,{"$f":"IF(ISBLANK(E46),\"\",E46/(1-SUM(E49:E50)))","v":4289143.2424794603},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(M46),\"\",M46/(1-SUM(M49:M50)))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U46),\"\",U46/(1-SUM(U49:U50)))","v":""}]
[null,null,"   Capital Taxes"]
[null,null,"   Federal tax (%)",null,0.15]
[null,null,"   Provincial tax (%)",null,0.11219182606296371]
[null,null,"Income Tax Credits",null,-103293.1443511851]
[null,null,"   "]
[null,4,"Capitalization/Cost of Capital"]
[null,null,"Capital Structure:"]
[null,null,"   Long-term debt Capitalization Ratio (%)",null,0.56000000000000005]
[null,null,"   Short-term debt Capitalization Ratio (%)",null,0.04,null,"(8)",null,null,null,null,null,null,null,"(8)",null,null,null,null,null,null,null,"(8)"]
[null,null,"   Common Equity Capitalization Ratio (%)",null,0.4]
[null,null,"   Prefered Shares Capitalization Ratio (%)",null,0]
[null,null,null,null,{"$f":"SUM(E55:E58)","v":1},null,null,null,null,null,null,null,{"$f":"SUM(M55:M58)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(U55:U58)","v":0}]
[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,3.4713157894736842E-2]
[null,null,"   Short-term debt Cost Rate (%)",null,2.1100000000000001E-2]
[null,null,"   Common Equity Cost Rate (%)",null,9.3600000000000003E-2]
[null,null,"   Prefered Shares Cost Rate (%)",null,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":[[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],[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]]}
[]
[]
[]
[]
[]
[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":""},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M12),\" \",'3. Data_Input_Sheet'!M12)","v":" "},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!Q12),\"\",'3. Data_Input_Sheet'!Q12)","v":""},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":535997407.02115536},null,null,null,{"$f":"'3. Data_Input_Sheet'!I16","v":0},null,null,null,{"$f":"G13+K13","v":535997407.02115536},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q16","v":0},null,null,null,{"$f":"G13+K13+S13","v":535997407.02115536}]
[null,2,null,"Accumulated Depreciation (average)","(3)",null,{"$f":"'3. Data_Input_Sheet'!E17","v":-110984931.93609791},null,null,null,{"$f":"'3. Data_Input_Sheet'!I17","v":0},null,null,null,{"$f":"G14+K14","v":-110984931.93609791},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q17","v":0},null,null,null,{"$f":"G14+K14+S14","v":-110984931.93609791}]
[null,3,null,"Net Fixed Assets (average)","(3)",null,{"$f":"SUM(G13:G14)","v":425012475.08505744},null,null,null,{"$f":"SUM(K13:K14)","v":0},null,null,null,{"$f":"SUM(O13:O14)","v":425012475.08505744},null,null,null,{"$f":"SUM(S13:S14)","v":0},null,null,null,{"$f":"SUM(W13:W14)","v":425012475.08505744}]
[]
[null,4,null,"Allowance for Working Capital","(1)",null,{"$f":"G30","v":76935221.451830372},null,null,null,{"$f":"K30","v":0},null,null,null,{"$f":"O30","v":76935221.451830372},null,null,null,{"$f":"S30","v":0},null,null,null,{"$f":"W30","v":76935221.451830372}]
[null,null,null,"Total Rate Base",null,null,{"$f":"G17+G15","v":501947696.53688782},null,null,null,{"$f":"K17+K15","v":0},null,null,null,{"$f":"O17+O15","v":501947696.53688782},null,null,null,{"$f":"S17+S15","v":0},null,null,null,{"$f":"W15+W17","v":501947696.53688782}]
[null,5]
[null,null,"(1)","Allowance for Working Capital - Derivation"]
[]
[]
[]
[null,6,null,"Controllable Expenses",null,null,{"$f":"'3. Data_Input_Sheet'!E19","v":64394130.706022486},null,null,null,{"$f":"'3. Data_Input_Sheet'!I19","v":0},null,null,null,{"$f":"G24+K24","v":64394130.706022486},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q19","v":0},null,null,null,{"$f":"G24+K24+S24","v":64394130.706022486}]
[null,7,null,"Cost of Power",null,null,{"$f":"'3. Data_Input_Sheet'!E20","v":541395014.58398044},null,null,null,{"$f":"'3. Data_Input_Sheet'!I20","v":0},null,null,null,{"$f":"G25+K25","v":541395014.58398044},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q20","v":0},null,null,null,{"$f":"G25+K25+S25","v":541395014.58398044}]
[null,8,null,"Working Capital Base",null,null,{"$f":"SUM(G24:G25)","v":605789145.29000294},null,null,null,{"$f":"K24+K25","v":0},null,null,null,{"$f":"SUM(O24:O25)","v":605789145.29000294},null,null,null,{"$f":"S24+S25","v":0},null,null,null,{"$f":"SUM(W24:W25)","v":605789145.29000294}]
[]
[null,9,null,"Working Capital Rate % ","(2)",null,{"$f":"'3. Data_Input_Sheet'!E21","v":0.127},null,null,null,{"$f":"O28-G28","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!M21","v":0.127},null,null,null,{"$f":"W28-O28","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!U21","v":0.127}]
[]
[null,10,null,"Working Capital Allowance",null,null,{"$f":"G26*G28","v":76935221.451830372},null,null,null,{"$f":"O30-G30","v":0},null,null,null,{"$f":"O26*O28","v":76935221.451830372},null,null,null,{"$f":"W30-O30","v":0},null,null,null,{"$f":"W26*W28","v":76935221.451830372}]
[]
[]
[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":[[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],[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],[26,9,27,9],[34,21,35,21],[34,5,35,5],[36,21,37,21],[36,5,37,5],[36,17,37,17],[47,9,48,9],[47,13,48,13],[47,17,48,17],[34,9,35,9],[36,9,37,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Utility Income"]
[]
[null,"Line No.",null,"Particulars                                ",null,"Initial Application   ",null,null,null,{"$f":"IF(N13=\"\",\"\",\"Adjustments\")","v":""},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M12),\"\",'3. Data_Input_Sheet'!M12)","v":""},null,null,null,{"$f":"IF(N13=\"\",\"\",\"Adjustments\")","v":""},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":118628500.58247563},null,null,null,{"$f":"N16-F16","v":-118628500.58247563},null,null,null,{"$f":"'3. Data_Input_Sheet'!M26","v":0},null,null,null,{"$f":"V16-N16","v":0},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U26),'5. Utility Income'!N16,'3. Data_Input_Sheet'!U26)","v":0}]
[null,2,null,"Other Revenue","(1)",{"$f":"F48","v":5516509.2400000002},null,null,null,{"$f":"N17-F17","v":-5516509.2400000002},null,null,null,{"$f":"N48","v":0},null,null,null,{"$f":"V17-N17","v":0},null,null,null,{"$f":"V48","v":0}]
[null,null,null,null,null,{"$f":"SUM(F16:F17)","v":124145009.82247563},null,null,null,{"$f":"SUM(J16:J17)","v":-124145009.82247563},null,null,null,{"$f":"SUM(N16:N17)","v":0},null,null,null,{"$f":"SUM(R16:R17)","v":0},null,null,null,{"$f":"SUM(V16:V17)","v":0}]
[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":64089437.490003996},null,null,null,{"$f":"'3. Data_Input_Sheet'!I36","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!M36","v":64089437.490003996},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q36","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!U36","v":64089437.490003996}]
[null,5,null,"Depreciation/Amortization",null,{"$f":"'3. Data_Input_Sheet'!E37","v":26487624.058676168},null,null,null,{"$f":"'3. Data_Input_Sheet'!I37","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!M37","v":26487624.058676168},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q37","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!U37","v":26487624.058676168}]
[null,6,null,"Property taxes",null,{"$f":"'3. Data_Input_Sheet'!E38","v":304693.21601849998},null,null,null,{"$f":"'3. Data_Input_Sheet'!I38","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!M38","v":304693.21601849998},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q38","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!U38","v":304693.21601849998}]
[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":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!I40","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!M40","v":""},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q40","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!U40","v":""}]
[null,null,null,null,null,{"$f":"SUM(F22:F26)","v":90881754.764698654},null,null,null,{"$f":"SUM(J22:J26)","v":0},null,null,null,{"$f":"SUM(N22:N26)","v":90881754.764698654},null,null,null,{"$f":"SUM(R22:R26)","v":0},null,null,null,{"$f":"SUM(V22:V26)","v":90881754.764698654}]
[null,9,null,"Subtotal (lines 4 to 8)"]
[]
[null,10,null,"Deemed Interest Expense",null,{"$f":"'7. Cost_of_Capital'!P19","v":10181190.05695642},null,null,null,{"$f":"N30-F30","v":-10181190.05695642},null,null,null,{"$f":"'7. Cost_of_Capital'!P35","v":0},null,null,null,{"$f":"V30-N30","v":0},null,null,null,{"$f":"'7. Cost_of_Capital'!P51","v":0}]
[]
[null,11,null,"Total Expenses (lines 9 to 10)",null,{"$f":"F27+F30","v":101062944.82165508},null,null,null,{"$f":"J30+J27","v":-10181190.05695642},null,null,null,{"$f":"N30+N27","v":90881754.764698654},null,null,null,{"$f":"R30+R27","v":0},null,null,null,{"$f":"V27+V30","v":90881754.764698654}]
[]
[null,12,null,"Utility income before income taxes",null,{"$f":"F18-(F32)","v":23082065.000820547},null,null,null,{"$f":"J18-(J32)","v":-113963819.7655192},null,null,null,{"$f":"N18-(N32)","v":-90881754.764698654},null,null,null,{"$f":"R18-(R32)","v":0},null,null,null,{"$f":"V18-(V32)","v":-90881754.764698654}]
[null,null,null,null,null,{"$f":"'6. Taxes_PILs'!G31","v":4289143.2424794603},null,null,null,{"$f":"N35-F35","v":0},null,null,null,{"$f":"'6. Taxes_PILs'!K31","v":4289143.2424794603},null,null,null,{"$f":"V35-N35","v":0},null,null,null,{"$f":"IF('6. Taxes_PILs'!O31=0,N35,'6. Taxes_PILs'!O31)","v":4289143.2424794603}]
[null,13,null,"Income taxes (grossed-up)"]
[null,null,null,null,null,{"$f":"F34-F35","v":18792921.758341089},null,null,null,{"$f":"J34-J35","v":-113963819.7655192},null,null,null,{"$f":"N34-N35","v":-95170898.007178113},null,null,null,{"$f":"R34-R35","v":0},null,null,null,{"$f":"V34-V35","v":-95170898.007178113}]
[null,14,null,"Utility net income"]
[]
[]
[]
[null,"Notes"]
[]
[null,"(1)",null,"  Specific Service Charges",null,{"$f":"'3. Data_Input_Sheet'!E28","v":735334.68},null,null,null,{"$f":"'3. Data_Input_Sheet'!I28","v":""},null,null,null,{"$f":"'3. Data_Input_Sheet'!M28","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q28","v":""},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U28),N44,'3. Data_Input_Sheet'!U28)","v":0}]
[null,null,null,"  Late Payment Charges",null,{"$f":"'3. Data_Input_Sheet'!E29","v":825000},null,null,null,{"$f":"'3. Data_Input_Sheet'!I29","v":""},null,null,null,{"$f":"'3. Data_Input_Sheet'!M29","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q29","v":""},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U29),N45,'3. Data_Input_Sheet'!U29)","v":0}]
[null,null,null,"  Other Distribution Revenue",null,{"$f":"'3. Data_Input_Sheet'!E30","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!I30","v":""},null,null,null,{"$f":"'3. Data_Input_Sheet'!M30","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q30","v":""},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U30),N46,'3. Data_Input_Sheet'!U30)","v":0}]
[null,null,null,"  Other Income and Deductions",null,{"$f":"'3. Data_Input_Sheet'!E31","v":3956174.56},null,null,null,{"$f":"'3. Data_Input_Sheet'!I31","v":""},null,null,null,{"$f":"'3. Data_Input_Sheet'!M31","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q31","v":""},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U31),N47,'3. Data_Input_Sheet'!U31)","v":0}]
[null,null,null,null,null,{"$f":"SUM(F44:F47)","v":5516509.2400000002},null,null,null,{"$f":"SUM(J44:J47)","v":0},null,null,null,{"$f":"SUM(N44:N47)","v":0},null,null,null,{"$f":"SUM(R44:R47)","v":0},null,null,null,{"$f":"SUM(V44:V47)","v":0}]
[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":[[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],[44,3,44,14],[51,3,51,14],[52,3,52,14],[45,3,45,14],[49,3,49,14],[50,3,50,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[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":""},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":18792921.758341081},null,null,null,{"$f":"'7. Cost_of_Capital'!P38","v":0},null,null,null,{"$f":"'7. Cost_of_Capital'!P54","v":0}]
[]
[null,2,null,"Adjustments required to arrive at taxable utility income",null,null,{"$f":"'3. Data_Input_Sheet'!E44","v":-6329306.3325322717},null,null,null,{"$f":"'3. Data_Input_Sheet'!M44","v":0},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U44),G18,'3. Data_Input_Sheet'!U44)","v":-6329306.3325322717}]
[]
[null,3,null,"Taxable income",null,null,{"$f":"G16+G18","v":12463615.42580881},null,null,null,{"$f":"K16+K18","v":0},null,null,null,{"$f":"O16+O18","v":-6329306.3325322717}]
[]
[null,null,null,"Calculation of Utility income Taxes"]
[]
[null,4,null,"Income taxes",null,null,{"$f":"'3. Data_Input_Sheet'!E46","v":3164564.9434881494},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M46),'6. Taxes_PILs'!G24,'3. Data_Input_Sheet'!M46)","v":3164564.9434881494},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U46),'6. Taxes_PILs'!K24,'3. Data_Input_Sheet'!U46)","v":3164564.9434881494}]
[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":3164564.9434881494},null,null,null,{"$f":"SUM(K24:K25)","v":3164564.9434881494},null,null,null,{"$f":"SUM(O24:O25)","v":3164564.9434881494}]
[null,6,null,"Total taxes"]
[]
[null,7,null,"Gross-up of Income Taxes",null,null,{"$f":"(G24/(1-G41))-G24","v":1124578.2989913109},null,null,null,{"$f":"(K24/(1-K41))-K24","v":1124578.2989913109},null,null,null,{"$f":"(O24/(1-O41))-O24","v":1124578.2989913109}]
[]
[null,8,null,"Grossed-up Income Taxes",null,null,{"$f":"G24+G29","v":4289143.2424794603},null,null,null,{"$f":"K24+K29","v":4289143.2424794603},null,null,null,{"$f":"O24+O29","v":4289143.2424794603}]
[]
[null,9,null,"PILs / tax Allowance (Grossed-up Income taxes + Capital taxes)",null,null,{"$f":"G26+G29","v":4289143.2424794603},null,null,null,{"$f":"K29+K26","v":4289143.2424794603},null,null,null,{"$f":"O29+O26","v":4289143.2424794603}]
[]
[null,10,null,"Other tax Credits",null,null,{"$f":"'3. Data_Input_Sheet'!E51","v":-103293.1443511851},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M51),G35,'3. Data_Input_Sheet'!M51)","v":-103293.1443511851},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U51),K35,'3. Data_Input_Sheet'!U51)","v":-103293.1443511851}]
[]
[null,null,null,"Tax Rates"]
[]
[null,11,null,"Federal tax (%)",null,null,{"$f":"'3. Data_Input_Sheet'!E49","v":0.15},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M49),G39,'3. Data_Input_Sheet'!M49)","v":0.15},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U49),K39,'3. Data_Input_Sheet'!U49)","v":0.15}]
[null,12,null,"Provincial tax (%)",null,null,{"$f":"'3. Data_Input_Sheet'!E50","v":0.11219182606296371},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M50),G40,'3. Data_Input_Sheet'!M50)","v":0.11219182606296371},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U50),K40,'3. Data_Input_Sheet'!U50)","v":0.11219182606296371}]
[null,13,null,"Total tax rate (%)",null,null,{"$f":"G39+G40","v":0.26219182606296371},null,null,null,{"$f":"K39+K40","v":0.26219182606296371},null,null,null,{"$f":"O39+O40","v":0.26219182606296371}]
[]
[]
[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":[[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],[67,3,67,15],[65,3,65,15],[61,3,61,15],[62,3,62,15],[63,3,63,15],[64,3,64,15],[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]]}
[]
[]
[]
[]
[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":281090710.0606572},null,{"$f":"'3. Data_Input_Sheet'!E62","v":3.4713157894736842E-2},null,null,null,{"$f":"L17*J17","v":9757546.2010792866}]
[null,2,null,"  Short-term Debt",null,{"$f":"'3. Data_Input_Sheet'!E56","v":0.04},null,null,null,{"$f":"$J$26*F18","v":20077907.861475512},null,{"$f":"'3. Data_Input_Sheet'!E63","v":2.1100000000000001E-2},null,null,null,{"$f":"L18*J18","v":423643.85587713332}]
[null,3,null,"Total Debt",null,{"$f":"SUM(F17:F18)","v":0.60000000000000009},null,null,null,{"$f":"SUM(J17:J18)","v":301168617.92213273},null,{"$f":"IF(F19=0,0,SUMPRODUCT(F17:F18,L17:L18)/F19)","v":3.3805614035087715E-2},null,null,null,{"$f":"SUM(P17:P18)","v":10181190.05695642}]
[]
[null,null,null,"Equity"]
[null,4,null,"  Common Equity",null,{"$f":"'3. Data_Input_Sheet'!E57","v":0.4},null,null,null,{"$f":"$J$26*F22","v":200779078.61475515},null,{"$f":"'3. Data_Input_Sheet'!E64","v":9.3600000000000003E-2},null,null,null,{"$f":"L22*J22","v":18792921.758341081}]
[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.4},null,null,null,{"$f":"SUM(J22:J23)","v":200779078.61475515},null,{"$f":"IF(F24=0,0,SUMPRODUCT(F22:F23,L22:L23)/F24)","v":9.3600000000000003E-2},null,null,null,{"$f":"SUM(P22:P23)","v":18792921.758341081}]
[]
[null,7,null,"Total",null,{"$f":"SUM(F19,F24)","v":1},null,null,null,{"$f":"'4. Rate_Base'!G18","v":501947696.53688782},null,{"$f":"(L19*F19)+(L24*F24)","v":5.7723368421052634E-2},null,null,null,{"$f":"P19+P24","v":28974111.815297499}]
[]
[]
[null,null,null,null,null,{"$f":"'1. Info'!AC1","v":""}]
[]
[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},null,null,null,{"$f":"$J$42*F33","v":0},null,{"$f":"'3. Data_Input_Sheet'!M62","v":0},null,null,null,{"$f":"L33*J33","v":0}]
[null,2,null,"  Short-term Debt",null,{"$f":"'3. Data_Input_Sheet'!M56","v":0},null,null,null,{"$f":"$J$42*F34","v":0},null,{"$f":"'3. Data_Input_Sheet'!M63","v":0},null,null,null,{"$f":"L34*J34","v":0}]
[null,3,null,"Total Debt",null,{"$f":"SUM(F33:F34)","v":0},null,null,null,{"$f":"SUM(J33:J34)","v":0},null,{"$f":"IF(F35=0,0,SUMPRODUCT(F33:F34,L33:L34)/F35)","v":0},null,null,null,{"$f":"SUM(P33:P34)","v":0}]
[]
[null,null,null,"Equity"]
[null,4,null,"  Common Equity",null,{"$f":"'3. Data_Input_Sheet'!M57","v":0},null,null,null,{"$f":"$J$42*F38","v":0},null,{"$f":"'3. Data_Input_Sheet'!M64","v":0},null,null,null,{"$f":"L38*J38","v":0}]
[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},null,null,null,{"$f":"SUM(J38:J39)","v":0},null,{"$f":"IF(F40=0,0,SUMPRODUCT(F38:F39,L38:L39)/F40)","v":0},null,null,null,{"$f":"SUM(P38:P39)","v":0}]
[]
[null,7,null,"Total",null,{"$f":"F35+F40","v":0},null,null,null,{"$f":"'4. Rate_Base'!O18","v":501947696.53688782},null,{"$f":"(L35*F35)+(L40*F40)","v":0},null,null,null,{"$f":"P35+P40","v":0}]
[]
[]
[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},null,null,null,{"$f":"$J$58*F49","v":0},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U62),L17,'3. Data_Input_Sheet'!U62)","v":3.4713157894736842E-2},null,null,null,{"$f":"L49*J49","v":0}]
[null,9,null,"  Short-term Debt",null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U56),F34,'3. Data_Input_Sheet'!U56)","v":0},null,null,null,{"$f":"$J$58*F50","v":0},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U63),L18,'3. Data_Input_Sheet'!U63)","v":2.1100000000000001E-2},null,null,null,{"$f":"L50*J50","v":0}]
[null,10,null,"Total Debt",null,{"$f":"SUM(F49:F50)","v":0},null,null,null,{"$f":"SUM(J49:J50)","v":0},null,{"$f":"IF(F51=0,0,SUMPRODUCT(F49:F50,L49:L50)/F51)","v":0},null,null,null,{"$f":"SUM(P49:P50)","v":0}]
[]
[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},null,null,null,{"$f":"$J$58*F54","v":0},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U64),L22,'3. Data_Input_Sheet'!U64)","v":9.3600000000000003E-2},null,null,null,{"$f":"L54*J54","v":0}]
[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},null,null,null,{"$f":"SUM(J54:J55)","v":0},null,{"$f":"IF(F56=0,0,SUMPRODUCT(F54:F55,L54:L55)/F56)","v":0},null,null,null,{"$f":"SUM(P54:P55)","v":0}]
[]
[null,14,null,"Total",null,{"$f":"F51+F56","v":0},null,null,null,{"$f":"'4. Rate_Base'!W18","v":501947696.53688782},null,{"$f":"(L51*F51)+(L56*F56)","v":0},null,null,null,{"$f":"P51+P56","v":0}]
[]
[]
[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":[[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],[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]]}
[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":""},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":5299580.516256311},null,null,null,{"$f":"J52","v":-24836384.602227587},null,null,null,{"$f":"N52","v":90881754.764698654}]
[null,2,null,"Distribution Revenue",null,{"$f":"'3. Data_Input_Sheet'!E25","v":113328920.06621931},null,{"$f":"'3. Data_Input_Sheet'!E26-H19","v":113328920.06621931},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M25),'3. Data_Input_Sheet'!E25,'3. Data_Input_Sheet'!M25)","v":113328920.06621931},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M26),'3. Data_Input_Sheet'!E26-L19,'3. Data_Input_Sheet'!M26-L19)","v":143464885.18470323},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U25),'3. Data_Input_Sheet'!M25,'3. Data_Input_Sheet'!U25)","v":0},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U26),'3. Data_Input_Sheet'!M26-P19,'3. Data_Input_Sheet'!U26-P19)","v":-90881754.764698654}]
[null,3,null,"Other Operating Revenue Offsets - net",null,{"$f":"'5. Utility Income'!F48","v":5516509.2400000002},null,{"$f":"'5. Utility Income'!F48","v":5516509.2400000002},null,{"$f":"'5. Utility Income'!N48","v":0},null,{"$f":"J21","v":0},null,{"$f":"'5. Utility Income'!V48","v":0},null,{"$f":"'5. Utility Income'!V48","v":0}]
[null,4,null,"Total Revenue",null,{"$f":"SUM(F20:F21)","v":118845429.30621931},null,{"$f":"SUM(H19:H21)","v":124145009.82247563},null,{"$f":"SUM(J20:J21)","v":113328920.06621931},null,{"$f":"SUM(L19:L21)","v":118628500.58247565},null,{"$f":"SUM(N20:N21)","v":0},null,{"$f":"SUM(P19:P21)","v":0}]
[]
[null,5,null,"Operating Expenses",null,{"$f":"'5. Utility Income'!F27","v":90881754.764698654},null,{"$f":"'5. Utility Income'!F27","v":90881754.764698654},null,{"$f":"'5. Utility Income'!N27","v":90881754.764698654},null,{"$f":"'5. Utility Income'!N27","v":90881754.764698654},null,{"$f":"'5. Utility Income'!V27","v":90881754.764698654},null,{"$f":"'5. Utility Income'!V27","v":90881754.764698654}]
[null,6,null,"Deemed Interest Expense",null,{"$f":"'5. Utility Income'!F30","v":10181190.05695642},null,{"$f":"'5. Utility Income'!F30","v":10181190.05695642},null,{"$f":"'5. Utility Income'!N30","v":0},null,{"$f":"'5. Utility Income'!N30","v":0},null,{"$f":"'5. Utility Income'!V30","v":0},null,{"$f":"'5. Utility Income'!V30","v":0}]
[null,8,null,"Total Cost and Expenses",null,{"$f":"SUM(F24:F25)","v":101062944.82165508},null,{"$f":"SUM(H24:H25)","v":101062944.82165508},null,{"$f":"SUM(J24:J25)","v":90881754.764698654},null,{"$f":"SUM(L24:L25)","v":90881754.764698654},null,{"$f":"SUM(N24:N25)","v":90881754.764698654},null,{"$f":"SUM(P24:P25)","v":90881754.764698654}]
[]
[null,9,null,"Utility Income Before Income Taxes",null,{"$f":"F22-F26","v":17782484.48456423},null,{"$f":"H22-H26","v":23082065.000820547},null,{"$f":"J22-J26","v":22447165.301520661},null,{"$f":"L22-L26","v":27746745.817776993},null,{"$f":"N22-N26","v":-90881754.764698654},null,{"$f":"P22-P26","v":-90881754.764698654}]
[null,null,null,"   "]
[null,10,null,"Tax Adjustments to Accounting               Income per 2013 PILs model",null,{"$f":"'3. Data_Input_Sheet'!E44","v":-6329306.3325322717},null,{"$f":"'3. Data_Input_Sheet'!E44","v":-6329306.3325322717},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M44),'3. Data_Input_Sheet'!E44,'3. Data_Input_Sheet'!M44)","v":-6329306.3325322717},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M44),'3. Data_Input_Sheet'!E44,'3. Data_Input_Sheet'!M44)","v":-6329306.3325322717},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U44),'3. Data_Input_Sheet'!M44,'3. Data_Input_Sheet'!U44)","v":0},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U44),'3. Data_Input_Sheet'!M44,'3. Data_Input_Sheet'!U44)","v":0}]
[null,11,null,"Taxable Income",null,{"$f":"SUM(F28:F30)","v":11453178.152031958},null,{"$f":"SUM(H28:H30)","v":16752758.668288276},null,{"$f":"SUM(J28+J30)","v":16117858.968988389},null,{"$f":"L28+L30","v":21417439.485244721},null,{"$f":"SUM(N28+N30)","v":-90881754.764698654},null,{"$f":"P28+P30","v":-90881754.764698654}]
[]
[null,12,null,"Income Tax Rate",null,{"$f":"'6. Taxes_PILs'!G41","v":0.26219182606296371},null,{"$f":"'6. Taxes_PILs'!G41","v":0.26219182606296371},null,{"$f":"'6. Taxes_PILs'!K41","v":0.26219182606296371},null,{"$f":"'6. Taxes_PILs'!K41","v":0.26219182606296371},null,{"$f":"'6. Taxes_PILs'!O41","v":0.26219182606296371},null,{"$f":"'6. Taxes_PILs'!O41","v":0.26219182606296371}]
[null,13,null,"Income Tax on Taxable Income",null,{"$f":"F31*F33","v":3002929.6939056991},null,{"$f":"H31*H33","v":4392436.3868306475},null,{"$f":"J31*J33","v":4225970.8753043832},null,{"$f":"L31*L33","v":5615477.5682293344},null,{"$f":"N31*N33","v":-23828453.237562794},null,{"$f":"P31*P33","v":-23828453.237562794}]
[null,14,null,"Income Tax Credits",null,{"$f":"'3. Data_Input_Sheet'!E51","v":-103293.1443511851},null,{"$f":"'3. Data_Input_Sheet'!E51","v":-103293.1443511851},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M51),'3. Data_Input_Sheet'!E51,'3. Data_Input_Sheet'!M51)","v":-103293.1443511851},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M51),'3. Data_Input_Sheet'!E51,'3. Data_Input_Sheet'!M51)","v":-103293.1443511851},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U51),'3. Data_Input_Sheet'!M51,'3. Data_Input_Sheet'!U51)","v":0},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U51),'3. Data_Input_Sheet'!M51,'3. Data_Input_Sheet'!U51)","v":0}]
[null,15,null,"Utility Net Income ",null,{"$f":"F28-SUM(F34:F35)","v":14882847.935009716},null,{"$f":"'5. Utility Income'!F37","v":18792921.758341089},null,{"$f":"J28-SUM(J34:J35)","v":18324487.570567463},null,{"$f":"'5. Utility Income'!N37","v":-95170898.007178113},null,{"$f":"N28-SUM(N34:N35)","v":-67053301.527135864},null,{"$f":"'5. Utility Income'!V37","v":-95170898.007178113}]
[]
[null,16,null,"Utility Rate Base",null,{"$f":"'4. Rate_Base'!G18","v":501947696.53688782},null,{"$f":"'4. Rate_Base'!G18","v":501947696.53688782},null,{"$f":"'4. Rate_Base'!O18","v":501947696.53688782},null,{"$f":"'4. Rate_Base'!O18","v":501947696.53688782},null,{"$f":"'4. Rate_Base'!W18","v":501947696.53688782},null,{"$f":"'4. Rate_Base'!W18","v":501947696.53688782}]
[]
[null,17,null,"Deemed Equity Portion of Rate Base ",null,{"$f":"'7. Cost_of_Capital'!J24","v":200779078.61475515},null,{"$f":"F40","v":200779078.61475515},null,{"$f":"'7. Cost_of_Capital'!J40","v":0},null,{"$f":"J40","v":0},null,{"$f":"'7. Cost_of_Capital'!J56","v":0},null,{"$f":"N40","v":0}]
[]
[null,18,null,"Income/(Equity Portion of Rate Base)",null,{"$f":"IF(F40=0,0,F36/F40)","v":7.4125491747903574E-2},null,{"$f":"IF(H40=0,0,H36/H40)","v":9.360000000000003E-2},null,{"$f":"IF(J40=0,0,J36/J40)","v":0},null,{"$f":"IF(L40=0,0,L36/L40)","v":0},null,{"$f":"IF(N40=0,0,N36/N40)","v":0},null,{"$f":"IF(P40=0,0,P36/P40)","v":0}]
[null,19,null,"Target Return - Equity on Rate Base",null,{"$f":"'7. Cost_of_Capital'!L24","v":9.3600000000000003E-2},null,{"$f":"'7. Cost_of_Capital'!L24","v":9.3600000000000003E-2},null,{"$f":"'7. Cost_of_Capital'!L40","v":0},null,{"$f":"'7. Cost_of_Capital'!L40","v":0},null,{"$f":"'7. Cost_of_Capital'!L56","v":0},null,{"$f":"'7. Cost_of_Capital'!L56","v":0}]
[null,20,null,"Deficiency/Sufficiency in Return on Equity",null,{"$f":"F42-F43","v":-1.9474508252096429E-2},null,{"$f":"H42-H43","v":0},null,{"$f":"J42-J43","v":0},null,{"$f":"L42-L43","v":0},null,{"$f":"N42-N43","v":0},null,{"$f":"P42-P43","v":0}]
[]
[null,21,null,"Indicated Rate of Return",null,{"$f":"IF(F38=0,0,(F36+F25)/F38)","v":4.9933565120214067E-2},null,{"$f":"IF(H38=0,0,(H36+H25)/H38)","v":5.7723368421052648E-2},null,{"$f":"IF(J38=0,0,(J36+J25)/J38)","v":3.6506766934073995E-2},null,{"$f":"IF(L40=0,0,(L36+L25)/L38)","v":0},null,{"$f":"IF(N38=0,0,(N36+N25)/N38)","v":-0.1335862321707221},null,{"$f":"IF(P40=0,0,(P36+P25)/P38)","v":0}]
[null,22,null,"Requested Rate of Return on Rate Base",null,{"$f":"'7. Cost_of_Capital'!L26","v":5.7723368421052634E-2},null,{"$f":"'7. Cost_of_Capital'!L26","v":5.7723368421052634E-2},null,{"$f":"'7. Cost_of_Capital'!L42","v":0},null,{"$f":"'7. Cost_of_Capital'!L42","v":0},null,{"$f":"'7. Cost_of_Capital'!L58","v":0},null,{"$f":"'7. Cost_of_Capital'!L58","v":0}]
[null,23,null,"Deficiency/Sufficiency in Rate of Return",null,{"$f":"F46-F47","v":-7.7898033008385673E-3},null,{"$f":"H46-H47","v":0},null,{"$f":"J46-J47","v":3.6506766934073995E-2},null,{"$f":"L46-L47","v":0},null,{"$f":"N46-N47","v":-0.1335862321707221},null,{"$f":"P46-P47","v":0}]
[]
[null,24,null,"Target Return on Equity",null,{"$f":"H50","v":18792921.758341081},null,{"$f":"'7. Cost_of_Capital'!P24","v":18792921.758341081},null,{"$f":"L50","v":0},null,{"$f":"'7. Cost_of_Capital'!P40","v":0},null,{"$f":"P50","v":0},null,{"$f":"'7. Cost_of_Capital'!P56","v":0}]
[null,25,null,"Revenue Deficiency/(Sufficiency)",null,{"$f":"F50-F36","v":3910073.8233313654}," ",{"$f":"H38*H48","v":0},null,{"$f":"J50-J36","v":-18324487.570567463},null,{"$f":"L38*L48","v":0},null,{"$f":"N50-N36","v":67053301.527135864},null,{"$f":"P38*P48","v":0}]
[null,26,null,"Gross Revenue Deficiency/(Sufficiency)",null,{"$f":"F51/(1-F33)","v":5299580.516256311},"(1)",null,null,{"$f":"J51/(1-J33)","v":-24836384.602227587},"(1)",null,null,{"$f":"N51/(1-N33)","v":90881754.764698654},"(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":[[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],[12,13,12,14],[7,5,7,14],[41,3,41,16],[32,13,33,14],[34,13,35,14],[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]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":""},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":64089437.490003996},null,null,null,{"$f":"'5. Utility Income'!N22","v":64089437.490003996},null,null,null,{"$f":"'5. Utility Income'!V22","v":64089437.490003996}]
[null,2,null,"Amortization/Depreciation",null,{"$f":"'5. Utility Income'!F23","v":26487624.058676168},null,null,null,{"$f":"'5. Utility Income'!N23","v":26487624.058676168},null,null,null,{"$f":"'5. Utility Income'!V23","v":26487624.058676168}]
[null,3,null,"Property Taxes",null,{"$f":"'5. Utility Income'!F24","v":304693.21601849998},null,null,null,{"$f":"'5. Utility Income'!N24","v":304693.21601849998},null,null,null,{"$f":"'5. Utility Income'!V24","v":304693.21601849998}]
[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":4289143.2424794603},null,null,null,{"$f":"'6. Taxes_PILs'!K33-J18","v":4289143.2424794603},null,null,null,{"$f":"'6. Taxes_PILs'!O33-N18","v":4289143.2424794603}]
[null,6,null,"Other Expenses",null,{"$f":"'5. Utility Income'!F26","v":0},null,null,null,{"$f":"'5. Utility Income'!N26","v":""},null,null,null,{"$f":"'5. Utility Income'!V26","v":""}]
[null,7,null,"Return"]
[null,null,null,"Deemed Interest Expense",null,{"$f":"'8. Rev_Def_Suff'!F25","v":10181190.05695642},null,null,null,{"$f":"'8. Rev_Def_Suff'!L25","v":0},null,null,null,{"$f":"'8. Rev_Def_Suff'!P25","v":0}]
[null,null,null,"Return on Deemed Equity",null,{"$f":"'8. Rev_Def_Suff'!F50","v":18792921.758341081},null,null,null,{"$f":"'8. Rev_Def_Suff'!L50","v":0},null,null,null,{"$f":"'8. Rev_Def_Suff'!P50","v":0}]
[]
[null,8,null,"Service Revenue Requirement (before Revenues)",null,{"$f":"SUM(F15:F23)","v":124145009.82247561},null,null,null,{"$f":"SUM(J15:J23)","v":95170898.007178113},null,null,null,{"$f":"SUM(N15:O23)","v":95170898.007178113}]
[]
[null,9,null,"Revenue Offsets",null,{"$f":"'3. Data_Input_Sheet'!E33","v":5516509.2400000002},null,null,null,{"$f":"'3. Data_Input_Sheet'!M33","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!U33","v":0}]
[null,10,null,"Base Revenue Requirement",null,{"$f":"F25-F27","v":118628500.58247562},null,null,null,{"$f":"J25-J27","v":95170898.007178113},null,null,null,{"$f":"N25-N27","v":95170898.007178113}]
[null,null,null,"(excluding Tranformer Owership Allowance credit adjustment)"]
[]
[null,11,null,"Distribution revenue",null,{"$f":"'5. Utility Income'!F16","v":118628500.58247563},null,null,null,{"$f":"'5. Utility Income'!N16","v":0},null,null,null,{"$f":"'5. Utility Income'!V16","v":0}]
[null,12,null,"Other revenue",null,{"$f":"'5. Utility Income'!F17","v":5516509.2400000002},null,null,null,{"$f":"'5. Utility Income'!N17","v":0},null,null,null,{"$f":"'5. Utility Income'!V17","v":0}]
[null,null,null,null,null,{"$f":"SUM(F31:F32)","v":124145009.82247563},null,null,null,{"$f":"SUM(J31:J32)","v":0},null,null,null,{"$f":"SUM(N31:N32)","v":0}]
[null,13,null,"Total revenue"]
[null,null,null,null,null,{"$f":"F33-F25","v":0},null,null,null,{"$f":"J33-J25","v":-95170898.007178113},null,null,null,{"$f":"N33-N25","v":-95170898.007178113}]
[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"]