{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Inputs","Model"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Inputs","index":0,"n_rows":62,"n_cols":55,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Time Line"]
[null,null,"Total Life",null,"Years",30]
[null,null,"Construction",null,"Years",1]
[null,null,"Debt Periods/year",null,"Period",2]
[]
[null,"Operating"]
[null,null,"Output",null,"MWH",1000]
[null,null,"Seasonality",null,"First, Second",1.2,0.8]
[]
[null,null,"Yield",null,"kWh/kWp",2500]
[null,null,"Implied kWp",null,"kWp",{"$f":"F8/F11*1000","v":400}]
[]
[]
[null,"Prices, Costs and Cap Exp"]
[null,null,"PPA Price",null,"Sols/MWH",80]
[]
[null,null,"Cap Exp",null,"USD/kWp",700]
[null,null,"Cap Exp",null,"Sols/MWH",{"$f":"F18*4","v":2800}]
[]
[null,null,"Op Exp",null,"USD/kWy",15]
[null,null,"Op Exp",null,"Sols/kWy",{"$f":"F21*4","v":60}]
[]
[null,null,"Total Cap Exp",null,"Sols",{"$f":"F19*F12","v":1120000}]
[null,null,"Total Op Exp",null,"Sols",{"$f":"F22*F12","v":24000}]
[]
[null,"Macro Economic"]
[null,null,"Sol Inflation Code",null,null,1]
[]
[null,null,null,null,null,null,2022,2023,2024,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]
[null,null,"Sol Inflation - Base",null,null,1,null,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09]
[null,null,"Sol Inflation - Changing",null,null,2,null,0.09,0.09,0.09,0.08,0.08,0.08,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06]
[null,null,"Sol Inflation - High",null,null,3,null,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11]
[null,null,"Sol Inflation - Low",null,null,4,null,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06]
[]
[null,null,{"$f":"INDEX(C31:C34,$F$28)","v":"Sol Inflation - Base"},null,null,null,null,{"$f":"INDEX(H31:H34,$F$28)","v":0.09},{"$f":"INDEX(I31:I34,$F$28)","v":0.09},{"$f":"INDEX(J31:J34,$F$28)","v":0.09},{"$f":"INDEX(K31:K34,$F$28)","v":0.09},{"$f":"INDEX(L31:L34,$F$28)","v":0.09},{"$f":"INDEX(M31:M34,$F$28)","v":0.09},{"$f":"INDEX(N31:N34,$F$28)","v":0.09},{"$f":"INDEX(O31:O34,$F$28)","v":0.09},{"$f":"INDEX(P31:P34,$F$28)","v":0.09},{"$f":"INDEX(Q31:Q34,$F$28)","v":0.09},{"$f":"INDEX(R31:R34,$F$28)","v":0.09},{"$f":"INDEX(S31:S34,$F$28)","v":0.09},{"$f":"INDEX(T31:T34,$F$28)","v":0.09},{"$f":"INDEX(U31:U34,$F$28)","v":0.09},{"$f":"INDEX(V31:V34,$F$28)","v":0.09},{"$f":"INDEX(W31:W34,$F$28)","v":0.09},{"$f":"INDEX(X31:X34,$F$28)","v":0.09},{"$f":"INDEX(Y31:Y34,$F$28)","v":0.09},{"$f":"INDEX(Z31:Z34,$F$28)","v":0.09},{"$f":"INDEX(AA31:AA34,$F$28)","v":0.09},{"$f":"INDEX(AB31:AB34,$F$28)","v":0.09},{"$f":"INDEX(AC31:AC34,$F$28)","v":0.09},{"$f":"INDEX(AD31:AD34,$F$28)","v":0.09},{"$f":"INDEX(AE31:AE34,$F$28)","v":0.09},{"$f":"INDEX(AF31:AF34,$F$28)","v":0.09},{"$f":"INDEX(AG31:AG34,$F$28)","v":0.09},{"$f":"INDEX(AH31:AH34,$F$28)","v":0.09},{"$f":"INDEX(AI31:AI34,$F$28)","v":0.09},{"$f":"INDEX(AJ31:AJ34,$F$28)","v":0.09},{"$f":"INDEX(AK31:AK34,$F$28)","v":0.09},{"$f":"INDEX(AL31:AL34,$F$28)","v":0.09},{"$f":"INDEX(AM31:AM34,$F$28)","v":0.09},{"$f":"INDEX(AN31:AN34,$F$28)","v":0.09},{"$f":"INDEX(AO31:AO34,$F$28)","v":0.09},{"$f":"INDEX(AP31:AP34,$F$28)","v":0.09},{"$f":"INDEX(AQ31:AQ34,$F$28)","v":0.09},{"$f":"INDEX(AR31:AR34,$F$28)","v":0.09},{"$f":"INDEX(AS31:AS34,$F$28)","v":0.09},{"$f":"INDEX(AT31:AT34,$F$28)","v":0.09},{"$f":"INDEX(AU31:AU34,$F$28)","v":0.09},{"$f":"INDEX(AV31:AV34,$F$28)","v":0.09},{"$f":"INDEX(AW31:AW34,$F$28)","v":0.09},{"$f":"INDEX(AX31:AX34,$F$28)","v":0.09},{"$f":"INDEX(AY31:AY34,$F$28)","v":0.09},{"$f":"INDEX(AZ31:AZ34,$F$28)","v":0.09},{"$f":"INDEX(BA31:BA34,$F$28)","v":0.09},{"$f":"INDEX(BB31:BB34,$F$28)","v":0.09},{"$f":"INDEX(BC31:BC34,$F$28)","v":0.09}]
[]
[]
[null,null,null,null,null,null,2022,2023,2024,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]
[null,null,"USD Inflation - Base",null,null,1,null,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03]
[null,null,"USD Inflation - Changing",null,null,2,null,0.04,0.03,2.5000000000000001E-2,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
[null,null,"USD Inflation - High",null,null,3,null,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04]
[null,null,"USD Inflation - Low",null,null,4,null,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
[]
[null,null,{"$f":"INDEX(C40:C43,$F$28)","v":"USD Inflation - Base"},null,null,null,null,{"$f":"INDEX(H40:H43,$F$28)","v":0.03},{"$f":"INDEX(I40:I43,$F$28)","v":0.03},{"$f":"INDEX(J40:J43,$F$28)","v":0.03},{"$f":"INDEX(K40:K43,$F$28)","v":0.03},{"$f":"INDEX(L40:L43,$F$28)","v":0.03},{"$f":"INDEX(M40:M43,$F$28)","v":0.03},{"$f":"INDEX(N40:N43,$F$28)","v":0.03},{"$f":"INDEX(O40:O43,$F$28)","v":0.03},{"$f":"INDEX(P40:P43,$F$28)","v":0.03},{"$f":"INDEX(Q40:Q43,$F$28)","v":0.03},{"$f":"INDEX(R40:R43,$F$28)","v":0.03},{"$f":"INDEX(S40:S43,$F$28)","v":0.03},{"$f":"INDEX(T40:T43,$F$28)","v":0.03},{"$f":"INDEX(U40:U43,$F$28)","v":0.03},{"$f":"INDEX(V40:V43,$F$28)","v":0.03},{"$f":"INDEX(W40:W43,$F$28)","v":0.03},{"$f":"INDEX(X40:X43,$F$28)","v":0.03},{"$f":"INDEX(Y40:Y43,$F$28)","v":0.03},{"$f":"INDEX(Z40:Z43,$F$28)","v":0.03},{"$f":"INDEX(AA40:AA43,$F$28)","v":0.03},{"$f":"INDEX(AB40:AB43,$F$28)","v":0.03},{"$f":"INDEX(AC40:AC43,$F$28)","v":0.03},{"$f":"INDEX(AD40:AD43,$F$28)","v":0.03},{"$f":"INDEX(AE40:AE43,$F$28)","v":0.03},{"$f":"INDEX(AF40:AF43,$F$28)","v":0.03},{"$f":"INDEX(AG40:AG43,$F$28)","v":0.03},{"$f":"INDEX(AH40:AH43,$F$28)","v":0.03},{"$f":"INDEX(AI40:AI43,$F$28)","v":0.03},{"$f":"INDEX(AJ40:AJ43,$F$28)","v":0.03},{"$f":"INDEX(AK40:AK43,$F$28)","v":0.03},{"$f":"INDEX(AL40:AL43,$F$28)","v":0.03},{"$f":"INDEX(AM40:AM43,$F$28)","v":0.03},{"$f":"INDEX(AN40:AN43,$F$28)","v":0.03},{"$f":"INDEX(AO40:AO43,$F$28)","v":0.03},{"$f":"INDEX(AP40:AP43,$F$28)","v":0.03},{"$f":"INDEX(AQ40:AQ43,$F$28)","v":0.03},{"$f":"INDEX(AR40:AR43,$F$28)","v":0.03},{"$f":"INDEX(AS40:AS43,$F$28)","v":0.03},{"$f":"INDEX(AT40:AT43,$F$28)","v":0.03},{"$f":"INDEX(AU40:AU43,$F$28)","v":0.03},{"$f":"INDEX(AV40:AV43,$F$28)","v":0.03},{"$f":"INDEX(AW40:AW43,$F$28)","v":0.03},{"$f":"INDEX(AX40:AX43,$F$28)","v":0.03},{"$f":"INDEX(AY40:AY43,$F$28)","v":0.03},{"$f":"INDEX(AZ40:AZ43,$F$28)","v":0.03},{"$f":"INDEX(BA40:BA43,$F$28)","v":0.03},{"$f":"INDEX(BB40:BB43,$F$28)","v":0.03},{"$f":"INDEX(BC40:BC43,$F$28)","v":0.03}]
[]
[null,null,"PPP Exchange",null,null,null,4,{"$f":"G47*(1+H36)/(1+H45)","v":4.233009708737864},{"$f":"H47*(1+I36)/(1+I45)","v":4.4795927985672543},4.7405399518818516,5.0166879102439017,5.3089221574425762,5.6181797588469982,5.9454523661584737,6.2917893971968315,6.6583014009170363,7.046163618446184,7.4566197515595549,7.8909859506795303,8.3506550351851345,8.837100959564852,9.351883539733679,9.8966534546696217,10.473157539407659,11.083244386363445,11.728870272947724,12.41210543447866,13.135140702506543,13.900294529837023,14.710020424778985,15.566914818455432,16.473725390404294,17.43335987916571,18.448895406107404,19.523588342385505,20.660884750679806,21.864431435185427,23.138087635293317,24.485937400456038,25.912302685919499,27.421757211312869,29.019141126534979,30.709576531964203,32.498483902758231,34.391599469909195,36.394993613787406,38.515090329153665,40.758687824055826,43.132980318661019,45.64558111392283,48.304547004054257,51.118404111086548,54.096175224353729,57.247408732568516,60.582209241261829]
[]
[null,"Financing"]
[null,null,"Debt Size"]
[null,null,null,"Target DSCR",null,"x",1.4]
[null,null,null,"Max Debt to Capital",null,"%",0.7]
[]
[null,null,null,"Peruvian Debt in Sol",null,"%",0.6]
[null,null,null,"Tenure",null,"Years",15]
[null,null,null,"Interest Rate",null,"%",7.0000000000000007E-2]
[]
[null,null,null,"US Debt in USD",null,"%",{"$f":"1-G54","v":0.4}]
[null,null,null,"Tenure",null,"Years",17]
[null,null,null,"Interest Rate",null,"%",0.05]
[]
[null,null,null,"Max Debt Tenure",null,null,{"$f":"MAX(G59,G54)","v":17}]

{"sheet":"Model","index":1,"n_rows":167,"n_cols":69,"rows_kept":167,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Time Line"]
[null,null,"Periods",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,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]
[null,null,"Year",null,null,null,null,null,2022,{"$f":"IF(J10,I4,I4+1)","v":2023},{"$f":"IF(K10,J4,J4+1)","v":2023},2024,2024,2025,2025,2026,2026,2027,2027,2028,2028,2029,2029,2030,2030,2031,2031,2032,2032,2033,2033,2034,2034,2035,2035,2036,2036,2037,2037,2038,2038,2039,2039,2040,2040,2041,2041,2042,2042,2043,2043,2044,2044,2045,2045,2046,2046,2047,2047,2048,2048,2049,2049,2050,2050,2051,2051,2052,2052]
[null,null,"Construction",null,null,{"$f":"Inputs!F4","v":1},null,null,{"$f":"I3<$F$5","v":true},{"$f":"J3<$F$5","v":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,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,false,false,false,false,false,false,false,false,false,false]
[null,null,"Operating",null,null,{"$f":"Inputs!F3","v":30},{"$f":"Inputs!F5","v":2},null,{"$f":"AND(NOT(I5),I3<$F$6*$G$6)","v":false},{"$f":"AND(NOT(J5),J3<$F$6*$G$6)","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,true,true,true,true,true,true,true,true,true,true,true,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]
[null,null,"Exchange Rate",null,null,"SOL/USD",null,null,{"$f":"LOOKUP(I4,Inputs!30:30,Inputs!47:47)","v":4},{"$f":"I7*(1+J16)/(1+J17)","v":4.1148558704955214},{"$f":"J7*(1+K16)/(1+K17)","v":4.233009708737864},4.3545562124661341,4.4795927985672543,4.6082196811534821,4.7405399518818516,4.8766596625798986,5.0166879102439008,5.1607369244777566,5.3089221574425753,5.4613623763890828,5.6181797588469973,5.7794999905476701,5.9454523661584728,6.1161698929096699,6.2917893971968306,6.472451634244214,6.6583014009170345,6.8494876517730034,7.0461636184461822,7.2484869324588104,7.4566197515595523,7.6707288896894203,7.8909859506795277,8.1175674657878343,8.350655035185131,8.5904354735036321,8.8371009595648502,9.0908491904067592,9.351883539733679,9.6204132209158928,9.8966534546696217,10.180825641551769,10.473157539407657,10.773883445914008,11.083244386363443,11.401488306841037,11.728870272947722,12.065652674229836,12.41210543447866,12.768506228068469,13.135140702506543,13.512302707373431,13.900294529837023,14.299427136929166,14.710020424778987,15.132403475002711,15.566914818455434,16.013902706556266,16.473725390404294,16.946751407909058,17.433359879165707,17.933940810311526,18.448895406107397,18.978636391494721,19.523588342385498,20.084188025950723,20.660884750679799,21.254140726491542,21.86443143518542]
[]
[null,"Operations"]
[null,null,"Seasonal Flag",null,"Flag",null,null,null,{"$f":"MOD(I3,2)=0","v":true},{"$f":"MOD(J3,2)=0","v":false},true,false,true,false,true,false,true,false,true,false,true,false,true,false,true,false,true,false,true,false,true,false,true,false,true,false,true,false,true,false,true,false,true,false,true,false,true,false,true,false,true,false,true,false,true,false,true,false,true,false,true,false,true,false,true,false,true,false,true]
[null,null,"Generation",null,"MWH",{"$f":"Inputs!F8","v":1000},null,null,{"$f":"$F$11*I6","v":0},{"$f":"$F$11*J6","v":1000},1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,0]
[null,null,"Seasonality",null,"Factor",{"$f":"Inputs!F9","v":1.2},{"$f":"Inputs!G9","v":0.8},null,{"$f":"IF(I10,$F$12,$G$12)","v":1.2},{"$f":"IF(J10,$F$12,$G$12)","v":0.8},1.2,0.8,1.2,0.8,1.2,0.8,1.2,0.8,1.2,0.8,1.2,0.8,1.2,0.8,1.2,0.8,1.2,0.8,1.2,0.8,1.2,0.8,1.2,0.8,1.2,0.8,1.2,0.8,1.2,0.8,1.2,0.8,1.2,0.8,1.2,0.8,1.2,0.8,1.2,0.8,1.2,0.8,1.2,0.8,1.2,0.8,1.2,0.8,1.2,0.8,1.2,0.8,1.2,0.8,1.2,0.8,1.2,0.8,1.2]
[null,null,"Seasonal Generation",null,"MWH",null,null,null,{"$f":"I12*I11","v":0},{"$f":"J12*J11","v":800},1200,800,1200,800,1200,800,1200,800,1200,800,1200,800,1200,800,1200,800,1200,800,1200,800,1200,800,1200,800,1200,800,1200,800,1200,800,1200,800,1200,800,1200,800,1200,800,1200,800,1200,800,1200,800,1200,800,1200,800,1200,800,1200,800,1200,800,1200,800,1200,800,0]
[]
[null,"Macro-econonic"]
[null,null,"Sol Inflation",null,null,null,null,null,{"$f":"(1+LOOKUP(I4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":0},{"$f":"(1+LOOKUP(J4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(K4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(L4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(M4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(N4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(O4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(P4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(Q4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(R4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(S4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(T4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(U4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(V4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(W4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(X4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(Y4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(Z4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(AA4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(AB4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(AC4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(AD4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(AE4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(AF4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(AG4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(AH4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(AI4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(AJ4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(AK4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(AL4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(AM4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(AN4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(AO4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(AP4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(AQ4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(AR4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(AS4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(AT4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(AU4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(AV4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(AW4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(AX4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(AY4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(AZ4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(BA4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(BB4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(BC4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(BD4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(BE4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(BF4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(BG4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(BH4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(BI4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(BJ4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(BK4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(BL4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(BM4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(BN4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(BO4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(BP4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2},{"$f":"(1+LOOKUP(BQ4,Inputs!30:30,Inputs!36:36))^(1/2)-1","v":4.4030650891055068E-2}]
[null,null,"USD Inflation",null,null,null,null,null,{"$f":"(1+LOOKUP(I4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":0},{"$f":"(1+LOOKUP(J4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(K4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(L4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(M4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(N4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(O4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(P4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(Q4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(R4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(S4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(T4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(U4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(V4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(W4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(X4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(Y4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(Z4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(AA4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(AB4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(AC4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(AD4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(AE4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(AF4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(AG4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(AH4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(AI4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(AJ4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(AK4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(AL4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(AM4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(AN4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(AO4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(AP4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(AQ4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(AR4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(AS4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(AT4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(AU4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(AV4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(AW4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(AX4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(AY4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(AZ4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(BA4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(BB4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(BC4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(BD4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(BE4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(BF4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(BG4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(BH4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(BI4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(BJ4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(BK4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(BL4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(BM4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(BN4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(BO4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(BP4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2},{"$f":"(1+LOOKUP(BQ4,Inputs!39:39,Inputs!45:45))^(1/2)-1","v":1.4889156509221957E-2}]
[null,null,"Exchange Rate"]
[]
[null,"Revenues, Op Exp, Cap Exp"]
[null,null,"PPA Price",null,"Sol/MWH",{"$f":"Inputs!F16","v":80},null,null,{"$f":"$F$21","v":80},{"$f":"$F$21","v":80},80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80]
[null,null,"Inflation Index",null,"Index",null,null,1,{"$f":"H22*(1+I16*I6)","v":1},{"$f":"I22*(1+J16*J6)","v":1.0440306508910551},1.0900000000000001,1.1379934094712501,1.1881000000000002,1.2404128163236627,1.2950290000000004,1.3520499697927926,1.4115816100000005,1.4737344670741439,1.5386239549000007,1.606370569110817,1.6771001108410009,1.7509439203307908,1.8280391208166913,1.9085288731605623,1.9925626416901938,2.080296471745013,2.1718932794423114,2.2675231542020646,2.3673636745921196,2.4716002380802506,2.5804264053054107,2.6940442595074732,2.8126647817828978,2.9365082428631464,3.0658046121433591,3.2007939847208298,3.3417270272362618,3.4888654433457047,3.6424824596875256,3.8028633332468185,3.970305881059403,4.1451210332390325,4.3276334103547498,4.5181819262305458,4.7171204172866776,4.924818299591295,5.1416612548424787,5.3680519465545125,5.6044107677783028,5.8511766217444192,6.1088077368783509,6.3777825177014176,6.6586004331974031,6.9517829442945462,7.2578744721851702,7.5774434092810559,7.9110831746818358,8.2594133161163512,8.6230806604032022,9.002760514566825,9.3991579198394923,9.8130089608778412,10.245082132625049,10.696179767356849,11.167139524561305,11.658835946418966,12.172182081771822,12.708131181596674,12.708131181596674]
[null,null,"Inflated Price",null,"Sol/MWH",null,null,null,{"$f":"I21*I22","v":80},{"$f":"J21*J22","v":83.522452071284405},87.2,91.039472757699997,95.048000000000016,99.233025305893023,103.60232000000003,108.16399758342341,112.92652880000004,117.89875736593152,123.08991639200005,128.50964552886535,134.16800886728007,140.07551362646328,146.24312966533529,152.68230985284498,159.40501133521551,166.42371773960105,173.75146235538492,181.40185233616518,189.38909396736958,197.72801904642006,206.43411242443284,215.52354076059785,225.01318254263182,234.92065942905171,245.26436897146874,256.06351877766639,267.33816217890092,279.10923546765639,291.39859677500203,304.22906665974546,317.62447048475224,331.6096826591226,346.21067282837998,361.45455409844368,377.36963338293424,393.98546396730359,411.3329003873983,429.444155724361,448.35286142226425,468.09412973955352,488.70461895026807,510.22260141611343,532.68803465579231,556.14263554356376,580.62995777481365,606.19547274248453,632.8866539745469,660.7530652893081,689.8464528322562,720.22084116534597,751.93263358715944,785.04071687022724,819.60657061000393,855.69438138854798,893.37116196490445,932.70687571351732,973.7745665417458,1016.6504945277338,1016.6504945277338]
[null,null,null,"Revenues","Sol ",null,null,null,{"$f":"I23*I13","v":0},{"$f":"J23*J13","v":66817.961657027525},104640,72831.578206160004,114057.60000000002,79386.42024471442,124322.78400000004,86531.198066738725,135511.83456000005,94319.005892745219,147707.89967040005,102807.71642309228,161001.61064073606,112060.41090117062,175491.75559840235,122145.84788227598,191286.01360225861,133138.97419168084,208501.7548264619,145121.48186893214,227266.91276084349,158182.41523713604,247720.93490931942,172418.83260847829,270015.81905115821,187936.52754324136,294317.24276576249,204850.81502213312,320805.7946146811,223287.38837412512,349678.31613000244,243383.25332779635,381149.36458170268,265287.7461272981,415452.807394056,289163.64327875496,452843.56005952111,315188.37117384287,493599.48046487797,343555.32457948878,538023.4337067171,374475.30379164283,586445.54274032172,408178.08113289077,639225.64158695075,444914.10843485099,696755.94932977634,484956.37819398765,759463.98476945632,528602.45223144651,827815.74339870748,576176.67293227674,902319.16030459129,628032.57349618175,983527.88473200472,684555.50511083833,1072045.3943578852,746165.50057081389,1168529.479850095,813320.39562218706,0]
[]
[null,null,"O&M"]
[null,null,null,"O&M No Inflation","Sol",{"$f":"Inputs!F25","v":24000},null,null,{"$f":"$F$27*I6","v":0},{"$f":"$F$27*J6","v":24000},24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,24000,0]
[null,null,null,"O&M With Inflation","Sol",null,null,null,{"$f":"I27*I22","v":0},{"$f":"J27*J22","v":25056.73562138532},26160.000000000004,27311.84182731,28514.400000000005,29769.907591767907,31080.696000000011,32449.199275027022,33877.958640000012,35369.627209779457,36926.974917600019,38552.89365865961,40250.402660184023,42022.65408793898,43872.938899600587,45804.692955853498,47821.503400564652,49927.115321880308,52125.438706615474,54420.555700849553,56816.728190210873,59318.405713926019,61930.233727329854,64657.062228179355,67503.954762789552,70476.197828715507,73579.310691440623,76819.055633299911,80201.44865367029,83732.77064029692,87419.579032500609,91268.719997923647,95287.341145425671,99482.904797736774,103863.201848514,108436.3662295331,113210.89001488026,118195.63919019108,123399.87011621949,128833.2467173083,134505.85842667927,140428.23892186605,146611.38568508043,153066.78042483403,159806.41039673769,166842.79066306911,174188.98733244409,181858.64182274535,189865.99619236405,198225.91958679244,206953.93584967684,216066.2523496038,225579.79007614782,235512.21506106819,245881.97118300118,256708.31441656439,268011.34858947131,279812.06271405518,292132.36996252375,304995.14835832018,0]
[]
[null,null,"Cap Exp",null,"Sol",{"$f":"Inputs!F24","v":1120000},null,null,{"$f":"$F$30*I5","v":1120000},{"$f":"$F$30*J5","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]
[]
[null,null,"Operating Cash Flow Pre-tax",null,"Sol",null,null,null,{"$f":"I24-I28-I30","v":-1120000},{"$f":"J24-J28-J30","v":41761.226035642205},78480,45519.736378850008,85543.200000000012,49616.512652946512,93242.088000000032,54081.998791711703,101633.87592000003,58949.378682965762,110780.92475280003,64254.822764432669,120751.20798055205,70037.756813231637,131618.81669880176,76341.154926422489,143464.51020169395,83211.858869800533,156376.31611984642,90700.926168082588,170450.18457063261,98864.009523210028,185790.70118198957,107761.77038029893,202511.86428836867,117460.32971452585,220737.93207432187,128031.7593888332,240604.34596101081,139554.6177338282,262258.73709750181,152114.53332987271,285862.023436277,165804.84132956131,311589.60554554197,180727.27704922186,339632.67004464084,196992.73198365179,370199.61034865846,214722.07786218048,403517.57528003782,234047.06486977678,439834.15705524129,255111.30070805675,479419.23119021306,278071.31777178188,522566.96199733228,303097.73637124232,569597.9885770923,330376.53264465404,620861.80754903064,360110.42058267293,676739.37022844353,392520.35843511357,737645.91354900354,427847.19069427392,804034.04576841393,466353.43785675871,876397.10988757131,508325.24726386688,0]
[null,null,"Project IRR",null,"Sol",{"$f":"IRR(I32:BQ32)","v":9.2231352880342676E-2}]
[]
[null,null,"Operating Cash Flow Pre-tax",null,"USD",null,null,null,{"$f":"I32/I7","v":-280000},{"$f":"J32/J7","v":10148.891565092221},18540,10453.358312044989,19096.2,10766.959061406338,19669.086000000007,11089.967833248529,20259.158580000007,11422.666868245988,20866.933337400005,11765.346874293364,21492.941337522007,12118.307280522169,22137.729577647671,12481.856498937836,22801.861464977108,12856.312193905973,23485.917308926422,13242.001559723152,24190.494828194216,13639.261606514847,24916.209673040044,14048.439454710293,25663.695963231246,14469.892638351603,26433.606842128185,14903.989417502151,27226.615047392021,15351.10910002721,28043.413498813778,15811.64237302802,28884.715903778193,16285.99164421887,29751.257380891544,16774.571393545437,30643.795102318298,17277.8085353518,31563.108955387841,17796.142791412352,32510.002224049476,18330.027075154725,33485.302290770967,18879.927887409369,34489.861359494091,19446.325724031649,35524.557200278912,20029.715495752604,36590.293916287286,20630.606960625177,37688.002733775909,21249.525169443932,38818.642815789201,21887.010924527258,39983.202100262883,22543.621252263081,41182.698163270776,23219.929889830983,42418.179108168901,23916.527786525905,0]
[null,null,"Project IRR",null,"USD",{"$f":"IRR(I35:BQ35)","v":6.1744456919521129E-2}]
[]
[null,null,"LCOE"]
[null,null,null,"Real Revenues",null,null,null,null,{"$f":"I24/I22","v":0},{"$f":"J24/J22","v":64000},96000,64000,96000,64000.000000000007,96000,64000,96000,64000.000000000007,95999.999999999985,63999.999999999993,95999.999999999985,64000,95999.999999999985,63999.999999999993,96000,64000.000000000007,96000,64000,96000,64000,96000,64000,96000,64000,96000,64000,95999.999999999985,64000.000000000007,96000,63999.999999999993,96000,64000.000000000007,96000,64000.000000000007,96000.000000000015,64000,96000,63999.999999999993,96000,64000,96000,64000.000000000007,96000,64000.000000000007,96000,64000.000000000007,96000.000000000015,64000.000000000007,96000.000000000015,63999.999999999993,96000,63999.999999999993,96000,64000,96000,64000.000000000007,96000,64000,0]
[null,null,null,"PV of Real Revenues",0.04,{"$f":"NPV(E40,J39:BQ39)","v":1793655.8339779947}]
[null,null,null,"PV of Generation",0.04,{"$f":"NPV(E41,J13:BQ13)","v":22420.697924724926}]
[null,null,null,"Real LCOE","SOL/MWH",{"$f":"F40/F41","v":80.000000000000028}]
[]
[null,"Part 1: Aggregate Debt Portion"]
[null,null,"Maximum Debt Tenure",null,"Years",{"$f":"Inputs!G62*2","v":34},null,null,{"$f":"AND(I6,I3<=$F$45)","v":false},{"$f":"AND(J6,J3<=$F$45)","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,true,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,false]
[null,null,"CFADS over Tenure",null,"Sol",null,null,null,{"$f":"IF(I45,I24-I28)","v":false},{"$f":"IF(J45,J24-J28)","v":41761.226035642205},78480,45519.736378850008,85543.200000000012,49616.512652946512,93242.088000000032,54081.998791711703,101633.87592000003,58949.378682965762,110780.92475280003,64254.822764432669,120751.20798055205,70037.756813231637,131618.81669880176,76341.154926422489,143464.51020169395,83211.858869800533,156376.31611984642,90700.926168082588,170450.18457063261,98864.009523210028,185790.70118198957,107761.77038029893,202511.86428836867,117460.32971452585,220737.93207432187,128031.7593888332,240604.34596101081,139554.6177338282,262258.73709750181,152114.53332987271,285862.023436277,165804.84132956131,311589.60554554197,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,false]
[null,null,"Target Debt Service",null,"Sol",{"$f":"Inputs!G51","v":1.4},null,null,{"$f":"IF(I45,I46/$F$47)","v":false},{"$f":"IF(J45,J46/$F$47)","v":29829.447168315863},56057.142857142862,32514.097413464293,61102.285714285725,35440.366180676079,66601.491428571462,38629.999136936931,72595.625657142882,42106.699059261264,79129.231966285734,45896.301974594768,86250.862843251467,50026.969152308317,94013.440499144126,54529.39637601607,102474.65014406711,59437.042049857526,111697.36865703316,64786.375834344712,121750.13183616615,70617.149659435745,132707.64370142113,76972.693128784958,144651.33163454905,83900.235510375613,157669.9514816585,91451.256706309432,171860.24711500775,99681.869809877287,187327.66935535846,108653.23809276623,204187.15959734074,118432.02952111523,222564.00396110141,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,false]
[]
[null,null,"Debt IRR",null,"% s.a.",{"$f":"F144","v":4.440790260216132E-2}]
[null,null,"Debt Amount from DSCR",null,"Sol",{"$f":"NPV(F49,I47:BQ47)","v":1351367.4867551003}]
[]
[null,null,"Debt to Capital from DSCR",null,"%",{"$f":"F50/F30","v":1.2065781131741966}]
[]
[null,null,"Target Maximum Debt",null,"%",{"$f":"Inputs!G52","v":0.7}]
[null,null,"Target Maximum Debt",null,"Sol",{"$f":"F54*F30","v":784000}]
[]
[null,null,"PV of CFADS in Base Currency",null,"Sol",{"$f":"NPV(F49,I46:BQ46)","v":1891914.4814571401}]
[null,null,"Max DSCR in Base Currency",null,"Sol",{"$f":"F57/F55","v":2.4131562263483928}]
[]
[null,null,"CFADS over Tenure",null,"Sol"]
[null,null,"Target Debt Service",null,"Sol",{"$f":"F58","v":2.4131562263483928},null,null,{"$f":"IF(I45,I46/$F$61)","v":false},{"$f":"IF(J45,J46/$F$61)","v":17305.64543632371},32521.723684154738,18863.153525592843,35448.678815728672,20560.8373428962,38639.059909144256,22411.312703756863,42116.575300967241,24428.330847094981,45907.067078054286,26626.880623333524,50038.703115079181,29023.299879433554,54542.186395436322,31635.396868582575,59450.983171025604,34482.582586755016,64801.571656417917,37586.015019562969,70633.713105495539,40968.756371323638,76990.747284990139,44655.944444742767,83919.914540639264,48674.979444769626,91472.70684929681,53055.727594798904,99705.250465733508,57830.743078330801,108678.72300764953,63035.509955380563,118459.80807833801,68708.705851364837,129121.19080538844,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,false]
[]
[null,null,"Target Aggregate Debt Service Applied",null,"Sol",{"$f":"IF(F61>F47,TRUE,FALSE)","v":true},null,null,{"$f":"IF($F$63,I61,I47)","v":false},{"$f":"IF($F$63,J61,J47)","v":17305.64543632371},32521.723684154738,18863.153525592843,35448.678815728672,20560.8373428962,38639.059909144256,22411.312703756863,42116.575300967241,24428.330847094981,45907.067078054286,26626.880623333524,50038.703115079181,29023.299879433554,54542.186395436322,31635.396868582575,59450.983171025604,34482.582586755016,64801.571656417917,37586.015019562969,70633.713105495539,40968.756371323638,76990.747284990139,44655.944444742767,83919.914540639264,48674.979444769626,91472.70684929681,53055.727594798904,99705.250465733508,57830.743078330801,108678.72300764953,63035.509955380563,118459.80807833801,68708.705851364837,129121.19080538844,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,false]
[null,null,"Final Debt Amount",null,"Sol",{"$f":"F49","v":4.440790260216132E-2}]
[null,null,"Total Aggregate Debt from PV of DS",null,"Sol",{"$f":"NPV(F64,I63:BQ63)","v":784000.00000000023}]
[]
[null,"Part 2: SOL Debt - Shorter Tenure"]
[null,null,"Debt Percent",null,"%",{"$f":"Inputs!G54","v":0.6}]
[null,null,"Debt Amount",null,"Sol",{"$f":"F68*F65","v":470400.00000000012}]
[]
[null,null,"LLCR or Target DSCR for Short-tenure"]
[null,null,null,"Tenure of Short-term Issue","Year",{"$f":"Inputs!G55","v":15},{"$f":"I4+F72","v":2037},null,{"$f":"AND(I6,I4<=$G$72)","v":false},{"$f":"AND(J6,J4<=$G$72)","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,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,false,false,false,false,false]
[null,null,null,"CFADS over Tenure","Sol",null,null,null,{"$f":"IF(I72,I46)","v":false},{"$f":"IF(J72,J46)","v":41761.226035642205},78480,45519.736378850008,85543.200000000012,49616.512652946512,93242.088000000032,54081.998791711703,101633.87592000003,58949.378682965762,110780.92475280003,64254.822764432669,120751.20798055205,70037.756813231637,131618.81669880176,76341.154926422489,143464.51020169395,83211.858869800533,156376.31611984642,90700.926168082588,170450.18457063261,98864.009523210028,185790.70118198957,107761.77038029893,202511.86428836867,117460.32971452585,220737.93207432187,128031.7593888332,240604.34596101081,139554.6177338282,262258.73709750181,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,false,false,false,false,false]
[null,null,null,"Interest Rate for Issue in Base Currency","% p.p",{"$f":"Inputs!G56/2","v":3.5000000000000003E-2}]
[null,null,null,"PV of CFADS","Sol",{"$f":"NPV(F74,I73:BQ73)","v":1929989.4500438031}]
[null,null,null,"Debt Amount","Sol",{"$f":"F69","v":470400.00000000012}]
[null,null,null,"LLCR or Target DSCR","x",{"$f":"IFERROR(F75/F76,FALSE)","v":4.102868728834614}]
[]
[null,null,null,"Debt Service for Issue","Sol",{"$f":"F77","v":4.102868728834614},{"$f":"NPV(F74,I79:BQ79)","v":470400.00000000035},null,{"$f":"IF(AND(I72,$F$79),I73/$F$79)","v":false},{"$f":"IF(AND(J72,$F$79),J73/$F$79)","v":10178.543062357283},19128.079689327911,11094.611937969439,20849.606861367425,12093.127012386691,22726.071478890499,13181.508443501494,24771.417911990644,14367.844203416629,27000.845524069799,15660.950181724123,29430.921621236084,17070.435698079302,32079.704567147339,18606.774910906439,34966.877978190605,20281.384652888024,38113.896996227762,22106.709271647946,41544.147725888266,24096.313106096266,45283.12102121822,26264.981285644928,49358.601913127866,28628.829601352976,53800.876085309377,31205.42426547475,58642.954932987217,34013.912449367483,63920.820876956073,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,false,false,false,false,false]
[]
[null,null,null,"Opening Balance","Sol",null,null,null,{"$f":"H84","v":0},{"$f":"I84","v":470400.00000000012},476685.45693764283,474241.36824113241,479745.20419160259,475686.67947694124,480242.58624624752,474325.0052859757,477744.87202748336,469694.52463645465,471765.98879531393,461276.95287908014,461760.69604812382,448491.39878857206,447118.16204809275,430687.59315262863,427154.88400206418,407138.42696394585,401106.88725479593,377031.73131248605,368121.13263677515,339461.22455317399,327246.05430643883,293416.54518594599,277421.14298180916,237772.28107304461,217465.48130924819,171275.89706976252,146065.12920172946,92534.453790802771,61759.24722411338,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9]
[null,null,null,"Add: Draw","Sol",{"$f":"F76","v":470400.00000000012},null,null,{"$f":"$F$82*I5","v":470400.00000000012},{"$f":"$F$82*J5","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]
[null,null,null,"Less: Repayment (DS - Interest)","Sol",{"$f":"SUM(I83:BQ83)","v":470399.99999999884},null,null,{"$f":"(I79-I85)*I72","v":0},{"$f":"(J79-J85)*J72","v":-6285.4569376427244},2444.088696510411,-5503.8359504701984,4058.5247146613328,-4555.9067693062552,5917.5809602718327,-3419.8667415076561,8050.3473910287248,-2071.4641588592858,10489.03591623381,-483.74316904368243,13269.297259551749,1373.2367404792785,16430.568895464094,3532.7091505644348,20016.457038118358,6031.5397091499181,24075.155942309902,8910.5986757109331,28659.908083601134,12215.170246735175,33829.509120492861,15995.402204136817,39648.861908764549,20306.799763796414,46189.584239485688,25210.767868033061,53530.675410926684,30775.206566689387,61759.247224112107,0,0,0,0,0,0,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,"Closing Balance","Sol",null,null,null,{"$f":"I81+I82-I83","v":470400.00000000012},{"$f":"J81+J82-J83","v":476685.45693764283},474241.36824113241,479745.20419160259,475686.67947694124,480242.58624624752,474325.0052859757,477744.87202748336,469694.52463645465,471765.98879531393,461276.95287908014,461760.69604812382,448491.39878857206,447118.16204809275,430687.59315262863,427154.88400206418,407138.42696394585,401106.88725479593,377031.73131248605,368121.13263677515,339461.22455317399,327246.05430643883,293416.54518594599,277421.14298180916,237772.28107304461,217465.48130924819,171275.89706976252,146065.12920172946,92534.453790802771,61759.24722411338,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9,1.2732925824820995E-9]
[null,null,null,"Interest Expense","%",{"$f":"Inputs!G56/2","v":3.5000000000000003E-2},null,null,{"$f":"$F$85*I81","v":0},{"$f":"$F$85*J81","v":16464.000000000007},16683.9909928175,16598.447888439638,16791.082146706092,16649.033781692946,16808.490518618666,16601.37518500915,16721.070520961919,16439.308362275915,16511.809607835989,16144.693350767806,16161.624361684335,15697.198957600023,15649.135671683247,15074.065760342004,14950.420940072248,14249.844943738106,14038.741053917858,13196.110595937012,12884.239642287132,11881.142859361091,11453.61190072536,10269.579081508111,9709.7400043633206,8322.0298375565617,7611.2918458236873,5994.6563974416886,5112.2795220605312,3238.7058826780972,2161.5736528439684,4.456524038687349E-11,4.456524038687349E-11,4.456524038687349E-11,4.456524038687349E-11,4.456524038687349E-11,4.456524038687349E-11,4.456524038687349E-11,4.456524038687349E-11,4.456524038687349E-11,4.456524038687349E-11,4.456524038687349E-11,4.456524038687349E-11,4.456524038687349E-11,4.456524038687349E-11,4.456524038687349E-11,4.456524038687349E-11,4.456524038687349E-11,4.456524038687349E-11,4.456524038687349E-11,4.456524038687349E-11,4.456524038687349E-11,4.456524038687349E-11,4.456524038687349E-11,4.456524038687349E-11,4.456524038687349E-11,4.456524038687349E-11,4.456524038687349E-11,4.456524038687349E-11,4.456524038687349E-11,4.456524038687349E-11]
[]
[null,null,null,"Check","Lookup",{"$f":"LOOKUP(G72,4:4,84:84)","v":1.2732925824820995E-9}]
[]
[null,"Step 3: USD Debt - Alternate Currency - Longer Tenure"]
[null,null,"USD/SOL Exchange Rate",null,"USD/Sol",null,null,null,{"$f":"1/I7","v":0.25},{"$f":"1/J7","v":0.24302187767261396},{"$f":"1/K7","v":0.23623853211009174},{"$f":"1/L7","v":0.22964452660806642},{"$f":"1/M7","v":0.22323457621412338},{"$f":"1/N7","v":0.21700354349202602},{"$f":"1/O7","v":0.21094643440417163},{"$f":"1/P7","v":0.20505839430897874},{"$f":"1/Q7","v":0.19933470406999707},{"$f":"1/R7","v":0.1937707762736221},{"$f":"1/S7","v":0.18836215155238253},{"$f":"1/T7","v":0.18310449501085391},{"$f":"1/U7","v":0.17799359275133395},{"$f":"1/V7","v":0.17302534849649498},{"$f":"1/W7","v":0.16819578030630639},{"$f":"1/X7","v":0.16350101738659617},{"$f":"1/Y7","v":0.15893729698669321},{"$f":"1/Z7","v":0.15450096138366426},{"$f":"1/AA7","v":0.15018845495072844},{"$f":"1/AB7","v":0.14599632130749926},{"$f":"1/AC7","v":0.14192120054977089},{"$f":"1/AD7","v":0.13795982655662772},{"$f":"1/AE7","v":0.13410902437271929},{"$f":"1/AF7","v":0.13036570766360234},{"$f":"1/AG7","v":0.12672687624211085},{"$f":"1/AH7","v":0.12318961366377101},{"$f":"1/AI7","v":0.11975108488933411},{"$f":"1/AJ7","v":0.11640853401255423},{"$f":"1/AK7","v":0.11315928205138909},{"$f":"1/AL7","v":0.11000072480085396},{"$f":"1/AM7","v":0.106930330745808},{"$f":"1/AN7","v":0.1039456390319996},{"$f":"1/AO7","v":0.10104425749374518},{"$f":"1/AP7","v":9.8223860736660187E-2},{"$f":"1/AQ7","v":9.5482188273906005E-2},{"$f":"1/AR7","v":9.2817042714458703E-2},{"$f":"1/AS7","v":9.0226288001947874E-2},{"$f":"1/AT7","v":8.7707847702653649E-2},{"$f":"1/AU7","v":8.5259703341290183E-2},{"$f":"1/AV7","v":8.287989278324151E-2},{"$f":"1/AW7","v":8.0566508661953098E-2},{"$f":"1/AX7","v":7.8317696850219026E-2},{"$f":"1/AY7","v":7.6131654974139151E-2},{"$f":"1/AZ7","v":7.4006630968555587E-2},{"$f":"1/BA7","v":7.1940921672810396E-2},{"$f":"1/BB7","v":6.9932871465699306E-2},{"$f":"1/BC7","v":6.7980870938527241E-2},{"$f":"1/BD7","v":6.6083355605202093E-2},{"$f":"1/BE7","v":6.4238804648333078E-2},{"$f":"1/BF7","v":6.2445739700328587E-2},{"$f":"1/BG7","v":6.0702723658516582E-2},{"$f":"1/BH7","v":5.9008359533338023E-2},{"$f":"1/BI7","v":5.7361289328689988E-2},{"$f":"1/BJ7","v":5.5760192953521255E-2},{"$f":"1/BK7","v":5.420378716380797E-2},{"$f":"1/BL7","v":5.2690824534061369E-2},{"$f":"1/BM7","v":5.1220092457543311E-2},{"$f":"1/BN7","v":4.9790412174388267E-2},{"$f":"1/BO7","v":4.8400637826852853E-2},{"$f":"1/BP7","v":4.7049655540935702E-2},{"$f":"1/BQ7","v":4.5736382533631596E-2}]
[null,null,"Percent Change in Exchange Rate",null,"%",null,null,null,null,{"$f":"J90/I90-1","v":-2.7912489309544153E-2},{"$f":"K90/J90-1","v":-2.7912489309544264E-2},-2.7912489309544042E-2,-2.7912489309544375E-2,-2.7912489309544264E-2,-2.7912489309544264E-2,-2.7912489309544153E-2,-2.7912489309544264E-2,-2.7912489309544264E-2,-2.7912489309544264E-2,-2.7912489309544264E-2,-2.7912489309544264E-2,-2.7912489309544153E-2,-2.7912489309544264E-2,-2.7912489309544153E-2,-2.7912489309544153E-2,-2.7912489309544375E-2,-2.7912489309544153E-2,-2.7912489309544264E-2,-2.7912489309544264E-2,-2.7912489309544264E-2,-2.7912489309544153E-2,-2.7912489309544375E-2,-2.7912489309544375E-2,-2.7912489309544042E-2,-2.7912489309544264E-2,-2.7912489309544375E-2,-2.7912489309544264E-2,-2.7912489309544486E-2,-2.7912489309544264E-2,-2.7912489309544264E-2,-2.7912489309544153E-2,-2.7912489309544264E-2,-2.7912489309544153E-2,-2.7912489309544375E-2,-2.7912489309544153E-2,-2.7912489309544153E-2,-2.7912489309544375E-2,-2.7912489309544153E-2,-2.7912489309544375E-2,-2.7912489309544264E-2,-2.7912489309544375E-2,-2.7912489309544153E-2,-2.7912489309544153E-2,-2.7912489309544375E-2,-2.7912489309544264E-2,-2.7912489309544264E-2,-2.7912489309544264E-2,-2.7912489309544153E-2,-2.7912489309544264E-2,-2.7912489309544153E-2,-2.7912489309544153E-2,-2.7912489309544264E-2,-2.7912489309544264E-2,-2.7912489309544264E-2,-2.7912489309544264E-2,-2.7912489309544264E-2,-2.7912489309544264E-2,-2.7912489309544264E-2,-2.7912489309544264E-2]
[]
[null,null,"SOL/USD Exchange Rate",null,"Sol/USD",null,null,null,{"$f":"I7","v":4},{"$f":"J7","v":4.1148558704955214},{"$f":"K7","v":4.233009708737864},{"$f":"L7","v":4.3545562124661341},{"$f":"M7","v":4.4795927985672543},{"$f":"N7","v":4.6082196811534821},{"$f":"O7","v":4.7405399518818516},{"$f":"P7","v":4.8766596625798986},{"$f":"Q7","v":5.0166879102439008},{"$f":"R7","v":5.1607369244777566},{"$f":"S7","v":5.3089221574425753},{"$f":"T7","v":5.4613623763890828},{"$f":"U7","v":5.6181797588469973},{"$f":"V7","v":5.7794999905476701},{"$f":"W7","v":5.9454523661584728},{"$f":"X7","v":6.1161698929096699},{"$f":"Y7","v":6.2917893971968306},{"$f":"Z7","v":6.472451634244214},{"$f":"AA7","v":6.6583014009170345},{"$f":"AB7","v":6.8494876517730034},{"$f":"AC7","v":7.0461636184461822},{"$f":"AD7","v":7.2484869324588104},{"$f":"AE7","v":7.4566197515595523},{"$f":"AF7","v":7.6707288896894203},{"$f":"AG7","v":7.8909859506795277},{"$f":"AH7","v":8.1175674657878343},{"$f":"AI7","v":8.350655035185131},{"$f":"AJ7","v":8.5904354735036321},{"$f":"AK7","v":8.8371009595648502},{"$f":"AL7","v":9.0908491904067592},{"$f":"AM7","v":9.351883539733679},{"$f":"AN7","v":9.6204132209158928},{"$f":"AO7","v":9.8966534546696217},{"$f":"AP7","v":10.180825641551769},{"$f":"AQ7","v":10.473157539407657},{"$f":"AR7","v":10.773883445914008},{"$f":"AS7","v":11.083244386363443},{"$f":"AT7","v":11.401488306841037},{"$f":"AU7","v":11.728870272947722},{"$f":"AV7","v":12.065652674229836},{"$f":"AW7","v":12.41210543447866},{"$f":"AX7","v":12.768506228068469},{"$f":"AY7","v":13.135140702506543},{"$f":"AZ7","v":13.512302707373431},{"$f":"BA7","v":13.900294529837023},{"$f":"BB7","v":14.299427136929166},{"$f":"BC7","v":14.710020424778987},{"$f":"BD7","v":15.132403475002711},{"$f":"BE7","v":15.566914818455434},{"$f":"BF7","v":16.013902706556266},{"$f":"BG7","v":16.473725390404294},{"$f":"BH7","v":16.946751407909058},{"$f":"BI7","v":17.433359879165707},{"$f":"BJ7","v":17.933940810311526},{"$f":"BK7","v":18.448895406107397},{"$f":"BL7","v":18.978636391494721},{"$f":"BM7","v":19.523588342385498},{"$f":"BN7","v":20.084188025950723},{"$f":"BO7","v":20.660884750679799},{"$f":"BP7","v":21.254140726491542},{"$f":"BQ7","v":21.86443143518542}]
[null,null,"Percent Change in Exchange Rate",null,"%",null,null,null,null,{"$f":"J93/I93-1","v":2.8713967623880343E-2},{"$f":"K93/J93-1","v":2.8713967623880343E-2},2.8713967623880343E-2,2.8713967623880565E-2,2.8713967623880343E-2,2.8713967623880343E-2,2.8713967623880343E-2,2.8713967623880343E-2,2.8713967623880343E-2,2.8713967623880565E-2,2.8713967623880343E-2,2.8713967623880343E-2,2.8713967623880343E-2,2.8713967623880343E-2,2.8713967623880343E-2,2.8713967623880565E-2,2.8713967623880343E-2,2.8713967623880343E-2,2.8713967623880343E-2,2.8713967623880343E-2,2.8713967623880565E-2,2.8713967623880343E-2,2.8713967623880343E-2,2.8713967623880565E-2,2.8713967623880343E-2,2.8713967623880343E-2,2.8713967623880565E-2,2.8713967623880565E-2,2.8713967623880565E-2,2.8713967623880565E-2,2.8713967623880565E-2,2.8713967623880343E-2,2.8713967623880343E-2,2.8713967623880343E-2,2.8713967623880343E-2,2.8713967623880343E-2,2.8713967623880343E-2,2.8713967623880565E-2,2.8713967623880343E-2,2.8713967623880565E-2,2.8713967623880343E-2,2.8713967623880565E-2,2.8713967623880565E-2,2.8713967623880343E-2,2.8713967623880565E-2,2.8713967623880343E-2,2.8713967623880343E-2,2.8713967623880343E-2,2.8713967623880343E-2,2.8713967623880343E-2,2.8713967623880343E-2,2.8713967623880343E-2,2.8713967623880343E-2,2.8713967623880343E-2,2.8713967623880343E-2,2.8713967623880343E-2,2.8713967623880343E-2,2.8713967623880343E-2,2.8713967623880343E-2,2.8713967623880565E-2]
[]
[null,null,"Interest Rate in USD",null,"%",{"$f":"Inputs!G60/2","v":2.5000000000000001E-2},null,null,{"$f":"$F$96","v":2.5000000000000001E-2},{"$f":"$F$96","v":2.5000000000000001E-2},2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2]
[null,null,"Yield Changed to SOL",null,"%","(1+US Int) * (1+Chg)-1",null,null,{"$f":"(1+I96)*(1+I94)-1","v":2.4999999999999911E-2},{"$f":"(1+J96)*(1+J94)-1","v":5.4431816814477285E-2},5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477507E-2,5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477507E-2,5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477507E-2,5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477507E-2,5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477507E-2,5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477507E-2,5.4431816814477507E-2,5.4431816814477507E-2,5.4431816814477507E-2,5.4431816814477507E-2,5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477507E-2,5.4431816814477285E-2,5.4431816814477507E-2,5.4431816814477285E-2,5.4431816814477507E-2,5.4431816814477507E-2,5.4431816814477285E-2,5.4431816814477507E-2,5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477285E-2,5.4431816814477507E-2]
[]
[null,null,"USD Balance"]
[null,null,null,"Aggregate Debt Service in Base Currency","Sol","DS = CFAD/DSCR - other",null,null,{"$f":"I63","v":false},{"$f":"J63","v":17305.64543632371},{"$f":"K63","v":32521.723684154738},{"$f":"L63","v":18863.153525592843},{"$f":"M63","v":35448.678815728672},{"$f":"N63","v":20560.8373428962},{"$f":"O63","v":38639.059909144256},{"$f":"P63","v":22411.312703756863},{"$f":"Q63","v":42116.575300967241},{"$f":"R63","v":24428.330847094981},{"$f":"S63","v":45907.067078054286},{"$f":"T63","v":26626.880623333524},{"$f":"U63","v":50038.703115079181},{"$f":"V63","v":29023.299879433554},{"$f":"W63","v":54542.186395436322},{"$f":"X63","v":31635.396868582575},{"$f":"Y63","v":59450.983171025604},{"$f":"Z63","v":34482.582586755016},{"$f":"AA63","v":64801.571656417917},{"$f":"AB63","v":37586.015019562969},{"$f":"AC63","v":70633.713105495539},{"$f":"AD63","v":40968.756371323638},{"$f":"AE63","v":76990.747284990139},{"$f":"AF63","v":44655.944444742767},{"$f":"AG63","v":83919.914540639264},{"$f":"AH63","v":48674.979444769626},{"$f":"AI63","v":91472.70684929681},{"$f":"AJ63","v":53055.727594798904},{"$f":"AK63","v":99705.250465733508},{"$f":"AL63","v":57830.743078330801},{"$f":"AM63","v":108678.72300764953},{"$f":"AN63","v":63035.509955380563},{"$f":"AO63","v":118459.80807833801},{"$f":"AP63","v":68708.705851364837},{"$f":"AQ63","v":129121.19080538844},{"$f":"AR63","v":false},{"$f":"AS63","v":false},{"$f":"AT63","v":false},{"$f":"AU63","v":false},{"$f":"AV63","v":false},{"$f":"AW63","v":false},{"$f":"AX63","v":false},{"$f":"AY63","v":false},{"$f":"AZ63","v":false},{"$f":"BA63","v":false},{"$f":"BB63","v":false},{"$f":"BC63","v":false},{"$f":"BD63","v":false},{"$f":"BE63","v":false},{"$f":"BF63","v":false},{"$f":"BG63","v":false},{"$f":"BH63","v":false},{"$f":"BI63","v":false},{"$f":"BJ63","v":false},{"$f":"BK63","v":false},{"$f":"BL63","v":false},{"$f":"BM63","v":false},{"$f":"BN63","v":false},{"$f":"BO63","v":false},{"$f":"BP63","v":false},{"$f":"BQ63","v":false}]
[null,null,null,"Less: Shorter-tenure Currency","Sol",null,null,null,{"$f":"I79","v":false},{"$f":"J79","v":10178.543062357283},{"$f":"K79","v":19128.079689327911},{"$f":"L79","v":11094.611937969439},{"$f":"M79","v":20849.606861367425},{"$f":"N79","v":12093.127012386691},{"$f":"O79","v":22726.071478890499},{"$f":"P79","v":13181.508443501494},{"$f":"Q79","v":24771.417911990644},{"$f":"R79","v":14367.844203416629},{"$f":"S79","v":27000.845524069799},{"$f":"T79","v":15660.950181724123},{"$f":"U79","v":29430.921621236084},{"$f":"V79","v":17070.435698079302},{"$f":"W79","v":32079.704567147339},{"$f":"X79","v":18606.774910906439},{"$f":"Y79","v":34966.877978190605},{"$f":"Z79","v":20281.384652888024},{"$f":"AA79","v":38113.896996227762},{"$f":"AB79","v":22106.709271647946},{"$f":"AC79","v":41544.147725888266},{"$f":"AD79","v":24096.313106096266},{"$f":"AE79","v":45283.12102121822},{"$f":"AF79","v":26264.981285644928},{"$f":"AG79","v":49358.601913127866},{"$f":"AH79","v":28628.829601352976},{"$f":"AI79","v":53800.876085309377},{"$f":"AJ79","v":31205.42426547475},{"$f":"AK79","v":58642.954932987217},{"$f":"AL79","v":34013.912449367483},{"$f":"AM79","v":63920.820876956073},{"$f":"AN79","v":false},{"$f":"AO79","v":false},{"$f":"AP79","v":false},{"$f":"AQ79","v":false},{"$f":"AR79","v":false},{"$f":"AS79","v":false},{"$f":"AT79","v":false},{"$f":"AU79","v":false},{"$f":"AV79","v":false},{"$f":"AW79","v":false},{"$f":"AX79","v":false},{"$f":"AY79","v":false},{"$f":"AZ79","v":false},{"$f":"BA79","v":false},{"$f":"BB79","v":false},{"$f":"BC79","v":false},{"$f":"BD79","v":false},{"$f":"BE79","v":false},{"$f":"BF79","v":false},{"$f":"BG79","v":false},{"$f":"BH79","v":false},{"$f":"BI79","v":false},{"$f":"BJ79","v":false},{"$f":"BK79","v":false},{"$f":"BL79","v":false},{"$f":"BM79","v":false},{"$f":"BN79","v":false},{"$f":"BO79","v":false},{"$f":"BP79","v":false},{"$f":"BQ79","v":false}]
[null,null,null,"Net Debt Service for Sculpting in Base Currency","Sol",null,null,null,{"$f":"IF(I45,I100-I101)","v":false},{"$f":"IF(J45,J100-J101)","v":7127.102373966427},{"$f":"IF(K45,K100-K101)","v":13393.643994826827},{"$f":"IF(L45,L100-L101)","v":7768.5415876234038},{"$f":"IF(M45,M100-M101)","v":14599.071954361247},{"$f":"IF(N45,N100-N101)","v":8467.7103305095097},{"$f":"IF(O45,O100-O101)","v":15912.988430253758},{"$f":"IF(P45,P100-P101)","v":9229.8042602553687},{"$f":"IF(Q45,Q100-Q101)","v":17345.157388976597},{"$f":"IF(R45,R100-R101)","v":10060.486643678352},{"$f":"IF(S45,S100-S101)","v":18906.221553984487},{"$f":"IF(T45,T100-T101)","v":10965.9304416094},{"$f":"IF(U45,U100-U101)","v":20607.781493843097},{"$f":"IF(V45,V100-V101)","v":11952.864181354253},{"$f":"IF(W45,W100-W101)","v":22462.481828288983},{"$f":"IF(X45,X100-X101)","v":13028.621957676136},{"$f":"IF(Y45,Y100-Y101)","v":24484.105192834999},{"$f":"IF(Z45,Z100-Z101)","v":14201.197933866992},{"$f":"IF(AA45,AA100-AA101)","v":26687.674660190154},{"$f":"IF(AB45,AB100-AB101)","v":15479.305747915023},{"$f":"IF(AC45,AC100-AC101)","v":29089.565379607273},{"$f":"IF(AD45,AD100-AD101)","v":16872.443265227372},{"$f":"IF(AE45,AE100-AE101)","v":31707.626263771919},{"$f":"IF(AF45,AF100-AF101)","v":18390.963159097839},{"$f":"IF(AG45,AG100-AG101)","v":34561.312627511397},{"$f":"IF(AH45,AH100-AH101)","v":20046.14984341665},{"$f":"IF(AI45,AI100-AI101)","v":37671.830763987433},{"$f":"IF(AJ45,AJ100-AJ101)","v":21850.303329324153},{"$f":"IF(AK45,AK100-AK101)","v":41062.295532746291},{"$f":"IF(AL45,AL100-AL101)","v":23816.830628963318},{"$f":"IF(AM45,AM100-AM101)","v":44757.902130693459},{"$f":"IF(AN45,AN100-AN101)","v":63035.509955380563},{"$f":"IF(AO45,AO100-AO101)","v":118459.80807833801},{"$f":"IF(AP45,AP100-AP101)","v":68708.705851364837},{"$f":"IF(AQ45,AQ100-AQ101)","v":129121.19080538844},{"$f":"IF(AR45,AR100-AR101)","v":false},{"$f":"IF(AS45,AS100-AS101)","v":false},{"$f":"IF(AT45,AT100-AT101)","v":false},{"$f":"IF(AU45,AU100-AU101)","v":false},{"$f":"IF(AV45,AV100-AV101)","v":false},{"$f":"IF(AW45,AW100-AW101)","v":false},{"$f":"IF(AX45,AX100-AX101)","v":false},{"$f":"IF(AY45,AY100-AY101)","v":false},{"$f":"IF(AZ45,AZ100-AZ101)","v":false},{"$f":"IF(BA45,BA100-BA101)","v":false},{"$f":"IF(BB45,BB100-BB101)","v":false},{"$f":"IF(BC45,BC100-BC101)","v":false},{"$f":"IF(BD45,BD100-BD101)","v":false},{"$f":"IF(BE45,BE100-BE101)","v":false},{"$f":"IF(BF45,BF100-BF101)","v":false},{"$f":"IF(BG45,BG100-BG101)","v":false},{"$f":"IF(BH45,BH100-BH101)","v":false},{"$f":"IF(BI45,BI100-BI101)","v":false},{"$f":"IF(BJ45,BJ100-BJ101)","v":false},{"$f":"IF(BK45,BK100-BK101)","v":false},{"$f":"IF(BL45,BL100-BL101)","v":false},{"$f":"IF(BM45,BM100-BM101)","v":false},{"$f":"IF(BN45,BN100-BN101)","v":false},{"$f":"IF(BO45,BO100-BO101)","v":false},{"$f":"IF(BP45,BP100-BP101)","v":false},{"$f":"IF(BQ45,BQ100-BQ101)","v":false}]
[null,null,null,"Conversion to Currency of the Issue","USD",null,null,null,{"$f":"IF(I45,I102*I90)","v":false},{"$f":"IF(J45,J102*J90)","v":1732.0418012862656},{"$f":"IF(K45,K102*K90)","v":3164.0947969430349},{"$f":"IF(L45,L102*L90)","v":1784.0030553248532},{"$f":"IF(M45,M102*M90)","v":3259.0176408513266},{"$f":"IF(N45,N102*N90)","v":1837.5231469845985},{"$f":"IF(O45,O102*O90)","v":3356.7881700768662},{"$f":"IF(P45,P102*P90)","v":1892.6488413941372},{"$f":"IF(Q45,Q102*Q90)","v":3457.491815179173},{"$f":"IF(R45,R102*R90)","v":1949.4283066359612},{"$f":"IF(S45,S102*S90)","v":3561.2165696345473},{"$f":"IF(T45,T102*T90)","v":2007.9111558350394},{"$f":"IF(U45,U102*U90)","v":3668.0530667235844},{"$f":"IF(V45,V102*V90)","v":2068.1484905100915},{"$f":"IF(W45,W102*W90)","v":3778.0946587252934},{"$f":"IF(X45,X102*X90)","v":2130.1929452253944},{"$f":"IF(Y45,Y102*Y90)","v":3891.4374984870537},{"$f":"IF(Z45,Z102*Z90)","v":2194.0987335821569},{"$f":"IF(AA45,AA102*AA90)","v":4008.1806234416658},{"$f":"IF(AB45,AB102*AB90)","v":2259.9216955896218},{"$f":"IF(AC45,AC102*AC90)","v":4128.4260421449162},{"$f":"IF(AD45,AD102*AD90)","v":2327.7193464573097},{"$f":"IF(AE45,AE102*AE90)","v":4252.2788234092623},{"$f":"IF(AF45,AF102*AF90)","v":2397.5509268510295},{"$f":"IF(AG45,AG102*AG90)","v":4379.8471881115402},{"$f":"IF(AH45,AH102*AH90)","v":2469.4774546565609},{"$f":"IF(AI45,AI102*AI90)","v":4511.2426037548876},{"$f":"IF(AJ45,AJ102*AJ90)","v":2543.5617782962577},{"$f":"IF(AK45,AK102*AK90)","v":4646.5798818675321},{"$f":"IF(AL45,AL102*AL90)","v":2619.8686316451435},{"$f":"IF(AM45,AM102*AM90)","v":4785.9772783235567},{"$f":"IF(AN45,AN102*AN90)","v":6552.2663640200053},{"$f":"IF(AO45,AO102*AO90)","v":11969.683350127221},{"$f":"IF(AP45,AP102*AP90)","v":6748.834354940609},{"$f":"IF(AQ45,AQ102*AQ90)","v":12328.77385063104},{"$f":"IF(AR45,AR102*AR90)","v":false},{"$f":"IF(AS45,AS102*AS90)","v":false},{"$f":"IF(AT45,AT102*AT90)","v":false},{"$f":"IF(AU45,AU102*AU90)","v":false},{"$f":"IF(AV45,AV102*AV90)","v":false},{"$f":"IF(AW45,AW102*AW90)","v":false},{"$f":"IF(AX45,AX102*AX90)","v":false},{"$f":"IF(AY45,AY102*AY90)","v":false},{"$f":"IF(AZ45,AZ102*AZ90)","v":false},{"$f":"IF(BA45,BA102*BA90)","v":false},{"$f":"IF(BB45,BB102*BB90)","v":false},{"$f":"IF(BC45,BC102*BC90)","v":false},{"$f":"IF(BD45,BD102*BD90)","v":false},{"$f":"IF(BE45,BE102*BE90)","v":false},{"$f":"IF(BF45,BF102*BF90)","v":false},{"$f":"IF(BG45,BG102*BG90)","v":false},{"$f":"IF(BH45,BH102*BH90)","v":false},{"$f":"IF(BI45,BI102*BI90)","v":false},{"$f":"IF(BJ45,BJ102*BJ90)","v":false},{"$f":"IF(BK45,BK102*BK90)","v":false},{"$f":"IF(BL45,BL102*BL90)","v":false},{"$f":"IF(BM45,BM102*BM90)","v":false},{"$f":"IF(BN45,BN102*BN90)","v":false},{"$f":"IF(BO45,BO102*BO90)","v":false},{"$f":"IF(BP45,BP102*BP90)","v":false},{"$f":"IF(BQ45,BQ102*BQ90)","v":false}]
[]
[null,null,null,"PV of Debt Service","USD",{"$f":"NPV(G105,I103:BQ103)","v":78400.0000000008},{"$f":"F96","v":2.5000000000000001E-2}]
[]
[null,null,null,"Opening Balance","USD",null,null,null,{"$f":"H110","v":0},{"$f":"I110","v":78400.0000000008},78627.95819871455,77429.562356739378,77581.298360333007,76261.813178490003,76330.835360967656,74882.318074914976,74861.727185393713,73275.778549849376,73158.244706959653,71425.984254999101,71203.722705539039,69315.762706453927,68980.508283605188,66926.926331970026,66469.906545043879,64240.216710182925,63652.123394355345,61235.245855772562,60506.205306577256,57890.434397096775,57009.975910566885,54182.946484921798,53139.969220193816,50088.621262587119,48871.359339495233,45581.900719227728,44177.886458912166,40635.753738517436,39031.778950335225,35221.596145770047,29549.869685394293,18318.933077401929,12028.072049396367,2.3646862246096134E-10,2.4238033802248538E-10,2.4843984647304753E-10,2.5465084263487374E-10,2.6101711370074557E-10,2.6754254154326418E-10,2.742311050818458E-10,2.8108688270889193E-10,2.8811405477661421E-10,2.9531690614602957E-10,3.026998287996803E-10,3.1026732451967233E-10,3.1802400763266413E-10,3.2597460782348073E-10,3.3412397301906777E-10,3.4247707234454446E-10,3.5103899915315808E-10,3.5981497413198702E-10,3.6881034848528671E-10,3.7803060719741889E-10,3.8748137237735435E-10,3.9716840668678822E-10,4.0709761685395794E-10,4.1727505727530687E-10,4.2770693370718956E-10,4.3839960704986932E-10]
[null,null,null,"Add: Draws","USD",{"$f":"F105","v":78400.0000000008},null,null,{"$f":"$F$108*I5","v":78400.0000000008},{"$f":"$F$108*J5","v":0},{"$f":"$F$108*K5","v":0},{"$f":"$F$108*L5","v":0},{"$f":"$F$108*M5","v":0},{"$f":"$F$108*N5","v":0},{"$f":"$F$108*O5","v":0},{"$f":"$F$108*P5","v":0},{"$f":"$F$108*Q5","v":0},{"$f":"$F$108*R5","v":0},{"$f":"$F$108*S5","v":0},{"$f":"$F$108*T5","v":0},{"$f":"$F$108*U5","v":0},{"$f":"$F$108*V5","v":0},{"$f":"$F$108*W5","v":0},{"$f":"$F$108*X5","v":0},{"$f":"$F$108*Y5","v":0},{"$f":"$F$108*Z5","v":0},{"$f":"$F$108*AA5","v":0},{"$f":"$F$108*AB5","v":0},{"$f":"$F$108*AC5","v":0},{"$f":"$F$108*AD5","v":0},{"$f":"$F$108*AE5","v":0},{"$f":"$F$108*AF5","v":0},{"$f":"$F$108*AG5","v":0},{"$f":"$F$108*AH5","v":0},{"$f":"$F$108*AI5","v":0},{"$f":"$F$108*AJ5","v":0},{"$f":"$F$108*AK5","v":0},{"$f":"$F$108*AL5","v":0},{"$f":"$F$108*AM5","v":0},{"$f":"$F$108*AN5","v":0},{"$f":"$F$108*AO5","v":0},{"$f":"$F$108*AP5","v":0},{"$f":"$F$108*AQ5","v":0},{"$f":"$F$108*AR5","v":0},{"$f":"$F$108*AS5","v":0},{"$f":"$F$108*AT5","v":0},{"$f":"$F$108*AU5","v":0},{"$f":"$F$108*AV5","v":0},{"$f":"$F$108*AW5","v":0},{"$f":"$F$108*AX5","v":0},{"$f":"$F$108*AY5","v":0},{"$f":"$F$108*AZ5","v":0},{"$f":"$F$108*BA5","v":0},{"$f":"$F$108*BB5","v":0},{"$f":"$F$108*BC5","v":0},{"$f":"$F$108*BD5","v":0},{"$f":"$F$108*BE5","v":0},{"$f":"$F$108*BF5","v":0},{"$f":"$F$108*BG5","v":0},{"$f":"$F$108*BH5","v":0},{"$f":"$F$108*BI5","v":0},{"$f":"$F$108*BJ5","v":0},{"$f":"$F$108*BK5","v":0},{"$f":"$F$108*BL5","v":0},{"$f":"$F$108*BM5","v":0},{"$f":"$F$108*BN5","v":0},{"$f":"$F$108*BO5","v":0},{"$f":"$F$108*BP5","v":0},{"$f":"$F$108*BQ5","v":0}]
[null,null,null,"Less: Repayment","USD",null,null,null,{"$f":"I103-I111","v":0},{"$f":"J103-J111","v":-227.95819871375443},{"$f":"K103-K111","v":1198.3958419751712},-151.73600359363127,1319.4851818430013,-69.022182477651768,1448.5172860526748,20.590889521262625,1585.94863554433,117.53384288972666,1732.2604519605559,222.26154946006181,1887.9599990851084,335.25442284874316,2053.5819516351635,457.01978692614375,2229.6898348609566,588.09331582758364,2416.8775385827821,729.04054919530768,2615.770909480485,880.45848652989025,2827.0294256450898,1042.9772647279844,3051.3479576066948,1217.2619230918829,3289.4586202675064,1404.0142603155643,3542.1327203947276,1603.9747881822077,3810.182804565176,5671.726460375754,11230.936607992364,6290.8610280055609,12028.072049396131,-5.9117155615240335E-12,-6.0595084505621349E-12,-6.2109961618261886E-12,-6.3662710658718437E-12,-6.5254278425186396E-12,-6.6885635385816048E-12,-6.8557776270461451E-12,-7.0271720677222984E-12,-7.2028513694153553E-12,-7.3829226536507391E-12,-7.5674957199920084E-12,-7.7566831129918092E-12,-7.9506001908166035E-12,-8.1493651955870182E-12,-8.353099325476694E-12,-8.5619268086136125E-12,-8.7759749788289527E-12,-8.9953743532996767E-12,-9.2202587121321682E-12,-9.4507651799354735E-12,-9.687034309433859E-12,-9.9292101671697067E-12,-1.017744042134895E-11,-1.0431876431882672E-11,-1.069267334267974E-11,-1.0959990176246734E-11]
[null,null,null,"Closing Balance","USD",null,null,null,{"$f":"I107+I108-I109","v":78400.0000000008},{"$f":"J107+J108-J109","v":78627.95819871455},77429.562356739378,77581.298360333007,76261.813178490003,76330.835360967656,74882.318074914976,74861.727185393713,73275.778549849376,73158.244706959653,71425.984254999101,71203.722705539039,69315.762706453927,68980.508283605188,66926.926331970026,66469.906545043879,64240.216710182925,63652.123394355345,61235.245855772562,60506.205306577256,57890.434397096775,57009.975910566885,54182.946484921798,53139.969220193816,50088.621262587119,48871.359339495233,45581.900719227728,44177.886458912166,40635.753738517436,39031.778950335225,35221.596145770047,29549.869685394293,18318.933077401929,12028.072049396367,2.3646862246096134E-10,2.4238033802248538E-10,2.4843984647304753E-10,2.5465084263487374E-10,2.6101711370074557E-10,2.6754254154326418E-10,2.742311050818458E-10,2.8108688270889193E-10,2.8811405477661421E-10,2.9531690614602957E-10,3.026998287996803E-10,3.1026732451967233E-10,3.1802400763266413E-10,3.2597460782348073E-10,3.3412397301906777E-10,3.4247707234454446E-10,3.5103899915315808E-10,3.5981497413198702E-10,3.6881034848528671E-10,3.7803060719741889E-10,3.8748137237735435E-10,3.9716840668678822E-10,4.0709761685395794E-10,4.1727505727530687E-10,4.2770693370718956E-10,4.3839960704986932E-10,4.4935959722611606E-10]
[null,null,null,"Interest Expense","USD",{"$f":"F96","v":2.5000000000000001E-2},null,null,{"$f":"$F$111*I107","v":0},{"$f":"$F$111*J107","v":1960.00000000002},1965.6989549678638,1935.7390589184845,1939.5324590083253,1906.5453294622503,1908.2708840241914,1872.0579518728746,1871.543179634843,1831.8944637462346,1828.9561176739915,1785.6496063749776,1780.093067638476,1732.8940676613483,1724.5127070901299,1673.1731582992506,1661.7476636260972,1606.0054177545733,1591.3030848588837,1530.8811463943141,1512.6551326644314,1447.2608599274195,1425.2493977641723,1354.5736621230451,1328.4992305048454,1252.215531564678,1221.783983487381,1139.5475179806933,1104.4471614728043,1015.8938434629359,975.79447375838072,880.53990364425124,738.74674213485741,457.97332693504825,300.70180123490917,5.9117155615240335E-12,6.0595084505621349E-12,6.2109961618261886E-12,6.3662710658718437E-12,6.5254278425186396E-12,6.6885635385816048E-12,6.8557776270461451E-12,7.0271720677222984E-12,7.2028513694153553E-12,7.3829226536507391E-12,7.5674957199920084E-12,7.7566831129918092E-12,7.9506001908166035E-12,8.1493651955870182E-12,8.353099325476694E-12,8.5619268086136125E-12,8.7759749788289527E-12,8.9953743532996767E-12,9.2202587121321682E-12,9.4507651799354735E-12,9.687034309433859E-12,9.9292101671697067E-12,1.017744042134895E-11,1.0431876431882672E-11,1.069267334267974E-11,1.0959990176246734E-11]
[]
[null,null,null,"Closing Balance Test","Lookup",{"$f":"I4+F45/2","v":2039},{"$f":"ROUND(LOOKUP(F113,4:4,110:110),0)=0","v":true}]
[]
[null,null,"SOL Balance"]
[null,null,null,"Opening Balance","Sol",null,null,null,{"$f":"H120","v":0},{"$f":"I120","v":313600.0000000032},323542.71537905704,327760.08919940161,337832.12474617676,341621.86912004516,351749.25778929732,354982.62052365893,365075.16523607052,367601.71236473875,377550.45478918601,379194.99042850919,388869.33224287187,389428.41500644089,398672.84697306954,397910.85252012487,406541.24119531666,404185.91437075549,411985.29008690949,407722.72326698934,414436.50610304292,407905.47270486853,413236.06540753541,404021.62895716185,407622.29709454696,395248.6066719825,396716.55658311263,380638.72875432746,379507.28298105451,359102.25835529307,354832.01607079024,329388.26523877378,284281.95699770871,181296.13232633114,122455.7043389264,2.2014319256413728E-9,2.328335905105672E-9,2.462350679921209E-9,2.6038691377360024E-9,2.7533057193078072E-9,2.911097596489235E-9,3.0777059144708681E-9,3.2536171017840008E-9,3.4393442517553868E-9,3.6354285793074302E-9,3.8424409572093444E-9,4.0609835361083756E-9,4.2916914529059497E-9,4.5352346322922461E-9,4.7923196865147749E-9,5.0636919187330296E-9,5.3501374356026757E-9,5.6524853750401253E-9,5.9716102554423756E-9,6.3084344529787176E-9,6.6639308139312307E-9,7.0391254094409098E-9,7.43510044041688E-9,7.852997300788591E-9,8.2940198077263146E-9,8.7594376079249095E-9]
[null,null,null,"Add: Draws","Sol",null,null,null,{"$f":"I108*I7","v":313600.0000000032},{"$f":"J108*J7","v":0},{"$f":"K108*K7","v":0},{"$f":"L108*L7","v":0},{"$f":"M108*M7","v":0},{"$f":"N108*N7","v":0},{"$f":"O108*O7","v":0},{"$f":"P108*P7","v":0},{"$f":"Q108*Q7","v":0},{"$f":"R108*R7","v":0},{"$f":"S108*S7","v":0},{"$f":"T108*T7","v":0},{"$f":"U108*U7","v":0},{"$f":"V108*V7","v":0},{"$f":"W108*W7","v":0},{"$f":"X108*X7","v":0},{"$f":"Y108*Y7","v":0},{"$f":"Z108*Z7","v":0},{"$f":"AA108*AA7","v":0},{"$f":"AB108*AB7","v":0},{"$f":"AC108*AC7","v":0},{"$f":"AD108*AD7","v":0},{"$f":"AE108*AE7","v":0},{"$f":"AF108*AF7","v":0},{"$f":"AG108*AG7","v":0},{"$f":"AH108*AH7","v":0},{"$f":"AI108*AI7","v":0},{"$f":"AJ108*AJ7","v":0},{"$f":"AK108*AK7","v":0},{"$f":"AL108*AL7","v":0},{"$f":"AM108*AM7","v":0},{"$f":"AN108*AN7","v":0},{"$f":"AO108*AO7","v":0},{"$f":"AP108*AP7","v":0},{"$f":"AQ108*AQ7","v":0},{"$f":"AR108*AR7","v":0},{"$f":"AS108*AS7","v":0},{"$f":"AT108*AT7","v":0},{"$f":"AU108*AU7","v":0},{"$f":"AV108*AV7","v":0},{"$f":"AW108*AW7","v":0},{"$f":"AX108*AX7","v":0},{"$f":"AY108*AY7","v":0},{"$f":"AZ108*AZ7","v":0},{"$f":"BA108*BA7","v":0},{"$f":"BB108*BB7","v":0},{"$f":"BC108*BC7","v":0},{"$f":"BD108*BD7","v":0},{"$f":"BE108*BE7","v":0},{"$f":"BF108*BF7","v":0},{"$f":"BG108*BG7","v":0},{"$f":"BH108*BH7","v":0},{"$f":"BI108*BI7","v":0},{"$f":"BJ108*BJ7","v":0},{"$f":"BK108*BK7","v":0},{"$f":"BL108*BL7","v":0},{"$f":"BM108*BM7","v":0},{"$f":"BN108*BN7","v":0},{"$f":"BO108*BO7","v":0},{"$f":"BP108*BP7","v":0},{"$f":"BQ108*BQ7","v":0}]
[null,null,null,"Less: Repayment","Sol",null,null,null,{"$f":"I109*I7","v":0},{"$f":"J109*J7","v":-938.01513220487698},{"$f":"K109*K7","v":5072.8212339919864},{"$f":"L109*L7","v":-660.74295710343074},{"$f":"M109*M7","v":5910.7563184001128},{"$f":"N109*N7","v":-318.06937972968188},{"$f":"O109*O7","v":6866.7540655241773},{"$f":"P109*P7","v":100.41476034498056},{"$f":"Q109*Q7","v":7956.2093462030507},{"$f":"R109*R7","v":606.56124287677983},{"$f":"S109*S7","v":9196.4358958748853},{"$f":"T109*T7","v":1213.850863939123},{"$f":"U109*U7","v":10606.898652372751},{"$f":"V109*V7","v":1937.6029336853758},{"$f":"W109*W7","v":12209.473673449616},{"$f":"X109*X7","v":2795.2106612616726},{"$f":"Y109*Y7","v":14028.738862015718},{"$f":"Z109*Z7","v":3806.4055431163424},{"$f":"AA109*AA7","v":16092.299100990653},{"$f":"AB109*AB7","v":4993.5542393550686},{"$f":"AC109*AC7","v":18431.149816571276},{"$f":"AD109*AD7","v":6381.9918341843713},{"$f":"AE109*AE7","v":21080.083453505235},{"$f":"AF109*AF7","v":8000.3958358382006},{"$f":"AG109*AG7","v":24078.143864109101},{"$f":"AH109*AH7","v":9881.2057842330014},{"$f":"AI109*AI7","v":27469.134190369987},{"$f":"AJ109*AJ7","v":12061.093907119786},{"$f":"AK109*AK7","v":31302.184462306301},{"$f":"AL109*AL7","v":14581.492904579076},{"$f":"AM109*AM7","v":35632.385853389373},{"$f":"AN109*AN7","v":54564.352224817405},{"$f":"AO109*AO7","v":111148.68758066314},{"$f":"AP109*AP7","v":64046.15926135773},{"$f":"AQ109*AQ7","v":125971.89346867159},{"$f":"AR109*AR7","v":-6.3692134425256014E-11},{"$f":"AS109*AS7","v":-6.7159013018814633E-11},{"$f":"AT109*AT7","v":-7.0814600112895851E-11},{"$f":"AU109*AU7","v":-7.466916745403148E-11},{"$f":"AV109*AV7","v":-7.8733545898578856E-11},{"$f":"AW109*AW7","v":-8.3019155846084557E-11},{"$f":"AX109*AX7","v":-8.753803932919117E-11},{"$f":"AY109*AY7","v":-9.2302893850256228E-11},{"$f":"AZ109*AZ7","v":-9.7327108059759533E-11},{"$f":"BA109*BA7","v":-1.0262479937675121E-10},{"$f":"BB109*BB7","v":-1.0821085365704904E-10},{"$f":"BC109*BC7","v":-1.1410096702064777E-10},{"$f":"BD109*BD7","v":-1.2031168995587038E-10},{"$f":"BE109*BE7","v":-1.2686047382418852E-10},{"$f":"BF109*BF7","v":-1.3376571989638454E-10},{"$f":"BG109*BG7","v":-1.4104683105784128E-10},{"$f":"BH109*BH7","v":-1.4872426632824421E-10},{"$f":"BI109*BI7","v":-1.5681959834889074E-10},{"$f":"BJ109*BJ7","v":-1.6535557399913749E-10},{"$f":"BK109*BK7","v":-1.743561783123113E-10},{"$f":"BL109*BL7","v":-1.8384670187067937E-10},{"$f":"BM109*BM7","v":-1.9385381186885006E-10},{"$f":"BN109*BN7","v":-2.0440562704528347E-10},{"$f":"BO109*BO7","v":-2.1553179669246069E-10},{"$f":"BP109*BP7","v":-2.2726358396771992E-10},{"$f":"BQ109*BQ7","v":-2.3963395373885249E-10}]
[null,null,null,"Add: Loss on Translation","Sol","Use Sol/USD",null,null,{"$f":"I116*I94","v":0},{"$f":"J116*J94","v":9004.7002468489682},{"$f":"K116*K94","v":9290.1950543365765},{"$f":"L116*L94","v":9411.2925896717516},{"$f":"M116*M94","v":9700.5006922685006},{"$f":"N116*N94","v":9809.3192895224638},{"$f":"O116*O94","v":10100.116799885824},{"$f":"P116*P94","v":10192.959472756544},{"$f":"Q116*Q94","v":10482.756474871296},{"$f":"R116*R94","v":10555.303667324082},{"$f":"S116*S94","v":10840.97153519807},{"$f":"T116*T94","v":10888.19267830183},{"$f":"U116*U94","v":11165.981415941791},{"$f":"V116*V94","v":11182.034900313982},{"$f":"W116*W94","v":11447.479220504922},{"$f":"X116*X94","v":11425.599336453492},{"$f":"Y116*Y94","v":11673.412037454542},{"$f":"Z116*Z94","v":11605.781259270347},{"$f":"AA116*AA94","v":11829.73228107047},{"$f":"AB116*AB94","v":11707.337075408657},{"$f":"AC116*AC94","v":11900.116418396863},{"$f":"AD116*AD94","v":11712.584536851293},{"$f":"AE116*AE94","v":11865.647003131671},{"$f":"AF116*AF94","v":11601.063973223343},{"$f":"AG116*AG94","v":11704.453441544647},{"$f":"AH116*AH94","v":11349.155695363123},{"$f":"AI116*AI94","v":11391.30636158479},{"$f":"AJ116*AJ94","v":10929.648133846815},{"$f":"AK116*AK94","v":10897.159836544879},{"$f":"AL116*AL94","v":10311.25062007628},{"$f":"AM116*AM94","v":10188.63502137294},{"$f":"AN116*AN94","v":9458.0439837523336},{"$f":"AO116*AO94","v":8162.8629092855517},{"$f":"AP116*AP94","v":5205.7312739529989},{"$f":"AQ116*AQ94","v":3516.1891297473962},{"$f":"AR116*AR94","v":6.3211845039042944E-11},{"$f":"AS116*AS94","v":6.6855761796722405E-11},{"$f":"AT116*AT94","v":7.0703857701897345E-11},{"$f":"AU116*AU94","v":7.4767414117773379E-11},{"$f":"AV116*AV94","v":7.9058331282848952E-11},{"$f":"AW116*AW94","v":8.358916213554842E-11},{"$f":"AX116*AX94","v":8.8373147983941551E-11},{"$f":"AY116*AY94","v":9.3424256121129912E-11},{"$f":"AZ116*AZ94","v":9.8757219492283908E-11},{"$f":"BA116*BA94","v":1.0438757852516287E-10},{"$f":"BB116*BB94","v":1.1033172524198176E-10},{"$f":"BC116*BC94","v":1.16606949776927E-10},{"$f":"BD116*BD94","v":1.2323148943042542E-10},{"$f":"BE116*BE94","v":1.3022458039834043E-10},{"$f":"BF116*BF94","v":1.3760651232186963E-10},{"$f":"BG116*BG94","v":1.4539868581180474E-10},{"$f":"BH116*BH94","v":1.5362367310920542E-10},{"$f":"BI116*BI94","v":1.6230528205335929E-10},{"$f":"BJ116*BJ94","v":1.7146862353720419E-10},{"$f":"BK116*BK94","v":1.811401826402022E-10},{"$f":"BL116*BL94","v":1.9134789363899995E-10},{"$f":"BM116*BM94","v":2.0212121910711974E-10},{"$f":"BN116*BN94","v":2.1349123332642877E-10},{"$f":"BO116*BO94","v":2.2549071024526334E-10},{"$f":"BP116*BP94","v":2.3815421623087568E-10},{"$f":"BQ116*BQ94","v":2.5151820787735768E-10}]
[null,null,null,"Closing Balance","Sol",null,null,null,{"$f":"I116+I117-I118+I119","v":313600.0000000032},{"$f":"J116+J117-J118+J119","v":323542.71537905704},327760.08919940161,337832.12474617676,341621.86912004516,351749.25778929732,354982.62052365893,365075.16523607052,367601.71236473875,377550.45478918601,379194.99042850919,388869.33224287187,389428.41500644089,398672.84697306954,397910.85252012487,406541.24119531666,404185.91437075549,411985.29008690949,407722.72326698934,414436.50610304292,407905.47270486853,413236.06540753541,404021.62895716185,407622.29709454696,395248.6066719825,396716.55658311263,380638.72875432746,379507.28298105451,359102.25835529307,354832.01607079024,329388.26523877378,284281.95699770871,181296.13232633114,122455.7043389264,2.2014319256413728E-9,2.328335905105672E-9,2.462350679921209E-9,2.6038691377360024E-9,2.7533057193078072E-9,2.911097596489235E-9,3.0777059144708681E-9,3.2536171017840008E-9,3.4393442517553868E-9,3.6354285793074302E-9,3.8424409572093444E-9,4.0609835361083756E-9,4.2916914529059497E-9,4.5352346322922461E-9,4.7923196865147749E-9,5.0636919187330296E-9,5.3501374356026757E-9,5.6524853750401253E-9,5.9716102554423756E-9,6.3084344529787176E-9,6.6639308139312307E-9,7.0391254094409098E-9,7.43510044041688E-9,7.852997300788591E-9,8.2940198077263146E-9,8.7594376079249095E-9,9.2505897695411199E-9]
[null,null,null,"Interest Expense","Sol",null,null,null,{"$f":"I111*I7","v":0},{"$f":"J111*J7","v":8065.1175061713038},{"$f":"K111*K7","v":8320.8227608348407},{"$f":"L111*L7","v":8429.2845447268355},{"$f":"M111*M7","v":8688.315635961133},{"$f":"N111*N7","v":8785.7797102391924},{"$f":"O111*O7","v":9046.2343647295784},{"$f":"P111*P7","v":9129.3894999103886},{"$f":"Q111*Q7","v":9388.9480427735452},{"$f":"R111*R7","v":9453.9254008015723},{"$f":"S111*S7","v":9709.7856581096039},{"$f":"T111*T7","v":9752.079577670278},{"$f":"U111*U7","v":10000.882841470344},{"$f":"V111*V7","v":10015.261247668876},{"$f":"W111*W7","v":10253.008154839366},{"$f":"X111*X7","v":10233.411296414462},{"$f":"Y111*Y7","v":10455.366330819283},{"$f":"Z111*Z7","v":10394.79239075065},{"$f":"AA111*AA7","v":10595.375559199503},{"$f":"AB111*AB7","v":10485.751508559953},{"$f":"AC111*AC7","v":10658.415563036},{"$f":"AD111*AD7","v":10490.451431043},{"$f":"AE111*AE7","v":10627.542810266683},{"$f":"AF111*AF7","v":10390.567323259638},{"$f":"AG111*AG7","v":10483.168763402298},{"$f":"AH111*AH7","v":10164.94405918365},{"$f":"AI111*AI7","v":10202.696573617444},{"$f":"AJ111*AJ7","v":9789.2094222043652},{"$f":"AK111*AK7","v":9760.1110704399944},{"$f":"AL111*AL7","v":9235.3377243842424},{"$f":"AM111*AM7","v":9125.5162773040884},{"$f":"AN111*AN7","v":8471.1577305631617},{"$f":"AO111*AO7","v":7311.120497674865},{"$f":"AP111*AP7","v":4662.5465900071104},{"$f":"AQ111*AQ7","v":3149.2973367168515},{"$f":"AR111*AR7","v":6.3692134425256014E-11},{"$f":"AS111*AS7","v":6.7159013018814633E-11},{"$f":"AT111*AT7","v":7.0814600112895851E-11},{"$f":"AU111*AU7","v":7.466916745403148E-11},{"$f":"AV111*AV7","v":7.8733545898578856E-11},{"$f":"AW111*AW7","v":8.3019155846084557E-11},{"$f":"AX111*AX7","v":8.753803932919117E-11},{"$f":"AY111*AY7","v":9.2302893850256228E-11},{"$f":"AZ111*AZ7","v":9.7327108059759533E-11},{"$f":"BA111*BA7","v":1.0262479937675121E-10},{"$f":"BB111*BB7","v":1.0821085365704904E-10},{"$f":"BC111*BC7","v":1.1410096702064777E-10},{"$f":"BD111*BD7","v":1.2031168995587038E-10},{"$f":"BE111*BE7","v":1.2686047382418852E-10},{"$f":"BF111*BF7","v":1.3376571989638454E-10},{"$f":"BG111*BG7","v":1.4104683105784128E-10},{"$f":"BH111*BH7","v":1.4872426632824421E-10},{"$f":"BI111*BI7","v":1.5681959834889074E-10},{"$f":"BJ111*BJ7","v":1.6535557399913749E-10},{"$f":"BK111*BK7","v":1.743561783123113E-10},{"$f":"BL111*BL7","v":1.8384670187067937E-10},{"$f":"BM111*BM7","v":1.9385381186885006E-10},{"$f":"BN111*BN7","v":2.0440562704528347E-10},{"$f":"BO111*BO7","v":2.1553179669246069E-10},{"$f":"BP111*BP7","v":2.2726358396771992E-10},{"$f":"BQ111*BQ7","v":2.3963395373885249E-10}]
[null,null,null,"Interest Expense - Loss","Sol",null,null,null,{"$f":"I121+I119","v":0},{"$f":"J121+J119","v":17069.817753020274},{"$f":"K121+K119","v":17611.017815171417},17840.577134398587,18388.816328229634,18595.098999761656,19146.3511646154,19322.348972666932,19871.704517644841,20009.229068125656,20550.757193307676,20640.272255972108,21166.864257412133,21197.296147982859,21700.487375344288,21659.010632867954,22128.778368273823,22000.573650020997,22425.107840269971,22193.088583968609,22558.531981432861,22203.035967894291,22493.189813398356,21991.631296482981,22187.622204946943,21514.099754546773,21594.002935202232,20718.857556051182,20657.270906984872,19546.588344460521,19314.151298677029,17929.201714315495,15473.983406960417,9868.2778639601092,6665.4864664642482,1.2690397946429896E-10,1.3401477481553703E-10,1.415184578147932E-10,1.4943658157180485E-10,1.577918771814278E-10,1.6660831798163298E-10,1.7591118731313272E-10,1.8572714997138613E-10,1.9608432755204344E-10,2.0701237790191407E-10,2.1854257889903079E-10,2.3070791679757477E-10,2.435431793862958E-10,2.5708505422252894E-10,2.7137223221825415E-10,2.86445516869646E-10,3.0234793943744963E-10,3.1912488040225003E-10,3.3682419753634168E-10,3.554963609525135E-10,3.7519459550967935E-10,3.9597503097596983E-10,4.1789686037171227E-10,4.4102250693772403E-10,4.6541780019859557E-10,4.9115216161621022E-10]
[null,null,null,"Yield with the Loss","Sol",null,null,null,{"$f":"IF(I116>0.1,I122/I116)","v":false},{"$f":"IF(J116>0.1,J122/J116)","v":5.4431816814477361E-2},{"$f":"IF(K116>0.1,K122/K116)","v":5.4431816814477355E-2},5.4431816814477355E-2,5.4431816814477584E-2,5.4431816814477355E-2,5.4431816814477348E-2,5.4431816814477355E-2,5.4431816814477355E-2,5.4431816814477361E-2,5.443181681447759E-2,5.4431816814477361E-2,5.4431816814477355E-2,5.4431816814477368E-2,5.4431816814477368E-2,5.4431816814477361E-2,5.4431816814477577E-2,5.4431816814477361E-2,5.4431816814477355E-2,5.4431816814477355E-2,5.4431816814477361E-2,5.443181681447759E-2,5.4431816814477368E-2,5.4431816814477375E-2,5.4431816814477597E-2,5.4431816814477375E-2,5.4431816814477368E-2,5.4431816814477604E-2,5.4431816814477597E-2,5.4431816814477597E-2,5.4431816814477604E-2,5.4431816814477604E-2,5.4431816814477382E-2,5.4431816814477389E-2,5.443181681447741E-2,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,false]
[]
[null,null,null,"Debt Service SOL","Sol",null,null,null,{"$f":"I118+I121","v":0},{"$f":"J118+J121","v":7127.102373966427},13393.643994826827,7768.5415876234047,14599.071954361247,8467.7103305095097,15912.988430253756,9229.8042602553687,17345.157388976597,10060.486643678352,18906.221553984491,10965.930441609402,20607.781493843097,11952.864181354251,22462.481828288983,13028.621957676136,24484.105192834999,14201.197933866992,26687.674660190154,15479.305747915023,29089.565379607277,16872.443265227372,31707.626263771919,18390.963159097839,34561.312627511397,20046.14984341665,37671.830763987433,21850.303329324153,41062.295532746299,23816.830628963318,44757.902130693459,63035.509955380563,118459.80807833801,68708.705851364837,129121.19080538844,0,0,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,"Debt Issued in SOL","Sol",null,null,null,{"$f":"I117","v":313600.0000000032},{"$f":"J117","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]
[null,null,null,"Debt Cash Flow in SOL","Sol",null,null,null,{"$f":"I125-I126","v":-313600.0000000032},{"$f":"J125-J126","v":7127.102373966427},13393.643994826827,7768.5415876234047,14599.071954361247,8467.7103305095097,15912.988430253756,9229.8042602553687,17345.157388976597,10060.486643678352,18906.221553984491,10965.930441609402,20607.781493843097,11952.864181354251,22462.481828288983,13028.621957676136,24484.105192834999,14201.197933866992,26687.674660190154,15479.305747915023,29089.565379607277,16872.443265227372,31707.626263771919,18390.963159097839,34561.312627511397,20046.14984341665,37671.830763987433,21850.303329324153,41062.295532746299,23816.830628963318,44757.902130693459,63035.509955380563,118459.80807833801,68708.705851364837,129121.19080538844,0,0,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,"Debt IRR for Issue","Sol",{"$f":"IRR(I127:BQ127)","v":5.4431816814477729E-2}]
[]
[null,"Step 4: Debt IRR"]
[null,null,"Total Debt Service"]
[null,null,null,"Debt Service Issue 1","Sol",null,null,null,{"$f":"I79","v":false},{"$f":"J79","v":10178.543062357283},{"$f":"K79","v":19128.079689327911},{"$f":"L79","v":11094.611937969439},{"$f":"M79","v":20849.606861367425},{"$f":"N79","v":12093.127012386691},{"$f":"O79","v":22726.071478890499},{"$f":"P79","v":13181.508443501494},{"$f":"Q79","v":24771.417911990644},{"$f":"R79","v":14367.844203416629},{"$f":"S79","v":27000.845524069799},{"$f":"T79","v":15660.950181724123},{"$f":"U79","v":29430.921621236084},{"$f":"V79","v":17070.435698079302},{"$f":"W79","v":32079.704567147339},{"$f":"X79","v":18606.774910906439},{"$f":"Y79","v":34966.877978190605},{"$f":"Z79","v":20281.384652888024},{"$f":"AA79","v":38113.896996227762},{"$f":"AB79","v":22106.709271647946},{"$f":"AC79","v":41544.147725888266},{"$f":"AD79","v":24096.313106096266},{"$f":"AE79","v":45283.12102121822},{"$f":"AF79","v":26264.981285644928},{"$f":"AG79","v":49358.601913127866},{"$f":"AH79","v":28628.829601352976},{"$f":"AI79","v":53800.876085309377},{"$f":"AJ79","v":31205.42426547475},{"$f":"AK79","v":58642.954932987217},{"$f":"AL79","v":34013.912449367483},{"$f":"AM79","v":63920.820876956073},{"$f":"AN79","v":false},{"$f":"AO79","v":false},{"$f":"AP79","v":false},{"$f":"AQ79","v":false},{"$f":"AR79","v":false},{"$f":"AS79","v":false},{"$f":"AT79","v":false},{"$f":"AU79","v":false},{"$f":"AV79","v":false},{"$f":"AW79","v":false},{"$f":"AX79","v":false},{"$f":"AY79","v":false},{"$f":"AZ79","v":false},{"$f":"BA79","v":false},{"$f":"BB79","v":false},{"$f":"BC79","v":false},{"$f":"BD79","v":false},{"$f":"BE79","v":false},{"$f":"BF79","v":false},{"$f":"BG79","v":false},{"$f":"BH79","v":false},{"$f":"BI79","v":false},{"$f":"BJ79","v":false},{"$f":"BK79","v":false},{"$f":"BL79","v":false},{"$f":"BM79","v":false},{"$f":"BN79","v":false},{"$f":"BO79","v":false},{"$f":"BP79","v":false},{"$f":"BQ79","v":false}]
[null,null,null,"Debt Service Issue 2","Sol",null,null,null,{"$f":"I125","v":0},{"$f":"J125","v":7127.102373966427},13393.643994826827,7768.5415876234047,14599.071954361247,8467.7103305095097,15912.988430253756,9229.8042602553687,17345.157388976597,10060.486643678352,18906.221553984491,10965.930441609402,20607.781493843097,11952.864181354251,22462.481828288983,13028.621957676136,24484.105192834999,14201.197933866992,26687.674660190154,15479.305747915023,29089.565379607277,16872.443265227372,31707.626263771919,18390.963159097839,34561.312627511397,20046.14984341665,37671.830763987433,21850.303329324153,41062.295532746299,23816.830628963318,44757.902130693459,63035.509955380563,118459.80807833801,68708.705851364837,129121.19080538844,0,0,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,"Total","Sol",null,null,null,{"$f":"SUM(I133:I134)","v":0},{"$f":"SUM(J133:J134)","v":17305.64543632371},32521.723684154738,18863.153525592843,35448.678815728672,20560.8373428962,38639.059909144256,22411.312703756863,42116.575300967241,24428.330847094981,45907.067078054286,26626.880623333527,50038.703115079181,29023.299879433551,54542.186395436322,31635.396868582575,59450.983171025604,34482.582586755016,64801.571656417917,37586.015019562969,70633.713105495539,40968.756371323638,76990.747284990139,44655.944444742767,83919.914540639264,48674.979444769626,91472.70684929681,53055.727594798904,99705.250465733523,57830.743078330801,108678.72300764953,63035.509955380563,118459.80807833801,68708.705851364837,129121.19080538844,0,0,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,"Dbt Issued"]
[null,null,null,"Debt Service Issue 1","Sol",{"$f":"F76","v":470400.00000000012},null,null,{"$f":"$F$138*I5","v":470400.00000000012},{"$f":"$F$138*J5","v":0},{"$f":"$F$138*K5","v":0},{"$f":"$F$138*L5","v":0},{"$f":"$F$138*M5","v":0},{"$f":"$F$138*N5","v":0},{"$f":"$F$138*O5","v":0},{"$f":"$F$138*P5","v":0},{"$f":"$F$138*Q5","v":0},{"$f":"$F$138*R5","v":0},{"$f":"$F$138*S5","v":0},{"$f":"$F$138*T5","v":0},{"$f":"$F$138*U5","v":0},{"$f":"$F$138*V5","v":0},{"$f":"$F$138*W5","v":0},{"$f":"$F$138*X5","v":0},{"$f":"$F$138*Y5","v":0},{"$f":"$F$138*Z5","v":0},{"$f":"$F$138*AA5","v":0},{"$f":"$F$138*AB5","v":0},{"$f":"$F$138*AC5","v":0},{"$f":"$F$138*AD5","v":0},{"$f":"$F$138*AE5","v":0},{"$f":"$F$138*AF5","v":0},{"$f":"$F$138*AG5","v":0},{"$f":"$F$138*AH5","v":0},{"$f":"$F$138*AI5","v":0},{"$f":"$F$138*AJ5","v":0},{"$f":"$F$138*AK5","v":0},{"$f":"$F$138*AL5","v":0},{"$f":"$F$138*AM5","v":0},{"$f":"$F$138*AN5","v":0},{"$f":"$F$138*AO5","v":0},{"$f":"$F$138*AP5","v":0},{"$f":"$F$138*AQ5","v":0},{"$f":"$F$138*AR5","v":0},{"$f":"$F$138*AS5","v":0},{"$f":"$F$138*AT5","v":0},{"$f":"$F$138*AU5","v":0},{"$f":"$F$138*AV5","v":0},{"$f":"$F$138*AW5","v":0},{"$f":"$F$138*AX5","v":0},{"$f":"$F$138*AY5","v":0},{"$f":"$F$138*AZ5","v":0},{"$f":"$F$138*BA5","v":0},{"$f":"$F$138*BB5","v":0},{"$f":"$F$138*BC5","v":0},{"$f":"$F$138*BD5","v":0},{"$f":"$F$138*BE5","v":0},{"$f":"$F$138*BF5","v":0},{"$f":"$F$138*BG5","v":0},{"$f":"$F$138*BH5","v":0},{"$f":"$F$138*BI5","v":0},{"$f":"$F$138*BJ5","v":0},{"$f":"$F$138*BK5","v":0},{"$f":"$F$138*BL5","v":0},{"$f":"$F$138*BM5","v":0},{"$f":"$F$138*BN5","v":0},{"$f":"$F$138*BO5","v":0},{"$f":"$F$138*BP5","v":0},{"$f":"$F$138*BQ5","v":0}]
[null,null,null,"Debt Service Issue 2","Sol",{"$f":"F105*I7","v":313600.0000000032},null,null,{"$f":"$F$139*I5","v":313600.0000000032},{"$f":"$F$139*J5","v":0},{"$f":"$F$139*K5","v":0},{"$f":"$F$139*L5","v":0},{"$f":"$F$139*M5","v":0},{"$f":"$F$139*N5","v":0},{"$f":"$F$139*O5","v":0},{"$f":"$F$139*P5","v":0},{"$f":"$F$139*Q5","v":0},{"$f":"$F$139*R5","v":0},{"$f":"$F$139*S5","v":0},{"$f":"$F$139*T5","v":0},{"$f":"$F$139*U5","v":0},{"$f":"$F$139*V5","v":0},{"$f":"$F$139*W5","v":0},{"$f":"$F$139*X5","v":0},{"$f":"$F$139*Y5","v":0},{"$f":"$F$139*Z5","v":0},{"$f":"$F$139*AA5","v":0},{"$f":"$F$139*AB5","v":0},{"$f":"$F$139*AC5","v":0},{"$f":"$F$139*AD5","v":0},{"$f":"$F$139*AE5","v":0},{"$f":"$F$139*AF5","v":0},{"$f":"$F$139*AG5","v":0},{"$f":"$F$139*AH5","v":0},{"$f":"$F$139*AI5","v":0},{"$f":"$F$139*AJ5","v":0},{"$f":"$F$139*AK5","v":0},{"$f":"$F$139*AL5","v":0},{"$f":"$F$139*AM5","v":0},{"$f":"$F$139*AN5","v":0},{"$f":"$F$139*AO5","v":0},{"$f":"$F$139*AP5","v":0},{"$f":"$F$139*AQ5","v":0},{"$f":"$F$139*AR5","v":0},{"$f":"$F$139*AS5","v":0},{"$f":"$F$139*AT5","v":0},{"$f":"$F$139*AU5","v":0},{"$f":"$F$139*AV5","v":0},{"$f":"$F$139*AW5","v":0},{"$f":"$F$139*AX5","v":0},{"$f":"$F$139*AY5","v":0},{"$f":"$F$139*AZ5","v":0},{"$f":"$F$139*BA5","v":0},{"$f":"$F$139*BB5","v":0},{"$f":"$F$139*BC5","v":0},{"$f":"$F$139*BD5","v":0},{"$f":"$F$139*BE5","v":0},{"$f":"$F$139*BF5","v":0},{"$f":"$F$139*BG5","v":0},{"$f":"$F$139*BH5","v":0},{"$f":"$F$139*BI5","v":0},{"$f":"$F$139*BJ5","v":0},{"$f":"$F$139*BK5","v":0},{"$f":"$F$139*BL5","v":0},{"$f":"$F$139*BM5","v":0},{"$f":"$F$139*BN5","v":0},{"$f":"$F$139*BO5","v":0},{"$f":"$F$139*BP5","v":0},{"$f":"$F$139*BQ5","v":0}]
[null,null,null,"Total","Sol",{"$f":"SUM(F138:F139)","v":784000.00000000326},null,null,{"$f":"SUM(I138:I139)","v":784000.00000000326},{"$f":"SUM(J138:J139)","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]
[]
[null,null,"Debt Cash Flow",null,"Sol",null,null,null,{"$f":"I135-I140","v":-784000.00000000326},{"$f":"J135-J140","v":17305.64543632371},32521.723684154738,18863.153525592843,35448.678815728672,20560.8373428962,38639.059909144256,22411.312703756863,42116.575300967241,24428.330847094981,45907.067078054286,26626.880623333527,50038.703115079181,29023.299879433551,54542.186395436322,31635.396868582575,59450.983171025604,34482.582586755016,64801.571656417917,37586.015019562969,70633.713105495539,40968.756371323638,76990.747284990139,44655.944444742767,83919.914540639264,48674.979444769626,91472.70684929681,53055.727594798904,99705.250465733523,57830.743078330801,108678.72300764953,63035.509955380563,118459.80807833801,68708.705851364837,129121.19080538844,0,0,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,"Debt IRR - Computed",null,"Sol",{"$f":"IRR(I142:BQ142)","v":4.440790260216132E-2},"DIRR Comp"]
[null,null,"Debt IRR - Fixed",null,"Sol",4.440790260216132E-2,"DIRR Fixed"]
[null,null,"Debt IRR - Difference",null,"Sol",{"$f":"F143-F144","v":0},"Difference"]
[]
[null,"Outputs"]
[null,null,"CFADS",null,"Sol",null,null,null,{"$f":"I24-I28","v":0},{"$f":"J24-J28","v":41761.226035642205},{"$f":"K24-K28","v":78480},{"$f":"L24-L28","v":45519.736378850008},{"$f":"M24-M28","v":85543.200000000012},{"$f":"N24-N28","v":49616.512652946512},{"$f":"O24-O28","v":93242.088000000032},{"$f":"P24-P28","v":54081.998791711703},{"$f":"Q24-Q28","v":101633.87592000003},{"$f":"R24-R28","v":58949.378682965762},{"$f":"S24-S28","v":110780.92475280003},{"$f":"T24-T28","v":64254.822764432669},{"$f":"U24-U28","v":120751.20798055205},{"$f":"V24-V28","v":70037.756813231637},{"$f":"W24-W28","v":131618.81669880176},{"$f":"X24-X28","v":76341.154926422489},{"$f":"Y24-Y28","v":143464.51020169395},{"$f":"Z24-Z28","v":83211.858869800533},{"$f":"AA24-AA28","v":156376.31611984642},{"$f":"AB24-AB28","v":90700.926168082588},{"$f":"AC24-AC28","v":170450.18457063261},{"$f":"AD24-AD28","v":98864.009523210028},{"$f":"AE24-AE28","v":185790.70118198957},{"$f":"AF24-AF28","v":107761.77038029893},{"$f":"AG24-AG28","v":202511.86428836867},{"$f":"AH24-AH28","v":117460.32971452585},{"$f":"AI24-AI28","v":220737.93207432187},{"$f":"AJ24-AJ28","v":128031.7593888332},{"$f":"AK24-AK28","v":240604.34596101081},{"$f":"AL24-AL28","v":139554.6177338282},{"$f":"AM24-AM28","v":262258.73709750181},{"$f":"AN24-AN28","v":152114.53332987271},{"$f":"AO24-AO28","v":285862.023436277},{"$f":"AP24-AP28","v":165804.84132956131},{"$f":"AQ24-AQ28","v":311589.60554554197},{"$f":"AR24-AR28","v":180727.27704922186},{"$f":"AS24-AS28","v":339632.67004464084},{"$f":"AT24-AT28","v":196992.73198365179},{"$f":"AU24-AU28","v":370199.61034865846},{"$f":"AV24-AV28","v":214722.07786218048},{"$f":"AW24-AW28","v":403517.57528003782},{"$f":"AX24-AX28","v":234047.06486977678},{"$f":"AY24-AY28","v":439834.15705524129},{"$f":"AZ24-AZ28","v":255111.30070805675},{"$f":"BA24-BA28","v":479419.23119021306},{"$f":"BB24-BB28","v":278071.31777178188},{"$f":"BC24-BC28","v":522566.96199733228},{"$f":"BD24-BD28","v":303097.73637124232},{"$f":"BE24-BE28","v":569597.9885770923},{"$f":"BF24-BF28","v":330376.53264465404},{"$f":"BG24-BG28","v":620861.80754903064},{"$f":"BH24-BH28","v":360110.42058267293},{"$f":"BI24-BI28","v":676739.37022844353},{"$f":"BJ24-BJ28","v":392520.35843511357},{"$f":"BK24-BK28","v":737645.91354900354},{"$f":"BL24-BL28","v":427847.19069427392},{"$f":"BM24-BM28","v":804034.04576841393},{"$f":"BN24-BN28","v":466353.43785675871},{"$f":"BO24-BO28","v":876397.10988757131},{"$f":"BP24-BP28","v":508325.24726386688},{"$f":"BQ24-BQ28","v":0}]
[null,null,"Less Total Debt Service",null,"Sol",null,null,null,{"$f":"I135","v":0},{"$f":"J135","v":17305.64543632371},32521.723684154738,18863.153525592843,35448.678815728672,20560.8373428962,38639.059909144256,22411.312703756863,42116.575300967241,24428.330847094981,45907.067078054286,26626.880623333527,50038.703115079181,29023.299879433551,54542.186395436322,31635.396868582575,59450.983171025604,34482.582586755016,64801.571656417917,37586.015019562969,70633.713105495539,40968.756371323638,76990.747284990139,44655.944444742767,83919.914540639264,48674.979444769626,91472.70684929681,53055.727594798904,99705.250465733523,57830.743078330801,108678.72300764953,63035.509955380563,118459.80807833801,68708.705851364837,129121.19080538844,0,0,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: Capital Expenditures",null,"Sol",null,null,null,{"$f":"I30","v":1120000}]
[null,null,"Add: Debt Issued",null,"Sol",null,null,null,{"$f":"I140","v":784000.00000000326}]
[null,null,null,"Equity Cash Flow","Sol",null,null,null,{"$f":"I148-I149-I150+I151","v":-335999.99999999674},{"$f":"J148-J149-J150+J151","v":24455.580599318495},45958.276315845258,26656.582853257165,50094.52118427134,29055.675310050312,54603.028090855776,31670.68608795484,59517.300619032794,34521.047835870777,64873.857674745741,37627.942141099142,70712.504865472874,41014.456933798087,77076.63030336544,44705.758057839914,84013.527030668338,48729.276283045518,91574.744463428506,53114.911148519619,99816.471465137074,57895.253151886391,108799.95389699943,63105.82593555616,118591.94974772941,68785.350269756222,129265.22522502506,74976.031794034294,140899.09549527729,81723.874655497406,153580.01408985228,89079.023374492142,167402.21535793899,97096.135478196476,182468.41474015353,180727.27704922186,339632.67004464084,196992.73198365179,370199.61034865846,214722.07786218048,403517.57528003782,234047.06486977678,439834.15705524129,255111.30070805675,479419.23119021306,278071.31777178188,522566.96199733228,303097.73637124232,569597.9885770923,330376.53264465404,620861.80754903064,360110.42058267293,676739.37022844353,392520.35843511357,737645.91354900354,427847.19069427392,804034.04576841393,466353.43785675871,876397.10988757131,508325.24726386688,0]
[]
[null,null,null,"Equity IRR","%",{"$f":"IRR(I152:BQ152)","v":0.14679346737670129}]
[]
[null,null,null,"DSCR",null,{"$f":"MIN(I156:BQ156)","v":2.4131562263483923},null,null,{"$f":"IF(I149>0.1,I148/I149)","v":false},{"$f":"IF(J149>0.1,J148/J149)","v":2.4131562263483923},2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483932,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483923,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483923,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,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,false]
[]
[]
[null,null,"CFADS",null,"USD",null,null,null,{"$f":"I148/I7","v":0},{"$f":"J148/J7","v":10148.891565092221},{"$f":"K148/K7","v":18540},{"$f":"L148/L7","v":10453.358312044989},{"$f":"M148/M7","v":19096.2},{"$f":"N148/N7","v":10766.959061406338},{"$f":"O148/O7","v":19669.086000000007},{"$f":"P148/P7","v":11089.967833248529},{"$f":"Q148/Q7","v":20259.158580000007},{"$f":"R148/R7","v":11422.666868245988},{"$f":"S148/S7","v":20866.933337400005},{"$f":"T148/T7","v":11765.346874293364},{"$f":"U148/U7","v":21492.941337522007},{"$f":"V148/V7","v":12118.307280522169},{"$f":"W148/W7","v":22137.729577647671},{"$f":"X148/X7","v":12481.856498937836},{"$f":"Y148/Y7","v":22801.861464977108},{"$f":"Z148/Z7","v":12856.312193905973},{"$f":"AA148/AA7","v":23485.917308926422},{"$f":"AB148/AB7","v":13242.001559723152},{"$f":"AC148/AC7","v":24190.494828194216},{"$f":"AD148/AD7","v":13639.261606514847},{"$f":"AE148/AE7","v":24916.209673040044},{"$f":"AF148/AF7","v":14048.439454710293},{"$f":"AG148/AG7","v":25663.695963231246},{"$f":"AH148/AH7","v":14469.892638351603},{"$f":"AI148/AI7","v":26433.606842128185},{"$f":"AJ148/AJ7","v":14903.989417502151},{"$f":"AK148/AK7","v":27226.615047392021},{"$f":"AL148/AL7","v":15351.10910002721},{"$f":"AM148/AM7","v":28043.413498813778},{"$f":"AN148/AN7","v":15811.64237302802},{"$f":"AO148/AO7","v":28884.715903778193},{"$f":"AP148/AP7","v":16285.99164421887},{"$f":"AQ148/AQ7","v":29751.257380891544},{"$f":"AR148/AR7","v":16774.571393545437},{"$f":"AS148/AS7","v":30643.795102318298},{"$f":"AT148/AT7","v":17277.8085353518},{"$f":"AU148/AU7","v":31563.108955387841},{"$f":"AV148/AV7","v":17796.142791412352},{"$f":"AW148/AW7","v":32510.002224049476},{"$f":"AX148/AX7","v":18330.027075154725},{"$f":"AY148/AY7","v":33485.302290770967},{"$f":"AZ148/AZ7","v":18879.927887409369},{"$f":"BA148/BA7","v":34489.861359494091},{"$f":"BB148/BB7","v":19446.325724031649},{"$f":"BC148/BC7","v":35524.557200278912},{"$f":"BD148/BD7","v":20029.715495752604},{"$f":"BE148/BE7","v":36590.293916287286},{"$f":"BF148/BF7","v":20630.606960625177},{"$f":"BG148/BG7","v":37688.002733775909},{"$f":"BH148/BH7","v":21249.525169443932},{"$f":"BI148/BI7","v":38818.642815789201},{"$f":"BJ148/BJ7","v":21887.010924527258},{"$f":"BK148/BK7","v":39983.202100262883},{"$f":"BL148/BL7","v":22543.621252263081},{"$f":"BM148/BM7","v":41182.698163270776},{"$f":"BN148/BN7","v":23219.929889830983},{"$f":"BO148/BO7","v":42418.179108168901},{"$f":"BP148/BP7","v":23916.527786525905},{"$f":"BQ148/BQ7","v":0}]
[null,null,"Less Total Debt Service",null,"USD",null,null,null,{"$f":"I149/I7","v":0},{"$f":"J149/J7","v":4205.6504482718901},{"$f":"K149/K7","v":7682.8842648347209},{"$f":"L149/L7","v":4331.8199617200471},{"$f":"M149/M7","v":7913.3707927797632},{"$f":"N149/N7","v":4461.7745605716482},{"$f":"O149/O7","v":8150.771916563157},{"$f":"P149/P7","v":4595.6277973887991},{"$f":"Q149/Q7","v":8395.2950740600536},{"$f":"R149/R7","v":4733.4966313104633},{"$f":"S149/S7","v":8647.1539262818515},{"$f":"T149/T7","v":4875.5015302497759},{"$f":"U149/U7","v":8906.5685440703091},{"$f":"V149/V7","v":5021.7665761572707},{"$f":"W149/W7","v":9173.7656003924203},{"$f":"X149/X7","v":5172.41957344199},{"$f":"Y149/Y7","v":9448.9785684041963},{"$f":"Z149/Z7","v":5327.5921606452503},{"$f":"AA149/AA7","v":9732.447925456323},{"$f":"AB149/AB7","v":5487.4199254646082},{"$f":"AC149/AC7","v":10024.421363220014},{"$f":"AD149/AD7","v":5652.0425232285461},{"$f":"AE149/AE7","v":10325.154004116614},{"$f":"AF149/AF7","v":5821.6037989254028},{"$f":"AG149/AG7","v":10634.908624240112},{"$f":"AH149/AH7","v":5996.2519128931654},{"$f":"AI149/AI7","v":10953.955882967317},{"$f":"AJ149/AJ7","v":6176.1394702799607},{"$f":"AK149/AK7","v":11282.574559456332},{"$f":"AL149/AL7","v":6361.4236543883571},{"$f":"AM149/AM7","v":11621.051796240019},{"$f":"AN149/AN7","v":6552.2663640200053},{"$f":"AO149/AO7","v":11969.683350127221},{"$f":"AP149/AP7","v":6748.8343549406081},{"$f":"AQ149/AQ7","v":12328.77385063104},{"$f":"AR149/AR7","v":0},{"$f":"AS149/AS7","v":0},{"$f":"AT149/AT7","v":0},{"$f":"AU149/AU7","v":0},{"$f":"AV149/AV7","v":0},{"$f":"AW149/AW7","v":0},{"$f":"AX149/AX7","v":0},{"$f":"AY149/AY7","v":0},{"$f":"AZ149/AZ7","v":0},{"$f":"BA149/BA7","v":0},{"$f":"BB149/BB7","v":0},{"$f":"BC149/BC7","v":0},{"$f":"BD149/BD7","v":0},{"$f":"BE149/BE7","v":0},{"$f":"BF149/BF7","v":0},{"$f":"BG149/BG7","v":0},{"$f":"BH149/BH7","v":0},{"$f":"BI149/BI7","v":0},{"$f":"BJ149/BJ7","v":0},{"$f":"BK149/BK7","v":0},{"$f":"BL149/BL7","v":0},{"$f":"BM149/BM7","v":0},{"$f":"BN149/BN7","v":0},{"$f":"BO149/BO7","v":0},{"$f":"BP149/BP7","v":0},{"$f":"BQ149/BQ7","v":0}]
[null,null,"Less: Capital Expenditures",null,"USD",null,null,null,{"$f":"I150/I7","v":280000},{"$f":"J150/J7","v":0},{"$f":"K150/K7","v":0},{"$f":"L150/L7","v":0},{"$f":"M150/M7","v":0},{"$f":"N150/N7","v":0},{"$f":"O150/O7","v":0},{"$f":"P150/P7","v":0},{"$f":"Q150/Q7","v":0},{"$f":"R150/R7","v":0},{"$f":"S150/S7","v":0},{"$f":"T150/T7","v":0},{"$f":"U150/U7","v":0},{"$f":"V150/V7","v":0},{"$f":"W150/W7","v":0},{"$f":"X150/X7","v":0},{"$f":"Y150/Y7","v":0},{"$f":"Z150/Z7","v":0},{"$f":"AA150/AA7","v":0},{"$f":"AB150/AB7","v":0},{"$f":"AC150/AC7","v":0},{"$f":"AD150/AD7","v":0},{"$f":"AE150/AE7","v":0},{"$f":"AF150/AF7","v":0},{"$f":"AG150/AG7","v":0},{"$f":"AH150/AH7","v":0},{"$f":"AI150/AI7","v":0},{"$f":"AJ150/AJ7","v":0},{"$f":"AK150/AK7","v":0},{"$f":"AL150/AL7","v":0},{"$f":"AM150/AM7","v":0},{"$f":"AN150/AN7","v":0},{"$f":"AO150/AO7","v":0},{"$f":"AP150/AP7","v":0},{"$f":"AQ150/AQ7","v":0},{"$f":"AR150/AR7","v":0},{"$f":"AS150/AS7","v":0},{"$f":"AT150/AT7","v":0},{"$f":"AU150/AU7","v":0},{"$f":"AV150/AV7","v":0},{"$f":"AW150/AW7","v":0},{"$f":"AX150/AX7","v":0},{"$f":"AY150/AY7","v":0},{"$f":"AZ150/AZ7","v":0},{"$f":"BA150/BA7","v":0},{"$f":"BB150/BB7","v":0},{"$f":"BC150/BC7","v":0},{"$f":"BD150/BD7","v":0},{"$f":"BE150/BE7","v":0},{"$f":"BF150/BF7","v":0},{"$f":"BG150/BG7","v":0},{"$f":"BH150/BH7","v":0},{"$f":"BI150/BI7","v":0},{"$f":"BJ150/BJ7","v":0},{"$f":"BK150/BK7","v":0},{"$f":"BL150/BL7","v":0},{"$f":"BM150/BM7","v":0},{"$f":"BN150/BN7","v":0},{"$f":"BO150/BO7","v":0},{"$f":"BP150/BP7","v":0},{"$f":"BQ150/BQ7","v":0}]
[null,null,"Add: Debt Issued",null,"USD",null,null,null,{"$f":"I151/I7","v":196000.00000000081},{"$f":"J151/J7","v":0},{"$f":"K151/K7","v":0},{"$f":"L151/L7","v":0},{"$f":"M151/M7","v":0},{"$f":"N151/N7","v":0},{"$f":"O151/O7","v":0},{"$f":"P151/P7","v":0},{"$f":"Q151/Q7","v":0},{"$f":"R151/R7","v":0},{"$f":"S151/S7","v":0},{"$f":"T151/T7","v":0},{"$f":"U151/U7","v":0},{"$f":"V151/V7","v":0},{"$f":"W151/W7","v":0},{"$f":"X151/X7","v":0},{"$f":"Y151/Y7","v":0},{"$f":"Z151/Z7","v":0},{"$f":"AA151/AA7","v":0},{"$f":"AB151/AB7","v":0},{"$f":"AC151/AC7","v":0},{"$f":"AD151/AD7","v":0},{"$f":"AE151/AE7","v":0},{"$f":"AF151/AF7","v":0},{"$f":"AG151/AG7","v":0},{"$f":"AH151/AH7","v":0},{"$f":"AI151/AI7","v":0},{"$f":"AJ151/AJ7","v":0},{"$f":"AK151/AK7","v":0},{"$f":"AL151/AL7","v":0},{"$f":"AM151/AM7","v":0},{"$f":"AN151/AN7","v":0},{"$f":"AO151/AO7","v":0},{"$f":"AP151/AP7","v":0},{"$f":"AQ151/AQ7","v":0},{"$f":"AR151/AR7","v":0},{"$f":"AS151/AS7","v":0},{"$f":"AT151/AT7","v":0},{"$f":"AU151/AU7","v":0},{"$f":"AV151/AV7","v":0},{"$f":"AW151/AW7","v":0},{"$f":"AX151/AX7","v":0},{"$f":"AY151/AY7","v":0},{"$f":"AZ151/AZ7","v":0},{"$f":"BA151/BA7","v":0},{"$f":"BB151/BB7","v":0},{"$f":"BC151/BC7","v":0},{"$f":"BD151/BD7","v":0},{"$f":"BE151/BE7","v":0},{"$f":"BF151/BF7","v":0},{"$f":"BG151/BG7","v":0},{"$f":"BH151/BH7","v":0},{"$f":"BI151/BI7","v":0},{"$f":"BJ151/BJ7","v":0},{"$f":"BK151/BK7","v":0},{"$f":"BL151/BL7","v":0},{"$f":"BM151/BM7","v":0},{"$f":"BN151/BN7","v":0},{"$f":"BO151/BO7","v":0},{"$f":"BP151/BP7","v":0},{"$f":"BQ151/BQ7","v":0}]
[null,null,null,"Equity Cash Flow","USD",null,null,null,{"$f":"I159-I160-I161+I162","v":-83999.999999999185},{"$f":"J159-J160-J161+J162","v":5943.2411168203307},10857.11573516528,6121.5383503249423,11182.829207220238,6305.18450083469,11518.31408343685,6494.3400358597301,11863.863505939953,6689.1702369355244,12219.779411118154,6889.8453440435878,12586.372793451697,7096.5407043648984,12963.963977255251,7309.4369254958456,13352.882896572912,7528.7200332607226,13753.469383470099,7754.581634258544,14166.073464974203,7987.2190832863007,14591.055668923431,8226.8356557848892,15028.787338991135,8473.6407254584374,15479.650959160868,8727.8499472221902,15944.040487935688,8989.6854456388537,16422.361702573759,9259.3760090080141,16915.03255365097,9537.1572892782606,17422.483530260506,16774.571393545437,30643.795102318298,17277.8085353518,31563.108955387841,17796.142791412352,32510.002224049476,18330.027075154725,33485.302290770967,18879.927887409369,34489.861359494091,19446.325724031649,35524.557200278912,20029.715495752604,36590.293916287286,20630.606960625177,37688.002733775909,21249.525169443932,38818.642815789201,21887.010924527258,39983.202100262883,22543.621252263081,41182.698163270776,23219.929889830983,42418.179108168901,23916.527786525905,0]
[]
[null,null,null,"Equity IRR","%",{"$f":"IRR(I163:BQ163)","v":0.11478360697829393}]
[]
[null,null,null,"DSCR","x",{"$f":"MIN(I167:BQ167)","v":2.4131562263483923},null,null,{"$f":"IF(I160>0.1,I159/I160)","v":false},{"$f":"IF(J160>0.1,J159/J160)","v":2.4131562263483928},2.4131562263483928,2.4131562263483932,2.4131562263483923,2.4131562263483932,2.4131562263483928,2.4131562263483923,2.4131562263483923,2.4131562263483928,2.4131562263483932,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483923,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483928,2.4131562263483932,2.4131562263483928,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,false]