{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Profit & Loss","Quarters","Balance Sheet","Cash Flow","Customization","Data Sheet","Calculated Data","Cost Analysis","Price Implied Expectations","Business Robustness","Buffet-Valuation","Deep Dive"],"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":"SHIVALIK BIMETAL CONTROLS LTD"},null,null,null,null,null,null,{"$f":"UPDATE","v":""},null,null,null,null,"SCREENER.IN"]
[]
["Narration",{"$f":"'Data Sheet'!B16","v":"2014-03-31"},{"$f":"'Data Sheet'!C16","v":"2015-03-31"},{"$f":"'Data Sheet'!D16","v":"2016-03-31"},{"$f":"'Data Sheet'!E16","v":"2017-03-31"},{"$f":"'Data Sheet'!F16","v":"2018-03-31"},{"$f":"'Data Sheet'!G16","v":"2019-03-31"},{"$f":"'Data Sheet'!H16","v":"2020-03-31"},{"$f":"'Data Sheet'!I16","v":"2021-03-31"},{"$f":"'Data Sheet'!J16","v":"2022-03-31"},{"$f":"'Data Sheet'!K16","v":"2023-03-31"},"Trailing","Best Case","Worst Case"]
["Sales",{"$f":"'Data Sheet'!B17","v":80.7},{"$f":"'Data Sheet'!C17","v":95.22},{"$f":"'Data Sheet'!D17","v":98.85},{"$f":"'Data Sheet'!E17","v":118.66},{"$f":"'Data Sheet'!F17","v":157.86000000000001},{"$f":"'Data Sheet'!G17","v":193.39},{"$f":"'Data Sheet'!H17","v":187.22},{"$f":"'Data Sheet'!I17","v":203.72},{"$f":"'Data Sheet'!J17","v":323.99},{"$f":"'Data Sheet'!K17","v":420.23},{"$f":"SUM(Quarters!H4:K4)","v":435.61},{"$f":"$K4+M27*K4","v":550.21444850236719},{"$f":"$K4+N27*L4","v":507.88485364773186}]
["Expenses",{"$f":"SUM('Data Sheet'!B18,'Data Sheet'!B20:B24, -1*'Data Sheet'!B19)","v":69.7},{"$f":"SUM('Data Sheet'!C18,'Data Sheet'!C20:C24, -1*'Data Sheet'!C19)","v":79.87},{"$f":"SUM('Data Sheet'!D18,'Data Sheet'!D20:D24, -1*'Data Sheet'!D19)","v":85.33},{"$f":"SUM('Data Sheet'!E18,'Data Sheet'!E20:E24, -1*'Data Sheet'!E19)","v":99.679999999999978},{"$f":"SUM('Data Sheet'!F18,'Data Sheet'!F20:F24, -1*'Data Sheet'!F19)","v":132.22},{"$f":"SUM('Data Sheet'!G18,'Data Sheet'!G20:G24, -1*'Data Sheet'!G19)","v":157.81},{"$f":"SUM('Data Sheet'!H18,'Data Sheet'!H20:H24, -1*'Data Sheet'!H19)","v":166.45},{"$f":"SUM('Data Sheet'!I18,'Data Sheet'!I20:I24, -1*'Data Sheet'!I19)","v":167.59000000000003},{"$f":"SUM('Data Sheet'!J18,'Data Sheet'!J20:J24, -1*'Data Sheet'!J19)","v":250.51999999999998},{"$f":"SUM('Data Sheet'!K18,'Data Sheet'!K20:K24, -1*'Data Sheet'!K19)","v":315.46000000000004},{"$f":"SUM(Quarters!H5:K5)","v":326.08999999999997},{"$f":"M4-M6","v":411.88087856600384},411.91616542734562]
["Operating Profit",{"$f":"B4-B5","v":11},{"$f":"C4-C5","v":15.349999999999994},13.519999999999996,18.980000000000018,25.640000000000015,35.579999999999984,20.77000000000001,36.129999999999967,73.470000000000027,104.76999999999998,{"$f":"SUM(Quarters!H6:K6)","v":109.52},{"$f":"M4*M28","v":138.33356993636338},{"$f":"N4*N28","v":95.968688220386241}]
["Other Income",{"$f":"'Data Sheet'!B25","v":-1.35},{"$f":"'Data Sheet'!C25","v":-0.55000000000000004},{"$f":"'Data Sheet'!D25","v":0.56999999999999995},{"$f":"'Data Sheet'!E25","v":2.04},{"$f":"'Data Sheet'!F25","v":4.1500000000000004},{"$f":"'Data Sheet'!G25","v":5.35},{"$f":"'Data Sheet'!H25","v":4.6500000000000004},{"$f":"'Data Sheet'!I25","v":4.05},{"$f":"'Data Sheet'!J25","v":5.45},{"$f":"'Data Sheet'!K25","v":7.93},{"$f":"SUM(Quarters!H7:K7)","v":7.03},0,0]
["Depreciation",{"$f":"'Data Sheet'!B26","v":2.35},{"$f":"'Data Sheet'!C26","v":3.17},{"$f":"'Data Sheet'!D26","v":3.69},{"$f":"'Data Sheet'!E26","v":4.54},{"$f":"'Data Sheet'!F26","v":4.62},{"$f":"'Data Sheet'!G26","v":4.8499999999999996},{"$f":"'Data Sheet'!H26","v":6.01},{"$f":"'Data Sheet'!I26","v":5.9},{"$f":"'Data Sheet'!J26","v":6.38},{"$f":"'Data Sheet'!K26","v":8.4700000000000006},{"$f":"SUM(Quarters!H8:K8)","v":8.9700000000000006},{"$f":"+$L8","v":8.9700000000000006},{"$f":"+$L8","v":8.9700000000000006}]
["Interest",{"$f":"'Data Sheet'!B27","v":3.17},{"$f":"'Data Sheet'!C27","v":3.2},{"$f":"'Data Sheet'!D27","v":3.9},{"$f":"'Data Sheet'!E27","v":2.54},{"$f":"'Data Sheet'!F27","v":3.31},{"$f":"'Data Sheet'!G27","v":3.58},{"$f":"'Data Sheet'!H27","v":2.94},{"$f":"'Data Sheet'!I27","v":1.63},{"$f":"'Data Sheet'!J27","v":2.76},{"$f":"'Data Sheet'!K27","v":6.64},{"$f":"SUM(Quarters!H9:K9)","v":6.25},{"$f":"+$L9","v":6.25},{"$f":"+$L9","v":6.25}]
["Profit before tax",{"$f":"'Data Sheet'!B28","v":4.13},{"$f":"'Data Sheet'!C28","v":8.43},{"$f":"'Data Sheet'!D28","v":6.5},{"$f":"'Data Sheet'!E28","v":13.94},{"$f":"'Data Sheet'!F28","v":21.86},{"$f":"'Data Sheet'!G28","v":32.5},{"$f":"'Data Sheet'!H28","v":16.47},{"$f":"'Data Sheet'!I28","v":32.65},{"$f":"'Data Sheet'!J28","v":69.78},{"$f":"'Data Sheet'!K28","v":97.59},{"$f":"SUM(Quarters!H10:K10)","v":101.33},{"$f":"M6+M7-SUM(M8:M9)","v":123.11356993636338},{"$f":"N6+N7-SUM(N8:N9)","v":80.748688220386242}]
["Tax",{"$f":"'Data Sheet'!B29","v":0.61},{"$f":"'Data Sheet'!C29","v":3.49},{"$f":"'Data Sheet'!D29","v":2.38},{"$f":"'Data Sheet'!E29","v":5.33},{"$f":"'Data Sheet'!F29","v":5.87},{"$f":"'Data Sheet'!G29","v":9.42},{"$f":"'Data Sheet'!H29","v":3.71},{"$f":"'Data Sheet'!I29","v":8.5},{"$f":"'Data Sheet'!J29","v":17.809999999999999},{"$f":"'Data Sheet'!K29","v":24.56},{"$f":"SUM(Quarters!H11:K11)","v":25.2},{"$f":"IF($L10>0,$L11/$L10,0)","v":0.24869239119707884},{"$f":"IF($L10>0,$L11/$L10,0)","v":0.24869239119707884}]
["Net profit",{"$f":"'Data Sheet'!B30","v":3.53},{"$f":"'Data Sheet'!C30","v":4.9400000000000004},{"$f":"'Data Sheet'!D30","v":4.1100000000000003},{"$f":"'Data Sheet'!E30","v":8.6199999999999992},{"$f":"'Data Sheet'!F30","v":15.99},{"$f":"'Data Sheet'!G30","v":23.08},{"$f":"'Data Sheet'!H30","v":12.76},{"$f":"'Data Sheet'!I30","v":24.15},{"$f":"'Data Sheet'!J30","v":51.98},{"$f":"'Data Sheet'!K30","v":73.03},{"$f":"SUM(Quarters!H12:K12)","v":76.14},{"$f":"M10-M11*M10","v":92.496161840080376},{"$f":"N10-N11*N10","v":60.667103860830991}]
["EPS",{"$f":"IF('Data Sheet'!B93>0,B12/'Data Sheet'!B93,0)","v":0.61284722222222221},{"$f":"IF('Data Sheet'!C93>0,C12/'Data Sheet'!C93,0)","v":0.85763888888888895},{"$f":"IF('Data Sheet'!D93>0,D12/'Data Sheet'!D93,0)","v":0.71354166666666674},{"$f":"IF('Data Sheet'!E93>0,E12/'Data Sheet'!E93,0)","v":1.4965277777777777},{"$f":"IF('Data Sheet'!F93>0,F12/'Data Sheet'!F93,0)","v":2.776041666666667},{"$f":"IF('Data Sheet'!G93>0,G12/'Data Sheet'!G93,0)","v":4.0069444444444446},{"$f":"IF('Data Sheet'!H93>0,H12/'Data Sheet'!H93,0)","v":2.2152777777777777},{"$f":"IF('Data Sheet'!I93>0,I12/'Data Sheet'!I93,0)","v":4.192708333333333},{"$f":"IF('Data Sheet'!J93>0,J12/'Data Sheet'!J93,0)","v":9.0243055555555554},{"$f":"IF('Data Sheet'!K93>0,K12/'Data Sheet'!K93,0)","v":12.678819444444445},{"$f":"IF('Data Sheet'!$B6>0,'Profit & Loss'!L12/'Data Sheet'!$B6,0)","v":13.217784337147201},{"$f":"IF('Data Sheet'!$B6>0,'Profit & Loss'!M12/'Data Sheet'!$B6,0)","v":16.05718832697724},{"$f":"IF('Data Sheet'!$B6>0,'Profit & Loss'!N12/'Data Sheet'!$B6,0)","v":10.531713884840746}]
["Price to earning",{"$f":"IF(B15>0,B15/B13,\"\")","v":4.4872521246458925},{"$f":"IF(C15>0,C15/C13,\"\")","v":11.333441295546558},9.5859854014598529,14.146078886310907,27.063714821763597,23.010051993067592,6.4416300940438873,13.547329192546584,37.94197768372451,40.496672600301252,{"$f":"IF(L13>0,L15/L13,0)","v":39.912135539795109},{"$f":"M29","v":39.912135539795109},{"$f":"N29","v":20.72420633029143}]
["Price",{"$f":"'Data Sheet'!B90","v":2.75},{"$f":"'Data Sheet'!C90","v":9.7200000000000006},{"$f":"'Data Sheet'!D90","v":6.84},{"$f":"'Data Sheet'!E90","v":21.17},{"$f":"'Data Sheet'!F90","v":75.13},{"$f":"'Data Sheet'!G90","v":92.2},{"$f":"'Data Sheet'!H90","v":14.27},{"$f":"'Data Sheet'!I90","v":56.8},{"$f":"'Data Sheet'!J90","v":342.4},{"$f":"'Data Sheet'!K90","v":513.45000000000005},{"$f":"'Data Sheet'!B8","v":527.54999999999995},{"$f":"M13*M14","v":640.87667689433147},{"$f":"N13*N14","v":218.26141156103475}]
[]
["EBIT",{"$f":"B10+B9","v":7.3},{"$f":"C10+C9","v":11.629999999999999},10.4,16.48,25.169999999999998,36.08,19.41,34.28,72.540000000000006,104.23,107.58]
["EBITDA",{"$f":"B17+B8","v":9.65},{"$f":"C17+C8","v":14.799999999999999},14.09,21.02,29.79,40.93,25.42,40.18,78.92,112.7,116.55]
["Operating Profit (excl Other Income)",{"$f":"B18-B7","v":11},{"$f":"C18-C7","v":15.35},13.52,18.98,25.64,35.58,20.770000000000003,36.130000000000003,73.47,104.77000000000001,109.52]
[]
["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.16666666666666666},{"$f":"IF('Data Sheet'!F93>0,'Data Sheet'!F31/'Data Sheet'!F93,0)","v":0.39930555555555552},{"$f":"IF('Data Sheet'!G93>0,'Data Sheet'!G31/'Data Sheet'!G93,0)","v":0.39930555555555552},{"$f":"IF('Data Sheet'!H93>0,'Data Sheet'!H31/'Data Sheet'!H93,0)","v":0.19965277777777776},{"$f":"IF('Data Sheet'!I93>0,'Data Sheet'!I31/'Data Sheet'!I93,0)","v":0.39930555555555552},{"$f":"IF('Data Sheet'!J93>0,'Data Sheet'!J31/'Data Sheet'!J93,0)","v":0.66666666666666663},{"$f":"IF('Data Sheet'!K93>0,'Data Sheet'!K31/'Data Sheet'!K93,0)","v":1.1996527777777779}]
["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.11136890951276103},{"$f":"IF('Data Sheet'!F30>0, 'Data Sheet'!F31/'Data Sheet'!F30, 0)","v":0.14383989993746091},{"$f":"IF('Data Sheet'!G30>0, 'Data Sheet'!G31/'Data Sheet'!G30, 0)","v":9.965337954939342E-2},{"$f":"IF('Data Sheet'!H30>0, 'Data Sheet'!H31/'Data Sheet'!H30, 0)","v":9.0125391849529779E-2},{"$f":"IF('Data Sheet'!I30>0, 'Data Sheet'!I31/'Data Sheet'!I30, 0)","v":9.5238095238095233E-2},{"$f":"IF('Data Sheet'!J30>0, 'Data Sheet'!J31/'Data Sheet'!J30, 0)","v":7.3874567141208158E-2},{"$f":"IF('Data Sheet'!K30>0, 'Data Sheet'!K31/'Data Sheet'!K30, 0)","v":9.4618649869916471E-2}]
["OPM",{"$f":"IF(B6>0,B6/B4,0)","v":0.13630731102850061},{"$f":"IF(C6>0,C6/C4,0)","v":0.16120562906952315},0.13677288821446634,0.15995280633743483,0.16242239959457755,0.18398055742282426,0.11093900224335013,0.17735126644413884,0.22676625821784629,0.2493158508435856,0.25141755239778701]
[]
[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.20122323557248878},{"$f":"IF(D4=0,\"\",POWER($K4/D4,1/7)-1)","v":0.22966609069002364},{"$f":"IF(F4=0,\"\",POWER($K4/F4,1/5)-1)","v":0.21630639725490375},{"$f":"IF(H4=0,\"\",POWER($K4/H4, 1/3)-1)","v":0.30931739405175063},{"$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.29704620512978797},{"$f":"MAX(K27:L27)","v":0.30931739405175063},{"$f":"MIN(H27:L27)","v":0.20122323557248878}]
[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.18895757085709425},{"$f":"IF(SUM(E4:$K$4)=0,\"\",SUMPRODUCT(E24:$K$24,E4:$K$4)/SUM(E4:$K$4))","v":0.19646495168435021},{"$f":"IF(SUM(G4:$K$4)=0,\"\",SUMPRODUCT(G24:$K$24,G4:$K$4)/SUM(G4:$K$4))","v":0.20377102856497681},{"$f":"IF(SUM(I4:$K$4)=0, \"\", SUMPRODUCT(I24:$K$24,I4:$K$4)/SUM(I4:$K$4))","v":0.22614300483152938},{"$f":"L24","v":0.25141755239778701},{"$f":"MAX(K28:L28)","v":0.25141755239778701},{"$f":"MIN(H28:L28)","v":0.18895757085709425}]
[null,null,null,null,null,null,"Price to Earning",{"$f":"IF(ISERROR(AVERAGEIF(B14:$L14,\">0\")),\"\",AVERAGEIF(B14:$L14,\">0\"))","v":20.72420633029143},{"$f":"IF(ISERROR(AVERAGEIF(E14:$L14,\">0\")),\"\",AVERAGEIF(E14:$L14,\">0\"))","v":25.319948851444181},{"$f":"IF(ISERROR(AVERAGEIF(G14:$L14,\">0\")),\"\",AVERAGEIF(G14:$L14,\">0\"))","v":26.891632850579825},{"$f":"IF(ISERROR(AVERAGEIF(I14:$L14,\">0\")),\"\",AVERAGEIF(I14:$L14,\">0\"))","v":32.974528754091864},{"$f":"L14","v":39.912135539795109},{"$f":"MAX(K29:L29)","v":39.912135539795109},{"$f":"MIN(H29:L29)","v":20.72420633029143}]

{"sheet":"Quarters","index":1,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Profit & Loss'!A1","v":"SHIVALIK BIMETAL CONTROLS LTD"},null,null,null,{"$f":"UPDATE","v":""},null,null,null,null,"SCREENER.IN"]
[]
["Narration",{"$f":"'Data Sheet'!B41","v":"2021-03-31"},{"$f":"'Data Sheet'!C41","v":"2021-06-30"},{"$f":"'Data Sheet'!D41","v":"2021-09-30"},{"$f":"'Data Sheet'!E41","v":"2021-12-31"},{"$f":"'Data Sheet'!F41","v":"2022-03-31"},{"$f":"'Data Sheet'!G41","v":"2022-06-30"},{"$f":"'Data Sheet'!H41","v":"2022-09-30"},{"$f":"'Data Sheet'!I41","v":"2022-12-31"},{"$f":"'Data Sheet'!J41","v":"2023-03-31"},{"$f":"'Data Sheet'!K41","v":"2023-06-30"}]
["Sales",{"$f":"'Data Sheet'!B42","v":66.86},{"$f":"'Data Sheet'!C42","v":70.31},{"$f":"'Data Sheet'!D42","v":76.23},{"$f":"'Data Sheet'!E42","v":88.13},{"$f":"'Data Sheet'!F42","v":89.32},{"$f":"'Data Sheet'!G42","v":97.69},{"$f":"'Data Sheet'!H42","v":104.87},{"$f":"'Data Sheet'!I42","v":107.54},{"$f":"'Data Sheet'!J42","v":110.13},{"$f":"'Data Sheet'!K42","v":113.07}]
["Expenses",{"$f":"'Data Sheet'!B43","v":54.2},{"$f":"'Data Sheet'!C43","v":54.45},{"$f":"'Data Sheet'!D43","v":58.4},{"$f":"'Data Sheet'!E43","v":67.569999999999993},{"$f":"'Data Sheet'!F43","v":70.09},{"$f":"'Data Sheet'!G43","v":73.44},{"$f":"'Data Sheet'!H43","v":79.16},{"$f":"'Data Sheet'!I43","v":79.75},{"$f":"'Data Sheet'!J43","v":83.11},{"$f":"'Data Sheet'!K43","v":84.07}]
["Operating Profit",{"$f":"'Data Sheet'!B50","v":12.66},{"$f":"'Data Sheet'!C50","v":15.86},{"$f":"'Data Sheet'!D50","v":17.829999999999998},{"$f":"'Data Sheet'!E50","v":20.56},{"$f":"'Data Sheet'!F50","v":19.23},{"$f":"'Data Sheet'!G50","v":24.25},{"$f":"'Data Sheet'!H50","v":25.71},{"$f":"'Data Sheet'!I50","v":27.79},{"$f":"'Data Sheet'!J50","v":27.02},{"$f":"'Data Sheet'!K50","v":29}]
["Other Income",{"$f":"'Data Sheet'!B44","v":1.1599999999999999},{"$f":"'Data Sheet'!C44","v":0.85},{"$f":"'Data Sheet'!D44","v":1.22},{"$f":"'Data Sheet'!E44","v":1.85},{"$f":"'Data Sheet'!F44","v":1.53},{"$f":"'Data Sheet'!G44","v":2.2400000000000002},{"$f":"'Data Sheet'!H44","v":3.37},{"$f":"'Data Sheet'!I44","v":0.7},{"$f":"'Data Sheet'!J44","v":1.62},{"$f":"'Data Sheet'!K44","v":1.34}]
["Depreciation",{"$f":"'Data Sheet'!B45","v":1.56},{"$f":"'Data Sheet'!C45","v":1.42},{"$f":"'Data Sheet'!D45","v":1.49},{"$f":"'Data Sheet'!E45","v":1.6},{"$f":"'Data Sheet'!F45","v":1.86},{"$f":"'Data Sheet'!G45","v":1.95},{"$f":"'Data Sheet'!H45","v":2.0699999999999998},{"$f":"'Data Sheet'!I45","v":2.2200000000000002},{"$f":"'Data Sheet'!J45","v":2.2400000000000002},{"$f":"'Data Sheet'!K45","v":2.44}]
["Interest",{"$f":"'Data Sheet'!B46","v":0.49},{"$f":"'Data Sheet'!C46","v":0.44},{"$f":"'Data Sheet'!D46","v":0.37},{"$f":"'Data Sheet'!E46","v":0.76},{"$f":"'Data Sheet'!F46","v":1.2},{"$f":"'Data Sheet'!G46","v":1.52},{"$f":"'Data Sheet'!H46","v":1.72},{"$f":"'Data Sheet'!I46","v":1.81},{"$f":"'Data Sheet'!J46","v":1.59},{"$f":"'Data Sheet'!K46","v":1.1299999999999999}]
["Profit before tax",{"$f":"'Data Sheet'!B47","v":11.77},{"$f":"'Data Sheet'!C47","v":14.85},{"$f":"'Data Sheet'!D47","v":17.190000000000001},{"$f":"'Data Sheet'!E47","v":20.05},{"$f":"'Data Sheet'!F47","v":17.7},{"$f":"'Data Sheet'!G47","v":23.02},{"$f":"'Data Sheet'!H47","v":25.29},{"$f":"'Data Sheet'!I47","v":24.46},{"$f":"'Data Sheet'!J47","v":24.81},{"$f":"'Data Sheet'!K47","v":26.77}]
["Tax",{"$f":"'Data Sheet'!B48","v":3.2},{"$f":"'Data Sheet'!C48","v":3.66},{"$f":"'Data Sheet'!D48","v":4.37},{"$f":"'Data Sheet'!E48","v":5.36},{"$f":"'Data Sheet'!F48","v":4.43},{"$f":"'Data Sheet'!G48","v":5.9},{"$f":"'Data Sheet'!H48","v":6.53},{"$f":"'Data Sheet'!I48","v":6.22},{"$f":"'Data Sheet'!J48","v":5.91},{"$f":"'Data Sheet'!K48","v":6.54}]
["Net profit",{"$f":"'Data Sheet'!B49","v":8.57},{"$f":"'Data Sheet'!C49","v":11.18},{"$f":"'Data Sheet'!D49","v":12.83},{"$f":"'Data Sheet'!E49","v":14.7},{"$f":"'Data Sheet'!F49","v":13.27},{"$f":"'Data Sheet'!G49","v":17.11},{"$f":"'Data Sheet'!H49","v":18.760000000000002},{"$f":"'Data Sheet'!I49","v":18.25},{"$f":"'Data Sheet'!J49","v":18.899999999999999},{"$f":"'Data Sheet'!K49","v":20.23}]
[]
["OPM",{"$f":"IF(B4>0,B6/B4,\"\")","v":0.18935088244092133},{"$f":"IF(C4>0,C6/C4,\"\")","v":0.22557246479874837},0.2338974157155975,0.23329172812890048,0.2152933273622929,0.24823421025693521,0.2451606751215791,0.25841547331225589,0.24534640878961228,0.25647828778632709]
[]
["EBIT",{"$f":"B10+B9","v":12.26},{"$f":"C10+C9","v":15.29},17.560000000000002,20.810000000000002,18.899999999999999,24.54,27.009999999999998,26.27,26.4,27.9]
["EBITDA",{"$f":"B16+B8","v":13.82},{"$f":"C16+C8","v":16.71},19.05,22.410000000000004,20.759999999999998,26.49,29.08,28.49,28.64,30.34]

{"sheet":"Balance Sheet","index":2,"n_rows":44,"n_cols":14,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Profit & Loss'!A1","v":"SHIVALIK BIMETAL CONTROLS LTD"},null,null,null,{"$f":"UPDATE","v":""},null,null,null,null,"SCREENER.IN"]
[]
["Narration",{"$f":"'Data Sheet'!B56","v":"2014-03-31"},{"$f":"'Data Sheet'!C56","v":"2015-03-31"},{"$f":"'Data Sheet'!D56","v":"2016-03-31"},{"$f":"'Data Sheet'!E56","v":"2017-03-31"},{"$f":"'Data Sheet'!F56","v":"2018-03-31"},{"$f":"'Data Sheet'!G56","v":"2019-03-31"},{"$f":"'Data Sheet'!H56","v":"2020-03-31"},{"$f":"'Data Sheet'!I56","v":"2021-03-31"},{"$f":"'Data Sheet'!J56","v":"2022-03-31"},{"$f":"'Data Sheet'!K56","v":"2023-03-31"},"2HFY20","Input data from 2QFY BS"]
["Equity Share Capital",{"$f":"'Data Sheet'!B57","v":3.84},{"$f":"'Data Sheet'!C57","v":3.84},{"$f":"'Data Sheet'!D57","v":3.84},{"$f":"'Data Sheet'!E57","v":3.84},{"$f":"'Data Sheet'!F57","v":7.68},{"$f":"'Data Sheet'!G57","v":7.68},{"$f":"'Data Sheet'!H57","v":7.68},{"$f":"'Data Sheet'!I57","v":7.68},{"$f":"'Data Sheet'!J57","v":7.68},{"$f":"'Data Sheet'!K57","v":11.52}]
["Reserves",{"$f":"'Data Sheet'!B58","v":52.36},{"$f":"'Data Sheet'!C58","v":57.04},{"$f":"'Data Sheet'!D58","v":61.15},{"$f":"'Data Sheet'!E58","v":67.400000000000006},{"$f":"'Data Sheet'!F58","v":77.59},{"$f":"'Data Sheet'!G58","v":97.86},{"$f":"'Data Sheet'!H58","v":107.64},{"$f":"'Data Sheet'!I58","v":130.55000000000001},{"$f":"'Data Sheet'!J58","v":179.5},{"$f":"'Data Sheet'!K58","v":243.49}]
["Borrowings",{"$f":"'Data Sheet'!B59","v":38.68},{"$f":"'Data Sheet'!C59","v":44.06},{"$f":"'Data Sheet'!D59","v":42.48},{"$f":"'Data Sheet'!E59","v":28.64},{"$f":"'Data Sheet'!F59","v":35.89},{"$f":"'Data Sheet'!G59","v":44.77},{"$f":"'Data Sheet'!H59","v":24.85},{"$f":"'Data Sheet'!I59","v":29.24},{"$f":"'Data Sheet'!J59","v":57.94},{"$f":"'Data Sheet'!K59","v":52.65},{"$f":"L8-(L7+L5+L4)","v":0}]
["Other Liabilities",{"$f":"'Data Sheet'!B60","v":18.57},{"$f":"'Data Sheet'!C60","v":22.18},{"$f":"'Data Sheet'!D60","v":19.13},{"$f":"'Data Sheet'!E60","v":17.95},{"$f":"'Data Sheet'!F60","v":27.29},{"$f":"'Data Sheet'!G60","v":25.76},{"$f":"'Data Sheet'!H60","v":21.42},{"$f":"'Data Sheet'!I60","v":50.68},{"$f":"'Data Sheet'!J60","v":56.44},{"$f":"'Data Sheet'!K60","v":54.03},null,"def tax liab+oth long term liab+other current liab"]
["Total",{"$f":"'Data Sheet'!B61","v":113.45},{"$f":"'Data Sheet'!C61","v":127.12},{"$f":"'Data Sheet'!D61","v":126.6},{"$f":"'Data Sheet'!E61","v":117.83},{"$f":"'Data Sheet'!F61","v":148.44999999999999},{"$f":"'Data Sheet'!G61","v":176.07},{"$f":"'Data Sheet'!H61","v":161.59},{"$f":"'Data Sheet'!I61","v":218.15},{"$f":"'Data Sheet'!J61","v":301.56},{"$f":"'Data Sheet'!K61","v":361.69}]
[]
["Net Block",{"$f":"'Data Sheet'!B62","v":20.079999999999998},{"$f":"'Data Sheet'!C62","v":34.74},{"$f":"'Data Sheet'!D62","v":32.700000000000003},{"$f":"'Data Sheet'!E62","v":43.1},{"$f":"'Data Sheet'!F62","v":45.2},{"$f":"'Data Sheet'!G62","v":45.3},{"$f":"'Data Sheet'!H62","v":45.41},{"$f":"'Data Sheet'!I62","v":45.64},{"$f":"'Data Sheet'!J62","v":78.97},{"$f":"'Data Sheet'!K62","v":102.11},54.36]
["Capital Work in Progress",{"$f":"'Data Sheet'!B63","v":17.850000000000001},{"$f":"'Data Sheet'!C63","v":3.97},{"$f":"'Data Sheet'!D63","v":4.24},{"$f":"'Data Sheet'!E63","v":4.47},{"$f":"'Data Sheet'!F63","v":4.72},{"$f":"'Data Sheet'!G63","v":5.99},{"$f":"'Data Sheet'!H63","v":17.54},{"$f":"'Data Sheet'!I63","v":24.79},{"$f":"'Data Sheet'!J63","v":7.55},{"$f":"'Data Sheet'!K63","v":2.99},19.190000000000001]
["Investments",{"$f":"'Data Sheet'!B64","v":17.53},{"$f":"'Data Sheet'!C64","v":17.75},{"$f":"'Data Sheet'!D64","v":17.88},{"$f":"'Data Sheet'!E64","v":9.31},{"$f":"'Data Sheet'!F64","v":9.31},{"$f":"'Data Sheet'!G64","v":10.27},{"$f":"'Data Sheet'!H64","v":10.28},{"$f":"'Data Sheet'!I64","v":10.29},{"$f":"'Data Sheet'!J64","v":10.29},{"$f":"'Data Sheet'!K64","v":23.59}]
["Other Assets",{"$f":"'Data Sheet'!B65","v":57.99},{"$f":"'Data Sheet'!C65","v":70.66},{"$f":"'Data Sheet'!D65","v":71.78},{"$f":"'Data Sheet'!E65","v":60.95},{"$f":"'Data Sheet'!F65","v":89.22},{"$f":"'Data Sheet'!G65","v":114.51},{"$f":"'Data Sheet'!H65","v":88.36},{"$f":"'Data Sheet'!I65","v":137.43},{"$f":"'Data Sheet'!J65","v":204.75},{"$f":"'Data Sheet'!K65","v":233},null,"total current assets+long term loans and advances+other non current assets"]
["Total",{"$f":"'Data Sheet'!B66","v":113.45},{"$f":"'Data Sheet'!C66","v":127.12},{"$f":"'Data Sheet'!D66","v":126.6},{"$f":"'Data Sheet'!E66","v":117.83},{"$f":"'Data Sheet'!F66","v":148.44999999999999},{"$f":"'Data Sheet'!G66","v":176.07},{"$f":"'Data Sheet'!H66","v":161.59},{"$f":"'Data Sheet'!I66","v":218.15},{"$f":"'Data Sheet'!J66","v":301.56},{"$f":"'Data Sheet'!K66","v":361.69},{"$f":"L8","v":0},{"$f":"#REF!+L11+L12+L13","v":{"$error":"#REF!"}},"check TA matching"]
[]
["Working Capital",{"$f":"B13-B7","v":39.42},48.48,52.650000000000006,43,61.93,88.75,66.94,86.75,148.31,178.97,{"$f":"L13-L7","v":0}]
["Debtors",{"$f":"'Data Sheet'!B67","v":21.74},{"$f":"'Data Sheet'!C67","v":24.08},{"$f":"'Data Sheet'!D67","v":24.08},{"$f":"'Data Sheet'!E67","v":26.42},{"$f":"'Data Sheet'!F67","v":33.590000000000003},{"$f":"'Data Sheet'!G67","v":34.58},{"$f":"'Data Sheet'!H67","v":30.95},{"$f":"'Data Sheet'!I67","v":42.82},{"$f":"'Data Sheet'!J67","v":59.28},{"$f":"'Data Sheet'!K67","v":79.98}]
["Inventory",{"$f":"'Data Sheet'!B68","v":18.61},{"$f":"'Data Sheet'!C68","v":28.8},{"$f":"'Data Sheet'!D68","v":23.38},{"$f":"'Data Sheet'!E68","v":26.07},{"$f":"'Data Sheet'!F68","v":40.6},{"$f":"'Data Sheet'!G68","v":69.27},{"$f":"'Data Sheet'!H68","v":50.52},{"$f":"'Data Sheet'!I68","v":70.14},{"$f":"'Data Sheet'!J68","v":114.88},{"$f":"'Data Sheet'!K68","v":121.88}]
["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":4.3363782912412683},{"$f":"IF('Balance Sheet'!C18>0,'Profit & Loss'!C4/'Balance Sheet'!C18,0)","v":3.3062499999999999},{"$f":"IF('Balance Sheet'!D18>0,'Profit & Loss'!D4/'Balance Sheet'!D18,0)","v":4.2279726261762187},{"$f":"IF('Balance Sheet'!E18>0,'Profit & Loss'!E4/'Balance Sheet'!E18,0)","v":4.5515918680475638},{"$f":"IF('Balance Sheet'!F18>0,'Profit & Loss'!F4/'Balance Sheet'!F18,0)","v":3.8881773399014778},{"$f":"IF('Balance Sheet'!G18>0,'Profit & Loss'!G4/'Balance Sheet'!G18,0)","v":2.7918290746354844},{"$f":"IF('Balance Sheet'!H18>0,'Profit & Loss'!H4/'Balance Sheet'!H18,0)","v":3.7058590657165476},{"$f":"IF('Balance Sheet'!I18>0,'Profit & Loss'!I4/'Balance Sheet'!I18,0)","v":2.9044767607641857},{"$f":"IF('Balance Sheet'!J18>0,'Profit & Loss'!J4/'Balance Sheet'!J18,0)","v":2.82024721448468},{"$f":"IF('Balance Sheet'!K18>0,'Profit & Loss'!K4/'Balance Sheet'!K18,0)","v":3.4478995733508371},{"$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":84.1716232961586},{"$f":"IF('Profit & Loss'!C4>0,'Balance Sheet'!C18/('Profit & Loss'!C4/365),0)","v":110.39697542533081},{"$f":"IF('Profit & Loss'!D4>0,'Balance Sheet'!D18/('Profit & Loss'!D4/365),0)","v":86.329792615073345},{"$f":"IF('Profit & Loss'!E4>0,'Balance Sheet'!E18/('Profit & Loss'!E4/365),0)","v":80.191724254171589},{"$f":"IF('Profit & Loss'!F4>0,'Balance Sheet'!F18/('Profit & Loss'!F4/365),0)","v":93.874319016850365},{"$f":"IF('Profit & Loss'!G4>0,'Balance Sheet'!G18/('Profit & Loss'!G4/365),0)","v":130.73866280572938},{"$f":"IF('Profit & Loss'!H4>0,'Balance Sheet'!H18/('Profit & Loss'!H4/365),0)","v":98.492682405725887},{"$f":"IF('Profit & Loss'!I4>0,'Balance Sheet'!I18/('Profit & Loss'!I4/365),0)","v":125.66807382682113},{"$f":"IF('Profit & Loss'!J4>0,'Balance Sheet'!J18/('Profit & Loss'!J4/365),0)","v":129.42127843451959},{"$f":"IF('Profit & Loss'!K4>0,'Balance Sheet'!K18/('Profit & Loss'!K4/365),0)","v":105.86155200723412},{"$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":98.328376703841371},{"$f":"IF('Profit & Loss'!C4>0,'Balance Sheet'!C17/('Profit & Loss'!C4/365),0)","v":92.304137786179368},{"$f":"IF('Profit & Loss'!D4>0,'Balance Sheet'!D17/('Profit & Loss'!D4/365),0)","v":88.914516944865952},{"$f":"IF('Profit & Loss'!E4>0,'Balance Sheet'!E17/('Profit & Loss'!E4/365),0)","v":81.268329681442793},{"$f":"IF('Profit & Loss'!F4>0,'Balance Sheet'!F17/('Profit & Loss'!F4/365),0)","v":77.66596984669961},{"$f":"IF('Profit & Loss'!G4>0,'Balance Sheet'!G17/('Profit & Loss'!G4/365),0)","v":65.265525621800521},{"$f":"IF('Profit & Loss'!H4>0,'Balance Sheet'!H17/('Profit & Loss'!H4/365),0)","v":60.339440230744572},{"$f":"IF('Profit & Loss'!I4>0,'Balance Sheet'!I17/('Profit & Loss'!I4/365),0)","v":76.719516984095819},{"$f":"IF('Profit & Loss'!J4>0,'Balance Sheet'!J17/('Profit & Loss'!J4/365),0)","v":66.783542701935247},{"$f":"IF('Profit & Loss'!K4>0,'Balance Sheet'!K17/('Profit & Loss'!K4/365),0)","v":69.468386359850555},{"$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":44.053283767038408},{"$f":"IF('Profit & Loss'!C4>0,C19/('Profit & Loss'!C4/365),0)","v":27.484247006931316},{"$f":"IF('Profit & Loss'!D4>0,D19/('Profit & Loss'!D4/365),0)","v":29.392008093070309},{"$f":"IF('Profit & Loss'!E4>0,E19/('Profit & Loss'!E4/365),0)","v":59.090257879656171},{"$f":"IF('Profit & Loss'!F4>0,F19/('Profit & Loss'!F4/365),0)","v":86.544723172431262},{"$f":"IF('Profit & Loss'!G4>0,G19/('Profit & Loss'!G4/365),0)","v":71.456124928900167},{"$f":"IF('Profit & Loss'!H4>0,H19/('Profit & Loss'!H4/365),0)","v":49.948189296015379},{"$f":"IF('Profit & Loss'!I4>0,I19/('Profit & Loss'!I4/365),0)","v":33.629736893775771},{"$f":"IF('Profit & Loss'!J4>0,J19/('Profit & Loss'!J4/365),0)","v":39.847063180962373},{"$f":"IF('Profit & Loss'!K4>0,K19/('Profit & Loss'!K4/365),0)","v":38.712252813935223},{"$f":"IF('Profit & Loss'!L4>0,L10/('Profit & Loss'!L4/365),0)","v":45.548541126236763}]
["Cash Conversion Cycle",{"$f":"IF(B19>0,B22+B23-B24,0)","v":138.44671623296156},{"$f":"IF(C19>0,C22+C23-C24,0)","v":175.21686620457885},145.85230146686899,102.3697960559582,84.995565691118699,124.54806349862973,108.88393334045506,168.75785391714118,156.35775795549245,136.61768555314944,{"$f":"IF(L10>0,L22+L23-L24,0)","v":-45.548541126236763}]
["Working Capital/Sales",{"$f":"B16/'Profit & Loss'!B4","v":0.48847583643122677},{"$f":"C16/'Profit & Loss'!C4","v":0.50913673597983611},{"$f":"D16/'Profit & Loss'!D4","v":0.53262518968133543},{"$f":"E16/'Profit & Loss'!E4","v":0.3623799089836508},{"$f":"F16/'Profit & Loss'!F4","v":0.3923096414544533},{"$f":"G16/'Profit & Loss'!G4","v":0.45891721392005796},{"$f":"H16/'Profit & Loss'!H4","v":0.35754727059074887},{"$f":"I16/'Profit & Loss'!I4","v":0.42582956999803651},{"$f":"J16/'Profit & Loss'!J4","v":0.45776104200746937},{"$f":"K16/'Profit & Loss'!K4","v":0.42588582442947909}]
[]
["Return on Equity",{"$f":"IF(SUM('Balance Sheet'!B4:B5)>0,'Profit & Loss'!B12/SUM('Balance Sheet'!B4:B5),\"\")","v":6.2811387900355869E-2},{"$f":"IF(SUM('Balance Sheet'!C4:C5)>0,'Profit & Loss'!C12/SUM('Balance Sheet'!C4:C5),\"\")","v":8.1143232588699099E-2},{"$f":"IF(SUM('Balance Sheet'!D4:D5)>0,'Profit & Loss'!D12/SUM('Balance Sheet'!D4:D5),\"\")","v":6.3240498538236656E-2},{"$f":"IF(SUM('Balance Sheet'!E4:E5)>0,'Profit & Loss'!E12/SUM('Balance Sheet'!E4:E5),\"\")","v":0.12099943851768667},{"$f":"IF(SUM('Balance Sheet'!F4:F5)>0,'Profit & Loss'!F12/SUM('Balance Sheet'!F4:F5),\"\")","v":0.18752198897619324},{"$f":"IF(SUM('Balance Sheet'!G4:G5)>0,'Profit & Loss'!G12/SUM('Balance Sheet'!G4:G5),\"\")","v":0.21868485882129998},{"$f":"IF(SUM('Balance Sheet'!H4:H5)>0,'Profit & Loss'!H12/SUM('Balance Sheet'!H4:H5),\"\")","v":0.11064862989941034},{"$f":"IF(SUM('Balance Sheet'!I4:I5)>0,'Profit & Loss'!I12/SUM('Balance Sheet'!I4:I5),\"\")","v":0.17470881863560728},{"$f":"IF(SUM('Balance Sheet'!J4:J5)>0,'Profit & Loss'!J12/SUM('Balance Sheet'!J4:J5),\"\")","v":0.27770060903942728},{"$f":"IF(SUM('Balance Sheet'!K4:K5)>0,'Profit & Loss'!K12/SUM('Balance Sheet'!K4:K5),\"\")","v":0.28638092623818673},{"$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":0.13512605042016809},{"$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.10442201393895691},{"$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":8.7287639132981792E-2},{"$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.10580720092915237},{"$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.14141697003640449},{"$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.15897053338306585},{"$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":9.8353360035603132E-2},{"$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.16413626406828288},{"$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.216825061598029},{"$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.25522982780702996}]
[]
["Book Value",{"$f":"B4+B5","v":56.2},60.879999999999995,64.989999999999995,71.240000000000009,85.27000000000001,105.53999999999999,115.32,138.23000000000002,187.18,255.01000000000002,0]
["BVPS",{"$f":"IF('Data Sheet'!B93>0,B31/'Data Sheet'!B93,0)","v":9.7569444444444446},{"$f":"IF('Data Sheet'!C93>0,C31/'Data Sheet'!C93,0)","v":10.569444444444445},{"$f":"IF('Data Sheet'!D93>0,D31/'Data Sheet'!D93,0)","v":11.282986111111111},{"$f":"IF('Data Sheet'!E93>0,E31/'Data Sheet'!E93,0)","v":12.368055555555557},{"$f":"IF('Data Sheet'!F93>0,F31/'Data Sheet'!F93,0)","v":14.803819444444446},{"$f":"IF('Data Sheet'!G93>0,G31/'Data Sheet'!G93,0)","v":18.322916666666664},{"$f":"IF('Data Sheet'!H93>0,H31/'Data Sheet'!H93,0)","v":20.020833333333332},{"$f":"IF('Data Sheet'!I93>0,I31/'Data Sheet'!I93,0)","v":23.998263888888893},{"$f":"IF('Data Sheet'!J93>0,J31/'Data Sheet'!J93,0)","v":32.496527777777779},{"$f":"IF('Data Sheet'!K93>0,K31/'Data Sheet'!K93,0)","v":44.27256944444445},{"$f":"IF('Data Sheet'!K93>0,L31/'Data Sheet'!K93,0)","v":0}]
[]
["Cash & Bank Balances",{"$f":"'Data Sheet'!B69","v":0.39},{"$f":"'Data Sheet'!C69","v":0.37},{"$f":"'Data Sheet'!D69","v":8.18},{"$f":"'Data Sheet'!E69","v":1.0900000000000001},{"$f":"'Data Sheet'!F69","v":0.35},{"$f":"'Data Sheet'!G69","v":0.49},{"$f":"'Data Sheet'!H69","v":0.42},{"$f":"'Data Sheet'!I69","v":15.93},{"$f":"'Data Sheet'!J69","v":11.82},{"$f":"'Data Sheet'!K69","v":17.059999999999999}]
["Cash/Sales",{"$f":"B34/'Data Sheet'!B17","v":4.8327137546468404E-3},{"$f":"C34/'Data Sheet'!C17","v":3.8857382902751521E-3},{"$f":"D34/'Data Sheet'!D17","v":8.2751643904906427E-2},{"$f":"E34/'Data Sheet'!E17","v":9.1859093207483575E-3},{"$f":"F34/'Data Sheet'!F17","v":2.2171544406436078E-3},{"$f":"G34/'Data Sheet'!G17","v":2.5337401106572213E-3},{"$f":"H34/'Data Sheet'!H17","v":2.2433500694370259E-3},{"$f":"I34/'Data Sheet'!I17","v":7.8195562536815241E-2},{"$f":"J34/'Data Sheet'!J17","v":3.6482607487885427E-2},{"$f":"K34/'Data Sheet'!K17","v":4.0596816029317272E-2}]
["Gross Block",20.010000000000002,41.57,34.33,159.47,184.59,196.76,212.98,224.73,256.99,275.76]
["Common Size Balance Sheet",{"$f":"B3","v":"2014-03-31"},"2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31","Check back how Assets are being put to use"]
["Net Block/Total Assets",{"$f":"B10/B$8","v":0.17699427060379019},0.27328508495909376,0.2582938388625593,0.36578121021811083,0.30447962276860902,0.25728403475890271,0.28101986509066151,0.20921384368553747,0.26187160100809126,0.28231358345544527,"high historical Fixed Assets/Total Assets - strong correlation high Op Leverage"]
["Working Capital/Total Assets",{"$f":"B16/B$8","v":0.34746584398413399},0.38137193203272496,0.41587677725118488,0.36493252991598063,0.41717750084203437,0.50406088487533374,0.4142583080636178,0.39766215906486363,0.49180925852235047,0.49481600265420667]
["Debtors/Total Assets",{"$f":"B17/B$8","v":0.19162626707800792},0.18942731277533037,0.19020537124802528,0.22422133582279558,0.22627147187605259,0.19639915942522859,0.19153412958722693,0.19628695851478339,0.19657779546358933,0.22112859078216154]
["Inventory/Total Assets",{"$f":"B18/B$8","v":0.16403702071397092},0.22655758338577722,0.18467614533965246,0.2212509547653399,0.27349275850454702,0.39342307036973928,0.31264310910328613,0.32152188860875541,0.38095238095238093,0.33697365146949043]
["Cash/Total Assets",{"$f":"B34/B$8","v":3.4376377258704275E-3},{"$f":"C34/C$8","v":2.9106356198867209E-3},6.4612954186413898E-2,9.2506152932190448E-3,2.3576961940047153E-3,2.7829840404384621E-3,2.599170740763661E-3,7.3023149209259675E-2,3.9196179864703543E-2,4.7167463850258502E-2,"check for excluding excess cash (over and above historical normalised levels)"]
[]
["Borrowings/Total Assets",{"$f":"B6/B$8","v":0.34094314676068754},0.34660163624921336,0.33554502369668243,0.24306203853008573,0.24176490400808356,0.25427386834781623,0.15378426882851662,0.13403621361448542,0.19213423530972276,0.14556664546987752]

{"sheet":"Cash Flow","index":3,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Balance Sheet'!A1","v":"SHIVALIK BIMETAL CONTROLS LTD"},null,null,null,{"$f":"UPDATE","v":""},null,null,null,null,"SCREENER.IN"]
[]
["Narration",{"$f":"'Data Sheet'!B81","v":"2014-03-31"},{"$f":"'Data Sheet'!C81","v":"2015-03-31"},{"$f":"'Data Sheet'!D81","v":"2016-03-31"},{"$f":"'Data Sheet'!E81","v":"2017-03-31"},{"$f":"'Data Sheet'!F81","v":"2018-03-31"},{"$f":"'Data Sheet'!G81","v":"2019-03-31"},{"$f":"'Data Sheet'!H81","v":"2020-03-31"},{"$f":"'Data Sheet'!I81","v":"2021-03-31"},{"$f":"'Data Sheet'!J81","v":"2022-03-31"},{"$f":"'Data Sheet'!K81","v":"2023-03-31"}]
["Cash from Operating Activity",{"$f":"'Data Sheet'!B82","v":9.61},{"$f":"'Data Sheet'!C82","v":2.74},{"$f":"'Data Sheet'!D82","v":15.48},{"$f":"'Data Sheet'!E82","v":11.73},{"$f":"'Data Sheet'!F82","v":5.64},{"$f":"'Data Sheet'!G82","v":3.76},{"$f":"'Data Sheet'!H82","v":41.24},{"$f":"'Data Sheet'!I82","v":29.49},{"$f":"'Data Sheet'!J82","v":-3.48},{"$f":"'Data Sheet'!K82","v":61.22}]
["Cash from Investing Activity",{"$f":"'Data Sheet'!B83","v":-4.51},{"$f":"'Data Sheet'!C83","v":-4.9000000000000004},{"$f":"'Data Sheet'!D83","v":-2.11},{"$f":"'Data Sheet'!E83","v":-3.1},{"$f":"'Data Sheet'!F83","v":-7.09},{"$f":"'Data Sheet'!G83","v":-7.08},{"$f":"'Data Sheet'!H83","v":-14.45},{"$f":"'Data Sheet'!I83","v":-14.72},{"$f":"'Data Sheet'!J83","v":-24.18},{"$f":"'Data Sheet'!K83","v":-37.47}]
["Cash from Financing Activity",{"$f":"'Data Sheet'!B84","v":-5.0999999999999996},{"$f":"'Data Sheet'!C84","v":2.13},{"$f":"'Data Sheet'!D84","v":-5.55},{"$f":"'Data Sheet'!E84","v":-16.57},{"$f":"'Data Sheet'!F84","v":1.49},{"$f":"'Data Sheet'!G84","v":3.49},{"$f":"'Data Sheet'!H84","v":-26.91},{"$f":"'Data Sheet'!I84","v":0.62},{"$f":"'Data Sheet'!J84","v":22.87},{"$f":"'Data Sheet'!K84","v":-17.78}]
["Net Cash Flow",{"$f":"'Data Sheet'!B85","v":0},{"$f":"'Data Sheet'!C85","v":-0.03},{"$f":"'Data Sheet'!D85","v":7.81},{"$f":"'Data Sheet'!E85","v":-7.94},{"$f":"'Data Sheet'!F85","v":0.05},{"$f":"'Data Sheet'!G85","v":0.17},{"$f":"'Data Sheet'!H85","v":-0.12},{"$f":"'Data Sheet'!I85","v":15.39},{"$f":"'Data Sheet'!J85","v":-4.79},{"$f":"'Data Sheet'!K85","v":5.97}]

{"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":"SHIVALIK BIMETAL CONTROLS 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":198.81},{"$f":"'Calculated Data'!K33-'Calculated Data'!B33","v":2941.6320000000001},{"$f":"C5/B5","v":14.796197374377547},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":183.77},{"$f":"'Calculated Data'!K33-'Calculated Data'!E33","v":2835.5328000000004},{"$f":"C6/B6","v":15.429791587310227},null,"MIN",{"$f":"MIN('Calculated Data'!B38:K38)","v":4.4872521246458925},{"$f":"MIN('Calculated Data'!B39:K39)","v":0.28185053380782915},{"$f":"MIN('Calculated Data'!B42:K42)","v":4.1945397324940989},{"$f":"MIN('Calculated Data'!B41:K41)","v":0.19628252788104089},{"$f":"MAX('Calculated Data'!B43:K43)","v":1.3991084637545744E-2},{"$f":"MIN('Calculated Data'!B40:K40)","v":-566.73103448275856},null,"LTB Quote",{"$f":"('Profit & Loss'!$L$10/'Data Sheet'!$B$61)/O5","v":9.9240977425199546}]
["5 YR",{"$f":"'Calculated Data'!K10-'Calculated Data'!G10","v":149.47000000000003},{"$f":"'Calculated Data'!K33-'Calculated Data'!G33","v":2426.4},{"$f":"C7/B7","v":16.233357864454405},null,"MAX",{"$f":"MAX('Calculated Data'!B38:K38)","v":40.496672600301245},{"$f":"MAX('Calculated Data'!B39:K39)","v":11.597474608838869},{"$f":"MAX('Calculated Data'!B42:K42)","v":26.55778172138421},{"$f":"MAX('Calculated Data'!B41:K41)","v":7.0377459962401545},{"$f":"MIN('Calculated Data'!B43:K43)","v":0},{"$f":"MAX('Calculated Data'!B40:K40)","v":141.24255319148938},null,"Equity Quoting @",{"$f":"('Profit & Loss'!$L$6/'Data Sheet'!$B$6)/'Data Sheet'!$B$8","v":3.6039237753010128E-2}]
["3 YR",{"$f":"'Calculated Data'!K10-'Calculated Data'!I10","v":116.78},{"$f":"'Calculated Data'!K33-'Calculated Data'!I33","v":2630.3040000000001},{"$f":"C8/B8","v":22.523582805274877},null,"TRAILING",{"$f":"'Data Sheet'!B8/'Profit & Loss'!L13","v":39.912135539795109},{"$f":"'Calculated Data'!L33/'Calculated Data'!K10","v":11.91682679110623},{"$f":"'Calculated Data'!K42","v":26.55778172138421},{"$f":"'Calculated Data'!L33/'Profit & Loss'!L4","v":6.9762172585569653},{"$f":"'Data Sheet'!K31/'Calculated Data'!L33","v":2.2738416076817018E-3},{"$f":"'Calculated Data'!L33/'Data Sheet'!K82","v":49.639170205815091}]
["1 YR",{"$f":"'Calculated Data'!K10-'Calculated Data'!J10","v":67.830000000000013},{"$f":"'Calculated Data'!K33-'Calculated Data'!J33","v":985.2480000000005},{"$f":"C9/B9","v":14.525254312251221},null,null,null,null,null,null,null,null,null," "]
["* IMPACT – Every Rupee retained added xx.yy in incremental market value"]
[]
[{"$f":"A1","v":"SHIVALIK BIMETAL CONTROLS 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.20122323557248878},{"$f":"POWER('Calculated Data'!$K3/'Calculated Data'!$B3, 1/9)-1","v":0.22413965444218031},{"$f":"POWER('Calculated Data'!$K4/'Calculated Data'!$B4, 1/9)-1","v":0.34368247550480158},{"$f":"POWER('Calculated Data'!$K7/'Calculated Data'!$B7, 1/9)-1","v":0.40020570857074422},{"$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.3444210844944058},{"$f":"POWER('Calculated Data'!$K33/'Calculated Data'!$B33, 1/9)-1","v":0.7879349678885299},{"$f":"POWER('Calculated Data'!$K17/'Calculated Data'!$B17, 1/9)-1","v":0.22843509510782467},{"$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.18298734699014507},{"$f":"POWER('Calculated Data'!$K34/'Calculated Data'!$B34, 1/9)-1","v":0.78839864543023497}]
["5 YR CAGR",{"$f":"POWER('Data Sheet'!$K17/'Data Sheet'!$G17, 1/4)-1","v":0.21412460361884933},{"$f":"POWER('Calculated Data'!$K3/'Calculated Data'!$G3, 1/4)-1","v":0.23352752958543443},{"$f":"POWER('Calculated Data'!$K4/'Calculated Data'!$G4, 1/4)-1","v":0.30371166745357114},{"$f":"POWER('Calculated Data'!$K7/'Calculated Data'!$G7, 1/4)-1","v":0.33372525231723094},{"$f":"POWER('Calculated Data'!$K8/'Calculated Data'!$G8, 1/4)-1","v":0.31655059243054362},{"$f":"POWER('Calculated Data'!$K26/'Calculated Data'!$G26, 1/4)-1","v":0.49384387591318135},{"$f":"POWER('Calculated Data'!$K33/'Calculated Data'!$G33, 1/4)-1","v":0.53617894834824131},{"$f":"POWER('Calculated Data'!$K17/'Calculated Data'!$G17, 1/4)-1","v":1.0087522215969331},{"$f":"POWER('Calculated Data'!$K19/'Calculated Data'!$G19, 1/4)-1","v":{"$error":"#NUM!"}},{"$f":"POWER('Calculated Data'!$K10/'Calculated Data'!$G10, 1/4)-1","v":0.24676622977408846},{"$f":"POWER('Calculated Data'!$K34/'Calculated Data'!$G34, 1/4)-1","v":0.53541574078088972}]
["3 YR CAGR",{"$f":"POWER('Data Sheet'!$K17/'Data Sheet'!$I17, 1/2)-1","v":0.43623892516087337},{"$f":"POWER('Calculated Data'!$K3/'Calculated Data'!$I3, 1/2)-1","v":0.46960844499955301},{"$f":"POWER('Calculated Data'!$K4/'Calculated Data'!$I4, 1/2)-1","v":0.74371684190336818},{"$f":"POWER('Calculated Data'!$K7/'Calculated Data'!$I7, 1/2)-1","v":0.73896997189341884},{"$f":"POWER('Calculated Data'!$K8/'Calculated Data'!$I8, 1/2)-1","v":0.73330546242921546},{"$f":"POWER('Calculated Data'!$K26/'Calculated Data'!$I26, 1/2)-1","v":1.6003186107327552},{"$f":"POWER('Calculated Data'!$K33/'Calculated Data'!$I33, 1/2)-1","v":2.0065948639709243},{"$f":"POWER('Calculated Data'!$K17/'Calculated Data'!$I17, 1/2)-1","v":0.44081850066137207},{"$f":"POWER('Calculated Data'!$K19/'Calculated Data'!$I19, 1/2)-1","v":0.45638004330601767},{"$f":"POWER('Calculated Data'!$K10/'Calculated Data'!$I10, 1/2)-1","v":0.35824292536992131},{"$f":"POWER('Calculated Data'!$K34/'Calculated Data'!$I34, 1/2)-1","v":1.9995801018156643}]
["1 YR GROWTH",{"$f":"('Data Sheet'!$K17-'Data Sheet'!$J17)/'Data Sheet'!$J17","v":0.29704620512978797},{"$f":"('Calculated Data'!$K3-'Calculated Data'!$J3)/'Calculated Data'!$J3","v":0.29118673073125784},{"$f":"('Calculated Data'!$K4-'Calculated Data'!$J4)/'Calculated Data'!$J4","v":0.43686242073338838},{"$f":"('Calculated Data'!$K7-'Calculated Data'!$J7)/'Calculated Data'!$J7","v":0.40496344747980001},{"$f":"('Calculated Data'!$K8-'Calculated Data'!$J8)/'Calculated Data'!$J8","v":0.79947916666666674},{"$f":"('Calculated Data'!$K26-'Calculated Data'!$J26)/'Calculated Data'!$J26","v":0.69893237105724759},{"$f":"('Calculated Data'!$K33-'Calculated Data'!$J33)/'Calculated Data'!$J33","v":0.49956191588785082},{"$f":"('Calculated Data'!$K17-'Calculated Data'!$J17)/'Calculated Data'!$J17","v":-18.591954022988507},{"$f":"('Calculated Data'!$K19-'Calculated Data'!$J19)/'Calculated Data'!$J19","v":-2.3167630057803463},{"$f":"('Calculated Data'!$K10-'Calculated Data'!$J10)/'Calculated Data'!$J10","v":0.36237845923709805},{"$f":"('Calculated Data'!$K34-'Calculated Data'!$J34)/'Calculated Data'!$J34","v":0.50014473215442445}]
["**modify (if, then) for negative values"]
[{"$f":"A1","v":"SHIVALIK BIMETAL CONTROLS LTD"},{"$f":"'Data Sheet'!B16","v":"2014-03-31"},{"$f":"'Data Sheet'!C16","v":"2015-03-31"},{"$f":"'Data Sheet'!D16","v":"2016-03-31"},{"$f":"'Data Sheet'!E16","v":"2017-03-31"},{"$f":"'Data Sheet'!F16","v":"2018-03-31"},{"$f":"'Data Sheet'!G16","v":"2019-03-31"},{"$f":"'Data Sheet'!H16","v":"2020-03-31"},{"$f":"'Data Sheet'!I16","v":"2021-03-31"},{"$f":"'Data Sheet'!J16","v":"2022-03-31"},{"$f":"'Data Sheet'!K16","v":"2023-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":2.0186832740213521},{"$f":"'Calculated Data'!C15/'Calculated Data'!C10","v":2.0880420499342973},{"$f":"'Calculated Data'!D15/'Calculated Data'!D10","v":1.9479919987690415},{"$f":"'Calculated Data'!E15/'Calculated Data'!E10","v":1.6539865244244805},{"$f":"'Calculated Data'!F15/'Calculated Data'!F10","v":1.740940541808373},{"$f":"'Calculated Data'!G15/'Calculated Data'!G10","v":1.668277430358158},{"$f":"'Calculated Data'!H15/'Calculated Data'!H10","v":1.4012313562261534},{"$f":"'Calculated Data'!I15/'Calculated Data'!I10","v":1.5781668234102582},{"$f":"'Calculated Data'!J15/'Calculated Data'!J10","v":1.6110695587135377},{"$f":"'Calculated Data'!K15/'Calculated Data'!K10","v":1.4183365358221245},{"$f":"'Balance Sheet'!L8/'Calculated Data'!L10","v":{"$error":"#DIV/0!"}}]
["Long term debt/Earning",{"$f":"'Data Sheet'!B59/'Data Sheet'!B30","v":10.957507082152976},{"$f":"'Data Sheet'!C59/'Data Sheet'!C30","v":8.9190283400809722},{"$f":"'Data Sheet'!D59/'Data Sheet'!D30","v":10.335766423357663},{"$f":"'Data Sheet'!E59/'Data Sheet'!E30","v":3.3225058004640373},{"$f":"'Data Sheet'!F59/'Data Sheet'!F30","v":2.2445278298936837},{"$f":"'Data Sheet'!G59/'Data Sheet'!G30","v":1.9397746967071059},{"$f":"'Data Sheet'!H59/'Data Sheet'!H30","v":1.9474921630094046},{"$f":"'Data Sheet'!I59/'Data Sheet'!I30","v":1.2107660455486542},{"$f":"'Data Sheet'!J59/'Data Sheet'!J30","v":1.1146594844170836},{"$f":"'Data Sheet'!K59/'Data Sheet'!K30","v":0.72093660139668625}]
["Current liablility/Earning",{"$f":"'Data Sheet'!B60/'Data Sheet'!B30","v":5.260623229461757},{"$f":"'Data Sheet'!C60/'Data Sheet'!C30","v":4.4898785425101213},{"$f":"'Data Sheet'!D60/'Data Sheet'!D30","v":4.6545012165450119},{"$f":"'Data Sheet'!E60/'Data Sheet'!E30","v":2.0823665893271461},{"$f":"'Data Sheet'!F60/'Data Sheet'!F30","v":1.7066916823014384},{"$f":"'Data Sheet'!G60/'Data Sheet'!G30","v":1.1161178509532064},{"$f":"'Data Sheet'!H60/'Data Sheet'!H30","v":1.6786833855799375},{"$f":"'Data Sheet'!I60/'Data Sheet'!I30","v":2.0985507246376813},{"$f":"'Data Sheet'!J60/'Data Sheet'!J30","v":1.0858022316275491},{"$f":"'Data Sheet'!K60/'Data Sheet'!K30","v":0.7398329453649185}]
["Total liability/Earning",{"$f":"('Data Sheet'!B59+'Data Sheet'!B60)/'Data Sheet'!B30","v":16.218130311614733},{"$f":"('Data Sheet'!C59+'Data Sheet'!C60)/'Data Sheet'!C30","v":13.408906882591094},{"$f":"('Data Sheet'!D59+'Data Sheet'!D60)/'Data Sheet'!D30","v":14.990267639902676},{"$f":"('Data Sheet'!E59+'Data Sheet'!E60)/'Data Sheet'!E30","v":5.4048723897911843},{"$f":"('Data Sheet'!F59+'Data Sheet'!F60)/'Data Sheet'!F30","v":3.9512195121951219},{"$f":"('Data Sheet'!G59+'Data Sheet'!G60)/'Data Sheet'!G30","v":3.0558925476603123},{"$f":"('Data Sheet'!H59+'Data Sheet'!H60)/'Data Sheet'!H30","v":3.6261755485893419},{"$f":"('Data Sheet'!I59+'Data Sheet'!I60)/'Data Sheet'!I30","v":3.3093167701863355},{"$f":"('Data Sheet'!J59+'Data Sheet'!J60)/'Data Sheet'!J30","v":2.2004617160446327},{"$f":"('Data Sheet'!K59+'Data Sheet'!K60)/'Data Sheet'!K30","v":1.4607695467616049}]
["Debt/Equity",{"$f":"'Data Sheet'!B59/'Calculated Data'!B10","v":0.6882562277580071},{"$f":"'Data Sheet'!C59/'Calculated Data'!C10","v":0.72371879106438908},{"$f":"'Data Sheet'!D59/'Calculated Data'!D10","v":0.65363902138790586},{"$f":"'Data Sheet'!E59/'Calculated Data'!E10","v":0.40202133632790565},{"$f":"'Data Sheet'!F59/'Calculated Data'!F10","v":0.42089832297408231},{"$f":"'Data Sheet'!G59/'Calculated Data'!G10","v":0.42419935569452344},{"$f":"'Data Sheet'!H59/'Calculated Data'!H10","v":0.21548733957682972},{"$f":"'Data Sheet'!I59/'Calculated Data'!I10","v":0.21153150546191127},{"$f":"'Data Sheet'!J59/'Calculated Data'!J10","v":0.30954161769419808},{"$f":"'Data Sheet'!K59/'Calculated Data'!K10","v":0.20646249166699343}]
["Interest Coverage",{"$f":"'Calculated Data'!B4/'Data Sheet'!B27","v":2.3028391167192428},{"$f":"'Calculated Data'!C4/'Data Sheet'!C27","v":3.6343749999999995},{"$f":"'Calculated Data'!D4/'Data Sheet'!D27","v":2.666666666666667},{"$f":"'Calculated Data'!E4/'Data Sheet'!E27","v":6.4881889763779528},{"$f":"'Calculated Data'!F4/'Data Sheet'!F27","v":7.6042296072507547},{"$f":"'Calculated Data'!G4/'Data Sheet'!G27","v":10.078212290502792},{"$f":"'Calculated Data'!H4/'Data Sheet'!H27","v":6.6020408163265305},{"$f":"'Calculated Data'!I4/'Data Sheet'!I27","v":21.030674846625768},{"$f":"'Calculated Data'!J4/'Data Sheet'!J27","v":26.282608695652179},{"$f":"'Calculated Data'!K4/'Data Sheet'!K27","v":15.697289156626507}]
["Working Capital/Sales",{"$f":"'Calculated Data'!B11/'Data Sheet'!B17","v":0.48847583643122677},{"$f":"'Calculated Data'!C11/'Data Sheet'!C17","v":0.50913673597983611},{"$f":"'Calculated Data'!D11/'Data Sheet'!D17","v":0.53262518968133543},{"$f":"'Calculated Data'!E11/'Data Sheet'!E17","v":0.3623799089836508},{"$f":"'Calculated Data'!F11/'Data Sheet'!F17","v":0.3923096414544533},{"$f":"'Calculated Data'!G11/'Data Sheet'!G17","v":0.45891721392005796},{"$f":"'Calculated Data'!H11/'Data Sheet'!H17","v":0.35754727059074887},{"$f":"'Calculated Data'!I11/'Data Sheet'!I17","v":0.42582956999803651},{"$f":"'Calculated Data'!J11/'Data Sheet'!J17","v":0.45776104200746937},{"$f":"'Calculated Data'!K11/'Data Sheet'!K17","v":0.42588582442947909},null,"Check for improving or deteriorating picture"]
["Inventory Turns",{"$f":"365/B27","v":4.3363782912412692},3.3062500000000004,4.2279726261762187,4.5515918680475638,3.8881773399014783,2.7918290746354839,3.705859065716548,2.9044767607641857,2.8202472144846795,3.4478995733508371]
["Inventory Days",{"$f":"'Balance Sheet'!B22","v":84.1716232961586},{"$f":"'Balance Sheet'!C22","v":110.39697542533081},{"$f":"'Balance Sheet'!D22","v":86.329792615073345},{"$f":"'Balance Sheet'!E22","v":80.191724254171589},{"$f":"'Balance Sheet'!F22","v":93.874319016850365},{"$f":"'Balance Sheet'!G22","v":130.73866280572938},{"$f":"'Balance Sheet'!H22","v":98.492682405725887},{"$f":"'Balance Sheet'!I22","v":125.66807382682113},{"$f":"'Balance Sheet'!J22","v":129.42127843451959},{"$f":"'Balance Sheet'!K22","v":105.86155200723412}]
["Debtor Days",{"$f":"'Balance Sheet'!B23","v":98.328376703841371},{"$f":"'Balance Sheet'!C23","v":92.304137786179368},{"$f":"'Balance Sheet'!D23","v":88.914516944865952},{"$f":"'Balance Sheet'!E23","v":81.268329681442793},{"$f":"'Balance Sheet'!F23","v":77.66596984669961},{"$f":"'Balance Sheet'!G23","v":65.265525621800521},{"$f":"'Balance Sheet'!H23","v":60.339440230744572},{"$f":"'Balance Sheet'!I23","v":76.719516984095819},{"$f":"'Balance Sheet'!J23","v":66.783542701935247},{"$f":"'Balance Sheet'!K23","v":69.468386359850555}]
["Creditor Days",{"$f":"'Balance Sheet'!B24","v":44.053283767038408},{"$f":"'Balance Sheet'!C24","v":27.484247006931316},{"$f":"'Balance Sheet'!D24","v":29.392008093070309},{"$f":"'Balance Sheet'!E24","v":59.090257879656171},{"$f":"'Balance Sheet'!F24","v":86.544723172431262},{"$f":"'Balance Sheet'!G24","v":71.456124928900167},{"$f":"'Balance Sheet'!H24","v":49.948189296015379},{"$f":"'Balance Sheet'!I24","v":33.629736893775771},{"$f":"'Balance Sheet'!J24","v":39.847063180962373},{"$f":"'Balance Sheet'!K24","v":38.712252813935223},null,"Check back to see if Creditor policy change is impacting Working Cap cycle"]
["Cash Conversion Cycle",{"$f":"'Balance Sheet'!B25","v":138.44671623296156},{"$f":"'Balance Sheet'!C25","v":175.21686620457885},{"$f":"'Balance Sheet'!D25","v":145.85230146686899},{"$f":"'Balance Sheet'!E25","v":102.3697960559582},{"$f":"'Balance Sheet'!F25","v":84.995565691118699},{"$f":"'Balance Sheet'!G25","v":124.54806349862973},{"$f":"'Balance Sheet'!H25","v":108.88393334045506},{"$f":"'Balance Sheet'!I25","v":168.75785391714118},{"$f":"'Balance Sheet'!J25","v":156.35775795549245},{"$f":"'Balance Sheet'!K25","v":136.61768555314944}]
["Cash In/Cash Out Ratio",{"$f":"('Data Sheet'!B67+'Data Sheet'!B69)/'Data Sheet'!B60","v":1.1917070543887991},{"$f":"('Data Sheet'!C67+'Data Sheet'!C69)/'Data Sheet'!C60","v":1.1023444544634806},{"$f":"('Data Sheet'!D67+'Data Sheet'!D69)/'Data Sheet'!D60","v":1.686356508102457},{"$f":"('Data Sheet'!E67+'Data Sheet'!E69)/'Data Sheet'!E60","v":1.5325905292479109},{"$f":"('Data Sheet'!F67+'Data Sheet'!F69)/'Data Sheet'!F60","v":1.2436790032979115},{"$f":"('Data Sheet'!G67+'Data Sheet'!G69)/'Data Sheet'!G60","v":1.3614130434782608},{"$f":"('Data Sheet'!H67+'Data Sheet'!H69)/'Data Sheet'!H60","v":1.4645191409897291},{"$f":"('Data Sheet'!I67+'Data Sheet'!I69)/'Data Sheet'!I60","v":1.159234411996843},{"$f":"('Data Sheet'!J67+'Data Sheet'!J69)/'Data Sheet'!J60","v":1.2597448618001417},{"$f":"('Data Sheet'!K67+'Data Sheet'!K69)/'Data Sheet'!K60","v":1.7960392374606702},null,"  "]
["Current Ratio",{"$f":"'Data Sheet'!B65/'Data Sheet'!B60","v":3.122778675282714},{"$f":"'Data Sheet'!C65/'Data Sheet'!C60","v":3.1857529305680794},{"$f":"'Data Sheet'!D65/'Data Sheet'!D60","v":3.7522216414009413},{"$f":"'Data Sheet'!E65/'Data Sheet'!E60","v":3.3955431754874654},{"$f":"'Data Sheet'!F65/'Data Sheet'!F60","v":3.2693294246976916},{"$f":"'Data Sheet'!G65/'Data Sheet'!G60","v":4.4452639751552798},{"$f":"'Data Sheet'!H65/'Data Sheet'!H60","v":4.125116713352007},{"$f":"'Data Sheet'!I65/'Data Sheet'!I60","v":2.7117205998421468},{"$f":"'Data Sheet'!J65/'Data Sheet'!J60","v":3.6277462792345854},{"$f":"'Data Sheet'!K65/'Data Sheet'!K60","v":4.3124190264667774}," "]
["CFO/PAT",{"$f":"'Calculated Data'!B17/'Calculated Data'!B7","v":2.7223796033994336},{"$f":"'Calculated Data'!C17/'Calculated Data'!C7","v":0.55465587044534415},{"$f":"'Calculated Data'!D17/'Calculated Data'!D7","v":3.7664233576642334},{"$f":"'Calculated Data'!E17/'Calculated Data'!E7","v":1.360788863109049},{"$f":"'Calculated Data'!F17/'Calculated Data'!F7","v":0.35272045028142585},{"$f":"'Calculated Data'!G17/'Calculated Data'!G7","v":0.16291161178509533},{"$f":"'Calculated Data'!H17/'Calculated Data'!H7","v":3.2319749216300941},{"$f":"'Calculated Data'!I17/'Calculated Data'!I7","v":1.2211180124223602},{"$f":"'Calculated Data'!J17/'Calculated Data'!J7","v":-6.6948826471719902E-2},{"$f":"'Calculated Data'!K17/'Calculated Data'!K7","v":0.83828563603998352}]
[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.39380421313506814},{"$f":"'Calculated Data'!C3/'Data Sheet'!C17","v":0.3935097668557026},{"$f":"'Calculated Data'!D3/'Data Sheet'!D17","v":0.4326757713707638},{"$f":"'Calculated Data'!E3/'Data Sheet'!E17","v":0.45322770942187768},{"$f":"'Calculated Data'!F3/'Data Sheet'!F17","v":0.43285189408336505},{"$f":"'Calculated Data'!G3/'Data Sheet'!G17","v":0.43813020321629864},{"$f":"'Calculated Data'!H3/'Data Sheet'!H17","v":0.47751308620873839},{"$f":"'Calculated Data'!I3/'Data Sheet'!I17","v":0.44585705870803061},{"$f":"'Calculated Data'!J3/'Data Sheet'!J17","v":0.46893422636501125},{"$f":"'Calculated Data'!K3/'Data Sheet'!K17","v":0.46681579135235468}]
["EBIT/Sales",{"$f":"'Calculated Data'!B4/'Data Sheet'!B17","v":9.0458488228004952E-2},{"$f":"'Calculated Data'!C4/'Data Sheet'!C17","v":0.12213820625918924},{"$f":"'Calculated Data'!D4/'Data Sheet'!D17","v":0.10520991401112798},{"$f":"'Calculated Data'!E4/'Data Sheet'!E17","v":0.13888420697792012},{"$f":"'Calculated Data'!F4/'Data Sheet'!F17","v":0.15944507791714174},{"$f":"'Calculated Data'!G4/'Data Sheet'!G17","v":0.18656600651533173},{"$f":"'Calculated Data'!H4/'Data Sheet'!H17","v":0.10367482106612541},{"$f":"'Calculated Data'!I4/'Data Sheet'!I17","v":0.16827017474965639},{"$f":"'Calculated Data'!J4/'Data Sheet'!J17","v":0.22389579925306338},{"$f":"'Calculated Data'!K4/'Data Sheet'!K17","v":0.24803084025414654},{"$f":"'Calculated Data'!L4/'Profit & Loss'!L4","v":0.24696402745575169}]
["EBITDA/Sales",{"$f":"'Calculated Data'!B5/'Data Sheet'!B17","v":0.11957868649318464},{"$f":"'Calculated Data'!C5/'Data Sheet'!C17","v":0.15542953161100609},{"$f":"'Calculated Data'!D5/'Data Sheet'!D17","v":0.14253920080930704},{"$f":"'Calculated Data'!E5/'Data Sheet'!E17","v":0.17714478341479858},{"$f":"'Calculated Data'!F5/'Data Sheet'!F17","v":0.18871151653363738},{"$f":"'Calculated Data'!G5/'Data Sheet'!G17","v":0.2116448627126532},{"$f":"'Calculated Data'!H5/'Data Sheet'!H17","v":0.13577609229783144},{"$f":"'Calculated Data'!I5/'Data Sheet'!I17","v":0.19723149420773611},{"$f":"'Calculated Data'!J5/'Data Sheet'!J17","v":0.24358776505447699},{"$f":"'Calculated Data'!K5/'Data Sheet'!K17","v":0.26818646931442303}]
["Op Profit (Ex Other Income)/Sales",{"$f":"'Calculated Data'!B6/'Data Sheet'!B17","v":0.13630731102850061},{"$f":"'Calculated Data'!C6/'Data Sheet'!C17","v":0.16120562906952321},{"$f":"'Calculated Data'!D6/'Data Sheet'!D17","v":0.13677288821446637},{"$f":"'Calculated Data'!E6/'Data Sheet'!E17","v":0.15995280633743469},{"$f":"'Calculated Data'!F6/'Data Sheet'!F17","v":0.16242239959457747},{"$f":"'Calculated Data'!G6/'Data Sheet'!G17","v":0.18398055742282435},{"$f":"'Calculated Data'!H6/'Data Sheet'!H17","v":0.11093900224335008},{"$f":"'Calculated Data'!I6/'Data Sheet'!I17","v":0.17735126644413904},{"$f":"'Calculated Data'!J6/'Data Sheet'!J17","v":0.22676625821784621},{"$f":"'Calculated Data'!K6/'Data Sheet'!K17","v":0.24931585084358568}]
["Net Margin =PAT/Sales",{"$f":"'Calculated Data'!B7/'Data Sheet'!B17","v":4.3742255266418832E-2},{"$f":"'Calculated Data'!C7/'Data Sheet'!C17","v":5.187985717286285E-2},{"$f":"'Calculated Data'!D7/'Data Sheet'!D17","v":4.1578148710166928E-2},{"$f":"'Calculated Data'!E7/'Data Sheet'!E17","v":7.2644530591606263E-2},{"$f":"'Calculated Data'!F7/'Data Sheet'!F17","v":0.10129228430254655},{"$f":"'Calculated Data'!G7/'Data Sheet'!G17","v":0.11934433011014013},{"$f":"'Calculated Data'!H7/'Data Sheet'!H17","v":6.8155111633372498E-2},{"$f":"'Calculated Data'!I7/'Data Sheet'!I17","v":0.11854506184959748},{"$f":"'Calculated Data'!J7/'Data Sheet'!J17","v":0.16043705052625079},{"$f":"'Calculated Data'!K7/'Data Sheet'!K17","v":0.173785783975442},{"$f":"'Calculated Data'!L7/'Profit & Loss'!L4","v":0.1747893758178187}]
["Op Cash Flow/Sales",{"$f":"'Calculated Data'!B17/'Data Sheet'!B17","v":0.11908302354399007},{"$f":"'Calculated Data'!C17/'Data Sheet'!C17","v":2.8775467338794374E-2},{"$f":"'Calculated Data'!D17/'Data Sheet'!D17","v":0.15660091047040972},{"$f":"'Calculated Data'!E17/'Data Sheet'!E17","v":9.8853868194842417E-2},{"$f":"'Calculated Data'!F17/'Data Sheet'!F17","v":3.5727860129228427E-2},{"$f":"'Calculated Data'!G17/'Data Sheet'!G17","v":1.9442577175655413E-2},{"$f":"'Calculated Data'!H17/'Data Sheet'!H17","v":0.22027561157995942},{"$f":"'Calculated Data'!I17/'Data Sheet'!I17","v":0.14475751030826625},{"$f":"'Calculated Data'!J17/'Data Sheet'!J17","v":-1.0741072255316522E-2},{"$f":"'Calculated Data'!K17/'Data Sheet'!K17","v":0.14568212645456058}]
["Free Cash Flow/Sales",{"$f":"'Calculated Data'!B19/'Data Sheet'!B17","v":0},{"$f":"'Calculated Data'!C19/'Data Sheet'!C17","v":-1.2707414408737688E-2},{"$f":"'Calculated Data'!D19/'Data Sheet'!D17","v":0.13717754172989377},{"$f":"'Calculated Data'!E19/'Data Sheet'!E17","v":-2.8990392718692044E-2},{"$f":"'Calculated Data'!F19/'Data Sheet'!F17","v":-8.4251868744457219E-3},{"$f":"'Calculated Data'!G19/'Data Sheet'!G17","v":-1.2720409535136225E-2},{"$f":"'Calculated Data'!H19/'Data Sheet'!H17","v":0.12589466937293026},{"$f":"'Calculated Data'!I19/'Data Sheet'!I17","v":7.9079128215197289E-2},{"$f":"'Calculated Data'!J19/'Data Sheet'!J17","v":-8.0095064662489585E-2},{"$f":"'Calculated Data'!K19/'Data Sheet'!K17","v":8.131261452061965E-2}]
["EPA/Sales",{"$f":"'Calculated Data'!B26/'Data Sheet'!B17","v":-3.7920795941084502E-2},{"$f":"'Calculated Data'!C26/'Data Sheet'!C17","v":-3.8306998614434262E-2},{"$f":"'Calculated Data'!D26/'Data Sheet'!D17","v":-4.2071825998988371E-2},{"$f":"'Calculated Data'!E26/'Data Sheet'!E17","v":-5.8113641546286348E-3},{"$f":"'Calculated Data'!F26/'Data Sheet'!F17","v":3.1605065648751964E-2},{"$f":"'Calculated Data'!G26/'Data Sheet'!G17","v":4.5594657268890684E-2},{"$f":"'Calculated Data'!H26/'Data Sheet'!H17","v":-2.9326922983373355E-3},{"$f":"'Calculated Data'!I26/'Data Sheet'!I17","v":3.1877335766083176E-2},{"$f":"'Calculated Data'!J26/'Data Sheet'!J17","v":7.9773953512837614E-2},{"$f":"'Calculated Data'!K26/'Data Sheet'!K17","v":0.10449169154819282},{"$f":"'Calculated Data'!L26/'Profit & Loss'!L4","v":0.14180451632206989}]
["EPA/Sales Increase - last 5 Years",null,null,null,null,{"$f":"(F42-B42)","v":6.9525861589836466E-2},{"$f":"(G42-C42)","v":8.3901655883324947E-2},3.9139133700651037E-2,3.7688699920711811E-2,4.8168887864085651E-2,5.8897034279302138E-2]
["EPA/Sales Increase - last 3 Years",null,null,{"$f":"(D42-B42)","v":-4.1510300579038692E-3},{"$f":"(E42-C42)","v":3.2495634459805627E-2},7.3676891647740328E-2,5.140602142351932E-2,-3.4537757947089298E-2,-1.3717321502807509E-2,8.2706645811174956E-2,7.2614355782109646E-2,"`"]
["MktCap Cagr  - last 5 years",null,null,null,null,{"$f":"POWER('Calculated Data'!F33/'Calculated Data'!B33, 1/4)-1","v":1.2862313395955343},{"$f":"POWER('Calculated Data'!G33/'Calculated Data'!C33, 1/4)-1","v":0.7549557238473068},{"$f":"POWER('Calculated Data'!H33/'Calculated Data'!D33, 1/4)-1","v":0.20182703124473256},{"$f":"POWER('Calculated Data'!I33/'Calculated Data'!E33, 1/4)-1","v":0.27984350680058667},{"$f":"POWER('Calculated Data'!J33/'Calculated Data'!F33, 1/4)-1","v":0.4611005081352042},{"$f":"POWER('Calculated Data'!K33/'Calculated Data'!G33, 1/4)-1","v":0.53617894834824131}]
["MktCap Cagr  - last 3 years",null,null,{"$f":"POWER('Calculated Data'!D33/'Calculated Data'!B33, 1/2)-1","v":0.57710897761465008},{"$f":"POWER('Calculated Data'!E33/'Calculated Data'!C33, 1/2)-1","v":0.47579928821457629},{"$f":"POWER('Calculated Data'!F33/'Calculated Data'!D33, 1/2)-1","v":2.3141994702574813},{"$f":"POWER('Calculated Data'!G33/'Calculated Data'!E33, 1/2)-1","v":1.0869163017353496},{"$f":"POWER('Calculated Data'!H33/'Calculated Data'!F33, 1/2)-1","v":-0.56418187076762993},{"$f":"POWER('Calculated Data'!I33/'Calculated Data'!G33, 1/2)-1","v":-0.21511016012594031},{"$f":"POWER('Calculated Data'!J33/'Calculated Data'!H33, 1/2)-1","v":3.8984072751473553},{"$f":"POWER('Calculated Data'!K33/'Calculated Data'!I33, 1/2)-1","v":2.0065948639709243}]
[]
[]
["Sales/Invested Capital =Capital Turns",{"$f":"'Data Sheet'!B17/'Calculated Data'!B13","v":1.0433096315449257},{"$f":"'Data Sheet'!C17/'Calculated Data'!C13","v":1.0920977176281683},{"$f":"'Data Sheet'!D17/'Calculated Data'!D13","v":1.1033597499720951},{"$f":"'Data Sheet'!E17/'Calculated Data'!E13","v":1.3101468477420779},{"$f":"'Data Sheet'!F17/'Calculated Data'!F13","v":1.4113544926240502},{"$f":"'Data Sheet'!G17/'Calculated Data'!G13","v":1.3809625821193945},{"$f":"'Data Sheet'!H17/'Calculated Data'!H13","v":1.4413734698591116},{"$f":"'Data Sheet'!I17/'Calculated Data'!I13","v":1.2960936505916782},{"$f":"'Data Sheet'!J17/'Calculated Data'!J13","v":1.379678916663118},{"$f":"'Data Sheet'!K17/'Calculated Data'!K13","v":1.4793184778399691}]
["Sales/Fixed Assets= Fixed Asset Turns",{"$f":"'Data Sheet'!B17/'Data Sheet'!B62","v":4.0189243027888448},{"$f":"'Data Sheet'!C17/'Data Sheet'!C62","v":2.7409326424870466},{"$f":"'Data Sheet'!D17/'Data Sheet'!D62","v":3.0229357798165135},{"$f":"'Data Sheet'!E17/'Data Sheet'!E62","v":2.7531322505800464},{"$f":"'Data Sheet'!F17/'Data Sheet'!F62","v":3.4924778761061948},{"$f":"'Data Sheet'!G17/'Data Sheet'!G62","v":4.269094922737307},{"$f":"'Data Sheet'!H17/'Data Sheet'!H62","v":4.1228804228143581},{"$f":"'Data Sheet'!I17/'Data Sheet'!I62","v":4.4636283961437337},{"$f":"'Data Sheet'!J17/'Data Sheet'!J62","v":4.1026972267949855},{"$f":"'Data Sheet'!K17/'Data Sheet'!K62","v":4.1154637156008231}]
["Sales/Total Assets= Asset Turns",{"$f":"'Data Sheet'!B17/'Calculated Data'!B15","v":0.71132657558395773},{"$f":"'Data Sheet'!C17/'Calculated Data'!C15","v":0.74905601006922584},{"$f":"'Data Sheet'!D17/'Calculated Data'!D15","v":0.78080568720379151},{"$f":"'Data Sheet'!E17/'Calculated Data'!E15","v":1.0070440465076806},{"$f":"'Data Sheet'!F17/'Calculated Data'!F15","v":1.063388346244527},{"$f":"'Data Sheet'!G17/'Calculated Data'!G15","v":1.0983699664906004},{"$f":"'Data Sheet'!H17/'Calculated Data'!H15","v":1.1586113002042204},{"$f":"'Data Sheet'!I17/'Calculated Data'!I15","v":0.93385285354114134},{"$f":"'Data Sheet'!J17/'Calculated Data'!J15","v":1.0743798912322589},{"$f":"'Data Sheet'!K17/'Calculated Data'!K15","v":1.1618513091321299},{"$f":"'Profit & Loss'!L4/'Balance Sheet'!L8","v":{"$error":"#DIV/0!"}}]
["Net Margin*Asset Turns= RoA",{"$f":"B39*B51","v":3.1115028646981048E-2},{"$f":"C39*C51","v":3.8860918816865951E-2},3.2464454976303327E-2,7.3156242043622172E-2,0.10771303469181545,0.13108422786391777,7.8965282505105497E-2,0.11070364428145769,0.17237034089401773,0.20191324062042082,{"$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":6.2811387900355856E-2},8.1143232588699085E-2,6.324049853823667E-2,0.12099943851768669,0.18752198897619327,0.21868485882129998,0.11064862989941032,0.17470881863560728,0.27770060903942723,0.28638092623818673,{"$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.6939291736930857E-2},{"$f":"'Calculated Data'!C4/'Calculated Data'!C14","v":0.11082523346674289},{"$f":"'Calculated Data'!D4/'Calculated Data'!D14","v":9.6771191960547134E-2},{"$f":"'Calculated Data'!E4/'Calculated Data'!E14","v":0.16499799759711653},{"$f":"'Calculated Data'!F4/'Calculated Data'!F14","v":0.20774182898646415},{"$f":"'Calculated Data'!G4/'Calculated Data'!G14","v":0.2400372563369037},{"$f":"'Calculated Data'!H4/'Calculated Data'!H14","v":0.13847470928158667},{"$f":"'Calculated Data'!I4/'Calculated Data'!I14","v":0.20469337791843312},{"$f":"'Calculated Data'!J4/'Calculated Data'!J14","v":0.29593668407310708},{"$f":"'Calculated Data'!K4/'Calculated Data'!K14","v":0.33878307222258336}]
["EBIT Margin*Cap Turns*(1-Tax rate)= RoIC",{"$f":"B36*B49*(1-'Calculated Data'!B22)","v":8.0436868358816804E-2},{"$f":"C36*C49*(1-'Calculated Data'!C22)","v":7.816501424399093E-2},{"$f":"D36*D49*(1-'Calculated Data'!D22)","v":7.3579640584886696E-2},{"$f":"E36*E49*(1-'Calculated Data'!E22)","v":0.11238625957173198},{"$f":"F36*F49*(1-'Calculated Data'!F22)","v":0.1646059513930441},{"$f":"G36*G49*(1-'Calculated Data'!G22)","v":0.18296451563289612},{"$f":"H36*H49*(1-'Calculated Data'!H22)","v":0.1157728951259164},{"$f":"I36*I49*(1-'Calculated Data'!I22)","v":0.16131601248419941},{"$f":"J36*J49*(1-'Calculated Data'!J22)","v":0.23006244176052573},{"$f":"K36*K49*(1-'Calculated Data'!K22)","v":0.27457649008799617},{"$f":"'Business Robustness'!L14*'Business Robustness'!L16*(1-'Calculated Data'!K22)","v":0.51566657286098427},"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":-2.2683698367232545E-2},{"$f":"'Calculated Data'!E27","v":1.4945098039215652},{"$f":"'Calculated Data'!F27","v":8.400359320306432},{"$f":"'Calculated Data'!G27","v":0.33887101061648417},{"$f":"'Calculated Data'!H27","v":-0.37547390639678913},{"$f":"'Calculated Data'!I27","v":-1.0165428073262242},{"$f":"'Calculated Data'!J27","v":1.0505647620504863},{"$f":"'Calculated Data'!K27","v":0.3087363855849688}]
[{"$f":"'Calculated Data'!A28","v":"3Yr Rolling RoIIC "},null,null,null,null,null,{"$f":"'Calculated Data'!G28","v":0.77170927693555424},{"$f":"'Calculated Data'!H28","v":9.6311552398285774E-2},{"$f":"'Calculated Data'!I28","v":0.17661432296425436},{"$f":"'Calculated Data'!J28","v":0.62658752326039002},{"$f":"'Calculated Data'!K28","v":0.66421776760620099},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.13116180819862361},{"$f":"'Calculated Data'!I29","v":0.43942976211396884},{"$f":"'Calculated Data'!J29","v":0.64871637326841969},{"$f":"'Calculated Data'!K29","v":0.413058144156281},null,"better to check when NOPLAT and/or Investments are Lumpy"]
[]
["Altman Z-Score",{"$f":"'Calculated Data'!B50","v":1.4679594535037461},{"$f":"'Calculated Data'!C50","v":1.8272759597230961},{"$f":"'Calculated Data'!D50","v":1.7831203791469195},{"$f":"'Calculated Data'!E50","v":2.6184462361028604},{"$f":"'Calculated Data'!F50","v":4.0016994274166393},{"$f":"'Calculated Data'!G50","v":4.3544567501561877},{"$f":"'Calculated Data'!H50","v":2.4579003651216036},{"$f":"'Calculated Data'!I50","v":2.9696759110703641},{"$f":"'Calculated Data'!J50","v":6.6058973338639069},{"$f":"'Calculated Data'!K50","v":7.8686283834222692}]
["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.11136890951276103},{"$f":"'Data Sheet'!F31/'Data Sheet'!F30","v":0.14383989993746091},{"$f":"'Data Sheet'!G31/'Data Sheet'!G30","v":9.965337954939342E-2},{"$f":"'Data Sheet'!H31/'Data Sheet'!H30","v":9.0125391849529779E-2},{"$f":"'Data Sheet'!I31/'Data Sheet'!I30","v":9.5238095238095233E-2},{"$f":"'Data Sheet'!J31/'Data Sheet'!J30","v":7.3874567141208158E-2},{"$f":"'Data Sheet'!K31/'Data Sheet'!K30","v":9.4618649869916471E-2}]
["Cash/Assets",{"$f":"'Data Sheet'!B69/'Data Sheet'!B61","v":3.4376377258704275E-3},{"$f":"'Data Sheet'!C69/'Data Sheet'!C61","v":2.9106356198867209E-3},{"$f":"'Data Sheet'!D69/'Data Sheet'!D61","v":6.4612954186413898E-2},{"$f":"'Data Sheet'!E69/'Data Sheet'!E61","v":9.2506152932190448E-3},{"$f":"'Data Sheet'!F69/'Data Sheet'!F61","v":2.3576961940047153E-3},{"$f":"'Data Sheet'!G69/'Data Sheet'!G61","v":2.7829840404384621E-3},{"$f":"'Data Sheet'!H69/'Data Sheet'!H61","v":2.599170740763661E-3},{"$f":"'Data Sheet'!I69/'Data Sheet'!I61","v":7.3023149209259675E-2},{"$f":"'Data Sheet'!J69/'Data Sheet'!J61","v":3.9196179864703543E-2},{"$f":"'Data Sheet'!K69/'Data Sheet'!K61","v":4.7167463850258502E-2}]
["EBIT/Invested Capital",{"$f":"'Calculated Data'!B4/'Calculated Data'!B13","v":9.4376212023270845E-2},{"$f":"'Calculated Data'!C4/'Calculated Data'!C13","v":0.13338685629085903},{"$f":"'Calculated Data'!D4/'Calculated Data'!D13","v":0.11608438441790378},{"$f":"'Calculated Data'!E4/'Calculated Data'!E13","v":0.18195870597328034},{"$f":"'Calculated Data'!F4/'Calculated Data'!F13","v":0.22503352704514976},{"$f":"'Calculated Data'!G4/'Calculated Data'!G13","v":0.25764067409311625},{"$f":"'Calculated Data'!H4/'Calculated Data'!H13","v":0.14943413657710372},{"$f":"'Calculated Data'!I4/'Calculated Data'!I13","v":0.21809390507698181},{"$f":"'Calculated Data'!J4/'Calculated Data'!J13","v":0.30890431375888944},{"$f":"'Calculated Data'!K4/'Calculated Data'!K13","v":0.36691660506213258},null,"Check back the significant role of EBIT/Invested Capital "]
["EPA",{"$f":"'Calculated Data'!B26","v":-3.0602082324455195},{"$f":"'Calculated Data'!C26","v":-3.6475924080664304},{"$f":"'Calculated Data'!D26","v":-4.1588000000000003},{"$f":"'Calculated Data'!E26","v":-0.68957647058823379},{"$f":"'Calculated Data'!F26","v":4.9891756633119853},{"$f":"'Calculated Data'!G26","v":8.8175507692307686},{"$f":"'Calculated Data'!H26","v":-0.54905865209471594},{"$f":"'Calculated Data'!I26","v":6.4940508422664642},{"$f":"'Calculated Data'!J26","v":25.845963198624258},{"$f":"'Calculated Data'!K26","v":43.910543539297073},null,"Check back what is really driving EPA (Invested Capital or RoIC, or both)"]
["MktCap",{"$f":"'Calculated Data'!B33","v":15.84},{"$f":"'Calculated Data'!C33","v":55.987200000000001},{"$f":"'Calculated Data'!D33","v":39.398399999999995},{"$f":"'Calculated Data'!E33","v":121.9392},{"$f":"'Calculated Data'!F33","v":432.74879999999996},{"$f":"'Calculated Data'!G33","v":531.072},{"$f":"'Calculated Data'!H33","v":82.1952},{"$f":"'Calculated Data'!I33","v":327.16799999999995},{"$f":"'Calculated Data'!J33","v":1972.2239999999997},{"$f":"'Calculated Data'!K33","v":2957.4720000000002},{"$f":"'Data Sheet'!B9","v":3038.91}]
["MktCap Change",null,{"$f":"C65-B65","v":40.147199999999998},{"$f":"D65-C65","v":-16.588800000000006},82.540800000000004,310.80959999999993,98.323200000000043,-448.8768,244.97279999999995,1645.0559999999998,985.2480000000005,81.437999999999647]
["MktCap Change - EPA",null,{"$f":"C66-C64","v":43.794792408066428},-12.430000000000007,83.23037647058824,305.82042433668795,89.505649230769279,-448.32774134790526,238.47874915773349,1619.2100368013755,941.33745646070338,81.437999999999647]
[]
["Capex/Net Profits 10 yr",{"$f":"SUM('Calculated Data'!B$18:K$18)/SUM('Calculated Data'!B$7:K$7)","v":0.51667491786309017}]
["Capex/Net Profits 7 yr",{"$f":"SUM('Calculated Data'!E$18:K$18)/SUM('Calculated Data'!E$7:K$7)","v":0.51967940460855877}]
["Capex/Net Profits 5 yr",{"$f":"SUM('Calculated Data'!G$18:K$18)/SUM('Calculated Data'!G$7:K$7)","v":0.46913513513513511}]
["Capex/Net Profits 3 yr",{"$f":"SUM('Calculated Data'!I$18:K$18)/SUM('Calculated Data'!I$7:K$7)","v":0.42169482434969163}]
["Capex/Depreciation 10 yr",{"$f":"SUM('Calculated Data'!B$18:K$18)/SUM('Data Sheet'!B26:K26)","v":2.2969187675070031}]

{"sheet":"Data Sheet","index":5,"n_rows":93,"n_cols":12,"rows_kept":93,"cut":false,"hidden":false,"merged":[[0,4,0,10],[1,4,1,10]]}
["COMPANY NAME","SHIVALIK BIMETAL CONTROLS 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":5.7604208131930621}]
["Face Value",2]
["Current Price",527.54999999999995]
["Market Capitalization",3038.91]
[]
[]
[]
[]
[]
["PROFIT & LOSS"]
["Report Date","2014-03-31","2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31"]
["Sales",80.7,95.22,98.85,118.66,157.86000000000001,193.39,187.22,203.72,323.99,420.23]
["Raw Material Cost",48.92,57.75,56.08,64.88,89.53,108.66,97.82,112.89,172.06,224.06]
["Change in Inventory",0.86,2.0699999999999998,-1.94,2.84,7.9,12.78,-9.36,11.61,11,18.07]
["Power and Fuel",1.2,1.29,1.65,1.91,2.02,2.04,2.06,2.16,2.9,4.03]
["Other Mfr. Exp",4.01,4.01,4.58,8.42,8.23,8,7.19,13.5,15.14,19.38]
["Employee Cost",8.7100000000000009,10.28,11.5,12.41,14.48,16.920000000000002,20.02,22.23,27.11,33.950000000000003]
["Selling and admin",7.81,8.4700000000000006,8.86,14.71,25.51,33.549999999999997,28.96,27.43,43.03,50.41]
["Other Expenses",-0.09,0.14000000000000001,0.72,0.19,0.35,1.42,1.04,0.99,1.28,1.7]
["Other Income",-1.35,-0.55000000000000004,0.56999999999999995,2.04,4.1500000000000004,5.35,4.6500000000000004,4.05,5.45,7.93]
["Depreciation",2.35,3.17,3.69,4.54,4.62,4.8499999999999996,6.01,5.9,6.38,8.4700000000000006]
["Interest",3.17,3.2,3.9,2.54,3.31,3.58,2.94,1.63,2.76,6.64]
["Profit before tax",4.13,8.43,6.5,13.94,21.86,32.5,16.47,32.65,69.78,97.59]
["Tax",0.61,3.49,2.38,5.33,5.87,9.42,3.71,8.5,17.809999999999999,24.56]
["Net profit",3.53,4.9400000000000004,4.1100000000000003,8.6199999999999992,15.99,23.08,12.76,24.15,51.98,73.03]
["Dividend Amount",null,null,null,0.96,2.2999999999999998,2.2999999999999998,1.1499999999999999,2.2999999999999998,3.84,6.91]
[]
[]
[]
[]
[]
[]
[]
[]
["Quarters"]
["Report Date","2021-03-31","2021-06-30","2021-09-30","2021-12-31","2022-03-31","2022-06-30","2022-09-30","2022-12-31","2023-03-31","2023-06-30"]
["Sales",66.86,70.31,76.23,88.13,89.32,97.69,104.87,107.54,110.13,113.07]
["Expenses",54.2,54.45,58.4,67.569999999999993,70.09,73.44,79.16,79.75,83.11,84.07]
["Other Income",1.1599999999999999,0.85,1.22,1.85,1.53,2.2400000000000002,3.37,0.7,1.62,1.34]
["Depreciation",1.56,1.42,1.49,1.6,1.86,1.95,2.0699999999999998,2.2200000000000002,2.2400000000000002,2.44]
["Interest",0.49,0.44,0.37,0.76,1.2,1.52,1.72,1.81,1.59,1.1299999999999999]
["Profit before tax",11.77,14.85,17.190000000000001,20.05,17.7,23.02,25.29,24.46,24.81,26.77]
["Tax",3.2,3.66,4.37,5.36,4.43,5.9,6.53,6.22,5.91,6.54]
["Net profit",8.57,11.18,12.83,14.7,13.27,17.11,18.760000000000002,18.25,18.899999999999999,20.23]
["Operating Profit",12.66,15.86,17.829999999999998,20.56,19.23,24.25,25.71,27.79,27.02,29]
[]
[]
[]
[]
["BALANCE SHEET"]
["Report Date","2014-03-31","2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31"]
["Equity Share Capital",3.84,3.84,3.84,3.84,7.68,7.68,7.68,7.68,7.68,11.52]
["Reserves",52.36,57.04,61.15,67.400000000000006,77.59,97.86,107.64,130.55000000000001,179.5,243.49]
["Borrowings",38.68,44.06,42.48,28.64,35.89,44.77,24.85,29.24,57.94,52.65]
["Other Liabilities",18.57,22.18,19.13,17.95,27.29,25.76,21.42,50.68,56.44,54.03]
["Total",113.45,127.12,126.6,117.83,148.44999999999999,176.07,161.59,218.15,301.56,361.69]
["Net Block",20.079999999999998,34.74,32.700000000000003,43.1,45.2,45.3,45.41,45.64,78.97,102.11]
["Capital Work in Progress",17.850000000000001,3.97,4.24,4.47,4.72,5.99,17.54,24.79,7.55,2.99]
["Investments",17.53,17.75,17.88,9.31,9.31,10.27,10.28,10.29,10.29,23.59]
["Other Assets",57.99,70.66,71.78,60.95,89.22,114.51,88.36,137.43,204.75,233,158.24]
["Total",113.45,127.12,126.6,117.83,148.44999999999999,176.07,161.59,218.15,301.56,361.69]
["Receivables",21.74,24.08,24.08,26.42,33.590000000000003,34.58,30.95,42.82,59.28,79.98,75.67]
["Inventory",18.61,28.8,23.38,26.07,40.6,69.27,50.52,70.14,114.88,121.88]
["Cash & Bank",0.39,0.37,8.18,1.0900000000000001,0.35,0.49,0.42,15.93,11.82,17.059999999999999]
["No. of Equity Shares",19201400,19201400,19201400,19201400,38402800,38402800,38402800,38402800,38402800,57604200]
["New Bonus Shares"]
["Face value",2,2,2,2,2,2,2,2,2,2]
[]
[]
[]
[]
[]
[]
[]
["CASH FLOW:"]
["Report Date","2014-03-31","2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31"]
["Cash from Operating Activity",9.61,2.74,15.48,11.73,5.64,3.76,41.24,29.49,-3.48,61.22]
["Cash from Investing Activity",-4.51,-4.9000000000000004,-2.11,-3.1,-7.09,-7.08,-14.45,-14.72,-24.18,-37.47]
["Cash from Financing Activity",-5.0999999999999996,2.13,-5.55,-16.57,1.49,3.49,-26.91,0.62,22.87,-17.78]
["Net Cash Flow",null,-0.03,7.81,-7.94,0.05,0.17,-0.12,15.39,-4.79,5.97]
[]
[]
[]
[]
["PRICE:",2.75,9.7200000000000006,6.84,21.17,75.13,92.2,14.27,56.8,342.4,513.45000000000005]
[]
["DERIVED:"]
["Adjusted Equity Shares in Cr",5.76,5.76,5.76,5.76,5.76,5.76,5.76,5.76,5.76,5.76]

{"sheet":"Calculated Data","index":6,"n_rows":53,"n_cols":14,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Data Sheet'!B1","v":"SHIVALIK BIMETAL CONTROLS LTD"}]
[{"$f":"A1","v":"SHIVALIK BIMETAL CONTROLS LTD"},{"$f":"'Data Sheet'!B16","v":"2014-03-31"},{"$f":"'Data Sheet'!C16","v":"2015-03-31"},{"$f":"'Data Sheet'!D16","v":"2016-03-31"},{"$f":"'Data Sheet'!E16","v":"2017-03-31"},{"$f":"'Data Sheet'!F16","v":"2018-03-31"},{"$f":"'Data Sheet'!G16","v":"2019-03-31"},{"$f":"'Data Sheet'!H16","v":"2020-03-31"},{"$f":"'Data Sheet'!I16","v":"2021-03-31"},{"$f":"'Data Sheet'!J16","v":"2022-03-31"},{"$f":"'Data Sheet'!K16","v":"2023-03-31"},"TTM"]
["Gross Profit",{"$f":"'Data Sheet'!B17-'Data Sheet'!B18","v":31.78},{"$f":"'Data Sheet'!C17-'Data Sheet'!C18","v":37.47},{"$f":"'Data Sheet'!D17-'Data Sheet'!D18","v":42.769999999999996},{"$f":"'Data Sheet'!E17-'Data Sheet'!E18","v":53.78},{"$f":"'Data Sheet'!F17-'Data Sheet'!F18","v":68.330000000000013},{"$f":"'Data Sheet'!G17-'Data Sheet'!G18","v":84.72999999999999},{"$f":"'Data Sheet'!H17-'Data Sheet'!H18","v":89.4},{"$f":"'Data Sheet'!I17-'Data Sheet'!I18","v":90.83},{"$f":"'Data Sheet'!J17-'Data Sheet'!J18","v":151.93},{"$f":"'Data Sheet'!K17-'Data Sheet'!K18","v":196.17000000000002}]
["EBIT",{"$f":"'Data Sheet'!B28+'Data Sheet'!B27","v":7.3},{"$f":"'Data Sheet'!C28+'Data Sheet'!C27","v":11.629999999999999},{"$f":"'Data Sheet'!D28+'Data Sheet'!D27","v":10.4},{"$f":"'Data Sheet'!E28+'Data Sheet'!E27","v":16.48},{"$f":"'Data Sheet'!F28+'Data Sheet'!F27","v":25.169999999999998},{"$f":"'Data Sheet'!G28+'Data Sheet'!G27","v":36.08},{"$f":"'Data Sheet'!H28+'Data Sheet'!H27","v":19.41},{"$f":"'Data Sheet'!I28+'Data Sheet'!I27","v":34.28},{"$f":"'Data Sheet'!J28+'Data Sheet'!J27","v":72.540000000000006},{"$f":"'Data Sheet'!K28+'Data Sheet'!K27","v":104.23},{"$f":"'Profit & Loss'!L17","v":107.58}]
["EBITDA",{"$f":"'Calculated Data'!B4+'Data Sheet'!B26","v":9.65},{"$f":"'Calculated Data'!C4+'Data Sheet'!C26","v":14.799999999999999},{"$f":"'Calculated Data'!D4+'Data Sheet'!D26","v":14.09},{"$f":"'Calculated Data'!E4+'Data Sheet'!E26","v":21.02},{"$f":"'Calculated Data'!F4+'Data Sheet'!F26","v":29.79},{"$f":"'Calculated Data'!G4+'Data Sheet'!G26","v":40.93},{"$f":"'Calculated Data'!H4+'Data Sheet'!H26","v":25.42},{"$f":"'Calculated Data'!I4+'Data Sheet'!I26","v":40.18},{"$f":"'Calculated Data'!J4+'Data Sheet'!J26","v":78.92},{"$f":"'Calculated Data'!K4+'Data Sheet'!K26","v":112.7},{"$f":"'Profit & Loss'!L18","v":116.55}]
["Operating Profit (excl Other Income)",{"$f":"B5-'Data Sheet'!B25","v":11},{"$f":"C5-'Data Sheet'!C25","v":15.35},{"$f":"D5-'Data Sheet'!D25","v":13.52},{"$f":"E5-'Data Sheet'!E25","v":18.98},{"$f":"F5-'Data Sheet'!F25","v":25.64},{"$f":"G5-'Data Sheet'!G25","v":35.58},{"$f":"H5-'Data Sheet'!H25","v":20.770000000000003},{"$f":"I5-'Data Sheet'!I25","v":36.130000000000003},{"$f":"J5-'Data Sheet'!J25","v":73.47},{"$f":"K5-'Data Sheet'!K25","v":104.77000000000001},{"$f":"'Profit & Loss'!L19","v":109.52}]
["PAT",{"$f":"'Data Sheet'!B30","v":3.53},{"$f":"'Data Sheet'!C30","v":4.9400000000000004},{"$f":"'Data Sheet'!D30","v":4.1100000000000003},{"$f":"'Data Sheet'!E30","v":8.6199999999999992},{"$f":"'Data Sheet'!F30","v":15.99},{"$f":"'Data Sheet'!G30","v":23.08},{"$f":"'Data Sheet'!H30","v":12.76},{"$f":"'Data Sheet'!I30","v":24.15},{"$f":"'Data Sheet'!J30","v":51.98},{"$f":"'Data Sheet'!K30","v":73.03},{"$f":"'Profit & Loss'!L12","v":76.14}]
["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.96},{"$f":"'Data Sheet'!F31","v":2.2999999999999998},{"$f":"'Data Sheet'!G31","v":2.2999999999999998},{"$f":"'Data Sheet'!H31","v":1.1499999999999999},{"$f":"'Data Sheet'!I31","v":2.2999999999999998},{"$f":"'Data Sheet'!J31","v":3.84},{"$f":"'Data Sheet'!K31","v":6.91}]
[null,{"$f":"B2","v":"2014-03-31"},"2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31","1HFY17"]
["Networth",{"$f":"'Data Sheet'!B57+'Data Sheet'!B58","v":56.2},{"$f":"'Data Sheet'!C57+'Data Sheet'!C58","v":60.879999999999995},{"$f":"'Data Sheet'!D57+'Data Sheet'!D58","v":64.989999999999995},{"$f":"'Data Sheet'!E57+'Data Sheet'!E58","v":71.240000000000009},{"$f":"'Data Sheet'!F57+'Data Sheet'!F58","v":85.27000000000001},{"$f":"'Data Sheet'!G57+'Data Sheet'!G58","v":105.53999999999999},{"$f":"'Data Sheet'!H57+'Data Sheet'!H58","v":115.32},{"$f":"'Data Sheet'!I57+'Data Sheet'!I58","v":138.23000000000002},{"$f":"'Data Sheet'!J57+'Data Sheet'!J58","v":187.18},{"$f":"'Data Sheet'!K57+'Data Sheet'!K58","v":255.01000000000002},{"$f":"'Balance Sheet'!L4+'Balance Sheet'!L5","v":0}]
["Working Capital",{"$f":"'Data Sheet'!B65-'Data Sheet'!B60","v":39.42},{"$f":"'Data Sheet'!C65-'Data Sheet'!C60","v":48.48},{"$f":"'Data Sheet'!D65-'Data Sheet'!D60","v":52.650000000000006},{"$f":"'Data Sheet'!E65-'Data Sheet'!E60","v":43},{"$f":"'Data Sheet'!F65-'Data Sheet'!F60","v":61.93},{"$f":"'Data Sheet'!G65-'Data Sheet'!G60","v":88.75},{"$f":"'Data Sheet'!H65-'Data Sheet'!H60","v":66.94},{"$f":"'Data Sheet'!I65-'Data Sheet'!I60","v":86.75},{"$f":"'Data Sheet'!J65-'Data Sheet'!J60","v":148.31},{"$f":"'Data Sheet'!K65-'Data Sheet'!K60","v":178.97},{"$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":77.349999999999994},{"$f":"'Data Sheet'!C62+'Data Sheet'!C63+('Data Sheet'!C65-'Data Sheet'!C60)","v":87.19},{"$f":"'Data Sheet'!D62+'Data Sheet'!D63+('Data Sheet'!D65-'Data Sheet'!D60)","v":89.59},{"$f":"'Data Sheet'!E62+'Data Sheet'!E63+('Data Sheet'!E65-'Data Sheet'!E60)","v":90.57},{"$f":"'Data Sheet'!F62+'Data Sheet'!F63+('Data Sheet'!F65-'Data Sheet'!F60)","v":111.85},{"$f":"'Data Sheet'!G62+'Data Sheet'!G63+('Data Sheet'!G65-'Data Sheet'!G60)","v":140.04},{"$f":"'Data Sheet'!H62+'Data Sheet'!H63+('Data Sheet'!H65-'Data Sheet'!H60)","v":129.88999999999999},{"$f":"'Data Sheet'!I62+'Data Sheet'!I63+('Data Sheet'!I65-'Data Sheet'!I60)","v":157.18},{"$f":"'Data Sheet'!J62+'Data Sheet'!J63+('Data Sheet'!J65-'Data Sheet'!J60)","v":234.82999999999998},{"$f":"'Data Sheet'!K62+'Data Sheet'!K63+('Data Sheet'!K65-'Data Sheet'!K60)","v":284.07},{"$f":"'Balance Sheet'!L10+'Balance Sheet'!L11+('Data Sheet'!L65-'Data Sheet'!L67)","v":156.12}]
["Capital Employed",{"$f":"B10+'Data Sheet'!B59","v":94.88},{"$f":"C10+'Data Sheet'!C59","v":104.94},{"$f":"D10+'Data Sheet'!D59","v":107.47},{"$f":"E10+'Data Sheet'!E59","v":99.88000000000001},{"$f":"F10+'Data Sheet'!F59","v":121.16000000000001},{"$f":"G10+'Data Sheet'!G59","v":150.31},{"$f":"H10+'Data Sheet'!H59","v":140.16999999999999},{"$f":"I10+'Data Sheet'!I59","v":167.47000000000003},{"$f":"J10+'Data Sheet'!J59","v":245.12},{"$f":"K10+'Data Sheet'!K59","v":307.66000000000003}]
["Total Assets",{"$f":"'Data Sheet'!B61","v":113.45},{"$f":"'Data Sheet'!C61","v":127.12},{"$f":"'Data Sheet'!D61","v":126.6},{"$f":"'Data Sheet'!E61","v":117.83},{"$f":"'Data Sheet'!F61","v":148.44999999999999},{"$f":"'Data Sheet'!G61","v":176.07},{"$f":"'Data Sheet'!H61","v":161.59},{"$f":"'Data Sheet'!I61","v":218.15},{"$f":"'Data Sheet'!J61","v":301.56},{"$f":"'Data Sheet'!K61","v":361.69},{"$f":"'Balance Sheet'!L8","v":0}]
[null,{"$f":"B2","v":"2014-03-31"},"2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31"]
["Operating Cash Flow",{"$f":"'Data Sheet'!B82","v":9.61},{"$f":"'Data Sheet'!C82","v":2.74},{"$f":"'Data Sheet'!D82","v":15.48},{"$f":"'Data Sheet'!E82","v":11.73},{"$f":"'Data Sheet'!F82","v":5.64},{"$f":"'Data Sheet'!G82","v":3.76},{"$f":"'Data Sheet'!H82","v":41.24},{"$f":"'Data Sheet'!I82","v":29.49},{"$f":"'Data Sheet'!J82","v":-3.48},{"$f":"'Data Sheet'!K82","v":61.22}]
["Capex",null,{"$f":"('Data Sheet'!C62-'Data Sheet'!B62)+('Data Sheet'!C63-'Data Sheet'!B63)+'Data Sheet'!C26","v":3.9500000000000028},{"$f":"('Data Sheet'!D62-'Data Sheet'!C62)+('Data Sheet'!D63-'Data Sheet'!C63)+'Data Sheet'!D26","v":1.9200000000000008},{"$f":"('Data Sheet'!E62-'Data Sheet'!D62)+('Data Sheet'!E63-'Data Sheet'!D63)+'Data Sheet'!E26","v":15.169999999999998},{"$f":"('Data Sheet'!F62-'Data Sheet'!E62)+('Data Sheet'!F63-'Data Sheet'!E63)+'Data Sheet'!F26","v":6.9700000000000015},{"$f":"('Data Sheet'!G62-'Data Sheet'!F62)+('Data Sheet'!G63-'Data Sheet'!F63)+'Data Sheet'!G26","v":6.2199999999999944},{"$f":"('Data Sheet'!H62-'Data Sheet'!G62)+('Data Sheet'!H63-'Data Sheet'!G63)+'Data Sheet'!H26","v":17.669999999999998},{"$f":"('Data Sheet'!I62-'Data Sheet'!H62)+('Data Sheet'!I63-'Data Sheet'!H63)+'Data Sheet'!I26","v":13.380000000000004},{"$f":"('Data Sheet'!J62-'Data Sheet'!I62)+('Data Sheet'!J63-'Data Sheet'!I63)+'Data Sheet'!J26","v":22.47},{"$f":"('Data Sheet'!K62-'Data Sheet'!J62)+('Data Sheet'!K63-'Data Sheet'!J63)+'Data Sheet'!K26","v":27.050000000000004},null,"CHECK?","derived from BS"]
["Free Cash Flow",null,{"$f":"C17-C18","v":-1.2100000000000026},{"$f":"D17-D18","v":13.559999999999999},-3.4399999999999977,-1.3300000000000018,-2.4599999999999946,23.570000000000004,16.109999999999992,-25.95,34.169999999999995]
["RoE",{"$f":"Customization!B53","v":6.2811387900355856E-2},{"$f":"Customization!C53","v":8.1143232588699085E-2},{"$f":"Customization!D53","v":6.324049853823667E-2},{"$f":"Customization!E53","v":0.12099943851768669},{"$f":"Customization!F53","v":0.18752198897619327},{"$f":"Customization!G53","v":0.21868485882129998},{"$f":"Customization!H53","v":0.11064862989941032},{"$f":"Customization!I53","v":0.17470881863560728},{"$f":"Customization!J53","v":0.27770060903942723},{"$f":"Customization!K53","v":0.28638092623818673}]
["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.11136890951276103},{"$f":"'Profit & Loss'!F23","v":0.14383989993746091},{"$f":"'Profit & Loss'!G23","v":9.965337954939342E-2},{"$f":"'Profit & Loss'!H23","v":9.0125391849529779E-2},{"$f":"'Profit & Loss'!I23","v":9.5238095238095233E-2},{"$f":"'Profit & Loss'!J23","v":7.3874567141208158E-2},{"$f":"'Profit & Loss'!K23","v":9.4618649869916471E-2}]
["Tax Rate",{"$f":"'Data Sheet'!B29/'Data Sheet'!B28","v":0.14769975786924938},{"$f":"'Data Sheet'!C29/'Data Sheet'!C28","v":0.41399762752075925},{"$f":"'Data Sheet'!D29/'Data Sheet'!D28","v":0.36615384615384616},{"$f":"'Data Sheet'!E29/'Data Sheet'!E28","v":0.38235294117647062},{"$f":"'Data Sheet'!F29/'Data Sheet'!F28","v":0.26852698993595608},{"$f":"'Data Sheet'!G29/'Data Sheet'!G28","v":0.28984615384615386},{"$f":"'Data Sheet'!H29/'Data Sheet'!H28","v":0.22525804493017609},{"$f":"'Data Sheet'!I29/'Data Sheet'!I28","v":0.26033690658499237},{"$f":"'Data Sheet'!J29/'Data Sheet'!J28","v":0.25523072513614214},{"$f":"'Data Sheet'!K29/'Data Sheet'!K28","v":0.25166512962393683},{"$f":"K22","v":0.25166512962393683}]
["NOPLAT",{"$f":"B4*(1-B22)","v":6.2217917675544792},6.8152075919335688,6.5920000000000005,10.178823529411765,18.411175663311983,25.622350769230767,15.037741347905282,25.355650842266463,54.025563198624255,77.998943539297073]
["RoIC",{"$f":"(B4/B13)*(1-B22)","v":8.0436868358816804E-2},{"$f":"(C4/C13)*(1-C22)","v":7.816501424399093E-2},7.3579640584886696E-2,0.11238625957173198,0.16460595139304413,0.18296451563289609,0.11577289512591642,0.16131601248419941,0.23006244176052573,0.27457649008799617,0.51566657286098427]
["WACC",0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,{"$f":"K25","v":0.12}]
["EPA (Economic Profit Added)",{"$f":"B13*(B24-B25)","v":-3.0602082324455195},{"$f":"C13*(C24-C25)","v":-3.6475924080664304},-4.1588000000000003,-0.68957647058823379,4.9891756633119853,8.8175507692307686,-0.54905865209471594,6.4940508422664642,25.845963198624258,43.910543539297073,61.771465355056868]
["RoIIC",null,null,{"$f":"(D23-C23)/(C13-B13)","v":-2.2683698367232545E-2},{"$f":"(E23-D23)/(D13-C13)","v":1.4945098039215652},8.400359320306432,0.33887101061648417,-0.37547390639678913,-1.0165428073262242,1.0505647620504863,0.3087363855849688]
["3Yr Rolling RoIIC ",null,null,null,null,null,{"$f":"(G23-D23)/(F13-C13)","v":0.77170927693555424},9.6311552398285774E-2,0.17661432296425436,0.62658752326039002,{"$f":"(K23-H23)/(J13-G13)","v":0.66421776760620099}]
["5Yr Rolling RoIIC",null,null,null,null,null,null,{"$f":"(H23-C23)/(G13-B13)","v":0.13116180819862361},{"$f":"(I23-D23)/(H13-C13)","v":0.43942976211396884},0.64871637326841969,{"$f":"(K23-F23)/(J13-E13)","v":0.413058144156281}]
["Operating Leverage",null,{"$f":"IF(C4-B4>0,((C4-B4)/B4)/(('Data Sheet'!C17-'Data Sheet'!B17)/'Data Sheet'!B17), \"\")","v":3.2966432695573422},{"$f":"IF(D4-C4>0,((D4-C4)/C4)/(('Data Sheet'!D17-'Data Sheet'!C17)/'Data Sheet'!C17), \"\")","v":""},{"$f":"IF(E4-D4>0,((E4-D4)/D4)/(('Data Sheet'!E17-'Data Sheet'!D17)/'Data Sheet'!D17), \"\")","v":2.9171746980934259},{"$f":"IF(F4-E4>0,((F4-E4)/E4)/(('Data Sheet'!F17-'Data Sheet'!E17)/'Data Sheet'!E17), \"\")","v":1.5961762556964523},{"$f":"IF(G4-F4>0,((G4-F4)/F4)/(('Data Sheet'!G17-'Data Sheet'!F17)/'Data Sheet'!F17), \"\")","v":1.9258321209191531},{"$f":"IF(H4-G4>0,((H4-G4)/G4)/(('Data Sheet'!H17-'Data Sheet'!G17)/'Data Sheet'!G17), \"\")","v":""},{"$f":"IF(I4-H4>0,((I4-H4)/H4)/(('Data Sheet'!I17-'Data Sheet'!H17)/'Data Sheet'!H17), \"\")","v":8.6926807487549382},{"$f":"IF(J4-I4>0,((J4-I4)/I4)/(('Data Sheet'!J17-'Data Sheet'!I17)/'Data Sheet'!I17), \"\")","v":1.8905166603458052},{"$f":"IF(K4-J4>0,((K4-J4)/J4)/(('Data Sheet'!K17-'Data Sheet'!J17)/'Data Sheet'!J17), \"\")","v":1.4706884423671083}]
["Sustainable Growth Rate",{"$f":"B20*(1-B21)","v":6.2811387900355856E-2},{"$f":"C20*(1-C21)","v":8.1143232588699085E-2},6.324049853823667E-2,0.10752386299831555,0.16054884484578397,0.19689217358347544,0.10067637877211237,0.15806988352745421,0.25718559675178965,0.2592839496490334,null,"coy can grow at this rate safely with internal accruals"]
[null,{"$f":"B2","v":"2014-03-31"},"2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31","CURRENT"]
["MktCap",{"$f":"'Data Sheet'!B90*'Data Sheet'!B93","v":15.84},{"$f":"'Data Sheet'!C90*'Data Sheet'!C93","v":55.987200000000001},{"$f":"'Data Sheet'!D90*'Data Sheet'!D93","v":39.398399999999995},{"$f":"'Data Sheet'!E90*'Data Sheet'!E93","v":121.9392},{"$f":"'Data Sheet'!F90*'Data Sheet'!F93","v":432.74879999999996},{"$f":"'Data Sheet'!G90*'Data Sheet'!G93","v":531.072},{"$f":"'Data Sheet'!H90*'Data Sheet'!H93","v":82.1952},{"$f":"'Data Sheet'!I90*'Data Sheet'!I93","v":327.16799999999995},{"$f":"'Data Sheet'!J90*'Data Sheet'!J93","v":1972.2239999999997},{"$f":"'Data Sheet'!K90*'Data Sheet'!K93","v":2957.4720000000002},{"$f":"'Data Sheet'!B9","v":3038.91}]
["MktCap+Dividend",{"$f":"B33+'Data Sheet'!B31","v":15.84},{"$f":"C33+'Data Sheet'!C31","v":55.987200000000001},{"$f":"D33+'Data Sheet'!D31","v":39.398399999999995},{"$f":"E33+'Data Sheet'!E31","v":122.89919999999999},{"$f":"F33+'Data Sheet'!F31","v":435.04879999999997},{"$f":"G33+'Data Sheet'!G31","v":533.37199999999996},{"$f":"H33+'Data Sheet'!H31","v":83.345200000000006},{"$f":"I33+'Data Sheet'!I31","v":329.46799999999996},{"$f":"J33+'Data Sheet'!J31","v":1976.0639999999996},{"$f":"K33+'Data Sheet'!K31","v":2964.3820000000001}]
["Retained Profit",{"$f":"'Data Sheet'!B30-'Data Sheet'!B31","v":3.53},{"$f":"'Data Sheet'!C30-'Data Sheet'!C31","v":4.9400000000000004},{"$f":"'Data Sheet'!D30-'Data Sheet'!D31","v":4.1100000000000003},{"$f":"'Data Sheet'!E30-'Data Sheet'!E31","v":7.6599999999999993},{"$f":"'Data Sheet'!F30-'Data Sheet'!F31","v":13.690000000000001},{"$f":"'Data Sheet'!G30-'Data Sheet'!G31","v":20.779999999999998},{"$f":"'Data Sheet'!H30-'Data Sheet'!H31","v":11.61},{"$f":"'Data Sheet'!I30-'Data Sheet'!I31","v":21.849999999999998},{"$f":"'Data Sheet'!J30-'Data Sheet'!J31","v":48.14},{"$f":"'Data Sheet'!K30-'Data Sheet'!K31","v":66.12}]
["EV",{"$f":"B33+'Data Sheet'!B59-'Data Sheet'!B69","v":54.129999999999995},{"$f":"C33+'Data Sheet'!C59-'Data Sheet'!C69","v":99.677199999999999},{"$f":"D33+'Data Sheet'!D59-'Data Sheet'!D69","v":73.698399999999992},{"$f":"E33+'Data Sheet'!E59-'Data Sheet'!E69","v":149.48920000000001},{"$f":"F33+'Data Sheet'!F59-'Data Sheet'!F69","v":468.28879999999992},{"$f":"G33+'Data Sheet'!G59-'Data Sheet'!G69","v":575.35199999999998},{"$f":"H33+'Data Sheet'!H59-'Data Sheet'!H69","v":106.62519999999999},{"$f":"I33+'Data Sheet'!I59-'Data Sheet'!I69","v":340.47799999999995},{"$f":"J33+'Data Sheet'!J59-'Data Sheet'!J69","v":2018.3439999999998},{"$f":"K33+'Data Sheet'!K59-'Data Sheet'!K69","v":2993.0620000000004}]
[null,{"$f":"B2","v":"2014-03-31"},"2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31"]
["Price/Earnings",{"$f":"B33/'Data Sheet'!B30","v":4.4872521246458925},{"$f":"C33/'Data Sheet'!C30","v":11.333441295546558},{"$f":"D33/'Data Sheet'!D30","v":9.5859854014598529},{"$f":"E33/'Data Sheet'!E30","v":14.146078886310907},{"$f":"F33/'Data Sheet'!F30","v":27.0637148217636},{"$f":"G33/'Data Sheet'!G30","v":23.010051993067592},{"$f":"H33/'Data Sheet'!H30","v":6.4416300940438873},{"$f":"I33/'Data Sheet'!I30","v":13.547329192546583},{"$f":"J33/'Data Sheet'!J30","v":37.94197768372451},{"$f":"K33/'Data Sheet'!K30","v":40.496672600301245}]
["Price/Book",{"$f":"B33/B10","v":0.28185053380782915},0.91963206307490153,0.60622249576857978,1.711667602470522,5.0750416324615912,5.0319499715747584,0.71275754422476589,2.3668378788974889,10.536510310930653,11.597474608838869]
["Price/CashFlow",{"$f":"B33/B17","v":1.648283038501561},20.433284671532846,2.545116279069767,10.395498721227622,76.728510638297863,141.24255319148938,1.9930940834141608,11.094201424211596,-566.73103448275856,48.308918654034635]
["Price/Sales",{"$f":"B33/'Data Sheet'!B17","v":0.19628252788104089},{"$f":"C33/'Data Sheet'!C17","v":0.58797731568998113},{"$f":"D33/'Data Sheet'!D17","v":0.39856752655538691},{"$f":"E33/'Data Sheet'!E17","v":1.0276352604078882},{"$f":"F33/'Data Sheet'!F17","v":2.7413454960091217},{"$f":"G33/'Data Sheet'!G17","v":2.7461192409121464},{"$f":"H33/'Data Sheet'!H17","v":0.43903001816045295},{"$f":"I33/'Data Sheet'!I17","v":1.605968977027292},{"$f":"J33/'Data Sheet'!J17","v":6.0872989907095887},{"$f":"K33/'Data Sheet'!K17","v":7.0377459962401545}]
["EV/EBITDA",{"$f":"B36/B5","v":5.6093264248704653},6.7349459459459462,5.2305464868701206,7.1117602283539494,15.719664316884858,14.05697532372343,4.1945397324940989,8.4738178198108507,25.574556512924477,26.55778172138421]
["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":7.8727759407967255E-3},{"$f":"'Data Sheet'!F31/'Calculated Data'!F33","v":5.3148616472188945E-3},{"$f":"'Data Sheet'!G31/'Calculated Data'!G33","v":4.3308628585201252E-3},{"$f":"'Data Sheet'!H31/'Calculated Data'!H33","v":1.3991084637545744E-2},{"$f":"'Data Sheet'!I31/'Calculated Data'!I33","v":7.0300273865414719E-3},{"$f":"'Data Sheet'!J31/'Calculated Data'!J33","v":1.9470404984423678E-3},{"$f":"'Data Sheet'!K31/'Calculated Data'!K33","v":2.3364549182545093E-3}]
[null,{"$f":"B2","v":"2014-03-31"},"2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31","Z-Weights"]
["Working Capital/Total Assets",{"$f":"B11/B15","v":0.34746584398413399},0.38137193203272496,0.41587677725118488,0.36493252991598063,0.41717750084203437,0.50406088487533374,0.4142583080636178,0.39766215906486363,0.49180925852235047,0.49481600265420667,1.2]
["Retained Profits/Total Assets",{"$f":"B35/B15","v":3.1115028646981048E-2},3.8860918816865958E-2,3.246445497630332E-2,6.5008911143172365E-2,9.2219602559784453E-2,0.11802124155165558,7.1848505476824059E-2,0.10016044006417602,0.15963655657248971,0.18280848240205702,1.4]
["EBIT/Total Assets",{"$f":"B4/B15","v":6.4345526663728517E-2},9.1488357457520444E-2,8.2148499210110595E-2,0.13986251379105491,0.16955203772313909,0.20491849832453002,0.12011881923386349,0.15713958285583315,0.24054914444886591,0.28817495645442232,3.3]
["Market Cap/Total Liabilities",{"$f":"B33/B15","v":0.13962097840458351},0.44042794210195091,0.3112037914691943,1.0348739709751338,2.9151148534860223,3.0162548986198674,0.50866514016956499,1.4997387118954846,6.5400716275368076,8.1768143990710289,0.6]
["Sales/Total Assets",{"$f":"'Data Sheet'!B17/'Calculated Data'!B15","v":0.71132657558395773},{"$f":"'Data Sheet'!C17/'Calculated Data'!C15","v":0.74905601006922584},{"$f":"'Data Sheet'!D17/'Calculated Data'!D15","v":0.78080568720379151},{"$f":"'Data Sheet'!E17/'Calculated Data'!E15","v":1.0070440465076806},{"$f":"'Data Sheet'!F17/'Calculated Data'!F15","v":1.063388346244527},{"$f":"'Data Sheet'!G17/'Calculated Data'!G15","v":1.0983699664906004},{"$f":"'Data Sheet'!H17/'Calculated Data'!H15","v":1.1586113002042204},{"$f":"'Data Sheet'!I17/'Calculated Data'!I15","v":0.93385285354114134},{"$f":"'Data Sheet'!J17/'Calculated Data'!J15","v":1.0743798912322589},{"$f":"'Data Sheet'!K17/'Calculated Data'!K15","v":1.1618513091321299},1]
["Altman Z-Score",{"$f":"$L$45*B45+$L$46*B46+$L$47*B47+$L$48*B48+$L$49*B49","v":1.4679594535037461},{"$f":"$L$45*C45+$L$46*C46+$L$47*C47+$L$48*C48+$L$49*C49","v":1.8272759597230961},1.7831203791469195,2.6184462361028604,4.0016994274166393,4.3544567501561877,2.4579003651216036,2.9696759110703641,6.6058973338639069,7.8686283834222692]
["Z > 2.99 -“Safe” Zones"]
["1.81 < Z < 2.99 -“Grey” Zones"]
["Z < 1.81 -“Distress” Zones"]

{"sheet":"Cost Analysis","index":7,"n_rows":42,"n_cols":12,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Data Sheet'!B1","v":"SHIVALIK BIMETAL CONTROLS LTD"},{"$f":"B7","v":"2014-03-31"},"2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31"]
[{"$f":"'Data Sheet'!A17","v":"Sales"},{"$f":"'Data Sheet'!B17","v":80.7},{"$f":"'Data Sheet'!C17","v":95.22},{"$f":"'Data Sheet'!D17","v":98.85},{"$f":"'Data Sheet'!E17","v":118.66},{"$f":"'Data Sheet'!F17","v":157.86000000000001},{"$f":"'Data Sheet'!G17","v":193.39},{"$f":"'Data Sheet'!H17","v":187.22},{"$f":"'Data Sheet'!I17","v":203.72},{"$f":"'Data Sheet'!J17","v":323.99},{"$f":"'Data Sheet'!K17","v":420.23}]
[{"$f":"'Data Sheet'!A25","v":"Other Income"},{"$f":"'Data Sheet'!B25","v":-1.35},{"$f":"'Data Sheet'!C25","v":-0.55000000000000004},{"$f":"'Data Sheet'!D25","v":0.56999999999999995},{"$f":"'Data Sheet'!E25","v":2.04},{"$f":"'Data Sheet'!F25","v":4.1500000000000004},{"$f":"'Data Sheet'!G25","v":5.35},{"$f":"'Data Sheet'!H25","v":4.6500000000000004},{"$f":"'Data Sheet'!I25","v":4.05},{"$f":"'Data Sheet'!J25","v":5.45},{"$f":"'Data Sheet'!K25","v":7.93}]
["Sales Increase",null,{"$f":"(C2-B2)/B2","v":0.17992565055762078},3.812224322621293E-2,0.20040465351542744,0.33035563795718875,0.2250728493601924,-3.1904441801540867E-2,8.8131609870740313E-2,0.59036913410563518,0.29704620512978797]
["EBIT",{"$f":"'Calculated Data'!B4","v":7.3},{"$f":"'Calculated Data'!C4","v":11.629999999999999},{"$f":"'Calculated Data'!D4","v":10.4},{"$f":"'Calculated Data'!E4","v":16.48},{"$f":"'Calculated Data'!F4","v":25.169999999999998},{"$f":"'Calculated Data'!G4","v":36.08},{"$f":"'Calculated Data'!H4","v":19.41},{"$f":"'Calculated Data'!I4","v":34.28},{"$f":"'Calculated Data'!J4","v":72.540000000000006},{"$f":"'Calculated Data'!K4","v":104.23}]
["EBIT Increase",null,{"$f":"(C5-B5)/B5","v":0.5931506849315068},{"$f":"(D5-C5)/C5","v":-0.10576096302665509},0.58461538461538465,0.5273058252427183,0.43345252284465635,-0.46202882483370283,0.76609994848016494,1.1161026837806303,0.43686242073338838]
["Operating Expenses",{"$f":"'Data Sheet'!B16","v":"2014-03-31"},{"$f":"'Data Sheet'!C16","v":"2015-03-31"},{"$f":"'Data Sheet'!D16","v":"2016-03-31"},{"$f":"'Data Sheet'!E16","v":"2017-03-31"},{"$f":"'Data Sheet'!F16","v":"2018-03-31"},{"$f":"'Data Sheet'!G16","v":"2019-03-31"},{"$f":"'Data Sheet'!H16","v":"2020-03-31"},{"$f":"'Data Sheet'!I16","v":"2021-03-31"},{"$f":"'Data Sheet'!J16","v":"2022-03-31"},{"$f":"'Data Sheet'!K16","v":"2023-03-31"}]
[{"$f":"'Data Sheet'!A18","v":"Raw Material Cost"},{"$f":"'Data Sheet'!B18","v":48.92},{"$f":"'Data Sheet'!C18","v":57.75},{"$f":"'Data Sheet'!D18","v":56.08},{"$f":"'Data Sheet'!E18","v":64.88},{"$f":"'Data Sheet'!F18","v":89.53},{"$f":"'Data Sheet'!G18","v":108.66},{"$f":"'Data Sheet'!H18","v":97.82},{"$f":"'Data Sheet'!I18","v":112.89},{"$f":"'Data Sheet'!J18","v":172.06},{"$f":"'Data Sheet'!K18","v":224.06}]
[{"$f":"'Data Sheet'!A19","v":"Change in Inventory"},{"$f":"'Data Sheet'!B19","v":0.86},{"$f":"'Data Sheet'!C19","v":2.0699999999999998},{"$f":"'Data Sheet'!D19","v":-1.94},{"$f":"'Data Sheet'!E19","v":2.84},{"$f":"'Data Sheet'!F19","v":7.9},{"$f":"'Data Sheet'!G19","v":12.78},{"$f":"'Data Sheet'!H19","v":-9.36},{"$f":"'Data Sheet'!I19","v":11.61},{"$f":"'Data Sheet'!J19","v":11},{"$f":"'Data Sheet'!K19","v":18.07}]
[{"$f":"'Data Sheet'!A20","v":"Power and Fuel"},{"$f":"'Data Sheet'!B20","v":1.2},{"$f":"'Data Sheet'!C20","v":1.29},{"$f":"'Data Sheet'!D20","v":1.65},{"$f":"'Data Sheet'!E20","v":1.91},{"$f":"'Data Sheet'!F20","v":2.02},{"$f":"'Data Sheet'!G20","v":2.04},{"$f":"'Data Sheet'!H20","v":2.06},{"$f":"'Data Sheet'!I20","v":2.16},{"$f":"'Data Sheet'!J20","v":2.9},{"$f":"'Data Sheet'!K20","v":4.03}]
[{"$f":"'Data Sheet'!A21","v":"Other Mfr. Exp"},{"$f":"'Data Sheet'!B21","v":4.01},{"$f":"'Data Sheet'!C21","v":4.01},{"$f":"'Data Sheet'!D21","v":4.58},{"$f":"'Data Sheet'!E21","v":8.42},{"$f":"'Data Sheet'!F21","v":8.23},{"$f":"'Data Sheet'!G21","v":8},{"$f":"'Data Sheet'!H21","v":7.19},{"$f":"'Data Sheet'!I21","v":13.5},{"$f":"'Data Sheet'!J21","v":15.14},{"$f":"'Data Sheet'!K21","v":19.38}]
[{"$f":"'Data Sheet'!A22","v":"Employee Cost"},{"$f":"'Data Sheet'!B22","v":8.7100000000000009},{"$f":"'Data Sheet'!C22","v":10.28},{"$f":"'Data Sheet'!D22","v":11.5},{"$f":"'Data Sheet'!E22","v":12.41},{"$f":"'Data Sheet'!F22","v":14.48},{"$f":"'Data Sheet'!G22","v":16.920000000000002},{"$f":"'Data Sheet'!H22","v":20.02},{"$f":"'Data Sheet'!I22","v":22.23},{"$f":"'Data Sheet'!J22","v":27.11},{"$f":"'Data Sheet'!K22","v":33.950000000000003}]
[{"$f":"'Data Sheet'!A23","v":"Selling and admin"},{"$f":"'Data Sheet'!B23","v":7.81},{"$f":"'Data Sheet'!C23","v":8.4700000000000006},{"$f":"'Data Sheet'!D23","v":8.86},{"$f":"'Data Sheet'!E23","v":14.71},{"$f":"'Data Sheet'!F23","v":25.51},{"$f":"'Data Sheet'!G23","v":33.549999999999997},{"$f":"'Data Sheet'!H23","v":28.96},{"$f":"'Data Sheet'!I23","v":27.43},{"$f":"'Data Sheet'!J23","v":43.03},{"$f":"'Data Sheet'!K23","v":50.41}]
[{"$f":"'Data Sheet'!A24","v":"Other Expenses"},{"$f":"'Data Sheet'!B24","v":-0.09},{"$f":"'Data Sheet'!C24","v":0.14000000000000001},{"$f":"'Data Sheet'!D24","v":0.72},{"$f":"'Data Sheet'!E24","v":0.19},{"$f":"'Data Sheet'!F24","v":0.35},{"$f":"'Data Sheet'!G24","v":1.42},{"$f":"'Data Sheet'!H24","v":1.04},{"$f":"'Data Sheet'!I24","v":0.99},{"$f":"'Data Sheet'!J24","v":1.28},{"$f":"'Data Sheet'!K24","v":1.7}]
["Interest Expense",{"$f":"'Profit & Loss'!B9","v":3.17},{"$f":"'Profit & Loss'!C9","v":3.2},{"$f":"'Profit & Loss'!D9","v":3.9},{"$f":"'Profit & Loss'!E9","v":2.54},{"$f":"'Profit & Loss'!F9","v":3.31},{"$f":"'Profit & Loss'!G9","v":3.58},{"$f":"'Profit & Loss'!H9","v":2.94},{"$f":"'Profit & Loss'!I9","v":1.63},{"$f":"'Profit & Loss'!J9","v":2.76},{"$f":"'Profit & Loss'!K9","v":6.64}]
["Coomon Size Expenses",{"$f":"B1","v":"2014-03-31"},"2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31"]
[{"$f":"A8","v":"Raw Material Cost"},{"$f":"B8/B$2","v":0.60619578686493181},0.6064902331442974,0.56732422862923626,0.54677229057812238,0.567148105916635,0.5618697967837013,0.52248691379126155,0.55414294129196939,0.53106577363498875,0.53318420864764537,"check lower RM/Sales - high correlation with Op Leverage"]
["Change in Inventory",{"$f":"B9/B$2","v":1.0656753407682774E-2},2.1739130434782608E-2,-1.962569549822964E-2,2.3933928872408562E-2,5.0044343088812872E-2,6.6084078804488341E-2,-4.9994658690310861E-2,5.6989986255644998E-2,3.3951665174851077E-2,4.3000261761416365E-2]
["Power and Fuel",{"$f":"B10/B$2","v":1.4869888475836431E-2},1.3547574039067423E-2,1.6691957511380879E-2,1.609640991066914E-2,1.2796148486000252E-2,1.0548632297430064E-2,1.10030979596197E-2,1.0602788140585118E-2,8.9508935460971013E-3,9.5899864359993339E-3]
["Other Mfr. Exp",{"$f":"B11/B$2","v":4.96902106567534E-2},4.2113001470279354E-2,4.6332827516439051E-2,7.095904264284511E-2,5.2134802989991132E-2,4.1367185480117898E-2,3.8404016664886235E-2,6.6267425878656985E-2,4.6729837340658664E-2,4.6117602265426071E-2]
["Employee Cost",{"$f":"B12/B$2","v":0.10793060718711277},0.1079605124973745,0.11633788568538189,0.10458452722063037,9.1726846572912704E-2,8.7491597290449363E-2,0.10693301997649823,0.1091203612801885,8.3675422080928416E-2,8.0789091687885214E-2,"check high Emp Cost/Sales - high correlation with Op Leverage"]
["Selling and admin",{"$f":"B13/B$2","v":9.6778190830235436E-2},8.8951900861163627E-2,8.9630753667172477E-2,0.1239676386313838,0.1615988850880527,0.17348363410724443,0.15468432859737208,0.13464559198900453,0.13281274113398561,0.11995811817338123]
["Other Expenses",{"$f":"B14/B$2","v":-1.1152416356877322E-3},1.4702793530770848E-3,7.2837632776934754E-3,1.601213551323108E-3,2.2171544406436078E-3,7.3426754227209267E-3,5.5549620767012071E-3,4.8596112311015119E-3,3.9507392203463072E-3,4.0454037074935155E-3]
["Interest Expense",{"$f":"B15/B2","v":3.9281288723667901E-2},3.3606385213190509E-2,3.9453717754172994E-2,2.1405696949266813E-2,2.0967946281515264E-2,1.8511815502352761E-2,1.5703450486059183E-2,8.0011780875711754E-3,8.5187814438717237E-3,1.5800870951621731E-2]
["Interest Expense Capitalised",null,null,null,null,null,null,null,null,null,null,"Add back from AR - any interest costs capitalised"]
["Depreciation",{"$f":"'Profit & Loss'!B8/'Profit & Loss'!B4","v":2.9120198265179677E-2},{"$f":"'Profit & Loss'!C8/'Profit & Loss'!C4","v":3.3291325351816843E-2},{"$f":"'Profit & Loss'!D8/'Profit & Loss'!D4","v":3.7329286798179061E-2},{"$f":"'Profit & Loss'!E8/'Profit & Loss'!E4","v":3.8260576436878475E-2},{"$f":"'Profit & Loss'!F8/'Profit & Loss'!F4","v":2.9266438616495628E-2},{"$f":"'Profit & Loss'!G8/'Profit & Loss'!G4","v":2.5078856197321475E-2},{"$f":"'Profit & Loss'!H8/'Profit & Loss'!H4","v":3.2101271231706016E-2},{"$f":"'Profit & Loss'!I8/'Profit & Loss'!I4","v":2.8961319458079719E-2},{"$f":"'Profit & Loss'!J8/'Profit & Loss'!J4","v":1.9691965801413622E-2},{"$f":"'Profit & Loss'!K8/'Profit & Loss'!K4","v":2.0155629060276514E-2}]
["Year on Year Escalation",{"$f":"B16","v":"2014-03-31"},{"$f":"C16","v":"2015-03-31"},"2016-03-31","2017-03-31","2018-03-31","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31"]
["Raw Material Increase/Sales Increase",null,{"$f":"((C8-B8)/B8)/C$4","v":1.0031853320989574},-0.75855318235483704,0.78300920081717806,1.1500702238355267,0.94934327116977602,3.1268599569054185,1.7480501601581144,0.88781494774030711,1.0174179994239285]
["Change in Inventory Increase/Sales Increase",null,{"$f":"((C9-B9)/B9)/C$4","v":7.819767441860467},-50.815426997245247,-12.294712136430103,5.3932487783845922,2.7445403599026688,54.299472687013598,-25.420897435897434,-8.8996714039979025E-2,2.1637282740119397]
["Power & Fuel Increase/Sales Increase",null,{"$f":"((C10-B10)/B10)/C$4","v":0.41683884297520707},7.3203920814914536,0.78628791702996648,0.17433219361042854,4.399015752968493E-2,-0.30729017701083761,0.55080906148867359,0.58030234441642081,1.3117662023103165]
["Other Mfg Increase/Sales Increase",null,{"$f":"((C11-B11)/B11)/C$4","v":0},3.7286535726798777,4.1836750439216219,-6.830614668670297E-2,-0.12416662933348505,3.173539303079421,9.957923041261008,0.20577207456063371,0.94279218290688926]
["Employee Cost Increase/Sales Increase",null,{"$f":"((C12-B12)/B12)/C$4","v":1.0018170432010314},3.1130655690259568,0.3948532800737441,0.50491333519709236,0.7486833164099137,-5.7426213930748631,1.2525541125541131,0.37184052181885996,0.84938106596290575]
["Selling & Admin Cost Increase/Sales Increase",null,{"$f":"((C13-B13)/B13)/C$4","v":0.46967756954952944},1.2078214797974354,3.2946883656588613,2.2224364932920815,1.4003044892358016,4.288140538686549,-0.5994613259668512,0.96333013752232843,0.57737903092605425]
["Other Expenses Increase/Sales Increase",null,{"$f":"((C14-B14)/B14)/C$4","v":-14.203397612488526},108.67296340023626,-3.6731238431768465,2.5490870032223398,13.582903783522989,8.3877234231972189,-0.54551282051282102,0.49617989154033065,1.1046261299875308]
["Year on Year Escalation",{"$f":"B27","v":"2014-03-31"},{"$f":"C27","v":"2015-03-31"},"2016-03-31","2017-03-31","2018-03-31","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31"]
["Working Capital Increase/Sales Increase",null,{"$f":"(('Calculated Data'!C11-'Calculated Data'!B11)/'Calculated Data'!B11)/'Cost Analysis'!C$4","v":1.2773752468646611},{"$f":"(('Calculated Data'!D11-'Calculated Data'!C11)/'Calculated Data'!C11)/'Cost Analysis'!D$4","v":2.2562904017674574},{"$f":"(('Calculated Data'!E11-'Calculated Data'!D11)/'Calculated Data'!D11)/'Cost Analysis'!E$4","v":-0.91457881210531422},{"$f":"(('Calculated Data'!F11-'Calculated Data'!E11)/'Calculated Data'!E11)/'Cost Analysis'!F$4","v":1.332601922164214},{"$f":"(('Calculated Data'!G11-'Calculated Data'!F11)/'Calculated Data'!F11)/'Cost Analysis'!G$4","v":1.9241307689255778},{"$f":"(('Calculated Data'!H11-'Calculated Data'!G11)/'Calculated Data'!G11)/'Cost Analysis'!H$4","v":7.7025788572602707},{"$f":"(('Calculated Data'!I11-'Calculated Data'!H11)/'Calculated Data'!H11)/'Cost Analysis'!I$4","v":3.3578946320087644},{"$f":"(('Calculated Data'!J11-'Calculated Data'!I11)/'Calculated Data'!I11)/'Cost Analysis'!J$4","v":1.2020028135542293},{"$f":"(('Calculated Data'!K11-'Calculated Data'!J11)/'Calculated Data'!J11)/'Cost Analysis'!K$4","v":0.6959494679120416}]
["Debtors Increase/Sales Increase",null,{"$f":"('Balance Sheet'!C17-'Balance Sheet'!B17)/'Balance Sheet'!B17/'Cost Analysis'!C$4","v":0.59822317851087625},{"$f":"('Balance Sheet'!D17-'Balance Sheet'!C17)/'Balance Sheet'!C17/'Cost Analysis'!D$4","v":0},{"$f":"('Balance Sheet'!E17-'Balance Sheet'!D17)/'Balance Sheet'!D17/'Cost Analysis'!E$4","v":0.48489931760361377},{"$f":"('Balance Sheet'!F17-'Balance Sheet'!E17)/'Balance Sheet'!E17/'Cost Analysis'!F$4","v":0.82149442290163588},{"$f":"('Balance Sheet'!G17-'Balance Sheet'!F17)/'Balance Sheet'!F17/'Cost Analysis'!G$4","v":0.13094896848446469},{"$f":"('Balance Sheet'!H17-'Balance Sheet'!G17)/'Balance Sheet'!G17/'Cost Analysis'!H$4","v":3.2902620283410235},{"$f":"('Balance Sheet'!I17-'Balance Sheet'!H17)/'Balance Sheet'!H17/'Cost Analysis'!I$4","v":4.3516941303177168},{"$f":"('Balance Sheet'!J17-'Balance Sheet'!I17)/'Balance Sheet'!I17/'Cost Analysis'!J$4","v":0.65111773459117583},{"$f":"('Balance Sheet'!K17-'Balance Sheet'!J17)/'Balance Sheet'!J17/'Cost Analysis'!K$4","v":1.1755419775460136}]
["Inventory Increase/Sales Increase",null,{"$f":"(('Balance Sheet'!C18-'Balance Sheet'!B18)/'Balance Sheet'!B18)/'Cost Analysis'!C$4","v":3.0432296685777231},{"$f":"(('Balance Sheet'!D18-'Balance Sheet'!C18)/'Balance Sheet'!C18)/'Cost Analysis'!D$4","v":-4.9366046831956005},{"$f":"(('Balance Sheet'!E18-'Balance Sheet'!D18)/'Balance Sheet'!D18)/'Cost Analysis'!E$4","v":0.574116424251087},{"$f":"(('Balance Sheet'!F18-'Balance Sheet'!E18)/'Balance Sheet'!E18)/'Cost Analysis'!F$4","v":1.6871079041513031},{"$f":"(('Balance Sheet'!G18-'Balance Sheet'!F18)/'Balance Sheet'!F18)/'Cost Analysis'!G$4","v":3.137462548127651},{"$f":"(('Balance Sheet'!H18-'Balance Sheet'!G18)/'Balance Sheet'!G18)/'Cost Analysis'!H$4","v":8.484083492611898},{"$f":"(('Balance Sheet'!I18-'Balance Sheet'!H18)/'Balance Sheet'!H18)/'Cost Analysis'!I$4","v":4.4066033254156753},{"$f":"(('Balance Sheet'!J18-'Balance Sheet'!I18)/'Balance Sheet'!I18)/'Cost Analysis'!J$4","v":1.0804547291642941},{"$f":"(('Balance Sheet'!K18-'Balance Sheet'!J18)/'Balance Sheet'!J18)/'Cost Analysis'!K$4","v":0.20513020055478759}]
["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":-1.4664966823357717},{"$f":"IF('Balance Sheet'!D19>0,(('Balance Sheet'!D19-'Balance Sheet'!C19)/'Balance Sheet'!C19)/'Cost Analysis'!D$4,0)","v":2.8902105881946167},{"$f":"IF('Balance Sheet'!E19>0,(('Balance Sheet'!E19-'Balance Sheet'!D19)/'Balance Sheet'!D19)/'Cost Analysis'!E$4,0)","v":7.0523141959164821},{"$f":"IF('Balance Sheet'!F19>0,(('Balance Sheet'!F19-'Balance Sheet'!E19)/'Balance Sheet'!E19)/'Cost Analysis'!F$4,0)","v":2.8710402745168846},{"$f":"IF('Balance Sheet'!G19>0,(('Balance Sheet'!G19-'Balance Sheet'!F19)/'Balance Sheet'!F19)/'Cost Analysis'!G$4,0)","v":5.1041745699017198E-2},{"$f":"IF('Balance Sheet'!H19>0,(('Balance Sheet'!H19-'Balance Sheet'!G19)/'Balance Sheet'!G19)/'Cost Analysis'!H$4,0)","v":10.133271003552302},{"$f":"IF('Balance Sheet'!I19>0,(('Balance Sheet'!I19-'Balance Sheet'!H19)/'Balance Sheet'!H19)/'Cost Analysis'!I$4,0)","v":-3.0337496747332811},{"$f":"IF('Balance Sheet'!J19>0,(('Balance Sheet'!J19-'Balance Sheet'!I19)/'Balance Sheet'!I19)/'Cost Analysis'!J$4,0)","v":1.4980288313291186},{"$f":"IF('Balance Sheet'!K19>0,(('Balance Sheet'!K19-'Balance Sheet'!J19)/'Balance Sheet'!J19)/'Cost Analysis'!K$4,0)","v":0.8756463849329652}]
["Invested Capital Increase/Sales Increase",null,{"$f":"(('Calculated Data'!C13-'Calculated Data'!B13)/'Calculated Data'!B13)/'Cost Analysis'!C$4","v":0.70703627922879297},{"$f":"(('Calculated Data'!D13-'Calculated Data'!C13)/'Calculated Data'!C13)/'Cost Analysis'!D$4","v":0.72204807777069246},{"$f":"(('Calculated Data'!E13-'Calculated Data'!D13)/'Calculated Data'!D13)/'Cost Analysis'!E$4","v":5.4583167843141933E-2},{"$f":"(('Calculated Data'!F13-'Calculated Data'!E13)/'Calculated Data'!E13)/'Cost Analysis'!F$4","v":0.71122257448855641},{"$f":"(('Calculated Data'!G13-'Calculated Data'!F13)/'Calculated Data'!F13)/'Cost Analysis'!G$4","v":1.1197884364500985},{"$f":"(('Calculated Data'!H13-'Calculated Data'!G13)/'Calculated Data'!G13)/'Cost Analysis'!H$4","v":2.2717617841996578},{"$f":"(('Calculated Data'!I13-'Calculated Data'!H13)/'Calculated Data'!H13)/'Cost Analysis'!I$4","v":2.3839443631791024},{"$f":"(('Calculated Data'!J13-'Calculated Data'!I13)/'Calculated Data'!I13)/'Cost Analysis'!J$4","v":0.83679780467650944},{"$f":"(('Calculated Data'!K13-'Calculated Data'!J13)/'Calculated Data'!J13)/'Cost Analysis'!K$4","v":0.70589557207493714}]
["Dilution ",{"$f":"B1","v":"2014-03-31"},"2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-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":1},{"$f":"('Data Sheet'!G57-'Data Sheet'!F57)/'Data Sheet'!F57","v":0},{"$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.5}]

{"sheet":"Price Implied Expectations","index":8,"n_rows":42,"n_cols":18,"rows_kept":42,"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":"SHIVALIK BIMETAL CONTROLS LTD"}]
[null,{"$f":"'Data Sheet'!B16","v":"2014-03-31"},{"$f":"'Data Sheet'!C16","v":"2015-03-31"},{"$f":"'Data Sheet'!D16","v":"2016-03-31"},{"$f":"'Data Sheet'!E16","v":"2017-03-31"},{"$f":"'Data Sheet'!F16","v":"2018-03-31"},{"$f":"'Data Sheet'!G16","v":"2019-03-31"},{"$f":"'Data Sheet'!H16","v":"2020-03-31"},{"$f":"'Data Sheet'!I16","v":"2021-03-31"},{"$f":"'Data Sheet'!J16","v":"2022-03-31"},{"$f":"'Data Sheet'!K16","v":"2023-03-31"},null,"Consensus Forecasts",null,null,"5 Yr Avg","Inputs","TTM"]
["Sales",{"$f":"'Data Sheet'!B17","v":80.7},{"$f":"'Data Sheet'!C17","v":95.22},{"$f":"'Data Sheet'!D17","v":98.85},{"$f":"'Data Sheet'!E17","v":118.66},{"$f":"'Data Sheet'!F17","v":157.86000000000001},{"$f":"'Data Sheet'!G17","v":193.39},{"$f":"'Data Sheet'!H17","v":187.22},{"$f":"'Data Sheet'!I17","v":203.72},{"$f":"'Data Sheet'!J17","v":323.99},{"$f":"'Data Sheet'!K17","v":420.23},null,"Sales Growth Rate",null,null,{"$f":"Customization!B14","v":0.21412460361884933},0.25,{"$f":"'Profit & Loss'!L31","v":0}]
["Capex",null,{"$f":"'Calculated Data'!C18","v":3.9500000000000028},{"$f":"'Calculated Data'!D18","v":1.9200000000000008},{"$f":"'Calculated Data'!E18","v":15.169999999999998},{"$f":"'Calculated Data'!F18","v":6.9700000000000015},{"$f":"'Calculated Data'!G18","v":6.2199999999999944},{"$f":"'Calculated Data'!H18","v":17.669999999999998},{"$f":"'Calculated Data'!I18","v":13.380000000000004},{"$f":"'Calculated Data'!J18","v":22.47},{"$f":"'Calculated Data'!K18","v":27.050000000000004},null,"EBIT Margin",null,null,{"$f":"(AVERAGE('Business Robustness'!G14:K14))","v":0.18608752836766468},0.24,{"$f":"'Calculated Data'!L4/Annual[[#This Row],[Column12]]","v":0.24696402745575169}]
["Depreciation",null,{"$f":"'Data Sheet'!C26","v":3.17},{"$f":"'Data Sheet'!D26","v":3.69},{"$f":"'Data Sheet'!E26","v":4.54},{"$f":"'Data Sheet'!F26","v":4.62},{"$f":"'Data Sheet'!G26","v":4.8499999999999996},{"$f":"'Data Sheet'!H26","v":6.01},{"$f":"'Data Sheet'!I26","v":5.9},{"$f":"'Data Sheet'!J26","v":6.38},{"$f":"'Data Sheet'!K26","v":8.4700000000000006},null,"Tax Rate",null,null,{"$f":"AVERAGE('Calculated Data'!G22:K22)","v":0.25646739202428026},0.25]
["Incremental Fixed Capital Investment",null,{"$f":"C4-C5","v":0.78000000000000291},{"$f":"D4-D5","v":-1.7699999999999991},10.629999999999999,2.3500000000000014,1.3699999999999948,11.659999999999998,7.480000000000004,16.09,18.580000000000005,null,"Inc Fixed Capital Rate",null,null,{"$f":"AVERAGE(G9:K9)","v":0.22027793412022909},0.1]
["Incremental Sales",null,{"$f":"C3-B3","v":14.519999999999996},{"$f":"D3-C3","v":3.6299999999999955},19.810000000000002,39.200000000000017,35.529999999999973,-6.1699999999999875,16.5,120.27000000000001,96.240000000000009,null,"Inc Working Capital Rate",null,null,{"$f":"AVERAGE(G15:K15)","v":0.38450710612574379},0.4]
["Incremental Fixed Capital Investment Rate",null,{"$f":"C6/C7","v":5.3719008264463027E-2},{"$f":"D6/D7","v":-0.48760330578512434},0.536597677940434,5.9948979591836746E-2,3.8558964255558568E-2,-1.8897893030794202,0.45333333333333359,0.13378232310634405,0.19305901911886952,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":0.11855532877806373},{"$f":"SUM(D6:H6)/SUM(D7:H7)","v":0.26347826086956516},0.31934776389815955,0.18969463789996591,0.21031367915539123,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.19783229758784204},null,"Cash & Bank Balance",null,null,null,{"$f":"'Balance Sheet'!K34","v":17.059999999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Investments",null,null,null,{"$f":"'Balance Sheet'!K12","v":23.59}]
["Working Capital",{"$f":"'Calculated Data'!B11","v":39.42},{"$f":"'Calculated Data'!C11","v":48.48},{"$f":"'Calculated Data'!D11","v":52.650000000000006},{"$f":"'Calculated Data'!E11","v":43},{"$f":"'Calculated Data'!F11","v":61.93},{"$f":"'Calculated Data'!G11","v":88.75},{"$f":"'Calculated Data'!H11","v":66.94},{"$f":"'Calculated Data'!I11","v":86.75},{"$f":"'Calculated Data'!J11","v":148.31},{"$f":"'Calculated Data'!K11","v":178.97},null,"Non-Operative Assets",null,null,null,{"$f":"Q10+Q11","v":40.65}]
["Incremental Working Capital",null,{"$f":"C12-B12","v":9.0599999999999952},{"$f":"D12-C12","v":4.1700000000000088},-9.6500000000000057,18.93,26.82,-21.810000000000002,19.810000000000002,61.56,30.659999999999997,null,"Debt",null,null,null,{"$f":"'Balance Sheet'!K6","v":52.65}]
["Incremental Working Capital Investment Rate",null,{"$f":"C13/C7","v":0.62396694214876014},{"$f":"D13/D7","v":1.1487603305785163},-0.48712771327612342,0.48290816326530589,0.75485505206867498,3.5348460291734272,1.2006060606060607,0.51184834123222744,0.31857855361596005,null,"# Shares Outstanding",null,null,null,{"$f":"'Data Sheet'!B6","v":5.7604208131930621}]
["5 Yr Avg",null,null,null,null,null,{"$f":"SUM(C13:G13)/SUM(C7:G7)","v":0.43774957848966195},{"$f":"SUM(D13:H13)/SUM(D7:H7)","v":0.20065217391304349},0.32516448936778863,0.51288170262504262,0.44608758623318212,null,"CMP",null,null,null,{"$f":"'Data Sheet'!B8","v":527.54999999999995}]
["9 Yr Avg",null,null,null,null,null,null,null,null,null,{"$f":"SUM(C13:K13)/SUM(C7:K7)","v":0.41100933643566107}]
["Years in Future",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
["Year","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","2033-03-01","2034-03-01","2035-03-01","2036-03-01","1937-03-01","1938-03-01"]
["Sales",{"$f":"'Data Sheet'!K17","v":420.23},{"$f":"B19*(1+10%)","v":462.25300000000004},{"$f":"C19*(1+$Q$3)","v":577.81625000000008},{"$f":"D19*(1+$Q$3)","v":722.27031250000005},902.837890625,1128.54736328125,1410.6842041015625,1763.3552551269531,2204.1940689086914,2755.2425861358643,3444.0532326698303,4305.0665408372879,5381.3331760466099,6726.6664700582623,8408.3330875728279,10510.416359466035]
["EBIT",{"$f":"'Calculated Data'!K4","v":104.23},{"$f":"C19*$Q$4","v":110.94072000000001},{"$f":"D19*$Q$4","v":138.67590000000001},{"$f":"E19*$Q$4","v":173.344875},216.68109375,270.85136718749999,338.564208984375,423.20526123046875,529.00657653808594,661.25822067260742,826.57277584075928,1033.2159698009491,1291.5199622511864,1614.399952813983,2017.9999410174787,2522.4999262718484]
["NOPAT",{"$f":"'Calculated Data'!K23","v":77.998943539297073},{"$f":"C20*(1-$Q$5)","v":83.205540000000013},{"$f":"D20*(1-$Q$5)","v":104.00692500000001},130.00865625,162.51082031250002,203.13852539062498,253.92315673828125,317.40394592285156,396.75493240356445,495.94366550445557,619.92958188056946,774.91197735071182,968.63997168838978,1210.7999646104872,1513.499955763109,1891.8749447038863]
["Incremental Fixed Capital Investment",null,{"$f":"(C19-B19)*$Q$6","v":4.2023000000000028},{"$f":"(D19-C19)*$Q$6","v":11.556325000000005},14.445406249999998,18.056757812499995,22.570947265625001,28.21368408203125,35.267105102539062,44.083881378173828,55.104851722717285,68.881064653396606,86.101330816745758,107.6266635209322,134.53332940116525,168.16666175145656,210.2083271893207]
["Incremental Working Capital Investment",null,{"$f":"(C19-B19)*$Q$7","v":16.809200000000011},{"$f":"(D19-C19)*$Q$7","v":46.225300000000018},57.781624999999991,72.227031249999982,90.283789062500006,112.854736328125,141.06842041015625,176.33552551269531,220.41940689086914,275.52425861358643,344.40532326698303,430.50665408372879,538.13331760466099,672.66664700582623,840.83330875728279]
["Free Cash Flow",null,{"$f":"C21-(C22+C23)","v":62.194040000000001},{"$f":"D21-(D22+D23)","v":46.22529999999999},57.78162500000002,72.227031250000039,90.283789062499977,112.854736328125,141.06842041015625,176.33552551269531,220.41940689086914,275.52425861358643,344.40532326698303,430.50665408372879,538.13331760466099,672.66664700582623,840.83330875728279]
["Present Value of Free Cash Flow",null,{"$f":"C24/((1+$Q$8)^C17)","v":55.53039285714285},{"$f":"D24/((1+$Q$8)^D17)","v":36.850526147959172},41.127819361561592,45.901584108885714,51.229446550095624,57.17572159608887,63.812189281349184,71.218961251505775,79.485447825341268,88.711437305068372,99.008300563692359,110.50033545054953,123.32626724391686,137.64092326330007,153.61710185636167]
["Cumulative Present Value of Free Cash Flow",null,{"$f":"C25","v":55.53039285714285},{"$f":"D25+C26","v":92.380919005102015},{"$f":"E25+D26","v":133.50873836666361},179.41032247554932,230.63976902564494,287.81549062173383,351.62767990308299,422.84664115458878,502.33208897993006,591.04352628499839,690.05182684869078,800.55216229924031,923.87842954315715,1061.5193528064572,1215.1364546628188]
["Present Value of Residual Value",null,{"$f":"((C21*(1+$Q$9))/($Q$8-$Q$9))/((1+$Q$8)^C17)","v":1114.3599107142861},{"$f":"((D21*(1+$Q$9))/($Q$8-$Q$9))/((1+$Q$8)^D17)","v":1243.7052574936226},1388.0639034527035,1549.1784636748926,1728.9938210657276,1929.6806038679999,2153.6613882455354,2403.6399422383206,2682.633864105268,2994.011009046058,3341.530144024618,3729.386321456047,4162.2615194821947,4645.3811601363777,5184.5771876522076]
[]
["Corporate Value",null,{"$f":"C27+C26","v":1169.8903035714291},{"$f":"D27+D26","v":1336.0861764987246},1521.5726418193672,1728.5887861504418,1959.6335900913725,2217.4960944897339,2505.2890681486183,2826.4865833929093,3184.9659530851982,3585.0545353310563,4031.5819708733088,4529.9384837552871,5086.1399490253516,5706.9005129428351,6399.7136423150259]
["Add: Non-Operative Assets",null,{"$f":"$Q$12","v":40.65},{"$f":"$Q$12","v":40.65},40.65,40.65,40.65,40.65,40.65,40.65,40.65,40.65,40.65,40.65,40.65,40.65,40.65]
["Less: Debt",null,{"$f":"$Q$13","v":52.65},{"$f":"$Q$13","v":52.65},52.65,52.65,52.65,52.65,52.65,52.65,52.65,52.65,52.65,52.65,52.65,52.65,52.65]
["Shareholder Value",null,{"$f":"C29+C30-C31","v":1157.8903035714291},{"$f":"D29+D30-D31","v":1324.0861764987246},1509.5726418193672,1716.5887861504418,1947.6335900913725,2205.4960944897339,2493.2890681486183,2814.4865833929093,3172.9659530851982,3573.0545353310563,4019.5819708733088,4517.9384837552871,5074.1399490253516,5694.9005129428351,6387.7136423150259]
[]
["Shareholder Value/Share",null,{"$f":"C32/$Q$14","v":201.00793694091217},{"$f":"D32/$Q$14","v":229.8592792849746},262.05943815111573,297.99711545707692,338.10613030747987,382.87065581016191,432.83106373726224,488.59044758447249,550.82190277109112,620.27665186329932,697.79311290371027,784.30702031488318,880.86272055056725,988.62577884932193,1108.8970492720391]
["Market-Implied-Forecast-Period",null,{"$f":"IF(Q15>Q34,\"15+\",IF(Q15<C34,\"<1\",LOOKUP(Q15,C34:Q34,C17:Q17)))","v":8}]
["Accrued Free Cash Flows ",null,{"$f":"C24","v":62.194040000000001},{"$f":"D24+C36","v":108.41933999999999},{"$f":"E24+D36","v":166.200965},{"$f":"F24+E36","v":238.42799625000004},328.71178531250001,441.56652164062501,582.63494205078132,758.97046756347663,979.38987445434577,1254.9141330679322,1599.3194563349152,2029.826110418644,2567.959428023305,3240.6260750291312,4081.459383786414]
[null,"*"]
["Steady State Value*",{"$f":"C32","v":1157.8903035714291},{"$f":"B21*16","v":1247.9830966287532},"(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":4098.3173970010603},{"$f":"L32","v":3573.0545353310563},"(present value of year 10 shareholder future value)"]
["Value",{"$f":"B38+B39","v":5256.2077005724896},{"$f":"C38+C39","v":4821.037631959809}]
["Value/Share *",{"$f":"B40/'Data Sheet'!B6","v":912.46939607853369},{"$f":"C40/'Data Sheet'!B6","v":836.92455608767534}]
[null,"(* as per Credit Suisse/Mauboussin 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":"SHIVALIK BIMETAL CONTROLS LTD"},{"$f":"'Data Sheet'!B16","v":"2014-03-31"},{"$f":"'Data Sheet'!C16","v":"2015-03-31"},{"$f":"'Data Sheet'!D16","v":"2016-03-31"},{"$f":"'Data Sheet'!E16","v":"2017-03-31"},{"$f":"'Data Sheet'!F16","v":"2018-03-31"},{"$f":"'Data Sheet'!G16","v":"2019-03-31"},{"$f":"'Data Sheet'!H16","v":"2020-03-31"},{"$f":"'Data Sheet'!I16","v":"2021-03-31"},{"$f":"'Data Sheet'!J16","v":"2022-03-31"},{"$f":"'Data Sheet'!K16","v":"2023-03-31"},"TTM"]
["Sales",{"$f":"'Data Sheet'!B17","v":80.7},{"$f":"'Data Sheet'!C17","v":95.22},{"$f":"'Data Sheet'!D17","v":98.85},{"$f":"'Data Sheet'!E17","v":118.66},{"$f":"'Data Sheet'!F17","v":157.86000000000001},{"$f":"'Data Sheet'!G17","v":193.39},{"$f":"'Data Sheet'!H17","v":187.22},{"$f":"'Data Sheet'!I17","v":203.72},{"$f":"'Data Sheet'!J17","v":323.99},{"$f":"'Data Sheet'!K17","v":420.23},{"$f":"'Profit & Loss'!L4","v":435.61}]
["EBIT",{"$f":"'Profit & Loss'!B10+'Profit & Loss'!B9","v":7.3},{"$f":"'Profit & Loss'!C10+'Profit & Loss'!C9","v":11.629999999999999},{"$f":"'Profit & Loss'!D10+'Profit & Loss'!D9","v":10.4},{"$f":"'Profit & Loss'!E10+'Profit & Loss'!E9","v":16.48},{"$f":"'Profit & Loss'!F10+'Profit & Loss'!F9","v":25.169999999999998},{"$f":"'Profit & Loss'!G10+'Profit & Loss'!G9","v":36.08},{"$f":"'Profit & Loss'!H10+'Profit & Loss'!H9","v":19.41},{"$f":"'Profit & Loss'!I10+'Profit & Loss'!I9","v":34.28},{"$f":"'Profit & Loss'!J10+'Profit & Loss'!J9","v":72.540000000000006},{"$f":"'Profit & Loss'!K10+'Profit & Loss'!K9","v":104.23},{"$f":"'Profit & Loss'!L10+'Profit & Loss'!L9","v":107.58}]
["Operating Profit (ex Other Income)",{"$f":"'Calculated Data'!B6","v":11},{"$f":"'Calculated Data'!C6","v":15.35},{"$f":"'Calculated Data'!D6","v":13.52},{"$f":"'Calculated Data'!E6","v":18.98},{"$f":"'Calculated Data'!F6","v":25.64},{"$f":"'Calculated Data'!G6","v":35.58},{"$f":"'Calculated Data'!H6","v":20.770000000000003},{"$f":"'Calculated Data'!I6","v":36.130000000000003},{"$f":"'Calculated Data'!J6","v":73.47},{"$f":"'Calculated Data'!K6","v":104.77000000000001},{"$f":"'Profit & Loss'!L6","v":109.52}]
["Operating Profit Margin (ex Other Income)",{"$f":"B5/B3","v":0.13630731102850061},0.16120562906952321,0.13677288821446637,0.15995280633743469,0.16242239959457747,0.18398055742282435,0.11093900224335008,0.17735126644413904,0.22676625821784621,0.24931585084358568,0.25141755239778701]
["1Yr Sales Increase",null,{"$f":"(C3-B3)/B3","v":0.17992565055762078},3.812224322621293E-2,0.20040465351542744,0.33035563795718875,0.2250728493601924,-3.1904441801540867E-2,8.8131609870740313E-2,0.59036913410563518,0.29704620512978797,3.6599005306617791E-2]
["1Yr EBIT Increase",null,{"$f":"(C4-B4)/B4","v":0.5931506849315068},-0.10576096302665509,0.58461538461538465,0.5273058252427183,0.43345252284465635,-0.46202882483370283,0.76609994848016494,1.1161026837806303,0.43686242073338838,3.214045860117043E-2]
["3Yr Sales Increase",null,null,null,{"$f":"(E3-B3)/B3","v":0.47038413878562568},{"$f":"(F3-C3)/C3","v":0.65784499054820433},0.95639858371269593,0.57778526883532788,0.29051057899404525,0.67531930296292486,1.2445785706655272,1.1382780286667977]
["3Yr EBIT Increase",null,null,null,{"$f":"(E4-B4)/B4","v":1.2575342465753425},{"$f":"(F4-C4)/C4","v":1.1642304385210662},{"$f":"(G4-D4)/D4","v":2.4692307692307693},{"$f":"(H4-E4)/E4","v":0.17779126213592231},{"$f":"(I4-F4)/F4","v":0.36193881605085432},{"$f":"(J4-G4)/G4","v":1.0105321507760534},{"$f":"(K4-H4)/H4","v":4.3699124162802683},{"$f":"(L4-I4)/I4","v":2.1382730455075842}]
["Abnormal margin exclusion (RM cycle)"]
["1 Yr Operating Leverage",null,{"$f":"IF((C3-B3)>0,(C8/C7),0)","v":3.2966432695573422},-2.7742586499719315,2.9171746980934259,1.5961762556964523,1.9258321209191531,0,8.6926807487549382,1.8905166603458052,1.4706884423671083,0.87817847321000353]
["3Yr Operating Leverage",null,null,null,{"$f":"IF((E3-B3)>0,E10/E9,0)","v":2.6734197497004786},{"$f":"IF((F3-C3)>0,F10/F9,0)","v":1.7697640861426549},2.5818009470960606,0.30771165643303006,1.2458713803268182,1.4963768195909717,3.5111583304407183,1.8785156101203373]
["EBIT Margin",{"$f":"B4/B3","v":9.0458488228004952E-2},0.12213820625918924,0.10520991401112798,0.13888420697792012,0.15944507791714174,0.18656600651533173,0.10367482106612541,0.16827017474965639,0.22389579925306338,0.24803084025414654,0.24696402745575169]
["Invested Capital",{"$f":"'Calculated Data'!B13","v":77.349999999999994},{"$f":"'Calculated Data'!C13","v":87.19},{"$f":"'Calculated Data'!D13","v":89.59},{"$f":"'Calculated Data'!E13","v":90.57},{"$f":"'Calculated Data'!F13","v":111.85},{"$f":"'Calculated Data'!G13","v":140.04},{"$f":"'Calculated Data'!H13","v":129.88999999999999},{"$f":"'Calculated Data'!I13","v":157.18},{"$f":"'Calculated Data'!J13","v":234.82999999999998},{"$f":"'Calculated Data'!K13","v":284.07},{"$f":"'Calculated Data'!L13","v":156.12}]
["Capital Turns",{"$f":"B3/B15","v":1.0433096315449257},1.0920977176281683,1.1033597499720951,1.3101468477420779,1.4113544926240502,1.3809625821193945,1.4413734698591116,1.2960936505916782,1.379678916663118,1.4793184778399691,2.7902254675890341]
["RoIC",{"$f":"'Calculated Data'!B24","v":8.0436868358816804E-2},{"$f":"'Calculated Data'!C24","v":7.816501424399093E-2},{"$f":"'Calculated Data'!D24","v":7.3579640584886696E-2},{"$f":"'Calculated Data'!E24","v":0.11238625957173198},{"$f":"'Calculated Data'!F24","v":0.16460595139304413},{"$f":"'Calculated Data'!G24","v":0.18296451563289609},{"$f":"'Calculated Data'!H24","v":0.11577289512591642},{"$f":"'Calculated Data'!I24","v":0.16131601248419941},{"$f":"'Calculated Data'!J24","v":0.23006244176052573},{"$f":"'Calculated Data'!K24","v":0.27457649008799617},{"$f":"(L4/L15)*(1-'Calculated Data'!K22)","v":0.51566657286098427}]
["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.13116180819862361},{"$f":"Customization!I58","v":0.43942976211396884},{"$f":"Customization!J58","v":0.64871637326841969},{"$f":"Customization!K58","v":0.413058144156281}]
["EPA",{"$f":"'Calculated Data'!B26","v":-3.0602082324455195},{"$f":"'Calculated Data'!C26","v":-3.6475924080664304},{"$f":"'Calculated Data'!D26","v":-4.1588000000000003},{"$f":"'Calculated Data'!E26","v":-0.68957647058823379},{"$f":"'Calculated Data'!F26","v":4.9891756633119853},{"$f":"'Calculated Data'!G26","v":8.8175507692307686},{"$f":"'Calculated Data'!H26","v":-0.54905865209471594},{"$f":"'Calculated Data'!I26","v":6.4940508422664642},{"$f":"'Calculated Data'!J26","v":25.845963198624258},{"$f":"'Calculated Data'!K26","v":43.910543539297073},{"$f":"L15*(L17-'Calculated Data'!K25)","v":61.771465355056868}]
["EPA/Sales",{"$f":"B19/B3","v":-3.7920795941084502E-2},-3.8306998614434262E-2,-4.2071825998988371E-2,-5.8113641546286348E-3,3.1605065648751964E-2,4.5594657268890684E-2,-2.9326922983373355E-3,3.1877335766083176E-2,7.9773953512837614E-2,0.10449169154819282,0.14180451632206989]
["Sustainable Growth Rate (without addl financing?)",{"$f":"'Calculated Data'!B31","v":6.2811387900355856E-2},{"$f":"'Calculated Data'!C31","v":8.1143232588699085E-2},{"$f":"'Calculated Data'!D31","v":6.324049853823667E-2},{"$f":"'Calculated Data'!E31","v":0.10752386299831555},{"$f":"'Calculated Data'!F31","v":0.16054884484578397},{"$f":"'Calculated Data'!G31","v":0.19689217358347544},{"$f":"'Calculated Data'!H31","v":0.10067637877211237},{"$f":"'Calculated Data'!I31","v":0.15806988352745421},{"$f":"'Calculated Data'!J31","v":0.25718559675178965},{"$f":"'Calculated Data'!K31","v":0.2592839496490334}]
["Business Robustness Snapshot (Quarterly)","Latest 10 Quarters Performance"]
[{"$f":"A2","v":"SHIVALIK BIMETAL CONTROLS LTD"},{"$f":"'Data Sheet'!B41","v":"2021-03-31"},{"$f":"'Data Sheet'!C41","v":"2021-06-30"},{"$f":"'Data Sheet'!D41","v":"2021-09-30"},{"$f":"'Data Sheet'!E41","v":"2021-12-31"},{"$f":"'Data Sheet'!F41","v":"2022-03-31"},{"$f":"'Data Sheet'!G41","v":"2022-06-30"},{"$f":"'Data Sheet'!H41","v":"2022-09-30"},{"$f":"'Data Sheet'!I41","v":"2022-12-31"},{"$f":"'Data Sheet'!J41","v":"2023-03-31"},{"$f":"'Data Sheet'!K41","v":"2023-06-30"}]
["Sales",{"$f":"'Data Sheet'!B42","v":66.86},{"$f":"'Data Sheet'!C42","v":70.31},{"$f":"'Data Sheet'!D42","v":76.23},{"$f":"'Data Sheet'!E42","v":88.13},{"$f":"'Data Sheet'!F42","v":89.32},{"$f":"'Data Sheet'!G42","v":97.69},{"$f":"'Data Sheet'!H42","v":104.87},{"$f":"'Data Sheet'!I42","v":107.54},{"$f":"'Data Sheet'!J42","v":110.13},{"$f":"'Data Sheet'!K42","v":113.07}]
["EBIT",{"$f":"Quarters!B16","v":12.26},{"$f":"Quarters!C16","v":15.29},{"$f":"Quarters!D16","v":17.560000000000002},{"$f":"Quarters!E16","v":20.810000000000002},{"$f":"Quarters!F16","v":18.899999999999999},{"$f":"Quarters!G16","v":24.54},{"$f":"Quarters!H16","v":27.009999999999998},{"$f":"Quarters!I16","v":26.27},{"$f":"Quarters!J16","v":26.4},{"$f":"Quarters!K16","v":27.9}]
["Operating Profit (ex Other Income)",{"$f":"Quarters!B6","v":12.66},{"$f":"Quarters!C6","v":15.86},{"$f":"Quarters!D6","v":17.829999999999998},{"$f":"Quarters!E6","v":20.56},{"$f":"Quarters!F6","v":19.23},{"$f":"Quarters!G6","v":24.25},{"$f":"Quarters!H6","v":25.71},{"$f":"Quarters!I6","v":27.79},{"$f":"Quarters!J6","v":27.02},{"$f":"Quarters!K6","v":29}]
["EBIT Margin",{"$f":"B25/B24","v":0.18336823212683218},{"$f":"C25/C24","v":0.21746550988479588},0.23035550308277583,0.23612844661295818,0.2115987460815047,0.25120278431773979,0.25755697530275579,0.24428119769388132,0.23971669844728957,0.24674980100822499]
["Operating Profit Margin (ex Other Income)",{"$f":"B26/B24","v":0.18935088244092133},{"$f":"C26/C24","v":0.22557246479874837},0.2338974157155975,0.23329172812890048,0.2152933273622929,0.24823421025693521,0.2451606751215791,0.25841547331225589,0.24534640878961228,0.25647828778632709]
["Threshold Margin Snapshot",{"$f":"B2","v":"2014-03-31"},{"$f":"C2","v":"2015-03-31"},"2016-03-31","2017-03-31","2018-03-31","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31","TTM"]
["Incremental Fixed Capital Investment Rate",null,{"$f":"('Calculated Data'!C18-'Data Sheet'!C26)/('Business Robustness'!C3-'Business Robustness'!B3)","v":5.3719008264463027E-2},{"$f":"('Calculated Data'!D18-'Data Sheet'!D26)/('Business Robustness'!D3-'Business Robustness'!C3)","v":-0.48760330578512434},{"$f":"('Calculated Data'!E18-'Data Sheet'!E26)/('Business Robustness'!E3-'Business Robustness'!D3)","v":0.536597677940434},{"$f":"('Calculated Data'!F18-'Data Sheet'!F26)/('Business Robustness'!F3-'Business Robustness'!E3)","v":5.9948979591836746E-2},{"$f":"('Calculated Data'!G18-'Data Sheet'!G26)/('Business Robustness'!G3-'Business Robustness'!F3)","v":3.8558964255558568E-2},{"$f":"('Calculated Data'!H18-'Data Sheet'!H26)/('Business Robustness'!H3-'Business Robustness'!G3)","v":-1.8897893030794202},{"$f":"('Calculated Data'!I18-'Data Sheet'!I26)/('Business Robustness'!I3-'Business Robustness'!H3)","v":0.45333333333333359},{"$f":"('Calculated Data'!J18-'Data Sheet'!J26)/('Business Robustness'!J3-'Business Robustness'!I3)","v":0.13378232310634405},{"$f":"('Calculated Data'!K18-'Data Sheet'!K26)/('Business Robustness'!K3-'Business Robustness'!J3)","v":0.19305901911886952}]
["Incremental Working Capital Investment Rate",null,{"$f":"('Calculated Data'!C11-'Calculated Data'!B11)/('Business Robustness'!C3-'Business Robustness'!B3)","v":0.62396694214876014},{"$f":"('Calculated Data'!D11-'Calculated Data'!C11)/('Business Robustness'!D3-'Business Robustness'!C3)","v":1.1487603305785163},{"$f":"('Calculated Data'!E11-'Calculated Data'!D11)/('Business Robustness'!E3-'Business Robustness'!D3)","v":-0.48712771327612342},{"$f":"('Calculated Data'!F11-'Calculated Data'!E11)/('Business Robustness'!F3-'Business Robustness'!E3)","v":0.48290816326530589},{"$f":"('Calculated Data'!G11-'Calculated Data'!F11)/('Business Robustness'!G3-'Business Robustness'!F3)","v":0.75485505206867498},{"$f":"('Calculated Data'!H11-'Calculated Data'!G11)/('Business Robustness'!H3-'Business Robustness'!G3)","v":3.5348460291734272},{"$f":"('Calculated Data'!I11-'Calculated Data'!H11)/('Business Robustness'!I3-'Business Robustness'!H3)","v":1.2006060606060607},{"$f":"('Calculated Data'!J11-'Calculated Data'!I11)/('Business Robustness'!J3-'Business Robustness'!I3)","v":0.51184834123222744},{"$f":"('Calculated Data'!K11-'Calculated Data'!J11)/('Business Robustness'!K3-'Business Robustness'!J3)","v":0.31857855361596005}]
["Incremental Threshold Margin",null,{"$f":"((C30+C31)*'Calculated Data'!C25)/((1+'Calculated Data'!C25)*(1-'Calculated Data'!C22))","v":0.12390599830791221},{"$f":"((D30+D31)*'Calculated Data'!D25)/((1+'Calculated Data'!D25)*(1-'Calculated Data'!D22))","v":0.11175937919097731},{"$f":"((E30+E31)*'Calculated Data'!E25)/((1+'Calculated Data'!E25)*(1-'Calculated Data'!E22))","v":8.5815244825844864E-3},{"$f":"((F30+F31)*'Calculated Data'!F25)/((1+'Calculated Data'!F25)*(1-'Calculated Data'!F22))","v":7.9515258260902832E-2},{"$f":"((G30+G31)*'Calculated Data'!G25)/((1+'Calculated Data'!G25)*(1-'Calculated Data'!G22))","v":0.11970454721405789},{"$f":"((H30+H31)*'Calculated Data'!H25)/((1+'Calculated Data'!H25)*(1-'Calculated Data'!H22))","v":0.2275029468100786},{"$f":"((I30+I31)*'Calculated Data'!I25)/((1+'Calculated Data'!I25)*(1-'Calculated Data'!I22))","v":0.23957906482751201},{"$f":"((J30+J31)*'Calculated Data'!J25)/((1+'Calculated Data'!J25)*(1-'Calculated Data'!J22))","v":9.2880730141452858E-2},{"$f":"((K30+K31)*'Calculated Data'!K25)/((1+'Calculated Data'!K25)*(1-'Calculated Data'!K22))","v":7.3253717733209461E-2}]
["Threshold Margin (Value Neutral Operating Margin)",null,{"$f":"(B4+(C32*(C3-B3)))/C3","v":9.5558864686314679E-2},{"$f":"(C4+(D32*(D3-C3)))/D3","v":0.12175707179022},8.9078038092027634E-2,0.12414163261008103,0.15214386763801371,0.18521689359139951,0.11468218422174527,0.14028446993460458,0.18939613496095967,"higher capital intensity business demands higher threshold margin (to break even) than lower cap intensive"]
["Threshold Exceed Rate",null,{"$f":"C14-C33","v":2.657934157287456E-2},{"$f":"D14-D33","v":-1.654715777909202E-2},4.9806168885892482E-2,3.5303445307060713E-2,3.4422138877318015E-2,-8.1542072525274095E-2,5.358799052791112E-2,8.3611329318458799E-2,5.8634705293186873E-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":"SHIVALIK BIMETAL CONTROLS 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":527.54999999999995},null,"Year","EPS","DPS",null,null,null,null,null,null,null,null,"Year","Sales"]
["EPS:",{"$f":"'Profit & Loss'!L13","v":13.217784337147201},null,"Current",{"$f":"B4","v":13.217784337147201},{"$f":"B5","v":1.1996527777777779},null,{"$f":"E14","v":81.841036703742517},"Earnings after 10 years",null,null,null,null,null,"Current",{"$f":"'Profit & Loss'!K4","v":420.23}]
["DPS:",{"$f":"'Profit & Loss'!K22","v":1.1996527777777779},null,"Year 1",{"$f":"E4*(1+$B$21)","v":15.86134120457664},{"$f":"E5*$B$36","v":1.586134120457664},null,{"$f":"SUM(F5:F14)","v":41.173951419957206},"Dividends paid over 10 years",null,null,null,null,null,"Year 1",{"$f":"P4*(1+$B$14)","v":525.28750000000002}]
["BVPS:",{"$f":"'Balance Sheet'!K32","v":44.27256944444445},null,"Year 2",19.033609445491965,1.9033609445491966,null,null,null,null,null,null,null,null,"Year 2",656.609375]
["P/E:",{"$f":"B3/B4","v":39.912135539795109},null,"Year 3",22.840331334590356,2.2840331334590358,null,{"$f":"$B$33*H4","v":2046.025917593563},"Projected price [Avg Sustainable P/E*EPS]",null,null,null,null,null,"Year 3",820.76171875]
["Earnings Yield:",{"$f":"B4/B3","v":2.505503618073586E-2},null,"Year 4",27.408397601508426,2.740839760150843,null,{"$f":"H7+H5","v":2087.1998690135201},"Total Gain [Projected Price+Dividends]",null,null,null,null,null,"Year 4",1025.9521484375]
["Dividend Yield:",{"$f":"B5/B3","v":2.274007729651745E-3},null,"Year 5",32.890077121810108,3.2890077121810108,null,null,null,null,null,null,null,null,"Year 5",1282.440185546875]
["P/BV:",{"$f":"B3/B6","v":11.915956237010311},null,"Year 6",39.46809254617213,3.9468092546172131,null,{"$f":"POWER(H8/$B$3,1/9)-1","v":0.16510941680132962},"Projected annual return using current EPS growth visibility",null,null,null,null,null,"Year 6",1603.0502319335938]
[null,null,null,"Year 7",47.361711055406552,4.736171105540655,null,null,"[(Total Gain/Current Price)^1/9)-1]",null,null,null,null,null,"Year 7",2003.8127899169922]
["Input Visibility data ","below",null,"Year 8",56.834053266487864,5.6834053266487867,null,null,null,null,null,null,null,null,"Year 8",2504.7659873962402]
["Sales",null,null,"Year 9",68.200863919785434,6.8200863919785437,null,null,null,null,null,null,null,null,"Year 9",3130.9574842453003]
["Med Term Visibility",0.25,null,"Year 10",81.841036703742517,8.1841036703742525,null,null,null,null,null,null,null,null,"Year 10",3913.6968553066254]
["Sales 10 Yr CAGR",{"$f":"POWER('Profit & Loss'!K4/'Profit & Loss'!B4, 1/9)-1","v":0.20122323557248878}]
["Sales 5yr CAGR",{"$f":"POWER('Profit & Loss'!K4/'Profit & Loss'!G4, 1/4)-1","v":0.21412460361884933},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.43623892516087337},null,"Year","BVPS","EPS","DPS"]
["Sales Y-o-Y growth",{"$f":"('Profit & Loss'!K4-'Profit & Loss'!J4)/'Profit & Loss'!J4","v":0.29704620512978797},null,"Current",{"$f":"B6","v":44.27256944444445},{"$f":"B4","v":13.217784337147201},{"$f":"B5","v":1.1996527777777779},{"$f":"F28","v":48.761045956176716},"Earnings after 10 years"]
["Sales TTM Growth",{"$f":"('Profit & Loss'!L4-'Profit & Loss'!K4)/'Profit & Loss'!K4","v":3.6599005306617791E-2},null,"Year 1",{"$f":"E18+F18-G18","v":56.290701003813872},{"$f":"E19*$B$37","v":11.145558798755147},{"$f":"F19*$B$36","v":1.1145558798755146},{"$f":"SUM(G19:G28)","v":25.984683247369396},"Dividends paid over 10 years"]
["EPS",null,null,"Year 2",{"$f":"E19+F19-G19","v":66.321703922693516},13.131697376693317,1.3131697376693319]
["Med Term Visibility",0.2,null,"Year 3",78.140231561717499,15.471765849220066,1.5471765849220067,{"$f":"$B$33*H18","v":1219.0261489044178},"Projected price [Avg Sustainable P/E*EPS]"]
["EPS 10 Yr CAGR",{"$f":"POWER('Profit & Loss'!K13/'Profit & Loss'!B13, 1/9)-1","v":0.40020570857074422},null,"Year 4",92.064820826015549,18.228834523551079,1.8228834523551081,{"$f":"H21+H19","v":1245.0108321517873},"Total Gain [Projected Price+Dividends]"]
["EPS 5yr CAGR",{"$f":"POWER('Profit & Loss'!K13/'Profit & Loss'!G13, 1/4)-1","v":0.33372525231723094},null,"Year 5",108.47077189721151,21.47721283564788,2.1477212835647879]
["EPS 3yr CAGR",{"$f":"POWER('Profit & Loss'!K13/'Profit & Loss'!I13, 1/2)-1","v":0.73896997189341906},null,"Year 6",127.8002634492946,25.304452162960335,2.5304452162960338,{"$f":"POWER(H22/$B$3,1/9)-1","v":0.10010563483995427},"Projected annual return using sustainable growth visbility*"]
["EPS Y-o-Y growth",{"$f":"('Profit & Loss'!K13-'Profit & Loss'!J13)/'Profit & Loss'!J13","v":0.40496344747979995},null,"Year 7",{"$f":"E24+F24-G24","v":150.57427039595891},29.813705538399866,2.9813705538399868,null,"[(Total Gain/Current Price)^1/9)-1]"]
["EPS TTM Growth",{"$f":"('Profit & Loss'!L13-'Profit & Loss'!K13)/'Profit & Loss'!K13","v":4.2509075475391969E-2},null,"Year 8",{"$f":"E25+F25-G25","v":177.40660538051878},35.126507865342724,3.5126507865342727]
["5Yr Averages",null,null,"Year 9",{"$f":"E26+F26-G26","v":209.02046245932723},41.386051566946797,4.1386051566946795]
["Return on Equity:",{"$f":"AVERAGE(Customization!G53:K53)","v":0.2136247685267863},null,"Year 10",{"$f":"E27+F27-G27","v":246.26790886957937},48.761045956176716,4.8761045956176723]
["Payout Ratio:",{"$f":"AVERAGE('Profit & Loss'!G23:K23)","v":9.0702016729628604E-2},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":40.496672600301245}]
["P/E Ratio-Low:",{"$f":"MIN('Calculated Data'!G38:K38)","v":6.4416300940438873}]
["Avg. P/E Ratio:",{"$f":"AVERAGE('Calculated Data'!G38:K39)","v":15.168319187815039}]
["Avg Sustainable P/E",25]
["RoE/Payout Visibility",null,"5 Yr Avg"]
["RoE Visibility",0.22,{"$f":"AVERAGE('Calculated Data'!G20:'Calculated Data'!K20)","v":0.2136247685267863}]
["Payout Visbility",0.1,{"$f":"AVERAGE('Calculated Data'!G21:K21)","v":9.0702016729628604E-2}]
["Sustainable Growth",{"$f":"B35*(1-B36)","v":0.19800000000000001},{"$f":"C35*(1-C36)","v":0.19424857119800668}]

{"sheet":"Deep Dive","index":11,"n_rows":15,"n_cols":18,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
[{"$f":"'Data Sheet'!B1","v":"SHIVALIK BIMETAL CONTROLS 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":435.61},{"$f":"'Calculated Data'!L7","v":76.14},{"$f":"'Calculated Data'!L4","v":107.58},{"$f":"'Calculated Data'!K24","v":0.27457649008799617},{"$f":"'Calculated Data'!K13","v":284.07},{"$f":"Customization!K42","v":0.10449169154819282},{"$f":"'Calculated Data'!L33","v":3038.91},{"$f":"Customization!H8","v":11.91682679110623},{"$f":"Customization!J8","v":6.9762172585569653},{"$f":"Customization!G8","v":39.912135539795109},{"$f":"IF(Customization!L8>0,0)","v":0},{"$f":"Customization!K8","v":2.2738416076817018E-3},{"$f":"Customization!I8","v":26.55778172138421},{"$f":"1/N4","v":2.505503618073586E-2}]
[null,"10Yr Incr FA Invest Rate","Dividend Payout","5yrAvg Sust. Growth","Retained Earnings / TA","RoE","WCap /TA","Wcap/ Sales","Capital Turns","Net Fixed Asset Turn","Gross Fixed Asset Turn","Cash Eqv","Invest ments","Net Profit","CFO","FCF/ Sales","Op Leverage"]
[null,{"$f":"'Price Implied Expectations'!K10","v":0.19783229758784204},{"$f":"'Calculated Data'!K21","v":9.4618649869916471E-2},{"$f":"'Buffet-Valuation'!C37","v":0.19424857119800668},{"$f":"'Calculated Data'!K46","v":0.18280848240205702},{"$f":"'Calculated Data'!K20","v":0.28638092623818673},{"$f":"'Calculated Data'!K45","v":0.49481600265420667},{"$f":"Customization!K25","v":0.42588582442947909},{"$f":"Customization!K49","v":1.4793184778399691},{"$f":"Customization!K50","v":4.1154637156008231},{"$f":"'Profit & Loss'!K4/'Balance Sheet'!K36","v":1.5238975921090805},{"$f":"'Balance Sheet'!K34","v":17.059999999999999},{"$f":"'Balance Sheet'!K12","v":23.59},{"$f":"'Calculated Data'!K7","v":73.03},{"$f":"'Cash Flow'!K4","v":61.22},{"$f":"'Calculated Data'!K19/'Profit & Loss'!K4","v":8.131261452061965E-2},{"$f":"'Calculated Data'!K30","v":1.4706884423671083}]
[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.41100933643566107},null,null,null,null,{"$f":"AVERAGE('Calculated Data'!G45:K45)","v":0.46052132263607454},{"$f":"AVERAGE(Customization!G51:K51)","v":1.0854130641200701},{"$f":"AVERAGE(Customization!G50:K50)","v":4.2147529368182415},{"$f":"'Price Implied Expectations'!B38","v":1157.8903035714291},0,{"$f":"L8/'Data Sheet'!B9","v":0.38102158457191199},{"$f":"1-N8","v":0.61897841542808796}]
[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":6.2811387900355856E-2},{"$f":"'Calculated Data'!C20","v":8.1143232588699085E-2},{"$f":"'Calculated Data'!D20","v":6.324049853823667E-2},{"$f":"'Calculated Data'!E20","v":0.12099943851768669},{"$f":"'Calculated Data'!F20","v":0.18752198897619327},{"$f":"'Calculated Data'!G20","v":0.21868485882129998},{"$f":"'Calculated Data'!H20","v":0.11064862989941032},{"$f":"'Calculated Data'!I20","v":0.17470881863560728},{"$f":"'Calculated Data'!J20","v":0.27770060903942723},{"$f":"'Calculated Data'!K20","v":0.28638092623818673}]
["CC Cycle",{"$f":"Customization!B30","v":138.44671623296156},{"$f":"Customization!C30","v":175.21686620457885},{"$f":"Customization!D30","v":145.85230146686899},{"$f":"Customization!E30","v":102.3697960559582},{"$f":"Customization!F30","v":84.995565691118699},{"$f":"Customization!G30","v":124.54806349862973},{"$f":"Customization!H30","v":108.88393334045506},{"$f":"Customization!I30","v":168.75785391714118},{"$f":"Customization!J30","v":156.35775795549245},{"$f":"Customization!K30","v":136.61768555314944}]
["Gr Margin",{"$f":"Customization!B35","v":0.39380421313506814},{"$f":"Customization!C35","v":0.3935097668557026},{"$f":"Customization!D35","v":0.4326757713707638},{"$f":"Customization!E35","v":0.45322770942187768},{"$f":"Customization!F35","v":0.43285189408336505},{"$f":"Customization!G35","v":0.43813020321629864},{"$f":"Customization!H35","v":0.47751308620873839},{"$f":"Customization!I35","v":0.44585705870803061},{"$f":"Customization!J35","v":0.46893422636501125},{"$f":"Customization!K35","v":0.46681579135235468}]
["Eq Dilution",{"$f":"'Cost Analysis'!B42","v":0},{"$f":"'Cost Analysis'!C42","v":0},{"$f":"'Cost Analysis'!D42","v":0},{"$f":"'Cost Analysis'!E42","v":0},{"$f":"'Cost Analysis'!F42","v":1},{"$f":"'Cost Analysis'!G42","v":0},{"$f":"'Cost Analysis'!H42","v":0},{"$f":"'Cost Analysis'!I42","v":0},{"$f":"'Cost Analysis'!J42","v":0},{"$f":"'Cost Analysis'!K42","v":0.5}]
["CFO",{"$f":"'Calculated Data'!B17","v":9.61},{"$f":"'Calculated Data'!C17","v":2.74},{"$f":"'Calculated Data'!D17","v":15.48},{"$f":"'Calculated Data'!E17","v":11.73},{"$f":"'Calculated Data'!F17","v":5.64},{"$f":"'Calculated Data'!G17","v":3.76},{"$f":"'Calculated Data'!H17","v":41.24},{"$f":"'Calculated Data'!I17","v":29.49},{"$f":"'Calculated Data'!J17","v":-3.48},{"$f":"'Calculated Data'!K17","v":61.22}]
["FCF/Sales",{"$f":"'Calculated Data'!B19/'Profit & Loss'!B4","v":0},{"$f":"'Calculated Data'!C19/'Profit & Loss'!C4","v":-1.2707414408737688E-2},{"$f":"'Calculated Data'!D19/'Profit & Loss'!D4","v":0.13717754172989377},{"$f":"'Calculated Data'!E19/'Profit & Loss'!E4","v":-2.8990392718692044E-2},{"$f":"'Calculated Data'!F19/'Profit & Loss'!F4","v":-8.4251868744457219E-3},{"$f":"'Calculated Data'!G19/'Profit & Loss'!G4","v":-1.2720409535136225E-2},{"$f":"'Calculated Data'!H19/'Profit & Loss'!H4","v":0.12589466937293026},{"$f":"'Calculated Data'!I19/'Profit & Loss'!I4","v":7.9079128215197289E-2},{"$f":"'Calculated Data'!J19/'Profit & Loss'!J4","v":-8.0095064662489585E-2},{"$f":"'Calculated Data'!K19/'Profit & Loss'!K4","v":8.131261452061965E-2}]