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 -24,357 -38,254 -57,880
Change - 42.37% -70.93% 111.01% -436.52% -177.64% -57.06% -51.3%
Announcement Date 06/05/21 04/05/22 25/04/23 23/04/24 23/04/25 - - -
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,830 4,878 5,302
Change - 29.74% 14.05% -0.49% 48.13% 5.11% 0.98% 8.7%
Free Cash Flow (FCF) 1 14,457 12,425 11,495 16,264 15,971 18,029 20,831 23,363
Change - -14.06% -7.48% 41.49% -1.8% 12.89% 15.54% 12.15%
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% 14.84% 15.57% 15.92%
EBIT Margin (%) 11.11% 11.6% 11.26% 12.54% 10.66% 11.84% 12.6% 13.13%
EBT Margin (%) 11.3% 11.72% 13.01% 11.15% 10.08% 12.14% 13.17% 14.1%
Net margin (%) 7.38% 7.53% 8.73% 7.57% 7.26% 8.83% 9.7% 10.42%
FCF margin (%) 12.46% 10% 8.34% 10.7% 9.07% 9.22% 9.62% 9.83%
FCF / Net Income (%) 168.75% 132.77% 95.49% 141.39% 124.92% 104.39% 99.15% 94.33%

Profitability

        
ROA - 4.77% 4.94% 4.53% 4.26% 5.36% 6.09% 6.86%
ROE 6.04% 6.65% 6.9% 7.12% 7.09% 8.45% 9.85% 10.78%

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.47% 2.25% 2.23%
CAPEX / EBITDA (%) 13.65% 15.9% 16.79% 13.58% 18.53% 16.63% 14.47% 14.02%
CAPEX / FCF (%) 14.57% 22% 27.12% 19.07% 28.77% 26.79% 23.42% 22.69%

Items per share

        
Cash flow per share 1 17.98 16.45 15.81 20.73 21.01 18.03 27.15 29.58
Change - -8.53% -3.91% 31.17% 1.34% -14.17% 50.55% 8.95%
Dividend per Share 1 4.05 6.05 8.45 7.75 8.25 9.642 11.24 13.87
Change - 49.38% 39.67% -8.28% 6.45% 16.87% 16.57% 23.45%
Book Value Per Share 1 157.7 164.3 176 168.5 202.1 214.3 220.7 240.5
Change - 4.18% 7.15% -4.28% 19.95% 6.02% 2.96% 8.98%
EPS 1 9.3 10.15 13.02 12.32 13.06 17.59 21.23 25.31
Change - 9.14% 28.28% -5.38% 6.01% 34.66% 20.71% 19.22%
Nbr of stocks (in thousands) 9,21,552 9,21,553 9,28,536 9,52,835 9,89,499 9,89,534 9,89,534 9,89,534
Announcement Date 06/05/21 04/05/22 25/04/23 23/04/24 23/04/25 - - -
1INR
Estimates
2026 *2027 *
P/E ratio 62.5x 51.8x
PBR 5.13x 4.98x
EV / Sales 5.44x 4.85x
Yield 0.88% 1.02%
More valuation ratios * Estimated data

EPS & Dividend

Year-on-year evolution of the PER

Year-on-year evolution of the Yield

Trading Rating
Investor Rating
ESG MSCI
A
More Ratings
Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
26
Last Close Price
1,099.90INR
Average target price
1,223.50INR
Spread / Average Target
+11.24%
Consensus

Quarterly revenue - Rate of surprise

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