{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Profit & Loss","Quarters","Balance Sheet","Cash Flow","Customization","Data Sheet","Calculated Data","Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"Profit & Loss","index":0,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Data Sheet'!B1","v":"ZENITH FIBRES LTD"},null,null,null,null,null,null,{"$f":"UPDATE","v":""},null,null,null,null,"SCREENER.IN"]
[]
["Narration",{"$f":"'Data Sheet'!B16","v":"2007-03-31"},{"$f":"'Data Sheet'!C16","v":"2008-03-31"},{"$f":"'Data Sheet'!D16","v":"2009-03-31"},{"$f":"'Data Sheet'!E16","v":"2010-03-31"},{"$f":"'Data Sheet'!F16","v":"2011-03-31"},{"$f":"'Data Sheet'!G16","v":"2012-03-31"},{"$f":"'Data Sheet'!H16","v":"2013-03-31"},{"$f":"'Data Sheet'!I16","v":"2014-03-31"},{"$f":"'Data Sheet'!J16","v":"2015-03-31"},{"$f":"'Data Sheet'!K16","v":"2016-03-31"},"Trailing","Best Case","Worst Case"]
["Sales",{"$f":"'Data Sheet'!B17","v":34.24},{"$f":"'Data Sheet'!C17","v":33.47},{"$f":"'Data Sheet'!D17","v":35.22},{"$f":"'Data Sheet'!E17","v":33.979999999999997},{"$f":"'Data Sheet'!F17","v":39.380000000000003},{"$f":"'Data Sheet'!G17","v":50.43},{"$f":"'Data Sheet'!H17","v":54.22},{"$f":"'Data Sheet'!I17","v":55.57},{"$f":"'Data Sheet'!J17","v":66.89},{"$f":"'Data Sheet'!K17","v":63.83},{"$f":"SUM(Quarters!H4:K4)","v":57.69},{"$f":"$K4+M23*K4","v":67.397939821226203},{"$f":"$K4+N23*L4","v":61.190870085214527}]
["Expenses",{"$f":"SUM('Data Sheet'!B18,'Data Sheet'!B20:B24, -1*'Data Sheet'!B19)","v":29.699999999999996},{"$f":"SUM('Data Sheet'!C18,'Data Sheet'!C20:C24, -1*'Data Sheet'!C19)","v":30.34},{"$f":"SUM('Data Sheet'!D18,'Data Sheet'!D20:D24, -1*'Data Sheet'!D19)","v":30.74},{"$f":"SUM('Data Sheet'!E18,'Data Sheet'!E20:E24, -1*'Data Sheet'!E19)","v":29.979999999999993},{"$f":"SUM('Data Sheet'!F18,'Data Sheet'!F20:F24, -1*'Data Sheet'!F19)","v":35.680000000000007},{"$f":"SUM('Data Sheet'!G18,'Data Sheet'!G20:G24, -1*'Data Sheet'!G19)","v":45.27},{"$f":"SUM('Data Sheet'!H18,'Data Sheet'!H20:H24, -1*'Data Sheet'!H19)","v":48.49},{"$f":"SUM('Data Sheet'!I18,'Data Sheet'!I20:I24, -1*'Data Sheet'!I19)","v":50.959999999999994},{"$f":"SUM('Data Sheet'!J18,'Data Sheet'!J20:J24, -1*'Data Sheet'!J19)","v":59.900000000000013},{"$f":"SUM('Data Sheet'!K18,'Data Sheet'!K20:K24, -1*'Data Sheet'!K19)","v":52.629999999999995},{"$f":"SUM(Quarters!H5:K5)","v":47.410000000000004},{"$f":"M4-M6","v":55.388045188496001},54.238660058239425]
["Operating Profit",{"$f":"B4-B5","v":4.5400000000000063},{"$f":"C4-C5","v":3.129999999999999},4.4800000000000004,4.0000000000000036,3.6999999999999957,5.1599999999999966,5.7299999999999969,4.6100000000000065,6.9899999999999878,11.200000000000003,{"$f":"SUM(Quarters!H6:K6)","v":10.280000000000001},{"$f":"M4*M24","v":12.009894632730203},{"$f":"N4*N24","v":6.9522100269750995}]
["Other Income",{"$f":"'Data Sheet'!B25","v":0.52},{"$f":"'Data Sheet'!C25","v":0.62},{"$f":"'Data Sheet'!D25","v":0.81},{"$f":"'Data Sheet'!E25","v":0.98},{"$f":"'Data Sheet'!F25","v":1.1000000000000001},{"$f":"'Data Sheet'!G25","v":1.36},{"$f":"'Data Sheet'!H25","v":1.75},{"$f":"'Data Sheet'!I25","v":1.91},{"$f":"'Data Sheet'!J25","v":2.95},{"$f":"'Data Sheet'!K25","v":2.96},{"$f":"SUM(Quarters!H7:K7)","v":2.9},0,0]
["Depreciation",{"$f":"'Data Sheet'!B26","v":0.85},{"$f":"'Data Sheet'!C26","v":0.88},{"$f":"'Data Sheet'!D26","v":0.91},{"$f":"'Data Sheet'!E26","v":0.95},{"$f":"'Data Sheet'!F26","v":0.95},{"$f":"'Data Sheet'!G26","v":0.94},{"$f":"'Data Sheet'!H26","v":1.06},{"$f":"'Data Sheet'!I26","v":1.1100000000000001},{"$f":"'Data Sheet'!J26","v":0.81},{"$f":"'Data Sheet'!K26","v":0.72},{"$f":"SUM(Quarters!H8:K8)","v":0.68},{"$f":"+$L8","v":0.68},{"$f":"+$L8","v":0.68}]
["Interest",{"$f":"'Data Sheet'!B27","v":0.12},{"$f":"'Data Sheet'!C27","v":0.11},{"$f":"'Data Sheet'!D27","v":0.15},{"$f":"'Data Sheet'!E27","v":0.16},{"$f":"'Data Sheet'!F27","v":0.14000000000000001},{"$f":"'Data Sheet'!G27","v":0.16},{"$f":"'Data Sheet'!H27","v":0.2},{"$f":"'Data Sheet'!I27","v":0.23},{"$f":"'Data Sheet'!J27","v":0.27},{"$f":"'Data Sheet'!K27","v":0.27},{"$f":"SUM(Quarters!H9:K9)","v":0.32},{"$f":"+$L9","v":0.32},{"$f":"+$L9","v":0.32}]
["Profit before tax",{"$f":"'Data Sheet'!B28","v":4.09},{"$f":"'Data Sheet'!C28","v":2.76},{"$f":"'Data Sheet'!D28","v":4.2300000000000004},{"$f":"'Data Sheet'!E28","v":3.87},{"$f":"'Data Sheet'!F28","v":3.71},{"$f":"'Data Sheet'!G28","v":5.42},{"$f":"'Data Sheet'!H28","v":6.21},{"$f":"'Data Sheet'!I28","v":5.17},{"$f":"'Data Sheet'!J28","v":8.8699999999999992},{"$f":"'Data Sheet'!K28","v":13.17},{"$f":"SUM(Quarters!H10:K10)","v":12.190000000000001},{"$f":"M6+M7-SUM(M8:M9)","v":11.009894632730203},{"$f":"N6+N7-SUM(N8:N9)","v":5.9522100269750995}]
["Tax",{"$f":"'Data Sheet'!B29","v":1.49},{"$f":"'Data Sheet'!C29","v":1.01},{"$f":"'Data Sheet'!D29","v":1.54},{"$f":"'Data Sheet'!E29","v":1.01},{"$f":"'Data Sheet'!F29","v":1.23},{"$f":"'Data Sheet'!G29","v":1.88},{"$f":"'Data Sheet'!H29","v":1.77},{"$f":"'Data Sheet'!I29","v":1.77},{"$f":"'Data Sheet'!J29","v":2.97},{"$f":"'Data Sheet'!K29","v":4.68},{"$f":"SUM(Quarters!H11:K11)","v":4.42},{"$f":"IF($L10>0,$L11/$L10,0)","v":0.36259228876127969},{"$f":"IF($L10>0,$L11/$L10,0)","v":0.36259228876127969}]
["Net profit",{"$f":"'Data Sheet'!B30","v":2.6},{"$f":"'Data Sheet'!C30","v":1.75},{"$f":"'Data Sheet'!D30","v":2.69},{"$f":"'Data Sheet'!E30","v":2.86},{"$f":"'Data Sheet'!F30","v":2.48},{"$f":"'Data Sheet'!G30","v":3.54},{"$f":"'Data Sheet'!H30","v":4.45},{"$f":"'Data Sheet'!I30","v":3.39},{"$f":"'Data Sheet'!J30","v":5.91},{"$f":"'Data Sheet'!K30","v":8.49},{"$f":"SUM(Quarters!H12:K12)","v":7.77},{"$f":"M10-M11*M10","v":7.0177917388280306},{"$f":"N10-N11*N10","v":3.7939845701063599}]
["EPS",{"$f":"IF('Data Sheet'!B93>0,B12/'Data Sheet'!B93,0)","v":4.5181819461443133},{"$f":"IF('Data Sheet'!C93>0,C12/'Data Sheet'!C93,0)","v":3.0410840022125187},{"$f":"IF('Data Sheet'!D93>0,D12/'Data Sheet'!D93,0)","v":4.6745805519723858},{"$f":"IF('Data Sheet'!E93>0,E12/'Data Sheet'!E93,0)","v":4.9700001407587449},{"$f":"IF('Data Sheet'!F93>0,F12/'Data Sheet'!F93,0)","v":4.3096504717068838},{"$f":"IF('Data Sheet'!G93>0,G12/'Data Sheet'!G93,0)","v":6.1516784959041813},{"$f":"IF('Data Sheet'!H93>0,H12/'Data Sheet'!H93,0)","v":7.7330421770546911},{"$f":"IF('Data Sheet'!I93>0,I12/'Data Sheet'!I93,0)","v":5.8910141528573936},{"$f":"IF('Data Sheet'!J93>0,J12/'Data Sheet'!J93,0)","v":10.27017511604342},{"$f":"IF('Data Sheet'!K93>0,K12/'Data Sheet'!K93,0)","v":19.19795511251268},{"$f":"IF('Data Sheet'!$B6>0,'Profit & Loss'!L12/'Data Sheet'!$B6,0)","v":17.568783805933453},{"$f":"IF('Data Sheet'!$B6>0,'Profit & Loss'!M12/'Data Sheet'!$B6,0)","v":15.867962143440858},{"$f":"IF('Data Sheet'!$B6>0,'Profit & Loss'!N12/'Data Sheet'!$B6,0)","v":8.5785964833006449}]
["Price to earning",{"$f":"IF(B15>0,B15/B13,\"\")","v":5.7102614076923084},{"$f":"IF(C15>0,C15/C13,\"\")","v":7.7669672994285719},3.8142459631970262,5.2796779188811191,6.1025830685483875,4.9905078785310737,4.1898129168539322,4.7631866554572273,5.8791597336717434,6.9325091771495879,{"$f":"IF(L13>0,L15/L13,0)","v":7.8519948519948519},{"$f":"M25","v":7.8519948519948519},{"$f":"N25","v":5.7486790251359903}]
["Price",{"$f":"'Data Sheet'!B90","v":25.8},{"$f":"'Data Sheet'!C90","v":23.62},{"$f":"'Data Sheet'!D90","v":17.829999999999998},{"$f":"'Data Sheet'!E90","v":26.24},{"$f":"'Data Sheet'!F90","v":26.3},{"$f":"'Data Sheet'!G90","v":30.7},{"$f":"'Data Sheet'!H90","v":32.4},{"$f":"'Data Sheet'!I90","v":28.06},{"$f":"'Data Sheet'!J90","v":60.38},{"$f":"'Data Sheet'!K90","v":133.09},{"$f":"'Data Sheet'!B8","v":137.94999999999999},{"$f":"M13*M14","v":124.59515706194681},{"$f":"N13*N14","v":49.315597668655784}]
[]
["RATIOS:"]
["Dividend Payout",{"$f":"IF('Data Sheet'!B30>0, 'Data Sheet'!B31/'Data Sheet'!B30, 0)","v":0.25384615384615383},{"$f":"IF('Data Sheet'!C30>0, 'Data Sheet'!C31/'Data Sheet'!C30, 0)","v":0.3828571428571429},{"$f":"IF('Data Sheet'!D30>0, 'Data Sheet'!D31/'Data Sheet'!D30, 0)","v":0.24535315985130113},{"$f":"IF('Data Sheet'!E30>0, 'Data Sheet'!E31/'Data Sheet'!E30, 0)","v":0.23076923076923078},{"$f":"IF('Data Sheet'!F30>0, 'Data Sheet'!F31/'Data Sheet'!F30, 0)","v":0.26612903225806456},{"$f":"IF('Data Sheet'!G30>0, 'Data Sheet'!G31/'Data Sheet'!G30, 0)","v":0.25141242937853109},{"$f":"IF('Data Sheet'!H30>0, 'Data Sheet'!H31/'Data Sheet'!H30, 0)","v":0.19775280898876405},{"$f":"IF('Data Sheet'!I30>0, 'Data Sheet'!I31/'Data Sheet'!I30, 0)","v":0.19469026548672566},{"$f":"IF('Data Sheet'!J30>0, 'Data Sheet'!J31/'Data Sheet'!J30, 0)","v":0.18781725888324874},{"$f":"IF('Data Sheet'!K30>0, 'Data Sheet'!K31/'Data Sheet'!K30, 0)","v":0.15665488810365136}]
["OPM",{"$f":"IF(B6>0,B6/B4,0)","v":0.13259345794392541},{"$f":"IF(C6>0,C6/C4,0)","v":9.3516582013743618E-2},0.12720045428733676,0.11771630370806369,9.3956323006602227E-2,0.10232004759071975,0.10568056067871628,8.2958430807990036E-2,0.10449992525041094,0.17546608177972745,0.17819379441844344]
[]
[]
[null,null,null,null,null,null,"TRENDS:","10 YEARS","7 YEARS","5 YEARS","3 YEARS","RECENT","BEST","WORST"]
[null,null,null,null,null,null,"Sales Growth",{"$f":"IF(B4=0,\"\",POWER($K4/B4,1/9)-1)","v":7.1653940915030301E-2},{"$f":"IF(D4=0,\"\",POWER($K4/D4,1/7)-1)","v":8.8656286285516694E-2},{"$f":"IF(F4=0,\"\",POWER($K4/F4,1/5)-1)","v":0.10141205749397852},{"$f":"IF(H4=0,\"\",POWER($K4/H4, 1/3)-1)","v":5.5897537540751996E-2},{"$f":"IF(ISERROR(MAX(IF(J4=0,\"\",(K4-J4)/J4),IF(K4=0,\"\",(L4-K4)/K4))),\"\",MAX(IF(J4=0,\"\",(K4-J4)/J4),IF(K4=0,\"\",(L4-K4)/K4)))","v":-4.5746748392883875E-2},{"$f":"MAX(K23:L23)","v":5.5897537540751996E-2},{"$f":"MIN(H23:L23)","v":-4.5746748392883875E-2}]
[null,null,null,null,null,null,"OPM",{"$f":"IF(SUM(B4:$K$4)=0,\"\",SUMPRODUCT(B19:$K$19,B4:$K$4)/SUM(B4:$K$4))","v":0.11459024463326414},{"$f":"IF(SUM(E4:$K$4)=0,\"\",SUMPRODUCT(E19:$K$19,E4:$K$4)/SUM(E4:$K$4))","v":0.11361515234696676},{"$f":"IF(SUM(G4:$K$4)=0,\"\",SUMPRODUCT(G19:$K$19,G4:$K$4)/SUM(G4:$K$4))","v":0.1157970715611466},{"$f":"IF(SUM(I4:$K$4)=0, \"\", SUMPRODUCT(I19:$K$19,I4:$K$4)/SUM(I4:$K$4))","v":0.12238982232003862},{"$f":"L19","v":0.17819379441844344},{"$f":"MAX(K24:L24)","v":0.17819379441844344},{"$f":"MIN(H24:L24)","v":0.11361515234696676}]
[null,null,null,null,null,null,"Price to Earning",{"$f":"IF(ISERROR(AVERAGEIF(B14:$L14,\">0\")),\"\",AVERAGEIF(B14:$L14,\">0\"))","v":5.7528097155823481},{"$f":"IF(ISERROR(AVERAGEIF(E14:$L14,\">0\")),\"\",AVERAGEIF(E14:$L14,\">0\"))","v":5.7486790251359903},{"$f":"IF(ISERROR(AVERAGEIF(G14:$L14,\">0\")),\"\",AVERAGEIF(G14:$L14,\">0\"))","v":5.7678618689430685},{"$f":"IF(ISERROR(AVERAGEIF(I14:$L14,\">0\")),\"\",AVERAGEIF(I14:$L14,\">0\"))","v":6.3567126045683526},{"$f":"L14","v":7.8519948519948519},{"$f":"MAX(K25:L25)","v":7.8519948519948519},{"$f":"MIN(H25:L25)","v":5.7486790251359903}]

{"sheet":"Quarters","index":1,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Profit & Loss'!A1","v":"ZENITH FIBRES LTD"},null,null,null,{"$f":"UPDATE","v":""},null,null,null,null,"SCREENER.IN"]
[]
["Narration",{"$f":"'Data Sheet'!B41","v":"2014-06-30"},{"$f":"'Data Sheet'!C41","v":"2014-09-30"},{"$f":"'Data Sheet'!D41","v":"2014-12-31"},{"$f":"'Data Sheet'!E41","v":"2015-03-31"},{"$f":"'Data Sheet'!F41","v":"2015-06-30"},{"$f":"'Data Sheet'!G41","v":"2015-09-30"},{"$f":"'Data Sheet'!H41","v":"2015-12-31"},{"$f":"'Data Sheet'!I41","v":"2016-03-31"},{"$f":"'Data Sheet'!J41","v":"2016-06-30"},{"$f":"'Data Sheet'!K41","v":"2016-09-30"}]
["Sales",{"$f":"'Data Sheet'!B42","v":16.18},{"$f":"'Data Sheet'!C42","v":17.260000000000002},{"$f":"'Data Sheet'!D42","v":16.87},{"$f":"'Data Sheet'!E42","v":16.59},{"$f":"'Data Sheet'!F42","v":14.53},{"$f":"'Data Sheet'!G42","v":18.45},{"$f":"'Data Sheet'!H42","v":12.92},{"$f":"'Data Sheet'!I42","v":17.93},{"$f":"'Data Sheet'!J42","v":16.23},{"$f":"'Data Sheet'!K42","v":10.61}]
["Expenses",{"$f":"'Data Sheet'!B43","v":14.76},{"$f":"'Data Sheet'!C43","v":15.85},{"$f":"'Data Sheet'!D43","v":14.82},{"$f":"'Data Sheet'!E43","v":14.47},{"$f":"'Data Sheet'!F43","v":12.77},{"$f":"'Data Sheet'!G43","v":14.95},{"$f":"'Data Sheet'!H43","v":10.31},{"$f":"'Data Sheet'!I43","v":14.61},{"$f":"'Data Sheet'!J43","v":13.11},{"$f":"'Data Sheet'!K43","v":9.3800000000000008}]
["Operating Profit",{"$f":"'Data Sheet'!B50","v":1.42},{"$f":"'Data Sheet'!C50","v":1.41},{"$f":"'Data Sheet'!D50","v":2.0499999999999998},{"$f":"'Data Sheet'!E50","v":2.12},{"$f":"'Data Sheet'!F50","v":1.76},{"$f":"'Data Sheet'!G50","v":3.5},{"$f":"'Data Sheet'!H50","v":2.61},{"$f":"'Data Sheet'!I50","v":3.32},{"$f":"'Data Sheet'!J50","v":3.12},{"$f":"'Data Sheet'!K50","v":1.23}]
["Other Income",{"$f":"'Data Sheet'!B44","v":1.1399999999999999},{"$f":"'Data Sheet'!C44","v":0.6},{"$f":"'Data Sheet'!D44","v":0.6},{"$f":"'Data Sheet'!E44","v":0.62},{"$f":"'Data Sheet'!F44","v":0.57999999999999996},{"$f":"'Data Sheet'!G44","v":0.91},{"$f":"'Data Sheet'!H44","v":0.71},{"$f":"'Data Sheet'!I44","v":0.77},{"$f":"'Data Sheet'!J44","v":0.77},{"$f":"'Data Sheet'!K44","v":0.65}]
["Depreciation",{"$f":"'Data Sheet'!B45","v":0.35},{"$f":"'Data Sheet'!C45","v":0.13},{"$f":"'Data Sheet'!D45","v":0.14000000000000001},{"$f":"'Data Sheet'!E45","v":0.2},{"$f":"'Data Sheet'!F45","v":0.18},{"$f":"'Data Sheet'!G45","v":0.18},{"$f":"'Data Sheet'!H45","v":0.18},{"$f":"'Data Sheet'!I45","v":0.18},{"$f":"'Data Sheet'!J45","v":0.16},{"$f":"'Data Sheet'!K45","v":0.16}]
["Interest",{"$f":"'Data Sheet'!B46","v":7.0000000000000007E-2},{"$f":"'Data Sheet'!C46","v":0.04},{"$f":"'Data Sheet'!D46","v":7.0000000000000007E-2},{"$f":"'Data Sheet'!E46","v":0.08},{"$f":"'Data Sheet'!F46","v":0.05},{"$f":"'Data Sheet'!G46","v":0.06},{"$f":"'Data Sheet'!H46","v":0.06},{"$f":"'Data Sheet'!I46","v":0.09},{"$f":"'Data Sheet'!J46","v":7.0000000000000007E-2},{"$f":"'Data Sheet'!K46","v":0.1}]
["Profit before tax",{"$f":"'Data Sheet'!B47","v":2.15},{"$f":"'Data Sheet'!C47","v":1.83},{"$f":"'Data Sheet'!D47","v":2.4300000000000002},{"$f":"'Data Sheet'!E47","v":2.4500000000000002},{"$f":"'Data Sheet'!F47","v":2.11},{"$f":"'Data Sheet'!G47","v":4.16},{"$f":"'Data Sheet'!H47","v":3.08},{"$f":"'Data Sheet'!I47","v":3.82},{"$f":"'Data Sheet'!J47","v":3.66},{"$f":"'Data Sheet'!K47","v":1.63}]
["Tax",{"$f":"'Data Sheet'!B48","v":0.7},{"$f":"'Data Sheet'!C48","v":0.65},{"$f":"'Data Sheet'!D48","v":0.79},{"$f":"'Data Sheet'!E48","v":0.78},{"$f":"'Data Sheet'!F48","v":0.73},{"$f":"'Data Sheet'!G48","v":1.4},{"$f":"'Data Sheet'!H48","v":1.2},{"$f":"'Data Sheet'!I48","v":1.35},{"$f":"'Data Sheet'!J48","v":1.32},{"$f":"'Data Sheet'!K48","v":0.55000000000000004}]
["Net profit",{"$f":"'Data Sheet'!B49","v":1.46},{"$f":"'Data Sheet'!C49","v":1.18},{"$f":"'Data Sheet'!D49","v":1.64},{"$f":"'Data Sheet'!E49","v":1.68},{"$f":"'Data Sheet'!F49","v":1.38},{"$f":"'Data Sheet'!G49","v":2.76},{"$f":"'Data Sheet'!H49","v":1.88},{"$f":"'Data Sheet'!I49","v":2.4700000000000002},{"$f":"'Data Sheet'!J49","v":2.34},{"$f":"'Data Sheet'!K49","v":1.08}]
[]
["OPM",{"$f":"IF(B4>0,B6/B4,\"\")","v":8.7762669962917178E-2},{"$f":"IF(C4>0,C6/C4,\"\")","v":8.1691772885283884E-2},0.12151748666271486,0.12778782399035565,0.12112869924294564,0.18970189701897019,0.20201238390092879,0.18516452872281092,0.19223659889094269,0.11592836946277098]

{"sheet":"Balance Sheet","index":2,"n_rows":37,"n_cols":12,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Profit & Loss'!A1","v":"ZENITH FIBRES LTD"},null,null,null,{"$f":"UPDATE","v":""},null,null,null,null,"SCREENER.IN"]
[]
["Narration",{"$f":"'Data Sheet'!B56","v":"2007-03-31"},{"$f":"'Data Sheet'!C56","v":"2008-03-31"},{"$f":"'Data Sheet'!D56","v":"2009-03-31"},{"$f":"'Data Sheet'!E56","v":"2010-03-31"},{"$f":"'Data Sheet'!F56","v":"2011-03-31"},{"$f":"'Data Sheet'!G56","v":"2012-03-31"},{"$f":"'Data Sheet'!H56","v":"2013-03-31"},{"$f":"'Data Sheet'!I56","v":"2014-03-31"},{"$f":"'Data Sheet'!J56","v":"2015-03-31"},{"$f":"'Data Sheet'!K56","v":"2016-03-31"}]
["Equity Share Capital",{"$f":"'Data Sheet'!B57","v":5.09},{"$f":"'Data Sheet'!C57","v":5.09},{"$f":"'Data Sheet'!D57","v":5.09},{"$f":"'Data Sheet'!E57","v":5.09},{"$f":"'Data Sheet'!F57","v":5.09},{"$f":"'Data Sheet'!G57","v":5.09},{"$f":"'Data Sheet'!H57","v":5.09},{"$f":"'Data Sheet'!I57","v":5.09},{"$f":"'Data Sheet'!J57","v":5.09},{"$f":"'Data Sheet'!K57","v":4.42}]
["Reserves",{"$f":"'Data Sheet'!B58","v":8.6300000000000008},{"$f":"'Data Sheet'!C58","v":9.6},{"$f":"'Data Sheet'!D58","v":11.52},{"$f":"'Data Sheet'!E58","v":13.61},{"$f":"'Data Sheet'!F58","v":15.32},{"$f":"'Data Sheet'!G58","v":17.84},{"$f":"'Data Sheet'!H58","v":21.25},{"$f":"'Data Sheet'!I58","v":23.87},{"$f":"'Data Sheet'!J58","v":28.33},{"$f":"'Data Sheet'!K58","v":35.89}]
["Borrowings",{"$f":"'Data Sheet'!B59","v":0.13},{"$f":"'Data Sheet'!C59","v":0.18},{"$f":"'Data Sheet'!D59","v":0.54},{"$f":"'Data Sheet'!E59","v":0.39},{"$f":"'Data Sheet'!F59","v":0.25},{"$f":"'Data Sheet'!G59","v":0.45},{"$f":"'Data Sheet'!H59","v":1.02},{"$f":"'Data Sheet'!I59","v":3.38},{"$f":"'Data Sheet'!J59","v":0.75},{"$f":"'Data Sheet'!K59","v":0.46}]
["Other Liabilities",{"$f":"'Data Sheet'!B60","v":3.85},{"$f":"'Data Sheet'!C60","v":3.8},{"$f":"'Data Sheet'!D60","v":3.72},{"$f":"'Data Sheet'!E60","v":3.82},{"$f":"'Data Sheet'!F60","v":3.46},{"$f":"'Data Sheet'!G60","v":4.55},{"$f":"'Data Sheet'!H60","v":3.79},{"$f":"'Data Sheet'!I60","v":3.54},{"$f":"'Data Sheet'!J60","v":4.18},{"$f":"'Data Sheet'!K60","v":5.34}]
["Total",{"$f":"'Data Sheet'!B61","v":17.7},{"$f":"'Data Sheet'!C61","v":18.670000000000002},{"$f":"'Data Sheet'!D61","v":20.87},{"$f":"'Data Sheet'!E61","v":22.91},{"$f":"'Data Sheet'!F61","v":24.12},{"$f":"'Data Sheet'!G61","v":27.93},{"$f":"'Data Sheet'!H61","v":31.15},{"$f":"'Data Sheet'!I61","v":35.880000000000003},{"$f":"'Data Sheet'!J61","v":38.35},{"$f":"'Data Sheet'!K61","v":46.11}]
[]
["Net Block",{"$f":"'Data Sheet'!B62","v":7.36},{"$f":"'Data Sheet'!C62","v":7.18},{"$f":"'Data Sheet'!D62","v":7.03},{"$f":"'Data Sheet'!E62","v":6.22},{"$f":"'Data Sheet'!F62","v":5.21},{"$f":"'Data Sheet'!G62","v":4.9800000000000004},{"$f":"'Data Sheet'!H62","v":6.66},{"$f":"'Data Sheet'!I62","v":5.65},{"$f":"'Data Sheet'!J62","v":5.72},{"$f":"'Data Sheet'!K62","v":4.97}]
["Capital Work in Progress",{"$f":"'Data Sheet'!B63","v":0.01},{"$f":"'Data Sheet'!C63","v":0},{"$f":"'Data Sheet'!D63","v":0},{"$f":"'Data Sheet'!E63","v":0},{"$f":"'Data Sheet'!F63","v":0.01},{"$f":"'Data Sheet'!G63","v":1.62},{"$f":"'Data Sheet'!H63","v":0},{"$f":"'Data Sheet'!I63","v":0},{"$f":"'Data Sheet'!J63","v":0},{"$f":"'Data Sheet'!K63","v":0}]
["Investments",{"$f":"'Data Sheet'!B64","v":0},{"$f":"'Data Sheet'!C64","v":0},{"$f":"'Data Sheet'!D64","v":0},{"$f":"'Data Sheet'!E64","v":0},{"$f":"'Data Sheet'!F64","v":0},{"$f":"'Data Sheet'!G64","v":0},{"$f":"'Data Sheet'!H64","v":1},{"$f":"'Data Sheet'!I64","v":1},{"$f":"'Data Sheet'!J64","v":1},{"$f":"'Data Sheet'!K64","v":1.42}]
["Other Assets",{"$f":"'Data Sheet'!B65","v":10.33},{"$f":"'Data Sheet'!C65","v":11.49},{"$f":"'Data Sheet'!D65","v":13.84},{"$f":"'Data Sheet'!E65","v":16.690000000000001},{"$f":"'Data Sheet'!F65","v":18.899999999999999},{"$f":"'Data Sheet'!G65","v":21.33},{"$f":"'Data Sheet'!H65","v":23.49},{"$f":"'Data Sheet'!I65","v":29.23},{"$f":"'Data Sheet'!J65","v":31.63},{"$f":"'Data Sheet'!K65","v":39.72}]
["Total",{"$f":"'Data Sheet'!B66","v":17.7},{"$f":"'Data Sheet'!C66","v":18.670000000000002},{"$f":"'Data Sheet'!D66","v":20.87},{"$f":"'Data Sheet'!E66","v":22.91},{"$f":"'Data Sheet'!F66","v":24.12},{"$f":"'Data Sheet'!G66","v":27.93},{"$f":"'Data Sheet'!H66","v":31.15},{"$f":"'Data Sheet'!I66","v":35.880000000000003},{"$f":"'Data Sheet'!J66","v":38.35},{"$f":"'Data Sheet'!K66","v":46.11}]
[]
["Working Capital",{"$f":"B13-B7","v":6.48},{"$f":"C13-C7","v":7.69},10.119999999999999,12.870000000000001,15.439999999999998,16.779999999999998,19.7,25.69,27.45,34.379999999999995]
["Debtors",{"$f":"'Data Sheet'!B67","v":2.97},{"$f":"'Data Sheet'!C67","v":2.8},{"$f":"'Data Sheet'!D67","v":1.69},{"$f":"'Data Sheet'!E67","v":4.03},{"$f":"'Data Sheet'!F67","v":3.63},{"$f":"'Data Sheet'!G67","v":5.18},{"$f":"'Data Sheet'!H67","v":3.91},{"$f":"'Data Sheet'!I67","v":7.46},{"$f":"'Data Sheet'!J67","v":4.47},{"$f":"'Data Sheet'!K67","v":3.87}]
["Inventory",{"$f":"'Data Sheet'!B68","v":2.41},{"$f":"'Data Sheet'!C68","v":2.61},{"$f":"'Data Sheet'!D68","v":3.6},{"$f":"'Data Sheet'!E68","v":2.66},{"$f":"'Data Sheet'!F68","v":3.29},{"$f":"'Data Sheet'!G68","v":2.94},{"$f":"'Data Sheet'!H68","v":4.47},{"$f":"'Data Sheet'!I68","v":5.0599999999999996},{"$f":"'Data Sheet'!J68","v":4.8499999999999996},{"$f":"'Data Sheet'!K68","v":4.5599999999999996}]
[]
["Inventory Turnover",{"$f":"IF('Balance Sheet'!B18>0,'Profit & Loss'!B4/'Balance Sheet'!B18,0)","v":14.207468879668049},{"$f":"IF('Balance Sheet'!C18>0,'Profit & Loss'!C4/'Balance Sheet'!C18,0)","v":12.82375478927203},{"$f":"IF('Balance Sheet'!D18>0,'Profit & Loss'!D4/'Balance Sheet'!D18,0)","v":9.7833333333333332},{"$f":"IF('Balance Sheet'!E18>0,'Profit & Loss'!E4/'Balance Sheet'!E18,0)","v":12.774436090225562},{"$f":"IF('Balance Sheet'!F18>0,'Profit & Loss'!F4/'Balance Sheet'!F18,0)","v":11.969604863221885},{"$f":"IF('Balance Sheet'!G18>0,'Profit & Loss'!G4/'Balance Sheet'!G18,0)","v":17.153061224489797},{"$f":"IF('Balance Sheet'!H18>0,'Profit & Loss'!H4/'Balance Sheet'!H18,0)","v":12.129753914988815},{"$f":"IF('Balance Sheet'!I18>0,'Profit & Loss'!I4/'Balance Sheet'!I18,0)","v":10.98221343873518},{"$f":"IF('Balance Sheet'!J18>0,'Profit & Loss'!J4/'Balance Sheet'!J18,0)","v":13.791752577319588},{"$f":"IF('Balance Sheet'!K18>0,'Profit & Loss'!K4/'Balance Sheet'!K18,0)","v":13.99780701754386}]
["Inventory Days",{"$f":"IF('Profit & Loss'!B4>0,'Balance Sheet'!B18/('Profit & Loss'!B4/365),0)","v":25.690712616822431},{"$f":"IF('Profit & Loss'!C4>0,'Balance Sheet'!C18/('Profit & Loss'!C4/365),0)","v":28.462802509710187},{"$f":"IF('Profit & Loss'!D4>0,'Balance Sheet'!D18/('Profit & Loss'!D4/365),0)","v":37.308347529812607},{"$f":"IF('Profit & Loss'!E4>0,'Balance Sheet'!E18/('Profit & Loss'!E4/365),0)","v":28.572689817539736},{"$f":"IF('Profit & Loss'!F4>0,'Balance Sheet'!F18/('Profit & Loss'!F4/365),0)","v":30.493905535804977},{"$f":"IF('Profit & Loss'!G4>0,'Balance Sheet'!G18/('Profit & Loss'!G4/365),0)","v":21.279000594883996},{"$f":"IF('Profit & Loss'!H4>0,'Balance Sheet'!H18/('Profit & Loss'!H4/365),0)","v":30.091294725193652},{"$f":"IF('Profit & Loss'!I4>0,'Balance Sheet'!I18/('Profit & Loss'!I4/365),0)","v":33.235558754723769},{"$f":"IF('Profit & Loss'!J4>0,'Balance Sheet'!J18/('Profit & Loss'!J4/365),0)","v":26.465091941994316},{"$f":"IF('Profit & Loss'!K4>0,'Balance Sheet'!K18/('Profit & Loss'!K4/365),0)","v":26.075513081623061}]
["Debtor Days",{"$f":"IF('Profit & Loss'!B4>0,'Balance Sheet'!B17/('Profit & Loss'!B4/365),0)","v":31.660338785046729},{"$f":"IF('Profit & Loss'!C4>0,'Balance Sheet'!C17/('Profit & Loss'!C4/365),0)","v":30.534807290110546},{"$f":"IF('Profit & Loss'!D4>0,'Balance Sheet'!D17/('Profit & Loss'!D4/365),0)","v":17.514196479273142},{"$f":"IF('Profit & Loss'!E4>0,'Balance Sheet'!E17/('Profit & Loss'!E4/365),0)","v":43.288699234844032},{"$f":"IF('Profit & Loss'!F4>0,'Balance Sheet'!F17/('Profit & Loss'!F4/365),0)","v":33.645251396648042},{"$f":"IF('Profit & Loss'!G4>0,'Balance Sheet'!G17/('Profit & Loss'!G4/365),0)","v":37.49157247670037},{"$f":"IF('Profit & Loss'!H4>0,'Balance Sheet'!H17/('Profit & Loss'!H4/365),0)","v":26.321468092954628},{"$f":"IF('Profit & Loss'!I4>0,'Balance Sheet'!I17/('Profit & Loss'!I4/365),0)","v":48.99946014036351},{"$f":"IF('Profit & Loss'!J4>0,'Balance Sheet'!J17/('Profit & Loss'!J4/365),0)","v":24.39153834653909},{"$f":"IF('Profit & Loss'!K4>0,'Balance Sheet'!K17/('Profit & Loss'!K4/365),0)","v":22.12987623374589}]
["Creditor Days"]
["Cash Conversion Cycle"]
[]
["Return on Equity",{"$f":"IF(SUM('Balance Sheet'!B4:B5)>0,'Profit & Loss'!B12/SUM('Balance Sheet'!B4:B5),\"\")","v":0.18950437317784255},{"$f":"IF(SUM('Balance Sheet'!C4:C5)>0,'Profit & Loss'!C12/SUM('Balance Sheet'!C4:C5),\"\")","v":0.1191286589516678},{"$f":"IF(SUM('Balance Sheet'!D4:D5)>0,'Profit & Loss'!D12/SUM('Balance Sheet'!D4:D5),\"\")","v":0.16195063214930766},{"$f":"IF(SUM('Balance Sheet'!E4:E5)>0,'Profit & Loss'!E12/SUM('Balance Sheet'!E4:E5),\"\")","v":0.15294117647058825},{"$f":"IF(SUM('Balance Sheet'!F4:F5)>0,'Profit & Loss'!F12/SUM('Balance Sheet'!F4:F5),\"\")","v":0.12150906418422341},{"$f":"IF(SUM('Balance Sheet'!G4:G5)>0,'Profit & Loss'!G12/SUM('Balance Sheet'!G4:G5),\"\")","v":0.15438290449193198},{"$f":"IF(SUM('Balance Sheet'!H4:H5)>0,'Profit & Loss'!H12/SUM('Balance Sheet'!H4:H5),\"\")","v":0.16894457099468491},{"$f":"IF(SUM('Balance Sheet'!I4:I5)>0,'Profit & Loss'!I12/SUM('Balance Sheet'!I4:I5),\"\")","v":0.11705801104972376},{"$f":"IF(SUM('Balance Sheet'!J4:J5)>0,'Profit & Loss'!J12/SUM('Balance Sheet'!J4:J5),\"\")","v":0.17684021543985637},{"$f":"IF(SUM('Balance Sheet'!K4:K5)>0,'Profit & Loss'!K12/SUM('Balance Sheet'!K4:K5),\"\")","v":0.21061771272637062}]
["Return on Capital Emp",{"$f":"IF(('Balance Sheet'!B10+'Balance Sheet'!B16)>0,('Profit & Loss'!B6-'Profit & Loss'!B8-'Profit & Loss'!B11)/('Balance Sheet'!B10+'Balance Sheet'!B16),\"\")","v":0.15895953757225481},{"$f":"IF(('Balance Sheet'!C10+'Balance Sheet'!C16)>0,('Profit & Loss'!C6-'Profit & Loss'!C8-'Profit & Loss'!C11)/('Balance Sheet'!C10+'Balance Sheet'!C16),\"\")","v":8.3389374579690589E-2},{"$f":"IF(('Balance Sheet'!D10+'Balance Sheet'!D16)>0,('Profit & Loss'!D6-'Profit & Loss'!D8-'Profit & Loss'!D11)/('Balance Sheet'!D10+'Balance Sheet'!D16),\"\")","v":0.11836734693877553},{"$f":"IF(('Balance Sheet'!E10+'Balance Sheet'!E16)>0,('Profit & Loss'!E6-'Profit & Loss'!E8-'Profit & Loss'!E11)/('Balance Sheet'!E10+'Balance Sheet'!E16),\"\")","v":0.10686223153483518},{"$f":"IF(('Balance Sheet'!F10+'Balance Sheet'!F16)>0,('Profit & Loss'!F6-'Profit & Loss'!F8-'Profit & Loss'!F11)/('Balance Sheet'!F10+'Balance Sheet'!F16),\"\")","v":7.3607748184019162E-2},{"$f":"IF(('Balance Sheet'!G10+'Balance Sheet'!G16)>0,('Profit & Loss'!G6-'Profit & Loss'!G8-'Profit & Loss'!G11)/('Balance Sheet'!G10+'Balance Sheet'!G16),\"\")","v":0.10753676470588223},{"$f":"IF(('Balance Sheet'!H10+'Balance Sheet'!H16)>0,('Profit & Loss'!H6-'Profit & Loss'!H8-'Profit & Loss'!H11)/('Balance Sheet'!H10+'Balance Sheet'!H16),\"\")","v":0.11001517450682839},{"$f":"IF(('Balance Sheet'!I10+'Balance Sheet'!I16)>0,('Profit & Loss'!I6-'Profit & Loss'!I8-'Profit & Loss'!I11)/('Balance Sheet'!I10+'Balance Sheet'!I16),\"\")","v":5.5201021059349265E-2},{"$f":"IF(('Balance Sheet'!J10+'Balance Sheet'!J16)>0,('Profit & Loss'!J6-'Profit & Loss'!J8-'Profit & Loss'!J11)/('Balance Sheet'!J10+'Balance Sheet'!J16),\"\")","v":9.6774193548386706E-2},{"$f":"IF(('Balance Sheet'!K10+'Balance Sheet'!K16)>0,('Profit & Loss'!K6-'Profit & Loss'!K8-'Profit & Loss'!K11)/('Balance Sheet'!K10+'Balance Sheet'!K16),\"\")","v":0.14739517153748419}]
[]
[]
[]
["Common Size Balance Sheet",{"$f":"B3","v":"2007-03-31"},{"$f":"C3","v":"2008-03-31"},"2009-03-31","2010-03-31","2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31","Check back how Assets are being put to use"]
["Net Block/Total Assets",{"$f":"B10/B$8","v":0.41581920903954805},{"$f":"C10/C$8","v":0.38457418318157466},0.33684714901772878,0.27149716281099956,0.21600331674958539,0.1783029001074114,0.21380417335473517,0.15746934225195094,0.14915254237288134,0.10778572977662113]
["Working Capital/Total Assets",{"$f":"B16/B$8","v":0.36610169491525429},{"$f":"C16/C$8","v":0.41189073379753616},0.48490656444657398,0.56176342208642516,0.64013266998341611,0.60078768349445033,0.6324237560192616,0.71599777034559642,0.71577574967405466,0.74560832791151588]
["Debtors/Total Assets",{"$f":"B17/B$8","v":0.16779661016949154},{"$f":"C17/C$8","v":0.14997321906802355},8.0977479635840913E-2,0.17590571802706242,0.15049751243781093,0.18546365914786966,0.12552166934189407,0.20791527313266442,0.11655801825293349,8.3929733246584259E-2]
["Inventory/Total Assets",{"$f":"B18/B$8","v":0.13615819209039548},{"$f":"C18/C$8","v":0.13979646491697909},0.17249640632486823,0.11610650371017024,0.13640132669983415,0.10526315789473684,0.14349919743178169,0.141025641025641,0.12646675358539763,9.8893949251789195E-2]
[]
["Borrowings/Total Assets",{"$f":"B6/B$8","v":7.3446327683615821E-3},{"$f":"C6/C$8","v":9.6411355115157988E-3},2.5874460948730235E-2,1.7023134002618946E-2,1.0364842454394693E-2,1.611170784103115E-2,3.2744783306581059E-2,9.4202898550724626E-2,1.955671447196871E-2,9.9761440034699632E-3]

{"sheet":"Cash Flow","index":3,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Balance Sheet'!A1","v":"ZENITH FIBRES LTD"},null,null,null,{"$f":"UPDATE","v":""},null,null,null,null,"SCREENER.IN"]
[]
["Narration",{"$f":"'Data Sheet'!B81","v":"2007-03-31"},{"$f":"'Data Sheet'!C81","v":"2008-03-31"},{"$f":"'Data Sheet'!D81","v":"2009-03-31"},{"$f":"'Data Sheet'!E81","v":"2010-03-31"},{"$f":"'Data Sheet'!F81","v":"2011-03-31"},{"$f":"'Data Sheet'!G81","v":"2012-03-31"},{"$f":"'Data Sheet'!H81","v":"2013-03-31"},{"$f":"'Data Sheet'!I81","v":"2014-03-31"},{"$f":"'Data Sheet'!J81","v":"2015-03-31"},{"$f":"'Data Sheet'!K81","v":"2016-03-31"}]
["Cash from Operating Activity",{"$f":"'Data Sheet'!B82","v":0.39},{"$f":"'Data Sheet'!C82","v":1.72},{"$f":"'Data Sheet'!D82","v":3.27},{"$f":"'Data Sheet'!E82","v":2.44},{"$f":"'Data Sheet'!F82","v":1.57},{"$f":"'Data Sheet'!G82","v":2.92},{"$f":"'Data Sheet'!H82","v":3.39},{"$f":"'Data Sheet'!I82","v":-0.8},{"$f":"'Data Sheet'!J82","v":7.62},{"$f":"'Data Sheet'!K82","v":8.9600000000000009}]
["Cash from Investing Activity",{"$f":"'Data Sheet'!B83","v":-0.23},{"$f":"'Data Sheet'!C83","v":-0.26},{"$f":"'Data Sheet'!D83","v":-0.42},{"$f":"'Data Sheet'!E83","v":0.59},{"$f":"'Data Sheet'!F83","v":0.61},{"$f":"'Data Sheet'!G83","v":-1.39},{"$f":"'Data Sheet'!H83","v":-0.81},{"$f":"'Data Sheet'!I83","v":1.21},{"$f":"'Data Sheet'!J83","v":0.78},{"$f":"'Data Sheet'!K83","v":1.54}]
["Cash from Financing Activity",{"$f":"'Data Sheet'!B84","v":-0.03},{"$f":"'Data Sheet'!C84","v":-0.76},{"$f":"'Data Sheet'!D84","v":-0.45},{"$f":"'Data Sheet'!E84","v":-0.93},{"$f":"'Data Sheet'!F84","v":-0.95},{"$f":"'Data Sheet'!G84","v":-0.59},{"$f":"'Data Sheet'!H84","v":-0.54},{"$f":"'Data Sheet'!I84","v":1.25},{"$f":"'Data Sheet'!J84","v":-3.49},{"$f":"'Data Sheet'!K84","v":-1.68}]
["Net Cash Flow",{"$f":"'Data Sheet'!B85","v":0.13},{"$f":"'Data Sheet'!C85","v":0.7},{"$f":"'Data Sheet'!D85","v":2.4},{"$f":"'Data Sheet'!E85","v":2.1},{"$f":"'Data Sheet'!F85","v":1.23},{"$f":"'Data Sheet'!G85","v":0.94},{"$f":"'Data Sheet'!H85","v":2.04},{"$f":"'Data Sheet'!I85","v":1.66},{"$f":"'Data Sheet'!J85","v":4.91},{"$f":"'Data Sheet'!K85","v":8.82}]

{"sheet":"Customization","index":4,"n_rows":65,"n_cols":14,"rows_kept":65,"cut":false,"hidden":false,"merged":[[50,0,50,10],[3,5,3,10],[3,12,3,13],[9,0,9,9],[33,0,33,10],[42,0,42,10]]}
[{"$f":"'Data Sheet'!B1","v":"ZENITH FIBRES LTD"}]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"DELTA NETWORTH","DELTA MKTCAP","IMPACT*",null,"HISTORICAL VALUATIONS",null,null,null,null,null,null,"PRE-TAX BOND"]
["10 YR",{"$f":"'Calculated Data'!K11-'Calculated Data'!B11","v":26.590000000000003},{"$f":"'Calculated Data'!K26-'Calculated Data'!B26","v":44.010323253999999},{"$f":"C5/B5","v":1.6551456658142156},null,null,"P/E","P/B","EV/EBITDA","P/SALES","YIELD",null,"LongTerm Bond",0.09]
["7 YR",{"$f":"'Calculated Data'!K11-'Calculated Data'!E11","v":21.610000000000003},{"$f":"'Calculated Data'!K26-'Calculated Data'!E26","v":43.757124066000003},{"$f":"C6/B6","v":2.0248553478019433},null,"MIN",{"$f":"MIN('Calculated Data'!B31:K31)","v":3.8142459631970258},{"$f":"MIN('Calculated Data'!B32:K32)","v":0.55756915614640878},{"$f":"MIN('Calculated Data'!B35:K35)","v":0.86285756712749573},{"$f":"MIN('Calculated Data'!B34:K34)","v":0.29057410044988302},{"$f":"MAX('Calculated Data'!B36:K36)","v":6.4325468839364242E-2},null,"LTB Quote",{"$f":"('Profit & Loss'!$L$10/'Data Sheet'!$B$61)/N5","v":7.6522284996861281}]
["5 YR",{"$f":"'Calculated Data'!K11-'Calculated Data'!G11","v":17.380000000000003},{"$f":"'Calculated Data'!K26-'Calculated Data'!G26","v":41.190605023999993},{"$f":"C7/B7","v":2.3700002890678933},null,"MAX",{"$f":"MAX('Calculated Data'!B31:K31)","v":7.7669672994285719},{"$f":"MAX('Calculated Data'!B32:K32)","v":1.4601092263458197},{"$f":"MAX('Calculated Data'!B35:K35)","v":2.765918073066667},{"$f":"MAX('Calculated Data'!B34:K34)","v":0.92208997201942666},{"$f":"MIN('Calculated Data'!B36:K36)","v":2.2597141107292777E-2},null,"Equity Quoting @",{"$f":"('Profit & Loss'!$L$6/'Data Sheet'!$B$6)/'Data Sheet'!$B$8","v":0.16849696771021147}]
["3 YR",{"$f":"'Calculated Data'!K11-'Calculated Data'!I11","v":11.350000000000001},{"$f":"'Calculated Data'!K26-'Calculated Data'!I26","v":42.709800152},{"$f":"C8/B8","v":3.7629779869603519},null,"TRAILING",{"$f":"'Data Sheet'!B8/'Profit & Loss'!L13","v":7.8519948519948519},{"$f":"'Calculated Data'!L26/'Calculated Data'!K11","v":1.513520218308112},{"$f":"'Calculated Data'!K35","v":2.2377826916666668},{"$f":"'Calculated Data'!L26/'Data Sheet'!K17","v":0.95582014726617581},{"$f":"'Data Sheet'!K31/'Calculated Data'!L26","v":2.1799704966398954E-2}]
["1 YR",{"$f":"'Calculated Data'!K11-'Calculated Data'!J11","v":6.8900000000000006},{"$f":"'Calculated Data'!K26-'Calculated Data'!J26","v":24.111168887999995},{"$f":"C9/B9","v":3.4994439605224952},null,null,null,null,null,null,null,null," "]
["* IMPACT – Every Rupee retained added xx.yy in incremental market value"]
[]
[{"$f":"A1","v":"ZENITH FIBRES LTD"},"SALES","GROSS PROFIT","EBIT","PAT","DIVIDEND","EPA**","MKTCAP","CFO**","FCF**","NETWORTH","TOTAL RETURNS"]
["10 YR CAGR",{"$f":"POWER('Data Sheet'!$K17/'Data Sheet'!$B17, 1/9)-1","v":7.1653940915030301E-2},{"$f":"POWER('Calculated Data'!$K4/'Calculated Data'!$B4, 1/9)-1","v":7.8392792769163E-2},{"$f":"POWER('Calculated Data'!$K5/'Calculated Data'!$B5, 1/9)-1","v":0.13766138993979071},{"$f":"POWER('Calculated Data'!$K8/'Calculated Data'!$B8, 1/9)-1","v":0.14052239084717844},{"$f":"POWER('Calculated Data'!$K9/'Calculated Data'!$B9, 1/9)-1","v":8.0965833526895237E-2},{"$f":"POWER('Calculated Data'!$K24/'Calculated Data'!$B24, 1/9)-1","v":0.16280536194513351},{"$f":"POWER('Calculated Data'!$K26/'Calculated Data'!$B26, 1/9)-1","v":0.16536830061181162},{"$f":"POWER('Calculated Data'!$K17/'Calculated Data'!$B17, 1/9)-1","v":0.41660661991457548},{"$f":"POWER('Calculated Data'!$K19/'Calculated Data'!$C19, 1/8)-1","v":0.31103808641249775},{"$f":"POWER('Calculated Data'!$K11/'Calculated Data'!$B11, 1/9)-1","v":0.12721438071023639},{"$f":"POWER('Calculated Data'!$K27/'Calculated Data'!$B27, 1/9)-1","v":0.16263302697688364}]
["5 YR CAGR",{"$f":"POWER('Data Sheet'!$K17/'Data Sheet'!$G17, 1/4)-1","v":6.0678996508217509E-2},{"$f":"POWER('Calculated Data'!$K4/'Calculated Data'!$G4, 1/4)-1","v":7.748837815302223E-2},{"$f":"POWER('Calculated Data'!$K5/'Calculated Data'!$G5, 1/4)-1","v":0.24577975072897251},{"$f":"POWER('Calculated Data'!$K8/'Calculated Data'!$G8, 1/4)-1","v":0.244446146011287},{"$f":"POWER('Calculated Data'!$K9/'Calculated Data'!$G9, 1/4)-1","v":0.10564424212274037},{"$f":"POWER('Calculated Data'!$K24/'Calculated Data'!$G24, 1/4)-1","v":0.47232224345508445},{"$f":"POWER('Calculated Data'!$K26/'Calculated Data'!$G26, 1/4)-1","v":0.35102235103083257},{"$f":"POWER('Calculated Data'!$K17/'Calculated Data'!$G17, 1/4)-1","v":0.32352238056316684},{"$f":"POWER('Calculated Data'!$K19/'Calculated Data'!$G19, 1/4)-1","v":0.96744277954352897},{"$f":"POWER('Calculated Data'!$K11/'Calculated Data'!$G11, 1/4)-1","v":0.15146882907072756},{"$f":"POWER('Calculated Data'!$K27/'Calculated Data'!$G27, 1/4)-1","v":0.34199921058523586}]
["3 YR CAGR",{"$f":"POWER('Data Sheet'!$K17/'Data Sheet'!$I17, 1/2)-1","v":7.1746869950248815E-2},{"$f":"POWER('Calculated Data'!$K4/'Calculated Data'!$I4, 1/2)-1","v":0.19530330878819213},{"$f":"POWER('Calculated Data'!$K5/'Calculated Data'!$I5, 1/2)-1","v":0.57762127549323083},{"$f":"POWER('Calculated Data'!$K8/'Calculated Data'!$I8, 1/2)-1","v":0.58253744940240271},{"$f":"POWER('Calculated Data'!$K9/'Calculated Data'!$I9, 1/2)-1","v":0.4195603245905104},{"$f":"POWER('Calculated Data'!$K24/'Calculated Data'!$I24, 1/2)-1","v":{"$error":"#NUM!"}},{"$f":"POWER('Calculated Data'!$K26/'Calculated Data'!$I26, 1/2)-1","v":0.90919558902908904},{"$f":"POWER('Calculated Data'!$K17/'Calculated Data'!$I17, 1/2)-1","v":{"$error":"#NUM!"}},{"$f":"POWER('Calculated Data'!$K19/'Calculated Data'!$I19, 1/2)-1","v":{"$error":"#NUM!"}},{"$f":"POWER('Calculated Data'!$K11/'Calculated Data'!$I11, 1/2)-1","v":0.17979654580896387},{"$f":"POWER('Calculated Data'!$K27/'Calculated Data'!$I27, 1/2)-1","v":0.89235947530814919}]
["1 YR GROWTH",{"$f":"('Data Sheet'!$K17-'Data Sheet'!$J17)/'Data Sheet'!$J17","v":-4.5746748392883875E-2},{"$f":"('Calculated Data'!$K4-'Calculated Data'!$J4)/'Calculated Data'!$J4","v":0.22771213748657371},{"$f":"('Calculated Data'!$K5-'Calculated Data'!$J5)/'Calculated Data'!$J5","v":0.47045951859956248},{"$f":"('Calculated Data'!$K8-'Calculated Data'!$J8)/'Calculated Data'!$J8","v":0.43654822335025378},{"$f":"('Calculated Data'!$K9-'Calculated Data'!$J9)/'Calculated Data'!$J9","v":0.19819819819819814},{"$f":"('Calculated Data'!$K24-'Calculated Data'!$J24)/'Calculated Data'!$J24","v":0.87788951922246017},{"$f":"('Calculated Data'!$K26-'Calculated Data'!$J26)/'Calculated Data'!$J26","v":0.69392977788237342},{"$f":"('Calculated Data'!$K17-'Calculated Data'!$J17)/'Calculated Data'!$J17","v":0.17585301837270351},{"$f":"('Calculated Data'!$K19-'Calculated Data'!$J19)/'Calculated Data'!$J19","v":0.33382789317507416},{"$f":"('Calculated Data'!$K11-'Calculated Data'!$J11)/'Calculated Data'!$J11","v":0.20616397366846201},{"$f":"('Calculated Data'!$K27-'Calculated Data'!$J27)/'Calculated Data'!$J27","v":0.67858326403331815}]
["**modify (if, then) for negative values"]
[{"$f":"A1","v":"ZENITH FIBRES LTD"},{"$f":"'Data Sheet'!B16","v":"2007-03-31"},{"$f":"'Data Sheet'!C16","v":"2008-03-31"},{"$f":"'Data Sheet'!D16","v":"2009-03-31"},{"$f":"'Data Sheet'!E16","v":"2010-03-31"},{"$f":"'Data Sheet'!F16","v":"2011-03-31"},{"$f":"'Data Sheet'!G16","v":"2012-03-31"},{"$f":"'Data Sheet'!H16","v":"2013-03-31"},{"$f":"'Data Sheet'!I16","v":"2014-03-31"},{"$f":"'Data Sheet'!J16","v":"2015-03-31"},{"$f":"'Data Sheet'!K16","v":"2016-03-31"},null,"    "]
["Total Assets/Networth= Financial Leverage",{"$f":"'Calculated Data'!B15/'Calculated Data'!B11","v":1.2900874635568511},{"$f":"'Calculated Data'!C15/'Calculated Data'!C11","v":1.2709326072157932},{"$f":"'Calculated Data'!D15/'Calculated Data'!D11","v":1.2564720048163758},{"$f":"'Calculated Data'!E15/'Calculated Data'!E11","v":1.2251336898395722},{"$f":"'Calculated Data'!F15/'Calculated Data'!F11","v":1.1817736403723664},{"$f":"'Calculated Data'!G15/'Calculated Data'!G11","v":1.2180549498473616},{"$f":"'Calculated Data'!H15/'Calculated Data'!H11","v":1.1826119969627942},{"$f":"'Calculated Data'!I15/'Calculated Data'!I11","v":1.238950276243094},{"$f":"'Calculated Data'!J15/'Calculated Data'!J11","v":1.1475164572112508},{"$f":"'Calculated Data'!K15/'Calculated Data'!K11","v":1.1438848920863309}," "]
["Long term debt/Earning",{"$f":"'Data Sheet'!B59/'Data Sheet'!B30","v":0.05},{"$f":"'Data Sheet'!C59/'Data Sheet'!C30","v":0.10285714285714286},{"$f":"'Data Sheet'!D59/'Data Sheet'!D30","v":0.20074349442379183},{"$f":"'Data Sheet'!E59/'Data Sheet'!E30","v":0.13636363636363638},{"$f":"'Data Sheet'!F59/'Data Sheet'!F30","v":0.10080645161290323},{"$f":"'Data Sheet'!G59/'Data Sheet'!G30","v":0.1271186440677966},{"$f":"'Data Sheet'!H59/'Data Sheet'!H30","v":0.2292134831460674},{"$f":"'Data Sheet'!I59/'Data Sheet'!I30","v":0.99705014749262533},{"$f":"'Data Sheet'!J59/'Data Sheet'!J30","v":0.12690355329949238},{"$f":"'Data Sheet'!K59/'Data Sheet'!K30","v":5.418138987043581E-2}]
["Current liablility/Earning",{"$f":"'Data Sheet'!B60/'Data Sheet'!B30","v":1.4807692307692308},{"$f":"'Data Sheet'!C60/'Data Sheet'!C30","v":2.1714285714285713},{"$f":"'Data Sheet'!D60/'Data Sheet'!D30","v":1.3828996282527881},{"$f":"'Data Sheet'!E60/'Data Sheet'!E30","v":1.3356643356643356},{"$f":"'Data Sheet'!F60/'Data Sheet'!F30","v":1.3951612903225807},{"$f":"'Data Sheet'!G60/'Data Sheet'!G30","v":1.2853107344632768},{"$f":"'Data Sheet'!H60/'Data Sheet'!H30","v":0.85168539325842696},{"$f":"'Data Sheet'!I60/'Data Sheet'!I30","v":1.0442477876106195},{"$f":"'Data Sheet'!J60/'Data Sheet'!J30","v":0.7072758037225042},{"$f":"'Data Sheet'!K60/'Data Sheet'!K30","v":0.62897526501766776}]
["Total liability/Earning",{"$f":"('Data Sheet'!B59+'Data Sheet'!B60)/'Data Sheet'!B30","v":1.5307692307692307},{"$f":"('Data Sheet'!C59+'Data Sheet'!C60)/'Data Sheet'!C30","v":2.2742857142857145},{"$f":"('Data Sheet'!D59+'Data Sheet'!D60)/'Data Sheet'!D30","v":1.5836431226765799},{"$f":"('Data Sheet'!E59+'Data Sheet'!E60)/'Data Sheet'!E30","v":1.4720279720279721},{"$f":"('Data Sheet'!F59+'Data Sheet'!F60)/'Data Sheet'!F30","v":1.4959677419354838},{"$f":"('Data Sheet'!G59+'Data Sheet'!G60)/'Data Sheet'!G30","v":1.4124293785310735},{"$f":"('Data Sheet'!H59+'Data Sheet'!H60)/'Data Sheet'!H30","v":1.0808988764044944},{"$f":"('Data Sheet'!I59+'Data Sheet'!I60)/'Data Sheet'!I30","v":2.0412979351032448},{"$f":"('Data Sheet'!J59+'Data Sheet'!J60)/'Data Sheet'!J30","v":0.83417935702199653},{"$f":"('Data Sheet'!K59+'Data Sheet'!K60)/'Data Sheet'!K30","v":0.68315665488810362}]
["Debt/Equity",{"$f":"'Data Sheet'!B59/'Calculated Data'!B11","v":9.4752186588921289E-3},{"$f":"'Data Sheet'!C59/'Calculated Data'!C11","v":1.2253233492171545E-2},{"$f":"'Data Sheet'!D59/'Calculated Data'!D11","v":3.2510535821794105E-2},{"$f":"'Data Sheet'!E59/'Calculated Data'!E11","v":2.0855614973262035E-2},{"$f":"'Data Sheet'!F59/'Calculated Data'!F11","v":1.2248897599216071E-2},{"$f":"'Data Sheet'!G59/'Calculated Data'!G11","v":1.9624945486262538E-2},{"$f":"'Data Sheet'!H59/'Calculated Data'!H11","v":3.8724373576309798E-2},{"$f":"'Data Sheet'!I59/'Calculated Data'!I11","v":0.11671270718232044},{"$f":"'Data Sheet'!J59/'Calculated Data'!J11","v":2.244165170556553E-2},{"$f":"'Data Sheet'!K59/'Calculated Data'!K11","v":1.1411560406846936E-2}]
["Interest Coverage",{"$f":"'Calculated Data'!B5/'Data Sheet'!B27","v":35.083333333333336},{"$f":"'Calculated Data'!C5/'Data Sheet'!C27","v":26.090909090909086},{"$f":"'Calculated Data'!D5/'Data Sheet'!D27","v":29.200000000000006},{"$f":"'Calculated Data'!E5/'Data Sheet'!E27","v":25.1875},{"$f":"'Calculated Data'!F5/'Data Sheet'!F27","v":27.499999999999996},{"$f":"'Calculated Data'!G5/'Data Sheet'!G27","v":34.875},{"$f":"'Calculated Data'!H5/'Data Sheet'!H27","v":32.049999999999997},{"$f":"'Calculated Data'!I5/'Data Sheet'!I27","v":23.478260869565219},{"$f":"'Calculated Data'!J5/'Data Sheet'!J27","v":33.851851851851848},{"$f":"'Calculated Data'!K5/'Data Sheet'!K27","v":49.777777777777771}]
["Working Capital/Sales",{"$f":"'Calculated Data'!B12/'Data Sheet'!B17","v":0.18925233644859812},{"$f":"'Calculated Data'!C12/'Data Sheet'!C17","v":0.22975799223184945},{"$f":"'Calculated Data'!D12/'Data Sheet'!D17","v":0.28733674048835889},{"$f":"'Calculated Data'!E12/'Data Sheet'!E17","v":0.37875220718069458},{"$f":"'Calculated Data'!F12/'Data Sheet'!F17","v":0.39207719654647022},{"$f":"'Calculated Data'!G12/'Data Sheet'!G17","v":0.33273844933571284},{"$f":"'Calculated Data'!H12/'Data Sheet'!H17","v":0.36333456289192179},{"$f":"'Calculated Data'!I12/'Data Sheet'!I17","v":0.46229980205146665},{"$f":"'Calculated Data'!J12/'Data Sheet'!J17","v":0.41037524293616384},{"$f":"'Calculated Data'!K12/'Data Sheet'!K17","v":0.53861820460598464},"Check for improving or deteriorating picture"]
["Inventory Turns",{"$f":"365/B27","v":14.207468879668049},12.823754789272032,9.7833333333333332,12.774436090225562,11.969604863221884,17.153061224489797,12.129753914988816,10.98221343873518,13.791752577319588,13.99780701754386]
["Inventory Days",{"$f":"'Balance Sheet'!B21","v":25.690712616822431},{"$f":"'Balance Sheet'!C21","v":28.462802509710187},{"$f":"'Balance Sheet'!D21","v":37.308347529812607},{"$f":"'Balance Sheet'!E21","v":28.572689817539736},{"$f":"'Balance Sheet'!F21","v":30.493905535804977},{"$f":"'Balance Sheet'!G21","v":21.279000594883996},{"$f":"'Balance Sheet'!H21","v":30.091294725193652},{"$f":"'Balance Sheet'!I21","v":33.235558754723769},{"$f":"'Balance Sheet'!J21","v":26.465091941994316},{"$f":"'Balance Sheet'!K21","v":26.075513081623061}]
["Debtor Days",{"$f":"'Balance Sheet'!B22","v":31.660338785046729},{"$f":"'Balance Sheet'!C22","v":30.534807290110546},{"$f":"'Balance Sheet'!D22","v":17.514196479273142},{"$f":"'Balance Sheet'!E22","v":43.288699234844032},{"$f":"'Balance Sheet'!F22","v":33.645251396648042},{"$f":"'Balance Sheet'!G22","v":37.49157247670037},{"$f":"'Balance Sheet'!H22","v":26.321468092954628},{"$f":"'Balance Sheet'!I22","v":48.99946014036351},{"$f":"'Balance Sheet'!J22","v":24.39153834653909},{"$f":"'Balance Sheet'!K22","v":22.12987623374589}]
["Creditor Days",null,null,null,null,null,null,null,null,null,null,"Check back to see if Creditor policy change is impacting Working Cap cycle"]
["Cash Conversion Cycle"]
["Cash In/Cash Out Ratio",{"$f":"('Data Sheet'!B67+'Data Sheet'!B69)/'Data Sheet'!B60","v":1.4701298701298702},{"$f":"('Data Sheet'!C67+'Data Sheet'!C69)/'Data Sheet'!C60","v":1.631578947368421},{"$f":"('Data Sheet'!D67+'Data Sheet'!D69)/'Data Sheet'!D60","v":2.010752688172043},{"$f":"('Data Sheet'!E67+'Data Sheet'!E69)/'Data Sheet'!E60","v":3.1204188481675392},{"$f":"('Data Sheet'!F67+'Data Sheet'!F69)/'Data Sheet'!F60","v":3.6849710982658959},{"$f":"('Data Sheet'!G67+'Data Sheet'!G69)/'Data Sheet'!G60","v":3.3824175824175828},{"$f":"('Data Sheet'!H67+'Data Sheet'!H69)/'Data Sheet'!H60","v":4.263852242744063},{"$f":"('Data Sheet'!I67+'Data Sheet'!I69)/'Data Sheet'!I60","v":6.036723163841808},{"$f":"('Data Sheet'!J67+'Data Sheet'!J69)/'Data Sheet'!J60","v":5.5717703349282299},{"$f":"('Data Sheet'!K67+'Data Sheet'!K69)/'Data Sheet'!K60","v":5.8988764044943824},null,"  "]
["Current Ratio",{"$f":"'Data Sheet'!B65/'Data Sheet'!B60","v":2.6831168831168832},{"$f":"'Data Sheet'!C65/'Data Sheet'!C60","v":3.0236842105263162},{"$f":"'Data Sheet'!D65/'Data Sheet'!D60","v":3.7204301075268815},{"$f":"'Data Sheet'!E65/'Data Sheet'!E60","v":4.3691099476439792},{"$f":"'Data Sheet'!F65/'Data Sheet'!F60","v":5.4624277456647397},{"$f":"'Data Sheet'!G65/'Data Sheet'!G60","v":4.6879120879120881},{"$f":"'Data Sheet'!H65/'Data Sheet'!H60","v":6.1978891820580468},{"$f":"'Data Sheet'!I65/'Data Sheet'!I60","v":8.2570621468926557},{"$f":"'Data Sheet'!J65/'Data Sheet'!J60","v":7.5669856459330145},{"$f":"'Data Sheet'!K65/'Data Sheet'!K60","v":7.4382022471910112}," "]
["CFO/PAT",{"$f":"'Calculated Data'!B17/'Calculated Data'!B8","v":0.15},{"$f":"'Calculated Data'!C17/'Calculated Data'!C8","v":0.98285714285714287},{"$f":"'Calculated Data'!D17/'Calculated Data'!D8","v":1.2156133828996283},{"$f":"'Calculated Data'!E17/'Calculated Data'!E8","v":0.85314685314685312},{"$f":"'Calculated Data'!F17/'Calculated Data'!F8","v":0.63306451612903225},{"$f":"'Calculated Data'!G17/'Calculated Data'!G8","v":0.82485875706214684},{"$f":"'Calculated Data'!H17/'Calculated Data'!H8","v":0.76179775280898876},{"$f":"'Calculated Data'!I17/'Calculated Data'!I8","v":-0.2359882005899705},{"$f":"'Calculated Data'!J17/'Calculated Data'!J8","v":1.2893401015228427},{"$f":"'Calculated Data'!K17/'Calculated Data'!K8","v":1.0553592461719672}]
[null,null,null,null,null,null,null,null,null,null,null," "]
["Gross Margin =Gross Profit/Sales",{"$f":"'Calculated Data'!B4/'Data Sheet'!B17","v":0.33849299065420568},{"$f":"'Calculated Data'!C4/'Data Sheet'!C17","v":0.33492680011950993},{"$f":"'Calculated Data'!D4/'Data Sheet'!D17","v":0.32453151618398635},{"$f":"'Calculated Data'!E4/'Data Sheet'!E17","v":0.36492054149499703},{"$f":"'Calculated Data'!F4/'Data Sheet'!F17","v":0.3042153377348909},{"$f":"'Calculated Data'!G4/'Data Sheet'!G17","v":0.3363077533214357},{"$f":"'Calculated Data'!H4/'Data Sheet'!H17","v":0.29011434894872734},{"$f":"'Calculated Data'!I4/'Data Sheet'!I17","v":0.28792513946373943},{"$f":"'Calculated Data'!J4/'Data Sheet'!J17","v":0.27836746897892056},{"$f":"'Calculated Data'!K4/'Data Sheet'!K17","v":0.35813880620397931}]
["EBIT/Sales",{"$f":"'Calculated Data'!B5/'Data Sheet'!B17","v":0.1229556074766355},{"$f":"'Calculated Data'!C5/'Data Sheet'!C17","v":8.5748431431132352E-2},{"$f":"'Calculated Data'!D5/'Data Sheet'!D17","v":0.12436115843270872},{"$f":"'Calculated Data'!E5/'Data Sheet'!E17","v":0.11859917598587406},{"$f":"'Calculated Data'!F5/'Data Sheet'!F17","v":9.7765363128491614E-2},{"$f":"'Calculated Data'!G5/'Data Sheet'!G17","v":0.11064842355740631},{"$f":"'Calculated Data'!H5/'Data Sheet'!H17","v":0.1182220582810771},{"$f":"'Calculated Data'!I5/'Data Sheet'!I17","v":9.7174734569012058E-2},{"$f":"'Calculated Data'!J5/'Data Sheet'!J17","v":0.1366422484676334},{"$f":"'Calculated Data'!K5/'Data Sheet'!K17","v":0.21055929813567287}]
["EBITDA/Sales",{"$f":"'Calculated Data'!B6/'Data Sheet'!B17","v":0.14778037383177567},{"$f":"'Calculated Data'!C6/'Data Sheet'!C17","v":0.1120406334030475},{"$f":"'Calculated Data'!D6/'Data Sheet'!D17","v":0.150198750709824},{"$f":"'Calculated Data'!E6/'Data Sheet'!E17","v":0.14655679811653916},{"$f":"'Calculated Data'!F6/'Data Sheet'!F17","v":0.12188928390045707},{"$f":"'Calculated Data'!G6/'Data Sheet'!G17","v":0.12928812214951418},{"$f":"'Calculated Data'!H6/'Data Sheet'!H17","v":0.13777203983769828},{"$f":"'Calculated Data'!I6/'Data Sheet'!I17","v":0.11714954111930899},{"$f":"'Calculated Data'!J6/'Data Sheet'!J17","v":0.14875168186574972},{"$f":"'Calculated Data'!K6/'Data Sheet'!K17","v":0.22183926053579822}]
["Op Profit (Ex Other Income)/Sales",{"$f":"'Calculated Data'!B7/'Data Sheet'!B17","v":0.13259345794392521},{"$f":"'Calculated Data'!C7/'Data Sheet'!C17","v":9.3516582013743632E-2},{"$f":"'Calculated Data'!D7/'Data Sheet'!D17","v":0.12720045428733676},{"$f":"'Calculated Data'!E7/'Data Sheet'!E17","v":0.11771630370806357},{"$f":"'Calculated Data'!F7/'Data Sheet'!F17","v":9.3956323006602324E-2},{"$f":"'Calculated Data'!G7/'Data Sheet'!G17","v":0.10232004759071979},{"$f":"'Calculated Data'!H7/'Data Sheet'!H17","v":0.10549612689044634},{"$f":"'Calculated Data'!I7/'Data Sheet'!I17","v":8.2778477595825101E-2},{"$f":"'Calculated Data'!J7/'Data Sheet'!J17","v":0.10464942442816563},{"$f":"'Calculated Data'!K7/'Data Sheet'!K17","v":0.17546608177972739}]
["Net Margin =PAT/Sales",{"$f":"'Calculated Data'!B8/'Data Sheet'!B17","v":7.5934579439252331E-2},{"$f":"'Calculated Data'!C8/'Data Sheet'!C17","v":5.2285628921422168E-2},{"$f":"'Calculated Data'!D8/'Data Sheet'!D17","v":7.6377058489494609E-2},{"$f":"'Calculated Data'!E8/'Data Sheet'!E17","v":8.4167157151265451E-2},{"$f":"'Calculated Data'!F8/'Data Sheet'!F17","v":6.2976130015236151E-2},{"$f":"'Calculated Data'!G8/'Data Sheet'!G17","v":7.0196311719214755E-2},{"$f":"'Calculated Data'!H8/'Data Sheet'!H17","v":8.2073035780154929E-2},{"$f":"'Calculated Data'!I8/'Data Sheet'!I17","v":6.1004138923879792E-2},{"$f":"'Calculated Data'!J8/'Data Sheet'!J17","v":8.8354014052922716E-2},{"$f":"'Calculated Data'!K8/'Data Sheet'!K17","v":0.13300955663481123}]
["Op Cash Flow/Sales",{"$f":"'Calculated Data'!B17/'Data Sheet'!B17","v":1.139018691588785E-2},{"$f":"'Calculated Data'!C17/'Data Sheet'!C17","v":5.1389303854197793E-2},{"$f":"'Calculated Data'!D17/'Data Sheet'!D17","v":9.2844974446337311E-2},{"$f":"'Calculated Data'!E17/'Data Sheet'!E17","v":7.1806945261918775E-2},{"$f":"'Calculated Data'!F17/'Data Sheet'!F17","v":3.9867953275774505E-2},{"$f":"'Calculated Data'!G17/'Data Sheet'!G17","v":5.7902042435058497E-2},{"$f":"'Calculated Data'!H17/'Data Sheet'!H17","v":6.2523054223533756E-2},{"$f":"'Calculated Data'!I17/'Data Sheet'!I17","v":-1.4396256973186972E-2},{"$f":"'Calculated Data'!J17/'Data Sheet'!J17","v":0.11391837344894604},{"$f":"'Calculated Data'!K17/'Data Sheet'!K17","v":0.14037286542378194}]
["Free Cash Flow/Sales",{"$f":"'Calculated Data'!B19/'Data Sheet'!B17","v":0},{"$f":"'Calculated Data'!C19/'Data Sheet'!C17","v":3.0773827308037068E-2},{"$f":"'Calculated Data'!D19/'Data Sheet'!D17","v":7.1266325951164097E-2},{"$f":"'Calculated Data'!E19/'Data Sheet'!E17","v":6.7686874632136573E-2},{"$f":"'Calculated Data'!F19/'Data Sheet'!F17","v":4.1137633316404264E-2},{"$f":"'Calculated Data'!G19/'Data Sheet'!G17","v":1.1897679952409273E-2},{"$f":"'Calculated Data'!H19/'Data Sheet'!H17","v":4.1866469937292525E-2},{"$f":"'Calculated Data'!I19/'Data Sheet'!I17","v":-1.619578909483535E-2},{"$f":"'Calculated Data'!J19/'Data Sheet'!J17","v":0.10076244580654807},{"$f":"'Calculated Data'!K19/'Data Sheet'!K17","v":0.14084286385712047}]
["EPA/Sales",{"$f":"'Calculated Data'!B24/'Data Sheet'!B17","v":2.9622769234284675E-2},{"$f":"'Calculated Data'!C24/'Data Sheet'!C17","v":1.0560614523930029E-3},{"$f":"'Calculated Data'!D24/'Data Sheet'!D17","v":2.0652756130664005E-2},{"$f":"'Calculated Data'!E24/'Data Sheet'!E17","v":2.023080912468652E-2},{"$f":"'Calculated Data'!F24/'Data Sheet'!F17","v":2.3967726170740881E-3},{"$f":"'Calculated Data'!G24/'Data Sheet'!G17","v":1.6634976105858627E-2},{"$f":"'Calculated Data'!H24/'Data Sheet'!H17","v":2.618582016012775E-2},{"$f":"'Calculated Data'!I24/'Data Sheet'!I17","v":-3.7707890339227479E-3},{"$f":"'Calculated Data'!J24/'Data Sheet'!J17","v":3.1382779750968405E-2},{"$f":"'Calculated Data'!K24/'Data Sheet'!K17","v":6.1758650629858573E-2}]
[]
["Sales/Invested Capital =Capital Turns",{"$f":"'Data Sheet'!B17/'Calculated Data'!B13","v":2.472202166064982},{"$f":"'Data Sheet'!C17/'Calculated Data'!C13","v":2.2508406186953596},{"$f":"'Data Sheet'!D17/'Calculated Data'!D13","v":2.0536443148688046},{"$f":"'Data Sheet'!E17/'Calculated Data'!E13","v":1.7799895233106338},{"$f":"'Data Sheet'!F17/'Calculated Data'!F13","v":1.9060987415295261},{"$f":"'Data Sheet'!G17/'Calculated Data'!G13","v":2.1569717707442257},{"$f":"'Data Sheet'!H17/'Calculated Data'!H13","v":2.0569044006069803},{"$f":"'Data Sheet'!I17/'Calculated Data'!I13","v":1.7731333758774728},{"$f":"'Data Sheet'!J17/'Calculated Data'!J13","v":2.016581248115767},{"$f":"'Data Sheet'!K17/'Calculated Data'!K13","v":1.6221092757306228}]
["Sales/Fixed Assets= Fixed Asset Turns",{"$f":"'Data Sheet'!B17/'Data Sheet'!B62","v":4.6521739130434785},{"$f":"'Data Sheet'!C17/'Data Sheet'!C62","v":4.6615598885793874},{"$f":"'Data Sheet'!D17/'Data Sheet'!D62","v":5.0099573257467993},{"$f":"'Data Sheet'!E17/'Data Sheet'!E62","v":5.463022508038585},{"$f":"'Data Sheet'!F17/'Data Sheet'!F62","v":7.5585412667946263},{"$f":"'Data Sheet'!G17/'Data Sheet'!G62","v":10.126506024096384},{"$f":"'Data Sheet'!H17/'Data Sheet'!H62","v":8.1411411411411407},{"$f":"'Data Sheet'!I17/'Data Sheet'!I62","v":9.8353982300884955},{"$f":"'Data Sheet'!J17/'Data Sheet'!J62","v":11.694055944055945},{"$f":"'Data Sheet'!K17/'Data Sheet'!K62","v":12.843058350100604}]
["Sales/Total Assets= Asset Turns",{"$f":"'Data Sheet'!B17/'Calculated Data'!B15","v":1.9344632768361585},{"$f":"'Data Sheet'!C17/'Calculated Data'!C15","v":1.79271558650241},{"$f":"'Data Sheet'!D17/'Calculated Data'!D15","v":1.687589841878294},{"$f":"'Data Sheet'!E17/'Calculated Data'!E15","v":1.4831951113051067},{"$f":"'Data Sheet'!F17/'Calculated Data'!F15","v":1.6326699834162521},{"$f":"'Data Sheet'!G17/'Calculated Data'!G15","v":1.8055853920515574},{"$f":"'Data Sheet'!H17/'Calculated Data'!H15","v":1.7406099518459071},{"$f":"'Data Sheet'!I17/'Calculated Data'!I15","v":1.5487736900780378},{"$f":"'Data Sheet'!J17/'Calculated Data'!J15","v":1.7441981747066493},{"$f":"'Data Sheet'!K17/'Calculated Data'!K15","v":1.3842984168293211}]
["Net Margin*Asset Turns= RoA",{"$f":"B39*B46","v":0.14689265536723164},{"$f":"C39*C46","v":9.3733261917514715E-2},0.12889314805941543,0.12483631601920557,0.10281923714759535,0.12674543501611171,0.14285714285714288,9.4481605351170561E-2,0.15410691003911345,0.18412491867273911,"Check back what is really driving RoA (Net Margins or Asset Turns, or both)"]
["Net Margin*Asset Turn*Fin Leverage= RoE",{"$f":"B39*B46*B19","v":0.18950437317784255},0.1191286589516678,0.16195063214930766,0.15294117647058822,0.1215090641842234,0.15438290449193198,0.16894457099468491,0.11705801104972376,0.1768402154398564,0.21061771272637064,"Check back what is really driving RoE (Net Margins, Asset Turns, or Financial Leverage)"]
["RoCE",{"$f":"'Calculated Data'!B5/'Calculated Data'!B14","v":0.303971119133574},{"$f":"'Calculated Data'!C5/'Calculated Data'!C14","v":0.19300605245460659},{"$f":"'Calculated Data'!D5/'Calculated Data'!D14","v":0.25539358600583095},{"$f":"'Calculated Data'!E5/'Calculated Data'!E14","v":0.21110529072812992},{"$f":"'Calculated Data'!F5/'Calculated Data'!F14","v":0.18635043562439496},{"$f":"'Calculated Data'!G5/'Calculated Data'!G14","v":0.23866552609067582},{"$f":"'Calculated Data'!H5/'Calculated Data'!H14","v":0.23428362573099415},{"$f":"'Calculated Data'!I5/'Calculated Data'!I14","v":0.16697588126159554},{"$f":"'Calculated Data'!J5/'Calculated Data'!J14","v":0.26748609891717878},{"$f":"'Calculated Data'!K5/'Calculated Data'!K14","v":0.32965415746872695}]
["EBIT Margin*Cap Turns*(1-Tax rate)= RoIC",{"$f":"B36*B44*(1-'Calculated Data'!B20)","v":0.19323347426584167},{"$f":"C36*C44*(1-'Calculated Data'!C20)","v":0.12237702601288458},{"$f":"D36*D44*(1-'Calculated Data'!D20)","v":0.16241341521410999},{"$f":"E36*E44*(1-'Calculated Data'!E20)","v":0.1560106282900392},{"$f":"F36*F44*(1-'Calculated Data'!F20)","v":0.12456848526913734},{"$f":"G36*G44*(1-'Calculated Data'!G20)","v":0.15588117386734177},{"$f":"H36*H44*(1-'Calculated Data'!H20)","v":0.17386172872086975},{"$f":"I36*I44*(1-'Calculated Data'!I20)","v":0.1133138881105588},{"$f":"J36*J44*(1-'Calculated Data'!J20)","v":0.18328592515955003},{"$f":"K36*K44*(1-'Calculated Data'!K20)","v":0.22017928004330045},"Check back what is really driving RoIC (Op Margins or Capital Turns, or both)"]
[]
["Altman Z-Score",{"$f":"'Calculated Data'!B43","v":3.8154241692655373},{"$f":"'Calculated Data'!C43","v":3.3120683269630415},{"$f":"'Calculated Data'!D43","v":3.3932052220699567},{"$f":"'Calculated Data'!E43","v":3.2676965215539067},{"$f":"'Calculated Data'!F43","v":3.4096867166666662},{"$f":"'Calculated Data'!G43","v":3.6981682325098459},{"$f":"'Calculated Data'!H43","v":3.6981637395826645},{"$f":"'Calculated Data'!I43","v":3.2811683850947597},{"$f":"'Calculated Data'!J43","v":4.1084615492985659},{"$f":"'Calculated Data'!K43","v":4.224163993675992}]
["Dividend Payout",{"$f":"'Data Sheet'!B31/'Data Sheet'!B30","v":0.25384615384615383},{"$f":"'Data Sheet'!C31/'Data Sheet'!C30","v":0.3828571428571429},{"$f":"'Data Sheet'!D31/'Data Sheet'!D30","v":0.24535315985130113},{"$f":"'Data Sheet'!E31/'Data Sheet'!E30","v":0.23076923076923078},{"$f":"'Data Sheet'!F31/'Data Sheet'!F30","v":0.26612903225806456},{"$f":"'Data Sheet'!G31/'Data Sheet'!G30","v":0.25141242937853109},{"$f":"'Data Sheet'!H31/'Data Sheet'!H30","v":0.19775280898876405},{"$f":"'Data Sheet'!I31/'Data Sheet'!I30","v":0.19469026548672566},{"$f":"'Data Sheet'!J31/'Data Sheet'!J30","v":0.18781725888324874},{"$f":"'Data Sheet'!K31/'Data Sheet'!K30","v":0.15665488810365136}]
["Cash/Assets",{"$f":"'Data Sheet'!B69/'Data Sheet'!B61","v":0.15197740112994351},{"$f":"'Data Sheet'!C69/'Data Sheet'!C61","v":0.18211033743974289},{"$f":"'Data Sheet'!D69/'Data Sheet'!D61","v":0.2774317201724964},{"$f":"'Data Sheet'!E69/'Data Sheet'!E61","v":0.34439109559144476},{"$f":"'Data Sheet'!F69/'Data Sheet'!F61","v":0.37810945273631835},{"$f":"'Data Sheet'!G69/'Data Sheet'!G61","v":0.36555674901539564},{"$f":"'Data Sheet'!H69/'Data Sheet'!H61","v":0.39325842696629215},{"$f":"'Data Sheet'!I69/'Data Sheet'!I61","v":0.38768115942028986},{"$f":"'Data Sheet'!J69/'Data Sheet'!J61","v":0.49074315514993477},{"$f":"'Data Sheet'!K69/'Data Sheet'!K61","v":0.59921925829538059}]
["EBIT/Invested Capital",{"$f":"'Calculated Data'!B5/'Calculated Data'!B13","v":0.303971119133574},{"$f":"'Calculated Data'!C5/'Calculated Data'!C13","v":0.19300605245460656},{"$f":"'Calculated Data'!D5/'Calculated Data'!D13","v":0.25539358600583095},{"$f":"'Calculated Data'!E5/'Calculated Data'!E13","v":0.21110529072812992},{"$f":"'Calculated Data'!F5/'Calculated Data'!F13","v":0.18635043562439499},{"$f":"'Calculated Data'!G5/'Calculated Data'!G13","v":0.23866552609067582},{"$f":"'Calculated Data'!H5/'Calculated Data'!H13","v":0.24317147192716237},{"$f":"'Calculated Data'!I5/'Calculated Data'!I13","v":0.17230376515634971},{"$f":"'Calculated Data'!J5/'Calculated Data'!J13","v":0.27555019596020497},{"$f":"'Calculated Data'!K5/'Calculated Data'!K13","v":0.34155019059720459},"Check back the significant role of EBIT/Invested Capital "]
["EPA",{"$f":"'Calculated Data'!B24","v":1.0142836185819073},{"$f":"'Calculated Data'!C24","v":3.5346376811593805E-2},{"$f":"'Calculated Data'!D24","v":0.72739007092198626},{"$f":"'Calculated Data'!E24","v":0.68744289405684789},{"$f":"'Calculated Data'!F24","v":9.4384905660377605E-2},{"$f":"'Calculated Data'!G24","v":0.83890184501845055},{"$f":"'Calculated Data'!H24","v":1.4197951690821267},{"$f":"'Calculated Data'!I24","v":-0.20954274661508709},{"$f":"'Calculated Data'!J24","v":2.0991941375422765},{"$f":"'Calculated Data'!K24","v":3.9420546697038725},"Check back what is really driving EPA (Invested Capital or RoIC, or both)"]
["MktCap",{"$f":"'Calculated Data'!B26","v":14.846679660000001},{"$f":"'Calculated Data'!C26","v":13.592192774000001},{"$f":"'Calculated Data'!D26","v":10.260321640999999},{"$f":"'Calculated Data'!E26","v":15.099878847999999},{"$f":"'Calculated Data'!F26","v":15.134406010000001},{"$f":"'Calculated Data'!G26","v":17.666397890000002},{"$f":"'Calculated Data'!H26","v":18.644667479999999},{"$f":"'Calculated Data'!I26","v":16.147202761999999},{"$f":"'Calculated Data'!J26","v":34.745834026000004},{"$f":"'Calculated Data'!K26","v":58.857002913999999}]
["MktCap Change",null,{"$f":"C57-B57","v":-1.2544868860000005},{"$f":"D57-C57","v":-3.3318711330000017},4.8395572070000004,3.452716200000161E-2,2.5319918800000014,0.97826958999999647,-2.4974647179999998,18.598631264000005,24.111168887999995]
["MktCap Change - EPA",null,{"$f":"C58-C56","v":-1.2898332628115943},-4.059261203921988,4.1521143129431524,-5.9857743660375995E-2,1.6930900349815508,-0.44152557908213019,-2.2879219713849128,16.499437126457728,20.169114218296123]
[]
["Capex/Net Profits 10 yr",{"$f":"SUM('Calculated Data'!B$18:K$18)/SUM('Calculated Data'!B$8:K$8)","v":0.15539832285115301}]
["Capex/Net Profits 7 yr",{"$f":"SUM('Calculated Data'!E$18:K$18)/SUM('Calculated Data'!E$8:K$8)","v":0.14395886889460155}]
["Capex/Net Profits 5 yr",{"$f":"SUM('Calculated Data'!G$18:K$18)/SUM('Calculated Data'!G$8:K$8)","v":0.17028704422032581}]
["Capex/Net Profits 3 yr",{"$f":"SUM('Calculated Data'!I$18:K$18)/SUM('Calculated Data'!I$8:K$8)","v":5.3400786958965697E-2}]
["Capex/Depreciation 10 yr",{"$f":"SUM('Calculated Data'!B$18:K$18)/SUM('Data Sheet'!B26:K26)","v":0.64596949891067512}]

{"sheet":"Data Sheet","index":5,"n_rows":93,"n_cols":11,"rows_kept":93,"cut":false,"hidden":false,"merged":[[0,4,0,10],[1,4,1,10]]}
["COMPANY NAME","ZENITH FIBRES LTD",null,null,{"$f":"IF(B2<>B3, \"A NEW VERSION OF THE WORKSHEET IS AVAILABLE\", \"\")","v":""}]
["LATEST VERSION",2.1,null,null,"PLEASE DO NOT MAKE ANY CHANGES TO THIS SHEET"]
["CURRENT VERSION",2.1]
[]
["META"]
["Number of shares",{"$f":"IF(B9>0, B9/B8, 0)","v":0.44226168901776008}]
["Face Value",10]
["Current Price",137.94999999999999]
["Market Capitalization",61.01]
[]
[]
[]
[]
[]
["PROFIT & LOSS"]
["Report Date","2007-03-31","2008-03-31","2009-03-31","2010-03-31","2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31"]
["Sales",34.24,33.47,35.22,33.979999999999997,39.380000000000003,50.43,54.22,55.57,66.89,63.83]
["Raw Material Cost",22.65,22.26,23.79,21.58,27.4,33.47,38.49,39.57,48.27,40.97]
["Change in Inventory",0.39,-0.25,0.85,-0.54,0.26,-0.53,1.17,-0.4,1.3,2.08]
["Power and Fuel",1.47,1.47,1.74,1.63,1.79,2.06,2.5,2.4700000000000002,3.14,3.18]
["Other Mfr. Exp",2.7,2.9,2.66,2.72,2.82,4.63,1.27,3.55,4.03,4.34]
["Employee Cost",1.32,1.5,1.52,1.59,1.78,1.9,2.2599999999999998,2.46,2.92,3.17]
["Selling and admin",1.22,1.28,1.21,1.1499999999999999,1.27,1.5,4.1900000000000004,1.5,1.7,1.75]
["Other Expenses",0.73,0.68,0.67,0.77,0.88,1.18,0.95,1.01,1.1399999999999999,1.3]
["Other Income",0.52,0.62,0.81,0.98,1.1000000000000001,1.36,1.75,1.91,2.95,2.96]
["Depreciation",0.85,0.88,0.91,0.95,0.95,0.94,1.06,1.1100000000000001,0.81,0.72]
["Interest",0.12,0.11,0.15,0.16,0.14000000000000001,0.16,0.2,0.23,0.27,0.27]
["Profit before tax",4.09,2.76,4.2300000000000004,3.87,3.71,5.42,6.21,5.17,8.8699999999999992,13.17]
["Tax",1.49,1.01,1.54,1.01,1.23,1.88,1.77,1.77,2.97,4.68]
["Net profit",2.6,1.75,2.69,2.86,2.48,3.54,4.45,3.39,5.91,8.49]
["Dividend Amount",0.66,0.67,0.66,0.66,0.66,0.89,0.88,0.66,1.1100000000000001,1.33]
[]
[]
[]
[]
[]
[]
[]
[]
["Quarters"]
["Report Date","2014-06-30","2014-09-30","2014-12-31","2015-03-31","2015-06-30","2015-09-30","2015-12-31","2016-03-31","2016-06-30","2016-09-30"]
["Sales",16.18,17.260000000000002,16.87,16.59,14.53,18.45,12.92,17.93,16.23,10.61]
["Expenses",14.76,15.85,14.82,14.47,12.77,14.95,10.31,14.61,13.11,9.3800000000000008]
["Other Income",1.1399999999999999,0.6,0.6,0.62,0.57999999999999996,0.91,0.71,0.77,0.77,0.65]
["Depreciation",0.35,0.13,0.14000000000000001,0.2,0.18,0.18,0.18,0.18,0.16,0.16]
["Interest",7.0000000000000007E-2,0.04,7.0000000000000007E-2,0.08,0.05,0.06,0.06,0.09,7.0000000000000007E-2,0.1]
["Profit before tax",2.15,1.83,2.4300000000000002,2.4500000000000002,2.11,4.16,3.08,3.82,3.66,1.63]
["Tax",0.7,0.65,0.79,0.78,0.73,1.4,1.2,1.35,1.32,0.55000000000000004]
["Net profit",1.46,1.18,1.64,1.68,1.38,2.76,1.88,2.4700000000000002,2.34,1.08]
["Operating Profit",1.42,1.41,2.0499999999999998,2.12,1.76,3.5,2.61,3.32,3.12,1.23]
[]
[]
[]
[]
["BALANCE SHEET"]
["Report Date","2007-03-31","2008-03-31","2009-03-31","2010-03-31","2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31"]
["Equity Share Capital",5.09,5.09,5.09,5.09,5.09,5.09,5.09,5.09,5.09,4.42]
["Reserves",8.6300000000000008,9.6,11.52,13.61,15.32,17.84,21.25,23.87,28.33,35.89]
["Borrowings",0.13,0.18,0.54,0.39,0.25,0.45,1.02,3.38,0.75,0.46]
["Other Liabilities",3.85,3.8,3.72,3.82,3.46,4.55,3.79,3.54,4.18,5.34]
["Total",17.7,18.670000000000002,20.87,22.91,24.12,27.93,31.15,35.880000000000003,38.35,46.11]
["Net Block",7.36,7.18,7.03,6.22,5.21,4.9800000000000004,6.66,5.65,5.72,4.97]
["Capital Work in Progress",0.01,null,null,null,0.01,1.62]
["Investments",null,null,null,null,null,null,1,1,1,1.42]
["Other Assets",10.33,11.49,13.84,16.690000000000001,18.899999999999999,21.33,23.49,29.23,31.63,39.72]
["Total",17.7,18.670000000000002,20.87,22.91,24.12,27.93,31.15,35.880000000000003,38.35,46.11]
["Receivables",2.97,2.8,1.69,4.03,3.63,5.18,3.91,7.46,4.47,3.87]
["Inventory",2.41,2.61,3.6,2.66,3.29,2.94,4.47,5.0599999999999996,4.8499999999999996,4.5599999999999996]
["Cash & Bank",2.69,3.4,5.79,7.89,9.1199999999999992,10.210000000000001,12.25,13.91,18.82,27.63]
["No. of Equity Shares",5754527,5754527,5754527,5754527,5754527,5754527,5754527,5754527,5754527,4422346]
["New Bonus Shares"]
["Face value",10,10,10,10,10,10,10,10,10,10]
[]
[]
[]
[]
[]
[]
[]
["CASH FLOW:"]
["Report Date","2007-03-31","2008-03-31","2009-03-31","2010-03-31","2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31"]
["Cash from Operating Activity",0.39,1.72,3.27,2.44,1.57,2.92,3.39,-0.8,7.62,8.9600000000000009]
["Cash from Investing Activity",-0.23,-0.26,-0.42,0.59,0.61,-1.39,-0.81,1.21,0.78,1.54]
["Cash from Financing Activity",-0.03,-0.76,-0.45,-0.93,-0.95,-0.59,-0.54,1.25,-3.49,-1.68]
["Net Cash Flow",0.13,0.7,2.4,2.1,1.23,0.94,2.04,1.66,4.91,8.82]
[]
[]
[]
[]
["PRICE:",25.8,23.62,17.829999999999998,26.24,26.3,30.7,32.4,28.06,60.38,133.09]
[]
["DERIVED:"]
["Adjusted Equity Shares in Cr",{"$f":"IF($B7>0,(B70*B72/$B7)+SUM(C71:$K71),0)/10000000","v":0.57545270000000004},{"$f":"IF($B7>0,(C70*C72/$B7)+SUM(D71:$K71),0)/10000000","v":0.57545270000000004},{"$f":"IF($B7>0,(D70*D72/$B7)+SUM(E71:$K71),0)/10000000","v":0.57545270000000004},{"$f":"IF($B7>0,(E70*E72/$B7)+SUM(F71:$K71),0)/10000000","v":0.57545270000000004},{"$f":"IF($B7>0,(F70*F72/$B7)+SUM(G71:$K71),0)/10000000","v":0.57545270000000004},{"$f":"IF($B7>0,(G70*G72/$B7)+SUM(H71:$K71),0)/10000000","v":0.57545270000000004},{"$f":"IF($B7>0,(H70*H72/$B7)+SUM(I71:$K71),0)/10000000","v":0.57545270000000004},{"$f":"IF($B7>0,(I70*I72/$B7)+SUM(J71:$K71),0)/10000000","v":0.57545270000000004},{"$f":"IF($B7>0,(J70*J72/$B7)+SUM(K71:$K71),0)/10000000","v":0.57545270000000004},{"$f":"IF($B7>0,(K70*K72/$B7),0)/10000000","v":0.44223459999999998}]

{"sheet":"Calculated Data","index":6,"n_rows":46,"n_cols":13,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Data Sheet'!B1","v":"ZENITH FIBRES LTD"}]
[]
[{"$f":"A1","v":"ZENITH FIBRES LTD"},{"$f":"'Data Sheet'!B16","v":"2007-03-31"},{"$f":"'Data Sheet'!C16","v":"2008-03-31"},{"$f":"'Data Sheet'!D16","v":"2009-03-31"},{"$f":"'Data Sheet'!E16","v":"2010-03-31"},{"$f":"'Data Sheet'!F16","v":"2011-03-31"},{"$f":"'Data Sheet'!G16","v":"2012-03-31"},{"$f":"'Data Sheet'!H16","v":"2013-03-31"},{"$f":"'Data Sheet'!I16","v":"2014-03-31"},{"$f":"'Data Sheet'!J16","v":"2015-03-31"},{"$f":"'Data Sheet'!K16","v":"2016-03-31"}]
["Gross Profit",{"$f":"'Data Sheet'!B17-'Data Sheet'!B18","v":11.590000000000003},{"$f":"'Data Sheet'!C17-'Data Sheet'!C18","v":11.209999999999997},{"$f":"'Data Sheet'!D17-'Data Sheet'!D18","v":11.43},{"$f":"'Data Sheet'!E17-'Data Sheet'!E18","v":12.399999999999999},{"$f":"'Data Sheet'!F17-'Data Sheet'!F18","v":11.980000000000004},{"$f":"'Data Sheet'!G17-'Data Sheet'!G18","v":16.96},{"$f":"'Data Sheet'!H17-'Data Sheet'!H18","v":15.729999999999997},{"$f":"'Data Sheet'!I17-'Data Sheet'!I18","v":16},{"$f":"'Data Sheet'!J17-'Data Sheet'!J18","v":18.619999999999997},{"$f":"'Data Sheet'!K17-'Data Sheet'!K18","v":22.86}]
["EBIT",{"$f":"'Data Sheet'!B28+'Data Sheet'!B27","v":4.21},{"$f":"'Data Sheet'!C28+'Data Sheet'!C27","v":2.8699999999999997},{"$f":"'Data Sheet'!D28+'Data Sheet'!D27","v":4.3800000000000008},{"$f":"'Data Sheet'!E28+'Data Sheet'!E27","v":4.03},{"$f":"'Data Sheet'!F28+'Data Sheet'!F27","v":3.85},{"$f":"'Data Sheet'!G28+'Data Sheet'!G27","v":5.58},{"$f":"'Data Sheet'!H28+'Data Sheet'!H27","v":6.41},{"$f":"'Data Sheet'!I28+'Data Sheet'!I27","v":5.4},{"$f":"'Data Sheet'!J28+'Data Sheet'!J27","v":9.1399999999999988},{"$f":"'Data Sheet'!K28+'Data Sheet'!K27","v":13.44}]
["EBITDA",{"$f":"'Calculated Data'!B5+'Data Sheet'!B26","v":5.0599999999999996},{"$f":"'Calculated Data'!C5+'Data Sheet'!C26","v":3.7499999999999996},{"$f":"'Calculated Data'!D5+'Data Sheet'!D26","v":5.2900000000000009},{"$f":"'Calculated Data'!E5+'Data Sheet'!E26","v":4.9800000000000004},{"$f":"'Calculated Data'!F5+'Data Sheet'!F26","v":4.8},{"$f":"'Calculated Data'!G5+'Data Sheet'!G26","v":6.52},{"$f":"'Calculated Data'!H5+'Data Sheet'!H26","v":7.4700000000000006},{"$f":"'Calculated Data'!I5+'Data Sheet'!I26","v":6.5100000000000007},{"$f":"'Calculated Data'!J5+'Data Sheet'!J26","v":9.9499999999999993},{"$f":"'Calculated Data'!K5+'Data Sheet'!K26","v":14.16}]
["Operating Profit (excl Other Income)",{"$f":"B6-'Data Sheet'!B25","v":4.5399999999999991},{"$f":"C6-'Data Sheet'!C25","v":3.1299999999999994},{"$f":"D6-'Data Sheet'!D25","v":4.4800000000000004},{"$f":"E6-'Data Sheet'!E25","v":4},{"$f":"F6-'Data Sheet'!F25","v":3.6999999999999997},{"$f":"G6-'Data Sheet'!G25","v":5.1599999999999993},{"$f":"H6-'Data Sheet'!H25","v":5.7200000000000006},{"$f":"I6-'Data Sheet'!I25","v":4.6000000000000005},{"$f":"J6-'Data Sheet'!J25","v":6.9999999999999991},{"$f":"K6-'Data Sheet'!K25","v":11.2}]
["PAT",{"$f":"'Data Sheet'!B30","v":2.6},{"$f":"'Data Sheet'!C30","v":1.75},{"$f":"'Data Sheet'!D30","v":2.69},{"$f":"'Data Sheet'!E30","v":2.86},{"$f":"'Data Sheet'!F30","v":2.48},{"$f":"'Data Sheet'!G30","v":3.54},{"$f":"'Data Sheet'!H30","v":4.45},{"$f":"'Data Sheet'!I30","v":3.39},{"$f":"'Data Sheet'!J30","v":5.91},{"$f":"'Data Sheet'!K30","v":8.49}]
["Dividend",{"$f":"'Data Sheet'!B31","v":0.66},{"$f":"'Data Sheet'!C31","v":0.67},{"$f":"'Data Sheet'!D31","v":0.66},{"$f":"'Data Sheet'!E31","v":0.66},{"$f":"'Data Sheet'!F31","v":0.66},{"$f":"'Data Sheet'!G31","v":0.89},{"$f":"'Data Sheet'!H31","v":0.88},{"$f":"'Data Sheet'!I31","v":0.66},{"$f":"'Data Sheet'!J31","v":1.1100000000000001},{"$f":"'Data Sheet'!K31","v":1.33}]
[null,{"$f":"B3","v":"2007-03-31"},{"$f":"C3","v":"2008-03-31"},"2009-03-31","2010-03-31","2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31"]
["Networth",{"$f":"'Data Sheet'!B57+'Data Sheet'!B58","v":13.72},{"$f":"'Data Sheet'!C57+'Data Sheet'!C58","v":14.69},{"$f":"'Data Sheet'!D57+'Data Sheet'!D58","v":16.61},{"$f":"'Data Sheet'!E57+'Data Sheet'!E58","v":18.7},{"$f":"'Data Sheet'!F57+'Data Sheet'!F58","v":20.41},{"$f":"'Data Sheet'!G57+'Data Sheet'!G58","v":22.93},{"$f":"'Data Sheet'!H57+'Data Sheet'!H58","v":26.34},{"$f":"'Data Sheet'!I57+'Data Sheet'!I58","v":28.96},{"$f":"'Data Sheet'!J57+'Data Sheet'!J58","v":33.42},{"$f":"'Data Sheet'!K57+'Data Sheet'!K58","v":40.31}]
["Working Capital",{"$f":"'Data Sheet'!B65-'Data Sheet'!B60","v":6.48},{"$f":"'Data Sheet'!C65-'Data Sheet'!C60","v":7.69},{"$f":"'Data Sheet'!D65-'Data Sheet'!D60","v":10.119999999999999},{"$f":"'Data Sheet'!E65-'Data Sheet'!E60","v":12.870000000000001},{"$f":"'Data Sheet'!F65-'Data Sheet'!F60","v":15.439999999999998},{"$f":"'Data Sheet'!G65-'Data Sheet'!G60","v":16.779999999999998},{"$f":"'Data Sheet'!H65-'Data Sheet'!H60","v":19.7},{"$f":"'Data Sheet'!I65-'Data Sheet'!I60","v":25.69},{"$f":"'Data Sheet'!J65-'Data Sheet'!J60","v":27.45},{"$f":"'Data Sheet'!K65-'Data Sheet'!K60","v":34.379999999999995}]
["Invested Capital",{"$f":"'Data Sheet'!B62+'Data Sheet'!B63+'Calculated Data'!B12","v":13.850000000000001},{"$f":"'Data Sheet'!C62+'Data Sheet'!C63+'Calculated Data'!C12","v":14.870000000000001},{"$f":"'Data Sheet'!D62+'Data Sheet'!D63+'Calculated Data'!D12","v":17.149999999999999},{"$f":"'Data Sheet'!E62+'Data Sheet'!E63+'Calculated Data'!E12","v":19.09},{"$f":"'Data Sheet'!F62+'Data Sheet'!F63+'Calculated Data'!F12","v":20.659999999999997},{"$f":"'Data Sheet'!G62+'Data Sheet'!G63+'Calculated Data'!G12","v":23.38},{"$f":"'Data Sheet'!H62+'Data Sheet'!H63+'Calculated Data'!H12","v":26.36},{"$f":"'Data Sheet'!I62+'Data Sheet'!I63+'Calculated Data'!I12","v":31.340000000000003},{"$f":"'Data Sheet'!J62+'Data Sheet'!J63+'Calculated Data'!J12","v":33.17},{"$f":"'Data Sheet'!K62+'Data Sheet'!K63+'Calculated Data'!K12","v":39.349999999999994}]
["Capital Employed",{"$f":"B11+'Data Sheet'!B59","v":13.850000000000001},{"$f":"C11+'Data Sheet'!C59","v":14.87},{"$f":"D11+'Data Sheet'!D59","v":17.149999999999999},{"$f":"E11+'Data Sheet'!E59","v":19.09},{"$f":"F11+'Data Sheet'!F59","v":20.66},{"$f":"G11+'Data Sheet'!G59","v":23.38},{"$f":"H11+'Data Sheet'!H59","v":27.36},{"$f":"I11+'Data Sheet'!I59","v":32.340000000000003},{"$f":"J11+'Data Sheet'!J59","v":34.17},{"$f":"K11+'Data Sheet'!K59","v":40.770000000000003}]
["Total Assets",{"$f":"'Data Sheet'!B61","v":17.7},{"$f":"'Data Sheet'!C61","v":18.670000000000002},{"$f":"'Data Sheet'!D61","v":20.87},{"$f":"'Data Sheet'!E61","v":22.91},{"$f":"'Data Sheet'!F61","v":24.12},{"$f":"'Data Sheet'!G61","v":27.93},{"$f":"'Data Sheet'!H61","v":31.15},{"$f":"'Data Sheet'!I61","v":35.880000000000003},{"$f":"'Data Sheet'!J61","v":38.35},{"$f":"'Data Sheet'!K61","v":46.11}]
[null,{"$f":"B3","v":"2007-03-31"},{"$f":"C3","v":"2008-03-31"},"2009-03-31","2010-03-31","2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31"]
["Operating Cash Flow",{"$f":"'Data Sheet'!B82","v":0.39},{"$f":"'Data Sheet'!C82","v":1.72},{"$f":"'Data Sheet'!D82","v":3.27},{"$f":"'Data Sheet'!E82","v":2.44},{"$f":"'Data Sheet'!F82","v":1.57},{"$f":"'Data Sheet'!G82","v":2.92},{"$f":"'Data Sheet'!H82","v":3.39},{"$f":"'Data Sheet'!I82","v":-0.8},{"$f":"'Data Sheet'!J82","v":7.62},{"$f":"'Data Sheet'!K82","v":8.9600000000000009}]
["Capex",null,{"$f":"('Data Sheet'!C62-'Data Sheet'!B62)+('Data Sheet'!C63-'Data Sheet'!B63)+'Data Sheet'!C26","v":0.68999999999999939},{"$f":"('Data Sheet'!D62-'Data Sheet'!C62)+('Data Sheet'!D63-'Data Sheet'!C63)+'Data Sheet'!D26","v":0.76000000000000056},{"$f":"('Data Sheet'!E62-'Data Sheet'!D62)+('Data Sheet'!E63-'Data Sheet'!D63)+'Data Sheet'!E26","v":0.13999999999999946},{"$f":"('Data Sheet'!F62-'Data Sheet'!E62)+('Data Sheet'!F63-'Data Sheet'!E63)+'Data Sheet'!F26","v":-4.9999999999999822E-2},{"$f":"('Data Sheet'!G62-'Data Sheet'!F62)+('Data Sheet'!G63-'Data Sheet'!F63)+'Data Sheet'!G26","v":2.3200000000000003},{"$f":"('Data Sheet'!H62-'Data Sheet'!G62)+('Data Sheet'!H63-'Data Sheet'!G63)+'Data Sheet'!H26","v":1.1199999999999997},{"$f":"('Data Sheet'!I62-'Data Sheet'!H62)+('Data Sheet'!I63-'Data Sheet'!H63)+'Data Sheet'!I26","v":0.10000000000000031},{"$f":"('Data Sheet'!J62-'Data Sheet'!I62)+('Data Sheet'!J63-'Data Sheet'!I63)+'Data Sheet'!J26","v":0.87999999999999945},{"$f":"('Data Sheet'!K62-'Data Sheet'!J62)+('Data Sheet'!K63-'Data Sheet'!J63)+'Data Sheet'!K26","v":-3.0000000000000027E-2},"CHECK?","derived from BS"]
["Free Cash Flow",null,{"$f":"C17-C18","v":1.0300000000000007},{"$f":"D17-D18","v":2.5099999999999993},2.3000000000000007,1.6199999999999999,0.59999999999999964,2.2700000000000005,-0.90000000000000036,6.74,8.99]
["Tax Rate",{"$f":"'Data Sheet'!B29/'Data Sheet'!B28","v":0.36430317848410759},{"$f":"'Data Sheet'!C29/'Data Sheet'!C28","v":0.36594202898550726},{"$f":"'Data Sheet'!D29/'Data Sheet'!D28","v":0.36406619385342787},{"$f":"'Data Sheet'!E29/'Data Sheet'!E28","v":0.26098191214470284},{"$f":"'Data Sheet'!F29/'Data Sheet'!F28","v":0.33153638814016173},{"$f":"'Data Sheet'!G29/'Data Sheet'!G28","v":0.34686346863468631},{"$f":"'Data Sheet'!H29/'Data Sheet'!H28","v":0.28502415458937197},{"$f":"'Data Sheet'!I29/'Data Sheet'!I28","v":0.34235976789168282},{"$f":"'Data Sheet'!J29/'Data Sheet'!J28","v":0.33483652762119509},{"$f":"'Data Sheet'!K29/'Data Sheet'!K28","v":0.3553530751708428}]
["NOPLAT",{"$f":"B5*(1-B20)","v":2.6762836185819072},1.8197463768115938,2.7853900709219865,2.9782428940568479,2.5735849056603772,3.6445018450184503,4.5829951690821265,3.5512572533849132,6.0795941375422764,8.6640546697038729]
["RoIC",{"$f":"(B5/B13)*(1-B20)","v":0.19323347426584167},{"$f":"(C5/C13)*(1-C20)","v":0.12237702601288458},0.16241341521410999,0.15601062829003917,0.12456848526913734,0.15588117386734177,0.17386172872086975,0.1133138881105588,0.18328592515955008,0.22017928004330045]
["WACC",0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12]
["EPA (Economic Profit Added)",{"$f":"B13*(B22-B23)","v":1.0142836185819073},{"$f":"C13*(C22-C23)","v":3.5346376811593805E-2},0.72739007092198626,0.68744289405684789,9.4384905660377605E-2,0.83890184501845055,1.4197951690821267,-0.20954274661508709,2.0991941375422765,3.9420546697038725]
[null,{"$f":"B3","v":"2007-03-31"},{"$f":"C3","v":"2008-03-31"},"2009-03-31","2010-03-31","2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31","CURRENT"]
["MktCap",{"$f":"'Data Sheet'!B90*'Data Sheet'!B93","v":14.846679660000001},{"$f":"'Data Sheet'!C90*'Data Sheet'!C93","v":13.592192774000001},{"$f":"'Data Sheet'!D90*'Data Sheet'!D93","v":10.260321640999999},{"$f":"'Data Sheet'!E90*'Data Sheet'!E93","v":15.099878847999999},{"$f":"'Data Sheet'!F90*'Data Sheet'!F93","v":15.134406010000001},{"$f":"'Data Sheet'!G90*'Data Sheet'!G93","v":17.666397890000002},{"$f":"'Data Sheet'!H90*'Data Sheet'!H93","v":18.644667479999999},{"$f":"'Data Sheet'!I90*'Data Sheet'!I93","v":16.147202761999999},{"$f":"'Data Sheet'!J90*'Data Sheet'!J93","v":34.745834026000004},{"$f":"'Data Sheet'!K90*'Data Sheet'!K93","v":58.857002913999999},{"$f":"'Data Sheet'!B9","v":61.01}]
["MktCap+Dividend",{"$f":"B26+'Data Sheet'!B31","v":15.506679660000001},{"$f":"C26+'Data Sheet'!C31","v":14.262192774000001},{"$f":"D26+'Data Sheet'!D31","v":10.920321640999999},{"$f":"E26+'Data Sheet'!E31","v":15.759878848},{"$f":"F26+'Data Sheet'!F31","v":15.794406010000001},{"$f":"G26+'Data Sheet'!G31","v":18.556397890000003},{"$f":"H26+'Data Sheet'!H31","v":19.524667479999998},{"$f":"I26+'Data Sheet'!I31","v":16.807202761999999},{"$f":"J26+'Data Sheet'!J31","v":35.855834026000004},{"$f":"K26+'Data Sheet'!K31","v":60.187002913999997}]
["Retained Profit",{"$f":"'Data Sheet'!B30-'Data Sheet'!B31","v":1.94},{"$f":"'Data Sheet'!C30-'Data Sheet'!C31","v":1.08},{"$f":"'Data Sheet'!D30-'Data Sheet'!D31","v":2.0299999999999998},{"$f":"'Data Sheet'!E30-'Data Sheet'!E31","v":2.1999999999999997},{"$f":"'Data Sheet'!F30-'Data Sheet'!F31","v":1.8199999999999998},{"$f":"'Data Sheet'!G30-'Data Sheet'!G31","v":2.65},{"$f":"'Data Sheet'!H30-'Data Sheet'!H31","v":3.5700000000000003},{"$f":"'Data Sheet'!I30-'Data Sheet'!I31","v":2.73},{"$f":"'Data Sheet'!J30-'Data Sheet'!J31","v":4.8},{"$f":"'Data Sheet'!K30-'Data Sheet'!K31","v":7.16}]
["EV",{"$f":"B26+'Data Sheet'!B59-'Data Sheet'!B69","v":12.286679660000003},{"$f":"C26+'Data Sheet'!C59-'Data Sheet'!C69","v":10.372192774},{"$f":"D26+'Data Sheet'!D59-'Data Sheet'!D69","v":5.010321641},{"$f":"E26+'Data Sheet'!E59-'Data Sheet'!E69","v":7.5998788480000004},{"$f":"F26+'Data Sheet'!F59-'Data Sheet'!F69","v":6.2644060100000019},{"$f":"G26+'Data Sheet'!G59-'Data Sheet'!G69","v":7.9063978900000009},{"$f":"H26+'Data Sheet'!H59-'Data Sheet'!H69","v":7.4146674799999985},{"$f":"I26+'Data Sheet'!I59-'Data Sheet'!I69","v":5.617202761999998},{"$f":"J26+'Data Sheet'!J59-'Data Sheet'!J69","v":16.675834026000004},{"$f":"K26+'Data Sheet'!K59-'Data Sheet'!K69","v":31.687002914000001}]
[null,{"$f":"B3","v":"2007-03-31"},{"$f":"C3","v":"2008-03-31"},"2009-03-31","2010-03-31","2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31"]
["Price/Earnings",{"$f":"B26/'Data Sheet'!B30","v":5.7102614076923084},{"$f":"C26/'Data Sheet'!C30","v":7.7669672994285719},{"$f":"D26/'Data Sheet'!D30","v":3.8142459631970258},{"$f":"E26/'Data Sheet'!E30","v":5.2796779188811191},{"$f":"F26/'Data Sheet'!F30","v":6.1025830685483875},{"$f":"G26/'Data Sheet'!G30","v":4.9905078785310737},{"$f":"H26/'Data Sheet'!H30","v":4.1898129168539322},{"$f":"I26/'Data Sheet'!I30","v":4.7631866554572264},{"$f":"J26/'Data Sheet'!J30","v":5.8791597336717434},{"$f":"K26/'Data Sheet'!K30","v":6.932509177149587}]
["Price/Book",{"$f":"B26/B11","v":1.0821195087463558},0.92526839850238263,0.6177195449127032,0.80748015229946524,0.74151915776580113,0.77044910117749688,0.70784614578587701,0.55756915614640878,1.0396718739078397,1.4601092263458197]
["Price/CashFlow",{"$f":"B26/B17","v":38.068409384615386},7.9024376593023264,3.1377130400611617,6.1884749377049175,9.6397490509554142,6.0501362636986311,5.4999019115044243,-20.184003452499997,4.5598207383202105,6.5688619323660706]
["Price/Sales",{"$f":"B26/'Data Sheet'!B17","v":0.43360629848130844},{"$f":"C26/'Data Sheet'!C17","v":0.40610077006274281},{"$f":"D26/'Data Sheet'!D17","v":0.29132088702441794},{"$f":"E26/'Data Sheet'!E17","v":0.4443754811065333},{"$f":"F26/'Data Sheet'!F17","v":0.38431706475368205},{"$f":"G26/'Data Sheet'!G17","v":0.3503152466785644},{"$f":"H26/'Data Sheet'!H17","v":0.34387066543710809},{"$f":"I26/'Data Sheet'!I17","v":0.29057410044988302},{"$f":"J26/'Data Sheet'!J17","v":0.5194473617282106},{"$f":"K26/'Data Sheet'!K17","v":0.92208997201942666}]
["EV/EBITDA",{"$f":"B29/B6","v":2.428197561264823},2.765918073066667,0.94713074499054806,1.5260800899598392,1.3050845854166671,1.2126377131901842,0.99259270147255663,0.86285756712749573,1.6759632186934679,2.2377826916666668]
["Dividend Yield",{"$f":"'Data Sheet'!B31/'Calculated Data'!B26","v":4.4454384085498615E-2},{"$f":"'Data Sheet'!C31/'Calculated Data'!C26","v":4.9293003059934386E-2},{"$f":"'Data Sheet'!D31/'Calculated Data'!D26","v":6.4325468839364242E-2},{"$f":"'Data Sheet'!E31/'Calculated Data'!E26","v":4.3708959962113735E-2},{"$f":"'Data Sheet'!F31/'Calculated Data'!F26","v":4.360924370364503E-2},{"$f":"'Data Sheet'!G31/'Calculated Data'!G26","v":5.037812493195238E-2},{"$f":"'Data Sheet'!H31/'Calculated Data'!H26","v":4.719848186855409E-2},{"$f":"'Data Sheet'!I31/'Calculated Data'!I26","v":4.0873952580394314E-2},{"$f":"'Data Sheet'!J31/'Calculated Data'!J26","v":3.1946275895101461E-2},{"$f":"'Data Sheet'!K31/'Calculated Data'!K26","v":2.2597141107292777E-2}]
[null,{"$f":"B3","v":"2007-03-31"},{"$f":"C3","v":"2008-03-31"},"2009-03-31","2010-03-31","2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31","Z-Weights"]
["Working Capital/Total Assets",{"$f":"B12/B15","v":0.36610169491525429},0.41189073379753616,0.48490656444657398,0.56176342208642516,0.64013266998341611,0.60078768349445033,0.6324237560192616,0.71599777034559642,0.71577574967405466,0.74560832791151588,1.2]
["Retained Profits/Total Assets",{"$f":"B28/B15","v":0.1096045197740113},5.7846813069094803E-2,9.7268806899856244E-2,9.6027935399388906E-2,7.5456053067993356E-2,9.4880057286072322E-2,0.11460674157303372,7.6086956521739121E-2,0.12516297262059972,0.15528085014096726,1.4]
["EBIT/Total Assets",{"$f":"B5/B15","v":0.23785310734463277},0.15372254954472411,0.20987062769525638,0.17590571802706242,0.15961857379767827,0.19978517722878625,0.20577849117174962,0.15050167224080269,0.23833116036505864,0.29147690305790502,3.3]
["Market Cap/Total Liabilities",{"$f":"B26/B15","v":0.83879546101694924},{"$f":"C26/C15","v":0.72802318018211032},0.49163016966938183,0.65909554116106506,0.62746293573797685,0.63252409201575377,0.59854470240770463,0.45003352179487172,0.90601914018252938,1.2764476884406852,0.6]
["Sales/Total Assets",{"$f":"'Data Sheet'!B17/'Calculated Data'!B15","v":1.9344632768361585},{"$f":"'Data Sheet'!C17/'Calculated Data'!C15","v":1.79271558650241},{"$f":"'Data Sheet'!D17/'Calculated Data'!D15","v":1.687589841878294},{"$f":"'Data Sheet'!E17/'Calculated Data'!E15","v":1.4831951113051067},{"$f":"'Data Sheet'!F17/'Calculated Data'!F15","v":1.6326699834162521},{"$f":"'Data Sheet'!G17/'Calculated Data'!G15","v":1.8055853920515574},{"$f":"'Data Sheet'!H17/'Calculated Data'!H15","v":1.7406099518459071},{"$f":"'Data Sheet'!I17/'Calculated Data'!I15","v":1.5487736900780378},{"$f":"'Data Sheet'!J17/'Calculated Data'!J15","v":1.7441981747066493},{"$f":"'Data Sheet'!K17/'Calculated Data'!K15","v":1.3842984168293211},1]
["Altman Z-Score",{"$f":"$L$38*B38+$L$39*B39+$L$40*B40+$L$41*B41+$L$42*B42","v":3.8154241692655373},{"$f":"$L$38*C38+$L$39*C39+$L$40*C40+$L$41*C41+$L$42*C42","v":3.3120683269630415},3.3932052220699567,3.2676965215539067,3.4096867166666662,3.6981682325098459,3.6981637395826645,3.2811683850947597,4.1084615492985659,4.224163993675992]
["Z > 2.99 -“Safe” Zones"]
["1.81 < Z < 2.99 -“Grey” Zones"]
["Z < 1.81 -“Distress” Zones"]

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