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 6,23,040 7,34,961 8,26,376
Change - 24.35% -13.46% 6.78% 15.04% 34.29% 17.96% 12.44%
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,02,311 2,21,847 2,31,385
Change - 117.88% 5.34% 74.15% -0.69% 52.79% 9.66% 4.3%
Free Cash Flow (FCF) 1 51,222 -5,751 -4,969 -7,366 -45,926 -84,183 -64,140 -65,908
Change - -111.23% 13.61% -48.25% -523.46% -83.3% 23.81% -2.76%
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% 21.11% 22.26% 23.69%
EBIT Margin (%) 14.57% 9.49% 9.18% 11.21% 18.71% 14.32% 15.63% 16.65%
EBT Margin (%) 6.04% 6.87% 9.65% 9.06% 9.43% 8.97% 9.89% 10.02%
Net margin (%) 3.43% 3.98% 5.9% 5.84% 5.93% 6.41% 7.03% 7.46%
FCF margin (%) 15.57% -1.32% -0.88% -1.16% -6.86% -12.33% -8.35% -8.08%
FCF / Net Income (%) 454.35% -33.03% -14.89% -19.93% -115.65% -192.24% -118.75% -108.39%

Profitability

        
ROA 1.2% 1.64% 2.77% 2.76% 2.68% 4.1% 4.5% 4.75%
ROE 5.96% 7.78% 13.03% 12.09% 11.65% 11.66% 12.95% 13.07%

Financial Health

        
Leverage (Debt/EBITDA) 4.66x 6x 4.38x 3.71x 3.41x 4.32x 4.3x 4.28x
Debt / Free cash flow 6.85x -75.88x -76.01x -54.75x -10.1x -7.4x -11.46x -12.54x

Capital Intensity

        
CAPEX / Current Assets (%) 10.14% 16.62% 13.54% 21.07% 19.77% 29.63% 28.87% 28.37%
CAPEX / EBITDA (%) 44.25% 99.95% 88.71% 122.57% 97.18% 140.34% 129.68% 119.75%
CAPEX / FCF (%) 65.12% -1,263.69% -1,540.82% -1,809.94% -288.31% -240.32% -345.88% -351.07%

Items per share

        
Cash flow per share 1 28.02 20.94 22.39 39.39 39.68 71.25 84.49 96.26
Change - -25.25% 6.88% 75.98% 0.73% 79.57% 18.58% 13.93%
Dividend per Share 1 1.55 1.75 2 2 2.25 2.414 2.761 3.058
Change - 12.9% 14.29% 0% 12.5% 7.3% 14.38% 10.76%
Book Value Per Share 1 69.85 70.23 90.09 101.2 112.2 121.8 135.8 150.2
Change - 0.54% 28.29% 12.38% 10.77% 8.61% 11.44% 10.61%
EPS 1 3.17 5.36 10.43 11.56 12.41 13.56 17.2 18.9
Change - 69.09% 94.59% 10.83% 7.35% 9.28% 26.84% 9.85%
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 27.8x 21.9x
PBR 3.09x 2.78x
EV / Sales 2.68x 2.52x
Yield 0.64% 0.73%

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Trader
Investor
Global
Quality
ESG MSCI
A
Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
25
Last Close Price
376.85INR
Average target price
408.91INR
Spread / Average Target
+8.51%

Quarterly revenue - Rate of surprise

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