Tata Consumer Products Ltd.

Financial

	Tata Consumer Produc	CCL Products (India)	Vintage Coffee & Bev
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.56 %	-0.32 %
5yr average Equity Multiplier	1.5	1.86	2.12
5yr Average Asset Turnover Ratio	0.57	0.74	0.29
5yr Avg Net Profit Margin	7.69 %	12.35 %	-6.09 %
Price to Book	5.31	5.8	6.65
P/E	80.29	36.76	40.4
5yr Avg Cash Conversion Cycle	-47.26 Days	146.14 Days	205.92 Days
Inventory Days	65.21 Days	97.75 Days	375.69 Days
Days Receivable	18.3 Days	69.76 Days	47.03 Days
Days Payable	110.21 Days	20.56 Days	90.4 Days
5yr Average Interest Coverage Ratio	16.77	10.07	1.04
5yr Avg ROCE	8.82 %	18.23 %	3.51 %
5yr Avg Operating Profit Margin	13.93 %	19.55 %	10.49 %
5 yr average Debt to Equity	0.1	0.71	0.86
5yr CAGR Net Profit	8.34 %	11.23 %	n/a
5yr Average Return on Assets	4.42 %	9.08 %	0.25 %
Shareholdings
Promoter Holding	33.84 %	46.09 %	38.68 %
Share Pledged by Promoters	0.0	0.0	26.61 %
Change in Promoter Holding (3 Yrs)	-0.88 %	-0.17 %	-33.54 %
Change in Mutual Fund Holding (3 Yrs)	3.76 %	-2.33 %	2.32 %

Business

	Tata Consumer Produc	CCL Products (India)	Vintage Coffee & Bev
Product Wise Break-Up	Product Wise Break-Up Salt 23.0 Tea 19.0 Coffee 0 Manufacturing Of Instant Coffee 0 Instant Coffee 0 Others 58.0	Product Wise Break-Up Coffee 0 Salt 0 Instant Coffee 100.0 Tea 0 Instant Coffee 0	Product Wise Break-Up Coffee 0 Salt 0 Manufacturing Of Instant Coffee 0 Tea 0 Instant Coffee 100.0
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 Domestic 0 Others 0.01	-	Location Wise Break-Up India 26.62 UK 0 USA 0 Canada 0 India 0 Rest of the World 0 Others 73.38
Customer Segment	Customer Segment Branded 88.85 Non Branded 11.15	-	-
Operating Profit Break-Up	Operating Profit Break-Up India - Beverages 56.99 International Business 30.34 Non Branded Business 12.67 India - Foods 0	-	-
Brand Wise Break-Up	Brand Wise Break-Up Indian Tea Brands 34.46 Tetley 22.47 Eight O`Clock 0 Continental coffee 0 Others 43.07	Brand Wise Break-Up Tetley 0 Coffee 55.0 Eight O`Clock 0 Indian Tea Brands 0 Others 45.0	-
Asset Break-Up - Segment Wise	Asset Break-Up - Segment Wise India 69.73 USA 11.91 UK 11.25 Others 7.11	-	-
Asset Break-Up	Asset Break-Up India - Beverages 61.0 International Business 28.98 Non Branded Business 10.03 India - Foods 0	-	-