KEI Industries Final - 2
KEI Industries Final - 2
KEI Industries Final - 2
2020-2021 2019-2020
41814.88 48842.66
200.6 164.69
42015.48 49007.35
27907.95 35031.60
107.71 117.10
1131.2 -1362.44
1493.62 1606.16
1849.43 2275.90
578.14 566.89
4625.39 6076.89
37693.44 44312.10
4322.04 4695.25
573.08 1291.51
144.89 137.07
3604.07 3266.67
908.57 715.64
2695.50 2551.03
0 0.00
0 0.00
2695.50 2551.03
89,725,616 80,969,900
90,577,438 82,163,482
30.04 31.51
29.76 31.05
-5%
25% 22%
Balance Sheet (KEI Industries)
FY ends-March 31, (INR Million) 2023-2024 2022-2023
Assets
Inventories (Net) 13427.46 11022.91
Raw Materials 3814.76 2247.51
Work In Progress 3214.24 2735.5
Finished Goods 5874.3 5510.22
Traded goods 19.13 14.71
Project Materials 505.03 514.97
Financial Assets (Net) 22468.77 19425.15
Trade Receivables 15178.73 13877.86
Cash and Cash Equivalents 6660.77 4798.89
Bank Balance 342.94 572.75
Loans 21.25 20.84
Other Financial Assets 265.08 154.81
(Operating
profit (EBIT)
+Depreciation
and
Amortization)/
EBITDA Margin Revenue 10.5% 10.4% 10.5% 11.2%
Operating
Profit
Operating Margin (EBIT)/Revenue 9.8% 9.5% 9.5% 9.9%
Net profit after
Net Margin taxes/Revenue 7.1% 6.9% 6.6% 6.4%
Liquidity ratios
(TCA-
Quick Ratio Inventories)/CL 1.65 1.84 1.41 1.47
Current Ratio Current assets/Cu 2.58 2.83 2.22 2.14
(current assets-
current
Net working capital to Total assets liabilities)/Total
Ratio assets 0.49 0.54 0.46 0.43
Working capital cycle
(accounts
receivable/Rev
Accounts Receivable Days enue)*365 68 73 89 118
(Inventory/Cost
of revenue or
cost of
Inventory Days sales)*365 67 64 76 74
(Inventory/Cost
of goods
Inventory Days sold)*365 79 76 91 91
(Accounts
Payable/Cost of
Accounts Payable Days Sales)*365 50 44 54 72
(Accounts
Payable/Cost of
Goods
Accounts Payable Days sold)*365 59 52 64 88
(Accounts
Receivable
days+Inventory
Cash Conversion Cycle/Working Days)-Accounts
capital cycle (Days) Payable days 85 94 111 120
(Accounts
Receivable
days+Inventory
Cash Conversion Cycle/Working Days)-Accounts
capital cycle (Days) Payable days 88 98 116 120
Leverage Ratios
Total
Assets/Equity Assets/Equity 1.48 1.46 1.65 1.70
Debt/Equity
Total Debt
(Long term
debt+short
term
debt+current
portion of long
term
debt)/Equity 0.05 0.06 0.17 0.17
Long term
Debt/(Total
Long-term Debt to Total Capital Debt+Equity) 0.01 0.01 0.01 0.03
(Total Debt -
Cash and cash
equivalent) /
Net debt/ EBITDA EBITDA (0.59) (0.44) (0.01) 0.18
EBIT/cash
Times interest earned/Interest interest
coverage Ratio payments 18 19 13 7
EBIT/Interest
Times interest earned/Interest expense (P&L
coverage Ratio A/c) 18 19 13 7
EBIT/(Int
exp+ST debt
repayable in 12
Debt Service Coverage Ratio months) 4 4 1 1
Efficiency Ratios
Sales/Fixed
assets
(Property plant
and
Fixed Asset Turnover equipment) 15.0 14.3 12.1 8.8
Sales/Total
Total Assets Turnover assets 1.7 1.8 1.6 1.4
Sales/accounts
Accounts Receivable Turnover receivable 5.34 4.98 4.10 3.10
Sales/
Inventory Turnover Inventory 6.04 6.27 5.31 5.48
Cost of
Inventory Turnover sales/Inventory 5.45 5.67 4.80 4.94
Valuation Ratios
Price/Earnings
P/E (eps) 61.91 54.35 36.73 36.59
P/B Price/Book val 11.43 10.02 6.47 5.56
EV/EBITDA (Market cap+Ne 41.55 35.77 23.04 21.17
EV/Sales (Market cap+Ne 4.4 3.7 2.4 2.4
P/CF Price/(OCF/sha 58.9 50.5 60.4 64.1
PEG P/E divided by 2.86 1.96 0.97 -7.87
ROE PAT/Shareholde 18% 18% 18% 15%
ROCE EBIT/(Sharehol 24% 24% 22% 20%
ROIC EBIT*(1-tax rat 15% 15% 16% 15%
ROA net profit after 12% 13% 11% 9%
Growth ratios
Revenue growth (y-o-y) 17.3% 20.6% 37.0% -14.4%
EBIT growth 20% 21% 32% -9%
PAT Growth 22% 27% 40% 6%
2019-2020
27.5%
10.4%
9.3%
5.2%
1.10
1.63
0.32
102
71
89
96
121
77
71
2.17
0.25
0.04
0.52
9.8
1.5
3.57
5.65
5.13
13.36
2.26
7.21
0.7
-260.3
17%
24%
20%
8%
420.99
DuPont Ratio Analysis
2020-2021 2019-2020
6% 5%
140% 150%
170% 217%
15% 17%
2023-2024
Revenue
Operating Revenue 17.3%
Other Income 54%
Total 17.5%
Cost of Revenue
Cost of materials consumed 19%
Purchases of Stock-in-Trade 182%
27% 40% 6%
Commonsize Income Statement
Fiscal Year Ended March 31 (Data in INR
million except per share data) 2023-2024 2022-2023 2021-2022
Revenue
Operating Revenue
Other Income
Total Revenue 100.00 100.00 100.00
Cost of Revenue
Cost of materials consumed
Purchases of Stock-in-Trade
Changes in inventories of finished goods,
Stock-in-Trade, work-in- progress and
intermediates
Excise duty
Employee benefits expense
Depreciation and amortization expense
Other expenses-Operating
100.00 100.00
Common Size Balance Sheet
2023-2024 2022-2023 2021-2022 2020-2021
FY ends-March 31, (INR Millions)
Assets
Cash and Short Term Investments
Goodwill, Net
Intangibles, Net
Intangibles - Gross
Accumulated Intangible Amortization
Intangibles capital work in progress
Long Term Investments (Financial Assets)
LT Investment - Affiliate Companies (Subsidiaries, Associates, JVs..)
LT Investments - Other
Note Receivable - Long Term
Other Long Term Assets, Total
Deferred Charges
Defered Income Tax - Long Term Asset
Restricted Cash - Long Term
Other Long Term Assets
Total Assets
Liabilities and Equities
Liabilities
Accounts Payable
Accrued Expenses
Notes Payable
Current Port. of LT Debt/Capital Leases
Short term debt
Other Current liabilities
Dividends Payable
Customer Advances
Income Taxes Payable
Provisions and other Payables
Discontinued Operations - Curr Liability
Other Current Liabilities
Total Current Liabilities
Total Long Term Debt
Long Term Debt
Capital Lease Obligations
Deferred Income Tax
Minority Interest
Provisions and other Payables
Other long-term liabilities
Total Liabilities
Shareholders Equity
Common Stock, Total
Additional Paid-In Capital
Retained Earnings (Accumulated Deficit)
General Reserve
Securities Premium
Other reserves
Unrealized Gain (Loss)
Other Equity, Total
Translation Adjustment
Other Equity
Minimum Pension Liability Adjustment
Other Comprehensive Income
Total Equity
Total Liabilities & Shareholders' Equity
2019-2020
Disaggregation of Revenue
Product Type
Year Cables and Wires Stainless Steel Wires EPC Projects
23/24 69508.1 2206.37 11997.95
22/23 60762.11 2533.75 7262.27
21/22 48200.69 2241.61 8749.81
20/21 31468.36 1407.71 9674.12
19/20 34022.67 1365.64 13922.24
arkets (India)
Inter-Segment EleminatioTotal Revenue
-2088.35 70034.68
-1088.83 61953.64
-1208.66 51378.22
-605.1 35706.01
-93.75 40226.21
s (Outside India)
Inter-Segment EleminatioTotal Revenue
-583.27 11006.12
-387.56 7128.1
-754.85 5850.38
-156.32 6082.76
-369.13 8621.46