{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Issues","Summary","Inputs","Model","Databook","Capital Expenditures","Sources and Uses of Funds","Revenue Forecast and Actual","Source of Historic Data","Historic IS and BS","2000 to 2005","Revenue Forecasts","Share Price","Sheet3","EBITDA to Debt","Actual and Proj Passengers","Chart5","Chart2","Chart7","Chart9"],"not_rendered":{"charts":12,"images":16,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Actual and Proj Passengers","index":15,"reason":"not_a_worksheet"},{"sheet":"Chart5","index":16,"reason":"not_a_worksheet"},{"sheet":"Chart2","index":17,"reason":"not_a_worksheet"},{"sheet":"Chart7","index":18,"reason":"not_a_worksheet"},{"sheet":"Chart9","index":19,"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":"Issues","index":0,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"Not a public penny"]
[]
[null,null,"Analysis of Subsized Financing"]
[]
[null,null,"Alternative Solutions"]

{"sheet":"Summary","index":1,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Operating and Construction Assumptions",null,null,null,null,null,null,"Financial Statistics"]
[]
[null,null,null,null,"Consturction Timing",null,null,null,"Equity IRR",null,{"$f":"Model!I121","v":0.19857941346585162}]
[null,null,null,null,null,null,null,null,"Project IRR",null,{"$f":"Model!I119","v":0.12306370533153554}]
[null,null,null,null,"Construction Cost"]
[null,null,null,null,null,null,null,null,"PLCR",null,{"$f":"Model!I132","v":2.8156861830864828}]
[null,null,null,null,"Revenues",null,null,null,"Min DSCR",null,{"$f":"Model!I126","v":1.3366334279410448}]
[]
[null,null,null,null,"Concession Length",null,null,null,"Debt/EBITDA 1",null,{"$f":"TRANSPOSE(Model!R133:W133)","v":9.0945202045127314}]
[null,null,null,null,null,null,null,null,"Debt/EBITDA 2",null,5.0823524415485313]
[null,null,null,null,"Revenue Senstivity",null,{"$f":"Model!G16","v":1},null,"Debt/EBITDA 3",null,4.8360272152777402]
[null,null,null,null,null,null,null,null,"Debt/EBITDA 4",null,4.3152001713656842]
[null,null,null,null,null,null,null,null,"Debt/EBITDA 5",null,3.7975909222299693]
[null,"Sources and Uses"]
[null,null,"Construction Expenditures",null,null,null,{"$f":"Model!J21","v":3821.0000000000005}]
[null,null,"Interest During Construction",null,null,null,{"$f":"Model!J22","v":507.59473614117428},null,"Debt Repayment"]
[null,null,"Fees",null,null,null,{"$f":"Model!J23","v":0}]
[null,null,"Working Capital",null,null,null,{"$f":"Model!J24","v":0},null,"Debt Tenor",null,{"$f":"Inputs!G50","v":33}]
[null,null,null,"Total",null,null,{"$f":"Model!J25","v":4328.5947361411745}]
[]
[null,null,"Original Debt",null,null,null,{"$f":"Model!J27","v":3558.5947361411741}]
[null,null,"Second Junior Debt Tranche",null,null,null,{"$f":"Model!J28","v":0}]
[null,null,"Senior Debt",null,null,null,{"$f":"Model!J29","v":0}]
[null,null,"Equity",null,null,null,{"$f":"Model!J30","v":770}]
[null,null,null,"Total",null,null,{"$f":"Model!J31","v":4328.5947361411745}]

{"sheet":"Inputs","index":2,"n_rows":73,"n_cols":110,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Timing Assumptions"]
[null,null,"Year",null,null,null,null,null,null,null,1986,{"$f":"K3+1","v":1987},1988,1989,1990,1991,1992,1993,1994,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,{"$f":"BW3+1","v":2051},2052,2053,2054,2055,2056,2057,2058,2059,2060,2061,2062,2063,2064,2065,2066,2067,2068,2069,2070,2071,2072,2073,2074,2075,2076,2077,2078,2079,2080,2081,2082,2083,2084,2085]
[null,null,"General Dates"]
[null,null,null,"Construction Start",null,null,1987]
[null,null,null,"Commercial Operation",null,null,{"$f":"IF(G18=1,1992,1994)","v":1992}]
[]
[null,null,"Construction Period",null,null,null,{"$f":"Inputs!G6-Inputs!G5+1","v":6}]
[null,null,"Period Start",null,null,null,{"$f":"-G8+1","v":-5}]
[]
[null,null,"Concession Period",null,null,null,1]
[null,null,null,null,"55 Years",null,55]
[null,null,null,null,"65 Years",null,65]
[null,null,null,null,"99 Years",null,99]
[null,null,null,null,{"$f":"INDEX(E12:E14,$G$11)","v":"55 Years"},null,{"$f":"INDEX(G12:G14,$G$11)","v":55}]
[]
[null,"Cash Flow"]
[null,null,"S-Curve",null,null,null,1]
[null,null,null,"Original Forecast",null,null,null,null,null,null,null,{"$f":"'Sources and Uses of Funds'!E46","v":0.1},{"$f":"'Sources and Uses of Funds'!F46","v":0.21249999999999999},{"$f":"'Sources and Uses of Funds'!G46","v":0.21249999999999999},{"$f":"'Sources and Uses of Funds'!H46","v":0.21249999999999999},{"$f":"'Sources and Uses of Funds'!I46","v":0.21249999999999999},{"$f":"'Sources and Uses of Funds'!J46","v":0.05},{"$f":"'Sources and Uses of Funds'!K46","v":0},{"$f":"'Sources and Uses of Funds'!L46","v":0}]
[null,null,null,"Actual Schedule",null,null,null,null,null,null,null,{"$f":"'Sources and Uses of Funds'!E43","v":7.7583779217121937E-2},{"$f":"'Sources and Uses of Funds'!F43","v":8.7862573922838638E-2},{"$f":"'Sources and Uses of Funds'!G43","v":0.14235426640382989},{"$f":"'Sources and Uses of Funds'!H43","v":0.18741199662067023},{"$f":"'Sources and Uses of Funds'!I43","v":0.14798648268093495},{"$f":"'Sources and Uses of Funds'!J43","v":0.17431709377640101},{"$f":"'Sources and Uses of Funds'!K43","v":0.11869895803998874},{"$f":"'Sources and Uses of Funds'!L43","v":6.3784849338214586E-2}]
[null,null,null,{"$f":"INDEX(D19:D20,$G$18)","v":"Original Forecast"},null,null,null,null,null,null,null,{"$f":"INDEX(L19:L20,$G$18)","v":0.1},0.21249999999999999,0.21249999999999999,0.21249999999999999,0.21249999999999999,0.05,0,0]
[]
[null,null,null,"Original Budget",null,null,{"$f":"'Capital Expenditures'!L18","v":3821},1]
[null,null,null,"Actual Cost",null,null,{"$f":"'Capital Expenditures'!M18","v":7926}]
[null,null,null,{"$f":"INDEX(D23:D24,$H$23)","v":"Original Budget"},null,null,{"$f":"INDEX(G23:G24,$H$23)","v":3821}]
[]
[null,null,"Revenues"]
[null,null,null,"Original Forecast",null,null,2,null,null,null,null,null,null,null,null,null,null,{"$f":"'Revenue Forecasts'!O21","v":488},{"$f":"'Revenue Forecasts'!P21","v":790},{"$f":"'Revenue Forecasts'!Q21","v":820},{"$f":"'Revenue Forecasts'!R21","v":900},{"$f":"'Revenue Forecasts'!S21","v":1000},{"$f":"'Revenue Forecasts'!T21","v":1080},{"$f":"'Revenue Forecasts'!U21","v":1180},{"$f":"'Revenue Forecasts'!V21","v":1250},{"$f":"'Revenue Forecasts'!W21","v":1370},{"$f":"'Revenue Forecasts'!X21","v":1480},{"$f":"'Revenue Forecasts'!Y21","v":1500},{"$f":"'Revenue Forecasts'!Z21","v":1590},{"$f":"'Revenue Forecasts'!AA21","v":1685.4},{"$f":"'Revenue Forecasts'!AB21","v":1820.2320000000002},{"$f":"AE28*1.05","v":1911.2436000000002},2006.8057800000004,2107.1460690000004,2212.5033724500004,2323.1285410725004,2439.2849681261255,2561.249216532432,2689.3116773590536,2823.7772612270064,2964.9661242883567,3113.2144305027746,3268.8751520279134,3432.318909629309,3603.9348551107746,3784.1315978663133,3973.3381777596292,4172.0050866476104,4380.6053409799915,4599.6356080289916,4829.6173884304417,5071.0982578519643,5324.6531707445629,5590.8858292817913,5870.4301207458811,6163.951626783175,6472.1492081223341,6795.756668528451,7135.5445019548742,7492.3217270526184,7866.9378134052495,8260.2847040755114,8673.2989392792879,{"$f":"BK28*1.05","v":9106.963886243253},9562.3120805554154,10040.427684583186,10542.449068812346,11069.571522252963,11623.050098365613,12204.202603283895,12814.412733448091,13455.133370120497,14127.890038626521,14834.284540557848,15575.998767585741,16354.79870596503,17172.538641263283,18031.165573326449,18932.723851992771,19879.360044592409,20873.328046822029,21916.994449163132,23012.844171621291,24163.486380202357,25371.660699212476,26640.243734173102,27972.255920881758,29370.868716925848,30839.412152772144,32381.382760410754,34000.451898431296,35700.474493352864,37485.498218020512,39359.773128921537,41327.761785367613,{"$f":"CQ28*1.05","v":43394.149874635994},45563.857368367797,47842.050236786192,50234.1527486255,52745.860386056775,55383.153405359619,58152.3110756276,61059.926629408983,64112.922960879434,67318.569108923402,70684.49756436958,74218.722442588056,77929.658564717465,81826.141492953335,85917.448567601008]
[null,null,null,"Original Forecast Slow Growth",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R28","v":488},{"$f":"S28","v":790},{"$f":"T28","v":820},{"$f":"U28","v":900},{"$f":"V28","v":1000},{"$f":"V29*1.01","v":1010},1020.1,1030.3009999999999,1040.60401,1051.0100500999999,1061.5201506009998,1072.1353521070098,1082.8567056280799,1093.6852726843608,1104.6221254112045,1115.6683466653164,1126.8250301319697,1138.0932804332895,1149.4742132376223,1160.9689553699984,1172.5786449236984,1184.3044313729354,1196.1474756866646,1208.1089504435313,1220.1900399479666,1232.3919403474463,1244.7158597509208,1257.1630183484301,1269.7346485319144,1282.4319950172337,1295.2563149674061,1308.2088781170801,1321.2909668982509,1334.5038765672334,1347.8489153329058,1361.3274044862349,1374.9406785310973,{"$f":"BB29*1.01","v":1388.6900853164084},1402.5769861695726,1416.6027560312684,1430.768783591581,1445.0764714274969,1459.5272361417719,1474.1225085031897,1488.8637335882215,1503.7523709241038,1518.7898946333448,1533.9777935796783,1549.317571515475,1564.8107472306299,1580.4588547029362,1596.2634432499656,1612.2260776824653,1628.3483384592901,1644.631821843883,1661.0781400623218,1677.688921462945,1694.4658106775744,1711.4104687843501,1728.5245734721937,1745.8098192069156,1763.2679173989848,1780.9005965729746,1798.7096025387043,1816.6966985640913,1834.8636655497323,1853.2123022052297,1871.7444252272819,1890.4618694795547,{"$f":"CH29*1.01","v":1909.3664881743503},1928.4601530560938,1947.7447545866546,1967.2222021325213,1986.8944241538466,2006.763368395385,2026.8310020793388,2047.0993121001322,2067.5703052211334,2088.2460082733446,2109.128468356078,2130.2197530396388,2151.5219505700352,2173.0371700757355,2194.7675417764931,2216.715217194258,2238.8823693662007,2261.2711930598625,2283.8839049904614,2306.7227440403658,2329.7899714807695,2353.087871195577,2376.6187499075327,2400.3849374066081]
[null,null,null,"Actual Followed by 1.5% Growth",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Revenue Forecasts'!O31","v":0},{"$f":"'Revenue Forecasts'!P31","v":0},{"$f":"'Revenue Forecasts'!Q31","v":304},{"$f":"'Revenue Forecasts'!R31","v":483},{"$f":"'Revenue Forecasts'!S31","v":509},{"$f":"'Revenue Forecasts'!T31","v":641},{"$f":"'Revenue Forecasts'!U31","v":539},{"$f":"'Revenue Forecasts'!V31","v":599},{"$f":"'Revenue Forecasts'!W31","v":564},{"$f":"'Revenue Forecasts'!X31","v":581},{"$f":"'Revenue Forecasts'!Y31","v":584},{"$f":"'Revenue Forecasts'!Z31","v":538},{"$f":"'Revenue Forecasts'!AA31","v":541},{"$f":"'Revenue Forecasts'!AB31","v":568},{"$f":"'Revenue Forecasts'!AC31","v":526},{"$f":"'Revenue Forecasts'!AD31","v":537},{"$f":"'Revenue Forecasts'!AE31","v":555},{"$f":"AH30*1.015","v":563.32499999999993},571.77487499999984,580.35149812499981,589.0567705968748,597.89262215582789,606.86101148816522,615.96392666048769,625.20338556039496,634.58143634380087,644.10015788895782,653.76166025729208,663.56808516115143,673.5216064385686,683.6244305351471,693.87879699317421,704.28697894807181,714.85128363229285,725.57405288677717,736.45766368007878,747.50452863527994,758.71709656480903,770.09785301328111,781.6493208084803,793.37406062060745,805.27467152991653,817.35379160286516,829.61409847690811,842.05830995406166,854.6891846033725,867.50952237242302,880.52216520800926,893.72999768612931,{"$f":"BN30*1.015","v":907.13594765142113},920.74298686619238,934.55413166918515,948.57244364422286,962.80103029888608,977.2430457533693,991.90169143966978,1006.7802168112647,1021.8819200634335,1037.210148864385,1052.7683010973508,1068.559825613811,1084.588222998018,1100.857046342988,1117.3699020381328,1134.1304505687046,1151.1424073272351,1168.4095434371436,1185.9356865887007,1203.7247218875311,1221.780592715844,1240.1073016065816,1258.7089111306802,1277.5895447976404,1296.753387969605,1316.204688789149,1335.9477591209861,1355.9869755078007,1376.3267801404177,1396.9716818425238,1417.9262570701615,1439.1951509262137,{"$f":"CT30*1.015","v":1460.7830781901068},1482.6948243629583,1504.9352467284025,1527.5092754293285,1550.4219145607683,1573.6782432791797,1597.2834169283672,1621.2426681822926,1645.5613082050268,1670.244727828102,1695.2983987455234,1720.727874726706]
[null,null,null,{"$f":"INDEX(D28:D30,$G$28)","v":"Original Forecast Slow Growth"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(R28:R30,$G$28)","v":488},790,820,900,1000,1010,1020.1,1030.3009999999999,1040.60401,1051.0100500999999,1061.5201506009998,1072.1353521070098,1082.8567056280799,1093.6852726843608,1104.6221254112045,1115.6683466653164,1126.8250301319697,1138.0932804332895,1149.4742132376223,1160.9689553699984,1172.5786449236984,1184.3044313729354,1196.1474756866646,1208.1089504435313,1220.1900399479666,1232.3919403474463,1244.7158597509208,1257.1630183484301,1269.7346485319144,1282.4319950172337,1295.2563149674061,1308.2088781170801,{"$f":"INDEX(AX28:AX30,$G$28)","v":1321.2909668982509},1334.5038765672334,1347.8489153329058,1361.3274044862349,1374.9406785310973,1388.6900853164084,1402.5769861695726,1416.6027560312684,1430.768783591581,1445.0764714274969,1459.5272361417719,1474.1225085031897,1488.8637335882215,1503.7523709241038,1518.7898946333448,1533.9777935796783,1549.317571515475,1564.8107472306299,1580.4588547029362,1596.2634432499656,1612.2260776824653,1628.3483384592901,1644.631821843883,1661.0781400623218,1677.688921462945,1694.4658106775744,1711.4104687843501,1728.5245734721937,1745.8098192069156,1763.2679173989848,1780.9005965729746,1798.7096025387043,{"$f":"INDEX(CD28:CD30,$G$28)","v":1816.6966985640913},1834.8636655497323,1853.2123022052297,1871.7444252272819,1890.4618694795547,1909.3664881743503,1928.4601530560938,1947.7447545866546,1967.2222021325213,1986.8944241538466,2006.763368395385,2026.8310020793388,2047.0993121001322,2067.5703052211334,2088.2460082733446,2109.128468356078,2130.2197530396388,2151.5219505700352,2173.0371700757355,2194.7675417764931,2216.715217194258,2238.8823693662007,2261.2711930598625,2283.8839049904614,2306.7227440403658,2329.7899714807695,2353.087871195577,2376.6187499075327,2400.3849374066081]
[]
[null,null,null,"Senstivity",null,null,{"$f":"I33/100","v":1},null,100]
[]
[null,null,"Operating Expenses"]
[null,null,null,"Original Forecast",null,null,null,null,null,null,null,null,null,null,null,null,null,100,{"$f":"R36*1.02","v":102},104.04,106.1208,108.243216,110.40808032000001,112.61624192640001,114.868566764928,117.16593810022657,119.5092568622311,121.89944199947573,124.33743083946524,126.82417945625456,129.36066304537965,131.94787630628724,134.58683383241299,137.27857050906127,140.02414191924251,142.82462475762736,145.6811172527799,148.59473959783551,151.56663438979223,154.59796707758807,157.68992641913982,160.84372494752262,164.06059944647308,167.34181143540255,170.68864766411059,174.1024206173928,177.58446902974066,181.13615841033547,184.75888157854217,188.45405921011303,{"$f":"AX36*1.02","v":192.22314039431529},196.06760320220161,199.98895526624565,203.98873437157056,208.06850905900197,212.22987924018202,216.47447682498566,220.80396636148538,225.22004568871509,229.72444660248939,234.31893553453918,239.00531424522995,243.78542053013456,248.66112894073726,253.63435151955201,258.70703854994304,263.8811793209419,269.15880290736072,274.54197896550795,280.0328185448181,285.63347491571449,291.3461444140288,297.17306730230939,303.1165286483556,309.17885922132274,315.36243640574918,321.66968513386416,328.10307883654144,334.6651404132723,341.35844322153775,348.1856120859685,355.14932432768785,{"$f":"CD36*1.02","v":362.25231081424164},369.49735703052647,376.88730417113703,384.42505025455978,392.11355125965099,399.95582228484403,407.9549387305409,416.11403750515171,424.43631825525478,432.92504462035987,441.5835455127671,450.41521642302246,459.4235207514829,468.61199116651255,477.98423098984279,487.54391560963967,497.29479392183248,507.24068980026914,517.38550359627448,527.73321366819994,538.28787794156392,549.05363550039522,560.0347082104031,571.23540237461111,582.66011042210334,594.3133126305454,606.19957888315628,618.32357046081938]
[null,null,null,"Original Slow Growth",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R36","v":100},102,104.04,106.1208,108.243216,110.40808032000001,112.61624192640001,114.868566764928,117.16593810022657,119.5092568622311,{"$f":"AA37*1.01","v":120.70434943085341},121.91139292516195,123.13050685441357,124.3618119229577,125.60543004218728,126.86148434260916,128.13009918603524,129.41140017789559,130.70551417967454,132.01256932147129,133.33269501468601,134.66602196483288,136.01268218448121,137.37280900632601,138.74653709638926,140.13400246735316,141.5353424920267,142.95069591694696,144.38020287611641,145.82400490487757,147.28224495392635,148.7550674034656,150.24261807750025,151.74504425827527,153.26249470085801,154.79511964786658,156.34307084434525,157.90650155278871,159.48556656831661,161.08042223399977,162.69122645633976,164.31813872090316,{"$f":"BG37*1.01","v":165.9613201081122},167.62093330919333,169.29714264228528,170.99011406870812,172.70001520939522,174.42701536148917,176.17128551510407,177.93299837025512,179.71232835395767,181.50945163749725,183.32454615387223,185.15779161541096,187.00936953156506,188.87946322688072,190.76825785914951,192.67594043774102,194.60269984211843,196.54872684053962,198.51421410894503,200.49935625003448,202.50434981253483,204.52939331066017,206.57468724376676,208.64043411620443,210.72683845736648,212.83410684194016,214.96244791035957,217.11207238946318,219.28319311335781,221.47602504449139,223.69078529493632,225.92769314788569,{"$f":"CM37*1.01","v":228.18697007936456},230.46883978015819,232.77352817795978,235.10126345973939,237.45227609433678,239.82679885528015,242.22506684383296,244.64731751227129,247.09379068739401,249.56472859426793,252.06037588021061,254.58097963901272,257.12678943540283,259.69805732975686,262.29503790305444,264.91798828208499,267.56716816490587,270.24283984655494,272.94526824502049]
[null,null,null,"Actual/1.5%",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Revenue Forecasts'!O35","v":0},{"$f":"'Revenue Forecasts'!P35","v":0},{"$f":"'Revenue Forecasts'!Q35","v":0},{"$f":"'Revenue Forecasts'!R35","v":0},{"$f":"'Revenue Forecasts'!S35","v":233},{"$f":"'Revenue Forecasts'!T35","v":201},{"$f":"'Revenue Forecasts'!U35","v":212},{"$f":"'Revenue Forecasts'!V35","v":186.6},{"$f":"'Revenue Forecasts'!W35","v":138.6},{"$f":"'Revenue Forecasts'!X35","v":129},{"$f":"'Revenue Forecasts'!Y35","v":125},{"$f":"'Revenue Forecasts'!Z35","v":146},{"$f":"'Revenue Forecasts'!AA35","v":126},{"$f":"'Revenue Forecasts'!AB35","v":118},{"$f":"AE38*1.015","v":119.76999999999998},121.56654999999996,123.39004824999995,125.24089897374994,127.11951245835617,129.0263051452315,130.96169972240997,132.92612521824611,134.92001709651979,136.94381735296756,138.99797461326204,141.08294423246096,143.19918839594786,145.34717622188705,147.52738386521534,149.74029462319356,151.98639904254145,154.26619502817957,156.58018795360223,158.92889077290624,161.31282413449983,163.73251649651732,166.18850424396507,168.68133180762453,171.21155178473887,173.77972506150994,176.38642093743258,179.03221725149405,181.71770051026644,184.44346601792043,187.21011800818923,190.01826977831206,{"$f":"BK38*1.015","v":192.86854382498672},195.76157198236149,198.69799556209688,201.67846549552831,204.70364247796121,207.77419711513062,210.89081007185754,214.05417222293539,217.26498480627941,220.52395957837359,223.83181897204918,227.18929625662989,230.59713570047933,234.05609273598648,237.56693412702626,241.13043813893162,244.74739471101557,248.41860563168078,252.14488471615596,255.92705798689826,259.76596385670172,263.66245331455224,267.61739011427051,271.63165096598453,275.7061257304743,279.84171761643137,284.03934338067779,288.29993353138792,292.62443253435873,297.01379902237409,301.46900600770965,305.99104109782525,{"$f":"CQ38*1.015","v":310.58090671429261},315.23962031500696,319.96821461973201,324.76773783902797,329.63925390661336,334.58384271521254,339.60260035594069,344.69663936127978,349.86708895169892,355.11509528597435,360.44182171526393,365.84844904099288,371.33617577660772,376.90621841325679,382.55981168945561]
[null,null,null,{"$f":"INDEX(D36:D38,$G$28)","v":"Original Slow Growth"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(R36:R38,$G$28)","v":100},102,104.04,106.1208,108.243216,110.40808032000001,112.61624192640001,114.868566764928,117.16593810022657,119.5092568622311,120.70434943085341,121.91139292516195,123.13050685441357,124.3618119229577,125.60543004218728,126.86148434260916,128.13009918603524,129.41140017789559,130.70551417967454,132.01256932147129,133.33269501468601,134.66602196483288,136.01268218448121,137.37280900632601,138.74653709638926,140.13400246735316,141.5353424920267,142.95069591694696,144.38020287611641,145.82400490487757,147.28224495392635,148.7550674034656,{"$f":"INDEX(AX36:AX38,$G$28)","v":150.24261807750025},151.74504425827527,153.26249470085801,154.79511964786658,156.34307084434525,157.90650155278871,159.48556656831661,161.08042223399977,162.69122645633976,164.31813872090316,165.9613201081122,167.62093330919333,169.29714264228528,170.99011406870812,172.70001520939522,174.42701536148917,176.17128551510407,177.93299837025512,179.71232835395767,181.50945163749725,183.32454615387223,185.15779161541096,187.00936953156506,188.87946322688072,190.76825785914951,192.67594043774102,194.60269984211843,196.54872684053962,198.51421410894503,200.49935625003448,202.50434981253483,204.52939331066017,{"$f":"INDEX(CD36:CD38,$G$28)","v":206.57468724376676},208.64043411620443,210.72683845736648,212.83410684194016,214.96244791035957,217.11207238946318,219.28319311335781,221.47602504449139,223.69078529493632,225.92769314788569,228.18697007936456,230.46883978015819,232.77352817795978,235.10126345973939,237.45227609433678,239.82679885528015,242.22506684383296,244.64731751227129,247.09379068739401,249.56472859426793,252.06037588021061,254.58097963901272,257.12678943540283,259.69805732975686,262.29503790305444,264.91798828208499,267.56716816490587,270.24283984655494,272.94526824502049]
[]
[]
[null,null,"Income Tax Rate",null,null,null,null,null,null,null,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25]
[]
[null,"Financing"]
[null,null,null,"Original Bank Loan"]
[null,null,null,null,"Commitment",null,5000]
[null,null,null,null,"Front-end Fee",null,{"$f":"7/800+0.0025","v":1.1250000000000001E-2}]
[null,null,null,null,"Credit Spread - Before Completion",null,1.2500000000000001E-2]
[null,null,null,null,"Credit Spread - After Completion",null,0.01]
[null,null,null,null,"Term",null,33]
[]
[null,null,null,"1990 Additional Debt "]
[null,null,null,null,"Commitment and EIB",null,{"$f":"1800+300","v":2100}]
[null,null,null,null,"Front-end Fee",null,2.5000000000000001E-3]
[null,null,null,null,"Credit Spread - Before Completion",null,2.75E-2]
[null,null,null,null,"Credit Spread - After Completion",null,2.2499999999999999E-2]
[null,null,null,null,"Term",null,10]
[]
[null,null,null,"1994 Senior Debt"]
[null,null,null,null,"Commitment ",null,693]
[null,null,null,null,"Front-end Fee",null,1.4999999999999999E-2]
[null,null,null,null,"Credit Spread - Before Completion",null,2.5000000000000001E-2]
[null,null,null,null,"Credit Spread - After Completion",null,2.5000000000000001E-2]
[null,null,null,null,"Term",null,6]
[]
[null,null,null,"LIBOR",null,null,null,null,null,null,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06,0.06]
[]
[null,null,null,"Equity Financing"]
[null,null,null,null,null,"TML and Bank Financing in 1986",null,null,null,null,46]
[null,null,null,null,null,"Institutional Investors - 1986",null,null,null,null,206]
[null,null,null,null,null,"IPO 1997",null,null,null,null,null,770]
[null,null,null,null,null,"1990 Nov IPO (Not Anticipated)",null,null,null,null,null,null,null,null,566]
[null,null,null,null,null,"1994 May IPO (Not Anticipated)",null,null,null,null,null,null,null,null,null,null,null,null,816]

{"sheet":"Model","index":3,"n_rows":169,"n_cols":110,"rows_kept":169,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,"Delay",null,null,null,null,null,"Revenues",null,null,null,null,null,"Equity IRR",{"$f":"I121","v":0.19857941346585162}]
[]
[null,null,null,null,null,null,null,null,"Cost",null,null,null,null,null,"Concession"]
[]
[null,null,"Year",null,null,null,null,null,null,null,1986,{"$f":"K5+1","v":1987},1988,1989,1990,1991,1992,1993,1994,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,{"$f":"AQ5+1","v":2019},2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,{"$f":"BW5+1","v":2051},2052,2053,2054,2055,2056,2057,2058,2059,2060,2061,2062,2063,2064,2065,2066,2067,2068,2069,2070,2071,2072,2073,2074,2075,2076,2077,2078,2079,2080,2081,2082,2083,2084,2085]
[]
[null,null,"Concession Period",null,null,null,null,null,null,null,null,1,{"$f":"L7+1","v":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,{"$f":"AR7+1","v":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,{"$f":"BX7+1","v":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]
[null,null,"Period Counter",null,null,null,null,null,null,null,null,{"$f":"Inputs!G9","v":-5},{"$f":"L8+1","v":-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,{"$f":"AR8+1","v":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,{"$f":"BX8+1","v":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]
[null,null,"Construction Flag",null,null,null,null,null,null,null,null,{"$f":"(L8<1)*1","v":1},1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(AR8<1)*1","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":"(BX8<1)*1","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":"(DD8<1)*1","v":0},0,0]
[null,null,"Operations Flag",null,null,null,null,null,null,null,null,{"$f":"(AND(L8>0,L7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(M8>0,M7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(N8>0,N7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(O8>0,O7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(P8>0,P7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(Q8>0,Q7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(R8>0,R7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(S8>0,S7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(T8>0,T7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(U8>0,U7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(V8>0,V7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(W8>0,W7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(X8>0,X7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(Y8>0,Y7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(Z8>0,Z7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(AA8>0,AA7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(AB8>0,AB7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(AC8>0,AC7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(AD8>0,AD7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(AE8>0,AE7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(AF8>0,AF7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(AG8>0,AG7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(AH8>0,AH7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(AI8>0,AI7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(AJ8>0,AJ7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(AK8>0,AK7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(AL8>0,AL7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(AM8>0,AM7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(AN8>0,AN7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(AO8>0,AO7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(AP8>0,AP7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(AQ8>0,AQ7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(AR8>0,AR7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(AS8>0,AS7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(AT8>0,AT7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(AU8>0,AU7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(AV8>0,AV7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(AW8>0,AW7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(AX8>0,AX7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(AY8>0,AY7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(AZ8>0,AZ7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(BA8>0,BA7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(BB8>0,BB7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(BC8>0,BC7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(BD8>0,BD7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(BE8>0,BE7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(BF8>0,BF7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(BG8>0,BG7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(BH8>0,BH7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(BI8>0,BI7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(BJ8>0,BJ7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(BK8>0,BK7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(BL8>0,BL7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(BM8>0,BM7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(BN8>0,BN7<=Inputs!$G$15))*1","v":1},{"$f":"(AND(BO8>0,BO7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(BP8>0,BP7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(BQ8>0,BQ7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(BR8>0,BR7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(BS8>0,BS7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(BT8>0,BT7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(BU8>0,BU7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(BV8>0,BV7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(BW8>0,BW7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(BX8>0,BX7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(BY8>0,BY7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(BZ8>0,BZ7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(CA8>0,CA7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(CB8>0,CB7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(CC8>0,CC7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(CD8>0,CD7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(CE8>0,CE7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(CF8>0,CF7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(CG8>0,CG7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(CH8>0,CH7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(CI8>0,CI7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(CJ8>0,CJ7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(CK8>0,CK7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(CL8>0,CL7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(CM8>0,CM7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(CN8>0,CN7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(CO8>0,CO7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(CP8>0,CP7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(CQ8>0,CQ7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(CR8>0,CR7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(CS8>0,CS7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(CT8>0,CT7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(CU8>0,CU7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(CV8>0,CV7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(CW8>0,CW7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(CX8>0,CX7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(CY8>0,CY7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(CZ8>0,CZ7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(DA8>0,DA7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(DB8>0,DB7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(DC8>0,DC7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(DD8>0,DD7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(DE8>0,DE7<=Inputs!$G$15))*1","v":0},{"$f":"(AND(DF8>0,DF7<=Inputs!$G$15))*1","v":0}]
[null,null,"Debt Repayment Flag",null,null,null,null,null,null,null,null,{"$f":"(AND(L8>0,L8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(M8>0,M8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(N8>0,N8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(O8>0,O8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(P8>0,P8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(Q8>0,Q8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(R8>0,R8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(S8>0,S8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(T8>0,T8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(U8>0,U8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(V8>0,V8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(W8>0,W8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(X8>0,X8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(Y8>0,Y8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(Z8>0,Z8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(AA8>0,AA8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(AB8>0,AB8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(AC8>0,AC8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(AD8>0,AD8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(AE8>0,AE8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(AF8>0,AF8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(AG8>0,AG8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(AH8>0,AH8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(AI8>0,AI8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(AJ8>0,AJ8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(AK8>0,AK8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(AL8>0,AL8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(AM8>0,AM8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(AN8>0,AN8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(AO8>0,AO8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(AP8>0,AP8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(AQ8>0,AQ8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(AR8>0,AR8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(AS8>0,AS8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(AT8>0,AT8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(AU8>0,AU8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(AV8>0,AV8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(AW8>0,AW8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(AX8>0,AX8<=Inputs!$G$50))*1","v":1},{"$f":"(AND(AY8>0,AY8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(AZ8>0,AZ8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(BA8>0,BA8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(BB8>0,BB8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(BC8>0,BC8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(BD8>0,BD8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(BE8>0,BE8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(BF8>0,BF8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(BG8>0,BG8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(BH8>0,BH8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(BI8>0,BI8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(BJ8>0,BJ8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(BK8>0,BK8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(BL8>0,BL8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(BM8>0,BM8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(BN8>0,BN8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(BO8>0,BO8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(BP8>0,BP8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(BQ8>0,BQ8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(BR8>0,BR8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(BS8>0,BS8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(BT8>0,BT8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(BU8>0,BU8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(BV8>0,BV8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(BW8>0,BW8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(BX8>0,BX8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(BY8>0,BY8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(BZ8>0,BZ8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(CA8>0,CA8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(CB8>0,CB8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(CC8>0,CC8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(CD8>0,CD8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(CE8>0,CE8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(CF8>0,CF8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(CG8>0,CG8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(CH8>0,CH8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(CI8>0,CI8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(CJ8>0,CJ8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(CK8>0,CK8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(CL8>0,CL8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(CM8>0,CM8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(CN8>0,CN8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(CO8>0,CO8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(CP8>0,CP8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(CQ8>0,CQ8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(CR8>0,CR8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(CS8>0,CS8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(CT8>0,CT8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(CU8>0,CU8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(CV8>0,CV8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(CW8>0,CW8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(CX8>0,CX8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(CY8>0,CY8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(CZ8>0,CZ8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(DA8>0,DA8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(DB8>0,DB8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(DC8>0,DC8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(DD8>0,DD8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(DE8>0,DE8<=Inputs!$G$50))*1","v":0},{"$f":"(AND(DF8>0,DF8<=Inputs!$G$50))*1","v":0}]
[]
[null,"Cash Flow"]
[null,null,"Construction Expenditures",null,null,null,null,null,null,{"$f":"SUM(L14:U14)","v":3821.0000000000005},null,{"$f":"Inputs!$G$25*Inputs!L21","v":382.1},{"$f":"Inputs!$G$25*Inputs!M21","v":811.96249999999998},{"$f":"Inputs!$G$25*Inputs!N21","v":811.96249999999998},{"$f":"Inputs!$G$25*Inputs!O21","v":811.96249999999998},{"$f":"Inputs!$G$25*Inputs!P21","v":811.96249999999998},{"$f":"Inputs!$G$25*Inputs!Q21","v":191.05},{"$f":"Inputs!$G$25*Inputs!R21","v":0},{"$f":"Inputs!$G$25*Inputs!S21","v":0},{"$f":"Inputs!$G$25*Inputs!T21","v":0},{"$f":"Inputs!$G$25*Inputs!U21","v":0}]
[]
[null,null,"Sensitivity",null,null,null,{"$f":"Inputs!G33","v":1}]
[null,null,"Revenues",null,null,null,null,null,null,null,null,{"$f":"Inputs!L31*L10*$G$16","v":0},{"$f":"Inputs!M31*M10*$G$16","v":0},{"$f":"Inputs!N31*N10*$G$16","v":0},{"$f":"Inputs!O31*O10*$G$16","v":0},{"$f":"Inputs!P31*P10*$G$16","v":0},{"$f":"Inputs!Q31*Q10*$G$16","v":0},{"$f":"Inputs!R31*R10*$G$16","v":488},{"$f":"Inputs!S31*S10*$G$16","v":790},{"$f":"Inputs!T31*T10*$G$16","v":820},{"$f":"Inputs!U31*U10*$G$16","v":900},{"$f":"Inputs!V31*V10*$G$16","v":1000},{"$f":"Inputs!W31*W10*$G$16","v":1010},{"$f":"Inputs!X31*X10*$G$16","v":1020.1},{"$f":"Inputs!Y31*Y10*$G$16","v":1030.3009999999999},{"$f":"Inputs!Z31*Z10*$G$16","v":1040.60401},{"$f":"Inputs!AA31*AA10*$G$16","v":1051.0100500999999},{"$f":"Inputs!AB31*AB10*$G$16","v":1061.5201506009998},{"$f":"Inputs!AC31*AC10*$G$16","v":1072.1353521070098},{"$f":"Inputs!AD31*AD10*$G$16","v":1082.8567056280799},{"$f":"Inputs!AE31*AE10*$G$16","v":1093.6852726843608},{"$f":"Inputs!AF31*AF10*$G$16","v":1104.6221254112045},{"$f":"Inputs!AG31*AG10*$G$16","v":1115.6683466653164},{"$f":"Inputs!AH31*AH10*$G$16","v":1126.8250301319697},{"$f":"Inputs!AI31*AI10*$G$16","v":1138.0932804332895},{"$f":"Inputs!AJ31*AJ10*$G$16","v":1149.4742132376223},{"$f":"Inputs!AK31*AK10*$G$16","v":1160.9689553699984},{"$f":"Inputs!AL31*AL10*$G$16","v":1172.5786449236984},{"$f":"Inputs!AM31*AM10*$G$16","v":1184.3044313729354},{"$f":"Inputs!AN31*AN10*$G$16","v":1196.1474756866646},{"$f":"Inputs!AO31*AO10*$G$16","v":1208.1089504435313},{"$f":"Inputs!AP31*AP10*$G$16","v":1220.1900399479666},{"$f":"Inputs!AQ31*AQ10*$G$16","v":1232.3919403474463},{"$f":"Inputs!AR31*AR10*$G$16","v":1244.7158597509208},{"$f":"Inputs!AS31*AS10*$G$16","v":1257.1630183484301},{"$f":"Inputs!AT31*AT10*$G$16","v":1269.7346485319144},{"$f":"Inputs!AU31*AU10*$G$16","v":1282.4319950172337},{"$f":"Inputs!AV31*AV10*$G$16","v":1295.2563149674061},{"$f":"Inputs!AW31*AW10*$G$16","v":1308.2088781170801},{"$f":"Inputs!AX31*AX10*$G$16","v":1321.2909668982509},{"$f":"Inputs!AY31*AY10*$G$16","v":1334.5038765672334},{"$f":"Inputs!AZ31*AZ10*$G$16","v":1347.8489153329058},{"$f":"Inputs!BA31*BA10*$G$16","v":1361.3274044862349},{"$f":"Inputs!BB31*BB10*$G$16","v":1374.9406785310973},{"$f":"Inputs!BC31*BC10*$G$16","v":1388.6900853164084},{"$f":"Inputs!BD31*BD10*$G$16","v":1402.5769861695726},{"$f":"Inputs!BE31*BE10*$G$16","v":1416.6027560312684},{"$f":"Inputs!BF31*BF10*$G$16","v":1430.768783591581},{"$f":"Inputs!BG31*BG10*$G$16","v":1445.0764714274969},{"$f":"Inputs!BH31*BH10*$G$16","v":1459.5272361417719},{"$f":"Inputs!BI31*BI10*$G$16","v":1474.1225085031897},{"$f":"Inputs!BJ31*BJ10*$G$16","v":1488.8637335882215},{"$f":"Inputs!BK31*BK10*$G$16","v":1503.7523709241038},{"$f":"Inputs!BL31*BL10*$G$16","v":1518.7898946333448},{"$f":"Inputs!BM31*BM10*$G$16","v":1533.9777935796783},{"$f":"Inputs!BN31*BN10*$G$16","v":1549.317571515475},{"$f":"Inputs!BO31*BO10*$G$16","v":0},{"$f":"Inputs!BP31*BP10*$G$16","v":0},{"$f":"Inputs!BQ31*BQ10*$G$16","v":0},{"$f":"Inputs!BR31*BR10*$G$16","v":0},{"$f":"Inputs!BS31*BS10*$G$16","v":0},{"$f":"Inputs!BT31*BT10*$G$16","v":0},{"$f":"Inputs!BU31*BU10*$G$16","v":0},{"$f":"Inputs!BV31*BV10*$G$16","v":0},{"$f":"Inputs!BW31*BW10*$G$16","v":0},{"$f":"Inputs!BX31*BX10*$G$16","v":0},{"$f":"Inputs!BY31*BY10*$G$16","v":0},{"$f":"Inputs!BZ31*BZ10*$G$16","v":0},{"$f":"Inputs!CA31*CA10*$G$16","v":0},{"$f":"Inputs!CB31*CB10*$G$16","v":0},{"$f":"Inputs!CC31*CC10*$G$16","v":0},{"$f":"Inputs!CD31*CD10*$G$16","v":0},{"$f":"Inputs!CE31*CE10*$G$16","v":0},{"$f":"Inputs!CF31*CF10*$G$16","v":0},{"$f":"Inputs!CG31*CG10*$G$16","v":0},{"$f":"Inputs!CH31*CH10*$G$16","v":0},{"$f":"Inputs!CI31*CI10*$G$16","v":0},{"$f":"Inputs!CJ31*CJ10*$G$16","v":0},{"$f":"Inputs!CK31*CK10*$G$16","v":0},{"$f":"Inputs!CL31*CL10*$G$16","v":0},{"$f":"Inputs!CM31*CM10*$G$16","v":0},{"$f":"Inputs!CN31*CN10*$G$16","v":0},{"$f":"Inputs!CO31*CO10*$G$16","v":0},{"$f":"Inputs!CP31*CP10*$G$16","v":0},{"$f":"Inputs!CQ31*CQ10*$G$16","v":0},{"$f":"Inputs!CR31*CR10*$G$16","v":0},{"$f":"Inputs!CS31*CS10*$G$16","v":0},{"$f":"Inputs!CT31*CT10*$G$16","v":0},{"$f":"Inputs!CU31*CU10*$G$16","v":0},{"$f":"Inputs!CV31*CV10*$G$16","v":0},{"$f":"Inputs!CW31*CW10*$G$16","v":0},{"$f":"Inputs!CX31*CX10*$G$16","v":0},{"$f":"Inputs!CY31*CY10*$G$16","v":0},{"$f":"Inputs!CZ31*CZ10*$G$16","v":0},{"$f":"Inputs!DA31*DA10*$G$16","v":0},{"$f":"Inputs!DB31*DB10*$G$16","v":0},{"$f":"Inputs!DC31*DC10*$G$16","v":0},{"$f":"Inputs!DD31*DD10*$G$16","v":0},{"$f":"Inputs!DE31*DE10*$G$16","v":0},{"$f":"Inputs!DF31*DF10*$G$16","v":0}]
[null,null,"Operating Costs",null,null,null,null,null,null,null,null,{"$f":"Inputs!L39*L10","v":0},{"$f":"Inputs!M39*M10","v":0},{"$f":"Inputs!N39*N10","v":0},{"$f":"Inputs!O39*O10","v":0},{"$f":"Inputs!P39*P10","v":0},{"$f":"Inputs!Q39*Q10","v":0},{"$f":"Inputs!R39*R10","v":100},{"$f":"Inputs!S39*S10","v":102},{"$f":"Inputs!T39*T10","v":104.04},{"$f":"Inputs!U39*U10","v":106.1208},{"$f":"Inputs!V39*V10","v":108.243216},{"$f":"Inputs!W39*W10","v":110.40808032000001},{"$f":"Inputs!X39*X10","v":112.61624192640001},{"$f":"Inputs!Y39*Y10","v":114.868566764928},{"$f":"Inputs!Z39*Z10","v":117.16593810022657},{"$f":"Inputs!AA39*AA10","v":119.5092568622311},{"$f":"Inputs!AB39*AB10","v":120.70434943085341},{"$f":"Inputs!AC39*AC10","v":121.91139292516195},{"$f":"Inputs!AD39*AD10","v":123.13050685441357},{"$f":"Inputs!AE39*AE10","v":124.3618119229577},{"$f":"Inputs!AF39*AF10","v":125.60543004218728},{"$f":"Inputs!AG39*AG10","v":126.86148434260916},{"$f":"Inputs!AH39*AH10","v":128.13009918603524},{"$f":"Inputs!AI39*AI10","v":129.41140017789559},{"$f":"Inputs!AJ39*AJ10","v":130.70551417967454},{"$f":"Inputs!AK39*AK10","v":132.01256932147129},{"$f":"Inputs!AL39*AL10","v":133.33269501468601},{"$f":"Inputs!AM39*AM10","v":134.66602196483288},{"$f":"Inputs!AN39*AN10","v":136.01268218448121},{"$f":"Inputs!AO39*AO10","v":137.37280900632601},{"$f":"Inputs!AP39*AP10","v":138.74653709638926},{"$f":"Inputs!AQ39*AQ10","v":140.13400246735316},{"$f":"Inputs!AR39*AR10","v":141.5353424920267},{"$f":"Inputs!AS39*AS10","v":142.95069591694696},{"$f":"Inputs!AT39*AT10","v":144.38020287611641},{"$f":"Inputs!AU39*AU10","v":145.82400490487757},{"$f":"Inputs!AV39*AV10","v":147.28224495392635},{"$f":"Inputs!AW39*AW10","v":148.7550674034656},{"$f":"Inputs!AX39*AX10","v":150.24261807750025},{"$f":"Inputs!AY39*AY10","v":151.74504425827527},{"$f":"Inputs!AZ39*AZ10","v":153.26249470085801},{"$f":"Inputs!BA39*BA10","v":154.79511964786658},{"$f":"Inputs!BB39*BB10","v":156.34307084434525},{"$f":"Inputs!BC39*BC10","v":157.90650155278871},{"$f":"Inputs!BD39*BD10","v":159.48556656831661},{"$f":"Inputs!BE39*BE10","v":161.08042223399977},{"$f":"Inputs!BF39*BF10","v":162.69122645633976},{"$f":"Inputs!BG39*BG10","v":164.31813872090316},{"$f":"Inputs!BH39*BH10","v":165.9613201081122},{"$f":"Inputs!BI39*BI10","v":167.62093330919333},{"$f":"Inputs!BJ39*BJ10","v":169.29714264228528},{"$f":"Inputs!BK39*BK10","v":170.99011406870812},{"$f":"Inputs!BL39*BL10","v":172.70001520939522},{"$f":"Inputs!BM39*BM10","v":174.42701536148917},{"$f":"Inputs!BN39*BN10","v":176.17128551510407},{"$f":"Inputs!BO39*BO10","v":0},{"$f":"Inputs!BP39*BP10","v":0},{"$f":"Inputs!BQ39*BQ10","v":0},{"$f":"Inputs!BR39*BR10","v":0},{"$f":"Inputs!BS39*BS10","v":0},{"$f":"Inputs!BT39*BT10","v":0},{"$f":"Inputs!BU39*BU10","v":0},{"$f":"Inputs!BV39*BV10","v":0},{"$f":"Inputs!BW39*BW10","v":0},{"$f":"Inputs!BX39*BX10","v":0},{"$f":"Inputs!BY39*BY10","v":0},{"$f":"Inputs!BZ39*BZ10","v":0},{"$f":"Inputs!CA39*CA10","v":0},{"$f":"Inputs!CB39*CB10","v":0},{"$f":"Inputs!CC39*CC10","v":0},{"$f":"Inputs!CD39*CD10","v":0},{"$f":"Inputs!CE39*CE10","v":0},{"$f":"Inputs!CF39*CF10","v":0},{"$f":"Inputs!CG39*CG10","v":0},{"$f":"Inputs!CH39*CH10","v":0},{"$f":"Inputs!CI39*CI10","v":0},{"$f":"Inputs!CJ39*CJ10","v":0},{"$f":"Inputs!CK39*CK10","v":0},{"$f":"Inputs!CL39*CL10","v":0},{"$f":"Inputs!CM39*CM10","v":0},{"$f":"Inputs!CN39*CN10","v":0},{"$f":"Inputs!CO39*CO10","v":0},{"$f":"Inputs!CP39*CP10","v":0},{"$f":"Inputs!CQ39*CQ10","v":0},{"$f":"Inputs!CR39*CR10","v":0},{"$f":"Inputs!CS39*CS10","v":0},{"$f":"Inputs!CT39*CT10","v":0},{"$f":"Inputs!CU39*CU10","v":0},{"$f":"Inputs!CV39*CV10","v":0},{"$f":"Inputs!CW39*CW10","v":0},{"$f":"Inputs!CX39*CX10","v":0},{"$f":"Inputs!CY39*CY10","v":0},{"$f":"Inputs!CZ39*CZ10","v":0},{"$f":"Inputs!DA39*DA10","v":0},{"$f":"Inputs!DB39*DB10","v":0},{"$f":"Inputs!DC39*DC10","v":0},{"$f":"Inputs!DD39*DD10","v":0},{"$f":"Inputs!DE39*DE10","v":0},{"$f":"Inputs!DF39*DF10","v":0}]
[]
[null,"Sources and Uses"]
[null,null,"Construction Expenditures",null,null,null,null,null,null,{"$f":"SUM(L21:DF21)","v":3821.0000000000005},null,{"$f":"L14","v":382.1},811.96249999999998,811.96249999999998,811.96249999999998,811.96249999999998,191.05,0,0,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":"AR14","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":"BX14","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]
[null,null,"Interest During Construction",null,null,null,null,null,null,{"$f":"SUM(L22:DF22)","v":507.59473614117428},null,{"$f":"L61","v":0},{"$f":"M61","v":0},30.744531249999998,91.840791015624987,157.36652961425779,227.64288426129147,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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":"BY61","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]
[null,null,"Fees"]
[null,null,"Working Capital",null,null,null,null,null,null,null,null,{"$f":"L30-L21","v":387.9},{"$f":"-L24","v":-387.9}]
[null,null,null,"Total",null,null,null,null,null,{"$f":"SUM(J21:J23)","v":4328.5947361411745},null,{"$f":"SUM(L21:L24)","v":770},{"$f":"SUM(M21:M24)","v":424.0625},842.70703125,903.80329101562495,969.32902961425771,418.69288426129151,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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(BY21:BY24)","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]
[]
[null,null,"Original Junior Debt",null,null,null,null,null,null,{"$f":"SUM(L27:DF27)","v":3558.5947361411741},{"$f":"J27/$J$31","v":0.82211316906825171},{"$f":"MAX(L25-L30,0)","v":0},{"$f":"MAX(M25-M30,0)","v":424.0625},842.70703125,903.80329101562495,969.32902961425771,418.69288426129151,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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(BY25-BY30,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]
[null,null,"Second Junior Debt Tranche",null,null,null,null,null,null,{"$f":"SUM(L28:DF28)","v":0}]
[null,null,"Senior Debt",null,null,null,null,null,null,{"$f":"SUM(L29:DF29)","v":0}]
[null,null,"Equity",null,null,null,null,null,null,{"$f":"SUM(L30:DF30)","v":770},{"$f":"J30/$J$31","v":0.17788683093174812},{"$f":"Inputs!L71","v":770},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!N72+Inputs!N73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!O72+Inputs!O73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!P72+Inputs!P73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!Q72+Inputs!Q73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!R72+Inputs!R73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!S72+Inputs!S73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!T72+Inputs!T73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!U72+Inputs!U73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!V72+Inputs!V73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!W72+Inputs!W73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!X72+Inputs!X73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!Y72+Inputs!Y73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!Z72+Inputs!Z73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!AA72+Inputs!AA73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!AB72+Inputs!AB73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!AC72+Inputs!AC73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!AD72+Inputs!AD73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!AE72+Inputs!AE73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!AF72+Inputs!AF73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!AG72+Inputs!AG73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!AH72+Inputs!AH73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!AI72+Inputs!AI73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!AJ72+Inputs!AJ73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!AK72+Inputs!AK73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!AL72+Inputs!AL73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!AM72+Inputs!AM73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!AN72+Inputs!AN73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!AO72+Inputs!AO73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!AP72+Inputs!AP73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!AQ72+Inputs!AQ73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!AR72+Inputs!AR73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!AS72+Inputs!AS73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!AT72+Inputs!AT73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!AU72+Inputs!AU73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!AV72+Inputs!AV73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!AW72+Inputs!AW73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!AX72+Inputs!AX73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!AY72+Inputs!AY73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!AZ72+Inputs!AZ73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!BA72+Inputs!BA73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!BB72+Inputs!BB73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!BC72+Inputs!BC73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!BD72+Inputs!BD73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!BE72+Inputs!BE73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!BF72+Inputs!BF73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!BG72+Inputs!BG73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!BH72+Inputs!BH73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!BI72+Inputs!BI73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!BJ72+Inputs!BJ73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!BK72+Inputs!BK73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!BL72+Inputs!BL73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!BM72+Inputs!BM73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!BN72+Inputs!BN73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!BO72+Inputs!BO73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!BP72+Inputs!BP73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!BQ72+Inputs!BQ73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!BR72+Inputs!BR73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!BS72+Inputs!BS73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!BT72+Inputs!BT73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!BU72+Inputs!BU73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!BV72+Inputs!BV73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!BW72+Inputs!BW73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!BX72+Inputs!BX73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!BY72+Inputs!BY73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!BZ72+Inputs!BZ73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!CA72+Inputs!CA73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!CB72+Inputs!CB73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!CC72+Inputs!CC73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!CD72+Inputs!CD73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!CE72+Inputs!CE73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!CF72+Inputs!CF73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!CG72+Inputs!CG73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!CH72+Inputs!CH73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!CI72+Inputs!CI73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!CJ72+Inputs!CJ73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!CK72+Inputs!CK73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!CL72+Inputs!CL73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!CM72+Inputs!CM73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!CN72+Inputs!CN73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!CO72+Inputs!CO73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!CP72+Inputs!CP73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!CQ72+Inputs!CQ73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!CR72+Inputs!CR73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!CS72+Inputs!CS73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!CT72+Inputs!CT73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!CU72+Inputs!CU73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!CV72+Inputs!CV73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!CW72+Inputs!CW73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!CX72+Inputs!CX73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!CY72+Inputs!CY73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!CZ72+Inputs!CZ73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!DA72+Inputs!DA73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!DB72+Inputs!DB73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!DC72+Inputs!DC73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!DD72+Inputs!DD73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!DE72+Inputs!DE73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!DF72+Inputs!DF73,0)","v":0},{"$f":"IF(AND(Inputs!$G$18=2,Inputs!$H$23=2),Inputs!DG72+Inputs!DG73,0)","v":0}]
[null,null,null,"Total",null,null,null,null,null,{"$f":"SUM(J27:J30)","v":4328.5947361411745},null,{"$f":"SUM(L27:L30)","v":770},{"$f":"SUM(M27:M30)","v":424.0625},842.70703125,903.80329101562495,969.32902961425771,418.69288426129151,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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(BY27:BY30)","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]
[]
[null,null,"Difference",null,null,null,null,null,null,null,null,{"$f":"L31-L25","v":0},{"$f":"M31-M25","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":"BY31-BY25","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]
[]
[null,null,"Total Required Debt",null,null,null,null,null,null,null,null,{"$f":"L25-L30","v":0},{"$f":"M25-M30","v":424.0625},842.70703125,903.80329101562495,969.32902961425771,418.69288426129151,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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":"BY25-BY30","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]
[]
[null,"Debt Schedule"]
[null,null,"Total Accumulated Debt"]
[]
[null,null,"Commitment",null,null,null,null,null,null,null,null,{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000},{"$f":"Inputs!$G$46","v":5000}]
[null,null,"Draws",null,null,null,null,null,null,null,null,{"$f":"L27","v":0},{"$f":"M27","v":424.0625},842.70703125,903.80329101562495,969.32902961425771,418.69288426129151,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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":"BY27","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]
[null,null,"Accumulated Draws",null,null,null,null,null,null,null,null,{"$f":"K42+L41","v":0},{"$f":"L42+M41","v":424.0625},1266.76953125,2170.5728222656248,3139.9018518798825,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,{"$f":"BX42+BY41","v":3558.5947361411741},3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741,3558.5947361411741]
[]
[null,null,"Opening Balance",null,null,null,null,null,null,null,null,{"$f":"K47","v":0},{"$f":"L47","v":0},424.0625,1266.76953125,2170.5728222656248,3139.9018518798825,3558.5947361411741,3528.6738393509399,3496.6584797853898,3462.4020450502508,3425.747659883652,3386.5274677553916,3344.5618621781528,3299.6586642105071,3251.6122423851266,3200.2025710319695,3145.1942226840911,3086.3352899518613,3023.3562319283756,2955.9686398432459,2883.863916312157,2806.7118621338918,2724.159164163148,2635.8277773344525,2541.313193427748,2440.1825886475744,2331.9728415327886,2216.1884121199678,2092.2990726482494,1959.7374794135108,1817.8965746523404,1666.1268065578881,1503.7331546968242,1329.9719472054858,1144.0474551897537,945.1082487329204,732.24329782410882,504.47780035168046,260.76871805618202,0,0,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":"BX47","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]
[null,null,"Add: Draws",null,null,null,null,null,null,null,null,{"$f":"L35","v":0},{"$f":"M35","v":424.0625},842.70703125,903.80329101562495,969.32902961425771,418.69288426129151,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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":"BY35","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]
[null,null,{"$f":"\"Less: Repayments \"&INDEX(C63:C65,$G$67)","v":"Less: Repayments Amortising"},null,null,null,null,null,null,null,null,{"$f":"MIN(L67,L44)","v":0},{"$f":"MIN(M67,M44)","v":0},0,0,0,0,29.920896790233947,32.01535956555032,34.256434735138846,36.654385166598573,39.220192128260464,41.965605577238705,44.903197967645397,48.046421825380577,51.409671353157222,55.00834834787824,58.858932732229697,62.979058023485791,67.387592085129796,72.104723531088865,77.152054178265089,82.552697970743651,88.331386828695699,94.514583906704402,101.13060478017371,108.20974711478587,115.78442941282087,123.88933947171833,132.56159323473861,141.84090476117029,151.76976809445225,162.39365186106389,173.76120749133835,185.92449201573206,198.93920645683329,212.86495090881164,227.76549747242839,243.7090822954984,260.76871805618202,0,0,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(BY67,BY44)","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]
[null,null,"Closing Balance",null,null,null,null,null,null,null,null,{"$f":"L44+L45-L46","v":0},424.0625,1266.76953125,2170.5728222656248,3139.9018518798825,3558.5947361411741,3528.6738393509399,3496.6584797853898,3462.4020450502508,3425.747659883652,3386.5274677553916,3344.5618621781528,3299.6586642105071,3251.6122423851266,3200.2025710319695,3145.1942226840911,3086.3352899518613,3023.3562319283756,2955.9686398432459,2883.863916312157,2806.7118621338918,2724.159164163148,2635.8277773344525,2541.313193427748,2440.1825886475744,2331.9728415327886,2216.1884121199678,2092.2990726482494,1959.7374794135108,1817.8965746523404,1666.1268065578881,1503.7331546968242,{"$f":"AR44+AR45-AR46","v":1329.9719472054858},1144.0474551897537,945.1082487329204,732.24329782410882,504.47780035168046,260.76871805618202,0,0,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":"BX44+BX45-BX46","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":"DD44+DD45-DD46","v":0},{"$f":"DE44+DE45-DE46","v":0},{"$f":"DF44+DF45-DF46","v":0}]
[]
[null,null,"Opening Balance",null,null,null,null,null,null,null,null,{"$f":"K50","v":0},{"$f":"L50","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":"BX50","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]
[null,null,"Add: Defaults",null,null,null,null,null,null,null,null,{"$f":"L109","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":"AR109","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":"BX109","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]
[null,null,"Less: Repayment of Default",null,null,null,null,null,null,null,null,null,{"$f":"L50","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":"AR50","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":"BX50","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]
[null,null,"Closing Balance",null,null,null,null,null,null,null,null,{"$f":"L49+L50-L51","v":0},{"$f":"M49+M50-M51","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":"BY49+BY50-BY51","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]
[]
[null,null,"Total Debt",null,null,null,null,null,null,null,null,{"$f":"L52+L47","v":0},{"$f":"M52+M47","v":424.0625},1266.76953125,2170.5728222656248,3139.9018518798825,3558.5947361411741,3528.6738393509399,3496.6584797853898,3462.4020450502508,3425.747659883652,3386.5274677553916,3344.5618621781528,3299.6586642105071,3251.6122423851266,3200.2025710319695,3145.1942226840911,3086.3352899518613,3023.3562319283756,2955.9686398432459,2883.863916312157,2806.7118621338918,2724.159164163148,2635.8277773344525,2541.313193427748,2440.1825886475744,2331.9728415327886,2216.1884121199678,2092.2990726482494,1959.7374794135108,1817.8965746523404,1666.1268065578881,1503.7331546968242,1329.9719472054858,1144.0474551897537,945.1082487329204,732.24329782410882,504.47780035168046,260.76871805618202,0,0,0,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":"BY52+BY47","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]
[]
[null,null,"LIBOR Rate",null,null,null,null,null,null,null,null,{"$f":"Inputs!L66","v":0.06},{"$f":"Inputs!M66","v":0.06},{"$f":"Inputs!N66","v":0.06},{"$f":"Inputs!O66","v":0.06},{"$f":"Inputs!P66","v":0.06},{"$f":"Inputs!Q66","v":0.06},{"$f":"Inputs!R66","v":0.06},{"$f":"Inputs!S66","v":0.06},{"$f":"Inputs!T66","v":0.06},{"$f":"Inputs!U66","v":0.06},{"$f":"Inputs!V66","v":0.06},{"$f":"Inputs!W66","v":0.06},{"$f":"Inputs!X66","v":0.06},{"$f":"Inputs!Y66","v":0.06},{"$f":"Inputs!Z66","v":0.06},{"$f":"Inputs!AA66","v":0.06},{"$f":"Inputs!AB66","v":0.06},{"$f":"Inputs!AC66","v":0.06},{"$f":"Inputs!AD66","v":0.06},{"$f":"Inputs!AE66","v":0.06},{"$f":"Inputs!AF66","v":0.06},{"$f":"Inputs!AG66","v":0.06},{"$f":"Inputs!AH66","v":0.06},{"$f":"Inputs!AI66","v":0.06},{"$f":"Inputs!AJ66","v":0.06},{"$f":"Inputs!AK66","v":0.06},{"$f":"Inputs!AL66","v":0.06},{"$f":"Inputs!AM66","v":0.06},{"$f":"Inputs!AN66","v":0.06},{"$f":"Inputs!AO66","v":0.06},{"$f":"Inputs!AP66","v":0.06},{"$f":"Inputs!AQ66","v":0.06},{"$f":"Inputs!AR66","v":0.06},{"$f":"Inputs!AS66","v":0.06},{"$f":"Inputs!AT66","v":0.06},{"$f":"Inputs!AU66","v":0.06},{"$f":"Inputs!AV66","v":0.06},{"$f":"Inputs!AW66","v":0.06},{"$f":"Inputs!AX66","v":0.06},{"$f":"Inputs!AY66","v":0.06},{"$f":"Inputs!AZ66","v":0.06},{"$f":"Inputs!BA66","v":0.06},{"$f":"Inputs!BB66","v":0.06},{"$f":"Inputs!BC66","v":0.06},{"$f":"Inputs!BD66","v":0.06},{"$f":"Inputs!BE66","v":0.06},{"$f":"Inputs!BF66","v":0.06},{"$f":"Inputs!BG66","v":0.06},{"$f":"Inputs!BH66","v":0.06},{"$f":"Inputs!BI66","v":0.06},{"$f":"Inputs!BJ66","v":0.06},{"$f":"Inputs!BK66","v":0.06},{"$f":"Inputs!BL66","v":0.06},{"$f":"Inputs!BM66","v":0.06},{"$f":"Inputs!BN66","v":0.06},{"$f":"Inputs!BO66","v":0.06},{"$f":"Inputs!BP66","v":0.06},{"$f":"Inputs!BQ66","v":0.06},{"$f":"Inputs!BR66","v":0.06},{"$f":"Inputs!BS66","v":0.06},{"$f":"Inputs!BT66","v":0.06},{"$f":"Inputs!BU66","v":0.06},{"$f":"Inputs!BV66","v":0.06},{"$f":"Inputs!BW66","v":0.06},{"$f":"Inputs!BX66","v":0.06},{"$f":"Inputs!BY66","v":0.06},{"$f":"Inputs!BZ66","v":0.06},{"$f":"Inputs!CA66","v":0.06},{"$f":"Inputs!CB66","v":0.06},{"$f":"Inputs!CC66","v":0.06},{"$f":"Inputs!CD66","v":0.06},{"$f":"Inputs!CE66","v":0.06},{"$f":"Inputs!CF66","v":0.06},{"$f":"Inputs!CG66","v":0.06},{"$f":"Inputs!CH66","v":0.06},{"$f":"Inputs!CI66","v":0.06},{"$f":"Inputs!CJ66","v":0.06},{"$f":"Inputs!CK66","v":0.06},{"$f":"Inputs!CL66","v":0.06},{"$f":"Inputs!CM66","v":0.06},{"$f":"Inputs!CN66","v":0.06},{"$f":"Inputs!CO66","v":0.06},{"$f":"Inputs!CP66","v":0.06},{"$f":"Inputs!CQ66","v":0.06},{"$f":"Inputs!CR66","v":0.06},{"$f":"Inputs!CS66","v":0.06},{"$f":"Inputs!CT66","v":0.06},{"$f":"Inputs!CU66","v":0.06},{"$f":"Inputs!CV66","v":0.06},{"$f":"Inputs!CW66","v":0.06},{"$f":"Inputs!CX66","v":0.06},{"$f":"Inputs!CY66","v":0.06},{"$f":"Inputs!CZ66","v":0.06},{"$f":"Inputs!DA66","v":0.06},{"$f":"Inputs!DB66","v":0.06},{"$f":"Inputs!DC66","v":0.06},{"$f":"Inputs!DD66","v":0.06},{"$f":"Inputs!DE66","v":0.06},{"$f":"Inputs!DF66","v":0.06}]
[null,null,"Credit Spread",null,null,null,null,null,null,null,null,{"$f":"L9*Inputs!$G$48+NOT(L9)*Inputs!$G$49","v":1.2500000000000001E-2},{"$f":"M9*Inputs!$G$48+NOT(M9)*Inputs!$G$49","v":1.2500000000000001E-2},{"$f":"N9*Inputs!$G$48+NOT(N9)*Inputs!$G$49","v":1.2500000000000001E-2},{"$f":"O9*Inputs!$G$48+NOT(O9)*Inputs!$G$49","v":1.2500000000000001E-2},{"$f":"P9*Inputs!$G$48+NOT(P9)*Inputs!$G$49","v":1.2500000000000001E-2},{"$f":"Q9*Inputs!$G$48+NOT(Q9)*Inputs!$G$49","v":1.2500000000000001E-2},{"$f":"R9*Inputs!$G$48+NOT(R9)*Inputs!$G$49","v":0.01},{"$f":"S9*Inputs!$G$48+NOT(S9)*Inputs!$G$49","v":0.01},{"$f":"T9*Inputs!$G$48+NOT(T9)*Inputs!$G$49","v":0.01},{"$f":"U9*Inputs!$G$48+NOT(U9)*Inputs!$G$49","v":0.01},{"$f":"V9*Inputs!$G$48+NOT(V9)*Inputs!$G$49","v":0.01},{"$f":"W9*Inputs!$G$48+NOT(W9)*Inputs!$G$49","v":0.01},{"$f":"X9*Inputs!$G$48+NOT(X9)*Inputs!$G$49","v":0.01},{"$f":"Y9*Inputs!$G$48+NOT(Y9)*Inputs!$G$49","v":0.01},{"$f":"Z9*Inputs!$G$48+NOT(Z9)*Inputs!$G$49","v":0.01},{"$f":"AA9*Inputs!$G$48+NOT(AA9)*Inputs!$G$49","v":0.01},{"$f":"AB9*Inputs!$G$48+NOT(AB9)*Inputs!$G$49","v":0.01},{"$f":"AC9*Inputs!$G$48+NOT(AC9)*Inputs!$G$49","v":0.01},{"$f":"AD9*Inputs!$G$48+NOT(AD9)*Inputs!$G$49","v":0.01},{"$f":"AE9*Inputs!$G$48+NOT(AE9)*Inputs!$G$49","v":0.01},{"$f":"AF9*Inputs!$G$48+NOT(AF9)*Inputs!$G$49","v":0.01},{"$f":"AG9*Inputs!$G$48+NOT(AG9)*Inputs!$G$49","v":0.01},{"$f":"AH9*Inputs!$G$48+NOT(AH9)*Inputs!$G$49","v":0.01},{"$f":"AI9*Inputs!$G$48+NOT(AI9)*Inputs!$G$49","v":0.01},{"$f":"AJ9*Inputs!$G$48+NOT(AJ9)*Inputs!$G$49","v":0.01},{"$f":"AK9*Inputs!$G$48+NOT(AK9)*Inputs!$G$49","v":0.01},{"$f":"AL9*Inputs!$G$48+NOT(AL9)*Inputs!$G$49","v":0.01},{"$f":"AM9*Inputs!$G$48+NOT(AM9)*Inputs!$G$49","v":0.01},{"$f":"AN9*Inputs!$G$48+NOT(AN9)*Inputs!$G$49","v":0.01},{"$f":"AO9*Inputs!$G$48+NOT(AO9)*Inputs!$G$49","v":0.01},{"$f":"AP9*Inputs!$G$48+NOT(AP9)*Inputs!$G$49","v":0.01},{"$f":"AQ9*Inputs!$G$48+NOT(AQ9)*Inputs!$G$49","v":0.01},{"$f":"AR9*Inputs!$G$48+NOT(AR9)*Inputs!$G$49","v":0.01},{"$f":"AS9*Inputs!$G$48+NOT(AS9)*Inputs!$G$49","v":0.01},{"$f":"AT9*Inputs!$G$48+NOT(AT9)*Inputs!$G$49","v":0.01},{"$f":"AU9*Inputs!$G$48+NOT(AU9)*Inputs!$G$49","v":0.01},{"$f":"AV9*Inputs!$G$48+NOT(AV9)*Inputs!$G$49","v":0.01},{"$f":"AW9*Inputs!$G$48+NOT(AW9)*Inputs!$G$49","v":0.01},{"$f":"AX9*Inputs!$G$48+NOT(AX9)*Inputs!$G$49","v":0.01},{"$f":"AY9*Inputs!$G$48+NOT(AY9)*Inputs!$G$49","v":0.01},{"$f":"AZ9*Inputs!$G$48+NOT(AZ9)*Inputs!$G$49","v":0.01},{"$f":"BA9*Inputs!$G$48+NOT(BA9)*Inputs!$G$49","v":0.01},{"$f":"BB9*Inputs!$G$48+NOT(BB9)*Inputs!$G$49","v":0.01},{"$f":"BC9*Inputs!$G$48+NOT(BC9)*Inputs!$G$49","v":0.01},{"$f":"BD9*Inputs!$G$48+NOT(BD9)*Inputs!$G$49","v":0.01},{"$f":"BE9*Inputs!$G$48+NOT(BE9)*Inputs!$G$49","v":0.01},{"$f":"BF9*Inputs!$G$48+NOT(BF9)*Inputs!$G$49","v":0.01},{"$f":"BG9*Inputs!$G$48+NOT(BG9)*Inputs!$G$49","v":0.01},{"$f":"BH9*Inputs!$G$48+NOT(BH9)*Inputs!$G$49","v":0.01},{"$f":"BI9*Inputs!$G$48+NOT(BI9)*Inputs!$G$49","v":0.01},{"$f":"BJ9*Inputs!$G$48+NOT(BJ9)*Inputs!$G$49","v":0.01},{"$f":"BK9*Inputs!$G$48+NOT(BK9)*Inputs!$G$49","v":0.01},{"$f":"BL9*Inputs!$G$48+NOT(BL9)*Inputs!$G$49","v":0.01},{"$f":"BM9*Inputs!$G$48+NOT(BM9)*Inputs!$G$49","v":0.01},{"$f":"BN9*Inputs!$G$48+NOT(BN9)*Inputs!$G$49","v":0.01},{"$f":"BO9*Inputs!$G$48+NOT(BO9)*Inputs!$G$49","v":0.01},{"$f":"BP9*Inputs!$G$48+NOT(BP9)*Inputs!$G$49","v":0.01},{"$f":"BQ9*Inputs!$G$48+NOT(BQ9)*Inputs!$G$49","v":0.01},{"$f":"BR9*Inputs!$G$48+NOT(BR9)*Inputs!$G$49","v":0.01},{"$f":"BS9*Inputs!$G$48+NOT(BS9)*Inputs!$G$49","v":0.01},{"$f":"BT9*Inputs!$G$48+NOT(BT9)*Inputs!$G$49","v":0.01},{"$f":"BU9*Inputs!$G$48+NOT(BU9)*Inputs!$G$49","v":0.01},{"$f":"BV9*Inputs!$G$48+NOT(BV9)*Inputs!$G$49","v":0.01},{"$f":"BW9*Inputs!$G$48+NOT(BW9)*Inputs!$G$49","v":0.01},{"$f":"BX9*Inputs!$G$48+NOT(BX9)*Inputs!$G$49","v":0.01},{"$f":"BY9*Inputs!$G$48+NOT(BY9)*Inputs!$G$49","v":0.01},{"$f":"BZ9*Inputs!$G$48+NOT(BZ9)*Inputs!$G$49","v":0.01},{"$f":"CA9*Inputs!$G$48+NOT(CA9)*Inputs!$G$49","v":0.01},{"$f":"CB9*Inputs!$G$48+NOT(CB9)*Inputs!$G$49","v":0.01},{"$f":"CC9*Inputs!$G$48+NOT(CC9)*Inputs!$G$49","v":0.01},{"$f":"CD9*Inputs!$G$48+NOT(CD9)*Inputs!$G$49","v":0.01},{"$f":"CE9*Inputs!$G$48+NOT(CE9)*Inputs!$G$49","v":0.01},{"$f":"CF9*Inputs!$G$48+NOT(CF9)*Inputs!$G$49","v":0.01},{"$f":"CG9*Inputs!$G$48+NOT(CG9)*Inputs!$G$49","v":0.01},{"$f":"CH9*Inputs!$G$48+NOT(CH9)*Inputs!$G$49","v":0.01},{"$f":"CI9*Inputs!$G$48+NOT(CI9)*Inputs!$G$49","v":0.01},{"$f":"CJ9*Inputs!$G$48+NOT(CJ9)*Inputs!$G$49","v":0.01},{"$f":"CK9*Inputs!$G$48+NOT(CK9)*Inputs!$G$49","v":0.01},{"$f":"CL9*Inputs!$G$48+NOT(CL9)*Inputs!$G$49","v":0.01},{"$f":"CM9*Inputs!$G$48+NOT(CM9)*Inputs!$G$49","v":0.01},{"$f":"CN9*Inputs!$G$48+NOT(CN9)*Inputs!$G$49","v":0.01},{"$f":"CO9*Inputs!$G$48+NOT(CO9)*Inputs!$G$49","v":0.01},{"$f":"CP9*Inputs!$G$48+NOT(CP9)*Inputs!$G$49","v":0.01},{"$f":"CQ9*Inputs!$G$48+NOT(CQ9)*Inputs!$G$49","v":0.01},{"$f":"CR9*Inputs!$G$48+NOT(CR9)*Inputs!$G$49","v":0.01},{"$f":"CS9*Inputs!$G$48+NOT(CS9)*Inputs!$G$49","v":0.01},{"$f":"CT9*Inputs!$G$48+NOT(CT9)*Inputs!$G$49","v":0.01},{"$f":"CU9*Inputs!$G$48+NOT(CU9)*Inputs!$G$49","v":0.01},{"$f":"CV9*Inputs!$G$48+NOT(CV9)*Inputs!$G$49","v":0.01},{"$f":"CW9*Inputs!$G$48+NOT(CW9)*Inputs!$G$49","v":0.01},{"$f":"CX9*Inputs!$G$48+NOT(CX9)*Inputs!$G$49","v":0.01},{"$f":"CY9*Inputs!$G$48+NOT(CY9)*Inputs!$G$49","v":0.01},{"$f":"CZ9*Inputs!$G$48+NOT(CZ9)*Inputs!$G$49","v":0.01},{"$f":"DA9*Inputs!$G$48+NOT(DA9)*Inputs!$G$49","v":0.01},{"$f":"DB9*Inputs!$G$48+NOT(DB9)*Inputs!$G$49","v":0.01},{"$f":"DC9*Inputs!$G$48+NOT(DC9)*Inputs!$G$49","v":0.01},{"$f":"DD9*Inputs!$G$48+NOT(DD9)*Inputs!$G$49","v":0.01},{"$f":"DE9*Inputs!$G$48+NOT(DE9)*Inputs!$G$49","v":0.01},{"$f":"DF9*Inputs!$G$48+NOT(DF9)*Inputs!$G$49","v":0.01}]
[null,null,"Total Rate",null,null,null,null,null,null,null,null,{"$f":"L56+L57","v":7.2499999999999995E-2},{"$f":"M56+M57","v":7.2499999999999995E-2},7.2499999999999995E-2,7.2499999999999995E-2,7.2499999999999995E-2,7.2499999999999995E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,{"$f":"BY56+BY57","v":6.9999999999999993E-2},6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2,6.9999999999999993E-2]
[]
[null,null,"Interst Cost",null,null,null,null,null,null,null,null,{"$f":"L58*L44+L58*L49","v":0},0,30.744531249999998,91.840791015624987,157.36652961425779,227.64288426129147,249.10163152988216,247.00716875456578,244.76609358497726,242.36814315351754,239.8023361918556,237.05692274287739,234.11933035247066,230.97610649473549,227.61285696695884,224.01417997223783,220.16359558788636,216.04347029663026,211.63493623498627,206.9178047890272,201.87047414185096,196.46983034937242,190.69114149142035,184.50794441341165,177.89192353994235,170.8127812053302,163.23809890729518,155.13318884839774,146.46093508537746,137.18162355894574,127.25276022566382,116.62887645905215,{"$f":"AR58*AR44+AR58*AR49","v":105.26132082877768},93.098036304383996,80.083321863282748,66.157577411304416,51.257030847687609,35.313446024617626,18.253810263932738,0,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":"BX58*BX44+BX58*BX49","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]
[null,null,"Interest Captialised",null,null,null,null,null,null,null,null,{"$f":"L60*L9","v":0},0,30.744531249999998,91.840791015624987,157.36652961425779,227.64288426129147,0,0,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":"AR60*AR9","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":"BX60*BX9","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":"DD60*DD9","v":0},0,0]
[]
[null,null,"Equal Installments",null,null,null,null,null,null,null,null,{"$f":"L42/Inputs!$G$50*L11","v":0},{"$f":"M42/Inputs!$G$50*M11","v":0},{"$f":"N42/Inputs!$G$50*N11","v":0},{"$f":"O42/Inputs!$G$50*O11","v":0},{"$f":"P42/Inputs!$G$50*P11","v":0},{"$f":"Q42/Inputs!$G$50*Q11","v":0},{"$f":"R42/Inputs!$G$50*R11","v":107.83620412549013},{"$f":"S42/Inputs!$G$50*S11","v":107.83620412549013},{"$f":"T42/Inputs!$G$50*T11","v":107.83620412549013},{"$f":"U42/Inputs!$G$50*U11","v":107.83620412549013},{"$f":"V42/Inputs!$G$50*V11","v":107.83620412549013},{"$f":"W42/Inputs!$G$50*W11","v":107.83620412549013},{"$f":"X42/Inputs!$G$50*X11","v":107.83620412549013},{"$f":"Y42/Inputs!$G$50*Y11","v":107.83620412549013},{"$f":"Z42/Inputs!$G$50*Z11","v":107.83620412549013},{"$f":"AA42/Inputs!$G$50*AA11","v":107.83620412549013},{"$f":"AB42/Inputs!$G$50*AB11","v":107.83620412549013},{"$f":"AC42/Inputs!$G$50*AC11","v":107.83620412549013},{"$f":"AD42/Inputs!$G$50*AD11","v":107.83620412549013},{"$f":"AE42/Inputs!$G$50*AE11","v":107.83620412549013},{"$f":"AF42/Inputs!$G$50*AF11","v":107.83620412549013},{"$f":"AG42/Inputs!$G$50*AG11","v":107.83620412549013},{"$f":"AH42/Inputs!$G$50*AH11","v":107.83620412549013},{"$f":"AI42/Inputs!$G$50*AI11","v":107.83620412549013},{"$f":"AJ42/Inputs!$G$50*AJ11","v":107.83620412549013},{"$f":"AK42/Inputs!$G$50*AK11","v":107.83620412549013},{"$f":"AL42/Inputs!$G$50*AL11","v":107.83620412549013},{"$f":"AM42/Inputs!$G$50*AM11","v":107.83620412549013},{"$f":"AN42/Inputs!$G$50*AN11","v":107.83620412549013},{"$f":"AO42/Inputs!$G$50*AO11","v":107.83620412549013},{"$f":"AP42/Inputs!$G$50*AP11","v":107.83620412549013},{"$f":"AQ42/Inputs!$G$50*AQ11","v":107.83620412549013},{"$f":"AR42/Inputs!$G$50*AR11","v":107.83620412549013},{"$f":"AS42/Inputs!$G$50*AS11","v":107.83620412549013},{"$f":"AT42/Inputs!$G$50*AT11","v":107.83620412549013},{"$f":"AU42/Inputs!$G$50*AU11","v":107.83620412549013},{"$f":"AV42/Inputs!$G$50*AV11","v":107.83620412549013},{"$f":"AW42/Inputs!$G$50*AW11","v":107.83620412549013},{"$f":"AX42/Inputs!$G$50*AX11","v":107.83620412549013},{"$f":"AY42/Inputs!$G$50*AY11","v":0},{"$f":"AZ42/Inputs!$G$50*AZ11","v":0},{"$f":"BA42/Inputs!$G$50*BA11","v":0},{"$f":"BB42/Inputs!$G$50*BB11","v":0},{"$f":"BC42/Inputs!$G$50*BC11","v":0},{"$f":"BD42/Inputs!$G$50*BD11","v":0},{"$f":"BE42/Inputs!$G$50*BE11","v":0},{"$f":"BF42/Inputs!$G$50*BF11","v":0},{"$f":"BG42/Inputs!$G$50*BG11","v":0},{"$f":"BH42/Inputs!$G$50*BH11","v":0},{"$f":"BI42/Inputs!$G$50*BI11","v":0},{"$f":"BJ42/Inputs!$G$50*BJ11","v":0},{"$f":"BK42/Inputs!$G$50*BK11","v":0},{"$f":"BL42/Inputs!$G$50*BL11","v":0},{"$f":"BM42/Inputs!$G$50*BM11","v":0},{"$f":"BN42/Inputs!$G$50*BN11","v":0},{"$f":"BO42/Inputs!$G$50*BO11","v":0},{"$f":"BP42/Inputs!$G$50*BP11","v":0},{"$f":"BQ42/Inputs!$G$50*BQ11","v":0},{"$f":"BR42/Inputs!$G$50*BR11","v":0},{"$f":"BS42/Inputs!$G$50*BS11","v":0},{"$f":"BT42/Inputs!$G$50*BT11","v":0},{"$f":"BU42/Inputs!$G$50*BU11","v":0},{"$f":"BV42/Inputs!$G$50*BV11","v":0},{"$f":"BW42/Inputs!$G$50*BW11","v":0},{"$f":"BX42/Inputs!$G$50*BX11","v":0},{"$f":"BY42/Inputs!$G$50*BY11","v":0},{"$f":"BZ42/Inputs!$G$50*BZ11","v":0},{"$f":"CA42/Inputs!$G$50*CA11","v":0},{"$f":"CB42/Inputs!$G$50*CB11","v":0},{"$f":"CC42/Inputs!$G$50*CC11","v":0},{"$f":"CD42/Inputs!$G$50*CD11","v":0},{"$f":"CE42/Inputs!$G$50*CE11","v":0},{"$f":"CF42/Inputs!$G$50*CF11","v":0},{"$f":"CG42/Inputs!$G$50*CG11","v":0},{"$f":"CH42/Inputs!$G$50*CH11","v":0},{"$f":"CI42/Inputs!$G$50*CI11","v":0},{"$f":"CJ42/Inputs!$G$50*CJ11","v":0},{"$f":"CK42/Inputs!$G$50*CK11","v":0},{"$f":"CL42/Inputs!$G$50*CL11","v":0},{"$f":"CM42/Inputs!$G$50*CM11","v":0},{"$f":"CN42/Inputs!$G$50*CN11","v":0},{"$f":"CO42/Inputs!$G$50*CO11","v":0},{"$f":"CP42/Inputs!$G$50*CP11","v":0},{"$f":"CQ42/Inputs!$G$50*CQ11","v":0},{"$f":"CR42/Inputs!$G$50*CR11","v":0},{"$f":"CS42/Inputs!$G$50*CS11","v":0},{"$f":"CT42/Inputs!$G$50*CT11","v":0},{"$f":"CU42/Inputs!$G$50*CU11","v":0},{"$f":"CV42/Inputs!$G$50*CV11","v":0},{"$f":"CW42/Inputs!$G$50*CW11","v":0},{"$f":"CX42/Inputs!$G$50*CX11","v":0},{"$f":"CY42/Inputs!$G$50*CY11","v":0},{"$f":"CZ42/Inputs!$G$50*CZ11","v":0},{"$f":"DA42/Inputs!$G$50*DA11","v":0},{"$f":"DB42/Inputs!$G$50*DB11","v":0},{"$f":"DC42/Inputs!$G$50*DC11","v":0},{"$f":"DD42/Inputs!$G$50*DD11","v":0},{"$f":"DE42/Inputs!$G$50*DE11","v":0},{"$f":"DF42/Inputs!$G$50*DF11","v":0}]
[null,null,"Amortising",null,null,null,null,null,null,null,null,{"$f":"IF(L11,PPMT(L58,L8,Inputs!$G$50,-L42))*1","v":0},{"$f":"IF(M11,PPMT(M58,M8,Inputs!$G$50,-M42))*1","v":0},{"$f":"IF(N11,PPMT(N58,N8,Inputs!$G$50,-N42))*1","v":0},{"$f":"IF(O11,PPMT(O58,O8,Inputs!$G$50,-O42))*1","v":0},{"$f":"IF(P11,PPMT(P58,P8,Inputs!$G$50,-P42))*1","v":0},{"$f":"IF(Q11,PPMT(Q58,Q8,Inputs!$G$50,-Q42))*1","v":0},{"$f":"IF(R11,PPMT(R58,R8,Inputs!$G$50,-R42))*1","v":29.920896790233947},{"$f":"IF(S11,PPMT(S58,S8,Inputs!$G$50,-S42))*1","v":32.01535956555032},{"$f":"IF(T11,PPMT(T58,T8,Inputs!$G$50,-T42))*1","v":34.256434735138846},{"$f":"IF(U11,PPMT(U58,U8,Inputs!$G$50,-U42))*1","v":36.654385166598573},{"$f":"IF(V11,PPMT(V58,V8,Inputs!$G$50,-V42))*1","v":39.220192128260464},{"$f":"IF(W11,PPMT(W58,W8,Inputs!$G$50,-W42))*1","v":41.965605577238705},{"$f":"IF(X11,PPMT(X58,X8,Inputs!$G$50,-X42))*1","v":44.903197967645397},{"$f":"IF(Y11,PPMT(Y58,Y8,Inputs!$G$50,-Y42))*1","v":48.046421825380577},{"$f":"IF(Z11,PPMT(Z58,Z8,Inputs!$G$50,-Z42))*1","v":51.409671353157222},{"$f":"IF(AA11,PPMT(AA58,AA8,Inputs!$G$50,-AA42))*1","v":55.00834834787824},{"$f":"IF(AB11,PPMT(AB58,AB8,Inputs!$G$50,-AB42))*1","v":58.858932732229697},{"$f":"IF(AC11,PPMT(AC58,AC8,Inputs!$G$50,-AC42))*1","v":62.979058023485791},{"$f":"IF(AD11,PPMT(AD58,AD8,Inputs!$G$50,-AD42))*1","v":67.387592085129796},{"$f":"IF(AE11,PPMT(AE58,AE8,Inputs!$G$50,-AE42))*1","v":72.104723531088865},{"$f":"IF(AF11,PPMT(AF58,AF8,Inputs!$G$50,-AF42))*1","v":77.152054178265089},{"$f":"IF(AG11,PPMT(AG58,AG8,Inputs!$G$50,-AG42))*1","v":82.552697970743651},{"$f":"IF(AH11,PPMT(AH58,AH8,Inputs!$G$50,-AH42))*1","v":88.331386828695699},{"$f":"IF(AI11,PPMT(AI58,AI8,Inputs!$G$50,-AI42))*1","v":94.514583906704402},{"$f":"IF(AJ11,PPMT(AJ58,AJ8,Inputs!$G$50,-AJ42))*1","v":101.13060478017371},{"$f":"IF(AK11,PPMT(AK58,AK8,Inputs!$G$50,-AK42))*1","v":108.20974711478587},{"$f":"IF(AL11,PPMT(AL58,AL8,Inputs!$G$50,-AL42))*1","v":115.78442941282087},{"$f":"IF(AM11,PPMT(AM58,AM8,Inputs!$G$50,-AM42))*1","v":123.88933947171833},{"$f":"IF(AN11,PPMT(AN58,AN8,Inputs!$G$50,-AN42))*1","v":132.56159323473861},{"$f":"IF(AO11,PPMT(AO58,AO8,Inputs!$G$50,-AO42))*1","v":141.84090476117029},{"$f":"IF(AP11,PPMT(AP58,AP8,Inputs!$G$50,-AP42))*1","v":151.76976809445225},{"$f":"IF(AQ11,PPMT(AQ58,AQ8,Inputs!$G$50,-AQ42))*1","v":162.39365186106389},{"$f":"IF(AR11,PPMT(AR58,AR8,Inputs!$G$50,-AR42))*1","v":173.76120749133835},{"$f":"IF(AS11,PPMT(AS58,AS8,Inputs!$G$50,-AS42))*1","v":185.92449201573206},{"$f":"IF(AT11,PPMT(AT58,AT8,Inputs!$G$50,-AT42))*1","v":198.93920645683329},{"$f":"IF(AU11,PPMT(AU58,AU8,Inputs!$G$50,-AU42))*1","v":212.86495090881164},{"$f":"IF(AV11,PPMT(AV58,AV8,Inputs!$G$50,-AV42))*1","v":227.76549747242839},{"$f":"IF(AW11,PPMT(AW58,AW8,Inputs!$G$50,-AW42))*1","v":243.7090822954984},{"$f":"IF(AX11,PPMT(AX58,AX8,Inputs!$G$50,-AX42))*1","v":260.76871805618327},{"$f":"IF(AY11,PPMT(AY58,AY8,Inputs!$G$50,-AY42))*1","v":0},{"$f":"IF(AZ11,PPMT(AZ58,AZ8,Inputs!$G$50,-AZ42))*1","v":0},{"$f":"IF(BA11,PPMT(BA58,BA8,Inputs!$G$50,-BA42))*1","v":0},{"$f":"IF(BB11,PPMT(BB58,BB8,Inputs!$G$50,-BB42))*1","v":0},{"$f":"IF(BC11,PPMT(BC58,BC8,Inputs!$G$50,-BC42))*1","v":0},{"$f":"IF(BD11,PPMT(BD58,BD8,Inputs!$G$50,-BD42))*1","v":0},{"$f":"IF(BE11,PPMT(BE58,BE8,Inputs!$G$50,-BE42))*1","v":0},{"$f":"IF(BF11,PPMT(BF58,BF8,Inputs!$G$50,-BF42))*1","v":0},{"$f":"IF(BG11,PPMT(BG58,BG8,Inputs!$G$50,-BG42))*1","v":0},{"$f":"IF(BH11,PPMT(BH58,BH8,Inputs!$G$50,-BH42))*1","v":0},{"$f":"IF(BI11,PPMT(BI58,BI8,Inputs!$G$50,-BI42))*1","v":0},{"$f":"IF(BJ11,PPMT(BJ58,BJ8,Inputs!$G$50,-BJ42))*1","v":0},{"$f":"IF(BK11,PPMT(BK58,BK8,Inputs!$G$50,-BK42))*1","v":0},{"$f":"IF(BL11,PPMT(BL58,BL8,Inputs!$G$50,-BL42))*1","v":0},{"$f":"IF(BM11,PPMT(BM58,BM8,Inputs!$G$50,-BM42))*1","v":0},{"$f":"IF(BN11,PPMT(BN58,BN8,Inputs!$G$50,-BN42))*1","v":0},{"$f":"IF(BO11,PPMT(BO58,BO8,Inputs!$G$50,-BO42))*1","v":0},{"$f":"IF(BP11,PPMT(BP58,BP8,Inputs!$G$50,-BP42))*1","v":0},{"$f":"IF(BQ11,PPMT(BQ58,BQ8,Inputs!$G$50,-BQ42))*1","v":0},{"$f":"IF(BR11,PPMT(BR58,BR8,Inputs!$G$50,-BR42))*1","v":0},{"$f":"IF(BS11,PPMT(BS58,BS8,Inputs!$G$50,-BS42))*1","v":0},{"$f":"IF(BT11,PPMT(BT58,BT8,Inputs!$G$50,-BT42))*1","v":0},{"$f":"IF(BU11,PPMT(BU58,BU8,Inputs!$G$50,-BU42))*1","v":0},{"$f":"IF(BV11,PPMT(BV58,BV8,Inputs!$G$50,-BV42))*1","v":0},{"$f":"IF(BW11,PPMT(BW58,BW8,Inputs!$G$50,-BW42))*1","v":0},{"$f":"IF(BX11,PPMT(BX58,BX8,Inputs!$G$50,-BX42))*1","v":0},{"$f":"IF(BY11,PPMT(BY58,BY8,Inputs!$G$50,-BY42))*1","v":0},{"$f":"IF(BZ11,PPMT(BZ58,BZ8,Inputs!$G$50,-BZ42))*1","v":0},{"$f":"IF(CA11,PPMT(CA58,CA8,Inputs!$G$50,-CA42))*1","v":0},{"$f":"IF(CB11,PPMT(CB58,CB8,Inputs!$G$50,-CB42))*1","v":0},{"$f":"IF(CC11,PPMT(CC58,CC8,Inputs!$G$50,-CC42))*1","v":0},{"$f":"IF(CD11,PPMT(CD58,CD8,Inputs!$G$50,-CD42))*1","v":0},{"$f":"IF(CE11,PPMT(CE58,CE8,Inputs!$G$50,-CE42))*1","v":0},{"$f":"IF(CF11,PPMT(CF58,CF8,Inputs!$G$50,-CF42))*1","v":0},{"$f":"IF(CG11,PPMT(CG58,CG8,Inputs!$G$50,-CG42))*1","v":0},{"$f":"IF(CH11,PPMT(CH58,CH8,Inputs!$G$50,-CH42))*1","v":0},{"$f":"IF(CI11,PPMT(CI58,CI8,Inputs!$G$50,-CI42))*1","v":0},{"$f":"IF(CJ11,PPMT(CJ58,CJ8,Inputs!$G$50,-CJ42))*1","v":0},{"$f":"IF(CK11,PPMT(CK58,CK8,Inputs!$G$50,-CK42))*1","v":0},{"$f":"IF(CL11,PPMT(CL58,CL8,Inputs!$G$50,-CL42))*1","v":0},{"$f":"IF(CM11,PPMT(CM58,CM8,Inputs!$G$50,-CM42))*1","v":0},{"$f":"IF(CN11,PPMT(CN58,CN8,Inputs!$G$50,-CN42))*1","v":0},{"$f":"IF(CO11,PPMT(CO58,CO8,Inputs!$G$50,-CO42))*1","v":0},{"$f":"IF(CP11,PPMT(CP58,CP8,Inputs!$G$50,-CP42))*1","v":0},{"$f":"IF(CQ11,PPMT(CQ58,CQ8,Inputs!$G$50,-CQ42))*1","v":0},{"$f":"IF(CR11,PPMT(CR58,CR8,Inputs!$G$50,-CR42))*1","v":0},{"$f":"IF(CS11,PPMT(CS58,CS8,Inputs!$G$50,-CS42))*1","v":0},{"$f":"IF(CT11,PPMT(CT58,CT8,Inputs!$G$50,-CT42))*1","v":0},{"$f":"IF(CU11,PPMT(CU58,CU8,Inputs!$G$50,-CU42))*1","v":0},{"$f":"IF(CV11,PPMT(CV58,CV8,Inputs!$G$50,-CV42))*1","v":0},{"$f":"IF(CW11,PPMT(CW58,CW8,Inputs!$G$50,-CW42))*1","v":0},{"$f":"IF(CX11,PPMT(CX58,CX8,Inputs!$G$50,-CX42))*1","v":0},{"$f":"IF(CY11,PPMT(CY58,CY8,Inputs!$G$50,-CY42))*1","v":0},{"$f":"IF(CZ11,PPMT(CZ58,CZ8,Inputs!$G$50,-CZ42))*1","v":0},{"$f":"IF(DA11,PPMT(DA58,DA8,Inputs!$G$50,-DA42))*1","v":0},{"$f":"IF(DB11,PPMT(DB58,DB8,Inputs!$G$50,-DB42))*1","v":0},{"$f":"IF(DC11,PPMT(DC58,DC8,Inputs!$G$50,-DC42))*1","v":0},{"$f":"IF(DD11,PPMT(DD58,DD8,Inputs!$G$50,-DD42))*1","v":0},{"$f":"IF(DE11,PPMT(DE58,DE8,Inputs!$G$50,-DE42))*1","v":0},{"$f":"IF(DF11,PPMT(DF58,DF8,Inputs!$G$50,-DF42))*1","v":0}]
[null,null,"Cash Sweep",null,null,null,null,null,null,null,null,{"$f":"L104-L106","v":0},{"$f":"M104-M106","v":0},0,0,0,0,123.84920697141192,350.42005405289922,373.07086043009065,433.30872325368534,508.64126647493185,516.57667832166555,524.69875140967054,533.0176756740758,541.54434181843453,550.29039056797183,560.16458480551853,570.31079728273664,580.74387752283349,591.47967259810548,602.53509653919809,613.92820459882466,625.67827270970906,637.80588250031019,650.3330122573276,663.28313425122121,676.68131887011145,690.55434603860215,704.93082443142794,719.84131902751824,735.31848758825856,751.39722668460422,768.11482794141079,785.51114521414797,803.62877346320988,822.51324014461238,842.21320999316765,862.78070413557111,884.27133453643683,906.74455485054204,915.61524609285925,924.57464424759974,933.62363638388751,942.76311844153815,951.99399531976542,961.31718096677491,970.73359847025449,980.24418014876892,989.84986764406835,999.55161201432077,1009.3503738282757,1019.2471232603702,1029.2428401867858,1039.3385142824654,1049.5351451191018,0,0,0,0,0,0,0,0,0,0,{"$f":"BY104-BY106","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]
[]
[null,null,"Debt Repayment Applied",null,null,null,2,null,null,null,null,{"$f":"INDEX(L63:L65,$G$67)","v":0},{"$f":"INDEX(M63:M65,$G$67)","v":0},0,0,0,0,29.920896790233947,32.01535956555032,34.256434735138846,36.654385166598573,39.220192128260464,41.965605577238705,44.903197967645397,48.046421825380577,51.409671353157222,55.00834834787824,58.858932732229697,62.979058023485791,67.387592085129796,72.104723531088865,77.152054178265089,82.552697970743651,88.331386828695699,94.514583906704402,101.13060478017371,108.20974711478587,115.78442941282087,123.88933947171833,132.56159323473861,141.84090476117029,151.76976809445225,162.39365186106389,173.76120749133835,185.92449201573206,198.93920645683329,212.86495090881164,227.76549747242839,243.7090822954984,260.76871805618327,0,0,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":"INDEX(BY63:BY65,$G$67)","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]
[]
[null,"Fixed Assets"]
[]
[null,null,"Opening Balance",null,null,null,null,null,null,null,null,{"$f":"K74","v":0},{"$f":"L74","v":382.1},1194.0625,2036.76953125,2940.5728222656253,3909.901851879883,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,{"$f":"BX74","v":4328.5947361411745},4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745]
[null,null,"Add: Capital Expenditures",null,null,null,null,null,null,null,null,{"$f":"L21","v":382.1},{"$f":"M21","v":811.96249999999998},811.96249999999998,811.96249999999998,811.96249999999998,191.05,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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":"BY21","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]
[null,null,"Add: Interest During Construction",null,null,null,null,null,null,null,null,{"$f":"L22","v":0},{"$f":"M22","v":0},30.744531249999998,91.840791015624987,157.36652961425779,227.64288426129147,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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":"BY22","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]
[null,null,"Closing Balance",null,null,null,null,null,null,null,null,{"$f":"L71+L72+L73","v":382.1},{"$f":"M71+M72+M73","v":1194.0625},2036.76953125,2940.5728222656253,3909.901851879883,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,{"$f":"BY71+BY72+BY73","v":4328.5947361411745},4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745,4328.5947361411745]
[]
[null,null,"Depreciation Rate",null,null,null,null,null,null,null,null,{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2},{"$f":"1/Inputs!$G$15","v":1.8181818181818181E-2}]
[null,null,"Depreciation Expense",null,null,null,null,null,null,null,null,{"$f":"L76*L71*L10","v":0},0,0,0,0,0,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,{"$f":"AR76*AR71*AR10","v":78.701722475294076},78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,0,0,0,0,0,0,0,0,0,{"$f":"BX76*BX71*BX10","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":"DD76*DD71*DD10","v":0},0,0]
[]
[null,null,"Accumulated Depreciation"]
[null,null,"Opening Balance",null,null,null,null,null,null,null,null,{"$f":"K82","v":0},{"$f":"L82","v":0},0,0,0,0,0,78.701722475294076,157.40344495058815,236.10516742588223,314.80688990117631,393.50861237647041,472.21033485176451,550.91205732705862,629.61377980235272,708.31550227764683,787.01722475294093,865.71894722823504,944.42066970352914,1023.1223921788232,1101.8241146541172,1180.5258371294112,1259.2275596047052,1337.9292820799992,1416.6310045552932,1495.3327270305872,1574.0344495058812,1652.7361719811752,1731.4378944564692,1810.1396169317632,1888.8413394070571,1967.5430618823511,2046.2447843576451,2124.9465068329391,2203.6482293082331,2282.3499517835271,2361.0516742588211,2439.7533967341151,2518.4551192094091,2597.1568416847031,2675.8585641599971,2754.560286635291,2833.262009110585,2911.963731585879,2990.665454061173,3069.367176536467,3148.068899011761,3226.770621487055,3305.472343962349,3384.174066437643,3462.875788912937,3541.577511388231,3620.279233863525,3698.9809563388189,3777.6826788141129,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,{"$f":"BX82","v":3856.3844012894069},3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069]
[null,null,"Add: Depreciation Expense",null,null,null,null,null,null,null,null,{"$f":"L77","v":0},{"$f":"M77","v":0},0,0,0,0,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,0,0,0,0,0,0,0,0,0,0,{"$f":"BY77","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]
[null,null,"Closing Balance",null,null,null,null,null,null,null,null,{"$f":"L80+L81","v":0},{"$f":"M80+M81","v":0},0,0,0,0,78.701722475294076,157.40344495058815,236.10516742588223,314.80688990117631,393.50861237647041,472.21033485176451,550.91205732705862,629.61377980235272,708.31550227764683,787.01722475294093,865.71894722823504,944.42066970352914,1023.1223921788232,1101.8241146541172,1180.5258371294112,1259.2275596047052,1337.9292820799992,1416.6310045552932,1495.3327270305872,1574.0344495058812,1652.7361719811752,1731.4378944564692,1810.1396169317632,1888.8413394070571,1967.5430618823511,2046.2447843576451,2124.9465068329391,2203.6482293082331,2282.3499517835271,2361.0516742588211,2439.7533967341151,2518.4551192094091,2597.1568416847031,2675.8585641599971,2754.560286635291,2833.262009110585,2911.963731585879,2990.665454061173,3069.367176536467,3148.068899011761,3226.770621487055,3305.472343962349,3384.174066437643,3462.875788912937,3541.577511388231,3620.279233863525,3698.9809563388189,3777.6826788141129,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,{"$f":"BY80+BY81","v":3856.3844012894069},3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069,3856.3844012894069]
[]
[null,"Profit and Loss"]
[null,null,"Revenues",null,null,null,null,null,null,null,null,{"$f":"L17","v":0},0,0,0,0,0,488,790,820,900,1000,1010,1020.1,1030.3009999999999,1040.60401,1051.0100500999999,1061.5201506009998,1072.1353521070098,1082.8567056280799,1093.6852726843608,1104.6221254112045,1115.6683466653164,1126.8250301319697,1138.0932804332895,1149.4742132376223,1160.9689553699984,1172.5786449236984,1184.3044313729354,1196.1474756866646,1208.1089504435313,1220.1900399479666,1232.3919403474463,{"$f":"AR17","v":1244.7158597509208},1257.1630183484301,1269.7346485319144,1282.4319950172337,1295.2563149674061,1308.2088781170801,1321.2909668982509,1334.5038765672334,1347.8489153329058,1361.3274044862349,1374.9406785310973,1388.6900853164084,1402.5769861695726,1416.6027560312684,1430.768783591581,1445.0764714274969,1459.5272361417719,1474.1225085031897,1488.8637335882215,1503.7523709241038,1518.7898946333448,1533.9777935796783,1549.317571515475,0,0,0,0,0,0,0,0,0,{"$f":"BX17","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]
[null,null,"Operating Cost",null,null,null,null,null,null,null,null,{"$f":"L18","v":0},0,0,0,0,0,100,102,104.04,106.1208,108.243216,110.40808032000001,112.61624192640001,114.868566764928,117.16593810022657,119.5092568622311,120.70434943085341,121.91139292516195,123.13050685441357,124.3618119229577,125.60543004218728,126.86148434260916,128.13009918603524,129.41140017789559,130.70551417967454,132.01256932147129,133.33269501468601,134.66602196483288,136.01268218448121,137.37280900632601,138.74653709638926,140.13400246735316,{"$f":"AR18","v":141.5353424920267},142.95069591694696,144.38020287611641,145.82400490487757,147.28224495392635,148.7550674034656,150.24261807750025,151.74504425827527,153.26249470085801,154.79511964786658,156.34307084434525,157.90650155278871,159.48556656831661,161.08042223399977,162.69122645633976,164.31813872090316,165.9613201081122,167.62093330919333,169.29714264228528,170.99011406870812,172.70001520939522,174.42701536148917,176.17128551510407,0,0,0,0,0,0,0,0,0,{"$f":"BX18","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]
[null,null,null,"EBITDA",null,null,null,null,null,null,null,{"$f":"L85-L86","v":0},{"$f":"M85-M86","v":0},0,0,0,0,388,688,715.96,793.87919999999997,891.75678400000004,899.59191968000005,907.48375807360003,915.43243323507193,923.43807189977349,931.5007932377689,940.81580117014641,950.22395918184782,959.72619877366628,969.32346076140311,979.01669536901716,988.80686232270727,998.6949309459344,1008.6818802553939,1018.7686990579477,1028.9563860485271,1039.2459499090123,1049.6384094081025,1060.1347935021834,1070.7361414372053,1081.4435028515773,1092.2579378800931,1103.180517258894,1114.2123224314832,1125.3544456557979,1136.6079901123562,1147.9740700134798,1159.4538107136145,1171.0483488207506,1182.7588323089581,1194.5864206320477,1206.5322848383682,1218.5976076867521,1230.7835837636196,1243.0914196012559,1255.5223337972686,1268.0775571352412,1280.7583327065938,1293.5659160336597,1306.5015751939964,1319.5665909459362,1332.7622568553957,1346.0898794239497,1359.5507782181892,1373.146286000371,0,0,0,0,0,0,0,0,0,0,{"$f":"BY85-BY86","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]
[null,null,"Less: Depreciation",null,null,null,null,null,null,null,null,{"$f":"L77","v":0},{"$f":"M77","v":0},0,0,0,0,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,78.701722475294076,0,0,0,0,0,0,0,0,0,0,{"$f":"BY77","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]
[null,null,null,"EBIT",null,null,null,null,null,null,null,{"$f":"L87-L88","v":0},{"$f":"M87-M88","v":0},0,0,0,0,309.2982775247059,609.2982775247059,637.25827752470593,715.17747752470586,813.05506152470593,820.89019720470594,828.78203559830592,836.73071075977782,844.73634942447939,852.7990707624748,862.11407869485231,871.52223670655371,881.02447629837218,890.62173828610901,900.31497289372305,910.10513984741317,919.9932084706403,929.98015778009983,940.06697658265364,950.25466357323296,960.54422743371822,970.93668693280836,981.43307102688925,992.03441896191123,1002.7417803762831,1013.556215404799,1024.4787947836001,1035.5105999561893,1046.6527231805039,1057.9062676370622,1069.2723475381858,1080.7520882383205,1092.3466263454566,1104.0571098336641,1115.8846981567538,1127.8305623630743,1139.8958852114581,1152.0818612883256,1164.3896971259619,1176.8206113219746,1189.3758346599473,1202.0566102312998,1214.8641935583657,1227.7998527187024,1240.8648684706423,1254.0605343801017,1267.3881569486557,1280.8490557428952,1294.444563525077,0,0,0,0,0,0,0,0,0,0,{"$f":"BY87-BY88","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]
[null,null,"Less: Interest",null,null,null,null,null,null,null,null,{"$f":"L60-L61","v":0},{"$f":"M60-M61","v":0},0,0,0,0,249.10163152988216,247.00716875456578,244.76609358497726,242.36814315351754,239.8023361918556,237.05692274287739,234.11933035247066,230.97610649473549,227.61285696695884,224.01417997223783,220.16359558788636,216.04347029663026,211.63493623498627,206.9178047890272,201.87047414185096,196.46983034937242,190.69114149142035,184.50794441341165,177.89192353994235,170.8127812053302,163.23809890729518,155.13318884839774,146.46093508537746,137.18162355894574,127.25276022566382,116.62887645905215,105.26132082877768,93.098036304383996,80.083321863282748,66.157577411304416,51.257030847687609,35.313446024617626,18.253810263932738,0,0,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":"BY60-BY61","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]
[null,null,null,"EBT",null,null,null,null,null,null,null,{"$f":"L89-L90","v":0},{"$f":"M89-M90","v":0},0,0,0,0,60.19664599482374,362.29110877014011,392.49218393972865,472.80933437118836,573.25272533285033,583.83327446182852,594.66270524583524,605.7546042650423,617.12349245752057,628.784890790237,641.95048310696598,655.47876640992342,669.38954006338588,683.70393349708183,698.44449875187206,713.63530949804078,729.30206697921994,745.47221336668815,762.17505304271128,779.44188236790274,797.30612852642298,815.80349808441065,834.97213594151185,854.85279540296551,875.48902015061935,896.9273389457469,919.21747395482237,942.41256365180527,966.56940131722115,991.74869022575785,1018.0153166904983,1045.4386422137029,1074.0928160815238,1104.0571098336641,1115.8846981567538,1127.8305623630743,1139.8958852114581,1152.0818612883256,1164.3896971259619,1176.8206113219746,1189.3758346599473,1202.0566102312998,1214.8641935583657,1227.7998527187024,1240.8648684706423,1254.0605343801017,1267.3881569486557,1280.8490557428952,1294.444563525077,0,0,0,0,0,0,0,0,0,0,{"$f":"BY89-BY90","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]
[null,null,"Less: Taxes",null,null,null,null,null,null,null,null,{"$f":"MAX(L91*Inputs!L42,0)","v":0},{"$f":"MAX(M91*Inputs!M42,0)","v":0},{"$f":"MAX(N91*Inputs!N42,0)","v":0},{"$f":"MAX(O91*Inputs!O42,0)","v":0},{"$f":"MAX(P91*Inputs!P42,0)","v":0},{"$f":"MAX(Q91*Inputs!Q42,0)","v":0},{"$f":"MAX(R91*Inputs!R42,0)","v":15.049161498705935},{"$f":"MAX(S91*Inputs!S42,0)","v":90.572777192535028},{"$f":"MAX(T91*Inputs!T42,0)","v":98.123045984932162},{"$f":"MAX(U91*Inputs!U42,0)","v":118.20233359279709},{"$f":"MAX(V91*Inputs!V42,0)","v":143.31318133321258},{"$f":"MAX(W91*Inputs!W42,0)","v":145.95831861545713},{"$f":"MAX(X91*Inputs!X42,0)","v":148.66567631145881},{"$f":"MAX(Y91*Inputs!Y42,0)","v":151.43865106626058},{"$f":"MAX(Z91*Inputs!Z42,0)","v":154.28087311438014},{"$f":"MAX(AA91*Inputs!AA42,0)","v":157.19622269755925},{"$f":"MAX(AB91*Inputs!AB42,0)","v":160.48762077674149},{"$f":"MAX(AC91*Inputs!AC42,0)","v":163.86969160248086},{"$f":"MAX(AD91*Inputs!AD42,0)","v":167.34738501584647},{"$f":"MAX(AE91*Inputs!AE42,0)","v":170.92598337427046},{"$f":"MAX(AF91*Inputs!AF42,0)","v":174.61112468796802},{"$f":"MAX(AG91*Inputs!AG42,0)","v":178.4088273745102},{"$f":"MAX(AH91*Inputs!AH42,0)","v":182.32551674480499},{"$f":"MAX(AI91*Inputs!AI42,0)","v":186.36805334167204},{"$f":"MAX(AJ91*Inputs!AJ42,0)","v":190.54376326067782},{"$f":"MAX(AK91*Inputs!AK42,0)","v":194.86047059197568},{"$f":"MAX(AL91*Inputs!AL42,0)","v":199.32653213160575},{"$f":"MAX(AM91*Inputs!AM42,0)","v":203.95087452110266},{"$f":"MAX(AN91*Inputs!AN42,0)","v":208.74303398537796},{"$f":"MAX(AO91*Inputs!AO42,0)","v":213.71319885074138},{"$f":"MAX(AP91*Inputs!AP42,0)","v":218.87225503765484},{"$f":"MAX(AQ91*Inputs!AQ42,0)","v":224.23183473643672},{"$f":"MAX(AR91*Inputs!AR42,0)","v":229.80436848870559},{"$f":"MAX(AS91*Inputs!AS42,0)","v":235.60314091295132},{"$f":"MAX(AT91*Inputs!AT42,0)","v":241.64235032930529},{"$f":"MAX(AU91*Inputs!AU42,0)","v":247.93717255643946},{"$f":"MAX(AV91*Inputs!AV42,0)","v":254.50382917262456},{"$f":"MAX(AW91*Inputs!AW42,0)","v":261.35966055342573},{"$f":"MAX(AX91*Inputs!AX42,0)","v":268.52320402038094},{"$f":"MAX(AY91*Inputs!AY42,0)","v":276.01427745841602},{"$f":"MAX(AZ91*Inputs!AZ42,0)","v":278.97117453918844},{"$f":"MAX(BA91*Inputs!BA42,0)","v":281.95764059076856},{"$f":"MAX(BB91*Inputs!BB42,0)","v":284.97397130286453},{"$f":"MAX(BC91*Inputs!BC42,0)","v":288.02046532208141},{"$f":"MAX(BD91*Inputs!BD42,0)","v":291.09742428149048},{"$f":"MAX(BE91*Inputs!BE42,0)","v":294.20515283049366},{"$f":"MAX(BF91*Inputs!BF42,0)","v":297.34395866498681},{"$f":"MAX(BG91*Inputs!BG42,0)","v":300.51415255782496},{"$f":"MAX(BH91*Inputs!BH42,0)","v":303.71604838959144},{"$f":"MAX(BI91*Inputs!BI42,0)","v":306.94996317967559},{"$f":"MAX(BJ91*Inputs!BJ42,0)","v":310.21621711766056},{"$f":"MAX(BK91*Inputs!BK42,0)","v":313.51513359502542},{"$f":"MAX(BL91*Inputs!BL42,0)","v":316.84703923716393},{"$f":"MAX(BM91*Inputs!BM42,0)","v":320.2122639357238},{"$f":"MAX(BN91*Inputs!BN42,0)","v":323.61114088126925},{"$f":"MAX(BO91*Inputs!BO42,0)","v":0},{"$f":"MAX(BP91*Inputs!BP42,0)","v":0},{"$f":"MAX(BQ91*Inputs!BQ42,0)","v":0},{"$f":"MAX(BR91*Inputs!BR42,0)","v":0},{"$f":"MAX(BS91*Inputs!BS42,0)","v":0},{"$f":"MAX(BT91*Inputs!BT42,0)","v":0},{"$f":"MAX(BU91*Inputs!BU42,0)","v":0},{"$f":"MAX(BV91*Inputs!BV42,0)","v":0},{"$f":"MAX(BW91*Inputs!BW42,0)","v":0},{"$f":"MAX(BX91*Inputs!BX42,0)","v":0},{"$f":"MAX(BY91*Inputs!BY42,0)","v":0},{"$f":"MAX(BZ91*Inputs!BZ42,0)","v":0},{"$f":"MAX(CA91*Inputs!CA42,0)","v":0},{"$f":"MAX(CB91*Inputs!CB42,0)","v":0},{"$f":"MAX(CC91*Inputs!CC42,0)","v":0},{"$f":"MAX(CD91*Inputs!CD42,0)","v":0},{"$f":"MAX(CE91*Inputs!CE42,0)","v":0},{"$f":"MAX(CF91*Inputs!CF42,0)","v":0},{"$f":"MAX(CG91*Inputs!CG42,0)","v":0},{"$f":"MAX(CH91*Inputs!CH42,0)","v":0},{"$f":"MAX(CI91*Inputs!CI42,0)","v":0},{"$f":"MAX(CJ91*Inputs!CJ42,0)","v":0},{"$f":"MAX(CK91*Inputs!CK42,0)","v":0},{"$f":"MAX(CL91*Inputs!CL42,0)","v":0},{"$f":"MAX(CM91*Inputs!CM42,0)","v":0},{"$f":"MAX(CN91*Inputs!CN42,0)","v":0},{"$f":"MAX(CO91*Inputs!CO42,0)","v":0},{"$f":"MAX(CP91*Inputs!CP42,0)","v":0},{"$f":"MAX(CQ91*Inputs!CQ42,0)","v":0},{"$f":"MAX(CR91*Inputs!CR42,0)","v":0},{"$f":"MAX(CS91*Inputs!CS42,0)","v":0},{"$f":"MAX(CT91*Inputs!CT42,0)","v":0},{"$f":"MAX(CU91*Inputs!CU42,0)","v":0},{"$f":"MAX(CV91*Inputs!CV42,0)","v":0},{"$f":"MAX(CW91*Inputs!CW42,0)","v":0},{"$f":"MAX(CX91*Inputs!CX42,0)","v":0},{"$f":"MAX(CY91*Inputs!CY42,0)","v":0},{"$f":"MAX(CZ91*Inputs!CZ42,0)","v":0},{"$f":"MAX(DA91*Inputs!DA42,0)","v":0},{"$f":"MAX(DB91*Inputs!DB42,0)","v":0},{"$f":"MAX(DC91*Inputs!DC42,0)","v":0},{"$f":"MAX(DD91*Inputs!DD42,0)","v":0},{"$f":"MAX(DE91*Inputs!DE42,0)","v":0},{"$f":"MAX(DF91*Inputs!DF42,0)","v":0}]
[null,null,null,"Earnings",null,null,null,null,null,null,null,{"$f":"L91-L92","v":0},{"$f":"M91-M92","v":0},0,0,0,0,45.147484496117805,271.71833157760511,294.36913795479649,354.60700077839124,429.93954399963775,437.87495584637139,445.99702893437643,454.3159531987817,462.84261934314043,471.58866809267772,481.46286233022448,491.60907480744254,502.04215504753938,512.77795012281138,523.8333740639041,535.22648212353056,546.97655023441496,559.10416002501609,571.63128978203349,584.58141177592711,597.97959639481724,611.85262356330804,626.22910195613395,641.13959655222413,656.61676511296446,672.69550420931023,689.4131054661168,706.80942273885398,724.92705098791589,743.81151766931839,763.51148751787366,784.07898166027712,805.56961206114283,828.04283237524805,836.91352361756526,845.87292177230574,854.92191390859352,864.06139596624416,873.29227284447143,882.61545849148092,892.0318759949605,901.54245767347493,911.14814516877436,920.84988953902678,930.64865135298169,940.54540078507625,950.54111771149178,960.63679180717145,970.83342264380781,0,0,0,0,0,0,0,0,0,0,{"$f":"BY91-BY92","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]
[]
[null,"Cash Flow"]
[null,null,"EBITDA",null,null,null,null,null,null,null,null,{"$f":"L87","v":0},{"$f":"M87","v":0},0,0,0,0,388,688,715.96,793.87919999999997,891.75678400000004,899.59191968000005,907.48375807360003,915.43243323507193,923.43807189977349,931.5007932377689,940.81580117014641,950.22395918184782,959.72619877366628,969.32346076140311,979.01669536901716,988.80686232270727,998.6949309459344,1008.6818802553939,1018.7686990579477,1028.9563860485271,1039.2459499090123,1049.6384094081025,1060.1347935021834,1070.7361414372053,1081.4435028515773,1092.2579378800931,1103.180517258894,1114.2123224314832,1125.3544456557979,1136.6079901123562,1147.9740700134798,1159.4538107136145,1171.0483488207506,1182.7588323089581,1194.5864206320477,1206.5322848383682,1218.5976076867521,1230.7835837636196,1243.0914196012559,1255.5223337972686,1268.0775571352412,1280.7583327065938,1293.5659160336597,1306.5015751939964,1319.5665909459362,1332.7622568553957,1346.0898794239497,1359.5507782181892,1373.146286000371,0,0,0,0,0,0,0,0,0,0,{"$f":"BY87","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]
[null,null,"Less: Taxes",null,null,null,null,null,null,null,null,{"$f":"L92","v":0},{"$f":"M92","v":0},0,0,0,0,15.049161498705935,90.572777192535028,98.123045984932162,118.20233359279709,143.31318133321258,145.95831861545713,148.66567631145881,151.43865106626058,154.28087311438014,157.19622269755925,160.48762077674149,163.86969160248086,167.34738501584647,170.92598337427046,174.61112468796802,178.4088273745102,182.32551674480499,186.36805334167204,190.54376326067782,194.86047059197568,199.32653213160575,203.95087452110266,208.74303398537796,213.71319885074138,218.87225503765484,224.23183473643672,229.80436848870559,235.60314091295132,241.64235032930529,247.93717255643946,254.50382917262456,261.35966055342573,268.52320402038094,276.01427745841602,278.97117453918844,281.95764059076856,284.97397130286453,288.02046532208141,291.09742428149048,294.20515283049366,297.34395866498681,300.51415255782496,303.71604838959144,306.94996317967559,310.21621711766056,313.51513359502542,316.84703923716393,320.2122639357238,323.61114088126925,0,0,0,0,0,0,0,0,0,0,{"$f":"BY92","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]
[null,null,"Less: WC Change",null,null,null,null,null,null,null,null,{"$f":"L24","v":387.9},{"$f":"M24","v":-387.9},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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":"BY24","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]
[null,null,"Operating Cash Flow",null,null,null,null,null,null,null,null,{"$f":"L96-L97-L98","v":-387.9},{"$f":"M96-M97-M98","v":387.9},0,0,0,0,372.95083850129407,597.427222807465,617.83695401506793,675.67686640720285,748.44360266678746,753.63360106454297,758.81808176214122,763.99378216881132,769.15719878539335,774.30457054020962,780.32818039340486,786.35426757936693,792.37881375781978,798.39747738713265,804.40557068104908,810.39803494819705,816.36941420112942,822.31382691372187,828.22493579726995,834.09591545655144,839.91941777740658,845.68753488699986,851.39175951680545,857.02294258646396,862.57124781392235,868.02610314365643,873.37614877018848,878.60918151853195,883.71209532649266,888.67081755591676,893.47024084085524,898.09415016018875,902.52514480036962,906.74455485054204,915.61524609285925,924.57464424759974,933.62363638388751,942.76311844153815,951.99399531976542,961.31718096677491,970.73359847025449,980.24418014876892,989.84986764406835,999.55161201432077,1009.3503738282757,1019.2471232603702,1029.2428401867858,1039.3385142824654,1049.5351451191018,0,0,0,0,0,0,0,0,0,0,{"$f":"BY96-BY97-BY98","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]
[null,null,"Less: Capital Expenditures",null,null,null,null,null,null,null,null,{"$f":"L72","v":382.1},{"$f":"M72","v":811.96249999999998},811.96249999999998,811.96249999999998,811.96249999999998,191.05,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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":"BY72","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]
[null,null,"Less: Interest During Construction",null,null,null,null,null,null,null,null,{"$f":"L73","v":0},{"$f":"M73","v":0},30.744531249999998,91.840791015624987,157.36652961425779,227.64288426129147,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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":"BY73","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]
[null,null,"Add: Equity Issues",null,null,null,null,null,null,null,null,{"$f":"L30","v":770},{"$f":"M30","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":"BY30","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]
[null,null,"Add: Debt Issues",null,null,null,null,null,null,null,null,{"$f":"L27","v":0},{"$f":"M27","v":424.0625},842.70703125,903.80329101562495,969.32902961425771,418.69288426129151,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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":"BY27","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]
[null,null,"Cash Before Interest",null,null,null,null,null,null,null,null,{"$f":"L99-L100-L101+L102+L103","v":0},{"$f":"M99-M100-M101+M102+M103","v":0},0,0,0,0,372.95083850129407,597.427222807465,617.83695401506793,675.67686640720285,748.44360266678746,753.63360106454297,758.81808176214122,763.99378216881132,769.15719878539335,774.30457054020962,780.32818039340486,786.35426757936693,792.37881375781978,798.39747738713265,804.40557068104908,810.39803494819705,816.36941420112942,822.31382691372187,828.22493579726995,834.09591545655144,839.91941777740658,845.68753488699986,851.39175951680545,857.02294258646396,862.57124781392235,868.02610314365643,873.37614877018848,878.60918151853195,883.71209532649266,888.67081755591676,893.47024084085524,898.09415016018875,902.52514480036962,906.74455485054204,915.61524609285925,924.57464424759974,933.62363638388751,942.76311844153815,951.99399531976542,961.31718096677491,970.73359847025449,980.24418014876892,989.84986764406835,999.55161201432077,1009.3503738282757,1019.2471232603702,1029.2428401867858,1039.3385142824654,1049.5351451191018,0,0,0,0,0,0,0,0,0,0,{"$f":"BY99-BY100-BY101+BY102+BY103","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]
[null,null,"Less: Repayment of Default",null,null,null,null,null,null,null,null,{"$f":"L51","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":"AR51","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":"BX51","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]
[null,null,"Less: Interest Expense",null,null,null,null,null,null,null,null,{"$f":"L90","v":0},{"$f":"M90","v":0},0,0,0,0,249.10163152988216,247.00716875456578,244.76609358497726,242.36814315351754,239.8023361918556,237.05692274287739,234.11933035247066,230.97610649473549,227.61285696695884,224.01417997223783,220.16359558788636,216.04347029663026,211.63493623498627,206.9178047890272,201.87047414185096,196.46983034937242,190.69114149142035,184.50794441341165,177.89192353994235,170.8127812053302,163.23809890729518,155.13318884839774,146.46093508537746,137.18162355894574,127.25276022566382,116.62887645905215,105.26132082877768,93.098036304383996,80.083321863282748,66.157577411304416,51.257030847687609,35.313446024617626,18.253810263932738,0,0,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":"BY90","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]
[null,null,"Less: Repayment of Debt",null,null,null,null,null,null,null,null,{"$f":"L46","v":0},0,0,0,0,0,29.920896790233947,32.01535956555032,34.256434735138846,36.654385166598573,39.220192128260464,41.965605577238705,44.903197967645397,48.046421825380577,51.409671353157222,55.00834834787824,58.858932732229697,62.979058023485791,67.387592085129796,72.104723531088865,77.152054178265089,82.552697970743651,88.331386828695699,94.514583906704402,101.13060478017371,108.20974711478587,115.78442941282087,123.88933947171833,132.56159323473861,141.84090476117029,151.76976809445225,162.39365186106389,{"$f":"AR46","v":173.76120749133835},185.92449201573206,198.93920645683329,212.86495090881164,227.76549747242839,243.7090822954984,260.76871805618202,0,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":"BX46","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]
[null,null,"Cash After Interest",null,null,null,null,null,null,null,null,{"$f":"L104-L106-L107-L105","v":0},{"$f":"M104-M106-M107-M105","v":0},0,0,0,0,93.928310181177977,318.40469448734888,338.81442569495181,396.65433808708678,469.42107434667139,474.61107274442685,479.79555344202515,484.97125384869526,490.13467046527728,495.28204222009356,501.30565207328885,507.33173925925087,513.35628543770372,519.37494906701659,525.38304236093302,531.37550662808098,537.34688588101335,543.2912985936058,549.20240747715388,555.07338713643537,560.89688945729063,566.66500656688379,572.36923119668927,578.00041426634789,583.54871949380629,589.00357482354036,594.35362045007241,599.58665319841589,604.68956700637659,609.6482892358008,614.44771252073929,619.07162184007268,623.5026164802548,906.74455485054204,915.61524609285925,924.57464424759974,933.62363638388751,942.76311844153815,951.99399531976542,961.31718096677491,970.73359847025449,980.24418014876892,989.84986764406835,999.55161201432077,1009.3503738282757,1019.2471232603702,1029.2428401867858,1039.3385142824654,1049.5351451191018,0,0,0,0,0,0,0,0,0,0,{"$f":"BY104-BY106-BY107-BY105","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]
[null,null,"Add: Default on Debt",null,null,null,null,null,null,null,null,{"$f":"MAX(-L108,0)","v":0},{"$f":"MAX(-M108,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(-BY108,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]
[null,null,"Cash After Default",null,null,null,null,null,null,null,null,{"$f":"L108+L109","v":0},{"$f":"M108+M109","v":0},0,0,0,0,93.928310181177977,318.40469448734888,338.81442569495181,396.65433808708678,469.42107434667139,474.61107274442685,479.79555344202515,484.97125384869526,490.13467046527728,495.28204222009356,501.30565207328885,507.33173925925087,513.35628543770372,519.37494906701659,525.38304236093302,531.37550662808098,537.34688588101335,543.2912985936058,549.20240747715388,555.07338713643537,560.89688945729063,566.66500656688379,572.36923119668927,578.00041426634789,583.54871949380629,589.00357482354036,594.35362045007241,599.58665319841589,604.68956700637659,609.6482892358008,614.44771252073929,619.07162184007268,623.5026164802548,906.74455485054204,915.61524609285925,924.57464424759974,933.62363638388751,942.76311844153815,951.99399531976542,961.31718096677491,970.73359847025449,980.24418014876892,989.84986764406835,999.55161201432077,1009.3503738282757,1019.2471232603702,1029.2428401867858,1039.3385142824654,1049.5351451191018,0,0,0,0,0,0,0,0,0,0,{"$f":"BY108+BY109","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]
[null,null,"Cash to Equity",null,null,null,null,null,null,null,null,{"$f":"L110","v":0},{"$f":"M110","v":0},0,0,0,0,93.928310181177977,318.40469448734888,338.81442569495181,396.65433808708678,469.42107434667139,474.61107274442685,479.79555344202515,484.97125384869526,490.13467046527728,495.28204222009356,501.30565207328885,507.33173925925087,513.35628543770372,519.37494906701659,525.38304236093302,531.37550662808098,537.34688588101335,543.2912985936058,549.20240747715388,555.07338713643537,560.89688945729063,566.66500656688379,572.36923119668927,578.00041426634789,583.54871949380629,589.00357482354036,594.35362045007241,599.58665319841589,604.68956700637659,609.6482892358008,614.44771252073929,619.07162184007268,623.5026164802548,906.74455485054204,915.61524609285925,924.57464424759974,933.62363638388751,942.76311844153815,951.99399531976542,961.31718096677491,970.73359847025449,980.24418014876892,989.84986764406835,999.55161201432077,1009.3503738282757,1019.2471232603702,1029.2428401867858,1039.3385142824654,1049.5351451191018,0,0,0,0,0,0,0,0,0,0,{"$f":"BY110","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]
[]
[null,null,"Free Cash"]
[null,null,null,"EBITDA",null,null,null,null,null,null,null,{"$f":"L96","v":0},{"$f":"M96","v":0},0,0,0,0,388,688,715.96,793.87919999999997,891.75678400000004,899.59191968000005,907.48375807360003,915.43243323507193,923.43807189977349,931.5007932377689,940.81580117014641,950.22395918184782,959.72619877366628,969.32346076140311,979.01669536901716,988.80686232270727,998.6949309459344,1008.6818802553939,1018.7686990579477,1028.9563860485271,1039.2459499090123,1049.6384094081025,1060.1347935021834,1070.7361414372053,1081.4435028515773,1092.2579378800931,1103.180517258894,1114.2123224314832,1125.3544456557979,1136.6079901123562,1147.9740700134798,1159.4538107136145,1171.0483488207506,1182.7588323089581,1194.5864206320477,1206.5322848383682,1218.5976076867521,1230.7835837636196,1243.0914196012559,1255.5223337972686,1268.0775571352412,1280.7583327065938,1293.5659160336597,1306.5015751939964,1319.5665909459362,1332.7622568553957,1346.0898794239497,1359.5507782181892,1373.146286000371,0,0,0,0,0,0,0,0,0,0,{"$f":"BY96","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]
[null,null,null,"Cap Exp",null,null,null,null,null,null,null,{"$f":"L100","v":382.1},{"$f":"M100","v":811.96249999999998},811.96249999999998,811.96249999999998,811.96249999999998,191.05,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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":"BY100","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]
[null,null,null,"Taxes on EBIT",null,null,null,null,null,null,null,{"$f":"(L114-L77)*Inputs!L42","v":0},{"$f":"(M114-M77)*Inputs!M42","v":0},{"$f":"(N114-N77)*Inputs!N42","v":0},{"$f":"(O114-O77)*Inputs!O42","v":0},{"$f":"(P114-P77)*Inputs!P42","v":0},{"$f":"(Q114-Q77)*Inputs!Q42","v":0},{"$f":"(R114-R77)*Inputs!R42","v":77.324569381176474},{"$f":"(S114-S77)*Inputs!S42","v":152.32456938117647},{"$f":"(T114-T77)*Inputs!T42","v":159.31456938117648},{"$f":"(U114-U77)*Inputs!U42","v":178.79436938117647},{"$f":"(V114-V77)*Inputs!V42","v":203.26376538117648},{"$f":"(W114-W77)*Inputs!W42","v":205.22254930117649},{"$f":"(X114-X77)*Inputs!X42","v":207.19550889957648},{"$f":"(Y114-Y77)*Inputs!Y42","v":209.18267768994446},{"$f":"(Z114-Z77)*Inputs!Z42","v":211.18408735611985},{"$f":"(AA114-AA77)*Inputs!AA42","v":213.1997676906187},{"$f":"(AB114-AB77)*Inputs!AB42","v":215.52851967371308},{"$f":"(AC114-AC77)*Inputs!AC42","v":217.88055917663843},{"$f":"(AD114-AD77)*Inputs!AD42","v":220.25611907459304},{"$f":"(AE114-AE77)*Inputs!AE42","v":222.65543457152725},{"$f":"(AF114-AF77)*Inputs!AF42","v":225.07874322343076},{"$f":"(AG114-AG77)*Inputs!AG42","v":227.52628496185329},{"$f":"(AH114-AH77)*Inputs!AH42","v":229.99830211766007},{"$f":"(AI114-AI77)*Inputs!AI42","v":232.49503944502496},{"$f":"(AJ114-AJ77)*Inputs!AJ42","v":235.01674414566341},{"$f":"(AK114-AK77)*Inputs!AK42","v":237.56366589330824},{"$f":"(AL114-AL77)*Inputs!AL42","v":240.13605685842955},{"$f":"(AM114-AM77)*Inputs!AM42","v":242.73417173320209},{"$f":"(AN114-AN77)*Inputs!AN42","v":245.35826775672231},{"$f":"(AO114-AO77)*Inputs!AO42","v":248.00860474047781},{"$f":"(AP114-AP77)*Inputs!AP42","v":250.68544509407079},{"$f":"(AQ114-AQ77)*Inputs!AQ42","v":253.38905385119975},{"$f":"(AR114-AR77)*Inputs!AR42","v":256.11969869590001},{"$f":"(AS114-AS77)*Inputs!AS42","v":258.87764998904731},{"$f":"(AT114-AT77)*Inputs!AT42","v":261.66318079512598},{"$f":"(AU114-AU77)*Inputs!AU42","v":264.47656690926556},{"$f":"(AV114-AV77)*Inputs!AV42","v":267.31808688454646},{"$f":"(AW114-AW77)*Inputs!AW42","v":270.18802205958013},{"$f":"(AX114-AX77)*Inputs!AX42","v":273.08665658636414},{"$f":"(AY114-AY77)*Inputs!AY42","v":276.01427745841602},{"$f":"(AZ114-AZ77)*Inputs!AZ42","v":278.97117453918844},{"$f":"(BA114-BA77)*Inputs!BA42","v":281.95764059076856},{"$f":"(BB114-BB77)*Inputs!BB42","v":284.97397130286453},{"$f":"(BC114-BC77)*Inputs!BC42","v":288.02046532208141},{"$f":"(BD114-BD77)*Inputs!BD42","v":291.09742428149048},{"$f":"(BE114-BE77)*Inputs!BE42","v":294.20515283049366},{"$f":"(BF114-BF77)*Inputs!BF42","v":297.34395866498681},{"$f":"(BG114-BG77)*Inputs!BG42","v":300.51415255782496},{"$f":"(BH114-BH77)*Inputs!BH42","v":303.71604838959144},{"$f":"(BI114-BI77)*Inputs!BI42","v":306.94996317967559},{"$f":"(BJ114-BJ77)*Inputs!BJ42","v":310.21621711766056},{"$f":"(BK114-BK77)*Inputs!BK42","v":313.51513359502542},{"$f":"(BL114-BL77)*Inputs!BL42","v":316.84703923716393},{"$f":"(BM114-BM77)*Inputs!BM42","v":320.2122639357238},{"$f":"(BN114-BN77)*Inputs!BN42","v":323.61114088126925},{"$f":"(BO114-BO77)*Inputs!BO42","v":0},{"$f":"(BP114-BP77)*Inputs!BP42","v":0},{"$f":"(BQ114-BQ77)*Inputs!BQ42","v":0},{"$f":"(BR114-BR77)*Inputs!BR42","v":0},{"$f":"(BS114-BS77)*Inputs!BS42","v":0},{"$f":"(BT114-BT77)*Inputs!BT42","v":0},{"$f":"(BU114-BU77)*Inputs!BU42","v":0},{"$f":"(BV114-BV77)*Inputs!BV42","v":0},{"$f":"(BW114-BW77)*Inputs!BW42","v":0},{"$f":"(BX114-BX77)*Inputs!BX42","v":0},{"$f":"(BY114-BY77)*Inputs!BY42","v":0},{"$f":"(BZ114-BZ77)*Inputs!BZ42","v":0},{"$f":"(CA114-CA77)*Inputs!CA42","v":0},{"$f":"(CB114-CB77)*Inputs!CB42","v":0},{"$f":"(CC114-CC77)*Inputs!CC42","v":0},{"$f":"(CD114-CD77)*Inputs!CD42","v":0},{"$f":"(CE114-CE77)*Inputs!CE42","v":0},{"$f":"(CF114-CF77)*Inputs!CF42","v":0},{"$f":"(CG114-CG77)*Inputs!CG42","v":0},{"$f":"(CH114-CH77)*Inputs!CH42","v":0},{"$f":"(CI114-CI77)*Inputs!CI42","v":0},{"$f":"(CJ114-CJ77)*Inputs!CJ42","v":0},{"$f":"(CK114-CK77)*Inputs!CK42","v":0},{"$f":"(CL114-CL77)*Inputs!CL42","v":0},{"$f":"(CM114-CM77)*Inputs!CM42","v":0},{"$f":"(CN114-CN77)*Inputs!CN42","v":0},{"$f":"(CO114-CO77)*Inputs!CO42","v":0},{"$f":"(CP114-CP77)*Inputs!CP42","v":0},{"$f":"(CQ114-CQ77)*Inputs!CQ42","v":0},{"$f":"(CR114-CR77)*Inputs!CR42","v":0},{"$f":"(CS114-CS77)*Inputs!CS42","v":0},{"$f":"(CT114-CT77)*Inputs!CT42","v":0},{"$f":"(CU114-CU77)*Inputs!CU42","v":0},{"$f":"(CV114-CV77)*Inputs!CV42","v":0},{"$f":"(CW114-CW77)*Inputs!CW42","v":0},{"$f":"(CX114-CX77)*Inputs!CX42","v":0},{"$f":"(CY114-CY77)*Inputs!CY42","v":0},{"$f":"(CZ114-CZ77)*Inputs!CZ42","v":0},{"$f":"(DA114-DA77)*Inputs!DA42","v":0},{"$f":"(DB114-DB77)*Inputs!DB42","v":0},{"$f":"(DC114-DC77)*Inputs!DC42","v":0},{"$f":"(DD114-DD77)*Inputs!DD42","v":0},{"$f":"(DE114-DE77)*Inputs!DE42","v":0},{"$f":"(DF114-DF77)*Inputs!DF42","v":0}]
[null,null,null,null,"Free Cash Flow",null,null,null,null,null,null,{"$f":"L114-L115-L116","v":-382.1},{"$f":"M114-M115-M116","v":-811.96249999999998},-811.96249999999998,-811.96249999999998,-811.96249999999998,-191.05,310.6754306188235,535.6754306188235,556.64543061882353,615.0848306188235,688.4930186188235,694.36937037882353,700.28824917402358,706.24975554512753,712.25398454365359,718.30102554715018,725.28728149643337,732.34340000520933,739.47007969907327,746.66802618987583,753.93795214558645,761.28057736085395,768.69662882827436,776.18684081036895,783.7519549122843,791.39272015521885,799.10989305058274,806.9042376749004,814.77652574546107,822.7275366967275,830.75805775750644,838.86888402889338,847.06081856299397,855.33467244243593,863.69126486067194,872.13142320309066,880.65598312893337,889.2657886540344,897.96169223438642,906.74455485054204,915.61524609285925,924.57464424759974,933.62363638388751,942.76311844153815,951.99399531976542,961.31718096677491,970.73359847025449,980.24418014876892,989.84986764406835,999.55161201432077,1009.3503738282757,1019.2471232603702,1029.2428401867858,1039.3385142824654,1049.5351451191018,0,0,0,0,0,0,0,0,0,0,{"$f":"BY114-BY115-BY116","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]
[]
[null,null,"Project IRR",null,null,null,null,null,{"$f":"IRR(L117:DF117)","v":0.12306370533153554}]
[]
[null,null,"Equity Cash",null,null,null,null,null,{"$f":"IRR(L121:DF121)","v":0.19857941346585162},null,null,{"$f":"-L30+L111","v":-770},0,0,0,0,0,93.928310181177977,318.40469448734888,338.81442569495181,396.65433808708678,469.42107434667139,474.61107274442685,479.79555344202515,484.97125384869526,490.13467046527728,495.28204222009356,501.30565207328885,507.33173925925087,513.35628543770372,519.37494906701659,525.38304236093302,531.37550662808098,537.34688588101335,543.2912985936058,549.20240747715388,555.07338713643537,560.89688945729063,566.66500656688379,572.36923119668927,578.00041426634789,583.54871949380629,589.00357482354036,{"$f":"-AR30+AR111","v":594.35362045007241},599.58665319841589,604.68956700637659,609.6482892358008,614.44771252073929,619.07162184007268,623.5026164802548,906.74455485054204,915.61524609285925,924.57464424759974,933.62363638388751,942.76311844153815,951.99399531976542,961.31718096677491,970.73359847025449,980.24418014876892,989.84986764406835,999.55161201432077,1009.3503738282757,1019.2471232603702,1029.2428401867858,1039.3385142824654,1049.5351451191018,0,0,0,0,0,0,0,0,0,{"$f":"-BX30+BX111","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]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R5","v":1993},1994,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,{"$f":"AX5","v":2025},2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,2056,{"$f":"CD5","v":2057},2058,2059,2060,2061,2062,2063,2064,2065,2066,2067,2068,2069,2070,2071,2072,2073,2074,2075,2076,2077,2078,2079,2080,2081,2082,2083,2084,2085]
[null,null,"CFADS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R104","v":372.95083850129407},597.427222807465,617.83695401506793,675.67686640720285,748.44360266678746,753.63360106454297,758.81808176214122,763.99378216881132,769.15719878539335,774.30457054020962,780.32818039340486,786.35426757936693,792.37881375781978,798.39747738713265,804.40557068104908,810.39803494819705,816.36941420112942,822.31382691372187,828.22493579726995,834.09591545655144,839.91941777740658,845.68753488699986,851.39175951680545,857.02294258646396,862.57124781392235,868.02610314365643,873.37614877018848,878.60918151853195,883.71209532649266,888.67081755591676,893.47024084085524,898.09415016018875,902.52514480036962,906.74455485054204,915.61524609285925,924.57464424759974,933.62363638388751,942.76311844153815,951.99399531976542,961.31718096677491,970.73359847025449,980.24418014876892,989.84986764406835,999.55161201432077,1009.3503738282757,1019.2471232603702,1029.2428401867858,1039.3385142824654,1049.5351451191018,0,0,0,0,0,0,0,0,0,0,{"$f":"BY104","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]
[null,null,"Debt Service",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R106+R107-R109+R105","v":279.02252832011612},{"$f":"S106+S107-S109+S105","v":279.02252832011612},279.02252832011612,279.02252832011612,279.02252832011607,279.02252832011607,279.02252832011607,279.02252832011607,279.02252832011607,279.02252832011607,279.02252832011607,279.02252832011607,279.02252832011607,279.02252832011607,279.02252832011607,279.02252832011607,279.02252832011607,279.02252832011607,279.02252832011607,279.02252832011607,279.02252832011607,279.02252832011607,279.02252832011607,279.02252832011607,279.02252832011607,279.02252832011607,279.02252832011607,279.02252832011607,279.02252832011607,279.02252832011607,279.02252832011601,279.02252832011601,279.02252832011476,0,0,0,0,0,0,0,0,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":"CE106+CE107-CE109+CE105","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]
[null,null,"DSCR",null,null,null,null,null,{"$f":"MIN(R126:DF126)","v":1.3366334279410448},null,null,null,null,null,null,null,null,{"$f":"IF(R125,R124/R125)","v":1.3366334279410448},{"$f":"IF(S125,S124/S125)","v":2.1411433205925596},2.2142905726459401,2.4215853482340117,2.6823769649456959,2.7009776078006027,2.7195584755492104,2.7381078752619539,2.7566132506080554,2.7750611221322887,2.7966493784263631,2.8182465133324324,2.8398381253600498,2.8614086546845057,2.8829413005611264,2.9044179329435584,2.9258189979001541,2.9471234163941786,2.9683084759631551,2.9893497148001344,3.0102207977048598,3.030893383335564,3.0513369821522924,3.0715188043999855,3.0914035974339478,3.1109534716415093,3.1301277141614325,3.1488825895467625,3.167171126456966,3.184942889401265,3.2021437344865493,3.2187155480500356,3.2345959669784361,false,false,false,false,false,false,false,false,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(CE125,CE124/CE125)","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]
[]
[null,null,"PLCR",null,null,null,null,null,{"$f":"L58","v":7.2499999999999995E-2}]
[]
[null,null,"NPV",null,null,null,null,null,{"$f":"NPV(I128,R124:DF124)","v":10019.886029756992}]
[null,null,"Loan",null,null,null,null,null,{"$f":"J27+J28+J29","v":3558.5947361411741}]
[null,null,null,null,null,null,null,null,{"$f":"I130/I131","v":2.8156861830864828}]
[null,null,"Debt/EBTDA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R114,R54/R114)","v":9.0945202045127314},{"$f":"IF(S114,S54/S114)","v":5.0823524415485313},4.8360272152777402,4.3152001713656842,3.7975909222299693,3.7178656110738184,3.6360525848032794,3.5519958921426507,3.4655302487672475,3.3764804555365195,3.2804883656431043,3.1817301623624763,3.0800124489884397,2.9751306277544169,2.866868231573894,2.7549962161104933,2.6392722098207448,2.5194397194726035,2.3952272884944383,2.2663476053520597,2.1324965589849052,1.9933522381560995,1.8485738713842852,1.6978007039271619,1.5406508080769854,1.3767198228060873,1.2055796185651531,1.0267768827876207,0.83983162138943745,0.64423557127354436,0.4394505185520059,0.22490651688460575,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,{"$f":"IF(CE114,CE54/CE114)","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]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,1]
[]
[]
[]
[]
[null,null,null,null,null,null,null,1]
[]
[]
[]
[]
[null,null,null,null,null,null,2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,1]

{"sheet":"Databook","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Capital Expenditures","index":5,"n_rows":97,"n_cols":14,"rows_kept":97,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Data from Cases"]
[null,null,null,null,null,1995]
[null,null,null,"Junior Bank Debt",null,8000]
[null,null,null,"Senior Bank Debt",null,{"$f":"F6-F4","v":333.33333333333394}]
[null,null,null,"Total Debt",null,{"$f":"F4/0.96","v":8333.3333333333339}]
[]
[null,null,null,"1987 IPO",770]
[]
[null,null,null,"May 1994 Financing",null,10100]
[null,null,null,null,null,null,null,null,null,null,null,"Original","Final","Percent Difference"]
[null,null,null,null,null,null,null,null,null,null,"Tunnels",1329,2110,{"$f":"M12/L12-1","v":0.58765989465763724}]
[null,null,null,"Junior Debt",0.96,null,null,null,null,null,"Terminals",448,553,0.234375]
[null,null,null,null,null,null,null,null,null,null,"Fixed Equipment",688,1200,0.7441860465116279]
[null,null,null,"Suspension of Interest","Sept 14 1995",null,null,null,null,null,"Rolling Stock",245,705,1.8775510204081631]
[null,null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(L11:L15)","v":2710},{"$f":"SUM(M11:M15)","v":4568},0.68560885608856093]
[null,null,null,"Junior Debt Trading",0.43,"of Face Value",null,null,null,null,"Corporate and Inflation",{"$f":"642+469","v":1111},{"$f":"1128+1146+222+72+790","v":3358},2.0225022502250227]
[null,null,null,null,null,null,null,null,null,null,"Subtotal",{"$f":"L16+L17","v":3821},{"$f":"M16+M17","v":7926},1.0743260926459044]
[null,null,null,"Initial Concession",55,"Years",null,null,null,null,"Financing Costs",500,1500,2]
[null,null,null,1993,65,null,null,null,null,null,"Total",{"$f":"L18+L19","v":4321},{"$f":"M18+M19","v":9426},1.181439481601481]
[null,null,null,1997,99]
[]
[]
[null,null,null,"1987 Construction Cost Estimate",null,2.7]
[null,null,null,"Estimated Completion",null,1990]
[]
[null,null,null,"1990 Construction Cost Estimate",null,4]
[]
[]
[null,null,null,"Toll Rate per Car Estimated in 1990",null,64.5]
[]
[null,null,null,"Average Realized in 1996",null,34.4]
[]
[null,null,null,"Minimum Paynmet of Railways",null,25]
[]
[null,null,null,"Paymemt per Passenger",1996,12.4]
[null,null,null,"Per ton of Freight",{"$f":"E36","v":1996},9]
[]
[null,null,null,"Interest During Construction",null,615]
[]
[null,null,null,"Number of Shares"]
[null,null,null,null,1986,26520]
[null,null,null,null,1987,332391]
[null,null,null,null,1993,538045]
[null,null,null,null,1996,919533]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Bozzana Book"]
[]
[]
[null,null,"Misc Data"]
[]
[null,null,"IRR projected",null,0.18]
[]
[null,null,"Original Assumptions",null,30,"Million voyagers"]
[null,null,null,null,15,"Millions tons of freight"]
[null,null,null,null,20,"Trains in each direction each hour"]
[]
[null,null,"Actual",null,8,"Million",null,3,"Eurostar"]
[null,null,null,null,null,null,null,5,"Shuttle"]
[]
[]
[]
[null,null,null,null,null,7.3]
[null,null,null,null,null,null,"Billion Francs for fist year"]
[]
[null,null,null,"Costs"]
[null,null,null,"Expected",1.2,"Billion"]
[null,null,null,"Actual",2.2999999999999998,"Billion",null,2300000,374000,{"$f":"H82/I82","v":6.1497326203208553}]
[]
[null,null,"Last Prospectus in 1994"]
[null,null,null,null,null,null,null,"Actual"]
[null,null,null,1995,"Shuttle Passengers",null,"Forecast",{"$f":"G87*0.7","v":5390000}]
[null,null,null,{"$f":"D86","v":1995},"Eurostar",null,7700000,{"$f":"G88*(1-0.7)","v":2760000.0000000005}]
[null,null,null,null,"Total",null,9200000,{"$f":"H86+H87","v":8150000}]
[null,null,null,null,null,null,{"$f":"G87+G88","v":16900000}]
[null,null,null,1995,"Revenues",null,null,{"$f":"G91*0.45","v":2340000}]
[null,null,null,null,null,null,5200000]
[null,null,null,null,"GBP",null,null,300000]
[null,null,null,null,null,null,525000]
[null,null,null,null,null,null,null,{"$f":"H90/H92","v":7.8}]
[null,null,null,null,null,null,{"$f":"G91/G93","v":9.9047619047619051}]
[null,null,null,null,null,null,{"$f":"H94","v":7.8}]
[null,null,null,null,null,null,{"$f":"G91/G96","v":666666.66666666663}]

{"sheet":"Sources and Uses of Funds","index":6,"n_rows":46,"n_cols":22,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,1988,{"$f":"F3+1","v":1989},1990,1991,1992,1993,1994,{"$f":"L3+1","v":1995},{"$f":"M3+1","v":1996},{"$f":"N3+1","v":1997},{"$f":"O3+1","v":1998},{"$f":"P3+1","v":1999}]
[null,null,"Turnover",null,null,1,6,5,11,8,3,31,299,448,456,618,627]
[null,null,"Capitalised Costs",null,null,54,220,506,547,781,846,716]
[null,null,"Deferred Expenses",null,null,0,0,0,0,11,46,51,5,35,75,48,27]
[]
[null,null,"Operating Cost",null,null,82,106,246,169,177,251,402,374,379,341,345,321]
[]
[null,null,"Depreciation",null,null,14,54,94,92,50,47,146,130,147,126,137,123]
[]
[null,null,"Interest",null,null,41,65,171,297,575,599,637,724,642,675,399,304]
[]
[null,null,"Issue of Capital",null,null,0,0,573,3,3,10,909,56,0,0,0,150]
[null,null,"Bank Loans",null,null,175,887,1278,1140,1604,1672,795,345,-1,0,-8,178]
[]
[null,null,"Capital Expenditures",null,null,624,1011,1331,1051,1238,843,453,66,39,28,57,58]
[]
[null,null,"Operating Cash Flow",null,null,31,44,165,-139,-108,-165,-333,101,115,201,356,315]
[]
[null,null,"Interest",null,null,31,38,181,328,555,670,657,657,35,135,210,252]
[]
[null,null,"Cash",null,null,-387,-118,504,-375,-294,4,261,-221,40,33,81,-23]
[]
[null,"Eurotunnel Uses and Sources of Funds - Actutal ₤ Millions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,null,null,null,1987,{"$f":"F3","v":1988},1989,1990,1991,1992,1993,1994,"Total","Percent",{"$f":"M3","v":1995},{"$f":"N3","v":1996},{"$f":"O3","v":1997},{"$f":"P3","v":1998},{"$f":"Q3","v":1999}]
[null,"Uses"]
[null,null,{"$f":"C17","v":"Capital Expenditures"},null,{"$f":"1175-F29","v":551},{"$f":"F17","v":624},{"$f":"G17","v":1011},1331,1051,1238,843,453,{"$f":"SUM(E29:L29)","v":7102},{"$f":"M29/$M$32","v":0.65275735294117643},{"$f":"M17","v":66},{"$f":"N17","v":39},{"$f":"O17","v":28},{"$f":"P17","v":57},{"$f":"Q17","v":58},null,{"$f":"SUM(E29:S29)","v":14452.652757352942},{"$f":"SUM(E29:L29)","v":7102}]
[null,null,"Capitalised Costs",null,null,{"$f":"F5","v":54},220,506,547,781,846,716,{"$f":"SUM(E30:L30)","v":3670},{"$f":"M30/$M$32","v":0.33731617647058826},{"$f":"M5","v":0},0,0,0,0,null,{"$f":"SUM(E30:S30)","v":7340.3373161764703},{"$f":"SUM(E30:L30)","v":3670}]
[null,null,"Deferred Expenses",null,null,0,0,0,0,11,46,51,{"$f":"SUM(E31:L31)","v":108},{"$f":"M31/$M$32","v":9.9264705882352935E-3},5,35,75,48,27,null,{"$f":"SUM(E31:S31)","v":406.0099264705882},{"$f":"SUM(E31:L31)","v":108}]
[null,null,null,"Total",{"$f":"SUM(E29:E31)","v":551},{"$f":"SUM(F29:F31)","v":678},{"$f":"SUM(G29:G31)","v":1231},1837,1598,2030,1735,1220,{"$f":"SUM(E32:L32)","v":10880},{"$f":"M32/$M$32","v":1},71,74,103,105,85,null,22199.000000000004,{"$f":"SUM(E32:L32)","v":10880}]
[]
[null,"Sources"]
[null,null,"Bank Loans",null,2,{"$f":"F15","v":175},{"$f":"G15","v":887},1278,1140,1604,1672,795,{"$f":"SUM(E35:L35)","v":7553},{"$f":"M35/($M$35+$M$36)","v":0.77641858552631582},{"$f":"M15","v":345},{"$f":"N15","v":-1},{"$f":"O15","v":0},{"$f":"P15","v":-8},{"$f":"Q15","v":178},null,{"$f":"SUM(E35:S35)","v":15620.776418585527},{"$f":"SUM(E35:L35)","v":7553}]
[null,null,"Equity Issue",null,770,{"$f":"F14","v":0},0,573,3,3,10,816,{"$f":"SUM(E36:L36)","v":2175},{"$f":"M36/($M$35+$M$36)","v":0.22358141447368421},{"$f":"M14","v":56},{"$f":"N14","v":0},{"$f":"O14","v":0},{"$f":"P14","v":0},{"$f":"Q14","v":150},null,{"$f":"SUM(E36:S36)","v":4556.2235814144733},{"$f":"SUM(E36:L36)","v":2175}]
[null,null,"Turnover",null,{"$f":"E4","v":0},1,6,5,11,8,3,31,{"$f":"SUM(E37:L37)","v":65},null,{"$f":"M4","v":299},{"$f":"N4","v":448},{"$f":"O4","v":456},{"$f":"P4","v":618},{"$f":"Q4","v":627},null,{"$f":"SUM(E37:S37)","v":2578},{"$f":"SUM(E37:L37)","v":65}]
[null,null,"Other",null,{"$f":"E32-E35-E36-E37","v":-221},{"$f":"F32-F35-F36-F37","v":502},338,-19,444,415,50,-422,{"$f":"SUM(E38:L38)","v":1087},null,-629,null,null,null,null,null,{"$f":"SUM(U35:U37)","v":22755},{"$f":"SUM(E38:L38)","v":1087}]
[null,null,null,"Total",{"$f":"SUM(E35:E38)","v":551},678,1231,1837,1598,2030,1735,1220,{"$f":"SUM(E39:L39)","v":10880},{"$f":"SUM(N35:N38)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U38-U32","v":555.99999999999636},{"$f":"SUM(V35:V38)","v":10880}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M35+M38","v":8640}]
[]
[null,null,null,"S-Curve",{"$f":"E29/$M$29","v":7.7583779217121937E-2},8.7862573922838638E-2,0.14235426640382989,0.18741199662067023,0.14798648268093495,0.17431709377640101,0.11869895803998874,6.3784849338214586E-2,1]
[null,null,null,null,{"$f":"E43","v":7.7583779217121937E-2},{"$f":"E44+F43","v":0.16544635313996059},0.30780061954379045,0.49521261616446066,0.64319909884539561,0.81751619262179664,0.9362151506617854,1]
[]
[null,null,null,null,0.1,{"$f":"0.85/4","v":0.21249999999999999},{"$f":"0.85/4","v":0.21249999999999999},{"$f":"0.85/4","v":0.21249999999999999},{"$f":"0.85/4","v":0.21249999999999999},0.05,null,null,{"$f":"SUM(E46:J46)","v":1}]

{"sheet":"Revenue Forecast and Actual","index":7,"n_rows":71,"n_cols":11,"rows_kept":71,"cut":false,"hidden":false,"merged":[[42,3,42,10],[43,4,43,7]]}
[]
[]
[]
[]
[null,null,null,null,null,null,"Eurotunnel Prospectus Revenue Forecats (GBP Millions)"]
[null,null,null,null,null,null,"Prospectus Date"]
[null,null,null,null,"November","November","May","May",null,"Nov 87 vs","Dif as % of"]
[null,null,null,null,1987,1990,1994,1997,"Actual","Actual","87 Proj"]
[null,null,null,1993,488,393,0,0,0]
[null,null,null,1994,762,764,137,0,82]
[null,null,null,1995,835,833,525,0,304,{"$f":"E11-I11","v":531},{"$f":"J11/E11","v":0.63592814371257489}]
[null,null,null,1996,908,904,737,0,483,{"$f":"E12-I12","v":425},{"$f":"J12/E12","v":0.46806167400881055}]
[null,null,null,1997,986,980,829,567,531,{"$f":"E13-I13","v":455},{"$f":"J13/E13","v":0.46146044624746452}]
[null,null,null,1998,1072,1070,901,649,666,{"$f":"E14-I14","v":406},{"$f":"J14/E14","v":0.3787313432835821}]
[null,null,null,1999,1158,1165,993,654,654,{"$f":"E15-I15","v":504},{"$f":"J15/E15","v":0.43523316062176165}]
[]
[]
[]
[]
[null,null,null,"Eurotunnel Shuttle Services",null,null,null,null,"Eurostar","Rail Freight (SNCF/EWS)"]
[null,null,null,"Trucks","Estimated tonnes of road freight carried (in million)2","Cars","Coaches","Estimated passenger number","Passengers","Tonnes of rail freight"]
[null,null,null,null,null,null,null,"(in million)3",null,"(in million)"]
[null,null,2001,1197771,15.6,2529757,75402,9.3000000000000007,6947135,2.4]
[null,null,2002,1231100,16,2335625,71911,8.6999999999999993,"6,602 ,817",1.5]
[null,null,2003,"1,284 ,875",16.7,2278999,71942,8.5,"6,314 ,795",1.7]
[null,null,2004,1281207,16.600000000000001,2101323,63467,7.8,"7, 276 ,675",1.9]
[null,null,2005,1308786,17,2047166,77267,8.1999999999999993,"7, 454 ,497",1.6]
[null,null,2006,1296269,"16,9",2021543,67201,"7,8",7858337,"1,6"]
[]
[]
[]
[]
[null,null,null,"Cars",null,2529757,2335625,2278999,2101323,2047166,2021543]
[null,null,null,"Trucks",null,1197771,1231100,"1,284 ,875",1281207,1308786,1296269]
[null,null,null,null,null,6947135,"6,602 ,817","6,314 ,795","7, 276 ,675",7454497,7858337]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Eurotunnel Prospectus Revenue Forecats (GBP Millions)"]
[null,null,null,null,"Prospectus Date"]
[null,null,null,null,"November","November","May","May",null,"Nov 87 vs","Dif as % of"]
[null,null,null,null,1987,1990,1994,1997,"Actual","Actual","87 Proj"]
[null,null,null,1993,488,393,0,0,0]
[null,null,null,1994,762,764,137,0,82]
[null,null,null,1995,835,833,525,0,304,{"$f":"E49-I49","v":531},{"$f":"J49/E49","v":0.63592814371257489}]
[null,null,null,1996,908,904,737,0,483,{"$f":"E50-I50","v":425},{"$f":"J50/E50","v":0.46806167400881055}]
[null,null,null,1997,986,980,829,567,531,{"$f":"E51-I51","v":455},{"$f":"J51/E51","v":0.46146044624746452}]
[null,null,null,1998,1072,1070,901,649,666,{"$f":"E52-I52","v":406},{"$f":"J52/E52","v":0.3787313432835821}]
[null,null,null,1999,1158,1165,993,654,654,{"$f":"E53-I53","v":504},{"$f":"J53/E53","v":0.43523316062176165}]
[]
[]
[]
[]
[null,null,null,null,2,null,null,null,1]
[null,null,null,null,{"$f":"(E53/OFFSET(E53,-E58,0))^(1/E58)-1","v":8.3716840631985034E-2},null,null,null,{"$f":"(I53/OFFSET(I53,-I58,0))^(1/I58)-1","v":-1.8018018018018056E-2}]
[]
[]
[null,null,null,null,1994,{"$f":"E62+1","v":1995},{"$f":"F62+1","v":1996},{"$f":"G62+1","v":1997},{"$f":"H62+1","v":1998},{"$f":"I62+1","v":1999}]
[]
[null,null,null,null,{"$f":"TRANSPOSE(E48:E53)","v":762},835,908,986,1072,1158]
[]
[null,null,null,null,{"$f":"TRANSPOSE(I48:I53)","v":82},304,483,531,666,654]
[]
[null,null,null,null,{"$f":"E64-E66","v":680},531,425,455,406,504]
[]
[]
[null,null,null,null,{"$f":"'Historic IS and BS'!J35","v":402},{"$f":"'Historic IS and BS'!K35","v":374},{"$f":"'Historic IS and BS'!L35","v":379},{"$f":"'Historic IS and BS'!M35","v":341},{"$f":"'Historic IS and BS'!N35","v":345},{"$f":"'Historic IS and BS'!O35","v":321}]

{"sheet":"Source of Historic Data","index":8,"n_rows":117,"n_cols":17,"rows_kept":117,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1158,654,{"$f":"O22-P22","v":504}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,508,{"$f":"202","v":202},{"$f":"O33-P33","v":306}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,-333]
[null,null,null,null,null,null,null,null,null,null,null,null,null,101]
[null,null,null,null,null,null,null,null,null,null,null,null,null,115]
[null,null,null,null,null,null,null,null,null,null,null,null,null,201]
[null,null,null,null,null,null,null,null,null,null,null,null,null,356]
[null,null,null,null,null,null,null,null,null,null,null,null,null,315,935,315,{"$f":"O44-P44","v":620}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Bank Debt","EIB",null,"Equity Financing"]
[null,5000,null,null,46]
[null,1800,300,null,206]
[null,693,null,null,770]
[1999,null,200,null,566,null,null,"Total Debt",null,{"$f":"B64","v":7493}]
[null,{"$f":"SUM(B60:B63)","v":7493},null,null,816,null,null,"Total Equity",null,{"$f":"E65","v":2404}]
[null,null,null,null,{"$f":"SUM(E59:E64)","v":2404},null,null,"Total",null,{"$f":"J63+J64","v":9897}]
[]
[null,null,null,null,null,null,null,"Debt to Capital",null,{"$f":"J63/J65","v":0.75709811053854703}]
[]
[null,"1987-11-01"]
[null,"£ 5 billion raised through the world’s largest private-sector loan syndication (over 220 banks) and letter of credit facility."]
[]
[null,"1990-10-01"]
[null,"£ 1.8 billion additional bank credit facilities agreed."]
[]
[null,"1994-05-01"]
[null,"£ 693 million of Senior Debt committed."]
[]
[null,"2002-07-01"]
[null,"£ 740 million in new Junior Debt financing raised to refinance Tier 1A debt and to finance a tender offer for subordinated debt (Resettable Advances and Stabilisation Advances)."]
[]
[null,"2005-09-01"]
[]
[null,"Eurotunnel Board decides to convert the Resettable and Stabilisation Advances into bonds."]
[]
[null,"2006-03-01"]
[]
[null,"Eurotunnel Board decides to convert the Resettable and Stabilisation Advances into bonds."]
[]
[]
[]
[]
[null,"1986-09-01"]
[null,"‘Equity One’ - Founding shareholders in the Channel Tunnel Group/France Manche (CTG/FM) subscribe initial equity of £46 million."]
[]
[null,"1986-10-01"]
[null,"‘Equity Two’ – a private institutional placing raises £206 million from large international investors."]
[]
[null,"1987-11-01"]
[null,"‘Equity Three’ – public floatation of the Group raises £770 million from private investors in Britain, France and several other countries."]
[]
[null,"1990-11-01"]
[null,"New issue of capital (£566 million)"]
[]
[null,"1994-05-01"]
[null,"New issue of capital (£816 million)"]
[]
[]
[]
[]
[]
[]
[null,"¹ Nominal value combined @ £1= €1.459 "]
[null,"² Excluding hedging charges and effective rate adjustments, combined @ £1 = €1.465"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"20/366","v":5.4644808743169397E-2}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"51/740","v":6.8918918918918923E-2}]
[null,"¹ Nominal value combined @ £1 = €1.459 .",null,null,null,null,null,null,null,null,{"$f":"147/3212","v":4.5765877957658782E-2}]
[null,"² Based on current interest rate forecasts.",null,null,null,null,null,null,null,null,{"$f":"16/464","v":3.4482758620689655E-2}]

{"sheet":"Historic IS and BS","index":9,"n_rows":117,"n_cols":25,"rows_kept":117,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O26-O28","v":504}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1158]
[]
[null,null,null,null,null,null,null,null,{"$f":"I32+I34","v":49},82,304,483,531,666,654]
[]
[]
[null,null,null,1988,{"$f":"D31+1","v":1989},{"$f":"E31+1","v":1990},1991,1992,1993,1994,1995,1996,1997,1998,1999]
[null,"Revenue",null,1,6,5,11,8,3,31,299,448,456,618,627]
[null,"Capitalized",null,54,220,506,547,781,846,716,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D33:J33)","v":3670}]
[null,"Deferred Expenses",null,null,null,null,null,11,46,51,5,35,75,48,27]
[null,"Operating Costs",null,82,106,246,169,177,251,402,374,379,341,345,321,null,null,null,null,null,null,null,{"$f":"SUM(D35:J35)","v":1433},{"$f":"W35+W33","v":5103}]
[null,"Depreciation",null,14,54,94,92,50,47,146,130,147,126,137,123]
[null,"Interest",null,-41,65,171,297,575,599,637,724,642,675,399,304,null,null,null,null,null,null,null,{"$f":"SUM(E37:J37)","v":2344}]
[]
[null,"EBITDA",null,{"$f":"D32-D35","v":-81},-100,-241,-158,-169,-248,-371,-75,69,115,273,306]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,1988,{"$f":"D64+1","v":1989},{"$f":"E64+1","v":1990},1991,1992,1993,1994,1995,1996,1997,1998,1999]
[null,"Equity Issue",null,0,0,573,3,3,10,909,56,0,0,0,0,null,null,null,null,null,null,null,{"$f":"SUM(D65:O65)","v":1554}]
[null,"Loans",null,175,887,1278,1140,1604,1672,795,345,0,0,0,0,null,null,null,null,null,null,null,{"$f":"SUM(D66:O66)","v":7896},{"$f":"W66+W65","v":9450}]
[]
[null,"Cap Exp",null,624,1011,1331,1051,1238,843,453,66,39,28,57,58,null,null,null,null,null,null,null,{"$f":"SUM(D68:O68)","v":6799}]
[null,"Operating CF",null,31,44,165,-139,-108,-165,-333,101,115,201,356,315,null,null,null,null,null,null,null,{"$f":"SUM(D69:J69)","v":-505},{"$f":"X66-W69","v":9955},135]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y69/X69","v":1.3561024610748368E-2}]
[null,"Interest",null,-31,38,181,328,555,670,657,35,135,210,252,null,null,null,null,null,null,null,null,null,null,{"$f":"1/Y70","v":73.740740740740733}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,1988,{"$f":"D96+1","v":1989},{"$f":"E96+1","v":1990},1991,1992,1993,1994,1995,1996,1997,1998,1999,{"$f":"O96+1","v":2000},2001,2002,2003,2004,2005,2006,2007]
[null,"Fixed Assets",null,955,1953,3399,4878,6757,8453,9461,9400,9284,9191,9108,9049,9001,8964,8832,8829.9,7424.8]
[null,"Current Assets",null,null,null,null,null,null,null,null,null,null,null,null,null,267,326,946,946,842]
[]
[null,"Loans",null,177,1086,2396,3559,5512,7072,8022,8899,8799,8884,8130,6960,7228,7297,7308,7307,7098]
[null,"Equity",null,998,997,1587,1556,1241,1367,1740,466,494,336,1062,2134,1998,1954,2419,2419,1099]
[]
[]
[null,"Cap Exp",null,{"$f":"D97","v":955},{"$f":"E97-D97","v":998},1446,1479,1879,1696,1008,null,{"$f":"SUM(D104:J104)","v":9461}]
[]
[null,"Cap + IDC",null,{"$f":"D68+D71","v":593},1049,1512,1379,1793,1513,1110]
[]
[null,"Interest",null,{"$f":"D37","v":-41},65,171,297,575,599,637]
[]
[null,"Rate",null,{"$f":"D108/D100","v":-0.23163841807909605},5.9852670349907919E-2,7.136894824707847E-2,8.3450407417813996E-2,0.1043178519593614,8.4700226244343896E-2,7.940663176265271E-2]
[]
[]
[null,null,null,{"$f":"D104/$L$104","v":0.10094070394250079},0.1054856780467181,0.15283796638833105,0.15632596977063734,0.19860479864707747,0.17926223443610612,0.10654264876862911]
[]
[null,null,null,null,null,{"$f":"SUM(D113:F113)","v":0.35926434837754995}]
[]
[null,null,null,{"$f":"D97-C97","v":955},998,1446,1479,1879,1696,1008]

{"sheet":"2000 to 2005","index":10,"n_rows":59,"n_cols":9,"rows_kept":59,"cut":false,"hidden":false,"merged":[[40,1,41,1]]}
[]
[null,null,null,null,2335,2278,2101]
[null,null,null,null,1231,1284,1281]
[null,null,null,null,6602,6314,7277]
[]
[null,"EUROTUNNEL: SALES VOLUMES"]
[null,null,"Year 2000","Year 2001","Year 2002","Year 2003","Year 2004","Year 2005 (Forecast)"]
[null,"Cars","2 784 493","2 529 757","2 335 625","2 278 999","2 101 323","2 143 350"]
[null,"Coaches","79 460","75 402","71 911","71 942","63 467","69 814"]
[null,"Trucks","1 133 146","1 197 771","1 231 100","1 284 875","1 281 207","1 319 643"]
[null,"Eurostar (passengers)","7 130 417","6 947 135","6 602 817","6 314 795","7 276 675","7 640 509"]
[null,"Railfreight (tonnes)","2 947 388","2 447 432","1 463 580","1 743 686","1 889 175","1 700 258"]
[]
[]
[]
[null,"BOOKYEAR","TURNOVER","EBIDTA","EBIT","INTEREST"]
[null,2000,"   977 130 000","  526 873 000","  367 689 000","  553 230 000"]
[null,2001,"   919 817 000","  487 047 000","  326 682 000","  555 169 000"]
[null,2002,"   914 143 000","  492 859 000","  325 824 000","  498 627 000"]
[null,2003,"   837 960 000","  421 828 000","  248 424 000","  515 868 000"]
[null,2004,"   813 883 000                ","  430 346 000","  255 588 000","  483 907 000"]
[null,"2005 (FORECAST)","   830 160 660","  488 952 920","  320 699 760","  470 900 000"]
[]
[]
[null,null,null,null,null,null,null,null,-333000]
[null,null,null,null,null,null,null,null,101000]
[null,null,null,null,null,null,null,null,115000]
[null,null,null,null,null,null,null,null,201000]
[null,null,null,null,null,null,null,null,356000]
[null,null,null,null,null,null,null,null,315000]
[null,{"$f":"B17","v":2000},null,{"$f":"D17","v":"  526 873 000"},{"$f":"F17","v":"  553 230 000"},8899000,526873,{"$f":"F31/G31","v":16.890218325858413},553230]
[null,{"$f":"B18","v":2001},null,{"$f":"D18","v":"  487 047 000"},{"$f":"F18","v":"  555 169 000"},8899000,487047,{"$f":"F32/G32","v":18.271337263138875},555169]
[null,{"$f":"B19","v":2002},null,{"$f":"D19","v":"  492 859 000"},{"$f":"F19","v":"  498 627 000"},8899000,492859,{"$f":"F33/G33","v":18.055873992358869},489627]
[null,{"$f":"B20","v":2003},null,{"$f":"D20","v":"  421 828 000"},{"$f":"F20","v":"  515 868 000"},8899000,421828,{"$f":"F34/G34","v":21.096276207364138},515868]
[null,{"$f":"B21","v":2004},null,{"$f":"D21","v":"  430 346 000"},{"$f":"F21","v":"  483 907 000"},8899000,430346,{"$f":"F35/G35","v":20.678709689412706},483907]
[]
[]
[]
[null,null,2006,2007,2008,2009]
[null,"Revenue Business line Operations Shuttle Services"," 434 983 000"," 443 683 000"," 452 556 000","461 607 120"]
[null,"Revenue Business line Sale of Use of Track High Speed Rail Services Passenger Transport"," "]
[null,null," 228 221 966"," 306 919 260  (2)"," 316 126 657","325 610 450"]
[null,"Revenue Business line Sale Use of Track Rail Service Goods Transport","   75 000 000","   25 000 000  (3)","   25 000 000","  50 000 000 (4)"]
[null,"Revenue Non Core Business Activities","   30 000 000","   30 000 000","   30 000 000","  30 000 000"]
[null,"Financial Income","   50 000 000","   50 000 000","   50 000 000","  50 000 000"]
[null,"Available Cash from Sales and Financial Income","  818 204 966","  855 602 260","  873 000 000","917 217 570"]
[null,"Costs of Operations inclusive Interest Payments on Loan Capital (5)","1 033 163 010","1033 163 010","1033 163 010",1033163010]
[null,"Necessary Refinancing of Debt","       5 800 000","    52 400 000","    99 200 000","231 100 100"]
[null,"Total Financing needs","   220 758 044","  229 960 750"," 259 363 010","347 055 540"]
[null," "]
[]
[]
[]
[null,null,434983000,443683000,452556000,461607120]
[null,null,228221966,306919260,316126657,325610450]
[null,null,75000000,25000000,25000000,50000000]
[null,null,30000000,30000000,30000000,30000000]
[]
[null,null,{"$f":"SUM(C54:C57)","v":768204966},{"$f":"SUM(D54:D57)","v":805602260},{"$f":"SUM(E54:E57)","v":823682657},{"$f":"SUM(F54:F57)","v":867217570}]

{"sheet":"Revenue Forecasts","index":11,"n_rows":83,"n_cols":31,"rows_kept":83,"cut":false,"hidden":false,"merged":[[72,21,72,28],[73,22,73,25]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,7.0000000000000007E-2,9000,{"$f":"PMT(V7,U7,,-W7)","v":651.3975245462824}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V7*W7","v":630.00000000000011}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1995,{"$f":"Q17+1","v":1996},{"$f":"R17+1","v":1997},{"$f":"S17+1","v":1998},{"$f":"T17+1","v":1999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,299,448,456,618,627]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1993,{"$f":"O20+1","v":1994},1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1987 Forecast",488,790,820,900,1000,1080,1180,1250,1370,1480,1500,{"$f":"Y21*1.06","v":1590},{"$f":"Z21*1.06","v":1685.4},{"$f":"AA21*1.08","v":1820.2320000000002}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q21/P21-1","v":3.7974683544303778E-2},9.7560975609756184E-2,0.11111111111111116,8.0000000000000071E-2,9.259259259259256E-2,5.9322033898305149E-2,9.6000000000000085E-2,8.0291970802919721E-2,1.3513513513513598E-2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Actual",0,5,205,400,550,630,620,610,600,598,590]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Actual",0,82,304,483,531,666,654]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1987 Forecast",488,762,835,908,986,1072,1158]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O20","v":1993},{"$f":"P20","v":1994},{"$f":"Q20","v":1995},{"$f":"R20","v":1996},1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Revenues - Annual Reports",null,null,{"$f":"Q26","v":304},{"$f":"R26","v":483},509,641,539,599,564,581,584,538,541,568,526,537,555]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Projected",{"$f":"O21","v":488},{"$f":"P21","v":790},{"$f":"Q21","v":820},{"$f":"R21","v":900},1000,1080,1180,1250,1370,1480,1500,1590,1685.4,1820.2320000000002]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R20","v":1996},1997,1998,1999,2000,2001,2002,2003,2004,2005,2006]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Operating Costs",null,null,null,null,{"$f":"S39+S38-S37","v":233},{"$f":"T39+T38-T37","v":201},212,186.6,138.6,129,125,146,126,{"$f":"AB36-AB37","v":118}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,{"$f":"S37+S35","v":353},{"$f":"T37+T35","v":321},{"$f":"U37+U35","v":332},392,381,386,414,null,null,{"$f":"150+83","v":233}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Depreciation",null,null,null,null,120,120,120,115.4,115.4,119,124,120,114,115]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Staff",null,null,null,null,88,86,92,95,95,102,105,104,83,98]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Operating Expenses",null,null,null,null,265,235,240,207,159,146,144,162,157,{"$f":"150+115","v":265}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cash Operating Expense",null,null,null,null,{"$f":"S38+S39-S37","v":233},201,212,186.6,138.6,129,125,146,126,248]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Operating Profit (EBIT)",null,null,null,null,51,174,203,208,188,{"$f":"X31-X35-X37","v":333},{"$f":"Y31-Y35-Y37","v":335},{"$f":"Z31-Z35-Z37","v":272},{"$f":"AA31-AA35-AA37","v":301},{"$f":"AB31-AB35-AB37","v":335}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S31-S37-S35","v":156},320,207,297,310,{"$f":"X31-X37-X35","v":333},335,272,301,335]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S30","v":1997},1998,1999,2000,2001,2002,2003,2004,2005,2006]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EBITDA",{"$f":"S37+S43","v":276},{"$f":"T37+T43","v":440},327,412.4,425.4,452,459,392,415,450]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Debt",8333,8333,8333,8333,8333,8333,8333,8333,8333,8333]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Debt/EBITDA",{"$f":"S47/S46","v":30.192028985507246},18.938636363636363,25.483180428134556,20.206110572259941,19.58862247296662,18.435840707964601,18.154684095860567,21.257653061224488,20.079518072289158,18.517777777777777]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1997,{"$f":"S52+1","v":1998},1999,2000,2001,2002,2003,2004,2005,2006]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Truck Traffic",255,705,839,1133,1197,1231,1284,1281,1308.7860000000001,1308.7860000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Car Traffic",2139,3351,3260,2784,2530,2335,2278,2101,2047,2021]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eurostar",6004,6308,6593,7130,6947,6602,6314,7277,7454.4970000000003,7858.3370000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Per Passenger",12.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S55*S56","v":74449.600000000006}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.52,{"$f":"S60","v":2.52},{"$f":"T60","v":2.52},2.52,2.52,2.52,2.52,2.52,2.52,2.52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Car Traffic",{"$f":"S60*S54","v":5390.28},{"$f":"T60*T54","v":8444.52},8215.2000000000007,7015.68,6375.6,5884.2,5740.56,5294.52,5158.4399999999996,5092.92]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eurostar",{"$f":"S55","v":6004},{"$f":"T55","v":6308},6593,7130,6947,6602,6314,7277,7454.4970000000003,7858.3370000000004]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P20","v":1994},{"$f":"Q20","v":1995},1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actual",null,null,null,{"$f":"S61+S62","v":11394.279999999999},14752.52,14808.2,14145.68,13322.6,12486.2,12054.560000000001,12571.52,12612.937,12951.257000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projected",30000,{"$f":"P66*1.03","v":30900},{"$f":"Q66*1.03","v":31827},32781.81,33765.264299999995,34778.222228999999,35821.568895869998,36896.215962746101,38003.102441628485,39143.195514877341,40317.491380323663,41527.016121733373,42772.826605385373]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eurotunnel Prospectus Revenue Forecats (GBP Millions)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prospectus Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"November","November","May","May",null,"Nov 87 vs","Dif as % of"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1987,1990,1994,1997,"Actual","Actual","87 Proj"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1993,488,393,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1994,762,764,137,0,82]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1995,835,833,525,0,304,{"$f":"W79-AA79","v":531},{"$f":"AB79/W79","v":0.63592814371257489}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1996,908,904,737,0,483,{"$f":"W80-AA80","v":425},{"$f":"AB80/W80","v":0.46806167400881055}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1997,986,980,829,567,531,{"$f":"W81-AA81","v":455},{"$f":"AB81/W81","v":0.46146044624746452}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1998,1072,1070,901,649,666,{"$f":"W82-AA82","v":406},{"$f":"AB82/W82","v":0.3787313432835821}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1999,1158,1165,993,654,654,{"$f":"W83-AA83","v":504},{"$f":"AB83/W83","v":0.43523316062176165}]

{"sheet":"Share Price","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"EBITDA to Debt","index":14,"n_rows":23,"n_cols":19,"rows_kept":23,"cut":false,"hidden":false,"merged":[[8,9,8,18],[10,7,19,7]]}
[]
[null,null,null,"Rate",null,7.0000000000000007E-2]
[]
[null,null,null,"Term",null,15]
[]
[null,null,null,"Total Debt",null,{"$f":"F23*F13","v":1000}]
[null,null,null,null,null,null,null,{"$f":"\"Ability to Pay Back Debt -- Debt Service Coverage -- with Different Terms at \"&TEXT(F2,\"0.00%\")&\" Interest Rate\"","v":"Ability to Pay Back Debt -- Debt Service Coverage -- with Different Terms at 7.00% Interest Rate"}]
[null,null,null,"Interest",null,{"$f":"F6*F2","v":70}]
[null,null,null,null,null,null,null,null,null,"Debt/EBITDA"]
[null,null,null,"Pmt",null,{"$f":"F6/F4","v":66.666666666666671},null,null,{"$f":"F17","v":1.4634146341463412},2,{"$f":"J10+2","v":4},{"$f":"K10+2","v":6},8,10,12,14,16,18,20]
[null,null,null,null,null,null,null,"Term of Debt (Yrs)",50,5.5555555555555554,2.7777777777777777,1.8518518518518516,1.3888888888888888,1.1111111111111112,0.92592592592592582,0.79365079365079361,0.69444444444444442,0.61728395061728392,0.55555555555555558]
[null,null,null,null,null,null,null,null,{"$f":"I11-5","v":45},5.4216867469879508,2.7108433734939754,1.8072289156626502,1.3554216867469877,1.0843373493975903,0.9036144578313251,0.77452667814113596,0.67771084337349385,0.60240963855421692,0.54216867469879515]
[null,null,null,"EBITDA",null,200,null,null,40,5.2631578947368425,2.6315789473684212,1.7543859649122804,1.3157894736842106,1.0526315789473684,0.87719298245614019,0.75187969924812026,0.65789473684210531,0.58479532163742687,0.52631578947368418]
[null,null,null,"Interest",null,{"$f":"F8","v":70},null,null,35,5.0724637681159415,2.5362318840579707,1.6908212560386471,1.2681159420289854,1.0144927536231885,0.84541062801932354,0.72463768115942029,0.63405797101449268,0.56360708534621573,0.50724637681159424]
[null,null,null,"Pmt",null,{"$f":"F10","v":66.666666666666671},null,null,30,4.838709677419355,2.4193548387096775,1.6129032258064515,1.2096774193548387,0.96774193548387089,0.80645161290322576,0.6912442396313363,0.60483870967741937,0.5376344086021505,0.48387096774193544]
[null,null,null,"Remainder",null,{"$f":"F13-F14-F15","v":63.333333333333329},null,null,25,4.5454545454545459,2.2727272727272729,1.5151515151515151,1.1363636363636365,0.90909090909090906,0.75757575757575757,0.64935064935064934,0.56818181818181823,0.50505050505050508,0.45454545454545453]
[null,null,null,"Coverage",null,{"$f":"F13/(F14+F15)","v":1.4634146341463412},null,null,20,4.166666666666667,2.0833333333333335,1.3888888888888888,1.0416666666666667,0.83333333333333337,0.69444444444444442,0.59523809523809523,0.52083333333333337,0.46296296296296297,0.41666666666666669]
[null,null,null,null,null,null,null,null,15,3.6585365853658534,1.8292682926829267,1.2195121951219512,0.91463414634146334,0.7317073170731706,0.6097560975609756,0.5226480836236933,0.45731707317073167,0.4065040650406504,0.3658536585365853]
[null,null,null,"Remainder",null,{"$f":"F13-F14","v":130},null,null,10,2.9411764705882355,1.4705882352941178,0.98039215686274506,0.73529411764705888,0.58823529411764708,0.49019607843137253,0.42016806722689076,0.36764705882352944,0.32679738562091504,0.29411764705882354]
[null,null,null,null,null,null,null,null,5,1.8518518518518519,0.92592592592592593,0.61728395061728392,0.46296296296296297,0.37037037037037035,0.30864197530864196,0.26455026455026454,0.23148148148148148,0.20576131687242799,0.18518518518518517]
[]
[]
[null,null,null,"Debt/EBITDA",null,5]