Tata Consumer Produc

₹799.5 -7.8 | 1%

WEBSITE BSE:500800 NSE : TATACONSUM 09 Jun, 14:19

Market Cap ₹74344 Cr.

Stock P/E 61.5

P/B 4.6

Current Price ₹799.5

Book Value ₹ 174.9

Face Value 1

52W High ₹861.4

Dividend Yield 1.06%

52W Low ₹ 685

Edit Ratio

Tata Consumer Produc Research see more...

Tata Consumer Products Limited

Equity Research : Tata Consumer Products Limited

Overview Inc. Year: 1962Industry: Tea/Coffee

Tata Consumer Products Ltd is an India-based enterprise that is engaged in the trading, production and distribution of consumer products. The Company operates thru 2 segments: Branded and Non Branded. Branded segment is sub-categorised as India liquids, India foods and worldwide beverages. India beverages is in the sale of branded tea, coffee and water. India foods is engaged within the sale of food merchandise. International beverages are in the sale of branded tea, coffee and water. The Company has branded beverage business in India, Europe, United States, Canada and Australia, and meals commercial enterprise in India. Non Branded segment is in plantation and extraction business for tea, coffee and other produce in India, Vietnam and the United States.

Tata Consumer Produc Share Price

Volume

Price

Price: NSE50 DMA200 DMAVolume

Quarterly Price

Quarterly Monthly

Show Value Show %

Peer Comparison

Tata Consumer Produc Quarterly Results

#(Fig in Cr.)	Dec 2020	Mar 2021	Jun 2021	Sep 2021	Dec 2021	Mar 2022	Jun 2022	Sep 2022	Dec 2022	Mar 2023
Net Sales	3070	3037	3008	3033	3208	3175	3327	3363	3475	3619
Other Income	19	43	28	40	25	47	35	29	49	55
Total Income	3089	3080	3036	3073	3233	3223	3362	3392	3523	3674
Total Expenditure	2708	2737	2609	2620	2747	2731	2870	2929	3021	3107
Operating Profit	381	343	428	453	487	492	493	463	503	567
Interest	18	15	20	20	16	16	16	20	24	28
Depreciation	64	66	67	69	70	72	73	73	75	83
Exceptional Income / Expenses	-6	-64	-4	-16	-13	-19	-24	111	79	-6
Profit Before Tax	292	198	336	348	388	385	379	482	482	450
Provision for Tax	55	65	96	86	100	95	103	127	113	105
Profit After Tax	237	133	241	261	288	289	277	355	369	346
Adjustments	-19	-79	-56	7	-23	-72	-21	-27	-18	-77
Profit After Adjustments	218	54	185	268	265	218	255	328	352	269
Adjusted Earnings Per Share	2.4	0.6	2	2.9	2.9	2.4	2.8	3.6	3.8	2.9

Tata Consumer Produc Profit & Loss

#(Fig in Cr.)	Mar 2013	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	Mar 2022	Mar 2023	TTM
Net Sales	7351	7738	7993	6637	6780	6815	7252	9637	11602	12425	13783	13784
Other Income	86	82	70	82	83	94	157	112	121	140	169	168
Total Income	7437	7819	8063	6719	6863	6910	7409	9749	11723	12565	13952	13951
Total Expenditure	6582	6986	7219	5982	5988	5976	6466	8345	10058	10707	11927	11927
Operating Profit	854	834	845	736	874	933	943	1404	1665	1859	2025	2026
Interest	84	87	82	117	92	43	52	78	69	73	87	88
Depreciation	105	129	133	117	126	116	123	242	255	278	304	304
Exceptional Income / Expenses	-28	89	-130	-333	5	-21	-33	-275	-31	-52	159	160
Profit Before Tax	637	707	500	170	662	753	735	809	1311	1456	1794	1793
Provision for Tax	164	184	216	200	198	186	261	274	317	377	447	448
Profit After Tax	473	522	284	-30	464	567	474	535	994	1079	1347	1347
Adjustments	-100	-42	-37	25	-74	-72	-66	-75	-137	-143	-143	-143
Profit After Adjustments	373	481	248	-6	389	496	408	460	857	936	1204	1204
Adjusted Earnings Per Share	6	7.8	4	-0.1	6.2	7.9	6.5	5	9.3	10.2	13	13.1

Growth Rates

#	1 Year	3 Year	5 Year	10 Year
Sales CAGR	11%	13%	15%	6%
Operating Profit CAGR	9%	13%	17%	9%
PAT CAGR	25%	36%	19%	11%

#	1 Year	3 Year	5 Year	10 Year
Share Price CAGR	6%	28%	25%	19%
ROE Average	9%	8%	7%	7%
ROCE Average	11%	10%	9%	9%

Tata Consumer Produc Balance Sheet

#(Fig in Cr.)	Mar 2013	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	Mar 2022	Mar 2023
Shareholder's Funds	4810	5849	5493	6247	6266	7032	7332	13815	14535	15142	16277
Minority's Interest	814	924	876	862	920	1009	1028	1092	1093	1152	850
Borrowings	673	1054	884	504	450	656	787	795	288	242	206
Other Non-Current Liabilities	350	345	1723	378	351	167	264	792	1209	1367	1505
Total Current Liabilities	2148	1739	1798	1904	1565	1586	1458	1979	3094	3173	3925
Total Liabilities	8794	9911	10774	9895	9551	10460	10881	18473	20218	21075	22762
Fixed Assets	4434	5181	4922	4662	4504	4748	4862	11606	11990	12582	13070
Other Non-Current Assets	750	874	2241	1490	1694	1178	1471	1185	1179	1357	1384
Total Current Assets	3609	3857	3611	3743	3330	4497	4511	5682	7049	7136	8309
Total Assets	8794	9911	10774	9895	9551	10460	10881	18473	20218	21075	22762

Tata Consumer Produc Cash Flow

#(Fig in Cr.)	Mar 2013	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	Mar 2022	Mar 2023
Opening Cash & Cash Equivalents	278	661	718	355	334	404	698	737	889	1773	977
Cash Flow from Operating Activities	173	422	418	116	741	356	210	1082	1656	1516	1461
Cash Flow from Investing Activities	16	-120	-175	121	225	-74	73	-673	-408	-1322	-828
Cash Flow from Financing Activities	186	-363	-392	-282	-816	-30	-224	-308	-426	-995	-714
Net Cash Inflow / Outflow	375	-62	-149	-45	150	251	59	101	822	-801	-81
Closing Cash & Cash Equivalent	661	718	537	334	404	698	737	889	1773	977	890

Tata Consumer Produc Ratios

#	Mar 2013	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	Mar 2022	Mar 2023
Earnings Per Share (Rs)	6.03	7.77	4.01	-0.09	6.17	7.85	6.47	4.99	9.3	10.15	12.96
CEPS(Rs)	9.34	10.53	6.75	1.37	9.34	10.83	9.45	8.43	13.55	14.72	17.77
DPS(Rs)	2.15	2.25	2.25	2.25	2.35	2.5	2.5	2.7	4.05	6.05	8.45
Book NAV/Share(Rs)	77.08	93.9	88.14	98.64	98.93	111.07	115.83	149.66	157.47	164.06	174.92
Core EBITDA Margin(%)	10.45	9.72	9.69	9.86	11.67	12.31	10.84	13.41	13.31	13.83	13.47
EBIT Margin(%)	9.81	10.25	7.28	4.32	11.11	11.68	10.86	9.21	11.89	12.3	13.65
Pre Tax Margin(%)	8.66	9.13	6.25	2.56	9.76	11.05	10.13	8.4	11.3	11.72	13.01
PAT Margin (%)	6.43	6.75	3.56	-0.46	6.84	8.32	6.53	5.55	8.57	8.68	9.77
Cash Profit Margin (%)	7.86	8.42	5.22	1.3	8.7	10.03	8.22	8.06	10.76	10.92	11.98
ROA(%)	5.54	5.59	2.75	-0.29	4.77	5.67	4.44	3.65	5.14	5.23	6.14
ROE(%)	10.18	9.88	5.05	-0.52	7.44	8.56	6.62	5.07	7.02	7.28	8.58
ROCE(%)	12.44	11.84	8.3	3.99	10.32	10.54	9.53	7.55	8.97	9.6	11.21
Receivable days	33.88	32.25	29	33.23	31.9	33.22	33.44	30.35	26.49	23.45	21.63
Inventory Days	63.14	68.43	71.77	89.49	82.96	77.69	76.97	62.91	62.31	66.32	65.78
Payable days	93.49	89.13	82.89	81.51	81.6	79.14	68.78	60.48	75.41	102.86	113.88
PER(x)	21.24	19.3	37.21	0	24.35	32.91	31.41	59.09	68.69	76.55	54.8
Price/Book(x)	1.66	1.6	1.69	1.23	1.52	2.33	1.75	1.97	4.05	4.74	4.06
Dividend Yield(%)	1.68	1.5	1.51	1.86	1.56	0.97	1.23	0.92	0.63	0.78	1.19
EV/Net Sales(x)	1.17	1.29	1.25	1.28	1.43	2.37	1.78	2.78	4.91	5.64	4.67
EV/Core EBITDA(x)	10.07	11.98	11.84	11.53	11.09	17.3	13.71	19.09	34.22	37.68	31.77
Net Sales Growth(%)	10.71	5.26	3.31	-16.97	2.15	0.53	6.4	32.9	20.39	7.1	10.93
EBIT Growth(%)	12	10	-26.68	-50.72	162.85	5.63	-1.09	12.71	55.51	10.8	23.02
PAT Growth(%)	9.45	10.5	-45.56	-110.64	1632.73	22.35	-16.47	12.95	85.69	8.57	24.8
EPS Growth(%)	4.66	28.91	-48.43	-102.18	7152.34	27.25	-17.63	-22.87	86.34	9.23	27.61
Debt/Equity(x)	0.29	0.25	0.24	0.22	0.13	0.15	0.16	0.09	0.08	0.07	0.07
Current Ratio(x)	1.68	2.22	2.01	1.97	2.13	2.84	3.09	2.87	2.28	2.25	2.12
Quick Ratio(x)	1.04	1.34	1.1	1.11	1.2	1.92	1.99	2.01	1.55	1.53	1.43
Interest Cover(x)	8.54	9.17	7.11	2.45	8.23	18.61	15	11.4	20.09	21.01	21.58
Total Debt/Mcap(x)	0.18	0.16	0.14	0.18	0.08	0.07	0.09	0.05	0.02	0.01	0.02

Tata Consumer Produc Shareholding Pattern

#	Dec 2020	Mar 2021	Jun 2021	Sep 2021	Dec 2021	Mar 2022	Jun 2022	Sep 2022	Dec 2022	Mar 2023
Promoter	34.68	34.68	34.68	34.68	34.68	34.68	34.68	34.68	34.41	34.41
FII	25.66	25.22	25	25.91	25.65	25.34	25.3	25.56	25.55	25.01
DII	13.62	12.55	13.98	13.3	13.4	13.7	13.99	14.9	15.12	15.84
Public	25.95	27.46	26.25	26.02	26.17	26.18	25.93	24.75	24.8	24.62
Others	0.09	0.09	0.08	0.09	0.09	0.1	0.1	0.11	0.12	0.11
Total	100	100	100	100	100	100	100	100	100	100

#	Dec 2020	Mar 2021	Jun 2021	Sep 2021	Dec 2021	Mar 2022	Jun 2022	Sep 2022	Dec 2022	Mar 2023
Promoter	31.96	31.96	31.96	31.96	31.96	31.96	31.96	31.96	31.96	31.96
FII	23.65	23.24	23.04	23.88	23.64	23.35	23.32	23.55	23.74	23.24
DII	12.55	11.57	12.88	12.26	12.35	12.63	12.89	13.73	14.05	14.72
Public	23.91	25.31	24.19	23.98	24.12	24.13	23.9	22.8	23.04	22.88
Others	0.08	0.08	0.08	0.08	0.09	0.09	0.09	0.11	0.11	0.11
Total	92.16	92.16	92.16	92.16	92.16	92.16	92.16	92.16	92.9	92.9

Pros

Company has reduced debt.
Company is almost debt free.

Cons

Promoter holding is low: 34.41%.
Company has a low return on equity of 8% over the last 3 years.
Debtor days have increased from 102.86 to 113.88days.
Stock is trading at 4.6 times its book value.

* The pros and cons are machine generated. Pros / cons are based on a checklist to highlight important points. Please exercise caution and do your own analysis.