{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sheet1","Inputs","CF and Cash Flow","Financial Model"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"CF and Cash Flow","index":2,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Cap Exp","Unit"]
["Beginning","Date","2020-01-01",null,null,null,"1. Get Timelines worked out"]
["End","Date","2020-12-31",null,null,null,"2. Start with operation never P&L, BS, CF"]
["Construction Duration","Months",12,null,null,null,"3. Put together Cap exp, Rev and Expenses -- Project IRR -- pre-tax"]
["Capexp","m€",50,null,null,null,"4. Put depreciation without IDC and then after-tax Project IRR"]
["Amortization duration","years",20,null,null,null,"5. Financing -- Sorces and Uses and Debt Repayment and Debt Balance"]
[null,null,null,null,null,null,"6. Cash Flow waterfall -- define CFADS and Equity Cash Flow to get Equity IRR"]
["Revenues",null,null,null,null,null,"7. Resolve Circular Reference -- for IDC"]
["Production","MWH/Year",100000,null,null,null,"8. Financial"]
["Electricity Price - 1","m€/MWH",60]
["Electricity Price - 2","m€/MWH",35]
["Part 1 Duration","Years",10]
["Inflation Revenues","%/Year",0.01]
[]
["Opexp"]
["Beginning","Date","2021-01-01"]
["End","Date","2040-01-01"]
["Operation Duration","Years",20]
["Total Costs","m€",1]
["Inflation Revenues","%/Year",0.01]
["Income Tax","%",0.3]
[]
["Financing"]
["Gearing","%",0.8]
["Interest Rate","%",0.03]
["Debt Tenor","Years",20]

{"sheet":"Inputs","index":1,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Timing"]
[null,null,null,"Beginning","Date","2020-01-01",null,null,null,"Summary"]
[null,null,null,"End","Date",{"$f":"EOMONTH(F3,F5-1)","v":"2020-12-31"}]
[null,null,null,"Construction Duration","Months",12,null,null,null,"DSCR",{"$f":"'Financial Model'!H121","v":1.014586681007561}]
[null,null,null,null,null,null,null,null,null,"Project Pre-Tax IRR"]
[null,null,null,"COD Date","Date",{"$f":"EDATE(F3,F5)","v":"2021-01-01"}]
[null,null,null,"Operation Duration","Years",20,null,null,null,"Equity IRR",{"$f":"'Financial Model'!F119","v":6.5959796309471116E-2}]
[null,null,null,"End Date","Date",{"$f":"EDATE(F7,F8*12)","v":"2041-01-01"}]
[null,null,null,"Part 1 Duration","Years",10]
[null,null,null,"Part 1 Duration End","Date",{"$f":"EDATE(F7,F10*12)","v":"2031-01-01"}]
[]
[null,null,null,"Months in Period Construction","Months",1]
[null,null,null,"Months in Period Operations","Months",12]
[]
[null,"Operation Assumptions"]
[null,null,null,"Production","MWH/Year",100000]
[null,null,null,"Capexp","m€",50]
[null,null,null,"S-Curve","%/Month",{"$f":"1/F5","v":8.3333333333333329E-2}]
[]
[null,null,"Revenues"]
[null,null,null,"Electricity Price - 1","m€/MWH",60]
[null,null,null,"Electricity Price - 2","m€/MWH",35]
[null,null,null,"Inflation Revenues","%/Year",0.01,null,"Assume starts at COD"]
[]
[null,null,"Opexp"]
[null,null,null,"Total Costs","m€",1,null,"Assume that this is Real and in € of COD Date"]
[null,null,null,"Inflation Cost","%/Year",0.01,null,"Assume starts at COD"]
[]
[null,"Tax Assumptions"]
[null,null,null,"Amortization duration","years",20]
[null,null,null,"Income Tax","%",0.3]
[]
[null,"Financing"]
[null,null,null,"Gearing","%",0.8]
[null,null,null,"Interest Rate","%",0.03]
[null,null,null,"Debt Tenor","Years",20,null,"Assume Equal Installment"]
[]
[null,null,null,"Level Payment",null,{"$f":"PMT(F36,F37,-1)","v":6.7215707596859131E-2}]
[]
[null,null,null,"Start of Repayment","Date",{"$f":"F7","v":"2021-01-01"}]
[null,null,null,"End of Repayment","Date",{"$f":"EDATE(F41,F37*12)","v":"2041-01-01"}]

{"sheet":"Financial Model","index":3,"n_rows":146,"n_cols":42,"rows_kept":146,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Driver","Driver","Sum"]
[null,"Time Line"]
[null,null,"Period",null,"Number",null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33]
[null,null,"Pre-COD Period",null,"Flag",{"$f":"Inputs!F5","v":12},null,{"$f":"SUM(J4:AP4)","v":12},null,{"$f":"(J3<=$F$4)*1","v":1},{"$f":"(K3<=$F$4)*1","v":1},1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Months in Period (Const,oper)",null,"Months",{"$f":"Inputs!F13","v":1},{"$f":"Inputs!F14","v":12},null,null,{"$f":"IF(J4,$F$5,$G$5)","v":1},{"$f":"IF(K4,$F$5,$G$5)","v":1},1,1,1,1,1,1,1,1,1,1,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12]
[null,null,"Start of Period",null,"Date",null,null,null,null,{"$f":"I7+1","v":"2020-01-01"},{"$f":"J7+1","v":"2020-02-02"},"2020-03-03","2020-04-04","2020-05-05","2020-06-06","2020-07-07","2020-08-08","2020-09-09","2020-10-10","2020-11-11","2020-12-12","2021-01-13","2022-01-14","2023-01-15","2024-01-16","2025-01-17","2026-01-18","2027-01-19","2028-01-20","2029-01-21","2030-01-22","2031-01-23","2032-01-24","2033-01-25","2034-01-26","2035-01-27","2036-01-28","2037-01-29","2038-01-30","2039-01-31","2040-02-01","2041-02-02"]
[null,null,"End of Period",null,"Date",null,null,null,{"$f":"Inputs!F3-1","v":"2019-12-31"},{"$f":"EDATE(J6,J5)","v":"2020-02-01"},{"$f":"EDATE(K6,K5)","v":"2020-03-02"},"2020-04-03","2020-05-04","2020-06-05","2020-07-06","2020-08-07","2020-09-08","2020-10-09","2020-11-10","2020-12-11","2021-01-12","2022-01-13","2023-01-14","2024-01-15","2025-01-16","2026-01-17","2027-01-18","2028-01-19","2029-01-20","2030-01-21","2031-01-22","2032-01-23","2033-01-24","2034-01-25","2035-01-26","2036-01-27","2037-01-28","2038-01-29","2039-01-30","2040-01-31","2041-02-01","2042-02-02"]
[null,null,"Operation Flag",null,"Flag",{"$f":"Inputs!F7","v":"2021-01-01"},{"$f":"Inputs!F9","v":"2041-01-01"},{"$f":"SUM(J8:AP8)","v":20},null,{"$f":"AND(J$6>=$F8,J$6<=$G8)*1","v":0},{"$f":"AND(K$6>=$F8,K$6<=$G8)*1","v":0},0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0]
[null,null,"Initial Price Flag",null,"Flag",{"$f":"Inputs!F7","v":"2021-01-01"},{"$f":"Inputs!F11","v":"2031-01-01"},{"$f":"SUM(J9:AP9)","v":10},null,{"$f":"AND(J$6>=$F9,J$6<$G9)*1","v":0},0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,{"$f":"AND(Z$6>=$F9,Z$6<$G9)*1","v":1},1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Second Price Flag",null,"Flag",{"$f":"G9","v":"2031-01-01"},{"$f":"G8","v":"2041-01-01"},10,null,{"$f":"AND(J$6>=$F10,J$6<=$G10)*1","v":0},{"$f":"AND(K$6>=$F10,K$6<=$G10)*1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,0]
[]
[null,"Operations"]
[null,null,"Production",null,"MWH/Year",{"$f":"Inputs!F17","v":100000},null,null,null,{"$f":"$F$13*J8","v":0},{"$f":"$F$13*K8","v":0},0,0,0,0,0,0,0,0,0,0,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,0]
[]
[null,"Cap Exp"]
[null,null,"Total Cost",null,"m€",{"$f":"Inputs!F18","v":50},null,null,null,{"$f":"$F$16","v":50},{"$f":"$F$16","v":50},50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50]
[null,null,"S-curve",null,"%",{"$f":"Inputs!F19","v":8.3333333333333329E-2},null,{"$f":"SUM(J17:AP17)","v":1},null,{"$f":"$F$17*J4","v":8.3333333333333329E-2},{"$f":"$F$17*K4","v":8.3333333333333329E-2},8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,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 Cap Exp","m€",null,null,null,null,{"$f":"J16*J17","v":4.1666666666666661},{"$f":"K16*K17","v":4.1666666666666661},4.1666666666666661,4.1666666666666661,4.1666666666666661,4.1666666666666661,4.1666666666666661,4.1666666666666661,4.1666666666666661,4.1666666666666661,4.1666666666666661,4.1666666666666661,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Revenues"]
[null,null,"Inflation Rate",null,"% p.a.",{"$f":"Inputs!F24","v":0.01},null,null,null,{"$f":"$F$21*J8","v":0},{"$f":"$F$21*K8","v":0},0,0,0,0,0,0,0,0,0,0,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0]
[null,null,"Inflation Index",null,"Index",null,null,null,1,{"$f":"I22*(1+J21)","v":1},{"$f":"J22*(1+K21)","v":1},1,1,1,1,1,1,1,1,1,1,1.01,1.0201,1.0303009999999999,1.04060401,1.0510100500999999,1.0615201506009999,1.0721353521070098,1.08285670562808,1.0936852726843609,1.1046221254112045,1.1156683466653166,1.1268250301319698,1.1380932804332895,1.1494742132376223,1.1609689553699987,1.1725786449236986,1.1843044313729356,1.196147475686665,1.2081089504435316,1.220190039947967,1.220190039947967]
[null,null,"Price Period 1",null,"m€/MWH",{"$f":"Inputs!F22","v":60},null,null,null,{"$f":"$F$23*J22*J9","v":0},{"$f":"$F$23*K22*K9","v":0},0,0,0,0,0,0,0,0,0,0,60.6,61.206000000000003,61.818059999999996,62.436240600000005,63.060603005999994,63.691209036059995,64.328121126420584,64.971402337684793,65.621116361061652,66.277327524672273,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Price Period 2",null,"m€/MWH",{"$f":"Inputs!F23","v":35},null,null,null,{"$f":"$F$24*J22*J10","v":0},{"$f":"$F$24*K22*K10","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,39.048392133286079,39.438876054618945,39.83326481516513,40.231597463316781,40.633913437949957,41.04025257232945,41.450655098052749,41.865161649033276,42.283813265523605,42.706651398178849,0]
[]
[null,null,"Revenues for Period 1",null,"m€",null,null,null,null,{"$f":"J23*J13/10^6","v":0},{"$f":"K23*K13/10^6","v":0},0,0,0,0,0,0,0,0,0,0,6.06,6.1205999999999996,6.1818059999999999,6.2436240600000001,6.3060603005999996,6.3691209036059995,6.4328121126420585,6.4971402337684792,6.5621116361061649,6.6277327524672272,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Revenues for Period 2",null,"m€",null,null,null,null,{"$f":"J24*J13/10^6","v":0},{"$f":"K24*K13/10^6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3.9048392133286081,3.9438876054618945,3.9833264815165133,4.0231597463316779,4.0633913437949962,4.1040252572329452,4.1450655098052751,4.1865161649033276,4.22838132655236,4.2706651398178854,0]
[null,null,null,"Total Revenues","m€",null,null,null,null,{"$f":"SUM(J26:J27)","v":0},{"$f":"SUM(K26:K27)","v":0},0,0,0,0,0,0,0,0,0,0,6.06,6.1205999999999996,6.1818059999999999,6.2436240600000001,6.3060603005999996,6.3691209036059995,6.4328121126420585,6.4971402337684792,6.5621116361061649,6.6277327524672272,3.9048392133286081,3.9438876054618945,3.9833264815165133,4.0231597463316779,4.0633913437949962,4.1040252572329452,4.1450655098052751,4.1865161649033276,4.22838132655236,4.2706651398178854,0]
[]
[null,"Op Exp"]
[null,null,"Inflation Rate",null,"% p.a.",{"$f":"Inputs!F28","v":0.01},null,null,null,{"$f":"$F$31*J8","v":0},{"$f":"$F$31*K8","v":0},0,0,0,0,0,0,0,0,0,0,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0]
[null,null,"Inflation Index",null,"Index",null,null,null,1,{"$f":"I32*(1+J31)","v":1},{"$f":"J32*(1+K31)","v":1},1,1,1,1,1,1,1,1,1,1,1.01,1.0201,1.0303009999999999,1.04060401,1.0510100500999999,1.0615201506009999,1.0721353521070098,1.08285670562808,1.0936852726843609,1.1046221254112045,1.1156683466653166,1.1268250301319698,1.1380932804332895,1.1494742132376223,1.1609689553699987,1.1725786449236986,1.1843044313729356,1.196147475686665,1.2081089504435316,1.220190039947967,1.220190039947967]
[null,null,null,"Operation Expense","m€",{"$f":"Inputs!F27","v":1},null,null,null,{"$f":"$F$33*J32*J8","v":0},{"$f":"$F$33*K32*K8","v":0},0,0,0,0,0,0,0,0,0,0,1.01,1.0201,1.0303009999999999,1.04060401,1.0510100500999999,1.0615201506009999,1.0721353521070098,1.08285670562808,1.0936852726843609,1.1046221254112045,1.1156683466653166,1.1268250301319698,1.1380932804332895,1.1494742132376223,1.1609689553699987,1.1725786449236986,1.1843044313729356,1.196147475686665,1.2081089504435316,1.220190039947967,0]
[]
[]
[null,"Pre-tax Free Cash Flow (EBITDA and Cap Exp)"]
[null,null,"EBITDA",null,"m€",null,null,{"$f":"SUM(J37:AP37)","v":82.015071753190767},null,{"$f":"J28-J33","v":0},{"$f":"K28-K33","v":0},0,0,0,0,0,0,0,0,0,0,5.05,5.1004999999999994,5.1515050000000002,5.2030200500000001,5.2550502505000001,5.3076007530049996,5.3606767605350489,5.4142835281403991,5.4684263634218038,5.5231106270560222,2.7891708666632917,2.817062575329925,2.8452332010832238,2.8736855330940556,2.9024223884249976,2.9314466123092466,2.9607610784323395,2.9903686892166625,3.0202723761088284,3.0504750998699182,0]
[null,null,"Cap Exp",null,"m€",null,null,{"$f":"SUM(J38:AP38)","v":49.999999999999979},null,{"$f":"J18","v":4.1666666666666661},{"$f":"K18","v":4.1666666666666661},4.1666666666666661,4.1666666666666661,4.1666666666666661,4.1666666666666661,4.1666666666666661,4.1666666666666661,4.1666666666666661,4.1666666666666661,4.1666666666666661,4.1666666666666661,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Pre-tax Free Cash Flow","m€",null,null,null,null,{"$f":"J37-J38","v":-4.1666666666666661},{"$f":"K37-K38","v":-4.1666666666666661},-4.1666666666666661,-4.1666666666666661,-4.1666666666666661,-4.1666666666666661,-4.1666666666666661,-4.1666666666666661,-4.1666666666666661,-4.1666666666666661,-4.1666666666666661,-4.1666666666666661,5.05,5.1004999999999994,5.1515050000000002,5.2030200500000001,5.2550502505000001,5.3076007530049996,5.3606767605350489,5.4142835281403991,5.4684263634218038,5.5231106270560222,2.7891708666632917,2.817062575329925,2.8452332010832238,2.8736855330940556,2.9024223884249976,2.9314466123092466,2.9607610784323395,2.9903686892166625,3.0202723761088284,3.0504750998699182,0]
[]
[null,null,"Pre-tax Project IRR",null,"%",{"$f":"XIRR(J39:AP39,J7:AP7)","v":5.7795068621635443E-2}]
[]
[null,"Depreciation and (EBIT, Taxes on Operations, After FCF)"]
[null,null,"Plant Balance",null,"m€",null,null,null,null,{"$f":"I44+J38","v":4.1666666666666661},{"$f":"J44+K38","v":8.3333333333333321},12.499999999999998,16.666666666666664,20.833333333333329,24.999999999999993,29.166666666666657,33.333333333333321,37.499999999999986,41.66666666666665,45.833333333333314,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979]
[null,null,"Depreciation Rate",null,"%",{"$f":"1/Inputs!F31","v":0.05},null,{"$f":"SUM(J45:AP45)","v":1.0000000000000002},null,{"$f":"$F$45*J8","v":0},{"$f":"$F$45*K8","v":0},0,0,0,0,0,0,0,0,0,0,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0]
[null,null,"Depreciation Expense",null,"m€",null,null,null,null,{"$f":"J44*J45","v":0},{"$f":"K44*K45","v":0},0,0,0,0,0,0,0,0,0,0,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,0]
[null,null,"Accumulated Depreciation",null,"m€",null,null,null,null,{"$f":"I47+J46","v":0},{"$f":"J47+K46","v":0},0,0,0,0,0,0,0,0,0,0,2.4999999999999991,4.9999999999999982,7.4999999999999973,9.9999999999999964,12.499999999999996,14.999999999999996,17.499999999999996,19.999999999999996,22.499999999999996,24.999999999999996,27.499999999999996,29.999999999999996,32.499999999999993,34.999999999999993,37.499999999999993,39.999999999999993,42.499999999999993,44.999999999999993,47.499999999999993,49.999999999999993,49.999999999999993]
[]
[null,null,"EBITDA",null,"m€",null,null,null,null,{"$f":"J37","v":0},{"$f":"K37","v":0},0,0,0,0,0,0,0,0,0,0,5.05,5.1004999999999994,5.1515050000000002,5.2030200500000001,5.2550502505000001,5.3076007530049996,5.3606767605350489,5.4142835281403991,5.4684263634218038,5.5231106270560222,2.7891708666632917,2.817062575329925,2.8452332010832238,2.8736855330940556,2.9024223884249976,2.9314466123092466,2.9607610784323395,2.9903686892166625,3.0202723761088284,3.0504750998699182,0]
[null,null,"Less: Depreciation not Distorted by Financing",null,"m€",null,null,null,null,{"$f":"J46","v":0},{"$f":"K46","v":0},0,0,0,0,0,0,0,0,0,0,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,0]
[null,null,"EBIT",null,"m€",null,null,null,null,{"$f":"J49-J50","v":0},{"$f":"K49-K50","v":0},0,0,0,0,0,0,0,0,0,0,2.5500000000000007,2.6005000000000003,2.6515050000000011,2.703020050000001,2.755050250500001,2.8076007530050004,2.8606767605350498,2.9142835281404,2.9684263634218047,3.0231106270560231,0.28917086666329261,0.31706257532992588,0.34523320108322464,0.3736855330940565,0.40242238842499845,0.43144661230924752,0.46076107843234038,0.49036868921666343,0.52027237610882926,0.55047509986991905,0]
[null,null,"Taxes on EBIT",null,"m€",{"$f":"Inputs!F32","v":0.3},null,null,null,{"$f":"J51*$F$52","v":0},{"$f":"K51*$F$52","v":0},0,0,0,0,0,0,0,0,0,0,0.76500000000000024,0.78015000000000001,0.79545150000000031,0.81090601500000026,0.82651507515000022,0.84228022590150009,0.85820302816051497,0.87428505844212001,0.89052790902654133,0.9069331881168069,8.6751259998987779E-2,9.511877259897776E-2,0.10356996032496739,0.11210565992821694,0.12072671652749953,0.12943398369277426,0.1382283235297021,0.14711060676499901,0.15608171283264877,0.1651425299609757,0]
[]
[null,null,"Pre-tax Cash Flow",null,"m€",null,null,null,null,{"$f":"J39","v":-4.1666666666666661},{"$f":"K39","v":-4.1666666666666661},-4.1666666666666661,-4.1666666666666661,-4.1666666666666661,-4.1666666666666661,-4.1666666666666661,-4.1666666666666661,-4.1666666666666661,-4.1666666666666661,-4.1666666666666661,-4.1666666666666661,5.05,5.1004999999999994,5.1515050000000002,5.2030200500000001,5.2550502505000001,5.3076007530049996,5.3606767605350489,5.4142835281403991,5.4684263634218038,5.5231106270560222,2.7891708666632917,2.817062575329925,2.8452332010832238,2.8736855330940556,2.9024223884249976,2.9314466123092466,2.9607610784323395,2.9903686892166625,3.0202723761088284,3.0504750998699182,0]
[null,null,"After-tax Cash Flow",null,"m€",null,null,null,null,{"$f":"J54-J52","v":-4.1666666666666661},{"$f":"K54-K52","v":-4.1666666666666661},-4.1666666666666661,-4.1666666666666661,-4.1666666666666661,-4.1666666666666661,-4.1666666666666661,-4.1666666666666661,-4.1666666666666661,-4.1666666666666661,-4.1666666666666661,-4.1666666666666661,4.2849999999999993,4.3203499999999995,4.3560534999999998,4.3921140349999996,4.4285351753499995,4.4653205271034997,4.5024737323745336,4.5399984696982791,4.5778984543952621,4.6161774389392152,2.702419606664304,2.721943802730947,2.7416632407582564,2.7615798731658385,2.7816956718974981,2.8020126286164722,2.8225327549026376,2.8432580824516633,2.8641906632761795,2.8853325699089423,0]
[]
[null,null,"After-tax Project IRR",null,"%",{"$f":"XIRR(J55:AP55,J7:AP7)","v":4.058591425418856E-2}]
[]
[null,"Uses and Sorces of Funds"]
[null,null,"Uses of Funds",null,null,null,null,"Fixed","Calc","Difference"]
[null,null,null,"Cap Exp","m€",null,{"$f":"H38","v":49.999999999999979}]
[null,null,null,"IDC","m€",null,{"$f":"H62","v":7.1576381571034497},7.1576381571034497,{"$f":"H72","v":7.1576381571034497},{"$f":"H62-I62","v":0}]
[null,null,null,"Total ","m€",null,{"$f":"G61+G62","v":57.157638157103428}]
[]
[null,null,"Sources of Funds"]
[null,null,null,"Debt","m€",{"$f":"Inputs!F35","v":0.8},{"$f":"F66*G63","v":45.726110525682742}]
[null,null,null,"Equity","m€",null,{"$f":"G63-G66","v":11.431527631420686}]
[null,null,null,"Total","m€",null,{"$f":"SUM(G66:G67)","v":57.157638157103428}]
[]
[null,"Construction Financing"]
[null,null,null,"Cap Exp","m€",null,null,{"$f":"SUM(J71:AP71)","v":49.999999999999979},null,{"$f":"J18","v":4.1666666666666661},{"$f":"K18","v":4.1666666666666661},4.1666666666666661,4.1666666666666661,4.1666666666666661,4.1666666666666661,4.1666666666666661,4.1666666666666661,4.1666666666666661,4.1666666666666661,4.1666666666666661,4.1666666666666661,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"IDC","m€",null,null,{"$f":"SUM(J72:AP72)","v":7.1576381571034497},null,{"$f":"J89","v":0},{"$f":"K89","v":9.9999999999999992E-2},0.20239999999999997,0.30725759999999996,0.41463178239999993,0.52458294517759996,0.6371729358618623,0.75246508632254705,0.87052424839428821,0.9914168303557509,1.115210834284289,1.241975894307112,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 ","m€",null,null,57.157638157103449,null,{"$f":"SUM(J71:J72)","v":4.1666666666666661},{"$f":"SUM(K71:K72)","v":4.2666666666666657},4.369066666666666,4.4739242666666659,4.5812984490666659,4.6912496118442659,4.8038396025285284,4.9191317529892133,5.037190915060954,5.1580834970224174,5.2818775009509551,5.408642560973778,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","m€",{"$f":"F66","v":0.8},null,null,null,{"$f":"J73*$F$75","v":3.333333333333333},{"$f":"K73*$F$75","v":3.4133333333333327},3.4952533333333329,3.579139413333333,3.6650387592533331,3.7529996894754127,3.8430716820228228,3.9353054023913709,4.0297527320487632,4.1264667976179341,4.2255020007607644,4.326914048779023,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Equity","m€",{"$f":"1-F75","v":0.19999999999999996},null,null,null,{"$f":"J73-J75","v":0.83333333333333304},{"$f":"K73-K75","v":0.85333333333333306},0.87381333333333311,0.89478485333333291,0.91625968981333283,0.93824992236885318,0.96076792050570559,0.9838263505978424,1.0074381830121908,1.0316166994044833,1.0563755001901907,1.0817285121947551,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","m€",null,null,null,null,{"$f":"SUM(J75:J76)","v":4.1666666666666661},{"$f":"SUM(K75:K76)","v":4.2666666666666657},4.369066666666666,4.4739242666666659,4.5812984490666659,4.6912496118442659,4.8038396025285284,4.9191317529892133,5.037190915060954,5.1580834970224174,5.2818775009509551,5.408642560973778,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"Debt Balance"]
[null,null,"Debt Repayment Flag",null,"Flag",{"$f":"Inputs!F41","v":"2021-01-01"},{"$f":"Inputs!F42","v":"2041-01-01"},{"$f":"SUM(J81:AP81)","v":20},null,{"$f":"AND(J6>=$F$81,J6<=$G$81)*1","v":0},{"$f":"AND(K6>=$F$81,K6<=$G$81)*1","v":0},0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0]
[null,null,"Debt Repayment",null,"m€",{"$f":"G66","v":45.726110525682742},{"$f":"F82/H81","v":2.2863055262841372},null,null,{"$f":"$G$82*J81","v":0},{"$f":"$G$82*K81","v":0},0,0,0,0,0,0,0,0,0,0,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,0]
[]
[null,null,"Opening Balance",null,"m€",null,null,null,null,{"$f":"I87","v":0},{"$f":"J87","v":3.333333333333333},6.7466666666666661,10.241919999999999,13.821059413333332,17.486098172586665,21.239097862062078,25.082169544084902,29.017474946476273,33.047227678525033,37.17369447614297,41.399196476903732,45.726110525682756,43.439804999398618,41.153499473114479,38.867193946830341,36.580888420546202,34.294582894262064,32.008277367977925,29.721971841693787,27.435666315409648,25.14936078912551,22.863055262841371,20.576749736557232,18.290444210273094,16.004138683988955,13.717833157704819,11.431527631420682,9.1452221051365452,6.8589165788524085,4.5726110525682717,2.2863055262841345,0]
[null,null,"Add: Draws",null,"m€",null,null,null,null,{"$f":"J75","v":3.333333333333333},{"$f":"K75","v":3.4133333333333327},3.4952533333333329,3.579139413333333,3.6650387592533331,3.7529996894754127,3.8430716820228228,3.9353054023913709,4.0297527320487632,4.1264667976179341,4.2255020007607644,4.326914048779023,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Less: Repayment",null,"m€",null,null,null,null,{"$f":"J82","v":0},{"$f":"K82","v":0},0,0,0,0,0,0,0,0,0,0,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,0]
[null,null,"Closing",null,"m€",null,null,null,null,{"$f":"J84+J85-J86","v":3.333333333333333},{"$f":"K84+K85-K86","v":6.7466666666666661},10.241919999999999,13.821059413333332,17.486098172586665,21.239097862062078,25.082169544084902,29.017474946476273,33.047227678525033,37.17369447614297,41.399196476903732,45.726110525682756,43.439804999398618,41.153499473114479,38.867193946830341,36.580888420546202,34.294582894262064,32.008277367977925,29.721971841693787,27.435666315409648,25.14936078912551,22.863055262841371,20.576749736557232,18.290444210273094,16.004138683988955,13.717833157704819,11.431527631420682,9.1452221051365452,6.8589165788524085,4.5726110525682717,2.2863055262841345,0,0]
[null,null,"Interest",null,"m€",{"$f":"Inputs!F36","v":0.03},null,null,null,{"$f":"$F$88*J84","v":0},{"$f":"$F$88*K84","v":9.9999999999999992E-2},0.20239999999999997,0.30725759999999996,0.41463178239999993,0.52458294517759996,0.6371729358618623,0.75246508632254705,0.87052424839428821,0.9914168303557509,1.115210834284289,1.241975894307112,1.3717833157704826,1.3031941499819586,1.2346049841934343,1.1660158184049101,1.0974266526163861,1.0288374868278618,0.96024832103933777,0.89165915525081352,0.82306998946228938,0.75448082367376523,0.68589165788524109,0.61730249209671695,0.54871332630819281,0.48012416051966866,0.41153499473114452,0.34294582894262043,0.27435666315409635,0.20576749736557223,0.13717833157704815,6.8589165788524031E-2,0]
[null,null,"Interest During Construction",null,"m€",null,null,{"$f":"SUM(J89:AP89)","v":7.1576381571034497},null,{"$f":"J88*J4","v":0},{"$f":"K88*K4","v":9.9999999999999992E-2},0.20239999999999997,0.30725759999999996,0.41463178239999993,0.52458294517759996,0.6371729358618623,0.75246508632254705,0.87052424839428821,0.9914168303557509,1.115210834284289,1.241975894307112,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Interest Expense",null,"m€",null,null,null,null,{"$f":"J88-J89","v":0},{"$f":"K88-K89","v":0},0,0,0,0,0,0,0,0,0,0,1.3717833157704826,1.3031941499819586,1.2346049841934343,1.1660158184049101,1.0974266526163861,1.0288374868278618,0.96024832103933777,0.89165915525081352,0.82306998946228938,0.75448082367376523,0.68589165788524109,0.61730249209671695,0.54871332630819281,0.48012416051966866,0.41153499473114452,0.34294582894262043,0.27435666315409635,0.20576749736557223,0.13717833157704815,6.8589165788524031E-2,0]
[]
[]
[null,"Profit and Loss"]
[null,null,"IDC Balance",null,"m€",null,null,null,null,{"$f":"I94+J89","v":0},{"$f":"J94+K89","v":9.9999999999999992E-2},0.30239999999999995,0.60965759999999991,1.0242893823999999,1.5488723275776,2.1860452634394623,2.9385103497620095,3.8090345981562979,4.8004514285120488,5.9156622627963378,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497]
[null,null,"Depreciation on IDC",null,"m€",null,null,{"$f":"SUM(J95:AP95)","v":7.1576381571034471},null,{"$f":"J94*J45","v":0},{"$f":"K94*K45","v":0},0,0,0,0,0,0,0,0,0,0,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0]
[null,null,"Accumulated Depreciation",null,"m€",null,null,null,null,{"$f":"I96+J95","v":0},{"$f":"J96+K95","v":0},0,0,0,0,0,0,0,0,0,0,0.35788190785517249,0.71576381571034497,1.0736457235655175,1.4315276314206899,1.7894095392758624,2.1472914471310349,2.5051733549862076,2.8630552628413799,3.2209371706965522,3.5788190785517244,3.9367009864068967,4.294582894262069,4.6524648021172412,5.0103467099724135,5.3682286178275858,5.726110525682758,6.0839924335379303,6.4418743413931026,6.7997562492482748,7.1576381571034471,7.1576381571034471]
[]
[null,null,"Revenues",null,"m€",null,null,null,null,{"$f":"J28","v":0},{"$f":"K28","v":0},0,0,0,0,0,0,0,0,0,0,6.06,6.1205999999999996,6.1818059999999999,6.2436240600000001,6.3060603005999996,6.3691209036059995,6.4328121126420585,6.4971402337684792,6.5621116361061649,6.6277327524672272,3.9048392133286081,3.9438876054618945,3.9833264815165133,4.0231597463316779,4.0633913437949962,4.1040252572329452,4.1450655098052751,4.1865161649033276,4.22838132655236,4.2706651398178854,0]
[null,null,"Less: Expenses",null,"m€",null,null,null,null,{"$f":"J33","v":0},{"$f":"K33","v":0},0,0,0,0,0,0,0,0,0,0,1.01,1.0201,1.0303009999999999,1.04060401,1.0510100500999999,1.0615201506009999,1.0721353521070098,1.08285670562808,1.0936852726843609,1.1046221254112045,1.1156683466653166,1.1268250301319698,1.1380932804332895,1.1494742132376223,1.1609689553699987,1.1725786449236986,1.1843044313729356,1.196147475686665,1.2081089504435316,1.220190039947967,0]
[null,null,"EBITDA",null,"m€",null,null,null,null,{"$f":"J98-J99","v":0},{"$f":"K98-K99","v":0},0,0,0,0,0,0,0,0,0,0,5.05,5.1004999999999994,5.1515050000000002,5.2030200500000001,5.2550502505000001,5.3076007530049996,5.3606767605350489,5.4142835281403991,5.4684263634218038,5.5231106270560222,2.7891708666632917,2.817062575329925,2.8452332010832238,2.8736855330940556,2.9024223884249976,2.9314466123092466,2.9607610784323395,2.9903686892166625,3.0202723761088284,3.0504750998699182,0]
[null,null,"Less: Depreciation Base",null,"m€",null,null,null,null,{"$f":"J46","v":0},{"$f":"K46","v":0},0,0,0,0,0,0,0,0,0,0,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,2.4999999999999991,0]
[null,null,"Less: Depreciation IDC",null,"m€",null,null,null,null,{"$f":"J95","v":0},{"$f":"K95","v":0},0,0,0,0,0,0,0,0,0,0,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0.35788190785517249,0]
[null,null,"EBIT",null,"m€",null,null,null,null,{"$f":"J100-J101-J102","v":0},{"$f":"K100-K101-K102","v":0},0,0,0,0,0,0,0,0,0,0,2.1921180921448284,2.242618092144828,2.2936230921448288,2.3451381421448287,2.3971683426448287,2.4497188451498282,2.5027948526798776,2.5564016202852278,2.6105444555666324,2.6652287192008508,-6.8711041191879874E-2,-4.081933252524661E-2,-1.2648706771947849E-2,1.5803625238884011E-2,4.4540480569825958E-2,7.3564704454075036E-2,0.10287917057716789,0.13248678136149095,0.16239046825365677,0.19259319201474656,0]
[null,null,"Less: Interest Expense",null,"m€",null,null,null,null,{"$f":"J90","v":0},{"$f":"K90","v":0},0,0,0,0,0,0,0,0,0,0,1.3717833157704826,1.3031941499819586,1.2346049841934343,1.1660158184049101,1.0974266526163861,1.0288374868278618,0.96024832103933777,0.89165915525081352,0.82306998946228938,0.75448082367376523,0.68589165788524109,0.61730249209671695,0.54871332630819281,0.48012416051966866,0.41153499473114452,0.34294582894262043,0.27435666315409635,0.20576749736557223,0.13717833157704815,6.8589165788524031E-2,0]
[null,null,"EBT",null,"m€",null,null,null,null,{"$f":"J103-J104","v":0},{"$f":"K103-K104","v":0},0,0,0,0,0,0,0,0,0,0,0.82033477637434582,0.9394239421628694,1.0590181079513945,1.1791223237399187,1.2997416900284426,1.4208813583219664,1.5425465316405398,1.6647424650344143,1.7874744661043431,1.9107478955270856,-0.75460269907712096,-0.65812182462196356,-0.56136203308014065,-0.46432053528078465,-0.36699451416131856,-0.2693811244885454,-0.17147749257692846,-7.3280716004081287E-2,2.5212136676608626E-2,0.12400402622622253,0]
[null,null,"Taxes",null,"m€",{"$f":"Inputs!F32","v":0.3},null,null,null,{"$f":"J105*$F$106","v":0},{"$f":"K105*$F$106","v":0},0,0,0,0,0,0,0,0,0,0,0.24610043291230374,0.28182718264886081,0.31770543238541832,0.35373669712197559,0.38992250700853276,0.42626440749658989,0.46276395949216192,0.49942273951032423,0.53624233983130287,0.57322436865812565,-0.22638080972313629,-0.19743654738658906,-0.16840860992404219,-0.13929616058423538,-0.11009835424839556,-8.0814337346563611E-2,-5.1443247773078536E-2,-2.1984214801224384E-2,7.5636410029825876E-3,3.7201207867866758E-2,0]
[null,null,"Net Income",null,"m€",null,null,null,null,{"$f":"J105-J106","v":0},{"$f":"K105-K106","v":0},0,0,0,0,0,0,0,0,0,0,0.57423434346204205,0.65759675951400864,0.74131267556597624,0.82538562661794312,0.90981918301990983,0.99461695082537649,1.0797825721483778,1.1653197255240899,1.2512321262730404,1.33752352686896,-0.52822188935398473,-0.4606852772353745,-0.39295342315609849,-0.32502437469654927,-0.25689615991292303,-0.18856678714198177,-0.12003424480384992,-5.1296501202856906E-2,1.7648495673626037E-2,8.6802818358355766E-2,0]
[]
[null,"Cash Flow post COD"]
[null,null,"EBITDA",null,"m€",null,null,null,null,{"$f":"J100","v":0},{"$f":"K100","v":0},0,0,0,0,0,0,0,0,0,0,5.05,5.1004999999999994,5.1515050000000002,5.2030200500000001,5.2550502505000001,5.3076007530049996,5.3606767605350489,5.4142835281403991,5.4684263634218038,5.5231106270560222,2.7891708666632917,2.817062575329925,2.8452332010832238,2.8736855330940556,2.9024223884249976,2.9314466123092466,2.9607610784323395,2.9903686892166625,3.0202723761088284,3.0504750998699182,0]
[null,null,"Less: Taxes",null,null,null,null,null,null,{"$f":"J106","v":0},{"$f":"K106","v":0},0,0,0,0,0,0,0,0,0,0,0.24610043291230374,0.28182718264886081,0.31770543238541832,0.35373669712197559,0.38992250700853276,0.42626440749658989,0.46276395949216192,0.49942273951032423,0.53624233983130287,0.57322436865812565,-0.22638080972313629,-0.19743654738658906,-0.16840860992404219,-0.13929616058423538,-0.11009835424839556,-8.0814337346563611E-2,-5.1443247773078536E-2,-2.1984214801224384E-2,7.5636410029825876E-3,3.7201207867866758E-2,0]
[null,null,"CFADS",null,null,null,null,null,null,{"$f":"J110-J111","v":0},{"$f":"K110-K111","v":0},0,0,0,0,0,0,0,0,0,0,4.8038995670876963,4.8186728173511382,4.833799567614582,4.8492833528780244,4.8651277434914677,4.8813363455084096,4.897912801042887,4.914860788630075,4.9321840235905006,4.9498862583978962,3.0155516763864281,3.0144991227165141,3.013641811007266,3.0129816936782912,3.0125207426733933,3.0122609496558104,3.0122043262054179,3.0123529040178871,3.0127087351058459,3.0132738920020512,0]
[null,null,"Less: Interest Expense",null,null,null,null,null,null,{"$f":"J104","v":0},{"$f":"K104","v":0},0,0,0,0,0,0,0,0,0,0,1.3717833157704826,1.3031941499819586,1.2346049841934343,1.1660158184049101,1.0974266526163861,1.0288374868278618,0.96024832103933777,0.89165915525081352,0.82306998946228938,0.75448082367376523,0.68589165788524109,0.61730249209671695,0.54871332630819281,0.48012416051966866,0.41153499473114452,0.34294582894262043,0.27435666315409635,0.20576749736557223,0.13717833157704815,6.8589165788524031E-2,0]
[null,null,"Less: Repayment",null,null,null,null,null,null,{"$f":"J86","v":0},{"$f":"K86","v":0},0,0,0,0,0,0,0,0,0,0,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,2.2863055262841372,0]
[null,null,"Net Cash Flow",null,null,null,null,null,null,{"$f":"J112-J113-J114","v":0},{"$f":"K112-K113-K114","v":0},0,0,0,0,0,0,0,0,0,0,1.1458107250330767,1.2291731410850422,1.3128890571370104,1.3969620081889773,1.4813955645909442,1.5661933323964106,1.651358953719412,1.7368961070951241,1.8228085078440741,1.9090999084399942,4.3354492217049678E-2,0.11089110433566018,0.17862295841493614,0.24655200687448531,0.31468022165811149,0.38300959442905258,0.45154213676718458,0.52027988036817785,0.58922487724466066,0.65837919992938998,0]
[null,null,"Dividends",null,null,null,null,null,null,{"$f":"J115","v":0},{"$f":"K115","v":0},0,0,0,0,0,0,0,0,0,0,1.1458107250330767,1.2291731410850422,1.3128890571370104,1.3969620081889773,1.4813955645909442,1.5661933323964106,1.651358953719412,1.7368961070951241,1.8228085078440741,1.9090999084399942,4.3354492217049678E-2,0.11089110433566018,0.17862295841493614,0.24655200687448531,0.31468022165811149,0.38300959442905258,0.45154213676718458,0.52027988036817785,0.58922487724466066,0.65837919992938998,0]
[]
[null,null,"Equity Cash Flow",null,"m€",null,null,null,null,{"$f":"J116-J76","v":-0.83333333333333304},{"$f":"K116-K76","v":-0.85333333333333306},-0.87381333333333311,-0.89478485333333291,-0.91625968981333283,-0.93824992236885318,-0.96076792050570559,-0.9838263505978424,-1.0074381830121908,-1.0316166994044833,-1.0563755001901907,-1.0817285121947551,1.1458107250330767,1.2291731410850422,1.3128890571370104,1.3969620081889773,1.4813955645909442,1.5661933323964106,1.651358953719412,1.7368961070951241,1.8228085078440741,1.9090999084399942,4.3354492217049678E-2,0.11089110433566018,0.17862295841493614,0.24655200687448531,0.31468022165811149,0.38300959442905258,0.45154213676718458,0.52027988036817785,0.58922487724466066,0.65837919992938998,0]
[null,null,"Equity IRR",null,"%",{"$f":"XIRR(J118:AP118,J7:AP7)","v":6.5959796309471116E-2}]
[]
[null,null,"DSCR",null,null,null,null,{"$f":"MIN(J121:AP121)","v":1.014586681007561},null,{"$f":"IFERROR(J112/(J113+J114),FALSE)","v":false},{"$f":"IFERROR(K112/(K113+K114),FALSE)","v":false},false,false,false,false,false,false,false,false,false,false,1.313226598506972,1.3424357854695965,1.3728833928695712,1.4046442577942588,1.4377992956500165,1.4724361290604444,1.5086497964852257,1.5465435526036768,1.5862297746325749,1.6278309913047406,1.014586681007561,1.0381907969786832,1.0630059155520621,1.0891228170557044,1.1166415209523533,1.1456724910182732,1.1763380342122538,1.2087739305512861,1.2431313397584061,1.2795790411119903,false]
[]
[null,"Balance Sheet"]
[null,null,"Equity"]
[null,null,null,"Opening Balance",null,null,null,null,null,{"$f":"I129","v":0},{"$f":"J129","v":0.83333333333333304},1.6866666666666661,2.5604799999999992,3.4552648533333321,4.3715245431466645,5.3097744655155177,6.2705423860212228,7.2543687366190657,8.2618069196312565,9.2934236190357389,10.34979911922593,11.431527631420686,10.859951249849651,10.288374868278618,9.7167984867075852,9.1452221051365523,8.5736457235655177,8.0020693419944831,7.4304929604234493,6.8589165788524156,6.2873401972813809,5.7157638157103463,5.1441874341393117,4.572611052568277,4.0010346709972424,3.4294582894262078,2.8578819078551732,2.286305526284139,1.7147291447131043,1.1431527631420695,0.57157638157103485,0]
[null,null,null,"Add: Equity Issued",null,null,null,null,null,{"$f":"J76","v":0.83333333333333304},{"$f":"K76","v":0.85333333333333306},0.87381333333333311,0.89478485333333291,0.91625968981333283,0.93824992236885318,0.96076792050570559,0.9838263505978424,1.0074381830121908,1.0316166994044833,1.0563755001901907,1.0817285121947551,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Add: Net Income",null,null,null,null,null,{"$f":"J107","v":0},{"$f":"K107","v":0},0,0,0,0,0,0,0,0,0,0,0.57423434346204205,0.65759675951400864,0.74131267556597624,0.82538562661794312,0.90981918301990983,0.99461695082537649,1.0797825721483778,1.1653197255240899,1.2512321262730404,1.33752352686896,-0.52822188935398473,-0.4606852772353745,-0.39295342315609849,-0.32502437469654927,-0.25689615991292303,-0.18856678714198177,-0.12003424480384992,-5.1296501202856906E-2,1.7648495673626037E-2,8.6802818358355766E-2,0]
[null,null,null,"Less: Dividends",null,null,null,null,null,{"$f":"J116","v":0},{"$f":"K116","v":0},0,0,0,0,0,0,0,0,0,0,1.1458107250330767,1.2291731410850422,1.3128890571370104,1.3969620081889773,1.4813955645909442,1.5661933323964106,1.651358953719412,1.7368961070951241,1.8228085078440741,1.9090999084399942,4.3354492217049678E-2,0.11089110433566018,0.17862295841493614,0.24655200687448531,0.31468022165811149,0.38300959442905258,0.45154213676718458,0.52027988036817785,0.58922487724466066,0.65837919992938998,0]
[null,null,null,"Closing",null,null,null,null,null,{"$f":"J125+J126+J127-J128","v":0.83333333333333304},{"$f":"K125+K126+K127-K128","v":1.6866666666666661},2.5604799999999992,3.4552648533333321,4.3715245431466645,5.3097744655155177,6.2705423860212228,7.2543687366190657,8.2618069196312565,9.2934236190357389,10.34979911922593,11.431527631420686,10.859951249849651,10.288374868278618,9.7167984867075852,9.1452221051365523,8.5736457235655177,8.0020693419944831,7.4304929604234493,6.8589165788524156,6.2873401972813809,5.7157638157103463,5.1441874341393117,4.572611052568277,4.0010346709972424,3.4294582894262078,2.8578819078551732,2.286305526284139,1.7147291447131043,1.1431527631420695,0.57157638157103485,0,0]
[]
[null,null,"Plant Balance"]
[null,null,null,"Plant",null,null,null,null,null,{"$f":"J44","v":4.1666666666666661},{"$f":"K44","v":8.3333333333333321},12.499999999999998,16.666666666666664,20.833333333333329,24.999999999999993,29.166666666666657,33.333333333333321,37.499999999999986,41.66666666666665,45.833333333333314,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979,49.999999999999979]
[null,null,null,"Less: Acc Depreciation",null,null,null,null,null,{"$f":"-J47","v":0},{"$f":"-K47","v":0},0,0,0,0,0,0,0,0,0,0,-2.4999999999999991,-4.9999999999999982,-7.4999999999999973,-9.9999999999999964,-12.499999999999996,-14.999999999999996,-17.499999999999996,-19.999999999999996,-22.499999999999996,-24.999999999999996,-27.499999999999996,-29.999999999999996,-32.499999999999993,-34.999999999999993,-37.499999999999993,-39.999999999999993,-42.499999999999993,-44.999999999999993,-47.499999999999993,-49.999999999999993,-49.999999999999993]
[null,null,null,"IDC Accumulated",null,null,null,null,null,{"$f":"J94","v":0},{"$f":"K94","v":9.9999999999999992E-2},0.30239999999999995,0.60965759999999991,1.0242893823999999,1.5488723275776,2.1860452634394623,2.9385103497620095,3.8090345981562979,4.8004514285120488,5.9156622627963378,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497,7.1576381571034497]
[null,null,null,"Less: Acc IDC Depreciation",null,null,null,null,null,{"$f":"-J96","v":0},{"$f":"-K96","v":0},0,0,0,0,0,0,0,0,0,0,-0.35788190785517249,-0.71576381571034497,-1.0736457235655175,-1.4315276314206899,-1.7894095392758624,-2.1472914471310349,-2.5051733549862076,-2.8630552628413799,-3.2209371706965522,-3.5788190785517244,-3.9367009864068967,-4.294582894262069,-4.6524648021172412,-5.0103467099724135,-5.3682286178275858,-5.726110525682758,-6.0839924335379303,-6.4418743413931026,-6.7997562492482748,-7.1576381571034471,-7.1576381571034471]
[null,null,null,"Total Assets",null,null,null,null,null,{"$f":"SUM(J132:J135)","v":4.1666666666666661},{"$f":"SUM(K132:K135)","v":8.4333333333333318},12.802399999999999,17.276324266666663,21.857622715733328,26.548872327577591,31.352711930106118,36.271843683095334,41.309034598156281,46.467118095178698,51.748995596129653,57.157638157103428,54.299756249248254,51.441874341393081,48.583992433537908,45.726110525682742,42.868228617827569,40.010346709972403,37.15246480211723,34.294582894262057,31.436700986406883,28.57881907855171,25.720937170696534,22.863055262841364,20.005173354986194,17.147291447131021,14.289409539275848,11.431527631420677,8.5736457235655053,5.7157638157103321,2.8578819078551598,-1.1546319456101628E-14,-1.1546319456101628E-14]
[]
[null,null,"Total Debt",null,null,null,null,null,null,{"$f":"J87","v":3.333333333333333},{"$f":"K87","v":6.7466666666666661},10.241919999999999,13.821059413333332,17.486098172586665,21.239097862062078,25.082169544084902,29.017474946476273,33.047227678525033,37.17369447614297,41.399196476903732,45.726110525682756,43.439804999398618,41.153499473114479,38.867193946830341,36.580888420546202,34.294582894262064,32.008277367977925,29.721971841693787,27.435666315409648,25.14936078912551,22.863055262841371,20.576749736557232,18.290444210273094,16.004138683988955,13.717833157704819,11.431527631420682,9.1452221051365452,6.8589165788524085,4.5726110525682717,2.2863055262841345,0,0]
[null,null,"Total Equity",null,null,null,null,null,null,{"$f":"J129","v":0.83333333333333304},{"$f":"K129","v":1.6866666666666661},2.5604799999999992,3.4552648533333321,4.3715245431466645,5.3097744655155177,6.2705423860212228,7.2543687366190657,8.2618069196312565,9.2934236190357389,10.34979911922593,11.431527631420686,10.859951249849651,10.288374868278618,9.7167984867075852,9.1452221051365523,8.5736457235655177,8.0020693419944831,7.4304929604234493,6.8589165788524156,6.2873401972813809,5.7157638157103463,5.1441874341393117,4.572611052568277,4.0010346709972424,3.4294582894262078,2.8578819078551732,2.286305526284139,1.7147291447131043,1.1431527631420695,0.57157638157103485,0,0]
[null,null,"Total",null,null,null,null,null,null,{"$f":"SUM(J138:J139)","v":4.1666666666666661},{"$f":"SUM(K138:K139)","v":8.4333333333333318},12.802399999999999,17.276324266666663,21.857622715733328,26.548872327577595,31.352711930106125,36.271843683095341,41.309034598156288,46.467118095178705,51.74899559612966,57.157638157103442,54.299756249248269,51.441874341393095,48.583992433537929,45.726110525682756,42.868228617827583,40.01034670997241,37.152464802117237,34.294582894262064,31.43670098640689,28.578819078551717,25.720937170696544,22.863055262841371,20.005173354986198,17.147291447131025,14.289409539275855,11.431527631420684,8.5736457235655124,5.715763815710341,2.8578819078551696,0,0]
[]
[null,null,null,null,null,null,null,{"$f":"AND(J142:AP142)","v":true},null,{"$f":"ROUND(J140-J136,0)=0","v":true},{"$f":"ROUND(K140-K136,0)=0","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]
[null,"Graph"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J8,J7,NA())","v":{"$error":"#N/A"}},{"$f":"IF(K8,K7,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"2022-01-13","2023-01-14","2024-01-15","2025-01-16","2026-01-17","2027-01-18","2028-01-19","2029-01-20","2030-01-21","2031-01-22","2032-01-23","2033-01-24","2034-01-25","2035-01-26","2036-01-27","2037-01-28","2038-01-29","2039-01-30","2040-01-31","2041-02-01",{"$error":"#N/A"}]
[null,null,"CFADS",null,null,null,null,null,null,{"$f":"J112","v":0},{"$f":"K112","v":0},0,0,0,0,0,0,0,0,0,0,4.8038995670876963,4.8186728173511382,4.833799567614582,4.8492833528780244,4.8651277434914677,4.8813363455084096,4.897912801042887,4.914860788630075,4.9321840235905006,4.9498862583978962,3.0155516763864281,3.0144991227165141,3.013641811007266,3.0129816936782912,3.0125207426733933,3.0122609496558104,3.0122043262054179,3.0123529040178871,3.0127087351058459,3.0132738920020512,0]
[null,null,"Debt Service",null,null,null,null,null,null,{"$f":"J86+J90","v":0},{"$f":"K86+K90","v":0},0,0,0,0,0,0,0,0,0,0,3.65808884205462,3.5894996762660956,3.5209105104775715,3.4523213446890475,3.383732178900523,3.315143013111999,3.246553847323475,3.1779646815349505,3.1093755157464265,3.0407863499579024,2.9721971841693784,2.9036080183808544,2.8350188525923299,2.7664296868038059,2.6978405210152818,2.6292513552267578,2.5606621894382338,2.4920730236497093,2.4234838578611853,2.3548946920726612,0]