TATA STEEL FM.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	TATA STEEL BALANCE SHEET
2
3	SR NO.	PARTICULAR	FY17	FY18	FY19	FY20	FY21	FY22	FY23	FY24
4		ASSET					( crore)
5	A)	NON-CURRENT ASSET
6	1	Property, plant and equipment	86,880.59	90,322.78	118,450.97	119,503.98	119,003.50	126,011.85	156,030.81	192,169.13
7	2	Capital work-in-progress	15,514.37	16,159.80	17,956.51	18,862.06	18,128.74	20,231.51	22,578.19	25,197.06
8	3	Right-of-use assets				8,549.78	9,450.95	9,450.95	9,450.95	9,450.95
9	4	Goodwill on consolidation	3,494.73	4,099.45	3,996.62	4,054.53	4,344.69	4,344.69	4,344.69	4,344.69
10	5	Other intangible assets	1,631.23	1,682.66	1,994.32	2,442.37	2,976.04	2,976.04	2,976.04	2,976.04
11	6	Intangible assets under development	269.76	454.61	684.7	634.77	878.66	878.66	878.66	878.66		Sales %
12	7	Equity accounted investments	1,593.68	1,781.22	1,922.95	2,168.54	2,475.66	2514.87	2554.71	2595.17		2%
13	8	Financial assets
14		Investments	5,190.31	1,209.28	1,290.36	684.77	987.38	1,045.50	1,251.97	1,499.20		1%
15		Loans	373.06	717.34	613.34	488.71	336.57	356.38	426.76	511.04		0.22%
16		Derivative assets	83.17	29.16	108.74	279.64	162.66	23,760.04	28,452.16	34,070.88		14%
17		Other financial assets	85.58	87.91	570.06	588.93	214.93	227.58	272.52	326.34		0.14%
18	9	Retirement benefit assets	1,752.64	20,570.87	19,964.19	27,278.45	20,019.47	21,197.90	25,384.05	30,396.87		13%
19	10	Non-current tax assets	981.23	1,152.76	1,574.78	1,725.67	1,845.34	1,953.96	2,339.83	2,801.90		1%
20	11	Deferred tax assets	885.87	1,035.80	808.95	1,270.33	1,578.02	1,670.91	2,000.88	2,396.01		1%
21	12	Other assets	3,674.96	2,577.14	4,654.92	3,154.20	2,872.70	3,041.80	3,642.49	4,361.81		2%
22		Total non-current assets	122,411.18	141,880.78	174,591.41	191,686.73	185,275.31	219,662.65	262,584.71	313,975.76
23
24	B)	Current assets
25	1	Inventories	24,803.82	28,331.04	31,656.10	31,068.72	33,276.38	33436.94827	40866.53009	48567.78704
26	2	Financial assets:										19	20	21	22	23	24
27		Investments	5,673.13	14,908.97	2,524.86	3,431.87	7,218.89	4,702.17	6,449.82	8,475.71		2%	2%	5%	3%	3%	4%
28		Trade receivables	11,586.82	12,415.52	11,811.00	7,884.91	9,539.84	6,985.94	10,739.02	8,272.13
29		Cash and cash equivalents	4,832.29	7,783.50	2,975.53	7,541.96	5,532.08	5000	5000	5000
30		Other balances with banks	88.76	154.35	365.84	512.76	250.1
31		Loans	224.5	256.48	239.7	215.68	64.72	68.53	82.06	98.27		0%
32		Derivative assets	104.04	150.95	359.11	1,486.06	498.79	498.79	498.79	498.79
33		Other financial assets	387.82	610.6	1,248.56	446.42	1,420.97	1,504.61	1,801.74	2,157.55		1%
34	3	Retirement benefit assets		2.91	4.38	0	0.42	77.61	92.94	111.29		0.05%
35	4	Current tax assets	35.08	62.28	133.94	143.2	156.74	165.02	197.61	236.63		0.10%
36	5	Other assets	2,194.38	3,098.09	3,529.70	3,177.69	2,153.44	2,280.20	2,730.49	3,269.71		1.38%
37		Total current assets	49,930.64	67,774.69	54,848.72	55,909.27	60,112.37	54,719.82	68,459.00	76,687.88
38		Assets held for sale	991.42	102.47	4,142.26	2,823.45	99.53	99.53	99.53	99.53
39		Total assets	173,333.24	209,757.94	233,582.39	250,419.45	245,487.21	274,482.00	331,143.24	390,763.16
40
41		Equity and liabilities
42	C)	Equity
43	1	Equity share capital	970.24	1,144.95	1,144.94	1,144.95	1,197.61	1,197.61	1,197.61	1,197.61
44	2	Hybrid perpetual securities	2,275.00	2,275.00	2,275.00	2,275.00	775	775	775	775
45	3	Other equity	34,574.08	57,450.67	65,505.14	70,156.35	72,266.16	83,611.72	96,262.32	114,008.80
46		Equity attributable to owners of the Company	37,819.32	60,870.62	68,925.08	73,576.30	74,238.77	85,584.33	98,234.93	115,981.41
47		Non-controlling interests	1,601.70	936.52	2,364.46	2,586.60	3,269.68	3,269.68	3,269.68	3,269.68
48		Total equity	39,421.02	61,807.14	71,289.54	76,162.90	77,508.45	88,854.01	101,504.61	119,251.09
49
50	D)	Non-current liabilities
51	1	Financial liabilities:
52		Borrowings	64,022.27	72,789.10	80,342.73	94,104.97	72,408.79	61,387.68	81,561.06	98,797.32
53		Derivative liabilities	179.98	85.04	59.82	127.92	71.41	71.41	71.41	71.41
54		Other financial liabilities	108.78	105.83	270.58	387.67	522.7	553.47	662.77	793.65		0%
55	2	Provisions	4,279.69	4,338.24	4,046.21	4,235.07	4,691.92	4,968.11	5,949.20	7,124.05		3%
56	3	Retirement benefit obligations	2,666.27	2,516.56	2,653.46	3,598.18	3,499.79	3,705.80	4,437.62	5,313.96		2%
57	4	Deferred income	2,057.59	1,526.58	906.8	151.3	144.26	152.75	182.92	219.04		0%
58	5	Deferred tax liabilities	10,030.08	10,569.88	12,459.89	9,261.38	9,241.42	9,785.41	11,717.82	14,031.85		6%
59	6	Other liabilities	226.51	358.16	519.23	729.15	6,531.34	6,915.80	8,281.53	9,916.96		4%
60		Total non-current liabilities	83,571.17	92,289.39	101,258.72	112,595.64	97,111.63	87,540.42	112,864.33	136,268.25
61
62	E)	Current liabilities
63	1	Financial liabilities:
64		Borrowings	18,328.10	15,884.98	10,802.08	19,184.48	9,492.11	34658.34327	46047.86282	55779.13593
65		Trade payables:	18,574.46	20413.81	21716.96	21380.85	25967.49	28013.83	36999.41	38717.59
66		Total outstanding dues of micro and small enterprises						0	0	0
67		Total outstanding dues of creditors other than micro and small enterprises						0.00	0.00	0
68		Derivative liabilities	673.67	468.79	416.59	729.22	510.01	510.01	510.01	510.01	Sales
69		Other financial liabilities	6,315.51	9,791.78	16,737.83	9,518.53	14,403.11	15,250.93	18262.68	21,869.19	9%
70	2	Provisions	987.38	1,269.64	1,248.72	1,663.67	4,725.32	5,003.47	5991.55	7,174.76	3%
71	3	Retirement benefit obligations	95.2	110.36	120.69	141.26	166.84	176.66	211.55	253.32	0%
72	4	Deferred income	22.52	6.21	16.51	34.55	63.98	67.75	81.12	97.15	0%
73	5	Current tax liabilities	739.18	783.47	636.42	609.58	4,424.44	4,684.88	5610.05	6,717.92	3%
74	6	Other liabilities	4,315.27	6,932.26	7,912.21	7,050.44	11,113.83	11,768.03	14091.98	16,874.86	7%
75		Total current liabilities	50,051.29	55,661.30	59,608.01	60,312.58	70,867.13	100,133.91	127,806.21	147,993.92
76		Liabilities held for sale	289.76	0.11	1,426.12	1,348.33	0	0	0	0
77		Total equity and liabilities	173,333.24	209,757.94	233,582.39	250,419.45	245,487.21	276,528.33	342,175.16	403,513.26
78			0.00	0.00	0.00	0.00	0.00	2,046.34	11,031.92	12,750.10
79			These values are extra because in trade payable double values are taken
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100