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 -12,746 -12,308 -17,627
Change - -203.48% 1.02% 74.08% -243.61% 6.91% 3.44% -43.22%
Announcement Date 24/05/21 10/05/22 08/05/23 09/05/24 06/05/25 - - -
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,964 10,454 10,308
Change - 99.48% 5.22% 8.02% 38.81% 2.6% -4.65% -1.4%
Free Cash Flow (FCF) 1 4,660 2,264 2,566 7,933 2,931 3,982 4,226 5,636
Change - -51.42% 13.37% 209.12% -63.06% 35.87% 6.13% 33.37%
Announcement Date 24/05/21 10/05/22 08/05/23 09/05/24 06/05/25 - - -
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% 18.41% 17.66% 17.61%
EBIT Margin (%) 35.32% 20.45% 15.13% 25.13% 17.38% 13.29% 12.77% 12.39%
EBT Margin (%) 38.73% 22.65% 16.76% 27.75% 19.85% 15.04% 14.16% 13.83%
Net margin (%) 28.79% 16.77% 12.54% 20.64% 15.09% 11.6% 10.69% 10.41%
FCF margin (%) 21.65% 6.36% 4.07% 12.7% 4.23% 4.92% 4.74% 5.79%
FCF / Net Income (%) 75.21% 37.92% 32.48% 61.54% 28.05% 42.42% 44.37% 55.57%

Profitability

        
ROA 14.2% 12.14% 14.03% 19.45% 13.54% 9.95% 9.68% 9.12%
ROE 20.03% 17.48% 20.44% 27.8% 18.94% 15.07% 14.05% 13.81%

Financial Health

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

Capital Intensity

        
CAPEX / Current Assets (%) 15.77% 19.02% 11.31% 12.33% 15.43% 13.54% 11.74% 10.58%
CAPEX / EBITDA (%) 36.35% 73.28% 60.18% 41.78% 70.78% 73.54% 66.47% 60.08%
CAPEX / FCF (%) 72.86% 299.2% 277.7% 97.04% 364.63% 275.34% 247.39% 182.9%

Items per share

        
Cash flow per share 1 96.35 74.75 98.13 158.2 138.5 142.4 129.6 137.2
Change - -22.42% 31.27% 61.26% -12.45% 2.83% -9.06% 5.94%
Dividend per Share 1 23 25 26 30 30 30 31.6 33.81
Change - 8.7% 4% 15.38% 0% -0.02% 5.34% 6.99%
Book Value Per Share 1 327.2 364.2 418.5 520.6 596.2 660.5 726.9 796.3
Change - 11.29% 14.93% 24.39% 14.52% 10.79% 10.04% 9.55%
EPS 1 62.72 60.43 79.98 130.5 105.8 93.12 95.16 102.5
Change - -3.65% 32.35% 63.17% -18.94% -11.97% 2.19% 7.71%
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 - - -
1INR
Estimates
2026 *2027 *
P/E ratio 12.1x 11.8x
PBR 1.7x 1.55x
EV / Sales 1.22x 1.11x
Yield 2.66% 2.81%

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. Equities
  3. MGL Stock
  4. Financials Mahanagar Gas Limited