{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["ORTP Summary","BLS","BB LCOE","RECs","ICE","Controls & Results","Assumptions","Construction CF","Model","Capital Costs","E&AS","PFP","Scarcity","MACRS","Depreciation"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":56,"comments":2,"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":"ORTP Summary","index":0,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[4,1,4,6],[2,1,2,6]]}
[]
[]
[null,"ISO-NE PUBLIC"]
[]
[null,"Summary of 2026-2027 ORTPs"]
[]
[]
[null,"Reference","CT","CC","Onshore Wind","Solar","Battery"]
[null,"Total Plant Capital Cost ($MM)",{"$f":"319765785.874606/1000000","v":319.76578587460602},{"$f":"599104967.944856/1000000","v":599.10496794485607},{"$f":"179859959.048784/1000000","v":179.85995904878399},{"$f":"27630352.5825819/1000000","v":27.630352582581899},{"$f":"136989533.994627/1000000","v":136.98953399462701}]
[null,"Gross CONE ($/kW-mo installed)",9.5045528472199834,13.168364771204683,18.50448690341576,8.943772631943137,8.5129501878440674]
[null,"Revenue Offset ($/kW-mo installed)",4.5012396448868426,4.3705023274637016,30.339875416544011,12.078635794400576,7.723963583112889]
[null,"Net CONE ($/kW-mo installed)",5.0033132023331408,8.797862443740982,-11.835388513128251,-3.1348631624574388,0.78898660473117843]
[null,"Net CONE ($/kW-mo qualified)",5.2119999999999997,9.7750000000000004,-30.099,-16.622,0.78900000000000003]
[null,"Final ORTP 2026-2027 ($/kW-mo)",5.2119999999999997,9.7750000000000004,0,0,0.78900000000000003]
[]
[]
[]
[]
[]
[]
[null,"DROP DOWN LIST FOR CONTROLS & RESULTS"]
[null,"CC - ORTP"]
[null,"SC - ORTP"]
[null,"Onshore Wind - ORTP"]
[null,"Solar - ORTP"]
[null,"Battery - ORTP"]

{"sheet":"BLS","index":1,"n_rows":77,"n_cols":9,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,0,0,12]]}
["PPI Commodity Data"]
[]
["Series Title","PPI Commodity data for Machinery and equipment-General purpose machinery and equipment, not seasonally adjusted"]
["Series ID","WPU114"]
["Seasonality","Not Seasonally Adjusted",null,null,null,null,null,null,"(1) For the simple cycle combustion turbine and combined cycle gas turbine technology types, each line item associated with capital costs that is included in the capital budgeting model will be updated to reflect changes in the Bureau of Labor Statistics Producer Price Index for Machinery and Equipment: General Purpose Machinery and Equipment (WPU114)."]
["Survey Name","PPI Commodity Data"]
["Measure Data Type","General purpose machinery and equipment"]
["Sector","Machinery and equipment"]
["Item","General purpose machinery and equipment"]
[]
[]
["Year","Period","Label","Observation Value"]
["2017","M01","2017 Jan",229.4]
["2017","M02","2017 Feb",230.3]
["2017","M03","2017 Mar",230.8]
["2017","M04","2017 Apr",230.8]
["2017","M05","2017 May",231.1]
["2017","M06","2017 Jun",231.3]
["2017","M07","2017 Jul",231.6]
["2017","M08","2017 Aug",231.9]
["2017","M09","2017 Sep",232.3]
["2017","M10","2017 Oct",232.9]
["2017","M11","2017 Nov",233.1]
["2017","M12","2017 Dec",233.3]
["2018","M01","2018 Jan",234.8]
["2018","M02","2018 Feb",235.4]
["2018","M03","2018 Mar",236.4]
["2018","M04","2018 Apr",236.7]
["2018","M05","2018 May",238.1]
["2018","M06","2018 Jun",238.9]
["2018","M07","2018 Jul",239.9]
["2018","M08","2018 Aug",240.6]
["2018","M09","2018 Sep",241.4]
["2018","M10","2018 Oct",242.4]
["2018","M11","2018 Nov",242.8]
["2018","M12","2018 Dec",242.9]
["2019","M01","2019 Jan",244.7]
["2019","M02","2019 Feb",245.1]
["2019","M03","2019 Mar",246]
["2019","M04","2019 Apr",247]
["2019","M05","2019 May",247]
["2019","M06","2019 Jun",247.4]
["2019","M07","2019 Jul",247.8]
["2019","M08","2019 Aug",247.6]
["2019","M09","2019 Sep",247.8]
["2019","M10","2019 Oct",248]
["2019","M11","2019 Nov",248.2]
["2019","M12","2019 Dec",248.3]
["2020","M01","2020 Jan",249.3]
["2020","M02","2020 Feb",249.7]
["2020","M03","2020 Mar",250.7]
["2020","M04","2020 Apr",250.9]
["2020","M05","2020 May",250.7]
["2020","M06","2020 Jun",250.9]
["2020","M07","2020 Jul",250.9]
["2020","M08","2020 Aug",251.4]
["2020","M09","2020 Sep",251.3]
["2020","M10","2020 Oct",251.9]
["2020","M11","2020 Nov",252.1]
["2020","M12","2020 Dec",252.6]
["2021","M01","2021 Jan",254.8]
["2021","M02","2021 Feb",255.9]
["2021","M03","2021 Mar",257.10000000000002]
["2021","M04","2021 Apr",258]
["2021","M05","2021 May",260.3]
["2021","M06","2021 Jun",263.2]
["2021","M07","2021 Jul",266.41300000000001]
["2021","M08","2021 Aug",268.54599999999999]
["2021","M09","2021 Sep",271.35399999999998]
["2021","M10","2021 Oct",274.13900000000001]
["2021","M11","2021 Nov",275.99]
[null,"M12","2021 Dec",278.26299999999998]
[]
[null,null,null,{"$f":"D75/D77","v":1.040694557934303},"Multiplier equal to the"]
[null,null,null,{"$f":"AVERAGE(D61:D72)","v":265.33375000000001}," average of values published during the most recent 12 month period available at the time of making the adjustment"]
[null,null,null,null,"Divided by the"]
[null,null,null,{"$f":"AVERAGE($D$55:$D$66)","v":254.95833333333334},"average of the most recent 12 month period available at the time of establishing the Offer Review Trigger Prices reflected in the table in Section III.A.21.1.1."]

{"sheet":"BB LCOE","index":2,"n_rows":12,"n_cols":17,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,16]]}
["Multiplier","LCOE per Technology Type (2019$/MWh), US Market"]
[]
[null,"Technology","2021-06-30","2020-12-31","2020-06-30","2019-12-31","2019-06-30","2018-12-31","2018-06-30","2017-12-31","2017-06-30","2016-12-31","2016-06-30","2015-12-31","2015-06-30","2014-12-31","2014-06-30"]
[{"$f":"AVERAGE(D4,C4)/AVERAGE(E4,F4)","v":0.90370227745152265},"PV non-tracking",38.870412000000002,45.696772000000003,45.103814999999997,48.474773999999996,54.598790999999999,56.851199999999999,54.820799999999998,62.247723999999998,69.674648000000005,83.481566000000001,92.530683999999994,115.302812,143.08556799999999,147.99193600000001,144.950164]
[{"$f":"C5/D5","v":0.93410989992234716},"Utility-scale battery",118.516293,126.876177]
[{"$f":"AVERAGE(D6,C6)/AVERAGE(E6,F6)","v":0.9862802609812451},"Wind onshore",35.894683999999998,36.719352999999998,37.232002999999999,36.392138000000003,37.722800999999997,39.592799999999997,40.607999999999997,46.821962999999997,53.035926000000003,59.887554999999999,69.479269000000002,71.756243999999995,72.655073999999999,84.008206999999999,113.292243]
[]
[]
[]
[]
[null,"For all other Generating Capacity Resource technology types, each line item associated with capital costs that is included in the capital budgeting model will be updated to reflect changes in the levelized cost of energy for that technology as published by Bloomberg."]
[null,"Technologies = Onshore wind, ESD/Lithium Ion, PV solar (tracking)"]

{"sheet":"RECs","index":3,"n_rows":234,"n_cols":6,"rows_kept":234,"cut":false,"hidden":false,"merged":[[532,0,533,5],[534,0,537,5]]}
[]
["Renewable Energy Credits (Data)"]
["Historical Period:  10 Years"]
["Location: MA Class I"]
["Instrument: All"]
["Inflation",0.02]
["2026$ 5-year Average",{"$f":"AVERAGE(B9:F9)","v":39.701822231072057}]
["Inflation adjustment to CCP dollar year",2026]
["2026$ Average",{"$f":"B10*(1+$B$6)^($B$8-B11)","v":38.53246248},{"$f":"C10*(1+$B$6)^($B$8-C11)","v":41.931326848412908},45.416547853099203,{"$f":"E10*(1+$B$6)^($B$8-E11)","v":44.723123481537876},27.905650492310279]
["Nominal Average",{"$f":"AVERAGE(B13:B227)","v":36.31},{"$f":"AVERAGE(C13:C227)","v":38.738064516129036},{"$f":"AVERAGE(D13:D227)","v":41.13516666666667},{"$f":"AVERAGE(E13:E227)","v":39.712853773584925},{"$f":"AVERAGE(F13:F227)","v":24.293548076923091}]
["Dollar Year",2023,2022,2021,2020,2019]
["Date","MA Class I REC Index 2023","MA Class I REC Index 2022","MA Class I REC Index 2021","MA Class I REC Index 2020","MA Class I REC Index 2019"]
["02/04/2022",36.31,38.31,37.130000000000003]
["01/28/2022",36.31,38.6875,38.125]
["01/21/2022",null,38.8125,39.25]
["01/14/2022",null,38.8125,39.75]
["01/07/2022",null,38.8125,39.75]
["12/24/2021",null,38.875,40]
["12/17/2021",null,38.875,40]
["12/10/2021",null,38.875,40]
["12/03/2021",null,38.375,40]
["11/26/2021",null,38.375,40]
["11/19/2021",null,38.375,39.25]
["11/12/2021",null,38.9375,39.75]
["11/05/2021",null,39.6875,41.125]
["10/29/2021",null,39.625,41.75]
["10/22/2021",null,39.75,42.125]
["10/15/2021",null,39.75,42.75]
["10/08/2021",null,39.8125,41.375]
["10/01/2021",null,39.5625,40.8125]
["09/24/2021",null,38.625,39.75]
["09/17/2021",null,38.19,38.5]
["09/10/2021",null,38.125,38.375]
["09/03/2021",null,36.25,36.875]
["08/27/2021",null,38.125,38.4375]
["08/20/2021",null,38.125,38.4375]
["08/13/2021",null,38.125,38.5]
["08/06/2021",null,38.380000000000003,39]
["07/30/2021",null,38.375,39]
["07/23/2021",null,38.375,39]
["07/16/2021",null,38.625,39.1875]
["07/09/2021",null,39.625,39.8125]
["07/02/2021",null,39.625,39.8125]
["06/25/2021",null,null,39.25,35.75]
["06/18/2021",null,null,38.9375,36.375]
["06/11/2021",null,null,40.125,35.75]
["06/04/2021",null,null,39.875,34]
["05/28/2021",null,null,39.625,32]
["05/21/2021",null,null,40.375,39.875]
["05/14/2021",null,null,40.8125,41.3125]
["05/07/2021",null,null,40.5,41.125]
["04/30/2021",null,null,43.125,42.6875]
["04/23/2021",null,null,43.75,42.9375]
["04/16/2021",null,null,45.375,48]
["04/09/2021",null,null,45.375,48.5]
["04/02/2021",null,null,44.5,47.375]
["03/26/2021",null,null,44.5,46.875]
["03/19/2021",null,null,43.875,46.375]
["03/12/2021",null,null,41.75,44.5]
["03/05/2021",null,null,39.8125,42.375]
["02/26/2021",null,null,40.0625,42.5]
["02/19/2021",null,null,39.625,42.125]
["02/12/2021",null,null,39.625,42.125]
["02/05/2021",null,null,40.4375,42.5]
["01/29/2021",null,null,40.4375,43.375]
["01/22/2021",null,null,40.4375,43.875]
["01/15/2021",null,null,40.4375,44.375]
["01/08/2021",null,null,41.125,44.1875]
["01/01/2021",null,null,41.75,43.5625]
["12/25/2020",null,null,41.375,43.3125]
["12/18/2020",null,null,41.375,43.125]
["12/11/2020",null,null,42.4375,44]
["12/04/2020",null,null,43.5,44.875]
["11/27/2020",null,null,43.5,45.375]
["11/20/2020",null,null,43.5,45.375]
["11/13/2020",null,null,43.375,44.4375]
["11/06/2020",null,null,43.1666666666667,45.125]
["10/30/2020",null,null,43.25,45.13]
["10/23/2020",null,null,43.3333333333333,45.6666666666667]
["10/16/2020",null,null,43.08,46.13]
["10/09/2020",null,null,43.08,46]
["10/02/2020",null,null,42.6666666666667,46.0833333333333]
["09/25/2020",null,null,42.46,46.29]
["09/18/2020",null,null,42.67,46.17]
["09/11/2020",null,null,41.46,43.33]
["09/04/2020",null,null,41.21,41.75]
["08/28/2020",null,null,41.21,41.25]
["08/21/2020",null,null,41.67,42]
["08/14/2020",null,null,42,43.08]
["08/07/2020",null,null,42.54,43.75]
["07/31/2020",null,null,42.63,44.29]
["07/24/2020",null,null,42.54,43.96]
["07/17/2020",null,null,43.79,42.88]
["07/10/2020",null,null,44.33,44.79]
["07/03/2020",null,null,44.21,44.75]
["06/26/2020",null,null,43.04,44.33]
["06/19/2020",null,null,39.96,42.58]
["06/12/2020",null,null,null,41.54,45.5]
["06/05/2020",null,null,null,41.5416666666667,42]
["05/29/2020",null,null,null,41.29,48.17]
["05/22/2020",null,null,null,41.1666666666667,49.9166666666667]
["05/15/2020",null,null,null,37.58,36.58]
["05/08/2020",null,null,null,31.04,29.04]
["05/01/2020",null,null,null,30.25,28.4166666666667]
["04/24/2020",null,null,null,30.75,24.3333333333333]
["04/17/2020",null,null,null,27.9166666666667,23.2916666666667]
["04/10/2020",null,null,null,27.8333333333333,25.5833333333333]
["04/03/2020",null,null,null,32.96875,30.1666666666667]
["03/27/2020",null,null,null,31.3333333333333,30.2916666666667]
["03/20/2020",null,null,null,31.9166666666667,30.8333333333333]
["03/13/2020",null,null,null,39.6666666666667,36.625]
["03/06/2020",null,null,null,39.4583333333333,36.875]
["02/28/2020",null,null,null,40.3333333333333,38.25]
["02/21/2020",null,null,null,40.5833333333333,39.0416666666667]
["02/14/2020",null,null,null,39.4583333333333,36.375]
["02/07/2020",null,null,null,38.5,34.4166666666667]
["01/31/2020",null,null,null,42.3333333333333,37.25]
["01/24/2020",null,null,null,41.8333333333333,37.5416666666667]
["01/17/2020",null,null,null,38.34375,35.4166666666667]
["01/10/2020",null,null,null,42.9375,40.4166666666667]
["01/03/2020",null,null,null,44.0625,42.4166666666667]
["12/27/2019",null,null,null,44.8125,43.125]
["12/20/2019",null,null,null,45.125,43.75]
["12/13/2019",null,null,null,44.875,41.6666666666667]
["12/06/2019",null,null,null,44.6666666666667,41.5416666666667]
["11/29/2019",null,null,null,43.3333333333333,39.75]
["11/22/2019",null,null,null,41.8333333333333,38.4166666666667]
["11/15/2019",null,null,null,40.4166666666667,37.1666666666667]
["11/08/2019",null,null,null,43.2916666666667,39.25]
["11/01/2019",null,null,null,46.29,40.75]
["10/25/2019",null,null,null,45.125,39.7916666666667]
["10/18/2019",null,null,null,41.9583333333333,38.625]
["10/11/2019",null,null,null,38.9583333333333,36.5]
["10/04/2019",null,null,null,36.875,34.4166666666667]
["09/27/2019",null,null,null,35.8333333333333,34.3333333333333]
["09/20/2019",null,null,null,35.2083333333333,34.2916666666667]
["09/13/2019",null,null,null,32.9583333333333,32.9166666666667]
["09/06/2019",null,null,null,30.2083333333333,29.875]
["08/30/2019",null,null,null,29.6666666666667,29.3333333333333]
["08/23/2019",null,null,null,28.9583333333333,28.4166666666667]
["08/16/2019",null,null,null,27.2916666666667,26.6666666666667]
["08/09/2019",null,null,null,26.5833333333333,25.1666666666667]
["08/02/2019",null,null,null,26.0416666666667,23.2083333333333]
["07/26/2019",null,null,null,27.75,25.75]
["07/19/2019",null,null,null,26.7083333333333,24.0416666666667]
["07/12/2019",null,null,null,25.9166666666667,22.75]
["07/05/2019",null,null,null,25.375,22.5833333333333]
["06/28/2019",null,null,null,23.216666666666701,20.5833333333333]
["06/21/2019",null,null,null,21.375,18.875]
["06/14/2019",null,null,null,null,18.9166666666667]
["06/07/2019",null,null,null,null,18.625]
["05/31/2019",null,null,null,null,18.7083333333333]
["05/24/2019",null,null,null,null,19.8333333333333]
["05/17/2019",null,null,null,null,22.4166666666667]
["05/10/2019",null,null,null,null,21.7916666666667]
["05/03/2019",null,null,null,null,20.625]
["04/26/2019",null,null,null,null,19.683333333333302]
["04/19/2019",null,null,null,null,17.7083333333333]
["04/12/2019",null,null,null,null,16.6666666666667]
["04/05/2019",null,null,null,null,14.875]
["03/29/2019",null,null,null,null,12.9166666666667]
["03/22/2019",null,null,null,null,12.116666666666699]
["03/15/2019",null,null,null,null,12.033333333333299]
["03/08/2019",null,null,null,null,12.0416666666667]
["03/01/2019",null,null,null,null,11.8333333333333]
["02/22/2019",null,null,null,null,13.6666666666667]
["02/15/2019",null,null,null,null,14.04]
["02/08/2019",null,null,null,null,14.33]
["02/01/2019",null,null,null,null,13.9583333333333]
["01/25/2019",null,null,null,null,14.25]
["01/18/2019",null,null,null,null,12.8333333333333]
["01/11/2019",null,null,null,null,12.1666666666667]
["01/04/2019",null,null,null,null,13]
["12/28/2018",null,null,null,null,13.5]
["12/21/2018",null,null,null,null,13.875]
["12/14/2018",null,null,null,null,13.108333333333301]
["12/07/2018",null,null,null,null,12.4166666666667]
["11/30/2018",null,null,null,null,12.625]
["11/23/2018",null,null,null,null,9]
["11/16/2018",null,null,null,null,8.65625]
["11/09/2018",null,null,null,null,7.125]
["11/02/2018",null,null,null,null,6.75]
["10/26/2018",null,null,null,null,7.1749999999999998]
["10/19/2018",null,null,null,null,7.1749999999999998]
["10/12/2018",null,null,null,null,8.0833333333333304]
["10/05/2018",null,null,null,null,8.5416666666666696]
["09/28/2018",null,null,null,null,8.6666666666666696]
["09/21/2018",null,null,null,null,8.7916666666666696]
["09/14/2018",null,null,null,null,8.875]
["09/07/2018",null,null,null,null,8.1750000000000007]
["08/31/2018",null,null,null,null,8.375]
["08/24/2018",null,null,null,null,9.4166666666666696]
["08/17/2018",null,null,null,null,10.875]
["08/10/2018",null,null,null,null,12.6666666666667]
["08/03/2018",null,null,null,null,15.0833333333333]
["07/27/2018",null,null,null,null,16.8333333333333]
["07/20/2018",null,null,null,null,17.5833333333333]
["07/13/2018",null,null,null,null,20.6666666666667]
["07/06/2018",null,null,null,null,24.1666666666667]
["06/29/2018",null,null,null,null,25.5416666666667]
["06/22/2018",null,null,null,null,25.5416666666667]
["06/15/2018",null,null,null,null,25.9583333333333]
["06/08/2018",null,null,null,null,25.875]
["06/01/2018",null,null,null,null,25.625]
["05/25/2018",null,null,null,null,25.8333333333333]
["05/18/2018",null,null,null,null,25.6666666666667]
["05/11/2018",null,null,null,null,26.5]
["05/04/2018",null,null,null,null,27.9583333333333]
["04/27/2018",null,null,null,null,28.5]
["04/20/2018",null,null,null,null,26.2916666666667]
["04/13/2018",null,null,null,null,25]
["04/06/2018",null,null,null,null,25.0833333333333]
["03/30/2018",null,null,null,null,25.3333333333333]
["03/23/2018",null,null,null,null,23.25]
["03/16/2018",null,null,null,null,23.6666666666667]
["03/09/2018",null,null,null,null,23.5833333333333]
["03/02/2018",null,null,null,null,23.5]
["02/23/2018",null,null,null,null,21.5]
["02/16/2018",null,null,null,null,21.3333333333333]
["02/09/2018",null,null,null,null,27.4583333333333]
["02/02/2018",null,null,null,null,28.0833333333333]
["01/26/2018",null,null,null,null,26.5416666666667]
["01/19/2018",null,null,null,null,26.2083333333333]
["01/12/2018",null,null,null,null,26.0833333333333]
["01/05/2018",null,null,null,null,24.2916666666667]
["12/29/2017",null,null,null,null,23.92]
["12/22/2017",null,null,null,null,24.5]
[]
["Data is compiled from a range of market indicatives and do not necessarily represent completed trades. CA RPS figures do not contain data from Evolution Markets.\n"]
[]
["California prices are representative of the renewable and environmental attributes used for compliance purposes with the state's renewable portfolio standard. CA prices do not include the value of electricity.\n"]
[]
[]
["Data for SNL RECs index provided by:\n    Evolution Markets: http://new.evomarkets.com/ \n    Tradition Financial Services: http://www.tfsbrokers.com/ \n    Clear Energy Brokerage and Consulting: http://www.clearenergybrokerage.com/ \n    Karbone: http://www.karbone.com/ \n\n"]

{"sheet":"ICE","index":4,"n_rows":100,"n_cols":14,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
["Futures Contracts As Of…"]
[null,"2020-08-31",null,null,null,null,null,null,"2021-02-07"]
[null,null,"a","b","a+b = c","d","e = d/c",null,null,"a","b","a+b = c","d","e = d/c"]
[null,null,"Henry Hub (H)","Algonquin CG Basis (ALQ)","Algonquin CG Delivered","MA Hub On-Peak (NEP)","Ratio",null,null,"Henry Hub (H)","Algonquin CG Basis (ALQ)","Algonquin CG Delivered","MA Hub On-Peak (NEP)","Ratio"]
[null,null,"($/MMBtu)","($/MMBtu)","($/MMBtu)","($/MWh)",null,null,null,"($/MMBtu)","($/MMBtu)","($/MMBtu)","($/MWh)"]
[null,"2024-06-01",2.3370000000000002,-9.7500000000000003E-2,{"$f":"C6+D6","v":2.2395},30.5,{"$f":"F6/E6","v":13.619111408796606},null,"2026-06-01",2.919,-0.41249999999999998,{"$f":"J6+K6","v":2.5065},38.200000000000003,{"$f":"M6/L6","v":15.240375024935171}]
[null,"2024-07-01",2.3780000000000001,0.08,{"$f":"C7+D7","v":2.4580000000000002},36.5,{"$f":"F7/E7","v":14.84947111472742},null,"2026-07-01",2.968,-0.23,{"$f":"J7+K7","v":2.738},49.55,{"$f":"M7/L7","v":18.097151205259312}]
[null,"2024-08-01",2.387,1.4999999999999999E-2,2.4020000000000001,34.450000000000003,14.342214820982514,null,"2026-08-01",2.9830000000000001,-0.3,2.6830000000000003,46.3,17.256802087215799]
[null,"2024-09-01",2.3820000000000001,-0.33500000000000002,2.0470000000000002,30.95,15.119687347337566,null,"2026-09-01",2.9809999999999999,-0.65,2.331,37.799999999999997,16.216216216216214]
[null,"2024-10-01",2.4129999999999998,-0.13,2.2829999999999999,31.1,13.622426631625055,null,"2026-10-01",3.0209999999999999,-0.44500000000000001,2.5760000000000001,38.85,15.081521739130435]
[null,"2024-11-01",2.496,1.3325,3.8285,40.6,10.604675460363067,null,"2026-11-01",3.161,1.9524999999999999,5.1135000000000002,47.95,9.377138945927447]
[null,"2024-12-01",2.6909999999999998,4.21,6.9009999999999998,60.6,8.7813360382553256,null,"2026-12-01",3.411,3.6625000000000001,7.0735000000000001,66.95,9.464904219975967]
[null,"2025-01-01",2.8050000000000002,5.68,8.4849999999999994,73.95,8.7153800824985286,null,"2027-01-01",3.5459999999999998,5.125,8.6709999999999994,103.6,11.947872217737286]
[null,"2025-02-01",2.77,5.6074999999999999,8.3774999999999995,71.2,8.4989555356609969,null,"2027-02-01",3.4809999999999999,4.9725000000000001,8.4535,98.75,11.681552019873426]
[null,"2025-03-01",2.641,2.7174999999999998,5.3584999999999994,50.55,9.4336101520948024,null,"2027-03-01",3.3359999999999999,3.5775000000000001,6.9135,56.65,8.1941129673826563]
[null,"2025-04-01",2.3460000000000001,0.58250000000000002,2.9285000000000001,32.9,11.234420351715894,null,"2027-04-01",2.9359999999999999,0.11,3.0459999999999998,43.05,14.133289560078792]
[null,"2025-05-01",2.3239999999999998,-0.1075,2.2164999999999999,29.35,13.241597112564856,null,"2027-05-01",2.9209999999999998,-0.47249999999999998,2.4484999999999997,37.549999999999997,15.335919950990403]
[]
[null,"Average",null,null,null,{"$f":"AVERAGEIF(F6:F17,\"<>#VALUE!\",F6:F17)","v":43.554166666666667},{"$f":"AVERAGEIF(G6:G17,\"<>#VALUE!\",G6:G17)","v":11.838573838051886},null,"Average",null,null,null,{"$f":"AVERAGEIF(M6:M17,\"<>#VALUE!\",M6:M17)","v":55.43333333333333},{"$f":"AVERAGEIF(N6:N17,\"<>#VALUE!\",N6:N17)","v":13.502238012893576}]
[]
[null,null,null,null,null,null,null,null,"2021-02-04"]
[null,null,null,null,null,null,null,null,null,"a","b","a+b = c","d","e = d/c"]
[null,null,null,null,null,null,null,null,null,"Henry Hub (H)","Algonquin CG Basis (ALQ)","Algonquin CG Delivered","MA Hub On-Peak (NEP)","Ratio"]
[null,null,null,null,null,null,null,null,null,"($/MMBtu)","($/MMBtu)","($/MMBtu)","($/MWh)"]
[null,null,null,null,null,null,null,null,"2026-06-01",2.903,-0.41249999999999998,{"$f":"J25+K25","v":2.4904999999999999},38.299999999999997,{"$f":"M25/L25","v":15.378438064645653}]
[null,null,null,null,null,null,null,null,"2026-07-01",2.95,-0.23,{"$f":"J26+K26","v":2.72},49.7,{"$f":"M26/L26","v":18.272058823529413}]
[null,null,null,null,null,null,null,null,"2026-08-01",2.9670000000000001,-0.3,2.6670000000000003,46.45,17.41657292838395]
[null,null,null,null,null,null,null,null,"2026-09-01",2.9649999999999999,-0.65,2.3149999999999999,37.950000000000003,16.393088552915767]
[null,null,null,null,null,null,null,null,"2026-10-01",3.0049999999999999,-0.44500000000000001,2.56,39,15.234375]
[null,null,null,null,null,null,null,null,"2026-11-01",3.145,1.9524999999999999,5.0975000000000001,48.1,9.4359980382540467]
[null,null,null,null,null,null,null,null,"2026-12-01",3.395,3.6625000000000001,7.0575000000000001,67.099999999999994,9.5076160113354575]
[null,null,null,null,null,null,null,null,"2027-01-01",3.53,5.125,8.6549999999999994,103.8,11.993067590987868]
[null,null,null,null,null,null,null,null,"2027-02-01",3.4649999999999999,4.9725000000000001,8.4375,98.95,11.727407407407409]
[null,null,null,null,null,null,null,null,"2027-03-01",3.32,3.5775000000000001,6.8975,56.8,8.2348677056904673]
[null,null,null,null,null,null,null,null,"2027-04-01",2.92,0.11,3.03,43.2,14.257425742574259]
[null,null,null,null,null,null,null,null,"2027-05-01",2.9049999999999998,-0.47249999999999998,2.4324999999999997,37.65,15.477903391572458]
[]
[null,null,null,null,null,null,null,null,"Average",null,null,null,{"$f":"AVERAGEIF(M25:M36,\"<>#VALUE!\",M25:M36)","v":55.583333333333336},{"$f":"AVERAGEIF(N25:N36,\"<>#VALUE!\",N25:N36)","v":13.610734938108061}]
[]
[null,null,null,null,null,null,null,null,"2021-02-03"]
[null,null,null,null,null,null,null,null,null,"a","b","a+b = c","d","e = d/c"]
[null,null,null,null,null,null,null,null,null,"Henry Hub (H)","Algonquin CG Basis (ALQ)","Algonquin CG Delivered","MA Hub On-Peak (NEP)","Ratio"]
[null,null,null,null,null,null,null,null,null,"($/MMBtu)","($/MMBtu)","($/MMBtu)","($/MWh)"]
[null,null,null,null,null,null,null,null,"2026-06-01",2.867,-0.41249999999999998,{"$f":"J44+K44","v":2.4544999999999999},38.35,{"$f":"M44/L44","v":15.624363414137299}]
[null,null,null,null,null,null,null,null,"2026-07-01",2.9140000000000001,-0.23,{"$f":"J45+K45","v":2.6840000000000002},49.75,{"$f":"M45/L45","v":18.535767511177347}]
[null,null,null,null,null,null,null,null,"2026-08-01",2.931,-0.3,2.6310000000000002,46.5,17.673888255416191]
[null,null,null,null,null,null,null,null,"2026-09-01",2.9289999999999998,-0.65,2.2789999999999999,38,16.673979815708645]
[null,null,null,null,null,null,null,null,"2026-10-01",2.9649999999999999,-0.44500000000000001,2.52,39.049999999999997,15.496031746031745]
[null,null,null,null,null,null,null,null,"2026-11-01",3.1,1.95,5.05,48.15,9.5346534653465351]
[null,null,null,null,null,null,null,null,"2026-12-01",3.35,3.66,7.01,67.150000000000006,9.5791726105563484]
[null,null,null,null,null,null,null,null,"2027-01-01",3.4849999999999999,5.1224999999999996,8.6074999999999999,103.85,12.065059541097879]
[null,null,null,null,null,null,null,null,"2027-02-01",3.4350000000000001,4.97,8.4049999999999994,99,11.778703152885189]
[null,null,null,null,null,null,null,null,"2027-03-01",3.29,3.5750000000000002,6.8650000000000002,56.85,8.2811361981063367]
[null,null,null,null,null,null,null,null,"2027-04-01",2.89,0.11,3,43.25,14.416666666666666]
[null,null,null,null,null,null,null,null,"2027-05-01",2.875,-0.47249999999999998,2.4024999999999999,37.700000000000003,15.691987513007286]
[]
[null,null,null,null,null,null,null,null,"Average",null,null,null,{"$f":"AVERAGEIF(M44:M55,\"<>#VALUE!\",M44:M55)","v":55.633333333333333},{"$f":"AVERAGEIF(N44:N55,\"<>#VALUE!\",N44:N55)","v":13.779284157511455}]
[]
[null,null,null,null,null,null,null,null,"2021-02-02"]
[null,null,null,null,null,null,null,null,null,"a","b","a+b = c","d","e = d/c"]
[null,null,null,null,null,null,null,null,null,"Henry Hub (H)","Algonquin CG Basis (ALQ)","Algonquin CG Delivered","MA Hub On-Peak (NEP)","Ratio"]
[null,null,null,null,null,null,null,null,null,"($/MMBtu)","($/MMBtu)","($/MMBtu)","($/MWh)"]
[null,null,null,null,null,null,null,null,"2026-06-01",2.8759999999999999,-0.41249999999999998,{"$f":"J63+K63","v":2.4634999999999998},38.700000000000003,{"$f":"M63/L63","v":15.709356606454234}]
[null,null,null,null,null,null,null,null,"2026-07-01",2.923,-0.23,{"$f":"J64+K64","v":2.6930000000000001},50.15,{"$f":"M64/L64","v":18.622354251763831}]
[null,null,null,null,null,null,null,null,"2026-08-01",2.94,-0.3,2.64,46.9,17.765151515151512]
[null,null,null,null,null,null,null,null,"2026-09-01",2.9380000000000002,-0.65,2.2880000000000003,38.35,16.761363636363637]
[null,null,null,null,null,null,null,null,"2026-10-01",2.9740000000000002,-0.44500000000000001,2.5290000000000004,39.4,15.579280347963619]
[null,null,null,null,null,null,null,null,"2026-11-01",3.109,1.95,5.0590000000000002,48.5,9.5868748764577969]
[null,null,null,null,null,null,null,null,"2026-12-01",3.359,3.66,7.0190000000000001,67.55,9.6238780453055988]
[null,null,null,null,null,null,null,null,"2027-01-01",3.4940000000000002,5.1224999999999996,8.6165000000000003,104.4,12.116288516218882]
[null,null,null,null,null,null,null,null,"2027-02-01",3.444,4.97,8.4139999999999997,99.55,11.831471357261707]
[null,null,null,null,null,null,null,null,"2027-03-01",3.2989999999999999,3.5750000000000002,6.8740000000000006,57.25,8.3284841431480938]
[null,null,null,null,null,null,null,null,"2027-04-01",2.899,0.11,3.0089999999999999,43.6,14.489863742107014]
[null,null,null,null,null,null,null,null,"2027-05-01",2.8839999999999999,-0.47249999999999998,2.4114999999999998,38.049999999999997,15.77856106157993]
[]
[null,null,null,null,null,null,null,null,"Average",null,null,null,{"$f":"AVERAGEIF(M63:M74,\"<>#VALUE!\",M63:M74)","v":56.033333333333331},{"$f":"AVERAGEIF(N63:N74,\"<>#VALUE!\",N63:N74)","v":13.849410674981321}]
[]
[null,null,null,null,null,null,null,null,"2021-02-01"]
[null,null,null,null,null,null,null,null,null,"a","b","a+b = c","d","e = d/c"]
[null,null,null,null,null,null,null,null,null,"Henry Hub (H)","Algonquin CG Basis (ALQ)","Algonquin CG Delivered","MA Hub On-Peak (NEP)","Ratio"]
[null,null,null,null,null,null,null,null,null,"($/MMBtu)","($/MMBtu)","($/MMBtu)","($/MWh)"]
[null,null,null,null,null,null,null,null,"2026-06-01",2.8570000000000002,-0.41249999999999998,{"$f":"J82+K82","v":2.4445000000000001},38.25,{"$f":"M82/L82","v":15.647371650644303}]
[null,null,null,null,null,null,null,null,"2026-07-01",2.9039999999999999,-0.23,{"$f":"J83+K83","v":2.6739999999999999},49.55,{"$f":"M83/L83","v":18.530291697830965}]
[null,null,null,null,null,null,null,null,"2026-08-01",2.9209999999999998,-0.3,2.621,46.35,17.684090041968716]
[null,null,null,null,null,null,null,null,"2026-09-01",2.919,-0.65,2.2690000000000001,37.85,16.681357426178934]
[null,null,null,null,null,null,null,null,"2026-10-01",2.9550000000000001,-0.44500000000000001,2.5100000000000002,38.9,15.498007968127489]
[null,null,null,null,null,null,null,null,"2026-11-01",3.09,1.95,5.04,48,9.5238095238095237]
[null,null,null,null,null,null,null,null,"2026-12-01",3.34,3.66,7,67,9.5714285714285712]
[null,null,null,null,null,null,null,null,"2027-01-01",3.4750000000000001,5.1224999999999996,8.5975000000000001,103.6,12.050014539110206]
[null,null,null,null,null,null,null,null,"2027-02-01",3.4249999999999998,4.97,8.3949999999999996,98.8,11.768910065515188]
[null,null,null,null,null,null,null,null,"2027-03-01",3.28,3.5750000000000002,6.8550000000000004,56.7,8.2713347921225377]
[null,null,null,null,null,null,null,null,"2027-04-01",2.88,0.11,2.9899999999999998,43.1,14.414715719063548]
[null,null,null,null,null,null,null,null,"2027-05-01",2.8650000000000002,-0.47249999999999998,2.3925000000000001,37.6,15.715778474399164]
[]
[null,null,null,null,null,null,null,null,"Average",null,null,null,{"$f":"AVERAGEIF(M82:M93,\"<>#VALUE!\",M82:M93)","v":55.475000000000001},{"$f":"AVERAGEIF(N82:N93,\"<>#VALUE!\",N82:N93)","v":13.779759205849928}]
[]
[null,"August 31, 2020 Average Ratio",null,null,null,{"$f":"F19","v":43.554166666666667},{"$f":"G19","v":11.838573838051886},null,"Average of February Averages",null,null,null,{"$f":"AVERAGE(M95,M76,M57,M38,M19)","v":55.631666666666661},{"$f":"AVERAGE(N95,N76,N57,N38,N19)","v":13.704285397868867}]
[]
[null,null,null,null,null,"Gas Unit Multiplier",{"$f":"N97/G97","v":1.1575959727361886}]
[null,null,null,null,null,"Non-Gas Unit Multiplier",{"$f":"M97/F97","v":1.2772983832392613}]

{"sheet":"Controls & Results","index":5,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"ISO-NE Public"]
[null,"Instructions",null,null,null,"Annually Updated Values  - post Net CONE & ORTP Order, June 2021"]
[null,"1. Choose reference technology from drop-down below",null,null,null,null,"Annual Updates - to be updated annually by ISO-NE"]
[null,"2. Choose Market Proposal"]
[null,"3. Click the \"Run Model\" button below. Macro MUST be run to get results."]
[]
[null,"Choose reference technology & market proposals:"]
[null,"Reference Technology",null,"Battery - ORTP"]
[null,"With FRM",null,"With FRM"]
[]
[null,"Run model:"]
[]
[]
[]
[]
[]
[]
[]
[null,"Summary of Results:",{"$f":"Assumptions!D3","v":"ORTP"}]
[]
[null,"Technology:",{"$f":"'Controls & Results'!$D$8","v":"Battery - ORTP"}]
[]
[null,null,"NPV","$/kW-yr","$/kW-mo"]
[null,"Expenses"]
[null,"Fixed",{"$f":"Model!$C$18","v":59588668.754325017},{"$f":"-PMT(Assumptions!$D$39,20,C25)/(Assumptions!$D$15*1000)","v":30.006744618877907},{"$f":"D25/12","v":2.500562051573159}]
[null,"Tax",{"$f":"Model!$C$22","v":6286336.6638458883},{"$f":"-PMT(Assumptions!$D$39,20,C26)/(Assumptions!$D$15*1000)","v":3.165576657502041},{"$f":"D26/12","v":0.26379805479183677}]
[null,"Install Costs",{"$f":"-Model!$C$26","v":136989533.99462667},{"$f":"-PMT(Assumptions!$D$39,20,C27)/(Assumptions!$D$15*1000)","v":68.983080977748855},{"$f":"D27/12","v":5.7485900814790716}]
[null,"Gross CONE",{"$f":"SUM(C25:C27)","v":202864539.41279757},{"$f":"SUM(D25:D27)","v":102.1554022541288},{"$f":"SUM(E25:E27)","v":8.5129501878440674}]
[]
[null,"Revenues"]
[null,"PFP",{"$f":"Model!$C$6","v":22090232.79546684},{"$f":"-PMT(Assumptions!$D$39,20,C31)/(Assumptions!$D$15*1000)","v":11.123859416930236},{"$f":"D31/12","v":0.92698828474418626}]
[null,"Scarcity",{"$f":"Model!$C$7","v":12339413.716936911},{"$f":"-PMT(Assumptions!$D$39,20,C32)/(Assumptions!$D$15*1000)","v":6.2136920305663068},{"$f":"D32/12","v":0.5178076692138589}]
[null,"E&AS",{"$f":"Model!$C$8","v":149633255.32001555},{"$f":"-PMT(Assumptions!$D$39,20,C33)/(Assumptions!$D$15*1000)","v":75.350011549858124},{"$f":"D33/12","v":6.2791676291548439}]
[null,"REC",{"$f":"Model!$C$9","v":0},{"$f":"-PMT(Assumptions!$D$39,20,C34)/(Assumptions!$D$15*1000)","v":0},{"$f":"D34/12","v":0}]
[null,"Revenue Offset",{"$f":"SUM(C31:C34)","v":184062901.83241931},{"$f":"SUM(D31:D34)","v":92.687562997354661},{"$f":"SUM(E31:E34)","v":7.723963583112889}]
[]
[null,"Net CONE Installed",{"$f":"C28-C35","v":18801637.580378264},{"$f":"D28-D35","v":9.4678392567741412},{"$f":"E28-E35","v":0.78898660473117843}]
[null,"Net CONE Qualified",{"$f":"C37/Assumptions!$D$17","v":18801637.580378264},{"$f":"D37/Assumptions!$D$17","v":9.4678392567741412},{"$f":"ROUND(E37/Assumptions!$D$17,3)","v":0.78900000000000003}]

{"sheet":"Assumptions","index":6,"n_rows":60,"n_cols":12,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[null,"Resource Assumptions"]
[]
[null,null,"CONE or ORTP:",{"$f":"RIGHT(D4,4)","v":"ORTP"},null,"ORTP","ORTP","ORTP","ORTP","ORTP","ORTP","ORTP"]
[null,null,"Reference Technology",{"$f":"'Controls & Results'!D8","v":"Battery - ORTP"}]
[null,null,null,{"$f":"MATCH('Controls & Results'!D8,F5:L5,0)","v":6},null,"CC - ORTP","SC - ORTP","Onshore Wind - ORTP","Offshore Wind - ORTP","Solar - ORTP","Battery - ORTP","Co-located Resource - ORTP"]
[null,null,null,null,null,"Combined Cycle","Simple Cycle"]
[null,null,null,null,null,"7HA 02 Combined Cycle","7HA 02 Simple Cycle"]
[null,"Line","Assumption"]
[null,"Plant"]
[null,{"$f":"MAX($B$9:B9)+1","v":1},"Location",{"$f":"OFFSET(F10,0,D$5-1)","v":"RI"},null,"CT","CT","NH","MA","CT","RI","MA"]
[null,{"$f":"MAX($B$9:B10)+1","v":2},"Fuel Type",{"$f":"OFFSET(F11,0,D$5-1)","v":0},null,"Natural Gas","Natural Gas","Wind","Wind","Solar"]
[null,{"$f":"MAX($B$9:B11)+1","v":3},"Property Tax Rate",0.01,null,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[null,{"$f":"MAX($B$9:B12)+1","v":4},"Insurance (% of Installed Costs)",3.0000000000000001E-3,null,3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3]
[null,{"$f":"MAX($B$9:B13)+1","v":5},"Site Leasing ($/acre)",25000,null,25000,25000,175,7,1500,{"$f":"F14","v":25000},2850]
[null,{"$f":"MAX($B$9:B14)+1","v":6},"Plant Capacity (MW)",150,null,557,376,82.5,800,20,150,10]
[null,{"$f":"MAX($B$9:B15)+1","v":7},"Plant Capacity for REC Calculation (MW)",0,null,null,null,{"$f":"H15","v":82.5},{"$f":"I15","v":800},{"$f":"J15","v":20},null,5]
[null,{"$f":"MAX($B$9:B16)+1","v":8},"Qualified Capacity (%)",1,null,0.9,0.96,{"$f":"32.44/H16","v":0.39321212121212118},{"$f":"371.663/800","v":0.46457875000000004},{"$f":"3.772/20","v":0.18859999999999999},{"$f":"150/150","v":1},{"$f":"(5*J17+5*K17)/10","v":0.59429999999999994}]
[null,{"$f":"MAX($B$9:B17)+1","v":9},"Capacity Factor (%)",0,null,null,null,0.43099999999999999,0.47,0.17199999999999999,null,{"$f":"J18","v":0.17199999999999999}]
[null,{"$f":"MAX($B$9:B18)+1","v":10},"Acres",10,null,15,8,4700,75600,133,10,35]
[null,{"$f":"MAX($B$9:B19)+1","v":11},"REC Price ($/MWh)",0,null,null,null,{"$f":"RECs!$B$7","v":39.701822231072057},{"$f":"RECs!$B$7","v":39.701822231072057},{"$f":"RECs!$B$7","v":39.701822231072057},null,{"$f":"RECs!$B$7","v":39.701822231072057}]
[null,{"$f":"MAX($B$9:B20)+1","v":12},"Investment Tax Credit",0,null,0,0,0,0.3,0.26,0,0.26]
[null,{"$f":"MAX($B$9:B21)+1","v":13},"Percent of Time Renewable-Charged (%)",0,null,0,0,0,0,0,0,1]
[]
[null,"Financial"]
[null,{"$f":"MAX($B$9:B24)+1","v":14},"Economic Life (years)",20]
[null,{"$f":"MAX($B$9:B25)+1","v":15},"Tax Depreciation Schedule",{"$f":"OFFSET(F26,0,D$5-1)","v":"7yrMACRS"},null,"20yrMACRS","15yrMACRS","5yrMACRS","5yrMACRS","5yrMACRS","7yrMACRS","5yrMACRS"]
[null,{"$f":"MAX($B$9:B26)+1","v":16},"Bonus Depreciation (%)",0.2,null,0.2,0.2,0.2,0.2,0.2,0.2,0.2]
[null,{"$f":"MAX($B$9:B27)+1","v":17},"Federal Tax Rate (%)",0.21,null,0.21,0.21,0.21,0.21,0.21,0.21,0.21]
[null,{"$f":"MAX($B$9:B28)+1","v":18},"State Tax Rate (%)",7.0000000000000007E-2,null,7.4999999999999997E-2,7.4999999999999997E-2,7.6999999999999999E-2,0.08,7.4999999999999997E-2,7.0000000000000007E-2,0.08]
[null,{"$f":"MAX($B$9:B29)+1","v":19},"Effective Income Tax Rate (%)",0.26529999999999998,null,{"$f":"1-(1-F28)*(1-F29)","v":0.26924999999999988},{"$f":"1-(1-G28)*(1-G29)","v":0.26924999999999988},{"$f":"1-(1-H28)*(1-H29)","v":0.2708299999999999},{"$f":"1-(1-I28)*(1-I29)","v":0.27319999999999989},{"$f":"1-(1-J28)*(1-J29)","v":0.26924999999999988},{"$f":"1-(1-K28)*(1-K29)","v":0.26529999999999998},{"$f":"1-(1-L28)*(1-L29)","v":0.27319999999999989}]
[null,{"$f":"MAX($B$9:B30)+1","v":20},"Debt Weight (%)",0.6,null,0.6,0.6,0.6,0.6,0.6,0.6,0.6]
[null,{"$f":"MAX($B$9:B31)+1","v":21},"Equity Weight (%)",0.4,null,{"$f":"1-F31","v":0.4},0.4,0.4,0.4,0.4,0.4,0.4]
[null,{"$f":"MAX($B$9:B32)+1","v":22},"Cost of Debt (%)",4.4999999999999998E-2,null,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2]
[null,{"$f":"MAX($B$9:B33)+1","v":23},"After Tax Cost of Debt (%)",3.3061500000000001E-2,null,{"$f":"F33*(1-F30)","v":3.2883750000000003E-2},3.2883750000000003E-2,3.2812650000000006E-2,3.2706000000000006E-2,3.2883750000000003E-2,3.3061500000000001E-2,3.2706000000000006E-2]
[null,{"$f":"MAX($B$9:B34)+1","v":24},"Cost of Equity (%)",0.11,null,0.11,0.11,0.11,0.11,0.11,0.11,0.11]
[null,{"$f":"MAX($B$9:B35)+1","v":25},"Annual Inflation Rate (%)",0.02,null,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
[null,{"$f":"MAX($B$9:B36)+1","v":26},"WACC (%)",7.1000000000000008E-2,null,{"$f":"F31*F33+F32*F35","v":7.1000000000000008E-2},7.1000000000000008E-2,7.1000000000000008E-2,7.1000000000000008E-2,7.1000000000000008E-2,7.1000000000000008E-2,7.1000000000000008E-2]
[null,{"$f":"MAX($B$9:B37)+1","v":27},"ATWACC (%)",6.3836900000000002E-2,null,{"$f":"(F31*F34)+(F32*F35)","v":6.3730250000000002E-2},6.3730250000000002E-2,6.3687590000000002E-2,6.3623600000000002E-2,6.3730250000000002E-2,6.3836900000000002E-2,6.3623600000000002E-2]
[null,{"$f":"MAX($B$9:B38)+1","v":28},"Discount Rate (%)",4.297735294117655E-2,"Real",{"$f":"(1+F38)/(1+F36)-1","v":4.2872794117647217E-2},4.2872794117647217E-2,4.2830970588235262E-2,4.2768235294117662E-2,4.2872794117647217E-2,4.297735294117655E-2,4.2768235294117662E-2]
[null,{"$f":"MAX($B$9:B39)+1","v":29},"Monthly WACC",5.7324338322313206E-3,"Nominal",{"$f":"(1+F37)^(1/12)-1","v":5.7324338322313206E-3},5.7324338322313206E-3,5.7324338322313206E-3,5.7324338322313206E-3,5.7324338322313206E-3,5.7324338322313206E-3,5.7324338322313206E-3]
[null,{"$f":"MAX($B$9:B40)+1","v":30},"Monthly Inflation Rate",1.6515813019202241E-3,null,{"$f":"(1+F36)^(1/12)-1","v":1.6515813019202241E-3},1.6515813019202241E-3,1.6515813019202241E-3,1.6515813019202241E-3,1.6515813019202241E-3,1.6515813019202241E-3,1.6515813019202241E-3]
[null,{"$f":"MAX($B$9:B41)+1","v":31},"Monthly Real WACC (%)",4.0741237836483535E-3,null,{"$f":"(1+F40)/(1+F41)-1","v":4.0741237836483535E-3},4.0741237836483535E-3,4.0741237836483535E-3,4.0741237836483535E-3,4.0741237836483535E-3,4.0741237836483535E-3,4.0741237836483535E-3]
[]
[null,"Construction"]
[null,{"$f":"MAX($B$9:B44)+1","v":32},"Interest During Construction (%)",{"$f":"OFFSET(F45,0,D$5-1)","v":4.4999999999999998E-2},"Nominal",{"$f":"F33","v":4.4999999999999998E-2},4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2]
[null,{"$f":"MAX($B$9:B45)+1","v":33},"Monthly Cost of Debt During Construction",3.6748094004368514E-3,"Nominal",{"$f":"(1+F45)^(1/12)-1","v":3.6748094004368514E-3},3.6748094004368514E-3,3.6748094004368514E-3,3.6748094004368514E-3,3.6748094004368514E-3,3.6748094004368514E-3,3.6748094004368514E-3]
[null,{"$f":"MAX($B$9:B46)+1","v":34},"Construction Months",17,null,{"$f":"'Capital Costs'!B4","v":28},{"$f":"'Capital Costs'!C4","v":21},{"$f":"'Capital Costs'!D4","v":21},{"$f":"'Capital Costs'!E4","v":48},{"$f":"'Capital Costs'!F4","v":30},{"$f":"'Capital Costs'!G4","v":17},{"$f":"'Capital Costs'!H4","v":30}]
[]
[null,"Capital and O&M"]
[null,{"$f":"MAX($B$9:B49)+1","v":35},"Overnight cost per kW ($ at construction start)",{"$f":"OFFSET(F50,0,D$5-1)","v":909.03872242488092},{"$f":"TEXT(EDATE(45809,-$D$47),\"mmm yyyy\")&\" $\"","v":"Jan 2024 $"},{"$f":"INDEX('Capital Costs'!$N$44:$T$44,1,MATCH(Assumptions!F$5,'Capital Costs'!$N$2:$T$2,0))","v":1028.0439477040413},{"$f":"INDEX('Capital Costs'!$N$44:$T$44,1,MATCH(Assumptions!G$5,'Capital Costs'!$N$2:$T$2,0))","v":823.11558752914698},{"$f":"INDEX('Capital Costs'!$N$44:$T$44,1,MATCH(Assumptions!H$5,'Capital Costs'!$N$2:$T$2,0))","v":2162.7709200049385},{"$f":"INDEX('Capital Costs'!$N$44:$T$44,1,MATCH(Assumptions!I$5,'Capital Costs'!$N$2:$T$2,0))","v":5446.1963465046856},{"$f":"INDEX('Capital Costs'!$N$44:$T$44,1,MATCH(Assumptions!J$5,'Capital Costs'!$N$2:$T$2,0))","v":1425.2535923679345},{"$f":"INDEX('Capital Costs'!$N$44:$T$44,1,MATCH(Assumptions!K$5,'Capital Costs'!$N$2:$T$2,0))","v":909.03872242488092},{"$f":"INDEX('Capital Costs'!$N$44:$T$44,1,MATCH(Assumptions!L$5,'Capital Costs'!$N$2:$T$2,0))","v":1483.5527365169066}]
[null,{"$f":"MAX($B$9:B50)+1","v":36},"Non-Depreciable cost per kW  ($ at construction start)",8.7454348227869385,{"$f":"TEXT(EDATE(45809,-$D$47),\"mmm yyyy\")&\" $\"","v":"Jan 2024 $"},{"$f":"INDEX('Capital Costs'!$N$47:$T$47,1,MATCH(Assumptions!F$5,'Capital Costs'!$N$2:$T$2,0))","v":19.325788385519793},{"$f":"INDEX('Capital Costs'!$N$47:$T$47,1,MATCH(Assumptions!G$5,'Capital Costs'!$N$2:$T$2,0))","v":22.386008838490508},{"$f":"INDEX('Capital Costs'!$N$47:$T$47,1,MATCH(Assumptions!H$5,'Capital Costs'!$N$2:$T$2,0))","v":15.783700766057498},{"$f":"INDEX('Capital Costs'!$N$47:$T$47,1,MATCH(Assumptions!I$5,'Capital Costs'!$N$2:$T$2,0))","v":49.924559123906242},{"$f":"INDEX('Capital Costs'!$N$47:$T$47,1,MATCH(Assumptions!J$5,'Capital Costs'!$N$2:$T$2,0))","v":11.359124552777129},{"$f":"INDEX('Capital Costs'!$N$47:$T$47,1,MATCH(Assumptions!K$5,'Capital Costs'!$N$2:$T$2,0))","v":8.7454348227869385},{"$f":"INDEX('Capital Costs'!$N$47:$T$47,1,MATCH(Assumptions!L$5,'Capital Costs'!$N$2:$T$2,0))","v":13.764203881022549}]
[null,{"$f":"MAX($B$9:B51)+1","v":37},"EPC Cost Escalation Rate",7.0000000000000001E-3,null,7.0000000000000001E-3,7.0000000000000001E-3,7.0000000000000001E-3,7.0000000000000001E-3,7.0000000000000001E-3,7.0000000000000001E-3,7.0000000000000001E-3]
[null,{"$f":"MAX($B$9:B52)+1","v":38},"Non-EPC Cost Escalation Rate",1.9E-2,null,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2]
[null,{"$f":"MAX($B$9:B53)+1","v":39},"Fuel Inventory Escalation Rate",5.3999999999999999E-2,null,5.3999999999999999E-2,5.3999999999999999E-2,5.3999999999999999E-2,5.3999999999999999E-2,5.3999999999999999E-2,5.3999999999999999E-2,5.3999999999999999E-2]
[null,{"$f":"MAX($B$9:B54)+1","v":40},"Ongoing Maintenance (2019$/MW-yr)",1000,null,1000,1000,1000,1000,1000,1000,1000]
[null,{"$f":"MAX($B$9:B55)+1","v":41},"Fixed O&M LTSA (2019$/kW-yr)",22,null,55.199999999999996,35,30,82,13,22,40]
[null,{"$f":"MAX($B$9:B56)+1","v":42},"Fixed O&M Escalation Rate",0.01]
[null,{"$f":"MAX($B$9:B57)+1","v":43},"Fixed O&M LTSA ($/kW-yr)",24.414963463823003,null,{"$f":"((F55/1000)+F56)*(1+$D$57)^(2025-2019)","v":59.657432463776203},38.214725421636004,32.907124668631006,88.106172499883016,14.861282108414002,24.414963463823003,43.522326174641009]
[]
[null,"Note: all dollar amounts are in capacity year dollars"]

{"sheet":"Construction CF","index":7,"n_rows":46,"n_cols":51,"rows_kept":46,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
["Drawdown Schedule and Construction Cash Flow"]
[]
["Technology",{"$f":"'Controls & Results'!D8","v":"Battery - ORTP"}]
[]
[]
["Capital Draw Down Schedule"]
[null,null,{"$f":"EDATE(45809,-B8+24)","v":"2026-01-01"},{"$f":"EDATE(C7,1)","v":"2026-02-01"},{"$f":"EDATE(D7,1)","v":"2026-03-01"},"2026-04-01","2026-05-01","2026-06-01","2026-07-01","2026-08-01","2026-09-01","2026-10-01","2026-11-01","2026-12-01","2027-01-01","2027-02-01","2027-03-01","2027-04-01","2027-05-01","2027-06-01","2027-07-01","2027-08-01","2027-09-01","2027-10-01","2027-11-01","2027-12-01","2028-01-01","2028-02-01","2028-03-01","2028-04-01","2028-05-01","2028-06-01","2028-07-01","2028-08-01","2028-09-01","2028-10-01","2028-11-01","2028-12-01","2029-01-01","2029-02-01","2029-03-01","2029-04-01","2029-05-01","2029-06-01","2029-07-01","2029-08-01","2029-09-01","2029-10-01","2029-11-01","2029-12-01"]
["Month Count",{"$f":"COUNTIF(C8:AX8,1)","v":17},{"$f":"IF(OR(C10>0,SUM(C$10:$AX$10)>0),1,0)","v":1},{"$f":"IF(OR(D10>0,SUM(D$10:$AX$10)>0),1,0)","v":1},{"$f":"IF(OR(E10>0,SUM(E$10:$AX$10)>0),1,0)","v":1},{"$f":"IF(OR(F10>0,SUM(F$10:$AX$10)>0),1,0)","v":1},{"$f":"IF(OR(G10>0,SUM(G$10:$AX$10)>0),1,0)","v":1},{"$f":"IF(OR(H10>0,SUM(H$10:$AX$10)>0),1,0)","v":1},{"$f":"IF(OR(I10>0,SUM(I$10:$AX$10)>0),1,0)","v":1},{"$f":"IF(OR(J10>0,SUM(J$10:$AX$10)>0),1,0)","v":1},{"$f":"IF(OR(K10>0,SUM(K$10:$AX$10)>0),1,0)","v":1},{"$f":"IF(OR(L10>0,SUM(L$10:$AX$10)>0),1,0)","v":1},{"$f":"IF(OR(M10>0,SUM(M$10:$AX$10)>0),1,0)","v":1},{"$f":"IF(OR(N10>0,SUM(N$10:$AX$10)>0),1,0)","v":1},{"$f":"IF(OR(O10>0,SUM(O$10:$AX$10)>0),1,0)","v":1},{"$f":"IF(OR(P10>0,SUM(P$10:$AX$10)>0),1,0)","v":1},{"$f":"IF(OR(Q10>0,SUM(Q$10:$AX$10)>0),1,0)","v":1},{"$f":"IF(OR(R10>0,SUM(R$10:$AX$10)>0),1,0)","v":1},{"$f":"IF(OR(S10>0,SUM(S$10:$AX$10)>0),1,0)","v":1},{"$f":"IF(OR(T10>0,SUM(T$10:$AX$10)>0),1,0)","v":0},{"$f":"IF(OR(U10>0,SUM(U$10:$AX$10)>0),1,0)","v":0},{"$f":"IF(OR(V10>0,SUM(V$10:$AX$10)>0),1,0)","v":0},{"$f":"IF(OR(W10>0,SUM(W$10:$AX$10)>0),1,0)","v":0},{"$f":"IF(OR(X10>0,SUM(X$10:$AX$10)>0),1,0)","v":0},{"$f":"IF(OR(Y10>0,SUM(Y$10:$AX$10)>0),1,0)","v":0},{"$f":"IF(OR(Z10>0,SUM(Z$10:$AX$10)>0),1,0)","v":0},{"$f":"IF(OR(AA10>0,SUM(AA$10:$AX$10)>0),1,0)","v":0},{"$f":"IF(OR(AB10>0,SUM(AB$10:$AX$10)>0),1,0)","v":0},{"$f":"IF(OR(AC10>0,SUM(AC$10:$AX$10)>0),1,0)","v":0},{"$f":"IF(OR(AD10>0,SUM(AD$10:$AX$10)>0),1,0)","v":0},{"$f":"IF(OR(AE10>0,SUM(AE$10:$AX$10)>0),1,0)","v":0},{"$f":"IF(OR(AF10>0,SUM(AF$10:$AX$10)>0),1,0)","v":0},{"$f":"IF(OR(AG10>0,SUM(AG$10:$AX$10)>0),1,0)","v":0},{"$f":"IF(OR(AH10>0,SUM(AH$10:$AX$10)>0),1,0)","v":0},{"$f":"IF(OR(AI10>0,SUM(AI$10:$AX$10)>0),1,0)","v":0},{"$f":"IF(OR(AJ10>0,SUM(AJ$10:$AX$10)>0),1,0)","v":0},{"$f":"IF(OR(AK10>0,SUM(AK$10:$AX$10)>0),1,0)","v":0},{"$f":"IF(OR(AL10>0,SUM(AL$10:$AX$10)>0),1,0)","v":0},{"$f":"IF(OR(AM10>0,SUM(AM$10:$AX$10)>0),1,0)","v":0},{"$f":"IF(OR(AN10>0,SUM(AN$10:$AX$10)>0),1,0)","v":0},{"$f":"IF(OR(AO10>0,SUM(AO$10:$AX$10)>0),1,0)","v":0},{"$f":"IF(OR(AP10>0,SUM(AP$10:$AX$10)>0),1,0)","v":0},{"$f":"IF(OR(AQ10>0,SUM(AQ$10:$AX$10)>0),1,0)","v":0},{"$f":"IF(OR(AR10>0,SUM(AR$10:$AX$10)>0),1,0)","v":0},{"$f":"IF(OR(AS10>0,SUM(AS$10:$AX$10)>0),1,0)","v":0},{"$f":"IF(OR(AT10>0,SUM(AT$10:$AX$10)>0),1,0)","v":0},{"$f":"IF(OR(AU10>0,SUM(AU$10:$AX$10)>0),1,0)","v":0},{"$f":"IF(OR(AV10>0,SUM(AV$10:$AX$10)>0),1,0)","v":0},{"$f":"IF(OR(AW10>0,SUM(AW$10:$AX$10)>0),1,0)","v":0},{"$f":"IF(OR(AX10>0,SUM(AX$10:$AX$10)>0),1,0)","v":0}]
["Construction Month",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,"Total"]
["Capital Draw Down",null,{"$f":"OFFSET(C13,MATCH($B$3,$A$13:$A$19,0)-1,0)","v":0.02},{"$f":"OFFSET(D13,MATCH($B$3,$A$13:$A$19,0)-1,0)","v":0},0.2,0.05,0,0.02,0,0.02,0.2,0.02,0.2,0.02,0.02,0.02,7.4999999999999997E-2,7.4999999999999997E-2,0.06,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C10:AX10)","v":1}]
[]
[]
[{"$f":"Assumptions!$F$5","v":"CC - ORTP"},null,5.0000000000000001E-3,0.1,0.05,0.05,6.5000000000000002E-2,5.5E-2,6.5000000000000002E-2,6.5000000000000002E-2,7.4999999999999997E-2,0.08,7.4999999999999997E-2,7.0000000000000007E-2,7.0000000000000007E-2,0.05,2.5000000000000001E-2,0.02,1.4999999999999999E-2,0.01,7.4999999999999997E-3,5.0000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C13:AX13)","v":0.99999999999999967}]
[{"$f":"Assumptions!$G$5","v":"SC - ORTP"},null,5.0000000000000001E-3,0.125,7.4999999999999997E-2,0.1,7.4999999999999997E-2,0.05,0.125,0.11,0.11,7.4999999999999997E-2,0.04,2.5000000000000001E-2,0.01,0.01,0.01,0.01,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,2.5000000000000001E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C14:AX14)","v":1}]
[{"$f":"Assumptions!$H$5","v":"Onshore Wind - ORTP"},null,2.5000000000000001E-2,0,0,0,0,1.4999999999999999E-2,0.2,0,0,0.05,0.4,0.05,2.5000000000000001E-2,5.0000000000000001E-3,0.05,7.4999999999999997E-2,0.04,0.03,0.01,0,2.5000000000000001E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C15:AX15)","v":1.0000000000000002}]
[{"$f":"Assumptions!$I$5","v":"Offshore Wind - ORTP"},null,{"$f":"20%/12","v":1.6666666666666666E-2},1.6666666666666666E-2,1.6666666666666666E-2,1.6666666666666666E-2,1.6666666666666666E-2,1.6666666666666666E-2,1.6666666666666666E-2,1.6666666666666666E-2,1.6666666666666666E-2,1.6666666666666666E-2,1.6666666666666666E-2,1.6666666666666666E-2,{"$f":"40%/12","v":3.3333333333333333E-2},3.3333333333333333E-2,3.3333333333333333E-2,3.3333333333333333E-2,3.3333333333333333E-2,3.3333333333333333E-2,3.3333333333333333E-2,3.3333333333333333E-2,3.3333333333333333E-2,3.3333333333333333E-2,3.3333333333333333E-2,3.3333333333333333E-2,{"$f":"30%/12","v":2.4999999999999998E-2},2.4999999999999998E-2,2.4999999999999998E-2,2.4999999999999998E-2,2.4999999999999998E-2,2.4999999999999998E-2,2.4999999999999998E-2,2.4999999999999998E-2,2.4999999999999998E-2,2.4999999999999998E-2,2.4999999999999998E-2,2.4999999999999998E-2,{"$f":"10%/12","v":8.3333333333333332E-3},8.3333333333333332E-3,8.3333333333333332E-3,8.3333333333333332E-3,8.3333333333333332E-3,8.3333333333333332E-3,8.3333333333333332E-3,8.3333333333333332E-3,8.3333333333333332E-3,8.3333333333333332E-3,8.3333333333333332E-3,8.3333333333333332E-3,{"$f":"SUM(C16:AX16)","v":0.99999999999999989}]
[{"$f":"Assumptions!$J$5","v":"Solar - ORTP"},null,0.05,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.15,0.08,0.1,0.3,0.08,0.05,0.05,0.05,0.05,0.04,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C17:AX17)","v":1}]
[{"$f":"Assumptions!$K$5","v":"Battery - ORTP"},null,0.02,0,0.2,0.05,0,0.02,0,0.02,0.2,0.02,0.2,0.02,0.02,0.02,7.4999999999999997E-2,7.4999999999999997E-2,0.06,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[{"$f":"Assumptions!$L$5","v":"Co-located Resource - ORTP"},null,0.05,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.15,7.4999999999999997E-2,0.1,0.3,7.4999999999999997E-2,0.05,0.05,0.05,0.05,0.05,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C19:AX19)","v":1.0000000000000002}]
[]
[]
[]
["Construction Cash Flow"]
[]
[null,null,{"$f":"C7","v":"2026-01-01"},{"$f":"D7","v":"2026-02-01"},"2026-03-01","2026-04-01","2026-05-01","2026-06-01","2026-07-01","2026-08-01","2026-09-01","2026-10-01","2026-11-01","2026-12-01","2027-01-01","2027-02-01","2027-03-01","2027-04-01","2027-05-01","2027-06-01","2027-07-01","2027-08-01","2027-09-01","2027-10-01","2027-11-01","2027-12-01","2028-01-01","2028-02-01","2028-03-01","2028-04-01","2028-05-01","2028-06-01","2028-07-01","2028-08-01","2028-09-01","2028-10-01","2028-11-01","2028-12-01","2029-01-01","2029-02-01","2029-03-01","2029-04-01","2029-05-01","2029-06-01","2029-07-01","2029-08-01","2029-09-01","2029-10-01","2029-11-01","2029-12-01"]
["Capital Costs"]
[{"$f":"\"Overnight Cost at beginning of construction (\"&TEXT($C$25,\"mmm-yyyy\")&\"$)\"","v":"Overnight Cost at beginning of construction (Jan-2026$)"},{"$f":"Assumptions!D50*1000*Assumptions!D15","v":136355808.36373213},{"$f":"$B$27*C10","v":2727116.1672746427},0,27271161.672746427,6817790.4181866068,0,2727116.1672746427,0,2727116.1672746427,27271161.672746427,2727116.1672746427,27271161.672746427,2727116.1672746427,2727116.1672746427,2727116.1672746427,10226685.627279909,10226685.627279909,8181348.5018239273,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Inflation Adjusted (nominal $)",null,{"$f":"C27*(1+Assumptions!$D$41)^(C9-1)","v":2727116.1672746427},{"$f":"D27*(1+Assumptions!$D$41)^(D9-1)","v":0},{"$f":"E27*(1+Assumptions!$D$41)^(E9-1)","v":27361317.142261978},{"$f":"F27*(1+Assumptions!$D$41)^(F9-1)","v":6851626.645512512},{"$f":"G27*(1+Assumptions!$D$41)^(G9-1)","v":0},{"$f":"H27*(1+Assumptions!$D$41)^(H9-1)","v":2749710.9486991754},{"$f":"I27*(1+Assumptions!$D$41)^(I9-1)","v":0},{"$f":"J27*(1+Assumptions!$D$41)^(J9-1)","v":2758801.1915200287},{"$f":"K27*(1+Assumptions!$D$41)^(K9-1)","v":27633575.759836588},{"$f":"L27*(1+Assumptions!$D$41)^(L9-1)","v":2767921.4856866729},{"$f":"M27*(1+Assumptions!$D$41)^(M9-1)","v":27724929.330576159},{"$f":"N27*(1+Assumptions!$D$41)^(N9-1)","v":2777071.9305455601},{"$f":"O27*(1+Assumptions!$D$41)^(O9-1)","v":2781658.4906201367},{"$f":"P27*(1+Assumptions!$D$41)^(P9-1)","v":2786252.6257715728},{"$f":"Q27*(1+Assumptions!$D$41)^(Q9-1)","v":10465703.806915207},{"$f":"R27*(1+Assumptions!$D$41)^(R9-1)","v":10482988.767634144},{"$f":"S27*(1+Assumptions!$D$41)^(S9-1)","v":8400241.8206968084},{"$f":"T27*(1+Assumptions!$D$41)^(T9-1)","v":0},{"$f":"U27*(1+Assumptions!$D$41)^(U9-1)","v":0},{"$f":"V27*(1+Assumptions!$D$41)^(V9-1)","v":0},{"$f":"W27*(1+Assumptions!$D$41)^(W9-1)","v":0},{"$f":"X27*(1+Assumptions!$D$41)^(X9-1)","v":0},{"$f":"Y27*(1+Assumptions!$D$41)^(Y9-1)","v":0},{"$f":"Z27*(1+Assumptions!$D$41)^(Z9-1)","v":0},{"$f":"AA27*(1+Assumptions!$D$41)^(AA9-1)","v":0},{"$f":"AB27*(1+Assumptions!$D$41)^(AB9-1)","v":0},{"$f":"AC27*(1+Assumptions!$D$41)^(AC9-1)","v":0},{"$f":"AD27*(1+Assumptions!$D$41)^(AD9-1)","v":0},{"$f":"AE27*(1+Assumptions!$D$41)^(AE9-1)","v":0},{"$f":"AF27*(1+Assumptions!$D$41)^(AF9-1)","v":0},{"$f":"AG27*(1+Assumptions!$D$41)^(AG9-1)","v":0},{"$f":"AH27*(1+Assumptions!$D$41)^(AH9-1)","v":0},{"$f":"AI27*(1+Assumptions!$D$41)^(AI9-1)","v":0},{"$f":"AJ27*(1+Assumptions!$D$41)^(AJ9-1)","v":0},{"$f":"AK27*(1+Assumptions!$D$41)^(AK9-1)","v":0},{"$f":"AL27*(1+Assumptions!$D$41)^(AL9-1)","v":0},{"$f":"AM27*(1+Assumptions!$D$41)^(AM9-1)","v":0},{"$f":"AN27*(1+Assumptions!$D$41)^(AN9-1)","v":0},{"$f":"AO27*(1+Assumptions!$D$41)^(AO9-1)","v":0},{"$f":"AP27*(1+Assumptions!$D$41)^(AP9-1)","v":0},{"$f":"AQ27*(1+Assumptions!$D$41)^(AQ9-1)","v":0},{"$f":"AR27*(1+Assumptions!$D$41)^(AR9-1)","v":0},{"$f":"AS27*(1+Assumptions!$D$41)^(AS9-1)","v":0},{"$f":"AT27*(1+Assumptions!$D$41)^(AT9-1)","v":0},{"$f":"AU27*(1+Assumptions!$D$41)^(AU9-1)","v":0},{"$f":"AV27*(1+Assumptions!$D$41)^(AV9-1)","v":0},{"$f":"AW27*(1+Assumptions!$D$41)^(AW9-1)","v":0},{"$f":"AX27*(1+Assumptions!$D$41)^(AX9-1)","v":0}]
[]
["Interest"]
[{"$f":"TEXT($C$25,\"mmm-yyyy\")&\"$\"","v":"Jan-2026$"},null,{"$f":"IF(C9>$B$8,0,B41*Assumptions!$D$46*Assumptions!$D$31)","v":0},{"$f":"IF(D9>$B$8,0,C41*Assumptions!$D$46*Assumptions!$D$31)","v":6012.9792765505044},{"$f":"IF(E9>$B$8,0,D41*Assumptions!$D$46*Assumptions!$D$31)","v":6012.9792765505044},{"$f":"IF(F9>$B$8,0,E41*Assumptions!$D$46*Assumptions!$D$31)","v":66142.772042055542},{"$f":"IF(G9>$B$8,0,F41*Assumptions!$D$46*Assumptions!$D$31)","v":81175.220233431799},{"$f":"IF(H9>$B$8,0,G41*Assumptions!$D$46*Assumptions!$D$31)","v":81175.220233431799},{"$f":"IF(I9>$B$8,0,H41*Assumptions!$D$46*Assumptions!$D$31)","v":87188.199509982296},{"$f":"IF(J9>$B$8,0,I41*Assumptions!$D$46*Assumptions!$D$31)","v":87188.199509982296},{"$f":"IF(K9>$B$8,0,J41*Assumptions!$D$46*Assumptions!$D$31)","v":93201.178786532793},{"$f":"IF(L9>$B$8,0,K41*Assumptions!$D$46*Assumptions!$D$31)","v":153330.97155203784},{"$f":"IF(M9>$B$8,0,L41*Assumptions!$D$46*Assumptions!$D$31)","v":159343.95082858831},{"$f":"IF(N9>$B$8,0,M41*Assumptions!$D$46*Assumptions!$D$31)","v":219473.74359409339},{"$f":"IF(O9>$B$8,0,N41*Assumptions!$D$46*Assumptions!$D$31)","v":225486.72287064386},{"$f":"IF(P9>$B$8,0,O41*Assumptions!$D$46*Assumptions!$D$31)","v":231499.70214719439},{"$f":"IF(Q9>$B$8,0,P41*Assumptions!$D$46*Assumptions!$D$31)","v":237512.68142374486},{"$f":"IF(R9>$B$8,0,Q41*Assumptions!$D$46*Assumptions!$D$31)","v":260061.35371080926},{"$f":"IF(S9>$B$8,0,R41*Assumptions!$D$46*Assumptions!$D$31)","v":282610.02599787363},{"$f":"IF(T9>$B$8,0,S41*Assumptions!$D$46*Assumptions!$D$31)","v":0},{"$f":"IF(U9>$B$8,0,T41*Assumptions!$D$46*Assumptions!$D$31)","v":0},{"$f":"IF(V9>$B$8,0,U41*Assumptions!$D$46*Assumptions!$D$31)","v":0},{"$f":"IF(W9>$B$8,0,V41*Assumptions!$D$46*Assumptions!$D$31)","v":0},{"$f":"IF(X9>$B$8,0,W41*Assumptions!$D$46*Assumptions!$D$31)","v":0},{"$f":"IF(Y9>$B$8,0,X41*Assumptions!$D$46*Assumptions!$D$31)","v":0},{"$f":"IF(Z9>$B$8,0,Y41*Assumptions!$D$46*Assumptions!$D$31)","v":0},{"$f":"IF(AA9>$B$8,0,Z41*Assumptions!$D$46*Assumptions!$D$31)","v":0},{"$f":"IF(AB9>$B$8,0,AA41*Assumptions!$D$46*Assumptions!$D$31)","v":0},{"$f":"IF(AC9>$B$8,0,AB41*Assumptions!$D$46*Assumptions!$D$31)","v":0},{"$f":"IF(AD9>$B$8,0,AC41*Assumptions!$D$46*Assumptions!$D$31)","v":0},{"$f":"IF(AE9>$B$8,0,AD41*Assumptions!$D$46*Assumptions!$D$31)","v":0},{"$f":"IF(AF9>$B$8,0,AE41*Assumptions!$D$46*Assumptions!$D$31)","v":0},{"$f":"IF(AG9>$B$8,0,AF41*Assumptions!$D$46*Assumptions!$D$31)","v":0},{"$f":"IF(AH9>$B$8,0,AG41*Assumptions!$D$46*Assumptions!$D$31)","v":0},{"$f":"IF(AI9>$B$8,0,AH41*Assumptions!$D$46*Assumptions!$D$31)","v":0},{"$f":"IF(AJ9>$B$8,0,AI41*Assumptions!$D$46*Assumptions!$D$31)","v":0},{"$f":"IF(AK9>$B$8,0,AJ41*Assumptions!$D$46*Assumptions!$D$31)","v":0},{"$f":"IF(AL9>$B$8,0,AK41*Assumptions!$D$46*Assumptions!$D$31)","v":0},{"$f":"IF(AM9>$B$8,0,AL41*Assumptions!$D$46*Assumptions!$D$31)","v":0},{"$f":"IF(AN9>$B$8,0,AM41*Assumptions!$D$46*Assumptions!$D$31)","v":0},{"$f":"IF(AO9>$B$8,0,AN41*Assumptions!$D$46*Assumptions!$D$31)","v":0},{"$f":"IF(AP9>$B$8,0,AO41*Assumptions!$D$46*Assumptions!$D$31)","v":0},{"$f":"IF(AQ9>$B$8,0,AP41*Assumptions!$D$46*Assumptions!$D$31)","v":0},{"$f":"IF(AR9>$B$8,0,AQ41*Assumptions!$D$46*Assumptions!$D$31)","v":0},{"$f":"IF(AS9>$B$8,0,AR41*Assumptions!$D$46*Assumptions!$D$31)","v":0},{"$f":"IF(AT9>$B$8,0,AS41*Assumptions!$D$46*Assumptions!$D$31)","v":0},{"$f":"IF(AU9>$B$8,0,AT41*Assumptions!$D$46*Assumptions!$D$31)","v":0},{"$f":"IF(AV9>$B$8,0,AU41*Assumptions!$D$46*Assumptions!$D$31)","v":0},{"$f":"IF(AW9>$B$8,0,AV41*Assumptions!$D$46*Assumptions!$D$31)","v":0},{"$f":"IF(AX9>$B$8,0,AW41*Assumptions!$D$46*Assumptions!$D$31)","v":0}]
["Inflation Adjusted (nominal $)",null,{"$f":"C31*(1+Assumptions!$D$41)^(C9-1)","v":0},{"$f":"D31*(1+Assumptions!$D$41)^(D9-1)","v":6022.9102006924886},{"$f":"E31*(1+Assumptions!$D$41)^(E9-1)","v":6032.8575265630971},{"$f":"F31*(1+Assumptions!$D$41)^(F9-1)","v":66471.034093762282},{"$f":"G31*(1+Assumptions!$D$41)^(G9-1)","v":81712.820140516022},{"$f":"H31*(1+Assumptions!$D$41)^(H9-1)","v":81847.775506387276},{"$f":"I31*(1+Assumptions!$D$41)^(I9-1)","v":88055.76515179644},{"$f":"J31*(1+Assumptions!$D$41)^(J9-1)","v":88201.196407047421},{"$f":"K31*(1+Assumptions!$D$41)^(K9-1)","v":94439.755292036178},{"$f":"L31*(1+Assumptions!$D$41)^(L9-1)","v":155625.23359766955},{"$f":"M31*(1+Assumptions!$D$41)^(M9-1)","v":161995.2911794133},{"$f":"N31*(1+Assumptions!$D$41)^(N9-1)","v":223494.0997896732},{"$f":"O31*(1+Assumptions!$D$41)^(O9-1)","v":229996.45732805683},{"$f":"P31*(1+Assumptions!$D$41)^(P9-1)","v":236519.68358119411},{"$f":"Q31*(1+Assumptions!$D$41)^(Q9-1)","v":243063.82974522715},{"$f":"R31*(1+Assumptions!$D$41)^(R9-1)","v":266579.06082239305},{"$f":"S31*(1+Assumptions!$D$41)^(S9-1)","v":290171.30352121033},{"$f":"T31*(1+Assumptions!$D$41)^(T9-1)","v":0},{"$f":"U31*(1+Assumptions!$D$41)^(U9-1)","v":0},{"$f":"V31*(1+Assumptions!$D$41)^(V9-1)","v":0},{"$f":"W31*(1+Assumptions!$D$41)^(W9-1)","v":0},{"$f":"X31*(1+Assumptions!$D$41)^(X9-1)","v":0},{"$f":"Y31*(1+Assumptions!$D$41)^(Y9-1)","v":0},{"$f":"Z31*(1+Assumptions!$D$41)^(Z9-1)","v":0},{"$f":"AA31*(1+Assumptions!$D$41)^(AA9-1)","v":0},{"$f":"AB31*(1+Assumptions!$D$41)^(AB9-1)","v":0},{"$f":"AC31*(1+Assumptions!$D$41)^(AC9-1)","v":0},{"$f":"AD31*(1+Assumptions!$D$41)^(AD9-1)","v":0},{"$f":"AE31*(1+Assumptions!$D$41)^(AE9-1)","v":0},{"$f":"AF31*(1+Assumptions!$D$41)^(AF9-1)","v":0},{"$f":"AG31*(1+Assumptions!$D$41)^(AG9-1)","v":0},{"$f":"AH31*(1+Assumptions!$D$41)^(AH9-1)","v":0},{"$f":"AI31*(1+Assumptions!$D$41)^(AI9-1)","v":0},{"$f":"AJ31*(1+Assumptions!$D$41)^(AJ9-1)","v":0},{"$f":"AK31*(1+Assumptions!$D$41)^(AK9-1)","v":0},{"$f":"AL31*(1+Assumptions!$D$41)^(AL9-1)","v":0},{"$f":"AM31*(1+Assumptions!$D$41)^(AM9-1)","v":0},{"$f":"AN31*(1+Assumptions!$D$41)^(AN9-1)","v":0},{"$f":"AO31*(1+Assumptions!$D$41)^(AO9-1)","v":0},{"$f":"AP31*(1+Assumptions!$D$41)^(AP9-1)","v":0},{"$f":"AQ31*(1+Assumptions!$D$41)^(AQ9-1)","v":0},{"$f":"AR31*(1+Assumptions!$D$41)^(AR9-1)","v":0},{"$f":"AS31*(1+Assumptions!$D$41)^(AS9-1)","v":0},{"$f":"AT31*(1+Assumptions!$D$41)^(AT9-1)","v":0},{"$f":"AU31*(1+Assumptions!$D$41)^(AU9-1)","v":0},{"$f":"AV31*(1+Assumptions!$D$41)^(AV9-1)","v":0},{"$f":"AW31*(1+Assumptions!$D$41)^(AW9-1)","v":0},{"$f":"AX31*(1+Assumptions!$D$41)^(AX9-1)","v":0}]
[]
["Non-Depreciable Assets"]
[{"$f":"\"Cost at beginning of construction (\"&TEXT($C$25,\"mmm-yyyy\")&\"$)\"","v":"Cost at beginning of construction (Jan-2026$)"},{"$f":"Assumptions!D51*1000*Assumptions!D15","v":1311815.2234180407},{"$f":"$B$35*C10","v":26236.304468360813},0,262363.04468360817,65590.761170902042,0,26236.304468360813,0,26236.304468360813,262363.04468360817,26236.304468360813,262363.04468360817,26236.304468360813,26236.304468360813,26236.304468360813,98386.141756353041,98386.141756353041,78708.913405082436,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Inflation Adjusted (nominal $)",null,{"$f":"C35*(1+Assumptions!$D$41)^(C9-1)","v":26236.304468360813},{"$f":"D35*(1+Assumptions!$D$41)^(D9-1)","v":0},{"$f":"E35*(1+Assumptions!$D$41)^(E9-1)","v":263230.38813457009},{"$f":"F35*(1+Assumptions!$D$41)^(F9-1)","v":65916.283630427584},{"$f":"G35*(1+Assumptions!$D$41)^(G9-1)","v":0},{"$f":"H35*(1+Assumptions!$D$41)^(H9-1)","v":26453.678253886981},{"$f":"I35*(1+Assumptions!$D$41)^(I9-1)","v":0},{"$f":"J35*(1+Assumptions!$D$41)^(J9-1)","v":26541.131212877568},{"$f":"K35*(1+Assumptions!$D$41)^(K9-1)","v":265849.66048920574},{"$f":"L35*(1+Assumptions!$D$41)^(L9-1)","v":26628.873281759152},{"$f":"M35*(1+Assumptions!$D$41)^(M9-1)","v":266728.53030962509},{"$f":"N35*(1+Assumptions!$D$41)^(N9-1)","v":26716.905416297312},{"$f":"O35*(1+Assumptions!$D$41)^(O9-1)","v":26761.030557728041},{"$f":"P35*(1+Assumptions!$D$41)^(P9-1)","v":26805.228575417303},{"$f":"Q35*(1+Assumptions!$D$41)^(Q9-1)","v":100685.62346147305},{"$f":"R35*(1+Assumptions!$D$41)^(R9-1)","v":100851.9139545542},{"$f":"S35*(1+Assumptions!$D$41)^(S9-1)","v":80814.783271923545},{"$f":"T35*(1+Assumptions!$D$41)^(T9-1)","v":0},{"$f":"U35*(1+Assumptions!$D$41)^(U9-1)","v":0},{"$f":"V35*(1+Assumptions!$D$41)^(V9-1)","v":0},{"$f":"W35*(1+Assumptions!$D$41)^(W9-1)","v":0},{"$f":"X35*(1+Assumptions!$D$41)^(X9-1)","v":0},{"$f":"Y35*(1+Assumptions!$D$41)^(Y9-1)","v":0},{"$f":"Z35*(1+Assumptions!$D$41)^(Z9-1)","v":0},{"$f":"AA35*(1+Assumptions!$D$41)^(AA9-1)","v":0},{"$f":"AB35*(1+Assumptions!$D$41)^(AB9-1)","v":0},{"$f":"AC35*(1+Assumptions!$D$41)^(AC9-1)","v":0},{"$f":"AD35*(1+Assumptions!$D$41)^(AD9-1)","v":0},{"$f":"AE35*(1+Assumptions!$D$41)^(AE9-1)","v":0},{"$f":"AF35*(1+Assumptions!$D$41)^(AF9-1)","v":0},{"$f":"AG35*(1+Assumptions!$D$41)^(AG9-1)","v":0},{"$f":"AH35*(1+Assumptions!$D$41)^(AH9-1)","v":0},{"$f":"AI35*(1+Assumptions!$D$41)^(AI9-1)","v":0},{"$f":"AJ35*(1+Assumptions!$D$41)^(AJ9-1)","v":0},{"$f":"AK35*(1+Assumptions!$D$41)^(AK9-1)","v":0},{"$f":"AL35*(1+Assumptions!$D$41)^(AL9-1)","v":0},{"$f":"AM35*(1+Assumptions!$D$41)^(AM9-1)","v":0},{"$f":"AN35*(1+Assumptions!$D$41)^(AN9-1)","v":0},{"$f":"AO35*(1+Assumptions!$D$41)^(AO9-1)","v":0},{"$f":"AP35*(1+Assumptions!$D$41)^(AP9-1)","v":0},{"$f":"AQ35*(1+Assumptions!$D$41)^(AQ9-1)","v":0},{"$f":"AR35*(1+Assumptions!$D$41)^(AR9-1)","v":0},{"$f":"AS35*(1+Assumptions!$D$41)^(AS9-1)","v":0},{"$f":"AT35*(1+Assumptions!$D$41)^(AT9-1)","v":0},{"$f":"AU35*(1+Assumptions!$D$41)^(AU9-1)","v":0},{"$f":"AV35*(1+Assumptions!$D$41)^(AV9-1)","v":0},{"$f":"AW35*(1+Assumptions!$D$41)^(AW9-1)","v":0},{"$f":"AX35*(1+Assumptions!$D$41)^(AX9-1)","v":0}]
[]
["Total Depreciable (Inflation Adjusted nominal$)",null,{"$f":"C32+C28-C36","v":2700879.862806282},{"$f":"D32+D28-D36","v":6022.9102006924886},27104119.611653972,6852181.3959758459,81712.820140516022,2805105.0459516761,88055.76515179644,2820461.2567141987,27462165.854639418,2896917.8460025834,27620196.091445949,2973849.1249189358,2984893.9173904657,2995967.0807773494,10608082.013198961,10648715.914501984,8609598.3409460951,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AQ32+AQ28-AQ36","v":0},0,0,0,0,0,0,0]
["Total Installed (Inflation Adjusted nominal$)",null,{"$f":"C32+C28","v":2727116.1672746427},{"$f":"D32+D28","v":6022.9102006924886},27367349.999788541,6918097.6796062738,81712.820140516022,2831558.7242055628,88055.76515179644,2847002.3879270763,27728015.515128624,2923546.7192843426,27886924.621755574,3000566.0303352331,3011654.9479481936,3022772.3093527667,10708767.636660434,10749567.828456538,8690413.1242180187,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AQ32+AQ28","v":0},0,0,0,0,0,0,0]
[]
[{"$f":"\"Aggregate Expenditure (\"&TEXT($C$25,\"mmm-yyyy\")&\"$)\"","v":"Aggregate Expenditure (Jan-2026$)"},null,{"$f":"C27","v":2727116.1672746427},{"$f":"C41+D27","v":2727116.1672746427},{"$f":"D41+E27","v":29998277.84002107},36816068.258207679,36816068.258207679,39543184.425482318,39543184.425482318,42270300.592756957,69541462.265503377,72268578.432778016,99539740.105524451,102266856.27279909,104993972.44007373,107721088.60734837,117947774.23462828,128174459.86190818,136355808.3637321,136355808.3637321,136355808.3637321,136355808.3637321,136355808.3637321,136355808.3637321,136355808.3637321,136355808.3637321,136355808.3637321,136355808.3637321,136355808.3637321,136355808.3637321,136355808.3637321,136355808.3637321,136355808.3637321,136355808.3637321,136355808.3637321,136355808.3637321,136355808.3637321,136355808.3637321,136355808.3637321,136355808.3637321,136355808.3637321,{"$f":"AO41+AP27","v":136355808.3637321},{"$f":"AP41+AQ27","v":136355808.3637321},{"$f":"AQ41+AR27","v":136355808.3637321},{"$f":"AR41+AS27","v":136355808.3637321},{"$f":"AS41+AT27","v":136355808.3637321},{"$f":"AT41+AU27","v":136355808.3637321},{"$f":"AU41+AV27","v":136355808.3637321},{"$f":"AV41+AW27","v":136355808.3637321},136355808.3637321]
[]
[]
[{"$f":"\"Depreciable Cost (\"&TEXT(C25,\"mmm-yyyy\")&\"$)\"","v":"Depreciable Cost (Jan-2026$)"},{"$f":"NPV(Assumptions!D40,'Construction CF'!C38:AX38)","v":131939231.19368502}]
["Depreciable Cost",{"$f":"B44*((1+Assumptions!D41)^('Construction CF'!$B$8))","v":135693025.47077197}]
["Installed Cost",{"$f":"NPV(Assumptions!D40,'Construction CF'!C39:AX39)*((1+Assumptions!D41)^('Construction CF'!$B$8))","v":136989533.99462667}]

{"sheet":"Model","index":8,"n_rows":54,"n_cols":22,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Results",{"$f":"'Controls & Results'!D8","v":"Battery - ORTP"}]
[]
[null,null,"NPV","$/kW-yr","$/kW-mo"]
[null,"Revenue"]
[null,"Pay for Performance",{"$f":"NPV(Assumptions!$D$39,PFP!D8:W8)","v":22090232.79546684},{"$f":"-PMT(Assumptions!$D$39,20,C6)/(Assumptions!$D$15*1000)","v":11.123859416930236},{"$f":"D6/12","v":0.92698828474418626}]
[null,"Scarcity Adder",{"$f":"NPV(Assumptions!$D$39,Scarcity!D6:W6)","v":12339413.716936911},{"$f":"-PMT(Assumptions!$D$39,20,C7)/(Assumptions!$D$15*1000)","v":6.2136920305663068},{"$f":"D7/12","v":0.5178076692138589}]
[null,"E&AS",{"$f":"-PV(Assumptions!$D$39,20,'E&AS'!D6)","v":149633255.32001555},{"$f":"-PMT(Assumptions!$D$39,20,C8)/(Assumptions!$D$15*1000)","v":75.350011549858124},{"$f":"D8/12","v":6.2791676291548439}]
[null,"REC",{"$f":"-PV(Assumptions!$D$39,20,(Assumptions!$D$20*Assumptions!$D$18*8760*Assumptions!$D$16))","v":0},{"$f":"-PMT(Assumptions!$D$39,20,C9)/(Assumptions!$D$15*1000)","v":0},0]
[null,"Capacity Revenue",{"$f":"-PV(Assumptions!$D$39,20,(C34*12*1000*Assumptions!$D$15))","v":18801637.58037835},{"$f":"-PMT(Assumptions!$D$39,20,C10)/(Assumptions!$D$15*1000)","v":9.467839256774166},0.78898660473118054]
[null,"Total Revenue",{"$f":"SUM(C6:C10)","v":202864539.41279766},{"$f":"SUM(D6:D10)","v":102.15540225412883},{"$f":"SUM(E6:E10)","v":8.5129501878440692}]
[]
[null,"Expenses"]
[null,"Property Taxes",{"$f":"PV(Assumptions!$D$39,20,-(AVERAGE(Depreciation!$C$79:$V$79)*Assumptions!$D$12))","v":2353866.3953112811},{"$f":"-PMT(Assumptions!$D$39,20,C14)/(Assumptions!$D$15*1000)","v":1.1853238084956843},{"$f":"D14/12","v":9.8776984041307025E-2}]
[null,"Site Leasing",{"$f":"PV(Assumptions!$D$39,20,-(Assumptions!$D$14*Assumptions!$D$19))","v":3309737.5001950124},{"$f":"-PMT(Assumptions!$D$39,20,C15)/(Assumptions!$D$15*1000)","v":1.6666666666666679},{"$f":"D15/12","v":0.13888888888888898}]
[null,"Insurance",{"$f":"PV(Assumptions!$D$39,20,-(Assumptions!$D$13*'Construction CF'!$B$46))","v":5440792.7735550646},{"$f":"-PMT(Assumptions!$D$39,20,C16)/(Assumptions!$D$15*1000)","v":2.7397906798925353},0.2283158899910446]
[null,"Fixed O&M (LTSA plus ongoing O&M)",{"$f":"PV(Assumptions!$D$39,20,-(Assumptions!$D$15*1000*Assumptions!$D$58))","v":48484272.085263662},{"$f":"-PMT(Assumptions!$D$39,20,C17)/(Assumptions!$D$15*1000)","v":24.414963463823018},2.034580288651918]
[null,"Subtotal - Fixed Expenses",{"$f":"SUM(C14:C17)","v":59588668.754325017},{"$f":"SUM(D14:D17)","v":30.006744618877903},{"$f":"SUM(E14:E17)","v":2.5005620515731586}]
[]
[null,"Net Income "]
[null,"Operating Income",{"$f":"NPV(Assumptions!$D$39,Model!C45:V45)","v":23695200.391428158},{"$f":"-PMT(Assumptions!$D$39,20,C21)/(Assumptions!$D$15*1000)","v":11.932064295145274},{"$f":"D21/12","v":0.99433869126210617}]
[null,"Net Income Taxes",{"$f":"NPV(Assumptions!$D$39,Model!C49:V49)","v":6286336.6638458883},{"$f":"-PMT(Assumptions!$D$39,20,C22)/(Assumptions!$D$15*1000)","v":3.165576657502041},{"$f":"D22/12","v":0.26379805479183677}]
[null,"Net Income",{"$f":"C21-C22","v":17408863.727582268},{"$f":"D21-D22","v":8.7664876376432339},{"$f":"E21-E22","v":0.73054063647026934}]
[]
[null,"Operating Cash Flow",{"$f":"C23+NPV(Assumptions!$D$39,Depreciation!C74:V74)+(Depreciation!$V$77+(Depreciation!$C$8-Depreciation!$C$7))*(1/(1+Assumptions!$D$39)^20)","v":136989533.99462661},{"$f":"-PMT(Assumptions!$D$39,20,C25)/(Assumptions!$D$15*1000)","v":68.983080977748813},{"$f":"D25/12","v":5.748590081479068}]
[null,"Less: Installed Cost",{"$f":"'Construction CF'!B46*-1","v":-136989533.99462667},{"$f":"-PMT(Assumptions!$D$39,20,C26)/(Assumptions!$D$15*1000)","v":-68.983080977748855},{"$f":"D26/12","v":-5.7485900814790716}]
[null,"NPV",{"$f":"SUM(C25:C26)","v":0},{"$f":"SUM(D25:D26)","v":0},{"$f":"SUM(E25:E26)","v":0}]
[]
[null,"Levelized Annual Capacity Revenue Requirement After Tax",{"$f":"PMT(Assumptions!$D$39,20,C27,0,0)","v":0},{"$f":"C29/(Assumptions!$D$15*1000)","v":0},{"$f":"C29/(Assumptions!$D$15*1000)/12","v":0}]
[null,"Levelized Annual Capacity Revenue Requirement Before Tax",{"$f":"C29/(1-Assumptions!D30)","v":0},{"$f":"C30/(Assumptions!$D$15*1000)","v":0},{"$f":"C30/(Assumptions!$D$15*1000)/12","v":0}]
[]
[]
[null,"NPV ($/kW-month)",{"$f":"C30/(Assumptions!D15*1000)/12","v":0},"Installed"]
[null,"Net CONE ($/kW-month)1",0.78898660473118021,"Installed"]
[]
[null,"Net CONE ($/kW-month)",{"$f":"C34/Assumptions!D17","v":0.78898660473118021},"Qualified"]
[]
[]
[]
[]
[null,"Tax Calculation and Cash Flow"]
[]
[null,null,2026,{"$f":"C43+1","v":2027},2028,2029,{"$f":"F43+1","v":2030},2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,{"$f":"S43+1","v":2043},{"$f":"T43+1","v":2044},{"$f":"U43+1","v":2045}]
[]
[null,"Operating Income ",{"$f":"Scarcity!D6+PFP!D8+'E&AS'!$D$6+($C$34*12*1000*Assumptions!$D$15)-PMT(Assumptions!$D$39,20,Model!$C$9)+PMT(Assumptions!$D$39,20,Model!$C$18)-Depreciation!C74","v":-31641858.357809894},{"$f":"Scarcity!E6+PFP!E8+'E&AS'!$D$6+($C$34*12*1000*Assumptions!$D$15)-PMT(Assumptions!$D$39,20,Model!$C$9)+PMT(Assumptions!$D$39,20,Model!$C$18)-Depreciation!D74","v":-15630461.151482262},{"$f":"Scarcity!F6+PFP!F8+'E&AS'!$D$6+($C$34*12*1000*Assumptions!$D$15)-PMT(Assumptions!$D$39,20,Model!$C$9)+PMT(Assumptions!$D$39,20,Model!$C$18)-Depreciation!E74","v":-8085237.0284638945},{"$f":"Scarcity!G6+PFP!G8+'E&AS'!$D$6+($C$34*12*1000*Assumptions!$D$15)-PMT(Assumptions!$D$39,20,Model!$C$9)+PMT(Assumptions!$D$39,20,Model!$C$18)-Depreciation!F74","v":-2612015.461356109},{"$f":"Scarcity!H6+PFP!H8+'E&AS'!$D$6+($C$34*12*1000*Assumptions!$D$15)-PMT(Assumptions!$D$39,20,Model!$C$9)+PMT(Assumptions!$D$39,20,Model!$C$18)-Depreciation!G74","v":1199095.1253157835},{"$f":"Scarcity!I6+PFP!I8+'E&AS'!$D$6+($C$34*12*1000*Assumptions!$D$15)-PMT(Assumptions!$D$39,20,Model!$C$9)+PMT(Assumptions!$D$39,20,Model!$C$18)-Depreciation!H74","v":1157571.372514531},{"$f":"Scarcity!J6+PFP!J8+'E&AS'!$D$6+($C$34*12*1000*Assumptions!$D$15)-PMT(Assumptions!$D$39,20,Model!$C$9)+PMT(Assumptions!$D$39,20,Model!$C$18)-Depreciation!I74","v":1193398.9380733389},{"$f":"Scarcity!K6+PFP!K8+'E&AS'!$D$6+($C$34*12*1000*Assumptions!$D$15)-PMT(Assumptions!$D$39,20,Model!$C$9)+PMT(Assumptions!$D$39,20,Model!$C$18)-Depreciation!J74","v":5993514.0240151631},{"$f":"Scarcity!L6+PFP!L8+'E&AS'!$D$6+($C$34*12*1000*Assumptions!$D$15)-PMT(Assumptions!$D$39,20,Model!$C$9)+PMT(Assumptions!$D$39,20,Model!$C$18)-Depreciation!K74","v":10783798.520956442},{"$f":"Scarcity!M6+PFP!M8+'E&AS'!$D$6+($C$34*12*1000*Assumptions!$D$15)-PMT(Assumptions!$D$39,20,Model!$C$9)+PMT(Assumptions!$D$39,20,Model!$C$18)-Depreciation!L74","v":10831595.786379429},{"$f":"Scarcity!N6+PFP!N8+'E&AS'!$D$6+($C$34*12*1000*Assumptions!$D$15)-PMT(Assumptions!$D$39,20,Model!$C$9)+PMT(Assumptions!$D$39,20,Model!$C$18)-Depreciation!M74","v":10780420.691120286},{"$f":"Scarcity!O6+PFP!O8+'E&AS'!$D$6+($C$34*12*1000*Assumptions!$D$15)-PMT(Assumptions!$D$39,20,Model!$C$9)+PMT(Assumptions!$D$39,20,Model!$C$18)-Depreciation!N74","v":10730249.029101519},{"$f":"Scarcity!P6+PFP!P8+'E&AS'!$D$6+($C$34*12*1000*Assumptions!$D$15)-PMT(Assumptions!$D$39,20,Model!$C$9)+PMT(Assumptions!$D$39,20,Model!$C$18)-Depreciation!O74","v":10779096.284560876},{"$f":"Scarcity!Q6+PFP!Q8+'E&AS'!$D$6+($C$34*12*1000*Assumptions!$D$15)-PMT(Assumptions!$D$39,20,Model!$C$9)+PMT(Assumptions!$D$39,20,Model!$C$18)-Depreciation!P74","v":10728950.591298176},{"$f":"Scarcity!R6+PFP!R8+'E&AS'!$D$6+($C$34*12*1000*Assumptions!$D$15)-PMT(Assumptions!$D$39,20,Model!$C$9)+PMT(Assumptions!$D$39,20,Model!$C$18)-Depreciation!Q74","v":10679788.14692298},{"$f":"Scarcity!S6+PFP!S8+'E&AS'!$D$6+($C$34*12*1000*Assumptions!$D$15)-PMT(Assumptions!$D$39,20,Model!$C$9)+PMT(Assumptions!$D$39,20,Model!$C$18)-Depreciation!R74","v":10729624.831444662},{"$f":"Scarcity!T6+PFP!T8+'E&AS'!$D$6+($C$34*12*1000*Assumptions!$D$15)-PMT(Assumptions!$D$39,20,Model!$C$9)+PMT(Assumptions!$D$39,20,Model!$C$18)-Depreciation!S74","v":10680449.166674437},{"$f":"Scarcity!U6+PFP!U8+'E&AS'!$D$6+($C$34*12*1000*Assumptions!$D$15)-PMT(Assumptions!$D$39,20,Model!$C$9)+PMT(Assumptions!$D$39,20,Model!$C$18)-Depreciation!T74","v":10632237.730625195},{"$f":"Scarcity!V6+PFP!V8+'E&AS'!$D$6+($C$34*12*1000*Assumptions!$D$15)-PMT(Assumptions!$D$39,20,Model!$C$9)+PMT(Assumptions!$D$39,20,Model!$C$18)-Depreciation!U74","v":10683006.776250755},{"$f":"Scarcity!W6+PFP!W8+'E&AS'!$D$6+($C$34*12*1000*Assumptions!$D$15)-PMT(Assumptions!$D$39,20,Model!$C$9)+PMT(Assumptions!$D$39,20,Model!$C$18)-Depreciation!V74","v":10634745.190994136}]
[null,"Income Taxes",{"$f":"IF(C45>0,C45*Assumptions!$D$30,0)","v":0},{"$f":"IF(D45>0,D45*Assumptions!$D$30,0)","v":0},{"$f":"IF(E45>0,E45*Assumptions!$D$30,0)","v":0},{"$f":"IF(F45>0,F45*Assumptions!$D$30,0)","v":0},{"$f":"IF(G45>0,G45*Assumptions!$D$30,0)","v":318119.93674627732},{"$f":"IF(H45>0,H45*Assumptions!$D$30,0)","v":307103.68512810505},{"$f":"IF(I45>0,I45*Assumptions!$D$30,0)","v":316608.73827085679},{"$f":"IF(J45>0,J45*Assumptions!$D$30,0)","v":1590079.2705712225},{"$f":"IF(K45>0,K45*Assumptions!$D$30,0)","v":2860941.7476097438},{"$f":"IF(L45>0,L45*Assumptions!$D$30,0)","v":2873622.3621264622},{"$f":"IF(M45>0,M45*Assumptions!$D$30,0)","v":2860045.6093542115},{"$f":"IF(N45>0,N45*Assumptions!$D$30,0)","v":2846735.0674206326},{"$f":"IF(O45>0,O45*Assumptions!$D$30,0)","v":2859694.2442940003},{"$f":"IF(P45>0,P45*Assumptions!$D$30,0)","v":2846390.591871406},{"$f":"IF(Q45>0,Q45*Assumptions!$D$30,0)","v":2833347.7953786664},{"$f":"IF(R45>0,R45*Assumptions!$D$30,0)","v":2846569.4677822688},{"$f":"IF(S45>0,S45*Assumptions!$D$30,0)","v":2833523.163918728},{"$f":"IF(T45>0,T45*Assumptions!$D$30,0)","v":2820732.6699348642},{"$f":"IF(U45>0,U45*Assumptions!$D$30,0)","v":2834201.697739325},{"$f":"IF(V45>0,V45*Assumptions!$D$30,0)","v":2821397.8991707442}]
[null,"Tax Benefit",{"$f":"IF(C45<0,-C45*Assumptions!$D$30,0)","v":8394585.0223269649},{"$f":"IF(D45<0,-D45*Assumptions!$D$30,0)","v":4146761.3434882439},{"$f":"IF(E45<0,-E45*Assumptions!$D$30,0)","v":2145013.3836514712},{"$f":"IF(F45<0,-F45*Assumptions!$D$30,0)","v":692967.70189777564},{"$f":"IF(G45<0,-G45*Assumptions!$D$30,0)","v":0},{"$f":"IF(H45<0,-H45*Assumptions!$D$30,0)","v":0},{"$f":"IF(I45<0,-I45*Assumptions!$D$30,0)","v":0},{"$f":"IF(J45<0,-J45*Assumptions!$D$30,0)","v":0},{"$f":"IF(K45<0,-K45*Assumptions!$D$30,0)","v":0},{"$f":"IF(L45<0,-L45*Assumptions!$D$30,0)","v":0},{"$f":"IF(M45<0,-M45*Assumptions!$D$30,0)","v":0},{"$f":"IF(N45<0,-N45*Assumptions!$D$30,0)","v":0},{"$f":"IF(O45<0,-O45*Assumptions!$D$30,0)","v":0},{"$f":"IF(P45<0,-P45*Assumptions!$D$30,0)","v":0},{"$f":"IF(Q45<0,-Q45*Assumptions!$D$30,0)","v":0},{"$f":"IF(R45<0,-R45*Assumptions!$D$30,0)","v":0},{"$f":"IF(S45<0,-S45*Assumptions!$D$30,0)","v":0},{"$f":"IF(T45<0,-T45*Assumptions!$D$30,0)","v":0},{"$f":"IF(U45<0,-U45*Assumptions!$D$30,0)","v":0},{"$f":"IF(V45<0,-V45*Assumptions!$D$30,0)","v":0}]
[null,"ITC",{"$f":"'Construction CF'!B46*Assumptions!D21","v":0}]
[null,"Net Income Taxes",{"$f":"C46-C47-C48","v":-8394585.0223269649},{"$f":"D46-D47-D48","v":-4146761.3434882439},-2145013.3836514712,-692967.70189777564,318119.93674627732,307103.68512810505,316608.73827085679,1590079.2705712225,2860941.7476097438,2873622.3621264622,2860045.6093542115,2846735.0674206326,2859694.2442940003,2846390.591871406,2833347.7953786664,2846569.4677822688,2833523.163918728,2820732.6699348642,2834201.697739325,2821397.8991707442]
[]
[]
[]
[null,"Notes:"]
[null,"1. Net CONE (Installed) in this cell is calculated and pasted when the model is run, based on an NPV of zero. "]

{"sheet":"Capital Costs","index":9,"n_rows":47,"n_cols":20,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,13,0,19]]}
["Capital Costs","2019$","2019$","2019$","2019$","2019$","2019$","2019$",null,"CC & SC","Onshore Wind","Solar","Battery"]
[2025,{"$f":"Assumptions!F$5","v":"CC - ORTP"},{"$f":"Assumptions!G$5","v":"SC - ORTP"},{"$f":"Assumptions!H$5","v":"Onshore Wind - ORTP"},{"$f":"Assumptions!I$5","v":"Offshore Wind - ORTP"},{"$f":"Assumptions!J$5","v":"Solar - ORTP"},{"$f":"Assumptions!K$5","v":"Battery - ORTP"},{"$f":"Assumptions!L$5","v":"Co-located Resource - ORTP"},null,"BLS PPI WPU114","Bloomberg LCOE","Bloomberg LCOE","Bloomberg LCOE",{"$f":"B2","v":"CC - ORTP"},"SC - ORTP","Onshore Wind - ORTP","Offshore Wind - ORTP","Solar - ORTP","Battery - ORTP","Co-located Resource - ORTP"]
["Cost Component","7HA.02 Combined Cycle (ORTP)","7HA.02 Simple Cycle (ORTP)","Onshore Wind (ORTP)","Offshore Wind","Solar","Battery","Co-located Resource","BLS PPI Escalation Rate",null,null,null,null,"7HA.02 Combined Cycle (ORTP)","7HA.02 Simple Cycle (ORTP)","Onshore Wind (ORTP)","Offshore Wind","Solar","Battery","Co-located Resource"]
["Construction Months",{"$f":"COUNTIF('Construction CF'!$C13:$AX13,\"<>\"&\"\")","v":28},{"$f":"COUNTIF('Construction CF'!$C14:$AX14,\"<>\"&\"\")","v":21},{"$f":"COUNTIF('Construction CF'!$C15:$AX15,\"<>\"&\"\")","v":21},{"$f":"COUNTIF('Construction CF'!$C16:$AX16,\"<>\"&\"\")","v":48},{"$f":"COUNTIF('Construction CF'!$C17:$AX17,\"<>\"&\"\")","v":30},{"$f":"COUNTIF('Construction CF'!$C18:$AX18,\"<>\"&\"\")","v":17},{"$f":"COUNTIF('Construction CF'!$C19:$AX19,\"<>\"&\"\")","v":30}]
["Years to Escalate to Beginning of Construction",{"$f":"A2-(B4/12)-2019","v":3.6666666666667425},{"$f":"A2-(C4/12)-2019","v":4.25},{"$f":"A2-(D4/12)-2019","v":4.25},{"$f":"A2-(E4/12)-2019","v":2},{"$f":"A2-(F4/12)-2019","v":3.5},{"$f":"A2-(G4/12)-2019","v":4.5833333333332575},{"$f":"A2-(H4/12)-2019","v":3.5},null,null,null,null,null,{"$f":"TEXT(EDATE(45809,-B$4+24),\"mmm yyyy\")&\" $\"","v":"Feb 2025 $"},{"$f":"TEXT(EDATE(45809,-C$4+24),\"mmm yyyy\")&\" $\"","v":"Sep 2025 $"},{"$f":"TEXT(EDATE(45809,-D$4+24),\"mmm yyyy\")&\" $\"","v":"Sep 2025 $"},{"$f":"TEXT(EDATE(45809,-E$4+12),\"mmm yyyy\")&\" $\"","v":"Jun 2022 $"},{"$f":"TEXT(EDATE(45809,-F$4+24),\"mmm yyyy\")&\" $\"","v":"Dec 2024 $"},{"$f":"TEXT(EDATE(45809,-G$4+24),\"mmm yyyy\")&\" $\"","v":"Jan 2026 $"},{"$f":"TEXT(EDATE(45809,-H$4+12),\"mmm yyyy\")&\" $\"","v":"Dec 2023 $"}]
[]
["EPC Costs",null,null,null,null,null,null,null,{"$f":"Assumptions!$D$52","v":7.0000000000000001E-3}]
["Civil/Structural/Architectural",49040011.784212932,18868655.911483936,{"$f":"78450000+5625000","v":84075000},null,1291792.3967671543,423748.49237759615,613487.55990325764,null,{"$f":"BLS!$D$74","v":1.040694557934303},{"$f":"'BB LCOE'!$A$6","v":0.9862802609812451},{"$f":"'BB LCOE'!$A$4","v":0.90370227745152265},{"$f":"'BB LCOE'!$A$5","v":0.93410989992234716},{"$f":"B8*J8*(1+$I$7)^B$5","v":52357862.481362313},{"$f":"C8*$J8*(1+$I$7)^C$5","v":20227373.701493189},{"$f":"D8*K8*(1+$I$7)^D$5","v":85416636.753719941},{"$f":"E8*(1+$I$7)^E$5","v":0},{"$f":"F8*L8*(1+$I$7)^F$5","v":1196248.063498707},{"$f":"G8*M8*(1+$I$7)^G$5","v":408687.36787496513},{"$f":"H8*(1+$I$7)^H$5","v":628649.98222641379}]
["Mechanical Costs",267032120.05606568,137734983.90110403,4300000,null,null,null,null,null,{"$f":"BLS!$D$74","v":1.040694557934303},{"$f":"'BB LCOE'!$A$6","v":0.9862802609812451},{"$f":"'BB LCOE'!$A$4","v":0.90370227745152265},{"$f":"'BB LCOE'!$A$5","v":0.93410989992234716},285098443.3185432,147653177.00457612,4368617.7584418161,0,0,0,{"$f":"H9*(1+$I$7)^H$5","v":0}]
["Electrical/Instrumentation Costs",54036721.760018192,27852487.407054689,11328780,null,1578383.7598560541,1293968.6502197757,531828.25791630568,null,{"$f":"BLS!$D$74","v":1.040694557934303},{"$f":"'BB LCOE'!$A$6","v":0.9862802609812451},{"$f":"'BB LCOE'!$A$4","v":0.90370227745152265},{"$f":"'BB LCOE'!$A$5","v":0.93410989992234716},57692629.832635336,29858124.17914407,11509560.34639081,0,1461642.3822518827,1247977.6359884012,{"$f":"H10*(1+$I$7)^H$5","v":544972.46030434931}]
["Construction Management",11414582,7590308.2000000002,2400000,null,804249.97685498488,1467930.465657162,818923.90975652507,null,{"$f":"BLS!$D$74","v":1.040694557934303},{"$f":"'BB LCOE'!$A$6","v":0.9862802609812451},{"$f":"'BB LCOE'!$A$4","v":0.90370227745152265},{"$f":"'BB LCOE'!$A$5","v":0.93410989992234716},12186846.880624695,8136880.6125435084,2438298.2837814791,0,744765.55194887938,1415756.395655358,{"$f":"H11*(1+$I$7)^H$5","v":839163.71734482679}]
["Other Project Costs",29015000,12450000,null,null,null,null,null,null,{"$f":"BLS!$D$74","v":1.040694557934303},{"$f":"'BB LCOE'!$A$6","v":0.9862802609812451},{"$f":"'BB LCOE'!$A$4","v":0.90370227745152265},{"$f":"'BB LCOE'!$A$5","v":0.93410989992234716},30978038.638762724,13346515.181842903,0,0,0,0,{"$f":"H12*(1+$I$7)^H$5","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"BLS!$D$74","v":1.040694557934303},{"$f":"'BB LCOE'!$A$6","v":0.9862802609812451},{"$f":"'BB LCOE'!$A$4","v":0.90370227745152265},{"$f":"'BB LCOE'!$A$5","v":0.93410989992234716},0,0,0,0,0,0]
["Medium Voltage Collection System",null,null,5730000,null,null,null,null,null,{"$f":"BLS!$D$74","v":1.040694557934303},{"$f":"'BB LCOE'!$A$6","v":0.9862802609812451},{"$f":"'BB LCOE'!$A$4","v":0.90370227745152265},{"$f":"'BB LCOE'!$A$5","v":0.93410989992234716},0,0,5821437.1525282804,0,0,0,{"$f":"H14*(1+$I$7)^H$5","v":0}]
["Project Substation and O&M Building",null,null,5350000,null,null,6828904.7535845451,null,null,{"$f":"BLS!$D$74","v":1.040694557934303},{"$f":"'BB LCOE'!$A$6","v":0.9862802609812451},{"$f":"'BB LCOE'!$A$4","v":0.90370227745152265},{"$f":"'BB LCOE'!$A$5","v":0.93410989992234716},0,0,5435373.2575962134,0,0,6586187.7019361425,0]
["Meterological Towers",null,null,421000,null,null,null,null,null,{"$f":"BLS!$D$74","v":1.040694557934303},{"$f":"'BB LCOE'!$A$6","v":0.9862802609812451},{"$f":"'BB LCOE'!$A$4","v":0.90370227745152265},{"$f":"'BB LCOE'!$A$5","v":0.93410989992234716},0,0,427718.15728000115,0,0,0,0]
["Offshore Substation Platform",null,null,null,465000000,null,null,null,null,{"$f":"BLS!$D$74","v":1.040694557934303},{"$f":"'BB LCOE'!$A$6","v":0.9862802609812451},{"$f":"'BB LCOE'!$A$4","v":0.90370227745152265},{"$f":"'BB LCOE'!$A$5","v":0.93410989992234716},0,0,0,471532784.99999988,0,0,0]
["Install Submarine Export Cabling",null,null,null,583000000,null,null,null,null,{"$f":"BLS!$D$74","v":1.040694557934303},{"$f":"'BB LCOE'!$A$6","v":0.9862802609812451},{"$f":"'BB LCOE'!$A$4","v":0.90370227745152265},{"$f":"'BB LCOE'!$A$5","v":0.93410989992234716},0,0,0,591190566.99999988,0,0,0]
["Construct Landfall Transition Box",null,null,null,40000000,null,null,null,null,{"$f":"BLS!$D$74","v":1.040694557934303},{"$f":"'BB LCOE'!$A$6","v":0.9862802609812451},{"$f":"'BB LCOE'!$A$4","v":0.90370227745152265},{"$f":"'BB LCOE'!$A$5","v":0.93410989992234716},0,0,0,40561959.999999993,0,0,0]
["Interarray Cabling ",null,null,null,242250000,null,null,null,null,{"$f":"BLS!$D$74","v":1.040694557934303},{"$f":"'BB LCOE'!$A$6","v":0.9862802609812451},{"$f":"'BB LCOE'!$A$4","v":0.90370227745152265},{"$f":"'BB LCOE'!$A$5","v":0.93410989992234716},0,0,0,245653370.24999994,0,0,0]
["Major Equipment - Wind Turbines, PV Modules, PV Inverters, PV Racks, Batteries",null,null,null,2333000000,15130733.844881427,101550687.93851924,7233943.7843614742,null,{"$f":"BLS!$D$74","v":1.040694557934303},{"$f":"'BB LCOE'!$A$6","v":0.9862802609812451},{"$f":"'BB LCOE'!$A$4","v":0.90370227745152265},{"$f":"'BB LCOE'!$A$5","v":0.93410989992234716},0,0,0,2365776316.9999995,14011625.325053137,97941312.136877492,7412731.6162414812]
["Solar SCADA & Monitoring",null,null,null,null,245333.41296153847,null,219683.58888461537,null,{"$f":"BLS!$D$74","v":1.040694557934303},{"$f":"'BB LCOE'!$A$6","v":0.9862802609812451},{"$f":"'BB LCOE'!$A$4","v":0.90370227745152265},{"$f":"'BB LCOE'!$A$5","v":0.93410989992234716},0,0,0,0,227187.91417354089,0,225113.09645712492]
["Testing & Energization",null,null,null,null,143129.7922615385,291725.57,77623.540461538461,null,{"$f":"BLS!$D$74","v":1.040694557934303},{"$f":"'BB LCOE'!$A$6","v":0.9862802609812451},{"$f":"'BB LCOE'!$A$4","v":0.90370227745152265},{"$f":"'BB LCOE'!$A$5","v":0.93410989992234716},0,0,0,0,132543.53969750126,281356.88383496267,79542.016042171337]
["Other Indirect Costs",null,null,null,null,2476527,10171811.094485134,1719841.1524864668,null,{"$f":"BLS!$D$74","v":1.040694557934303},{"$f":"'BB LCOE'!$A$6","v":0.9862802609812451},{"$f":"'BB LCOE'!$A$4","v":0.90370227745152265},{"$f":"'BB LCOE'!$A$5","v":0.93410989992234716},0,0,0,0,2293356.6069643465,9810278.4493736308,1762347.2432160906]
["Project Contingency",24632306,12269786,{"$f":"SUM(D8:D24)*7%","v":7952334.6000000006},{"$f":"SUM(E10:E24)*5%","v":183162500},{"$f":"(22464508)*5%","v":1123225.4000000001},5834216.5408476694,1020709.1339809105,null,{"$f":"BLS!$D$74","v":1.040694557934303},{"$f":"'BB LCOE'!$A$6","v":0.9862802609812451},{"$f":"'BB LCOE'!$A$4","v":0.90370227745152265},{"$f":"'BB LCOE'!$A$5","v":0.93410989992234716},26298829.123895466,13153324.106583415,8079234.9196816981,185735749.96249995,1040148.7212536634,5626853.2976087611,1045936.0888045129]
["EPC Contractor Fee",20888195,10404778,null,null,null,null,null,null,{"$f":"BLS!$D$74","v":1.040694557934303},{"$f":"'BB LCOE'!$A$6","v":0.9862802609812451},{"$f":"'BB LCOE'!$A$4","v":0.90370227745152265},{"$f":"'BB LCOE'!$A$5","v":0.93410989992234716},22301406.576047231,11154018.276361851,0,0,0,0,0]
["Owners Development Costs",null,null,320000,null,743013.58980539045,964833.56044268317,650651.19655300537,null,{"$f":"BLS!$D$74","v":1.040694557934303},{"$f":"'BB LCOE'!$A$6","v":0.9862802609812451},{"$f":"'BB LCOE'!$A$4","v":0.90370227745152265},{"$f":"'BB LCOE'!$A$5","v":0.93410989992234716},0,0,325106.43783753057,0,688058.36772403005,930540.86409204872,666732.12283740996]
["Total EPC",{"$f":"SUM(B8:B27)","v":456058936.6002968},227170999.41964266,121877114.59999999,3846412500,23536389.173388086,128827827.06613381,12886692.124304099,null,null,null,null,null,{"$f":"SUM(N7:N27)","v":486914056.85187101},243529413.06254506,123821983.06725778,3900450749.2124991,21795576.472565688,124248950.73324177,13205188.343474381]
[]
["Non-EPC Costs",null,null,null,null,null,null,null,{"$f":"Assumptions!$D$53","v":1.9E-2}]
["Owner's Development Costs (Services)",null,null,null,{"$f":"E28*5%","v":192320625},null,null,null,null,{"$f":"BLS!$D$74","v":1.040694557934303},{"$f":"'BB LCOE'!$A$6","v":0.9862802609812451},{"$f":"'BB LCOE'!$A$4","v":0.90370227745152265},{"$f":"'BB LCOE'!$A$5","v":0.93410989992234716},{"$f":"B31*$J31*(1+$I$30)^B$5","v":0},0,{"$f":"D31*K31*(1+$I$30)^D$5","v":0},{"$f":"E31*(1+$I$30)^E$5","v":199698236.49562499},{"$f":"F31*L31*(1+$I$30)^F$5","v":0},0,{"$f":"H31*(1+$I$30)^H$5","v":0}]
["Owner's Contingency",13967000,6957000,{"$f":"5%*D27","v":16000},null,{"$f":"$F$27*10%","v":74301.358980539051},{"$f":"$G$27*5%","v":48241.678022134161},65065.119655300543,null,{"$f":"BLS!$D$74","v":1.040694557934303},{"$f":"'BB LCOE'!$A$6","v":0.9862802609812451},{"$f":"'BB LCOE'!$A$4","v":0.90370227745152265},{"$f":"'BB LCOE'!$A$5","v":0.93410989992234716},15573937.399859695,7843060.5689439178,{"$f":"D32*K32*(1+$I$30)^D$5","v":17094.665458379583},{"$f":"E32*(1+$I$30)^E$5","v":0},71718.595820537594,49123.057551983831,{"$f":"H32*(1+$I$30)^H$5","v":69495.690891043632}]
["Electrical Interconnection",25000000,25000000,7000000,55000000,5700000,5400000,817000,null,{"$f":"BLS!$D$74","v":1.040694557934303},{"$f":"'BB LCOE'!$A$6","v":0.9862802609812451},{"$f":"'BB LCOE'!$A$4","v":0.90370227745152265},{"$f":"'BB LCOE'!$A$5","v":0.93410989992234716},27876310.946981627,28184061.265430205,{"$f":"D33*K33*(1+$I$30)^D$5","v":7478916.1380410679},{"$f":"E33*(1+$I$30)^E$5","v":57109854.999999993},5501864.3236947497,5498658.4558481667,{"$f":"H33*(1+$I$30)^H$5","v":872633.13675251533}]
["Electrical System Upgrade Costs/Substation Upgrades",0,0,38000000,null,null,null,null,null,{"$f":"BLS!$D$74","v":1.040694557934303},{"$f":"'BB LCOE'!$A$6","v":0.9862802609812451},{"$f":"'BB LCOE'!$A$4","v":0.90370227745152265},{"$f":"'BB LCOE'!$A$5","v":0.93410989992234716},0,0,{"$f":"D34*K34*(1+$I$30)^D$5","v":40599830.463651508},{"$f":"E34*(1+$I$30)^E$5","v":0},0,0,{"$f":"H34*(1+$I$30)^H$5","v":0}]
["Gas Interconnection",10000000,10000000,null,null,null,null,null,null,{"$f":"BLS!$D$74","v":1.040694557934303},{"$f":"'BB LCOE'!$A$6","v":0.9862802609812451},{"$f":"'BB LCOE'!$A$4","v":0.90370227745152265},{"$f":"'BB LCOE'!$A$5","v":0.93410989992234716},11150524.378792651,11273624.506172083,{"$f":"D35*K35*(1+$I$30)^D$5","v":0},{"$f":"E35*(1+$I$30)^E$5","v":0},0,0,{"$f":"H35*(1+$I$30)^H$5","v":0}]
["Fuel Inventories",{"$f":"1500000*3","v":4500000},{"$f":"1500000*3","v":4500000},null,null,null,null,null,{"$f":"Assumptions!$D$54","v":5.3999999999999999E-2},{"$f":"BLS!$D$74","v":1.040694557934303},{"$f":"'BB LCOE'!$A$6","v":0.9862802609812451},{"$f":"'BB LCOE'!$A$4","v":0.90370227745152265},{"$f":"'BB LCOE'!$A$5","v":0.93410989992234716},{"$f":"B36*J36*(1+$I36)^B$5","v":5679167.8400066625},{"$f":"C36*J36*(1+$I36)^C$5","v":5856098.7771235434},{"$f":"D36*(1+$I36)^D$5","v":0},{"$f":"E36*(1+$I36)^E$5","v":0},{"$f":"F36*(1+$I36)^F$5","v":0},{"$f":"G36*(1+$I36)^G$5","v":0},{"$f":"H36*(1+$I36)^H$5","v":0}]
["Financing Fees (4% of costs financed through debt)",{"$f":"4%*B28","v":18242357.464011874},9086839.9767857064,4875084.5839999998,153856500,941455.56693552341,5153113.0826453529,515467.68497216399,null,{"$f":"BLS!$D$74","v":1.040694557934303},{"$f":"'BB LCOE'!$A$6","v":0.9862802609812451},{"$f":"'BB LCOE'!$A$4","v":0.90370227745152265},{"$f":"'BB LCOE'!$A$5","v":0.93410989992234716},{"$f":"B37*J37*(1+$I$30)^B$5","v":20341185.162911449},{"$f":"C37*$J37*(1+$I$30)^C$5","v":10244162.184595549},{"$f":"D37*K37*(1+$I$30)^D$5","v":5208621.2527989745},{"$f":"E37*(1+$I$30)^E$5","v":159758589.19649997},{"$f":"F37*L37*(1+$I$30)^F$5","v":908729.9642221703},{"$f":"G37*M37*(1+$I$30)^G$5","v":5247260.8936721636},{"$f":"H37*(1+$I$30)^H$5","v":550568.15524090198}]
["Working Capital (1% of EPC costs)",{"$f":"1%*B28","v":4560589.3660029685},2271709.9941964266,1218771.1459999999,38464125,235363.89173388085,1288278.2706613382,128866.921243041,null,{"$f":"BLS!$D$74","v":1.040694557934303},{"$f":"'BB LCOE'!$A$6","v":0.9862802609812451},{"$f":"'BB LCOE'!$A$4","v":0.90370227745152265},{"$f":"'BB LCOE'!$A$5","v":0.93410989992234716},{"$f":"B38*J38*(1+$I$30)^B$5","v":5085296.2907278622},{"$f":"C38*$J38*(1+$I$30)^C$5","v":2561040.5461488874},{"$f":"D38*K38*(1+$I$30)^D$5","v":1302155.3131997436},{"$f":"E38*(1+$I$30)^E$5","v":39939647.299124993},{"$f":"F38*L38*(1+$I$30)^F$5","v":227182.49105554257},{"$f":"G38*M38*(1+$I$30)^G$5","v":1311815.2234180409},{"$f":"H38*(1+$I$30)^H$5","v":137642.03881022549}]
["Total Non-EPC",{"$f":"SUM(B31:B38)","v":76269946.83001484},57815549.970982134,51109855.729999997,439641250,6951120.8176499438,11889633.031328827,1526399.7258705057,null,null,null,null,null,{"$f":"SUM(N31:N38)","v":85706422.019279957},65962047.848414183,54606617.833149672,456506327.99124998,6709495.3747930005,12106857.630490353,1630339.0216946865]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
["Total Overnight Capital Costs",{"$f":"B28+B39","v":532328883.43031162},284986549.39062476,172986970.32999998,4286053750,30487509.991038032,140717460.09746265,14413091.850174604,null,null,null,null,null,{"$f":"N28+N39","v":572620478.87115097},309491460.91095924,178428600.90040743,4356957077.2037487,28505071.847358689,136355808.36373213,14835527.365169067]
[]
["$/KW",{"$f":"B42/(B45*1000)","v":955.70715158045175},757.94295050698076,2096.8117615757574,5357.5671874999998,1524.3754995519016,938.11640064975097,1441.3091850174603,null,null,null,null,null,{"$f":"N42/(N45*1000)","v":1028.0439477040413},823.11558752914698,2162.7709200049385,5446.1963465046856,1425.2535923679345,909.03872242488092,1483.5527365169066]
["Installed Capacity (MW)",{"$f":"INDEX(Assumptions!$C$5:$L$15,MATCH(Assumptions!$C$15,Assumptions!$C$5:$C$15,0),MATCH('Capital Costs'!B$2,Assumptions!$C$5:$L$5,0))","v":557},{"$f":"INDEX(Assumptions!$C$5:$L$15,MATCH(Assumptions!$C$15,Assumptions!$C$5:$C$15,0),MATCH('Capital Costs'!C$2,Assumptions!$C$5:$L$5,0))","v":376},{"$f":"INDEX(Assumptions!$C$5:$L$15,MATCH(Assumptions!$C$15,Assumptions!$C$5:$C$15,0),MATCH('Capital Costs'!D$2,Assumptions!$C$5:$L$5,0))","v":82.5},{"$f":"INDEX(Assumptions!$C$5:$L$15,MATCH(Assumptions!$C$15,Assumptions!$C$5:$C$15,0),MATCH('Capital Costs'!E$2,Assumptions!$C$5:$L$5,0))","v":800},{"$f":"INDEX(Assumptions!$C$5:$L$15,MATCH(Assumptions!$C$15,Assumptions!$C$5:$C$15,0),MATCH('Capital Costs'!F$2,Assumptions!$C$5:$L$5,0))","v":20},{"$f":"INDEX(Assumptions!$C$5:$L$15,MATCH(Assumptions!$C$15,Assumptions!$C$5:$C$15,0),MATCH('Capital Costs'!G$2,Assumptions!$C$5:$L$5,0))","v":150},{"$f":"INDEX(Assumptions!$C$5:$L$15,MATCH(Assumptions!$C$15,Assumptions!$C$5:$C$15,0),MATCH('Capital Costs'!H$2,Assumptions!$C$5:$L$5,0))","v":10},null,null,null,null,null,{"$f":"B45","v":557},376,82.5,800,20,150,10]
["Non-Depreciable Assets",{"$f":"SUM(B36,B38)","v":9060589.3660029694},6771709.9941964261,1218771.1459999999,38464125,235363.89173388085,1288278.2706613382,128866.921243041,null,null,null,null,null,{"$f":"SUM(N36,N38)","v":10764464.130734526},8417139.3232724313,1302155.3131997436,39939647.299124993,227182.49105554257,1311815.2234180409,137642.03881022549]
["Non-Depreciable $/kW",{"$f":"B46/(B45*1000)","v":16.266767263919157},18.00986700584156,14.772983587878787,48.080156250000002,11.768194586694042,8.5885218044089218,12.886692124304099,null,null,null,null,null,{"$f":"N46/(N45*1000)","v":19.325788385519793},22.386008838490508,15.783700766057498,49.924559123906242,11.359124552777129,8.7454348227869385,13.764203881022549]

{"sheet":"E&AS","index":10,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"Energy & Ancillary Services Revenue"]
[]
[null,"Technology",null,{"$f":"'Controls & Results'!D8","v":"Battery - ORTP"}]
[]
[null,"Year"]
[null,"E&AS Revenue","Availability",{"$f":"OFFSET(D9,MATCH($D$3,$B$9:$B$15,0)-1,0)","v":11302501.732478712}]
[null,null,null,null,null,null,null,"Annual Update EAS Multiplier"]
[null,null,null,null,null,null,"With FRM",null,"With FRM"]
[null,{"$f":"Assumptions!$F$5","v":"CC - ORTP"},{"$f":"PFP!F37","v":0.92769999999999997},{"$f":"C9*IF('Controls & Results'!$D$9=\"FRM Sunset\",#REF!,G9)","v":22465869.603583351},null,null,{"$f":"$H9*I9","v":24216739.898225021},{"$f":"ICE!$G$99","v":1.1575959727361886},20919855]
[null,{"$f":"Assumptions!$G$5","v":"SC - ORTP"},{"$f":"PFP!F38","v":0.98},{"$f":"C10*IF('Controls & Results'!$D$9=\"FRM Sunset\",#REF!,G10)","v":14051573.452712635},null,null,{"$f":"$H10*I10","v":14338340.257870035},{"$f":"ICE!$G$99","v":1.1575959727361886},12386308]
[null,{"$f":"Assumptions!$H$5","v":"Onshore Wind - ORTP"},1,{"$f":"C11*IF('Controls & Results'!$D$9=\"FRM Sunset\",#REF!,G11)","v":17259110.124529593},null,null,{"$f":"$H11*I11","v":17259110.124529593},{"$f":"ICE!$G$100","v":1.2772983832392613},13512199.147046635]
[null,{"$f":"Assumptions!$I$5","v":"Offshore Wind - ORTP"},1,{"$f":"C12*IF('Controls & Results'!$D$9=\"FRM Sunset\",#REF!,G12)","v":143752522.83713666},null,null,143752522.83713666,null,143752522.83713666]
[null,{"$f":"Assumptions!$J$5","v":"Solar - ORTP"},1,{"$f":"C13*IF('Controls & Results'!$D$9=\"FRM Sunset\",#REF!,G13)","v":1522538.6331090885},null,null,{"$f":"$H13*I13","v":1522538.6331090885},{"$f":"ICE!$G$100","v":1.2772983832392613},1191999.1860068685]
[null,{"$f":"Assumptions!$K$5","v":"Battery - ORTP"},1,{"$f":"C14*IF('Controls & Results'!$D$9=\"FRM Sunset\",#REF!,G14)","v":11302501.732478712},null,null,{"$f":"$H14*I14","v":11302501.732478712},{"$f":"ICE!$G$100","v":1.2772983832392613},8848756]
[null,{"$f":"Assumptions!$L$5","v":"Co-located Resource - ORTP"},1,{"$f":"C15*IF('Controls & Results'!$D$9=\"FRM Sunset\",#REF!,G15)","v":320098.27877122897}," ",null,320098.27877122897,null,320098.27877122897]
[]
[]
[null,null,null," "]

{"sheet":"PFP","index":11,"n_rows":53,"n_cols":23,"rows_kept":53,"cut":false,"hidden":false,"merged":[[7,1,8,1]]}
[null,"Pay for Performance"]
[]
[null,"Technology",{"$f":"'Controls & Results'!D8","v":"Battery - ORTP"}]
[null,null,{"$f":"'Controls & Results'!D9","v":"With FRM"}]
[null,null,{"$f":"'Controls & Results'!#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Year",null,2026,{"$f":"D7+1","v":2027},{"$f":"E7+1","v":2028},2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"ICAP","ICAP: 2025$",{"$f":"D9/(1+Assumptions!$D$36)^(D7-$D$7)","v":1699707.4800000002},{"$f":"E9/(1+Assumptions!$D$36)^(E7-$D$7)","v":1666379.8823529414},{"$f":"F9/(1+Assumptions!$D$36)^(F7-$D$7)","v":1633705.7670126876},{"$f":"G9/(1+Assumptions!$D$36)^(G7-$D$7)","v":1699707.4800000004},{"$f":"H9/(1+Assumptions!$D$36)^(H7-$D$7)","v":1666379.8823529417},{"$f":"I9/(1+Assumptions!$D$36)^(I7-$D$7)","v":1633705.7670126879},{"$f":"J9/(1+Assumptions!$D$36)^(J7-$D$7)","v":1699707.4800000002},{"$f":"K9/(1+Assumptions!$D$36)^(K7-$D$7)","v":1666379.8823529417},{"$f":"L9/(1+Assumptions!$D$36)^(L7-$D$7)","v":1633705.7670126879},{"$f":"M9/(1+Assumptions!$D$36)^(M7-$D$7)","v":1699707.4800000004},{"$f":"N9/(1+Assumptions!$D$36)^(N7-$D$7)","v":1666379.8823529414},{"$f":"O9/(1+Assumptions!$D$36)^(O7-$D$7)","v":1633705.7670126881},{"$f":"P9/(1+Assumptions!$D$36)^(P7-$D$7)","v":1699707.4800000002},{"$f":"Q9/(1+Assumptions!$D$36)^(Q7-$D$7)","v":1666379.8823529414},{"$f":"R9/(1+Assumptions!$D$36)^(R7-$D$7)","v":1633705.7670126876},{"$f":"S9/(1+Assumptions!$D$36)^(S7-$D$7)","v":1699707.4800000007},{"$f":"T9/(1+Assumptions!$D$36)^(T7-$D$7)","v":1666379.8823529417},{"$f":"U9/(1+Assumptions!$D$36)^(U7-$D$7)","v":1633705.7670126876},{"$f":"V9/(1+Assumptions!$D$36)^(V7-$D$7)","v":1699707.4800000002},{"$f":"W9/(1+Assumptions!$D$36)^(W7-$D$7)","v":1666379.8823529414}]
[null,null,"ICAP: Nominal",{"$f":"OFFSET(D13,MATCH($C$3,$B$13:$B$19,0)-1,0)","v":1699707.4800000002},{"$f":"OFFSET(E13,MATCH($C$3,$B$13:$B$19,0)-1,0)","v":1699707.4800000002},1699707.4800000002,1803743.1754358404,1803743.1754358404,1803743.1754358404,1914146.6877179171,1914146.6877179171,1914146.6877179171,2031307.7781797554,2031307.7781797554,2031307.7781797554,2155640.0646665818,2155640.0646665818,2155640.0646665818,2287582.4817446941,2287582.4817446941,2287582.4817446941,2427600.8302873229,2427600.8302873229]
[]
[]
[null,null,"Plant Capacity (MW)"]
[null,{"$f":"Assumptions!$F$5","v":"CC - ORTP"},{"$f":"Assumptions!F15*Assumptions!F17","v":501.3},{"$f":"D24*12*1000*$C13","v":3868921.840698001},3868921.840698001,3868921.840698001,4105730.8087234437,4105730.8087234437,4105730.8087234437,4357034.380063788,4357034.380063788,4357034.380063788,4623719.7403987329,4623719.7403987329,4623719.7403987329,4906728.3782690577,4906728.3782690577,4906728.3782690577,5207059.4088461511,5207059.4088461511,5207059.4088461511,5525773.1011428051,5525773.1011428051]
[null,{"$f":"Assumptions!$G$5","v":"SC - ORTP"},{"$f":"Assumptions!G15*Assumptions!G17","v":360.96},{"$f":"D25*12*1000*$C14","v":4090176.0798720005},4090176.0798720005,4090176.0798720005,4340527.5773688061,4340527.5773688061,4340527.5773688061,4606202.5893243961,4606202.5893243961,4606202.5893243961,4888139.0374117633,4888139.0374117633,4888139.0374117633,5187332.2516136626,5187332.2516136626,5187332.2516136626,5504838.4840704314,5504838.4840704314,5504838.4840704314,5841778.6380034126,5841778.6380034126]
[null,{"$f":"Assumptions!$H$5","v":"Onshore Wind - ORTP"},{"$f":"Assumptions!H15","v":82.5},{"$f":"D26*12*1000*$C15","v":277562.54244552949},277562.54244552949,277562.54244552949,294551.59054353536,294551.59054353536,294551.59054353536,312580.50429752411,312580.50429752411,312580.50429752411,331712.93180456699,331712.93180456699,331712.93180456699,352016.41693446087,352016.41693446087,352016.41693446087,373562.6377821854,373562.6377821854,373562.6377821854,396427.6597155573,396427.6597155573]
[null,{"$f":"Assumptions!$I$5","v":"Offshore Wind - ORTP"},{"$f":"Assumptions!I15","v":800},{"$f":"D27*12*1000*$C16","v":3085689.9580677333},3085689.9580677333,3085689.9580677333,3274558.8690211438,3274558.8690211438,3274558.8690211438,3474988.0682761888,3474988.0682761888,3474988.0682761888,3687685.1379592381,3687685.1379592381,3687685.1379592381,3913400.9698834466,3913400.9698834466,3913400.9698834466,4152932.4164480735,4152932.4164480735,4152932.4164480735,4407125.1037940271,4407125.1037940271]
[null,{"$f":"Assumptions!$J$5","v":"Solar - ORTP"},{"$f":"Assumptions!J15","v":20},{"$f":"D28*12*1000*$C17","v":121551.68836741126},121551.68836741126,121551.68836741126,128991.62410900381,128991.62410900381,128991.62410900381,136886.94343746768,136886.94343746768,136886.94343746768,145265.51947138819,145265.51947138819,145265.51947138819,154156.93138719292,154156.93138719292,154156.93138719292,163592.56884354021,163592.56884354021,163592.56884354021,173605.74279731562,173605.74279731562]
[null,{"$f":"Assumptions!$K$5","v":"Battery - ORTP"},{"$f":"Assumptions!K15","v":150},{"$f":"D29*12*1000*$C18","v":1699707.4800000002},1699707.4800000002,1699707.4800000002,1803743.1754358404,1803743.1754358404,1803743.1754358404,1914146.6877179171,1914146.6877179171,1914146.6877179171,2031307.7781797554,2031307.7781797554,2031307.7781797554,2155640.0646665818,2155640.0646665818,2155640.0646665818,2287582.4817446941,2287582.4817446941,2287582.4817446941,2427600.8302873229,2427600.8302873229]
[null,{"$f":"Assumptions!$L$5","v":"Co-located Resource - ORTP"},{"$f":"Assumptions!L15","v":10},{"$f":"D30*12*1000*$C19","v":92682.892171852873},92682.892171852873,92682.892171852873,98355.826635907637,98355.826635907637,98355.826635907637,104375.99007263826,104375.99007263826,104375.99007263826,110764.6356730043,110764.6356730043,110764.6356730043,117544.31749327756,117544.31749327756,117544.31749327756,124738.9700784061,124738.9700784061,124738.9700784061,132373.99295896516,132373.99295896516]
[]
[null,"PPR Tariff Rate ($/MWh)","Inflation Rate (%)"]
[null,{"$f":"VLOOKUP(C3,B37:E43,4,FALSE)","v":9337},0.02,{"$f":"B22","v":9337},{"$f":"D22","v":9337},{"$f":"E22","v":9337},{"$f":"D22*((1+$C$22)^3)","v":9908.4990959999996},{"$f":"G22","v":9908.4990959999996},{"$f":"G22","v":9908.4990959999996},{"$f":"G22*((1+$C$22)^3)","v":10514.978508667968},{"$f":"J22","v":10514.978508667968},{"$f":"J22","v":10514.978508667968},{"$f":"J22*((1+$C$22)^3)","v":11158.579313226515},{"$f":"M22","v":11158.579313226515},{"$f":"M22","v":11158.579313226515},{"$f":"M22*((1+$C$22)^3)","v":11841.573635830484},{"$f":"P22","v":11841.573635830484},{"$f":"P22","v":11841.573635830484},{"$f":"P22*((1+$C$22)^3)","v":12566.372674932396},{"$f":"S22","v":12566.372674932396},{"$f":"S22","v":12566.372674932396},{"$f":"S22*((1+$C$22)^3)","v":13335.535213619658},{"$f":"V22","v":13335.535213619658}]
[null,"Technology Specific, CCP-specific Net Performance Payments"]
[null,{"$f":"Assumptions!$F$5","v":"CC - ORTP"},null,{"$f":"($D37*D$22*($F37-$G37))/1000/12","v":0.64314812166666691},0.64314812166666691,0.64314812166666691,0.68251393189764009,0.68251393189764009,0.68251393189764009,0.7242892446412309,0.7242892446412309,0.7242892446412309,0.76862154072723132,0.76862154072723132,0.76862154072723132,0.81566732799206365,0.81566732799206365,0.81566732799206365,0.86559269380380188,0.86559269380380188,0.86559269380380188,0.91857389140614487,0.91857389140614487]
[null,{"$f":"Assumptions!$G$5","v":"SC - ORTP"},null,{"$f":"($D38*D$22*($F38-$G38))/1000/12","v":0.94428193333333343},0.94428193333333343,0.94428193333333343,1.0020795419088002,1.0020795419088002,1.0020795419088002,1.0634148265099539,1.0634148265099539,1.0634148265099539,1.1285043212109753,1.1285043212109753,1.1285043212109753,1.1975778137036566,1.1975778137036566,1.1975778137036566,1.2708791565248301,1.2708791565248301,1.2708791565248301,1.3486671279374016,1.3486671279374016]
[null,{"$f":"Assumptions!$H$5","v":"Onshore Wind - ORTP"},null,{"$f":"($D39*D$22*($F39-($F39*$G39))/1000/12)","v":0.28036620449043381},0.28036620449043381,0.28036620449043381,0.29752685913488425,0.29752685913488425,0.29752685913488425,0.31573788312881224,0.31573788312881224,0.31573788312881224,0.33506356747936056,0.33506356747936056,0.33506356747936056,0.35557213831763718,0.35557213831763718,0.35557213831763718,0.37733599775978321,0.37733599775978321,0.37733599775978321,0.40043197951066395,0.40043197951066395]
[null,{"$f":"Assumptions!$I$5","v":"Offshore Wind - ORTP"},null,{"$f":"($D40*D$22*($F40-($F40*$G40))/1000/12)","v":0.32142603729872227},0.32142603729872227,0.32142603729872227,0.34109988218970244,0.34109988218970244,0.34109988218970244,0.36197792377876969,0.36197792377876969,0.36197792377876969,0.38413386853742065,0.38413386853742065,0.38413386853742065,0.40764593436285906,0.40764593436285906,0.40764593436285906,0.432597126713341,0.432597126713341,0.432597126713341,0.45907553164521109,0.45907553164521109]
[null,{"$f":"Assumptions!$J$5","v":"Solar - ORTP"},null,{"$f":"($D41*D$22*($F41-($F41*$G41))/1000/12)","v":0.50646536819754695},0.50646536819754695,0.50646536819754695,0.5374651004541825,0.5374651004541825,0.5374651004541825,0.57036226432278203,0.57036226432278203,0.57036226432278203,0.60527299779745081,0.60527299779745081,0.60527299779745081,0.64232054744663714,0.64232054744663714,0.64232054744663714,0.68163570351475089,0.68163570351475089,0.68163570351475089,0.72335726165548175,0.72335726165548175]
[null,{"$f":"Assumptions!$K$5","v":"Battery - ORTP"},null,{"$f":"($D42*D$22*($F42-$G42))/1000/12","v":0.94428193333333343},0.94428193333333343,0.94428193333333343,1.0020795419088002,1.0020795419088002,1.0020795419088002,1.0634148265099539,1.0634148265099539,1.0634148265099539,1.1285043212109753,1.1285043212109753,1.1285043212109753,1.1975778137036566,1.1975778137036566,1.1975778137036566,1.2708791565248301,1.2708791565248301,1.2708791565248301,1.3486671279374016,1.3486671279374016]
[null,{"$f":"Assumptions!$L$5","v":"Co-located Resource - ORTP"},null,{"$f":"($D43*D$22*($F43-($F43*$G43))/1000/12)","v":0.77235743476544061},0.77235743476544061,0.77235743476544061,0.81963188863256364,0.81963188863256364,0.81963188863256364,0.86979991727198558,0.86979991727198558,0.86979991727198558,0.92303863060836921,0.92303863060836921,0.92303863060836921,0.97953597911064627,0.97953597911064627,0.97953597911064627,1.0394914173200507,1.0394914173200507,1.0394914173200507,1.1031166079913763,1.1031166079913763]
[]
[]
[null,"Pay for Performance",null,"[H]","[PPR]","[A]","[Br]"]
[null,"Technology",null,"Scarcity Hours at Criteria","Performance Payment Rate","Average Actual Performance","Average Balancing Ratio","Net Performance Payments"]
[null,null,null,"hrs","$/MWh","%","%","$/kW-mo"]
[null,null,null,"[1]","[2]","[3]","[4]","[5]"]
[null,"CC - ORTP",null,7.4,9337,0.92769999999999997,0.81599999999999995,{"$f":"(D37*E37*(F37-G37))/1000/12","v":0.64314812166666691}]
[null,"SC - ORTP",null,7.4,9337,0.98,{"$f":"G37","v":0.81599999999999995},{"$f":"(D38*E38*(F38-G38))/1000/12","v":0.94428193333333343}]
[null,"Onshore Wind - ORTP",null,7.4,9337,0.2646366601166445,{"$f":"G38","v":0.81599999999999995},{"$f":"(D39*E39*(F39-(F39*G39)))/1000/12","v":0.28036620449043381}]
[null,"Offshore Wind - ORTP",null,7.4,9337,0.30339288980945694,0.81599999999999995,{"$f":"(D40*E40*(F40-(F40*G40)))/1000/12","v":0.32142603729872227}]
[null,"Solar - ORTP",null,7.4,9337,0.47805085405405406,0.81599999999999995,0.50646536819754695]
[null,"Battery - ORTP",null,7.4,9337,0.98,0.81599999999999995,{"$f":"(D42*E42*(F42-G42))/1000/12","v":0.94428193333333343}]
[null,"Co-located Resource - ORTP",null,7.4,9337,{"$f":"((F41*5)+(F42*5))/10","v":0.72902542702702711},0.81599999999999995,0.77235743476544061]
[]
[]
[]
[null,"NOTES (IN PROCESS)"]
[null,"[1] - ISO-NE values"]
[null,"[2] - ISO-NE values"]
[null,"[3] - Mott MacDonald values"]
[null,"[4] - ISO-NE values"]
[null,"[5] - ([1] x [2] x ([3] - [4]) / 1000 / 12 non-intermittent"]
[null,"[5] - ([1] x [2] x ([3] - ([3] * [4])) / 1000 / 12 intermittent"]

{"sheet":"Scarcity","index":12,"n_rows":37,"n_cols":23,"rows_kept":37,"cut":false,"hidden":false,"merged":[[2,2,2,3],[5,1,6,1]]}
[null,"Scarcity Adder"]
[]
[null,"Technology",{"$f":"'Controls & Results'!D8","v":"Battery - ORTP"}]
[]
[null,"Year",null,2026,{"$f":"D5+1","v":2027},{"$f":"E5+1","v":2028},2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[null,"ICAP","ICAP: 2025$",{"$f":"D7/(1+Assumptions!$D$36)^(D5-$D$5)","v":1087799.9999999998},{"$f":"E7/(1+Assumptions!$D$36)^(E5-$D$5)","v":1066470.588235294},{"$f":"F7/(1+Assumptions!$D$36)^(F5-$D$5)","v":1045559.4002306802},{"$f":"G7/(1+Assumptions!$D$36)^(G5-$D$5)","v":1025058.2355202748},{"$f":"H7/(1+Assumptions!$D$36)^(H5-$D$5)","v":1004959.0544316419},{"$f":"I7/(1+Assumptions!$D$36)^(I5-$D$5)","v":985253.97493298224},{"$f":"J7/(1+Assumptions!$D$36)^(J5-$D$5)","v":965935.26954213949},{"$f":"K7/(1+Assumptions!$D$36)^(K5-$D$5)","v":946995.36229621537},{"$f":"L7/(1+Assumptions!$D$36)^(L5-$D$5)","v":928426.82578060322},{"$f":"M7/(1+Assumptions!$D$36)^(M5-$D$5)","v":910222.37821627769},{"$f":"N7/(1+Assumptions!$D$36)^(N5-$D$5)","v":892374.88060419378},{"$f":"O7/(1+Assumptions!$D$36)^(O5-$D$5)","v":874877.33392568026},{"$f":"P7/(1+Assumptions!$D$36)^(P5-$D$5)","v":857722.87639772566},{"$f":"Q7/(1+Assumptions!$D$36)^(Q5-$D$5)","v":840904.78078208398},{"$f":"R7/(1+Assumptions!$D$36)^(R5-$D$5)","v":824416.45174714108},{"$f":"S7/(1+Assumptions!$D$36)^(S5-$D$5)","v":808251.42328151106},{"$f":"T7/(1+Assumptions!$D$36)^(T5-$D$5)","v":792403.35615834408},{"$f":"U7/(1+Assumptions!$D$36)^(U5-$D$5)","v":776866.03544935689},{"$f":"V7/(1+Assumptions!$D$36)^(V5-$D$5)","v":761633.36808760487},{"$f":"W7/(1+Assumptions!$D$36)^(W5-$D$5)","v":746699.38047804404}]
[null,null,"ICAP: Nominal",{"$f":"OFFSET(D11,MATCH($C$3,$B$11:$B$17,0)-1,0)","v":1087799.9999999998},{"$f":"OFFSET(E11,MATCH($C$3,$B$11:$B$17,0)-1,0)","v":1087799.9999999998},1087799.9999999998,1087799.9999999998,1087799.9999999998,1087799.9999999998,1087799.9999999998,1087799.9999999998,1087799.9999999998,1087799.9999999998,1087799.9999999998,1087799.9999999998,1087799.9999999998,1087799.9999999998,1087799.9999999998,1087799.9999999998,1087799.9999999998,1087799.9999999998,1087799.9999999998,1087799.9999999998]
[]
[]
[null,null,"Plant Capacity (MW)"]
[null,{"$f":"Assumptions!$F$5","v":"CC - ORTP"},{"$f":"Assumptions!F15*Assumptions!F17","v":501.3},{"$f":"$G$24*12*1000*$C11","v":3441414.4739999999},3441414.4739999999,3441414.4739999999,3441414.4739999999,3441414.4739999999,3441414.4739999999,3441414.4739999999,3441414.4739999999,3441414.4739999999,3441414.4739999999,3441414.4739999999,3441414.4739999999,3441414.4739999999,3441414.4739999999,3441414.4739999999,3441414.4739999999,3441414.4739999999,3441414.4739999999,3441414.4739999999,3441414.4739999999]
[null,{"$f":"Assumptions!$G$5","v":"SC - ORTP"},{"$f":"Assumptions!G15*Assumptions!G17","v":360.96},{"$f":"$G$25*12*1000*$C12","v":2617681.9199999995},2617681.9199999995,2617681.9199999995,2617681.9199999995,2617681.9199999995,2617681.9199999995,2617681.9199999995,2617681.9199999995,2617681.9199999995,2617681.9199999995,2617681.9199999995,2617681.9199999995,2617681.9199999995,2617681.9199999995,2617681.9199999995,2617681.9199999995,2617681.9199999995,2617681.9199999995,2617681.9199999995,2617681.9199999995]
[null,{"$f":"Assumptions!$H$5","v":"Onshore Wind - ORTP"},{"$f":"Assumptions!H15","v":82.5},{"$f":"$G$26*12*1000*$C13","v":161560.68100121146},161560.68100121146,161560.68100121146,161560.68100121146,161560.68100121146,161560.68100121146,161560.68100121146,161560.68100121146,161560.68100121146,161560.68100121146,161560.68100121146,161560.68100121146,161560.68100121146,161560.68100121146,161560.68100121146,161560.68100121146,161560.68100121146,161560.68100121146,161560.68100121146,161560.68100121146]
[null,{"$f":"Assumptions!$I$5","v":"Offshore Wind - ORTP"},{"$f":"Assumptions!I15","v":800},{"$f":"$G$27*12*1000*$C14","v":1796085.9076719852},1796085.9076719852,1796085.9076719852,1796085.9076719852,1796085.9076719852,1796085.9076719852,1796085.9076719852,1796085.9076719852,1796085.9076719852,1796085.9076719852,1796085.9076719852,1796085.9076719852,1796085.9076719852,1796085.9076719852,1796085.9076719852,1796085.9076719852,1796085.9076719852,1796085.9076719852,1796085.9076719852,1796085.9076719852]
[null,{"$f":"Assumptions!$J$5","v":"Solar - ORTP"},{"$f":"Assumptions!J15","v":20},{"$f":"$G$28*12*1000*$C15","v":70751.526400000002},70751.526400000002,70751.526400000002,70751.526400000002,70751.526400000002,70751.526400000002,70751.526400000002,70751.526400000002,70751.526400000002,70751.526400000002,70751.526400000002,70751.526400000002,70751.526400000002,70751.526400000002,70751.526400000002,70751.526400000002,70751.526400000002,70751.526400000002,70751.526400000002,70751.526400000002]
[null,{"$f":"Assumptions!$K$5","v":"Battery - ORTP"},{"$f":"Assumptions!K15","v":150},{"$f":"$G$29*12*1000*$C16","v":1087799.9999999998},1087799.9999999998,1087799.9999999998,1087799.9999999998,1087799.9999999998,1087799.9999999998,1087799.9999999998,1087799.9999999998,1087799.9999999998,1087799.9999999998,1087799.9999999998,1087799.9999999998,1087799.9999999998,1087799.9999999998,1087799.9999999998,1087799.9999999998,1087799.9999999998,1087799.9999999998,1087799.9999999998,1087799.9999999998]
[null,{"$f":"Assumptions!$L$5","v":"Co-located Resource - ORTP"},{"$f":"Assumptions!L15","v":10},{"$f":"$G$30*12*1000*$C17","v":53947.881600000008},53947.881600000008,53947.881600000008,53947.881600000008,53947.881600000008,53947.881600000008,53947.881600000008,53947.881600000008,53947.881600000008,53947.881600000008,53947.881600000008,53947.881600000008,53947.881600000008,53947.881600000008,53947.881600000008,53947.881600000008,53947.881600000008,53947.881600000008,53947.881600000008,53947.881600000008]
[]
[]
[null,"Scarcity",null,"[H]",null,"[A]"]
[null,"Technology",null,"Scarcity Hours at Criteria","Reserve Constraint Penalty Factor","Average Actual Performance","Energy Market Scarcity Revenue"]
[null,null,null,"hrs","$/MWh","%","$/kW-mo"]
[null,null,null,"[1]","[2]","[3]","[4]"]
[null,"Combined Cycle - ORTP",null,{"$f":"PFP!D37","v":7.4},1000,{"$f":"PFP!F37","v":0.92769999999999997},{"$f":"(D24*E24*F24)/1000/12","v":0.5720816666666666}]
[null,"Simple Cycle - ORTP",null,{"$f":"PFP!D38","v":7.4},1000,{"$f":"PFP!F38","v":0.98},0.60433333333333328]
[null,"Onshore Wind - ORTP",null,{"$f":"PFP!D39","v":7.4},1000,{"$f":"PFP!F39","v":0.2646366601166445},0.16319260707193076]
[null,"Offshore Wind",null,{"$f":"PFP!D40","v":7.4},1000,{"$f":"PFP!F40","v":0.30339288980945694},0.18709228204916514]
[null,"Solar",null,{"$f":"PFP!D41","v":7.4},1000,{"$f":"PFP!F41","v":0.47805085405405406},0.29479802666666671]
[null,"Battery",null,{"$f":"PFP!D42","v":7.4},1000,{"$f":"PFP!F42","v":0.98},0.60433333333333328]
[null,"Co-located Resource",null,{"$f":"PFP!D43","v":7.4},1000,{"$f":"PFP!F43","v":0.72902542702702711},0.44956568000000008]
[]
[]
[null,"NOTES [IN PROCESS]:"]
[null,"[1] - ISO-NE values"]
[null,"[2] - ISO-NE values"]
[null,"[3] - Mott MacDonald values"]
[null,"[4] - [1] x [2] x [3] / 1000 / 12"]

{"sheet":"MACRS","index":13,"n_rows":17,"n_cols":34,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,2,2,3]]}
[null,"MACRS"]
[]
[null,"Technology",{"$f":"'Controls & Results'!D8","v":"Battery - ORTP"}]
[]
[null,"Depreciation Schedule",{"$f":"Assumptions!D26","v":"7yrMACRS"}]
[]
[]
[null,null,"Year",2026,{"$f":"D8+1","v":2027},{"$f":"E8+1","v":2028},2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055]
[null,null,"Depreciation Schedule",{"$f":"OFFSET(D11,MATCH($C$5,$C$12:$C$17,0),0)","v":0.1429},0.24490000000000001,0.1749,0.1249,8.9300000000000004E-2,8.9200000000000002E-2,8.9300000000000004E-2,4.4600000000000001E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,null,"3yrMACRS",0.33329999999999999,0.44450000000000001,0.14810000000000001,7.4099999999999999E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D12:AG12)","v":1}]
[null,"Wind, Solar, Co-located","5yrMACRS",0.2,0.32,0.192,0.1152,0.1152,5.7599999999999998E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.99999999999999989]
[null,"Battery","7yrMACRS",0.1429,0.24490000000000001,0.1749,0.1249,8.9300000000000004E-2,8.9200000000000002E-2,8.9300000000000004E-2,4.4600000000000001E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1.0000000000000002]
[null,null,"10yrMACRS",0.1,0.18,0.14399999999999999,0.1152,9.2200000000000004E-2,7.3700000000000002E-2,6.5500000000000003E-2,6.5500000000000003E-2,6.5600000000000006E-2,6.5500000000000003E-2,3.2800000000000003E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1]
[null,"Simple Cycle, Aero","15yrMACRS",0.05,9.5000000000000001E-2,8.5500000000000007E-2,7.6999999999999999E-2,6.93E-2,6.2300000000000001E-2,5.8999999999999997E-2,5.8999999999999997E-2,5.91E-2,5.8999999999999997E-2,{"$f":"L16","v":5.91E-2},{"$f":"M16","v":5.8999999999999997E-2},{"$f":"N16","v":5.91E-2},{"$f":"O16","v":5.8999999999999997E-2},{"$f":"P16","v":5.91E-2},2.9499999999999998E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D16:AG16)","v":1.0000000000000002}]
[null,"Combined Cycle","20yrMACRS",3.7499999999999999E-2,7.2190000000000004E-2,6.6769999999999996E-2,6.1769999999999999E-2,5.713E-2,5.2850000000000001E-2,4.888E-2,4.5220000000000003E-2,4.462E-2,4.4609999999999997E-2,4.462E-2,4.4609999999999997E-2,4.462E-2,4.4609999999999997E-2,4.462E-2,4.4609999999999997E-2,4.462E-2,4.4609999999999997E-2,4.462E-2,4.4609999999999997E-2,2.231E-2,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D17:AG17)","v":1.0000000000000002}]

{"sheet":"Depreciation","index":14,"n_rows":79,"n_cols":22,"rows_kept":79,"cut":false,"hidden":false,"merged":[]}
[null,"Depreciation"]
[null,null,2026,{"$f":"C2+1","v":2027},{"$f":"D2+1","v":2028},2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,{"$f":"S2+1","v":2043},2044,2045]
[null,"Depreciation Rate",{"$f":"MACRS!D9","v":0.1429},{"$f":"MACRS!E9","v":0.24490000000000001},{"$f":"MACRS!F9","v":0.1749},{"$f":"MACRS!G9","v":0.1249},{"$f":"MACRS!H9","v":8.9300000000000004E-2},{"$f":"MACRS!I9","v":8.9200000000000002E-2},{"$f":"MACRS!J9","v":8.9300000000000004E-2},{"$f":"MACRS!K9","v":4.4600000000000001E-2},{"$f":"MACRS!L9","v":0},{"$f":"MACRS!M9","v":0},{"$f":"MACRS!N9","v":0},{"$f":"MACRS!O9","v":0},{"$f":"MACRS!P9","v":0},{"$f":"MACRS!Q9","v":0},{"$f":"MACRS!R9","v":0},{"$f":"MACRS!S9","v":0},{"$f":"MACRS!T9","v":0},{"$f":"MACRS!U9","v":0},{"$f":"MACRS!V9","v":0},{"$f":"MACRS!W9","v":0}]
[]
[null,"CAPEX SCHEDULE",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Beginning Plant ",{"$f":"'Construction CF'!B45","v":135693025.47077197}]
[null,"ITC Reduced Plant Basis",{"$f":"C7*(1-Assumptions!$D$21/2)","v":135693025.47077197}]
[null,"Bonus Depreciation",{"$f":"Assumptions!$D$27*Depreciation!C8","v":27138605.094154395}]
[null,"Beginning Plant MACRS",{"$f":"C8-C9","v":108554420.37661758}]
[]
[1,"Year 1 Additions",{"$f":"C5","v":0}]
[null,"Tax Depreciation",{"$f":"($C10+C12)*C$3","v":15512426.671818653},{"$f":"($C10+D12)*D$3","v":26584977.550233647},18986168.123870414,13558447.105039535,9693909.7396319509,9683054.2975942884,9693909.7396319509,4841527.1487971442,0,0,0,0,0,0,0,0,0,0,0,{"$f":"($C10+V12)*V$3","v":0}]
[]
[2,{"$f":"\"Year \"&$A15&\" Additions\"","v":"Year 2 Additions"},0,{"$f":"D$5","v":0}]
[null,"Tax Depreciation",0,{"$f":"$D15*C$3","v":0},{"$f":"$D15*D$3","v":0},{"$f":"$D15*E$3","v":0},{"$f":"$D15*F$3","v":0},{"$f":"$D15*G$3","v":0},{"$f":"$D15*H$3","v":0},{"$f":"$D15*I$3","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"$D15*U$3","v":0}]
[]
[{"$f":"A15+1","v":3},{"$f":"\"Year \"&$A18&\" Additions\"","v":"Year 3 Additions"},0,0,{"$f":"E$5","v":0}]
[null,"Tax Depreciation",0,0,{"$f":"$E18*C$3","v":0},{"$f":"$E18*D$3","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[{"$f":"A18+1","v":4},{"$f":"\"Year \"&$A21&\" Additions\"","v":"Year 4 Additions"},0,0,0,{"$f":"F$5","v":0}]
[null,"Tax Depreciation",0,0,0,{"$f":"$F21*C$3","v":0},{"$f":"$F21*D$3","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$F21*S$3","v":0}]
[]
[{"$f":"A21+1","v":5},{"$f":"\"Year \"&$A24&\" Additions\"","v":"Year 5 Additions"},0,0,0,0,{"$f":"G$5","v":0}]
[null,"Tax Depreciation",0,0,0,0,{"$f":"$G24*C$3","v":0},{"$f":"$G24*D$3","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[{"$f":"A24+1","v":6},{"$f":"\"Year \"&$A27&\" Additions\"","v":"Year 6 Additions"},0,0,0,0,0,{"$f":"H$5","v":0}]
[null,"Tax Depreciation",0,0,0,0,0,{"$f":"$H27*C$3","v":0},{"$f":"$H27*D$3","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[{"$f":"A27+1","v":7},{"$f":"\"Year \"&$A30&\" Additions\"","v":"Year 7 Additions"},0,0,0,0,0,0,{"$f":"I$5","v":0}]
[null,"Tax Depreciation",0,0,0,0,0,0,{"$f":"$I30*C$3","v":0},0,{"$f":"$I30*E$3","v":0},0,0,0,{"$f":"$I30*I$3","v":0},0,0,0,0,0,0,0]
[]
[{"$f":"A30+1","v":8},{"$f":"\"Year \"&$A33&\" Additions\"","v":"Year 8 Additions"},0,0,0,0,0,0,0,{"$f":"J$5","v":0}]
[null,"Tax Depreciation",0,0,0,0,0,0,0,{"$f":"$J33*C$3","v":0},{"$f":"$J33*D$3","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[{"$f":"A33+1","v":9},{"$f":"\"Year \"&$A36&\" Additions\"","v":"Year 9 Additions"},0,0,0,0,0,0,0,0,{"$f":"K$5","v":0}]
[null,"Tax Depreciation",0,0,0,0,0,0,0,0,{"$f":"$K36*C$3","v":0},{"$f":"$K36*D$3","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[{"$f":"A36+1","v":10},{"$f":"\"Year \"&$A39&\" Additions\"","v":"Year 10 Additions"},0,0,0,0,0,0,0,0,0,{"$f":"L$5","v":0}]
[null,"Tax Depreciation",0,0,0,0,0,0,0,0,0,{"$f":"$L39*C$3","v":0},{"$f":"$L39*D$3","v":0},0,0,0,0,0,0,0,0,0]
[]
[{"$f":"A39+1","v":11},{"$f":"\"Year \"&$A42&\" Additions\"","v":"Year 11 Additions"},0,0,0,0,0,0,0,0,0,0,{"$f":"M$5","v":0}]
[null,"Tax Depreciation",0,0,0,0,0,0,0,0,0,0,{"$f":"$M42*C$3","v":0},{"$f":"$M42*D$3","v":0},0,0,0,0,0,0,0,0]
[]
[{"$f":"A42+1","v":12},{"$f":"\"Year \"&$A45&\" Additions\"","v":"Year 12 Additions"},0,0,0,0,0,0,0,0,0,0,0,{"$f":"N$5","v":0}]
[null,"Tax Depreciation",0,0,0,0,0,0,0,0,0,0,0,{"$f":"$N45*C$3","v":0},{"$f":"$N45*D$3","v":0},0,0,0,0,0,0,0]
[]
[{"$f":"A45+1","v":13},{"$f":"\"Year \"&$A48&\" Additions\"","v":"Year 13 Additions"},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"O$5","v":0}]
[null,"Tax Depreciation",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$O48*C$3","v":0},{"$f":"$O48*D$3","v":0},0,0,0,0,0,0]
[]
[{"$f":"A48+1","v":14},{"$f":"\"Year \"&$A51&\" Additions\"","v":"Year 14 Additions"},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P$5","v":0}]
[null,"Tax Depreciation",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$P51*C$3","v":0},{"$f":"$P51*D$3","v":0},0,0,0,0,0]
[]
[{"$f":"A51+1","v":15},{"$f":"\"Year \"&$A54&\" Additions\"","v":"Year 15 Additions"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Q$5","v":0}]
[null,"Tax Depreciation",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$Q54*C$3","v":0},{"$f":"$Q54*D$3","v":0},0,0,0,0]
[]
[{"$f":"A54+1","v":16},{"$f":"\"Year \"&$A57&\" Additions\"","v":"Year 16 Additions"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"R$5","v":0}]
[null,"Tax Depreciation",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$R57*C$3","v":0},{"$f":"$R57*D$3","v":0},0,0,0]
[]
[{"$f":"A57+1","v":17},{"$f":"\"Year \"&$A60&\" Additions\"","v":"Year 17 Additions"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"S$5","v":0}]
[null,"Tax Depreciation",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$S60*C$3","v":0},{"$f":"$S60*D$3","v":0},0,0]
[]
[{"$f":"A60+1","v":18},{"$f":"\"Year \"&$A63&\" Additions\"","v":"Year 18 Additions"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"T$5","v":0}]
[null,"Tax Depreciation",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$T63*C$3","v":0},{"$f":"$T63*D$3","v":0},0]
[]
[{"$f":"A63+1","v":19},{"$f":"\"Year \"&$A66&\" Additions\"","v":"Year 19 Additions"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"U$5","v":0}]
[null,"Tax Depreciation",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$U66*C$3","v":0},{"$f":"$U66*D$3","v":0}]
[]
[{"$f":"A66+1","v":20},{"$f":"\"Year \"&$A69&\" Additions\"","v":"Year 20 Additions"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"V$5","v":0}]
[null,"Tax Depreciation",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$V69*C$3","v":0}]
[]
[]
[null,"2026$"]
[null,"Depreciation Expense",{"$f":"SUMIF($B$7:$B$72,\"Tax Depreciation\",C$7:C$72)+C9","v":42651031.765973046},{"$f":"SUMIF($B$7:$B$72,\"Tax Depreciation\",D$7:D$72)","v":26584977.550233647},{"$f":"SUMIF($B$7:$B$72,\"Tax Depreciation\",E$7:E$72)","v":18986168.123870414},13558447.105039535,9693909.7396319509,9683054.2975942884,9693909.7396319509,{"$f":"SUMIF($B$7:$B$72,\"Tax Depreciation\",J$7:J$72)","v":4841527.1487971442},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUMIF($B$7:$B$72,\"Tax Depreciation\",V$7:V$72)+IF(V13>0,MACRS!X17*Depreciation!C10,0)","v":0}]
[null,"Gross Plant",{"$f":"SUMIF($A$12:$A$72,\">0\",C$12:C$72)+C7","v":135693025.47077197},{"$f":"SUMIF($A$12:$A$72,\">0\",D$12:D$72)+C75","v":135693025.47077197},135693025.47077197,135693025.47077197,135693025.47077197,135693025.47077197,135693025.47077197,135693025.47077197,135693025.47077197,135693025.47077197,135693025.47077197,135693025.47077197,135693025.47077197,135693025.47077197,135693025.47077197,135693025.47077197,135693025.47077197,135693025.47077197,135693025.47077197,135693025.47077197]
[null,"Accumulated Depreciation",{"$f":"SUM($C$74:C$74)","v":42651031.765973046},{"$f":"SUM($C$74:D$74)","v":69236009.316206694},{"$f":"SUM($C$74:E$74)","v":88222177.440077111},{"$f":"SUM($C$74:F$74)","v":101780624.54511665},{"$f":"SUM($C$74:G$74)","v":111474534.2847486},{"$f":"SUM($C$74:H$74)","v":121157588.58234289},{"$f":"SUM($C$74:I$74)","v":130851498.32197484},{"$f":"SUM($C$74:J$74)","v":135693025.470772},{"$f":"SUM($C$74:K$74)","v":135693025.470772},{"$f":"SUM($C$74:L$74)","v":135693025.470772},{"$f":"SUM($C$74:M$74)","v":135693025.470772},{"$f":"SUM($C$74:N$74)","v":135693025.470772},{"$f":"SUM($C$74:O$74)","v":135693025.470772},{"$f":"SUM($C$74:P$74)","v":135693025.470772},{"$f":"SUM($C$74:Q$74)","v":135693025.470772},{"$f":"SUM($C$74:R$74)","v":135693025.470772},{"$f":"SUM($C$74:S$74)","v":135693025.470772},{"$f":"SUM($C$74:T$74)","v":135693025.470772},{"$f":"SUM($C$74:U$74)","v":135693025.470772},{"$f":"SUM($C$74:V$74)","v":135693025.470772}]
[null,"Net Plant",{"$f":"C75-C76","v":93041993.704798922},{"$f":"D75-D76","v":66457016.154565275},47470848.030694857,{"$f":"F75-F76","v":33912400.92565532},24218491.186023369,14535436.888429075,4841527.1487971246,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Plant Basis for Property Tax Calculation (Gross Plant Less Depreciation)",{"$f":"C75-(C75*MACRS!D9)","v":116302492.13099866},{"$f":"C79-D75*MACRS!E9","v":83071270.193206608},{"$f":"D79-E75*MACRS!F9","v":59338560.03836859},{"$f":"E79-F75*MACRS!G9","v":42390501.157069176},{"$f":"F79-G75*MACRS!H9","v":30273113.982529238},{"$f":"G79-H75*MACRS!I9","v":18169296.110536378},{"$f":"H79-I75*MACRS!J9","v":6051908.9359964412},{"$f":"I79-J75*MACRS!K9","v":1.1175870895385742E-8},{"$f":"J79-K75*MACRS!L9","v":1.1175870895385742E-8},{"$f":"K79-L75*MACRS!M9","v":1.1175870895385742E-8},{"$f":"L79-M75*MACRS!N9","v":1.1175870895385742E-8},{"$f":"M79-N75*MACRS!O9","v":1.1175870895385742E-8},{"$f":"N79-O75*MACRS!P9","v":1.1175870895385742E-8},{"$f":"O79-P75*MACRS!Q9","v":1.1175870895385742E-8},{"$f":"P79-Q75*MACRS!R9","v":1.1175870895385742E-8},{"$f":"Q79-R75*MACRS!S9","v":1.1175870895385742E-8},{"$f":"R79-S75*MACRS!T9","v":1.1175870895385742E-8},{"$f":"S79-T75*MACRS!U9","v":1.1175870895385742E-8},{"$f":"T79-U75*MACRS!V9","v":1.1175870895385742E-8},{"$f":"U79-V75*MACRS!W9","v":1.1175870895385742E-8}]