{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["1. Utility_Info_","2. ICM_Costs","3. Cost_of_Service_Parameters","4. ICM_Assets_and_Rate_Base","5. UCC_Calculation","6. ICMIRR_2024","7. Rate Riders Revs","8. Opex Interest Annual","9. IRR"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":9063,"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. Utility_Info_","index":0,"n_rows":85,"n_cols":28,"rows_kept":85,"cut":false,"hidden":false,"merged":[[20,3,20,5],[22,3,22,7],[18,3,18,4],[1,2,1,9],[2,2,2,9],[3,2,3,9],[4,2,4,9],[14,3,14,4]]}
[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,"Algoma 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,null,null,"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,null,null,"Attawapiskat 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,null,null,"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,null,null,"Brant County Power"]
[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,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"E.L.K. Energy Inc."]
[null,null,"Utility Name   ","Alectra Utilities Corporation - PowerStream Rate Zone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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,null,null,"Entegrus Powerlines Inc."]
[null,null,"Assigned EB Number","EB-2025-0252",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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,null,null,"Erie Thames Powerlines Corp."]
[null,null,"Name and Title","Natalie Yeates, Director, Regulatory Affairs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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,null,null,"Essex Powerlines Corporation"]
[null,null,"Phone Number","416-617-1959",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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,null,null,"Fort Albany Power Corporation"]
[null,null,"Email Address","natalie.yeates@alectrautilities.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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,null,null,"Greater Sudbury Hydro Inc."]
[null,null,"Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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,null,null,"Guelph Hydro Electric Systems Inc."]
[null,null,"ICM Project","2024 - Cable Replacement / Injection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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,null,null,"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,null,null,"Hearst Power Distribution Co. Ltd."]
["Note:  Drop-down lists are shaded blue; Input cells are shaded green."]
[]
[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,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"PowerStream 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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"Thunder Bay Hydro Electricity Distribution"]
[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,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"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,null,null,"Woodstock Hydro Services 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,null,null,"Alectra Utilities Corporation - PowerStream Rate Zone"]
[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,"Alectra Utilities Corporation - Brampton Rate Zone"]
[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,"Alectra Utilities Corporation - Enersource Rate Zone"]
[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,"Alectra Utilities Corporation - Horizon Rate Zone"]
[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,"Alectra Utilities Corporation - Guelph Rate Zone"]

{"sheet":"2. ICM_Costs","index":1,"n_rows":220,"n_cols":11,"rows_kept":220,"cut":false,"hidden":false,"merged":[[166,2,166,3],[168,2,168,3],[170,2,170,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,2024,null,2015,null,"Total"]
[null,"Sheet 2: ICM Capital Cost Data",null,null,null,null,"Audited Actual",null,"Forecast"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,1,"Capital Costs"]
[null,null,null,null,"Asset Type"]
[null,null,"SYSTEM ACCESS",null,"Asset type must be selected to enable calculations",null,{"$f":"IF(ISBLANK(G19),\"\",G19)","v":"Audited Actual"},null,{"$f":"IF(ISBLANK(I19),\"\",I19)","v":"Forecast"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G42,I42)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G44,I44)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G46,I46)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G48,I48)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G50,I50)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,"Total System Access",null,null,null,{"$f":"SUM(G42,G44,G46,G48,G50,G52,G54,G56,G58,G60)","v":0},null,{"$f":"SUM(I42,I44,I46,I48,I50,I52,I54,I56,I58,I60)","v":0},null,{"$f":"SUM(K42,K44,K46,K48,K50,K52,K54,K56,K58,K60)","v":0}]
[]
[null,null,null,null,{"$f":"E40","v":"Asset Type"}]
[null,null,"SYSTEM RENEWAL",null,null,null,{"$f":"G41","v":"Audited Actual"},null,{"$f":"I41","v":"Forecast"}]
[null,null,null,null,"UG Transformers",null,766013.6385,null,null,null,{"$f":"SUM(G66,I66)","v":766013.6385}]
[]
[null,null,null,null,"UG Conduit",null,2127815.6625000001,null,null,null,{"$f":"SUM(G68,I68)","v":2127815.6625000001}]
[]
[null,null,null,null,"UG Prim XLPE TR",null,3404505.06,null,null,null,{"$f":"SUM(G70,I70)","v":3404505.06}]
[]
[null,null,null,null,"UG Sec In Duct/Svs",null,851126.26500000001,null,null,null,{"$f":"SUM(G72,I72)","v":851126.26500000001}]
[]
[null,null,null,null,"Air Insulated Switchgear",null,680901.01199999999,null,null,null,{"$f":"SUM(G74,I74)","v":680901.01199999999}]
[]
[null,null,null,null,"Solid Dielectric Switchgear",null,680901.01199999999,null,null,null,{"$f":"SUM(G76,I76)","v":680901.01199999999}]
[]
[null,null,null,null,"UG Cable Injection",null,5418039.379999999,null,null,null,{"$f":"SUM(G78,I78)","v":5418039.379999999}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G80,I80)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G82,I82)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,"Total System Renewal",null,null,null,{"$f":"SUM(G66,G68,G70,G72,G74,G76,G78,G80,G82,G84)","v":13929302.029999997},null,{"$f":"SUM(I66,I68,I70,I72,I74,I76,I78,I80,I82,I84)","v":0},null,{"$f":"SUM(K66,K68,K70,K72,K74,K76,K78,K80,K82,K84)","v":13929302.029999997}]
[]
[null,null,null,null,{"$f":"E64","v":"Asset Type"}]
[null,null,"SYSTEM SERVICE",null,null,null,{"$f":"G65","v":"Audited Actual"},null,{"$f":"I65","v":"Forecast"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G90,I90)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G92,I92)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G94,I94)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G96,I96)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G98,I98)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G100,I100)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G102,I102)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G104,I104)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G106,I106)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,"Total System Service",null,null,null,{"$f":"SUM(G90,G92,G94,G96,G98,G100,G102,G104,G106,G108)","v":0},null,{"$f":"SUM(I90,I92,I94,I96,I98,I100,I102,I104,I106,I108)","v":0},null,{"$f":"SUM(K90,K92,K94,K96,K98,K100,K102,K104,K106,K108)","v":0}]
[]
[null,null,null,null,{"$f":"E88","v":"Asset Type"}]
[null,null,"GENERAL PLANT",null,null,null,"Audited Actual",null,{"$f":"I89","v":"Forecast"}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G115,I115)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G117,I117)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G119,I119)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G121,I121)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G123,I123)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G125,I125)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G127,I127)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G129,I129)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G131,I131)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,"Total General Plant",null,null,null,{"$f":"SUM(G115,G117,G119,G121,G123,G125,G127,G129,G131,G133)","v":0},null,{"$f":"SUM(I115,I117,I119,I121,I123,I125,I127,I129,I131,I133)","v":0},null,{"$f":"SUM(K115,K117,K119,K121,K123,K125,K127,K129,K131,K133)","v":0}]
[]
[null,null,null,null,{"$f":"E112","v":"Asset Type"}]
[null,null,null,null,null,null,"Audited Actual",null,{"$f":"I113","v":"Forecast"}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G140,I140)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G142,I142)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G144,I144)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G146,I146)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G148,I148)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G150,I150)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G152,I152)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G154,I154)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G156,I156)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,"Total ",null,null,null,{"$f":"SUM(G140,G142,G144,G146,G148,G150,G152,G154,G156,G158)","v":0},null,{"$f":"SUM(I140,I142,I144,I146,I148,I150,I152,I154,I156,I158)","v":0},null,{"$f":"SUM(K140,K142,K144,K146,K148,K150,K152,K154,K156,K158)","v":0}]
[]
[null,null,"Total Capital Costs Related to Incremental Capital Projects (ICP)",null,null,null,{"$f":"G160+G135+G110+G86+G62","v":13929302.029999997},null,{"$f":"SUM(I62,I86,I110,I135,I160)","v":0},null,{"$f":"SUM(K62,K86,K110,K135,K160)","v":13929302.029999997}]
[]
[null,null,null,null,{"$f":"E137","v":"Asset Type"}]
[null,null,"OTHER CAPITAL COST",null,null,null,"Audited Actual",null,{"$f":"I138","v":"Forecast"}]
[]
[null,null,"A",null,null,null,null,null,null,null,{"$f":"SUM(G167,I167)","v":0}]
[]
[null,null,"B",null,null,null,null,null,null,null,{"$f":"SUM(G169,I169)","v":0}]
[]
[null,null,"C",null,null,null,null,null,null,null,{"$f":"SUM(G171,I171)","v":0}]
[]
[null,null,"Total Other Capital Costs ",null,null,null,{"$f":"SUM(G167,G169,G171)","v":0},null,{"$f":"SUM(I167,I169,I171)","v":0},null,{"$f":"SUM(K167,K169,K171)","v":0}]
[]
[null,null,"Total ICM Capital Costs",null,null,null,{"$f":"G162+G173","v":13929302.029999997},null,{"$f":"I162+I173","v":0},null,{"$f":"K162+K173","v":13929302.029999997}]
[]
[]
[null,2,"Aggregated ICM Costs by Category"]
[]
[null,null,"Asset Account","Capital","Account"]
[]
[null,null,120227,"OH Swtch & Cpctrs",1835,null,{"$f":"SUMIF($E$42:$E$171,$D182,G$42:G$171)","v":0},null,{"$f":"SUMIF($E$42:$E$171,$D182,I$42:I$171)","v":0},null,{"$f":"SUM(G182:J182)","v":0}]
[]
[null,null,120223,"Concrete Poles",1830,null,{"$f":"SUMIF($E$42:$E$171,$D184,G$42:G$171)","v":0},null,{"$f":"SUMIF($E$42:$E$171,$D184,I$42:I$171)","v":0},null,{"$f":"SUM(G184:J184)","v":0}]
[]
[null,null,120221,"Wood Poles",1830,null,{"$f":"SUMIF($E$42:$E$171,$D186,G$42:G$171)","v":0},null,{"$f":"SUMIF($E$42:$E$171,$D186,I$42:I$171)","v":0},null,{"$f":"SUM(G186:J186)","v":0}]
[]
[null,null,120225,"OH Transformers",1850,null,{"$f":"SUMIF($E$42:$E$171,$D188,G$42:G$171)","v":0},null,{"$f":"SUMIF($E$42:$E$171,$D188,I$42:I$171)","v":0},null,{"$f":"SUM(G188:J188)","v":0}]
[]
[null,null,120224,"OH Prim Cond & Dev",1835,null,{"$f":"SUMIF($E$42:$E$171,$D190,G$42:G$171)","v":0},null,{"$f":"SUMIF($E$42:$E$171,$D190,I$42:I$171)","v":0},null,{"$f":"SUM(G190:J190)","v":0}]
[]
[null,null,120226,"OH Sec Cond & Dev",1855,null,{"$f":"SUMIF($E$42:$E$171,$D192,G$42:G$171)","v":0},null,{"$f":"SUMIF($E$42:$E$171,$D192,I$42:I$171)","v":0},null,{"$f":"SUM(G192:J192)","v":0}]
[]
[null,null,120243,"UG Transformers",1850,null,{"$f":"SUMIF($E$42:$E$171,$D194,G$42:G$171)","v":766013.6385},null,{"$f":"SUMIF($E$42:$E$171,$D194,I$42:I$171)","v":0},null,{"$f":"SUM(G194:J194)","v":766013.6385}]
[]
[null,null,120245,"UG Conduit",1840,null,{"$f":"SUMIF($E$42:$E$171,$D196,G$42:G$171)","v":2127815.6625000001},null,{"$f":"SUMIF($E$42:$E$171,$D196,I$42:I$171)","v":0},null,{"$f":"SUM(G196:J196)","v":2127815.6625000001}]
[]
[null,null,"120241.XLPETR","UG Prim XLPE TR",1845,null,{"$f":"SUMIF($E$42:$E$171,$D198,G$42:G$171)","v":3404505.06},null,{"$f":"SUMIF($E$42:$E$171,$D198,I$42:I$171)","v":0},null,{"$f":"SUM(G198:J198)","v":3404505.06}]
[]
[null,null,"120242.DB","UG Sec - Dir Buried",1845,null,{"$f":"SUMIF($E$42:$E$171,$D200,G$42:G$171)","v":0},null,{"$f":"SUMIF($E$42:$E$171,$D200,I$42:I$171)","v":0},null,{"$f":"SUM(G200:J200)","v":0}]
[]
[null,null,"120242.IDSERV","UG Sec In Duct/Svs",1845,null,{"$f":"SUMIF($E$42:$E$171,$D202,G$42:G$171)","v":851126.26500000001},null,0,null,851126.26500000001]
[]
[null,null,120248,"Air Insulated Switchgear",1845,null,680901.01199999999,null,0,null,680901.01199999999]
[]
[null,null,120249,"Solid Dielectric Switchgear",1845,null,680901.01199999999,null,0,null,680901.01199999999]
[null,null,null,null,null,null,null,null,0,null,{"$f":"SUM(G207:J207)","v":0}]
[null,null,120244,"UG Cable Injection",1845,null,5418039.379999999,null,0,null,5418039.379999999]
[]
[null,null,"120063.MS","MS Integrated P&C Systems ",1820,null,0]
[]
[null,null,"120021.MS","MS Building Improvements ",1820,null,0]
[]
[null,null,130104,"Capital Contributions Paid ",1609,null,0]
[]
[]
[]
[]
[null,null,null,"Total Capital Costs",null,null,{"$f":"SUM(G182:G217)","v":13929302.029999997},null,{"$f":"SUM(I182:I217)","v":0},null,{"$f":"SUM(K182:K217)","v":13929302.029999997}]
[null,null,null,null,null,null,{"$f":"IF(G219=G175,\" \",\"Error\")","v":" "},null,{"$f":"IF(I219=I175,\"\",\"Error\")","v":""},null,{"$f":"IF(K219=K175,\"\",\"Error\")","v":""}]

{"sheet":"3. Cost_of_Service_Parameters","index":2,"n_rows":140,"n_cols":11,"rows_kept":140,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sheet 3: Parameters and Rates"]
[]
[null,null,null,null,null,null,2024,null,2025,null,2026]
[null,"Cost of Capital"]
[null,null,"Capital Structure"]
[null,null,null,"Deemed Short-term Debt Capitalization",null,null,0.04,null,0.04,null,0.04]
[null,null,null,"Deemed Long-term Debt Capitalization",null,null,{"$f":"60%-G22","v":0.55999999999999994},null,{"$f":"G23-(I22-G22)","v":0.55999999999999994},null,{"$f":"I23-(K22-I22)","v":0.55999999999999994}]
[null,null,null,"Deemed Equity Capitalization",null,null,{"$f":"100%-G23-G25-G22","v":0.40000000000000008},null,{"$f":"100%-I23-I25-I22","v":0.40000000000000008},null,{"$f":"100%-K23-K25-K22","v":0.40000000000000008}]
[null,null,null,"Preferred Shares"]
[null,null,"Total",null,null,null,{"$f":"SUM(G22:G25)","v":1},null,{"$f":"SUM(I22:I25)","v":1},null,{"$f":"SUM(K22:K25)","v":1}]
[]
[null,null,"Cost of Capital Parameters"]
[null,null,null,"Deemed Short-term Debt Rate",null,null,1.7600000000000001E-2,null,1.7600000000000001E-2,null,1.7600000000000001E-2]
[null,null,null,"Long-term Debt Rate (actual/embedded/deemed)1",null,null,3.8825037148941706E-2,null,3.8825039999999998E-2,null,3.8825039999999998E-2]
[null,null,null,"Target Return on Equity (ROE)",null,null,8.7800000000000003E-2,null,8.7800000000000003E-2,null,8.7800000000000003E-2]
[null,null,null,"Return on Preferred Shares"]
[null,null,"WACC",null,null,null,{"$f":"SUMPRODUCT(G22:G25,G29:G32)","v":5.7566020803407357E-2},null,{"$f":"SUMPRODUCT(I22:I25,I29:I32)","v":5.75660224E-2},null,{"$f":"SUMPRODUCT(K22:K25,K29:K32)","v":5.75660224E-2}]
[]
[null,"Working Capital Allowance"]
[null,null,"Working Capital Allowance Rate",null,null,null,7.4999999999999997E-2,null,{"$f":"G36","v":7.4999999999999997E-2},null,{"$f":"I36","v":7.4999999999999997E-2}]
[null,null,"(% of the sum of Cost of Power + controllable expenses)"]
[]
[null,"Taxes/PILs"]
[null,null,"Aggregate Corporate Income Tax Rate",null,null,null,0.26500000000000001,null,0.26500000000000001,null,0.26500000000000001]
[null,null,"Capital Tax (until July 1st, 2010)",null,null,null,0,null,0,null,0]
[]
[null,"Depreciation Rates",null,null,"Account"]
[null,"(expressed as expected useful life in years)"]
[null,null,"OH Swtch & Cpctrs",null,1835,null,38,null,35,null,35]
[null,null,"                              - rate (%)",null,null,null,2.6315789473684209E-2,null,2.8571428571428571E-2,null,2.8571428571428571E-2]
[null,null,"Concrete Poles",null,1830,null,51,null,60,null,60]
[null,null,"                             - rate (%)",null,null,null,1.9607843137254902E-2,null,1.6666666666666666E-2,null,1.6666666666666666E-2]
[null,null,"Wood Poles",null,1830,null,44,null,45,null,45]
[null,null,"                             - rate (%)",null,null,null,2.2727272727272728E-2,null,2.2222222222222223E-2,null,2.2222222222222223E-2]
[null,null,"OH Transformers",null,1850,null,41,null,45,null,45]
[null,null,"                             - rate (%)",null,null,null,2.4390243902439025E-2,null,2.2222222222222223E-2,null,2.2222222222222223E-2]
[null,null,"OH Prim Cond & Dev",null,1835,null,45,null,50,null,50]
[null,null,"                             - rate (%)",null,null,null,2.2222222222222223E-2,null,0.02,null,0.02]
[null,null,"OH Sec Cond & Dev",null,1855,null,48,null,50,null,50]
[null,null,"                             - rate (%)",null,null,null,2.0833333333333332E-2,null,0.02,null,0.02]
[null,null,"UG Transformers",null,1850,null,32,null,30,null,30]
[null,null,"                             - rate (%)",null,null,null,3.125E-2,null,3.3333333333333333E-2,null,3.3333333333333333E-2]
[null,null,"UG Conduit",null,1840,null,52,null,60,null,60]
[null,null,"                             - rate (%)",null,null,null,1.9230769230769232E-2,null,1.6666666666666666E-2,null,1.6666666666666666E-2]
[null,null,"UG Prim XLPE TR",null,1845,null,38,null,45,null,45]
[null,null,"                             - rate (%)",null,null,null,2.6315789473684209E-2,null,2.2222222222222223E-2,null,2.2222222222222223E-2]
[null,null,"UG Sec - Dir Buried",null,1845,null,31,null,30,null,30]
[null,null,"                             - rate (%)",null,null,null,3.2258064516129031E-2,null,3.3333333333333333E-2,null,3.3333333333333333E-2]
[null,null,"UG Sec In Duct/Svs",null,1845,null,37,null,40,null,40]
[null,null,"                             - rate (%)",null,null,null,2.7027027027027029E-2,null,2.5000000000000001E-2,null,2.5000000000000001E-2]
[null,null,"Air Insulated Switchgear",null,1845,null,39,null,35,null,35]
[null,null,"                             - rate (%)",null,null,null,2.564102564102564E-2,null,2.8571428571428571E-2,null,2.8571428571428571E-2]
[null,null,"Solid Dielectric Switchgear",null,1845,null,42,null,45,null,45]
[null,null,"                             - rate (%)",null,null,null,2.3809523809523808E-2,null,2.2222222222222223E-2,null,2.2222222222222223E-2]
[null,null,"UG Cable Injection",null,1845,null,24,null,20,null,20]
[null,null,"                             - rate (%)",null,null,null,4.1666666666666664E-2,null,0.05,null,0.05]
[null,null,"MS Integrated P&C Systems ",null,1820,null,36,null,15,null,15]
[null,null,"                             - rate (%)",null,null,null,2.7777777777777776E-2,null,6.6666666666666666E-2,null,6.6666666666666666E-2]
[null,null,"MS Building Improvements ",null,1820,null,21,null,25,null,25]
[null,null,"                             - rate (%)",null,null,null,4.7619047619047616E-2,null,0.04,null,0.04]
[null,null,"Capital Contributions Paid ",null,1609,null,40,null,40,null,40]
[null,null,"                             - rate (%)",null,null,null,2.5000000000000001E-2,null,2.5000000000000001E-2,null,2.5000000000000001E-2]
[]
[]
[]
[null,"CCA Rates"]
[null,null,"OH Swtch & Cpctrs - CCA Class",null,null,null,47,null,47,null,47]
[null,null,"OH Swtch & Cpctrs - CCA Rate",null,null,null,0.08,null,0.08,null,0.08]
[]
[null,null,"Concrete Poles - CCA Class",null,null,null,47,null,47,null,47]
[null,null,"Concrete Poles - CCA Rate",null,null,null,0.08,null,0.08,null,0.08]
[]
[null,null,"Wood Poles - CCA Class",null,null,null,47,null,47,null,47]
[null,null,"Wood Poles - CCA Rate",null,null,null,0.08,null,0.08,null,0.08]
[]
[null,null,"OH Transformers - CCA Class",null,null,null,47,null,47,null,47]
[null,null,"OH Transformers - CCA Rate",null,null,null,0.08,null,0.08,null,0.08]
[]
[null,null,"OH Prim Cond & Dev - CCA Class",null,null,null,47,null,47,null,47]
[null,null,"OH Prim Cond & Dev - CCA Rate",null,null,null,0.08,null,0.08,null,0.08]
[]
[null,null,"OH Sec Cond & Dev - CCA Class",null,null,null,47,null,47,null,47]
[null,null,"OH Sec Cond & Dev - CCA Rate",null,null,null,0.08,null,0.08,null,0.08]
[]
[null,null,"UG Transformers - CCA Class",null,null,null,47,null,47,null,47]
[null,null,"UG Transformers - CCA Rate",null,null,null,0.08,null,0.08,null,0.08]
[]
[null,null,"OH  Services - CCA Class",null,null,null,47,null,47,null,47]
[null,null,"OH Services - CCA Rate",null,null,null,0.08,null,0.08,null,0.08]
[]
[null,null,"UG Conduit - CCA Class",null,null,null,47,null,47,null,47]
[null,null,"UG Conduit - CCA Rate",null,null,null,0.08,null,0.08,null,0.08]
[]
[null,null,"UG Prim XLPE TR - CCA Class",null,null,null,47,null,47,null,47]
[null,null,"UG Prim XLPE TR - CCA Rate",null,null,null,0.08,null,0.08,null,0.08]
[]
[null,null,"UG Sec - Dir Buried - CCA Class",null,null,null,47,null,47,null,47]
[null,null,"UG Sec - Dir Buried - CCA Rate",null,null,null,0.08,null,0.08,null,0.08]
[]
[null,null,"UG Sec In Duct/Svs - CCA Class",null,null,null,47,null,47,null,47]
[null,null,"UG Sec In Duct/Svs - CCA Rate",null,null,null,0.08,null,0.08,null,0.08]
[]
[null,null,"Air Insulated Switchgear - CCA Class",null,null,null,47,null,47,null,47]
[null,null,"Air Insulated Switchgear - CCA Rate",null,null,null,0.08,null,0.08,null,0.08]
[]
[null,null,"Solid Dielectric Switchgear - CCA Class",null,null,null,47,null,47,null,47]
[null,null,"Solid Dielectric Switchgear - CCA Rate",null,null,null,0.08,null,0.08,null,0.08]
[]
[null,null,"UG Cable Injection - CCA Class",null,null,null,47,null,47,null,47]
[null,null,"UG Cable Injection - CCA Rate",null,null,null,0.08,null,0.08,null,0.08]
[]
[null,null,"MS Integrated P&C Systems  - CCA Class",null,null,null,47,null,47,null,47]
[null,null,"MS Integrated P&C Systems  - CCA Rate",null,null,null,0.08,null,0.08,null,0.08]
[]
[null,null,"MS Building Improvements   - CCA Class",null,null,null,1,null,1,null,1]
[null,null,"MS Building Improvements   - CCA Rate",null,null,null,0.04,null,0.04,null,0.04]
[]
[null,null,"Capital Contributions Paid   - CCA Class",null,null,null,47,null,47,null,47]
[null,null,"Capital Contributions Paid   - CCA Rate",null,null,null,0.08,null,0.08,null,0.08]
[]
[]
[null,"Assumptions"]
[null,1,"Fiscal calendar year (January 1 to December 31) used."]
[null,3,"Amortization is done on a striaght line basis and no \"half-year\" rule applied."]

{"sheet":"4. ICM_Assets_and_Rate_Base","index":3,"n_rows":357,"n_cols":13,"rows_kept":357,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sheet 4: ICM Assets - Net Book Value"]
[null,null,null,null,null,null,null,null,{"$f":"'3. Cost_of_Service_Parameters'!G19","v":2024},null,2025,null,2026]
[null,"Net Fixed Assets - OH Swtch & Cpctrs"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I25","v":0},null,{"$f":"K25","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G182","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I22+I23-I24","v":0},null,{"$f":"K22+K23-K24","v":0},null,{"$f":"M22+M23-M24","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I31","v":0},null,{"$f":"K31","v":0}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I23/('3. Cost_of_Service_Parameters'!G45)+MIN((I22/'3. Cost_of_Service_Parameters'!G45),(I22+I28)))), 0, -(I23/('3. Cost_of_Service_Parameters'!G45)+MIN((I22/'3. Cost_of_Service_Parameters'!G45),(I22+I28))))","v":0},null,{"$f":"IF(ISERROR(-(K23/('3. Cost_of_Service_Parameters'!I45)+MIN((K22/'3. Cost_of_Service_Parameters'!I45),(K22+K28)))), 0, -(K23/('3. Cost_of_Service_Parameters'!I45)+MIN((K22/'3. Cost_of_Service_Parameters'!I45),(K22+K28))))","v":0},null,{"$f":"IF(ISERROR(-(M23/('3. Cost_of_Service_Parameters'!K45)+MIN((M22/'3. Cost_of_Service_Parameters'!K45),(M22+M28)))), 0, -(M23/('3. Cost_of_Service_Parameters'!K45)+MIN((M22/'3. Cost_of_Service_Parameters'!K45),(M22+M28))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I28+I29-I30","v":0},null,{"$f":"K28+K29-K30","v":0},null,{"$f":"M28+M29-M30","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I22+I28","v":0},null,{"$f":"I35","v":0},null,{"$f":"K35","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I25+I31","v":0},null,{"$f":"K25+K31","v":0},null,{"$f":"M25+M31","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I35","v":0},null,{"$f":"AVERAGE(K34:K35)","v":0},null,{"$f":"AVERAGE(M34:M35)","v":0}]
[]
[null,"Net Fixed Assets - Concrete Poles"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I44","v":0},null,{"$f":"K44","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G184","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I41+I42-I43","v":0},null,{"$f":"K41+K42-K43","v":0},null,{"$f":"M41+M42-M43","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I50","v":0},null,{"$f":"K50","v":0}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I42/('3. Cost_of_Service_Parameters'!G47)+MIN((I41/'3. Cost_of_Service_Parameters'!G47),(I41+I47)))), 0, -(I42/('3. Cost_of_Service_Parameters'!G47)+MIN((I41/'3. Cost_of_Service_Parameters'!G47),(I41+I47))))","v":0},null,{"$f":"IF(ISERROR(-(K42/('3. Cost_of_Service_Parameters'!I47*2)+MIN((K41/'3. Cost_of_Service_Parameters'!I47),(K41+K47)))), 0, -(K42/('3. Cost_of_Service_Parameters'!I47*2)+MIN((K41/'3. Cost_of_Service_Parameters'!I47),(K41+K47))))","v":0},null,{"$f":"IF(ISERROR(-(M42/('3. Cost_of_Service_Parameters'!K47*2)+MIN((M41/'3. Cost_of_Service_Parameters'!K47),(M41+M47)))), 0, -(M42/('3. Cost_of_Service_Parameters'!K47*2)+MIN((M41/'3. Cost_of_Service_Parameters'!K47),(M41+M47))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I47+I48-I49","v":0},null,{"$f":"K47+K48-K49","v":0},null,{"$f":"M47+M48-M49","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I41+I47","v":0},null,{"$f":"I54","v":0},null,{"$f":"K54","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I44+I50","v":0},null,{"$f":"K44+K50","v":0},null,{"$f":"M44+M50","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I54","v":0},null,{"$f":"AVERAGE(K53:K54)","v":0},null,{"$f":"AVERAGE(M53:M54)","v":0}]
[]
[null,"Net Fixed Assets - Wood Poles"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I63","v":0},null,{"$f":"K63","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G186","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I60+I61-I62","v":0},null,{"$f":"K60+K61-K62","v":0},null,{"$f":"M60+M61-M62","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I69","v":0},null,{"$f":"K69","v":0}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I61/('3. Cost_of_Service_Parameters'!G49)+MIN((I60/'3. Cost_of_Service_Parameters'!G49),(I60+I66)))), 0, -(I61/('3. Cost_of_Service_Parameters'!G49)+MIN((I60/'3. Cost_of_Service_Parameters'!G49),(I60+I66))))","v":0},null,{"$f":"IF(ISERROR(-(K61/('3. Cost_of_Service_Parameters'!I49*2)+MIN((K60/'3. Cost_of_Service_Parameters'!I49),(K60+K66)))), 0, -(K61/('3. Cost_of_Service_Parameters'!I49*2)+MIN((K60/'3. Cost_of_Service_Parameters'!I49),(K60+K66))))","v":0},null,{"$f":"IF(ISERROR(-(M61/('3. Cost_of_Service_Parameters'!K49*2)+MIN((M60/'3. Cost_of_Service_Parameters'!K49),(M60+M66)))), 0, -(M61/('3. Cost_of_Service_Parameters'!K49*2)+MIN((M60/'3. Cost_of_Service_Parameters'!K49),(M60+M66))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I66+I67-I68","v":0},null,{"$f":"K66+K67-K68","v":0},null,{"$f":"M66+M67-M68","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I60+I66","v":0},null,{"$f":"I73","v":0},null,{"$f":"K73","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I63+I69","v":0},null,{"$f":"K63+K69","v":0},null,{"$f":"M63+M69","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I73","v":0},null,{"$f":"AVERAGE(K72:K73)","v":0},null,{"$f":"AVERAGE(M72:M73)","v":0}]
[]
[null,"Net Fixed Assets - OH Transformers"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I82","v":0},null,{"$f":"K82","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G188","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I79+I80-I81","v":0},null,{"$f":"K79+K80-K81","v":0},null,{"$f":"M79+M80-M81","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I88","v":0},null,{"$f":"K88","v":0}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I80/('3. Cost_of_Service_Parameters'!G51)+MIN((I79/'3. Cost_of_Service_Parameters'!G51),(I79+I85)))), 0, -(I80/('3. Cost_of_Service_Parameters'!G51)+MIN((I79/'3. Cost_of_Service_Parameters'!G51),(I79+I85))))","v":0},null,{"$f":"IF(ISERROR(-(K80/('3. Cost_of_Service_Parameters'!I51*2)+MIN((K79/'3. Cost_of_Service_Parameters'!I51),(K79+K85)))), 0, -(K80/('3. Cost_of_Service_Parameters'!I51*2)+MIN((K79/'3. Cost_of_Service_Parameters'!I51),(K79+K85))))","v":0},null,{"$f":"IF(ISERROR(-(M80/('3. Cost_of_Service_Parameters'!K51*2)+MIN((M79/'3. Cost_of_Service_Parameters'!K51),(M79+M85)))), 0, -(M80/('3. Cost_of_Service_Parameters'!K51*2)+MIN((M79/'3. Cost_of_Service_Parameters'!K51),(M79+M85))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I85+I86-I87","v":0},null,{"$f":"K85+K86-K87","v":0},null,{"$f":"M85+M86-M87","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I79+I85","v":0},null,{"$f":"I92","v":0},null,{"$f":"K92","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I82+I88","v":0},null,{"$f":"K82+K88","v":0},null,{"$f":"M82+M88","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I92","v":0},null,{"$f":"AVERAGE(K91:K92)","v":0},null,{"$f":"AVERAGE(M91:M92)","v":0}]
[]
[null,"Net Fixed Assets - OH Prim Cond & Dev"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I101","v":0},null,{"$f":"K101","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G190","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I98+I99-I100","v":0},null,{"$f":"K98+K99-K100","v":0},null,{"$f":"M98+M99-M100","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I107","v":0},null,{"$f":"K107","v":0}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I99/('3. Cost_of_Service_Parameters'!G53)+MIN((I98/'3. Cost_of_Service_Parameters'!G53),(I98+I104)))), 0, -(I99/('3. Cost_of_Service_Parameters'!G53)+MIN((I98/'3. Cost_of_Service_Parameters'!G53),(I98+I104))))","v":0},null,{"$f":"IF(ISERROR(-(K99/('3. Cost_of_Service_Parameters'!I53*2)+MIN((K98/'3. Cost_of_Service_Parameters'!I53),(K98+K104)))), 0, -(K99/('3. Cost_of_Service_Parameters'!I53*2)+MIN((K98/'3. Cost_of_Service_Parameters'!I53),(K98+K104))))","v":0},null,{"$f":"IF(ISERROR(-(M99/('3. Cost_of_Service_Parameters'!K53*2)+MIN((M98/'3. Cost_of_Service_Parameters'!K53),(M98+M104)))), 0, -(M99/('3. Cost_of_Service_Parameters'!K53*2)+MIN((M98/'3. Cost_of_Service_Parameters'!K53),(M98+M104))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I104+I105-I106","v":0},null,{"$f":"K104+K105-K106","v":0},null,{"$f":"M104+M105-M106","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I98+I104","v":0},null,{"$f":"I111","v":0},null,{"$f":"K111","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I101+I107","v":0},null,{"$f":"K101+K107","v":0},null,{"$f":"M101+M107","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I111","v":0},null,{"$f":"AVERAGE(K110:K111)","v":0},null,{"$f":"AVERAGE(M110:M111)","v":0}]
[]
[null,"Net Fixed Assets - OH Sec Cond & Dev"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I120","v":0},null,{"$f":"K120","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G192","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I117+I118-I119","v":0},null,{"$f":"K117+K118-K119","v":0},null,{"$f":"M117+M118-M119","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I126","v":0},null,{"$f":"K126","v":0}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I118/('3. Cost_of_Service_Parameters'!G55)+MIN((I117/'3. Cost_of_Service_Parameters'!G55),(I117+I123)))), 0, -(I118/('3. Cost_of_Service_Parameters'!G55)+MIN((I117/'3. Cost_of_Service_Parameters'!G55),(I117+I123))))","v":0},null,{"$f":"IF(ISERROR(-(K118/('3. Cost_of_Service_Parameters'!I55*2)+MIN((K117/'3. Cost_of_Service_Parameters'!I55),(K117+K123)))), 0, -(K118/('3. Cost_of_Service_Parameters'!I55*2)+MIN((K117/'3. Cost_of_Service_Parameters'!I55),(K117+K123))))","v":0},null,{"$f":"IF(ISERROR(-(M118/('3. Cost_of_Service_Parameters'!K55*2)+MIN((M117/'3. Cost_of_Service_Parameters'!K55),(M117+M123)))), 0, -(M118/('3. Cost_of_Service_Parameters'!K55*2)+MIN((M117/'3. Cost_of_Service_Parameters'!K55),(M117+M123))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I123+I124-I125","v":0},null,{"$f":"K123+K124-K125","v":0},null,{"$f":"M123+M124-M125","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I117+I123","v":0},null,{"$f":"I130","v":0},null,{"$f":"K130","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I120+I126","v":0},null,{"$f":"K120+K126","v":0},null,{"$f":"M120+M126","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I130","v":0},null,{"$f":"AVERAGE(K129:K130)","v":0},null,{"$f":"AVERAGE(M129:M130)","v":0}]
[]
[null,"Net Fixed Assets - UG Transformers"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I139","v":766013.6385},null,{"$f":"K139","v":766013.6385}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G194","v":766013.6385}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I136+I137-I138","v":766013.6385},null,{"$f":"K136+K137-K138","v":766013.6385},null,{"$f":"M136+M137-M138","v":766013.6385}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I145","v":-23937.926203125},null,{"$f":"K145","v":-49471.714153125002}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I137/('3. Cost_of_Service_Parameters'!G57)+MIN((I136/'3. Cost_of_Service_Parameters'!G57),(I136+I142)))), 0, -(I137/('3. Cost_of_Service_Parameters'!G57)+MIN((I136/'3. Cost_of_Service_Parameters'!G57),(I136+I142))))","v":-23937.926203125},null,{"$f":"IF(ISERROR(-(K137/('3. Cost_of_Service_Parameters'!I57*2)+MIN((K136/'3. Cost_of_Service_Parameters'!I57),(K136+K142)))), 0, -(K137/('3. Cost_of_Service_Parameters'!I57*2)+MIN((K136/'3. Cost_of_Service_Parameters'!I57),(K136+K142))))","v":-25533.787950000002},null,{"$f":"IF(ISERROR(-(M137/('3. Cost_of_Service_Parameters'!K57*2)+MIN((M136/'3. Cost_of_Service_Parameters'!K57),(M136+M142)))), 0, -(M137/('3. Cost_of_Service_Parameters'!K57*2)+MIN((M136/'3. Cost_of_Service_Parameters'!K57),(M136+M142))))","v":-25533.787950000002}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I142+I143-I144","v":-23937.926203125},null,{"$f":"K142+K143-K144","v":-49471.714153125002},null,{"$f":"M142+M143-M144","v":-75005.502103125007}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I136+I142","v":0},null,{"$f":"I149","v":742075.71229687496},null,{"$f":"K149","v":716541.92434687505}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I139+I145","v":742075.71229687496},null,{"$f":"K139+K145","v":716541.92434687505},null,{"$f":"M139+M145","v":691008.13639687502}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I149","v":742075.71229687496},null,{"$f":"AVERAGE(K148:K149)","v":729308.81832187506},null,{"$f":"AVERAGE(M148:M149)","v":703775.03037187504}]
[]
[null,"Net Fixed Assets - UG Conduit"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I158","v":2127815.6625000001},null,{"$f":"K158","v":2127815.6625000001}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G196","v":2127815.6625000001}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I155+I156-I157","v":2127815.6625000001},null,{"$f":"K155+K156-K157","v":2127815.6625000001},null,{"$f":"M155+M156-M157","v":2127815.6625000001}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I164","v":-40919.531971153847},null,{"$f":"K164","v":-76383.126346153847}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I156/('3. Cost_of_Service_Parameters'!G59)+MIN((I155/'3. Cost_of_Service_Parameters'!G59),(I155+I161)))), 0, -(I156/('3. Cost_of_Service_Parameters'!G59)+MIN((I155/'3. Cost_of_Service_Parameters'!G59),(I155+I161))))","v":-40919.531971153847},null,{"$f":"IF(ISERROR(-(K156/('3. Cost_of_Service_Parameters'!I59*2)+MIN((K155/'3. Cost_of_Service_Parameters'!I59),(K155+K161)))), 0, -(K156/('3. Cost_of_Service_Parameters'!I59*2)+MIN((K155/'3. Cost_of_Service_Parameters'!I59),(K155+K161))))","v":-35463.594375000001},null,{"$f":"IF(ISERROR(-(M156/('3. Cost_of_Service_Parameters'!K59*2)+MIN((M155/'3. Cost_of_Service_Parameters'!K59),(M155+M161)))), 0, -(M156/('3. Cost_of_Service_Parameters'!K59*2)+MIN((M155/'3. Cost_of_Service_Parameters'!K59),(M155+M161))))","v":-35463.594375000001}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I161+I162-I163","v":-40919.531971153847},null,{"$f":"K161+K162-K163","v":-76383.126346153847},null,{"$f":"M161+M162-M163","v":-111846.72072115385}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I155+I161","v":0},null,{"$f":"I168","v":2086896.1305288463},null,{"$f":"K168","v":2051432.5361538462}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I158+I164","v":2086896.1305288463},null,{"$f":"K158+K164","v":2051432.5361538462},null,{"$f":"M158+M164","v":2015968.9417788463}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I168","v":2086896.1305288463},null,{"$f":"AVERAGE(K167:K168)","v":2069164.3333413461},null,{"$f":"AVERAGE(M167:M168)","v":2033700.7389663463}]
[]
[null,"Net Fixed Assets - UG Prim XLPE TR"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I177","v":3404505.06},null,{"$f":"K177","v":3404505.06}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G198","v":3404505.06}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I174+I175-I176","v":3404505.06},null,{"$f":"K174+K175-K176","v":3404505.06},null,{"$f":"M174+M175-M176","v":3404505.06}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I183","v":-89592.238421052636},null,{"$f":"K183","v":-165247.90642105264}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I175/('3. Cost_of_Service_Parameters'!G61)+MIN((I174/'3. Cost_of_Service_Parameters'!G61),(I174+I180)))), 0, -(I175/('3. Cost_of_Service_Parameters'!G61)+MIN((I174/'3. Cost_of_Service_Parameters'!G61),(I174+I180))))","v":-89592.238421052636},null,{"$f":"IF(ISERROR(-(K175/('3. Cost_of_Service_Parameters'!I61*2)+MIN((K174/'3. Cost_of_Service_Parameters'!I61),(K174+K180)))), 0, -(K175/('3. Cost_of_Service_Parameters'!I61*2)+MIN((K174/'3. Cost_of_Service_Parameters'!I61),(K174+K180))))","v":-75655.668000000005},null,{"$f":"IF(ISERROR(-(M175/('3. Cost_of_Service_Parameters'!K61*2)+MIN((M174/'3. Cost_of_Service_Parameters'!K61),(M174+M180)))), 0, -(M175/('3. Cost_of_Service_Parameters'!K61*2)+MIN((M174/'3. Cost_of_Service_Parameters'!K61),(M174+M180))))","v":-75655.668000000005}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I180+I181-I182","v":-89592.238421052636},null,{"$f":"K180+K181-K182","v":-165247.90642105264},null,{"$f":"M180+M181-M182","v":-240903.57442105265}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I174+I180","v":0},null,{"$f":"I187","v":3314912.8215789474},null,{"$f":"K187","v":3239257.1535789473}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I177+I183","v":3314912.8215789474},null,{"$f":"K177+K183","v":3239257.1535789473},null,{"$f":"M177+M183","v":3163601.4855789472}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I187","v":3314912.8215789474},null,{"$f":"AVERAGE(K186:K187)","v":3277084.9875789471},null,{"$f":"AVERAGE(M186:M187)","v":3201429.3195789475}]
[]
[]
[null,"Net Fixed Assets - UG Sec - Dir Buried"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I197","v":0},null,{"$f":"K197","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G200","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I194+I195-I196","v":0},null,{"$f":"K194+K195-K196","v":0},null,{"$f":"M194+M195-M196","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I203","v":0},null,{"$f":"K203","v":0}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I195/('3. Cost_of_Service_Parameters'!G63)+MIN((I194/'3. Cost_of_Service_Parameters'!G63),(I194+I200)))), 0, -(I195/('3. Cost_of_Service_Parameters'!G63)+MIN((I194/'3. Cost_of_Service_Parameters'!G63),(I194+I200))))","v":0},null,{"$f":"IF(ISERROR(-(K195/('3. Cost_of_Service_Parameters'!I63*2)+MIN((K194/'3. Cost_of_Service_Parameters'!I63),(K194+K200)))), 0, -(K195/('3. Cost_of_Service_Parameters'!I63*2)+MIN((K194/'3. Cost_of_Service_Parameters'!I63),(K194+K200))))","v":0},null,{"$f":"IF(ISERROR(-(M195/('3. Cost_of_Service_Parameters'!K63*2)+MIN((M194/'3. Cost_of_Service_Parameters'!K63),(M194+M200)))), 0, -(M195/('3. Cost_of_Service_Parameters'!K63*2)+MIN((M194/'3. Cost_of_Service_Parameters'!K63),(M194+M200))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I200+I201-I202","v":0},null,{"$f":"K200+K201-K202","v":0},null,{"$f":"M200+M201-M202","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I194+I200","v":0},null,{"$f":"I207","v":0},null,{"$f":"K207","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I197+I203","v":0},null,{"$f":"K197+K203","v":0},null,{"$f":"M197+M203","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I207","v":0},null,{"$f":"AVERAGE(K206:K207)","v":0},null,{"$f":"AVERAGE(M206:M207)","v":0}]
[]
[]
[null,"Net Fixed Assets - UG Sec In Duct/Svs"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I217","v":851126.26500000001},null,{"$f":"K217","v":851126.26500000001}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G202","v":851126.26500000001}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I214+I215-I216","v":851126.26500000001},null,{"$f":"K214+K215-K216","v":851126.26500000001},null,{"$f":"M214+M215-M216","v":851126.26500000001}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I223","v":-23003.412567567568},null,{"$f":"K223","v":-44281.569192567564}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I215/('3. Cost_of_Service_Parameters'!G65)+MIN((I214/'3. Cost_of_Service_Parameters'!G65),(I214+I220)))), 0, -(I215/('3. Cost_of_Service_Parameters'!G65)+MIN((I214/'3. Cost_of_Service_Parameters'!G65),(I214+I220))))","v":-23003.412567567568},null,{"$f":"IF(ISERROR(-(K215/('3. Cost_of_Service_Parameters'!I65*2)+MIN((K214/'3. Cost_of_Service_Parameters'!I65),(K214+K220)))), 0, -(K215/('3. Cost_of_Service_Parameters'!I65*2)+MIN((K214/'3. Cost_of_Service_Parameters'!I65),(K214+K220))))","v":-21278.156625},null,{"$f":"IF(ISERROR(-(M215/('3. Cost_of_Service_Parameters'!K65*2)+MIN((M214/'3. Cost_of_Service_Parameters'!K65),(M214+M220)))), 0, -(M215/('3. Cost_of_Service_Parameters'!K65*2)+MIN((M214/'3. Cost_of_Service_Parameters'!K65),(M214+M220))))","v":-21278.156625}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I220+I221-I222","v":-23003.412567567568},null,{"$f":"K220+K221-K222","v":-44281.569192567564},null,{"$f":"M220+M221-M222","v":-65559.725817567567}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I214+I220","v":0},null,{"$f":"I227","v":828122.85243243247},null,{"$f":"K227","v":806844.69580743241}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I217+I223","v":828122.85243243247},null,{"$f":"K217+K223","v":806844.69580743241},null,{"$f":"M217+M223","v":785566.53918243246}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I227","v":828122.85243243247},null,{"$f":"AVERAGE(K226:K227)","v":817483.77411993244},null,{"$f":"AVERAGE(M226:M227)","v":796205.61749493238}]
[]
[]
[null,"Net Fixed Assets - Air Insulated Switchgear"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I237","v":680901.01199999999},null,{"$f":"K237","v":680901.01199999999}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G204","v":680901.01199999999}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I234+I235-I236","v":680901.01199999999},null,{"$f":"K234+K235-K236","v":680901.01199999999},null,{"$f":"M234+M235-M236","v":680901.01199999999}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I243","v":-17459.000307692306},null,{"$f":"K243","v":-36913.314936263734}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I235/('3. Cost_of_Service_Parameters'!G67)+MIN((I234/'3. Cost_of_Service_Parameters'!G67),(I234+I240)))), 0, -(I235/('3. Cost_of_Service_Parameters'!G67)+MIN((I234/'3. Cost_of_Service_Parameters'!G67),(I234+I240))))","v":-17459.000307692306},null,{"$f":"IF(ISERROR(-(K235/('3. Cost_of_Service_Parameters'!I67*2)+MIN((K234/'3. Cost_of_Service_Parameters'!I67),(K234+K240)))), 0, -(K235/('3. Cost_of_Service_Parameters'!I67*2)+MIN((K234/'3. Cost_of_Service_Parameters'!I67),(K234+K240))))","v":-19454.314628571428},null,{"$f":"IF(ISERROR(-(M235/('3. Cost_of_Service_Parameters'!K67*2)+MIN((M234/'3. Cost_of_Service_Parameters'!K67),(M234+M240)))), 0, -(M235/('3. Cost_of_Service_Parameters'!K67*2)+MIN((M234/'3. Cost_of_Service_Parameters'!K67),(M234+M240))))","v":-19454.314628571428}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I240+I241-I242","v":-17459.000307692306},null,{"$f":"K240+K241-K242","v":-36913.314936263734},null,{"$f":"M240+M241-M242","v":-56367.629564835166}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I234+I240","v":0},null,{"$f":"I247","v":663442.01169230766},null,{"$f":"K247","v":643987.69706373627}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I237+I243","v":663442.01169230766},null,{"$f":"K237+K243","v":643987.69706373627},null,{"$f":"M237+M243","v":624533.38243516488}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I247","v":663442.01169230766},null,{"$f":"AVERAGE(K246:K247)","v":653714.85437802202},null,{"$f":"AVERAGE(M246:M247)","v":634260.53974945052}]
[]
[]
[null,"Net Fixed Assets - Solid Dielectric Switchgear"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I257","v":680901.01199999999},null,{"$f":"K257","v":680901.01199999999}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G206","v":680901.01199999999}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I254+I255-I256","v":680901.01199999999},null,{"$f":"K254+K255-K256","v":680901.01199999999},null,{"$f":"M254+M255-M256","v":680901.01199999999}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I263","v":-8105.9644285714285},null,{"$f":"K263","v":-23237.098028571429}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I255/('3. Cost_of_Service_Parameters'!G69*2)+MIN((I254/'3. Cost_of_Service_Parameters'!G69),(I254+I260)))), 0, -(I255/('3. Cost_of_Service_Parameters'!G69*2)+MIN((I254/'3. Cost_of_Service_Parameters'!G69),(I254+I260))))","v":-8105.9644285714285},null,{"$f":"IF(ISERROR(-(K255/('3. Cost_of_Service_Parameters'!I69*2)+MIN((K254/'3. Cost_of_Service_Parameters'!I69),(K254+K260)))), 0, -(K255/('3. Cost_of_Service_Parameters'!I69*2)+MIN((K254/'3. Cost_of_Service_Parameters'!I69),(K254+K260))))","v":-15131.133599999999},null,{"$f":"IF(ISERROR(-(M255/('3. Cost_of_Service_Parameters'!K69*2)+MIN((M254/'3. Cost_of_Service_Parameters'!K69),(M254+M260)))), 0, -(M255/('3. Cost_of_Service_Parameters'!K69*2)+MIN((M254/'3. Cost_of_Service_Parameters'!K69),(M254+M260))))","v":-15131.133599999999}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I260+I261-I262","v":-8105.9644285714285},null,{"$f":"K260+K261-K262","v":-23237.098028571429},null,{"$f":"M260+M261-M262","v":-38368.231628571426}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I254+I260","v":0},null,{"$f":"I267","v":672795.04757142859},null,{"$f":"K267","v":657663.91397142853}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I257+I263","v":672795.04757142859},null,{"$f":"K257+K263","v":657663.91397142853},null,{"$f":"M257+M263","v":642532.78037142858}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I267","v":672795.04757142859},null,{"$f":"AVERAGE(K266:K267)","v":665229.48077142856},null,{"$f":"AVERAGE(M266:M267)","v":650098.34717142861}]
[]
[]
[null,"Net Fixed Assets - UG Cable Injection"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I277","v":5418039.379999999},null,{"$f":"K277","v":5418039.379999999}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G208","v":5418039.379999999}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I274+I275-I276","v":5418039.379999999},null,{"$f":"K274+K275-K276","v":5418039.379999999},null,{"$f":"M274+M275-M276","v":5418039.379999999}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I283","v":-112875.82041666664},null,{"$f":"K283","v":-383777.78941666655}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I275/('3. Cost_of_Service_Parameters'!G71*2)+MIN((I274/'3. Cost_of_Service_Parameters'!G71),(I274+I280)))), 0, -(I275/('3. Cost_of_Service_Parameters'!G71*2)+MIN((I274/'3. Cost_of_Service_Parameters'!G71),(I274+I280))))","v":-112875.82041666664},null,{"$f":"IF(ISERROR(-(K275/('3. Cost_of_Service_Parameters'!I71*2)+MIN((K274/'3. Cost_of_Service_Parameters'!I71),(K274+K280)))), 0, -(K275/('3. Cost_of_Service_Parameters'!I71*2)+MIN((K274/'3. Cost_of_Service_Parameters'!I71),(K274+K280))))","v":-270901.96899999992},null,{"$f":"IF(ISERROR(-(M275/('3. Cost_of_Service_Parameters'!K71*2)+MIN((M274/'3. Cost_of_Service_Parameters'!K71),(M274+M280)))), 0, -(M275/('3. Cost_of_Service_Parameters'!K71*2)+MIN((M274/'3. Cost_of_Service_Parameters'!K71),(M274+M280))))","v":-270901.96899999992}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I280+I281-I282","v":-112875.82041666664},null,{"$f":"K280+K281-K282","v":-383777.78941666655},null,{"$f":"M280+M281-M282","v":-654679.75841666642}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I274+I280","v":0},null,{"$f":"I287","v":5305163.5595833324},null,{"$f":"K287","v":5034261.5905833328}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I277+I283","v":5305163.5595833324},null,{"$f":"K277+K283","v":5034261.5905833328},null,{"$f":"M277+M283","v":4763359.6215833323}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I287","v":5305163.5595833324},null,{"$f":"AVERAGE(K286:K287)","v":5169712.5750833321},null,{"$f":"AVERAGE(M286:M287)","v":4898810.6060833326}]
[]
[]
[null,"Net Fixed Assets - MS Integrated P&C Systems "]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I297","v":0},null,{"$f":"K297","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G210","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I294+I295-I296","v":0},null,{"$f":"K294+K295-K296","v":0},null,{"$f":"M294+M295-M296","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I303","v":0},null,{"$f":"K303","v":0}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I295/('3. Cost_of_Service_Parameters'!G73*2)+MIN((I294/'3. Cost_of_Service_Parameters'!G73),(I294+I300)))), 0, -(I295/('3. Cost_of_Service_Parameters'!G73*2)+MIN((I294/'3. Cost_of_Service_Parameters'!G73),(I294+I300))))","v":0},null,{"$f":"IF(ISERROR(-(K295/('3. Cost_of_Service_Parameters'!I73*2)+MIN((K294/'3. Cost_of_Service_Parameters'!I73),(K294+K300)))), 0, -(K295/('3. Cost_of_Service_Parameters'!I73*2)+MIN((K294/'3. Cost_of_Service_Parameters'!I73),(K294+K300))))","v":0},null,{"$f":"IF(ISERROR(-(M295/('3. Cost_of_Service_Parameters'!K73*2)+MIN((M294/'3. Cost_of_Service_Parameters'!K73),(M294+M300)))), 0, -(M295/('3. Cost_of_Service_Parameters'!K73*2)+MIN((M294/'3. Cost_of_Service_Parameters'!K73),(M294+M300))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I300+I301-I302","v":0},null,{"$f":"K300+K301-K302","v":0},null,{"$f":"M300+M301-M302","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I294+I300","v":0},null,{"$f":"I307","v":0},null,{"$f":"K307","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I297+I303","v":0},null,{"$f":"K297+K303","v":0},null,{"$f":"M297+M303","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I307","v":0},null,{"$f":"AVERAGE(K306:K307)","v":0},null,{"$f":"AVERAGE(M306:M307)","v":0}]
[]
[]
[null,"Net Fixed Assets - MS Building Improvements "]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I317","v":0},null,{"$f":"K317","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G212","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I314+I315-I316","v":0},null,{"$f":"K314+K315-K316","v":0},null,{"$f":"M314+M315-M316","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I323","v":0},null,{"$f":"K323","v":0}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I315/('3. Cost_of_Service_Parameters'!G75*2)+MIN((I314/'3. Cost_of_Service_Parameters'!G75),(I314+I320)))), 0, -(I315/('3. Cost_of_Service_Parameters'!G75*2)+MIN((I314/'3. Cost_of_Service_Parameters'!G75),(I314+I320))))","v":0},null,{"$f":"IF(ISERROR(-(K315/('3. Cost_of_Service_Parameters'!I75*2)+MIN((K314/'3. Cost_of_Service_Parameters'!I75),(K314+K320)))), 0, -(K315/('3. Cost_of_Service_Parameters'!I75*2)+MIN((K314/'3. Cost_of_Service_Parameters'!I75),(K314+K320))))","v":0},null,{"$f":"IF(ISERROR(-(M315/('3. Cost_of_Service_Parameters'!K75*2)+MIN((M314/'3. Cost_of_Service_Parameters'!K75),(M314+M320)))), 0, -(M315/('3. Cost_of_Service_Parameters'!K75*2)+MIN((M314/'3. Cost_of_Service_Parameters'!K75),(M314+M320))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I320+I321-I322","v":0},null,{"$f":"K320+K321-K322","v":0},null,{"$f":"M320+M321-M322","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I314+I320","v":0},null,{"$f":"I327","v":0},null,{"$f":"K327","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I317+I323","v":0},null,{"$f":"K317+K323","v":0},null,{"$f":"M317+M323","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I327","v":0},null,{"$f":"AVERAGE(K326:K327)","v":0},null,{"$f":"AVERAGE(M326:M327)","v":0}]
[]
[]
[null,"Net Fixed Assets - Capital Contributions Paid "]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I337","v":0},null,{"$f":"K337","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G214","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I334+I335-I336","v":0},null,{"$f":"K334+K335-K336","v":0},null,{"$f":"M334+M335-M336","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I343","v":0},null,{"$f":"K343","v":0}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I335/('3. Cost_of_Service_Parameters'!G77*2)+MIN((I334/'3. Cost_of_Service_Parameters'!G77),(I334+I340)))), 0, -(I335/('3. Cost_of_Service_Parameters'!G77*2)+MIN((I334/'3. Cost_of_Service_Parameters'!G77),(I334+I340))))","v":0},null,{"$f":"IF(ISERROR(-(K335/('3. Cost_of_Service_Parameters'!I77*2)+MIN((K334/'3. Cost_of_Service_Parameters'!I77),(K334+K340)))), 0, -(K335/('3. Cost_of_Service_Parameters'!I77*2)+MIN((K334/'3. Cost_of_Service_Parameters'!I77),(K334+K340))))","v":0},null,{"$f":"IF(ISERROR(-(M335/('3. Cost_of_Service_Parameters'!K77*2)+MIN((M334/'3. Cost_of_Service_Parameters'!K77),(M334+M340)))), 0, -(M335/('3. Cost_of_Service_Parameters'!K77*2)+MIN((M334/'3. Cost_of_Service_Parameters'!K77),(M334+M340))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I340+I341-I342","v":0},null,{"$f":"K340+K341-K342","v":0},null,{"$f":"M340+M341-M342","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I334+I340","v":0},null,{"$f":"I347","v":0},null,{"$f":"K347","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I337+I343","v":0},null,{"$f":"K337+K343","v":0},null,{"$f":"M337+M343","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I347","v":0},null,{"$f":"AVERAGE(K346:K347)","v":0},null,{"$f":"AVERAGE(M346:M347)","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,null,"Additions",null,null,null,null,{"$f":"I23+I42+I61+I80+I99+I118+I137+I156+I175+I195+I215+I235+I255+I275+I295+I315+I335","v":13929302.029999997},null,{"$f":"K23+K42+K61+K80+K99+K118+K137+K156+K175+K195+K215+K235+K255+K275+K295+K315+K335","v":0},null,{"$f":"M23+M42+M61+M80+M99+M118+M137+M156+M175+M195+M215+M235+M255+M275+M295+M315+M335","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I36+I55+I74+I93+I112+I131+I150+I169+I188+I208+I228+I248+I268+I288+I308+I328+I348","v":13613408.13568417},null,{"$f":"K36+K55+K74+K93+K112+K131+K150+K169+K188+K208+K228+K248+K268+K288+K308+K328+K348","v":13381698.823594883},null,{"$f":"M36+M55+M74+M93+M112+M131+M150+M169+M188+M208+M228+M248+M268+M288+M308+M328+M348","v":12918280.199416313}]
[null,null,null,"Total Amortization",null,null,null,null,{"$f":"I29+I48+I67+I86+I105+I124+I143+I162+I181+I201+I221+I241+I261+I281+I301+I321+I341","v":-315893.89431582944},null,{"$f":"K29+K48+K67+K86+K105+K124+K143+K162+K181+K201+K221+K241+K261+K281+K301+K321+K341","v":-463418.62417857139},null,{"$f":"M29+M48+M67+M86+M105+M124+M143+M162+M181+M201+M221+M241+M261+M281+M301+M321+M341","v":-463418.62417857139}]

{"sheet":"5. UCC_Calculation","index":4,"n_rows":46,"n_cols":4,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Sheet 6: CCA For PILs Calculation"]
[]
["UCC/Class 47",null,null,{"$f":"'3. Cost_of_Service_Parameters'!G19","v":2024}]
[null,null,null,{"$f":"'2. ICM_Costs'!G19","v":"Audited Actual"}]
[]
["Opening UCC",null,null,0]
["Capital Additions",null,null,{"$f":"'2. ICM_Costs'!G219","v":13929302.029999997}]
["Retirements/Removals (if applicable)"]
["UCC Full Year",null,null,{"$f":"SUM(D23:D24)-D25","v":13929302.029999997}]
[]
[]
["CCA Rate Class",null,null,{"$f":"'3. Cost_of_Service_Parameters'!G83","v":47}]
["CCA Rate ",null,null,{"$f":"'3. Cost_of_Service_Parameters'!G84","v":0.08}]
["CCA",null,null,{"$f":"D26*D30","v":1114344.1623999998}]
["Closing UCC",null,null,{"$f":"IF((D26-D31)<0, 0, D26-D31)","v":12814957.867599998}]
[]
["UCC/Class 8",null,null,{"$f":"D20","v":2024}]
[null,null,null,"Audited Actual"]
[]
["Opening UCC",null,null,0]
["Capital Additions RTU's",null,null,0]
["Retirements/Removals (if applicable)"]
["UCC Full Year",null,null,{"$f":"SUM(D37:D38)-D39","v":0}]
[]
[]
["CCA Rate Class",null,null,{"$f":"'3. Cost_of_Service_Parameters'!G107","v":47}]
["CCA Rate ",null,null,{"$f":"'3. Cost_of_Service_Parameters'!G108","v":0.08}]
["CCA",null,null,{"$f":"D40*D44","v":0}]
["Closing UCC",null,null,{"$f":"IF((D40-D45)<0, 0, D40-D45)","v":0}]

{"sheet":"6. ICMIRR_2024","index":5,"n_rows":88,"n_cols":11,"rows_kept":88,"cut":false,"hidden":false,"merged":[[23,8,23,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Sheet 6:",null,"Incremental Capital Adjustment"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"2024 OEB Approved"]
[]
[null,null,"Return on Rate Base"]
[null,null,"Incremental Capital CAPEX",null,null,{"$f":"'2. ICM_Costs'!G219","v":13929302.029999997},"B",null,null,null,17273507.710000001]
[null,null,"Depreciation Expense",null,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!I357","v":315893.89431582944},"C",null,null,null,383855.72688888892]
[null,null,"Incremental Capital CAPEX to be included in Rate Base",null,null,{"$f":"(F27+(F27-F28))/2","v":13771355.082842082},"D = B - C",null,null,null,{"$f":"(K27+(K27-K28))/2","v":17081579.846555557}]
[]
[null,null,"Deemed ShortTerm Debt %",{"$f":"'3. Cost_of_Service_Parameters'!G22","v":0.04},"E",{"$f":"F29*D31","v":550854.20331368328},"G = D * E",null,{"$f":"D31","v":0.04},null,{"$f":"K29*I31","v":683263.19386222225}]
[null,null,"Deemed Long Term Debt %",{"$f":"'3. Cost_of_Service_Parameters'!G23","v":0.55999999999999994},"F",{"$f":"F29*D32","v":7711958.8463915652},"H = D * F",null,{"$f":"D32","v":0.55999999999999994},null,{"$f":"K29*I32","v":9565684.7140711118}]
[]
[null,null,"Short Term Interest",{"$f":"'3. Cost_of_Service_Parameters'!G29","v":1.7600000000000001E-2},"I",{"$f":"F31*D34","v":9695.0339783208256},"K = G * I",null,{"$f":"D34","v":1.7600000000000001E-2},null,{"$f":"K31*I34","v":12025.432211975112}]
[null,null,"Long Term Interest",{"$f":"'3. Cost_of_Service_Parameters'!G30","v":3.8825037148941706E-2},"J",{"$f":"F32*D35","v":299417.08870226215},"L = H * J",null,{"$f":"D35","v":3.8825037148941706E-2},null,{"$f":"K32*I35","v":371388.06437887473}]
[]
[null,null,"Return on Rate Base - Interest",null,null,{"$f":"SUM(F34:F35)","v":309112.12268058298},"M = K + L",null,null,null,{"$f":"SUM(K34:K35)","v":383413.49659084983}]
[]
[]
[null,null,"Deemed Equity %",{"$f":"'3. Cost_of_Service_Parameters'!G24","v":0.40000000000000008},"N",{"$f":"F29*D40","v":5508542.0331368335},"P = D * N",null,0.39999999999999991,null,{"$f":"K29*I40","v":6832631.9386222214}]
[]
[null,null,"Return on Rate Base -Equity",{"$f":"'3. Cost_of_Service_Parameters'!G31","v":8.7800000000000003E-2},"O",{"$f":"F40*D42","v":483649.990509414},"Q = P * O",null,{"$f":"D42","v":8.7800000000000003E-2},null,{"$f":"K40*I42","v":599905.08421103109}]
[]
[null,null,"Return on Rate Base - Total",null,null,{"$f":"F37+F42","v":792762.11318999692},"R = M + Q",null,null,null,{"$f":"K37+K42","v":983318.58080188092}]
[]
[]
[]
[null,null,"Amortization Expense"]
[]
[null,null,"Amortization Expense - Incremental",null,"C",{"$f":"F28","v":315893.89431582944},"S",null,null,null,{"$f":"K28","v":383855.72688888892}]
[]
[]
[null,null,"Grossed up PIL's"]
[]
[null,null,"Regulatory Taxable Income",null,"O",{"$f":"F42","v":483649.990509414},"T ",null,null,null,{"$f":"K42","v":599905.08421103109}]
[]
[null,null,"Add Back Amortization Expense",null,"S",{"$f":"F50","v":315893.89431582944},"U",null,null,null,{"$f":"K50","v":383855.72688888892}]
[]
[null,null,"Deduct CCA",null,null,{"$f":"'5. UCC_Calculation'!D31+'5. UCC_Calculation'!D45","v":1114344.1623999998},"V",null,null,null,1381880.6168000002]
[]
[null,null,"Incremental Taxable Income",null,null,{"$f":"F55+F57-F59","v":-314800.27757475642},"W = T + U - V",null,null,null,{"$f":"K55+K57-K59","v":-398119.80570008024}]
[]
[null,null,"Current Tax Rate (F1.1 Z-Factor Tax Changes)",{"$f":"'3. Cost_of_Service_Parameters'!G40","v":0.26500000000000001},"X",null,null,null,{"$f":"D63","v":0.26500000000000001}]
[]
[null,null,"PIL's Before Gross Up",null,null,{"$f":"F61*D63","v":-83422.073557310461},"Y = W * X",null,null,null,{"$f":"K61*I63","v":-105501.74851052127}]
[]
[null,null,"Incremental Grossed Up PIL's",null,null,{"$f":"F65/(1-D63)","v":-113499.41980586457},"Z = Y / ( 1 - X ) ",null,null,null,{"$f":"K65/(1-I63)","v":-143539.79389186567}]
[]
[]
[null,null,"Ontario Capital Tax"]
[null,null,"Incremental Capital CAPEX",null,null,{"$f":"F27","v":13929302.029999997},"AA",null,null,null,{"$f":"K27","v":17273507.710000001}]
[]
[null,null,"Less : Available Capital Exemption (if any)",null,null,0,"AB",null,null,null,0]
[]
[null,null,"Incremental Capital CAPEX subject to OCT",null,null,{"$f":"F71-F73","v":13929302.029999997},"AC = AA - AB",null,null,null,{"$f":"K71-K73","v":17273507.710000001}]
[]
[null,null,"Ontario Capital Tax Rate (F1.1 Z-Factor Tax Changes)",0,"AD"]
[]
[null,null,"Incremental Ontario Capital Tax",null,null,{"$f":"F75*D77","v":0},"AE = AC * AD",null,null,null,{"$f":"K75*I77","v":0}]
[]
[]
[null,null,"Incremental Revenue Requirement"]
[null,null,"Return on Rate Base - Total",null,"Q",{"$f":"F44","v":792762.11318999692},"AF",null,null,null,{"$f":"K44","v":983318.58080188092}]
[null,null,"Amortization Expense - Total",null,"S",{"$f":"F50","v":315893.89431582944},"AG",null,null,null,{"$f":"K50","v":383855.72688888892}]
[null,null,"Incremental Grossed Up PIL's",null,"Z",{"$f":"F67","v":-113499.41980586457},"AH",null,null,null,{"$f":"K67","v":-143539.79389186567}]
[null,null,"Incremental Ontario Capital Tax",null,"AE",{"$f":"F79","v":0},"AI",null,null,null,{"$f":"K79","v":0}]
[]
[null,null,"Incremental Revenue Requirement",null,null,{"$f":"SUM(F83:F86)","v":995156.58769996185},"AJ = AF + AG + AH + AI",null,null,null,{"$f":"SUM(K83:K86)","v":1223634.5137989041}]

{"sheet":"7. Rate Riders Revs","index":6,"n_rows":131,"n_cols":17,"rows_kept":131,"cut":false,"hidden":false,"merged":[[12,1,12,13],[18,5,18,15]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This worksheet calculates the rate rider revenues.\n"]
[]
[]
[]
[null,"Sheet 7: ICM Rate Rider Revenues"]
[]
[]
[]
[]
[null,"Prescribed \nInterest Rates","Approved Deferral and Variance Accounts","CWIP",null,"Date","Year","Quarter",null,"Opening Balance (Principal)","Rate Rider Revenues","Interest Rate","Interest","Principal &\nInterest\n(Cumm.)",null,"Board Approved ICM Rate Rider","Board Approved ICM  Rate Rider\n(Cumm.)"]
[]
[null,"2018 Q1",1.4999999999999999E-2,2.9899999999999999E-2,null,"2018-01-01",{"$f":"YEAR(F24)","v":2018},{"$f":"IF(MONTH(F24)=0,\"\",IF(MONTH(F24)<4,\"Q1\",IF(MONTH(F24)<7,\"Q2\",IF(MONTH(F24)<10,\"Q3\",\"Q4\"))))","v":"Q1"},{"$f":"CONCATENATE(G24,\" \",H24)","v":"2018 Q1"},0,null,{"$f":"VLOOKUP(I24,$B$22:$D$59,2)","v":1.4999999999999999E-2},{"$f":"ROUND(J24*L24/12,2)","v":0},{"$f":"K24+M24","v":0},null,null,{"$f":"P24","v":0}]
[null,"2018 Q2",1.89E-2,3.3500000000000002E-2,null,"2018-02-01",{"$f":"YEAR(F25)","v":2018},{"$f":"IF(MONTH(F25)=0,\"\",IF(MONTH(F25)<4,\"Q1\",IF(MONTH(F25)<7,\"Q2\",IF(MONTH(F25)<10,\"Q3\",\"Q4\"))))","v":"Q1"},{"$f":"CONCATENATE(G25,\" \",H25)","v":"2018 Q1"},{"$f":"J24+K24","v":0},null,1.4999999999999999E-2,{"$f":"ROUND(J25*L25/12,2)","v":0},{"$f":"N24+K25+M25","v":0},null,null,{"$f":"Q24+P25","v":0}]
[null,"2018 Q3",1.89E-2,3.3500000000000002E-2,null,"2018-03-01",2018,"Q1","2018 Q1",{"$f":"J25+K25","v":0},null,1.4999999999999999E-2,0,{"$f":"N25+K26+M26","v":0},null,null,{"$f":"Q25+P26","v":0}]
[null,"2018 Q4",2.1700000000000001E-2,3.3500000000000002E-2,null,"2018-04-01",2018,"Q2","2018 Q2",0,null,1.89E-2,0,0,null,null,0]
[null,"2019 Q1",2.4500000000000001E-2,3.8199999999999998E-2,null,"2018-05-01",2018,"Q2","2018 Q2",0,null,1.89E-2,0,0,null,null,0]
[null,"2019 Q2",2.18E-2,3.39E-2,null,"2018-06-01",2018,"Q2","2018 Q2",0,null,1.89E-2,0,0,null,null,0]
[null,"2019 Q3",2.18E-2,2.8799999999999999E-2,null,"2018-07-01",2018,"Q3","2018 Q3",0,null,1.89E-2,0,0,null,null,0]
[null,"2019 Q4",2.18E-2,2.8799999999999999E-2,null,"2018-08-01",2018,"Q3","2018 Q3",0,null,1.89E-2,0,0,null,null,0]
[null,"2020 Q1",2.18E-2,2.8799999999999999E-2,null,"2018-09-01",2018,"Q3","2018 Q3",0,null,1.89E-2,0,0,null,null,0]
[null,"2020 Q2",2.18E-2,2.4799999999999999E-2,null,"2018-10-01",2018,"Q4","2018 Q4",0,null,2.1700000000000001E-2,0,0,null,null,0]
[null,"2020 Q3",5.7000000000000002E-3,2.4799999999999999E-2,null,"2018-11-01",2018,"Q4","2018 Q4",0,null,2.1700000000000001E-2,0,0,null,null,0]
[null,"2020 Q4",5.7000000000000002E-3,2.0299999999999999E-2,null,"2018-12-01",2018,"Q4","2018 Q4",0,null,2.1700000000000001E-2,0,0,null,null,0]
[null,"2021 Q1",5.7000000000000002E-3,2.0299999999999999E-2,null,"2019-01-01",2019,"Q1","2019 Q1",0,null,2.4500000000000001E-2,0,0,null,null,0]
[null,"2021 Q2",5.7000000000000002E-3,2.29E-2,null,"2019-02-01",2019,"Q1","2019 Q1",0,null,2.4500000000000001E-2,0,0,null,null,0]
[null,"2021 Q3",5.7000000000000002E-3,2.29E-2,null,"2019-03-01",2019,"Q1","2019 Q1",0,null,2.4500000000000001E-2,0,0,null,null,0]
[null,"2021 Q4",5.7000000000000002E-3,2.29E-2,null,"2019-04-01",2019,"Q2","2019 Q2",0,null,2.18E-2,0,0,null,null,0]
[null,"2022 Q1",5.7000000000000002E-3,2.7199999999999998E-2,null,"2019-05-01",2019,"Q2","2019 Q2",0,null,2.18E-2,0,0,null,null,0]
[null,"2022 Q2",1.0200000000000001E-2,3.3099999999999997E-2,null,"2019-06-01",2019,"Q2","2019 Q2",0,null,2.18E-2,0,0,null,null,0]
[null,"2022 Q3",2.1999999999999999E-2,4.6600000000000003E-2,null,"2019-07-01",2019,"Q3","2019 Q3",0,null,2.18E-2,0,0,null,null,0]
[null,"2022 Q4",3.8699999999999998E-2,5.0099999999999999E-2,null,"2019-08-01",2019,"Q3","2019 Q3",0,null,2.18E-2,0,0,null,null,0]
[null,"2023 Q1",4.7300000000000002E-2,5.0099999999999999E-2,null,"2019-09-01",2019,"Q3","2019 Q3",0,null,2.18E-2,0,0,null,null,0]
[null,"2023 Q2",4.9799999999999997E-2,5.0099999999999999E-2,null,"2019-10-01",2019,"Q4","2019 Q4",0,null,2.18E-2,0,0,null,null,0]
[null,"2023 Q3",4.9799999999999997E-2,5.0099999999999999E-2,null,"2019-11-01",2019,"Q4","2019 Q4",0,null,2.18E-2,0,0,null,null,0]
[null,"2023 Q4",5.4899999999999997E-2,5.4800000000000001E-2,null,"2019-12-01",2019,"Q4","2019 Q4",0,null,2.18E-2,0,0,null,null,0]
[null,"2024 Q1",5.4899999999999997E-2,5.4800000000000001E-2,null,"2020-01-01",2020,"Q1","2020 Q1",0,null,2.18E-2,{"$f":"ROUND(J48*L48/12,2)","v":0},{"$f":"N47+K48+M48","v":0},null,null,{"$f":"Q47+P48","v":0}]
[null,"2024 Q2",5.4899999999999997E-2,5.9799999999999999E-2,null,"2020-02-01",2020,"Q1","2020 Q1",0,null,2.18E-2,0,0,null,null,0]
[null,"2024 Q3",5.1999999999999998E-2,5.9799999999999999E-2,null,"2020-03-01",2020,"Q1","2020 Q1",0,null,2.18E-2,0,0,null,null,0]
[null,"2024 Q4",4.3999999999999997E-2,4.5499999999999999E-2,null,"2020-04-01",2020,"Q2","2020 Q2",0,null,2.18E-2,0,0,null,null,0]
[null,"2025 Q1",3.6400000000000002E-2,4.2299999999999997E-2,null,"2020-05-01",2020,"Q2","2020 Q2",0,null,2.18E-2,0,0,null,null,0]
[null,"2025 Q2",3.1600000000000003E-2,4.2299999999999997E-2,null,"2020-06-01",2020,"Q2","2020 Q2",0,null,2.18E-2,0,0,null,null,0]
[null,"2025 Q3",{"$f":"C53","v":3.1600000000000003E-2},4.2299999999999997E-2,null,"2020-07-01",2020,"Q3","2020 Q3",0,null,5.7000000000000002E-3,0,0,null,null,0]
[null,"2025 Q4",{"$f":"C54","v":3.1600000000000003E-2},4.2299999999999997E-2,null,"2020-08-01",2020,"Q3","2020 Q3",0,null,5.7000000000000002E-3,0,0,null,null,0]
[null,"2026 Q1",3.1600000000000003E-2,4.2299999999999997E-2,null,"2020-09-01",2020,"Q3","2020 Q3",0,null,5.7000000000000002E-3,0,0,null,null,0]
[null,"2026 Q2",3.1600000000000003E-2,4.2299999999999997E-2,null,"2020-10-01",2020,"Q4","2020 Q4",0,null,5.7000000000000002E-3,0,0,null,null,0]
[null,"2026 Q3",3.1600000000000003E-2,4.2299999999999997E-2,null,"2020-11-01",2020,"Q4","2020 Q4",0,null,5.7000000000000002E-3,0,0,null,null,0]
[null,"2026 Q4",3.1600000000000003E-2,4.2299999999999997E-2,null,"2020-12-01",2020,{"$f":"IF(MONTH(F59)=0,\"\",IF(MONTH(F59)<4,\"Q1\",IF(MONTH(F59)<7,\"Q2\",IF(MONTH(F59)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2020 Q4",0,null,5.7000000000000002E-3,0,0,null,null,0]
[null,null,null,null,null,"2021-01-01",2021,"Q1","2021 Q1",{"$f":"J59+K59","v":0},null,{"$f":"VLOOKUP(I60,$B$22:$D$59,2)","v":5.7000000000000002E-3},0,0,null,null,0]
[null,"Note: 2025-2026 Interest rates are forecasted. ",null,null,null,"2021-02-01",2021,"Q1","2021 Q1",0,null,5.7000000000000002E-3,0,0,null,null,0]
[null,null,null,null,null,"2021-03-01",2021,"Q1","2021 Q1",0,null,5.7000000000000002E-3,0,0,null,null,0]
[null,null,null,null,null,"2021-04-01",2021,"Q2","2021 Q2",0,null,5.7000000000000002E-3,0,0,null,null,0]
[null,null,null,null,null,"2021-05-01",2021,"Q2","2021 Q2",0,null,5.7000000000000002E-3,0,0,null,null,0]
[null,null,null,null,null,"2021-06-01",2021,"Q2","2021 Q2",0,null,5.7000000000000002E-3,0,0,null,null,0]
[null,null,null,null,null,"2021-07-01",2021,"Q3","2021 Q3",0,null,5.7000000000000002E-3,0,0,null,null,0]
[null,null,null,null,null,"2021-08-01",2021,"Q3","2021 Q3",0,null,5.7000000000000002E-3,0,0,null,null,0]
[null,null,null,null,null,"2021-09-01",2021,"Q3","2021 Q3",0,null,5.7000000000000002E-3,0,0,null,null,0]
[null,null,null,null,null,"2021-10-01",2021,"Q4","2021 Q4",0,null,5.7000000000000002E-3,0,0,null,null,0]
[null,null,null,null,null,"2021-11-01",2021,"Q4","2021 Q4",0,null,5.7000000000000002E-3,0,0,null,null,0]
[null,null,null,null,null,"2021-12-01",2021,{"$f":"IF(MONTH(F71)=0,\"\",IF(MONTH(F71)<4,\"Q1\",IF(MONTH(F71)<7,\"Q2\",IF(MONTH(F71)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2021 Q4",0,null,5.7000000000000002E-3,0,0,null,null,0]
[null,null,null,null,null,"2022-01-01",{"$f":"YEAR(F72)","v":2022},{"$f":"IF(MONTH(F72)=0,\"\",IF(MONTH(F72)<4,\"Q1\",IF(MONTH(F72)<7,\"Q2\",IF(MONTH(F72)<10,\"Q3\",\"Q4\"))))","v":"Q1"},"2022 Q1",{"$f":"J71+K71","v":0},null,{"$f":"VLOOKUP(I72,$B$22:$D$59,2)","v":5.7000000000000002E-3},{"$f":"ROUND(J72*L72/12,2)","v":0},{"$f":"N71+K72+M72","v":0},null,null,{"$f":"Q71+P72","v":0}]
[null,null,null,null,null,"2022-02-01",2022,"Q1","2022 Q1",0,null,5.7000000000000002E-3,0,0,null,null,0]
[null,null,null,null,null,"2022-03-01",2022,"Q1","2022 Q1",0,null,5.7000000000000002E-3,0,0,null,null,0]
[null,null,null,null,null,"2022-04-01",2022,"Q2","2022 Q2",0,null,1.0200000000000001E-2,0,0,null,null,0]
[null,null,null,null,null,"2022-05-01",2022,"Q2","2022 Q2",0,null,1.0200000000000001E-2,0,0,null,null,0]
[null,null,null,null,null,"2022-06-01",2022,"Q2","2022 Q2",0,null,1.0200000000000001E-2,0,0,null,null,0]
[null,null,null,null,null,"2022-07-01",2022,"Q3","2022 Q3",0,null,2.1999999999999999E-2,0,0,null,null,0]
[null,null,null,null,null,"2022-08-01",2022,"Q3","2022 Q3",0,null,2.1999999999999999E-2,0,0,null,null,0]
[null,null,null,null,null,"2022-09-01",2022,"Q3","2022 Q3",0,null,2.1999999999999999E-2,0,0,null,null,0]
[null,null,null,null,null,"2022-10-01",2022,"Q4","2022 Q4",0,null,3.8699999999999998E-2,0,0,null,null,0]
[null,null,null,null,null,"2022-11-01",2022,"Q4","2022 Q4",0,null,3.8699999999999998E-2,0,0,null,null,0]
[null,null,null,null,null,"2022-12-01",2022,{"$f":"IF(MONTH(F83)=0,\"\",IF(MONTH(F83)<4,\"Q1\",IF(MONTH(F83)<7,\"Q2\",IF(MONTH(F83)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2022 Q4",0,null,3.8699999999999998E-2,0,0,null,null,0]
[null,null,null,null,null,"2023-01-01",{"$f":"YEAR(F84)","v":2023},{"$f":"IF(MONTH(F84)=0,\"\",IF(MONTH(F84)<4,\"Q1\",IF(MONTH(F84)<7,\"Q2\",IF(MONTH(F84)<10,\"Q3\",\"Q4\"))))","v":"Q1"},"2023 Q1",{"$f":"J83+K83","v":0},null,{"$f":"VLOOKUP(I84,$B$22:$D$59,2)","v":4.7300000000000002E-2},{"$f":"ROUND(J84*L84/12,2)","v":0},{"$f":"N83+K84+M84","v":0},null,null,{"$f":"Q83+P84","v":0}]
[null,null,null,null,null,"2023-02-01",2023,"Q1","2023 Q1",0,null,4.7300000000000002E-2,0,0,null,null,0]
[null,null,null,null,null,"2023-03-01",2023,"Q1","2023 Q1",0,null,4.7300000000000002E-2,0,0,null,null,0]
[null,null,null,null,null,"2023-04-01",2023,"Q2","2023 Q2",0,null,4.9799999999999997E-2,0,0,null,null,0]
[null,null,null,null,null,"2023-05-01",2023,"Q2","2023 Q2",0,null,4.9799999999999997E-2,0,0,null,null,0]
[null,null,null,null,null,"2023-06-01",2023,"Q2",{"$f":"CONCATENATE(G89,\" \",H89)","v":"2023 Q2"},0,null,4.9799999999999997E-2,0,0,null,null,0]
[null,null,null,null,null,"2023-07-01",2023,"Q3","2023 Q3",0,null,4.9799999999999997E-2,0,0,null,null,0]
[null,null,null,null,null,"2023-08-01",2023,"Q3","2023 Q3",0,null,4.9799999999999997E-2,0,0,null,null,0]
[null,null,null,null,null,"2023-09-01",2023,"Q3","2023 Q3",0,null,4.9799999999999997E-2,0,0,null,null,0]
[null,null,null,null,null,"2023-10-01",2023,"Q4","2023 Q4",0,null,5.4899999999999997E-2,0,0,null,null,0]
[null,null,null,null,null,"2023-11-01",2023,"Q4","2023 Q4",0,null,5.4899999999999997E-2,0,0,null,null,0]
[null,null,null,null,null,"2023-12-01",2023,{"$f":"IF(MONTH(F95)=0,\"\",IF(MONTH(F95)<4,\"Q1\",IF(MONTH(F95)<7,\"Q2\",IF(MONTH(F95)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2023 Q4",0,null,5.4899999999999997E-2,0,0,null,null,0]
[null,null,null,null,null,"2024-01-01",{"$f":"YEAR(F96)","v":2024},{"$f":"IF(MONTH(F96)=0,\"\",IF(MONTH(F96)<4,\"Q1\",IF(MONTH(F96)<7,\"Q2\",IF(MONTH(F96)<10,\"Q3\",\"Q4\"))))","v":"Q1"},"2024 Q1",{"$f":"J95+K95","v":0},null,{"$f":"VLOOKUP(I96,$B$22:$D$59,2)","v":5.4899999999999997E-2},{"$f":"ROUND(J96*L96/12,2)","v":0},{"$f":"N95+K96+M96","v":0},null,null,{"$f":"Q95+P96","v":0}]
[null,null,null,null,null,"2024-02-01",2024,"Q1","2024 Q1",0,null,5.4899999999999997E-2,0,0,null,null,0]
[null,null,null,null,null,"2024-03-01",2024,"Q1","2024 Q1",0,40970.69,5.4899999999999997E-2,0,40970.69,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},101969.54281657534]
[null,null,null,null,null,"2024-04-01",2024,"Q2","2024 Q2",40970.69,187418.32,5.4899999999999997E-2,187.44,228576.45,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},203939.08563315068]
[null,null,null,null,null,"2024-05-01",2024,"Q2","2024 Q2",228389.01,122872.47,5.4899999999999997E-2,1044.8800000000001,352493.80000000005,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},305908.62844972603]
[null,null,null,null,null,"2024-06-01",2024,"Q2","2024 Q2",351261.48,122101.56,5.4899999999999997E-2,1607.02,476202.38000000006,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},407878.17126630136]
[null,null,null,null,null,"2024-07-01",2024,"Q3","2024 Q3",473363.04,124489.94,5.1999999999999998E-2,2051.2399999999998,602743.56000000006,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},509847.71408287669]
[null,null,null,null,null,"2024-08-01",2024,"Q3","2024 Q3",597852.98,124923.42,5.1999999999999998E-2,2590.6999999999998,730257.68,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},611817.25689945207]
[null,null,null,null,null,"2024-09-01",2024,"Q3","2024 Q3",722776.4,119344.95,5.1999999999999998E-2,3132.03,852734.66,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},713786.79971602745]
[null,null,null,null,null,"2024-10-01",2024,"Q4","2024 Q4",842121.35,117806.66,4.3999999999999997E-2,3087.78,973629.10000000009,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},815756.34253260284]
[null,null,null,null,null,"2024-11-01",2024,"Q4","2024 Q4",959928.01,118558.09,4.3999999999999997E-2,3519.74,1095706.9300000002,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},917725.88534917822]
[null,null,null,null,null,"2024-12-01",2024,{"$f":"IF(MONTH(F107)=0,\"\",IF(MONTH(F107)<4,\"Q1\",IF(MONTH(F107)<7,\"Q2\",IF(MONTH(F107)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2024 Q4",1078486.1000000001,119534.41,4.3999999999999997E-2,3954.45,1219195.79,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},1019695.4281657536]
[null,null,null,null,null,"2025-01-01",{"$f":"YEAR(F108)","v":2025},{"$f":"IF(MONTH(F108)=0,\"\",IF(MONTH(F108)<4,\"Q1\",IF(MONTH(F108)<7,\"Q2\",IF(MONTH(F108)<10,\"Q3\",\"Q4\"))))","v":"Q1"},"2025 Q1",{"$f":"J107+K107","v":1198020.51},114808.45999999999,{"$f":"VLOOKUP(I108,$B$22:$D$59,2)","v":3.6400000000000002E-2},{"$f":"ROUND(J108*L108/12,2)","v":3634},{"$f":"N107+K108+M108","v":1337638.25},null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},{"$f":"Q107+P108","v":1121664.970982329}]
[null,null,null,null,null,"2025-02-01",2025,"Q1","2025 Q1",1312828.97,84948.12999999999,3.6400000000000002E-2,3982.25,1426568.63,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},1223634.5137989044]
[null,null,null,null,null,"2025-03-01",2025,"Q1","2025 Q1",1397777.0999999999,104254.23000000001,3.6400000000000002E-2,4239.92,1535062.7799999998,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},1325604.0566154798]
[null,null,null,null,null,"2025-04-01",2025,"Q2","2025 Q2",1502031.3299999998,98314.349999999991,3.1600000000000003E-2,3955.35,1637332.48,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},1427573.5994320551]
[null,null,null,null,null,"2025-05-01",2025,"Q2","2025 Q2",1600345.68,102535.55829260273,{"$f":"VLOOKUP(I112,$B$22:$D$59,2)","v":3.1600000000000003E-2},4214.24,1744082.2782926026,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},1529543.1422486305]
[null,null,null,null,null,"2025-06-01",2025,"Q2","2025 Q2",1702881.2382926026,103851.19529863013,3.1600000000000003E-2,4484.25,1852417.7235912327,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},1631512.6850652059]
[null,null,null,null,null,"2025-07-01",2025,"Q3","2025 Q3",1806732.4335912326,110000.75535123287,3.1600000000000003E-2,4757.7299999999996,1967176.2089424655,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},1733482.2278817813]
[null,null,null,null,null,"2025-08-01",2025,"Q3","2025 Q3",1916733.1889424655,105068.56943561643,3.1600000000000003E-2,5047.3999999999996,2077292.1783780819,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},1835451.7706983567]
[null,null,null,null,null,"2025-09-01",2025,"Q3","2025 Q3",2021801.758378082,99872.429120547939,3.1600000000000003E-2,5324.08,2182488.68749863,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},1937421.3135149321]
[null,null,null,null,null,"2025-10-01",2025,"Q4","2025 Q4",2121674.18749863,103096.4009890411,3.1600000000000003E-2,5587.08,2291172.1684876713,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},2039390.8563315074]
[null,null,null,null,null,"2025-11-01",2025,"Q4","2025 Q4",2224770.5884876712,101465.32222465753,3.1600000000000003E-2,5858.56,2398496.0507123289,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},2141360.3991480828]
[null,null,null,null,null,"2025-12-01",2025,{"$f":"IF(MONTH(F119)=0,\"\",IF(MONTH(F119)<4,\"Q1\",IF(MONTH(F119)<7,\"Q2\",IF(MONTH(F119)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2025 Q4",2326235.9107123287,104312.34398246575,3.1600000000000003E-2,6125.75,2508934.1446947944,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},2243329.941964658]
[null,null,null,null,null,"2026-01-01",{"$f":"YEAR(F120)","v":2026},{"$f":"IF(MONTH(F120)=0,\"\",IF(MONTH(F120)<4,\"Q1\",IF(MONTH(F120)<7,\"Q2\",IF(MONTH(F120)<10,\"Q3\",\"Q4\"))))","v":"Q1"},"2026 Q1",{"$f":"J119+K119","v":2430548.2546947943},104258.79732438357,{"$f":"VLOOKUP(I120,$B$22:$D$59,2)","v":3.1600000000000003E-2},{"$f":"ROUND(J120*L120/12,2)","v":6400.44},{"$f":"N119+K120+M120","v":2619593.382019178},null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},{"$f":"Q119+P120","v":2345299.4847812331}]
[null,null,null,null,null,"2026-02-01",2026,"Q1","2026 Q1",2534807.0520191779,93768.735473424662,3.1600000000000003E-2,6674.99,2720037.1074926029,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},2447269.0275978083]
[null,null,null,null,null,"2026-03-01",2026,"Q1","2026 Q1",2628575.7874926026,102604.12919452054,3.1600000000000003E-2,6921.92,2829563.1566871232,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},2549238.5704143834]
[null,null,null,null,null,"2026-04-01",2026,"Q2","2026 Q2",2731179.916687123,100389.52251232875,3.1600000000000003E-2,7192.11,2937144.7891994519,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},2651208.1132309586]
[null,null,null,null,null,"2026-05-01",2026,"Q2","2026 Q2",2831569.4391994518,103208.88901917808,3.1600000000000003E-2,7456.47,3047810.1482186303,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},2753177.6560475337]
[null,null,null,null,null,"2026-06-01",2026,"Q2","2026 Q2",2934778.32821863,104559.05686575342,3.1600000000000003E-2,7728.25,3160097.455084384,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},2855147.1988641089]
[null,null,null,null,null,"2026-07-01",2026,"Q3","2026 Q3",3039337.3850843837,110780.33402301368,3.1600000000000003E-2,8003.59,3278881.3791073975,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},2957116.741680684]
[null,null,null,null,null,"2026-08-01",2026,"Q3","2026 Q3",3150117.7191073974,105787.62415506851,3.1600000000000003E-2,8295.31,3392964.3132624659,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},3059086.2844972592]
[null,null,null,null,null,"2026-09-01",2026,"Q3","2026 Q3",3255905.3432624657,100503.51287123287,3.1600000000000003E-2,8573.8799999999992,3502041.7061336986,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},3161055.8273138343]
[null,null,null,null,null,"2026-10-01",2026,"Q4","2026 Q4",3356408.8561336985,103727.42638191783,3.1600000000000003E-2,8838.5400000000009,3614607.6725156163,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},3263025.3701304095]
[null,null,null,null,null,"2026-11-01",2026,"Q4","2026 Q4",3460136.2825156162,102094.42509315067,3.1600000000000003E-2,9111.69,3725813.7876087669,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},3364994.9129469846]
[null,null,null,null,null,"2026-12-01",2026,{"$f":"IF(MONTH(F131)=0,\"\",IF(MONTH(F131)<4,\"Q1\",IF(MONTH(F131)<7,\"Q2\",IF(MONTH(F131)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2026 Q4",3562230.7076087669,104950.46865917806,3.1600000000000003E-2,9380.5400000000009,3840144.7962679449,null,{"$f":"'6. ICMIRR_2024'!$K$88/12","v":101969.54281657534},3466964.4557635598]

{"sheet":"8. Opex Interest Annual","index":7,"n_rows":42,"n_cols":14,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This worksheet calculates the interest on amortization/depreciation expense, in the absence of monthly data."]
[]
[]
[null,"Sheet 8: Interest on Amortization (Annual Data) "]
[]
[]
[]
[]
[null,"Year",null,"OM&A",null,"Amortization Expense",null,"Cumulative OM&A and Amortization Expense",null,"Average Cumulative OM&A and Amortization Expense",null,"Average Annual Prescribed Interest Rate for Deferral and Variance Accounts (from Sheet 7)",null,"Simple Interest on OM&A and Amortization Expenses"]
[null,null,null,null,null,"(from Sheet 4)"]
[null,2018,null,0,null,null,null,{"$f":"D23+F23","v":0},null,{"$f":"H23/2","v":0},null,{"$f":"AVERAGE('7. Rate Riders Revs'!C24:C27)","v":1.8624999999999999E-2},null,{"$f":"J23*L23","v":0}]
[null,2019,null,0,null,null,null,{"$f":"H23+D24+F24","v":0},null,{"$f":"(H24+H23)/2","v":0},null,{"$f":"AVERAGE('7. Rate Riders Revs'!C28:C31)","v":2.2474999999999998E-2},null,{"$f":"J24*L24","v":0}]
[null,2020,null,0,null,null,null,{"$f":"H24+D25+F25","v":0},null,{"$f":"(H25+H24)/2","v":0},null,{"$f":"AVERAGE('7. Rate Riders Revs'!C32:C35)","v":1.3749999999999998E-2},null,0]
[null,2021,null,0,null,null,null,0,null,0,null,{"$f":"AVERAGE('7. Rate Riders Revs'!C36:C39)","v":5.7000000000000002E-3},null,0]
[null,2022,null,0,null,null,null,{"$f":"H26+D27+F27","v":0},null,0,null,{"$f":"AVERAGE('7. Rate Riders Revs'!C40:C43)","v":1.915E-2},null,0]
[null,2023,null,0,null,null,null,0,null,0,null,{"$f":"AVERAGE('7. Rate Riders Revs'!C44:C47)","v":5.0449999999999995E-2},null,0]
[null,2024,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!I357","v":315893.89431582944},null,315893.89431582944,null,157946.94715791472,null,{"$f":"AVERAGE('7. Rate Riders Revs'!C48:C51)","v":5.1449999999999996E-2},null,8126.3704312747113]
[null,2025,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!K357","v":463418.62417857139},null,779312.51849440089,null,547603.2064051152,null,{"$f":"AVERAGE('7. Rate Riders Revs'!C52:C55)","v":3.2800000000000003E-2},null,17961.385170087779]
[null,2026,null,0,null,{"$f":"F30","v":463418.62417857139},null,1242731.1426729723,null,1011021.8305836866,null,{"$f":"AVERAGE('7. Rate Riders Revs'!C56:C59)","v":3.1600000000000003E-2},null,{"$f":"J31*L31","v":31948.289846444499}]
[]
[]
[null,"Cumulative Interest to 2018",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N23)","v":0}]
[null,"Cumulative Interest to 2019",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N24)","v":0}]
[null,"Cumulative Interest to 2020",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N25)","v":0}]
[null,"Cumulative Interest to 2021",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N26)","v":0}]
[null,"Cumulative Interest to 2022",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N27)","v":0}]
[null,"Cumulative Interest to 2023",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N28)","v":0}]
[null,"Cumulative Interest to 2024",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N29)","v":8126.3704312747113}]
[null,"Cumulative Interest to 2025",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N30)","v":26087.755601362489}]
[null,"Cumulative Interest to 2026",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N31)","v":58036.045447806988}]

{"sheet":"9. IRR","index":8,"n_rows":31,"n_cols":25,"rows_kept":31,"cut":false,"hidden":false,"merged":[[13,1,13,26],[19,2,19,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This worksheet calculates the ICM Incremental Revenue Requirement."]
[]
[]
[null,"Sheet 9: ICM Incremental Revenue Requirement"]
[null,null," "]
[]
[null,null,null,null,null,null,2018,null,2019,null,2020,null,2021,null,2022,null,2023,null,2024,null,2025,null,2026,null,"Total"]
[]
[null,null,"Deferred and forecasted ICM Incremental Revenue Requirement (from Sheet 6)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'6. ICMIRR_2024'!$F$88","v":995156.58769996185},null,{"$f":"'6. ICMIRR_2024'!$F$88","v":995156.58769996185},null,{"$f":"'6. ICMIRR_2024'!$F$88","v":995156.58769996185},null,{"$f":"SUM(G22:W22)","v":2985469.7630998855}]
[]
[null,null,"Interest on Deferred and forecasted Amortization Expense (Sheet 8)",null,null,null,{"$f":"'8. Opex Interest Annual'!$N$23","v":0},null,{"$f":"'8. Opex Interest Annual'!$N$24","v":0},null,{"$f":"'8. Opex Interest Annual'!$N$25","v":0},null,{"$f":"'8. Opex Interest Annual'!$N$26","v":0},null,{"$f":"'8. Opex Interest Annual'!$N$27","v":0},null,{"$f":"'8. Opex Interest Annual'!$N$28","v":0},null,{"$f":"'8. Opex Interest Annual'!$N$29","v":8126.3704312747113},null,{"$f":"'8. Opex Interest Annual'!$N$30","v":17961.385170087779},null,{"$f":"'8. Opex Interest Annual'!$N$31","v":31948.289846444499},null,{"$f":"SUM(G24:W24)","v":58036.045447806988}]
[]
[]
[null,null,"ICM Rate Rider Revenues (from Sheet 7)",null,null,null,{"$f":"SUM('7. Rate Riders Revs'!K26:K35)","v":0},null,{"$f":"SUM('7. Rate Riders Revs'!K36:K47)","v":0},null,{"$f":"SUM('7. Rate Riders Revs'!K48:K59)","v":0},null,{"$f":"SUM('7. Rate Riders Revs'!K60:K71)","v":0},null,{"$f":"SUM('7. Rate Riders Revs'!K72:K83)","v":0},null,{"$f":"SUM('7. Rate Riders Revs'!K84:K95)","v":0},null,{"$f":"SUM('7. Rate Riders Revs'!K96:K107)","v":1198020.51},null,{"$f":"SUM('7. Rate Riders Revs'!K108:K119)","v":1232527.7446947943},null,{"$f":"SUM('7. Rate Riders Revs'!K120:K131)","v":1236632.9215731507},null,{"$f":"SUM(G27:W27)","v":3667181.1762679452}]
[]
[null,null,"ICM Rate Rider Interest (from Sheet 7)",null,null,null,{"$f":"SUM('7. Rate Riders Revs'!M27:M35)","v":0},null,{"$f":"SUM('7. Rate Riders Revs'!M36:M47)","v":0},null,{"$f":"SUM('7. Rate Riders Revs'!M48:M59)","v":0},null,{"$f":"SUM('7. Rate Riders Revs'!M60:M71)","v":0},null,{"$f":"SUM('7. Rate Riders Revs'!M72:M83)","v":0},null,{"$f":"SUM('7. Rate Riders Revs'!M84:M95)","v":0},null,{"$f":"SUM('7. Rate Riders Revs'!M96:M107)","v":21175.280000000002},null,{"$f":"SUM('7. Rate Riders Revs'!M108:M119)","v":57210.61},null,{"$f":"SUM('7. Rate Riders Revs'!M120:M131)","v":94577.73000000001},null,{"$f":"SUM(G29:W29)","v":172963.62}]
[]
[null,null,"Net Deferred Revenue Requirement",null,null,null,{"$f":"(G22+G24)-(G27+G29)","v":0},null,{"$f":"(I22+I24)-(I27+I29)","v":0},null,{"$f":"(K22+K24)-(K27+K29)","v":0},null,{"$f":"(M22+M24)-(M27+M29)","v":0},null,{"$f":"(O22+O24)-(O27+O29)","v":0},null,{"$f":"(Q22+Q24)-(Q27+Q29)","v":0},null,{"$f":"(S22+S24)-(S27+S29)","v":-215912.83186876343},null,{"$f":"(U22+U24)-(U27+U29)","v":-276620.38182474475},null,{"$f":"(W22+W24)-(W27+W29)","v":-304105.7740267443},null,{"$f":"(Y22+Y24)-(Y27+Y29)","v":-796638.98772025295}]