{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Common","Asset Specific Inputs","Analysis_w AFUDC"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":17,"comments":1,"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":"Common","index":0,"n_rows":42,"n_cols":71,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Real Discount Rate"]
[null,null,null,"After-Tax WACC",{"$f":"G24","v":7.2938159617909684E-2}]
[null,null,null,"AFUDC Debt",{"$f":"F22","v":2.9430825000000001E-2}]
[null,null,null,"AFUDC Equity",{"$f":"F23","v":5.0841375000000001E-2}]
[null,null,null,"Rate for Cap Interest",{"$f":"D22","v":6.1499999999999999E-2}]
[null,null,null,"State/Federal Income Tax Rate",0.2491958816]
[null,null,null,"Property Tax",""]
[null,null,null,"Insurance"]
[null,null,null,"Infl Rate",2.5000000000000001E-2]
[null,null,null,"State Income Tax Rate",4.9615039999999999E-2]
[null,null,null,"Federal Income Tax Rate",0.21]
[null,null,null,"Base Year for Contruction Cost Estimates",2024]
[]
[]
[]
[]
[null,"WACC Components:"]
[null,null,null,"Rate","Portion %","Nominal WACC","After-Tax WACC"]
[]
[]
[null,"Debt",null,6.1499999999999999E-2,{"$f":"E24-E23","v":0.47855000000000003},{"$f":"D22*E22","v":2.9430825000000001E-2},{"$f":"F22*(1-Tax_Rate)","v":2.2096784617909683E-2}]
[null,"Common Equity",null,9.7500000000000003E-2,0.52144999999999997,{"$f":"D23*E23","v":5.0841375000000001E-2},{"$f":"F23","v":5.0841375000000001E-2}]
[null,null,null,null,1,{"$f":"SUM(F22:F23)","v":8.0272200000000002E-2},{"$f":"SUM(G22:G23)","v":7.2938159617909684E-2}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Tax Depreciation Rates -- Full year convention"]
[]
[]
[null,"Tax Life",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,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69]
[null,5,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,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,0,0,0,0,0,0,0]
[null,7,0.26534999999999997,0.20989999999999998,0.14989999999999998,0.10710000000000001,8.925000000000001E-2,8.925000000000001E-2,6.695000000000001E-2,2.23E-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,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,0,0,0,0]
[null,15,9.7500000000000003E-2,9.0499999999999997E-2,8.1500000000000003E-2,7.3000000000000009E-2,6.5500000000000003E-2,6.0499999999999998E-2,5.9000000000000004E-2,5.9000000000000004E-2,5.9000000000000004E-2,5.9000000000000004E-2,5.9000000000000004E-2,5.9000000000000004E-2,5.9000000000000004E-2,5.9000000000000004E-2,5.9499999999999997E-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,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]
[null,20,7.400000000000001E-2,6.9500000000000006E-2,6.4500000000000002E-2,5.9499999999999997E-2,5.5000000000000007E-2,5.1000000000000004E-2,4.7E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,3.95E-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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["60% 7yr SL; 40% 20yr MACRS","7_20",0.1153142857142857,0.11351428571428571,0.1115142857142857,0.1095142857142857,0.10771428571428571,0.1061142857142857,0.1045142857142857,1.7999999999999999E-2,1.7999999999999999E-2,1.7999999999999999E-2,1.7999999999999999E-2,1.7999999999999999E-2,1.7999999999999999E-2,1.7999999999999999E-2,1.7999999999999999E-2,1.7999999999999999E-2,1.7999999999999999E-2,1.7999999999999999E-2,1.7999999999999999E-2,1.5800000000000002E-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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["60% 5yr SL; 40% 20yr MACRS","5_20",0.14960000000000001,0.14779999999999999,0.14579999999999999,0.14379999999999998,0.14200000000000002,2.0400000000000001E-2,1.8800000000000001E-2,1.7999999999999999E-2,1.7999999999999999E-2,1.7999999999999999E-2,1.7999999999999999E-2,1.7999999999999999E-2,1.7999999999999999E-2,1.7999999999999999E-2,1.7999999999999999E-2,1.7999999999999999E-2,1.7999999999999999E-2,1.7999999999999999E-2,1.7999999999999999E-2,1.5800000000000002E-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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Asset Specific Inputs","index":1,"n_rows":159,"n_cols":112,"rows_kept":159,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Total Case Count =",2]
[]
[]
[null,null,null," --- PROJECT SPECIFIC INPUTS ---"]
[null,null,null,null,null,null,null,null,"Active Case"]
[null,null,null,null,null,null,null,null,2,1,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,null,null,null,null,null,null,null,null,null,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":"BS12+1","v":1},{"$f":"BT12+1","v":2},{"$f":"BU12+1","v":3},{"$f":"BV12+1","v":4},{"$f":"BW12+1","v":5},{"$f":"BX12+1","v":6},{"$f":"BY12+1","v":7},{"$f":"BZ12+1","v":8},{"$f":"CA12+1","v":9},{"$f":"CB12+1","v":10},{"$f":"CC12+1","v":11},{"$f":"CD12+1","v":12},{"$f":"CE12+1","v":13},{"$f":"CF12+1","v":14},{"$f":"CG12+1","v":15},{"$f":"CH12+1","v":16},{"$f":"CI12+1","v":17},{"$f":"CJ12+1","v":18},{"$f":"CK12+1","v":19},{"$f":"CL12+1","v":20},{"$f":"CM12+1","v":21},{"$f":"CN12+1","v":22},{"$f":"CO12+1","v":23},{"$f":"CP12+1","v":24},{"$f":"CQ12+1","v":25},{"$f":"CR12+1","v":26},{"$f":"CS12+1","v":27},{"$f":"CT12+1","v":28},{"$f":"CU12+1","v":29},{"$f":"CV12+1","v":30},{"$f":"CW12+1","v":31},{"$f":"CX12+1","v":32},{"$f":"CY12+1","v":33},{"$f":"CZ12+1","v":34},{"$f":"DA12+1","v":35},{"$f":"DB12+1","v":36},{"$f":"DC12+1","v":37},{"$f":"DD12+1","v":38},{"$f":"DE12+1","v":39},{"$f":"DF12+1","v":40},{"$f":"DG12+1","v":41}]
[null,null,null,null,null,null,null,"Project Name",{"$f":"OFFSET($J13,0,I$12-1,1,1)","v":"Distribution"},"Transmission","Distribution"]
["Source/Notes",null,null,null,null,null,null,"Project Description (key features)","Dist","Trans","Dist"]
[null,null,null,null,null,null,null,"MW Capability of Plant (used Summer rating)",1,1,1]
[null,null,null,null,null,null,null,"Real Inflation Rate % for ST",0,0,0]
[null,null,null,null,null,null,null,"Transition Year for ST to LT (# yrs into the future from base year)",10,10,10]
[null,null,null,null,null,null,null,"Real Infl Rate % for LT (beyond ST period)",0,0,0]
[null,null,null,null,null,null,null,"% of Expenditures for Capitalized Interest",1,1,1]
[null,null,null,null,null,null,null,"Tax Life (Yrs)",{"$f":"OFFSET($J20,0,I$12-1,1,1)","v":20},15,20]
[null,null,null,null,null,null,null,"Plant Life (Yrs)",51,50,51]
[null,null,null,null,null,null,null,"Net Salvage Value (or Site Restoration)",-0.2,-0.13,-0.2]
[null,null,null,null,null,null,null,"Nuclear Decommissioning Cost",0,0,0]
[null,null,null,null,null,null,null,"Federal ITC %",0,0,0]
[null,null,null,null,null,null,null,"Years Lag for Federal ITC realization",0,0,0]
[null,null,null,null,null,null,null,"1-time state deduct for Fed ITC tax basis reduction? (\"yes\" or blank)",{"$f":"OFFSET($J26,0,I$12-1,1,1)","v":0}]
[null,null,null,null,null,null,null,"State ITC %",0,0,0]
[null,null,null,null,null,null,null,"State ITC spread over how many years?",0,0,0]
[null,null,null,null,null,null,null,"Years Lag for start of State ITC (not to exceed spread years minus one)",0,0,0]
[null,null,null,null,null,null,null,"Portion of Federal ITC offsetting basis for Tax Deprec",0,0,0]
[null,null,null,null,null,null,null,"Bonus Depreciation %",0,0,0]
[null,null,null,null,null,null,null,"Portion of CWIP in Ratebase",0,0,0]
[null,null,null,null,null,null,null,"Property Tax Basis Method (DEC/DEP=1, DEI=2, DEK=3, DEC/DEP detailed)",3,3,3]
["2014 Tax Information Report.xlsx",null,null,null,null,null,null,"Property Tax Rate %",1.0216720520049251E-2,1.0216720520049251E-2,1.0216720520049251E-2]
["Standard Assumptions 2015_04_07v5.xlsx",null,null,null,null,null,null,"Insurance Rate % (applied to Replacement Cost)",4.28E-4,4.28E-4,4.28E-4]
[]
[null,null,null,null,null,null,null,null,"Overnight Cost Expenditures (for Base Year) $000"]
[null,null,null,null,null,null,null,0,{"$f":"OFFSET($J38,0,I$12-1,1,1)","v":0}]
[null,null,null,null,null,null,"Construction Year",1,100,40,100]
[null,null,null,null,null,null,null,2,0,60,0]
[null,null,null,null,null,null,null,3,0,0,0]
[null,null,null,null,null,null,null,4,0,0,0]
[null,null,null,null,null,null,null,5,0,0,0]
[null,null,null,null,null,null,null,6,0,0,0]
[null,null,null,null,null,null,null,7,0,0,0]
[null,null,null,null,null,null,null,8,0,0,0]
[null,null,null,null,null,null,null,9,0,0,0]
[null,null,null,null,null,null,null,10,0,0,0]
[null,null,null,null,null,null,null,11,0,0,0]
[null,null,null,null,null,null,null,12,0,0,0]
[null,null,null,null,null,null,null,13,0,0,0]
[null,null,null,null,null,null,null,14,0,0,0]
[null,null,null,null,null,null,null,15,0]
[]
[null,null,null,null,null,null,null,"CWIP (or remaining CWIP) % to Plant in Service (only for NO AFUDC cases)"]
[null,null,null,null,null,null,null,1,{"$f":"OFFSET($J56,0,I$12-1,1,1)","v":1},{"$f":"IF(AND(J39>0,J40=0),1,0)","v":0},{"$f":"IF(AND(K39>0,K40=0),1,0)","v":1}]
[null,null,null,null,null,null,null,2,0,{"$f":"IF(AND(J40>0,J41=0),1,0)","v":1},0]
[null,null,null,null,null,null,null,3,0,{"$f":"IF(AND(J41>0,J42=0),1,0)","v":0},0]
[null,null,null,null,null,null,null,4,0,{"$f":"IF(AND(J42>0,J43=0),1,0)","v":0},0]
[null,null,null,null,null,null,null,5,0,{"$f":"IF(AND(J43>0,J44=0),1,0)","v":0},0]
[null,null,null,null,null,null,null,6,0,{"$f":"IF(AND(J44>0,J45=0),1,0)","v":0},0]
[null,null,null,null,null,null,null,7,0,{"$f":"IF(AND(J45>0,J46=0),1,0)","v":0},0]
[null,null,null,null,null,null,null,8,0,{"$f":"IF(AND(J46>0,J47=0),1,0)","v":0},0]
[null,null,null,null,null,null,null,9,0,{"$f":"IF(AND(J47>0,J48=0),1,0)","v":0},0]
[null,null,null,null,null,null,null,10,0,{"$f":"IF(AND(J48>0,J49=0),1,0)","v":0},0]
[null,null,null,null,null,null,null,11,0,{"$f":"IF(AND(J49>0,J50=0),1,0)","v":0},0]
[null,null,null,null,null,null,null,12,0,{"$f":"IF(AND(J50>0,J51=0),1,0)","v":0},0]
[null,null,null,null,null,null,null,13,0,{"$f":"IF(AND(J51>0,J52=0),1,0)","v":0},0]
[null,null,null,null,null,null,null,14,0,{"$f":"IF(AND(J52>0,J53=0),1,0)","v":0},0]
[null,null,null,null,null,null,null,15,0,{"$f":"IF(AND(J53>0,J54=0),1,0)","v":0},0]
[]
[]
[]
[]
[null,null,null," --- OUTPUTS/Summary Metrics ---"]
[null,null,null,null,null,null,null,null,{"$f":"Active_Case","v":2},{"$f":"J12","v":1},{"$f":"J76+1","v":2}]
[null,1,null,null,null,null,null,"Project Name",{"$f":"I13","v":"Distribution"},"Transmission","Distribution"]
[null,2,null,null,null,null,null,"Project Description (key features)",{"$f":"I14","v":"Dist"},"Trans","Dist"]
[null,3,null,null,null,null,null,"REGION (DEC/DEP=1, DEI=2, DEK=3)",{"$f":"I33","v":3},3,3]
[null,4,null,null,null,null,null,"Base Year",{"$f":"base_year","v":2024},2024,2024]
[null,null,null,null,null,null,null,"Project MW Rating (1.0 if modeled as total $000)",{"$f":"I15","v":1},1,1]
[null,null,null,null,null,null,null,"Overnight Cost $/kW (or $000 if modeled as 1.0 MW)",{"$f":"SUM(I38:I53)/I15","v":100},100,100]
[null,null,null,"Inflated Installed Cost for mid-Base Year c/o:"]
[null,7,null,null,null,null,null,"Inflated Direct $/kW (or $000 if modeled as 1.0 MW)",{"$f":"IF(SUM($I$39:$I$53)>0,'Analysis_w AFUDC'!O49,I38)","v":98.780487804878064},97.816775728732907,98.780487804878064]
[null,8,null,null,null,null,null,"AFUDC $/kW (or $000 if modeled as 1.0 MW)",{"$f":"IF(SUM($I$39:$I$53)>0,'Analysis_w AFUDC'!O50,0)","v":3.9157170731707334},7.0945492177102221,3.9157170731707334]
[null,8,null,null,null,null,null,"Inflated Installed Cost $/kW (or $000 if modeled as 1.0 MW)",{"$f":"IF(SUM($I$39:$I$53)>0,'Analysis_w AFUDC'!O51,I38)","v":102.6962048780488},104.91132494644313,102.6962048780488]
[null,10,null,null,null,null,null,"AFUDC % of Total",{"$f":"I85/I86","v":3.812913123538135E-2},6.7624245726874241E-2,3.812913123538135E-2]
[null,11,null,null,null,null,null,"Net Salvage Value %",{"$f":"I22","v":-0.2},-0.13,-0.2]
[null,12,null,null,null,null,null,"Nuclear Decommissioning %",{"$f":"I23","v":0},0,0]
[null,13,null,null,null,null,null,"Project Life (yrs)",{"$f":"I21","v":51},50,51]
[null,14,null,null,null,null,null,"Tax Life (yrs)",{"$f":"I20","v":20},15,20]
[null,15,null,null,null,null,null,"Bonus Depreciation %",{"$f":"I31","v":0},0,0]
[null,16,null,null,null,null,null,"Fed ITC %",{"$f":"I24","v":0},0,0]
[null,17,null,null,null,null,null,"State ITC (or credit) %",{"$f":"I27","v":0},0,0]
[null,18,null,null,null,null,null,"Lag Years for Fed ITC",{"$f":"I29","v":0},0,0]
[null,19,null,null,null,null,null,"Lag Years for State ITC",{"$f":"I25","v":0},0,0]
[null,20]
[null,21,null,null,null,null,null,"Real LFCR % (EOY convention)",{"$f":"'Analysis_w AFUDC'!O54","v":6.5927625521397623E-2},6.5165531125493142E-2,6.5927625521397623E-2]
[null,22]
[null,23]
[null,null,null,null,null,null,null,"Real LT Discount Rate",{"$f":"'Analysis_w AFUDC'!O57","v":4.6768936212594925E-2},4.6768936212594925E-2,4.6768936212594925E-2]
[null,null,null,null,null,null,null,"LT Technology-specific Infl Rate",{"$f":"'Analysis_w AFUDC'!M62","v":2.4999999999999911E-2},2.4999999999999911E-2,2.4999999999999911E-2]
[null,24]
[null,25]
[null,null,null,null,null,null,null,"ST + LT Components of Inflated Installed Cost (incl AFUDC)","$/kW","$/kW","$/kW"]
[null,27,null,null,null,null,0,{"$f":"base_year","v":2024},{"$f":"'Analysis_w AFUDC'!M68","v":102.6962048780488},104.91132494644313,102.6962048780488]
[null,28,null,null,null,null,1,{"$f":"H106+1","v":2025},{"$f":"'Analysis_w AFUDC'!M69","v":105.26361000000001},107.5341080701042,105.26361000000001]
[null,29,null,null,null,null,2,{"$f":"H107+1","v":2026},{"$f":"'Analysis_w AFUDC'!M70","v":107.89520025000002},110.2224607718568,107.89520025000002]
[null,30,null,null,null,null,3,2027,{"$f":"'Analysis_w AFUDC'!M71","v":110.59258025625002},112.97802229115322,110.59258025625002]
[null,31,null,null,null,null,4,2028,{"$f":"'Analysis_w AFUDC'!M72","v":113.35739476265626},115.80247284843205,113.35739476265626]
[null,32,null,null,null,null,5,2029,{"$f":"'Analysis_w AFUDC'!M73","v":116.19132963172265},118.69753466964283,116.19132963172265]
[null,33,null,null,null,null,6,2030,{"$f":"'Analysis_w AFUDC'!M74","v":119.0961128725157},121.6649730363839,119.0961128725157]
[null,34,null,null,null,null,7,2031,{"$f":"'Analysis_w AFUDC'!M75","v":122.07351569432861},124.70659736229349,122.07351569432861]
[null,35,null,null,null,null,8,2032,{"$f":"'Analysis_w AFUDC'!M76","v":125.12535358668681},127.82426229635082,125.12535358668681]
[null,36,null,null,null,null,9,2033,{"$f":"'Analysis_w AFUDC'!M77","v":128.25348742635396},131.01986885375956,128.25348742635396]
[null,37,null,null,null,null,10,2034,{"$f":"'Analysis_w AFUDC'!M78","v":131.4598246120128},134.29536557510357,131.4598246120128]
[null,38,null,null,null,null,11,2035,{"$f":"'Analysis_w AFUDC'!M79","v":134.74632022731311},137.65274971448116,134.74632022731311]
[null,39,null,null,null,null,12,2036,{"$f":"'Analysis_w AFUDC'!M80","v":138.11497823299592},141.09406845734318,138.11497823299592]
[null,40,null,null,null,null,13,2037,{"$f":"'Analysis_w AFUDC'!M81","v":141.56785268882081},144.62142016877675,141.56785268882081]
[null,41,null,null,null,null,14,2038,{"$f":"'Analysis_w AFUDC'!M82","v":145.10704900604131},148.23695567299615,145.10704900604131]
[null,42,null,null,null,null,15,2039,{"$f":"'Analysis_w AFUDC'!M83","v":148.73472523119233},151.94287956482103,148.73472523119233]
[null,43]
[null,44]
[null,45,null,null,null,null,null,"LT Component of Inflated Installed Cost (incl AFUDC)","$/kW","$/kW","$/kW"]
[null,46,null,null,null,null,0,{"$f":"base_year","v":2024},{"$f":"'Analysis_w AFUDC'!N68","v":102.69620487804879},104.91132494644314,102.69620487804879]
[null,47,null,null,null,null,1,{"$f":"H125+1","v":2025},{"$f":"'Analysis_w AFUDC'!N69","v":105.26361000000003},107.53410807010422,105.26361000000003]
[null,48,null,null,null,null,2,{"$f":"H126+1","v":2026},{"$f":"'Analysis_w AFUDC'!N70","v":107.89520025},110.2224607718568,107.89520025]
[null,49,null,null,null,null,3,2027,{"$f":"'Analysis_w AFUDC'!N71","v":110.59258025624999},112.97802229115322,110.59258025624999]
[null,50,null,null,null,null,4,2028,{"$f":"'Analysis_w AFUDC'!N72","v":113.35739476265624},115.80247284843205,113.35739476265624]
[null,51,null,null,null,null,5,2029,{"$f":"'Analysis_w AFUDC'!N73","v":116.19132963172264},118.69753466964283,116.19132963172264]
[null,52,null,null,null,null,6,2030,{"$f":"'Analysis_w AFUDC'!N74","v":119.0961128725157},121.66497303638391,119.0961128725157]
[null,53,null,null,null,null,7,2031,{"$f":"'Analysis_w AFUDC'!N75","v":122.07351569432858},124.70659736229349,122.07351569432858]
[null,54,null,null,null,null,8,2032,{"$f":"'Analysis_w AFUDC'!N76","v":125.12535358668678},127.82426229635082,125.12535358668678]
[null,55,null,null,null,null,9,2033,{"$f":"'Analysis_w AFUDC'!N77","v":128.25348742635396},131.01986885375959,128.25348742635396]
[null,56,null,null,null,null,10,2034,{"$f":"'Analysis_w AFUDC'!N78","v":131.4598246120128},134.29536557510357,131.4598246120128]
[null,57,null,null,null,null,11,2035,{"$f":"'Analysis_w AFUDC'!N79","v":134.74632022731311},137.65274971448116,134.74632022731311]
[null,58,null,null,null,null,12,2036,{"$f":"'Analysis_w AFUDC'!N80","v":138.11497823299592},141.09406845734318,138.11497823299592]
[null,59,null,null,null,null,13,2037,{"$f":"'Analysis_w AFUDC'!N81","v":141.56785268882084},144.62142016877675,141.56785268882084]
[null,60,null,null,null,null,14,2038,{"$f":"'Analysis_w AFUDC'!N82","v":145.10704900604134},148.23695567299615,145.10704900604134]
[null,61,null,null,null,null,15,2039,{"$f":"'Analysis_w AFUDC'!N83","v":148.73472523119236},151.94287956482106,148.73472523119236]
[null,62]
[null,63]
[null,64,null,null,null,null,null,"ST Premium Inflated Installed Cost (incl AFUDC)","$/kW","$/kW","$/kW"]
[null,65,null,null,null,null,0,{"$f":"base_year","v":2024},{"$f":"'Analysis_w AFUDC'!O68","v":0},0,0]
[null,66,null,null,null,null,1,{"$f":"H144+1","v":2025},{"$f":"'Analysis_w AFUDC'!O69","v":0},0,0]
[null,67,null,null,null,null,2,{"$f":"H145+1","v":2026},{"$f":"'Analysis_w AFUDC'!O70","v":0},0,0]
[null,68,null,null,null,null,3,2027,{"$f":"'Analysis_w AFUDC'!O71","v":0},0,0]
[null,69,null,null,null,null,4,2028,{"$f":"'Analysis_w AFUDC'!O72","v":0},0,0]
[null,70,null,null,null,null,5,2029,{"$f":"'Analysis_w AFUDC'!O73","v":0},0,0]
[null,71,null,null,null,null,6,2030,{"$f":"'Analysis_w AFUDC'!O74","v":0},0,0]
[null,72,null,null,null,null,7,2031,{"$f":"'Analysis_w AFUDC'!O75","v":0},0,0]
[null,73,null,null,null,null,8,2032,{"$f":"'Analysis_w AFUDC'!O76","v":0},0,0]
[null,74,null,null,null,null,9,2033,{"$f":"'Analysis_w AFUDC'!O77","v":0},0,0]
[null,75,null,null,null,null,10,2034,{"$f":"'Analysis_w AFUDC'!O78","v":0},0,0]
[null,76,null,null,null,null,11,2035,{"$f":"'Analysis_w AFUDC'!O79","v":0},0,0]
[null,77,null,null,null,null,12,2036,{"$f":"'Analysis_w AFUDC'!O80","v":0},0,0]
[null,78,null,null,null,null,13,2037,{"$f":"'Analysis_w AFUDC'!O81","v":0},0,0]
[null,79,null,null,null,null,14,2038,{"$f":"'Analysis_w AFUDC'!O82","v":0},0,0]
[null,80,null,null,null,null,15,2039,{"$f":"'Analysis_w AFUDC'!O83","v":0},0,0]

{"sheet":"Analysis_w AFUDC","index":2,"n_rows":228,"n_cols":76,"rows_kept":228,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"PLANT SPECIFIC INPUTS"]
[]
[]
[null,null,null,null,null,"Project Description (used on summary sheet)",{"$f":"'Asset Specific Inputs'!I14","v":"Dist"}]
[{"$f":"ROW()","v":15},null,null,null,null,"MW Capability of Plant",{"$f":"'Asset Specific Inputs'!I15","v":1}]
[{"$f":"ROW()","v":16},null,null,null,null,"Real Inflation Rate % for ST",{"$f":"'Asset Specific Inputs'!I16","v":0}]
[{"$f":"ROW()","v":17},null,null,null,null,"Transition Year for ST to LT (# yrs into the future from base year)",{"$f":"'Asset Specific Inputs'!I17","v":10}]
[{"$f":"ROW()","v":18},null,null,null,null,"Real Infl Rate % for LT (beyond ST period)",{"$f":"'Asset Specific Inputs'!I18","v":0}]
[{"$f":"ROW()","v":19},null,null,null,null,"% of Expenditures for Capitalized Interest",{"$f":"'Asset Specific Inputs'!I19","v":1}]
[{"$f":"ROW()","v":20},null,null,null,null,"Tax Life (Yrs)",{"$f":"'Asset Specific Inputs'!I20","v":20}]
[{"$f":"ROW()","v":21},null,null,null,null,"Plant Life (Yrs)",{"$f":"'Asset Specific Inputs'!I21","v":51}]
[{"$f":"ROW()","v":22},null,null,null,null,"Salvage Value (or Site Restoration)",{"$f":"'Asset Specific Inputs'!I22","v":-0.2}]
[{"$f":"ROW()","v":23},null,null,null,null,"Nuclear Decommissioning Cost",{"$f":"'Asset Specific Inputs'!I23","v":0}]
[{"$f":"ROW()","v":24},null,null,null,null,"Federal ITC %",{"$f":"'Asset Specific Inputs'!I24","v":0}]
[{"$f":"ROW()","v":25},null,null,null,null,"Years Lag for Federal ITC realization",{"$f":"'Asset Specific Inputs'!I25","v":0}]
[{"$f":"ROW()","v":26},null,null,null,null,"1-time state deduct for Fed ITC tax basis reduction?",{"$f":"'Asset Specific Inputs'!I26","v":0}]
[{"$f":"ROW()","v":27},null,null,null,null,"State ITC %",{"$f":"'Asset Specific Inputs'!I27","v":0}]
[{"$f":"ROW()","v":28},null,null,null,null,"State ITC spread over how many years?",{"$f":"'Asset Specific Inputs'!I28","v":0}]
[null,null,null,null,null,"Years Lag for start of State ITC (not to exceed spread years minus one)",{"$f":"'Asset Specific Inputs'!I29","v":0}]
[{"$f":"ROW()","v":30},null,null,null,null,"Portion of Federal ITC offsetting basis for Tax Deprec",{"$f":"'Asset Specific Inputs'!I30","v":0}]
[{"$f":"ROW()","v":31},null,null,null,null,"Bonus Depreciation %",{"$f":"'Asset Specific Inputs'!I31","v":0}]
[{"$f":"ROW()","v":32},null,null,null,null,"Portion of CWIP in Ratebase",{"$f":"'Asset Specific Inputs'!I32","v":0}]
[{"$f":"ROW()","v":33},null,null,null,null,"Property Tax Basis Method ",{"$f":"'Asset Specific Inputs'!I33","v":3},"(DEC/DEP=1, DEI=2, DEK=3, DEC/DEP detailed)"]
[{"$f":"ROW()","v":34},null,null,null,null,"Property Tax Rate %",{"$f":"'Asset Specific Inputs'!I34","v":1.0216720520049251E-2}]
[{"$f":"ROW()","v":35},null,null,null,null,"Insurance Rate % (applied to Orig Cost)",{"$f":"'Asset Specific Inputs'!I35","v":4.28E-4}]
[{"$f":"ROW()","v":36}]
[{"$f":"ROW()","v":37},null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[{"$f":"ROW()","v":38},null,null,null,null,null,null,null,"Reminder:  Base Year =",{"$f":"base_year","v":2024},{"$f":"base_year","v":2024},{"$f":"K38+1","v":2025},{"$f":"L38+1","v":2026},2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038]
[{"$f":"ROW()","v":39},null,null,null,null,"Construction expenditures by year in Base Year $",null,null,null,null,{"$f":"OFFSET('Asset Specific Inputs'!$I$38,K37,0,1,1)","v":100},{"$f":"OFFSET('Asset Specific Inputs'!$I$38,L37,0,1,1)","v":0},{"$f":"OFFSET('Asset Specific Inputs'!$I$38,M37,0,1,1)","v":0},{"$f":"OFFSET('Asset Specific Inputs'!$I$38,N37,0,1,1)","v":0},{"$f":"OFFSET('Asset Specific Inputs'!$I$38,O37,0,1,1)","v":0},{"$f":"OFFSET('Asset Specific Inputs'!$I$38,P37,0,1,1)","v":0},{"$f":"OFFSET('Asset Specific Inputs'!$I$38,Q37,0,1,1)","v":0},{"$f":"OFFSET('Asset Specific Inputs'!$I$38,R37,0,1,1)","v":0},{"$f":"OFFSET('Asset Specific Inputs'!$I$38,S37,0,1,1)","v":0},{"$f":"OFFSET('Asset Specific Inputs'!$I$38,T37,0,1,1)","v":0},{"$f":"OFFSET('Asset Specific Inputs'!$I$38,U37,0,1,1)","v":0},{"$f":"OFFSET('Asset Specific Inputs'!$I$38,V37,0,1,1)","v":0},{"$f":"OFFSET('Asset Specific Inputs'!$I$38,W37,0,1,1)","v":0},{"$f":"OFFSET('Asset Specific Inputs'!$I$38,X37,0,1,1)","v":0},{"$f":"OFFSET('Asset Specific Inputs'!$I$38,Y37,0,1,1)","v":0}]
[{"$f":"ROW()","v":40},null,null,null,null,"Closing to Plant in Service %*",null,null,null,{"$f":"IF(J110=base_year+COUNTIF($K$39:$AF$39,\">0\")-1,1,0)","v":0},{"$f":"OFFSET('Asset Specific Inputs'!$I$55,K37,0,1,1)","v":1},{"$f":"OFFSET('Asset Specific Inputs'!$I$55,L37,0,1,1)","v":0},{"$f":"OFFSET('Asset Specific Inputs'!$I$55,M37,0,1,1)","v":0},{"$f":"OFFSET('Asset Specific Inputs'!$I$55,N37,0,1,1)","v":0},{"$f":"OFFSET('Asset Specific Inputs'!$I$55,O37,0,1,1)","v":0},{"$f":"OFFSET('Asset Specific Inputs'!$I$55,P37,0,1,1)","v":0},{"$f":"OFFSET('Asset Specific Inputs'!$I$55,Q37,0,1,1)","v":0},{"$f":"OFFSET('Asset Specific Inputs'!$I$55,R37,0,1,1)","v":0},{"$f":"OFFSET('Asset Specific Inputs'!$I$55,S37,0,1,1)","v":0},{"$f":"OFFSET('Asset Specific Inputs'!$I$55,T37,0,1,1)","v":0},{"$f":"OFFSET('Asset Specific Inputs'!$I$55,U37,0,1,1)","v":0},{"$f":"OFFSET('Asset Specific Inputs'!$I$55,V37,0,1,1)","v":0},{"$f":"OFFSET('Asset Specific Inputs'!$I$55,W37,0,1,1)","v":0},{"$f":"OFFSET('Asset Specific Inputs'!$I$55,X37,0,1,1)","v":0},{"$f":"OFFSET('Asset Specific Inputs'!$I$55,Y37,0,1,1)","v":0}]
[{"$f":"ROW()","v":41},null,null,null,null,null,"find 1st year of construction --->",{"$f":"MATCH(TRUE,INDEX(ISNUMBER(K41:Y41),0),0)","v":1},null,null,{"$f":"IF(K39>0,K39,\" \")","v":100},{"$f":"IF(L39>0,L39,\" \")","v":" "}," "," "," "," "," "," "," "," "," "," "," "," "," "]
[{"$f":"ROW()","v":42}]
[{"$f":"ROW()","v":43}]
[{"$f":"ROW()","v":44}]
[{"$f":"ROW()","v":45},null,null,null,null,null,null,null,null,"NPV Test Okay?"]
[{"$f":"ROW()","v":46},null,"RESULTS SUMMARY",null,null,null,null,null,null,{"$f":"IF(ROUND(G182,0)<>0,\"NO!!!\", \"Yes \")","v":"Yes "}]
[{"$f":"ROW()","v":47},null,null,null,"Reminder:  Base Year =",{"$f":"base_year","v":2024}]
[{"$f":"ROW()","v":48},null,"Costs in $000 assuming Base Year Completion:",null,null,null,null,null,null,"Cost $/kW assuming Base Year Completion:"]
[{"$f":"ROW()","v":49},null,"Direct Cost",null,null,null,null,{"$f":"G112/(1+$M$60)^(COUNTIF(K$39:AF$39,\">0\")+$H$41-1-0.5)","v":98.780487804878064},null,"Direct Cost",null,null,null,null,{"$f":"H49/$H$53","v":98.780487804878064}]
[{"$f":"ROW()","v":50},null,"AFUDC ",null,null,null,null,{"$f":"SUM(G118:G119)/(1+$M$60)^(COUNTIF(K$39:AF$39,\">0\")+$H$41-1-0.5)","v":3.9157170731707334},null,"AFUDC",null,null,null,null,{"$f":"H50/$H$53","v":3.9157170731707334}]
[{"$f":"ROW()","v":51},null,"Total Cost",null,null,null,null,{"$f":"SUM(H49:H50)","v":102.6962048780488},null,"Total Cost",null,null,null,null,{"$f":"SUM(O49:O50)","v":102.6962048780488}]
[{"$f":"ROW()","v":52}]
[{"$f":"ROW()","v":53},null,"MW Capability",null,null,null,null,{"$f":"G15","v":1},null,"Nominal Levelized FCR % (EOY convention)",null,null,null,null,{"$f":"G176/G125","v":9.5457802978495057E-2}]
[{"$f":"ROW()","v":54},null,null,null,null,null,null,null,null,"Real Levelized FCR % (EOY convention)",null,null,null,null,{"$f":"PMT(O57,G21,PV(disc_rate,G21,O53))","v":6.5927625521397623E-2}]
[{"$f":"ROW()","v":55},null,null,null,null,null,null,null,null,"Real Levelized FCR % (BOY convention)",null,null,null,null,{"$f":"O54/(1+$O$57)","v":6.2982023291535627E-2}]
[{"$f":"ROW()","v":56},null,null,null,null,null,null,null,null,"PVRR Factor",null,null,null,null,{"$f":"-PV(disc_rate,G21,O53)","v":1.2726464770861423}]
[{"$f":"ROW()","v":57},null,null,null,null,null,null,null,null,"Real LT Discount Rate",null,null,null,null,{"$f":"(1+disc_rate)/(1+$M$62)-1","v":4.6768936212594925E-2}]
[]
[{"$f":"ROW()","v":59},null,null,null,null,null,null,null,null,null,null,"Real %","Tot Infl %"]
[{"$f":"ROW()","v":60},null,null,null,null,null,null,null,null,null,"Inflation Rate % for ST",{"$f":"G16","v":0},{"$f":"(1+L60)*(1+infl)-1","v":2.4999999999999911E-2}]
[{"$f":"ROW()","v":61},null,null,null,null,null,null,null,null,null,"Transition Year for ST to LT (# yrs into the future from base year)",{"$f":"G17","v":10}]
[{"$f":"ROW()","v":62},null,null,null,null,null,null,null,null,null,"Infl Rate % for LT (beyond ST period)",{"$f":"G18","v":0},{"$f":"(1+L62)*(1+infl)-1","v":2.4999999999999911E-2}]
[]
[{"$f":"ROW()","v":64},null,null,null,null,null,null,null,null,null,85]
[{"$f":"ROW()","v":65},null,null,null,null,null,null,null,null,null,null,null,"Total Infl Installed Cost $/kW"]
[{"$f":"ROW()","v":66}]
[{"$f":"ROW()","v":67},null,null,null,null,null,null,null,null,null,null,null,"Total Cost (ST+LT) $/kW","LT Cost $/kW","ST Prem $/kW"]
[{"$f":"ROW()","v":68},null,null,null,null,null,null,null,null,null,0,{"$f":"base_year","v":2024},{"$f":"IF(L68<=base_year+$G$17,$O$51*(1+$M$60)^(L68-$F$47),IF(L68>=$F$47,M67*(1+$M$62)))","v":102.6962048780488},{"$f":"OFFSET($M$68,$G$17,0,1,1)*(1+$M$62)^(L68-$L$68-$G$17)","v":102.69620487804879},{"$f":"ROUND(M68-N68,4)","v":0}]
[{"$f":"ROW()","v":69},null,null,null,null,null,null,null,null,null,1,{"$f":"L68+1","v":2025},105.26361000000001,{"$f":"OFFSET($M$68,$G$17,0,1,1)*(1+$M$62)^(L69-$L$68-$G$17)","v":105.26361000000003},{"$f":"ROUND(M69-N69,4)","v":0}]
[{"$f":"ROW()","v":70},null,null,null,null,null,null,null,null,null,2,{"$f":"L69+1","v":2026},107.89520025000002,{"$f":"OFFSET($M$68,$G$17,0,1,1)*(1+$M$62)^(L70-$L$68-$G$17)","v":107.89520025},0]
[{"$f":"ROW()","v":71},null,null,null,null,null,null,null,null,null,3,2027,110.59258025625002,110.59258025624999,0]
[{"$f":"ROW()","v":72},null,null,null,null,null,null,null,null,null,4,2028,113.35739476265626,113.35739476265624,0]
[{"$f":"ROW()","v":73},null,null,null,null,null,null,null,null,null,5,2029,116.19132963172265,116.19132963172264,0]
[{"$f":"ROW()","v":74},null,null,null,null,null,null,null,null,null,6,2030,119.0961128725157,119.0961128725157,0]
[{"$f":"ROW()","v":75},null,null,null,null,null,null,null,null,null,7,2031,122.07351569432861,122.07351569432858,0]
[{"$f":"ROW()","v":76},null,null,null,null,null,null,null,null,null,8,2032,125.12535358668681,125.12535358668678,0]
[{"$f":"ROW()","v":77},null,null,null,null,null,null,null,null,null,9,2033,128.25348742635396,128.25348742635396,0]
[{"$f":"ROW()","v":78},null,null,null,null,null,null,null,null,null,10,2034,131.4598246120128,131.4598246120128,0]
[{"$f":"ROW()","v":79},null,null,null,null,null,null,null,null,null,11,2035,134.74632022731311,134.74632022731311,0]
[{"$f":"ROW()","v":80},null,null,null,null,null,null,null,null,null,12,2036,138.11497823299592,138.11497823299592,0]
[{"$f":"ROW()","v":81},null,null,null,null,null,null,null,null,null,13,2037,141.56785268882081,141.56785268882084,0]
[{"$f":"ROW()","v":82},null,null,null,null,null,null,null,null,null,14,2038,145.10704900604131,145.10704900604134,0]
[{"$f":"ROW()","v":83},null,null,null,null,null,null,null,null,null,15,2039,148.73472523119233,148.73472523119236,0]
[{"$f":"ROW()","v":84}]
[{"$f":"ROW()","v":85}]
[{"$f":"ROW()","v":86}]
[{"$f":"ROW()","v":87}]
[{"$f":"ROW()","v":88}]
[{"$f":"ROW()","v":89}]
[{"$f":"ROW()","v":90}]
[{"$f":"ROW()","v":91}]
[{"$f":"ROW()","v":92}]
[{"$f":"ROW()","v":93}]
[{"$f":"ROW()","v":94}]
[{"$f":"ROW()","v":95}]
[{"$f":"ROW()","v":96}]
[{"$f":"ROW()","v":97}]
[{"$f":"ROW()","v":98}]
[{"$f":"ROW()","v":99}," -------------------------------------------------- CALCULATIONS -------------------------------------------------------------------------"]
[{"$f":"ROW()","v":100}]
[{"$f":"ROW()","v":101},"CONSTRUCTION PERIOD"]
[{"$f":"ROW()","v":102},null,null,null,null,null,null,null,null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22]
[{"$f":"ROW()","v":103},null,null,null,null,null,null,null,null,{"$f":"K38-1","v":2023},{"$f":"J103+1","v":2024},{"$f":"K103+1","v":2025},{"$f":"L103+1","v":2026},{"$f":"M103+1","v":2027},{"$f":"N103+1","v":2028},2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[{"$f":"ROW()","v":104},"Base Year $ Expenditures split into beg and end of year cash flows",null,null,null,null,null,null,null,{"$f":"0.5*J39+0.5*K39","v":50},50,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"ROW()","v":105},"Years of Inflation Applied",null,null,null,null,null,null,null,{"$f":"J103-base_year+0.5","v":-0.5},0.5,1.5,2.5,3.5,4.5,5.5,6.5,7.5,8.5,9.5,10.5,11.5,12.5,13.5,14.5,15.5,16.5,17.5,18.5,19.5,20.5,21.5]
[{"$f":"ROW()","v":106},"Infl $ expenditures using beg_end of year cash flow convention",null,null,null,null,null,null,null,{"$f":"J104*(1+infl)^J105","v":49.386479832479488},50.621141828291464,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"ROW()","v":107}]
[{"$f":"ROW()","v":108}]
[{"$f":"ROW()","v":109}]
[{"$f":"ROW()","v":110},null,null,null,null,null,"Totals",null,null,{"$f":"J$103","v":2023},2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045]
[{"$f":"ROW()","v":111},"CWIP in Ratebase (see Input Notes re: setting % to zero)"]
[{"$f":"ROW()","v":112},"Construction Expenditure",null,null,null,null,{"$f":"SUM(J112:AF112)","v":100.00762166077095},null,null,{"$f":"J106","v":49.386479832479488},{"$f":"K106","v":50.621141828291464},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"ROW()","v":113},"CWIP to include in RB period-end before Closings",null,null,null,null,null,null,null,{"$f":"J112*$G$32+I116","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"ROW()","v":114}]
[{"$f":"ROW()","v":115},"Less: Closing to Plant (for RB calc)",null,null,null,null,null,null,null,{"$f":"-J113*J40","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"ROW()","v":116},"CWIP for RB calc period-end after Closings",null,null,null,null,null,null,null,{"$f":"J113+J115","v":0},{"$f":"K113+K115","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"ROW()","v":117},"AFUDC capitalized to Plant in Service:"]
[{"$f":"ROW()","v":118},"AFUDC debt  (calc from prior period-end CWIP)",null,null,null,null,{"$f":"SUM(J118:AF118)","v":1.4534848453157332},null,null,{"$f":"(I122)*afudc_debt","v":0},1.4534848453157332,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"ROW()","v":119},"AFUDC equity  (calc from prior period-end CWIP)",null,null,null,null,{"$f":"SUM(J119:AF119)","v":2.5108765410930269},null,null,{"$f":"(I122)*afudc_equity","v":0},2.5108765410930269,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"ROW()","v":120},"CWIP for AFUDC calc period-end before Closings",null,null,null,null,null,null,null,{"$f":"I122+J112-(J113-I113-I115)+J118+J119","v":49.386479832479488},103.97198304717971,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"ROW()","v":121},"Less: Closing to Plant",null,null,null,null,null,null,null,{"$f":"-J120*J40","v":0},-103.97198304717971,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"ROW()","v":122},"CWIP for AFUDC calc period-end after Closings",null,null,null,null,null,null,null,{"$f":"J120+J121","v":49.386479832479488},{"$f":"K120+K121","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"ROW()","v":123},"CWIP incl AFUDC  period-end after Closings",null,null,null,null,null,null,null,{"$f":"J116+J122","v":49.386479832479488},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"ROW()","v":124},"Amount Closed to Plant",null,null,null,null,null,null,null,{"$f":"-(J115+J121)","v":0},103.97198304717971,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"ROW()","v":125},"Cumulative Closed to Plant (Gross Plant)",null,null,null,null,{"$f":"SUM(G112:G119)","v":103.97198304717971},null,null,{"$f":"IF(J112>0,I125+J124,0)","v":0},103.97198304717971,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"ROW()","v":126}]
[{"$f":"ROW()","v":127},"Interest for Tax Purposes",null,null,null,null,null,null,null,{"$f":"J$103","v":2023},{"$f":"K$103","v":2024},{"$f":"L$103","v":2025},{"$f":"M$103","v":2026},{"$f":"N$103","v":2027},{"$f":"O$105","v":4.5},5.5,6.5,7.5,8.5,9.5,10.5,11.5,12.5,13.5,14.5,15.5,16.5,17.5,18.5,19.5,20.5,21.5]
[{"$f":"ROW()","v":128}]
[{"$f":"ROW()","v":129},"CWIP for Cap Interest beg period",null,null,null,null,null,null,null,{"$f":"I134","v":0},{"$f":"J134","v":49.386479832479488},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"ROW()","v":130},"Expenditure",null,null,null,null,null,null,null,{"$f":"J112*$G$19","v":49.386479832479488},50.621141828291464,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"ROW()","v":131},"Capitalized Interest",null,null,null,null,{"$f":"SUM(J131:AF131)","v":3.0372685096974883},null,null,{"$f":"(J129)*cap_int","v":0},3.0372685096974883,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"ROW()","v":132},"CWIP period-end before closings",null,null,null,null,null,null,null,{"$f":"SUM(J129:J131)","v":49.386479832479488},{"$f":"SUM(K129:K131)","v":103.04489017046843},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"ROW()","v":133},"Less: Closings to Plant",null,null,null,null,null,null,null,{"$f":"-J40*J132","v":0},-103.04489017046843,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"ROW()","v":134},"CWIP period-end after Closings",null,null,null,null,null,null,null,{"$f":"J132+J133","v":49.386479832479488},{"$f":"K132+K133","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"ROW()","v":135}]
[{"$f":"ROW()","v":136}]
[{"$f":"ROW()","v":137},"Construction Period After-Tax Cost Cash Flows"]
[{"$f":"ROW()","v":138},"Direct Expenditures",null,null,null,null,null,null,null,{"$f":"J112","v":49.386479832479488},{"$f":"K112","v":50.621141828291464},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"ROW()","v":139},"Tax Impact of Capitalizing of Interest",null,null,null,null,null,null,null,{"$f":"J131*Tax_Rate","v":0},0.75687480392998374,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"ROW()","v":140},"  Total Construction Period Cost Cash Flows (AT)",null,null,null,null,null,null,null,{"$f":"J138+J139","v":49.386479832479488},{"$f":"K138+K139","v":51.378016632221446},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"ROW()","v":141},"  PV Construction Period Cost Cash Flows (AT)",null,null,null,null,{"$f":"NPV(disc_rate,J140:BX140)*(1+disc_rate)^(COUNTIF(J112:AF112,\">0\")+H41-1)","v":104.366655413689}]
[{"$f":"ROW()","v":142}]
[{"$f":"ROW()","v":143},"SERVICE PERIOD",null,null,null,null,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,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67]
[{"$f":"ROW()","v":144},null,null,null,null,null,null,null,null,{"$f":"J127+COUNTIF(J138:AF138,\">0\")","v":2025},{"$f":"J144+1","v":2026},{"$f":"K144+1","v":2027},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,2056,2057,2058,2059,2060,2061,2062,2063,2064,2065,2066,2067,2068,2069,2070,2071,2072,2073,2074,2075,2076,2077,2078,2079,2080,2081,2082,2083,2084,2085,2086,2087,2088,2089,2090,{"$f":"BW144+1","v":2091}]
[{"$f":"ROW()","v":145},"Tax Depreciation Rates",null,null,null,null,null,null,null,{"$f":"VLOOKUP($G$20,tax_dep_rates,J143+1,FALSE)","v":7.400000000000001E-2},6.9500000000000006E-2,6.4500000000000002E-2,5.9499999999999997E-2,5.5000000000000007E-2,5.1000000000000004E-2,4.7E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,3.95E-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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"VLOOKUP($G$20,tax_dep_rates,BV143+1,FALSE)","v":0},{"$f":"VLOOKUP($G$20,tax_dep_rates,BW143+1,FALSE)","v":0},{"$f":"VLOOKUP($G$20,tax_dep_rates,BX143+1,FALSE)","v":0}]
[{"$f":"ROW()","v":146},"Tax Basis for MACRS Depreciation",null,null,null,null,{"$f":"G112*(1-G24*G30)-G147","v":100.00762166077095}]
[{"$f":"ROW()","v":147},"Bonus Depreciation",null,null,null,null,{"$f":"G112*(1-G24*G30)*G31","v":0}]
[{"$f":"ROW()","v":148},"Salvage Value (or Site Restoration Cost)",null,null,null,null,null,null,null,{"$f":"IF(J144=$J$144+$G$21-1,$G$22*$G$125,0)","v":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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-20.794396609435942,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(BV144=$J$144+$G$21-1,$G$22*$G$125,0)","v":0},{"$f":"IF(BW144=$J$144+$G$21-1,$G$22*$G$125,0)","v":0},{"$f":"IF(BX144=$J$144+$G$21-1,$G$22*$G$125,0)","v":0}]
[{"$f":"ROW()","v":149},"Nuclear Decommissioning Cost",null,null,null,null,null,null,null,{"$f":"IF(J144<=$J$144+$G$21-1,$G$23*$G$125,0)","v":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,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,0,0,{"$f":"IF(BV144<=$J$144+$G$21-1,$G$23*$G$125,0)","v":0},{"$f":"IF(BW144<=$J$144+$G$21-1,$G$23*$G$125,0)","v":0},{"$f":"IF(BX144<=$J$144+$G$21-1,$G$23*$G$125,0)","v":0}]
[{"$f":"ROW()","v":150},"Property Tax  (if Nuclear case, may be fixed input)",null,null,null,null,{"$f":"NPV(disc_rate,J150:BX150)","v":10.756600945814906},null,null,{"$f":"IF(J144<=$J$144+$G$21-1,OFFSET(J189,$G$33,0,1,1)*$G$34,0)","v":1.0622526927083338},{"$f":"IF(K144<=$J$144+$G$21-1,OFFSET(K189,$G$33,0,1,1)*$G$34,0)","v":1.041424208537582},1.0205957243668304,0.99976724019607877,0.97893875602532709,0.95811027185457553,0.93728178768382386,0.91645330351307208,0.89562481934232052,0.87479633517156885,0.85396785100081729,0.83313936683006562,0.81231088265931395,0.79148239848856228,0.77065391431781072,0.74982543014705894,0.72899694597630749,0.7081684618055557,0.68733997763480426,0.66651149346405247,0.64568300929330091,0.62485452512254935,0.60402604095179768,0.58319755678104612,0.56236907261029445,0.54154058843954289,0.52071210426879122,0.49988362009803966,0.47905513592728804,0.45822665175653643,0.43739816758578481,0.4165696834150332,0.39574119924428153,0.37491271507352991,0.3540842309027783,0.33325574673202668,0.31242726256127507,0.29159877839052345,0.27077029421977183,0.24994181004902022,0.2291133258782686,0.20828484170751699,0.18745635753676537,0.16662787336601378,0.14579938919526217,0.12497090502451055,0.10414242085375894,8.3313936683007322E-2,6.2485452512255707E-2,4.1656968341504098E-2,2.0828484170752483E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(BW144<=$J$144+$G$21-1,OFFSET(BW189,$G$33,0,1,1)*$G$34,0)","v":0},{"$f":"IF(BX144<=$J$144+$G$21-1,OFFSET(BX189,$G$33,0,1,1)*$G$34,0)","v":0}]
[{"$f":"ROW()","v":151},"Insurance",null,null,null,null,{"$f":"NPV(disc_rate,J151:BX151)","v":0.85901439511451494},null,null,{"$f":"IF(AND(J143<=$G$21,J143<=$G$17),$G$35*$G$125*(1+$M$60)^J143,IF(J143<=$G$21,I151*(1+$M$62),0))","v":4.5612508962797733E-2},{"$f":"IF(AND(K143<=$G$21,K143<=$G$17),$G$35*$G$125*(1+$M$60)^K143,IF(K143<=$G$21,J151*(1+$M$62),0))","v":4.6752821686867681E-2},4.7921642229039371E-2,4.9119683284765348E-2,5.0347675366884476E-2,5.1606367251056585E-2,5.2896526432333002E-2,5.4218939593141321E-2,5.5574413082969849E-2,5.6963773410044091E-2,5.838786774529519E-2,5.9847564438927567E-2,6.1343753549900751E-2,6.2877347388648266E-2,6.4449281073364464E-2,6.6060513100198573E-2,6.7712025927703534E-2,6.9404826575896111E-2,7.1139947240293502E-2,7.291844592130084E-2,7.4741407069333354E-2,7.6609942246066681E-2,7.8525190802218342E-2,8.04883205722738E-2,8.2500528586580635E-2,8.4563041801245145E-2,8.6677117846276269E-2,8.8844045792433171E-2,9.106514693724399E-2,9.3341775610675082E-2,9.5675320000941949E-2,9.8067203000965483E-2,0.10051888307598961,0.10303185515288933,0.10560765153171156,0.10824784282000434,0.11095403889050444,0.11372788986276704,0.1165710871093362,0.11948536428706959,0.12247249839424632,0.12553431085410247,0.12867266862545501,0.13188948534109138,0.13518672247461866,0.13856639053648412,0.1420305502998962,0.14558131405739358,0.14922084690882842,0.15295136808154911,0.15677515228358782,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AND(BW143<=$G$21,BW143<=$G$17),$G$35*$G$125*(1+$M$60)^BW143,IF(BW143<=$G$21,BV151*(1+$M$62),0))","v":0},{"$f":"IF(AND(BX143<=$G$21,BX143<=$G$17),$G$35*$G$125*(1+$M$60)^BX143,IF(BX143<=$G$21,BW151*(1+$M$62),0))","v":0}]
[{"$f":"ROW()","v":152}]
[{"$f":"ROW()","v":153}]
[{"$f":"ROW()","v":154}]
[{"$f":"ROW()","v":155}]
[{"$f":"ROW()","v":156},"Service Period After-Tax Cost Cash Flows"]
[{"$f":"ROW()","v":157},"Investment Tax Credit",null,null,"(amortization of the ITC -- see Note A)",null,null,null,null,{"$f":"IF(AND(J143>$G$25,J143<=$G$21),-$G$24*$G$112/($G$21-$G$25),0)","v":0},{"$f":"IF(AND(K143>$G$25,K143<=$G$21),-$G$24*$G$112/($G$21-$G$25),0)","v":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,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,0,0,{"$f":"IF(AND(BW143>$G$25,BW143<=$G$21),-$G$24*$G$112/($G$21-$G$25),0)","v":0},{"$f":"IF(AND(BX143>$G$25,BX143<=$G$21),-$G$24*$G$112/($G$21-$G$25),0)","v":0}]
[{"$f":"ROW()","v":158},"Investment Tax Credit STATE",null,null,"(no amortization assumed -- see Note A)",null,null,null,null,{"$f":"IF(AND(J143<=$G$28,J143>$G$29),-$G$27*$G$112/($G$28-$G$29),0)*(1-Tax_Rate)","v":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,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,0,0,{"$f":"IF(AND(BV143<=$G$28,BV143>$G$29),-$G$27*$G$112/($G$28-$G$29),0)*(1-Tax_Rate)","v":0},{"$f":"IF(AND(BW143<=$G$28,BW143>$G$29),-$G$27*$G$112/($G$28-$G$29),0)*(1-Tax_Rate)","v":0},{"$f":"IF(AND(BX143<=$G$28,BX143>$G$29),-$G$27*$G$112/($G$28-$G$29),0)*(1-Tax_Rate)","v":0}]
[{"$f":"ROW()","v":159},"State income tax adjustment for Federal ITC related tax basis adjustment (Note A)",null,null,null,null,null,null,null,{"$f":"IF(AND($G$26=\"yes\",J143=$G$25+1),-$G$112*$G$24*$G$30*state_tax_rate*(1-fed_tax_rate),0)","v":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,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,0,0,{"$f":"IF(AND($G$26=\"yes\",BV143=$G$25+1),-$G$112*$G$24*$G$30*state_tax_rate*(1-fed_tax_rate),0)","v":0},{"$f":"IF(AND($G$26=\"yes\",BW143=$G$25+1),-$G$112*$G$24*$G$30*state_tax_rate*(1-fed_tax_rate),0)","v":0},{"$f":"IF(AND($G$26=\"yes\",BX143=$G$25+1),-$G$112*$G$24*$G$30*state_tax_rate*(1-fed_tax_rate),0)","v":0}]
[{"$f":"ROW()","v":160},"Depreciation Tax Shield (1st yr captures bonus depreciation, if any applies)",null,null,null,null,null,null,null,{"$f":"IF(AND(J143<$G$21,J143<=COUNTIF($J$145:$BX$145,\">0\")),-(J145*$G$146+G147)*Tax_Rate,IF(AND(J143<=COUNTIF($J$145:$BX$145,\">0\"),J143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:I160)),0))","v":-1.8441900710391557},{"$f":"IF(AND(K143<$G$21,K143<=COUNTIF($J$145:$BX$145,\">0\")),-(K145*$G$146+H147)*Tax_Rate,IF(AND(K143<=COUNTIF($J$145:$BX$145,\">0\"),K143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:J160)),0))","v":-1.7320433775300179},{"$f":"IF(AND(L143<$G$21,L143<=COUNTIF($J$145:$BX$145,\">0\")),-(L145*$G$146+I147)*Tax_Rate,IF(AND(L143<=COUNTIF($J$145:$BX$145,\">0\"),L143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:K160)),0))","v":-1.6074359402976424},{"$f":"IF(AND(M143<$G$21,M143<=COUNTIF($J$145:$BX$145,\">0\")),-(M145*$G$146+J147)*Tax_Rate,IF(AND(M143<=COUNTIF($J$145:$BX$145,\">0\"),M143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:L160)),0))","v":-1.4828285030652666},{"$f":"IF(AND(N143<$G$21,N143<=COUNTIF($J$145:$BX$145,\">0\")),-(N145*$G$146+K147)*Tax_Rate,IF(AND(N143<=COUNTIF($J$145:$BX$145,\">0\"),N143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:M160)),0))","v":-1.3706818095561293},{"$f":"IF(AND(O143<$G$21,O143<=COUNTIF($J$145:$BX$145,\">0\")),-(O145*$G$146+L147)*Tax_Rate,IF(AND(O143<=COUNTIF($J$145:$BX$145,\">0\"),O143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:N160)),0))","v":-1.2709958597702289},{"$f":"IF(AND(P143<$G$21,P143<=COUNTIF($J$145:$BX$145,\">0\")),-(P145*$G$146+M147)*Tax_Rate,IF(AND(P143<=COUNTIF($J$145:$BX$145,\">0\"),P143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:O160)),0))","v":-1.1713099099843285},{"$f":"IF(AND(Q143<$G$21,Q143<=COUNTIF($J$145:$BX$145,\">0\")),-(Q145*$G$146+N147)*Tax_Rate,IF(AND(Q143<=COUNTIF($J$145:$BX$145,\">0\"),Q143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:P160)),0))","v":-1.1214669350913784},{"$f":"IF(AND(R143<$G$21,R143<=COUNTIF($J$145:$BX$145,\">0\")),-(R145*$G$146+O147)*Tax_Rate,IF(AND(R143<=COUNTIF($J$145:$BX$145,\">0\"),R143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:Q160)),0))","v":-1.1214669350913784},{"$f":"IF(AND(S143<$G$21,S143<=COUNTIF($J$145:$BX$145,\">0\")),-(S145*$G$146+P147)*Tax_Rate,IF(AND(S143<=COUNTIF($J$145:$BX$145,\">0\"),S143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:R160)),0))","v":-1.1214669350913784},{"$f":"IF(AND(T143<$G$21,T143<=COUNTIF($J$145:$BX$145,\">0\")),-(T145*$G$146+Q147)*Tax_Rate,IF(AND(T143<=COUNTIF($J$145:$BX$145,\">0\"),T143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:S160)),0))","v":-1.1214669350913784},{"$f":"IF(AND(U143<$G$21,U143<=COUNTIF($J$145:$BX$145,\">0\")),-(U145*$G$146+R147)*Tax_Rate,IF(AND(U143<=COUNTIF($J$145:$BX$145,\">0\"),U143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:T160)),0))","v":-1.1214669350913784},{"$f":"IF(AND(V143<$G$21,V143<=COUNTIF($J$145:$BX$145,\">0\")),-(V145*$G$146+S147)*Tax_Rate,IF(AND(V143<=COUNTIF($J$145:$BX$145,\">0\"),V143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:U160)),0))","v":-1.1214669350913784},{"$f":"IF(AND(W143<$G$21,W143<=COUNTIF($J$145:$BX$145,\">0\")),-(W145*$G$146+T147)*Tax_Rate,IF(AND(W143<=COUNTIF($J$145:$BX$145,\">0\"),W143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:V160)),0))","v":-1.1214669350913784},{"$f":"IF(AND(X143<$G$21,X143<=COUNTIF($J$145:$BX$145,\">0\")),-(X145*$G$146+U147)*Tax_Rate,IF(AND(X143<=COUNTIF($J$145:$BX$145,\">0\"),X143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:W160)),0))","v":-1.1214669350913784},{"$f":"IF(AND(Y143<$G$21,Y143<=COUNTIF($J$145:$BX$145,\">0\")),-(Y145*$G$146+V147)*Tax_Rate,IF(AND(Y143<=COUNTIF($J$145:$BX$145,\">0\"),Y143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:X160)),0))","v":-1.1214669350913784},{"$f":"IF(AND(Z143<$G$21,Z143<=COUNTIF($J$145:$BX$145,\">0\")),-(Z145*$G$146+W147)*Tax_Rate,IF(AND(Z143<=COUNTIF($J$145:$BX$145,\">0\"),Z143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:Y160)),0))","v":-1.1214669350913784},{"$f":"IF(AND(AA143<$G$21,AA143<=COUNTIF($J$145:$BX$145,\">0\")),-(AA145*$G$146+X147)*Tax_Rate,IF(AND(AA143<=COUNTIF($J$145:$BX$145,\">0\"),AA143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:Z160)),0))","v":-1.1214669350913784},{"$f":"IF(AND(AB143<$G$21,AB143<=COUNTIF($J$145:$BX$145,\">0\")),-(AB145*$G$146+Y147)*Tax_Rate,IF(AND(AB143<=COUNTIF($J$145:$BX$145,\">0\"),AB143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:AA160)),0))","v":-1.1214669350913784},{"$f":"IF(AND(AC143<$G$21,AC143<=COUNTIF($J$145:$BX$145,\">0\")),-(AC145*$G$146+Z147)*Tax_Rate,IF(AND(AC143<=COUNTIF($J$145:$BX$145,\">0\"),AC143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:AB160)),0))","v":-0.9843987541357655},{"$f":"IF(AND(AD143<$G$21,AD143<=COUNTIF($J$145:$BX$145,\">0\")),-(AD145*$G$146+AA147)*Tax_Rate,IF(AND(AD143<=COUNTIF($J$145:$BX$145,\">0\"),AD143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:AC160)),0))","v":0},{"$f":"IF(AND(AE143<$G$21,AE143<=COUNTIF($J$145:$BX$145,\">0\")),-(AE145*$G$146+AB147)*Tax_Rate,IF(AND(AE143<=COUNTIF($J$145:$BX$145,\">0\"),AE143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:AD160)),0))","v":0},{"$f":"IF(AND(AF143<$G$21,AF143<=COUNTIF($J$145:$BX$145,\">0\")),-(AF145*$G$146+AC147)*Tax_Rate,IF(AND(AF143<=COUNTIF($J$145:$BX$145,\">0\"),AF143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:AE160)),0))","v":0},{"$f":"IF(AND(AG143<$G$21,AG143<=COUNTIF($J$145:$BX$145,\">0\")),-(AG145*$G$146+AD147)*Tax_Rate,IF(AND(AG143<=COUNTIF($J$145:$BX$145,\">0\"),AG143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:AF160)),0))","v":0},{"$f":"IF(AND(AH143<$G$21,AH143<=COUNTIF($J$145:$BX$145,\">0\")),-(AH145*$G$146+AE147)*Tax_Rate,IF(AND(AH143<=COUNTIF($J$145:$BX$145,\">0\"),AH143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:AG160)),0))","v":0},{"$f":"IF(AND(AI143<$G$21,AI143<=COUNTIF($J$145:$BX$145,\">0\")),-(AI145*$G$146+AF147)*Tax_Rate,IF(AND(AI143<=COUNTIF($J$145:$BX$145,\">0\"),AI143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:AH160)),0))","v":0},{"$f":"IF(AND(AJ143<$G$21,AJ143<=COUNTIF($J$145:$BX$145,\">0\")),-(AJ145*$G$146+AG147)*Tax_Rate,IF(AND(AJ143<=COUNTIF($J$145:$BX$145,\">0\"),AJ143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:AI160)),0))","v":0},{"$f":"IF(AND(AK143<$G$21,AK143<=COUNTIF($J$145:$BX$145,\">0\")),-(AK145*$G$146+AH147)*Tax_Rate,IF(AND(AK143<=COUNTIF($J$145:$BX$145,\">0\"),AK143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:AJ160)),0))","v":0},{"$f":"IF(AND(AL143<$G$21,AL143<=COUNTIF($J$145:$BX$145,\">0\")),-(AL145*$G$146+AI147)*Tax_Rate,IF(AND(AL143<=COUNTIF($J$145:$BX$145,\">0\"),AL143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:AK160)),0))","v":0},{"$f":"IF(AND(AM143<$G$21,AM143<=COUNTIF($J$145:$BX$145,\">0\")),-(AM145*$G$146+AJ147)*Tax_Rate,IF(AND(AM143<=COUNTIF($J$145:$BX$145,\">0\"),AM143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:AL160)),0))","v":0},{"$f":"IF(AND(AN143<$G$21,AN143<=COUNTIF($J$145:$BX$145,\">0\")),-(AN145*$G$146+AK147)*Tax_Rate,IF(AND(AN143<=COUNTIF($J$145:$BX$145,\">0\"),AN143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:AM160)),0))","v":0},{"$f":"IF(AND(AO143<$G$21,AO143<=COUNTIF($J$145:$BX$145,\">0\")),-(AO145*$G$146+AL147)*Tax_Rate,IF(AND(AO143<=COUNTIF($J$145:$BX$145,\">0\"),AO143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:AN160)),0))","v":0},{"$f":"IF(AND(AP143<$G$21,AP143<=COUNTIF($J$145:$BX$145,\">0\")),-(AP145*$G$146+AM147)*Tax_Rate,IF(AND(AP143<=COUNTIF($J$145:$BX$145,\">0\"),AP143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:AO160)),0))","v":0},{"$f":"IF(AND(AQ143<$G$21,AQ143<=COUNTIF($J$145:$BX$145,\">0\")),-(AQ145*$G$146+AN147)*Tax_Rate,IF(AND(AQ143<=COUNTIF($J$145:$BX$145,\">0\"),AQ143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:AP160)),0))","v":0},{"$f":"IF(AND(AR143<$G$21,AR143<=COUNTIF($J$145:$BX$145,\">0\")),-(AR145*$G$146+AO147)*Tax_Rate,IF(AND(AR143<=COUNTIF($J$145:$BX$145,\">0\"),AR143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:AQ160)),0))","v":0},{"$f":"IF(AND(AS143<$G$21,AS143<=COUNTIF($J$145:$BX$145,\">0\")),-(AS145*$G$146+AP147)*Tax_Rate,IF(AND(AS143<=COUNTIF($J$145:$BX$145,\">0\"),AS143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:AR160)),0))","v":0},{"$f":"IF(AND(AT143<$G$21,AT143<=COUNTIF($J$145:$BX$145,\">0\")),-(AT145*$G$146+AQ147)*Tax_Rate,IF(AND(AT143<=COUNTIF($J$145:$BX$145,\">0\"),AT143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:AS160)),0))","v":0},{"$f":"IF(AND(AU143<$G$21,AU143<=COUNTIF($J$145:$BX$145,\">0\")),-(AU145*$G$146+AR147)*Tax_Rate,IF(AND(AU143<=COUNTIF($J$145:$BX$145,\">0\"),AU143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:AT160)),0))","v":0},{"$f":"IF(AND(AV143<$G$21,AV143<=COUNTIF($J$145:$BX$145,\">0\")),-(AV145*$G$146+AS147)*Tax_Rate,IF(AND(AV143<=COUNTIF($J$145:$BX$145,\">0\"),AV143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:AU160)),0))","v":0},{"$f":"IF(AND(AW143<$G$21,AW143<=COUNTIF($J$145:$BX$145,\">0\")),-(AW145*$G$146+AT147)*Tax_Rate,IF(AND(AW143<=COUNTIF($J$145:$BX$145,\">0\"),AW143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:AV160)),0))","v":0},{"$f":"IF(AND(AX143<$G$21,AX143<=COUNTIF($J$145:$BX$145,\">0\")),-(AX145*$G$146+AU147)*Tax_Rate,IF(AND(AX143<=COUNTIF($J$145:$BX$145,\">0\"),AX143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:AW160)),0))","v":0},{"$f":"IF(AND(AY143<$G$21,AY143<=COUNTIF($J$145:$BX$145,\">0\")),-(AY145*$G$146+AV147)*Tax_Rate,IF(AND(AY143<=COUNTIF($J$145:$BX$145,\">0\"),AY143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:AX160)),0))","v":0},{"$f":"IF(AND(AZ143<$G$21,AZ143<=COUNTIF($J$145:$BX$145,\">0\")),-(AZ145*$G$146+AW147)*Tax_Rate,IF(AND(AZ143<=COUNTIF($J$145:$BX$145,\">0\"),AZ143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:AY160)),0))","v":0},{"$f":"IF(AND(BA143<$G$21,BA143<=COUNTIF($J$145:$BX$145,\">0\")),-(BA145*$G$146+AX147)*Tax_Rate,IF(AND(BA143<=COUNTIF($J$145:$BX$145,\">0\"),BA143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:AZ160)),0))","v":0},{"$f":"IF(AND(BB143<$G$21,BB143<=COUNTIF($J$145:$BX$145,\">0\")),-(BB145*$G$146+AY147)*Tax_Rate,IF(AND(BB143<=COUNTIF($J$145:$BX$145,\">0\"),BB143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:BA160)),0))","v":0},{"$f":"IF(AND(BC143<$G$21,BC143<=COUNTIF($J$145:$BX$145,\">0\")),-(BC145*$G$146+AZ147)*Tax_Rate,IF(AND(BC143<=COUNTIF($J$145:$BX$145,\">0\"),BC143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:BB160)),0))","v":0},{"$f":"IF(AND(BD143<$G$21,BD143<=COUNTIF($J$145:$BX$145,\">0\")),-(BD145*$G$146+BA147)*Tax_Rate,IF(AND(BD143<=COUNTIF($J$145:$BX$145,\">0\"),BD143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:BC160)),0))","v":0},{"$f":"IF(AND(BE143<$G$21,BE143<=COUNTIF($J$145:$BX$145,\">0\")),-(BE145*$G$146+BB147)*Tax_Rate,IF(AND(BE143<=COUNTIF($J$145:$BX$145,\">0\"),BE143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:BD160)),0))","v":0},{"$f":"IF(AND(BF143<$G$21,BF143<=COUNTIF($J$145:$BX$145,\">0\")),-(BF145*$G$146+BC147)*Tax_Rate,IF(AND(BF143<=COUNTIF($J$145:$BX$145,\">0\"),BF143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:BE160)),0))","v":0},{"$f":"IF(AND(BG143<$G$21,BG143<=COUNTIF($J$145:$BX$145,\">0\")),-(BG145*$G$146+BD147)*Tax_Rate,IF(AND(BG143<=COUNTIF($J$145:$BX$145,\">0\"),BG143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:BF160)),0))","v":0},{"$f":"IF(AND(BH143<$G$21,BH143<=COUNTIF($J$145:$BX$145,\">0\")),-(BH145*$G$146+BE147)*Tax_Rate,IF(AND(BH143<=COUNTIF($J$145:$BX$145,\">0\"),BH143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:BG160)),0))","v":0},{"$f":"IF(AND(BI143<$G$21,BI143<=COUNTIF($J$145:$BX$145,\">0\")),-(BI145*$G$146+BF147)*Tax_Rate,IF(AND(BI143<=COUNTIF($J$145:$BX$145,\">0\"),BI143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:BH160)),0))","v":0},{"$f":"IF(AND(BJ143<$G$21,BJ143<=COUNTIF($J$145:$BX$145,\">0\")),-(BJ145*$G$146+BG147)*Tax_Rate,IF(AND(BJ143<=COUNTIF($J$145:$BX$145,\">0\"),BJ143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:BI160)),0))","v":0},{"$f":"IF(AND(BK143<$G$21,BK143<=COUNTIF($J$145:$BX$145,\">0\")),-(BK145*$G$146+BH147)*Tax_Rate,IF(AND(BK143<=COUNTIF($J$145:$BX$145,\">0\"),BK143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:BJ160)),0))","v":0},{"$f":"IF(AND(BL143<$G$21,BL143<=COUNTIF($J$145:$BX$145,\">0\")),-(BL145*$G$146+BI147)*Tax_Rate,IF(AND(BL143<=COUNTIF($J$145:$BX$145,\">0\"),BL143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:BK160)),0))","v":0},{"$f":"IF(AND(BM143<$G$21,BM143<=COUNTIF($J$145:$BX$145,\">0\")),-(BM145*$G$146+BJ147)*Tax_Rate,IF(AND(BM143<=COUNTIF($J$145:$BX$145,\">0\"),BM143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:BL160)),0))","v":0},{"$f":"IF(AND(BN143<$G$21,BN143<=COUNTIF($J$145:$BX$145,\">0\")),-(BN145*$G$146+BK147)*Tax_Rate,IF(AND(BN143<=COUNTIF($J$145:$BX$145,\">0\"),BN143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:BM160)),0))","v":0},{"$f":"IF(AND(BO143<$G$21,BO143<=COUNTIF($J$145:$BX$145,\">0\")),-(BO145*$G$146+BL147)*Tax_Rate,IF(AND(BO143<=COUNTIF($J$145:$BX$145,\">0\"),BO143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:BN160)),0))","v":0},{"$f":"IF(AND(BP143<$G$21,BP143<=COUNTIF($J$145:$BX$145,\">0\")),-(BP145*$G$146+BM147)*Tax_Rate,IF(AND(BP143<=COUNTIF($J$145:$BX$145,\">0\"),BP143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:BO160)),0))","v":0},{"$f":"IF(AND(BQ143<$G$21,BQ143<=COUNTIF($J$145:$BX$145,\">0\")),-(BQ145*$G$146+BN147)*Tax_Rate,IF(AND(BQ143<=COUNTIF($J$145:$BX$145,\">0\"),BQ143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:BP160)),0))","v":0},{"$f":"IF(AND(BR143<$G$21,BR143<=COUNTIF($J$145:$BX$145,\">0\")),-(BR145*$G$146+BO147)*Tax_Rate,IF(AND(BR143<=COUNTIF($J$145:$BX$145,\">0\"),BR143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:BQ160)),0))","v":0},{"$f":"IF(AND(BS143<$G$21,BS143<=COUNTIF($J$145:$BX$145,\">0\")),-(BS145*$G$146+BP147)*Tax_Rate,IF(AND(BS143<=COUNTIF($J$145:$BX$145,\">0\"),BS143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:BR160)),0))","v":0},{"$f":"IF(AND(BT143<$G$21,BT143<=COUNTIF($J$145:$BX$145,\">0\")),-(BT145*$G$146+BQ147)*Tax_Rate,IF(AND(BT143<=COUNTIF($J$145:$BX$145,\">0\"),BT143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:BS160)),0))","v":0},{"$f":"IF(AND(BU143<$G$21,BU143<=COUNTIF($J$145:$BX$145,\">0\")),-(BU145*$G$146+BR147)*Tax_Rate,IF(AND(BU143<=COUNTIF($J$145:$BX$145,\">0\"),BU143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:BT160)),0))","v":0},{"$f":"IF(AND(BV143<$G$21,BV143<=COUNTIF($J$145:$BX$145,\">0\")),-(BV145*$G$146+BS147)*Tax_Rate,IF(AND(BV143<=COUNTIF($J$145:$BX$145,\">0\"),BV143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:BU160)),0))","v":0},{"$f":"IF(AND(BW143<$G$21,BW143<=COUNTIF($J$145:$BX$145,\">0\")),-(BW145*$G$146+BT147)*Tax_Rate,IF(AND(BW143<=COUNTIF($J$145:$BX$145,\">0\"),BW143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:BV160)),0))","v":0},{"$f":"IF(AND(BX143<$G$21,BX143<=COUNTIF($J$145:$BX$145,\">0\")),-(BX145*$G$146+BU147)*Tax_Rate,IF(AND(BX143<=COUNTIF($J$145:$BX$145,\">0\"),BX143=$G$21),-(SUM($G$146:$G$147)*Tax_Rate+SUM($I$160:BW160)),0))","v":0}]
[{"$f":"ROW()","v":161},"Interest Tax Shield",null,null,null,null,null,null,null,{"$f":"IF(AND(J143<$G$21,J143<=COUNTIF($J$145:$BX$145,\">0\")),-(J145*$G$131)*Tax_Rate,IF(AND(J143<=COUNTIF($J$145:$BX$145,\">0\"),J143=$G$21),-($G$131*Tax_Rate+SUM($I161:I161)),0))","v":-5.6008735490818806E-2},{"$f":"IF(AND(K143<$G$21,K143<=COUNTIF($J$145:$BX$145,\">0\")),-(K145*$G$131)*Tax_Rate,IF(AND(K143<=COUNTIF($J$145:$BX$145,\">0\"),K143=$G$21),-($G$131*Tax_Rate+SUM($I161:J161)),0))","v":-5.2602798873133877E-2},{"$f":"IF(AND(L143<$G$21,L143<=COUNTIF($J$145:$BX$145,\">0\")),-(L145*$G$131)*Tax_Rate,IF(AND(L143<=COUNTIF($J$145:$BX$145,\">0\"),L143=$G$21),-($G$131*Tax_Rate+SUM($I161:K161)),0))","v":-4.8818424853483949E-2},{"$f":"IF(AND(M143<$G$21,M143<=COUNTIF($J$145:$BX$145,\">0\")),-(M145*$G$131)*Tax_Rate,IF(AND(M143<=COUNTIF($J$145:$BX$145,\">0\"),M143=$G$21),-($G$131*Tax_Rate+SUM($I161:L161)),0))","v":-4.5034050833834036E-2},{"$f":"IF(AND(N143<$G$21,N143<=COUNTIF($J$145:$BX$145,\">0\")),-(N145*$G$131)*Tax_Rate,IF(AND(N143<=COUNTIF($J$145:$BX$145,\">0\"),N143=$G$21),-($G$131*Tax_Rate+SUM($I161:M161)),0))","v":-4.1628114216149113E-2},{"$f":"IF(AND(O143<$G$21,O143<=COUNTIF($J$145:$BX$145,\">0\")),-(O145*$G$131)*Tax_Rate,IF(AND(O143<=COUNTIF($J$145:$BX$145,\">0\"),O143=$G$21),-($G$131*Tax_Rate+SUM($I161:N161)),0))","v":-3.8600615000429168E-2},{"$f":"IF(AND(P143<$G$21,P143<=COUNTIF($J$145:$BX$145,\">0\")),-(P145*$G$131)*Tax_Rate,IF(AND(P143<=COUNTIF($J$145:$BX$145,\">0\"),P143=$G$21),-($G$131*Tax_Rate+SUM($I161:O161)),0))","v":-3.5573115784709237E-2},{"$f":"IF(AND(Q143<$G$21,Q143<=COUNTIF($J$145:$BX$145,\">0\")),-(Q145*$G$131)*Tax_Rate,IF(AND(Q143<=COUNTIF($J$145:$BX$145,\">0\"),Q143=$G$21),-($G$131*Tax_Rate+SUM($I161:P161)),0))","v":-3.4059366176849272E-2},{"$f":"IF(AND(R143<$G$21,R143<=COUNTIF($J$145:$BX$145,\">0\")),-(R145*$G$131)*Tax_Rate,IF(AND(R143<=COUNTIF($J$145:$BX$145,\">0\"),R143=$G$21),-($G$131*Tax_Rate+SUM($I161:Q161)),0))","v":-3.4059366176849272E-2},{"$f":"IF(AND(S143<$G$21,S143<=COUNTIF($J$145:$BX$145,\">0\")),-(S145*$G$131)*Tax_Rate,IF(AND(S143<=COUNTIF($J$145:$BX$145,\">0\"),S143=$G$21),-($G$131*Tax_Rate+SUM($I161:R161)),0))","v":-3.4059366176849272E-2},{"$f":"IF(AND(T143<$G$21,T143<=COUNTIF($J$145:$BX$145,\">0\")),-(T145*$G$131)*Tax_Rate,IF(AND(T143<=COUNTIF($J$145:$BX$145,\">0\"),T143=$G$21),-($G$131*Tax_Rate+SUM($I161:S161)),0))","v":-3.4059366176849272E-2},{"$f":"IF(AND(U143<$G$21,U143<=COUNTIF($J$145:$BX$145,\">0\")),-(U145*$G$131)*Tax_Rate,IF(AND(U143<=COUNTIF($J$145:$BX$145,\">0\"),U143=$G$21),-($G$131*Tax_Rate+SUM($I161:T161)),0))","v":-3.4059366176849272E-2},{"$f":"IF(AND(V143<$G$21,V143<=COUNTIF($J$145:$BX$145,\">0\")),-(V145*$G$131)*Tax_Rate,IF(AND(V143<=COUNTIF($J$145:$BX$145,\">0\"),V143=$G$21),-($G$131*Tax_Rate+SUM($I161:U161)),0))","v":-3.4059366176849272E-2},{"$f":"IF(AND(W143<$G$21,W143<=COUNTIF($J$145:$BX$145,\">0\")),-(W145*$G$131)*Tax_Rate,IF(AND(W143<=COUNTIF($J$145:$BX$145,\">0\"),W143=$G$21),-($G$131*Tax_Rate+SUM($I161:V161)),0))","v":-3.4059366176849272E-2},{"$f":"IF(AND(X143<$G$21,X143<=COUNTIF($J$145:$BX$145,\">0\")),-(X145*$G$131)*Tax_Rate,IF(AND(X143<=COUNTIF($J$145:$BX$145,\">0\"),X143=$G$21),-($G$131*Tax_Rate+SUM($I161:W161)),0))","v":-3.4059366176849272E-2},{"$f":"IF(AND(Y143<$G$21,Y143<=COUNTIF($J$145:$BX$145,\">0\")),-(Y145*$G$131)*Tax_Rate,IF(AND(Y143<=COUNTIF($J$145:$BX$145,\">0\"),Y143=$G$21),-($G$131*Tax_Rate+SUM($I161:X161)),0))","v":-3.4059366176849272E-2},{"$f":"IF(AND(Z143<$G$21,Z143<=COUNTIF($J$145:$BX$145,\">0\")),-(Z145*$G$131)*Tax_Rate,IF(AND(Z143<=COUNTIF($J$145:$BX$145,\">0\"),Z143=$G$21),-($G$131*Tax_Rate+SUM($I161:Y161)),0))","v":-3.4059366176849272E-2},{"$f":"IF(AND(AA143<$G$21,AA143<=COUNTIF($J$145:$BX$145,\">0\")),-(AA145*$G$131)*Tax_Rate,IF(AND(AA143<=COUNTIF($J$145:$BX$145,\">0\"),AA143=$G$21),-($G$131*Tax_Rate+SUM($I161:Z161)),0))","v":-3.4059366176849272E-2},{"$f":"IF(AND(AB143<$G$21,AB143<=COUNTIF($J$145:$BX$145,\">0\")),-(AB145*$G$131)*Tax_Rate,IF(AND(AB143<=COUNTIF($J$145:$BX$145,\">0\"),AB143=$G$21),-($G$131*Tax_Rate+SUM($I161:AA161)),0))","v":-3.4059366176849272E-2},{"$f":"IF(AND(AC143<$G$21,AC143<=COUNTIF($J$145:$BX$145,\">0\")),-(AC145*$G$131)*Tax_Rate,IF(AND(AC143<=COUNTIF($J$145:$BX$145,\">0\"),AC143=$G$21),-($G$131*Tax_Rate+SUM($I161:AB161)),0))","v":-2.9896554755234356E-2},{"$f":"IF(AND(AD143<$G$21,AD143<=COUNTIF($J$145:$BX$145,\">0\")),-(AD145*$G$131)*Tax_Rate,IF(AND(AD143<=COUNTIF($J$145:$BX$145,\">0\"),AD143=$G$21),-($G$131*Tax_Rate+SUM($I161:AC161)),0))","v":0},{"$f":"IF(AND(AE143<$G$21,AE143<=COUNTIF($J$145:$BX$145,\">0\")),-(AE145*$G$131)*Tax_Rate,IF(AND(AE143<=COUNTIF($J$145:$BX$145,\">0\"),AE143=$G$21),-($G$131*Tax_Rate+SUM($I161:AD161)),0))","v":0},{"$f":"IF(AND(AF143<$G$21,AF143<=COUNTIF($J$145:$BX$145,\">0\")),-(AF145*$G$131)*Tax_Rate,IF(AND(AF143<=COUNTIF($J$145:$BX$145,\">0\"),AF143=$G$21),-($G$131*Tax_Rate+SUM($I161:AE161)),0))","v":0},{"$f":"IF(AND(AG143<$G$21,AG143<=COUNTIF($J$145:$BX$145,\">0\")),-(AG145*$G$131)*Tax_Rate,IF(AND(AG143<=COUNTIF($J$145:$BX$145,\">0\"),AG143=$G$21),-($G$131*Tax_Rate+SUM($I161:AF161)),0))","v":0},{"$f":"IF(AND(AH143<$G$21,AH143<=COUNTIF($J$145:$BX$145,\">0\")),-(AH145*$G$131)*Tax_Rate,IF(AND(AH143<=COUNTIF($J$145:$BX$145,\">0\"),AH143=$G$21),-($G$131*Tax_Rate+SUM($I161:AG161)),0))","v":0},{"$f":"IF(AND(AI143<$G$21,AI143<=COUNTIF($J$145:$BX$145,\">0\")),-(AI145*$G$131)*Tax_Rate,IF(AND(AI143<=COUNTIF($J$145:$BX$145,\">0\"),AI143=$G$21),-($G$131*Tax_Rate+SUM($I161:AH161)),0))","v":0},{"$f":"IF(AND(AJ143<$G$21,AJ143<=COUNTIF($J$145:$BX$145,\">0\")),-(AJ145*$G$131)*Tax_Rate,IF(AND(AJ143<=COUNTIF($J$145:$BX$145,\">0\"),AJ143=$G$21),-($G$131*Tax_Rate+SUM($I161:AI161)),0))","v":0},{"$f":"IF(AND(AK143<$G$21,AK143<=COUNTIF($J$145:$BX$145,\">0\")),-(AK145*$G$131)*Tax_Rate,IF(AND(AK143<=COUNTIF($J$145:$BX$145,\">0\"),AK143=$G$21),-($G$131*Tax_Rate+SUM($I161:AJ161)),0))","v":0},{"$f":"IF(AND(AL143<$G$21,AL143<=COUNTIF($J$145:$BX$145,\">0\")),-(AL145*$G$131)*Tax_Rate,IF(AND(AL143<=COUNTIF($J$145:$BX$145,\">0\"),AL143=$G$21),-($G$131*Tax_Rate+SUM($I161:AK161)),0))","v":0},{"$f":"IF(AND(AM143<$G$21,AM143<=COUNTIF($J$145:$BX$145,\">0\")),-(AM145*$G$131)*Tax_Rate,IF(AND(AM143<=COUNTIF($J$145:$BX$145,\">0\"),AM143=$G$21),-($G$131*Tax_Rate+SUM($I161:AL161)),0))","v":0},{"$f":"IF(AND(AN143<$G$21,AN143<=COUNTIF($J$145:$BX$145,\">0\")),-(AN145*$G$131)*Tax_Rate,IF(AND(AN143<=COUNTIF($J$145:$BX$145,\">0\"),AN143=$G$21),-($G$131*Tax_Rate+SUM($I161:AM161)),0))","v":0},{"$f":"IF(AND(AO143<$G$21,AO143<=COUNTIF($J$145:$BX$145,\">0\")),-(AO145*$G$131)*Tax_Rate,IF(AND(AO143<=COUNTIF($J$145:$BX$145,\">0\"),AO143=$G$21),-($G$131*Tax_Rate+SUM($I161:AN161)),0))","v":0},{"$f":"IF(AND(AP143<$G$21,AP143<=COUNTIF($J$145:$BX$145,\">0\")),-(AP145*$G$131)*Tax_Rate,IF(AND(AP143<=COUNTIF($J$145:$BX$145,\">0\"),AP143=$G$21),-($G$131*Tax_Rate+SUM($I161:AO161)),0))","v":0},{"$f":"IF(AND(AQ143<$G$21,AQ143<=COUNTIF($J$145:$BX$145,\">0\")),-(AQ145*$G$131)*Tax_Rate,IF(AND(AQ143<=COUNTIF($J$145:$BX$145,\">0\"),AQ143=$G$21),-($G$131*Tax_Rate+SUM($I161:AP161)),0))","v":0},{"$f":"IF(AND(AR143<$G$21,AR143<=COUNTIF($J$145:$BX$145,\">0\")),-(AR145*$G$131)*Tax_Rate,IF(AND(AR143<=COUNTIF($J$145:$BX$145,\">0\"),AR143=$G$21),-($G$131*Tax_Rate+SUM($I161:AQ161)),0))","v":0},{"$f":"IF(AND(AS143<$G$21,AS143<=COUNTIF($J$145:$BX$145,\">0\")),-(AS145*$G$131)*Tax_Rate,IF(AND(AS143<=COUNTIF($J$145:$BX$145,\">0\"),AS143=$G$21),-($G$131*Tax_Rate+SUM($I161:AR161)),0))","v":0},{"$f":"IF(AND(AT143<$G$21,AT143<=COUNTIF($J$145:$BX$145,\">0\")),-(AT145*$G$131)*Tax_Rate,IF(AND(AT143<=COUNTIF($J$145:$BX$145,\">0\"),AT143=$G$21),-($G$131*Tax_Rate+SUM($I161:AS161)),0))","v":0},{"$f":"IF(AND(AU143<$G$21,AU143<=COUNTIF($J$145:$BX$145,\">0\")),-(AU145*$G$131)*Tax_Rate,IF(AND(AU143<=COUNTIF($J$145:$BX$145,\">0\"),AU143=$G$21),-($G$131*Tax_Rate+SUM($I161:AT161)),0))","v":0},{"$f":"IF(AND(AV143<$G$21,AV143<=COUNTIF($J$145:$BX$145,\">0\")),-(AV145*$G$131)*Tax_Rate,IF(AND(AV143<=COUNTIF($J$145:$BX$145,\">0\"),AV143=$G$21),-($G$131*Tax_Rate+SUM($I161:AU161)),0))","v":0},{"$f":"IF(AND(AW143<$G$21,AW143<=COUNTIF($J$145:$BX$145,\">0\")),-(AW145*$G$131)*Tax_Rate,IF(AND(AW143<=COUNTIF($J$145:$BX$145,\">0\"),AW143=$G$21),-($G$131*Tax_Rate+SUM($I161:AV161)),0))","v":0},{"$f":"IF(AND(AX143<$G$21,AX143<=COUNTIF($J$145:$BX$145,\">0\")),-(AX145*$G$131)*Tax_Rate,IF(AND(AX143<=COUNTIF($J$145:$BX$145,\">0\"),AX143=$G$21),-($G$131*Tax_Rate+SUM($I161:AW161)),0))","v":0},{"$f":"IF(AND(AY143<$G$21,AY143<=COUNTIF($J$145:$BX$145,\">0\")),-(AY145*$G$131)*Tax_Rate,IF(AND(AY143<=COUNTIF($J$145:$BX$145,\">0\"),AY143=$G$21),-($G$131*Tax_Rate+SUM($I161:AX161)),0))","v":0},{"$f":"IF(AND(AZ143<$G$21,AZ143<=COUNTIF($J$145:$BX$145,\">0\")),-(AZ145*$G$131)*Tax_Rate,IF(AND(AZ143<=COUNTIF($J$145:$BX$145,\">0\"),AZ143=$G$21),-($G$131*Tax_Rate+SUM($I161:AY161)),0))","v":0},{"$f":"IF(AND(BA143<$G$21,BA143<=COUNTIF($J$145:$BX$145,\">0\")),-(BA145*$G$131)*Tax_Rate,IF(AND(BA143<=COUNTIF($J$145:$BX$145,\">0\"),BA143=$G$21),-($G$131*Tax_Rate+SUM($I161:AZ161)),0))","v":0},{"$f":"IF(AND(BB143<$G$21,BB143<=COUNTIF($J$145:$BX$145,\">0\")),-(BB145*$G$131)*Tax_Rate,IF(AND(BB143<=COUNTIF($J$145:$BX$145,\">0\"),BB143=$G$21),-($G$131*Tax_Rate+SUM($I161:BA161)),0))","v":0},{"$f":"IF(AND(BC143<$G$21,BC143<=COUNTIF($J$145:$BX$145,\">0\")),-(BC145*$G$131)*Tax_Rate,IF(AND(BC143<=COUNTIF($J$145:$BX$145,\">0\"),BC143=$G$21),-($G$131*Tax_Rate+SUM($I161:BB161)),0))","v":0},{"$f":"IF(AND(BD143<$G$21,BD143<=COUNTIF($J$145:$BX$145,\">0\")),-(BD145*$G$131)*Tax_Rate,IF(AND(BD143<=COUNTIF($J$145:$BX$145,\">0\"),BD143=$G$21),-($G$131*Tax_Rate+SUM($I161:BC161)),0))","v":0},{"$f":"IF(AND(BE143<$G$21,BE143<=COUNTIF($J$145:$BX$145,\">0\")),-(BE145*$G$131)*Tax_Rate,IF(AND(BE143<=COUNTIF($J$145:$BX$145,\">0\"),BE143=$G$21),-($G$131*Tax_Rate+SUM($I161:BD161)),0))","v":0},{"$f":"IF(AND(BF143<$G$21,BF143<=COUNTIF($J$145:$BX$145,\">0\")),-(BF145*$G$131)*Tax_Rate,IF(AND(BF143<=COUNTIF($J$145:$BX$145,\">0\"),BF143=$G$21),-($G$131*Tax_Rate+SUM($I161:BE161)),0))","v":0},{"$f":"IF(AND(BG143<$G$21,BG143<=COUNTIF($J$145:$BX$145,\">0\")),-(BG145*$G$131)*Tax_Rate,IF(AND(BG143<=COUNTIF($J$145:$BX$145,\">0\"),BG143=$G$21),-($G$131*Tax_Rate+SUM($I161:BF161)),0))","v":0},{"$f":"IF(AND(BH143<$G$21,BH143<=COUNTIF($J$145:$BX$145,\">0\")),-(BH145*$G$131)*Tax_Rate,IF(AND(BH143<=COUNTIF($J$145:$BX$145,\">0\"),BH143=$G$21),-($G$131*Tax_Rate+SUM($I161:BG161)),0))","v":0},{"$f":"IF(AND(BI143<$G$21,BI143<=COUNTIF($J$145:$BX$145,\">0\")),-(BI145*$G$131)*Tax_Rate,IF(AND(BI143<=COUNTIF($J$145:$BX$145,\">0\"),BI143=$G$21),-($G$131*Tax_Rate+SUM($I161:BH161)),0))","v":0},{"$f":"IF(AND(BJ143<$G$21,BJ143<=COUNTIF($J$145:$BX$145,\">0\")),-(BJ145*$G$131)*Tax_Rate,IF(AND(BJ143<=COUNTIF($J$145:$BX$145,\">0\"),BJ143=$G$21),-($G$131*Tax_Rate+SUM($I161:BI161)),0))","v":0},{"$f":"IF(AND(BK143<$G$21,BK143<=COUNTIF($J$145:$BX$145,\">0\")),-(BK145*$G$131)*Tax_Rate,IF(AND(BK143<=COUNTIF($J$145:$BX$145,\">0\"),BK143=$G$21),-($G$131*Tax_Rate+SUM($I161:BJ161)),0))","v":0},{"$f":"IF(AND(BL143<$G$21,BL143<=COUNTIF($J$145:$BX$145,\">0\")),-(BL145*$G$131)*Tax_Rate,IF(AND(BL143<=COUNTIF($J$145:$BX$145,\">0\"),BL143=$G$21),-($G$131*Tax_Rate+SUM($I161:BK161)),0))","v":0},{"$f":"IF(AND(BM143<$G$21,BM143<=COUNTIF($J$145:$BX$145,\">0\")),-(BM145*$G$131)*Tax_Rate,IF(AND(BM143<=COUNTIF($J$145:$BX$145,\">0\"),BM143=$G$21),-($G$131*Tax_Rate+SUM($I161:BL161)),0))","v":0},{"$f":"IF(AND(BN143<$G$21,BN143<=COUNTIF($J$145:$BX$145,\">0\")),-(BN145*$G$131)*Tax_Rate,IF(AND(BN143<=COUNTIF($J$145:$BX$145,\">0\"),BN143=$G$21),-($G$131*Tax_Rate+SUM($I161:BM161)),0))","v":0},{"$f":"IF(AND(BO143<$G$21,BO143<=COUNTIF($J$145:$BX$145,\">0\")),-(BO145*$G$131)*Tax_Rate,IF(AND(BO143<=COUNTIF($J$145:$BX$145,\">0\"),BO143=$G$21),-($G$131*Tax_Rate+SUM($I161:BN161)),0))","v":0},{"$f":"IF(AND(BP143<$G$21,BP143<=COUNTIF($J$145:$BX$145,\">0\")),-(BP145*$G$131)*Tax_Rate,IF(AND(BP143<=COUNTIF($J$145:$BX$145,\">0\"),BP143=$G$21),-($G$131*Tax_Rate+SUM($I161:BO161)),0))","v":0},{"$f":"IF(AND(BQ143<$G$21,BQ143<=COUNTIF($J$145:$BX$145,\">0\")),-(BQ145*$G$131)*Tax_Rate,IF(AND(BQ143<=COUNTIF($J$145:$BX$145,\">0\"),BQ143=$G$21),-($G$131*Tax_Rate+SUM($I161:BP161)),0))","v":0},{"$f":"IF(AND(BR143<$G$21,BR143<=COUNTIF($J$145:$BX$145,\">0\")),-(BR145*$G$131)*Tax_Rate,IF(AND(BR143<=COUNTIF($J$145:$BX$145,\">0\"),BR143=$G$21),-($G$131*Tax_Rate+SUM($I161:BQ161)),0))","v":0},{"$f":"IF(AND(BS143<$G$21,BS143<=COUNTIF($J$145:$BX$145,\">0\")),-(BS145*$G$131)*Tax_Rate,IF(AND(BS143<=COUNTIF($J$145:$BX$145,\">0\"),BS143=$G$21),-($G$131*Tax_Rate+SUM($I161:BR161)),0))","v":0},{"$f":"IF(AND(BT143<$G$21,BT143<=COUNTIF($J$145:$BX$145,\">0\")),-(BT145*$G$131)*Tax_Rate,IF(AND(BT143<=COUNTIF($J$145:$BX$145,\">0\"),BT143=$G$21),-($G$131*Tax_Rate+SUM($I161:BS161)),0))","v":0},{"$f":"IF(AND(BU143<$G$21,BU143<=COUNTIF($J$145:$BX$145,\">0\")),-(BU145*$G$131)*Tax_Rate,IF(AND(BU143<=COUNTIF($J$145:$BX$145,\">0\"),BU143=$G$21),-($G$131*Tax_Rate+SUM($I161:BT161)),0))","v":0},{"$f":"IF(AND(BV143<$G$21,BV143<=COUNTIF($J$145:$BX$145,\">0\")),-(BV145*$G$131)*Tax_Rate,IF(AND(BV143<=COUNTIF($J$145:$BX$145,\">0\"),BV143=$G$21),-($G$131*Tax_Rate+SUM($I161:BU161)),0))","v":0},{"$f":"IF(AND(BW143<$G$21,BW143<=COUNTIF($J$145:$BX$145,\">0\")),-(BW145*$G$131)*Tax_Rate,IF(AND(BW143<=COUNTIF($J$145:$BX$145,\">0\"),BW143=$G$21),-($G$131*Tax_Rate+SUM($I161:BV161)),0))","v":0},{"$f":"IF(AND(BX143<$G$21,BX143<=COUNTIF($J$145:$BX$145,\">0\")),-(BX145*$G$131)*Tax_Rate,IF(AND(BX143<=COUNTIF($J$145:$BX$145,\">0\"),BX143=$G$21),-($G$131*Tax_Rate+SUM($I161:BW161)),0))","v":0}]
[{"$f":"ROW()","v":162},"Salvage Value (or Site Restoration Cost)",null,null,null,null,null,null,null,{"$f":"-J148*(1-Tax_Rate)","v":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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,15.612518614007502,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"-BV148*(1-Tax_Rate)","v":0},{"$f":"-BW148*(1-Tax_Rate)","v":0},{"$f":"-BX148*(1-Tax_Rate)","v":0}]
[{"$f":"ROW()","v":163},"Nuclear Decommissioning Cost",null,null,null,null,null,null,null,{"$f":"J149*(1-Tax_Rate)","v":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,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,0,0,{"$f":"BV149*(1-Tax_Rate)","v":0},{"$f":"BW149*(1-Tax_Rate)","v":0},{"$f":"BX149*(1-Tax_Rate)","v":0}]
[{"$f":"ROW()","v":164}]
[{"$f":"ROW()","v":165}]
[{"$f":"ROW()","v":166}]
[{"$f":"ROW()","v":167},"Property Tax  (if Nuclear case, may be fixed input)",null,null,null,null,null,null,null,{"$f":"J150*(1-Tax_Rate)","v":0.7975436964669067},0.78190558477147709,0.76626747307604759,0.75062936138061798,0.73499124968518847,0.71935313798975897,0.70371502629432936,0.68807691459889975,0.67243880290347025,0.65680069120804074,0.64116257951261124,0.62552446781718163,0.60988635612175213,0.59424824442632251,0.57861013273089301,0.5629720210354634,0.54733390934003401,0.5316957976446044,0.516057685949175,0.50041957425374528,0.48478146255831583,0.46914335086288633,0.45350523916745678,0.43786712747202733,0.42222901577659772,0.40659090408116827,0.39095279238573871,0.37531468069030921,0.35967656899487971,0.34403845729945015,0.32840034560402065,0.31276223390859115,0.29712412221316153,0.28148601051773203,0.26584789882230253,0.25020978712687297,0.23457167543144347,0.21893356373601394,0.20329545204058441,0.18765734034515491,0.17201922864972538,0.15638111695429585,0.14074300525886632,0.12510489356343682,0.1094667818680073,9.3828670172577788E-2,7.8190558477148259E-2,6.2552446781718743E-2,4.6914335086289213E-2,3.1276223390859698E-2,1.5638111695430175E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BV150*(1-Tax_Rate)","v":0},0,0]
[{"$f":"ROW()","v":168},"Insurance",null,null,null,null,null,null,null,3.4246059579825454E-2,3.5102211069321092E-2,3.5979766346054119E-2,3.6879260504705469E-2,3.78012420173231E-2,3.8746273067756173E-2,3.9714929894450079E-2,4.0707803141811327E-2,4.1725498220356608E-2,4.2768635675865516E-2,4.3837851567762154E-2,4.4933797856956205E-2,4.6057142803380108E-2,4.7208571373464604E-2,4.8388785657801213E-2,4.9598505299246247E-2,5.0838467931727395E-2,5.2109429630020576E-2,5.3412165370771078E-2,5.4747469505040357E-2,5.611615624266636E-2,5.7519060148733016E-2,5.8957036652451333E-2,6.0430962568762618E-2,6.1941736632981678E-2,6.3490280048806219E-2,6.5077537050026363E-2,6.6704475476277017E-2,6.8372087363183939E-2,7.0081389547263534E-2,7.1833424285945108E-2,7.3629259893093726E-2,7.5469991390421057E-2,7.7356741175181584E-2,7.9290659704561117E-2,8.1272926197175133E-2,8.330474935210451E-2,8.5387368085907106E-2,8.7522052288054777E-2,8.9710103595256135E-2,9.195285618513753E-2,9.4251677589765964E-2,9.660796952951009E-2,9.9023168767747846E-2,0.10149874798694154,0.10403621668661507,0.10663712210378043,0.10930305015637493,0.11203562641028429,0.11483651707054138,0.11770742999730491,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"ROW()","v":169},"  Total Service Period Cost Cash Flows (AT)",null,null,null,null,null,null,null,{"$f":"SUM(J157:J168)","v":-1.0684090504832422},{"$f":"SUM(K157:K168)","v":-0.96763838056235363},-0.8540071257290246,-0.74035393201377719,-0.63951743206976697,-0.551497063713143,-0.46345306958025828,-0.42674158352751668,-0.44136200014440091,-0.45595697438432148,-0.47052587018785436,-0.4850680355940899,-0.49958280234309549,-0.51406948546844067,-0.52852738287953349,-0.5429557749335181,-0.55735392399646633,-0.57172107399360272,-0.58605644994828165,-0.45912826513221422,0.54089761880098219,0.52666241101161937,0.51246227581990811,0.49829809004078995,0.48417075240957941,0.47008118412997446,0.45603032943576505,0.44201915616658621,0.42804865635806366,0.41411984684671366,0.40023376988996573,0.38639149380168486,0.37259411360358258,0.35884275169291363,0.34513855852686365,0.33148271332404811,0.317876424783548,0.30432093182192105,0.29081750432863918,0.27736744394041102,0.2639720848348629,0.25063279454406184,0.23735097478837641,0.22412806233118465,0.21096552985494885,0.19786488685919285,0.18482768058092869,0.17185549693809365,0.15894996149657351,0.14611274046140107,15.745864155700238,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(BW157:BW168)","v":0},{"$f":"SUM(BX157:BX168)","v":0}]
[{"$f":"ROW()","v":170},"  PV Service Period Cost Cash Flows (AT)",null,null,null,null,{"$f":"NPV(disc_rate,J169:BX169)","v":-5.0205713508966632}]
[{"$f":"ROW()","v":171}]
[{"$f":"ROW()","v":172},"COMBINED RESULTS",null,null,null,null,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,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67]
[{"$f":"ROW()","v":173},null,null,null,null,null,null,null,null,{"$f":"J144","v":2025},{"$f":"K144","v":2026},2027,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,2056,2057,2058,2059,2060,2061,2062,2063,2064,2065,2066,2067,2068,2069,2070,2071,2072,2073,2074,2075,2076,2077,2078,2079,2080,2081,2082,2083,2084,2085,2086,2087,2088,2089,{"$f":"BW144","v":2090},{"$f":"BX144","v":2091}]
[{"$f":"ROW()","v":174},"PV Construction + Service Period Cost CF (AT)",null,null,null,null,{"$f":"G141+G170","v":99.346084062792343}]
[{"$f":"ROW()","v":175},"PV Grossed up to Revenue Requirement",null,null,null,null,{"$f":"G174/(1-Tax_Rate)","v":132.31957794065337}]
[{"$f":"ROW()","v":176},"Equivalent Uniform Annual Revenue Requirement",null,null,null,null,{"$f":"-PMT(disc_rate,$G$21,G175)","v":9.9249370730011091}]
[{"$f":"ROW()","v":177}]
[{"$f":"ROW()","v":178},"Cash Flow Check:"]
[{"$f":"ROW()","v":179},"Service Period Cash Flow (AT)",null,null,null,null,null,null,null,{"$f":"IF(J144<=$J$144+$G$21-1,$G$176*(1-Tax_Rate)-J169,-J169)","v":8.5200926797533167},8.4193220098324275,8.3056907549990981,8.1920375612838523,8.0912010613398415,8.0031806929832179,7.9151366988503327,7.8784252127975911,7.8930456294144751,7.9076406036543956,7.9222094994579288,7.9367516648641638,7.9512664316131696,7.965753114738515,7.9802110121496082,7.9946394042035926,8.0090375532665412,8.0234047032636777,8.0377400792183558,7.9108118944022889,6.9107860104690921,6.925021218258455,6.9392213534501659,6.9533855392292843,6.9675128768604946,6.9816024451400995,6.9956532998343093,7.0096644731034878,7.0236349729120109,7.0375637824233603,7.0514498593801083,7.0652921354683897,7.0790895156664915,7.092840877577161,7.106545070743211,7.1202009159460262,7.1338072044865264,7.1473626974481537,7.1608661249414354,7.1743161853296638,7.1877115444352118,7.2010508347260123,7.2143326544816979,7.2275555669388893,7.2407180994151252,7.2538187424108811,7.2668559486891455,7.2798281323319802,7.2927336677735006,7.3055708888086732,-8.2941805264301642,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(BV144<=$J$144+$G$21-1,$G$176*(1-Tax_Rate)-BV169,-BV169)","v":0},{"$f":"IF(BW144<=$J$144+$G$21-1,$G$176*(1-Tax_Rate)-BW169,-BW169)","v":0},{"$f":"IF(BX144<=$J$144+$G$21-1,$G$176*(1-Tax_Rate)-BX169,-BX169)","v":0}]
[{"$f":"ROW()","v":180},"PV Service Period Cash Flow (AT)",null,null,null,null,{"$f":"NPV(disc_rate,J179:BX179)","v":104.36665541368895}]
[{"$f":"ROW()","v":181},"PV Construction Period Cash Flow (AT)",null,null,null,null,{"$f":"-G141","v":-104.366655413689}]
[{"$f":"ROW()","v":182},"  NPV TEST  (should equal zero)",null,null,null,null,{"$f":"SUM(G180:G181)","v":0}]
[{"$f":"ROW()","v":183}]
[{"$f":"ROW()","v":184}]
[{"$f":"ROW()","v":185}]
[{"$f":"ROW()","v":186}]
[{"$f":"ROW()","v":187},null,null,null,null,null,null,null,null,"SERVICE PERIOD"]
[{"$f":"ROW()","v":188},null,null,null,null,null,null,null,null,{"$f":"J143","v":1},{"$f":"K143","v":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,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,{"$f":"BW143","v":66},{"$f":"BX143","v":67}]
[{"$f":"ROW()","v":189},"Property Tax Basis by Region:",null,null,null,null,null,null,null,{"$f":"J144","v":2025},2026,2027,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,2056,2057,2058,2059,2060,2061,2062,2063,2064,2065,2066,2067,2068,2069,2070,2071,2072,2073,2074,2075,2076,2077,2078,2079,2080,2081,2082,2083,2084,2085,2086,2087,2088,2089,{"$f":"BW144","v":2090},{"$f":"BX144","v":2091}]
[{"$f":"ROW()","v":190}]
[{"$f":"ROW()","v":191}]
[{"$f":"ROW()","v":192},"  DEK  (net plant)",null,null,null,null,null,null,null,{"$f":"J207","v":103.97198304717971},{"$f":"K207","v":101.93331671292128},99.89465037866286,97.855984044404423,95.817317710146,93.778651375887577,91.739985041629154,89.701318707370717,87.662652373112294,85.623986038853872,83.585319704595449,81.546653370337026,79.507987036078589,77.469320701820166,75.430654367561743,73.391988033303306,71.353321699044898,69.314655364786461,67.275989030528052,65.237322696269615,63.198656362011199,61.159990027752777,59.121323693494354,57.082657359235931,55.043991024977508,53.005324690719085,50.966658356460663,48.92799202220224,46.889325687943817,44.850659353685394,42.811993019426971,40.773326685168549,38.734660350910119,36.695994016651696,34.657327682393273,32.61866134813485,30.579995013876427,28.541328679618005,26.502662345359582,24.463996011101159,22.425329676842736,20.386663342584313,18.347997008325891,16.309330674067468,14.270664339809045,12.231998005550622,10.193331671292199,8.1546653370337765,6.1159990027753537,4.0773326685169309,2.0386663342585081,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BW207","v":0},{"$f":"BX207","v":0}]
[{"$f":"ROW()","v":193}]
[{"$f":"ROW()","v":194}]
[{"$f":"ROW()","v":195}]
[{"$f":"ROW()","v":196}]
[{"$f":"ROW()","v":197}]
[{"$f":"ROW()","v":198}]
[{"$f":"ROW()","v":199}]
[{"$f":"ROW()","v":200}]
[{"$f":"ROW()","v":201}]
[{"$f":"ROW()","v":202}]
[{"$f":"ROW()","v":203}]
[{"$f":"ROW()","v":204},"For DEK:  Property Tax Basis"]
[{"$f":"ROW()","v":205},"  Book Depreciation",null,null,null,null,null,null,null,{"$f":"IF(J143<=$G21,$G125/$G21,0)","v":2.0386663342584255},{"$f":"IF(K143<=$G21,$G125/$G21,0)","v":2.0386663342584255},2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,2.0386663342584255,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(BW143<=$G21,$G125/$G21,0)","v":0},{"$f":"IF(BX143<=$G21,$G125/$G21,0)","v":0}]
[{"$f":"ROW()","v":206},"  Accumulated Book Depreciation",null,null,null,null,null,null,null,{"$f":"I206+I205","v":0},{"$f":"J206+J205","v":2.0386663342584255},4.0773326685168509,6.1159990027752764,8.1546653370337019,10.193331671292128,12.231998005550555,14.270664339808981,16.309330674067407,18.347997008325834,20.38666334258426,22.425329676842686,24.463996011101113,26.502662345359539,28.541328679617965,30.579995013876392,32.618661348134815,34.657327682393237,36.69599401665166,38.734660350910083,40.773326685168506,42.811993019426929,44.850659353685352,46.889325687943774,48.927992022202197,50.96665835646062,53.005324690719043,55.043991024977466,57.082657359235888,59.121323693494311,61.159990027752734,63.198656362011157,65.237322696269587,67.275989030528009,69.314655364786432,71.353321699044855,73.391988033303278,75.430654367561701,77.469320701820124,79.507987036078546,81.546653370336969,83.585319704595392,85.623986038853815,87.662652373112238,89.70131870737066,91.739985041629083,93.778651375887506,95.817317710145929,97.855984044404352,99.894650378662774,101.9333167129212,103.97198304717962,103.97198304717962,103.97198304717962,103.97198304717962,103.97198304717962,103.97198304717962,103.97198304717962,103.97198304717962,103.97198304717962,103.97198304717962,103.97198304717962,103.97198304717962,103.97198304717962,103.97198304717962,{"$f":"BV206+BV205","v":103.97198304717962},{"$f":"BW206+BW205","v":103.97198304717962}]
[{"$f":"ROW()","v":207},"    Net Plant",null,null,null,null,null,null,null,{"$f":"G125-J206","v":103.97198304717971},{"$f":"G125-K206","v":101.93331671292128},{"$f":"G125-L206","v":99.89465037866286},{"$f":"G125-M206","v":97.855984044404423},{"$f":"G125-N206","v":95.817317710146},{"$f":"G125-O206","v":93.778651375887577},{"$f":"G125-P206","v":91.739985041629154},{"$f":"G125-Q206","v":89.701318707370717},{"$f":"G125-R206","v":87.662652373112294},{"$f":"G125-S206","v":85.623986038853872},{"$f":"G125-T206","v":83.585319704595449},{"$f":"G125-U206","v":81.546653370337026},{"$f":"G125-V206","v":79.507987036078589},{"$f":"G125-W206","v":77.469320701820166},{"$f":"G125-X206","v":75.430654367561743},{"$f":"G125-Y206","v":73.391988033303306},{"$f":"G125-Z206","v":71.353321699044898},{"$f":"G125-AA206","v":69.314655364786461},{"$f":"G125-AB206","v":67.275989030528052},{"$f":"G125-AC206","v":65.237322696269615},{"$f":"G125-AD206","v":63.198656362011199},{"$f":"G125-AE206","v":61.159990027752777},{"$f":"G125-AF206","v":59.121323693494354},{"$f":"G125-AG206","v":57.082657359235931},{"$f":"G125-AH206","v":55.043991024977508},{"$f":"G125-AI206","v":53.005324690719085},{"$f":"G125-AJ206","v":50.966658356460663},{"$f":"G125-AK206","v":48.92799202220224},{"$f":"G125-AL206","v":46.889325687943817},{"$f":"G125-AM206","v":44.850659353685394},{"$f":"G125-AN206","v":42.811993019426971},{"$f":"G125-AO206","v":40.773326685168549},{"$f":"G125-AP206","v":38.734660350910119},{"$f":"G125-AQ206","v":36.695994016651696},{"$f":"G125-AR206","v":34.657327682393273},{"$f":"G125-AS206","v":32.61866134813485},{"$f":"G125-AT206","v":30.579995013876427},{"$f":"G125-AU206","v":28.541328679618005},{"$f":"G125-AV206","v":26.502662345359582},{"$f":"G125-AW206","v":24.463996011101159},{"$f":"G125-AX206","v":22.425329676842736},{"$f":"G125-AY206","v":20.386663342584313},{"$f":"G125-AZ206","v":18.347997008325891},{"$f":"G125-BA206","v":16.309330674067468},{"$f":"G125-BB206","v":14.270664339809045},{"$f":"G125-BC206","v":12.231998005550622},{"$f":"G125-BD206","v":10.193331671292199},{"$f":"G125-BE206","v":8.1546653370337765},{"$f":"G125-BF206","v":6.1159990027753537},{"$f":"G125-BG206","v":4.0773326685169309},{"$f":"G125-BH206","v":2.0386663342585081},{"$f":"G125-BI206","v":0},{"$f":"G125-BJ206","v":0},{"$f":"G125-BK206","v":0},{"$f":"G125-BL206","v":0},{"$f":"G125-BM206","v":0},{"$f":"G125-BN206","v":0},{"$f":"G125-BO206","v":0},{"$f":"G125-BP206","v":0},{"$f":"G125-BQ206","v":0},{"$f":"G125-BR206","v":0},{"$f":"G125-BS206","v":0},{"$f":"G125-BT206","v":0},{"$f":"G125-BU206","v":0},{"$f":"G125-BV206","v":0},{"$f":"G125-BW206","v":0},{"$f":"G125-BX206","v":0}]
[{"$f":"ROW()","v":208}]
[{"$f":"ROW()","v":209}]
[{"$f":"ROW()","v":210}]
[{"$f":"ROW()","v":211}]
[{"$f":"ROW()","v":212}]
[{"$f":"ROW()","v":213}]
[{"$f":"ROW()","v":214}]
[{"$f":"ROW()","v":215}]
[{"$f":"ROW()","v":216}]
[{"$f":"ROW()","v":217}]
[{"$f":"ROW()","v":218}]
[{"$f":"ROW()","v":219}]
[{"$f":"ROW()","v":220}]
[{"$f":"ROW()","v":221}]
[{"$f":"ROW()","v":222}]
[{"$f":"ROW()","v":223}]
[{"$f":"ROW()","v":224}]
[{"$f":"ROW()","v":225}]
[{"$f":"ROW()","v":226}]
[{"$f":"ROW()","v":227}]
[{"$f":"ROW()","v":228}]