KALYANI STEELS 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 1,180.18 1,257.42 1,345.06 1,406.58 1,198.93 1,187.99 1,706.03 1,899.35 1,959.49 1,981.90 1,981.90 2,083.44 2,004.57
Expenses 944.89 969.80 1,141.80 1,194.18 1,003.62 924.57 1,367.47 1,653.69 1,588.32 1,608.89 1,608.91 1,691.34 1,664.85
Operating Profit 235.29 287.62 203.26 212.40 195.31 263.42 338.56 245.66 371.17 373.01 372.99 392.10 339.72
Other Income 2.66 13.27 17.20 25.13 23.26 42.54 46.36 56.40 46.81 51.67 51.68 - -
Depreciation 51.73 52.03 37.22 38.40 42.62 44.15 45.88 48.90 60.75 63.39 63.38 63.38 63.38
Interest 12.03 9.63 8.64 6.63 8.05 6.77 13.21 28.10 24.55 18.57 18.56 18.56 18.56
Profit before tax 174.19 239.23 174.60 192.50 167.90 255.04 325.83 225.06 332.68 342.72 342.73 310.16 257.78
Tax 60.61 82.75 59.71 60.45 30.79 64.73 82.92 58.04 85.22 89.68 89.68 26% 26%
Net profit 113.58 156.48 114.88 132.05 137.12 190.30 242.92 167.03 247.46 253.03 253.03 229.00 190.33
EPS 25.99 35.81 26.29 30.22 31.38 43.55 55.59 38.22 56.63 57.90 57.83 52.34 43.50
Price to earning 6.47 10.09 11.32 7.11 4.06 7.32 5.33 7.71 15.12 13.21 13.22 13.22 9.13
Price 168.15 361.35 297.50 214.70 127.40 318.65 296.40 294.80 856.25 764.65 764.60 691.99 397.35

RATIOS:
Dividend Payout 0.00% 13.97% 19.03% 16.55% 15.94% 17.23% 18.00% 26.17% 17.67% 17.28%
OPM 19.94% 22.87% 15.11% 15.10% 16.29% 22.17% 19.84% 12.93% 18.94% 18.82% 18.82%

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

Sales Growth 5.93% 5.69% 10.58% 5.12% 1.14% 5.12% 1.14%
OPM 18.02% 17.63% 18.22% 16.95% 18.82% 18.82% 16.95%
Price to Earning 9.18 9.13 10.32 12.32 13.22 13.22 9.13
KALYANI STEELS LTD SCREENER.IN

Narration Dec-22 Mar-23 Jun-23 Sep-23 Dec-23 Mar-24 Jun-24 Sep-24 Dec-24 Mar-25
Sales 446.53 459.58 496.84 480.07 479.76 502.83 461.46 492.10 484.01 544.33
Expenses 389.77 357.71 404.41 386.98 384.17 412.75 382.26 395.97 400.66 430.02
Operating Profit 56.76 101.87 92.43 93.09 95.59 90.08 79.20 96.13 83.35 114.31
Other Income 16.18 14.81 12.45 9.07 12.24 13.04 12.41 14.08 12.44 12.75
Depreciation 12.40 13.32 15.82 14.91 14.77 15.26 15.98 15.90 15.74 15.76
Interest 8.61 8.57 6.84 8.79 5.45 3.47 4.07 4.81 5.52 4.16
Profit before tax 51.93 94.79 82.22 78.46 87.61 84.39 71.56 89.50 74.53 107.14
Tax 12.86 25.10 20.97 20.14 22.28 21.84 19.98 22.71 19.13 27.86
Net profit 39.08 69.70 61.25 58.32 65.33 62.55 51.57 66.79 55.39 79.28

OPM 13% 22% 19% 19% 20% 18% 17% 20% 17% 21%
KALYANI STEELS LTD SCREENER.IN

Narration Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Mar-25
Equity Share Capital 21.86 21.86 21.86 21.86 21.86 21.86 21.86 21.86 21.86 21.86
Reserves 567.66 679.91 762.87 868.70 942.07 1,132.35 1,345.60 1,467.61 1,669.58 1,882.57
Borrowings 327.17 238.86 168.84 17.88 - 168.38 438.24 506.35 596.24 437.60
Other Liabilities 337.92 420.80 324.71 421.90 400.48 327.78 550.53 354.71 296.70 402.96
Total 1,254.61 1,361.43 1,278.28 1,330.34 1,364.41 1,650.37 2,356.23 2,350.53 2,584.38 2,744.99

Net Block 487.75 436.29 437.35 422.48 418.50 382.44 358.43 599.44 733.84 677.85
Capital Work in Progress 0.35 4.92 4.71 5.09 5.22 10.67 154.33 17.87 381.15 429.49
Investments 249.12 234.32 279.65 366.01 177.46 144.21 147.46 146.13 145.38 150.20
Other Assets 517.39 685.90 556.57 536.76 763.23 1,113.05 1,696.01 1,587.09 1,324.01 1,487.45
Total 1,254.61 1,361.43 1,278.28 1,330.34 1,364.41 1,650.37 2,356.23 2,350.53 2,584.38 2,744.99

Working Capital 179.47 265.10 231.86 114.86 362.75 785.27 1,145.48 1,232.38 1,027.31 1,084.49
Debtors 345.86 465.09 376.31 308.86 235.51 249.10 416.44 404.70 420.84 431.35
Inventory 109.12 134.78 111.67 154.43 125.97 118.95 217.61 323.90 202.43 214.65

Debtor Days 106.97 135.00 102.12 80.15 71.70 76.53 89.10 77.77 78.39 79.44
Inventory Turnover 10.82 9.33 12.04 9.11 9.52 9.99 7.84 5.86 9.68 9.23

Return on Equity 19% 22% 15% 15% 14% 16% 18% 11% 15% 13%
Return on Capital Emp 27% 19% 21% 19% 23% 22% 13% 17% 16%
KALYANI STEELS LTD SCREENER.IN

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 160.57 152.36 191.31 285.77 256.87 62.38 262.98 -125.73 301.56 382.64
Cash from Investing Activity -255.17 -38.41 -76.71 -116.54 -183.31 -226.09 -469.93 153.14 -304.41 -135.71
Cash from Financing Activity 96.70 -98.20 -105.09 -181.39 -79.72 160.35 217.76 -39.05 11.65 -251.94
Net Cash Flow 2.11 15.76 9.51 -12.16 -6.16 -3.36 10.81 -11.64 8.80 -5.01
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: https://www.screener.in/excel/

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@screener.in
s… do ANYTHING.
COMPANY NAME KALYANI STEELS LTD
LATEST VERSION 2.10 PLEAS
CURRENT VERSION 2.10

META
Number of shares 4.38
Face Value 5.00
Current Price 764.60
Market Capitalization 3,345.38

PROFIT & LOSS

Report Date Mar-16 Mar-17 Mar-18 Mar-19
Sales 1,180.18 1,257.42 1,345.06 1,406.58
Raw Material Cost 432.57 613.31 745.39 809.85
Change in Inventory -8.75 6.05 -20.34 20.39
Power and Fuel 79.13 72.36 75.46 79.99
Other Mfr. Exp 239.67 150.64 164.95 205.67
Employee Cost 86.29 58.30 55.00 57.68
Selling and admin 55.66 56.83 50.32 43.66
Other Expenses 42.82 24.41 30.34 17.72
Other Income 2.66 13.27 17.20 25.13
Depreciation 51.73 52.03 37.22 38.40
Interest 12.03 9.63 8.64 6.63
Profit before tax 174.19 239.23 174.60 192.50
Tax 60.61 82.75 59.71 60.45
Net profit 113.58 156.48 114.88 132.05
Dividend Amount 21.86 21.86 21.86

Quarters
Report Date Dec-22 Mar-23 Jun-23 Sep-23
Sales 446.53 459.58 496.84 480.07
Expenses 389.77 357.71 404.41 386.98
Other Income 16.18 14.81 12.45 9.07
Depreciation 12.40 13.32 15.82 14.91
Interest 8.61 8.57 6.84 8.79
Profit before tax 51.93 94.79 82.22 78.46
Tax 12.86 25.10 20.97 20.14
Net profit 39.08 69.70 61.25 58.32
Operating Profit 56.76 101.87 92.43 93.09

BALANCE SHEET
Report Date Mar-16 Mar-17 Mar-18 Mar-19
Equity Share Capital 21.86 21.86 21.86 21.86
Reserves 567.66 679.91 762.87 868.70
Borrowings 327.17 238.86 168.84 17.88
Other Liabilities 337.92 420.80 324.71 421.90
Total 1,254.61 1,361.43 1,278.28 1,330.34
Net Block 487.75 436.29 437.35 422.48
Capital Work in Progress 0.35 4.92 4.71 5.09
Investments 249.12 234.32 279.65 366.01
Other Assets 517.39 685.90 556.57 536.76
Total 1,254.61 1,361.43 1,278.28 1,330.34
Receivables 345.86 465.09 376.31 308.86
Inventory 109.12 134.78 111.67 154.43
Cash & Bank 6.99 23.87 33.53 38.42
No. of Equity Shares 43,759,380.00 43,759,380.00 43,759,380.00 43,759,380.00
New Bonus Shares
Face value 5.00 5.00 5.00 5.00

CASH FLOW:
Report Date Mar-16 Mar-17 Mar-18 Mar-19
Cash from Operating Activity 160.57 152.36 191.31 285.77
Cash from Investing Activity -255.17 -38.41 -76.71 -116.54
Cash from Financing Activity 96.70 -98.20 -105.09 -181.39
Net Cash Flow 2.11 15.76 9.51 -12.16

PRICE: 168.15 361.35 297.50 214.70

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

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

1,198.93 1,187.99 1,706.03 1,899.35 1,959.49 1,981.90
636.52 587.20 996.77 1,187.49 1,118.43 1,137.46
12.05 -24.67 29.51 2.52 -2.36 -8.88
75.40 67.77 88.81 83.15 63.17
156.81 135.35 178.45 203.24 237.90
59.61 59.87 62.98 67.59 82.03 83.30
40.35 41.77 56.30 66.16 66.10
46.98 7.94 13.67 48.58 18.33 379.25
23.26 42.54 46.36 56.40 46.81 51.67
42.62 44.15 45.88 48.90 60.75 63.39
8.05 6.77 13.21 28.10 24.55 18.57
167.90 255.04 325.83 225.06 332.68 342.72
30.79 64.73 82.92 58.04 85.22 89.68
137.12 190.30 242.92 167.03 247.46 253.03
21.86 32.79 43.72 43.72 43.72 43.72

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

479.76 502.83 461.46 492.10 484.01 544.33
384.17 412.75 382.26 395.97 400.66 430.02
12.24 13.04 12.41 14.08 12.44 12.75
14.77 15.26 15.98 15.90 15.74 15.76
5.45 3.47 4.07 4.81 5.52 4.16
87.61 84.39 71.56 89.50 74.53 107.14
22.28 21.84 19.98 22.71 19.13 27.86
 65.33 62.55 51.57 66.79 55.39 79.28
95.59 90.08 79.20 96.13 83.35 114.31

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

21.86 21.86 21.86 21.86 21.86 21.86
942.07 1,132.35 1,345.60 1,467.61 1,669.58 1,882.57
168.38 438.24 506.35 596.24 437.60
400.48 327.78 550.53 354.71 296.70 402.96
1,364.41 1,650.37 2,356.23 2,350.53 2,584.38 2,744.99
418.50 382.44 358.43 599.44 733.84 677.85
5.22 10.67 154.33 17.87 381.15 429.49
177.46 144.21 147.46 146.13 145.38 150.20
763.23 1,113.05 1,696.01 1,587.09 1,324.01 1,487.45
1,364.41 1,650.37 2,356.23 2,350.53 2,584.38 2,744.99
235.51 249.10 416.44 404.70 420.84 431.35
125.97 118.95 217.61 323.90 202.43 214.65
360.54 625.96 974.22 749.48 541.05 704.21
43,759,380.00 43,759,380.00 43,759,380.00 43,759,380.00 43,759,380.00

5.00 5.00 5.00 5.00 5.00 5.00

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

256.87 62.38 262.98 -125.73 301.56 382.64
-183.31 -226.09 -469.93 153.14 -304.41 -135.71
-79.72 160.35 217.76 -39.05 11.65 -251.94
-6.16 -3.36 10.81 -11.64 8.80 -5.01

127.40 318.65 296.40 294.80 856.25 764.65

4.37 4.37 4.37 4.37 4.37 4.37