Projected Income Statement: Tata Consumer Products Limited

Forecast Balance Sheet: Tata Consumer Products Limited

Fiscal Period: March 2021 2022 2023 2024 2025 2026 2027 2028
Net Debt 1 -24,047 -13,859 -23,689 2,607 -8,773 -20,934 -30,385 -45,411
Change - 42.37% -70.93% 111.01% -436.52% -138.62% -45.15% -49.45%
Announcement Date 06/05/21 04/05/22 25/04/23 23/04/24 23/04/25 08/05/26 - -
1INR in Million
Estimates

Cash Flow Forecast: Tata Consumer Products Limited

Fiscal Period: March 2021 2022 2023 2024 2025 2026 2027 2028
CAPEX 1 2,107 2,733 3,118 3,102 4,595 4,526 4,477 5,139
Change - 29.74% 14.05% -0.49% 48.13% -1.5% -1.1% 14.8%
Free Cash Flow (FCF) 1 14,457 12,425 11,495 16,264 15,971 15,765 20,209 23,983
Change - -14.06% -7.48% 41.49% -1.8% -1.29% 28.19% 18.68%
Announcement Date 06/05/21 04/05/22 25/04/23 23/04/24 23/04/25 - - -
1INR in Million
Estimates

Forecast Financial Ratios: Tata Consumer Products Limited

Fiscal Period: March 2021 2022 2023 2024 2025 2026 2027 2028

Profitability

        
EBITDA Margin (%) 13.31% 13.83% 13.47% 15.02% 14.07% 13.76% 14.66% 15.3%
EBIT Margin (%) 11.11% 11.6% 11.26% 12.54% 10.66% 10.67% 11.82% 12.78%
EBT Margin (%) 11.3% 11.72% 13.01% 11.15% 10.08% 10.71% 12.3% 13.12%
Net margin (%) 7.38% 7.53% 8.73% 7.57% 7.26% 7.6% 8.82% 9.68%
FCF margin (%) 12.46% 10% 8.34% 10.7% 9.07% 7.86% 8.96% 9.73%
FCF / Net Income (%) 168.75% 132.77% 95.49% 141.39% 124.92% 97.68% 101.6% 100.45%

Profitability

        
ROA - 4.77% 4.94% 4.53% 4.26% 4.95% 5.75% 6.27%
ROE 6.04% 6.65% 6.9% 7.12% 7.09% 7.74% 8.51% 10.2%

Financial Health

        
Leverage (Debt/EBITDA) - - - 0.11x - - - -
Debt / Free cash flow - - - 0.16x - - - -

Capital Intensity

        
CAPEX / Current Assets (%) 1.82% 2.2% 2.26% 2.04% 2.61% 2.26% 1.98% 2.08%
CAPEX / EBITDA (%) 13.65% 15.9% 16.79% 13.58% 18.53% 16.28% 13.54% 13.62%
CAPEX / FCF (%) 14.57% 22% 27.12% 19.07% 28.77% 28.71% 22.15% 21.43%

Items per share

        
Cash flow per share 1 17.98 16.45 15.81 20.73 21.01 19.98 25.5 29.87
Change - -8.53% -3.91% 31.17% 1.34% -4.89% 27.59% 17.15%
Dividend per Share 1 4.05 6.05 8.45 7.75 8.25 9.259 10.71 12.17
Change - 49.38% 39.67% -8.28% 6.45% 12.23% 15.72% 13.57%
Book Value Per Share 1 157.7 164.3 176 168.5 202.1 209.1 239.8 236.6
Change - 4.18% 7.15% -4.28% 19.95% 3.44% 14.69% -1.34%
EPS 1 9.3 10.15 13.02 12.32 13.06 15.58 19.75 24.04
Change - 9.14% 28.28% -5.38% 6.01% 19.3% 21.26% 21.72%
Nbr of stocks (in thousands) 9,21,552 9,21,553 9,28,536 9,52,835 9,89,499 9,89,562 9,89,562 9,89,562
Announcement Date 06/05/21 04/05/22 25/04/23 23/04/24 23/04/25 08/05/26 - -
1INR
Estimates
2026 2027 *
P/E ratio 65.1x 59.5x
PBR 5.63x 4.91x
EV / Sales 4.95x 5.02x
Yield 0.79% 0.91%

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Trader
Investor
Global
Quality
ESG MSCI
A
Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
28
Last Close Price
1,176.20INR
Average target price
1,292.89INR
Spread / Average Target
+9.92%

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Equities
  3. TATACONSUM Stock
  4. Financials Tata Consumer Products Limited