{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Index","1.Input -->","P&L assumptions","BS assumptions","2.Output-->","P&L","BS","Cash Flow","DCF valuation","3.Charts  -->","Revenues&Ebitda","Cash flows","Ebitda bridge","Working capital","DCF results","4.Sources -->","P&L source","BS source"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Index","index":0,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"DCF Valuation"]
[null,"Sheet index"]
[]
[null,"#                ","Worksheet"]
[null,1,"1.Input -->"]
[null,{"$f":"B5+1","v":2},"P&L assumptions"]
[null,{"$f":"B6+1","v":3},"BS assumptions"]
[null,4,"2.Output -->"]
[null,5,"P&L"]
[null,6,"BS"]
[null,7,"Cash Flow"]
[null,8,"DCF valuation"]
[null,9,"3.Charts -->"]
[null,10,"Revenue&Ebitda"]
[null,11,"Cash flows"]
[null,12,"Ebitda bridge"]
[null,13,"Working capital"]
[null,14,"DCF results"]
[null,15,"4. Sources -->"]
[null,16,"P&L source"]
[null,17,"BS source"]

{"sheet":"1.Input -->","index":1,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1.Input -->"]

{"sheet":"P&L assumptions","index":2,"n_rows":55,"n_cols":11,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[null,"P&L assumptions"]
[null,null,null,null,null,null,"Case scenarios:"]
[null,null,null,null,null,null,"Case 1: Optimistic case"]
[null,null,null,null,null,null,"Case 2: Base case"]
[null,"Selected case",1,null,null,null,"Case 3: Worst case"]
[]
[]
[null,"$ in thousands","FY11\nActual","FY12\nActual","FY13\nActual",null,"FY14\nForecast","FY15\nForecast","FY16\nForecast","FY17\nForecast","FY18\nForecast"]
[null,"Revenues",{"$f":"'P&L source'!D4","v":177203},{"$f":"'P&L source'!E4","v":188618},{"$f":"'P&L source'!F4","v":208366},null,{"$f":"+E9*(1+G10)","v":229202.6},{"$f":"+G9*(1+H10)","v":252122.86000000002},{"$f":"+H9*(1+I10)","v":277335.14600000007},305068.66060000012,335575.52666000015]
[null,"y-o-y growth %",0,{"$f":"D9/C9-1","v":6.4417645299458703E-2},{"$f":"E9/D9-1","v":0.10469838509580209},null,{"$f":"+CHOOSE($C$5,G11,G12,G13)","v":0.1},{"$f":"+CHOOSE($C$5,H11,H12,H13)","v":0.1},0.1,0.1,0.1]
[null,"Case 1",null,null,null,null,0.1,0.1,0.1,0.1,0.1]
[null,"Case 2",null,null,null,null,0.08,0.08,0.08,0.08,0.08]
[null,"Case 3",null,null,null,null,0.04,0.04,0.04,0.04,0.04]
[]
[null,"Other revenues",{"$f":"'P&L source'!D5","v":3520},{"$f":"'P&L source'!E5","v":2416},{"$f":"'P&L source'!F5","v":2585},null,{"$f":"+E15*(1+G16)","v":2585},{"$f":"+G15*(1+H16)","v":2585},{"$f":"+H15*(1+I16)","v":2585},{"$f":"+I15*(1+J16)","v":2585},{"$f":"+J15*(1+K16)","v":2585}]
[null,"y-o-y growth %",0,{"$f":"D15/C15-1","v":-0.3136363636363636},{"$f":"E15/D15-1","v":6.9950331125827825E-2},null,{"$f":"+CHOOSE($C$5,G17,G18,G19)","v":0},{"$f":"+CHOOSE($C$5,H17,H18,H19)","v":0},0,0,0]
[null,"Case 1",null,null,null,null,0,0,0,0,0]
[null,"Case 2",null,null,null,null,0,0,0,0,0]
[null,"Case 3",null,null,null,null,0,0,0,0,0]
[]
[null,"Cost of goods sold",{"$f":"'P&L source'!D8+'P&L source'!D9","v":-142394.36746666671},{"$f":"'P&L source'!E8+'P&L source'!E9","v":-150572.16639999999},{"$f":"'P&L source'!F8+'P&L source'!F9","v":-157523.118425397},null,{"$f":"G$9*G22","v":-174193.976},{"$f":"H$9*H22","v":-191613.37360000002},-210774.71096000005,-231852.18205600011,-255037.40026160012]
[null,"% of revenues",{"$f":"C21/C$9","v":-0.8035663474470901},{"$f":"D21/D$9","v":-0.79829160737575411},{"$f":"E21/E$9","v":-0.75599242882906514},null,{"$f":"+CHOOSE($C$5,G23,G24,G25)","v":-0.76},{"$f":"+CHOOSE($C$5,H23,H24,H25)","v":-0.76},-0.76,-0.76,-0.76]
[null,"Case 1",null,null,null,null,-0.76,-0.76,-0.76,-0.76,-0.76]
[null,"Case 2",null,null,null,null,-0.78,-0.78,-0.78,-0.78,-0.78]
[null,"Case 3",null,null,null,null,-0.8,-0.8,-0.8,-0.8,-0.8]
[]
[null,"Operating expenses",{"$f":"'P&L source'!D10+'P&L source'!D11+'P&L source'!D12","v":-18011.315200000005},{"$f":"'P&L source'!E10+'P&L source'!E11+'P&L source'!E12","v":-19247.897599999997},{"$f":"'P&L source'!F10+'P&L source'!F11+'P&L source'!F12","v":-23867.008000000009},null,{"$f":"G$9*G28","v":-22920.260000000002},{"$f":"H$9*H28","v":-25212.286000000004},-27733.51460000001,-30506.866060000015,-33557.552666000018]
[null,"% of revenues",{"$f":"C27/C$9","v":-0.10164227016472635},{"$f":"D27/D$9","v":-0.10204698173026963},{"$f":"E27/E$9","v":-0.11454367795129727},null,{"$f":"+CHOOSE($C$5,G29,G30,G31)","v":-0.1},{"$f":"+CHOOSE($C$5,H29,H30,H31)","v":-0.1},-0.1,-0.1,-0.1]
[null,"Case 1",null,null,null,null,-0.1,-0.1,-0.1,-0.1,-0.1]
[null,"Case 2",null,null,null,null,-0.105,-0.105,-0.105,-0.105,-0.105]
[null,"Case 3",null,null,null,null,-0.11,-0.11,-0.11,-0.11,-0.11]
[]
[null,"D&A",{"$f":"'P&L source'!D16","v":-2907.8000000000006},{"$f":"'P&L source'!E16","v":-4649.8},{"$f":"'P&L source'!F16","v":-6430.6600000000008},null,{"$f":"G$9*G34","v":-4584.0520000000006},{"$f":"H$9*H34","v":-5042.4572000000007},-5546.7029200000015,-6101.3732120000022,-6711.510533200003]
[null,"% of revenues",{"$f":"C33/C$9","v":-1.6409428734276511E-2},{"$f":"D33/D$9","v":-2.4651942020379815E-2},{"$f":"E33/E$9","v":-3.0862328786846225E-2},null,{"$f":"+CHOOSE($C$5,G35,G36,G37)","v":-0.02},{"$f":"+CHOOSE($C$5,H35,H36,H37)","v":-0.02},-0.02,-0.02,-0.02]
[null,"Case 1",null,null,null,null,-0.02,-0.02,-0.02,-0.02,-0.02]
[null,"Case 2",null,null,null,null,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2]
[null,"Case 3",null,null,null,null,-0.03,-0.03,-0.03,-0.03,-0.03]
[]
[null,"Interest expenses",{"$f":"'P&L source'!D20","v":-1266.3000000000002},{"$f":"'P&L source'!E20","v":-2190.9},{"$f":"'P&L source'!F20","v":-2663.92},null,{"$f":"+E39*(1+G40)","v":-2663.92},{"$f":"+G39*(1+H40)","v":-2663.92},{"$f":"+H39*(1+I40)","v":-2663.92},{"$f":"+I39*(1+J40)","v":-2663.92},{"$f":"+J39*(1+K40)","v":-2663.92}]
[null,"y-o-y growth %",0,{"$f":"D39/C39-1","v":0.73015873015873001},{"$f":"E39/D39-1","v":0.21590214067278279},null,{"$f":"+CHOOSE($C$5,G41,G42,G43)","v":0},{"$f":"+CHOOSE($C$5,H41,H42,H43)","v":0},0,0,0]
[null,"Case 1",null,null,null,null,0,0,0,0,0]
[null,"Case 2",null,null,null,null,0,0,0,0,0]
[null,"Case 3",null,null,null,null,0,0,0,0,0]
[]
[null,"Extraordinary items",{"$f":"'P&L source'!D21","v":-317.58000000000004},{"$f":"'P&L source'!E21","v":-864.30000000000007},{"$f":"'P&L source'!F21","v":-320.26},null,{"$f":"G$9*G46","v":0},{"$f":"H$9*H46","v":0},0,0,0]
[null,"% of revenues",{"$f":"C45/C$9","v":-1.7921818479371119E-3},{"$f":"D45/D$9","v":-4.5822774072463929E-3},{"$f":"E45/E$9","v":-1.5370069973028228E-3},null,{"$f":"+CHOOSE($C$5,G47,G48,G49)","v":0},{"$f":"+CHOOSE($C$5,H47,H48,H49)","v":0},0,0,0]
[null,"Case 1",null,null,null,null,0,0,0,0,0]
[null,"Case 2",null,null,null,null,0,0,0,0,0]
[null,"Case 3",null,null,null,null,0,0,0,0,0]
[]
[null,"Taxes",{"$f":"'P&L source'!D25","v":-3805.7759999999998},{"$f":"'P&L source'!E25","v":-3050.192},{"$f":"'P&L source'!F25","v":-3814.88}]
[null,"% of EBT",null,null,null,null,{"$f":"+CHOOSE($C$5,G53,G54,G55)","v":-0.18},{"$f":"+CHOOSE($C$5,H53,H54,H55)","v":-0.18},-0.18,-0.18,-0.18]
[null,"Case 1",null,null,null,null,-0.18,-0.18,-0.18,-0.18,-0.18]
[null,"Case 2",null,null,null,null,-0.2,-0.2,-0.2,-0.2,-0.2]
[null,"Case 3",null,null,null,null,-0.22,-0.22,-0.22,-0.22,-0.22]

{"sheet":"BS assumptions","index":3,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"BS assumptions"]
[]
[]
[null,"$ in thousands","FY11\nActual","FY12\nActual","FY13\nActual",null,"FY14\nForecast","FY15\nForecast","FY16\nForecast","FY17\nForecast","FY18\nForecast"]
[null,"Trade receivable",{"$f":"'BS source'!D11","v":32883.599999999999},{"$f":"'BS source'!E11","v":38556},{"$f":"'BS source'!F11","v":43581.599999999999},null,{"$f":"G6*'P&L assumptions'!G9/360","v":47939.759999999995},{"$f":"H6*'P&L assumptions'!H9/360","v":52733.736000000004},{"$f":"I6*'P&L assumptions'!I9/360","v":58007.109600000011},{"$f":"J6*'P&L assumptions'!J9/360","v":63807.820560000022},{"$f":"K6*'P&L assumptions'!K9/360","v":70188.602616000018}]
[null,"Days receivables (DSO)",{"$f":"C5/'P&L assumptions'!C9*360","v":66.805279820319072},{"$f":"D5/'P&L assumptions'!D9*360","v":73.588734903349632},{"$f":"E5/'P&L assumptions'!E9*360","v":75.297198199322338},null,{"$f":"$E$6","v":75.297198199322338},{"$f":"$E$6","v":75.297198199322338},75.297198199322338,75.297198199322338,75.297198199322338]
[]
[null,"Inventory",{"$f":"'BS source'!D10","v":31167.200000000001},{"$f":"'BS source'!E10","v":36396.800000000003},{"$f":"'BS source'!F10","v":46212},null,{"$f":"-G9*'P&L assumptions'!G$21/360","v":51102.670511975753},{"$f":"-H9*'P&L assumptions'!H$21/360","v":56212.937563173342},{"$f":"-I9*'P&L assumptions'!I$21/360","v":61834.231319490689},{"$f":"-J9*'P&L assumptions'!J$21/360","v":68017.654451439768},{"$f":"-K9*'P&L assumptions'!K$21/360","v":74819.419896583742}]
[null,"Days inventory (DIO)",{"$f":"-C8/'P&L assumptions'!C$21*360","v":78.796599890979181},{"$f":"-D8/'P&L assumptions'!D$21*360","v":87.020385727810066},{"$f":"-E8/'P&L assumptions'!E$21*360","v":105.61192646702818},null,{"$f":"$E$9","v":105.61192646702818},{"$f":"$E$9","v":105.61192646702818},105.61192646702818,105.61192646702818,105.61192646702818]
[]
[null,"Trade payable",{"$f":"'BS source'!J10","v":15891.2},{"$f":"'BS source'!K10","v":26351.599999999999},{"$f":"'BS source'!L10","v":36189.599999999999},null,{"$f":"-G12*'P&L assumptions'!G$21/360","v":40019.588088812387},{"$f":"-H12*'P&L assumptions'!H$21/360","v":44021.546897693624},{"$f":"-I12*'P&L assumptions'!I$21/360","v":48423.701587462994},{"$f":"-J12*'P&L assumptions'!J$21/360","v":53266.071746209302},{"$f":"-K12*'P&L assumptions'!K$21/360","v":58592.678920830236}]
[null,"Days payables (DPO)",{"$f":"-C11/'P&L assumptions'!C$21*360","v":40.175971155173656},{"$f":"-D11/'P&L assumptions'!D$21*360","v":63.003516697758023},{"$f":"-E11/'P&L assumptions'!E$21*360","v":82.706945686643365},null,{"$f":"$E$12","v":82.706945686643365},{"$f":"$E$12","v":82.706945686643365},82.706945686643365,82.706945686643365,82.706945686643365]
[]
[null,"PP&E",{"$f":"'BS source'!D5","v":45106.400000000001},{"$f":"'BS source'!E5","v":49072.4},{"$f":"'BS source'!F5","v":56109.2},null,{"$f":"G15*'P&L assumptions'!G$9","v":59898.018769381182},{"$f":"H15*'P&L assumptions'!H$9","v":65887.820646319306},{"$f":"I15*'P&L assumptions'!I$9","v":72476.602710951251},{"$f":"J15*'P&L assumptions'!J$9","v":79724.262982046392},{"$f":"K15*'P&L assumptions'!K$9","v":87696.689280251027}]
[null,"as a % of revenues",{"$f":"C14/'P&L assumptions'!C$9","v":0.25454648059005774},{"$f":"D14/'P&L assumptions'!D$9","v":0.26016817058817293},{"$f":"E14/'P&L assumptions'!E$9","v":0.26928193659234229},null,{"$f":"AVERAGE($C15:$E15)","v":0.26133219592352436},{"$f":"AVERAGE($C15:$E15)","v":0.26133219592352436},0.26133219592352436,0.26133219592352436,0.26133219592352436]
[]
[null,"Other assets",{"$f":"'BS source'!D12","v":8841.6},{"$f":"'BS source'!E12","v":11359.199999999999},{"$f":"'BS source'!F12","v":17602.8},null,{"$f":"G18*'P&L assumptions'!G$9","v":14867.518484339287},{"$f":"H18*'P&L assumptions'!H$9","v":16354.270332773216},{"$f":"I18*'P&L assumptions'!I$9","v":17989.697366050539},{"$f":"J18*'P&L assumptions'!J$9","v":19788.6671026556},{"$f":"K18*'P&L assumptions'!K$9","v":21767.53381292116}]
[null,"as a % of revenues",{"$f":"C17/'P&L assumptions'!C$9","v":4.9895317799360059E-2},{"$f":"D17/'P&L assumptions'!D$9","v":6.0223308485934532E-2},{"$f":"E17/'P&L assumptions'!E$9","v":8.4480193505658316E-2},null,{"$f":"AVERAGE($C18:$E18)","v":6.4866273263650964E-2},{"$f":"AVERAGE($C18:$E18)","v":6.4866273263650964E-2},6.4866273263650964E-2,6.4866273263650964E-2,6.4866273263650964E-2]
[]
[null,"Other liabilities",{"$f":"'BS source'!J11+'BS source'!J12+'BS source'!J13","v":5969.0386666666891},{"$f":"'BS source'!K11+'BS source'!K12+'BS source'!K13","v":5800.3560000000052},{"$f":"'BS source'!L11+'BS source'!L12+'BS source'!L13","v":8473.4464253970418},null,{"$f":"G21*'P&L assumptions'!G$9","v":8029.9438439337491},{"$f":"H21*'P&L assumptions'!H$9","v":8832.9382283271243},{"$f":"I21*'P&L assumptions'!I$9","v":9716.2320511598391},{"$f":"J21*'P&L assumptions'!J$9","v":10687.855256275825},{"$f":"K21*'P&L assumptions'!K$9","v":11756.640781903407}]
[null,"as a % of revenues",{"$f":"C20/'P&L assumptions'!C$9","v":3.368474950574589E-2},{"$f":"D20/'P&L assumptions'!D$9","v":3.0751868856630889E-2},{"$f":"E20/'P&L assumptions'!E$9","v":4.0666166387016318E-2},null,{"$f":"AVERAGE($C21:$E21)","v":3.5034261583131034E-2},{"$f":"AVERAGE($C21:$E21)","v":3.5034261583131034E-2},3.5034261583131034E-2,3.5034261583131034E-2,3.5034261583131034E-2]

{"sheet":"2.Output-->","index":4,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2.Output -->"]

{"sheet":"P&L","index":5,"n_rows":56,"n_cols":13,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[null,"P&L"]
[]
[null,"$ in thousands","FY11\nActual","FY12\nActual","FY13\nActual",null,"FY14\nForecast","FY15\nForecast","FY16\nForecast","FY17\nForecast","FY18\nForecast",null,"Note"]
[null,"Revenues",{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B4,'P&L assumptions'!C:C)","v":177203},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B4,'P&L assumptions'!D:D)","v":188618},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B4,'P&L assumptions'!E:E)","v":208366},null,{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B4,'P&L assumptions'!G:G)","v":229202.6},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B4,'P&L assumptions'!H:H)","v":252122.86000000002},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B4,'P&L assumptions'!I:I)","v":277335.14600000007},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B4,'P&L assumptions'!J:J)","v":305068.66060000012},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B4,'P&L assumptions'!K:K)","v":335575.52666000015}]
[null,"Other revenues",{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B5,'P&L assumptions'!C:C)","v":3520},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B5,'P&L assumptions'!D:D)","v":2416},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B5,'P&L assumptions'!E:E)","v":2585},null,{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B5,'P&L assumptions'!G:G)","v":2585},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B5,'P&L assumptions'!H:H)","v":2585},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B5,'P&L assumptions'!I:I)","v":2585},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B5,'P&L assumptions'!J:J)","v":2585},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B5,'P&L assumptions'!K:K)","v":2585}]
[null,"Total Revenues",{"$f":"+C4+C5","v":180723},{"$f":"+D4+D5","v":191034},{"$f":"+E4+E5","v":210951},null,{"$f":"+G4+G5","v":231787.6},254707.86000000002,279920.14600000007,307653.66060000012,338160.52666000015]
[]
[null,"Cost of goods sold",{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B8,'P&L assumptions'!C:C)","v":-142394.36746666671},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B8,'P&L assumptions'!D:D)","v":-150572.16639999999},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B8,'P&L assumptions'!E:E)","v":-157523.118425397},null,{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B8,'P&L assumptions'!G:G)","v":-174193.976},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B8,'P&L assumptions'!H:H)","v":-191613.37360000002},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B8,'P&L assumptions'!I:I)","v":-210774.71096000005},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B8,'P&L assumptions'!J:J)","v":-231852.18205600011},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B8,'P&L assumptions'!K:K)","v":-255037.40026160012}]
[null,"Gross Margin",{"$f":"+C6+C8","v":38328.632533333293},{"$f":"+D6+D8","v":40461.833600000013},{"$f":"+E6+E8","v":53427.881574603001},null,{"$f":"+G6+G8","v":57593.624000000011},63094.486399999994,69145.435040000011,75801.478544000012,83123.126398400025]
[]
[null,"Operating expenses",{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B11,'P&L assumptions'!C:C)","v":-18011.315200000005},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B11,'P&L assumptions'!D:D)","v":-19247.897599999997},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B11,'P&L assumptions'!E:E)","v":-23867.008000000009},null,{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B11,'P&L assumptions'!G:G)","v":-22920.260000000002},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B11,'P&L assumptions'!H:H)","v":-25212.286000000004},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B11,'P&L assumptions'!I:I)","v":-27733.51460000001},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B11,'P&L assumptions'!J:J)","v":-30506.866060000015},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B11,'P&L assumptions'!K:K)","v":-33557.552666000018}]
[null,"EBITDA",{"$f":"+C9+C11","v":20317.317333333289},{"$f":"+D9+D11","v":21213.936000000016},{"$f":"+E9+E11","v":29560.873574602992},null,{"$f":"+G9+G11","v":34673.364000000009},37882.200399999987,41411.920440000002,45294.612483999997,49565.573732400007]
[]
[null,"D&A",{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B14,'P&L assumptions'!C:C)","v":-2907.8000000000006},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B14,'P&L assumptions'!D:D)","v":-4649.8},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B14,'P&L assumptions'!E:E)","v":-6430.6600000000008},null,{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B14,'P&L assumptions'!G:G)","v":-4584.0520000000006},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B14,'P&L assumptions'!H:H)","v":-5042.4572000000007},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B14,'P&L assumptions'!I:I)","v":-5546.7029200000015},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B14,'P&L assumptions'!J:J)","v":-6101.3732120000022},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B14,'P&L assumptions'!K:K)","v":-6711.510533200003}]
[null,"EBIT",{"$f":"+C12+C14","v":17409.51733333329},{"$f":"+D12+D14","v":16564.136000000017},{"$f":"+E12+E14","v":23130.213574602993},null,{"$f":"+G12+G14","v":30089.312000000009},32839.743199999983,35865.217519999998,39193.239271999992,42854.063199200005]
[]
[null,"Interest expenses",{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B17,'P&L assumptions'!C:C)","v":-1266.3000000000002},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B17,'P&L assumptions'!D:D)","v":-2190.9},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B17,'P&L assumptions'!E:E)","v":-2663.92},null,{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B17,'P&L assumptions'!G:G)","v":-2663.92},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B17,'P&L assumptions'!H:H)","v":-2663.92},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B17,'P&L assumptions'!I:I)","v":-2663.92},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B17,'P&L assumptions'!J:J)","v":-2663.92},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B17,'P&L assumptions'!K:K)","v":-2663.92}]
[null,"Extraordinary items",{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B18,'P&L assumptions'!C:C)","v":-317.58000000000004},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B18,'P&L assumptions'!D:D)","v":-864.30000000000007},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B18,'P&L assumptions'!E:E)","v":-320.26},null,{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B18,'P&L assumptions'!G:G)","v":0},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B18,'P&L assumptions'!H:H)","v":0},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B18,'P&L assumptions'!I:I)","v":0},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B18,'P&L assumptions'!J:J)","v":0},{"$f":"+SUMIF('P&L assumptions'!$B:$B,'P&L'!$B18,'P&L assumptions'!K:K)","v":0}]
[null,"EBT",{"$f":"+C15+C17+C18","v":15825.63733333329},{"$f":"+D15+D17+D18","v":13508.936000000018},{"$f":"+E15+E17+E18","v":20146.033574602992},null,{"$f":"+G15+G17+G18","v":27425.392000000007},30175.823199999984,33201.29752,36529.319271999993,40190.143199200007]
[]
[null,"Taxes",{"$f":"'P&L assumptions'!C51","v":-3805.7759999999998},{"$f":"'P&L assumptions'!D51","v":-3050.192},{"$f":"'P&L assumptions'!E51","v":-3814.88},null,{"$f":"G22*G19","v":-4936.570560000001},{"$f":"H22*H19","v":-5431.648175999997},-5976.2335536000001,-6575.2774689599983,-7234.2257758560008]
[null,"Tax rate",{"$f":"C21/C19","v":-0.24048168928931246},{"$f":"D21/D19","v":-0.22579069143565386},-0.18936134430001206,null,{"$f":"'P&L assumptions'!G52","v":-0.18},{"$f":"'P&L assumptions'!H52","v":-0.18},{"$f":"'P&L assumptions'!I52","v":-0.18},{"$f":"'P&L assumptions'!J52","v":-0.18},{"$f":"'P&L assumptions'!K52","v":-0.18}]
[]
[null,"Net Income",{"$f":"+C19+C21","v":12019.861333333291},{"$f":"+D19+D21","v":10458.744000000017},{"$f":"+E19+E21","v":16331.153574602991},null,{"$f":"+G19+G21","v":22488.821440000007},24744.175023999989,27225.063966400001,29954.041803039996,32955.917423344006]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,1]

{"sheet":"BS","index":6,"n_rows":26,"n_cols":13,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,"Balance Sheet"]
[]
[null,"$ in thousands","FY11\nActual","FY12\nActual","FY13\nActual",null,"FY14\nForecast","FY15\nForecast","FY16\nForecast","FY17\nForecast","FY18\nForecast",null,"Note"]
[null,"Intangible assets",{"$f":"'BS source'!D4","v":5961.6},{"$f":"'BS source'!E4","v":5840},{"$f":"'BS source'!F4","v":5650},null,{"$f":"$E$4","v":5650},{"$f":"$E$4","v":5650},5650,5650,5650,null,"Flat"]
[null,"PP&E",{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B5,'BS assumptions'!C:C)","v":45106.400000000001},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B5,'BS assumptions'!D:D)","v":49072.4},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B5,'BS assumptions'!E:E)","v":56109.2},null,{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B5,'BS assumptions'!G:G)","v":59898.018769381182},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B5,'BS assumptions'!H:H)","v":65887.820646319306},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B5,'BS assumptions'!I:I)","v":72476.602710951251},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B5,'BS assumptions'!J:J)","v":79724.262982046392},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B5,'BS assumptions'!K:K)","v":87696.689280251027}]
[null,"Financial assets",{"$f":"'BS source'!D6","v":8824},{"$f":"'BS source'!E6","v":9831},{"$f":"'BS source'!F6","v":10323},null,{"$f":"$E$6","v":10323},{"$f":"$E$6","v":10323},10323,10323,10323,null,"Flat"]
[]
[null,"Inventory",{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B8,'BS assumptions'!C:C)","v":31167.200000000001},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B8,'BS assumptions'!D:D)","v":36396.800000000003},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B8,'BS assumptions'!E:E)","v":46212},null,{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B8,'BS assumptions'!G:G)","v":51102.670511975753},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B8,'BS assumptions'!H:H)","v":56212.937563173342},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B8,'BS assumptions'!I:I)","v":61834.231319490689},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B8,'BS assumptions'!J:J)","v":68017.654451439768},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B8,'BS assumptions'!K:K)","v":74819.419896583742}]
[null,"Trade receivable",{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B9,'BS assumptions'!C:C)","v":32883.599999999999},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B9,'BS assumptions'!D:D)","v":38556},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B9,'BS assumptions'!E:E)","v":43581.599999999999},null,{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B9,'BS assumptions'!G:G)","v":47939.759999999995},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B9,'BS assumptions'!H:H)","v":52733.736000000004},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B9,'BS assumptions'!I:I)","v":58007.109600000011},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B9,'BS assumptions'!J:J)","v":63807.820560000022},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B9,'BS assumptions'!K:K)","v":70188.602616000018}]
[null,"Other assets",{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B10,'BS assumptions'!C:C)","v":8841.6},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B10,'BS assumptions'!D:D)","v":11359.199999999999},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B10,'BS assumptions'!E:E)","v":17602.8},null,{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B10,'BS assumptions'!G:G)","v":14867.518484339287},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B10,'BS assumptions'!H:H)","v":16354.270332773216},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B10,'BS assumptions'!I:I)","v":17989.697366050539},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B10,'BS assumptions'!J:J)","v":19788.6671026556},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B10,'BS assumptions'!K:K)","v":21767.53381292116}]
[]
[null,"Cash and equivalents",{"$f":"'BS source'!D14","v":11791.199999999999},{"$f":"'BS source'!E14","v":19408.8},{"$f":"'BS source'!F14","v":8173.6},null,{"$f":"E12+'Cash Flow'!G30","v":23746.539181652879},{"$f":"G12+'Cash Flow'!H30","v":35914.870622357827},{"$f":"H12+'Cash Flow'!I30","v":49306.50664713329},{"$f":"I12+'Cash Flow'!J30","v":64043.777714386284},{"$f":"J12+'Cash Flow'!K30","v":80261.24732836464},null,"Opening cash + Net Cash Flow"]
[]
[null,"Total Assets",{"$f":"SUM(C4:C12)","v":144575.6},{"$f":"SUM(D4:D12)","v":170464.2},187652.19999999998,null,{"$f":"SUM(G4:G12)","v":213527.50694734912},243076.6351646237,275587.14764362579,311355.18281052803,350706.49293412059]
[]
[null,"Trade payable",{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B16,'BS assumptions'!C:C)","v":15891.2},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B16,'BS assumptions'!D:D)","v":26351.599999999999},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B16,'BS assumptions'!E:E)","v":36189.599999999999},null,{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B16,'BS assumptions'!G:G)","v":40019.588088812387},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B16,'BS assumptions'!H:H)","v":44021.546897693624},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B16,'BS assumptions'!I:I)","v":48423.701587462994},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B16,'BS assumptions'!J:J)","v":53266.071746209302},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B16,'BS assumptions'!K:K)","v":58592.678920830236}]
[null,"Other liabilities",{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B17,'BS assumptions'!C:C)","v":5969.0386666666891},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B17,'BS assumptions'!D:D)","v":5800.3560000000052},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B17,'BS assumptions'!E:E)","v":8473.4464253970418},null,{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B17,'BS assumptions'!G:G)","v":8029.9438439337491},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B17,'BS assumptions'!H:H)","v":8832.9382283271243},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B17,'BS assumptions'!I:I)","v":9716.2320511598391},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B17,'BS assumptions'!J:J)","v":10687.855256275825},{"$f":"+SUMIF('BS assumptions'!$B:$B,BS!$B17,'BS assumptions'!K:K)","v":11756.640781903407}]
[]
[null,"Financial liabilities",{"$f":"'BS source'!J15+'BS source'!J16","v":41293.000000000007},{"$f":"'BS source'!K15+'BS source'!K16","v":50645.4},{"$f":"'BS source'!L15+'BS source'!L16","v":51120.799999999996},null,{"$f":"$E$19","v":51120.799999999996},{"$f":"$E$19","v":51120.799999999996},51120.799999999996,51120.799999999996,51120.799999999996,null,"No additional debt"]
[]
[null,"Shareholders' equity",{"$f":"'BS source'!J8","v":81422.361333333276},{"$f":"'BS source'!K8","v":87666.844000000026},{"$f":"'BS source'!L8","v":91868.353574602996},null,{"$f":"E21+'P&L'!G24","v":114357.17501460301},{"$f":"G21+'P&L'!H24","v":139101.35003860301},{"$f":"H21+'P&L'!I24","v":166326.414005003},{"$f":"I21+'P&L'!J24","v":196280.45580804299},{"$f":"J21+'P&L'!K24","v":229236.373231387}]
[]
[null,"Total Liabilities & Equities",{"$f":"+SUM(C16:C21)","v":144575.59999999998},{"$f":"+SUM(D16:D21)","v":170464.2},187652.2,null,{"$f":"+SUM(G16:G21)","v":213527.50694734915},243076.63516462376,275587.14764362585,311355.18281052809,350706.49293412064]
[]
[]
[null,"Check",{"$f":"C14-C23","v":0},{"$f":"D14-D23","v":0},{"$f":"E14-E23","v":0},null,{"$f":"G14-G23","v":0},0,0,0,0]

{"sheet":"Cash Flow","index":7,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,"Cash Flow"]
[null,"."]
[null,"$ in thousands",null,"FY12\nActual","FY13\nActual",null,"FY14\nForecast","FY15\nForecast","FY16\nForecast","FY17\nForecast","FY18\nForecast",null,"Note"]
[null,"EBIT","P&L",{"$f":"'P&L'!D15","v":16564.136000000017},{"$f":"'P&L'!E15","v":23130.213574602993},null,{"$f":"'P&L'!G15","v":30089.312000000009},{"$f":"'P&L'!H15","v":32839.743199999983},{"$f":"'P&L'!I15","v":35865.217519999998},{"$f":"'P&L'!J15","v":39193.239271999992},{"$f":"'P&L'!K15","v":42854.063199200005}]
[null,"Operating taxes",null,{"$f":"+D4*D6","v":-3740.0277204742097},{"$f":"+E4*E6","v":-4379.9683364332095},null,{"$f":"+G4*G6","v":-5416.0761600000014},{"$f":"+H4*H6","v":-5911.1537759999965},{"$f":"+I4*I6","v":-6455.7391535999996},{"$f":"+J4*J6","v":-7054.7830689599987},{"$f":"+K4*K6","v":-7713.7313758560003}]
[null,"Operating tax rate","P&L",{"$f":"'P&L'!D22","v":-0.22579069143565386},{"$f":"'P&L'!E22","v":-0.18936134430001206},null,{"$f":"'P&L'!G22","v":-0.18},{"$f":"'P&L'!H22","v":-0.18},{"$f":"'P&L'!I22","v":-0.18},{"$f":"'P&L'!J22","v":-0.18},{"$f":"'P&L'!K22","v":-0.18}]
[null,"NOPAT",null,{"$f":"SUM(D4:D5)","v":12824.108279525808},{"$f":"SUM(E4:E5)","v":18750.245238169784},null,{"$f":"SUM(G4:G5)","v":24673.235840000008},{"$f":"SUM(H4:H5)","v":26928.589423999987},{"$f":"SUM(I4:I5)","v":29409.478366399999},{"$f":"SUM(J4:J5)","v":32138.456203039994},{"$f":"SUM(K4:K5)","v":35140.331823344008}]
[]
[null,"Add-back D&A","P&L",{"$f":"-'P&L'!D14","v":4649.8},{"$f":"-'P&L'!E14","v":6430.6600000000008},null,{"$f":"-'P&L'!G14","v":4584.0520000000006},{"$f":"-'P&L'!H14","v":5042.4572000000007},{"$f":"-'P&L'!I14","v":5546.7029200000015},{"$f":"-'P&L'!J14","v":6101.3732120000022},{"$f":"-'P&L'!K14","v":6711.510533200003}]
[null,"Gross Cash Flow",null,{"$f":"+D7+D9","v":17473.908279525807},{"$f":"+E7+E9","v":25180.905238169784},null,{"$f":"+G7+G9","v":29257.287840000008},{"$f":"+H7+H9","v":31971.046623999988},{"$f":"+I7+I9","v":34956.181286400002},{"$f":"+J7+J9","v":38239.829415039996},{"$f":"+K7+K9","v":41851.84235654401},null,"1)"]
[]
[null,"Inventory","BS",{"$f":"-(BS!D8-BS!C8)","v":-5229.6000000000022},{"$f":"-(BS!E8-BS!D8)","v":-9815.1999999999971},null,{"$f":"-(BS!G8-BS!E8)","v":-4890.6705119757535},{"$f":"-(BS!H8-BS!G8)","v":-5110.2670511975884},{"$f":"-(BS!I8-BS!H8)","v":-5621.2937563173473},{"$f":"-(BS!J8-BS!I8)","v":-6183.4231319490791},{"$f":"-(BS!K8-BS!J8)","v":-6801.7654451439739}]
[null,"Trade receivables","BS",{"$f":"-(BS!D9-BS!C9)","v":-5672.4000000000015},{"$f":"-(BS!E9-BS!D9)","v":-5025.5999999999985},null,{"$f":"-(BS!G9-BS!E9)","v":-4358.1599999999962},{"$f":"-(BS!H9-BS!G9)","v":-4793.9760000000097},{"$f":"-(BS!I9-BS!H9)","v":-5273.3736000000063},{"$f":"-(BS!J9-BS!I9)","v":-5800.7109600000113},{"$f":"-(BS!K9-BS!J9)","v":-6380.7820559999964}]
[null,"Trade payables","BS",{"$f":"BS!D16-BS!C16","v":10460.399999999998},{"$f":"BS!E16-BS!D16","v":9838},null,{"$f":"BS!G16-BS!E16","v":3829.988088812388},{"$f":"BS!H16-BS!G16","v":4001.9588088812379},{"$f":"BS!I16-BS!H16","v":4402.1546897693697},{"$f":"BS!J16-BS!I16","v":4842.3701587463074},{"$f":"BS!K16-BS!J16","v":5326.6071746209345}]
[null,"Investments in working capital",null,{"$f":"SUM(D12:D14)","v":-441.60000000000582},{"$f":"SUM(E12:E14)","v":-5002.7999999999956},null,{"$f":"SUM(G12:G14)","v":-5418.8424231633617},{"$f":"SUM(H12:H14)","v":-5902.2842423163602},{"$f":"SUM(I12:I14)","v":-6492.5126665479838},{"$f":"SUM(J12:J14)","v":-7141.7639332027829},{"$f":"SUM(K12:K14)","v":-7855.9403265230358},null,"2)"]
[null,"Investments in other assets/liabilities","BS",{"$f":"-(BS!D10-BS!C10)+BS!D17-BS!C17","v":-2686.2826666666824},{"$f":"-(BS!E10-BS!D10)+BS!E17-BS!D17","v":-3570.5095746029638},null,{"$f":"-(BS!G10-BS!E10)+BS!G17-BS!E17","v":2291.7789341974185},{"$f":"-(BS!H10-BS!G10)+BS!H17-BS!G17","v":-683.75746404055371},{"$f":"-(BS!I10-BS!H10)+BS!I17-BS!H17","v":-752.13321044460827},{"$f":"-(BS!J10-BS!I10)+BS!J17-BS!I17","v":-827.34653148907455},{"$f":"-(BS!K10-BS!J10)+BS!K17-BS!J17","v":-910.08118463797837},null,"3)"]
[]
[null,"Capex","BS, P&L",{"$f":"-(BS!D5-BS!C5)+'P&L'!D14","v":-8615.7999999999993},{"$f":"-(BS!E5-BS!D5)+'P&L'!E14","v":-13467.459999999995},null,{"$f":"-(BS!G5-BS!E5)+'P&L'!G14","v":-8372.8707693811848},{"$f":"-(BS!H5-BS!G5)+'P&L'!H14","v":-11032.259076938124},{"$f":"-(BS!I5-BS!H5)+'P&L'!I14","v":-12135.484984631947},{"$f":"-(BS!J5-BS!I5)+'P&L'!J14","v":-13349.033483095143},{"$f":"-(BS!K5-BS!J5)+'P&L'!K14","v":-14683.936831404637},null,"4)"]
[null,"Other investments","BS",{"$f":"-(BS!D4-BS!C4)-(BS!D6-BS!C6)","v":-885.39999999999964},{"$f":"-(BS!E4-BS!D4)-(BS!E6-BS!D6)","v":-302},null,{"$f":"-(BS!G4-BS!E4)-(BS!G6-BS!E6)","v":0},{"$f":"-(BS!H4-BS!G4)-(BS!H6-BS!G6)","v":0},{"$f":"-(BS!I4-BS!H4)-(BS!I6-BS!H6)","v":0},{"$f":"-(BS!J4-BS!I4)-(BS!J6-BS!I6)","v":0},{"$f":"-(BS!K4-BS!J4)-(BS!K6-BS!J6)","v":0},null,"5)"]
[]
[null,"Extraordinary items","P&L",{"$f":"'P&L'!D18","v":-864.30000000000007},{"$f":"'P&L'!E18","v":-320.26},null,{"$f":"'P&L'!G18","v":0},{"$f":"'P&L'!H18","v":0},{"$f":"'P&L'!I18","v":0},{"$f":"'P&L'!J18","v":0},{"$f":"'P&L'!K18","v":0},null,"6)"]
[]
[null,"UFCF",null,{"$f":"D10+D15+D16+D18+D19+D21","v":3980.52561285912},{"$f":"E10+E15+E16+E18+E19+E21","v":2517.8756635668306},null,{"$f":"G10+G15+G16+G18+G19+G21","v":17757.353581652878},{"$f":"H10+H15+H16+H18+H19+H21","v":14352.745840704949},{"$f":"I10+I15+I16+I18+I19+I21","v":15576.050424775463},{"$f":"J10+J15+J16+J18+J19+J21","v":16921.685467252995},{"$f":"K10+K15+K16+K18+K19+K21","v":18401.884013978357},null,"1)+2)+3)+4)+5)+6)"]
[]
[null,"Interest expenses","P&L",{"$f":"'P&L'!D17","v":-2190.9},{"$f":"'P&L'!E17","v":-2663.92},null,{"$f":"'P&L'!G17","v":-2663.92},{"$f":"'P&L'!H17","v":-2663.92},{"$f":"'P&L'!I17","v":-2663.92},{"$f":"'P&L'!J17","v":-2663.92},{"$f":"'P&L'!K17","v":-2663.92},null,"7)"]
[null,"Delta Taxes vs. Operating taxes",null,{"$f":"'P&L'!D21-'Cash Flow'!D5","v":689.83572047420967},{"$f":"'P&L'!E21-'Cash Flow'!E5","v":565.08833643320941},null,{"$f":"'P&L'!G21-'Cash Flow'!G5","v":479.50560000000041},{"$f":"'P&L'!H21-'Cash Flow'!H5","v":479.5055999999995},{"$f":"'P&L'!I21-'Cash Flow'!I5","v":479.5055999999995},{"$f":"'P&L'!J21-'Cash Flow'!J5","v":479.50560000000041},{"$f":"'P&L'!K21-'Cash Flow'!K5","v":479.5055999999995},null,"8)"]
[null,"Delta Financial liabilities","BS",{"$f":"BS!D19-BS!C19","v":9352.3999999999942},{"$f":"BS!E19-BS!D19","v":475.39999999999418},null,{"$f":"BS!G19-BS!E19","v":0},{"$f":"BS!H19-BS!G19","v":0},{"$f":"BS!I19-BS!H19","v":0},{"$f":"BS!J19-BS!I19","v":0},{"$f":"BS!K19-BS!J19","v":0},null,"9)"]
[null,"Delta equity incl. dividends","BS",{"$f":"BS!D21-BS!C21-'P&L'!D24","v":-4214.2613333332665},{"$f":"BS!E21-BS!D21-'P&L'!E24","v":-12129.644000000022},null,{"$f":"BS!G21-BS!E21-'P&L'!G24","v":0},{"$f":"BS!H21-BS!G21-'P&L'!H24","v":0},{"$f":"BS!I21-BS!H21-'P&L'!I24","v":0},{"$f":"BS!J21-BS!I21-'P&L'!J24","v":0},{"$f":"BS!K21-BS!J21-'P&L'!K24","v":0},null,"10)"]
[]
[null,"Net Cash Flow",null,{"$f":"SUM(D23,D25:D28)","v":7617.6000000000568},{"$f":"SUM(E23,E25:E28)","v":-11235.199999999988},null,{"$f":"SUM(G23,G25:G28)","v":15572.939181652879},{"$f":"SUM(H23,H25:H28)","v":12168.331440704947},{"$f":"SUM(I23,I25:I28)","v":13391.636024775464},{"$f":"SUM(J23,J25:J28)","v":14737.271067252996},{"$f":"SUM(K23,K25:K28)","v":16217.469613978355},null,"1)+2)+3)+4)+5)+6)+7)+8)+9)+10)"]
[]
[null,"Opening cash",null,{"$f":"BS!C12","v":11791.199999999999},{"$f":"BS!D12","v":19408.8},null,{"$f":"BS!E12","v":8173.6},{"$f":"BS!G12","v":23746.539181652879},{"$f":"BS!H12","v":35914.870622357827},{"$f":"BS!I12","v":49306.50664713329},{"$f":"BS!J12","v":64043.777714386284}]
[null,"Closing cash",null,{"$f":"D30+D32","v":19408.800000000054},{"$f":"E30+E32","v":8173.6000000000113},null,{"$f":"G30+G32","v":23746.539181652879},{"$f":"H30+H32","v":35914.870622357827},{"$f":"I30+I32","v":49306.50664713329},{"$f":"J30+J32","v":64043.777714386284},{"$f":"K30+K32","v":80261.24732836464}]
[]
[null,"Check",null,{"$f":"BS!D12","v":19408.8},{"$f":"BS!E12","v":8173.6},null,{"$f":"BS!G12","v":23746.539181652879},{"$f":"BS!H12","v":35914.870622357827},{"$f":"BS!I12","v":49306.50664713329},{"$f":"BS!J12","v":64043.777714386284},{"$f":"BS!K12","v":80261.24732836464}]
[null,null,null,{"$f":"D33-D35","v":5.4569682106375694E-11},{"$f":"E33-E35","v":1.0913936421275139E-11},null,{"$f":"G33-G35","v":0},{"$f":"H33-H35","v":0},{"$f":"I33-I35","v":0},{"$f":"J33-J35","v":0},{"$f":"K33-K35","v":0}]

{"sheet":"DCF valuation","index":8,"n_rows":4,"n_cols":13,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,"DCF Valuation"]
[]
[]
[null,"$ in thousands","FY11\nActual","FY12\nActual","FY13\nActual",null,"FY14\nForecast","FY15\nForecast","FY16\nForecast","FY17\nForecast","FY18\nForecast",null,"Note"]

{"sheet":"3.Charts  -->","index":9,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3.Charts -->"]

{"sheet":"Revenues&Ebitda","index":10,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,"Revenues & EBITDA"]

{"sheet":"Cash flows","index":11,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,"Cash flows"]

{"sheet":"Ebitda bridge","index":12,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,"Ebitda bridge"]

{"sheet":"Working capital","index":13,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,"Working capital"]

{"sheet":"DCF results","index":14,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,"DCF results"]

{"sheet":"4.Sources -->","index":15,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"4.Sources -->"]

{"sheet":"P&L source","index":16,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,"P&L source"]
[]
[null,"USD in thousands",null,"2011\nAct","2012\nAct","2013\nAct"]
[null,"Revenue from sales and services",null,177203,188618,208366]
[null,"Other revenue",null,3520,2416,2585]
[null,"Revenue",null,{"$f":"D4+D5","v":180723},{"$f":"E4+E5","v":191034},{"$f":"F4+F5","v":210951}]
[]
[null,"Raw materials",null,-139903.0394666667,-138922.98879999999,-150080.46882539699]
[null,"Direct costs",null,-2491.3280000000004,-11649.177600000001,-7442.6495999999997]
[null,"Cost for services",null,-16389.593600000004,-17878.310399999998,-22293.312000000005]
[null,"Lease costs",null,-290.72640000000007,-246.13120000000004,-120.92160000000001]
[null,"Other operating expenses",null,-1330.9952000000003,-1123.4560000000001,-1452.7744000000002]
[]
[null,"EBITDA",null,{"$f":"D6+SUM(D8:D12)","v":20317.317333333282},{"$f":"E6+SUM(E8:E12)","v":21213.936000000016},{"$f":"F6+SUM(F8:F12)","v":29560.873574603}]
[]
[null,"D&A",null,-2907.8000000000006,-4649.8,-6430.6600000000008]
[]
[null,"EBIT",null,{"$f":"D14+D16","v":17409.517333333282},{"$f":"E14+E16","v":16564.136000000017},{"$f":"F14+F16","v":23130.213574603}]
[]
[null,"Financial income/expenses",null,-1266.3000000000002,-2190.9,-2663.92]
[null,"Extraordinary income",null,-317.58000000000004,-864.30000000000007,-320.26]
[]
[null,"EBT",null,{"$f":"D18+D21+D20","v":15825.637333333281},{"$f":"E18+E21+E20","v":13508.936000000018},{"$f":"F18+F21+F20","v":20146.033574603003}]
[]
[null,"Taxes",null,-3805.7759999999998,-3050.192,-3814.88]
[]
[null,"Net Income",null,{"$f":"D23+D25","v":12019.861333333281},{"$f":"E23+E25","v":10458.744000000017},{"$f":"F23+F25","v":16331.153574603002}]

{"sheet":"BS source","index":17,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,"BS source"]
[]
[null,"USD in thousands",null,"31Dec11\nAct","31Dec12\nAct","31Dec13\nAct",null,"USD in thousands",null,"31Dec11\nAct","31Dec12\nAct","31Dec13\nAct"]
[null,"Intangible assets",null,5961.6,5840,5650,null,"Share Capital",null,6784.8,6800,7508]
[null,"PP&E",null,45106.400000000001,49072.4,56109.2,null,"Reserves",null,46224,44414.400000000001,46513.2]
[null,"Financial assets",null,8824,9831,10323,null,"Retained earnings",null,16393.7,25993.7,21516]
[null,null,null,null,null,null,null,"Profit/(loss) for the year",null,12019.861333333281,10458.744000000017,16331.153574603002]
[null,"Fixed assets",null,{"$f":"D6+D5+D4","v":59892},{"$f":"E6+E5+E4","v":64743.4},{"$f":"F6+F5+F4","v":72082.2},null,"Total Equity",null,{"$f":"SUM(J4:J7)","v":81422.361333333276},{"$f":"SUM(K4:K7)","v":87666.844000000026},{"$f":"SUM(L4:L7)","v":91868.353574602996}]
[]
[null,"Inventory",null,31167.200000000001,36396.800000000003,46212,null,"Trade payable",null,15891.2,26351.599999999999,36189.599999999999]
[null,"Trade receivables",null,32883.599999999999,38556,43581.599999999999,null,"Other liabilities",null,5315,4334,6473.0464253970422]
[null,"Other assets",null,8841.6,11359.199999999999,17602.8,null,"Deferred taxes",null,478.83866666668911,1217.9560000000056,1760.3999999999999]
[null,null,null,null,null,null,null,"Provisions for retirement benefits",null,175.2,248.39999999999998,240]
[null,"Cash and equivalents",null,11791.199999999999,19408.8,8173.6]
[null,"Non fixed assets",null,{"$f":"+D14+D12+D11+D10","v":84683.599999999991},{"$f":"+E14+E12+E11+E10","v":105720.8},{"$f":"+F14+F12+F11+F10","v":115570},null,"Bank borrowings",null,37402.600000000006,45594.6,50680.399999999994]
[null,null,null,null,null,null,null,"Other Financial liabilities",null,3890.3999999999996,5050.8,440.4]
[null,null,null,null,null,null,null,"Total Liabilities",null,{"$f":"J16+J15+SUM(J10:J13)","v":63153.238666666701},{"$f":"K16+K15+SUM(K10:K13)","v":82797.356},{"$f":"L16+L15+SUM(L10:L13)","v":95783.846425397031}]
[]
[null,"Total Assets",null,{"$f":"D15+D8","v":144575.59999999998},{"$f":"E15+E8","v":170464.2},{"$f":"F15+F8","v":187652.2},null,"Total Liabilities & Equity",null,{"$f":"J17+J8","v":144575.59999999998},{"$f":"K17+K8","v":170464.2},{"$f":"L17+L8","v":187652.2}]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"J19-D19","v":0},{"$f":"K19-E19","v":0},{"$f":"L19-F19","v":0}]