Fundamental Analysis of Interglobe Aviation Ltd

About the Company - Interglobe Aviation Ltd

InterGlobe Aviation Ltd. is a Public Limited Listed company incorporated on 13/01/2004 and has its registered office in the State of Delhi, India. Company’s Corporate Identification Number(CIN) is L62100DL2004PLC129768 and registration number is 129768. Currently Company is involved in the business activities of Passenger airways. Company’s Total Operating Revenue is Rs. 25930.93 Cr. and Equity Capital is Rs. 385.26 Cr. for the Year ended 31/03/2022.

INDUSTRY	ADDRESS	CONTACT
Airlines	Upper Ground Floor, New Delhi Delhi 110001	investors@goindigo.in http://www.goindigo.in

Management
Name	Position Held
Dr. Venkataramani Sumantran	Chairman & Ind.Director
Mr. Rahul Bhatia	Managing Director
Mr. Meleveetil Damodaran	Director
Mr. Anil Parashar	Director
Mr. Gregg Albert Saretsky	Director
Air Cmdr. (Retd.) Birender Singh Dhanoa	Independent Director
Ms. Pallavi Shardul Shroff	Independent Director
Mr. Vikram Singh Mehta	Independent Director

Basic Stock Data of Interglobe Aviation Ltd

Last Updated: July 6, 2024, 11:59 am

Market Cap	1,66,855 Cr.
Current Price	4,323
High / Low	4,610/2,333
Stock P/E	20.4
Book Value	50.0
Dividend Yield	0.00 %
ROCE	26.6 %
ROE	%
Face Value	10.0
PEG Ratio	0.12

Interglobe Aviation Ltd Quarterly Results

Month	Dec 2020	Mar 2021	Jun 2021	Sep 2021	Dec 2021	Mar 2022	Jun 2022	Sep 2022	Dec 2022	Mar 2023	Jun 2023	Sep 2023	Dec 2023
Sales	4,910	6,223	3,007	5,608	9,295	8,021	12,855	12,498	14,933	14,161	16,683	14,944	19,452
Expenses	4,071	5,674	4,477	5,422	7,517	7,985	12,258	12,472	11,819	11,412	11,715	12,748	14,308
Operating Profit	839	549	-1,470	186	1,778	36	597	25	3,114	2,748	4,968	2,196	5,144
OPM %	17%	9%	-49%	3%	19%	0%	5%	0%	21%	19%	30%	15%	26%
Other Income	233	139	163	190	185	186	163	354	476	438	477	558	610
Interest	541	528	555	569	601	633	657	728	829	918	954	1,021	1,095
Depreciation	1,156	1,319	1,317	1,248	1,234	1,269	1,170	1,237	1,342	1,352	1,404	1,545	1,660
Profit before tax	-627	-1,159	-3,179	-1,440	128	-1,680	-1,065	-1,585	1,418	916	3,087	188	2,998
Tax %	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%
Net Profit	-627	-1,159	-3,179	-1,440	128	-1,680	-1,065	-1,585	1,418	916	3,087	188	2,998
EPS in Rs	-16.28	-30.11	-82.60	-37.40	3.33	-43.60	-27.65	-41.14	36.79	23.76	80.07	4.87	77.69

Last Updated: July 6, 2024, 10:49 pm

Interglobe Aviation Ltd Quarterly Chart

Interglobe Aviation Ltd Profit & Loss

Month	Mar 2012	Mar 2013	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	Mar 2022	Mar 2023	TTM
Sales	5,565	9,203	11,117	13,925	16,140	18,580	23,021	28,497	35,756	14,641	25,931	54,446	60,720
Expenses	5,540	8,348	10,684	12,022	12,976	16,362	19,991	28,648	31,687	14,638	25,373	47,926	47,694
Operating Profit	25	855	433	1,904	3,164	2,219	3,030	-151	4,069	2	558	6,521	13,026
OPM %	0%	9%	4%	14%	20%	12%	13%	-1%	11%	0%	2%	12%	21%
Other Income	165	296	391	395	515	789	947	1,325	1,531	1,036	725	1,431	1,950
Interest	59	73	123	150	350	406	413	563	1,902	2,170	2,386	3,168	3,723
Depreciation	67	86	226	302	505	457	437	760	3,974	4,699	5,068	5,101	5,644
Profit before tax	64	993	475	1,847	2,824	2,144	3,127	-149	-275	-5,830	-6,171	-317	5,609
Tax %	-100%	21%	0%	29%	30%	23%	28%	205%	10%	0%	0%	0%
Net Profit	128	787	474	1,304	1,986	1,659	2,242	156	-248	-5,830	-6,171	-317	5,609
EPS in Rs	4,165.47	25,646.58	15,454.07	42,481.11	55.12	45.90	58.33	4.06	-6.45	-151.46	-160.18	-8.21	145.49
Dividend Payout %	0%	70%	80%	83%	27%	74%	10%	123%	0%	0%	0%	0%

Interglobe Aviation Ltd Profit & Loss Yearly Chart

Interglobe Aviation Ltd Growth

Compounded Sales Growth
10 Years:	20%
5 Years:	19%
3 Years:	68%
TTM:	27%

Compounded Profit Growth
10 Years:	35%
5 Years:	107%
3 Years:	49%
TTM:	1154%

Stock Price CAGR
10 Years:	%
5 Years:	22%
3 Years:	35%
1 Year:	64%

Return on Equity
10 Years:	%
5 Years:	%
3 Years:	%
Last Year:	%

Last Updated: June 27, 2024, 9:09 am

Interglobe Aviation Ltd Balance Sheet

Month	Mar 2012	Mar 2013	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	Mar 2022	Mar 2023	Sep 2023
Equity Capital	31	31	31	31	360	361	384	384	385	385	385	386	386
Reserves	348	498	373	386	2,363	3,418	6,693	6,560	5,478	-314	-6,421	-6,689	-3,378
Preference Capital	4	4	4	4	-0	-0	-0	-0	-0	-0	-0	-0
Borrowings	1,016	1,800	3,346	3,926	3,245	2,596	2,453	2,429	22,719	29,860	36,878	44,854	49,392
Other Liabilities	2,419	3,682	5,351	6,446	6,662	8,834	11,599	15,638	13,467	13,044	15,018	20,492	26,594
Total Liabilities	3,814	6,011	9,102	10,789	12,630	15,210	21,129	25,012	42,048	42,974	45,860	59,043	72,993
Fixed Assets	886	1,764	3,956	4,876	4,747	3,794	4,579	5,662	16,778	18,815	21,282	27,650	31,957
CWIP	-0	7	-0	0	32	25	32	24	140	72	125	21	-0
Investments	523	1,138	1,272	517	986	3,713	6,344	6,517	9,499	7,290	8,033	11,514	14,838
Other Assets	2,404	3,101	3,874	5,396	6,864	7,677	10,174	12,809	15,631	16,797	16,420	19,858	26,198
Total Assets	3,814	6,011	9,102	10,789	12,630	15,210	21,129	25,012	42,048	42,974	45,860	59,043	72,993

Interglobe Aviation Ltd Reserves and Borrowings Chart

Interglobe Aviation Ltd Cash Flow

Month	Mar 2012	Mar 2013	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	Mar 2022	Mar 2023
Cash from Operating Activity	896	1,741	1,595	2,384	3,116	3,782	3,903	3,160	6,943	-1,620	2,064	12,703
Cash from Investing Activity	-47	-1,890	-2,914	-940	-1,337	-3,033	-4,152	-2,526	-4,573	3,228	1,527	-4,039
Cash from Financing Activity	-638	36	1,285	-1,308	-1,220	-1,401	766	-592	-2,407	-1,775	-3,088	-8,432
Net Cash Flow	212	-113	-34	136	559	-652	518	42	-37	-168	503	232

Interglobe Aviation Ltd Financial Efficiency Indicators

Month	Mar 2012	Mar 2013	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	Mar 2022	Mar 2023
Debtor Days	3	3	3	3	4	3	4	5	3	5	5	3
Inventory Days
Days Payable
Cash Conversion Cycle	3	3	3	3	4	3	4	5	3	5	5	3
Working Capital Days	-50	-44	-76	-60	-63	-72	-70	-64	-80	-186	-126	-57
ROCE %	9%	55%	17%	47%	61%	38%	40%	0%	5%	-14%	-13%	7%

Interglobe Aviation Ltd Financial Efficiency Indicators Chart

Interglobe Aviation Ltd Share Holding Pattern

Month	Jun 2021	Sep 2021	Dec 2021	Mar 2022	Jun 2022	Sep 2022	Dec 2022	Mar 2023	Jun 2023	Sep 2023	Dec 2023	Mar 2024
Promoters	74.84%	74.79%	74.78%	74.77%	74.77%	71.92%	71.92%	67.86%	67.77%	63.25%	63.12%	57.29%
FIIs	19.17%	18.51%	18.57%	17.70%	16.72%	18.06%	17.77%	19.43%	19.76%	20.29%	18.70%	23.66%
DIIs	3.92%	4.62%	4.73%	5.48%	6.38%	7.77%	8.24%	10.43%	10.37%	13.25%	14.65%	15.03%
Government	0.00%	0.00%	0.00%	0.00%	0.00%	0.07%	0.07%	0.07%	0.07%	0.07%	0.07%	0.07%
Public	2.08%	2.08%	1.92%	2.05%	2.13%	2.18%	1.98%	2.19%	2.02%	3.16%	3.45%	3.95%
No. of Shareholders	89,834	94,131	98,496	1,11,409	1,15,224	1,15,067	1,03,777	1,06,266	1,05,511	1,40,179	1,41,106	1,70,059

Interglobe Aviation Ltd Shareholding Pattern Chart

No. of Interglobe Aviation Ltd Shareholders

Interglobe Aviation Ltd Mutual Fund Holdings

Fund Name	No of Shares	AUM (%)	Amount Invested (Cr)	Previous Number of Shares	Previous Date	Percentage Change
SBI Equity Hybrid Fund	4,400,000	1.82	1079.69	1,044,687	2024-07-05	321.18%
Kotak Flexicap Fund - Regular Plan	2,650,000	1.66	650.27	1,044,687	2024-07-05	153.66%
SBI Multicap Fund	1,900,000	3.6	466.23	1,044,687	2024-07-05	81.87%
Axis Bluechip Fund	1,628,722	1.3	399.66	1,044,687	2024-07-05	55.91%
Nippon India Small Cap Fund	1,619,443	1.06	397.39	1,044,687	2024-07-05	55.02%
ICICI Prudential Balanced Advantage Fund	1,434,715	0.71	352.06	1,044,687	2024-07-05	37.33%
ICICI Prudential Multi Asset Fund	1,133,370	1.12	278.11	1,044,687	2024-07-05	8.49%
ICICI Prudential Value Discovery Fund	1,044,687	0.79	256.35	1,044,687	2024-07-05	0%
Mirae Asset Emerging Bluechip Fund	948,562	0.83	232.76	1,044,687	2024-07-05	-9.2%
Nippon India Growth Fund	928,703	1.19	227.89	1,044,687	2024-07-05	-11.1%

Interglobe Aviation Ltd ROCE Trend

Interglobe Aviation Ltd EPS Trend

Interglobe Aviation Ltd Key Financial Ratios

Month	Mar 24	Mar 23	Mar 22	Mar 21	Mar 20
FaceValue	10.00	10.00	10.00	10.00	10.00
Basic EPS (Rs.)	211.84	-7.93	-160.01	-150.89	-6.07
Diluted EPS (Rs.)	211.84	-7.93	-160.01	-150.89	-6.07
Cash EPS (Rs.)	378.21	124.43	-28.38	-28.76	97.20
Book Value[Excl.RevalReserv]/Share (Rs.)	51.72	-162.17	-155.58	2.73	152.60
Book Value[Incl.RevalReserv]/Share (Rs.)	51.72	-162.17	-155.58	2.73	152.60
Revenue From Operations / Share (Rs.)	1785.18	1412.19	673.08	380.37	929.22
PBDIT / Share (Rs.)	483.04	205.69	33.04	26.59	145.38
PBIT / Share (Rs.)	316.56	73.33	-98.52	-95.50	42.10
PBT / Share (Rs.)	208.54	-7.89	-159.73	-151.15	-6.64
Net Profit / Share (Rs.)	211.73	-7.93	-159.94	-150.85	-6.07
NP After MI And SOA / Share (Rs.)	211.73	-7.93	-159.94	-150.85	-6.07
PBDIT Margin (%)	27.05	14.56	4.90	6.98	15.64
PBIT Margin (%)	17.73	5.19	-14.63	-25.10	4.53
PBT Margin (%)	11.68	-0.55	-23.73	-39.73	-0.71
Net Profit Margin (%)	11.86	-0.56	-23.76	-39.65	-0.65
NP After MI And SOA Margin (%)	11.86	-0.56	-23.76	-39.65	-0.65
Return on Networth / Equity (%)	409.35	0.00	0.00	-5530.98	-3.97
Return on Capital Employeed (%)	23.75	8.00	-16.12	-15.23	6.31
Return On Assets (%)	9.93	-0.51	-13.40	-13.48	-0.55
Long Term Debt / Equity (X)	0.00	0.00	-0.06	3.64	0.05
Total Debt / Equity (X)	0.94	-0.36	-0.65	23.87	0.05
Asset Turnover Ratio (%)	0.97	1.04	0.58	0.34	1.07
Current Ratio (X)	1.16	1.10	0.90	1.10	1.37
Quick Ratio (X)	1.14	1.07	0.88	1.08	1.35
Interest Coverage Ratio (X)	4.47	2.53	0.53	0.47	2.98
Interest Coverage Ratio (Post Tax) (X)	2.96	0.90	-1.61	-1.71	0.87
Enterprise Value (Cr.)	121981.36	64138.88	71341.91	54208.82	30579.99
EV / Net Operating Revenue (X)	1.77	1.18	2.75	3.70	0.85
EV / EBITDA (X)	6.54	8.09	56.05	52.97	5.47
MarketCap / Net Operating Revenue (X)	1.99	1.35	2.99	4.30	1.15
Price / BV (X)	68.53	-11.79	-12.94	599.54	7.00
Price / Net Operating Revenue (X)	1.99	1.35	2.99	4.30	1.15
EarningsYield	0.05	0.00	-0.07	-0.09	-0.01

Interglobe Aviation Ltd Profitability Ratios (%)

Interglobe Aviation Ltd Liquidity Ratios

Interglobe Aviation Ltd Liquidity Ratios (%)

Interglobe Aviation Ltd Interest Coverage Ratios (%)

Interglobe Aviation Ltd Valuation Ratios

Fair Value

Fair Value: 156.06

Calculation basis:

Fair value = P/E Ratio * (Return on Equity / 100) * Book Value * (1 + Dividend Yield / 100)
P/E Ratio (Price-to-Earnings Ratio): Represents the price of the stock relative to its earnings per share. A higher P/E ratio indicates that investors are willing to pay a higher price for the stock.
Return on Equity (ROE): Measures a company's profitability relative to its shareholder equity. It showcases the company's ability to generate profits using the investment made by its shareholders, offering valuable insight into its operational efficiency and financial performance
Book Value: Represents the net asset value of the company per share. It is calculated as the total assets minus intangible assets and liabilities, divided by the number of outstanding shares.
Dividend Yield: The ratio of the annual dividend per share to the current market price per share. It offers valuable insights into the profitability of an investment through dividends.

This formula allows us to gauge the fair value of the stock by analyzing its fundamental indicators.

Overvalued: 96.39% compared to the current price 4323

Default values used*: Deafault value of 15% for ROE is used

Intrinsic Value: 426.77

Calculation basis:

Fair value = P/E Ratio * (Return on Equity / 100) * Book Value * (1 + Dividend Yield / 100) * (1 + EPS CAGR for Last 5 Years)
P/E Ratio (Price-to-Earnings Ratio): Represents the price of the stock relative to its earnings per share. A higher P/E ratio indicates that investors are willing to pay a higher price for the stock.
Return on Equity (ROE): Measures a company's profitability relative to its shareholder equity. It showcases the company's ability to generate profits using the investment made by its shareholders, offering valuable insight into its operational efficiency and financial performance.
Book Value: Represents the net asset value of the company per share. It is calculated as the total assets minus intangible assets and liabilities, divided by the number of outstanding shares.
Dividend Yield: The ratio of the annual dividend per share to the current market price per share. It offers valuable insights into the profitability of an investment through dividends.
EPS CAGR (Compound Annual Growth Rate): Represents the geometric mean growth rate of earnings per share over the last 5 years. It provides insight into the historical growth trajectory of the company's earnings.

This formula allows us to gauge the fair value of the stock by analyzing its fundamental indicators along with EPS growth.

Overvalued: 90.13% compared to the current price ₹4323

Default values used*: Deafault value of 15% for ROE is used

Last 5 Year EPS CAGR: 173.47%

*Investments are subject to market risks

Strength and Weakness of Interglobe Aviation Ltd Stock

Strength	Weakness
The stock has a high average ROCE of 21.00%, which is a positive sign. The stock has a low average Working Capital Days of -79.00, which is a positive sign. The company has higher reserves (716.54 cr) compared to borrowings (1.23 cr), indicating strong financial stability. The company has shown consistent growth in sales (23.92 cr) and profit (61.00 cr) over the years.	The stock has a high average Cash Conversion Cycle of 3.67, which may not be favorable.

FAQ

What is the latest fair value of Interglobe Aviation Ltd?

The latest fair value of Interglobe Aviation Ltd is ₹156.06.

What is the Market Cap of Interglobe Aviation Ltd?

The Market Cap of Interglobe Aviation Ltd is 1,66,855 Cr..

What is the current Stock Price of Interglobe Aviation Ltd as on 06 July 2024?

The current stock price of Interglobe Aviation Ltd as on 06 July 2024 is 4,323.

What is the High / Low of Interglobe Aviation Ltd stocks in FY 2024?

In FY 2024, the High / Low of Interglobe Aviation Ltd stocks is 4,610/2,333.

What is the Stock P/E of Interglobe Aviation Ltd?

The Stock P/E of Interglobe Aviation Ltd is 20.4.

What is the Book Value of Interglobe Aviation Ltd?

The Book Value of Interglobe Aviation Ltd is 50.0.

What is the Dividend Yield of Interglobe Aviation Ltd?

The Dividend Yield of Interglobe Aviation Ltd is 0.00 %.

What is the ROCE of Interglobe Aviation Ltd?

The ROCE of Interglobe Aviation Ltd is 26.6 %.

What is the ROE of Interglobe Aviation Ltd?

The ROE of Interglobe Aviation Ltd is %.

What is the Face Value of Interglobe Aviation Ltd?

The Face Value of Interglobe Aviation Ltd is 10.0.