Ashiana Housing Ltd

ASHIANA
Realty
โ‚น 311.20
Price
โ‚น 3,112
Market Cap
Small Cap
164.57
P/E Ratio

๐Ÿ“Š Score Snapshot

2.17 / 25
Performance
17.29 / 25
Valuation
0.73 / 20
Growth
7.0 / 30
Profitability
27.19 / 100
Avoid

๐Ÿข Company Overview

โณ Loading company overview...

๐Ÿค– CARL Insights

โณ Loading CARL insights...

๐Ÿ“ˆ Net Profit (Yearly)

๐Ÿ“Š Sales (Yearly)

๐Ÿ“‰ Quarterly Sales Trend

๐Ÿ“‰ Quarterly Net Profit

๐Ÿ“ˆ Yearly Ratios

Metric Mar 2024 Mar 2023 Mar 2022 Mar 2021 Mar 2020 Mar 2019 Mar 2018 Mar 2017
Adj Cash EBITDA 234.74 10.49 -68.51 122.42 50.68 3.00 -42.41 -22.30
Adj Cash EBITDA Margin 25.16 2.62 -31.00 49.76 17.24 0.88 -15.53 -5.98
Adj Cash EBITDA To EBITDA 2.05 0.23 -27.51 11.75 -38.39 0.06 -0.67 -0.22
Adj Cash EPS 20.68 -0.60 -7.87 - 1.00 -2.83 -6.39 -5.11
Adj Cash PAT 206.83 -6.17 -79.82 - 10.20 -29.36 -64.88 -52.27
Adj Cash PAT To PAT 2.38 -0.21 9.05 - -0.24 -2.01 -1.58 -0.74
Adj Cash PE 13.98 - - - 20.84 - - -
Adj EPS 8.68 2.80 -0.87 - -4.11 1.41 4.05 6.91
Adj EV To Cash EBITDA 11.33 159.26 - 10.89 9.26 398.74 - -
Adj EV To EBITDA 23.17 36.73 530.11 127.95 - 25.45 25.76 21.75
Adj Number Of Shares 10.00 10.29 10.14 11.76 10.17 10.37 10.16 10.23
Adj PE 34.00 62.65 - - - 89.83 44.60 34.89
Adj Peg 0.16 - - - - - - -
Bvps 77.00 73.76 72.58 63.78 73.65 75.31 75.30 70.58
Cash Conversion Cycle 2,658 29.00 41.00 41.00 4,563 3,213 9,261 23.00
Cash ROCE 19.34 -1.22 -8.07 - 5.33 -2.37 -8.39 -6.53
Cash Roic 26.00 -3.34 -11.76 - 5.20 -4.08 -13.07 -11.25
Cash Revenue 933.00 401.00 221.00 246.00 294.00 340.00 273.00 373.00
Cash Revenue To Revenue 0.99 0.98 1.00 1.02 0.97 1.01 0.85 0.98
Dio 2,736 - - - 4,701 3,261 9,495 -
Dpo 95.00 - - - 176.00 73.00 263.00 -
Dso 17.00 29.00 41.00 41.00 38.00 25.00 29.00 23.00
Dividend Yield 0.52 0.29 0.65 0.32 0.59 0.22 0.16 0.12
EV 2,659 1,671 1,320 1,333 469.43 1,196 1,638 2,190
EV To EBITDA 24.23 37.56 206.57 531.19 33.48 26.06 27.50 22.90
EV To Fcff 15.97 - - - 11.89 - - -
Fcfe 151.71 6.64 32.94 - -27.39 -8.03 -25.67 -26.48
Fcfe Margin 16.26 1.66 14.90 - -9.32 -2.36 -9.40 -7.10
Fcfe To Adj PAT 1.75 0.23 -3.73 - 0.66 -0.55 -0.62 -0.37
Fcff 166.51 -23.25 -75.17 - 39.49 -28.92 -79.34 -57.10
Fcff Margin 17.85 -5.80 -34.01 - 13.43 -8.51 -29.06 -15.31
Fcff To NOPAT 2.46 -1.23 9.48 - -2.33 -1.84 -2.18 -0.93
Market Cap 2,850 1,744 1,411 1,505 504.43 1,225 1,700 2,328
PB 3.70 2.30 1.92 2.01 0.67 1.57 2.22 3.22
PE 34.34 62.30 - 752.94 - 87.52 44.75 34.75
Peg 0.17 - - - - - - -
PS 3.02 4.25 6.36 6.22 1.66 3.62 5.30 6.10
ROCE 8.72 3.33 -0.30 - -0.87 2.46 5.12 8.92
ROE 11.36 3.86 -1.19 - -5.46 1.89 5.53 10.31
Roic 10.56 2.72 -1.24 - -2.23 2.22 6.00 12.04
Share Price 285.00 169.45 139.15 128.00 49.60 118.15 167.35 227.60

๐Ÿ“Š Quarterly Results

Metric Dec 2024 Sep 2024 Jun 2024 Mar 2024 Dec 2023 Sep 2023 Jun 2023 Mar 2023 Dec 2022 Sep 2022 Jun 2022 Mar 2022 Dec 2021 Sep 2021
Sales 133.00 55.00 123.00 290.00 184.00 346.00 121.00 111.00 130.00 87.00 80.00 75.00 51.00 57.75
Interest 1.00 1.00 2.00 - - 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.32
Expenses - 116.00 66.00 129.00 269.00 152.00 313.00 113.00 103.00 120.00 92.00 65.00 68.00 55.00 63.33
Other Income - 6.76 4.99 5.42 7.29 4.77 4.93 7.99 5.46 5.38 4.90 1.21 3.61 2.79 2.94
Exceptional Items -5.00 - - - - - - - - - - - -3.07 -
Depreciation 3.00 3.00 3.00 2.00 3.00 2.00 2.00 2.00 2.00 2.00 2.00 1.00 2.00 2.36
Profit Before Tax 15.00 -10.00 -5.00 25.00 35.00 35.00 13.00 11.00 13.00 -3.00 13.00 8.00 -7.00 -6.32
Tax % 26.67 20.00 - 32.00 20.00 22.86 15.38 9.09 30.77 33.33 23.08 25.00 42.86 9.18
Net Profit - 11.00 -8.00 -5.00 17.00 28.00 27.00 11.00 10.00 9.00 -2.00 10.00 6.00 -4.00 -5.74
Exceptional Items At -3.64 - - - - - - - - - - - -3.07 -
Profit For PE 14.53 -7.55 -5.45 17.38 27.80 27.35 10.87 10.38 9.05 -1.81 10.26 6.31 -0.77 -6.00
Profit For EPS 10.89 -7.55 -5.45 17.38 27.80 27.35 10.87 10.38 9.05 -1.81 10.26 6.31 -3.84 -6.00
EPS In Rs 1.08 -0.75 -0.54 1.73 2.77 2.72 1.06 1.01 0.88 -0.18 1.00 0.62 -0.38 -0.56
PAT Margin % 8.27 -14.55 -4.07 5.86 15.22 7.80 9.09 9.01 6.92 -2.30 12.50 8.00 -7.84 -9.94
PBT Margin 11.28 -18.18 -4.07 8.62 19.02 10.12 10.74 9.91 10.00 -3.45 16.25 10.67 -13.73 -10.94
Tax 4.00 -2.00 - 8.00 7.00 8.00 2.00 1.00 4.00 -1.00 3.00 2.00 -3.00 -0.58
Yoy Profit Growth % -47.73 -127.61 -150.14 67.44 207.18 1,611 5.95 64.50 1,275 68.47 300.00 211.88 -105.99 -151.00
Adj Ebit 20.76 -9.01 -3.58 26.29 33.77 35.93 13.99 11.46 13.38 -2.10 14.21 9.61 -3.21 -5.00
Adj EBITDA 23.76 -6.01 -0.58 28.29 36.77 37.93 15.99 13.46 15.38 -0.10 16.21 10.61 -1.21 -2.64
Adj EBITDA Margin 17.86 -10.93 -0.47 9.76 19.98 10.96 13.21 12.13 11.83 -0.11 20.26 14.15 -2.37 -4.57
Adj Ebit Margin 15.61 -16.38 -2.91 9.07 18.35 10.38 11.56 10.32 10.29 -2.41 17.76 12.81 -6.29 -8.66
Adj PAT 7.33 -8.00 -5.00 17.00 28.00 27.00 11.00 10.00 9.00 -2.00 10.00 6.00 -5.75 -5.74
Adj PAT Margin 5.51 -14.55 -4.07 5.86 15.22 7.80 9.09 9.01 6.92 -2.30 12.50 8.00 -11.27 -9.94
Ebit 25.76 -9.01 -3.58 26.29 33.77 35.93 13.99 11.46 13.38 -2.10 14.21 9.61 -0.14 -5.00
EBITDA 28.76 -6.01 -0.58 28.29 36.77 37.93 15.99 13.46 15.38 -0.10 16.21 10.61 1.86 -2.64
EBITDA Margin 21.62 -10.93 -0.47 9.76 19.98 10.96 13.21 12.13 11.83 -0.11 20.26 14.15 3.65 -4.57
Ebit Margin 19.37 -16.38 -2.91 9.07 18.35 10.38 11.56 10.32 10.29 -2.41 17.76 12.81 -0.27 -8.66
NOPAT 10.27 -11.20 -9.00 12.92 23.20 23.91 5.08 5.45 5.54 -4.67 10.00 4.50 -3.43 -7.21
NOPAT Margin 7.72 -20.36 -7.32 4.46 12.61 6.91 4.20 4.91 4.26 -5.37 12.50 6.00 -6.73 -12.48
Operating Profit 14.00 -14.00 -9.00 19.00 29.00 31.00 6.00 6.00 8.00 -7.00 13.00 6.00 -6.00 -7.94
Operating Profit Margin 10.53 -25.45 -7.32 6.55 15.76 8.96 4.96 5.41 6.15 -8.05 16.25 8.00 -11.76 -13.75

๐Ÿ’ฐ Profit & Loss

Metric Mar 2024 Mar 2023 Mar 2022 Mar 2021 Mar 2020 Mar 2019 Mar 2018 Mar 2017 Mar 2016 Mar 2015 Mar 2014 Mar 2013
Sales 944.00 410.00 222.00 242.00 304.00 338.00 321.00 382.00 529.00 143.00 111.00 149.00
Interest 2.00 3.00 5.00 9.00 14.00 15.00 12.00 7.00 3.00 2.00 2.00 3.00
Expenses - 847.00 379.00 231.00 241.00 317.00 303.00 267.00 291.00 389.00 105.00 91.00 114.00
Other Income - 17.74 14.49 11.49 9.42 11.68 12.00 9.59 9.70 11.11 13.09 7.44 8.09
Exceptional Items 4.98 1.01 -3.90 7.91 -15.34 1.09 4.02 5.07 2.60 8.62 3.43 4.60
Depreciation 9.00 8.00 8.00 9.00 9.00 8.00 7.00 8.00 8.00 8.00 3.00 3.00
Profit Before Tax 108.00 34.00 -15.00 - -39.00 24.00 49.00 91.00 143.00 49.00 26.00 42.00
Tax % 23.15 17.65 53.33 - 23.08 41.67 22.45 26.37 25.87 4.08 15.38 21.43
Net Profit - 83.00 28.00 -7.00 2.00 -30.00 14.00 38.00 67.00 106.00 47.00 22.00 33.00
Exceptional Items At 4.00 1.00 -4.00 8.00 -14.00 1.00 3.00 4.00 2.00 8.00 3.00 4.00
Profit For PE 80.00 27.00 -3.00 -6.00 -16.00 13.00 35.00 63.00 104.00 38.00 19.00 30.00
Profit For EPS 83.00 28.00 -7.00 2.00 -30.00 14.00 38.00 67.00 106.00 46.00 22.00 33.00
EPS In Rs 8.30 2.72 -0.69 0.17 -2.95 1.35 3.74 6.55 10.34 4.54 2.35 3.56
Dividend Payout % 18.00 18.00 -131.00 238.00 -10.00 19.00 7.00 4.00 5.00 11.00 21.00 13.00
PAT Margin % 8.79 6.83 -3.15 0.83 -9.87 4.14 11.84 17.54 20.04 32.87 19.82 22.15
PBT Margin 11.44 8.29 -6.76 - -12.83 7.10 15.26 23.82 27.03 34.27 23.42 28.19
Tax 25.00 6.00 -8.00 -2.00 -9.00 10.00 11.00 24.00 37.00 2.00 4.00 9.00
Adj Ebit 105.74 37.49 -5.51 1.42 -10.32 39.00 56.59 92.70 143.11 43.09 24.44 40.09
Adj EBITDA 114.74 45.49 2.49 10.42 -1.32 47.00 63.59 100.70 151.11 51.09 27.44 43.09
Adj EBITDA Margin 12.15 11.10 1.12 4.31 -0.43 13.91 19.81 26.36 28.57 35.73 24.72 28.92
Adj Ebit Margin 11.20 9.14 -2.48 0.59 -3.39 11.54 17.63 24.27 27.05 30.13 22.02 26.91
Adj PAT 86.83 28.83 -8.82 - -41.80 14.64 41.12 70.73 107.93 55.27 24.90 36.61
Adj PAT Margin 9.20 7.03 -3.97 - -13.75 4.33 12.81 18.52 20.40 38.65 22.43 24.57
Ebit 100.76 36.48 -1.61 -6.49 5.02 37.91 52.57 87.63 140.51 34.47 21.01 35.49
EBITDA 109.76 44.48 6.39 2.51 14.02 45.91 59.57 95.63 148.51 42.47 24.01 38.49
EBITDA Margin 11.63 10.85 2.88 1.04 4.61 13.58 18.56 25.03 28.07 29.70 21.63 25.83
Ebit Margin 10.67 8.90 -0.73 -2.68 1.65 11.22 16.38 22.94 26.56 24.10 18.93 23.82
NOPAT 67.63 18.94 -7.93 - -16.92 15.75 36.45 61.11 97.85 28.78 14.39 25.14
NOPAT Margin 7.16 4.62 -3.57 - -5.57 4.66 11.36 16.00 18.50 20.13 12.96 16.87
Operating Profit 88.00 23.00 -17.00 -8.00 -22.00 27.00 47.00 83.00 132.00 30.00 17.00 32.00
Operating Profit Margin 9.32 5.61 -7.66 -3.31 -7.24 7.99 14.64 21.73 24.95 20.98 15.32 21.48

๐Ÿฆ Balance Sheet

Metric Sep 2024 Mar 2024 Sep 2023 Mar 2023 Mar 2022 Mar 2021 Mar 2020 Mar 2019 Mar 2018 Mar 2017
Accumulated Depreciation - 44.31 - 42.55 44.14 40.47 35.64 28.51 21.67 15.15
Advance From Customers - 1,254 - 1,077 820.00 398.00 177.00 164.00 240.00 320.00
Average Capital Employed 953.00 931.50 - 927.50 864.50 846.00 909.00 923.50 857.50 765.50
Average Invested Capital 619.50 640.50 - 696.00 639.00 674.00 760.00 709.50 607.00 507.50
Average Total Assets 2,596 2,303 - 2,032 1,602 1,256 1,184 1,213 1,226 1,202
Average Total Equity 743.00 764.50 - 747.50 743.00 749.50 765.00 773.00 743.50 686.00
Cwip - - - 3.00 - - - - - -
Capital Employed 1,030 919.00 876.00 944.00 911.00 818.00 874.00 944.00 903.00 812.00
Cash Equivalents 305.00 231.00 165.00 156.00 127.00 154.00 93.00 64.00 42.00 53.00
Fixed Assets 105.00 101.00 86.00 74.00 93.00 98.00 130.00 121.00 121.00 86.00
Gross Block - 145.67 - 116.48 136.98 138.28 165.70 149.73 142.38 101.23
Inventory 2,001 1,526 1,490 1,529 1,247 741.00 620.00 625.00 638.00 670.00
Invested Capital 581.00 563.00 658.00 718.00 674.00 604.00 744.00 776.00 643.00 571.00
Investments 102.00 108.00 90.00 101.00 138.00 86.00 66.00 128.00 158.00 174.00
Lease Liabilities 7.00 1.00 1.00 2.00 12.00 15.00 - - - -
Loans N Advances 43.00 25.00 - 3.00 -3.00 3.00 4.00 1.00 87.00 48.00
Long Term Borrowings 251.00 128.00 123.00 165.00 156.00 47.00 104.00 143.00 63.00 78.00
Net Debt -133.00 -191.00 -107.00 -73.00 -91.00 -172.00 -35.00 -29.00 -62.00 -138.00
Net Working Capital 476.00 462.00 572.00 641.00 581.00 506.00 614.00 655.00 522.00 485.00
Non Controlling Interest - - - - - - - - - -
Other Asset Items 397.00 370.00 335.00 302.00 237.00 230.00 227.00 232.00 161.00 166.00
Other Borrowings - - - - - - 20.00 17.00 14.00 10.00
Other Liability Items 1,911 180.00 1,299 142.00 106.00 97.00 99.00 72.00 71.00 74.00
Reserves 737.00 750.00 709.00 739.00 716.00 730.00 729.00 761.00 745.00 702.00
Share Capital 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00
Short Term Borrowings 16.00 19.00 24.00 17.00 6.00 6.00 - 3.00 60.00 1.00
Short Term Loans And Advances - 9.00 4.00 - - 2.00 2.00 2.00 2.00 9.00
Total Assets 2,987 2,406 2,205 2,200 1,864 1,339 1,173 1,194 1,232 1,220
Total Borrowings 274.00 148.00 148.00 184.00 174.00 68.00 124.00 163.00 138.00 89.00
Total Equity 757.00 770.00 729.00 759.00 736.00 750.00 749.00 781.00 765.00 722.00
Total Equity And Liabilities 2,987 2,406 2,205 2,200 1,864 1,339 1,173 1,194 1,232 1,220
Total Liabilities 2,230 1,636 1,476 1,441 1,128 589.00 424.00 413.00 467.00 498.00
Trade Payables 46.00 53.00 30.00 37.00 27.00 26.00 23.00 14.00 18.00 14.00
Trade Receivables 35.00 44.00 72.00 66.00 50.00 54.00 64.00 46.00 50.00 48.00

๐Ÿ’ต Cash Flows

Metric Mar 2024 Mar 2023 Mar 2022 Mar 2021 Mar 2020 Mar 2019 Mar 2018 Mar 2017
Cash From Financing Activity -128.00 -14.00 81.00 -73.00 -63.00 2.00 32.00 15.00
Cash From Investing Activity -10.00 32.00 -22.00 12.00 64.00 31.00 11.00 -24.00
Cash From Operating Activity 212.00 12.00 -85.00 121.00 28.00 -10.00 -54.00 -39.00
Cash Paid For Purchase Of Fixed Assets -31.67 -16.11 -5.45 -8.88 -6.02 -8.93 -19.06 -3.46
Cash Paid For Purchase Of Investments - - -26.16 -7.45 - - - -40.88
Cash Paid For Repayment Of Borrowings -34.00 - - -53.00 -42.00 - - -
Cash Received From Borrowings - 20.00 109.00 - - 22.00 49.00 21.00
Cash Received From Issue Of Shares - - - - - - - -
Cash Received From Sale Of Fixed Assets 1.55 0.92 1.21 21.93 1.43 0.26 2.27 0.25
Cash Received From Sale Of Investments 16.02 36.37 - - 59.55 30.71 19.97 -
Change In Inventory 3.00 -282.00 -506.00 -98.00 5.00 13.00 8.00 -56.00
Change In Other Working Capital Items 110.00 246.00 433.00 203.00 47.00 -56.00 11.00 2.00
Change In Payables 18.00 10.00 2.00 3.00 10.00 -3.00 -77.00 -60.00
Change In Receivables -11.00 -9.00 -1.00 4.00 -10.00 2.00 -48.00 -9.00
Change In Working Capital 120.00 -35.00 -71.00 112.00 52.00 -44.00 -106.00 -123.00
Direct Taxes Paid -22.00 -7.00 -3.00 -2.00 -2.00 -6.00 -9.00 -13.00
Dividends Paid -5.00 -5.00 -8.00 -3.00 -3.00 -3.00 -3.00 -
Interest Paid -18.00 -28.00 -17.00 -14.00 -17.00 -17.00 -14.00 -7.00
Interest Received 7.11 4.85 4.59 4.21 4.73 5.22 3.95 4.45
Investment Income 6.16 5.91 3.35 2.43 4.17 3.46 3.91 15.92
Net Cash Flow 75.00 29.00 -27.00 61.00 29.00 22.00 -11.00 -48.00
Other Cash Financing Items Paid -70.00 -2.00 -3.00 -3.00 -1.00 - - -
Other Cash Investing Items Paid -9.08 - - - - - - -
Other Cash Operating Items Paid - - -4.00 - -17.00 - - -
Profit From Operations 114.00 53.00 -7.00 11.00 -4.00 40.00 61.00 96.00

๐Ÿงพ Shareholding Pattern

Nse Code Date Promoters Fii Dii Public Others
Ashiana 2024-12-31 - 7.47 7.75 23.67 0.00
Ashiana 2024-09-30 - 7.46 7.85 23.58 0.00
Ashiana 2024-06-30 - 8.34 6.99 23.57 0.00
Ashiana 2024-03-31 - 8.28 7.08 23.54 0.00
๐Ÿ’ฌ
Stock Chat