Projected Income Statement: Tata Power Company Limited

Forecast Balance Sheet: Tata Power Company Limited

Fiscal Period: March 2021 2022 2023 2024 2025 2026 2027 2028
Net Debt 1 3,50,962 4,36,425 3,77,679 4,03,279 4,63,946 5,86,127 6,68,471 8,50,852
Change - 24.35% -13.46% 6.78% 15.04% 26.34% 14.05% 27.28%
Announcement Date 12/05/21 06/05/22 04/05/23 08/05/24 14/05/25 - - -
1INR in Million
Estimates

Cash Flow Forecast: Tata Power Company Limited

Fiscal Period: March 2021 2022 2023 2024 2025 2026 2027 2028
CAPEX 1 33,358 72,679 76,560 1,33,328 1,32,410 2,19,498 2,28,177 1,99,881
Change - 117.88% 5.34% 74.15% -0.69% 65.77% 3.95% -12.4%
Free Cash Flow (FCF) 1 51,222 -5,751 -4,969 -7,366 -45,926 -89,043 -56,683 17,128
Change - -111.23% 13.61% -48.25% -523.46% -93.88% 36.34% 130.22%
Announcement Date 12/05/21 06/05/22 04/05/23 08/05/24 14/05/25 - - -
1INR in Million
Estimates

Forecast Financial Ratios: Tata Power Company Limited

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

Profitability

        
EBITDA Margin (%) 22.91% 16.63% 15.26% 17.19% 20.34% 20.8% 21.76% 23.33%
EBIT Margin (%) 14.57% 9.49% 9.18% 11.21% 18.71% 14.03% 14.69% 16.18%
EBT Margin (%) 6.04% 6.87% 9.65% 9.06% 9.43% 9.3% 9.49% 10.06%
Net margin (%) 3.43% 3.98% 5.9% 5.84% 5.93% 6.77% 7.04% 7.15%
FCF margin (%) 15.57% -1.32% -0.88% -1.16% -6.86% -12.26% -7.17% 2.06%
FCF / Net Income (%) 454.35% -33.03% -14.89% -19.93% -115.65% -181.08% -101.82% 28.81%

Profitability

        
ROA 1.2% 1.64% 2.77% 2.76% 2.68% 4.09% 4.57% 2.94%
ROE 5.96% 7.78% 13.03% 12.09% 11.65% 12.98% 13.15% 12.41%

Financial Health

        
Leverage (Debt/EBITDA) 4.66x 6x 4.38x 3.71x 3.41x 3.88x 3.88x 4.39x
Debt / Free cash flow 6.85x -75.88x -76.01x -54.75x -10.1x -6.58x -11.79x 49.68x

Capital Intensity

        
CAPEX / Current Assets (%) 10.14% 16.62% 13.54% 21.07% 19.77% 30.23% 28.85% 24.06%
CAPEX / EBITDA (%) 44.25% 99.95% 88.71% 122.57% 97.18% 145.36% 132.58% 103.1%
CAPEX / FCF (%) 65.12% -1,263.69% -1,540.82% -1,809.94% -288.31% -246.51% -402.55% 1,167.02%

Items per share

        
Cash flow per share 1 28.02 20.94 22.39 39.39 39.68 63.96 90.53 -
Change - -25.25% 6.88% 75.98% 0.73% 61.19% 41.54% -
Dividend per Share 1 1.55 1.75 2 2 2.25 2.454 2.624 2.117
Change - 12.9% 14.29% 0% 12.5% 9.05% 6.96% -19.35%
Book Value Per Share 1 69.85 70.23 90.09 101.2 112.2 127 142.1 153.1
Change - 0.54% 28.29% 12.38% 10.77% 13.24% 11.89% 7.75%
EPS 1 3.17 5.36 10.43 11.56 12.41 15.04 16.94 18.61
Change - 69.09% 94.59% 10.83% 7.35% 21.17% 12.67% 9.84%
Nbr of stocks (in thousands) 31,95,340 31,95,340 31,95,340 31,95,340 31,95,340 31,95,340 31,95,340 31,95,340
Announcement Date 12/05/21 06/05/22 04/05/23 08/05/24 14/05/25 - - -
1INR
Estimates
2026 *2027 *
P/E ratio 26.6x 23.6x
PBR 3.15x 2.82x
EV / Sales 2.57x 2.46x
Yield 0.61% 0.66%
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
23
Last Close Price
400.45INR
Average target price
420.87INR
Spread / Average Target
+5.10%
Consensus

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Equities
  3. TATAPOWER Stock
  4. Financials Tata Power Company Limited