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 791,338 730,613 677,347
Change - -24.22% 40.21% 11.58% 5.94% -6.63% -7.67% -7.29%
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 152,632 161,538 172,257
Change - 50.78% 34.41% 28.74% -13.93% -2.6% 5.83% 6.64%
Free Cash Flow (FCF) 1 373,481 338,588 7,541 20,941 78,413 117,771 163,791 174,797
Change - -9.34% -97.77% 177.7% 274.45% 50.19% 39.08% 6.72%
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% 15.31% 16.21% 16.72%
EBIT Margin (%) 13.61% 22.29% 9.44% 5.42% 6.81% 10.51% 11.48% 11.74%
EBT Margin (%) 8.86% 20.59% 7.49% -0.5% 3.85% 8.29% 9.33% 9.84%
Net margin (%) 4.79% 16.46% 3.6% -1.94% 1.57% 5.61% 6.67% 7.24%
FCF margin (%) 23.9% 13.88% 0.31% 0.91% 3.59% 5% 6.51% 6.91%
FCF / Net Income (%) 498.62% 84.32% 8.61% -47.19% 229.24% 89.21% 97.66% 95.48%

Profitability

        
ROA 3.27% 15.13% 3.06% -1.58% 1.35% 6.26% 7.1% 6.91%
ROE 10.97% 42.56% 8.05% -4.55% 4.09% 13.39% 15.35% 15%

Financial Health

        
Leverage (Debt/EBITDA) 2.21x 0.81x 2.22x 3.59x 3.35x 2.2x 1.79x 1.6x
Debt / Free cash flow 1.81x 1.51x 95.08x 38.2x 10.81x 6.72x 4.46x 3.88x

Capital Intensity

        
CAPEX / Current Assets (%) 4.47% 4.31% 5.81% 7.94% 7.17% 6.48% 6.42% 6.81%
CAPEX / EBITDA (%) 22.88% 16.57% 43.78% 81.62% 61.94% 42.35% 39.62% 40.73%
CAPEX / FCF (%) 18.69% 31.08% 1,875.41% 869.42% 199.85% 129.6% 98.62% 98.55%

Items per share

        
Cash flow per share 1 37.74 36.71 17.75 16.27 18.85 23.32 24.54 26.67
Change - -2.75% -51.65% -8.3% 15.82% 23.73% 5.24% 8.67%
Dividend per Share 1 2.5 5.1 3.6 3.6 3.6 3.639 4.283 3.953
Change - 104% -29.41% 0% 0% 1.08% 17.69% -7.69%
Book Value Per Share 1 63.22 94.65 84.41 73.78 73.09 80.43 89.46 100.2
Change - 49.73% -10.82% -12.59% -0.94% 10.04% 11.23% 11.99%
EPS 1 6.378 33.21 7.17 -3.62 2.74 10.53 13.47 14.71
Change - 420.68% -78.41% -150.49% 175.69% 284.3% 27.92% 9.2%
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 14.3x 11.2x
PBR 1.88x 1.69x
EV / Sales 1.14x 1.04x
Yield 2.41% 2.84%
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
CCC
More Ratings
Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
31
Last Close Price
150.95INR
Average target price
161.40INR
Spread / Average Target
+6.92%
Consensus

Quarterly revenue - Rate of surprise