Ashiana Housing Ltd: Intrinsic Value & Share Price Analysis

Share Price and Basic Stock Data

Last Updated: April 4, 2025, 12:04 pm

Market Cap	2,947 Cr.
Current Price	293
High / Low	469/278
Stock P/E	156
Book Value	74.9
Dividend Yield	0.50 %
ROCE	11.3 %
ROE	10.4 %
Face Value	2.00
PEG Ratio	2.84

Stock P/E, Current Price, and Intrinsic Value Over Time

Stock P/E Current Price Intrinsic Value

View Share Price Target for Ashiana Housing Ltd

Competitors of Ashiana Housing Ltd

Stock Name ⇩	Market Cap ⇩	Current Price ⇩	High / Low ⇩	Stock P/E ⇩	Book Value ⇩	Dividend Yield ⇩	ROCE ⇩	ROE ⇩	Face Value ⇩
Hampton Sky Realty Ltd	632 Cr.	23.0	38.3/22.0	26.5	5.74	0.00 %	15.7 %	10.6 %	1.00
Grovy India Ltd	65.5 Cr.	49.1	98.2/22.6	40.2	13.9	0.05 %	5.79 %	5.27 %	10.0
Gothi Plascon (India) Ltd	50.5 Cr.	49.5	53.6/32.2	33.2	12.4	4.04 %	17.8 %	12.9 %	10.0
Generic Engineering Construction & Projects Ltd	164 Cr.	28.9	71.0/22.0	16.0	48.5	0.00 %	6.61 %	4.33 %	5.00
Garnet Construction Ltd	35.0 Cr.	25.2	57.2/21.6	6.58	73.3	0.00 %	4.51 %	3.13 %	10.0
Industry Average	17,222.52 Cr	423.64		48.05	132.01	0.58%	10.29%	8.69%	6.13

All Competitor Stocks of Ashiana Housing Ltd

Quarterly Result

Metric	Dec 2021	Mar 2022	Jun 2022	Sep 2022	Dec 2022	Mar 2023	Jun 2023	Sep 2023	Dec 2023	Mar 2024	Jun 2024	Sep 2024	Dec 2024
Sales	51	75	80	87	130	111	121	346	184	290	123	55	133
Expenses	55	68	65	92	120	103	113	313	152	269	129	66	116
Operating Profit	-4	6	15	-5	10	9	8	33	33	20	-6	-12	17
OPM %	-7%	9%	18%	-6%	8%	8%	7%	10%	18%	7%	-5%	-22%	13%
Other Income	-0	4	1	5	5	5	8	5	5	7	5	5	2
Interest	1	1	1	1	1	1	1	1	0	0	2	1	1
Depreciation	2	1	2	2	2	2	2	2	3	2	3	3	3
Profit before tax	-7	8	13	-3	13	11	13	35	35	25	-5	-10	15
Tax %	-48%	18%	20%	-33%	29%	9%	16%	23%	20%	30%	19%	-28%	27%
Net Profit	-4	6	10	-2	9	10	11	27	28	17	-5	-8	11
EPS in Rs	-0.38	0.62	1.00	-0.18	0.88	1.01	1.06	2.72	2.77	1.73	-0.54	-0.75	1.08

Last Updated: March 3, 2025, 5:31 pm

Below is a detailed analysis of the quarterly data for Ashiana Housing Ltd based on the most recent figures (Dec 2024) and their trends compared to the previous period:

For Sales, as of Dec 2024, the value is ₹133.00 Cr.. The value appears strong and on an upward trend. It has increased from 55.00 Cr. (Sep 2024) to ₹133.00 Cr., marking an increase of 78.00 Cr..
For Expenses, as of Dec 2024, the value is ₹116.00 Cr.. The value appears to be increasing, which may not be favorable. It has increased from 66.00 Cr. (Sep 2024) to ₹116.00 Cr., marking an increase of 50.00 Cr..
For Operating Profit, as of Dec 2024, the value is ₹17.00 Cr.. The value appears strong and on an upward trend. It has increased from -12.00 Cr. (Sep 2024) to ₹17.00 Cr., marking an increase of 29.00 Cr..
For OPM %, as of Dec 2024, the value is 13.00%. The value appears strong and on an upward trend. It has increased from -22.00% (Sep 2024) to 13.00%, marking an increase of 35.00%.
For Other Income, as of Dec 2024, the value is ₹2.00 Cr.. The value appears to be declining and may need further review. It has decreased from 5.00 Cr. (Sep 2024) to ₹2.00 Cr., marking a decrease of 3.00 Cr..
For Interest, as of Dec 2024, the value is ₹1.00 Cr.. The value remains steady. There is no change compared to the previous period (Sep 2024) which recorded 1.00 Cr..
For Depreciation, as of Dec 2024, the value is ₹3.00 Cr.. The value remains steady. There is no change compared to the previous period (Sep 2024) which recorded 3.00 Cr..
For Profit before tax, as of Dec 2024, the value is ₹15.00 Cr.. The value appears strong and on an upward trend. It has increased from -10.00 Cr. (Sep 2024) to ₹15.00 Cr., marking an increase of 25.00 Cr..
For Tax %, as of Dec 2024, the value is 27.00%. The value appears to be increasing, which may not be favorable. It has increased from -28.00% (Sep 2024) to 27.00%, marking an increase of 55.00%.
For Net Profit, as of Dec 2024, the value is ₹11.00 Cr.. The value appears strong and on an upward trend. It has increased from -8.00 Cr. (Sep 2024) to ₹11.00 Cr., marking an increase of 19.00 Cr..
For EPS in Rs, as of Dec 2024, the value is 1.08. The value appears strong and on an upward trend. It has increased from -0.75 (Sep 2024) to 1.08, marking an increase of 1.83.

Overall, while many items appear to show a positive trend, any significant downward movement warrant further investigation.

Quarterly Chart

Profit & Loss - Annual Report

Last Updated: March 7, 2025, 9:13 pm

Metric	Mar 2013	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	Mar 2022	Mar 2023	Mar 2024	TTM
Sales	149	111	143	529	382	321	338	304	242	222	410	944	600
Expenses	114	91	105	389	291	267	303	317	241	231	379	847	581
Operating Profit	35	20	37	140	91	54	34	-13	1	-9	30	97	20
OPM %	23%	18%	26%	27%	24%	17%	10%	-4%	0%	-4%	7%	10%	3%
Other Income	13	11	22	14	15	14	13	-4	17	8	16	23	19
Interest	3	2	2	3	7	12	15	14	9	5	3	2	3
Depreciation	3	3	8	8	8	7	8	9	9	8	8	9	12
Profit before tax	42	26	49	143	91	49	24	-39	0	-15	34	108	25
Tax %	21%	15%	5%	26%	27%	22%	42%	-23%	-473%	-52%	19%	23%
Net Profit	33	22	47	106	67	38	14	-30	2	-7	28	83	15
EPS in Rs	3.56	2.35	4.54	10.34	6.55	3.74	1.35	-2.95	0.17	-0.69	2.72	8.30	1.52
Dividend Payout %	13%	21%	11%	5%	4%	7%	19%	-10%	238%	-131%	18%	18%

Profit & Loss Yearly Chart

YoY Net Profit Growth

Year	2013-2014	2014-2015	2015-2016	2016-2017	2017-2018	2018-2019	2019-2020	2020-2021	2021-2022	2022-2023	2023-2024
YoY Net Profit Growth (%)	-33.33%	113.64%	125.53%	-36.79%	-43.28%	-63.16%	-314.29%	106.67%	-450.00%	500.00%	196.43%
Change in YoY Net Profit Growth (%)	0.00%	146.97%	11.90%	-162.32%	-6.49%	-19.87%	-251.13%	420.95%	-556.67%	950.00%	-303.57%

Ashiana Housing Ltd has shown an inconsistent trend in YoY Net Profit Growth (%) in the last 11 years from 2013-2014 to 2023-2024.

Growth

Compounded Sales Growth
10 Years:	24%
5 Years:	23%
3 Years:	57%
TTM:	-21%

Compounded Profit Growth
10 Years:	15%
5 Years:	43%
3 Years:	147%
TTM:	-75%

Stock Price CAGR
10 Years:	1%
5 Years:	41%
3 Years:	24%
1 Year:	-9%

Return on Equity
10 Years:	5%
5 Years:	2%
3 Years:	5%
Last Year:	10%

Last Updated: Unknown

Balance Sheet

Last Updated: November 15, 2024, 1:41 am

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	Sep 2024
Equity Capital	19	19	20	20	20	20	20	20	20	20	20	20	20
Reserves	249	266	502	630	702	745	761	729	730	716	739	750	737
Borrowings	14	12	37	68	89	138	163	124	68	174	184	148	274
Other Liabilities	130	316	619	465	409	328	249	299	521	954	1,256	1,487	1,957
Total Liabilities	412	613	1,179	1,183	1,220	1,232	1,194	1,173	1,339	1,864	2,200	2,406	2,987
Fixed Assets	46	56	68	63	86	121	121	130	98	93	74	101	105
CWIP	0	1	4	1	0	0	0	0	0	0	3	0	0
Investments	55	33	255	178	174	158	128	66	86	138	101	108	102
Other Assets	311	522	853	941	960	953	945	976	1,155	1,633	2,022	2,196	2,780
Total Assets	412	613	1,179	1,183	1,220	1,232	1,194	1,173	1,339	1,864	2,200	2,406	2,987

Below is a detailed analysis of the balance sheet data for Ashiana Housing Ltd based on the most recent figures (Sep 2024) and their trends compared to the previous period:

For Equity Capital, as of Sep 2024, the value is ₹20.00 Cr.. The value remains steady. There is no change compared to the previous period (Mar 2024) which recorded 20.00 Cr..
For Reserves, as of Sep 2024, the value is ₹737.00 Cr.. The value appears to be declining and may need further review. It has decreased from 750.00 Cr. (Mar 2024) to ₹737.00 Cr., marking a decrease of 13.00 Cr..
For Borrowings, as of Sep 2024, the value is ₹274.00 Cr.. The value appears to be increasing, which may not be favorable. Additionally, since Reserves exceed Borrowings, this is considered a positive sign. It has increased from 148.00 Cr. (Mar 2024) to ₹274.00 Cr., marking an increase of 126.00 Cr..
For Other Liabilities, as of Sep 2024, the value is ₹1,957.00 Cr.. The value appears to be increasing, which may not be favorable. It has increased from 1,487.00 Cr. (Mar 2024) to ₹1,957.00 Cr., marking an increase of 470.00 Cr..
For Total Liabilities, as of Sep 2024, the value is ₹2,987.00 Cr.. The value appears to be increasing, which may not be favorable. It has increased from 2,406.00 Cr. (Mar 2024) to ₹2,987.00 Cr., marking an increase of 581.00 Cr..
For Fixed Assets, as of Sep 2024, the value is ₹105.00 Cr.. The value appears strong and on an upward trend. It has increased from 101.00 Cr. (Mar 2024) to ₹105.00 Cr., marking an increase of 4.00 Cr..
For CWIP, as of Sep 2024, the value is ₹0.00 Cr.. The value remains steady. There is no change compared to the previous period (Mar 2024) which recorded 0.00 Cr..
For Investments, as of Sep 2024, the value is ₹102.00 Cr.. The value appears to be declining and may need further review. It has decreased from 108.00 Cr. (Mar 2024) to ₹102.00 Cr., marking a decrease of 6.00 Cr..
For Other Assets, as of Sep 2024, the value is ₹2,780.00 Cr.. The value appears strong and on an upward trend. It has increased from 2,196.00 Cr. (Mar 2024) to ₹2,780.00 Cr., marking an increase of 584.00 Cr..
For Total Assets, as of Sep 2024, the value is ₹2,987.00 Cr.. The value appears strong and on an upward trend. It has increased from 2,406.00 Cr. (Mar 2024) to ₹2,987.00 Cr., marking an increase of 581.00 Cr..

Notably, the Reserves (737.00 Cr.) exceed the Borrowings (274.00 Cr.), indicating a solid financial buffer.

Overall, while many items appear to show a positive trend, any significant downward movement or items where Borrowings exceed Reserves warrant further investigation.

Reserves and Borrowings Chart

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 +	-22	-23	-4	-79	-39	-54	-10	28	121	-85	12	212
Cash from Investing Activity +	49	30	-203	121	-24	11	31	64	12	-22	32	-10
Cash from Financing Activity +	-13	-8	213	18	15	32	2	-63	-73	81	-14	-128
Net Cash Flow	14	-0	6	60	-48	-11	22	29	61	-27	29	75

Free 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
Free Cash Flow	21.00	8.00	0.00	72.00	2.00	-84.00	-129.00	-137.00	-67.00	-183.00	-154.00	-51.00

Free Cash Flow = Income Generated from Operational Activities - Borrowings - Capital Work in Progress (CWIP)

Consistent positive free cash flow is crucial for businesses as it indicates their ability to generate cash from their core operations. It provides financial flexibility, allowing companies to invest in growth opportunities, pay dividends to shareholders, reduce debt, and weather economic downturns more effectively.

Free Cash Flow Chart

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	30	32	35	19	23	29	25	38	41	41	29	17
Inventory Days				4,736		9,495	3,261	4,701				2,736
Days Payable				158		263	73	176				95
Cash Conversion Cycle	30	32	35	4,596	23	9,261	3,213	4,563	41	41	29	2,658
Working Capital Days	352	559	435	272	475	654	666	679	729	917	533	198
ROCE %	15%	8%	10%	23%	12%	7%	4%	-1%	0%	-1%	4%	11%

Financial Efficiency Indicators Chart

Share Holding Pattern

Month	Sep 2021	Dec 2021	Mar 2022	Jun 2022	Sep 2022	Dec 2022	Mar 2023	Jun 2023	Sep 2023	Dec 2023	Mar 2024	Jun 2024
Promoters	61.22%	61.22%	61.22%	61.22%	61.22%	61.22%	61.22%	61.22%	61.11%	61.11%	61.11%	61.11%
FIIs	2.55%	4.90%	5.69%	7.49%	7.54%	7.55%	7.58%	7.67%	7.86%	8.24%	8.28%	8.34%
DIIs	10.45%	9.36%	9.44%	7.31%	8.16%	8.51%	8.63%	7.68%	7.40%	7.33%	7.08%	6.99%
Public	25.78%	24.52%	23.65%	23.98%	23.06%	22.72%	22.57%	23.42%	23.64%	23.32%	23.54%	23.57%
No. of Shareholders	20,854	20,300	20,366	20,425	19,820	19,504	18,819	18,749	20,287	19,556	22,304	23,341

Shareholding Pattern Chart

No. of Shareholders

Mutual Fund Holdings

Fund Name	No of Shares	AUM (%)	Amount Invested (Cr)	Previous Number of Shares	Previous Date	Percentage Change
SBI Contra Fund	6,086,223	0.74	255.65	6,086,223	2025-04-03	0%
SBI Multi Asset Allocation Fund	690,963	0.53	29.51	6,086,223	2025-04-03	-88.65%

ROCE Trend

EPS Trend

Key Financial Ratios

Month	Mar 24	Mar 23	Mar 22	Mar 21	Mar 20
FaceValue	2.00	2.00	2.00	2.00	2.00
Basic EPS (Rs.)	8.33	2.81	-0.64	0.40	-2.83
Diluted EPS (Rs.)	8.33	2.81	-0.64	0.40	-2.83
Cash EPS (Rs.)	9.24	3.55	0.12	1.04	-2.06
Book Value[Excl.RevalReserv]/Share (Rs.)	76.64	74.22	71.91	73.36	73.26
Book Value[Incl.RevalReserv]/Share (Rs.)	76.64	74.22	71.91	73.36	73.26
Revenue From Operations / Share (Rs.)	93.35	39.80	21.66	22.74	29.14
PBDIT / Share (Rs.)	11.87	4.47	0.28	1.78	0.06
PBIT / Share (Rs.)	10.93	3.65	-0.53	0.90	-0.82
PBT / Share (Rs.)	10.72	3.35	-1.43	0.02	-3.85
Net Profit / Share (Rs.)	8.30	2.72	-0.68	0.16	-2.95
NP After MI And SOA / Share (Rs.)	8.30	2.72	-0.68	0.16	-2.95
PBDIT Margin (%)	12.71	11.23	1.29	7.82	0.23
PBIT Margin (%)	11.70	9.17	-2.48	4.00	-2.82
PBT Margin (%)	11.48	8.42	-6.60	0.12	-13.20
Net Profit Margin (%)	8.88	6.84	-3.17	0.73	-10.13
NP After MI And SOA Margin (%)	8.88	6.84	-3.17	0.73	-10.13
Return on Networth / Equity (%)	10.82	3.66	-0.95	0.22	-4.03
Return on Capital Employeed (%)	11.44	3.81	-0.58	1.09	-0.93
Return On Assets (%)	3.46	1.26	-0.37	0.12	-2.57
Long Term Debt / Equity (X)	0.16	0.21	0.21	0.06	0.13
Total Debt / Equity (X)	0.19	0.23	0.21	0.06	0.13
Asset Turnover Ratio (%)	0.40	0.20	0.10	0.15	0.22
Current Ratio (X)	1.57	1.71	1.86	2.46	3.66
Quick Ratio (X)	0.51	0.45	0.50	0.94	1.38
Inventory Turnover Ratio (X)	0.33	0.00	0.00	0.00	0.00
Dividend Payout Ratio (NP) (%)	0.00	18.35	-116.17	178.48	-8.46
Dividend Payout Ratio (CP) (%)	0.00	14.10	615.78	28.93	-12.13
Earning Retention Ratio (%)	0.00	81.65	216.17	-78.48	108.46
Cash Earning Retention Ratio (%)	0.00	85.90	-515.78	71.07	112.13
Interest Coverage Ratio (X)	58.20	15.05	0.59	2.02	0.05
Interest Coverage Ratio (Post Tax) (X)	41.68	10.16	0.42	1.19	0.05
Enterprise Value (Cr.)	2677.04	1760.14	1432.63	1247.74	516.16
EV / Net Operating Revenue (X)	2.85	4.32	6.46	5.36	1.73
EV / EBITDA (X)	22.44	38.45	497.44	68.56	726.98
MarketCap / Net Operating Revenue (X)	2.94	4.26	6.31	5.80	1.69
Retention Ratios (%)	0.00	81.64	216.17	-78.48	108.46
Price / BV (X)	3.58	2.28	1.90	1.80	0.67
Price / Net Operating Revenue (X)	2.94	4.26	6.31	5.80	1.69
EarningsYield	0.03	0.01	-0.01	0.00	-0.05

After reviewing the key financial ratios for Ashiana Housing Ltd, here is a detailed analysis based on the latest available data and recent trends:

For FaceValue, as of Mar 24, the value is 2.00. This value is within the healthy range. There is no change compared to the previous period (Mar 23) which recorded 2.00.
For Basic EPS (Rs.), as of Mar 24, the value is 8.33. This value is within the healthy range. It has increased from 2.81 (Mar 23) to 8.33, marking an increase of 5.52.
For Diluted EPS (Rs.), as of Mar 24, the value is 8.33. This value is within the healthy range. It has increased from 2.81 (Mar 23) to 8.33, marking an increase of 5.52.
For Cash EPS (Rs.), as of Mar 24, the value is 9.24. This value is within the healthy range. It has increased from 3.55 (Mar 23) to 9.24, marking an increase of 5.69.
For Book Value[Excl.RevalReserv]/Share (Rs.), as of Mar 24, the value is 76.64. It has increased from 74.22 (Mar 23) to 76.64, marking an increase of 2.42.
For Book Value[Incl.RevalReserv]/Share (Rs.), as of Mar 24, the value is 76.64. It has increased from 74.22 (Mar 23) to 76.64, marking an increase of 2.42.
For Revenue From Operations / Share (Rs.), as of Mar 24, the value is 93.35. It has increased from 39.80 (Mar 23) to 93.35, marking an increase of 53.55.
For PBDIT / Share (Rs.), as of Mar 24, the value is 11.87. This value is within the healthy range. It has increased from 4.47 (Mar 23) to 11.87, marking an increase of 7.40.
For PBIT / Share (Rs.), as of Mar 24, the value is 10.93. This value is within the healthy range. It has increased from 3.65 (Mar 23) to 10.93, marking an increase of 7.28.
For PBT / Share (Rs.), as of Mar 24, the value is 10.72. This value is within the healthy range. It has increased from 3.35 (Mar 23) to 10.72, marking an increase of 7.37.
For Net Profit / Share (Rs.), as of Mar 24, the value is 8.30. This value is within the healthy range. It has increased from 2.72 (Mar 23) to 8.30, marking an increase of 5.58.
For NP After MI And SOA / Share (Rs.), as of Mar 24, the value is 8.30. This value is within the healthy range. It has increased from 2.72 (Mar 23) to 8.30, marking an increase of 5.58.
For PBDIT Margin (%), as of Mar 24, the value is 12.71. This value is within the healthy range. It has increased from 11.23 (Mar 23) to 12.71, marking an increase of 1.48.
For PBIT Margin (%), as of Mar 24, the value is 11.70. This value is within the healthy range. It has increased from 9.17 (Mar 23) to 11.70, marking an increase of 2.53.
For PBT Margin (%), as of Mar 24, the value is 11.48. This value is within the healthy range. It has increased from 8.42 (Mar 23) to 11.48, marking an increase of 3.06.
For Net Profit Margin (%), as of Mar 24, the value is 8.88. This value is within the healthy range. It has increased from 6.84 (Mar 23) to 8.88, marking an increase of 2.04.
For NP After MI And SOA Margin (%), as of Mar 24, the value is 8.88. This value is within the healthy range. It has increased from 6.84 (Mar 23) to 8.88, marking an increase of 2.04.
For Return on Networth / Equity (%), as of Mar 24, the value is 10.82. This value is below the healthy minimum of 15. It has increased from 3.66 (Mar 23) to 10.82, marking an increase of 7.16.
For Return on Capital Employeed (%), as of Mar 24, the value is 11.44. This value is within the healthy range. It has increased from 3.81 (Mar 23) to 11.44, marking an increase of 7.63.
For Return On Assets (%), as of Mar 24, the value is 3.46. This value is below the healthy minimum of 5. It has increased from 1.26 (Mar 23) to 3.46, marking an increase of 2.20.
For Long Term Debt / Equity (X), as of Mar 24, the value is 0.16. This value is below the healthy minimum of 0.2. It has decreased from 0.21 (Mar 23) to 0.16, marking a decrease of 0.05.
For Total Debt / Equity (X), as of Mar 24, the value is 0.19. This value is within the healthy range. It has decreased from 0.23 (Mar 23) to 0.19, marking a decrease of 0.04.
For Asset Turnover Ratio (%), as of Mar 24, the value is 0.40. It has increased from 0.20 (Mar 23) to 0.40, marking an increase of 0.20.
For Current Ratio (X), as of Mar 24, the value is 1.57. This value is within the healthy range. It has decreased from 1.71 (Mar 23) to 1.57, marking a decrease of 0.14.
For Quick Ratio (X), as of Mar 24, the value is 0.51. This value is below the healthy minimum of 1. It has increased from 0.45 (Mar 23) to 0.51, marking an increase of 0.06.
For Inventory Turnover Ratio (X), as of Mar 24, the value is 0.33. This value is below the healthy minimum of 4. It has increased from 0.00 (Mar 23) to 0.33, marking an increase of 0.33.
For Dividend Payout Ratio (NP) (%), as of Mar 24, the value is 0.00. This value is below the healthy minimum of 20. It has decreased from 18.35 (Mar 23) to 0.00, marking a decrease of 18.35.
For Dividend Payout Ratio (CP) (%), as of Mar 24, the value is 0.00. This value is below the healthy minimum of 20. It has decreased from 14.10 (Mar 23) to 0.00, marking a decrease of 14.10.
For Earning Retention Ratio (%), as of Mar 24, the value is 0.00. This value is below the healthy minimum of 40. It has decreased from 81.65 (Mar 23) to 0.00, marking a decrease of 81.65.
For Cash Earning Retention Ratio (%), as of Mar 24, the value is 0.00. This value is below the healthy minimum of 40. It has decreased from 85.90 (Mar 23) to 0.00, marking a decrease of 85.90.
For Interest Coverage Ratio (X), as of Mar 24, the value is 58.20. This value is within the healthy range. It has increased from 15.05 (Mar 23) to 58.20, marking an increase of 43.15.
For Interest Coverage Ratio (Post Tax) (X), as of Mar 24, the value is 41.68. This value is within the healthy range. It has increased from 10.16 (Mar 23) to 41.68, marking an increase of 31.52.
For Enterprise Value (Cr.), as of Mar 24, the value is 2,677.04. It has increased from 1,760.14 (Mar 23) to 2,677.04, marking an increase of 916.90.
For EV / Net Operating Revenue (X), as of Mar 24, the value is 2.85. This value is within the healthy range. It has decreased from 4.32 (Mar 23) to 2.85, marking a decrease of 1.47.
For EV / EBITDA (X), as of Mar 24, the value is 22.44. This value exceeds the healthy maximum of 15. It has decreased from 38.45 (Mar 23) to 22.44, marking a decrease of 16.01.
For MarketCap / Net Operating Revenue (X), as of Mar 24, the value is 2.94. This value is within the healthy range. It has decreased from 4.26 (Mar 23) to 2.94, marking a decrease of 1.32.
For Retention Ratios (%), as of Mar 24, the value is 0.00. This value is below the healthy minimum of 30. It has decreased from 81.64 (Mar 23) to 0.00, marking a decrease of 81.64.
For Price / BV (X), as of Mar 24, the value is 3.58. This value exceeds the healthy maximum of 3. It has increased from 2.28 (Mar 23) to 3.58, marking an increase of 1.30.
For Price / Net Operating Revenue (X), as of Mar 24, the value is 2.94. This value is within the healthy range. It has decreased from 4.26 (Mar 23) to 2.94, marking a decrease of 1.32.
For EarningsYield, as of Mar 24, the value is 0.03. This value is below the healthy minimum of 5. It has increased from 0.01 (Mar 23) to 0.03, marking an increase of 0.02.

Overall, while many metrics show healthy performance, any figures highlighted in red or significant downward trends warrant further investigation.

Profitability Ratios (%)

Liquidity Ratios

Liquidity Ratios (%)

Interest Coverage Ratios (%)

Valuation Ratios

Fair Value

Fair Value of Ashiana Housing Ltd as of April 4, 2025 is: 977.00

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.

As of April 4, 2025, Ashiana Housing Ltd is Undervalued by 233.45% compared to the current share price 293.00

Intrinsic Value of Ashiana Housing Ltd as of April 4, 2025 is: 1,514.17

Calculation basis:

Intrinsic 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 intrinsic value of the stock by analyzing its fundamental indicators along with EPS growth.

As of April 4, 2025, Ashiana Housing Ltd is Undervalued by 416.78% compared to the current share price 293.00

Last 5 Year EPS CAGR: 54.98%

*Investments are subject to market risks

Strength and Weakness

Strength	Weakness
The company has higher reserves (635.08 cr) compared to borrowings (114.85 cr), indicating strong financial stability. The company has shown consistent growth in sales (361.15 cr) and profit (41.31 cr) over the years.	The stock has a low average ROCE of 7.67%, which may not be favorable. The stock has a high average Working Capital Days of 539.08, which may not be favorable. The stock has a high average Cash Conversion Cycle of 21.08, which may not be favorable.

Stock Analysis

Considering all of the following key financial indicators, prospective investors are encouraged to conduct thorough research and seek professional guidance before considering any investment in Ashiana Housing Ltd:
1. Net Profit Margin: 8.88%
  - Net Profit Margin: This metric indicates the percentage of profit a company makes from its total revenue. A higher net profit margin is generally desirable as it reflects better profitability.
2. ROCE: 11.44% (Industry Average ROCE: 9.97%)
  - ROCE (Return on Capital Employed): ROCE measures a company's profitability and the efficiency with which its capital is employed. A higher ROCE indicates efficient use of capital.
3. ROE%: 10.82% (Industry Average ROE: 8.15%)
  - ROE (Return on Equity): ROE measures a company's profitability relative to shareholders' equity. A higher ROE indicates efficient use of shareholders' funds.
4. Interest Coverage Ratio (Post Tax): 41.68
  - Interest Coverage Ratio: The interest coverage ratio measures a company's ability to cover its interest payments on outstanding debt. A ratio greater than 2 is generally considered healthy as it indicates the company can meet its interest obligations comfortably.
5. Quick Ratio: 0.51
  - Quick Ratio: The quick ratio assesses a company's ability to cover its short-term liabilities with its most liquid assets. A ratio higher than 1 suggests the company can meet its short-term obligations without relying heavily on inventory.
6. Stock P/E: 156 (Industry average Stock P/E: 42.04)
  - Stock P/E (Price-to-Earnings) Ratio: The P/E ratio compares a company's current share price to its earnings per share. A lower P/E ratio relative to industry peers or historical values may indicate that the stock is undervalued.
7. Total Debt / Equity: 0.19
  - Total Debt / Equity: This ratio measures a company's financial leverage by comparing its total debt to its total equity. A lower ratio indicates lower financial risk and greater financial stability.
The current analysis is available for review. It's important to conduct thorough research and consider consulting with financial professionals before making any investment decisions.
Stock Rating:

About the Company - Qualitative Analysis

Ashiana Housing Ltd. is a Public Limited Listed company incorporated on 25/06/1986 and has its registered office in the State of West Bengal, India. Company's Corporate Identification Number(CIN) is L70109WB1986PLC040864 and registration number is 040864. Currently Company is involved in the business activities of Construction of buildings. Company's Total Operating Revenue is Rs. 878.13 Cr. and Equity Capital is Rs. 20.11 Cr. for the Year ended 31/03/2024.

INDUSTRY	ADDRESS	CONTACT
Realty	5F Everest, 46/C, Chowringhee Road, Kolkata West Bengal 700071	investorrelations@ashianahousing.com http://www.ashianahousing.com

Management
Name	Position Held
Mr. Vishal Gupta	Managing Director
Mr. Ankur Gupta	Joint Managing Director
Mr. Varun Gupta	Whole Time Director
Mr. Narayan Anand	Independent Director
Mr. Abhishek Dalmia	Independent Director
Ms. Sonal Mattoo	Independent Director
Mr. Piyul Mukherjee	Independent Director
Mr. Suraj Krishna Moraje	Independent Director

FAQ

What is the intrinsic value of Ashiana Housing Ltd?

Ashiana Housing Ltd's intrinsic value (as of 04 April 2025) is ₹977.00 — 233.45% higher the current market price of 293.00, indicating undervalued. Calculated using the PE ratio method, this valuation considers the company's 2,947 Cr. market cap, FY2025-2026 high/low of ₹469/278, reserves of 737 Cr, and liabilities of 2,987 Cr.

What is the Market Cap of Ashiana Housing Ltd?

The Market Cap of Ashiana Housing Ltd is 2,947 Cr..

What is the current Stock Price of Ashiana Housing Ltd as on 04 April 2025?

The current stock price of Ashiana Housing Ltd as on 04 April 2025 is 293.

What is the High / Low of Ashiana Housing Ltd stocks in FY 2025-2026?

In FY 2025-2026, the High / Low of Ashiana Housing Ltd stocks is ₹469/278.

What is the Stock P/E of Ashiana Housing Ltd?

The Stock P/E of Ashiana Housing Ltd is 156.

What is the Book Value of Ashiana Housing Ltd?

The Book Value of Ashiana Housing Ltd is 74.9.

What is the Dividend Yield of Ashiana Housing Ltd?

The Dividend Yield of Ashiana Housing Ltd is 0.50 %.

What is the ROCE of Ashiana Housing Ltd?

The ROCE of Ashiana Housing Ltd is 11.3 %.

What is the ROE of Ashiana Housing Ltd?

The ROE of Ashiana Housing Ltd is 10.4 %.

What is the Face Value of Ashiana Housing Ltd?

The Face Value of Ashiana Housing Ltd is 2.00.