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,74,784 7,44,256 8,39,660
Change - 24.35% -13.46% 6.78% 15.04% 23.89% 16.18% 12.82%
Announcement Date 12/05/21 06/05/22 04/05/23 08/05/24 14/05/25 12/05/26 - -
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 1,36,948 2,12,348 2,23,917
Change - 117.88% 5.34% 74.15% -0.69% 3.43% 3.03% 5.45%
Free Cash Flow (FCF) 1 51,222 -5,751 -4,969 -7,366 -45,926 -77,015 -66,012 -77,998
Change - -111.23% 13.61% -48.25% -523.46% -67.69% 26.24% -18.16%
Announcement Date 12/05/21 06/05/22 04/05/23 08/05/24 14/05/25 12/05/26 - -
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% 23.31% 21.93% 23.23%
EBIT Margin (%) 14.57% 9.49% 9.18% 11.21% 18.71% 15.82% 15.25% 16.2%
EBT Margin (%) 6.04% 6.87% 9.65% 9.06% 9.43% 10.34% 9.69% 10.24%
Net margin (%) 3.43% 3.98% 5.9% 5.84% 5.93% 5.84% 6.57% 7.06%
FCF margin (%) 15.57% -1.32% -0.88% -1.16% -6.86% -12% -8.74% -9.63%
FCF / Net Income (%) 454.35% -33.03% -14.89% -19.93% -115.65% -205.53% -132.98% -136.39%

Profitability

        
ROA 1.2% 1.64% 2.77% 2.76% 2.68% 2.26% 4.07% 4.22%
ROE 5.96% 7.78% 13.03% 12.09% 11.65% 9.95% 11.55% 11.85%

Financial Health

        
Leverage (Debt/EBITDA) 4.66x 6x 4.38x 3.71x 3.41x 3.84x 4.49x 4.46x
Debt / Free cash flow 6.85x -75.88x -76.01x -54.75x -10.1x -7.46x -11.27x -10.77x

Capital Intensity

        
CAPEX / Current Assets (%) 10.14% 16.62% 13.54% 21.07% 19.77% 21.34% 28.1% 27.64%
CAPEX / EBITDA (%) 44.25% 99.95% 88.71% 122.57% 97.18% 91.54% 128.16% 118.94%
CAPEX / FCF (%) 65.12% -1,263.69% -1,540.82% -1,809.94% -288.31% -177.82% -321.68% -287.08%

Items per share

        
Cash flow per share 1 28.02 20.94 22.39 39.39 39.68 18.73 69.24 78.98
Change - -25.25% 6.88% 75.98% 0.73% -52.8% -2.82% 14.06%
Dividend per Share 1 1.55 1.75 2 2 2.25 2.5 2.913 3.164
Change - 12.9% 14.29% 0% 12.5% 11.11% 16.89% 8.63%
Book Value Per Share 1 69.85 70.23 90.09 101.2 112.2 123.5 137.9 153.6
Change - 0.54% 28.29% 12.38% 10.77% 10.12% 12.96% 11.37%
EPS 1 3.17 5.36 10.43 11.56 12.41 11.71 15.27 17.67
Change - 69.09% 94.59% 10.83% 7.35% -5.64% 13.49% 15.72%
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 12/05/26 - -
1INR
Estimates
2026 2027 *
P/E ratio 32.3x 26.8x
PBR 3.07x 2.97x
EV / Sales 2.78x 2.71x
Yield 0.66% 0.71%

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
26
Last Close Price
409.05INR
Average target price
432.77INR
Spread / Average Target
+5.80%

Quarterly revenue - Rate of surprise

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