Projected Income Statement: Tata Steel Limited

Forecast Balance Sheet: Tata Steel Limited

Fiscal Period: March 2021 2022 2023 2024 2025 2026 2027 2028
Net Debt 1 6,74,789 5,11,380 7,16,989 8,00,013 8,47,534 8,01,778 7,31,723 6,53,062
Change - -24.22% 40.21% 11.58% 5.94% -5.4% -8.74% -10.75%
Announcement Date 05/05/21 03/05/22 02/05/23 29/05/24 12/05/25 - - -
1INR in Million
Estimates

Cash Flow Forecast: Tata Steel Limited

Fiscal Period: March 2021 2022 2023 2024 2025 2026 2027 2028
CAPEX 1 69,786 1,05,222 1,41,425 1,82,066 1,56,705 1,51,823 1,70,444 1,76,736
Change - 50.78% 34.41% 28.74% -13.93% -3.12% 12.27% 3.69%
Free Cash Flow (FCF) 1 3,73,481 3,38,588 7,541 20,941 78,413 1,41,601 1,81,336 2,08,117
Change - -9.34% -97.77% 177.7% 274.45% 80.58% 28.06% 14.77%
Announcement Date 05/05/21 03/05/22 02/05/23 29/05/24 12/05/25 - - -
1INR in Million
Estimates

Forecast Financial Ratios: Tata Steel Limited

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

Profitability

        
EBITDA Margin (%) 19.52% 26.02% 13.27% 9.73% 11.58% 14.78% 16.98% 17.69%
EBIT Margin (%) 13.61% 22.29% 9.44% 5.42% 6.81% 9.85% 12.23% 12.94%
EBT Margin (%) 8.86% 20.59% 7.49% -0.5% 3.85% 6.95% 9.9% 10.74%
Net margin (%) 4.79% 16.46% 3.6% -1.94% 1.57% 4.96% 6.97% 7.55%
FCF margin (%) 23.9% 13.88% 0.31% 0.91% 3.59% 6.09% 7.18% 7.89%
FCF / Net Income (%) 498.62% 84.32% 8.61% -47.19% 229.24% 122.72% 103.04% 104.46%

Profitability

        
ROA 3.27% 15.13% 3.06% -1.58% 1.35% 6.13% 8.64% 8.88%
ROE 10.97% 42.56% 8.05% -4.55% 4.09% 12.49% 16.72% 16.91%

Financial Health

        
Leverage (Debt/EBITDA) 2.21x 0.81x 2.22x 3.59x 3.35x 2.33x 1.71x 1.4x
Debt / Free cash flow 1.81x 1.51x 95.08x 38.2x 10.81x 5.66x 4.04x 3.14x

Capital Intensity

        
CAPEX / Current Assets (%) 4.47% 4.31% 5.81% 7.94% 7.17% 6.53% 6.75% 6.7%
CAPEX / EBITDA (%) 22.88% 16.57% 43.78% 81.62% 61.94% 44.19% 39.77% 37.87%
CAPEX / FCF (%) 18.69% 31.08% 1,875.41% 869.42% 199.85% 107.22% 93.99% 84.92%

Items per share

        
Cash flow per share 1 37.74 36.71 17.75 16.27 18.85 22.01 29.3 30.27
Change - -2.75% -51.65% -8.3% 15.82% 16.76% 33.14% 3.32%
Dividend per Share 1 2.5 5.1 3.6 3.6 3.6 3.673 3.961 4.199
Change - 104% -29.41% 0% 0% 2.04% 7.82% 6.01%
Book Value Per Share 1 63.22 94.65 84.41 73.78 73.09 79.41 89.15 100.7
Change - 49.73% -10.82% -12.59% -0.94% 8.65% 12.26% 13.01%
EPS 1 6.378 33.21 7.17 -3.62 2.74 9.548 13.96 15.71
Change - 420.68% -78.41% -150.49% 175.69% 248.46% 46.18% 12.58%
Nbr of stocks (in thousands) 1,19,85,893 1,22,16,159 1,22,22,312 1,24,83,532 1,24,83,527 1,24,83,527 1,24,83,527 1,24,83,527
Announcement Date 05/05/21 03/05/22 02/05/23 29/05/24 12/05/25 - - -
1INR
Estimates
2026 *2027 *
P/E ratio 21.3x 14.6x
PBR 2.56x 2.28x
EV / Sales 1.44x 1.29x
Yield 1.81% 1.95%

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
32
Last Close Price
203.20INR
Average target price
211.19INR
Spread / Average Target
+3.93%

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Equities
  3. 500470 Stock
  4. Financials Tata Steel Limited