INTERGLOBE AVIATION LTD SCREENER.

IN

Narration Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Mar-25 Trailing Best Case Worst Case
Sales 16,139.91 18,580.50 23,020.89 28,496.77 35,756.00 14,640.63 25,930.93 54,446.45 68,904.34 80,803.00 80,803.00 118,022.27 94,756.37
Expenses 12,975.79 16,361.83 19,991.06 28,647.70 31,686.93 14,638.23 25,372.72 47,925.69 52,573.04 62,796.80 62,796.80 91,722.10 80,829.04
Operating Profit 3,164.12 2,218.67 3,029.83 -150.93 4,069.07 2.40 558.21 6,520.76 16,331.30 18,006.20 18,006.20 26,300.17 13,927.33
Other Income 515.12 789.07 946.81 1,324.86 1,531.31 1,036.33 724.54 1,431.44 2,325.57 3,306.80 3,306.80 - -
Depreciation 505.47 457.25 436.88 759.58 3,973.61 4,698.69 5,067.85 5,101.24 6,405.61 8,636.60 8,636.60 8,636.60 8,636.60
Interest 350.26 406.15 413.09 563.40 1,901.86 2,169.84 2,385.93 3,167.68 4,208.02 5,088.90 5,088.90 5,088.90 5,088.90
Profit before tax 2,823.51 2,144.34 3,126.67 -149.05 -275.09 -5,829.80 -6,171.03 -316.72 8,043.24 7,587.50 7,587.50 12,574.67 201.83
Tax 837.34 485.15 884.30 -305.18 -26.93 - - - -124.24 334.20 334.20 4% 4%
Net profit 1,986.16 1,659.19 2,242.37 156.14 -248.16 -5,829.79 -6,171.03 -316.72 8,167.49 7,253.30 7,253.30 12,020.80 192.94
EPS 55.11 45.90 58.33 4.06 -6.45 -151.46 -160.16 -8.22 211.59 187.71 187.70 311.07 4.99
Price to earning 15.84 22.91 22.12 351.60 -165.32 -10.77 -12.58 -232.56 16.77 27.25 29.41 29.41 24.48
Price 873.20 1,051.40 1,290.45 1,428.15 1,066.15 1,631.95 2,014.15 1,910.65 3,548.65 5,115.35 5,521.00 9,149.88 122.21

RATIOS:
Dividend Payout 27.22% 74.07% 10.29% 123.09% 0.00% 0.00% 0.00% 0.00% 0.00% 5.33%
OPM 19.60% 11.94% 13.16% 0.00% 11.38% 0.02% 2.15% 11.98% 23.70% 22.28% 22.28%

TRENDS: 10 YEARS 7 YEARS 5 YEARS 3 YEARS RECENT BEST WORST

Sales Growth 19.60% 19.65% 17.71% 46.06% 17.27% 46.06% 17.27%
OPM 14.70% 14.72% 16.92% 20.01% 22.28% 22.28% 14.70%
Price to Earning 69.42 106.26 24.48 24.48 29.41 29.41 24.48
INTERGLOBE AVIATION LTD [Link]

Narration Dec-22 Mar-23 Jun-23 Sep-23 Dec-23 Mar-24 Jun-24 Sep-24 Dec-24 Mar-25
Sales 14,932.97 14,160.60 16,683.10 14,943.88 19,452.10 17,825.30 19,570.70 16,969.60 22,110.70 22,152.00
Expenses 11,819.34 11,412.23 11,715.30 12,747.56 14,307.90 13,841.10 14,424.60 15,351.80 16,950.70 16,069.70
Operating Profit 3,113.63 2,748.37 4,967.80 2,196.32 5,144.20 3,984.20 5,146.10 1,617.80 5,160.00 6,082.30
Other Income 475.73 438.37 477.40 558.27 609.80 680.00 679.70 790.50 883.50 953.10
Depreciation 1,341.88 1,352.49 1,404.30 1,545.46 1,660.30 1,795.50 1,866.50 2,077.60 2,215.40 2,477.10
Interest 829.31 918.23 953.70 1,021.27 1,095.20 1,099.10 1,157.60 1,240.10 1,308.10 1,383.10
Profit before tax 1,418.17 916.02 3,087.20 187.86 2,998.50 1,769.60 2,801.70 -909.40 2,520.00 3,175.20
Tax - - - - - -124.30 75.00 79.40 78.00 101.80
Net profit 1,418.17 916.02 3,087.20 187.86 2,998.50 1,893.90 2,726.70 -988.80 2,442.00 3,073.40

OPM 21% 19% 30% 15% 26% 22% 26% 10% 23% 27%
INTERGLOBE AVIATION LTD [Link]

Narration Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Mar-25
Equity Share Capital 360.36 361.47 384.41 384.41 384.80 384.91 385.26 385.55 385.98 386.40
Reserves 2,362.83 3,417.75 6,693.04 6,560.38 5,477.64 -314.00 -6,420.55 -6,694.56 1,545.95 8,920.40
Borrowings 3,244.63 2,596.17 2,452.72 2,429.17 22,719.17 29,859.65 36,877.84 44,860.10 51,280.02 67,088.40
Other Liabilities 6,661.69 8,834.37 11,599.17 15,637.78 13,466.85 13,043.69 15,017.56 20,491.59 28,856.87 39,518.70
Total 12,629.51 15,209.76 21,129.34 25,011.74 42,048.46 42,974.25 45,860.11 59,042.68 82,068.82 115,913.90

Net Block 4,747.41 3,793.84 4,578.81 5,662.04 16,778.20 18,815.47 21,282.07 27,649.97 36,036.57 51,567.10
Capital Work in Progress 31.97 25.19 32.49 23.63 140.24 71.74 125.31 20.77 1.48 0.70
Investments 986.16 3,713.44 6,344.04 6,516.70 9,499.35 7,290.17 8,032.61 11,514.35 16,453.16 26,402.10
Other Assets 6,863.97 7,677.29 10,174.00 12,809.37 15,630.67 16,796.87 16,420.12 19,857.59 29,577.61 37,944.00
Total 12,629.51 15,209.76 21,129.34 25,011.74 42,048.46 42,974.25 45,860.11 59,042.68 82,068.82 115,913.90

Working Capital 202.28 -1,157.08 -1,425.17 -2,828.41 2,163.82 3,753.18 1,402.56 -634.00 720.74 -1,574.70
Debtors 157.11 158.70 226.32 362.47 259.61 219.17 332.92 519.90 642.52 739.80
Inventory 87.11 163.15 183.23 211.44 286.13 316.42 408.06 591.07 624.80 820.30

Debtor Days 3.55 3.12 3.59 4.64 2.65 5.46 4.69 3.49 3.40 3.34
Inventory Turnover 185.28 113.89 125.64 134.77 124.96 46.27 63.55 92.12 110.28 98.50

Return on Equity 73% 44% 32% 2% -4% -8221% 423% 78%

Return on Capital Emp 41% 45% 4% 9% -13% -12% 8% 27% 20%
INTERGLOBE AVIATION LTD [Link]

Narration Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Mar-25
Cash from Operating Activity 3,115.72 3,782.07 3,903.10 3,160.00 6,943.30 -1,620.40 2,064.10 12,703.14 21,182.80 24,064.70
Cash from Investing Activity -1,337.14 -3,033.12 -4,151.54 -2,525.68 -4,572.56 3,227.98 1,527.17 -4,038.53 -11,759.13 -12,783.60
Cash from Financing Activity -1,219.96 -1,401.21 765.96 -592.16 -2,407.48 -1,775.34 -3,087.84 -8,432.46 -9,978.53 -10,974.90
Net Cash Flow 558.62 -652.26 517.52 42.16 -36.74 -167.76 503.43 232.15 -554.86 306.20
How to use it?
You can customize this workbook as you want.
You can add custom formating, add conditional formating, add your own formulas… do ANYTHING.
Please don't edit the "Data Sheet" only.

After customization, you can upload this back on Screener.

Upload on: [Link]

Download your customized workbooks now onwards.

Now whenever you will "Export to excel" from Screener, it will export your customized file.

TESTING:
This is a testing feature currently.
You can report any formula errors on the worksheet at: support@[Link]
s… do ANYTHING.
COMPANY NAME INTERGLOBE AVIATION LTD
LATEST VERSION 2.10 PLEAS
CURRENT VERSION 2.10

META
Number of shares 38.64
Face Value 10.00
Current Price 5,521.00
Market Capitalization 213,353.18

PROFIT & LOSS

Report Date Mar-16 Mar-17 Mar-18 Mar-19
Sales 16,139.91 18,580.50 23,020.89 28,496.77
Raw Material Cost 114.78 123.83 123.88 139.80
Change in Inventory 1.13 0.29 -1.27 0.66
Power and Fuel 4,779.32 6,341.51 7,760.14 11,942.79
Other Mfr. Exp 3,068.19 6,496.88 8,177.60 10,945.71
Employee Cost 1,787.98 2,048.39 2,456.23 3,138.67
Selling and admin 3,096.67 1,201.47 1,199.09 1,771.08
Other Expenses 129.98 150.04 272.85 710.31
Other Income 515.12 789.07 946.81 1,324.86
Depreciation 505.47 457.25 436.88 759.58
Interest 350.26 406.15 413.09 563.40
Profit before tax 2,823.51 2,144.34 3,126.67 -149.05
Tax 837.34 485.15 884.30 -305.18
Net profit 1,986.16 1,659.19 2,242.37 156.14
Dividend Amount 540.54 1,229.00 230.65 192.20

Quarters
Report Date Dec-22 Mar-23 Jun-23 Sep-23
Sales 14,932.97 14,160.60 16,683.10 14,943.88
Expenses 11,819.34 11,412.23 11,715.30 12,747.56
Other Income 475.73 438.37 477.40 558.27
Depreciation 1,341.88 1,352.49 1,404.30 1,545.46
Interest 829.31 918.23 953.70 1,021.27
Profit before tax 1,418.17 916.02 3,087.20 187.86
Tax
Net profit 1,418.17 916.02 3,087.20 187.86
Operating Profit 3,113.63 2,748.37 4,967.80 2,196.32

BALANCE SHEET
Report Date Mar-16 Mar-17 Mar-18 Mar-19
Equity Share Capital 360.36 361.47 384.41 384.41
Reserves 2,362.83 3,417.75 6,693.04 6,560.38
Borrowings 3,244.63 2,596.17 2,452.72 2,429.17
Other Liabilities 6,661.69 8,834.37 11,599.17 15,637.78
Total 12,629.51 15,209.76 21,129.34 25,011.74
Net Block 4,747.41 3,793.84 4,578.81 5,662.04
Capital Work in Progress 31.97 25.19 32.49 23.63
Investments 986.16 3,713.44 6,344.04 6,516.70
Other Assets 6,863.97 7,677.29 10,174.00 12,809.37
Total 12,629.51 15,209.76 21,129.34 25,011.74
Receivables 157.11 158.70 226.32 362.47
Inventory 87.11 163.15 183.23 211.44
Cash & Bank 3,718.67 4,632.54 6,580.60 8,606.36
No. of Equity Shares ### ### ### ###
New Bonus Shares
Face value 10.00 10.00 10.00 10.00

CASH FLOW:
Report Date Mar-16 Mar-17 Mar-18 Mar-19
Cash from Operating Activity 3,115.72 3,782.07 3,903.10 3,160.00
Cash from Investing Activity -1,337.14 -3,033.12 -4,151.54 -2,525.68
Cash from Financing Activity -1,219.96 -1,401.21 765.96 -592.16
Net Cash Flow 558.62 -652.26 517.52 42.16

PRICE: 873.20 1,051.40 1,290.45 1,428.15

DERIVED:
Adjusted Equity Shares in Cr 36.04 36.15 38.44 38.44
 PLEASE DO NOT MAKE ANY CHANGES TO THIS SHEET

Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Mar-25

35,756.00 14,640.63 25,930.93 54,446.45 68,904.34 80,803.00
180.91 54.32 118.14 287.24 336.86 383.40
3.05 -1.16 1.68 1.24 -5.41 0.20
12,453.79 3,831.28 9,695.24 23,646.02 23,904.58 26,197.30
10,496.59 6,829.16 9,578.33 14,725.76 19,272.06
4,396.83 3,028.20 3,154.04 4,326.60 5,841.92 6,730.10
2,331.97 1,196.01 1,653.48 1,606.70 2,012.61
1,829.89 -301.90 1,175.17 3,334.61 1,199.60 29,486.20
1,531.31 1,036.33 724.54 1,431.44 2,325.57 3,306.80
3,973.61 4,698.69 5,067.85 5,101.24 6,405.61 8,636.60
1,901.86 2,169.84 2,385.93 3,167.68 4,208.02 5,088.90
-275.09 -5,829.80 -6,171.03 -316.72 8,043.24 7,587.50
-26.93 -124.24 334.20
-248.16 -5,829.79 -6,171.03 -316.72 8,167.49 7,253.30
386.40

Dec-23 Mar-24 Jun-24 Sep-24 Dec-24 Mar-25

19,452.10 17,825.30 19,570.70 16,969.60 22,110.70 22,152.00
14,307.90 13,841.10 14,424.60 15,351.80 16,950.70 16,069.70
609.80 680.00 679.70 790.50 883.50 953.10
1,660.30 1,795.50 1,866.50 2,077.60 2,215.40 2,477.10
1,095.20 1,099.10 1,157.60 1,240.10 1,308.10 1,383.10
2,998.50 1,769.60 2,801.70 -909.40 2,520.00 3,175.20
-124.30 75.00 79.40 78.00 101.80
 2,998.50 1,893.90 2,726.70 -988.80 2,442.00 3,073.40
5,144.20 3,984.20 5,146.10 1,617.80 5,160.00 6,082.30

Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Mar-25

384.80 384.91 385.26 385.55 385.98 386.40
5,477.64 -314.00 -6,420.55 -6,694.56 1,545.95 8,920.40
22,719.17 29,859.65 36,877.84 44,860.10 51,280.02 67,088.40
13,466.85 13,043.69 15,017.56 20,491.59 28,856.87 39,518.70
42,048.46 42,974.25 45,860.11 59,042.68 82,068.82 115,913.90
16,778.20 18,815.47 21,282.07 27,649.97 36,036.57 51,567.10
140.24 71.74 125.31 20.77 1.48 0.70
9,499.35 7,290.17 8,032.61 11,514.35 16,453.16 26,402.10
15,630.67 16,796.87 16,420.12 19,857.59 29,577.61 37,944.00
42,048.46 42,974.25 45,860.11 59,042.68 82,068.82 115,913.90
259.61 219.17 332.92 519.90 642.52 739.80
286.13 316.42 408.06 591.07 624.80 820.30
10,829.41 11,227.06 10,116.52 11,810.57 16,709.34 18,859.40
### ### ### ### ###

10.00 10.00 10.00 10.00 10.00 10.00

Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Mar-25

6,943.30 -1,620.40 2,064.10 12,703.14 21,182.80 24,064.70
-4,572.56 3,227.98 1,527.17 -4,038.53 -11,759.13 -12,783.60
-2,407.48 -1,775.34 -3,087.84 -8,432.46 -9,978.53 -10,974.90
-36.74 -167.76 503.43 232.15 -554.86 306.20

1,066.15 1,631.95 2,014.15 1,910.65 3,548.65 5,115.35

38.48 38.49 38.53 38.55 38.60 38.64