{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["What I am reading","||||","Valuation_Chart","Valuation_Table","|","Scorecard","Revenue","Profit","Efficiency","Dupont","Others","Piotroski","Altman","||","Analysis","Screener Output.v0","|||","Screener Input","Shareholding input","Phil Fisher"],"not_rendered":{"charts":31,"images":3,"macros":0,"external_links":0,"defined_names":114,"comments":5,"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":"What I am reading","index":0,"n_rows":44,"n_cols":38,"rows_kept":44,"cut":false,"hidden":false,"merged":[[41,1,42,2],[52,1,54,2],[56,1,58,2],[59,1,61,2],[63,1,65,2]]}
[]
[]
[null,"Red flag @ Screener",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,null,null,null,null,null,null,null,null,null,null,"RoCE"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"Going to Bed Smarter #4: ROCE, the Secret Winning Edge to any portfolio"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"At Marketsmojo we use the concept of Return on Capital Employed (ROCE) to uncover great companies that can deliver fantastic shareholder returns.  In this, the fourth piece in the series of Going to Bed Smarter, I present pieces which let you into the secret of ROCE."]
[null,"Green flag @ Screener",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,null,null,null,null,null,null,null,null,null,null,"Sanjeev Mohta"]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"August 28, 11:54: AM IST"]
[null,"Insider trading","2 employees sold shares in 2018",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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yesterday’s ET story says,“Warren Buffett in Talks for a Slice of Paytm”."]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"Let’s discuss how Warren Buffett finds a great business."]
[null,"Valuepickr",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,null,null,null,null,null,null,null,null,null,null,"His 2007 newsletter reads: “A truly great business must have an enduring ‘moat’ that protects excellent returns on invested capital (ROIC).” "]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"At Marketsmojo we use the concept of Return on Capital Employed (ROCE) to uncover great companies that can deliver fantastic shareholder returns. "]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"In this, the fourth piece in the series of Going to Bed Smarter, I present pieces which let you into the secret of ROCE."]
[]
[null,"Trendlyne",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,null,null,null,null,null,null,null,null,null,null,"The 2007 letter of Berkshire Hathaway is a classic. If there is only one Berkshire Hathaway letter you want to read, this one is it. In that letter, Warren Buffett narrates the success of See’s Candy."]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"“We bought See’s for $25 million when its sales were $30 million and pre-tax earnings were less than $5 million. The capital then required to conduct the business was $8 million (Modest seasonal debt was also needed for a few months each year). Consequently, the company was earning 60% pre-tax on invested capital. Two factors helped to minimize the funds required for operations. First, the product was sold for cash, and that eliminated accounts receivable. Second, the production and distribution cycle was short, which minimized inventories."]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"Last year See’s sales were $383 million, and pre-tax profits were $82 million. The capital now required to run the business is $40 million. This means we have had to reinvest only $32 million since 1972 to handle the modest physical growth – and somewhat immodest financial growth – of the business. In the meantime pre-tax earnings have totaled $1.35 billion. All of that, except for the $32 million, has been sent to Berkshire (or, in the early years, to Blue Chip). After paying corporate taxes on the profits, we have used the rest to buy other attractive businesses. Just as Adam and Eve kick-started an activity that led to six billion humans, See’s has given birth to multiple new streams of cash for us. (The biblical command to “be fruitful and multiply” is one we take seriously at Berkshire.)"]
[null,"Valuepickr",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,null,null,null,null,null,null,null,null,null,null,"There aren’t many See’s in Corporate America. Typically, companies that increase their earnings from $5 million to $82 million require, say, $400 million or so of capital investment to finance their growth. That’s because growing businesses have both working capital needs that increase in proportion to sales growth and significant requirements for fixed asset investments."]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"A company that needs large increases in capital to engender its growth may well prove to be a satisfactory investment. There is, to follow through on our example, nothing shabby about earning $82 million pre-tax on $400 million of net tangible assets. But that equation for the owner is vastly different from the See’s situation.It’s far better to have an ever-increasing stream of earnings with virtually no major capital requirements. Ask Microsoft or Google.”"]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"ROCE = EBIT/Capital Employed"]
[null,"General news",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,null,null,null,null,null,null,null,null,null,null,"How do we calculated ROCE? Well, there are a few variants. But the easiest one is shown in this paper by Mirae Asset Management. Marketsmojo uses the same method."]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"EBIT is easy to calculate, but what about the Capital Employed? The paper says: “Capital Employed is the capital investment necessary for a business to function. It is commonly represented as total assets less current liabilities (or Fixed Assets plus Working Capital).”"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"ROCE is a far more useful measure compared to Return on Equity (ROE) as: “ ROCE is especially useful when comparing the performance of companies in capital-intensive sectors such as utilities and telecoms. This is because unlike return on equity (ROE), which only analyzes profitability related to a company’s equity, ROCE considers debt and other liabilities as well. This provides a better indication of financial performance for companies with significant debt.”"]
[null,"Analyst report",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,null,null,null,null,null,null,null,null,null,null,"It follows from the equation that in order to generate high ROCE, a company must either have very high profit margins or need low levels of Capital Employed or a combination of the two."]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"We have had many such companies in India as well. Many consumer related business enjoy high ROCE due to their Asset Light nature.  Hindustan Unilever with ROCE at close to 800%, Nestle at 400%, Page Industries at 84% are great examples."]
[]
[null,"Concall",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,null,null,null,null,null,null,null,null,null,null,"High ROCE Means High Valuation"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"In 1997, when running research for HSBC, I had written a piece on the importance of ROCE. I had found that, everything else remaining the same, high ROCE companies enjoy far higher valuation that companies with low ROCE. At least for the companies where market believes that the high ROCE is sustainable."]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"A 2011 report, “Impact of ROCE on valuation”, by PWC concluded: “Companies that deliver better Return on Capital Employed (ROCE) experience higher valuation”"]
[null,"Annual report",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,null,null,null,null,null,null,null,null,null,null,"The relationship remains the same today. Is it any wonder why Hindustan Unilever, Nestle or Page Industries enjoy such high valuations?"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"At Marketsmojo, the five-year average ROCE  is one of the most important metric used in our Quality Parameter."]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"An interesting example: The Abrasives Industry"]
[null,"Fraud?",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,null,null,null,null,null,null,null,null,null,null,"Let us look at the Abrasives Industry (which was picked randomly) which has a fairly uniform product, the relationship between the five-year average ROCE and Price/Book Value is fairly consistent with the findings above."]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"Next time you look at a stock, don’t forget to look at its long term ROCE – it’ll give you an insight about the inherent strength of the company’s business, and its ability to squeeze value from every rupee of capital. That will not only determine its valuation but also the price performance."]
[]
[]
[null,"Earnings slowdown?"]
[]
[]
[]
[null,"Over valued?"]

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

{"sheet":"Valuation_Chart","index":2,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[[6,8,7,8],[12,0,12,1],[0,0,0,1],[0,2,0,12],[4,10,4,11],[8,0,9,0]]}
["Snapshot",null,"Value of stock based on"]
[]
["Company",{"$f":"'Screener Input'!B1","v":"GODREJ CONSUMER PRODUCTS LTD"}]
["Sector","FMCG"]
["Stock Price#",{"$f":"'Screener Input'!B8","v":789.65}]
["No of shares outstanding",{"$f":"'Screener Output.v0'!L40","v":68.13},null,"Distance Covered",null,{"$f":"(Valuation_Table!B8-Valuation_Table!B25)/Valuation_Table!B25","v":-8.1059064803478326E-2},null,null,"PEG"]
["Market Cap",{"$f":"'Screener Output.v0'!B38","v":80715.350000000006},null,"Distance Left (Fundoo)",null,{"$f":"POWER(Valuation_Table!E24/Valuation_Table!B8, 1/10)-1","v":9.8560981716041107E-2},null,null,{"$f":"Valuation_Table!B17","v":1.7150015619097561}]
["Promoter Shareholding",{"$f":"SUM('Shareholding input'!C6:C7)","v":0.63249999999999995},null,"Distance Left (Mine)",null,{"$f":"Valuation_Table!C53","v":0.13765210982004716},{"$f":"Valuation_Table!E55","v":0.17717882261561257}]
["Stock Beta",1.1000000000000001]
[null,"https://in.reuters.com/\n",null,0.83]
[]
["Be cautious","Buy on dips\nThere is a difference between a quality stock correcting, a cyclical stock correcting and a worthless stock crumbling. How to invest in share markets is all about knowing this critical difference. High quality stocks can be added on dips, but volatile and speculative stocks are a strict no.\n\nBet on fav FII stocks\nFIIs are may be buying just to diversify their portfolio. FIIs may also be buying in one account and selling in another account. Quite often FIIs create arbitrage positions i.e. long on equity and short on futures. Buying such stocks without looking at the nature of the transaction will lead you nowhere.\n"]
[]
[]
["The stock exchange is one big supermarket of companies. And if you are going to be buying stocks, what you want to happen?"]
["You want to have these stocks go down, way down; you will make better buys then. Later on 20-30 years later when you are in a"]
["period when you are dis-saving, or when you heirs dis-save for you, they you make care about high prices."]
[]
["Charlie and I spend no time thinking about where the mkt is going. There is always going to be some good & bad thing happening"]
[]
["The stock doesn't know you own it. It just sits there. It doesn't care what you paid or the fact that you own it"]

{"sheet":"Valuation_Table","index":3,"n_rows":61,"n_cols":13,"rows_kept":61,"cut":false,"hidden":false,"merged":[[4,0,4,10],[49,2,49,4],[49,0,50,1],[6,0,6,1],[17,0,17,1],[5,0,5,10]]}
[]
[]
[]
[]
[]
[]
["Current Data",null,null,"Year Ending","CY","CY-1","CY-2","CY-3","CY-4","CY-5","CAGR"]
["CMP",{"$f":"'Screener Input'!B8","v":789.65},null,"PE Ratio",{"$f":"'Screener Output.v0'!L76","v":30.551193553409234},{"$f":"'Screener Output.v0'!K76","v":29.476108564821971},{"$f":"'Screener Output.v0'!J76","v":37.439059404911546},{"$f":"'Screener Output.v0'!I76","v":28.430529216659597},{"$f":"'Screener Output.v0'!H76","v":24.983274665537895}]
["EPSi",{"$f":"'Screener Output.v0'!M74","v":29.79083138764566},null,"EPS",{"$f":"'Screener Output.v0'!L74","v":23.984068043660201},{"$f":"'Screener Output.v0'!K74","v":19.142943267396259},{"$f":"'Screener Output.v0'!J74","v":12.149906013406019},{"$f":"'Screener Output.v0'!I74","v":13.318869202691909},{"$f":"'Screener Output.v0'!H74","v":11.155926624160951},{"$f":"'Screener Output.v0'!G74","v":11.690867700209761},{"$f":"(E9/J9)^(1/5)-1","v":0.1545565789880603}]
["EPSi-1",{"$f":"SUM('Screener Input'!D49:G49)/'Screener Input'!K93","v":19.470305712198734},null,"DPS",{"$f":"'Screener Output.v0'!L75","v":9.9991099867491293},{"$f":"'Screener Output.v0'!K75","v":7.4996393743579759},{"$f":"'Screener Output.v0'!J75","v":2.8743370650001383},{"$f":"'Screener Output.v0'!I75","v":2.7488741204338778},{"$f":"'Screener Output.v0'!H75","v":2.6241897081908094},{"$f":"'Screener Output.v0'!G75","v":2.5986885419282997},{"$f":"(E10/J10)^(1/5)-1","v":0.30930679806807615}]
["BVPS",{"$f":"'Screener Output.v0'!L73","v":91.850183503848456},null,"PB Ratio",{"$f":"'Screener Output.v0'!L78","v":7.9775769306906019},{"$f":"'Screener Output.v0'!K78","v":7.2500124779020974},{"$f":"'Screener Output.v0'!J78","v":7.2615960670123094},{"$f":"'Screener Output.v0'!I78","v":5.9827780849507288},{"$f":"'Screener Output.v0'!H78","v":5.0274257725404201}]
["ROE",{"$f":"Analysis!M4","v":0.32434155546784993},null,"BVPS",{"$f":"'Screener Output.v0'!L73","v":91.850183503848456},{"$f":"'Screener Output.v0'!K73","v":77.828759015222701},{"$f":"'Screener Output.v0'!J73","v":62.642020955477761},{"$f":"'Screener Output.v0'!I73","v":63.292085152297354},{"$f":"'Screener Output.v0'!H73","v":55.438228550744682},{"$f":"'Screener Output.v0'!G73","v":48.652571693886387},{"$f":"(E12/J12)^(1/5)-1","v":0.13552015038550658}]
["PE",{"$f":"B8/B9","v":26.506477436795201}]
["Earnings Yeild",{"$f":"B9/B8","v":3.7726627477547854E-2},null,"Payout Ratio",{"$f":"E10/E9","v":0.41690633834706081},{"$f":"F10/F9","v":0.39177044353107177},{"$f":"G10/G9","v":0.23657278186585468},{"$f":"H10/H9","v":0.20638945233265721},{"$f":"I10/I9","v":0.23522830479249207}]
["Dividend Yeild",{"$f":"'Screener Output.v0'!L75/B8","v":1.2662711311022768E-2}]
["PB",{"$f":"B8/B11","v":8.5971521218236244},null,"Projections Historical",0,1,2,3,4,10]
["PEG",{"$f":"B13/100/K9","v":1.7150015619097561},null,"EPS/BV ",null,null,null,null,null,{"$f":"IF($A$29=1, IF($A$28=2,M43, $E$12*(1+$K$12)^J16), IF($A$28=2,K43, $E$12*(1+Valuation_Table!$C$60)^J16))","v":64.604486729330844}]
["Average Data",null,null,"DPS"]
["ROE 5 Yr.",{"$f":"Analysis!M3","v":0.23286195010226524}]
["Payout",{"$f":"AVERAGE(E14:I14)","v":0.29737346417382737},null,"EPS/BV  after 10 years",{"$f":"J17","v":64.604486729330844}]
["Avg P/E Ratio",{"$f":"AVERAGE(E8:F8,B13)","v":28.844593185008801},null,"Bank Interest 1 Yr",{"$f":"B8*B24","v":63.171999999999997}]
["Avg P/B Ratio",{"$f":"AVERAGE(E11:G11,B16)","v":7.7715843993571578},null,"Dividend after 10 Yrs",{"$f":"B20*M43","v":19.211660019873172}]
["Value of Stock",null,null,"Projected Price",{"$f":"IF(A28=2, E20*I44, E20*B22)","v":2002.3004073461952}]
["Discount Rate",{"$f":"Valuation_Table!C61","v":0.08},null,"Final Price",{"$f":"E23+E22","v":2021.5120673660683}]
["P E/B Valuation",{"$f":"IF(A28=2, B21*B9, B22*B11)","v":859.30441201983024}]
["Historical Earnings Growth",{"$f":"E24/((1+B24)^5)","v":1375.8071456503103},null,"Projections Growth","Year 0",1,2,3,4,5]
["Sustainable Earnings Growth",{"$f":"E32/(1+B24)^5","v":1632.4027430325079},null,"BVPS",{"$f":"E12","v":91.850183503848456},{"$f":"E27+E28-E29","v":112.78201216113153},{"$f":"F27+F28-F29","v":138.48401583847323},{"$f":"G27+G28-G29","v":170.0432744128662},{"$f":"H27+H28-H29","v":208.79460346366065},{"$f":"I27+I28-I29","v":256.37701100543319}]
[2,null,null,"EPS",{"$f":"IF($A$30=1, E27*$B$12, E27*$B$19)","v":29.790831387645657},36.579893253135367,44.916121104484773,55.152100119915467,67.720766460696623,83.153718535700278]
[1,null,null,"DPS",{"$f":"E28*B20","v":8.8590027303625778},{"$f":"F28*B20","v":10.877889575793679},{"$f":"G28*B20","v":13.356862530091794},{"$f":"H28*B20","v":16.400771069121021},{"$f":"I28*B20","v":20.138358918924098},{"$f":"J28*B20","v":24.727709339896592}]
[1,null,null,"Earnings after 5 years",{"$f":"J28","v":83.153718535700278}]
[null,null,null,"Sum Of dividend paid",{"$f":"SUM(E29:J29)","v":94.360594164189763}]
[null,null,null,"Projected Price",{"$f":"B21*E30","v":2398.5351829830001}]
[null,null,null,"Total Gain",{"$f":"E32+E31","v":2492.8957771471901}]
[]
[]
[]
["Fundo Prof Concept"]
["Year Ending","TTM","CY","CY-1","CY-2","CY-3","CY-4","CY-5","5 YR CAGR","10 YR CAGR","Conservative 10 Yr",null,"Future in 10 Yrs"]
["Volume/share"]
["Avg. Realization"]
["Sales/share",{"$f":"'Screener Output.v0'!M25/'Screener Input'!K93","v":159.41645775307344},{"$f":"'Screener Output.v0'!L25/'Screener Input'!K93","v":148.92098801327595},{"$f":"'Screener Output.v0'!K25/'Screener Input'!K93","v":137.43382612346429},{"$f":"'Screener Output.v0'!J25/'Screener Input'!K93","v":120.00018046243414},{"$f":"'Screener Output.v0'!I25/'Screener Input'!K93","v":122.89027988793048},{"$f":"'Screener Output.v0'!H25/'Screener Input'!K93","v":112.54025441639759},{"$f":"'Screener Output.v0'!G25/'Screener Input'!K93","v":96.987110681981534},{"$f":"Revenue!D5","v":0.10449518431683535},{"$f":"Revenue!C5","v":0.25206079569986128},null,null,{"$f":"B41*                                  (1+                   (             IF(MIN(I41:J41) >0.25, 0.25,MIN(I41:J41) )                   )                  )                                      ^10","v":430.69657819553902}]
["Net Profit margin",{"$f":"'Screener Output.v0'!M127","v":0.18687425255546622},{"$f":"'Screener Output.v0'!L127","v":0.16105230272526866},{"$f":"'Screener Output.v0'!K127","v":0.13967770872044577},{"$f":"'Screener Output.v0'!J127","v":0.10158824119349252},{"$f":"'Screener Output.v0'!I127","v":0.11661288434850943},{"$f":"'Screener Output.v0'!H127","v":0.10684593866758828},{"$f":"'Screener Output.v0'!G127","v":0.12793417994285994},{"$f":"IFERROR(IF(  (POWER('Screener Output.v0'!M127/'Screener Output.v0'!G127,1/5)-1)>0, (POWER('Screener Output.v0'!M127/'Screener Output.v0'!G127,1/5)-1), 0.01), 0.01)","v":7.8729550306152252E-2},{"$f":"IFERROR(IF((POWER('Screener Output.v0'!M127/'Screener Output.v0'!C127,1/10)-1)>0, (POWER('Screener Output.v0'!M127/'Screener Output.v0'!C127,1/10)-1),0.01), 0.01)","v":4.4752117865425101E-2},null,null,{"$f":"IF(B42*(1+MIN(I42:J42))^10>0.15, 0.15, B42*(1+MIN(I42:J42))^10)","v":0.15}]
["Net Profit/share (EPS)",null,null,null,null,null,null,null,null,null,{"$f":"(B41*(1+$B53)^10)*C$52","v":92.525800290403751},null,{"$f":"M41*M42","v":64.604486729330844}]
["Exit PE",null,null,null,null,null,null,null,{"$f":"AVERAGE(E8:G8,B13)","v":30.993209739984486},null,{"$f":"I44","v":30.993209739984486}]
["Price/share",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M43*I44","v":2002.3004073461952}]
["Price/revenue",{"$f":"B8/B41","v":4.9533781588794339},null,null,null,null,null,null,null,null,null,null,{"$f":"M45/M41","v":4.6489814609976721}]
["Wealth compounding",null,null,null,null,null,null,null,null,null,null,null,{"$f":"POWER(M45/B8,1/10)-1","v":9.7512460344895135E-2}]
[]
["My Concept"]
["10 Yr estimate",null,"NP Margin"]
[null,null,"TTM","TTM+1%","TTM+1.5%"]
["Revenue Growth",null,{"$f":"B42","v":0.18687425255546622},{"$f":"C52+1%","v":0.19687425255546623},{"$f":"B42+1.5%","v":0.2018742525554662}]
["Conservative",{"$f":"Valuation_Table!C60","v":0.12},{"$f":"POWER((($B$41*(1+$B53)^10)*C$52*$K$44)/$B$8, 1/10)-1","v":0.13765210982004716},{"$f":"POWER((($B$41*(1+$B53)^10)*D$52*$K$44)/$B$8, 1/10)-1","v":0.14359809157916437},0.1464698098517272]
["Conservative +2%",{"$f":"B53+2%","v":0.13999999999999999},{"$f":"POWER((($B$41*(1+$B54)^10)*C$52*$K$44)/$B$8, 1/10)-1","v":0.15796732606683372},0.16401948607164929,0.16694248502765063]
["Conservative +3%",{"$f":"B53+3%","v":0.15},0.16812493419022689,0.17423018331789186,0.17717882261561257]
[]
[]
[]
["Assumptions","Max","Current"]
["Conservative furture growth in EPS/BVPS",null,0.12]
["Discount Rate",null,0.08]

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

{"sheet":"Scorecard","index":5,"n_rows":20,"n_cols":13,"rows_kept":20,"cut":false,"hidden":false,"merged":[[4,5,6,5],[8,5,11,5],[12,5,13,5],[18,6,18,9],[19,6,19,9],[20,6,20,9],[21,6,21,9],[15,6,15,9],[17,6,17,9],[16,6,16,9],[15,10,15,12],[16,10,16,12],[17,10,17,12],[18,10,18,12],[19,10,19,12]]}
[]
["RESEARCH FRAMEWORK",null,null,null,"S.No",null,"Criteria","Goal","Actual","Description","Weight","Score","Delta"]
["PARAMETER","Max WEIGHT","Actual Weight",null,null,null,"FINANCIAL ANALYSIS",null,null,null,{"$f":"SUM(K4:K14)","v":50},{"$f":"SUM(L4:L14)","v":50},{"$f":"K3-L3","v":0}]
["Financial Anlaysis",{"$f":"Scorecard!K3","v":50},{"$f":"Scorecard!L3","v":50},null,1,"Revenue","Revenue growth 5 Yr.",">20%",{"$f":"Revenue!C5","v":0.25206079569986128},"Growth should be consistent year on year. Ignore companies where a sudden spurt of sales in one year is confounding the 10 years performance.\n\nVery high growth rates of >50% are unsustainable.",4,{"$f":"Revenue!L5","v":4},{"$f":"K4-L4","v":0}]
[null,null,null,null,2,"Profit","EPS growth 10 Yr.",">20%",{"$f":"Profit!F5","v":0.29544957553311435},"Rising earnings serve as a good catalyst for stock prices. So seek companies with strong, consistent, and expanding earnings (profits). Seek companies with 5/10 year earnings per share growth greater than 25% (alongwith safe balance sheets). To help indicate that earnings growth is still strong, look for companies where the last 3-years earnings growth rate is higher than the last 10-years growth rate. More important than the rate of growth is the consistency in such growth. So exclude companies with volatile earnings growth in the past, even if the \"average\" growth has been high.",5,{"$f":"Profit!L5","v":5},0]
[null,null,null,null,3,null,"EPS growth 5 Yr.",">20%",{"$f":"Profit!G5","v":0.20572197295616834},"Seek companies where earnings have risen as retained earnings (earnings after paying dividends) have been employed profitably. A great way to screen for such companies is by looking at those that have had consistent earnings and strong return on equity in the past.\n\n  What counts in the long run is the increase in \"per share value\", not overall growth or size of a business.",9,{"$f":"Profit!M5","v":9},0]
[null,null,null,null,4,null,"Avg. NP margin 5 Yr."," >10%",{"$f":"Profit!C5","v":0.14149044906462638},"Look for companies with sustained operating & net profit margins over the years - It’s a good indicator of priciing power",4,{"$f":"Profit!P5","v":4},0]
[null,null,null,null,null,"RoE/RoA","ROE/ROA 5 Yr.",">20%  / >2%",{"$f":"Dupont!D4","v":0.26917602389526518},"ROE = Efficiency in allocating capital, which is a CEO's #1 job. Higher = Better. Look for consistency. \n\nConsider it a positive sign when a company is able to earn above-average (better than competitors) returns on equity without employing much debt. Average return on equity for Indian companies over the last 10 years is approximately 16%. Thus, seek companies that earn atleast this much (16%) or more than this. Again, consistency is the key here.",{"$f":"10","v":10},{"$f":"Dupont!K4","v":10},0]
[null,null,null,null,5,"Efficiency","Debt/Net Profit","<=5",{"$f":"Efficiency!C5","v":1.721203253474429},"Seeks out companies with conservative financing, which equates to a simple, safe balance sheet. Such companies tend to have strong cash flows, with little need for long-term debt. Look for low debt to equity or low debt-burden ratios. Also seek companies that have history of consistently generating positive free cash flows.",3,{"$f":"Efficiency!K5","v":3},0]
[null,null,null,null,6,null,"CFO/PAT 5 Yr.",">1",{"$f":"Efficiency!E5","v":1.1804866660680611},"Cumulative PAT and CFO are similar for last 10 years",4,{"$f":"Efficiency!M5","v":4},0]
[null,null,null,null,7,null,"Current Cash flow","CFO > 0",{"$f":"Efficiency!F5","v":1723.35},"Positive CFO is necessary. It’s great if CFO meets the outflow for CFI and CFF",1,{"$f":"Efficiency!N5","v":1},0]
[null,null,null,null,8,null,"C Liabilty/ C Asset",">1.25",{"$f":"Efficiency!D5","v":0.92336248961011558},"Current Ratio measures the liquidity of a company, or its ability to pay short-term obligations. \n\nThe ratio is mainly used to give an idea of the company's ability to pay back its short-term liabilities (debt and payables) with its short-term assets (cash, inventory, receivables). The higher the current ratio, the more capable the company is of paying its obligations. A ratio under 1 suggests that the company would be unable to pay off its obligations if they came due at that point.\n\nWhile this shows the company is not in good financial health, it does not necessarily mean that it will go bankrupt - as there are many ways to access financing - but it is definitely not a good sign.\n\nThe current ratio can give a sense of the efficiency of a company's operating cycle or its ability to turn its product into cash. Companies that have trouble getting paid on their receivables or have long inventory turnover can run into liquidity problems because they are unable to alleviate their obligations.",1,{"$f":"Efficiency!L5","v":1},0]
[null,null,null,null,9,"Promoter","Promoter Pledged Holding",0,{"$f":"Others!E4","v":0},null,6,{"$f":"Others!L4","v":6},0]
[null,null,null,null,10,null,"Promoter Holding 5 Yr.",">=-3%",{"$f":"Others!F4","v":-6.0000000000004494E-4},"Buffett prefers that firms reinvest their earnings within the company, provided that profitable opportunities exist. When companies have excess cash flow, Buffett favours shareholder-enhancing maneuvers such as share buybacks. While we do not screen for this factor, a follow-up examination of a company would reveal if it has a share buyback plan in place.",3,{"$f":"Others!M4","v":3},0]
[]
[null,null,null,null,null,null,"Other questions"]
[null,null,null,null,null,null,"Big addressable market and long runway to grow?"]
[null,null,null,null,null,null,"What MOAT does the company has?"]
[null,null,null,null,null,null,"Is the company in a stable industry?"]
[null,null,null,null,null,null,"Is the company addressing any human problem?"]

{"sheet":"Revenue","index":6,"n_rows":64,"n_cols":12,"rows_kept":64,"cut":false,"hidden":false,"merged":[[3,14,5,19],[6,1,7,8],[28,18,28,19],[47,10,47,11],[47,12,47,13],[47,14,47,15],[47,16,47,17],[47,18,47,19],[28,10,28,11],[28,12,28,13],[28,14,28,15],[28,16,28,17],[61,1,61,8],[28,1,28,8],[63,10,64,20],[10,1,10,8],[10,10,10,11],[10,12,10,13],[10,14,10,15],[10,16,10,17],[10,18,10,19]]}
[]
[]
[null,"Revenue","10 YR CAGR","5 YR CAGR","YOY","QoQ","SSGR",null,null,null,"Revenue","10 YR CAGR"]
[null,"Expected Gth",0.2,null,null,null,null,null,null,null,"Expected Score",4]
[null,"Actual Gth",{"$f":"POWER('Screener Output.v0'!M25/'Screener Output.v0'!C25,1/9)-1","v":0.25206079569986128},{"$f":"POWER('Screener Output.v0'!M25/'Screener Output.v0'!G25,1/5)-1","v":0.10449518431683535},{"$f":"POWER('Screener Output.v0'!M25/'Screener Output.v0'!N25,1)-1","v":0.13595349099876408},{"$f":"'Screener Output.v0'!L191","v":0.16797344406239212},{"$f":"'Screener Output.v0'!L142","v":9.960951202234905E-2},null,null,null,"Actual Score",{"$f":"IF(C5>0.2,4,IF(AND(C5>0.1,C5<0.2),3,IF(AND(C5>0.05,C5<0.1),2,IF(AND(C5>0,C5<0.05),1,0))))","v":4}]
[]
[null,"SSGR and FCF determine the margin of safety. WC if managed well growth funded by profit allows the company to have SSGR >= Sales gth rate. If sales is debt funded then SSGR < Sales gth rate. Sales funded by debt is a recipe for disaster"]
[]
[]
[]
[null,"Total Income - Annl",null,null,null,null,null,null,null,null,"Income Dist - Annl"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total Income - Qtrly",null,null,null,null,null,null,null,null,"Income Dist - Qtrly"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sales/NFAT",null,null,null,null,null,null,null,null,"Sales in Cash/Credit"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Indicator of asset light business model"]
[]
[null,null,null,null,null,null,null,null,null,null,"When debtors are increasing at a rate faster than sales, there is a reason to worry. Either the company is trying to increase sales by giving more credit or the company is unable to collect dues in a timely manner."]

{"sheet":"Profit","index":7,"n_rows":67,"n_cols":19,"rows_kept":67,"cut":false,"hidden":false,"merged":[[32,18,32,19],[32,20,32,21],[10,1,10,2],[10,3,10,4],[10,18,10,19],[10,5,10,6],[10,7,10,8],[27,10,28,17],[10,20,10,21],[10,10,10,11],[10,12,10,13],[10,14,10,15],[10,16,10,17],[66,1,66,8],[49,10,50,17],[7,1,8,7],[2,1,2,2],[2,14,2,15],[32,1,32,8],[50,1,50,8]]}
[]
[]
[null,"5 YR NP \nmargin",null,null,null,"10 YR CAGR","5 YR CAGR","YOY",null,null,"EPS","10 YR CAGR","5 YR CAGR",null,"5 YR NP \nmargin",null,null,null,"QoQ NP"]
[null,"Expected",0.1,null,"EPS Expected Gth",0.2,0.2,null,null,null,"EPS Expected Score",5,9,null,"Expected Score",4]
[null,"Actual",{"$f":"SUM('Screener Output.v0'!H35:M35)/SUM('Screener Output.v0'!H26:M26)","v":0.14149044906462638},null,"EPS Actual Gth",{"$f":"('Screener Output.v0'!M74/'Screener Output.v0'!C74)^(1/9)-1","v":0.29544957553311435},{"$f":"('Screener Output.v0'!M74/'Screener Output.v0'!G74)^(1/5)-1","v":0.20572197295616834},{"$f":"('Screener Output.v0'!M74/'Screener Output.v0'!N74)^(1/1)-1","v":0.53006490129124195},null,null,"EPS Actual Score",{"$f":"IF(F5>0.2,5,IF(AND(F5>0.1,F5<0.2),3,IF(AND(F5>0.05,F5<0.1),1,IF(AND(F5>0,F5<0.05),1,0))))","v":5},{"$f":"IF(G5>0.2,9,IF(AND(G5>0.1,G5<0.2),7,IF(AND(G5>0.05,G5<0.1),3,IF(AND(G5>0,G5<0.05),1,0))))","v":9},null,"Actual Score",{"$f":"IF(C5>0.1,4,IF(AND(C5>0.08,C5<0.1),3,IF(AND(C5>0.05,C5<0.08),2,IF(AND(C5>0.03,C5<0.05),1,0))))","v":4},null,null,{"$f":"'Screener Output.v0'!L193","v":0.59615969056499529}]
[null,null,null,null,"PAT Actual Gth",{"$f":"POWER('Screener Output.v0'!M35/'Screener Output.v0'!C35,1/9)-1","v":0.31447176506737473},{"$f":"POWER('Screener Output.v0'!M35/'Screener Output.v0'!G35,1/5)-1","v":0.19145159349341045},{"$f":"('Screener Output.v0'!M35/'Screener Output.v0'!N35)^(1/1)-1","v":0.53006490129124173}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(M7, 'Screener Output.v0'!F203:G205,2, FALSE)","v":"Fast Grower"},null,{"$f":"MAX('Screener Output.v0'!F203:F205)","v":3.0000100000000001}]
[null,"Equity dilution is a sign of trouble. Company is either trying to be too aggressive or does not generate sufficent funds internally for expansion"]
[]
[]
[null,"EPS - Annl",null,null,null,null,null,null,null,null,"Profit Margin"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Fluctuations in Operating Profit margin indicative of lack of pricing power - company not able to pass in higher raw material price to the customer"]
[]
[]
[]
[]
[null,"Net Profit - Qtr",null,null,null,null,null,null,null,null,"Operating Profit Components"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Company might be making profit but not paying reasonable taxes. There could be genuine reasons (tax exemptions etc.). Company could be showing profits while there is no cost to show."]
[null,"Net Profit - YoY Growth"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Other Inc as % of Net Profit"]

{"sheet":"Efficiency","index":8,"n_rows":67,"n_cols":14,"rows_kept":67,"cut":false,"hidden":false,"merged":[[66,1,67,8],[51,1,51,8],[7,1,7,7],[23,1,23,7],[37,9,37,16],[35,9,35,16],[7,9,7,16],[21,9,21,16],[37,1,37,7],[51,9,51,16],[21,1,21,8]]}
[]
[]
[null,null,"Debt/NP","C Liabilty/ C Asset","5 Yr. CFO/PAT ","CFO","5 YR cFCF",null,null,null,"Debt/NP","C Liabilty/ C Asset","5 Yr. CFO/PAT ","CFO"]
[null,"Expected Value","<=5",">=1.25",">=1",">0",null,null,null,"Expected Score",3,1,4,1]
[null,"Actual Value",{"$f":"SUM('Screener Output.v0'!L45:L45)/SUM('Screener Output.v0'!M35:M35)","v":1.721203253474429},{"$f":"SUM('Screener Output.v0'!L10:L10)/SUM('Screener Output.v0'!L9:L9)","v":0.92336248961011558},{"$f":"SUM('Screener Output.v0'!H62:L62)/SUM('Screener Output.v0'!H35:L35)","v":1.1804866660680611},{"$f":"'Screener Output.v0'!L62","v":1723.35},{"$f":"SUM('Screener Output.v0'!H63:L63)","v":2241.06},null,null,"Actual Value",{"$f":"IF(C5<=3,3,IF((AND((C5>3),(C5<=5))),2,0))","v":3},{"$f":"IF(Efficiency!D5>1.5,1,IF(AND(Efficiency!D5>1.25,Efficiency!D5<1.5),0.75,IF(AND(Efficiency!D5>1,Efficiency!D5<1.25),0.5,IF(AND(Efficiency!D5>0.9,Efficiency!D5<1),1,0))))","v":1},{"$f":"IF(E5>1,4,IF(AND(E5>0.75,E5<1),2,IF(AND(E5>0.5,E5<0.75),1,IF(AND(E5>0,E5<0.5),1,0))))","v":4},{"$f":"IF(F5>1.5,1,IF(AND(F5>1.25,F5<1.5),0.75,IF(AND(F5>1,F5<1.25),0.5,IF(AND(F5>0.9,F5<1),1,0))))","v":1}]
[]
[]
[null,"Debt/NP",null,null,null,null,null,null,null,"C Liabillity/ C Asset"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"    If the ratio >5, the company has taken more loan than what it chew, affecting PAT. ",null,null,null,null,null,null,null,"Are current liabilties able to fund the current asset. Current Liabilities is also called Float (other people's money)"]
[]
[null,"PAT/WC",null,null,null,null,null,null,null,"Change WC and NP"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Indicator in internal accruals are getting tied to WC and that is causing company to borrow money for capex. "]
[]
[null,"Source of Cash",null,null,null,null,null,null,null,"CFO/PAT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Limited Capex (higher FCF) and higher operating cash flow are signs of efficient use of capital",null,null,null,null,null,null,null,"CFO to be higher than PAT. Excess CFO helps to fund its business expansion attempts over and above the SSGR levels."]
[]
[]
[null,"CFO and Operating Profit"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"A huge difference between the numbers could potentially tell you one of two things — The company has difficulty collecting cash from its clients or it’s reporting revenue aggressively in a bid to boost growth. "]

{"sheet":"Dupont","index":9,"n_rows":22,"n_cols":13,"rows_kept":22,"cut":false,"hidden":false,"merged":[[5,12,5,19],[5,21,5,28],[12,1,13,6]]}
[]
[null,null,null,"ROE/ROA 5 Yr.",null,null,null,null,null,null,"ROE/ROA 5 Yr."]
[null,null,"Expected",">20%  / >2%",null,null,null,null,null,"Expected Score",10]
[null,null,"Actual",{"$f":"IF(Valuation_Table!A28=2, G10, SUM('Screener Output.v0'!L35:L35)/SUM('Screener Output.v0'!L60:L60))","v":0.26917602389526518},null,null,null,null,null,"Actual Score",{"$f":"IF(Valuation_Table!A28=2, (IF(D4>0.2,10,IF(AND(D4>0.1,D4<0.2),7,IF(AND(D4>0.05,D4<0.1),3,IF(AND(D4>0,D4<0.05),1,0))))), (IF(D4>0.02,10,IF(AND(D4>0.01,D4<0.02),7,IF(AND(D4>0.005,D4<0.01),3,IF(AND(D4>0,D4<0.005),1,0))))))","v":10}]
[]
[null,null,"CY-4","CY-3","CY-2","CY-1","CY0","CY+1",null,null,"5 YR CAGR",null,"DU Pont Analysis"]
[null,"NPM",{"$f":"SUM('Screener Output.v0'!H35:H35)/SUM('Screener Output.v0'!H26:H26)","v":0.1078101499183496},{"$f":"SUM('Screener Output.v0'!I35:I35)/SUM('Screener Output.v0'!I26:I26)","v":0.11802396910487542},{"$f":"SUM('Screener Output.v0'!J35:J35)/SUM('Screener Output.v0'!J26:J26)","v":9.8603019036358625E-2},{"$f":"SUM('Screener Output.v0'!K35:K35)/SUM('Screener Output.v0'!K26:K26)","v":0.14112890608562215},{"$f":"SUM('Screener Output.v0'!L35:L35)/SUM('Screener Output.v0'!L26:L26)","v":0.16602003196092369},{"$f":"'Screener Output.v0'!M35/'Screener Output.v0'!M26","v":0.19717826894065599},null,"NP",{"$f":"POWER('Screener Output.v0'!M35/'Screener Output.v0'!G35,1/5)-1","v":0.19145159349341045}]
[null,"Asset Turnover",{"$f":"'Screener Output.v0'!H25/'Screener Output.v0'!H60","v":0.91878488256452895},{"$f":"'Screener Output.v0'!I25/'Screener Output.v0'!I60","v":0.9150113812822438},{"$f":"'Screener Output.v0'!J25/'Screener Output.v0'!J60","v":0.8353654674112716},{"$f":"'Screener Output.v0'!K25/'Screener Output.v0'!K60","v":0.7158911599574328},{"$f":"'Screener Output.v0'!L25/'Screener Output.v0'!L60","v":0.72270781547139984},{"$f":"'Screener Output.v0'!M26/'Screener Output.v0'!L60","v":0.73321343865072197},null,"Sales",{"$f":"POWER('Screener Output.v0'!M26/'Screener Output.v0'!G26,1/5)-1","v":9.9325488710200194E-2}]
[null,"Equity Multiplier",{"$f":"'Screener Output.v0'!H60/SUM('Screener Output.v0'!H40:H41)","v":2.210589606399322},{"$f":"'Screener Output.v0'!I60/SUM('Screener Output.v0'!I40:I41)","v":2.1228596813967138},{"$f":"'Screener Output.v0'!J60/SUM('Screener Output.v0'!J40:J41)","v":2.2938438607345746},{"$f":"'Screener Output.v0'!K60/SUM('Screener Output.v0'!K40:K41)","v":2.4671073850187191},{"$f":"'Screener Output.v0'!L60/SUM('Screener Output.v0'!L40:L41)","v":2.243433131308612},null,null,"Assets",{"$f":"POWER('Screener Output.v0'!L60/'Screener Output.v0'!G60,1/5)-1","v":0.12718807206054916}]
[null,"ROE",{"$f":"C7*C8*C9","v":0.21896848548005526},{"$f":"D7*D8*D9","v":0.2292545693490112},{"$f":"E7*E8*E9","v":0.18894290283193199},{"$f":"F7*F8*F9","v":0.24925910322937464},{"$f":"G7*G8*G9","v":0.26917602389526518},{"$f":"H7*H8*G9","v":0.32434155546784993},null,"Shareholder funds ",{"$f":"POWER(SUM('Screener Output.v0'!L40:L41)/SUM('Screener Output.v0'!G40:G41),1/5)-1","v":0.13565411390920201}]
[null,"RoCE",{"$f":"'Screener Output.v0'!H93","v":0.18695944913007703},{"$f":"'Screener Output.v0'!I93","v":0.1936839768691376},{"$f":"'Screener Output.v0'!J93","v":0.18087392149850245},{"$f":"'Screener Output.v0'!K93","v":0.19793010336583927},{"$f":"'Screener Output.v0'!L93","v":0.2268238710590379},{"$f":"'Screener Output.v0'!M93","v":0.25841104341031534}]
[null,"RoIC",{"$f":"('Screener Output.v0'!H35-'Screener Output.v0'!G35)/('Screener Output.v0'!H41-'Screener Output.v0'!G41)","v":-5.6515626689737211E-2},{"$f":"('Screener Output.v0'!I35-'Screener Output.v0'!H35)/('Screener Output.v0'!I41-'Screener Output.v0'!H41)","v":0.29354181845354838},{"$f":"('Screener Output.v0'!J35-'Screener Output.v0'!I35)/('Screener Output.v0'!J41-'Screener Output.v0'!I41)","v":3.3335619570187522},{"$f":"('Screener Output.v0'!K35-'Screener Output.v0'!J35)/('Screener Output.v0'!K41-'Screener Output.v0'!J41)","v":0.46121664186747341},{"$f":"('Screener Output.v0'!L35-'Screener Output.v0'!K35)/('Screener Output.v0'!L41-'Screener Output.v0'!K41)","v":0.35369569224430819}]
[null,"DuPont analysis is an extended analysis of a company's return on equity. It concludes that a company can earn a high return on equity if:"]
[]
[null,"1. It earns a high net profit margin - Preferred"]
[null,"2. It uses its assets effectively to generate more sales; and/or - Preferred"]
[null,"3. It has a high financial leverage"]
[]
[]
[null,null,null,null,null,"NPCY - NPCY-4",{"$f":"'Screener Output.v0'!L35-'Screener Output.v0'!G35","v":788.75000000000114},null,null,{"$f":"G20/G22","v":0.27093917565789738}]
[null,null,null,null,null,null,null,null,"꓿"]
[null,null,null,null,null,"NWCY - NWCY-4",{"$f":"'Screener Output.v0'!L41-'Screener Output.v0'!G41","v":2911.17}]

{"sheet":"Others","index":10,"n_rows":64,"n_cols":13,"rows_kept":64,"cut":false,"hidden":false,"merged":[[63,1,63,6],[18,1,18,6],[5,1,5,6],[20,8,20,9],[20,10,20,11],[50,9,50,10],[50,11,50,12],[20,12,20,13],[20,1,20,2],[20,3,20,4],[5,8,5,13],[35,1,35,2],[35,3,35,4],[35,5,35,6]]}
[]
[null,null,null,null,"Promoter Pledged Holding","Promoter Holding 5 Yr.",null,null,null,null,null,"Promoter Pledged Holding","Promoter Holding 5 Yr."]
[null,null,null,"Expected Value",0,">=-3%",null,null,null,null,"Expected Score",6,3]
[null,null,null,"Actual Value",{"$f":"'Shareholding input'!C7","v":0},{"$f":"SUM('Shareholding input'!C6:C7)-SUM('Shareholding input'!H6:H7)","v":-6.0000000000004494E-4},null,null,null,null,"Actual Value",{"$f":"IF(E4>0,0,6)","v":6},{"$f":"IF(F4>-0.03,3,IF(F4=0,2,0))","v":3}]
[]
[null,"Inventory Days\n",null,null,null,null,null,null,"Inventory/Sales\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"How effectively inventory is managed by comparing cost of goods sold with average inventory for a period. This measures how many times average inventory is “turned” or sold during a period"]
[]
[null,"Tangible assets",null,null,null,null,null,null,"Asset Dist. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Shareholding Dist."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Receivable Days\n",null,null,null,null,null,null,null,"Liabilty Dist."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Accounts receivable days is the number of days that a customer invoice is outstanding before it is collected - indicator of credit terms offered by the company to its customers and subsequent collection practices"]

{"sheet":"Piotroski","index":11,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,1,0,6],[1,1,1,6],[34,1,34,3],[35,1,35,3],[36,1,36,3]]}
[]
[null,"Piotrosoki Score"]
[null,"Piotroski F Score data","CY","CY-1","CY-2","CY-3","CY-4"]
[null,"ROA",{"$f":"SUM('Screener Output.v0'!L35:L35)/SUM('Screener Output.v0'!L60:L60)","v":0.11639375787921748},{"$f":"SUM('Screener Output.v0'!K35:K35)/SUM('Screener Output.v0'!K60:K60)","v":9.9994036916076362E-2},{"$f":"SUM('Screener Output.v0'!J35:J35)/SUM('Screener Output.v0'!J60:J60)","v":8.486330858809088E-2},{"$f":"SUM('Screener Output.v0'!I35:I35)/SUM('Screener Output.v0'!I60:I60)","v":0.10670211638303616},{"$f":"SUM('Screener Output.v0'!H35:H35)/SUM('Screener Output.v0'!H60:H60)","v":9.8168433211196962E-2}]
[null,"Borrowings / Total Assets",{"$f":"'Screener Output.v0'!L45/'Screener Output.v0'!L60","v":0.24884082022207818},{"$f":"'Screener Output.v0'!K45/'Screener Output.v0'!K60","v":0.30587027387374166},{"$f":"'Screener Output.v0'!J45/'Screener Output.v0'!J60","v":0.29538177352483819},{"$f":"'Screener Output.v0'!I45/'Screener Output.v0'!I60","v":0.29692415793263899},{"$f":"'Screener Output.v0'!H45/'Screener Output.v0'!H60","v":0.28438291560126816}]
[null,"Current Ratio",{"$f":"SUM('Screener Output.v0'!L9:L9)/SUM('Screener Output.v0'!L10:L10)","v":1.082998292926372},{"$f":"SUM('Screener Output.v0'!K9:K9)/SUM('Screener Output.v0'!K10:K10)","v":1.0500370605675562},{"$f":"SUM('Screener Output.v0'!J9:J9)/SUM('Screener Output.v0'!J10:J10)","v":1.3778092985404959},{"$f":"SUM('Screener Output.v0'!I9:I9)/SUM('Screener Output.v0'!I10:I10)","v":1.5023620563784941},{"$f":"SUM('Screener Output.v0'!H9:H9)/SUM('Screener Output.v0'!H10:H10)","v":1.3295889014310163}]
[null,"Gross Margin",{"$f":"'Screener Output.v0'!L29/'Screener Output.v0'!L26","v":0.24053795131089578},{"$f":"'Screener Output.v0'!K29/'Screener Output.v0'!K26","v":0.21395222871175901},{"$f":"'Screener Output.v0'!J29/'Screener Output.v0'!J26","v":0.16564101103054654},{"$f":"'Screener Output.v0'!I29/'Screener Output.v0'!I26","v":0.17550268035754218},{"$f":"'Screener Output.v0'!H29/'Screener Output.v0'!H26","v":0.16204156342481782}]
[null,"PAT",{"$f":"'Screener Output.v0'!L35","v":1634.1800000000014},{"$f":"'Screener Output.v0'!K35","v":1307.9699999999984},{"$f":"'Screener Output.v0'!J35","v":830.62000000000057},{"$f":"'Screener Output.v0'!I35","v":976.43000000000006},{"$f":"'Screener Output.v0'!H35","v":819.3000000000003}]
[null,"Operating Cash Flow",{"$f":"'Screener Output.v0'!L62","v":1723.35},{"$f":"'Screener Output.v0'!K62","v":1860.22},{"$f":"'Screener Output.v0'!J62","v":847.37},{"$f":"'Screener Output.v0'!I62","v":1026.73},{"$f":"'Screener Output.v0'!H62","v":1115.8699999999999}]
[null,"Shares Outstanding",{"$f":"'Screener Output.v0'!L40","v":68.13},{"$f":"'Screener Output.v0'!K40","v":34.06},{"$f":"'Screener Output.v0'!J40","v":34.049999999999997},{"$f":"'Screener Output.v0'!I40","v":34.04},{"$f":"'Screener Output.v0'!H40","v":34.04}]
[null,"Asset Turnover",{"$f":"'Screener Output.v0'!L25/'Screener Output.v0'!L49","v":0.72270781547139984},{"$f":"'Screener Output.v0'!K25/'Screener Output.v0'!K49","v":0.7158911599574328},{"$f":"'Screener Output.v0'!J25/'Screener Output.v0'!J49","v":0.8353654674112716},{"$f":"'Screener Output.v0'!I25/'Screener Output.v0'!I49","v":0.9150113812822438},{"$f":"'Screener Output.v0'!H25/'Screener Output.v0'!H49","v":0.91878488256452895}]
[null,null,null,null,null,null,null,"Start",0,"Value",{"$f":"(C23/9)*100","v":88.888888888888886}]
[null,null,null,null,null,null,null,"Intial",30,"Pointer",1]
[null,"Piotroski 1: PAT >0",{"$f":"--(C8>0)","v":1},null,null,null,null,"Middle",40,"End",{"$f":"SUM(I12:I16) - SUM(K12:K13)","v":110.11111111111111}]
[null,"Piotroski 2: Operating Cash Flow >0",{"$f":"--(C9>0)","v":1},null,null,null,null,"End",30]
[null,"Piotroski 3: Return on Assets higher than last Yr.",{"$f":"--(C4>D4)","v":1},null,null,null,null,"Max",100]
[null,"Piotroski 4: Operating Cash Flow higher than PAT",{"$f":"--(C9>C8)","v":1}]
[null,"Piotroski 5: Borrowings/Assets lower than last Yr.",{"$f":"--(C5<D5)","v":1}]
[null,"Piotroski 6: Current Ratio than last Yr.",{"$f":"--(C6>D6)","v":1}]
[null,"Piotroski 7: Shares Outstanding not higher than last Yr.",{"$f":"--(C10<D10)","v":0}]
[null,"Piotroski 8: Gross Margin higher than last Yr.",{"$f":"--(C7>D7)","v":1}]
[null,"Piotroski 9: Total Income/Total Assets higher than last Yr.",{"$f":"--(C11>D11)","v":1}]
[null,"Piotroski F Score",{"$f":"SUM(C14:C22)","v":8}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Weak"]
[null,"Stable"]
[null,"Strong"]

{"sheet":"Altman","index":12,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[2,1,2,5],[0,1,0,5],[1,1,1,5]]}
[]
[null,"Altman Zscore"]
[null,"Altman Zscore = 1.2T1 + 1.4T2 + 3.3T3 + 0.6T4 + 0.999T5."]
[null,"Input","CY",null,"T1 = Working Capital/Total Assets",{"$f":"C5/C6","v":2.5348822301835432E-2},"Altman Score",null,"Pointer"]
[null,"Working Capital",{"$f":"'Screener Output.v0'!L52","v":355.89999999999964},null,"T2 = Reserves & Surplus/Total Assets",{"$f":"C8/C6","v":0.44089287113339648},"Start",0,"Value",{"$f":"(C14/6)*100","v":89.231691998869906}]
[null,"Total Assets",{"$f":"'Screener Output.v0'!L60","v":14040.1},null,"T3 = EBITDA/Total Assets",{"$f":"C9/C6","v":0.16863697552011747},"Intial",30,"Pointer",1]
[null,"Total Liabilities",{"$f":"'Screener Output.v0'!L60","v":14040.1},null,"T4 = Market Value of Equity/Total Assets",{"$f":"'Screener Output.v0'!B38/'Screener Output.v0'!L60","v":5.7489156060142026},"Middle",20,"End",{"$f":"SUM(H5:H9) - SUM(J5:J6)","v":109.76830800113009}]
[null,"Reserves & Surplus",{"$f":"'Screener Output.v0'!L41","v":6190.18},null,"T5 = Net Sales/Total Assets",{"$f":"C11/C6","v":0.70108261337169964},"End",50]
[null,"EBITDA",{"$f":"'Screener Output.v0'!L29","v":2367.6800000000012},null,null,null,"Max",100]
[null,"Market Value of Equity",{"$f":"'Screener Output.v0'!B38","v":80715.350000000006},null,null,null,{"$f":"IF(SUM(C1:D1)>=20,20,SUM(C1:D1))","v":0}]
[null,"Net Sales",{"$f":"'Screener Output.v0'!L26","v":9843.27}]
[]
[]
[null,"Score",{"$f":"IF((1.2*F4+1.4*F5+3.3*F6+0.6*F7+0.999*F8)>=6,6,(1.2*F4+1.4*F5+3.3*F6+0.6*F7+0.999*F8))","v":5.3539015199321947}]
[]
[null,"How to read score"]
[null,"Less Chances of Bankruptcy","1.8 to 3"]
[null,"Not likely to be Bankrupt","3+"]
[null,"Likely to be Bankrupt","0 to 1.8"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Likely to be Bankrupt"]
[null,"Less Chances of Bankruptcy"]
[null,"Not likely to be Bankrupt"]

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

{"sheet":"Analysis","index":14,"n_rows":13,"n_cols":15,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[]
[null,"PE","PB","OTHERS","Gross Profit Margin","Net Profit Margin","Inventory/Sales","Receivables/\nSales","Current Cash/Assets","Current Assets/Current Liabilities","Leverage","Debt/PAT","ROE","ROCE","ROA"]
[null,{"$f":"AVERAGE('Screener Output.v0'!H76:L76)","v":30.176033081068049},{"$f":"AVERAGE('Screener Output.v0'!H78:L78)","v":6.6998778666192305},"5 Yr. Average",{"$f":"SUM('Screener Output.v0'!H29:L29)/SUM('Screener Output.v0'!H26:L26)","v":0.194189138880493},{"$f":"SUM('Screener Output.v0'!H35:M35)/SUM('Screener Output.v0'!H26:M26)","v":0.14149044906462638},{"$f":"SUM('Screener Output.v0'!H6:L6)/SUM('Screener Output.v0'!H26:L26)","v":0.14861517593200094},{"$f":"SUM('Screener Output.v0'!H7:L7)/SUM('Screener Output.v0'!H26:L26)","v":0.11354857020693111},{"$f":"SUM('Screener Output.v0'!H55:L55)/SUM('Screener Output.v0'!H60:L60)","v":7.767037581171056E-2},{"$f":"SUM('Screener Output.v0'!H9:L9)/SUM('Screener Output.v0'!H10:L10)","v":1.2217137103084879},{"$f":"SUM('Screener Input'!G66:K66)/SUM('Screener Input'!G57:K58)","v":2.275099933886191},{"$f":"SUM('Screener Output.v0'!H45:L45)/SUM('Screener Output.v0'!H35:L35)","v":2.7792708988057817},{"$f":"SUM('Screener Output.v0'!H35:L35)/SUM('Screener Output.v0'!H40:L41)","v":0.23286195010226524},{"$f":"SUM('Screener Output.v0'!H35:L35)/SUM('Screener Output.v0'!H42:L45)","v":0.14136951607629208},{"$f":"SUM('Screener Output.v0'!H35:L35)/SUM('Screener Output.v0'!H60:L60)","v":0.10235240511149955}]
[null,{"$f":"'Screener Output.v0'!L76","v":30.551193553409234},{"$f":"'Screener Output.v0'!L78","v":7.9775769306906019},"Current",{"$f":"'Screener Output.v0'!L29/'Screener Output.v0'!L26","v":0.24053795131089578},{"$f":"'Screener Output.v0'!M35/'Screener Output.v0'!M26","v":0.19717826894065599},{"$f":"SUM('Screener Output.v0'!L6:L6)/SUM('Screener Output.v0'!L26:L26)","v":0.16028413321995638},{"$f":"SUM('Screener Output.v0'!L7:L7)/SUM('Screener Output.v0'!L26:L26)","v":0.12653315412459476},{"$f":"'Screener Output.v0'!L55/'Screener Output.v0'!L60","v":6.8390538528927861E-2},{"$f":"SUM('Screener Output.v0'!L9:L9)/SUM('Screener Output.v0'!L10:L10)","v":1.082998292926372},{"$f":"SUM('Screener Input'!K66:K66)/SUM('Screener Input'!K57:K58)","v":2.243433131308612},{"$f":"SUM('Screener Output.v0'!L45:L45)/SUM('Screener Output.v0'!M35:M35)","v":1.721203253474429},{"$f":"Dupont!H10","v":0.32434155546784993},{"$f":"SUM('Screener Output.v0'!L35:L35)/SUM('Screener Output.v0'!L42:L45)","v":0.16757280000328148},{"$f":"SUM('Screener Output.v0'!L35:L35)/SUM('Screener Output.v0'!L60:L60)","v":0.11639375787921748}]
[null,{"$f":"MAX('Screener Output.v0'!H76:L76)","v":37.439059404911546},{"$f":"MAX('Screener Output.v0'!H78:L78)","v":7.9775769306906019},"5 Yr. Max"]
[null,null,null," "]
[null,null,null,"CASH FLOW","CFO"," CFF/CFO","Capex/CFO","CFO/PAT","CFO/Sales","CFO/Assets","CFO/Current Liabilty","CFO/Total Debt","FCF/CFO","CAPEX/FCF"]
[null,null,null,"5 Yr. Average",{"$f":"AVERAGE('Screener Output.v0'!H62:L62)","v":1314.7079999999999},{"$f":"SUM('Screener Output.v0'!H65:L65)/SUM('Screener Output.v0'!H62:L62)","v":-0.2364570687939832},{"$f":"SUM('Screener Output.v0'!H23:L23)/SUM('Screener Output.v0'!H62:L62)","v":0.65907866994039743},{"$f":"SUM('Screener Output.v0'!H62:L62)/SUM('Screener Output.v0'!H35:L35)","v":1.1804866660680611},{"$f":"SUM('Screener Output.v0'!H62:L62)/SUM('Screener Output.v0'!H26:L26)","v":0.15143725718582512},{"$f":"SUM('Screener Output.v0'!H62:L62)/SUM('Screener Output.v0'!H60:L60)","v":0.12082564947412167},{"$f":"SUM('Screener Output.v0'!H62:L62)/SUM('Screener Output.v0'!H48:L48)","v":0.43778391514362824},{"$f":"SUM('Screener Output.v0'!H62:L62)/SUM('Screener Output.v0'!H45:L45)","v":0.42474688832071084},{"$f":"SUM('Screener Output.v0'!H63:L63)/SUM('Screener Output.v0'!H62:L62)","v":0.34092133005960262},{"$f":"SUM('Screener Output.v0'!H23:L23)/SUM('Screener Output.v0'!H63:L63)","v":1.9332280260233996}]
[null,null,null,"Current",{"$f":"'Screener Output.v0'!L62","v":1723.35},{"$f":"SUM('Screener Output.v0'!L65:L65)/SUM('Screener Output.v0'!L62:L62)","v":-0.80309281341573102},{"$f":"SUM('Screener Output.v0'!L23:L23)/SUM('Screener Output.v0'!L62:L62)","v":0.21715844140772314},{"$f":"SUM('Screener Output.v0'!L62:L62)/SUM('Screener Output.v0'!L35:L35)","v":1.0545655925295858},{"$f":"SUM('Screener Output.v0'!L62:L62)/SUM('Screener Output.v0'!L26:L26)","v":0.17507901337665224},{"$f":"SUM('Screener Output.v0'!L62:L62)/SUM('Screener Output.v0'!L60:L60)","v":0.12274485224464213},{"$f":"SUM('Screener Output.v0'!L62:L62)/SUM('Screener Output.v0'!L48:L48)","v":0.40189690394679151},{"$f":"SUM('Screener Output.v0'!L62:L62)/SUM('Screener Output.v0'!L45:L45)","v":0.49326654740608228},{"$f":"SUM('Screener Output.v0'!L63:L63)/SUM('Screener Output.v0'!L62:L62)","v":0.78284155859227678},{"$f":"SUM('Screener Output.v0'!L23:L23)/SUM('Screener Output.v0'!L63:L63)","v":0.27739769181163854}]
[]
[null,null,null,"GROWTH","Sales","Inventory ","Receivables ","PAT","EPS","BVPS","CFO","FCF","Networth"]
[null,null,null,"10 YR CAGR",{"$f":"POWER('Screener Output.v0'!M25/'Screener Output.v0'!C25,1/9)-1","v":0.25206079569986128},{"$f":"('Screener Output.v0'!L6/'Screener Output.v0'!C6)^(1/9)-1","v":0.28301739822754968},{"$f":"('Screener Output.v0'!L7/'Screener Output.v0'!C7)^(1/9)-1","v":0.40023895054207204},{"$f":"POWER('Screener Output.v0'!M35/'Screener Output.v0'!C35,1/9)-1","v":0.31447176506737473},{"$f":"('Screener Output.v0'!M74/'Screener Output.v0'!C74)^(1/9)-1","v":0.29544957553311435},{"$f":"('Screener Output.v0'!L73/'Screener Output.v0'!C73)^(1/9)-1","v":0.28576069210202748},{"$f":"('Screener Output.v0'!L62/'Screener Output.v0'!C62)^(1/9)-1","v":0.31833034146691719},{"$f":"('Screener Output.v0'!L63/'Screener Output.v0'!C62)^(1/9)-1","v":0.28295148386740299},{"$f":"('Screener Output.v0'!L42/'Screener Output.v0'!C42)^(1/9)-1","v":0.30464061150823163}]
[null,null,null,"5 YR CAGR",{"$f":"POWER('Screener Output.v0'!M25/'Screener Output.v0'!G25,1/5)-1","v":0.10449518431683535},{"$f":"('Screener Output.v0'!L6/'Screener Output.v0'!G6)^(1/5)-1","v":8.5448402444458837E-2},{"$f":"('Screener Output.v0'!L7/'Screener Output.v0'!G7)^(1/5)-1","v":0.11314525899163441},{"$f":"POWER('Screener Output.v0'!M35/'Screener Output.v0'!G35,1/5)-1","v":0.19145159349341045},{"$f":"('Screener Output.v0'!M74/'Screener Output.v0'!G74)^(1/5)-1","v":0.20572197295616834},{"$f":"('Screener Output.v0'!L73/'Screener Output.v0'!G73)^(1/5)-1","v":0.13552015038550658},{"$f":"('Screener Output.v0'!L62/'Screener Output.v0'!G62)^(1/5)-1","v":0.16011012480684328},{"$f":"('Screener Output.v0'!L63/'Screener Output.v0'!G63)^(1/5)-1","v":-2.52341610859584},{"$f":"('Screener Output.v0'!L42/'Screener Output.v0'!G42)^(1/5)-1","v":0.13565411390920201}]

{"sheet":"Screener Output.v0","index":15,"n_rows":207,"n_cols":14,"rows_kept":207,"cut":false,"hidden":false,"merged":[[67,0,67,10],[84,0,84,10],[2,0,2,9],[11,0,11,10],[12,0,12,9],[37,2,37,10]]}
[{"$f":"'Screener Input'!B1","v":"GODREJ CONSUMER PRODUCTS LTD"}]
[]
["COPY PASTE DATA FROM ANY FINANCIAL WEBSITE: ONLY FOR THE FIELDS MARKED GREEN BELOW"]
[{"$f":"'Screener Input'!A1","v":"COMPANY NAME"},null,{"$f":"EOMONTH('Screener Input'!B$16,-1)+1","v":"2009-03-01"},{"$f":"EOMONTH('Screener Input'!C$16,-1)+1","v":"2010-03-01"},{"$f":"EOMONTH('Screener Input'!D$16,-1)+1","v":"2011-03-01"},{"$f":"EOMONTH('Screener Input'!E$16,-1)+1","v":"2012-03-01"},{"$f":"EOMONTH('Screener Input'!F$16,-1)+1","v":"2013-03-01"},{"$f":"EOMONTH('Screener Input'!G$16,-1)+1","v":"2014-03-01"},{"$f":"EOMONTH('Screener Input'!H$16,-1)+1","v":"2015-03-01"},{"$f":"EOMONTH('Screener Input'!I$16,-1)+1","v":"2016-03-01"},{"$f":"EOMONTH('Screener Input'!J$16,-1)+1","v":"2017-03-01"},{"$f":"EOMONTH('Screener Input'!K$16,-1)+1","v":"2018-03-01"}]
["CONSOLIDATED"]
["Inventory",null,{"$f":"'Screener Output.v0'!C54","v":167.47},{"$f":"'Screener Output.v0'!D54","v":264.43},{"$f":"'Screener Output.v0'!E54","v":439.41},{"$f":"'Screener Output.v0'!F54","v":783.91},{"$f":"'Screener Output.v0'!G54","v":1047.0899999999999},{"$f":"'Screener Output.v0'!H54","v":1082.1300000000001},{"$f":"'Screener Output.v0'!I54","v":1071.71},{"$f":"'Screener Output.v0'!J54","v":1306.98},{"$f":"'Screener Output.v0'!K54","v":1412.5},{"$f":"'Screener Output.v0'!L54","v":1577.72}]
["Debtors",null,{"$f":"C53","v":60.19},115.26,383.99,472.53,728.76,732.05,804.58,1118.01,1028.74,1245.5]
["Cash",null,{"$f":"C55","v":378.32},305.16000000000003,226.91,639.87,747.6,704.79,894.22,753.79,912.66,960.21]
["Current Assets",null,{"$f":"C47","v":735.04},912.45,1415.6,2286.5500000000002,2957.84,2921.16,3189.74,3623.17,3966.62,4643.9399999999996]
["Current Liabilities",null,336.39,562.32000000000005,775.39,1335.04,1946.55,2197.04,2123.15,2629.66,3777.6,4288.04]
["Working Capital (check)",null,{"$f":"C9-C10","v":398.65},350.13,640.20999999999992,951.51000000000022,1011.2900000000002,724.11999999999989,1066.5899999999997,993.51000000000022,189.01999999999998,355.89999999999964]
[]
["COPY PASTE DATA FROM ANNUAL REPORTS: ONLY FOR THE FIELDS MARKED ORANGE BELOW"]
["Operating Expenses/Capex",null,{"$f":"C4","v":"2009-03-01"},"2010-03-01","2011-03-01","2012-03-01","2013-03-01","2014-03-01","2015-03-01","2016-03-01","2017-03-01","2018-03-01"]
["Raw Materials",null,{"$f":"'Screener Input'!B18","v":760.63},{"$f":"'Screener Input'!C18","v":986.75},{"$f":"'Screener Input'!D18","v":1752.4},{"$f":"'Screener Input'!E18","v":2527.85},{"$f":"'Screener Input'!F18","v":3177.49},{"$f":"'Screener Input'!G18","v":3504.3},{"$f":"'Screener Input'!H18","v":3806.48},{"$f":"'Screener Input'!I18","v":3959.14},{"$f":"'Screener Input'!J18","v":4265.8500000000004},{"$f":"'Screener Input'!K18","v":4218.3599999999997}]
["Employee cost",null,{"$f":"'Screener Input'!B22","v":86.53},{"$f":"'Screener Input'!C22","v":151.80000000000001},{"$f":"'Screener Input'!D22","v":284.5},{"$f":"'Screener Input'!E22","v":401.48},{"$f":"'Screener Input'!F22","v":590.67999999999995},{"$f":"'Screener Input'!G22","v":742.43},{"$f":"'Screener Input'!H22","v":776.95},{"$f":"'Screener Input'!I22","v":944.13},{"$f":"'Screener Input'!J22","v":988.46},{"$f":"'Screener Input'!K22","v":1057.4100000000001}]
["Advertising and sales promotion",null,{"$f":"'Screener Input'!B23","v":245.08},{"$f":"'Screener Input'!C23","v":323.26},{"$f":"'Screener Input'!D23","v":774.11},{"$f":"'Screener Input'!E23","v":994.66},{"$f":"'Screener Input'!F23","v":1405.16},{"$f":"'Screener Input'!G23","v":1698.48},{"$f":"'Screener Input'!H23","v":1818.85},{"$f":"'Screener Input'!I23","v":1464.98},{"$f":"'Screener Input'!J23","v":1649.39},{"$f":"'Screener Input'!K23","v":1771.6}]
["Freight, transport and distribution"]
["Royalty"]
["Power and fuel",null,{"$f":"'Screener Input'!B20","v":35.61},{"$f":"'Screener Input'!C20","v":33.46},{"$f":"'Screener Input'!D20","v":53.39},{"$f":"'Screener Input'!E20","v":79.959999999999994},{"$f":"'Screener Input'!F20","v":102.56},{"$f":"'Screener Input'!G20","v":103.2},{"$f":"'Screener Input'!H20","v":109.92},{"$f":"'Screener Input'!I20","v":109.99},{"$f":"'Screener Input'!J20","v":89.02},{"$f":"'Screener Input'!K20","v":101.11}]
["Miscellaneous expenses",null,{"$f":"'Screener Input'!B24","v":26.46},{"$f":"'Screener Input'!C24","v":143.38},{"$f":"'Screener Input'!D24","v":128.6},{"$f":"'Screener Input'!E24","v":79.58},{"$f":"'Screener Input'!F24","v":131.84},{"$f":"'Screener Input'!G24","v":141.97999999999999},{"$f":"'Screener Input'!H24","v":150.09},{"$f":"'Screener Input'!I24","v":158.43},{"$f":"'Screener Input'!J24","v":219.07},{"$f":"'Screener Input'!K24","v":255.98}]
["R&D Cost"]
["Capex",null,null,{"$f":"(D50-C50)+(D51-C51)+D30","v":155.09000000000003},2561.1899999999996,708.11000000000013,984.54000000000042,733.36999999999932,577.9100000000002,300.14,2346.8200000000006,374.23999999999967]
[{"$f":"'Screener Input'!A1","v":"COMPANY NAME"},null,{"$f":"C14","v":"2009-03-01"},"2010-03-01","2011-03-01","2012-03-01","2013-03-01","2014-03-01","2015-03-01","2016-03-01","2017-03-01","2018-03-01","TTMI","TTMI-1"]
["Total Income",null,{"$f":"'Screener Input'!B17+'Screener Input'!B25","v":1436.42},{"$f":"'Screener Input'!C17+'Screener Input'!C25","v":2085.7400000000002},{"$f":"'Screener Input'!D17+'Screener Input'!D25","v":3785.27},{"$f":"'Screener Input'!E17+'Screener Input'!E25","v":5105.51},{"$f":"'Screener Input'!F17+'Screener Input'!F25","v":6608.3200000000006},{"$f":"'Screener Input'!G17+'Screener Input'!G25","v":7668.05},{"$f":"'Screener Input'!H17+'Screener Input'!H25","v":8373.26},{"$f":"'Screener Input'!I17+'Screener Input'!I25","v":8176.3399999999992},{"$f":"'Screener Input'!J17+'Screener Input'!J25","v":9364.2000000000007},{"$f":"'Screener Input'!K17+'Screener Input'!K25","v":10146.890000000001},{"$f":"SUM('Screener Input'!H42:K42)+SUM('Screener Input'!H44:K44)","v":10862.010000000002},{"$f":"SUM('Screener Input'!D42:G42)+SUM('Screener Input'!D44:G44)","v":9562.02}]
["Sales",null,{"$f":"'Screener Input'!B17","v":1396.49},{"$f":"'Screener Input'!C17","v":2041.44},{"$f":"'Screener Input'!D17","v":3691.89},{"$f":"'Screener Input'!E17","v":4853.34},{"$f":"'Screener Input'!F17","v":6411.64},{"$f":"'Screener Input'!G17","v":7599.47},{"$f":"'Screener Input'!H17","v":8273.15},{"$f":"'Screener Input'!I17","v":8423.8799999999992},{"$f":"'Screener Input'!J17","v":9267.91},{"$f":"'Screener Input'!K17","v":9843.27},{"$f":"SUM('Screener Input'!H42:K42)","v":10294.390000000001},{"$f":"SUM('Screener Input'!D42:G42)","v":9475.83}]
[{"$f":"A15","v":"Raw Materials"},null,760.63,986.75,1752.4,2527.85,3177.49,3504.3,3806.48,3959.14,4265.8500000000004,4218.3599999999997]
["Gross Profit",null,{"$f":"C26-C27","v":635.86},1054.69,1939.4899999999998,2325.4900000000002,3234.1500000000005,4095.17,4466.67,4464.74,5002.0599999999995,5624.9100000000008]
["EBITDA",null,{"$f":"'Screener Input'!B17-'Screener Input'!B18-'Screener Input'!B20-'Screener Input'!B21-'Screener Input'!B22-'Screener Input'!B23-'Screener Input'!B24+'Screener Input'!B25+'Screener Input'!B19","v":247.31000000000003},{"$f":"'Screener Input'!C17-'Screener Input'!C18-'Screener Input'!C20-'Screener Input'!C21-'Screener Input'!C22-'Screener Input'!C23-'Screener Input'!C24+'Screener Input'!C25+'Screener Input'!C19","v":454.62},{"$f":"'Screener Input'!D17-'Screener Input'!D18-'Screener Input'!D20-'Screener Input'!D21-'Screener Input'!D22-'Screener Input'!D23-'Screener Input'!D24+'Screener Input'!D25+'Screener Input'!D19","v":751.41999999999973},{"$f":"'Screener Input'!E17-'Screener Input'!E18-'Screener Input'!E20-'Screener Input'!E21-'Screener Input'!E22-'Screener Input'!E23-'Screener Input'!E24+'Screener Input'!E25+'Screener Input'!E19","v":1114.3200000000002},{"$f":"'Screener Input'!F17-'Screener Input'!F18-'Screener Input'!F20-'Screener Input'!F21-'Screener Input'!F22-'Screener Input'!F23-'Screener Input'!F24+'Screener Input'!F25+'Screener Input'!F19","v":1188.9300000000003},{"$f":"'Screener Input'!G17-'Screener Input'!G18-'Screener Input'!G20-'Screener Input'!G21-'Screener Input'!G22-'Screener Input'!G23-'Screener Input'!G24+'Screener Input'!G25+'Screener Input'!G19","v":1231.4300000000003},{"$f":"'Screener Input'!H17-'Screener Input'!H18-'Screener Input'!H20-'Screener Input'!H21-'Screener Input'!H22-'Screener Input'!H23-'Screener Input'!H24+'Screener Input'!H25+'Screener Input'!H19","v":1451.96},{"$f":"'Screener Input'!I17-'Screener Input'!I18-'Screener Input'!I20-'Screener Input'!I21-'Screener Input'!I22-'Screener Input'!I23-'Screener Input'!I24+'Screener Input'!I25+'Screener Input'!I19","v":1395.3400000000004},{"$f":"'Screener Input'!J17-'Screener Input'!J18-'Screener Input'!J20-'Screener Input'!J21-'Screener Input'!J22-'Screener Input'!J23-'Screener Input'!J24+'Screener Input'!J25+'Screener Input'!J19","v":1982.8899999999985},{"$f":"'Screener Input'!K17-'Screener Input'!K18-'Screener Input'!K20-'Screener Input'!K21-'Screener Input'!K22-'Screener Input'!K23-'Screener Input'!K24+'Screener Input'!K25+'Screener Input'!K19","v":2367.6800000000012},{"$f":"SUM('Screener Input'!H50:K50)+SUM('Screener Input'!H44:K44)","v":2684.4900000000002},{"$f":"SUM('Screener Input'!D50:G50)","v":1927.46}]
["Depreciation & Amortisation",null,{"$f":"'Screener Input'!B26","v":19.23},{"$f":"'Screener Input'!C26","v":23.6},{"$f":"'Screener Input'!D26","v":49.92},{"$f":"'Screener Input'!E26","v":64.44},{"$f":"'Screener Input'!F26","v":77},{"$f":"'Screener Input'!G26","v":81.849999999999994},{"$f":"'Screener Input'!H26","v":90.78},{"$f":"'Screener Input'!I26","v":100.63},{"$f":"'Screener Input'!J26","v":141.57},{"$f":"'Screener Input'!K26","v":155.68},{"$f":"SUM('Screener Input'!H45:K45)","v":164.45}]
["EBIT (Operating Profit)",null,{"$f":"C29-C30","v":228.08000000000004},431.02,701.49999999999977,1049.8800000000001,1111.9300000000003,1149.5800000000004,1361.18,1294.7100000000005,1841.3199999999986,2212.0000000000014,2520.0400000000004]
["Interest",null,{"$f":"'Screener Input'!B27","v":18.86},{"$f":"'Screener Input'!C27","v":11.1},{"$f":"'Screener Input'!D27","v":48.58},{"$f":"'Screener Input'!E27","v":72.59},{"$f":"'Screener Input'!F27","v":87.32},{"$f":"'Screener Input'!G27","v":119.91},{"$f":"'Screener Input'!H27","v":112.46},{"$f":"'Screener Input'!I27","v":128.04},{"$f":"'Screener Input'!J27","v":154.19},{"$f":"'Screener Input'!K27","v":173.12},{"$f":"SUM('Screener Input'!H46:K46)","v":189.82999999999998}]
["PBT",null,{"$f":"C31-C32","v":209.22000000000003},419.91999999999996,652.91999999999973,977.29000000000008,1024.6100000000004,1029.6700000000003,1248.72,1166.6700000000005,1687.1299999999985,2038.8800000000015]
["Tax",null,{"$f":"'Screener Input'!B29","v":35.96},{"$f":"'Screener Input'!C29","v":80.33},{"$f":"'Screener Input'!D29","v":138.21},{"$f":"'Screener Input'!E29","v":226.05},{"$f":"'Screener Input'!F29","v":179.18},{"$f":"'Screener Input'!G29","v":210.37},{"$f":"'Screener Input'!H29","v":272.29000000000002},{"$f":"'Screener Input'!I29","v":336.05},{"$f":"'Screener Input'!J29","v":379.16},{"$f":"'Screener Input'!K29","v":404.7},{"$f":"SUM('Screener Input'!H48:K48)","v":300.38}]
["PAT",null,{"$f":"C33-C34","v":173.26000000000002},339.59,514.7099999999997,751.24,845.43000000000029,819.3000000000003,976.43000000000006,830.62000000000057,1307.9699999999984,1634.1800000000014,{"$f":"SUM('Screener Input'!H49:K49)","v":2029.83},{"$f":"SUM('Screener Input'!D49:G49)","v":1326.6299999999999}]
["Dividends",null,{"$f":"'Screener Input'!B31","v":102.8},{"$f":"'Screener Input'!C31","v":130.99},{"$f":"'Screener Input'!D31","v":145.62},{"$f":"'Screener Input'!E31","v":161.63999999999999},{"$f":"'Screener Input'!F31","v":176.96},{"$f":"'Screener Input'!G31","v":178.71},{"$f":"'Screener Input'!H31","v":187.22},{"$f":"'Screener Input'!I31","v":195.79},{"$f":"'Screener Input'!J31","v":510.9},{"$f":"'Screener Input'!K31","v":681.3}]
["Market Cap",null,{"$f":"'Screener Input'!B90*'Screener Input'!B93","v":2638.0095002228513},{"$f":"'Screener Input'!C90*'Screener Input'!C93","v":6307.2912231255123},{"$f":"'Screener Input'!D90*'Screener Input'!D93","v":8387.8314148336176},{"$f":"'Screener Input'!E90*'Screener Input'!E93","v":11546.894363927551},{"$f":"'Screener Input'!F90*'Screener Input'!F93","v":18309.996489495748},{"$f":"'Screener Input'!G90*'Screener Input'!G93","v":18980.543261649102},{"$f":"'Screener Input'!H90*'Screener Input'!H93","v":25789.901663016255},{"$f":"'Screener Input'!I90*'Screener Input'!I93","v":30984.939954098845},{"$f":"'Screener Input'!J90*'Screener Input'!J93","v":38439.203657213031},{"$f":"'Screener Input'!K90*'Screener Input'!K93","v":49926.149481110304}]
["Current Market Cap",{"$f":"'Screener Input'!B9","v":80715.350000000006},null,null,null,null,null,null,null,null,null,{"$f":"L35+L34+L32+L30","v":2367.6800000000012}]
["Current EPS"]
["Equity",null,{"$f":"'Screener Input'!B57","v":25.7},{"$f":"'Screener Input'!C57","v":30.82},{"$f":"'Screener Input'!D57","v":32.36},{"$f":"'Screener Input'!E57","v":34.03},{"$f":"'Screener Input'!F57","v":34.03},{"$f":"'Screener Input'!G57","v":34.04},{"$f":"'Screener Input'!H57","v":34.04},{"$f":"'Screener Input'!I57","v":34.049999999999997},{"$f":"'Screener Input'!J57","v":34.06},{"$f":"'Screener Input'!K57","v":68.13}]
["Reserves & Surplus",null,{"$f":"'Screener Input'!B58","v":545.83000000000004},{"$f":"'Screener Input'!C58","v":923.87},{"$f":"'Screener Input'!D58","v":1692.8},{"$f":"'Screener Input'!E58","v":2769.94},{"$f":"'Screener Input'!F58","v":3279.01},{"$f":"'Screener Input'!G58","v":3741.36},{"$f":"'Screener Input'!H58","v":4276.6499999999996},{"$f":"'Screener Input'!I58","v":4232.91},{"$f":"'Screener Input'!J58","v":5267.89},{"$f":"'Screener Input'!K58","v":6190.18}]
["Networth",null,{"$f":"C41+C40","v":571.53000000000009},954.69,1725.1599999999999,2803.9700000000003,3313.0400000000004,3775.4,4310.6899999999996,4266.96,5301.9500000000007,6258.31]
["Secured Loans"]
["Unsecured Loans"]
["Borrowings",null,{"$f":"'Screener Input'!B59","v":277.57},{"$f":"'Screener Input'!C59","v":36.869999999999997},{"$f":"'Screener Input'!D59","v":2000.75},{"$f":"'Screener Input'!E59","v":1876.91},{"$f":"'Screener Input'!F59","v":2456.34},{"$f":"'Screener Input'!G59","v":2373.42},{"$f":"'Screener Input'!H59","v":2717.15},{"$f":"'Screener Input'!I59","v":2891.12},{"$f":"'Screener Input'!J59","v":4000.93},{"$f":"'Screener Input'!K59","v":3493.75}]
["Other Liabilities",null,{"$f":"'Screener Input'!B60","v":336.39},{"$f":"'Screener Input'!C60","v":562.32000000000005},{"$f":"'Screener Input'!D60","v":775.39},{"$f":"'Screener Input'!E60","v":1335.04},{"$f":"'Screener Input'!F60","v":1946.55},{"$f":"'Screener Input'!G60","v":2197.04},{"$f":"'Screener Input'!H60","v":2123.15},{"$f":"'Screener Input'!I60","v":2629.66},{"$f":"'Screener Input'!J60","v":3777.6},{"$f":"'Screener Input'!K60","v":4288.04}]
["Current Asset",null,{"$f":"'Screener Input'!B65","v":735.04},{"$f":"'Screener Input'!C65","v":912.45},{"$f":"'Screener Input'!D65","v":1415.6},{"$f":"'Screener Input'!E65","v":2286.5500000000002},{"$f":"'Screener Input'!F65","v":2957.84},{"$f":"'Screener Input'!G65","v":2921.16},{"$f":"'Screener Input'!H65","v":3189.74},{"$f":"'Screener Input'!I65","v":3623.17},{"$f":"'Screener Input'!J65","v":3966.62},{"$f":"'Screener Input'!K65","v":4643.9399999999996}]
["Current Liabilities",null,{"$f":"'Screener Input'!B60","v":336.39},{"$f":"'Screener Input'!C60","v":562.32000000000005},{"$f":"'Screener Input'!D60","v":775.39},{"$f":"'Screener Input'!E60","v":1335.04},{"$f":"'Screener Input'!F60","v":1946.55},{"$f":"'Screener Input'!G60","v":2197.04},{"$f":"'Screener Input'!H60","v":2123.15},{"$f":"'Screener Input'!I60","v":2629.66},{"$f":"'Screener Input'!J60","v":3777.6},{"$f":"'Screener Input'!K60","v":4288.04}]
["Total Assets",null,{"$f":"'Screener Input'!B66","v":1185.49},{"$f":"'Screener Input'!C66","v":1553.88},{"$f":"'Screener Input'!D66","v":4501.3},{"$f":"'Screener Input'!E66","v":6015.92},{"$f":"'Screener Input'!F66","v":7715.93},{"$f":"'Screener Input'!G66","v":8345.86},{"$f":"'Screener Input'!H66","v":9150.99},{"$f":"'Screener Input'!I66","v":9787.74},{"$f":"'Screener Input'!J66","v":13080.48},{"$f":"'Screener Input'!K66","v":14040.1}]
["Net Fixed Assets",null,{"$f":"'Screener Input'!B62","v":440.44},{"$f":"'Screener Input'!C62","v":573.59},{"$f":"'Screener Input'!D62","v":3077.68},{"$f":"'Screener Input'!E62","v":3691.79},{"$f":"'Screener Input'!F62","v":4496.0600000000004},{"$f":"'Screener Input'!G62","v":5121.3599999999997},{"$f":"'Screener Input'!H62","v":5550.95},{"$f":"'Screener Input'!I62","v":5931.41},{"$f":"'Screener Input'!J62","v":8082.89},{"$f":"'Screener Input'!K62","v":8315}]
["Capital Work in Progress",null,{"$f":"'Screener Input'!B63","v":2.5},{"$f":"'Screener Input'!C63","v":0.84},{"$f":"'Screener Input'!D63","v":8.02},{"$f":"'Screener Input'!E63","v":37.58},{"$f":"'Screener Input'!F63","v":140.85},{"$f":"'Screener Input'!G63","v":167.07},{"$f":"'Screener Input'!H63","v":224.61},{"$f":"'Screener Input'!I63","v":43.66},{"$f":"'Screener Input'!J63","v":97.43},{"$f":"'Screener Input'!K63","v":83.88}]
["Working Capital",null,{"$f":"'Screener Input'!B65-'Screener Input'!B60","v":398.65},{"$f":"'Screener Input'!C65-'Screener Input'!C60","v":350.13},{"$f":"'Screener Input'!D65-'Screener Input'!D60","v":640.20999999999992},{"$f":"'Screener Input'!E65-'Screener Input'!E60","v":951.51000000000022},{"$f":"'Screener Input'!F65-'Screener Input'!F60","v":1011.2900000000002},{"$f":"'Screener Input'!G65-'Screener Input'!G60","v":724.11999999999989},{"$f":"'Screener Input'!H65-'Screener Input'!H60","v":1066.5899999999997},{"$f":"'Screener Input'!I65-'Screener Input'!I60","v":993.51000000000022},{"$f":"'Screener Input'!J65-'Screener Input'!J60","v":189.01999999999998},{"$f":"'Screener Input'!K65-'Screener Input'!K60","v":355.89999999999964}]
["Debtors",null,{"$f":"'Screener Input'!B67","v":60.19},{"$f":"'Screener Input'!C67","v":115.26},{"$f":"'Screener Input'!D67","v":383.99},{"$f":"'Screener Input'!E67","v":472.53},{"$f":"'Screener Input'!F67","v":728.76},{"$f":"'Screener Input'!G67","v":732.05},{"$f":"'Screener Input'!H67","v":804.58},{"$f":"'Screener Input'!I67","v":1118.01},{"$f":"'Screener Input'!J67","v":1028.74},{"$f":"'Screener Input'!K67","v":1245.5}]
["Inventory",null,{"$f":"'Screener Input'!B68","v":167.47},{"$f":"'Screener Input'!C68","v":264.43},{"$f":"'Screener Input'!D68","v":439.41},{"$f":"'Screener Input'!E68","v":783.91},{"$f":"'Screener Input'!F68","v":1047.0899999999999},{"$f":"'Screener Input'!G68","v":1082.1300000000001},{"$f":"'Screener Input'!H68","v":1071.71},{"$f":"'Screener Input'!I68","v":1306.98},{"$f":"'Screener Input'!J68","v":1412.5},{"$f":"'Screener Input'!K68","v":1577.72}]
["Cash",null,{"$f":"'Screener Input'!B69","v":378.32},{"$f":"'Screener Input'!C69","v":305.16000000000003},{"$f":"'Screener Input'!D69","v":226.91},{"$f":"'Screener Input'!E69","v":639.87},{"$f":"'Screener Input'!F69","v":747.6},{"$f":"'Screener Input'!G69","v":704.79},{"$f":"'Screener Input'!H69","v":894.22},{"$f":"'Screener Input'!I69","v":753.79},{"$f":"'Screener Input'!J69","v":912.66},{"$f":"'Screener Input'!K69","v":960.21}]
["Net Other Assets"]
["Invested Capital",null,{"$f":"C42+C45","v":849.10000000000014},991.56000000000006,3725.91,4680.88,5769.380000000001,6148.82,7027.84,7158.08,9302.880000000001,9752.0600000000013]
["Capital Employed",null,{"$f":"C49-C48","v":849.1},991.56000000000006,3725.9100000000003,4680.88,5769.38,6148.8200000000006,7027.84,7158.08,9302.8799999999992,9752.0600000000013]
["Total Liability",null,{"$f":"'Screener Input'!B59+'Screener Input'!B60","v":613.96},{"$f":"'Screener Input'!C59+'Screener Input'!C60","v":599.19000000000005},{"$f":"'Screener Input'!D59+'Screener Input'!D60","v":2776.14},{"$f":"'Screener Input'!E59+'Screener Input'!E60","v":3211.95},{"$f":"'Screener Input'!F59+'Screener Input'!F60","v":4402.8900000000003},{"$f":"'Screener Input'!G59+'Screener Input'!G60","v":4570.46},{"$f":"'Screener Input'!H59+'Screener Input'!H60","v":4840.3},{"$f":"'Screener Input'!I59+'Screener Input'!I60","v":5520.78},{"$f":"'Screener Input'!J59+'Screener Input'!J60","v":7778.53},{"$f":"'Screener Input'!K59+'Screener Input'!K60","v":7781.79}]
["Total Assets",null,{"$f":"'Screener Input'!B66","v":1185.49},{"$f":"'Screener Input'!C66","v":1553.88},{"$f":"'Screener Input'!D66","v":4501.3},{"$f":"'Screener Input'!E66","v":6015.92},{"$f":"'Screener Input'!F66","v":7715.93},{"$f":"'Screener Input'!G66","v":8345.86},{"$f":"'Screener Input'!H66","v":9150.99},{"$f":"'Screener Input'!I66","v":9787.74},{"$f":"'Screener Input'!J66","v":13080.48},{"$f":"'Screener Input'!K66","v":14040.1}]
[]
["Operating Cash Flow",null,{"$f":"'Screener Input'!B82","v":143.27000000000001},{"$f":"'Screener Input'!C82","v":338.5},{"$f":"'Screener Input'!D82","v":206.13},{"$f":"'Screener Input'!E82","v":1098.51},{"$f":"'Screener Input'!F82","v":820.12},{"$f":"'Screener Input'!G82","v":1115.8699999999999},{"$f":"'Screener Input'!H82","v":1026.73},{"$f":"'Screener Input'!I82","v":847.37},{"$f":"'Screener Input'!J82","v":1860.22},{"$f":"'Screener Input'!K82","v":1723.35}]
["Free Cash Flow",null,null,{"$f":"D62-D23","v":183.40999999999997},-2355.0599999999995,390.39999999999986,-164.42000000000041,382.50000000000057,448.81999999999982,547.23,-486.60000000000059,1349.1100000000001]
["Cash from Investing Activity",null,{"$f":"'Screener Input'!B83","v":-141.51},{"$f":"'Screener Input'!C83","v":-50.8},{"$f":"'Screener Input'!D83","v":-2527.41},{"$f":"'Screener Input'!E83","v":-856.35},{"$f":"'Screener Input'!F83","v":-865.18},{"$f":"'Screener Input'!G83","v":-494.24},{"$f":"'Screener Input'!H83","v":-1235.8599999999999},{"$f":"'Screener Input'!I83","v":-621.59},{"$f":"'Screener Input'!J83","v":-2243.25},{"$f":"'Screener Input'!K83","v":-339.79}]
["Cash from Financing Activity",null,{"$f":"'Screener Input'!B84","v":333.98},{"$f":"'Screener Input'!C84","v":-360.86},{"$f":"'Screener Input'!D84","v":2236.89},{"$f":"'Screener Input'!E84","v":-7.26},{"$f":"'Screener Input'!F84","v":281.68},{"$f":"'Screener Input'!G84","v":-620.49},{"$f":"'Screener Input'!H84","v":-12.04},{"$f":"'Screener Input'!I84","v":-202.47},{"$f":"'Screener Input'!J84","v":664.65},{"$f":"'Screener Input'!K84","v":-1384.01}]
["Tax Rate",null,{"$f":"C34/C33","v":0.17187649364305513},0.19129834254143649,0.2116798382650249,0.23130288860010845,0.17487629439494046,0.20430817640603294,0.21805528861554233,0.28804203416561652,0.2247366830060519,0.19849132857254947]
["NOPAT",null,{"$f":"C31*(1-C66)","v":188.87840932989201},348.56658839779004,553.00659345708482,807.03972331651812,917.47980197343406,914.71140656715295,1064.367502242296,921.77909794543507,1427.5078508472955,1772.9371811975216]
[]
["MktCap+Dividend",null,null,{"$f":"D37+C36","v":6410.0912231255124},8518.8214148336174,11692.514363927552,18471.636489495748,19157.503261649101,25968.611663016254,31172.159954098846,38634.993657213032,50437.049481110305]
["Retained Profit",null,{"$f":"C35-C36","v":70.460000000000022},208.59999999999997,369.08999999999969,589.6,668.47000000000025,640.59000000000026,789.21,634.83000000000061,797.06999999999846,952.88000000000147]
[]
["Price",null,{"$f":"'Screener Input'!B90","v":44.144444},{"$f":"'Screener Input'!C90","v":97.211428999999995},{"$f":"'Screener Input'!D90","v":126.28052599999999},{"$f":"'Screener Input'!E90","v":169.57550000000001},{"$f":"'Screener Input'!F90","v":268.88549999999998},{"$f":"'Screener Input'!G90","v":278.71157899999997},{"$f":"'Screener Input'!H90","v":378.66250000000002},{"$f":"'Screener Input'!I90","v":454.88105300000001},{"$f":"'Screener Input'!J90","v":564.25947399999995},{"$f":"'Screener Input'!K90","v":732.74190499999997}]
["BVPS",null,{"$f":"SUM('Screener Input'!B57:B58)/'Screener Input'!B93","v":9.5639815084777595},{"$f":"SUM('Screener Input'!C57:C58)/'Screener Input'!C93","v":14.714205491532793},{"$f":"SUM('Screener Input'!D57:D58)/'Screener Input'!D93","v":25.972638392432611},{"$f":"SUM('Screener Input'!E57:E58)/'Screener Input'!E93","v":41.178571462506142},{"$f":"SUM('Screener Input'!F57:F58)/'Screener Input'!F93","v":48.652571693886387},{"$f":"SUM('Screener Input'!G57:G58)/'Screener Input'!G93","v":55.438228550744682},{"$f":"SUM('Screener Input'!H57:H58)/'Screener Input'!H93","v":63.292085152297354},{"$f":"SUM('Screener Input'!I57:I58)/'Screener Input'!I93","v":62.642020955477761},{"$f":"SUM('Screener Input'!J57:J58)/'Screener Input'!J93","v":77.828759015222701},{"$f":"SUM('Screener Input'!K57:K58)/'Screener Input'!K93","v":91.850183503848456}]
["EPS",null,{"$f":"('Screener Input'!B30/'Screener Input'!B93)","v":2.8993323817802321},{"$f":"('Screener Input'!C30/'Screener Input'!C93)","v":5.2339471900508228},{"$f":"('Screener Input'!D30/'Screener Input'!D93)","v":7.7490648444022527},{"$f":"('Screener Input'!E30/'Screener Input'!E93)","v":10.672472049712535},{"$f":"('Screener Input'!F30/'Screener Input'!F93)","v":11.690867700209761},{"$f":"('Screener Input'!G30/'Screener Input'!G93)","v":11.155926624160951},{"$f":"('Screener Input'!H30/'Screener Input'!H93)","v":13.318869202691909},{"$f":"('Screener Input'!I30/'Screener Input'!I93)","v":12.149906013406019},{"$f":"('Screener Input'!J30/'Screener Input'!J93)","v":19.142943267396259},{"$f":"('Screener Input'!K30/'Screener Input'!K93)","v":23.984068043660201},{"$f":"SUM('Screener Input'!H49:K49)/'Screener Input'!K93","v":29.79083138764566},{"$f":"SUM('Screener Input'!D49:G49)/'Screener Input'!K93","v":19.470305712198734}]
["DPS",null,{"$f":"'Screener Input'!B31/'Screener Input'!B93","v":1.7202549281254063},{"$f":"'Screener Input'!C31/'Screener Input'!C93","v":2.0188896682021187},{"$f":"'Screener Input'!D31/'Screener Input'!D93","v":2.1923390309919295},{"$f":"'Screener Input'!E31/'Screener Input'!E93","v":2.3738143743333526},{"$f":"'Screener Input'!F31/'Screener Input'!F93","v":2.5986885419282997},{"$f":"'Screener Input'!G31/'Screener Input'!G93","v":2.6241897081908094},{"$f":"'Screener Input'!H31/'Screener Input'!H93","v":2.7488741204338778},{"$f":"'Screener Input'!I31/'Screener Input'!I93","v":2.8743370650001383},{"$f":"'Screener Input'!J31/'Screener Input'!J93","v":7.4996393743579759},{"$f":"'Screener Input'!K31/'Screener Input'!K93","v":9.9991099867491293}]
["P/E",null,{"$f":"'Screener Input'!B90/('Screener Input'!B30/'Screener Input'!B93)","v":15.225727232037698},{"$f":"'Screener Input'!C90/('Screener Input'!C30/'Screener Input'!C93)","v":18.573253697474936},{"$f":"'Screener Input'!D90/('Screener Input'!D30/'Screener Input'!D93)","v":16.29622780756857},{"$f":"'Screener Input'!E90/('Screener Input'!E30/'Screener Input'!E93)","v":15.889055432529107},{"$f":"'Screener Input'!F90/('Screener Input'!F30/'Screener Input'!F93)","v":22.999618753291987},{"$f":"'Screener Input'!G90/('Screener Input'!G30/'Screener Input'!G93)","v":24.983274665537895},{"$f":"'Screener Input'!H90/('Screener Input'!H30/'Screener Input'!H93)","v":28.430529216659597},{"$f":"'Screener Input'!I90/('Screener Input'!I30/'Screener Input'!I93)","v":37.439059404911546},{"$f":"'Screener Input'!J90/('Screener Input'!J30/'Screener Input'!J93)","v":29.476108564821971},{"$f":"'Screener Input'!K90/('Screener Input'!K30/'Screener Input'!K93)","v":30.551193553409234}]
["PEG",null,null,{"$f":"D76/(((('Screener Input'!C30/'Screener Input'!C93) - ('Screener Input'!B30/'Screener Input'!B93))/('Screener Input'!B30/'Screener Input'!B93))*100)","v":0.23065918921331149},{"$f":"E76/(((('Screener Input'!D30/'Screener Input'!D93) - ('Screener Input'!C30/'Screener Input'!C93))/('Screener Input'!C30/'Screener Input'!C93))*100)","v":0.33912368112992369},{"$f":"F76/(((('Screener Input'!E30/'Screener Input'!E93) - ('Screener Input'!D30/'Screener Input'!D93))/('Screener Input'!D30/'Screener Input'!D93))*100)","v":0.42117061434108949},{"$f":"G76/(((('Screener Input'!F30/'Screener Input'!F93) - ('Screener Input'!E30/'Screener Input'!E93))/('Screener Input'!E30/'Screener Input'!E93))*100)","v":2.4102890480601249},{"$f":"H76/(((('Screener Input'!G30/'Screener Input'!G93) - ('Screener Input'!F30/'Screener Input'!F93))/('Screener Input'!F30/'Screener Input'!F93))*100)","v":-5.4599688060999787},{"$f":"I76/(((('Screener Input'!H30/'Screener Input'!H93) - ('Screener Input'!G30/'Screener Input'!G93))/('Screener Input'!G30/'Screener Input'!G93))*100)","v":1.4663768746118799},{"$f":"J76/(((('Screener Input'!I30/'Screener Input'!I93) - ('Screener Input'!H30/'Screener Input'!H93))/('Screener Input'!H30/'Screener Input'!H93))*100)","v":-4.2657111862559853},{"$f":"K76/(((('Screener Input'!J30/'Screener Input'!J93) - ('Screener Input'!I30/'Screener Input'!I93))/('Screener Input'!I30/'Screener Input'!I93))*100)","v":0.5121264705106332},{"$f":"L76/(((('Screener Input'!K30/'Screener Input'!K93) - ('Screener Input'!J30/'Screener Input'!J93))/('Screener Input'!J30/'Screener Input'!J93))*100)","v":1.2080658771937205}]
["Price/Book",null,{"$f":"C37/C42","v":4.6156973391122964},6.6066379904738834,4.8620599914405727,4.118052034767687,5.5266451625986246,5.0274257725404201,5.9827780849507288,7.2615960670123094,7.2500124779020974,7.9775769306906019]
["Price/operating CashFlow",null,{"$f":"C37/C62","v":18.412853355362959},18.633061220459417,40.691948842156009,10.511414883731192,22.325996792537371,17.009636661662295,25.118484570448175,36.566010071278008,20.663794420666928,28.970406174665801]
["Price/Free Cashflow",null,null,{"$f":"D37/D63","v":34.389025806256548},-3.5616211114933884,29.577085973175091,-111.36112692796316,49.622335324572738,57.46156958918111,56.621420525371128,-78.995486348567582,37.006729978363737]
["Price/Sales",null,{"$f":"C37/C26","v":1.8890285646319354},3.0896285088591937,2.2719613571459654,2.3791645266821511,2.8557430687773717,2.497614078567203,3.117301349911008,3.6782266549498388,4.1475590135438338,5.0721101301813629]
["EV/EBITDA",null,{"$f":"(C37-C45+C8)/C29","v":11.074196353656751},14.463906610192055,8.8019901184871578,9.252148722025586,13.963190843443888,14.058381931290532,16.506633559475642,20.674251404029729,17.827985242354877,20.016475824904667]
["Dividend Yield",null,{"$f":"C36/C37","v":3.8968775507182876E-2},2.0768027884891176E-2,1.73608639466067E-2,1.3998569217447996E-2,9.6646659709367002E-3,9.4154312411642224E-3,7.2594305494573068E-3,6.3188762117997871E-3,1.3291118217641087E-2,1.3646155513310148E-2]
["Enterprise Value",null,{"$f":"C37+C8-C45","v":2738.7595002228513},6575.5812231255122,6613.9914148336175,10309.854363927552,16601.256489495747,17311.913261649104,23966.971663016255,28847.609954098847,35350.933657213034,47392.609481110303]
[null,null,null,null,null,null,null,null,null,null,null,"Z-Weights"]
["Working Capital/Total Assets",null,{"$f":"C52/C60","v":0.33627445191439825},0.22532628002162328,0.14222780085753003,0.15816533464540755,0.13106521184095762,8.6763976390689501E-2,0.11655460228893263,0.10150555695186021,1.4450540041344048E-2,1.2]
["Retained Profits/Total Assets",null,{"$f":"C70/C60","v":5.9435338973757704E-2},0.13424460061265989,8.1996312176482275E-2,9.8006622428489745E-2,8.6635052417531028E-2,7.6755421250775863E-2,8.6243127792730634E-2,6.485971225226668E-2,6.0935837216982744E-2,1.4]
["EBIT/Total Assets",null,{"$f":"C31/C60","v":0.19239301892044644},0.27738306690349318,0.15584386732721653,0.17451694836367507,0.14410835764450952,0.13774254540574613,0.14874674761965645,0.13227874872033796,0.14076853448803092,3.3]
["Market Cap/Total Liabilities",null,{"$f":"C37/C59","v":4.2967123268989038},10.526362628090441,3.021400727208865,3.5949794872048293,4.1586313738239538,4.1528737286069894,5.3281618211714674,5.6124207003537263,4.9417053938485846,6.4157667427558831]
["Sales/Total Assets",null,{"$f":"C26/C60","v":1.1779854743608129},1.3137694030427058,0.82018305822762305,0.80674942485937318,0.83096140063479063,0.91056763473147162,0.90407158132617338,0.86065629042046476,0.70852980930363418,1]
[]
["RoE",null,{"$f":"SUM('Screener Output.v0'!C35:C35)/SUM('Screener Output.v0'!C40:C41)","v":0.3031511906636572},{"$f":"SUM('Screener Output.v0'!D35:D35)/SUM('Screener Output.v0'!D40:D41)","v":0.35570708816474456},{"$f":"SUM('Screener Output.v0'!E35:E35)/SUM('Screener Output.v0'!E40:E41)","v":0.29835493519441658},{"$f":"SUM('Screener Output.v0'!F35:F35)/SUM('Screener Output.v0'!F40:F41)","v":0.26792012753346145},{"$f":"SUM('Screener Output.v0'!G35:G35)/SUM('Screener Output.v0'!G40:G41)","v":0.25518255137275742},{"$f":"SUM('Screener Output.v0'!H35:H35)/SUM('Screener Output.v0'!H40:H41)","v":0.21701011813317803},{"$f":"SUM('Screener Output.v0'!I35:I35)/SUM('Screener Output.v0'!I40:I41)","v":0.22651362078924722},{"$f":"SUM('Screener Output.v0'!J35:J35)/SUM('Screener Output.v0'!J40:J41)","v":0.19466317940641595},{"$f":"SUM('Screener Output.v0'!K35:K35)/SUM('Screener Output.v0'!K40:K41)","v":0.24669602693348641},{"$f":"SUM('Screener Output.v0'!L35:L35)/SUM('Screener Output.v0'!L40:L41)","v":0.26112161270374928}]
["RoCE",null,{"$f":"C31/(C60-C48)","v":0.26861382640442827},{"$f":"D31/(D60-D48)","v":0.43468877324619787},0.18827615267142783,0.22429115892738119,0.19272954806235684,0.18695944913007703,0.1936839768691376,0.18087392149850245,0.19793010336583927,0.2268238710590379,{"$f":"M31/(L60-L48)","v":0.25841104341031534}]
["Sales Type",null,{"$f":"C4","v":"2009-03-01"},{"$f":"D4","v":"2010-03-01"},"2011-03-01","2012-03-01","2013-03-01","2014-03-01","2015-03-01","2016-03-01","2017-03-01","2018-03-01"]
["Cash Sales",null,{"$f":"(C26-C7)/C26","v":0.9568990827001983},{"$f":"(D26-D7)/D26","v":0.9435398542205502},0.89599094230868193,0.90263818318930888,0.88633797281194826,0.90367091389267928,0.90274804639103612,0.86728087294690803,0.88899978528060808,0.87346684587540524]
["Credit Sales",null,{"$f":"1-C95","v":4.31009172998017E-2},{"$f":"1-D95","v":5.64601457794498E-2},0.10400905769131807,9.7361816810691115E-2,0.11366202718805174,9.6329086107320716E-2,9.7251953608963881E-2,0.13271912705309197,0.11100021471939192,0.12653315412459476]
[]
[]
["Liability Dist.",null,{"$f":"C4","v":"2009-03-01"},"2010-03-01","2011-03-01","2012-03-01","2013-03-01","2014-03-01","2015-03-01","2016-03-01","2017-03-01","2018-03-01"]
["Equity",null,{"$f":"C42/(C10+C42+C45)","v":0.48210444626272686},0.61439107266970416,0.38325816986203987,0.46609163685687316,0.42937662731517784,0.452368000421766,0.47106269376318843,0.43594946330817941,0.40533298472227319,0.44574540067378438]
["Float",null,{"$f":"C10/(C10+C42+C45)","v":0.28375608398215085},0.36188122634952508,0.17225912514162578,0.22191784465218953,0.25227678322639008,0.26324908397696578,0.23201314830417258,0.26866876316698235,0.28879674140398515,0.30541377910413742]
["Debt",null,{"$f":"C45/(C10+C42+C45)","v":0.23413946975512234},2.3727700980770712E-2,0.44448270499633447,0.3119905184909374,0.31834658945843208,0.28438291560126816,0.29692415793263899,0.29538177352483819,0.3058702738737416,0.24884082022207818]
[]
[]
[null,null,null,{"$f":"D4","v":"2010-03-01"},"2011-03-01","2012-03-01","2013-03-01","2014-03-01","2015-03-01","2016-03-01","2017-03-01","2018-03-01"]
["∆ WC",null,null,{"$f":"D11-C11","v":-48.519999999999982},290.07999999999993,311.3000000000003,59.779999999999973,-287.1700000000003,342.4699999999998,-73.079999999999472,-804.49000000000024,166.87999999999965]
["NP",null,null,{"$f":"C35","v":173.26000000000002},339.59,514.7099999999997,751.24,845.43000000000029,819.3000000000003,976.43000000000006,830.62000000000057,1307.9699999999984]
[]
[]
[]
[null,null,{"$f":"C4","v":"2009-03-01"},"2010-03-01","2011-03-01","2012-03-01","2013-03-01","2014-03-01","2015-03-01","2016-03-01","2017-03-01","2018-03-01"]
["Receivable Days",null,{"$f":"(C7/C26)*365","v":15.7318348144276},20.607953209499176,37.963306057331074,35.537063135902279,41.486639923638883,35.160116429172028,35.496963067271842,48.442481374378559,40.515078372578067,46.184601255477091]
["Inventory Turnover ratio",null,{"$f":"C27/C54","v":4.5418880993610795},{"$f":"D27/AVERAGE(C54:D54)","v":4.5693447557304934},4.9795408047283471,4.1327698394532915,3.4707700709994538,3.2916279200834104,3.5345986702819148,3.328840664399312,3.1372541809463574,2.8214378875132931]
["Inventory/Sales",null,{"$f":"C6/C26","v":0.11992209038374782},{"$f":"D6/D26","v":0.12953111529116701},0.11902033917586928,0.16151969571470368,0.16331079099887078,0.1423954565252577,0.12954074324773515,0.15515178278892863,0.15240760861941904,0.16028413321995638]
[]
[null,null,{"$f":"C4","v":"2009-03-01"},"2010-03-01","2011-03-01","2012-03-01","2013-03-01","2014-03-01","2015-03-01","2016-03-01","2017-03-01","2018-03-01","TTM"]
["Debt/PAT",null,{"$f":"C45/C35","v":1.6020431721112776},0.1085721016519921,3.8871403314487791,2.4984159522922105,2.9054327383698229,2.896887586964481,2.782739162049507,3.480677084587414,3.058885142625599,2.1379223830912122,{"$f":"L45/M35","v":1.721203253474429}]
["CFO/PAT",null,{"$f":"C62/C35","v":0.82690753780445569},0.99679024706263442,0.40047793903363083,1.4622623928438314,0.97006257170907084,1.3619797388014152,1.0515141894452238,1.0201656593869632,1.4222191640481068,1.0545655925295858,{"$f":"L62/M35","v":0.84901198622544749}]
["PAT/WC",null,{"$f":"C35/C11","v":0.43461683180734989},0.96989689543883695,0.80397057215601098,0.78952401971603015,0.83599165422381327,1.1314423023808213,0.91546892432893645,0.83604593813851935,6.9197439424399461,4.5916830570385025,{"$f":"M35/L11","v":5.7033717336330483}]
["Sales/NFAT",null,{"$f":"C26/C50","v":3.1706702388520571},{"$f":"D26/AVERAGE(C50:D50)","v":4.0263897517824923},2.0222497925379388,1.4338906886358904,1.5661351881140959,1.5803552304048278,1.5503953689501149,1.4672732783156073,1.3226361644891289,1.2005532419110021,{"$f":"M26/AVERAGE(K50:L50)","v":1.2555749550704391}]
["C Liability/C Asset",null,{"$f":"C10/C9","v":0.45764856334349152},0.61627486437613022,0.5477465385702176,0.58386652380223469,0.65809847726719495,0.75211217461556368,0.66561851436167219,0.72578984701242277,0.95234733854011733,0.92336248961011558]
[]
[]
[]
["Profit Margin",null,{"$f":"C4","v":"2009-03-01"},"2010-03-01","2011-03-01","2012-03-01","2013-03-01","2014-03-01","2015-03-01","2016-03-01","2017-03-01","2018-03-01","TTM"]
["OP Margin",null,{"$f":"C29/C26","v":0.17709399995703515},0.22269574418057841,0.2035326079596087,0.22959858571622843,0.18543305612916511,0.16204156342481782,0.17550268035754218,0.16564101103054654,0.21395222871175901,0.24053795131089578,0.26077212928595089]
["NP Margin",null,{"$f":"C35/C25","v":0.12061931746982081},0.16281511597802215,0.13597709014152218,0.1471429886534352,0.12793417994285994,0.10684593866758828,0.11661288434850943,0.10158824119349252,0.13967770872044577,0.16105230272526866,0.18687425255546622]
[]
["Gross Profit",null,{"$f":"C125","v":"2009-03-01"},{"$f":"D125","v":"2010-03-01"},"2011-03-01","2012-03-01","2013-03-01","2014-03-01","2015-03-01","2016-03-01","2017-03-01","2018-03-01","TTM"]
["Depreciation",null,{"$f":"C30/C29","v":7.7756661679673281E-2},{"$f":"D30/D29","v":5.1911486516211344E-2},6.6434217880812357E-2,5.7828989877234539E-2,6.476411563338462E-2,6.6467440292992674E-2,6.2522383536736545E-2,7.2118623417948294E-2,7.1395790991936062E-2,6.5752128666035914E-2,{"$f":"M30/M29","v":6.1259308099490026E-2}]
["Interest",null,{"$f":"C32/C29","v":7.626056366503578E-2},{"$f":"D32/D29","v":2.4415995776692623E-2},6.4650927577120668E-2,6.5142867398951823E-2,7.3444189313079805E-2,9.7374597013228495E-2,7.7453924350533068E-2,9.1762581163014001E-2,7.7760238843304533E-2,7.3117988917421231E-2,{"$f":"M32/M29","v":7.0713617856650604E-2}]
["Taxes",null,{"$f":"C34/C29","v":0.14540455299017427},{"$f":"D34/D29","v":0.17669702168844309},0.18393175587554239,0.20285914279560627,0.15070693817129685,0.17083390854534969,0.18753271439984573,0.24083735863660463,0.19121585161052823,0.17092681443438293,{"$f":"M34/M29","v":0.11189462430480276}]
["Net Profit",null,{"$f":"C35/C29","v":0.70057822166511663},{"$f":"D35/D29","v":0.74697549601865287},0.68498309866652451,0.67416899992820722,0.71108475688223871,0.6653240541484291,0.67249097771288469,0.59528143678243317,0.6596281185542312,0.69020306798216002,{"$f":"M35/M29","v":0.75613244973905647}]
["EBITDA",null,{"$f":"SUM(C130:C133)","v":1},{"$f":"SUM(D130:D133)","v":1},1,0.99999999999999989,1,1,1,1,1,1,0.99999999999999989]
[]
[]
["SSGR",null,{"$f":"C4","v":"2009-03-01"},"2010-03-01","2011-03-01","2012-03-01","2013-03-01","2014-03-01","2015-03-01","2016-03-01","2017-03-01","2018-03-01","TTM"]
["Net fixed asset turnover (Sales/average net fixed assets over the year)",null,{"$f":"C26/C50","v":3.1706702388520571},{"$f":"D26/AVERAGE(C50:D50)","v":4.0263897517824923},2.0222497925379388,1.4338906886358904,1.5661351881140959,1.5803552304048278,1.5503953689501149,1.4672732783156073,1.3226361644891289,1.2005532419110021,{"$f":"M26/AVERAGE(K50:L50)","v":1.2555749550704391}]
["Net profit margin as % of sales",null,{"$f":"C35/C26","v":0.12406819955746194},0.1663482639705306,0.13941639647985171,0.1547882489172405,0.13185861963553791,0.1078101499183496,0.11802396910487542,9.8603019036358625E-2,0.14112890608562215,0.16602003196092369]
["Dividend paid as % of net profit after tax",null,{"$f":"C36/C35","v":0.59332794643887787},0.38572985070231758,0.28291659381010686,0.21516426175390019,0.20931360372828023,0.21812522885389959,0.19173929518757105,0.23571548963424893,0.39060528911213604,0.41690633834706053]
["Depreciation rate as a % of net fixed assets",null,{"$f":"C30/C50","v":4.3660884569975481E-2},4.1144371415122297E-2,1.6220009877570118E-2,1.745494732907343E-2,1.7126105968336719E-2,1.5982082884233875E-2,1.635395743071006E-2,1.6965611886549742E-2,1.7514775037146366E-2,1.872279013830427E-2]
["SSGR",null,null,null,{"$f":"AVERAGE(C138:E138)*AVERAGE(C139:E139)*(1-AVERAGE(C140:E140))-AVERAGE(C141:E141)","v":0.22141314638001924},{"$f":"AVERAGE(D138:F138)*AVERAGE(D139:F139)*(1-AVERAGE(D140:F140))-AVERAGE(D141:F141)","v":0.24515660104051201},{"$f":"AVERAGE(E138:G138)*AVERAGE(E139:G139)*(1-AVERAGE(E140:G140))-AVERAGE(E141:G141)","v":0.16476015571790065},0.14089594072491424,0.13165634376394816,0.1136495386946528,0.10853855372695637,{"$f":"AVERAGE(J138:L138)*AVERAGE(J139:L139)*(1-AVERAGE(J140:L140))-AVERAGE(J141:L141)","v":9.960951202234905E-2}]
[]
[]
[]
["P/L - Quaterly",null,{"$f":"'Screener Input'!B41","v":"2016-06-30"},{"$f":"'Screener Input'!C41","v":"2016-09-30"},{"$f":"'Screener Input'!D41","v":"2016-12-31"},{"$f":"'Screener Input'!E41","v":"2017-03-31"},{"$f":"'Screener Input'!F41","v":"2017-06-30"},{"$f":"'Screener Input'!G41","v":"2017-09-30"},{"$f":"'Screener Input'!H41","v":"2017-12-31"},{"$f":"'Screener Input'!I41","v":"2018-03-31"},{"$f":"'Screener Input'!J41","v":"2018-06-30"},{"$f":"'Screener Input'!K41","v":"2018-09-30"}]
["Other Income",null,{"$f":"'Screener Input'!B44","v":5.7},{"$f":"'Screener Input'!C44","v":16.53},{"$f":"'Screener Input'!D44","v":22.08},{"$f":"'Screener Input'!E44","v":32.950000000000003},{"$f":"'Screener Input'!F44","v":16.25},{"$f":"'Screener Input'!G44","v":14.91},{"$f":"'Screener Input'!H44","v":33.94},{"$f":"'Screener Input'!I44","v":223.09},{"$f":"'Screener Input'!J44","v":24.76},{"$f":"'Screener Input'!K44","v":285.83}]
["Net Profit",null,{"$f":"'Screener Input'!B49","v":245.83},{"$f":"'Screener Input'!C49","v":318.74},{"$f":"'Screener Input'!D49","v":351.93},{"$f":"'Screener Input'!E49","v":387.58},{"$f":"'Screener Input'!F49","v":225.17},{"$f":"'Screener Input'!G49","v":361.95},{"$f":"'Screener Input'!H49","v":429.87},{"$f":"'Screener Input'!I49","v":617.19000000000005},{"$f":"'Screener Input'!J49","v":405.04},{"$f":"'Screener Input'!K49","v":577.73}]
["Oth Inc % Net Profit",null,{"$f":"C147/C148","v":2.3186755074645078E-2},{"$f":"D147/D148","v":5.1860450523938006E-2},6.2739749381979362E-2,8.5014706641209567E-2,7.2167695518941255E-2,4.1193535018648988E-2,7.8954102403052076E-2,0.3614608143359419,6.1129764961485283E-2,0.49474668097554214]
[]
[]
[]
[]
[]
["Assets",null,{"$f":"C4","v":"2009-03-01"},"2010-03-01","2011-03-01","2012-03-01","2013-03-01","2014-03-01","2015-03-01","2016-03-01","2017-03-01","2018-03-01"]
["Tangible assets (Non-current)",null,{"$f":"'Screener Input'!B62","v":440.44},{"$f":"'Screener Input'!C62","v":573.59},{"$f":"'Screener Input'!D62","v":3077.68},{"$f":"'Screener Input'!E62","v":3691.79},{"$f":"'Screener Input'!F62","v":4496.0600000000004},{"$f":"'Screener Input'!G62","v":5121.3599999999997},{"$f":"'Screener Input'!H62","v":5550.95},{"$f":"'Screener Input'!I62","v":5931.41},{"$f":"'Screener Input'!J62","v":8082.89},{"$f":"'Screener Input'!K62","v":8315}]
["Tangible assets (Non-current)",null,{"$f":"'Screener Input'!B62/'Screener Input'!B66","v":0.37152569823448534},{"$f":"'Screener Input'!C62/'Screener Input'!C66","v":0.36913403866450434},{"$f":"'Screener Input'!D62/'Screener Input'!D66","v":0.6837313664941238},{"$f":"'Screener Input'!E62/'Screener Input'!E66","v":0.61367006210188968},{"$f":"'Screener Input'!F62/'Screener Input'!F66","v":0.58269839150951341},{"$f":"'Screener Input'!G62/'Screener Input'!G66","v":0.61364077518673921},{"$f":"'Screener Input'!H62/'Screener Input'!H66","v":0.60659557053389856},{"$f":"'Screener Input'!I62/'Screener Input'!I66","v":0.60600404179105694},{"$f":"'Screener Input'!J62/'Screener Input'!J66","v":0.61793527454649988},{"$f":"'Screener Input'!K62/'Screener Input'!K66","v":0.59223224905805516}]
["Investments (Current)",null,{"$f":"'Screener Input'!B64/'Screener Input'!B66","v":6.3349332343587885E-3},{"$f":"'Screener Input'!C64/'Screener Input'!C66","v":4.3117872680001029E-2},{"$f":"'Screener Input'!D64/'Screener Input'!D66","v":0},{"$f":"'Screener Input'!E64/'Screener Input'!E66","v":0},{"$f":"'Screener Input'!F64/'Screener Input'!F66","v":1.5705170990405564E-2},{"$f":"'Screener Input'!G64/'Screener Input'!G66","v":1.632785596691054E-2},{"$f":"'Screener Input'!H64/'Screener Input'!H66","v":2.0291793565504933E-2},{"$f":"'Screener Input'!I64/'Screener Input'!I66","v":1.9360955644510378E-2},{"$f":"'Screener Input'!J64/'Screener Input'!J66","v":7.1368940589336169E-2},{"$f":"'Screener Input'!K64/'Screener Input'!K66","v":7.1030833113724254E-2}]
["Inventories (Current)",null,{"$f":"'Screener Input'!B68/'Screener Input'!B66","v":0.14126648052703944},{"$f":"'Screener Input'!C68/'Screener Input'!C66","v":0.17017401601153243},{"$f":"'Screener Input'!D68/'Screener Input'!D66","v":9.7618465776553448E-2},{"$f":"'Screener Input'!E68/'Screener Input'!E66","v":0.13030592162129814},{"$f":"'Screener Input'!F68/'Screener Input'!F66","v":0.13570496362719722},{"$f":"'Screener Input'!G68/'Screener Input'!G66","v":0.129660694044712},{"$f":"'Screener Input'!H68/'Screener Input'!H66","v":0.11711410459414774},{"$f":"'Screener Input'!I68/'Screener Input'!I66","v":0.13353235782724102},{"$f":"'Screener Input'!J68/'Screener Input'!J66","v":0.10798533387153988},{"$f":"'Screener Input'!K68/'Screener Input'!K66","v":0.11237241899986468}]
["Receivables (Current)",null,{"$f":"'Screener Input'!B67/'Screener Input'!B66","v":5.0772254510793001E-2},{"$f":"'Screener Input'!C67/'Screener Input'!C66","v":7.417561201637192E-2},{"$f":"'Screener Input'!D67/'Screener Input'!D66","v":8.5306467020638474E-2},{"$f":"'Screener Input'!E67/'Screener Input'!E66","v":7.8546589715288759E-2},{"$f":"'Screener Input'!F67/'Screener Input'!F66","v":9.4448757311173109E-2},{"$f":"'Screener Input'!G67/'Screener Input'!G66","v":8.7714148092587207E-2},{"$f":"'Screener Input'!H67/'Screener Input'!H66","v":8.7922727486315688E-2},{"$f":"'Screener Input'!I67/'Screener Input'!I66","v":0.11422555155735645},{"$f":"'Screener Input'!J67/'Screener Input'!J66","v":7.8646960967793236E-2},{"$f":"'Screener Input'!K67/'Screener Input'!K66","v":8.8710194371834958E-2}]
["Cash (Current)",null,{"$f":"'Screener Input'!B69/'Screener Input'!B66","v":0.31912542492977586},{"$f":"'Screener Input'!C69/'Screener Input'!C66","v":0.196385821298942},{"$f":"'Screener Input'!D69/'Screener Input'!D66","v":5.0409881589762957E-2},{"$f":"'Screener Input'!E69/'Screener Input'!E66","v":0.10636278407957553},{"$f":"'Screener Input'!F69/'Screener Input'!F66","v":9.689045908918302E-2},{"$f":"'Screener Input'!G69/'Screener Input'!G66","v":8.4447857979884633E-2},{"$f":"'Screener Input'!H69/'Screener Input'!H66","v":9.7718388939338804E-2},{"$f":"'Screener Input'!I69/'Screener Input'!I66","v":7.7013692639976136E-2},{"$f":"'Screener Input'!J69/'Screener Input'!J66","v":6.9772668892884665E-2},{"$f":"'Screener Input'!K69/'Screener Input'!K66","v":6.8390538528927861E-2}]
["Rest",null,{"$f":"('Screener Input'!B66-'Screener Input'!B62-'Screener Input'!B64-'Screener Input'!B68-'Screener Input'!B67-'Screener Input'!B69)/'Screener Input'!B66","v":0.11097520856354752},{"$f":"('Screener Input'!C66-'Screener Input'!C62-'Screener Input'!C64-'Screener Input'!C68-'Screener Input'!C67-'Screener Input'!C69)/'Screener Input'!C66","v":0.14701263932864836},{"$f":"('Screener Input'!D66-'Screener Input'!D62-'Screener Input'!D64-'Screener Input'!D68-'Screener Input'!D67-'Screener Input'!D69)/'Screener Input'!D66","v":8.2933819118921268E-2},{"$f":"('Screener Input'!E66-'Screener Input'!E62-'Screener Input'!E64-'Screener Input'!E68-'Screener Input'!E67-'Screener Input'!E69)/'Screener Input'!E66","v":7.1114642481947946E-2},{"$f":"('Screener Input'!F66-'Screener Input'!F62-'Screener Input'!F64-'Screener Input'!F68-'Screener Input'!F67-'Screener Input'!F69)/'Screener Input'!F66","v":7.4552257472527653E-2},{"$f":"('Screener Input'!G66-'Screener Input'!G62-'Screener Input'!G64-'Screener Input'!G68-'Screener Input'!G67-'Screener Input'!G69)/'Screener Input'!G66","v":6.8208668729166422E-2},{"$f":"('Screener Input'!H66-'Screener Input'!H62-'Screener Input'!H64-'Screener Input'!H68-'Screener Input'!H67-'Screener Input'!H69)/'Screener Input'!H66","v":7.0357414880794306E-2},{"$f":"('Screener Input'!I66-'Screener Input'!I62-'Screener Input'!I64-'Screener Input'!I68-'Screener Input'!I67-'Screener Input'!I69)/'Screener Input'!I66","v":4.9863400539859042E-2},{"$f":"('Screener Input'!J66-'Screener Input'!J62-'Screener Input'!J64-'Screener Input'!J68-'Screener Input'!J67-'Screener Input'!J69)/'Screener Input'!J66","v":5.4290821131946179E-2},{"$f":"('Screener Input'!K66-'Screener Input'!K62-'Screener Input'!K64-'Screener Input'!K68-'Screener Input'!K67-'Screener Input'!K69)/'Screener Input'!K66","v":6.726376592759313E-2}]
[]
["Liabilities",null,{"$f":"C4","v":"2009-03-01"},"2010-03-01","2011-03-01","2012-03-01","2013-03-01","2014-03-01","2015-03-01","2016-03-01","2017-03-01","2018-03-01"]
["Shareholder Funds",null,{"$f":"SUM('Screener Input'!B57:B58)/'Screener Input'!B61","v":0.48210444626272686},{"$f":"SUM('Screener Input'!C57:C58)/'Screener Input'!C61","v":0.61439107266970416},{"$f":"SUM('Screener Input'!D57:D58)/'Screener Input'!D61","v":0.38325816986203981},{"$f":"SUM('Screener Input'!E57:E58)/'Screener Input'!E61","v":0.46609163685687316},{"$f":"SUM('Screener Input'!F57:F58)/'Screener Input'!F61","v":0.42937662731517784},{"$f":"SUM('Screener Input'!G57:G58)/'Screener Input'!G61","v":0.452368000421766},{"$f":"SUM('Screener Input'!H57:H58)/'Screener Input'!H61","v":0.47106269376318843},{"$f":"SUM('Screener Input'!I57:I58)/'Screener Input'!I61","v":0.43594946330817941},{"$f":"SUM('Screener Input'!J57:J58)/'Screener Input'!J61","v":0.40533298472227325},{"$f":"SUM('Screener Input'!K57:K58)/'Screener Input'!K61","v":0.44574540067378438}]
["Rest",null,{"$f":"1-C165","v":0.51789555373727314},{"$f":"1-D165","v":0.38560892733029584},0.61674183013796013,0.53390836314312684,0.57062337268482222,0.54763199957823394,0.52893730623681157,0.56405053669182059,0.5946670152777267,0.55425459932621557]
[]
[]
[]
["P/L - Annual",null,{"$f":"C4","v":"2009-03-01"},"2010-03-01","2011-03-01","2012-03-01","2013-03-01","2014-03-01","2015-03-01","2016-03-01","2017-03-01","2018-03-01"]
["Raw Mat + Invt change",null,{"$f":"IF(('Screener Input'!B18-'Screener Input'!B19)/('Screener Input'!B$17+'Screener Input'!B$25)<0, 0, ('Screener Input'!B18-'Screener Input'!B19)/('Screener Input'!B$17+'Screener Input'!B$25))","v":0.53573467370267747},{"$f":"IF(('Screener Input'!C18-'Screener Input'!C19)/('Screener Input'!C$17+'Screener Input'!C$25)<0, 0, ('Screener Input'!C18-'Screener Input'!C19)/('Screener Input'!C$17+'Screener Input'!C$25))","v":0.4536998858918177},{"$f":"IF(('Screener Input'!D18-'Screener Input'!D19)/('Screener Input'!D$17+'Screener Input'!D$25)<0, 0, ('Screener Input'!D18-'Screener Input'!D19)/('Screener Input'!D$17+'Screener Input'!D$25))","v":0.45100613694663788},{"$f":"IF(('Screener Input'!E18-'Screener Input'!E19)/('Screener Input'!E$17+'Screener Input'!E$25)<0, 0, ('Screener Input'!E18-'Screener Input'!E19)/('Screener Input'!E$17+'Screener Input'!E$25))","v":0.45354724601459995},{"$f":"IF(('Screener Input'!F18-'Screener Input'!F19)/('Screener Input'!F$17+'Screener Input'!F$25)<0, 0, ('Screener Input'!F18-'Screener Input'!F19)/('Screener Input'!F$17+'Screener Input'!F$25))","v":0.45724178005907701},{"$f":"IF(('Screener Input'!G18-'Screener Input'!G19)/('Screener Input'!G$17+'Screener Input'!G$25)<0, 0, ('Screener Input'!G18-'Screener Input'!G19)/('Screener Input'!G$17+'Screener Input'!G$25))","v":0.46357026884279579},{"$f":"IF(('Screener Input'!H18-'Screener Input'!H19)/('Screener Input'!H$17+'Screener Input'!H$25)<0, 0, ('Screener Input'!H18-'Screener Input'!H19)/('Screener Input'!H$17+'Screener Input'!H$25))","v":0.45878427279219802},{"$f":"IF(('Screener Input'!I18-'Screener Input'!I19)/('Screener Input'!I$17+'Screener Input'!I$25)<0, 0, ('Screener Input'!I18-'Screener Input'!I19)/('Screener Input'!I$17+'Screener Input'!I$25))","v":0.47297935261987639},{"$f":"IF(('Screener Input'!J18-'Screener Input'!J19)/('Screener Input'!J$17+'Screener Input'!J$25)<0, 0, ('Screener Input'!J18-'Screener Input'!J19)/('Screener Input'!J$17+'Screener Input'!J$25))","v":0.44131052305589374},{"$f":"IF(('Screener Input'!K18-'Screener Input'!K19)/('Screener Input'!K$17+'Screener Input'!K$25)<0, 0, ('Screener Input'!K18-'Screener Input'!K19)/('Screener Input'!K$17+'Screener Input'!K$25))","v":0.42124828395695618}]
["Power and Fuel",null,{"$f":"IF(('Screener Input'!B20)/('Screener Input'!B$17+'Screener Input'!B$25)<0, 0, ('Screener Input'!B20)/('Screener Input'!B$17+'Screener Input'!B$25))","v":2.4790799348379997E-2},{"$f":"IF(('Screener Input'!C20)/('Screener Input'!C$17+'Screener Input'!C$25)<0, 0, ('Screener Input'!C20)/('Screener Input'!C$17+'Screener Input'!C$25))","v":1.6042267972038698E-2},{"$f":"IF(('Screener Input'!D20)/('Screener Input'!D$17+'Screener Input'!D$25)<0, 0, ('Screener Input'!D20)/('Screener Input'!D$17+'Screener Input'!D$25))","v":1.4104674171195186E-2},{"$f":"IF(('Screener Input'!E20)/('Screener Input'!E$17+'Screener Input'!E$25)<0, 0, ('Screener Input'!E20)/('Screener Input'!E$17+'Screener Input'!E$25))","v":1.566151079911703E-2},{"$f":"IF(('Screener Input'!F20)/('Screener Input'!F$17+'Screener Input'!F$25)<0, 0, ('Screener Input'!F20)/('Screener Input'!F$17+'Screener Input'!F$25))","v":1.5519829548205896E-2},{"$f":"IF(('Screener Input'!G20)/('Screener Input'!G$17+'Screener Input'!G$25)<0, 0, ('Screener Input'!G20)/('Screener Input'!G$17+'Screener Input'!G$25))","v":1.3458441194306245E-2},{"$f":"IF(('Screener Input'!H20)/('Screener Input'!H$17+'Screener Input'!H$25)<0, 0, ('Screener Input'!H20)/('Screener Input'!H$17+'Screener Input'!H$25))","v":1.3127503505205857E-2},{"$f":"IF(('Screener Input'!I20)/('Screener Input'!I$17+'Screener Input'!I$25)<0, 0, ('Screener Input'!I20)/('Screener Input'!I$17+'Screener Input'!I$25))","v":1.3452229237042491E-2},{"$f":"IF(('Screener Input'!J20)/('Screener Input'!J$17+'Screener Input'!J$25)<0, 0, ('Screener Input'!J20)/('Screener Input'!J$17+'Screener Input'!J$25))","v":9.5064180602720989E-3},{"$f":"IF(('Screener Input'!K20)/('Screener Input'!K$17+'Screener Input'!K$25)<0, 0, ('Screener Input'!K20)/('Screener Input'!K$17+'Screener Input'!K$25))","v":9.9646295564453733E-3}]
["Other Mfr. Exp",null,{"$f":"IF(('Screener Input'!B21)/('Screener Input'!B$17+'Screener Input'!B$25)<0, 0, ('Screener Input'!B21)/('Screener Input'!B$17+'Screener Input'!B$25))","v":1.8023976274348728E-2},{"$f":"IF(('Screener Input'!C21)/('Screener Input'!C$17+'Screener Input'!C$25)<0, 0, ('Screener Input'!C21)/('Screener Input'!C$17+'Screener Input'!C$25))","v":1.5783367054378782E-2},{"$f":"IF(('Screener Input'!D21)/('Screener Input'!D$17+'Screener Input'!D$25)<0, 0, ('Screener Input'!D21)/('Screener Input'!D$17+'Screener Input'!D$25))","v":2.2738140211926758E-2},{"$f":"IF(('Screener Input'!E21)/('Screener Input'!E$17+'Screener Input'!E$25)<0, 0, ('Screener Input'!E21)/('Screener Input'!E$17+'Screener Input'!E$25))","v":2.3488348862307586E-2},{"$f":"IF(('Screener Input'!F21)/('Screener Input'!F$17+'Screener Input'!F$25)<0, 0, ('Screener Input'!F21)/('Screener Input'!F$17+'Screener Input'!F$25))","v":2.5354401723887462E-2},{"$f":"IF(('Screener Input'!G21)/('Screener Input'!G$17+'Screener Input'!G$25)<0, 0, ('Screener Input'!G21)/('Screener Input'!G$17+'Screener Input'!G$25))","v":2.5541043681248817E-2},{"$f":"IF(('Screener Input'!H21)/('Screener Input'!H$17+'Screener Input'!H$25)<0, 0, ('Screener Input'!H21)/('Screener Input'!H$17+'Screener Input'!H$25))","v":2.6748243814237224E-2},{"$f":"IF(('Screener Input'!I21)/('Screener Input'!I$17+'Screener Input'!I$25)<0, 0, ('Screener Input'!I21)/('Screener Input'!I$17+'Screener Input'!I$25))","v":2.8891900287903879E-2},{"$f":"IF(('Screener Input'!J21)/('Screener Input'!J$17+'Screener Input'!J$25)<0, 0, ('Screener Input'!J21)/('Screener Input'!J$17+'Screener Input'!J$25))","v":3.2341257128211696E-2},{"$f":"IF(('Screener Input'!K21)/('Screener Input'!K$17+'Screener Input'!K$25)<0, 0, ('Screener Input'!K21)/('Screener Input'!K$17+'Screener Input'!K$25))","v":3.141356612715817E-2}]
["Employee Cost",null,{"$f":"IF(('Screener Input'!B22)/('Screener Input'!B$17+'Screener Input'!B$25)<0, 0, ('Screener Input'!B22)/('Screener Input'!B$17+'Screener Input'!B$25))","v":6.0240041213572633E-2},{"$f":"IF(('Screener Input'!C22)/('Screener Input'!C$17+'Screener Input'!C$25)<0, 0, ('Screener Input'!C22)/('Screener Input'!C$17+'Screener Input'!C$25))","v":7.2779924631066195E-2},{"$f":"IF(('Screener Input'!D22)/('Screener Input'!D$17+'Screener Input'!D$25)<0, 0, ('Screener Input'!D22)/('Screener Input'!D$17+'Screener Input'!D$25))","v":7.5159764032684595E-2},{"$f":"IF(('Screener Input'!E22)/('Screener Input'!E$17+'Screener Input'!E$25)<0, 0, ('Screener Input'!E22)/('Screener Input'!E$17+'Screener Input'!E$25))","v":7.8636610250494079E-2},{"$f":"IF(('Screener Input'!F22)/('Screener Input'!F$17+'Screener Input'!F$25)<0, 0, ('Screener Input'!F22)/('Screener Input'!F$17+'Screener Input'!F$25))","v":8.9384291317611719E-2},{"$f":"IF(('Screener Input'!G22)/('Screener Input'!G$17+'Screener Input'!G$25)<0, 0, ('Screener Input'!G22)/('Screener Input'!G$17+'Screener Input'!G$25))","v":9.6821225735356439E-2},{"$f":"IF(('Screener Input'!H22)/('Screener Input'!H$17+'Screener Input'!H$25)<0, 0, ('Screener Input'!H22)/('Screener Input'!H$17+'Screener Input'!H$25))","v":9.2789427295939697E-2},{"$f":"IF(('Screener Input'!I22)/('Screener Input'!I$17+'Screener Input'!I$25)<0, 0, ('Screener Input'!I22)/('Screener Input'!I$17+'Screener Input'!I$25))","v":0.11547098090343602},{"$f":"IF(('Screener Input'!J22)/('Screener Input'!J$17+'Screener Input'!J$25)<0, 0, ('Screener Input'!J22)/('Screener Input'!J$17+'Screener Input'!J$25))","v":0.10555733538369534},{"$f":"IF(('Screener Input'!K22)/('Screener Input'!K$17+'Screener Input'!K$25)<0, 0, ('Screener Input'!K22)/('Screener Input'!K$17+'Screener Input'!K$25))","v":0.10421025555613592}]
["Selling and admin",null,{"$f":"IF(('Screener Input'!B23)/('Screener Input'!B$17+'Screener Input'!B$25)<0, 0, ('Screener Input'!B23)/('Screener Input'!B$17+'Screener Input'!B$25))","v":0.17061862129460742},{"$f":"IF(('Screener Input'!C23)/('Screener Input'!C$17+'Screener Input'!C$25)<0, 0, ('Screener Input'!C23)/('Screener Input'!C$17+'Screener Input'!C$25))","v":0.15498576044952869},{"$f":"IF(('Screener Input'!D23)/('Screener Input'!D$17+'Screener Input'!D$25)<0, 0, ('Screener Input'!D23)/('Screener Input'!D$17+'Screener Input'!D$25))","v":0.2045058872946976},{"$f":"IF(('Screener Input'!E23)/('Screener Input'!E$17+'Screener Input'!E$25)<0, 0, ('Screener Input'!E23)/('Screener Input'!E$17+'Screener Input'!E$25))","v":0.1948208895879158},{"$f":"IF(('Screener Input'!F23)/('Screener Input'!F$17+'Screener Input'!F$25)<0, 0, ('Screener Input'!F23)/('Screener Input'!F$17+'Screener Input'!F$25))","v":0.21263498135683501},{"$f":"IF(('Screener Input'!G23)/('Screener Input'!G$17+'Screener Input'!G$25)<0, 0, ('Screener Input'!G23)/('Screener Input'!G$17+'Screener Input'!G$25))","v":0.22150090309791928},{"$f":"IF(('Screener Input'!H23)/('Screener Input'!H$17+'Screener Input'!H$25)<0, 0, ('Screener Input'!H23)/('Screener Input'!H$17+'Screener Input'!H$25))","v":0.21722124954916006},{"$f":"IF(('Screener Input'!I23)/('Screener Input'!I$17+'Screener Input'!I$25)<0, 0, ('Screener Input'!I23)/('Screener Input'!I$17+'Screener Input'!I$25))","v":0.17917307744051741},{"$f":"IF(('Screener Input'!J23)/('Screener Input'!J$17+'Screener Input'!J$25)<0, 0, ('Screener Input'!J23)/('Screener Input'!J$17+'Screener Input'!J$25))","v":0.17613784412977082},{"$f":"IF(('Screener Input'!K23)/('Screener Input'!K$17+'Screener Input'!K$25)<0, 0, ('Screener Input'!K23)/('Screener Input'!K$17+'Screener Input'!K$25))","v":0.17459536863019109}]
["Other Expenses",null,{"$f":"IF(('Screener Input'!B24)/('Screener Input'!B$17+'Screener Input'!B$25)<0, 0, ('Screener Input'!B24)/('Screener Input'!B$17+'Screener Input'!B$25))","v":1.8420796145974017E-2},{"$f":"IF(('Screener Input'!C24)/('Screener Input'!C$17+'Screener Input'!C$25)<0, 0, ('Screener Input'!C24)/('Screener Input'!C$17+'Screener Input'!C$25))","v":6.8742988100146701E-2},{"$f":"IF(('Screener Input'!D24)/('Screener Input'!D$17+'Screener Input'!D$25)<0, 0, ('Screener Input'!D24)/('Screener Input'!D$17+'Screener Input'!D$25))","v":3.3973798434457782E-2},{"$f":"IF(('Screener Input'!E24)/('Screener Input'!E$17+'Screener Input'!E$25)<0, 0, ('Screener Input'!E24)/('Screener Input'!E$17+'Screener Input'!E$25))","v":1.558708140812573E-2},{"$f":"IF(('Screener Input'!F24)/('Screener Input'!F$17+'Screener Input'!F$25)<0, 0, ('Screener Input'!F24)/('Screener Input'!F$17+'Screener Input'!F$25))","v":1.9950607718754537E-2},{"$f":"IF(('Screener Input'!G24)/('Screener Input'!G$17+'Screener Input'!G$25)<0, 0, ('Screener Input'!G24)/('Screener Input'!G$17+'Screener Input'!G$25))","v":1.851578954232171E-2},{"$f":"IF(('Screener Input'!H24)/('Screener Input'!H$17+'Screener Input'!H$25)<0, 0, ('Screener Input'!H24)/('Screener Input'!H$17+'Screener Input'!H$25))","v":1.792491813224479E-2},{"$f":"IF(('Screener Input'!I24)/('Screener Input'!I$17+'Screener Input'!I$25)<0, 0, ('Screener Input'!I24)/('Screener Input'!I$17+'Screener Input'!I$25))","v":1.93766404038971E-2},{"$f":"IF(('Screener Input'!J24)/('Screener Input'!J$17+'Screener Input'!J$25)<0, 0, ('Screener Input'!J24)/('Screener Input'!J$17+'Screener Input'!J$25))","v":2.339441703509109E-2},{"$f":"IF(('Screener Input'!K24)/('Screener Input'!K$17+'Screener Input'!K$25)<0, 0, ('Screener Input'!K24)/('Screener Input'!K$17+'Screener Input'!K$25))","v":2.5227434218760621E-2}]
["Depreciation",null,{"$f":"IF(('Screener Input'!B26)/('Screener Input'!B$17+'Screener Input'!B$25)<0, 0, ('Screener Input'!B26)/('Screener Input'!B$17+'Screener Input'!B$25))","v":1.3387449353253226E-2},{"$f":"IF(('Screener Input'!C26)/('Screener Input'!C$17+'Screener Input'!C$25)<0, 0, ('Screener Input'!C26)/('Screener Input'!C$17+'Screener Input'!C$25))","v":1.1314928994026101E-2},{"$f":"IF(('Screener Input'!D26)/('Screener Input'!D$17+'Screener Input'!D$25)<0, 0, ('Screener Input'!D26)/('Screener Input'!D$17+'Screener Input'!D$25))","v":1.3187962813749086E-2},{"$f":"IF(('Screener Input'!E26)/('Screener Input'!E$17+'Screener Input'!E$25)<0, 0, ('Screener Input'!E26)/('Screener Input'!E$17+'Screener Input'!E$25))","v":1.2621657777577558E-2},{"$f":"IF(('Screener Input'!F26)/('Screener Input'!F$17+'Screener Input'!F$25)<0, 0, ('Screener Input'!F26)/('Screener Input'!F$17+'Screener Input'!F$25))","v":1.1651978112440075E-2},{"$f":"IF(('Screener Input'!G26)/('Screener Input'!G$17+'Screener Input'!G$25)<0, 0, ('Screener Input'!G26)/('Screener Input'!G$17+'Screener Input'!G$25))","v":1.0674160966608198E-2},{"$f":"IF(('Screener Input'!H26)/('Screener Input'!H$17+'Screener Input'!H$25)<0, 0, ('Screener Input'!H26)/('Screener Input'!H$17+'Screener Input'!H$25))","v":1.0841655460358332E-2},{"$f":"IF(('Screener Input'!I26)/('Screener Input'!I$17+'Screener Input'!I$25)<0, 0, ('Screener Input'!I26)/('Screener Input'!I$17+'Screener Input'!I$25))","v":1.2307462752282807E-2},{"$f":"IF(('Screener Input'!J26)/('Screener Input'!J$17+'Screener Input'!J$25)<0, 0, ('Screener Input'!J26)/('Screener Input'!J$17+'Screener Input'!J$25))","v":1.511821618504517E-2},{"$f":"IF(('Screener Input'!K26)/('Screener Input'!K$17+'Screener Input'!K$25)<0, 0, ('Screener Input'!K26)/('Screener Input'!K$17+'Screener Input'!K$25))","v":1.5342632077414852E-2}]
["Interest",null,{"$f":"IF(('Screener Input'!B27)/('Screener Input'!B$17+'Screener Input'!B$25)<0, 0, ('Screener Input'!B27)/('Screener Input'!B$17+'Screener Input'!B$25))","v":1.3129864524303475E-2},{"$f":"IF(('Screener Input'!C27)/('Screener Input'!C$17+'Screener Input'!C$25)<0, 0, ('Screener Input'!C27)/('Screener Input'!C$17+'Screener Input'!C$25))","v":5.3218521963427842E-3},{"$f":"IF(('Screener Input'!D27)/('Screener Input'!D$17+'Screener Input'!D$25)<0, 0, ('Screener Input'!D27)/('Screener Input'!D$17+'Screener Input'!D$25))","v":1.2833959004245403E-2},{"$f":"IF(('Screener Input'!E27)/('Screener Input'!E$17+'Screener Input'!E$25)<0, 0, ('Screener Input'!E27)/('Screener Input'!E$17+'Screener Input'!E$25))","v":1.4217972347522579E-2},{"$f":"IF(('Screener Input'!F27)/('Screener Input'!F$17+'Screener Input'!F$25)<0, 0, ('Screener Input'!F27)/('Screener Input'!F$17+'Screener Input'!F$25))","v":1.3213645828289185E-2},{"$f":"IF(('Screener Input'!G27)/('Screener Input'!G$17+'Screener Input'!G$25)<0, 0, ('Screener Input'!G27)/('Screener Input'!G$17+'Screener Input'!G$25))","v":1.563761321326804E-2},{"$f":"IF(('Screener Input'!H27)/('Screener Input'!H$17+'Screener Input'!H$25)<0, 0, ('Screener Input'!H27)/('Screener Input'!H$17+'Screener Input'!H$25))","v":1.3430850110948423E-2},{"$f":"IF(('Screener Input'!I27)/('Screener Input'!I$17+'Screener Input'!I$25)<0, 0, ('Screener Input'!I27)/('Screener Input'!I$17+'Screener Input'!I$25))","v":1.5659818451776712E-2},{"$f":"IF(('Screener Input'!J27)/('Screener Input'!J$17+'Screener Input'!J$25)<0, 0, ('Screener Input'!J27)/('Screener Input'!J$17+'Screener Input'!J$25))","v":1.6465902052497809E-2},{"$f":"IF(('Screener Input'!K27)/('Screener Input'!K$17+'Screener Input'!K$25)<0, 0, ('Screener Input'!K27)/('Screener Input'!K$17+'Screener Input'!K$25))","v":1.7061385311164304E-2}]
["Tax",null,{"$f":"IF(('Screener Input'!B29)/('Screener Input'!B$17+'Screener Input'!B$25)<0, 0, ('Screener Input'!B29)/('Screener Input'!B$17+'Screener Input'!B$25))","v":2.5034460673062194E-2},{"$f":"IF(('Screener Input'!C29)/('Screener Input'!C$17+'Screener Input'!C$25)<0, 0, ('Screener Input'!C29)/('Screener Input'!C$17+'Screener Input'!C$25))","v":3.8513908732632059E-2},{"$f":"IF(('Screener Input'!D29)/('Screener Input'!D$17+'Screener Input'!D$25)<0, 0, ('Screener Input'!D29)/('Screener Input'!D$17+'Screener Input'!D$25))","v":3.6512586948883437E-2},{"$f":"IF(('Screener Input'!E29)/('Screener Input'!E$17+'Screener Input'!E$25)<0, 0, ('Screener Input'!E29)/('Screener Input'!E$17+'Screener Input'!E$25))","v":4.4275694298904517E-2},{"$f":"IF(('Screener Input'!F29)/('Screener Input'!F$17+'Screener Input'!F$25)<0, 0, ('Screener Input'!F29)/('Screener Input'!F$17+'Screener Input'!F$25))","v":2.7114304392039126E-2},{"$f":"IF(('Screener Input'!G29)/('Screener Input'!G$17+'Screener Input'!G$25)<0, 0, ('Screener Input'!G29)/('Screener Input'!G$17+'Screener Input'!G$25))","v":2.7434615058587256E-2},{"$f":"IF(('Screener Input'!H29)/('Screener Input'!H$17+'Screener Input'!H$25)<0, 0, ('Screener Input'!H29)/('Screener Input'!H$17+'Screener Input'!H$25))","v":3.2518994991198175E-2},{"$f":"IF(('Screener Input'!I29)/('Screener Input'!I$17+'Screener Input'!I$25)<0, 0, ('Screener Input'!I29)/('Screener Input'!I$17+'Screener Input'!I$25))","v":4.1100296709774796E-2},{"$f":"IF(('Screener Input'!J29)/('Screener Input'!J$17+'Screener Input'!J$25)<0, 0, ('Screener Input'!J29)/('Screener Input'!J$17+'Screener Input'!J$25))","v":4.0490378249076267E-2},{"$f":"IF(('Screener Input'!K29)/('Screener Input'!K$17+'Screener Input'!K$25)<0, 0, ('Screener Input'!K29)/('Screener Input'!K$17+'Screener Input'!K$25))","v":3.9884141840504816E-2}]
["Net profit",null,{"$f":"1-SUM(C171:C179)","v":0.12061931746982091},{"$f":"1-SUM(D171:D179)","v":0.16281511597802234},0.13597709014152215,0.14714298865343522,0.12793417994285983,0.10684593866758829,0.11661288434850925,0.10158824119349263,0.13967770872044605,0.16105230272526871]
[null,null,{"$f":"SUM(C171:C180)","v":1},{"$f":"SUM(D171:D180)","v":1},1,1,1,1,1,1,1,1]
[]
["P/L - Annual - YoY change",null,{"$f":"C4","v":"2009-03-01"},"2010-03-01","2011-03-01","2012-03-01","2013-03-01","2014-03-01","2015-03-01","2016-03-01","2017-03-01","2018-03-01"]
["Sales",null,null,{"$f":"('Screener Input'!C17+'Screener Input'!C25)","v":2085.7400000000002},{"$f":"('Screener Input'!D17+'Screener Input'!D25)","v":3785.27},{"$f":"('Screener Input'!E17+'Screener Input'!E25)","v":5105.51},{"$f":"('Screener Input'!F17+'Screener Input'!F25)","v":6608.3200000000006},{"$f":"('Screener Input'!G17+'Screener Input'!G25)","v":7668.05},{"$f":"('Screener Input'!H17+'Screener Input'!H25)","v":8373.26},{"$f":"('Screener Input'!I17+'Screener Input'!I25)","v":8176.3399999999992},{"$f":"('Screener Input'!J17+'Screener Input'!J25)","v":9364.2000000000007},{"$f":"('Screener Input'!K17+'Screener Input'!K25)","v":10146.890000000001}]
["Sales YoY",null,null,{"$f":"('Screener Input'!C17+'Screener Input'!C25)/('Screener Input'!B17+'Screener Input'!B25)-1","v":0.45204048955041021},{"$f":"('Screener Input'!D17+'Screener Input'!D25)/('Screener Input'!C17+'Screener Input'!C25)-1","v":0.81483310479733784},{"$f":"('Screener Input'!E17+'Screener Input'!E25)/('Screener Input'!D17+'Screener Input'!D25)-1","v":0.34878357422323902},{"$f":"('Screener Input'!F17+'Screener Input'!F25)/('Screener Input'!E17+'Screener Input'!E25)-1","v":0.29435061335694179},{"$f":"('Screener Input'!G17+'Screener Input'!G25)/('Screener Input'!F17+'Screener Input'!F25)-1","v":0.16036299694930012},{"$f":"('Screener Input'!H17+'Screener Input'!H25)/('Screener Input'!G17+'Screener Input'!G25)-1","v":9.1967318940278098E-2},{"$f":"('Screener Input'!I17+'Screener Input'!I25)/('Screener Input'!H17+'Screener Input'!H25)-1","v":-2.3517721890876531E-2},{"$f":"('Screener Input'!J17+'Screener Input'!J25)/('Screener Input'!I17+'Screener Input'!I25)-1","v":0.14528016202848737},{"$f":"('Screener Input'!K17+'Screener Input'!K25)/('Screener Input'!J17+'Screener Input'!J25)-1","v":8.3583221204160507E-2}]
["EPS",null,null,{"$f":"'Screener Input'!C30/'Screener Input'!C93","v":5.2339471900508228},{"$f":"'Screener Input'!D30/'Screener Input'!D93","v":7.7490648444022527},{"$f":"'Screener Input'!E30/'Screener Input'!E93","v":10.672472049712535},{"$f":"'Screener Input'!F30/'Screener Input'!F93","v":11.690867700209761},{"$f":"'Screener Input'!G30/'Screener Input'!G93","v":11.155926624160951},{"$f":"'Screener Input'!H30/'Screener Input'!H93","v":13.318869202691909},{"$f":"'Screener Input'!I30/'Screener Input'!I93","v":12.149906013406019},{"$f":"'Screener Input'!J30/'Screener Input'!J93","v":19.142943267396259},{"$f":"'Screener Input'!K30/'Screener Input'!K93","v":23.984068043660201}]
["EPS YoY",null,null,{"$f":"(('Screener Input'!C30/'Screener Input'!C93)/('Screener Input'!B30/'Screener Input'!B93))-1","v":0.80522496245742725},{"$f":"(('Screener Input'!D30/'Screener Input'!D93)/('Screener Input'!C30/'Screener Input'!C93))-1","v":0.48053936408307707},{"$f":"(('Screener Input'!E30/'Screener Input'!E93)/('Screener Input'!D30/'Screener Input'!D93))-1","v":0.37725935503328323},{"$f":"(('Screener Input'!F30/'Screener Input'!F93)/('Screener Input'!E30/'Screener Input'!E93))-1","v":9.5422658007772165E-2},{"$f":"(('Screener Input'!G30/'Screener Input'!G93)/('Screener Input'!F30/'Screener Input'!F93))-1","v":-4.5757174725295391E-2},{"$f":"(('Screener Input'!H30/'Screener Input'!H93)/('Screener Input'!G30/'Screener Input'!G93))-1","v":0.19388282581982597},{"$f":"(('Screener Input'!I30/'Screener Input'!I93)/('Screener Input'!H30/'Screener Input'!H93))-1","v":-8.7767450186358786E-2},{"$f":"(('Screener Input'!J30/'Screener Input'!J93)/('Screener Input'!I30/'Screener Input'!I93))-1","v":0.57556307400849271},{"$f":"(('Screener Input'!K30/'Screener Input'!K93)/('Screener Input'!J30/'Screener Input'!J93))-1","v":0.25289344008605075}]
[]
["P/L - QoQ - change",null,{"$f":"'Screener Input'!B41","v":"2016-06-30"},{"$f":"'Screener Input'!C41","v":"2016-09-30"},{"$f":"'Screener Input'!D41","v":"2016-12-31"},{"$f":"'Screener Input'!E41","v":"2017-03-31"},{"$f":"'Screener Input'!F41","v":"2017-06-30"},{"$f":"'Screener Input'!G41","v":"2017-09-30"},{"$f":"'Screener Input'!H41","v":"2017-12-31"},{"$f":"'Screener Input'!I41","v":"2018-03-31"},{"$f":"'Screener Input'!J41","v":"2018-06-30"},{"$f":"'Screener Input'!K41","v":"2018-09-30"}]
["Sales ",null,{"$f":"('Screener Input'!B42+'Screener Input'!B44)","v":2122.66},{"$f":"('Screener Input'!C42+'Screener Input'!C44)","v":2375.52},{"$f":"('Screener Input'!D42+'Screener Input'!D44)","v":2424.2399999999998},{"$f":"('Screener Input'!E42+'Screener Input'!E44)","v":2422.7599999999998},{"$f":"('Screener Input'!F42+'Screener Input'!F44)","v":2193.5500000000002},{"$f":"('Screener Input'!G42+'Screener Input'!G44)","v":2521.4699999999998},{"$f":"('Screener Input'!H42+'Screener Input'!H44)","v":2664.2400000000002},{"$f":"('Screener Input'!I42+'Screener Input'!I44)","v":2751.98},{"$f":"('Screener Input'!J42+'Screener Input'!J44)","v":2500.7800000000002},{"$f":"('Screener Input'!K42+'Screener Input'!K44)","v":2945.0099999999998}]
["Sales QoQ",null,null,null,null,null,{"$f":"G190/C190-1","v":3.3396775743642637E-2},6.1439179632248875E-2,9.9000099000099206E-2,0.13588634449966164,0.14006063230835863,{"$f":"L190/H190-1","v":0.16797344406239212}]
["NP",null,{"$f":"'Screener Input'!B49","v":245.83},{"$f":"'Screener Input'!C49","v":318.74},{"$f":"'Screener Input'!D49","v":351.93},{"$f":"'Screener Input'!E49","v":387.58},{"$f":"'Screener Input'!F49","v":225.17},{"$f":"'Screener Input'!G49","v":361.95},{"$f":"'Screener Input'!H49","v":429.87},{"$f":"'Screener Input'!I49","v":617.19000000000005},{"$f":"'Screener Input'!J49","v":405.04},{"$f":"'Screener Input'!K49","v":577.73}]
["NP QoQ",null,null,null,null,null,{"$f":"G192/C192-1","v":-8.4041817516169792E-2},0.13556503733450453,0.22146449578041083,0.59241962949584615,0.79881867033796716,{"$f":"L192/H192-1","v":0.59615969056499529}]
[]
["P/L - Quaterly",null,{"$f":"'Screener Input'!B41","v":"2016-06-30"},{"$f":"'Screener Input'!C41","v":"2016-09-30"},{"$f":"'Screener Input'!D41","v":"2016-12-31"},{"$f":"'Screener Input'!E41","v":"2017-03-31"},{"$f":"'Screener Input'!F41","v":"2017-06-30"},{"$f":"'Screener Input'!G41","v":"2017-09-30"},{"$f":"'Screener Input'!H41","v":"2017-12-31"},{"$f":"'Screener Input'!I41","v":"2018-03-31"},{"$f":"'Screener Input'!J41","v":"2018-06-30"},{"$f":"'Screener Input'!K41","v":"2018-09-30"}]
["Expenses",null,{"$f":"IF('Screener Input'!B43/('Screener Input'!B42+'Screener Input'!B44)<0, 0, 'Screener Input'!B43/('Screener Input'!B42+'Screener Input'!B44))","v":0.81679119595224869},{"$f":"IF('Screener Input'!C43/('Screener Input'!C42+'Screener Input'!C44)<0, 0, 'Screener Input'!C43/('Screener Input'!C42+'Screener Input'!C44))","v":0.79635195662423386},{"$f":"IF('Screener Input'!D43/('Screener Input'!D42+'Screener Input'!D44)<0, 0, 'Screener Input'!D43/('Screener Input'!D42+'Screener Input'!D44))","v":0.78263703263703266},{"$f":"IF('Screener Input'!E43/('Screener Input'!E42+'Screener Input'!E44)<0, 0, 'Screener Input'!E43/('Screener Input'!E42+'Screener Input'!E44))","v":0.76294804272812833},{"$f":"IF('Screener Input'!F43/('Screener Input'!F42+'Screener Input'!F44)<0, 0, 'Screener Input'!F43/('Screener Input'!F42+'Screener Input'!F44))","v":0.83329306375510004},{"$f":"IF('Screener Input'!G43/('Screener Input'!G42+'Screener Input'!G44)<0, 0, 'Screener Input'!G43/('Screener Input'!G42+'Screener Input'!G44))","v":0.78317806676264246},{"$f":"IF('Screener Input'!H43/('Screener Input'!H42+'Screener Input'!H44)<0, 0, 'Screener Input'!H43/('Screener Input'!H42+'Screener Input'!H44))","v":0.76618472810257321},{"$f":"IF('Screener Input'!I43/('Screener Input'!I42+'Screener Input'!I44)<0, 0, 'Screener Input'!I43/('Screener Input'!I42+'Screener Input'!I44))","v":0.70204361950304872},{"$f":"IF('Screener Input'!J43/('Screener Input'!J42+'Screener Input'!J44)<0, 0, 'Screener Input'!J43/('Screener Input'!J42+'Screener Input'!J44))","v":0.81249050296307546},{"$f":"IF('Screener Input'!K43/('Screener Input'!K42+'Screener Input'!K44)<0, 0, 'Screener Input'!K43/('Screener Input'!K42+'Screener Input'!K44))","v":0.73763756320012497}]
["Depreciation",null,{"$f":"IF('Screener Input'!B45/('Screener Input'!B42+'Screener Input'!B44)<0,0, 'Screener Input'!B45/('Screener Input'!B42+'Screener Input'!B44))","v":1.5381643786569681E-2},{"$f":"IF('Screener Input'!C45/('Screener Input'!C42+'Screener Input'!C44)<0,0, 'Screener Input'!C45/('Screener Input'!C42+'Screener Input'!C44))","v":1.5049336566309692E-2},{"$f":"IF('Screener Input'!D45/('Screener Input'!D42+'Screener Input'!D44)<0,0, 'Screener Input'!D45/('Screener Input'!D42+'Screener Input'!D44))","v":1.4957264957264958E-2},{"$f":"IF('Screener Input'!E45/('Screener Input'!E42+'Screener Input'!E44)<0,0, 'Screener Input'!E45/('Screener Input'!E42+'Screener Input'!E44))","v":1.5234691013554789E-2},{"$f":"IF('Screener Input'!F45/('Screener Input'!F42+'Screener Input'!F44)<0,0, 'Screener Input'!F45/('Screener Input'!F42+'Screener Input'!F44))","v":1.7031752182535158E-2},{"$f":"IF('Screener Input'!G45/('Screener Input'!G42+'Screener Input'!G44)<0,0, 'Screener Input'!G45/('Screener Input'!G42+'Screener Input'!G44))","v":1.5296632519918937E-2},{"$f":"IF('Screener Input'!H45/('Screener Input'!H42+'Screener Input'!H44)<0,0, 'Screener Input'!H45/('Screener Input'!H42+'Screener Input'!H44))","v":1.4867279224093925E-2},{"$f":"IF('Screener Input'!I45/('Screener Input'!I42+'Screener Input'!I44)<0,0, 'Screener Input'!I45/('Screener Input'!I42+'Screener Input'!I44))","v":1.458586181585622E-2},{"$f":"IF('Screener Input'!J45/('Screener Input'!J42+'Screener Input'!J44)<0,0, 'Screener Input'!J45/('Screener Input'!J42+'Screener Input'!J44))","v":1.6846743815929429E-2},{"$f":"IF('Screener Input'!K45/('Screener Input'!K42+'Screener Input'!K44)<0,0, 'Screener Input'!K45/('Screener Input'!K42+'Screener Input'!K44))","v":1.4454959405910338E-2}]
["Interest",null,{"$f":"IF('Screener Input'!B46/('Screener Input'!B42+'Screener Input'!B44)<0, 0, 'Screener Input'!B46/('Screener Input'!B42+'Screener Input'!B44))","v":1.5348666296062487E-2},{"$f":"IF('Screener Input'!C46/('Screener Input'!C42+'Screener Input'!C44)<0, 0, 'Screener Input'!C46/('Screener Input'!C42+'Screener Input'!C44))","v":1.4733616218764733E-2},{"$f":"IF('Screener Input'!D46/('Screener Input'!D42+'Screener Input'!D44)<0, 0, 'Screener Input'!D46/('Screener Input'!D42+'Screener Input'!D44))","v":1.6380391380391383E-2},{"$f":"IF('Screener Input'!E46/('Screener Input'!E42+'Screener Input'!E44)<0, 0, 'Screener Input'!E46/('Screener Input'!E42+'Screener Input'!E44))","v":1.5655698459608052E-2},{"$f":"IF('Screener Input'!F46/('Screener Input'!F42+'Screener Input'!F44)<0, 0, 'Screener Input'!F46/('Screener Input'!F42+'Screener Input'!F44))","v":1.8103074924209612E-2},{"$f":"IF('Screener Input'!G46/('Screener Input'!G42+'Screener Input'!G44)<0, 0, 'Screener Input'!G46/('Screener Input'!G42+'Screener Input'!G44))","v":1.5923251119386708E-2},{"$f":"IF('Screener Input'!H46/('Screener Input'!H42+'Screener Input'!H44)<0, 0, 'Screener Input'!H46/('Screener Input'!H42+'Screener Input'!H44))","v":1.4503197910098188E-2},{"$f":"IF('Screener Input'!I46/('Screener Input'!I42+'Screener Input'!I44)<0, 0, 'Screener Input'!I46/('Screener Input'!I42+'Screener Input'!I44))","v":1.5348948756895036E-2},{"$f":"IF('Screener Input'!J46/('Screener Input'!J42+'Screener Input'!J44)<0, 0, 'Screener Input'!J46/('Screener Input'!J42+'Screener Input'!J44))","v":1.9086045153911976E-2},{"$f":"IF('Screener Input'!K46/('Screener Input'!K42+'Screener Input'!K44)<0, 0, 'Screener Input'!K46/('Screener Input'!K42+'Screener Input'!K44))","v":2.0787705304905587E-2}]
["Tax",null,{"$f":"IF('Screener Input'!B48/('Screener Input'!B42+'Screener Input'!B44)<0, 0, 'Screener Input'!B48/('Screener Input'!B42+'Screener Input'!B44))","v":3.6279950627985648E-2},{"$f":"IF('Screener Input'!C48/('Screener Input'!C42+'Screener Input'!C44)<0, 0, 'Screener Input'!C48/('Screener Input'!C42+'Screener Input'!C44))","v":3.8509463191217085E-2},{"$f":"IF('Screener Input'!D48/('Screener Input'!D42+'Screener Input'!D44)<0, 0, 'Screener Input'!D48/('Screener Input'!D42+'Screener Input'!D44))","v":4.0742665742665746E-2},{"$f":"IF('Screener Input'!E48/('Screener Input'!E42+'Screener Input'!E44)<0, 0, 'Screener Input'!E48/('Screener Input'!E42+'Screener Input'!E44))","v":4.6186993346431351E-2},{"$f":"IF('Screener Input'!F48/('Screener Input'!F42+'Screener Input'!F44)<0, 0, 'Screener Input'!F48/('Screener Input'!F42+'Screener Input'!F44))","v":2.8921155205032936E-2},{"$f":"IF('Screener Input'!G48/('Screener Input'!G42+'Screener Input'!G44)<0, 0, 'Screener Input'!G48/('Screener Input'!G42+'Screener Input'!G44))","v":4.2054833093393938E-2},{"$f":"IF('Screener Input'!H48/('Screener Input'!H42+'Screener Input'!H44)<0, 0, 'Screener Input'!H48/('Screener Input'!H42+'Screener Input'!H44))","v":4.3096718013392182E-2},{"$f":"IF('Screener Input'!I48/('Screener Input'!I42+'Screener Input'!I44)<0, 0, 'Screener Input'!I48/('Screener Input'!I42+'Screener Input'!I44))","v":4.3750317952892102E-2},{"$f":"IF('Screener Input'!J48/('Screener Input'!J42+'Screener Input'!J44)<0, 0, 'Screener Input'!J48/('Screener Input'!J42+'Screener Input'!J44))","v":0},{"$f":"IF('Screener Input'!K48/('Screener Input'!K42+'Screener Input'!K44)<0, 0, 'Screener Input'!K48/('Screener Input'!K42+'Screener Input'!K44))","v":3.09472633369666E-2}]
["Net profit",null,{"$f":"1-SUM(C196:C199)","v":0.11619854333713353},{"$f":"1-SUM(D196:D199)","v":0.13535562739947471},0.14528264528264534,0.15997457445227747,0.10265095393312229,0.14354721650465785,0.16134807674984242,0.22427125197130793,0.15157670806708312,0.19617250875209247]
[]
[null,null,null,null,null,null,null,{"$f":"H24","v":"2014-03-01"},{"$f":"I24","v":"2015-03-01"},{"$f":"J24","v":"2016-03-01"},"2017-03-01","2018-03-01","TTMI"]
[null,null,null,null,1.0000000000000001E-5,{"$f":"SUM(I203:M203)+E203","v":3.0000100000000001},"Fast Grower",null,{"$f":"IF(I35/H35-1 >0.2,1, 0)","v":0},{"$f":"IF(J35/I35-1 >0.2,1, 0)","v":0},1,1,{"$f":"IF(M35/N35-1 >0.2,1, 0)","v":1}]
[null,null,null,null,2.0000000000000002E-5,{"$f":"SUM(I204:M204)+E204","v":1.0000199999999999},"Stalwart",null,{"$f":"IF(I203+I205>0, 0, 1)","v":1},{"$f":"IF(J203+J205>0, 0, 1)","v":0},0,0,0]
[null,null,null,null,3.0000000000000001E-5,1.00003,"Slow Grower",null,{"$f":"IF(I35/H35-1 <0.1,1, 0)","v":0},{"$f":"IF(J35/I35-1 <0.1,1, 0)","v":1},0,0,{"$f":"IF(M35/N35-1 <0.1,1, 0)","v":0}]
[]
[null,null,null,null,null,null,"YoY PAT growth",{"$f":"H35/G35-1","v":-3.0907348923033262E-2},{"$f":"I35/H35-1","v":0.19178567069449493},{"$f":"J35/I35-1","v":-0.14932970105383847},0.57469119452938466,0.24940174468833631,{"$f":"M35/N35-1","v":0.53006490129124173}]

{"sheet":"|||","index":16,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Screener Input","index":17,"n_rows":93,"n_cols":11,"rows_kept":93,"cut":false,"hidden":false,"merged":[[0,4,0,10],[1,4,1,10]]}
["COMPANY NAME","GODREJ CONSUMER PRODUCTS 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":102.21661495599317}]
["Face Value",1]
["Current Price",789.65]
["Market Capitalization",80715.350000000006]
[]
[]
[]
[]
[]
["PROFIT & LOSS"]
["Report Date","2009-03-31","2010-03-31","2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31","2017-03-31","2018-03-31"]
["Sales",1396.49,2041.44,3691.89,4853.34,6411.64,7599.47,8273.15,8423.8799999999992,9267.91,9843.27]
["Raw Material Cost",760.63,986.75,1752.4,2527.85,3177.49,3504.3,3806.48,3959.14,4265.8500000000004,4218.3599999999997]
["Change in Inventory",-8.91,40.450000000000003,45.22,212.26,155.88999999999999,-50.38,-35.04,91.9,133.33000000000001,-56]
["Power and Fuel",35.61,33.46,53.39,79.959999999999994,102.56,103.2,109.92,109.99,89.02,101.11]
["Other Mfr. Exp",25.89,32.92,86.07,119.92,167.55,195.85,223.97,236.23,302.85000000000002,318.75]
["Employee Cost",86.53,151.80000000000001,284.5,401.48,590.67999999999995,742.43,776.95,944.13,988.46,1057.4100000000001]
["Selling and admin",245.08,323.26,774.11,994.66,1405.16,1698.48,1818.85,1464.98,1649.39,1771.6]
["Other Expenses",26.46,143.38,128.6,79.58,131.84,141.97999999999999,150.09,158.43,219.07,255.98]
["Other Income",39.93,44.3,93.38,252.17,196.68,68.58,100.11,-247.54,96.29,303.62]
["Depreciation",19.23,23.6,49.92,64.44,77,81.849999999999994,90.78,100.63,141.57,155.68]
["Interest",18.86,11.1,48.58,72.59,87.32,119.91,112.46,128.04,154.19,173.12]
["Profit before tax",209.22,419.92,652.91999999999996,977.29,1024.6099999999999,1029.67,1248.72,1166.67,1687.13,2038.88]
["Tax",35.96,80.33,138.21,226.05,179.18,210.37,272.29000000000002,336.05,379.16,404.7]
["Net profit",173.26,339.59,514.71,726.72,796.1,759.73,907.12,827.61,1304.08,1634.18]
["Dividend Amount",102.8,130.99,145.62,161.63999999999999,176.96,178.71,187.22,195.79,510.9,681.3]
[]
[]
[]
[]
[]
[]
[]
[]
["Quarters"]
["Report Date","2016-06-30","2016-09-30","2016-12-31","2017-03-31","2017-06-30","2017-09-30","2017-12-31","2018-03-31","2018-06-30","2018-09-30"]
["Sales",2116.96,2358.9899999999998,2402.16,2389.81,2177.3000000000002,2506.56,2630.3,2528.89,2476.02,2659.18]
["Expenses",1733.77,1891.75,1897.3,1848.44,1827.87,1974.76,2041.3,1932.01,2031.86,2172.35]
["Other Income",5.7,16.53,22.08,32.950000000000003,16.25,14.91,33.94,223.09,24.76,285.83]
["Depreciation",32.65,35.75,36.26,36.909999999999997,37.36,38.57,39.61,40.14,42.13,42.57]
["Interest",32.58,35,39.71,37.93,39.71,40.15,38.64,42.24,47.73,61.22]
["Profit before tax",323.66000000000003,413.02,450.97,499.48,288.61,467.99,544.69000000000005,737.59,379.06,668.87]
["Tax",77.010000000000005,91.48,98.77,111.9,63.44,106.04,114.82,120.4,-25.98,91.14]
["Net profit",245.83,318.74,351.93,387.58,225.17,361.95,429.87,617.19000000000005,405.04,577.73]
["Operating Profit",383.19,467.24,504.86,541.37,349.43,531.79999999999995,589,596.88,444.16,486.83]
[]
[]
[]
[]
["BALANCE SHEET"]
["Report Date","2009-03-31","2010-03-31","2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31","2017-03-31","2018-03-31"]
["Equity Share Capital",25.7,30.82,32.36,34.03,34.03,34.04,34.04,34.049999999999997,34.06,68.13]
["Reserves",545.83000000000004,923.87,1692.8,2769.94,3279.01,3741.36,4276.6499999999996,4232.91,5267.89,6190.18]
["Borrowings",277.57,36.869999999999997,2000.75,1876.91,2456.34,2373.42,2717.15,2891.12,4000.93,3493.75]
["Other Liabilities",336.39,562.32000000000005,775.39,1335.04,1946.55,2197.04,2123.15,2629.66,3777.6,4288.04]
["Total",1185.49,1553.88,4501.3,6015.92,7715.93,8345.86,9150.99,9787.74,13080.48,14040.1]
["Net Block",440.44,573.59,3077.68,3691.79,4496.0600000000004,5121.3599999999997,5550.95,5931.41,8082.89,8315]
["Capital Work in Progress",2.5,0.84,8.02,37.58,140.85,167.07,224.61,43.66,97.43,83.88]
["Investments",7.51,67,null,null,121.18,136.27000000000001,185.69,189.5,933.54,997.28]
["Other Assets",735.04,912.45,1415.6,2286.5500000000002,2957.84,2921.16,3189.74,3623.17,3966.62,4643.9399999999996]
["Total",1185.49,1553.88,4501.3,6015.92,7715.93,8345.86,9150.99,9787.74,13080.48,14040.1]
["Receivables",60.19,115.26,383.99,472.53,728.76,732.05,804.58,1118.01,1028.74,1245.5]
["Inventory",167.47,264.43,439.41,783.91,1047.0899999999999,1082.1300000000001,1071.71,1306.98,1412.5,1577.72]
["Cash & Bank",378.32,305.16000000000003,226.91,639.87,747.6,704.79,894.22,753.79,912.66,960.21]
["No. of Equity Shares",256985032,308221168,323621268,340328585,340358049,340409400,340478025,340564947,340631940,681360642]
["New Bonus Shares",null,null,null,null,null,null,null,null,null,340600816]
["Face value",1,1,1,1,1,1,1,1,1,1]
[]
[]
[]
[]
[]
[]
[]
["CASH FLOW:"]
["Report Date","2009-03-31","2010-03-31","2011-03-31","2012-03-31","2013-03-31","2014-03-31","2015-03-31","2016-03-31","2017-03-31","2018-03-31"]
["Cash from Operating Activity",143.27000000000001,338.5,206.13,1098.51,820.12,1115.8699999999999,1026.73,847.37,1860.22,1723.35]
["Cash from Investing Activity",-141.51,-50.8,-2527.41,-856.35,-865.18,-494.24,-1235.8599999999999,-621.59,-2243.25,-339.79]
["Cash from Financing Activity",333.98,-360.86,2236.89,-7.26,281.68,-620.49,-12.04,-202.47,664.65,-1384.01]
["Net Cash Flow",335.74,-73.16,-84.39,234.9,236.62,1.1399999999999999,-221.17,23.31,281.62,-0.45]
[]
[]
[]
[]
["PRICE:",44.144444,97.211428999999995,126.28052599999999,169.57550000000001,268.88549999999998,278.71157899999997,378.66250000000002,454.88105300000001,564.25947399999995,732.74190499999997]
[]
["DERIVED:"]
["Adjusted Equity Shares in Cr",{"$f":"IF($B7>0,(B70*B72/$B7)+SUM(C71:$K71),0)/10000000","v":59.758584800000001},{"$f":"IF($B7>0,(C70*C72/$B7)+SUM(D71:$K71),0)/10000000","v":64.882198399999993},{"$f":"IF($B7>0,(D70*D72/$B7)+SUM(E71:$K71),0)/10000000","v":66.422208400000002},{"$f":"IF($B7>0,(E70*E72/$B7)+SUM(F71:$K71),0)/10000000","v":68.092940100000007},{"$f":"IF($B7>0,(F70*F72/$B7)+SUM(G71:$K71),0)/10000000","v":68.095886500000006},{"$f":"IF($B7>0,(G70*G72/$B7)+SUM(H71:$K71),0)/10000000","v":68.101021599999996},{"$f":"IF($B7>0,(H70*H72/$B7)+SUM(I71:$K71),0)/10000000","v":68.107884100000007},{"$f":"IF($B7>0,(I70*I72/$B7)+SUM(J71:$K71),0)/10000000","v":68.116576300000006},{"$f":"IF($B7>0,(J70*J72/$B7)+SUM(K71:$K71),0)/10000000","v":68.123275599999999},{"$f":"IF($B7>0,(K70*K72/$B7),0)/10000000","v":68.136064200000007}]

{"sheet":"Shareholding input","index":18,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"http://www.bseindia.com/corporates/Sharehold_Searchnew.aspx?expandable=3",null,null,null,null,null,"https://www.bseindia.com/corporates/Insider_Trading_new.aspx?expandable=2"]
[]
[null,"Shareholding Dist.","2018-09-01","2018-03-01","2017-03-01","2016-03-01","2015-03-01","2014-03-01"]
[null,"Employee trust & Insurance Co",0.63249999999999995,0.63260000000000005,0.63270000000000004,0.63280000000000003,0.63300000000000001,0.6331]
[null,"Promoter pledged"]
[null,"FII",0.27889999999999998,0.28010000000000002,0.2843,0.28560000000000002,0.28770000000000001,0.28410000000000002]
[null,"Mutual funds",7.7999999999999996E-3,6.8999999999999999E-3,6.1999999999999998E-3,5.1999999999999998E-3,3.3E-3,2.2000000000000001E-3]
[null,"Bodies corporate"]
[null,"Individuals <= 2 lakh",4.8300000000000003E-2,4.8599999999999997E-2,5.0599999999999999E-2,5.11E-2,0.05,5.3400000000000003E-2]
[null,"Individuals > 2 lakh",3.8E-3,2.3999999999999998E-3,8.0000000000000004E-4,8.9999999999999998E-4,2.5000000000000001E-3,3.7000000000000002E-3]
[null,"Others",{"$f":"1-SUM(C6:C12)","v":2.8699999999999948E-2},2.9399999999999982E-2,2.5399999999999978E-2,2.4399999999999866E-2,2.3499999999999965E-2,2.3499999999999965E-2]
[]
[]
[]
[null,"Total",{"$f":"SUM(C6:C16)","v":1},1,1,1,1,1]
[]
[]
[null,"Promoters"]
[]
[]
[]
[]
[]
[null,"Rest",{"$f":"SUM(C6:C7)-SUM(C21:C25)","v":0.63249999999999995},{"$f":"SUM(D6:D7)-SUM(D21:D25)","v":0.63260000000000005},0.63270000000000004,0.63280000000000003,0.63300000000000001,0.6331]

{"sheet":"Phil Fisher","index":19,"n_rows":95,"n_cols":54,"rows_kept":95,"cut":false,"hidden":false,"merged":[[42,1,43,18],[53,1,55,16],[57,1,59,16],[60,1,62,16],[64,1,66,16]]}
[]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Red Flags",null,null,null,null,null,null,null,null,"RoCE"]
[null,"List of mistakes made in the market made over and over again -",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Philip Fisher on What to Buy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1. Skewed business performance - Significant change In financial ratios from previous year",null,null,null,null,null,null,null,null,"Going to Bed Smarter #4: ROCE, the Secret Winning Edge to any portfolio"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.Absence or low implementation of policies",null,null,null,null,null,null,null,null,"At Marketsmojo we use the concept of Return on Capital Employed (ROCE) to uncover great companies that can deliver fantastic shareholder returns.  In this, the fourth piece in the series of Going to Bed Smarter, I present pieces which let you into the secret of ROCE."]
[null,"Do not be taken in by the new highs. Once the past peak of the index has been crossed, every new level is a new high & there is nothing extraordinary about it.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.Does the company have products or services with sufficient market potential to make possible a sizeable increase in sales for atleast several years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.Unusual related party transactions",null,null,null,null,null,null,null,null,"Sanjeev Mohta"]
[null,"These are journeys of an index which will go up as the market prices of stocks go up. They are not urgent reminders that tell you about loss opportunities.",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4.Too many acquisitions"]
[null,"Do not treat them like immediate calls for actions. Do not check the index everyday, and do not make generalizations based on the index.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.Does the management has determination to continue to develop products or processes that will further increase total sales potential when the growth potential of currently attractive product lines have largely been exploited",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5.Formation of too many subsidiaries",null,null,null,null,null,null,null,null,"August 28, 11:54: AM IST"]
[null,"Explanations about why the market is up or down is equally useless. Discount them. How you will do is a function of what you are buying, holding and selling. ",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,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,null,"  "]
[null,"Stay focussed on that micro reality, not on the macro nartatives floating around.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.How effective are the company's research and development efforts in relation to its size",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,null,null,null,null,"Yesterday’s ET story says,“Warren Buffett in Talks for a Slice of Paytm”."]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outperformers",null,null,null,null,null,null,null,null,"Let’s discuss how Warren Buffett finds a great business."]
[null,"Do not sacrifice quality for anything. The rising tide allows lightweights to also soar. Do not use price as an indicator of how good the stock is.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4.Does the company have an above average sales organization",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use of technology and premiumization to improve margins",null,null,null,null,null,null,null,null,"His 2007 newsletter reads: “A truly great business must have an enduring ‘moat’ that protects excellent returns on invested capital (ROIC).” "]
[null,"What you see as the rise in the price of the stock in the past is history. What will matter to you is how the stock stock will behave in the future.",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Company is in perpetual challenger mode. Responds swiftly to competition.",null,null,null,null,null,null,null,null,"At Marketsmojo we use the concept of Return on Capital Employed (ROCE) to uncover great companies that can deliver fantastic shareholder returns. "]
[null,"While it is not possible to predict the future with any degee of certainity, you need to have an investment thesis or a basic set of reasons why you bought the stock. Write down your reasons.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5.Does the company have a worthwhile profit margin",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"They stay relevant through economic cycles by anticipating and adapting to disruption better.",null,null,null,null,null,null,null,null,"In this, the fourth piece in the series of Going to Bed Smarter, I present pieces which let you into the secret of ROCE."]
[null,"Make sure your holdings are worth your hard earned money. Do not take chances with unknown stocks and overhyped IPO when there are enough of others with well established track record & performance numbers",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Up the ante in customer satisfaction"]
[null,"Your money deserves better",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6.What is the company doing to maintain or improve its profit margin",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"There is relentless focus on execution and excellent capital allocation",null,null,null,null,null,null,null,null,"The Magic of ROCE"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ability to convert as opportunities what peers see as risk",null,null,null,null,null,null,null,null,"The 2007 letter of Berkshire Hathaway is a classic. If there is only one Berkshire Hathaway letter you want to read, this one is it. In that letter, Warren Buffett narrates the success of See’s Candy."]
[null,"Do not benchmark your returns with what you may have gained in the short-term by participating in the equity markets. It is a good feeling to see the value of investments go up.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7.Does the company have outstanding labor and personel relations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stable leadership",null,null,null,null,null,null,null,null,"“We bought See’s for $25 million when its sales were $30 million and pre-tax earnings were less than $5 million. The capital then required to conduct the business was $8 million (Modest seasonal debt was also needed for a few months each year). Consequently, the company was earning 60% pre-tax on invested capital. Two factors helped to minimize the funds required for operations. First, the product was sold for cash, and that eliminated accounts receivable. Second, the production and distribution cycle was short, which minimized inventories."]
[null,"A bull market attracts investors as their confidence moves up when what they have invested in begins to do well, or exceed their expectations ",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not venturing in unrelated business or making unrelated acquisitions",null,null,null,null,null,null,null,null,"Last year See’s sales were $383 million, and pre-tax profits were $82 million. The capital now required to run the business is $40 million. This means we have had to reinvest only $32 million since 1972 to handle the modest physical growth – and somewhat immodest financial growth – of the business. In the meantime pre-tax earnings have totaled $1.35 billion. All of that, except for the $32 million, has been sent to Berkshire (or, in the early years, to Blue Chip). After paying corporate taxes on the profits, we have used the rest to buy other attractive businesses. Just as Adam and Eve kick-started an activity that led to six billion humans, See’s has given birth to multiple new streams of cash for us. (The biblical command to “be fruitful and multiply” is one we take seriously at Berkshire.)"]
[null,"Investors who see a 10% return as fantastic will begin to believe that a 40% return is to be normally expected.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8.Does the company have outstanding executive relations",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,null,null,null,null,"There aren’t many See’s in Corporate America. Typically, companies that increase their earnings from $5 million to $82 million require, say, $400 million or so of capital investment to finance their growth. That’s because growing businesses have both working capital needs that increase in proportion to sales growth and significant requirements for fixed asset investments."]
[null,"Do not be taken in by recent  experiences of appreciation in the value of your investments. Learn to see these as the buffer for the inevitable correction that will come in the future.",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,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,null,"A company that needs large increases in capital to engender its growth may well prove to be a satisfactory investment. There is, to follow through on our example, nothing shabby about earning $82 million pre-tax on $400 million of net tangible assets. But that equation for the owner is vastly different from the See’s situation.It’s far better to have an ever-increasing stream of earnings with virtually no major capital requirements. Ask Microsoft or Google.”"]
[null,"It does not matter when that would happen, not is it necessary to predict the next fall. Returns will eventually average out overtime and these abnormal gains will bufer you again.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9.Does the company have depth to its management"]
[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,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,null,null,null,"ROCE = EBIT/Capital Employed"]
[null,"Do not quit in great haste. The desire to be right about timing the market is very high with investors. Coming off from a flat into a boom creates anxities.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10.How good are the company's cost analysis and accounting controls",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,null,null,null,null,"How do we calculated ROCE? Well, there are a few variants. But the easiest one is shown in this paper by Mirae Asset Management. Marketsmojo uses the same method."]
[null,"Stories about how someone did not make all the money because of not getting out at the right time remain in memory. ",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,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,null,"EBIT is easy to calculate, but what about the Capital Employed? The paper says: “Capital Employed is the capital investment necessary for a business to function. It is commonly represented as total assets less current liabilities (or Fixed Assets plus Working Capital).”"]
[null,"Tentativeness about how far the markets will run up will increase as naysayers point to the end of the bull market with every rise.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11.Are there other aspects of the business, somewhat peculiar to the industry involved, which will give the investor important clues as to how outstanding the company maybe in relation to its competitors",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,null,null,null,null,"ROCE is a far more useful measure compared to Return on Equity (ROE) as: “ ROCE is especially useful when comparing the performance of companies in capital-intensive sectors such as utilities and telecoms. This is because unlike return on equity (ROE), which only analyzes profitability related to a company’s equity, ROCE considers debt and other liabilities as well. This provides a better indication of financial performance for companies with significant debt.”"]
[null,"Remember that a bull market is not defined by its highs, but by its lows. No one knows how far your stock will run and you may regret quitting too soon.",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,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,null,"It follows from the equation that in order to generate high ROCE, a company must either have very high profit margins or need low levels of Capital Employed or a combination of the two."]
[null,"Allow your gains to run. What you have to be hawk-eyed is the loss.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12.Does the company have a short-range or a long-range outlook in regard to its profits",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,null,null,null,null,"We have had many such companies in India as well. Many consumer related business enjoy high ROCE due to their Asset Light nature.  Hindustan Unilever with ROCE at close to 800%, Nestle at 400%, Page Industries at 84% are great examples."]
[]
[null,"Do not hesitate to throw out the bad apples. There is no way you will get each one of the stock picks right - even if you did the best research and analysis.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13.In the foreseeable future will the growth of the company require sufficient equity financing so that the large number of shares then outstanding will largely cancel the existing share holder's benefit from this anticipated growth",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,null,null,null,null,"High ROCE Means High Valuation"]
[null,"There are too many unknowns and a stock you picked might end up doing worse that you expected. Your portfolio will do well if you focus on selling off what is losing money for you, rather than selling what is making money.",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,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,null,"In 1997, when running research for HSBC, I had written a piece on the importance of ROCE. I had found that, everything else remaining the same, high ROCE companies enjoy far higher valuation that companies with low ROCE. At least for the companies where market believes that the high ROCE is sustainable."]
[null,"Do not hope to recover your loss from the stock you wrongly picked. You can make it in a another stock.By letting your losses to persist, you are allowing your capital to bleed. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14.Does the management talk freely to investors about its affairs when things are going well but calm up when trouble and disappointments happen",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,null,null,null,null,"A 2011 report, “Impact of ROCE on valuation”, by PWC concluded: “Companies that deliver better Return on Capital Employed (ROCE) experience higher valuation”"]
[null,"If you are unable to see at a loss and move on, you may still not be ready for equity investing.If you do not cut your loss, your profits may get wiped off.",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,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,null,"The relationship remains the same today. Is it any wonder why Hindustan Unilever, Nestle or Page Industries enjoy such high valuations?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15. Dies the company has management of unquestionable integrity",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,null,null,null,null,"At Marketsmojo, the five-year average ROCE  is one of the most important metric used in our Quality Parameter."]
[null,"Do not indulge in day trading if you not mastered the art of managing your capital. Trading is very different from investing & calls for a different set of skills."]
[null,"Riding the momentum in a stock and booking some quick gains can make you mistakenly believe that it is all easy. Its just that you got lukcy in a gamble ans you may not be able to replicate your gains.",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,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,null,"An interesting example: The Abrasives Industry"]
[null,"Traders are tested when the bets move against them and a good one will bow out and take the loss on the chin. The amateur will hold the position & wish for the markets to oblige & get caught up in steep loss.",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,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,null,"Let us look at the Abrasives Industry (which was picked randomly) which has a fairly uniform product, the relationship between the five-year average ROCE and Price/Book Value is fairly consistent with the findings above."]
[null,"Trading is about moving the capital quickly across positions, evaluating them as you go along. If you merely buy & sell without that agility it is your broker who will make the money, not you.",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,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,null,"Next time you look at a stock, don’t forget to look at its long term ROCE – it’ll give you an insight about the inherent strength of the company’s business, and its ability to squeeze value from every rupee of capital. That will not only determine its valuation but also the price performance."]
[]
[null,"Particpate in the market with the power of information and preparedness. There are sensible approaches for discerning investor to participate in the value that businesses create"]
[]
[]
[null,"When your stock falls, ask yourself. Is it critical to its survival or is it just a temporary patch? If it is temporary, your stock will most likely pass through the tough phase. As you go about investing, always keep in mind, every good stock will have bad days."]
[]
[]
[]
[null,"Good investing means being prepared for an environment different than what we thought and keeping Plan B ready. Predit less and plan more."]
[null,"Accept that market and returns have cycles. What goes up will go down."]
[]
[null,"Invest in companies with share of mind among consumers. These companies have pricing power and a unique moat. The consumers keep coming back to these products"]
[null,"A vast majority of customers will have something positive about the company"]
[]
[null,"The art of valuation"]
[null,"1.Analysts need to be careful of and fix their own internal flaws, keeping emotions in check. Steering clear of the overconfidence mind trap, the heuristics mind trap, confirmation bias, and the like would keep you in good stead. “Make sure we know there’s always a different view on a particular stock,” Valentine states"]
[]
[]
[]
[null,"2.It is essential to get a grasp on expectations and concerns of market participants and where those fit into the larger market outlook."]
[]
[]
[null,"3.Don’t change price target unless there is ample reason, whether a revised forecast, a revised multiple, or a new valuation method. Another critical point: If you’re going to change your price target, don’t do it incrementally."]
[]
[]
[]
[null,"4.Which factors are going to move my stocks and where can I get unique insights on these factors?"]
[]
[]
[]
[null,"The art of building portfolio"]
[null,"Across all sizes (large, mid and small)"]
[null,"Aggregation of risk in portfolio from a SINGLE EVENT"]
[null,"Maximum exposure 10%. Nothing goes above 15%"]
[null,"#stocks 15-20"]
[null,"Emerging moat business 2-3% weight"]
[]
[]
[null,"Behavior Science"]
[null,"I know it all - You should be realistic about your abilities than carry any misguided conviction that anything you will touch will turn in gold. "]
[null,"The tendency to accumulate a particular type of investment is the outcome of such a bias."]
[null,"Don't be carried away thinking the outcome is a result of your ability & skill"]
[]
[null,"Mental maths - Risk & returns are two sides of the coin. Don't be misguided by seeing only one side of the coin."]
[]
[null,"Why did I do that? Do not get carried away with your prediction having come true, even when you have not gained from the decision. "]
[null,"Instead of regretting your decision, treat it as a lesson for the future."]
[null,"If you are unsure of your action, postpone taking a decision."]
[null,"Betting on a sector that is out of favor because you feel its cheap is a avoidable mistake"]
[]
[null,"Instant gratification - Learn to defer decisions that involve spending.Never rush or make hasty decisions with money."]
[]
[null,"Make the right moves - Keep yourself up-to-date in your profession to ensure your job is not in the line of fire."]
[null,"Do not borrow when you have money sitting in an instrument that earns lesser"]
[null,"As much as possible, borrow to acquire assets that appreciate in value."]
[]
[null,"You cant do it all - Do not live with the belief that you can do everything on your own."]