{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Exercise with History Completed","History and Forecast Chart","Advertising"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":1,"defined_names":18,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"History and Forecast Chart","index":1,"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":"Exercise with History Completed","index":0,"n_rows":176,"n_cols":76,"rows_kept":176,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Year",null,null,null,null,null,"2007-01-01",{"$f":"EDATE(I2,3)","v":"2007-04-01"},{"$f":"EDATE(J2,3)","v":"2007-07-01"},"2007-10-01","2008-01-01","2008-04-01","2008-07-01","2008-10-01","2009-01-01","2009-04-01","2009-07-01","2009-10-01","2010-01-01","2010-04-01","2010-07-01","2010-10-01","2011-01-01","2011-04-01","2011-07-01","2011-10-01","2012-01-01","2012-04-01","2012-07-01","2012-10-01","2013-01-01","2013-04-01","2013-07-01","2013-10-01","2014-01-01","2014-04-01","2014-07-01","2014-10-01","2015-01-01","2015-04-01","2015-07-01","2015-10-01","2016-01-01","2016-04-01","2016-07-01","2016-10-01","2017-01-01","2017-04-01","2017-07-01","2017-10-01","2018-01-01","2018-04-01","2018-07-01","2018-10-01","2019-01-01","2019-04-01","2019-07-01","2019-10-01","2020-01-01","2020-04-01","2020-07-01","2020-10-01","2021-01-01","2021-04-01","2021-07-01","2021-10-01","2022-01-01","2022-04-01","2022-07-01","2022-10-01","2023-01-01","2023-04-01",{"$f":"EDATE(BV2,3)","v":"2023-07-01"},"2023-10-01"]
[null,null,null,"Historic Switch",null,null,"2014-10-01",null,{"$f":"I2<=$G3","v":true},true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,{"$f":"AO2<=$G3","v":false},false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,{"$f":"BU2<=$G3","v":false},false,false,false]
[null,null,null,"Valuation Switch"]
[null,null,null,"Scenario Code",null,null,null,1]
[]
[null,null,"History"]
[null,null,null,"Balance Sheet"]
[null,null,null,null,"Assets"]
[null,null,null,null,null,"Cash",null,null,100,83.319210140045641,102.35001440174297,102.33195314957464,110.65240663406419,120.03537927373338,122.59906659204616,129.38053781001796,92.044708434460603,75.698383096832799,65.596107055639848,56.815313604356817,59.824012909414492,61.198895641561982,66.946872578017235,67.103791299769782,56.255236367652842,61.501606481383533,63.278879629678563,61.103621267722524,50.750546102208553,58.539957426473492,64.116315494436137,75.496850151449124,94.806446734788707,55.535245884154129,58.155618382140283,55.846288124430281,63.814089974230832,52.812943088645952,60.640998705982433,60.62813564304691]
[null,null,null,null,null,"Accounts Receivable",null,null,75,90.869087617403565,68.981647985981994,65.275895640331456,77.835659787616024,115.87701133739196,113.86428600349051,120.9727272989804,70.572861800083473,76.266672844891445,63.778781836564221,63.591955211842574,55.816178400178956,57.655373233955871,51.397137457018104,58.342079533052242,77.691824845738182,86.607342900613872,85.203489962789902,68.194378299030959,63.085108892966801,64.244749441734271,74.714169200683713,59.517990541218239,67.830387287028771,70.928194977859008,75.146072680008615,57.127308648585732,61.15408281048591,45.620930115695067,51.411918373181265,63.026786346982888]
[null,null,null,null,null,"Net Plant",null,null,1000,1042.4886350338331,1017.9732191345776,834.40045971673305,682.15181760931523,703.20984944953898,617.61266867861752,643.34875878335652,770.76776730366873,937.75116407640076,1085.6093354991974,1163.1920768759178,1110.4296215282625,1316.4445561362425,991.64254396332126,1121.5045022428856,1424.1603147980729,1341.748024525401,1454.3111962754704,1573.2389705562805,1264.2403742813319,1285.4987659238518,1402.9165576026369,1365.2119581456327,1248.1273830294085,1116.0679476146952,1117.2694465498146,1175.1604487940285,1292.9860331419948,1143.023378691541,1159.4345069775636,1383.6365057072796]
[null,null,null,null,null,"Total",null,null,{"$f":"SUM(I10:I12)","v":1175},{"$f":"SUM(J10:J12)","v":1216.6769327912823},1189.3048815223026,1002.0083085066392,870.63988403099552,939.12224006066435,854.07602127415419,893.70202389235487,933.38533753821275,1089.7162200181251,1214.9842243914015,1283.5993456921171,1226.069812837856,1435.2988250117603,1109.9865539983566,1246.9503730757076,1558.1073760114639,1489.8569739073985,1602.7935658679389,1702.5369701230341,1378.0760292765074,1408.2834727920595,1541.7470422977567,1500.2267988383001,1410.7642170512261,1242.5313884767083,1250.5711376119634,1288.1340455670445,1417.9542059267114,1241.4572518958821,1271.4874240567274,1507.2914276973095]
[]
[null,null,null,null,"Liabilities and Capital"]
[null,null,null,null,null,"Debt",null,null,{"$f":"I13*0.4","v":470},450.32313806955153,448.12929341452821,374.69296514652308,317.12168969735177,329.29809148930894,296.08469410826547,309.0917186373498,345.12499029525179,405.37981886929344,460.48217702193489,488.00295619210988,468.10145377507081,551.05738071112171,423.43576661653543,475.44331741706213,592.16622046629027,561.29985240271378,607.03603036205959,653.73703672960119,525.99636815341626,537.61548934013013,586.81314923882917,576.28352331883275,537.17353190567894,468.64127739953977,470.17002597278201,492.40269476738354,542.72004924649025,478.33452871207476,488.03020227341841,577.70585654013064]
[null,null,null,null,null,"Equity",null,null,{"$f":"I13-I16","v":705},{"$f":"J13-J16","v":766.35379472173076},741.17558810777439,627.31534336011612,553.51819433364381,609.82414857135541,557.99132716588872,584.61030525500507,588.26034724296096,684.33640114883167,754.50204736946671,795.59638950000726,757.96835906278523,884.24144430063859,686.55078738182124,771.50705565864541,965.94115554517361,928.55712150468469,995.75753550587933,1048.7999333934329,852.07966112309111,870.66798345192933,954.93389305892754,923.94327551946731,873.59068514554713,773.89011107716851,780.40111163918141,795.73135079966096,875.23415668022119,763.12272318380735,783.45722178330902,929.58557115717883]
[null,null,null,null,null,"Total",null,null,{"$f":"SUM(I16:I17)","v":1175},{"$f":"SUM(J16:J17)","v":1216.6769327912823},1189.3048815223026,1002.0083085066392,870.63988403099552,939.12224006066435,854.07602127415419,893.70202389235487,933.38533753821275,1089.7162200181251,1214.9842243914015,1283.5993456921171,1226.069812837856,1435.2988250117603,1109.9865539983566,1246.9503730757076,1558.1073760114639,1489.8569739073985,1602.7935658679389,1702.5369701230341,1378.0760292765074,1408.2834727920595,1541.7470422977567,1500.2267988383001,1410.7642170512261,1242.5313884767083,1250.5711376119634,1288.1340455670445,1417.9542059267114,1241.4572518958821,1271.4874240567274,1507.2914276973095]
[]
[null,null,null,null,"Profit and Loss"]
[null,null,null,null,null,"Revenues",null,null,300,327.47635046961426,287.92659194392797,285.10358256132582,339.34263915046409,427.50804534956785,467.45714401396202,499.89090919592161,290.29144720033389,297.06669137956578,279.11512734625688,258.3678208473703,211.26471360071582,202.62149293582348,217.58854982807242,245.36831813220897,322.76729938295273,350.42937160245549,348.81395985115961,296.77751319612383,280.3404355718672,272.97899776693708,262.85667680273485,262.07196216487296,251.32154914811505,283.71277991143603,288.58429072003446,236.50923459434293,252.61633124194364,214.48372046278027,185.64767349272506,216.10714538793155]
[null,null,null,null,null,"Depreciation",null,null,100,107.24886350338332,102.79732191345776,78.440045971673314,74.215181760931529,74.320984944953906,66.761266867861764,58.334875878335652,82.076776730366873,83.775116407640084,111.56093354991975,106.31920768759178,119.04296215282625,130.64445561362425,95.164254396332126,106.15045022428856,141.41603147980729,138.17480245254009,142.43111962754705,158.32389705562807,128.4240374281332,133.54987659238517,137.29165576026369,134.52119581456327,121.81273830294086,109.60679476146953,103.72694465498147,124.51604487940286,125.29860331419948,107.3023378691541,123.94345069775636,144.36365057072797]
[null,null,null,null,null,"EBIT",null,null,{"$f":"I21-I22","v":200},223.22748696623094,186.1292700304702,201.66353658965249,271.12745738953254,357.18706040461393,405.69587714610026,435.55603331758596,213.21467046996702,203.29157497192568,170.55419379633713,142.04861315977851,100.22175144788957,70.977037322199237,118.42429543174029,133.21786790792041,180.35126790314544,216.2545691499154,203.38284022361256,139.45361614049577,153.916398143734,144.42912117455191,122.56502104247116,125.55076635030969,126.5088108451742,172.1059851499665,176.85734606505298,118.99318971494007,123.31772792774416,100.18138259362617,69.7042227949687,77.743494817203583]
[null,null,null,null,null,"Interest Expense",null,null,23.5,22.516156903477579,22.406464670726411,18.734648257326153,15.856084484867589,16.464904574465447,14.804234705413274,15.454585931867491,17.25624951476259,20.268990943464672,23.024108851096745,24.400147809605496,23.405072688753542,27.552869035556085,21.171788330826772,23.772165870853108,29.608311023314513,28.064992620135691,30.351801518102981,32.686851836480059,26.299818407670813,26.880774467006507,29.340657461941461,28.814176165941639,26.858676595283949,23.432063869976989,23.508501298639104,24.620134738369178,27.136002462324512,23.916726435603739,24.401510113670923,28.885292827006534]
[null,null,null,null,null,"Interest Income",null,null,1,0.83319210140045641,1.0235001440174296,1.0233195314957464,1.1065240663406419,1.2003537927373338,1.2259906659204616,1.2938053781001795,0.92044708434460609,0.756983830968328,0.65596107055639852,0.56815313604356821,0.59824012909414492,0.61198895641561979,0.66946872578017236,0.67103791299769788,0.56255236367652839,0.61501606481383531,0.63278879629678564,0.6110362126772253,0.50750546102208549,0.58539957426473499,0.64116315494436138,0.75496850151449124,0.94806446734788707,0.55535245884154127,0.58155618382140284,0.55846288124430277,0.63814089974230837,0.52812943088645947,0.6064099870598243,0.6062813564304691]
[null,null,null,null,null,"Net Income",null,null,{"$f":"I23-I24+I25","v":177.5},201.54452216415382,164.74630550376119,183.95220786382211,256.37789697100561,341.92250962288585,392.11763310660746,421.39525276381863,196.87886803954902,183.77956785942933,148.18604601579679,118.21661848621657,77.41491888823019,44.036157243058774,97.921975826693696,110.116739950065,151.30550924350746,188.80459259459354,173.66382750180637,107.37780051669293,128.12408519708526,118.13374628181015,93.865526735474063,97.491558685882552,100.59819871723813,149.22927373883107,153.93040095023528,94.931517857815194,96.819866365161957,76.792785588908899,45.909122668357604,49.464483346627517]
[]
[null,null,null,null,"Cash Flow"]
[null,null,null,null,null,"Capital Expenditure",null,null,130,135.52352255439831,132.33651848749511,108.47205976317531,88.679736289210993,91.41728042844008,80.289646928220293,83.635338641836356,100.19980974947694,121.90765132993211,141.12921361489569,151.21496999386932,144.35585079867414,171.13779229771151,128.91353071523176,145.79558529157512,185.14084092374949,174.42724318830213,189.06045551581116,204.52106617231649,164.35124865657318,167.11483957010074,182.37915248834281,177.47755455893227,162.25655979382313,145.08883318991039,145.24502805147591,152.77085834322372,168.08818430845935,148.59303922990034,150.72648590708329,179.87274574194637]
[null,null,null,null,null,"Dividends",null,null,88.75,100.77226108207691,82.373152751880596,91.976103931911055,128.18894848550281,170.96125481144293,196.05881655330373,210.69762638190932,98.439434019774509,91.889783929714667,74.093023007898395,59.108309243108287,38.707459444115095,22.018078621529387,48.960987913346848,55.058369975032498,75.652754621753729,94.402296297296772,86.831913750903183,53.688900258346465,64.062042598542632,59.066873140905074,46.932763367737032,48.745779342941276,50.299099358619067,74.614636869415534,76.965200475117641,47.465758928907597,48.409933182580978,38.396392794454449,22.954561334178802,24.732241673313759]
[null,null,null,null,null,"Shares",null,null,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100]
[]
[null,null,"Assumptions"]
[null,null,null,"Operating"]
[null,null,null,null,"Revenue Growth"]
[null,null,null,null,null,"Historic",null,null,null,{"$f":"IF(J3,J21/I21-1)","v":9.1587834898714249E-2},{"$f":"IF(K3,K21/J21-1)","v":-0.12077134262969014},-9.8046150011456001E-3,0.1902433357794493,0.25981234312264334,9.3446425392365029E-2,6.9383398237231386E-2,-0.4192904054461204,2.3339455035877199E-2,-6.042940711374456E-2,-7.4332432986150776E-2,-0.18231027026574043,-4.0911804520407435E-2,7.38670743926928E-2,0.12767109448583924,0.31543999583939675,8.5702833813665391E-2,-4.6098069460013269E-3,-0.14918108976269173,-5.5385185512334512E-2,-2.6258922619969205E-2,-3.7080951454164346E-2,-2.9853327197422175E-3,-4.1020843771126803E-2,0.12888361890619793,1.7170572330647671E-2,-0.18045007230213839,6.8103457673554857E-2,-0.1509506950389593,-0.13444398907216448,0.16407139029620055,false,false,false,false,false,false,false,false,false,false,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(BW3,BW21/BV21-1)","v":false},false]
[null,null,null,null,null,"Base",null,null,0.03,0.03,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.2000000000000003E-2,4.2000000000000003E-2,0.04,0.04,0.04,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03]
[null,null,null,null,null,"Low",null,null,0.01,0.01,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[null,0,null,null,null,"High",null,null,0.05,0.05,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,7.5999999999999998E-2,7.5999999999999998E-2,7.5999999999999998E-2,7.5999999999999998E-2,7.5999999999999998E-2,7.5999999999999998E-2,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05]
[true,{"$f":"B39+A40","v":1},null,null,null,{"$f":"E35","v":"Revenue Growth"},"Scenario",{"$f":"H5","v":1},{"$f":"IF(I3,I36,INDEX(I37:I39,$H$40))","v":0},9.1587834898714249E-2,-0.12077134262969014,-9.8046150011456001E-3,0.1902433357794493,0.25981234312264334,9.3446425392365029E-2,6.9383398237231386E-2,-0.4192904054461204,2.3339455035877199E-2,-6.042940711374456E-2,-7.4332432986150776E-2,-0.18231027026574043,-4.0911804520407435E-2,7.38670743926928E-2,0.12767109448583924,0.31543999583939675,8.5702833813665391E-2,-4.6098069460013269E-3,-0.14918108976269173,-5.5385185512334512E-2,-2.6258922619969205E-2,-3.7080951454164346E-2,-2.9853327197422175E-3,-4.1020843771126803E-2,0.12888361890619793,1.7170572330647671E-2,-0.18045007230213839,6.8103457673554857E-2,-0.1509506950389593,-0.13444398907216448,0.16407139029620055,{"$f":"IF(AO3,AO36,INDEX(AO37:AO39,$H$40))","v":0.05},0.05,0.05,0.05,0.05,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.2000000000000003E-2,4.2000000000000003E-2,0.04,0.04,0.04,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,{"$f":"IF(BU3,BU36,INDEX(BU37:BU39,$H$40))","v":0.03},0.03,0.03,0.03]
[false,{"$f":"B40+A41","v":1}]
[false,1,null,null,"Cap Exp to Sales"]
[false,1,null,null,null,"Historic",null,null,{"$f":"IF(I3,I29/I21)","v":0.43333333333333335},{"$f":"IF(J3,J29/J21)","v":0.41384216710627236},0.45961895215731541,0.38046543922275322,0.26132800909198595,0.213837567322714,0.17175830545403367,0.16730718063339947,0.34516969313370005,0.41037132356979461,0.5056308303914232,0.58527013734887257,0.683293714025062,0.84461815880468394,0.59246468077981485,0.59419075128117305,0.57360470307150291,0.49775292062613141,0.54200942988773748,0.68913936224393069,0.58625595098799299,0.6121893659847758,0.69383496248494481,0.67720924090032486,0.64561339982111154,0.51139336492068288,0.50330192156018327,0.64594035241479675,0.66538922278731316,0.69279402142637647,0.81189536648295124,0.83233132073934346,false,false,false,false,false,false,false,false,false,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(BV3,BV29/BV21)","v":false},false,false]
[false,1,null,null,null,"Base ",null,null,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6]
[false,1,null,null,null,"Low ",null,null,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7]
[false,1,null,null,null,"High",null,null,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[false,1]
[true,2,null,null,null,{"$f":"E42","v":"Cap Exp to Sales"},"Scenario",{"$f":"H5","v":1},{"$f":"IF(I3,I43,INDEX(I44:I46,$H$48))","v":0.43333333333333335},0.41384216710627236,0.45961895215731541,0.38046543922275322,0.26132800909198595,0.213837567322714,0.17175830545403367,0.16730718063339947,0.34516969313370005,0.41037132356979461,0.5056308303914232,0.58527013734887257,0.683293714025062,0.84461815880468394,0.59246468077981485,0.59419075128117305,0.57360470307150291,0.49775292062613141,0.54200942988773748,0.68913936224393069,0.58625595098799299,0.6121893659847758,0.69383496248494481,0.67720924090032486,0.64561339982111154,0.51139336492068288,0.50330192156018327,0.64594035241479675,0.66538922278731316,0.69279402142637647,0.81189536648295124,0.83233132073934346,{"$f":"IF(AO3,AO43,INDEX(AO44:AO46,$H$48))","v":0.6},0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6]
[false,2]
[false,2,null,null,"A/R to Revenues"]
[false,2,null,null,null,"Historic",null,null,{"$f":"IF(I3,I11/I21)","v":0.25},{"$f":"IF(J3,J11/J21)","v":0.27748290063417902},0.2395806775617855,0.22895501716920938,0.22937188200833139,0.27105223538574769,0.24358229938633605,0.24199825416622592,0.24311037228520282,0.25673249495159517,0.22850349403471534,0.24612954896348821,0.2642001943858448,0.28454717413525876,0.23621250979258582,0.23777348264504325,0.24070537812927387,0.24714635792249043,0.24426628452355115,0.22978283484020257,0.22503035912132804,0.23534685806336242,0.28423919114200091,0.22710552494652092,0.26989483200683789,0.25,0.26039557625439286,0.24154367057408829,0.2420828554901128,0.21270113189598344,0.27693273718938327,0.29164600843643645,false,false,false,false,false,false,false,false,false,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(BV3,BV11/BV21)","v":false},false,false]
[false,2,null,null,null,"Projected","Average",null,{"$f":"AVERAGEIF(3:3,TRUE,51:51)","v":0.2486891293137973},0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,{"$f":"AVERAGEIF(3:3,TRUE,51:51)","v":0.2486891293137973},0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,{"$f":"AVERAGEIF(3:3,TRUE,51:51)","v":0.2486891293137973},0.2486891293137973,0.2486891293137973,0.2486891293137973]
[true,3,null,null,null,{"$f":"E50","v":"A/R to Revenues"},null,null,{"$f":"IF(I3,I51,I52)","v":0.25},{"$f":"IF(J3,J51,J52)","v":0.27748290063417902},0.2395806775617855,0.22895501716920938,0.22937188200833139,0.27105223538574769,0.24358229938633605,0.24199825416622592,0.24311037228520282,0.25673249495159517,0.22850349403471534,0.24612954896348821,0.2642001943858448,0.28454717413525876,0.23621250979258582,0.23777348264504325,0.24070537812927387,0.24714635792249043,0.24426628452355115,0.22978283484020257,0.22503035912132804,0.23534685806336242,0.28423919114200091,0.22710552494652092,0.26989483200683789,0.25,0.26039557625439286,0.24154367057408829,0.2420828554901128,0.21270113189598344,0.27693273718938327,0.29164600843643645,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,{"$f":"IF(BV3,BV51,BV52)","v":0.2486891293137973},0.2486891293137973,0.2486891293137973]
[false,3]
[false,3,null,"Tax and Depreciation"]
[false,3,null,null,"Depreciation Rate"]
[false,3,null,null,null,"Historic",null,null,null,{"$f":"IF(J3,J22/I12)","v":0.10724886350338332},{"$f":"IF(K3,K22/J12)","v":9.8607618787250911E-2},7.7055117460121933E-2,8.8944320316082418E-2,0.10895079808688471,9.4937900713594064E-2,9.4452200929011271E-2,0.12757742299150948,0.10869047715981379,0.11896645701292953,9.7935052887789378E-2,0.10234162054520685,0.11765217090824796,7.2288843425080268E-2,0.10704507473028996,0.12609492979920348,9.7021944100535801E-2,0.1061534036377116,0.10886521224693846,8.163034340722175E-2,0.10563645910161881,0.10680030148577858,9.5886811717753748E-2,8.9226246207511323E-2,8.7816993883617855E-2,9.2939632283742954E-2,0.11144674658732931,0.10662254966356571,8.2988010016168706E-2,0.10843474683749582,0.12451212181622741,false,false,false,false,false,false,false,false,false,false,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(BW3,BW22/BV12)","v":false},false]
[false,3,null,null,null,"Projected","Last Period",null,null,{"$f":"IF(NOT(J3),I58,J57)","v":0.10724886350338332},{"$f":"IF(NOT(K3),J58,K57)","v":9.8607618787250911E-2},7.7055117460121933E-2,8.8944320316082418E-2,0.10895079808688471,9.4937900713594064E-2,9.4452200929011271E-2,0.12757742299150948,0.10869047715981379,0.11896645701292953,9.7935052887789378E-2,0.10234162054520685,0.11765217090824796,7.2288843425080268E-2,0.10704507473028996,0.12609492979920348,9.7021944100535801E-2,0.1061534036377116,0.10886521224693846,8.163034340722175E-2,0.10563645910161881,0.10680030148577858,9.5886811717753748E-2,8.9226246207511323E-2,8.7816993883617855E-2,9.2939632283742954E-2,0.11144674658732931,0.10662254966356571,8.2988010016168706E-2,0.10843474683749582,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,{"$f":"IF(NOT(BW3),BV58,BW57)","v":0.12451212181622741},0.12451212181622741]
[true,4,null,null,null,{"$f":"D55","v":"Tax and Depreciation"},null,null,null,{"$f":"IF(J3,J57,J58)","v":0.10724886350338332},{"$f":"IF(K3,K57,K58)","v":9.8607618787250911E-2},7.7055117460121933E-2,8.8944320316082418E-2,0.10895079808688471,9.4937900713594064E-2,9.4452200929011271E-2,0.12757742299150948,0.10869047715981379,0.11896645701292953,9.7935052887789378E-2,0.10234162054520685,0.11765217090824796,7.2288843425080268E-2,0.10704507473028996,0.12609492979920348,9.7021944100535801E-2,0.1061534036377116,0.10886521224693846,8.163034340722175E-2,0.10563645910161881,0.10680030148577858,9.5886811717753748E-2,8.9226246207511323E-2,8.7816993883617855E-2,9.2939632283742954E-2,0.11144674658732931,0.10662254966356571,8.2988010016168706E-2,0.10843474683749582,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,{"$f":"IF(BW3,BW57,BW58)","v":0.12451212181622741},0.12451212181622741]
[false,4]
[false,4,null,"Financing"]
[false,4,null,null,"Interest Expense Rate"]
[false,4,null,null,null,"Historic",null,null,null,{"$f":"IF(J3,J24/I16)","v":4.7906716815909745E-2},{"$f":"IF(K3,K24/J16)","v":4.9756414397844631E-2},4.1806345919895585E-2,4.2317539852041501E-2,5.1919831122806175E-2,4.4956940498678571E-2,5.2196504038862654E-2,5.5828896325135616E-2,5.8729421263075461E-2,5.6796386448927802E-2,5.2988256716922193E-2,4.7960923989853403E-2,5.8860891828794913E-2,3.8420297181221426E-2,5.6141138149015279E-2,6.2275164964285111E-2,4.7393775008031415E-2,5.4074130588451647E-2,5.3846642046905133E-2,4.0229965460177756E-2,5.1104486826354378E-2,5.4575543383160736E-2,4.9102812715286402E-2,4.6606705742000203E-2,4.3621032084081482E-2,5.016310434515342E-2,5.2364322220307659E-2,5.510937033994881E-2,4.4068256680050058E-2,5.1013482508512349E-2,5.9187510716444514E-2,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,{"$f":"IF(BW3,BW24/BV16)","v":false},false]
[false,4,null,null,null,"Projected",null,0.03,null,{"$f":"$H$64","v":0.03},{"$f":"$H$64","v":0.03},0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,{"$f":"$H$64","v":0.03},0.03]
[true,5,null,null,null,{"$f":"D61","v":"Financing"},"Fixed",null,null,{"$f":"IF(J3,J63,J64)","v":4.7906716815909745E-2},{"$f":"IF(K3,K63,K64)","v":4.9756414397844631E-2},4.1806345919895585E-2,4.2317539852041501E-2,5.1919831122806175E-2,4.4956940498678571E-2,5.2196504038862654E-2,5.5828896325135616E-2,5.8729421263075461E-2,5.6796386448927802E-2,5.2988256716922193E-2,4.7960923989853403E-2,5.8860891828794913E-2,3.8420297181221426E-2,5.6141138149015279E-2,6.2275164964285111E-2,4.7393775008031415E-2,5.4074130588451647E-2,5.3846642046905133E-2,4.0229965460177756E-2,5.1104486826354378E-2,5.4575543383160736E-2,4.9102812715286402E-2,4.6606705742000203E-2,4.3621032084081482E-2,5.016310434515342E-2,5.2364322220307659E-2,5.510937033994881E-2,4.4068256680050058E-2,5.1013482508512349E-2,5.9187510716444514E-2,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,{"$f":"IF(BW3,BW63,BW64)","v":0.03},0.03]
[false,5]
[false,5,null,null,"Interest Income Rate"]
[false,5,null,null,null,"Historic",null,null,null,{"$f":"IF(J3,J25/I10)","v":8.3319210140045639E-3},{"$f":"IF(K3,K25/J10)","v":1.2284083614056078E-2},9.9982353444429007E-3,1.0813084596590066E-2,1.084796823901891E-2,1.0213577641344094E-2,1.0553142157316535E-2,7.1142623142917225E-3,8.2240885309265745E-3,8.6654568264331096E-3,8.6613849745938443E-3,1.0529557810066714E-2,1.0229821214807059E-2,1.0939228866174447E-2,1.0023439290845093E-2,8.3833171387211677E-3,1.0932601203458349E-2,1.0288979955154993E-2,9.6562425923647655E-3,8.3056527664453015E-3,1.1534842858356152E-2,1.0952572962658298E-2,1.1774982634178435E-2,1.255766916693927E-2,5.8577499523327003E-3,1.0471839541946429E-2,9.6029050465020575E-3,1.142673794756916E-2,8.2760630309031552E-3,1.1482222947544729E-2,9.9978788174320994E-3,false,false,false,false,false,false,false,false,false,false,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(BW3,BW25/BV10)","v":false},false]
[false,5,null,null,null,"Projected",null,0.01,null,{"$f":"$H$69","v":0.01},{"$f":"$H$69","v":0.01},0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,{"$f":"$H$69","v":0.01},0.01]
[true,6,null,null,null,{"$f":"E67","v":"Interest Income Rate"},"Fixed",null,null,{"$f":"IF(J3,J68,J69)","v":8.3319210140045639E-3},{"$f":"IF(K3,K68,K69)","v":1.2284083614056078E-2},9.9982353444429007E-3,1.0813084596590066E-2,1.084796823901891E-2,1.0213577641344094E-2,1.0553142157316535E-2,7.1142623142917225E-3,8.2240885309265745E-3,8.6654568264331096E-3,8.6613849745938443E-3,1.0529557810066714E-2,1.0229821214807059E-2,1.0939228866174447E-2,1.0023439290845093E-2,8.3833171387211677E-3,1.0932601203458349E-2,1.0288979955154993E-2,9.6562425923647655E-3,8.3056527664453015E-3,1.1534842858356152E-2,1.0952572962658298E-2,1.1774982634178435E-2,1.255766916693927E-2,5.8577499523327003E-3,1.0471839541946429E-2,9.6029050465020575E-3,1.142673794756916E-2,8.2760630309031552E-3,1.1482222947544729E-2,9.9978788174320994E-3,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,{"$f":"IF(BW3,BW68,BW69)","v":0.01},0.01]
[]
[null,null,"Operating Analysis"]
[null,null,null,"Revenues"]
[null,null,null,null,"Revenue Growth",null,null,null,{"$f":"I40","v":0},{"$f":"J40","v":9.1587834898714249E-2},{"$f":"K40","v":-0.12077134262969014},-9.8046150011456001E-3,0.1902433357794493,0.25981234312264334,9.3446425392365029E-2,6.9383398237231386E-2,-0.4192904054461204,2.3339455035877199E-2,-6.042940711374456E-2,-7.4332432986150776E-2,-0.18231027026574043,-4.0911804520407435E-2,7.38670743926928E-2,0.12767109448583924,0.31543999583939675,8.5702833813665391E-2,-4.6098069460013269E-3,-0.14918108976269173,-5.5385185512334512E-2,-2.6258922619969205E-2,-3.7080951454164346E-2,-2.9853327197422175E-3,-4.1020843771126803E-2,0.12888361890619793,1.7170572330647671E-2,-0.18045007230213839,6.8103457673554857E-2,-0.1509506950389593,-0.13444398907216448,0.16407139029620055,0.05,0.05,0.05,0.05,0.05,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.2000000000000003E-2,4.2000000000000003E-2,0.04,0.04,0.04,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,{"$f":"BW40","v":0.03},0.03]
[null,null,null,null,"Total Revenues",null,null,null,{"$f":"IF(I3,I21,H75*(1+I74))","v":300},{"$f":"IF(J3,J21,I75*(1+J74))","v":327.47635046961426},{"$f":"IF(K3,K21,J75*(1+K74))","v":287.92659194392797},285.10358256132582,339.34263915046409,427.50804534956785,467.45714401396202,499.89090919592161,290.29144720033389,297.06669137956578,279.11512734625688,258.3678208473703,211.26471360071582,202.62149293582348,217.58854982807242,245.36831813220897,322.76729938295273,350.42937160245549,348.81395985115961,296.77751319612383,280.3404355718672,272.97899776693708,262.85667680273485,262.07196216487296,251.32154914811505,283.71277991143603,288.58429072003446,236.50923459434293,252.61633124194364,214.48372046278027,185.64767349272506,216.10714538793155,226.91250265732813,238.25812779019455,250.17103417970429,262.67958588868953,275.81356518312401,288.2251756163646,301.19530851910099,314.74909740246051,328.91280678557121,342.72714467056522,357.12168474672899,371.40655213659818,386.2628142220621,401.71332679094462,415.77329322862767,430.32535849162957,445.38674603883658,458.74834842000166,472.5107988726017,486.68612283877974,501.28670652394317,516.32530771966151,531.81506695125142,547.76951895978902,564.2026045285827,581.12868266444025,598.56254314437342,616.51941943870463,635.01500202186583,654.0654520825218,673.68741564499749,693.8980381143474,714.71497925777783,736.15642863551113,{"$f":"IF(BW3,BW21,BV75*(1+BW74))","v":758.24112149457653},780.9883551394139]
[]
[null,null,null,"Capital Expenditures"]
[null,null,null,null,"Cap Exp to Sales",null,null,null,{"$f":"I48","v":0.43333333333333335},{"$f":"J48","v":0.41384216710627236},{"$f":"K48","v":0.45961895215731541},0.38046543922275322,0.26132800909198595,0.213837567322714,0.17175830545403367,0.16730718063339947,0.34516969313370005,0.41037132356979461,0.5056308303914232,0.58527013734887257,0.683293714025062,0.84461815880468394,0.59246468077981485,0.59419075128117305,0.57360470307150291,0.49775292062613141,0.54200942988773748,0.68913936224393069,0.58625595098799299,0.6121893659847758,0.69383496248494481,0.67720924090032486,0.64561339982111154,0.51139336492068288,0.50330192156018327,0.64594035241479675,0.66538922278731316,0.69279402142637647,0.81189536648295124,0.83233132073934346,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,{"$f":"BW48","v":0.6},0.6]
[null,null,null,null,"Total Cap Exp",null,null,null,{"$f":"IF(I3,I29,I78*I75)","v":130},{"$f":"IF(J3,J29,J78*J75)","v":135.52352255439831},{"$f":"IF(K3,K29,K78*K75)","v":132.33651848749511},108.47205976317531,88.679736289210993,91.41728042844008,80.289646928220293,83.635338641836356,100.19980974947694,121.90765132993211,141.12921361489569,151.21496999386932,144.35585079867414,171.13779229771151,128.91353071523176,145.79558529157512,185.14084092374949,174.42724318830213,189.06045551581116,204.52106617231649,164.35124865657318,167.11483957010074,182.37915248834281,177.47755455893227,162.25655979382313,145.08883318991039,145.24502805147591,152.77085834322372,168.08818430845935,148.59303922990034,150.72648590708329,179.87274574194637,136.14750159439689,142.95487667411672,150.10262050782256,157.6077515332137,165.4881391098744,172.93510536981876,180.71718511146059,188.84945844147629,197.34768407134271,205.63628680233913,214.27301084803739,222.8439312819589,231.75768853323726,241.02799607456677,249.4639759371766,258.19521509497775,267.23204762330192,275.24900905200099,283.506479323561,292.01167370326783,300.77202391436589,309.79518463179687,319.08904017075082,328.66171137587338,338.52156271714961,348.67720959866415,359.13752588662402,369.91165166322276,381.00900121311946,392.43927124951307,404.21244938699846,416.33882286860842,428.8289875546667,441.69385718130667,{"$f":"IF(BW3,BW29,BW78*BW75)","v":454.94467289674589},468.59301308364832]
[]
[null,null,null,"Working Capital"]
[null,null,null,null,"A/R to Sales",null,null,null,{"$f":"I53","v":0.25},{"$f":"J53","v":0.27748290063417902},{"$f":"K53","v":0.2395806775617855},0.22895501716920938,0.22937188200833139,0.27105223538574769,0.24358229938633605,0.24199825416622592,0.24311037228520282,0.25673249495159517,0.22850349403471534,0.24612954896348821,0.2642001943858448,0.28454717413525876,0.23621250979258582,0.23777348264504325,0.24070537812927387,0.24714635792249043,0.24426628452355115,0.22978283484020257,0.22503035912132804,0.23534685806336242,0.28423919114200091,0.22710552494652092,0.26989483200683789,0.25,0.26039557625439286,0.24154367057408829,0.2420828554901128,0.21270113189598344,0.27693273718938327,0.29164600843643645,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,{"$f":"BW53","v":0.2486891293137973},0.2486891293137973]
[null,null,null,null,"A/R Amount",null,null,null,{"$f":"IF(I3,I11,I82*I75)","v":75},{"$f":"IF(J3,J11,J82*J75)","v":90.869087617403565},{"$f":"IF(K3,K11,K82*K75)","v":68.981647985981994},65.275895640331456,77.835659787616024,115.87701133739196,113.86428600349051,120.9727272989804,70.572861800083473,76.266672844891445,63.778781836564221,63.591955211842574,55.816178400178956,57.655373233955871,51.397137457018104,58.342079533052242,77.691824845738182,86.607342900613872,85.203489962789902,68.194378299030959,63.085108892966801,64.244749441734271,74.714169200683713,59.517990541218239,67.830387287028771,70.928194977859008,75.146072680008615,57.127308648585732,61.15408281048591,45.620930115695067,51.411918373181265,63.026786346982888,56.430672716265647,59.252206352078936,62.214816669682882,65.325557503167033,68.591835378325385,71.678467970350027,74.903999029015779,78.274678985321486,81.797039539660943,85.232515200326716,88.812280838740435,92.364772072290066,96.059362955181669,99.901737473388934,103.39829828495755,107.01723872493105,110.76284208030363,114.08572734271273,117.50829916299411,121.03354813788393,124.66455458202046,128.40449121948109,132.25662595606553,136.22432473474751,140.31105447678993,144.52038611109367,148.85599769442646,153.32167762525924,157.92132795401704,162.65896779263755,167.53873682641668,172.5648989312092,177.74184589914546,183.07410127611982,{"$f":"IF(BW3,BW11,BW82*BW75)","v":188.56632431440343},194.22331404383556]
[null,null,null,null,"Working Capital Change",null,null,null,{"$f":"I83-H83","v":75},{"$f":"J83-I83","v":15.869087617403565},-21.887439631421572,-3.7057523456505379,12.559764147284568,38.041351549775939,-2.0127253339014572,7.1084412954898966,-50.399865498896929,5.6938110448079726,-12.487891008327225,-0.18682662472164679,-7.7757768116636186,1.8391948337769151,-6.2582357769377666,6.9449420760341383,19.34974531268594,8.9155180548756903,-1.4038529378239701,-17.009111663758944,-5.1092694060641577,1.1596405487674701,10.469419758949442,-15.196178659465474,8.3123967458105312,3.097807690830237,4.2178777021496074,-18.018764031422883,4.0267741619001782,-15.533152694790843,5.7909882574861982,11.614867973801623,-6.596113630717241,2.8215336358132888,2.9626103176039464,3.1107408334841509,3.2662778751583517,3.0866325920246425,3.2255310586657515,3.3706799563057075,3.5223605543394569,3.435475660665773,3.5797656384137184,3.552491233549631,3.6945908828916032,3.8423745182072651,3.4965608115686138,3.6189404399734997,3.7456033553725803,3.3228852624091019,3.4225718202813766,3.5252489748898199,3.6310064441365313,3.7399366374606302,3.8521347365844463,3.967698778681978,4.0867297420424222,4.2093316343037372,4.335611583332792,4.4656799308327777,4.5996503287578037,4.7376398386205096,4.8797690337791266,5.0261621047925189,5.1769469679362601,{"$f":"BV83-BU83","v":5.3322553769743593},5.4922230382836119,5.6569897294321265]
[]
[null,null,"Depreciation and Taxes"]
[null,null,null,"Depreciation Rate",null,null,null,null,{"$f":"I59","v":0},{"$f":"J59","v":0.10724886350338332},{"$f":"K59","v":9.8607618787250911E-2},7.7055117460121933E-2,8.8944320316082418E-2,0.10895079808688471,9.4937900713594064E-2,9.4452200929011271E-2,0.12757742299150948,0.10869047715981379,0.11896645701292953,9.7935052887789378E-2,0.10234162054520685,0.11765217090824796,7.2288843425080268E-2,0.10704507473028996,0.12609492979920348,9.7021944100535801E-2,0.1061534036377116,0.10886521224693846,8.163034340722175E-2,0.10563645910161881,0.10680030148577858,9.5886811717753748E-2,8.9226246207511323E-2,8.7816993883617855E-2,9.2939632283742954E-2,0.11144674658732931,0.10662254966356571,8.2988010016168706E-2,0.10843474683749582,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,{"$f":"BW59","v":0.12451212181622741},0.12451212181622741]
[null,null,null,"Depreciation Expense",null,null,"Opening Balance",null,{"$f":"IF(I3,I22,I87*I91)","v":100},{"$f":"IF(J3,J22,J87*J91)","v":107.24886350338332},{"$f":"IF(K3,K22,K87*K91)","v":102.79732191345776},78.440045971673314,74.215181760931529,74.320984944953906,66.761266867861764,58.334875878335652,82.076776730366873,83.775116407640084,111.56093354991975,106.31920768759178,119.04296215282625,130.64445561362425,95.164254396332126,106.15045022428856,141.41603147980729,138.17480245254009,142.43111962754705,158.32389705562807,128.4240374281332,133.54987659238517,137.29165576026369,134.52119581456327,121.81273830294086,109.60679476146953,103.72694465498147,124.51604487940286,125.29860331419948,107.3023378691541,123.94345069775636,144.36365057072797,172.27951714800403,167.78064322592746,164.68953435684719,162.87328676275465,162.21766379882641,162.62487761915258,163.90862595279657,166.00149531831539,168.84634368595908,172.39510605194974,176.53403599885743,181.23299583249806,186.4140616960685,192.05989288440762,198.15701531393032,204.54535384507236,211.22541190444426,218.19891695358777,225.30234497057236,232.54946523733975,239.95323098131129,247.52590793570766,255.27918770109949,263.22428782487617,271.37204027739801,279.7329697953179,288.31736338023933,297.13533208127933,306.19686605040289,315.51188373711511,325.09027598206296,334.94194567542297,345.07684356396135,355.50500071890229,{"$f":"IF(BW3,BW22,BW87*BW91)","v":366.23655811395048},377.28179370787382]
[]
[null,null,null,"Net Plant"]
[null,null,null,null,"Opening balance",null,null,null,{"$f":"H94","v":0},{"$f":"I94","v":1000},{"$f":"J94","v":1042.4886350338331},1017.9732191345776,834.40045971673305,682.15181760931523,703.20984944953898,617.61266867861752,643.34875878335652,770.76776730366873,937.75116407640076,1085.6093354991974,1163.1920768759178,1110.4296215282625,1316.4445561362425,991.64254396332126,1121.5045022428856,1424.1603147980729,1341.748024525401,1454.3111962754704,1573.2389705562805,1264.2403742813319,1285.4987659238518,1402.9165576026369,1365.2119581456327,1248.1273830294085,1116.0679476146952,1117.2694465498146,1175.1604487940285,1292.9860331419948,1143.023378691541,1159.4345069775636,1383.6365057072796,1347.5044901536724,1322.6787236018617,1308.0918097528372,1302.8262745232964,1306.0967498343443,1316.4069775850105,1333.2155367436744,1356.0634998668354,1384.564840252219,1417.8060210026083,1455.5449958517881,1497.155931301249,1542.4995581384178,1591.4676613285769,1642.7746219518233,1696.4244832017287,1752.4311189205864,1809.4812110189996,1867.6853453719882,1927.1475538379161,1987.9663467709706,2050.2356234670597,2114.0454759367108,2179.482899487708,2246.6324219274597,2315.5766617308059,2386.3968242371907,2459.1731438191337,2533.9852789818501,2610.9126664942482,2690.0348398991837,2771.4317170923691,2855.1838610830746,{"$f":"BV94","v":2941.3727175454787},3030.080832328274]
[null,null,null,null,"Add: Cap Exp",null,null,null,{"$f":"I79","v":130},{"$f":"J79","v":135.52352255439831},{"$f":"K79","v":132.33651848749511},108.47205976317531,88.679736289210993,91.41728042844008,80.289646928220293,83.635338641836356,100.19980974947694,121.90765132993211,141.12921361489569,151.21496999386932,144.35585079867414,171.13779229771151,128.91353071523176,145.79558529157512,185.14084092374949,174.42724318830213,189.06045551581116,204.52106617231649,164.35124865657318,167.11483957010074,182.37915248834281,177.47755455893227,162.25655979382313,145.08883318991039,145.24502805147591,152.77085834322372,168.08818430845935,148.59303922990034,150.72648590708329,179.87274574194637,136.14750159439689,142.95487667411672,150.10262050782256,157.6077515332137,165.4881391098744,172.93510536981876,180.71718511146059,188.84945844147629,197.34768407134271,205.63628680233913,214.27301084803739,222.8439312819589,231.75768853323726,241.02799607456677,249.4639759371766,258.19521509497775,267.23204762330192,275.24900905200099,283.506479323561,292.01167370326783,300.77202391436589,309.79518463179687,319.08904017075082,328.66171137587338,338.52156271714961,348.67720959866415,359.13752588662402,369.91165166322276,381.00900121311946,392.43927124951307,404.21244938699846,416.33882286860842,428.8289875546667,441.69385718130667,{"$f":"BW79","v":454.94467289674589},468.59301308364832]
[null,null,null,null,"Less: Depreciation",null,null,null,{"$f":"I88","v":100},{"$f":"J88","v":107.24886350338332},{"$f":"K88","v":102.79732191345776},78.440045971673314,74.215181760931529,74.320984944953906,66.761266867861764,58.334875878335652,82.076776730366873,83.775116407640084,111.56093354991975,106.31920768759178,119.04296215282625,130.64445561362425,95.164254396332126,106.15045022428856,141.41603147980729,138.17480245254009,142.43111962754705,158.32389705562807,128.4240374281332,133.54987659238517,137.29165576026369,134.52119581456327,121.81273830294086,109.60679476146953,103.72694465498147,124.51604487940286,125.29860331419948,107.3023378691541,123.94345069775636,144.36365057072797,172.27951714800403,167.78064322592746,164.68953435684719,162.87328676275465,162.21766379882641,162.62487761915258,163.90862595279657,166.00149531831539,168.84634368595908,172.39510605194974,176.53403599885743,181.23299583249806,186.4140616960685,192.05989288440762,198.15701531393032,204.54535384507236,211.22541190444426,218.19891695358777,225.30234497057236,232.54946523733975,239.95323098131129,247.52590793570766,255.27918770109949,263.22428782487617,271.37204027739801,279.7329697953179,288.31736338023933,297.13533208127933,306.19686605040289,315.51188373711511,325.09027598206296,334.94194567542297,345.07684356396135,355.50500071890229,{"$f":"BW88","v":366.23655811395048},377.28179370787382]
[null,null,null,null,"Closing Balance",null,"History or Formula",null,{"$f":"IF(I3,I12,I91+I92-I93)","v":1000},{"$f":"IF(J3,J12,J91+J92-J93)","v":1042.4886350338331},{"$f":"IF(K3,K12,K91+K92-K93)","v":1017.9732191345776},834.40045971673305,682.15181760931523,703.20984944953898,617.61266867861752,643.34875878335652,770.76776730366873,937.75116407640076,1085.6093354991974,1163.1920768759178,1110.4296215282625,1316.4445561362425,991.64254396332126,1121.5045022428856,1424.1603147980729,1341.748024525401,1454.3111962754704,1573.2389705562805,1264.2403742813319,1285.4987659238518,1402.9165576026369,1365.2119581456327,1248.1273830294085,1116.0679476146952,1117.2694465498146,1175.1604487940285,1292.9860331419948,1143.023378691541,1159.4345069775636,1383.6365057072796,1347.5044901536724,1322.6787236018617,1308.0918097528372,1302.8262745232964,1306.0967498343443,1316.4069775850105,1333.2155367436744,1356.0634998668354,1384.564840252219,1417.8060210026083,1455.5449958517881,1497.155931301249,1542.4995581384178,1591.4676613285769,1642.7746219518233,1696.4244832017287,1752.4311189205864,1809.4812110189996,1867.6853453719882,1927.1475538379161,1987.9663467709706,2050.2356234670597,2114.0454759367108,2179.482899487708,2246.6324219274597,2315.5766617308059,2386.3968242371907,2459.1731438191337,2533.9852789818501,2610.9126664942482,2690.0348398991837,2771.4317170923691,2855.1838610830746,2941.3727175454787,{"$f":"IF(BW3,BW12,BW91+BW92-BW93)","v":3030.080832328274},3121.3920517040483]
[]
[null,null,"Financing"]
[null,null,null,"Interest Income Rate",null,null,null,null,{"$f":"I70","v":0},{"$f":"J70","v":8.3319210140045639E-3},{"$f":"K70","v":1.2284083614056078E-2},9.9982353444429007E-3,1.0813084596590066E-2,1.084796823901891E-2,1.0213577641344094E-2,1.0553142157316535E-2,7.1142623142917225E-3,8.2240885309265745E-3,8.6654568264331096E-3,8.6613849745938443E-3,1.0529557810066714E-2,1.0229821214807059E-2,1.0939228866174447E-2,1.0023439290845093E-2,8.3833171387211677E-3,1.0932601203458349E-2,1.0288979955154993E-2,9.6562425923647655E-3,8.3056527664453015E-3,1.1534842858356152E-2,1.0952572962658298E-2,1.1774982634178435E-2,1.255766916693927E-2,5.8577499523327003E-3,1.0471839541946429E-2,9.6029050465020575E-3,1.142673794756916E-2,8.2760630309031552E-3,1.1482222947544729E-2,9.9978788174320994E-3,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,{"$f":"BW70","v":0.01},0.01]
[]
[null,null,null,"Cash Balance"]
[null,null,null,null,"Opening Balance",null,null,null,{"$f":"H103","v":0},{"$f":"I103","v":100},83.319210140045641,102.35001440174297,102.33195314957464,110.65240663406419,120.03537927373338,122.59906659204616,129.38053781001796,92.044708434460603,75.698383096832799,65.596107055639848,56.815313604356817,59.824012909414492,61.198895641561982,66.946872578017235,67.103791299769782,56.255236367652842,61.501606481383533,63.278879629678563,61.103621267722524,50.750546102208553,58.539957426473492,64.116315494436137,75.496850151449124,94.806446734788707,55.535245884154129,58.155618382140283,55.846288124430281,63.814089974230832,52.812943088645952,60.640998705982433,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,62.698224608751566,98.795812732929818,136.44767137140329,175.66066765664704,216.44690116713525,258.82323535183554,302.81089278706793,348.43510648250214,395.72482042711204,444.7124334188195,495.43358096843093,547.92695072249853,602.23412742249934,658.39946391933347,716.46997520146999,776.49525277986766,{"$f":"BU103","v":838.52739710987214},902.62096602557654,968.83293742085016]
[null,null,null,null,"Add: New Cash",null,"Cash Flow",null,{"$f":"I140","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":"AO140","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2.0700889657046559,36.097588124178259,37.65185863847347,39.212996285243747,40.786233510488216,42.376334184700283,43.987657435232393,45.624213695434207,47.2897139446099,48.987612991707437,50.72114754961143,52.493369754067601,54.307176700000809,56.165336496834158,58.07051128213655,60.025277578397663,62.032144330004456,64.093568915704338,66.21197139527365,68.389747217092832]
[null,null,null,null,"Less: Cash Used",null,"Cash Flow",null,{"$f":"I137","v":0},0,0,0,0,0,0,0,0,0,0,0,0,19.814452896334785,0,0,0,0,0,0,0,0,7.1241531192915346,0,0,0,0,0,0,0,13.619462132634318,25.391721471706255,{"$f":"AO137","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]
[null,null,null,null,"Closing Balance",null,null,null,{"$f":"IF(I3,I10,I100+I101-I102)","v":100},{"$f":"IF(J3,J10,J100+J101-J102)","v":83.319210140045641},102.35001440174297,102.33195314957464,110.65240663406419,120.03537927373338,122.59906659204616,129.38053781001796,92.044708434460603,75.698383096832799,65.596107055639848,56.815313604356817,59.824012909414492,61.198895641561982,66.946872578017235,67.103791299769782,56.255236367652842,61.501606481383533,63.278879629678563,61.103621267722524,50.750546102208553,58.539957426473492,64.116315494436137,75.496850151449124,94.806446734788707,55.535245884154129,58.155618382140283,55.846288124430281,63.814089974230832,52.812943088645952,60.640998705982433,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,62.698224608751566,98.795812732929818,136.44767137140329,175.66066765664704,216.44690116713525,258.82323535183554,302.81089278706793,348.43510648250214,395.72482042711204,444.7124334188195,495.43358096843093,547.92695072249853,602.23412742249934,658.39946391933347,716.46997520146999,776.49525277986766,838.52739710987214,{"$f":"IF(BV3,BV10,BV100+BV101-BV102)","v":902.62096602557654},968.83293742085016,1037.2226846379431]
[]
[null,null,null,null,"Intrest Income",null,"Opening Balance",null,{"$f":"IF(I3,I25,I97*I100)","v":1},{"$f":"IF(J3,J25,J97*J100)","v":0.83319210140045641},{"$f":"IF(K3,K25,K97*K100)","v":1.0235001440174296},1.0233195314957464,1.1065240663406419,1.2003537927373338,1.2259906659204616,1.2938053781001795,0.92044708434460609,0.756983830968328,0.65596107055639852,0.56815313604356821,0.59824012909414492,0.61198895641561979,0.66946872578017236,0.67103791299769788,0.56255236367652839,0.61501606481383531,0.63278879629678564,0.6110362126772253,0.50750546102208549,0.58539957426473499,0.64116315494436138,0.75496850151449124,0.94806446734788707,0.55535245884154127,0.58155618382140284,0.55846288124430277,0.63814089974230837,0.52812943088645947,0.6064099870598243,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.62698224608751563,0.98795812732929822,1.364476713714033,1.7566066765664703,2.1644690116713527,2.5882323535183556,3.0281089278706794,3.4843510648250215,3.9572482042711203,4.447124334188195,4.9543358096843093,5.4792695072249851,6.0223412742249938,6.5839946391933353,7.1646997520147,7.7649525277986768,8.3852739710987212,{"$f":"IF(BW3,BW25,BW97*BW100)","v":9.0262096602557662},9.6883293742085019]
[]
[null,null,null,"Debt Balance"]
[null,null,null,null,"Opening Balance",null,null,null,{"$f":"H111","v":0},{"$f":"I111","v":470},{"$f":"J111","v":450.32313806955153},448.12929341452821,374.69296514652308,317.12168969735177,329.29809148930894,296.08469410826547,309.0917186373498,345.12499029525179,405.37981886929344,460.48217702193489,488.00295619210988,468.10145377507081,551.05738071112171,423.43576661653543,475.44331741706213,592.16622046629027,561.29985240271378,607.03603036205959,653.73703672960119,525.99636815341626,537.61548934013013,586.81314923882917,576.28352331883275,537.17353190567894,468.64127739953977,470.17002597278201,492.40269476738354,542.72004924649025,478.33452871207476,488.03020227341841,577.70585654013064,519.81449088798604,475.61452549436541,435.26248379716208,398.1658070137251,363.79967678780486,331.07950151049238,299.92936017685412,270.00560220221274,241.00027258594534,212.19360427801342,183.58109597522247,154.63556074572335,125.34739164176274,95.558151944643356,64.219347494342827,31.704266952958733,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BV111","v":0},0]
[null,null,null,null,"Add: New Debt",null,"Cash Flow",null,{"$f":"I141","v":16.25},0,0,0,0,0,0,0,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":"AO141","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]
[null,null,null,null,"Less: Debt Repaid",null,"Cash Flow",null,{"$f":"I138","v":0},55.128514413658365,74.22139580926482,68.149842486059597,98.164629809938788,113.82360777818087,182.04316182684667,181.28872232291869,128.21626649956136,53.063437962614728,55.512633951249668,19.399373561552366,17.170347609930793,0,23.469947371384983,11.468292831711814,13.078199865125555,47.234337506659045,43.106430800463031,24.000842805416951,32.244100776166796,21.842269614422037,0,21.985599258037766,3.0428811219262641,37.034790750144438,35.229239376473586,33.729709496509606,3.5935780264209214,16.138844128499059,0,0,{"$f":"AO138","v":57.891365652144657},44.199965393620644,40.352041697203326,37.096676783436983,34.366130225920216,32.720175277312492,31.150141333638274,29.92375797464139,29.005329616267403,28.806668307931901,28.612508302790957,28.9455352294991,29.288169103960612,29.789239697119385,31.338804450300529,32.515080541384094,31.704266952958733,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Closing Balance",null,null,null,{"$f":"IF(I3,I16,I108+I109-I110)","v":470},{"$f":"IF(J3,J16,J108+J109-J110)","v":450.32313806955153},448.12929341452821,374.69296514652308,317.12168969735177,329.29809148930894,296.08469410826547,309.0917186373498,345.12499029525179,405.37981886929344,460.48217702193489,488.00295619210988,468.10145377507081,551.05738071112171,423.43576661653543,475.44331741706213,592.16622046629027,561.29985240271378,607.03603036205959,653.73703672960119,525.99636815341626,537.61548934013013,586.81314923882917,576.28352331883275,537.17353190567894,468.64127739953977,470.17002597278201,492.40269476738354,542.72004924649025,478.33452871207476,488.03020227341841,577.70585654013064,{"$f":"IF(AO3,AO16,AO108+AO109-AO110)","v":519.81449088798604},475.61452549436541,435.26248379716208,398.1658070137251,363.79967678780486,331.07950151049238,299.92936017685412,270.00560220221274,241.00027258594534,212.19360427801342,183.58109597522247,154.63556074572335,125.34739164176274,95.558151944643356,64.219347494342827,31.704266952958733,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(BV3,BV16,BV108+BV109-BV110)","v":0},0,0]
[null,null,null,null,null,null,null,null,{"$f":"I65","v":0},{"$f":"J65","v":4.7906716815909745E-2},{"$f":"K65","v":4.9756414397844631E-2},4.1806345919895585E-2,4.2317539852041501E-2,5.1919831122806175E-2,4.4956940498678571E-2,5.2196504038862654E-2,5.5828896325135616E-2,5.8729421263075461E-2,5.6796386448927802E-2,5.2988256716922193E-2,4.7960923989853403E-2,5.8860891828794913E-2,3.8420297181221426E-2,5.6141138149015279E-2,6.2275164964285111E-2,4.7393775008031415E-2,5.4074130588451647E-2,5.3846642046905133E-2,4.0229965460177756E-2,5.1104486826354378E-2,5.4575543383160736E-2,4.9102812715286402E-2,4.6606705742000203E-2,4.3621032084081482E-2,5.016310434515342E-2,5.2364322220307659E-2,5.510937033994881E-2,4.4068256680050058E-2,5.1013482508512349E-2,5.9187510716444514E-2,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,{"$f":"BW65","v":0.03},0.03]
[null,null,null,null,"Interest Expense",null,"Opening Balance",null,{"$f":"IF(I3,I24,I112*I108)","v":23.5},{"$f":"IF(J3,J24,J112*J108)","v":22.516156903477579},{"$f":"IF(K3,K24,K112*K108)","v":22.406464670726411},18.734648257326153,15.856084484867589,16.464904574465447,14.804234705413274,15.454585931867491,17.25624951476259,20.268990943464672,23.024108851096745,24.400147809605496,23.405072688753542,27.552869035556085,21.171788330826772,23.772165870853108,29.608311023314513,28.064992620135691,30.351801518102981,32.686851836480059,26.299818407670813,26.880774467006507,29.340657461941461,28.814176165941639,26.858676595283949,23.432063869976989,23.508501298639104,24.620134738369178,27.136002462324512,23.916726435603739,24.401510113670923,28.885292827006534,17.331175696203918,15.59443472663958,14.268435764830961,13.057874513914863,11.944974210411752,10.913990303634145,9.9323850453147706,8.9978808053056234,8.1001680660663826,7.2300081775783598,6.3658081283404027,5.5074328792566742,4.6390668223717002,3.760421749252882,2.8667445583393008,1.9265804248302847,0.9511280085887619,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(BW3,BW24,BW112*BW108)","v":0},0]
[]
[null,null,"Profit and Loss"]
[null,null,null,"Revenues",null,null,null,null,{"$f":"I75","v":300},{"$f":"J75","v":327.47635046961426},{"$f":"K75","v":287.92659194392797},285.10358256132582,339.34263915046409,427.50804534956785,467.45714401396202,499.89090919592161,290.29144720033389,297.06669137956578,279.11512734625688,258.3678208473703,211.26471360071582,202.62149293582348,217.58854982807242,245.36831813220897,322.76729938295273,350.42937160245549,348.81395985115961,296.77751319612383,280.3404355718672,272.97899776693708,262.85667680273485,262.07196216487296,251.32154914811505,283.71277991143603,288.58429072003446,236.50923459434293,252.61633124194364,214.48372046278027,185.64767349272506,216.10714538793155,226.91250265732813,238.25812779019455,250.17103417970429,262.67958588868953,275.81356518312401,288.2251756163646,301.19530851910099,314.74909740246051,328.91280678557121,342.72714467056522,357.12168474672899,371.40655213659818,386.2628142220621,401.71332679094462,415.77329322862767,430.32535849162957,445.38674603883658,458.74834842000166,472.5107988726017,486.68612283877974,501.28670652394317,516.32530771966151,531.81506695125142,547.76951895978902,564.2026045285827,581.12868266444025,598.56254314437342,616.51941943870463,635.01500202186583,654.0654520825218,673.68741564499749,693.8980381143474,714.71497925777783,736.15642863551113,{"$f":"BW75","v":758.24112149457653},780.9883551394139]
[null,null,null,"Less: Depreciation",null,null,null,null,{"$f":"I88","v":100},{"$f":"J88","v":107.24886350338332},{"$f":"K88","v":102.79732191345776},78.440045971673314,74.215181760931529,74.320984944953906,66.761266867861764,58.334875878335652,82.076776730366873,83.775116407640084,111.56093354991975,106.31920768759178,119.04296215282625,130.64445561362425,95.164254396332126,106.15045022428856,141.41603147980729,138.17480245254009,142.43111962754705,158.32389705562807,128.4240374281332,133.54987659238517,137.29165576026369,134.52119581456327,121.81273830294086,109.60679476146953,103.72694465498147,124.51604487940286,125.29860331419948,107.3023378691541,123.94345069775636,144.36365057072797,172.27951714800403,167.78064322592746,164.68953435684719,162.87328676275465,162.21766379882641,162.62487761915258,163.90862595279657,166.00149531831539,168.84634368595908,172.39510605194974,176.53403599885743,181.23299583249806,186.4140616960685,192.05989288440762,198.15701531393032,204.54535384507236,211.22541190444426,218.19891695358777,225.30234497057236,232.54946523733975,239.95323098131129,247.52590793570766,255.27918770109949,263.22428782487617,271.37204027739801,279.7329697953179,288.31736338023933,297.13533208127933,306.19686605040289,315.51188373711511,325.09027598206296,334.94194567542297,345.07684356396135,355.50500071890229,{"$f":"BW88","v":366.23655811395048},377.28179370787382]
[null,null,null,"EBIT",null,null,null,null,{"$f":"I116-I117","v":200},{"$f":"J116-J117","v":220.22748696623094},{"$f":"K116-K117","v":185.1292700304702},206.66353658965249,265.12745738953254,353.18706040461393,400.69587714610026,441.55603331758596,208.21467046996702,213.29157497192568,167.55419379633713,152.04861315977851,92.221751447889574,71.977037322199237,122.42429543174029,139.21786790792041,181.35126790314544,212.2545691499154,206.38284022361256,138.45361614049577,151.916398143734,139.42912117455191,125.56502104247116,127.55076635030969,129.5088108451742,174.1059851499665,184.85734606505298,111.99318971494007,127.31772792774416,107.18138259362617,61.7042227949687,71.743494817203583,54.632985509324101,70.477484564267087,85.481499822857103,99.806299125934885,113.5959013842976,125.60029799721201,137.28668256630442,148.74760208414511,160.06646309961212,170.33203861861548,180.58764874787155,190.17355630410012,199.8487525259936,209.653433906537,217.61627791469735,225.78000464655722,234.16133413439232,240.54943146641389,247.20845390202933,254.13665760143999,261.33347554263185,268.79939978395385,276.53587925015194,284.54523113491285,292.83056425118468,301.39571286912235,310.24517976413409,319.3840873574253,328.81813597146294,338.55356834540669,348.59713966293452,358.95609243892443,369.63813569381648,380.65142791660884,{"$f":"BW116-BW117","v":392.00456338062605},403.70656143154008]
[null,null,null,"Less: Interest Expense",null,null,null,null,{"$f":"I113","v":23.5},{"$f":"J113","v":22.516156903477579},{"$f":"K113","v":22.406464670726411},18.734648257326153,15.856084484867589,16.464904574465447,14.804234705413274,15.454585931867491,17.25624951476259,20.268990943464672,23.024108851096745,24.400147809605496,23.405072688753542,27.552869035556085,21.171788330826772,23.772165870853108,29.608311023314513,28.064992620135691,30.351801518102981,32.686851836480059,26.299818407670813,26.880774467006507,29.340657461941461,28.814176165941639,26.858676595283949,23.432063869976989,23.508501298639104,24.620134738369178,27.136002462324512,23.916726435603739,24.401510113670923,28.885292827006534,17.331175696203918,15.59443472663958,14.268435764830961,13.057874513914863,11.944974210411752,10.913990303634145,9.9323850453147706,8.9978808053056234,8.1001680660663826,7.2300081775783598,6.3658081283404027,5.5074328792566742,4.6390668223717002,3.760421749252882,2.8667445583393008,1.9265804248302847,0.9511280085887619,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BW113","v":0},0]
[null,null,null,"Add: Interest Income",null,null,null,null,{"$f":"I105","v":1},{"$f":"J105","v":0.83319210140045641},{"$f":"K105","v":1.0235001440174296},1.0233195314957464,1.1065240663406419,1.2003537927373338,1.2259906659204616,1.2938053781001795,0.92044708434460609,0.756983830968328,0.65596107055639852,0.56815313604356821,0.59824012909414492,0.61198895641561979,0.66946872578017236,0.67103791299769788,0.56255236367652839,0.61501606481383531,0.63278879629678564,0.6110362126772253,0.50750546102208549,0.58539957426473499,0.64116315494436138,0.75496850151449124,0.94806446734788707,0.55535245884154127,0.58155618382140284,0.55846288124430277,0.63814089974230837,0.52812943088645947,0.6064099870598243,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.62698224608751563,0.98795812732929822,1.364476713714033,1.7566066765664703,2.1644690116713527,2.5882323535183556,3.0281089278706794,3.4843510648250215,3.9572482042711203,4.447124334188195,4.9543358096843093,5.4792695072249851,6.0223412742249938,6.5839946391933353,7.1646997520147,7.7649525277986768,8.3852739710987212,{"$f":"BW105","v":9.0262096602557662},9.6883293742085019]
[null,null,null,"Net Income",null,null,null,null,{"$f":"I118-I119+I120","v":177.5},{"$f":"J118-J119+J120","v":198.54452216415382},163.74630550376119,188.95220786382211,250.37789697100561,337.92250962288585,387.11763310660746,427.39525276381863,191.87886803954902,193.77956785942933,145.18604601579679,128.21661848621659,69.41491888823019,45.036157243058774,101.9219758266937,116.116739950065,152.30550924350746,184.80459259459354,176.66382750180637,106.37780051669293,126.12408519708528,113.13374628181015,96.865526735474063,99.491558685882552,103.59819871723813,151.22927373883107,161.93040095023528,87.931517857815194,100.81986636516196,83.792785588908899,37.909122668357604,43.464483346627517,37.908091169550659,55.489331194057982,71.819345414456606,87.354705968450489,102.25720853031632,115.29258905000833,127.96057887742012,140.35600263526996,152.57257638997621,163.70831179746759,174.82812197596161,185.27240478127391,195.81596706005237,206.49929351371458,215.35581471278851,224.45970557815738,233.81648748223401,241.17641371250141,248.19641202935864,255.50113431515402,263.09008221919834,270.96386879562522,279.12411160367031,287.57334006278353,296.31491531600972,305.35296107339349,314.69230409832227,324.33842316710962,334.29740547868795,344.57590961963166,355.18113430212787,366.12079219093914,377.40308822161518,{"$f":"BV118-BV119+BV120","v":389.03670188770758},401.0307730408818,413.39489080574856]
[null,null,null,"Shares",null,null,null,null,{"$f":"IF(I3,I31,H122)","v":100},{"$f":"IF(J3,J31,I122)","v":100},100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,{"$f":"IF(BV3,BV31,BU122)","v":100},100,100]
[null,null,null,"EPS",null,null,null,null,{"$f":"I121/I122","v":1.7749999999999999},{"$f":"J121/J122","v":1.9854452216415381},1.6374630550376119,1.8895220786382212,2.5037789697100563,3.3792250962288586,3.8711763310660747,4.273952527638186,1.9187886803954901,1.9377956785942934,1.4518604601579679,1.2821661848621659,0.69414918888230193,0.45036157243058772,1.0192197582669369,1.16116739950065,1.5230550924350745,1.8480459259459354,1.7666382750180636,1.0637780051669292,1.2612408519708529,1.1313374628181014,0.96865526735474061,0.99491558685882553,1.0359819871723814,1.5122927373883106,1.6193040095023528,0.87931517857815189,1.0081986636516196,0.83792785588908902,0.37909122668357603,0.43464483346627519,0.37908091169550656,0.55489331194057978,0.71819345414456603,0.87354705968450486,1.0225720853031632,1.1529258905000832,1.2796057887742012,1.4035600263526995,1.5257257638997621,1.6370831179746759,1.748281219759616,1.8527240478127391,1.9581596706005238,2.0649929351371457,2.1535581471278853,2.2445970557815738,2.3381648748223403,2.4117641371250143,2.4819641202935863,2.55501134315154,2.6309008221919834,2.709638687956252,2.7912411160367032,2.8757334006278352,2.9631491531600971,3.0535296107339347,3.1469230409832227,3.2433842316710964,3.3429740547868794,3.4457590961963165,3.5518113430212788,3.6612079219093916,3.7740308822161519,{"$f":"BV121/BV122","v":3.8903670188770758},4.0103077304088179,4.1339489080574854]
[]
[null,null,"Cash Flow"]
[null,null,null,"Dividend Payout",null,null,null,0.6,{"$f":"IF(I3,I30/I26,$H$126)","v":0.5},0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,{"$f":"IF(AO3,AO30/AO26,$H$126)","v":0.6},0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6]
[]
[null,null,null,"EBITDA",null,null,null,null,{"$f":"I116","v":300},327.47635046961426,287.92659194392797,285.10358256132582,339.34263915046409,427.50804534956785,467.45714401396202,499.89090919592161,290.29144720033389,297.06669137956578,279.11512734625688,258.3678208473703,211.26471360071582,202.62149293582348,217.58854982807242,245.36831813220897,322.76729938295273,350.42937160245549,348.81395985115961,296.77751319612383,280.3404355718672,272.97899776693708,262.85667680273485,262.07196216487296,251.32154914811505,283.71277991143603,288.58429072003446,236.50923459434293,252.61633124194364,214.48372046278027,185.64767349272506,216.10714538793155,{"$f":"AO116","v":226.91250265732813},238.25812779019455,250.17103417970429,262.67958588868953,275.81356518312401,288.2251756163646,301.19530851910099,314.74909740246051,328.91280678557121,342.72714467056522,357.12168474672899,371.40655213659818,386.2628142220621,401.71332679094462,415.77329322862767,430.32535849162957,445.38674603883658,458.74834842000166,472.5107988726017,486.68612283877974,501.28670652394317,516.32530771966151,531.81506695125142,547.76951895978902,564.2026045285827,581.12868266444025,598.56254314437342,616.51941943870463,635.01500202186583,654.0654520825218,673.68741564499749,693.8980381143474,714.71497925777783,736.15642863551113,758.24112149457653,780.9883551394139]
[null,null,null,"Less: WC Changes",null,null,null,null,{"$f":"I84","v":75},15.869087617403565,-21.887439631421572,-3.7057523456505379,12.559764147284568,38.041351549775939,-2.0127253339014572,7.1084412954898966,-50.399865498896929,5.6938110448079726,-12.487891008327225,-0.18682662472164679,-7.7757768116636186,1.8391948337769151,-6.2582357769377666,6.9449420760341383,19.34974531268594,8.9155180548756903,-1.4038529378239701,-17.009111663758944,-5.1092694060641577,1.1596405487674701,10.469419758949442,-15.196178659465474,8.3123967458105312,3.097807690830237,4.2178777021496074,-18.018764031422883,4.0267741619001782,-15.533152694790843,5.7909882574861982,11.614867973801623,{"$f":"AO84","v":-6.596113630717241},2.8215336358132888,2.9626103176039464,3.1107408334841509,3.2662778751583517,3.0866325920246425,3.2255310586657515,3.3706799563057075,3.5223605543394569,3.435475660665773,3.5797656384137184,3.552491233549631,3.6945908828916032,3.8423745182072651,3.4965608115686138,3.6189404399734997,3.7456033553725803,3.3228852624091019,3.4225718202813766,3.5252489748898199,3.6310064441365313,3.7399366374606302,3.8521347365844463,3.967698778681978,4.0867297420424222,4.2093316343037372,4.335611583332792,4.4656799308327777,4.5996503287578037,4.7376398386205096,4.8797690337791266,5.0261621047925189,5.1769469679362601,5.3322553769743593,5.4922230382836119,5.6569897294321265]
[null,null,null,null,"Cash From Operations",null,null,null,{"$f":"I128-I129","v":225},{"$f":"J128-J129","v":311.60726285221068},{"$f":"K128-K129","v":309.81403157534953},288.80933490697635,326.78287500317953,389.46669379979193,469.46986934786349,492.7824679004317,340.69131269923082,291.37288033475784,291.60301835458409,258.55464747209192,219.04049041237943,200.78229810204658,223.84678560501018,238.42337605617485,303.41755407026676,341.5138535475798,350.21781278898357,313.78662485988275,285.44970497793133,271.81935721816961,252.38725704378541,277.26814082433845,243.00915240230452,280.61497222060581,284.36641301788484,254.5279986257658,248.58955708004345,230.01687315757113,179.85668523523887,204.49227741412994,233.50861628804537,235.43659415438125,247.20842386210035,259.56884505520537,272.54728730796569,285.13854302433992,297.96977746043524,311.3784174461548,325.39044623123175,339.29166900989946,353.54191910831526,367.85406090304855,382.56822333917052,397.87095227273733,412.27673241705907,426.7064180516561,441.64114268346401,455.42546315759256,469.08822705232035,483.16087386388995,497.65570007980665,512.58537108220094,527.96293221466703,543.80182018110702,560.1158747865403,576.91935103013657,594.2269315610406,612.0537395078718,630.41535169310805,649.32781224390123,668.80764661121839,688.87187600955485,709.53803228984157,730.8241732585368,{"$f":"BW128-BW129","v":752.74889845629286},775.3313654099818]
[null,null,null,"Less: Captial Expendtitures",null,null,null,null,{"$f":"I92","v":130},135.52352255439831,132.33651848749511,108.47205976317531,88.679736289210993,91.41728042844008,80.289646928220293,83.635338641836356,100.19980974947694,121.90765132993211,141.12921361489569,151.21496999386932,144.35585079867414,171.13779229771151,128.91353071523176,145.79558529157512,185.14084092374949,174.42724318830213,189.06045551581116,204.52106617231649,164.35124865657318,167.11483957010074,182.37915248834281,177.47755455893227,162.25655979382313,145.08883318991039,145.24502805147591,152.77085834322372,168.08818430845935,148.59303922990034,150.72648590708329,179.87274574194637,{"$f":"AO92","v":136.14750159439689},142.95487667411672,150.10262050782256,157.6077515332137,165.4881391098744,172.93510536981876,180.71718511146059,188.84945844147629,197.34768407134271,205.63628680233913,214.27301084803739,222.8439312819589,231.75768853323726,241.02799607456677,249.4639759371766,258.19521509497775,267.23204762330192,275.24900905200099,283.506479323561,292.01167370326783,300.77202391436589,309.79518463179687,319.08904017075082,328.66171137587338,338.52156271714961,348.67720959866415,359.13752588662402,369.91165166322276,381.00900121311946,392.43927124951307,404.21244938699846,416.33882286860842,428.8289875546667,441.69385718130667,454.94467289674589,468.59301308364832]
[null,null,null,null,"Cash before Financing",null,null,null,{"$f":"I130-I131","v":95},{"$f":"J130-J131","v":176.08374029781237},{"$f":"K130-K131","v":177.47751308785442},180.33727514380104,238.10313871396852,298.04941337135187,389.1802224196432,409.14712925859533,240.49150294975388,169.46522900482574,150.4738047396884,107.3396774782226,74.684639613705286,29.644505804335068,94.933254889778425,92.627790764599723,118.27671314651727,167.08661035927767,161.15735727317241,109.26555868756626,121.09845632135816,104.70451764806887,70.0081045554426,99.790586265406176,80.752592608481393,135.52613903069542,139.12138496640893,101.75714028254208,80.501372771584101,81.423833927670785,29.130199328155584,24.61953167218357,97.361114693648489,92.481717480264535,97.105803354277782,101.96109352199167,107.05914819809129,112.20343765452117,117.25259234897464,122.52895900467851,128.04276215988904,133.65538220756034,139.26890826027787,145.01012962108965,150.81053480593326,156.84295619817055,162.81275647988247,168.51120295667835,174.40909506016209,180.17645410559157,185.58174772875935,191.14920016062212,196.88367616544076,202.79018645040406,208.87389204391621,215.14010880523364,221.5943120693907,228.24214143147242,235.08940567441658,242.14208784464904,249.40635047998859,256.88854099438817,264.59519722421993,272.53305314094644,280.70904473517487,289.13031607723013,{"$f":"BW130-BW131","v":297.80422555954698},306.73835232633348]
[null,null,null,"Less: Interest Expense",null,null,null,null,{"$f":"I119","v":23.5},22.516156903477579,22.406464670726411,18.734648257326153,15.856084484867589,16.464904574465447,14.804234705413274,15.454585931867491,17.25624951476259,20.268990943464672,23.024108851096745,24.400147809605496,23.405072688753542,27.552869035556085,21.171788330826772,23.772165870853108,29.608311023314513,28.064992620135691,30.351801518102981,32.686851836480059,26.299818407670813,26.880774467006507,29.340657461941461,28.814176165941639,26.858676595283949,23.432063869976989,23.508501298639104,24.620134738369178,27.136002462324512,23.916726435603739,24.401510113670923,28.885292827006534,{"$f":"AO119","v":17.331175696203918},15.59443472663958,14.268435764830961,13.057874513914863,11.944974210411752,10.913990303634145,9.9323850453147706,8.9978808053056234,8.1001680660663826,7.2300081775783598,6.3658081283404027,5.5074328792566742,4.6390668223717002,3.760421749252882,2.8667445583393008,1.9265804248302847,0.9511280085887619,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Add: Interest Income",null,null,null,null,{"$f":"I120","v":1},0.83319210140045641,1.0235001440174296,1.0233195314957464,1.1065240663406419,1.2003537927373338,1.2259906659204616,1.2938053781001795,0.92044708434460609,0.756983830968328,0.65596107055639852,0.56815313604356821,0.59824012909414492,0.61198895641561979,0.66946872578017236,0.67103791299769788,0.56255236367652839,0.61501606481383531,0.63278879629678564,0.6110362126772253,0.50750546102208549,0.58539957426473499,0.64116315494436138,0.75496850151449124,0.94806446734788707,0.55535245884154127,0.58155618382140284,0.55846288124430277,0.63814089974230837,0.52812943088645947,0.6064099870598243,0.6062813564304691,{"$f":"AO120","v":0.6062813564304691},0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.6062813564304691,0.62698224608751563,0.98795812732929822,1.364476713714033,1.7566066765664703,2.1644690116713527,2.5882323535183556,3.0281089278706794,3.4843510648250215,3.9572482042711203,4.447124334188195,4.9543358096843093,5.4792695072249851,6.0223412742249938,6.5839946391933353,7.1646997520147,7.7649525277986768,8.3852739710987212,9.0262096602557662,9.6883293742085019]
[null,null,null,"Less: Dividends",null,null,"Payout",null,{"$f":"MAX(I126*I121,0)","v":88.75},99.272261082076909,81.873152751880596,94.476103931911055,125.18894848550281,168.96125481144293,193.55881655330373,213.69762638190932,95.939434019774509,96.889783929714667,72.593023007898395,64.108309243108295,34.707459444115095,22.518078621529387,50.960987913346848,58.058369975032498,76.152754621753729,92.402296297296772,88.331913750903183,53.188900258346465,63.062042598542639,56.566873140905074,48.432763367737032,49.745779342941276,51.799099358619067,75.614636869415534,80.965200475117641,43.965758928907597,50.409933182580978,41.896392794454449,18.954561334178802,21.732241673313759,{"$f":"MAX(AO126*AO121,0)","v":22.744854701730393},33.293598716434786,43.091607248673959,52.412823581070292,61.354325118189792,69.175553430004996,76.776347326452068,84.213601581161967,91.543545833985718,98.224987078480552,104.89687318557696,111.16344286876434,117.48958023603141,123.89957610822874,129.2134888276731,134.67582334689442,140.28989248934039,144.70584822750084,148.91784721761519,153.30068058909239,157.85404933151901,162.57832127737512,167.47446696220217,172.54400403767011,177.78894918960583,183.21177664403609,188.81538245899335,194.60305390026576,200.57844328721276,206.74554577177898,213.10868058127673,219.67247531456348,226.44185293296911,233.42202113262454,240.61846382452907,248.03693448344913]
[null,null,null,null,"Net Cash Flow",null,null,null,{"$f":"I132-I133+I134-I135","v":-16.25},{"$f":"J132-J133+J134-J135","v":55.128514413658365},{"$f":"K132-K133+K134-K135","v":74.22139580926482},68.149842486059597,98.164629809938788,113.82360777818087,182.04316182684667,181.28872232291869,128.21626649956136,53.063437962614728,55.512633951249668,19.399373561552366,17.170347609930793,-19.814452896334785,23.469947371384983,11.468292831711814,13.078199865125555,47.234337506659045,43.106430800463031,24.000842805416951,32.244100776166796,21.842269614422037,-7.1241531192915346,21.985599258037766,3.0428811219262641,37.034790750144438,35.229239376473586,33.729709496509606,3.5935780264209214,16.138844128499059,-13.619462132634318,-25.391721471706255,57.891365652144657,44.199965393620644,40.352041697203326,37.096676783436983,34.366130225920216,32.720175277312492,31.150141333638274,29.92375797464139,29.005329616267403,28.806668307931901,28.612508302790957,28.9455352294991,29.288169103960612,29.789239697119385,31.338804450300529,32.515080541384094,33.774355918663389,36.097588124178259,37.65185863847347,39.212996285243747,40.786233510488216,42.376334184700283,43.987657435232393,45.624213695434207,47.2897139446099,48.987612991707437,50.72114754961143,52.493369754067601,54.307176700000809,56.165336496834158,58.07051128213655,60.025277578397663,62.032144330004456,64.093568915704338,{"$f":"BW132-BW133+BW134-BW135","v":66.21197139527365},68.389747217092832]
[null,null,null,"Add: Reduction in Cash when Negative",null,null,null,null,{"$f":"MIN(I100,MAX(-I136,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,19.814452896334785,0,0,0,0,0,0,0,0,7.1241531192915346,0,0,0,0,0,0,0,13.619462132634318,25.391721471706255,{"$f":"MIN(AO100,MAX(-AO136,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,{"$f":"MIN(BU100,MAX(-BU136,0))","v":0},0,0,0]
[null,null,null,"Less: Reduction in Debt when Positive",null,null,null,null,{"$f":"MIN(I108,MAX(I136,0))","v":0},55.128514413658365,74.22139580926482,68.149842486059597,98.164629809938788,113.82360777818087,182.04316182684667,181.28872232291869,128.21626649956136,53.063437962614728,55.512633951249668,19.399373561552366,17.170347609930793,0,23.469947371384983,11.468292831711814,13.078199865125555,47.234337506659045,43.106430800463031,24.000842805416951,32.244100776166796,21.842269614422037,0,21.985599258037766,3.0428811219262641,37.034790750144438,35.229239376473586,33.729709496509606,3.5935780264209214,16.138844128499059,0,0,{"$f":"MIN(AO108,MAX(AO136,0))","v":57.891365652144657},44.199965393620644,40.352041697203326,37.096676783436983,34.366130225920216,32.720175277312492,31.150141333638274,29.92375797464139,29.005329616267403,28.806668307931901,28.612508302790957,28.9455352294991,29.288169103960612,29.789239697119385,31.338804450300529,32.515080541384094,31.704266952958733,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Remaining Cash Flow",null,null,null,{"$f":"I136+I137-I138","v":-16.25},{"$f":"J136+J137-J138","v":0},{"$f":"K136+K137-K138","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,2.0700889657046559,36.097588124178259,37.65185863847347,39.212996285243747,40.786233510488216,42.376334184700283,43.987657435232393,45.624213695434207,47.2897139446099,48.987612991707437,50.72114754961143,52.493369754067601,54.307176700000809,56.165336496834158,58.07051128213655,60.025277578397663,62.032144330004456,64.093568915704338,{"$f":"BW136+BW137-BW138","v":66.21197139527365},68.389747217092832]
[null,null,null,"Less: Addition in Cash when Positive",null,null,null,null,{"$f":"MAX(I139,0)","v":0},{"$f":"MAX(J139,0)","v":0},{"$f":"MAX(K139,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,2.0700889657046559,36.097588124178259,37.65185863847347,39.212996285243747,40.786233510488216,42.376334184700283,43.987657435232393,45.624213695434207,47.2897139446099,48.987612991707437,50.72114754961143,52.493369754067601,54.307176700000809,56.165336496834158,58.07051128213655,60.025277578397663,62.032144330004456,64.093568915704338,{"$f":"MAX(BW139,0)","v":66.21197139527365},68.389747217092832]
[null,null,null,"Add: Increase in Debt when Negative",null,null,null,null,{"$f":"MAX(-I139,0)","v":16.25},{"$f":"MAX(-J139,0)","v":0},{"$f":"MAX(-K139,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(-BW139,0)","v":0},0]
[]
[null,null,"Balance Sheet"]
[null,null,null,null,"Assets"]
[null,null,null,null,null,"Cash",null,null,{"$f":"I103","v":100},83.319210140045641,102.35001440174297,102.33195314957464,110.65240663406419,120.03537927373338,122.59906659204616,129.38053781001796,92.044708434460603,75.698383096832799,65.596107055639848,56.815313604356817,59.824012909414492,61.198895641561982,66.946872578017235,67.103791299769782,56.255236367652842,61.501606481383533,63.278879629678563,61.103621267722524,50.750546102208553,58.539957426473492,64.116315494436137,75.496850151449124,94.806446734788707,55.535245884154129,58.155618382140283,55.846288124430281,63.814089974230832,52.812943088645952,60.640998705982433,60.62813564304691,{"$f":"AO103","v":60.62813564304691},60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,60.62813564304691,62.698224608751566,98.795812732929818,136.44767137140329,175.66066765664704,216.44690116713525,258.82323535183554,302.81089278706793,348.43510648250214,395.72482042711204,444.7124334188195,495.43358096843093,547.92695072249853,602.23412742249934,658.39946391933347,716.46997520146999,776.49525277986766,838.52739710987214,902.62096602557654,968.83293742085016,1037.2226846379431]
[null,null,null,null,null,"Accounts Receivable",null,null,{"$f":"I83","v":75},90.869087617403565,68.981647985981994,65.275895640331456,77.835659787616024,115.87701133739196,113.86428600349051,120.9727272989804,70.572861800083473,76.266672844891445,63.778781836564221,63.591955211842574,55.816178400178956,57.655373233955871,51.397137457018104,58.342079533052242,77.691824845738182,86.607342900613872,85.203489962789902,68.194378299030959,63.085108892966801,64.244749441734271,74.714169200683713,59.517990541218239,67.830387287028771,70.928194977859008,75.146072680008615,57.127308648585732,61.15408281048591,45.620930115695067,51.411918373181265,63.026786346982888,{"$f":"AO83","v":56.430672716265647},59.252206352078936,62.214816669682882,65.325557503167033,68.591835378325385,71.678467970350027,74.903999029015779,78.274678985321486,81.797039539660943,85.232515200326716,88.812280838740435,92.364772072290066,96.059362955181669,99.901737473388934,103.39829828495755,107.01723872493105,110.76284208030363,114.08572734271273,117.50829916299411,121.03354813788393,124.66455458202046,128.40449121948109,132.25662595606553,136.22432473474751,140.31105447678993,144.52038611109367,148.85599769442646,153.32167762525924,157.92132795401704,162.65896779263755,167.53873682641668,172.5648989312092,177.74184589914546,183.07410127611982,188.56632431440343,194.22331404383556]
[null,null,null,null,null,"Net Plant",null,null,{"$f":"I94","v":1000},1042.4886350338331,1017.9732191345776,834.40045971673305,682.15181760931523,703.20984944953898,617.61266867861752,643.34875878335652,770.76776730366873,937.75116407640076,1085.6093354991974,1163.1920768759178,1110.4296215282625,1316.4445561362425,991.64254396332126,1121.5045022428856,1424.1603147980729,1341.748024525401,1454.3111962754704,1573.2389705562805,1264.2403742813319,1285.4987659238518,1402.9165576026369,1365.2119581456327,1248.1273830294085,1116.0679476146952,1117.2694465498146,1175.1604487940285,1292.9860331419948,1143.023378691541,1159.4345069775636,1383.6365057072796,{"$f":"AO94","v":1347.5044901536724},1322.6787236018617,1308.0918097528372,1302.8262745232964,1306.0967498343443,1316.4069775850105,1333.2155367436744,1356.0634998668354,1384.564840252219,1417.8060210026083,1455.5449958517881,1497.155931301249,1542.4995581384178,1591.4676613285769,1642.7746219518233,1696.4244832017287,1752.4311189205864,1809.4812110189996,1867.6853453719882,1927.1475538379161,1987.9663467709706,2050.2356234670597,2114.0454759367108,2179.482899487708,2246.6324219274597,2315.5766617308059,2386.3968242371907,2459.1731438191337,2533.9852789818501,2610.9126664942482,2690.0348398991837,2771.4317170923691,2855.1838610830746,2941.3727175454787,3030.080832328274,3121.3920517040483]
[null,null,null,null,null,"Total",null,null,{"$f":"SUM(I145:I147)","v":1175},{"$f":"SUM(J145:J147)","v":1216.6769327912823},{"$f":"SUM(K145:K147)","v":1189.3048815223026},1002.0083085066392,870.63988403099552,939.12224006066435,854.07602127415419,893.70202389235487,933.38533753821275,1089.7162200181251,1214.9842243914015,1283.5993456921171,1226.069812837856,1435.2988250117603,1109.9865539983566,1246.9503730757076,1558.1073760114639,1489.8569739073985,1602.7935658679389,1702.5369701230341,1378.0760292765074,1408.2834727920595,1541.7470422977567,1500.2267988383001,1410.7642170512261,1242.5313884767083,1250.5711376119634,1288.1340455670445,1417.9542059267114,1241.4572518958821,1271.4874240567274,1507.2914276973095,{"$f":"SUM(AO145:AO147)","v":1464.5632985129848},1442.5590655969877,1430.9347620655669,1428.7799676695104,1435.3167208557165,1448.7135811984074,1468.7476714157372,1494.9663144952037,1526.9900154349268,1563.6666718459819,1604.9854123335754,1650.148839016586,1699.1870567366464,1751.9975344450127,1806.8010558798278,1864.0698575697065,1925.8921856096417,2022.3627510946421,2121.6413159063854,2223.8417696324473,2329.0778025201262,2437.4633500383761,2549.1129946798442,2664.1423307049577,2782.6682968313617,2904.8094812607192,3030.6864029000481,3160.4217721668915,3294.1407343583664,3431.9710982062193,3574.0435519270704,3720.4918688034459,3871.453104092092,4027.0677848471751,{"$f":"SUM(BW145:BW147)","v":4187.4800940635278},4352.838050385827]
[]
[null,null,null,null,"Liabilities and Capital"]
[null,null,null,null,null,"Debt",null,null,{"$f":"I111","v":470},450.32313806955153,448.12929341452821,374.69296514652308,317.12168969735177,329.29809148930894,296.08469410826547,309.0917186373498,345.12499029525179,405.37981886929344,460.48217702193489,488.00295619210988,468.10145377507081,551.05738071112171,423.43576661653543,475.44331741706213,592.16622046629027,561.29985240271378,607.03603036205959,653.73703672960119,525.99636815341626,537.61548934013013,586.81314923882917,576.28352331883275,537.17353190567894,468.64127739953977,470.17002597278201,492.40269476738354,542.72004924649025,478.33452871207476,488.03020227341841,577.70585654013064,{"$f":"AO111","v":519.81449088798604},475.61452549436541,435.26248379716208,398.1658070137251,363.79967678780486,331.07950151049238,299.92936017685412,270.00560220221274,241.00027258594534,212.19360427801342,183.58109597522247,154.63556074572335,125.34739164176274,95.558151944643356,64.219347494342827,31.704266952958733,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,"Equity",null,null,{"$f":"I159","v":705},{"$f":"J159","v":766.35379472173076},{"$f":"K159","v":741.17558810777439},627.31534336011612,553.51819433364381,609.82414857135541,557.99132716588872,584.61030525500507,588.26034724296096,684.33640114883167,754.50204736946671,795.59638950000726,757.96835906278523,884.24144430063859,686.55078738182124,771.50705565864541,965.94115554517361,928.55712150468469,995.75753550587933,1048.7999333934329,852.07966112309111,870.66798345192933,954.93389305892754,923.94327551946731,873.59068514554713,773.89011107716851,780.40111163918141,795.73135079966096,875.23415668022119,763.12272318380735,783.45722178330902,929.58557115717883,944.74880762499902,966.94454010262223,995.67227826840474,1030.6141606557849,1071.5170440679115,1117.6340796879147,1168.8183112388829,1224.9607122929908,1285.9897428489812,1351.4730675679682,1421.4043163583528,1495.5132782708624,1573.8396650948835,1656.4393825003692,1742.5817083854847,1832.3655906167476,1925.892185609641,2022.3627510946415,2121.641315906385,2223.8417696324468,2329.0778025201262,2437.4633500383766,2549.1129946798446,2664.1423307049581,2782.6682968313621,2904.8094812607196,3030.6864029000485,3160.4217721668924,3294.1407343583674,3431.9710982062202,3574.0435519270713,3720.4918688034468,3871.4531040920924,4027.0677848471751,{"$f":"BW159","v":4187.4800940635278},4352.838050385827]
[null,null,null,null,null,"Total",null,null,{"$f":"SUM(I151:I152)","v":1175},{"$f":"SUM(J151:J152)","v":1216.6769327912823},{"$f":"SUM(K151:K152)","v":1189.3048815223026},1002.0083085066392,870.63988403099552,939.12224006066435,854.07602127415419,893.70202389235487,933.38533753821275,1089.7162200181251,1214.9842243914015,1283.5993456921171,1226.069812837856,1435.2988250117603,1109.9865539983566,1246.9503730757076,1558.1073760114639,1489.8569739073985,1602.7935658679389,1702.5369701230341,1378.0760292765074,1408.2834727920595,1541.7470422977567,1500.2267988383001,1410.7642170512261,1242.5313884767083,1250.5711376119634,1288.1340455670445,1417.9542059267114,1241.4572518958821,1271.4874240567274,1507.2914276973095,{"$f":"SUM(AO151:AO152)","v":1464.5632985129851},1442.5590655969877,1430.9347620655667,1428.7799676695099,1435.3167208557163,1448.7135811984072,1468.7476714157369,1494.9663144952035,1526.9900154349266,1563.6666718459817,1604.9854123335754,1650.1488390165857,1699.1870567366461,1751.9975344450127,1806.8010558798276,1864.0698575697063,1925.892185609641,2022.3627510946415,2121.641315906385,2223.8417696324468,2329.0778025201262,2437.4633500383766,2549.1129946798446,2664.1423307049581,2782.6682968313621,2904.8094812607196,3030.6864029000485,3160.4217721668924,3294.1407343583674,3431.9710982062202,3574.0435519270713,3720.4918688034468,3871.4531040920924,4027.0677848471751,{"$f":"SUM(BW151:BW152)","v":4187.4800940635278},4352.838050385827]
[]
[null,null,null,"Equity Balance"]
[null,null,null,null,"Opening Balance",null,null,null,{"$f":"H159","v":0},{"$f":"I159","v":705},{"$f":"J159","v":766.35379472173076},741.17558810777439,627.31534336011612,553.51819433364381,609.82414857135541,557.99132716588872,584.61030525500507,588.26034724296096,684.33640114883167,754.50204736946671,795.59638950000726,757.96835906278523,884.24144430063859,686.55078738182124,771.50705565864541,965.94115554517361,928.55712150468469,995.75753550587933,1048.7999333934329,852.07966112309111,870.66798345192933,954.93389305892754,923.94327551946731,873.59068514554713,773.89011107716851,780.40111163918141,795.73135079966096,875.23415668022119,763.12272318380735,783.45722178330902,929.58557115717883,944.74880762499902,966.94454010262223,995.67227826840474,1030.6141606557849,1071.5170440679115,1117.6340796879147,1168.8183112388829,1224.9607122929908,1285.9897428489812,1351.4730675679682,1421.4043163583528,1495.5132782708624,1573.8396650948835,1656.4393825003692,1742.5817083854847,1832.3655906167476,1925.892185609641,2022.3627510946415,2121.641315906385,2223.8417696324468,2329.0778025201262,2437.4633500383766,2549.1129946798446,2664.1423307049581,2782.6682968313621,2904.8094812607196,3030.6864029000485,3160.4217721668924,3294.1407343583674,3431.9710982062202,3574.0435519270713,3720.4918688034468,3871.4531040920924,{"$f":"BV159","v":4027.0677848471751},4187.4800940635278]
[null,null,null,null,"Add: Net Income",null,null,null,{"$f":"I121","v":177.5},198.54452216415382,163.74630550376119,188.95220786382211,250.37789697100561,337.92250962288585,387.11763310660746,427.39525276381863,191.87886803954902,193.77956785942933,145.18604601579679,128.21661848621659,69.41491888823019,45.036157243058774,101.9219758266937,116.116739950065,152.30550924350746,184.80459259459354,176.66382750180637,106.37780051669293,126.12408519708528,113.13374628181015,96.865526735474063,99.491558685882552,103.59819871723813,151.22927373883107,161.93040095023528,87.931517857815194,100.81986636516196,83.792785588908899,37.909122668357604,43.464483346627517,{"$f":"AO121","v":37.908091169550659},55.489331194057982,71.819345414456606,87.354705968450489,102.25720853031632,115.29258905000833,127.96057887742012,140.35600263526996,152.57257638997621,163.70831179746759,174.82812197596161,185.27240478127391,195.81596706005237,206.49929351371458,215.35581471278851,224.45970557815738,233.81648748223401,241.17641371250141,248.19641202935864,255.50113431515402,263.09008221919834,270.96386879562522,279.12411160367031,287.57334006278353,296.31491531600972,305.35296107339349,314.69230409832227,324.33842316710962,334.29740547868795,344.57590961963166,355.18113430212787,366.12079219093914,377.40308822161518,389.03670188770758,401.0307730408818,413.39489080574856]
[null,null,null,null,"Less: Dividends",null,null,null,{"$f":"I135","v":88.75},{"$f":"J135","v":99.272261082076909},{"$f":"K135","v":81.873152751880596},94.476103931911055,125.18894848550281,168.96125481144293,193.55881655330373,213.69762638190932,95.939434019774509,96.889783929714667,72.593023007898395,64.108309243108295,34.707459444115095,22.518078621529387,50.960987913346848,58.058369975032498,76.152754621753729,92.402296297296772,88.331913750903183,53.188900258346465,63.062042598542639,56.566873140905074,48.432763367737032,49.745779342941276,51.799099358619067,75.614636869415534,80.965200475117641,43.965758928907597,50.409933182580978,41.896392794454449,18.954561334178802,21.732241673313759,22.744854701730393,33.293598716434786,43.091607248673959,52.412823581070292,61.354325118189792,69.175553430004996,76.776347326452068,84.213601581161967,91.543545833985718,98.224987078480552,104.89687318557696,111.16344286876434,117.48958023603141,123.89957610822874,129.2134888276731,134.67582334689442,140.28989248934039,144.70584822750084,148.91784721761519,153.30068058909239,157.85404933151901,162.57832127737512,167.47446696220217,172.54400403767011,177.78894918960583,183.21177664403609,188.81538245899335,194.60305390026576,200.57844328721276,206.74554577177898,213.10868058127673,219.67247531456348,226.44185293296911,233.42202113262454,{"$f":"BW135","v":240.61846382452907},248.03693448344913]
[null,null,null,null,"Closining Balance",null,null,null,{"$f":"IF(I3,I17,I156+I157-I158)","v":705},766.35379472173076,741.17558810777439,627.31534336011612,553.51819433364381,609.82414857135541,557.99132716588872,584.61030525500507,588.26034724296096,684.33640114883167,754.50204736946671,795.59638950000726,757.96835906278523,884.24144430063859,686.55078738182124,771.50705565864541,965.94115554517361,928.55712150468469,995.75753550587933,1048.7999333934329,852.07966112309111,870.66798345192933,954.93389305892754,923.94327551946731,873.59068514554713,773.89011107716851,780.40111163918141,795.73135079966096,875.23415668022119,763.12272318380735,783.45722178330902,929.58557115717883,{"$f":"IF(AO3,AO17,AO156+AO157-AO158)","v":944.74880762499902},966.94454010262223,995.67227826840474,1030.6141606557849,1071.5170440679115,1117.6340796879147,1168.8183112388829,1224.9607122929908,1285.9897428489812,1351.4730675679682,1421.4043163583528,1495.5132782708624,1573.8396650948835,1656.4393825003692,1742.5817083854847,1832.3655906167476,1925.892185609641,2022.3627510946415,2121.641315906385,2223.8417696324468,2329.0778025201262,2437.4633500383766,2549.1129946798446,2664.1423307049581,2782.6682968313621,2904.8094812607196,3030.6864029000485,3160.4217721668924,3294.1407343583674,3431.9710982062202,3574.0435519270713,3720.4918688034468,{"$f":"IF(BU3,BU17,BU156+BU157-BU158)","v":3871.4531040920924},4027.0677848471751,4187.4800940635278,4352.838050385827]
[]
[null,null,null,null,null,"Difference",null,null,{"$f":"I153-I148","v":0},{"$f":"J153-J148","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":"BV153-BV148","v":0},0,0]
[]
[1,{"$f":"MATCH(A163,B:B,0)","v":40},null,null,null,{"$f":"INDEX(F:F,$B163)","v":"Revenue Growth"},null,null,{"$f":"INDEX(I:I,$B163)","v":0},9.1587834898714249E-2,-0.12077134262969014,-9.8046150011456001E-3,0.1902433357794493,0.25981234312264334,9.3446425392365029E-2,6.9383398237231386E-2,-0.4192904054461204,2.3339455035877199E-2,{"$f":"INDEX(S:S,$B163)","v":-6.042940711374456E-2},-7.4332432986150776E-2,-0.18231027026574043,-4.0911804520407435E-2,7.38670743926928E-2,0.12767109448583924,0.31543999583939675,8.5702833813665391E-2,-4.6098069460013269E-3,-0.14918108976269173,{"$f":"INDEX(AC:AC,$B163)","v":-5.5385185512334512E-2},-2.6258922619969205E-2,-3.7080951454164346E-2,-2.9853327197422175E-3,-4.1020843771126803E-2,0.12888361890619793,1.7170572330647671E-2,-0.18045007230213839,6.8103457673554857E-2,-0.1509506950389593,{"$f":"INDEX(AM:AM,$B163)","v":-0.13444398907216448},0.16407139029620055,0.05,0.05,0.05,0.05,0.05,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,{"$f":"INDEX(AW:AW,$B163)","v":4.4999999999999998E-2},4.2000000000000003E-2,4.2000000000000003E-2,0.04,0.04,0.04,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,0.03,{"$f":"INDEX(BG:BG,$B163)","v":0.03},0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,{"$f":"INDEX(BQ:BQ,$B163)","v":0.03},0.03,0.03,0.03,0.03,0.03,0.03,0.03]
[2,48,null,null,null,"Cap Exp to Sales",null,null,0.43333333333333335,0.41384216710627236,0.45961895215731541,0.38046543922275322,0.26132800909198595,0.213837567322714,0.17175830545403367,0.16730718063339947,0.34516969313370005,0.41037132356979461,0.5056308303914232,0.58527013734887257,0.683293714025062,0.84461815880468394,0.59246468077981485,0.59419075128117305,0.57360470307150291,0.49775292062613141,0.54200942988773748,0.68913936224393069,0.58625595098799299,0.6121893659847758,0.69383496248494481,0.67720924090032486,0.64561339982111154,0.51139336492068288,0.50330192156018327,0.64594035241479675,0.66538922278731316,0.69279402142637647,0.81189536648295124,0.83233132073934346,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6]
[3,53,null,null,null,"A/R to Revenues",null,null,0.25,0.27748290063417902,0.2395806775617855,0.22895501716920938,0.22937188200833139,0.27105223538574769,0.24358229938633605,0.24199825416622592,0.24311037228520282,0.25673249495159517,0.22850349403471534,0.24612954896348821,0.2642001943858448,0.28454717413525876,0.23621250979258582,0.23777348264504325,0.24070537812927387,0.24714635792249043,0.24426628452355115,0.22978283484020257,0.22503035912132804,0.23534685806336242,0.28423919114200091,0.22710552494652092,0.26989483200683789,0.25,0.26039557625439286,0.24154367057408829,0.2420828554901128,0.21270113189598344,0.27693273718938327,0.29164600843643645,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973]
[4,59,null,null,null,"Tax and Depreciation",null,null,0,0.10724886350338332,9.8607618787250911E-2,7.7055117460121933E-2,8.8944320316082418E-2,0.10895079808688471,9.4937900713594064E-2,9.4452200929011271E-2,0.12757742299150948,0.10869047715981379,0.11896645701292953,9.7935052887789378E-2,0.10234162054520685,0.11765217090824796,7.2288843425080268E-2,0.10704507473028996,0.12609492979920348,9.7021944100535801E-2,0.1061534036377116,0.10886521224693846,8.163034340722175E-2,0.10563645910161881,0.10680030148577858,9.5886811717753748E-2,8.9226246207511323E-2,8.7816993883617855E-2,9.2939632283742954E-2,0.11144674658732931,0.10662254966356571,8.2988010016168706E-2,0.10843474683749582,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741,0.12451212181622741]
[5,65,null,null,null,"Financing",null,null,0,4.7906716815909745E-2,4.9756414397844631E-2,4.1806345919895585E-2,4.2317539852041501E-2,5.1919831122806175E-2,4.4956940498678571E-2,5.2196504038862654E-2,5.5828896325135616E-2,5.8729421263075461E-2,5.6796386448927802E-2,5.2988256716922193E-2,4.7960923989853403E-2,5.8860891828794913E-2,3.8420297181221426E-2,5.6141138149015279E-2,6.2275164964285111E-2,4.7393775008031415E-2,5.4074130588451647E-2,5.3846642046905133E-2,4.0229965460177756E-2,5.1104486826354378E-2,5.4575543383160736E-2,4.9102812715286402E-2,4.6606705742000203E-2,4.3621032084081482E-2,5.016310434515342E-2,5.2364322220307659E-2,5.510937033994881E-2,4.4068256680050058E-2,5.1013482508512349E-2,5.9187510716444514E-2,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03]
[6,70,null,null,null,"Interest Income Rate",null,null,0,8.3319210140045639E-3,1.2284083614056078E-2,9.9982353444429007E-3,1.0813084596590066E-2,1.084796823901891E-2,1.0213577641344094E-2,1.0553142157316535E-2,7.1142623142917225E-3,8.2240885309265745E-3,8.6654568264331096E-3,8.6613849745938443E-3,1.0529557810066714E-2,1.0229821214807059E-2,1.0939228866174447E-2,1.0023439290845093E-2,8.3833171387211677E-3,1.0932601203458349E-2,1.0288979955154993E-2,9.6562425923647655E-3,8.3056527664453015E-3,1.1534842858356152E-2,1.0952572962658298E-2,1.1774982634178435E-2,1.255766916693927E-2,5.8577499523327003E-3,1.0471839541946429E-2,9.6029050465020575E-3,1.142673794756916E-2,8.2760630309031552E-3,1.1482222947544729E-2,9.9978788174320994E-3,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[]
[null,null,null,null,null,null,3]
[]
[null,null,null,null,null,{"$f":"INDEX(F163:F168,$G$170)","v":"A/R to Revenues"},null,null,{"$f":"INDEX(I163:I168,$G$170)","v":0.25},{"$f":"INDEX(J163:J168,$G$170)","v":0.27748290063417902},0.2395806775617855,0.22895501716920938,0.22937188200833139,0.27105223538574769,0.24358229938633605,0.24199825416622592,0.24311037228520282,0.25673249495159517,0.22850349403471534,0.24612954896348821,0.2642001943858448,0.28454717413525876,0.23621250979258582,0.23777348264504325,0.24070537812927387,0.24714635792249043,0.24426628452355115,0.22978283484020257,0.22503035912132804,0.23534685806336242,0.28423919114200091,0.22710552494652092,0.26989483200683789,0.25,0.26039557625439286,0.24154367057408829,0.2420828554901128,0.21270113189598344,0.27693273718938327,0.29164600843643645,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,{"$f":"INDEX(BV163:BV168,$G$170)","v":0.2486891293137973},0.2486891293137973,0.2486891293137973]
[]
[]
[null,null,null,null,null,"History",null,null,{"$f":"IF(I3,I172)","v":0.25},{"$f":"IF(J3,J172)","v":0.27748290063417902},0.2395806775617855,0.22895501716920938,0.22937188200833139,0.27105223538574769,0.24358229938633605,0.24199825416622592,0.24311037228520282,0.25673249495159517,0.22850349403471534,0.24612954896348821,0.2642001943858448,0.28454717413525876,0.23621250979258582,0.23777348264504325,0.24070537812927387,0.24714635792249043,0.24426628452355115,0.22978283484020257,0.22503035912132804,0.23534685806336242,0.28423919114200091,0.22710552494652092,0.26989483200683789,0.25,0.26039557625439286,0.24154367057408829,0.2420828554901128,0.21270113189598344,0.27693273718938327,0.29164600843643645,false,false,false,false,false,false,false,false,false,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(BV3,BV172)","v":false},false,false]
[null,null,null,null,null,"Projection ",null,null,{"$f":"IF(NOT(I3),I172)","v":false},{"$f":"IF(NOT(J3),J172)","v":false},false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,0.2486891293137973,{"$f":"IF(NOT(BV3),BV172)","v":0.2486891293137973},0.2486891293137973,0.2486891293137973]

{"sheet":"Advertising","index":2,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"High Quality Modelling, Finance and Energy Courses"]
[]
[null,null,"This page is my advertising and publicity - You can of course delete the page without affecting the model"]
[]
[null,null,"I have taught classes for many years and I believe I have learned from my mistakes and can offer high quality courses"]
[]
[null,null,"Here is my simple concept"]
[null,null,null,"1. Deliver the courses at a reasonable price -- I will do quite well if a lot of people attend and I will survive if course numbers are low"]
[null,null,null,null,"USD 1,500 for courses in Europe"]
[null,null,null,null,"USD 1,000 for courses in Africa and Latin America"]
[null,null,null,"2. Do not cancel the classes as long as one student has signed up (I take the risk of low numbers and not you)"]
[null,null,null,"3. Limit the size of the classes to 25 participants"]
[null,null,null,"4. Lunches are offered by not with a four course elaborate menu -- we assume that you are attending the course to learn and not to have a fancy lunch"]
[null,null,null,"5. Scolarships Avaiable"]
[]
[null,null,"Download Outlines at",null,null,null,null,null,"www.FinanceEnergyInstitiute.com"]
[null,null,"Check for upcomming dates",null,null,null,null,null,"www.FinanceEnergyInstitiute.com"]
[]
[null,null,"Customised In-Company Courses"]
[]
[null,null,"I also offer courses tailored for single institutions (or combinations of institutions) "]
[null,null,"Depending on various considerations my rate is USD 1,500 to USD 2,000 per day plus expenses"]
[]
[null,null,"Contact Details"]
[null,null,null,"E-mail",null,null,null,null,"edwardbodmer@gmail.com"]
[null,null,null,"Phone",null,null,null,null,"001-630-886-2754"]
[]
[null,null,null,"Skype",null,null,null,null,"edward.bodmer"]
[null,null,null,"Link to Book"]