{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Scenarios","Financial Model","LCOE Analysis","Debt Service Chart","Tornado","Low Sensitivity"],"not_rendered":{"charts":7,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Debt Service Chart","index":3,"reason":"not_a_worksheet"},{"sheet":"Tornado","index":4,"reason":"not_a_worksheet"},{"sheet":"Low Sensitivity","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":"Scenarios","index":0,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[null,"code number",null,1]
[null,null,"Life","Degradation","capacity factor","Cost per kW","O&M cost","Interest rate",null,"Equity IRR","Project IRR","DSCR"]
[null,null,null,null,null,null,null,null,null,{"$f":"'Financial Model'!H107","v":0.47972057319091088},{"$f":"'Financial Model'!F41","v":0.20561859972104291},{"$f":"'Financial Model'!F107","v":1.500391261508816}]
[null,"Base case",25,0,0.2,1100,12,0.1,1,0.47972057319091088,0.20561859972104291,1.500391261508816]
[null,"Downside",20,7.4999999999999997E-3,0.18,1500,15,0.12,2,0.10047304932354573,0.11131136590225155,0.88478887945006579]
[null,"Upside",30,3.0000000000000001E-3,0.22,1000,10,7.0000000000000007E-2,3,0.87900811844317106,0.25014336782619773,2.0950759199756095]
[null,{"$f":"TRANSPOSE(C2:I2)&\" Low case sensitivity\"","v":"Life Low case sensitivity"},{"$f":"C5","v":20},5.0000000000000001E-3,0.2,1100,12,0.1,4,0.45903102866189016,0.19601379091673876,1.4924950014297831]
[null,"Degradation Low case sensitivity",25,{"$f":"D5","v":7.4999999999999997E-3},0.2,1100,12,0.1,5,0.44927161608353638,0.19608432609755599,1.4885468713902668]
[null,"capacity factor Low case sensitivity",25,0,{"$f":"E5","v":0.18},1100,12,0.1,6,0.35836457144866252,0.18292251313123242,1.3424660599281528]
[null,"Cost per kW Low case sensitivity",25,0,0.2,{"$f":"F5","v":1500},12,0.1,7,0.21564297308394509,0.14730347824294587,1.1002869251064651]
[null,"O&M cost Low case sensitivity",25,0,0.2,1100,{"$f":"G5","v":15},0.1,8,0.46363270213475705,0.20280170922494722,1.4806760729343624]
[null,"Interest rate Low case sensitivity",25,0,0.2,1100,12,{"$f":"H5","v":0.12},9,0.41230615940220172,0.20561859972104291,1.3796814505505024]
[null,{"$f":"TRANSPOSE(C2:H2)& \": High case sensitivity\"","v":"Life: High case sensitivity"},{"$f":"C6","v":30},0,0.2,1100,12,0.1,10,0.47977945101126029,0.20681678245001844,1.500391261508816]
[null,"Degradation: High case sensitivity",25,0,0.2,1100,12,0.1,11,0.47972057319091088,0.20561859972104291,1.500391261508816]
[null,"capacity factor: High case sensitivity",25,0,{"$f":"E6","v":0.22},1100,12,0.1,12,0.61475738814100311,0.22805133412314471,1.6583164630894791]
[null,"Cost per kW: High case sensitivity",25,0,0.2,{"$f":"F6","v":1000},12,0.1,13,0.60782025238347903,0.22693598337148613,1.6504303876596975]
[null,"O&M cost: High case sensitivity",25,0,0.2,1100,{"$f":"G6","v":10},0.1,14,0.49056381942924543,0.20749426309657992,1.5135347205584515]
[null,"Interest rate: High case sensitivity",25,0,0.2,1100,12,{"$f":"H6","v":7.0000000000000007E-2},15,0.58494255814135432,0.20561859972104291,1.715030560692582]
[]
[]
[null,{"$f":"INDEX(B4:B18,$D$1)","v":"Base case"},25,0,0.2,1100,12,0.1]
[]
[null,null,null,null,null,null,"code number",1]
[null,null,null,null,null,null,null,"Low","High",{"$f":"J2","v":"Equity IRR"},{"$f":"K2","v":"Project IRR"},{"$f":"L2","v":"DSCR"}]
[null,null,null,null,null,null,{"$f":"B7","v":"Life Low case sensitivity"},{"$f":"INDEX(J25:L25,$H$23)","v":-2.068954452902072E-2},{"$f":"INDEX(J33:L33,$H$23)","v":5.8877820349412247E-5},{"$f":"J7-J$4","v":-2.068954452902072E-2},-9.6048088043041435E-3,-7.8962600790328796E-3]
[null,null,null,null,null,null,"Degradation Low case sensitivity",-3.0448957107374497E-2,{"$f":"INDEX(J34:L34,$H$23)","v":0},-3.0448957107374497E-2,-9.5342736234869108E-3,-1.1844390118549208E-2]
[null,null,null,null,null,null,"capacity factor Low case sensitivity",-0.12135600174224837,0.13503681495009223,-0.12135600174224837,-2.2696086589810482E-2,-0.15792520158066314]
[null,null,null,null,null,null,"Cost per kW Low case sensitivity",-0.26407760010696579,0.12809967919256815,-0.26407760010696579,-5.8315121478097032E-2,-0.40010433640235088]
[null,null,null,null,null,null,"O&M cost Low case sensitivity",-1.6087871056153835E-2,1.0843246238334547E-2,-1.6087871056153835E-2,-2.8168904960956809E-3,-1.9715188574453535E-2]
[null,null,null,null,null,null,"Interest rate Low case sensitivity",-6.741441378870916E-2,0.10522198495044344,-6.741441378870916E-2,0,-0.12070981095831357]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"J24","v":"Equity IRR"},{"$f":"K24","v":"Project IRR"},"DSCR"]
[null,null,null,null,null,null,{"$f":"B13","v":"Life: High case sensitivity"},null,null,{"$f":"J13-J$4","v":5.8877820349412247E-5},{"$f":"K13-K$4","v":1.1981827289755387E-3},0]
[null,null,null,null,null,null,{"$f":"B14","v":"Degradation: High case sensitivity"},null,null,{"$f":"J14-J$4","v":0},0,0]
[null,null,null,null,null,null,"capacity factor: High case sensitivity",null,null,{"$f":"J15-J$4","v":0.13503681495009223},2.2432734402101806E-2,0.15792520158066314]
[null,null,null,null,null,null,"Cost per kW: High case sensitivity",null,null,{"$f":"J16-J$4","v":0.12809967919256815},2.1317383650443222E-2,0.15003912615088155]
[null,null,null,null,null,null,"O&M cost: High case sensitivity",null,null,{"$f":"J17-J$4","v":1.0843246238334547E-2},1.8756633755370178E-3,1.3143459049635542E-2]
[null,null,null,null,null,null,"Interest rate: High case sensitivity",null,null,{"$f":"J18-J$4","v":0.10522198495044344},0,0.21463929918376601]
[]
[null,null,null,null,null,null,"Tonado Chart",null,{"$f":"INDEX(J32:L32,H23)","v":"Equity IRR"}]

{"sheet":"Financial Model","index":1,"n_rows":129,"n_cols":44,"rows_kept":129,"cut":false,"hidden":false,"merged":[]}
["Timing",null,null,null,null,"PPA",{"$f":"G22","v":137.16321540576945}]
[null,"Time Period",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,23,24,25,26,27,28,29,30,31,32,33,34,35]
[null,"Operating Switch",null,null,null,{"$f":"F6","v":25},null,null,null,{"$f":"J2<=$F$3","v":true},{"$f":"K2<=$F$3","v":true},true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,false,false,false,false,false,false,false,false,false,false]
["Assumptions"]
[null,"Timing assumptions"]
[null,null,"Project Life",null,"Years",{"$f":"Scenarios!C21","v":25}]
[]
[null,"Operating Assumptions"]
[null,null,"Plant Capacity",null,"mwp",20]
[null,null,"Degradation",null,"%pa",{"$f":"Scenarios!D21","v":0}]
[null,null,"Capacity Factor (Yeild)",null,"%",{"$f":"Scenarios!E21","v":0.2}]
[]
[]
[null,"Capex Assumptions"]
[null,null,"Cost per kWp",null,"$ per kW",{"$f":"Scenarios!F21","v":1100}]
[]
[null,"Opex Assumptions"]
[null,null,"O&M per kW",null,"$/kW-year",{"$f":"Scenarios!G21","v":12}]
[]
[null,"PPA Assumptions"]
[null,null,"Year",null,null,0,1,11,{"$f":"F6+1","v":26}]
[null,null,"PPA Price",null,"$/mWh",0,137.16321540576945,{"$f":"G22","v":137.16321540576945},0]
[]
[null,"Financing Assumptions"]
[null,null,"Debt size",null,"%",0.7]
[null,null,"Debt Tenor",null,"years",10]
[null,null,"Interest rate",null,"%",{"$f":"Scenarios!H21","v":0.1}]
[]
["Operating Model"]
[null,"Plant Characteristics",null,null,"mwp",{"$f":"F9","v":20},null,null,{"$f":"$F$30*I3","v":0},20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,0,0,0,0,0,0,0,0,0,0]
[null,"Degradation Factor",null,null,"%",{"$f":"F10","v":0},null,null,1,{"$f":"I31*(1-$F$31)","v":1},{"$f":"J31*(1-$F$31)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"Net Capacity",null,null,"mwp",null,null,null,{"$f":"PRODUCT(I30:I31)","v":0},{"$f":"PRODUCT(J30:J31)","v":20},20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,0,0,0,0,0,0,0,0,0,0]
[null,"Generation",null,null,"mwh",{"$f":"F11","v":0.2},null,null,{"$f":"I32*8760*$F$33","v":0},{"$f":"J32*8760*$F$33","v":35040},{"$f":"K32*8760*$F$33","v":35040},35040,35040,35040,35040,35040,35040,35040,35040,35040,35040,35040,35040,35040,35040,35040,35040,35040,35040,35040,35040,35040,35040,35040,0,0,0,0,0,0,0,0,0,0]
[]
[null,"EPC Cost",null,null,"$'000",{"$f":"F15*F9","v":22000},null,null,{"$f":"F35","v":22000}]
[null,"O&M Cost",null,null,"$'000",{"$f":"F18","v":12},null,null,{"$f":"$F$36*I3*I30","v":0},240,240,240,240,240,240,240,240,240,240,240,240,240,240,240,240,240,240,240,240,240,240,240,240,240,0,0,0,0,0,0,0,0,0,0]
[null,"PPA Price",null,null,"$/mWh",null,null,null,{"$f":"LOOKUP(I2,21:21,22:22)","v":0},{"$f":"LOOKUP(J2,21:21,22:22)","v":137.16321540576945},137.16321540576945,137.16321540576945,137.16321540576945,137.16321540576945,137.16321540576945,137.16321540576945,137.16321540576945,137.16321540576945,137.16321540576945,137.16321540576945,137.16321540576945,137.16321540576945,137.16321540576945,137.16321540576945,137.16321540576945,137.16321540576945,137.16321540576945,137.16321540576945,137.16321540576945,137.16321540576945,137.16321540576945,137.16321540576945,137.16321540576945,137.16321540576945,0,0,0,0,0,0,0,0,0,0]
[null,"Revenues",null,null,"$'000",null,null,null,{"$f":"I37*I33/1000","v":0},{"$f":"J37*J33/1000","v":4806.199067818161},4806.199067818161,4806.199067818161,4806.199067818161,4806.199067818161,4806.199067818161,4806.199067818161,4806.199067818161,4806.199067818161,4806.199067818161,4806.199067818161,4806.199067818161,4806.199067818161,4806.199067818161,4806.199067818161,4806.199067818161,4806.199067818161,4806.199067818161,4806.199067818161,4806.199067818161,4806.199067818161,4806.199067818161,4806.199067818161,4806.199067818161,4806.199067818161,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Project Cashflows",null,null,null,null,null,null,{"$f":"I38-I35-I36","v":-22000},{"$f":"J38-J35-J36","v":4566.199067818161},4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,0,0,0,0,0,0,0,0,0,0]
[null,"Project IRR",null,null,null,{"$f":"IRR(40:40)","v":0.20561859972104291}]
[]
["Project Finance Model"]
[]
[null,"Sources and uses of funds"]
[null,null,"Cap Exp",null,"$'000",null,null,null,{"$f":"I35","v":22000}]
[]
[null,null,"Debt",null,"$'000",0.85,null,null,{"$f":"I46*F48","v":18700}]
[null,null,"Equity",null,"$'000",null,null,null,{"$f":"I46-I48","v":3300}]
[null,null,"Total",null,null,null,null,null,{"$f":"SUM(I48:I49)","v":22000}]
[]
[null,"Debt schedule"]
[null,null,"Repayment",null,"years",{"$f":"F26","v":10},null,null,null,{"$f":"J2<=$F$53","v":true},{"$f":"K2<=$F$53","v":true},true,true,true,true,true,true,true,true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,null,"Repayment amount",null,"$'000",{"$f":"I48/F53","v":1870},null,null,null,{"$f":"IF(J53,PPMT($F$59,J2,$F$53,-$I$48))*1","v":1173.3388843029672},{"$f":"IF(K53,PPMT($F$59,K2,$F$53,-$I$48))*1","v":1290.6727727332639},1419.7400500065903,1561.7140550072493,1717.8854605079741,1889.6740065587715,2078.641407214649,2286.505547936114,2515.1561027297253,2766.6717130026973,0,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,null,"Opening balance",null,null,null,null,null,null,{"$f":"I58","v":18700},{"$f":"J58","v":17526.661115697032},16235.988342963768,14816.248292957178,13254.534237949929,11536.648777441955,9646.9747708831837,7568.3333636685347,5281.8278157324203,2766.671713002695,0,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,null,"less: repayment",null,null,null,null,null,null,{"$f":"-J54","v":-1173.3388843029672},{"$f":"-K54","v":-1290.6727727332639},-1419.7400500065903,-1561.7140550072493,-1717.8854605079741,-1889.6740065587715,-2078.641407214649,-2286.505547936114,-2515.1561027297253,-2766.6717130026973,0,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,null,"closing balance",null,null,null,null,null,{"$f":"I48","v":18700},{"$f":"SUM(J56:J57)","v":17526.661115697032},{"$f":"SUM(K56:K57)","v":16235.988342963768},14816.248292957178,13254.534237949929,11536.648777441955,9646.9747708831837,7568.3333636685347,5281.8278157324203,2766.671713002695,0,0,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,null,"Interest",null,null,{"$f":"F27","v":0.1},null,null,null,{"$f":"$F$59*J56","v":1870},{"$f":"$F$59*K56","v":1752.6661115697034},1623.5988342963769,1481.624829295718,1325.4534237949929,1153.6648777441956,964.69747708831846,756.83333636685347,528.1827815732421,276.6671713002695,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Financial Statements"]
[]
[null,"cash flow waterfall"]
[null,null,"EBIDTA",null,null,null,null,null,null,{"$f":"J40","v":4566.199067818161},{"$f":"K40","v":4566.199067818161},4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,0,0,0,0,0,0,0,0,0,0]
[null,null,"less: debt service",null,null,null,null,null,null,{"$f":"J57-J59","v":-3043.338884302967},{"$f":"K57-K59","v":-3043.338884302967},-3043.338884302967,-3043.338884302967,-3043.338884302967,-3043.338884302967,-3043.3388843029675,-3043.3388843029675,-3043.3388843029675,-3043.338884302967,0,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,null,"Net cash flow",null,null,null,null,null,null,{"$f":"SUM(J64:J65)","v":1522.860183515194},{"$f":"SUM(K64:K65)","v":1522.860183515194},1522.860183515194,1522.860183515194,1522.860183515194,1522.860183515194,1522.8601835151935,1522.8601835151935,1522.8601835151935,1522.860183515194,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,0,0,0,0,0,0,0,0,0,0]
[null,null,"Dividend",null,null,null,null,null,null,{"$f":"J66","v":1522.860183515194},{"$f":"K66","v":1522.860183515194},1522.860183515194,1522.860183515194,1522.860183515194,1522.860183515194,1522.8601835151935,1522.8601835151935,1522.8601835151935,1522.860183515194,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Equity Cash flow",null,null,null,null,null,{"$f":"-I49","v":-3300},{"$f":"J67","v":1522.860183515194},1522.860183515194,1522.860183515194,1522.860183515194,1522.860183515194,1522.860183515194,1522.8601835151935,1522.8601835151935,1522.8601835151935,1522.860183515194,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,0,0,0,0,0,0,0,0,0,0]
[null,null,"Equity IRR",null,null,{"$f":"IRR(69:69)","v":0.47972057319091088}]
[null,null,null,null,null,null,null,null,null,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041]
[null,null,"CFADS",null,null,null,null,null,null,{"$f":"J64","v":4566.199067818161},4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,4566.199067818161,0,0,0,0,0,0,0,0,0,0]
[null,null,"Debt Service",null,null,null,null,null,null,{"$f":"-J65","v":3043.338884302967},3043.338884302967,3043.338884302967,3043.338884302967,3043.338884302967,3043.338884302967,3043.3388843029675,3043.3388843029675,3043.3388843029675,3043.338884302967,0,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,null,null,null,null,null,null,null,null,{"$f":"IF(J73>0.1,J72/J73)","v":1.500391261508816},{"$f":"IF(K73>0.1,K72/K73)","v":1.500391261508816},1.500391261508816,1.500391261508816,1.500391261508816,1.500391261508816,1.5003912615088157,1.5003912615088157,1.5003912615088157,1.500391261508816,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,"Target Equity IRR",null,null,{"$f":"F76/100","v":0.48}]
[null,null,"Equity IRR Computed ",null,{"$f":"H107","v":0.47972057319091088},48]
[null,null,"Difference",null,{"$f":"E75-E76","v":2.7942680908910056E-4}]
[]
[]
["LCOE Inputs"]
[null,"Project IRR",null,null,{"$f":"F41","v":0.20561859972104291}]
[]
["LCOE with Carrying Charge Rate",null,null,null,null,null,null,null,"Main Idea -- Use project IRR that gives you target equity IRR"]
[null,"Discount Rate (Project IRR)",null,null,{"$f":"F41","v":0.20561859972104291},{"$f":"formula1(E84)","v":"=F41"}]
[null,"Carrying Charge rate",null,null,{"$f":"E87","v":0.20755450308264067},{"$f":"formula1(E85)","v":"=E87"}]
[null,"Carrying Charge from EBITDA/Cost",null,null,{"$f":"J64/I46","v":0.20755450308264367},{"$f":"formula1(E86)","v":"=J64/I46"},null,null,"EBITDA/Cost",{"$f":"J64/I50","v":0.20755450308264367}]
[null,"Carrying Charge with PMT Function",null,null,{"$f":"PMT(E84,$F$6,-1)","v":0.20755450308264067},{"$f":"formula1(E87)","v":"=PMT(E84,$F$6,-1)"},null,null,"PMT",{"$f":"PMT(E81,F6,-1)","v":0.20755450308264067}]
[null,"Carrying Cost - USD/kW-yr",null,null,{"$f":"(F15*E86+F18)","v":240.30995339090805},{"$f":"_xlfn.FORMULATEXT(E88)","v":"=(F15*E86+F18)"}]
[null,"Hours",null,null,{"$f":"8760*F11","v":1752},{"$f":"_xlfn.FORMULATEXT(E89)","v":"=8760*F11"}]
[null,"Simple LCOE (USD/MWH)",null,null,{"$f":"E88*1000/E89","v":137.16321540576942},"=E88*1000/E89",null,null,"LCOE",{"$f":"(F15*J87+F18)/(8760*F11)*1000","v":137.16321540576757}]
[]
["LCOE Revenue and Generation Formula"]
[null,"NPV of Revenues",null,null,{"$f":"NPV(E81,J38:AR38)","v":23156.322779971226},{"$f":"formula1(E93)","v":"=NPV(E81,J38:AR38)"}]
[null,"NPV of Generation",null,null,{"$f":"NPV(E81,J33:AR33)","v":168823.12587575294},"=NPV(E81,J33:AR33)"]
[null,"LCOE from NPV Revenues/NPV of Generation)",null,null,{"$f":"E93/E94*1000","v":137.16321540576942},"=E93/E94*1000"]
[]
[null,"Total Cost",null,null,null,null,null,null,{"$f":"I35+I36","v":22000},240,240,240,240,240,240,240,240,240,240,240,240,240,240,240,240,240,240,240,240,240,240,240,240,240,0,0,0,0,0,0,0,0,0,0]
[]
["LCOE using cost"]
[null,"NPV of OPEX",null,null,{"$f":"NPV(E84,J36:AR36)","v":1156.3227799709107},{"$f":"formula1(E100)","v":"=NPV(E84,J36:AR36)"}]
[null,"NPV of CAP EXP",null,null,{"$f":"F35","v":22000},"=F35"]
[null,"NPV of Cost",null,null,{"$f":"E100+E101","v":23156.322779970909},"=E100+E101"]
[null,"NPV of Generation",null,null,{"$f":"NPV(E84,J33:AR33)","v":168823.12587575294},"=NPV(E84,J33:AR33)"]
[null,"LCOE from Cost Analysis",null,null,{"$f":"E102/E103*1000","v":137.16321540576755},"=E102/E103*1000"]
[]
[]
[{"$f":"Scenarios!$B$21","v":"Base case"},null,"DSCR",null,null,{"$f":"J74","v":1.500391261508816},"Equity IRR",{"$f":"F70","v":0.47972057319091088}]
[]
[null,null,null,null,null,{"$f":"H107","v":0.47972057319091088},1000,1100,1200,1300,1400,1500]
[null,null,null,null,null,0.15,0.27688118359623326,0.21817930165252886,0.17711577941480683,0.14680379516188324,0.12334769689475999,0.10449844654214679]
[null,null,null,null,null,0.16,0.3312434591886122,0.25894371803317218,0.20882992470954753,0.17255875821109412,0.14505614022954849,0.12334590256730804]
[null,null,null,null,null,0.16999999999999998,0.39278240830533062,0.30560544659827049,0.24472305533649252,0.20116291031458222,0.16871585932648259,0.14355085843565285]
[null,null,null,null,null,0.18,0.46042557060413558,0.35836457144866252,0.28541381067472171,0.23318923735634378,0.19476207038798887,0.16543111241058783]
[null,null,null,null,null,0.19,0.53260418892309125,0.41674403882765776,0.33123097864966078,0.2691620155992005,0.22365409550287718,0.18933763107886747]
[null,null,null,null,null,0.2,0.60782025238347903,0.47972057319091088,0.38204985683318293,0.3094392399480228,0.25583060251500633,0.21564297308394509]
[null,null,null,null,null,0.21,0.68494248066977326,0.54608387369565903,0.43727841595790506,0.35408549848646964,0.29163464160987562,0.24471319975624883]
[]
[null,null,null,null,null,"Target IRR",0.2]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"H107","v":0.47972057319091088},{"$f":"F107","v":1.500391261508816}]
[null,null,null,null,null,0.15,0.21817930165252886,1.1055782575571584]
[null,null,null,null,null,0.16,0.25894371803317218,1.1845408583474901]
[null,null,null,null,null,0.16999999999999998,0.30560544659827049,1.2635034591378214]
[null,null,null,null,null,0.18,0.35836457144866252,1.3424660599281528]
[null,null,null,null,null,0.19,0.41674403882765776,1.4214286607184847]
[null,null,null,null,null,0.2,0.47972057319091088,1.500391261508816]
[null,null,null,null,null,0.21,0.54608387369565903,1.5793538622991476]

{"sheet":"LCOE Analysis","index":2,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Carrying Charge rate",null,null,{"$f":"'Financial Model'!E86","v":0.20755450308264367}]
[]
[]
[null,null,null,"Solar 1 ","Solar 2","Wind 1","Wind 2","Hydro","NGCC 1","NGCC 2"]
[null,"Capital Cost ","USD/kW",1100,1700,2000,3500,4000,850,1566]
[null,"Fixed O&M","USD/kW-yr",12,11,35,35,15,16,16]
[null,"Total Capacity Cost","USD/KW-yr",{"$f":"D6*$F$2+D7","v":240.30995339090805},{"$f":"E6*$F$2+E7","v":363.84265524049425},450.10900616528733,761.44076078925286,845.21801233057465,192.42132762024713,341.03035182741996]
[null,"Capacity Factor","%",0.2,0.19,0.35,0.35,0.6,0.8,0.8]
[null,"Hours","Hours/yr",{"$f":"8766*D9","v":1753.2},{"$f":"8766*E9","v":1665.54},3068.1,3068.1,5259.5999999999995,7012.8,7012.8]
[null,"Capacity cost ","USD/MWh",{"$f":"D8*1000/D10","v":137.06933230145336},{"$f":"E8*1000/E10","v":218.45326755316248},146.70610676486663,248.1799031287288,160.70005558038153,27.438587671150913,48.629698811804118]
[null,"Variable cost","USD/MWh",0,0,0,0,0,70,70]
[null,"LCOE","USD/MWh",{"$f":"SUM(D11:D12)","v":137.06933230145336},218.45326755316248,146.70610676486663,248.1799031287288,160.70005558038153,97.438587671150913,118.62969881180412]