{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Contents","Demand and Solar","LCOE Analysis","Detailed LCOE Calculator","Sensitivity","Waterfall Chart"],"not_rendered":{"charts":6,"images":0,"macros":1,"external_links":0,"defined_names":34,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Waterfall Chart","index":5,"reason":"not_a_worksheet"}],"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":"Contents","index":0,"n_rows":22,"n_cols":13,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Contents"]
[null,null,null,null,null," Colour Codes ",null,null,null,null," File Name: ",null,{"$f":"IFERROR(File_name(),\"\")","v":""}]
[null,null,"Demand and Solar",null,null,null," Inputs ",null,"1234567890"]
[null,null,null,"Demand",null,null," Section Titles ",null,"TITLE ROW",null," Last Save Date ",null,{"$f":"IFERROR(lastsaved(),\"\")","v":""}]
[null,null,null,"Solar Supply",null,null," Sum Column ",null,"1000000000"]
[null,null,null,null,null,null," True or 1 ",null,{"$f":"1=1","v":true},null," Last Save By",null,{"$f":"IFERROR(last_save_by(),\"\")","v":""}]
[null,null,"Battery Costs",null,null,null," False or 0 ",null,{"$f":"1=2","v":false}]
[null,null,null,"Production",null,null," Other Sheet Links ",null,"|||||||||||||||||||"]
[null,null,null,"Capital Expenditures"]
[null,null,null,"Operating Expense"]
[null,null,null,"Carrying Charges"]
[]
[null,null,"Detailed LCOE Calculator"]
[null,null,null,"Production"]
[null,null,null,"Real LCOE"]
[null,null,null,"Carrying Charge Analysis"]
[null,null,null,"Capital Expenditures"]
[null,null,null,"Operating Expense"]
[null,null,null,"Carrying Charges"]
[null,null,null,"LCOE Calculation"]
[null,null,null,"Financing Assumptions"]

{"sheet":"Demand and Solar","index":1,"n_rows":38,"n_cols":28,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["          "]
[null,"Demand"]
[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]
[null,null,"Load","MW",null,null,null,null,null,100,100,100,100,100,100,100,100,100,100,100,100]
[null,null,"Solar","MW",null,null,null,null,null,null,null,null,100,100,100,100,100,100]
[null,null,"Non-Solar Need","MW",null,null,null,null,null,{"$f":"J4-J5","v":100},{"$f":"K4-K5","v":100},100,0,{"$f":"N4-N5","v":0},{"$f":"O4-O5","v":0},{"$f":"P4-P5","v":0},{"$f":"Q4-Q5","v":0},{"$f":"R4-R5","v":0},{"$f":"S4-S5","v":100},{"$f":"T4-T5","v":100},{"$f":"U4-U5","v":100}]
[]
[null,"Solar Supply"]
[null,null,null,null,{"$f":"E3","v":1},{"$f":"F3","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,{"$f":"V3","v":18},19,20,21,22,23,24]
[null,null,"Solar",null,{"$f":"E5","v":0},{"$f":"F5","v":0},0,0,0,0,0,0,100,100,100,100,100,100,0,0,0,{"$f":"V5","v":0},0,0,0,0,0,0]
[null,null,"Non-Solar Need",null,{"$f":"E6","v":0},{"$f":"F6","v":0},0,0,0,100,100,100,0,0,0,0,0,0,100,100,100,{"$f":"V6","v":0},0,0,0,0,0,0]
[]
[]
[null,null,null,null,{"$f":"E9","v":1},{"$f":"F9","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
[null,null,"Solar for Demand",null,{"$f":"E10","v":0},{"$f":"F10","v":0},0,0,0,0,0,0,100,100,100,100,100,100,0,0,0,0,0,0,0,0,0,0]
[null,null,"Solar for Charging",null,{"$f":"E10","v":0},{"$f":"F10","v":0},0,0,0,0,0,0,100,100,100,100,100,100,0,0,0,0,0,0,0,0,0,0]
[null,null,"Battery Discharge",null,{"$f":"E11","v":0},{"$f":"F11","v":0},0,0,0,100,100,100,0,0,0,0,0,0,100,100,100,0,0,0,0,0,0,0]
[]
[]
[]
[null,"s"]
[]
[null,null,null,null,null,null,null,null,null,null,"How do we fill in the red area"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Fill in with extra solar and use battery to move"]

{"sheet":"LCOE Analysis","index":2,"n_rows":59,"n_cols":12,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
["          ",null,null,null,null,null,null,"Fuel Cost/MMBTU",12]
[]
[null,null,null,null,"Load Required","Solar for Load","Battery","Added Solar to Charge Battery","Thermal for Non Solar","All Thermal","Solar + Battery","Solar + Thermal"]
[null,null,"Real LCOE - USD/MWH",null,null,{"$f":"F59","v":46.451655059433975},null,null,null,{"$f":"J59","v":100.0773810751174},{"$f":"K59","v":142.76378692856318},{"$f":"L59","v":81.148374110777794}]
[]
[null,"Production"]
[null,null,"Load for Each Hour","MW",100]
[null,null,"Solar Hours","Hrs per Day",6]
[null,null,"Solar MWH","MWH per Day",{"$f":"E7*E8","v":600}]
[]
[null,null,"Battery Discharge Hours","Hrs per Day",4]
[null,null,"Total Hours of Electricity","Hrs per Day",{"$f":"E8+E11","v":10}]
[]
[null,null,"Round Trip Efficiency of Battery","%",null,null,{"$f":"Sensitivity!J19","v":0.8}]
[null,null,"Depth of Discharge","%",null,null,{"$f":"Sensitivity!K19","v":0.9}]
[]
[null,null,"MW of Capacity",null,null,{"$f":"E7","v":100},{"$f":"E7","v":100},{"$f":"F17/(G14*G15)","v":138.88888888888889},{"$f":"E7","v":100},{"$f":"I17","v":100}]
[null,null,"Percent of Day (Capacity Factor)","%",null,{"$f":"E9/24/E7","v":0.25},{"$f":"E11/24","v":0.16666666666666666},{"$f":"G18","v":0.16666666666666666},{"$f":"H18","v":0.16666666666666666},{"$f":"E12/24","v":0.41666666666666669}]
[null,null,"Annual Yield (CF x 8760)","MWH/MWp",null,{"$f":"F18*8760","v":2190},{"$f":"G18*8760","v":1460},{"$f":"H18*8760","v":1460},{"$f":"I18*8760","v":1460},{"$f":"J18*8760","v":3650}]
[null,null,"Annual Energy","MWH",null,{"$f":"F19*F17","v":219000},{"$f":"G19*G17","v":146000},202777.77777777778,146000,365000]
[null,null,"Storage Hours","Hours",null,null,{"$f":"E11","v":4}]
[null,null,"Total Battery Capacity Storage","MWH  ",null,null,{"$f":"G21*G17","v":400}]
[]
[null,"Capital Expenditures"]
[null,null,"Cost per kW","USD per kW",null,{"$f":"Sensitivity!L19","v":850},null,{"$f":"F25","v":850},{"$f":"J25","v":800},800]
[null,null,"Cost per kWh","USD per kWh",null,null,{"$f":"Sensitivity!D19","v":350}]
[]
[null,null,"Capital Expenditure to LCOE Calculator","USD",null,{"$f":"F25*F17*1000+F26*F22*1000","v":85000000},{"$f":"G25*G17*1000+G26*G22*1000","v":140000000},118055555.55555555,80000000,80000000,{"$f":"G28+H28+F28","v":343055555.55555558},{"$f":"F28+I28","v":165000000}]
[]
[null,"Operating Expense"]
[null,null,"Operating Expense Percent","%",null,null,{"$f":"Sensitivity!G19","v":0.02}]
[null,null,"Fixed O&M Expense","USD/kW-yr",null,{"$f":"Sensitivity!M19","v":15},null,{"$f":"F32","v":15},6,6]
[null,null,"Total Fixed O&M Expense per Year","USD/Year",null,{"$f":"F17*F32*1000","v":1500000},{"$f":"G31*G28","v":2800000},{"$f":"H17*H32*1000","v":2083333.3333333335},{"$f":"I17*I32*1000","v":600000},{"$f":"J17*J32*1000","v":600000}]
[]
[null,null,"Heat Rate for Thermal","MMBTU/MWH",null,null,null,null,6.5,6.5]
[null,null,"Fuel Cost/MMBTU","USD/MMBTU",null,null,null,null,{"$f":"I1","v":12},{"$f":"I1","v":12}]
[null,null,"Fuel Cost/MWH","USD/MWH",null,null,null,null,{"$f":"I35*I36","v":78},{"$f":"J35*J36","v":78}]
[null,null,"Total Fuel Cost","USD/Year",null,null,null,null,{"$f":"I37*I20","v":11388000},{"$f":"J37*J20","v":28470000}]
[]
[null,null,"Total O&M Cost to LCOE Calculator","USD",null,{"$f":"F33+F38","v":1500000},{"$f":"G33+G38","v":2800000},{"$f":"H33+H38","v":2083333.3333333335},{"$f":"I33+I38","v":11988000},{"$f":"J33+J38","v":29070000}]
[null,null,"O&M Cost Adjusted for Degradation","USD",null,{"$f":"'Detailed LCOE Calculator'!G61","v":1569470.738496738},{"$f":"'Detailed LCOE Calculator'!H61","v":3075943.1165286642},{"$f":"'Detailed LCOE Calculator'!I61","v":2179820.4701343584},{"$f":"'Detailed LCOE Calculator'!J61","v":11988000},{"$f":"'Detailed LCOE Calculator'!K61","v":29070000},{"$f":"F41+G41+H41","v":6825234.3251597602},{"$f":"F41+I41","v":13557470.738496738}]
[]
[null,"Carrying Charges"]
[null,null,"Life","yrs",null,{"$f":"Sensitivity!N19","v":20},{"$f":"Sensitivity!E19","v":9},{"$f":"F44","v":20},25,25]
[null,null,"Degradation","%",null,5.0000000000000001E-3,{"$f":"Sensitivity!F19","v":0.02},5.0000000000000001E-3,0,0]
[null,null,"Tax Life",null,null,5,5,5,15,15]
[null,null,"Income Tax Rate","%",null,0.3,{"$f":"F47","v":0.3},{"$f":"J47","v":0.3},{"$f":"J47","v":0.3},{"$f":"G47","v":0.3}]
[null,null,"Variable Declining Balance Factor (1-St Line)",null,null,2,2,2,2,2]
[null,null,"Debt to Captial","%",null,{"$f":"Sensitivity!I19","v":0.5},{"$f":"F49","v":0.5},{"$f":"G49","v":0.5},0.5,0.5]
[null,null,"Target Equity IRR","%",null,{"$f":"Sensitivity!H19","v":0.1},{"$f":"F50","v":0.1},0.1,0.1,0.1]
[null,null,"Cost of Debt","%",null,0.04,{"$f":"F51","v":0.04},0.04,0.04,0.04]
[null,null,"Inflation","%",null,0.02,{"$f":"F52","v":0.02},0.02,0.02,0.02]
[]
[null,null,"Real Capital Recovery from LCOE Calculator","USD per year",null,{"$f":"'Detailed LCOE Calculator'!G39","v":8603441.7195193022},{"$f":"'Detailed LCOE Calculator'!H39","v":24730881.573803023},{"$f":"'Detailed LCOE Calculator'!I39","v":11949224.610443475},{"$f":"'Detailed LCOE Calculator'!J39","v":7458244.092417853},{"$f":"'Detailed LCOE Calculator'!K39","v":7458244.092417853},{"$f":"F54+G54+H54","v":45283547.903765798},{"$f":"F54+I54","v":16061685.811937155}]
[]
[null,null,"Total Annual Production","MWH/yr",null,{"$f":"F20","v":219000},{"$f":"G20","v":146000},202777.77777777778,146000,365000,{"$f":"F56+G56","v":365000},{"$f":"J56","v":365000}]
[]
[null,null,"Total Cost","USD per year",null,{"$f":"F54+F41","v":10172912.45801604},{"$f":"G54+G41","v":27806824.690331686},{"$f":"H54+H41","v":14129045.080577834},{"$f":"I54+I41","v":19446244.092417851},{"$f":"J54+J41","v":36528244.092417851},{"$f":"K54+K41","v":52108782.228925556},{"$f":"L54+L41","v":29619156.550433893}]
[null,null,"Cost/MWH","USD/MWH",null,{"$f":"F58/F56","v":46.451655059433975},190.45770335843622,69.677482589150955,133.1934526877935,100.0773810751174,142.76378692856318,81.148374110777794]

{"sheet":"Detailed LCOE Calculator","index":3,"n_rows":89,"n_cols":11,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
["          "]
[null,null,null,null,null,null,"Solar for Load","Battery","Solar for Charge","Thermal for Storage","All Thermal"]
[null,"Production"]
[null,"Real LCOE",null,null,null,null,{"$f":"G78","v":40.272945314513542},{"$f":"H78","v":175.95096903915845},{"$f":"I78","v":60.409417971770317},{"$f":"J78","v":123.71405575976429},{"$f":"K78","v":96.285622303905711}]
[]
[null,null,"Annual Production",null,"Quantity",null,{"$f":"'LCOE Analysis'!F20","v":219000},{"$f":"'LCOE Analysis'!G20","v":146000},{"$f":"'LCOE Analysis'!H20","v":202777.77777777778},{"$f":"'LCOE Analysis'!I20","v":146000},{"$f":"'LCOE Analysis'!J20","v":365000}]
[null,null,"Total Capital Cost",null,"USD",null,{"$f":"'LCOE Analysis'!F28","v":85000000},{"$f":"'LCOE Analysis'!G28","v":140000000},{"$f":"'LCOE Analysis'!H28","v":118055555.55555555},{"$f":"'LCOE Analysis'!I28","v":80000000},{"$f":"'LCOE Analysis'!J28","v":80000000}]
[]
[null,"Carrying Charge Analysis"]
[null,null,"Economic Life",null,"Yr",null,{"$f":"'LCOE Analysis'!F44","v":20},{"$f":"'LCOE Analysis'!G44","v":9},{"$f":"'LCOE Analysis'!H44","v":20},{"$f":"'LCOE Analysis'!I44","v":25},{"$f":"'LCOE Analysis'!J44","v":25}]
[null,null,"Tax Life",null,"Yr",null,{"$f":"'LCOE Analysis'!F46","v":5},{"$f":"'LCOE Analysis'!G46","v":5},{"$f":"'LCOE Analysis'!H46","v":5},{"$f":"'LCOE Analysis'!I46","v":15},{"$f":"'LCOE Analysis'!J46","v":15}]
[null,null,"Income Tax Rate",null,"%",null,{"$f":"'LCOE Analysis'!F47","v":0.3},{"$f":"G12","v":0.3},{"$f":"H12","v":0.3},{"$f":"I12","v":0.3},{"$f":"J12","v":0.3}]
[null,null,"Variable Declining Balance Factor (1-St Line)",null,"Factor",null,{"$f":"'LCOE Analysis'!F48","v":2},{"$f":"G13","v":2},{"$f":"H13","v":2},2,2]
[null,null,"Debt to Captial",null,"%",null,{"$f":"'LCOE Analysis'!F49","v":0.5},{"$f":"G14","v":0.5},0.5,0.5,0.5]
[null,null,"Target Equity IRR",null,"%",null,{"$f":"'LCOE Analysis'!F50","v":0.1},{"$f":"'LCOE Analysis'!G50","v":0.1},{"$f":"'LCOE Analysis'!H50","v":0.1},{"$f":"'LCOE Analysis'!I50","v":0.1},{"$f":"'LCOE Analysis'!J50","v":0.1}]
[null,null,"Cost of Debt",null,"%",null,{"$f":"'LCOE Analysis'!F51","v":0.04},{"$f":"'LCOE Analysis'!G51","v":0.04},{"$f":"'LCOE Analysis'!H51","v":0.04},{"$f":"'LCOE Analysis'!I51","v":0.04},{"$f":"'LCOE Analysis'!J51","v":0.04}]
[null,null,"After Cost of Debt",null,"%",null,{"$f":"G16*(1-G12)","v":2.7999999999999997E-2},{"$f":"H16*(1-H12)","v":2.7999999999999997E-2},{"$f":"I16*(1-I12)","v":2.7999999999999997E-2},{"$f":"J16*(1-J12)","v":2.7999999999999997E-2},{"$f":"K16*(1-K12)","v":2.7999999999999997E-2}]
[null,null,"WACC",null,"%",null,{"$f":"G17*G14+G15*(1-G14)","v":6.4000000000000001E-2},{"$f":"H17*H14+H15*(1-H14)","v":6.4000000000000001E-2},{"$f":"I17*I14+I15*(1-I14)","v":6.4000000000000001E-2},{"$f":"J17*J14+J15*(1-J14)","v":6.4000000000000001E-2},{"$f":"K17*K14+K15*(1-K14)","v":6.4000000000000001E-2}]
[]
[null,null,"Required Project IRR",null,"% p.a.",null,{"$f":"G18","v":6.4000000000000001E-2},{"$f":"H18","v":6.4000000000000001E-2},{"$f":"I18","v":6.4000000000000001E-2},{"$f":"J18","v":6.4000000000000001E-2},{"$f":"K18","v":6.4000000000000001E-2}]
[null,"Capital Expenditures"]
[]
[null,null,"Inflation",null,"% p.a.",null,{"$f":"'LCOE Analysis'!F52","v":0.02},{"$f":"G23","v":0.02},{"$f":"H23","v":0.02},0.02,0.02]
[null,null,"Degradation",null,"% p.a.",null,5.0000000000000001E-3,{"$f":"'LCOE Analysis'!G45","v":0.02},{"$f":"'LCOE Analysis'!H45","v":5.0000000000000001E-3},0,0]
[null,null,"Tax Shield Value",null,"%",null,{"$f":"tax_dep_shield(G11,G13,G20,G12)","v":0.24556801952684551},{"$f":"tax_dep_shield(H11,H13,H20,H12)","v":0.24556801952684551},{"$f":"tax_dep_shield(I11,I13,I20,I12)","v":0.24556801952684551},{"$f":"tax_dep_shield(J11,J13,J20,J12)","v":0.19655218584700579},{"$f":"tax_dep_shield(K11,K13,K20,K12)","v":0.19655218584700579}]
[]
[null,"Operating Expense"]
[null,null,"Levelizing Factor with PMT",null,"%",null,{"$f":"PMT(G20,G10,-1)","v":9.0036790305478495E-2},{"$f":"PMT(H20,H10,-1)","v":0.149592249888924},{"$f":"PMT(I20,I10,-1)","v":9.0036790305478495E-2},{"$f":"PMT(J20,J10,-1)","v":8.1224486094910509E-2},{"$f":"PMT(K20,K10,-1)","v":8.1224486094910509E-2}]
[null,null,"Capital Recovery Pre-Tax",null,"USD/yr",null,{"$f":"G28*G7","v":7653127.1759656724},{"$f":"H28*H7","v":20942914.984449361},{"$f":"I28*I7","v":10629343.299952323},{"$f":"J28*J7","v":6497958.8875928409},{"$f":"K28*K7","v":6497958.8875928409}]
[]
[null,null,"Capital Cost Recovery Base",null,"USD/yr",null,{"$f":"G28*G7","v":7653127.1759656724},{"$f":"H28*H7","v":20942914.984449361},{"$f":"I28*I7","v":10629343.299952323},{"$f":"J28*J7","v":6497958.8875928409},{"$f":"K28*K7","v":6497958.8875928409}]
[null,null,"IRR Adjusted for Degradation",null,"% p.a.",null,{"$f":"(1+G20)/(1-G24)-1","v":6.9346733668341765E-2},8.5714285714285854E-2,6.9346733668341765E-2,6.4000000000000057E-2,6.4000000000000057E-2]
[null,null,"Nominal Levelizing Factor with Degradation",null,"% p.a.",null,{"$f":"PMT(G32,G10,-1)","v":9.3914196134475394E-2},{"$f":"PMT(H32,H10,-1)","v":0.16390398481180912},{"$f":"PMT(I32,I10,-1)","v":9.3914196134475394E-2},{"$f":"PMT(J32,J10,-1)","v":8.122448609491055E-2},{"$f":"PMT(K32,K10,-1)","v":8.122448609491055E-2}]
[null,null,"PMT Factor Adjusted for Paying Taxes",null,"% p.a.",null,{"$f":"G33/(1-G12)","v":0.13416313733496485},{"$f":"H33/(1-H12)","v":0.2341485497311559},{"$f":"I33/(1-I12)","v":0.13416313733496485},{"$f":"J33/(1-J12)","v":0.11603498013558651},{"$f":"K33/(1-K12)","v":0.11603498013558651}]
[null,null,"PMT Factor Adjust for Tax Depreciation Shield",null,"% p.a.",null,{"$f":"G34*(1-G25)","v":0.10121696140610935},{"$f":"H34*(1-H25)","v":0.17664915409859286},{"$f":"I34*(1-I25)","v":0.10121696140610935},{"$f":"J34*(1-J25)","v":9.3228051155223077E-2},{"$f":"K34*(1-K25)","v":9.3228051155223077E-2}]
[]
[null,null,"Construction Timing",null,"Year",null,1,1,1,1,1]
[null,null,"Construction Factor",null,"Factor",null,{"$f":"FV(G20,G37,-1/G37)","v":1.0000000000000009},1.0000000000000009,1.0000000000000009,1.0000000000000009,1.0000000000000009]
[null,null,"Capital Cost Recovery with Degradation",null,"USD/yr",null,{"$f":"G35*G7*G38","v":8603441.7195193022},{"$f":"H35*H7*H38","v":24730881.573803023},{"$f":"I35*I7*I38","v":11949224.610443475},{"$f":"J35*J7*J38","v":7458244.092417853},{"$f":"K35*K7*K38","v":7458244.092417853}]
[null,"Carrying Charges"]
[]
[null,null,"Real IRR",null,"% p.a.",null,{"$f":"(1+G20)/(1+G23)-1","v":4.3137254901960853E-2},4.3137254901960853E-2,4.3137254901960853E-2,4.3137254901960853E-2,4.3137254901960853E-2]
[null,null,"Levelizing Factor with Real IRR",null,"% p.a.",null,{"$f":"(1+G42)/(1-G24)-1","v":4.8379150655237124E-2},6.4425770308123242E-2,4.8379150655237124E-2,4.3137254901960853E-2,4.3137254901960853E-2]
[null,null,"Real IRR Adjusted for Degradation",null,"% p.a.",null,{"$f":"(1+G42)/(1-G24)-1","v":4.8379150655237124E-2},6.4425770308123242E-2,4.8379150655237124E-2,4.3137254901960853E-2,4.3137254901960853E-2]
[null,null,"Levelizing Factor with Real IRR and Degradation",null,"% p.a.",null,{"$f":"PMT(G44,G10,-1)","v":7.9143501041814654E-2},{"$f":"PMT(H44,H10,-1)","v":0.14986704532996081},{"$f":"PMT(I44,I10,-1)","v":7.9143501041814654E-2},{"$f":"PMT(J44,J10,-1)","v":6.6152032897282886E-2},{"$f":"PMT(K44,K10,-1)","v":6.6152032897282886E-2}]
[]
[null,null,"Adj for Tax on Inc (Divide by (1-t))",null,"%",null,{"$f":"G45/(1-G12)","v":0.11306214434544952},{"$f":"H45/(1-H12)","v":0.21409577904280117},{"$f":"I45/(1-I12)","v":0.11306214434544952},{"$f":"J45/(1-J12)","v":9.4502904138975552E-2},{"$f":"K45/(1-K12)","v":9.4502904138975552E-2}]
[null,null,"Adj for Tax Shield",null,"%",null,{"$f":"G47*(1-G25)","v":8.5297697475079148E-2},0.16152070259420337,8.5297697475079148E-2,7.5928151761569848E-2,7.5928151761569848E-2]
[]
[null,null,"Construction Real",null,"Factor",null,1,1,1,1,1]
[null,null,"Final Real Capital Cost Recovery with Degradation",null,"USD/yr",null,{"$f":"G48*G7","v":7250304.2853817279},{"$f":"H48*H7","v":22612898.363188472},{"$f":"I48*I7","v":10069867.063030178},{"$f":"J48*J7","v":6074252.1409255881},{"$f":"K48*K7","v":6074252.1409255881}]
[]
[]
[null,null,"Total Operating Costs",null,"USD/yr",null,{"$f":"'LCOE Analysis'!F40","v":1500000},{"$f":"'LCOE Analysis'!G40","v":2800000},{"$f":"'LCOE Analysis'!H40","v":2083333.3333333335},{"$f":"'LCOE Analysis'!I40","v":11988000},{"$f":"'LCOE Analysis'!J40","v":29070000}]
[]
[null,null,"Inflation Factor for Nominal Cost",null,"Factor",null,{"$f":"PV(G42,G10,-1)/PV(G20,G10,-1)","v":1.1903281668737857},{"$f":"PV(H42,H10,-1)/PV(H20,H10,-1)","v":1.0965368153933452},{"$f":"PV(I42,I10,-1)/PV(I20,I10,-1)","v":1.1903281668737857},{"$f":"PV(J42,J10,-1)/PV(J20,J10,-1)","v":1.2278456539806},{"$f":"PV(K42,K10,-1)/PV(K20,K10,-1)","v":1.2278456539806}]
[null,null,"Degradation Factor for Nominal Cost",null,"Factor",null,{"$f":"PV(G42,G10,-1)/PV(G32,G10,-1)","v":1.2415892719953321},{"$f":"PV(H42,H10,-1)/PV(H32,H10,-1)","v":1.2014442838400539},{"$f":"PV(I42,I10,-1)/PV(I32,I10,-1)","v":1.2415892719953321},{"$f":"PV(J42,J10,-1)/PV(J32,J10,-1)","v":1.2278456539806011},{"$f":"PV(K42,K10,-1)/PV(K32,K10,-1)","v":1.2278456539806011}]
[null,null,"Adjusted Nominal Cost for LCOE Calc",null,"USD/yr",null,{"$f":"G57*G54","v":1862383.9079929981},{"$f":"H57*H54","v":3364043.994752151},{"$f":"I57*I54","v":2586644.316656942},{"$f":"J57*J54","v":14719413.699919445},{"$f":"K57*K54","v":35693473.161216073}]
[]
[null,null,"Degradation Factor for Real Cost",null,"Factor",null,{"$f":"PV(G42,G10,-1)/PV(G44,G10,-1)","v":1.0463138256644919},{"$f":"PV(H42,H10,-1)/PV(H44,H10,-1)","v":1.0985511130459515},{"$f":"PV(I42,I10,-1)/PV(I44,I10,-1)","v":1.0463138256644919},{"$f":"PV(J42,J10,-1)/PV(J44,J10,-1)","v":1},{"$f":"PV(K42,K10,-1)/PV(K44,K10,-1)","v":1}]
[null,null,"Adjusted Real Cost of LOCE",null,"USD/yr",null,{"$f":"G54*G60","v":1569470.738496738},{"$f":"H54*H60","v":3075943.1165286642},{"$f":"I54*I60","v":2179820.4701343584},{"$f":"J54*J60","v":11988000},{"$f":"K54*K60","v":29070000}]
[]
[null,"LCOE Calculation"]
[null,null,"Nominal Capital Recovery",null,"USD/yr",null,{"$f":"G39","v":8603441.7195193022},{"$f":"H39","v":24730881.573803023},{"$f":"I39","v":11949224.610443475},{"$f":"J39","v":7458244.092417853},{"$f":"K39","v":7458244.092417853}]
[null,null,"Nomina O&M Cost",null,"USD/yr",null,{"$f":"G58","v":1862383.9079929981},{"$f":"H58","v":3364043.994752151},{"$f":"I58","v":2586644.316656942},{"$f":"J58","v":14719413.699919445},{"$f":"K58","v":35693473.161216073}]
[null,null,"Total Nominal Cost",null,"USD/yr",null,{"$f":"SUM(G64:G65)","v":10465825.6275123},{"$f":"SUM(H64:H65)","v":28094925.568555173},{"$f":"SUM(I64:I65)","v":14535868.927100416},{"$f":"SUM(J64:J65)","v":22177657.792337298},{"$f":"SUM(K64:K65)","v":43151717.253633924}]
[]
[null,null,"Total Production",null,"kWh",null,{"$f":"G6","v":219000},{"$f":"H6","v":146000},202777.77777777778,146000,365000]
[null,null,"LCOE - Nominal",null,"USD/unit",null,{"$f":"IFERROR(G66/G68,FALSE)","v":47.789158116494519},{"$f":"IFERROR(H66/H68,FALSE)","v":192.43099704489845},{"$f":"IFERROR(I66/I68,FALSE)","v":71.683737174741779},{"$f":"IFERROR(J66/J68,FALSE)","v":151.90176570094039},{"$f":"IFERROR(K66/K68,FALSE)","v":118.22388288666828}]
[null,null,"LCOE - Nominal",null,"USD/unit",null,{"$f":"G69*1000","v":47789.158116494516},{"$f":"H69*1000","v":192430.99704489845},{"$f":"I69*1000","v":71683.737174741778},{"$f":"J69*1000","v":151901.76570094039},{"$f":"K69*1000","v":118223.88288666827}]
[]
[null,null,"Capital Recovery - Real",null,"USD/yr",null,{"$f":"G51","v":7250304.2853817279},{"$f":"H51","v":22612898.363188472},{"$f":"I51","v":10069867.063030178},{"$f":"J51","v":6074252.1409255881},{"$f":"K51","v":6074252.1409255881}]
[null,null,"O&M Cost",null,"USD/yr",null,{"$f":"G61","v":1569470.738496738},{"$f":"H61","v":3075943.1165286642},{"$f":"I61","v":2179820.4701343584},{"$f":"J61","v":11988000},{"$f":"K61","v":29070000}]
[null,null,"Total Cost",null,"USD/yr",null,{"$f":"SUM(G72:G73)","v":8819775.0238784663},{"$f":"SUM(H72:H73)","v":25688841.479717135},{"$f":"SUM(I72:I73)","v":12249687.533164537},{"$f":"SUM(J72:J73)","v":18062252.140925586},{"$f":"SUM(K72:K73)","v":35144252.140925586}]
[]
[null,null,"Total Production",null,"Unit",null,{"$f":"G68","v":219000},{"$f":"H68","v":146000},{"$f":"I68","v":202777.77777777778},{"$f":"J68","v":146000},{"$f":"K68","v":365000}]
[null,null,"LCOE - Real",null,"USD/unit",null,{"$f":"IFERROR(G74/G76,FALSE)","v":40.272945314513542},{"$f":"IFERROR(H74/H76,FALSE)","v":175.95096903915845},{"$f":"IFERROR(I74/I76,FALSE)","v":60.409417971770317},{"$f":"IFERROR(J74/J76,FALSE)","v":123.71405575976429},{"$f":"IFERROR(K74/K76,FALSE)","v":96.285622303905711}]
[null,null,"LCOE - Real",null,"USD/unit",null,{"$f":"G77","v":40.272945314513542},{"$f":"H77","v":175.95096903915845},60.409417971770317,123.71405575976429,96.285622303905711]
[]
[null,null,"LCOE-Real",null,"USD/unit-year"]
[]
[null,"Financing Assumptions"]
[null,null,"Max Debt to Capital",null,null,null,0.85,0.85,0.85,0.85,0.85]
[null,null,"Interest Rate",null,null,null,0.03,0.03,0.03,0.03,0.03]
[null,null,"Debt Tenor",null,null,null,20,20,20,20,20]
[null,null,"P50 DSCR",null,null,null,1.2,1.2,1.2,1.2,1.2]
[null,null,"P99 DSCR",null,null,null,1,1,1,1,1]
[]
[null,null,"Target Equity IRR",null,null,null,0.08,0.08,0.08,0.08,0.08]

{"sheet":"Sensitivity","index":4,"n_rows":34,"n_cols":18,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,null,"Code Number",12]
[null,null,"Hours of Storage",{"$f":"'LCOE Analysis'!$E$11","v":4}]
[null,null,"Thermal Fuel Cost",{"$f":"'LCOE Analysis'!$I$1","v":12}]
[null,null,null,"Battery Cost USD/kWh","Battery Life - Years","Battery Degradation","Battery O&M Cost","Return on Equity","Debt to Capital","Round Trip Efficiency","Depth of Discharge (Larger Battery)","Solar Capital Cost","Solar O&M Cost","Solar Life",null,"Solar Plus Battery","Solar Plus Thermal","Thermal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'LCOE Analysis'!K4","v":142.76378692856318},{"$f":"'LCOE Analysis'!L4","v":81.148374110777794},{"$f":"'LCOE Analysis'!J4","v":100.0773810751174}]
[null,null,"Best Case",200,20,0.01,0.01,0.05,0.8,1,1,600,7,35,1,41.583023567258351,57.85431390587798,93.689966728777449]
[null,null,"Higher Battery Cost",350,20,0.01,0.01,0.05,0.8,1,1,600,7,35,2,56.323770477051319,57.85431390587798,93.689966728777449]
[null,null,"Longer Battery Life",350,9,0.01,0.01,0.05,0.8,1,1,600,7,35,3,80.418124228234873,57.85431390587798,93.689966728777449]
[null,null,"Higher Degradation",350,9,0.02,0.01,0.05,0.8,1,1,600,7,35,4,83.274542487765146,57.85431390587798,93.689966728777449]
[null,null,"Higher Battery O&M",350,9,0.02,0.02,0.05,0.8,1,1,600,7,35,5,87.505203095020747,57.85431390587798,93.689966728777449]
[null,null,"Higher Return",350,9,0.02,0.02,0.1,0.8,1,1,600,7,35,6,93.527199721897034,61.128652217080983,95.586967424485806]
[null,null,"Lower Debt",350,9,0.02,0.02,0.1,0.5,1,1,600,7,35,7,107.46130952891524,68.916495167887788,100.0773810751174]
[null,null,"Lower Efficiency",350,9,0.02,0.02,0.1,0.5,0.8,1,600,7,35,8,111.37108805210782,68.916495167887788,100.0773810751174]
[null,null,"Depth of Discharge",350,9,0.02,0.02,0.1,0.5,0.8,0.9,600,7,35,9,113.54318723165927,68.916495167887788,100.0773810751174]
[null,null,"Higher Solar Cost",350,9,0.02,0.02,0.1,0.5,0.8,0.9,850,7,35,10,127.06615955563625,74.577274280250236,100.0773810751174]
[null,null,"Higher Solar O&M",350,9,0.02,0.02,0.1,0.5,0.8,0.9,850,15,35,11,132.67184219648206,76.923839106650817,100.0773810751174]
[null,null,"Shorter Solar Life",350,9,0.02,0.02,0.1,0.5,0.8,0.9,850,15,20,12,142.76378692856318,81.148374110777794,100.0773810751174]
[]
[null,null,{"$f":"INDEX(C6:C17,$D$1)","v":"Shorter Solar Life"},{"$f":"INDEX(D6:D17,$D$1)","v":350},{"$f":"INDEX(E6:E17,$D$1)","v":9},{"$f":"INDEX(F6:F17,$D$1)","v":0.02},{"$f":"INDEX(G6:G17,$D$1)","v":0.02},{"$f":"INDEX(H6:H17,$D$1)","v":0.1},{"$f":"INDEX(I6:I17,$D$1)","v":0.5},{"$f":"INDEX(J6:J17,$D$1)","v":0.8},{"$f":"INDEX(K6:K17,$D$1)","v":0.9},{"$f":"INDEX(L6:L17,$D$1)","v":850},{"$f":"INDEX(M6:M17,$D$1)","v":15},{"$f":"INDEX(N6:N17,$D$1)","v":20}]
[]
[]
[null,null,"Best Case",{"$f":"P6","v":41.583023567258351}]
[null,null,{"$f":"C7","v":"Higher Battery Cost"},{"$f":"P7-P6","v":14.740746909792968}]
[null,null,"Shorter Battery Life",{"$f":"P8-P7","v":24.094353751183554}]
[null,null,{"$f":"C9","v":"Higher Degradation"},2.8564182595302725]
[null,null,"Higher Battery O&M",4.2306606072556008]
[null,null,"Higher Return",6.0219966268762875]
[null,null,"Lower Debt",13.934109807018203]
[null,null,"Lower Efficiency",3.9097785231925855]
[null,null,"Depth of Discharge",2.1720991795514522]
[null,null,"Higher Solar Cost",13.522972323976973]
[null,null,"Higher Solar O&M",5.6056826408458136]
[null,null,"Shorter Solar Life",10.091944732081117]
[null,null,"Worst Case",{"$f":"P17","v":142.76378692856318}]