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

{"sheet":"Profit & Loss","index":0,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Data Sheet'!B1","v":"FIRSTSOURCE SOLUTIONS LTD"},null,null,null,null,null,null,{"$f":"UPDATE","v":""},null,null,null,null,"SCREENER.IN"]
[]
["Narration",{"$f":"'Data Sheet'!B16","v":"2007-03-31"},{"$f":"'Data Sheet'!C16","v":"2008-03-31"},{"$f":"'Data Sheet'!D16","v":"2009-03-31"},{"$f":"'Data Sheet'!E16","v":"2010-03-31"},{"$f":"'Data Sheet'!F16","v":"2011-03-31"},{"$f":"'Data Sheet'!G16","v":"2012-03-31"},{"$f":"'Data Sheet'!H16","v":"2013-03-31"},{"$f":"'Data Sheet'!I16","v":"2014-03-31"},{"$f":"'Data Sheet'!J16","v":"2015-03-31"},{"$f":"'Data Sheet'!K16","v":"2016-03-31"},"Trailing","Best Case","Worst Case"]
["Sales",{"$f":"'Data Sheet'!B17","v":831.02},{"$f":"'Data Sheet'!C17","v":1298.79},{"$f":"'Data Sheet'!D17","v":1749.37},{"$f":"'Data Sheet'!E17","v":1970.79},{"$f":"'Data Sheet'!F17","v":2055.2800000000002},{"$f":"'Data Sheet'!G17","v":2254.9899999999998},{"$f":"'Data Sheet'!H17","v":2818.54},{"$f":"'Data Sheet'!I17","v":3105.88},{"$f":"'Data Sheet'!J17","v":3034.65},{"$f":"'Data Sheet'!K17","v":3230.29},{"$f":"SUM(Quarters!H4:K4)","v":3532.7299999999996},{"$f":"$K4+M23*K4","v":3532.7299999999996},{"$f":"$K4+N23*L4","v":3394.5608450058021}]
["Expenses",{"$f":"SUM('Data Sheet'!B18,'Data Sheet'!B20:B24, -1*'Data Sheet'!B19)","v":664.2},{"$f":"SUM('Data Sheet'!C18,'Data Sheet'!C20:C24, -1*'Data Sheet'!C19)","v":1064.42},{"$f":"SUM('Data Sheet'!D18,'Data Sheet'!D20:D24, -1*'Data Sheet'!D19)","v":1562.2},{"$f":"SUM('Data Sheet'!E18,'Data Sheet'!E20:E24, -1*'Data Sheet'!E19)","v":1692.99},{"$f":"SUM('Data Sheet'!F18,'Data Sheet'!F20:F24, -1*'Data Sheet'!F19)","v":1765.7200000000003},{"$f":"SUM('Data Sheet'!G18,'Data Sheet'!G20:G24, -1*'Data Sheet'!G19)","v":2059.2999999999997},{"$f":"SUM('Data Sheet'!H18,'Data Sheet'!H20:H24, -1*'Data Sheet'!H19)","v":2525.33},{"$f":"SUM('Data Sheet'!I18,'Data Sheet'!I20:I24, -1*'Data Sheet'!I19)","v":2734.89},{"$f":"SUM('Data Sheet'!J18,'Data Sheet'!J20:J24, -1*'Data Sheet'!J19)","v":2644.86},{"$f":"SUM('Data Sheet'!K18,'Data Sheet'!K20:K24, -1*'Data Sheet'!K19)","v":2817.1200000000003},{"$f":"SUM(Quarters!H5:K5)","v":3082.33},{"$f":"M4-M6","v":3082.3299999999995},3003.7751397911056]
["Operating Profit",{"$f":"B4-B5","v":166.81999999999994},{"$f":"C4-C5","v":234.36999999999989},187.16999999999985,277.79999999999995,289.55999999999995,195.69000000000005,293.21000000000004,370.99000000000024,389.78999999999996,413.16999999999962,{"$f":"SUM(Quarters!H6:K6)","v":450.40000000000003},{"$f":"M4*M24","v":450.40000000000009},{"$f":"N4*N24","v":390.78570521469629}]
["Other Income",{"$f":"'Data Sheet'!B25","v":13.3},{"$f":"'Data Sheet'!C25","v":44.95},{"$f":"'Data Sheet'!D25","v":70.88},{"$f":"'Data Sheet'!E25","v":23.5},{"$f":"'Data Sheet'!F25","v":20.63},{"$f":"'Data Sheet'!G25","v":38.65},{"$f":"'Data Sheet'!H25","v":46.4},{"$f":"'Data Sheet'!I25","v":2},{"$f":"'Data Sheet'!J25","v":6.52},{"$f":"'Data Sheet'!K25","v":9.44},{"$f":"SUM(Quarters!H7:K7)","v":5.59},0,0]
["Depreciation",{"$f":"'Data Sheet'!B26","v":64.150000000000006},{"$f":"'Data Sheet'!C26","v":86.08},{"$f":"'Data Sheet'!D26","v":96.13},{"$f":"'Data Sheet'!E26","v":87.26},{"$f":"'Data Sheet'!F26","v":89.08},{"$f":"'Data Sheet'!G26","v":89.26},{"$f":"'Data Sheet'!H26","v":88.4},{"$f":"'Data Sheet'!I26","v":75.7},{"$f":"'Data Sheet'!J26","v":72.180000000000007},{"$f":"'Data Sheet'!K26","v":66.2},{"$f":"SUM(Quarters!H8:K8)","v":62.62},{"$f":"+$L8","v":62.62},{"$f":"+$L8","v":62.62}]
["Interest",{"$f":"'Data Sheet'!B27","v":13.34},{"$f":"'Data Sheet'!C27","v":50.05},{"$f":"'Data Sheet'!D27","v":111.23},{"$f":"'Data Sheet'!E27","v":53.75},{"$f":"'Data Sheet'!F27","v":45.81},{"$f":"'Data Sheet'!G27","v":69.099999999999994},{"$f":"'Data Sheet'!H27","v":92},{"$f":"'Data Sheet'!I27","v":94.01},{"$f":"'Data Sheet'!J27","v":80.12},{"$f":"'Data Sheet'!K27","v":60.8},{"$f":"SUM(Quarters!H9:K9)","v":46.870000000000005},{"$f":"+$L9","v":46.870000000000005},{"$f":"+$L9","v":46.870000000000005}]
["Profit before tax",{"$f":"'Data Sheet'!B28","v":102.63},{"$f":"'Data Sheet'!C28","v":143.19},{"$f":"'Data Sheet'!D28","v":50.69},{"$f":"'Data Sheet'!E28","v":160.29},{"$f":"'Data Sheet'!F28","v":175.3},{"$f":"'Data Sheet'!G28","v":75.98},{"$f":"'Data Sheet'!H28","v":159.19},{"$f":"'Data Sheet'!I28","v":203.28},{"$f":"'Data Sheet'!J28","v":244.02},{"$f":"'Data Sheet'!K28","v":295.62},{"$f":"SUM(Quarters!H10:K10)","v":346.51},{"$f":"M6+M7-SUM(M8:M9)","v":340.91000000000008},{"$f":"N6+N7-SUM(N8:N9)","v":281.29570521469628}]
["Tax",{"$f":"'Data Sheet'!B29","v":6.01},{"$f":"'Data Sheet'!C29","v":12.65},{"$f":"'Data Sheet'!D29","v":19.91},{"$f":"'Data Sheet'!E29","v":23.77},{"$f":"'Data Sheet'!F29","v":34.93},{"$f":"'Data Sheet'!G29","v":13.77},{"$f":"'Data Sheet'!H29","v":12.92},{"$f":"'Data Sheet'!I29","v":10.09},{"$f":"'Data Sheet'!J29","v":9.5399999999999991},{"$f":"'Data Sheet'!K29","v":30.21},{"$f":"SUM(Quarters!H11:K11)","v":56.03},{"$f":"IF($L10>0,$L11/$L10,0)","v":0.16169807509162795},{"$f":"IF($L10>0,$L11/$L10,0)","v":0.16169807509162795}]
["Net profit",{"$f":"'Data Sheet'!B30","v":97.25},{"$f":"'Data Sheet'!C30","v":131.56},{"$f":"'Data Sheet'!D30","v":30.67},{"$f":"'Data Sheet'!E30","v":136.07},{"$f":"'Data Sheet'!F30","v":138.51},{"$f":"'Data Sheet'!G30","v":62.03},{"$f":"'Data Sheet'!H30","v":146.59},{"$f":"'Data Sheet'!I30","v":192.96},{"$f":"'Data Sheet'!J30","v":234.32},{"$f":"'Data Sheet'!K30","v":264.97000000000003},{"$f":"SUM(Quarters!H12:K12)","v":290.83},{"$f":"M10-M11*M10","v":285.78550922051318},{"$f":"N10-N11*N10","v":235.81073114993788}]
["EPS",{"$f":"IF('Data Sheet'!B93>0,B12/'Data Sheet'!B93,0)","v":2.2877815274549684},{"$f":"IF('Data Sheet'!C93>0,C12/'Data Sheet'!C93,0)","v":3.078773898373933},{"$f":"IF('Data Sheet'!D93>0,D12/'Data Sheet'!D93,0)","v":0.71627134630488365},{"$f":"IF('Data Sheet'!E93>0,E12/'Data Sheet'!E93,0)","v":3.1702453534121346},{"$f":"IF('Data Sheet'!F93>0,F12/'Data Sheet'!F93,0)","v":3.2163892053584786},{"$f":"IF('Data Sheet'!G93>0,G12/'Data Sheet'!G93,0)","v":1.4399584887104759},{"$f":"IF('Data Sheet'!H93>0,H12/'Data Sheet'!H93,0)","v":2.2289166897281265},{"$f":"IF('Data Sheet'!I93>0,I12/'Data Sheet'!I93,0)","v":2.9248112514530078},{"$f":"IF('Data Sheet'!J93>0,J12/'Data Sheet'!J93,0)","v":3.5167792838238978},{"$f":"IF('Data Sheet'!K93>0,K12/'Data Sheet'!K93,0)","v":3.9353056835313343},{"$f":"IF('Data Sheet'!$B6>0,'Profit & Loss'!L12/'Data Sheet'!$B6,0)","v":4.2892782018253071},{"$f":"IF('Data Sheet'!$B6>0,'Profit & Loss'!M12/'Data Sheet'!$B6,0)","v":4.214880016150647},{"$f":"IF('Data Sheet'!$B6>0,'Profit & Loss'!N12/'Data Sheet'!$B6,0)","v":3.4778318222945246}]
["Price to earning",{"$f":"IF(B15>0,B15/B13,\"\")","v":33.779449249233934},{"$f":"IF(C15>0,C15/C13,\"\")","v":13.46315168577075},24.1388966474731,9.6995647251414709,6.0284992772940589,6.7779731683379003,4.8095112973054093,9.887817542288559,8.9655896646765108,9.1987771500169835,{"$f":"IF(L13>0,L15/L13,0)","v":10.036653715228828},{"$f":"M25","v":10.036653715228828},{"$f":"N25","v":8.1755483175362151}]
["Price",{"$f":"'Data Sheet'!B90","v":77.28},{"$f":"'Data Sheet'!C90","v":41.45},{"$f":"'Data Sheet'!D90","v":17.29},{"$f":"'Data Sheet'!E90","v":30.75},{"$f":"'Data Sheet'!F90","v":19.39},{"$f":"'Data Sheet'!G90","v":9.76},{"$f":"'Data Sheet'!H90","v":10.72},{"$f":"'Data Sheet'!I90","v":28.92},{"$f":"'Data Sheet'!J90","v":31.53},{"$f":"'Data Sheet'!K90","v":36.200000000000003},{"$f":"'Data Sheet'!B8","v":43.05},{"$f":"M13*M14","v":42.303291173342139},{"$f":"N13*N14","v":28.433182103433911}]
[]
["RATIOS:"]
["Dividend Payout",{"$f":"IF('Data Sheet'!B30>0, 'Data Sheet'!B31/'Data Sheet'!B30, 0)","v":0},{"$f":"IF('Data Sheet'!C30>0, 'Data Sheet'!C31/'Data Sheet'!C30, 0)","v":0},{"$f":"IF('Data Sheet'!D30>0, 'Data Sheet'!D31/'Data Sheet'!D30, 0)","v":0},{"$f":"IF('Data Sheet'!E30>0, 'Data Sheet'!E31/'Data Sheet'!E30, 0)","v":0},{"$f":"IF('Data Sheet'!F30>0, 'Data Sheet'!F31/'Data Sheet'!F30, 0)","v":0},{"$f":"IF('Data Sheet'!G30>0, 'Data Sheet'!G31/'Data Sheet'!G30, 0)","v":0},{"$f":"IF('Data Sheet'!H30>0, 'Data Sheet'!H31/'Data Sheet'!H30, 0)","v":0},{"$f":"IF('Data Sheet'!I30>0, 'Data Sheet'!I31/'Data Sheet'!I30, 0)","v":0},{"$f":"IF('Data Sheet'!J30>0, 'Data Sheet'!J31/'Data Sheet'!J30, 0)","v":0},{"$f":"IF('Data Sheet'!K30>0, 'Data Sheet'!K31/'Data Sheet'!K30, 0)","v":0}]
["OPM",{"$f":"IF(B6>0,B6/B4,0)","v":0.20074125773146248},{"$f":"IF(C6>0,C6/C4,0)","v":0.18045257508912133},0.10699280312341006,0.1409587018403787,0.14088591335487133,8.6780872642450782E-2,0.10402903630957873,0.1194476283694155,0.12844644357668922,0.12790492494481909,0.12749346822429117]
[]
[]
[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.16282523641764834},{"$f":"IF(D4=0,\"\",POWER($K4/D4,1/7)-1)","v":9.1569532996186531E-2},{"$f":"IF(F4=0,\"\",POWER($K4/F4,1/5)-1)","v":9.4647030748830518E-2},{"$f":"IF(H4=0,\"\",POWER($K4/H4, 1/3)-1)","v":4.6499688627719138E-2},{"$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.3626268848926747E-2},{"$f":"MAX(K23:L23)","v":9.3626268848926747E-2},{"$f":"MIN(H23:L23)","v":4.6499688627719138E-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.12611277159322756},{"$f":"IF(SUM(E4:$K$4)=0,\"\",SUMPRODUCT(E19:$K$19,E4:$K$4)/SUM(E4:$K$4))","v":0.12074495328205857},{"$f":"IF(SUM(G4:$K$4)=0,\"\",SUMPRODUCT(G19:$K$19,G4:$K$4)/SUM(G4:$K$4))","v":0.11512113733051332},{"$f":"IF(SUM(I4:$K$4)=0, \"\", SUMPRODUCT(I19:$K$19,I4:$K$4)/SUM(I4:$K$4))","v":0.12527719025656237},{"$f":"L19","v":0.12749346822429117},{"$f":"MAX(K24:L24)","v":0.12749346822429117},{"$f":"MIN(H24:L24)","v":0.11512113733051332}]
[null,null,null,null,null,null,"Price to Earning",{"$f":"IF(ISERROR(AVERAGEIF(B14:$L14,\">0\")),\"\",AVERAGEIF(B14:$L14,\">0\"))","v":12.435080374797046},{"$f":"IF(ISERROR(AVERAGEIF(E14:$L14,\">0\")),\"\",AVERAGEIF(E14:$L14,\">0\"))","v":8.1755483175362151},{"$f":"IF(ISERROR(AVERAGEIF(G14:$L14,\">0\")),\"\",AVERAGEIF(G14:$L14,\">0\"))","v":8.2793870896423662},{"$f":"IF(ISERROR(AVERAGEIF(I14:$L14,\">0\")),\"\",AVERAGEIF(I14:$L14,\">0\"))","v":9.5222095180527209},{"$f":"L14","v":10.036653715228828},{"$f":"MAX(K25:L25)","v":10.036653715228828},{"$f":"MIN(H25:L25)","v":8.1755483175362151}]

{"sheet":"Quarters","index":1,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Profit & Loss'!A1","v":"FIRSTSOURCE SOLUTIONS LTD"},null,null,null,{"$f":"UPDATE","v":""},null,null,null,null,"SCREENER.IN"]
[]
["Narration",{"$f":"'Data Sheet'!B41","v":"2014-09-30"},{"$f":"'Data Sheet'!C41","v":"2014-12-31"},{"$f":"'Data Sheet'!D41","v":"2015-03-31"},{"$f":"'Data Sheet'!E41","v":"2015-06-30"},{"$f":"'Data Sheet'!F41","v":"2015-09-30"},{"$f":"'Data Sheet'!G41","v":"2015-12-31"},{"$f":"'Data Sheet'!H41","v":"2016-03-31"},{"$f":"'Data Sheet'!I41","v":"2016-06-30"},{"$f":"'Data Sheet'!J41","v":"2016-09-30"},{"$f":"'Data Sheet'!K41","v":"2016-12-31"}]
["Sales",{"$f":"'Data Sheet'!B42","v":773.99},{"$f":"'Data Sheet'!C42","v":751.02},{"$f":"'Data Sheet'!D42","v":754.05},{"$f":"'Data Sheet'!E42","v":741.43},{"$f":"'Data Sheet'!F42","v":787.8},{"$f":"'Data Sheet'!G42","v":818.6},{"$f":"'Data Sheet'!H42","v":869.43},{"$f":"'Data Sheet'!I42","v":893.54},{"$f":"'Data Sheet'!J42","v":884.35},{"$f":"'Data Sheet'!K42","v":885.41}]
["Expenses",{"$f":"'Data Sheet'!B43","v":679.11},{"$f":"'Data Sheet'!C43","v":657.47},{"$f":"'Data Sheet'!D43","v":654.75},{"$f":"'Data Sheet'!E43","v":657.3},{"$f":"'Data Sheet'!F43","v":694.26},{"$f":"'Data Sheet'!G43","v":717.29},{"$f":"'Data Sheet'!H43","v":758},{"$f":"'Data Sheet'!I43","v":774.31},{"$f":"'Data Sheet'!J43","v":771.78},{"$f":"'Data Sheet'!K43","v":778.24}]
["Operating Profit",{"$f":"'Data Sheet'!B50","v":94.88},{"$f":"'Data Sheet'!C50","v":93.55},{"$f":"'Data Sheet'!D50","v":99.3},{"$f":"'Data Sheet'!E50","v":84.13},{"$f":"'Data Sheet'!F50","v":93.54},{"$f":"'Data Sheet'!G50","v":101.31},{"$f":"'Data Sheet'!H50","v":111.43},{"$f":"'Data Sheet'!I50","v":119.23},{"$f":"'Data Sheet'!J50","v":112.57},{"$f":"'Data Sheet'!K50","v":107.17}]
["Other Income",{"$f":"'Data Sheet'!B44","v":4.7},{"$f":"'Data Sheet'!C44","v":2.4700000000000002},{"$f":"'Data Sheet'!D44","v":0.38},{"$f":"'Data Sheet'!E44","v":4.54},{"$f":"'Data Sheet'!F44","v":0.92},{"$f":"'Data Sheet'!G44","v":2.06},{"$f":"'Data Sheet'!H44","v":1.93},{"$f":"'Data Sheet'!I44","v":1.86},{"$f":"'Data Sheet'!J44","v":0.39},{"$f":"'Data Sheet'!K44","v":1.41}]
["Depreciation",{"$f":"'Data Sheet'!B45","v":17.73},{"$f":"'Data Sheet'!C45","v":18.93},{"$f":"'Data Sheet'!D45","v":17.98},{"$f":"'Data Sheet'!E45","v":17.21},{"$f":"'Data Sheet'!F45","v":18.3},{"$f":"'Data Sheet'!G45","v":15.99},{"$f":"'Data Sheet'!H45","v":14.7},{"$f":"'Data Sheet'!I45","v":16.3},{"$f":"'Data Sheet'!J45","v":16.05},{"$f":"'Data Sheet'!K45","v":15.57}]
["Interest",{"$f":"'Data Sheet'!B46","v":18.07},{"$f":"'Data Sheet'!C46","v":17.27},{"$f":"'Data Sheet'!D46","v":17.37},{"$f":"'Data Sheet'!E46","v":14.27},{"$f":"'Data Sheet'!F46","v":13.06},{"$f":"'Data Sheet'!G46","v":12.45},{"$f":"'Data Sheet'!H46","v":12.97},{"$f":"'Data Sheet'!I46","v":13.16},{"$f":"'Data Sheet'!J46","v":10.86},{"$f":"'Data Sheet'!K46","v":9.8800000000000008}]
["Profit before tax",{"$f":"'Data Sheet'!B47","v":63.77},{"$f":"'Data Sheet'!C47","v":59.83},{"$f":"'Data Sheet'!D47","v":64.319999999999993},{"$f":"'Data Sheet'!E47","v":57.19},{"$f":"'Data Sheet'!F47","v":63.09},{"$f":"'Data Sheet'!G47","v":74.92},{"$f":"'Data Sheet'!H47","v":85.69},{"$f":"'Data Sheet'!I47","v":91.64},{"$f":"'Data Sheet'!J47","v":86.06},{"$f":"'Data Sheet'!K47","v":83.12}]
["Tax",{"$f":"'Data Sheet'!B48","v":2.4700000000000002},{"$f":"'Data Sheet'!C48","v":2.12},{"$f":"'Data Sheet'!D48","v":2.17},{"$f":"'Data Sheet'!E48","v":4.17},{"$f":"'Data Sheet'!F48","v":4.29},{"$f":"'Data Sheet'!G48","v":7.29},{"$f":"'Data Sheet'!H48","v":9.5399999999999991},{"$f":"'Data Sheet'!I48","v":18.27},{"$f":"'Data Sheet'!J48","v":14.86},{"$f":"'Data Sheet'!K48","v":13.36}]
["Net profit",{"$f":"'Data Sheet'!B49","v":61.24},{"$f":"'Data Sheet'!C49","v":57.51},{"$f":"'Data Sheet'!D49","v":62.32},{"$f":"'Data Sheet'!E49","v":52.87},{"$f":"'Data Sheet'!F49","v":58.66},{"$f":"'Data Sheet'!G49","v":67.45},{"$f":"'Data Sheet'!H49","v":76.2},{"$f":"'Data Sheet'!I49","v":73.36},{"$f":"'Data Sheet'!J49","v":71.260000000000005},{"$f":"'Data Sheet'!K49","v":70.010000000000005}]
[]
["OPM",{"$f":"IF(B4>0,B6/B4,\"\")","v":0.12258556312097055},{"$f":"IF(C4>0,C6/C4,\"\")","v":0.12456392639343826},0.13168888004774221,0.11346991624293595,0.11873571972581876,0.1237600781822624,0.12816442956879795,0.13343554849251293,0.12729123084751512,0.12103997018330491]

{"sheet":"Balance Sheet","index":2,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Profit & Loss'!A1","v":"FIRSTSOURCE SOLUTIONS LTD"},null,null,null,{"$f":"UPDATE","v":""},null,null,null,null,"SCREENER.IN"]
[]
["Narration",{"$f":"'Data Sheet'!B56","v":"2007-03-31"},{"$f":"'Data Sheet'!C56","v":"2008-03-31"},{"$f":"'Data Sheet'!D56","v":"2009-03-31"},{"$f":"'Data Sheet'!E56","v":"2010-03-31"},{"$f":"'Data Sheet'!F56","v":"2011-03-31"},{"$f":"'Data Sheet'!G56","v":"2012-03-31"},{"$f":"'Data Sheet'!H56","v":"2013-03-31"},{"$f":"'Data Sheet'!I56","v":"2014-03-31"},{"$f":"'Data Sheet'!J56","v":"2015-03-31"},{"$f":"'Data Sheet'!K56","v":"2016-03-31"}]
["Equity Share Capital",{"$f":"'Data Sheet'!B57","v":425.08},{"$f":"'Data Sheet'!C57","v":427.31},{"$f":"'Data Sheet'!D57","v":428.19},{"$f":"'Data Sheet'!E57","v":429.21},{"$f":"'Data Sheet'!F57","v":430.64},{"$f":"'Data Sheet'!G57","v":430.78},{"$f":"'Data Sheet'!H57","v":657.67},{"$f":"'Data Sheet'!I57","v":659.74},{"$f":"'Data Sheet'!J57","v":666.29},{"$f":"'Data Sheet'!K57","v":673.32}]
["Reserves",{"$f":"'Data Sheet'!B58","v":641.47},{"$f":"'Data Sheet'!C58","v":312.73},{"$f":"'Data Sheet'!D58","v":951.24},{"$f":"'Data Sheet'!E58","v":994.81},{"$f":"'Data Sheet'!F58","v":992.08},{"$f":"'Data Sheet'!G58","v":999.11},{"$f":"'Data Sheet'!H58","v":1055.96},{"$f":"'Data Sheet'!I58","v":1431.69},{"$f":"'Data Sheet'!J58","v":1422.33},{"$f":"'Data Sheet'!K58","v":1751.77}]
["Borrowings",{"$f":"'Data Sheet'!B59","v":197.59},{"$f":"'Data Sheet'!C59","v":1255.18},{"$f":"'Data Sheet'!D59","v":1394.56},{"$f":"'Data Sheet'!E59","v":1357.85},{"$f":"'Data Sheet'!F59","v":1493.27},{"$f":"'Data Sheet'!G59","v":2111.75},{"$f":"'Data Sheet'!H59","v":1276.4100000000001},{"$f":"'Data Sheet'!I59","v":1188.75},{"$f":"'Data Sheet'!J59","v":1031.4000000000001},{"$f":"'Data Sheet'!K59","v":905.93}]
["Other Liabilities",{"$f":"'Data Sheet'!B60","v":153.61000000000001},{"$f":"'Data Sheet'!C60","v":641.97},{"$f":"'Data Sheet'!D60","v":327.78},{"$f":"'Data Sheet'!E60","v":287.24},{"$f":"'Data Sheet'!F60","v":409.47},{"$f":"'Data Sheet'!G60","v":503.71},{"$f":"'Data Sheet'!H60","v":512.49},{"$f":"'Data Sheet'!I60","v":544.89},{"$f":"'Data Sheet'!J60","v":471.76},{"$f":"'Data Sheet'!K60","v":531.38}]
["Total",{"$f":"'Data Sheet'!B61","v":1417.75},{"$f":"'Data Sheet'!C61","v":2637.19},{"$f":"'Data Sheet'!D61","v":3101.77},{"$f":"'Data Sheet'!E61","v":3069.11},{"$f":"'Data Sheet'!F61","v":3325.46},{"$f":"'Data Sheet'!G61","v":4045.35},{"$f":"'Data Sheet'!H61","v":3502.53},{"$f":"'Data Sheet'!I61","v":3825.07},{"$f":"'Data Sheet'!J61","v":3591.78},{"$f":"'Data Sheet'!K61","v":3862.4}]
[]
["Net Block",{"$f":"'Data Sheet'!B62","v":713.94},{"$f":"'Data Sheet'!C62","v":2101.69},{"$f":"'Data Sheet'!D62","v":2506.64},{"$f":"'Data Sheet'!E62","v":2248.38},{"$f":"'Data Sheet'!F62","v":2262.8000000000002},{"$f":"'Data Sheet'!G62","v":2497.91},{"$f":"'Data Sheet'!H62","v":2514.44},{"$f":"'Data Sheet'!I62","v":2730.43},{"$f":"'Data Sheet'!J62","v":2443.9299999999998},{"$f":"'Data Sheet'!K62","v":2602.02}]
["Capital Work in Progress",{"$f":"'Data Sheet'!B63","v":8.1999999999999993},{"$f":"'Data Sheet'!C63","v":8.92},{"$f":"'Data Sheet'!D63","v":7.02},{"$f":"'Data Sheet'!E63","v":8.01},{"$f":"'Data Sheet'!F63","v":10.95},{"$f":"'Data Sheet'!G63","v":8.67},{"$f":"'Data Sheet'!H63","v":1.82},{"$f":"'Data Sheet'!I63","v":0.4},{"$f":"'Data Sheet'!J63","v":8.4700000000000006},{"$f":"'Data Sheet'!K63","v":7.88}]
["Investments",{"$f":"'Data Sheet'!B64","v":115.25},{"$f":"'Data Sheet'!C64","v":22.12},{"$f":"'Data Sheet'!D64","v":1.82},{"$f":"'Data Sheet'!E64","v":100.53},{"$f":"'Data Sheet'!F64","v":132.93},{"$f":"'Data Sheet'!G64","v":80.03},{"$f":"'Data Sheet'!H64","v":2.68},{"$f":"'Data Sheet'!I64","v":5.24},{"$f":"'Data Sheet'!J64","v":73.37},{"$f":"'Data Sheet'!K64","v":85.15}]
["Other Assets",{"$f":"'Data Sheet'!B65","v":580.36},{"$f":"'Data Sheet'!C65","v":504.46},{"$f":"'Data Sheet'!D65","v":586.29},{"$f":"'Data Sheet'!E65","v":712.19},{"$f":"'Data Sheet'!F65","v":918.78},{"$f":"'Data Sheet'!G65","v":1458.74},{"$f":"'Data Sheet'!H65","v":983.59},{"$f":"'Data Sheet'!I65","v":1089},{"$f":"'Data Sheet'!J65","v":1066.01},{"$f":"'Data Sheet'!K65","v":1167.3499999999999}]
["Total",{"$f":"'Data Sheet'!B66","v":1417.75},{"$f":"'Data Sheet'!C66","v":2637.19},{"$f":"'Data Sheet'!D66","v":3101.77},{"$f":"'Data Sheet'!E66","v":3069.11},{"$f":"'Data Sheet'!F66","v":3325.46},{"$f":"'Data Sheet'!G66","v":4045.35},{"$f":"'Data Sheet'!H66","v":3502.53},{"$f":"'Data Sheet'!I66","v":3825.07},{"$f":"'Data Sheet'!J66","v":3591.78},{"$f":"'Data Sheet'!K66","v":3862.4}]
[]
["Working Capital",{"$f":"B13-B7","v":426.75},-137.51000000000005,258.51,424.95000000000005,509.30999999999995,955.03,471.1,544.11,594.25,635.96999999999991]
["Debtors",{"$f":"'Data Sheet'!B67","v":133.54},{"$f":"'Data Sheet'!C67","v":205.38},{"$f":"'Data Sheet'!D67","v":237.95},{"$f":"'Data Sheet'!E67","v":261.06},{"$f":"'Data Sheet'!F67","v":238.87},{"$f":"'Data Sheet'!G67","v":351.47},{"$f":"'Data Sheet'!H67","v":386.58},{"$f":"'Data Sheet'!I67","v":301.93},{"$f":"'Data Sheet'!J67","v":288.95},{"$f":"'Data Sheet'!K67","v":304.08}]
["Inventory",{"$f":"'Data Sheet'!B68","v":0},{"$f":"'Data Sheet'!C68","v":0},{"$f":"'Data Sheet'!D68","v":0},{"$f":"'Data Sheet'!E68","v":0},{"$f":"'Data Sheet'!F68","v":0},{"$f":"'Data Sheet'!G68","v":0},{"$f":"'Data Sheet'!H68","v":0},{"$f":"'Data Sheet'!I68","v":0},{"$f":"'Data Sheet'!J68","v":0},{"$f":"'Data Sheet'!K68","v":0}]
[]
[]
["Inventory Turnover",{"$f":"IF('Balance Sheet'!B18>0,'Profit & Loss'!B4/'Balance Sheet'!B18,0)","v":0},{"$f":"IF('Balance Sheet'!C18>0,'Profit & Loss'!C4/'Balance Sheet'!C18,0)","v":0},{"$f":"IF('Balance Sheet'!D18>0,'Profit & Loss'!D4/'Balance Sheet'!D18,0)","v":0},{"$f":"IF('Balance Sheet'!E18>0,'Profit & Loss'!E4/'Balance Sheet'!E18,0)","v":0},{"$f":"IF('Balance Sheet'!F18>0,'Profit & Loss'!F4/'Balance Sheet'!F18,0)","v":0},{"$f":"IF('Balance Sheet'!G18>0,'Profit & Loss'!G4/'Balance Sheet'!G18,0)","v":0},{"$f":"IF('Balance Sheet'!H18>0,'Profit & Loss'!H4/'Balance Sheet'!H18,0)","v":0},{"$f":"IF('Balance Sheet'!I18>0,'Profit & Loss'!I4/'Balance Sheet'!I18,0)","v":0},{"$f":"IF('Balance Sheet'!J18>0,'Profit & Loss'!J4/'Balance Sheet'!J18,0)","v":0},{"$f":"IF('Balance Sheet'!K18>0,'Profit & Loss'!K4/'Balance Sheet'!K18,0)","v":0}]
["Inventory Days",{"$f":"IF('Profit & Loss'!B4>0,'Balance Sheet'!B18/('Profit & Loss'!B4/365),0)","v":0},{"$f":"IF('Profit & Loss'!C4>0,'Balance Sheet'!C18/('Profit & Loss'!C4/365),0)","v":0},{"$f":"IF('Profit & Loss'!D4>0,'Balance Sheet'!D18/('Profit & Loss'!D4/365),0)","v":0},{"$f":"IF('Profit & Loss'!E4>0,'Balance Sheet'!E18/('Profit & Loss'!E4/365),0)","v":0},{"$f":"IF('Profit & Loss'!F4>0,'Balance Sheet'!F18/('Profit & Loss'!F4/365),0)","v":0},{"$f":"IF('Profit & Loss'!G4>0,'Balance Sheet'!G18/('Profit & Loss'!G4/365),0)","v":0},{"$f":"IF('Profit & Loss'!H4>0,'Balance Sheet'!H18/('Profit & Loss'!H4/365),0)","v":0},{"$f":"IF('Profit & Loss'!I4>0,'Balance Sheet'!I18/('Profit & Loss'!I4/365),0)","v":0},{"$f":"IF('Profit & Loss'!J4>0,'Balance Sheet'!J18/('Profit & Loss'!J4/365),0)","v":0},{"$f":"IF('Profit & Loss'!K4>0,'Balance Sheet'!K18/('Profit & Loss'!K4/365),0)","v":0}]
["Debtor Days",{"$f":"IF('Profit & Loss'!B4>0,'Balance Sheet'!B17/('Profit & Loss'!B4/365),0)","v":58.653341676493945},{"$f":"IF('Profit & Loss'!C4>0,'Balance Sheet'!C17/('Profit & Loss'!C4/365),0)","v":57.718106853301919},{"$f":"IF('Profit & Loss'!D4>0,'Balance Sheet'!D17/('Profit & Loss'!D4/365),0)","v":49.647444508594525},{"$f":"IF('Profit & Loss'!E4>0,'Balance Sheet'!E17/('Profit & Loss'!E4/365),0)","v":48.349595847350557},{"$f":"IF('Profit & Loss'!F4>0,'Balance Sheet'!F17/('Profit & Loss'!F4/365),0)","v":42.42125160562064},{"$f":"IF('Profit & Loss'!G4>0,'Balance Sheet'!G17/('Profit & Loss'!G4/365),0)","v":56.890074900553891},{"$f":"IF('Profit & Loss'!H4>0,'Balance Sheet'!H17/('Profit & Loss'!H4/365),0)","v":50.061982444811846},{"$f":"IF('Profit & Loss'!I4>0,'Balance Sheet'!I17/('Profit & Loss'!I4/365),0)","v":35.482520251909285},{"$f":"IF('Profit & Loss'!J4>0,'Balance Sheet'!J17/('Profit & Loss'!J4/365),0)","v":34.754172639348845},{"$f":"IF('Profit & Loss'!K4>0,'Balance Sheet'!K17/('Profit & Loss'!K4/365),0)","v":34.35889656965783}]
["Creditor Days",{"$f":"IF('Profit & Loss'!B4>0,'Calculated Data'!B3/('Profit & Loss'!B4/365),0)","v":0},{"$f":"IF('Profit & Loss'!C4>0,'Calculated Data'!C3/('Profit & Loss'!C4/365),0)","v":0},{"$f":"IF('Profit & Loss'!D4>0,'Calculated Data'!D3/('Profit & Loss'!D4/365),0)","v":0},{"$f":"IF('Profit & Loss'!E4>0,'Calculated Data'!E3/('Profit & Loss'!E4/365),0)","v":0},{"$f":"IF('Profit & Loss'!F4>0,'Calculated Data'!F3/('Profit & Loss'!F4/365),0)","v":0},{"$f":"IF('Profit & Loss'!G4>0,'Calculated Data'!G3/('Profit & Loss'!G4/365),0)","v":0},{"$f":"IF('Profit & Loss'!H4>0,'Calculated Data'!H3/('Profit & Loss'!H4/365),0)","v":0},{"$f":"IF('Profit & Loss'!I4>0,'Calculated Data'!I3/('Profit & Loss'!I4/365),0)","v":0},{"$f":"IF('Profit & Loss'!J4>0,'Calculated Data'!J3/('Profit & Loss'!J4/365),0)","v":0},{"$f":"IF('Profit & Loss'!K4>0,'Calculated Data'!K3/('Profit & Loss'!K4/365),0)","v":0},"input creditors data in Calculated data sheet"]
["Cash Conversion Cycle",null,null,null,{"$f":"E22+E23-E24","v":48.349595847350557},{"$f":"F22+F23-F24","v":42.42125160562064},56.890074900553891,50.061982444811846,35.482520251909285,34.754172639348845,34.35889656965783,"? Check for creditors data input"]
[]
["Return on Equity",{"$f":"IF(SUM('Balance Sheet'!B4:B5)>0,'Profit & Loss'!B12/SUM('Balance Sheet'!B4:B5),\"\")","v":9.1181848014626601E-2},{"$f":"IF(SUM('Balance Sheet'!C4:C5)>0,'Profit & Loss'!C12/SUM('Balance Sheet'!C4:C5),\"\")","v":0.17777417436895304},{"$f":"IF(SUM('Balance Sheet'!D4:D5)>0,'Profit & Loss'!D12/SUM('Balance Sheet'!D4:D5),\"\")","v":2.223382121600951E-2},{"$f":"IF(SUM('Balance Sheet'!E4:E5)>0,'Profit & Loss'!E12/SUM('Balance Sheet'!E4:E5),\"\")","v":9.5553433238297208E-2},{"$f":"IF(SUM('Balance Sheet'!F4:F5)>0,'Profit & Loss'!F12/SUM('Balance Sheet'!F4:F5),\"\")","v":9.7355769230769218E-2},{"$f":"IF(SUM('Balance Sheet'!G4:G5)>0,'Profit & Loss'!G12/SUM('Balance Sheet'!G4:G5),\"\")","v":4.3380959374497347E-2},{"$f":"IF(SUM('Balance Sheet'!H4:H5)>0,'Profit & Loss'!H12/SUM('Balance Sheet'!H4:H5),\"\")","v":8.5543553742639888E-2},{"$f":"IF(SUM('Balance Sheet'!I4:I5)>0,'Profit & Loss'!I12/SUM('Balance Sheet'!I4:I5),\"\")","v":9.2262232061316896E-2},{"$f":"IF(SUM('Balance Sheet'!J4:J5)>0,'Profit & Loss'!J12/SUM('Balance Sheet'!J4:J5),\"\")","v":0.11218890942344706},{"$f":"IF(SUM('Balance Sheet'!K4:K5)>0,'Profit & Loss'!K12/SUM('Balance Sheet'!K4:K5),\"\")","v":0.10926192429971672}]
["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":8.4738184782894493E-2},{"$f":"IF(('Balance Sheet'!C10+'Balance Sheet'!C16)>0,('Profit & Loss'!C6-'Profit & Loss'!C8-'Profit & Loss'!C11)/('Balance Sheet'!C10+'Balance Sheet'!C16),\"\")","v":6.9056807420908417E-2},{"$f":"IF(('Balance Sheet'!D10+'Balance Sheet'!D16)>0,('Profit & Loss'!D6-'Profit & Loss'!D8-'Profit & Loss'!D11)/('Balance Sheet'!D10+'Balance Sheet'!D16),\"\")","v":2.5723740122597278E-2},{"$f":"IF(('Balance Sheet'!E10+'Balance Sheet'!E16)>0,('Profit & Loss'!E6-'Profit & Loss'!E8-'Profit & Loss'!E11)/('Balance Sheet'!E10+'Balance Sheet'!E16),\"\")","v":6.2382870801584528E-2},{"$f":"IF(('Balance Sheet'!F10+'Balance Sheet'!F16)>0,('Profit & Loss'!F6-'Profit & Loss'!F8-'Profit & Loss'!F11)/('Balance Sheet'!F10+'Balance Sheet'!F16),\"\")","v":5.9719852386810025E-2},{"$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":2.6835102839898772E-2},{"$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":6.427312981906122E-2},{"$f":"IF(('Balance Sheet'!I10+'Balance Sheet'!I16)>0,('Profit & Loss'!I6-'Profit & Loss'!I8-'Profit & Loss'!I11)/('Balance Sheet'!I10+'Balance Sheet'!I16),\"\")","v":8.7096202825435107E-2},{"$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.10139952208229926},{"$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":9.7826120525387555E-2}]
[]
[]
[]
["Common Size Balance Sheet",{"$f":"B3","v":"2007-03-31"},"2008-03-31","2009-03-31","2010-03-31","2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31","Check back how Assets are being put to use"]
["Net Block/Total Assets",{"$f":"B10/B$8","v":0.50357256215834956},0.79694295822447381,0.808132131009069,0.73258371319372717,0.68044721632495964,0.61747685614347336,0.71789249485371998,0.71382484503551558,0.68042307713724104,0.67367957746478868]
["Working Capital/Total Assets",{"$f":"B16/B$8","v":0.30100511373655442},-5.2142621502432533E-2,8.3342736566541037E-2,0.13846033540668143,0.15315475152309754,0.23608093242859085,0.13450277370929015,0.14224837715388214,0.16544721558670072,0.16465669014084505]
["Debtors/Total Assets",{"$f":"B17/B$8","v":9.41915006171751E-2},7.7878347786848878E-2,7.6714263146526018E-2,8.5060489848848689E-2,7.1830664028435159E-2,8.6882469996415648E-2,0.1103716456390095,7.89345031594193E-2,8.0447577524235883E-2,7.8728251864125923E-2]
["Inventory/Total Assets",{"$f":"B18/B$8","v":0},0,0,0,0,0,0,0,0,0]
[]
["Borrowings/Total Assets",{"$f":"B6/B$8","v":0.13936871803914655},0.47595357179422038,0.44960135664475442,0.44242467686071851,0.44904163634504701,0.52201910835898002,0.36442514411011467,0.31077862627350611,0.2871556721180028,0.23455105633802814]

{"sheet":"Cash Flow","index":3,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Balance Sheet'!A1","v":"FIRSTSOURCE SOLUTIONS LTD"},null,null,null,{"$f":"UPDATE","v":""},null,null,null,null,"SCREENER.IN"]
[]
["Narration",{"$f":"'Data Sheet'!B81","v":"2007-03-31"},{"$f":"'Data Sheet'!C81","v":"2008-03-31"},{"$f":"'Data Sheet'!D81","v":"2009-03-31"},{"$f":"'Data Sheet'!E81","v":"2010-03-31"},{"$f":"'Data Sheet'!F81","v":"2011-03-31"},{"$f":"'Data Sheet'!G81","v":"2012-03-31"},{"$f":"'Data Sheet'!H81","v":"2013-03-31"},{"$f":"'Data Sheet'!I81","v":"2014-03-31"},{"$f":"'Data Sheet'!J81","v":"2015-03-31"},{"$f":"'Data Sheet'!K81","v":"2016-03-31"}]
["Cash from Operating Activity",{"$f":"'Data Sheet'!B82","v":91.37},{"$f":"'Data Sheet'!C82","v":226.85},{"$f":"'Data Sheet'!D82","v":174.71},{"$f":"'Data Sheet'!E82","v":171.57},{"$f":"'Data Sheet'!F82","v":245.7},{"$f":"'Data Sheet'!G82","v":5.68},{"$f":"'Data Sheet'!H82","v":199.28},{"$f":"'Data Sheet'!I82","v":395.57},{"$f":"'Data Sheet'!J82","v":246.05},{"$f":"'Data Sheet'!K82","v":299.73}]
["Cash from Investing Activity",{"$f":"'Data Sheet'!B83","v":-404.63},{"$f":"'Data Sheet'!C83","v":-1415.23},{"$f":"'Data Sheet'!D83","v":-88.03},{"$f":"'Data Sheet'!E83","v":-147.22},{"$f":"'Data Sheet'!F83","v":-59.69},{"$f":"'Data Sheet'!G83","v":-475.73},{"$f":"'Data Sheet'!H83","v":583.34},{"$f":"'Data Sheet'!I83","v":-13.28},{"$f":"'Data Sheet'!J83","v":-104.24},{"$f":"'Data Sheet'!K83","v":-103.69}]
["Cash from Financing Activity",{"$f":"'Data Sheet'!B84","v":597.23},{"$f":"'Data Sheet'!C84","v":989.85},{"$f":"'Data Sheet'!D84","v":-92.45},{"$f":"'Data Sheet'!E84","v":0.71},{"$f":"'Data Sheet'!F84","v":16.86},{"$f":"'Data Sheet'!G84","v":332.81},{"$f":"'Data Sheet'!H84","v":-881.06},{"$f":"'Data Sheet'!I84","v":-286.41000000000003},{"$f":"'Data Sheet'!J84","v":-246.45},{"$f":"'Data Sheet'!K84","v":-207.44}]
["Net Cash Flow",{"$f":"'Data Sheet'!B85","v":283.97000000000003},{"$f":"'Data Sheet'!C85","v":-198.53},{"$f":"'Data Sheet'!D85","v":-5.77},{"$f":"'Data Sheet'!E85","v":25.06},{"$f":"'Data Sheet'!F85","v":202.87},{"$f":"'Data Sheet'!G85","v":-137.24},{"$f":"'Data Sheet'!H85","v":-98.44},{"$f":"'Data Sheet'!I85","v":95.88},{"$f":"'Data Sheet'!J85","v":-104.64},{"$f":"'Data Sheet'!K85","v":-11.41}]

{"sheet":"Customization","index":4,"n_rows":68,"n_cols":14,"rows_kept":68,"cut":false,"hidden":false,"merged":[[53,0,53,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":"FIRSTSOURCE SOLUTIONS LTD"}]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"DELTA NETWORTH","DELTA MKTCAP","IMPACT*",null,"HISTORICAL VALUATIONS",null,null,null,null,null,null,"PRE-TAX BOND"]
["10 YR",{"$f":"'Calculated Data'!K13-'Calculated Data'!B13","v":1358.5400000000002},{"$f":"'Calculated Data'!K31-'Calculated Data'!B31","v":-847.65145804799977},{"$f":"C5/B5","v":-0.62394295202791206},null,null,"P/E","P/B","EV/EBITDA","P/SALES","YIELD",null,"LongTerm Bond",0.09]
["7 YR",{"$f":"'Calculated Data'!K13-'Calculated Data'!E13","v":1001.0700000000002},{"$f":"'Calculated Data'!K31-'Calculated Data'!E31","v":1117.5802092900005},{"$f":"C6/B6","v":1.1163856766160212},null,"MIN",{"$f":"MIN('Calculated Data'!B36:K36)","v":4.8095112973054093},{"$f":"MIN('Calculated Data'!B37:K37)","v":0.29403497865709949},{"$f":"MIN('Calculated Data'!B40:K40)","v":5.569469834423864},{"$f":"MIN('Calculated Data'!B39:K39)","v":0.186447689627005},{"$f":"MAX('Calculated Data'!B41:K41)","v":0},null,"LTB Quote",{"$f":"('Profit & Loss'!$L$10/'Data Sheet'!$B$61)/N5","v":2.7156488175708775}]
["5 YR",{"$f":"'Calculated Data'!K13-'Calculated Data'!G13","v":995.20000000000027},{"$f":"'Calculated Data'!K31-'Calculated Data'!G31","v":2016.9623058080003},{"$f":"C7/B7","v":2.0266904198231508},null,"MAX",{"$f":"MAX('Calculated Data'!B36:K36)","v":33.779449249233934},{"$f":"MAX('Calculated Data'!B37:K37)","v":3.0800726074614415},{"$f":"MAX('Calculated Data'!B40:K40)","v":17.599719295403066},{"$f":"MAX('Calculated Data'!B39:K39)","v":3.9530353535269911},{"$f":"MIN('Calculated Data'!B41:K41)","v":0},null,"Equity Quoting @",{"$f":"('Profit & Loss'!$L$6/'Data Sheet'!$B$6)/'Data Sheet'!$B$8","v":0.15430153205251187}]
["3 YR",{"$f":"'Calculated Data'!K13-'Calculated Data'!I13","v":333.65999999999985},{"$f":"'Calculated Data'!K31-'Calculated Data'!I31","v":529.4467084800001},{"$f":"C8/B8","v":1.5867850760654569},null,"TRAILING",{"$f":"'Data Sheet'!B8/'Profit & Loss'!L13","v":10.036653715228828},{"$f":"'Calculated Data'!L31/'Calculated Data'!K13","v":1.2036501738079823},{"$f":"'Calculated Data'!K40","v":7.7479058762954907},{"$f":"'Calculated Data'!L31/'Data Sheet'!K17","v":0.90362165625996427},{"$f":"'Data Sheet'!K31/'Calculated Data'!L31","v":0}]
["1 YR",{"$f":"'Calculated Data'!K13-'Calculated Data'!J13","v":336.47000000000025},{"$f":"'Calculated Data'!K31-'Calculated Data'!J31","v":336.58301121300019},{"$f":"C9/B9","v":1.0003358730733793},null,null,null,null,null,null,null,null," "]
["* IMPACT – Every Rupee retained added xx.yy in incremental market value"]
[]
[{"$f":"A1","v":"FIRSTSOURCE SOLUTIONS 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.16282523641764834},{"$f":"POWER('Calculated Data'!$K6/'Calculated Data'!$B6, 1/9)-1","v":0.16282523641764834},{"$f":"POWER('Calculated Data'!$K7/'Calculated Data'!$B7, 1/9)-1","v":0.13286876029790262},{"$f":"POWER('Calculated Data'!$K10/'Calculated Data'!$B10, 1/9)-1","v":0.11780862185453178},{"$f":"POWER('Calculated Data'!$K11/'Calculated Data'!$B11, 1/9)-1","v":{"$error":"#DIV/0!"}},{"$f":"POWER('Calculated Data'!$K26/'Calculated Data'!$B26, 1/9)-1","v":0.10332542983025794},{"$f":"POWER('Calculated Data'!$K31/'Calculated Data'!$B31, 1/9)-1","v":-3.261735431053292E-2},{"$f":"POWER('Calculated Data'!$K19/'Calculated Data'!$B19, 1/9)-1","v":0.14110386545440079},{"$f":"POWER('Calculated Data'!$K21/'Calculated Data'!$C21, 1/8)-1","v":{"$error":"#NUM!"}},{"$f":"POWER('Calculated Data'!$K13/'Calculated Data'!$B13, 1/9)-1","v":9.5565923874497027E-2},{"$f":"POWER('Calculated Data'!$K32/'Calculated Data'!$B32, 1/9)-1","v":-3.261735431053292E-2}]
["5 YR CAGR",{"$f":"POWER('Data Sheet'!$K17/'Data Sheet'!$G17, 1/4)-1","v":9.4017384381185565E-2},{"$f":"POWER('Calculated Data'!$K6/'Calculated Data'!$G6, 1/4)-1","v":9.4017384381185565E-2},{"$f":"POWER('Calculated Data'!$K7/'Calculated Data'!$G7, 1/4)-1","v":0.25195474277662688},{"$f":"POWER('Calculated Data'!$K10/'Calculated Data'!$G10, 1/4)-1","v":0.43763531044020265},{"$f":"POWER('Calculated Data'!$K11/'Calculated Data'!$G11, 1/4)-1","v":{"$error":"#DIV/0!"}},{"$f":"POWER('Calculated Data'!$K26/'Calculated Data'!$G26, 1/4)-1","v":-0.30423418502227662},{"$f":"POWER('Calculated Data'!$K31/'Calculated Data'!$G31, 1/4)-1","v":0.55169476256494598},{"$f":"POWER('Calculated Data'!$K19/'Calculated Data'!$G19, 1/4)-1","v":1.6952277500831991},{"$f":"POWER('Calculated Data'!$K21/'Calculated Data'!$G21, 1/4)-1","v":{"$error":"#NUM!"}},{"$f":"POWER('Calculated Data'!$K13/'Calculated Data'!$G13, 1/4)-1","v":0.14118566588703607},{"$f":"POWER('Calculated Data'!$K32/'Calculated Data'!$G32, 1/4)-1","v":0.55169476256494598}]
["3 YR CAGR",{"$f":"POWER('Data Sheet'!$K17/'Data Sheet'!$I17, 1/2)-1","v":1.983149605494483E-2},{"$f":"POWER('Calculated Data'!$K6/'Calculated Data'!$I6, 1/2)-1","v":1.983149605494483E-2},{"$f":"POWER('Calculated Data'!$K7/'Calculated Data'!$I7, 1/2)-1","v":9.4941414045396355E-2},{"$f":"POWER('Calculated Data'!$K10/'Calculated Data'!$I10, 1/2)-1","v":0.17183025757593451},{"$f":"POWER('Calculated Data'!$K11/'Calculated Data'!$I11, 1/2)-1","v":{"$error":"#DIV/0!"}},{"$f":"POWER('Calculated Data'!$K26/'Calculated Data'!$I26, 1/2)-1","v":-0.20673978904984824},{"$f":"POWER('Calculated Data'!$K31/'Calculated Data'!$I31, 1/2)-1","v":0.13026306166499535},{"$f":"POWER('Calculated Data'!$K19/'Calculated Data'!$I19, 1/2)-1","v":-0.12953075149551896},{"$f":"POWER('Calculated Data'!$K21/'Calculated Data'!$I21, 1/2)-1","v":-0.15027516883466752},{"$f":"POWER('Calculated Data'!$K13/'Calculated Data'!$I13, 1/2)-1","v":7.6817893737234355E-2},{"$f":"POWER('Calculated Data'!$K32/'Calculated Data'!$I32, 1/2)-1","v":0.13026306166499535}]
["1 YR GROWTH",{"$f":"('Data Sheet'!$K17-'Data Sheet'!$J17)/'Data Sheet'!$J17","v":6.4468719621702628E-2},{"$f":"('Calculated Data'!$K6-'Calculated Data'!$J6)/'Calculated Data'!$J6","v":6.4468719621702628E-2},{"$f":"('Calculated Data'!$K7-'Calculated Data'!$J7)/'Calculated Data'!$J7","v":9.9586598383414673E-2},{"$f":"('Calculated Data'!$K10-'Calculated Data'!$J10)/'Calculated Data'!$J10","v":0.13080402867873009},{"$f":"('Calculated Data'!$K11-'Calculated Data'!$J11)/'Calculated Data'!$J11","v":{"$error":"#DIV/0!"}},{"$f":"('Calculated Data'!$K26-'Calculated Data'!$J26)/'Calculated Data'!$J26","v":0.28408061247230271},{"$f":"('Calculated Data'!$K31-'Calculated Data'!$J31)/'Calculated Data'!$J31","v":0.16021529527945089},{"$f":"('Calculated Data'!$K19-'Calculated Data'!$J19)/'Calculated Data'!$J19","v":0.21816703921967082},{"$f":"('Calculated Data'!$K21-'Calculated Data'!$J21)/'Calculated Data'!$J21","v":-0.83190360380278605},{"$f":"('Calculated Data'!$K13-'Calculated Data'!$J13)/'Calculated Data'!$J13","v":0.16109680075839564},{"$f":"('Calculated Data'!$K32-'Calculated Data'!$J32)/'Calculated Data'!$J32","v":0.16021529527945089}]
["**modify (if, then) for negative values"]
[{"$f":"A1","v":"FIRSTSOURCE SOLUTIONS LTD"},{"$f":"'Data Sheet'!B16","v":"2007-03-31"},{"$f":"'Data Sheet'!C16","v":"2008-03-31"},{"$f":"'Data Sheet'!D16","v":"2009-03-31"},{"$f":"'Data Sheet'!E16","v":"2010-03-31"},{"$f":"'Data Sheet'!F16","v":"2011-03-31"},{"$f":"'Data Sheet'!G16","v":"2012-03-31"},{"$f":"'Data Sheet'!H16","v":"2013-03-31"},{"$f":"'Data Sheet'!I16","v":"2014-03-31"},{"$f":"'Data Sheet'!J16","v":"2015-03-31"},{"$f":"'Data Sheet'!K16","v":"2016-03-31"},null,"    "]
["Total Assets/Networth= Financial Leverage",{"$f":"'Calculated Data'!B17/'Calculated Data'!B13","v":1.3292860156579627},{"$f":"'Calculated Data'!C17/'Calculated Data'!C13","v":3.5635776444516516},{"$f":"'Calculated Data'!D17/'Calculated Data'!D13","v":2.2485881849749534},{"$f":"'Calculated Data'!E17/'Calculated Data'!E13","v":2.1552436061291274},{"$f":"'Calculated Data'!F17/'Calculated Data'!F13","v":2.3373959739091319},{"$f":"'Calculated Data'!G17/'Calculated Data'!G13","v":2.8291337095860523},{"$f":"'Calculated Data'!H17/'Calculated Data'!H13","v":2.0439243010451498},{"$f":"'Calculated Data'!I17/'Calculated Data'!I13","v":1.8289256633021425},{"$f":"'Calculated Data'!J17/'Calculated Data'!J13","v":1.7196905133533149},{"$f":"'Calculated Data'!K17/'Calculated Data'!K13","v":1.5926831581508314}," "]
["Long term debt/Earning",{"$f":"'Data Sheet'!B59/'Data Sheet'!B30","v":2.0317737789203085},{"$f":"'Data Sheet'!C59/'Data Sheet'!C30","v":9.5407418668288244},{"$f":"'Data Sheet'!D59/'Data Sheet'!D30","v":45.469840234757086},{"$f":"'Data Sheet'!E59/'Data Sheet'!E30","v":9.9790548982141551},{"$f":"'Data Sheet'!F59/'Data Sheet'!F30","v":10.780954443722475},{"$f":"'Data Sheet'!G59/'Data Sheet'!G30","v":34.044010962437532},{"$f":"'Data Sheet'!H59/'Data Sheet'!H30","v":8.7073470223071148},{"$f":"'Data Sheet'!I59/'Data Sheet'!I30","v":6.1606032338308454},{"$f":"'Data Sheet'!J59/'Data Sheet'!J30","v":4.4016729259132816},{"$f":"'Data Sheet'!K59/'Data Sheet'!K30","v":3.4189908291504691}]
["Current liablility/Earning",{"$f":"'Data Sheet'!B60/'Data Sheet'!B30","v":1.5795372750642676},{"$f":"'Data Sheet'!C60/'Data Sheet'!C30","v":4.8796746731529339},{"$f":"'Data Sheet'!D60/'Data Sheet'!D30","v":10.687316596022169},{"$f":"'Data Sheet'!E60/'Data Sheet'!E30","v":2.1109722936723747},{"$f":"'Data Sheet'!F60/'Data Sheet'!F30","v":2.956248646307126},{"$f":"'Data Sheet'!G60/'Data Sheet'!G30","v":8.1204256005158797},{"$f":"'Data Sheet'!H60/'Data Sheet'!H30","v":3.4960774950542328},{"$f":"'Data Sheet'!I60/'Data Sheet'!I30","v":2.8238495024875618},{"$f":"'Data Sheet'!J60/'Data Sheet'!J30","v":2.01331512461591},{"$f":"'Data Sheet'!K60/'Data Sheet'!K30","v":2.0054345774993392}]
["Total liability/Earning",{"$f":"('Data Sheet'!B59+'Data Sheet'!B60)/'Data Sheet'!B30","v":3.6113110539845765},{"$f":"('Data Sheet'!C59+'Data Sheet'!C60)/'Data Sheet'!C30","v":14.420416539981758},{"$f":"('Data Sheet'!D59+'Data Sheet'!D60)/'Data Sheet'!D30","v":56.157156830779257},{"$f":"('Data Sheet'!E59+'Data Sheet'!E60)/'Data Sheet'!E30","v":12.090027191886529},{"$f":"('Data Sheet'!F59+'Data Sheet'!F60)/'Data Sheet'!F30","v":13.737203090029602},{"$f":"('Data Sheet'!G59+'Data Sheet'!G60)/'Data Sheet'!G30","v":42.164436562953412},{"$f":"('Data Sheet'!H59+'Data Sheet'!H60)/'Data Sheet'!H30","v":12.203424517361348},{"$f":"('Data Sheet'!I59+'Data Sheet'!I60)/'Data Sheet'!I30","v":8.9844527363184064},{"$f":"('Data Sheet'!J59+'Data Sheet'!J60)/'Data Sheet'!J30","v":6.4149880505291916},{"$f":"('Data Sheet'!K59+'Data Sheet'!K60)/'Data Sheet'!K30","v":5.4244254066498083}]
["Debt/Equity",{"$f":"'Data Sheet'!B59/'Calculated Data'!B13","v":0.18526088790961512},{"$f":"'Data Sheet'!C59/'Calculated Data'!C13","v":1.6960975082427978},{"$f":"'Data Sheet'!D59/'Calculated Data'!D13","v":1.0109682985001049},{"$f":"'Data Sheet'!E59/'Calculated Data'!E13","v":0.95353295599780896},{"$f":"'Data Sheet'!F59/'Calculated Data'!F13","v":1.0495881129104814},{"$f":"'Data Sheet'!G59/'Calculated Data'!G13","v":1.4768618565064446},{"$f":"'Data Sheet'!H59/'Calculated Data'!H13","v":0.74485740795854416},{"$f":"'Data Sheet'!I59/'Calculated Data'!I13","v":0.56839100519740071},{"$f":"'Data Sheet'!J59/'Calculated Data'!J13","v":0.49381888519692435},{"$f":"'Data Sheet'!K59/'Calculated Data'!K13","v":0.37356551715606429}]
["Interest Coverage",{"$f":"'Calculated Data'!B7/'Data Sheet'!B27","v":8.6934032983508249},{"$f":"'Calculated Data'!C7/'Data Sheet'!C27","v":3.8609390609390615},{"$f":"'Calculated Data'!D7/'Data Sheet'!D27","v":1.4557223770565495},{"$f":"'Calculated Data'!E7/'Data Sheet'!E27","v":3.982139534883721},{"$f":"'Calculated Data'!F7/'Data Sheet'!F27","v":4.8266753983846327},{"$f":"'Calculated Data'!G7/'Data Sheet'!G27","v":2.0995658465991318},{"$f":"'Calculated Data'!H7/'Data Sheet'!H27","v":2.7303260869565218},{"$f":"'Calculated Data'!I7/'Data Sheet'!I27","v":3.1623231571109458},{"$f":"'Calculated Data'!J7/'Data Sheet'!J27","v":4.045681477783325},{"$f":"'Calculated Data'!K7/'Data Sheet'!K27","v":5.8621710526315791}]
["Working Capital/Sales",{"$f":"'Calculated Data'!B14/'Data Sheet'!B17","v":0.51352554691824503},{"$f":"'Calculated Data'!C14/'Data Sheet'!C17","v":-0.10587546870548746},{"$f":"'Calculated Data'!D14/'Data Sheet'!D17","v":0.14777319835140651},{"$f":"'Calculated Data'!E14/'Data Sheet'!E17","v":0.21562419131414309},{"$f":"'Calculated Data'!F14/'Data Sheet'!F17","v":0.24780565178467162},{"$f":"'Calculated Data'!G14/'Data Sheet'!G17","v":0.42351850784260686},{"$f":"'Calculated Data'!H14/'Data Sheet'!H17","v":0.16714327275823654},{"$f":"'Calculated Data'!I14/'Data Sheet'!I17","v":0.17518706453565494},{"$f":"'Calculated Data'!J14/'Data Sheet'!J17","v":0.1958215939235167},{"$f":"'Calculated Data'!K14/'Data Sheet'!K17","v":0.19687706057350884},"Check for improving or deteriorating picture"]
["Inventory Turns",{"$f":"365/B27","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Inventory Days",{"$f":"'Balance Sheet'!B22","v":0},{"$f":"'Balance Sheet'!C22","v":0},{"$f":"'Balance Sheet'!D22","v":0},{"$f":"'Balance Sheet'!E22","v":0},{"$f":"'Balance Sheet'!F22","v":0},{"$f":"'Balance Sheet'!G22","v":0},{"$f":"'Balance Sheet'!H22","v":0},{"$f":"'Balance Sheet'!I22","v":0},{"$f":"'Balance Sheet'!J22","v":0},{"$f":"'Balance Sheet'!K22","v":0}]
["Debtor Days",{"$f":"'Balance Sheet'!B23","v":58.653341676493945},{"$f":"'Balance Sheet'!C23","v":57.718106853301919},{"$f":"'Balance Sheet'!D23","v":49.647444508594525},{"$f":"'Balance Sheet'!E23","v":48.349595847350557},{"$f":"'Balance Sheet'!F23","v":42.42125160562064},{"$f":"'Balance Sheet'!G23","v":56.890074900553891},{"$f":"'Balance Sheet'!H23","v":50.061982444811846},{"$f":"'Balance Sheet'!I23","v":35.482520251909285},{"$f":"'Balance Sheet'!J23","v":34.754172639348845},{"$f":"'Balance Sheet'!K23","v":34.35889656965783}]
["Creditor Days",null,null,null,null,null,null,null,null,null,null,"Check back to see if Creditor policy change is impacting Working Cap cycle"]
["Cash Conversion Cycle"]
["Cash In/Cash Out Ratio",{"$f":"('Data Sheet'!B67+'Data Sheet'!B69)/'Data Sheet'!B60","v":2.9042380053381938},{"$f":"('Data Sheet'!C67+'Data Sheet'!C69)/'Data Sheet'!C60","v":0.48489804819539845},{"$f":"('Data Sheet'!D67+'Data Sheet'!D69)/'Data Sheet'!D60","v":1.0209286716700225},{"$f":"('Data Sheet'!E67+'Data Sheet'!E69)/'Data Sheet'!E60","v":1.3656872301907812},{"$f":"('Data Sheet'!F67+'Data Sheet'!F69)/'Data Sheet'!F60","v":1.3756563362395289},{"$f":"('Data Sheet'!G67+'Data Sheet'!G69)/'Data Sheet'!G60","v":2.0534434496039391},{"$f":"('Data Sheet'!H67+'Data Sheet'!H69)/'Data Sheet'!H60","v":0.93012546586274847},{"$f":"('Data Sheet'!I67+'Data Sheet'!I69)/'Data Sheet'!I60","v":0.89605241424874749},{"$f":"('Data Sheet'!J67+'Data Sheet'!J69)/'Data Sheet'!J60","v":0.78255892826861118},{"$f":"('Data Sheet'!K67+'Data Sheet'!K69)/'Data Sheet'!K60","v":0.70192705784937337},null,"  "]
["Current Ratio",{"$f":"'Data Sheet'!B65/'Data Sheet'!B60","v":3.7781394440466114},{"$f":"'Data Sheet'!C65/'Data Sheet'!C60","v":0.78579995949966508},{"$f":"'Data Sheet'!D65/'Data Sheet'!D60","v":1.788669229361157},{"$f":"'Data Sheet'!E65/'Data Sheet'!E60","v":2.4794248711878568},{"$f":"'Data Sheet'!F65/'Data Sheet'!F60","v":2.2438273866217302},{"$f":"'Data Sheet'!G65/'Data Sheet'!G60","v":2.8959917412797047},{"$f":"'Data Sheet'!H65/'Data Sheet'!H60","v":1.9192374485355812},{"$f":"'Data Sheet'!I65/'Data Sheet'!I60","v":1.9985685184165611},{"$f":"'Data Sheet'!J65/'Data Sheet'!J60","v":2.2596447346108191},{"$f":"'Data Sheet'!K65/'Data Sheet'!K60","v":2.1968271293612855}," "]
["CFO/PAT",{"$f":"'Calculated Data'!B19/'Calculated Data'!B10","v":0.93953727506426743},{"$f":"'Calculated Data'!C19/'Calculated Data'!C10","v":1.7243083003952568},{"$f":"'Calculated Data'!D19/'Calculated Data'!D10","v":5.6964460384740789},{"$f":"'Calculated Data'!E19/'Calculated Data'!E10","v":1.2608951275079003},{"$f":"'Calculated Data'!F19/'Calculated Data'!F10","v":1.7738791423001949},{"$f":"'Calculated Data'!G19/'Calculated Data'!G10","v":9.1568595840722231E-2},{"$f":"'Calculated Data'!H19/'Calculated Data'!H10","v":1.3594378879869022},{"$f":"'Calculated Data'!I19/'Calculated Data'!I10","v":2.0500103648424544},{"$f":"'Calculated Data'!J19/'Calculated Data'!J10","v":1.0500597473540458},{"$f":"'Calculated Data'!K19/'Calculated Data'!K10","v":1.1311846624146129}]
[null,null,null,null,null,null,null,null,null,null,null," "]
["Gross Margin =Gross Profit/Sales",{"$f":"'Calculated Data'!B6/'Data Sheet'!B17","v":1},{"$f":"'Calculated Data'!C6/'Data Sheet'!C17","v":1},{"$f":"'Calculated Data'!D6/'Data Sheet'!D17","v":1},{"$f":"'Calculated Data'!E6/'Data Sheet'!E17","v":1},{"$f":"'Calculated Data'!F6/'Data Sheet'!F17","v":1},{"$f":"'Calculated Data'!G6/'Data Sheet'!G17","v":1},{"$f":"'Calculated Data'!H6/'Data Sheet'!H17","v":1},{"$f":"'Calculated Data'!I6/'Data Sheet'!I17","v":1},{"$f":"'Calculated Data'!J6/'Data Sheet'!J17","v":1},{"$f":"'Calculated Data'!K6/'Data Sheet'!K17","v":1}]
["EBIT/Sales",{"$f":"'Calculated Data'!B7/'Data Sheet'!B17","v":0.13955139467160838},{"$f":"'Calculated Data'!C7/'Data Sheet'!C17","v":0.14878463800922398},{"$f":"'Calculated Data'!D7/'Data Sheet'!D17","v":9.2559035538508166E-2},{"$f":"'Calculated Data'!E7/'Data Sheet'!E17","v":0.10860619345541635},{"$f":"'Calculated Data'!F7/'Data Sheet'!F17","v":0.10758144875637382},{"$f":"'Calculated Data'!G7/'Data Sheet'!G17","v":6.4337314134430751E-2},{"$f":"'Calculated Data'!H7/'Data Sheet'!H17","v":8.9120608542011107E-2},{"$f":"'Calculated Data'!I7/'Data Sheet'!I17","v":9.5718443726093741E-2},{"$f":"'Calculated Data'!J7/'Data Sheet'!J17","v":0.1068129767848022},{"$f":"'Calculated Data'!K7/'Data Sheet'!K17","v":0.11033684282216148}]
["EBITDA/Sales",{"$f":"'Calculated Data'!B8/'Data Sheet'!B17","v":0.21674568602440375},{"$f":"'Calculated Data'!C8/'Data Sheet'!C17","v":0.21506171128511922},{"$f":"'Calculated Data'!D8/'Data Sheet'!D17","v":0.14751024654589939},{"$f":"'Calculated Data'!E8/'Data Sheet'!E17","v":0.15288285408389529},{"$f":"'Calculated Data'!F8/'Data Sheet'!F17","v":0.1509234751469386},{"$f":"'Calculated Data'!G8/'Data Sheet'!G17","v":0.10392063822899436},{"$f":"'Calculated Data'!H8/'Data Sheet'!H17","v":0.12048436424531851},{"$f":"'Calculated Data'!I8/'Data Sheet'!I17","v":0.12009156825118807},{"$f":"'Calculated Data'!J8/'Data Sheet'!J17","v":0.13059825680061951},{"$f":"'Calculated Data'!K8/'Data Sheet'!K17","v":0.13083035888418687}]
["Op Profit (Ex Other Income)/Sales",{"$f":"'Calculated Data'!B9/'Data Sheet'!B17","v":0.20074125773146254},{"$f":"'Calculated Data'!C9/'Data Sheet'!C17","v":0.18045257508912141},{"$f":"'Calculated Data'!D9/'Data Sheet'!D17","v":0.10699280312341015},{"$f":"'Calculated Data'!E9/'Data Sheet'!E17","v":0.14095870184037873},{"$f":"'Calculated Data'!F9/'Data Sheet'!F17","v":0.14088591335487136},{"$f":"'Calculated Data'!G9/'Data Sheet'!G17","v":8.678087264245074E-2},{"$f":"'Calculated Data'!H9/'Data Sheet'!H17","v":0.10402194043724768},{"$f":"'Calculated Data'!I9/'Data Sheet'!I17","v":0.11944762836941543},{"$f":"'Calculated Data'!J9/'Data Sheet'!J17","v":0.12844973884962022},{"$f":"'Calculated Data'!K9/'Data Sheet'!K17","v":0.12790802064210954}]
["Net Margin =PAT/Sales",{"$f":"'Calculated Data'!B10/'Data Sheet'!B17","v":0.11702486101417535},{"$f":"'Calculated Data'!C10/'Data Sheet'!C17","v":0.10129428160056668},{"$f":"'Calculated Data'!D10/'Data Sheet'!D17","v":1.753202581500769E-2},{"$f":"'Calculated Data'!E10/'Data Sheet'!E17","v":6.9043378543629713E-2},{"$f":"'Calculated Data'!F10/'Data Sheet'!F17","v":6.7392277451247512E-2},{"$f":"'Calculated Data'!G10/'Data Sheet'!G17","v":2.7507882518326025E-2},{"$f":"'Calculated Data'!H10/'Data Sheet'!H17","v":5.2009196250541061E-2},{"$f":"'Calculated Data'!I10/'Data Sheet'!I17","v":6.2127319793424084E-2},{"$f":"'Calculated Data'!J10/'Data Sheet'!J17","v":7.721483531873527E-2},{"$f":"'Calculated Data'!K10/'Data Sheet'!K17","v":8.2026691102037294E-2}]
["Op Cash Flow/Sales",{"$f":"'Calculated Data'!B19/'Data Sheet'!B17","v":0.10994921903203293},{"$f":"'Calculated Data'!C19/'Data Sheet'!C17","v":0.17466257054643167},{"$f":"'Calculated Data'!D19/'Data Sheet'!D17","v":9.9870239000325836E-2},{"$f":"'Calculated Data'!E19/'Data Sheet'!E17","v":8.7056459592346216E-2},{"$f":"'Calculated Data'!F19/'Data Sheet'!F17","v":0.1195457553228757},{"$f":"'Calculated Data'!G19/'Data Sheet'!G17","v":2.5188581767546644E-3},{"$f":"'Calculated Data'!H19/'Data Sheet'!H17","v":7.0703271906731854E-2},{"$f":"'Calculated Data'!I19/'Data Sheet'!I17","v":0.12736164951640114},{"$f":"'Calculated Data'!J19/'Data Sheet'!J17","v":8.1080190466775406E-2},{"$f":"'Calculated Data'!K19/'Data Sheet'!K17","v":9.2787334883245781E-2}]
["Free Cash Flow/Sales",{"$f":"'Calculated Data'!B21/'Data Sheet'!B17","v":0},{"$f":"'Calculated Data'!C21/'Data Sheet'!C17","v":-0.96066338669068907},{"$f":"'Calculated Data'!D21/'Data Sheet'!D17","v":-0.18547820072368901},{"$f":"'Calculated Data'!E21/'Data Sheet'!E17","v":0.17332135844001631},{"$f":"'Calculated Data'!F21/'Data Sheet'!F17","v":6.7757191234284336E-2},{"$f":"'Calculated Data'!G21/'Data Sheet'!G17","v":-0.14031547811741946},{"$f":"'Calculated Data'!H21/'Data Sheet'!H17","v":3.5905113995188927E-2},{"$f":"'Calculated Data'!I21/'Data Sheet'!I17","v":3.3903434775329436E-2},{"$f":"'Calculated Data'!J21/'Data Sheet'!J17","v":0.14904519466824839},{"$f":"'Calculated Data'!K21/'Data Sheet'!K17","v":2.3536586498425795E-2}]
["EPA/Sales",{"$f":"'Calculated Data'!B26/'Data Sheet'!B17","v":-3.4521417939684933E-2},{"$f":"'Calculated Data'!C26/'Data Sheet'!C17","v":-4.6661604349806811E-2},{"$f":"'Calculated Data'!D26/'Data Sheet'!D17","v":-0.13395638399161125},{"$f":"'Calculated Data'!E26/'Data Sheet'!E17","v":-7.0764306355815265E-2},{"$f":"'Calculated Data'!F26/'Data Sheet'!F17","v":-7.6347372597447602E-2},{"$f":"'Calculated Data'!G26/'Data Sheet'!G17","v":-0.13153332143665783},{"$f":"'Calculated Data'!H26/'Data Sheet'!H17","v":-4.5300049202223344E-2},{"$f":"'Calculated Data'!I26/'Data Sheet'!I17","v":-3.5564502668554279E-2},{"$f":"'Calculated Data'!J26/'Data Sheet'!J17","v":-1.7837412521877496E-2},{"$f":"'Calculated Data'!K26/'Data Sheet'!K17","v":-2.1517471743231292E-2}]
[]
["Sales/Invested Capital =Capital Turns",{"$f":"'Data Sheet'!B17/'Calculated Data'!B15","v":0.72332425210420481},{"$f":"'Data Sheet'!C17/'Calculated Data'!C15","v":0.65824844153869544},{"$f":"'Data Sheet'!D17/'Calculated Data'!D15","v":0.63104715800257549},{"$f":"'Data Sheet'!E17/'Calculated Data'!E15","v":0.73500190203405757},{"$f":"'Data Sheet'!F17/'Calculated Data'!F15","v":0.73849647510294436},{"$f":"'Data Sheet'!G17/'Calculated Data'!G15","v":0.65142809270830626},{"$f":"'Data Sheet'!H17/'Calculated Data'!H15","v":0.94348856515451762},{"$f":"'Data Sheet'!I17/'Calculated Data'!I15","v":0.94837768020177471},{"$f":"'Data Sheet'!J17/'Calculated Data'!J15","v":0.99606124759982295},{"$f":"'Data Sheet'!K17/'Calculated Data'!K15","v":0.99520005422275082}]
["Sales/Fixed Assets= Fixed Asset Turns",{"$f":"'Data Sheet'!B17/'Data Sheet'!B62","v":1.1639913718239627},{"$f":"'Data Sheet'!C17/'Data Sheet'!C62","v":0.61797410655234597},{"$f":"'Data Sheet'!D17/'Data Sheet'!D62","v":0.69789439249353713},{"$f":"'Data Sheet'!E17/'Data Sheet'!E62","v":0.87653777386384857},{"$f":"'Data Sheet'!F17/'Data Sheet'!F62","v":0.90829061339932826},{"$f":"'Data Sheet'!G17/'Data Sheet'!G62","v":0.90275069958485288},{"$f":"'Data Sheet'!H17/'Data Sheet'!H62","v":1.1209414422296813},{"$f":"'Data Sheet'!I17/'Data Sheet'!I62","v":1.1375058141025407},{"$f":"'Data Sheet'!J17/'Data Sheet'!J62","v":1.2417090505865553},{"$f":"'Data Sheet'!K17/'Data Sheet'!K62","v":1.2414547159514531}]
["Sales/Total Assets= Asset Turns",{"$f":"'Data Sheet'!B17/'Calculated Data'!B17","v":0.58615411743960499},{"$f":"'Data Sheet'!C17/'Calculated Data'!C17","v":0.49249011258195274},{"$f":"'Data Sheet'!D17/'Calculated Data'!D17","v":0.56399088262508179},{"$f":"'Data Sheet'!E17/'Calculated Data'!E17","v":0.64213729713174172},{"$f":"'Data Sheet'!F17/'Calculated Data'!F17","v":0.61804381950166298},{"$f":"'Data Sheet'!G17/'Calculated Data'!G17","v":0.55742766386097609},{"$f":"'Data Sheet'!H17/'Calculated Data'!H17","v":0.80471544854719301},{"$f":"'Data Sheet'!I17/'Calculated Data'!I17","v":0.81197991147874415},{"$f":"'Data Sheet'!J17/'Calculated Data'!J17","v":0.84488749310926614},{"$f":"'Data Sheet'!K17/'Calculated Data'!K17","v":0.83634268848384419}]
["Net Margin*Asset Turns= RoA",{"$f":"B39*B46","v":6.8594604126256384E-2},{"$f":"C39*C46","v":4.9886432149371107E-2},9.8879027136119062E-3,4.4335328482850073E-2,4.1651380560884813E-2,1.533365468995266E-2,4.1852603689333141E-2,5.0446135626276117E-2,6.523784864329106E-2,6.8602423363711695E-2,"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":9.1181848014626588E-2},0.17777417436895304,2.2233821216009513E-2,9.5553433238297208E-2,9.7355769230769246E-2,4.3380959374497333E-2,8.5543553742639902E-2,9.2262232061316882E-2,0.11218890942344706,0.10926192429971672,"Check back what is really driving RoE (Net Margins, Asset Turns, or Financial Leverage)"]
["RoCE",{"$f":"'Calculated Data'!B7/'Calculated Data'!B16","v":9.1738256838641299E-2},{"$f":"'Calculated Data'!C7/'Calculated Data'!C16","v":9.6851475025310496E-2},{"$f":"'Calculated Data'!D7/'Calculated Data'!D16","v":5.8370794415264667E-2},{"$f":"'Calculated Data'!E7/'Calculated Data'!E16","v":7.6941050444485182E-2},{"$f":"'Calculated Data'!F7/'Calculated Data'!F16","v":7.5826734659583894E-2},{"$f":"'Calculated Data'!G7/'Calculated Data'!G16","v":4.0964073141256593E-2},{"$f":"'Calculated Data'!H7/'Calculated Data'!H16","v":8.4008909579804947E-2},{"$f":"'Calculated Data'!I7/'Calculated Data'!I16","v":9.0632221402484003E-2},{"$f":"'Calculated Data'!J7/'Calculated Data'!J16","v":0.10389035967718155},{"$f":"'Calculated Data'!K7/'Calculated Data'!K16","v":0.10700025817917636}]
["EBIT Margin*Cap Turns*(1-Tax rate)= RoIC",{"$f":"B36*B44*(1-'Calculated Data'!B22)","v":9.50298211872007E-2},{"$f":"C36*C44*(1-'Calculated Data'!C22)","v":8.9285071657044468E-2},{"$f":"D36*D44*(1-'Calculated Data'!D22)","v":3.5467204585791993E-2},{"$f":"E36*E44*(1-'Calculated Data'!E22)","v":6.7988100232355034E-2},{"$f":"F36*F44*(1-'Calculated Data'!F22)","v":6.3617734453413816E-2},{"$f":"G36*G44*(1-'Calculated Data'!G22)","v":3.4315499288929414E-2},{"$f":"H36*H44*(1-'Calculated Data'!H22)","v":7.7259921576765228E-2},{"$f":"I36*I44*(1-'Calculated Data'!I22)","v":8.6271419461666665E-2},{"$f":"J36*J44*(1-'Calculated Data'!J22)","v":0.10223284462950599},{"$f":"K36*K44*(1-'Calculated Data'!K22)","v":9.8585810954399708E-2},"Check back what is really driving RoIC (Op Margins or Capital Turns, or both)"]
["Return on Incremental Invested Cap= RoIIC",null,null,{"$f":"'Calculated Data'!D27","v":-9.4450752053383727E-2},{"$f":"'Calculated Data'!E27","v":0.10509478786642959},{"$f":"'Calculated Data'!F27","v":5.7769906739018231E-2},{"$f":"'Calculated Data'!G27","v":-0.57279882574092666},{"$f":"'Calculated Data'!H27","v":0.16508190085920646},{"$f":"'Calculated Data'!I27","v":-0.10907859384338489},{"$f":"'Calculated Data'!J27","v":0.10061191195039197},{"$f":"'Calculated Data'!K27","v":-3.736050686439598E-2}]
[{"$f":"'Calculated Data'!A28","v":"3Yr Rolling RoIIC "},null,null,null,null,null,{"$f":"'Calculated Data'!G28","v":2.52676119276951E-2},{"$f":"'Calculated Data'!H28","v":7.0352730686560908E-2},{"$f":"'Calculated Data'!I28","v":0.3446890739293928},{"$f":"'Calculated Data'!J28","v":0.39172322639044765},{"$f":"'Calculated Data'!K28","v":-0.21494487873769019},"better to check if NOPLAT and/or Investments are Lumpy"]
[{"$f":"'Calculated Data'!A29","v":"5Yr Rolling RoIIC"},null,null,null,null,null,{"$f":"'Calculated Data'!G29","v":0},{"$f":"'Calculated Data'!H29","v":2.362362258944058E-2},{"$f":"'Calculated Data'!I29","v":0.18162266274445965},{"$f":"'Calculated Data'!J29","v":0.25691366512214625},{"$f":"'Calculated Data'!K29","v":0.39129712888954493},"better to check if NOPLAT and/or Investments are Lumpy"]
[]
["Altman Z-Score",{"$f":"'Calculated Data'!B48","v":2.7035809301307001},{"$f":"'Calculated Data'!C48","v":1.1445445119494613},{"$f":"'Calculated Data'!D48","v":0.99332315939183113},{"$f":"'Calculated Data'!E48","v":1.3585214812404898},{"$f":"'Calculated Data'!F48","v":1.2302158080201837},{"$f":"'Calculated Data'!G48","v":1.0428997751441036},{"$f":"'Calculated Data'!H48","v":1.3821519748990587},{"$f":"'Calculated Data'!I48","v":1.6090646612417552},{"$f":"'Calculated Data'!J48","v":1.7835029378570511},{"$f":"'Calculated Data'!K48","v":1.8131312108699253}]
["Dividend Payout",{"$f":"'Data Sheet'!B31/'Data Sheet'!B30","v":0},{"$f":"'Data Sheet'!C31/'Data Sheet'!C30","v":0},{"$f":"'Data Sheet'!D31/'Data Sheet'!D30","v":0},{"$f":"'Data Sheet'!E31/'Data Sheet'!E30","v":0},{"$f":"'Data Sheet'!F31/'Data Sheet'!F30","v":0},{"$f":"'Data Sheet'!G31/'Data Sheet'!G30","v":0},{"$f":"'Data Sheet'!H31/'Data Sheet'!H30","v":0},{"$f":"'Data Sheet'!I31/'Data Sheet'!I30","v":0},{"$f":"'Data Sheet'!J31/'Data Sheet'!J30","v":0},{"$f":"'Data Sheet'!K31/'Data Sheet'!K30","v":0}]
["Cash/Assets",{"$f":"'Data Sheet'!B69/'Data Sheet'!B61","v":0.22047610650678892},{"$f":"'Data Sheet'!C69/'Data Sheet'!C61","v":4.0160170484492962E-2},{"$f":"'Data Sheet'!D69/'Data Sheet'!D61","v":3.117252407496365E-2},{"$f":"'Data Sheet'!E69/'Data Sheet'!E61","v":4.2755065800834768E-2},{"$f":"'Data Sheet'!F69/'Data Sheet'!F61","v":9.7556428283605875E-2},{"$f":"'Data Sheet'!G69/'Data Sheet'!G61","v":0.16880368818520031},{"$f":"'Data Sheet'!H69/'Data Sheet'!H61","v":2.5724262176198345E-2},{"$f":"'Data Sheet'!I69/'Data Sheet'!I61","v":4.8710219682254176E-2},{"$f":"'Data Sheet'!J69/'Data Sheet'!J61","v":2.2337114188508204E-2},{"$f":"'Data Sheet'!K69/'Data Sheet'!K61","v":1.7841238608119304E-2}]
["EBIT/Invested Capital",{"$f":"'Calculated Data'!B7/'Calculated Data'!B15","v":0.10094090818093986},{"$f":"'Calculated Data'!C7/'Calculated Data'!C15","v":9.7937256094470626E-2},{"$f":"'Calculated Data'!D7/'Calculated Data'!D15","v":5.8409116324034963E-2},{"$f":"'Calculated Data'!E7/'Calculated Data'!E15","v":7.9825758762409826E-2},{"$f":"'Calculated Data'!F7/'Calculated Data'!F15","v":7.9448520693050098E-2},{"$f":"'Calculated Data'!G7/'Calculated Data'!G15","v":4.1911133836567374E-2},{"$f":"'Calculated Data'!H7/'Calculated Data'!H15","v":8.4084275078999515E-2},{"$f":"'Calculated Data'!I7/'Calculated Data'!I15","v":9.0777235613476892E-2},{"$f":"'Calculated Data'!J7/'Calculated Data'!J15","v":0.106392266916121},{"$f":"'Calculated Data'!K7/'Calculated Data'!K15","v":0.10980723195938225},"Check back the significant role of EBIT/Invested Capital "]
["EPA",{"$f":"'Calculated Data'!B26","v":-28.687988736236971},{"$f":"'Calculated Data'!C26","v":-60.603625113485585},{"$f":"'Calculated Data'!D26","v":-234.33927946340498},{"$f":"'Calculated Data'!E26","v":-139.46158732297715},{"$f":"'Calculated Data'!F26","v":-156.91522795208212},{"$f":"'Calculated Data'!G26","v":-296.60632450644903},{"$f":"'Calculated Data'!H26","v":-127.68000067843458},{"$f":"'Calculated Data'!I26","v":-110.45907754820936},{"$f":"'Calculated Data'!J26","v":-54.130303909515547},{"$f":"'Calculated Data'!K26","v":-69.507673797442607},"Check back what is really driving EPA (Invested Capital or RoIC, or both)"]
["MktCap",{"$f":"'Calculated Data'!B31","v":3285.0514394880001},{"$f":"'Calculated Data'!C31","v":1771.2122357800001},{"$f":"'Calculated Data'!D31","v":740.33996017799996},{"$f":"'Calculated Data'!E31","v":1319.8197721499998},{"$f":"'Calculated Data'!F31","v":835.00743489800004},{"$f":"'Calculated Data'!G31","v":420.43767563199998},{"$f":"'Calculated Data'!H31","v":705.02626107200001},{"$f":"'Calculated Data'!I31","v":1907.9532729600003},{"$f":"'Calculated Data'!J31","v":2100.8169702270002},{"$f":"'Calculated Data'!K31","v":2437.3999814400004}]
["MktCap Change",null,{"$f":"C60-B60","v":-1513.839203708},{"$f":"D60-C60","v":-1030.8722756020002},579.47981197199988,-484.81233725199979,-414.56975926600006,284.58858544000003,1202.9270118880004,192.86369726699991,336.58301121300019]
["MktCap Change - EPA",null,{"$f":"C61-C59","v":-1453.2355785945144},-796.53299613859519,718.94139929497703,-327.8971092999177,-117.96343475955103,412.2685861184346,1313.3860894362097,246.99400117651544,406.09068501044283]
[]
["Capex/Net Profits 10 yr",{"$f":"SUM('Calculated Data'!B$20:K$20)/SUM('Calculated Data'!B$10:K$10)","v":1.8384520499257808}]
["Capex/Net Profits 7 yr",{"$f":"SUM('Calculated Data'!E$20:K$20)/SUM('Calculated Data'!E$10:K$10)","v":0.56516227827640486}]
["Capex/Net Profits 5 yr",{"$f":"SUM('Calculated Data'!G$20:K$20)/SUM('Calculated Data'!G$10:K$10)","v":0.80798561390655677}]
["Capex/Net Profits 3 yr",{"$f":"SUM('Calculated Data'!I$20:K$20)/SUM('Calculated Data'!I$10:K$10)","v":0.44452148790176954}]
["Capex/Depreciation 10 yr",{"$f":"SUM('Calculated Data'!B$20:K$20)/SUM('Data Sheet'!B26:K26)","v":3.239096802711066}]

{"sheet":"Data Sheet","index":5,"n_rows":93,"n_cols":11,"rows_kept":93,"cut":false,"hidden":false,"merged":[[0,4,0,10],[1,4,1,10]]}
["COMPANY NAME","FIRSTSOURCE SOLUTIONS 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":67.803948896631823}]
["Face Value",10]
["Current Price",43.05]
["Market Capitalization",2918.96]
[]
[]
[]
[]
[]
["PROFIT & LOSS"]
["Report Date","2007-03-31","2008-03-31","2009-03-31","2010-03-31","2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31"]
["Sales",831.02,1298.79,1749.37,1970.79,2055.2800000000002,2254.9899999999998,2818.54,3105.88,3034.65,3230.29]
["Raw Material Cost"]
["Change in Inventory"]
["Power and Fuel",11.02,17.93,22.37,28.26,28.57,33.03,41.26,39.409999999999997,39.01,35.75]
["Other Mfr. Exp",49.91,62.16,114.32,77.489999999999995,17.59,18.2,91.33,101.81,114.36,125.32]
["Employee Cost",412.23,709.8,1025.28,1199.8699999999999,1268.26,1522.36,1934.87,2129.41,2017.15,2172.17]
["Selling and admin",184.52,268.27999999999997,343.58,382.4,446.17,480.38,452.42,462.21,465.42,471.25]
["Other Expenses",6.52,6.25,56.65,4.97,5.13,5.33,5.45,2.0499999999999998,8.92,12.63]
["Other Income",13.3,44.95,70.88,23.5,20.63,38.65,46.4,2,6.52,9.44]
["Depreciation",64.150000000000006,86.08,96.13,87.26,89.08,89.26,88.4,75.7,72.180000000000007,66.2]
["Interest",13.34,50.05,111.23,53.75,45.81,69.099999999999994,92,94.01,80.12,60.8]
["Profit before tax",102.63,143.19,50.69,160.29,175.3,75.98,159.19,203.28,244.02,295.62]
["Tax",6.01,12.65,19.91,23.77,34.93,13.77,12.92,10.09,9.5399999999999991,30.21]
["Net profit",97.25,131.56,30.67,136.07,138.51,62.03,146.59,192.96,234.32,264.97000000000003]
["Dividend Amount"]
[]
[]
[]
[]
[]
[]
[]
[]
["Quarters"]
["Report Date","2014-09-30","2014-12-31","2015-03-31","2015-06-30","2015-09-30","2015-12-31","2016-03-31","2016-06-30","2016-09-30","2016-12-31"]
["Sales",773.99,751.02,754.05,741.43,787.8,818.6,869.43,893.54,884.35,885.41]
["Expenses",679.11,657.47,654.75,657.3,694.26,717.29,758,774.31,771.78,778.24]
["Other Income",4.7,2.4700000000000002,0.38,4.54,0.92,2.06,1.93,1.86,0.39,1.41]
["Depreciation",17.73,18.93,17.98,17.21,18.3,15.99,14.7,16.3,16.05,15.57]
["Interest",18.07,17.27,17.37,14.27,13.06,12.45,12.97,13.16,10.86,9.8800000000000008]
["Profit before tax",63.77,59.83,64.319999999999993,57.19,63.09,74.92,85.69,91.64,86.06,83.12]
["Tax",2.4700000000000002,2.12,2.17,4.17,4.29,7.29,9.5399999999999991,18.27,14.86,13.36]
["Net profit",61.24,57.51,62.32,52.87,58.66,67.45,76.2,73.36,71.260000000000005,70.010000000000005]
["Operating Profit",94.88,93.55,99.3,84.13,93.54,101.31,111.43,119.23,112.57,107.17]
[]
[]
[]
[]
["BALANCE SHEET"]
["Report Date","2007-03-31","2008-03-31","2009-03-31","2010-03-31","2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31"]
["Equity Share Capital",425.08,427.31,428.19,429.21,430.64,430.78,657.67,659.74,666.29,673.32]
["Reserves",641.47,312.73,951.24,994.81,992.08,999.11,1055.96,1431.69,1422.33,1751.77]
["Borrowings",197.59,1255.18,1394.56,1357.85,1493.27,2111.75,1276.4100000000001,1188.75,1031.4000000000001,905.93]
["Other Liabilities",153.61000000000001,641.97,327.78,287.24,409.47,503.71,512.49,544.89,471.76,531.38]
["Total",1417.75,2637.19,3101.77,3069.11,3325.46,4045.35,3502.53,3825.07,3591.78,3862.4]
["Net Block",713.94,2101.69,2506.64,2248.38,2262.8000000000002,2497.91,2514.44,2730.43,2443.9299999999998,2602.02]
["Capital Work in Progress",8.1999999999999993,8.92,7.02,8.01,10.95,8.67,1.82,0.4,8.4700000000000006,7.88]
["Investments",115.25,22.12,1.82,100.53,132.93,80.03,2.68,5.24,73.37,85.15]
["Other Assets",580.36,504.46,586.29,712.19,918.78,1458.74,983.59,1089,1066.01,1167.3499999999999]
["Total",1417.75,2637.19,3101.77,3069.11,3325.46,4045.35,3502.53,3825.07,3591.78,3862.4]
["Receivables",133.54,205.38,237.95,261.06,238.87,351.47,386.58,301.93,288.95,304.08]
["Inventory"]
["Cash & Bank",312.58,105.91,96.69,131.22,324.42,682.87,90.1,186.32,80.23,68.91]
["No. of Equity Shares",425084296,427312964,428189682,429209682,430638182,430776307,657673751,659734880,666291459,673314912]
["New Bonus Shares"]
["Face value",10,10,10,10,10,10,10,10,10,10]
[]
[]
[]
[]
[]
[]
[]
["CASH FLOW:"]
["Report Date","2007-03-31","2008-03-31","2009-03-31","2010-03-31","2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31"]
["Cash from Operating Activity",91.37,226.85,174.71,171.57,245.7,5.68,199.28,395.57,246.05,299.73]
["Cash from Investing Activity",-404.63,-1415.23,-88.03,-147.22,-59.69,-475.73,583.34,-13.28,-104.24,-103.69]
["Cash from Financing Activity",597.23,989.85,-92.45,0.71,16.86,332.81,-881.06,-286.41000000000003,-246.45,-207.44]
["Net Cash Flow",283.97000000000003,-198.53,-5.77,25.06,202.87,-137.24,-98.44,95.88,-104.64,-11.41]
[]
[]
[]
[]
["PRICE:",77.28,41.45,17.29,30.75,19.39,9.76,10.72,28.92,31.53,36.200000000000003]
[]
["DERIVED:"]
["Adjusted Equity Shares in Cr",{"$f":"IF($B7>0,(B70*B72/$B7)+SUM(C71:$K71),0)/10000000","v":42.508429599999999},{"$f":"IF($B7>0,(C70*C72/$B7)+SUM(D71:$K71),0)/10000000","v":42.731296399999998},{"$f":"IF($B7>0,(D70*D72/$B7)+SUM(E71:$K71),0)/10000000","v":42.8189682},{"$f":"IF($B7>0,(E70*E72/$B7)+SUM(F71:$K71),0)/10000000","v":42.920968199999997},{"$f":"IF($B7>0,(F70*F72/$B7)+SUM(G71:$K71),0)/10000000","v":43.0638182},{"$f":"IF($B7>0,(G70*G72/$B7)+SUM(H71:$K71),0)/10000000","v":43.0776307},{"$f":"IF($B7>0,(H70*H72/$B7)+SUM(I71:$K71),0)/10000000","v":65.767375099999995},{"$f":"IF($B7>0,(I70*I72/$B7)+SUM(J71:$K71),0)/10000000","v":65.973488000000003},{"$f":"IF($B7>0,(J70*J72/$B7)+SUM(K71:$K71),0)/10000000","v":66.629145899999997},{"$f":"IF($B7>0,(K70*K72/$B7),0)/10000000","v":67.331491200000002}]

{"sheet":"Calculated Data","index":6,"n_rows":51,"n_cols":13,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Data Sheet'!B1","v":"FIRSTSOURCE SOLUTIONS LTD"}]
[{"$f":"A5","v":"FIRSTSOURCE SOLUTIONS LTD"},{"$f":"B5","v":"2007-03-31"},{"$f":"C5","v":"2008-03-31"},"2009-03-31","2010-03-31","2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31"]
["Payables (Creditors)",null,null,null,null,null,null,null,null,null,null,"Input data from Annual Reports"]
[]
[{"$f":"A1","v":"FIRSTSOURCE SOLUTIONS LTD"},{"$f":"'Data Sheet'!B16","v":"2007-03-31"},{"$f":"'Data Sheet'!C16","v":"2008-03-31"},{"$f":"'Data Sheet'!D16","v":"2009-03-31"},{"$f":"'Data Sheet'!E16","v":"2010-03-31"},{"$f":"'Data Sheet'!F16","v":"2011-03-31"},{"$f":"'Data Sheet'!G16","v":"2012-03-31"},{"$f":"'Data Sheet'!H16","v":"2013-03-31"},{"$f":"'Data Sheet'!I16","v":"2014-03-31"},{"$f":"'Data Sheet'!J16","v":"2015-03-31"},{"$f":"'Data Sheet'!K16","v":"2016-03-31"}]
["Gross Profit",{"$f":"'Data Sheet'!B17-'Data Sheet'!B18","v":831.02},{"$f":"'Data Sheet'!C17-'Data Sheet'!C18","v":1298.79},{"$f":"'Data Sheet'!D17-'Data Sheet'!D18","v":1749.37},{"$f":"'Data Sheet'!E17-'Data Sheet'!E18","v":1970.79},{"$f":"'Data Sheet'!F17-'Data Sheet'!F18","v":2055.2800000000002},{"$f":"'Data Sheet'!G17-'Data Sheet'!G18","v":2254.9899999999998},{"$f":"'Data Sheet'!H17-'Data Sheet'!H18","v":2818.54},{"$f":"'Data Sheet'!I17-'Data Sheet'!I18","v":3105.88},{"$f":"'Data Sheet'!J17-'Data Sheet'!J18","v":3034.65},{"$f":"'Data Sheet'!K17-'Data Sheet'!K18","v":3230.29}]
["EBIT",{"$f":"'Data Sheet'!B28+'Data Sheet'!B27","v":115.97},{"$f":"'Data Sheet'!C28+'Data Sheet'!C27","v":193.24},{"$f":"'Data Sheet'!D28+'Data Sheet'!D27","v":161.92000000000002},{"$f":"'Data Sheet'!E28+'Data Sheet'!E27","v":214.04},{"$f":"'Data Sheet'!F28+'Data Sheet'!F27","v":221.11},{"$f":"'Data Sheet'!G28+'Data Sheet'!G27","v":145.07999999999998},{"$f":"'Data Sheet'!H28+'Data Sheet'!H27","v":251.19},{"$f":"'Data Sheet'!I28+'Data Sheet'!I27","v":297.29000000000002},{"$f":"'Data Sheet'!J28+'Data Sheet'!J27","v":324.14},{"$f":"'Data Sheet'!K28+'Data Sheet'!K27","v":356.42}]
["EBITDA",{"$f":"'Calculated Data'!B7+'Data Sheet'!B26","v":180.12},{"$f":"'Calculated Data'!C7+'Data Sheet'!C26","v":279.32},{"$f":"'Calculated Data'!D7+'Data Sheet'!D26","v":258.05},{"$f":"'Calculated Data'!E7+'Data Sheet'!E26","v":301.3},{"$f":"'Calculated Data'!F7+'Data Sheet'!F26","v":310.19},{"$f":"'Calculated Data'!G7+'Data Sheet'!G26","v":234.33999999999997},{"$f":"'Calculated Data'!H7+'Data Sheet'!H26","v":339.59000000000003},{"$f":"'Calculated Data'!I7+'Data Sheet'!I26","v":372.99},{"$f":"'Calculated Data'!J7+'Data Sheet'!J26","v":396.32},{"$f":"'Calculated Data'!K7+'Data Sheet'!K26","v":422.62}]
["Operating Profit (excl Other Income)",{"$f":"B8-'Data Sheet'!B25","v":166.82},{"$f":"C8-'Data Sheet'!C25","v":234.37},{"$f":"D8-'Data Sheet'!D25","v":187.17000000000002},{"$f":"E8-'Data Sheet'!E25","v":277.8},{"$f":"F8-'Data Sheet'!F25","v":289.56},{"$f":"G8-'Data Sheet'!G25","v":195.68999999999997},{"$f":"H8-'Data Sheet'!H25","v":293.19000000000005},{"$f":"I8-'Data Sheet'!I25","v":370.99},{"$f":"J8-'Data Sheet'!J25","v":389.8},{"$f":"K8-'Data Sheet'!K25","v":413.18}]
["PAT",{"$f":"'Data Sheet'!B30","v":97.25},{"$f":"'Data Sheet'!C30","v":131.56},{"$f":"'Data Sheet'!D30","v":30.67},{"$f":"'Data Sheet'!E30","v":136.07},{"$f":"'Data Sheet'!F30","v":138.51},{"$f":"'Data Sheet'!G30","v":62.03},{"$f":"'Data Sheet'!H30","v":146.59},{"$f":"'Data Sheet'!I30","v":192.96},{"$f":"'Data Sheet'!J30","v":234.32},{"$f":"'Data Sheet'!K30","v":264.97000000000003}]
["Dividend",{"$f":"'Data Sheet'!B31","v":0},{"$f":"'Data Sheet'!C31","v":0},{"$f":"'Data Sheet'!D31","v":0},{"$f":"'Data Sheet'!E31","v":0},{"$f":"'Data Sheet'!F31","v":0},{"$f":"'Data Sheet'!G31","v":0},{"$f":"'Data Sheet'!H31","v":0},{"$f":"'Data Sheet'!I31","v":0},{"$f":"'Data Sheet'!J31","v":0},{"$f":"'Data Sheet'!K31","v":0}]
[null,{"$f":"B5","v":"2007-03-31"},{"$f":"C5","v":"2008-03-31"},{"$f":"D5","v":"2009-03-31"},{"$f":"E5","v":"2010-03-31"},{"$f":"F5","v":"2011-03-31"},{"$f":"G5","v":"2012-03-31"},{"$f":"H5","v":"2013-03-31"},{"$f":"I5","v":"2014-03-31"},{"$f":"J5","v":"2015-03-31"},{"$f":"K5","v":"2016-03-31"}]
["Networth",{"$f":"'Data Sheet'!B57+'Data Sheet'!B58","v":1066.55},{"$f":"'Data Sheet'!C57+'Data Sheet'!C58","v":740.04},{"$f":"'Data Sheet'!D57+'Data Sheet'!D58","v":1379.43},{"$f":"'Data Sheet'!E57+'Data Sheet'!E58","v":1424.02},{"$f":"'Data Sheet'!F57+'Data Sheet'!F58","v":1422.72},{"$f":"'Data Sheet'!G57+'Data Sheet'!G58","v":1429.8899999999999},{"$f":"'Data Sheet'!H57+'Data Sheet'!H58","v":1713.63},{"$f":"'Data Sheet'!I57+'Data Sheet'!I58","v":2091.4300000000003},{"$f":"'Data Sheet'!J57+'Data Sheet'!J58","v":2088.62},{"$f":"'Data Sheet'!K57+'Data Sheet'!K58","v":2425.09}]
["Working Capital",{"$f":"'Data Sheet'!B65-'Data Sheet'!B60","v":426.75},{"$f":"'Data Sheet'!C65-'Data Sheet'!C60","v":-137.51000000000005},{"$f":"'Data Sheet'!D65-'Data Sheet'!D60","v":258.51},{"$f":"'Data Sheet'!E65-'Data Sheet'!E60","v":424.95000000000005},{"$f":"'Data Sheet'!F65-'Data Sheet'!F60","v":509.30999999999995},{"$f":"'Data Sheet'!G65-'Data Sheet'!G60","v":955.03},{"$f":"'Data Sheet'!H65-'Data Sheet'!H60","v":471.1},{"$f":"'Data Sheet'!I65-'Data Sheet'!I60","v":544.11},{"$f":"'Data Sheet'!J65-'Data Sheet'!J60","v":594.25},{"$f":"'Data Sheet'!K65-'Data Sheet'!K60","v":635.96999999999991}]
["Invested Capital",{"$f":"'Data Sheet'!B62+'Data Sheet'!B63+'Calculated Data'!B14","v":1148.8900000000001},{"$f":"'Data Sheet'!C62+'Data Sheet'!C63+'Calculated Data'!C14","v":1973.1000000000001},{"$f":"'Data Sheet'!D62+'Data Sheet'!D63+'Calculated Data'!D14","v":2772.17},{"$f":"'Data Sheet'!E62+'Data Sheet'!E63+'Calculated Data'!E14","v":2681.34},{"$f":"'Data Sheet'!F62+'Data Sheet'!F63+'Calculated Data'!F14","v":2783.06},{"$f":"'Data Sheet'!G62+'Data Sheet'!G63+'Calculated Data'!G14","v":3461.6099999999997},{"$f":"'Data Sheet'!H62+'Data Sheet'!H63+'Calculated Data'!H14","v":2987.36},{"$f":"'Data Sheet'!I62+'Data Sheet'!I63+'Calculated Data'!I14","v":3274.94},{"$f":"'Data Sheet'!J62+'Data Sheet'!J63+'Calculated Data'!J14","v":3046.6499999999996},{"$f":"'Data Sheet'!K62+'Data Sheet'!K63+'Calculated Data'!K14","v":3245.87}]
["Capital Employed",{"$f":"B13+'Data Sheet'!B59","v":1264.1399999999999},{"$f":"C13+'Data Sheet'!C59","v":1995.22},{"$f":"D13+'Data Sheet'!D59","v":2773.99},{"$f":"E13+'Data Sheet'!E59","v":2781.87},{"$f":"F13+'Data Sheet'!F59","v":2915.99},{"$f":"G13+'Data Sheet'!G59","v":3541.64},{"$f":"H13+'Data Sheet'!H59","v":2990.04},{"$f":"I13+'Data Sheet'!I59","v":3280.1800000000003},{"$f":"J13+'Data Sheet'!J59","v":3120.02},{"$f":"K13+'Data Sheet'!K59","v":3331.02}]
["Total Assets",{"$f":"'Data Sheet'!B61","v":1417.75},{"$f":"'Data Sheet'!C61","v":2637.19},{"$f":"'Data Sheet'!D61","v":3101.77},{"$f":"'Data Sheet'!E61","v":3069.11},{"$f":"'Data Sheet'!F61","v":3325.46},{"$f":"'Data Sheet'!G61","v":4045.35},{"$f":"'Data Sheet'!H61","v":3502.53},{"$f":"'Data Sheet'!I61","v":3825.07},{"$f":"'Data Sheet'!J61","v":3591.78},{"$f":"'Data Sheet'!K61","v":3862.4}]
[null,{"$f":"B5","v":"2007-03-31"},{"$f":"C5","v":"2008-03-31"},{"$f":"D5","v":"2009-03-31"},{"$f":"E5","v":"2010-03-31"},{"$f":"F5","v":"2011-03-31"},{"$f":"G5","v":"2012-03-31"},{"$f":"H5","v":"2013-03-31"},{"$f":"I5","v":"2014-03-31"},{"$f":"J5","v":"2015-03-31"},{"$f":"K5","v":"2016-03-31"}]
["Operating Cash Flow",{"$f":"'Data Sheet'!B82","v":91.37},{"$f":"'Data Sheet'!C82","v":226.85},{"$f":"'Data Sheet'!D82","v":174.71},{"$f":"'Data Sheet'!E82","v":171.57},{"$f":"'Data Sheet'!F82","v":245.7},{"$f":"'Data Sheet'!G82","v":5.68},{"$f":"'Data Sheet'!H82","v":199.28},{"$f":"'Data Sheet'!I82","v":395.57},{"$f":"'Data Sheet'!J82","v":246.05},{"$f":"'Data Sheet'!K82","v":299.73}]
["Capex",null,{"$f":"('Data Sheet'!C62-'Data Sheet'!B62)+('Data Sheet'!C63-'Data Sheet'!B63)+'Data Sheet'!C26","v":1474.55},{"$f":"('Data Sheet'!D62-'Data Sheet'!C62)+('Data Sheet'!D63-'Data Sheet'!C63)+'Data Sheet'!D26","v":499.17999999999984},{"$f":"('Data Sheet'!E62-'Data Sheet'!D62)+('Data Sheet'!E63-'Data Sheet'!D63)+'Data Sheet'!E26","v":-170.00999999999976},{"$f":"('Data Sheet'!F62-'Data Sheet'!E62)+('Data Sheet'!F63-'Data Sheet'!E63)+'Data Sheet'!F26","v":106.44000000000007},{"$f":"('Data Sheet'!G62-'Data Sheet'!F62)+('Data Sheet'!G63-'Data Sheet'!F63)+'Data Sheet'!G26","v":322.08999999999969},{"$f":"('Data Sheet'!H62-'Data Sheet'!G62)+('Data Sheet'!H63-'Data Sheet'!G63)+'Data Sheet'!H26","v":98.080000000000211},{"$f":"('Data Sheet'!I62-'Data Sheet'!H62)+('Data Sheet'!I63-'Data Sheet'!H63)+'Data Sheet'!I26","v":290.26999999999981},{"$f":"('Data Sheet'!J62-'Data Sheet'!I62)+('Data Sheet'!J63-'Data Sheet'!I63)+'Data Sheet'!J26","v":-206.25},{"$f":"('Data Sheet'!K62-'Data Sheet'!J62)+('Data Sheet'!K63-'Data Sheet'!J63)+'Data Sheet'!K26","v":223.70000000000016},"CHECK?","derived from BS"]
["Free Cash Flow",null,{"$f":"C19-C20","v":-1247.7},{"$f":"D19-D20","v":-324.4699999999998},341.57999999999976,139.25999999999993,-316.40999999999968,101.19999999999979,105.30000000000018,452.3,76.029999999999859]
["Tax Rate",{"$f":"'Data Sheet'!B29/'Data Sheet'!B28","v":5.8559875280132519E-2},{"$f":"'Data Sheet'!C29/'Data Sheet'!C28","v":8.8344158111599971E-2},{"$f":"'Data Sheet'!D29/'Data Sheet'!D28","v":0.39277964095482348},{"$f":"'Data Sheet'!E29/'Data Sheet'!E28","v":0.14829371763678334},{"$f":"'Data Sheet'!F29/'Data Sheet'!F28","v":0.19925841414717627},{"$f":"'Data Sheet'!G29/'Data Sheet'!G28","v":0.18123190313240325},{"$f":"'Data Sheet'!H29/'Data Sheet'!H28","v":8.1160876939506257E-2},{"$f":"'Data Sheet'!I29/'Data Sheet'!I28","v":4.9635970090515541E-2},{"$f":"'Data Sheet'!J29/'Data Sheet'!J28","v":3.9095156134743049E-2},{"$f":"'Data Sheet'!K29/'Data Sheet'!K28","v":0.10219200324741222}]
["NOPLAT",{"$f":"B7*(1-B22)","v":109.17881126376304},176.16837488651441,98.321120536595004,182.29921267702289,177.05197204791787,118.78687549355092,230.80319932156542,282.53372245179065,311.46769609048437,319.99672620255734]
["RoIC",{"$f":"(B7/B15)*(1-B22)","v":9.5029821187200714E-2},{"$f":"(C7/C15)*(1-C22)","v":8.9285071657044454E-2},3.5467204585791993E-2,6.7988100232355034E-2,6.3617734453413816E-2,3.4315499288929407E-2,7.7259921576765242E-2,8.6271419461666665E-2,0.10223284462950599,9.8585810954399708E-2]
["WACC",0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12]
["EPA (Economic Profit Added)",{"$f":"B15*(B24-B25)","v":-28.687988736236971},{"$f":"C15*(C24-C25)","v":-60.603625113485585},-234.33927946340498,-139.46158732297715,-156.91522795208212,-296.60632450644903,-127.68000067843458,-110.45907754820936,-54.130303909515547,-69.507673797442607]
["RoIIC",null,null,{"$f":"(D23-C23)/(C15-B15)","v":-9.4450752053383727E-2},{"$f":"(E23-D23)/(D15-C15)","v":0.10509478786642959},5.7769906739018231E-2,-0.57279882574092666,0.16508190085920646,-0.10907859384338489,0.10061191195039197,-3.736050686439598E-2]
["3Yr Rolling RoIIC ",null,null,null,null,null,{"$f":"(G23-D23)/(F15-C15)","v":2.52676119276951E-2},7.0352730686560908E-2,0.3446890739293928,0.39172322639044765,{"$f":"(K23-H23)/(J15-G15)","v":-0.21494487873769019}]
["5Yr Rolling RoIIC",null,null,null,null,null,null,{"$f":"(H23-C23)/(G15-B15)","v":2.362362258944058E-2},{"$f":"(I23-D23)/(H15-C15)","v":0.18162266274445965},0.25691366512214625,{"$f":"(K23-F23)/(J15-E15)","v":0.39129712888954493}]
[null,{"$f":"B5","v":"2007-03-31"},{"$f":"C5","v":"2008-03-31"},{"$f":"D5","v":"2009-03-31"},{"$f":"E5","v":"2010-03-31"},{"$f":"F5","v":"2011-03-31"},{"$f":"G5","v":"2012-03-31"},{"$f":"H5","v":"2013-03-31"},{"$f":"I5","v":"2014-03-31"},{"$f":"J5","v":"2015-03-31"},{"$f":"K5","v":"2016-03-31"},"CURRENT"]
["MktCap",{"$f":"'Data Sheet'!B90*'Data Sheet'!B93","v":3285.0514394880001},{"$f":"'Data Sheet'!C90*'Data Sheet'!C93","v":1771.2122357800001},{"$f":"'Data Sheet'!D90*'Data Sheet'!D93","v":740.33996017799996},{"$f":"'Data Sheet'!E90*'Data Sheet'!E93","v":1319.8197721499998},{"$f":"'Data Sheet'!F90*'Data Sheet'!F93","v":835.00743489800004},{"$f":"'Data Sheet'!G90*'Data Sheet'!G93","v":420.43767563199998},{"$f":"'Data Sheet'!H90*'Data Sheet'!H93","v":705.02626107200001},{"$f":"'Data Sheet'!I90*'Data Sheet'!I93","v":1907.9532729600003},{"$f":"'Data Sheet'!J90*'Data Sheet'!J93","v":2100.8169702270002},{"$f":"'Data Sheet'!K90*'Data Sheet'!K93","v":2437.3999814400004},{"$f":"'Data Sheet'!B9","v":2918.96}]
["MktCap+Dividend",{"$f":"B31+'Data Sheet'!B31","v":3285.0514394880001},{"$f":"C31+'Data Sheet'!C31","v":1771.2122357800001},{"$f":"D31+'Data Sheet'!D31","v":740.33996017799996},{"$f":"E31+'Data Sheet'!E31","v":1319.8197721499998},{"$f":"F31+'Data Sheet'!F31","v":835.00743489800004},{"$f":"G31+'Data Sheet'!G31","v":420.43767563199998},{"$f":"H31+'Data Sheet'!H31","v":705.02626107200001},{"$f":"I31+'Data Sheet'!I31","v":1907.9532729600003},{"$f":"J31+'Data Sheet'!J31","v":2100.8169702270002},{"$f":"K31+'Data Sheet'!K31","v":2437.3999814400004}]
["Retained Profit",{"$f":"'Data Sheet'!B30-'Data Sheet'!B31","v":97.25},{"$f":"'Data Sheet'!C30-'Data Sheet'!C31","v":131.56},{"$f":"'Data Sheet'!D30-'Data Sheet'!D31","v":30.67},{"$f":"'Data Sheet'!E30-'Data Sheet'!E31","v":136.07},{"$f":"'Data Sheet'!F30-'Data Sheet'!F31","v":138.51},{"$f":"'Data Sheet'!G30-'Data Sheet'!G31","v":62.03},{"$f":"'Data Sheet'!H30-'Data Sheet'!H31","v":146.59},{"$f":"'Data Sheet'!I30-'Data Sheet'!I31","v":192.96},{"$f":"'Data Sheet'!J30-'Data Sheet'!J31","v":234.32},{"$f":"'Data Sheet'!K30-'Data Sheet'!K31","v":264.97000000000003}]
["EV",{"$f":"B31+'Data Sheet'!B59-'Data Sheet'!B69","v":3170.0614394880004},{"$f":"C31+'Data Sheet'!C59-'Data Sheet'!C69","v":2920.4822357800003},{"$f":"D31+'Data Sheet'!D59-'Data Sheet'!D69","v":2038.2099601779996},{"$f":"E31+'Data Sheet'!E59-'Data Sheet'!E69","v":2546.4497721499997},{"$f":"F31+'Data Sheet'!F59-'Data Sheet'!F69","v":2003.8574348980001},{"$f":"G31+'Data Sheet'!G59-'Data Sheet'!G69","v":1849.3176756319999},{"$f":"H31+'Data Sheet'!H59-'Data Sheet'!H69","v":1891.3362610720001},{"$f":"I31+'Data Sheet'!I59-'Data Sheet'!I69","v":2910.3832729600003},{"$f":"J31+'Data Sheet'!J59-'Data Sheet'!J69","v":3051.9869702270003},{"$f":"K31+'Data Sheet'!K59-'Data Sheet'!K69","v":3274.4199814400004}]
[null,{"$f":"B5","v":"2007-03-31"},{"$f":"C5","v":"2008-03-31"},{"$f":"D5","v":"2009-03-31"},{"$f":"E5","v":"2010-03-31"},{"$f":"F5","v":"2011-03-31"},{"$f":"G5","v":"2012-03-31"},{"$f":"H5","v":"2013-03-31"},{"$f":"I5","v":"2014-03-31"},{"$f":"J5","v":"2015-03-31"},{"$f":"K5","v":"2016-03-31"}]
["Price/Earnings",{"$f":"B31/'Data Sheet'!B30","v":33.779449249233934},{"$f":"C31/'Data Sheet'!C30","v":13.463151685770752},{"$f":"D31/'Data Sheet'!D30","v":24.138896647473096},{"$f":"E31/'Data Sheet'!E30","v":9.6995647251414709},{"$f":"F31/'Data Sheet'!F30","v":6.0284992772940589},{"$f":"G31/'Data Sheet'!G30","v":6.7779731683379003},{"$f":"H31/'Data Sheet'!H30","v":4.8095112973054093},{"$f":"I31/'Data Sheet'!I30","v":9.887817542288559},{"$f":"J31/'Data Sheet'!J30","v":8.9655896646765125},{"$f":"K31/'Data Sheet'!K30","v":9.1987771500169835}]
["Price/Book",{"$f":"B31/B13","v":3.0800726074614415},2.3934006753418737,0.53669991241164827,0.92682671040434816,0.58690918444809947,0.29403497865709949,0.41142268813687899,0.91227211666658703,1.0058397268181862,1.0050760926151194]
["Price/CashFlow",{"$f":"B31/B19","v":35.953282691124002},7.8078564504298003,4.2375362611069765,7.6926022739989506,3.398483658518519,74.020717540845069,3.5378676288237654,4.8233012436736873,8.5381709824304011,8.1319853916524885]
["Price/Sales",{"$f":"B31/'Data Sheet'!B17","v":3.9530353535269911},{"$f":"C31/'Data Sheet'!C17","v":1.3637402780896066},{"$f":"D31/'Data Sheet'!D17","v":0.42320375916930097},{"$f":"E31/'Data Sheet'!E17","v":0.66969071902638022},{"$f":"F31/'Data Sheet'!F17","v":0.40627429591004632},{"$f":"G31/'Data Sheet'!G17","v":0.186447689627005},{"$f":"H31/'Data Sheet'!H17","v":0.25013881693075141},{"$f":"I31/'Data Sheet'!I17","v":0.61430360250878979},{"$f":"J31/'Data Sheet'!J17","v":0.69227652949335183},{"$f":"K31/'Data Sheet'!K17","v":0.75454525180092202}]
["EV/EBITDA",{"$f":"B34/B8","v":17.599719295403066},10.455686079693542,7.8985078867583782,8.4515425560902742,6.4600968274219026,7.8916005617137497,5.569469834423864,7.8028453120995209,7.7008149228577922,7.7479058762954907]
["Dividend Yield",{"$f":"'Data Sheet'!B31/'Calculated Data'!B31","v":0},{"$f":"'Data Sheet'!C31/'Calculated Data'!C31","v":0},{"$f":"'Data Sheet'!D31/'Calculated Data'!D31","v":0},{"$f":"'Data Sheet'!E31/'Calculated Data'!E31","v":0},{"$f":"'Data Sheet'!F31/'Calculated Data'!F31","v":0},{"$f":"'Data Sheet'!G31/'Calculated Data'!G31","v":0},{"$f":"'Data Sheet'!H31/'Calculated Data'!H31","v":0},{"$f":"'Data Sheet'!I31/'Calculated Data'!I31","v":0},{"$f":"'Data Sheet'!J31/'Calculated Data'!J31","v":0},{"$f":"'Data Sheet'!K31/'Calculated Data'!K31","v":0}]
[null,{"$f":"B5","v":"2007-03-31"},{"$f":"C5","v":"2008-03-31"},{"$f":"D5","v":"2009-03-31"},{"$f":"E5","v":"2010-03-31"},{"$f":"F5","v":"2011-03-31"},{"$f":"G5","v":"2012-03-31"},{"$f":"H5","v":"2013-03-31"},{"$f":"I5","v":"2014-03-31"},{"$f":"J5","v":"2015-03-31"},{"$f":"K5","v":"2016-03-31"},"Z-Weights"]
["Working Capital/Total Assets",{"$f":"B14/B17","v":0.30100511373655442},-5.2142621502432533E-2,8.3342736566541037E-2,0.13846033540668143,0.15315475152309754,0.23608093242859085,0.13450277370929015,0.14224837715388214,0.16544721558670072,0.16465669014084505,1.2]
["Retained Profits/Total Assets",{"$f":"B33/B17","v":6.8594604126256398E-2},4.9886432149371114E-2,9.8879027136119062E-3,4.4335328482850073E-2,4.1651380560884806E-2,1.5333654689952663E-2,4.1852603689333134E-2,5.0446135626276117E-2,6.523784864329106E-2,6.8602423363711681E-2,1.4]
["EBIT/Total Assets",{"$f":"B7/B17","v":8.1798624581202614E-2},7.3274963123627801E-2,5.220245214828953E-2,6.9740087517228114E-2,6.6490049496911716E-2,3.586339871704549E-2,7.1716730477683274E-2,7.772145346359674E-2,9.0244948187249763E-2,9.2279411764705888E-2,3.3]
["Market Cap/Total Liabilities",{"$f":"B31/B17","v":2.3170879488541702},{"$f":"C31/C17","v":0.67162860308889394},0.2386830616641466,0.43003338822981246,0.25109531760959386,0.10393110006105775,0.2012905702654938,0.49880218478616084,0.58489578154202093,0.63105840447390227,0.6]
["Sales/Total Assets",{"$f":"'Data Sheet'!B17/'Calculated Data'!B17","v":0.58615411743960499},{"$f":"'Data Sheet'!C17/'Calculated Data'!C17","v":0.49249011258195274},{"$f":"'Data Sheet'!D17/'Calculated Data'!D17","v":0.56399088262508179},{"$f":"'Data Sheet'!E17/'Calculated Data'!E17","v":0.64213729713174172},{"$f":"'Data Sheet'!F17/'Calculated Data'!F17","v":0.61804381950166298},{"$f":"'Data Sheet'!G17/'Calculated Data'!G17","v":0.55742766386097609},{"$f":"'Data Sheet'!H17/'Calculated Data'!H17","v":0.80471544854719301},{"$f":"'Data Sheet'!I17/'Calculated Data'!I17","v":0.81197991147874415},{"$f":"'Data Sheet'!J17/'Calculated Data'!J17","v":0.84488749310926614},{"$f":"'Data Sheet'!K17/'Calculated Data'!K17","v":0.83634268848384419},1]
["Altman Z-Score",{"$f":"$L$43*B43+$L$44*B44+$L$45*B45+$L$46*B46+$L$47*B47","v":2.7035809301307001},{"$f":"$L$43*C43+$L$44*C44+$L$45*C45+$L$46*C46+$L$47*C47","v":1.1445445119494613},0.99332315939183113,1.3585214812404898,1.2302158080201837,1.0428997751441036,1.3821519748990587,1.6090646612417552,1.7835029378570511,1.8131312108699253]
["Z > 2.99 -“Safe” Zones"]
["1.81 < Z < 2.99 -“Grey” Zones"]
["Z < 1.81 -“Distress” Zones"]

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