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 674,789 511,380 716,989 800,013 847,534 803,859 742,190 675,257
Change - -24.22% 40.21% 11.58% 5.94% -5.15% -7.67% -9.02%
Announcement Date 5/5/21 5/3/22 5/2/23 5/29/24 5/12/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 105,222 141,425 182,066 156,705 150,951 160,790 166,765
Change - 50.78% 34.41% 28.74% -13.93% -3.67% 6.52% 3.72%
Free Cash Flow (FCF) 1 373,481 338,588 7,541 20,941 78,413 135,532 175,637 213,345
Change - -9.34% -97.77% 177.7% 274.45% 72.84% 29.59% 21.47%
Announcement Date 5/5/21 5/3/22 5/2/23 5/29/24 5/12/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.96% 16.66% 17.07%
EBIT Margin (%) 13.61% 22.29% 9.44% 5.42% 6.81% 10.17% 11.95% 12.37%
EBT Margin (%) 8.86% 20.59% 7.49% -0.5% 3.85% 7.43% 9.7% 10.23%
Net margin (%) 4.79% 16.46% 3.6% -1.94% 1.57% 5.07% 6.68% 7.37%
FCF margin (%) 23.9% 13.88% 0.31% 0.91% 3.59% 5.82% 7.07% 8.26%
FCF / Net Income (%) 498.62% 84.32% 8.61% -47.19% 229.24% 114.89% 105.85% 112.08%

Profitability

        
ROA 3.27% 15.13% 3.06% -1.58% 1.35% 5.47% 6.83% 7%
ROE 10.97% 42.56% 8.05% -4.55% 4.09% 12.26% 15.65% 16.06%

Financial Health

        
Leverage (Debt/EBITDA) 2.21x 0.81x 2.22x 3.59x 3.35x 2.31x 1.79x 1.53x
Debt / Free cash flow 1.81x 1.51x 95.08x 38.2x 10.81x 5.93x 4.23x 3.17x

Capital Intensity

        
CAPEX / Current Assets (%) 4.47% 4.31% 5.81% 7.94% 7.17% 6.49% 6.47% 6.46%
CAPEX / EBITDA (%) 22.88% 16.57% 43.78% 81.62% 61.94% 43.37% 38.82% 37.84%
CAPEX / FCF (%) 18.69% 31.08% 1,875.41% 869.42% 199.85% 111.38% 91.55% 78.17%

Items per share

        
Cash flow per share 1 37.74 36.71 17.75 16.27 18.85 22.72 27.64 28.39
Change - -2.75% -51.65% -8.3% 15.82% 20.52% 21.66% 2.72%
Dividend per Share 1 2.5 5.1 3.6 3.6 3.6 3.768 3.859 4.003
Change - 104% -29.41% 0% 0% 4.66% 2.43% 3.73%
Book Value Per Share 1 63.22 94.65 84.41 73.78 73.09 79.76 89.16 100.7
Change - 49.73% -10.82% -12.59% -0.94% 9.13% 11.79% 12.91%
EPS 1 6.378 33.21 7.17 -3.62 2.74 9.882 13.27 15.11
Change - 420.68% -78.41% -150.49% 175.69% 260.65% 34.31% 13.82%
Nbr of stocks (in thousands) 11,985,893 12,216,159 12,222,312 12,483,532 12,483,527 12,483,527 12,483,527 12,483,527
Announcement Date 5/5/21 5/3/22 5/2/23 5/29/24 5/12/25 - - -
1INR
Estimates
2026 *2027 *
P/E ratio 17.4x 13x
PBR 2.16x 1.93x
EV / Sales 1.27x 1.16x
Yield 2.19% 2.25%
More valuation ratios * Estimated data

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Trader
Investor
Global
Quality
ESG MSCI
CCC
More Ratings
Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
32
Last Close Price
166.35INR
Average target price
184.97INR
Spread / Average Target
+11.19%
Consensus

Quarterly revenue - Rate of surprise

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