{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Profit & Loss","Quarters","Balance Sheet","Cash Flow","Customization","Data Sheet","KeyMetrics","Charts","Forecast"],"not_rendered":{"charts":38,"images":1,"macros":1,"external_links":1,"defined_names":4,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Profit & Loss","index":0,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
[{"$f":"'Data Sheet'!B1","v":"KNR CONSTRUCTIONS LTD"},null,null,null,null,null,null,{"$f":"UPDATE","v":""},null,null,null,null,"SCREENER.IN"]
[]
["Narration",{"$f":"'Data Sheet'!B16","v":"2015-03-31"},{"$f":"'Data Sheet'!C16","v":"2016-03-31"},{"$f":"'Data Sheet'!D16","v":"2017-03-31"},{"$f":"'Data Sheet'!E16","v":"2018-03-31"},{"$f":"'Data Sheet'!F16","v":"2019-03-31"},{"$f":"'Data Sheet'!G16","v":"2020-03-31"},{"$f":"'Data Sheet'!H16","v":"2021-03-31"},{"$f":"'Data Sheet'!I16","v":"2022-03-31"},{"$f":"'Data Sheet'!J16","v":"2023-03-31"},{"$f":"'Data Sheet'!K16","v":"2024-03-31"},"Trailing","Best Case","Worst Case"]
["Sales",{"$f":"'Data Sheet'!B17","v":904.4},{"$f":"'Data Sheet'!C17","v":1191.68},{"$f":"'Data Sheet'!D17","v":1642.13},{"$f":"'Data Sheet'!E17","v":2069.6},{"$f":"'Data Sheet'!F17","v":2291.5},{"$f":"'Data Sheet'!G17","v":2451.6799999999998},{"$f":"'Data Sheet'!H17","v":2903.63},{"$f":"'Data Sheet'!I17","v":3605.82},{"$f":"'Data Sheet'!J17","v":4062.36},{"$f":"'Data Sheet'!K17","v":4429.49},{"$f":"SUM(Quarters!H4:K4)","v":4433.46},{"$f":"$K4+M23*K4","v":5099.072760715133},{"$f":"$K4+N23*L4","v":4830.1576340353877}]
["Expenses",{"$f":"SUM('Data Sheet'!B18,'Data Sheet'!B20:B24, -1*'Data Sheet'!B19)","v":777.58},{"$f":"SUM('Data Sheet'!C18,'Data Sheet'!C20:C24, -1*'Data Sheet'!C19)","v":1019.36},{"$f":"SUM('Data Sheet'!D18,'Data Sheet'!D20:D24, -1*'Data Sheet'!D19)","v":1377.67},{"$f":"SUM('Data Sheet'!E18,'Data Sheet'!E20:E24, -1*'Data Sheet'!E19)","v":1620.21},{"$f":"SUM('Data Sheet'!F18,'Data Sheet'!F20:F24, -1*'Data Sheet'!F19)","v":1753.93},{"$f":"SUM('Data Sheet'!G18,'Data Sheet'!G20:G24, -1*'Data Sheet'!G19)","v":1828.69},{"$f":"SUM('Data Sheet'!H18,'Data Sheet'!H20:H24, -1*'Data Sheet'!H19)","v":2204.7199999999998},{"$f":"SUM('Data Sheet'!I18,'Data Sheet'!I20:I24, -1*'Data Sheet'!I19)","v":2804.1100000000006},{"$f":"SUM('Data Sheet'!J18,'Data Sheet'!J20:J24, -1*'Data Sheet'!J19)","v":3144.6800000000003},{"$f":"SUM('Data Sheet'!K18,'Data Sheet'!K20:K24, -1*'Data Sheet'!K19)","v":3381.74},{"$f":"SUM(Quarters!H5:K5)","v":3322.84},{"$f":"M4-M6","v":3821.7110185306001},3764.1022240151519]
["Operating Profit",{"$f":"B4-B5","v":126.81999999999994},{"$f":"C4-C5","v":172.32000000000005},264.46000000000004,449.38999999999987,537.56999999999994,622.98999999999978,698.91000000000031,801.70999999999958,917.67999999999984,1047.75,{"$f":"SUM(Quarters!H6:K6)","v":1110.6199999999999},{"$f":"M4*M24","v":1277.3617421845331},{"$f":"N4*N24","v":1066.0554100202357}]
["Other Income",{"$f":"'Data Sheet'!B25","v":13.62},{"$f":"'Data Sheet'!C25","v":45.75},{"$f":"'Data Sheet'!D25","v":29.57},{"$f":"'Data Sheet'!E25","v":54.94},{"$f":"'Data Sheet'!F25","v":74.760000000000005},{"$f":"'Data Sheet'!G25","v":66.39},{"$f":"'Data Sheet'!H25","v":143.99},{"$f":"'Data Sheet'!I25","v":77.73},{"$f":"'Data Sheet'!J25","v":97.67},{"$f":"'Data Sheet'!K25","v":144.69},{"$f":"SUM(Quarters!H7:K7)","v":158.01000000000002},0,0]
["Depreciation",{"$f":"'Data Sheet'!B26","v":55.17},{"$f":"'Data Sheet'!C26","v":70.86},{"$f":"'Data Sheet'!D26","v":115.63},{"$f":"'Data Sheet'!E26","v":193.6},{"$f":"'Data Sheet'!F26","v":230.13},{"$f":"'Data Sheet'!G26","v":254.13},{"$f":"'Data Sheet'!H26","v":189.9},{"$f":"'Data Sheet'!I26","v":164.92},{"$f":"'Data Sheet'!J26","v":180.7},{"$f":"'Data Sheet'!K26","v":156.83000000000001},{"$f":"SUM(Quarters!H8:K8)","v":150.5},{"$f":"+$L8","v":150.5},{"$f":"+$L8","v":150.5}]
["Interest",{"$f":"'Data Sheet'!B27","v":13.8},{"$f":"'Data Sheet'!C27","v":57},{"$f":"'Data Sheet'!D27","v":72.67},{"$f":"'Data Sheet'!E27","v":82.5},{"$f":"'Data Sheet'!F27","v":89.84},{"$f":"'Data Sheet'!G27","v":110.78},{"$f":"'Data Sheet'!H27","v":133.21},{"$f":"'Data Sheet'!I27","v":151.13999999999999},{"$f":"'Data Sheet'!J27","v":153.4},{"$f":"'Data Sheet'!K27","v":105.67},{"$f":"SUM(Quarters!H9:K9)","v":122.47},{"$f":"+$L9","v":122.47},{"$f":"+$L9","v":122.47}]
["Profit before tax",{"$f":"'Data Sheet'!B28","v":71.47},{"$f":"'Data Sheet'!C28","v":90.21},{"$f":"'Data Sheet'!D28","v":105.73},{"$f":"'Data Sheet'!E28","v":228.23},{"$f":"'Data Sheet'!F28","v":292.36},{"$f":"'Data Sheet'!G28","v":324.47000000000003},{"$f":"'Data Sheet'!H28","v":519.79},{"$f":"'Data Sheet'!I28","v":563.38},{"$f":"'Data Sheet'!J28","v":681.25},{"$f":"'Data Sheet'!K28","v":929.94},{"$f":"SUM(Quarters!H10:K10)","v":995.66000000000008},{"$f":"M6+M7-SUM(M8:M9)","v":1004.3917421845331},{"$f":"N6+N7-SUM(N8:N9)","v":793.08541002023571}]
["Tax",{"$f":"'Data Sheet'!B29","v":-0.28000000000000003},{"$f":"'Data Sheet'!C29","v":-21.89},{"$f":"'Data Sheet'!D29","v":6.99},{"$f":"'Data Sheet'!E29","v":-0.73},{"$f":"'Data Sheet'!F29","v":27.47},{"$f":"'Data Sheet'!G29","v":68.53},{"$f":"'Data Sheet'!H29","v":136.96},{"$f":"'Data Sheet'!I29","v":196.99},{"$f":"'Data Sheet'!J29","v":241.84},{"$f":"'Data Sheet'!K29","v":196.17},{"$f":"SUM(Quarters!H11:K11)","v":212.11},{"$f":"IF($L10>0,$L11/$L10,0)","v":0.21303457003394732},{"$f":"IF($L10>0,$L11/$L10,0)","v":0.21303457003394732}]
["Net profit",{"$f":"'Data Sheet'!B30","v":69.760000000000005},{"$f":"'Data Sheet'!C30","v":112.13},{"$f":"'Data Sheet'!D30","v":114.9},{"$f":"'Data Sheet'!E30","v":243.48},{"$f":"'Data Sheet'!F30","v":270.51},{"$f":"'Data Sheet'!G30","v":265.51},{"$f":"'Data Sheet'!H30","v":407.38},{"$f":"'Data Sheet'!I30","v":381.84},{"$f":"'Data Sheet'!J30","v":458.01},{"$f":"'Data Sheet'!K30","v":777.4},{"$f":"SUM(Quarters!H12:K12)","v":812.87},{"$f":"M10-M11*M10","v":790.4215792426038},{"$f":"N10-N11*N10","v":624.13080069637795}]
["EPS",{"$f":"IF('Data Sheet'!B93>0,B12/'Data Sheet'!B93,0)","v":2.4825622775800711},{"$f":"IF('Data Sheet'!C93>0,C12/'Data Sheet'!C93,0)","v":3.9903914590747327},{"$f":"IF('Data Sheet'!D93>0,D12/'Data Sheet'!D93,0)","v":4.0860597439544808},{"$f":"IF('Data Sheet'!E93>0,E12/'Data Sheet'!E93,0)","v":8.6586059743954475},{"$f":"IF('Data Sheet'!F93>0,F12/'Data Sheet'!F93,0)","v":9.6198435277382632},{"$f":"IF('Data Sheet'!G93>0,G12/'Data Sheet'!G93,0)","v":9.4420341394025602},{"$f":"IF('Data Sheet'!H93>0,H12/'Data Sheet'!H93,0)","v":14.487197724039829},{"$f":"IF('Data Sheet'!I93>0,I12/'Data Sheet'!I93,0)","v":13.578947368421051},{"$f":"IF('Data Sheet'!J93>0,J12/'Data Sheet'!J93,0)","v":16.287695590327168},{"$f":"IF('Data Sheet'!K93>0,K12/'Data Sheet'!K93,0)","v":27.645803698435277},{"$f":"IF('Data Sheet'!$B6>0,'Profit & Loss'!L12/'Data Sheet'!$B6,0)","v":28.903624802762106},{"$f":"IF('Data Sheet'!$B6>0,'Profit & Loss'!M12/'Data Sheet'!$B6,0)","v":28.105415087818368},{"$f":"IF('Data Sheet'!$B6>0,'Profit & Loss'!N12/'Data Sheet'!$B6,0)","v":22.192530775124688}]
["Price to earning",{"$f":"IF(B15>0,B15/B13,\"\")","v":17.111353211009174},{"$f":"IF(C15>0,C15/C13,\"\")","v":12.765664853295283},23.587516100957352,16.399868572367343,13.584420538981925,10.405596776015969,14.730246943885316,20.925775193798451,15.576175192681383,8.9091278621044516,{"$f":"IF(L13>0,L15/L13,0)","v":11.811667302274659},{"$f":"M25","v":14.305686387714736},{"$f":"N25","v":11.811667302274659}]
["Price",{"$f":"'Data Sheet'!B90","v":42.48},{"$f":"'Data Sheet'!C90","v":50.94},{"$f":"'Data Sheet'!D90","v":96.38},{"$f":"'Data Sheet'!E90","v":142},{"$f":"'Data Sheet'!F90","v":130.68},{"$f":"'Data Sheet'!G90","v":98.25},{"$f":"'Data Sheet'!H90","v":213.4},{"$f":"'Data Sheet'!I90","v":284.14999999999998},{"$f":"'Data Sheet'!J90","v":253.7},{"$f":"'Data Sheet'!K90","v":246.3},{"$f":"'Data Sheet'!B8","v":341.4},{"$f":"M13*M14","v":402.06725404287562},{"$f":"N13*N14","v":262.13079011126433}]
[]
["RATIOS:"]
["Dividend Payout",{"$f":"IF('Data Sheet'!B30>0, 'Data Sheet'!B31/'Data Sheet'!B30, 0)","v":4.0280963302752291E-2},{"$f":"IF('Data Sheet'!C30>0, 'Data Sheet'!C31/'Data Sheet'!C30, 0)","v":5.0120395968964594E-2},{"$f":"IF('Data Sheet'!D30>0, 'Data Sheet'!D31/'Data Sheet'!D30, 0)","v":6.1183637946040037E-2},{"$f":"IF('Data Sheet'!E30>0, 'Data Sheet'!E31/'Data Sheet'!E30, 0)","v":2.308197798587153E-2},{"$f":"IF('Data Sheet'!F30>0, 'Data Sheet'!F31/'Data Sheet'!F30, 0)","v":2.0775572067576062E-2},{"$f":"IF('Data Sheet'!G30>0, 'Data Sheet'!G31/'Data Sheet'!G30, 0)","v":2.6477345486045724E-2},{"$f":"IF('Data Sheet'!H30>0, 'Data Sheet'!H31/'Data Sheet'!H30, 0)","v":1.7256615445039029E-2},{"$f":"IF('Data Sheet'!I30>0, 'Data Sheet'!I31/'Data Sheet'!I30, 0)","v":1.8410852713178296E-2},{"$f":"IF('Data Sheet'!J30>0, 'Data Sheet'!J31/'Data Sheet'!J30, 0)","v":1.5349009846946574E-2},{"$f":"IF('Data Sheet'!K30>0, 'Data Sheet'!K31/'Data Sheet'!K30, 0)","v":9.0429637252379732E-3}]
["OPM",{"$f":"IF(B6>0,B6/B4,0)","v":0.14022556390977436},{"$f":"IF(C6>0,C6/C4,0)","v":0.14460257787325459},0.16104693294684344,0.21713857750289906,0.23459306131355004,0.25410738758728701,0.24070215557767355,0.22233777615077835,0.22589824633956612,0.2365396467764912,0.25050863208419605]
[]
[]
[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.19306995212280076},{"$f":"IF(D4=0,\"\",POWER($K4/D4,1/7)-1)","v":0.15229516995920722},{"$f":"IF(F4=0,\"\",POWER($K4/F4,1/5)-1)","v":0.14089787911639595},{"$f":"IF(H4=0,\"\",POWER($K4/H4, 1/3)-1)","v":0.15116475276276353},{"$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":9.0373575950924989E-2},{"$f":"MAX(K23:L23)","v":0.15116475276276353},{"$f":"MIN(H23:L23)","v":9.0373575950924989E-2}]
[null,null,null,null,null,null,"OPM",{"$f":"IF(SUM(B4:$K$4)=0,\"\",SUMPRODUCT(B19:$K$19,B4:$K$4)/SUM(B4:$K$4))","v":0.22070820266989766},{"$f":"IF(SUM(E4:$K$4)=0,\"\",SUMPRODUCT(E19:$K$19,E4:$K$4)/SUM(E4:$K$4))","v":0.23269374642432772},{"$f":"IF(SUM(G4:$K$4)=0,\"\",SUMPRODUCT(G19:$K$19,G4:$K$4)/SUM(G4:$K$4))","v":0.23428892945502713},{"$f":"IF(SUM(I4:$K$4)=0, \"\", SUMPRODUCT(I19:$K$19,I4:$K$4)/SUM(I4:$K$4))","v":0.22873330153657684},{"$f":"L19","v":0.25050863208419605},{"$f":"MAX(K24:L24)","v":0.25050863208419605},{"$f":"MIN(H24:L24)","v":0.22070820266989766}]
[null,null,null,null,null,null,"Price to Earning",{"$f":"IF(ISERROR(AVERAGEIF(B14:$L14,\">0\")),\"\",AVERAGEIF(B14:$L14,\">0\"))","v":15.073401140670116},{"$f":"IF(ISERROR(AVERAGEIF(E14:$L14,\">0\")),\"\",AVERAGEIF(E14:$L14,\">0\"))","v":14.042859797763688},{"$f":"IF(ISERROR(AVERAGEIF(G14:$L14,\">0\")),\"\",AVERAGEIF(G14:$L14,\">0\"))","v":13.726431545126703},{"$f":"IF(ISERROR(AVERAGEIF(I14:$L14,\">0\")),\"\",AVERAGEIF(I14:$L14,\">0\"))","v":14.305686387714736},{"$f":"L14","v":11.811667302274659},{"$f":"MAX(K25:L25)","v":14.305686387714736},{"$f":"MIN(H25:L25)","v":11.811667302274659}]

{"sheet":"Quarters","index":1,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[{"$f":"'Profit & Loss'!A1","v":"KNR CONSTRUCTIONS LTD"},null,null,null,{"$f":"UPDATE","v":""},null,null,null,null,"SCREENER.IN"]
[]
["Narration",{"$f":"'Data Sheet'!B41","v":"2022-03-31"},{"$f":"'Data Sheet'!C41","v":"2022-06-30"},{"$f":"'Data Sheet'!D41","v":"2022-09-30"},{"$f":"'Data Sheet'!E41","v":"2022-12-31"},{"$f":"'Data Sheet'!F41","v":"2023-03-31"},{"$f":"'Data Sheet'!G41","v":"2023-06-30"},{"$f":"'Data Sheet'!H41","v":"2023-09-30"},{"$f":"'Data Sheet'!I41","v":"2023-12-31"},{"$f":"'Data Sheet'!J41","v":"2024-03-31"},{"$f":"'Data Sheet'!K41","v":"2024-06-30"}]
["Sales",{"$f":"'Data Sheet'!B42","v":1102.0899999999999},{"$f":"'Data Sheet'!C42","v":980.45},{"$f":"'Data Sheet'!D42","v":961.65},{"$f":"'Data Sheet'!E42","v":874.93},{"$f":"'Data Sheet'!F42","v":1245.33},{"$f":"'Data Sheet'!G42","v":981.02},{"$f":"'Data Sheet'!H42","v":1038.45},{"$f":"'Data Sheet'!I42","v":996.01},{"$f":"'Data Sheet'!J42","v":1414},{"$f":"'Data Sheet'!K42","v":985}]
["Expenses",{"$f":"'Data Sheet'!B43","v":823.22},{"$f":"'Data Sheet'!C43","v":769.19},{"$f":"'Data Sheet'!D43","v":698.36},{"$f":"'Data Sheet'!E43","v":678.14},{"$f":"'Data Sheet'!F43","v":999.36},{"$f":"'Data Sheet'!G43","v":765.28},{"$f":"'Data Sheet'!H43","v":806.86},{"$f":"'Data Sheet'!I43","v":770.1},{"$f":"'Data Sheet'!J43","v":1039.48},{"$f":"'Data Sheet'!K43","v":706.4}]
["Operating Profit",{"$f":"'Data Sheet'!B50","v":278.87},{"$f":"'Data Sheet'!C50","v":211.26},{"$f":"'Data Sheet'!D50","v":263.29000000000002},{"$f":"'Data Sheet'!E50","v":196.79},{"$f":"'Data Sheet'!F50","v":245.97},{"$f":"'Data Sheet'!G50","v":215.74},{"$f":"'Data Sheet'!H50","v":231.59},{"$f":"'Data Sheet'!I50","v":225.91},{"$f":"'Data Sheet'!J50","v":374.52},{"$f":"'Data Sheet'!K50","v":278.60000000000002}]
["Other Income",{"$f":"'Data Sheet'!B44","v":19.829999999999998},{"$f":"'Data Sheet'!C44","v":10.119999999999999},{"$f":"'Data Sheet'!D44","v":9.93},{"$f":"'Data Sheet'!E44","v":68.38},{"$f":"'Data Sheet'!F44","v":10.1},{"$f":"'Data Sheet'!G44","v":7.58},{"$f":"'Data Sheet'!H44","v":5.34},{"$f":"'Data Sheet'!I44","v":6.52},{"$f":"'Data Sheet'!J44","v":125.25},{"$f":"'Data Sheet'!K44","v":20.9}]
["Depreciation",{"$f":"'Data Sheet'!B45","v":47.82},{"$f":"'Data Sheet'!C45","v":40.97},{"$f":"'Data Sheet'!D45","v":45.01},{"$f":"'Data Sheet'!E45","v":46.48},{"$f":"'Data Sheet'!F45","v":48.24},{"$f":"'Data Sheet'!G45","v":36.4},{"$f":"'Data Sheet'!H45","v":39.21},{"$f":"'Data Sheet'!I45","v":40.68},{"$f":"'Data Sheet'!J45","v":40.54},{"$f":"'Data Sheet'!K45","v":30.07}]
["Interest",{"$f":"'Data Sheet'!B46","v":43.31},{"$f":"'Data Sheet'!C46","v":54.53},{"$f":"'Data Sheet'!D46","v":44.61},{"$f":"'Data Sheet'!E46","v":33.380000000000003},{"$f":"'Data Sheet'!F46","v":20.56},{"$f":"'Data Sheet'!G46","v":20.34},{"$f":"'Data Sheet'!H46","v":20.61},{"$f":"'Data Sheet'!I46","v":27.66},{"$f":"'Data Sheet'!J46","v":37.07},{"$f":"'Data Sheet'!K46","v":37.130000000000003}]
["Profit before tax",{"$f":"'Data Sheet'!B47","v":207.57},{"$f":"'Data Sheet'!C47","v":125.88},{"$f":"'Data Sheet'!D47","v":183.6},{"$f":"'Data Sheet'!E47","v":185.31},{"$f":"'Data Sheet'!F47","v":187.27},{"$f":"'Data Sheet'!G47","v":166.58},{"$f":"'Data Sheet'!H47","v":177.11},{"$f":"'Data Sheet'!I47","v":164.09},{"$f":"'Data Sheet'!J47","v":422.16},{"$f":"'Data Sheet'!K47","v":232.3}]
["Tax",{"$f":"'Data Sheet'!B48","v":67.86},{"$f":"'Data Sheet'!C48","v":33.61},{"$f":"'Data Sheet'!D48","v":85.09},{"$f":"'Data Sheet'!E48","v":77.89},{"$f":"'Data Sheet'!F48","v":45.24},{"$f":"'Data Sheet'!G48","v":38.700000000000003},{"$f":"'Data Sheet'!H48","v":34.56},{"$f":"'Data Sheet'!I48","v":28.26},{"$f":"'Data Sheet'!J48","v":94.65},{"$f":"'Data Sheet'!K48","v":54.64}]
["Net profit",{"$f":"'Data Sheet'!B49","v":139.16},{"$f":"'Data Sheet'!C49","v":89.61},{"$f":"'Data Sheet'!D49","v":115.37},{"$f":"'Data Sheet'!E49","v":105.76},{"$f":"'Data Sheet'!F49","v":147.27000000000001},{"$f":"'Data Sheet'!G49","v":137.11000000000001},{"$f":"'Data Sheet'!H49","v":147.38},{"$f":"'Data Sheet'!I49","v":139.61000000000001},{"$f":"'Data Sheet'!J49","v":353.3},{"$f":"'Data Sheet'!K49","v":172.58}]
[]
["OPM",{"$f":"IF(B4>0,B6/B4,\"\")","v":0.25303741073778008},{"$f":"IF(C4>0,C6/C4,\"\")","v":0.2154724871232597},0.27378984037851611,0.22492085081092203,0.19751391197513912,0.21991396709547206,0.2230150705378208,0.22681499181735124,0.26486562942008485,0.28284263959390865]

{"sheet":"Balance Sheet","index":2,"n_rows":37,"n_cols":12,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
[{"$f":"'Profit & Loss'!A1","v":"KNR CONSTRUCTIONS LTD"},null,null,null,{"$f":"UPDATE","v":""},null,null,null,null,"SCREENER.IN"]
[]
["Narration",{"$f":"'Data Sheet'!B56","v":"2015-03-31"},{"$f":"'Data Sheet'!C56","v":"2016-03-31"},{"$f":"'Data Sheet'!D56","v":"2017-03-31"},{"$f":"'Data Sheet'!E56","v":"2018-03-31"},{"$f":"'Data Sheet'!F56","v":"2019-03-31"},{"$f":"'Data Sheet'!G56","v":"2020-03-31"},{"$f":"'Data Sheet'!H56","v":"2021-03-31"},{"$f":"'Data Sheet'!I56","v":"2022-03-31"},{"$f":"'Data Sheet'!J56","v":"2023-03-31"},{"$f":"'Data Sheet'!K56","v":"2024-03-31"}]
["Equity Share Capital",{"$f":"'Data Sheet'!B57","v":28.12},{"$f":"'Data Sheet'!C57","v":28.12},{"$f":"'Data Sheet'!D57","v":28.12},{"$f":"'Data Sheet'!E57","v":28.12},{"$f":"'Data Sheet'!F57","v":28.12},{"$f":"'Data Sheet'!G57","v":28.12},{"$f":"'Data Sheet'!H57","v":56.25},{"$f":"'Data Sheet'!I57","v":56.25},{"$f":"'Data Sheet'!J57","v":56.25},{"$f":"'Data Sheet'!K57","v":56.25}]
["Reserves",{"$f":"'Data Sheet'!B58","v":760.35},{"$f":"'Data Sheet'!C58","v":670.5},{"$f":"'Data Sheet'!D58","v":777.3},{"$f":"'Data Sheet'!E58","v":1011.14},{"$f":"'Data Sheet'!F58","v":1274.2},{"$f":"'Data Sheet'!G58","v":1524.04},{"$f":"'Data Sheet'!H58","v":1903.07},{"$f":"'Data Sheet'!I58","v":2262.96},{"$f":"'Data Sheet'!J58","v":2714.45},{"$f":"'Data Sheet'!K58","v":3497.9}]
["Borrowings",{"$f":"'Data Sheet'!B59","v":733.64},{"$f":"'Data Sheet'!C59","v":735.41},{"$f":"'Data Sheet'!D59","v":721.14},{"$f":"'Data Sheet'!E59","v":770.4},{"$f":"'Data Sheet'!F59","v":758.21},{"$f":"'Data Sheet'!G59","v":874.54},{"$f":"'Data Sheet'!H59","v":764.37},{"$f":"'Data Sheet'!I59","v":1463.54},{"$f":"'Data Sheet'!J59","v":652.05999999999995},{"$f":"'Data Sheet'!K59","v":1262.43}]
["Other Liabilities",{"$f":"'Data Sheet'!B60","v":489.54},{"$f":"'Data Sheet'!C60","v":551.59},{"$f":"'Data Sheet'!D60","v":715.63},{"$f":"'Data Sheet'!E60","v":798.32},{"$f":"'Data Sheet'!F60","v":668.53},{"$f":"'Data Sheet'!G60","v":1076.6400000000001},{"$f":"'Data Sheet'!H60","v":1283.49},{"$f":"'Data Sheet'!I60","v":1487.58},{"$f":"'Data Sheet'!J60","v":919.25},{"$f":"'Data Sheet'!K60","v":987.21}]
["Total",{"$f":"'Data Sheet'!B61","v":2011.65},{"$f":"'Data Sheet'!C61","v":1985.62},{"$f":"'Data Sheet'!D61","v":2242.19},{"$f":"'Data Sheet'!E61","v":2607.98},{"$f":"'Data Sheet'!F61","v":2729.06},{"$f":"'Data Sheet'!G61","v":3503.34},{"$f":"'Data Sheet'!H61","v":4007.18},{"$f":"'Data Sheet'!I61","v":5270.33},{"$f":"'Data Sheet'!J61","v":4342.01},{"$f":"'Data Sheet'!K61","v":5803.79}]
[]
["Net Block",{"$f":"'Data Sheet'!B62","v":234.94},{"$f":"'Data Sheet'!C62","v":737.79},{"$f":"'Data Sheet'!D62","v":1228.44},{"$f":"'Data Sheet'!E62","v":1341.35},{"$f":"'Data Sheet'!F62","v":1320.52},{"$f":"'Data Sheet'!G62","v":1274.82},{"$f":"'Data Sheet'!H62","v":776},{"$f":"'Data Sheet'!I62","v":889.9},{"$f":"'Data Sheet'!J62","v":890.49},{"$f":"'Data Sheet'!K62","v":806.36}]
["Capital Work in Progress",{"$f":"'Data Sheet'!B63","v":1108.26},{"$f":"'Data Sheet'!C63","v":428.71},{"$f":"'Data Sheet'!D63","v":91.26},{"$f":"'Data Sheet'!E63","v":1.1499999999999999},{"$f":"'Data Sheet'!F63","v":0.01},{"$f":"'Data Sheet'!G63","v":10.15},{"$f":"'Data Sheet'!H63","v":2.38},{"$f":"'Data Sheet'!I63","v":20.62},{"$f":"'Data Sheet'!J63","v":2.5099999999999998},{"$f":"'Data Sheet'!K63","v":2.1800000000000002}]
["Investments",{"$f":"'Data Sheet'!B64","v":23.64},{"$f":"'Data Sheet'!C64","v":105.87},{"$f":"'Data Sheet'!D64","v":73.59},{"$f":"'Data Sheet'!E64","v":52.67},{"$f":"'Data Sheet'!F64","v":51.93},{"$f":"'Data Sheet'!G64","v":65.84},{"$f":"'Data Sheet'!H64","v":61.67},{"$f":"'Data Sheet'!I64","v":73.260000000000005},{"$f":"'Data Sheet'!J64","v":72.349999999999994},{"$f":"'Data Sheet'!K64","v":115.18}]
["Other Assets",{"$f":"'Data Sheet'!B65","v":644.80999999999995},{"$f":"'Data Sheet'!C65","v":713.25},{"$f":"'Data Sheet'!D65","v":848.9},{"$f":"'Data Sheet'!E65","v":1212.81},{"$f":"'Data Sheet'!F65","v":1356.6},{"$f":"'Data Sheet'!G65","v":2152.5300000000002},{"$f":"'Data Sheet'!H65","v":3167.13},{"$f":"'Data Sheet'!I65","v":4286.55},{"$f":"'Data Sheet'!J65","v":3376.66},{"$f":"'Data Sheet'!K65","v":4880.07}]
["Total",{"$f":"'Data Sheet'!B66","v":2011.65},{"$f":"'Data Sheet'!C66","v":1985.62},{"$f":"'Data Sheet'!D66","v":2242.19},{"$f":"'Data Sheet'!E66","v":2607.98},{"$f":"'Data Sheet'!F66","v":2729.06},{"$f":"'Data Sheet'!G66","v":3503.34},{"$f":"'Data Sheet'!H66","v":4007.18},{"$f":"'Data Sheet'!I66","v":5270.33},{"$f":"'Data Sheet'!J66","v":4342.01},{"$f":"'Data Sheet'!K66","v":5803.79}]
[]
["Working Capital",{"$f":"B13-B7","v":155.26999999999992},{"$f":"C13-C7","v":161.65999999999997},133.26999999999998,414.4899999999999,688.06999999999994,1075.8900000000001,1883.64,2798.9700000000003,2457.41,3892.8599999999997]
["Debtors",{"$f":"'Data Sheet'!B67","v":110.13},{"$f":"'Data Sheet'!C67","v":134.6},{"$f":"'Data Sheet'!D67","v":181.69},{"$f":"'Data Sheet'!E67","v":269.14},{"$f":"'Data Sheet'!F67","v":96.8},{"$f":"'Data Sheet'!G67","v":174.65},{"$f":"'Data Sheet'!H67","v":332.87},{"$f":"'Data Sheet'!I67","v":598.41},{"$f":"'Data Sheet'!J67","v":622.9},{"$f":"'Data Sheet'!K67","v":673.98}]
["Inventory",{"$f":"'Data Sheet'!B68","v":55.73},{"$f":"'Data Sheet'!C68","v":61.83},{"$f":"'Data Sheet'!D68","v":80.540000000000006},{"$f":"'Data Sheet'!E68","v":75.05},{"$f":"'Data Sheet'!F68","v":101.19},{"$f":"'Data Sheet'!G68","v":123.16},{"$f":"'Data Sheet'!H68","v":147.99},{"$f":"'Data Sheet'!I68","v":227.41},{"$f":"'Data Sheet'!J68","v":234.23},{"$f":"'Data Sheet'!K68","v":220.87}]
[]
["Inventory Turnover",{"$f":"IF('Balance Sheet'!B18>0,'Profit & Loss'!B4/'Balance Sheet'!B18,0)","v":16.2282433159878},{"$f":"IF('Balance Sheet'!C18>0,'Profit & Loss'!C4/'Balance Sheet'!C18,0)","v":19.273491832443799},{"$f":"IF('Balance Sheet'!D18>0,'Profit & Loss'!D4/'Balance Sheet'!D18,0)","v":20.388999255028558},{"$f":"IF('Balance Sheet'!E18>0,'Profit & Loss'!E4/'Balance Sheet'!E18,0)","v":27.576282478347768},{"$f":"IF('Balance Sheet'!F18>0,'Profit & Loss'!F4/'Balance Sheet'!F18,0)","v":22.645518331850973},{"$f":"IF('Balance Sheet'!G18>0,'Profit & Loss'!G4/'Balance Sheet'!G18,0)","v":19.906463137382268},{"$f":"IF('Balance Sheet'!H18>0,'Profit & Loss'!H4/'Balance Sheet'!H18,0)","v":19.620447327522129},{"$f":"IF('Balance Sheet'!I18>0,'Profit & Loss'!I4/'Balance Sheet'!I18,0)","v":15.85603095730179},{"$f":"IF('Balance Sheet'!J18>0,'Profit & Loss'!J4/'Balance Sheet'!J18,0)","v":17.343465824189899},{"$f":"IF('Balance Sheet'!K18>0,'Profit & Loss'!K4/'Balance Sheet'!K18,0)","v":20.054738081224247}]
["Inventory Days",{"$f":"IF('Profit & Loss'!B4>0,'Balance Sheet'!B18/('Profit & Loss'!B4/365),0)","v":22.491651923927467},{"$f":"IF('Profit & Loss'!C4>0,'Balance Sheet'!C18/('Profit & Loss'!C4/365),0)","v":18.937927967239528},{"$f":"IF('Profit & Loss'!D4>0,'Balance Sheet'!D18/('Profit & Loss'!D4/365),0)","v":17.901810453496374},{"$f":"IF('Profit & Loss'!E4>0,'Balance Sheet'!E18/('Profit & Loss'!E4/365),0)","v":13.23601178971782},{"$f":"IF('Profit & Loss'!F4>0,'Balance Sheet'!F18/('Profit & Loss'!F4/365),0)","v":16.117979489417412},{"$f":"IF('Profit & Loss'!G4>0,'Balance Sheet'!G18/('Profit & Loss'!G4/365),0)","v":18.335753442537364},{"$f":"IF('Profit & Loss'!H4>0,'Balance Sheet'!H18/('Profit & Loss'!H4/365),0)","v":18.603041709859728},{"$f":"IF('Profit & Loss'!I4>0,'Balance Sheet'!I18/('Profit & Loss'!I4/365),0)","v":23.01963215024599},{"$f":"IF('Profit & Loss'!J4>0,'Balance Sheet'!J18/('Profit & Loss'!J4/365),0)","v":21.045389871897122},{"$f":"IF('Profit & Loss'!K4>0,'Balance Sheet'!K18/('Profit & Loss'!K4/365),0)","v":18.200187832007749}]
["Debtor Days",{"$f":"IF('Profit & Loss'!B4>0,'Balance Sheet'!B17/('Profit & Loss'!B4/365),0)","v":44.446539141972579},{"$f":"IF('Profit & Loss'!C4>0,'Balance Sheet'!C17/('Profit & Loss'!C4/365),0)","v":41.226671589688507},{"$f":"IF('Profit & Loss'!D4>0,'Balance Sheet'!D17/('Profit & Loss'!D4/365),0)","v":40.38465285939602},{"$f":"IF('Profit & Loss'!E4>0,'Balance Sheet'!E17/('Profit & Loss'!E4/365),0)","v":47.466225357557015},{"$f":"IF('Profit & Loss'!F4>0,'Balance Sheet'!F17/('Profit & Loss'!F4/365),0)","v":15.418721361553567},{"$f":"IF('Profit & Loss'!G4>0,'Balance Sheet'!G17/('Profit & Loss'!G4/365),0)","v":26.001456144358158},{"$f":"IF('Profit & Loss'!H4>0,'Balance Sheet'!H17/('Profit & Loss'!H4/365),0)","v":41.843330589641241},{"$f":"IF('Profit & Loss'!I4>0,'Balance Sheet'!I17/('Profit & Loss'!I4/365),0)","v":60.574196715310244},{"$f":"IF('Profit & Loss'!J4>0,'Balance Sheet'!J17/('Profit & Loss'!J4/365),0)","v":55.967097943067571},{"$f":"IF('Profit & Loss'!K4>0,'Balance Sheet'!K17/('Profit & Loss'!K4/365),0)","v":55.537477226497856}]
["Creditor Days"]
["Cash Conversion Cycle"]
[]
["Return on Equity",{"$f":"IF(SUM('Balance Sheet'!B4:B5)>0,'Profit & Loss'!B12/SUM('Balance Sheet'!B4:B5),\"\")","v":8.8475148071581675E-2},{"$f":"IF(SUM('Balance Sheet'!C4:C5)>0,'Profit & Loss'!C12/SUM('Balance Sheet'!C4:C5),\"\")","v":0.16050213277604419},{"$f":"IF(SUM('Balance Sheet'!D4:D5)>0,'Profit & Loss'!D12/SUM('Balance Sheet'!D4:D5),\"\")","v":0.14265848873879469},{"$f":"IF(SUM('Balance Sheet'!E4:E5)>0,'Profit & Loss'!E12/SUM('Balance Sheet'!E4:E5),\"\")","v":0.23428208532994629},{"$f":"IF(SUM('Balance Sheet'!F4:F5)>0,'Profit & Loss'!F12/SUM('Balance Sheet'!F4:F5),\"\")","v":0.20771392591682536},{"$f":"IF(SUM('Balance Sheet'!G4:G5)>0,'Profit & Loss'!G12/SUM('Balance Sheet'!G4:G5),\"\")","v":0.17105839604164519},{"$f":"IF(SUM('Balance Sheet'!H4:H5)>0,'Profit & Loss'!H12/SUM('Balance Sheet'!H4:H5),\"\")","v":0.20791907396443665},{"$f":"IF(SUM('Balance Sheet'!I4:I5)>0,'Profit & Loss'!I12/SUM('Balance Sheet'!I4:I5),\"\")","v":0.16464227042829238},{"$f":"IF(SUM('Balance Sheet'!J4:J5)>0,'Profit & Loss'!J12/SUM('Balance Sheet'!J4:J5),\"\")","v":0.16530479662179234},{"$f":"IF(SUM('Balance Sheet'!K4:K5)>0,'Profit & Loss'!K12/SUM('Balance Sheet'!K4:K5),\"\")","v":0.21873021678882432}]
["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.18433663924553434},{"$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.1371393629440214},{"$f":"IF(('Balance Sheet'!D10+'Balance Sheet'!D16)>0,('Profit & Loss'!D6-'Profit & Loss'!D8-'Profit & Loss'!D11)/('Balance Sheet'!D10+'Balance Sheet'!D16),\"\")","v":0.10416314780680176},{"$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.14609531620193178},{"$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.13938633568821907},{"$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.12776139974731029},{"$f":"IF(('Balance Sheet'!H10+'Balance Sheet'!H16)>0,('Profit & Loss'!H6-'Profit & Loss'!H8-'Profit & Loss'!H11)/('Balance Sheet'!H10+'Balance Sheet'!H16),\"\")","v":0.13988735317561785},{"$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.11922350204805254},{"$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.14789569580931325},{"$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.14784368469660925}]
[]
[]
[]
["Common Size Balance Sheet",{"$f":"B3","v":"2015-03-31"},{"$f":"C3","v":"2016-03-31"},"2017-03-31","2018-03-31","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31","2024-03-31","Check back how Assets are being put to use"]
["Net Block/Total Assets",{"$f":"B10/B$8","v":0.11678969999751447},{"$f":"C10/C$8","v":0.37156656359222812},0.54787506857135215,0.51432526323054617,0.48387356818831395,0.36388703351658702,0.19365239395285463,0.16885090686920934,0.20508704494001626,0.13893679819566179]
["Working Capital/Total Assets",{"$f":"B16/B$8","v":7.7185395073695678E-2},{"$f":"C16/C$8","v":8.1415376557448044E-2},5.9437425017505201E-2,0.15893143352326317,0.25212710603651073,0.30710407782287763,0.47006623111514834,0.53108059647118877,0.56596138654678352,0.67074446180857672]
["Debtors/Total Assets",{"$f":"B17/B$8","v":5.4746103944523145E-2},{"$f":"C17/C$8","v":6.7787391343761647E-2},8.1032383517899903E-2,0.10319864416138159,3.5470088601936199E-2,4.9852426541528938E-2,8.3068392235936497E-2,0.11354317471581475,0.14345890497718797,0.11612756491878583]
["Inventory/Total Assets",{"$f":"B18/B$8","v":2.7703626376357714E-2},{"$f":"C18/C$8","v":3.1138888609099427E-2},3.5920238695204242E-2,2.8777061173782006E-2,3.7078701091218219E-2,3.5155023491867755E-2,3.6931208480777009E-2,4.3149100720448245E-2,5.3945062309851882E-2,3.8056166746212393E-2]
[]
["Borrowings/Total Assets",{"$f":"B6/B$8","v":0.36469564785126635},{"$f":"C6/C$8","v":0.37036794552834884},0.32162305603004204,0.29540103835152109,0.27782826321150872,0.24963035274909084,0.19075010356410244,0.27769418613255714,0.15017468868104861,0.21751820792964599]

{"sheet":"Cash Flow","index":3,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[{"$f":"'Balance Sheet'!A1","v":"KNR CONSTRUCTIONS LTD"},null,null,null,{"$f":"UPDATE","v":""},null,null,null,null,"SCREENER.IN"]
[]
["Narration",{"$f":"'Data Sheet'!B81","v":"2015-03-31"},{"$f":"'Data Sheet'!C81","v":"2016-03-31"},{"$f":"'Data Sheet'!D81","v":"2017-03-31"},{"$f":"'Data Sheet'!E81","v":"2018-03-31"},{"$f":"'Data Sheet'!F81","v":"2019-03-31"},{"$f":"'Data Sheet'!G81","v":"2020-03-31"},{"$f":"'Data Sheet'!H81","v":"2021-03-31"},{"$f":"'Data Sheet'!I81","v":"2022-03-31"},{"$f":"'Data Sheet'!J81","v":"2023-03-31"},{"$f":"'Data Sheet'!K81","v":"2024-03-31"}]
["Cash from Operating Activity",{"$f":"'Data Sheet'!B82","v":78.400000000000006},{"$f":"'Data Sheet'!C82","v":245.85},{"$f":"'Data Sheet'!D82","v":365.67},{"$f":"'Data Sheet'!E82","v":220.57},{"$f":"'Data Sheet'!F82","v":255.91},{"$f":"'Data Sheet'!G82","v":230.62},{"$f":"'Data Sheet'!H82","v":-75.59},{"$f":"'Data Sheet'!I82","v":-336.44},{"$f":"'Data Sheet'!J82","v":1194.1300000000001},{"$f":"'Data Sheet'!K82","v":-315.64}]
["Cash from Investing Activity",{"$f":"'Data Sheet'!B83","v":-548.95000000000005},{"$f":"'Data Sheet'!C83","v":-243.99},{"$f":"'Data Sheet'!D83","v":-249.63},{"$f":"'Data Sheet'!E83","v":-163.28},{"$f":"'Data Sheet'!F83","v":-183.5},{"$f":"'Data Sheet'!G83","v":-202.09},{"$f":"'Data Sheet'!H83","v":260.19},{"$f":"'Data Sheet'!I83","v":-408.48},{"$f":"'Data Sheet'!J83","v":66.81},{"$f":"'Data Sheet'!K83","v":-15.08}]
["Cash from Financing Activity",{"$f":"'Data Sheet'!B84","v":449.83},{"$f":"'Data Sheet'!C84","v":1.47},{"$f":"'Data Sheet'!D84","v":-123.61},{"$f":"'Data Sheet'!E84","v":-37.53},{"$f":"'Data Sheet'!F84","v":-107.5},{"$f":"'Data Sheet'!G84","v":2.2200000000000002},{"$f":"'Data Sheet'!H84","v":-97.83},{"$f":"'Data Sheet'!I84","v":764.87},{"$f":"'Data Sheet'!J84","v":-1217.3499999999999},{"$f":"'Data Sheet'!K84","v":496.13}]
["Net Cash Flow",{"$f":"'Data Sheet'!B85","v":-20.72},{"$f":"'Data Sheet'!C85","v":3.33},{"$f":"'Data Sheet'!D85","v":-7.57},{"$f":"'Data Sheet'!E85","v":19.760000000000002},{"$f":"'Data Sheet'!F85","v":-35.090000000000003},{"$f":"'Data Sheet'!G85","v":30.75},{"$f":"'Data Sheet'!H85","v":86.77},{"$f":"'Data Sheet'!I85","v":19.940000000000001},{"$f":"'Data Sheet'!J85","v":43.6},{"$f":"'Data Sheet'!K85","v":165.4}]

{"sheet":"Customization","index":4,"n_rows":65,"n_cols":14,"rows_kept":65,"cut":false,"hidden":true,"merged":[[50,0,50,10],[3,5,3,10],[3,12,3,13],[9,0,9,9],[33,0,33,10],[42,0,42,10]]}
[{"$f":"'Data Sheet'!B1","v":"KNR CONSTRUCTIONS LTD"}]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"DELTA NETWORTH","DELTA MKTCAP","IMPACT*",null,"HISTORICAL VALUATIONS",null,null,null,null,null,null,"PRE-TAX BOND"]
["10 YR",{"$f":"KeyMetrics!K12-KeyMetrics!B12","v":2765.6800000000003},{"$f":"KeyMetrics!K27-KeyMetrics!B27","v":5732.268},{"$f":"C5/B5","v":2.0726432559081309},null,null,"P/E","P/B","EV/EBITDA","P/SALES","YIELD",null,"LongTerm Bond",0.09]
["7 YR",{"$f":"KeyMetrics!K12-KeyMetrics!E12","v":2514.8900000000003},{"$f":"KeyMetrics!K27-KeyMetrics!E27","v":2932.9160000000002},{"$f":"C6/B6","v":1.1662203913491245},null,"MIN",{"$f":"MIN(KeyMetrics!B34:K34)","v":8.9091278621044516},{"$f":"MIN(KeyMetrics!B35:K35)","v":1.5139295090491709},{"$f":"MIN(KeyMetrics!B38:K38)","v":5.1560242536772174},{"$f":"MIN(KeyMetrics!B37:K37)","v":1.1268966586177642},{"$f":"MAX(KeyMetrics!B39:K39)","v":3.9261876717707105E-3},null,"LTB Quote",{"$f":"('Profit & Loss'!$L$10/'Data Sheet'!$B$61)/N5","v":5.4994103789868465}]
["5 YR",{"$f":"KeyMetrics!K12-KeyMetrics!G12","v":2001.9900000000002},{"$f":"KeyMetrics!K27-KeyMetrics!G27","v":4163.1660000000002},{"$f":"C7/B7","v":2.0795138836857325},null,"MAX",{"$f":"MAX(KeyMetrics!B34:K34)","v":23.587516100957352},{"$f":"MAX(KeyMetrics!B35:K35)","v":3.8421954082712699},{"$f":"MAX(KeyMetrics!B38:K38)","v":13.413400740529765},{"$f":"MAX(KeyMetrics!B37:K37)","v":2.2159447781641899},{"$f":"MIN(KeyMetrics!B39:K39)","v":8.7981699806440267E-4},null,"Equity Quoting @",{"$f":"('Profit & Loss'!$L$6/'Data Sheet'!$B$6)/'Data Sheet'!$B$8","v":0.11567331677316209}]
["3 YR",{"$f":"KeyMetrics!K12-KeyMetrics!I12","v":1234.94},{"$f":"KeyMetrics!K27-KeyMetrics!I27","v":-1064.3419999999996},{"$f":"C8/B8","v":-0.86185725622297404},null,"TRAILING",{"$f":"'Data Sheet'!B8/'Profit & Loss'!L13","v":11.811667302274659},{"$f":"KeyMetrics!L27/KeyMetrics!K12","v":2.7014476035057609},{"$f":"KeyMetrics!K38","v":6.5223373922377643},{"$f":"KeyMetrics!L27/'Data Sheet'!K17","v":2.1675971725864605},{"$f":"'Data Sheet'!K31/KeyMetrics!L27","v":7.3218870263035932E-4}]
["1 YR",{"$f":"KeyMetrics!K12-KeyMetrics!J12","v":783.45000000000027},{"$f":"KeyMetrics!K27-KeyMetrics!J27","v":-208.08799999999974},{"$f":"C9/B9","v":-0.26560469717276108},null,null,null,null,null,null,null,null," "]
["* IMPACT – Every Rupee retained added xx.yy in incremental market value"]
[]
[{"$f":"A1","v":"KNR CONSTRUCTIONS 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.19306995212280076},{"$f":"POWER(KeyMetrics!$K4/KeyMetrics!$B4, 1/9)-1","v":0.19078785184657132},{"$f":"POWER(KeyMetrics!$K6/KeyMetrics!$B6, 1/9)-1","v":0.31974153732388522},{"$f":"POWER(KeyMetrics!$K9/KeyMetrics!$B9, 1/9)-1","v":0.30718652613521402},{"$f":"POWER(KeyMetrics!$K10/KeyMetrics!$B10, 1/9)-1","v":0.10726070938441823},{"$f":"POWER(KeyMetrics!$K25/KeyMetrics!$B25, 1/9)-1","v":-2.1160006852966626},{"$f":"POWER(KeyMetrics!$K27/KeyMetrics!$B27, 1/9)-1","v":0.21574701278160946},{"$f":"POWER(KeyMetrics!$K18/KeyMetrics!$B18, 1/9)-1","v":-2.1673697663150842},{"$f":"POWER(KeyMetrics!$K20/KeyMetrics!$C20, 1/8)-1","v":{"$error":"#NUM!"}},{"$f":"POWER(KeyMetrics!$K12/KeyMetrics!$B12, 1/9)-1","v":0.18211893937262902},{"$f":"POWER(KeyMetrics!$K28/KeyMetrics!$B28, 1/9)-1","v":0.2155664506138375}]
["5 YR CAGR",{"$f":"POWER('Data Sheet'!$K17/'Data Sheet'!$G17, 1/4)-1","v":0.15937113991775886},{"$f":"POWER(KeyMetrics!$K4/KeyMetrics!$G4, 1/4)-1","v":0.1255869125446043},{"$f":"POWER(KeyMetrics!$K6/KeyMetrics!$G6, 1/4)-1","v":0.24197931819421226},{"$f":"POWER(KeyMetrics!$K9/KeyMetrics!$G9, 1/4)-1","v":0.30809990281269473},{"$f":"POWER(KeyMetrics!$K10/KeyMetrics!$G10, 1/4)-1","v":0},{"$f":"POWER(KeyMetrics!$K25/KeyMetrics!$G25, 1/4)-1","v":0.43284450462243895},{"$f":"POWER(KeyMetrics!$K27/KeyMetrics!$G27, 1/4)-1","v":0.25829642640601502},{"$f":"POWER(KeyMetrics!$K18/KeyMetrics!$G18, 1/4)-1","v":{"$error":"#NUM!"}},{"$f":"POWER(KeyMetrics!$K20/KeyMetrics!$G20, 1/4)-1","v":{"$error":"#NUM!"}},{"$f":"POWER(KeyMetrics!$K12/KeyMetrics!$G12, 1/4)-1","v":0.23012661903870635},{"$f":"POWER(KeyMetrics!$K28/KeyMetrics!$G28, 1/4)-1","v":0.2578162294927675}]
["3 YR CAGR",{"$f":"POWER('Data Sheet'!$K17/'Data Sheet'!$I17, 1/2)-1","v":0.1083446803235022},{"$f":"POWER(KeyMetrics!$K4/KeyMetrics!$I4, 1/2)-1","v":6.0262092559846492E-2},{"$f":"POWER(KeyMetrics!$K6/KeyMetrics!$I6, 1/2)-1","v":0.20390140950907942},{"$f":"POWER(KeyMetrics!$K9/KeyMetrics!$I9, 1/2)-1","v":0.42686063794518025},{"$f":"POWER(KeyMetrics!$K10/KeyMetrics!$I10, 1/2)-1","v":0},{"$f":"POWER(KeyMetrics!$K25/KeyMetrics!$I25, 1/2)-1","v":2.5978039238595114},{"$f":"POWER(KeyMetrics!$K27/KeyMetrics!$I27, 1/2)-1","v":-6.8981360824043714E-2},{"$f":"POWER(KeyMetrics!$K18/KeyMetrics!$I18, 1/2)-1","v":-3.1405039329562179E-2},{"$f":"POWER(KeyMetrics!$K20/KeyMetrics!$I20, 1/2)-1","v":-0.21738503218676952},{"$f":"POWER(KeyMetrics!$K12/KeyMetrics!$I12, 1/2)-1","v":0.2379349917483895},{"$f":"POWER(KeyMetrics!$K28/KeyMetrics!$I28, 1/2)-1","v":-6.8918478931718763E-2}]
["1 YR GROWTH",{"$f":"('Data Sheet'!$K17-'Data Sheet'!$J17)/'Data Sheet'!$J17","v":9.0373575950924989E-2},{"$f":"(KeyMetrics!$K4-KeyMetrics!$J4)/KeyMetrics!$J4","v":6.1757580950452057E-2},{"$f":"(KeyMetrics!$K6-KeyMetrics!$J6)/KeyMetrics!$J6","v":0.24077158090217476},{"$f":"(KeyMetrics!$K9-KeyMetrics!$J9)/KeyMetrics!$J9","v":0.69734285277614028},{"$f":"(KeyMetrics!$K10-KeyMetrics!$J10)/KeyMetrics!$J10","v":0},{"$f":"(KeyMetrics!$K25-KeyMetrics!$J25)/KeyMetrics!$J25","v":0.85599698673298719},{"$f":"(KeyMetrics!$K27-KeyMetrics!$J27)/KeyMetrics!$J27","v":-2.9168309026409107E-2},{"$f":"(KeyMetrics!$K18-KeyMetrics!$J18)/KeyMetrics!$J18","v":-1.2643263296291023},{"$f":"(KeyMetrics!$K20-KeyMetrics!$J20)/KeyMetrics!$J20","v":-1.3763616082254231},{"$f":"(KeyMetrics!$K12-KeyMetrics!$J12)/KeyMetrics!$J12","v":0.28276247879597227},{"$f":"(KeyMetrics!$K28-KeyMetrics!$J28)/KeyMetrics!$J28","v":-2.9139594408348065E-2}]
["**modify (if, then) for negative values"]
[{"$f":"A1","v":"KNR CONSTRUCTIONS LTD"},{"$f":"'Data Sheet'!B16","v":"2015-03-31"},{"$f":"'Data Sheet'!C16","v":"2016-03-31"},{"$f":"'Data Sheet'!D16","v":"2017-03-31"},{"$f":"'Data Sheet'!E16","v":"2018-03-31"},{"$f":"'Data Sheet'!F16","v":"2019-03-31"},{"$f":"'Data Sheet'!G16","v":"2020-03-31"},{"$f":"'Data Sheet'!H16","v":"2021-03-31"},{"$f":"'Data Sheet'!I16","v":"2022-03-31"},{"$f":"'Data Sheet'!J16","v":"2023-03-31"},{"$f":"'Data Sheet'!K16","v":"2024-03-31"},null,"    "]
["Total Assets/Networth= Financial Leverage",{"$f":"KeyMetrics!B16/KeyMetrics!B12","v":2.5513335954443415},{"$f":"KeyMetrics!C16/KeyMetrics!C12","v":2.8422032005954594},{"$f":"KeyMetrics!D16/KeyMetrics!D12","v":2.783876735119565},{"$f":"KeyMetrics!E16/KeyMetrics!E12","v":2.5094586532725209},{"$f":"KeyMetrics!F16/KeyMetrics!F12","v":2.095537195159408},{"$f":"KeyMetrics!G16/KeyMetrics!G12","v":2.257074012988352},{"$f":"KeyMetrics!H16/KeyMetrics!H12","v":2.04518914725517},{"$f":"KeyMetrics!I16/KeyMetrics!I12","v":2.2724677799768025},{"$f":"KeyMetrics!J16/KeyMetrics!J12","v":1.5671166131302561},{"$f":"KeyMetrics!K16/KeyMetrics!K12","v":1.6329614675801527}," "]
["Long term debt/Earning",{"$f":"'Data Sheet'!B59/'Data Sheet'!B30","v":10.516628440366972},{"$f":"'Data Sheet'!C59/'Data Sheet'!C30","v":6.5585481137964861},{"$f":"'Data Sheet'!D59/'Data Sheet'!D30","v":6.276240208877284},{"$f":"'Data Sheet'!E59/'Data Sheet'!E30","v":3.1641202562838839},{"$f":"'Data Sheet'!F59/'Data Sheet'!F30","v":2.8028908358286202},{"$f":"'Data Sheet'!G59/'Data Sheet'!G30","v":3.2938119091559641},{"$f":"'Data Sheet'!H59/'Data Sheet'!H30","v":1.8763071333889734},{"$f":"'Data Sheet'!I59/'Data Sheet'!I30","v":3.8328619316991412},{"$f":"'Data Sheet'!J59/'Data Sheet'!J30","v":1.4236807056614484},{"$f":"'Data Sheet'!K59/'Data Sheet'!K30","v":1.6239130434782609}]
["Current liablility/Earning",{"$f":"'Data Sheet'!B60/'Data Sheet'!B30","v":7.0174885321100913},{"$f":"'Data Sheet'!C60/'Data Sheet'!C30","v":4.9192009274948729},{"$f":"'Data Sheet'!D60/'Data Sheet'!D30","v":6.2282854656222799},{"$f":"'Data Sheet'!E60/'Data Sheet'!E30","v":3.2787908657795306},{"$f":"'Data Sheet'!F60/'Data Sheet'!F30","v":2.4713688957894346},{"$f":"'Data Sheet'!G60/'Data Sheet'!G30","v":4.0549885126737228},{"$f":"'Data Sheet'!H60/'Data Sheet'!H30","v":3.1505964946732781},{"$f":"'Data Sheet'!I60/'Data Sheet'!I30","v":3.8958202388434948},{"$f":"'Data Sheet'!J60/'Data Sheet'!J30","v":2.0070522477675161},{"$f":"'Data Sheet'!K60/'Data Sheet'!K30","v":1.2698868021610497}]
["Total liability/Earning",{"$f":"('Data Sheet'!B59+'Data Sheet'!B60)/'Data Sheet'!B30","v":17.534116972477065},{"$f":"('Data Sheet'!C59+'Data Sheet'!C60)/'Data Sheet'!C30","v":11.477749041291359},{"$f":"('Data Sheet'!D59+'Data Sheet'!D60)/'Data Sheet'!D30","v":12.504525674499565},{"$f":"('Data Sheet'!E59+'Data Sheet'!E60)/'Data Sheet'!E30","v":6.4429111220634141},{"$f":"('Data Sheet'!F59+'Data Sheet'!F60)/'Data Sheet'!F30","v":5.2742597316180548},{"$f":"('Data Sheet'!G59+'Data Sheet'!G60)/'Data Sheet'!G30","v":7.3488004218296865},{"$f":"('Data Sheet'!H59+'Data Sheet'!H60)/'Data Sheet'!H30","v":5.0269036280622519},{"$f":"('Data Sheet'!I59+'Data Sheet'!I60)/'Data Sheet'!I30","v":7.7286821705426361},{"$f":"('Data Sheet'!J59+'Data Sheet'!J60)/'Data Sheet'!J30","v":3.4307329534289646},{"$f":"('Data Sheet'!K59+'Data Sheet'!K60)/'Data Sheet'!K30","v":2.893799845639311}]
["Debt/Equity",{"$f":"'Data Sheet'!B59/KeyMetrics!B12","v":0.9304602584752748},{"$f":"'Data Sheet'!C59/KeyMetrics!C12","v":1.0526609601786379},{"$f":"'Data Sheet'!D59/KeyMetrics!D12","v":0.89535894316009046},{"$f":"'Data Sheet'!E59/KeyMetrics!E12","v":0.74129669187691238},{"$f":"'Data Sheet'!F59/KeyMetrics!F12","v":0.58219945942625473},{"$f":"'Data Sheet'!G59/KeyMetrics!G12","v":0.56343418204308837},{"$f":"'Data Sheet'!H59/KeyMetrics!H12","v":0.39012004164710207},{"$f":"'Data Sheet'!I59/KeyMetrics!I12","v":0.63105109067311715},{"$f":"'Data Sheet'!J59/KeyMetrics!J12","v":0.2353412495037355},{"$f":"'Data Sheet'!K59/KeyMetrics!K12","v":0.3551988520461995}]
["Interest Coverage",{"$f":"KeyMetrics!B6/'Data Sheet'!B27","v":6.1789855072463764},{"$f":"KeyMetrics!C6/'Data Sheet'!C27","v":2.5826315789473679},{"$f":"KeyMetrics!D6/'Data Sheet'!D27","v":2.4549332599422047},{"$f":"KeyMetrics!E6/'Data Sheet'!E27","v":3.7664242424242427},{"$f":"KeyMetrics!F6/'Data Sheet'!F27","v":4.254229741763135},{"$f":"KeyMetrics!G6/'Data Sheet'!G27","v":3.9289582957212494},{"$f":"KeyMetrics!H6/'Data Sheet'!H27","v":4.9020343818031673},{"$f":"KeyMetrics!I6/'Data Sheet'!I27","v":4.7275373825592171},{"$f":"KeyMetrics!J6/'Data Sheet'!J27","v":5.4410039113428939},{"$f":"KeyMetrics!K6/'Data Sheet'!K27","v":9.8004163906501383}]
["Working Capital/Sales",{"$f":"KeyMetrics!B13/'Data Sheet'!B17","v":0.17168288367978762},{"$f":"KeyMetrics!C13/'Data Sheet'!C17","v":0.13565722341568204},{"$f":"KeyMetrics!D13/'Data Sheet'!D17","v":8.115679026630046E-2},{"$f":"KeyMetrics!E13/'Data Sheet'!E17","v":0.20027541553923459},{"$f":"KeyMetrics!F13/'Data Sheet'!F17","v":0.30027056513200956},{"$f":"KeyMetrics!G13/'Data Sheet'!G17","v":0.43883785812177778},{"$f":"KeyMetrics!H13/'Data Sheet'!H17","v":0.64871901723015679},{"$f":"KeyMetrics!I13/'Data Sheet'!I17","v":0.77623675058655173},{"$f":"KeyMetrics!J13/'Data Sheet'!J17","v":0.6049217696117527},{"$f":"KeyMetrics!K13/'Data Sheet'!K17","v":0.87885061259874153},"Check for improving or deteriorating picture"]
["Inventory Turns",{"$f":"365/B27","v":16.228243315987797},19.273491832443796,20.388999255028558,27.576282478347768,22.645518331850976,19.906463137382264,19.620447327522129,15.85603095730179,17.343465824189902,20.054738081224247]
["Inventory Days",{"$f":"'Balance Sheet'!B21","v":22.491651923927467},{"$f":"'Balance Sheet'!C21","v":18.937927967239528},{"$f":"'Balance Sheet'!D21","v":17.901810453496374},{"$f":"'Balance Sheet'!E21","v":13.23601178971782},{"$f":"'Balance Sheet'!F21","v":16.117979489417412},{"$f":"'Balance Sheet'!G21","v":18.335753442537364},{"$f":"'Balance Sheet'!H21","v":18.603041709859728},{"$f":"'Balance Sheet'!I21","v":23.01963215024599},{"$f":"'Balance Sheet'!J21","v":21.045389871897122},{"$f":"'Balance Sheet'!K21","v":18.200187832007749}]
["Debtor Days",{"$f":"'Balance Sheet'!B22","v":44.446539141972579},{"$f":"'Balance Sheet'!C22","v":41.226671589688507},{"$f":"'Balance Sheet'!D22","v":40.38465285939602},{"$f":"'Balance Sheet'!E22","v":47.466225357557015},{"$f":"'Balance Sheet'!F22","v":15.418721361553567},{"$f":"'Balance Sheet'!G22","v":26.001456144358158},{"$f":"'Balance Sheet'!H22","v":41.843330589641241},{"$f":"'Balance Sheet'!I22","v":60.574196715310244},{"$f":"'Balance Sheet'!J22","v":55.967097943067571},{"$f":"'Balance Sheet'!K22","v":55.537477226497856}]
["Creditor Days",null,null,null,null,null,null,null,null,null,null,"Check back to see if Creditor policy change is impacting Working Cap cycle"]
["Cash Conversion Cycle"]
["Cash In/Cash Out Ratio",{"$f":"('Data Sheet'!B67+'Data Sheet'!B69)/'Data Sheet'!B60","v":0.31392736037913144},{"$f":"('Data Sheet'!C67+'Data Sheet'!C69)/'Data Sheet'!C60","v":0.32598488007396798},{"$f":"('Data Sheet'!D67+'Data Sheet'!D69)/'Data Sheet'!D60","v":0.30113326719114625},{"$f":"('Data Sheet'!E67+'Data Sheet'!E69)/'Data Sheet'!E60","v":0.40224471389918826},{"$f":"('Data Sheet'!F67+'Data Sheet'!F69)/'Data Sheet'!F60","v":0.18588545016678384},{"$f":"('Data Sheet'!G67+'Data Sheet'!G69)/'Data Sheet'!G60","v":0.239188586714222},{"$f":"('Data Sheet'!H67+'Data Sheet'!H69)/'Data Sheet'!H60","v":0.37453349850797435},{"$f":"('Data Sheet'!I67+'Data Sheet'!I69)/'Data Sheet'!I60","v":0.57651353204533529},{"$f":"('Data Sheet'!J67+'Data Sheet'!J69)/'Data Sheet'!J60","v":0.91716072885504474},{"$f":"('Data Sheet'!K67+'Data Sheet'!K69)/'Data Sheet'!K60","v":1.0989252539986425},null,"  "]
["Current Ratio",{"$f":"'Data Sheet'!B65/'Data Sheet'!B60","v":1.317175307431466},{"$f":"'Data Sheet'!C65/'Data Sheet'!C60","v":1.2930800050762341},{"$f":"'Data Sheet'!D65/'Data Sheet'!D60","v":1.1862275198077219},{"$f":"'Data Sheet'!E65/'Data Sheet'!E60","v":1.5192028259344621},{"$f":"'Data Sheet'!F65/'Data Sheet'!F60","v":2.0292283068822639},{"$f":"'Data Sheet'!G65/'Data Sheet'!G60","v":1.9993033883192153},{"$f":"'Data Sheet'!H65/'Data Sheet'!H60","v":2.4675922679568987},{"$f":"'Data Sheet'!I65/'Data Sheet'!I60","v":2.8815593110958742},{"$f":"'Data Sheet'!J65/'Data Sheet'!J60","v":3.6732771280935546},{"$f":"'Data Sheet'!K65/'Data Sheet'!K60","v":4.9432947397210318}," "]
["CFO/PAT",{"$f":"KeyMetrics!B18/KeyMetrics!B9","v":1.1238532110091743},{"$f":"KeyMetrics!C18/KeyMetrics!C9","v":2.1925443681441186},{"$f":"KeyMetrics!D18/KeyMetrics!D9","v":3.1825065274151436},{"$f":"KeyMetrics!E18/KeyMetrics!E9","v":0.90590602924264829},{"$f":"KeyMetrics!F18/KeyMetrics!F9","v":0.94602787327640381},{"$f":"KeyMetrics!G18/KeyMetrics!G9","v":0.86859252005574183},{"$f":"KeyMetrics!H18/KeyMetrics!H9","v":-0.18555157346948795},{"$f":"KeyMetrics!I18/KeyMetrics!I9","v":-0.88110203226482298},{"$f":"KeyMetrics!J18/KeyMetrics!J9","v":2.6072138162922212},{"$f":"KeyMetrics!K18/KeyMetrics!K9","v":-0.4060200668896321}]
[null,null,null,null,null,null,null,null,null,null,null," "]
["Gross Margin =Gross Profit/Sales",{"$f":"KeyMetrics!B4/'Data Sheet'!B17","v":0.62616099071207432},{"$f":"KeyMetrics!C4/'Data Sheet'!C17","v":0.7332673200859291},{"$f":"KeyMetrics!D4/'Data Sheet'!D17","v":0.77964594764117345},{"$f":"KeyMetrics!E4/'Data Sheet'!E17","v":0.75509277155005794},{"$f":"KeyMetrics!F4/'Data Sheet'!F17","v":0.71905738599170854},{"$f":"KeyMetrics!G4/'Data Sheet'!G17","v":0.69274946159368267},{"$f":"KeyMetrics!H4/'Data Sheet'!H17","v":0.68093386554071966},{"$f":"KeyMetrics!I4/'Data Sheet'!I17","v":0.67255159714017898},{"$f":"KeyMetrics!J4/'Data Sheet'!J17","v":0.63205131992240959},{"$f":"KeyMetrics!K4/'Data Sheet'!K17","v":0.61546363125325931}]
["EBIT/Sales",{"$f":"KeyMetrics!B6/'Data Sheet'!B17","v":9.4283502874834141E-2},{"$f":"KeyMetrics!C6/'Data Sheet'!C17","v":0.12353148496240599},{"$f":"KeyMetrics!D6/'Data Sheet'!D17","v":0.10863938908612594},{"$f":"KeyMetrics!E6/'Data Sheet'!E17","v":0.15014012369540009},{"$f":"KeyMetrics!F6/'Data Sheet'!F17","v":0.16679031202269257},{"$f":"KeyMetrics!G6/'Data Sheet'!G17","v":0.17753132545846115},{"$f":"KeyMetrics!H6/'Data Sheet'!H17","v":0.22489091240963896},{"$f":"KeyMetrics!I6/'Data Sheet'!I17","v":0.19815742327681357},{"$f":"KeyMetrics!J6/'Data Sheet'!J17","v":0.20545938813891432},{"$f":"KeyMetrics!K6/'Data Sheet'!K17","v":0.23379892493266724}]
["EBITDA/Sales",{"$f":"KeyMetrics!B7/'Data Sheet'!B17","v":0.15528527200353825},{"$f":"KeyMetrics!C7/'Data Sheet'!C17","v":0.18299375671321158},{"$f":"KeyMetrics!D7/'Data Sheet'!D17","v":0.17905403348090587},{"$f":"KeyMetrics!E7/'Data Sheet'!E17","v":0.24368477000386551},{"$f":"KeyMetrics!F7/'Data Sheet'!F17","v":0.26721797948941745},{"$f":"KeyMetrics!G7/'Data Sheet'!G17","v":0.28118677804607456},{"$f":"KeyMetrics!H7/'Data Sheet'!H17","v":0.29029180715173764},{"$f":"KeyMetrics!I7/'Data Sheet'!I17","v":0.2438945926308024},{"$f":"KeyMetrics!J7/'Data Sheet'!J17","v":0.24994092104097124},{"$f":"KeyMetrics!K7/'Data Sheet'!K17","v":0.26920480687392906}]
["Op Profit (Ex Other Income)/Sales",{"$f":"KeyMetrics!B8/'Data Sheet'!B17","v":0.14022556390977442},{"$f":"KeyMetrics!C8/'Data Sheet'!C17","v":0.14460257787325456},{"$f":"KeyMetrics!D8/'Data Sheet'!D17","v":0.16104693294684341},{"$f":"KeyMetrics!E8/'Data Sheet'!E17","v":0.21713857750289914},{"$f":"KeyMetrics!F8/'Data Sheet'!F17","v":0.23459306131355009},{"$f":"KeyMetrics!G8/'Data Sheet'!G17","v":0.25410738758728713},{"$f":"KeyMetrics!H8/'Data Sheet'!H17","v":0.24070215557767344},{"$f":"KeyMetrics!I8/'Data Sheet'!I17","v":0.22233777615077843},{"$f":"KeyMetrics!J8/'Data Sheet'!J17","v":0.22589824633956615},{"$f":"KeyMetrics!K8/'Data Sheet'!K17","v":0.2365396467764912}]
["Net Margin =PAT/Sales",{"$f":"KeyMetrics!B9/'Data Sheet'!B17","v":7.7134011499336588E-2},{"$f":"KeyMetrics!C9/'Data Sheet'!C17","v":9.4094052094522013E-2},{"$f":"KeyMetrics!D9/'Data Sheet'!D17","v":6.9970099809393893E-2},{"$f":"KeyMetrics!E9/'Data Sheet'!E17","v":0.1176459219172787},{"$f":"KeyMetrics!F9/'Data Sheet'!F17","v":0.11804931267728562},{"$f":"KeyMetrics!G9/'Data Sheet'!G17","v":0.10829716765646415},{"$f":"KeyMetrics!H9/'Data Sheet'!H17","v":0.14030024486590922},{"$f":"KeyMetrics!I9/'Data Sheet'!I17","v":0.10589546899179658},{"$f":"KeyMetrics!J9/'Data Sheet'!J17","v":0.11274480843647534},{"$f":"KeyMetrics!K9/'Data Sheet'!K17","v":0.17550553223960322}]
["Op Cash Flow/Sales",{"$f":"KeyMetrics!B18/'Data Sheet'!B17","v":8.6687306501547989E-2},{"$f":"KeyMetrics!C18/'Data Sheet'!C17","v":0.20630538399570353},{"$f":"KeyMetrics!D18/'Data Sheet'!D17","v":0.22268029936728517},{"$f":"KeyMetrics!E18/'Data Sheet'!E17","v":0.10657614998067259},{"$f":"KeyMetrics!F18/'Data Sheet'!F17","v":0.11167794021383373},{"$f":"KeyMetrics!G18/'Data Sheet'!G17","v":9.4066109769627371E-2},{"$f":"KeyMetrics!H18/'Data Sheet'!H17","v":-2.6032931193023905E-2},{"$f":"KeyMetrics!I18/'Data Sheet'!I17","v":-9.3304712936308515E-2},{"$f":"KeyMetrics!J18/'Data Sheet'!J17","v":0.2939498222707983},{"$f":"KeyMetrics!K18/'Data Sheet'!K17","v":-7.1258767939424178E-2}]
["Free Cash Flow/Sales",{"$f":"KeyMetrics!B20/'Data Sheet'!B17","v":0},{"$f":"KeyMetrics!C20/'Data Sheet'!C17","v":0.29512117346938771},{"$f":"KeyMetrics!D20/'Data Sheet'!D17","v":5.8972188559979974E-2},{"$f":"KeyMetrics!E20/'Data Sheet'!E17","v":2.0148821028218638E-3},{"$f":"KeyMetrics!F20/'Data Sheet'!F17","v":2.0837879118481308E-2},{"$f":"KeyMetrics!G20/'Data Sheet'!G17","v":4.9149970632382974E-3},{"$f":"KeyMetrics!H20/'Data Sheet'!H17","v":8.3033995378198985E-2},{"$f":"KeyMetrics!I20/'Data Sheet'!I17","v":-0.17568819297690955},{"$f":"KeyMetrics!J20/'Data Sheet'!J17","v":0.25378105337783946},{"$f":"KeyMetrics!K20/'Data Sheet'!K17","v":-8.759699197876053E-2}]
["EPA/Sales",{"$f":"KeyMetrics!B25/'Data Sheet'!B17","v":-0.10417109172655094},{"$f":"KeyMetrics!C25/'Data Sheet'!C17","v":1.9763857256448164E-2},{"$f":"KeyMetrics!D25/'Data Sheet'!D17","v":-4.7199333085611427E-3},{"$f":"KeyMetrics!E25/'Data Sheet'!E17","v":4.8746172469836951E-2},{"$f":"KeyMetrics!F25/'Data Sheet'!F17","v":4.5933527532956778E-2},{"$f":"KeyMetrics!G25/'Data Sheet'!G17","v":2.4480928593513911E-2},{"$f":"KeyMetrics!H25/'Data Sheet'!H17","v":5.5619331846762189E-2},{"$f":"KeyMetrics!I25/'Data Sheet'!I17","v":5.4201199204032312E-3},{"$f":"KeyMetrics!J25/'Data Sheet'!J17","v":3.3553068758965153E-2},{"$f":"KeyMetrics!K25/'Data Sheet'!K17","v":5.7112897713037444E-2}]
[]
["Sales/Invested Capital =Capital Turns",{"$f":"'Data Sheet'!B17/KeyMetrics!B14","v":0.60354895326566427},{"$f":"'Data Sheet'!C17/KeyMetrics!C14","v":0.8972412962293701},{"$f":"'Data Sheet'!D17/KeyMetrics!D14","v":1.1301885104303599},{"$f":"'Data Sheet'!E17/KeyMetrics!E14","v":1.1779236079886626},{"$f":"'Data Sheet'!F17/KeyMetrics!F14","v":1.1408443692123869},{"$f":"'Data Sheet'!G17/KeyMetrics!G14","v":1.038469032471218},{"$f":"'Data Sheet'!H17/KeyMetrics!H14","v":1.0907619026153073},{"$f":"'Data Sheet'!I17/KeyMetrics!I14","v":0.97205276196997425},{"$f":"'Data Sheet'!J17/KeyMetrics!J14","v":1.2124963810399325},{"$f":"'Data Sheet'!K17/KeyMetrics!K14","v":0.94216403624452294}]
["Sales/Fixed Assets= Fixed Asset Turns",{"$f":"'Data Sheet'!B17/'Data Sheet'!B62","v":3.8494934876989868},{"$f":"'Data Sheet'!C17/'Data Sheet'!C62","v":1.6152021577955789},{"$f":"'Data Sheet'!D17/'Data Sheet'!D62","v":1.3367604441405361},{"$f":"'Data Sheet'!E17/'Data Sheet'!E62","v":1.5429231744138368},{"$f":"'Data Sheet'!F17/'Data Sheet'!F62","v":1.735301244964105},{"$f":"'Data Sheet'!G17/'Data Sheet'!G62","v":1.9231577791374468},{"$f":"'Data Sheet'!H17/'Data Sheet'!H62","v":3.7417912371134023},{"$f":"'Data Sheet'!I17/'Data Sheet'!I62","v":4.0519384200471968},{"$f":"'Data Sheet'!J17/'Data Sheet'!J62","v":4.5619378095206011},{"$f":"'Data Sheet'!K17/'Data Sheet'!K62","v":5.4931916265687777}]
["Sales/Total Assets= Asset Turns",{"$f":"'Data Sheet'!B17/KeyMetrics!B16","v":0.44958118957075033},{"$f":"'Data Sheet'!C17/KeyMetrics!C16","v":0.60015511527885501},{"$f":"'Data Sheet'!D17/KeyMetrics!D16","v":0.73237771999696732},{"$f":"'Data Sheet'!E17/KeyMetrics!E16","v":0.79356436782490658},{"$f":"'Data Sheet'!F17/KeyMetrics!F16","v":0.83966640528240499},{"$f":"'Data Sheet'!G17/KeyMetrics!G16","v":0.69981217923467309},{"$f":"'Data Sheet'!H17/KeyMetrics!H16","v":0.72460683073882381},{"$f":"'Data Sheet'!I17/KeyMetrics!I16","v":0.68417347680316032},{"$f":"'Data Sheet'!J17/KeyMetrics!J16","v":0.9355943445547108},{"$f":"'Data Sheet'!K17/KeyMetrics!K16","v":0.76320645647068552}]
["Net Margin*Asset Turns= RoA",{"$f":"B39*B46","v":3.4678000646235677E-2},{"$f":"C39*C46","v":5.6471026681842444E-2},5.1244542166364135E-2,9.3359611653463598E-2,9.9122042021795059E-2,7.5787676902612927E-2,0.10166251578416742,7.245087119781872E-2,0.10548340515107058,0.13394695535158924,"Check back what is really driving RoA (Net Margins or Asset Turns, or both)"]
["Net Margin*Asset Turn*Fin Leverage= RoE",{"$f":"B39*B46*B19","v":8.8475148071581661E-2},0.16050213277604419,0.14265848873879466,0.23428208532994632,0.20771392591682539,0.17105839604164519,0.20791907396443662,0.16464227042829238,0.16530479662179232,0.21873021678882434,"Check back what is really driving RoE (Net Margins, Asset Turns, or Financial Leverage)"]
["RoCE",{"$f":"KeyMetrics!B6/KeyMetrics!B15","v":5.6020918330475448E-2},{"$f":"KeyMetrics!C6/KeyMetrics!C15","v":0.10265475617664901},{"$f":"KeyMetrics!D6/KeyMetrics!D15","v":0.1168640603710303},{"$f":"KeyMetrics!E6/KeyMetrics!E15","v":0.17170628736889804},{"$f":"KeyMetrics!F6/KeyMetrics!F15","v":0.18548625838983179},{"$f":"KeyMetrics!G6/KeyMetrics!G15","v":0.1793588000164833},{"$f":"KeyMetrics!H6/KeyMetrics!H15","v":0.2397482826606552},{"$f":"KeyMetrics!I6/KeyMetrics!I15","v":0.18888903575441146},{"$f":"KeyMetrics!J6/KeyMetrics!J15","v":0.24385291402260165},{"$f":"KeyMetrics!K6/KeyMetrics!K15","v":0.21500940501351584}]
["EBIT Margin*Cap Turns*(1-Tax rate)= RoIC",{"$f":"B36*B44*(1-KeyMetrics!B21)","v":5.7127646627898682E-2},{"$f":"C36*C44*(1-KeyMetrics!C21)","v":0.13773294890326776},{"$f":"D36*D44*(1-KeyMetrics!D21)","v":0.11466558560466664},{"$f":"E36*E44*(1-KeyMetrics!E21)","v":0.17741926735130795},{"$f":"F36*F44*(1-KeyMetrics!F21)","v":0.17240300624403587},{"$f":"G36*G44*(1-KeyMetrics!G21)","v":0.14542268623050336},{"$f":"H36*H44*(1-KeyMetrics!H21)","v":0.18066744822736647},{"$f":"I36*I44*(1-KeyMetrics!I21)","v":0.12526864253883641},{"$f":"J36*J44*(1-KeyMetrics!J21)","v":0.16068297444302926},{"$f":"K36*K44*(1-KeyMetrics!K21)","v":0.17380971823093594},"Check back what is really driving RoIC (Op Margins or Capital Turns, or both)"]
[]
["Altman Z-Score",{"$f":"KeyMetrics!B46","v":1.0847104615614045},{"$f":"KeyMetrics!C46","v":1.4501402080962116},{"$f":"KeyMetrics!D46","v":1.8588591332581093},{"$f":"KeyMetrics!E46","v":2.4238011794568974},{"$f":"KeyMetrics!F46","v":2.5481751811979221},{"$f":"KeyMetrics!G46","v":2.0547874314225849},{"$f":"KeyMetrics!H46","v":2.8648258376214697},{"$f":"KeyMetrics!I46","v":2.778082738652039},{"$f":"KeyMetrics!J46","v":3.3803227998093046},{"$f":"KeyMetrics!K46","v":3.0587816926525595}]
["Dividend Payout",{"$f":"'Data Sheet'!B31/'Data Sheet'!B30","v":4.0280963302752291E-2},{"$f":"'Data Sheet'!C31/'Data Sheet'!C30","v":5.0120395968964594E-2},{"$f":"'Data Sheet'!D31/'Data Sheet'!D30","v":6.1183637946040037E-2},{"$f":"'Data Sheet'!E31/'Data Sheet'!E30","v":2.308197798587153E-2},{"$f":"'Data Sheet'!F31/'Data Sheet'!F30","v":2.0775572067576062E-2},{"$f":"'Data Sheet'!G31/'Data Sheet'!G30","v":2.6477345486045724E-2},{"$f":"'Data Sheet'!H31/'Data Sheet'!H30","v":1.7256615445039029E-2},{"$f":"'Data Sheet'!I31/'Data Sheet'!I30","v":1.8410852713178296E-2},{"$f":"'Data Sheet'!J31/'Data Sheet'!J30","v":1.5349009846946574E-2},{"$f":"'Data Sheet'!K31/'Data Sheet'!K30","v":9.0429637252379732E-3}]
["Cash/Assets",{"$f":"'Data Sheet'!B69/'Data Sheet'!B61","v":2.1648895185544203E-2},{"$f":"'Data Sheet'!C69/'Data Sheet'!C61","v":2.2768707003354118E-2},{"$f":"'Data Sheet'!D69/'Data Sheet'!D61","v":1.5079007577413154E-2},{"$f":"'Data Sheet'!E69/'Data Sheet'!E61","v":1.993113444121504E-2},{"$f":"'Data Sheet'!F69/'Data Sheet'!F61","v":1.0065736920404827E-2},{"$f":"'Data Sheet'!G69/'Data Sheet'!G61","v":2.3654569639258535E-2},{"$f":"'Data Sheet'!H69/'Data Sheet'!H61","v":3.6893775672667564E-2},{"$f":"'Data Sheet'!I69/'Data Sheet'!I61","v":4.9180981077086253E-2},{"$f":"'Data Sheet'!J69/'Data Sheet'!J61","v":5.0713839903639091E-2},{"$f":"'Data Sheet'!K69/'Data Sheet'!K61","v":7.0796841374343319E-2}]
["EBIT/Invested Capital",{"$f":"KeyMetrics!B6/KeyMetrics!B14","v":5.6904709470326394E-2},{"$f":"KeyMetrics!C6/KeyMetrics!C14","v":0.1108375496928081},{"$f":"KeyMetrics!D6/KeyMetrics!D14","v":0.12278298932531298},{"$f":"KeyMetrics!E6/KeyMetrics!E14","v":0.17685359620714977},{"$f":"KeyMetrics!F6/KeyMetrics!F14","v":0.19028178831026588},{"$f":"KeyMetrics!G6/KeyMetrics!G14","v":0.18436078378218107},{"$f":"KeyMetrics!H6/KeyMetrics!H14","v":0.24530243950083019},{"$f":"KeyMetrics!I6/KeyMetrics!I14","v":0.19261947060107992},{"$f":"KeyMetrics!J6/KeyMetrics!J14","v":0.24911876456911244},{"$f":"KeyMetrics!K6/KeyMetrics!K14","v":0.22027693878419199},"Check back the significant role of EBIT/Invested Capital "]
["EPA",{"$f":"KeyMetrics!B25","v":-94.212335357492663},{"$f":"KeyMetrics!C25","v":23.552193415364147},{"$f":"KeyMetrics!D25","v":-7.7507440839875104},{"$f":"KeyMetrics!E25","v":100.88507854357455},{"$f":"KeyMetrics!F25","v":105.25667834177045},{"$f":"KeyMetrics!G25","v":60.019403014146178},{"$f":"KeyMetrics!H25","v":161.4979605302141},{"$f":"KeyMetrics!I25","v":19.543976811388379},{"$f":"KeyMetrics!J25","v":136.30464440366967},{"$f":"KeyMetrics!K25","v":252.98100929092223},"Check back what is really driving EPA (Invested Capital or RoIC, or both)"]
["MktCap",{"$f":"KeyMetrics!B27","v":1193.6879999999999},{"$f":"KeyMetrics!C27","v":1431.414},{"$f":"KeyMetrics!D27","v":2710.2055999999998},{"$f":"KeyMetrics!E27","v":3993.04},{"$f":"KeyMetrics!F27","v":3674.7216000000003},{"$f":"KeyMetrics!G27","v":2762.79},{"$f":"KeyMetrics!H27","v":6000.808},{"$f":"KeyMetrics!I27","v":7990.2979999999998},{"$f":"KeyMetrics!J27","v":7134.0439999999999},{"$f":"KeyMetrics!K27","v":6925.9560000000001}]
["MktCap Change",null,{"$f":"C57-B57","v":237.72600000000011},{"$f":"D57-C57","v":1278.7915999999998},1282.8344000000002,-318.31839999999966,-911.93160000000034,3238.018,1989.4899999999998,-856.25399999999991,-208.08799999999974]
["MktCap Change - EPA",null,{"$f":"C58-C56","v":214.17380658463597},1286.5423440839872,1181.9493214564257,-423.57507834177011,-971.95100301414652,3076.5200394697858,1969.9460231886114,-992.55864440366963,-461.06900929092194]
[]
["Capex/Net Profits 10 yr",{"$f":"SUM(KeyMetrics!B$19:K$19)/SUM(KeyMetrics!B$9:K$9)","v":0.329592508029875}]
["Capex/Net Profits 7 yr",{"$f":"SUM(KeyMetrics!E$19:K$19)/SUM(KeyMetrics!E$9:K$9)","v":0.30635170266713735}]
["Capex/Net Profits 5 yr",{"$f":"SUM(KeyMetrics!G$19:K$19)/SUM(KeyMetrics!G$9:K$9)","v":0.18972202572768476}]
["Capex/Net Profits 3 yr",{"$f":"SUM(KeyMetrics!I$19:K$19)/SUM(KeyMetrics!I$9:K$9)","v":0.32933065388777244}]
["Capex/Depreciation 10 yr",{"$f":"SUM(KeyMetrics!B$19:K$19)/SUM('Data Sheet'!B26:K26)","v":0.6340709858735506}]

{"sheet":"Data Sheet","index":5,"n_rows":93,"n_cols":11,"rows_kept":93,"cut":false,"hidden":true,"merged":[[0,4,0,10],[1,4,1,10]]}
["COMPANY NAME","KNR CONSTRUCTIONS 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":28.123462214411251}]
["Face Value",2]
["Current Price",341.4]
["Market Capitalization",9601.35]
[]
[]
[]
[]
[]
["PROFIT & LOSS"]
["Report Date","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","2024-03-31"]
["Sales",904.4,1191.68,1642.13,2069.6,2291.5,2451.6799999999998,2903.63,3605.82,4062.36,4429.49]
["Raw Material Cost",338.1,317.86,361.85,506.86,643.78,753.28,926.45,1180.72,1494.74,1703.3]
["Change in Inventory",1.61,6.33,-2.41,-5.98,1.31]
["Power and Fuel",3,1.85,5.19,7.42,10.33,15.47,17.23,20.65,20.23]
["Other Mfr. Exp",358.07,633.23,881.9,971.48,964.67,876.36,1055.6199999999999,1256.4000000000001,1362.41]
["Employee Cost",38.380000000000003,46.47,58.82,74.290000000000006,95.14,127.35,133.65,146.47999999999999,174.79,174.19]
["Selling and admin",43.3,22.46,95.34,41.9,32.58,38.700000000000003,32.47,36.590000000000003,47.26]
["Other Expenses",-1.66,3.82,-27.84,12.28,8.74,17.53,39.299999999999997,163.27000000000001,45.25,1504.25]
["Other Income",13.62,45.75,29.57,54.94,74.760000000000005,66.39,143.99,77.73,97.67,144.69]
["Depreciation",55.17,70.86,115.63,193.6,230.13,254.13,189.9,164.92,180.7,156.83000000000001]
["Interest",13.8,57,72.67,82.5,89.84,110.78,133.21,151.13999999999999,153.4,105.67]
["Profit before tax",71.47,90.21,105.73,228.23,292.36,324.47000000000003,519.79,563.38,681.25,929.94]
["Tax",-0.28000000000000003,-21.89,6.99,-0.73,27.47,68.53,136.96,196.99,241.84,196.17]
["Net profit",69.760000000000005,112.13,114.9,243.48,270.51,265.51,407.38,381.84,458.01,777.4]
["Dividend Amount",2.81,5.62,7.03,5.62,5.62,7.03,7.03,7.03,7.03,7.03]
[]
[]
[]
[]
[]
[]
[]
[]
["Quarters"]
["Report Date","2022-03-31","2022-06-30","2022-09-30","2022-12-31","2023-03-31","2023-06-30","2023-09-30","2023-12-31","2024-03-31","2024-06-30"]
["Sales",1102.0899999999999,980.45,961.65,874.93,1245.33,981.02,1038.45,996.01,1414,985]
["Expenses",823.22,769.19,698.36,678.14,999.36,765.28,806.86,770.1,1039.48,706.4]
["Other Income",19.829999999999998,10.119999999999999,9.93,68.38,10.1,7.58,5.34,6.52,125.25,20.9]
["Depreciation",47.82,40.97,45.01,46.48,48.24,36.4,39.21,40.68,40.54,30.07]
["Interest",43.31,54.53,44.61,33.380000000000003,20.56,20.34,20.61,27.66,37.07,37.130000000000003]
["Profit before tax",207.57,125.88,183.6,185.31,187.27,166.58,177.11,164.09,422.16,232.3]
["Tax",67.86,33.61,85.09,77.89,45.24,38.700000000000003,34.56,28.26,94.65,54.64]
["Net profit",139.16,89.61,115.37,105.76,147.27000000000001,137.11000000000001,147.38,139.61000000000001,353.3,172.58]
["Operating Profit",278.87,211.26,263.29000000000002,196.79,245.97,215.74,231.59,225.91,374.52,278.60000000000002]
[]
[]
[]
[]
["BALANCE SHEET"]
["Report Date","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","2024-03-31"]
["Equity Share Capital",28.12,28.12,28.12,28.12,28.12,28.12,56.25,56.25,56.25,56.25]
["Reserves",760.35,670.5,777.3,1011.14,1274.2,1524.04,1903.07,2262.96,2714.45,3497.9]
["Borrowings",733.64,735.41,721.14,770.4,758.21,874.54,764.37,1463.54,652.05999999999995,1262.43]
["Other Liabilities",489.54,551.59,715.63,798.32,668.53,1076.6400000000001,1283.49,1487.58,919.25,987.21]
["Total",2011.65,1985.62,2242.19,2607.98,2729.06,3503.34,4007.18,5270.33,4342.01,5803.79]
["Net Block",234.94,737.79,1228.44,1341.35,1320.52,1274.82,776,889.9,890.49,806.36]
["Capital Work in Progress",1108.26,428.71,91.26,1.1499999999999999,0.01,10.15,2.38,20.62,2.5099999999999998,2.1800000000000002]
["Investments",23.64,105.87,73.59,52.67,51.93,65.84,61.67,73.260000000000005,72.349999999999994,115.18]
["Other Assets",644.80999999999995,713.25,848.9,1212.81,1356.6,2152.5300000000002,3167.13,4286.55,3376.66,4880.07]
["Total",2011.65,1985.62,2242.19,2607.98,2729.06,3503.34,4007.18,5270.33,4342.01,5803.79]
["Receivables",110.13,134.6,181.69,269.14,96.8,174.65,332.87,598.41,622.9,673.98]
["Inventory",55.73,61.83,80.540000000000006,75.05,101.19,123.16,147.99,227.41,234.23,220.87]
["Cash & Bank",43.55,45.21,33.81,51.98,27.47,82.87,147.84,259.2,220.2,410.89]
["No. of Equity Shares",28123460,28123460,140617300,140617300,140617300,140617300,281234600,281234600,281234600]
["New Bonus Shares"]
["Face value",10,10,2,2,2,2,2,2,2,2]
[]
[]
[]
[]
[]
[]
[]
["CASH FLOW:"]
["Report Date","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","2024-03-31"]
["Cash from Operating Activity",78.400000000000006,245.85,365.67,220.57,255.91,230.62,-75.59,-336.44,1194.1300000000001,-315.64]
["Cash from Investing Activity",-548.95000000000005,-243.99,-249.63,-163.28,-183.5,-202.09,260.19,-408.48,66.81,-15.08]
["Cash from Financing Activity",449.83,1.47,-123.61,-37.53,-107.5,2.2200000000000002,-97.83,764.87,-1217.3499999999999,496.13]
["Net Cash Flow",-20.72,3.33,-7.57,19.760000000000002,-35.090000000000003,30.75,86.77,19.940000000000001,43.6,165.4]
[]
[]
[]
[]
["PRICE:",42.48,50.94,96.38,142,130.68,98.25,213.4,284.14999999999998,253.7,246.3]
[]
["DERIVED:"]
["Adjusted Equity Shares in Cr",28.1,28.1,28.12,28.12,28.12,28.12,28.12,28.12,28.12,28.12]

{"sheet":"KeyMetrics","index":6,"n_rows":111,"n_cols":17,"rows_kept":111,"cut":false,"hidden":false,"merged":[[50,0,50,11],[1,15,1,16]]}
[{"$f":"'Data Sheet'!B1","v":"KNR CONSTRUCTIONS LTD"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PETER LYNCH KPIs"]
[null,{"$f":"'Data Sheet'!B16","v":"2015-03-31"},{"$f":"'Data Sheet'!C16","v":"2016-03-31"},{"$f":"'Data Sheet'!D16","v":"2017-03-31"},{"$f":"'Data Sheet'!E16","v":"2018-03-31"},{"$f":"'Data Sheet'!F16","v":"2019-03-31"},{"$f":"'Data Sheet'!G16","v":"2020-03-31"},{"$f":"'Data Sheet'!H16","v":"2021-03-31"},{"$f":"'Data Sheet'!I16","v":"2022-03-31"},{"$f":"'Data Sheet'!J16","v":"2023-03-31"},{"$f":"'Data Sheet'!K16","v":"2024-03-31"},null,null,null,null,"Current Price",{"$f":"'Data Sheet'!B8","v":341.4}]
["Gross Profit",{"$f":"'Data Sheet'!B17-'Data Sheet'!B18","v":566.29999999999995},{"$f":"'Data Sheet'!C17-'Data Sheet'!C18","v":873.82},{"$f":"'Data Sheet'!D17-'Data Sheet'!D18","v":1280.2800000000002},{"$f":"'Data Sheet'!E17-'Data Sheet'!E18","v":1562.7399999999998},{"$f":"'Data Sheet'!F17-'Data Sheet'!F18","v":1647.72},{"$f":"'Data Sheet'!G17-'Data Sheet'!G18","v":1698.3999999999999},{"$f":"'Data Sheet'!H17-'Data Sheet'!H18","v":1977.18},{"$f":"'Data Sheet'!I17-'Data Sheet'!I18","v":2425.1000000000004},{"$f":"'Data Sheet'!J17-'Data Sheet'!J18","v":2567.62},{"$f":"'Data Sheet'!K17-'Data Sheet'!K18","v":2726.1899999999996},null,null,null,null,"Cash Held Per Share",{"$f":"KeyMetrics!K94/'Data Sheet'!B6","v":18.705733881172954}]
["Gross Margin",{"$f":"B4/'Data Sheet'!B17","v":0.62616099071207432},{"$f":"C4/'Data Sheet'!C17","v":0.7332673200859291},{"$f":"D4/'Data Sheet'!D17","v":0.77964594764117345},{"$f":"E4/'Data Sheet'!E17","v":0.75509277155005794},{"$f":"F4/'Data Sheet'!F17","v":0.71905738599170854},{"$f":"G4/'Data Sheet'!G17","v":0.69274946159368267},{"$f":"H4/'Data Sheet'!H17","v":0.68093386554071966},{"$f":"I4/'Data Sheet'!I17","v":0.67255159714017898},{"$f":"J4/'Data Sheet'!J17","v":0.63205131992240959},{"$f":"K4/'Data Sheet'!K17","v":0.61546363125325931},null,null,null,null,"Dividend Paid",{"$f":"KeyMetrics!K91/'Data Sheet'!B6","v":0.24996922307800462}]
["EBIT",{"$f":"'Data Sheet'!B28+'Data Sheet'!B27","v":85.27},{"$f":"'Data Sheet'!C28+'Data Sheet'!C27","v":147.20999999999998},{"$f":"'Data Sheet'!D28+'Data Sheet'!D27","v":178.4},{"$f":"'Data Sheet'!E28+'Data Sheet'!E27","v":310.73},{"$f":"'Data Sheet'!F28+'Data Sheet'!F27","v":382.20000000000005},{"$f":"'Data Sheet'!G28+'Data Sheet'!G27","v":435.25},{"$f":"'Data Sheet'!H28+'Data Sheet'!H27","v":653},{"$f":"'Data Sheet'!I28+'Data Sheet'!I27","v":714.52},{"$f":"'Data Sheet'!J28+'Data Sheet'!J27","v":834.65},{"$f":"'Data Sheet'!K28+'Data Sheet'!K27","v":1035.6100000000001},null,null,null,null,"Dividend Payout (%)",{"$f":"KeyMetrics!K92","v":9.0429637252379732E-3}]
["EBITDA",{"$f":"KeyMetrics!B6+'Data Sheet'!B26","v":140.44},{"$f":"KeyMetrics!C6+'Data Sheet'!C26","v":218.07},{"$f":"KeyMetrics!D6+'Data Sheet'!D26","v":294.02999999999997},{"$f":"KeyMetrics!E6+'Data Sheet'!E26","v":504.33000000000004},{"$f":"KeyMetrics!F6+'Data Sheet'!F26","v":612.33000000000004},{"$f":"KeyMetrics!G6+'Data Sheet'!G26","v":689.38},{"$f":"KeyMetrics!H6+'Data Sheet'!H26","v":842.9},{"$f":"KeyMetrics!I6+'Data Sheet'!I26","v":879.43999999999994},{"$f":"KeyMetrics!J6+'Data Sheet'!J26","v":1015.3499999999999},{"$f":"KeyMetrics!K6+'Data Sheet'!K26","v":1192.44},null,null,null,null,"Current EPS",{"$f":"KeyMetrics!K65/'Data Sheet'!B6","v":27.642400287459573}]
["Operating Profit (excl Other Income)",{"$f":"B7-'Data Sheet'!B25","v":126.82},{"$f":"C7-'Data Sheet'!C25","v":172.32},{"$f":"D7-'Data Sheet'!D25","v":264.45999999999998},{"$f":"E7-'Data Sheet'!E25","v":449.39000000000004},{"$f":"F7-'Data Sheet'!F25","v":537.57000000000005},{"$f":"G7-'Data Sheet'!G25","v":622.99},{"$f":"H7-'Data Sheet'!H25","v":698.91},{"$f":"I7-'Data Sheet'!I25","v":801.70999999999992},{"$f":"J7-'Data Sheet'!J25","v":917.68},{"$f":"K7-'Data Sheet'!K25","v":1047.75},null,null,null,null,"Cash EPS",{"$f":"KeyMetrics!K104/'Data Sheet'!B6","v":-11.223369213704322}]
["PAT",{"$f":"'Data Sheet'!B30","v":69.760000000000005},{"$f":"'Data Sheet'!C30","v":112.13},{"$f":"'Data Sheet'!D30","v":114.9},{"$f":"'Data Sheet'!E30","v":243.48},{"$f":"'Data Sheet'!F30","v":270.51},{"$f":"'Data Sheet'!G30","v":265.51},{"$f":"'Data Sheet'!H30","v":407.38},{"$f":"'Data Sheet'!I30","v":381.84},{"$f":"'Data Sheet'!J30","v":458.01},{"$f":"'Data Sheet'!K30","v":777.4},null,null,null,null,"Cash Yield on CMP",{"$f":"Q8/Q3","v":-3.2874543683961109E-2}]
["Dividend",{"$f":"'Data Sheet'!B31","v":2.81},{"$f":"'Data Sheet'!C31","v":5.62},{"$f":"'Data Sheet'!D31","v":7.03},{"$f":"'Data Sheet'!E31","v":5.62},{"$f":"'Data Sheet'!F31","v":5.62},{"$f":"'Data Sheet'!G31","v":7.03},{"$f":"'Data Sheet'!H31","v":7.03},{"$f":"'Data Sheet'!I31","v":7.03},{"$f":"'Data Sheet'!J31","v":7.03},{"$f":"'Data Sheet'!K31","v":7.03}]
[null,{"$f":"B3","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","2024-03-31",null,null,null,null,"A) NET PROFIT MARGIN",{"$f":"KeyMetrics!K66","v":0.17550553223960322}]
["Networth",{"$f":"'Data Sheet'!B57+'Data Sheet'!B58","v":788.47},{"$f":"'Data Sheet'!C57+'Data Sheet'!C58","v":698.62},{"$f":"'Data Sheet'!D57+'Data Sheet'!D58","v":805.42},{"$f":"'Data Sheet'!E57+'Data Sheet'!E58","v":1039.26},{"$f":"'Data Sheet'!F57+'Data Sheet'!F58","v":1302.32},{"$f":"'Data Sheet'!G57+'Data Sheet'!G58","v":1552.1599999999999},{"$f":"'Data Sheet'!H57+'Data Sheet'!H58","v":1959.32},{"$f":"'Data Sheet'!I57+'Data Sheet'!I58","v":2319.21},{"$f":"'Data Sheet'!J57+'Data Sheet'!J58","v":2770.7},{"$f":"'Data Sheet'!K57+'Data Sheet'!K58","v":3554.15},null,null,null,null,"B) ASSET TURNOVER",{"$f":"KeyMetrics!K45","v":0.76320645647068552}]
["Working Capital",{"$f":"'Data Sheet'!B65-'Data Sheet'!B60","v":155.26999999999992},{"$f":"'Data Sheet'!C65-'Data Sheet'!C60","v":161.65999999999997},{"$f":"'Data Sheet'!D65-'Data Sheet'!D60","v":133.26999999999998},{"$f":"'Data Sheet'!E65-'Data Sheet'!E60","v":414.4899999999999},{"$f":"'Data Sheet'!F65-'Data Sheet'!F60","v":688.06999999999994},{"$f":"'Data Sheet'!G65-'Data Sheet'!G60","v":1075.8900000000001},{"$f":"'Data Sheet'!H65-'Data Sheet'!H60","v":1883.64},{"$f":"'Data Sheet'!I65-'Data Sheet'!I60","v":2798.9700000000003},{"$f":"'Data Sheet'!J65-'Data Sheet'!J60","v":2457.41},{"$f":"'Data Sheet'!K65-'Data Sheet'!K60","v":3892.8599999999997},null,null,null,null,"C) LEVERAGE",{"$f":"(KeyMetrics!K96+KeyMetrics!K97)/KeyMetrics!K97","v":1.3551988520461995}]
["Invested Capital",{"$f":"'Data Sheet'!B62+'Data Sheet'!B63+KeyMetrics!B13","v":1498.47},{"$f":"'Data Sheet'!C62+'Data Sheet'!C63+KeyMetrics!C13","v":1328.1599999999999},{"$f":"'Data Sheet'!D62+'Data Sheet'!D63+KeyMetrics!D13","v":1452.97},{"$f":"'Data Sheet'!E62+'Data Sheet'!E63+KeyMetrics!E13","v":1756.9899999999998},{"$f":"'Data Sheet'!F62+'Data Sheet'!F63+KeyMetrics!F13","v":2008.6},{"$f":"'Data Sheet'!G62+'Data Sheet'!G63+KeyMetrics!G13","v":2360.86},{"$f":"'Data Sheet'!H62+'Data Sheet'!H63+KeyMetrics!H13","v":2662.02},{"$f":"'Data Sheet'!I62+'Data Sheet'!I63+KeyMetrics!I13","v":3709.4900000000002},{"$f":"'Data Sheet'!J62+'Data Sheet'!J63+KeyMetrics!J13","v":3350.41},{"$f":"'Data Sheet'!K62+'Data Sheet'!K63+KeyMetrics!K13","v":4701.3999999999996},null,null,null,null,"ROE = A X B X C",{"$f":"Q11*Q12*Q13","v":0.18152476012755728}]
["Capital Employed",{"$f":"B12+'Data Sheet'!B59","v":1522.1100000000001},{"$f":"C12+'Data Sheet'!C59","v":1434.03},{"$f":"D12+'Data Sheet'!D59","v":1526.56},{"$f":"E12+'Data Sheet'!E59","v":1809.6599999999999},{"$f":"F12+'Data Sheet'!F59","v":2060.5299999999997},{"$f":"G12+'Data Sheet'!G59","v":2426.6999999999998},{"$f":"H12+'Data Sheet'!H59","v":2723.69},{"$f":"I12+'Data Sheet'!I59","v":3782.75},{"$f":"J12+'Data Sheet'!J59","v":3422.7599999999998},{"$f":"K12+'Data Sheet'!K59","v":4816.58}]
["Total Assets",{"$f":"'Data Sheet'!B61","v":2011.65},{"$f":"'Data Sheet'!C61","v":1985.62},{"$f":"'Data Sheet'!D61","v":2242.19},{"$f":"'Data Sheet'!E61","v":2607.98},{"$f":"'Data Sheet'!F61","v":2729.06},{"$f":"'Data Sheet'!G61","v":3503.34},{"$f":"'Data Sheet'!H61","v":4007.18},{"$f":"'Data Sheet'!I61","v":5270.33},{"$f":"'Data Sheet'!J61","v":4342.01},{"$f":"'Data Sheet'!K61","v":5803.79},null,null,null,null,"Price/Earnings",{"$f":"Q3/Q7","v":12.350591715976332}]
[null,{"$f":"B3","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","2024-03-31",null,null,null,null,"Cash Adjusted P/E ratio",{"$f":"(Q3-Q4)/Q7","v":11.673887316696682}]
["Operating Cash Flow",{"$f":"'Data Sheet'!B82","v":78.400000000000006},{"$f":"'Data Sheet'!C82","v":245.85},{"$f":"'Data Sheet'!D82","v":365.67},{"$f":"'Data Sheet'!E82","v":220.57},{"$f":"'Data Sheet'!F82","v":255.91},{"$f":"'Data Sheet'!G82","v":230.62},{"$f":"'Data Sheet'!H82","v":-75.59},{"$f":"'Data Sheet'!I82","v":-336.44},{"$f":"'Data Sheet'!J82","v":1194.1300000000001},{"$f":"'Data Sheet'!K82","v":-315.64},null,null,null,null,"Price/Book Value",{"$f":"Q3/(KeyMetrics!K97/'Data Sheet'!B6)","v":2.7014476035057609}]
["Capex",null,{"$f":"('Data Sheet'!C62-'Data Sheet'!B62)+('Data Sheet'!C63-'Data Sheet'!B63)+'Data Sheet'!C26","v":-105.83999999999999},{"$f":"('Data Sheet'!D62-'Data Sheet'!C62)+('Data Sheet'!D63-'Data Sheet'!C63)+'Data Sheet'!D26","v":268.8300000000001},{"$f":"('Data Sheet'!E62-'Data Sheet'!D62)+('Data Sheet'!E63-'Data Sheet'!D63)+'Data Sheet'!E26","v":216.39999999999986},{"$f":"('Data Sheet'!F62-'Data Sheet'!E62)+('Data Sheet'!F63-'Data Sheet'!E63)+'Data Sheet'!F26","v":208.16000000000008},{"$f":"('Data Sheet'!G62-'Data Sheet'!F62)+('Data Sheet'!G63-'Data Sheet'!F63)+'Data Sheet'!G26","v":218.56999999999994},{"$f":"('Data Sheet'!H62-'Data Sheet'!G62)+('Data Sheet'!H63-'Data Sheet'!G63)+'Data Sheet'!H26","v":-316.68999999999994},{"$f":"('Data Sheet'!I62-'Data Sheet'!H62)+('Data Sheet'!I63-'Data Sheet'!H63)+'Data Sheet'!I26","v":297.05999999999995},{"$f":"('Data Sheet'!J62-'Data Sheet'!I62)+('Data Sheet'!J63-'Data Sheet'!I63)+'Data Sheet'!J26","v":163.18},{"$f":"('Data Sheet'!K62-'Data Sheet'!J62)+('Data Sheet'!K63-'Data Sheet'!J63)+'Data Sheet'!K26","v":72.370000000000019},null,null,null,null,"Dividend Yield",{"$f":"Q5/Q3","v":7.3218870263035921E-4}]
["Free Cash Flow",null,{"$f":"C18-C19","v":351.69},{"$f":"D18-D19","v":96.839999999999918},4.1700000000001296,47.749999999999915,12.050000000000068,241.09999999999994,-633.5,1030.95,-388.01,null,null,null,null,"Earnings Growth",{"$f":"Q89/Q88-1","v":0.69734285277614028}]
["Tax Rate",{"$f":"'Data Sheet'!B29/'Data Sheet'!B28","v":-3.9177277179236044E-3},{"$f":"'Data Sheet'!C29/'Data Sheet'!C28","v":-0.24265602483095003},{"$f":"'Data Sheet'!D29/'Data Sheet'!D28","v":6.6111794192755133E-2},{"$f":"'Data Sheet'!E29/'Data Sheet'!E28","v":-3.1985278009025982E-3},{"$f":"'Data Sheet'!F29/'Data Sheet'!F28","v":9.3959501983855512E-2},{"$f":"'Data Sheet'!G29/'Data Sheet'!G28","v":0.21120596665331154},{"$f":"'Data Sheet'!H29/'Data Sheet'!H28","v":0.26349102522172418},{"$f":"'Data Sheet'!I29/'Data Sheet'!I28","v":0.34965742482871243},{"$f":"'Data Sheet'!J29/'Data Sheet'!J28","v":0.35499449541284406},{"$f":"'Data Sheet'!K29/'Data Sheet'!K28","v":0.21094909348990254},null,null,null,null,"Inverse PEG ",{"$f":"(Q20+Q19)/Q16","v":5.652158678160845E-2}]
["NOPLAT",{"$f":"B6*(1-B21)","v":85.604064642507339},182.93139341536411,166.60565591601249,311.72387854357447,346.28867834177049,343.32260301414618,480.94036053021409,464.68277681138841,538.35384440366965,817.14900929092209]
["RoIC",{"$f":"(B6/B14)*(1-B21)","v":5.7127646627898682E-2},{"$f":"(C6/C14)*(1-C21)","v":0.13773294890326779},0.11466558560466664,0.17741926735130795,0.17240300624403587,0.14542268623050336,0.18066744822736647,0.12526864253883643,0.16068297444302926,0.17380971823093594,null,null,null,null,"Growth Nos:"]
["WACC",0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,null,null,null,null,"3 Year Sales CAGR ",{"$f":"RATE(3,,-Q58,Q61,0,)","v":0.15116475276276356}]
["EPA (Economic Profit Added)",{"$f":"B14*(B23-B24)","v":-94.212335357492663},{"$f":"C14*(C23-C24)","v":23.552193415364147},-7.7507440839875104,100.88507854357455,105.25667834177045,60.019403014146178,161.4979605302141,19.543976811388379,136.30464440366967,252.98100929092223,null,null,null,null,"3 Years Profit CAGR",{"$f":"RATE(3,,-Q86,Q89,0,)","v":0.24036149978039753}]
[null,{"$f":"B3","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","2024-03-31","CURRENT",null,null,null,"1 Year Sales Growth",{"$f":"RATE(1,,-Q60,Q61,0,)","v":9.0373575950925017E-2}]
["MktCap",{"$f":"'Data Sheet'!B90*'Data Sheet'!B93","v":1193.6879999999999},{"$f":"'Data Sheet'!C90*'Data Sheet'!C93","v":1431.414},{"$f":"'Data Sheet'!D90*'Data Sheet'!D93","v":2710.2055999999998},{"$f":"'Data Sheet'!E90*'Data Sheet'!E93","v":3993.04},{"$f":"'Data Sheet'!F90*'Data Sheet'!F93","v":3674.7216000000003},{"$f":"'Data Sheet'!G90*'Data Sheet'!G93","v":2762.79},{"$f":"'Data Sheet'!H90*'Data Sheet'!H93","v":6000.808},{"$f":"'Data Sheet'!I90*'Data Sheet'!I93","v":7990.2979999999998},{"$f":"'Data Sheet'!J90*'Data Sheet'!J93","v":7134.0439999999999},{"$f":"'Data Sheet'!K90*'Data Sheet'!K93","v":6925.9560000000001},{"$f":"'Data Sheet'!B9","v":9601.35},null,null,null,"1 Year EBIT Growth",{"$f":"RATE(1,,-Q81,Q82,0,)","v":9.6687849378175331E-2}]
["MktCap+Dividend",{"$f":"B27+'Data Sheet'!B31","v":1196.4979999999998},{"$f":"C27+'Data Sheet'!C31","v":1437.0339999999999},{"$f":"D27+'Data Sheet'!D31","v":2717.2356},{"$f":"E27+'Data Sheet'!E31","v":3998.66},{"$f":"F27+'Data Sheet'!F31","v":3680.3416000000002},{"$f":"G27+'Data Sheet'!G31","v":2769.82},{"$f":"H27+'Data Sheet'!H31","v":6007.8379999999997},{"$f":"I27+'Data Sheet'!I31","v":7997.3279999999995},{"$f":"J27+'Data Sheet'!J31","v":7141.0739999999996},{"$f":"K27+'Data Sheet'!K31","v":6932.9859999999999},null,null,null,null,"1 Year Profit Growth",{"$f":"RATE(1,,-Q88,Q89,0,)","v":0.69734285277614028}]
["Retained Profit",{"$f":"'Data Sheet'!B30-'Data Sheet'!B31","v":66.95},{"$f":"'Data Sheet'!C30-'Data Sheet'!C31","v":106.50999999999999},{"$f":"'Data Sheet'!D30-'Data Sheet'!D31","v":107.87},{"$f":"'Data Sheet'!E30-'Data Sheet'!E31","v":237.85999999999999},{"$f":"'Data Sheet'!F30-'Data Sheet'!F31","v":264.89},{"$f":"'Data Sheet'!G30-'Data Sheet'!G31","v":258.48},{"$f":"'Data Sheet'!H30-'Data Sheet'!H31","v":400.35},{"$f":"'Data Sheet'!I30-'Data Sheet'!I31","v":374.81},{"$f":"'Data Sheet'!J30-'Data Sheet'!J31","v":450.98},{"$f":"'Data Sheet'!K30-'Data Sheet'!K31","v":770.37},null,null,null,null,"RM/ Sales",{"$f":"Q75/Q61","v":0.38453636874674063}]
["Shares Outstanding (Mn)",{"$f":"'Data Sheet'!B70/10^6","v":28.123460000000001},{"$f":"'Data Sheet'!C70/10^6","v":28.123460000000001},{"$f":"'Data Sheet'!D70/10^6","v":140.6173},{"$f":"'Data Sheet'!E70/10^6","v":140.6173},{"$f":"'Data Sheet'!F70/10^6","v":140.6173},{"$f":"'Data Sheet'!G70/10^6","v":140.6173},{"$f":"'Data Sheet'!H70/10^6","v":281.2346},{"$f":"'Data Sheet'!I70/10^6","v":281.2346},{"$f":"'Data Sheet'!J70/10^6","v":281.2346},{"$f":"'Data Sheet'!K70/10^6","v":0},null,null,null,null,"5 yr Avg RM/Sales",{"$f":"AVERAGE(Q71/Q57,Q72/Q58,Q73/Q59,Q74/Q60,Q75/Q61)","v":0.34125002490994993}]
["EPS",{"$f":"B9/B30*10","v":24.804913762389123},{"$f":"C9/C30*10","v":39.870627582808083},8.1711140805576559,17.315081430236535,19.237320016811587,18.881744991547983,14.485415379188762,13.577276764665513,16.285691732098396,{"$error":"#DIV/0!"},null,null,null,null,"Inventory/Sales",{"$f":"Q68/Q61","v":4.9863528306870547E-2}]
["EV",{"$f":"B27+'Data Sheet'!B59-'Data Sheet'!B69","v":1883.778},{"$f":"C27+'Data Sheet'!C59-'Data Sheet'!C69","v":2121.614},{"$f":"D27+'Data Sheet'!D59-'Data Sheet'!D69","v":3397.5355999999997},{"$f":"E27+'Data Sheet'!E59-'Data Sheet'!E69","v":4711.46},{"$f":"F27+'Data Sheet'!F59-'Data Sheet'!F69","v":4405.4615999999996},{"$f":"G27+'Data Sheet'!G59-'Data Sheet'!G69","v":3554.46},{"$f":"H27+'Data Sheet'!H59-'Data Sheet'!H69","v":6617.3379999999997},{"$f":"I27+'Data Sheet'!I59-'Data Sheet'!I69","v":9194.637999999999},{"$f":"J27+'Data Sheet'!J59-'Data Sheet'!J69","v":7565.9039999999995},{"$f":"K27+'Data Sheet'!K59-'Data Sheet'!K69","v":7777.4960000000001},null,null,null,null,"5 yr Avg Inventory/Sales",{"$f":"AVERAGE(Q64/Q57,Q65/Q58,Q66/Q59,Q67/Q60,Q68/Q61)","v":7.4936202504992971E-2}]
[null,{"$f":"B3","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","2024-03-31"]
["Price/Earnings",{"$f":"B27/'Data Sheet'!B30","v":17.11135321100917},{"$f":"C27/'Data Sheet'!C30","v":12.765664853295283},{"$f":"D27/'Data Sheet'!D30","v":23.587516100957352},{"$f":"E27/'Data Sheet'!E30","v":16.399868572367343},{"$f":"F27/'Data Sheet'!F30","v":13.584420538981925},{"$f":"G27/'Data Sheet'!G30","v":10.405596776015969},{"$f":"H27/'Data Sheet'!H30","v":14.730246943885316},{"$f":"I27/'Data Sheet'!I30","v":20.925775193798451},{"$f":"J27/'Data Sheet'!J30","v":15.576175192681383},{"$f":"K27/'Data Sheet'!K30","v":8.9091278621044516},null,null,null,null,"Debt:Equity",{"$f":"Q36/Q35","v":0.3551988520461995}]
["Price/Book",{"$f":"B27/B12","v":1.5139295090491709},2.04891643525808,3.3649594000645626,3.8421954082712699,2.8216733214570922,1.7799646943614063,3.062699303840108,3.445267138379017,2.5748164723716029,1.9486954686774616,null,null,null,null,"Networth",{"$f":"Q109","v":3554.15}]
["Price/CashFlow",{"$f":"B27/B18","v":15.225612244897956},5.8223062843197075,7.4116159378674755,18.103277870970668,14.359429486929001,11.979836961234932,-79.386268024871015,-23.749548210676494,5.9742607588788488,-21.942580154606514,null,null,null,null,"Long Term Debt",{"$f":"Q107","v":1262.43}]
["Price/Sales",{"$f":"B27/'Data Sheet'!B17","v":1.3198673153471914},{"$f":"C27/'Data Sheet'!C17","v":1.2011731337271749},{"$f":"D27/'Data Sheet'!D17","v":1.6504208558396714},{"$f":"E27/'Data Sheet'!E17","v":1.9293776575183612},{"$f":"F27/'Data Sheet'!F17","v":1.6036315077460179},{"$f":"G27/'Data Sheet'!G17","v":1.1268966586177642},{"$f":"H27/'Data Sheet'!H17","v":2.0666572531624205},{"$f":"I27/'Data Sheet'!I17","v":2.2159447781641899},{"$f":"J27/'Data Sheet'!J17","v":1.7561328882718419},{"$f":"K27/'Data Sheet'!K17","v":1.56360122722932},null,null,null,null,"Cash & Bank Balance",{"$f":"'Data Sheet'!K69","v":410.89}]
["EV/EBITDA",{"$f":"B32/B7","v":13.413400740529765},9.7290503049479522,11.555064449205863,9.3420181230543484,7.1945872323746984,5.1560242536772174,7.8506797959425789,10.455105521695623,7.4515231201063674,6.5223373922377643,null,null,null,null,"Investments",{"$f":"'Data Sheet'!K64","v":115.18}]
["Dividend Yield",{"$f":"'Data Sheet'!B31/KeyMetrics!B27","v":2.354048964218456E-3},{"$f":"'Data Sheet'!C31/KeyMetrics!C27","v":3.9261876717707105E-3},{"$f":"'Data Sheet'!D31/KeyMetrics!D27","v":2.5938991492010792E-3},{"$f":"'Data Sheet'!E31/KeyMetrics!E27","v":1.407448961192475E-3},{"$f":"'Data Sheet'!F31/KeyMetrics!F27","v":1.529367558075692E-3},{"$f":"'Data Sheet'!G31/KeyMetrics!G27","v":2.5445292620865142E-3},{"$f":"'Data Sheet'!H31/KeyMetrics!H27","v":1.1715089034676665E-3},{"$f":"'Data Sheet'!I31/KeyMetrics!I27","v":8.7981699806440267E-4},{"$f":"'Data Sheet'!J31/KeyMetrics!J27","v":9.8541584548679549E-4},{"$f":"'Data Sheet'!K31/KeyMetrics!K27","v":1.0150223304912708E-3}]
[null,{"$f":"B3","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","2024-03-31","Z-Weights",null,null,null,"Management Effectiveness:"]
["Working Capital/Total Assets",{"$f":"B13/B16","v":7.7185395073695678E-2},8.1415376557448044E-2,5.9437425017505201E-2,0.15893143352326317,0.25212710603651073,0.30710407782287763,0.47006623111514834,0.53108059647118877,0.56596138654678352,0.67074446180857672,1.2,null,null,null,"Book Value",{"$f":"KeyMetrics!K97/'Data Sheet'!B6","v":126.37668765329875}]
["Retained Profits/Total Assets",{"$f":"B29/B16","v":3.3281137374791839E-2},5.3640676463774538E-2,4.810921465174673E-2,9.1204687152508832E-2,9.706272489428594E-2,7.3781020397677644E-2,9.9908164844104835E-2,7.1116988879254245E-2,0.10386433932671735,0.13273567789323873,1.4,null,null,null,"ROE",{"$f":"Q7/Q41","v":0.21873021678882432}]
["EBIT/Total Assets",{"$f":"B6/B16","v":4.2388089379365196E-2},7.4138052598180917E-2,7.9565068080760332E-2,0.11914585234549345,0.14004822173202497,0.1242385837515057,0.16295749130311094,0.13557405323765304,0.19222664157843947,0.17843684902451676,3.3,null,null,null,"ROCE",{"$f":"Q50/(AVERAGE(Q106,Q107)+AVERAGE(Q108,Q109))","v":0.18870443506397358}]
["Market Cap/Total Liabilities",{"$f":"B27/B16","v":0.59338751770934295},{"$f":"C27/C16","v":0.72089020054189623},1.2087314634353019,1.5310853610840574,1.346515503506702,0.78861600643956908,1.497513962437425,1.5160906432804018,1.6430279985536651,1.1933505519669043,0.6,null,null,null,"Shares ( in Cr)",{"$f":"'Data Sheet'!B6","v":28.123462214411251}]
["Sales/Total Assets",{"$f":"'Data Sheet'!B17/KeyMetrics!B16","v":0.44958118957075033},{"$f":"'Data Sheet'!C17/KeyMetrics!C16","v":0.60015511527885501},{"$f":"'Data Sheet'!D17/KeyMetrics!D16","v":0.73237771999696732},{"$f":"'Data Sheet'!E17/KeyMetrics!E16","v":0.79356436782490658},{"$f":"'Data Sheet'!F17/KeyMetrics!F16","v":0.83966640528240499},{"$f":"'Data Sheet'!G17/KeyMetrics!G16","v":0.69981217923467309},{"$f":"'Data Sheet'!H17/KeyMetrics!H16","v":0.72460683073882381},{"$f":"'Data Sheet'!I17/KeyMetrics!I16","v":0.68417347680316032},{"$f":"'Data Sheet'!J17/KeyMetrics!J16","v":0.9355943445547108},{"$f":"'Data Sheet'!K17/KeyMetrics!K16","v":0.76320645647068552},1,null,null,null,"Margins: "]
["Altman Z-Score",{"$f":"$L$41*B41+$L$42*B42+$L$43*B43+$L$44*B44+$L$45*B45","v":1.0847104615614045},1.4501402080962116,1.8588591332581093,2.4238011794568974,2.5481751811979221,2.0547874314225849,2.8648258376214697,2.778082738652039,3.3803227998093046,3.0587816926525595,null,null,null,null,"Operating ",{"$f":"Q82/Q61","v":0.27194552871775307}]
["Z > 2.99 -“Safe” Zones",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Net Profit",{"$f":"Q89/Q61","v":0.17550553223960322}]
["1.81 < Z < 2.99 -“Grey” Zones"]
["Z < 1.81 -“Distress” Zones",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Latest Earnings:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Net Profit (TTM)",{"$f":"SUM(Q51:Q54)","v":777.40000000000009}]
["10 YEARS NUMBERS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q1",{"$f":"'Data Sheet'!G49","v":137.11000000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q2",{"$f":"'Data Sheet'!H49","v":147.38}]
[null,{"$f":"'Profit & Loss'!B3","v":"2015-03-31"},{"$f":"'Profit & Loss'!C3","v":"2016-03-31"},{"$f":"'Profit & Loss'!D3","v":"2017-03-31"},{"$f":"'Profit & Loss'!E3","v":"2018-03-31"},{"$f":"'Profit & Loss'!F3","v":"2019-03-31"},{"$f":"'Profit & Loss'!G3","v":"2020-03-31"},{"$f":"'Profit & Loss'!H3","v":"2021-03-31"},{"$f":"'Profit & Loss'!I3","v":"2022-03-31"},{"$f":"'Profit & Loss'!J3","v":"2023-03-31"},{"$f":"'Profit & Loss'!K3","v":"2024-03-31"},"Total 10 Yrs ","CAGR",null,null,"Q3",{"$f":"'Data Sheet'!I49","v":139.61000000000001}]
[{"$f":"'Profit & Loss'!A4","v":"Sales"},{"$f":"'Profit & Loss'!B4","v":904.4},{"$f":"'Profit & Loss'!C4","v":1191.68},{"$f":"'Profit & Loss'!D4","v":1642.13},{"$f":"'Profit & Loss'!E4","v":2069.6},{"$f":"'Profit & Loss'!F4","v":2291.5},{"$f":"'Profit & Loss'!G4","v":2451.6799999999998},{"$f":"'Profit & Loss'!H4","v":2903.63},{"$f":"'Profit & Loss'!I4","v":3605.82},{"$f":"'Profit & Loss'!J4","v":4062.36},{"$f":"'Profit & Loss'!K4","v":4429.49},{"$f":"SUM(B54:K54)","v":25552.29},{"$f":"RATE(9,,-B54,K54,0,0.2)","v":0.19306995212284644},null,null,"Q4",{"$f":"'Data Sheet'!J49","v":353.3}]
["Receivables",{"$f":"'Data Sheet'!B67","v":110.13},{"$f":"'Data Sheet'!C67","v":134.6},{"$f":"'Data Sheet'!D67","v":181.69},{"$f":"'Data Sheet'!E67","v":269.14},{"$f":"'Data Sheet'!F67","v":96.8},{"$f":"'Data Sheet'!G67","v":174.65},{"$f":"'Data Sheet'!H67","v":332.87},{"$f":"'Data Sheet'!I67","v":598.41},{"$f":"'Data Sheet'!J67","v":622.9},{"$f":"'Data Sheet'!K67","v":673.98},null,{"$f":"RATE(9,,-B55,K55,0,0.2)","v":0.22296972981455412}]
["% Sales",{"$f":"B55/B54","v":0.12177134011499337},0.11294978517722877,0.11064288454629048,0.13004445303440279,4.224307222343443E-2,7.1236866148926464E-2,0.11463926188942805,0.16595670332961709,0.1533345149125139,0.1521574718534188,null,null,null,null,"Last 5 Years: Sales"]
["EBITDA",{"$f":"'Profit & Loss'!B6+'Data Sheet'!B26","v":181.98999999999995},{"$f":"'Profit & Loss'!C6+'Data Sheet'!C26","v":243.18000000000006},{"$f":"'Profit & Loss'!D6+'Data Sheet'!D26","v":380.09000000000003},{"$f":"'Profit & Loss'!E6+'Data Sheet'!E26","v":642.9899999999999},{"$f":"'Profit & Loss'!F6+'Data Sheet'!F26","v":767.69999999999993},{"$f":"'Profit & Loss'!G6+'Data Sheet'!G26","v":877.11999999999978},{"$f":"'Profit & Loss'!H6+'Data Sheet'!H26","v":888.81000000000029},{"$f":"'Profit & Loss'!I6+'Data Sheet'!I26","v":966.62999999999954},{"$f":"'Profit & Loss'!J6+'Data Sheet'!J26","v":1098.3799999999999},{"$f":"'Profit & Loss'!K6+'Data Sheet'!K26","v":1204.58},null,{"$f":"RATE(9,,-B57,K57,0,0.2)","v":0.23366908113466622},null,null,2014,{"$f":"KeyMetrics!G54","v":2451.6799999999998}]
["EBITDA %",{"$f":"B57/B54","v":0.20122733303847851},0.20406484962406019,0.23146157734162337,0.31068322381136448,0.33502072878027489,0.3577628401749004,0.30610305031977225,0.26807494550476713,0.27037977924162304,0.27194552871775307,null,null,null,null,{"$f":"P57+1","v":2015},{"$f":"KeyMetrics!H54","v":2903.63}]
[{"$f":"'Profit & Loss'!A7","v":"Other Income"},{"$f":"'Profit & Loss'!B7","v":13.62},{"$f":"'Profit & Loss'!C7","v":45.75},{"$f":"'Profit & Loss'!D7","v":29.57},{"$f":"'Profit & Loss'!E7","v":54.94},{"$f":"'Profit & Loss'!F7","v":74.760000000000005},{"$f":"'Profit & Loss'!G7","v":66.39},{"$f":"'Profit & Loss'!H7","v":143.99},{"$f":"'Profit & Loss'!I7","v":77.73},{"$f":"'Profit & Loss'!J7","v":97.67},{"$f":"'Profit & Loss'!K7","v":144.69},null,null,null,null,{"$f":"P58+1","v":2016},{"$f":"KeyMetrics!I54","v":3605.82}]
[{"$f":"'Profit & Loss'!A8","v":"Depreciation"},{"$f":"'Profit & Loss'!B8","v":55.17},{"$f":"'Profit & Loss'!C8","v":70.86},{"$f":"'Profit & Loss'!D8","v":115.63},{"$f":"'Profit & Loss'!E8","v":193.6},{"$f":"'Profit & Loss'!F8","v":230.13},{"$f":"'Profit & Loss'!G8","v":254.13},{"$f":"'Profit & Loss'!H8","v":189.9},{"$f":"'Profit & Loss'!I8","v":164.92},{"$f":"'Profit & Loss'!J8","v":180.7},{"$f":"'Profit & Loss'!K8","v":156.83000000000001},{"$f":"SUM(B60:K60)","v":1611.8700000000001},null,null,null,{"$f":"P59+1","v":2017},{"$f":"KeyMetrics!J54","v":4062.36}]
[{"$f":"'Profit & Loss'!A9","v":"Interest"},{"$f":"'Profit & Loss'!B9","v":13.8},{"$f":"'Profit & Loss'!C9","v":57},{"$f":"'Profit & Loss'!D9","v":72.67},{"$f":"'Profit & Loss'!E9","v":82.5},{"$f":"'Profit & Loss'!F9","v":89.84},{"$f":"'Profit & Loss'!G9","v":110.78},{"$f":"'Profit & Loss'!H9","v":133.21},{"$f":"'Profit & Loss'!I9","v":151.13999999999999},{"$f":"'Profit & Loss'!J9","v":153.4},{"$f":"'Profit & Loss'!K9","v":105.67},{"$f":"SUM(B61:K61)","v":970.01},null,null,null,{"$f":"P60+1","v":2018},{"$f":"KeyMetrics!K54","v":4429.49}]
[{"$f":"'Profit & Loss'!A10","v":"Profit before tax"},{"$f":"'Profit & Loss'!B10","v":71.47},{"$f":"'Profit & Loss'!C10","v":90.21},{"$f":"'Profit & Loss'!D10","v":105.73},{"$f":"'Profit & Loss'!E10","v":228.23},{"$f":"'Profit & Loss'!F10","v":292.36},{"$f":"'Profit & Loss'!G10","v":324.47000000000003},{"$f":"'Profit & Loss'!H10","v":519.79},{"$f":"'Profit & Loss'!I10","v":563.38},{"$f":"'Profit & Loss'!J10","v":681.25},{"$f":"'Profit & Loss'!K10","v":929.94},null,{"$f":"RATE(9,,-B62,K62,0,0.2)","v":0.3298864829321364}]
["Tax%",{"$f":"B64/B62","v":-3.9177277179236044E-3},-0.24265602483095003,6.6111794192755133E-2,-3.1985278009025982E-3,9.3959501983855512E-2,0.21120596665331154,0.26349102522172418,0.34965742482871243,0.35499449541284406,0.21094909348990254,null,null,null,null,"Last 5 Years: Inventory"]
[{"$f":"'Profit & Loss'!A11","v":"Tax"},{"$f":"'Profit & Loss'!B11","v":-0.28000000000000003},{"$f":"'Profit & Loss'!C11","v":-21.89},{"$f":"'Profit & Loss'!D11","v":6.99},{"$f":"'Profit & Loss'!E11","v":-0.73},{"$f":"'Profit & Loss'!F11","v":27.47},{"$f":"'Profit & Loss'!G11","v":68.53},{"$f":"'Profit & Loss'!H11","v":136.96},{"$f":"'Profit & Loss'!I11","v":196.99},{"$f":"'Profit & Loss'!J11","v":241.84},{"$f":"'Profit & Loss'!K11","v":196.17},null,null,null,null,{"$f":"P57","v":2014},{"$f":"'Data Sheet'!G68","v":123.16}]
["Net Profit after Tax",{"$f":"'Profit & Loss'!B12","v":69.760000000000005},{"$f":"'Profit & Loss'!C12","v":112.13},{"$f":"'Profit & Loss'!D12","v":114.9},{"$f":"'Profit & Loss'!E12","v":243.48},{"$f":"'Profit & Loss'!F12","v":270.51},{"$f":"'Profit & Loss'!G12","v":265.51},{"$f":"'Profit & Loss'!H12","v":407.38},{"$f":"'Profit & Loss'!I12","v":381.84},{"$f":"'Profit & Loss'!J12","v":458.01},{"$f":"'Profit & Loss'!K12","v":777.4},{"$f":"SUM(B65:K65)","v":3100.92},{"$f":"RATE(9,,-B65,K65,0,0.2)","v":0.3071865261352148},null,null,{"$f":"P58","v":2015},{"$f":"'Data Sheet'!H68","v":147.99}]
["NPM%",{"$f":"B65/B54","v":7.7134011499336588E-2},9.4094052094522013E-2,6.9970099809393893E-2,0.1176459219172787,0.11804931267728562,0.10829716765646415,0.14030024486590922,0.10589546899179658,0.11274480843647534,0.17550553223960322,null,null,null,null,{"$f":"P59","v":2016},{"$f":"'Data Sheet'!I67","v":598.41}]
["Cash from Operations",{"$f":"'Cash Flow'!B4","v":78.400000000000006},{"$f":"'Cash Flow'!C4","v":245.85},{"$f":"'Cash Flow'!D4","v":365.67},{"$f":"'Cash Flow'!E4","v":220.57},{"$f":"'Cash Flow'!F4","v":255.91},{"$f":"'Cash Flow'!G4","v":230.62},{"$f":"'Cash Flow'!H4","v":-75.59},{"$f":"'Cash Flow'!I4","v":-336.44},{"$f":"'Cash Flow'!J4","v":1194.1300000000001},{"$f":"'Cash Flow'!K4","v":-315.64},{"$f":"SUM(B67:K67)","v":1863.48},{"$f":"RATE(9,,-B67,K67,0,0.2)","v":{"$error":"#NUM!"}},null,null,{"$f":"P60","v":2017},{"$f":"'Data Sheet'!J68","v":234.23}]
["Capex(NFA+WIP Change+Dep)",null,{"$f":"('Balance Sheet'!C10-'Balance Sheet'!B10)+('Balance Sheet'!C11-'Balance Sheet'!B11)+C60","v":-105.83999999999999},{"$f":"('Balance Sheet'!D10-'Balance Sheet'!C10)+('Balance Sheet'!D11-'Balance Sheet'!C11)+D60","v":268.8300000000001},{"$f":"('Balance Sheet'!E10-'Balance Sheet'!D10)+('Balance Sheet'!E11-'Balance Sheet'!D11)+E60","v":216.39999999999986},{"$f":"('Balance Sheet'!F10-'Balance Sheet'!E10)+('Balance Sheet'!F11-'Balance Sheet'!E11)+F60","v":208.16000000000008},{"$f":"('Balance Sheet'!G10-'Balance Sheet'!F10)+('Balance Sheet'!G11-'Balance Sheet'!F11)+G60","v":218.56999999999994},{"$f":"('Balance Sheet'!H10-'Balance Sheet'!G10)+('Balance Sheet'!H11-'Balance Sheet'!G11)+H60","v":-316.68999999999994},{"$f":"('Balance Sheet'!I10-'Balance Sheet'!H10)+('Balance Sheet'!I11-'Balance Sheet'!H11)+I60","v":297.05999999999995},{"$f":"('Balance Sheet'!J10-'Balance Sheet'!I10)+('Balance Sheet'!J11-'Balance Sheet'!I11)+J60","v":163.18},{"$f":"('Balance Sheet'!K10-'Balance Sheet'!J10)+('Balance Sheet'!K11-'Balance Sheet'!J11)+K60","v":72.370000000000019},{"$f":"SUM(B68:K68)","v":1022.0400000000001},{"$f":"RATE(8,,-C68,K68,0,0.2)","v":{"$error":"#NUM!"}},null,null,{"$f":"P61","v":2018},{"$f":"'Data Sheet'!K68","v":220.87}]
[null,null,null,null,null,null,null,null,null,null,"FCF",{"$f":"L67-L68","v":841.43999999999994}]
["YoY Sales Growth (%)",null,{"$f":"C54/B54-1","v":0.31764705882352962},0.37799577067669166,0.26031434782873442,0.1072187862388867,6.9901811040802952E-2,0.18434298113946368,0.24183177608717354,0.1266119773033596,9.0373575950924989E-2,null,null,null,null,"Last 5 Years: RM"]
["YoY Op. Profit Growth (%)",null,{"$f":"C57/B57-1","v":0.33622726523435431},0.56299860185870521,0.69167828672156562,0.19395324966173666,0.14252963397160334,1.3327708865378263E-2,8.7555270530258689E-2,0.136298273382784,9.6687849378175095E-2,"Avg Op. Lev",null,null,null,{"$f":"P57","v":2014},{"$f":"'Data Sheet'!G18","v":753.28}]
["Business Risk (Op. Leverage)",null,{"$f":"C71/C70-1","v":5.8493242404447976E-2},0.48943095540677528,1.6570886026483391,0.80894837990054236,1.0389977290918289,-0.92770156594519182,-0.63794968574064692,7.6503789655035792E-2,6.9868580066798636E-2,{"$f":"AVERAGE(C72:K72)","v":0.2926311141653255},null,null,null,{"$f":"P58","v":2015},{"$f":"'Data Sheet'!H18","v":926.45}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P59","v":2016},{"$f":"'Data Sheet'!I18","v":1180.72}]
["Self Sustainable Growth Rate(SSGR)",null,{"$f":"((1-C82) + C81*C66*(1-'Profit & Loss'!B18)) - 1","v":4.9815388640212621E-2},{"$f":"((1-D82) + D81*D66*(1-'Profit & Loss'!C18)) - 1","v":-5.2821737299615368E-3},{"$f":"((1-E82) + E81*E66*(1-'Profit & Loss'!D18)) - 1","v":2.6080447185968136E-2},{"$f":"((1-F82) + F81*F66*(1-'Profit & Loss'!E18)) - 1","v":2.5850493847152656E-2},{"$f":"((1-G82) + G81*G66*(1-'Profit & Loss'!F18)) - 1","v":4.5997692696519987E-3},{"$f":"((1-H82) + H81*H66*(1-'Profit & Loss'!G18)) - 1","v":0.26635780798440045},{"$f":"((1-I82) + I81*I66*(1-'Profit & Loss'!H18)) - 1","v":0.23635322391107572},{"$f":"((1-J82) + J81*J66*(1-'Profit & Loss'!I18)) - 1","v":0.30194347533249921},{"$f":"((1-K82) + K81*K66*(1-'Profit & Loss'!J18)) - 1","v":0.75479646776251763},null,null,null,null,{"$f":"P60","v":2017},{"$f":"'Data Sheet'!J18","v":1494.74}]
["Growth in Sales",null,{"$f":"C54/B54-1","v":0.31764705882352962},0.37799577067669166,0.26031434782873442,0.1072187862388867,6.9901811040802952E-2,0.18434298113946368,0.24183177608717354,0.1266119773033596,9.0373575950924989E-2,"Req. Funds ?",null,null,null,{"$f":"P61","v":2018},{"$f":"'Data Sheet'!K18","v":1703.3}]
["Need for External Funds (Debt/Equity)",null,{"$f":"IF(C75>C74,\"YES\",\"NO\")","v":"YES"},"YES","YES","YES","YES","NO","YES","NO","NO",{"$f":"IF(COUNTIF(C76:K76,\"YES\")>6,\"Yes\",\"No\")","v":"No"}]
["Return on Invested Capital (ROIC)",{"$f":"KeyMetrics!B23","v":5.7127646627898682E-2},{"$f":"KeyMetrics!C23","v":0.13773294890326779},{"$f":"KeyMetrics!D23","v":0.11466558560466664},{"$f":"KeyMetrics!E23","v":0.17741926735130795},{"$f":"KeyMetrics!F23","v":0.17240300624403587},{"$f":"KeyMetrics!G23","v":0.14542268623050336},{"$f":"KeyMetrics!H23","v":0.18066744822736647},{"$f":"KeyMetrics!I23","v":0.12526864253883643},{"$f":"KeyMetrics!J23","v":0.16068297444302926},{"$f":"KeyMetrics!K23","v":0.17380971823093594},null,null,null,null,"Last 5 Years: EBIT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P57","v":2014},{"$f":"KeyMetrics!G57","v":877.11999999999978}]
[null,{"$f":"B53","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","2024-03-31",null,null,null,null,{"$f":"P58","v":2015},{"$f":"KeyMetrics!H57","v":888.81000000000029}]
["Capital Intensity (EBITDA / EBIT)",{"$f":"(B57)/(B57-B60)","v":1.4350260211323136},1.4112116991643453,1.437230583074945,1.4308062039653755,1.4280930855516492,1.4079198703028943,1.2717088037086319,1.2057102942460491,1.1969095981169908,1.1496826533047004,null,null,null,null,{"$f":"P59","v":2016},{"$f":"KeyMetrics!I57","v":966.62999999999954}]
["Net Fixed Assets Turns (Higher is better)",{"$f":"'Profit & Loss'!B4/'Balance Sheet'!B10","v":3.8494934876989868},{"$f":"'Profit & Loss'!C4/'Balance Sheet'!C10","v":1.6152021577955789},{"$f":"'Profit & Loss'!D4/'Balance Sheet'!D10","v":1.3367604441405361},{"$f":"'Profit & Loss'!E4/'Balance Sheet'!E10","v":1.5429231744138368},{"$f":"'Profit & Loss'!F4/'Balance Sheet'!F10","v":1.735301244964105},{"$f":"'Profit & Loss'!G4/'Balance Sheet'!G10","v":1.9231577791374468},{"$f":"'Profit & Loss'!H4/'Balance Sheet'!H10","v":3.7417912371134023},{"$f":"'Profit & Loss'!I4/'Balance Sheet'!I10","v":4.0519384200471968},{"$f":"'Profit & Loss'!J4/'Balance Sheet'!J10","v":4.5619378095206011},{"$f":"'Profit & Loss'!K4/'Balance Sheet'!K10","v":5.4931916265687777},null,null,null,null,{"$f":"P60","v":2017},{"$f":"KeyMetrics!J57","v":1098.3799999999999}]
["Depreciation/NFA (consistency)",{"$f":"B60/'Balance Sheet'!B10","v":0.23482591299906361},{"$f":"C60/'Balance Sheet'!C10","v":9.604358963932827E-2},{"$f":"D60/'Balance Sheet'!D10","v":9.4127511315163934E-2},{"$f":"E60/'Balance Sheet'!E10","v":0.14433220263167704},{"$f":"F60/'Balance Sheet'!F10","v":0.17427225638384877},{"$f":"G60/'Balance Sheet'!G10","v":0.1993457899938815},{"$f":"H60/'Balance Sheet'!H10","v":0.24471649484536084},{"$f":"I60/'Balance Sheet'!I10","v":0.18532419372963255},{"$f":"J60/'Balance Sheet'!J10","v":0.20292198677132814},{"$f":"K60/'Balance Sheet'!K10","v":0.19449129421102238},null,null,null,null,{"$f":"P61","v":2018},{"$f":"KeyMetrics!K57","v":1204.58}]
["Receivable days (Lower is better)",{"$f":"'Balance Sheet'!B22","v":44.446539141972579},{"$f":"'Balance Sheet'!C22","v":41.226671589688507},{"$f":"'Balance Sheet'!D22","v":40.38465285939602},{"$f":"'Balance Sheet'!E22","v":47.466225357557015},{"$f":"'Balance Sheet'!F22","v":15.418721361553567},{"$f":"'Balance Sheet'!G22","v":26.001456144358158},{"$f":"'Balance Sheet'!H22","v":41.843330589641241},{"$f":"'Balance Sheet'!I22","v":60.574196715310244},{"$f":"'Balance Sheet'!J22","v":55.967097943067571},{"$f":"'Balance Sheet'!K22","v":55.537477226497856}]
["Inventory Turnover (Higher is better)",{"$f":"'Balance Sheet'!B20","v":16.2282433159878},{"$f":"'Balance Sheet'!C20","v":19.273491832443799},{"$f":"'Balance Sheet'!D20","v":20.388999255028558},{"$f":"'Balance Sheet'!E20","v":27.576282478347768},{"$f":"'Balance Sheet'!F20","v":22.645518331850973},{"$f":"'Balance Sheet'!G20","v":19.906463137382268},{"$f":"'Balance Sheet'!H20","v":19.620447327522129},{"$f":"'Balance Sheet'!I20","v":15.85603095730179},{"$f":"'Balance Sheet'!J20","v":17.343465824189899},{"$f":"'Balance Sheet'!K20","v":20.054738081224247},null,null,null,null,"Last 5 Years: Profits"]
["Working Capital Cycle",{"$f":"'Balance Sheet'!B22+'Balance Sheet'!B21","v":66.938191065900043},{"$f":"'Balance Sheet'!C22+'Balance Sheet'!C21","v":60.164599556928039},{"$f":"'Balance Sheet'!D22+'Balance Sheet'!D21","v":58.286463312892394},{"$f":"'Balance Sheet'!E22+'Balance Sheet'!E21","v":60.702237147274836},{"$f":"'Balance Sheet'!F22+'Balance Sheet'!F21","v":31.536700850970981},{"$f":"'Balance Sheet'!G22+'Balance Sheet'!G21","v":44.337209586895526},{"$f":"'Balance Sheet'!H22+'Balance Sheet'!H21","v":60.446372299500965},{"$f":"'Balance Sheet'!I22+'Balance Sheet'!I21","v":83.593828865556233},{"$f":"'Balance Sheet'!J22+'Balance Sheet'!J21","v":77.012487814964686},{"$f":"'Balance Sheet'!K22+'Balance Sheet'!K21","v":73.737665058505598},null,null,null,null,{"$f":"P57","v":2014},{"$f":"KeyMetrics!G65","v":265.51}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P58","v":2015},{"$f":"KeyMetrics!H65","v":407.38}]
["Net Fixed Assets",{"$f":"'Balance Sheet'!B10","v":234.94},{"$f":"'Balance Sheet'!C10","v":737.79},{"$f":"'Balance Sheet'!D10","v":1228.44},{"$f":"'Balance Sheet'!E10","v":1341.35},{"$f":"'Balance Sheet'!F10","v":1320.52},{"$f":"'Balance Sheet'!G10","v":1274.82},{"$f":"'Balance Sheet'!H10","v":776},{"$f":"'Balance Sheet'!I10","v":889.9},{"$f":"'Balance Sheet'!J10","v":890.49},{"$f":"'Balance Sheet'!K10","v":806.36},null,null,null,null,{"$f":"P59","v":2016},{"$f":"KeyMetrics!I65","v":381.84}]
["CWIP",{"$f":"'Balance Sheet'!B11","v":1108.26},{"$f":"'Balance Sheet'!C11","v":428.71},{"$f":"'Balance Sheet'!D11","v":91.26},{"$f":"'Balance Sheet'!E11","v":1.1499999999999999},{"$f":"'Balance Sheet'!F11","v":0.01},{"$f":"'Balance Sheet'!G11","v":10.15},{"$f":"'Balance Sheet'!H11","v":2.38},{"$f":"'Balance Sheet'!I11","v":20.62},{"$f":"'Balance Sheet'!J11","v":2.5099999999999998},{"$f":"'Balance Sheet'!K11","v":2.1800000000000002},null,null,null,null,{"$f":"P60","v":2017},{"$f":"KeyMetrics!J65","v":458.01}]
["Share Capital",{"$f":"'Balance Sheet'!B4","v":28.12},{"$f":"'Balance Sheet'!C4","v":28.12},{"$f":"'Balance Sheet'!D4","v":28.12},{"$f":"'Balance Sheet'!E4","v":28.12},{"$f":"'Balance Sheet'!F4","v":28.12},{"$f":"'Balance Sheet'!G4","v":28.12},{"$f":"'Balance Sheet'!H4","v":56.25},{"$f":"'Balance Sheet'!I4","v":56.25},{"$f":"'Balance Sheet'!J4","v":56.25},{"$f":"'Balance Sheet'!K4","v":56.25},null,null,null,null,{"$f":"P61","v":2018},{"$f":"KeyMetrics!K65","v":777.4}]
[]
["Dividend Paid (Div) without DDT",{"$f":"'Data Sheet'!B31","v":2.81},{"$f":"'Data Sheet'!C31","v":5.62},{"$f":"'Data Sheet'!D31","v":7.03},{"$f":"'Data Sheet'!E31","v":5.62},{"$f":"'Data Sheet'!F31","v":5.62},{"$f":"'Data Sheet'!G31","v":7.03},{"$f":"'Data Sheet'!H31","v":7.03},{"$f":"'Data Sheet'!I31","v":7.03},{"$f":"'Data Sheet'!J31","v":7.03},{"$f":"'Data Sheet'!K31","v":7.03},null,null,null,null,"Last 5 Years: Dividends"]
["Dividend Payout (Div/PAT)",{"$f":"B91/B65","v":4.0280963302752291E-2},5.0120395968964594E-2,6.1183637946040037E-2,2.308197798587153E-2,2.0775572067576062E-2,2.6477345486045724E-2,1.7256615445039029E-2,1.8410852713178296E-2,1.5349009846946574E-2,9.0429637252379732E-3,null,null,null,null,{"$f":"P57","v":2014},{"$f":"'Data Sheet'!G31","v":7.03}]
["Retained Earnings (PAT-Div)",{"$f":"B65-B91","v":66.95},106.50999999999999,107.87,237.85999999999999,264.89,258.48,400.35,374.81,450.98,770.37,{"$f":"SUM(B93:K93)","v":3039.0699999999997},null,null,null,{"$f":"P58","v":2015},{"$f":"'Data Sheet'!H31","v":7.03}]
["Cash + Investments (CI+NCI)",{"$f":"'Data Sheet'!B69+'Data Sheet'!B64","v":67.19},{"$f":"'Data Sheet'!C69+'Data Sheet'!C64","v":151.08000000000001},{"$f":"'Data Sheet'!D69+'Data Sheet'!D64","v":107.4},{"$f":"'Data Sheet'!E69+'Data Sheet'!E64","v":104.65},{"$f":"'Data Sheet'!F69+'Data Sheet'!F64","v":79.400000000000006},{"$f":"'Data Sheet'!G69+'Data Sheet'!G64","v":148.71},{"$f":"'Data Sheet'!H69+'Data Sheet'!H64","v":209.51},{"$f":"'Data Sheet'!I69+'Data Sheet'!I64","v":332.46},{"$f":"'Data Sheet'!J69+'Data Sheet'!J64","v":292.54999999999995},{"$f":"'Data Sheet'!K69+'Data Sheet'!K64","v":526.06999999999994},null,null,null,null,{"$f":"P59","v":2016},{"$f":"'Data Sheet'!I31","v":7.03}]
[null,{"$f":"B53","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","2024-03-31",null,null,null,null,{"$f":"P60","v":2017},{"$f":"'Data Sheet'!J31","v":7.03}]
["Total Debt(D)",{"$f":"'Balance Sheet'!B6","v":733.64},{"$f":"'Balance Sheet'!C6","v":735.41},{"$f":"'Balance Sheet'!D6","v":721.14},{"$f":"'Balance Sheet'!E6","v":770.4},{"$f":"'Balance Sheet'!F6","v":758.21},{"$f":"'Balance Sheet'!G6","v":874.54},{"$f":"'Balance Sheet'!H6","v":764.37},{"$f":"'Balance Sheet'!I6","v":1463.54},{"$f":"'Balance Sheet'!J6","v":652.05999999999995},{"$f":"'Balance Sheet'!K6","v":1262.43},null,null,null,null,{"$f":"P61","v":2018},{"$f":"'Data Sheet'!K31","v":7.03}]
["Total Equity(E)",{"$f":"'Balance Sheet'!B4+'Balance Sheet'!B5","v":788.47},{"$f":"'Balance Sheet'!C4+'Balance Sheet'!C5","v":698.62},{"$f":"'Balance Sheet'!D4+'Balance Sheet'!D5","v":805.42},{"$f":"'Balance Sheet'!E4+'Balance Sheet'!E5","v":1039.26},{"$f":"'Balance Sheet'!F4+'Balance Sheet'!F5","v":1302.32},{"$f":"'Balance Sheet'!G4+'Balance Sheet'!G5","v":1552.1599999999999},{"$f":"'Balance Sheet'!H4+'Balance Sheet'!H5","v":1959.32},{"$f":"'Balance Sheet'!I4+'Balance Sheet'!I5","v":2319.21},{"$f":"'Balance Sheet'!J4+'Balance Sheet'!J5","v":2770.7},{"$f":"'Balance Sheet'!K4+'Balance Sheet'!K5","v":3554.15}]
["D/E",{"$f":"B96/B97","v":0.9304602584752748},1.0526609601786379,0.89535894316009046,0.74129669187691238,0.58219945942625473,0.56343418204308837,0.39012004164710207,0.63105109067311715,0.2353412495037355,0.3551988520461995,null,null,null,null,"Last 5 Years: Op CF"]
["Cost of Funds",0.12,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P57","v":2014},{"$f":"KeyMetrics!G104","v":230.62}]
["Interest Outgo (Rs Cr) (Calculated)",{"$f":"$B$99*B96","v":88.036799999999999},88.249199999999988,86.536799999999999,92.447999999999993,90.985200000000006,104.94479999999999,91.724400000000003,175.62479999999999,78.247199999999992,151.49160000000001,{"$f":"SUM(B100:K100)","v":1048.2888000000003},null,null,null,{"$f":"P58","v":2015},{"$f":"KeyMetrics!H104","v":-75.59}]
["Interest Coverage (Op/Int. Outgo)",{"$f":"B57/B100","v":2.0672037148101698},2.7556057165390744,4.3922354420315983,6.9551531671858768,8.4376360111314792,8.3579176862502944,9.6900061488546143,5.5039493283408696,14.037307405249006,7.95146397556036,null,null,null,null,{"$f":"P59","v":2016},{"$f":"KeyMetrics!I104","v":-336.44}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P60","v":2017},{"$f":"KeyMetrics!J104","v":1194.1300000000001}]
[null,{"$f":"'Cash Flow'!B3","v":"2015-03-31"},{"$f":"'Cash Flow'!C3","v":"2016-03-31"},{"$f":"'Cash Flow'!D3","v":"2017-03-31"},{"$f":"'Cash Flow'!E3","v":"2018-03-31"},{"$f":"'Cash Flow'!F3","v":"2019-03-31"},{"$f":"'Cash Flow'!G3","v":"2020-03-31"},{"$f":"'Cash Flow'!H3","v":"2021-03-31"},{"$f":"'Cash Flow'!I3","v":"2022-03-31"},{"$f":"'Cash Flow'!J3","v":"2023-03-31"},{"$f":"'Cash Flow'!K3","v":"2024-03-31"},"Total 10 Yrs ",null,null,null,{"$f":"P61","v":2018},{"$f":"KeyMetrics!K104","v":-315.64}]
[{"$f":"'Cash Flow'!A4","v":"Cash from Operating Activity"},{"$f":"'Cash Flow'!B4","v":78.400000000000006},{"$f":"'Cash Flow'!C4","v":245.85},{"$f":"'Cash Flow'!D4","v":365.67},{"$f":"'Cash Flow'!E4","v":220.57},{"$f":"'Cash Flow'!F4","v":255.91},{"$f":"'Cash Flow'!G4","v":230.62},{"$f":"'Cash Flow'!H4","v":-75.59},{"$f":"'Cash Flow'!I4","v":-336.44},{"$f":"'Cash Flow'!J4","v":1194.1300000000001},{"$f":"'Cash Flow'!K4","v":-315.64},{"$f":"SUM(B104:K104)","v":1863.48}]
[{"$f":"'Cash Flow'!A5","v":"Cash from Investing Activity"},{"$f":"'Cash Flow'!B5","v":-548.95000000000005},{"$f":"'Cash Flow'!C5","v":-243.99},{"$f":"'Cash Flow'!D5","v":-249.63},{"$f":"'Cash Flow'!E5","v":-163.28},{"$f":"'Cash Flow'!F5","v":-183.5},{"$f":"'Cash Flow'!G5","v":-202.09},{"$f":"'Cash Flow'!H5","v":260.19},{"$f":"'Cash Flow'!I5","v":-408.48},{"$f":"'Cash Flow'!J5","v":66.81},{"$f":"'Cash Flow'!K5","v":-15.08},{"$f":"SUM(B105:K105)","v":-1688},null,null,null,"Debt: Equity"]
[{"$f":"'Cash Flow'!A6","v":"Cash from Financing Activity"},{"$f":"'Cash Flow'!B6","v":449.83},{"$f":"'Cash Flow'!C6","v":1.47},{"$f":"'Cash Flow'!D6","v":-123.61},{"$f":"'Cash Flow'!E6","v":-37.53},{"$f":"'Cash Flow'!F6","v":-107.5},{"$f":"'Cash Flow'!G6","v":2.2200000000000002},{"$f":"'Cash Flow'!H6","v":-97.83},{"$f":"'Cash Flow'!I6","v":764.87},{"$f":"'Cash Flow'!J6","v":-1217.3499999999999},{"$f":"'Cash Flow'!K6","v":496.13},{"$f":"SUM(B106:K106)","v":130.70000000000005},null,null,null,{"$f":"CONCATENATE(\"Debt FY\",P102)","v":"Debt FY2017"},{"$f":"KeyMetrics!J96","v":652.05999999999995}]
[{"$f":"'Cash Flow'!A7","v":"Net Cash Flow"},{"$f":"'Cash Flow'!B7","v":-20.72},{"$f":"'Cash Flow'!C7","v":3.33},{"$f":"'Cash Flow'!D7","v":-7.57},{"$f":"'Cash Flow'!E7","v":19.760000000000002},{"$f":"'Cash Flow'!F7","v":-35.090000000000003},{"$f":"'Cash Flow'!G7","v":30.75},{"$f":"'Cash Flow'!H7","v":86.77},{"$f":"'Cash Flow'!I7","v":19.940000000000001},{"$f":"'Cash Flow'!J7","v":43.6},{"$f":"'Cash Flow'!K7","v":165.4},{"$f":"SUM(B107:K107)","v":306.16999999999996},null,null,null,{"$f":"CONCATENATE(\"Debt FY\",P103)","v":"Debt FY2018"},{"$f":"KeyMetrics!K96","v":1262.43}]
["Cash & Eq at end of Year",{"$f":"'Data Sheet'!B69","v":43.55},{"$f":"'Data Sheet'!C69","v":45.21},{"$f":"'Data Sheet'!D69","v":33.81},{"$f":"'Data Sheet'!E69","v":51.98},{"$f":"'Data Sheet'!F69","v":27.47},{"$f":"'Data Sheet'!G69","v":82.87},{"$f":"'Data Sheet'!H69","v":147.84},{"$f":"'Data Sheet'!I69","v":259.2},{"$f":"'Data Sheet'!J69","v":220.2},{"$f":"'Data Sheet'!K69","v":410.89},null,null,null,null,{"$f":"CONCATENATE(\"Equity FY\",P102)","v":"Equity FY2017"},{"$f":"KeyMetrics!J97","v":2770.7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Equity FY\",P103)","v":"Equity FY2018"},{"$f":"KeyMetrics!K97","v":3554.15}]
["Market Cap",{"$f":"'Data Sheet'!B90*'Data Sheet'!B93","v":1193.6879999999999},{"$f":"'Data Sheet'!C90*'Data Sheet'!C93","v":1431.414},{"$f":"'Data Sheet'!D90*'Data Sheet'!D93","v":2710.2055999999998},{"$f":"'Data Sheet'!E90*'Data Sheet'!E93","v":3993.04},{"$f":"'Data Sheet'!F90*'Data Sheet'!F93","v":3674.7216000000003},{"$f":"'Data Sheet'!G90*'Data Sheet'!G93","v":2762.79},{"$f":"'Data Sheet'!H90*'Data Sheet'!H93","v":6000.808},{"$f":"'Data Sheet'!I90*'Data Sheet'!I93","v":7990.2979999999998},{"$f":"'Data Sheet'!J90*'Data Sheet'!J93","v":7134.0439999999999},{"$f":"'Data Sheet'!K90*'Data Sheet'!K93","v":6925.9560000000001}]
["P/B",{"$f":"B110/B97","v":1.5139295090491709},{"$f":"C110/C97","v":2.04891643525808},3.3649594000645626,3.8421954082712699,2.8216733214570922,1.7799646943614063,3.062699303840108,3.445267138379017,2.5748164723716029,1.9486954686774616]

{"sheet":"Charts","index":7,"n_rows":12,"n_cols":23,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,1],[9,15,9,16],[10,15,10,16],[11,15,11,16],[9,19,9,21],[10,19,10,21],[11,19,11,21]]}
[{"$f":"'Data Sheet'!B1","v":"KNR CONSTRUCTIONS LTD"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"KeyMetrics!F53","v":"2019-03-31"},{"$f":"KeyMetrics!G53","v":"2020-03-31"},{"$f":"KeyMetrics!H53","v":"2021-03-31"},{"$f":"KeyMetrics!I53","v":"2022-03-31"},{"$f":"KeyMetrics!J53","v":"2023-03-31"},{"$f":"KeyMetrics!K53","v":"2024-03-31"},"Growth (x)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sales (INR Cr)",{"$f":"KeyMetrics!F54","v":2291.5},{"$f":"KeyMetrics!G54","v":2451.6799999999998},{"$f":"KeyMetrics!H54","v":2903.63},{"$f":"KeyMetrics!I54","v":3605.82},{"$f":"KeyMetrics!J54","v":4062.36},{"$f":"KeyMetrics!K54","v":4429.49},{"$f":"V3/Q3","v":1.9330089461051712}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAT (INR Cr)",{"$f":"KeyMetrics!F65","v":270.51},{"$f":"KeyMetrics!G65","v":265.51},{"$f":"KeyMetrics!H65","v":407.38},{"$f":"KeyMetrics!I65","v":381.84},{"$f":"KeyMetrics!J65","v":458.01},{"$f":"KeyMetrics!K65","v":777.4},{"$f":"V4/Q4","v":2.8738309119810728}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ROE (%)",{"$f":"Q4/KeyMetrics!F97","v":0.20771392591682536},{"$f":"R4/KeyMetrics!G97","v":0.17105839604164519},{"$f":"S4/KeyMetrics!H97","v":0.20791907396443665},{"$f":"T4/KeyMetrics!I97","v":0.16464227042829238},{"$f":"U4/KeyMetrics!J97","v":0.16530479662179234},{"$f":"V4/KeyMetrics!K97","v":0.21873021678882432},1.053035880109503]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PE (x)",{"$f":"Q8/Q4","v":13.584420538981925},10.405596776015969,14.730246943885316,20.925775193798451,15.576175192681383,8.9091278621044516,0.65583422101360678]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PB (x)",{"$f":"KeyMetrics!F111","v":2.8216733214570922},{"$f":"KeyMetrics!G111","v":1.7799646943614063},{"$f":"KeyMetrics!H111","v":3.062699303840108},{"$f":"KeyMetrics!I111","v":3.445267138379017},{"$f":"KeyMetrics!J111","v":2.5748164723716029},{"$f":"KeyMetrics!K111","v":1.9486954686774616},0.69061696613099388]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mcap (INR Cr)",{"$f":"KeyMetrics!F110","v":3674.7216000000003},{"$f":"KeyMetrics!G110","v":2762.79},{"$f":"KeyMetrics!H110","v":6000.808},{"$f":"KeyMetrics!I110","v":7990.2979999999998},{"$f":"KeyMetrics!J110","v":7134.0439999999999},{"$f":"KeyMetrics!K110","v":6925.9560000000001},1.8847566574839301]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10 Years","3 Years","Total Retained Earnings (10 Yrs)",null,null,{"$f":"KeyMetrics!L93","v":3039.0699999999997}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OCF as part of Sales",null,{"$f":"KeyMetrics!L104/KeyMetrics!L54","v":7.2928101551759161E-2},{"$f":"SUM(KeyMetrics!I104:K104)/SUM(KeyMetrics!I54:K54)","v":4.4806148622007387E-2},"Total Mcap Increase (10 Yrs)",null,null,{"$f":"Customization!C5","v":5732.268}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OCF as part of Profits",null,{"$f":"KeyMetrics!L104/KeyMetrics!L65","v":0.60094423590418322},{"$f":"SUM(KeyMetrics!I104:K104)/SUM(KeyMetrics!I65:K65)","v":0.33516772298655129},"Value created per INR of RE",null,null,{"$f":"W11/W10","v":1.8861914993731637}]

{"sheet":"Forecast","index":8,"n_rows":39,"n_cols":19,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
[null,"Annual"]
[null,"Growth%",null,{"$f":"D10/C10-1","v":0.31764705882352962},0.37799577067669166,0.26031434782873442,0.1072187862388867,6.9901811040802952E-2,0.18434298113946368,0.24183177608717354,0.1266119773033596,9.0373575950924989E-2,0.15,0.15,{"$f":"MEDIAN(L2:N2)","v":0.15},{"$f":"MEDIAN(M2:O2)","v":0.15},{"$f":"MEDIAN(N2:P2)","v":0.15}]
[null,"Exp as Sales%",{"$f":"C11/C10","v":0.85977443609022564},0.85539742212674541,0.83895306705315653,0.78286142249710089,0.76540693868644993,0.74589261241271299,0.7592978444223264,0.77766222384922168,0.77410175366043388,0.7634603532235088,0.89000000000000012,{"$f":"1-N4","v":0.88800000000000001},{"$f":"1-O4","v":0.88700000000000001},{"$f":"1-P4","v":0.88600000000000001},{"$f":"1-Q4","v":0.88500000000000001}]
[null,"OPM %",{"$f":"C12/C10","v":0.14022556390977436},0.14460257787325459,0.16104693294684344,0.21713857750289906,0.23459306131355004,0.25410738758728701,0.24070215557767355,0.22233777615077835,0.22589824633956612,0.2365396467764912,0.11,0.112,0.113,0.114,0.115]
[null,"Tax %",{"$f":"C17/C16","v":-3.9177277179236044E-3},-0.24265602483095003,6.6111794192755133E-2,-3.1985278009025982E-3,9.3959501983855512E-2,0.21120596665331154,0.26349102522172418,0.34965742482871243,0.35499449541284406,0.21094909348990254,0.35,0.35,0.35,0.35,0.35]
[null,"NPM %",{"$f":"C18/C10","v":7.7134011499336588E-2},{"$f":"D18/D10","v":9.4094052094522013E-2},6.9970099809393893E-2,0.1176459219172787,0.11804931267728562,0.10829716765646415,0.14030024486590922,0.10589546899179658,0.11274480843647534,0.17550553223960322,5.5637956995147245E-2,5.9474310472172581E-2,6.2229222592225325E-2,6.3787157145830109E-2,6.5269088052207713E-2]
[]
[]
[null,"Narration",{"$f":"'Profit & Loss'!B3","v":"2015-03-31"},{"$f":"'Profit & Loss'!C3","v":"2016-03-31"},{"$f":"'Profit & Loss'!D3","v":"2017-03-31"},{"$f":"'Profit & Loss'!E3","v":"2018-03-31"},{"$f":"'Profit & Loss'!F3","v":"2019-03-31"},{"$f":"'Profit & Loss'!G3","v":"2020-03-31"},{"$f":"'Profit & Loss'!H3","v":"2021-03-31"},{"$f":"'Profit & Loss'!I3","v":"2022-03-31"},{"$f":"'Profit & Loss'!J3","v":"2023-03-31"},{"$f":"'Profit & Loss'!K3","v":"2024-03-31"},{"$f":"L9+365","v":"2025-03-31"},{"$f":"M9+365","v":"2026-03-31"},"2027-03-31","2028-03-30","2029-03-30",null,"5 Yr Cagr"]
[null,"Sales",{"$f":"'Profit & Loss'!B4","v":904.4},{"$f":"'Profit & Loss'!C4","v":1191.68},{"$f":"'Profit & Loss'!D4","v":1642.13},{"$f":"'Profit & Loss'!E4","v":2069.6},{"$f":"'Profit & Loss'!F4","v":2291.5},{"$f":"'Profit & Loss'!G4","v":2451.6799999999998},{"$f":"'Profit & Loss'!H4","v":2903.63},{"$f":"'Profit & Loss'!I4","v":3605.82},{"$f":"'Profit & Loss'!J4","v":4062.36},{"$f":"'Profit & Loss'!K4","v":4429.49},{"$f":"L10*(1+M2)","v":5093.9134999999997},{"$f":"M10*(1+N2)","v":5858.0005249999995},6736.7006037499987,7747.2056943124981,8909.2865484593713,null,{"$f":"RATE(5,,-L10,Q10,1,)","v":0.15}]
[null,"Expenses",{"$f":"'Profit & Loss'!B5","v":777.58},{"$f":"'Profit & Loss'!C5","v":1019.36},{"$f":"'Profit & Loss'!D5","v":1377.67},{"$f":"'Profit & Loss'!E5","v":1620.21},{"$f":"'Profit & Loss'!F5","v":1753.93},{"$f":"'Profit & Loss'!G5","v":1828.69},{"$f":"'Profit & Loss'!H5","v":2204.7199999999998},{"$f":"'Profit & Loss'!I5","v":2804.1100000000006},{"$f":"'Profit & Loss'!J5","v":3144.6800000000003},{"$f":"'Profit & Loss'!K5","v":3381.74},{"$f":"M10-M12","v":4533.5830150000002},{"$f":"N10-N12","v":5201.9044661999997},5975.4534355262485,6864.0242451608729,7884.7185953865437,null,{"$f":"RATE(5,,-L11,Q11,1,)","v":0.18448399470833257}]
[null,"Operating Profit",{"$f":"'Profit & Loss'!B6","v":126.81999999999994},{"$f":"'Profit & Loss'!C6","v":172.32000000000005},{"$f":"'Profit & Loss'!D6","v":264.46000000000004},{"$f":"'Profit & Loss'!E6","v":449.38999999999987},{"$f":"'Profit & Loss'!F6","v":537.56999999999994},{"$f":"'Profit & Loss'!G6","v":622.98999999999978},{"$f":"'Profit & Loss'!H6","v":698.91000000000031},{"$f":"'Profit & Loss'!I6","v":801.70999999999958},{"$f":"'Profit & Loss'!J6","v":917.67999999999984},{"$f":"'Profit & Loss'!K6","v":1047.75},{"$f":"M4*M10","v":560.33048499999995},{"$f":"N4*N10","v":656.09605879999992},761.2471682237499,883.18144915162486,1024.5679530728278,null,-4.4648016635337774E-3]
[null,"Other Income",{"$f":"'Profit & Loss'!B7","v":13.62},{"$f":"'Profit & Loss'!C7","v":45.75},{"$f":"'Profit & Loss'!D7","v":29.57},{"$f":"'Profit & Loss'!E7","v":54.94},{"$f":"'Profit & Loss'!F7","v":74.760000000000005},{"$f":"'Profit & Loss'!G7","v":66.39},{"$f":"'Profit & Loss'!H7","v":143.99},{"$f":"'Profit & Loss'!I7","v":77.73},{"$f":"'Profit & Loss'!J7","v":97.67},{"$f":"'Profit & Loss'!K7","v":144.69},{"$f":"L13*1.1","v":159.15900000000002},{"$f":"M13*1.1","v":175.07490000000004},192.58239000000006,211.84062900000009,233.02469190000011,null,9.9999999999998951E-2]
[null,"Depreciation",{"$f":"'Profit & Loss'!B8","v":55.17},{"$f":"'Profit & Loss'!C8","v":70.86},{"$f":"'Profit & Loss'!D8","v":115.63},{"$f":"'Profit & Loss'!E8","v":193.6},{"$f":"'Profit & Loss'!F8","v":230.13},{"$f":"'Profit & Loss'!G8","v":254.13},{"$f":"'Profit & Loss'!H8","v":189.9},{"$f":"'Profit & Loss'!I8","v":164.92},{"$f":"'Profit & Loss'!J8","v":180.7},{"$f":"'Profit & Loss'!K8","v":156.83000000000001},{"$f":"L14*1.1","v":172.51300000000003},189.76430000000005,208.74073000000007,229.61480300000011,252.57628330000014,null,9.999999999999902E-2]
[null,"Interest",{"$f":"'Profit & Loss'!B9","v":13.8},{"$f":"'Profit & Loss'!C9","v":57},{"$f":"'Profit & Loss'!D9","v":72.67},{"$f":"'Profit & Loss'!E9","v":82.5},{"$f":"'Profit & Loss'!F9","v":89.84},{"$f":"'Profit & Loss'!G9","v":110.78},{"$f":"'Profit & Loss'!H9","v":133.21},{"$f":"'Profit & Loss'!I9","v":151.13999999999999},{"$f":"'Profit & Loss'!J9","v":153.4},{"$f":"'Profit & Loss'!K9","v":105.67},{"$f":"L15*1.05","v":110.95350000000001},{"$f":"M15*0.95","v":105.40582500000001},{"$f":"N15*0.95","v":100.13553375000001},{"$f":"O15*1.05","v":105.14231043750002},110.39942595937502,null,8.7952335100217986E-3]
[null,"Profit before tax",{"$f":"'Profit & Loss'!B10","v":71.47},{"$f":"'Profit & Loss'!C10","v":90.21},{"$f":"'Profit & Loss'!D10","v":105.73},{"$f":"'Profit & Loss'!E10","v":228.23},{"$f":"'Profit & Loss'!F10","v":292.36},{"$f":"'Profit & Loss'!G10","v":324.47000000000003},{"$f":"'Profit & Loss'!H10","v":519.79},{"$f":"'Profit & Loss'!I10","v":563.38},{"$f":"'Profit & Loss'!J10","v":681.25},{"$f":"'Profit & Loss'!K10","v":929.94},{"$f":"M12+M13-M14-M15","v":436.02298499999989},{"$f":"N12+N13-N14-N15","v":536.0008337999999},644.95329447374979,760.26496471412486,894.61693571345279,null,{"$f":"RATE(5,,-L16,Q16,1,)","v":-7.7149748375463607E-3}]
[null,"Tax",{"$f":"'Profit & Loss'!B11","v":-0.28000000000000003},{"$f":"'Profit & Loss'!C11","v":-21.89},{"$f":"'Profit & Loss'!D11","v":6.99},{"$f":"'Profit & Loss'!E11","v":-0.73},{"$f":"'Profit & Loss'!F11","v":27.47},{"$f":"'Profit & Loss'!G11","v":68.53},{"$f":"'Profit & Loss'!H11","v":136.96},{"$f":"'Profit & Loss'!I11","v":196.99},{"$f":"'Profit & Loss'!J11","v":241.84},{"$f":"'Profit & Loss'!K11","v":196.17},{"$f":"M16*M5","v":152.60804474999995},{"$f":"N16*N5","v":187.60029182999995},225.7336530658124,266.09273764994367,313.11592749970845,null,9.8030777742159625E-2]
[null,"Net profit",{"$f":"'Profit & Loss'!B12","v":69.760000000000005},{"$f":"'Profit & Loss'!C12","v":112.13},{"$f":"'Profit & Loss'!D12","v":114.9},{"$f":"'Profit & Loss'!E12","v":243.48},{"$f":"'Profit & Loss'!F12","v":270.51},{"$f":"'Profit & Loss'!G12","v":265.51},{"$f":"'Profit & Loss'!H12","v":407.38},{"$f":"'Profit & Loss'!I12","v":381.84},{"$f":"'Profit & Loss'!J12","v":458.01},{"$f":"'Profit & Loss'!K12","v":777.4},{"$f":"M16-M17","v":283.41494024999997},{"$f":"N16-N17","v":348.40054196999995},419.21964140793739,494.17222706418119,581.5010082137444,null,-5.6414655013460407E-2]
[null,"EPS",{"$f":"'Profit & Loss'!B13","v":2.4825622775800711},{"$f":"'Profit & Loss'!C13","v":3.9903914590747327},{"$f":"'Profit & Loss'!D13","v":4.0860597439544808},{"$f":"'Profit & Loss'!E13","v":8.6586059743954475},{"$f":"'Profit & Loss'!F13","v":9.6198435277382632},{"$f":"'Profit & Loss'!G13","v":9.4420341394025602},{"$f":"'Profit & Loss'!H13","v":14.487197724039829},{"$f":"'Profit & Loss'!I13","v":13.578947368421051},{"$f":"'Profit & Loss'!J13","v":16.287695590327168},{"$f":"'Profit & Loss'!K13","v":27.645803698435277},{"$f":"M18/$M$23","v":10.077526660453996},{"$f":"N18/$M$23","v":12.388252175845894},14.906402284748479,17.5715288287284,20.676721940578389,null,-5.6437888679631336E-2]
[null,"Price to earning",{"$f":"'Profit & Loss'!B14","v":17.111353211009174},{"$f":"'Profit & Loss'!C14","v":12.765664853295283},{"$f":"'Profit & Loss'!D14","v":23.587516100957352},{"$f":"'Profit & Loss'!E14","v":16.399868572367343},{"$f":"'Profit & Loss'!F14","v":13.584420538981925},{"$f":"'Profit & Loss'!G14","v":10.405596776015969},{"$f":"'Profit & Loss'!H14","v":14.730246943885316},{"$f":"'Profit & Loss'!I14","v":20.925775193798451},{"$f":"'Profit & Loss'!J14","v":15.576175192681383},{"$f":"'Profit & Loss'!K14","v":8.9091278621044516},{"$f":"M21/M19","v":33.877360140332271},20,20,20,20]
[null,"Price",{"$f":"'Profit & Loss'!B15","v":42.48},{"$f":"'Profit & Loss'!C15","v":50.94},{"$f":"'Profit & Loss'!D15","v":96.38},{"$f":"'Profit & Loss'!E15","v":142},{"$f":"'Profit & Loss'!F15","v":130.68},{"$f":"'Profit & Loss'!G15","v":98.25},{"$f":"'Profit & Loss'!H15","v":213.4},{"$f":"'Profit & Loss'!I15","v":284.14999999999998},{"$f":"'Profit & Loss'!J15","v":253.7},{"$f":"'Profit & Loss'!K15","v":246.3},{"$f":"'Profit & Loss'!L15","v":341.4},{"$f":"N20*N19","v":247.76504351691787},{"$f":"O20*O19","v":298.12804569496956},351.43057657456802,413.53443881156778,null,0.10919896138864045]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Nosh",{"$f":"'Data Sheet'!B6","v":28.123462214411251}]
[null,"Quarterly"]
[null,"QoQ Sales",null,{"$f":"D29/C29-1","v":-0.11037211117059398},{"$f":"E29/D29-1","v":-1.9174868682747759E-2},-9.0178339312639744E-2,0.42334815356657107,-0.21224093212240924,5.8541110272981145E-2,-4.086860224372868E-2,0.41966446120018874,-0.30339462517680338,0.3]
[null,"Tax %",null,{"$f":"D36/D35","v":0.26700031776294886},{"$f":"E36/E35","v":0.46345315904139439},0.420322702498516,0.24157633363592673,0.23232080681954617,0.19513296821184575,0.17222256078981046,0.22420409323479248,0.23521308652604389,{"$f":"MEDIAN(I26:L26)","v":0.20966853072331912}]
[null,"Quarterly","Contribution",{"$f":"D29/$K$10","v":0.24134985574887505},{"$f":"E29/$K$10","v":0.23672200395829024},0.21537480676257148,0.30655333353026315,{"$f":"H29/$L$10","v":0.22147470702044705},{"$f":"I29/$L$10","v":0.23444008226680726},0.22485884379465809,0.3192241093218407]
[null,"Narration",{"$f":"Quarters!B3","v":"2022-03-31"},{"$f":"Quarters!C3","v":"2022-06-30"},{"$f":"Quarters!D3","v":"2022-09-30"},{"$f":"Quarters!E3","v":"2022-12-31"},{"$f":"Quarters!F3","v":"2023-03-31"},{"$f":"Quarters!G3","v":"2023-06-30"},{"$f":"Quarters!H3","v":"2023-09-30"},{"$f":"Quarters!I3","v":"2023-12-31"},{"$f":"Quarters!J3","v":"2024-03-31"},{"$f":"Quarters!K3","v":"2024-06-30"},{"$f":"L28+90","v":"2024-09-28"},"YoY","QoQ"]
[null,"Sales",{"$f":"Quarters!B4","v":1102.0899999999999},{"$f":"Quarters!C4","v":980.45},{"$f":"Quarters!D4","v":961.65},{"$f":"Quarters!E4","v":874.93},{"$f":"Quarters!F4","v":1245.33},{"$f":"Quarters!G4","v":981.02},{"$f":"Quarters!H4","v":1038.45},{"$f":"Quarters!I4","v":996.01},{"$f":"Quarters!J4","v":1414},{"$f":"Quarters!K4","v":985},{"$f":"L29*(1+M25)","v":1280.5},{"$f":"L29/H29-1","v":4.0570018959857901E-3},{"$f":"L29/K29-1","v":-0.30339462517680338}]
[null,"Expenses",{"$f":"Quarters!B5","v":823.22},{"$f":"Quarters!C5","v":769.19},{"$f":"Quarters!D5","v":698.36},{"$f":"Quarters!E5","v":678.14},{"$f":"Quarters!F5","v":999.36},{"$f":"Quarters!G5","v":765.28},{"$f":"Quarters!H5","v":806.86},{"$f":"Quarters!I5","v":770.1},{"$f":"Quarters!J5","v":1039.48},{"$f":"Quarters!K5","v":706.4},{"$f":"M29-M31","v":941.33956152758128},{"$f":"L30/H30-1","v":-7.6939159523311762E-2},{"$f":"L30/K30-1","v":-0.32042944549197683}]
[null,"Operating Profit",{"$f":"Quarters!B6","v":278.87},{"$f":"Quarters!C6","v":211.26},{"$f":"Quarters!D6","v":263.29000000000002},{"$f":"Quarters!E6","v":196.79},{"$f":"Quarters!F6","v":245.97},{"$f":"Quarters!G6","v":215.74},{"$f":"Quarters!H6","v":231.59},{"$f":"Quarters!I6","v":225.91},{"$f":"Quarters!J6","v":374.52},{"$f":"Quarters!K6","v":278.60000000000002},{"$f":"M29*M39","v":339.16043847241866},0.29136924075275794,-0.25611449321798563]
[null,"Other Income",{"$f":"Quarters!B7","v":19.829999999999998},{"$f":"Quarters!C7","v":10.119999999999999},{"$f":"Quarters!D7","v":9.93},{"$f":"Quarters!E7","v":68.38},{"$f":"Quarters!F7","v":10.1},{"$f":"Quarters!G7","v":7.58},{"$f":"Quarters!H7","v":5.34},{"$f":"Quarters!I7","v":6.52},{"$f":"Quarters!J7","v":125.25},{"$f":"Quarters!K7","v":20.9},{"$f":"AVERAGE(I32:L32)","v":39.502500000000005},1.7572559366754614,-0.83313373253493017]
[null,"Depreciation",{"$f":"Quarters!B8","v":47.82},{"$f":"Quarters!C8","v":40.97},{"$f":"Quarters!D8","v":45.01},{"$f":"Quarters!E8","v":46.48},{"$f":"Quarters!F8","v":48.24},{"$f":"Quarters!G8","v":36.4},{"$f":"Quarters!H8","v":39.21},{"$f":"Quarters!I8","v":40.68},{"$f":"Quarters!J8","v":40.54},{"$f":"Quarters!K8","v":30.07},{"$f":"I33*1.32","v":51.757200000000005},-0.17390109890109884,-0.25826344351258013]
[null,"Interest",{"$f":"Quarters!B9","v":43.31},{"$f":"Quarters!C9","v":54.53},{"$f":"Quarters!D9","v":44.61},{"$f":"Quarters!E9","v":33.380000000000003},{"$f":"Quarters!F9","v":20.56},{"$f":"Quarters!G9","v":20.34},{"$f":"Quarters!H9","v":20.61},{"$f":"Quarters!I9","v":27.66},{"$f":"Quarters!J9","v":37.07},{"$f":"Quarters!K9","v":37.130000000000003},8,0.82546705998033443,1.6185594820610216E-3]
[null,"Profit before tax",{"$f":"Quarters!B10","v":207.57},{"$f":"Quarters!C10","v":125.88},{"$f":"Quarters!D10","v":183.6},{"$f":"Quarters!E10","v":185.31},{"$f":"Quarters!F10","v":187.27},{"$f":"Quarters!G10","v":166.58},{"$f":"Quarters!H10","v":177.11},{"$f":"Quarters!I10","v":164.09},{"$f":"Quarters!J10","v":422.16},{"$f":"Quarters!K10","v":232.3},{"$f":"M31+M32-M33-M34","v":318.90573847241865},0.39452515307960145,-0.4497346977449308]
[null,"Tax",{"$f":"Quarters!B11","v":67.86},{"$f":"Quarters!C11","v":33.61},{"$f":"Quarters!D11","v":85.09},{"$f":"Quarters!E11","v":77.89},{"$f":"Quarters!F11","v":45.24},{"$f":"Quarters!G11","v":38.700000000000003},{"$f":"Quarters!H11","v":34.56},{"$f":"Quarters!I11","v":28.26},{"$f":"Quarters!J11","v":94.65},{"$f":"Quarters!K11","v":54.64},{"$f":"M26*M35","v":66.864497624747088},0.41188630490956069,-0.42271526677231908]
[null,"Net profit",{"$f":"Quarters!B12","v":139.16},{"$f":"Quarters!C12","v":89.61},{"$f":"Quarters!D12","v":115.37},{"$f":"Quarters!E12","v":105.76},{"$f":"Quarters!F12","v":147.27000000000001},{"$f":"Quarters!G12","v":137.11000000000001},{"$f":"Quarters!H12","v":147.38},{"$f":"Quarters!I12","v":139.61000000000001},{"$f":"Quarters!J12","v":353.3},{"$f":"Quarters!K12","v":172.58},{"$f":"M35-M36","v":252.04124084767156},0.25869739625118515,-0.51151995471270872]
[null,null,{"$f":"Quarters!B13","v":0},{"$f":"Quarters!C13","v":0},{"$f":"Quarters!D13","v":0},{"$f":"Quarters!E13","v":0},{"$f":"Quarters!F13","v":0},{"$f":"Quarters!G13","v":0},{"$f":"Quarters!H13","v":0},{"$f":"Quarters!I13","v":0},{"$f":"Quarters!J13","v":0},{"$f":"Quarters!K13","v":0}]
[null,"OPM",{"$f":"Quarters!B14","v":0.25303741073778008},{"$f":"Quarters!C14","v":0.2154724871232597},{"$f":"Quarters!D14","v":0.27378984037851611},{"$f":"Quarters!E14","v":0.22492085081092203},{"$f":"Quarters!F14","v":0.19751391197513912},{"$f":"Quarters!G14","v":0.21991396709547206},{"$f":"Quarters!H14","v":0.2230150705378208},{"$f":"Quarters!I14","v":0.22681499181735124},{"$f":"Quarters!J14","v":0.26486562942008485},{"$f":"Quarters!K14","v":0.28284263959390865},{"$f":"K39","v":0.26486562942008485},0.28615132239925956,6.7872189431236851E-2]