ExcelDrag here to set row groups
Drag here to set column labels
Name
2020FY
2021FY
2022FY
2023FY
2024FY
PROFIT & LOSS (P&L)
Revenue
Cost of Revenue
Gross Profit
Total Operating Cost
Operating Profit
EBIT
Depreciation & Amortization
EBITDA
Leases (Operating + Other)
EBITDAR
Adjusted EBITDA
Interest Expense(Incl Cap Int)
Interest Income
Net Interest Expenses (Incl Cap Int)
Net Income before Taxes
Net Income
CASH FLOW BREAKDOWN
Cash tax
Others
FFO (pre-cash interest)
Cash interest
FFO
Change in net working capital
OCF / CFO (post int. and tax)
Asset disposals
Capex
Net Capex
FOCF (pre-leases)
Lease Payments / Reversal
FOCF (pre-M&A)
Investments (Acquisitions/Contributions)
Divestments (Sales/Disposals/Distributions)
Net M&A
Dividends Paid
Share buybacks
Other Adjustments to FCF
FCF
Equity issuance
Cash flow available for debt servicing(Operating Cash Method)
Cash flow available for debt servicing(Free Cash Flow Method)
DEBT
Short-term Debt
Long-term Debt
Total Debt
DEBT STRUCTURE
Secured Debt
Unsecured Debt
Lease in Debt
Subordinated Debt
Hybrid and Other Debt Instruments
Gross Debt
DEBT ADJUSTMENTS
Off-Balance Sheet Liabilities
Pension & Other-post employment benefits
Lease not in Debt
Other adjustments to debt
Total Debt (adj.)
Cash & Cash Equivalent
Net Debt
Net Debt (adj.)
Total equity
Total assets
114,387.7
125,496
171,187.9
208,519.1
267,105.6
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
43,873.2
67,891.3
62,012.7
66,054.9
123,401.8
43,873.2
67,891.3
62,012.7
66,054.9
123,401.8
-16,802.8
-21,073.4
-30,993
-34,247.1
-38,884.6
75,650
80,630
106,070
128,330
158,640
-64.9
-47.7
-181.6
-114.7
-102.4
75,714.9
80,677.7
106,251.6
128,444.7
158,742.4
75,650
80,630
106,070
128,330
158,640
-18,219.4
-20,420.8
-24,699.1
-24,538.9
-25,507.1
15,855.2
16,021.6
18,143.1
11,157.1
6,937.5
-2,364.2
-4,399.2
-6,556
-13,381.8
-18,569.6
42,439.2
62,920.1
57,171.4
54,868.9
100,937.3
37,845.3
50,487.4
49,531.8
53,908.5
81,039.9
-8,495.7
-8,728.3
-9,597.2
-8,474
-12,719.2
N/A
N/A
N/A
N/A
N/A
67,154.3
71,901.7
96,472.8
119,856
145,920.8
535
2,184.7
-7,312
-9,100
-18,393.5
67,689.3
74,086.4
89,160.8
110,756
127,527.3
9,909.3
4,083.9
7,583.9
-8,741.3
-95.5
77,598.6
78,170.3
96,744.7
102,014.7
127,431.8
629.9
38
129.1
2,037.9
267.1
-36,214.1
-23,517
-38,137
-91,410.4
-74,163
-35,584.2
-23,479
-38,007.9
-89,372.5
-73,895.9
42,014.4
54,691.3
58,736.8
12,642.2
53,535.9
-134.2
-181
-617
-530.1
-475.3
41,880.2
54,510.3
58,119.8
12,112.1
53,060.6
-7,539.7
-136,907.5
-6,555.7
-144,307.8
-36,349.9
784.7
3,244.6
2,730.8
0
2,477.7
-6,755
-133,662.9
-3,824.9
-144,307.8
-33,872.2
-6,999.3
-2.3
-10,266.5
-10,929.1
-10,796.8
-19,724
0
-54,268.8
-250.2
0
N/A
N/A
N/A
N/A
N/A
8,401.9
-79,154.9
-10,240.4
-143,375
8,391.6
0
0
9,092.5
9,455
2,351.6
37,804
52,040.8
66,064.4
27,584.6
76,012.8
8,401.9
-79,154.9
-1,147.9
-133,920
10,743.2
38,944.6
20,052.6
60,608
40,014.9
86,163
261,813.3
329,355.3
396,914.8
465,169.4
376,629.3
300,757.9
349,407.9
457,522.8
505,184.3
462,792.3
85,335.5
108,765.2
122,583.1
121,537
106,234.3
215,422.4
240,642.7
334,939.7
383,647.3
356,558
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
300,757.9
349,407.9
457,522.8
505,184.3
462,792.3
22,206.6
5,057.6
6,213.3
10,561.7
13,106.9
55.1
197.8
268.3
2,492.1
2,821.6
6,063.3
7,480.1
20,159.4
27,492.6
30,244.8
17,562.8
24,232.1
21,826.3
29,444
38,623
346,645.7
386,375.5
505,990.1
575,174.7
547,588.6
71,954.6
41,980.4
86,530.2
11,211.1
15,757.3
227,431.4
299,378.5
319,650
444,233.9
371,231.5
274,691.1
344,395.1
419,459.9
563,963.6
531,831.3
258,430.8
320,731.9
423,809.9
469,169.8
545,430
622,036.7
754,636.6
996,858.2
1,147,630.9
1,189,178.7
to
of
Page
of
Click on values to load pdf