Keystone Realtors

₹545.7 8.9 | 1.6%

WEBSITE BSE:543669 NSE : RUSTOMJEE 28 Nov, 16:01

Market Cap ₹6214 Cr.

Stock P/E 46.6

P/B 3.6

Current Price ₹545.7

Book Value ₹ 152.1

Face Value 10

52W High ₹659

Dividend Yield 0%

52W Low ₹ 416.5

Edit Ratio

Keystone Realtors Research see more...

Keystone Realtors Limited

Overview Inc. Year: 1995Industry: Construction - Real Estate

Keystone Realtors Ltd is a real estate company that operates in the United Kingdom. They specialize in providing a range of property-related services, including buying, selling, letting, and management of residential and commercial properties. Keystone Realtors Ltd is committed to delivering high-quality services to their clients, ensuring that their properties are marketed effectively and efficiently to achieve the best possible results. They have a team of experienced professionals who have a wealth of knowledge in the property industry and are dedicated to delivering exceptional customer service. Keystone Realtors Ltd has built a reputation for being trustworthy, reliable, and transparent in all their dealings with clients. Their focus on providing bespoke solutions to meet individual needs has earned them a loyal client base and established them as a leading player in the real estate industry.

Keystone Realtors Share Price

New

Volume

Price

Price: NSE50 DMA200 DMAVolume

Quarterly Price

Quarterly Monthly

Show Value Show %

Peer Comparison

Keystone Realtors Quarterly Results

#(Fig in Cr.)	Dec 2022	Mar 2023	Jun 2023	Sep 2023
Net Sales	127	344	272	618
Other Income	9	13	11	15
Total Income	136	358	283	633
Total Expenditure	118	247	209	632
Operating Profit	18	110	74	1
Interest	6	22	7	7
Depreciation	1	2	1	2
Exceptional Income / Expenses	0	0	0	0
Profit Before Tax	11	86	66	-8
Provision for Tax	4	21	20	-2
Profit After Tax	7	65	46	-5
Adjustments	-2	11	1	10
Profit After Adjustments	5	77	47	4
Adjusted Earnings Per Share	0.5	6.7	4.1	0.4

Keystone Realtors Profit & Loss

#(Fig in Cr.)	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	Mar 2022	Mar 2023	TTM
Net Sales	425	781	1018	674	1529	2117	1211	849	1269	686	1361
Other Income	17	110	38	121	247	26	57	329	34	45	48
Total Income	443	891	1056	795	1776	2143	1269	1177	1303	730	1410
Total Expenditure	432	678	701	599	1294	1609	854	607	1090	587	1206
Operating Profit	10	213	355	195	483	534	414	570	213	143	203
Interest	141	193	296	135	310	348	348	267	23	36	42
Depreciation	3	5	4	3	2	3	3	2	3	5	6
Exceptional Income / Expenses	0	0	0	10	6	0	0	0	0	0	0
Profit Before Tax	-133	15	55	67	177	183	63	301	184	108	155
Provision for Tax	0	12	8	33	55	45	49	58	49	28	43
Profit After Tax	-134	3	47	35	121	137	14	244	136	80	113
Adjustments	2	-21	-18	0	0	-36	8	67	4	2	20
Profit After Adjustments	-132	-18	29	35	121	102	22	310	140	82	133
Adjusted Earnings Per Share	0	-7051.4	11758.3	13983.9	48891.1	10.2	2.2	31	14	7.2	11.7

Growth Rates

#	1 Year	3 Year	5 Year	10 Year
Sales CAGR	-46%	-17%	-15%	0%
Operating Profit CAGR	-33%	-30%	-22%	0%
PAT CAGR	-41%	79%	-8%	0%

#	1 Year	3 Year	5 Year	10 Year
Share Price CAGR	-2%	NA%	NA%	NA%
ROE Average	6%	20%	21%	17%
ROCE Average	6%	13%	16%	18%

Keystone Realtors Balance Sheet

#(Fig in Cr.)	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	Mar 2022	Mar 2023
Shareholder's Funds	-412	-422	-380	348	353	404	427	801	933	1669
Minority's Interest	3	24	40	-3	-223	-224	-147	23	31	17
Borrowings	17	300	300	0	412	361	291	192	142	103
Other Non-Current Liabilities	29	5	5	-85	190	401	26	184	163	155
Total Current Liabilities	3402	3336	3603	2039	3185	3099	3731	2416	2570	2530
Total Liabilities	3039	3243	3568	2300	3916	4041	4328	3615	3838	4474
Fixed Assets	56	49	71	20	162	197	195	29	24	30
Other Non-Current Assets	128	91	105	150	57	104	197	674	674	750
Total Current Assets	2854	3104	3392	2130	3697	3741	3936	2912	3141	3694
Total Assets	3039	3243	3568	2300	3916	4041	4328	3615	3838	4474

Keystone Realtors Cash Flow

#(Fig in Cr.)	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	Mar 2022	Mar 2023
Opening Cash & Cash Equivalents	136	103	39	43	19	4	32	355	153	60
Cash Flow from Operating Activities	-843	-209	-127	160	202	429	355	645	-110	306
Cash Flow from Investing Activities	-111	12	-21	24	-119	-47	-204	-237	-138	27
Cash Flow from Financing Activities	921	134	177	-209	-68	-353	171	-609	154	-30
Net Cash Inflow / Outflow	-33	-64	29	-25	15	29	323	-202	-93	303
Closing Cash & Cash Equivalent	103	39	68	19	4	32	355	153	60	362

Keystone Realtors Ratios

#	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	Mar 2022	Mar 2023
Earnings Per Share (Rs)	-7051.43	11758.32	13983.87	48891.13	10.17	2.2	31.04	13.96	7.2
CEPS(Rs)	0	0	0	0	14.08	1.76	24.55	13.92	7.39
DPS(Rs)	0	0	0	0	0	0	0	0	0
Book NAV/Share(Rs)	-169726.54	-193308.08	99800.32	101885	40.38	42.72	80.07	93.24	146.05
Core EBITDA Margin(%)	13.17	31.14	11.06	15.42	24.02	29.5	28.45	14.16	14.35
EBIT Margin(%)	26.62	34.51	30.07	31.83	25.07	33.94	66.92	16.36	20.96
Pre Tax Margin(%)	1.94	5.45	10	11.55	8.63	5.2	35.49	14.53	15.71
PAT Margin (%)	0.44	4.66	5.15	7.93	6.49	1.18	28.69	10.7	11.59
Cash Profit Margin (%)	1.06	5.02	5.56	8.08	6.65	1.45	28.93	10.97	12.27
ROA(%)	0.11	1.39	1.18	3.9	3.45	0.34	6.13	3.64	1.91
ROE(%)	0	0	0	48.48	41.86	3.43	39.66	15.67	6.13
ROCE(%)	16.93	25.29	14.62	28.15	25.28	16.57	22.89	9.21	5.55
Receivable days	23.1	22.93	65.07	49.75	43.28	44.08	21.63	21.61	46.64
Inventory Days	1186.13	998.48	1246.2	532.29	486.05	851.39	1066.07	639.34	1284.16
Payable days	314.64	305.37	134.14	81.43	140.31	260.83	311.69	217.41	-1118.91
PER(x)	0	0	0	0	0	0	0	0	64.33
Price/Book(x)	0	0	0	0	0	0	0	0	3.17
Dividend Yield(%)	0	0	0	0	0	0	0	0	0
EV/Net Sales(x)	2.14	1.87	1.5	1.18	0.77	1.83	1.22	1.12	8.58
EV/Core EBITDA(x)	7.85	5.36	5.16	3.73	3.04	5.36	1.82	6.68	41.11
Net Sales Growth(%)	83.77	30.3	-33.82	127	38.42	-42.77	-29.94	49.56	-45.98
EBIT Growth(%)	2837.8	68.91	-42.33	140.32	9	-22.53	38.15	-63.43	-30.81
PAT Growth(%)	102.58	1273.07	-26.87	249.63	13.34	-89.64	1610.25	-44.23	-41.47
EPS Growth(%)	0	266.75	18.93	249.63	-99.98	-78.39	1312.8	-55.03	-48.44
Debt/Equity(x)	-4.06	-4.92	2.69	5.17	4.01	5.88	1.52	1.67	0.62
Current Ratio(x)	0.93	0.94	1.04	1.16	1.21	1.05	1.21	1.22	1.46
Quick Ratio(x)	0.13	0.14	0.21	0.3	0.28	0.31	0.3	0.34	0.44
Interest Cover(x)	1.08	1.19	1.5	1.57	1.53	1.18	2.13	8.9	3.99
Total Debt/Mcap(x)	0	0	0	0	0	0	0	0	0.19

Keystone Realtors Shareholding Pattern

#	Sep 2022	Dec 2022	Mar 2023	Jun 2023	Sep 2023
Promoter	96.71	86.7	86.7	86.7	86.7
FII	0	2.45	1.66	1.49	1.53
DII	2.42	5.91	6.64	7.86	7.98
Public	0.87	4.94	5	3.95	3.79
Others	0	0	0	0	0
Total	100	100	100	100	100

#	Sep 2022	Dec 2022	Mar 2023	Jun 2023	Sep 2023
Promoter	10.01	9.87	9.87	9.87	9.87
FII	0	0.28	0.19	0.17	0.17
DII	0.25	0.67	0.76	0.89	0.91
Public	0.09	0.56	0.57	0.45	0.43
Others	0	0	0	0	0
Total	10.35	11.39	11.39	11.39	11.39

Pros

Debtor days have improved from 217.41 to -1118.91days.
Company has reduced debt.

Cons

Stock is trading at 3.6 times its book value.
The company has delivered a poor profit growth of -7% over past five years.

* The pros and cons are machine generated. Pros / cons are based on a checklist to highlight important points. Please exercise caution and do your own analysis.