KALYAN JEWELLERS INDIA LTD SCREENER.

IN

Narration Dec-99 Dec-99 Dec-99 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Trailing Best Case Worst Case
Sales - - - 10,505.13 9,770.76 10,100.92 8,573.31 10,817.93 14,071.45 18,548.29 19,708.03 24,449.44 21,243.89
Expenses - - - 9,731.57 9,150.55 9,301.51 7,948.94 9,965.42 12,906.50 17,180.28 18,342.29 22,543.88 19,771.71
Operating Profit - - - 773.56 620.21 799.41 624.37 852.51 1,164.95 1,368.01 1,365.74 1,905.55 1,472.17
Other Income - - - 32.25 42.21 80.10 45.37 38.29 4.64 73.71 84.22 - -
Depreciation - - - 202.03 223.62 239.17 224.90 231.58 244.58 274.30 285.70 285.70 285.70
Interest - - - 389.99 417.87 419.46 405.48 360.37 353.48 378.59 326.41 326.41 326.41
Profit before tax - - - 213.79 20.93 220.88 39.36 298.85 571.53 788.83 837.85 1,293.44 860.06
Tax - - - 72.80 25.79 78.61 45.43 74.82 139.59 192.54 207.56 25% 25%
Net profit - - - 142.37 -3.61 143.00 -6.30 224.21 433.11 597.35 631.23 973.02 647.00
EPS - - - 1.70 -0.04 1.70 -0.06 2.18 4.20 5.80 6.12 9.44 6.27
Price to earning -1,113.49 26.99 25.06 73.77 119.29 119.29 61.28
Price - - - - - - 68.10 58.75 105.35 427.80 730.25 1,125.66 384.49

RATIOS:
Dividend Payout 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 11.89% 20.69%
OPM 0.00% 0.00% 0.00% 7.36% 6.35% 7.91% 7.28% 7.88% 8.28% 7.38% 6.93%

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

Sales Growth 13.68% 29.34% 31.82% 31.82% 13.68%
OPM 7.53% 7.53% 7.74% 7.79% 6.93% 7.79% 6.93%
Price to Earning 61.28 61.28 61.28 61.28 119.29 119.29 61.28
KALYAN JEWELLERS INDIA LTD SCREENER.IN

Narration Mar-22 Jun-22 Sep-22 Dec-22 Mar-23 Jun-23 Sep-23 Dec-23 Mar-24 Jun-24
Sales 2,857.07 3,332.64 3,472.91 3,884.10 3,381.80 4,375.74 4,414.54 5,223.08 4,534.93 5,535.48
Expenses 2,638.63 3,068.44 3,206.80 3,557.10 3,125.08 4,052.80 4,100.88 4,853.27 4,228.69 5,159.45
Operating Profit 218.44 264.20 266.11 327.00 256.72 322.94 313.66 369.81 306.24 376.03
Other Income 11.45 7.88 8.50 6.89 -18.63 11.65 13.13 20.13 28.80 22.16
Depreciation 58.04 58.98 60.32 62.08 63.20 64.07 66.94 69.73 73.56 75.47
Interest 75.97 71.27 73.87 77.23 80.19 82.06 81.71 81.66 77.81 85.23
Profit before tax 95.88 141.83 140.42 194.58 94.70 188.46 178.14 238.55 183.67 237.49
Tax 23.84 34.06 34.50 46.14 24.90 44.91 43.27 58.18 46.18 59.93
Net profit 72.30 107.94 106.38 148.70 70.09 143.89 135.25 180.61 137.60 177.77

OPM 8% 8% 8% 8% 8% 7% 7% 7% 7% 7%
KALYAN JEWELLERS INDIA LTD SCREENER.IN

Narration Dec-99 Dec-99 Dec-99 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24
Equity Share Capital - - - 839.24 839.24 839.24 1,030.05 1,030.05 1,030.05 1,030.05
Reserves - - - 1,012.09 1,045.93 1,202.82 1,795.98 2,106.97 2,604.66 3,159.00
Borrowings - - - 4,196.45 3,907.05 3,759.36 4,081.17 4,029.32 4,295.49 4,486.36
Other Liabilities - - - 2,503.45 2,267.69 2,417.26 1,957.93 1,778.81 2,782.75 4,142.33
Total - - - 8,551.23 8,059.91 8,218.68 8,865.13 8,945.15 10,712.95 12,817.74

Net Block - - - 1,878.59 2,151.97 2,167.17 1,898.68 1,921.43 1,902.89 2,299.06

Capital Work in Progress - - - 17.99 21.73 24.45 53.06 2.13 20.49 48.84
Investments - - - 1.06 2.56 - - 0.60 4.35 4.40
Other Assets - - - 6,653.59 5,883.65 6,027.06 6,913.39 7,020.99 8,785.22 10,465.44
Total - - - 8,551.23 8,059.91 8,218.68 8,865.13 8,945.15 10,712.95 12,817.74

Working Capital - - - 4,150.14 3,615.96 3,609.80 4,955.46 5,242.18 6,002.47 6,323.11

Debtors - - - 181.82 146.69 213.65 112.66 119.47 244.23 328.32
Inventory - - - 5,022.07 4,500.70 4,720.34 5,303.09 5,794.26 7,013.88 8,297.57

Debtor Days - - - 6.32 5.48 7.72 4.80 4.03 6.34 6.46

Inventory Turnover - - - 2.09 2.17 2.14 1.62 1.87 2.01 2.24

Return on Equity 8% 0% 7% 0% 7% 12% 14%

Return on Capital Emp 20% 7% 11% 7% 9% 12% 14%
KALYAN JEWELLERS INDIA LTD SCREENER.IN

Narration Dec-99 Dec-99 Dec-99 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24
Cash from Operating Activity - - - - - 319.73 628.91 264.10 1,013.37 1,321.80
Cash from Investing Activity - - - - - 34.33 -217.28 63.57 -383.90 -136.98
Cash from Financing Activity - - - - - -343.29 -207.64 -543.51 -637.59 -1,148.01
Net Cash Flow - - - - - 10.76 203.99 -215.83 -8.12 36.80
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 KALYAN JEWELLERS INDIA LTD
LATEST VERSION 2.10 PLEAS
CURRENT VERSION 2.10

META
Number of shares 103.12
Face Value 10.00
Current Price 730.25
Market Capitalization 75,300.41

PROFIT & LOSS

Report Date Mar-18
Sales 10,505.13
Raw Material Cost 9,545.15
Change in Inventory 743.46
Power and Fuel 35.77
Other Mfr. Exp 38.92
Employee Cost 369.17
Selling and admin 477.40
Other Expenses 8.62
Other Income 32.25
Depreciation 202.03
Interest 389.99
Profit before tax 213.79
Tax 72.80
Net profit 142.37
Dividend Amount

Quarters
Report Date Mar-22 Jun-22 Sep-22 Dec-22
Sales 2,857.07 3,332.64 3,472.91 3,884.10
Expenses 2,638.63 3,068.44 3,206.80 3,557.10
Other Income 11.45 7.88 8.50 6.89
Depreciation 58.04 58.98 60.32 62.08
Interest 75.97 71.27 73.87 77.23
Profit before tax 95.88 141.83 140.42 194.58
Tax 23.84 34.06 34.50 46.14
Net profit 72.30 107.94 106.38 148.70
Operating Profit 218.44 264.20 266.11 327.00

BALANCE SHEET
Report Date Mar-18
Equity Share Capital 839.24
Reserves 1,012.09
Borrowings 4,196.45
Other Liabilities 2,503.45
Total 8,551.23
Net Block 1,878.59
Capital Work in Progress 17.99
Investments 1.06
Other Assets 6,653.59
Total 8,551.23
Receivables 181.82
Inventory 5,022.07
Cash & Bank 1,017.91
No. of Equity Shares ###
New Bonus Shares
Face value 10.00

CASH FLOW:
Report Date Mar-18
Cash from Operating Activity
Cash from Investing Activity
Cash from Financing Activity
Net Cash Flow

PRICE:

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

Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24

9,770.76 10,100.92 8,573.31 10,817.93 14,071.45 18,548.29
7,518.40 8,469.29 7,482.50 9,709.12 13,104.19 17,070.19
-679.94 77.52 368.38 582.83 1,231.96 1,235.60
40.35 38.65 29.81 35.69 46.69 53.98
47.00 52.38 38.32 47.46 63.42 72.27
382.28 358.56 332.13 354.86 441.45 607.18
453.82 413.35 252.60 344.68 441.69 580.05
28.76 46.80 181.96 56.44 41.02 32.21
42.21 80.10 45.37 38.29 4.64 73.71
223.62 239.17 224.90 231.58 244.58 274.30
417.87 419.46 405.48 360.37 353.48 378.59
20.93 220.88 39.36 298.85 571.53 788.83
25.79 78.61 45.43 74.82 139.59 192.54
-3.61 143.00 -6.30 224.21 433.11 597.35
51.50 123.61

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

3,381.80 4,375.74 4,414.54 5,223.08 4,534.93 5,535.48
3,125.08 4,052.80 4,100.88 4,853.27 4,228.69 5,159.45
-18.63 11.65 13.13 20.13 28.80 22.16
63.20 64.07 66.94 69.73 73.56 75.47
80.19 82.06 81.71 81.66 77.81 85.23
94.70 188.46 178.14 238.55 183.67 237.49
24.90 44.91 43.27 58.18 46.18 59.93
 70.09 143.89 135.25 180.61 137.60 177.77
256.72 322.94 313.66 369.81 306.24 376.03

Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24

839.24 839.24 1,030.05 1,030.05 1,030.05 1,030.05
1,045.93 1,202.82 1,795.98 2,106.97 2,604.66 3,159.00
3,907.05 3,759.36 4,081.17 4,029.32 4,295.49 4,486.36
2,267.69 2,417.26 1,957.93 1,778.81 2,782.75 4,142.33
8,059.91 8,218.68 8,865.13 8,945.15 10,712.95 12,817.74
2,151.97 2,167.17 1,898.68 1,921.43 1,902.89 2,299.06
21.73 24.45 53.06 2.13 20.49 48.84
2.56 0.60 4.35 4.40
5,883.65 6,027.06 6,913.39 7,020.99 8,785.22 10,465.44
8,059.91 8,218.68 8,865.13 8,945.15 10,712.95 12,817.74
146.69 213.65 112.66 119.47 244.23 328.32
4,500.70 4,720.34 5,303.09 5,794.26 7,013.88 8,297.57
825.45 750.14 1,096.62 777.20 981.88 975.10
### ### ### ### ### ###

10.00 10.00 10.00 10.00 10.00 10.00

Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24

319.73 628.91 264.10 1,013.37 1,321.80
34.33 -217.28 63.57 -383.90 -136.98
-343.29 -207.64 -543.51 -637.59 -1,148.01
10.76 203.99 -215.83 -8.12 36.80

68.10 58.75 105.35 427.80

83.92 83.92 103.01 103.01 103.01 103.01