Tata Consumer Products Ltd.

Financial

	Tata Consumer Produc	CCL Products (India)	Andrew Yule
Operational Metrics
FMCG Sector
Number of stores - Tata Cha	13.0 .	n/a	n/a
Volume growth- International coffee	0.0	n/a	n/a
Number of stores - Tata Starbucks	479.0 .	n/a	n/a
Annual Sales Volume - Tea	2.17 Million Kgs	n/a	n/a
Annual Sales Volume - Salt	1438.56 Million Kgs	n/a	n/a
Annual Sales Volume - Coffee	24.31 Million Kgs	n/a	n/a
Volume growth- India branded business	4.69 %	n/a	n/a
Volume growth- India branded business - India beverages	0.0	n/a	n/a
Volume growth- India branded business - India Foods	10.0 %	n/a	n/a
Unclassified
Volume Growth	3.49 %	n/a	n/a
Advertisement Spend as a % of Total Sales	6.49 %	n/a	n/a
Financials
5 yr Average ROE	6.6 %	16.98 %	-2.38 %
5yr average Equity Multiplier	1.5	1.75	1.83
5yr Average Asset Turnover Ratio	0.57	0.74	0.52
5yr Avg Net Profit Margin	7.69 %	13.27 %	-2.65 %
Price to Book	5.5	6.08	4.43
P/E	86.0	38.55	0.0
5yr Avg Cash Conversion Cycle	-47.26 Days	138.11 Days	-108.73 Days
Inventory Days	65.21 Days	90.94 Days	51.42 Days
Days Receivable	18.3 Days	64.52 Days	128.45 Days
Days Payable	110.21 Days	19.54 Days	212.9 Days
5yr Average Interest Coverage Ratio	16.77	11.96	0.33
5yr Avg ROCE	8.82 %	18.61 %	0.24 %
5yr Avg Operating Profit Margin	13.93 %	20.99 %	-9.13 %
5 yr average Debt to Equity	0.1	0.62	0.24
5yr CAGR Net Profit	8.34 %	8.55 %	16.97 %
5yr Average Return on Assets	4.42 %	9.81 %	-1.1 %
Shareholdings
Promoter Holding	33.84 %	46.09 %	89.25 %
Share Pledged by Promoters	0.0	0.0	0.0
Change in Promoter Holding (3 Yrs)	-0.88 %	-0.17 %	0.0
Change in Mutual Fund Holding (3 Yrs)	3.47 %	-0.17 %	0.0

Business

	Tata Consumer Produc	CCL Products (India)	Andrew Yule
Product Wise Break-Up	Product Wise Break-Up Salt 23.0 Tea 19.0 Coffee 0 Manufacturing Of Instant Coffee 0 Printing 0 Sale Of Service 0 Spares 0 Lt And Ht Switchgears 0 Industrial Fans 0 Transformers 0 Black & Packet Tea 0 Others 58.0	Product Wise Break-Up Coffee 0 Spares 0 Lt And Ht Switchgears 0 Black & Packet Tea 0 Transformers 0 Printing 0 Instant Coffee 100.0 Industrial Fans 0 Tea 0 Salt 0 Sale Of Service 0	Product Wise Break-Up Coffee 0 Spares 0 Lt And Ht Switchgears 0 Black Tea 53.48 Transformers 26.28 Printing 0 Manufacturing Of Instant Coffee 0 Industrial Fans 18.92 Tea 0 Salt 0 Service 1.11 Others 0.21
Location Wise Break-Up	Location Wise Break-Up India 73.04 USA 11.56 UK 8.57 Rest of the World 6.82 Canada 0 Others 0.01	-	-
Customer Segment	Customer Segment Branded 89.19 Non Branded 10.81	-	-
Operating Profit Break-Up	Operating Profit Break-Up India - Beverages 47.3 International Business 30.79 Non Branded Business 21.92 India - Foods 0 Engineering 0 Electrical - Chennai 0 Electrical - Kolkata 0 Tea 0	-	Operating Profit Break-Up Non Branded Business 0 Electrical - Kolkata 0 Electrical - Chennai 26.85 Tea 0 India - Beverages 0 India - Foods 0 Engineering & Capital Goods 73.15 International Business 0
Brand Wise Break-Up	Brand Wise Break-Up Indian Tea Brands 33.66 Tetley 23.96 Eight O`Clock 0 Continental coffee 0 Others 42.38	Brand Wise Break-Up Indian Tea Brands 0 Eight O`Clock 0 Coffee 55.0 Tetley 0 Others 45.0	-
Asset Break-Up - Segment Wise	Asset Break-Up - Segment Wise India 72.33 UK 11.56 USA 9.33 Others 6.78	-	-
Asset Break-Up	Asset Break-Up India - Beverages 62.79 International Business 27.51 Non Branded Business 9.7 India - Foods 0 Engineering 0 Electrical - Chennai 0 Electrical - Kolkata 0 Tea 0	-	Asset Break-Up Non Branded Business 0 Electrical - Kolkata 3.24 Electrical - Chennai 9.7 Tea 41.6 India - Beverages 0 India - Foods 0 Engineering & Capital Goods 9.68 International Business 0 Others 35.78

Tata Consumer Products Ltd.

Tata Consumer Products Ltd.

SIGN UP FOR FREE