COMPANY NAME KALYAN JEWELLERS INDIA LTD

LATEST VERSION 2.10 PLEAS

CURRENT VERSION 2.10

META
Number of shares 103.01
Face Value 10.00
Current Price 287.45
Market Capitalization 29,608.88

PROFIT & LOSS

Report Date
Sales
Raw Material Cost
Change in Inventory
Power and Fuel
Other Mfr. Exp
Employee Cost
Selling and admin
Other Expenses
Other Income
Depreciation
Interest
Profit before tax
Tax
Net profit
Dividend Amount

Quarters
Report Date Mar-21 Jun-21 Sep-21 Dec-21
Sales 3,056.60 1,636.78 2,888.70 3,435.40
Expenses 2,828.91 1,568.06 2,660.58 3,136.18
Other Income 12.28 4.73 4.95 17.16
Depreciation 54.86 57.57 57.16 58.81
Interest 86.64 80.81 83.70 81.88
Profit before tax 98.47 -64.93 92.21 175.69
Tax 24.60 -13.62 23.44 41.17
Net profit 74.19 -51.33 68.73 134.52
Operating Profit 227.69 68.72 228.12 299.22
BALANCE SHEET
Report Date
Equity Share Capital
Reserves
Borrowings
Other Liabilities
Total
Net Block
Capital Work in Progress
Investments
Other Assets
Total
Receivables
Inventory
Cash & Bank
No. of Equity Shares
New Bonus Shares
Face value

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

PRICE:

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

Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23

10,505.13 9,770.76 10,100.92 8,573.31 10,817.93 14,071.45
9,545.15 7,518.40 8,469.29 7,482.50 9,709.12 13,104.19
743.46 -679.94 77.52 368.38 582.83 1,231.96
35.77 40.35 38.65 29.81 35.69 46.69
38.92 47.00 52.38 38.32 47.46 63.42
369.17 382.28 358.56 332.13 354.86 441.45
477.40 453.82 413.35 252.60 344.68 441.69
8.62 28.76 46.80 181.96 56.44 41.02
32.25 42.21 80.10 45.37 38.29 4.64
202.03 223.62 239.17 224.90 231.58 244.58
389.99 417.87 419.46 405.48 360.37 353.48
213.79 20.93 220.88 39.36 298.85 571.53
72.80 25.79 78.61 45.43 74.82 139.59
142.37 -3.61 143.00 -6.30 224.21 433.11
51.50

Mar-22 Jun-22 Sep-22 Dec-22 Mar-23 Jun-23

2,857.07 3,332.64 3,472.91 3,884.10 3,381.80 4,375.74
2,638.63 3,068.44 3,206.80 3,557.10 3,125.08 4,052.80
11.45 7.88 8.50 6.89 -18.63 11.65
58.04 58.98 60.32 62.08 63.20 64.07
75.97 71.27 73.87 77.23 80.19 82.06
95.88 141.83 140.42 194.58 94.70 188.46
23.84 34.06 34.50 46.14 24.90 44.91
72.30 107.94 106.38 148.70 70.09 143.89
218.44 264.20 266.11 327.00 256.72 322.94
Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23
839.24 839.24 839.24 1,030.05 1,030.05 1,030.05
1,012.09 1,045.93 1,202.82 1,795.98 2,106.97 2,604.66
4,077.40 3,788.00 3,640.31 4,081.17 4,029.32 4,295.49
2,622.50 2,386.74 2,536.31 1,957.93 1,778.81 2,782.75
8,551.23 8,059.91 8,218.68 8,865.13 8,945.15 10,712.95
1,878.59 2,151.97 2,167.17 1,898.68 1,921.43 1,902.89
17.99 21.73 24.45 53.06 2.13 20.49
1.06 2.56 0.60 4.35
6,653.59 5,883.65 6,027.06 6,913.39 7,020.99 8,785.22
8,551.23 8,059.91 8,218.68 8,865.13 8,945.15 10,712.95
181.82 146.69 213.65 112.66 119.47 244.23
5,022.07 4,500.70 4,720.34 5,303.09 5,794.26 7,013.88
1,017.91 825.45 750.14 1,096.62 777.20 981.88
### ### ### ### ### ###

10.00 10.00 10.00 10.00 10.00 10.00

Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23

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

68.10 58.75 105.35

83.92 83.92 83.92 103.01 103.01 103.01

HISTORICAL FINANCIAAL STATEMENTS - KALYAN JWELLERS INDIA LTD.
Years Mar-19 Mar-20 Mar-21 Mar-22

INCOME STATEMENT
Sales 9770.76 10100.92 8573.31 10817.93
COGS 8285.69 8482.8 7182.25 9209.44
Gross Profit 1485.07 1618.12 1391.06 1608.49
Selling And General Expenses 864.86 818.71 766.69 755.98
Other Income 42.21 80.1 45.37 38.29
EBITDA 662.42 879.51 669.74 890.8
Depreciation 223.62 239.17 224.9 231.58
EBIT 438.8 640.34 444.84 659.22
Interest 417.87 419.46 405.48 360.37
EBT 20.93 220.88 39.36 298.85
Tax 25.79 78.61 45.43 74.82
EAT -4.86 142.27 -6.07 224.03
Net Margins -0.05% 1.41% -0.07% 2.07%

BALANCE SHEET
Report Date Mar-19 Mar-20 Mar-21 Mar-22
Equity Share Capital 839.24 839.24 1030.05 1030.05
Reserves 1045.93 1202.82 1795.98 2106.97
Borrowings 3788 3640.31 4081.17 4029.32
Other Liabilities 2386.74 2536.31 1957.93 1778.81
Total Liabilities 8059.91 8218.68 8865.13 8945.15
Net Block 2151.97 2167.17 1898.68 1921.43
Capital Work in Progress 21.73 24.45 53.06 2.13
Investments 2.56 0.6
Other Assets 5883.65 6027.06 6913.39 7020.99
Total Assets 8059.91 8218.68 8865.13 8945.15
Receivables 146.69 213.65 112.66 119.47
Inventory 4500.7 4720.34 5303.09 5794.26
Cash & Bank 825.45 750.14 1096.62 777.2
Total Current Asset 5472.84 5684.13 6512.37 6690.93

Checker true true true true

RATIO ANALYSIS OF MARCH'23

LIQUIDITY RATIOS
CURRENT RATIO CA CL
CA/CL 8239.99 3501
2.35
2.35:1
QUICK RATIO QA CL
QA/CL 1226.11 3501
0.35
0.35:1

SOLVENCY RATIOS
DEBT EQUITY RATIO LTD SHF
LTD/SHF 8 3634.71
0.002201
0.002:1

TOTAL ASSET TO DEBT TA LTD

TA/LTD 10712.95 8
1339.12
1339.12:1

PROPRIETARY RATIO PF TA
PF/TA*100 1030.05 10712.95
9.61%

INTEREST COVERAGE RATIO EBIT INTEREST

EBIT/INTEREST 925.01 353.48
2.62
2.62 TIMES

ACTIVITY RATIOS
CAPITAL TURNOVER RATIO NS CE
NET SALES/CAPITAL EMPLOYED 14071.45 7211.95
1.95
1.95:1

FIXED ASSET TURNOVER RATIO NS FA

NET SALES/NET FIXED ASSETS 14071.45 1903
7.39
7.39:1

WORKING CAPITAL TURNOVER RATIO NS WC

NET SALES/ WORKING CAPITAL 14071.45 4738.99
2.97
2.97:1

STOCK TURNOVER RATIO COGS AVERAGE INVENTORY

COGS/AVG INVENTORY 11982.34 6404.07
1.87
1.87:1

PROFITABILITY RATIOS
IN RELATION TO SALES
GROSS PROFIT RATIO GP SALES
GP/SALES*100 2089.11 14071.45
14.85%

OPERATING PROFIT RATIO OP SALES

OPERATING PROFIT/SALES*100 1164.95 14071.45
8.28%

NET PROFIT RATIO NP SALES

NET PROFIT/SALES*100 431.94 14071.45
3.07%

IN RELATION TO INVESTMENTS
RETURN ON TOTAL ASSET RATIO EBIT TA
EBIT/TOTAL ASSETS*100 925.01 10712.95
8.63%

RETURN ON CAPITAL EMPLOYED EBIT CE

EBIT/CAPITAL EMPLOYED*100 925.01 7211.95
12.83%

RETURN ON SHAREHOLDER FUND EAT SHF

EAT/SHAREHOLDER FUND*100 431.94 3634.71
11.88%

RETURN ON EQUITY SHAREHOLDER FUND EAT ESF

EAT/EQUITY SHAREHOLDER FUND*100 431.94 3634.71
11.88%
 Mar-23

14071.45
11982.34
2089.11
924.16
4.64
1169.59
244.58
925.01
353.48
571.53
139.59
431.94
3.07%

Mar-23
1030.05
2604.66
4295.49
2782.75
10712.95
1902.89
20.49
4.35
8785.22
10712.95
244.23
7013.88
981.88
8239.99

true