{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Profit & Loss","Quarters","Balance Sheet","Cash Flow","Customization","Data Sheet","Calculated Data","Cost Analysis","Price Implied Expectations","Business Robustness","Buffet-Valuation","Deep Dive","Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Profit & Loss","index":0,"n_rows":29,"n_cols":14,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Data Sheet'!B1","v":"AXTEL INDUSTRIES LTD"},null,null,null,null,null,null,{"$f":"UPDATE","v":""},null,null,null,null,"SCREENER.IN"]
[]
["Narration",{"$f":"'Data Sheet'!B16","v":"2010-03-31"},{"$f":"'Data Sheet'!C16","v":"2011-03-31"},{"$f":"'Data Sheet'!D16","v":"2012-03-31"},{"$f":"'Data Sheet'!E16","v":"2013-03-31"},{"$f":"'Data Sheet'!F16","v":"2014-03-31"},{"$f":"'Data Sheet'!G16","v":"2015-03-31"},{"$f":"'Data Sheet'!H16","v":"2016-03-31"},{"$f":"'Data Sheet'!I16","v":"2017-03-31"},{"$f":"'Data Sheet'!J16","v":"2018-03-31"},{"$f":"'Data Sheet'!K16","v":"2019-03-31"},"Trailing","Best Case","Worst Case"]
["Sales",{"$f":"'Data Sheet'!B17","v":27.05},{"$f":"'Data Sheet'!C17","v":54.09},{"$f":"'Data Sheet'!D17","v":58.41},{"$f":"'Data Sheet'!E17","v":60.03},{"$f":"'Data Sheet'!F17","v":48.01},{"$f":"'Data Sheet'!G17","v":39.229999999999997},{"$f":"'Data Sheet'!H17","v":66.930000000000007},{"$f":"'Data Sheet'!I17","v":76.11},{"$f":"'Data Sheet'!J17","v":81.5},{"$f":"'Data Sheet'!K17","v":110.75},{"$f":"SUM(Quarters!H4:K4)","v":106.33999999999999},{"$f":"$K4+M27*K4","v":150.49769938650306},{"$f":"$K4+N27*L4","v":120.92730896451768}]
["Expenses",{"$f":"SUM('Data Sheet'!B18,'Data Sheet'!B20:B24, -1*'Data Sheet'!B19)","v":25.079999999999995},{"$f":"SUM('Data Sheet'!C18,'Data Sheet'!C20:C24, -1*'Data Sheet'!C19)","v":48.62},{"$f":"SUM('Data Sheet'!D18,'Data Sheet'!D20:D24, -1*'Data Sheet'!D19)","v":52.190000000000005},{"$f":"SUM('Data Sheet'!E18,'Data Sheet'!E20:E24, -1*'Data Sheet'!E19)","v":53.27},{"$f":"SUM('Data Sheet'!F18,'Data Sheet'!F20:F24, -1*'Data Sheet'!F19)","v":39.07},{"$f":"SUM('Data Sheet'!G18,'Data Sheet'!G20:G24, -1*'Data Sheet'!G19)","v":41.52},{"$f":"SUM('Data Sheet'!H18,'Data Sheet'!H20:H24, -1*'Data Sheet'!H19)","v":56.609999999999992},{"$f":"SUM('Data Sheet'!I18,'Data Sheet'!I20:I24, -1*'Data Sheet'!I19)","v":65.430000000000007},{"$f":"SUM('Data Sheet'!J18,'Data Sheet'!J20:J24, -1*'Data Sheet'!J19)","v":71.41},{"$f":"SUM('Data Sheet'!K18,'Data Sheet'!K20:K24, -1*'Data Sheet'!K19)","v":90.86999999999999},{"$f":"SUM(Quarters!H5:K5)","v":88.22999999999999},{"$f":"M4-M6","v":124.86751943644127},105.31256120428283]
["Operating Profit",{"$f":"B4-B5","v":1.970000000000006},{"$f":"C4-C5","v":5.470000000000006},6.2199999999999918,6.759999999999998,8.9399999999999977,-2.2900000000000063,10.320000000000014,10.679999999999993,10.090000000000003,19.88000000000001,{"$f":"SUM(Quarters!H6:K6)","v":18.11},{"$f":"M4*M28","v":25.630179950061791},{"$f":"N4*N28","v":15.614747760234854}]
["Other Income",{"$f":"'Data Sheet'!B25","v":7.0000000000000007E-2},{"$f":"'Data Sheet'!C25","v":0.02},{"$f":"'Data Sheet'!D25","v":0.1},{"$f":"'Data Sheet'!E25","v":0.33},{"$f":"'Data Sheet'!F25","v":0.2},{"$f":"'Data Sheet'!G25","v":0.23},{"$f":"'Data Sheet'!H25","v":0.22},{"$f":"'Data Sheet'!I25","v":1.17},{"$f":"'Data Sheet'!J25","v":0.68},{"$f":"'Data Sheet'!K25","v":1.59},{"$f":"SUM(Quarters!H7:K7)","v":2.2199999999999998},0,0]
["Depreciation",{"$f":"'Data Sheet'!B26","v":0.65},{"$f":"'Data Sheet'!C26","v":0.73},{"$f":"'Data Sheet'!D26","v":0.93},{"$f":"'Data Sheet'!E26","v":1.38},{"$f":"'Data Sheet'!F26","v":2.8},{"$f":"'Data Sheet'!G26","v":3.89},{"$f":"'Data Sheet'!H26","v":3.45},{"$f":"'Data Sheet'!I26","v":2.78},{"$f":"'Data Sheet'!J26","v":2.39},{"$f":"'Data Sheet'!K26","v":2.8},{"$f":"SUM(Quarters!H8:K8)","v":2.67},{"$f":"+$L8","v":2.67},{"$f":"+$L8","v":2.67}]
["Interest",{"$f":"'Data Sheet'!B27","v":0.33},{"$f":"'Data Sheet'!C27","v":0.45},{"$f":"'Data Sheet'!D27","v":0.92},{"$f":"'Data Sheet'!E27","v":0.71},{"$f":"'Data Sheet'!F27","v":2.1800000000000002},{"$f":"'Data Sheet'!G27","v":1.94},{"$f":"'Data Sheet'!H27","v":1.37},{"$f":"'Data Sheet'!I27","v":0.75},{"$f":"'Data Sheet'!J27","v":0.5},{"$f":"'Data Sheet'!K27","v":0.48},{"$f":"SUM(Quarters!H9:K9)","v":0.6},{"$f":"+$L9","v":0.6},{"$f":"+$L9","v":0.6}]
["Profit before tax",{"$f":"'Data Sheet'!B28","v":1.06},{"$f":"'Data Sheet'!C28","v":4.3099999999999996},{"$f":"'Data Sheet'!D28","v":4.47},{"$f":"'Data Sheet'!E28","v":5},{"$f":"'Data Sheet'!F28","v":4.16},{"$f":"'Data Sheet'!G28","v":-7.89},{"$f":"'Data Sheet'!H28","v":5.72},{"$f":"'Data Sheet'!I28","v":8.32},{"$f":"'Data Sheet'!J28","v":7.88},{"$f":"'Data Sheet'!K28","v":18.190000000000001},{"$f":"SUM(Quarters!H10:K10)","v":17.060000000000002},{"$f":"M6+M7-SUM(M8:M9)","v":22.360179950061791},{"$f":"N6+N7-SUM(N8:N9)","v":12.344747760234855}]
["Tax",{"$f":"'Data Sheet'!B29","v":0.4},{"$f":"'Data Sheet'!C29","v":1.89},{"$f":"'Data Sheet'!D29","v":1.45},{"$f":"'Data Sheet'!E29","v":1.63},{"$f":"'Data Sheet'!F29","v":1.4},{"$f":"'Data Sheet'!G29","v":-0.35},{"$f":"'Data Sheet'!H29","v":0.92},{"$f":"'Data Sheet'!I29","v":1.49},{"$f":"'Data Sheet'!J29","v":1.96},{"$f":"'Data Sheet'!K29","v":5.24},{"$f":"SUM(Quarters!H11:K11)","v":4.75},{"$f":"IF($L10>0,$L11/$L10,0)","v":0.27842907385697535},{"$f":"IF($L10>0,$L11/$L10,0)","v":0.27842907385697535}]
["Net profit",{"$f":"'Data Sheet'!B30","v":0.66},{"$f":"'Data Sheet'!C30","v":2.42},{"$f":"'Data Sheet'!D30","v":3.02},{"$f":"'Data Sheet'!E30","v":3.38},{"$f":"'Data Sheet'!F30","v":2.76},{"$f":"'Data Sheet'!G30","v":-7.54},{"$f":"'Data Sheet'!H30","v":4.8},{"$f":"'Data Sheet'!I30","v":6.84},{"$f":"'Data Sheet'!J30","v":5.93},{"$f":"'Data Sheet'!K30","v":12.96},{"$f":"SUM(Quarters!H12:K12)","v":12.309999999999999},{"$f":"M10-M11*M10","v":16.134455755290777},{"$f":"N10-N11*N10","v":8.9076110743546941}]
["EPS",{"$f":"IF('Data Sheet'!B93>0,B12/'Data Sheet'!B93,0)","v":0.66001320026400534},{"$f":"IF('Data Sheet'!C93>0,C12/'Data Sheet'!C93,0)","v":2.4200484009680192},{"$f":"IF('Data Sheet'!D93>0,D12/'Data Sheet'!D93,0)","v":3.0200604012080241},{"$f":"IF('Data Sheet'!E93>0,E12/'Data Sheet'!E93,0)","v":3.3800676013520272},{"$f":"IF('Data Sheet'!F93>0,F12/'Data Sheet'!F93,0)","v":2.7600552011040218},{"$f":"IF('Data Sheet'!G93>0,G12/'Data Sheet'!G93,0)","v":-4.6673434521009236},{"$f":"IF('Data Sheet'!H93>0,H12/'Data Sheet'!H93,0)","v":2.9712531260058928},{"$f":"IF('Data Sheet'!I93>0,I12/'Data Sheet'!I93,0)","v":4.234035704558397},{"$f":"IF('Data Sheet'!J93>0,J12/'Data Sheet'!J93,0)","v":3.6707356327531135},{"$f":"IF('Data Sheet'!K93>0,K12/'Data Sheet'!K93,0)","v":8.0223834402159113},{"$f":"IF('Data Sheet'!$B6>0,'Profit & Loss'!L12/'Data Sheet'!$B6,0)","v":7.6200752393980844},{"$f":"IF('Data Sheet'!$B6>0,'Profit & Loss'!M12/'Data Sheet'!$B6,0)","v":9.9874709018728822},{"$f":"IF('Data Sheet'!$B6>0,'Profit & Loss'!N12/'Data Sheet'!$B6,0)","v":5.5139452956846773}]
["Price to earning",{"$f":"IF(B15>0,B15/B13,\"\")","v":18.166303333333332},{"$f":"IF(C15>0,C15/C13,\"\")","v":6.0783908264462818},4.4999099999999999,2.3490654437869822,2.2825630434782611,-2.4425029177718836,4.9507730833333339,19.508574269005848,25.471733558178752,15.799543981481481,{"$f":"IF(L13>0,L15/L13,0)","v":11.876523151909018},{"$f":"M29","v":18.164093740143773},{"$f":"N29","v":11.098338069095329}]
["Price",{"$f":"'Data Sheet'!B90","v":11.99},{"$f":"'Data Sheet'!C90","v":14.71},{"$f":"'Data Sheet'!D90","v":13.59},{"$f":"'Data Sheet'!E90","v":7.94},{"$f":"'Data Sheet'!F90","v":6.3},{"$f":"'Data Sheet'!G90","v":11.4},{"$f":"'Data Sheet'!H90","v":14.71},{"$f":"'Data Sheet'!I90","v":82.6},{"$f":"'Data Sheet'!J90","v":93.5},{"$f":"'Data Sheet'!K90","v":126.75},{"$f":"'Data Sheet'!B8","v":90.5},{"$f":"M13*M14","v":181.41335768857729},{"$f":"N13*N14","v":61.195628986006355}]
[]
["EBIT",{"$f":"B10+B9","v":1.3900000000000001},{"$f":"C10+C9","v":4.76},5.39,5.71,6.34,-5.9499999999999993,7.09,9.07,8.379999999999999,18.670000000000002,17.660000000000004]
["EBITDA",{"$f":"B17+B8","v":2.04},{"$f":"C17+C8","v":5.49},6.3199999999999994,7.09,9.14,-2.0599999999999992,10.54,11.85,10.77,21.470000000000002,20.330000000000005]
["Operating Profit (excl Other Income)",{"$f":"B18-B7","v":1.97},{"$f":"C18-C7","v":5.4700000000000006},6.22,6.76,8.9400000000000013,-2.2899999999999991,10.319999999999999,10.68,10.09,19.880000000000003,18.110000000000007]
[]
["RATIOS:"]
["DPS",{"$f":"IF('Data Sheet'!B93>0,'Data Sheet'!B31/'Data Sheet'!B93,0)","v":0},{"$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},{"$f":"IF('Data Sheet'!F93>0,'Data Sheet'!F31/'Data Sheet'!F93,0)","v":0},{"$f":"IF('Data Sheet'!G93>0,'Data Sheet'!G31/'Data Sheet'!G93,0)","v":0},{"$f":"IF('Data Sheet'!H93>0,'Data Sheet'!H31/'Data Sheet'!H93,0)","v":0},{"$f":"IF('Data Sheet'!I93>0,'Data Sheet'!I31/'Data Sheet'!I93,0)","v":0},{"$f":"IF('Data Sheet'!J93>0,'Data Sheet'!J31/'Data Sheet'!J93,0)","v":1.4980067843613043},{"$f":"IF('Data Sheet'!K93>0,'Data Sheet'!K31/'Data Sheet'!K93,0)","v":1.4980067843613043}]
["Dividend Payout",{"$f":"IF('Data Sheet'!B30>0, 'Data Sheet'!B31/'Data Sheet'!B30, 0)","v":0},{"$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},{"$f":"IF('Data Sheet'!F30>0, 'Data Sheet'!F31/'Data Sheet'!F30, 0)","v":0},{"$f":"IF('Data Sheet'!G30>0, 'Data Sheet'!G31/'Data Sheet'!G30, 0)","v":0},{"$f":"IF('Data Sheet'!H30>0, 'Data Sheet'!H31/'Data Sheet'!H30, 0)","v":0},{"$f":"IF('Data Sheet'!I30>0, 'Data Sheet'!I31/'Data Sheet'!I30, 0)","v":0},{"$f":"IF('Data Sheet'!J30>0, 'Data Sheet'!J31/'Data Sheet'!J30, 0)","v":0.40809443507588533},{"$f":"IF('Data Sheet'!K30>0, 'Data Sheet'!K31/'Data Sheet'!K30, 0)","v":0.18672839506172836}]
["OPM",{"$f":"IF(B6>0,B6/B4,0)","v":7.2828096118299671E-2},{"$f":"IF(C6>0,C6/C4,0)","v":0.10112775004621936},0.10648861496319111,0.11261036148592367,0.18621120599875021,0,0.15419094576423148,0.14032321639731957,0.12380368098159514,0.17950338600451476,0.17030280233214221]
[]
[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.16955219208422889},{"$f":"IF(D4=0,\"\",POWER($K4/D4,1/7)-1)","v":9.5705369235637328E-2},{"$f":"IF(F4=0,\"\",POWER($K4/F4,1/5)-1)","v":0.18195898329350002},{"$f":"IF(H4=0,\"\",POWER($K4/H4, 1/3)-1)","v":0.18278997968577526},{"$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.35889570552147237},{"$f":"MAX(K27:L27)","v":0.35889570552147237},{"$f":"MIN(H27:L27)","v":9.5705369235637328E-2}]
[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.12912507434376558},{"$f":"IF(SUM(E4:$K$4)=0,\"\",SUMPRODUCT(E24:$K$24,E4:$K$4)/SUM(E4:$K$4))","v":0.13815898541114061},{"$f":"IF(SUM(G4:$K$4)=0,\"\",SUMPRODUCT(G24:$K$24,G4:$K$4)/SUM(G4:$K$4))","v":0.13609420057673829},{"$f":"IF(SUM(I4:$K$4)=0, \"\", SUMPRODUCT(I24:$K$24,I4:$K$4)/SUM(I4:$K$4))","v":0.15147562975108064},{"$f":"L24","v":0.17030280233214221},{"$f":"MAX(K28:L28)","v":0.17030280233214221},{"$f":"MIN(H28:L28)","v":0.12912507434376558}]
[null,null,null,null,null,null,"Price to Earning",{"$f":"IF(ISERROR(AVERAGEIF(B14:$L14,\">0\")),\"\",AVERAGEIF(B14:$L14,\">0\"))","v":11.098338069095329},{"$f":"IF(ISERROR(AVERAGEIF(E14:$L14,\">0\")),\"\",AVERAGEIF(E14:$L14,\">0\"))","v":11.748396647310525},{"$f":"IF(ISERROR(AVERAGEIF(G14:$L14,\">0\")),\"\",AVERAGEIF(G14:$L14,\">0\"))","v":15.521429608781684},{"$f":"IF(ISERROR(AVERAGEIF(I14:$L14,\">0\")),\"\",AVERAGEIF(I14:$L14,\">0\"))","v":18.164093740143773},{"$f":"L14","v":11.876523151909018},{"$f":"MAX(K29:L29)","v":18.164093740143773},{"$f":"MIN(H29:L29)","v":11.098338069095329}]

{"sheet":"Quarters","index":1,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Profit & Loss'!A1","v":"AXTEL INDUSTRIES LTD"},null,null,null,{"$f":"UPDATE","v":""},null,null,null,null,"SCREENER.IN"]
[]
["Narration",{"$f":"'Data Sheet'!B41","v":"2017-09-30"},{"$f":"'Data Sheet'!C41","v":"2017-12-31"},{"$f":"'Data Sheet'!D41","v":"2018-03-31"},{"$f":"'Data Sheet'!E41","v":"2018-06-30"},{"$f":"'Data Sheet'!F41","v":"2018-09-30"},{"$f":"'Data Sheet'!G41","v":"2018-12-31"},{"$f":"'Data Sheet'!H41","v":"2019-03-31"},{"$f":"'Data Sheet'!I41","v":"2019-06-30"},{"$f":"'Data Sheet'!J41","v":"2019-09-30"},{"$f":"'Data Sheet'!K41","v":"2019-12-31"}]
["Sales",{"$f":"'Data Sheet'!B42","v":24.16},{"$f":"'Data Sheet'!C42","v":14.39},{"$f":"'Data Sheet'!D42","v":30.06},{"$f":"'Data Sheet'!E42","v":21.37},{"$f":"'Data Sheet'!F42","v":30.28},{"$f":"'Data Sheet'!G42","v":28.97},{"$f":"'Data Sheet'!H42","v":30.13},{"$f":"'Data Sheet'!I42","v":17.829999999999998},{"$f":"'Data Sheet'!J42","v":30.83},{"$f":"'Data Sheet'!K42","v":27.55}]
["Expenses",{"$f":"'Data Sheet'!B43","v":21.88},{"$f":"'Data Sheet'!C43","v":13.09},{"$f":"'Data Sheet'!D43","v":25.22},{"$f":"'Data Sheet'!E43","v":18.86},{"$f":"'Data Sheet'!F43","v":24.86},{"$f":"'Data Sheet'!G43","v":23.19},{"$f":"'Data Sheet'!H43","v":23.96},{"$f":"'Data Sheet'!I43","v":16.54},{"$f":"'Data Sheet'!J43","v":26.1},{"$f":"'Data Sheet'!K43","v":21.63}]
["Operating Profit",{"$f":"'Data Sheet'!B50","v":2.2799999999999998},{"$f":"'Data Sheet'!C50","v":1.3},{"$f":"'Data Sheet'!D50","v":4.84},{"$f":"'Data Sheet'!E50","v":2.5099999999999998},{"$f":"'Data Sheet'!F50","v":5.42},{"$f":"'Data Sheet'!G50","v":5.78},{"$f":"'Data Sheet'!H50","v":6.17},{"$f":"'Data Sheet'!I50","v":1.29},{"$f":"'Data Sheet'!J50","v":4.7300000000000004},{"$f":"'Data Sheet'!K50","v":5.92}]
["Other Income",{"$f":"'Data Sheet'!B44","v":0.1},{"$f":"'Data Sheet'!C44","v":0.26},{"$f":"'Data Sheet'!D44","v":0.28999999999999998},{"$f":"'Data Sheet'!E44","v":0.24},{"$f":"'Data Sheet'!F44","v":0.84},{"$f":"'Data Sheet'!G44","v":0.63},{"$f":"'Data Sheet'!H44","v":-0.12},{"$f":"'Data Sheet'!I44","v":0.41},{"$f":"'Data Sheet'!J44","v":0.92},{"$f":"'Data Sheet'!K44","v":1.01}]
["Depreciation",{"$f":"'Data Sheet'!B45","v":0.55000000000000004},{"$f":"'Data Sheet'!C45","v":0.67},{"$f":"'Data Sheet'!D45","v":0.61},{"$f":"'Data Sheet'!E45","v":0.66},{"$f":"'Data Sheet'!F45","v":0.7},{"$f":"'Data Sheet'!G45","v":0.72},{"$f":"'Data Sheet'!H45","v":0.71},{"$f":"'Data Sheet'!I45","v":0.6},{"$f":"'Data Sheet'!J45","v":0.66},{"$f":"'Data Sheet'!K45","v":0.7}]
["Interest",{"$f":"'Data Sheet'!B46","v":7.0000000000000007E-2},{"$f":"'Data Sheet'!C46","v":0.18},{"$f":"'Data Sheet'!D46","v":0.12},{"$f":"'Data Sheet'!E46","v":7.0000000000000007E-2},{"$f":"'Data Sheet'!F46","v":0.15},{"$f":"'Data Sheet'!G46","v":0.13},{"$f":"'Data Sheet'!H46","v":0.13},{"$f":"'Data Sheet'!I46","v":0.1},{"$f":"'Data Sheet'!J46","v":0.13},{"$f":"'Data Sheet'!K46","v":0.24}]
["Profit before tax",{"$f":"'Data Sheet'!B47","v":1.76},{"$f":"'Data Sheet'!C47","v":0.71},{"$f":"'Data Sheet'!D47","v":4.4000000000000004},{"$f":"'Data Sheet'!E47","v":2.02},{"$f":"'Data Sheet'!F47","v":5.41},{"$f":"'Data Sheet'!G47","v":5.56},{"$f":"'Data Sheet'!H47","v":5.21},{"$f":"'Data Sheet'!I47","v":1},{"$f":"'Data Sheet'!J47","v":4.8600000000000003},{"$f":"'Data Sheet'!K47","v":5.99}]
["Tax",{"$f":"'Data Sheet'!B48","v":0},{"$f":"'Data Sheet'!C48","v":0},{"$f":"'Data Sheet'!D48","v":1.96},{"$f":"'Data Sheet'!E48","v":0},{"$f":"'Data Sheet'!F48","v":0},{"$f":"'Data Sheet'!G48","v":0},{"$f":"'Data Sheet'!H48","v":1.5},{"$f":"'Data Sheet'!I48","v":0.28999999999999998},{"$f":"'Data Sheet'!J48","v":1.42},{"$f":"'Data Sheet'!K48","v":1.54}]
["Net profit",{"$f":"'Data Sheet'!B49","v":1.76},{"$f":"'Data Sheet'!C49","v":0.71},{"$f":"'Data Sheet'!D49","v":2.4500000000000002},{"$f":"'Data Sheet'!E49","v":2.02},{"$f":"'Data Sheet'!F49","v":5.41},{"$f":"'Data Sheet'!G49","v":5.56},{"$f":"'Data Sheet'!H49","v":3.71},{"$f":"'Data Sheet'!I49","v":0.71},{"$f":"'Data Sheet'!J49","v":3.44},{"$f":"'Data Sheet'!K49","v":4.45}]
[]
["OPM",{"$f":"IF(B4>0,B6/B4,\"\")","v":9.4370860927152314E-2},{"$f":"IF(C4>0,C6/C4,\"\")","v":9.0340514246004172E-2},0.16101131071190952,0.11745437529246607,0.17899603698811095,0.19951674145667933,0.20477928974444076,7.234997195737522E-2,0.15342199156665587,0.21488203266787659]
[]
["EBIT",{"$f":"B10+B9","v":1.83},{"$f":"C10+C9","v":0.8899999999999999},4.5200000000000005,2.09,5.5600000000000005,5.6899999999999995,5.34,1.1000000000000001,4.99,6.23]
["EBITDA",{"$f":"B16+B8","v":2.38},{"$f":"C16+C8","v":1.56},5.1300000000000008,2.75,6.2600000000000007,6.4099999999999993,6.05,1.7000000000000002,5.65,6.9300000000000006]

{"sheet":"Balance Sheet","index":2,"n_rows":44,"n_cols":14,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Profit & Loss'!A1","v":"AXTEL INDUSTRIES LTD"},null,null,null,{"$f":"UPDATE","v":""},null,null,null,null,"SCREENER.IN"]
[]
["Narration",{"$f":"'Data Sheet'!B56","v":"2010-03-31"},{"$f":"'Data Sheet'!C56","v":"2011-03-31"},{"$f":"'Data Sheet'!D56","v":"2012-03-31"},{"$f":"'Data Sheet'!E56","v":"2013-03-31"},{"$f":"'Data Sheet'!F56","v":"2014-03-31"},{"$f":"'Data Sheet'!G56","v":"2015-03-31"},{"$f":"'Data Sheet'!H56","v":"2016-03-31"},{"$f":"'Data Sheet'!I56","v":"2017-03-31"},{"$f":"'Data Sheet'!J56","v":"2018-03-31"},{"$f":"'Data Sheet'!K56","v":"2019-03-31"},"2HFY20","Input data from 2QFY BS"]
["Equity Share Capital",{"$f":"'Data Sheet'!B57","v":10},{"$f":"'Data Sheet'!C57","v":10},{"$f":"'Data Sheet'!D57","v":10},{"$f":"'Data Sheet'!E57","v":10},{"$f":"'Data Sheet'!F57","v":10},{"$f":"'Data Sheet'!G57","v":16.149999999999999},{"$f":"'Data Sheet'!H57","v":16.149999999999999},{"$f":"'Data Sheet'!I57","v":16.149999999999999},{"$f":"'Data Sheet'!J57","v":16.149999999999999},{"$f":"'Data Sheet'!K57","v":16.149999999999999}]
["Reserves",{"$f":"'Data Sheet'!B58","v":5.82},{"$f":"'Data Sheet'!C58","v":8.19},{"$f":"'Data Sheet'!D58","v":11.17},{"$f":"'Data Sheet'!E58","v":14.51},{"$f":"'Data Sheet'!F58","v":17.239999999999998},{"$f":"'Data Sheet'!G58","v":9.67},{"$f":"'Data Sheet'!H58","v":14.15},{"$f":"'Data Sheet'!I58","v":20.71},{"$f":"'Data Sheet'!J58","v":26.86},{"$f":"'Data Sheet'!K58","v":35.909999999999997}]
["Borrowings",{"$f":"'Data Sheet'!B59","v":1.6},{"$f":"'Data Sheet'!C59","v":6.97},{"$f":"'Data Sheet'!D59","v":7.99},{"$f":"'Data Sheet'!E59","v":14.91},{"$f":"'Data Sheet'!F59","v":16.739999999999998},{"$f":"'Data Sheet'!G59","v":12.5},{"$f":"'Data Sheet'!H59","v":10.119999999999999},{"$f":"'Data Sheet'!I59","v":4.96},{"$f":"'Data Sheet'!J59","v":4.25},{"$f":"'Data Sheet'!K59","v":1.1599999999999999},{"$f":"L8-(L7+L5+L4)","v":0}]
["Other Liabilities",{"$f":"'Data Sheet'!B60","v":12.38},{"$f":"'Data Sheet'!C60","v":21.42},{"$f":"'Data Sheet'!D60","v":18.91},{"$f":"'Data Sheet'!E60","v":22.88},{"$f":"'Data Sheet'!F60","v":22.61},{"$f":"'Data Sheet'!G60","v":30.92},{"$f":"'Data Sheet'!H60","v":21.71},{"$f":"'Data Sheet'!I60","v":22.66},{"$f":"'Data Sheet'!J60","v":36.24},{"$f":"'Data Sheet'!K60","v":31.08},null,"def tax liab+oth long term liab+other current liab"]
["Total",{"$f":"'Data Sheet'!B61","v":29.8},{"$f":"'Data Sheet'!C61","v":46.58},{"$f":"'Data Sheet'!D61","v":48.07},{"$f":"'Data Sheet'!E61","v":62.3},{"$f":"'Data Sheet'!F61","v":66.59},{"$f":"'Data Sheet'!G61","v":69.239999999999995},{"$f":"'Data Sheet'!H61","v":62.13},{"$f":"'Data Sheet'!I61","v":64.48},{"$f":"'Data Sheet'!J61","v":83.5},{"$f":"'Data Sheet'!K61","v":84.3}]
[]
["Net Block",{"$f":"'Data Sheet'!B62","v":6.39},{"$f":"'Data Sheet'!C62","v":6.53},{"$f":"'Data Sheet'!D62","v":7.11},{"$f":"'Data Sheet'!E62","v":17.059999999999999},{"$f":"'Data Sheet'!F62","v":24.39},{"$f":"'Data Sheet'!G62","v":21.32},{"$f":"'Data Sheet'!H62","v":18.63},{"$f":"'Data Sheet'!I62","v":16.559999999999999},{"$f":"'Data Sheet'!J62","v":17.149999999999999},{"$f":"'Data Sheet'!K62","v":15.84}]
["Capital Work in Progress",{"$f":"'Data Sheet'!B63","v":0.15},{"$f":"'Data Sheet'!C63","v":1.39},{"$f":"'Data Sheet'!D63","v":3.45},{"$f":"'Data Sheet'!E63","v":2.91},{"$f":"'Data Sheet'!F63","v":0.35},{"$f":"'Data Sheet'!G63","v":0.31},{"$f":"'Data Sheet'!H63","v":0},{"$f":"'Data Sheet'!I63","v":0.23},{"$f":"'Data Sheet'!J63","v":0},{"$f":"'Data Sheet'!K63","v":0.2}]
["Investments",{"$f":"'Data Sheet'!B64","v":0.18},{"$f":"'Data Sheet'!C64","v":0.08},{"$f":"'Data Sheet'!D64","v":0.03},{"$f":"'Data Sheet'!E64","v":0},{"$f":"'Data Sheet'!F64","v":0},{"$f":"'Data Sheet'!G64","v":0},{"$f":"'Data Sheet'!H64","v":0},{"$f":"'Data Sheet'!I64","v":3.52},{"$f":"'Data Sheet'!J64","v":14.22},{"$f":"'Data Sheet'!K64","v":14.9}]
["Other Assets",{"$f":"'Data Sheet'!B65","v":23.08},{"$f":"'Data Sheet'!C65","v":38.58},{"$f":"'Data Sheet'!D65","v":37.479999999999997},{"$f":"'Data Sheet'!E65","v":42.33},{"$f":"'Data Sheet'!F65","v":41.85},{"$f":"'Data Sheet'!G65","v":47.61},{"$f":"'Data Sheet'!H65","v":43.5},{"$f":"'Data Sheet'!I65","v":44.17},{"$f":"'Data Sheet'!J65","v":52.13},{"$f":"'Data Sheet'!K65","v":53.36},null,"total current assets+long term loans and advances+other non current assets"]
["Total",{"$f":"'Data Sheet'!B66","v":29.8},{"$f":"'Data Sheet'!C66","v":46.58},{"$f":"'Data Sheet'!D66","v":48.07},{"$f":"'Data Sheet'!E66","v":62.3},{"$f":"'Data Sheet'!F66","v":66.59},{"$f":"'Data Sheet'!G66","v":69.239999999999995},{"$f":"'Data Sheet'!H66","v":62.13},{"$f":"'Data Sheet'!I66","v":64.48},{"$f":"'Data Sheet'!J66","v":83.5},{"$f":"'Data Sheet'!K66","v":84.3},{"$f":"L8","v":0},{"$f":"L10+L11+L12+L13","v":0},"check TA matching"]
[]
["Working Capital",{"$f":"B13-B7","v":10.699999999999998},17.159999999999997,18.569999999999997,19.45,19.240000000000002,16.689999999999998,21.79,21.51,15.89,22.28,{"$f":"L13-L7","v":0}]
["Debtors",{"$f":"'Data Sheet'!B67","v":4.6100000000000003},{"$f":"'Data Sheet'!C67","v":16.37},{"$f":"'Data Sheet'!D67","v":12.7},{"$f":"'Data Sheet'!E67","v":17.190000000000001},{"$f":"'Data Sheet'!F67","v":17.57},{"$f":"'Data Sheet'!G67","v":13.04},{"$f":"'Data Sheet'!H67","v":18.23},{"$f":"'Data Sheet'!I67","v":17.91},{"$f":"'Data Sheet'!J67","v":20.12},{"$f":"'Data Sheet'!K67","v":19.43}]
["Inventory",{"$f":"'Data Sheet'!B68","v":11.56},{"$f":"'Data Sheet'!C68","v":14.79},{"$f":"'Data Sheet'!D68","v":12.08},{"$f":"'Data Sheet'!E68","v":7.65},{"$f":"'Data Sheet'!F68","v":10.82},{"$f":"'Data Sheet'!G68","v":17.850000000000001},{"$f":"'Data Sheet'!H68","v":13.68},{"$f":"'Data Sheet'!I68","v":12.25},{"$f":"'Data Sheet'!J68","v":17.850000000000001},{"$f":"'Data Sheet'!K68","v":21.71}]
["Payables (Creditors)",9.74,7.17,7.96,19.21,37.43,37.86,25.62,18.77,35.369999999999997,44.57,null,"input Creditors (Payables) data from Screener/Annual Reports"]
[]
["Inventory Turnover",{"$f":"IF('Balance Sheet'!B18>0,'Profit & Loss'!B4/'Balance Sheet'!B18,0)","v":2.3399653979238755},{"$f":"IF('Balance Sheet'!C18>0,'Profit & Loss'!C4/'Balance Sheet'!C18,0)","v":3.6572008113590266},{"$f":"IF('Balance Sheet'!D18>0,'Profit & Loss'!D4/'Balance Sheet'!D18,0)","v":4.835264900662251},{"$f":"IF('Balance Sheet'!E18>0,'Profit & Loss'!E4/'Balance Sheet'!E18,0)","v":7.8470588235294114},{"$f":"IF('Balance Sheet'!F18>0,'Profit & Loss'!F4/'Balance Sheet'!F18,0)","v":4.4371534195933453},{"$f":"IF('Balance Sheet'!G18>0,'Profit & Loss'!G4/'Balance Sheet'!G18,0)","v":2.1977591036414563},{"$f":"IF('Balance Sheet'!H18>0,'Profit & Loss'!H4/'Balance Sheet'!H18,0)","v":4.8925438596491233},{"$f":"IF('Balance Sheet'!I18>0,'Profit & Loss'!I4/'Balance Sheet'!I18,0)","v":6.2130612244897963},{"$f":"IF('Balance Sheet'!J18>0,'Profit & Loss'!J4/'Balance Sheet'!J18,0)","v":4.5658263305322127},{"$f":"IF('Balance Sheet'!K18>0,'Profit & Loss'!K4/'Balance Sheet'!K18,0)","v":5.1013357899585445},{"$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":155.98521256931608},{"$f":"IF('Profit & Loss'!C4>0,'Balance Sheet'!C18/('Profit & Loss'!C4/365),0)","v":99.803105934553514},{"$f":"IF('Profit & Loss'!D4>0,'Balance Sheet'!D18/('Profit & Loss'!D4/365),0)","v":75.487074131141938},{"$f":"IF('Profit & Loss'!E4>0,'Balance Sheet'!E18/('Profit & Loss'!E4/365),0)","v":46.514242878560722},{"$f":"IF('Profit & Loss'!F4>0,'Balance Sheet'!F18/('Profit & Loss'!F4/365),0)","v":82.259945844615714},{"$f":"IF('Profit & Loss'!G4>0,'Balance Sheet'!G18/('Profit & Loss'!G4/365),0)","v":166.07825643640075},{"$f":"IF('Profit & Loss'!H4>0,'Balance Sheet'!H18/('Profit & Loss'!H4/365),0)","v":74.60331689825189},{"$f":"IF('Profit & Loss'!I4>0,'Balance Sheet'!I18/('Profit & Loss'!I4/365),0)","v":58.747207988437793},{"$f":"IF('Profit & Loss'!J4>0,'Balance Sheet'!J18/('Profit & Loss'!J4/365),0)","v":79.941717791411051},{"$f":"IF('Profit & Loss'!K4>0,'Balance Sheet'!K18/('Profit & Loss'!K4/365),0)","v":71.54988713318285},{"$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":62.205175600739373},{"$f":"IF('Profit & Loss'!C4>0,'Balance Sheet'!C17/('Profit & Loss'!C4/365),0)","v":110.46496579774451},{"$f":"IF('Profit & Loss'!D4>0,'Balance Sheet'!D17/('Profit & Loss'!D4/365),0)","v":79.36141071734292},{"$f":"IF('Profit & Loss'!E4>0,'Balance Sheet'!E17/('Profit & Loss'!E4/365),0)","v":104.52023988005999},{"$f":"IF('Profit & Loss'!F4>0,'Balance Sheet'!F17/('Profit & Loss'!F4/365),0)","v":133.57737971255989},{"$f":"IF('Profit & Loss'!G4>0,'Balance Sheet'!G17/('Profit & Loss'!G4/365),0)","v":121.3255161865919},{"$f":"IF('Profit & Loss'!H4>0,'Balance Sheet'!H17/('Profit & Loss'!H4/365),0)","v":99.416554609293286},{"$f":"IF('Profit & Loss'!I4>0,'Balance Sheet'!I17/('Profit & Loss'!I4/365),0)","v":85.890815924320066},{"$f":"IF('Profit & Loss'!J4>0,'Balance Sheet'!J17/('Profit & Loss'!J4/365),0)","v":90.107975460122702},{"$f":"IF('Profit & Loss'!K4>0,'Balance Sheet'!K17/('Profit & Loss'!K4/365),0)","v":64.035665914221212},{"$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":131.42698706099816},{"$f":"IF('Profit & Loss'!C4>0,C19/('Profit & Loss'!C4/365),0)","v":48.383250138657793},{"$f":"IF('Profit & Loss'!D4>0,D19/('Profit & Loss'!D4/365),0)","v":49.741482622838561},{"$f":"IF('Profit & Loss'!E4>0,E19/('Profit & Loss'!E4/365),0)","v":116.80243211727471},{"$f":"IF('Profit & Loss'!F4>0,F19/('Profit & Loss'!F4/365),0)","v":284.56467402624452},{"$f":"IF('Profit & Loss'!G4>0,G19/('Profit & Loss'!G4/365),0)","v":352.25337751720627},{"$f":"IF('Profit & Loss'!H4>0,H19/('Profit & Loss'!H4/365),0)","v":139.71761541909456},{"$f":"IF('Profit & Loss'!I4>0,I19/('Profit & Loss'!I4/365),0)","v":90.015109709630806},{"$f":"IF('Profit & Loss'!J4>0,J19/('Profit & Loss'!J4/365),0)","v":158.40552147239262},{"$f":"IF('Profit & Loss'!K4>0,K19/('Profit & Loss'!K4/365),0)","v":146.88984198645599},{"$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":86.763401109057298},{"$f":"IF(C19>0,C22+C23-C24,0)","v":161.88482159364025},105.10700222564631,34.232050641345992,-68.727348469068914,-64.849604894213655,34.302256088450633,54.622914203127053,11.644171779141146,-11.304288939051929,0]
["Working Capital/Sales",{"$f":"B16/'Profit & Loss'!B4","v":0.3955637707948243},{"$f":"C16/'Profit & Loss'!C4","v":0.31724902939545196},{"$f":"D16/'Profit & Loss'!D4","v":0.31792501284026703},{"$f":"E16/'Profit & Loss'!E4","v":0.32400466433449943},{"$f":"F16/'Profit & Loss'!F4","v":0.40074984378254536},{"$f":"G16/'Profit & Loss'!G4","v":0.42543971450420592},{"$f":"H16/'Profit & Loss'!H4","v":0.32556402211265495},{"$f":"I16/'Profit & Loss'!I4","v":0.28261726448561297},{"$f":"J16/'Profit & Loss'!J4","v":0.19496932515337423},{"$f":"K16/'Profit & Loss'!K4","v":0.20117381489841987}]
[]
["Return on Equity",{"$f":"IF(SUM('Balance Sheet'!B4:B5)>0,'Profit & Loss'!B12/SUM('Balance Sheet'!B4:B5),\"\")","v":4.1719342604298361E-2},{"$f":"IF(SUM('Balance Sheet'!C4:C5)>0,'Profit & Loss'!C12/SUM('Balance Sheet'!C4:C5),\"\")","v":0.13304013194062672},{"$f":"IF(SUM('Balance Sheet'!D4:D5)>0,'Profit & Loss'!D12/SUM('Balance Sheet'!D4:D5),\"\")","v":0.14265470004723665},{"$f":"IF(SUM('Balance Sheet'!E4:E5)>0,'Profit & Loss'!E12/SUM('Balance Sheet'!E4:E5),\"\")","v":0.1379028967768258},{"$f":"IF(SUM('Balance Sheet'!F4:F5)>0,'Profit & Loss'!F12/SUM('Balance Sheet'!F4:F5),\"\")","v":0.1013215859030837},{"$f":"IF(SUM('Balance Sheet'!G4:G5)>0,'Profit & Loss'!G12/SUM('Balance Sheet'!G4:G5),\"\")","v":-0.29202168861347794},{"$f":"IF(SUM('Balance Sheet'!H4:H5)>0,'Profit & Loss'!H12/SUM('Balance Sheet'!H4:H5),\"\")","v":0.15841584158415842},{"$f":"IF(SUM('Balance Sheet'!I4:I5)>0,'Profit & Loss'!I12/SUM('Balance Sheet'!I4:I5),\"\")","v":0.18556701030927836},{"$f":"IF(SUM('Balance Sheet'!J4:J5)>0,'Profit & Loss'!J12/SUM('Balance Sheet'!J4:J5),\"\")","v":0.13787491281097419},{"$f":"IF(SUM('Balance Sheet'!K4:K5)>0,'Profit & Loss'!K12/SUM('Balance Sheet'!K4:K5),\"\")","v":0.24894352669996161},{"$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":5.3832650672908496E-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":0.12030392570704965},{"$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.14953271028037354},{"$f":"IF(('Balance Sheet'!E10+'Balance Sheet'!E16)>0,('Profit & Loss'!E6-'Profit & Loss'!E8-'Profit & Loss'!E11)/('Balance Sheet'!E10+'Balance Sheet'!E16),\"\")","v":0.10271158586688574},{"$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.10864084345633734},{"$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.15338068929229171},{"$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.14720435428005973},{"$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.16837404780667173},{"$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.17372881355932213},{"$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.3105981112277022}]
[]
["Book Value",{"$f":"B4+B5","v":15.82},18.189999999999998,21.17,24.509999999999998,27.24,25.82,30.299999999999997,36.86,43.01,52.059999999999995,0]
["BVPS",{"$f":"IF('Data Sheet'!B93>0,B31/'Data Sheet'!B93,0)","v":15.820316406328127},{"$f":"IF('Data Sheet'!C93>0,C31/'Data Sheet'!C93,0)","v":18.190363807276142},{"$f":"IF('Data Sheet'!D93>0,D31/'Data Sheet'!D93,0)","v":21.170423408468171},{"$f":"IF('Data Sheet'!E93>0,E31/'Data Sheet'!E93,0)","v":24.510490209804196},{"$f":"IF('Data Sheet'!F93>0,F31/'Data Sheet'!F93,0)","v":27.240544810896218},{"$f":"IF('Data Sheet'!G93>0,G31/'Data Sheet'!G93,0)","v":15.982865773640032},{"$f":"IF('Data Sheet'!H93>0,H31/'Data Sheet'!H93,0)","v":18.756035357912197},{"$f":"IF('Data Sheet'!I93>0,I31/'Data Sheet'!I93,0)","v":22.816747963453587},{"$f":"IF('Data Sheet'!J93>0,J31/'Data Sheet'!J93,0)","v":26.623666031148634},{"$f":"IF('Data Sheet'!K93>0,K31/'Data Sheet'!K93,0)","v":32.225716195805575},{"$f":"IF('Data Sheet'!K93>0,L31/'Data Sheet'!K93,0)","v":0}]
[]
["Cash & Bank Balances",{"$f":"'Data Sheet'!B69","v":0.16},{"$f":"'Data Sheet'!C69","v":1.1000000000000001},{"$f":"'Data Sheet'!D69","v":4.55},{"$f":"'Data Sheet'!E69","v":1.27},{"$f":"'Data Sheet'!F69","v":1.67},{"$f":"'Data Sheet'!G69","v":6.32},{"$f":"'Data Sheet'!H69","v":0.83},{"$f":"'Data Sheet'!I69","v":6.94},{"$f":"'Data Sheet'!J69","v":4.4000000000000004},{"$f":"'Data Sheet'!K69","v":5.5}]
["Cash/Sales",{"$f":"B34/'Data Sheet'!B17","v":5.9149722735674674E-3},{"$f":"C34/'Data Sheet'!C17","v":2.0336476243298207E-2},{"$f":"D34/'Data Sheet'!D17","v":7.7897620270501622E-2},{"$f":"E34/'Data Sheet'!E17","v":2.115608862235549E-2},{"$f":"F34/'Data Sheet'!F17","v":3.4784419912518225E-2},{"$f":"G34/'Data Sheet'!G17","v":0.16110119806270712},{"$f":"H34/'Data Sheet'!H17","v":1.2401015986851933E-2},{"$f":"I34/'Data Sheet'!I17","v":9.1183812902378147E-2},{"$f":"J34/'Data Sheet'!J17","v":5.3987730061349701E-2},{"$f":"K34/'Data Sheet'!K17","v":4.9661399548532728E-2}]
[]
["Common Size Balance Sheet",{"$f":"B3","v":"2010-03-31"},"2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31","Check back how Assets are being put to use"]
["Net Block/Total Assets",{"$f":"B10/B$8","v":0.21442953020134226},0.14018892228424218,0.14790929893904722,0.27383627608346711,0.36627121189367773,0.30791450028885042,0.29985514244326411,0.25682382133995035,0.20538922155688621,0.18790035587188614,"high historical Fixed Assets/Total Assets - strong correlation high Op Leverage"]
["Working Capital/Total Assets",{"$f":"B16/B$8","v":0.35906040268456368},0.36839845427221979,0.38631162887455789,0.31219903691813805,0.28893227211292988,0.24104563835932985,0.35071624014163849,0.33359181141439204,0.1902994011976048,0.26429418742586003]
["Debtors/Total Assets",{"$f":"B17/B$8","v":0.1546979865771812},0.35143838557320745,0.26419804451841061,0.2759229534510434,0.26385343144616308,0.18833044482957828,0.29341702881055848,0.2777605459057072,0.24095808383233533,0.23048635824436536]
["Inventory/Total Assets",{"$f":"B18/B$8","v":0.38791946308724834},0.31751824817518248,0.25130018722696068,0.12279293739967899,0.16248685988887221,0.25779896013864823,0.22018348623853209,0.18998138957816377,0.21377245508982037,0.25753262158956108]
["Cash/Total Assets",{"$f":"B34/B$8","v":5.3691275167785232E-3},{"$f":"C34/C$8","v":2.3615285530270504E-2},9.465363012273767E-2,2.0385232744783308E-2,2.5078840666766779E-2,9.1276718659734274E-2,1.3359085787864154E-2,0.1076302729528536,5.2694610778443118E-2,6.5243179122182679E-2,"check for excluding excess cash (over and above historical normalised levels)"]
[]
["Borrowings/Total Assets",{"$f":"B6/B$8","v":5.3691275167785234E-2},0.14963503649635038,0.16621593509465363,0.23932584269662924,0.25138909746208138,0.18053148469093011,0.16288427490745211,7.6923076923076913E-2,5.089820359281437E-2,1.3760379596678529E-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":"AXTEL INDUSTRIES LTD"},null,null,null,{"$f":"UPDATE","v":""},null,null,null,null,"SCREENER.IN"]
[]
["Narration",{"$f":"'Data Sheet'!B81","v":"2010-03-31"},{"$f":"'Data Sheet'!C81","v":"2011-03-31"},{"$f":"'Data Sheet'!D81","v":"2012-03-31"},{"$f":"'Data Sheet'!E81","v":"2013-03-31"},{"$f":"'Data Sheet'!F81","v":"2014-03-31"},{"$f":"'Data Sheet'!G81","v":"2015-03-31"},{"$f":"'Data Sheet'!H81","v":"2016-03-31"},{"$f":"'Data Sheet'!I81","v":"2017-03-31"},{"$f":"'Data Sheet'!J81","v":"2018-03-31"},{"$f":"'Data Sheet'!K81","v":"2019-03-31"}]
["Cash from Operating Activity",{"$f":"'Data Sheet'!B82","v":1.95},{"$f":"'Data Sheet'!C82","v":-2.09},{"$f":"'Data Sheet'!D82","v":4.84},{"$f":"'Data Sheet'!E82","v":1.26},{"$f":"'Data Sheet'!F82","v":8.2799999999999994},{"$f":"'Data Sheet'!G82","v":6.69},{"$f":"'Data Sheet'!H82","v":-1.24},{"$f":"'Data Sheet'!I82","v":15.13},{"$f":"'Data Sheet'!J82","v":11.79},{"$f":"'Data Sheet'!K82","v":9.15}]
["Cash from Investing Activity",{"$f":"'Data Sheet'!B83","v":-0.45},{"$f":"'Data Sheet'!C83","v":-1.92},{"$f":"'Data Sheet'!D83","v":-3.49},{"$f":"'Data Sheet'!E83","v":-10.59},{"$f":"'Data Sheet'!F83","v":-7.51},{"$f":"'Data Sheet'!G83","v":-0.61},{"$f":"'Data Sheet'!H83","v":-0.63},{"$f":"'Data Sheet'!I83","v":-3.78},{"$f":"'Data Sheet'!J83","v":-13.12},{"$f":"'Data Sheet'!K83","v":-1.55}]
["Cash from Financing Activity",{"$f":"'Data Sheet'!B84","v":-1.45},{"$f":"'Data Sheet'!C84","v":4.95},{"$f":"'Data Sheet'!D84","v":2.1},{"$f":"'Data Sheet'!E84","v":6.05},{"$f":"'Data Sheet'!F84","v":-0.37},{"$f":"'Data Sheet'!G84","v":-1.44},{"$f":"'Data Sheet'!H84","v":-3.62},{"$f":"'Data Sheet'!I84","v":-5.9},{"$f":"'Data Sheet'!J84","v":-1.21},{"$f":"'Data Sheet'!K84","v":-6.5}]
["Net Cash Flow",{"$f":"'Data Sheet'!B85","v":0.05},{"$f":"'Data Sheet'!C85","v":0.94},{"$f":"'Data Sheet'!D85","v":3.45},{"$f":"'Data Sheet'!E85","v":-3.28},{"$f":"'Data Sheet'!F85","v":0.4},{"$f":"'Data Sheet'!G85","v":4.6500000000000004},{"$f":"'Data Sheet'!H85","v":-5.49},{"$f":"'Data Sheet'!I85","v":5.44},{"$f":"'Data Sheet'!J85","v":-2.54},{"$f":"'Data Sheet'!K85","v":1.1000000000000001}]

{"sheet":"Customization","index":4,"n_rows":73,"n_cols":15,"rows_kept":73,"cut":false,"hidden":false,"merged":[[58,0,58,10],[9,0,9,9],[33,0,33,10],[47,0,47,10]]}
[{"$f":"'Data Sheet'!B1","v":"AXTEL INDUSTRIES 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,null,"PRE-TAX BOND"]
["10 YR",{"$f":"'Calculated Data'!K10-'Calculated Data'!B10","v":36.239999999999995},{"$f":"'Calculated Data'!K33-'Calculated Data'!B33","v":192.77232979999999},{"$f":"C5/B5","v":5.3193247737306848},null,null,"P/E","P/B","EV/EBITDA","P/SALES","YIELD","P/CFO",null,"LongTerm Bond",0.09]
["7 YR",{"$f":"'Calculated Data'!K10-'Calculated Data'!E10","v":27.549999999999997},{"$f":"'Calculated Data'!K33-'Calculated Data'!E33","v":196.82224880000001},{"$f":"C6/B6","v":7.1441832595281314},null,"MIN",{"$f":"MIN('Calculated Data'!B38:K38)","v":-2.4425029177718836},{"$f":"MIN('Calculated Data'!B39:K39)","v":0.2312729074889868},{"$f":"MIN('Calculated Data'!B42:K42)","v":-11.940034951456317},{"$f":"MIN('Calculated Data'!B41:K41)","v":0.13122003749218913},{"$f":"MAX('Calculated Data'!B43:K43)","v":1.60214629343455E-2},{"$f":"MIN('Calculated Data'!B40:K40)","v":-19.164282903225807},null,"LTB Quote",{"$f":"('Profit & Loss'!$L$10/'Data Sheet'!$B$61)/O5","v":6.3609246830723345}]
["5 YR",{"$f":"'Calculated Data'!K10-'Calculated Data'!G10","v":26.239999999999995},{"$f":"'Calculated Data'!K33-'Calculated Data'!G33","v":186.345618},{"$f":"C7/B7","v":7.1015860518292699},null,"MAX",{"$f":"MAX('Calculated Data'!B38:K38)","v":25.471733558178755},{"$f":"MAX('Calculated Data'!B39:K39)","v":3.9331941990011527},{"$f":"MAX('Calculated Data'!B42:K42)","v":14.010898792943362},{"$f":"MAX('Calculated Data'!B41:K41)","v":1.8533420858895706},{"$f":"MIN('Calculated Data'!B43:K43)","v":0},{"$f":"MAX('Calculated Data'!B40:K40)","v":22.378370491803278},null,"Equity Quoting @",{"$f":"('Profit & Loss'!$L$6/'Data Sheet'!$B$6)/'Data Sheet'!$B$8","v":0.12387140902872777}]
["3 YR",{"$f":"'Calculated Data'!K10-'Calculated Data'!I10","v":15.199999999999996},{"$f":"'Calculated Data'!K33-'Calculated Data'!I33","v":71.323442},{"$f":"C8/B8","v":4.6923317105263171},null,"TRAILING",{"$f":"'Data Sheet'!B8/'Profit & Loss'!L13","v":11.876523151909018},{"$f":"'Calculated Data'!L33/'Calculated Data'!K10","v":2.8082981175566655},{"$f":"'Calculated Data'!K42","v":9.3349832324173256},{"$f":"'Calculated Data'!L33/'Profit & Loss'!L4","v":1.3748354335151403},{"$f":"'Data Sheet'!K31/'Calculated Data'!L33","v":1.655266757865937E-2},{"$f":"'Calculated Data'!L33/'Data Sheet'!K82","v":15.97814207650273}]
["1 YR",{"$f":"'Calculated Data'!K10-'Calculated Data'!J10","v":9.0499999999999972},{"$f":"'Calculated Data'!K33-'Calculated Data'!J33","v":53.714709999999997},{"$f":"C9/B9","v":5.9353270718232061},null,null,null,null,null,null,null,null,null," "]
["* IMPACT – Every Rupee retained added xx.yy in incremental market value"]
[]
[{"$f":"A1","v":"AXTEL INDUSTRIES 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.16955219208422889},{"$f":"POWER('Calculated Data'!$K3/'Calculated Data'!$B3, 1/9)-1","v":0.26345343660364584},{"$f":"POWER('Calculated Data'!$K4/'Calculated Data'!$B4, 1/9)-1","v":0.33458956302760767},{"$f":"POWER('Calculated Data'!$K7/'Calculated Data'!$B7, 1/9)-1","v":0.39210967500090788},{"$f":"POWER('Calculated Data'!$K8/'Calculated Data'!$B8, 1/9)-1","v":{"$error":"#DIV/0!"}},{"$f":"POWER('Calculated Data'!$K26/'Calculated Data'!$B26, 1/9)-1","v":-2.2457257087321771},{"$f":"POWER('Calculated Data'!$K33/'Calculated Data'!$B33, 1/9)-1","v":0.37068504048613704},{"$f":"POWER('Calculated Data'!$K17/'Calculated Data'!$B17, 1/9)-1","v":0.18740397397346387},{"$f":"POWER('Calculated Data'!$K19/'Calculated Data'!$C19, 1/8)-1","v":{"$error":"#NUM!"}},{"$f":"POWER('Calculated Data'!$K10/'Calculated Data'!$B10, 1/9)-1","v":0.14150421776626421},{"$f":"POWER('Calculated Data'!$K34/'Calculated Data'!$B34, 1/9)-1","v":0.37247560783748712}]
["5 YR CAGR",{"$f":"POWER('Data Sheet'!$K17/'Data Sheet'!$G17, 1/4)-1","v":0.29622787529391292},{"$f":"POWER('Calculated Data'!$K3/'Calculated Data'!$G3, 1/4)-1","v":0.45278928629956527},{"$f":"POWER('Calculated Data'!$K4/'Calculated Data'!$G4, 1/4)-1","v":{"$error":"#NUM!"}},{"$f":"POWER('Calculated Data'!$K7/'Calculated Data'!$G7, 1/4)-1","v":{"$error":"#NUM!"}},{"$f":"POWER('Calculated Data'!$K8/'Calculated Data'!$G8, 1/4)-1","v":{"$error":"#DIV/0!"}},{"$f":"POWER('Calculated Data'!$K26/'Calculated Data'!$G26, 1/4)-1","v":{"$error":"#NUM!"}},{"$f":"POWER('Calculated Data'!$K33/'Calculated Data'!$G33, 1/4)-1","v":0.82604207078499425},{"$f":"POWER('Calculated Data'!$K17/'Calculated Data'!$G17, 1/4)-1","v":8.1430823930679797E-2},{"$f":"POWER('Calculated Data'!$K19/'Calculated Data'!$G19, 1/4)-1","v":5.9955997743292633E-2},{"$f":"POWER('Calculated Data'!$K10/'Calculated Data'!$G10, 1/4)-1","v":0.19161779868080298},{"$f":"POWER('Calculated Data'!$K34/'Calculated Data'!$G34, 1/4)-1","v":0.83141363487927955}]
["3 YR CAGR",{"$f":"POWER('Data Sheet'!$K17/'Data Sheet'!$I17, 1/2)-1","v":0.20628799705356493},{"$f":"POWER('Calculated Data'!$K3/'Calculated Data'!$I3, 1/2)-1","v":0.14032964527050984},{"$f":"POWER('Calculated Data'!$K4/'Calculated Data'!$I4, 1/2)-1","v":0.43472450286386755},{"$f":"POWER('Calculated Data'!$K7/'Calculated Data'!$I7, 1/2)-1","v":0.37649440322337058},{"$f":"POWER('Calculated Data'!$K8/'Calculated Data'!$I8, 1/2)-1","v":{"$error":"#DIV/0!"}},{"$f":"POWER('Calculated Data'!$K26/'Calculated Data'!$I26, 1/2)-1","v":0.74660441271478017},{"$f":"POWER('Calculated Data'!$K33/'Calculated Data'!$I33, 1/2)-1","v":0.23875083530194208},{"$f":"POWER('Calculated Data'!$K17/'Calculated Data'!$I17, 1/2)-1","v":-0.22233763275084573},{"$f":"POWER('Calculated Data'!$K19/'Calculated Data'!$I19, 1/2)-1","v":-0.274932872296759},{"$f":"POWER('Calculated Data'!$K10/'Calculated Data'!$I10, 1/2)-1","v":0.18843221683889833},{"$f":"POWER('Calculated Data'!$K34/'Calculated Data'!$I34, 1/2)-1","v":0.24604948028427942}]
["1 YR GROWTH",{"$f":"('Data Sheet'!$K17-'Data Sheet'!$J17)/'Data Sheet'!$J17","v":0.35889570552147237},{"$f":"('Calculated Data'!$K3-'Calculated Data'!$J3)/'Calculated Data'!$J3","v":0.43270472746060451},{"$f":"('Calculated Data'!$K4-'Calculated Data'!$J4)/'Calculated Data'!$J4","v":1.2279236276849648},{"$f":"('Calculated Data'!$K7-'Calculated Data'!$J7)/'Calculated Data'!$J7","v":1.1854974704890391},{"$f":"('Calculated Data'!$K8-'Calculated Data'!$J8)/'Calculated Data'!$J8","v":0},{"$f":"('Calculated Data'!$K26-'Calculated Data'!$J26)/'Calculated Data'!$J26","v":2.7297054582535831},{"$f":"('Calculated Data'!$K33-'Calculated Data'!$J33)/'Calculated Data'!$J33","v":0.35561497326203206},{"$f":"('Calculated Data'!$K17-'Calculated Data'!$J17)/'Calculated Data'!$J17","v":-0.22391857506361315},{"$f":"('Calculated Data'!$K19-'Calculated Data'!$J19)/'Calculated Data'!$J19","v":-0.17477876106194692},{"$f":"('Calculated Data'!$K10-'Calculated Data'!$J10)/'Calculated Data'!$J10","v":0.2104161822831899},{"$f":"('Calculated Data'!$K34-'Calculated Data'!$J34)/'Calculated Data'!$J34","v":0.35000734358011454}]
["**modify (if, then) for negative values"]
[{"$f":"A1","v":"AXTEL INDUSTRIES LTD"},{"$f":"'Data Sheet'!B16","v":"2010-03-31"},{"$f":"'Data Sheet'!C16","v":"2011-03-31"},{"$f":"'Data Sheet'!D16","v":"2012-03-31"},{"$f":"'Data Sheet'!E16","v":"2013-03-31"},{"$f":"'Data Sheet'!F16","v":"2014-03-31"},{"$f":"'Data Sheet'!G16","v":"2015-03-31"},{"$f":"'Data Sheet'!H16","v":"2016-03-31"},{"$f":"'Data Sheet'!I16","v":"2017-03-31"},{"$f":"'Data Sheet'!J16","v":"2018-03-31"},{"$f":"'Data Sheet'!K16","v":"2019-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.8836915297092289},{"$f":"'Calculated Data'!C15/'Calculated Data'!C10","v":2.5607476635514019},{"$f":"'Calculated Data'!D15/'Calculated Data'!D10","v":2.2706660368445912},{"$f":"'Calculated Data'!E15/'Calculated Data'!E10","v":2.5418196654426763},{"$f":"'Calculated Data'!F15/'Calculated Data'!F10","v":2.4445668135095451},{"$f":"'Calculated Data'!G15/'Calculated Data'!G10","v":2.6816421378776139},{"$f":"'Calculated Data'!H15/'Calculated Data'!H10","v":2.050495049504951},{"$f":"'Calculated Data'!I15/'Calculated Data'!I10","v":1.7493217580032556},{"$f":"'Calculated Data'!J15/'Calculated Data'!J10","v":1.9414089746570566},{"$f":"'Calculated Data'!K15/'Calculated Data'!K10","v":1.6192854398770651},{"$f":"'Balance Sheet'!L8/'Calculated Data'!L10","v":{"$error":"#DIV/0!"}}]
["Long term debt/Earning",{"$f":"'Data Sheet'!B59/'Data Sheet'!B30","v":2.4242424242424243},{"$f":"'Data Sheet'!C59/'Data Sheet'!C30","v":2.8801652892561984},{"$f":"'Data Sheet'!D59/'Data Sheet'!D30","v":2.6456953642384105},{"$f":"'Data Sheet'!E59/'Data Sheet'!E30","v":4.4112426035502956},{"$f":"'Data Sheet'!F59/'Data Sheet'!F30","v":6.0652173913043477},{"$f":"'Data Sheet'!G59/'Data Sheet'!G30","v":-1.6578249336870026},{"$f":"'Data Sheet'!H59/'Data Sheet'!H30","v":2.1083333333333334},{"$f":"'Data Sheet'!I59/'Data Sheet'!I30","v":0.72514619883040932},{"$f":"'Data Sheet'!J59/'Data Sheet'!J30","v":0.71669477234401358},{"$f":"'Data Sheet'!K59/'Data Sheet'!K30","v":8.9506172839506154E-2}]
["Current liablility/Earning",{"$f":"'Data Sheet'!B60/'Data Sheet'!B30","v":18.757575757575758},{"$f":"'Data Sheet'!C60/'Data Sheet'!C30","v":8.8512396694214885},{"$f":"'Data Sheet'!D60/'Data Sheet'!D30","v":6.2615894039735096},{"$f":"'Data Sheet'!E60/'Data Sheet'!E30","v":6.7692307692307692},{"$f":"'Data Sheet'!F60/'Data Sheet'!F30","v":8.1920289855072461},{"$f":"'Data Sheet'!G60/'Data Sheet'!G30","v":-4.1007957559681696},{"$f":"'Data Sheet'!H60/'Data Sheet'!H30","v":4.5229166666666671},{"$f":"'Data Sheet'!I60/'Data Sheet'!I30","v":3.3128654970760234},{"$f":"'Data Sheet'!J60/'Data Sheet'!J30","v":6.1112984822934235},{"$f":"'Data Sheet'!K60/'Data Sheet'!K30","v":2.3981481481481479}]
["Total liability/Earning",{"$f":"('Data Sheet'!B59+'Data Sheet'!B60)/'Data Sheet'!B30","v":21.18181818181818},{"$f":"('Data Sheet'!C59+'Data Sheet'!C60)/'Data Sheet'!C30","v":11.731404958677686},{"$f":"('Data Sheet'!D59+'Data Sheet'!D60)/'Data Sheet'!D30","v":8.9072847682119196},{"$f":"('Data Sheet'!E59+'Data Sheet'!E60)/'Data Sheet'!E30","v":11.180473372781066},{"$f":"('Data Sheet'!F59+'Data Sheet'!F60)/'Data Sheet'!F30","v":14.257246376811594},{"$f":"('Data Sheet'!G59+'Data Sheet'!G60)/'Data Sheet'!G30","v":-5.7586206896551726},{"$f":"('Data Sheet'!H59+'Data Sheet'!H60)/'Data Sheet'!H30","v":6.6312499999999996},{"$f":"('Data Sheet'!I59+'Data Sheet'!I60)/'Data Sheet'!I30","v":4.0380116959064329},{"$f":"('Data Sheet'!J59+'Data Sheet'!J60)/'Data Sheet'!J30","v":6.8279932546374376},{"$f":"('Data Sheet'!K59+'Data Sheet'!K60)/'Data Sheet'!K30","v":2.4876543209876538}]
["Debt/Equity",{"$f":"'Data Sheet'!B59/'Calculated Data'!B10","v":0.10113780025284451},{"$f":"'Data Sheet'!C59/'Calculated Data'!C10","v":0.38317757009345799},{"$f":"'Data Sheet'!D59/'Calculated Data'!D10","v":0.37742087860179496},{"$f":"'Data Sheet'!E59/'Calculated Data'!E10","v":0.60832313341493272},{"$f":"'Data Sheet'!F59/'Calculated Data'!F10","v":0.61453744493392071},{"$f":"'Data Sheet'!G59/'Calculated Data'!G10","v":0.48412083656080557},{"$f":"'Data Sheet'!H59/'Calculated Data'!H10","v":0.33399339933993399},{"$f":"'Data Sheet'!I59/'Calculated Data'!I10","v":0.13456321215409658},{"$f":"'Data Sheet'!J59/'Calculated Data'!J10","v":9.8814229249011856E-2},{"$f":"'Data Sheet'!K59/'Calculated Data'!K10","v":2.2281982328082983E-2}]
["Interest Coverage",{"$f":"'Calculated Data'!B4/'Data Sheet'!B27","v":4.2121212121212119},{"$f":"'Calculated Data'!C4/'Data Sheet'!C27","v":10.577777777777778},{"$f":"'Calculated Data'!D4/'Data Sheet'!D27","v":5.8586956521739122},{"$f":"'Calculated Data'!E4/'Data Sheet'!E27","v":8.0422535211267601},{"$f":"'Calculated Data'!F4/'Data Sheet'!F27","v":2.9082568807339446},{"$f":"'Calculated Data'!G4/'Data Sheet'!G27","v":-3.0670103092783503},{"$f":"'Calculated Data'!H4/'Data Sheet'!H27","v":5.1751824817518246},{"$f":"'Calculated Data'!I4/'Data Sheet'!I27","v":12.093333333333334},{"$f":"'Calculated Data'!J4/'Data Sheet'!J27","v":16.759999999999998},{"$f":"'Calculated Data'!K4/'Data Sheet'!K27","v":38.895833333333336}]
["Working Capital/Sales",{"$f":"'Calculated Data'!B11/'Data Sheet'!B17","v":0.3955637707948243},{"$f":"'Calculated Data'!C11/'Data Sheet'!C17","v":0.31724902939545196},{"$f":"'Calculated Data'!D11/'Data Sheet'!D17","v":0.31792501284026703},{"$f":"'Calculated Data'!E11/'Data Sheet'!E17","v":0.32400466433449943},{"$f":"'Calculated Data'!F11/'Data Sheet'!F17","v":0.40074984378254536},{"$f":"'Calculated Data'!G11/'Data Sheet'!G17","v":0.42543971450420592},{"$f":"'Calculated Data'!H11/'Data Sheet'!H17","v":0.32556402211265495},{"$f":"'Calculated Data'!I11/'Data Sheet'!I17","v":0.28261726448561297},{"$f":"'Calculated Data'!J11/'Data Sheet'!J17","v":0.19496932515337423},{"$f":"'Calculated Data'!K11/'Data Sheet'!K17","v":0.20117381489841987},null,"Check for improving or deteriorating picture"]
["Inventory Turns",{"$f":"365/B27","v":2.3399653979238755},3.6572008113590266,4.835264900662251,7.8470588235294114,4.4371534195933453,2.1977591036414563,4.8925438596491242,6.2130612244897954,4.5658263305322127,5.1013357899585436]
["Inventory Days",{"$f":"'Balance Sheet'!B22","v":155.98521256931608},{"$f":"'Balance Sheet'!C22","v":99.803105934553514},{"$f":"'Balance Sheet'!D22","v":75.487074131141938},{"$f":"'Balance Sheet'!E22","v":46.514242878560722},{"$f":"'Balance Sheet'!F22","v":82.259945844615714},{"$f":"'Balance Sheet'!G22","v":166.07825643640075},{"$f":"'Balance Sheet'!H22","v":74.60331689825189},{"$f":"'Balance Sheet'!I22","v":58.747207988437793},{"$f":"'Balance Sheet'!J22","v":79.941717791411051},{"$f":"'Balance Sheet'!K22","v":71.54988713318285}]
["Debtor Days",{"$f":"'Balance Sheet'!B23","v":62.205175600739373},{"$f":"'Balance Sheet'!C23","v":110.46496579774451},{"$f":"'Balance Sheet'!D23","v":79.36141071734292},{"$f":"'Balance Sheet'!E23","v":104.52023988005999},{"$f":"'Balance Sheet'!F23","v":133.57737971255989},{"$f":"'Balance Sheet'!G23","v":121.3255161865919},{"$f":"'Balance Sheet'!H23","v":99.416554609293286},{"$f":"'Balance Sheet'!I23","v":85.890815924320066},{"$f":"'Balance Sheet'!J23","v":90.107975460122702},{"$f":"'Balance Sheet'!K23","v":64.035665914221212}]
["Creditor Days",{"$f":"'Balance Sheet'!B24","v":131.42698706099816},{"$f":"'Balance Sheet'!C24","v":48.383250138657793},{"$f":"'Balance Sheet'!D24","v":49.741482622838561},{"$f":"'Balance Sheet'!E24","v":116.80243211727471},{"$f":"'Balance Sheet'!F24","v":284.56467402624452},{"$f":"'Balance Sheet'!G24","v":352.25337751720627},{"$f":"'Balance Sheet'!H24","v":139.71761541909456},{"$f":"'Balance Sheet'!I24","v":90.015109709630806},{"$f":"'Balance Sheet'!J24","v":158.40552147239262},{"$f":"'Balance Sheet'!K24","v":146.88984198645599},null,"Check back to see if Creditor policy change is impacting Working Cap cycle"]
["Cash Conversion Cycle",{"$f":"'Balance Sheet'!B25","v":86.763401109057298},{"$f":"'Balance Sheet'!C25","v":161.88482159364025},{"$f":"'Balance Sheet'!D25","v":105.10700222564631},{"$f":"'Balance Sheet'!E25","v":34.232050641345992},{"$f":"'Balance Sheet'!F25","v":-68.727348469068914},{"$f":"'Balance Sheet'!G25","v":-64.849604894213655},{"$f":"'Balance Sheet'!H25","v":34.302256088450633},{"$f":"'Balance Sheet'!I25","v":54.622914203127053},{"$f":"'Balance Sheet'!J25","v":11.644171779141146},{"$f":"'Balance Sheet'!K25","v":-11.304288939051929}]
["Cash In/Cash Out Ratio",{"$f":"('Data Sheet'!B67+'Data Sheet'!B69)/'Data Sheet'!B60","v":0.38529886914378031},{"$f":"('Data Sheet'!C67+'Data Sheet'!C69)/'Data Sheet'!C60","v":0.81559290382819805},{"$f":"('Data Sheet'!D67+'Data Sheet'!D69)/'Data Sheet'!D60","v":0.91221575885774719},{"$f":"('Data Sheet'!E67+'Data Sheet'!E69)/'Data Sheet'!E60","v":0.80681818181818188},{"$f":"('Data Sheet'!F67+'Data Sheet'!F69)/'Data Sheet'!F60","v":0.85095090667846096},{"$f":"('Data Sheet'!G67+'Data Sheet'!G69)/'Data Sheet'!G60","v":0.62613195342820172},{"$f":"('Data Sheet'!H67+'Data Sheet'!H69)/'Data Sheet'!H60","v":0.87793643482266226},{"$f":"('Data Sheet'!I67+'Data Sheet'!I69)/'Data Sheet'!I60","v":1.0966460723742277},{"$f":"('Data Sheet'!J67+'Data Sheet'!J69)/'Data Sheet'!J60","v":0.67660044150110377},{"$f":"('Data Sheet'!K67+'Data Sheet'!K69)/'Data Sheet'!K60","v":0.80212355212355213},null,"  "]
["Current Ratio",{"$f":"'Data Sheet'!B65/'Data Sheet'!B60","v":1.8642972536348947},{"$f":"'Data Sheet'!C65/'Data Sheet'!C60","v":1.8011204481792715},{"$f":"'Data Sheet'!D65/'Data Sheet'!D60","v":1.9820200951877311},{"$f":"'Data Sheet'!E65/'Data Sheet'!E60","v":1.8500874125874125},{"$f":"'Data Sheet'!F65/'Data Sheet'!F60","v":1.8509509066784611},{"$f":"'Data Sheet'!G65/'Data Sheet'!G60","v":1.5397800776196635},{"$f":"'Data Sheet'!H65/'Data Sheet'!H60","v":2.0036849378166743},{"$f":"'Data Sheet'!I65/'Data Sheet'!I60","v":1.9492497793468668},{"$f":"'Data Sheet'!J65/'Data Sheet'!J60","v":1.4384657836644592},{"$f":"'Data Sheet'!K65/'Data Sheet'!K60","v":1.7168597168597168}," "]
["CFO/PAT",{"$f":"'Calculated Data'!B17/'Calculated Data'!B7","v":2.9545454545454541},{"$f":"'Calculated Data'!C17/'Calculated Data'!C7","v":-0.86363636363636365},{"$f":"'Calculated Data'!D17/'Calculated Data'!D7","v":1.6026490066225165},{"$f":"'Calculated Data'!E17/'Calculated Data'!E7","v":0.37278106508875741},{"$f":"'Calculated Data'!F17/'Calculated Data'!F7","v":3},{"$f":"'Calculated Data'!G17/'Calculated Data'!G7","v":-0.88726790450928383},{"$f":"'Calculated Data'!H17/'Calculated Data'!H7","v":-0.25833333333333336},{"$f":"'Calculated Data'!I17/'Calculated Data'!I7","v":2.2119883040935675},{"$f":"'Calculated Data'!J17/'Calculated Data'!J7","v":1.9881956155143339},{"$f":"'Calculated Data'!K17/'Calculated Data'!K7","v":0.70601851851851849}]
[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.24990757855822557},{"$f":"'Calculated Data'!C3/'Data Sheet'!C17","v":0.32298021815492706},{"$f":"'Calculated Data'!D3/'Data Sheet'!D17","v":0.36808765622324946},{"$f":"'Calculated Data'!E3/'Data Sheet'!E17","v":0.48758953856405129},{"$f":"'Calculated Data'!F3/'Data Sheet'!F17","v":0.5061445532180795},{"$f":"'Calculated Data'!G3/'Data Sheet'!G17","v":0.31735916390517455},{"$f":"'Calculated Data'!H3/'Data Sheet'!H17","v":0.57149260421335724},{"$f":"'Calculated Data'!I3/'Data Sheet'!I17","v":0.56037314413349093},{"$f":"'Calculated Data'!J3/'Data Sheet'!J17","v":0.47496932515337426},{"$f":"'Calculated Data'!K3/'Data Sheet'!K17","v":0.50076749435665913}]
["EBIT/Sales",{"$f":"'Calculated Data'!B4/'Data Sheet'!B17","v":5.1386321626617382E-2},{"$f":"'Calculated Data'!C4/'Data Sheet'!C17","v":8.8001479016454054E-2},{"$f":"'Calculated Data'!D4/'Data Sheet'!D17","v":9.2278719397363471E-2},{"$f":"'Calculated Data'!E4/'Data Sheet'!E17","v":9.5119107113110113E-2},{"$f":"'Calculated Data'!F4/'Data Sheet'!F17","v":0.13205582170381172},{"$f":"'Calculated Data'!G4/'Data Sheet'!G17","v":-0.15166964058118787},{"$f":"'Calculated Data'!H4/'Data Sheet'!H17","v":0.10593157029732556},{"$f":"'Calculated Data'!I4/'Data Sheet'!I17","v":0.11916962291420313},{"$f":"'Calculated Data'!J4/'Data Sheet'!J17","v":0.10282208588957054},{"$f":"'Calculated Data'!K4/'Data Sheet'!K17","v":0.16857787810383748},{"$f":"'Calculated Data'!L4/'Profit & Loss'!L4","v":0.16607109272145953}]
["EBITDA/Sales",{"$f":"'Calculated Data'!B5/'Data Sheet'!B17","v":7.5415896487985218E-2},{"$f":"'Calculated Data'!C5/'Data Sheet'!C17","v":0.10149750415973377},{"$f":"'Calculated Data'!D5/'Data Sheet'!D17","v":0.10820065057353193},{"$f":"'Calculated Data'!E5/'Data Sheet'!E17","v":0.11810761286023655},{"$f":"'Calculated Data'!F5/'Data Sheet'!F17","v":0.19037700479066863},{"$f":"'Calculated Data'!G5/'Data Sheet'!G17","v":-5.2510833545755781E-2},{"$f":"'Calculated Data'!H5/'Data Sheet'!H17","v":0.15747796204990286},{"$f":"'Calculated Data'!I5/'Data Sheet'!I17","v":0.15569570358691368},{"$f":"'Calculated Data'!J5/'Data Sheet'!J17","v":0.13214723926380367},{"$f":"'Calculated Data'!K5/'Data Sheet'!K17","v":0.19386004514672689}]
["Op Profit (Ex Other Income)/Sales",{"$f":"'Calculated Data'!B6/'Data Sheet'!B17","v":7.2828096118299449E-2},{"$f":"'Calculated Data'!C6/'Data Sheet'!C17","v":0.10112775004621927},{"$f":"'Calculated Data'!D6/'Data Sheet'!D17","v":0.10648861496319123},{"$f":"'Calculated Data'!E6/'Data Sheet'!E17","v":0.1126103614859237},{"$f":"'Calculated Data'!F6/'Data Sheet'!F17","v":0.1862112059987503},{"$f":"'Calculated Data'!G6/'Data Sheet'!G17","v":-5.8373693601835315E-2},{"$f":"'Calculated Data'!H6/'Data Sheet'!H17","v":0.15419094576423126},{"$f":"'Calculated Data'!I6/'Data Sheet'!I17","v":0.14032321639731968},{"$f":"'Calculated Data'!J6/'Data Sheet'!J17","v":0.1238036809815951},{"$f":"'Calculated Data'!K6/'Data Sheet'!K17","v":0.17950338600451471}]
["Net Margin =PAT/Sales",{"$f":"'Calculated Data'!B7/'Data Sheet'!B17","v":2.4399260628465806E-2},{"$f":"'Calculated Data'!C7/'Data Sheet'!C17","v":4.4740247735256047E-2},{"$f":"'Calculated Data'!D7/'Data Sheet'!D17","v":5.1703475432288995E-2},{"$f":"'Calculated Data'!E7/'Data Sheet'!E17","v":5.6305180742961848E-2},{"$f":"'Calculated Data'!F7/'Data Sheet'!F17","v":5.7488023328473234E-2},{"$f":"'Calculated Data'!G7/'Data Sheet'!G17","v":-0.19219984705582463},{"$f":"'Calculated Data'!H7/'Data Sheet'!H17","v":7.1716718960107562E-2},{"$f":"'Calculated Data'!I7/'Data Sheet'!I17","v":8.986992510839574E-2},{"$f":"'Calculated Data'!J7/'Data Sheet'!J17","v":7.2760736196319009E-2},{"$f":"'Calculated Data'!K7/'Data Sheet'!K17","v":0.11702031602708804},{"$f":"'Calculated Data'!L7/'Profit & Loss'!L4","v":0.1157607673500094}]
["Op Cash Flow/Sales",{"$f":"'Calculated Data'!B17/'Data Sheet'!B17","v":7.2088724584103508E-2},{"$f":"'Calculated Data'!C17/'Data Sheet'!C17","v":-3.8639304862266591E-2},{"$f":"'Calculated Data'!D17/'Data Sheet'!D17","v":8.2862523540489647E-2},{"$f":"'Calculated Data'!E17/'Data Sheet'!E17","v":2.0989505247376312E-2},{"$f":"'Calculated Data'!F17/'Data Sheet'!F17","v":0.17246406998541969},{"$f":"'Calculated Data'!G17/'Data Sheet'!G17","v":0.17053275554422639},{"$f":"'Calculated Data'!H17/'Data Sheet'!H17","v":-1.8526819064694455E-2},{"$f":"'Calculated Data'!I17/'Data Sheet'!I17","v":0.19879122322953621},{"$f":"'Calculated Data'!J17/'Data Sheet'!J17","v":0.14466257668711655},{"$f":"'Calculated Data'!K17/'Data Sheet'!K17","v":8.2618510158013553E-2}]
["Free Cash Flow/Sales",{"$f":"'Calculated Data'!B19/'Data Sheet'!B17","v":0},{"$f":"'Calculated Data'!C19/'Data Sheet'!C17","v":-7.7648363838047699E-2},{"$f":"'Calculated Data'!D19/'Data Sheet'!D17","v":2.1742852251326814E-2},{"$f":"'Calculated Data'!E19/'Data Sheet'!E17","v":-0.15875395635515574},{"$f":"'Calculated Data'!F19/'Data Sheet'!F17","v":1.4788585711310106E-2},{"$f":"'Calculated Data'!G19/'Data Sheet'!G17","v":0.15065001274534795},{"$f":"'Calculated Data'!H19/'Data Sheet'!H17","v":-2.5250261467204521E-2},{"$f":"'Calculated Data'!I19/'Data Sheet'!I17","v":0.18644067796610173},{"$f":"'Calculated Data'!J19/'Data Sheet'!J17","v":0.110920245398773},{"$f":"'Calculated Data'!K19/'Data Sheet'!K17","v":6.7358916478555297E-2}]
["EPA/Sales",{"$f":"'Calculated Data'!B26/'Data Sheet'!B17","v":-4.4485334635371243E-2},{"$f":"'Calculated Data'!C26/'Data Sheet'!C17","v":-6.2290957024019799E-3},{"$f":"'Calculated Data'!D26/'Data Sheet'!D17","v":2.4989898223887613E-3},{"$f":"'Calculated Data'!E26/'Data Sheet'!E17","v":-1.4690321505913706E-2},{"$f":"'Calculated Data'!F26/'Data Sheet'!F17","v":-2.231313989072789E-2},{"$f":"'Calculated Data'!G26/'Data Sheet'!G17","v":-0.26215799902237197},{"$f":"'Calculated Data'!H26/'Data Sheet'!H17","v":1.6423880915140431E-2},{"$f":"'Calculated Data'!I26/'Data Sheet'!I17","v":3.744166464530084E-2},{"$f":"'Calculated Data'!J26/'Data Sheet'!J17","v":2.8599196537012234E-2},{"$f":"'Calculated Data'!K26/'Data Sheet'!K17","v":7.8495044904736452E-2}]
["EPA/Sales Increase - last 5 Years",null,null,null,null,{"$f":"(F42-B42)","v":2.2172194744643353E-2},{"$f":"(G42-C42)","v":-0.25592890331996998},1.3924891092751669E-2,5.2131986151214546E-2,5.0912336427740124E-2,0.34065304392710843]
["EPA/Sales Increase - last 3 Years",null,null,{"$f":"(D42-B42)","v":4.6984324457760004E-2},{"$f":"(E42-C42)","v":-8.4612258035117252E-3},-2.4812129713116651E-2,-0.24746767751645826,3.873702080586832E-2,0.29959966366767282,1.2175315621871803E-2,4.1053380259435612E-2]
["MktCap Cagr  - last 5 years",null,null,null,null,{"$f":"POWER('Calculated Data'!F33/'Calculated Data'!B33, 1/4)-1","v":-0.14860647770104818},{"$f":"POWER('Calculated Data'!G33/'Calculated Data'!C33, 1/4)-1","v":5.7792814528060399E-2},{"$f":"POWER('Calculated Data'!H33/'Calculated Data'!D33, 1/4)-1","v":0.14994182966637593},{"$f":"POWER('Calculated Data'!I33/'Calculated Data'!E33, 1/4)-1","v":1.0247315682874336},{"$f":"POWER('Calculated Data'!J33/'Calculated Data'!F33, 1/4)-1","v":1.2128161543406168},{"$f":"POWER('Calculated Data'!K33/'Calculated Data'!G33, 1/4)-1","v":0.82604207078499425}]
["MktCap Cagr  - last 3 years",null,null,{"$f":"POWER('Calculated Data'!D33/'Calculated Data'!B33, 1/2)-1","v":6.4633522445288083E-2},{"$f":"POWER('Calculated Data'!E33/'Calculated Data'!C33, 1/2)-1","v":-0.26531036163705224},{"$f":"POWER('Calculated Data'!F33/'Calculated Data'!D33, 1/2)-1","v":-0.31913572649139732},{"$f":"POWER('Calculated Data'!G33/'Calculated Data'!E33, 1/2)-1","v":0.52299090669144466},{"$f":"POWER('Calculated Data'!H33/'Calculated Data'!F33, 1/2)-1","v":0.94218769153811976},{"$f":"POWER('Calculated Data'!I33/'Calculated Data'!G33, 1/2)-1","v":1.6917678271143144},{"$f":"POWER('Calculated Data'!J33/'Calculated Data'!H33, 1/2)-1","v":1.5211545486795663},{"$f":"POWER('Calculated Data'!K33/'Calculated Data'!I33, 1/2)-1","v":0.23875083530194208}]
[]
[]
["Sales/Invested Capital =Capital Turns",{"$f":"'Data Sheet'!B17/'Calculated Data'!B13","v":1.5690255220417635},{"$f":"'Data Sheet'!C17/'Calculated Data'!C13","v":2.1566985645933019},{"$f":"'Data Sheet'!D17/'Calculated Data'!D13","v":2.0051493305870238},{"$f":"'Data Sheet'!E17/'Calculated Data'!E13","v":1.5228310502283104},{"$f":"'Data Sheet'!F17/'Calculated Data'!F13","v":1.091632560254661},{"$f":"'Data Sheet'!G17/'Calculated Data'!G13","v":1.0237473903966599},{"$f":"'Data Sheet'!H17/'Calculated Data'!H13","v":1.6558634339435925},{"$f":"'Data Sheet'!I17/'Calculated Data'!I13","v":1.9872062663185379},{"$f":"'Data Sheet'!J17/'Calculated Data'!J13","v":2.4667070217917675},{"$f":"'Data Sheet'!K17/'Calculated Data'!K13","v":2.8901356993736953}]
["Sales/Fixed Assets= Fixed Asset Turns",{"$f":"'Data Sheet'!B17/'Data Sheet'!B62","v":4.2331768388106417},{"$f":"'Data Sheet'!C17/'Data Sheet'!C62","v":8.283307810107198},{"$f":"'Data Sheet'!D17/'Data Sheet'!D62","v":8.2151898734177209},{"$f":"'Data Sheet'!E17/'Data Sheet'!E62","v":3.5187573270808912},{"$f":"'Data Sheet'!F17/'Data Sheet'!F62","v":1.968429684296843},{"$f":"'Data Sheet'!G17/'Data Sheet'!G62","v":1.8400562851782363},{"$f":"'Data Sheet'!H17/'Data Sheet'!H62","v":3.592592592592593},{"$f":"'Data Sheet'!I17/'Data Sheet'!I62","v":4.5960144927536239},{"$f":"'Data Sheet'!J17/'Data Sheet'!J62","v":4.7521865889212833},{"$f":"'Data Sheet'!K17/'Data Sheet'!K62","v":6.9917929292929291}]
["Sales/Total Assets= Asset Turns",{"$f":"'Data Sheet'!B17/'Calculated Data'!B15","v":0.90771812080536918},{"$f":"'Data Sheet'!C17/'Calculated Data'!C15","v":1.1612279948475741},{"$f":"'Data Sheet'!D17/'Calculated Data'!D15","v":1.2151029748283753},{"$f":"'Data Sheet'!E17/'Calculated Data'!E15","v":0.96356340288924569},{"$f":"'Data Sheet'!F17/'Calculated Data'!F15","v":0.72097912599489411},{"$f":"'Data Sheet'!G17/'Calculated Data'!G15","v":0.56658001155401505},{"$f":"'Data Sheet'!H17/'Calculated Data'!H15","v":1.0772573635924674},{"$f":"'Data Sheet'!I17/'Calculated Data'!I15","v":1.1803660049627791},{"$f":"'Data Sheet'!J17/'Calculated Data'!J15","v":0.9760479041916168},{"$f":"'Data Sheet'!K17/'Calculated Data'!K15","v":1.3137603795966786},{"$f":"'Profit & Loss'!L4/'Balance Sheet'!L8","v":{"$error":"#DIV/0!"}}]
["Net Margin*Asset Turns= RoA",{"$f":"B39*B51","v":2.2147651006711414E-2},{"$f":"C39*C51","v":5.1953628166595101E-2},6.282504680674017E-2,5.4253611556982342E-2,4.1447664814536718E-2,-0.10889659156556905,7.725736359246739E-2,0.10607940446650123,7.1017964071856288E-2,0.15373665480427048,{"$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":4.1719342604298368E-2},0.13304013194062672,0.14265470004723665,0.13790289677682577,0.10132158590308371,-0.29202168861347794,0.15841584158415842,0.18556701030927833,0.13787491281097419,0.24894352669996164,{"$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":7.9793340987370842E-2},{"$f":"'Calculated Data'!C4/'Calculated Data'!C14","v":0.1891891891891892},{"$f":"'Calculated Data'!D4/'Calculated Data'!D14","v":0.18484224965706444},{"$f":"'Calculated Data'!E4/'Calculated Data'!E14","v":0.14485032978183662},{"$f":"'Calculated Data'!F4/'Calculated Data'!F14","v":0.14415643474306503},{"$f":"'Calculated Data'!G4/'Calculated Data'!G14","v":-0.15527139874739038},{"$f":"'Calculated Data'!H4/'Calculated Data'!H14","v":0.17540821375556656},{"$f":"'Calculated Data'!I4/'Calculated Data'!I14","v":0.21688187470109996},{"$f":"'Calculated Data'!J4/'Calculated Data'!J14","v":0.17731696995344901},{"$f":"'Calculated Data'!K4/'Calculated Data'!K14","v":0.35080796692972577}]
["EBIT Margin*Cap Turns*(1-Tax rate)= RoIC",{"$f":"B36*B49*(1-'Calculated Data'!B22)","v":5.0201374600534095E-2},{"$f":"C36*C49*(1-'Calculated Data'!C22)","v":0.10656571823991536},{"$f":"D36*D49*(1-'Calculated Data'!D22)","v":0.12501084776950661},{"$f":"E36*E49*(1-'Calculated Data'!E22)","v":9.7629122272957891E-2},{"$f":"F36*F49*(1-'Calculated Data'!F22)","v":9.5642249973764304E-2},{"$f":"G36*G49*(1-'Calculated Data'!G22)","v":-0.14838356737076347},{"$f":"H36*H49*(1-'Calculated Data'!H22)","v":0.14719570385082509},{"$f":"I36*I49*(1-'Calculated Data'!I22)","v":0.19440431060453908},{"$f":"J36*J49*(1-'Calculated Data'!J22)","v":0.19054583891545085},{"$f":"K36*K49*(1-'Calculated Data'!K22)","v":0.3468613315031201},{"$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.12358390077406256},{"$f":"'Calculated Data'!E27","v":5.1104692462783645E-2},{"$f":"'Calculated Data'!F27","v":3.4772220976302615E-2},{"$f":"'Calculated Data'!G27","v":-2.1693869419942553},{"$f":"'Calculated Data'!H27","v":-2.0557789136568871},{"$f":"'Calculated Data'!I27","v":0.71239749833499577},{"$f":"'Calculated Data'!J27","v":0.54247668791856007},{"$f":"'Calculated Data'!K27","v":-1.3300554573066665}]
[{"$f":"'Calculated Data'!A28","v":"3Yr Rolling RoIIC "},null,null,null,null,null,{"$f":"'Calculated Data'!G28","v":-0.49352509508853853},{"$f":"'Calculated Data'!H28","v":0.22863007069100652},{"$f":"'Calculated Data'!I28","v":3.2393389423076924},{"$f":"'Calculated Data'!J28","v":-2.1094529611644606},{"$f":"'Calculated Data'!K28","v":-1.3905446730206854},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":0.1554545605404779},{"$f":"'Calculated Data'!I29","v":0.2479869035611551},{"$f":"'Calculated Data'!J29","v":0.26685872603778582},{"$f":"'Calculated Data'!K29","v":-1.4240407632215364},null,"better to check when NOPLAT and/or Investments are Lumpy"]
[]
["Altman Z-Score",{"$f":"'Calculated Data'!B50","v":1.7649280577181208},{"$f":"'Calculated Data'!C50","v":2.2027441708887934},{"$f":"'Calculated Data'!D50","v":2.3062791121281463},{"$f":"'Calculated Data'!E50","v":1.7930803325842697},{"$f":"'Calculated Data'!F50","v":1.4966800480552633},{"$f":"'Calculated Data'!G50","v":0.5793888388214905},{"$f":"'Calculated Data'!H50","v":2.2123487281506518},{"$f":"'Calculated Data'!I50","v":3.4350525558312652},{"$f":"'Calculated Data'!J50","v":2.6798135089820359},{"$f":"'Calculated Data'!K50","v":3.9941904389086602}]
["Dividend Payout",{"$f":"'Data Sheet'!B31/'Data Sheet'!B30","v":0},{"$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},{"$f":"'Data Sheet'!F31/'Data Sheet'!F30","v":0},{"$f":"'Data Sheet'!G31/'Data Sheet'!G30","v":0},{"$f":"'Data Sheet'!H31/'Data Sheet'!H30","v":0},{"$f":"'Data Sheet'!I31/'Data Sheet'!I30","v":0},{"$f":"'Data Sheet'!J31/'Data Sheet'!J30","v":0.40809443507588533},{"$f":"'Data Sheet'!K31/'Data Sheet'!K30","v":0.18672839506172836}]
["Cash/Assets",{"$f":"'Data Sheet'!B69/'Data Sheet'!B61","v":5.3691275167785232E-3},{"$f":"'Data Sheet'!C69/'Data Sheet'!C61","v":2.3615285530270504E-2},{"$f":"'Data Sheet'!D69/'Data Sheet'!D61","v":9.465363012273767E-2},{"$f":"'Data Sheet'!E69/'Data Sheet'!E61","v":2.0385232744783308E-2},{"$f":"'Data Sheet'!F69/'Data Sheet'!F61","v":2.5078840666766779E-2},{"$f":"'Data Sheet'!G69/'Data Sheet'!G61","v":9.1276718659734274E-2},{"$f":"'Data Sheet'!H69/'Data Sheet'!H61","v":1.3359085787864154E-2},{"$f":"'Data Sheet'!I69/'Data Sheet'!I61","v":0.1076302729528536},{"$f":"'Data Sheet'!J69/'Data Sheet'!J61","v":5.2694610778443118E-2},{"$f":"'Data Sheet'!K69/'Data Sheet'!K61","v":6.5243179122182679E-2}]
["EBIT/Invested Capital",{"$f":"'Calculated Data'!B4/'Calculated Data'!B13","v":8.0626450116009302E-2},{"$f":"'Calculated Data'!C4/'Calculated Data'!C13","v":0.18979266347687401},{"$f":"'Calculated Data'!D4/'Calculated Data'!D13","v":0.18503261242705116},{"$f":"'Calculated Data'!E4/'Calculated Data'!E13","v":0.14485032978183662},{"$f":"'Calculated Data'!F4/'Calculated Data'!F13","v":0.14415643474306503},{"$f":"'Calculated Data'!G4/'Calculated Data'!G13","v":-0.1552713987473904},{"$f":"'Calculated Data'!H4/'Calculated Data'!H13","v":0.17540821375556653},{"$f":"'Calculated Data'!I4/'Calculated Data'!I13","v":0.23681462140992168},{"$f":"'Calculated Data'!J4/'Calculated Data'!J13","v":0.25363196125907989},{"$f":"'Calculated Data'!K4/'Calculated Data'!K13","v":0.4872129436325679},null,"Check back the significant role of EBIT/Invested Capital "]
["EPA",{"$f":"'Calculated Data'!B26","v":-1.2033283018867922},{"$f":"'Calculated Data'!C26","v":-0.33693178654292311},{"$f":"'Calculated Data'!D26","v":0.14596599552572753},{"$f":"'Calculated Data'!E26","v":-0.88185999999999976},{"$f":"'Calculated Data'!F26","v":-1.0712538461538459},{"$f":"'Calculated Data'!G26","v":-10.284458301647652},{"$f":"'Calculated Data'!H26","v":1.0992503496503492},{"$f":"'Calculated Data'!I26","v":2.8496850961538467},{"$f":"'Calculated Data'!J26","v":2.3308345177664971},{"$f":"'Calculated Data'!K26","v":8.6933262231995627},null,"Check back what is really driving EPA (Invested Capital or RoIC, or both)"]
["MktCap",{"$f":"'Calculated Data'!B33","v":11.989760199999999},{"$f":"'Calculated Data'!C33","v":14.7097058},{"$f":"'Calculated Data'!D33","v":13.5897282},{"$f":"'Calculated Data'!E33","v":7.9398412},{"$f":"'Calculated Data'!F33","v":6.299874},{"$f":"'Calculated Data'!G33","v":18.416472000000002},{"$f":"'Calculated Data'!H33","v":23.763710800000002},{"$f":"'Calculated Data'!I33","v":133.438648},{"$f":"'Calculated Data'!J33","v":151.04738},{"$f":"'Calculated Data'!K33","v":204.76209}]
["MktCap Change",null,{"$f":"C65-B65","v":2.7199456000000009},{"$f":"D65-C65","v":-1.1199776000000004},-5.6498869999999997,-1.6399672000000001,12.116598000000003,5.3472387999999995,109.6749372,17.608732000000003,53.714709999999997]
["MktCap Change - EPA",null,{"$f":"C66-C64","v":3.056877386542924},-1.2659435955257279,-4.768027,-0.56871335384615418,22.401056301647657,4.2479884503496503,106.82525210384615,15.277897482233506,45.021383776800434]
[]
["Capex/Net Profits 10 yr",{"$f":"SUM('Calculated Data'!B$18:K$18)/SUM('Calculated Data'!B$7:K$7)","v":0.86999716151007656}]
["Capex/Net Profits 7 yr",{"$f":"SUM('Calculated Data'!E$18:K$18)/SUM('Calculated Data'!E$7:K$7)","v":0.85719189838654319}]
["Capex/Net Profits 5 yr",{"$f":"SUM('Calculated Data'!G$18:K$18)/SUM('Calculated Data'!G$7:K$7)","v":0.28751631143975637}]
["Capex/Net Profits 3 yr",{"$f":"SUM('Calculated Data'!I$18:K$18)/SUM('Calculated Data'!I$7:K$7)","v":0.20909444228527013}]
["Capex/Depreciation 10 yr",{"$f":"SUM('Calculated Data'!B$18:K$18)/SUM('Data Sheet'!B26:K26)","v":1.4059633027522933}]

{"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","AXTEL INDUSTRIES 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":1.6154696132596684}]
["Face Value",10]
["Current Price",90.5]
["Market Capitalization",146.19999999999999]
[]
[]
[]
[]
[]
["PROFIT & LOSS"]
["Report Date","2010-03-31","2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31"]
["Sales",27.05,54.09,58.41,60.03,48.01,39.229999999999997,66.930000000000007,76.11,81.5,110.75]
["Raw Material Cost",20.29,36.619999999999997,36.909999999999997,30.76,23.71,26.78,28.68,33.46,42.79,55.29]
["Change in Inventory",4.7300000000000004,-0.27,-0.85,-5.0599999999999996,3.03,6.87,-2.89,-2.99,2.2400000000000002,0.93]
["Power and Fuel",0.23,0.27,0.32,0.33,0.52,0.64,0.65,0.65,0.71,0.65]
["Other Mfr. Exp",3.09,3.8,5.35,5.54,4.91,4.67,6.47,7.99,7.36,9.02]
["Employee Cost",4.58,5.27,6.31,8.5,9.6,12.25,13.94,16.03,17.3,20.36]
["Selling and admin",1.54,1.9,3.1,3.42,3.48,4.75,4.1900000000000004,4.29,5.44,6.33]
["Other Expenses",0.08,0.49,-0.65,-0.34,-0.12,-0.7,-0.21,0.02,0.05,0.15]
["Other Income",7.0000000000000007E-2,0.02,0.1,0.33,0.2,0.23,0.22,1.17,0.68,1.59]
["Depreciation",0.65,0.73,0.93,1.38,2.8,3.89,3.45,2.78,2.39,2.8]
["Interest",0.33,0.45,0.92,0.71,2.1800000000000002,1.94,1.37,0.75,0.5,0.48]
["Profit before tax",1.06,4.3099999999999996,4.47,5,4.16,-7.89,5.72,8.32,7.88,18.190000000000001]
["Tax",0.4,1.89,1.45,1.63,1.4,-0.35,0.92,1.49,1.96,5.24]
["Net profit",0.66,2.42,3.02,3.38,2.76,-7.54,4.8,6.84,5.93,12.96]
["Dividend Amount",null,null,null,null,null,null,null,null,2.42,2.42]
[]
[]
[]
[]
[]
[]
[]
[]
["Quarters"]
["Report Date","2017-09-30","2017-12-31","2018-03-31","2018-06-30","2018-09-30","2018-12-31","2019-03-31","2019-06-30","2019-09-30","2019-12-31"]
["Sales",24.16,14.39,30.06,21.37,30.28,28.97,30.13,17.829999999999998,30.83,27.55]
["Expenses",21.88,13.09,25.22,18.86,24.86,23.19,23.96,16.54,26.1,21.63]
["Other Income",0.1,0.26,0.28999999999999998,0.24,0.84,0.63,-0.12,0.41,0.92,1.01]
["Depreciation",0.55000000000000004,0.67,0.61,0.66,0.7,0.72,0.71,0.6,0.66,0.7]
["Interest",7.0000000000000007E-2,0.18,0.12,7.0000000000000007E-2,0.15,0.13,0.13,0.1,0.13,0.24]
["Profit before tax",1.76,0.71,4.4000000000000004,2.02,5.41,5.56,5.21,1,4.8600000000000003,5.99]
["Tax",null,null,1.96,null,null,null,1.5,0.28999999999999998,1.42,1.54]
["Net profit",1.76,0.71,2.4500000000000002,2.02,5.41,5.56,3.71,0.71,3.44,4.45]
["Operating Profit",2.2799999999999998,1.3,4.84,2.5099999999999998,5.42,5.78,6.17,1.29,4.7300000000000004,5.92]
[]
[]
[]
[]
["BALANCE SHEET"]
["Report Date","2010-03-31","2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31"]
["Equity Share Capital",10,10,10,10,10,16.149999999999999,16.149999999999999,16.149999999999999,16.149999999999999,16.149999999999999]
["Reserves",5.82,8.19,11.17,14.51,17.239999999999998,9.67,14.15,20.71,26.86,35.909999999999997]
["Borrowings",1.6,6.97,7.99,14.91,16.739999999999998,12.5,10.119999999999999,4.96,4.25,1.1599999999999999]
["Other Liabilities",12.38,21.42,18.91,22.88,22.61,30.92,21.71,22.66,36.24,31.08]
["Total",29.8,46.58,48.07,62.3,66.59,69.239999999999995,62.13,64.48,83.5,84.3]
["Net Block",6.39,6.53,7.11,17.059999999999999,24.39,21.32,18.63,16.559999999999999,17.149999999999999,15.84]
["Capital Work in Progress",0.15,1.39,3.45,2.91,0.35,0.31,null,0.23,null,0.2]
["Investments",0.18,0.08,0.03,null,null,null,null,3.52,14.22,14.9]
["Other Assets",23.08,38.58,37.479999999999997,42.33,41.85,47.61,43.5,44.17,52.13,53.36]
["Total",29.8,46.58,48.07,62.3,66.59,69.239999999999995,62.13,64.48,83.5,84.3]
["Receivables",4.6100000000000003,16.37,12.7,17.190000000000001,17.57,13.04,18.23,17.91,20.12,19.43]
["Inventory",11.56,14.79,12.08,7.65,10.82,17.850000000000001,13.68,12.25,17.850000000000001,21.71]
["Cash & Bank",0.16,1.1000000000000001,4.55,1.27,1.67,6.32,0.83,6.94,4.4000000000000004,5.5]
["No. of Equity Shares",9999800,9999800,9999800,9999800,9999800,16154800,16154800,16154800,16154800,16154800]
["New Bonus Shares"]
["Face value",10,10,10,10,10,10,10,10,10,10]
[]
[]
[]
[]
[]
[]
[]
["CASH FLOW:"]
["Report Date","2010-03-31","2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31"]
["Cash from Operating Activity",1.95,-2.09,4.84,1.26,8.2799999999999994,6.69,-1.24,15.13,11.79,9.15]
["Cash from Investing Activity",-0.45,-1.92,-3.49,-10.59,-7.51,-0.61,-0.63,-3.78,-13.12,-1.55]
["Cash from Financing Activity",-1.45,4.95,2.1,6.05,-0.37,-1.44,-3.62,-5.9,-1.21,-6.5]
["Net Cash Flow",0.05,0.94,3.45,-3.28,0.4,4.6500000000000004,-5.49,5.44,-2.54,1.1000000000000001]
[]
[]
[]
[]
["PRICE:",11.99,14.71,13.59,7.94,6.3,11.4,14.71,82.6,93.5,126.75]
[]
["DERIVED:"]
["Adjusted Equity Shares in Cr",{"$f":"IF($B7>0,(B70*B72/$B7)+SUM(C71:$K71),0)/10000000","v":0.99997999999999998},{"$f":"IF($B7>0,(C70*C72/$B7)+SUM(D71:$K71),0)/10000000","v":0.99997999999999998},{"$f":"IF($B7>0,(D70*D72/$B7)+SUM(E71:$K71),0)/10000000","v":0.99997999999999998},{"$f":"IF($B7>0,(E70*E72/$B7)+SUM(F71:$K71),0)/10000000","v":0.99997999999999998},{"$f":"IF($B7>0,(F70*F72/$B7)+SUM(G71:$K71),0)/10000000","v":0.99997999999999998},{"$f":"IF($B7>0,(G70*G72/$B7)+SUM(H71:$K71),0)/10000000","v":1.61548},{"$f":"IF($B7>0,(H70*H72/$B7)+SUM(I71:$K71),0)/10000000","v":1.61548},{"$f":"IF($B7>0,(I70*I72/$B7)+SUM(J71:$K71),0)/10000000","v":1.61548},{"$f":"IF($B7>0,(J70*J72/$B7)+SUM(K71:$K71),0)/10000000","v":1.61548},{"$f":"IF($B7>0,(K70*K72/$B7),0)/10000000","v":1.61548}]

{"sheet":"Calculated Data","index":6,"n_rows":53,"n_cols":14,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Data Sheet'!B1","v":"AXTEL INDUSTRIES LTD"}]
[{"$f":"A1","v":"AXTEL INDUSTRIES LTD"},{"$f":"'Data Sheet'!B16","v":"2010-03-31"},{"$f":"'Data Sheet'!C16","v":"2011-03-31"},{"$f":"'Data Sheet'!D16","v":"2012-03-31"},{"$f":"'Data Sheet'!E16","v":"2013-03-31"},{"$f":"'Data Sheet'!F16","v":"2014-03-31"},{"$f":"'Data Sheet'!G16","v":"2015-03-31"},{"$f":"'Data Sheet'!H16","v":"2016-03-31"},{"$f":"'Data Sheet'!I16","v":"2017-03-31"},{"$f":"'Data Sheet'!J16","v":"2018-03-31"},{"$f":"'Data Sheet'!K16","v":"2019-03-31"},"TTM"]
["Gross Profit",{"$f":"'Data Sheet'!B17-'Data Sheet'!B18","v":6.7600000000000016},{"$f":"'Data Sheet'!C17-'Data Sheet'!C18","v":17.470000000000006},{"$f":"'Data Sheet'!D17-'Data Sheet'!D18","v":21.5},{"$f":"'Data Sheet'!E17-'Data Sheet'!E18","v":29.27},{"$f":"'Data Sheet'!F17-'Data Sheet'!F18","v":24.299999999999997},{"$f":"'Data Sheet'!G17-'Data Sheet'!G18","v":12.449999999999996},{"$f":"'Data Sheet'!H17-'Data Sheet'!H18","v":38.250000000000007},{"$f":"'Data Sheet'!I17-'Data Sheet'!I18","v":42.65},{"$f":"'Data Sheet'!J17-'Data Sheet'!J18","v":38.71},{"$f":"'Data Sheet'!K17-'Data Sheet'!K18","v":55.46}]
["EBIT",{"$f":"'Data Sheet'!B28+'Data Sheet'!B27","v":1.3900000000000001},{"$f":"'Data Sheet'!C28+'Data Sheet'!C27","v":4.76},{"$f":"'Data Sheet'!D28+'Data Sheet'!D27","v":5.39},{"$f":"'Data Sheet'!E28+'Data Sheet'!E27","v":5.71},{"$f":"'Data Sheet'!F28+'Data Sheet'!F27","v":6.34},{"$f":"'Data Sheet'!G28+'Data Sheet'!G27","v":-5.9499999999999993},{"$f":"'Data Sheet'!H28+'Data Sheet'!H27","v":7.09},{"$f":"'Data Sheet'!I28+'Data Sheet'!I27","v":9.07},{"$f":"'Data Sheet'!J28+'Data Sheet'!J27","v":8.379999999999999},{"$f":"'Data Sheet'!K28+'Data Sheet'!K27","v":18.670000000000002},{"$f":"'Profit & Loss'!L17","v":17.660000000000004}]
["EBITDA",{"$f":"'Calculated Data'!B4+'Data Sheet'!B26","v":2.04},{"$f":"'Calculated Data'!C4+'Data Sheet'!C26","v":5.49},{"$f":"'Calculated Data'!D4+'Data Sheet'!D26","v":6.3199999999999994},{"$f":"'Calculated Data'!E4+'Data Sheet'!E26","v":7.09},{"$f":"'Calculated Data'!F4+'Data Sheet'!F26","v":9.14},{"$f":"'Calculated Data'!G4+'Data Sheet'!G26","v":-2.0599999999999992},{"$f":"'Calculated Data'!H4+'Data Sheet'!H26","v":10.54},{"$f":"'Calculated Data'!I4+'Data Sheet'!I26","v":11.85},{"$f":"'Calculated Data'!J4+'Data Sheet'!J26","v":10.77},{"$f":"'Calculated Data'!K4+'Data Sheet'!K26","v":21.470000000000002},{"$f":"'Profit & Loss'!L18","v":20.330000000000005}]
["Operating Profit (excl Other Income)",{"$f":"B5-'Data Sheet'!B25","v":1.97},{"$f":"C5-'Data Sheet'!C25","v":5.4700000000000006},{"$f":"D5-'Data Sheet'!D25","v":6.22},{"$f":"E5-'Data Sheet'!E25","v":6.76},{"$f":"F5-'Data Sheet'!F25","v":8.9400000000000013},{"$f":"G5-'Data Sheet'!G25","v":-2.2899999999999991},{"$f":"H5-'Data Sheet'!H25","v":10.319999999999999},{"$f":"I5-'Data Sheet'!I25","v":10.68},{"$f":"J5-'Data Sheet'!J25","v":10.09},{"$f":"K5-'Data Sheet'!K25","v":19.880000000000003},{"$f":"'Profit & Loss'!L19","v":18.110000000000007}]
["PAT",{"$f":"'Data Sheet'!B30","v":0.66},{"$f":"'Data Sheet'!C30","v":2.42},{"$f":"'Data Sheet'!D30","v":3.02},{"$f":"'Data Sheet'!E30","v":3.38},{"$f":"'Data Sheet'!F30","v":2.76},{"$f":"'Data Sheet'!G30","v":-7.54},{"$f":"'Data Sheet'!H30","v":4.8},{"$f":"'Data Sheet'!I30","v":6.84},{"$f":"'Data Sheet'!J30","v":5.93},{"$f":"'Data Sheet'!K30","v":12.96},{"$f":"'Profit & Loss'!L12","v":12.309999999999999}]
["Dividend",{"$f":"'Data Sheet'!B31","v":0},{"$f":"'Data Sheet'!C31","v":0},{"$f":"'Data Sheet'!D31","v":0},{"$f":"'Data Sheet'!E31","v":0},{"$f":"'Data Sheet'!F31","v":0},{"$f":"'Data Sheet'!G31","v":0},{"$f":"'Data Sheet'!H31","v":0},{"$f":"'Data Sheet'!I31","v":0},{"$f":"'Data Sheet'!J31","v":2.42},{"$f":"'Data Sheet'!K31","v":2.42}]
[null,{"$f":"B2","v":"2010-03-31"},"2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31","1HFY17"]
["Networth",{"$f":"'Data Sheet'!B57+'Data Sheet'!B58","v":15.82},{"$f":"'Data Sheet'!C57+'Data Sheet'!C58","v":18.189999999999998},{"$f":"'Data Sheet'!D57+'Data Sheet'!D58","v":21.17},{"$f":"'Data Sheet'!E57+'Data Sheet'!E58","v":24.509999999999998},{"$f":"'Data Sheet'!F57+'Data Sheet'!F58","v":27.24},{"$f":"'Data Sheet'!G57+'Data Sheet'!G58","v":25.82},{"$f":"'Data Sheet'!H57+'Data Sheet'!H58","v":30.299999999999997},{"$f":"'Data Sheet'!I57+'Data Sheet'!I58","v":36.86},{"$f":"'Data Sheet'!J57+'Data Sheet'!J58","v":43.01},{"$f":"'Data Sheet'!K57+'Data Sheet'!K58","v":52.059999999999995},{"$f":"'Balance Sheet'!L4+'Balance Sheet'!L5","v":0}]
["Working Capital",{"$f":"'Data Sheet'!B65-'Data Sheet'!B60","v":10.699999999999998},{"$f":"'Data Sheet'!C65-'Data Sheet'!C60","v":17.159999999999997},{"$f":"'Data Sheet'!D65-'Data Sheet'!D60","v":18.569999999999997},{"$f":"'Data Sheet'!E65-'Data Sheet'!E60","v":19.45},{"$f":"'Data Sheet'!F65-'Data Sheet'!F60","v":19.240000000000002},{"$f":"'Data Sheet'!G65-'Data Sheet'!G60","v":16.689999999999998},{"$f":"'Data Sheet'!H65-'Data Sheet'!H60","v":21.79},{"$f":"'Data Sheet'!I65-'Data Sheet'!I60","v":21.51},{"$f":"'Data Sheet'!J65-'Data Sheet'!J60","v":15.89},{"$f":"'Data Sheet'!K65-'Data Sheet'!K60","v":22.28},{"$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+('Data Sheet'!B65-'Data Sheet'!B60)","v":17.239999999999998},{"$f":"'Data Sheet'!C62+'Data Sheet'!C63+('Data Sheet'!C65-'Data Sheet'!C60)","v":25.08},{"$f":"'Data Sheet'!D62+'Data Sheet'!D63+('Data Sheet'!D65-'Data Sheet'!D60)","v":29.129999999999995},{"$f":"'Data Sheet'!E62+'Data Sheet'!E63+('Data Sheet'!E65-'Data Sheet'!E60)","v":39.42},{"$f":"'Data Sheet'!F62+'Data Sheet'!F63+('Data Sheet'!F65-'Data Sheet'!F60)","v":43.980000000000004},{"$f":"'Data Sheet'!G62+'Data Sheet'!G63+('Data Sheet'!G65-'Data Sheet'!G60)","v":38.319999999999993},{"$f":"'Data Sheet'!H62+'Data Sheet'!H63+('Data Sheet'!H65-'Data Sheet'!H60)","v":40.42},{"$f":"'Data Sheet'!I62+'Data Sheet'!I63+('Data Sheet'!I65-'Data Sheet'!I60)","v":38.299999999999997},{"$f":"'Data Sheet'!J62+'Data Sheet'!J63+('Data Sheet'!J65-'Data Sheet'!J60)","v":33.04},{"$f":"'Data Sheet'!K62+'Data Sheet'!K63+('Data Sheet'!K65-'Data Sheet'!K60)","v":38.32},{"$f":"'Balance Sheet'!L10+'Balance Sheet'!L11+'Balance Sheet'!L16","v":0}]
["Capital Employed",{"$f":"B10+'Data Sheet'!B59","v":17.420000000000002},{"$f":"C10+'Data Sheet'!C59","v":25.159999999999997},{"$f":"D10+'Data Sheet'!D59","v":29.160000000000004},{"$f":"E10+'Data Sheet'!E59","v":39.42},{"$f":"F10+'Data Sheet'!F59","v":43.98},{"$f":"G10+'Data Sheet'!G59","v":38.32},{"$f":"H10+'Data Sheet'!H59","v":40.419999999999995},{"$f":"I10+'Data Sheet'!I59","v":41.82},{"$f":"J10+'Data Sheet'!J59","v":47.26},{"$f":"K10+'Data Sheet'!K59","v":53.219999999999992}]
["Total Assets",{"$f":"'Data Sheet'!B61","v":29.8},{"$f":"'Data Sheet'!C61","v":46.58},{"$f":"'Data Sheet'!D61","v":48.07},{"$f":"'Data Sheet'!E61","v":62.3},{"$f":"'Data Sheet'!F61","v":66.59},{"$f":"'Data Sheet'!G61","v":69.239999999999995},{"$f":"'Data Sheet'!H61","v":62.13},{"$f":"'Data Sheet'!I61","v":64.48},{"$f":"'Data Sheet'!J61","v":83.5},{"$f":"'Data Sheet'!K61","v":84.3},{"$f":"'Balance Sheet'!L8","v":0}]
[null,{"$f":"B2","v":"2010-03-31"},"2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31"]
["Operating Cash Flow",{"$f":"'Data Sheet'!B82","v":1.95},{"$f":"'Data Sheet'!C82","v":-2.09},{"$f":"'Data Sheet'!D82","v":4.84},{"$f":"'Data Sheet'!E82","v":1.26},{"$f":"'Data Sheet'!F82","v":8.2799999999999994},{"$f":"'Data Sheet'!G82","v":6.69},{"$f":"'Data Sheet'!H82","v":-1.24},{"$f":"'Data Sheet'!I82","v":15.13},{"$f":"'Data Sheet'!J82","v":11.79},{"$f":"'Data Sheet'!K82","v":9.15}]
["Capex",null,{"$f":"('Data Sheet'!C62-'Data Sheet'!B62)+('Data Sheet'!C63-'Data Sheet'!B63)+'Data Sheet'!C26","v":2.1100000000000003},{"$f":"('Data Sheet'!D62-'Data Sheet'!C62)+('Data Sheet'!D63-'Data Sheet'!C63)+'Data Sheet'!D26","v":3.5700000000000007},{"$f":"('Data Sheet'!E62-'Data Sheet'!D62)+('Data Sheet'!E63-'Data Sheet'!D63)+'Data Sheet'!E26","v":10.79},{"$f":"('Data Sheet'!F62-'Data Sheet'!E62)+('Data Sheet'!F63-'Data Sheet'!E63)+'Data Sheet'!F26","v":7.5700000000000012},{"$f":"('Data Sheet'!G62-'Data Sheet'!F62)+('Data Sheet'!G63-'Data Sheet'!F63)+'Data Sheet'!G26","v":0.7799999999999998},{"$f":"('Data Sheet'!H62-'Data Sheet'!G62)+('Data Sheet'!H63-'Data Sheet'!G63)+'Data Sheet'!H26","v":0.44999999999999885},{"$f":"('Data Sheet'!I62-'Data Sheet'!H62)+('Data Sheet'!I63-'Data Sheet'!H63)+'Data Sheet'!I26","v":0.9399999999999995},{"$f":"('Data Sheet'!J62-'Data Sheet'!I62)+('Data Sheet'!J63-'Data Sheet'!I63)+'Data Sheet'!J26","v":2.75},{"$f":"('Data Sheet'!K62-'Data Sheet'!J62)+('Data Sheet'!K63-'Data Sheet'!J63)+'Data Sheet'!K26","v":1.6900000000000011},null,"CHECK?","derived from BS"]
["Free Cash Flow",null,{"$f":"C17-C18","v":-4.2},{"$f":"D17-D18","v":1.2699999999999991},-9.5299999999999994,0.70999999999999819,5.91,-1.6899999999999988,14.190000000000001,9.0399999999999991,7.4599999999999991]
["RoE",{"$f":"Customization!B53","v":4.1719342604298368E-2},{"$f":"Customization!C53","v":0.13304013194062672},{"$f":"Customization!D53","v":0.14265470004723665},{"$f":"Customization!E53","v":0.13790289677682577},{"$f":"Customization!F53","v":0.10132158590308371},{"$f":"Customization!G53","v":-0.29202168861347794},{"$f":"Customization!H53","v":0.15841584158415842},{"$f":"Customization!I53","v":0.18556701030927833},{"$f":"Customization!J53","v":0.13787491281097419},{"$f":"Customization!K53","v":0.24894352669996164}]
["Dividend Payout",{"$f":"'Profit & Loss'!B23","v":0},{"$f":"'Profit & Loss'!C23","v":0},{"$f":"'Profit & Loss'!D23","v":0},{"$f":"'Profit & Loss'!E23","v":0},{"$f":"'Profit & Loss'!F23","v":0},{"$f":"'Profit & Loss'!G23","v":0},{"$f":"'Profit & Loss'!H23","v":0},{"$f":"'Profit & Loss'!I23","v":0},{"$f":"'Profit & Loss'!J23","v":0.40809443507588533},{"$f":"'Profit & Loss'!K23","v":0.18672839506172836}]
["Tax Rate",{"$f":"'Data Sheet'!B29/'Data Sheet'!B28","v":0.37735849056603776},{"$f":"'Data Sheet'!C29/'Data Sheet'!C28","v":0.43851508120649652},{"$f":"'Data Sheet'!D29/'Data Sheet'!D28","v":0.32438478747203581},{"$f":"'Data Sheet'!E29/'Data Sheet'!E28","v":0.32599999999999996},{"$f":"'Data Sheet'!F29/'Data Sheet'!F28","v":0.33653846153846151},{"$f":"'Data Sheet'!G29/'Data Sheet'!G28","v":4.4359949302915085E-2},{"$f":"'Data Sheet'!H29/'Data Sheet'!H28","v":0.16083916083916086},{"$f":"'Data Sheet'!I29/'Data Sheet'!I28","v":0.17908653846153846},{"$f":"'Data Sheet'!J29/'Data Sheet'!J28","v":0.24873096446700507},{"$f":"'Data Sheet'!K29/'Data Sheet'!K28","v":0.28807036833424959}]
["NOPLAT",{"$f":"B4*(1-B22)","v":0.86547169811320757},2.6726682134570763,3.6415659955257267,3.8485400000000003,4.2063461538461544,-5.6860583016476545,5.9496503496503497,7.4456850961538468,6.295634517766497,13.291726223199561]
["RoIC",{"$f":"(B4/B13)*(1-B22)","v":5.0201374600534095E-2},{"$f":"(C4/C13)*(1-C22)","v":0.10656571823991534},0.12501084776950661,9.7629122272957891E-2,9.5642249973764304E-2,-0.14838356737076344,0.14719570385082506,0.19440431060453908,0.19054583891545088,0.3468613315031201]
["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":-1.2033283018867922},{"$f":"C13*(C24-C25)","v":-0.33693178654292311},0.14596599552572753,-0.88185999999999976,-1.0712538461538459,-10.284458301647652,1.0992503496503492,2.8496850961538467,2.3308345177664971,8.6933262231995627]
["RoIIC",null,null,{"$f":"(D23-C23)/(C13-B13)","v":0.12358390077406256},{"$f":"(E23-D23)/(D13-C13)","v":5.1104692462783645E-2},3.4772220976302615E-2,-2.1693869419942553,-2.0557789136568871,0.71239749833499577,0.54247668791856007,-1.3300554573066665]
["3Yr Rolling RoIIC ",null,null,null,null,null,{"$f":"(G23-D23)/(F13-C13)","v":-0.49352509508853853},0.22863007069100652,3.2393389423076924,-2.1094529611644606,{"$f":"(K23-H23)/(J13-G13)","v":-1.3905446730206854}]
["5Yr Rolling RoIIC",null,null,null,null,null,null,{"$f":"(H23-C23)/(G13-B13)","v":0.1554545605404779},{"$f":"(I23-D23)/(H13-C13)","v":0.2479869035611551},0.26685872603778582,{"$f":"(K23-F23)/(J13-E13)","v":-1.4240407632215364}]
["Operating Leverage",null,{"$f":"IF(C4-B4>0,((C4-B4)/B4)/(('Data Sheet'!C17-'Data Sheet'!B17)/'Data Sheet'!B17), \"\")","v":2.4253570516367962},{"$f":"IF(D4-C4>0,((D4-C4)/C4)/(('Data Sheet'!D17-'Data Sheet'!C17)/'Data Sheet'!C17), \"\")","v":1.6571691176470611},{"$f":"IF(E4-D4>0,((E4-D4)/D4)/(('Data Sheet'!E17-'Data Sheet'!D17)/'Data Sheet'!D17), \"\")","v":2.1405895691609937},{"$f":"IF(F4-E4>0,((F4-E4)/E4)/(('Data Sheet'!F17-'Data Sheet'!E17)/'Data Sheet'!E17), \"\")","v":-0.55102121099976376},{"$f":"IF(G4-F4>0,((G4-F4)/F4)/(('Data Sheet'!G17-'Data Sheet'!F17)/'Data Sheet'!F17), \"\")","v":""},{"$f":"IF(H4-G4>0,((H4-G4)/G4)/(('Data Sheet'!H17-'Data Sheet'!G17)/'Data Sheet'!G17), \"\")","v":-3.1038388496192688},{"$f":"IF(I4-H4>0,((I4-H4)/H4)/(('Data Sheet'!I17-'Data Sheet'!H17)/'Data Sheet'!H17), \"\")","v":2.0360905998506618},{"$f":"IF(J4-I4>0,((J4-I4)/I4)/(('Data Sheet'!J17-'Data Sheet'!I17)/'Data Sheet'!I17), \"\")","v":""},{"$f":"IF(K4-J4>0,((K4-J4)/J4)/(('Data Sheet'!K17-'Data Sheet'!J17)/'Data Sheet'!J17), \"\")","v":3.421394039532466}]
["Sustainable Growth Rate",{"$f":"B20*(1-B21)","v":4.1719342604298368E-2},{"$f":"C20*(1-C21)","v":0.13304013194062672},0.14265470004723665,0.13790289677682577,0.10132158590308371,-0.29202168861347794,0.15841584158415842,0.18556701030927833,8.1608928156242738E-2,0.20245870149827128,null,"coy can grow at this rate safely with internal accruals"]
[null,{"$f":"B2","v":"2010-03-31"},"2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31","CURRENT"]
["MktCap",{"$f":"'Data Sheet'!B90*'Data Sheet'!B93","v":11.989760199999999},{"$f":"'Data Sheet'!C90*'Data Sheet'!C93","v":14.7097058},{"$f":"'Data Sheet'!D90*'Data Sheet'!D93","v":13.5897282},{"$f":"'Data Sheet'!E90*'Data Sheet'!E93","v":7.9398412},{"$f":"'Data Sheet'!F90*'Data Sheet'!F93","v":6.299874},{"$f":"'Data Sheet'!G90*'Data Sheet'!G93","v":18.416472000000002},{"$f":"'Data Sheet'!H90*'Data Sheet'!H93","v":23.763710800000002},{"$f":"'Data Sheet'!I90*'Data Sheet'!I93","v":133.438648},{"$f":"'Data Sheet'!J90*'Data Sheet'!J93","v":151.04738},{"$f":"'Data Sheet'!K90*'Data Sheet'!K93","v":204.76209},{"$f":"'Data Sheet'!B9","v":146.19999999999999}]
["MktCap+Dividend",{"$f":"B33+'Data Sheet'!B31","v":11.989760199999999},{"$f":"C33+'Data Sheet'!C31","v":14.7097058},{"$f":"D33+'Data Sheet'!D31","v":13.5897282},{"$f":"E33+'Data Sheet'!E31","v":7.9398412},{"$f":"F33+'Data Sheet'!F31","v":6.299874},{"$f":"G33+'Data Sheet'!G31","v":18.416472000000002},{"$f":"H33+'Data Sheet'!H31","v":23.763710800000002},{"$f":"I33+'Data Sheet'!I31","v":133.438648},{"$f":"J33+'Data Sheet'!J31","v":153.46737999999999},{"$f":"K33+'Data Sheet'!K31","v":207.18208999999999}]
["Retained Profit",{"$f":"'Data Sheet'!B30-'Data Sheet'!B31","v":0.66},{"$f":"'Data Sheet'!C30-'Data Sheet'!C31","v":2.42},{"$f":"'Data Sheet'!D30-'Data Sheet'!D31","v":3.02},{"$f":"'Data Sheet'!E30-'Data Sheet'!E31","v":3.38},{"$f":"'Data Sheet'!F30-'Data Sheet'!F31","v":2.76},{"$f":"'Data Sheet'!G30-'Data Sheet'!G31","v":-7.54},{"$f":"'Data Sheet'!H30-'Data Sheet'!H31","v":4.8},{"$f":"'Data Sheet'!I30-'Data Sheet'!I31","v":6.84},{"$f":"'Data Sheet'!J30-'Data Sheet'!J31","v":3.51},{"$f":"'Data Sheet'!K30-'Data Sheet'!K31","v":10.540000000000001}]
["EV",{"$f":"B33+'Data Sheet'!B59-'Data Sheet'!B69","v":13.429760199999999},{"$f":"C33+'Data Sheet'!C59-'Data Sheet'!C69","v":20.579705799999999},{"$f":"D33+'Data Sheet'!D59-'Data Sheet'!D69","v":17.029728199999997},{"$f":"E33+'Data Sheet'!E59-'Data Sheet'!E69","v":21.579841200000001},{"$f":"F33+'Data Sheet'!F59-'Data Sheet'!F69","v":21.369873999999996},{"$f":"G33+'Data Sheet'!G59-'Data Sheet'!G69","v":24.596472000000002},{"$f":"H33+'Data Sheet'!H59-'Data Sheet'!H69","v":33.053710800000005},{"$f":"I33+'Data Sheet'!I59-'Data Sheet'!I69","v":131.45864800000001},{"$f":"J33+'Data Sheet'!J59-'Data Sheet'!J69","v":150.89738},{"$f":"K33+'Data Sheet'!K59-'Data Sheet'!K69","v":200.42209}]
[null,{"$f":"B2","v":"2010-03-31"},"2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31"]
["Price/Earnings",{"$f":"B33/'Data Sheet'!B30","v":18.166303333333332},{"$f":"C33/'Data Sheet'!C30","v":6.0783908264462809},{"$f":"D33/'Data Sheet'!D30","v":4.4999099999999999},{"$f":"E33/'Data Sheet'!E30","v":2.3490654437869822},{"$f":"F33/'Data Sheet'!F30","v":2.2825630434782611},{"$f":"G33/'Data Sheet'!G30","v":-2.4425029177718836},{"$f":"H33/'Data Sheet'!H30","v":4.9507730833333339},{"$f":"I33/'Data Sheet'!I30","v":19.508574269005848},{"$f":"J33/'Data Sheet'!J30","v":25.471733558178755},{"$f":"K33/'Data Sheet'!K30","v":15.799543981481481}]
["Price/Book",{"$f":"B33/B10","v":0.75788623261694055},0.80866991753710837,0.64193331128956066,0.32394292941656472,0.2312729074889868,0.71326382649109221,0.78428088448844901,3.6201478024959308,3.5119130434782613,3.9331941990011527]
["Price/CashFlow",{"$f":"B33/B17","v":6.1485949743589741},-7.0381367464114835,2.8077950826446281,6.30146126984127,0.76085434782608696,2.7528358744394619,-19.164282903225807,8.8194744216787839,12.811482612383378,22.378370491803278]
["Price/Sales",{"$f":"B33/'Data Sheet'!B17","v":0.44324436968576708},{"$f":"C33/'Data Sheet'!C17","v":0.2719487114069144},{"$f":"D33/'Data Sheet'!D17","v":0.23266098613251157},{"$f":"E33/'Data Sheet'!E17","v":0.13226455438947193},{"$f":"F33/'Data Sheet'!F17","v":0.13122003749218913},{"$f":"G33/'Data Sheet'!G17","v":0.46944868722916144},{"$f":"H33/'Data Sheet'!H17","v":0.35505320185268191},{"$f":"I33/'Data Sheet'!I17","v":1.7532341085271319},{"$f":"J33/'Data Sheet'!J17","v":1.8533420858895706},{"$f":"K33/'Data Sheet'!K17","v":1.8488676297968398}]
["EV/EBITDA",{"$f":"B36/B5","v":6.5832157843137251},3.7485802914389796,2.694577246835443,3.0437011565585332,2.3380606126914656,-11.940034951456317,3.1360256925996213,11.093556793248947,14.010898792943362,9.3349832324173256]
["Dividend Yield",{"$f":"'Data Sheet'!B31/'Calculated Data'!B33","v":0},{"$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":0},{"$f":"'Data Sheet'!F31/'Calculated Data'!F33","v":0},{"$f":"'Data Sheet'!G31/'Calculated Data'!G33","v":0},{"$f":"'Data Sheet'!H31/'Calculated Data'!H33","v":0},{"$f":"'Data Sheet'!I31/'Calculated Data'!I33","v":0},{"$f":"'Data Sheet'!J31/'Calculated Data'!J33","v":1.60214629343455E-2},{"$f":"'Data Sheet'!K31/'Calculated Data'!K33","v":1.1818593959458022E-2}]
[null,{"$f":"B2","v":"2010-03-31"},"2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31","Z-Weights"]
["Working Capital/Total Assets",{"$f":"B11/B15","v":0.35906040268456368},0.36839845427221979,0.38631162887455789,0.31219903691813805,0.28893227211292988,0.24104563835932985,0.35071624014163849,0.33359181141439204,0.1902994011976048,0.26429418742586003,1.2]
["Retained Profits/Total Assets",{"$f":"B35/B15","v":2.214765100671141E-2},5.1953628166595107E-2,6.282504680674017E-2,5.4253611556982342E-2,4.1447664814536711E-2,-0.10889659156556904,7.7257363592467404E-2,0.10607940446650123,4.203592814371257E-2,0.12502965599051011,1.4]
["EBIT/Total Assets",{"$f":"B4/B15","v":4.6644295302013423E-2},0.10218978102189781,0.11212814645308923,9.1653290529695022E-2,9.5209490914551734E-2,-8.5932986712882728E-2,0.11411556413970705,0.1406637717121588,0.10035928143712573,0.22147093712930013,3.3]
["Market Cap/Total Liabilities",{"$f":"B33/B15","v":0.4023409463087248},0.31579445684843283,0.28270705637611815,0.12744528410914929,9.4606907944135746E-2,0.26598024263431547,0.38248367616288431,2.0694579404466502,1.8089506586826347,2.4289690391459078,0.6]
["Sales/Total Assets",{"$f":"'Data Sheet'!B17/'Calculated Data'!B15","v":0.90771812080536918},{"$f":"'Data Sheet'!C17/'Calculated Data'!C15","v":1.1612279948475741},{"$f":"'Data Sheet'!D17/'Calculated Data'!D15","v":1.2151029748283753},{"$f":"'Data Sheet'!E17/'Calculated Data'!E15","v":0.96356340288924569},{"$f":"'Data Sheet'!F17/'Calculated Data'!F15","v":0.72097912599489411},{"$f":"'Data Sheet'!G17/'Calculated Data'!G15","v":0.56658001155401505},{"$f":"'Data Sheet'!H17/'Calculated Data'!H15","v":1.0772573635924674},{"$f":"'Data Sheet'!I17/'Calculated Data'!I15","v":1.1803660049627791},{"$f":"'Data Sheet'!J17/'Calculated Data'!J15","v":0.9760479041916168},{"$f":"'Data Sheet'!K17/'Calculated Data'!K15","v":1.3137603795966786},1]
["Altman Z-Score",{"$f":"$L$45*B45+$L$46*B46+$L$47*B47+$L$48*B48+$L$49*B49","v":1.7649280577181208},{"$f":"$L$45*C45+$L$46*C46+$L$47*C47+$L$48*C48+$L$49*C49","v":2.2027441708887934},2.3062791121281463,1.7930803325842697,1.4966800480552633,0.5793888388214905,2.2123487281506518,3.4350525558312652,2.6798135089820359,3.9941904389086602]
["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":"AXTEL INDUSTRIES LTD"},{"$f":"B7","v":"2010-03-31"},"2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31"]
[{"$f":"'Data Sheet'!A17","v":"Sales"},{"$f":"'Data Sheet'!B17","v":27.05},{"$f":"'Data Sheet'!C17","v":54.09},{"$f":"'Data Sheet'!D17","v":58.41},{"$f":"'Data Sheet'!E17","v":60.03},{"$f":"'Data Sheet'!F17","v":48.01},{"$f":"'Data Sheet'!G17","v":39.229999999999997},{"$f":"'Data Sheet'!H17","v":66.930000000000007},{"$f":"'Data Sheet'!I17","v":76.11},{"$f":"'Data Sheet'!J17","v":81.5},{"$f":"'Data Sheet'!K17","v":110.75}]
[{"$f":"'Data Sheet'!A25","v":"Other Income"},{"$f":"'Data Sheet'!B25","v":7.0000000000000007E-2},{"$f":"'Data Sheet'!C25","v":0.02},{"$f":"'Data Sheet'!D25","v":0.1},{"$f":"'Data Sheet'!E25","v":0.33},{"$f":"'Data Sheet'!F25","v":0.2},{"$f":"'Data Sheet'!G25","v":0.23},{"$f":"'Data Sheet'!H25","v":0.22},{"$f":"'Data Sheet'!I25","v":1.17},{"$f":"'Data Sheet'!J25","v":0.68},{"$f":"'Data Sheet'!K25","v":1.59}]
["Sales Increase",null,{"$f":"(C2-B2)/B2","v":0.99963031423290216},7.9866888519134649E-2,2.7734976887519341E-2,-0.20023321672497091,-0.18287856696521562,0.70609227631914384,0.13715822501120561,7.0818552095651036E-2,0.35889570552147237]
["EBIT",{"$f":"'Calculated Data'!B4","v":1.3900000000000001},{"$f":"'Calculated Data'!C4","v":4.76},{"$f":"'Calculated Data'!D4","v":5.39},{"$f":"'Calculated Data'!E4","v":5.71},{"$f":"'Calculated Data'!F4","v":6.34},{"$f":"'Calculated Data'!G4","v":-5.9499999999999993},{"$f":"'Calculated Data'!H4","v":7.09},{"$f":"'Calculated Data'!I4","v":9.07},{"$f":"'Calculated Data'!J4","v":8.379999999999999},{"$f":"'Calculated Data'!K4","v":18.670000000000002}]
["EBIT Increase",null,{"$f":"(C5-B5)/B5","v":2.4244604316546758},{"$f":"(D5-C5)/C5","v":0.13235294117647056},5.936920222634514E-2,0.11033274956217161,-1.9384858044164037,-2.1915966386554624,0.2792665726375177,-7.6074972436604327E-2,1.2279236276849648]
["Operating Expenses",{"$f":"'Data Sheet'!B16","v":"2010-03-31"},{"$f":"'Data Sheet'!C16","v":"2011-03-31"},{"$f":"'Data Sheet'!D16","v":"2012-03-31"},{"$f":"'Data Sheet'!E16","v":"2013-03-31"},{"$f":"'Data Sheet'!F16","v":"2014-03-31"},{"$f":"'Data Sheet'!G16","v":"2015-03-31"},{"$f":"'Data Sheet'!H16","v":"2016-03-31"},{"$f":"'Data Sheet'!I16","v":"2017-03-31"},{"$f":"'Data Sheet'!J16","v":"2018-03-31"},{"$f":"'Data Sheet'!K16","v":"2019-03-31"}]
[{"$f":"'Data Sheet'!A18","v":"Raw Material Cost"},{"$f":"'Data Sheet'!B18","v":20.29},{"$f":"'Data Sheet'!C18","v":36.619999999999997},{"$f":"'Data Sheet'!D18","v":36.909999999999997},{"$f":"'Data Sheet'!E18","v":30.76},{"$f":"'Data Sheet'!F18","v":23.71},{"$f":"'Data Sheet'!G18","v":26.78},{"$f":"'Data Sheet'!H18","v":28.68},{"$f":"'Data Sheet'!I18","v":33.46},{"$f":"'Data Sheet'!J18","v":42.79},{"$f":"'Data Sheet'!K18","v":55.29}]
[{"$f":"'Data Sheet'!A19","v":"Change in Inventory"},{"$f":"'Data Sheet'!B19","v":4.7300000000000004},{"$f":"'Data Sheet'!C19","v":-0.27},{"$f":"'Data Sheet'!D19","v":-0.85},{"$f":"'Data Sheet'!E19","v":-5.0599999999999996},{"$f":"'Data Sheet'!F19","v":3.03},{"$f":"'Data Sheet'!G19","v":6.87},{"$f":"'Data Sheet'!H19","v":-2.89},{"$f":"'Data Sheet'!I19","v":-2.99},{"$f":"'Data Sheet'!J19","v":2.2400000000000002},{"$f":"'Data Sheet'!K19","v":0.93}]
[{"$f":"'Data Sheet'!A20","v":"Power and Fuel"},{"$f":"'Data Sheet'!B20","v":0.23},{"$f":"'Data Sheet'!C20","v":0.27},{"$f":"'Data Sheet'!D20","v":0.32},{"$f":"'Data Sheet'!E20","v":0.33},{"$f":"'Data Sheet'!F20","v":0.52},{"$f":"'Data Sheet'!G20","v":0.64},{"$f":"'Data Sheet'!H20","v":0.65},{"$f":"'Data Sheet'!I20","v":0.65},{"$f":"'Data Sheet'!J20","v":0.71},{"$f":"'Data Sheet'!K20","v":0.65}]
[{"$f":"'Data Sheet'!A21","v":"Other Mfr. Exp"},{"$f":"'Data Sheet'!B21","v":3.09},{"$f":"'Data Sheet'!C21","v":3.8},{"$f":"'Data Sheet'!D21","v":5.35},{"$f":"'Data Sheet'!E21","v":5.54},{"$f":"'Data Sheet'!F21","v":4.91},{"$f":"'Data Sheet'!G21","v":4.67},{"$f":"'Data Sheet'!H21","v":6.47},{"$f":"'Data Sheet'!I21","v":7.99},{"$f":"'Data Sheet'!J21","v":7.36},{"$f":"'Data Sheet'!K21","v":9.02}]
[{"$f":"'Data Sheet'!A22","v":"Employee Cost"},{"$f":"'Data Sheet'!B22","v":4.58},{"$f":"'Data Sheet'!C22","v":5.27},{"$f":"'Data Sheet'!D22","v":6.31},{"$f":"'Data Sheet'!E22","v":8.5},{"$f":"'Data Sheet'!F22","v":9.6},{"$f":"'Data Sheet'!G22","v":12.25},{"$f":"'Data Sheet'!H22","v":13.94},{"$f":"'Data Sheet'!I22","v":16.03},{"$f":"'Data Sheet'!J22","v":17.3},{"$f":"'Data Sheet'!K22","v":20.36}]
[{"$f":"'Data Sheet'!A23","v":"Selling and admin"},{"$f":"'Data Sheet'!B23","v":1.54},{"$f":"'Data Sheet'!C23","v":1.9},{"$f":"'Data Sheet'!D23","v":3.1},{"$f":"'Data Sheet'!E23","v":3.42},{"$f":"'Data Sheet'!F23","v":3.48},{"$f":"'Data Sheet'!G23","v":4.75},{"$f":"'Data Sheet'!H23","v":4.1900000000000004},{"$f":"'Data Sheet'!I23","v":4.29},{"$f":"'Data Sheet'!J23","v":5.44},{"$f":"'Data Sheet'!K23","v":6.33}]
[{"$f":"'Data Sheet'!A24","v":"Other Expenses"},{"$f":"'Data Sheet'!B24","v":0.08},{"$f":"'Data Sheet'!C24","v":0.49},{"$f":"'Data Sheet'!D24","v":-0.65},{"$f":"'Data Sheet'!E24","v":-0.34},{"$f":"'Data Sheet'!F24","v":-0.12},{"$f":"'Data Sheet'!G24","v":-0.7},{"$f":"'Data Sheet'!H24","v":-0.21},{"$f":"'Data Sheet'!I24","v":0.02},{"$f":"'Data Sheet'!J24","v":0.05},{"$f":"'Data Sheet'!K24","v":0.15}]
["Interest Expense",{"$f":"'Profit & Loss'!B9","v":0.33},{"$f":"'Profit & Loss'!C9","v":0.45},{"$f":"'Profit & Loss'!D9","v":0.92},{"$f":"'Profit & Loss'!E9","v":0.71},{"$f":"'Profit & Loss'!F9","v":2.1800000000000002},{"$f":"'Profit & Loss'!G9","v":1.94},{"$f":"'Profit & Loss'!H9","v":1.37},{"$f":"'Profit & Loss'!I9","v":0.75},{"$f":"'Profit & Loss'!J9","v":0.5},{"$f":"'Profit & Loss'!K9","v":0.48}]
["Coomon Size Expenses",{"$f":"B1","v":"2010-03-31"},"2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31"]
[{"$f":"A8","v":"Raw Material Cost"},{"$f":"B8/B$2","v":0.75009242144177446},0.67701978184507294,0.63191234377675054,0.51241046143594871,0.49385544678192045,0.68264083609482551,0.42850739578664271,0.43962685586650901,0.5250306748466258,0.49923250564334087,"check lower RM/Sales - high correlation with Op Leverage"]
["Change in Inventory",{"$f":"B9/B$2","v":0.17486136783733827},-4.9916805324459234E-3,-1.4552302687895908E-2,-8.4291187739463591E-2,6.3111851697563004E-2,0.17512108080550601,-4.3179441207231432E-2,-3.928524504007358E-2,2.7484662576687118E-2,8.3972911963882627E-3]
["Power and Fuel",{"$f":"B10/B$2","v":8.5027726432532341E-3},4.9916805324459234E-3,5.4785139530902248E-3,5.4972513743128436E-3,1.0831076858987711E-2,1.6314045373438696E-2,9.7116390258478996E-3,8.5402706608855607E-3,8.7116564417177907E-3,5.8690744920993233E-3]
["Other Mfr. Exp",{"$f":"B11/B$2","v":0.11423290203327172},7.0253281567757439E-2,9.1593905153227184E-2,9.2287189738464101E-2,0.10227036034159551,0.11904154983431048,9.666816076497832E-2,0.10497963473919328,9.0306748466257677E-2,8.1444695259593677E-2]
["Employee Cost",{"$f":"B12/B$2","v":0.16931608133086876},9.7430208911074123E-2,0.10802944701249786,0.14159586873230051,0.19995834201208082,0.31226102472597506,0.20827730464664573,0.21061621337537775,0.21226993865030674,0.18383747178329571,"check high Emp Cost/Sales - high correlation with Op Leverage"]
["Selling and admin",{"$f":"B13/B$2","v":5.6931608133086876E-2},3.512664078387872E-2,5.3073103920561554E-2,5.6971514242878558E-2,7.2484898979379292E-2,0.12108080550599032,6.2602719258927242E-2,5.6365786361844701E-2,6.6748466257668712E-2,5.7155756207674942E-2]
["Other Expenses",{"$f":"B14/B$2","v":2.9574861367837337E-3},9.0589757811055643E-3,-1.1128231467214519E-2,-5.6638347492920212E-3,-2.4994792751510102E-3,-1.7843487127198573E-2,-3.1376064545047058E-3,2.6277755879647877E-4,6.1349693251533746E-4,1.3544018058690745E-3]
["Interest Expense",{"$f":"B15/B2","v":1.2199630314232903E-2},8.3194675540765387E-3,1.5750727615134397E-2,1.1827419623521572E-2,4.5407206831910026E-2,4.9451950038236048E-2,2.0469146869864036E-2,9.8541584548679541E-3,6.1349693251533744E-3,4.3340857787810385E-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":"2010-03-31"},{"$f":"C16","v":"2011-03-31"},"2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31"]
["Raw Material Increase/Sales Increase",null,{"$f":"((C8-B8)/B8)/C$4","v":0.8051276097182567},9.9154605862006071E-2,-6.0076311749299887,1.1446340516131543,-0.70801753150492508,0.10048044906619777,1.2151416122004373,3.9373920844760213,0.81395325611263913]
["Change in Inventory Increase/Sales Increase",null,{"$f":"((C9-B9)/B9)/C$4","v":-1.0574733852909164},26.896604938271643,178.58104575163347,7.9847602480713942,-6.9298811430117953,-2.0120168787014108,0.25227853540493522,-24.699232444574058,-1.6295024420024418]
["Power & Fuel Increase/Sales Increase",null,{"$f":"((C10-B10)/B10)/C$4","v":0.17397736043220993},2.3186728395061755,1.1267361111111089,-2.8754348812585073,-1.2618713860171715,2.2128835740072211E-2,0,1.3034394177251307,-0.23546406644998175]
["Other Mfg Increase/Sales Increase",null,{"$f":"((C11-B11)/B11)/C$4","v":0.2298584381762126},5.1071820175438676,1.2804776739356167,0.56792980411708494,0.2672802935759388,0.54587620497993927,1.7128425816488388,-1.1133884888578252,0.62843738387216619]
["Employee Cost Increase/Sales Increase",null,{"$f":"((C12-B12)/B12)/C$4","v":0.1507107374486446},2.4709044908285938,12.51373481246695,-0.64630517764510087,-1.5094260155656796,0.19538407131805777,1.0931044345045544,1.1187245158370722,0.49284126278345908]
["Selling & Admin Cost Increase/Sales Increase",null,{"$f":"((C13-B13)/B13)/C$4","v":0.23385268577576257},7.9078947368421186,3.7218637992831414,-8.7617129345827188E-2,-1.9955456497263893,-0.1669678890366709,0.1740059587876514,3.7852407332926821,0.45585093011563577]
["Other Expenses Increase/Sales Increase",null,{"$f":"((C14-B14)/B14)/C$4","v":5.1268953402366861},-29.130102040816379,-17.195726495726444,3.2315258882255056,-26.42919514047076,-0.99137184115523425,-7.9852163087457271,21.180890538033395,5.5726495726495724]
["Year on Year Escalation",{"$f":"B26","v":"2010-03-31"},{"$f":"C26","v":"2011-03-31"},"2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31"]
["Working Capital Increase/Sales Increase",null,{"$f":"(('Calculated Data'!C11-'Calculated Data'!B11)/'Calculated Data'!B11)/'Cost Analysis'!C$4","v":0.6039615937620969},{"$f":"(('Calculated Data'!D11-'Calculated Data'!C11)/'Calculated Data'!C11)/'Cost Analysis'!D$4","v":1.0288097319347338},{"$f":"(('Calculated Data'!E11-'Calculated Data'!D11)/'Calculated Data'!D11)/'Cost Analysis'!E$4","v":1.708610064022019},{"$f":"(('Calculated Data'!F11-'Calculated Data'!E11)/'Calculated Data'!E11)/'Cost Analysis'!F$4","v":5.3921698625683134E-2},{"$f":"(('Calculated Data'!G11-'Calculated Data'!F11)/'Calculated Data'!F11)/'Cost Analysis'!G$4","v":0.7247234311585119},{"$f":"(('Calculated Data'!H11-'Calculated Data'!G11)/'Calculated Data'!G11)/'Cost Analysis'!H$4","v":0.43276524778667264},{"$f":"(('Calculated Data'!I11-'Calculated Data'!H11)/'Calculated Data'!H11)/'Cost Analysis'!I$4","v":-9.3686916406457835E-2},{"$f":"(('Calculated Data'!J11-'Calculated Data'!I11)/'Calculated Data'!I11)/'Cost Analysis'!J$4","v":-3.6893415411048407},{"$f":"(('Calculated Data'!K11-'Calculated Data'!J11)/'Calculated Data'!J11)/'Cost Analysis'!K$4","v":1.1204918429588036}]
["Debtors Increase/Sales Increase",null,{"$f":"('Balance Sheet'!C17-'Balance Sheet'!B17)/'Balance Sheet'!B17/'Cost Analysis'!C$4","v":2.5519195471639988},{"$f":"('Balance Sheet'!D17-'Balance Sheet'!C17)/'Balance Sheet'!C17/'Cost Analysis'!D$4","v":-2.8070530441865258},{"$f":"('Balance Sheet'!E17-'Balance Sheet'!D17)/'Balance Sheet'!D17/'Cost Analysis'!E$4","v":12.747200349956225},{"$f":"('Balance Sheet'!F17-'Balance Sheet'!E17)/'Balance Sheet'!E17/'Cost Analysis'!F$4","v":-0.11040064116524782},{"$f":"('Balance Sheet'!G17-'Balance Sheet'!F17)/'Balance Sheet'!F17/'Cost Analysis'!G$4","v":1.4098198809059239},{"$f":"('Balance Sheet'!H17-'Balance Sheet'!G17)/'Balance Sheet'!G17/'Cost Analysis'!H$4","v":0.56367439259374097},{"$f":"('Balance Sheet'!I17-'Balance Sheet'!H17)/'Balance Sheet'!H17/'Cost Analysis'!I$4","v":-0.12797980775780804},{"$f":"('Balance Sheet'!J17-'Balance Sheet'!I17)/'Balance Sheet'!I17/'Cost Analysis'!J$4","v":1.7424071501602016},{"$f":"('Balance Sheet'!K17-'Balance Sheet'!J17)/'Balance Sheet'!J17/'Cost Analysis'!K$4","v":-9.5554875872967501E-2}]
["Inventory Increase/Sales Increase",null,{"$f":"(('Balance Sheet'!C18-'Balance Sheet'!B18)/'Balance Sheet'!B18)/'Cost Analysis'!C$4","v":0.27951509745910186},{"$f":"(('Balance Sheet'!D18-'Balance Sheet'!C18)/'Balance Sheet'!C18)/'Cost Analysis'!D$4","v":-2.2942162497182812},{"$f":"(('Balance Sheet'!E18-'Balance Sheet'!D18)/'Balance Sheet'!D18)/'Cost Analysis'!E$4","v":-13.222360191317104},{"$f":"(('Balance Sheet'!F18-'Balance Sheet'!E18)/'Balance Sheet'!E18)/'Cost Analysis'!F$4","v":-2.0694822354898692},{"$f":"(('Balance Sheet'!G18-'Balance Sheet'!F18)/'Balance Sheet'!F18)/'Cost Analysis'!G$4","v":-3.5527549589682481},{"$f":"(('Balance Sheet'!H18-'Balance Sheet'!G18)/'Balance Sheet'!G18)/'Cost Analysis'!H$4","v":-0.33085398780450803},{"$f":"(('Balance Sheet'!I18-'Balance Sheet'!H18)/'Balance Sheet'!H18)/'Cost Analysis'!I$4","v":-0.7621282918625546},{"$f":"(('Balance Sheet'!J18-'Balance Sheet'!I18)/'Balance Sheet'!I18)/'Cost Analysis'!J$4","v":6.455128544924464},{"$f":"(('Balance Sheet'!K18-'Balance Sheet'!J18)/'Balance Sheet'!J18)/'Cost Analysis'!K$4","v":0.60253297900356717}]
["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.26395795110749298},{"$f":"IF('Balance Sheet'!D19>0,(('Balance Sheet'!D19-'Balance Sheet'!C19)/'Balance Sheet'!C19)/'Cost Analysis'!D$4,0)","v":1.3795618317061855},{"$f":"IF('Balance Sheet'!E19>0,(('Balance Sheet'!E19-'Balance Sheet'!D19)/'Balance Sheet'!D19)/'Cost Analysis'!E$4,0)","v":50.957914572864176},{"$f":"IF('Balance Sheet'!F19>0,(('Balance Sheet'!F19-'Balance Sheet'!E19)/'Balance Sheet'!E19)/'Cost Analysis'!F$4,0)","v":-4.736798204623387},{"$f":"IF('Balance Sheet'!G19>0,(('Balance Sheet'!G19-'Balance Sheet'!F19)/'Balance Sheet'!F19)/'Cost Analysis'!G$4,0)","v":-6.2818247821141551E-2},{"$f":"IF('Balance Sheet'!H19>0,(('Balance Sheet'!H19-'Balance Sheet'!G19)/'Balance Sheet'!G19)/'Cost Analysis'!H$4,0)","v":-0.45786700383895801},{"$f":"IF('Balance Sheet'!I19>0,(('Balance Sheet'!I19-'Balance Sheet'!H19)/'Balance Sheet'!H19)/'Cost Analysis'!I$4,0)","v":-1.9493489563402793},{"$f":"IF('Balance Sheet'!J19>0,(('Balance Sheet'!J19-'Balance Sheet'!I19)/'Balance Sheet'!I19)/'Cost Analysis'!J$4,0)","v":12.488111629598803},{"$f":"IF('Balance Sheet'!K19>0,(('Balance Sheet'!K19-'Balance Sheet'!J19)/'Balance Sheet'!J19)/'Cost Analysis'!K$4,0)","v":0.72474379514243836}]
["Invested Capital Increase/Sales Increase",null,{"$f":"(('Calculated Data'!C13-'Calculated Data'!B13)/'Calculated Data'!B13)/'Cost Analysis'!C$4","v":0.45492455964524497},{"$f":"(('Calculated Data'!D13-'Calculated Data'!C13)/'Calculated Data'!C13)/'Cost Analysis'!D$4","v":2.0219049043062221},{"$f":"(('Calculated Data'!E13-'Calculated Data'!D13)/'Calculated Data'!D13)/'Cost Analysis'!E$4","v":12.73641148872866},{"$f":"(('Calculated Data'!F13-'Calculated Data'!E13)/'Calculated Data'!E13)/'Cost Analysis'!F$4","v":-0.57771294417979169},{"$f":"(('Calculated Data'!G13-'Calculated Data'!F13)/'Calculated Data'!F13)/'Cost Analysis'!G$4","v":0.70371757301154803},{"$f":"(('Calculated Data'!H13-'Calculated Data'!G13)/'Calculated Data'!G13)/'Cost Analysis'!H$4","v":7.7612618044512402E-2},{"$f":"(('Calculated Data'!I13-'Calculated Data'!H13)/'Calculated Data'!H13)/'Cost Analysis'!I$4","v":-0.38239983441834707},{"$f":"(('Calculated Data'!J13-'Calculated Data'!I13)/'Calculated Data'!I13)/'Cost Analysis'!J$4","v":-1.9392773582255109},{"$f":"(('Calculated Data'!K13-'Calculated Data'!J13)/'Calculated Data'!J13)/'Cost Analysis'!K$4","v":0.44527224188241149}]
["Dilution ",{"$f":"B1","v":"2010-03-31"},"2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31"]
["Equity Capital Increase/Decrease",null,{"$f":"('Data Sheet'!C57-'Data Sheet'!B57)/'Data Sheet'!B57","v":0},{"$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.61499999999999988},{"$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":41,"n_cols":18,"rows_kept":41,"cut":false,"hidden":false,"merged":[[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],[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]]}
[{"$f":"'Data Sheet'!B1","v":"AXTEL INDUSTRIES LTD"}]
[null,{"$f":"'Data Sheet'!B16","v":"2010-03-31"},{"$f":"'Data Sheet'!C16","v":"2011-03-31"},{"$f":"'Data Sheet'!D16","v":"2012-03-31"},{"$f":"'Data Sheet'!E16","v":"2013-03-31"},{"$f":"'Data Sheet'!F16","v":"2014-03-31"},{"$f":"'Data Sheet'!G16","v":"2015-03-31"},{"$f":"'Data Sheet'!H16","v":"2016-03-31"},{"$f":"'Data Sheet'!I16","v":"2017-03-31"},{"$f":"'Data Sheet'!J16","v":"2018-03-31"},{"$f":"'Data Sheet'!K16","v":"2019-03-31"},null,"Consensus Forecasts",null,null,"5 Yr Avg","Inputs","TTM"]
["Sales",{"$f":"'Data Sheet'!B17","v":27.05},{"$f":"'Data Sheet'!C17","v":54.09},{"$f":"'Data Sheet'!D17","v":58.41},{"$f":"'Data Sheet'!E17","v":60.03},{"$f":"'Data Sheet'!F17","v":48.01},{"$f":"'Data Sheet'!G17","v":39.229999999999997},{"$f":"'Data Sheet'!H17","v":66.930000000000007},{"$f":"'Data Sheet'!I17","v":76.11},{"$f":"'Data Sheet'!J17","v":81.5},{"$f":"'Data Sheet'!K17","v":110.75},null,"Sales Growth Rate",null,null,{"$f":"Customization!B14","v":0.29622787529391292},0.15,{"$f":"'Profit & Loss'!L31","v":0}]
["Capex",null,{"$f":"'Calculated Data'!C18","v":2.1100000000000003},{"$f":"'Calculated Data'!D18","v":3.5700000000000007},{"$f":"'Calculated Data'!E18","v":10.79},{"$f":"'Calculated Data'!F18","v":7.5700000000000012},{"$f":"'Calculated Data'!G18","v":0.7799999999999998},{"$f":"'Calculated Data'!H18","v":0.44999999999999885},{"$f":"'Calculated Data'!I18","v":0.9399999999999995},{"$f":"'Calculated Data'!J18","v":2.75},{"$f":"'Calculated Data'!K18","v":1.6900000000000011},null,"EBIT Margin",null,null,0.18,0.18,{"$f":"'Calculated Data'!L4/Annual[[#This Row],[Column12]]","v":0.16607109272145953}]
["Depreciation",null,{"$f":"'Data Sheet'!C26","v":0.73},{"$f":"'Data Sheet'!D26","v":0.93},{"$f":"'Data Sheet'!E26","v":1.38},{"$f":"'Data Sheet'!F26","v":2.8},{"$f":"'Data Sheet'!G26","v":3.89},{"$f":"'Data Sheet'!H26","v":3.45},{"$f":"'Data Sheet'!I26","v":2.78},{"$f":"'Data Sheet'!J26","v":2.39},{"$f":"'Data Sheet'!K26","v":2.8},null,"Tax Rate",null,null,{"$f":"AVERAGE('Calculated Data'!G22:K22)","v":0.18421739628097383},0.25]
["Incremental Fixed Capital Investment",null,{"$f":"C4-C5","v":1.3800000000000003},{"$f":"D4-D5","v":2.6400000000000006},9.41,4.7700000000000014,-3.1100000000000003,-3.0000000000000013,-1.8400000000000003,0.35999999999999988,-1.1099999999999988,null,"Inc Fixed Capital Rate",null,null,{"$f":"AVERAGE(G9:K9)","v":0.430998445161764},0.2]
["Incremental Sales",null,{"$f":"C3-B3","v":27.040000000000003},{"$f":"D3-C3","v":4.3199999999999932},1.6200000000000045,-12.020000000000003,-8.7800000000000011,27.70000000000001,9.1799999999999926,5.3900000000000006,29.25,null,"Inc Working Capital Rate",null,null,{"$f":"AVERAGE(G15:K15)","v":0.18022491789833997},0.15]
["Incremental Fixed Capital Investment Rate",null,{"$f":"C6/C7","v":5.1035502958579892E-2},{"$f":"D6/D7","v":0.61111111111111216},5.8086419753086256,-0.39683860232945095,0.35421412300683369,-0.10830324909747294,-0.20043572984749475,6.679035250463819E-2,-3.794871794871791E-2,null,"Cost of Capital",null,null,null,0.12]
["5 Yr Avg",null,null,null,null,null,{"$f":"SUM(C6:G6)/SUM(C7:G7)","v":1.2389162561576357},{"$f":"SUM(D6:H6)/SUM(D7:H7)","v":0.83411214953270996},0.35197740112994336,-0.13134606427573361,-0.1386675167357348,null,"Inflation Rate",null,null,null,0.05]
["9 Yr Avg",null,null,null,null,null,null,null,null,null,{"$f":"SUM(C6:K6)/SUM(C7:K7)","v":0.11350059737156513},null,"Cash & Bank Balance",null,null,null,{"$f":"'Balance Sheet'!K34","v":5.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Investments",null,null,null,{"$f":"'Balance Sheet'!K12","v":14.9}]
["Working Capital",{"$f":"'Calculated Data'!B11","v":10.699999999999998},{"$f":"'Calculated Data'!C11","v":17.159999999999997},{"$f":"'Calculated Data'!D11","v":18.569999999999997},{"$f":"'Calculated Data'!E11","v":19.45},{"$f":"'Calculated Data'!F11","v":19.240000000000002},{"$f":"'Calculated Data'!G11","v":16.689999999999998},{"$f":"'Calculated Data'!H11","v":21.79},{"$f":"'Calculated Data'!I11","v":21.51},{"$f":"'Calculated Data'!J11","v":15.89},{"$f":"'Calculated Data'!K11","v":22.28},null,"Non-Operative Assets",null,null,null,{"$f":"Q10+Q11","v":20.399999999999999}]
["Incremental Working Capital",null,{"$f":"C12-B12","v":6.4599999999999991},{"$f":"D12-C12","v":1.4100000000000001},0.88000000000000256,-0.2099999999999973,-2.5500000000000043,5.1000000000000014,-0.27999999999999758,-5.620000000000001,6.3900000000000006,null,"Debt",null,null,null,{"$f":"'Balance Sheet'!K6","v":1.1599999999999999}]
["Incremental Working Capital Investment Rate",null,{"$f":"C13/C7","v":0.23890532544378693},{"$f":"D13/D7","v":0.32638888888888945},0.54320987654320996,1.7470881863560501E-2,0.29043280182232389,0.18411552346570395,-3.0501089324618497E-2,-1.0426716141001855,0.21846153846153848,null,"# Shares Outstanding",null,null,null,{"$f":"'Data Sheet'!B6","v":1.6154696132596684}]
["5 Yr Avg",null,null,null,null,null,{"$f":"SUM(C13:G13)/SUM(C7:G7)","v":0.49178981937602628},{"$f":"SUM(D13:H13)/SUM(D7:H7)","v":0.3605919003115266},0.16610169491525448,-0.16581276199347922,4.8453936882371679E-2,null,"CMP",null,null,null,{"$f":"'Data Sheet'!B8","v":90.5}]
["9 Yr Avg",null,null,null,null,null,null,null,null,null,{"$f":"SUM(C13:K13)/SUM(C7:K7)","v":0.13835125448028679}]
["Years in Future",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
["Year","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","2030-03-01","2031-03-01","2032-03-01","1933-03-01","1934-03-01"]
["Sales",{"$f":"'Data Sheet'!K17","v":110.75},{"$f":"B19*(1+10%)","v":121.825},{"$f":"C19*(1+$Q$3)","v":140.09875},{"$f":"D19*(1+$Q$3)","v":161.11356249999997},185.28059687499996,213.07268640624994,245.0335893671874,281.7886277722655,324.05692193810529,372.66546022882108,428.56527926314419,492.85007115261578,566.77758182550815,651.79421909933433,749.56335196423447,861.99785475886961]
["EBIT",{"$f":"'Calculated Data'!K4","v":18.670000000000002},{"$f":"R4*C19","v":20.231610870791808},{"$f":"D19*$Q$4","v":25.217775},{"$f":"E19*$Q$4","v":29.000441249999994},33.350507437499992,38.353083553124989,44.106046086093734,50.72195299900779,58.330245948858952,67.079782841187793,77.14175026736595,88.713012807470832,102.01996472859146,117.32295943788017,134.9214033535622,155.15961385659654]
["NOPAT",{"$f":"'Calculated Data'!K23","v":13.291726223199561},{"$f":"C20*(1-$Q$5)","v":15.173708153093855},{"$f":"D20*(1-$Q$5)","v":18.913331249999999},21.750330937499996,25.012880578124992,28.764812664843742,33.079534564570302,38.041464749255844,43.747684461644212,50.309837130890841,57.856312700524462,66.534759605603128,76.514973546443599,87.992219578410129,101.19105251517165,116.3697103924474]
["Incremental Fixed Capital Investment",null,{"$f":"(C19-B19)*$Q$6","v":2.2150000000000007},{"$f":"(D19-C19)*$Q$6","v":3.6547499999999986},4.2029624999999955,4.8334068749999979,5.5584179062499972,6.3921805921874926,7.35100768101562,8.4536588331679585,9.7217076581431581,11.179963806864624,12.856958377894319,14.785502134578474,17.003327454765238,19.553826572980029,22.486900558927029]
["Incremental Working Capital Investment",null,{"$f":"(C19-B19)*$Q$7","v":1.6612500000000003},{"$f":"(D19-C19)*$Q$7","v":2.7410624999999986},3.1522218749999964,3.6250551562499975,4.1688134296874972,4.7941354441406192,5.5132557607617141,6.3402441248759684,7.2912807436073672,8.384972855148467,9.6427187834207384,11.089126600933854,12.752495591073925,14.665369929735022,16.865175419195271]
["Free Cash Flow",null,{"$f":"C21-(C22+C23)","v":11.297458153093855},{"$f":"D21-(D22+D23)","v":12.517518750000001},14.395146562500004,16.554418546874999,19.037581328906249,21.893218528242191,25.177201307478512,28.953781503600286,33.296848729140315,38.291376038511373,44.035082444288072,50.640344810931268,58.236396532570964,66.971856012456598,77.017634414325101]
["Present Value of Free Cash Flow",null,{"$f":"C24/((1+$Q$8)^C17)","v":10.087016208119513},{"$f":"D24/((1+$Q$8)^D17)","v":9.9788893096301017},10.246180987566623,10.520632264019296,10.802434913948385,11.091785849143431,11.388887255816913,11.693946735883435,12.007177452023164,12.328798276630931,12.659033944754968,12.998115211132331,13.346279011430518,13.703768627808119,14.070833858910124]
["Cumulative Present Value of Free Cash Flow",null,{"$f":"C25","v":10.087016208119513},{"$f":"D25+C26","v":20.065905517749613},{"$f":"E25+D26","v":30.312086505316238},40.832718769335536,51.635153683283917,62.726939532427352,74.115826788244263,85.809773524127692,97.816950976150849,110.14574925278178,122.80478319753675,135.80289840866908,149.14917742009959,162.85294604790772,176.92377990681786]
["Present Value of Residual Value",null,{"$f":"((C21*(1+$Q$9))/($Q$8-$Q$9))/((1+$Q$8)^C17)","v":203.2193056217927},{"$f":"((D21*(1+$Q$9))/($Q$8-$Q$9))/((1+$Q$8)^D17)","v":226.16387814891581},232.22183917076171,238.44206700569282,244.8289080862024,251.38682526708277,258.12040094387964,265.03434025487633,272.13347436884624,279.42276386086883,286.9073021785706,294.5923192012109,302.48318489410042,310.58541306090666,318.90466519646668]
[]
["Corporate Value",null,{"$f":"C27+C26","v":213.30632182991221},{"$f":"D27+D26","v":246.22978366666541},262.53392567607796,279.27478577502836,296.46406176948631,314.11376479951014,332.23622773212389,350.84411377900403,369.95042534499709,389.56851311365062,409.71208537610732,430.39521760987998,451.63236231420001,473.43835910881438,495.82844510328454]
["Add: Non-Operative Assets",null,{"$f":"$Q$12","v":20.399999999999999},{"$f":"$Q$12","v":20.399999999999999},20.399999999999999,20.399999999999999,20.399999999999999,20.399999999999999,20.399999999999999,20.399999999999999,20.399999999999999,20.399999999999999,20.399999999999999,20.399999999999999,20.399999999999999,20.399999999999999,20.399999999999999]
["Less: Debt",null,{"$f":"$Q$13","v":1.1599999999999999},{"$f":"$Q$13","v":1.1599999999999999},1.1599999999999999,1.1599999999999999,1.1599999999999999,1.1599999999999999,1.1599999999999999,1.1599999999999999,1.1599999999999999,1.1599999999999999,1.1599999999999999,1.1599999999999999,1.1599999999999999,1.1599999999999999,1.1599999999999999]
["Shareholder Value",null,{"$f":"C29+C30-C31","v":232.54632182991222},{"$f":"D29+D30-D31","v":265.46978366666536},281.77392567607791,298.51478577502832,315.70406176948626,333.35376479951009,351.47622773212385,370.08411377900399,389.19042534499704,408.80851311365058,428.95208537610728,449.63521760987993,470.87236231419996,492.67835910881433,515.0684451032846]
[]
["Shareholder Value/Share",null,{"$f":"C32/$Q$14","v":143.94967254177195},{"$f":"D32/$Q$14","v":164.32979084701242},174.422300093605,184.78514440930277,195.42556491202811,206.35099667821933,217.5690739381478,229.08763541039576,240.91472977922186,253.05862131864146,265.52779566715259,278.33096575714183,291.47707790311284,304.97531805299383,318.8351182068896]
["Market-Implied-Forecast-Period",null,{"$f":"IF(Q15>Q34,\"15+\",IF(Q15<C34,\"<1\",LOOKUP(Q15,C34:Q34,C17:Q17)))","v":"<1"}]
[]
["Steady State Value",{"$f":"C32","v":232.54632182991222},{"$f":"B21*16","v":212.66761957119297},"(as per Rajshekhar Iyer formula)"]
["Future Value",{"$f":"'Calculated Data'!K13*('Calculated Data'!K24-'Calculated Data'!K25)*10/('Price Implied Expectations'!Q8)*(1+'Price Implied Expectations'!Q8)","v":811.37711416529271},{"$f":"L32","v":408.80851311365058},"(present value of year 10 shareholder future value)"]
["Value",{"$f":"B37+B38","v":1043.923435995205},{"$f":"C37+C38","v":621.47613268484361}]
["Value/Share",{"$f":"B39/'Data Sheet'!B6","v":646.20431571522613},{"$f":"C39/'Data Sheet'!B6","v":384.70307802994768}]
[null,"(as per Credit Suisse paper What's captured in P/E)"]

{"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":"AXTEL INDUSTRIES LTD"},{"$f":"'Data Sheet'!B16","v":"2010-03-31"},{"$f":"'Data Sheet'!C16","v":"2011-03-31"},{"$f":"'Data Sheet'!D16","v":"2012-03-31"},{"$f":"'Data Sheet'!E16","v":"2013-03-31"},{"$f":"'Data Sheet'!F16","v":"2014-03-31"},{"$f":"'Data Sheet'!G16","v":"2015-03-31"},{"$f":"'Data Sheet'!H16","v":"2016-03-31"},{"$f":"'Data Sheet'!I16","v":"2017-03-31"},{"$f":"'Data Sheet'!J16","v":"2018-03-31"},{"$f":"'Data Sheet'!K16","v":"2019-03-31"},"TTM"]
["Sales",{"$f":"'Data Sheet'!B17","v":27.05},{"$f":"'Data Sheet'!C17","v":54.09},{"$f":"'Data Sheet'!D17","v":58.41},{"$f":"'Data Sheet'!E17","v":60.03},{"$f":"'Data Sheet'!F17","v":48.01},{"$f":"'Data Sheet'!G17","v":39.229999999999997},{"$f":"'Data Sheet'!H17","v":66.930000000000007},{"$f":"'Data Sheet'!I17","v":76.11},{"$f":"'Data Sheet'!J17","v":81.5},{"$f":"'Data Sheet'!K17","v":110.75},{"$f":"'Profit & Loss'!L4","v":106.33999999999999}]
["EBIT",{"$f":"'Profit & Loss'!B10+'Profit & Loss'!B9","v":1.3900000000000001},{"$f":"'Profit & Loss'!C10+'Profit & Loss'!C9","v":4.76},{"$f":"'Profit & Loss'!D10+'Profit & Loss'!D9","v":5.39},{"$f":"'Profit & Loss'!E10+'Profit & Loss'!E9","v":5.71},{"$f":"'Profit & Loss'!F10+'Profit & Loss'!F9","v":6.34},{"$f":"'Profit & Loss'!G10+'Profit & Loss'!G9","v":-5.9499999999999993},{"$f":"'Profit & Loss'!H10+'Profit & Loss'!H9","v":7.09},{"$f":"'Profit & Loss'!I10+'Profit & Loss'!I9","v":9.07},{"$f":"'Profit & Loss'!J10+'Profit & Loss'!J9","v":8.379999999999999},{"$f":"'Profit & Loss'!K10+'Profit & Loss'!K9","v":18.670000000000002},{"$f":"'Profit & Loss'!L10+'Profit & Loss'!L9","v":17.660000000000004}]
["Operating Profit (ex Other Income)",{"$f":"'Calculated Data'!B6","v":1.97},{"$f":"'Calculated Data'!C6","v":5.4700000000000006},{"$f":"'Calculated Data'!D6","v":6.22},{"$f":"'Calculated Data'!E6","v":6.76},{"$f":"'Calculated Data'!F6","v":8.9400000000000013},{"$f":"'Calculated Data'!G6","v":-2.2899999999999991},{"$f":"'Calculated Data'!H6","v":10.319999999999999},{"$f":"'Calculated Data'!I6","v":10.68},{"$f":"'Calculated Data'!J6","v":10.09},{"$f":"'Calculated Data'!K6","v":19.880000000000003},{"$f":"'Profit & Loss'!L6","v":18.11}]
["Operating Profit Margin (ex Other Income)",{"$f":"B5/B3","v":7.2828096118299449E-2},0.10112775004621927,0.10648861496319123,0.1126103614859237,0.1862112059987503,-5.8373693601835315E-2,0.15419094576423126,0.14032321639731968,0.1238036809815951,0.17950338600451471,0.17030280233214221]
["1Yr Sales Increase",null,{"$f":"(C3-B3)/B3","v":0.99963031423290216},7.9866888519134649E-2,2.7734976887519341E-2,-0.20023321672497091,-0.18287856696521562,0.70609227631914384,0.13715822501120561,7.0818552095651036E-2,0.35889570552147237,-3.9819413092550889E-2]
["1Yr EBIT Increase",null,{"$f":"(C4-B4)/B4","v":2.4244604316546758},0.13235294117647056,5.936920222634514E-2,0.11033274956217161,-1.9384858044164037,-2.1915966386554624,0.2792665726375177,-7.6074972436604327E-2,1.2279236276849648,-5.4097482592394101E-2]
["3Yr Sales Increase",null,null,null,{"$f":"(E3-B3)/B3","v":1.2192236598890944},{"$f":"(F3-C3)/C3","v":-0.11240525050841201},-0.32836843006334532,0.11494252873563228,0.58529473026452827,1.0774917155238339,0.65471388017331522,0.39718828012087753]
["3Yr EBIT Increase",null,null,null,{"$f":"(E4-B4)/B4","v":3.107913669064748},{"$f":"(F4-C4)/C4","v":0.33193277310924374},{"$f":"(G4-D4)/D4","v":-2.1038961038961039},{"$f":"(H4-E4)/E4","v":0.24168126094570927},{"$f":"(I4-F4)/F4","v":0.4305993690851736},{"$f":"(J4-G4)/G4","v":-2.4084033613445377},{"$f":"(K4-H4)/H4","v":1.6332863187588156},{"$f":"(L4-I4)/I4","v":0.94707828004410177}]
["Abnormal margin exclusion (RM cycle)"]
["1 Yr Operating Leverage",null,{"$f":"IF((C3-B3)>0,(C8/C7),0)","v":2.4253570516367962},1.6571691176470611,2.1405895691609937,0,0,-3.1038388496192688,2.0360905998506618,-1.0742237759090825,3.421394039532466,0]
["3Yr Operating Leverage",null,null,null,{"$f":"IF((E3-B3)>0,E10/E9,0)","v":2.5490923210491636},{"$f":"IF((F3-C3)>0,F10/F9,0)","v":0},0,2.1026269702276688,0.73569664447612748,-2.2351943190335035,2.4946566251603732,2.3844567613019056]
["EBIT Margin",{"$f":"B4/B3","v":5.1386321626617382E-2},8.8001479016454054E-2,9.2278719397363471E-2,9.5119107113110113E-2,0.13205582170381172,-0.15166964058118787,0.10593157029732556,0.11916962291420313,0.10282208588957054,0.16857787810383748,0.16607109272145953]
["Invested Capital",{"$f":"'Calculated Data'!B13","v":17.239999999999998},{"$f":"'Calculated Data'!C13","v":25.08},{"$f":"'Calculated Data'!D13","v":29.129999999999995},{"$f":"'Calculated Data'!E13","v":39.42},{"$f":"'Calculated Data'!F13","v":43.980000000000004},{"$f":"'Calculated Data'!G13","v":38.319999999999993},{"$f":"'Calculated Data'!H13","v":40.42},{"$f":"'Calculated Data'!I13","v":38.299999999999997},{"$f":"'Calculated Data'!J13","v":33.04},{"$f":"'Calculated Data'!K13","v":38.32},{"$f":"'Balance Sheet'!L10+'Balance Sheet'!L11+'Balance Sheet'!L16","v":0}]
["Capital Turns",{"$f":"B3/B15","v":1.5690255220417635},2.1566985645933019,2.0051493305870238,1.5228310502283104,1.091632560254661,1.0237473903966599,1.6558634339435925,1.9872062663185379,2.4667070217917675,2.8901356993736953,{"$error":"#DIV/0!"}]
["RoIC",{"$f":"'Calculated Data'!B24","v":5.0201374600534095E-2},{"$f":"'Calculated Data'!C24","v":0.10656571823991534},{"$f":"'Calculated Data'!D24","v":0.12501084776950661},{"$f":"'Calculated Data'!E24","v":9.7629122272957891E-2},{"$f":"'Calculated Data'!F24","v":9.5642249973764304E-2},{"$f":"'Calculated Data'!G24","v":-0.14838356737076344},{"$f":"'Calculated Data'!H24","v":0.14719570385082506},{"$f":"'Calculated Data'!I24","v":0.19440431060453908},{"$f":"'Calculated Data'!J24","v":0.19054583891545088},{"$f":"'Calculated Data'!K24","v":0.3468613315031201},{"$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":0.1554545605404779},{"$f":"Customization!I58","v":0.2479869035611551},{"$f":"Customization!J58","v":0.26685872603778582},{"$f":"Customization!K58","v":-1.4240407632215364}]
["EPA",{"$f":"'Calculated Data'!B26","v":-1.2033283018867922},{"$f":"'Calculated Data'!C26","v":-0.33693178654292311},{"$f":"'Calculated Data'!D26","v":0.14596599552572753},{"$f":"'Calculated Data'!E26","v":-0.88185999999999976},{"$f":"'Calculated Data'!F26","v":-1.0712538461538459},{"$f":"'Calculated Data'!G26","v":-10.284458301647652},{"$f":"'Calculated Data'!H26","v":1.0992503496503492},{"$f":"'Calculated Data'!I26","v":2.8496850961538467},{"$f":"'Calculated Data'!J26","v":2.3308345177664971},{"$f":"'Calculated Data'!K26","v":8.6933262231995627},{"$f":"L15*(L17-'Calculated Data'!K25)","v":{"$error":"#DIV/0!"}}]
["EPA/Sales",{"$f":"B19/B3","v":-4.4485334635371243E-2},-6.2290957024019799E-3,2.4989898223887613E-3,-1.4690321505913706E-2,-2.231313989072789E-2,-0.26215799902237197,1.6423880915140431E-2,3.744166464530084E-2,2.8599196537012234E-2,7.8495044904736452E-2,{"$error":"#DIV/0!"}]
["Sustainable Growth Rate (without addl financing?)",{"$f":"'Calculated Data'!B31","v":4.1719342604298368E-2},{"$f":"'Calculated Data'!C31","v":0.13304013194062672},{"$f":"'Calculated Data'!D31","v":0.14265470004723665},{"$f":"'Calculated Data'!E31","v":0.13790289677682577},{"$f":"'Calculated Data'!F31","v":0.10132158590308371},{"$f":"'Calculated Data'!G31","v":-0.29202168861347794},{"$f":"'Calculated Data'!H31","v":0.15841584158415842},{"$f":"'Calculated Data'!I31","v":0.18556701030927833},{"$f":"'Calculated Data'!J31","v":8.1608928156242738E-2},{"$f":"'Calculated Data'!K31","v":0.20245870149827128}]
["Business Robustness Snapshot (Quarterly)","Latest 10 Quarters Performance"]
[{"$f":"A2","v":"AXTEL INDUSTRIES LTD"},{"$f":"'Data Sheet'!B41","v":"2017-09-30"},{"$f":"'Data Sheet'!C41","v":"2017-12-31"},{"$f":"'Data Sheet'!D41","v":"2018-03-31"},{"$f":"'Data Sheet'!E41","v":"2018-06-30"},{"$f":"'Data Sheet'!F41","v":"2018-09-30"},{"$f":"'Data Sheet'!G41","v":"2018-12-31"},{"$f":"'Data Sheet'!H41","v":"2019-03-31"},{"$f":"'Data Sheet'!I41","v":"2019-06-30"},{"$f":"'Data Sheet'!J41","v":"2019-09-30"},{"$f":"'Data Sheet'!K41","v":"2019-12-31"}]
["Sales",{"$f":"'Data Sheet'!B42","v":24.16},{"$f":"'Data Sheet'!C42","v":14.39},{"$f":"'Data Sheet'!D42","v":30.06},{"$f":"'Data Sheet'!E42","v":21.37},{"$f":"'Data Sheet'!F42","v":30.28},{"$f":"'Data Sheet'!G42","v":28.97},{"$f":"'Data Sheet'!H42","v":30.13},{"$f":"'Data Sheet'!I42","v":17.829999999999998},{"$f":"'Data Sheet'!J42","v":30.83},{"$f":"'Data Sheet'!K42","v":27.55}]
["EBIT",{"$f":"Quarters!B16","v":1.83},{"$f":"Quarters!C16","v":0.8899999999999999},{"$f":"Quarters!D16","v":4.5200000000000005},{"$f":"Quarters!E16","v":2.09},{"$f":"Quarters!F16","v":5.5600000000000005},{"$f":"Quarters!G16","v":5.6899999999999995},{"$f":"Quarters!H16","v":5.34},{"$f":"Quarters!I16","v":1.1000000000000001},{"$f":"Quarters!J16","v":4.99},{"$f":"Quarters!K16","v":6.23}]
["Operating Profit (ex Other Income)",{"$f":"Quarters!B6","v":2.2799999999999998},{"$f":"Quarters!C6","v":1.3},{"$f":"Quarters!D6","v":4.84},{"$f":"Quarters!E6","v":2.5099999999999998},{"$f":"Quarters!F6","v":5.42},{"$f":"Quarters!G6","v":5.78},{"$f":"Quarters!H6","v":6.17},{"$f":"Quarters!I6","v":1.29},{"$f":"Quarters!J6","v":4.7300000000000004},{"$f":"Quarters!K6","v":5.92}]
["EBIT Margin",{"$f":"B25/B24","v":7.574503311258278E-2},{"$f":"C25/C24","v":6.1848505906879771E-2},0.15036593479707255,9.7800655124005598E-2,0.18361955085865259,0.19641007939247496,0.17723199468967807,6.16937745372967E-2,0.16185533571196889,0.22613430127041742]
["Operating Profit Margin (ex Other Income)",{"$f":"B26/B24","v":9.4370860927152314E-2},{"$f":"C26/C24","v":9.0340514246004172E-2},0.16101131071190952,0.11745437529246607,0.17899603698811095,0.19951674145667933,0.20477928974444076,7.234997195737522E-2,0.15342199156665587,0.21488203266787659]
["Threshold Margin Snapshot",{"$f":"B2","v":"2010-03-31"},{"$f":"C2","v":"2011-03-31"},"2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31","TTM"]
["Incremental Fixed Capital Investment Rate",null,{"$f":"('Calculated Data'!C18-'Data Sheet'!C26)/('Business Robustness'!C3-'Business Robustness'!B3)","v":5.1035502958579892E-2},{"$f":"('Calculated Data'!D18-'Data Sheet'!D26)/('Business Robustness'!D3-'Business Robustness'!C3)","v":0.61111111111111216},{"$f":"('Calculated Data'!E18-'Data Sheet'!E26)/('Business Robustness'!E3-'Business Robustness'!D3)","v":5.8086419753086256},{"$f":"('Calculated Data'!F18-'Data Sheet'!F26)/('Business Robustness'!F3-'Business Robustness'!E3)","v":-0.39683860232945095},{"$f":"('Calculated Data'!G18-'Data Sheet'!G26)/('Business Robustness'!G3-'Business Robustness'!F3)","v":0.35421412300683369},{"$f":"('Calculated Data'!H18-'Data Sheet'!H26)/('Business Robustness'!H3-'Business Robustness'!G3)","v":-0.10830324909747294},{"$f":"('Calculated Data'!I18-'Data Sheet'!I26)/('Business Robustness'!I3-'Business Robustness'!H3)","v":-0.20043572984749475},{"$f":"('Calculated Data'!J18-'Data Sheet'!J26)/('Business Robustness'!J3-'Business Robustness'!I3)","v":6.679035250463819E-2},{"$f":"('Calculated Data'!K18-'Data Sheet'!K26)/('Business Robustness'!K3-'Business Robustness'!J3)","v":-3.794871794871791E-2}]
["Incremental Working Capital Investment Rate",null,{"$f":"('Calculated Data'!C11-'Calculated Data'!B11)/('Business Robustness'!C3-'Business Robustness'!B3)","v":0.23890532544378693},{"$f":"('Calculated Data'!D11-'Calculated Data'!C11)/('Business Robustness'!D3-'Business Robustness'!C3)","v":0.32638888888888945},{"$f":"('Calculated Data'!E11-'Calculated Data'!D11)/('Business Robustness'!E3-'Business Robustness'!D3)","v":0.54320987654320996},{"$f":"('Calculated Data'!F11-'Calculated Data'!E11)/('Business Robustness'!F3-'Business Robustness'!E3)","v":1.7470881863560501E-2},{"$f":"('Calculated Data'!G11-'Calculated Data'!F11)/('Business Robustness'!G3-'Business Robustness'!F3)","v":0.29043280182232389},{"$f":"('Calculated Data'!H11-'Calculated Data'!G11)/('Business Robustness'!H3-'Business Robustness'!G3)","v":0.18411552346570395},{"$f":"('Calculated Data'!I11-'Calculated Data'!H11)/('Business Robustness'!I3-'Business Robustness'!H3)","v":-3.0501089324618497E-2},{"$f":"('Calculated Data'!J11-'Calculated Data'!I11)/('Business Robustness'!J3-'Business Robustness'!I3)","v":-1.0426716141001855},{"$f":"('Calculated Data'!K11-'Calculated Data'!J11)/('Business Robustness'!K3-'Business Robustness'!J3)","v":0.21846153846153848}]
["Incremental Threshold Margin",null,{"$f":"((C30+C31)*'Calculated Data'!C25)/((1+'Calculated Data'!C25)*(1-'Calculated Data'!C22))","v":5.5326666340652329E-2},{"$f":"((D30+D31)*'Calculated Data'!D25)/((1+'Calculated Data'!D25)*(1-'Calculated Data'!D22))","v":0.14867401844843922},{"$f":"((E30+E31)*'Calculated Data'!E25)/((1+'Calculated Data'!E25)*(1-'Calculated Data'!E22))","v":1.0097263435542341},{"$f":"((F30+F31)*'Calculated Data'!F25)/((1+'Calculated Data'!F25)*(1-'Calculated Data'!F22))","v":-6.1264352373373604E-2},{"$f":"((G30+G31)*'Calculated Data'!G25)/((1+'Calculated Data'!G25)*(1-'Calculated Data'!G22))","v":7.2275448610771856E-2},{"$f":"((H30+H31)*'Calculated Data'!H25)/((1+'Calculated Data'!H25)*(1-'Calculated Data'!H22))","v":9.6796028880866379E-3},{"$f":"((I30+I31)*'Calculated Data'!I25)/((1+'Calculated Data'!I25)*(1-'Calculated Data'!I22))","v":-3.0141094993390224E-2},{"$f":"((J30+J31)*'Calculated Data'!J25)/((1+'Calculated Data'!J25)*(1-'Calculated Data'!J22))","v":-0.13917611621693252},{"$f":"((K30+K31)*'Calculated Data'!K25)/((1+'Calculated Data'!K25)*(1-'Calculated Data'!K22))","v":2.7166532309389459E-2}]
["Threshold Margin (Value Neutral Operating Margin)",null,{"$f":"(B4+(C32*(C3-B3)))/C3","v":5.3356129743968181E-2},{"$f":"(C4+(D32*(D3-C3)))/D3","v":9.2488816293395934E-2},0.11703742589634955,0.13427197491205897,0.14543516597495343,-8.4892798446137743E-2,8.951917945027825E-2,0.1020839353814814,8.28408223029313E-2,"higher capital intensity business demands higher threshold margin (to break even) than lower cap intensive"]
["Threshold Exceed Rate",null,{"$f":"C14-C33","v":3.4645349272485873E-2},{"$f":"D14-D33","v":-2.100968960324634E-4},-2.1918318783239438E-2,-2.2161532082472513E-3,-0.2971048065561413,0.19082436874346331,2.9650443463924883E-2,7.3815050808913318E-4,8.5737055800906181E-2]

{"sheet":"Buffet-Valuation","index":10,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[[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],[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],[19,0,19,1],[12,0,12,1],[26,0,26,1],[33,0,33,1],[0,0,0,1],[1,0,1,1],[1,3,1,12],[3,8,3,12],[4,8,4,12],[0,3,0,12],[2,7,2,12]]}
[{"$f":"'Data Sheet'!B1","v":"AXTEL INDUSTRIES 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":90.5},null,"Year","EPS","DPS",null,null,null,null,null,null,null,null,"Year","Sales"]
["EPS:",{"$f":"'Profit & Loss'!L13","v":7.6200752393980844},null,"Current",{"$f":"B4","v":7.6200752393980844},{"$f":"B5","v":1.4980067843613043},null,{"$f":"E14","v":70.967480907198834},"Earnings after 10 years",null,null,null,null,null,"Current",{"$f":"'Profit & Loss'!K4","v":110.75}]
["DPS:",{"$f":"'Profit & Loss'!K22","v":1.4980067843613043},null,"Year 1",{"$f":"E4*(1+$B$21)","v":9.5250940492476062},{"$f":"E5*$B$36","v":0.47625470246238033},null,{"$f":"SUM(F5:F14)","v":15.836851416950186},"Dividends paid over 10 years",null,null,null,null,null,"Year 1",{"$f":"P4*(1+$B$14)","v":138.4375}]
["BVPS:",{"$f":"'Balance Sheet'!K32","v":32.225716195805575},null,"Year 2",11.906367561559508,0.59531837807797539,null,null,null,null,null,null,null,null,"Year 2",173.046875]
["P/E:",{"$f":"B3/B4","v":11.876523151909018},null,"Year 3",14.882959451949384,0.74414797259746923,null,{"$f":"$B$33*H4","v":1064.5122136079824},"Projected price [Avg Sustainable P/E*EPS]",null,null,null,null,null,"Year 3",216.30859375]
["Earnings Yield:",{"$f":"B4/B3","v":8.4199726402188785E-2},null,"Year 4",18.60369931493673,0.93018496574683651,null,{"$f":"H7+H5","v":1080.3490650249325},"Total Gain [Projected Price+Dividends]",null,null,null,null,null,"Year 4",270.3857421875]
["Dividend Yield:",{"$f":"B5/B3","v":1.6552561153163583E-2},null,"Year 5",23.254624143670913,1.1627312071835456,null,null,null,null,null,null,null,null,"Year 5",337.982177734375]
["P/BV:",{"$f":"B3/B6","v":2.8083161736457938},null,"Year 6",29.068280179588641,1.4534140089794321,null,{"$f":"POWER(H8/$B$3,1/9)-1","v":0.31721685761409191},"Projected annual return using current EPS growth visibility",null,null,null,null,null,"Year 6",422.47772216796875]
[null,null,null,"Year 7",36.335350224485801,1.81676751122429,null,null,"[(Total Gain/Current Price)^1/9)-1]",null,null,null,null,null,"Year 7",528.09715270996094]
["Input Visibility data ","below",null,"Year 8",45.419187780607253,2.2709593890303625,null,null,null,null,null,null,null,null,"Year 8",660.12144088745117]
["Sales",null,null,"Year 9",56.773984725759064,2.8386992362879533,null,null,null,null,null,null,null,null,"Year 9",825.15180110931396]
["Med Term Visibility",0.25,null,"Year 10",70.967480907198834,3.5483740453599419,null,null,null,null,null,null,null,null,"Year 10",1031.4397513866425]
["Sales 10 Yr CAGR",{"$f":"POWER('Profit & Loss'!K4/'Profit & Loss'!B4, 1/9)-1","v":0.16955219208422889}]
["Sales 5yr CAGR",{"$f":"POWER('Profit & Loss'!K4/'Profit & Loss'!G4, 1/4)-1","v":0.29622787529391292},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.20628799705356493},null,"Year","BVPS","EPS","DPS"]
["Sales Y-o-Y growth",{"$f":"('Profit & Loss'!K4-'Profit & Loss'!J4)/'Profit & Loss'!J4","v":0.35889570552147237},null,"Current",{"$f":"B6","v":32.225716195805575},{"$f":"B4","v":7.6200752393980844},{"$f":"B5","v":1.4980067843613043},{"$f":"F28","v":56.835854385016688},"Earnings after 10 years"]
["Sales TTM Growth",{"$f":"('Profit & Loss'!L4-'Profit & Loss'!K4)/'Profit & Loss'!K4","v":-3.9819413092550889E-2},null,"Year 1",{"$f":"E18+F18-G18","v":38.347784650842357},{"$f":"E19*$B$37","v":9.107598854575059},{"$f":"F19*$B$36","v":0.45537994272875298},{"$f":"SUM(G19:G28)","v":13.418691451758678},"Dividends paid over 10 years"]
["EPS",null,null,"Year 2",{"$f":"E19+F19-G19","v":47.000003562688661},11.162500846138556,0.55812504230692783]
["Med Term Visibility",0.25,null,"Year 3",57.604379366520291,13.681040099548568,0.68405200497742846,{"$f":"$B$33*H18","v":852.53781577525035},"Projected price [Avg Sustainable P/E*EPS]"]
["EPS 10 Yr CAGR",{"$f":"POWER('Profit & Loss'!K13/'Profit & Loss'!B13, 1/9)-1","v":0.31985999636914486},null,"Year 4",70.601367461091428,16.767824772009213,0.83839123860046072,{"$f":"H21+H19","v":865.95650722700907},"Total Gain [Projected Price+Dividends]"]
["EPS 5yr CAGR",{"$f":"POWER('Profit & Loss'!K13/'Profit & Loss'!G13, 1/4)-1","v":{"$error":"#NUM!"}},null,"Year 5",86.530800994500183,20.551065236193793,1.0275532618096896]
["EPS 3yr CAGR",{"$f":"POWER('Profit & Loss'!K13/'Profit & Loss'!I13, 1/2)-1","v":0.3764944032233708},null,"Year 6",106.05431296888429,25.187899330110017,1.2593949665055009,{"$f":"POWER(H22/$B$3,1/9)-1","v":0.28523651442981768},"Projected annual return using sustainable growth visbility*"]
["EPS Y-o-Y growth",{"$f":"('Profit & Loss'!K13-'Profit & Loss'!J13)/'Profit & Loss'!J13","v":1.1854974704890389},null,"Year 7",{"$f":"E24+F24-G24","v":129.98281733248879},30.870919116466087,1.5435459558233044,null,"[(Total Gain/Current Price)^1/9)-1]"]
["EPS TTM Growth",{"$f":"('Profit & Loss'!L13-'Profit & Loss'!K13)/'Profit & Loss'!K13","v":-5.0148213908733259E-2},null,"Year 8",{"$f":"E25+F25-G25","v":159.31019049313159},37.836170242118747,1.8918085121059374]
["5Yr Averages",null,null,"Year 9",{"$f":"E26+F26-G26","v":195.2545522231444},46.372956152996792,2.3186478076498398]
["Return on Equity:",{"$f":"AVERAGE(Customization!G53:K53)","v":8.7755920558178935E-2},null,"Year 10",{"$f":"E27+F27-G27","v":239.30886056849133},56.835854385016688,2.8417927192508348]
["Payout Ratio:",{"$f":"AVERAGE('Profit & Loss'!G23:K23)","v":0.11896456602752274},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":25.471733558178755}]
["P/E Ratio-Low:",{"$f":"MIN('Calculated Data'!G38:K38)","v":-2.4425029177718836}]
["Avg. P/E Ratio:",{"$f":"AVERAGE('Calculated Data'!G38:K39)","v":7.5850921730182419}]
["Avg Sustainable P/E",15]
["RoE/Payout Visibility",null,"5 Yr Avg"]
["RoE Visibility",0.25,{"$f":"AVERAGE('Calculated Data'!G20:'Calculated Data'!K20)","v":8.7755920558178935E-2}]
["Payout Visbility",0.05,{"$f":"AVERAGE('Calculated Data'!G21:K21)","v":0.11896456602752274}]
["Sustainable Growth",{"$f":"B35*(1-B36)","v":0.23749999999999999},{"$f":"C35*(1-C36)","v":7.7316075552629426E-2}]

{"sheet":"Deep Dive","index":11,"n_rows":13,"n_cols":18,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
[{"$f":"'Data Sheet'!B1","v":"AXTEL INDUSTRIES LTD"}]
[null,null,null,null,"Key figures extracted/highlighted automatically from Excel for quick scan that helps tell a more complete story?"]
[null,null,null,null,"TTM Sales","TTM Net Profit","TTM EBIT","ROIC","Invested Cap","EPA /Sales","Mkt Cap","P/B","P/S","P/E","P/CFO","Div Yield","EV/EBITDA","Earnings Yield"]
[null,null,null,null,{"$f":"Annual[[#This Row],[Column12]]","v":106.33999999999999},{"$f":"'Calculated Data'!L7","v":12.309999999999999},{"$f":"'Calculated Data'!L4","v":17.660000000000004},{"$f":"'Calculated Data'!K24","v":0.3468613315031201},{"$f":"'Calculated Data'!K13","v":38.32},{"$f":"Customization!K42","v":7.8495044904736452E-2},{"$f":"'Calculated Data'!L33","v":146.19999999999999},{"$f":"Customization!H8","v":2.8082981175566655},{"$f":"Customization!J8","v":1.3748354335151403},{"$f":"Customization!G8","v":11.876523151909018},{"$f":"IF(Customization!L8>0,0)","v":0},{"$f":"Customization!K8","v":1.655266757865937E-2},{"$f":"Customization!I8","v":9.3349832324173256},{"$f":"1/N4","v":8.4199726402188785E-2}]
[null,null,null,"10Yr Incr FA Invest Rate","Dividend Payout","5yrAvg Sust. Growth","Retained Earnings / TA","RoE","WCap /TA","Total Asset Turns","Fixed Asset Turn","Cash Eqv","Invest ments","Net Profit","CFO","FCF/ Sales","Op Leverage"]
[null,null,null,{"$f":"'Price Implied Expectations'!K10","v":0.11350059737156513},{"$f":"'Calculated Data'!K21","v":0.18672839506172836},{"$f":"'Buffet-Valuation'!C37","v":7.7316075552629426E-2},{"$f":"'Calculated Data'!K46","v":0.12502965599051011},{"$f":"'Calculated Data'!K20","v":0.24894352669996164},{"$f":"'Calculated Data'!K45","v":0.26429418742586003},{"$f":"Customization!K51","v":1.3137603795966786},{"$f":"Customization!K50","v":6.9917929292929291},{"$f":"'Balance Sheet'!K34","v":5.5},{"$f":"'Balance Sheet'!K12","v":14.9},{"$f":"'Calculated Data'!K7","v":12.96},{"$f":"'Cash Flow'!K4","v":9.15},{"$f":"'Calculated Data'!K19/'Profit & Loss'!K4","v":6.7358916478555297E-2},{"$f":"'Calculated Data'!K30","v":3.421394039532466}]
[null,null,null,"10Yr Incr Wcap Invest Rate","Industry FA Turns","Industry WCap /TA","Industry RE /TA","Industry RoE","5YrAvg WCap /TA","5YrAvg TA Turns","5YrAvg FA Turns","Steady State Value","Future Earnings Value","SState Value/ Mcap","Future Value /Mcap"]
[null,null,null,{"$f":"'Price Implied Expectations'!K16","v":0.13835125448028679},null,null,null,null,{"$f":"AVERAGE('Calculated Data'!G45:K45)","v":0.27598945570776501},{"$f":"AVERAGE(Customization!G51:K51)","v":1.0228023327795115},{"$f":"AVERAGE(Customization!G50:K50)","v":4.3545285777477334},{"$f":"'Price Implied Expectations'!B37","v":232.54632182991222},0,{"$f":"L8/'Data Sheet'!B9","v":1.5906041164836677},{"$f":"1-N8","v":-0.59060411648366773}]
[null,"FY 2010","FY 2011","FY2012","FY 2013","FY 2014","FY 2015","FY 2016","FY 2017","FY 2018","FY 2019"]
["RoE",{"$f":"'Calculated Data'!B20","v":4.1719342604298368E-2},{"$f":"'Calculated Data'!C20","v":0.13304013194062672},{"$f":"'Calculated Data'!D20","v":0.14265470004723665},{"$f":"'Calculated Data'!E20","v":0.13790289677682577},{"$f":"'Calculated Data'!F20","v":0.10132158590308371},{"$f":"'Calculated Data'!G20","v":-0.29202168861347794},{"$f":"'Calculated Data'!H20","v":0.15841584158415842},{"$f":"'Calculated Data'!I20","v":0.18556701030927833},{"$f":"'Calculated Data'!J20","v":0.13787491281097419},{"$f":"'Calculated Data'!K20","v":0.24894352669996164}]
["CC Cycle",{"$f":"Customization!B30","v":86.763401109057298},{"$f":"Customization!C30","v":161.88482159364025},{"$f":"Customization!D30","v":105.10700222564631},{"$f":"Customization!E30","v":34.232050641345992},{"$f":"Customization!F30","v":-68.727348469068914},{"$f":"Customization!G30","v":-64.849604894213655},{"$f":"Customization!H30","v":34.302256088450633},{"$f":"Customization!I30","v":54.622914203127053},{"$f":"Customization!J30","v":11.644171779141146},{"$f":"Customization!K30","v":-11.304288939051929}]
["Gr Margin",{"$f":"Customization!B35","v":0.24990757855822557},{"$f":"Customization!C35","v":0.32298021815492706},{"$f":"Customization!D35","v":0.36808765622324946},{"$f":"Customization!E35","v":0.48758953856405129},{"$f":"Customization!F35","v":0.5061445532180795},{"$f":"Customization!G35","v":0.31735916390517455},{"$f":"Customization!H35","v":0.57149260421335724},{"$f":"Customization!I35","v":0.56037314413349093},{"$f":"Customization!J35","v":0.47496932515337426},{"$f":"Customization!K35","v":0.50076749435665913}]
["Eq Dilution",{"$f":"'Cost Analysis'!B41","v":0},{"$f":"'Cost Analysis'!C41","v":0},{"$f":"'Cost Analysis'!D41","v":0},{"$f":"'Cost Analysis'!E41","v":0},{"$f":"'Cost Analysis'!F41","v":0},{"$f":"'Cost Analysis'!G41","v":0.61499999999999988},{"$f":"'Cost Analysis'!H41","v":0},{"$f":"'Cost Analysis'!I41","v":0},{"$f":"'Cost Analysis'!J41","v":0},{"$f":"'Cost Analysis'!K41","v":0}]

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