Financials InterGlobe Aviation Limited

Equities

INDIGO

INE646L01027

Airlines

Market Closed - NSE India S.E. Other stock markets 12:40:29 11/09/2024 BST			5-day change	1st Jan Change
4,900.40 ^INR	+1.42%		+1.81%	+65.16%

09-01	InterGlobe Aviation Limited Receives Penalty from Authorities	CI
08-30	InterGlobe Aviation Limited Receives Order from Joint Commissioner of State Tax, Nava Raipur Division, Chhattisgarh	CI

Projected Income Statement: InterGlobe Aviation Limited

Fiscal Period: March	2020	2021	2022	2023	2024	2025	2026	2027
Net sales ¹	357,560	146,406	259,309	544,465	689,043	782,198	900,197	1,039,603
Change	-	-59.05%	77.12%	109.97%	26.55%	13.52%	15.09%	15.49%
EBITDA ¹	45,550	2,669	8,590	64,954	163,176	182,295	210,687	238,128
Change	-	-94.14%	221.91%	656.14%	151.22%	11.72%	15.57%	13.02%
EBIT ¹	846.9	-47,131	-45,213	13,924	98,918	109,572	125,976	128,095
Change	-	-	-4.07%	-	610.43%	10.77%	14.97%	1.68%
Interest Paid ¹	-18,759	-21,420	-23,580	-31,317	-41,694	-47,110	-51,657	-52,506
Earnings before Tax (EBT) ¹	-2,557	-58,181	-61,537	-3,044	80,493	83,495	97,142	117,556
Change	-	2,175.63%	5.77%	-95.05%	-	3.73%	16.34%	21.02%
Net income ¹	-2,337	-58,064	-61,618	-3,058	81,725	83,959	84,607	93,358
Change	-	2,384.8%	6.12%	-95.04%	-	2.73%	0.77%	10.34%
Announcement Date	02/06/20	05/06/21	25/05/22	18/05/23	23/05/24	-	-	-

¹INR in Million

Estimates

Fiscal Period: March	2020 Q1	2020 Q2	2020 Q3	2020 Q4	2021 Q1	2021 Q2	2021 Q3	2021 Q4	2022 Q1	2022 Q2	2022 Q3	2022 Q4	2023 Q1	2023 Q2	2023 Q3	2023 Q4	2024 Q1	2024 Q2	2024 Q3	2024 Q4	2025 Q1	2025 Q2	2025 Q3	2025 Q4	2026 Q1
Net sales ¹	94,201	81,052	99,317	82,991	7,667	27,410	49,100	62,229	30,069	56,085	92,948	80,207	128,553	124,976	149,330	141,606	166,831	149,439	194,521	178,253	195,707	168,847	223,180	204,882	224,470
Change	-	-13.96%	22.53%	-16.44%	-90.76%	257.48%	79.13%	26.74%	-51.68%	86.52%	65.73%	-13.71%	60.28%	-2.78%	19.49%	-5.17%	17.81%	-10.42%	30.17%	-8.36%	9.79%	-9.2%	32.18%	-8.2%	9.56%
EBITDA ¹	26,564	2,564	-	-	-	-	9,871	6,177	-	2,559	19,105	1,052	6,639	757.1	31,878	27,517	-	22,003	51,493	39,935	51,592	-	-	-	-
Change	-	-90.35%	-100%	-	-	-	-	-37.42%	-100%	-	646.64%	-94.49%	531.15%	-88.6%	4,110.54%	-13.68%	-100%	-	134.03%	-22.45%	29.19%	-100%	-	-	-
EBIT ¹	-	-	-	-	-	-9,206	-3,144	-	-27,820	-10,571	5,494	-12,316	-5,712	-12,104	17,754	13,985	35,667	6,513	34,836	21,903	32,834	1,109	42,779	26,615	38,684
Change	-	-	-	-	-	-	-65.84%	-100%	-	-62%	-	-	-53.62%	111.92%	-	-21.23%	155.03%	-81.74%	434.86%	-37.13%	49.91%	-95.55%	3,758.03%	-37.78%	45.34%
Charge d'intérêts	-	-	-	-	-	-	-	-5,282	-	-	-	-	-	-	-8,293	-9,182	-9,537	-	-10,952	-10,991	-11,576	-	-	-	-
Earnings before Tax (EBT) ¹	-	-	-	-	-	-11,949	-6,231	-	-31,742	-14,357	-	-	-10,642	-15,833	14,233	9,198	30,907	1,891	29,985	17,710	28,040	-	-	-	-
Change	-	-	-	-	-	-	-47.85%	-100%	-	-54.77%	-100%	-	-	48.77%	-	-35.37%	236.01%	-93.88%	1,485.68%	-40.94%	58.33%	-100%	-	-	-
Net income ¹	-	-	4,960	-	-28,443	-11,948	-6,201	-11,472	-31,742	-14,357	-	-	-10,643	-15,833	14,226	9,192	30,906	1,889	29,981	18,948	27,288	-	-	-	-
Change	-	-	-	-100%	-	-57.99%	-48.1%	84.98%	176.7%	-54.77%	-100%	-	-	48.77%	-	-35.39%	236.23%	-93.89%	1,486.9%	-36.8%	44.01%	-100%	-	-	-
Announcement Date	19/07/19	24/10/19	27/01/20	02/06/20	29/07/20	29/10/20	28/01/21	05/06/21	27/07/21	28/10/21	04/02/22	25/05/22	03/08/22	04/11/22	03/02/23	18/05/23	02/08/23	03/11/23	02/02/24	23/05/24	26/07/24	-	-	-	-

¹INR in Million

Estimates

Forecast Balance Sheet: InterGlobe Aviation Limited

Fiscal Period: March	2020	2021	2022	2023	2024	2025	2026	2027
Net Debt ¹	-200,250	106,733	186,512	214,565	189,883	16,578	-11,891	131,136
Change	-	-46.7%	74.75%	15.04%	-11.5%	-91.27%	-171.73%	1,002.82%
Announcement Date	02/06/20	05/06/21	25/05/22	18/05/23	23/05/24	-	-	-

¹INR in Million

Estimates

Cash Flow Forecast: InterGlobe Aviation Limited

Fiscal Period: March	2020	2021	2022	2023	2024	2025	2026	2027
CAPEX ¹	10,883	4,369	3,469	5,698	11,026	135,797	123,007	13,372
Change	-	-59.86%	-20.6%	64.26%	93.51%	1,131.55%	-9.42%	-89.13%
Free Cash Flow (FCF) ¹	58,835	-20,510	17,437	121,581	201,149	147,620	183,665	224,424
Change	-	-134.86%	-185.02%	597.26%	65.44%	-26.61%	24.42%	22.19%
Announcement Date	02/06/20	05/06/21	25/05/22	18/05/23	23/05/24	-	-	-

¹INR in Million

Estimates

Forecast Financial Ratios: InterGlobe Aviation Limited

Fiscal Period: March	2020	2021	2022	2023	2024	2025	2026	2027
Profitability
EBITDA Margin (%)	12.74%	1.82%	3.31%	11.93%	23.68%	23.31%	23.4%	22.91%
EBIT Margin (%)	0.24%	-32.19%	-17.44%	2.56%	14.36%	14.01%	13.99%	12.32%
EBT Margin (%)	-0.72%	-39.74%	-23.73%	-0.56%	11.68%	10.67%	10.79%	11.31%
Net margin (%)	-0.65%	-39.66%	-23.76%	-0.56%	11.86%	10.73%	9.4%	8.98%
FCF margin (%)	16.45%	-14.01%	6.72%	22.33%	29.19%	18.87%	20.4%	21.59%
FCF / Net Income (%)	-2,517.77%	35.32%	-28.3%	-3,975.99%	246.13%	175.82%	217.08%	240.39%
Profitability
ROA	3.04%	-13.64%	-13.84%	-0.58%	11.56%	9%	8%	8%
ROE	-3.64%	-193.91%	-	-	-	139.35%	60.81%	40.23%
Financial Health
Leverage (Debt/EBITDA)	-	40x	21.71x	3.3x	1.16x	0.09x	-	0.55x
Debt / Free cash flow	-	-5.2x	10.7x	1.76x	0.94x	0.11x	-	0.58x
Capital Intensity
CAPEX / Current Assets (%)	3.04%	2.98%	1.34%	1.05%	1.6%	17.36%	13.66%	1.29%
CAPEX / EBITDA (%)	23.89%	163.72%	40.38%	8.77%	6.76%	74.49%	58.38%	5.62%
CAPEX / FCF (%)	18.5%	-21.3%	19.89%	4.69%	5.48%	91.99%	66.97%	5.96%
Items per share
Cash flow per share ¹	181.1	-41.94	54.29	330.1	549.7	458.5	499.8	578.8
Change	-	-123.16%	-229.45%	508.1%	66.51%	-16.59%	9%	15.81%
Dividend per Share ¹	-	-	-	-	-	20.37	23.17	33.6
Change	-	-	-	-	-	-	13.77%	45.01%
Book Value Per Share ¹	152.8	2.88	-155.4	-162	51.72	259.7	451.3	661.7
Change	-	-98.11%	-5,496.91%	4.24%	-131.92%	402.1%	73.76%	46.62%
EPS ¹	-6.07	-150.9	-160	-7.93	211.6	217.3	218	238.4
Change	-	2,385.83%	6.04%	-95.04%	-2,768.47%	2.68%	0.31%	9.39%
Nbr of stocks (in thousands)	384,796	384,864	385,255	385,547	385,979	386,261	386,261	386,261
Announcement Date	02/06/20	05/06/21	25/05/22	18/05/23	23/05/24	-	-	-