Market Cap ₹7430 Cr.
Stock P/E 47.0
P/B 4.3
Current Price ₹652.4
Book Value ₹ 152.8
Face Value 10
52W High ₹750
Dividend Yield 0%
52W Low ₹ 442
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.
Price goes above X
Price falls below X
PE goes above X
PE falls below X
₹ | |
#(Fig in Cr.) | Dec 2021 | Mar 2022 | Jun 2022 | Sep 2022 | Dec 2022 | Mar 2023 | Jun 2023 | Sep 2023 | Dec 2023 |
---|---|---|---|---|---|---|---|---|---|
Net Sales | 871 | 234 | 169 | 46 | 127 | 344 | 272 | 618 | 521 |
Other Income | 7 | 14 | 7 | 10 | 9 | 13 | 11 | 15 | 13 |
Total Income | 878 | 248 | 176 | 56 | 136 | 358 | 283 | 633 | 533 |
Total Expenditure | 760 | 176 | 164 | 53 | 118 | 247 | 209 | 632 | 512 |
Operating Profit | 118 | 72 | 12 | 3 | 18 | 110 | 74 | 1 | 21 |
Interest | 3 | 6 | 3 | 5 | 6 | 22 | 7 | 7 | 7 |
Depreciation | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 2 | 2 |
Exceptional Income / Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Profit Before Tax | 115 | 66 | 8 | -3 | 11 | 86 | 66 | -8 | 12 |
Provision for Tax | 28 | 20 | 3 | 0 | 4 | 21 | 20 | -2 | 4 |
Profit After Tax | 87 | 46 | 5 | -3 | 7 | 65 | 46 | -5 | 9 |
Adjustments | 2 | -4 | 0 | -2 | -2 | 11 | 1 | 10 | 22 |
Profit After Adjustments | 90 | 42 | 5 | -5 | 5 | 77 | 47 | 4 | 30 |
Adjusted Earnings Per Share | 9 | 4.2 | 0.5 | -0.5 | 0.5 | 6.7 | 4.1 | 0.4 | 2.7 |
#(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 | 1755 |
Other Income | 17 | 110 | 38 | 40 | 65 | 26 | 57 | 329 | 34 | 45 | 52 |
Total Income | 443 | 891 | 1056 | 713 | 1595 | 2143 | 1269 | 1177 | 1303 | 730 | 1807 |
Total Expenditure | 432 | 678 | 701 | 599 | 1294 | 1609 | 1075 | 735 | 1090 | 587 | 1600 |
Operating Profit | 10 | 213 | 355 | 114 | 301 | 534 | 193 | 442 | 213 | 143 | 206 |
Interest | 141 | 193 | 296 | 54 | 129 | 348 | 128 | 140 | 23 | 36 | 43 |
Depreciation | 3 | 5 | 4 | 3 | 2 | 3 | 2 | 2 | 3 | 5 | 7 |
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 | 156 |
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 | 115 |
Adjustments | 2 | -21 | -18 | 0 | 0 | -36 | 8 | 67 | 4 | 2 | 44 |
Profit After Adjustments | -132 | -18 | 29 | 35 | 121 | 102 | 22 | 310 | 140 | 82 | 158 |
Adjusted Earnings Per Share | -61113.1 | -7051.4 | 11758.3 | 13983.9 | 48891.1 | 10.2 | 2.2 | 31 | 14 | 7.2 | 13.9 |
# | 1 Year | 3 Year | 5 Year | 10 Year |
---|---|---|---|---|
Sales CAGR | -46% | -17% | -15% | 0% |
Operating Profit CAGR | -33% | -10% | -14% | 0% |
PAT CAGR | -41% | 79% | -8% | 0% |
# | 1 Year | 3 Year | 5 Year | 10 Year |
---|---|---|---|---|
Share Price CAGR | 44% | NA% | NA% | NA% |
ROE Average | 6% | 20% | 21% | 16% |
ROCE Average | 6% | 11% | 11% | 10% |
#(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 | 163 | 161 | 19 | 24 | 30 |
Other Non-Current Assets | 128 | 91 | 105 | 150 | 57 | 138 | 231 | 684 | 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 |
#(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 | -204 | -141 | 160 | 202 | 429 | 355 | 645 | -110 | 306 |
Cash Flow from Investing Activities | -111 | 12 | -15 | 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 | -58 | 22 | -25 | 15 | 29 | 323 | -202 | -93 | 303 |
Closing Cash & Cash Equivalent | 103 | 45 | 61 | 19 | 4 | 32 | 355 | 153 | 60 | 362 |
# | Mar 2014 | Mar 2015 | Mar 2016 | Mar 2017 | Mar 2018 | Mar 2019 | Mar 2020 | Mar 2021 | Mar 2022 | Mar 2023 |
---|---|---|---|---|---|---|---|---|---|---|
Earnings Per Share (Rs) | -61113.08 | -7051.43 | 11758.32 | 13983.87 | 48891.13 | 10.17 | 2.2 | 31.04 | 13.96 | 7.2 |
CEPS(Rs) | 0 | 0 | 0 | 0 | 0 | 13.96 | 1.64 | 24.5 | 13.92 | 7.39 |
DPS(Rs) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Book NAV/Share(Rs) | -191052.33 | -169726.54 | -193308.08 | 99800.32 | 101885 | 40.38 | 42.72 | 80.07 | 93.24 | 146.05 |
Core EBITDA Margin(%) | -1.72 | 12.03 | 12.88 | 11.06 | 15.42 | 14.32 | 11.24 | 13.42 | 14.16 | 14.35 |
EBIT Margin(%) | 1.67 | 15.08 | 14.27 | 18.03 | 19.95 | 15.43 | 15.78 | 51.96 | 16.36 | 20.96 |
Pre Tax Margin(%) | -31.38 | 1.94 | 5.45 | 10 | 11.55 | 8.63 | 5.2 | 35.49 | 14.53 | 15.71 |
PAT Margin (%) | -31.48 | 0.44 | 4.66 | 5.15 | 7.93 | 6.49 | 1.18 | 28.69 | 10.7 | 11.59 |
Cash Profit Margin (%) | -30.76 | 1.06 | 5.03 | 5.56 | 8.08 | 6.6 | 1.36 | 28.87 | 10.97 | 12.27 |
ROA(%) | -4.4 | 0.11 | 1.39 | 1.18 | 3.9 | 3.45 | 0.34 | 6.13 | 3.64 | 1.91 |
ROE(%) | 0 | 0 | 0 | 0 | 48.48 | 41.86 | 3.43 | 39.66 | 15.67 | 6.13 |
ROCE(%) | 0.61 | 9.58 | 10.46 | 8.76 | 17.65 | 15.56 | 7.7 | 17.77 | 9.21 | 5.55 |
Receivable days | 57.97 | 23.13 | 22.94 | 65.07 | 49.75 | 43.28 | 44.08 | 21.63 | 21.61 | 46.64 |
Inventory Days | 2060.2 | 1187.32 | 998.8 | 1246.2 | 532.29 | 486.05 | 851.39 | 1066.07 | 639.34 | 1284.16 |
Payable days | 95.47 | 91.78 | 104.31 | 134.14 | 81.43 | 107.04 | 148.79 | 187.6 | 158.1 | 2196.07 |
PER(x) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 64.33 |
Price/Book(x) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3.17 |
Dividend Yield(%) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EV/Net Sales(x) | 3.48 | 2.14 | 1.87 | 1.5 | 1.18 | 0.77 | 1.83 | 1.22 | 1.12 | 8.58 |
EV/Core EBITDA(x) | 145.85 | 13.64 | 12.76 | 8.82 | 5.98 | 4.94 | 11.49 | 2.34 | 6.68 | 41.11 |
Net Sales Growth(%) | 0 | 83.58 | 30.38 | -33.8 | 127 | 38.42 | -42.77 | -29.94 | 49.56 | -45.98 |
EBIT Growth(%) | 0 | 1562.6 | 23.41 | -16.38 | 151.25 | 7.03 | -41.48 | 130.67 | -52.9 | -30.81 |
PAT Growth(%) | 0 | 102.58 | 1273.07 | -26.87 | 249.63 | 13.34 | -89.64 | 1610.25 | -44.23 | -41.47 |
EPS Growth(%) | 0 | 88.46 | 266.75 | 18.93 | 249.63 | -99.98 | -78.39 | 1312.81 | -55.03 | -48.44 |
Debt/Equity(x) | -3.84 | -4.06 | -4.92 | 2.69 | 5.17 | 4.01 | 5.88 | 1.52 | 1.67 | 0.62 |
Current Ratio(x) | 0.84 | 0.93 | 0.94 | 1.04 | 1.16 | 1.21 | 1.05 | 1.21 | 1.22 | 1.46 |
Quick Ratio(x) | 0.13 | 0.13 | 0.14 | 0.21 | 0.3 | 0.28 | 0.31 | 0.3 | 0.34 | 0.44 |
Interest Cover(x) | 0.05 | 1.15 | 1.62 | 2.25 | 2.37 | 2.27 | 1.49 | 3.16 | 8.9 | 3.99 |
Total Debt/Mcap(x) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.19 |
# | Sep 2022 | Dec 2022 | Mar 2023 | Jun 2023 | Sep 2023 | Dec 2023 | Mar 2024 |
---|---|---|---|---|---|---|---|
Promoter | 96.71 | 86.7 | 86.7 | 86.7 | 86.7 | 86.7 | 86.7 |
FII | 0 | 2.45 | 1.66 | 1.49 | 1.53 | 2.44 | 2.33 |
DII | 2.42 | 5.91 | 6.64 | 7.86 | 7.98 | 8.19 | 8.72 |
Public | 0.87 | 4.94 | 5 | 3.95 | 3.79 | 2.67 | 2.25 |
Others | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Total | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
# | Sep 2022 | Dec 2022 | Mar 2023 | Jun 2023 | Sep 2023 | Dec 2023 | Mar 2024 |
---|---|---|---|---|---|---|---|
Promoter | 10.01 | 9.87 | 9.87 | 9.87 | 9.87 | 9.87 | 9.87 |
FII | 0 | 0.28 | 0.19 | 0.17 | 0.17 | 0.28 | 0.27 |
DII | 0.25 | 0.67 | 0.76 | 0.89 | 0.91 | 0.93 | 0.99 |
Public | 0.09 | 0.56 | 0.57 | 0.45 | 0.43 | 0.3 | 0.26 |
Others | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Total | 10.35 | 11.39 | 11.39 | 11.39 | 11.39 | 11.39 | 11.39 |
Pros
Cons
* 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.
Companies | Open Date | Close Date | Issue Price | Cost of 1 Lot | GMP | Expected Listing | Listing Gain(%) | Listing Price | Current Price | Type | Exchange |
---|
Companies | Open Date | Close Date | Issue Price | Cost of 1 Lot | GMP | Expected Listing | Listing Gain(%) | Listing Price | Current Price | Type | Exchange |
---|
Companies | Open Date | Close Date | Issue Price | Cost of 1 Lot | GMP | Expected Listing | Listing Gain(%) | Listing Price | Current Price | Type | Exchange |
---|
Companies | Open Date | Close Date | Issue Price | Cost of 1 Lot | GMP | Expected Listing | Listing Gain(%) | Listing Price | Current Price | Type | Exchange |
---|
Companies | Open Date | Close Date | Issue Price | Cost of 1 Lot | GMP | Expected Listing | Listing Gain(%) | Listing Price | Current Price | Type | Exchange |
---|
You May Also Know About