Projected Income Statement: Mahanagar Gas Limited

Forecast Balance Sheet: Mahanagar Gas Limited

Fiscal Period: March 2021 2022 2023 2024 2025 2026 2027 2028
Net Debt 1 -5,119 -15,535 -15,377 -3,985 -13,693 -11,493 -9,173 -12,395
Change - -203.48% 1.02% 74.08% -243.61% 16.07% 27.76% -35.12%
Announcement Date 24/05/21 10/05/22 08/05/23 09/05/24 06/05/25 07/05/26 - -
1INR in Million
Estimates

Cash Flow Forecast: Mahanagar Gas Limited

Fiscal Period: March 2021 2022 2023 2024 2025 2026 2027 2028
CAPEX 1 3,395 6,773 7,127 7,698 10,686 10,604 11,580 11,456
Change - 99.48% 5.22% 8.02% 38.81% -0.76% 5.62% -1.07%
Free Cash Flow (FCF) 1 4,660 2,264 2,566 7,933 2,931 856.9 5,421 5,230
Change - -51.42% 13.37% 209.12% -63.06% -70.76% 36.14% -3.51%
Announcement Date 24/05/21 10/05/22 08/05/23 09/05/24 06/05/25 07/05/26 - -
1INR in Million
Estimates

Forecast Financial Ratios: Mahanagar Gas Limited

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

Profitability

        
EBITDA Margin (%) 43.39% 25.96% 18.8% 29.51% 21.81% 17.61% 14.3% 16.19%
EBIT Margin (%) 35.32% 20.45% 15.13% 25.13% 17.38% 12.64% 9.33% 11.11%
EBT Margin (%) 38.73% 22.65% 16.76% 27.75% 19.85% 13.84% 10.47% 12.22%
Net margin (%) 28.79% 16.77% 12.54% 20.64% 15.09% 10.28% 7.86% 9.25%
FCF margin (%) 21.65% 6.36% 4.07% 12.7% 4.23% 1.04% 5.86% 5.21%
FCF / Net Income (%) 75.21% 37.92% 32.48% 61.54% 28.05% 10.12% 74.63% 56.35%

Profitability

        
ROA 14.2% 12.14% 14.03% 19.45% 13.54% 9.82% 7.97% 8.65%
ROE 20.03% 17.48% 20.44% 27.8% 18.94% 13.76% 10.98% 12.83%

Financial Health

        
Leverage (Debt/EBITDA) - - - - - - - -
Debt / Free cash flow - - - - - - - -

Capital Intensity

        
CAPEX / Current Assets (%) 15.77% 19.02% 11.31% 12.33% 15.43% 12.87% 12.53% 11.41%
CAPEX / EBITDA (%) 36.35% 73.28% 60.18% 41.78% 70.78% 73.08% 87.59% 70.47%
CAPEX / FCF (%) 72.86% 299.2% 277.7% 97.04% 364.63% 1,237.5% 213.62% 219.03%

Items per share

        
Cash flow per share 1 96.35 74.75 98.13 158.2 138.5 116.2 133.2 130
Change - -22.42% 31.27% 61.26% -12.45% -16.15% -6.53% -2.33%
Dividend per Share 1 23 25 26 30 30 30 25.8 31.22
Change - 8.7% 4% 15.38% 0% 0% -12.87% 21.02%
Book Value Per Share 1 327.2 364.2 418.5 520.6 596.2 651.4 699.8 761.1
Change - 11.29% 14.93% 24.39% 14.52% 9.25% 6.07% 8.75%
EPS 1 62.72 60.43 79.98 130.5 105.8 85.73 73.66 93.98
Change - -3.65% 32.35% 63.17% -18.94% -18.95% -21.08% 27.58%
Nbr of stocks (in thousands) 98,778 98,778 98,778 98,778 98,778 98,778 98,778 98,778
Announcement Date 24/05/21 10/05/22 08/05/23 09/05/24 06/05/25 07/05/26 - -
1INR
Estimates
2026 2027 *
P/E 10.8x 15.1x
PBR 1.42x 1.59x
EV / Sales 0.97x 1.09x
Yield 3.23% 2.32%

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Trader
Investor
Global
-
Quality
ESG MSCI
BB

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Stocks
  3. MGL Stock
  4. Financials Mahanagar Gas Limited