{"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":"AJANTA PHARMA 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":258.01},{"$f":"'Data Sheet'!C17","v":309.37},{"$f":"'Data Sheet'!D17","v":349.34},{"$f":"'Data Sheet'!E17","v":409.14},{"$f":"'Data Sheet'!F17","v":504.87},{"$f":"'Data Sheet'!G17","v":677.4},{"$f":"'Data Sheet'!H17","v":930.84},{"$f":"'Data Sheet'!I17","v":1208.3399999999999},{"$f":"'Data Sheet'!J17","v":1473.56},{"$f":"'Data Sheet'!K17","v":1727.53},{"$f":"SUM(Quarters!H4:K4)","v":1890.23},{"$f":"$K4+M23*K4","v":2122.9631288400878},{"$f":"$K4+N23*L4","v":2053.3136213659436}]
["Expenses",{"$f":"SUM('Data Sheet'!B18,'Data Sheet'!B20:B24, -1*'Data Sheet'!B19)","v":218.33},{"$f":"SUM('Data Sheet'!C18,'Data Sheet'!C20:C24, -1*'Data Sheet'!C19)","v":258.02},{"$f":"SUM('Data Sheet'!D18,'Data Sheet'!D20:D24, -1*'Data Sheet'!D19)","v":284.28000000000003},{"$f":"SUM('Data Sheet'!E18,'Data Sheet'!E20:E24, -1*'Data Sheet'!E19)","v":330.58},{"$f":"SUM('Data Sheet'!F18,'Data Sheet'!F20:F24, -1*'Data Sheet'!F19)","v":416.17},{"$f":"SUM('Data Sheet'!G18,'Data Sheet'!G20:G24, -1*'Data Sheet'!G19)","v":545.37},{"$f":"SUM('Data Sheet'!H18,'Data Sheet'!H20:H24, -1*'Data Sheet'!H19)","v":706.35},{"$f":"SUM('Data Sheet'!I18,'Data Sheet'!I20:I24, -1*'Data Sheet'!I19)","v":839.58999999999992},{"$f":"SUM('Data Sheet'!J18,'Data Sheet'!J20:J24, -1*'Data Sheet'!J19)","v":976.79000000000008},{"$f":"SUM('Data Sheet'!K18,'Data Sheet'!K20:K24, -1*'Data Sheet'!K19)","v":1146.81},{"$f":"SUM(Quarters!H5:K5)","v":1246.3600000000001},{"$f":"M4-M6","v":1399.8171255673287},1497.0766019069015]
["Operating Profit",{"$f":"B4-B5","v":39.679999999999978},{"$f":"C4-C5","v":51.350000000000023},65.059999999999945,78.56,88.699999999999989,132.02999999999997,224.49,368.75,496.76999999999987,580.72,{"$f":"SUM(Quarters!H6:K6)","v":643.87},{"$f":"M4*M24","v":723.146003272759},{"$f":"N4*N24","v":556.23701945904202}]
["Other Income",{"$f":"'Data Sheet'!B25","v":0.82},{"$f":"'Data Sheet'!C25","v":1.54},{"$f":"'Data Sheet'!D25","v":2.5},{"$f":"'Data Sheet'!E25","v":1.08},{"$f":"'Data Sheet'!F25","v":10.46},{"$f":"'Data Sheet'!G25","v":6.22},{"$f":"'Data Sheet'!H25","v":5.6},{"$f":"'Data Sheet'!I25","v":13.71},{"$f":"'Data Sheet'!J25","v":16.8},{"$f":"'Data Sheet'!K25","v":16.63},{"$f":"SUM(Quarters!H7:K7)","v":18.7},0,0]
["Depreciation",{"$f":"'Data Sheet'!B26","v":8.74},{"$f":"'Data Sheet'!C26","v":7.87},{"$f":"'Data Sheet'!D26","v":14.2},{"$f":"'Data Sheet'!E26","v":20.73},{"$f":"'Data Sheet'!F26","v":24.75},{"$f":"'Data Sheet'!G26","v":31.87},{"$f":"'Data Sheet'!H26","v":34.17},{"$f":"'Data Sheet'!I26","v":43.88},{"$f":"'Data Sheet'!J26","v":51.64},{"$f":"'Data Sheet'!K26","v":45.06},{"$f":"SUM(Quarters!H8:K8)","v":50.77},{"$f":"+$L8","v":50.77},{"$f":"+$L8","v":50.77}]
["Interest",{"$f":"'Data Sheet'!B27","v":12.38},{"$f":"'Data Sheet'!C27","v":16.14},{"$f":"'Data Sheet'!D27","v":23.55},{"$f":"'Data Sheet'!E27","v":20.149999999999999},{"$f":"'Data Sheet'!F27","v":18.02},{"$f":"'Data Sheet'!G27","v":15.43},{"$f":"'Data Sheet'!H27","v":19.13},{"$f":"'Data Sheet'!I27","v":8.73},{"$f":"'Data Sheet'!J27","v":5.92},{"$f":"'Data Sheet'!K27","v":4.8899999999999997},{"$f":"SUM(Quarters!H9:K9)","v":4.43},{"$f":"+$L9","v":4.43},{"$f":"+$L9","v":4.43}]
["Profit before tax",{"$f":"'Data Sheet'!B28","v":19.38},{"$f":"'Data Sheet'!C28","v":28.88},{"$f":"'Data Sheet'!D28","v":29.81},{"$f":"'Data Sheet'!E28","v":38.76},{"$f":"'Data Sheet'!F28","v":56.39},{"$f":"'Data Sheet'!G28","v":90.95},{"$f":"'Data Sheet'!H28","v":176.79},{"$f":"'Data Sheet'!I28","v":329.85},{"$f":"'Data Sheet'!J28","v":456.01},{"$f":"'Data Sheet'!K28","v":547.4},{"$f":"SUM(Quarters!H10:K10)","v":607.37},{"$f":"M6+M7-SUM(M8:M9)","v":667.94600327275896},{"$f":"N6+N7-SUM(N8:N9)","v":501.03701945904203}]
["Tax",{"$f":"'Data Sheet'!B29","v":4.67},{"$f":"'Data Sheet'!C29","v":6.85},{"$f":"'Data Sheet'!D29","v":4.38},{"$f":"'Data Sheet'!E29","v":4.76},{"$f":"'Data Sheet'!F29","v":5.68},{"$f":"'Data Sheet'!G29","v":13.69},{"$f":"'Data Sheet'!H29","v":64.680000000000007},{"$f":"'Data Sheet'!I29","v":95.97},{"$f":"'Data Sheet'!J29","v":146.15},{"$f":"'Data Sheet'!K29","v":145.99},{"$f":"SUM(Quarters!H11:K11)","v":138.35},{"$f":"IF($L10>0,$L11/$L10,0)","v":0.22778536970874425},{"$f":"IF($L10>0,$L11/$L10,0)","v":0.22778536970874425}]
["Net profit",{"$f":"'Data Sheet'!B30","v":14.66},{"$f":"'Data Sheet'!C30","v":21.88},{"$f":"'Data Sheet'!D30","v":25.43},{"$f":"'Data Sheet'!E30","v":34},{"$f":"'Data Sheet'!F30","v":50.71},{"$f":"'Data Sheet'!G30","v":77.260000000000005},{"$f":"'Data Sheet'!H30","v":112.11},{"$f":"'Data Sheet'!I30","v":233.88},{"$f":"'Data Sheet'!J30","v":309.86},{"$f":"'Data Sheet'!K30","v":401.41},{"$f":"SUM(Quarters!H12:K12)","v":469.02},{"$f":"M10-M11*M10","v":515.79767597179546},{"$f":"N10-N11*N10","v":386.90811674379688}]
["EPS",{"$f":"IF('Data Sheet'!B93>0,B12/'Data Sheet'!B93,0)","v":2.064035795392948},{"$f":"IF('Data Sheet'!C93>0,C12/'Data Sheet'!C93,0)","v":3.0805663849384519},{"$f":"IF('Data Sheet'!D93>0,D12/'Data Sheet'!D93,0)","v":3.580384057083402},{"$f":"IF('Data Sheet'!E93>0,E12/'Data Sheet'!E93,0)","v":4.78698615575445},{"$f":"IF('Data Sheet'!F93>0,F12/'Data Sheet'!F93,0)","v":7.1396490575972988},{"$f":"IF('Data Sheet'!G93>0,G12/'Data Sheet'!G93,0)","v":10.877722070399672},{"$f":"IF('Data Sheet'!H93>0,H12/'Data Sheet'!H93,0)","v":15.784382880047982},{"$f":"IF('Data Sheet'!I93>0,I12/'Data Sheet'!I93,0)","v":26.427118644067797},{"$f":"IF('Data Sheet'!J93>0,J12/'Data Sheet'!J93,0)","v":34.929545710742872},{"$f":"IF('Data Sheet'!K93>0,K12/'Data Sheet'!K93,0)","v":45.220251724303026},{"$f":"IF('Data Sheet'!$B6>0,'Profit & Loss'!L12/'Data Sheet'!$B6,0)","v":53.294689461251529},{"$f":"IF('Data Sheet'!$B6>0,'Profit & Loss'!M12/'Data Sheet'!$B6,0)","v":58.610031482137387},{"$f":"IF('Data Sheet'!$B6>0,'Profit & Loss'!N12/'Data Sheet'!$B6,0)","v":43.964325469912389}]
["Price to earning",{"$f":"IF(B15>0,B15/B13,\"\")","v":4.7528245497953625},{"$f":"IF(C15>0,C15/C13,\"\")","v":3.7460643784277878},2.1757442430200551,5.4710832970588239,4.2256978958785254,6.5234246233497268,12.069524760503077,14.9883914828117,38.547881817595041,32.498934525173759,{"$f":"IF(L13>0,L15/L13,0)","v":33.666581382457039},{"$f":"M25","v":33.666581382457039},{"$f":"N25","v":14.424195723279173}]
["Price",{"$f":"'Data Sheet'!B90","v":9.81},{"$f":"'Data Sheet'!C90","v":11.54},{"$f":"'Data Sheet'!D90","v":7.79},{"$f":"'Data Sheet'!E90","v":26.19},{"$f":"'Data Sheet'!F90","v":30.17},{"$f":"'Data Sheet'!G90","v":70.959999999999994},{"$f":"'Data Sheet'!H90","v":190.51},{"$f":"'Data Sheet'!I90","v":396.1},{"$f":"'Data Sheet'!J90","v":1346.46},{"$f":"'Data Sheet'!K90","v":1469.61},{"$f":"'Data Sheet'!B8","v":1794.25},{"$f":"M13*M14","v":1973.1993947217475},{"$f":"N13*N14","v":634.15003541996384}]
[]
["RATIOS:"]
["Dividend Payout",{"$f":"IF('Data Sheet'!B30>0, 'Data Sheet'!B31/'Data Sheet'!B30, 0)","v":0.15961800818553887},{"$f":"IF('Data Sheet'!C30>0, 'Data Sheet'!C31/'Data Sheet'!C30, 0)","v":0.13391224862888484},{"$f":"IF('Data Sheet'!D30>0, 'Data Sheet'!D31/'Data Sheet'!D30, 0)","v":0.11521824616594574},{"$f":"IF('Data Sheet'!E30>0, 'Data Sheet'!E31/'Data Sheet'!E30, 0)","v":0.12029411764705882},{"$f":"IF('Data Sheet'!F30>0, 'Data Sheet'!F31/'Data Sheet'!F30, 0)","v":0.11536186156576611},{"$f":"IF('Data Sheet'!G30>0, 'Data Sheet'!G31/'Data Sheet'!G30, 0)","v":0.11364224695832253},{"$f":"IF('Data Sheet'!H30>0, 'Data Sheet'!H31/'Data Sheet'!H30, 0)","v":0.13067522968513068},{"$f":"IF('Data Sheet'!I30>0, 'Data Sheet'!I31/'Data Sheet'!I30, 0)","v":0.15041901829998289},{"$f":"IF('Data Sheet'!J30>0, 'Data Sheet'!J31/'Data Sheet'!J30, 0)","v":0.17046408055250759},{"$f":"IF('Data Sheet'!K30>0, 'Data Sheet'!K31/'Data Sheet'!K30, 0)","v":0.17538177922822051}]
["OPM",{"$f":"IF(B6>0,B6/B4,0)","v":0.15379248866323003},{"$f":"IF(C6>0,C6/C4,0)","v":0.16598248052493786},0.1862369038758801,0.1920125140538691,0.17568879117396555,0.19490699734278119,0.24116926646899575,0.30517073009252366,0.33712234316892414,0.33615624620122375,0.34063050528242594]
[]
[]
[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":0.23524851345618658},{"$f":"IF(D4=0,\"\",POWER($K4/D4,1/7)-1)","v":0.25651646306096887},{"$f":"IF(F4=0,\"\",POWER($K4/F4,1/5)-1)","v":0.27893716126818502},{"$f":"IF(H4=0,\"\",POWER($K4/H4, 1/3)-1)","v":0.22890087514548974},{"$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":0.17235131246776517},{"$f":"MAX(K23:L23)","v":0.22890087514548974},{"$f":"MIN(H23:L23)","v":0.17235131246776517}]
[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.27089725294327499},{"$f":"IF(SUM(E4:$K$4)=0,\"\",SUMPRODUCT(E19:$K$19,E4:$K$4)/SUM(E4:$K$4))","v":0.28420527202640627},{"$f":"IF(SUM(G4:$K$4)=0,\"\",SUMPRODUCT(G19:$K$19,G4:$K$4)/SUM(G4:$K$4))","v":0.29957774354525923},{"$f":"IF(SUM(I4:$K$4)=0, \"\", SUMPRODUCT(I19:$K$19,I4:$K$4)/SUM(I4:$K$4))","v":0.32798797123437723},{"$f":"L19","v":0.34063050528242594},{"$f":"MAX(K24:L24)","v":0.34063050528242594},{"$f":"MIN(H24:L24)","v":0.27089725294327499}]
[null,null,null,null,null,null,"Price to Earning",{"$f":"IF(ISERROR(AVERAGEIF(B14:$L14,\">0\")),\"\",AVERAGEIF(B14:$L14,\">0\"))","v":14.424195723279173},{"$f":"IF(ISERROR(AVERAGEIF(E14:$L14,\">0\")),\"\",AVERAGEIF(E14:$L14,\">0\"))","v":18.498939973103461},{"$f":"IF(ISERROR(AVERAGEIF(G14:$L14,\">0\")),\"\",AVERAGEIF(G14:$L14,\">0\"))","v":23.049123098648391},{"$f":"IF(ISERROR(AVERAGEIF(I14:$L14,\">0\")),\"\",AVERAGEIF(I14:$L14,\">0\"))","v":29.925447302009385},{"$f":"L14","v":33.666581382457039},{"$f":"MAX(K25:L25)","v":33.666581382457039},{"$f":"MIN(H25:L25)","v":14.424195723279173}]

{"sheet":"Quarters","index":1,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Profit & Loss'!A1","v":"AJANTA PHARMA 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":321.74},{"$f":"'Data Sheet'!C42","v":371.87},{"$f":"'Data Sheet'!D42","v":407.85},{"$f":"'Data Sheet'!E42","v":372.09},{"$f":"'Data Sheet'!F42","v":391.35},{"$f":"'Data Sheet'!G42","v":441.7},{"$f":"'Data Sheet'!H42","v":472.78},{"$f":"'Data Sheet'!I42","v":425.73},{"$f":"'Data Sheet'!J42","v":475.9},{"$f":"'Data Sheet'!K42","v":515.82000000000005}]
["Expenses",{"$f":"'Data Sheet'!B43","v":224.82},{"$f":"'Data Sheet'!C43","v":243.05},{"$f":"'Data Sheet'!D43","v":263.08999999999997},{"$f":"'Data Sheet'!E43","v":247.46},{"$f":"'Data Sheet'!F43","v":268.83},{"$f":"'Data Sheet'!G43","v":287.77999999999997},{"$f":"'Data Sheet'!H43","v":309.3},{"$f":"'Data Sheet'!I43","v":285.13},{"$f":"'Data Sheet'!J43","v":309.33},{"$f":"'Data Sheet'!K43","v":342.6}]
["Operating Profit",{"$f":"'Data Sheet'!B50","v":96.92},{"$f":"'Data Sheet'!C50","v":128.82},{"$f":"'Data Sheet'!D50","v":144.76},{"$f":"'Data Sheet'!E50","v":124.63},{"$f":"'Data Sheet'!F50","v":122.52},{"$f":"'Data Sheet'!G50","v":153.91999999999999},{"$f":"'Data Sheet'!H50","v":163.47999999999999},{"$f":"'Data Sheet'!I50","v":140.6},{"$f":"'Data Sheet'!J50","v":166.57},{"$f":"'Data Sheet'!K50","v":173.22}]
["Other Income",{"$f":"'Data Sheet'!B44","v":4.51},{"$f":"'Data Sheet'!C44","v":4.41},{"$f":"'Data Sheet'!D44","v":4.54},{"$f":"'Data Sheet'!E44","v":4.9800000000000004},{"$f":"'Data Sheet'!F44","v":7.96},{"$f":"'Data Sheet'!G44","v":6.16},{"$f":"'Data Sheet'!H44","v":1.6},{"$f":"'Data Sheet'!I44","v":4.9800000000000004},{"$f":"'Data Sheet'!J44","v":5.46},{"$f":"'Data Sheet'!K44","v":6.66}]
["Depreciation",{"$f":"'Data Sheet'!B45","v":12.55},{"$f":"'Data Sheet'!C45","v":12.72},{"$f":"'Data Sheet'!D45","v":13.14},{"$f":"'Data Sheet'!E45","v":13.23},{"$f":"'Data Sheet'!F45","v":10.31},{"$f":"'Data Sheet'!G45","v":10.97},{"$f":"'Data Sheet'!H45","v":11.73},{"$f":"'Data Sheet'!I45","v":12.05},{"$f":"'Data Sheet'!J45","v":13},{"$f":"'Data Sheet'!K45","v":13.99}]
["Interest",{"$f":"'Data Sheet'!B46","v":1.57},{"$f":"'Data Sheet'!C46","v":1.48},{"$f":"'Data Sheet'!D46","v":1.38},{"$f":"'Data Sheet'!E46","v":1.49},{"$f":"'Data Sheet'!F46","v":1.17},{"$f":"'Data Sheet'!G46","v":1.07},{"$f":"'Data Sheet'!H46","v":1.53},{"$f":"'Data Sheet'!I46","v":1.1200000000000001},{"$f":"'Data Sheet'!J46","v":1.01},{"$f":"'Data Sheet'!K46","v":0.77}]
["Profit before tax",{"$f":"'Data Sheet'!B47","v":87.31},{"$f":"'Data Sheet'!C47","v":119.03},{"$f":"'Data Sheet'!D47","v":134.78},{"$f":"'Data Sheet'!E47","v":114.89},{"$f":"'Data Sheet'!F47","v":119},{"$f":"'Data Sheet'!G47","v":148.04},{"$f":"'Data Sheet'!H47","v":151.82},{"$f":"'Data Sheet'!I47","v":132.41},{"$f":"'Data Sheet'!J47","v":158.02000000000001},{"$f":"'Data Sheet'!K47","v":165.12}]
["Tax",{"$f":"'Data Sheet'!B48","v":27.65},{"$f":"'Data Sheet'!C48","v":36.03},{"$f":"'Data Sheet'!D48","v":41.72},{"$f":"'Data Sheet'!E48","v":40.75},{"$f":"'Data Sheet'!F48","v":32.99},{"$f":"'Data Sheet'!G48","v":44.6},{"$f":"'Data Sheet'!H48","v":40.520000000000003},{"$f":"'Data Sheet'!I48","v":24.9},{"$f":"'Data Sheet'!J48","v":38.47},{"$f":"'Data Sheet'!K48","v":34.46}]
["Net profit",{"$f":"'Data Sheet'!B49","v":59.66},{"$f":"'Data Sheet'!C49","v":83},{"$f":"'Data Sheet'!D49","v":93.06},{"$f":"'Data Sheet'!E49","v":74.14},{"$f":"'Data Sheet'!F49","v":86.01},{"$f":"'Data Sheet'!G49","v":103.44},{"$f":"'Data Sheet'!H49","v":111.3},{"$f":"'Data Sheet'!I49","v":107.51},{"$f":"'Data Sheet'!J49","v":119.55},{"$f":"'Data Sheet'!K49","v":130.66}]
[]
["OPM",{"$f":"IF(B4>0,B6/B4,\"\")","v":0.3012370236837198},{"$f":"IF(C4>0,C6/C4,\"\")","v":0.34641138032107993},0.35493441216133376,0.3349458464350023,0.31307014181678799,0.34847181344804162,0.34578450865095817,0.33025626570831274,0.35001050640890946,0.33581481912294986]

{"sheet":"Balance Sheet","index":2,"n_rows":37,"n_cols":12,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Profit & Loss'!A1","v":"AJANTA PHARMA 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":11.8},{"$f":"'Data Sheet'!C57","v":11.8},{"$f":"'Data Sheet'!D57","v":11.8},{"$f":"'Data Sheet'!E57","v":11.8},{"$f":"'Data Sheet'!F57","v":11.8},{"$f":"'Data Sheet'!G57","v":11.8},{"$f":"'Data Sheet'!H57","v":11.8},{"$f":"'Data Sheet'!I57","v":17.670000000000002},{"$f":"'Data Sheet'!J57","v":17.68},{"$f":"'Data Sheet'!K57","v":17.690000000000001}]
["Reserves",{"$f":"'Data Sheet'!B58","v":103.59},{"$f":"'Data Sheet'!C58","v":123.06},{"$f":"'Data Sheet'!D58","v":145.31},{"$f":"'Data Sheet'!E58","v":173.13},{"$f":"'Data Sheet'!F58","v":217.03},{"$f":"'Data Sheet'!G58","v":286.23},{"$f":"'Data Sheet'!H58","v":381.63},{"$f":"'Data Sheet'!I58","v":575.64},{"$f":"'Data Sheet'!J58","v":823.41},{"$f":"'Data Sheet'!K58","v":1154.3699999999999}]
["Borrowings",{"$f":"'Data Sheet'!B59","v":116.37},{"$f":"'Data Sheet'!C59","v":173.54},{"$f":"'Data Sheet'!D59","v":250.22},{"$f":"'Data Sheet'!E59","v":227.96},{"$f":"'Data Sheet'!F59","v":190.63},{"$f":"'Data Sheet'!G59","v":199.64},{"$f":"'Data Sheet'!H59","v":124.84},{"$f":"'Data Sheet'!I59","v":130.49},{"$f":"'Data Sheet'!J59","v":72.38},{"$f":"'Data Sheet'!K59","v":92.93}]
["Other Liabilities",{"$f":"'Data Sheet'!B60","v":36.520000000000003},{"$f":"'Data Sheet'!C60","v":59.06},{"$f":"'Data Sheet'!D60","v":64.39},{"$f":"'Data Sheet'!E60","v":89.26},{"$f":"'Data Sheet'!F60","v":102.7},{"$f":"'Data Sheet'!G60","v":152.84},{"$f":"'Data Sheet'!H60","v":200.62},{"$f":"'Data Sheet'!I60","v":225.67},{"$f":"'Data Sheet'!J60","v":234.56},{"$f":"'Data Sheet'!K60","v":222.39}]
["Total",{"$f":"'Data Sheet'!B61","v":268.27999999999997},{"$f":"'Data Sheet'!C61","v":367.46},{"$f":"'Data Sheet'!D61","v":471.72},{"$f":"'Data Sheet'!E61","v":502.15},{"$f":"'Data Sheet'!F61","v":522.16},{"$f":"'Data Sheet'!G61","v":650.51},{"$f":"'Data Sheet'!H61","v":718.89},{"$f":"'Data Sheet'!I61","v":949.47},{"$f":"'Data Sheet'!J61","v":1148.03},{"$f":"'Data Sheet'!K61","v":1487.38}]
[]
["Net Block",{"$f":"'Data Sheet'!B62","v":62},{"$f":"'Data Sheet'!C62","v":101.8},{"$f":"'Data Sheet'!D62","v":138.27000000000001},{"$f":"'Data Sheet'!E62","v":168.46},{"$f":"'Data Sheet'!F62","v":214.03},{"$f":"'Data Sheet'!G62","v":246.13},{"$f":"'Data Sheet'!H62","v":272.56},{"$f":"'Data Sheet'!I62","v":279.39},{"$f":"'Data Sheet'!J62","v":288.08999999999997},{"$f":"'Data Sheet'!K62","v":451.58}]
["Capital Work in Progress",{"$f":"'Data Sheet'!B63","v":13.44},{"$f":"'Data Sheet'!C63","v":23.88},{"$f":"'Data Sheet'!D63","v":55.17},{"$f":"'Data Sheet'!E63","v":46.99},{"$f":"'Data Sheet'!F63","v":17.22},{"$f":"'Data Sheet'!G63","v":2.5099999999999998},{"$f":"'Data Sheet'!H63","v":12.49},{"$f":"'Data Sheet'!I63","v":93.55},{"$f":"'Data Sheet'!J63","v":170.2},{"$f":"'Data Sheet'!K63","v":239.8}]
["Investments",{"$f":"'Data Sheet'!B64","v":8.4700000000000006},{"$f":"'Data Sheet'!C64","v":8.4700000000000006},{"$f":"'Data Sheet'!D64","v":8.4700000000000006},{"$f":"'Data Sheet'!E64","v":8.4700000000000006},{"$f":"'Data Sheet'!F64","v":8.4600000000000009},{"$f":"'Data Sheet'!G64","v":8.4700000000000006},{"$f":"'Data Sheet'!H64","v":8.4600000000000009},{"$f":"'Data Sheet'!I64","v":63.46},{"$f":"'Data Sheet'!J64","v":59.5},{"$f":"'Data Sheet'!K64","v":66.39}]
["Other Assets",{"$f":"'Data Sheet'!B65","v":184.37},{"$f":"'Data Sheet'!C65","v":233.31},{"$f":"'Data Sheet'!D65","v":269.81},{"$f":"'Data Sheet'!E65","v":278.23},{"$f":"'Data Sheet'!F65","v":282.45},{"$f":"'Data Sheet'!G65","v":393.4},{"$f":"'Data Sheet'!H65","v":425.38},{"$f":"'Data Sheet'!I65","v":513.07000000000005},{"$f":"'Data Sheet'!J65","v":630.24},{"$f":"'Data Sheet'!K65","v":729.61}]
["Total",{"$f":"'Data Sheet'!B66","v":268.27999999999997},{"$f":"'Data Sheet'!C66","v":367.46},{"$f":"'Data Sheet'!D66","v":471.72},{"$f":"'Data Sheet'!E66","v":502.15},{"$f":"'Data Sheet'!F66","v":522.16},{"$f":"'Data Sheet'!G66","v":650.51},{"$f":"'Data Sheet'!H66","v":718.89},{"$f":"'Data Sheet'!I66","v":949.47},{"$f":"'Data Sheet'!J66","v":1148.03},{"$f":"'Data Sheet'!K66","v":1487.38}]
[]
["Working Capital",{"$f":"B13-B7","v":147.85},{"$f":"C13-C7","v":174.25},205.42000000000002,188.97000000000003,179.75,240.55999999999997,224.76,287.40000000000009,395.68,507.22]
["Debtors",{"$f":"'Data Sheet'!B67","v":68.44},{"$f":"'Data Sheet'!C67","v":86.83},{"$f":"'Data Sheet'!D67","v":100.12},{"$f":"'Data Sheet'!E67","v":96.73},{"$f":"'Data Sheet'!F67","v":103.98},{"$f":"'Data Sheet'!G67","v":141},{"$f":"'Data Sheet'!H67","v":150.47},{"$f":"'Data Sheet'!I67","v":202.22},{"$f":"'Data Sheet'!J67","v":258.76},{"$f":"'Data Sheet'!K67","v":372.35}]
["Inventory",{"$f":"'Data Sheet'!B68","v":70.84},{"$f":"'Data Sheet'!C68","v":92.77},{"$f":"'Data Sheet'!D68","v":103.89},{"$f":"'Data Sheet'!E68","v":119.62},{"$f":"'Data Sheet'!F68","v":113.12},{"$f":"'Data Sheet'!G68","v":167.8},{"$f":"'Data Sheet'!H68","v":147.6},{"$f":"'Data Sheet'!I68","v":155.4},{"$f":"'Data Sheet'!J68","v":159.03},{"$f":"'Data Sheet'!K68","v":204.58}]
[]
["Inventory Turnover",{"$f":"IF('Balance Sheet'!B18>0,'Profit & Loss'!B4/'Balance Sheet'!B18,0)","v":3.6421513269339352},{"$f":"IF('Balance Sheet'!C18>0,'Profit & Loss'!C4/'Balance Sheet'!C18,0)","v":3.3348065107254503},{"$f":"IF('Balance Sheet'!D18>0,'Profit & Loss'!D4/'Balance Sheet'!D18,0)","v":3.3625950524593318},{"$f":"IF('Balance Sheet'!E18>0,'Profit & Loss'!E4/'Balance Sheet'!E18,0)","v":3.4203310483196789},{"$f":"IF('Balance Sheet'!F18>0,'Profit & Loss'!F4/'Balance Sheet'!F18,0)","v":4.4631364922206505},{"$f":"IF('Balance Sheet'!G18>0,'Profit & Loss'!G4/'Balance Sheet'!G18,0)","v":4.036948748510131},{"$f":"IF('Balance Sheet'!H18>0,'Profit & Loss'!H4/'Balance Sheet'!H18,0)","v":6.3065040650406505},{"$f":"IF('Balance Sheet'!I18>0,'Profit & Loss'!I4/'Balance Sheet'!I18,0)","v":7.7756756756756751},{"$f":"IF('Balance Sheet'!J18>0,'Profit & Loss'!J4/'Balance Sheet'!J18,0)","v":9.2659246683015777},{"$f":"IF('Balance Sheet'!K18>0,'Profit & Loss'!K4/'Balance Sheet'!K18,0)","v":8.4442760778179675}]
["Inventory Days",{"$f":"IF('Profit & Loss'!B4>0,'Balance Sheet'!B18/('Profit & Loss'!B4/365),0)","v":100.21549552342933},{"$f":"IF('Profit & Loss'!C4>0,'Balance Sheet'!C18/('Profit & Loss'!C4/365),0)","v":109.45162750105052},{"$f":"IF('Profit & Loss'!D4>0,'Balance Sheet'!D18/('Profit & Loss'!D4/365),0)","v":108.54711742142325},{"$f":"IF('Profit & Loss'!E4>0,'Balance Sheet'!E18/('Profit & Loss'!E4/365),0)","v":106.71481644424891},{"$f":"IF('Profit & Loss'!F4>0,'Balance Sheet'!F18/('Profit & Loss'!F4/365),0)","v":81.781052548180725},{"$f":"IF('Profit & Loss'!G4>0,'Balance Sheet'!G18/('Profit & Loss'!G4/365),0)","v":90.414821375848845},{"$f":"IF('Profit & Loss'!H4>0,'Balance Sheet'!H18/('Profit & Loss'!H4/365),0)","v":57.87675647801985},{"$f":"IF('Profit & Loss'!I4>0,'Balance Sheet'!I18/('Profit & Loss'!I4/365),0)","v":46.941258255126876},{"$f":"IF('Profit & Loss'!J4>0,'Balance Sheet'!J18/('Profit & Loss'!J4/365),0)","v":39.391643367083802},{"$f":"IF('Profit & Loss'!K4>0,'Balance Sheet'!K18/('Profit & Loss'!K4/365),0)","v":43.224546028144232}]
["Debtor Days",{"$f":"IF('Profit & Loss'!B4>0,'Balance Sheet'!B17/('Profit & Loss'!B4/365),0)","v":96.820278283787445},{"$f":"IF('Profit & Loss'!C4>0,'Balance Sheet'!C17/('Profit & Loss'!C4/365),0)","v":102.44351423861396},{"$f":"IF('Profit & Loss'!D4>0,'Balance Sheet'!D17/('Profit & Loss'!D4/365),0)","v":104.60811816568386},{"$f":"IF('Profit & Loss'!E4>0,'Balance Sheet'!E17/('Profit & Loss'!E4/365),0)","v":86.294300239526819},{"$f":"IF('Profit & Loss'!F4>0,'Balance Sheet'!F17/('Profit & Loss'!F4/365),0)","v":75.173212906292719},{"$f":"IF('Profit & Loss'!G4>0,'Balance Sheet'!G17/('Profit & Loss'!G4/365),0)","v":75.974313551815769},{"$f":"IF('Profit & Loss'!H4>0,'Balance Sheet'!H17/('Profit & Loss'!H4/365),0)","v":59.002137853981353},{"$f":"IF('Profit & Loss'!I4>0,'Balance Sheet'!I17/('Profit & Loss'!I4/365),0)","v":61.084049191452742},{"$f":"IF('Profit & Loss'!J4>0,'Balance Sheet'!J17/('Profit & Loss'!J4/365),0)","v":64.0947094112218},{"$f":"IF('Profit & Loss'!K4>0,'Balance Sheet'!K17/('Profit & Loss'!K4/365),0)","v":78.67171626541942}]
["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.12704740445445878},{"$f":"IF(SUM('Balance Sheet'!C4:C5)>0,'Profit & Loss'!C12/SUM('Balance Sheet'!C4:C5),\"\")","v":0.16224232537446237},{"$f":"IF(SUM('Balance Sheet'!D4:D5)>0,'Profit & Loss'!D12/SUM('Balance Sheet'!D4:D5),\"\")","v":0.16186111641525044},{"$f":"IF(SUM('Balance Sheet'!E4:E5)>0,'Profit & Loss'!E12/SUM('Balance Sheet'!E4:E5),\"\")","v":0.18385334991618449},{"$f":"IF(SUM('Balance Sheet'!F4:F5)>0,'Profit & Loss'!F12/SUM('Balance Sheet'!F4:F5),\"\")","v":0.22160555871170737},{"$f":"IF(SUM('Balance Sheet'!G4:G5)>0,'Profit & Loss'!G12/SUM('Balance Sheet'!G4:G5),\"\")","v":0.25923564741804517},{"$f":"IF(SUM('Balance Sheet'!H4:H5)>0,'Profit & Loss'!H12/SUM('Balance Sheet'!H4:H5),\"\")","v":0.28495539231883688},{"$f":"IF(SUM('Balance Sheet'!I4:I5)>0,'Profit & Loss'!I12/SUM('Balance Sheet'!I4:I5),\"\")","v":0.39419527734236742},{"$f":"IF(SUM('Balance Sheet'!J4:J5)>0,'Profit & Loss'!J12/SUM('Balance Sheet'!J4:J5),\"\")","v":0.3684029057532488},{"$f":"IF(SUM('Balance Sheet'!K4:K5)>0,'Profit & Loss'!K12/SUM('Balance Sheet'!K4:K5),\"\")","v":0.34248246676791294}]
["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.12518465570645687},{"$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":0.13269335265350488},{"$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.13523815065902392},{"$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.14847662479366586},{"$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":0.14797602722332265},{"$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.17766956378803753},{"$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.25263411887718168},{"$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":0.40385327899221929},{"$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":0.4372522924375154},{"$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.40641426783479356}]
[]
[]
[]
["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.23110183390487551},{"$f":"C10/C$8","v":0.27703695640341808},0.29311879928771306,0.33547744697799464,0.40989351922782291,0.37836466772224869,0.37914006315291632,0.29425890233498686,0.25094291961011472,0.30360768599819815]
["Working Capital/Total Assets",{"$f":"B16/B$8","v":0.55110332488444913},{"$f":"C16/C$8","v":0.47420127360801179},0.43547019418298993,0.37632181619038141,0.34424314386394977,0.36980215523204868,0.31264866669448732,0.30269518784163807,0.34465998275306398,0.34101574580806521]
["Debtors/Total Assets",{"$f":"B17/B$8","v":0.25510660503951099},{"$f":"C17/C$8","v":0.23629782833505689},0.21224455185279403,0.19263168375983272,0.19913436494561057,0.21675300917741464,0.20930879550418005,0.21298197942009753,0.22539480675592102,0.25033952318842528]
["Inventory/Total Assets",{"$f":"B18/B$8","v":0.26405248248099006},{"$f":"C18/C$8","v":0.2524628530996571},0.22023658102264054,0.23821567260778653,0.21663857821357441,0.25795145347496584,0.2053165296498769,0.1636702581440172,0.13852425459265003,0.13754386908523714]
[]
["Borrowings/Total Assets",{"$f":"B6/B$8","v":0.43376323244371556},{"$f":"C6/C$8","v":0.47226909051325316},0.53044178750105997,0.45396793786717121,0.36507966906695266,0.30689766490907133,0.17365660949519399,0.13743456875941315,6.3047132914645088E-2,6.2478989901706354E-2]

{"sheet":"Cash Flow","index":3,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Balance Sheet'!A1","v":"AJANTA PHARMA 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":21.13},{"$f":"'Data Sheet'!C82","v":19.079999999999998},{"$f":"'Data Sheet'!D82","v":34.590000000000003},{"$f":"'Data Sheet'!E82","v":95.11},{"$f":"'Data Sheet'!F82","v":95.37},{"$f":"'Data Sheet'!G82","v":70.349999999999994},{"$f":"'Data Sheet'!H82","v":234.29},{"$f":"'Data Sheet'!I82","v":212.42},{"$f":"'Data Sheet'!J82","v":279.42},{"$f":"'Data Sheet'!K82","v":326.38}]
["Cash from Investing Activity",{"$f":"'Data Sheet'!B83","v":-24.04},{"$f":"'Data Sheet'!C83","v":-59.14},{"$f":"'Data Sheet'!D83","v":-81.93},{"$f":"'Data Sheet'!E83","v":-42.67},{"$f":"'Data Sheet'!F83","v":-50.71},{"$f":"'Data Sheet'!G83","v":-53.07},{"$f":"'Data Sheet'!H83","v":-103.7},{"$f":"'Data Sheet'!I83","v":-187.79},{"$f":"'Data Sheet'!J83","v":-158.36000000000001},{"$f":"'Data Sheet'!K83","v":-209.29}]
["Cash from Financing Activity",{"$f":"'Data Sheet'!B84","v":3.64},{"$f":"'Data Sheet'!C84","v":38.369999999999997},{"$f":"'Data Sheet'!D84","v":49.65},{"$f":"'Data Sheet'!E84","v":-45.67},{"$f":"'Data Sheet'!F84","v":-55.89},{"$f":"'Data Sheet'!G84","v":-12.84},{"$f":"'Data Sheet'!H84","v":-104.49},{"$f":"'Data Sheet'!I84","v":-20.13},{"$f":"'Data Sheet'!J84","v":-105.19},{"$f":"'Data Sheet'!K84","v":-118.57}]
["Net Cash Flow",{"$f":"'Data Sheet'!B85","v":0.73},{"$f":"'Data Sheet'!C85","v":-1.69},{"$f":"'Data Sheet'!D85","v":2.31},{"$f":"'Data Sheet'!E85","v":6.77},{"$f":"'Data Sheet'!F85","v":-11.23},{"$f":"'Data Sheet'!G85","v":4.4400000000000004},{"$f":"'Data Sheet'!H85","v":26.1},{"$f":"'Data Sheet'!I85","v":4.5},{"$f":"'Data Sheet'!J85","v":15.87},{"$f":"'Data Sheet'!K85","v":-1.48}]

{"sheet":"Customization","index":4,"n_rows":67,"n_cols":14,"rows_kept":67,"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":"AJANTA PHARMA 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":1056.6699999999998},{"$f":"'Calculated Data'!K26-'Calculated Data'!B26","v":12975.720899849999},{"$f":"C5/B5","v":12.279823312718257},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":987.12999999999988},{"$f":"'Calculated Data'!K26-'Calculated Data'!E26","v":12859.380475649999},{"$f":"C6/B6","v":13.027038460638417},null,"MIN",{"$f":"MIN('Calculated Data'!B31:K31)","v":2.1757442430200551},{"$f":"MIN('Calculated Data'!B32:K32)","v":0.35216839220928015},{"$f":"MIN('Calculated Data'!B35:K35)","v":3.9671756787010897},{"$f":"MIN('Calculated Data'!B34:K34)","v":0.15838202353008532},{"$f":"MAX('Calculated Data'!B36:K36)","v":5.2955785835386765E-2},null,"LTB Quote",{"$f":"('Profit & Loss'!$L$10/'Data Sheet'!$B$61)/N5","v":25.154896211255242}]
["5 YR",{"$f":"'Calculated Data'!K11-'Calculated Data'!G11","v":874.03},{"$f":"'Calculated Data'!K26-'Calculated Data'!G26","v":12541.39752135},{"$f":"C7/B7","v":14.348932555347071},null,"MAX",{"$f":"MAX('Calculated Data'!B31:K31)","v":38.547881817595048},{"$f":"MAX('Calculated Data'!B32:K32)","v":14.201151672234841},{"$f":"MAX('Calculated Data'!B35:K35)","v":23.1323220982534},{"$f":"MAX('Calculated Data'!B34:K34)","v":8.1058434403756898},{"$f":"MIN('Calculated Data'!B36:K36)","v":4.4221387146284093E-3},null,"Equity Quoting @",{"$f":"('Profit & Loss'!$L$6/'Data Sheet'!$B$6)/'Data Sheet'!$B$8","v":4.0776299373666114E-2}]
["3 YR",{"$f":"'Calculated Data'!K11-'Calculated Data'!I11","v":578.75},{"$f":"'Calculated Data'!K26-'Calculated Data'!I26","v":9539.9123077499989},{"$f":"C8/B8","v":16.483649775809933},null,"TRAILING",{"$f":"'Data Sheet'!B8/'Profit & Loss'!L13","v":33.666581382457039},{"$f":"'Calculated Data'!L26/'Calculated Data'!K11","v":13.47226251215808},{"$f":"'Calculated Data'!K35","v":21.902347547919984},{"$f":"'Calculated Data'!L26/'Data Sheet'!K17","v":9.1403911943642075},{"$f":"'Data Sheet'!K31/'Calculated Data'!L26","v":4.4584333419884362E-3}]
["1 YR",{"$f":"'Calculated Data'!K11-'Calculated Data'!J11","v":330.97},{"$f":"'Calculated Data'!K26-'Calculated Data'!J26","v":1100.9506477499981},{"$f":"C9/B9","v":3.3264363771640872},null,null,null,null,null,null,null,null," "]
["* IMPACT – Every Rupee retained added xx.yy in incremental market value"]
[]
[{"$f":"A1","v":"AJANTA PHARMA 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":0.23524851345618658},{"$f":"POWER('Calculated Data'!$K4/'Calculated Data'!$B4, 1/9)-1","v":0.31018222368770632},{"$f":"POWER('Calculated Data'!$K5/'Calculated Data'!$B5, 1/9)-1","v":0.37343981077687283},{"$f":"POWER('Calculated Data'!$K8/'Calculated Data'!$B8, 1/9)-1","v":0.44449863319568239},{"$f":"POWER('Calculated Data'!$K9/'Calculated Data'!$B9, 1/9)-1","v":0.45969414781571216},{"$f":"POWER('Calculated Data'!$K24/'Calculated Data'!$B24, 1/9)-1","v":-2.3790741663964274},{"$f":"POWER('Calculated Data'!$K26/'Calculated Data'!$B26, 1/9)-1","v":0.78848675650947753},{"$f":"POWER('Calculated Data'!$K17/'Calculated Data'!$B17, 1/9)-1","v":0.35547515021762566},{"$f":"POWER('Calculated Data'!$K19/'Calculated Data'!$C19, 1/8)-1","v":{"$error":"#NUM!"}},{"$f":"POWER('Calculated Data'!$K11/'Calculated Data'!$B11, 1/9)-1","v":0.29379250266772239},{"$f":"POWER('Calculated Data'!$K27/'Calculated Data'!$B27, 1/9)-1","v":0.78300052569712353}]
["5 YR CAGR",{"$f":"POWER('Data Sheet'!$K17/'Data Sheet'!$G17, 1/4)-1","v":0.26370324711714987},{"$f":"POWER('Calculated Data'!$K4/'Calculated Data'!$G4, 1/4)-1","v":0.31200473957949293},{"$f":"POWER('Calculated Data'!$K5/'Calculated Data'!$G5, 1/4)-1","v":0.50947803718696671},{"$f":"POWER('Calculated Data'!$K8/'Calculated Data'!$G8, 1/4)-1","v":0.50976158541131711},{"$f":"POWER('Calculated Data'!$K9/'Calculated Data'!$G9, 1/4)-1","v":0.68274975426897355},{"$f":"POWER('Calculated Data'!$K24/'Calculated Data'!$G24, 1/4)-1","v":0.74308359643173505},{"$f":"POWER('Calculated Data'!$K26/'Calculated Data'!$G26, 1/4)-1","v":1.2555722324657297},{"$f":"POWER('Calculated Data'!$K17/'Calculated Data'!$G17, 1/4)-1","v":0.46762418226505398},{"$f":"POWER('Calculated Data'!$K19/'Calculated Data'!$G19, 1/4)-1","v":0.22973113972003878},{"$f":"POWER('Calculated Data'!$K11/'Calculated Data'!$G11, 1/4)-1","v":0.40822634709634853},{"$f":"POWER('Calculated Data'!$K27/'Calculated Data'!$G27, 1/4)-1","v":1.2488782791982178}]
["3 YR CAGR",{"$f":"POWER('Data Sheet'!$K17/'Data Sheet'!$I17, 1/2)-1","v":0.1956889696546773},{"$f":"POWER('Calculated Data'!$K4/'Calculated Data'!$I4, 1/2)-1","v":0.20636156564330621},{"$f":"POWER('Calculated Data'!$K5/'Calculated Data'!$I5, 1/2)-1","v":0.27718244227052913},{"$f":"POWER('Calculated Data'!$K8/'Calculated Data'!$I8, 1/2)-1","v":0.31007919917989102},{"$f":"POWER('Calculated Data'!$K9/'Calculated Data'!$I9, 1/2)-1","v":0.414615498877551},{"$f":"POWER('Calculated Data'!$K24/'Calculated Data'!$I24, 1/2)-1","v":0.25525300059061151},{"$f":"POWER('Calculated Data'!$K26/'Calculated Data'!$I26, 1/2)-1","v":0.92909936758658906},{"$f":"POWER('Calculated Data'!$K17/'Calculated Data'!$I17, 1/2)-1","v":0.23955004881207898},{"$f":"POWER('Calculated Data'!$K19/'Calculated Data'!$I19, 1/2)-1","v":-0.22668498072722176},{"$f":"POWER('Calculated Data'!$K11/'Calculated Data'!$I11, 1/2)-1","v":0.40551047989322497},{"$f":"POWER('Calculated Data'!$K27/'Calculated Data'!$I27, 1/2)-1","v":0.9246640272681157}]
["1 YR GROWTH",{"$f":"('Data Sheet'!$K17-'Data Sheet'!$J17)/'Data Sheet'!$J17","v":0.17235131246776517},{"$f":"('Calculated Data'!$K4-'Calculated Data'!$J4)/'Calculated Data'!$J4","v":0.13352996019650717},{"$f":"('Calculated Data'!$K5-'Calculated Data'!$J5)/'Calculated Data'!$J5","v":0.19561405407745752},{"$f":"('Calculated Data'!$K8-'Calculated Data'!$J8)/'Calculated Data'!$J8","v":0.29545601239269348},{"$f":"('Calculated Data'!$K9-'Calculated Data'!$J9)/'Calculated Data'!$J9","v":0.3328284740628551},{"$f":"('Calculated Data'!$K24-'Calculated Data'!$J24)/'Calculated Data'!$J24","v":0.20857541912714395},{"$f":"('Calculated Data'!$K26-'Calculated Data'!$J26)/'Calculated Data'!$J26","v":9.2172595272822622E-2},{"$f":"('Calculated Data'!$K17-'Calculated Data'!$J17)/'Calculated Data'!$J17","v":0.1680624150025051},{"$f":"('Calculated Data'!$K19-'Calculated Data'!$J19)/'Calculated Data'!$J19","v":-0.66137751878115603},{"$f":"('Calculated Data'!$K11-'Calculated Data'!$J11)/'Calculated Data'!$J11","v":0.39350128999274758},{"$f":"('Calculated Data'!$K27-'Calculated Data'!$J27)/'Calculated Data'!$J27","v":9.3232123570219774E-2}]
["**modify (if, then) for negative values"]
[{"$f":"A1","v":"AJANTA PHARMA 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":2.3249848340410777},{"$f":"'Calculated Data'!C15/'Calculated Data'!C11","v":2.724751594245884},{"$f":"'Calculated Data'!D15/'Calculated Data'!D11","v":3.0024823372159632},{"$f":"'Calculated Data'!E15/'Calculated Data'!E11","v":2.7153517547180011},{"$f":"'Calculated Data'!F15/'Calculated Data'!F11","v":2.2818686361054055},{"$f":"'Calculated Data'!G15/'Calculated Data'!G11","v":2.18269972821528},{"$f":"'Calculated Data'!H15/'Calculated Data'!H11","v":1.8272373738657448},{"$f":"'Calculated Data'!I15/'Calculated Data'!I11","v":1.6002932699600547},{"$f":"'Calculated Data'!J15/'Calculated Data'!J11","v":1.3649312202023565},{"$f":"'Calculated Data'!K15/'Calculated Data'!K11","v":1.2690305957032917}," "]
["Long term debt/Earning",{"$f":"'Data Sheet'!B59/'Data Sheet'!B30","v":7.9379263301500682},{"$f":"'Data Sheet'!C59/'Data Sheet'!C30","v":7.9314442413162709},{"$f":"'Data Sheet'!D59/'Data Sheet'!D30","v":9.839559575304758},{"$f":"'Data Sheet'!E59/'Data Sheet'!E30","v":6.7047058823529415},{"$f":"'Data Sheet'!F59/'Data Sheet'!F30","v":3.7592190889370931},{"$f":"'Data Sheet'!G59/'Data Sheet'!G30","v":2.584002070929329},{"$f":"'Data Sheet'!H59/'Data Sheet'!H30","v":1.1135491927571135},{"$f":"'Data Sheet'!I59/'Data Sheet'!I30","v":0.55793569351804351},{"$f":"'Data Sheet'!J59/'Data Sheet'!J30","v":0.23358936293810106},{"$f":"'Data Sheet'!K59/'Data Sheet'!K30","v":0.23150893101816097}]
["Current liablility/Earning",{"$f":"'Data Sheet'!B60/'Data Sheet'!B30","v":2.4911323328785815},{"$f":"'Data Sheet'!C60/'Data Sheet'!C30","v":2.6992687385740406},{"$f":"'Data Sheet'!D60/'Data Sheet'!D30","v":2.5320487613055449},{"$f":"'Data Sheet'!E60/'Data Sheet'!E30","v":2.625294117647059},{"$f":"'Data Sheet'!F60/'Data Sheet'!F30","v":2.0252415697101163},{"$f":"'Data Sheet'!G60/'Data Sheet'!G30","v":1.9782552420398654},{"$f":"'Data Sheet'!H60/'Data Sheet'!H30","v":1.7894924627597895},{"$f":"'Data Sheet'!I60/'Data Sheet'!I30","v":0.96489652813408577},{"$f":"'Data Sheet'!J60/'Data Sheet'!J30","v":0.75698702639901894},{"$f":"'Data Sheet'!K60/'Data Sheet'!K30","v":0.55402207219551081}]
["Total liability/Earning",{"$f":"('Data Sheet'!B59+'Data Sheet'!B60)/'Data Sheet'!B30","v":10.42905866302865},{"$f":"('Data Sheet'!C59+'Data Sheet'!C60)/'Data Sheet'!C30","v":10.63071297989031},{"$f":"('Data Sheet'!D59+'Data Sheet'!D60)/'Data Sheet'!D30","v":12.371608336610304},{"$f":"('Data Sheet'!E59+'Data Sheet'!E60)/'Data Sheet'!E30","v":9.33},{"$f":"('Data Sheet'!F59+'Data Sheet'!F60)/'Data Sheet'!F30","v":5.7844606586472089},{"$f":"('Data Sheet'!G59+'Data Sheet'!G60)/'Data Sheet'!G30","v":4.5622573129691952},{"$f":"('Data Sheet'!H59+'Data Sheet'!H60)/'Data Sheet'!H30","v":2.9030416555169034},{"$f":"('Data Sheet'!I59+'Data Sheet'!I60)/'Data Sheet'!I30","v":1.5228322216521293},{"$f":"('Data Sheet'!J59+'Data Sheet'!J60)/'Data Sheet'!J30","v":0.99057638933711989},{"$f":"('Data Sheet'!K59+'Data Sheet'!K60)/'Data Sheet'!K30","v":0.78553100321367175}]
["Debt/Equity",{"$f":"'Data Sheet'!B59/'Calculated Data'!B11","v":1.0084929369962736},{"$f":"'Data Sheet'!C59/'Calculated Data'!C11","v":1.2868159572890403},{"$f":"'Data Sheet'!D59/'Calculated Data'!D11","v":1.5926420978931957},{"$f":"'Data Sheet'!E59/'Calculated Data'!E11","v":1.2326826366733359},{"$f":"'Data Sheet'!F59/'Calculated Data'!F11","v":0.83306384652362009},{"$f":"'Data Sheet'!G59/'Calculated Data'!G11","v":0.66986544978693408},{"$f":"'Data Sheet'!H59/'Calculated Data'!H11","v":0.31731184708842741},{"$f":"'Data Sheet'!I59/'Calculated Data'!I11","v":0.21993561544555126},{"$f":"'Data Sheet'!J59/'Calculated Data'!J11","v":8.6055000059446676E-2},{"$f":"'Data Sheet'!K59/'Calculated Data'!K11","v":7.9287749773902363E-2}]
["Interest Coverage",{"$f":"'Calculated Data'!B5/'Data Sheet'!B27","v":2.5654281098546039},{"$f":"'Calculated Data'!C5/'Data Sheet'!C27","v":2.7893432465923169},{"$f":"'Calculated Data'!D5/'Data Sheet'!D27","v":2.2658174097664543},{"$f":"'Calculated Data'!E5/'Data Sheet'!E27","v":2.9235732009925557},{"$f":"'Calculated Data'!F5/'Data Sheet'!F27","v":4.1293007769145396},{"$f":"'Calculated Data'!G5/'Data Sheet'!G27","v":6.8943616331821129},{"$f":"'Calculated Data'!H5/'Data Sheet'!H27","v":10.241505488761108},{"$f":"'Calculated Data'!I5/'Data Sheet'!I27","v":38.78350515463918},{"$f":"'Calculated Data'!J5/'Data Sheet'!J27","v":78.028716216216225},{"$f":"'Calculated Data'!K5/'Data Sheet'!K27","v":112.94274028629857}]
["Working Capital/Sales",{"$f":"'Calculated Data'!B12/'Data Sheet'!B17","v":0.57303980465873416},{"$f":"'Calculated Data'!C12/'Data Sheet'!C17","v":0.56324142612405859},{"$f":"'Calculated Data'!D12/'Data Sheet'!D17","v":0.588023129329593},{"$f":"'Calculated Data'!E12/'Data Sheet'!E17","v":0.46187124211761266},{"$f":"'Calculated Data'!F12/'Data Sheet'!F17","v":0.35603224592469346},{"$f":"'Calculated Data'!G12/'Data Sheet'!G17","v":0.35512252731030408},{"$f":"'Calculated Data'!H12/'Data Sheet'!H17","v":0.24145932705943018},{"$f":"'Calculated Data'!I12/'Data Sheet'!I17","v":0.23784696360295951},{"$f":"'Calculated Data'!J12/'Data Sheet'!J17","v":0.26851977523819864},{"$f":"'Calculated Data'!K12/'Data Sheet'!K17","v":0.29360995178086635},"Check for improving or deteriorating picture"]
["Inventory Turns",{"$f":"365/B27","v":3.6421513269339356},3.3348065107254499,3.3625950524593322,3.4203310483196789,4.4631364922206505,4.036948748510131,6.3065040650406505,7.7756756756756742,9.2659246683015777,8.4442760778179675]
["Inventory Days",{"$f":"'Balance Sheet'!B21","v":100.21549552342933},{"$f":"'Balance Sheet'!C21","v":109.45162750105052},{"$f":"'Balance Sheet'!D21","v":108.54711742142325},{"$f":"'Balance Sheet'!E21","v":106.71481644424891},{"$f":"'Balance Sheet'!F21","v":81.781052548180725},{"$f":"'Balance Sheet'!G21","v":90.414821375848845},{"$f":"'Balance Sheet'!H21","v":57.87675647801985},{"$f":"'Balance Sheet'!I21","v":46.941258255126876},{"$f":"'Balance Sheet'!J21","v":39.391643367083802},{"$f":"'Balance Sheet'!K21","v":43.224546028144232}]
["Debtor Days",{"$f":"'Balance Sheet'!B22","v":96.820278283787445},{"$f":"'Balance Sheet'!C22","v":102.44351423861396},{"$f":"'Balance Sheet'!D22","v":104.60811816568386},{"$f":"'Balance Sheet'!E22","v":86.294300239526819},{"$f":"'Balance Sheet'!F22","v":75.173212906292719},{"$f":"'Balance Sheet'!G22","v":75.974313551815769},{"$f":"'Balance Sheet'!H22","v":59.002137853981353},{"$f":"'Balance Sheet'!I22","v":61.084049191452742},{"$f":"'Balance Sheet'!J22","v":64.0947094112218},{"$f":"'Balance Sheet'!K22","v":78.67171626541942}]
["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":2.0780394304490688},{"$f":"('Data Sheet'!C67+'Data Sheet'!C69)/'Data Sheet'!C60","v":1.5677277345072806},{"$f":"('Data Sheet'!D67+'Data Sheet'!D69)/'Data Sheet'!D60","v":1.6802298493554899},{"$f":"('Data Sheet'!E67+'Data Sheet'!E69)/'Data Sheet'!E60","v":1.2499439838673538},{"$f":"('Data Sheet'!F67+'Data Sheet'!F69)/'Data Sheet'!F60","v":1.1247322297955209},{"$f":"('Data Sheet'!G67+'Data Sheet'!G69)/'Data Sheet'!G60","v":0.99757916775713162},{"$f":"('Data Sheet'!H67+'Data Sheet'!H69)/'Data Sheet'!H60","v":0.98046057222609906},{"$f":"('Data Sheet'!I67+'Data Sheet'!I69)/'Data Sheet'!I60","v":1.1636903443080606},{"$f":"('Data Sheet'!J67+'Data Sheet'!J69)/'Data Sheet'!J60","v":1.6862210095497954},{"$f":"('Data Sheet'!K67+'Data Sheet'!K69)/'Data Sheet'!K60","v":1.9214443095462928},null,"  "]
["Current Ratio",{"$f":"'Data Sheet'!B65/'Data Sheet'!B60","v":5.0484665936473165},{"$f":"'Data Sheet'!C65/'Data Sheet'!C60","v":3.9503894344734167},{"$f":"'Data Sheet'!D65/'Data Sheet'!D60","v":4.1902469327535332},{"$f":"'Data Sheet'!E65/'Data Sheet'!E60","v":3.1170737172305625},{"$f":"'Data Sheet'!F65/'Data Sheet'!F60","v":2.7502434274586172},{"$f":"'Data Sheet'!G65/'Data Sheet'!G60","v":2.5739335252551685},{"$f":"'Data Sheet'!H65/'Data Sheet'!H60","v":2.1203269863423388},{"$f":"'Data Sheet'!I65/'Data Sheet'!I60","v":2.2735410112110608},{"$f":"'Data Sheet'!J65/'Data Sheet'!J60","v":2.6869031377899044},{"$f":"'Data Sheet'!K65/'Data Sheet'!K60","v":3.2807680201447909}," "]
["CFO/PAT",{"$f":"'Calculated Data'!B17/'Calculated Data'!B8","v":1.4413369713506139},{"$f":"'Calculated Data'!C17/'Calculated Data'!C8","v":0.87202925045703839},{"$f":"'Calculated Data'!D17/'Calculated Data'!D8","v":1.3602044828942195},{"$f":"'Calculated Data'!E17/'Calculated Data'!E8","v":2.7973529411764706},{"$f":"'Calculated Data'!F17/'Calculated Data'!F8","v":1.8806941431670283},{"$f":"'Calculated Data'!G17/'Calculated Data'!G8","v":0.91056173958063669},{"$f":"'Calculated Data'!H17/'Calculated Data'!H8","v":2.08982249576309},{"$f":"'Calculated Data'!I17/'Calculated Data'!I8","v":0.90824354369762272},{"$f":"'Calculated Data'!J17/'Calculated Data'!J8","v":0.90176208610340158},{"$f":"'Calculated Data'!K17/'Calculated Data'!K8","v":0.81308387932537796}]
[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.43079725592031309},{"$f":"'Calculated Data'!C4/'Data Sheet'!C17","v":0.50163234961373115},{"$f":"'Calculated Data'!D4/'Data Sheet'!D17","v":0.61656266101791946},{"$f":"'Calculated Data'!E4/'Data Sheet'!E17","v":0.67578335044239135},{"$f":"'Calculated Data'!F4/'Data Sheet'!F17","v":0.64592865490126172},{"$f":"'Calculated Data'!G4/'Data Sheet'!G17","v":0.62995276055506355},{"$f":"'Calculated Data'!H4/'Data Sheet'!H17","v":0.66464698551845647},{"$f":"'Calculated Data'!I4/'Data Sheet'!I17","v":0.71903603290464602},{"$f":"'Calculated Data'!J4/'Data Sheet'!J17","v":0.75699666114715392},{"$f":"'Calculated Data'!K4/'Data Sheet'!K17","v":0.73192940209431956}]
["EBIT/Sales",{"$f":"'Calculated Data'!B5/'Data Sheet'!B17","v":0.12309600403085151},{"$f":"'Calculated Data'!C5/'Data Sheet'!C17","v":0.14552154378252577},{"$f":"'Calculated Data'!D5/'Data Sheet'!D17","v":0.15274517661876683},{"$f":"'Calculated Data'!E5/'Data Sheet'!E17","v":0.14398494402893874},{"$f":"'Calculated Data'!F5/'Data Sheet'!F17","v":0.14738447521144057},{"$f":"'Calculated Data'!G5/'Data Sheet'!G17","v":0.15704162976085032},{"$f":"'Calculated Data'!H5/'Data Sheet'!H17","v":0.21047655880709895},{"$f":"'Calculated Data'!I5/'Data Sheet'!I17","v":0.28020259198569947},{"$f":"'Calculated Data'!J5/'Data Sheet'!J17","v":0.313478921794837},{"$f":"'Calculated Data'!K5/'Data Sheet'!K17","v":0.31969922374719972}]
["EBITDA/Sales",{"$f":"'Calculated Data'!B6/'Data Sheet'!B17","v":0.15697066005193597},{"$f":"'Calculated Data'!C6/'Data Sheet'!C17","v":0.17096033875294953},{"$f":"'Calculated Data'!D6/'Data Sheet'!D17","v":0.19339325585389594},{"$f":"'Calculated Data'!E6/'Data Sheet'!E17","v":0.19465219729188055},{"$f":"'Calculated Data'!F6/'Data Sheet'!F17","v":0.19640699586032048},{"$f":"'Calculated Data'!G6/'Data Sheet'!G17","v":0.2040891644523177},{"$f":"'Calculated Data'!H6/'Data Sheet'!H17","v":0.24718533797430275},{"$f":"'Calculated Data'!I6/'Data Sheet'!I17","v":0.31651687438965859},{"$f":"'Calculated Data'!J6/'Data Sheet'!J17","v":0.34852330410706051},{"$f":"'Calculated Data'!K6/'Data Sheet'!K17","v":0.34578270710204739}]
["Op Profit (Ex Other Income)/Sales",{"$f":"'Calculated Data'!B7/'Data Sheet'!B17","v":0.15379248866323011},{"$f":"'Calculated Data'!C7/'Data Sheet'!C17","v":0.16598248052493775},{"$f":"'Calculated Data'!D7/'Data Sheet'!D17","v":0.18623690387588024},{"$f":"'Calculated Data'!E7/'Data Sheet'!E17","v":0.1920125140538691},{"$f":"'Calculated Data'!F7/'Data Sheet'!F17","v":0.17568879117396555},{"$f":"'Calculated Data'!G7/'Data Sheet'!G17","v":0.19490699734278122},{"$f":"'Calculated Data'!H7/'Data Sheet'!H17","v":0.24116926646899572},{"$f":"'Calculated Data'!I7/'Data Sheet'!I17","v":0.30517073009252371},{"$f":"'Calculated Data'!J7/'Data Sheet'!J17","v":0.33712234316892425},{"$f":"'Calculated Data'!K7/'Data Sheet'!K17","v":0.33615624620122364}]
["Net Margin =PAT/Sales",{"$f":"'Calculated Data'!B8/'Data Sheet'!B17","v":5.6819503120034108E-2},{"$f":"'Calculated Data'!C8/'Data Sheet'!C17","v":7.0724375343439894E-2},{"$f":"'Calculated Data'!D8/'Data Sheet'!D17","v":7.2794412320375576E-2},{"$f":"'Calculated Data'!E8/'Data Sheet'!E17","v":8.3101138974434177E-2},{"$f":"'Calculated Data'!F8/'Data Sheet'!F17","v":0.10044169786281618},{"$f":"'Calculated Data'!G8/'Data Sheet'!G17","v":0.11405373486861531},{"$f":"'Calculated Data'!H8/'Data Sheet'!H17","v":0.12043960293928065},{"$f":"'Calculated Data'!I8/'Data Sheet'!I17","v":0.19355479418044591},{"$f":"'Calculated Data'!J8/'Data Sheet'!J17","v":0.21027986644588617},{"$f":"'Calculated Data'!K8/'Data Sheet'!K17","v":0.23236065365000899}]
["Op Cash Flow/Sales",{"$f":"'Calculated Data'!B17/'Data Sheet'!B17","v":8.1896050540676724E-2},{"$f":"'Calculated Data'!C17/'Data Sheet'!C17","v":6.1673724019782133E-2},{"$f":"'Calculated Data'!D17/'Data Sheet'!D17","v":9.9015285967825065E-2},{"$f":"'Calculated Data'!E17/'Data Sheet'!E17","v":0.2324632155252481},{"$f":"'Calculated Data'!F17/'Data Sheet'!F17","v":0.18890011290035058},{"$f":"'Calculated Data'!G17/'Data Sheet'!G17","v":0.10385296722763507},{"$f":"'Calculated Data'!H17/'Data Sheet'!H17","v":0.25169739160328303},{"$f":"'Calculated Data'!I17/'Data Sheet'!I17","v":0.17579489216611219},{"$f":"'Calculated Data'!J17/'Data Sheet'!J17","v":0.18962241103178698},{"$f":"'Calculated Data'!K17/'Data Sheet'!K17","v":0.18892870167232986}]
["Free Cash Flow/Sales",{"$f":"'Calculated Data'!B19/'Data Sheet'!B17","v":0},{"$f":"'Calculated Data'!C19/'Data Sheet'!C17","v":-0.12615961470084364},{"$f":"'Calculated Data'!D19/'Data Sheet'!D17","v":-0.13559855727944128},{"$f":"'Calculated Data'!E19/'Data Sheet'!E17","v":0.12800019553209172},{"$f":"'Calculated Data'!F19/'Data Sheet'!F17","v":0.10858240735238778},{"$f":"'Calculated Data'!G19/'Data Sheet'!G17","v":3.1133746678476536E-2},{"$f":"'Calculated Data'!H19/'Data Sheet'!H17","v":0.17587340466675258},{"$f":"'Calculated Data'!I19/'Data Sheet'!I17","v":6.6744459340913984E-2},{"$f":"'Calculated Data'!J19/'Data Sheet'!J17","v":9.6657075382067942E-2},{"$f":"'Calculated Data'!K19/'Data Sheet'!K17","v":2.7918473195834494E-2}]
["EPA/Sales",{"$f":"'Calculated Data'!B24/'Data Sheet'!B17","v":-5.726608459838247E-2},{"$f":"'Calculated Data'!C24/'Data Sheet'!C17","v":-5.6510563753700865E-2},{"$f":"'Calculated Data'!D24/'Data Sheet'!D17","v":-0.10400851103476934},{"$f":"'Calculated Data'!E24/'Data Sheet'!E17","v":-4.3485611887212457E-2},{"$f":"'Calculated Data'!F24/'Data Sheet'!F17","v":1.1699026662457625E-2},{"$f":"'Calculated Data'!G24/'Data Sheet'!G17","v":4.2628944656228941E-2},{"$f":"'Calculated Data'!H24/'Data Sheet'!H17","v":7.3737963383667754E-2},{"$f":"'Calculated Data'!I24/'Data Sheet'!I17","v":0.14001383412100477},{"$f":"'Calculated Data'!J24/'Data Sheet'!J17","v":0.14968595623347578},{"$f":"'Calculated Data'!K24/'Data Sheet'!K17","v":0.15431105451787899}]
[]
["Sales/Invested Capital =Capital Turns",{"$f":"'Data Sheet'!B17/'Calculated Data'!B13","v":1.1554928568229657},{"$f":"'Data Sheet'!C17/'Calculated Data'!C13","v":1.031474010602474},{"$f":"'Data Sheet'!D17/'Calculated Data'!D13","v":0.87584616156044715},{"$f":"'Data Sheet'!E17/'Calculated Data'!E13","v":1.0116710350625586},{"$f":"'Data Sheet'!F17/'Calculated Data'!F13","v":1.2283941605839417},{"$f":"'Data Sheet'!G17/'Calculated Data'!G13","v":1.3847097301717091},{"$f":"'Data Sheet'!H17/'Calculated Data'!H13","v":1.8258566917086758},{"$f":"'Data Sheet'!I17/'Calculated Data'!I13","v":1.8298755186721987},{"$f":"'Data Sheet'!J17/'Calculated Data'!J13","v":1.7255407098610021},{"$f":"'Data Sheet'!K17/'Calculated Data'!K13","v":1.4412898381445021}]
["Sales/Fixed Assets= Fixed Asset Turns",{"$f":"'Data Sheet'!B17/'Data Sheet'!B62","v":4.1614516129032255},{"$f":"'Data Sheet'!C17/'Data Sheet'!C62","v":3.0389980353634578},{"$f":"'Data Sheet'!D17/'Data Sheet'!D62","v":2.5265061112316478},{"$f":"'Data Sheet'!E17/'Data Sheet'!E62","v":2.4287071114804699},{"$f":"'Data Sheet'!F17/'Data Sheet'!F62","v":2.3588749240760643},{"$f":"'Data Sheet'!G17/'Data Sheet'!G62","v":2.752204119774103},{"$f":"'Data Sheet'!H17/'Data Sheet'!H62","v":3.4151746404461405},{"$f":"'Data Sheet'!I17/'Data Sheet'!I62","v":4.3249221518307737},{"$f":"'Data Sheet'!J17/'Data Sheet'!J62","v":5.1149293623520427},{"$f":"'Data Sheet'!K17/'Data Sheet'!K62","v":3.825523716727933}]
["Sales/Total Assets= Asset Turns",{"$f":"'Data Sheet'!B17/'Calculated Data'!B15","v":0.96171909944833767},{"$f":"'Data Sheet'!C17/'Calculated Data'!C15","v":0.84191476623305939},{"$f":"'Data Sheet'!D17/'Calculated Data'!D15","v":0.7405664377172898},{"$f":"'Data Sheet'!E17/'Calculated Data'!E15","v":0.81477646121676794},{"$f":"'Data Sheet'!F17/'Calculated Data'!F15","v":0.96688754404780153},{"$f":"'Data Sheet'!G17/'Calculated Data'!G15","v":1.0413367972821324},{"$f":"'Data Sheet'!H17/'Calculated Data'!H15","v":1.294829528856988},{"$f":"'Data Sheet'!I17/'Calculated Data'!I15","v":1.272646845081993},{"$f":"'Data Sheet'!J17/'Calculated Data'!J15","v":1.2835553077881239},{"$f":"'Data Sheet'!K17/'Calculated Data'!K15","v":1.1614584033669941}]
["Net Margin*Asset Turns= RoA",{"$f":"B39*B46","v":5.4644401371701214E-2},{"$f":"C39*C46","v":5.9543895934251349E-2},5.3909098617824135E-2,6.770885193667231E-2,9.7115826566569655E-2,0.11876835098614932,0.15594875432959146,0.24632689816423897,0.26990583869759499,0.26987723379365058,"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.12704740445445878},0.16224232537446237,0.16186111641525047,0.18385334991618449,0.2216055587117074,0.25923564741804511,0.28495539231883688,0.39419527734236737,0.36840290575324874,0.34248246676791294,"Check back what is really driving RoE (Net Margins, Asset Turns, or Financial Leverage)"]
["RoCE",{"$f":"'Calculated Data'!B5/'Calculated Data'!B14","v":0.13703831549879186},{"$f":"'Calculated Data'!C5/'Calculated Data'!C14","v":0.1459792477302205},{"$f":"'Calculated Data'!D5/'Calculated Data'!D14","v":0.13099943534726141},{"$f":"'Calculated Data'!E5/'Calculated Data'!E14","v":0.14267722637990748},{"$f":"'Calculated Data'!F5/'Calculated Data'!F14","v":0.17739474562532778},{"$f":"'Calculated Data'!G5/'Calculated Data'!G14","v":0.21375610344203988},{"$f":"'Calculated Data'!H5/'Calculated Data'!H14","v":0.37802689717714705},{"$f":"'Calculated Data'!I5/'Calculated Data'!I14","v":0.46778115501519768},{"$f":"'Calculated Data'!J5/'Calculated Data'!J14","v":0.50568710521418336},{"$f":"'Calculated Data'!K5/'Calculated Data'!K14","v":0.43659633672993459}]
["EBIT Margin*Cap Turns*(1-Tax rate)= RoIC",{"$f":"B36*B44*(1-'Calculated Data'!B20)","v":0.10796180082258924},{"$f":"C36*C44*(1-'Calculated Data'!C20)","v":0.11449931576832378},{"$f":"D36*D44*(1-'Calculated Data'!D20)","v":0.11412471871569968},{"$f":"E36*E44*(1-'Calculated Data'!E20)","v":0.12777666435015878},{"$f":"F36*F44*(1-'Calculated Data'!F20)","v":0.16280997087972235},{"$f":"G36*G44*(1-'Calculated Data'!G20)","v":0.18472494164216458},{"$f":"H36*H44*(1-'Calculated Data'!H20)","v":0.24370086961023094},{"$f":"I36*I44*(1-'Calculated Data'!I20)","v":0.36355514239408937},{"$f":"J36*J44*(1-'Calculated Data'!J20)","v":0.36755700509797362},{"$f":"K36*K44*(1-'Calculated Data'!K20)","v":0.33789074846851225},"Check back what is really driving RoIC (Op Margins or Capital Turns, or both)"]
[]
["Altman Z-Score",{"$f":"'Calculated Data'!B43","v":2.2338297478008053},{"$f":"'Calculated Data'!C43","v":2.0212930200838186},{"$f":"'Calculated Data'!D43","v":1.7735722582464171},{"$f":"'Calculated Data'!E43","v":1.9591578198944539},{"$f":"'Calculated Data'!F43","v":2.2167498164930288},{"$f":"'Calculated Data'!G43","v":2.6370046145947024},{"$f":"'Calculated Data'!H43","v":3.8884956704641875},{"$f":"'Calculated Data'!I43","v":5.3208684845229444},{"$f":"'Calculated Data'!J43","v":9.5809943956168393},{"$f":"'Calculated Data'!K43","v":8.3700220418790074}]
["Dividend Payout",{"$f":"'Data Sheet'!B31/'Data Sheet'!B30","v":0.15961800818553887},{"$f":"'Data Sheet'!C31/'Data Sheet'!C30","v":0.13391224862888484},{"$f":"'Data Sheet'!D31/'Data Sheet'!D30","v":0.11521824616594574},{"$f":"'Data Sheet'!E31/'Data Sheet'!E30","v":0.12029411764705882},{"$f":"'Data Sheet'!F31/'Data Sheet'!F30","v":0.11536186156576611},{"$f":"'Data Sheet'!G31/'Data Sheet'!G30","v":0.11364224695832253},{"$f":"'Data Sheet'!H31/'Data Sheet'!H30","v":0.13067522968513068},{"$f":"'Data Sheet'!I31/'Data Sheet'!I30","v":0.15041901829998289},{"$f":"'Data Sheet'!J31/'Data Sheet'!J30","v":0.17046408055250759},{"$f":"'Data Sheet'!K31/'Data Sheet'!K30","v":0.17538177922822051}]
["Cash/Assets",{"$f":"'Data Sheet'!B69/'Data Sheet'!B61","v":2.7769494557924559E-2},{"$f":"'Data Sheet'!C69/'Data Sheet'!C61","v":1.5675175529309311E-2},{"$f":"'Data Sheet'!D69/'Data Sheet'!D61","v":1.7107606207071992E-2},{"$f":"'Data Sheet'!E69/'Data Sheet'!E61","v":2.9552922433535796E-2},{"$f":"'Data Sheet'!F69/'Data Sheet'!F61","v":2.2081354374138194E-2},{"$f":"'Data Sheet'!G69/'Data Sheet'!G61","v":1.7632319257198201E-2},{"$f":"'Data Sheet'!H69/'Data Sheet'!H61","v":6.430747402245128E-2},{"$f":"'Data Sheet'!I69/'Data Sheet'!I61","v":6.3603905336661506E-2},{"$f":"'Data Sheet'!J69/'Data Sheet'!J61","v":0.11912580681689502},{"$f":"'Data Sheet'!K69/'Data Sheet'!K61","v":3.6950880070997325E-2}]
["EBIT/Invested Capital",{"$f":"'Calculated Data'!B5/'Calculated Data'!B13","v":0.14223655336109992},{"$f":"'Calculated Data'!C5/'Calculated Data'!C13","v":0.15010169039442534},{"$f":"'Calculated Data'!D5/'Calculated Data'!D13","v":0.13378127663841949},{"$f":"'Calculated Data'!E5/'Calculated Data'!E13","v":0.14566539735918102},{"$f":"'Calculated Data'!F5/'Calculated Data'!F13","v":0.18104622871046228},{"$f":"'Calculated Data'!G5/'Calculated Data'!G13","v":0.21745707277187246},{"$f":"'Calculated Data'!H5/'Calculated Data'!H13","v":0.38430003334575624},{"$f":"'Calculated Data'!I5/'Calculated Data'!I13","v":0.51273586334312626},{"$f":"'Calculated Data'!J5/'Calculated Data'!J13","v":0.54092064124032457},{"$f":"'Calculated Data'!K5/'Calculated Data'!K13","v":0.46077924244952445},"Check back the significant role of EBIT/Invested Capital "]
["EPA",{"$f":"'Calculated Data'!B24","v":-14.77522248722866},{"$f":"'Calculated Data'!C24","v":-17.482673108482437},{"$f":"'Calculated Data'!D24","v":-36.334333244886317},{"$f":"'Calculated Data'!E24","v":-17.791703247534105},{"$f":"'Calculated Data'!F24","v":5.9064875910749812},{"$f":"'Calculated Data'!G24","v":28.876847110129482},{"$f":"'Calculated Data'!H24","v":68.638245836053301},{"$f":"'Calculated Data'!I24","v":169.1843163217749},{"$f":"'Calculated Data'!J24","v":220.57123766740054},{"$f":"'Calculated Data'!K24","v":266.57697601127148},"Check back what is really driving EPA (Invested Capital or RoIC, or both)"]
["MktCap",{"$f":"'Calculated Data'!B26","v":69.676407900000001},{"$f":"'Calculated Data'!C26","v":81.96388859999999},{"$f":"'Calculated Data'!D26","v":55.329176100000005},{"$f":"'Calculated Data'!E26","v":186.01683210000002},{"$f":"'Calculated Data'!F26","v":214.28514030000002},{"$f":"'Calculated Data'!G26","v":503.99978639999995},{"$f":"'Calculated Data'!H26","v":1353.1144208999999},{"$f":"'Calculated Data'!I26","v":3505.4850000000001},{"$f":"'Calculated Data'!J26","v":11944.446660000001},{"$f":"'Calculated Data'!K26","v":13045.39730775}]
["MktCap Added",null,{"$f":"C57-$B$57","v":12.287480699999989},-14.347231799999996,116.34042420000002,144.60873240000001,434.32337849999993,1283.438013,3435.8085921000002,11874.770252100001,12975.720899849999]
["Cumulative EPA",null,{"$f":"SUM($B$56:C56)","v":-32.257895595711098},{"$f":"SUM($B$56:D56)","v":-68.592228840597414},{"$f":"SUM($B$56:E56)","v":-86.383932088131516},{"$f":"SUM($B$56:F56)","v":-80.477444497056538},{"$f":"SUM($B$56:G56)","v":-51.600597386927056},{"$f":"SUM($B$56:H56)","v":17.037648449126245},{"$f":"SUM($B$56:I56)","v":186.22196477090114},{"$f":"SUM($B$56:J56)","v":406.79320243830171},{"$f":"SUM($B$56:K56)","v":673.37017844957313}]
["Mcapadded/Cum EPA",null,{"$f":"C58/C59","v":-0.38091389636817136},0.20916701560087453,-1.3467831503815544,-1.7968852428619186,-8.4170222922658482,75.32952782963541,18.450071646096585,29.191171781935186,19.269818170039017]
[]
[]
["Capex/Net Profits 10 yr",{"$f":"SUM('Calculated Data'!B$18:K$18)/SUM('Calculated Data'!B$8:K$8)","v":0.69474711208242279}]
["Capex/Net Profits 7 yr",{"$f":"SUM('Calculated Data'!E$18:K$18)/SUM('Calculated Data'!E$8:K$8)","v":0.61517515153006397}]
["Capex/Net Profits 5 yr",{"$f":"SUM('Calculated Data'!G$18:K$18)/SUM('Calculated Data'!G$8:K$8)","v":0.58769347389204241}]
["Capex/Net Profits 3 yr",{"$f":"SUM('Calculated Data'!I$18:K$18)/SUM('Calculated Data'!I$8:K$8)","v":0.57864889171031053}]
["Capex/Depreciation 10 yr",{"$f":"SUM('Calculated Data'!B$18:K$18)/SUM('Data Sheet'!B26:K26)","v":3.1462655968329161}]

{"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","AJANTA PHARMA 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":8.8005016023408107}]
["Face Value",2]
["Current Price",1794.25]
["Market Capitalization",15790.3]
[]
[]
[]
[]
[]
["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",258.01,309.37,349.34,409.14,504.87,677.4,930.84,1208.3399999999999,1473.56,1727.53]
["Raw Material Cost",146.86000000000001,154.18,133.94999999999999,132.65,178.76,250.67,312.16000000000003,339.5,358.08,463.1]
["Change in Inventory",6.82,14,6.89,-7.13,-4.5999999999999996,20.72,9.5399999999999991,-6.02,-7.34,49.27]
["Power and Fuel",1.84,2.2200000000000002,3.27,4.7699999999999996,6.16,7.83,10.25,11.2,12.91,15.49]
["Other Mfr. Exp",5.54,8.8000000000000007,11.97,10.92,10.11,17.649999999999999,29.25,34.75,55.72,77.89]
["Employee Cost",21.95,30.45,42.67,47.79,70.86,93.84,123.18,156.97,200.58,256.99]
["Selling and admin",43.6,70.72,94.96,118.51,115.29,165.73,207.01,248.78,284.95,313.48]
["Other Expenses",5.36,5.65,4.3499999999999996,8.81,30.39,30.37,34.04,42.37,57.21,69.13]
["Other Income",0.82,1.54,2.5,1.08,10.46,6.22,5.6,13.71,16.8,16.63]
["Depreciation",8.74,7.87,14.2,20.73,24.75,31.87,34.17,43.88,51.64,45.06]
["Interest",12.38,16.14,23.55,20.149999999999999,18.02,15.43,19.13,8.73,5.92,4.8899999999999997]
["Profit before tax",19.38,28.88,29.81,38.76,56.39,90.95,176.79,329.85,456.01,547.4]
["Tax",4.67,6.85,4.38,4.76,5.68,13.69,64.680000000000007,95.97,146.15,145.99]
["Net profit",14.66,21.88,25.43,34,50.71,77.260000000000005,112.11,233.88,309.86,401.41]
["Dividend Amount",2.34,2.93,2.93,4.09,5.85,8.7799999999999994,14.65,35.18,52.82,70.400000000000006]
[]
[]
[]
[]
[]
[]
[]
[]
["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",321.74,371.87,407.85,372.09,391.35,441.7,472.78,425.73,475.9,515.82000000000005]
["Expenses",224.82,243.05,263.08999999999997,247.46,268.83,287.77999999999997,309.3,285.13,309.33,342.6]
["Other Income",4.51,4.41,4.54,4.9800000000000004,7.96,6.16,1.6,4.9800000000000004,5.46,6.66]
["Depreciation",12.55,12.72,13.14,13.23,10.31,10.97,11.73,12.05,13,13.99]
["Interest",1.57,1.48,1.38,1.49,1.17,1.07,1.53,1.1200000000000001,1.01,0.77]
["Profit before tax",87.31,119.03,134.78,114.89,119,148.04,151.82,132.41,158.02000000000001,165.12]
["Tax",27.65,36.03,41.72,40.75,32.99,44.6,40.520000000000003,24.9,38.47,34.46]
["Net profit",59.66,83,93.06,74.14,86.01,103.44,111.3,107.51,119.55,130.66]
["Operating Profit",96.92,128.82,144.76,124.63,122.52,153.91999999999999,163.47999999999999,140.6,166.57,173.22]
[]
[]
[]
[]
["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",11.8,11.8,11.8,11.8,11.8,11.8,11.8,17.670000000000002,17.68,17.690000000000001]
["Reserves",103.59,123.06,145.31,173.13,217.03,286.23,381.63,575.64,823.41,1154.3699999999999]
["Borrowings",116.37,173.54,250.22,227.96,190.63,199.64,124.84,130.49,72.38,92.93]
["Other Liabilities",36.520000000000003,59.06,64.39,89.26,102.7,152.84,200.62,225.67,234.56,222.39]
["Total",268.27999999999997,367.46,471.72,502.15,522.16,650.51,718.89,949.47,1148.03,1487.38]
["Net Block",62,101.8,138.27000000000001,168.46,214.03,246.13,272.56,279.39,288.08999999999997,451.58]
["Capital Work in Progress",13.44,23.88,55.17,46.99,17.22,2.5099999999999998,12.49,93.55,170.2,239.8]
["Investments",8.4700000000000006,8.4700000000000006,8.4700000000000006,8.4700000000000006,8.4600000000000009,8.4700000000000006,8.4600000000000009,63.46,59.5,66.39]
["Other Assets",184.37,233.31,269.81,278.23,282.45,393.4,425.38,513.07000000000005,630.24,729.61]
["Total",268.27999999999997,367.46,471.72,502.15,522.16,650.51,718.89,949.47,1148.03,1487.38]
["Receivables",68.44,86.83,100.12,96.73,103.98,141,150.47,202.22,258.76,372.35]
["Inventory",70.84,92.77,103.89,119.62,113.12,167.8,147.6,155.4,159.03,204.58]
["Cash & Bank",7.45,5.76,8.07,14.84,11.53,11.47,46.23,60.39,136.76,54.96]
["No. of Equity Shares",11861800,11861800,11861800,11861800,11861800,11861800,23723600,35400000,88710000,88767750]
["New Bonus Shares",null,null,null,null,null,null,null,11716900]
["Face value",10,10,10,10,10,10,5,5,2,2]
[]
[]
[]
[]
[]
[]
[]
["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",21.13,19.079999999999998,34.590000000000003,95.11,95.37,70.349999999999994,234.29,212.42,279.42,326.38]
["Cash from Investing Activity",-24.04,-59.14,-81.93,-42.67,-50.71,-53.07,-103.7,-187.79,-158.36000000000001,-209.29]
["Cash from Financing Activity",3.64,38.369999999999997,49.65,-45.67,-55.89,-12.84,-104.49,-20.13,-105.19,-118.57]
["Net Cash Flow",0.73,-1.69,2.31,6.77,-11.23,4.4400000000000004,26.1,4.5,15.87,-1.48]
[]
[]
[]
[]
["PRICE:",9.81,11.54,7.79,26.19,30.17,70.959999999999994,190.51,396.1,1346.46,1469.61]
[]
["DERIVED:"]
["Adjusted Equity Shares in Cr",{"$f":"IF($B7>0,(B70*B72/$B7)+SUM(C71:$K71),0)/10000000","v":7.1025900000000002},{"$f":"IF($B7>0,(C70*C72/$B7)+SUM(D71:$K71),0)/10000000","v":7.1025900000000002},{"$f":"IF($B7>0,(D70*D72/$B7)+SUM(E71:$K71),0)/10000000","v":7.1025900000000002},{"$f":"IF($B7>0,(E70*E72/$B7)+SUM(F71:$K71),0)/10000000","v":7.1025900000000002},{"$f":"IF($B7>0,(F70*F72/$B7)+SUM(G71:$K71),0)/10000000","v":7.1025900000000002},{"$f":"IF($B7>0,(G70*G72/$B7)+SUM(H71:$K71),0)/10000000","v":7.1025900000000002},{"$f":"IF($B7>0,(H70*H72/$B7)+SUM(I71:$K71),0)/10000000","v":7.1025900000000002},{"$f":"IF($B7>0,(I70*I72/$B7)+SUM(J71:$K71),0)/10000000","v":8.85},{"$f":"IF($B7>0,(J70*J72/$B7)+SUM(K71:$K71),0)/10000000","v":8.8710000000000004},{"$f":"IF($B7>0,(K70*K72/$B7),0)/10000000","v":8.8767750000000003}]

{"sheet":"Calculated Data","index":6,"n_rows":58,"n_cols":13,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Data Sheet'!B1","v":"AJANTA PHARMA LTD"}]
[]
[{"$f":"A1","v":"AJANTA PHARMA 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":111.14999999999998},{"$f":"'Data Sheet'!C17-'Data Sheet'!C18","v":155.19},{"$f":"'Data Sheet'!D17-'Data Sheet'!D18","v":215.39},{"$f":"'Data Sheet'!E17-'Data Sheet'!E18","v":276.49},{"$f":"'Data Sheet'!F17-'Data Sheet'!F18","v":326.11},{"$f":"'Data Sheet'!G17-'Data Sheet'!G18","v":426.73},{"$f":"'Data Sheet'!H17-'Data Sheet'!H18","v":618.68000000000006},{"$f":"'Data Sheet'!I17-'Data Sheet'!I18","v":868.83999999999992},{"$f":"'Data Sheet'!J17-'Data Sheet'!J18","v":1115.48},{"$f":"'Data Sheet'!K17-'Data Sheet'!K18","v":1264.4299999999998}]
["EBIT",{"$f":"'Data Sheet'!B28+'Data Sheet'!B27","v":31.759999999999998},{"$f":"'Data Sheet'!C28+'Data Sheet'!C27","v":45.019999999999996},{"$f":"'Data Sheet'!D28+'Data Sheet'!D27","v":53.36},{"$f":"'Data Sheet'!E28+'Data Sheet'!E27","v":58.91},{"$f":"'Data Sheet'!F28+'Data Sheet'!F27","v":74.41},{"$f":"'Data Sheet'!G28+'Data Sheet'!G27","v":106.38},{"$f":"'Data Sheet'!H28+'Data Sheet'!H27","v":195.92},{"$f":"'Data Sheet'!I28+'Data Sheet'!I27","v":338.58000000000004},{"$f":"'Data Sheet'!J28+'Data Sheet'!J27","v":461.93},{"$f":"'Data Sheet'!K28+'Data Sheet'!K27","v":552.29}]
["EBITDA",{"$f":"'Calculated Data'!B5+'Data Sheet'!B26","v":40.5},{"$f":"'Calculated Data'!C5+'Data Sheet'!C26","v":52.889999999999993},{"$f":"'Calculated Data'!D5+'Data Sheet'!D26","v":67.56},{"$f":"'Calculated Data'!E5+'Data Sheet'!E26","v":79.64},{"$f":"'Calculated Data'!F5+'Data Sheet'!F26","v":99.16},{"$f":"'Calculated Data'!G5+'Data Sheet'!G26","v":138.25},{"$f":"'Calculated Data'!H5+'Data Sheet'!H26","v":230.08999999999997},{"$f":"'Calculated Data'!I5+'Data Sheet'!I26","v":382.46000000000004},{"$f":"'Calculated Data'!J5+'Data Sheet'!J26","v":513.57000000000005},{"$f":"'Calculated Data'!K5+'Data Sheet'!K26","v":597.34999999999991}]
["Operating Profit (excl Other Income)",{"$f":"B6-'Data Sheet'!B25","v":39.68},{"$f":"C6-'Data Sheet'!C25","v":51.349999999999994},{"$f":"D6-'Data Sheet'!D25","v":65.06},{"$f":"E6-'Data Sheet'!E25","v":78.56},{"$f":"F6-'Data Sheet'!F25","v":88.699999999999989},{"$f":"G6-'Data Sheet'!G25","v":132.03},{"$f":"H6-'Data Sheet'!H25","v":224.48999999999998},{"$f":"I6-'Data Sheet'!I25","v":368.75000000000006},{"$f":"J6-'Data Sheet'!J25","v":496.77000000000004},{"$f":"K6-'Data Sheet'!K25","v":580.71999999999991}]
["PAT",{"$f":"'Data Sheet'!B30","v":14.66},{"$f":"'Data Sheet'!C30","v":21.88},{"$f":"'Data Sheet'!D30","v":25.43},{"$f":"'Data Sheet'!E30","v":34},{"$f":"'Data Sheet'!F30","v":50.71},{"$f":"'Data Sheet'!G30","v":77.260000000000005},{"$f":"'Data Sheet'!H30","v":112.11},{"$f":"'Data Sheet'!I30","v":233.88},{"$f":"'Data Sheet'!J30","v":309.86},{"$f":"'Data Sheet'!K30","v":401.41}]
["Dividend",{"$f":"'Data Sheet'!B31","v":2.34},{"$f":"'Data Sheet'!C31","v":2.93},{"$f":"'Data Sheet'!D31","v":2.93},{"$f":"'Data Sheet'!E31","v":4.09},{"$f":"'Data Sheet'!F31","v":5.85},{"$f":"'Data Sheet'!G31","v":8.7799999999999994},{"$f":"'Data Sheet'!H31","v":14.65},{"$f":"'Data Sheet'!I31","v":35.18},{"$f":"'Data Sheet'!J31","v":52.82},{"$f":"'Data Sheet'!K31","v":70.400000000000006}]
[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":115.39},{"$f":"'Data Sheet'!C57+'Data Sheet'!C58","v":134.86000000000001},{"$f":"'Data Sheet'!D57+'Data Sheet'!D58","v":157.11000000000001},{"$f":"'Data Sheet'!E57+'Data Sheet'!E58","v":184.93},{"$f":"'Data Sheet'!F57+'Data Sheet'!F58","v":228.83},{"$f":"'Data Sheet'!G57+'Data Sheet'!G58","v":298.03000000000003},{"$f":"'Data Sheet'!H57+'Data Sheet'!H58","v":393.43},{"$f":"'Data Sheet'!I57+'Data Sheet'!I58","v":593.30999999999995},{"$f":"'Data Sheet'!J57+'Data Sheet'!J58","v":841.08999999999992},{"$f":"'Data Sheet'!K57+'Data Sheet'!K58","v":1172.06}]
["Working Capital",{"$f":"'Data Sheet'!B65-'Data Sheet'!B60","v":147.85},{"$f":"'Data Sheet'!C65-'Data Sheet'!C60","v":174.25},{"$f":"'Data Sheet'!D65-'Data Sheet'!D60","v":205.42000000000002},{"$f":"'Data Sheet'!E65-'Data Sheet'!E60","v":188.97000000000003},{"$f":"'Data Sheet'!F65-'Data Sheet'!F60","v":179.75},{"$f":"'Data Sheet'!G65-'Data Sheet'!G60","v":240.55999999999997},{"$f":"'Data Sheet'!H65-'Data Sheet'!H60","v":224.76},{"$f":"'Data Sheet'!I65-'Data Sheet'!I60","v":287.40000000000009},{"$f":"'Data Sheet'!J65-'Data Sheet'!J60","v":395.68},{"$f":"'Data Sheet'!K65-'Data Sheet'!K60","v":507.22}]
["Invested Capital",{"$f":"'Data Sheet'!B62+'Data Sheet'!B63+'Calculated Data'!B12","v":223.29},{"$f":"'Data Sheet'!C62+'Data Sheet'!C63+'Calculated Data'!C12","v":299.93},{"$f":"'Data Sheet'!D62+'Data Sheet'!D63+'Calculated Data'!D12","v":398.86},{"$f":"'Data Sheet'!E62+'Data Sheet'!E63+'Calculated Data'!E12","v":404.42000000000007},{"$f":"'Data Sheet'!F62+'Data Sheet'!F63+'Calculated Data'!F12","v":411},{"$f":"'Data Sheet'!G62+'Data Sheet'!G63+'Calculated Data'!G12","v":489.19999999999993},{"$f":"'Data Sheet'!H62+'Data Sheet'!H63+'Calculated Data'!H12","v":509.81},{"$f":"'Data Sheet'!I62+'Data Sheet'!I63+'Calculated Data'!I12","v":660.34000000000015},{"$f":"'Data Sheet'!J62+'Data Sheet'!J63+'Calculated Data'!J12","v":853.97},{"$f":"'Data Sheet'!K62+'Data Sheet'!K63+'Calculated Data'!K12","v":1198.5999999999999}]
["Capital Employed",{"$f":"B11+'Data Sheet'!B59","v":231.76},{"$f":"C11+'Data Sheet'!C59","v":308.39999999999998},{"$f":"D11+'Data Sheet'!D59","v":407.33000000000004},{"$f":"E11+'Data Sheet'!E59","v":412.89},{"$f":"F11+'Data Sheet'!F59","v":419.46000000000004},{"$f":"G11+'Data Sheet'!G59","v":497.67},{"$f":"H11+'Data Sheet'!H59","v":518.27},{"$f":"I11+'Data Sheet'!I59","v":723.8},{"$f":"J11+'Data Sheet'!J59","v":913.46999999999991},{"$f":"K11+'Data Sheet'!K59","v":1264.99}]
["Total Assets",{"$f":"'Data Sheet'!B61","v":268.27999999999997},{"$f":"'Data Sheet'!C61","v":367.46},{"$f":"'Data Sheet'!D61","v":471.72},{"$f":"'Data Sheet'!E61","v":502.15},{"$f":"'Data Sheet'!F61","v":522.16},{"$f":"'Data Sheet'!G61","v":650.51},{"$f":"'Data Sheet'!H61","v":718.89},{"$f":"'Data Sheet'!I61","v":949.47},{"$f":"'Data Sheet'!J61","v":1148.03},{"$f":"'Data Sheet'!K61","v":1487.38}]
[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":21.13},{"$f":"'Data Sheet'!C82","v":19.079999999999998},{"$f":"'Data Sheet'!D82","v":34.590000000000003},{"$f":"'Data Sheet'!E82","v":95.11},{"$f":"'Data Sheet'!F82","v":95.37},{"$f":"'Data Sheet'!G82","v":70.349999999999994},{"$f":"'Data Sheet'!H82","v":234.29},{"$f":"'Data Sheet'!I82","v":212.42},{"$f":"'Data Sheet'!J82","v":279.42},{"$f":"'Data Sheet'!K82","v":326.38}]
["Capex",null,{"$f":"('Data Sheet'!C62-'Data Sheet'!B62)+('Data Sheet'!C63-'Data Sheet'!B63)+'Data Sheet'!C26","v":58.109999999999992},{"$f":"('Data Sheet'!D62-'Data Sheet'!C62)+('Data Sheet'!D63-'Data Sheet'!C63)+'Data Sheet'!D26","v":81.960000000000022},{"$f":"('Data Sheet'!E62-'Data Sheet'!D62)+('Data Sheet'!E63-'Data Sheet'!D63)+'Data Sheet'!E26","v":42.739999999999995},{"$f":"('Data Sheet'!F62-'Data Sheet'!E62)+('Data Sheet'!F63-'Data Sheet'!E63)+'Data Sheet'!F26","v":40.54999999999999},{"$f":"('Data Sheet'!G62-'Data Sheet'!F62)+('Data Sheet'!G63-'Data Sheet'!F63)+'Data Sheet'!G26","v":49.259999999999991},{"$f":"('Data Sheet'!H62-'Data Sheet'!G62)+('Data Sheet'!H63-'Data Sheet'!G63)+'Data Sheet'!H26","v":70.580000000000013},{"$f":"('Data Sheet'!I62-'Data Sheet'!H62)+('Data Sheet'!I63-'Data Sheet'!H63)+'Data Sheet'!I26","v":131.76999999999998},{"$f":"('Data Sheet'!J62-'Data Sheet'!I62)+('Data Sheet'!J63-'Data Sheet'!I63)+'Data Sheet'!J26","v":136.98999999999998},{"$f":"('Data Sheet'!K62-'Data Sheet'!J62)+('Data Sheet'!K63-'Data Sheet'!J63)+'Data Sheet'!K26","v":278.15000000000003},"CHECK?","derived from BS"]
["Free Cash Flow",null,{"$f":"C17-C18","v":-39.029999999999994},{"$f":"D17-D18","v":-47.370000000000019},52.370000000000005,54.820000000000014,21.090000000000003,163.70999999999998,80.650000000000006,142.43000000000004,48.229999999999961]
["Tax Rate",{"$f":"'Data Sheet'!B29/'Data Sheet'!B28","v":0.2409700722394221},{"$f":"'Data Sheet'!C29/'Data Sheet'!C28","v":0.23718836565096951},{"$f":"'Data Sheet'!D29/'Data Sheet'!D28","v":0.14693056021469306},{"$f":"'Data Sheet'!E29/'Data Sheet'!E28","v":0.12280701754385966},{"$f":"'Data Sheet'!F29/'Data Sheet'!F28","v":0.10072707926937399},{"$f":"'Data Sheet'!G29/'Data Sheet'!G28","v":0.15052226498075866},{"$f":"'Data Sheet'!H29/'Data Sheet'!H28","v":0.36585779738673008},{"$f":"'Data Sheet'!I29/'Data Sheet'!I28","v":0.29095043201455206},{"$f":"'Data Sheet'!J29/'Data Sheet'!J28","v":0.32049735751408964},{"$f":"'Data Sheet'!K29/'Data Sheet'!K28","v":0.26669711362805992}]
["NOPLAT",{"$f":"B5*(1-B20)","v":24.106790505675953},34.341779778393352,45.519785306943973,51.675438596491219,66.914898031565883,90.367441451346878,124.24114033599183,240.070002728513,313.88265564351656,404.99585111435874]
["RoIC",{"$f":"(B5/B13)*(1-B20)","v":0.10796180082258924},{"$f":"(C5/C13)*(1-C20)","v":0.11449931576832377},0.11412471871569968,0.12777666435015878,0.16280997087972232,0.18472494164216455,0.24370086961023094,0.36355514239408937,0.36755700509797362,0.33789074846851225]
["WACC",{"$f":"(B50*B54)+(B51*B55)+(B52*B56)","v":0.17413235251423984},0.1727884936047604,0.20522017387511982,0.17176979833842371,0.14843895484304354,0.12569622718973306,0.10906591573319185,0.10734725506063256,0.10926779392263894,0.11548379367853101]
["EPA (Economic Profit Added)",{"$f":"B13*(B22-B23)","v":-14.77522248722866},{"$f":"C13*(C22-C23)","v":-17.482673108482437},-36.334333244886317,-17.791703247534105,5.9064875910749812,28.876847110129482,68.638245836053301,169.1843163217749,220.57123766740054,266.57697601127148]
[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":69.676407900000001},{"$f":"'Data Sheet'!C90*'Data Sheet'!C93","v":81.96388859999999},{"$f":"'Data Sheet'!D90*'Data Sheet'!D93","v":55.329176100000005},{"$f":"'Data Sheet'!E90*'Data Sheet'!E93","v":186.01683210000002},{"$f":"'Data Sheet'!F90*'Data Sheet'!F93","v":214.28514030000002},{"$f":"'Data Sheet'!G90*'Data Sheet'!G93","v":503.99978639999995},{"$f":"'Data Sheet'!H90*'Data Sheet'!H93","v":1353.1144208999999},{"$f":"'Data Sheet'!I90*'Data Sheet'!I93","v":3505.4850000000001},{"$f":"'Data Sheet'!J90*'Data Sheet'!J93","v":11944.446660000001},{"$f":"'Data Sheet'!K90*'Data Sheet'!K93","v":13045.39730775},{"$f":"'Data Sheet'!B9","v":15790.3}]
["MktCap+Dividend",{"$f":"B26+'Data Sheet'!B31","v":72.016407900000004},{"$f":"C26+'Data Sheet'!C31","v":84.893888599999997},{"$f":"D26+'Data Sheet'!D31","v":58.259176100000005},{"$f":"E26+'Data Sheet'!E31","v":190.10683210000002},{"$f":"F26+'Data Sheet'!F31","v":220.13514030000002},{"$f":"G26+'Data Sheet'!G31","v":512.77978639999992},{"$f":"H26+'Data Sheet'!H31","v":1367.7644209},{"$f":"I26+'Data Sheet'!I31","v":3540.665},{"$f":"J26+'Data Sheet'!J31","v":11997.266660000001},{"$f":"K26+'Data Sheet'!K31","v":13115.797307749999}]
["Retained Profit",{"$f":"'Data Sheet'!B30-'Data Sheet'!B31","v":12.32},{"$f":"'Data Sheet'!C30-'Data Sheet'!C31","v":18.95},{"$f":"'Data Sheet'!D30-'Data Sheet'!D31","v":22.5},{"$f":"'Data Sheet'!E30-'Data Sheet'!E31","v":29.91},{"$f":"'Data Sheet'!F30-'Data Sheet'!F31","v":44.86},{"$f":"'Data Sheet'!G30-'Data Sheet'!G31","v":68.48},{"$f":"'Data Sheet'!H30-'Data Sheet'!H31","v":97.46},{"$f":"'Data Sheet'!I30-'Data Sheet'!I31","v":198.7},{"$f":"'Data Sheet'!J30-'Data Sheet'!J31","v":257.04000000000002},{"$f":"'Data Sheet'!K30-'Data Sheet'!K31","v":331.01}]
["EV",{"$f":"B26+'Data Sheet'!B59-'Data Sheet'!B69","v":178.59640790000003},{"$f":"C26+'Data Sheet'!C59-'Data Sheet'!C69","v":249.74388859999999},{"$f":"D26+'Data Sheet'!D59-'Data Sheet'!D69","v":297.47917610000002},{"$f":"E26+'Data Sheet'!E59-'Data Sheet'!E69","v":399.13683210000005},{"$f":"F26+'Data Sheet'!F59-'Data Sheet'!F69","v":393.38514030000005},{"$f":"G26+'Data Sheet'!G59-'Data Sheet'!G69","v":692.16978639999991},{"$f":"H26+'Data Sheet'!H59-'Data Sheet'!H69","v":1431.7244208999998},{"$f":"I26+'Data Sheet'!I59-'Data Sheet'!I69","v":3575.5850000000005},{"$f":"J26+'Data Sheet'!J59-'Data Sheet'!J69","v":11880.06666},{"$f":"K26+'Data Sheet'!K59-'Data Sheet'!K69","v":13083.367307750001}]
[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":4.7528245497953616},{"$f":"C26/'Data Sheet'!C30","v":3.7460643784277878},{"$f":"D26/'Data Sheet'!D30","v":2.1757442430200551},{"$f":"E26/'Data Sheet'!E30","v":5.4710832970588239},{"$f":"F26/'Data Sheet'!F30","v":4.2256978958785254},{"$f":"G26/'Data Sheet'!G30","v":6.5234246233497268},{"$f":"H26/'Data Sheet'!H30","v":12.069524760503077},{"$f":"I26/'Data Sheet'!I30","v":14.9883914828117},{"$f":"J26/'Data Sheet'!J30","v":38.547881817595048},{"$f":"K26/'Data Sheet'!K30","v":32.498934525173759}]
["Price/Book",{"$f":"B26/B11","v":0.60383402287893229},0.60777019575856428,0.35216839220928015,1.0058769918347483,0.93643814316304685,1.6911042056168839,3.43927616323107,5.9083531374829352,14.201151672234841,11.130315263510401]
["Price/CashFlow",{"$f":"B26/B17","v":3.2975110222432562},4.2958012893081756,1.5995714397224632,1.9558072978656293,2.2468820415224915,7.1641760682302769,5.7753827346450981,16.502612748328783,42.747286021043593,39.969965401525826]
["Price/Sales",{"$f":"B26/'Data Sheet'!B17","v":0.27005312933607228},{"$f":"C26/'Data Sheet'!C17","v":0.26493806316061669},{"$f":"D26/'Data Sheet'!D17","v":0.15838202353008532},{"$f":"E26/'Data Sheet'!E17","v":0.4546532534095909},{"$f":"F26/'Data Sheet'!F17","v":0.42443627131736889},{"$f":"G26/'Data Sheet'!G17","v":0.7440209424269264},{"$f":"H26/'Data Sheet'!H17","v":1.4536487698208069},{"$f":"I26/'Data Sheet'!I17","v":2.901075028551567},{"$f":"J26/'Data Sheet'!J17","v":8.1058434403756898},{"$f":"K26/'Data Sheet'!K17","v":7.5514736691982192}]
["EV/EBITDA",{"$f":"B29/B6","v":4.4097878493827167},4.721949113253924,4.4031849629958559,5.0117633362631846,3.9671756787010897,5.0066530661844482,6.2224539132513366,9.3489123045547249,23.1323220982534,21.902347547919984]
["Dividend Yield",{"$f":"'Data Sheet'!B31/'Calculated Data'!B26","v":3.3583820844472666E-2},{"$f":"'Data Sheet'!C31/'Calculated Data'!C26","v":3.5747449883679637E-2},{"$f":"'Data Sheet'!D31/'Calculated Data'!D26","v":5.2955785835386765E-2},{"$f":"'Data Sheet'!E31/'Calculated Data'!E26","v":2.1987257571407699E-2},{"$f":"'Data Sheet'!F31/'Calculated Data'!F26","v":2.730007312597587E-2},{"$f":"'Data Sheet'!G31/'Calculated Data'!G26","v":1.7420642303669041E-2},{"$f":"'Data Sheet'!H31/'Calculated Data'!H26","v":1.0826874485792424E-2},{"$f":"'Data Sheet'!I31/'Calculated Data'!I26","v":1.0035701193985995E-2},{"$f":"'Data Sheet'!J31/'Calculated Data'!J26","v":4.4221387146284093E-3},{"$f":"'Data Sheet'!K31/'Calculated Data'!K26","v":5.3965393570785938E-3}]
[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.55110332488444913},0.47420127360801179,0.43547019418298993,0.37632181619038141,0.34424314386394977,0.36980215523204868,0.31264866669448732,0.30269518784163807,0.34465998275306398,0.34101574580806521,1.2]
["Retained Profits/Total Assets",{"$f":"B28/B15","v":4.5922170866259139E-2},5.1570238937571435E-2,4.7697786822691421E-2,5.9563875336054964E-2,8.5912364026352078E-2,0.10527124871254863,0.13557011503846206,0.20927464796149428,0.22389658806825607,0.22254568435772967,1.4]
["EBIT/Total Assets",{"$f":"B5/B15","v":0.11838377814223945},0.1225167365155391,0.11311795132705842,0.1173155431643931,0.14250421326796384,0.16353322777513027,0.27253126347563605,0.35659894467439734,0.40236753394946129,0.37131734997109006,3.3]
["Market Cap/Total Liabilities",{"$f":"B26/B15","v":0.25971525234829285},{"$f":"C26/C15","v":0.22305526751211013},0.11729241096413127,0.37044076889375688,0.41038214397885714,0.77477638529768944,1.8822273517506154,3.6920439824323044,10.404298371993765,8.7707225508948614,0.6]
["Sales/Total Assets",{"$f":"'Data Sheet'!B17/'Calculated Data'!B15","v":0.96171909944833767},{"$f":"'Data Sheet'!C17/'Calculated Data'!C15","v":0.84191476623305939},{"$f":"'Data Sheet'!D17/'Calculated Data'!D15","v":0.7405664377172898},{"$f":"'Data Sheet'!E17/'Calculated Data'!E15","v":0.81477646121676794},{"$f":"'Data Sheet'!F17/'Calculated Data'!F15","v":0.96688754404780153},{"$f":"'Data Sheet'!G17/'Calculated Data'!G15","v":1.0413367972821324},{"$f":"'Data Sheet'!H17/'Calculated Data'!H15","v":1.294829528856988},{"$f":"'Data Sheet'!I17/'Calculated Data'!I15","v":1.272646845081993},{"$f":"'Data Sheet'!J17/'Calculated Data'!J15","v":1.2835553077881239},{"$f":"'Data Sheet'!K17/'Calculated Data'!K15","v":1.1614584033669941},1]
["Altman Z-Score",{"$f":"$L$38*B38+$L$39*B39+$L$40*B40+$L$41*B41+$L$42*B42","v":2.2338297478008053},{"$f":"$L$38*C38+$L$39*C39+$L$40*C40+$L$41*C41+$L$42*C42","v":2.0212930200838186},1.7735722582464171,1.9591578198944539,2.2167498164930288,2.6370046145947024,3.8884956704641875,5.3208684845229444,9.5809943956168393,8.3700220418790074]
["Z > 2.99 -“Safe” Zones"]
["1.81 < Z < 2.99 -“Grey” Zones"]
["Z < 1.81 -“Distress” Zones"]
[]
["Risk Free rate",8,8,8,8,8,8,8,8,8,8]
["Risk Premium",{"$f":"((5/(Customization!B24))^2)+((5/B43)^2)","v":8.8085962607498285},{"$f":"((5/(Customization!C24))^2)+((5/C43)^2)","v":9.33220177308967},{"$f":"((5/(Customization!D24))^2)+((5/D43)^2)","v":12.817279326536777},{"$f":"((5/(Customization!E24))^2)+((5/E43)^2)","v":9.4382082548774626},{"$f":"((5/(Customization!F24))^2)+((5/F43)^2)","v":6.5537049795777929},{"$f":"((5/(Customization!G24))^2)+((5/G43)^2)","v":4.1211190470241919},{"$f":"((5/(Customization!H24))^2)+((5/H43)^2)","v":1.8917440579556315},{"$f":"((5/(Customization!I24))^2)+((5/I43)^2)","v":0.89964955444075523},{"$f":"((5/(Customization!J24))^2)+((5/J43)^2)","v":0.2764507573224419},{"$f":"((5/(Customization!K24))^2)+((5/K43)^2)","v":0.35881075972425014}]
["E",{"$f":"(B48+B49+5)/100","v":0.2180859626074983},0.22332201773089672,0.25817279326536779,0.22438208254877462,0.19553704979577793,0.17121119047024191,0.1489174405795563,0.13899649554440754,0.13276450757322442,0.13358810759724249]
["D",{"$f":"(B48+B49)/100","v":0.16808596260749831},0.17332201773089673,0.20817279326536778,0.17438208254877463,0.14553704979577792,0.12121119047024191,9.8917440579556301E-2,8.8996495544407542E-2,8.2764507573224413E-2,8.35881075972425E-2]
["F",{"$f":"B50/4","v":5.4521490651874574E-2},5.5830504432724179E-2,6.4543198316341949E-2,5.6095520637193655E-2,4.8884262448944484E-2,4.2802797617560479E-2,3.7229360144889076E-2,3.4749123886101886E-2,3.3191126893306104E-2,3.3397026899310622E-2]
[]
["E",{"$f":"SUM('Data Sheet'!B57:B58)/'Data Sheet'!B61","v":0.43011033248844494},{"$f":"SUM('Data Sheet'!C57:C58)/'Data Sheet'!C61","v":0.36700593261851638},{"$f":"SUM('Data Sheet'!D57:D58)/'Data Sheet'!D61","v":0.33305774612058003},{"$f":"SUM('Data Sheet'!E57:E58)/'Data Sheet'!E61","v":0.36827641143084738},{"$f":"SUM('Data Sheet'!F57:F58)/'Data Sheet'!F61","v":0.43823732189367248},{"$f":"SUM('Data Sheet'!G57:G58)/'Data Sheet'!G61","v":0.45814822216414819},{"$f":"SUM('Data Sheet'!H57:H58)/'Data Sheet'!H61","v":0.547274270055224},{"$f":"SUM('Data Sheet'!I57:I58)/'Data Sheet'!I61","v":0.62488546241587406},{"$f":"SUM('Data Sheet'!J57:J58)/'Data Sheet'!J61","v":0.73263764884192917},{"$f":"SUM('Data Sheet'!K57:K58)/'Data Sheet'!K61","v":0.78800306579354296}]
["D",{"$f":"'Data Sheet'!B59/'Data Sheet'!B61","v":0.43376323244371556},{"$f":"'Data Sheet'!C59/'Data Sheet'!C61","v":0.47226909051325316},{"$f":"'Data Sheet'!D59/'Data Sheet'!D61","v":0.53044178750105997},{"$f":"'Data Sheet'!E59/'Data Sheet'!E61","v":0.45396793786717121},{"$f":"'Data Sheet'!F59/'Data Sheet'!F61","v":0.36507966906695266},{"$f":"'Data Sheet'!G59/'Data Sheet'!G61","v":0.30689766490907133},{"$f":"'Data Sheet'!H59/'Data Sheet'!H61","v":0.17365660949519399},{"$f":"'Data Sheet'!I59/'Data Sheet'!I61","v":0.13743456875941315},{"$f":"'Data Sheet'!J59/'Data Sheet'!J61","v":6.3047132914645088E-2},{"$f":"'Data Sheet'!K59/'Data Sheet'!K61","v":6.2478989901706354E-2}]
["F",{"$f":"'Data Sheet'!B60/'Data Sheet'!B61","v":0.13612643506783959},{"$f":"'Data Sheet'!C60/'Data Sheet'!C61","v":0.16072497686823056},{"$f":"'Data Sheet'!D60/'Data Sheet'!D61","v":0.13650046637836002},{"$f":"'Data Sheet'!E60/'Data Sheet'!E61","v":0.17775565070198149},{"$f":"'Data Sheet'!F60/'Data Sheet'!F61","v":0.19668300903937491},{"$f":"'Data Sheet'!G60/'Data Sheet'!G61","v":0.23495411292678053},{"$f":"'Data Sheet'!H60/'Data Sheet'!H61","v":0.27906912044958199},{"$f":"'Data Sheet'!I60/'Data Sheet'!I61","v":0.23767996882471271},{"$f":"'Data Sheet'!J60/'Data Sheet'!J61","v":0.20431521824342569},{"$f":"'Data Sheet'!K60/'Data Sheet'!K61","v":0.14951794430475063}]
[]
["PE",{"$f":"(1/B50*B54)+(1/B51*B55)+(1/B52*B56)","v":7.0495572686581767},7.2470028237849302,5.9530114904820444,7.4133890922427357,8.7731405476348598,10.697072969411348,12.926531060922807,12.879845435670536,12.435807970862999,11.123197962985095]

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