Fundamental Analysis of Lexus Granito (India) Ltd

About the Company - Lexus Granito (India) Ltd

Lexus Granito (India) Ltd. is a Public Limited Listed company incorporated on 05/05/2008 and has its registered office in the State of Gujarat, India. Company’s Corporate Identification Number(CIN) is L26914GJ2008PLC053838 and registration number is 053838. Currently Company is involved in the business activities of Manufacture of refractory products. Company’s Total Operating Revenue is Rs. 139.18 Cr. and Equity Capital is Rs. 19.19 Cr. for the Year ended 31/03/2022.

INDUSTRY	ADDRESS	CONTACT
Ceramics/Tiles/Sanitaryware	Survey No. 800, Opp. Lakhdhirpur Village, Rajkot Gujarat 363642	cs@lexustile.com www.lexusgranito.com

Management
Name	Position Held
Mr. Anilkumar Babulal Detroja	Chairman & Managing Director
Mr. Hitesh Babulal Detroja	Whole Time Director
Mrs. Dimpalben Anilbhai Detroja	Whole Time Director
Mr. Jitendrabhai Chandulal Lakhtariya	Independent Director
Mr. Rakesh Jayantilal Amrutiya	Independent Director
Mr. Sagarbhai Rasikbhai Jasani	Independent Director

Basic Stock Data of Lexus Granito (India) Ltd

Last Updated: July 26, 2024, 10:25 pm

Market Cap	92.0 Cr.
Current Price	45.6
High / Low	56.7/31.6
Stock P/E
Book Value	4.62
Dividend Yield	0.00 %
ROCE	13.5 %
ROE	109 %
Face Value	10.0
PEG Ratio	0.00

Data Source: screener.in

Lexus Granito (India) Ltd Quarterly Results

Month	Jun 2022	Sep 2022	Dec 2022	Mar 2023	Jun 2023	Sep 2023	Dec 2023
Sales	20.37	16.76	26.87	37.68	31.57	31.85	26.55
Expenses	19.49	12.01	26.23	35.97	31.47	29.09	26.65
Operating Profit	0.88	4.75	0.64	1.71	0.10	2.76	-0.10
OPM %	4.32%	28.34%	2.38%	4.54%	0.32%	8.67%	-0.38%
Other Income	0.08	0.48	0.08	0.46	0.10	0.38	0.23
Interest	0.73	1.04	1.36	1.10	0.97	1.46	1.12
Depreciation	2.37	2.26	4.32	4.38	2.55	2.60	2.55
Profit before tax	-2.14	1.93	-4.96	-3.31	-3.32	-0.92	-3.54
Tax %	-2.80%	88.60%	-1.41%	-2.11%	-4.52%	-16.30%	-9.89%
Net Profit	-2.20	0.22	-5.03	-3.38	-3.47	-1.07	-3.89
EPS in Rs	-1.15	0.11	-2.62	-1.76	-1.81	-0.56	-1.93

Last Updated: July 11, 2024, 7:19 am

Lexus Granito (India) Ltd Quarterly Chart

Lexus Granito (India) Ltd Profit & Loss

Last Updated: July 10, 2024, 7:14 pm

Month	Mar 2012	Mar 2013	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	Mar 2022	Mar 2023	TTM
Sales	35	63	59	80	101	165	181	134	100	101	138	101	128
Expenses	32	54	50	68	88	146	150	118	86	135	124	96	123
Operating Profit	2	10	9	13	14	19	31	16	14	-34	14	5	4
OPM %	7%	15%	15%	16%	13%	12%	17%	12%	14%	-33%	10%	5%	4%
Other Income	0	0	1	1	1	4	3	6	3	0	11	1	1
Interest	2	4	4	4	4	5	9	8	8	6	6	4	5
Depreciation	3	5	5	6	6	10	14	13	11	9	8	13	12
Profit before tax	-2	0	1	3	5	8	11	1	-1	-49	11	-12	-11
Tax %	-31%	-881%	41%	33%	34%	18%	36%	36%	-68%	1%	-8%	-2%
Net Profit	-3	2	0	2	3	7	7	0	-2	-49	12	-12	-12
EPS in Rs	-4.29	2.24	0.46	2.91	3.21	4.89	3.65	0.17	-0.97	-25.36	6.03	-6.16	-6.06
Dividend Payout %	-0%	-0%	-0%	-0%	-0%	-0%	-0%	-0%	-0%	-0%	-0%	-0%

Lexus Granito (India) Ltd Profit & Loss Yearly Chart

Lexus Granito (India) Ltd Growth

Compounded Sales Growth
10 Years:	7%
5 Years:	-3%
3 Years:	5%
TTM:	17%

Compounded Profit Growth
10 Years:	%
5 Years:	%
3 Years:	19%
TTM:	-37%

Stock Price CAGR
10 Years:	%
5 Years:	20%
3 Years:	57%
1 Year:	9%

Return on Equity
10 Years:	-15%
5 Years:	-41%
3 Years:	-32%
Last Year:	-109%

Last Updated: July 24, 2024, 5:31 pm

Lexus Granito (India) Ltd Balance Sheet

Last Updated: July 10, 2024, 7:14 pm

Month	Mar 2012	Mar 2013	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	Mar 2022	Mar 2023	Sep 2023
Equity Capital	7	7	7	7	10	13	19	19	19	19	19	19	19
Reserves	4	6	6	8	11	24	49	49	48	-1	13	1	-3
Borrowings	28	35	31	31	55	81	68	64	64	67	59	69	68
Other Liabilities	32	22	16	13	22	49	71	55	54	59	61	66	65
Total Liabilities	72	70	60	59	98	168	208	187	185	144	152	156	149
Fixed Assets	40	34	32	27	52	45	71	60	50	45	33	57	53
CWIP	0	1	0	0	0	32	0	0	0	0	24	0	0
Investments	0	0	0	0	0	2	2	2	2	2	0	0	0
Other Assets	32	34	29	32	46	88	134	125	132	96	95	98	95
Total Assets	72	70	60	59	98	168	208	187	185	144	152	156	149

Lexus Granito (India) Ltd Reserves and Borrowings Chart

Lexus Granito (India) Ltd Cash Flow

Month	Mar 2013	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	Mar 2022	Mar 2023	Mar 2024
Cash from Operating Activity	3	9	6	12	10	10	9	11	4	36	6	11
Cash from Investing Activity	-1	-1	-1	-33	-36	-6	-2	4	-3	-14	-14	1
Cash from Financing Activity	-2	-8	-5	22	26	-4	-7	-15	1	-21	8	-12
Net Cash Flow	-0	-0	-0	0	-0	0	-1	0	2	0	0	-0

Lexus Granito (India) Ltd Financial Efficiency Indicators

Month	Mar 2013	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	Mar 2022	Mar 2023	Mar 2024
Debtor Days	63	109	82	65	71	121	105	155	118	55	52	38
Inventory Days	138	53	52	73	164	392	1,323	1,706	334	914	1,224	470
Days Payable	139	107	64	76	197	380	778	880	246	672	599	243
Cash Conversion Cycle	62	55	69	62	38	133	650	981	206	297	677	265
Working Capital Days	55	57	61	64	44	82	144	219	133	79	160	104
ROCE %	10%	10%	16%	14%	14%	15%	7%	5%	-40%	13%	-8%

Lexus Granito (India) Ltd Financial Efficiency Indicators Chart

Lexus Granito (India) Ltd Share Holding Pattern

Month	Mar 2020	Sep 2020	Mar 2021	Sep 2021	Mar 2022	Sep 2022	Mar 2023	Jun 2023	Sep 2023	Dec 2023	Mar 2024	Jun 2024
Promoters	69.99%	51.75%	52.80%	52.80%	52.80%	52.79%	52.79%	52.79%	52.79%	55.13%	55.13%	55.13%
Public	30.01%	48.25%	47.21%	47.21%	47.21%	47.21%	47.21%	47.21%	47.21%	44.87%	44.87%	44.87%
No. of Shareholders	527	526	469	481	465	521	762	1,137	1,588	2,764	3,154	4,286

Lexus Granito (India) Ltd Shareholding Pattern Chart

No. of Lexus Granito (India) Ltd Shareholders

This stock is not held by any mutual fund

Lexus Granito (India) Ltd ROCE Trend

Lexus Granito (India) Ltd EPS Trend

Lexus Granito (India) Ltd Key Financial Ratios

Month	Mar 24	Mar 23	Mar 22	Mar 21	Mar 20
FaceValue	10.00	10.00	10.00	10.00	10.00
Basic EPS (Rs.)	-8.44	-6.16	6.98	-25.36	-0.97
Diluted EPS (Rs.)	-8.44	-6.16	6.98	-25.36	-0.97
Cash EPS (Rs.)	-1.92	0.84	11.24	-20.54	4.70
Book Value[Excl.RevalReserv]/Share (Rs.)	4.62	10.61	16.41	9.44	34.79
Book Value[Incl.RevalReserv]/Share (Rs.)	4.62	10.61	16.41	9.44	34.79
Revenue From Operations / Share (Rs.)	58.43	52.62	72.52	52.96	52.45
PBDIT / Share (Rs.)	1.04	3.23	13.35	-17.61	9.08
PBIT / Share (Rs.)	-5.25	-3.77	9.08	-22.43	3.41
PBT / Share (Rs.)	-7.89	-6.03	6.02	-25.64	-0.57
Net Profit / Share (Rs.)	-8.21	-6.16	6.97	-25.36	-0.97
PBDIT Margin (%)	1.78	6.14	18.41	-33.26	17.31
PBIT Margin (%)	-8.98	-7.16	12.52	-42.35	6.50
PBT Margin (%)	-13.49	-11.45	8.29	-48.42	-1.10
Net Profit Margin (%)	-14.05	-11.71	9.61	-47.88	-1.85
Return on Networth / Equity (%)	-177.91	-58.10	42.50	-268.73	-2.79
Return on Capital Employeed (%)	-18.13	-8.65	29.96	-78.82	6.80
Return On Assets (%)	-13.73	-7.58	8.90	-33.77	-1.01
Long Term Debt / Equity (X)	3.32	1.93	0.80	1.78	0.37
Total Debt / Equity (X)	6.22	3.37	1.85	3.01	0.70
Asset Turnover Ratio (%)	0.85	0.65	0.94	0.61	0.54
Current Ratio (X)	1.11	1.21	0.99	1.03	1.43
Quick Ratio (X)	0.23	0.21	0.31	0.38	0.49
Inventory Turnover Ratio (X)	0.81	0.20	0.42	0.33	0.36
Interest Coverage Ratio (X)	0.42	1.43	4.35	-5.49	2.28
Interest Coverage Ratio (Post Tax) (X)	-2.27	-1.73	3.27	-6.90	0.75
Enterprise Value (Cr.)	123.57	190.50	120.18	79.14	58.05
EV / Net Operating Revenue (X)	1.05	1.89	0.86	0.77	0.57
EV / EBITDA (X)	58.63	30.68	4.69	-2.34	3.33
MarketCap / Net Operating Revenue (X)	0.55	1.21	0.45	0.24	0.10
Price / BV (X)	7.05	6.00	2.00	1.37	0.16
Price / Net Operating Revenue (X)	0.55	1.21	0.45	0.24	0.10
EarningsYield	-0.25	-0.09	0.21	-1.97	-0.16

Lexus Granito (India) Ltd Profitability Ratios (%)

Lexus Granito (India) Ltd Liquidity Ratios

Lexus Granito (India) Ltd Liquidity Ratios (%)

Lexus Granito (India) Ltd Interest Coverage Ratios (%)

Lexus Granito (India) Ltd Valuation Ratios

Fair Value

Fair Value: 77.05

Calculation basis:

Fair value = P/E Ratio * (Return on Equity / 100) * Book Value * (1 + Dividend Yield / 100)
P/E Ratio (Price-to-Earnings Ratio): Represents the price of the stock relative to its earnings per share. A higher P/E ratio indicates that investors are willing to pay a higher price for the stock.
Return on Equity (ROE): Measures a company's profitability relative to its shareholder equity. It showcases the company's ability to generate profits using the investment made by its shareholders, offering valuable insight into its operational efficiency and financial performance
Book Value: Represents the net asset value of the company per share. It is calculated as the total assets minus intangible assets and liabilities, divided by the number of outstanding shares.
Dividend Yield: The ratio of the annual dividend per share to the current market price per share. It offers valuable insights into the profitability of an investment through dividends.

This formula allows us to gauge the fair value of the stock by analyzing its fundamental indicators.

Undervalued: 68.96% compared to the current price 45.6

Default values used*: Deafault value of 15 for Stock P/E is used

Intrinsic Value: 53.68

Calculation basis:

Fair value = P/E Ratio * (Return on Equity / 100) * Book Value * (1 + Dividend Yield / 100) * (1 + EPS CAGR for Last 5 Years)
P/E Ratio (Price-to-Earnings Ratio): Represents the price of the stock relative to its earnings per share. A higher P/E ratio indicates that investors are willing to pay a higher price for the stock.
Return on Equity (ROE): Measures a company's profitability relative to its shareholder equity. It showcases the company's ability to generate profits using the investment made by its shareholders, offering valuable insight into its operational efficiency and financial performance.
Book Value: Represents the net asset value of the company per share. It is calculated as the total assets minus intangible assets and liabilities, divided by the number of outstanding shares.
Dividend Yield: The ratio of the annual dividend per share to the current market price per share. It offers valuable insights into the profitability of an investment through dividends.
EPS CAGR (Compound Annual Growth Rate): Represents the geometric mean growth rate of earnings per share over the last 5 years. It provides insight into the historical growth trajectory of the company's earnings.

This formula allows us to gauge the fair value of the stock by analyzing its fundamental indicators along with EPS growth.

Undervalued: 17.73% compared to the current price 45.6

Default values used*: Deafault value of 15 for Stock P/E is used

Last 5 Year EPS CAGR: -30.33%

*Investments are subject to market risks

Strength and Weakness of Lexus Granito (India) Ltd Stock

Strength	Weakness
	The stock has a low average ROCE of 4.67%, which may not be favorable. The stock has a high average Working Capital Days of 100.17, which may not be favorable. The stock has a high average Cash Conversion Cycle of 291.25, which may not be favorable. The company has higher borrowings (56.83) compared to reserves (16.92), which may suggest financial risk. The company has not shown consistent growth in sales (106.62) and profit (-2.69).

Strength

Weakness

The stock has a low average ROCE of 4.67%, which may not be favorable.
The stock has a high average Working Capital Days of 100.17, which may not be favorable.
The stock has a high average Cash Conversion Cycle of 291.25, which may not be favorable.
The company has higher borrowings (56.83) compared to reserves (16.92), which may suggest financial risk.
The company has not shown consistent growth in sales (106.62) and profit (-2.69).

FAQ

What is the latest fair value of Lexus Granito (India) Ltd?

The latest fair value of Lexus Granito (India) Ltd is ₹77.05.

What is the Market Cap of Lexus Granito (India) Ltd?

The Market Cap of Lexus Granito (India) Ltd is 92.0 Cr..

What is the current Stock Price of Lexus Granito (India) Ltd as on 26 July 2024?

The current stock price of Lexus Granito (India) Ltd as on 26 July 2024 is 45.6.

What is the High / Low of Lexus Granito (India) Ltd stocks in FY 2024?

In FY 2024, the High / Low of Lexus Granito (India) Ltd stocks is 56.7/31.6.

What is the Stock P/E of Lexus Granito (India) Ltd?

The Stock P/E of Lexus Granito (India) Ltd is .

What is the Book Value of Lexus Granito (India) Ltd?

The Book Value of Lexus Granito (India) Ltd is 4.62.

What is the Dividend Yield of Lexus Granito (India) Ltd?

The Dividend Yield of Lexus Granito (India) Ltd is 0.00 %.

What is the ROCE of Lexus Granito (India) Ltd?

The ROCE of Lexus Granito (India) Ltd is 13.5 %.

What is the ROE of Lexus Granito (India) Ltd?

The ROE of Lexus Granito (India) Ltd is 109 %.

What is the Face Value of Lexus Granito (India) Ltd?

The Face Value of Lexus Granito (India) Ltd is 10.0.