{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Detailed LCOE Calculator"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":32,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Detailed LCOE Calculator","index":0,"n_rows":93,"n_cols":12,"rows_kept":93,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Technology",null,null,1,null,{"$f":"INDEX(I2:S2,$E$2)","v":"Project 1"},null,"Project 1","Project 2","Project 3","Project 4"]
[]
[null,"Real LCOE",null,null,null,null,{"$f":"G83","v":21.084407453550131},null,{"$f":"I83","v":21.084407453550131},{"$f":"J83","v":21.07195234284908},{"$f":"K83","v":21.07195234284908},{"$f":"L83","v":19.060616795982714}]
[]
[null,null,"Annual Production",null,"Quantity",null,{"$f":"INDEX(I6:S6,$E$2)","v":160},null,160,160,160,160]
[null,null,"Total Capital Cost",null,"USD",null,{"$f":"INDEX(I7:S7,$E$2)","v":50500},null,50500,50500,50500,50500]
[]
[null,"Carrying Charge Analysis"]
[null,null,"Project Life",null,"Yr",null,{"$f":"INDEX(I10:S10,$E$2)","v":30},null,30,30,30,30]
[null,null,"Tax Life",null,"Yr",null,{"$f":"INDEX(I11:S11,$E$2)","v":5},null,5,5,5,5]
[null,null,"Income Tax Rate",null,"%",null,{"$f":"INDEX(I12:S12,$E$2)","v":0.3},null,0.3,0.3,0.3,0.3]
[null,null,"Variable Declining Balance Factor (1-St Line)",null,"Factor",null,{"$f":"INDEX(I13:S13,$E$2)","v":1},null,1,1,1,1]
[null,null,"Debt to Captial",null,"%",null,{"$f":"INDEX(I14:S14,$E$2)","v":0.8},null,0.8,0.8,0.8,0.8]
[null,null,"Target Equity IRR",null,"%",null,{"$f":"INDEX(I15:S15,$E$2)","v":7.4999999999999997E-2},null,7.4999999999999997E-2,7.4999999999999997E-2,7.4999999999999997E-2,7.4999999999999997E-2]
[null,null,"Cost of Debt",null,"%",null,{"$f":"INDEX(I16:S16,$E$2)","v":3.2000000000000001E-2},null,3.2000000000000001E-2,3.2000000000000001E-2,3.2000000000000001E-2,3.2000000000000001E-2]
[null,null,"After Cost of Debt",null,"%",null,{"$f":"INDEX(I17:S17,$E$2)","v":2.24E-2},null,{"$f":"I16*(1-I12)","v":2.24E-2},{"$f":"J16*(1-J12)","v":2.24E-2},{"$f":"K16*(1-K12)","v":2.24E-2},{"$f":"L16*(1-L12)","v":2.24E-2}]
[null,null,"WACC",null,"%",null,{"$f":"INDEX(I18:S18,$E$2)","v":3.2919999999999998E-2},null,{"$f":"I17*I14+I15*(1-I14)","v":3.2919999999999998E-2},{"$f":"J17*J14+J15*(1-J14)","v":3.2919999999999998E-2},{"$f":"K17*K14+K15*(1-K14)","v":3.2919999999999998E-2},{"$f":"L17*L14+L15*(1-L14)","v":3.2919999999999998E-2}]
[]
[null,null,"Required Nominal Project IRR",null,"% p.a.",null,{"$f":"INDEX(I20:S20,$E$2)","v":3.2919999999999998E-2},null,{"$f":"I18","v":3.2919999999999998E-2},{"$f":"J18","v":3.2919999999999998E-2},{"$f":"K18","v":3.2919999999999998E-2},{"$f":"L18","v":3.2919999999999998E-2}]
[]
[null,null,"Inflation",null,"% p.a.",null,{"$f":"INDEX(I22:S22,$E$2)","v":0.02},null,0.02,0.02,0.02,0.02]
[null,null,"Degradation",null,"% p.a.",null,{"$f":"INDEX(I23:S23,$E$2)","v":5.0000000000000001E-3},null,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3]
[null,null,"Tax Shield Value",null,"%",null,{"$f":"INDEX(I24:S24,$E$2)","v":0.26382140038754404},null,{"$f":"tax_dep_shield(I11,I13,I20,I12)","v":0.26382140038754404},{"$f":"tax_dep_shield(J11,J13,J20,J12)","v":0.26382140038754404},{"$f":"tax_dep_shield(K11,K13,K20,K12)","v":0.26382140038754404},{"$f":"tax_dep_shield(L11,L13,L20,L12)","v":0.26382140038754404}]
[]
[null,null,"Levelizing Factor with PMT",null,"%",null,{"$f":"INDEX(I26:S26,$E$2)","v":5.2963687077588924E-2},null,{"$f":"PMT(I20,I10,-1)","v":5.2963687077588924E-2},{"$f":"PMT(J20,J10,-1)","v":5.2963687077588924E-2},{"$f":"PMT(K20,K10,-1)","v":5.2963687077588924E-2},{"$f":"PMT(L20,L10,-1)","v":5.2963687077588924E-2}]
[null,null,"Capital Recovery Pre-Tax",null,"USD/yr",null,{"$f":"INDEX(I27:S27,$E$2)","v":2674.6661974182407},null,{"$f":"I26*I7","v":2674.6661974182407},{"$f":"J26*J7","v":2674.6661974182407},{"$f":"K26*K7","v":2674.6661974182407},{"$f":"L26*L7","v":2674.6661974182407}]
[]
[null,null,"Capital Cost Recovery Base",null,"USD/yr",null,{"$f":"INDEX(I29:S29,$E$2)","v":2674.6661974182407},null,{"$f":"I26*I7","v":2674.6661974182407},{"$f":"J26*J7","v":2674.6661974182407},{"$f":"K26*K7","v":2674.6661974182407},{"$f":"L26*L7","v":2674.6661974182407}]
[null,null,"IRR Adjusted for Degradation",null,"% p.a.",null,{"$f":"INDEX(I30:S30,$E$2)","v":3.811055276381925E-2},null,{"$f":"(1+I20)/(1-I23)-1","v":3.811055276381925E-2},3.811055276381925E-2,3.811055276381925E-2,3.811055276381925E-2]
[null,null,"Nominal Levelizing Factor with Degradation",null,"% p.a.",null,{"$f":"INDEX(I31:S31,$E$2)","v":5.6510776270983928E-2},null,{"$f":"PMT(I30,I10,-1)","v":5.6510776270983928E-2},{"$f":"PMT(J30,J10,-1)","v":5.6510776270983928E-2},{"$f":"PMT(K30,K10,-1)","v":5.6510776270983928E-2},{"$f":"PMT(L30,L10,-1)","v":5.6510776270983928E-2}]
[null,null,"PMT Factor Adjusted for Paying Taxes",null,"% p.a.",null,{"$f":"INDEX(I32:S32,$E$2)","v":8.0729680387119904E-2},null,{"$f":"I31/(1-I12)","v":8.0729680387119904E-2},{"$f":"J31/(1-J12)","v":8.0729680387119904E-2},{"$f":"K31/(1-K12)","v":8.0729680387119904E-2},{"$f":"L31/(1-L12)","v":8.0729680387119904E-2}]
[null,null,"PMT Factor Adjust for Tax Depreciation Shield",null,"% p.a.",null,{"$f":"INDEX(I33:S33,$E$2)","v":5.9431463054551076E-2},null,{"$f":"I32*(1-I24)","v":5.9431463054551076E-2},{"$f":"J32*(1-J24)","v":5.9431463054551076E-2},{"$f":"K32*(1-K24)","v":5.9431463054551076E-2},{"$f":"L32*(1-L24)","v":5.9431463054551076E-2}]
[]
[null,null,"Construction Timing",null,"Year",null,null,null,1,1,1,1]
[null,null,"Construction Factor",null,"Factor",null,null,null,{"$f":"FV(I20,I35,-1/I35)","v":1.000000000000002},1.000000000000002,1.000000000000002,1.000000000000002]
[null,null,"Capital Cost Recovery with Degradation",null,"USD/yr",null,{"$f":"INDEX(I37:S37,$E$2)","v":3001.2888842548355},null,{"$f":"I33*I7*I36","v":3001.2888842548355},{"$f":"J33*J7*J36","v":3001.2888842548355},{"$f":"K33*K7*K36","v":3001.2888842548355},{"$f":"L33*L7*L36","v":3001.2888842548355}]
[]
[null,null,"Real IRR",null,"% p.a.",null,{"$f":"INDEX(I39:S39,$E$2)","v":1.2666666666666604E-2},null,{"$f":"(1+I20)/(1+I22)-1","v":1.2666666666666604E-2},1.2666666666666604E-2,1.2666666666666604E-2,1.2666666666666604E-2]
[null,null,"Levelizing Factor with Real IRR",null,"% p.a.",null,{"$f":"INDEX(I40:S40,$E$2)","v":1.7755443886097177E-2},null,{"$f":"(1+I39)/(1-I23)-1","v":1.7755443886097177E-2},1.7755443886097177E-2,1.7755443886097177E-2,1.7755443886097177E-2]
[null,null,"Real IRR Adjusted for Degradation",null,"% p.a.",null,{"$f":"INDEX(I41:S41,$E$2)","v":1.7755443886097177E-2},null,{"$f":"(1+I39)/(1-I23)-1","v":1.7755443886097177E-2},1.7755443886097177E-2,1.7755443886097177E-2,1.7755443886097177E-2]
[null,null,"Levelizing Factor with Real IRR and Degradation",null,"% p.a.",null,{"$f":"INDEX(I42:S42,$E$2)","v":4.3283729825073898E-2},null,{"$f":"PMT(I41,I10,-1)","v":4.3283729825073898E-2},{"$f":"PMT(J41,J10,-1)","v":4.3283729825073898E-2},{"$f":"PMT(K41,K10,-1)","v":4.3283729825073898E-2},{"$f":"PMT(L41,L10,-1)","v":4.3283729825073898E-2}]
[]
[null,null,"Adj for Tax on Inc (Divide by (1-t))",null,"%",null,{"$f":"INDEX(I44:S44,$E$2)","v":6.1833899750105573E-2},null,{"$f":"I42/(1-I12)","v":6.1833899750105573E-2},{"$f":"J42/(1-J12)","v":6.1833899750105573E-2},{"$f":"K42/(1-K12)","v":6.1833899750105573E-2},{"$f":"L42/(1-L12)","v":6.1833899750105573E-2}]
[null,null,"Adj for Tax Shield",null,"%",null,{"$f":"INDEX(I45:S45,$E$2)","v":4.5520793726609707E-2},null,{"$f":"I44*(1-I24)","v":4.5520793726609707E-2},4.5520793726609707E-2,4.5520793726609707E-2,4.5520793726609707E-2]
[]
[null,null,"Construction Real",null,"Factor",null,null,null,1,1,1,1]
[null,null,"Final Real Capital Cost Recovery with Degradation",null,"USD/yr",null,{"$f":"INDEX(I48:S48,$E$2)","v":2298.8000831937902},null,{"$f":"I45*I7","v":2298.8000831937902},{"$f":"J45*J7","v":2298.8000831937902},{"$f":"K45*K7","v":2298.8000831937902},{"$f":"L45*L7","v":2298.8000831937902}]
[]
[null,"Operating Cost Analysis"]
[null,null,"Total Operating Costs",null,"USD/yr",null,{"$f":"INDEX(I51:S51,$E$2)","v":1000},null,1000,1000,1000,700]
[]
[null,null,"Degradation for Input Cost (eg electricity input)",null,"%",null,{"$f":"INDEX(I53:S53,$E$2)","v":5.0000000000000001E-3},null,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3]
[]
[null,null,"Nominal IRR",null,"% p.a.",null,{"$f":"INDEX(I55:S55,$E$2)","v":3.2919999999999998E-2},null,{"$f":"I20","v":3.2919999999999998E-2},{"$f":"J20","v":3.2919999999999998E-2},3.2919999999999998E-2,3.2919999999999998E-2]
[null,null,"Real IRR",null,"% p.a.",null,{"$f":"INDEX(I56:S56,$E$2)","v":1.2666666666666604E-2},null,{"$f":"I39","v":1.2666666666666604E-2},{"$f":"J39","v":1.2666666666666604E-2},1.2666666666666604E-2,1.2666666666666604E-2]
[null,null,"Nominal Adjusted for Degradation",null,"% p.a.",null,{"$f":"INDEX(I57:S57,$E$2)","v":3.811055276381925E-2},null,{"$f":"(1+I55)/(1-I53)-1","v":3.811055276381925E-2},{"$f":"(1+J55)/(1-J53)-1","v":3.811055276381925E-2},3.811055276381925E-2,3.811055276381925E-2]
[]
[null,null,"Inflation Factor for Nominal Cost",null,"Factor",null,{"$f":"INDEX(I59:S59,$E$2)","v":1.3150517606412262},null,{"$f":"PV(I56,I10,-1)/PV(I55,I10,-1)","v":1.3150517606412262},{"$f":"PV(J56,J10,-1)/PV(J55,J10,-1)","v":1.3150517606412262},1.3150517606412262,1.3150517606412262]
[null,null,"Degradation Factor for Nominal Cost",null,"Factor",null,{"$f":"INDEX(I60:S60,$E$2)","v":1.4031235348379942},null,{"$f":"PV(I56,I10,-1)/PV(I57,I10,-1)","v":1.4031235348379942},{"$f":"PV(J56,J10,-1)/PV(J57,J10,-1)","v":1.4031235348379942},1.4031235348379942,1.4031235348379942]
[null,null,"Adjusted Nominal Cost for LCOE Calc",null,"USD/yr",null,{"$f":"INDEX(I61:S61,$E$2)","v":1403.1235348379942},null,{"$f":"I60*I51","v":1403.1235348379942},{"$f":"J60*J51","v":1403.1235348379942},{"$f":"K60*K51","v":1403.1235348379942},{"$f":"L60*L51","v":982.18647438659593}]
[]
[null,null,"Real IRR without Degradation",null,"% p.a.",null,{"$f":"INDEX(I63:S63,$E$2)","v":1.2666666666666604E-2},null,{"$f":"I39","v":1.2666666666666604E-2},{"$f":"(1+J39)/(1-J53)-1","v":1.7755443886097177E-2},{"$f":"(1+K39)/(1-K53)-1","v":1.7755443886097177E-2},{"$f":"(1+L39)/(1-L53)-1","v":1.7755443886097177E-2}]
[null,null,"Real IRR with Degradation",null,"% p.a.",null,{"$f":"INDEX(I64:S64,$E$2)","v":1.7755443886097177E-2},null,{"$f":"(1+I63)/(1-I53)-1","v":1.7755443886097177E-2},{"$f":"(1+J63)/(1-J53)-1","v":2.2869792850348958E-2},{"$f":"(1+K63)/(1-K53)-1","v":2.2869792850348958E-2},{"$f":"(1+L63)/(1-L53)-1","v":2.2869792850348958E-2}]
[null,null,"Degradation Factor for Real Cost",null,"Factor",null,{"$f":"INDEX(I65:S65,$E$2)","v":1.0747051093742304},null,{"$f":"PV(I63,I10,-1)/PV(I64,I10,-1)","v":1.0747051093742304},{"$f":"PV(J63,J10,-1)/PV(J64,J10,-1)","v":1.0727122916620628},{"$f":"PV(K63,K10,-1)/PV(K64,K10,-1)","v":1.0727122916620628},{"$f":"PV(L63,L10,-1)/PV(L64,L10,-1)","v":1.0727122916620628}]
[null,null,"Adjusted Real Cost of LOCE",null,"USD/yr",null,{"$f":"INDEX(I66:S66,$E$2)","v":1074.7051093742305},null,{"$f":"I51*I65","v":1074.7051093742305},{"$f":"J51*J65","v":1072.7122916620629},{"$f":"K51*K65","v":1072.7122916620629},{"$f":"L51*L65","v":750.89860416344402}]
[]
[null,"LCOE Calculation"]
[null,null,"Nominal Capital Recovery",null,"USD/yr",null,{"$f":"INDEX(I69:S69,$E$2)","v":3001.2888842548355},null,{"$f":"I37","v":3001.2888842548355},{"$f":"J37","v":3001.2888842548355},{"$f":"K37","v":3001.2888842548355},{"$f":"L37","v":3001.2888842548355}]
[null,null,"Nominal O&M Cost",null,"USD/yr",null,{"$f":"INDEX(I70:S70,$E$2)","v":1403.1235348379942},null,{"$f":"I61","v":1403.1235348379942},{"$f":"J61","v":1403.1235348379942},{"$f":"K61","v":1403.1235348379942},{"$f":"L61","v":982.18647438659593}]
[null,null,"Total Nominal Cost",null,"USD/yr",null,{"$f":"INDEX(I71:S71,$E$2)","v":4404.4124190928296},null,{"$f":"SUM(I69:I70)","v":4404.4124190928296},{"$f":"SUM(J69:J70)","v":4404.4124190928296},{"$f":"SUM(K69:K70)","v":4404.4124190928296},{"$f":"SUM(L69:L70)","v":3983.4753586414313}]
[]
[null,null,"Total Production",null,"Units per Year",null,{"$f":"INDEX(I73:S73,$E$2)","v":160},null,{"$f":"I6","v":160},{"$f":"J6","v":160},{"$f":"K6","v":160},{"$f":"L6","v":160}]
[null,null,"LCOE - Nominal",null,"USD/Unit Year",null,{"$f":"INDEX(I74:S74,$E$2)","v":27.527577619330184},null,{"$f":"IFERROR(I71/I73,FALSE)","v":27.527577619330184},{"$f":"IFERROR(J71/J73,FALSE)","v":27.527577619330184},{"$f":"IFERROR(K71/K73,FALSE)","v":27.527577619330184},{"$f":"IFERROR(L71/L73,FALSE)","v":24.896720991508946}]
[null,null,"LCOE - Nominal",null,"USD/Unit Year x 1000",null,{"$f":"INDEX(I75:S75,$E$2)","v":27527.577619330183},null,{"$f":"I74*1000","v":27527.577619330183},{"$f":"J74*1000","v":27527.577619330183},{"$f":"K74*1000","v":27527.577619330183},{"$f":"L74*1000","v":24896.720991508948}]
[]
[null,null,"Capital Recovery - Real",null,"USD/yr",null,{"$f":"INDEX(I77:S77,$E$2)","v":2298.8000831937902},null,{"$f":"I48","v":2298.8000831937902},{"$f":"J48","v":2298.8000831937902},{"$f":"K48","v":2298.8000831937902},{"$f":"L48","v":2298.8000831937902}]
[null,null,"O&M Cost",null,"USD/yr",null,{"$f":"INDEX(I78:S78,$E$2)","v":1074.7051093742305},null,{"$f":"I66","v":1074.7051093742305},{"$f":"J66","v":1072.7122916620629},{"$f":"K66","v":1072.7122916620629},{"$f":"L66","v":750.89860416344402}]
[null,null,"Total Cost",null,"USD/yr",null,{"$f":"INDEX(I79:S79,$E$2)","v":3373.5051925680209},null,{"$f":"SUM(I77:I78)","v":3373.5051925680209},{"$f":"SUM(J77:J78)","v":3371.5123748558531},{"$f":"SUM(K77:K78)","v":3371.5123748558531},{"$f":"SUM(L77:L78)","v":3049.6986873572341}]
[]
[null,null,"Total Production",null,"Units per Year",null,{"$f":"INDEX(I81:S81,$E$2)","v":160},null,{"$f":"I73","v":160},{"$f":"J73","v":160},{"$f":"K73","v":160},{"$f":"L73","v":160}]
[null,null,"LCOE - Real",null,"USD/Units Year",null,{"$f":"INDEX(I82:S82,$E$2)","v":21.084407453550131},null,{"$f":"IFERROR(I79/I81,FALSE)","v":21.084407453550131},{"$f":"IFERROR(J79/J81,FALSE)","v":21.07195234284908},{"$f":"IFERROR(K79/K81,FALSE)","v":21.07195234284908},{"$f":"IFERROR(L79/L81,FALSE)","v":19.060616795982714}]
[null,null,"LCOE - Real",null,"USD/Units Year x 1000",null,{"$f":"INDEX(I83:S83,$E$2)","v":21.084407453550131},null,{"$f":"I82","v":21.084407453550131},{"$f":"J82","v":21.07195234284908},21.07195234284908,19.060616795982714]
[]
[]
[null,"Financing Assumptions"]
[null,null,"Max Debt to Capital",null,null,null,{"$f":"INDEX(I87:S87,$E$2)","v":0.85},null,0.85,0.85,0.85,0.85]
[null,null,"Interest Rate",null,null,null,{"$f":"INDEX(I88:S88,$E$2)","v":0.03},null,0.03,0.03,0.03,0.03]
[null,null,"Debt Tenor",null,null,null,{"$f":"INDEX(I89:S89,$E$2)","v":20},null,20,20,20,20]
[null,null,"P50 DSCR",null,null,null,{"$f":"INDEX(I90:S90,$E$2)","v":1.2},null,1.2,1.2,1.2,1.2]
[null,null,"P99 DSCR",null,null,null,{"$f":"INDEX(I91:S91,$E$2)","v":1},null,1,1,1,1]
[]
[null,null,"Target Equity IRR",null,null,null,{"$f":"INDEX(I93:S93,$E$2)","v":0.08},null,0.08,0.08,0.08,0.08]