COMPANY NAME ICICI BANK LTD
LATEST VERSION 2.10
CURRENT VERSION 2.10
META
Number of shares 712.30
Face Value 2.00
Current Price 1,392.55
Market Capitalization 991,906.66
PROFIT & LOSS
Report Date Mar-21 Mar-22 Mar-23
Sales 89,162.66 95,406.87 121,066.81
Raw Material Cost
Change in Inventory
Power and Fuel
Other Mfr. Exp 2,178.52 2,699.47 3,464.42
Employee Cost 11,063.46 12,353.95 15,247.91
Selling and admin 6,402.88 6,167.72 7,565.20
Other Expenses 71,664.11 59,577.23 61,586.85
Other Income 72,173.81 62,129.45 65,111.99
Depreciation 1,340.07 1,330.01 1,514.56
Interest 42,659.09 41,166.67 50,543.39
Profit before tax 26,028.34 34,241.27 46,256.47
Tax 5,664.37 8,457.44 11,793.44
Net profit 18,384.32 25,110.10 34,036.64
Dividend Amount 1,383.41 3,474.92 5,587.12
Quarters
Report Date Mar-24 Jun-24 Sep-24
Sales 42,606.72 44,581.65 46,325.78
Expenses 30,604.33 29,387.05 32,220.79
Other Income 24,574.98 22,745.28 26,661.96
Depreciation
Interest 20,423.73 21,121.62 22,225.30
Profit before tax 16,153.64 16,818.26 18,541.65
Tax 4,180.91 4,355.45 4,635.66
Net profit 11,671.52 11,695.84 12,947.77
Operating Profit 12,002.39 15,194.60 14,104.99
BALANCE SHEET
Report Date Mar-21 Mar-22 Mar-23
Equity Share Capital 1,383.41 1,389.97 1,396.78
Reserves 156,204.09 180,662.52 213,101.01
Borrowings 1,103,839.96 1,252,968.47 1,399,893.96
Other Liabilities 312,384.79 317,616.42 344,098.75
Total 1,573,812.25 1,752,637.38 1,958,490.50
Net Block 10,809.26 10,706.74 11,070.34
Capital Work in Progress
Investments 536,578.62 567,097.72 639,551.97
Other Assets 1,026,424.37 1,174,832.92 1,307,868.19
Total 1,573,812.25 1,752,637.38 1,958,490.50
Receivables
Inventory
Cash & Bank 147,570.53 183,125.98 136,456.49
No. of Equity Shares ### ### ###
New Bonus Shares
Face value 2.00 2.00 2.00
CASH FLOW:
Report Date Mar-21 Mar-22 Mar-23
Cash from Operating Activity 138,015.30 58,111.43 -3,771.19
Cash from Investing Activity -63,630.92 -39,448.29 -67,689.02
Cash from Financing Activity -54,666.77 17,451.00 24,790.72
Net Cash Flow 19,717.61 36,114.14 -46,669.49
PRICE: 582.10 730.30 877.25
DERIVED:
Adjusted Equity Shares in Cr 691.60 694.88 698.28
PLEASE DO NOT MAKE ANY CHANGES TO THIS SHEET
Mar-24 Mar-25
159,515.93 186,331.47
3,617.18
19,186.58 23,629.94
7,643.68
69,112.55 109,075.80
76,521.80 108,255.47
1,935.21
74,108.16 89,027.65
60,434.37 72,853.55
15,427.62 18,434.83
44,256.37 51,029.20
7,023.40 7,835.30
Dec-24 Mar-25
47,037.12 48,386.92
33,510.13 37,587.77
27,589.44 31,360.85
22,633.41 23,047.32
18,483.02 19,112.68
4,654.41 4,789.31
12,883.37 13,502.22
13,526.99 10,799.15
Mar-24 Mar-25
1,404.68 1,424.60
254,739.16 310,411.47
1,651,007.95 1,860,520.84
456,911.23 469,884.50
2,364,063.02 2,642,241.41
15,714.44 15,812.42
827,162.51 886,376.81
1,521,186.07 1,740,052.18
2,364,063.02 2,642,241.41
162,768.90
###
2.00 2.00
Mar-24 Mar-25
157,284.48 122,805.26
-144,736.58 -77,288.36
13,764.51 5,589.23
26,312.41 51,106.13
1,093.30 1,348.35
702.23 712.19
COMPANY NAME INFOSYS LTD
LATEST VERSION 2.10
CURRENT VERSION 2.10
META
Number of shares
Face Value 5
Current Price 1482.6
Market Capitalization 615762.87
PROFIT & LOSS
Report Date Mar-21 Mar-22 Mar-23
Sales 100472 121641 146767
Raw Material Cost
Change in Inventory
Power and Fuel 143 132 176
Other Mfr. Exp 12800 20690 26330
Employee Cost 55547 63997 78374
Selling and admin 3194 4305 5300
Other Expenses 899 1026 1457
Other Income 2201 2295 2701
Depreciation 3267 3476 4225
Interest 195 200 284
Profit before tax 26628 30110 33322
Tax 7205 7964 9214
Net profit 19351 22110 24095
Dividend Amount 11469.6 13007.6 14069.2
Quarters
Report Date Mar-24 Jun-24 Sep-24
Sales 37923 39315 40986
Expenses 29139 29878 31177
Other Income 2729 838 712
Depreciation 1163 1149 1160
Interest 110 105 108
Profit before tax 10240 9021 9253
Tax 2265 2647 2737
Net profit 7969 6368 6506
Operating Profit 8784 9437 9809
BALANCE SHEET
Report Date Mar-21 Mar-22 Mar-23
Equity Share Capital 2124 2098 2069
Reserves 74227 73252 73338
Borrowings 5325 5474 8299
Other Liabilities 25835 35905 40890
Total 107511 116729 124596
Net Block 25505 25800 29225
Capital Work in Progress 922 416 288
Investments 14205 20324 19478
Other Assets 66879 70189 75605
Total 107511 116729 124596
Receivables 19294 22698 25424
Inventory
Cash & Bank 24714 17472 12173
No. of Equity Shares 4245146114 4193012929 4136387925
New Bonus Shares
Face value 5 5 5
CASH FLOW:
Report Date Mar-21 Mar-22 Mar-23
Cash from Operating Activity 23224 23885 22467
Cash from Investing Activity -7373 -6485 -1071
Cash from Financing Activity -9786 -24642 -26695
Net Cash Flow 6065 -7242 -5299
PRICE: 1368.05 1906.85 1427.95
DERIVED:
Adjusted Equity Shares in Cr 426.07 420.67 414.86
PLEASE DO NOT MAKE ANY CHANGES TO THIS SHEET
Mar-24 Mar-25
153670 162990
199 222
27195 30395
82636 85968
5705 6039
1510 1130
4711 3600
4678 4812
470 416
35988 37608
9740 10858
26233 26713
19053.2 17827.8
Dec-24 Mar-25
41764 40925
31649 31051
859 1190
1203 1299
101 102
9670 9663
2848 2625
6806 7033
10115 9874
Mar-24 Mar-25
2071 2073
86045 93745
8359 8227
40885 43750
137360 147795
27622 30961
293 814
24623 23541
84822 92479
137360 147795
30193 31158
14786 24455
4139950635 4143607528
5 5
Mar-24 Mar-25
25210 35694
-5093 -1864
-17504 -24161
2613 9669
1498.05 1570.65
415.09 415.33
CHANGES TO THIS SHEET
COMPANY NAME EMAMI LTD
LATEST VERSION 2.10
CURRENT VERSION 2.10
META
Number of shares 43.65
Face Value 1.00
Current Price 622.50
Market Capitalization 27,172.11
PROFIT & LOSS
Report Date Mar-20 Mar-21 Mar-22
Sales 2,654.88 2,880.53 3,192.03
Raw Material Cost 884.56 948.63 1,123.77
Change in Inventory 8.47 19.40 45.89
Power and Fuel 22.47 21.50 22.52
Other Mfr. Exp 38.22 36.12 42.87
Employee Cost 305.52 315.17 323.73
Selling and admin 676.07 650.02 733.50
Other Expenses 51.98 48.23 53.75
Other Income 46.38 68.89 90.07
Depreciation 336.33 366.95 334.78
Interest 21.01 13.27 5.07
Profit before tax 373.57 568.93 688.00
Tax 71.27 114.21 -148.66
Net profit 302.91 454.70 838.99
Dividend Amount 181.28 355.60 352.96
Quarters
Report Date Dec-23 Mar-24 Jun-24
Sales 996.32 891.24 906.07
Expenses 682.48 681.83 691.66
Other Income 10.81 10.70 10.46
Depreciation 45.81 48.00 44.43
Interest 2.71 2.88 2.06
Profit before tax 276.13 169.23 178.38
Tax 15.48 22.48 27.78
Net profit 258.41 148.90 152.64
Operating Profit 313.84 209.41 214.41
BALANCE SHEET
Report Date Mar-20 Mar-21 Mar-22
Equity Share Capital 45.32 44.45 44.12
Reserves 1,778.43 1,718.20 2,032.48
Borrowings 210.24 100.74 281.55
Other Liabilities 644.49 656.30 691.79
Total 2,678.48 2,519.69 3,049.94
Net Block 1,459.17 1,131.83 1,343.92
Capital Work in Progress 8.05 6.43 3.08
Investments 156.42 255.33 302.69
Other Assets 1,054.84 1,126.10 1,400.25
Total 2,678.48 2,519.69 3,049.94
Receivables 308.01 231.75 320.92
Inventory 244.65 300.45 357.61
Cash & Bank 119.06 360.37 116.00
No. of Equity Shares ### ### ###
New Bonus Shares ### ### ###
Face value 1.00 1.00 1.00
CASH FLOW:
Report Date Mar-20 Mar-21 Mar-22
Cash from Operating Activity 530.75 921.53 643.85
Cash from Investing Activity -231.02 -224.38 -233.95
Cash from Financing Activity -405.36 -688.18 -402.14
Net Cash Flow -105.63 8.97 7.76
PRICE: 169.95 486.00 447.15
DERIVED:
Adjusted Equity Shares in Cr 45.39 44.45 44.12
PLEASE DO NOT MAKE ANY CHANGES TO THIS SHEET
Mar-23 Mar-24
3,405.73 3,578.09
1,164.43 1,176.07
-36.93 15.53
22.62 23.37
51.70 52.23
374.68 409.40
838.91 919.40
61.20 67.33
68.93 40.90
247.25 185.91
7.39 9.98
669.55 790.83
42.14 66.70
639.57 723.53
352.96 349.20
Sep-24 Dec-24
890.59 1,049.48
644.74 715.29
21.56 14.93
44.65 45.60
2.33 2.17
220.43 301.35
9.44 22.37
212.66 278.99
245.85 334.19
Mar-23 Mar-24
44.12 43.65
2,258.68 2,402.94
90.51 93.95
703.10 728.28
3,096.41 3,268.82
1,245.35 1,113.63
6.33 7.55
293.36 441.54
1,551.37 1,706.10
3,096.41 3,268.82
414.60 494.21
328.04 323.40
184.74 201.38
### ###
###
1.00 1.00
Mar-23 Mar-24
748.88 779.01
-122.02 -209.87
-607.64 -562.97
19.21 6.17
358.55 429.35
44.12 43.65
COMPANY NAME SUN PHARMACEUTICAL INDUSTRIES LTD
LATEST VERSION 2.10
CURRENT VERSION 2.10
META
Number of shares 239.93
Face Value 1.00
Current Price 1,771.10
Market Capitalization 424,946.21
PROFIT & LOSS
Report Date Mar-20 Mar-21 Mar-22
Sales 32,837.50 33,498.14 38,654.49
Raw Material Cost 8,929.60 9,328.30 10,459.15
Change in Inventory -300.85 638.22 107.61
Power and Fuel 621.89 627.09 702.78
Other Mfr. Exp 1,690.00 1,723.78 1,880.71
Employee Cost 6,362.35 6,862.23 7,300.83
Selling and admin 6,995.37 6,283.41 7,366.88
Other Expenses 954.60 841.59 794.18
Other Income 382.26 -3,449.21 -3,505.16
Depreciation 2,052.78 2,079.95 2,143.74
Interest 302.73 141.43 127.35
Profit before tax 5,009.59 2,799.37 4,481.32
Tax 822.80 514.69 1,075.50
Net profit 3,764.93 2,903.82 3,272.73
Dividend Amount 959.72 1,799.48 2,399.30
Quarters
Report Date Dec-23 Mar-24 Jun-24
Sales 12,380.70 11,982.90 12,652.75
Expenses 8,903.87 8,947.75 9,045.13
Other Income 180.39 504.30 532.55
Depreciation 622.14 650.36 655.13
Interest 34.73 73.57 61.54
Profit before tax 3,000.35 2,815.52 3,423.50
Tax 432.32 148.93 552.25
Net profit 2,523.75 2,654.58 2,835.62
Operating Profit 3,476.83 3,035.15 3,607.62
BALANCE SHEET
Report Date Mar-20 Mar-21 Mar-22
Equity Share Capital 239.93 239.93 239.93
Reserves 45,024.52 46,222.85 47,771.29
Borrowings 8,314.88 3,868.58 1,290.30
Other Liabilities 14,614.99 17,290.86 20,474.39
Total 68,194.32 67,622.22 69,775.91
Net Block 22,846.91 21,552.98 22,665.16
Capital Work in Progress 1,220.34 1,566.83 1,286.80
Investments 10,143.11 9,612.45 12,848.59
Other Assets 33,983.96 34,889.96 32,975.36
Total 68,194.32 67,622.22 69,775.91
Receivables 9,421.24 9,061.40 10,484.59
Inventory 7,874.99 8,997.02 8,925.13
Cash & Bank 6,487.55 6,445.51 5,033.35
No. of Equity Shares ### ### ###
New Bonus Shares
Face value 1.00 1.00 1.00
CASH FLOW:
Report Date Mar-20 Mar-21 Mar-22
Cash from Operating Activity 6,554.77 6,170.37 8,984.54
Cash from Investing Activity -2,225.32 406.53 -5,555.86
Cash from Financing Activity -5,715.14 -5,980.48 -5,193.46
Net Cash Flow -1,385.69 596.42 -1,764.78
PRICE: 352.30 597.80 914.75
DERIVED:
Adjusted Equity Shares in Cr 239.93 239.93 239.93
PLEASE DO NOT MAKE ANY CHANGES TO THIS SHEET
Mar-23 Mar-24
43,885.68 48,496.85
11,349.07 10,370.48
686.91 -292.13
830.05 760.78
1,936.77 2,186.62
8,296.03 9,429.06
9,482.36 11,033.19
1,027.87 1,406.82
459.42 865.23
2,529.43 2,556.64
172.00 238.47
9,408.43 11,087.89
847.59 1,439.45
8,473.58 9,576.38
2,759.20 3,239.06
Sep-24 Dec-24
13,291.39 13,675.46
9,352.43 9,666.44
354.00 149.45
625.91 630.56
69.17 51.51
3,597.88 3,476.40
567.21 558.86
3,040.16 2,903.38
3,938.96 4,009.02
Mar-23 Mar-24
239.93 239.93
55,755.45 63,426.82
6,885.87 3,273.67
17,830.65 18,367.40
80,711.90 85,307.82
24,065.44 23,211.38
4,973.16 5,353.88
14,824.34 15,025.77
36,848.96 41,716.79
80,711.90 85,307.82
11,438.51 11,249.37
10,513.05 9,868.29
5,770.29 10,520.68
### ###
1.00 1.00
Mar-23 Mar-24
4,959.33 12,134.98
-7,219.92 -762.90
2,376.07 -6,710.16
115.48 4,661.92
983.10 1,620.55
239.93 239.93