{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Profit & Loss","Quarters","Balance Sheet","Cash Flow","Customization","Data Sheet","Calculated Data","Cost Analysis","Price Implied Expectations","Business Robustness","Buffet-Valuation"],"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":31,"n_cols":14,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Data Sheet'!B1","v":"AVANTI FEEDS LTD"},null,null,null,null,null,null,{"$f":"UPDATE","v":""},null,null,null,null,"SCREENER.IN"]
[]
["Narration",{"$f":"'Data Sheet'!B16","v":"2008-03-31"},{"$f":"'Data Sheet'!C16","v":"2009-03-31"},{"$f":"'Data Sheet'!D16","v":"2010-03-31"},{"$f":"'Data Sheet'!E16","v":"2011-03-31"},{"$f":"'Data Sheet'!F16","v":"2012-03-31"},{"$f":"'Data Sheet'!G16","v":"2013-03-31"},{"$f":"'Data Sheet'!H16","v":"2014-03-31"},{"$f":"'Data Sheet'!I16","v":"2015-03-31"},{"$f":"'Data Sheet'!J16","v":"2016-03-31"},{"$f":"'Data Sheet'!K16","v":"2017-03-31"},"Trailing","Best Case","Worst Case"]
["Sales",{"$f":"'Data Sheet'!B17","v":98.01},{"$f":"'Data Sheet'!C17","v":69.31},{"$f":"'Data Sheet'!D17","v":91.54},{"$f":"'Data Sheet'!E17","v":207.75},{"$f":"'Data Sheet'!F17","v":393.41},{"$f":"'Data Sheet'!G17","v":648.04},{"$f":"'Data Sheet'!H17","v":1131.6099999999999},{"$f":"'Data Sheet'!I17","v":1780.66},{"$f":"'Data Sheet'!J17","v":2018.29},{"$f":"'Data Sheet'!K17","v":2732.66},{"$f":"SUM(Quarters!H4:K4)","v":2974.29},{"$f":"$K4+M27*K4","v":3699.8799357872253},{"$f":"$K4+N27*L4","v":3748.7377204385512}]
["Expenses",{"$f":"SUM('Data Sheet'!B18,'Data Sheet'!B20:B24, -1*'Data Sheet'!B19)","v":96.57},{"$f":"SUM('Data Sheet'!C18,'Data Sheet'!C20:C24, -1*'Data Sheet'!C19)","v":73.080000000000013},{"$f":"SUM('Data Sheet'!D18,'Data Sheet'!D20:D24, -1*'Data Sheet'!D19)","v":98.610000000000028},{"$f":"SUM('Data Sheet'!E18,'Data Sheet'!E20:E24, -1*'Data Sheet'!E19)","v":199.97000000000003},{"$f":"SUM('Data Sheet'!F18,'Data Sheet'!F20:F24, -1*'Data Sheet'!F19)","v":348.68000000000006},{"$f":"SUM('Data Sheet'!G18,'Data Sheet'!G20:G24, -1*'Data Sheet'!G19)","v":597.57999999999993},{"$f":"SUM('Data Sheet'!H18,'Data Sheet'!H20:H24, -1*'Data Sheet'!H19)","v":1020.18},{"$f":"SUM('Data Sheet'!I18,'Data Sheet'!I20:I24, -1*'Data Sheet'!I19)","v":1598.37},{"$f":"SUM('Data Sheet'!J18,'Data Sheet'!J20:J24, -1*'Data Sheet'!J19)","v":1787.99},{"$f":"SUM('Data Sheet'!K18,'Data Sheet'!K20:K24, -1*'Data Sheet'!K19)","v":2400.7999999999997},{"$f":"SUM(Quarters!H5:K5)","v":2495.9000000000005},{"$f":"M4-M6","v":3104.7847828326544},3356.2215890414136]
["Operating Profit",{"$f":"B4-B5","v":1.4400000000000119},{"$f":"C4-C5","v":-3.7700000000000102},-7.0700000000000216,7.7799999999999727,44.729999999999961,50.460000000000036,111.42999999999995,182.29000000000019,230.29999999999995,331.86000000000013,{"$f":"SUM(Quarters!H6:K6)","v":478.39},{"$f":"M4*M28","v":595.09515295457095},{"$f":"N4*N28","v":392.51613139713731}]
["Other Income",{"$f":"'Data Sheet'!B25","v":8.76},{"$f":"'Data Sheet'!C25","v":4.2699999999999996},{"$f":"'Data Sheet'!D25","v":10.69},{"$f":"'Data Sheet'!E25","v":4.1399999999999997},{"$f":"'Data Sheet'!F25","v":3.35},{"$f":"'Data Sheet'!G25","v":2.58},{"$f":"'Data Sheet'!H25","v":3.68},{"$f":"'Data Sheet'!I25","v":9.02},{"$f":"'Data Sheet'!J25","v":21.49},{"$f":"'Data Sheet'!K25","v":21.87},{"$f":"SUM(Quarters!H7:K7)","v":24.759999999999998},0,0]
["Depreciation",{"$f":"'Data Sheet'!B26","v":3.88},{"$f":"'Data Sheet'!C26","v":3.34},{"$f":"'Data Sheet'!D26","v":2.78},{"$f":"'Data Sheet'!E26","v":2.9},{"$f":"'Data Sheet'!F26","v":4},{"$f":"'Data Sheet'!G26","v":4.9800000000000004},{"$f":"'Data Sheet'!H26","v":5.54},{"$f":"'Data Sheet'!I26","v":8.8000000000000007},{"$f":"'Data Sheet'!J26","v":10.23},{"$f":"'Data Sheet'!K26","v":13.69},{"$f":"SUM(Quarters!H8:K8)","v":15.05},{"$f":"+$L8","v":15.05},{"$f":"+$L8","v":15.05}]
["Interest",{"$f":"'Data Sheet'!B27","v":5},{"$f":"'Data Sheet'!C27","v":7.09},{"$f":"'Data Sheet'!D27","v":3.13},{"$f":"'Data Sheet'!E27","v":4.5999999999999996},{"$f":"'Data Sheet'!F27","v":4.07},{"$f":"'Data Sheet'!G27","v":3.92},{"$f":"'Data Sheet'!H27","v":4.3899999999999997},{"$f":"'Data Sheet'!I27","v":2.67},{"$f":"'Data Sheet'!J27","v":3.38},{"$f":"'Data Sheet'!K27","v":4.8499999999999996},{"$f":"SUM(Quarters!H9:K9)","v":3.2600000000000002},{"$f":"+$L9","v":3.2600000000000002},{"$f":"+$L9","v":3.2600000000000002}]
["Profit before tax",{"$f":"'Data Sheet'!B28","v":1.32},{"$f":"'Data Sheet'!C28","v":-9.93},{"$f":"'Data Sheet'!D28","v":-2.29},{"$f":"'Data Sheet'!E28","v":5.29},{"$f":"'Data Sheet'!F28","v":40.01},{"$f":"'Data Sheet'!G28","v":44.14},{"$f":"'Data Sheet'!H28","v":105.17},{"$f":"'Data Sheet'!I28","v":179.84},{"$f":"'Data Sheet'!J28","v":238.18},{"$f":"'Data Sheet'!K28","v":335.18},{"$f":"SUM(Quarters!H10:K10)","v":484.82000000000005},{"$f":"M6+M7-SUM(M8:M9)","v":576.785152954571},{"$f":"N6+N7-SUM(N8:N9)","v":374.20613139713731}]
["Tax",{"$f":"'Data Sheet'!B29","v":0.43},{"$f":"'Data Sheet'!C29","v":-2.93},{"$f":"'Data Sheet'!D29","v":-1.08},{"$f":"'Data Sheet'!E29","v":1.76},{"$f":"'Data Sheet'!F29","v":11.96},{"$f":"'Data Sheet'!G29","v":13.96},{"$f":"'Data Sheet'!H29","v":35.42},{"$f":"'Data Sheet'!I29","v":63.27},{"$f":"'Data Sheet'!J29","v":79.2},{"$f":"'Data Sheet'!K29","v":108.43},{"$f":"SUM(Quarters!H11:K11)","v":159.69},{"$f":"IF($L10>0,$L11/$L10,0)","v":0.32937997607359426},{"$f":"IF($L10>0,$L11/$L10,0)","v":0.32937997607359426}]
["Net profit",{"$f":"'Data Sheet'!B30","v":0.89},{"$f":"'Data Sheet'!C30","v":-7},{"$f":"'Data Sheet'!D30","v":-1.21},{"$f":"'Data Sheet'!E30","v":3.4},{"$f":"'Data Sheet'!F30","v":28.05},{"$f":"'Data Sheet'!G30","v":30.05},{"$f":"'Data Sheet'!H30","v":70.41},{"$f":"'Data Sheet'!I30","v":115.92},{"$f":"'Data Sheet'!J30","v":157.5},{"$f":"'Data Sheet'!K30","v":214.35},{"$f":"SUM(Quarters!H12:K12)","v":311.16999999999996},{"$f":"M10-M11*M10","v":386.80367307479003},{"$f":"N10-N11*N10","v":250.95012479095595}]
["EPS",{"$f":"IF('Data Sheet'!B93>0,B12/'Data Sheet'!B93,0)","v":0.27217125382262997},{"$f":"IF('Data Sheet'!C93>0,C12/'Data Sheet'!C93,0)","v":-1.75},{"$f":"IF('Data Sheet'!D93>0,D12/'Data Sheet'!D93,0)","v":-0.30249999999999999},{"$f":"IF('Data Sheet'!E93>0,E12/'Data Sheet'!E93,0)","v":0.85},{"$f":"IF('Data Sheet'!F93>0,F12/'Data Sheet'!F93,0)","v":7.0125000000000002},{"$f":"IF('Data Sheet'!G93>0,G12/'Data Sheet'!G93,0)","v":6.6167259823305891},{"$f":"IF('Data Sheet'!H93>0,H12/'Data Sheet'!H93,0)","v":15.503616519663785},{"$f":"IF('Data Sheet'!I93>0,I12/'Data Sheet'!I93,0)","v":25.524488381755802},{"$f":"IF('Data Sheet'!J93>0,J12/'Data Sheet'!J93,0)","v":34.680011388255167},{"$f":"IF('Data Sheet'!K93>0,K12/'Data Sheet'!K93,0)","v":47.197844070301549},{"$f":"IF('Data Sheet'!$B6>0,'Profit & Loss'!L12/'Data Sheet'!$B6,0)","v":68.516679208291066},{"$f":"IF('Data Sheet'!$B6>0,'Profit & Loss'!M12/'Data Sheet'!$B6,0)","v":85.170495821107693},{"$f":"IF('Data Sheet'!$B6>0,'Profit & Loss'!N12/'Data Sheet'!$B6,0)","v":55.256834519981169}]
["Price to earning",{"$f":"IF(B15>0,B15/B13,\"\")","v":23.147191011235954},{"$f":"IF(C15>0,C15/C13,\"\")","v":-1.8742857142857141},-16.06611570247934,9.3176470588235301,2.8634581105169339,3.161684503161398,7.6840135879846621,12.861766123964806,12.538346517015873,18.064596313552606,{"$f":"IF(L13>0,L15/L13,0)","v":28.357328791335927},{"$f":"M29","v":28.357328791335927},{"$f":"N29","v":11.856105125794468}]
["Price",{"$f":"'Data Sheet'!B90","v":6.3},{"$f":"'Data Sheet'!C90","v":3.28},{"$f":"'Data Sheet'!D90","v":4.8600000000000003},{"$f":"'Data Sheet'!E90","v":7.92},{"$f":"'Data Sheet'!F90","v":20.079999999999998},{"$f":"'Data Sheet'!G90","v":20.92},{"$f":"'Data Sheet'!H90","v":119.13},{"$f":"'Data Sheet'!I90","v":328.29},{"$f":"'Data Sheet'!J90","v":434.83},{"$f":"'Data Sheet'!K90","v":852.61},{"$f":"'Data Sheet'!B8","v":1942.95},{"$f":"M13*M14","v":2415.2077533202532},{"$f":"N13*N14","v":655.13083898752541}]
[]
["EBIT",{"$f":"B10+B9","v":6.32},{"$f":"C10+C9","v":-2.84},0.83999999999999986,9.89,44.08,48.06,109.56,182.51,241.56,340.03000000000003,488.08000000000004]
["EBITDA",{"$f":"B17+B8","v":10.199999999999999},{"$f":"C17+C8","v":0.5},3.6199999999999997,12.790000000000001,48.08,53.040000000000006,115.10000000000001,191.31,251.79,353.72,503.13000000000005]
["Operating Profit (excl Other Income)",{"$f":"B18-B7","v":1.4399999999999995},{"$f":"C18-C7","v":-3.7699999999999996},-7.07,8.6500000000000021,44.73,50.460000000000008,111.42,182.29,230.29999999999998,331.85,478.37000000000006]
[]
["RATIOS:"]
["DPS",{"$f":"IF('Data Sheet'!B93>0,'Data Sheet'!B31/'Data Sheet'!B93,0)","v":0.19877675840978593},{"$f":"IF('Data Sheet'!C93>0,'Data Sheet'!C31/'Data Sheet'!C93,0)","v":0},{"$f":"IF('Data Sheet'!D93>0,'Data Sheet'!D31/'Data Sheet'!D93,0)","v":0},{"$f":"IF('Data Sheet'!E93>0,'Data Sheet'!E31/'Data Sheet'!E93,0)","v":0.2},{"$f":"IF('Data Sheet'!F93>0,'Data Sheet'!F31/'Data Sheet'!F93,0)","v":1.4750000000000001},{"$f":"IF('Data Sheet'!G93>0,'Data Sheet'!G31/'Data Sheet'!G93,0)","v":1.2991242361314634},{"$f":"IF('Data Sheet'!H93>0,'Data Sheet'!H31/'Data Sheet'!H93,0)","v":2.9989952705272085},{"$f":"IF('Data Sheet'!I93>0,'Data Sheet'!I31/'Data Sheet'!I93,0)","v":5.5003599014515174},{"$f":"IF('Data Sheet'!J93>0,'Data Sheet'!J31/'Data Sheet'!J93,0)","v":5.5003599014515174},{"$f":"IF('Data Sheet'!K93>0,'Data Sheet'!K31/'Data Sheet'!K93,0)","v":6.9998575367151217}]
["Dividend Payout",{"$f":"IF('Data Sheet'!B30>0, 'Data Sheet'!B31/'Data Sheet'!B30, 0)","v":0.7303370786516854},{"$f":"IF('Data Sheet'!C30>0, 'Data Sheet'!C31/'Data Sheet'!C30, 0)","v":0},{"$f":"IF('Data Sheet'!D30>0, 'Data Sheet'!D31/'Data Sheet'!D30, 0)","v":0},{"$f":"IF('Data Sheet'!E30>0, 'Data Sheet'!E31/'Data Sheet'!E30, 0)","v":0.23529411764705885},{"$f":"IF('Data Sheet'!F30>0, 'Data Sheet'!F31/'Data Sheet'!F30, 0)","v":0.21033868092691624},{"$f":"IF('Data Sheet'!G30>0, 'Data Sheet'!G31/'Data Sheet'!G30, 0)","v":0.19633943427620634},{"$f":"IF('Data Sheet'!H30>0, 'Data Sheet'!H31/'Data Sheet'!H30, 0)","v":0.19343843204090327},{"$f":"IF('Data Sheet'!I30>0, 'Data Sheet'!I31/'Data Sheet'!I30, 0)","v":0.21549344375431331},{"$f":"IF('Data Sheet'!J30>0, 'Data Sheet'!J31/'Data Sheet'!J30, 0)","v":0.15860317460317461},{"$f":"IF('Data Sheet'!K30>0, 'Data Sheet'!K31/'Data Sheet'!K30, 0)","v":0.14830884068112898}]
["OPM",{"$f":"IF(B6>0,B6/B4,0)","v":1.4692378328742086E-2},{"$f":"IF(C6>0,C6/C4,0)","v":0},0,3.7448856799037172E-2,0.1136981774738821,7.7865563854083136E-2,9.8470321047003789E-2,0.10237215414509238,0.11410649609322741,0.12144211134938124,0.16084174710603202]
[]
[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.44740670106639846},{"$f":"IF(D4=0,\"\",POWER($K4/D4,1/7)-1)","v":0.6244661654193242},{"$f":"IF(F4=0,\"\",POWER($K4/F4,1/5)-1)","v":0.47349287763198999},{"$f":"IF(H4=0,\"\",POWER($K4/H4, 1/3)-1)","v":0.34162025910000415},{"$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.35394814422109799},{"$f":"MAX(K27:L27)","v":0.35394814422109799},{"$f":"MIN(H27:L27)","v":0.34162025910000415}]
[null,null,null,null,null,null,"OPM",{"$f":"IF(SUM(B4:$K$4)=0,\"\",SUMPRODUCT(B24:$K$24,B4:$K$4)/SUM(B4:$K$4))","v":0.10470621330937452},{"$f":"IF(SUM(E4:$K$4)=0,\"\",SUMPRODUCT(E24:$K$24,E4:$K$4)/SUM(E4:$K$4))","v":0.10758581844212908},{"$f":"IF(SUM(G4:$K$4)=0,\"\",SUMPRODUCT(G24:$K$24,G4:$K$4)/SUM(G4:$K$4))","v":0.10904965071481343},{"$f":"IF(SUM(I4:$K$4)=0, \"\", SUMPRODUCT(I24:$K$24,I4:$K$4)/SUM(I4:$K$4))","v":0.11397649277896266},{"$f":"L24","v":0.16084174710603202},{"$f":"MAX(K28:L28)","v":0.16084174710603202},{"$f":"MIN(H28:L28)","v":0.10470621330937452}]
[null,null,null,null,null,null,"Price to Earning",{"$f":"IF(ISERROR(AVERAGEIF(B14:$L14,\">0\")),\"\",AVERAGEIF(B14:$L14,\">0\"))","v":13.110670224176854},{"$f":"IF(ISERROR(AVERAGEIF(E14:$L14,\">0\")),\"\",AVERAGEIF(E14:$L14,\">0\"))","v":11.856105125794468},{"$f":"IF(ISERROR(AVERAGEIF(G14:$L14,\">0\")),\"\",AVERAGEIF(G14:$L14,\">0\"))","v":13.777955972835878},{"$f":"IF(ISERROR(AVERAGEIF(I14:$L14,\">0\")),\"\",AVERAGEIF(I14:$L14,\">0\"))","v":17.955509436467302},{"$f":"L14","v":28.357328791335927},{"$f":"MAX(K29:L29)","v":28.357328791335927},{"$f":"MIN(H29:L29)","v":11.856105125794468}]
[]
["Year on Year Sales Growth",null,{"$f":"(C4-B4)/B4","v":-0.29282726252423225},{"$f":"(D4-C4)/C4","v":0.32073293896984567},1.2694996722744154,0.89367027677497002,0.64723825017157655,0.7462039380285167,0.57356333012256899,0.13345051834712965,0.35394814422109799,8.8423001763849193E-2]

{"sheet":"Quarters","index":1,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Profit & Loss'!A1","v":"AVANTI FEEDS LTD"},null,null,null,{"$f":"UPDATE","v":""},null,null,null,null,"SCREENER.IN"]
[]
["Narration",{"$f":"'Data Sheet'!B41","v":"2015-03-31"},{"$f":"'Data Sheet'!C41","v":"2015-06-30"},{"$f":"'Data Sheet'!D41","v":"2015-09-30"},{"$f":"'Data Sheet'!E41","v":"2015-12-31"},{"$f":"'Data Sheet'!F41","v":"2016-03-31"},{"$f":"'Data Sheet'!G41","v":"2016-06-30"},{"$f":"'Data Sheet'!H41","v":"2016-09-30"},{"$f":"'Data Sheet'!I41","v":"2016-12-31"},{"$f":"'Data Sheet'!J41","v":"2017-03-31"},{"$f":"'Data Sheet'!K41","v":"2017-06-30"}]
["Sales",{"$f":"'Data Sheet'!B42","v":381.45},{"$f":"'Data Sheet'!C42","v":603.4},{"$f":"'Data Sheet'!D42","v":532.95000000000005},{"$f":"'Data Sheet'!E42","v":413.11},{"$f":"'Data Sheet'!F42","v":468.83},{"$f":"'Data Sheet'!G42","v":724.38},{"$f":"'Data Sheet'!H42","v":713.06},{"$f":"'Data Sheet'!I42","v":558.63},{"$f":"'Data Sheet'!J42","v":704.43},{"$f":"'Data Sheet'!K42","v":998.17}]
["Expenses",{"$f":"'Data Sheet'!B43","v":344.57},{"$f":"'Data Sheet'!C43","v":539.25},{"$f":"'Data Sheet'!D43","v":470.5},{"$f":"'Data Sheet'!E43","v":357.62},{"$f":"'Data Sheet'!F43","v":422.44},{"$f":"'Data Sheet'!G43","v":648.34},{"$f":"'Data Sheet'!H43","v":656.63},{"$f":"'Data Sheet'!I43","v":489.73},{"$f":"'Data Sheet'!J43","v":576.34},{"$f":"'Data Sheet'!K43","v":773.2}]
["Operating Profit",{"$f":"'Data Sheet'!B50","v":36.880000000000003},{"$f":"'Data Sheet'!C50","v":64.150000000000006},{"$f":"'Data Sheet'!D50","v":62.45},{"$f":"'Data Sheet'!E50","v":55.49},{"$f":"'Data Sheet'!F50","v":46.39},{"$f":"'Data Sheet'!G50","v":76.040000000000006},{"$f":"'Data Sheet'!H50","v":56.43},{"$f":"'Data Sheet'!I50","v":68.900000000000006},{"$f":"'Data Sheet'!J50","v":128.09},{"$f":"'Data Sheet'!K50","v":224.97}]
["Other Income",{"$f":"'Data Sheet'!B44","v":1.52},{"$f":"'Data Sheet'!C44","v":7.53},{"$f":"'Data Sheet'!D44","v":5.84},{"$f":"'Data Sheet'!E44","v":3.5},{"$f":"'Data Sheet'!F44","v":4.62},{"$f":"'Data Sheet'!G44","v":1.85},{"$f":"'Data Sheet'!H44","v":7},{"$f":"'Data Sheet'!I44","v":3.59},{"$f":"'Data Sheet'!J44","v":7.99},{"$f":"'Data Sheet'!K44","v":6.18}]
["Depreciation",{"$f":"'Data Sheet'!B45","v":2.2400000000000002},{"$f":"'Data Sheet'!C45","v":2.6},{"$f":"'Data Sheet'!D45","v":2.5299999999999998},{"$f":"'Data Sheet'!E45","v":2.58},{"$f":"'Data Sheet'!F45","v":2.52},{"$f":"'Data Sheet'!G45","v":2.71},{"$f":"'Data Sheet'!H45","v":3.24},{"$f":"'Data Sheet'!I45","v":3.93},{"$f":"'Data Sheet'!J45","v":3.81},{"$f":"'Data Sheet'!K45","v":4.07}]
["Interest",{"$f":"'Data Sheet'!B46","v":0.49},{"$f":"'Data Sheet'!C46","v":0.28999999999999998},{"$f":"'Data Sheet'!D46","v":0.3},{"$f":"'Data Sheet'!E46","v":0.19},{"$f":"'Data Sheet'!F46","v":0.78},{"$f":"'Data Sheet'!G46","v":0.2},{"$f":"'Data Sheet'!H46","v":0.22},{"$f":"'Data Sheet'!I46","v":0.24},{"$f":"'Data Sheet'!J46","v":2.1800000000000002},{"$f":"'Data Sheet'!K46","v":0.62}]
["Profit before tax",{"$f":"'Data Sheet'!B47","v":35.67},{"$f":"'Data Sheet'!C47","v":68.790000000000006},{"$f":"'Data Sheet'!D47","v":65.47},{"$f":"'Data Sheet'!E47","v":56.22},{"$f":"'Data Sheet'!F47","v":47.7},{"$f":"'Data Sheet'!G47","v":74.98},{"$f":"'Data Sheet'!H47","v":59.96},{"$f":"'Data Sheet'!I47","v":68.31},{"$f":"'Data Sheet'!J47","v":130.09},{"$f":"'Data Sheet'!K47","v":226.46}]
["Tax",{"$f":"'Data Sheet'!B48","v":13.39},{"$f":"'Data Sheet'!C48","v":23.08},{"$f":"'Data Sheet'!D48","v":21.5},{"$f":"'Data Sheet'!E48","v":19.04},{"$f":"'Data Sheet'!F48","v":15.58},{"$f":"'Data Sheet'!G48","v":25.76},{"$f":"'Data Sheet'!H48","v":19.77},{"$f":"'Data Sheet'!I48","v":21.84},{"$f":"'Data Sheet'!J48","v":40.409999999999997},{"$f":"'Data Sheet'!K48","v":77.67}]
["Net profit",{"$f":"'Data Sheet'!B49","v":21.79},{"$f":"'Data Sheet'!C49","v":45.4},{"$f":"'Data Sheet'!D49","v":43.96},{"$f":"'Data Sheet'!E49","v":36.54},{"$f":"'Data Sheet'!F49","v":31.23},{"$f":"'Data Sheet'!G49","v":49.03},{"$f":"'Data Sheet'!H49","v":37.340000000000003},{"$f":"'Data Sheet'!I49","v":41.11},{"$f":"'Data Sheet'!J49","v":83.88},{"$f":"'Data Sheet'!K49","v":148.84}]
[]
["OPM",{"$f":"IF(B4>0,B6/B4,\"\")","v":9.6683706907851635E-2},{"$f":"IF(C4>0,C6/C4,\"\")","v":0.10631421942326816},0.11717797166713576,0.13432257752172544,9.8948446131860171E-2,0.10497252823103896,7.913780046559897E-2,0.12333745054866371,0.18183495876098407,0.22538244988328643]
[]
["EBIT",{"$f":"B10+B9","v":36.160000000000004},{"$f":"C10+C9","v":69.080000000000013},65.77,56.41,48.480000000000004,75.180000000000007,60.18,68.55,132.27000000000001,227.08]
["EBITDA",{"$f":"B16+B8","v":38.400000000000006},{"$f":"C16+C8","v":71.680000000000007},68.3,58.989999999999995,51.000000000000007,77.89,63.42,72.48,136.08000000000001,231.15]

{"sheet":"Balance Sheet","index":2,"n_rows":44,"n_cols":14,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Profit & Loss'!A1","v":"AVANTI FEEDS LTD"},null,null,null,{"$f":"UPDATE","v":""},null,null,null,null,"SCREENER.IN"]
[]
["Narration",{"$f":"'Data Sheet'!B56","v":"2008-03-31"},{"$f":"'Data Sheet'!C56","v":"2009-03-31"},{"$f":"'Data Sheet'!D56","v":"2010-03-31"},{"$f":"'Data Sheet'!E56","v":"2011-03-31"},{"$f":"'Data Sheet'!F56","v":"2012-03-31"},{"$f":"'Data Sheet'!G56","v":"2013-03-31"},{"$f":"'Data Sheet'!H56","v":"2014-03-31"},{"$f":"'Data Sheet'!I56","v":"2015-03-31"},{"$f":"'Data Sheet'!J56","v":"2016-03-31"},{"$f":"'Data Sheet'!K56","v":"2017-03-31"},"1HFY17","Input data from 2QFY BS"]
["Equity Share Capital",{"$f":"'Data Sheet'!B57","v":6.54},{"$f":"'Data Sheet'!C57","v":8},{"$f":"'Data Sheet'!D57","v":8},{"$f":"'Data Sheet'!E57","v":8},{"$f":"'Data Sheet'!F57","v":8},{"$f":"'Data Sheet'!G57","v":9.08},{"$f":"'Data Sheet'!H57","v":9.08},{"$f":"'Data Sheet'!I57","v":9.08},{"$f":"'Data Sheet'!J57","v":9.08},{"$f":"'Data Sheet'!K57","v":9.08}]
["Reserves",{"$f":"'Data Sheet'!B58","v":62.72},{"$f":"'Data Sheet'!C58","v":60.1},{"$f":"'Data Sheet'!D58","v":58.9},{"$f":"'Data Sheet'!E58","v":61.52},{"$f":"'Data Sheet'!F58","v":85.61},{"$f":"'Data Sheet'!G58","v":116.02},{"$f":"'Data Sheet'!H58","v":170.49},{"$f":"'Data Sheet'!I58","v":256.20999999999998},{"$f":"'Data Sheet'!J58","v":413.71},{"$f":"'Data Sheet'!K58","v":631.38}]
["Borrowings",{"$f":"'Data Sheet'!B59","v":40.659999999999997},{"$f":"'Data Sheet'!C59","v":38.020000000000003},{"$f":"'Data Sheet'!D59","v":34.130000000000003},{"$f":"'Data Sheet'!E59","v":54.46},{"$f":"'Data Sheet'!F59","v":49.57},{"$f":"'Data Sheet'!G59","v":61.08},{"$f":"'Data Sheet'!H59","v":56.12},{"$f":"'Data Sheet'!I59","v":58.4},{"$f":"'Data Sheet'!J59","v":10.71},{"$f":"'Data Sheet'!K59","v":19.43},{"$f":"L8-(L7+L5+L4)","v":0}]
["Other Liabilities",{"$f":"'Data Sheet'!B60","v":9.67},{"$f":"'Data Sheet'!C60","v":11.99},{"$f":"'Data Sheet'!D60","v":13.64},{"$f":"'Data Sheet'!E60","v":28.32},{"$f":"'Data Sheet'!F60","v":40.04},{"$f":"'Data Sheet'!G60","v":62.7},{"$f":"'Data Sheet'!H60","v":163.72},{"$f":"'Data Sheet'!I60","v":154.1},{"$f":"'Data Sheet'!J60","v":189.1},{"$f":"'Data Sheet'!K60","v":396.58},null,"def tax liab+oth long term liab+other current liab"]
["Total",{"$f":"'Data Sheet'!B61","v":119.59},{"$f":"'Data Sheet'!C61","v":118.11},{"$f":"'Data Sheet'!D61","v":114.67},{"$f":"'Data Sheet'!E61","v":152.30000000000001},{"$f":"'Data Sheet'!F61","v":183.22},{"$f":"'Data Sheet'!G61","v":248.88},{"$f":"'Data Sheet'!H61","v":399.41},{"$f":"'Data Sheet'!I61","v":477.79},{"$f":"'Data Sheet'!J61","v":622.6},{"$f":"'Data Sheet'!K61","v":1056.47}]
[]
["Net Block",{"$f":"'Data Sheet'!B62","v":33.43},{"$f":"'Data Sheet'!C62","v":30.05},{"$f":"'Data Sheet'!D62","v":27.86},{"$f":"'Data Sheet'!E62","v":26.78},{"$f":"'Data Sheet'!F62","v":43.09},{"$f":"'Data Sheet'!G62","v":50.85},{"$f":"'Data Sheet'!H62","v":77.510000000000005},{"$f":"'Data Sheet'!I62","v":89.57},{"$f":"'Data Sheet'!J62","v":103.99},{"$f":"'Data Sheet'!K62","v":160.47}]
["Capital Work in Progress",{"$f":"'Data Sheet'!B63","v":0.14000000000000001},{"$f":"'Data Sheet'!C63","v":0},{"$f":"'Data Sheet'!D63","v":0},{"$f":"'Data Sheet'!E63","v":11.12},{"$f":"'Data Sheet'!F63","v":1.67},{"$f":"'Data Sheet'!G63","v":1.59},{"$f":"'Data Sheet'!H63","v":4.8099999999999996},{"$f":"'Data Sheet'!I63","v":0},{"$f":"'Data Sheet'!J63","v":41.62},{"$f":"'Data Sheet'!K63","v":78.47}]
["Investments",{"$f":"'Data Sheet'!B64","v":27.83},{"$f":"'Data Sheet'!C64","v":27.5},{"$f":"'Data Sheet'!D64","v":31.33},{"$f":"'Data Sheet'!E64","v":34.49},{"$f":"'Data Sheet'!F64","v":44.77},{"$f":"'Data Sheet'!G64","v":34.869999999999997},{"$f":"'Data Sheet'!H64","v":40.31},{"$f":"'Data Sheet'!I64","v":111.09},{"$f":"'Data Sheet'!J64","v":33.15},{"$f":"'Data Sheet'!K64","v":357.51}]
["Other Assets",{"$f":"'Data Sheet'!B65","v":58.19},{"$f":"'Data Sheet'!C65","v":60.56},{"$f":"'Data Sheet'!D65","v":55.48},{"$f":"'Data Sheet'!E65","v":79.91},{"$f":"'Data Sheet'!F65","v":93.69},{"$f":"'Data Sheet'!G65","v":161.57},{"$f":"'Data Sheet'!H65","v":276.77999999999997},{"$f":"'Data Sheet'!I65","v":277.13},{"$f":"'Data Sheet'!J65","v":443.84},{"$f":"'Data Sheet'!K65","v":460.02},null,"total current assets+long term loans and advances+other non current assets"]
["Total",{"$f":"'Data Sheet'!B66","v":119.59},{"$f":"'Data Sheet'!C66","v":118.11},{"$f":"'Data Sheet'!D66","v":114.67},{"$f":"'Data Sheet'!E66","v":152.30000000000001},{"$f":"'Data Sheet'!F66","v":183.22},{"$f":"'Data Sheet'!G66","v":248.88},{"$f":"'Data Sheet'!H66","v":399.41},{"$f":"'Data Sheet'!I66","v":477.79},{"$f":"'Data Sheet'!J66","v":622.6},{"$f":"'Data Sheet'!K66","v":1056.47},{"$f":"L8","v":0},{"$f":"L10+L11+L12+L13","v":0},"check TA matching"]
[]
["Working Capital",{"$f":"B13-B7","v":48.519999999999996},48.57,41.839999999999996,51.589999999999996,53.65,98.86999999999999,113.05999999999997,123.03,254.73999999999998,63.44,{"$f":"L13-L7","v":0}]
["Debtors",{"$f":"'Data Sheet'!B67","v":13.54},{"$f":"'Data Sheet'!C67","v":15.86},{"$f":"'Data Sheet'!D67","v":8.93},{"$f":"'Data Sheet'!E67","v":22.81},{"$f":"'Data Sheet'!F67","v":15.51},{"$f":"'Data Sheet'!G67","v":39.729999999999997},{"$f":"'Data Sheet'!H67","v":45.02},{"$f":"'Data Sheet'!I67","v":33.56},{"$f":"'Data Sheet'!J67","v":34.97},{"$f":"'Data Sheet'!K67","v":23.51}]
["Inventory",{"$f":"'Data Sheet'!B68","v":26.7},{"$f":"'Data Sheet'!C68","v":20.38},{"$f":"'Data Sheet'!D68","v":27.27},{"$f":"'Data Sheet'!E68","v":39.049999999999997},{"$f":"'Data Sheet'!F68","v":42.15},{"$f":"'Data Sheet'!G68","v":97.16},{"$f":"'Data Sheet'!H68","v":199.15},{"$f":"'Data Sheet'!I68","v":222.02},{"$f":"'Data Sheet'!J68","v":285.55},{"$f":"'Data Sheet'!K68","v":355.7}]
["Payables (Creditors)",null,null,null,null,null,null,null,null,null,null,null,"input Creditors (Payables) data from Annual Reports"]
[]
["Inventory Turnover",{"$f":"IF('Balance Sheet'!B18>0,'Profit & Loss'!B4/'Balance Sheet'!B18,0)","v":3.6707865168539331},{"$f":"IF('Balance Sheet'!C18>0,'Profit & Loss'!C4/'Balance Sheet'!C18,0)","v":3.4008832188420022},{"$f":"IF('Balance Sheet'!D18>0,'Profit & Loss'!D4/'Balance Sheet'!D18,0)","v":3.356802346901357},{"$f":"IF('Balance Sheet'!E18>0,'Profit & Loss'!E4/'Balance Sheet'!E18,0)","v":5.3201024327784898},{"$f":"IF('Balance Sheet'!F18>0,'Profit & Loss'!F4/'Balance Sheet'!F18,0)","v":9.3335705812574155},{"$f":"IF('Balance Sheet'!G18>0,'Profit & Loss'!G4/'Balance Sheet'!G18,0)","v":6.6698229724166325},{"$f":"IF('Balance Sheet'!H18>0,'Profit & Loss'!H4/'Balance Sheet'!H18,0)","v":5.6821993472257084},{"$f":"IF('Balance Sheet'!I18>0,'Profit & Loss'!I4/'Balance Sheet'!I18,0)","v":8.020268444284298},{"$f":"IF('Balance Sheet'!J18>0,'Profit & Loss'!J4/'Balance Sheet'!J18,0)","v":7.0680791455086673},{"$f":"IF('Balance Sheet'!K18>0,'Profit & Loss'!K4/'Balance Sheet'!K18,0)","v":7.6824852403710988},{"$f":"IF('Balance Sheet'!L18>0,'Profit & Loss'!L4/'Balance Sheet'!L18,0)","v":0}]
["Inventory Days",{"$f":"IF('Profit & Loss'!B4>0,'Balance Sheet'!B18/('Profit & Loss'!B4/365),0)","v":99.433731251913073},{"$f":"IF('Profit & Loss'!C4>0,'Balance Sheet'!C18/('Profit & Loss'!C4/365),0)","v":107.32506131871303},{"$f":"IF('Profit & Loss'!D4>0,'Balance Sheet'!D18/('Profit & Loss'!D4/365),0)","v":108.73443303473891},{"$f":"IF('Profit & Loss'!E4>0,'Balance Sheet'!E18/('Profit & Loss'!E4/365),0)","v":68.607701564380264},{"$f":"IF('Profit & Loss'!F4>0,'Balance Sheet'!F18/('Profit & Loss'!F4/365),0)","v":39.106148801504787},{"$f":"IF('Profit & Loss'!G4>0,'Balance Sheet'!G18/('Profit & Loss'!G4/365),0)","v":54.724091105487318},{"$f":"IF('Profit & Loss'!H4>0,'Balance Sheet'!H18/('Profit & Loss'!H4/365),0)","v":64.235690741509885},{"$f":"IF('Profit & Loss'!I4>0,'Balance Sheet'!I18/('Profit & Loss'!I4/365),0)","v":45.509698651061967},{"$f":"IF('Profit & Loss'!J4>0,'Balance Sheet'!J18/('Profit & Loss'!J4/365),0)","v":51.640621516234042},{"$f":"IF('Profit & Loss'!K4>0,'Balance Sheet'!K18/('Profit & Loss'!K4/365),0)","v":47.510667261935261},{"$f":"IF('Profit & Loss'!L4>0,L18/('Profit & Loss'!L4/365),0)","v":0}]
["Debtor Days",{"$f":"IF('Profit & Loss'!B4>0,'Balance Sheet'!B17/('Profit & Loss'!B4/365),0)","v":50.424446485052542},{"$f":"IF('Profit & Loss'!C4>0,'Balance Sheet'!C17/('Profit & Loss'!C4/365),0)","v":83.521858317703078},{"$f":"IF('Profit & Loss'!D4>0,'Balance Sheet'!D17/('Profit & Loss'!D4/365),0)","v":35.606838540528727},{"$f":"IF('Profit & Loss'!E4>0,'Balance Sheet'!E17/('Profit & Loss'!E4/365),0)","v":40.075330926594468},{"$f":"IF('Profit & Loss'!F4>0,'Balance Sheet'!F17/('Profit & Loss'!F4/365),0)","v":14.389949416639128},{"$f":"IF('Profit & Loss'!G4>0,'Balance Sheet'!G17/('Profit & Loss'!G4/365),0)","v":22.37739954323807},{"$f":"IF('Profit & Loss'!H4>0,'Balance Sheet'!H17/('Profit & Loss'!H4/365),0)","v":14.521168953968242},{"$f":"IF('Profit & Loss'!I4>0,'Balance Sheet'!I17/('Profit & Loss'!I4/365),0)","v":6.8791347028629835},{"$f":"IF('Profit & Loss'!J4>0,'Balance Sheet'!J17/('Profit & Loss'!J4/365),0)","v":6.3241902798904022},{"$f":"IF('Profit & Loss'!K4>0,'Balance Sheet'!K17/('Profit & Loss'!K4/365),0)","v":3.1402186880182685},{"$f":"IF('Profit & Loss'!L4>0, L17/('Profit & Loss'!L4/365),0)","v":0}]
["Creditor Days",{"$f":"IF('Profit & Loss'!B4>0,B19/('Profit & Loss'!B4/365),0)","v":0},{"$f":"IF('Profit & Loss'!C4>0,C19/('Profit & Loss'!C4/365),0)","v":0},{"$f":"IF('Profit & Loss'!D4>0,D19/('Profit & Loss'!D4/365),0)","v":0},{"$f":"IF('Profit & Loss'!E4>0,E19/('Profit & Loss'!E4/365),0)","v":0},{"$f":"IF('Profit & Loss'!F4>0,F19/('Profit & Loss'!F4/365),0)","v":0},{"$f":"IF('Profit & Loss'!G4>0,G19/('Profit & Loss'!G4/365),0)","v":0},{"$f":"IF('Profit & Loss'!H4>0,H19/('Profit & Loss'!H4/365),0)","v":0},{"$f":"IF('Profit & Loss'!I4>0,I19/('Profit & Loss'!I4/365),0)","v":0},{"$f":"IF('Profit & Loss'!J4>0,J19/('Profit & Loss'!J4/365),0)","v":0},{"$f":"IF('Profit & Loss'!K4>0,K19/('Profit & Loss'!K4/365),0)","v":0},{"$f":"IF('Profit & Loss'!L4>0,L19/('Profit & Loss'!L4/365),0)","v":0}]
["Cash Conversion Cycle",{"$f":"IF(B19>0,B22+B23-B24,0)","v":0},{"$f":"IF(C19>0,C22+C23-C24,0)","v":0},0,0,0,0,0,0,0,0,0]
["Working Capital/Sales",{"$f":"B16/'Profit & Loss'!B4","v":0.4950515253545556},{"$f":"C16/'Profit & Loss'!C4","v":0.70076468042129558},{"$f":"D16/'Profit & Loss'!D4","v":0.45706794843784132},{"$f":"E16/'Profit & Loss'!E4","v":0.24832731648616124},{"$f":"F16/'Profit & Loss'!F4","v":0.1363717241554612},{"$f":"G16/'Profit & Loss'!G4","v":0.15256774273193013},{"$f":"H16/'Profit & Loss'!H4","v":9.9910746635324871E-2},{"$f":"I16/'Profit & Loss'!I4","v":6.9092359012950258E-2},{"$f":"J16/'Profit & Loss'!J4","v":0.12621575690312095},{"$f":"K16/'Profit & Loss'!K4","v":2.321547503165414E-2}]
[]
["Return on Equity",{"$f":"IF(SUM('Balance Sheet'!B4:B5)>0,'Profit & Loss'!B12/SUM('Balance Sheet'!B4:B5),\"\")","v":1.2850129945134276E-2},{"$f":"IF(SUM('Balance Sheet'!C4:C5)>0,'Profit & Loss'!C12/SUM('Balance Sheet'!C4:C5),\"\")","v":-0.10279001468428782},{"$f":"IF(SUM('Balance Sheet'!D4:D5)>0,'Profit & Loss'!D12/SUM('Balance Sheet'!D4:D5),\"\")","v":-1.8086696562032881E-2},{"$f":"IF(SUM('Balance Sheet'!E4:E5)>0,'Profit & Loss'!E12/SUM('Balance Sheet'!E4:E5),\"\")","v":4.8906789413118518E-2},{"$f":"IF(SUM('Balance Sheet'!F4:F5)>0,'Profit & Loss'!F12/SUM('Balance Sheet'!F4:F5),\"\")","v":0.29964747356051707},{"$f":"IF(SUM('Balance Sheet'!G4:G5)>0,'Profit & Loss'!G12/SUM('Balance Sheet'!G4:G5),\"\")","v":0.2402078337330136},{"$f":"IF(SUM('Balance Sheet'!H4:H5)>0,'Profit & Loss'!H12/SUM('Balance Sheet'!H4:H5),\"\")","v":0.39210335802194124},{"$f":"IF(SUM('Balance Sheet'!I4:I5)>0,'Profit & Loss'!I12/SUM('Balance Sheet'!I4:I5),\"\")","v":0.43695578423611903},{"$f":"IF(SUM('Balance Sheet'!J4:J5)>0,'Profit & Loss'!J12/SUM('Balance Sheet'!J4:J5),\"\")","v":0.37252536720357626},{"$f":"IF(SUM('Balance Sheet'!K4:K5)>0,'Profit & Loss'!K12/SUM('Balance Sheet'!K4:K5),\"\")","v":0.33468132279923801},{"$f":"IF(SUM('Balance Sheet'!L4:L5)>0,'Profit & Loss'!L12/SUM('Balance Sheet'!L4:L5),\"\")","v":""}]
["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":-3.5021354484441596E-2},{"$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":-5.3167133045026842E-2},{"$f":"IF(('Balance Sheet'!D10+'Balance Sheet'!D16)>0,('Profit & Loss'!D6-'Profit & Loss'!D8-'Profit & Loss'!D11)/('Balance Sheet'!D10+'Balance Sheet'!D16),\"\")","v":-0.12582496413199459},{"$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":3.9811152226616978E-2},{"$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.29739507959478972},{"$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.21052631578947389},{"$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.36978538070000494},{"$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.51843838193791236},{"$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.39269088172162897},{"$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.93671564467866608}]
[]
["Book Value",{"$f":"B4+B5","v":69.260000000000005},68.099999999999994,66.900000000000006,69.52000000000001,93.61,125.1,179.57000000000002,265.28999999999996,422.78999999999996,640.46,0]
["BVPS",{"$f":"IF('Data Sheet'!B93>0,B31/'Data Sheet'!B93,0)","v":21.180428134556575},{"$f":"IF('Data Sheet'!C93>0,C31/'Data Sheet'!C93,0)","v":17.024999999999999},{"$f":"IF('Data Sheet'!D93>0,D31/'Data Sheet'!D93,0)","v":16.725000000000001},{"$f":"IF('Data Sheet'!E93>0,E31/'Data Sheet'!E93,0)","v":17.380000000000003},{"$f":"IF('Data Sheet'!F93>0,F31/'Data Sheet'!F93,0)","v":23.4025},{"$f":"IF('Data Sheet'!G93>0,G31/'Data Sheet'!G93,0)","v":27.545837616956959},{"$f":"IF('Data Sheet'!H93>0,H31/'Data Sheet'!H93,0)","v":39.539616793580834},{"$f":"IF('Data Sheet'!I93>0,I31/'Data Sheet'!I93,0)","v":58.414350610731503},{"$f":"IF('Data Sheet'!J93>0,J31/'Data Sheet'!J93,0)","v":93.09436199898667},{"$f":"IF('Data Sheet'!K93>0,K31/'Data Sheet'!K93,0)","v":141.0232386902978},{"$f":"IF('Data Sheet'!K93>0,L31/'Data Sheet'!K93,0)","v":0}]
[]
["Cash & Bank Balances",{"$f":"'Data Sheet'!B69","v":3.99},{"$f":"'Data Sheet'!C69","v":9.01},{"$f":"'Data Sheet'!D69","v":3.42},{"$f":"'Data Sheet'!E69","v":4.5599999999999996},{"$f":"'Data Sheet'!F69","v":22.05},{"$f":"'Data Sheet'!G69","v":8.59},{"$f":"'Data Sheet'!H69","v":12.86},{"$f":"'Data Sheet'!I69","v":6.16},{"$f":"'Data Sheet'!J69","v":72.569999999999993},{"$f":"'Data Sheet'!K69","v":45.12}]
["Cash/Sales",{"$f":"B34/'Data Sheet'!B17","v":4.0710131619222531E-2},{"$f":"C34/'Data Sheet'!C17","v":0.1299956716202568},{"$f":"D34/'Data Sheet'!D17","v":3.7360716626611314E-2},{"$f":"E34/'Data Sheet'!E17","v":2.194945848375451E-2},{"$f":"F34/'Data Sheet'!F17","v":5.6048397346279963E-2},{"$f":"G34/'Data Sheet'!G17","v":1.3255354607740263E-2},{"$f":"H34/'Data Sheet'!H17","v":1.1364339304177235E-2},{"$f":"I34/'Data Sheet'!I17","v":3.4593914615928924E-3},{"$f":"J34/'Data Sheet'!J17","v":3.59561807272493E-2},{"$f":"K34/'Data Sheet'!K17","v":1.6511384511794368E-2}]
["Working Capital/Sales"]
["Common Size Balance Sheet",{"$f":"B3","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","2017-03-31","Check back how Assets are being put to use"]
["Net Block/Total Assets",{"$f":"B10/B$8","v":0.27953842294506226},0.25442384218101771,0.24295805354495509,0.17583716349310571,0.23518174871738895,0.20431533269045324,0.19406124032948599,0.18746729734820736,0.16702537744940571,0.15189262354823138,"high historical Fixed Assets/Total Assets - strong correlation high Op Leverage"]
["Working Capital/Total Assets",{"$f":"B16/B$8","v":0.4057195417677063},0.41122682245364489,0.36487311415365831,0.33873933026920544,0.29281737801550051,0.39725972356155576,0.28306752459878315,0.25749806400301389,0.40915515579826528,6.0049031207701116E-2]
["Debtors/Total Assets",{"$f":"B17/B$8","v":0.11322016891044401},0.13428160189653712,7.7875643149908427E-2,0.14977019041365724,8.4652330531601358E-2,0.15963516554162649,0.11271625647830551,7.0240063626279325E-2,5.6167683906199806E-2,2.2253353147746742E-2]
["Inventory/Total Assets",{"$f":"B18/B$8","v":0.22326281461660671},0.1725510117686902,0.23781285427749194,0.25640183847669068,0.23005130444274641,0.39038894246223077,0.49861045041436114,0.46468113606396116,0.45864118213941535,0.33668726987041753]
["Cash/Total Assets",{"$f":"B34/B$8","v":3.3363993644953592E-2},{"$f":"C34/C$8","v":7.6284819236305132E-2},2.9824714397837272E-2,2.9940906106369004E-2,0.12034712367645455,3.4514625522340081E-2,3.2197491299667008E-2,1.2892693442725884E-2,0.11655958882107291,4.2708264314178346E-2,"check for excluding excess cash (over and above historical normalised levels)"]
[]
["Borrowings/Total Assets",{"$f":"B6/B$8","v":0.33999498285809848},0.32190331047328763,0.29763669660765679,0.35758371634931058,0.27054906669577555,0.24541947926711669,0.14050724819108182,0.12222943134012849,1.7202055894635401E-2,1.8391435629975295E-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":"AVANTI FEEDS LTD"},null,null,null,{"$f":"UPDATE","v":""},null,null,null,null,"SCREENER.IN"]
[]
["Narration",{"$f":"'Data Sheet'!B81","v":"2008-03-31"},{"$f":"'Data Sheet'!C81","v":"2009-03-31"},{"$f":"'Data Sheet'!D81","v":"2010-03-31"},{"$f":"'Data Sheet'!E81","v":"2011-03-31"},{"$f":"'Data Sheet'!F81","v":"2012-03-31"},{"$f":"'Data Sheet'!G81","v":"2013-03-31"},{"$f":"'Data Sheet'!H81","v":"2014-03-31"},{"$f":"'Data Sheet'!I81","v":"2015-03-31"},{"$f":"'Data Sheet'!J81","v":"2016-03-31"},{"$f":"'Data Sheet'!K81","v":"2017-03-31"}]
["Cash from Operating Activity",{"$f":"'Data Sheet'!B82","v":17.190000000000001},{"$f":"'Data Sheet'!C82","v":9.34},{"$f":"'Data Sheet'!D82","v":3.92},{"$f":"'Data Sheet'!E82","v":-7.72},{"$f":"'Data Sheet'!F82","v":50.38},{"$f":"'Data Sheet'!G82","v":-20.55},{"$f":"'Data Sheet'!H82","v":55.56},{"$f":"'Data Sheet'!I82","v":89.34},{"$f":"'Data Sheet'!J82","v":122},{"$f":"'Data Sheet'!K82","v":291.69}]
["Cash from Investing Activity",{"$f":"'Data Sheet'!B83","v":0.47},{"$f":"'Data Sheet'!C83","v":0.65},{"$f":"'Data Sheet'!D83","v":-2.19},{"$f":"'Data Sheet'!E83","v":-17.600000000000001},{"$f":"'Data Sheet'!F83","v":-17.440000000000001},{"$f":"'Data Sheet'!G83","v":5.43},{"$f":"'Data Sheet'!H83","v":-39.1},{"$f":"'Data Sheet'!I83","v":-83.52},{"$f":"'Data Sheet'!J83","v":18.13},{"$f":"'Data Sheet'!K83","v":-428.3}]
["Cash from Financing Activity",{"$f":"'Data Sheet'!B84","v":-21.08},{"$f":"'Data Sheet'!C84","v":-4.97},{"$f":"'Data Sheet'!D84","v":-7.32},{"$f":"'Data Sheet'!E84","v":19.010000000000002},{"$f":"'Data Sheet'!F84","v":-14.09},{"$f":"'Data Sheet'!G84","v":0.81},{"$f":"'Data Sheet'!H84","v":-12.74},{"$f":"'Data Sheet'!I84","v":-11.97},{"$f":"'Data Sheet'!J84","v":-74.260000000000005},{"$f":"'Data Sheet'!K84","v":107.11}]
["Net Cash Flow",{"$f":"'Data Sheet'!B85","v":-3.42},{"$f":"'Data Sheet'!C85","v":5.0199999999999996},{"$f":"'Data Sheet'!D85","v":-5.59},{"$f":"'Data Sheet'!E85","v":-6.31},{"$f":"'Data Sheet'!F85","v":18.850000000000001},{"$f":"'Data Sheet'!G85","v":-14.31},{"$f":"'Data Sheet'!H85","v":3.72},{"$f":"'Data Sheet'!I85","v":-6.15},{"$f":"'Data Sheet'!J85","v":65.86},{"$f":"'Data Sheet'!K85","v":-29.5}]

{"sheet":"Customization","index":4,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[58,0,58,10],[3,5,3,10],[3,12,3,13],[9,0,9,9],[33,0,33,10],[47,0,47,10]]}
[{"$f":"'Data Sheet'!B1","v":"AVANTI FEEDS 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'!K10-'Calculated Data'!B10","v":571.20000000000005},{"$f":"'Calculated Data'!K33-'Calculated Data'!B33","v":3851.5452198100002},{"$f":"C5/B5","v":6.7429012951855736},null,null,"P/E","P/B","EV/EBITDA","P/SALES","YIELD",null,"LongTerm Bond",0.09]
["7 YR",{"$f":"'Calculated Data'!K10-'Calculated Data'!E10","v":570.94000000000005},{"$f":"'Calculated Data'!K33-'Calculated Data'!E33","v":3840.4662198100004},{"$f":"C6/B6","v":6.726567099537605},null,"MIN",{"$f":"MIN('Calculated Data'!B38:K38)","v":-16.06611570247934},{"$f":"MIN('Calculated Data'!B39:K39)","v":0.19265785609397945},{"$f":"MIN('Calculated Data'!B42:K42)","v":2.2429284525790347},{"$f":"MIN('Calculated Data'!B41:K41)","v":0.14660918974137402},{"$f":"MAX('Calculated Data'!B43:K43)","v":7.3456175298804785E-2},null,"LTB Quote",{"$f":"('Profit & Loss'!$L$10/'Data Sheet'!$B$61)/N5","v":45.044643271919803}]
["5 YR",{"$f":"'Calculated Data'!K10-'Calculated Data'!G10","v":515.36},{"$f":"'Calculated Data'!K33-'Calculated Data'!G33","v":3777.1376004900003},{"$f":"C7/B7","v":7.3291244964490847},null,"MAX",{"$f":"MAX('Calculated Data'!B38:K38)","v":23.147191011235954},{"$f":"MAX('Calculated Data'!B39:K39)","v":6.0458829900540234},{"$f":"MAX('Calculated Data'!B42:K42)","v":84.26},{"$f":"MAX('Calculated Data'!B41:K41)","v":1.4169879237848837},{"$f":"MIN('Calculated Data'!B43:K43)","v":0},null,"Equity Quoting @",{"$f":"('Profit & Loss'!$L$6/'Data Sheet'!$B$6)/'Data Sheet'!$B$8","v":5.4214949087426821E-2}]
["3 YR",{"$f":"'Calculated Data'!K10-'Calculated Data'!I10","v":375.17000000000007},{"$f":"'Calculated Data'!K33-'Calculated Data'!I33","v":2381.2102907200001},{"$f":"C8/B8","v":6.3470167943065805},null,"TRAILING",{"$f":"'Data Sheet'!B8/'Profit & Loss'!L13","v":28.357328791335927},{"$f":"'Calculated Data'!L33/'Calculated Data'!K10","v":13.777519283015334},{"$f":"'Calculated Data'!K42","v":10.874296674799275},{"$f":"'Calculated Data'!L33/'Data Sheet'!K17","v":3.2290698440347505},{"$f":"'Data Sheet'!K31/'Calculated Data'!L33","v":3.602694938207945E-3}]
["1 YR",{"$f":"'Calculated Data'!K10-'Calculated Data'!J10","v":217.67000000000007},{"$f":"'Calculated Data'!K33-'Calculated Data'!J33","v":1897.3566433800002},{"$f":"C9/B9","v":8.7166657940000896},null,null,null,null,null,null,null,null," "]
["* IMPACT – Every Rupee retained added xx.yy in incremental market value"]
[]
[{"$f":"A1","v":"AVANTI FEEDS 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.44740670106639846},{"$f":"POWER('Calculated Data'!$K3/'Calculated Data'!$B3, 1/9)-1","v":0.43622949521770993},{"$f":"POWER('Calculated Data'!$K4/'Calculated Data'!$B4, 1/9)-1","v":0.55708072478980131},{"$f":"POWER('Calculated Data'!$K7/'Calculated Data'!$B7, 1/9)-1","v":0.83923428282327128},{"$f":"POWER('Calculated Data'!$K8/'Calculated Data'!$B8, 1/9)-1","v":0.54066626992082023},{"$f":"POWER('Calculated Data'!$K26/'Calculated Data'!$B26, 1/9)-1","v":-2.482841159671846},{"$f":"POWER('Calculated Data'!$K33/'Calculated Data'!$B33, 1/9)-1","v":0.78926108424491415},{"$f":"POWER('Calculated Data'!$K17/'Calculated Data'!$B17, 1/9)-1","v":0.36970580377623419},{"$f":"POWER('Calculated Data'!$K19/'Calculated Data'!$C19, 1/8)-1","v":0.44867152954560119},{"$f":"POWER('Calculated Data'!$K10/'Calculated Data'!$B10, 1/9)-1","v":0.28036676226892099},{"$f":"POWER('Calculated Data'!$K34/'Calculated Data'!$B34, 1/9)-1","v":0.78471658831935343}]
["5 YR CAGR",{"$f":"POWER('Data Sheet'!$K17/'Data Sheet'!$G17, 1/4)-1","v":0.43299919556683952},{"$f":"POWER('Calculated Data'!$K3/'Calculated Data'!$G3, 1/4)-1","v":0.48011409849547038},{"$f":"POWER('Calculated Data'!$K4/'Calculated Data'!$G4, 1/4)-1","v":0.63092266150501297},{"$f":"POWER('Calculated Data'!$K7/'Calculated Data'!$G7, 1/4)-1","v":0.63425473852290026},{"$f":"POWER('Calculated Data'!$K8/'Calculated Data'!$G8, 1/4)-1","v":0.52356023513857597},{"$f":"POWER('Calculated Data'!$K26/'Calculated Data'!$G26, 1/4)-1","v":0.9052681945092671},{"$f":"POWER('Calculated Data'!$K33/'Calculated Data'!$G33, 1/4)-1","v":1.5266622133892516},{"$f":"POWER('Calculated Data'!$K17/'Calculated Data'!$G17, 1/4)-1","v":{"$error":"#NUM!"}},{"$f":"POWER('Calculated Data'!$K19/'Calculated Data'!$G19, 1/4)-1","v":{"$error":"#NUM!"}},{"$f":"POWER('Calculated Data'!$K10/'Calculated Data'!$G10, 1/4)-1","v":0.50421070582928085},{"$f":"POWER('Calculated Data'!$K34/'Calculated Data'!$G34, 1/4)-1","v":1.493983709954517}]
["3 YR CAGR",{"$f":"POWER('Data Sheet'!$K17/'Data Sheet'!$I17, 1/2)-1","v":0.23880314250591805},{"$f":"POWER('Calculated Data'!$K3/'Calculated Data'!$I3, 1/2)-1","v":0.26088819258696794},{"$f":"POWER('Calculated Data'!$K4/'Calculated Data'!$I4, 1/2)-1","v":0.36494541862883478},{"$f":"POWER('Calculated Data'!$K7/'Calculated Data'!$I7, 1/2)-1","v":0.35982354841197495},{"$f":"POWER('Calculated Data'!$K8/'Calculated Data'!$I8, 1/2)-1","v":0.12810376050945793},{"$f":"POWER('Calculated Data'!$K26/'Calculated Data'!$I26, 1/2)-1","v":0.4450014681622787},{"$f":"POWER('Calculated Data'!$K33/'Calculated Data'!$I33, 1/2)-1","v":0.61155964630167703},{"$f":"POWER('Calculated Data'!$K17/'Calculated Data'!$I17, 1/2)-1","v":0.80691530368964925},{"$f":"POWER('Calculated Data'!$K19/'Calculated Data'!$I19, 1/2)-1","v":0.58736139424327694},{"$f":"POWER('Calculated Data'!$K10/'Calculated Data'!$I10, 1/2)-1","v":0.5537658275378019},{"$f":"POWER('Calculated Data'!$K34/'Calculated Data'!$I34, 1/2)-1","v":0.60477370146756027}]
["1 YR GROWTH",{"$f":"('Data Sheet'!$K17-'Data Sheet'!$J17)/'Data Sheet'!$J17","v":0.35394814422109799},{"$f":"('Calculated Data'!$K3-'Calculated Data'!$J3)/'Calculated Data'!$J3","v":0.32988302617184206},{"$f":"('Calculated Data'!$K4-'Calculated Data'!$J4)/'Calculated Data'!$J4","v":0.4076419937075676},{"$f":"('Calculated Data'!$K7-'Calculated Data'!$J7)/'Calculated Data'!$J7","v":0.36095238095238091},{"$f":"('Calculated Data'!$K8-'Calculated Data'!$J8)/'Calculated Data'!$J8","v":0.27261809447558039},{"$f":"('Calculated Data'!$K26-'Calculated Data'!$J26)/'Calculated Data'!$J26","v":0.7116216752728155},{"$f":"('Calculated Data'!$K33-'Calculated Data'!$J33)/'Calculated Data'!$J33","v":0.96078927396913738},{"$f":"('Calculated Data'!$K17-'Calculated Data'!$J17)/'Calculated Data'!$J17","v":1.3909016393442624},{"$f":"('Calculated Data'!$K19-'Calculated Data'!$J19)/'Calculated Data'!$J19","v":2.3136551229140498},{"$f":"('Calculated Data'!$K10-'Calculated Data'!$J10)/'Calculated Data'!$J10","v":0.51484188367747608},{"$f":"('Calculated Data'!$K34-'Calculated Data'!$J34)/'Calculated Data'!$J34","v":0.95219302554813789}]
["**modify (if, then) for negative values"]
[{"$f":"A1","v":"AVANTI FEEDS LTD"},{"$f":"'Data Sheet'!B16","v":"2008-03-31"},{"$f":"'Data Sheet'!C16","v":"2009-03-31"},{"$f":"'Data Sheet'!D16","v":"2010-03-31"},{"$f":"'Data Sheet'!E16","v":"2011-03-31"},{"$f":"'Data Sheet'!F16","v":"2012-03-31"},{"$f":"'Data Sheet'!G16","v":"2013-03-31"},{"$f":"'Data Sheet'!H16","v":"2014-03-31"},{"$f":"'Data Sheet'!I16","v":"2015-03-31"},{"$f":"'Data Sheet'!J16","v":"2016-03-31"},{"$f":"'Data Sheet'!K16","v":"2017-03-31"},"TTM","input TTM BS data in Balance Sheet from Half yearly results"]
["Total Assets/Networth= Financial Leverage",{"$f":"'Calculated Data'!B15/'Calculated Data'!B10","v":1.7266820675714698},{"$f":"'Calculated Data'!C15/'Calculated Data'!C10","v":1.7343612334801763},{"$f":"'Calculated Data'!D15/'Calculated Data'!D10","v":1.714050822122571},{"$f":"'Calculated Data'!E15/'Calculated Data'!E10","v":2.1907364787111621},{"$f":"'Calculated Data'!F15/'Calculated Data'!F10","v":1.9572695224869139},{"$f":"'Calculated Data'!G15/'Calculated Data'!G10","v":1.9894484412470024},{"$f":"'Calculated Data'!H15/'Calculated Data'!H10","v":2.2242579495461379},{"$f":"'Calculated Data'!I15/'Calculated Data'!I10","v":1.8010102152361569},{"$f":"'Calculated Data'!J15/'Calculated Data'!J10","v":1.4725986896568037},{"$f":"'Calculated Data'!K15/'Calculated Data'!K10","v":1.6495487618274365},{"$f":"'Balance Sheet'!L8/'Calculated Data'!L10","v":{"$error":"#DIV/0!"}}]
["Long term debt/Earning",{"$f":"'Data Sheet'!B59/'Data Sheet'!B30","v":45.685393258426963},{"$f":"'Data Sheet'!C59/'Data Sheet'!C30","v":-5.4314285714285715},{"$f":"'Data Sheet'!D59/'Data Sheet'!D30","v":-28.206611570247937},{"$f":"'Data Sheet'!E59/'Data Sheet'!E30","v":16.017647058823531},{"$f":"'Data Sheet'!F59/'Data Sheet'!F30","v":1.7672014260249553},{"$f":"'Data Sheet'!G59/'Data Sheet'!G30","v":2.0326123128119797},{"$f":"'Data Sheet'!H59/'Data Sheet'!H30","v":0.79704587416560146},{"$f":"'Data Sheet'!I59/'Data Sheet'!I30","v":0.50379572118702554},{"$f":"'Data Sheet'!J59/'Data Sheet'!J30","v":6.8000000000000005E-2},{"$f":"'Data Sheet'!K59/'Data Sheet'!K30","v":9.0646139491485894E-2}]
["Current liablility/Earning",{"$f":"'Data Sheet'!B60/'Data Sheet'!B30","v":10.865168539325843},{"$f":"'Data Sheet'!C60/'Data Sheet'!C30","v":-1.7128571428571429},{"$f":"'Data Sheet'!D60/'Data Sheet'!D30","v":-11.272727272727273},{"$f":"'Data Sheet'!E60/'Data Sheet'!E30","v":8.329411764705883},{"$f":"'Data Sheet'!F60/'Data Sheet'!F30","v":1.4274509803921569},{"$f":"'Data Sheet'!G60/'Data Sheet'!G30","v":2.0865224625623959},{"$f":"'Data Sheet'!H60/'Data Sheet'!H30","v":2.3252378923448376},{"$f":"'Data Sheet'!I60/'Data Sheet'!I30","v":1.3293650793650793},{"$f":"'Data Sheet'!J60/'Data Sheet'!J30","v":1.2006349206349205},{"$f":"'Data Sheet'!K60/'Data Sheet'!K30","v":1.8501516211803126}]
["Total liability/Earning",{"$f":"('Data Sheet'!B59+'Data Sheet'!B60)/'Data Sheet'!B30","v":56.550561797752806},{"$f":"('Data Sheet'!C59+'Data Sheet'!C60)/'Data Sheet'!C30","v":-7.144285714285715},{"$f":"('Data Sheet'!D59+'Data Sheet'!D60)/'Data Sheet'!D30","v":-39.47933884297521},{"$f":"('Data Sheet'!E59+'Data Sheet'!E60)/'Data Sheet'!E30","v":24.347058823529412},{"$f":"('Data Sheet'!F59+'Data Sheet'!F60)/'Data Sheet'!F30","v":3.194652406417112},{"$f":"('Data Sheet'!G59+'Data Sheet'!G60)/'Data Sheet'!G30","v":4.1191347753743761},{"$f":"('Data Sheet'!H59+'Data Sheet'!H60)/'Data Sheet'!H30","v":3.122283766510439},{"$f":"('Data Sheet'!I59+'Data Sheet'!I60)/'Data Sheet'!I30","v":1.833160800552105},{"$f":"('Data Sheet'!J59+'Data Sheet'!J60)/'Data Sheet'!J30","v":1.2686349206349206},{"$f":"('Data Sheet'!K59+'Data Sheet'!K60)/'Data Sheet'!K30","v":1.9407977606717985}]
["Debt/Equity",{"$f":"'Data Sheet'!B59/'Calculated Data'!B10","v":0.58706323996534782},{"$f":"'Data Sheet'!C59/'Calculated Data'!C10","v":0.55829662261380331},{"$f":"'Data Sheet'!D59/'Calculated Data'!D10","v":0.5101644245142003},{"$f":"'Data Sheet'!E59/'Calculated Data'!E10","v":0.78337169159953957},{"$f":"'Data Sheet'!F59/'Calculated Data'!F10","v":0.52953744258092084},{"$f":"'Data Sheet'!G59/'Calculated Data'!G10","v":0.48824940047961629},{"$f":"'Data Sheet'!H59/'Calculated Data'!H10","v":0.31252436375786596},{"$f":"'Data Sheet'!I59/'Calculated Data'!I10","v":0.22013645444607791},{"$f":"'Data Sheet'!J59/'Calculated Data'!J10","v":2.5331724969843188E-2},{"$f":"'Data Sheet'!K59/'Calculated Data'!K10","v":3.0337569871654747E-2}]
["Interest Coverage",{"$f":"'Calculated Data'!B4/'Data Sheet'!B27","v":1.264},{"$f":"'Calculated Data'!C4/'Data Sheet'!C27","v":-0.4005641748942172},{"$f":"'Calculated Data'!D4/'Data Sheet'!D27","v":0.26837060702875398},{"$f":"'Calculated Data'!E4/'Data Sheet'!E27","v":2.1500000000000004},{"$f":"'Calculated Data'!F4/'Data Sheet'!F27","v":10.830466830466829},{"$f":"'Calculated Data'!G4/'Data Sheet'!G27","v":12.260204081632654},{"$f":"'Calculated Data'!H4/'Data Sheet'!H27","v":24.956719817767656},{"$f":"'Calculated Data'!I4/'Data Sheet'!I27","v":68.355805243445687},{"$f":"'Calculated Data'!J4/'Data Sheet'!J27","v":71.467455621301781},{"$f":"'Calculated Data'!K4/'Data Sheet'!K27","v":70.109278350515481}]
["Working Capital/Sales",{"$f":"'Calculated Data'!B11/'Data Sheet'!B17","v":0.4950515253545556},{"$f":"'Calculated Data'!C11/'Data Sheet'!C17","v":0.70076468042129558},{"$f":"'Calculated Data'!D11/'Data Sheet'!D17","v":0.45706794843784132},{"$f":"'Calculated Data'!E11/'Data Sheet'!E17","v":0.24832731648616124},{"$f":"'Calculated Data'!F11/'Data Sheet'!F17","v":0.1363717241554612},{"$f":"'Calculated Data'!G11/'Data Sheet'!G17","v":0.15256774273193013},{"$f":"'Calculated Data'!H11/'Data Sheet'!H17","v":9.9910746635324871E-2},{"$f":"'Calculated Data'!I11/'Data Sheet'!I17","v":6.9092359012950258E-2},{"$f":"'Calculated Data'!J11/'Data Sheet'!J17","v":0.12621575690312095},{"$f":"'Calculated Data'!K11/'Data Sheet'!K17","v":2.321547503165414E-2},null,"Check for improving or deteriorating picture"]
["Inventory Turns",{"$f":"365/B27","v":3.6707865168539326},3.4008832188420022,3.3568023469013566,5.3201024327784889,9.3335705812574155,6.6698229724166325,5.6821993472257093,8.020268444284298,7.0680791455086673,7.6824852403710988]
["Inventory Days",{"$f":"'Balance Sheet'!B22","v":99.433731251913073},{"$f":"'Balance Sheet'!C22","v":107.32506131871303},{"$f":"'Balance Sheet'!D22","v":108.73443303473891},{"$f":"'Balance Sheet'!E22","v":68.607701564380264},{"$f":"'Balance Sheet'!F22","v":39.106148801504787},{"$f":"'Balance Sheet'!G22","v":54.724091105487318},{"$f":"'Balance Sheet'!H22","v":64.235690741509885},{"$f":"'Balance Sheet'!I22","v":45.509698651061967},{"$f":"'Balance Sheet'!J22","v":51.640621516234042},{"$f":"'Balance Sheet'!K22","v":47.510667261935261}]
["Debtor Days",{"$f":"'Balance Sheet'!B23","v":50.424446485052542},{"$f":"'Balance Sheet'!C23","v":83.521858317703078},{"$f":"'Balance Sheet'!D23","v":35.606838540528727},{"$f":"'Balance Sheet'!E23","v":40.075330926594468},{"$f":"'Balance Sheet'!F23","v":14.389949416639128},{"$f":"'Balance Sheet'!G23","v":22.37739954323807},{"$f":"'Balance Sheet'!H23","v":14.521168953968242},{"$f":"'Balance Sheet'!I23","v":6.8791347028629835},{"$f":"'Balance Sheet'!J23","v":6.3241902798904022},{"$f":"'Balance Sheet'!K23","v":3.1402186880182685}]
["Creditor Days",{"$f":"'Balance Sheet'!B24","v":0},{"$f":"'Balance Sheet'!C24","v":0},{"$f":"'Balance Sheet'!D24","v":0},{"$f":"'Balance Sheet'!E24","v":0},{"$f":"'Balance Sheet'!F24","v":0},{"$f":"'Balance Sheet'!G24","v":0},{"$f":"'Balance Sheet'!H24","v":0},{"$f":"'Balance Sheet'!I24","v":0},{"$f":"'Balance Sheet'!J24","v":0},{"$f":"'Balance Sheet'!K24","v":0},null,"Check back to see if Creditor policy change is impacting Working Cap cycle"]
["Cash Conversion Cycle",{"$f":"'Balance Sheet'!B25","v":0},{"$f":"'Balance Sheet'!C25","v":0},{"$f":"'Balance Sheet'!D25","v":0},{"$f":"'Balance Sheet'!E25","v":0},{"$f":"'Balance Sheet'!F25","v":0},{"$f":"'Balance Sheet'!G25","v":0},{"$f":"'Balance Sheet'!H25","v":0},{"$f":"'Balance Sheet'!I25","v":0},{"$f":"'Balance Sheet'!J25","v":0},{"$f":"'Balance Sheet'!K25","v":0}]
["Cash In/Cash Out Ratio",{"$f":"('Data Sheet'!B67+'Data Sheet'!B69)/'Data Sheet'!B60","v":1.8128231644260602},{"$f":"('Data Sheet'!C67+'Data Sheet'!C69)/'Data Sheet'!C60","v":2.0742285237698077},{"$f":"('Data Sheet'!D67+'Data Sheet'!D69)/'Data Sheet'!D60","v":0.90542521994134895},{"$f":"('Data Sheet'!E67+'Data Sheet'!E69)/'Data Sheet'!E60","v":0.96645480225988689},{"$f":"('Data Sheet'!F67+'Data Sheet'!F69)/'Data Sheet'!F60","v":0.93806193806193816},{"$f":"('Data Sheet'!G67+'Data Sheet'!G69)/'Data Sheet'!G60","v":0.77065390749601259},{"$f":"('Data Sheet'!H67+'Data Sheet'!H69)/'Data Sheet'!H60","v":0.35353041778646471},{"$f":"('Data Sheet'!I67+'Data Sheet'!I69)/'Data Sheet'!I60","v":0.25775470473718365},{"$f":"('Data Sheet'!J67+'Data Sheet'!J69)/'Data Sheet'!J60","v":0.56869381279746167},{"$f":"('Data Sheet'!K67+'Data Sheet'!K69)/'Data Sheet'!K60","v":0.17305461697513741},null,"  "]
["Current Ratio",{"$f":"'Data Sheet'!B65/'Data Sheet'!B60","v":6.0175801447776625},{"$f":"'Data Sheet'!C65/'Data Sheet'!C60","v":5.0508757297748126},{"$f":"'Data Sheet'!D65/'Data Sheet'!D60","v":4.0674486803519061},{"$f":"'Data Sheet'!E65/'Data Sheet'!E60","v":2.821680790960452},{"$f":"'Data Sheet'!F65/'Data Sheet'!F60","v":2.3399100899100898},{"$f":"'Data Sheet'!G65/'Data Sheet'!G60","v":2.5768740031897925},{"$f":"'Data Sheet'!H65/'Data Sheet'!H60","v":1.6905692645980941},{"$f":"'Data Sheet'!I65/'Data Sheet'!I60","v":1.7983776768332251},{"$f":"'Data Sheet'!J65/'Data Sheet'!J60","v":2.3471179270227394},{"$f":"'Data Sheet'!K65/'Data Sheet'!K60","v":1.1599677240405466}," "]
["CFO/PAT",{"$f":"'Calculated Data'!B17/'Calculated Data'!B7","v":19.314606741573034},{"$f":"'Calculated Data'!C17/'Calculated Data'!C7","v":-1.3342857142857143},{"$f":"'Calculated Data'!D17/'Calculated Data'!D7","v":-3.2396694214876032},{"$f":"'Calculated Data'!E17/'Calculated Data'!E7","v":-2.2705882352941176},{"$f":"'Calculated Data'!F17/'Calculated Data'!F7","v":1.7960784313725491},{"$f":"'Calculated Data'!G17/'Calculated Data'!G7","v":-0.68386023294509157},{"$f":"'Calculated Data'!H17/'Calculated Data'!H7","v":0.78909245845760556},{"$f":"'Calculated Data'!I17/'Calculated Data'!I7","v":0.77070393374741197},{"$f":"'Calculated Data'!J17/'Calculated Data'!J7","v":0.77460317460317463},{"$f":"'Calculated Data'!K17/'Calculated Data'!K7","v":1.3608117564730582}]
[null,null,null,null,null,null,null,null,null,null,null," "]
["Gross Margin =Gross Profit/Sales",{"$f":"'Calculated Data'!B3/'Data Sheet'!B17","v":0.24803591470258138},{"$f":"'Calculated Data'!C3/'Data Sheet'!C17","v":0.27918049343529072},{"$f":"'Calculated Data'!D3/'Data Sheet'!D17","v":0.15293860607384749},{"$f":"'Calculated Data'!E3/'Data Sheet'!E17","v":0.17395908543922978},{"$f":"'Calculated Data'!F3/'Data Sheet'!F17","v":0.30116163798581636},{"$f":"'Calculated Data'!G3/'Data Sheet'!G17","v":0.20324362693660875},{"$f":"'Calculated Data'!H3/'Data Sheet'!H17","v":0.22022604961073156},{"$f":"'Calculated Data'!I3/'Data Sheet'!I17","v":0.22328799433917768},{"$f":"'Calculated Data'!J3/'Data Sheet'!J17","v":0.23550629493283917},{"$f":"'Calculated Data'!K3/'Data Sheet'!K17","v":0.23132039843961558}]
["EBIT/Sales",{"$f":"'Calculated Data'!B4/'Data Sheet'!B17","v":6.448321599836751E-2},{"$f":"'Calculated Data'!C4/'Data Sheet'!C17","v":-4.0975328235463855E-2},{"$f":"'Calculated Data'!D4/'Data Sheet'!D17","v":9.1763163644308469E-3},{"$f":"'Calculated Data'!E4/'Data Sheet'!E17","v":4.7605294825511436E-2},{"$f":"'Calculated Data'!F4/'Data Sheet'!F17","v":0.11204595714394651},{"$f":"'Calculated Data'!G4/'Data Sheet'!G17","v":7.4162088759953101E-2},{"$f":"'Calculated Data'!H4/'Data Sheet'!H17","v":9.6817808255494395E-2},{"$f":"'Calculated Data'!I4/'Data Sheet'!I17","v":0.10249570384014915},{"$f":"'Calculated Data'!J4/'Data Sheet'!J17","v":0.11968547631906218},{"$f":"'Calculated Data'!K4/'Data Sheet'!K17","v":0.12443187224169858},{"$f":"'Calculated Data'!L4/'Profit & Loss'!L4","v":0.16409966748366839}]
["EBITDA/Sales",{"$f":"'Calculated Data'!B5/'Data Sheet'!B17","v":0.10407101316192224},{"$f":"'Calculated Data'!C5/'Data Sheet'!C17","v":7.2139662386380031E-3},{"$f":"'Calculated Data'!D5/'Data Sheet'!D17","v":3.9545553856237703E-2},{"$f":"'Calculated Data'!E5/'Data Sheet'!E17","v":6.1564380264741279E-2},{"$f":"'Calculated Data'!F5/'Data Sheet'!F17","v":0.12221346686662768},{"$f":"'Calculated Data'!G5/'Data Sheet'!G17","v":8.1846799580272842E-2},{"$f":"'Calculated Data'!H5/'Data Sheet'!H17","v":0.10171348786242612},{"$f":"'Calculated Data'!I5/'Data Sheet'!I17","v":0.10743769164242471},{"$f":"'Calculated Data'!J5/'Data Sheet'!J17","v":0.12475412354022464},{"$f":"'Calculated Data'!K5/'Data Sheet'!K17","v":0.12944164294130994}]
["Op Profit (Ex Other Income)/Sales",{"$f":"'Calculated Data'!B6/'Data Sheet'!B17","v":1.469237832874196E-2},{"$f":"'Calculated Data'!C6/'Data Sheet'!C17","v":-5.4393305439330533E-2},{"$f":"'Calculated Data'!D6/'Data Sheet'!D17","v":-7.723399606729299E-2},{"$f":"'Calculated Data'!E6/'Data Sheet'!E17","v":4.1636582430806271E-2},{"$f":"'Calculated Data'!F6/'Data Sheet'!F17","v":0.11369817747388219},{"$f":"'Calculated Data'!G6/'Data Sheet'!G17","v":7.7865563854083095E-2},{"$f":"'Calculated Data'!H6/'Data Sheet'!H17","v":9.8461484080204317E-2},{"$f":"'Calculated Data'!I6/'Data Sheet'!I17","v":0.10237215414509226},{"$f":"'Calculated Data'!J6/'Data Sheet'!J17","v":0.11410649609322743},{"$f":"'Calculated Data'!K6/'Data Sheet'!K17","v":0.12143845191132452}]
["Net Margin =PAT/Sales",{"$f":"'Calculated Data'!B7/'Data Sheet'!B17","v":9.0807060504030195E-3},{"$f":"'Calculated Data'!C7/'Data Sheet'!C17","v":-0.10099552734093203},{"$f":"'Calculated Data'!D7/'Data Sheet'!D17","v":-1.3218265239239675E-2},{"$f":"'Calculated Data'!E7/'Data Sheet'!E17","v":1.6365824308062576E-2},{"$f":"'Calculated Data'!F7/'Data Sheet'!F17","v":7.1299661930301725E-2},{"$f":"'Calculated Data'!G7/'Data Sheet'!G17","v":4.6370594407752611E-2},{"$f":"'Calculated Data'!H7/'Data Sheet'!H17","v":6.2221083235390287E-2},{"$f":"'Calculated Data'!I7/'Data Sheet'!I17","v":6.50994575045208E-2},{"$f":"'Calculated Data'!J7/'Data Sheet'!J17","v":7.8036357510565882E-2},{"$f":"'Calculated Data'!K7/'Data Sheet'!K17","v":7.8440054745193333E-2},{"$f":"'Calculated Data'!L7/'Profit & Loss'!L4","v":0.1046199261000104}]
["Op Cash Flow/Sales",{"$f":"'Calculated Data'!B17/'Data Sheet'!B17","v":0.17539026629935722},{"$f":"'Calculated Data'!C17/'Data Sheet'!C17","v":0.1347568893377579},{"$f":"'Calculated Data'!D17/'Data Sheet'!D17","v":4.2822809700677297E-2},{"$f":"'Calculated Data'!E17/'Data Sheet'!E17","v":-3.7160048134777378E-2},{"$f":"'Calculated Data'!F17/'Data Sheet'!F17","v":0.12805978495716935},{"$f":"'Calculated Data'!G17/'Data Sheet'!G17","v":-3.1711005493488056E-2},{"$f":"'Calculated Data'!H17/'Data Sheet'!H17","v":4.9098187538109427E-2},{"$f":"'Calculated Data'!I17/'Data Sheet'!I17","v":5.0172407983556655E-2},{"$f":"'Calculated Data'!J17/'Data Sheet'!J17","v":6.0447210262152613E-2},{"$f":"'Calculated Data'!K17/'Data Sheet'!K17","v":0.10674214867564938}]
["Free Cash Flow/Sales",{"$f":"'Calculated Data'!B19/'Data Sheet'!B17","v":0},{"$f":"'Calculated Data'!C19/'Data Sheet'!C17","v":0.13735391718366757},{"$f":"'Calculated Data'!D19/'Data Sheet'!D17","v":3.6377539873279456E-2},{"$f":"'Calculated Data'!E19/'Data Sheet'!E17","v":-9.9446450060168473E-2},{"$f":"'Calculated Data'!F19/'Data Sheet'!F17","v":0.10045499606008997},{"$f":"'Calculated Data'!G19/'Data Sheet'!G17","v":-5.1246836615023765E-2},{"$f":"'Calculated Data'!H19/'Data Sheet'!H17","v":1.7797651134224692E-2},{"$f":"'Calculated Data'!I19/'Data Sheet'!I17","v":4.1158896139633631E-2},{"$f":"'Calculated Data'!J19/'Data Sheet'!J17","v":2.7612483835325947E-2},{"$f":"'Calculated Data'!K19/'Data Sheet'!K17","v":6.7578842592931426E-2}]
["EPA/Sales",{"$f":"'Calculated Data'!B26/'Data Sheet'!B17","v":-5.7030791539515124E-2},{"$f":"'Calculated Data'!C26/'Data Sheet'!C17","v":-0.16500381039807871},{"$f":"'Calculated Data'!D26/'Data Sheet'!D17","v":-8.6521271632512262E-2},{"$f":"'Calculated Data'!E26/'Data Sheet'!E17","v":-1.9924114477057497E-2},{"$f":"'Calculated Data'!F26/'Data Sheet'!F17","v":4.8535050345595888E-2},{"$f":"'Calculated Data'!G26/'Data Sheet'!G17","v":2.2688469251829511E-2},{"$f":"'Calculated Data'!H26/'Data Sheet'!H17","v":4.3491927808943606E-2},{"$f":"'Calculated Data'!I26/'Data Sheet'!I17","v":5.2109139325384295E-2},{"$f":"'Calculated Data'!J26/'Data Sheet'!J17","v":5.6084148916467756E-2},{"$f":"'Calculated Data'!K26/'Data Sheet'!K17","v":7.0899942020954357E-2}]
["EPA/Sales Increase - last 5 Years",null,null,null,null,{"$f":"(F42-B42)","v":0.10556584188511101},{"$f":"(G42-C42)","v":0.18769227964990823},0.13001319944145587,7.2033253802441799E-2,7.5490985708718678E-3,4.8211472769124845E-2]
["EPA/Sales Increase - last 3 Years",null,null,{"$f":"(D42-B42)","v":-2.9490480092997137E-2},{"$f":"(E42-C42)","v":0.14507969592102121},0.13505632197810816,4.2612583728887009E-2,-5.0431225366522822E-3,2.9420670073554783E-2,1.259222110752415E-2,1.8790802695570062E-2]
["MktCap Cagr  - last 5 years",null,null,null,null,{"$f":"POWER('Calculated Data'!F33/'Calculated Data'!B33, 1/4)-1","v":0.40518611388173031},{"$f":"POWER('Calculated Data'!G33/'Calculated Data'!C33, 1/4)-1","v":0.64042845114339797},{"$f":"POWER('Calculated Data'!H33/'Calculated Data'!D33, 1/4)-1","v":1.2968442789712076},{"$f":"POWER('Calculated Data'!I33/'Calculated Data'!E33, 1/4)-1","v":1.619198732690986},{"$f":"POWER('Calculated Data'!J33/'Calculated Data'!F33, 1/4)-1","v":1.2267644621293843},{"$f":"POWER('Calculated Data'!K33/'Calculated Data'!G33, 1/4)-1","v":1.5266622133892516}]
["MktCap Cagr  - last 3 years",null,null,{"$f":"POWER('Calculated Data'!D33/'Calculated Data'!B33, 1/2)-1","v":-2.8586847705441065E-2},{"$f":"POWER('Calculated Data'!E33/'Calculated Data'!C33, 1/2)-1","v":0.55390931084843675},{"$f":"POWER('Calculated Data'!F33/'Calculated Data'!D33, 1/2)-1","v":1.0326552198536656},{"$f":"POWER('Calculated Data'!G33/'Calculated Data'!E33, 1/2)-1","v":0.7317648362962923},{"$f":"POWER('Calculated Data'!H33/'Calculated Data'!F33, 1/2)-1","v":1.5953706217931827},{"$f":"POWER('Calculated Data'!I33/'Calculated Data'!G33, 1/2)-1","v":2.9613935203823107},{"$f":"POWER('Calculated Data'!J33/'Calculated Data'!H33, 1/2)-1","v":0.91050940014743409},{"$f":"POWER('Calculated Data'!K33/'Calculated Data'!I33, 1/2)-1","v":0.61155964630167703}]
[]
[]
["Sales/Invested Capital =Capital Turns",{"$f":"'Data Sheet'!B17/'Calculated Data'!B13","v":1.1939334876355221},{"$f":"'Data Sheet'!C17/'Calculated Data'!C13","v":0.88158229458153137},{"$f":"'Data Sheet'!D17/'Calculated Data'!D13","v":1.313342898134864},{"$f":"'Data Sheet'!E17/'Calculated Data'!E13","v":2.3214884344619513},{"$f":"'Data Sheet'!F17/'Calculated Data'!F13","v":3.9976628391423641},{"$f":"'Data Sheet'!G17/'Calculated Data'!G13","v":4.2828629964972569},{"$f":"'Data Sheet'!H17/'Calculated Data'!H13","v":5.7918415395639267},{"$f":"'Data Sheet'!I17/'Calculated Data'!I13","v":8.3756349952963323},{"$f":"'Data Sheet'!J17/'Calculated Data'!J13","v":5.0413138503809174},{"$f":"'Data Sheet'!K17/'Calculated Data'!K13","v":9.0371717706197501}]
["Sales/Fixed Assets= Fixed Asset Turns",{"$f":"'Data Sheet'!B17/'Data Sheet'!B62","v":2.9317977864193838},{"$f":"'Data Sheet'!C17/'Data Sheet'!C62","v":2.3064891846921798},{"$f":"'Data Sheet'!D17/'Data Sheet'!D62","v":3.285714285714286},{"$f":"'Data Sheet'!E17/'Data Sheet'!E62","v":7.7576549663928303},{"$f":"'Data Sheet'!F17/'Data Sheet'!F62","v":9.1299605476908798},{"$f":"'Data Sheet'!G17/'Data Sheet'!G62","v":12.744149459193705},{"$f":"'Data Sheet'!H17/'Data Sheet'!H62","v":14.599535543800798},{"$f":"'Data Sheet'!I17/'Data Sheet'!I62","v":19.880093781400024},{"$f":"'Data Sheet'!J17/'Data Sheet'!J62","v":19.408500817386287},{"$f":"'Data Sheet'!K17/'Data Sheet'!K62","v":17.029102012837289}]
["Sales/Total Assets= Asset Turns",{"$f":"'Data Sheet'!B17/'Calculated Data'!B15","v":0.81955012960949913},{"$f":"'Data Sheet'!C17/'Calculated Data'!C15","v":0.58682584031834728},{"$f":"'Data Sheet'!D17/'Calculated Data'!D15","v":0.79829074736199535},{"$f":"'Data Sheet'!E17/'Calculated Data'!E15","v":1.3640840446487195},{"$f":"'Data Sheet'!F17/'Calculated Data'!F15","v":2.1472000873267114},{"$f":"'Data Sheet'!G17/'Calculated Data'!G15","v":2.6038251366120218},{"$f":"'Data Sheet'!H17/'Calculated Data'!H15","v":2.8332039758643996},{"$f":"'Data Sheet'!I17/'Calculated Data'!I15","v":3.7268674522279661},{"$f":"'Data Sheet'!J17/'Calculated Data'!J15","v":3.241712174751044},{"$f":"'Data Sheet'!K17/'Calculated Data'!K15","v":2.5865949814003235},{"$f":"'Profit & Loss'!L4/'Balance Sheet'!L8","v":{"$error":"#DIV/0!"}}]
["Net Margin*Asset Turns= RoA",{"$f":"B39*B51","v":7.4420938205535577E-3},{"$f":"C39*C51","v":-5.9266785200237058E-2},-1.0552018836661724E-2,2.2324359816152328E-2,0.15309464032310888,0.12074091931854709,0.1762850204050975,0.24261704933129619,0.25297141021522651,0.2028926519446837,{"$f":"L39*L51","v":{"$error":"#DIV/0!"}},"Check back what is really driving RoA (Net Margins or Asset Turns, or both)"]
["Net Margin*Asset Turn*Fin Leverage= RoE",{"$f":"B39*B51*B19","v":1.2850129945134276E-2},-0.10279001468428781,-1.8086696562032885E-2,4.8906789413118518E-2,0.29964747356051713,0.2402078337330136,0.39210335802194124,0.43695578423611903,0.37252536720357632,0.33468132279923801,{"$f":"L39*L51*L19","v":{"$error":"#DIV/0!"}},"Check back what is really driving RoE (Net Margins, Asset Turns, or Financial Leverage)"]
["RoCE",{"$f":"'Calculated Data'!B4/'Calculated Data'!B14","v":5.7496360989810771E-2},{"$f":"'Calculated Data'!C4/'Calculated Data'!C14","v":-2.6762156049754991E-2},{"$f":"'Calculated Data'!D4/'Calculated Data'!D14","v":8.3143620706720763E-3},{"$f":"'Calculated Data'!E4/'Calculated Data'!E14","v":7.977093079528956E-2},{"$f":"'Calculated Data'!F4/'Calculated Data'!F14","v":0.30786422684732501},{"$f":"'Calculated Data'!G4/'Calculated Data'!G14","v":0.25813728649693846},{"$f":"'Calculated Data'!H4/'Calculated Data'!H14","v":0.46484789341932192},{"$f":"'Calculated Data'!I4/'Calculated Data'!I14","v":0.5638419475424018},{"$f":"'Calculated Data'!J4/'Calculated Data'!J14","v":0.55723183391003472},{"$f":"'Calculated Data'!K4/'Calculated Data'!K14","v":0.51528285017199837}]
["EBIT Margin*Cap Turns*(1-Tax rate)= RoIC",{"$f":"B36*B49*(1-'Calculated Data'!B22)","v":5.1909028154612277E-2},{"$f":"C36*C49*(1-'Calculated Data'!C22)","v":-2.5464437785434186E-2},{"$f":"D36*D49*(1-'Calculated Data'!D22)","v":6.3679023638425437E-3},{"$f":"E36*E49*(1-'Calculated Data'!E22)","v":7.3746398674615091E-2},{"$f":"F36*F49*(1-'Calculated Data'!F22)","v":0.3140267671624925},{"$f":"G36*G49*(1-'Calculated Data'!G22)","v":0.21717160540582642},{"$f":"H36*H49*(1-'Calculated Data'!H22)","v":0.37189835411955513},{"$f":"I36*I49*(1-'Calculated Data'!I22)","v":0.55644713090846099},{"$f":"J36*J49*(1-'Calculated Data'!J22)","v":0.40273779671941484},{"$f":"K36*K49*(1-'Calculated Data'!K22)","v":0.76073495457034568},{"$f":"'Business Robustness'!L14*'Business Robustness'!L16*(1-'Calculated Data'!K22)","v":{"$error":"#DIV/0!"}},"Check back what is really driving RoIC (Op Margins or Capital Turns, or both)"]
["Return on Incremental Invested Cap= RoIIC",null,null,{"$f":"'Calculated Data'!D27","v":-0.70485789436618496},{"$f":"'Calculated Data'!E27","v":-0.69010341060890901},{"$f":"'Calculated Data'!F27","v":1.2280853430555618},{"$f":"'Calculated Data'!G27","v":0.21937908716308449},{"$f":"'Calculated Data'!H27","v":0.75238685848625864},{"$f":"'Calculated Data'!I27","v":1.0356060722319065},{"$f":"'Calculated Data'!J27","v":2.4933459283088792},{"$f":"'Calculated Data'!K27","v":0.36641788892869992}]
[{"$f":"'Calculated Data'!A28","v":"3Yr Rolling RoIIC "},null,null,null,null,null,{"$f":"'Calculated Data'!G28","v":1.6380188387668411},{"$f":"'Calculated Data'!H28","v":0.80948333795475269},{"$f":"'Calculated Data'!I28","v":0.82535920176294175},{"$f":"'Calculated Data'!J28","v":1.1242301541523958},{"$f":"'Calculated Data'!K28","v":0.63190465441335697},null,"better to check when NOPLAT and/or Investments are Lumpy"]
[{"$f":"'Calculated Data'!A29","v":"5Yr Rolling RoIIC"},null,null,null,null,null,{"$f":"'Calculated Data'!G29","v":0},{"$f":"'Calculated Data'!H29","v":1.0786407761711863},{"$f":"'Calculated Data'!I29","v":1.0093937755770723},{"$f":"'Calculated Data'!J29","v":1.0821309426118011},{"$f":"'Calculated Data'!K29","v":0.64057022906298733},null,"better to check when NOPLAT and/or Investments are Lumpy"]
[]
["Altman Z-Score",{"$f":"'Calculated Data'!B50","v":1.5869771720043482},{"$f":"'Calculated Data'!C50","v":0.98462450258233847},{"$f":"'Calculated Data'!D50","v":1.3472573471701406},{"$f":"'Calculated Data'!E50","v":2.133571897570584},{"$f":"'Calculated Data'!F50","v":3.7247898701015174},{"$f":"'Calculated Data'!G50","v":4.0826790886853104},{"$f":"'Calculated Data'!H50","v":5.0898946897623993},{"$f":"'Calculated Data'!I50","v":7.4351839876389203},{"$f":"'Calculated Data'!J50","v":7.2141467167651783},{"$f":"'Calculated Data'!K50","v":6.161801785082397}]
["Dividend Payout",{"$f":"'Data Sheet'!B31/'Data Sheet'!B30","v":0.7303370786516854},{"$f":"'Data Sheet'!C31/'Data Sheet'!C30","v":0},{"$f":"'Data Sheet'!D31/'Data Sheet'!D30","v":0},{"$f":"'Data Sheet'!E31/'Data Sheet'!E30","v":0.23529411764705885},{"$f":"'Data Sheet'!F31/'Data Sheet'!F30","v":0.21033868092691624},{"$f":"'Data Sheet'!G31/'Data Sheet'!G30","v":0.19633943427620634},{"$f":"'Data Sheet'!H31/'Data Sheet'!H30","v":0.19343843204090327},{"$f":"'Data Sheet'!I31/'Data Sheet'!I30","v":0.21549344375431331},{"$f":"'Data Sheet'!J31/'Data Sheet'!J30","v":0.15860317460317461},{"$f":"'Data Sheet'!K31/'Data Sheet'!K30","v":0.14830884068112898}]
["Cash/Assets",{"$f":"'Data Sheet'!B69/'Data Sheet'!B61","v":3.3363993644953592E-2},{"$f":"'Data Sheet'!C69/'Data Sheet'!C61","v":7.6284819236305132E-2},{"$f":"'Data Sheet'!D69/'Data Sheet'!D61","v":2.9824714397837272E-2},{"$f":"'Data Sheet'!E69/'Data Sheet'!E61","v":2.9940906106369004E-2},{"$f":"'Data Sheet'!F69/'Data Sheet'!F61","v":0.12034712367645455},{"$f":"'Data Sheet'!G69/'Data Sheet'!G61","v":3.4514625522340081E-2},{"$f":"'Data Sheet'!H69/'Data Sheet'!H61","v":3.2197491299667008E-2},{"$f":"'Data Sheet'!I69/'Data Sheet'!I61","v":1.2892693442725884E-2},{"$f":"'Data Sheet'!J69/'Data Sheet'!J61","v":0.11655958882107291},{"$f":"'Data Sheet'!K69/'Data Sheet'!K61","v":4.2708264314178346E-2}]
["EBIT/Invested Capital",{"$f":"'Calculated Data'!B4/'Calculated Data'!B13","v":7.6988670970885617E-2},{"$f":"'Calculated Data'!C4/'Calculated Data'!C13","v":-3.6123123887051634E-2},{"$f":"'Calculated Data'!D4/'Calculated Data'!D13","v":1.2051649928263988E-2},{"$f":"'Calculated Data'!E4/'Calculated Data'!E13","v":0.11051514135657617},{"$f":"'Calculated Data'!F4/'Calculated Data'!F13","v":0.44792195915049282},{"$f":"'Calculated Data'!G4/'Calculated Data'!G13","v":0.31762606569294827},{"$f":"'Calculated Data'!H4/'Calculated Data'!H13","v":0.56075340362370762},{"$f":"'Calculated Data'!I4/'Calculated Data'!I13","v":0.85846660395108187},{"$f":"'Calculated Data'!J4/'Calculated Data'!J13","v":0.6033720494567254},{"$f":"'Calculated Data'!K4/'Calculated Data'!K13","v":1.1245122031880417},null,"Check back the significant role of EBIT/Invested Capital "]
["EPA",{"$f":"'Calculated Data'!B26","v":-5.5895878787878779},{"$f":"'Calculated Data'!C26","v":-11.436414098690836},{"$f":"'Calculated Data'!D26","v":-7.920157205240173},{"$f":"'Calculated Data'!E26","v":-4.1392347826086953},{"$f":"'Calculated Data'!F26","v":19.09417415646088},{"$f":"'Calculated Data'!G26","v":14.703035613955596},{"$f":"'Calculated Data'!H26","v":49.215900427878672},{"$f":"'Calculated Data'!I26","v":92.788660031138804},{"$f":"'Calculated Data'!J26","v":113.1940769166177},{"$f":"'Calculated Data'!K26","v":193.74543556298113},null,"Check back what is really driving EPA (Invested Capital or RoIC, or both)"]
["MktCap",{"$f":"'Calculated Data'!B33","v":20.600999999999999},{"$f":"'Calculated Data'!C33","v":13.12},{"$f":"'Calculated Data'!D33","v":19.440000000000001},{"$f":"'Calculated Data'!E33","v":31.68},{"$f":"'Calculated Data'!F33","v":80.319999999999993},{"$f":"'Calculated Data'!G33","v":95.008619320000022},{"$f":"'Calculated Data'!H33","v":541.03139672999998},{"$f":"'Calculated Data'!I33","v":1490.9359290900002},{"$f":"'Calculated Data'!J33","v":1974.7895764300001},{"$f":"'Calculated Data'!K33","v":3872.1462198100003}]
["MktCap Change",null,{"$f":"C65-B65","v":-7.4809999999999999},{"$f":"D65-C65","v":6.3200000000000021},12.239999999999998,48.639999999999993,14.688619320000029,446.02277740999995,949.90453236000019,483.85364733999995,1897.3566433800002]
["MktCap Change - EPA",null,{"$f":"C66-C64","v":3.9554140986908362},14.240157205240175,16.379234782608695,29.545825843539113,-1.4416293955566317E-2,396.80687698212125,857.11587232886143,370.65957042338226,1703.611207817019]
[]
["Capex/Net Profits 10 yr",{"$f":"SUM('Calculated Data'!B$18:K$18)/SUM('Calculated Data'!B$7:K$7)","v":0.42724867724867721}]
["Capex/Net Profits 7 yr",{"$f":"SUM('Calculated Data'!E$18:K$18)/SUM('Calculated Data'!E$7:K$7)","v":0.42154014975471221}]
["Capex/Net Profits 5 yr",{"$f":"SUM('Calculated Data'!G$18:K$18)/SUM('Calculated Data'!G$7:K$7)","v":0.40361763255869298}]
["Capex/Net Profits 3 yr",{"$f":"SUM('Calculated Data'!I$18:K$18)/SUM('Calculated Data'!I$7:K$7)","v":0.38817475449494643}]
["Capex/Depreciation 10 yr",{"$f":"SUM('Calculated Data'!B$18:K$18)/SUM('Data Sheet'!B26:K26)","v":4.3503491852344531}]

{"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","AVANTI FEEDS 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":4.5415219125556501}]
["Face Value",2]
["Current Price",1942.95]
["Market Capitalization",8823.9500000000007]
[]
[]
[]
[]
[]
["PROFIT & LOSS"]
["Report Date","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","2017-03-31"]
["Sales",98.01,69.31,91.54,207.75,393.41,648.04,1131.6099999999999,1780.66,2018.29,2732.66]
["Raw Material Cost",73.7,49.96,77.540000000000006,171.61,274.93,516.33000000000004,882.4,1383.06,1542.97,2100.54]
["Change in Inventory",0.89,-3.17,1,9.42,-4.17,19.36,12.63,15,14.06,29.38]
["Power and Fuel",3.57,3.02,3.73,7.05,10.85,19.12,26.39,28.83,25.63,33.65]
["Other Mfr. Exp",4.74,4.2,4.93,9.18,9.07,13.91,20.420000000000002,34.56,34.869999999999997,45.43]
["Employee Cost",4.53,4.3099999999999996,4.6500000000000004,6.7,12.47,17.420000000000002,35.22,47.64,58.08,73.349999999999994]
["Selling and admin",7.58,7.12,7.98,14.34,29.9,47.48,66.400000000000006,116.67,133.26,168.94]
["Other Expenses",3.34,1.3,0.78,0.51,7.29,2.68,1.98,2.61,7.24,8.27]
["Other Income",8.76,4.2699999999999996,10.69,4.1399999999999997,3.35,2.58,3.68,9.02,21.49,21.87]
["Depreciation",3.88,3.34,2.78,2.9,4,4.9800000000000004,5.54,8.8000000000000007,10.23,13.69]
["Interest",5,7.09,3.13,4.5999999999999996,4.07,3.92,4.3899999999999997,2.67,3.38,4.8499999999999996]
["Profit before tax",1.32,-9.93,-2.29,5.29,40.01,44.14,105.17,179.84,238.18,335.18]
["Tax",0.43,-2.93,-1.08,1.76,11.96,13.96,35.42,63.27,79.2,108.43]
["Net profit",0.89,-7,-1.21,3.4,28.05,30.05,70.41,115.92,157.5,214.35]
["Dividend Amount",0.65,null,null,0.8,5.9,5.9,13.62,24.98,24.98,31.79]
[]
[]
[]
[]
[]
[]
[]
[]
["Quarters"]
["Report Date","2015-03-31","2015-06-30","2015-09-30","2015-12-31","2016-03-31","2016-06-30","2016-09-30","2016-12-31","2017-03-31","2017-06-30"]
["Sales",381.45,603.4,532.95000000000005,413.11,468.83,724.38,713.06,558.63,704.43,998.17]
["Expenses",344.57,539.25,470.5,357.62,422.44,648.34,656.63,489.73,576.34,773.2]
["Other Income",1.52,7.53,5.84,3.5,4.62,1.85,7,3.59,7.99,6.18]
["Depreciation",2.2400000000000002,2.6,2.5299999999999998,2.58,2.52,2.71,3.24,3.93,3.81,4.07]
["Interest",0.49,0.28999999999999998,0.3,0.19,0.78,0.2,0.22,0.24,2.1800000000000002,0.62]
["Profit before tax",35.67,68.790000000000006,65.47,56.22,47.7,74.98,59.96,68.31,130.09,226.46]
["Tax",13.39,23.08,21.5,19.04,15.58,25.76,19.77,21.84,40.409999999999997,77.67]
["Net profit",21.79,45.4,43.96,36.54,31.23,49.03,37.340000000000003,41.11,83.88,148.84]
["Operating Profit",36.880000000000003,64.150000000000006,62.45,55.49,46.39,76.040000000000006,56.43,68.900000000000006,128.09,224.97]
[]
[]
[]
[]
["BALANCE SHEET"]
["Report Date","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","2017-03-31"]
["Equity Share Capital",6.54,8,8,8,8,9.08,9.08,9.08,9.08,9.08]
["Reserves",62.72,60.1,58.9,61.52,85.61,116.02,170.49,256.20999999999998,413.71,631.38]
["Borrowings",40.659999999999997,38.020000000000003,34.130000000000003,54.46,49.57,61.08,56.12,58.4,10.71,19.43]
["Other Liabilities",9.67,11.99,13.64,28.32,40.04,62.7,163.72,154.1,189.1,396.58]
["Total",119.59,118.11,114.67,152.30000000000001,183.22,248.88,399.41,477.79,622.6,1056.47]
["Net Block",33.43,30.05,27.86,26.78,43.09,50.85,77.510000000000005,89.57,103.99,160.47]
["Capital Work in Progress",0.14000000000000001,null,null,11.12,1.67,1.59,4.8099999999999996,null,41.62,78.47]
["Investments",27.83,27.5,31.33,34.49,44.77,34.869999999999997,40.31,111.09,33.15,357.51]
["Other Assets",58.19,60.56,55.48,79.91,93.69,161.57,276.77999999999997,277.13,443.84,460.02]
["Total",119.59,118.11,114.67,152.30000000000001,183.22,248.88,399.41,477.79,622.6,1056.47]
["Receivables",13.54,15.86,8.93,22.81,15.51,39.729999999999997,45.02,33.56,34.97,23.51]
["Inventory",26.7,20.38,27.27,39.049999999999997,42.15,97.16,199.15,222.02,285.55,355.7]
["Cash & Bank",3.99,9.01,3.42,4.5599999999999996,22.05,8.59,12.86,6.16,72.569999999999993,45.12]
["No. of Equity Shares",6540000,8000000,8000000,8000000,8000000,9083042,9083042,9083042,45415210,45415210]
["New Bonus Shares"]
["Face value",10,10,10,10,10,10,10,10,2,2]
[]
[]
[]
[]
[]
[]
[]
["CASH FLOW:"]
["Report Date","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","2017-03-31"]
["Cash from Operating Activity",17.190000000000001,9.34,3.92,-7.72,50.38,-20.55,55.56,89.34,122,291.69]
["Cash from Investing Activity",0.47,0.65,-2.19,-17.600000000000001,-17.440000000000001,5.43,-39.1,-83.52,18.13,-428.3]
["Cash from Financing Activity",-21.08,-4.97,-7.32,19.010000000000002,-14.09,0.81,-12.74,-11.97,-74.260000000000005,107.11]
["Net Cash Flow",-3.42,5.0199999999999996,-5.59,-6.31,18.850000000000001,-14.31,3.72,-6.15,65.86,-29.5]
[]
[]
[]
[]
["PRICE:",6.3,3.28,4.8600000000000003,7.92,20.079999999999998,20.92,119.13,328.29,434.83,852.61]
[]
["DERIVED:"]
["Adjusted Equity Shares in Cr",{"$f":"IF($B7>0,(B70*B72/$B7)+SUM(C71:$K71),0)/10000000","v":3.27},{"$f":"IF($B7>0,(C70*C72/$B7)+SUM(D71:$K71),0)/10000000","v":4},{"$f":"IF($B7>0,(D70*D72/$B7)+SUM(E71:$K71),0)/10000000","v":4},{"$f":"IF($B7>0,(E70*E72/$B7)+SUM(F71:$K71),0)/10000000","v":4},{"$f":"IF($B7>0,(F70*F72/$B7)+SUM(G71:$K71),0)/10000000","v":4},{"$f":"IF($B7>0,(G70*G72/$B7)+SUM(H71:$K71),0)/10000000","v":4.5415210000000004},{"$f":"IF($B7>0,(H70*H72/$B7)+SUM(I71:$K71),0)/10000000","v":4.5415210000000004},{"$f":"IF($B7>0,(I70*I72/$B7)+SUM(J71:$K71),0)/10000000","v":4.5415210000000004},{"$f":"IF($B7>0,(J70*J72/$B7)+SUM(K71:$K71),0)/10000000","v":4.5415210000000004},{"$f":"IF($B7>0,(K70*K72/$B7),0)/10000000","v":4.5415210000000004}]

{"sheet":"Calculated Data","index":6,"n_rows":53,"n_cols":14,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Data Sheet'!B1","v":"AVANTI FEEDS LTD"}]
[{"$f":"A1","v":"AVANTI FEEDS LTD"},{"$f":"'Data Sheet'!B16","v":"2008-03-31"},{"$f":"'Data Sheet'!C16","v":"2009-03-31"},{"$f":"'Data Sheet'!D16","v":"2010-03-31"},{"$f":"'Data Sheet'!E16","v":"2011-03-31"},{"$f":"'Data Sheet'!F16","v":"2012-03-31"},{"$f":"'Data Sheet'!G16","v":"2013-03-31"},{"$f":"'Data Sheet'!H16","v":"2014-03-31"},{"$f":"'Data Sheet'!I16","v":"2015-03-31"},{"$f":"'Data Sheet'!J16","v":"2016-03-31"},{"$f":"'Data Sheet'!K16","v":"2017-03-31"},"TTM"]
["Gross Profit",{"$f":"'Data Sheet'!B17-'Data Sheet'!B18","v":24.310000000000002},{"$f":"'Data Sheet'!C17-'Data Sheet'!C18","v":19.350000000000001},{"$f":"'Data Sheet'!D17-'Data Sheet'!D18","v":14},{"$f":"'Data Sheet'!E17-'Data Sheet'!E18","v":36.139999999999986},{"$f":"'Data Sheet'!F17-'Data Sheet'!F18","v":118.48000000000002},{"$f":"'Data Sheet'!G17-'Data Sheet'!G18","v":131.70999999999992},{"$f":"'Data Sheet'!H17-'Data Sheet'!H18","v":249.20999999999992},{"$f":"'Data Sheet'!I17-'Data Sheet'!I18","v":397.60000000000014},{"$f":"'Data Sheet'!J17-'Data Sheet'!J18","v":475.31999999999994},{"$f":"'Data Sheet'!K17-'Data Sheet'!K18","v":632.11999999999989}]
["EBIT",{"$f":"'Data Sheet'!B28+'Data Sheet'!B27","v":6.32},{"$f":"'Data Sheet'!C28+'Data Sheet'!C27","v":-2.84},{"$f":"'Data Sheet'!D28+'Data Sheet'!D27","v":0.83999999999999986},{"$f":"'Data Sheet'!E28+'Data Sheet'!E27","v":9.89},{"$f":"'Data Sheet'!F28+'Data Sheet'!F27","v":44.08},{"$f":"'Data Sheet'!G28+'Data Sheet'!G27","v":48.06},{"$f":"'Data Sheet'!H28+'Data Sheet'!H27","v":109.56},{"$f":"'Data Sheet'!I28+'Data Sheet'!I27","v":182.51},{"$f":"'Data Sheet'!J28+'Data Sheet'!J27","v":241.56},{"$f":"'Data Sheet'!K28+'Data Sheet'!K27","v":340.03000000000003},{"$f":"'Profit & Loss'!L17","v":488.08000000000004}]
["EBITDA",{"$f":"'Calculated Data'!B4+'Data Sheet'!B26","v":10.199999999999999},{"$f":"'Calculated Data'!C4+'Data Sheet'!C26","v":0.5},{"$f":"'Calculated Data'!D4+'Data Sheet'!D26","v":3.6199999999999997},{"$f":"'Calculated Data'!E4+'Data Sheet'!E26","v":12.790000000000001},{"$f":"'Calculated Data'!F4+'Data Sheet'!F26","v":48.08},{"$f":"'Calculated Data'!G4+'Data Sheet'!G26","v":53.040000000000006},{"$f":"'Calculated Data'!H4+'Data Sheet'!H26","v":115.10000000000001},{"$f":"'Calculated Data'!I4+'Data Sheet'!I26","v":191.31},{"$f":"'Calculated Data'!J4+'Data Sheet'!J26","v":251.79},{"$f":"'Calculated Data'!K4+'Data Sheet'!K26","v":353.72},{"$f":"'Profit & Loss'!L18","v":503.13000000000005}]
["Operating Profit (excl Other Income)",{"$f":"B5-'Data Sheet'!B25","v":1.4399999999999995},{"$f":"C5-'Data Sheet'!C25","v":-3.7699999999999996},{"$f":"D5-'Data Sheet'!D25","v":-7.07},{"$f":"E5-'Data Sheet'!E25","v":8.6500000000000021},{"$f":"F5-'Data Sheet'!F25","v":44.73},{"$f":"G5-'Data Sheet'!G25","v":50.460000000000008},{"$f":"H5-'Data Sheet'!H25","v":111.42},{"$f":"I5-'Data Sheet'!I25","v":182.29},{"$f":"J5-'Data Sheet'!J25","v":230.29999999999998},{"$f":"K5-'Data Sheet'!K25","v":331.85},{"$f":"'Profit & Loss'!L19","v":478.37000000000006}]
["PAT",{"$f":"'Data Sheet'!B30","v":0.89},{"$f":"'Data Sheet'!C30","v":-7},{"$f":"'Data Sheet'!D30","v":-1.21},{"$f":"'Data Sheet'!E30","v":3.4},{"$f":"'Data Sheet'!F30","v":28.05},{"$f":"'Data Sheet'!G30","v":30.05},{"$f":"'Data Sheet'!H30","v":70.41},{"$f":"'Data Sheet'!I30","v":115.92},{"$f":"'Data Sheet'!J30","v":157.5},{"$f":"'Data Sheet'!K30","v":214.35},{"$f":"'Profit & Loss'!L12","v":311.16999999999996}]
["Dividend",{"$f":"'Data Sheet'!B31","v":0.65},{"$f":"'Data Sheet'!C31","v":0},{"$f":"'Data Sheet'!D31","v":0},{"$f":"'Data Sheet'!E31","v":0.8},{"$f":"'Data Sheet'!F31","v":5.9},{"$f":"'Data Sheet'!G31","v":5.9},{"$f":"'Data Sheet'!H31","v":13.62},{"$f":"'Data Sheet'!I31","v":24.98},{"$f":"'Data Sheet'!J31","v":24.98},{"$f":"'Data Sheet'!K31","v":31.79}]
[null,{"$f":"B2","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","2017-03-31","1HFY17"]
["Networth",{"$f":"'Data Sheet'!B57+'Data Sheet'!B58","v":69.260000000000005},{"$f":"'Data Sheet'!C57+'Data Sheet'!C58","v":68.099999999999994},{"$f":"'Data Sheet'!D57+'Data Sheet'!D58","v":66.900000000000006},{"$f":"'Data Sheet'!E57+'Data Sheet'!E58","v":69.52000000000001},{"$f":"'Data Sheet'!F57+'Data Sheet'!F58","v":93.61},{"$f":"'Data Sheet'!G57+'Data Sheet'!G58","v":125.1},{"$f":"'Data Sheet'!H57+'Data Sheet'!H58","v":179.57000000000002},{"$f":"'Data Sheet'!I57+'Data Sheet'!I58","v":265.28999999999996},{"$f":"'Data Sheet'!J57+'Data Sheet'!J58","v":422.78999999999996},{"$f":"'Data Sheet'!K57+'Data Sheet'!K58","v":640.46},{"$f":"'Balance Sheet'!L4+'Balance Sheet'!L5","v":0}]
["Working Capital",{"$f":"'Data Sheet'!B65-'Data Sheet'!B60","v":48.519999999999996},{"$f":"'Data Sheet'!C65-'Data Sheet'!C60","v":48.57},{"$f":"'Data Sheet'!D65-'Data Sheet'!D60","v":41.839999999999996},{"$f":"'Data Sheet'!E65-'Data Sheet'!E60","v":51.589999999999996},{"$f":"'Data Sheet'!F65-'Data Sheet'!F60","v":53.65},{"$f":"'Data Sheet'!G65-'Data Sheet'!G60","v":98.86999999999999},{"$f":"'Data Sheet'!H65-'Data Sheet'!H60","v":113.05999999999997},{"$f":"'Data Sheet'!I65-'Data Sheet'!I60","v":123.03},{"$f":"'Data Sheet'!J65-'Data Sheet'!J60","v":254.73999999999998},{"$f":"'Data Sheet'!K65-'Data Sheet'!K60","v":63.44},{"$f":"'Balance Sheet'!L16","v":0}]
["Exclude one-off excess Cash (if any)",null,null,null,null,null,null,null,null,null,null,null,"check historical normalised levels of cash/total assets for excluding one-off excess cash for RoIC calculations"]
["Invested Capital",{"$f":"'Data Sheet'!B62+'Data Sheet'!B63+'Calculated Data'!B11","v":82.09},{"$f":"'Data Sheet'!C62+'Data Sheet'!C63+'Calculated Data'!C11","v":78.62},{"$f":"'Data Sheet'!D62+'Data Sheet'!D63+'Calculated Data'!D11","v":69.699999999999989},{"$f":"'Data Sheet'!E62+'Data Sheet'!E63+'Calculated Data'!E11","v":89.49},{"$f":"'Data Sheet'!F62+'Data Sheet'!F63+'Calculated Data'!F11","v":98.41},{"$f":"'Data Sheet'!G62+'Data Sheet'!G63+'Calculated Data'!G11","v":151.31},{"$f":"'Data Sheet'!H62+'Data Sheet'!H63+'Calculated Data'!H11","v":195.38},{"$f":"'Data Sheet'!I62+'Data Sheet'!I63+'Calculated Data'!I11","v":212.6},{"$f":"'Data Sheet'!J62+'Data Sheet'!J63+'Calculated Data'!J11","v":400.34999999999997},{"$f":"'Data Sheet'!K62+'Data Sheet'!K63+'Calculated Data'!K11","v":302.38},{"$f":"'Balance Sheet'!L10+'Balance Sheet'!L11+'Balance Sheet'!L16","v":0}]
["Capital Employed",{"$f":"B10+'Data Sheet'!B59","v":109.92},{"$f":"C10+'Data Sheet'!C59","v":106.12},{"$f":"D10+'Data Sheet'!D59","v":101.03},{"$f":"E10+'Data Sheet'!E59","v":123.98000000000002},{"$f":"F10+'Data Sheet'!F59","v":143.18},{"$f":"G10+'Data Sheet'!G59","v":186.18},{"$f":"H10+'Data Sheet'!H59","v":235.69000000000003},{"$f":"I10+'Data Sheet'!I59","v":323.68999999999994},{"$f":"J10+'Data Sheet'!J59","v":433.49999999999994},{"$f":"K10+'Data Sheet'!K59","v":659.89}]
["Total Assets",{"$f":"'Data Sheet'!B61","v":119.59},{"$f":"'Data Sheet'!C61","v":118.11},{"$f":"'Data Sheet'!D61","v":114.67},{"$f":"'Data Sheet'!E61","v":152.30000000000001},{"$f":"'Data Sheet'!F61","v":183.22},{"$f":"'Data Sheet'!G61","v":248.88},{"$f":"'Data Sheet'!H61","v":399.41},{"$f":"'Data Sheet'!I61","v":477.79},{"$f":"'Data Sheet'!J61","v":622.6},{"$f":"'Data Sheet'!K61","v":1056.47},{"$f":"'Balance Sheet'!L8","v":0}]
[null,{"$f":"B2","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","2017-03-31"]
["Operating Cash Flow",{"$f":"'Data Sheet'!B82","v":17.190000000000001},{"$f":"'Data Sheet'!C82","v":9.34},{"$f":"'Data Sheet'!D82","v":3.92},{"$f":"'Data Sheet'!E82","v":-7.72},{"$f":"'Data Sheet'!F82","v":50.38},{"$f":"'Data Sheet'!G82","v":-20.55},{"$f":"'Data Sheet'!H82","v":55.56},{"$f":"'Data Sheet'!I82","v":89.34},{"$f":"'Data Sheet'!J82","v":122},{"$f":"'Data Sheet'!K82","v":291.69}]
["Capex",null,{"$f":"('Data Sheet'!C62-'Data Sheet'!B62)+('Data Sheet'!C63-'Data Sheet'!B63)+'Data Sheet'!C26","v":-0.17999999999999927},{"$f":"('Data Sheet'!D62-'Data Sheet'!C62)+('Data Sheet'!D63-'Data Sheet'!C63)+'Data Sheet'!D26","v":0.58999999999999853},{"$f":"('Data Sheet'!E62-'Data Sheet'!D62)+('Data Sheet'!E63-'Data Sheet'!D63)+'Data Sheet'!E26","v":12.940000000000001},{"$f":"('Data Sheet'!F62-'Data Sheet'!E62)+('Data Sheet'!F63-'Data Sheet'!E63)+'Data Sheet'!F26","v":10.860000000000003},{"$f":"('Data Sheet'!G62-'Data Sheet'!F62)+('Data Sheet'!G63-'Data Sheet'!F63)+'Data Sheet'!G26","v":12.659999999999998},{"$f":"('Data Sheet'!H62-'Data Sheet'!G62)+('Data Sheet'!H63-'Data Sheet'!G63)+'Data Sheet'!H26","v":35.42},{"$f":"('Data Sheet'!I62-'Data Sheet'!H62)+('Data Sheet'!I63-'Data Sheet'!H63)+'Data Sheet'!I26","v":16.04999999999999},{"$f":"('Data Sheet'!J62-'Data Sheet'!I62)+('Data Sheet'!J63-'Data Sheet'!I63)+'Data Sheet'!J26","v":66.27},{"$f":"('Data Sheet'!K62-'Data Sheet'!J62)+('Data Sheet'!K63-'Data Sheet'!J63)+'Data Sheet'!K26","v":107.02000000000001},null,"CHECK?","derived from BS"]
["Free Cash Flow",null,{"$f":"C17-C18","v":9.52},{"$f":"D17-D18","v":3.3300000000000014},-20.66,39.519999999999996,-33.21,20.14,73.29000000000002,55.730000000000004,184.67]
["RoE",{"$f":"Customization!B53","v":1.2850129945134276E-2},{"$f":"Customization!C53","v":-0.10279001468428781},{"$f":"Customization!D53","v":-1.8086696562032885E-2},{"$f":"Customization!E53","v":4.8906789413118518E-2},{"$f":"Customization!F53","v":0.29964747356051713},{"$f":"Customization!G53","v":0.2402078337330136},{"$f":"Customization!H53","v":0.39210335802194124},{"$f":"Customization!I53","v":0.43695578423611903},{"$f":"Customization!J53","v":0.37252536720357632},{"$f":"Customization!K53","v":0.33468132279923801}]
["Dividend Payout",{"$f":"'Profit & Loss'!B23","v":0.7303370786516854},{"$f":"'Profit & Loss'!C23","v":0},{"$f":"'Profit & Loss'!D23","v":0},{"$f":"'Profit & Loss'!E23","v":0.23529411764705885},{"$f":"'Profit & Loss'!F23","v":0.21033868092691624},{"$f":"'Profit & Loss'!G23","v":0.19633943427620634},{"$f":"'Profit & Loss'!H23","v":0.19343843204090327},{"$f":"'Profit & Loss'!I23","v":0.21549344375431331},{"$f":"'Profit & Loss'!J23","v":0.15860317460317461},{"$f":"'Profit & Loss'!K23","v":0.14830884068112898}]
["Tax Rate",{"$f":"'Data Sheet'!B29/'Data Sheet'!B28","v":0.32575757575757575},{"$f":"'Data Sheet'!C29/'Data Sheet'!C28","v":0.29506545820745217},{"$f":"'Data Sheet'!D29/'Data Sheet'!D28","v":0.47161572052401751},{"$f":"'Data Sheet'!E29/'Data Sheet'!E28","v":0.33270321361058602},{"$f":"'Data Sheet'!F29/'Data Sheet'!F28","v":0.29892526868282931},{"$f":"'Data Sheet'!G29/'Data Sheet'!G28","v":0.31626642501132762},{"$f":"'Data Sheet'!H29/'Data Sheet'!H28","v":0.33678805743082629},{"$f":"'Data Sheet'!I29/'Data Sheet'!I28","v":0.35181272241992884},{"$f":"'Data Sheet'!J29/'Data Sheet'!J28","v":0.33252162230246035},{"$f":"'Data Sheet'!K29/'Data Sheet'!K28","v":0.32349782206575572}]
["NOPLAT",{"$f":"B4*(1-B22)","v":4.2612121212121217},-2.0020140986908359,0.44384279475982524,6.5995652173913042,30.903374156460881,32.860235613955595,72.661500427878678,118.30066003113879,161.23607691661769,230.03103556298109]
["RoIC",{"$f":"(B4/B13)*(1-B22)","v":5.1909028154612277E-2},{"$f":"(C4/C13)*(1-C22)","v":-2.5464437785434186E-2},6.3679023638425437E-3,7.3746398674615091E-2,0.31402676716249245,0.21717160540582642,0.37189835411955507,0.55644713090846099,0.40273779671941479,0.76073495457034568]
["WACC",0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12]
["EPA (Economic Profit Added)",{"$f":"B13*(B24-B25)","v":-5.5895878787878779},{"$f":"C13*(C24-C25)","v":-11.436414098690836},-7.920157205240173,-4.1392347826086953,19.09417415646088,14.703035613955596,49.215900427878672,92.788660031138804,113.1940769166177,193.74543556298113]
["RoIIC",null,null,{"$f":"(D23-C23)/(C13-B13)","v":-0.70485789436618496},{"$f":"(E23-D23)/(D13-C13)","v":-0.69010341060890901},1.2280853430555618,0.21937908716308449,0.75238685848625864,1.0356060722319065,2.4933459283088792,0.36641788892869992]
["3Yr Rolling RoIIC ",null,null,null,null,null,{"$f":"(G23-D23)/(F13-C13)","v":1.6380188387668411},0.80948333795475269,0.82535920176294175,1.1242301541523958,{"$f":"(K23-H23)/(J13-G13)","v":0.63190465441335697}]
["5Yr Rolling RoIIC",null,null,null,null,null,null,{"$f":"(H23-C23)/(G13-B13)","v":1.0786407761711863},{"$f":"(I23-D23)/(H13-C13)","v":1.0093937755770723},1.0821309426118011,{"$f":"(K23-F23)/(J13-E13)","v":0.64057022906298733}]
["Operating Leverage",null,{"$f":"((C4-B4)/B4)/(('Data Sheet'!C17-'Data Sheet'!B17)/'Data Sheet'!B17)","v":4.9495633572972251},{"$f":"((D4-C4)/C4)/(('Data Sheet'!D17-'Data Sheet'!C17)/'Data Sheet'!C17)","v":-4.0400423232150429},{"$f":"((E4-D4)/D4)/(('Data Sheet'!E17-'Data Sheet'!D17)/'Data Sheet'!D17)","v":8.4866579796017927},{"$f":"((F4-E4)/E4)/(('Data Sheet'!F17-'Data Sheet'!E17)/'Data Sheet'!E17)","v":3.8683476335129705},{"$f":"((G4-F4)/F4)/(('Data Sheet'!G17-'Data Sheet'!F17)/'Data Sheet'!F17)","v":0.13950099689147213},{"$f":"((H4-G4)/G4)/(('Data Sheet'!H17-'Data Sheet'!G17)/'Data Sheet'!G17)","v":1.714880305154467},{"$f":"((I4-H4)/H4)/(('Data Sheet'!I17-'Data Sheet'!H17)/'Data Sheet'!H17)","v":1.1608922049382753},{"$f":"((J4-I4)/I4)/(('Data Sheet'!J17-'Data Sheet'!I17)/'Data Sheet'!I17)","v":2.4244485477403535},{"$f":"((K4-J4)/J4)/(('Data Sheet'!K17-'Data Sheet'!J17)/'Data Sheet'!J17)","v":1.1516997627000669}]
["Sustainable Growth Rate",{"$f":"B20*(1-B21)","v":3.4652035807103665E-3},{"$f":"C20*(1-C21)","v":-0.10279001468428781},-1.8086696562032885E-2,3.7399309551208279E-2,0.23662001922871495,0.19304556354916066,0.31625549924820401,0.34279467752271103,0.31344166134487578,0.28504512381725633,null,"coy can grow at this rate safely with internal accruals"]
[null,{"$f":"B2","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","2017-03-31","CURRENT"]
["MktCap",{"$f":"'Data Sheet'!B90*'Data Sheet'!B93","v":20.600999999999999},{"$f":"'Data Sheet'!C90*'Data Sheet'!C93","v":13.12},{"$f":"'Data Sheet'!D90*'Data Sheet'!D93","v":19.440000000000001},{"$f":"'Data Sheet'!E90*'Data Sheet'!E93","v":31.68},{"$f":"'Data Sheet'!F90*'Data Sheet'!F93","v":80.319999999999993},{"$f":"'Data Sheet'!G90*'Data Sheet'!G93","v":95.008619320000022},{"$f":"'Data Sheet'!H90*'Data Sheet'!H93","v":541.03139672999998},{"$f":"'Data Sheet'!I90*'Data Sheet'!I93","v":1490.9359290900002},{"$f":"'Data Sheet'!J90*'Data Sheet'!J93","v":1974.7895764300001},{"$f":"'Data Sheet'!K90*'Data Sheet'!K93","v":3872.1462198100003},{"$f":"'Data Sheet'!B9","v":8823.9500000000007}]
["MktCap+Dividend",{"$f":"B33+'Data Sheet'!B31","v":21.250999999999998},{"$f":"C33+'Data Sheet'!C31","v":13.12},{"$f":"D33+'Data Sheet'!D31","v":19.440000000000001},{"$f":"E33+'Data Sheet'!E31","v":32.479999999999997},{"$f":"F33+'Data Sheet'!F31","v":86.22},{"$f":"G33+'Data Sheet'!G31","v":100.90861932000003},{"$f":"H33+'Data Sheet'!H31","v":554.65139672999999},{"$f":"I33+'Data Sheet'!I31","v":1515.9159290900002},{"$f":"J33+'Data Sheet'!J31","v":1999.7695764300001},{"$f":"K33+'Data Sheet'!K31","v":3903.9362198100002}]
["Retained Profit",{"$f":"'Data Sheet'!B30-'Data Sheet'!B31","v":0.24},{"$f":"'Data Sheet'!C30-'Data Sheet'!C31","v":-7},{"$f":"'Data Sheet'!D30-'Data Sheet'!D31","v":-1.21},{"$f":"'Data Sheet'!E30-'Data Sheet'!E31","v":2.5999999999999996},{"$f":"'Data Sheet'!F30-'Data Sheet'!F31","v":22.15},{"$f":"'Data Sheet'!G30-'Data Sheet'!G31","v":24.15},{"$f":"'Data Sheet'!H30-'Data Sheet'!H31","v":56.79},{"$f":"'Data Sheet'!I30-'Data Sheet'!I31","v":90.94},{"$f":"'Data Sheet'!J30-'Data Sheet'!J31","v":132.52000000000001},{"$f":"'Data Sheet'!K30-'Data Sheet'!K31","v":182.56}]
["EV",{"$f":"B33+'Data Sheet'!B59-'Data Sheet'!B69","v":57.270999999999994},{"$f":"C33+'Data Sheet'!C59-'Data Sheet'!C69","v":42.13},{"$f":"D33+'Data Sheet'!D59-'Data Sheet'!D69","v":50.150000000000006},{"$f":"E33+'Data Sheet'!E59-'Data Sheet'!E69","v":81.58},{"$f":"F33+'Data Sheet'!F59-'Data Sheet'!F69","v":107.83999999999999},{"$f":"G33+'Data Sheet'!G59-'Data Sheet'!G69","v":147.49861932000002},{"$f":"H33+'Data Sheet'!H59-'Data Sheet'!H69","v":584.29139672999997},{"$f":"I33+'Data Sheet'!I59-'Data Sheet'!I69","v":1543.1759290900002},{"$f":"J33+'Data Sheet'!J59-'Data Sheet'!J69","v":1912.9295764300002},{"$f":"K33+'Data Sheet'!K59-'Data Sheet'!K69","v":3846.4562198100002}]
[null,{"$f":"B2","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","2017-03-31"]
["Price/Earnings",{"$f":"B33/'Data Sheet'!B30","v":23.147191011235954},{"$f":"C33/'Data Sheet'!C30","v":-1.8742857142857141},{"$f":"D33/'Data Sheet'!D30","v":-16.06611570247934},{"$f":"E33/'Data Sheet'!E30","v":9.3176470588235301},{"$f":"F33/'Data Sheet'!F30","v":2.8634581105169339},{"$f":"G33/'Data Sheet'!G30","v":3.1616845031613985},{"$f":"H33/'Data Sheet'!H30","v":7.6840135879846612},{"$f":"I33/'Data Sheet'!I30","v":12.861766123964804},{"$f":"J33/'Data Sheet'!J30","v":12.538346517015874},{"$f":"K33/'Data Sheet'!K30","v":18.064596313552602}]
["Price/Book",{"$f":"B33/B10","v":0.29744441235922608},0.19265785609397945,0.29058295964125558,0.4556962025316455,0.85802798846277095,0.75946138545163888,3.012927530935011,5.6200231033585899,4.6708521403770202,6.0458829900540234]
["Price/CashFlow",{"$f":"B33/B17","v":1.1984293193717277},1.4047109207708779,4.9591836734693882,-4.1036269430051817,1.5942834458118298,-4.6232904778588821,9.7377861182505399,16.68833589758227,16.186799806803279,13.274867907058866]
["Price/Sales",{"$f":"B33/'Data Sheet'!B17","v":0.21019283746556472},{"$f":"C33/'Data Sheet'!C17","v":0.18929447410186118},{"$f":"D33/'Data Sheet'!D17","v":0.21236617871968538},{"$f":"E33/'Data Sheet'!E17","v":0.15249097472924186},{"$f":"F33/'Data Sheet'!F17","v":0.2041635952314379},{"$f":"G33/'Data Sheet'!G17","v":0.14660918974137402},{"$f":"H33/'Data Sheet'!H17","v":0.47810764903986358},{"$f":"I33/'Data Sheet'!I17","v":0.83729399722013187},{"$f":"J33/'Data Sheet'!J17","v":0.97844689139320917},{"$f":"K33/'Data Sheet'!K17","v":1.4169879237848837}]
["EV/EBITDA",{"$f":"B36/B5","v":5.614803921568627},84.26,13.853591160220997,6.3784206411258788,2.2429284525790347,2.7808940294117646,5.0763805102519539,8.0663631231509072,7.5973214838953105,10.874296674799275]
["Dividend Yield",{"$f":"'Data Sheet'!B31/'Calculated Data'!B33","v":3.1551866414251735E-2},{"$f":"'Data Sheet'!C31/'Calculated Data'!C33","v":0},{"$f":"'Data Sheet'!D31/'Calculated Data'!D33","v":0},{"$f":"'Data Sheet'!E31/'Calculated Data'!E33","v":2.5252525252525256E-2},{"$f":"'Data Sheet'!F31/'Calculated Data'!F33","v":7.3456175298804785E-2},{"$f":"'Data Sheet'!G31/'Calculated Data'!G33","v":6.2099628878177021E-2},{"$f":"'Data Sheet'!H31/'Calculated Data'!H33","v":2.5174139767709297E-2},{"$f":"'Data Sheet'!I31/'Calculated Data'!I33","v":1.6754576445982265E-2},{"$f":"'Data Sheet'!J31/'Calculated Data'!J33","v":1.26494489833993E-2},{"$f":"'Data Sheet'!K31/'Calculated Data'!K33","v":8.2099172384972278E-3}]
[null,{"$f":"B2","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","2017-03-31","Z-Weights"]
["Working Capital/Total Assets",{"$f":"B11/B15","v":0.4057195417677063},0.41122682245364489,0.36487311415365831,0.33873933026920544,0.29281737801550051,0.39725972356155576,0.28306752459878315,0.25749806400301389,0.40915515579826528,6.0049031207701116E-2,1.2]
["Retained Profits/Total Assets",{"$f":"B35/B15","v":2.0068567605987121E-3},-5.9266785200237065E-2,-1.0552018836661724E-2,1.707156927117531E-2,0.12089291562056544,9.7034715525554482E-2,0.14218472246563679,0.19033466585738504,0.21284934147124962,0.17280187795204785,1.4]
["EBIT/Total Assets",{"$f":"B4/B15","v":5.2847228029099427E-2},-2.4045381424096179E-2,7.3253684485916097E-3,6.4937623112278395E-2,0.24058508896408687,0.19310511089681776,0.2743045992839438,0.38198790263504884,0.3879858657243816,0.3218548562666238,3.3]
["Market Cap/Total Liabilities",{"$f":"B33/B15","v":0.17226356718789196},0.11108288883244433,0.16952995552454872,0.20801050558108994,0.43838008950987878,0.38174469350691104,1.3545764921509225,3.1204837461855628,3.1718432001766783,3.6651738523668445,0.6]
["Sales/Total Assets",{"$f":"'Data Sheet'!B17/'Calculated Data'!B15","v":0.81955012960949913},{"$f":"'Data Sheet'!C17/'Calculated Data'!C15","v":0.58682584031834728},{"$f":"'Data Sheet'!D17/'Calculated Data'!D15","v":0.79829074736199535},{"$f":"'Data Sheet'!E17/'Calculated Data'!E15","v":1.3640840446487195},{"$f":"'Data Sheet'!F17/'Calculated Data'!F15","v":2.1472000873267114},{"$f":"'Data Sheet'!G17/'Calculated Data'!G15","v":2.6038251366120218},{"$f":"'Data Sheet'!H17/'Calculated Data'!H15","v":2.8332039758643996},{"$f":"'Data Sheet'!I17/'Calculated Data'!I15","v":3.7268674522279661},{"$f":"'Data Sheet'!J17/'Calculated Data'!J15","v":3.241712174751044},{"$f":"'Data Sheet'!K17/'Calculated Data'!K15","v":2.5865949814003235},1]
["Altman Z-Score",{"$f":"$L$45*B45+$L$46*B46+$L$47*B47+$L$48*B48+$L$49*B49","v":1.5869771720043482},{"$f":"$L$45*C45+$L$46*C46+$L$47*C47+$L$48*C48+$L$49*C49","v":0.98462450258233847},1.3472573471701406,2.133571897570584,3.7247898701015174,4.0826790886853104,5.0898946897623993,7.4351839876389203,7.2141467167651783,6.161801785082397]
["Z > 2.99 -“Safe” Zones"]
["1.81 < Z < 2.99 -“Grey” Zones"]
["Z < 1.81 -“Distress” Zones"]

{"sheet":"Cost Analysis","index":7,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Data Sheet'!B1","v":"AVANTI FEEDS LTD"},{"$f":"B7","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","2017-03-31"]
[{"$f":"'Data Sheet'!A17","v":"Sales"},{"$f":"'Data Sheet'!B17","v":98.01},{"$f":"'Data Sheet'!C17","v":69.31},{"$f":"'Data Sheet'!D17","v":91.54},{"$f":"'Data Sheet'!E17","v":207.75},{"$f":"'Data Sheet'!F17","v":393.41},{"$f":"'Data Sheet'!G17","v":648.04},{"$f":"'Data Sheet'!H17","v":1131.6099999999999},{"$f":"'Data Sheet'!I17","v":1780.66},{"$f":"'Data Sheet'!J17","v":2018.29},{"$f":"'Data Sheet'!K17","v":2732.66}]
[{"$f":"'Data Sheet'!A25","v":"Other Income"},{"$f":"'Data Sheet'!B25","v":8.76},{"$f":"'Data Sheet'!C25","v":4.2699999999999996},{"$f":"'Data Sheet'!D25","v":10.69},{"$f":"'Data Sheet'!E25","v":4.1399999999999997},{"$f":"'Data Sheet'!F25","v":3.35},{"$f":"'Data Sheet'!G25","v":2.58},{"$f":"'Data Sheet'!H25","v":3.68},{"$f":"'Data Sheet'!I25","v":9.02},{"$f":"'Data Sheet'!J25","v":21.49},{"$f":"'Data Sheet'!K25","v":21.87}]
["Sales Increase",null,{"$f":"(C2-B2)/B2","v":-0.29282726252423225},0.32073293896984567,1.2694996722744154,0.89367027677497002,0.64723825017157655,0.7462039380285167,0.57356333012256899,0.13345051834712965,0.35394814422109799]
["EBIT",{"$f":"'Calculated Data'!B4","v":6.32},{"$f":"'Calculated Data'!C4","v":-2.84},{"$f":"'Calculated Data'!D4","v":0.83999999999999986},{"$f":"'Calculated Data'!E4","v":9.89},{"$f":"'Calculated Data'!F4","v":44.08},{"$f":"'Calculated Data'!G4","v":48.06},{"$f":"'Calculated Data'!H4","v":109.56},{"$f":"'Calculated Data'!I4","v":182.51},{"$f":"'Calculated Data'!J4","v":241.56},{"$f":"'Calculated Data'!K4","v":340.03000000000003}]
["EBIT Increase",null,{"$f":"(C5-B5)/B5","v":-1.4493670886075949},{"$f":"(D5-C5)/C5","v":-1.295774647887324},10.773809523809527,3.4570273003033365,9.0290381125226957E-2,1.2796504369538078,0.66584519897772898,0.32354391540189587,0.4076419937075676]
["Operating Expenses",{"$f":"'Data Sheet'!B16","v":"2008-03-31"},{"$f":"'Data Sheet'!C16","v":"2009-03-31"},{"$f":"'Data Sheet'!D16","v":"2010-03-31"},{"$f":"'Data Sheet'!E16","v":"2011-03-31"},{"$f":"'Data Sheet'!F16","v":"2012-03-31"},{"$f":"'Data Sheet'!G16","v":"2013-03-31"},{"$f":"'Data Sheet'!H16","v":"2014-03-31"},{"$f":"'Data Sheet'!I16","v":"2015-03-31"},{"$f":"'Data Sheet'!J16","v":"2016-03-31"},{"$f":"'Data Sheet'!K16","v":"2017-03-31"}]
[{"$f":"'Data Sheet'!A18","v":"Raw Material Cost"},{"$f":"'Data Sheet'!B18","v":73.7},{"$f":"'Data Sheet'!C18","v":49.96},{"$f":"'Data Sheet'!D18","v":77.540000000000006},{"$f":"'Data Sheet'!E18","v":171.61},{"$f":"'Data Sheet'!F18","v":274.93},{"$f":"'Data Sheet'!G18","v":516.33000000000004},{"$f":"'Data Sheet'!H18","v":882.4},{"$f":"'Data Sheet'!I18","v":1383.06},{"$f":"'Data Sheet'!J18","v":1542.97},{"$f":"'Data Sheet'!K18","v":2100.54}]
[{"$f":"'Data Sheet'!A19","v":"Change in Inventory"},{"$f":"'Data Sheet'!B19","v":0.89},{"$f":"'Data Sheet'!C19","v":-3.17},{"$f":"'Data Sheet'!D19","v":1},{"$f":"'Data Sheet'!E19","v":9.42},{"$f":"'Data Sheet'!F19","v":-4.17},{"$f":"'Data Sheet'!G19","v":19.36},{"$f":"'Data Sheet'!H19","v":12.63},{"$f":"'Data Sheet'!I19","v":15},{"$f":"'Data Sheet'!J19","v":14.06},{"$f":"'Data Sheet'!K19","v":29.38}]
[{"$f":"'Data Sheet'!A20","v":"Power and Fuel"},{"$f":"'Data Sheet'!B20","v":3.57},{"$f":"'Data Sheet'!C20","v":3.02},{"$f":"'Data Sheet'!D20","v":3.73},{"$f":"'Data Sheet'!E20","v":7.05},{"$f":"'Data Sheet'!F20","v":10.85},{"$f":"'Data Sheet'!G20","v":19.12},{"$f":"'Data Sheet'!H20","v":26.39},{"$f":"'Data Sheet'!I20","v":28.83},{"$f":"'Data Sheet'!J20","v":25.63},{"$f":"'Data Sheet'!K20","v":33.65}]
[{"$f":"'Data Sheet'!A21","v":"Other Mfr. Exp"},{"$f":"'Data Sheet'!B21","v":4.74},{"$f":"'Data Sheet'!C21","v":4.2},{"$f":"'Data Sheet'!D21","v":4.93},{"$f":"'Data Sheet'!E21","v":9.18},{"$f":"'Data Sheet'!F21","v":9.07},{"$f":"'Data Sheet'!G21","v":13.91},{"$f":"'Data Sheet'!H21","v":20.420000000000002},{"$f":"'Data Sheet'!I21","v":34.56},{"$f":"'Data Sheet'!J21","v":34.869999999999997},{"$f":"'Data Sheet'!K21","v":45.43}]
[{"$f":"'Data Sheet'!A22","v":"Employee Cost"},{"$f":"'Data Sheet'!B22","v":4.53},{"$f":"'Data Sheet'!C22","v":4.3099999999999996},{"$f":"'Data Sheet'!D22","v":4.6500000000000004},{"$f":"'Data Sheet'!E22","v":6.7},{"$f":"'Data Sheet'!F22","v":12.47},{"$f":"'Data Sheet'!G22","v":17.420000000000002},{"$f":"'Data Sheet'!H22","v":35.22},{"$f":"'Data Sheet'!I22","v":47.64},{"$f":"'Data Sheet'!J22","v":58.08},{"$f":"'Data Sheet'!K22","v":73.349999999999994}]
[{"$f":"'Data Sheet'!A23","v":"Selling and admin"},{"$f":"'Data Sheet'!B23","v":7.58},{"$f":"'Data Sheet'!C23","v":7.12},{"$f":"'Data Sheet'!D23","v":7.98},{"$f":"'Data Sheet'!E23","v":14.34},{"$f":"'Data Sheet'!F23","v":29.9},{"$f":"'Data Sheet'!G23","v":47.48},{"$f":"'Data Sheet'!H23","v":66.400000000000006},{"$f":"'Data Sheet'!I23","v":116.67},{"$f":"'Data Sheet'!J23","v":133.26},{"$f":"'Data Sheet'!K23","v":168.94}]
[{"$f":"'Data Sheet'!A24","v":"Other Expenses"},{"$f":"'Data Sheet'!B24","v":3.34},{"$f":"'Data Sheet'!C24","v":1.3},{"$f":"'Data Sheet'!D24","v":0.78},{"$f":"'Data Sheet'!E24","v":0.51},{"$f":"'Data Sheet'!F24","v":7.29},{"$f":"'Data Sheet'!G24","v":2.68},{"$f":"'Data Sheet'!H24","v":1.98},{"$f":"'Data Sheet'!I24","v":2.61},{"$f":"'Data Sheet'!J24","v":7.24},{"$f":"'Data Sheet'!K24","v":8.27}]
["Interest Expense",{"$f":"'Profit & Loss'!B9","v":5},{"$f":"'Profit & Loss'!C9","v":7.09},{"$f":"'Profit & Loss'!D9","v":3.13},{"$f":"'Profit & Loss'!E9","v":4.5999999999999996},{"$f":"'Profit & Loss'!F9","v":4.07},{"$f":"'Profit & Loss'!G9","v":3.92},{"$f":"'Profit & Loss'!H9","v":4.3899999999999997},{"$f":"'Profit & Loss'!I9","v":2.67},{"$f":"'Profit & Loss'!J9","v":3.38},{"$f":"'Profit & Loss'!K9","v":4.8499999999999996}]
["Coomon Size Expenses",{"$f":"B1","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","2017-03-31"]
[{"$f":"A8","v":"Raw Material Cost"},{"$f":"B8/B$2","v":0.75196408529741865},0.72081950656470928,0.84706139392615254,0.82604091456077022,0.6988383620141837,0.79675637306339131,0.77977395038926844,0.77671200566082232,0.76449370506716086,0.7686796015603844,"check lower RM/Sales - high correlation with Op Leverage"]
["Change in Inventory",{"$f":"B9/B$2","v":9.0807060504030195E-3},-4.573654595296494E-2,1.0924186148131964E-2,4.5342960288808666E-2,-1.0599628885895121E-2,2.9874699092648602E-2,1.1161089067788375E-2,8.423842844787888E-3,6.9662932482448016E-3,1.0751429010561139E-2]
["Power and Fuel",{"$f":"B10/B$2","v":3.6424854606672788E-2},4.3572356081373539E-2,4.0747214332532221E-2,3.3935018050541513E-2,2.7579370122772676E-2,2.9504351583235607E-2,2.3320755383922025E-2,1.6190625947682318E-2,1.2698868844417798E-2,1.2314009060768629E-2]
["Other Mfr. Exp",{"$f":"B11/B$2","v":4.8362411998775633E-2},6.0597316404559225E-2,5.3856237710290578E-2,4.4187725631768954E-2,2.3054828296179556E-2,2.1464724399728415E-2,1.8045086204611132E-2,1.9408533914391294E-2,1.7277001818370996E-2,1.6624827091551823E-2]
["Employee Cost",{"$f":"B12/B$2","v":4.6219773492500768E-2},6.2184388977059579E-2,5.0797465588813637E-2,3.2250300842358602E-2,3.1697211560458557E-2,2.6881056724893528E-2,3.1123797067894417E-2,2.6754124875046331E-2,2.8776835836277246E-2,2.6841978145835926E-2,"check high Emp Cost/Sales - high correlation with Op Leverage"]
["Selling and admin",{"$f":"B13/B$2","v":7.7339047036016725E-2},0.10272687923820516,8.7175005462093072E-2,6.9025270758122745E-2,7.6002135177041755E-2,7.3267082278871673E-2,5.8677459548784484E-2,6.5520649646760187E-2,6.6026190487987357E-2,6.1822546529754892E-2]
["Other Expenses",{"$f":"B14/B$2","v":3.4078155290276496E-2},1.8756312220458808E-2,8.5208651955429315E-3,2.4548736462093861E-3,1.8530286469586436E-2,4.1355471884451586E-3,1.7497194263041155E-3,1.4657486549930923E-3,3.5871951008031554E-3,3.026355272884296E-3]
["Interest Expense",{"$f":"B15/B2","v":5.1015202530354041E-2},0.10229404126388687,3.4192702643653046E-2,2.2141997593261128E-2,1.0345441142828093E-2,6.0490093204123201E-3,3.8794284249874075E-3,1.499444026372244E-3,1.6746850056235723E-3,1.774827457495627E-3]
["Interest Expense Capitalised",null,null,null,null,null,null,null,null,null,null,"Add back from AR - any interest costs capitalised"]
["Year on Year Escalation",{"$f":"B16","v":"2008-03-31"},{"$f":"C16","v":"2009-03-31"},"2010-03-31","2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31","2017-03-31"]
["Raw Material Increase/Sales Increase",null,{"$f":"((C8-B8)/B8)/C$4","v":1.1000228821051536},1.721187836459001,0.95563655551660787,0.67369681245845736,1.356597331979092,0.95012171338640838,0.98922712866555806,0.86639180781902037,1.0209448359489064]
["Change in Inventory Increase/Sales Increase",null,{"$f":"((C9-B9)/B9)/C$4","v":15.578459852014246},-4.1014104054117331,6.6325342053179597,-1.6143259955359806,-8.7180970065090015,-0.4658565161966004,0.32716257508461544,-0.4695872855559764,3.0784620558444087]
["Power & Fuel Increase/Sales Increase",null,{"$f":"((C10-B10)/B10)/C$4","v":0.52611776417884204},0.73300652718568349,0.70112694661808739,0.60313865886165741,1.1776374176970621,0.5095525581486301,0.16120149252446034,-0.83173517932291541,0.88406891904039775]
["Other Mfg Increase/Sales Increase",null,{"$f":"((C11-B11)/B11)/C$4","v":0.38904864817183432},0.54191354454512308,0.67906198350785896,-1.3408268259007365E-2,0.82446818114841713,0.62718595150223722,1.2072919201355159,6.7215230922332336E-2,0.8556030640750325]
["Employee Cost Increase/Sales Increase",null,{"$f":"((C12-B12)/B12)/C$4","v":0.16584904354246993},0.24595637466561929,0.34727083801756736,0.96365969892002867,0.61330226750697403,1.3693495233867072,0.61482407717635257,1.6421335753538489,0.74280153020455986]
["Selling & Admin Cost Increase/Sales Increase",null,{"$f":"((C13-B13)/B13)/C$4","v":0.20724168681566194},0.37659529838713762,0.62780046234681441,1.214180147541035,0.90841334866237167,0.53401429786490939,1.3199559202838616,1.0655330456570971,0.75645900498434293]
["Other Expenses Increase/Sales Increase",null,{"$f":"((C14-B14)/B14)/C$4","v":2.0857977424941057},-1.2471434997750785,-0.27266950414700181,14.875864166629702,-0.97703297616752305,-0.35003035569716412,0.55474574728099069,13.292914723185206,0.40193795529917509]
["Year on Year Escalation",{"$f":"B26","v":"2008-03-31"},{"$f":"C26","v":"2009-03-31"},"2010-03-31","2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31","2017-03-31"]
["Working Capital Increase/Sales Increase",null,{"$f":"(('Calculated Data'!C11-'Calculated Data'!B11)/'Calculated Data'!B11)/'Cost Analysis'!C$4","v":-3.5191494006569495E-3},{"$f":"(('Calculated Data'!D11-'Calculated Data'!C11)/'Calculated Data'!C11)/'Cost Analysis'!D$4","v":-0.43201954671022663},{"$f":"(('Calculated Data'!E11-'Calculated Data'!D11)/'Calculated Data'!D11)/'Cost Analysis'!E$4","v":0.18356097116333378},{"$f":"(('Calculated Data'!F11-'Calculated Data'!E11)/'Calculated Data'!E11)/'Cost Analysis'!F$4","v":4.4681153745870068E-2},{"$f":"(('Calculated Data'!G11-'Calculated Data'!F11)/'Calculated Data'!F11)/'Cost Analysis'!G$4","v":1.3022568682245266},{"$f":"(('Calculated Data'!H11-'Calculated Data'!G11)/'Calculated Data'!G11)/'Cost Analysis'!H$4","v":0.19233588699271162},{"$f":"(('Calculated Data'!I11-'Calculated Data'!H11)/'Calculated Data'!H11)/'Cost Analysis'!I$4","v":0.15374634480884092},{"$f":"(('Calculated Data'!J11-'Calculated Data'!I11)/'Calculated Data'!I11)/'Cost Analysis'!J$4","v":8.0220887200031221},{"$f":"(('Calculated Data'!K11-'Calculated Data'!J11)/'Calculated Data'!J11)/'Cost Analysis'!K$4","v":-2.1216717115140487}]
["Debtors Increase/Sales Increase",null,{"$f":"('Balance Sheet'!C17-'Balance Sheet'!B17)/'Balance Sheet'!B17/'Cost Analysis'!C$4","v":-0.58513733987308225},{"$f":"('Balance Sheet'!D17-'Balance Sheet'!C17)/'Balance Sheet'!C17/'Cost Analysis'!D$4","v":-1.3623430727366479},{"$f":"('Balance Sheet'!E17-'Balance Sheet'!D17)/'Balance Sheet'!D17/'Cost Analysis'!E$4","v":1.2243495166924225},{"$f":"('Balance Sheet'!F17-'Balance Sheet'!E17)/'Balance Sheet'!E17/'Cost Analysis'!F$4","v":-0.35811314380021686},{"$f":"('Balance Sheet'!G17-'Balance Sheet'!F17)/'Balance Sheet'!F17/'Cost Analysis'!G$4","v":2.4126713434820908},{"$f":"('Balance Sheet'!H17-'Balance Sheet'!G17)/'Balance Sheet'!G17/'Cost Analysis'!H$4","v":0.17843480488978608},{"$f":"('Balance Sheet'!I17-'Balance Sheet'!H17)/'Balance Sheet'!H17/'Cost Analysis'!I$4","v":-0.44381068034677729},{"$f":"('Balance Sheet'!J17-'Balance Sheet'!I17)/'Balance Sheet'!I17/'Cost Analysis'!J$4","v":0.31483056987513253},{"$f":"('Balance Sheet'!K17-'Balance Sheet'!J17)/'Balance Sheet'!J17/'Cost Analysis'!K$4","v":-0.92586857879166018}]
["Inventory Increase/Sales Increase",null,{"$f":"(('Balance Sheet'!C18-'Balance Sheet'!B18)/'Balance Sheet'!B18)/'Cost Analysis'!C$4","v":0.80834044552323525},{"$f":"(('Balance Sheet'!D18-'Balance Sheet'!C18)/'Balance Sheet'!C18)/'Cost Analysis'!D$4","v":1.0540749157814393},{"$f":"(('Balance Sheet'!E18-'Balance Sheet'!D18)/'Balance Sheet'!D18)/'Cost Analysis'!E$4","v":0.34027305435416899},{"$f":"(('Balance Sheet'!F18-'Balance Sheet'!E18)/'Balance Sheet'!E18)/'Cost Analysis'!F$4","v":8.8830752674853616E-2},{"$f":"(('Balance Sheet'!G18-'Balance Sheet'!F18)/'Balance Sheet'!F18)/'Cost Analysis'!G$4","v":2.0164148673564406},{"$f":"(('Balance Sheet'!H18-'Balance Sheet'!G18)/'Balance Sheet'!G18)/'Cost Analysis'!H$4","v":1.4067358292631316},{"$f":"(('Balance Sheet'!I18-'Balance Sheet'!H18)/'Balance Sheet'!H18)/'Cost Analysis'!I$4","v":0.20021862579316221},{"$f":"(('Balance Sheet'!J18-'Balance Sheet'!I18)/'Balance Sheet'!I18)/'Cost Analysis'!J$4","v":2.1442059262945832},{"$f":"(('Balance Sheet'!K18-'Balance Sheet'!J18)/'Balance Sheet'!J18)/'Cost Analysis'!K$4","v":0.69407415213045476}]
["Creditors Increase/Sales Increase",null,{"$f":"IF('Balance Sheet'!C19>0,(('Balance Sheet'!C19-'Balance Sheet'!B19)/'Balance Sheet'!B19)/'Cost Analysis'!C$4,0)","v":0},{"$f":"IF('Balance Sheet'!D19>0,(('Balance Sheet'!D19-'Balance Sheet'!C19)/'Balance Sheet'!C19)/'Cost Analysis'!D$4,0)","v":0},{"$f":"IF('Balance Sheet'!E19>0,(('Balance Sheet'!E19-'Balance Sheet'!D19)/'Balance Sheet'!D19)/'Cost Analysis'!E$4,0)","v":0},{"$f":"IF('Balance Sheet'!F19>0,(('Balance Sheet'!F19-'Balance Sheet'!E19)/'Balance Sheet'!E19)/'Cost Analysis'!F$4,0)","v":0},{"$f":"IF('Balance Sheet'!G19>0,(('Balance Sheet'!G19-'Balance Sheet'!F19)/'Balance Sheet'!F19)/'Cost Analysis'!G$4,0)","v":0},{"$f":"IF('Balance Sheet'!H19>0,(('Balance Sheet'!H19-'Balance Sheet'!G19)/'Balance Sheet'!G19)/'Cost Analysis'!H$4,0)","v":0},{"$f":"IF('Balance Sheet'!I19>0,(('Balance Sheet'!I19-'Balance Sheet'!H19)/'Balance Sheet'!H19)/'Cost Analysis'!I$4,0)","v":0},{"$f":"IF('Balance Sheet'!J19>0,(('Balance Sheet'!J19-'Balance Sheet'!I19)/'Balance Sheet'!I19)/'Cost Analysis'!J$4,0)","v":0},{"$f":"IF('Balance Sheet'!K19>0,(('Balance Sheet'!K19-'Balance Sheet'!J19)/'Balance Sheet'!J19)/'Cost Analysis'!K$4,0)","v":0}]
["Invested Capital Increase/Sales Increase",null,{"$f":"(('Calculated Data'!C13-'Calculated Data'!B13)/'Calculated Data'!B13)/'Cost Analysis'!C$4","v":0.14435363073502644},{"$f":"(('Calculated Data'!D13-'Calculated Data'!C13)/'Calculated Data'!C13)/'Cost Analysis'!D$4","v":-0.35374332288201854},{"$f":"(('Calculated Data'!E13-'Calculated Data'!D13)/'Calculated Data'!D13)/'Cost Analysis'!E$4","v":0.22365593282926569},{"$f":"(('Calculated Data'!F13-'Calculated Data'!E13)/'Calculated Data'!E13)/'Cost Analysis'!F$4","v":0.11153547794571046},{"$f":"(('Calculated Data'!G13-'Calculated Data'!F13)/'Calculated Data'!F13)/'Cost Analysis'!G$4","v":0.83052414951353382},{"$f":"(('Calculated Data'!H13-'Calculated Data'!G13)/'Calculated Data'!G13)/'Cost Analysis'!H$4","v":0.39031737340123274},{"$f":"(('Calculated Data'!I13-'Calculated Data'!H13)/'Calculated Data'!H13)/'Cost Analysis'!I$4","v":0.15366383377442536},{"$f":"(('Calculated Data'!J13-'Calculated Data'!I13)/'Calculated Data'!I13)/'Cost Analysis'!J$4","v":6.6175376440974905},{"$f":"(('Calculated Data'!K13-'Calculated Data'!J13)/'Calculated Data'!J13)/'Cost Analysis'!K$4","v":-0.69137494284728984}]
["Dilution ",{"$f":"B1","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","2017-03-31"]
["Equity Capital Increase/Decrease",null,{"$f":"('Data Sheet'!C57-'Data Sheet'!B57)/'Data Sheet'!B57","v":0.22324159021406728},{"$f":"('Data Sheet'!D57-'Data Sheet'!C57)/'Data Sheet'!C57","v":0},{"$f":"('Data Sheet'!E57-'Data Sheet'!D57)/'Data Sheet'!D57","v":0},{"$f":"('Data Sheet'!F57-'Data Sheet'!E57)/'Data Sheet'!E57","v":0},{"$f":"('Data Sheet'!G57-'Data Sheet'!F57)/'Data Sheet'!F57","v":0.13500000000000001},{"$f":"('Data Sheet'!H57-'Data Sheet'!G57)/'Data Sheet'!G57","v":0},{"$f":"('Data Sheet'!I57-'Data Sheet'!H57)/'Data Sheet'!H57","v":0},{"$f":"('Data Sheet'!J57-'Data Sheet'!I57)/'Data Sheet'!I57","v":0},{"$f":"('Data Sheet'!K57-'Data Sheet'!J57)/'Data Sheet'!J57","v":0}]

{"sheet":"Price Implied Expectations","index":8,"n_rows":35,"n_cols":18,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,12,1,14],[2,12,2,14],[3,12,3,14],[4,12,4,14],[11,12,11,14],[5,12,5,14],[6,12,6,14],[7,12,7,14],[8,12,8,14],[9,12,9,14],[13,12,13,14],[14,12,14,14],[10,0,10,10],[27,1,27,16],[32,1,32,16],[10,12,10,14],[12,12,12,14]]}
[{"$f":"'Data Sheet'!B1","v":"AVANTI FEEDS LTD"}]
["(CONSOLIDATED)",{"$f":"'Data Sheet'!B16","v":"2008-03-31"},{"$f":"'Data Sheet'!C16","v":"2009-03-31"},{"$f":"'Data Sheet'!D16","v":"2010-03-31"},{"$f":"'Data Sheet'!E16","v":"2011-03-31"},{"$f":"'Data Sheet'!F16","v":"2012-03-31"},{"$f":"'Data Sheet'!G16","v":"2013-03-31"},{"$f":"'Data Sheet'!H16","v":"2014-03-31"},{"$f":"'Data Sheet'!I16","v":"2015-03-31"},{"$f":"'Data Sheet'!J16","v":"2016-03-31"},{"$f":"'Data Sheet'!K16","v":"2017-03-31"},null,"Consensus Forecasts",null,null,"5 Yr Avg","Inputs","TTM"]
["Sales",{"$f":"'Data Sheet'!B17","v":98.01},{"$f":"'Data Sheet'!C17","v":69.31},{"$f":"'Data Sheet'!D17","v":91.54},{"$f":"'Data Sheet'!E17","v":207.75},{"$f":"'Data Sheet'!F17","v":393.41},{"$f":"'Data Sheet'!G17","v":648.04},{"$f":"'Data Sheet'!H17","v":1131.6099999999999},{"$f":"'Data Sheet'!I17","v":1780.66},{"$f":"'Data Sheet'!J17","v":2018.29},{"$f":"'Data Sheet'!K17","v":2732.66},null,"Sales Growth Rate",null,null,{"$f":"Customization!B14","v":0.43299919556683952},0.25,{"$f":"'Profit & Loss'!L31","v":8.8423001763849193E-2}]
["Capex",null,{"$f":"'Calculated Data'!C18","v":-0.17999999999999927},{"$f":"'Calculated Data'!D18","v":0.58999999999999853},{"$f":"'Calculated Data'!E18","v":12.940000000000001},{"$f":"'Calculated Data'!F18","v":10.860000000000003},{"$f":"'Calculated Data'!G18","v":12.659999999999998},{"$f":"'Calculated Data'!H18","v":35.42},{"$f":"'Calculated Data'!I18","v":16.04999999999999},{"$f":"'Calculated Data'!J18","v":66.27},{"$f":"'Calculated Data'!K18","v":107.02000000000001},null,"EBIT Margin",null,null,{"$f":"AVERAGE(Customization!G36:K36)","v":0.10351858988327148},0.13,{"$f":"'Calculated Data'!L4/Annual[[#This Row],[Column12]]","v":0.16409966748366839}]
["Depreciation",null,{"$f":"'Data Sheet'!C26","v":3.34},{"$f":"'Data Sheet'!D26","v":2.78},{"$f":"'Data Sheet'!E26","v":2.9},{"$f":"'Data Sheet'!F26","v":4},{"$f":"'Data Sheet'!G26","v":4.9800000000000004},{"$f":"'Data Sheet'!H26","v":5.54},{"$f":"'Data Sheet'!I26","v":8.8000000000000007},{"$f":"'Data Sheet'!J26","v":10.23},{"$f":"'Data Sheet'!K26","v":13.69},null,"Tax Rate",null,null,{"$f":"AVERAGE('Calculated Data'!G22:K22)","v":0.3321773298460598},0.33]
["Incremental Fixed Capital Investment",null,{"$f":"C4-C5","v":-3.5199999999999991},{"$f":"D4-D5","v":-2.1900000000000013},10.040000000000001,6.860000000000003,7.6799999999999979,29.880000000000003,7.2499999999999893,56.039999999999992,93.330000000000013,null,"Inc Fixed Capital Rate",null,null,{"$f":"AVERAGE(G9:K9)","v":5.4554459498957784E-2},0.1]
["Incremental Sales",null,{"$f":"C3-B3","v":-28.700000000000003},{"$f":"D3-C3","v":22.230000000000004},116.21,185.66000000000003,254.62999999999994,483.56999999999994,649.05000000000018,237.62999999999988,714.36999999999989,null,"Inc Working Capital Rate",null,null,{"$f":"AVERAGE(G15:K15)","v":8.2381391765750434E-2},0.15]
["Incremental Fixed Capital Investment Rate",null,{"$f":"C6/C7","v":0.12264808362369334},{"$f":"D6/D7","v":-9.8515519568151189E-2},8.639531881937873E-2,3.6949262091996136E-2,3.0161410674311745E-2,6.1790433649730143E-2,1.1170171789538537E-2,0.23582880949375087,0.13064658370312307,null,"Cost of Capital",null,null,null,0.12]
["5 Yr Avg",null,null,null,null,null,{"$f":"SUMIF(C6:G6,\">0\")/SUMIF(C7:G7,\">0\")","v":4.2472310058230961E-2},5.1266120681540066E-2,3.6533816425120769E-2,5.9490538734300255E-2,{"$f":"SUMIF(G6:K6,\">0\")/SUMIF(G7:K7,\">0\")","v":8.3009511595596885E-2},null,"Inflation Rate",null,null,null,0.05]
["9 Yr Avg",null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(C6:K6,\">0\")/SUMIF(C7:K7,\">0\")","v":7.9253571629714456E-2},null,"Cash & Bank Balance",null,null,null,{"$f":"'Balance Sheet'!K34","v":45.12}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Investments",null,null,null,{"$f":"'Balance Sheet'!K12","v":357.51}]
["Working Capital",{"$f":"'Calculated Data'!B11","v":48.519999999999996},{"$f":"'Calculated Data'!C11","v":48.57},{"$f":"'Calculated Data'!D11","v":41.839999999999996},{"$f":"'Calculated Data'!E11","v":51.589999999999996},{"$f":"'Calculated Data'!F11","v":53.65},{"$f":"'Calculated Data'!G11","v":98.86999999999999},{"$f":"'Calculated Data'!H11","v":113.05999999999997},{"$f":"'Calculated Data'!I11","v":123.03},{"$f":"'Calculated Data'!J11","v":254.73999999999998},{"$f":"'Calculated Data'!K11","v":63.44},null,"Non-Operative Assets",null,null,null,{"$f":"Q10+Q11","v":402.63}]
["Incremental Working Capital",null,{"$f":"C12-B12","v":5.0000000000004263E-2},{"$f":"D12-C12","v":-6.730000000000004},9.75,2.0600000000000023,45.219999999999992,14.189999999999984,9.9700000000000273,131.70999999999998,-191.29999999999998,null,"Debt",null,null,null,{"$f":"'Balance Sheet'!K6","v":19.43}]
["Incremental Working Capital Investment Rate",null,{"$f":"C13/C7","v":-1.7421602787457929E-3},{"$f":"D13/D7","v":-0.30274403958614499},8.3899836502882713E-2,1.1095551007217505E-2,0.17759101441306996,2.9344252124821609E-2,1.5360912102303404E-2,0.5542650338761943,-0.26778840096868572,null,"# Shares Outstanding",null,null,null,{"$f":"'Data Sheet'!B6","v":4.5415219125556501}]
["5 Yr Avg",null,null,null,null,null,{"$f":"SUMIF(C13:G13,\">0\")/SUMIF(C7:G7,\">0\")","v":9.8629758263784492E-2},6.7043208133295659E-2,4.8066448801742913E-2,0.11220409380626774,{"$f":"SUMIF(G13:K13,\">0\")/SUMIF(G7:K7,\">0\")","v":8.5963449823661414E-2},null,"CMP",null,null,null,{"$f":"'Data Sheet'!B8","v":1942.95}]
["9 Yr Avg",null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(C13:K13,\">0\")/SUMIF(C7:K7,\">0\")","v":7.9955694895526314E-2}]
["Years in Future",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
["Year","2016-03-01","2017-03-01","2018-03-01","2019-03-01","2020-03-01","2021-03-01","2022-03-01","2023-03-01","2024-03-01","2025-03-01","2026-03-01","2027-03-01","2028-03-01","2029-03-01","1930-03-01","1931-03-01"]
["Sales",{"$f":"'Data Sheet'!K17","v":2732.66},{"$f":"B19*(1+R3)","v":2974.29},{"$f":"C19*(1+$Q$3)","v":3717.8625000000002},{"$f":"D19*(1+$Q$3)","v":4647.328125},5809.16015625,7261.4501953125,9076.812744140625,11346.015930175781,14182.519912719727,17728.149890899658,22160.187363624573,27700.234204530716,34625.292755663395,43281.615944579244,54102.019930724055,67627.524913405068]
["EBIT",{"$f":"'Calculated Data'!K4","v":340.03000000000003},{"$f":"R4*C19","v":488.08000000000004},{"$f":"D19*$Q$4","v":483.32212500000003},{"$f":"E19*$Q$4","v":604.15265625000006},755.19082031250002,943.988525390625,1179.9856567382812,1474.9820709228516,1843.7275886535645,2304.6594858169556,2880.8243572711945,3601.0304465889931,4501.2880582362413,5626.6100727953017,7033.2625909941271,8791.5782387426589]
["NOPAT",{"$f":"'Calculated Data'!K23","v":230.03103556298109},{"$f":"C20*(1-$Q$5)","v":327.0136},{"$f":"D20*(1-$Q$5)","v":323.82582374999998},404.78227968750002,505.97784960937497,632.47231201171871,790.59039001464839,988.23798751831043,1235.297484397888,1544.12185549736,1930.1523193717001,2412.6903992146249,3015.8629990182812,3769.8287487728517,4712.2859359660642,5890.3574199575805]
["Incremental Fixed Capital Investment",null,{"$f":"(C19-B19)*$Q$6","v":24.163000000000011},{"$f":"(D19-C19)*$Q$6","v":74.357250000000022},92.946562499999985,116.18320312500001,145.22900390625,181.5362548828125,226.92031860351562,283.65039825439453,354.56299781799316,443.20374727249146,554.00468409061432,692.5058551132679,865.63231889158487,1082.0403986144811,1352.5504982681014]
["Incremental Working Capital Investment",null,{"$f":"(C19-B19)*$Q$7","v":36.244500000000016},{"$f":"(D19-C19)*$Q$7","v":111.53587500000003},139.41984374999996,174.27480468749999,217.843505859375,272.30438232421875,340.38047790527344,425.4755973815918,531.84449672698975,664.80562090873718,831.00702613592148,1038.7587826699018,1298.4484783373773,1623.0605979217216,2028.825747402152]
["Free Cash Flow",null,{"$f":"C21-(C22+C23)","v":266.60609999999997},{"$f":"D21-(D22+D23)","v":137.93269874999993},172.41587343750007,215.51984179687497,269.39980224609371,336.74975280761714,420.93719100952137,526.17148876190163,657.71436095237709,822.14295119047142,1027.6786889880891,1284.5983612351115,1605.7479515438895,2007.1849394298615,2508.9811742873271]
["Present Value of Free Cash Flow",null,{"$f":"C24/((1+$Q$8)^C17)","v":238.04116071428567},{"$f":"D24/((1+$Q$8)^D17)","v":109.95910295758921},122.72221312230948,136.96675571686319,152.86468271971339,170.60790482110866,190.41060805927302,212.51183935186717,237.17839213378033,264.7080269350227,295.4330657756949,329.72440376751666,367.99598634767483,410.70980619160122,458.38148012455503]
["Cumulative Present Value of Free Cash Flow",null,{"$f":"C25","v":238.04116071428567},{"$f":"D25+C26","v":348.0002636718749},{"$f":"E25+D26","v":470.72247679418439},607.68923251104752,760.55391523076094,931.16182005186965,1121.5724281111427,1334.0842674630098,1571.2626595967902,1835.9706865318128,2131.4037523075076,2461.1281560750244,2829.1241424226992,3239.8339486143004,3698.2154287388553]
["Present Value of Residual Value",null,{"$f":"((C21*(1+$Q$9))/($Q$8-$Q$9))/((1+$Q$8)^C17)","v":4379.6464285714292},{"$f":"((D21*(1+$Q$9))/($Q$8-$Q$9))/((1+$Q$8)^D17)","v":3872.2794612962375},4321.7404701966934,4823.3710604873804,5383.2266300082365,6008.0654352770498,6705.4301733002767,7483.7390327012017,8352.3873132825902,9321.860840717176,10403.862545443275,11611.453733753657,12959.21175642149,14463.405978148983,16142.194172041276]
[]
["Corporate Value",null,{"$f":"C27+C26","v":4617.6875892857151},{"$f":"D27+D26","v":4220.2797249681125},4792.4629469908778,5431.0602929984279,6143.7805452389975,6939.2272553289195,7827.0026014114192,8817.8233001642111,9923.6499728793806,11157.831527248989,12535.266297750783,14072.581889828682,15788.335898844189,17703.239926763283,19840.409600780131]
["Add: Non-Operative Assets",null,{"$f":"$Q$12","v":402.63},{"$f":"$Q$12","v":402.63},402.63,402.63,402.63,402.63,402.63,402.63,402.63,402.63,402.63,402.63,402.63,402.63,402.63]
["Less: Debt",null,{"$f":"$Q$13","v":19.43},{"$f":"$Q$13","v":19.43},19.43,19.43,19.43,19.43,19.43,19.43,19.43,19.43,19.43,19.43,19.43,19.43,19.43]
["Shareholder Value",null,{"$f":"C29+C30-C31","v":5000.887589285715},{"$f":"D29+D30-D31","v":4603.4797249681124},5175.6629469908776,5814.2602929984278,6526.9805452389974,7322.4272553289193,8210.2026014114181,9201.02330016421,10306.849972879379,11541.031527248988,12918.466297750781,14455.781889828681,16171.535898844188,18086.439926763283,20223.609600780132]
[]
["Shareholder Value/Share",null,{"$f":"C32/$Q$14","v":1101.1479599955439},{"$f":"D32/$Q$14","v":1013.64252195749},1139.6318341395774,1280.2449057713716,1437.1791375032847,1612.3289497040807,1807.8086508210397,2025.9779601033608,2269.4704927845228,2541.2255515804623,2844.5236082723586,3183.0259036874227,3560.8186441060197,3982.4623276089192,4453.046795804119]
["Market-Implied-Forecast-Period",null,{"$f":"IF(Q15>Q34,\"15+\",IF(Q15<C34,\"<1\",LOOKUP(Q15,C34:Q34,C17:Q17)))","v":7}]

{"sheet":"Business Robustness","index":9,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[[21,1,21,10],[0,1,0,11]]}
["Business Robustness Snapshot (Annual)","Annual Historical Performance"]
[{"$f":"'Data Sheet'!B1","v":"AVANTI FEEDS LTD"},{"$f":"'Data Sheet'!B16","v":"2008-03-31"},{"$f":"'Data Sheet'!C16","v":"2009-03-31"},{"$f":"'Data Sheet'!D16","v":"2010-03-31"},{"$f":"'Data Sheet'!E16","v":"2011-03-31"},{"$f":"'Data Sheet'!F16","v":"2012-03-31"},{"$f":"'Data Sheet'!G16","v":"2013-03-31"},{"$f":"'Data Sheet'!H16","v":"2014-03-31"},{"$f":"'Data Sheet'!I16","v":"2015-03-31"},{"$f":"'Data Sheet'!J16","v":"2016-03-31"},{"$f":"'Data Sheet'!K16","v":"2017-03-31"},"TTM"]
["Sales",{"$f":"'Data Sheet'!B17","v":98.01},{"$f":"'Data Sheet'!C17","v":69.31},{"$f":"'Data Sheet'!D17","v":91.54},{"$f":"'Data Sheet'!E17","v":207.75},{"$f":"'Data Sheet'!F17","v":393.41},{"$f":"'Data Sheet'!G17","v":648.04},{"$f":"'Data Sheet'!H17","v":1131.6099999999999},{"$f":"'Data Sheet'!I17","v":1780.66},{"$f":"'Data Sheet'!J17","v":2018.29},{"$f":"'Data Sheet'!K17","v":2732.66},{"$f":"'Profit & Loss'!L4","v":2974.29}]
["EBIT",{"$f":"'Profit & Loss'!B10+'Profit & Loss'!B9","v":6.32},{"$f":"'Profit & Loss'!C10+'Profit & Loss'!C9","v":-2.84},{"$f":"'Profit & Loss'!D10+'Profit & Loss'!D9","v":0.83999999999999986},{"$f":"'Profit & Loss'!E10+'Profit & Loss'!E9","v":9.89},{"$f":"'Profit & Loss'!F10+'Profit & Loss'!F9","v":44.08},{"$f":"'Profit & Loss'!G10+'Profit & Loss'!G9","v":48.06},{"$f":"'Profit & Loss'!H10+'Profit & Loss'!H9","v":109.56},{"$f":"'Profit & Loss'!I10+'Profit & Loss'!I9","v":182.51},{"$f":"'Profit & Loss'!J10+'Profit & Loss'!J9","v":241.56},{"$f":"'Profit & Loss'!K10+'Profit & Loss'!K9","v":340.03000000000003},{"$f":"'Profit & Loss'!L10+'Profit & Loss'!L9","v":488.08000000000004}]
["Operating Profit (ex Other Income)",{"$f":"'Calculated Data'!B6","v":1.4399999999999995},{"$f":"'Calculated Data'!C6","v":-3.7699999999999996},{"$f":"'Calculated Data'!D6","v":-7.07},{"$f":"'Calculated Data'!E6","v":8.6500000000000021},{"$f":"'Calculated Data'!F6","v":44.73},{"$f":"'Calculated Data'!G6","v":50.460000000000008},{"$f":"'Calculated Data'!H6","v":111.42},{"$f":"'Calculated Data'!I6","v":182.29},{"$f":"'Calculated Data'!J6","v":230.29999999999998},{"$f":"'Calculated Data'!K6","v":331.85},{"$f":"'Profit & Loss'!L6","v":478.39}]
["Operating Profit Margin (ex Other Income)",{"$f":"B5/B3","v":1.469237832874196E-2},-5.4393305439330533E-2,-7.723399606729299E-2,4.1636582430806271E-2,0.11369817747388219,7.7865563854083095E-2,9.8461484080204317E-2,0.10237215414509226,0.11410649609322743,0.12143845191132452,0.16084174710603202]
["1Yr Sales Increase",null,{"$f":"(C3-B3)/B3","v":-0.29282726252423225},0.32073293896984567,1.2694996722744154,0.89367027677497002,0.64723825017157655,0.7462039380285167,0.57356333012256899,0.13345051834712965,0.35394814422109799,8.8423001763849193E-2]
["1Yr EBIT Increase",null,{"$f":"(C4-B4)/B4","v":-1.4493670886075949},-1.295774647887324,10.773809523809527,3.4570273003033365,9.0290381125226957E-2,1.2796504369538078,0.66584519897772898,0.32354391540189587,0.4076419937075676,0.43540275858012528]
["3Yr Sales Increase",null,null,null,{"$f":"(E3-B3)/B3","v":1.1196816651362105},{"$f":"(F3-C3)/C3","v":4.6760929158851541},6.0793095914354378,4.4469795427196148,3.526219465697364,2.1144528115548424,1.4148425694364668,0.67033010232161094]
["3Yr EBIT Increase",null,null,null,{"$f":"(E4-B4)/B4","v":0.564873417721519},{"$f":"(F4-C4)/C4","v":-16.52112676056338},{"$f":"(G4-D4)/D4","v":56.214285714285722},{"$f":"(H4-E4)/E4","v":10.077856420626896},{"$f":"(I4-F4)/F4","v":3.1404264972776774},{"$f":"(J4-G4)/G4","v":4.0262172284644189},{"$f":"(K4-H4)/H4","v":2.1035962029937934},{"$f":"(L4-I4)/I4","v":1.6742644238671858}]
["Abnormal margin exclusion (RM cycle)"]
["1 Yr Operating Leverage",null,{"$f":"IF((C3-B3)>0,(C8/C7),0)","v":0},-4.0400423232150429,8.4866579796017927,3.8683476335129705,0.13950099689147213,1.714880305154467,1.1608922049382753,2.4244485477403535,1.1516997627000669,4.9240893194618405]
["3Yr Operating Leverage",null,null,null,{"$f":"IF((E3-B3)>0,E10/E9,0)","v":0.50449465710667107},{"$f":"IF((F3-C3)>0,F10/F9,0)","v":-3.533104892856056},9.2468206905403694,2.2662250464196281,0.89059303535340506,1.9041414433381367,1.4868058457073834,2.4976715472997024]
["EBIT Margin",{"$f":"B4/B3","v":6.448321599836751E-2},-4.0975328235463855E-2,9.1763163644308469E-3,4.7605294825511436E-2,0.11204595714394651,7.4162088759953101E-2,9.6817808255494395E-2,0.10249570384014915,0.11968547631906218,0.12443187224169858,0.16409966748366839]
["Invested Capital",{"$f":"'Calculated Data'!B13","v":82.09},{"$f":"'Calculated Data'!C13","v":78.62},{"$f":"'Calculated Data'!D13","v":69.699999999999989},{"$f":"'Calculated Data'!E13","v":89.49},{"$f":"'Calculated Data'!F13","v":98.41},{"$f":"'Calculated Data'!G13","v":151.31},{"$f":"'Calculated Data'!H13","v":195.38},{"$f":"'Calculated Data'!I13","v":212.6},{"$f":"'Calculated Data'!J13","v":400.34999999999997},{"$f":"'Calculated Data'!K13","v":302.38},{"$f":"'Balance Sheet'!L10+'Balance Sheet'!L11+'Balance Sheet'!L16","v":0}]
["Capital Turns",{"$f":"B3/B15","v":1.1939334876355221},0.88158229458153137,1.313342898134864,2.3214884344619513,3.9976628391423641,4.2828629964972569,5.7918415395639267,8.3756349952963323,5.0413138503809174,9.0371717706197501,{"$error":"#DIV/0!"}]
["RoIC",{"$f":"'Calculated Data'!B24","v":5.1909028154612277E-2},{"$f":"'Calculated Data'!C24","v":-2.5464437785434186E-2},{"$f":"'Calculated Data'!D24","v":6.3679023638425437E-3},{"$f":"'Calculated Data'!E24","v":7.3746398674615091E-2},{"$f":"'Calculated Data'!F24","v":0.31402676716249245},{"$f":"'Calculated Data'!G24","v":0.21717160540582642},{"$f":"'Calculated Data'!H24","v":0.37189835411955507},{"$f":"'Calculated Data'!I24","v":0.55644713090846099},{"$f":"'Calculated Data'!J24","v":0.40273779671941479},{"$f":"'Calculated Data'!K24","v":0.76073495457034568},{"$f":"(L4/L15)*(1-'Calculated Data'!K22)","v":{"$error":"#DIV/0!"}}]
["5Yr Rolling RoIIC",{"$f":"Customization!B58","v":0},{"$f":"Customization!C58","v":0},{"$f":"Customization!D58","v":0},{"$f":"Customization!E58","v":0},{"$f":"Customization!F58","v":0},{"$f":"Customization!G58","v":0},{"$f":"Customization!H58","v":1.0786407761711863},{"$f":"Customization!I58","v":1.0093937755770723},{"$f":"Customization!J58","v":1.0821309426118011},{"$f":"Customization!K58","v":0.64057022906298733}]
["EPA",{"$f":"'Calculated Data'!B26","v":-5.5895878787878779},{"$f":"'Calculated Data'!C26","v":-11.436414098690836},{"$f":"'Calculated Data'!D26","v":-7.920157205240173},{"$f":"'Calculated Data'!E26","v":-4.1392347826086953},{"$f":"'Calculated Data'!F26","v":19.09417415646088},{"$f":"'Calculated Data'!G26","v":14.703035613955596},{"$f":"'Calculated Data'!H26","v":49.215900427878672},{"$f":"'Calculated Data'!I26","v":92.788660031138804},{"$f":"'Calculated Data'!J26","v":113.1940769166177},{"$f":"'Calculated Data'!K26","v":193.74543556298113},{"$f":"L15*(L17-'Calculated Data'!K25)","v":{"$error":"#DIV/0!"}}]
["EPA/Sales",{"$f":"B19/B3","v":-5.7030791539515124E-2},-0.16500381039807871,-8.6521271632512262E-2,-1.9924114477057497E-2,4.8535050345595888E-2,2.2688469251829511E-2,4.3491927808943606E-2,5.2109139325384295E-2,5.6084148916467756E-2,7.0899942020954357E-2,{"$error":"#DIV/0!"}]
["Sustainable Growth Rate (without addl financing?)",{"$f":"'Calculated Data'!B31","v":3.4652035807103665E-3},{"$f":"'Calculated Data'!C31","v":-0.10279001468428781},{"$f":"'Calculated Data'!D31","v":-1.8086696562032885E-2},{"$f":"'Calculated Data'!E31","v":3.7399309551208279E-2},{"$f":"'Calculated Data'!F31","v":0.23662001922871495},{"$f":"'Calculated Data'!G31","v":0.19304556354916066},{"$f":"'Calculated Data'!H31","v":0.31625549924820401},{"$f":"'Calculated Data'!I31","v":0.34279467752271103},{"$f":"'Calculated Data'!J31","v":0.31344166134487578},{"$f":"'Calculated Data'!K31","v":0.28504512381725633}]
["Business Robustness Snapshot (Quarterly)","Latest 10 Quarters Performance"]
[{"$f":"A2","v":"AVANTI FEEDS LTD"},{"$f":"'Data Sheet'!B41","v":"2015-03-31"},{"$f":"'Data Sheet'!C41","v":"2015-06-30"},{"$f":"'Data Sheet'!D41","v":"2015-09-30"},{"$f":"'Data Sheet'!E41","v":"2015-12-31"},{"$f":"'Data Sheet'!F41","v":"2016-03-31"},{"$f":"'Data Sheet'!G41","v":"2016-06-30"},{"$f":"'Data Sheet'!H41","v":"2016-09-30"},{"$f":"'Data Sheet'!I41","v":"2016-12-31"},{"$f":"'Data Sheet'!J41","v":"2017-03-31"},{"$f":"'Data Sheet'!K41","v":"2017-06-30"}]
["Sales",{"$f":"'Data Sheet'!B42","v":381.45},{"$f":"'Data Sheet'!C42","v":603.4},{"$f":"'Data Sheet'!D42","v":532.95000000000005},{"$f":"'Data Sheet'!E42","v":413.11},{"$f":"'Data Sheet'!F42","v":468.83},{"$f":"'Data Sheet'!G42","v":724.38},{"$f":"'Data Sheet'!H42","v":713.06},{"$f":"'Data Sheet'!I42","v":558.63},{"$f":"'Data Sheet'!J42","v":704.43},{"$f":"'Data Sheet'!K42","v":998.17}]
["EBIT",{"$f":"Quarters!B16","v":36.160000000000004},{"$f":"Quarters!C16","v":69.080000000000013},{"$f":"Quarters!D16","v":65.77},{"$f":"Quarters!E16","v":56.41},{"$f":"Quarters!F16","v":48.480000000000004},{"$f":"Quarters!G16","v":75.180000000000007},{"$f":"Quarters!H16","v":60.18},{"$f":"Quarters!I16","v":68.55},{"$f":"Quarters!J16","v":132.27000000000001},{"$f":"Quarters!K16","v":227.08}]
["Operating Profit (ex Other Income)",{"$f":"Quarters!B6","v":36.880000000000003},{"$f":"Quarters!C6","v":64.150000000000006},{"$f":"Quarters!D6","v":62.45},{"$f":"Quarters!E6","v":55.49},{"$f":"Quarters!F6","v":46.39},{"$f":"Quarters!G6","v":76.040000000000006},{"$f":"Quarters!H6","v":56.43},{"$f":"Quarters!I6","v":68.900000000000006},{"$f":"Quarters!J6","v":128.09},{"$f":"Quarters!K6","v":224.97}]
["EBIT Margin",{"$f":"B25/B24","v":9.4796172499672315E-2},{"$f":"C25/C24","v":0.11448458733841567},0.12340744910404351,0.13654958727699643,0.10340635198259499,0.1037853060548331,8.4396824951616975E-2,0.12271091778099995,0.18776883437673014,0.22749631826242026]
["Operating Profit Margin (ex Other Income)",{"$f":"B26/B24","v":9.6683706907851635E-2},{"$f":"C26/C24","v":0.10631421942326816},0.11717797166713576,0.13432257752172544,9.8948446131860171E-2,0.10497252823103896,7.913780046559897E-2,0.12333745054866371,0.18183495876098407,0.22538244988328643]
["Threshold Margin Snapshot",{"$f":"B2","v":"2008-03-31"},{"$f":"C2","v":"2009-03-31"},"2010-03-31","2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31","2017-03-31","TTM"]
["Incremental Fixed Capital Investment Rate",null,{"$f":"('Calculated Data'!C18-'Data Sheet'!C26)/('Business Robustness'!C3-'Business Robustness'!B3)","v":0.12264808362369334},{"$f":"('Calculated Data'!D18-'Data Sheet'!D26)/('Business Robustness'!D3-'Business Robustness'!C3)","v":-9.8515519568151189E-2},{"$f":"('Calculated Data'!E18-'Data Sheet'!E26)/('Business Robustness'!E3-'Business Robustness'!D3)","v":8.639531881937873E-2},{"$f":"('Calculated Data'!F18-'Data Sheet'!F26)/('Business Robustness'!F3-'Business Robustness'!E3)","v":3.6949262091996136E-2},{"$f":"('Calculated Data'!G18-'Data Sheet'!G26)/('Business Robustness'!G3-'Business Robustness'!F3)","v":3.0161410674311745E-2},{"$f":"('Calculated Data'!H18-'Data Sheet'!H26)/('Business Robustness'!H3-'Business Robustness'!G3)","v":6.1790433649730143E-2},{"$f":"('Calculated Data'!I18-'Data Sheet'!I26)/('Business Robustness'!I3-'Business Robustness'!H3)","v":1.1170171789538537E-2},{"$f":"('Calculated Data'!J18-'Data Sheet'!J26)/('Business Robustness'!J3-'Business Robustness'!I3)","v":0.23582880949375087},{"$f":"('Calculated Data'!K18-'Data Sheet'!K26)/('Business Robustness'!K3-'Business Robustness'!J3)","v":0.13064658370312307}]
["Incremental Working Capital Investment Rate",null,{"$f":"('Calculated Data'!C11-'Calculated Data'!B11)/('Business Robustness'!C3-'Business Robustness'!B3)","v":-1.7421602787457929E-3},{"$f":"('Calculated Data'!D11-'Calculated Data'!C11)/('Business Robustness'!D3-'Business Robustness'!C3)","v":-0.30274403958614499},{"$f":"('Calculated Data'!E11-'Calculated Data'!D11)/('Business Robustness'!E3-'Business Robustness'!D3)","v":8.3899836502882713E-2},{"$f":"('Calculated Data'!F11-'Calculated Data'!E11)/('Business Robustness'!F3-'Business Robustness'!E3)","v":1.1095551007217505E-2},{"$f":"('Calculated Data'!G11-'Calculated Data'!F11)/('Business Robustness'!G3-'Business Robustness'!F3)","v":0.17759101441306996},{"$f":"('Calculated Data'!H11-'Calculated Data'!G11)/('Business Robustness'!H3-'Business Robustness'!G3)","v":2.9344252124821609E-2},{"$f":"('Calculated Data'!I11-'Calculated Data'!H11)/('Business Robustness'!I3-'Business Robustness'!H3)","v":1.5360912102303404E-2},{"$f":"('Calculated Data'!J11-'Calculated Data'!I11)/('Business Robustness'!J3-'Business Robustness'!I3)","v":0.5542650338761943},{"$f":"('Calculated Data'!K11-'Calculated Data'!J11)/('Business Robustness'!K3-'Business Robustness'!J3)","v":-0.26778840096868572}]
["Incremental Threshold Margin",null,{"$f":"((C30+C31)*'Calculated Data'!C25)/((1+'Calculated Data'!C25)*(1-'Calculated Data'!C22))","v":1.8376466614520338E-2},{"$f":"((D30+D31)*'Calculated Data'!D25)/((1+'Calculated Data'!D25)*(1-'Calculated Data'!D22))","v":-8.1365205767119669E-2},{"$f":"((E30+E31)*'Calculated Data'!E25)/((1+'Calculated Data'!E25)*(1-'Calculated Data'!E22))","v":2.7343020183774679E-2},{"$f":"((F30+F31)*'Calculated Data'!F25)/((1+'Calculated Data'!F25)*(1-'Calculated Data'!F22))","v":7.3425247215413965E-3},{"$f":"((G30+G31)*'Calculated Data'!G25)/((1+'Calculated Data'!G25)*(1-'Calculated Data'!G22))","v":3.2555353746652325E-2},{"$f":"((H30+H31)*'Calculated Data'!H25)/((1+'Calculated Data'!H25)*(1-'Calculated Data'!H22))","v":1.472294147912382E-2},{"$f":"((I30+I31)*'Calculated Data'!I25)/((1+'Calculated Data'!I25)*(1-'Calculated Data'!I22))","v":4.3854858458211993E-3},{"$f":"((J30+J31)*'Calculated Data'!J25)/((1+'Calculated Data'!J25)*(1-'Calculated Data'!J22))","v":0.12682494986825849},{"$f":"((K30+K31)*'Calculated Data'!K25)/((1+'Calculated Data'!K25)*(1-'Calculated Data'!K22))","v":-2.1720205218650788E-2}]
["Threshold Margin (Value Neutral Operating Margin)",null,{"$f":"(B4+(C32*(C3-B3)))/C3","v":8.3575175417158656E-2},{"$f":"(C4+(D32*(D3-C3)))/D3","v":-5.0783794234248093E-2},1.9338302650091236E-2,2.8604288502583501E-2,8.0812248818761312E-2,4.8762005294279751E-2,6.3126256325312102E-2,0.10536018750387419,8.271930536471879E-2,"higher capital intensity business demands higher threshold margin (to break even) than lower cap intensive"]
["Threshold Exceed Rate",null,{"$f":"C14-C33","v":-0.12455050365262252},{"$f":"D14-D33","v":5.9960110598678937E-2},2.82669921754202E-2,8.3441668641363015E-2,-6.6501600588082105E-3,4.8055802961214644E-2,3.936944751483705E-2,1.4325288815187992E-2,4.1712566876979787E-2]

{"sheet":"Buffet-Valuation","index":10,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,3,1,12],[3,8,3,12],[4,8,4,12],[0,3,0,12],[2,7,2,12],[19,0,19,1],[12,0,12,1],[26,0,26,1],[33,0,33,1],[0,0,0,1],[1,0,1,1],[5,7,5,12],[6,8,6,12],[22,7,22,12],[19,7,19,12],[25,7,25,12],[11,7,11,12],[12,7,12,12],[13,7,13,12],[14,3,14,12],[17,8,17,12],[7,8,7,12],[8,7,8,12],[9,8,9,12],[10,8,10,12],[15,3,15,12],[16,7,16,12],[28,3,28,12],[26,7,26,12],[27,7,27,12],[18,8,18,12],[20,8,20,12],[21,8,21,12],[24,8,24,12]]}
[{"$f":"'Data Sheet'!B1","v":"AVANTI FEEDS LTD"},null,null,"(adapted from the methodology described in the book \"Buffetology\" by Mary Buffet - using current Visibility aided by Historicals)"]
["Current Data",null,null,"10 yr Projected Company data using historical earnings growth rate/current visibility",null,null,null,null,null,null,null,null,null,null,"10yr Sales Projection"]
["Price",{"$f":"'Data Sheet'!B8","v":1942.95},null,"Year","EPS","DPS",null,null,null,null,null,null,null,null,"Year","Sales"]
["EPS:",{"$f":"'Profit & Loss'!L13","v":68.516679208291066},null,"Current",{"$f":"B4","v":68.516679208291066},{"$f":"B5","v":6.9998575367151217},null,{"$f":"E14","v":68.516679208291066},"Earnings after 10 years",null,null,null,null,null,"Current",{"$f":"'Profit & Loss'!K4","v":2732.66}]
["DPS:",{"$f":"'Profit & Loss'!K22","v":6.9998575367151217},null,"Year 1",{"$f":"E4*(1+$B$21)","v":68.516679208291066},{"$f":"E5*$B$36","v":0},null,{"$f":"SUM(F5:F14)","v":0},"Dividends paid over 10 years",null,null,null,null,null,"Year 1",{"$f":"P4*(1+$B$14)","v":2732.66}]
["BVPS:",{"$f":"'Balance Sheet'!K32","v":141.0232386902978},null,"Year 2",68.516679208291066,0,null,null,null,null,null,null,null,null,"Year 2",2732.66]
["P/E:",{"$f":"B3/B4","v":28.357328791335927},null,"Year 3",68.516679208291066,0,null,{"$f":"$B$33*H4","v":0},"Projected price [Avg Sustainable P/E*EPS]",null,null,null,null,null,"Year 3",2732.66]
["Earnings Yield:",{"$f":"B4/B3","v":3.5264252403968743E-2},null,"Year 4",68.516679208291066,0,null,{"$f":"H7+H5","v":0},"Total Gain [Projected Price+Dividends]",null,null,null,null,null,"Year 4",2732.66]
["Dividend Yield:",{"$f":"B5/B3","v":3.6026956621195202E-3},null,"Year 5",68.516679208291066,0,null,null,null,null,null,null,null,null,"Year 5",2732.66]
["P/BV:",{"$f":"B3/B6","v":13.777516514614497},null,"Year 6",68.516679208291066,0,null,{"$f":"POWER(H8/$B$3,1/9)-1","v":-1},"Projected annual return using current EPS growth visibility",null,null,null,null,null,"Year 6",2732.66]
[null,null,null,"Year 7",68.516679208291066,0,null,null,"[(Total Gain/Current Price)^1/9)-1]",null,null,null,null,null,"Year 7",2732.66]
["Input Visibility data ","below",null,"Year 8",68.516679208291066,0,null,null,null,null,null,null,null,null,"Year 8",2732.66]
["Sales",null,null,"Year 9",68.516679208291066,0,null,null,null,null,null,null,null,null,"Year 9",2732.66]
["Med Term Visibility",null,null,"Year 10",68.516679208291066,0,null,null,null,null,null,null,null,null,"Year 10",2732.66]
["Sales 10 Yr CAGR",{"$f":"POWER('Profit & Loss'!K4/'Profit & Loss'!B4, 1/9)-1","v":0.44740670106639846}]
["Sales 5yr CAGR",{"$f":"POWER('Profit & Loss'!K4/'Profit & Loss'!G4, 1/4)-1","v":0.43299919556683952},null,"10 yr Projected Company data using sustainable growth rate based on current visibility"]
["Sales 3yr CAGR",{"$f":"POWER('Profit & Loss'!K4/'Profit & Loss'!I4, 1/2)-1","v":0.23880314250591805},null,"Year","BVPS","EPS","DPS"]
["Sales Y-o-Y growth",{"$f":"('Profit & Loss'!K4-'Profit & Loss'!J4)/'Profit & Loss'!J4","v":0.35394814422109799},null,"Current",{"$f":"B6","v":141.0232386902978},{"$f":"B4","v":68.516679208291066},{"$f":"B5","v":6.9998575367151217},{"$f":"F28","v":0},"Earnings after 10 years"]
["Sales TTM Growth",{"$f":"('Profit & Loss'!L4-'Profit & Loss'!K4)/'Profit & Loss'!K4","v":8.8423001763849193E-2},null,"Year 1",{"$f":"E18+F18-G18","v":202.54006036187374},{"$f":"E19*$B$37","v":0},{"$f":"F19*$B$36","v":0},{"$f":"SUM(G19:G28)","v":0},"Dividends paid over 10 years"]
["EPS",null,null,"Year 2",{"$f":"E19+F19-G19","v":202.54006036187374},0,0]
["Med Term Visibility",null,null,"Year 3",202.54006036187374,0,0,{"$f":"$B$33*H18","v":0},"Projected price [Avg Sustainable P/E*EPS]"]
["EPS 10 Yr CAGR",{"$f":"POWER('Profit & Loss'!K13/'Profit & Loss'!B13, 1/9)-1","v":0.77331813870363542},null,"Year 4",202.54006036187374,0,0,{"$f":"H21+H19","v":0},"Total Gain [Projected Price+Dividends]"]
["EPS 5yr CAGR",{"$f":"POWER('Profit & Loss'!K13/'Profit & Loss'!G13, 1/4)-1","v":0.63425473852290026},null,"Year 5",202.54006036187374,0,0]
["EPS 3yr CAGR",{"$f":"POWER('Profit & Loss'!K13/'Profit & Loss'!I13, 1/2)-1","v":0.35982354841197495},null,"Year 6",202.54006036187374,0,0,{"$f":"POWER(H22/$B$3,1/9)-1","v":-1},"Projected annual return using sustainable growth visbility*"]
["EPS Y-o-Y growth",{"$f":"('Profit & Loss'!K13-'Profit & Loss'!J13)/'Profit & Loss'!J13","v":0.36095238095238075},null,"Year 7",{"$f":"E24+F24-G24","v":202.54006036187374},0,0,null,"[(Total Gain/Current Price)^1/9)-1]"]
["EPS TTM Growth",{"$f":"('Profit & Loss'!L13-'Profit & Loss'!K13)/'Profit & Loss'!K13","v":0.45169086762172755},null,"Year 8",{"$f":"E25+F25-G25","v":202.54006036187374},0,0]
["5Yr Averages",null,null,"Year 9",{"$f":"E26+F26-G26","v":202.54006036187374},0,0]
["Return on Equity:",{"$f":"AVERAGE(Customization!G53:K53)","v":0.35529473319877769},null,"Year 10",{"$f":"E27+F27-G27","v":202.54006036187374},0,0]
["Payout Ratio:",{"$f":"AVERAGE('Profit & Loss'!G23:K23)","v":0.18243666507114531},null,"*Assuming current capital structure is maintained - business's inherent ability to grow with internal accruals from here"]
["P/E Ratio-High:",{"$f":"MAX('Calculated Data'!G38:K38)","v":18.064596313552602}]
["P/E Ratio-Low:",{"$f":"MIN('Calculated Data'!G38:K38)","v":3.1616845031613985}]
["Avg. P/E Ratio:",{"$f":"AVERAGE('Calculated Data'!G38:K39)","v":7.4419554195855628}]
["Avg Sustainable P/E"]
["RoE/Payout Visibility"]
["RoE Visibility"]
["Payout Visbility"]
["Sustainable Growth",{"$f":"B35*(1-B36)","v":0}]