{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Model Tollway Case","Structuring","Sweep Adjustment","Sub Debt","CF and DS Graph","Waterfall Chart","Sheet1"],"not_rendered":{"charts":8,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Structuring","index":1,"reason":"not_a_worksheet"},{"sheet":"Sweep Adjustment","index":2,"reason":"not_a_worksheet"},{"sheet":"CF and DS Graph","index":4,"reason":"not_a_worksheet"},{"sheet":"Waterfall Chart","index":5,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Model Tollway Case","index":0,"n_rows":163,"n_cols":128,"rows_kept":163,"cut":false,"hidden":false,"merged":[]}
[{"$f":"_xlfn.SEQUENCE(,100)","v":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,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100]
[{"$f":"A1-$I$1+1","v":-7},{"$f":"B1-$I$1+1","v":-6},-5,-4,-3,-2,-1,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,{"$f":"BN1-$I$1+1","v":58},59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92]
[null,"Timing "]
[null,null,"Period",null,null,null,null,null,{"$f":"_xlfn.SEQUENCE(,120)","v":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,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120]
[null,null,"Construction Periods",null,"Years",1,null,null,{"$f":"I4<=$F$5","v":true},{"$f":"J4<=$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]
[null,null,"Operating Life",null,"Life",30,{"$f":"F6+F5","v":31},null,{"$f":"AND(NOT(I5),I4<=$G$6)","v":false},{"$f":"AND(NOT(J5),J4<=$G$6)","v":true},{"$f":"AND(NOT(K5),K4<=$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,false,false,false,false,false,false,false,false,false]
[]
[null,"Operating Cash Flow"]
[null,null,"Inflation Index",null,"%",0.02,1,null,{"$f":"G9*(1+$F$9*I6)","v":1},{"$f":"I9*(1+$F$9*J6)","v":1.02},1.0404,1.0612079999999999,1.08243216,1.1040808032,1.1261624192640001,1.14868566764928,1.1716593810022657,1.1950925686223111,1.2189944199947573,1.2433743083946525,1.2682417945625455,1.2936066304537963,1.3194787630628724,1.3458683383241299,1.3727857050906125,1.4002414191924248,1.4282462475762734,1.4568111725277988,1.4859473959783549,1.5156663438979221,1.5459796707758806,1.5768992641913981,1.6084372494752261,1.6406059944647307,1.6734181143540252,1.7068864766411058,1.7410242061739281,1.7758446902974065,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548]
[]
[null,null,"Revenues (Minimum Traffic Case)",null,"Annual Euro",65,null,{"$f":"SUM(I11:XFD11)","v":2689.6636513026183},{"$f":"$F$11*I9*I6","v":0},{"$f":"$F$11*J9*J6","v":66.3},67.626000000000005,68.978519999999989,70.358090399999995,71.765252208000007,73.20055725216001,74.664568397203197,76.157859765147279,77.681016960450222,79.234637299659227,80.819330045652407,82.435716646565453,84.084430979496759,85.766119599086707,87.481441991068436,89.231070830889806,91.015692247507616,92.836006092457765,94.692726214306916,96.586580738593071,98.518312353364934,100.48867860043224,102.49845217244088,104.5484212158897,106.6393896402075,108.77217743301163,110.94762098167188,113.16657340130533,115.42990486933142,117.73850296671806,0,0,0,0,0,0,0,0,0]
[null,null,"Operating Expense",null,"Annual Euro",10,null,{"$f":"SUM(I12:XFD12)","v":413.79440789271058},{"$f":"$F$12*I9*I6","v":0},{"$f":"$F$12*J9*J6","v":10.199999999999999},10.404,10.612079999999999,10.824321599999999,11.040808032000001,11.261624192640001,11.486856676492801,11.716593810022658,11.95092568622311,12.189944199947574,12.433743083946524,12.682417945625454,12.936066304537963,13.194787630628724,13.458683383241299,13.727857050906124,14.002414191924249,14.282462475762735,14.568111725277987,14.85947395978355,15.156663438979221,15.459796707758805,15.768992641913982,16.084372494752262,16.406059944647307,16.734181143540251,17.068864766411057,17.410242061739282,17.758446902974065,18.11361584103355,0,0,0,0,0,0,0,0,0]
[null,null,"Capital Expenditure",null,"One Time",1000,{"$f":"F5","v":1},null,{"$f":"$F$13/$G$13*I5","v":1000},{"$f":"$F$13/$G$13*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]
[]
[null,null,"EBITDA",null,"Euro",null,null,{"$f":"SUM(I15:XFD15)","v":2275.869243409908},{"$f":"I11-I12","v":0},{"$f":"J11-J12","v":56.099999999999994},57.222000000000008,58.36643999999999,59.533768799999997,60.724444176000006,61.938933059520011,63.177711720710398,64.441265955124621,65.730091274227107,67.044693099711651,68.385586961705883,69.753298700939993,71.148364674958799,72.571331968457983,74.022758607827143,75.503213779983682,77.01327805558337,78.553543616695038,80.124614489028929,81.727106778809514,83.361648914385711,85.028881892673439,86.729459530526896,88.464048721137445,90.233329695560187,92.03799628947138,93.878756215260822,95.756331339566046,97.671457966357366,99.624887125684509,0,0,0,0,0,0,0,0,0]
[null,null,"Free Cash Flow",null,"Euro",null,null,{"$f":"SUM(I16:XFD16)","v":1275.8692434099082},{"$f":"I15-I13","v":-1000},{"$f":"J15-J13","v":56.099999999999994},57.222000000000008,58.36643999999999,59.533768799999997,60.724444176000006,61.938933059520011,63.177711720710398,64.441265955124621,65.730091274227107,67.044693099711651,68.385586961705883,69.753298700939993,71.148364674958799,72.571331968457983,74.022758607827143,75.503213779983682,77.01327805558337,78.553543616695038,80.124614489028929,81.727106778809514,83.361648914385711,85.028881892673439,86.729459530526896,88.464048721137445,90.233329695560187,92.03799628947138,93.878756215260822,95.756331339566046,97.671457966357366,99.624887125684509,0,0,0,0,0,0,0,0,0]
[null,null,"PIRR",null,"% p.a.",{"$f":"IRR(I16:AV16)","v":5.6638622000197314E-2}]
[]
[null,null,"Opening Balance",null,"Euro",null,null,null,{"$f":"H22","v":0},{"$f":"I22","v":0},56.099999999999994,116.49942669421108,181.4642336859842,251.2758866242801,326.23225076055718,406.64852895517799,492.85825299431701,585.21433124046439,684.09015581091842,789.88077265966081,903.00411812926109,1023.9023257415458,1153.0431072093031,1290.9212118769219,1438.0599690362828,1595.012917816128,1762.3655296093309,1940.7370282837464,2130.7823137195246,2333.1939945298004,2548.7045361534897,2778.0885308595489,3022.1650965725134,3281.8004118206113,3557.910394521371,3851.4635327567112,4163.4838761513238,4495.0541969561409,4847.3193304542974,5221.4897048518324,5221.4897048518324,5221.4897048518324,5221.4897048518324,5221.4897048518324,5221.4897048518324,5221.4897048518324,5221.4897048518324,5221.4897048518324]
[null,null,"Add: Re-Investment",null,"Euro",{"$f":"F17","v":5.6638622000197314E-2},null,null,{"$f":"I19*$F$20*I6","v":0},{"$f":"J19*$F$20*J6","v":0},3.1774266942110692,6.5983669917731183,10.277884138295931,14.231919960277038,18.47734513510078,23.03201231842862,27.914812291022738,33.145733296226922,38.745923749030695,44.73775850789432,51.144908911344743,57.992416792798316,65.306772699160703,73.115998551533607,81.449734999861477,90.339333737619455,99.81795505772044,109.92067094674935,120.684574031466,132.14889270930379,144.35511281338574,157.34710618243747,171.17126652696041,185.87665300519947,201.51514194586883,218.14158717935192,235.81398946525115,254.59367553179936,274.5454872718505,0,0,0,0,0,0,0,0,0]
[null,null,"Add: Dividends",null,"Euro",null,null,null,{"$f":"I15","v":0},{"$f":"J15","v":56.099999999999994},57.222000000000008,58.36643999999999,59.533768799999997,60.724444176000006,61.938933059520011,63.177711720710398,64.441265955124621,65.730091274227107,67.044693099711651,68.385586961705883,69.753298700939993,71.148364674958799,72.571331968457983,74.022758607827143,75.503213779983682,77.01327805558337,78.553543616695038,80.124614489028929,81.727106778809514,83.361648914385711,85.028881892673439,86.729459530526896,88.464048721137445,90.233329695560187,92.03799628947138,93.878756215260822,95.756331339566046,97.671457966357366,99.624887125684509,0,0,0,0,0,0,0,0,0]
[null,null,"Closing Balance",null,"Euro",null,null,null,{"$f":"SUM(I19:I21)","v":0},{"$f":"SUM(J19:J21)","v":56.099999999999994},116.49942669421108,181.4642336859842,251.2758866242801,326.23225076055718,406.64852895517799,492.85825299431701,585.21433124046439,684.09015581091842,789.88077265966081,903.00411812926109,1023.9023257415458,1153.0431072093031,1290.9212118769219,1438.0599690362828,1595.012917816128,1762.3655296093309,1940.7370282837464,2130.7823137195246,2333.1939945298004,2548.7045361534897,2778.0885308595489,3022.1650965725134,3281.8004118206113,3557.910394521371,3851.4635327567112,4163.4838761513238,4495.0541969561409,4847.3193304542974,5221.4897048518324,5221.4897048518324,5221.4897048518324,5221.4897048518324,5221.4897048518324,5221.4897048518324,5221.4897048518324,5221.4897048518324,5221.4897048518324,5221.4897048518324]
[]
[null,null,"Ending Balance",null,"Euro"]
[null,null,"Investment",null,"Euro"]
[null,null,"Growth Ratio",null,"x"]
[null,null,"Annual Growth",null,"% p.a."]
[]
[null,"Debt Structuring"]
[null,null,"Tenure of Debt",null,"Years",30]
[null,null,"Interest Rate",null,"% p.a.",4.4999999999999998E-2]
[null,null,"DSCR for Sizing",null,"x",1.3]
[]
[null,null,"Flag for Tenure",null,"Flag",{"$f":"F30","v":30},null,null,{"$f":"AND(NOT(I5),I4<=$F$34)","v":false},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]
[null,null,"CFADS for Tenure",null,"Euro",null,null,null,{"$f":"IF(I34,I15)","v":false},56.099999999999994,57.222000000000008,58.36643999999999,59.533768799999997,60.724444176000006,61.938933059520011,63.177711720710398,64.441265955124621,65.730091274227107,67.044693099711651,68.385586961705883,69.753298700939993,71.148364674958799,72.571331968457983,74.022758607827143,75.503213779983682,77.01327805558337,78.553543616695038,80.124614489028929,81.727106778809514,83.361648914385711,85.028881892673439,86.729459530526896,88.464048721137445,90.233329695560187,92.03799628947138,93.878756215260822,95.756331339566046,97.671457966357366,false,false,false,false,false,false,false,false,false,false]
[null,null,"Target Debt Service =CFADS/DSCR",null,"Euro",{"$f":"F32","v":1.3},null,null,{"$f":"IF(I34,I35/$F$36)","v":false},{"$f":"IF(J34,J35/$F$36)","v":43.153846153846146},44.016923076923085,44.897261538461528,45.795206769230766,46.711110904615389,47.645333122707697,48.598239785161844,49.570204580865088,50.561608672482386,51.572840845932035,52.604297662850676,53.656383616107682,54.72951128842984,55.824101514198446,56.940583544482415,58.07939521537206,59.240983119679512,60.425802782073106,61.634318837714559,62.867005214468854,64.12434531875823,65.406832225133414,66.714968869636067,68.049268247028806,69.410253611969367,70.798458684208754,72.214427857892943,73.658716415050804,75.131890743351818,false,false,false,false,false,false,false,false,false,false]
[null,null,"PV of Debt =Debt",null,"Euro",{"$f":"NPV(F31,I36:AV36)","v":870.86647705304927},{"$f":"F37/F13","v":0.87086647705304931}]
[]
[null,null,"Opening Balance",null,"Euro",null,null,null,{"$f":"G42","v":0},{"$f":"I42","v":870.86647705304927},866.90162236659035,861.89527229616385,855.78329801102973,848.49833965229527,839.96965403203319,830.12295534076702,818.88024854593971,806.15965514964194,791.87523095889344,775.93677550611164,758.24963274103595,738.71448259827491,717.22712302676746,693.67824204877354,667.95317939648589,639.93167725395574,609.4876196107042,576.48875971111283,540.79643506039838,502.26526942364745,460.74286122895336,416.06945775912283,368.07761448864727,316.59183889360759,261.42821803185058,202.3940291590751,139.28733261334054,71.896546165890058,3.2969182939268649E-12,3.4452796171535737E-12,3.6003171999254844E-12,3.7623314739221314E-12,3.931636390248627E-12,4.1085600278098154E-12,4.293445229061257E-12,4.4866502643690132E-12,4.6885495262656186E-12,4.8995342549475715E-12]
[null,null,"Add: Debt Draws",null,"Euro",{"$f":"F37","v":870.86647705304927},null,null,{"$f":"$F$40*I5","v":870.86647705304927},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,"Less: Debt Repayment =DS - Int",null,"Euro",null,null,null,{"$f":"I36-I43","v":0},{"$f":"J36-J43","v":3.9648546864589278},5.0063500704265209,6.1119742851341528,7.2849583587344284,8.5286856202621024,9.8466986912662051,11.242706794827328,12.720593396297801,14.284424190748503,15.938455452781831,17.687142765075656,19.535150142761069,21.487359571507469,23.54888097799391,25.725062652287608,28.021502142530196,30.444057643251504,32.998859899591423,35.692324650714482,38.531165636750927,41.522408194694094,44.673403469830518,47.991843270475542,51.485775595039684,55.163620861757025,59.034188872775481,63.106696545734565,67.390786447450481,71.896546165886761,-1.4836132322670891E-13,-1.550375827719108E-13,-1.6201427399664678E-13,-1.6930491632649592E-13,-1.7692363756118821E-13,-1.8488520125144168E-13,-1.9320503530775656E-13,-2.0189926189660558E-13,-2.1098472868195284E-13,-2.204790414726407E-13]
[null,null,"Closing Balance",null,"Euro",null,null,null,{"$f":"I39+I40-I41","v":870.86647705304927},{"$f":"J39+J40-J41","v":866.90162236659035},861.89527229616385,855.78329801102973,848.49833965229527,839.96965403203319,830.12295534076702,818.88024854593971,806.15965514964194,791.87523095889344,775.93677550611164,758.24963274103595,738.71448259827491,717.22712302676746,693.67824204877354,667.95317939648589,639.93167725395574,609.4876196107042,576.48875971111283,540.79643506039838,502.26526942364745,460.74286122895336,416.06945775912283,368.07761448864727,316.59183889360759,261.42821803185058,202.3940291590751,139.28733261334054,71.896546165890058,3.2969182939268649E-12,3.4452796171535737E-12,3.6003171999254844E-12,3.7623314739221314E-12,3.931636390248627E-12,4.1085600278098154E-12,4.293445229061257E-12,4.4866502643690132E-12,4.6885495262656186E-12,4.8995342549475715E-12,5.1200132964202123E-12]
[null,null,"Interest  Opening Balance x Int Rate",null,"Euro",{"$f":"F31","v":4.4999999999999998E-2},null,null,{"$f":"I39*$F$43","v":0},{"$f":"J39*$F$43","v":39.188991467387218},39.010573006496564,38.785287253327375,38.510248410496338,38.182425284353286,37.798634431441492,37.355532990334517,36.849611184567287,36.277184481733883,35.634385393150204,34.917154897775021,34.121233473346614,33.242151716922372,32.275220536204536,31.215520892194807,30.057893072841864,28.796925476428008,27.426942882481686,25.941994187000077,24.335839577717927,22.601937124064136,20.733428755302899,18.723125599160525,16.563492651989126,14.24663275021234,11.764269811433275,9.1077313121583785,6.2679299676003239,3.2353445774650527,1.4836132322670891E-13,1.550375827719108E-13,1.6201427399664678E-13,1.6930491632649592E-13,1.7692363756118821E-13,1.8488520125144168E-13,1.9320503530775656E-13,2.0189926189660558E-13,2.1098472868195284E-13,2.204790414726407E-13]
[]
[null,"Cash Flow Statements"]
[null,null,"Cash Before COD - Uses and Source"]
[null,null,null,"Uses"]
[null,null,null,"Cap Exp","Euro",null,null,null,{"$f":"I13","v":1000},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,"Source"]
[null,null,null,"Debt","Euro",null,{"$f":"I51/I48","v":0.87086647705304931},null,{"$f":"I40","v":870.86647705304927},{"$f":"J40","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]
[null,null,null,"Equity Investment","Euro",null,null,null,{"$f":"I48-I51","v":129.13352294695073},{"$f":"J48-J51","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]
[null,null,null,"Total",null,null,null,null,{"$f":"SUM(I51:I52)","v":1000},{"$f":"SUM(J51:J52)","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]
[]
[null,null,"Cash Flow After"]
[null,null,null,"EBITDA ","Euro",null,null,null,{"$f":"I15","v":0},56.099999999999994,57.222000000000008,58.36643999999999,59.533768799999997,60.724444176000006,61.938933059520011,63.177711720710398,64.441265955124621,65.730091274227107,67.044693099711651,68.385586961705883,69.753298700939993,71.148364674958799,72.571331968457983,74.022758607827143,75.503213779983682,77.01327805558337,78.553543616695038,80.124614489028929,81.727106778809514,83.361648914385711,85.028881892673439,86.729459530526896,88.464048721137445,90.233329695560187,92.03799628947138,93.878756215260822,95.756331339566046,97.671457966357366,99.624887125684509,0,0,0,0,0,0,0,0,0]
[null,null,null,"Less: Interest","Euro",null,null,null,{"$f":"I43","v":0},{"$f":"J43","v":39.188991467387218},39.010573006496564,38.785287253327375,38.510248410496338,38.182425284353286,37.798634431441492,37.355532990334517,36.849611184567287,36.277184481733883,35.634385393150204,34.917154897775021,34.121233473346614,33.242151716922372,32.275220536204536,31.215520892194807,30.057893072841864,28.796925476428008,27.426942882481686,25.941994187000077,24.335839577717927,22.601937124064136,20.733428755302899,18.723125599160525,16.563492651989126,14.24663275021234,11.764269811433275,9.1077313121583785,6.2679299676003239,3.2353445774650527,1.4836132322670891E-13,1.550375827719108E-13,1.6201427399664678E-13,1.6930491632649592E-13,1.7692363756118821E-13,1.8488520125144168E-13,1.9320503530775656E-13,2.0189926189660558E-13,2.1098472868195284E-13,2.204790414726407E-13]
[null,null,null,"Less: Repayment","Euro",null,null,null,{"$f":"I41","v":0},{"$f":"J41","v":3.9648546864589278},5.0063500704265209,6.1119742851341528,7.2849583587344284,8.5286856202621024,9.8466986912662051,11.242706794827328,12.720593396297801,14.284424190748503,15.938455452781831,17.687142765075656,19.535150142761069,21.487359571507469,23.54888097799391,25.725062652287608,28.021502142530196,30.444057643251504,32.998859899591423,35.692324650714482,38.531165636750927,41.522408194694094,44.673403469830518,47.991843270475542,51.485775595039684,55.163620861757025,59.034188872775481,63.106696545734565,67.390786447450481,71.896546165886761,-1.4836132322670891E-13,-1.550375827719108E-13,-1.6201427399664678E-13,-1.6930491632649592E-13,-1.7692363756118821E-13,-1.8488520125144168E-13,-1.9320503530775656E-13,-2.0189926189660558E-13,-2.1098472868195284E-13,-2.204790414726407E-13]
[null,null,null,"Dividends","Euro",null,null,null,{"$f":"I56-I57-I58","v":0},{"$f":"J56-J57-J58","v":12.946153846153848},13.205076923076923,13.469178461538462,13.738562030769231,14.013333271384617,14.293599936812313,14.579471935548554,14.871061374259533,15.168482601744721,15.471852253779616,15.781289298855206,16.096915084832311,16.418853386528959,16.747230454259537,17.082175063344732,17.423818564611622,17.772294935903858,18.127740834621932,18.490295651314369,18.86010156434066,19.23730359562748,19.622049667540026,20.014490660890829,20.414780474108639,20.82307608359082,21.239537605262619,21.664328357367879,22.097614924515241,22.539567223005548,99.624887125684509,0,0,0,0,0,0,0,0,0]
[]
[null,"Summary Analysis - Structuring"]
[]
[null,null,null,"Equity Net Cash Flow","Euro",null,null,null,{"$f":"-I52+I59","v":-129.13352294695073},12.946153846153848,13.205076923076923,13.469178461538462,13.738562030769231,14.013333271384617,14.293599936812313,14.579471935548554,14.871061374259533,15.168482601744721,15.471852253779616,15.781289298855206,16.096915084832311,16.418853386528959,16.747230454259537,17.082175063344732,17.423818564611622,17.772294935903858,18.127740834621932,18.490295651314369,18.86010156434066,19.23730359562748,19.622049667540026,20.014490660890829,20.414780474108639,20.82307608359082,21.239537605262619,21.664328357367879,22.097614924515241,22.539567223005548,99.624887125684509,0,0,0,0,0,0,0,0,0]
[null,null,null,"Equity IRR",{"$f":"IRR(I63:AV63)","v":0.11555769517426473}]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(I6,I4,NA())","v":{"$error":"#N/A"}},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,{"$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"}]
[null,null,null,"Cash Flow","Euro",null,null,null,{"$f":"I56","v":0},56.099999999999994,57.222000000000008,58.36643999999999,59.533768799999997,60.724444176000006,61.938933059520011,63.177711720710398,64.441265955124621,65.730091274227107,67.044693099711651,68.385586961705883,69.753298700939993,71.148364674958799,72.571331968457983,74.022758607827143,75.503213779983682,77.01327805558337,78.553543616695038,80.124614489028929,81.727106778809514,83.361648914385711,85.028881892673439,86.729459530526896,88.464048721137445,90.233329695560187,92.03799628947138,93.878756215260822,95.756331339566046,97.671457966357366,99.624887125684509,0,0,0,0,0,0,0,0,0]
[null,null,null,"Debt Service","Euro",null,null,null,{"$f":"I57+I58","v":0},43.153846153846146,44.016923076923085,44.897261538461528,45.795206769230766,46.711110904615389,47.645333122707697,48.598239785161844,49.570204580865088,50.561608672482386,51.572840845932035,52.604297662850676,53.656383616107682,54.72951128842984,55.824101514198446,56.940583544482415,58.07939521537206,59.240983119679512,60.425802782073106,61.634318837714559,62.867005214468854,64.12434531875823,65.406832225133414,66.714968869636067,68.049268247028806,69.410253611969367,70.798458684208754,72.214427857892943,73.658716415050804,75.131890743351818,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Equity IRR",{"$f":"E64","v":0.11555769517426473},"DSCR",{"$f":"F36","v":1.3},null,"Tenure",{"$f":"F34","v":30},"Debt to Capital"]
[]
[null,null,null,"DSCR",null,null,null,null,{"$f":"IF(I68>0,I67/I68)","v":false},{"$f":"IF(J68>0,J67/J68)","v":1.3},1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3000000000000003,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,false,false,false,false,false,false,false,false,false,false]
[]
[null,"Risk Analysis"]
[null,null,"Scheduled Debt Repayment",null,null,null,null,{"$f":"SUM(I75:XFD75)","v":870.8664770530446},{"$f":"I41","v":0},3.9648546864589278,5.0063500704265209,6.1119742851341528,7.2849583587344284,8.5286856202621024,9.8466986912662051,11.242706794827328,12.720593396297801,14.284424190748503,15.938455452781831,17.687142765075656,19.535150142761069,21.487359571507469,23.54888097799391,25.725062652287608,28.021502142530196,30.444057643251504,32.998859899591423,35.692324650714482,38.531165636750927,41.522408194694094,44.673403469830518,47.991843270475542,51.485775595039684,55.163620861757025,59.034188872775481,63.106696545734565,67.390786447450481,71.896546165886761,-1.4836132322670891E-13,-1.550375827719108E-13,-1.6201427399664678E-13,-1.6930491632649592E-13,-1.7692363756118821E-13,-1.8488520125144168E-13,-1.9320503530775656E-13,-2.0189926189660558E-13,-2.1098472868195284E-13,-2.204790414726407E-13]
[]
[null,null,"Operating Period"]
[null,null,"Target Tail",null,"Years",null,4]
[null,null,"Target Repayment",null,null,null,{"$f":"F6-G78","v":26}]
[null,null,"Closing Balance at Target Date",null,null,null,{"$f":"LOOKUP(G79,4:4,107:107)","v":0},"End Debt"]
[null,null,"Repayment in Final Year Scheduled",null,null,null,{"$f":"LOOKUP(G79,4:4,75:75)","v":55.163620861757025}]
[null,null,"Opening Balance in Final Year",null,null,null,{"$f":"LOOKUP(G79,4:4,103:103)","v":51.620526696722223}]
[null,null,"Difference",null,null,null,{"$f":"G81-G82","v":3.5430941650348018}]
[]
[null,null,"Initial Lower Case",null,"Euro",{"$f":"G85/100","v":1},100,null,{"$f":"I11*$F$85","v":0},66.3,67.626000000000005,68.978519999999989,70.358090399999995,71.765252208000007,73.20055725216001,74.664568397203197,76.157859765147279,77.681016960450222,79.234637299659227,80.819330045652407,82.435716646565453,84.084430979496759,85.766119599086707,87.481441991068436,89.231070830889806,91.015692247507616,92.836006092457765,94.692726214306916,96.586580738593071,98.518312353364934,100.48867860043224,102.49845217244088,104.5484212158897,106.6393896402075,108.77217743301163,110.94762098167188,113.16657340130533,115.42990486933142,117.73850296671806,0,0,0,0,0,0,0,0,0]
[null,null,"Actual Case with Higher Traffic",null,"Euro",{"$f":"G86/100","v":1.2},120,null,{"$f":"I$11*$F86","v":0},{"$f":"J$11*$F86","v":79.559999999999988},81.151200000000003,82.77422399999999,84.429708479999988,86.118302649600011,87.840668702592012,89.597482076643828,91.389431718176738,93.217220352540267,95.081564759591075,96.98319605478288,98.922859975878538,100.9013171753961,102.91934351890404,104.97773038928212,107.07728499706776,109.21883069700914,111.40320731094931,113.6312714571683,115.90389688631168,118.22197482403791,120.58641432051868,122.99814260692905,125.45810545906764,127.96726756824899,130.52661291961397,133.13714517800625,135.79988808156639,138.51588584319771,141.28620356006167,0,0,0,0,0,0,0,0,0]
[null,null,"Actual Case with Very High Traffic",null,"Euro",{"$f":"G87/100","v":1.31},131,null,{"$f":"I$11*$F87","v":0},86.852999999999994,88.590060000000008,90.361861199999993,92.169098423999998,94.012480392480015,95.892730000329621,97.810584600336199,99.766796292342946,101.76213221818979,103.7973748625536,105.87332235980466,107.99078880700075,110.15060458314076,112.35361667480359,114.60068900829965,116.89270278846566,119.23055684423498,121.61516798111968,124.04747134074206,126.52842076755692,129.05898918290808,131.64016896656625,134.27297234589756,136.95843179281553,139.69760042867182,142.49155243724525,145.34138348599015,148.24821115570998,151.21317537882416,154.23743888640067,0,0,0,0,0,0,0,0,0]
[null,null,"Actual Case with Low Traffic",null,"Euro",{"$f":"G88/100","v":0.85},85,null,{"$f":"I$11*$F88","v":0},56.354999999999997,57.482100000000003,58.631741999999988,59.804376839999996,61.000464376800004,62.220473664336005,63.464883137622714,64.734180800375185,66.028864416382689,67.349441704710344,68.696430538804549,70.070359149580639,71.471766332572244,72.901201659223702,74.359225692408174,75.846410206256337,77.363338410381473,78.910605178589094,80.48881728216088,82.098593627804107,83.740565500360191,85.415376810367405,87.123684346574748,88.866158033506252,90.643481194176374,92.456350818059889,94.305477834421097,96.191587391109522,98.115419138931713,100.07772752171034,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Scenario",null,3]
[null,null,{"$f":"INDEX(C85:C88,$E$90)","v":"Actual Case with Very High Traffic"},null,null,null,null,null,{"$f":"INDEX(I85:I88,$E$90)","v":0},{"$f":"INDEX(J85:J88,$E$90)","v":86.852999999999994},{"$f":"INDEX(K85:K88,$E$90)","v":88.590060000000008},{"$f":"INDEX(L85:L88,$E$90)","v":90.361861199999993},{"$f":"INDEX(M85:M88,$E$90)","v":92.169098423999998},{"$f":"INDEX(N85:N88,$E$90)","v":94.012480392480015},{"$f":"INDEX(O85:O88,$E$90)","v":95.892730000329621},{"$f":"INDEX(P85:P88,$E$90)","v":97.810584600336199},{"$f":"INDEX(Q85:Q88,$E$90)","v":99.766796292342946},{"$f":"INDEX(R85:R88,$E$90)","v":101.76213221818979},{"$f":"INDEX(S85:S88,$E$90)","v":103.7973748625536},{"$f":"INDEX(T85:T88,$E$90)","v":105.87332235980466},{"$f":"INDEX(U85:U88,$E$90)","v":107.99078880700075},{"$f":"INDEX(V85:V88,$E$90)","v":110.15060458314076},{"$f":"INDEX(W85:W88,$E$90)","v":112.35361667480359},{"$f":"INDEX(X85:X88,$E$90)","v":114.60068900829965},{"$f":"INDEX(Y85:Y88,$E$90)","v":116.89270278846566},{"$f":"INDEX(Z85:Z88,$E$90)","v":119.23055684423498},{"$f":"INDEX(AA85:AA88,$E$90)","v":121.61516798111968},{"$f":"INDEX(AB85:AB88,$E$90)","v":124.04747134074206},{"$f":"INDEX(AC85:AC88,$E$90)","v":126.52842076755692},{"$f":"INDEX(AD85:AD88,$E$90)","v":129.05898918290808},{"$f":"INDEX(AE85:AE88,$E$90)","v":131.64016896656625},{"$f":"INDEX(AF85:AF88,$E$90)","v":134.27297234589756},{"$f":"INDEX(AG85:AG88,$E$90)","v":136.95843179281553},{"$f":"INDEX(AH85:AH88,$E$90)","v":139.69760042867182},{"$f":"INDEX(AI85:AI88,$E$90)","v":142.49155243724525},{"$f":"INDEX(AJ85:AJ88,$E$90)","v":145.34138348599015},{"$f":"INDEX(AK85:AK88,$E$90)","v":148.24821115570998},{"$f":"INDEX(AL85:AL88,$E$90)","v":151.21317537882416},{"$f":"INDEX(AM85:AM88,$E$90)","v":154.23743888640067},{"$f":"INDEX(AN85:AN88,$E$90)","v":0},{"$f":"INDEX(AO85:AO88,$E$90)","v":0},{"$f":"INDEX(AP85:AP88,$E$90)","v":0},{"$f":"INDEX(AQ85:AQ88,$E$90)","v":0},{"$f":"INDEX(AR85:AR88,$E$90)","v":0},{"$f":"INDEX(AS85:AS88,$E$90)","v":0},{"$f":"INDEX(AT85:AT88,$E$90)","v":0},{"$f":"INDEX(AU85:AU88,$E$90)","v":0},{"$f":"INDEX(AV85:AV88,$E$90)","v":0}]
[]
[null,null,"Initial Sweep Percent",null,null,1,null,null,{"$f":"$F$93","v":1},{"$f":"$F$93","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"Years of Sweep",null,null,8,"sweep yr",null,{"$f":"I4<$F$94","v":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,false,false,false]
[null,null,"Final Sweep Period",null,null,{"$f":"F94","v":8},null,null,{"$f":"I4=$F$95","v":false},false,false,false,false,false,false,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,false,false]
[null,null,"Sweep in Final Year",null,null,0.6,"swep_applied",null,{"$f":"$F$96*I95","v":0},{"$f":"$F$96*J95","v":0},0,0,0,0,0,0.6,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,"Sweep Applied",null,null,null,null,null,{"$f":"I93*I94+I95*I96","v":1},{"$f":"J93*J94+J95*J96","v":1},1,1,1,1,1,0.6,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,"Adjusted Debt Schedule"]
[null,null,"Base Debt"]
[null,null,null,"Opening Debt","Euro",null,null,null,{"$f":"H107","v":0},{"$f":"I107","v":870.86647705304927},833.40246852043651,792.71951960385616,748.64211678602976,700.98623521740103,649.55894344170406,594.15799008889121,553.90893634905433,541.18834295275656,526.90391876200806,510.96546330922621,493.27832054415057,473.74317040138953,452.25581082988208,428.70692985188816,402.98186719960057,374.96036505707036,344.51630741381888,311.51744751422746,275.825122863513,237.29395722676207,195.77154903206798,151.09814556223745,103.10630229176191,51.620526696722223,0,0,0,0,0,1.4836132322670891E-13,3.0339890599861972E-13,4.6541317999526652E-13,6.3471809632176244E-13,8.1164173388295068E-13,9.9652693513439234E-13,1.1897319704421489E-12,1.3916312323387546E-12,1.6026159610207074E-12]
[null,null,null,"Add: Debt Issue","Euro",null,null,null,{"$f":"I40","v":870.86647705304927},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: Scheduled","Euro",null,null,null,{"$f":"MIN(I58,I103)","v":0},3.9648546864589278,5.0063500704265209,6.1119742851341528,7.2849583587344284,8.5286856202621024,9.8466986912662051,11.242706794827328,12.720593396297801,14.284424190748503,15.938455452781831,17.687142765075656,19.535150142761069,21.487359571507469,23.54888097799391,25.725062652287608,28.021502142530196,30.444057643251504,32.998859899591423,35.692324650714482,38.531165636750927,41.522408194694094,44.673403469830518,47.991843270475542,51.485775595039684,51.620526696722223,0,0,0,0,-1.4836132322670891E-13,-1.550375827719108E-13,-1.6201427399664678E-13,-1.6930491632649592E-13,-1.7692363756118821E-13,-1.8488520125144168E-13,-1.9320503530775656E-13,-2.0189926189660558E-13,-2.1098472868195284E-13,-2.204790414726407E-13]
[null,null,null,"Less: Cash Sweep","Euro",null,null,null,{"$f":"I130","v":0},{"$f":"J130","v":33.499153846153845},35.676598846153851,37.965428532692322,40.370923209894229,42.898606155434869,45.554254661546736,29.006346945009579,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,"Closing Balance","Euro",null,null,null,{"$f":"I103+I104-I105-I106","v":870.86647705304927},{"$f":"J103+J104-J105-J106","v":833.40246852043651},792.71951960385616,748.64211678602976,700.98623521740103,649.55894344170406,594.15799008889121,553.90893634905433,541.18834295275656,526.90391876200806,510.96546330922621,493.27832054415057,473.74317040138953,452.25581082988208,428.70692985188816,402.98186719960057,374.96036505707036,344.51630741381888,311.51744751422746,275.825122863513,237.29395722676207,195.77154903206798,151.09814556223745,103.10630229176191,51.620526696722223,0,0,0,0,0,1.4836132322670891E-13,3.0339890599861972E-13,4.6541317999526652E-13,6.3471809632176244E-13,8.1164173388295068E-13,9.9652693513439234E-13,1.1897319704421489E-12,1.3916312323387546E-12,1.6026159610207074E-12,1.8230950024933483E-12]
[null,null,null,"Interest ","Euro",{"$f":"$F$43","v":4.4999999999999998E-2},null,null,{"$f":"I103*$F$108","v":0},{"$f":"J103*$F$108","v":39.188991467387218},37.50311108341964,35.672378382173527,33.688895255371335,31.544380584783045,29.230152454876681,26.737109554000103,24.925902135707442,24.353475432874045,23.710676344290363,22.993445848915179,22.197524424486776,21.318442668062527,20.351511487344691,19.291811843334965,18.134184023982026,16.873216427568167,15.503233833621849,14.018285138140236,12.412130528858084,10.678228075204293,8.8097197064430581,6.7994165503006849,4.6397836031292856,2.3229237013524999,0,0,0,0,0,6.6762595452019005E-15,1.3652950769937886E-14,2.0943593099786992E-14,2.8562314334479308E-14,3.6523878024732778E-14,4.4843712081047653E-14,5.3537938669896702E-14,6.2623405455243956E-14,7.2117718245931837E-14]
[]
[null,null,"Defaulted Debt"]
[null,null,null,"Opening Balance","Euro",null,null,null,{"$f":"H114","v":0},{"$f":"I114","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]
[null,null,null,"Add: Default","Euro"]
[null,null,null,"Less: Repayment of Default","Euro"]
[null,null,null,"Closing Balance","Euro",null,null,null,{"$f":"I111+I112-I113","v":0},{"$f":"J111+J112-J113","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]
[null,null,null,"Interest","Euro",{"$f":"$F$43","v":4.4999999999999998E-2},null,null,{"$f":"I111*$F$115","v":0},{"$f":"J111*$F$115","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]
[]
[null,null,null,"Total Interest","Euro",null,null,null,{"$f":"I115+I108","v":0},{"$f":"J115+J108","v":39.188991467387218},37.50311108341964,35.672378382173527,33.688895255371335,31.544380584783045,29.230152454876681,26.737109554000103,24.925902135707442,24.353475432874045,23.710676344290363,22.993445848915179,22.197524424486776,21.318442668062527,20.351511487344691,19.291811843334965,18.134184023982026,16.873216427568167,15.503233833621849,14.018285138140236,12.412130528858084,10.678228075204293,8.8097197064430581,6.7994165503006849,4.6397836031292856,2.3229237013524999,0,0,0,0,0,6.6762595452019005E-15,1.3652950769937886E-14,2.0943593099786992E-14,2.8562314334479308E-14,3.6523878024732778E-14,4.4843712081047653E-14,5.3537938669896702E-14,6.2623405455243956E-14,7.2117718245931837E-14]
[]
[null,"Adjusted Cash Waterfall"]
[null,null,"Adjusted Revenues",null,"Euro",null,null,null,{"$f":"I91","v":0},{"$f":"J91","v":86.852999999999994},88.590060000000008,90.361861199999993,92.169098423999998,94.012480392480015,95.892730000329621,97.810584600336199,99.766796292342946,101.76213221818979,103.7973748625536,105.87332235980466,107.99078880700075,110.15060458314076,112.35361667480359,114.60068900829965,116.89270278846566,119.23055684423498,121.61516798111968,124.04747134074206,126.52842076755692,129.05898918290808,131.64016896656625,134.27297234589756,136.95843179281553,139.69760042867182,142.49155243724525,145.34138348599015,148.24821115570998,151.21317537882416,154.23743888640067,0,0,0,0,0,0,0,0,0]
[null,null,"Less Operating Expense",null,"Euro",null,null,null,{"$f":"I12","v":0},10.199999999999999,10.404,10.612079999999999,10.824321599999999,11.040808032000001,11.261624192640001,11.486856676492801,11.716593810022658,11.95092568622311,12.189944199947574,12.433743083946524,12.682417945625454,12.936066304537963,13.194787630628724,13.458683383241299,13.727857050906124,14.002414191924249,14.282462475762735,14.568111725277987,14.85947395978355,15.156663438979221,15.459796707758805,15.768992641913982,16.084372494752262,16.406059944647307,16.734181143540251,17.068864766411057,17.410242061739282,17.758446902974065,18.11361584103355,0,0,0,0,0,0,0,0,0]
[null,null,"EBITDA",null,null,null,null,null,{"$f":"I120-I121","v":0},{"$f":"J120-J121","v":76.652999999999992},78.186060000000012,79.749781200000001,81.344776823999993,82.971672360480014,84.631105807689622,86.323727923843393,88.050202482320287,89.811206531966675,91.607430662606021,93.439579275858136,95.308370861375295,97.214538278602802,99.158829044174865,101.14200562505836,103.16484573755953,105.22814265231074,107.33270550535696,109.47935961546408,111.66894680777338,113.90232574392886,116.18037225880744,118.50397970398357,120.87405929806327,123.29154048402451,125.75737129370499,128.2725187195791,130.83796909397068,133.45472847585009,136.12382304536712,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Less: Interest",null,"Euro",null,null,null,{"$f":"I117","v":0},{"$f":"J117","v":39.188991467387218},37.50311108341964,35.672378382173527,33.688895255371335,31.544380584783045,29.230152454876681,26.737109554000103,24.925902135707442,24.353475432874045,23.710676344290363,22.993445848915179,22.197524424486776,21.318442668062527,20.351511487344691,19.291811843334965,18.134184023982026,16.873216427568167,15.503233833621849,14.018285138140236,12.412130528858084,10.678228075204293,8.8097197064430581,6.7994165503006849,4.6397836031292856,2.3229237013524999,0,0,0,0,0,6.6762595452019005E-15,1.3652950769937886E-14,2.0943593099786992E-14,2.8562314334479308E-14,3.6523878024732778E-14,4.4843712081047653E-14,5.3537938669896702E-14,6.2623405455243956E-14,7.2117718245931837E-14]
[null,null,"Less: Debt Repayment Scheduled",null,"Euro",null,null,null,{"$f":"I105","v":0},{"$f":"J105","v":3.9648546864589278},5.0063500704265209,6.1119742851341528,7.2849583587344284,8.5286856202621024,9.8466986912662051,11.242706794827328,12.720593396297801,14.284424190748503,15.938455452781831,17.687142765075656,19.535150142761069,21.487359571507469,23.54888097799391,25.725062652287608,28.021502142530196,30.444057643251504,32.998859899591423,35.692324650714482,38.531165636750927,41.522408194694094,44.673403469830518,47.991843270475542,51.485775595039684,51.620526696722223,0,0,0,0,-1.4836132322670891E-13,-1.550375827719108E-13,-1.6201427399664678E-13,-1.6930491632649592E-13,-1.7692363756118821E-13,-1.8488520125144168E-13,-1.9320503530775656E-13,-2.0189926189660558E-13,-2.1098472868195284E-13,-2.204790414726407E-13]
[null,null,"Cash Flow After Scheduled Debt Service",null,"Euro",null,null,null,{"$f":"I122-I124-I125","v":0},{"$f":"J122-J124-J125","v":33.499153846153845},35.676598846153851,37.965428532692322,40.370923209894229,42.898606155434869,45.554254661546736,48.343911575015966,50.403706950315041,51.173306908344124,51.958298865533827,52.758990661867308,53.575696294127454,54.408736039032803,55.25843657883626,56.125131129435786,57.009159571047306,57.910868581491066,58.830611772143683,59.768749826609366,60.725650642164368,61.701689474030474,62.697249082533858,63.712719883207342,64.748500099894301,69.348090085949792,125.75737129370499,128.2725187195791,130.83796909397068,133.45472847585009,136.12382304536726,1.4836132322670891E-13,1.4836132322670889E-13,1.4836132322670894E-13,1.4836132322670891E-13,1.4836132322670891E-13,1.4836132322670891E-13,1.4836132322670889E-13,1.4836132322670889E-13,1.4836132322670886E-13]
[]
[null,null,"Cash Sweep",null,"%",null,0,null,{"$f":"I97","v":1},{"$f":"J97","v":1},1,1,1,1,1,0.6,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,"Cash Swept Before Constraint",null,"Euro",null,null,null,{"$f":"MAX(I126,0)*I128","v":0},{"$f":"MAX(J126,0)*J128","v":33.499153846153845},35.676598846153851,37.965428532692322,40.370923209894229,42.898606155434869,45.554254661546736,29.006346945009579,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,"Cash Swept After Constraint",null,null,null,null,null,{"$f":"MIN(I129,I103-I105)","v":0},{"$f":"MIN(J129,J103-J105)","v":33.499153846153845},35.676598846153851,37.965428532692322,40.370923209894229,42.898606155434869,45.554254661546736,29.006346945009579,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,"Cash Flow Before Default",null,"Euro",null,null,null,{"$f":"I126-I130","v":0},{"$f":"J126-J130","v":0},0,0,0,0,0,19.337564630006387,50.403706950315041,51.173306908344124,51.958298865533827,52.758990661867308,53.575696294127454,54.408736039032803,55.25843657883626,56.125131129435786,57.009159571047306,57.910868581491066,58.830611772143683,59.768749826609366,60.725650642164368,61.701689474030474,62.697249082533858,63.712719883207342,64.748500099894301,69.348090085949792,125.75737129370499,128.2725187195791,130.83796909397068,133.45472847585009,136.12382304536726,1.4836132322670891E-13,1.4836132322670889E-13,1.4836132322670894E-13,1.4836132322670891E-13,1.4836132322670891E-13,1.4836132322670891E-13,1.4836132322670889E-13,1.4836132322670889E-13,1.4836132322670886E-13]
[null,null,"Add: Repayment not Made from Default",null,"Euro",null,null,null,{"$f":"MAX(-I132,0)","v":0},{"$f":"MAX(-J132,0)","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]
[null,null,"Less: Repayment of Default",null,"Euro",null,null,null,{"$f":"MIN(MAX(I126,0),I111)","v":0},{"$f":"MIN(MAX(J126,0),J111)","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]
[]
[null,null,"Cash Flow After Sweep",null,"Euro",null,null,null,{"$f":"I132+I133-I134","v":0},{"$f":"J132+J133-J134","v":0},0,0,0,0,0,19.337564630006387,50.403706950315041,51.173306908344124,51.958298865533827,52.758990661867308,53.575696294127454,54.408736039032803,55.25843657883626,56.125131129435786,57.009159571047306,57.910868581491066,58.830611772143683,59.768749826609366,60.725650642164368,61.701689474030474,62.697249082533858,63.712719883207342,64.748500099894301,69.348090085949792,125.75737129370499,128.2725187195791,130.83796909397068,133.45472847585009,136.12382304536726,1.4836132322670891E-13,1.4836132322670889E-13,1.4836132322670894E-13,1.4836132322670891E-13,1.4836132322670891E-13,1.4836132322670891E-13,1.4836132322670889E-13,1.4836132322670889E-13,1.4836132322670886E-13]
[]
[null,null,"Dividends",null,null,null,null,null,{"$f":"I136","v":0},{"$f":"J136","v":0},0,0,0,0,0,19.337564630006387,50.403706950315041,51.173306908344124,51.958298865533827,52.758990661867308,53.575696294127454,54.408736039032803,55.25843657883626,56.125131129435786,57.009159571047306,57.910868581491066,58.830611772143683,59.768749826609366,60.725650642164368,61.701689474030474,62.697249082533858,63.712719883207342,64.748500099894301,69.348090085949792,125.75737129370499,128.2725187195791,130.83796909397068,133.45472847585009,136.12382304536726,1.4836132322670891E-13,1.4836132322670889E-13,1.4836132322670894E-13,1.4836132322670891E-13,1.4836132322670891E-13,1.4836132322670891E-13,1.4836132322670889E-13,1.4836132322670889E-13,1.4836132322670886E-13]
[]
[null,"Ratios"]
[null,null,"Equity Cash Flow",null,null,null,null,null,{"$f":"I138-I52","v":-129.13352294695073},0,0,0,0,0,0,19.337564630006387,50.403706950315041,51.173306908344124,51.958298865533827,52.758990661867308,53.575696294127454,54.408736039032803,55.25843657883626,56.125131129435786,57.009159571047306,57.910868581491066,58.830611772143683,59.768749826609366,60.725650642164368,61.701689474030474,62.697249082533858,63.712719883207342,64.748500099894301,69.348090085949792,125.75737129370499,128.2725187195791,130.83796909397068,133.45472847585009,136.12382304536726,1.4836132322670891E-13,1.4836132322670889E-13,1.4836132322670894E-13,1.4836132322670891E-13,1.4836132322670891E-13,1.4836132322670891E-13,1.4836132322670889E-13,1.4836132322670889E-13,1.4836132322670886E-13]
[null,null,"Equity IRR",null,null,{"$f":"IRR(I141:AV141)","v":0.16026338718301636}]
[]
[null,null,"DSCR",null,null,null,null,null,{"$f":"IFERROR(I122/(I124+I125),FALSE)","v":false},{"$f":"IFERROR(J122/(J124+J125),FALSE)","v":1.7762727272727274},1.8392625518596091,1.9086039655796005,1.9852849963811077,2.0705097018514143,2.1657606313051967,2.2728842901976938,2.3388684985954198,2.3244329377846835,2.310452373370016,2.2969082419747111,2.2837829554344959,2.2710598375081257,2.2587230654592751,2.2467576160777973,2.2351492157516599,2.2238842942392663,2.212949941826071,2.202333869579884,2.1920243724464625,2.1820102949513447,2.1722809992956411,2.1628263356530488,2.1536366144928607,2.2855701586419999,false,false,false,false,-917515563253356.5,0,0,0,0,0,0,0,0,0]
[]
[null,null,"CFADS for Loan Life",null,null,null,null,null,{"$f":"IF(I34,I122)","v":false},76.652999999999992,78.186060000000012,79.749781200000001,81.344776823999993,82.971672360480014,84.631105807689622,86.323727923843393,88.050202482320287,89.811206531966675,91.607430662606021,93.439579275858136,95.308370861375295,97.214538278602802,99.158829044174865,101.14200562505836,103.16484573755953,105.22814265231074,107.33270550535696,109.47935961546408,111.66894680777338,113.90232574392886,116.18037225880744,118.50397970398357,120.87405929806327,123.29154048402451,125.75737129370499,128.2725187195791,130.83796909397068,133.45472847585009,false,false,false,false,false,false,false,false,false,false]
[null,null,"NPV of CFADS",null,null,{"$f":"F115","v":4.4999999999999998E-2},{"$f":"NPV(F147,I146:AV146)","v":1546.8963722854116}]
[null,null,"Debt Balance",null,null,null,{"$f":"F40","v":870.86647705304927}]
[null,null,"LLCR",null,null,null,{"$f":"G147/G148","v":1.776272727272727}]
[]
[null,null,"CFADS for Life",null,null,{"$f":"F147","v":4.4999999999999998E-2},{"$f":"NPV(F151,I151:AV151)","v":1583.2414351493971},null,{"$f":"IF(I6,I122)","v":false},76.652999999999992,78.186060000000012,79.749781200000001,81.344776823999993,82.971672360480014,84.631105807689622,86.323727923843393,88.050202482320287,89.811206531966675,91.607430662606021,93.439579275858136,95.308370861375295,97.214538278602802,99.158829044174865,101.14200562505836,103.16484573755953,105.22814265231074,107.33270550535696,109.47935961546408,111.66894680777338,113.90232574392886,116.18037225880744,118.50397970398357,120.87405929806327,123.29154048402451,125.75737129370499,128.2725187195791,130.83796909397068,133.45472847585009,136.12382304536712,false,false,false,false,false,false,false,false,false]
[null,null,"Debt Balance",null,null,null,{"$f":"G148","v":870.86647705304927}]
[null,null,"PLCR",null,null,null,{"$f":"G151/G152","v":1.8180070962278563}]
[]
[null,"Graphs"]
[null,null,null,null,null,null,null,null,{"$f":"I66","v":{"$error":"#N/A"}},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,{"$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"}]
[null,null,null,"Scheduled Debt Service",null,null,null,null,{"$f":"I124+I125","v":0},{"$f":"J124+J125","v":43.153846153846146},42.509461153846161,41.784352667307679,40.973853614105764,40.073066205045151,39.076851146142886,37.979816348827427,37.646495532005247,38.637899623622545,39.649131797072194,40.680588613990835,41.732674567247841,42.805802239569999,43.900392465338598,45.016874495622574,46.155686166512226,47.317274070819671,48.502093733213272,49.710609788854718,50.943296165609013,52.200636269898389,53.48312317627358,54.791259820776226,56.125559198168972,53.943450398074724,0,0,0,0,-1.4836132322670891E-13,-1.4836132322670891E-13,-1.4836132322670889E-13,-1.4836132322670894E-13,-1.4836132322670891E-13,-1.4836132322670891E-13,-1.4836132322670891E-13,-1.4836132322670889E-13,-1.4836132322670889E-13,-1.4836132322670886E-13]
[null,null,null,"Sweep",null,null,null,null,{"$f":"I130","v":0},{"$f":"J130","v":33.499153846153845},35.676598846153851,37.965428532692322,40.370923209894229,42.898606155434869,45.554254661546736,29.006346945009579,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,"Repayment of Default",null,null,null,null,{"$f":"I134","v":0},{"$f":"J134","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]
[null,null,null,"Default",null,null,null,null,{"$f":"-I133","v":0},{"$f":"-J133","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]
[null,null,null,"Dividend",null,null,null,null,{"$f":"I138","v":0},{"$f":"J138","v":0},0,0,0,0,0,19.337564630006387,50.403706950315041,51.173306908344124,51.958298865533827,52.758990661867308,53.575696294127454,54.408736039032803,55.25843657883626,56.125131129435786,57.009159571047306,57.910868581491066,58.830611772143683,59.768749826609366,60.725650642164368,61.701689474030474,62.697249082533858,63.712719883207342,64.748500099894301,69.348090085949792,125.75737129370499,128.2725187195791,130.83796909397068,133.45472847585009,136.12382304536726,1.4836132322670891E-13,1.4836132322670889E-13,1.4836132322670894E-13,1.4836132322670891E-13,1.4836132322670891E-13,1.4836132322670891E-13,1.4836132322670889E-13,1.4836132322670889E-13,1.4836132322670886E-13]
[]
[null,null,null,"Equity IRR with Sweep",null,{"$f":"F142","v":0.16026338718301636},"Equity IRR Before",{"$f":"E70","v":0.11555769517426473},"Year of Sweep End",{"$f":"F94","v":8},{"$f":"F85","v":1},"Cash Sweep Percent",null,{"$f":"F128","v":0},"Unpaid Debt at Project Life",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Unpaid Debt at Loan Life"]

{"sheet":"Sub Debt","index":3,"n_rows":211,"n_cols":128,"rows_kept":211,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Timing "]
[null,null,"Period",null,null,null,null,null,{"$f":"_xlfn.SEQUENCE(,120)","v":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,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120]
[null,null,"Construction Periods",null,"Years",1,null,null,{"$f":"I3<=$F$4","v":true},{"$f":"J3<=$F$4","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,false,false,false,false,{"$f":"BV3<=$F$4","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]
[null,null,"Operating Life",null,"Life",30,{"$f":"F5+F4","v":31},null,{"$f":"AND(NOT(I4),I3<=$G$5)","v":false},{"$f":"AND(NOT(J4),J3<=$G$5)","v":true},{"$f":"AND(NOT(K4),K3<=$G$5)","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,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,{"$f":"AND(NOT(BW4),BW3<=$G$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]
[]
[null,"Operating Cash Flow"]
[null,null,"Inflation Index",null,"%",0.02,1,null,{"$f":"G8*(1+$F$8*I5)","v":1},{"$f":"I8*(1+$F$8*J5)","v":1.02},1.0404,1.0612079999999999,1.08243216,1.1040808032,1.1261624192640001,1.14868566764928,1.1716593810022657,1.1950925686223111,1.2189944199947573,1.2433743083946525,1.2682417945625455,1.2936066304537963,1.3194787630628724,1.3458683383241299,1.3727857050906125,1.4002414191924248,1.4282462475762734,1.4568111725277988,1.4859473959783549,1.5156663438979221,1.5459796707758806,1.5768992641913981,1.6084372494752261,1.6406059944647307,1.6734181143540252,1.7068864766411058,1.7410242061739281,1.7758446902974065,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,{"$f":"BU8*(1+$F$8*BV5)","v":1.8113615841033548},1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548,1.8113615841033548]
[]
[null,null,"Revenues (Minimum Traffic Case)",null,"Annual Euro",60,null,{"$f":"SUM(I10:XFD10)","v":2482.7664473562631},{"$f":"$F$10*I8*I5","v":0},{"$f":"$F$10*J8*J5","v":61.2},62.423999999999999,63.672479999999993,64.945929599999999,66.244848192000006,67.56974515584001,68.921140058956809,70.29956286013595,71.705554117338664,73.139665199685439,74.602458503679145,76.09450767375273,77.616397827227786,79.168725783772345,80.75210029944779,82.367142305436744,84.014485151545486,85.694774854576409,87.408670351667922,89.156843758701299,90.939980633875322,92.758780246552831,94.613955851483894,96.506234968513567,98.436359667883835,100.40508686124151,102.41318859846635,104.46145237043568,106.55068141784439,108.68169504620128,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,{"$f":"$F$10*BV8*BV5","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]
[null,null,"Operating Expense",null,"Annual Euro",10,null,{"$f":"SUM(I11:XFD11)","v":413.79440789271058},{"$f":"$F$11*I8*I5","v":0},{"$f":"$F$11*J8*J5","v":10.199999999999999},10.404,10.612079999999999,10.824321599999999,11.040808032000001,11.261624192640001,11.486856676492801,11.716593810022658,11.95092568622311,12.189944199947574,12.433743083946524,12.682417945625454,12.936066304537963,13.194787630628724,13.458683383241299,13.727857050906124,14.002414191924249,14.282462475762735,14.568111725277987,14.85947395978355,15.156663438979221,15.459796707758805,15.768992641913982,16.084372494752262,16.406059944647307,16.734181143540251,17.068864766411057,17.410242061739282,17.758446902974065,18.11361584103355,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,{"$f":"$F$11*BV8*BV5","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]
[null,null,"Capital Expenditure",null,"One Time",1000,{"$f":"F4","v":1},null,{"$f":"$F$12/$G$12*I4","v":1000},{"$f":"$F$12/$G$12*J4","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,0,0,0,0,{"$f":"$F$12/$G$12*BV4","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]
[]
[null,null,"EBITDA",null,"Euro",null,null,{"$f":"SUM(I14:XFD14)","v":2068.9720394635533},{"$f":"I10-I11","v":0},{"$f":"J10-J11","v":51},52.019999999999996,53.060399999999994,54.121608000000002,55.204040160000005,56.308120963200011,57.43428338246401,58.582969050113292,59.754628431115556,60.949720999737863,62.168715419732621,63.412089728127278,64.680331522689826,65.973938153143621,67.293416916206496,68.63928525453062,70.012070959621241,71.412312378813681,72.840558626389935,74.297369798917742,75.7833171948961,77.298983538794033,78.844963209569912,80.421862473761308,82.030299723236524,83.67090571770126,85.344323832055295,87.051210308696398,88.79223451487033,90.568079205167734,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,{"$f":"BV10-BV11","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]
[null,null,"Free Cash Flow",null,"Euro",null,null,{"$f":"SUM(I15:XFD15)","v":1068.9720394635528},{"$f":"I14-I12","v":-1000},{"$f":"J14-J12","v":51},52.019999999999996,53.060399999999994,54.121608000000002,55.204040160000005,56.308120963200011,57.43428338246401,58.582969050113292,59.754628431115556,60.949720999737863,62.168715419732621,63.412089728127278,64.680331522689826,65.973938153143621,67.293416916206496,68.63928525453062,70.012070959621241,71.412312378813681,72.840558626389935,74.297369798917742,75.7833171948961,77.298983538794033,78.844963209569912,80.421862473761308,82.030299723236524,83.67090571770126,85.344323832055295,87.051210308696398,88.79223451487033,90.568079205167734,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,{"$f":"BV14-BV12","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]
[null,null,"PIRR",null,"% p.a.",{"$f":"IRR(I15:DX15)","v":4.9015284845550067E-2}]
[]
[null,null,"Opening Balance",null,"Euro",null,null,null,{"$f":"H21","v":0},{"$f":"I21","v":0},51,105.51977952712305,163.75226157748463,225.90023332280808,292.17683776580174,362.80608965736457,438.02341686808444,518.07622846500806,603.22451080604424,693.74145302875797,789.91410337786101,892.04405788657141,1000.4481830013518,1115.4593738175197,1237.4273496750309,1366.7194889495572,1503.7217049640058,1648.8393650400662,1802.4982548084511,1965.1455900004119,2137.2510780521548,2319.3080319681339,2511.834539009194,2715.3746868973822,2930.4998503612901,3157.8100409842918,3397.93532346333,3651.5373015383375,3919.3106770122608,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,{"$f":"BU21","v":4201.9848854493903},4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903]
[null,null,"Add: Re-Investment",null,"Euro",{"$f":"F16","v":4.9015284845550067E-2},null,null,{"$f":"I18*$F$19*I5","v":0},{"$f":"J18*$F$19*J5","v":0},2.4997795271230534,5.1720820503615785,8.0263637453234331,11.072564282993659,14.321130928362843,17.783043828255899,21.469842546810277,25.393653909920644,29.567221222975853,34.003934929370367,38.717864780583142,43.723793592090651,49.037252663024262,54.674558941304639,60.652854019995722,66.990145054827167,73.705347697246935,80.818331141994747,88.349965393043121,96.322170856846725,104.75797037718533,113.68154383149023,123.11828541442658,133.09486374067151,143.63928490530049,154.78095864698321,166.55076776631142,178.98114095905285,192.10612923196163,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,{"$f":"BV18*$F$19*BV5","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]
[null,null,"Add: Dividends",null,"Euro",null,null,null,{"$f":"I14","v":0},{"$f":"J14","v":51},52.019999999999996,53.060399999999994,54.121608000000002,55.204040160000005,56.308120963200011,57.43428338246401,58.582969050113292,59.754628431115556,60.949720999737863,62.168715419732621,63.412089728127278,64.680331522689826,65.973938153143621,67.293416916206496,68.63928525453062,70.012070959621241,71.412312378813681,72.840558626389935,74.297369798917742,75.7833171948961,77.298983538794033,78.844963209569912,80.421862473761308,82.030299723236524,83.67090571770126,85.344323832055295,87.051210308696398,88.79223451487033,90.568079205167734,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,{"$f":"BV14","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]
[null,null,"Closing Balance",null,"Euro",null,null,null,{"$f":"SUM(I18:I20)","v":0},{"$f":"SUM(J18:J20)","v":51},105.51977952712305,163.75226157748463,225.90023332280808,292.17683776580174,362.80608965736457,438.02341686808444,518.07622846500806,603.22451080604424,693.74145302875797,789.91410337786101,892.04405788657141,1000.4481830013518,1115.4593738175197,1237.4273496750309,1366.7194889495572,1503.7217049640058,1648.8393650400662,1802.4982548084511,1965.1455900004119,2137.2510780521548,2319.3080319681339,2511.834539009194,2715.3746868973822,2930.4998503612901,3157.8100409842918,3397.93532346333,3651.5373015383375,3919.3106770122608,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,{"$f":"SUM(BV18:BV20)","v":4201.9848854493903},4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903,4201.9848854493903]
[]
[null,null,"Ending Balance",null,"Euro"]
[null,null,"Investment",null,"Euro"]
[null,null,"Growth Ratio",null,"x"]
[null,null,"Annual Growth",null,"% p.a."]
[]
[null,"Debt Structuring"]
[]
[null,null,"Senior Debt"]
[null,null,null,"Tenure of Debt","Years",22]
[null,null,null,"Interest Rate","% p.a.",4.4999999999999998E-2]
[null,null,null,"DSCR for Sizing","x",1.75]
[]
[null,null,null,"Flag for Tenure","Flag",{"$f":"F31","v":22},null,null,{"$f":"AND(NOT(I4),I3<=$F$35)","v":false},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,{"$f":"AND(NOT(AO4),AO3<=$F$35)","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,{"$f":"AND(NOT(BU4),BU3<=$F$35)","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,{"$f":"AND(NOT(DA4),DA3<=$F$35)","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]
[null,null,null,"CFADS for Tenure","Euro",null,null,null,{"$f":"IF(I35,I14)","v":false},51,52.019999999999996,53.060399999999994,54.121608000000002,55.204040160000005,56.308120963200011,57.43428338246401,58.582969050113292,59.754628431115556,60.949720999737863,62.168715419732621,63.412089728127278,64.680331522689826,65.973938153143621,67.293416916206496,68.63928525453062,70.012070959621241,71.412312378813681,72.840558626389935,74.297369798917742,75.7833171948961,false,false,false,false,false,false,false,false,false,false,{"$f":"IF(AO35,AO14)","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,{"$f":"IF(BU35,BU14)","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,{"$f":"IF(DA35,DA14)","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]
[null,null,null,"Target Debt Service =CFADS/DSCR","Euro",{"$f":"F33","v":1.75},null,null,{"$f":"IF(I35,I36/$F$37)","v":false},{"$f":"IF(J35,J36/$F$37)","v":29.142857142857142},29.725714285714282,30.320228571428569,30.926633142857145,31.545165805714287,32.176069121828576,32.81959050426515,33.475982314350453,34.145501960637461,34.828411999850211,35.52498023984721,36.235479844644161,36.960189441537047,37.699393230367782,38.453381094975143,39.222448716874638,40.006897691212139,40.807035645036386,41.623176357937105,42.455639885095856,43.304752682797769,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,{"$f":"IF(BV35,BV36/$F$37)","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]
[null,null,null,"PV of Debt =Debt","Euro",{"$f":"NPV(F32,I37:DX37)","v":464.65680743158822},{"$f":"F38/F12","v":0.46465680743158821}]
[]
[null,null,null,"Opening Balance","Euro",null,null,null,{"$f":"G43","v":0},{"$f":"I43","v":464.65680743158822},456.42350662315255,447.23685013548015,437.04227982014817,425.78254926919772,413.3975981805973,399.82442097689562,384.99692941659077,368.84580892598689,351.29836836701884,332.27838294368451,311.70592993630311,289.49721693879258,265.56440225950121,239.81540713081097,212.15371935672232,182.4781880109002,150.68280878017856,116.65649953025022,80.282865651174376,41.439954720381365,7.602807272633072E-13,7.9449335999015601E-13,8.3024556118971308E-13,8.6760661144325015E-13,9.0664890895819645E-13,9.4744810986131534E-13,9.900832748050746E-13,1.034637022171303E-12,1.0811956881690116E-12,1.1298494941366171E-12,1.1806927213727648E-12,1.2338238938345391E-12,1.2893459690570935E-12,1.3473665376646626E-12,1.4079980318595725E-12,1.4713579432932532E-12,1.5375690507414496E-12,1.6067596580248149E-12,1.6790638426359316E-12,1.7546217155545486E-12,1.8335796927545035E-12,1.9160907789284562E-12,2.0023148639802366E-12,2.0924190328593475E-12,2.1865778893380181E-12,2.2849738943582287E-12,2.3877977196043488E-12,2.4952486169865443E-12,2.6075348047509387E-12,2.7248738709647311E-12,2.8474931951581442E-12,2.9756303889402605E-12,3.1095337564425723E-12,3.249462775482488E-12,3.3956886003791998E-12,3.5484945873962637E-12,3.7081768438290956E-12,3.8750448018014051E-12,4.0494218178824684E-12,4.2316457996871792E-12,4.422069860673102E-12,4.6210630044033916E-12,4.8290108396015444E-12,{"$f":"BU43","v":5.046316327383614E-12},5.2734005621158768E-12,5.510703587411091E-12,5.7586852488445903E-12,6.0178260850425964E-12,6.2886282588695134E-12,6.5716165305186419E-12,6.8673392743919811E-12,7.1763695417396203E-12,7.4993061711179033E-12,7.8367749488182093E-12,8.1894298215150292E-12,8.5579541634832062E-12,8.9430621008399507E-12,9.3454998953777491E-12,9.7660473906697485E-12,1.0205519523249887E-11,1.0664767901796132E-11,1.1144682457376958E-11,1.1646193167958921E-11,1.2170271860517072E-11,1.271793409424034E-11,1.3290241128481155E-11,1.3888301979262807E-11,1.4513275568329633E-11,1.5166372968904466E-11,1.5848859752505166E-11,1.6562058441367898E-11,1.7307351071229455E-11,1.808618186943478E-11,1.8900060053559347E-11,1.9750562755969517E-11,2.0639338079988144E-11,2.1568108293587612E-11,2.2538673166799055E-11,2.3552913459305012E-11,2.4612794564973739E-11,2.5720370320397557E-11,2.6877786984815446E-11,2.808728739913214E-11,2.9351215332093084E-11,3.0672020022037273E-11,3.2052260923028952E-11,3.3494612664565252E-11,3.5001870234470686E-11,3.657695439502187E-11,3.8222917342797852E-11,3.9942948623223757E-11,4.1740381311268824E-11,4.3618698470275919E-11,4.5581539901438337E-11,4.7632709197003061E-11,4.9776181110868201E-11,5.2016109260857269E-11,5.4356834177595847E-11]
[null,null,null,"Add: Debt Draws","Euro",{"$f":"F38","v":464.65680743158822},null,null,{"$f":"$F$41*I4","v":464.65680743158822},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,{"$f":"$F$41*AO4","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,{"$f":"$F$41*BU4","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,{"$f":"$F$41*DA4","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]
[null,null,null,"Less: Debt Repayment =DS - Int","Euro",null,null,null,{"$f":"I37-I44","v":0},{"$f":"J37-J44","v":8.233300808435672},9.186656487672419,10.194570315331962,11.259730550950479,12.384951088600392,13.573177203701697,14.827491560304846,16.151120490603869,17.547440558968052,19.019985423334361,20.572453007381405,22.208712997510521,23.932814679291383,25.748995128690229,27.661687774088648,29.675531345822133,31.795379230721629,34.026309249928353,36.373633879075847,38.84291093079301,41.439954720380605,-3.421263272684882E-14,-3.575220119955702E-14,-3.7361050253537085E-14,-3.9042297514946254E-14,-4.0799200903118836E-14,-4.2635164943759192E-14,-4.4553747366228357E-14,-4.6558665997708636E-14,-4.8653805967605524E-14,-5.0843227236147766E-14,-5.3131172461774417E-14,-5.5522075222554257E-14,-5.8020568607569209E-14,-6.063149419490982E-14,-6.3359911433680755E-14,-6.6211107448196396E-14,-6.9190607283365228E-14,-7.2304184611116668E-14,-7.5557872918616925E-14,-7.8957977199954685E-14,-8.2511086173952652E-14,-8.6224085051780527E-14,-9.0104168879110641E-14,-9.4158856478670628E-14,-9.8396005020210814E-14,-1.0282382524612028E-13,-1.0745089738219569E-13,-1.122861877643945E-13,-1.1733906621379225E-13,-1.226193241934129E-13,-1.2813719378211648E-13,-1.3390336750231171E-13,-1.3992901903991575E-13,-1.4622582489671194E-13,-1.5280598701706399E-13,-1.5968225643283185E-13,-1.6686795797230929E-13,-1.7437701608106321E-13,-1.8222398180471107E-13,-1.9042406098592307E-13,-1.9899314373028957E-13,-2.0794783519815263E-13,-2.1730548778206948E-13,{"$f":"BV37-BV44","v":-2.2708423473226263E-13},-2.3730302529521446E-13,-2.479816614334991E-13,-2.5914083619800653E-13,-2.7080217382691684E-13,-2.829882716491281E-13,-2.9572274387333886E-13,-3.0903026734763912E-13,-3.2293662937828289E-13,-3.3746877770030564E-13,-3.5265487269681939E-13,-3.6852434196817628E-13,-3.8510793735674426E-13,-4.0243779453779779E-13,-4.2054749529199868E-13,-4.3947213258013865E-13,-4.5924837854624492E-13,-4.7991455558082596E-13,-5.015107105819631E-13,-5.2407869255815146E-13,-5.476622337232682E-13,-5.7230703424081531E-13,-5.9806085078165192E-13,-6.2497358906682625E-13,-6.530974005748335E-13,-6.824867836007009E-13,-7.1319868886273248E-13,-7.4529262986155538E-13,-7.7883079820532542E-13,-8.1387818412456503E-13,-8.5050270241017055E-13,-8.8877532401862826E-13,-9.2877021359946643E-13,-9.705648732114425E-13,-1.0142402925059574E-12,-1.0598811056687254E-12,-1.1075757554238182E-12,-1.15741666441789E-12,-1.2095004143166951E-12,-1.2639279329609462E-12,-1.3208046899441887E-12,-1.3802409009916772E-12,-1.4423517415363027E-12,-1.5072575699054362E-12,-1.5750841605511808E-12,-1.645962947775984E-12,-1.7200312804259034E-12,-1.7974326880450691E-12,-1.878317159007097E-12,-1.9628414311624162E-12,-2.051169295564725E-12,-2.1434719138651379E-12,-2.2399281499890688E-12,-2.340724916738577E-12,-2.446057537991813E-12]
[null,null,null,"Closing Balance","Euro",null,null,null,{"$f":"I40+I41-I42","v":464.65680743158822},{"$f":"J40+J41-J42","v":456.42350662315255},447.23685013548015,437.04227982014817,425.78254926919772,413.3975981805973,399.82442097689562,384.99692941659077,368.84580892598689,351.29836836701884,332.27838294368451,311.70592993630311,289.49721693879258,265.56440225950121,239.81540713081097,212.15371935672232,182.4781880109002,150.68280878017856,116.65649953025022,80.282865651174376,41.439954720381365,7.602807272633072E-13,7.9449335999015601E-13,8.3024556118971308E-13,8.6760661144325015E-13,9.0664890895819645E-13,9.4744810986131534E-13,9.900832748050746E-13,1.034637022171303E-12,1.0811956881690116E-12,1.1298494941366171E-12,1.1806927213727648E-12,1.2338238938345391E-12,1.2893459690570935E-12,1.3473665376646626E-12,1.4079980318595725E-12,1.4713579432932532E-12,1.5375690507414496E-12,1.6067596580248149E-12,1.6790638426359316E-12,1.7546217155545486E-12,1.8335796927545035E-12,1.9160907789284562E-12,2.0023148639802366E-12,2.0924190328593475E-12,2.1865778893380181E-12,2.2849738943582287E-12,2.3877977196043488E-12,2.4952486169865443E-12,2.6075348047509387E-12,2.7248738709647311E-12,2.8474931951581442E-12,2.9756303889402605E-12,3.1095337564425723E-12,3.249462775482488E-12,3.3956886003791998E-12,3.5484945873962637E-12,3.7081768438290956E-12,3.8750448018014051E-12,4.0494218178824684E-12,4.2316457996871792E-12,4.422069860673102E-12,4.6210630044033916E-12,4.8290108396015444E-12,5.046316327383614E-12,{"$f":"BV40+BV41-BV42","v":5.2734005621158768E-12},5.510703587411091E-12,5.7586852488445903E-12,6.0178260850425964E-12,6.2886282588695134E-12,6.5716165305186419E-12,6.8673392743919811E-12,7.1763695417396203E-12,7.4993061711179033E-12,7.8367749488182093E-12,8.1894298215150292E-12,8.5579541634832062E-12,8.9430621008399507E-12,9.3454998953777491E-12,9.7660473906697485E-12,1.0205519523249887E-11,1.0664767901796132E-11,1.1144682457376958E-11,1.1646193167958921E-11,1.2170271860517072E-11,1.271793409424034E-11,1.3290241128481155E-11,1.3888301979262807E-11,1.4513275568329633E-11,1.5166372968904466E-11,1.5848859752505166E-11,1.6562058441367898E-11,1.7307351071229455E-11,1.808618186943478E-11,1.8900060053559347E-11,1.9750562755969517E-11,2.0639338079988144E-11,2.1568108293587612E-11,2.2538673166799055E-11,2.3552913459305012E-11,2.4612794564973739E-11,2.5720370320397557E-11,2.6877786984815446E-11,2.808728739913214E-11,2.9351215332093084E-11,3.0672020022037273E-11,3.2052260923028952E-11,3.3494612664565252E-11,3.5001870234470686E-11,3.657695439502187E-11,3.8222917342797852E-11,3.9942948623223757E-11,4.1740381311268824E-11,4.3618698470275919E-11,4.5581539901438337E-11,4.7632709197003061E-11,4.9776181110868201E-11,5.2016109260857269E-11,5.4356834177595847E-11,5.6802891715587662E-11]
[null,null,null,"Interest  Opening Balance x Int Rate","Euro",{"$f":"F32","v":4.4999999999999998E-2},null,null,{"$f":"I40*$F$44","v":0},{"$f":"J40*$F$44","v":20.90955633442147},20.539057798041863,20.125658256096607,19.666902591906666,19.160214717113895,18.602891918126879,17.992098943960304,17.324861823746584,16.598061401669408,15.808426576515847,14.952527232465803,14.02676684713364,13.027374762245666,11.950398101677553,10.791693320886493,9.5469173710525048,8.2115184604905078,6.7807263951080348,5.2495424788612599,3.6127289543028467,1.8647979624171613,3.421263272684882E-14,3.575220119955702E-14,3.7361050253537085E-14,3.9042297514946254E-14,4.0799200903118836E-14,4.2635164943759192E-14,4.4553747366228357E-14,4.6558665997708636E-14,4.8653805967605524E-14,5.0843227236147766E-14,5.3131172461774417E-14,5.5522075222554257E-14,5.8020568607569209E-14,6.063149419490982E-14,6.3359911433680755E-14,6.6211107448196396E-14,6.9190607283365228E-14,7.2304184611116668E-14,7.5557872918616925E-14,7.8957977199954685E-14,8.2511086173952652E-14,8.6224085051780527E-14,9.0104168879110641E-14,9.4158856478670628E-14,9.8396005020210814E-14,1.0282382524612028E-13,1.0745089738219569E-13,1.122861877643945E-13,1.1733906621379225E-13,1.226193241934129E-13,1.2813719378211648E-13,1.3390336750231171E-13,1.3992901903991575E-13,1.4622582489671194E-13,1.5280598701706399E-13,1.5968225643283185E-13,1.6686795797230929E-13,1.7437701608106321E-13,1.8222398180471107E-13,1.9042406098592307E-13,1.9899314373028957E-13,2.0794783519815263E-13,2.1730548778206948E-13,{"$f":"BV40*$F$44","v":2.2708423473226263E-13},2.3730302529521446E-13,2.479816614334991E-13,2.5914083619800653E-13,2.7080217382691684E-13,2.829882716491281E-13,2.9572274387333886E-13,3.0903026734763912E-13,3.2293662937828289E-13,3.3746877770030564E-13,3.5265487269681939E-13,3.6852434196817628E-13,3.8510793735674426E-13,4.0243779453779779E-13,4.2054749529199868E-13,4.3947213258013865E-13,4.5924837854624492E-13,4.7991455558082596E-13,5.015107105819631E-13,5.2407869255815146E-13,5.476622337232682E-13,5.7230703424081531E-13,5.9806085078165192E-13,6.2497358906682625E-13,6.530974005748335E-13,6.824867836007009E-13,7.1319868886273248E-13,7.4529262986155538E-13,7.7883079820532542E-13,8.1387818412456503E-13,8.5050270241017055E-13,8.8877532401862826E-13,9.2877021359946643E-13,9.705648732114425E-13,1.0142402925059574E-12,1.0598811056687254E-12,1.1075757554238182E-12,1.15741666441789E-12,1.2095004143166951E-12,1.2639279329609462E-12,1.3208046899441887E-12,1.3802409009916772E-12,1.4423517415363027E-12,1.5072575699054362E-12,1.5750841605511808E-12,1.645962947775984E-12,1.7200312804259034E-12,1.7974326880450691E-12,1.878317159007097E-12,1.9628414311624162E-12,2.051169295564725E-12,2.1434719138651379E-12,2.2399281499890688E-12,2.340724916738577E-12,2.446057537991813E-12]
[]
[]
[null,null,"Subordinated Debt"]
[null,null,null,"Aggregate DSCR =CFADS/(DSsen + DSsub)"]
[null,null,null,"Aggregate DSCR * (DSsen + DSsub) =CFADS"]
[null,null,null,"(DSsen + DSsub) =CFADS/Aggregate DSCR"]
[null,null,null,"DSsub =CFADS/Aggregate DSCR - Dssen"]
[]
[null,null,null,"Tenure","Years",27]
[null,null,null,"Aggregate DSCR","x",1.5]
[null,null,null,"Interest Rate","%",6.5000000000000002E-2]
[null,null,null,"Flag for Tenure"]
[null,null,null,"CFADS for Tenure ","Euro"]
[null,null,null,"Target Debt Service - Above Formula","Euro"]
[]
[null,null,null,"Subordinated Debt - Opening","Euro"]
[null,null,null,"Add: Debt Draws","Euro"]
[null,null,null,"Less: Debt Service","Euro"]
[null,null,null,"Closing Balance","Euro"]
[null,null,null,"Interest","Euro",{"$f":"F55","v":6.5000000000000002E-2}]
[]
[]
[null,"Cash Flow Statement"]
[null,null,"Cash Before COD - Uses and Source"]
[null,null,null,"Uses"]
[null,null,null,"Cap Exp","Euro",null,null,null,{"$f":"I12","v":1000},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,{"$f":"AO12","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,{"$f":"BU12","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,{"$f":"DA12","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]
[]
[null,null,null,"Source"]
[null,null,null,"Debt","Euro",null,{"$f":"I73/I70","v":0.46465680743158821},null,{"$f":"I41","v":464.65680743158822},{"$f":"J41","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,0,0,0,0,{"$f":"BV41","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]
[null,null,null,"Subordinated Debt","Euro"]
[null,null,null,"Equity Investment","Euro",null,null,null,{"$f":"I70-I73","v":535.34319256841172},{"$f":"J70-J73","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,0,0,0,0,{"$f":"BV70-BV73","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]
[null,null,null,"Total",null,null,null,null,{"$f":"SUM(I73:I75)","v":1000},{"$f":"SUM(J73:J75)","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,0,0,0,0,{"$f":"SUM(BV73:BV75)","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]
[]
[null,null,"Cash Flow After"]
[null,null,null,"EBITDA ","Euro",null,null,null,{"$f":"I14","v":0},51,52.019999999999996,53.060399999999994,54.121608000000002,55.204040160000005,56.308120963200011,57.43428338246401,58.582969050113292,59.754628431115556,60.949720999737863,62.168715419732621,63.412089728127278,64.680331522689826,65.973938153143621,67.293416916206496,68.63928525453062,70.012070959621241,71.412312378813681,72.840558626389935,74.297369798917742,75.7833171948961,77.298983538794033,78.844963209569912,80.421862473761308,82.030299723236524,83.67090571770126,85.344323832055295,87.051210308696398,88.79223451487033,90.568079205167734,0,{"$f":"AO14","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,{"$f":"BU14","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,{"$f":"DA14","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]
[null,null,null,"Less: Interest - Senior","Euro",null,null,null,{"$f":"I44","v":0},{"$f":"J44","v":20.90955633442147},20.539057798041863,20.125658256096607,19.666902591906666,19.160214717113895,18.602891918126879,17.992098943960304,17.324861823746584,16.598061401669408,15.808426576515847,14.952527232465803,14.02676684713364,13.027374762245666,11.950398101677553,10.791693320886493,9.5469173710525048,8.2115184604905078,6.7807263951080348,5.2495424788612599,3.6127289543028467,1.8647979624171613,3.421263272684882E-14,3.575220119955702E-14,3.7361050253537085E-14,3.9042297514946254E-14,4.0799200903118836E-14,4.2635164943759192E-14,4.4553747366228357E-14,4.6558665997708636E-14,4.8653805967605524E-14,5.0843227236147766E-14,5.3131172461774417E-14,5.5522075222554257E-14,5.8020568607569209E-14,6.063149419490982E-14,6.3359911433680755E-14,6.6211107448196396E-14,6.9190607283365228E-14,7.2304184611116668E-14,7.5557872918616925E-14,7.8957977199954685E-14,8.2511086173952652E-14,8.6224085051780527E-14,9.0104168879110641E-14,9.4158856478670628E-14,9.8396005020210814E-14,1.0282382524612028E-13,1.0745089738219569E-13,1.122861877643945E-13,1.1733906621379225E-13,1.226193241934129E-13,1.2813719378211648E-13,1.3390336750231171E-13,1.3992901903991575E-13,1.4622582489671194E-13,1.5280598701706399E-13,1.5968225643283185E-13,1.6686795797230929E-13,1.7437701608106321E-13,1.8222398180471107E-13,1.9042406098592307E-13,1.9899314373028957E-13,2.0794783519815263E-13,2.1730548778206948E-13,{"$f":"BV44","v":2.2708423473226263E-13},2.3730302529521446E-13,2.479816614334991E-13,2.5914083619800653E-13,2.7080217382691684E-13,2.829882716491281E-13,2.9572274387333886E-13,3.0903026734763912E-13,3.2293662937828289E-13,3.3746877770030564E-13,3.5265487269681939E-13,3.6852434196817628E-13,3.8510793735674426E-13,4.0243779453779779E-13,4.2054749529199868E-13,4.3947213258013865E-13,4.5924837854624492E-13,4.7991455558082596E-13,5.015107105819631E-13,5.2407869255815146E-13,5.476622337232682E-13,5.7230703424081531E-13,5.9806085078165192E-13,6.2497358906682625E-13,6.530974005748335E-13,6.824867836007009E-13,7.1319868886273248E-13,7.4529262986155538E-13,7.7883079820532542E-13,8.1387818412456503E-13,8.5050270241017055E-13,8.8877532401862826E-13,9.2877021359946643E-13,9.705648732114425E-13,1.0142402925059574E-12,1.0598811056687254E-12,1.1075757554238182E-12,1.15741666441789E-12,1.2095004143166951E-12,1.2639279329609462E-12,1.3208046899441887E-12,1.3802409009916772E-12,1.4423517415363027E-12,1.5072575699054362E-12,1.5750841605511808E-12,1.645962947775984E-12,1.7200312804259034E-12,1.7974326880450691E-12,1.878317159007097E-12,1.9628414311624162E-12,2.051169295564725E-12,2.1434719138651379E-12,2.2399281499890688E-12,2.340724916738577E-12,2.446057537991813E-12]
[null,null,null,"Less: Repayment - Senior","Euro",null,null,null,{"$f":"I42","v":0},{"$f":"J42","v":8.233300808435672},9.186656487672419,10.194570315331962,11.259730550950479,12.384951088600392,13.573177203701697,14.827491560304846,16.151120490603869,17.547440558968052,19.019985423334361,20.572453007381405,22.208712997510521,23.932814679291383,25.748995128690229,27.661687774088648,29.675531345822133,31.795379230721629,34.026309249928353,36.373633879075847,38.84291093079301,41.439954720380605,-3.421263272684882E-14,-3.575220119955702E-14,-3.7361050253537085E-14,-3.9042297514946254E-14,-4.0799200903118836E-14,-4.2635164943759192E-14,-4.4553747366228357E-14,-4.6558665997708636E-14,-4.8653805967605524E-14,-5.0843227236147766E-14,-5.3131172461774417E-14,-5.5522075222554257E-14,-5.8020568607569209E-14,-6.063149419490982E-14,-6.3359911433680755E-14,-6.6211107448196396E-14,-6.9190607283365228E-14,-7.2304184611116668E-14,-7.5557872918616925E-14,-7.8957977199954685E-14,-8.2511086173952652E-14,-8.6224085051780527E-14,-9.0104168879110641E-14,-9.4158856478670628E-14,-9.8396005020210814E-14,-1.0282382524612028E-13,-1.0745089738219569E-13,-1.122861877643945E-13,-1.1733906621379225E-13,-1.226193241934129E-13,-1.2813719378211648E-13,-1.3390336750231171E-13,-1.3992901903991575E-13,-1.4622582489671194E-13,-1.5280598701706399E-13,-1.5968225643283185E-13,-1.6686795797230929E-13,-1.7437701608106321E-13,-1.8222398180471107E-13,-1.9042406098592307E-13,-1.9899314373028957E-13,-2.0794783519815263E-13,-2.1730548778206948E-13,{"$f":"BV42","v":-2.2708423473226263E-13},-2.3730302529521446E-13,-2.479816614334991E-13,-2.5914083619800653E-13,-2.7080217382691684E-13,-2.829882716491281E-13,-2.9572274387333886E-13,-3.0903026734763912E-13,-3.2293662937828289E-13,-3.3746877770030564E-13,-3.5265487269681939E-13,-3.6852434196817628E-13,-3.8510793735674426E-13,-4.0243779453779779E-13,-4.2054749529199868E-13,-4.3947213258013865E-13,-4.5924837854624492E-13,-4.7991455558082596E-13,-5.015107105819631E-13,-5.2407869255815146E-13,-5.476622337232682E-13,-5.7230703424081531E-13,-5.9806085078165192E-13,-6.2497358906682625E-13,-6.530974005748335E-13,-6.824867836007009E-13,-7.1319868886273248E-13,-7.4529262986155538E-13,-7.7883079820532542E-13,-8.1387818412456503E-13,-8.5050270241017055E-13,-8.8877532401862826E-13,-9.2877021359946643E-13,-9.705648732114425E-13,-1.0142402925059574E-12,-1.0598811056687254E-12,-1.1075757554238182E-12,-1.15741666441789E-12,-1.2095004143166951E-12,-1.2639279329609462E-12,-1.3208046899441887E-12,-1.3802409009916772E-12,-1.4423517415363027E-12,-1.5072575699054362E-12,-1.5750841605511808E-12,-1.645962947775984E-12,-1.7200312804259034E-12,-1.7974326880450691E-12,-1.878317159007097E-12,-1.9628414311624162E-12,-2.051169295564725E-12,-2.1434719138651379E-12,-2.2399281499890688E-12,-2.340724916738577E-12,-2.446057537991813E-12]
[null,null,null,"Net Cash Flow","Euro"]
[null,null,null,"Sub Debt Interest","Euro"]
[null,null,null,"Sub Debt Repayment","Euro"]
[]
[null,null,null,"Dividends","Euro",null,null,null,{"$f":"I79-I80-I81","v":0},{"$f":"J79-J80-J81","v":21.857142857142858},22.294285714285714,22.740171428571426,23.194974857142853,23.658874354285718,24.132051841371435,24.614692878198856,25.106986735762835,25.609126470478099,26.121308999887653,26.643735179885411,27.17660988348312,27.72014208115278,28.274544922775842,28.840035821231353,29.416836537655985,30.005173268409102,30.605276733777295,31.21738226845283,31.841729913821879,32.478564512098338,77.298983538794033,78.844963209569912,80.421862473761308,82.030299723236524,83.67090571770126,85.344323832055295,87.051210308696398,88.79223451487033,90.568079205167734,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,{"$f":"BV79-BV80-BV81","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]
[]
[null,"Summary Analysis - Structuring"]
[]
[null,null,null,"Equity Net Cash Flow","Euro",null,null,null,{"$f":"-I75+I86","v":-535.34319256841172},21.857142857142858,22.294285714285714,22.740171428571426,23.194974857142853,23.658874354285718,24.132051841371435,24.614692878198856,25.106986735762835,25.609126470478099,26.121308999887653,26.643735179885411,27.17660988348312,27.72014208115278,28.274544922775842,28.840035821231353,29.416836537655985,30.005173268409102,30.605276733777295,31.21738226845283,31.841729913821879,32.478564512098338,77.298983538794033,78.844963209569912,80.421862473761308,82.030299723236524,83.67090571770126,85.344323832055295,87.051210308696398,88.79223451487033,90.568079205167734,0,{"$f":"-AO75+AO86","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,{"$f":"-BU75+BU86","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,{"$f":"-DA75+DA86","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]
[null,null,null,"Equity IRR",{"$f":"IRR(I90:DX90)","v":5.1117331005168909E-2}]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(I5,I3,NA())","v":{"$error":"#N/A"}},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,{"$error":"#N/A"},{"$f":"IF(AO5,AO3,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"},{"$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"},{"$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"},{"$f":"IF(BU5,BU3,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"},{"$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"},{"$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"},{"$f":"IF(DA5,DA3,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"},{"$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"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"Cash Flow","Euro",null,null,null,{"$f":"I79","v":0},51,52.019999999999996,53.060399999999994,54.121608000000002,55.204040160000005,56.308120963200011,57.43428338246401,58.582969050113292,59.754628431115556,60.949720999737863,62.168715419732621,63.412089728127278,64.680331522689826,65.973938153143621,67.293416916206496,68.63928525453062,70.012070959621241,71.412312378813681,72.840558626389935,74.297369798917742,75.7833171948961,77.298983538794033,78.844963209569912,80.421862473761308,82.030299723236524,83.67090571770126,85.344323832055295,87.051210308696398,88.79223451487033,90.568079205167734,0,{"$f":"AO79","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,{"$f":"BU79","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,{"$f":"DA79","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]
[null,null,null,"Debt Service","Euro",null,null,null,{"$f":"I80+I81","v":0},29.142857142857142,29.725714285714282,30.320228571428569,30.926633142857145,31.545165805714287,32.176069121828576,32.81959050426515,33.475982314350453,34.145501960637461,34.828411999850211,35.52498023984721,36.235479844644161,36.960189441537047,37.699393230367782,38.453381094975143,39.222448716874638,40.006897691212139,40.807035645036386,41.623176357937105,42.455639885095856,43.304752682797769,0,0,0,0,0,0,0,0,0,0,{"$f":"AO80+AO81","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,{"$f":"BU80+BU81","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,{"$f":"DA80+DA81","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]
[]
[null,null,null,"Equity IRR",{"$f":"E91","v":5.1117331005168909E-2},"DSCR",{"$f":"F37","v":1.75},null,"Tenure",{"$f":"F35","v":22},"Debt to Capital"]
[]
[null,null,null,"DSCR",null,null,null,null,{"$f":"IF(I95>0,I94/I95)","v":false},{"$f":"IF(J95>0,J94/J95)","v":1.75},1.75,1.75,1.75,1.75,1.75,1.75,1.75,1.75,1.7499999999999998,1.75,1.75,1.7499999999999998,1.75,1.75,1.75,1.75,1.7500000000000002,1.75,1.7499999999999998,1.75,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,{"$f":"IF(BV95>0,BV94/BV95)","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]
[]
[]
[null,"Risk Analysis"]
[null,null,"Scheduled Senior Debt Repayment",null,null,null,null,{"$f":"SUM(I103:XFD103)","v":464.65680743153143},{"$f":"I42","v":0},8.233300808435672,9.186656487672419,10.194570315331962,11.259730550950479,12.384951088600392,13.573177203701697,14.827491560304846,16.151120490603869,17.547440558968052,19.019985423334361,20.572453007381405,22.208712997510521,23.932814679291383,25.748995128690229,27.661687774088648,29.675531345822133,31.795379230721629,34.026309249928353,36.373633879075847,38.84291093079301,41.439954720380605,-3.421263272684882E-14,-3.575220119955702E-14,-3.7361050253537085E-14,-3.9042297514946254E-14,-4.0799200903118836E-14,-4.2635164943759192E-14,-4.4553747366228357E-14,-4.6558665997708636E-14,-4.8653805967605524E-14,-5.0843227236147766E-14,{"$f":"AO42","v":-5.3131172461774417E-14},-5.5522075222554257E-14,-5.8020568607569209E-14,-6.063149419490982E-14,-6.3359911433680755E-14,-6.6211107448196396E-14,-6.9190607283365228E-14,-7.2304184611116668E-14,-7.5557872918616925E-14,-7.8957977199954685E-14,-8.2511086173952652E-14,-8.6224085051780527E-14,-9.0104168879110641E-14,-9.4158856478670628E-14,-9.8396005020210814E-14,-1.0282382524612028E-13,-1.0745089738219569E-13,-1.122861877643945E-13,-1.1733906621379225E-13,-1.226193241934129E-13,-1.2813719378211648E-13,-1.3390336750231171E-13,-1.3992901903991575E-13,-1.4622582489671194E-13,-1.5280598701706399E-13,-1.5968225643283185E-13,-1.6686795797230929E-13,-1.7437701608106321E-13,-1.8222398180471107E-13,-1.9042406098592307E-13,-1.9899314373028957E-13,-2.0794783519815263E-13,{"$f":"BU42","v":-2.1730548778206948E-13},-2.2708423473226263E-13,-2.3730302529521446E-13,-2.479816614334991E-13,-2.5914083619800653E-13,-2.7080217382691684E-13,-2.829882716491281E-13,-2.9572274387333886E-13,-3.0903026734763912E-13,-3.2293662937828289E-13,-3.3746877770030564E-13,-3.5265487269681939E-13,-3.6852434196817628E-13,-3.8510793735674426E-13,-4.0243779453779779E-13,-4.2054749529199868E-13,-4.3947213258013865E-13,-4.5924837854624492E-13,-4.7991455558082596E-13,-5.015107105819631E-13,-5.2407869255815146E-13,-5.476622337232682E-13,-5.7230703424081531E-13,-5.9806085078165192E-13,-6.2497358906682625E-13,-6.530974005748335E-13,-6.824867836007009E-13,-7.1319868886273248E-13,-7.4529262986155538E-13,-7.7883079820532542E-13,-8.1387818412456503E-13,-8.5050270241017055E-13,{"$f":"DA42","v":-8.8877532401862826E-13},-9.2877021359946643E-13,-9.705648732114425E-13,-1.0142402925059574E-12,-1.0598811056687254E-12,-1.1075757554238182E-12,-1.15741666441789E-12,-1.2095004143166951E-12,-1.2639279329609462E-12,-1.3208046899441887E-12,-1.3802409009916772E-12,-1.4423517415363027E-12,-1.5072575699054362E-12,-1.5750841605511808E-12,-1.645962947775984E-12,-1.7200312804259034E-12,-1.7974326880450691E-12,-1.878317159007097E-12,-1.9628414311624162E-12,-2.051169295564725E-12,-2.1434719138651379E-12,-2.2399281499890688E-12,-2.340724916738577E-12,-2.446057537991813E-12]
[null,null,"Scheduled Subordinated Debt Repayment"]
[]
[null,null,"Volatility",null,"%",0]
[null,null,"Mean Reversion",null,"%",0]
[]
[null,null,"Base Revenue Estimate",null,"Euro",{"$f":"G109/100","v":1},100,null,{"$f":"I10*$F$109","v":0},61.2,62.423999999999999,63.672479999999993,64.945929599999999,66.244848192000006,67.56974515584001,68.921140058956809,70.29956286013595,71.705554117338664,73.139665199685439,74.602458503679145,76.09450767375273,77.616397827227786,79.168725783772345,80.75210029944779,82.367142305436744,84.014485151545486,85.694774854576409,87.408670351667922,89.156843758701299,90.939980633875322,92.758780246552831,94.613955851483894,96.506234968513567,98.436359667883835,100.40508686124151,102.41318859846635,104.46145237043568,106.55068141784439,108.68169504620128,0,{"$f":"AO10*$F$109","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,{"$f":"BU10*$F$109","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,{"$f":"DA10*$F$109","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]
[]
[null,null,"Random Number - Probability",null,"%",null,null,null,{"$f":"RAND()","v":0.9869881617681654},{"$f":"RAND()","v":0.76459843810454542},{"$f":"RAND()","v":0.38417576844785117},0.24749180618117395,0.33095825708033111,0.98732334617269901,0.47363268258949076,0.64762991644496515,0.82574307091087995,0.56609811982633451,0.42962926524958633,0.82544984256841258,0.65302329956762573,0.60466817200312528,0.44074957946124493,0.22793072620744126,0.77041943713750383,0.56636056431786619,0.36521220530332044,8.7535751333169154E-2,0.16709910775832515,0.14921760463128453,0.60397623873521356,0.76852300868556067,0.45931999403130164,0.35239402456116597,0.5228778602980404,0.63245612399625406,0.28916271932138049,2.4934704911657612E-2,3.4192833917544574E-2,0.91972226517335687,0.66890483084223862,0.29274917565548852,0.80068794065040205,0.20067439788848052,0.72005667685488839,0.83174021159779032,0.56098195133549167,0.86066193913695599,0.89836113377593396,0.47008532236596567,0.13115633414118022,0.91460859533202821,0.12802088165118131,0.44692669679926267,0.44725954481191843,0.98064552049190712,0.66722009610297695,0.39401539935018992,0.58236787769060239,0.82218803676517949,0.447933798448517,0.52145754760944962,0.22494256521689482,0.80554365973058006,0.19765888687027688,0.17669793736155792,0.19121656459665781,0.6537941796492388,0.50565383817145515,0.83962828498980757,0.97796446881517574,0.94400087206772998,0.72691703647079675,{"$f":"RAND()","v":0.61685788057048707},0.75301661122874752,0.22070310203737653,0.7686699829505852,0.75301233544298263,0.59551988580485726,0.92787878121488954,0.25965160347471994,1.468764286242763E-2,9.8822217067352947E-2,0.35012573165403893,0.1902059429162527,0.41117142265251894,0.85722993940421677,0.93407679152128398,0.38488297201147537,0.40015633047703114,0.22147447154536504,0.10268658200323788,0.45247979614198042,0.15832778131126146,0.37344801100691427,0.66141081167029714,3.4221866278261959E-2,6.2614981171180029E-2,0.64586232630165652,0.6720491944134297,0.61816065829467559,0.41198306936863061,0.14652632442258817,0.96898523178826812,0.78375171301235513,0.2694280678744666,0.24875589038744816,0.13303579162402479,0.87292334264592886,0.11161980082989198,0.94279188913601364,0.93564135818620231,0.2493372309281725,5.1746473669503468E-2,0.53110531235703884,0.43043805495597676,0.88287997748144165,0.48789063047083059,0.37827234609409854,0.56104739656618452,8.7791652513310114E-2,0.60219037068659531,0.8012349847010205,0.51576336274216439,0.33105480778249285,9.3371066283181259E-2,0.11058750195300915,0.65453062155969755]
[null,null,"Cash Flow Change from Normal Distribution",null,"Factor",null,null,null,{"$f":"NORMSINV(I111)","v":2.2258582674581744},{"$f":"NORMSINV(J111)","v":0.72117293135184923},-0.29453184015404565,-0.6824038652205372,-0.43726866946129234,2.23597654419821,-6.614125603360628E-2,0.37892956732114058,0.93747581575601202,0.16644881568290096,-0.17731810486630309,0.93633581247050501,0.39349569787085742,0.26544891823849082,-0.14906903552966297,-0.74567882685323106,0.74022888146321464,0.16711587990469964,-0.34456102536108119,-1.356086955830337,-0.96569221632329016,-1.039794878035986,0.26365273055383037,0.73399139490249965,-0.10214700934860378,-0.37886509004507668,5.7377759190608911E-2,0.33836552314765306,-0.55583239335936252,-1.9610824141083714,-1.8224570312021398,1.403205829841589,0.43689108401285259,-0.54537104393370928,0.84408104556054353,-0.83921477832518432,0.58300988429291112,0.96106482038666163,0.15345928306522452,1.0832981149944287,1.2722685117191344,-7.5055385665549701E-2,-1.1209417257943504,1.3696928251487359,-1.1357964496423725,-0.13342990814241112,-0.13258816893890643,2.0672674561160642,0.43224988314502039,-0.26886860305056454,0.20795481987091624,0.92373572618503974,-0.13088333640890035,5.3812055194321431E-2,-0.75560654533834026,0.86159089971011849,-0.85001315277569489,-0.92802254574422172,-0.873421953681082,0.39558440893471603,1.4172545058470827E-2,0.9929313104593438,2.0134143008806493,1.5892752857629853,0.60351531998466101,{"$f":"NORMSINV(BV111)","v":0.29723875118462428},0.68401328394520633,-0.76982079242222567,0.7344737809818187,0.68399974136409314,0.24176762230746376,1.460173350276776,-0.64441986406898011,-2.1784132310056346,-1.2882917205048143,-0.38498103937609107,-0.87713763364337927,-0.2245326744927649,1.067956529221181,1.506860504290948,-0.29268106545148115,-0.25294248170484807,-0.76722299526980031,-1.2663909091269503,-0.11939857237616912,-1.0013542733930285,-0.32273489589937276,0.41631655962631064,-1.8220741688341127,-1.5331862857569309,0.37417335338010227,0.44557868369176462,0.30065356193314463,-0.22244672860281231,-1.0514485038450554,1.8660845555323486,0.78492665309621901,-0.61454365336621486,-0.67840998360519411,-1.1121548349584127,1.1403192646375158,-1.2179588735686007,1.5786505994425377,1.5191796442581651,-0.67657686492407443,-1.628150643482978,7.8048623096929406E-2,-0.17525902092603787,1.1895074400612171,-3.0358350596847088E-2,-0.31002138755175612,0.15362527509441584,-1.3544799525313287,0.25902071357389833,0.8460407165110807,3.952317808045637E-2,-0.43700238888461918,-1.3202782560424233,-1.2234096671261598,0.39758142232399613]
[null,null,"Cash Flow Change After Volatilty",null,"Factor",{"$f":"F106","v":0},null,null,{"$f":"I112*$F$113","v":0},{"$f":"J112*$F$113","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,0,0,0,0,{"$f":"BV112*$F$113","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]
[]
[null,null,"Last Period",null,"Index",null,null,null,{"$f":"H118","v":1},{"$f":"I118","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,{"$f":"BU118","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"Mean Reversion Adjustment",null,"Index",{"$f":"F107","v":0},null,null,null,{"$f":"(J115-1)*$F$116","v":0},{"$f":"(K115-1)*$F$116","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,0,0,0,0,{"$f":"(BW115-1)*$F$116","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]
[]
[null,null,"Random Index",null,"Index",{"$f":"F106","v":0},{"$f":"F107","v":0},{"$f":"AVERAGE(I118:DX118)","v":1},1,{"$f":"I118*(1+J113)-J116","v":1},{"$f":"J118*(1+K113)-K116","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,{"$f":"BV118*(1+BW113)-BW116","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"Adjusted Revenue",null,"Euro",null,null,null,{"$f":"I109*I118","v":0},{"$f":"J109*J118","v":61.2},62.423999999999999,63.672479999999993,64.945929599999999,66.244848192000006,67.56974515584001,68.921140058956809,70.29956286013595,71.705554117338664,73.139665199685439,74.602458503679145,76.09450767375273,77.616397827227786,79.168725783772345,80.75210029944779,82.367142305436744,84.014485151545486,85.694774854576409,87.408670351667922,89.156843758701299,90.939980633875322,92.758780246552831,94.613955851483894,96.506234968513567,98.436359667883835,100.40508686124151,102.41318859846635,104.46145237043568,106.55068141784439,108.68169504620128,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,{"$f":"BV109*BV118","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]
[null,null,"Operating Expense",null,"Euro",null,null,null,{"$f":"I11","v":0},10.199999999999999,10.404,10.612079999999999,10.824321599999999,11.040808032000001,11.261624192640001,11.486856676492801,11.716593810022658,11.95092568622311,12.189944199947574,12.433743083946524,12.682417945625454,12.936066304537963,13.194787630628724,13.458683383241299,13.727857050906124,14.002414191924249,14.282462475762735,14.568111725277987,14.85947395978355,15.156663438979221,15.459796707758805,15.768992641913982,16.084372494752262,16.406059944647307,16.734181143540251,17.068864766411057,17.410242061739282,17.758446902974065,18.11361584103355,0,{"$f":"AO11","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,{"$f":"BU11","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,{"$f":"DA11","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]
[null,null,"Adjusted EBITDA",null,"Euro",null,null,null,{"$f":"I119-I120","v":0},{"$f":"J119-J120","v":51},52.019999999999996,53.060399999999994,54.121608000000002,55.204040160000005,56.308120963200011,57.43428338246401,58.582969050113292,59.754628431115556,60.949720999737863,62.168715419732621,63.412089728127278,64.680331522689826,65.973938153143621,67.293416916206496,68.63928525453062,70.012070959621241,71.412312378813681,72.840558626389935,74.297369798917742,75.7833171948961,77.298983538794033,78.844963209569912,80.421862473761308,82.030299723236524,83.67090571770126,85.344323832055295,87.051210308696398,88.79223451487033,90.568079205167734,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,{"$f":"BV119-BV120","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]
[]
[null,"Adjusted Senior Debt Schedule"]
[null,null,"Base Debt"]
[null,null,null,"Opening Debt","Euro",null,null,null,{"$f":"H129","v":0},{"$f":"I129","v":464.65680743158822},456.42350662315255,447.23685013548015,437.04227982014817,425.78254926919772,413.3975981805973,399.82442097689562,384.99692941659077,368.84580892598689,351.29836836701884,332.27838294368451,311.70592993630311,289.49721693879258,265.56440225950121,239.81540713081097,212.15371935672232,182.4781880109002,150.68280878017856,116.65649953025022,80.282865651174376,41.439954720381365,7.602807272633072E-13,7.9449335999015601E-13,8.3024556118971308E-13,8.6760661144325015E-13,9.0664890895819645E-13,9.4744810986131534E-13,9.900832748050746E-13,1.034637022171303E-12,1.0811956881690116E-12,1.1298494941366171E-12,1.1806927213727648E-12,1.2338238938345391E-12,1.2893459690570935E-12,1.3473665376646626E-12,1.4079980318595725E-12,1.4713579432932532E-12,1.5375690507414496E-12,1.6067596580248149E-12,1.6790638426359316E-12,1.7546217155545486E-12,1.8335796927545035E-12,1.9160907789284562E-12,2.0023148639802366E-12,2.0924190328593475E-12,2.1865778893380181E-12,2.2849738943582287E-12,2.3877977196043488E-12,2.4952486169865443E-12,2.6075348047509387E-12,2.7248738709647311E-12,2.8474931951581442E-12,2.9756303889402605E-12,3.1095337564425723E-12,3.249462775482488E-12,3.3956886003791998E-12,3.5484945873962637E-12,3.7081768438290956E-12,3.8750448018014051E-12,4.0494218178824684E-12,4.2316457996871792E-12,4.422069860673102E-12,4.6210630044033916E-12,4.8290108396015444E-12,{"$f":"BU129","v":5.046316327383614E-12},5.2734005621158768E-12,5.510703587411091E-12,5.7586852488445903E-12,6.0178260850425964E-12,6.2886282588695134E-12,6.5716165305186419E-12,6.8673392743919811E-12,7.1763695417396203E-12,7.4993061711179033E-12,7.8367749488182093E-12,8.1894298215150292E-12,8.5579541634832062E-12,8.9430621008399507E-12,9.3454998953777491E-12,9.7660473906697485E-12,1.0205519523249887E-11,1.0664767901796132E-11,1.1144682457376958E-11,1.1646193167958921E-11,1.2170271860517072E-11,1.271793409424034E-11,1.3290241128481155E-11,1.3888301979262807E-11,1.4513275568329633E-11,1.5166372968904466E-11,1.5848859752505166E-11,1.6562058441367898E-11,1.7307351071229455E-11,1.808618186943478E-11,1.8900060053559347E-11,1.9750562755969517E-11,2.0639338079988144E-11,2.1568108293587612E-11,2.2538673166799055E-11,2.3552913459305012E-11,2.4612794564973739E-11,2.5720370320397557E-11,2.6877786984815446E-11,2.808728739913214E-11,2.9351215332093084E-11,3.0672020022037273E-11,3.2052260923028952E-11,3.3494612664565252E-11,3.5001870234470686E-11,3.657695439502187E-11,3.8222917342797852E-11,3.9942948623223757E-11,4.1740381311268824E-11,4.3618698470275919E-11,4.5581539901438337E-11,4.7632709197003061E-11,4.9776181110868201E-11,5.2016109260857269E-11,5.4356834177595847E-11]
[null,null,null,"Add: Debt Issue","Euro",null,null,null,{"$f":"I41","v":464.65680743158822},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,{"$f":"AO41","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,{"$f":"BU41","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,{"$f":"DA41","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]
[null,null,null,"Less: Scheduled","Euro",null,null,null,{"$f":"I81","v":0},8.233300808435672,9.186656487672419,10.194570315331962,11.259730550950479,12.384951088600392,13.573177203701697,14.827491560304846,16.151120490603869,17.547440558968052,19.019985423334361,20.572453007381405,22.208712997510521,23.932814679291383,25.748995128690229,27.661687774088648,29.675531345822133,31.795379230721629,34.026309249928353,36.373633879075847,38.84291093079301,41.439954720380605,-3.421263272684882E-14,-3.575220119955702E-14,-3.7361050253537085E-14,-3.9042297514946254E-14,-4.0799200903118836E-14,-4.2635164943759192E-14,-4.4553747366228357E-14,-4.6558665997708636E-14,-4.8653805967605524E-14,-5.0843227236147766E-14,{"$f":"AO81","v":-5.3131172461774417E-14},-5.5522075222554257E-14,-5.8020568607569209E-14,-6.063149419490982E-14,-6.3359911433680755E-14,-6.6211107448196396E-14,-6.9190607283365228E-14,-7.2304184611116668E-14,-7.5557872918616925E-14,-7.8957977199954685E-14,-8.2511086173952652E-14,-8.6224085051780527E-14,-9.0104168879110641E-14,-9.4158856478670628E-14,-9.8396005020210814E-14,-1.0282382524612028E-13,-1.0745089738219569E-13,-1.122861877643945E-13,-1.1733906621379225E-13,-1.226193241934129E-13,-1.2813719378211648E-13,-1.3390336750231171E-13,-1.3992901903991575E-13,-1.4622582489671194E-13,-1.5280598701706399E-13,-1.5968225643283185E-13,-1.6686795797230929E-13,-1.7437701608106321E-13,-1.8222398180471107E-13,-1.9042406098592307E-13,-1.9899314373028957E-13,-2.0794783519815263E-13,{"$f":"BU81","v":-2.1730548778206948E-13},-2.2708423473226263E-13,-2.3730302529521446E-13,-2.479816614334991E-13,-2.5914083619800653E-13,-2.7080217382691684E-13,-2.829882716491281E-13,-2.9572274387333886E-13,-3.0903026734763912E-13,-3.2293662937828289E-13,-3.3746877770030564E-13,-3.5265487269681939E-13,-3.6852434196817628E-13,-3.8510793735674426E-13,-4.0243779453779779E-13,-4.2054749529199868E-13,-4.3947213258013865E-13,-4.5924837854624492E-13,-4.7991455558082596E-13,-5.015107105819631E-13,-5.2407869255815146E-13,-5.476622337232682E-13,-5.7230703424081531E-13,-5.9806085078165192E-13,-6.2497358906682625E-13,-6.530974005748335E-13,-6.824867836007009E-13,-7.1319868886273248E-13,-7.4529262986155538E-13,-7.7883079820532542E-13,-8.1387818412456503E-13,-8.5050270241017055E-13,{"$f":"DA81","v":-8.8877532401862826E-13},-9.2877021359946643E-13,-9.705648732114425E-13,-1.0142402925059574E-12,-1.0598811056687254E-12,-1.1075757554238182E-12,-1.15741666441789E-12,-1.2095004143166951E-12,-1.2639279329609462E-12,-1.3208046899441887E-12,-1.3802409009916772E-12,-1.4423517415363027E-12,-1.5072575699054362E-12,-1.5750841605511808E-12,-1.645962947775984E-12,-1.7200312804259034E-12,-1.7974326880450691E-12,-1.878317159007097E-12,-1.9628414311624162E-12,-2.051169295564725E-12,-2.1434719138651379E-12,-2.2399281499890688E-12,-2.340724916738577E-12,-2.446057537991813E-12]
[null,null,null,"Less: Cash Sweep","Euro"]
[null,null,null,"Closing Balance","Euro",null,null,null,{"$f":"I125+I126-I127-I128","v":464.65680743158822},{"$f":"J125+J126-J127-J128","v":456.42350662315255},447.23685013548015,437.04227982014817,425.78254926919772,413.3975981805973,399.82442097689562,384.99692941659077,368.84580892598689,351.29836836701884,332.27838294368451,311.70592993630311,289.49721693879258,265.56440225950121,239.81540713081097,212.15371935672232,182.4781880109002,150.68280878017856,116.65649953025022,80.282865651174376,41.439954720381365,7.602807272633072E-13,7.9449335999015601E-13,8.3024556118971308E-13,8.6760661144325015E-13,9.0664890895819645E-13,9.4744810986131534E-13,9.900832748050746E-13,1.034637022171303E-12,1.0811956881690116E-12,1.1298494941366171E-12,1.1806927213727648E-12,1.2338238938345391E-12,1.2893459690570935E-12,1.3473665376646626E-12,1.4079980318595725E-12,1.4713579432932532E-12,1.5375690507414496E-12,1.6067596580248149E-12,1.6790638426359316E-12,1.7546217155545486E-12,1.8335796927545035E-12,1.9160907789284562E-12,2.0023148639802366E-12,2.0924190328593475E-12,2.1865778893380181E-12,2.2849738943582287E-12,2.3877977196043488E-12,2.4952486169865443E-12,2.6075348047509387E-12,2.7248738709647311E-12,2.8474931951581442E-12,2.9756303889402605E-12,3.1095337564425723E-12,3.249462775482488E-12,3.3956886003791998E-12,3.5484945873962637E-12,3.7081768438290956E-12,3.8750448018014051E-12,4.0494218178824684E-12,4.2316457996871792E-12,4.422069860673102E-12,4.6210630044033916E-12,4.8290108396015444E-12,5.046316327383614E-12,{"$f":"BV125+BV126-BV127-BV128","v":5.2734005621158768E-12},5.510703587411091E-12,5.7586852488445903E-12,6.0178260850425964E-12,6.2886282588695134E-12,6.5716165305186419E-12,6.8673392743919811E-12,7.1763695417396203E-12,7.4993061711179033E-12,7.8367749488182093E-12,8.1894298215150292E-12,8.5579541634832062E-12,8.9430621008399507E-12,9.3454998953777491E-12,9.7660473906697485E-12,1.0205519523249887E-11,1.0664767901796132E-11,1.1144682457376958E-11,1.1646193167958921E-11,1.2170271860517072E-11,1.271793409424034E-11,1.3290241128481155E-11,1.3888301979262807E-11,1.4513275568329633E-11,1.5166372968904466E-11,1.5848859752505166E-11,1.6562058441367898E-11,1.7307351071229455E-11,1.808618186943478E-11,1.8900060053559347E-11,1.9750562755969517E-11,2.0639338079988144E-11,2.1568108293587612E-11,2.2538673166799055E-11,2.3552913459305012E-11,2.4612794564973739E-11,2.5720370320397557E-11,2.6877786984815446E-11,2.808728739913214E-11,2.9351215332093084E-11,3.0672020022037273E-11,3.2052260923028952E-11,3.3494612664565252E-11,3.5001870234470686E-11,3.657695439502187E-11,3.8222917342797852E-11,3.9942948623223757E-11,4.1740381311268824E-11,4.3618698470275919E-11,4.5581539901438337E-11,4.7632709197003061E-11,4.9776181110868201E-11,5.2016109260857269E-11,5.4356834177595847E-11,5.6802891715587662E-11]
[null,null,null,"Interest ","Euro",{"$f":"$F$44","v":4.4999999999999998E-2},null,null,{"$f":"I125*$F$130","v":0},{"$f":"J125*$F$130","v":20.90955633442147},20.539057798041863,20.125658256096607,19.666902591906666,19.160214717113895,18.602891918126879,17.992098943960304,17.324861823746584,16.598061401669408,15.808426576515847,14.952527232465803,14.02676684713364,13.027374762245666,11.950398101677553,10.791693320886493,9.5469173710525048,8.2115184604905078,6.7807263951080348,5.2495424788612599,3.6127289543028467,1.8647979624171613,3.421263272684882E-14,3.575220119955702E-14,3.7361050253537085E-14,3.9042297514946254E-14,4.0799200903118836E-14,4.2635164943759192E-14,4.4553747366228357E-14,4.6558665997708636E-14,4.8653805967605524E-14,5.0843227236147766E-14,5.3131172461774417E-14,5.5522075222554257E-14,5.8020568607569209E-14,6.063149419490982E-14,6.3359911433680755E-14,6.6211107448196396E-14,6.9190607283365228E-14,7.2304184611116668E-14,7.5557872918616925E-14,7.8957977199954685E-14,8.2511086173952652E-14,8.6224085051780527E-14,9.0104168879110641E-14,9.4158856478670628E-14,9.8396005020210814E-14,1.0282382524612028E-13,1.0745089738219569E-13,1.122861877643945E-13,1.1733906621379225E-13,1.226193241934129E-13,1.2813719378211648E-13,1.3390336750231171E-13,1.3992901903991575E-13,1.4622582489671194E-13,1.5280598701706399E-13,1.5968225643283185E-13,1.6686795797230929E-13,1.7437701608106321E-13,1.8222398180471107E-13,1.9042406098592307E-13,1.9899314373028957E-13,2.0794783519815263E-13,2.1730548778206948E-13,{"$f":"BV125*$F$130","v":2.2708423473226263E-13},2.3730302529521446E-13,2.479816614334991E-13,2.5914083619800653E-13,2.7080217382691684E-13,2.829882716491281E-13,2.9572274387333886E-13,3.0903026734763912E-13,3.2293662937828289E-13,3.3746877770030564E-13,3.5265487269681939E-13,3.6852434196817628E-13,3.8510793735674426E-13,4.0243779453779779E-13,4.2054749529199868E-13,4.3947213258013865E-13,4.5924837854624492E-13,4.7991455558082596E-13,5.015107105819631E-13,5.2407869255815146E-13,5.476622337232682E-13,5.7230703424081531E-13,5.9806085078165192E-13,6.2497358906682625E-13,6.530974005748335E-13,6.824867836007009E-13,7.1319868886273248E-13,7.4529262986155538E-13,7.7883079820532542E-13,8.1387818412456503E-13,8.5050270241017055E-13,8.8877532401862826E-13,9.2877021359946643E-13,9.705648732114425E-13,1.0142402925059574E-12,1.0598811056687254E-12,1.1075757554238182E-12,1.15741666441789E-12,1.2095004143166951E-12,1.2639279329609462E-12,1.3208046899441887E-12,1.3802409009916772E-12,1.4423517415363027E-12,1.5072575699054362E-12,1.5750841605511808E-12,1.645962947775984E-12,1.7200312804259034E-12,1.7974326880450691E-12,1.878317159007097E-12,1.9628414311624162E-12,2.051169295564725E-12,2.1434719138651379E-12,2.2399281499890688E-12,2.340724916738577E-12,2.446057537991813E-12]
[]
[null,null,"Defaulted Senior Debt"]
[null,null,null,"Opening Balance","Euro",null,null,null,{"$f":"H136","v":0},{"$f":"I136","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,0,0,0,0,{"$f":"BU136","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]
[null,null,null,"Add: Default","Euro"]
[null,null,null,"Less: Repayment of Default","Euro"]
[null,null,null,"Closing Balance","Euro",null,null,null,{"$f":"I133+I134-I135","v":0},{"$f":"J133+J134-J135","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,0,0,0,0,{"$f":"BV133+BV134-BV135","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]
[null,null,null,"Interest","Euro",{"$f":"$F$44","v":4.4999999999999998E-2},null,null,{"$f":"I133*$F$137","v":0},{"$f":"J133*$F$137","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,0,0,0,0,{"$f":"BV133*$F$137","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]
[]
[null,null,null,"Senior Interest","Euro",null,null,null,{"$f":"I137+I130","v":0},{"$f":"J137+J130","v":20.90955633442147},20.539057798041863,20.125658256096607,19.666902591906666,19.160214717113895,18.602891918126879,17.992098943960304,17.324861823746584,16.598061401669408,15.808426576515847,14.952527232465803,14.02676684713364,13.027374762245666,11.950398101677553,10.791693320886493,9.5469173710525048,8.2115184604905078,6.7807263951080348,5.2495424788612599,3.6127289543028467,1.8647979624171613,3.421263272684882E-14,3.575220119955702E-14,3.7361050253537085E-14,3.9042297514946254E-14,4.0799200903118836E-14,4.2635164943759192E-14,4.4553747366228357E-14,4.6558665997708636E-14,4.8653805967605524E-14,5.0843227236147766E-14,5.3131172461774417E-14,5.5522075222554257E-14,5.8020568607569209E-14,6.063149419490982E-14,6.3359911433680755E-14,6.6211107448196396E-14,6.9190607283365228E-14,7.2304184611116668E-14,7.5557872918616925E-14,7.8957977199954685E-14,8.2511086173952652E-14,8.6224085051780527E-14,9.0104168879110641E-14,9.4158856478670628E-14,9.8396005020210814E-14,1.0282382524612028E-13,1.0745089738219569E-13,1.122861877643945E-13,1.1733906621379225E-13,1.226193241934129E-13,1.2813719378211648E-13,1.3390336750231171E-13,1.3992901903991575E-13,1.4622582489671194E-13,1.5280598701706399E-13,1.5968225643283185E-13,1.6686795797230929E-13,1.7437701608106321E-13,1.8222398180471107E-13,1.9042406098592307E-13,1.9899314373028957E-13,2.0794783519815263E-13,2.1730548778206948E-13,{"$f":"BV137+BV130","v":2.2708423473226263E-13},2.3730302529521446E-13,2.479816614334991E-13,2.5914083619800653E-13,2.7080217382691684E-13,2.829882716491281E-13,2.9572274387333886E-13,3.0903026734763912E-13,3.2293662937828289E-13,3.3746877770030564E-13,3.5265487269681939E-13,3.6852434196817628E-13,3.8510793735674426E-13,4.0243779453779779E-13,4.2054749529199868E-13,4.3947213258013865E-13,4.5924837854624492E-13,4.7991455558082596E-13,5.015107105819631E-13,5.2407869255815146E-13,5.476622337232682E-13,5.7230703424081531E-13,5.9806085078165192E-13,6.2497358906682625E-13,6.530974005748335E-13,6.824867836007009E-13,7.1319868886273248E-13,7.4529262986155538E-13,7.7883079820532542E-13,8.1387818412456503E-13,8.5050270241017055E-13,8.8877532401862826E-13,9.2877021359946643E-13,9.705648732114425E-13,1.0142402925059574E-12,1.0598811056687254E-12,1.1075757554238182E-12,1.15741666441789E-12,1.2095004143166951E-12,1.2639279329609462E-12,1.3208046899441887E-12,1.3802409009916772E-12,1.4423517415363027E-12,1.5072575699054362E-12,1.5750841605511808E-12,1.645962947775984E-12,1.7200312804259034E-12,1.7974326880450691E-12,1.878317159007097E-12,1.9628414311624162E-12,2.051169295564725E-12,2.1434719138651379E-12,2.2399281499890688E-12,2.340724916738577E-12,2.446057537991813E-12]
[]
[null,"Adjusted Subordinated Debt Schedule"]
[null,null,"Base Debt"]
[null,null,null,"Opening Debt","Euro"]
[null,null,null,"Add: Debt Issue","Euro"]
[null,null,null,"Less: Scheduled","Euro"]
[null,null,null,"Less: Cash Sweep","Euro"]
[null,null,null,"Closing Balance","Euro"]
[null,null,null,"Interest ","Euro"]
[]
[]
[null,null,"Defaulted Senior Debt"]
[null,null,null,"Opening Balance","Euro"]
[null,null,null,"Add: Default","Euro"]
[null,null,null,"Less: Repayment of Default","Euro"]
[null,null,null,"Closing Balance","Euro"]
[null,null,null,"Interest","Euro"]
[]
[null,null,null,"Senior Interest","Euro"]
[]
[]
[]
[null,"Adjusted Cash Waterfall"]
[null,null,"Adjusted Revenues",null,"Euro",null,null,null,{"$f":"I109*I118","v":0},61.2,62.423999999999999,63.672479999999993,64.945929599999999,66.244848192000006,67.56974515584001,68.921140058956809,70.29956286013595,71.705554117338664,73.139665199685439,74.602458503679145,76.09450767375273,77.616397827227786,79.168725783772345,80.75210029944779,82.367142305436744,84.014485151545486,85.694774854576409,87.408670351667922,89.156843758701299,90.939980633875322,92.758780246552831,94.613955851483894,96.506234968513567,98.436359667883835,100.40508686124151,102.41318859846635,104.46145237043568,106.55068141784439,108.68169504620128,0,{"$f":"AO109*AO118","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,{"$f":"BU109*BU118","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,{"$f":"DA109*DA118","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]
[null,null,"Less Operating Expense",null,"Euro",null,null,null,{"$f":"I11","v":0},10.199999999999999,10.404,10.612079999999999,10.824321599999999,11.040808032000001,11.261624192640001,11.486856676492801,11.716593810022658,11.95092568622311,12.189944199947574,12.433743083946524,12.682417945625454,12.936066304537963,13.194787630628724,13.458683383241299,13.727857050906124,14.002414191924249,14.282462475762735,14.568111725277987,14.85947395978355,15.156663438979221,15.459796707758805,15.768992641913982,16.084372494752262,16.406059944647307,16.734181143540251,17.068864766411057,17.410242061739282,17.758446902974065,18.11361584103355,0,{"$f":"AO11","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,{"$f":"BU11","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,{"$f":"DA11","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]
[null,null,"EBITDA",null,null,null,null,null,{"$f":"I163-I164","v":0},{"$f":"J163-J164","v":51},52.019999999999996,53.060399999999994,54.121608000000002,55.204040160000005,56.308120963200011,57.43428338246401,58.582969050113292,59.754628431115556,60.949720999737863,62.168715419732621,63.412089728127278,64.680331522689826,65.973938153143621,67.293416916206496,68.63928525453062,70.012070959621241,71.412312378813681,72.840558626389935,74.297369798917742,75.7833171948961,77.298983538794033,78.844963209569912,80.421862473761308,82.030299723236524,83.67090571770126,85.344323832055295,87.051210308696398,88.79223451487033,90.568079205167734,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,{"$f":"BV163-BV164","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]
[]
[null,null,"Less: Interest",null,"Euro",null,null,null,{"$f":"I139","v":0},{"$f":"J139","v":20.90955633442147},20.539057798041863,20.125658256096607,19.666902591906666,19.160214717113895,18.602891918126879,17.992098943960304,17.324861823746584,16.598061401669408,15.808426576515847,14.952527232465803,14.02676684713364,13.027374762245666,11.950398101677553,10.791693320886493,9.5469173710525048,8.2115184604905078,6.7807263951080348,5.2495424788612599,3.6127289543028467,1.8647979624171613,3.421263272684882E-14,3.575220119955702E-14,3.7361050253537085E-14,3.9042297514946254E-14,4.0799200903118836E-14,4.2635164943759192E-14,4.4553747366228357E-14,4.6558665997708636E-14,4.8653805967605524E-14,5.0843227236147766E-14,5.3131172461774417E-14,5.5522075222554257E-14,5.8020568607569209E-14,6.063149419490982E-14,6.3359911433680755E-14,6.6211107448196396E-14,6.9190607283365228E-14,7.2304184611116668E-14,7.5557872918616925E-14,7.8957977199954685E-14,8.2511086173952652E-14,8.6224085051780527E-14,9.0104168879110641E-14,9.4158856478670628E-14,9.8396005020210814E-14,1.0282382524612028E-13,1.0745089738219569E-13,1.122861877643945E-13,1.1733906621379225E-13,1.226193241934129E-13,1.2813719378211648E-13,1.3390336750231171E-13,1.3992901903991575E-13,1.4622582489671194E-13,1.5280598701706399E-13,1.5968225643283185E-13,1.6686795797230929E-13,1.7437701608106321E-13,1.8222398180471107E-13,1.9042406098592307E-13,1.9899314373028957E-13,2.0794783519815263E-13,2.1730548778206948E-13,{"$f":"BV139","v":2.2708423473226263E-13},2.3730302529521446E-13,2.479816614334991E-13,2.5914083619800653E-13,2.7080217382691684E-13,2.829882716491281E-13,2.9572274387333886E-13,3.0903026734763912E-13,3.2293662937828289E-13,3.3746877770030564E-13,3.5265487269681939E-13,3.6852434196817628E-13,3.8510793735674426E-13,4.0243779453779779E-13,4.2054749529199868E-13,4.3947213258013865E-13,4.5924837854624492E-13,4.7991455558082596E-13,5.015107105819631E-13,5.2407869255815146E-13,5.476622337232682E-13,5.7230703424081531E-13,5.9806085078165192E-13,6.2497358906682625E-13,6.530974005748335E-13,6.824867836007009E-13,7.1319868886273248E-13,7.4529262986155538E-13,7.7883079820532542E-13,8.1387818412456503E-13,8.5050270241017055E-13,8.8877532401862826E-13,9.2877021359946643E-13,9.705648732114425E-13,1.0142402925059574E-12,1.0598811056687254E-12,1.1075757554238182E-12,1.15741666441789E-12,1.2095004143166951E-12,1.2639279329609462E-12,1.3208046899441887E-12,1.3802409009916772E-12,1.4423517415363027E-12,1.5072575699054362E-12,1.5750841605511808E-12,1.645962947775984E-12,1.7200312804259034E-12,1.7974326880450691E-12,1.878317159007097E-12,1.9628414311624162E-12,2.051169295564725E-12,2.1434719138651379E-12,2.2399281499890688E-12,2.340724916738577E-12,2.446057537991813E-12]
[null,null,"Less: Debt Repayment Scheduled",null,"Euro",null,null,null,{"$f":"I127","v":0},{"$f":"J127","v":8.233300808435672},9.186656487672419,10.194570315331962,11.259730550950479,12.384951088600392,13.573177203701697,14.827491560304846,16.151120490603869,17.547440558968052,19.019985423334361,20.572453007381405,22.208712997510521,23.932814679291383,25.748995128690229,27.661687774088648,29.675531345822133,31.795379230721629,34.026309249928353,36.373633879075847,38.84291093079301,41.439954720380605,-3.421263272684882E-14,-3.575220119955702E-14,-3.7361050253537085E-14,-3.9042297514946254E-14,-4.0799200903118836E-14,-4.2635164943759192E-14,-4.4553747366228357E-14,-4.6558665997708636E-14,-4.8653805967605524E-14,-5.0843227236147766E-14,-5.3131172461774417E-14,-5.5522075222554257E-14,-5.8020568607569209E-14,-6.063149419490982E-14,-6.3359911433680755E-14,-6.6211107448196396E-14,-6.9190607283365228E-14,-7.2304184611116668E-14,-7.5557872918616925E-14,-7.8957977199954685E-14,-8.2511086173952652E-14,-8.6224085051780527E-14,-9.0104168879110641E-14,-9.4158856478670628E-14,-9.8396005020210814E-14,-1.0282382524612028E-13,-1.0745089738219569E-13,-1.122861877643945E-13,-1.1733906621379225E-13,-1.226193241934129E-13,-1.2813719378211648E-13,-1.3390336750231171E-13,-1.3992901903991575E-13,-1.4622582489671194E-13,-1.5280598701706399E-13,-1.5968225643283185E-13,-1.6686795797230929E-13,-1.7437701608106321E-13,-1.8222398180471107E-13,-1.9042406098592307E-13,-1.9899314373028957E-13,-2.0794783519815263E-13,-2.1730548778206948E-13,{"$f":"BV127","v":-2.2708423473226263E-13},-2.3730302529521446E-13,-2.479816614334991E-13,-2.5914083619800653E-13,-2.7080217382691684E-13,-2.829882716491281E-13,-2.9572274387333886E-13,-3.0903026734763912E-13,-3.2293662937828289E-13,-3.3746877770030564E-13,-3.5265487269681939E-13,-3.6852434196817628E-13,-3.8510793735674426E-13,-4.0243779453779779E-13,-4.2054749529199868E-13,-4.3947213258013865E-13,-4.5924837854624492E-13,-4.7991455558082596E-13,-5.015107105819631E-13,-5.2407869255815146E-13,-5.476622337232682E-13,-5.7230703424081531E-13,-5.9806085078165192E-13,-6.2497358906682625E-13,-6.530974005748335E-13,-6.824867836007009E-13,-7.1319868886273248E-13,-7.4529262986155538E-13,-7.7883079820532542E-13,-8.1387818412456503E-13,-8.5050270241017055E-13,-8.8877532401862826E-13,-9.2877021359946643E-13,-9.705648732114425E-13,-1.0142402925059574E-12,-1.0598811056687254E-12,-1.1075757554238182E-12,-1.15741666441789E-12,-1.2095004143166951E-12,-1.2639279329609462E-12,-1.3208046899441887E-12,-1.3802409009916772E-12,-1.4423517415363027E-12,-1.5072575699054362E-12,-1.5750841605511808E-12,-1.645962947775984E-12,-1.7200312804259034E-12,-1.7974326880450691E-12,-1.878317159007097E-12,-1.9628414311624162E-12,-2.051169295564725E-12,-2.1434719138651379E-12,-2.2399281499890688E-12,-2.340724916738577E-12,-2.446057537991813E-12]
[null,null,"Cash Flow After Scheduled Debt Service",null,"Euro",null,null,null,{"$f":"I165-I167-I168","v":0},{"$f":"J165-J167-J168","v":21.857142857142858},22.294285714285714,22.740171428571426,23.194974857142853,23.658874354285718,24.132051841371435,24.614692878198856,25.106986735762835,25.609126470478099,26.121308999887653,26.643735179885411,27.17660988348312,27.72014208115278,28.274544922775842,28.840035821231353,29.416836537655985,30.005173268409102,30.605276733777295,31.21738226845283,31.841729913821879,32.478564512098338,77.298983538794033,78.844963209569912,80.421862473761308,82.030299723236524,83.67090571770126,85.344323832055295,87.051210308696398,88.79223451487033,90.568079205167734,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,{"$f":"BV165-BV167-BV168","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]
[]
[null,null,"Cash Sweep",null,"%",{"$f":"G171/100","v":0},0,null,{"$f":"$F$171","v":0},{"$f":"$F$171","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,0,0,0,0,{"$f":"$F$171","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]
[null,null,"Cash Swept Before Constraint",null,"Euro",null,null,null,{"$f":"MAX(I169,0)*I171","v":0},{"$f":"MAX(J169,0)*J171","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,0,0,0,0,{"$f":"MAX(BV169,0)*BV171","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]
[null,null,"Cash Swept After Constraint",null,null,null,null,null,{"$f":"MIN(I172,I125-I127)","v":0},{"$f":"MIN(J172,J125-J127)","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,0,0,0,0,{"$f":"MIN(BV172,BV125-BV127)","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]
[]
[null,null,"Cash Flow Before Default",null,"Euro",null,null,null,{"$f":"I169-I173","v":0},{"$f":"J169-J173","v":21.857142857142858},22.294285714285714,22.740171428571426,23.194974857142853,23.658874354285718,24.132051841371435,24.614692878198856,25.106986735762835,25.609126470478099,26.121308999887653,26.643735179885411,27.17660988348312,27.72014208115278,28.274544922775842,28.840035821231353,29.416836537655985,30.005173268409102,30.605276733777295,31.21738226845283,31.841729913821879,32.478564512098338,77.298983538794033,78.844963209569912,80.421862473761308,82.030299723236524,83.67090571770126,85.344323832055295,87.051210308696398,88.79223451487033,90.568079205167734,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,{"$f":"BV169-BV173","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]
[null,null,"Add: Repayment not Made from Default",null,"Euro",null,null,null,{"$f":"MAX(-I175,0)","v":0},{"$f":"MAX(-J175,0)","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,0,0,0,0,{"$f":"MAX(-BV175,0)","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]
[null,null,"Less: Repayment of Default",null,"Euro",null,null,null,{"$f":"MIN(MAX(I169,0),I133)","v":0},{"$f":"MIN(MAX(J169,0),J133)","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,0,0,0,0,{"$f":"MIN(MAX(BV169,0),BV133)","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]
[]
[null,null,"Cash Flow After Sweep",null,"Euro",null,null,null,{"$f":"I175+I176-I177","v":0},{"$f":"J175+J176-J177","v":21.857142857142858},22.294285714285714,22.740171428571426,23.194974857142853,23.658874354285718,24.132051841371435,24.614692878198856,25.106986735762835,25.609126470478099,26.121308999887653,26.643735179885411,27.17660988348312,27.72014208115278,28.274544922775842,28.840035821231353,29.416836537655985,30.005173268409102,30.605276733777295,31.21738226845283,31.841729913821879,32.478564512098338,77.298983538794033,78.844963209569912,80.421862473761308,82.030299723236524,83.67090571770126,85.344323832055295,87.051210308696398,88.79223451487033,90.568079205167734,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,{"$f":"BV175+BV176-BV177","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]
[]
[null,null,"Less: Interest - Subordinated"]
[null,null,"Less: Debt Repayment Subordinated"]
[null,null,"Cash Flow After Subordinated Debt"]
[]
[null,null,"Dividends",null,null,null,null,null,{"$f":"I179","v":0},21.857142857142858,22.294285714285714,22.740171428571426,23.194974857142853,23.658874354285718,24.132051841371435,24.614692878198856,25.106986735762835,25.609126470478099,26.121308999887653,26.643735179885411,27.17660988348312,27.72014208115278,28.274544922775842,28.840035821231353,29.416836537655985,30.005173268409102,30.605276733777295,31.21738226845283,31.841729913821879,32.478564512098338,77.298983538794033,78.844963209569912,80.421862473761308,82.030299723236524,83.67090571770126,85.344323832055295,87.051210308696398,88.79223451487033,90.568079205167734,0,{"$f":"AO179","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,{"$f":"BU179","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,{"$f":"DA179","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]
[]
[null,"Ratios"]
[null,null,"Equity Cash Flow",null,null,null,null,null,{"$f":"I185-I75","v":-535.34319256841172},21.857142857142858,22.294285714285714,22.740171428571426,23.194974857142853,23.658874354285718,24.132051841371435,24.614692878198856,25.106986735762835,25.609126470478099,26.121308999887653,26.643735179885411,27.17660988348312,27.72014208115278,28.274544922775842,28.840035821231353,29.416836537655985,30.005173268409102,30.605276733777295,31.21738226845283,31.841729913821879,32.478564512098338,77.298983538794033,78.844963209569912,80.421862473761308,82.030299723236524,83.67090571770126,85.344323832055295,87.051210308696398,88.79223451487033,90.568079205167734,0,{"$f":"AO185-AO75","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,{"$f":"BU185-BU75","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,{"$f":"DA185-DA75","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]
[null,null,"Equity IRR",null,null,{"$f":"IRR(I188:DX188)","v":5.1117331005168909E-2}]
[]
[null,null,"DSCR",null,null,null,null,null,{"$f":"IFERROR(I165/(I167+I168),FALSE)","v":false},1.75,1.75,1.75,1.75,1.75,1.75,1.75,1.75,1.75,1.7499999999999998,1.75,1.75,1.7499999999999998,1.75,1.75,1.75,1.75,1.7500000000000002,1.75,1.7499999999999998,1.75,false,false,false,false,false,false,false,false,false,false,{"$f":"IFERROR(AO165/(AO167+AO168),FALSE)","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,{"$f":"IFERROR(BU165/(BU167+BU168),FALSE)","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,{"$f":"IFERROR(DA165/(DA167+DA168),FALSE)","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]
[]
[null,null,"CFADS for Loan Life",null,null,null,null,null,{"$f":"IF(I35,I165)","v":false},51,52.019999999999996,53.060399999999994,54.121608000000002,55.204040160000005,56.308120963200011,57.43428338246401,58.582969050113292,59.754628431115556,60.949720999737863,62.168715419732621,63.412089728127278,64.680331522689826,65.973938153143621,67.293416916206496,68.63928525453062,70.012070959621241,71.412312378813681,72.840558626389935,74.297369798917742,75.7833171948961,false,false,false,false,false,false,false,false,false,false,{"$f":"IF(AO35,AO165)","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,{"$f":"IF(BU35,BU165)","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,{"$f":"IF(DA35,DA165)","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]
[null,null,"NPV of CFADS",null,null,{"$f":"F137","v":4.4999999999999998E-2},{"$f":"NPV(F194,I193:DX193)","v":813.14941300527926}]
[null,null,"Debt Balance",null,null,null,{"$f":"F41","v":464.65680743158822}]
[null,null,"LLCR",null,null,null,{"$f":"G194/G195","v":1.7499999999999998}]
[]
[null,null,"CFADS for Life",null,null,{"$f":"F194","v":4.4999999999999998E-2},{"$f":"NPV(F198,I198:DX198)","v":1053.3875150694594},null,{"$f":"IF(I5,I165)","v":false},51,52.019999999999996,53.060399999999994,54.121608000000002,55.204040160000005,56.308120963200011,57.43428338246401,58.582969050113292,59.754628431115556,60.949720999737863,62.168715419732621,63.412089728127278,64.680331522689826,65.973938153143621,67.293416916206496,68.63928525453062,70.012070959621241,71.412312378813681,72.840558626389935,74.297369798917742,75.7833171948961,77.298983538794033,78.844963209569912,80.421862473761308,82.030299723236524,83.67090571770126,85.344323832055295,87.051210308696398,88.79223451487033,90.568079205167734,false,{"$f":"IF(AO5,AO165)","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,{"$f":"IF(BU5,BU165)","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,{"$f":"IF(DA5,DA165)","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]
[null,null,"Debt Balance",null,null,null,{"$f":"G195","v":464.65680743158822}]
[null,null,"PLCR",null,null,null,{"$f":"G198/G199","v":2.2670226675298424}]
[]
[null,"Graphs"]
[null,null,null,null,null,null,null,null,{"$f":"I93","v":{"$error":"#N/A"}},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,{"$error":"#N/A"},{"$f":"AO93","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"},{"$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"},{"$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"},{"$f":"BU93","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"},{"$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"},{"$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"},{"$f":"DA93","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"},{"$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"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"Scheduled Debt Service - Senior",null,null,null,null,{"$f":"I167+I168","v":0},29.142857142857142,29.725714285714282,30.320228571428569,30.926633142857145,31.545165805714287,32.176069121828576,32.81959050426515,33.475982314350453,34.145501960637461,34.828411999850211,35.52498023984721,36.235479844644161,36.960189441537047,37.699393230367782,38.453381094975143,39.222448716874638,40.006897691212139,40.807035645036386,41.623176357937105,42.455639885095856,43.304752682797769,0,0,0,0,0,0,0,0,0,0,{"$f":"AO167+AO168","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,{"$f":"BU167+BU168","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,{"$f":"DA167+DA168","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]
[null,null,null,"Scheduled Debt Service - Subordinated"]
[null,null,null,"Sweep",null,null,null,null,{"$f":"I173","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,{"$f":"AO173","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,{"$f":"BU173","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,{"$f":"DA173","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]
[null,null,null,"Repayment of Default",null,null,null,null,{"$f":"I177","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,{"$f":"AO177","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,{"$f":"BU177","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,{"$f":"DA177","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]
[null,null,null,"Default",null,null,null,null,{"$f":"-I176","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,{"$f":"-AO176","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,{"$f":"-BU176","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,{"$f":"-DA176","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]
[null,null,null,"Dividend",null,null,null,null,{"$f":"I185","v":0},{"$f":"J185","v":21.857142857142858},22.294285714285714,22.740171428571426,23.194974857142853,23.658874354285718,24.132051841371435,24.614692878198856,25.106986735762835,25.609126470478099,26.121308999887653,26.643735179885411,27.17660988348312,27.72014208115278,28.274544922775842,28.840035821231353,29.416836537655985,30.005173268409102,30.605276733777295,31.21738226845283,31.841729913821879,32.478564512098338,77.298983538794033,78.844963209569912,80.421862473761308,82.030299723236524,83.67090571770126,85.344323832055295,87.051210308696398,88.79223451487033,90.568079205167734,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,{"$f":"BV185","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]
[]
[null,null,null,"Equity IRR",null,{"$f":"F189","v":5.1117331005168909E-2},"Percent of Cash Flow",null,{"$f":"F109","v":1},"Cash Sweep Percent",null,{"$f":"F171","v":0},"Unpaid Debt at Project Life",null,null,{"$f":"DX136","v":0},"Unpaid Debt at Loan Life"]

{"sheet":"Sheet1","index":6,"n_rows":155,"n_cols":6,"rows_kept":155,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Timing "]
[null,null,"Period"]
[null,null,"Construction Periods",null,"Years",1]
[null,null,"Operating Life",null,"Life",40]
[]
[null,"Operating Cash Flow"]
[null,null,"Inflation Index",null,"%",0.02]
[]
[null,null,"Revenues",null,"Annual Euro",60]
[null,null,"Operating Expense",null,"Annual Euro",10]
[null,null,"Capital Expenditure",null,"One Time",1000]
[]
[null,null,"EBITDA",null,"Euro"]
[null,null,"Free Cash Flow",null,"Euro"]
[null,null,"PIRR",null,"% p.a."]
[]
[null,null,"Opening Balance",null,"Euro"]
[null,null,"Add: Re-Investment",null,"Euro"]
[null,null,"Add: Dividends",null,"Euro"]
[null,null,"Closing Balance",null,"Euro"]
[]
[null,null,"Ending Balance",null,"Euro"]
[null,null,"Investment",null,"Euro"]
[null,null,"Growth Ratio",null,"x"]
[null,null,"Annual Growth",null,"% p.a."]
[]
[null,"Debt Structuring"]
[null,null,"Tenure of Debt",null,"Years",30]
[null,null,"Interest Rate",null,"% p.a.",4.4999999999999998E-2]
[null,null,"DSCR for Sizing",null,"x",1.3]
[]
[null,null,"Flag for Tenure",null,"Flag",{"$f":"F29","v":30}]
[null,null,"CFADS for Tenure",null,"Euro"]
[null,null,"Target Debt Service =CFADS/DSCR",null,"Euro",{"$f":"F31","v":1.3}]
[null,null,"PV of Debt =Debt",null,"Euro",{"$f":"NPV(F30,I35:DX35)","v":0}]
[]
[null,null,"Opening Balance",null,"Euro"]
[null,null,"Add: Debt Draws",null,"Euro",{"$f":"F36","v":0}]
[null,null,"Less: Debt Repayment =DS - Int",null,"Euro"]
[null,null,"Closing Balance",null,"Euro"]
[null,null,"Interest  Opening Balance x Int Rate",null,"Euro",{"$f":"F30","v":4.4999999999999998E-2}]
[]
[null,"Cash Flow Statement"]
[null,null,"Cash Before COD - Uses and Source"]
[null,null,null,"Uses"]
[null,null,null,"Cap Exp","Euro"]
[]
[null,null,null,"Source"]
[null,null,null,"Debt","Euro"]
[null,null,null,"Equity Investment","Euro"]
[null,null,null,"Total"]
[]
[null,null,"Cash Flow After"]
[null,null,null,"EBITDA ","Euro"]
[null,null,null,"Less: Interest","Euro"]
[null,null,null,"Less: Repayment","Euro"]
[null,null,null,"Dividends","Euro"]
[]
[null,"Summary Analysis"]
[]
[null,null,null,"Equity Net Cash Flow","Euro"]
[null,null,null,"Equity IRR",{"$f":"IRR(I62:DX62)","v":{"$error":"#NUM!"}}]
[]
[]
[null,null,null,"Cash Flow","Euro"]
[null,null,null,"Debt Service","Euro"]
[]
[null,null,null,"Equity IRR",{"$f":"E63","v":{"$error":"#NUM!"}},"DSCR"]
[]
[null,null,null,"DSCR"]
[]
[null,"Risk Analysis"]
[null,null,"Scheduled Debt Repayment"]
[]
[null,null,"Volatility",null,"%",0]
[null,null,"Mean Reversion",null,"%",0]
[]
[null,null,"Base Revenue Estimate",null,"Euro",{"$f":"G79/100","v":0}]
[]
[null,null,"Random Number - Probability",null,"%"]
[null,null,"Cash Flow Change Before Volatilty",null,"Factor"]
[null,null,"Cash Flow Change After Volatilty",null,"Factor",{"$f":"F76","v":0}]
[]
[null,null,"Last Period",null,"Index"]
[null,null,"Mean Reversion Adjustment",null,"Index",{"$f":"F77","v":0}]
[]
[null,null,"Random Index",null,"Index",{"$f":"F76","v":0}]
[null,null,"Adjusted Revenue",null,"Euro"]
[null,null,"Operating Expense",null,"Euro"]
[null,null,"Adjusted EBITDA",null,"Euro"]
[]
[null,"Adjusted Debt Schedule"]
[null,null,"Base Debt"]
[null,null,null,"Opening Debt","Euro"]
[null,null,null,"Add: Debt Issue","Euro"]
[null,null,null,"Less: Scheduled","Euro"]
[null,null,null,"Less: Cash Sweep","Euro"]
[null,null,null,"Closing Balance","Euro"]
[null,null,null,"Interest ","Euro",{"$f":"$F$42","v":4.4999999999999998E-2}]
[]
[null,null,"Defaulted Debt"]
[null,null,null,"Opening Balance","Euro"]
[null,null,null,"Add: Default","Euro"]
[null,null,null,"Less: Repayment of Default","Euro"]
[null,null,null,"Closing Balance","Euro"]
[null,null,null,"Interest","Euro",{"$f":"$F$42","v":4.4999999999999998E-2}]
[]
[null,null,null,"Total Interest","Euro"]
[]
[null,"Adjusted Cash Waterfall"]
[null,null,"Adjusted Revenues",null,"Euro"]
[null,null,"Less Operating Expense",null,"Euro"]
[null,null,"EBITDA"]
[]
[null,null,"Less: Interest",null,"Euro"]
[null,null,"Less: Debt Repayment Scheduled",null,"Euro"]
[null,null,"Cash Flow After Scheduled Debt Service",null,"Euro"]
[]
[null,null,"Cash Sweep",null,"%",{"$f":"G120/100","v":0}]
[null,null,"Cash Swept Before Constraint",null,"Euro"]
[null,null,"Cash Swept After Constraint"]
[]
[null,null,"Cash Flow Before Default",null,"Euro"]
[null,null,"Add: Repayment not Made from Default",null,"Euro"]
[null,null,"Less: Repayment of Default",null,"Euro"]
[]
[null,null,"Cash Flow After Sweep",null,"Euro"]
[]
[null,null,"Dividends"]
[]
[null,"Ratios"]
[null,null,"Equity Cash Flow"]
[null,null,"Equity IRR",null,null,{"$f":"IRR(I133:DX133)","v":{"$error":"#NUM!"}}]
[]
[null,null,"DSCR"]
[]
[null,null,"CFADS for Loan Life"]
[null,null,"NPV of CFADS",null,null,{"$f":"F107","v":4.4999999999999998E-2}]
[null,null,"Debt Balance"]
[null,null,"LLCR"]
[]
[null,null,"CFADS for Life",null,null,{"$f":"F139","v":4.4999999999999998E-2}]
[null,null,"Debt Balance"]
[null,null,"PLCR"]
[]
[null,"Graphs"]
[]
[null,null,null,"Scheduled Debt Service"]
[null,null,null,"Sweep"]
[null,null,null,"Repayment of Default"]
[null,null,null,"Default"]
[null,null,null,"Dividend"]
[]
[null,null,null,"Equity IRR",null,{"$f":"F134","v":{"$error":"#NUM!"}}]