WEBSITE BSE:500800 NSE : TATACONSUM 09 May, 16:00
Market Cap ₹103230 Cr.
Stock P/E 87.9
P/B 6.4
Current Price ₹1083.4
Book Value ₹ 168.5
Face Value 1
52W High ₹1269.6
Dividend Yield 0.72%
52W Low ₹ 756.6
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.
Price goes above X
Price falls below X
PE goes above X
PE falls below X
₹ | |
| #(Fig in Cr.) | Dec 2021 | Mar 2022 | Jun 2022 | Sep 2022 | Dec 2022 | Mar 2023 | Jun 2023 | Sep 2023 | Dec 2023 | Mar 2024 |
|---|---|---|---|---|---|---|---|---|---|---|
| Net Sales | 3208 | 3175 | 3327 | 3363 | 3475 | 3619 | 3741 | 3734 | 3804 | 3927 |
| Other Income | 25 | 47 | 35 | 29 | 49 | 55 | 58 | 90 | 60 | 38 |
| Total Income | 3233 | 3223 | 3362 | 3392 | 3523 | 3674 | 3799 | 3824 | 3864 | 3965 |
| Total Expenditure | 2747 | 2731 | 2870 | 2929 | 3021 | 3107 | 3196 | 3197 | 3232 | 3297 |
| Operating Profit | 487 | 492 | 493 | 463 | 503 | 567 | 603 | 627 | 632 | 668 |
| Interest | 16 | 16 | 16 | 20 | 24 | 28 | 26 | 28 | 33 | 43 |
| Depreciation | 70 | 72 | 73 | 73 | 75 | 83 | 82 | 94 | 86 | 116 |
| Exceptional Income / Expenses | -13 | -19 | -24 | 111 | 79 | -6 | -5 | -15 | -92 | -216 |
| Profit Before Tax | 388 | 385 | 379 | 482 | 482 | 450 | 489 | 491 | 422 | 294 |
| Provision for Tax | 100 | 95 | 103 | 127 | 113 | 105 | 131 | 132 | 106 | 26 |
| Profit After Tax | 288 | 289 | 277 | 355 | 369 | 346 | 359 | 359 | 316 | 268 |
| Adjustments | -23 | -72 | -21 | -27 | -18 | -77 | -42 | -21 | -37 | -51 |
| Profit After Adjustments | 265 | 218 | 255 | 328 | 352 | 269 | 317 | 338 | 279 | 217 |
| Adjusted Earnings Per Share | 2.9 | 2.4 | 2.8 | 3.6 | 3.8 | 2.9 | 3.4 | 3.6 | 3 | 2.3 |
| #(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 | 15206 |
| Other Income | 86 | 82 | 70 | 82 | 83 | 94 | 157 | 112 | 121 | 140 | 169 | 246 |
| Total Income | 7437 | 7819 | 8063 | 6719 | 6863 | 6910 | 7409 | 9749 | 11723 | 12565 | 13952 | 15452 |
| Total Expenditure | 6582 | 6986 | 7219 | 5982 | 5988 | 5976 | 6466 | 8345 | 10058 | 10707 | 11927 | 12922 |
| Operating Profit | 854 | 834 | 845 | 736 | 874 | 933 | 943 | 1404 | 1665 | 1859 | 2025 | 2530 |
| Interest | 84 | 87 | 82 | 117 | 92 | 43 | 52 | 78 | 69 | 73 | 87 | 130 |
| Depreciation | 105 | 129 | 133 | 117 | 126 | 116 | 123 | 242 | 255 | 278 | 304 | 378 |
| Exceptional Income / Expenses | -28 | 89 | -130 | -333 | 5 | -21 | -33 | -275 | -31 | -52 | 159 | -328 |
| Profit Before Tax | 637 | 707 | 500 | 170 | 662 | 753 | 735 | 809 | 1311 | 1456 | 1794 | 1696 |
| Provision for Tax | 164 | 184 | 216 | 200 | 198 | 186 | 261 | 274 | 317 | 377 | 447 | 395 |
| Profit After Tax | 473 | 522 | 284 | -30 | 464 | 567 | 474 | 535 | 994 | 1079 | 1347 | 1302 |
| Adjustments | -100 | -42 | -37 | 25 | -74 | -72 | -66 | -75 | -137 | -143 | -143 | -151 |
| Profit After Adjustments | 373 | 481 | 248 | -6 | 389 | 496 | 408 | 460 | 857 | 936 | 1204 | 1151 |
| Adjusted Earnings Per Share | 6 | 7.8 | 4 | -0.1 | 6.2 | 7.9 | 6.5 | 5 | 9.3 | 10.2 | 13 | 12.3 |
| # | 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 | 37% | 20% | 40% | 22% |
| ROE Average | 9% | 8% | 7% | 7% |
| ROCE Average | 11% | 10% | 9% | 9% |
| #(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 | 1540 | 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 | 12367 | 12855 |
| Other Non-Current Assets | 750 | 874 | 2241 | 1490 | 1694 | 1178 | 1471 | 1185 | 1179 | 1572 | 1599 |
| Total Current Assets | 3609 | 3857 | 3611 | 3743 | 3302 | 4497 | 4511 | 5682 | 7049 | 7136 | 8309 |
| Total Assets | 8794 | 9911 | 10774 | 9895 | 9551 | 10460 | 10881 | 18473 | 20218 | 21075 | 22762 |
| #(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 |
| # | 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.14 | 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 |
| # | Dec 2021 | Mar 2022 | Jun 2022 | Sep 2022 | Dec 2022 | Mar 2023 | Jun 2023 | Sep 2023 | Dec 2023 | Mar 2024 |
|---|---|---|---|---|---|---|---|---|---|---|
| Promoter | 34.68 | 34.68 | 34.68 | 34.68 | 34.41 | 34.41 | 34.41 | 34.41 | 34.41 | 33.55 |
| FII | 25.65 | 25.34 | 25.3 | 25.56 | 25.55 | 25.01 | 25.36 | 25.26 | 25.61 | 25.45 |
| DII | 13.4 | 13.7 | 13.99 | 14.9 | 15.12 | 15.84 | 16.32 | 16.88 | 17.07 | 17.39 |
| Public | 26.17 | 26.18 | 25.93 | 24.75 | 24.8 | 24.62 | 23.79 | 23.43 | 22.89 | 23.58 |
| Others | 0.09 | 0.1 | 0.1 | 0.11 | 0.12 | 0.11 | 0.12 | 0.03 | 0.03 | 0.03 |
| Total | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
| # | Dec 2021 | Mar 2022 | Jun 2022 | Sep 2022 | Dec 2022 | Mar 2023 | Jun 2023 | Sep 2023 | Dec 2023 | Mar 2024 |
|---|---|---|---|---|---|---|---|---|---|---|
| Promoter | 31.96 | 31.96 | 31.96 | 31.96 | 31.96 | 31.96 | 31.96 | 31.96 | 31.96 | 31.96 |
| FII | 23.64 | 23.35 | 23.32 | 23.55 | 23.74 | 23.24 | 23.56 | 23.47 | 23.79 | 24.25 |
| DII | 12.35 | 12.63 | 12.89 | 13.73 | 14.05 | 14.72 | 15.16 | 15.68 | 15.85 | 16.57 |
| Public | 24.12 | 24.13 | 23.9 | 22.8 | 23.04 | 22.88 | 22.1 | 21.76 | 21.26 | 22.47 |
| Others | 0.09 | 0.09 | 0.09 | 0.11 | 0.11 | 0.11 | 0.11 | 0.03 | 0.03 | 0.03 |
| Total | 92.16 | 92.16 | 92.16 | 92.16 | 92.9 | 92.9 | 92.9 | 92.9 | 92.9 | 95.28 |
Pros
Cons
* 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.
Sell or Purchase Share (Tentative Price)
| Companies | Open Date | Close Date | Issue Price | Cost of 1 Lot | GMP | Expected Listing | Listing Gain(%) | Listing Price | Current Price | Type | Exchange |
|---|
| Companies | Open Date | Close Date | Issue Price | Cost of 1 Lot | GMP | Expected Listing | Listing Gain(%) | Listing Price | Current Price | Type | Exchange |
|---|
| Companies | Open Date | Close Date | Issue Price | Cost of 1 Lot | GMP | Expected Listing | Listing Gain(%) | Listing Price | Current Price | Type | Exchange |
|---|
| Companies | Open Date | Close Date | Issue Price | Cost of 1 Lot | GMP | Expected Listing | Listing Gain(%) | Listing Price | Current Price | Type | Exchange |
|---|
| Companies | Open Date | Close Date | Issue Price | Cost of 1 Lot | GMP | Expected Listing | Listing Gain(%) | Listing Price | Current Price | Type | Exchange |
|---|
You May Also Know About
