{"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":2,"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":""},null,null,null,null,null,null,{"$f":"UPDATE","v":""},null,null,null,null,"SCREENER.IN"]
[]
["Narration",{"$f":"'Data Sheet'!B16","v":null},{"$f":"'Data Sheet'!C16","v":null},{"$f":"'Data Sheet'!D16","v":null},{"$f":"'Data Sheet'!E16","v":null},{"$f":"'Data Sheet'!F16","v":null},{"$f":"'Data Sheet'!G16","v":null},{"$f":"'Data Sheet'!H16","v":null},{"$f":"'Data Sheet'!I16","v":null},{"$f":"'Data Sheet'!J16","v":null},{"$f":"'Data Sheet'!K16","v":null},"Trailing","Best Case","Worst Case"]
["Sales",{"$f":"'Data Sheet'!B17","v":null},{"$f":"'Data Sheet'!C17","v":null},{"$f":"'Data Sheet'!D17","v":null},{"$f":"'Data Sheet'!E17","v":null},{"$f":"'Data Sheet'!F17","v":null},{"$f":"'Data Sheet'!G17","v":null},{"$f":"'Data Sheet'!H17","v":null},{"$f":"'Data Sheet'!I17","v":null},{"$f":"'Data Sheet'!J17","v":null},{"$f":"'Data Sheet'!K17","v":null},{"$f":"SUM(Quarters!H4:K4)","v":null},{"$f":"$K4+M23*K4","v":null},{"$f":"$K4+N23*L4","v":null}]
["Expenses",{"$f":"SUM('Data Sheet'!B18,'Data Sheet'!B20:B24, -1*'Data Sheet'!B19)","v":null},{"$f":"SUM('Data Sheet'!C18,'Data Sheet'!C20:C24, -1*'Data Sheet'!C19)","v":null},{"$f":"SUM('Data Sheet'!D18,'Data Sheet'!D20:D24, -1*'Data Sheet'!D19)","v":null},{"$f":"SUM('Data Sheet'!E18,'Data Sheet'!E20:E24, -1*'Data Sheet'!E19)","v":null},{"$f":"SUM('Data Sheet'!F18,'Data Sheet'!F20:F24, -1*'Data Sheet'!F19)","v":null},{"$f":"SUM('Data Sheet'!G18,'Data Sheet'!G20:G24, -1*'Data Sheet'!G19)","v":null},{"$f":"SUM('Data Sheet'!H18,'Data Sheet'!H20:H24, -1*'Data Sheet'!H19)","v":null},{"$f":"SUM('Data Sheet'!I18,'Data Sheet'!I20:I24, -1*'Data Sheet'!I19)","v":null},{"$f":"SUM('Data Sheet'!J18,'Data Sheet'!J20:J24, -1*'Data Sheet'!J19)","v":null},{"$f":"SUM('Data Sheet'!K18,'Data Sheet'!K20:K24, -1*'Data Sheet'!K19)","v":null},{"$f":"SUM(Quarters!H5:K5)","v":null},{"$f":"M4-M6","v":null}]
["Operating Profit",{"$f":"B4-B5","v":null},{"$f":"C4-C5","v":null},null,null,null,null,null,null,null,null,{"$f":"SUM(Quarters!H6:K6)","v":null},{"$f":"M4*M24","v":null},{"$f":"N4*N24","v":null}]
["Other Income",{"$f":"'Data Sheet'!B25","v":null},{"$f":"'Data Sheet'!C25","v":null},{"$f":"'Data Sheet'!D25","v":null},{"$f":"'Data Sheet'!E25","v":null},{"$f":"'Data Sheet'!F25","v":null},{"$f":"'Data Sheet'!G25","v":null},{"$f":"'Data Sheet'!H25","v":null},{"$f":"'Data Sheet'!I25","v":null},{"$f":"'Data Sheet'!J25","v":null},{"$f":"'Data Sheet'!K25","v":null},{"$f":"SUM(Quarters!H7:K7)","v":null},0,0]
["Depreciation",{"$f":"'Data Sheet'!B26","v":null},{"$f":"'Data Sheet'!C26","v":null},{"$f":"'Data Sheet'!D26","v":null},{"$f":"'Data Sheet'!E26","v":null},{"$f":"'Data Sheet'!F26","v":null},{"$f":"'Data Sheet'!G26","v":null},{"$f":"'Data Sheet'!H26","v":null},{"$f":"'Data Sheet'!I26","v":null},{"$f":"'Data Sheet'!J26","v":null},{"$f":"'Data Sheet'!K26","v":null},{"$f":"SUM(Quarters!H8:K8)","v":null},{"$f":"+$L8","v":null},{"$f":"+$L8","v":null}]
["Interest",{"$f":"'Data Sheet'!B27","v":null},{"$f":"'Data Sheet'!C27","v":null},{"$f":"'Data Sheet'!D27","v":null},{"$f":"'Data Sheet'!E27","v":null},{"$f":"'Data Sheet'!F27","v":null},{"$f":"'Data Sheet'!G27","v":null},{"$f":"'Data Sheet'!H27","v":null},{"$f":"'Data Sheet'!I27","v":null},{"$f":"'Data Sheet'!J27","v":null},{"$f":"'Data Sheet'!K27","v":null},{"$f":"SUM(Quarters!H9:K9)","v":null},{"$f":"+$L9","v":null},{"$f":"+$L9","v":null}]
["Profit before tax",{"$f":"'Data Sheet'!B28","v":null},{"$f":"'Data Sheet'!C28","v":null},{"$f":"'Data Sheet'!D28","v":null},{"$f":"'Data Sheet'!E28","v":null},{"$f":"'Data Sheet'!F28","v":null},{"$f":"'Data Sheet'!G28","v":null},{"$f":"'Data Sheet'!H28","v":null},{"$f":"'Data Sheet'!I28","v":null},{"$f":"'Data Sheet'!J28","v":null},{"$f":"'Data Sheet'!K28","v":null},{"$f":"SUM(Quarters!H10:K10)","v":null},{"$f":"M6+M7-SUM(M8:M9)","v":null},{"$f":"N6+N7-SUM(N8:N9)","v":null}]
["Tax",{"$f":"'Data Sheet'!B29","v":null},{"$f":"'Data Sheet'!C29","v":null},{"$f":"'Data Sheet'!D29","v":null},{"$f":"'Data Sheet'!E29","v":null},{"$f":"'Data Sheet'!F29","v":null},{"$f":"'Data Sheet'!G29","v":null},{"$f":"'Data Sheet'!H29","v":null},{"$f":"'Data Sheet'!I29","v":null},{"$f":"'Data Sheet'!J29","v":null},{"$f":"'Data Sheet'!K29","v":null},{"$f":"SUM(Quarters!H11:K11)","v":null},{"$f":"IF($L10>0,$L11/$L10,0)","v":null},{"$f":"IF($L10>0,$L11/$L10,0)","v":null}]
["Net profit",{"$f":"'Data Sheet'!B30","v":null},{"$f":"'Data Sheet'!C30","v":null},{"$f":"'Data Sheet'!D30","v":null},{"$f":"'Data Sheet'!E30","v":null},{"$f":"'Data Sheet'!F30","v":null},{"$f":"'Data Sheet'!G30","v":null},{"$f":"'Data Sheet'!H30","v":null},{"$f":"'Data Sheet'!I30","v":null},{"$f":"'Data Sheet'!J30","v":null},{"$f":"'Data Sheet'!K30","v":null},{"$f":"SUM(Quarters!H12:K12)","v":null},{"$f":"M10-M11*M10","v":null},{"$f":"N10-N11*N10","v":null}]
["EPS",{"$f":"IF('Data Sheet'!B93>0,B12/'Data Sheet'!B93,0)","v":null},{"$f":"IF('Data Sheet'!C93>0,C12/'Data Sheet'!C93,0)","v":null},{"$f":"IF('Data Sheet'!D93>0,D12/'Data Sheet'!D93,0)","v":null},{"$f":"IF('Data Sheet'!E93>0,E12/'Data Sheet'!E93,0)","v":null},{"$f":"IF('Data Sheet'!F93>0,F12/'Data Sheet'!F93,0)","v":null},{"$f":"IF('Data Sheet'!G93>0,G12/'Data Sheet'!G93,0)","v":null},{"$f":"IF('Data Sheet'!H93>0,H12/'Data Sheet'!H93,0)","v":null},{"$f":"IF('Data Sheet'!I93>0,I12/'Data Sheet'!I93,0)","v":null},{"$f":"IF('Data Sheet'!J93>0,J12/'Data Sheet'!J93,0)","v":null},{"$f":"IF('Data Sheet'!K93>0,K12/'Data Sheet'!K93,0)","v":null},{"$f":"IF('Data Sheet'!$B6>0,'Profit & Loss'!L12/'Data Sheet'!$B6,0)","v":null},{"$f":"IF('Data Sheet'!$B6>0,'Profit & Loss'!M12/'Data Sheet'!$B6,0)","v":null},{"$f":"IF('Data Sheet'!$B6>0,'Profit & Loss'!N12/'Data Sheet'!$B6,0)","v":null}]
["Price to earning",{"$f":"IF(B15>0,B15/B13,\"\")","v":null},{"$f":"IF(C15>0,C15/C13,\"\")","v":null},null,null,null,null,null,null,null,null,{"$f":"IF(L13>0,L15/L13,0)","v":null},{"$f":"M25","v":null},{"$f":"N25","v":null}]
["Price",{"$f":"'Data Sheet'!B90","v":null},{"$f":"'Data Sheet'!C90","v":null},{"$f":"'Data Sheet'!D90","v":null},{"$f":"'Data Sheet'!E90","v":null},{"$f":"'Data Sheet'!F90","v":null},{"$f":"'Data Sheet'!G90","v":null},{"$f":"'Data Sheet'!H90","v":null},{"$f":"'Data Sheet'!I90","v":null},{"$f":"'Data Sheet'!J90","v":null},{"$f":"'Data Sheet'!K90","v":null},{"$f":"'Data Sheet'!B8","v":null},{"$f":"M13*M14","v":null},{"$f":"N13*N14","v":null}]
[]
["RATIOS:"]
["Dividend Payout",{"$f":"IF('Data Sheet'!B30>0, 'Data Sheet'!B31/'Data Sheet'!B30, 0)","v":null},{"$f":"IF('Data Sheet'!C30>0, 'Data Sheet'!C31/'Data Sheet'!C30, 0)","v":null},{"$f":"IF('Data Sheet'!D30>0, 'Data Sheet'!D31/'Data Sheet'!D30, 0)","v":null},{"$f":"IF('Data Sheet'!E30>0, 'Data Sheet'!E31/'Data Sheet'!E30, 0)","v":null},{"$f":"IF('Data Sheet'!F30>0, 'Data Sheet'!F31/'Data Sheet'!F30, 0)","v":null},{"$f":"IF('Data Sheet'!G30>0, 'Data Sheet'!G31/'Data Sheet'!G30, 0)","v":null},{"$f":"IF('Data Sheet'!H30>0, 'Data Sheet'!H31/'Data Sheet'!H30, 0)","v":null},{"$f":"IF('Data Sheet'!I30>0, 'Data Sheet'!I31/'Data Sheet'!I30, 0)","v":null},{"$f":"IF('Data Sheet'!J30>0, 'Data Sheet'!J31/'Data Sheet'!J30, 0)","v":null},{"$f":"IF('Data Sheet'!K30>0, 'Data Sheet'!K31/'Data Sheet'!K30, 0)","v":null}]
["OPM",{"$f":"IF(B6>0,B6/B4,0)","v":null},{"$f":"IF(C6>0,C6/C4,0)","v":null}]
[]
[]
[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":null},{"$f":"IF(D4=0,\"\",POWER($K4/D4,1/7)-1)","v":null},{"$f":"IF(F4=0,\"\",POWER($K4/F4,1/5)-1)","v":null},{"$f":"IF(H4=0,\"\",POWER($K4/H4, 1/3)-1)","v":null},{"$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":null},{"$f":"MAX(K23:L23)","v":null},{"$f":"MIN(H23:L23)","v":null}]
[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":null},{"$f":"IF(SUM(E4:$K$4)=0,\"\",SUMPRODUCT(E19:$K$19,E4:$K$4)/SUM(E4:$K$4))","v":null},{"$f":"IF(SUM(G4:$K$4)=0,\"\",SUMPRODUCT(G19:$K$19,G4:$K$4)/SUM(G4:$K$4))","v":null},{"$f":"IF(SUM(I4:$K$4)=0, \"\", SUMPRODUCT(I19:$K$19,I4:$K$4)/SUM(I4:$K$4))","v":null},{"$f":"L19","v":null},{"$f":"MAX(K24:L24)","v":null},{"$f":"MIN(H24:L24)","v":null}]
[null,null,null,null,null,null,"Price to Earning",{"$f":"IF(ISERROR(AVERAGEIF(B14:$L14,\">0\")),\"\",AVERAGEIF(B14:$L14,\">0\"))","v":null},{"$f":"IF(ISERROR(AVERAGEIF(E14:$L14,\">0\")),\"\",AVERAGEIF(E14:$L14,\">0\"))","v":null},{"$f":"IF(ISERROR(AVERAGEIF(G14:$L14,\">0\")),\"\",AVERAGEIF(G14:$L14,\">0\"))","v":null},{"$f":"IF(ISERROR(AVERAGEIF(I14:$L14,\">0\")),\"\",AVERAGEIF(I14:$L14,\">0\"))","v":null},{"$f":"L14","v":null},{"$f":"MAX(K25:L25)","v":null},{"$f":"MIN(H25:L25)","v":null}]

{"sheet":"Quarters","index":1,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Profit & Loss'!A1","v":""},null,null,null,{"$f":"UPDATE","v":""},null,null,null,null,"SCREENER.IN"]
[]
["Narration",{"$f":"'Data Sheet'!B41","v":null},{"$f":"'Data Sheet'!C41","v":null},{"$f":"'Data Sheet'!D41","v":null},{"$f":"'Data Sheet'!E41","v":null},{"$f":"'Data Sheet'!F41","v":null},{"$f":"'Data Sheet'!G41","v":null},{"$f":"'Data Sheet'!H41","v":null},{"$f":"'Data Sheet'!I41","v":null},{"$f":"'Data Sheet'!J41","v":null},{"$f":"'Data Sheet'!K41","v":null}]
["Sales",{"$f":"'Data Sheet'!B42","v":null},{"$f":"'Data Sheet'!C42","v":null},{"$f":"'Data Sheet'!D42","v":null},{"$f":"'Data Sheet'!E42","v":null},{"$f":"'Data Sheet'!F42","v":null},{"$f":"'Data Sheet'!G42","v":null},{"$f":"'Data Sheet'!H42","v":null},{"$f":"'Data Sheet'!I42","v":null},{"$f":"'Data Sheet'!J42","v":null},{"$f":"'Data Sheet'!K42","v":null}]
["Expenses",{"$f":"'Data Sheet'!B43","v":null},{"$f":"'Data Sheet'!C43","v":null},{"$f":"'Data Sheet'!D43","v":null},{"$f":"'Data Sheet'!E43","v":null},{"$f":"'Data Sheet'!F43","v":null},{"$f":"'Data Sheet'!G43","v":null},{"$f":"'Data Sheet'!H43","v":null},{"$f":"'Data Sheet'!I43","v":null},{"$f":"'Data Sheet'!J43","v":null},{"$f":"'Data Sheet'!K43","v":null}]
["Operating Profit",{"$f":"'Data Sheet'!B50","v":null},{"$f":"'Data Sheet'!C50","v":null},{"$f":"'Data Sheet'!D50","v":null},{"$f":"'Data Sheet'!E50","v":null},{"$f":"'Data Sheet'!F50","v":null},{"$f":"'Data Sheet'!G50","v":null},{"$f":"'Data Sheet'!H50","v":null},{"$f":"'Data Sheet'!I50","v":null},{"$f":"'Data Sheet'!J50","v":null},{"$f":"'Data Sheet'!K50","v":null}]
["Other Income",{"$f":"'Data Sheet'!B44","v":null},{"$f":"'Data Sheet'!C44","v":null},{"$f":"'Data Sheet'!D44","v":null},{"$f":"'Data Sheet'!E44","v":null},{"$f":"'Data Sheet'!F44","v":null},{"$f":"'Data Sheet'!G44","v":null},{"$f":"'Data Sheet'!H44","v":null},{"$f":"'Data Sheet'!I44","v":null},{"$f":"'Data Sheet'!J44","v":null},{"$f":"'Data Sheet'!K44","v":null}]
["Depreciation",{"$f":"'Data Sheet'!B45","v":null},{"$f":"'Data Sheet'!C45","v":null},{"$f":"'Data Sheet'!D45","v":null},{"$f":"'Data Sheet'!E45","v":null},{"$f":"'Data Sheet'!F45","v":null},{"$f":"'Data Sheet'!G45","v":null},{"$f":"'Data Sheet'!H45","v":null},{"$f":"'Data Sheet'!I45","v":null},{"$f":"'Data Sheet'!J45","v":null},{"$f":"'Data Sheet'!K45","v":null}]
["Interest",{"$f":"'Data Sheet'!B46","v":null},{"$f":"'Data Sheet'!C46","v":null},{"$f":"'Data Sheet'!D46","v":null},{"$f":"'Data Sheet'!E46","v":null},{"$f":"'Data Sheet'!F46","v":null},{"$f":"'Data Sheet'!G46","v":null},{"$f":"'Data Sheet'!H46","v":null},{"$f":"'Data Sheet'!I46","v":null},{"$f":"'Data Sheet'!J46","v":null},{"$f":"'Data Sheet'!K46","v":null}]
["Profit before tax",{"$f":"'Data Sheet'!B47","v":null},{"$f":"'Data Sheet'!C47","v":null},{"$f":"'Data Sheet'!D47","v":null},{"$f":"'Data Sheet'!E47","v":null},{"$f":"'Data Sheet'!F47","v":null},{"$f":"'Data Sheet'!G47","v":null},{"$f":"'Data Sheet'!H47","v":null},{"$f":"'Data Sheet'!I47","v":null},{"$f":"'Data Sheet'!J47","v":null},{"$f":"'Data Sheet'!K47","v":null}]
["Tax",{"$f":"'Data Sheet'!B48","v":null},{"$f":"'Data Sheet'!C48","v":null},{"$f":"'Data Sheet'!D48","v":null},{"$f":"'Data Sheet'!E48","v":null},{"$f":"'Data Sheet'!F48","v":null},{"$f":"'Data Sheet'!G48","v":null},{"$f":"'Data Sheet'!H48","v":null},{"$f":"'Data Sheet'!I48","v":null},{"$f":"'Data Sheet'!J48","v":null},{"$f":"'Data Sheet'!K48","v":null}]
["Net profit",{"$f":"'Data Sheet'!B49","v":null},{"$f":"'Data Sheet'!C49","v":null},{"$f":"'Data Sheet'!D49","v":null},{"$f":"'Data Sheet'!E49","v":null},{"$f":"'Data Sheet'!F49","v":null},{"$f":"'Data Sheet'!G49","v":null},{"$f":"'Data Sheet'!H49","v":null},{"$f":"'Data Sheet'!I49","v":null},{"$f":"'Data Sheet'!J49","v":null},{"$f":"'Data Sheet'!K49","v":null}]
[]
["OPM",{"$f":"IF(B4>0,B6/B4,\"\")","v":null},{"$f":"IF(C4>0,C6/C4,\"\")","v":null}]

{"sheet":"Balance Sheet","index":2,"n_rows":37,"n_cols":12,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Profit & Loss'!A1","v":""},null,null,null,{"$f":"UPDATE","v":""},null,null,null,null,"SCREENER.IN"]
[]
["Narration",{"$f":"'Data Sheet'!B56","v":null},{"$f":"'Data Sheet'!C56","v":null},{"$f":"'Data Sheet'!D56","v":null},{"$f":"'Data Sheet'!E56","v":null},{"$f":"'Data Sheet'!F56","v":null},{"$f":"'Data Sheet'!G56","v":null},{"$f":"'Data Sheet'!H56","v":null},{"$f":"'Data Sheet'!I56","v":null},{"$f":"'Data Sheet'!J56","v":null},{"$f":"'Data Sheet'!K56","v":null}]
["Equity Share Capital",{"$f":"'Data Sheet'!B57","v":null},{"$f":"'Data Sheet'!C57","v":null},{"$f":"'Data Sheet'!D57","v":null},{"$f":"'Data Sheet'!E57","v":null},{"$f":"'Data Sheet'!F57","v":null},{"$f":"'Data Sheet'!G57","v":null},{"$f":"'Data Sheet'!H57","v":null},{"$f":"'Data Sheet'!I57","v":null},{"$f":"'Data Sheet'!J57","v":null},{"$f":"'Data Sheet'!K57","v":null}]
["Reserves",{"$f":"'Data Sheet'!B58","v":null},{"$f":"'Data Sheet'!C58","v":null},{"$f":"'Data Sheet'!D58","v":null},{"$f":"'Data Sheet'!E58","v":null},{"$f":"'Data Sheet'!F58","v":null},{"$f":"'Data Sheet'!G58","v":null},{"$f":"'Data Sheet'!H58","v":null},{"$f":"'Data Sheet'!I58","v":null},{"$f":"'Data Sheet'!J58","v":null},{"$f":"'Data Sheet'!K58","v":null}]
["Borrowings",{"$f":"'Data Sheet'!B59","v":null},{"$f":"'Data Sheet'!C59","v":null},{"$f":"'Data Sheet'!D59","v":null},{"$f":"'Data Sheet'!E59","v":null},{"$f":"'Data Sheet'!F59","v":null},{"$f":"'Data Sheet'!G59","v":null},{"$f":"'Data Sheet'!H59","v":null},{"$f":"'Data Sheet'!I59","v":null},{"$f":"'Data Sheet'!J59","v":null},{"$f":"'Data Sheet'!K59","v":null}]
["Other Liabilities",{"$f":"'Data Sheet'!B60","v":null},{"$f":"'Data Sheet'!C60","v":null},{"$f":"'Data Sheet'!D60","v":null},{"$f":"'Data Sheet'!E60","v":null},{"$f":"'Data Sheet'!F60","v":null},{"$f":"'Data Sheet'!G60","v":null},{"$f":"'Data Sheet'!H60","v":null},{"$f":"'Data Sheet'!I60","v":null},{"$f":"'Data Sheet'!J60","v":null},{"$f":"'Data Sheet'!K60","v":null}]
["Total",{"$f":"'Data Sheet'!B61","v":null},{"$f":"'Data Sheet'!C61","v":null},{"$f":"'Data Sheet'!D61","v":null},{"$f":"'Data Sheet'!E61","v":null},{"$f":"'Data Sheet'!F61","v":null},{"$f":"'Data Sheet'!G61","v":null},{"$f":"'Data Sheet'!H61","v":null},{"$f":"'Data Sheet'!I61","v":null},{"$f":"'Data Sheet'!J61","v":null},{"$f":"'Data Sheet'!K61","v":null}]
[]
["Net Block",{"$f":"'Data Sheet'!B62","v":null},{"$f":"'Data Sheet'!C62","v":null},{"$f":"'Data Sheet'!D62","v":null},{"$f":"'Data Sheet'!E62","v":null},{"$f":"'Data Sheet'!F62","v":null},{"$f":"'Data Sheet'!G62","v":null},{"$f":"'Data Sheet'!H62","v":null},{"$f":"'Data Sheet'!I62","v":null},{"$f":"'Data Sheet'!J62","v":null},{"$f":"'Data Sheet'!K62","v":null}]
["Capital Work in Progress",{"$f":"'Data Sheet'!B63","v":null},{"$f":"'Data Sheet'!C63","v":null},{"$f":"'Data Sheet'!D63","v":null},{"$f":"'Data Sheet'!E63","v":null},{"$f":"'Data Sheet'!F63","v":null},{"$f":"'Data Sheet'!G63","v":null},{"$f":"'Data Sheet'!H63","v":null},{"$f":"'Data Sheet'!I63","v":null},{"$f":"'Data Sheet'!J63","v":null},{"$f":"'Data Sheet'!K63","v":null}]
["Investments",{"$f":"'Data Sheet'!B64","v":null},{"$f":"'Data Sheet'!C64","v":null},{"$f":"'Data Sheet'!D64","v":null},{"$f":"'Data Sheet'!E64","v":null},{"$f":"'Data Sheet'!F64","v":null},{"$f":"'Data Sheet'!G64","v":null},{"$f":"'Data Sheet'!H64","v":null},{"$f":"'Data Sheet'!I64","v":null},{"$f":"'Data Sheet'!J64","v":null},{"$f":"'Data Sheet'!K64","v":null}]
["Other Assets",{"$f":"'Data Sheet'!B65","v":null},{"$f":"'Data Sheet'!C65","v":null},{"$f":"'Data Sheet'!D65","v":null},{"$f":"'Data Sheet'!E65","v":null},{"$f":"'Data Sheet'!F65","v":null},{"$f":"'Data Sheet'!G65","v":null},{"$f":"'Data Sheet'!H65","v":null},{"$f":"'Data Sheet'!I65","v":null},{"$f":"'Data Sheet'!J65","v":null},{"$f":"'Data Sheet'!K65","v":null}]
["Total",{"$f":"'Data Sheet'!B66","v":null},{"$f":"'Data Sheet'!C66","v":null},{"$f":"'Data Sheet'!D66","v":null},{"$f":"'Data Sheet'!E66","v":null},{"$f":"'Data Sheet'!F66","v":null},{"$f":"'Data Sheet'!G66","v":null},{"$f":"'Data Sheet'!H66","v":null},{"$f":"'Data Sheet'!I66","v":null},{"$f":"'Data Sheet'!J66","v":null},{"$f":"'Data Sheet'!K66","v":null}]
[]
["Working Capital",{"$f":"B13-B7","v":null},{"$f":"C13-C7","v":null}]
["Debtors",{"$f":"'Data Sheet'!B67","v":null},{"$f":"'Data Sheet'!C67","v":null},{"$f":"'Data Sheet'!D67","v":null},{"$f":"'Data Sheet'!E67","v":null},{"$f":"'Data Sheet'!F67","v":null},{"$f":"'Data Sheet'!G67","v":null},{"$f":"'Data Sheet'!H67","v":null},{"$f":"'Data Sheet'!I67","v":null},{"$f":"'Data Sheet'!J67","v":null},{"$f":"'Data Sheet'!K67","v":null}]
["Inventory",{"$f":"'Data Sheet'!B68","v":null},{"$f":"'Data Sheet'!C68","v":null},{"$f":"'Data Sheet'!D68","v":null},{"$f":"'Data Sheet'!E68","v":null},{"$f":"'Data Sheet'!F68","v":null},{"$f":"'Data Sheet'!G68","v":null},{"$f":"'Data Sheet'!H68","v":null},{"$f":"'Data Sheet'!I68","v":null},{"$f":"'Data Sheet'!J68","v":null},{"$f":"'Data Sheet'!K68","v":null}]
[]
["Inventory Turnover",{"$f":"IF('Balance Sheet'!B18>0,'Profit & Loss'!B4/'Balance Sheet'!B18,0)","v":null},{"$f":"IF('Balance Sheet'!C18>0,'Profit & Loss'!C4/'Balance Sheet'!C18,0)","v":null},{"$f":"IF('Balance Sheet'!D18>0,'Profit & Loss'!D4/'Balance Sheet'!D18,0)","v":null},{"$f":"IF('Balance Sheet'!E18>0,'Profit & Loss'!E4/'Balance Sheet'!E18,0)","v":null},{"$f":"IF('Balance Sheet'!F18>0,'Profit & Loss'!F4/'Balance Sheet'!F18,0)","v":null},{"$f":"IF('Balance Sheet'!G18>0,'Profit & Loss'!G4/'Balance Sheet'!G18,0)","v":null},{"$f":"IF('Balance Sheet'!H18>0,'Profit & Loss'!H4/'Balance Sheet'!H18,0)","v":null},{"$f":"IF('Balance Sheet'!I18>0,'Profit & Loss'!I4/'Balance Sheet'!I18,0)","v":null},{"$f":"IF('Balance Sheet'!J18>0,'Profit & Loss'!J4/'Balance Sheet'!J18,0)","v":null},{"$f":"IF('Balance Sheet'!K18>0,'Profit & Loss'!K4/'Balance Sheet'!K18,0)","v":null}]
["Inventory Days",{"$f":"IF('Profit & Loss'!B4>0,'Balance Sheet'!B18/('Profit & Loss'!B4/365),0)","v":null},{"$f":"IF('Profit & Loss'!C4>0,'Balance Sheet'!C18/('Profit & Loss'!C4/365),0)","v":null},{"$f":"IF('Profit & Loss'!D4>0,'Balance Sheet'!D18/('Profit & Loss'!D4/365),0)","v":null},{"$f":"IF('Profit & Loss'!E4>0,'Balance Sheet'!E18/('Profit & Loss'!E4/365),0)","v":null},{"$f":"IF('Profit & Loss'!F4>0,'Balance Sheet'!F18/('Profit & Loss'!F4/365),0)","v":null},{"$f":"IF('Profit & Loss'!G4>0,'Balance Sheet'!G18/('Profit & Loss'!G4/365),0)","v":null},{"$f":"IF('Profit & Loss'!H4>0,'Balance Sheet'!H18/('Profit & Loss'!H4/365),0)","v":null},{"$f":"IF('Profit & Loss'!I4>0,'Balance Sheet'!I18/('Profit & Loss'!I4/365),0)","v":null},{"$f":"IF('Profit & Loss'!J4>0,'Balance Sheet'!J18/('Profit & Loss'!J4/365),0)","v":null},{"$f":"IF('Profit & Loss'!K4>0,'Balance Sheet'!K18/('Profit & Loss'!K4/365),0)","v":null}]
["Debtor Days",{"$f":"IF('Profit & Loss'!B4>0,'Balance Sheet'!B17/('Profit & Loss'!B4/365),0)","v":null},{"$f":"IF('Profit & Loss'!C4>0,'Balance Sheet'!C17/('Profit & Loss'!C4/365),0)","v":null},{"$f":"IF('Profit & Loss'!D4>0,'Balance Sheet'!D17/('Profit & Loss'!D4/365),0)","v":null},{"$f":"IF('Profit & Loss'!E4>0,'Balance Sheet'!E17/('Profit & Loss'!E4/365),0)","v":null},{"$f":"IF('Profit & Loss'!F4>0,'Balance Sheet'!F17/('Profit & Loss'!F4/365),0)","v":null},{"$f":"IF('Profit & Loss'!G4>0,'Balance Sheet'!G17/('Profit & Loss'!G4/365),0)","v":null},{"$f":"IF('Profit & Loss'!H4>0,'Balance Sheet'!H17/('Profit & Loss'!H4/365),0)","v":null},{"$f":"IF('Profit & Loss'!I4>0,'Balance Sheet'!I17/('Profit & Loss'!I4/365),0)","v":null},{"$f":"IF('Profit & Loss'!J4>0,'Balance Sheet'!J17/('Profit & Loss'!J4/365),0)","v":null},{"$f":"IF('Profit & Loss'!K4>0,'Balance Sheet'!K17/('Profit & Loss'!K4/365),0)","v":null}]
["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":null},{"$f":"IF(SUM('Balance Sheet'!C4:C5)>0,'Profit & Loss'!C12/SUM('Balance Sheet'!C4:C5),\"\")","v":null},{"$f":"IF(SUM('Balance Sheet'!D4:D5)>0,'Profit & Loss'!D12/SUM('Balance Sheet'!D4:D5),\"\")","v":null},{"$f":"IF(SUM('Balance Sheet'!E4:E5)>0,'Profit & Loss'!E12/SUM('Balance Sheet'!E4:E5),\"\")","v":null},{"$f":"IF(SUM('Balance Sheet'!F4:F5)>0,'Profit & Loss'!F12/SUM('Balance Sheet'!F4:F5),\"\")","v":null},{"$f":"IF(SUM('Balance Sheet'!G4:G5)>0,'Profit & Loss'!G12/SUM('Balance Sheet'!G4:G5),\"\")","v":null},{"$f":"IF(SUM('Balance Sheet'!H4:H5)>0,'Profit & Loss'!H12/SUM('Balance Sheet'!H4:H5),\"\")","v":null},{"$f":"IF(SUM('Balance Sheet'!I4:I5)>0,'Profit & Loss'!I12/SUM('Balance Sheet'!I4:I5),\"\")","v":null},{"$f":"IF(SUM('Balance Sheet'!J4:J5)>0,'Profit & Loss'!J12/SUM('Balance Sheet'!J4:J5),\"\")","v":null},{"$f":"IF(SUM('Balance Sheet'!K4:K5)>0,'Profit & Loss'!K12/SUM('Balance Sheet'!K4:K5),\"\")","v":null}]
["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":null},{"$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":null},{"$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":null},{"$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":null},{"$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":null},{"$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":null},{"$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":null},{"$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":null},{"$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":null},{"$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":null}]
[]
[]
[]
["Common Size Balance Sheet",{"$f":"B3","v":null},{"$f":"C3","v":null},null,null,null,null,null,null,null,null,"Check back how Assets are being put to use"]
["Net Block/Total Assets",{"$f":"B10/B$8","v":null},{"$f":"C10/C$8","v":null}]
["Working Capital/Total Assets",{"$f":"B16/B$8","v":null},{"$f":"C16/C$8","v":null}]
["Debtors/Total Assets",{"$f":"B17/B$8","v":null},{"$f":"C17/C$8","v":null}]
["Inventory/Total Assets",{"$f":"B18/B$8","v":null},{"$f":"C18/C$8","v":null}]
[]
["Borrowings/Total Assets",{"$f":"B6/B$8","v":null},{"$f":"C6/C$8","v":null}]

{"sheet":"Cash Flow","index":3,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Balance Sheet'!A1","v":""},null,null,null,{"$f":"UPDATE","v":""},null,null,null,null,"SCREENER.IN"]
[]
["Narration",{"$f":"'Data Sheet'!B81","v":null},{"$f":"'Data Sheet'!C81","v":null},{"$f":"'Data Sheet'!D81","v":null},{"$f":"'Data Sheet'!E81","v":null},{"$f":"'Data Sheet'!F81","v":null},{"$f":"'Data Sheet'!G81","v":null},{"$f":"'Data Sheet'!H81","v":null},{"$f":"'Data Sheet'!I81","v":null},{"$f":"'Data Sheet'!J81","v":null},{"$f":"'Data Sheet'!K81","v":null}]
["Cash from Operating Activity",{"$f":"'Data Sheet'!B82","v":null},{"$f":"'Data Sheet'!C82","v":null},{"$f":"'Data Sheet'!D82","v":null},{"$f":"'Data Sheet'!E82","v":null},{"$f":"'Data Sheet'!F82","v":null},{"$f":"'Data Sheet'!G82","v":null},{"$f":"'Data Sheet'!H82","v":null},{"$f":"'Data Sheet'!I82","v":null},{"$f":"'Data Sheet'!J82","v":null},{"$f":"'Data Sheet'!K82","v":null}]
["Cash from Investing Activity",{"$f":"'Data Sheet'!B83","v":null},{"$f":"'Data Sheet'!C83","v":null},{"$f":"'Data Sheet'!D83","v":null},{"$f":"'Data Sheet'!E83","v":null},{"$f":"'Data Sheet'!F83","v":null},{"$f":"'Data Sheet'!G83","v":null},{"$f":"'Data Sheet'!H83","v":null},{"$f":"'Data Sheet'!I83","v":null},{"$f":"'Data Sheet'!J83","v":null},{"$f":"'Data Sheet'!K83","v":null}]
["Cash from Financing Activity",{"$f":"'Data Sheet'!B84","v":null},{"$f":"'Data Sheet'!C84","v":null},{"$f":"'Data Sheet'!D84","v":null},{"$f":"'Data Sheet'!E84","v":null},{"$f":"'Data Sheet'!F84","v":null},{"$f":"'Data Sheet'!G84","v":null},{"$f":"'Data Sheet'!H84","v":null},{"$f":"'Data Sheet'!I84","v":null},{"$f":"'Data Sheet'!J84","v":null},{"$f":"'Data Sheet'!K84","v":null}]
["Net Cash Flow",{"$f":"'Data Sheet'!B85","v":null},{"$f":"'Data Sheet'!C85","v":null},{"$f":"'Data Sheet'!D85","v":null},{"$f":"'Data Sheet'!E85","v":null},{"$f":"'Data Sheet'!F85","v":null},{"$f":"'Data Sheet'!G85","v":null},{"$f":"'Data Sheet'!H85","v":null},{"$f":"'Data Sheet'!I85","v":null},{"$f":"'Data Sheet'!J85","v":null},{"$f":"'Data Sheet'!K85","v":null}]

{"sheet":"Customization","index":4,"n_rows":65,"n_cols":14,"rows_kept":65,"cut":false,"hidden":false,"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":""}]
[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'!K11-'Calculated Data'!B11","v":null},{"$f":"'Calculated Data'!K26-'Calculated Data'!B26","v":null},{"$f":"C5/B5","v":null},null,null,"P/E","P/B","EV/EBITDA","P/SALES","YIELD",null,"LongTerm Bond",0.09]
["7 YR",{"$f":"'Calculated Data'!K11-'Calculated Data'!E11","v":null},{"$f":"'Calculated Data'!K26-'Calculated Data'!E26","v":null},{"$f":"C6/B6","v":null},null,"MIN",{"$f":"MIN('Calculated Data'!B31:K31)","v":null},{"$f":"MIN('Calculated Data'!B32:K32)","v":null},{"$f":"MIN('Calculated Data'!B35:K35)","v":null},{"$f":"MIN('Calculated Data'!B34:K34)","v":null},{"$f":"MAX('Calculated Data'!B36:K36)","v":null},null,"LTB Quote",{"$f":"('Profit & Loss'!$L$10/'Data Sheet'!$B$61)/N5","v":null}]
["5 YR",{"$f":"'Calculated Data'!K11-'Calculated Data'!G11","v":null},{"$f":"'Calculated Data'!K26-'Calculated Data'!G26","v":null},{"$f":"C7/B7","v":null},null,"MAX",{"$f":"MAX('Calculated Data'!B31:K31)","v":null},{"$f":"MAX('Calculated Data'!B32:K32)","v":null},{"$f":"MAX('Calculated Data'!B35:K35)","v":null},{"$f":"MAX('Calculated Data'!B34:K34)","v":null},{"$f":"MIN('Calculated Data'!B36:K36)","v":null},null,"Equity Quoting @",{"$f":"('Profit & Loss'!$L$6/'Data Sheet'!$B$6)/'Data Sheet'!$B$8","v":null}]
["3 YR",{"$f":"'Calculated Data'!K11-'Calculated Data'!I11","v":null},{"$f":"'Calculated Data'!K26-'Calculated Data'!I26","v":null},{"$f":"C8/B8","v":null},null,"TRAILING",{"$f":"'Data Sheet'!B8/'Profit & Loss'!L13","v":null},{"$f":"'Calculated Data'!L26/'Calculated Data'!K11","v":null},{"$f":"'Calculated Data'!K35","v":null},{"$f":"'Calculated Data'!L26/'Data Sheet'!K17","v":null},{"$f":"'Data Sheet'!K31/'Calculated Data'!L26","v":null}]
["1 YR",{"$f":"'Calculated Data'!K11-'Calculated Data'!J11","v":null},{"$f":"'Calculated Data'!K26-'Calculated Data'!J26","v":null},{"$f":"C9/B9","v":null},null,null,null,null,null,null,null,null," "]
["* IMPACT – Every Rupee retained added xx.yy in incremental market value"]
[]
[{"$f":"A1","v":""},"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":null},{"$f":"POWER('Calculated Data'!$K4/'Calculated Data'!$B4, 1/9)-1","v":null},{"$f":"POWER('Calculated Data'!$K5/'Calculated Data'!$B5, 1/9)-1","v":null},{"$f":"POWER('Calculated Data'!$K8/'Calculated Data'!$B8, 1/9)-1","v":null},{"$f":"POWER('Calculated Data'!$K9/'Calculated Data'!$B9, 1/9)-1","v":null},{"$f":"POWER('Calculated Data'!$K24/'Calculated Data'!$B24, 1/9)-1","v":null},{"$f":"POWER('Calculated Data'!$K26/'Calculated Data'!$B26, 1/9)-1","v":null},{"$f":"POWER('Calculated Data'!$K17/'Calculated Data'!$B17, 1/9)-1","v":null},{"$f":"POWER('Calculated Data'!$K19/'Calculated Data'!$C19, 1/8)-1","v":null},{"$f":"POWER('Calculated Data'!$K11/'Calculated Data'!$B11, 1/9)-1","v":null},{"$f":"POWER('Calculated Data'!$K27/'Calculated Data'!$B27, 1/9)-1","v":null}]
["5 YR CAGR",{"$f":"POWER('Data Sheet'!$K17/'Data Sheet'!$G17, 1/4)-1","v":null},{"$f":"POWER('Calculated Data'!$K4/'Calculated Data'!$G4, 1/4)-1","v":null},{"$f":"POWER('Calculated Data'!$K5/'Calculated Data'!$G5, 1/4)-1","v":null},{"$f":"POWER('Calculated Data'!$K8/'Calculated Data'!$G8, 1/4)-1","v":null},{"$f":"POWER('Calculated Data'!$K9/'Calculated Data'!$G9, 1/4)-1","v":null},{"$f":"POWER('Calculated Data'!$K24/'Calculated Data'!$G24, 1/4)-1","v":null},{"$f":"POWER('Calculated Data'!$K26/'Calculated Data'!$G26, 1/4)-1","v":null},{"$f":"POWER('Calculated Data'!$K17/'Calculated Data'!$G17, 1/4)-1","v":null},{"$f":"POWER('Calculated Data'!$K19/'Calculated Data'!$G19, 1/4)-1","v":null},{"$f":"POWER('Calculated Data'!$K11/'Calculated Data'!$G11, 1/4)-1","v":null},{"$f":"POWER('Calculated Data'!$K27/'Calculated Data'!$G27, 1/4)-1","v":null}]
["3 YR CAGR",{"$f":"POWER('Data Sheet'!$K17/'Data Sheet'!$I17, 1/2)-1","v":null},{"$f":"POWER('Calculated Data'!$K4/'Calculated Data'!$I4, 1/2)-1","v":null},{"$f":"POWER('Calculated Data'!$K5/'Calculated Data'!$I5, 1/2)-1","v":null},{"$f":"POWER('Calculated Data'!$K8/'Calculated Data'!$I8, 1/2)-1","v":null},{"$f":"POWER('Calculated Data'!$K9/'Calculated Data'!$I9, 1/2)-1","v":null},{"$f":"POWER('Calculated Data'!$K24/'Calculated Data'!$I24, 1/2)-1","v":{"$error":"#UNKNOWN!"}},{"$f":"POWER('Calculated Data'!$K26/'Calculated Data'!$I26, 1/2)-1","v":null},{"$f":"POWER('Calculated Data'!$K17/'Calculated Data'!$I17, 1/2)-1","v":{"$error":"#UNKNOWN!"}},{"$f":"POWER('Calculated Data'!$K19/'Calculated Data'!$I19, 1/2)-1","v":{"$error":"#UNKNOWN!"}},{"$f":"POWER('Calculated Data'!$K11/'Calculated Data'!$I11, 1/2)-1","v":null},{"$f":"POWER('Calculated Data'!$K27/'Calculated Data'!$I27, 1/2)-1","v":null}]
["1 YR GROWTH",{"$f":"('Data Sheet'!$K17-'Data Sheet'!$J17)/'Data Sheet'!$J17","v":null},{"$f":"('Calculated Data'!$K4-'Calculated Data'!$J4)/'Calculated Data'!$J4","v":null},{"$f":"('Calculated Data'!$K5-'Calculated Data'!$J5)/'Calculated Data'!$J5","v":null},{"$f":"('Calculated Data'!$K8-'Calculated Data'!$J8)/'Calculated Data'!$J8","v":null},{"$f":"('Calculated Data'!$K9-'Calculated Data'!$J9)/'Calculated Data'!$J9","v":null},{"$f":"('Calculated Data'!$K24-'Calculated Data'!$J24)/'Calculated Data'!$J24","v":null},{"$f":"('Calculated Data'!$K26-'Calculated Data'!$J26)/'Calculated Data'!$J26","v":null},{"$f":"('Calculated Data'!$K17-'Calculated Data'!$J17)/'Calculated Data'!$J17","v":null},{"$f":"('Calculated Data'!$K19-'Calculated Data'!$J19)/'Calculated Data'!$J19","v":null},{"$f":"('Calculated Data'!$K11-'Calculated Data'!$J11)/'Calculated Data'!$J11","v":null},{"$f":"('Calculated Data'!$K27-'Calculated Data'!$J27)/'Calculated Data'!$J27","v":null}]
["**modify (if, then) for negative values"]
[{"$f":"A1","v":""},{"$f":"'Data Sheet'!B16","v":null},{"$f":"'Data Sheet'!C16","v":null},{"$f":"'Data Sheet'!D16","v":null},{"$f":"'Data Sheet'!E16","v":null},{"$f":"'Data Sheet'!F16","v":null},{"$f":"'Data Sheet'!G16","v":null},{"$f":"'Data Sheet'!H16","v":null},{"$f":"'Data Sheet'!I16","v":null},{"$f":"'Data Sheet'!J16","v":null},{"$f":"'Data Sheet'!K16","v":null},null,"    "]
["Total Assets/Networth= Financial Leverage",{"$f":"'Calculated Data'!B15/'Calculated Data'!B11","v":null},{"$f":"'Calculated Data'!C15/'Calculated Data'!C11","v":null},{"$f":"'Calculated Data'!D15/'Calculated Data'!D11","v":null},{"$f":"'Calculated Data'!E15/'Calculated Data'!E11","v":null},{"$f":"'Calculated Data'!F15/'Calculated Data'!F11","v":null},{"$f":"'Calculated Data'!G15/'Calculated Data'!G11","v":null},{"$f":"'Calculated Data'!H15/'Calculated Data'!H11","v":null},{"$f":"'Calculated Data'!I15/'Calculated Data'!I11","v":null},{"$f":"'Calculated Data'!J15/'Calculated Data'!J11","v":null},{"$f":"'Calculated Data'!K15/'Calculated Data'!K11","v":null}," "]
["Long term debt/Earning",{"$f":"'Data Sheet'!B59/'Data Sheet'!B30","v":null},{"$f":"'Data Sheet'!C59/'Data Sheet'!C30","v":null},{"$f":"'Data Sheet'!D59/'Data Sheet'!D30","v":null},{"$f":"'Data Sheet'!E59/'Data Sheet'!E30","v":null},{"$f":"'Data Sheet'!F59/'Data Sheet'!F30","v":null},{"$f":"'Data Sheet'!G59/'Data Sheet'!G30","v":null},{"$f":"'Data Sheet'!H59/'Data Sheet'!H30","v":null},{"$f":"'Data Sheet'!I59/'Data Sheet'!I30","v":null},{"$f":"'Data Sheet'!J59/'Data Sheet'!J30","v":null},{"$f":"'Data Sheet'!K59/'Data Sheet'!K30","v":null}]
["Current liablility/Earning",{"$f":"'Data Sheet'!B60/'Data Sheet'!B30","v":null},{"$f":"'Data Sheet'!C60/'Data Sheet'!C30","v":null},{"$f":"'Data Sheet'!D60/'Data Sheet'!D30","v":null},{"$f":"'Data Sheet'!E60/'Data Sheet'!E30","v":null},{"$f":"'Data Sheet'!F60/'Data Sheet'!F30","v":null},{"$f":"'Data Sheet'!G60/'Data Sheet'!G30","v":null},{"$f":"'Data Sheet'!H60/'Data Sheet'!H30","v":null},{"$f":"'Data Sheet'!I60/'Data Sheet'!I30","v":null},{"$f":"'Data Sheet'!J60/'Data Sheet'!J30","v":null},{"$f":"'Data Sheet'!K60/'Data Sheet'!K30","v":null}]
["Total liability/Earning",{"$f":"('Data Sheet'!B59+'Data Sheet'!B60)/'Data Sheet'!B30","v":null},{"$f":"('Data Sheet'!C59+'Data Sheet'!C60)/'Data Sheet'!C30","v":null},{"$f":"('Data Sheet'!D59+'Data Sheet'!D60)/'Data Sheet'!D30","v":null},{"$f":"('Data Sheet'!E59+'Data Sheet'!E60)/'Data Sheet'!E30","v":null},{"$f":"('Data Sheet'!F59+'Data Sheet'!F60)/'Data Sheet'!F30","v":null},{"$f":"('Data Sheet'!G59+'Data Sheet'!G60)/'Data Sheet'!G30","v":null},{"$f":"('Data Sheet'!H59+'Data Sheet'!H60)/'Data Sheet'!H30","v":null},{"$f":"('Data Sheet'!I59+'Data Sheet'!I60)/'Data Sheet'!I30","v":null},{"$f":"('Data Sheet'!J59+'Data Sheet'!J60)/'Data Sheet'!J30","v":null},{"$f":"('Data Sheet'!K59+'Data Sheet'!K60)/'Data Sheet'!K30","v":null}]
["Debt/Equity",{"$f":"'Data Sheet'!B59/'Calculated Data'!B11","v":null},{"$f":"'Data Sheet'!C59/'Calculated Data'!C11","v":null},{"$f":"'Data Sheet'!D59/'Calculated Data'!D11","v":null},{"$f":"'Data Sheet'!E59/'Calculated Data'!E11","v":null},{"$f":"'Data Sheet'!F59/'Calculated Data'!F11","v":null},{"$f":"'Data Sheet'!G59/'Calculated Data'!G11","v":null},{"$f":"'Data Sheet'!H59/'Calculated Data'!H11","v":null},{"$f":"'Data Sheet'!I59/'Calculated Data'!I11","v":null},{"$f":"'Data Sheet'!J59/'Calculated Data'!J11","v":null},{"$f":"'Data Sheet'!K59/'Calculated Data'!K11","v":null}]
["Interest Coverage",{"$f":"'Calculated Data'!B5/'Data Sheet'!B27","v":null},{"$f":"'Calculated Data'!C5/'Data Sheet'!C27","v":null},{"$f":"'Calculated Data'!D5/'Data Sheet'!D27","v":null},{"$f":"'Calculated Data'!E5/'Data Sheet'!E27","v":null},{"$f":"'Calculated Data'!F5/'Data Sheet'!F27","v":null},{"$f":"'Calculated Data'!G5/'Data Sheet'!G27","v":null},{"$f":"'Calculated Data'!H5/'Data Sheet'!H27","v":null},{"$f":"'Calculated Data'!I5/'Data Sheet'!I27","v":null},{"$f":"'Calculated Data'!J5/'Data Sheet'!J27","v":null},{"$f":"'Calculated Data'!K5/'Data Sheet'!K27","v":null}]
["Working Capital/Sales",{"$f":"'Calculated Data'!B12/'Data Sheet'!B17","v":null},{"$f":"'Calculated Data'!C12/'Data Sheet'!C17","v":null},{"$f":"'Calculated Data'!D12/'Data Sheet'!D17","v":null},{"$f":"'Calculated Data'!E12/'Data Sheet'!E17","v":null},{"$f":"'Calculated Data'!F12/'Data Sheet'!F17","v":null},{"$f":"'Calculated Data'!G12/'Data Sheet'!G17","v":null},{"$f":"'Calculated Data'!H12/'Data Sheet'!H17","v":null},{"$f":"'Calculated Data'!I12/'Data Sheet'!I17","v":null},{"$f":"'Calculated Data'!J12/'Data Sheet'!J17","v":null},{"$f":"'Calculated Data'!K12/'Data Sheet'!K17","v":null},"Check for improving or deteriorating picture"]
["Inventory Turns",{"$f":"365/B27","v":null}]
["Inventory Days",{"$f":"'Balance Sheet'!B21","v":null},{"$f":"'Balance Sheet'!C21","v":null},{"$f":"'Balance Sheet'!D21","v":null},{"$f":"'Balance Sheet'!E21","v":null},{"$f":"'Balance Sheet'!F21","v":null},{"$f":"'Balance Sheet'!G21","v":null},{"$f":"'Balance Sheet'!H21","v":null},{"$f":"'Balance Sheet'!I21","v":null},{"$f":"'Balance Sheet'!J21","v":null},{"$f":"'Balance Sheet'!K21","v":null}]
["Debtor Days",{"$f":"'Balance Sheet'!B22","v":null},{"$f":"'Balance Sheet'!C22","v":null},{"$f":"'Balance Sheet'!D22","v":null},{"$f":"'Balance Sheet'!E22","v":null},{"$f":"'Balance Sheet'!F22","v":null},{"$f":"'Balance Sheet'!G22","v":null},{"$f":"'Balance Sheet'!H22","v":null},{"$f":"'Balance Sheet'!I22","v":null},{"$f":"'Balance Sheet'!J22","v":null},{"$f":"'Balance Sheet'!K22","v":null}]
["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":null},{"$f":"('Data Sheet'!C67+'Data Sheet'!C69)/'Data Sheet'!C60","v":null},{"$f":"('Data Sheet'!D67+'Data Sheet'!D69)/'Data Sheet'!D60","v":null},{"$f":"('Data Sheet'!E67+'Data Sheet'!E69)/'Data Sheet'!E60","v":null},{"$f":"('Data Sheet'!F67+'Data Sheet'!F69)/'Data Sheet'!F60","v":null},{"$f":"('Data Sheet'!G67+'Data Sheet'!G69)/'Data Sheet'!G60","v":null},{"$f":"('Data Sheet'!H67+'Data Sheet'!H69)/'Data Sheet'!H60","v":null},{"$f":"('Data Sheet'!I67+'Data Sheet'!I69)/'Data Sheet'!I60","v":null},{"$f":"('Data Sheet'!J67+'Data Sheet'!J69)/'Data Sheet'!J60","v":null},{"$f":"('Data Sheet'!K67+'Data Sheet'!K69)/'Data Sheet'!K60","v":null},null,"  "]
["Current Ratio",{"$f":"'Data Sheet'!B65/'Data Sheet'!B60","v":null},{"$f":"'Data Sheet'!C65/'Data Sheet'!C60","v":null},{"$f":"'Data Sheet'!D65/'Data Sheet'!D60","v":null},{"$f":"'Data Sheet'!E65/'Data Sheet'!E60","v":null},{"$f":"'Data Sheet'!F65/'Data Sheet'!F60","v":null},{"$f":"'Data Sheet'!G65/'Data Sheet'!G60","v":null},{"$f":"'Data Sheet'!H65/'Data Sheet'!H60","v":null},{"$f":"'Data Sheet'!I65/'Data Sheet'!I60","v":null},{"$f":"'Data Sheet'!J65/'Data Sheet'!J60","v":null},{"$f":"'Data Sheet'!K65/'Data Sheet'!K60","v":null}," "]
["CFO/PAT",{"$f":"'Calculated Data'!B17/'Calculated Data'!B8","v":null},{"$f":"'Calculated Data'!C17/'Calculated Data'!C8","v":null},{"$f":"'Calculated Data'!D17/'Calculated Data'!D8","v":null},{"$f":"'Calculated Data'!E17/'Calculated Data'!E8","v":null},{"$f":"'Calculated Data'!F17/'Calculated Data'!F8","v":null},{"$f":"'Calculated Data'!G17/'Calculated Data'!G8","v":null},{"$f":"'Calculated Data'!H17/'Calculated Data'!H8","v":null},{"$f":"'Calculated Data'!I17/'Calculated Data'!I8","v":null},{"$f":"'Calculated Data'!J17/'Calculated Data'!J8","v":null},{"$f":"'Calculated Data'!K17/'Calculated Data'!K8","v":null}]
[null,null,null,null,null,null,null,null,null,null,null," "]
["Gross Margin =Gross Profit/Sales",{"$f":"'Calculated Data'!B4/'Data Sheet'!B17","v":null},{"$f":"'Calculated Data'!C4/'Data Sheet'!C17","v":null},{"$f":"'Calculated Data'!D4/'Data Sheet'!D17","v":null},{"$f":"'Calculated Data'!E4/'Data Sheet'!E17","v":null},{"$f":"'Calculated Data'!F4/'Data Sheet'!F17","v":null},{"$f":"'Calculated Data'!G4/'Data Sheet'!G17","v":null},{"$f":"'Calculated Data'!H4/'Data Sheet'!H17","v":null},{"$f":"'Calculated Data'!I4/'Data Sheet'!I17","v":null},{"$f":"'Calculated Data'!J4/'Data Sheet'!J17","v":null},{"$f":"'Calculated Data'!K4/'Data Sheet'!K17","v":null}]
["EBIT/Sales",{"$f":"'Calculated Data'!B5/'Data Sheet'!B17","v":null},{"$f":"'Calculated Data'!C5/'Data Sheet'!C17","v":null},{"$f":"'Calculated Data'!D5/'Data Sheet'!D17","v":null},{"$f":"'Calculated Data'!E5/'Data Sheet'!E17","v":null},{"$f":"'Calculated Data'!F5/'Data Sheet'!F17","v":null},{"$f":"'Calculated Data'!G5/'Data Sheet'!G17","v":null},{"$f":"'Calculated Data'!H5/'Data Sheet'!H17","v":null},{"$f":"'Calculated Data'!I5/'Data Sheet'!I17","v":null},{"$f":"'Calculated Data'!J5/'Data Sheet'!J17","v":null},{"$f":"'Calculated Data'!K5/'Data Sheet'!K17","v":null}]
["EBITDA/Sales",{"$f":"'Calculated Data'!B6/'Data Sheet'!B17","v":null},{"$f":"'Calculated Data'!C6/'Data Sheet'!C17","v":null},{"$f":"'Calculated Data'!D6/'Data Sheet'!D17","v":null},{"$f":"'Calculated Data'!E6/'Data Sheet'!E17","v":null},{"$f":"'Calculated Data'!F6/'Data Sheet'!F17","v":null},{"$f":"'Calculated Data'!G6/'Data Sheet'!G17","v":null},{"$f":"'Calculated Data'!H6/'Data Sheet'!H17","v":null},{"$f":"'Calculated Data'!I6/'Data Sheet'!I17","v":null},{"$f":"'Calculated Data'!J6/'Data Sheet'!J17","v":null},{"$f":"'Calculated Data'!K6/'Data Sheet'!K17","v":null}]
["Op Profit (Ex Other Income)/Sales",{"$f":"'Calculated Data'!B7/'Data Sheet'!B17","v":null},{"$f":"'Calculated Data'!C7/'Data Sheet'!C17","v":null},{"$f":"'Calculated Data'!D7/'Data Sheet'!D17","v":null},{"$f":"'Calculated Data'!E7/'Data Sheet'!E17","v":null},{"$f":"'Calculated Data'!F7/'Data Sheet'!F17","v":null},{"$f":"'Calculated Data'!G7/'Data Sheet'!G17","v":null},{"$f":"'Calculated Data'!H7/'Data Sheet'!H17","v":null},{"$f":"'Calculated Data'!I7/'Data Sheet'!I17","v":null},{"$f":"'Calculated Data'!J7/'Data Sheet'!J17","v":null},{"$f":"'Calculated Data'!K7/'Data Sheet'!K17","v":null}]
["Net Margin =PAT/Sales",{"$f":"'Calculated Data'!B8/'Data Sheet'!B17","v":null},{"$f":"'Calculated Data'!C8/'Data Sheet'!C17","v":null},{"$f":"'Calculated Data'!D8/'Data Sheet'!D17","v":null},{"$f":"'Calculated Data'!E8/'Data Sheet'!E17","v":null},{"$f":"'Calculated Data'!F8/'Data Sheet'!F17","v":null},{"$f":"'Calculated Data'!G8/'Data Sheet'!G17","v":null},{"$f":"'Calculated Data'!H8/'Data Sheet'!H17","v":null},{"$f":"'Calculated Data'!I8/'Data Sheet'!I17","v":null},{"$f":"'Calculated Data'!J8/'Data Sheet'!J17","v":null},{"$f":"'Calculated Data'!K8/'Data Sheet'!K17","v":null}]
["Op Cash Flow/Sales",{"$f":"'Calculated Data'!B17/'Data Sheet'!B17","v":null},{"$f":"'Calculated Data'!C17/'Data Sheet'!C17","v":null},{"$f":"'Calculated Data'!D17/'Data Sheet'!D17","v":null},{"$f":"'Calculated Data'!E17/'Data Sheet'!E17","v":null},{"$f":"'Calculated Data'!F17/'Data Sheet'!F17","v":null},{"$f":"'Calculated Data'!G17/'Data Sheet'!G17","v":null},{"$f":"'Calculated Data'!H17/'Data Sheet'!H17","v":null},{"$f":"'Calculated Data'!I17/'Data Sheet'!I17","v":null},{"$f":"'Calculated Data'!J17/'Data Sheet'!J17","v":null},{"$f":"'Calculated Data'!K17/'Data Sheet'!K17","v":null}]
["Free Cash Flow/Sales",{"$f":"'Calculated Data'!B19/'Data Sheet'!B17","v":null},{"$f":"'Calculated Data'!C19/'Data Sheet'!C17","v":null},{"$f":"'Calculated Data'!D19/'Data Sheet'!D17","v":null},{"$f":"'Calculated Data'!E19/'Data Sheet'!E17","v":null},{"$f":"'Calculated Data'!F19/'Data Sheet'!F17","v":null},{"$f":"'Calculated Data'!G19/'Data Sheet'!G17","v":null},{"$f":"'Calculated Data'!H19/'Data Sheet'!H17","v":null},{"$f":"'Calculated Data'!I19/'Data Sheet'!I17","v":null},{"$f":"'Calculated Data'!J19/'Data Sheet'!J17","v":null},{"$f":"'Calculated Data'!K19/'Data Sheet'!K17","v":null}]
["EPA/Sales",{"$f":"'Calculated Data'!B24/'Data Sheet'!B17","v":null},{"$f":"'Calculated Data'!C24/'Data Sheet'!C17","v":null},{"$f":"'Calculated Data'!D24/'Data Sheet'!D17","v":null},{"$f":"'Calculated Data'!E24/'Data Sheet'!E17","v":null},{"$f":"'Calculated Data'!F24/'Data Sheet'!F17","v":null},{"$f":"'Calculated Data'!G24/'Data Sheet'!G17","v":null},{"$f":"'Calculated Data'!H24/'Data Sheet'!H17","v":null},{"$f":"'Calculated Data'!I24/'Data Sheet'!I17","v":null},{"$f":"'Calculated Data'!J24/'Data Sheet'!J17","v":null},{"$f":"'Calculated Data'!K24/'Data Sheet'!K17","v":null}]
[]
["Sales/Invested Capital =Capital Turns",{"$f":"'Data Sheet'!B17/'Calculated Data'!B13","v":null},{"$f":"'Data Sheet'!C17/'Calculated Data'!C13","v":null},{"$f":"'Data Sheet'!D17/'Calculated Data'!D13","v":null},{"$f":"'Data Sheet'!E17/'Calculated Data'!E13","v":null},{"$f":"'Data Sheet'!F17/'Calculated Data'!F13","v":null},{"$f":"'Data Sheet'!G17/'Calculated Data'!G13","v":null},{"$f":"'Data Sheet'!H17/'Calculated Data'!H13","v":null},{"$f":"'Data Sheet'!I17/'Calculated Data'!I13","v":null},{"$f":"'Data Sheet'!J17/'Calculated Data'!J13","v":null},{"$f":"'Data Sheet'!K17/'Calculated Data'!K13","v":null}]
["Sales/Fixed Assets= Fixed Asset Turns",{"$f":"'Data Sheet'!B17/'Data Sheet'!B62","v":null},{"$f":"'Data Sheet'!C17/'Data Sheet'!C62","v":null},{"$f":"'Data Sheet'!D17/'Data Sheet'!D62","v":null},{"$f":"'Data Sheet'!E17/'Data Sheet'!E62","v":null},{"$f":"'Data Sheet'!F17/'Data Sheet'!F62","v":null},{"$f":"'Data Sheet'!G17/'Data Sheet'!G62","v":null},{"$f":"'Data Sheet'!H17/'Data Sheet'!H62","v":null},{"$f":"'Data Sheet'!I17/'Data Sheet'!I62","v":null},{"$f":"'Data Sheet'!J17/'Data Sheet'!J62","v":null},{"$f":"'Data Sheet'!K17/'Data Sheet'!K62","v":null}]
["Sales/Total Assets= Asset Turns",{"$f":"'Data Sheet'!B17/'Calculated Data'!B15","v":null},{"$f":"'Data Sheet'!C17/'Calculated Data'!C15","v":null},{"$f":"'Data Sheet'!D17/'Calculated Data'!D15","v":null},{"$f":"'Data Sheet'!E17/'Calculated Data'!E15","v":null},{"$f":"'Data Sheet'!F17/'Calculated Data'!F15","v":null},{"$f":"'Data Sheet'!G17/'Calculated Data'!G15","v":null},{"$f":"'Data Sheet'!H17/'Calculated Data'!H15","v":null},{"$f":"'Data Sheet'!I17/'Calculated Data'!I15","v":null},{"$f":"'Data Sheet'!J17/'Calculated Data'!J15","v":null},{"$f":"'Data Sheet'!K17/'Calculated Data'!K15","v":null}]
["Net Margin*Asset Turns= RoA",{"$f":"B39*B46","v":null},{"$f":"C39*C46","v":null},null,null,null,null,null,null,null,null,"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":null},null,null,null,null,null,null,null,null,null,"Check back what is really driving RoE (Net Margins, Asset Turns, or Financial Leverage)"]
["RoCE",{"$f":"'Calculated Data'!B5/'Calculated Data'!B14","v":null},{"$f":"'Calculated Data'!C5/'Calculated Data'!C14","v":null},{"$f":"'Calculated Data'!D5/'Calculated Data'!D14","v":null},{"$f":"'Calculated Data'!E5/'Calculated Data'!E14","v":null},{"$f":"'Calculated Data'!F5/'Calculated Data'!F14","v":null},{"$f":"'Calculated Data'!G5/'Calculated Data'!G14","v":null},{"$f":"'Calculated Data'!H5/'Calculated Data'!H14","v":null},{"$f":"'Calculated Data'!I5/'Calculated Data'!I14","v":null},{"$f":"'Calculated Data'!J5/'Calculated Data'!J14","v":null},{"$f":"'Calculated Data'!K5/'Calculated Data'!K14","v":null}]
["EBIT Margin*Cap Turns*(1-Tax rate)= RoIC",{"$f":"B36*B44*(1-'Calculated Data'!B20)","v":null},{"$f":"C36*C44*(1-'Calculated Data'!C20)","v":null},{"$f":"D36*D44*(1-'Calculated Data'!D20)","v":null},{"$f":"E36*E44*(1-'Calculated Data'!E20)","v":null},{"$f":"F36*F44*(1-'Calculated Data'!F20)","v":null},{"$f":"G36*G44*(1-'Calculated Data'!G20)","v":null},{"$f":"H36*H44*(1-'Calculated Data'!H20)","v":null},{"$f":"I36*I44*(1-'Calculated Data'!I20)","v":null},{"$f":"J36*J44*(1-'Calculated Data'!J20)","v":null},{"$f":"K36*K44*(1-'Calculated Data'!K20)","v":null},"Check back what is really driving RoIC (Op Margins or Capital Turns, or both)"]
[]
["Altman Z-Score",{"$f":"'Calculated Data'!B43","v":null},{"$f":"'Calculated Data'!C43","v":null},{"$f":"'Calculated Data'!D43","v":null},{"$f":"'Calculated Data'!E43","v":null},{"$f":"'Calculated Data'!F43","v":null},{"$f":"'Calculated Data'!G43","v":null},{"$f":"'Calculated Data'!H43","v":null},{"$f":"'Calculated Data'!I43","v":null},{"$f":"'Calculated Data'!J43","v":null},{"$f":"'Calculated Data'!K43","v":null}]
["Dividend Payout",{"$f":"'Data Sheet'!B31/'Data Sheet'!B30","v":null},{"$f":"'Data Sheet'!C31/'Data Sheet'!C30","v":null},{"$f":"'Data Sheet'!D31/'Data Sheet'!D30","v":null},{"$f":"'Data Sheet'!E31/'Data Sheet'!E30","v":null},{"$f":"'Data Sheet'!F31/'Data Sheet'!F30","v":null},{"$f":"'Data Sheet'!G31/'Data Sheet'!G30","v":null},{"$f":"'Data Sheet'!H31/'Data Sheet'!H30","v":null},{"$f":"'Data Sheet'!I31/'Data Sheet'!I30","v":null},{"$f":"'Data Sheet'!J31/'Data Sheet'!J30","v":null},{"$f":"'Data Sheet'!K31/'Data Sheet'!K30","v":null}]
["Cash/Assets",{"$f":"'Data Sheet'!B69/'Data Sheet'!B61","v":null},{"$f":"'Data Sheet'!C69/'Data Sheet'!C61","v":null},{"$f":"'Data Sheet'!D69/'Data Sheet'!D61","v":null},{"$f":"'Data Sheet'!E69/'Data Sheet'!E61","v":null},{"$f":"'Data Sheet'!F69/'Data Sheet'!F61","v":null},{"$f":"'Data Sheet'!G69/'Data Sheet'!G61","v":null},{"$f":"'Data Sheet'!H69/'Data Sheet'!H61","v":null},{"$f":"'Data Sheet'!I69/'Data Sheet'!I61","v":null},{"$f":"'Data Sheet'!J69/'Data Sheet'!J61","v":null},{"$f":"'Data Sheet'!K69/'Data Sheet'!K61","v":null}]
["EBIT/Invested Capital",{"$f":"'Calculated Data'!B5/'Calculated Data'!B13","v":null},{"$f":"'Calculated Data'!C5/'Calculated Data'!C13","v":null},{"$f":"'Calculated Data'!D5/'Calculated Data'!D13","v":null},{"$f":"'Calculated Data'!E5/'Calculated Data'!E13","v":null},{"$f":"'Calculated Data'!F5/'Calculated Data'!F13","v":null},{"$f":"'Calculated Data'!G5/'Calculated Data'!G13","v":null},{"$f":"'Calculated Data'!H5/'Calculated Data'!H13","v":null},{"$f":"'Calculated Data'!I5/'Calculated Data'!I13","v":null},{"$f":"'Calculated Data'!J5/'Calculated Data'!J13","v":null},{"$f":"'Calculated Data'!K5/'Calculated Data'!K13","v":null},"Check back the significant role of EBIT/Invested Capital "]
["EPA",{"$f":"'Calculated Data'!B24","v":null},{"$f":"'Calculated Data'!C24","v":null},{"$f":"'Calculated Data'!D24","v":null},{"$f":"'Calculated Data'!E24","v":null},{"$f":"'Calculated Data'!F24","v":null},{"$f":"'Calculated Data'!G24","v":null},{"$f":"'Calculated Data'!H24","v":null},{"$f":"'Calculated Data'!I24","v":null},{"$f":"'Calculated Data'!J24","v":null},{"$f":"'Calculated Data'!K24","v":null},"Check back what is really driving EPA (Invested Capital or RoIC, or both)"]
["MktCap",{"$f":"'Calculated Data'!B26","v":null},{"$f":"'Calculated Data'!C26","v":null},{"$f":"'Calculated Data'!D26","v":null},{"$f":"'Calculated Data'!E26","v":null},{"$f":"'Calculated Data'!F26","v":null},{"$f":"'Calculated Data'!G26","v":null},{"$f":"'Calculated Data'!H26","v":null},{"$f":"'Calculated Data'!I26","v":null},{"$f":"'Calculated Data'!J26","v":null},{"$f":"'Calculated Data'!K26","v":null}]
["MktCap Change",null,{"$f":"C57-B57","v":null},{"$f":"D57-C57","v":null}]
["MktCap Change - EPA",null,{"$f":"C58-C56","v":null}]
[]
["Capex/Net Profits 10 yr",{"$f":"SUM('Calculated Data'!B$18:K$18)/SUM('Calculated Data'!B$8:K$8)","v":null}]
["Capex/Net Profits 7 yr",{"$f":"SUM('Calculated Data'!E$18:K$18)/SUM('Calculated Data'!E$8:K$8)","v":null}]
["Capex/Net Profits 5 yr",{"$f":"SUM('Calculated Data'!G$18:K$18)/SUM('Calculated Data'!G$8:K$8)","v":null}]
["Capex/Net Profits 3 yr",{"$f":"SUM('Calculated Data'!I$18:K$18)/SUM('Calculated Data'!I$8:K$8)","v":null}]
["Capex/Depreciation 10 yr",{"$f":"SUM('Calculated Data'!B$18:K$18)/SUM('Data Sheet'!B26:K26)","v":null}]

{"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","HINDUSTAN UNILEVER 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":null}]
["Face Value",1.00]
["Current Price",1086.40]
["Market Capitalization",235134.94]
[]
[]
[]
[]
[]
["PROFIT & LOSS"]
["Report Date","2006-12-31","2007-12-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",12410.98,13871.08,20501.10,17764.27,20022.55,23436.33,27003.99,29233.74,31972.19,33193.72]
["Raw Material Cost",5659.96,6280.91,9571.38,7554.93,8794.99,10308.66,11947.57,12644.63,13509.40,13186.04]
["Change in Inventory",70.23,91.39,320.72,-75.65,307.60,-95.15,26.00,171.30,-57.04,-88.28]
["Power and Fuel",193.07,201.46,304.47,247.06,278.54,299.63,335.94,362.76,346.97,309.21]
["Other Mfr. Exp",1371.92,1500.01,2177.07,1769.73,2165.89,2603.89,2716.40,2939.55,3164.64,3054.00]
["Employee Cost",784.21,799.60,1259.88,1148.12,1016.67,1207.44,1431.62,1572.66,1723.87,1742.24]
["Selling and admin",2371.52,2578.14,3884.14,3912.10,4666.41,4583.67,5417.15,6117.42,6680.91,7601.90]
["Other Expenses",719.79,779.95,1184.35,692.49,710.33,883.21,1021.28,1036.18,1093.31,1414.19]
["Other Income",998.94,674.34,814.28,629.18,489.89,402.19,1183.04,819.56,1263.55,510.52]
["Depreciation",135.67,141.91,199.97,191.94,229.29,233.54,251.32,295.54,322.39,357.28]
["Interest",13.97,26.49,26.45,7.47,1.01,1.65,25.72,40.68,17.70,4.54]
["Profit before tax",2230.04,2328.34,3028.39,2793.96,2956.91,3621.68,5066.03,5215.18,6319.51,5946.56]
["Tax",335.88,409.47,518.45,629.35,650.28,821.54,1226.66,1259.44,1944.00,1852.48]
["Net profit",1890.53,1914.89,2504.51,2156.63,2296.05,2790.66,3828.98,3945.57,4363.08,4082.42]
["Dividend Amount",1325.48,1976.12,1634.51,1417.94,1410.60,1620.94,3999.99,2811.43,3245.32,3462.26]
[]
[]
[]
[]
[]
[]
[]
[]
["Quarters"]
["Report Date","2014-06-30","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"]
["Sales",16.18,17.260000000000002,16.87,16.59,14.53,18.45,12.92,17.93,16.23,10.61]
["Expenses",14.76,15.85,14.82,14.47,12.77,14.95,10.31,14.61,13.11,9.3800000000000008]
["Other Income",1.1399999999999999,0.6,0.6,0.62,0.57999999999999996,0.91,0.71,0.77,0.77,0.65]
["Depreciation",0.35,0.13,0.14000000000000001,0.2,0.18,0.18,0.18,0.18,0.16,0.16]
["Interest",7.0000000000000007E-2,0.04,7.0000000000000007E-2,0.08,0.05,0.06,0.06,0.09,7.0000000000000007E-2,0.1]
["Profit before tax",2.15,1.83,2.4300000000000002,2.4500000000000002,2.11,4.16,3.08,3.82,3.66,1.63]
["Tax",0.7,0.65,0.79,0.78,0.73,1.4,1.2,1.35,1.32,0.55000000000000004]
["Net profit",1.46,1.18,1.64,1.68,1.38,2.76,1.88,2.4700000000000002,2.34,1.08]
["Operating Profit",1.42,1.41,2.0499999999999998,2.12,1.76,3.5,2.61,3.32,3.12,1.23]
[]
[]
[]
[]
["BALANCE SHEET"]
["Report Date","2006-12-31","2007-12-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",220.68,217.75,217.99,218.17,215.95,216.15,216.25,216.27,216.35,216.39]
["Reserves",2402.13,1289.74,1918.81,2450.09,2518.33,3464.26,2647.85,3320.35,3810.46,3754.65]
["Borrowings",92.49,102.15,434.13,10.84,null,null,24.74,45.58,43.04,254.78]
["Other Liabilities",4803.26,5396.46,6066.45,7034.44,7807.09,7924.29,9420.83,10412.69,10637.39,11223.83]
["Total",7518.56,7006.10,8637.38,9713.54,10541.37,11604.70,12309.67,13994.89,14707.24,15449.65]
["Net Block",1469.07,1558.90,1657.99,2214.36,2223.45,2262.86,2431.43,2746.24,2821.01,3300.56]
["Capital Work in Progress",116.11,188.82,477.85,279.98,289.19,227.64,222.42,372.60,516.30,427.33]
["Investments",2352.33,1429.19,287.64,1224.43,1188.50,2322.16,2252.34,2838.14,3025.08,2747.42]
["Other Assets",3581.05,3829.19,6213.90,5994.77,6840.23,6792.04,7403.48,8037.91,8344.85,8974.34]
["Total",7518.56,7006.10,8637.38,9713.54,10541.37,11604.70,12309.67,13994.89,14707.24,15449.65]
["Receivables",480.39,464.93,560.57,684.81,963.29,856.74,996.53,1016.81,1010.28,1268.51]
["Inventory",1604.37,2003.77,2580.53,2226.41,2875.69,2667.37,2705.97,2939.83,2848.79,2752.13]
["Cash & Bank",460.90,262.42,1864.11,2012.38,1775.68,1996.43,1900.71,2516.03,2689.49,3027.84]
["No. of Equity Shares",2206776097.00,2177463355.00,2179876077.00,2181686781.00,2159471968.00,2161512492.00,2162472310.00,2162696292.00,2163464851.00,2163936971.00]
["New Bonus Shares"]
["Face value",1.00,1.00,1.00,1.00,1.00,1.00,1.00,1.00,1.00,1.00]
[]
[]
[]
[]
[]
[]
[]
["CASH FLOW:"]
["Report Date","2006-12-31","2007-12-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",1671.39,1732.08,2054.05,3479.57,1923.61,2931.51,3604.76,3818.18,3291.91,4125.34]
["Cash from Investing Activity",-244.07,1000.96,885.37,-1143.51,-327.13,-514.34,63.07,-475.04,137.97,-268.23]
["Cash from Financing Activity",-1391.38,-2931.52,-1337.73,-2187.79,-2283.18,-1725.58,-4147.41,-2960.29,-3462.42,-3818.95]
["Net Cash Flow",35.94,-198.48,1601.69,148.27,-686.70,691.59,-479.58,382.85,-32.54,38.16]
[]
[]
[]
[]
["PRICE:",281.51,205.71,235.38,230.94,280.47,416.14,481.20,597.77,901.91,878.35]
[]
["DERIVED:"]
["Adjusted Equity Shares in Cr",{"$f":"IF($B7>0,(B70*B72/$B7)+SUM(C71:$K71),0)/10000000","v":null},{"$f":"IF($B7>0,(C70*C72/$B7)+SUM(D71:$K71),0)/10000000","v":null},{"$f":"IF($B7>0,(D70*D72/$B7)+SUM(E71:$K71),0)/10000000","v":null},{"$f":"IF($B7>0,(E70*E72/$B7)+SUM(F71:$K71),0)/10000000","v":null},{"$f":"IF($B7>0,(F70*F72/$B7)+SUM(G71:$K71),0)/10000000","v":null},{"$f":"IF($B7>0,(G70*G72/$B7)+SUM(H71:$K71),0)/10000000","v":null},{"$f":"IF($B7>0,(H70*H72/$B7)+SUM(I71:$K71),0)/10000000","v":null},{"$f":"IF($B7>0,(I70*I72/$B7)+SUM(J71:$K71),0)/10000000","v":null},{"$f":"IF($B7>0,(J70*J72/$B7)+SUM(K71:$K71),0)/10000000","v":null},{"$f":"IF($B7>0,(K70*K72/$B7),0)/10000000","v":null}]

{"sheet":"Calculated Data","index":6,"n_rows":46,"n_cols":13,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Data Sheet'!B1","v":""}]
[]
[{"$f":"A1","v":""},{"$f":"'Data Sheet'!B16","v":null},{"$f":"'Data Sheet'!C16","v":null},{"$f":"'Data Sheet'!D16","v":null},{"$f":"'Data Sheet'!E16","v":null},{"$f":"'Data Sheet'!F16","v":null},{"$f":"'Data Sheet'!G16","v":null},{"$f":"'Data Sheet'!H16","v":null},{"$f":"'Data Sheet'!I16","v":null},{"$f":"'Data Sheet'!J16","v":null},{"$f":"'Data Sheet'!K16","v":null}]
["Gross Profit",{"$f":"'Data Sheet'!B17-'Data Sheet'!B18","v":null},{"$f":"'Data Sheet'!C17-'Data Sheet'!C18","v":null},{"$f":"'Data Sheet'!D17-'Data Sheet'!D18","v":null},{"$f":"'Data Sheet'!E17-'Data Sheet'!E18","v":null},{"$f":"'Data Sheet'!F17-'Data Sheet'!F18","v":null},{"$f":"'Data Sheet'!G17-'Data Sheet'!G18","v":null},{"$f":"'Data Sheet'!H17-'Data Sheet'!H18","v":null},{"$f":"'Data Sheet'!I17-'Data Sheet'!I18","v":null},{"$f":"'Data Sheet'!J17-'Data Sheet'!J18","v":null},{"$f":"'Data Sheet'!K17-'Data Sheet'!K18","v":null}]
["EBIT",{"$f":"'Data Sheet'!B28+'Data Sheet'!B27","v":null},{"$f":"'Data Sheet'!C28+'Data Sheet'!C27","v":null},{"$f":"'Data Sheet'!D28+'Data Sheet'!D27","v":null},{"$f":"'Data Sheet'!E28+'Data Sheet'!E27","v":null},{"$f":"'Data Sheet'!F28+'Data Sheet'!F27","v":null},{"$f":"'Data Sheet'!G28+'Data Sheet'!G27","v":null},{"$f":"'Data Sheet'!H28+'Data Sheet'!H27","v":null},{"$f":"'Data Sheet'!I28+'Data Sheet'!I27","v":null},{"$f":"'Data Sheet'!J28+'Data Sheet'!J27","v":null},{"$f":"'Data Sheet'!K28+'Data Sheet'!K27","v":null}]
["EBITDA",{"$f":"'Calculated Data'!B5+'Data Sheet'!B26","v":null},{"$f":"'Calculated Data'!C5+'Data Sheet'!C26","v":null},{"$f":"'Calculated Data'!D5+'Data Sheet'!D26","v":null},{"$f":"'Calculated Data'!E5+'Data Sheet'!E26","v":null},{"$f":"'Calculated Data'!F5+'Data Sheet'!F26","v":null},{"$f":"'Calculated Data'!G5+'Data Sheet'!G26","v":null},{"$f":"'Calculated Data'!H5+'Data Sheet'!H26","v":null},{"$f":"'Calculated Data'!I5+'Data Sheet'!I26","v":null},{"$f":"'Calculated Data'!J5+'Data Sheet'!J26","v":null},{"$f":"'Calculated Data'!K5+'Data Sheet'!K26","v":null}]
["Operating Profit (excl Other Income)",{"$f":"B6-'Data Sheet'!B25","v":null},{"$f":"C6-'Data Sheet'!C25","v":null},{"$f":"D6-'Data Sheet'!D25","v":null},{"$f":"E6-'Data Sheet'!E25","v":null},{"$f":"F6-'Data Sheet'!F25","v":null},{"$f":"G6-'Data Sheet'!G25","v":null},{"$f":"H6-'Data Sheet'!H25","v":null},{"$f":"I6-'Data Sheet'!I25","v":null},{"$f":"J6-'Data Sheet'!J25","v":null},{"$f":"K6-'Data Sheet'!K25","v":null}]
["PAT",{"$f":"'Data Sheet'!B30","v":null},{"$f":"'Data Sheet'!C30","v":null},{"$f":"'Data Sheet'!D30","v":null},{"$f":"'Data Sheet'!E30","v":null},{"$f":"'Data Sheet'!F30","v":null},{"$f":"'Data Sheet'!G30","v":null},{"$f":"'Data Sheet'!H30","v":null},{"$f":"'Data Sheet'!I30","v":null},{"$f":"'Data Sheet'!J30","v":null},{"$f":"'Data Sheet'!K30","v":null}]
["Dividend",{"$f":"'Data Sheet'!B31","v":null},{"$f":"'Data Sheet'!C31","v":null},{"$f":"'Data Sheet'!D31","v":null},{"$f":"'Data Sheet'!E31","v":null},{"$f":"'Data Sheet'!F31","v":null},{"$f":"'Data Sheet'!G31","v":null},{"$f":"'Data Sheet'!H31","v":null},{"$f":"'Data Sheet'!I31","v":null},{"$f":"'Data Sheet'!J31","v":null},{"$f":"'Data Sheet'!K31","v":null}]
[null,{"$f":"B3","v":null},{"$f":"C3","v":null}]
["Networth",{"$f":"'Data Sheet'!B57+'Data Sheet'!B58","v":null},{"$f":"'Data Sheet'!C57+'Data Sheet'!C58","v":null},{"$f":"'Data Sheet'!D57+'Data Sheet'!D58","v":null},{"$f":"'Data Sheet'!E57+'Data Sheet'!E58","v":null},{"$f":"'Data Sheet'!F57+'Data Sheet'!F58","v":null},{"$f":"'Data Sheet'!G57+'Data Sheet'!G58","v":null},{"$f":"'Data Sheet'!H57+'Data Sheet'!H58","v":null},{"$f":"'Data Sheet'!I57+'Data Sheet'!I58","v":null},{"$f":"'Data Sheet'!J57+'Data Sheet'!J58","v":null},{"$f":"'Data Sheet'!K57+'Data Sheet'!K58","v":null}]
["Working Capital",{"$f":"'Data Sheet'!B65-'Data Sheet'!B60","v":null},{"$f":"'Data Sheet'!C65-'Data Sheet'!C60","v":null},{"$f":"'Data Sheet'!D65-'Data Sheet'!D60","v":null},{"$f":"'Data Sheet'!E65-'Data Sheet'!E60","v":null},{"$f":"'Data Sheet'!F65-'Data Sheet'!F60","v":null},{"$f":"'Data Sheet'!G65-'Data Sheet'!G60","v":null},{"$f":"'Data Sheet'!H65-'Data Sheet'!H60","v":null},{"$f":"'Data Sheet'!I65-'Data Sheet'!I60","v":null},{"$f":"'Data Sheet'!J65-'Data Sheet'!J60","v":null},{"$f":"'Data Sheet'!K65-'Data Sheet'!K60","v":null}]
["Invested Capital",{"$f":"'Data Sheet'!B62+'Data Sheet'!B63+'Calculated Data'!B12","v":null},{"$f":"'Data Sheet'!C62+'Data Sheet'!C63+'Calculated Data'!C12","v":null},{"$f":"'Data Sheet'!D62+'Data Sheet'!D63+'Calculated Data'!D12","v":null},{"$f":"'Data Sheet'!E62+'Data Sheet'!E63+'Calculated Data'!E12","v":null},{"$f":"'Data Sheet'!F62+'Data Sheet'!F63+'Calculated Data'!F12","v":null},{"$f":"'Data Sheet'!G62+'Data Sheet'!G63+'Calculated Data'!G12","v":null},{"$f":"'Data Sheet'!H62+'Data Sheet'!H63+'Calculated Data'!H12","v":null},{"$f":"'Data Sheet'!I62+'Data Sheet'!I63+'Calculated Data'!I12","v":null},{"$f":"'Data Sheet'!J62+'Data Sheet'!J63+'Calculated Data'!J12","v":null},{"$f":"'Data Sheet'!K62+'Data Sheet'!K63+'Calculated Data'!K12","v":null}]
["Capital Employed",{"$f":"B11+'Data Sheet'!B59","v":null},{"$f":"C11+'Data Sheet'!C59","v":null},{"$f":"D11+'Data Sheet'!D59","v":null},{"$f":"E11+'Data Sheet'!E59","v":null},{"$f":"F11+'Data Sheet'!F59","v":null},{"$f":"G11+'Data Sheet'!G59","v":null},{"$f":"H11+'Data Sheet'!H59","v":null},{"$f":"I11+'Data Sheet'!I59","v":null},{"$f":"J11+'Data Sheet'!J59","v":null},{"$f":"K11+'Data Sheet'!K59","v":null}]
["Total Assets",{"$f":"'Data Sheet'!B61","v":null},{"$f":"'Data Sheet'!C61","v":null},{"$f":"'Data Sheet'!D61","v":null},{"$f":"'Data Sheet'!E61","v":null},{"$f":"'Data Sheet'!F61","v":null},{"$f":"'Data Sheet'!G61","v":null},{"$f":"'Data Sheet'!H61","v":null},{"$f":"'Data Sheet'!I61","v":null},{"$f":"'Data Sheet'!J61","v":null},{"$f":"'Data Sheet'!K61","v":null}]
[null,{"$f":"B3","v":null},{"$f":"C3","v":null}]
["Operating Cash Flow",{"$f":"'Data Sheet'!B82","v":null},{"$f":"'Data Sheet'!C82","v":null},{"$f":"'Data Sheet'!D82","v":null},{"$f":"'Data Sheet'!E82","v":null},{"$f":"'Data Sheet'!F82","v":null},{"$f":"'Data Sheet'!G82","v":null},{"$f":"'Data Sheet'!H82","v":null},{"$f":"'Data Sheet'!I82","v":null},{"$f":"'Data Sheet'!J82","v":null},{"$f":"'Data Sheet'!K82","v":null}]
["Capex",null,{"$f":"('Data Sheet'!C62-'Data Sheet'!B62)+('Data Sheet'!C63-'Data Sheet'!B63)+'Data Sheet'!C26","v":null},{"$f":"('Data Sheet'!D62-'Data Sheet'!C62)+('Data Sheet'!D63-'Data Sheet'!C63)+'Data Sheet'!D26","v":null},{"$f":"('Data Sheet'!E62-'Data Sheet'!D62)+('Data Sheet'!E63-'Data Sheet'!D63)+'Data Sheet'!E26","v":null},{"$f":"('Data Sheet'!F62-'Data Sheet'!E62)+('Data Sheet'!F63-'Data Sheet'!E63)+'Data Sheet'!F26","v":null},{"$f":"('Data Sheet'!G62-'Data Sheet'!F62)+('Data Sheet'!G63-'Data Sheet'!F63)+'Data Sheet'!G26","v":null},{"$f":"('Data Sheet'!H62-'Data Sheet'!G62)+('Data Sheet'!H63-'Data Sheet'!G63)+'Data Sheet'!H26","v":null},{"$f":"('Data Sheet'!I62-'Data Sheet'!H62)+('Data Sheet'!I63-'Data Sheet'!H63)+'Data Sheet'!I26","v":null},{"$f":"('Data Sheet'!J62-'Data Sheet'!I62)+('Data Sheet'!J63-'Data Sheet'!I63)+'Data Sheet'!J26","v":null},{"$f":"('Data Sheet'!K62-'Data Sheet'!J62)+('Data Sheet'!K63-'Data Sheet'!J63)+'Data Sheet'!K26","v":null},"CHECK?","derived from BS"]
["Free Cash Flow",null,{"$f":"C17-C18","v":null},{"$f":"D17-D18","v":null}]
["Tax Rate",{"$f":"'Data Sheet'!B29/'Data Sheet'!B28","v":null},{"$f":"'Data Sheet'!C29/'Data Sheet'!C28","v":null},{"$f":"'Data Sheet'!D29/'Data Sheet'!D28","v":null},{"$f":"'Data Sheet'!E29/'Data Sheet'!E28","v":null},{"$f":"'Data Sheet'!F29/'Data Sheet'!F28","v":null},{"$f":"'Data Sheet'!G29/'Data Sheet'!G28","v":null},{"$f":"'Data Sheet'!H29/'Data Sheet'!H28","v":null},{"$f":"'Data Sheet'!I29/'Data Sheet'!I28","v":null},{"$f":"'Data Sheet'!J29/'Data Sheet'!J28","v":null},{"$f":"'Data Sheet'!K29/'Data Sheet'!K28","v":null}]
["NOPLAT",{"$f":"B5*(1-B20)","v":null}]
["RoIC",{"$f":"(B5/B13)*(1-B20)","v":null},{"$f":"(C5/C13)*(1-C20)","v":null}]
["WACC",0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12]
["EPA (Economic Profit Added)",{"$f":"B13*(B22-B23)","v":null},{"$f":"C13*(C22-C23)","v":null}]
[null,{"$f":"B3","v":null},{"$f":"C3","v":null},null,null,null,null,null,null,null,null,"CURRENT"]
["MktCap",{"$f":"'Data Sheet'!B90*'Data Sheet'!B93","v":null},{"$f":"'Data Sheet'!C90*'Data Sheet'!C93","v":null},{"$f":"'Data Sheet'!D90*'Data Sheet'!D93","v":null},{"$f":"'Data Sheet'!E90*'Data Sheet'!E93","v":null},{"$f":"'Data Sheet'!F90*'Data Sheet'!F93","v":null},{"$f":"'Data Sheet'!G90*'Data Sheet'!G93","v":null},{"$f":"'Data Sheet'!H90*'Data Sheet'!H93","v":null},{"$f":"'Data Sheet'!I90*'Data Sheet'!I93","v":null},{"$f":"'Data Sheet'!J90*'Data Sheet'!J93","v":null},{"$f":"'Data Sheet'!K90*'Data Sheet'!K93","v":null},{"$f":"'Data Sheet'!B9","v":null}]
["MktCap+Dividend",{"$f":"B26+'Data Sheet'!B31","v":null},{"$f":"C26+'Data Sheet'!C31","v":null},{"$f":"D26+'Data Sheet'!D31","v":null},{"$f":"E26+'Data Sheet'!E31","v":null},{"$f":"F26+'Data Sheet'!F31","v":null},{"$f":"G26+'Data Sheet'!G31","v":null},{"$f":"H26+'Data Sheet'!H31","v":null},{"$f":"I26+'Data Sheet'!I31","v":null},{"$f":"J26+'Data Sheet'!J31","v":null},{"$f":"K26+'Data Sheet'!K31","v":null}]
["Retained Profit",{"$f":"'Data Sheet'!B30-'Data Sheet'!B31","v":null},{"$f":"'Data Sheet'!C30-'Data Sheet'!C31","v":null},{"$f":"'Data Sheet'!D30-'Data Sheet'!D31","v":null},{"$f":"'Data Sheet'!E30-'Data Sheet'!E31","v":null},{"$f":"'Data Sheet'!F30-'Data Sheet'!F31","v":null},{"$f":"'Data Sheet'!G30-'Data Sheet'!G31","v":null},{"$f":"'Data Sheet'!H30-'Data Sheet'!H31","v":null},{"$f":"'Data Sheet'!I30-'Data Sheet'!I31","v":null},{"$f":"'Data Sheet'!J30-'Data Sheet'!J31","v":null},{"$f":"'Data Sheet'!K30-'Data Sheet'!K31","v":null}]
["EV",{"$f":"B26+'Data Sheet'!B59-'Data Sheet'!B69","v":null},{"$f":"C26+'Data Sheet'!C59-'Data Sheet'!C69","v":null},{"$f":"D26+'Data Sheet'!D59-'Data Sheet'!D69","v":null},{"$f":"E26+'Data Sheet'!E59-'Data Sheet'!E69","v":null},{"$f":"F26+'Data Sheet'!F59-'Data Sheet'!F69","v":null},{"$f":"G26+'Data Sheet'!G59-'Data Sheet'!G69","v":null},{"$f":"H26+'Data Sheet'!H59-'Data Sheet'!H69","v":null},{"$f":"I26+'Data Sheet'!I59-'Data Sheet'!I69","v":null},{"$f":"J26+'Data Sheet'!J59-'Data Sheet'!J69","v":null},{"$f":"K26+'Data Sheet'!K59-'Data Sheet'!K69","v":null}]
[null,{"$f":"B3","v":null},{"$f":"C3","v":null}]
["Price/Earnings",{"$f":"B26/'Data Sheet'!B30","v":null},{"$f":"C26/'Data Sheet'!C30","v":null},{"$f":"D26/'Data Sheet'!D30","v":null},{"$f":"E26/'Data Sheet'!E30","v":null},{"$f":"F26/'Data Sheet'!F30","v":null},{"$f":"G26/'Data Sheet'!G30","v":null},{"$f":"H26/'Data Sheet'!H30","v":null},{"$f":"I26/'Data Sheet'!I30","v":null},{"$f":"J26/'Data Sheet'!J30","v":null},{"$f":"K26/'Data Sheet'!K30","v":null}]
["Price/Book",{"$f":"B26/B11","v":null}]
["Price/CashFlow",{"$f":"B26/B17","v":null}]
["Price/Sales",{"$f":"B26/'Data Sheet'!B17","v":null},{"$f":"C26/'Data Sheet'!C17","v":null},{"$f":"D26/'Data Sheet'!D17","v":null},{"$f":"E26/'Data Sheet'!E17","v":null},{"$f":"F26/'Data Sheet'!F17","v":null},{"$f":"G26/'Data Sheet'!G17","v":null},{"$f":"H26/'Data Sheet'!H17","v":null},{"$f":"I26/'Data Sheet'!I17","v":null},{"$f":"J26/'Data Sheet'!J17","v":null},{"$f":"K26/'Data Sheet'!K17","v":null}]
["EV/EBITDA",{"$f":"B29/B6","v":null}]
["Dividend Yield",{"$f":"'Data Sheet'!B31/'Calculated Data'!B26","v":null},{"$f":"'Data Sheet'!C31/'Calculated Data'!C26","v":null},{"$f":"'Data Sheet'!D31/'Calculated Data'!D26","v":null},{"$f":"'Data Sheet'!E31/'Calculated Data'!E26","v":null},{"$f":"'Data Sheet'!F31/'Calculated Data'!F26","v":null},{"$f":"'Data Sheet'!G31/'Calculated Data'!G26","v":null},{"$f":"'Data Sheet'!H31/'Calculated Data'!H26","v":null},{"$f":"'Data Sheet'!I31/'Calculated Data'!I26","v":null},{"$f":"'Data Sheet'!J31/'Calculated Data'!J26","v":null},{"$f":"'Data Sheet'!K31/'Calculated Data'!K26","v":null}]
[null,{"$f":"B3","v":null},{"$f":"C3","v":null},null,null,null,null,null,null,null,null,"Z-Weights"]
["Working Capital/Total Assets",{"$f":"B12/B15","v":null},null,null,null,null,null,null,null,null,null,1.2]
["Retained Profits/Total Assets",{"$f":"B28/B15","v":null},null,null,null,null,null,null,null,null,null,1.4]
["EBIT/Total Assets",{"$f":"B5/B15","v":null},null,null,null,null,null,null,null,null,null,3.3]
["Market Cap/Total Liabilities",{"$f":"B26/B15","v":null},{"$f":"C26/C15","v":null},null,null,null,null,null,null,null,null,0.6]
["Sales/Total Assets",{"$f":"'Data Sheet'!B17/'Calculated Data'!B15","v":null},{"$f":"'Data Sheet'!C17/'Calculated Data'!C15","v":null},{"$f":"'Data Sheet'!D17/'Calculated Data'!D15","v":null},{"$f":"'Data Sheet'!E17/'Calculated Data'!E15","v":null},{"$f":"'Data Sheet'!F17/'Calculated Data'!F15","v":null},{"$f":"'Data Sheet'!G17/'Calculated Data'!G15","v":null},{"$f":"'Data Sheet'!H17/'Calculated Data'!H15","v":null},{"$f":"'Data Sheet'!I17/'Calculated Data'!I15","v":null},{"$f":"'Data Sheet'!J17/'Calculated Data'!J15","v":null},{"$f":"'Data Sheet'!K17/'Calculated Data'!K15","v":null},1]
["Altman Z-Score",{"$f":"$L$38*B38+$L$39*B39+$L$40*B40+$L$41*B41+$L$42*B42","v":null},{"$f":"$L$38*C38+$L$39*C39+$L$40*C40+$L$41*C41+$L$42*C42","v":null}]
["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":[]}