Fundamental Analysis of Future Market Networks Ltd

About the Company - Future Retail Ltd

Future Retail Ltd. is a Public Limited Listed company incorporated on 07/02/2007 and has its registered office in the State of Maharashtra, India. Company’s Corporate Identification Number(CIN) is L51909MH2007PLC268269 and registration number is 268269. Currently Company is involved in the business activities of Retail trade, except of motor vehicles and motorcycles. Company’s Total Operating Revenue is Rs. 6261.04 Cr. and Equity Capital is Rs. 108.46 Cr. for the Year ended 31/03/2021.

INDUSTRY	ADDRESS	CONTACT
Retail - Departmental Stores	Knowledge House, Shyam Nagar, Mumbai Maharashtra 400060	investorrelations@futureretail.in https://www.futureretail.in

Management
Name	Position Held
Mr. Kishore Biyani	Executive Chairman
Mr. Rakesh Biyani	Managing Director
Mr. Rahul Garg	Non Executive Director
Mr. Ravindra Dhariwal	Independent Director
Ms. Gagan Singh	Independent Director
Mr. Jacob Mathew	Independent Director

Basic Stock Data of Future Retail Ltd

Last Updated: July 26, 2024, 11:51 am

Market Cap	137 Cr.
Current Price	2.53
High / Low	3.86/1.90
Stock P/E
Book Value	20.6
Dividend Yield	0.00 %
ROCE	13.7 %
ROE	134 %
Face Value	2.00
PEG Ratio	0.00

Data Source: screener.in

Future Retail Ltd Quarterly Results

Month	Dec 2018	Mar 2019	Jun 2019	Sep 2019	Dec 2019	Mar 2020	Jun 2020	Sep 2020	Dec 2020	Mar 2021	Jun 2021	Sep 2021	Dec 2021
Sales	5,301	5,397	5,149	5,394	5,130	4,445	1,355	1,417	1,486	2,002	1,406	2,347	2,786
Expenses	5,023	5,106	4,517	4,719	4,433	4,465	1,498	1,432	1,604	2,293	1,801	2,705	3,131
Operating Profit	278	291	633	675	696	-20	-143	-15	-117	-291	-395	-359	-345
OPM %	5%	5%	12%	13%	14%	-0%	-11%	-1%	-8%	-15%	-28%	-15%	-12%
Other Income	5	6	9	21	15	39	92	47	27	10	1	2	5
Interest	56	61	239	263	269	222	271	355	397	420	350	360	340
Depreciation	25	32	240	261	271	269	231	363	354	380	404	403	399
Profit before tax	201	203	162	171	171	-471	-553	-686	-841	-1,080	-1,147	-1,120	-1,078
Tax %	0%	0%	0%	0%	0%	0%	0%	0%	0%	-2%	0%	0%	0%
Net Profit	201	203	162	171	171	-471	-553	-686	-841	-1,100	-1,147	-1,120	-1,078
EPS in Rs	4.01	4.04	3.23	3.41	3.40	-8.92	-10.20	-12.64	-15.51	-20.29	-21.16	-20.65	-19.88

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

Future Retail Ltd Quarterly Chart

Future Retail Ltd Profit & Loss

Last Updated: July 10, 2024, 5:06 pm

Month	Dec 2012	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	TTM
Sales	1,578	2,343	1,779	6,845	17,075	18,478	20,165	20,118	6,261	8,541
Expenses	2,065	2,931	2,148	6,762	16,494	17,644	19,119	18,041	6,814	9,931
Operating Profit	-487	-588	-368	83	581	834	1,045	2,077	-553	-1,390
OPM %	-31%	-25%	-21%	1%	3%	5%	5%	10%	-9%	-16%
Other Income	4	405	54	18	24	-594	12	-9	164	19
Interest	18	71	20	50	204	175	224	993	1,442	1,469
Depreciation	37	61	44	37	33	53	101	1,041	1,328	1,585
Profit before tax	-538	-315	-379	15	368	11	733	34	-3,160	-4,425
Tax %	0%	0%	0%	0%	0%	0%	0%	0%	-1%
Net Profit	-538	-315	-379	15	368	11	733	34	-3,180	-4,445
EPS in Rs	-10.10	-2.25	-2.71	0.09	7.81	0.23	14.58	0.64	-58.64	-81.98
Dividend Payout %	0%	0%	0%	0%	0%	0%	0%	0%	0%

Future Retail Ltd Profit & Loss Yearly Chart

Future Retail Ltd Growth

Compounded Sales Growth
10 Years:	%
5 Years:	-2%
3 Years:	-30%
TTM:	-2%

Compounded Profit Growth
10 Years:	%
5 Years:	%
3 Years:	%
TTM:	-74%

Stock Price CAGR
10 Years:	%
5 Years:	-64%
3 Years:	-66%
1 Year:	-31%

Return on Equity
10 Years:	%
5 Years:	-9%
3 Years:	-24%
Last Year:	-134%

Last Updated: July 23, 2024, 5:45 pm

Future Retail Ltd Balance Sheet

Last Updated: July 10, 2024, 5:06 pm

Month	Dec 2012	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	Sep 2021
Equity Capital	533	1,399	1,399	9	94	100	101	105	108	108
Reserves	-1,522	-1,441	-1,687	1,865	2,459	2,996	3,751	3,427	1,091	-1,226
Borrowings	627	183	390	1,122	1,079	1,286	2,657	8,889	11,196	13,811
Other Liabilities	858	377	356	2,589	3,305	3,812	4,019	8,857	6,491	4,915
Total Liabilities	496	517	458	5,585	6,938	8,194	10,528	21,279	18,885	17,608
Fixed Assets	184	143	135	261	554	1,019	1,441	3,372	6,842	6,033
CWIP	39	47	43	0	12	34	190	4,096	74	77
Investments	0	0	0	0	0	0	104	114	114	114
Other Assets	273	327	280	5,325	6,372	7,142	8,793	13,697	11,855	11,383
Total Assets	496	517	458	5,585	6,938	8,194	10,528	21,279	18,885	17,608

Future Retail Ltd Reserves and Borrowings Chart

Future Retail Ltd Cash Flow

Month	Dec 2012	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021
Cash from Operating Activity	-136	-704	-284	262	197	632	-302	-1,837	-155
Cash from Investing Activity	-81	-61	-50	-170	-70	-455	-774	-4,420	-66
Cash from Financing Activity	236	750	320	-11	-88	-130	1,106	6,139	166
Net Cash Flow	19	-15	-14	81	39	47	30	-118	-55

Future Retail Ltd Financial Efficiency Indicators

Month	Dec 2012	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021
Debtor Days	0	0	0	6	5	5	6	12	24
Inventory Days	37	37	50	238	106	117	125	128	292
Days Payable	161	26	39	159	79	91	89	134	300
Cash Conversion Cycle	-123	11	12	85	32	31	42	6	15
Working Capital Days	-124	5	1	125	59	56	71	92	236
ROCE %			-283%	4%	17%	20%	18%	12%	-14%

Future Retail Ltd Financial Efficiency Indicators Chart

Future Retail Ltd Share Holding Pattern

Month	Jun 2019	Sep 2019	Dec 2019	Mar 2020	Jun 2020	Sep 2020	Dec 2020	Mar 2021	Jun 2021	Sep 2021	Dec 2021	Mar 2022
Promoters	47.02%	47.02%	47.02%	40.31%	41.73%	33.86%	28.00%	20.56%	19.86%	19.86%	18.24%	14.31%
FIIs	13.66%	12.90%	12.60%	12.00%	10.98%	4.39%	2.91%	2.60%	2.91%	2.97%	2.85%	2.60%
DIIs	15.58%	15.20%	14.15%	12.91%	11.09%	6.46%	6.06%	6.08%	6.07%	6.07%	7.21%	6.61%
Public	23.74%	24.88%	26.24%	34.78%	36.20%	55.29%	63.03%	70.76%	71.16%	71.10%	71.70%	76.48%
No. of Shareholders	53,717	53,115	53,906	59,516	1,21,760	4,05,620	4,08,445	4,04,913	4,12,774	4,02,328	4,02,005	4,12,430

Future Retail Ltd Shareholding Pattern Chart

No. of Future Retail Ltd Shareholders

This stock is not held by any mutual fund

Future Retail Ltd ROCE Trend

Future Retail Ltd EPS Trend

Future Retail Ltd Key Financial Ratios

Month	Mar 21	Mar 20	Mar 19
FaceValue	2.00	2.00	2.00
Basic EPS (Rs.)	-59.03	0.23	14.47
Diluted EPS (Rs.)	-59.03	0.22	14.47
Cash EPS (Rs.)	-33.32	21.12	16.54
Book Value[Excl.RevalReserv]/Share (Rs.)	20.17	79.32	76.53
Book Value[Incl.RevalReserv]/Share (Rs.)	20.17	79.32	76.53
Revenue From Operations / Share (Rs.)	116.24	385.51	404.55
PBDIT / Share (Rs.)	-5.80	40.62	21.08
PBIT / Share (Rs.)	-31.30	19.79	19.01
PBT / Share (Rs.)	-58.43	0.33	14.47
Net Profit / Share (Rs.)	-58.81	0.28	14.47
NP After MI And SOA / Share (Rs.)	-58.81	0.21	14.47
PBDIT Margin (%)	-4.99	10.53	5.21
PBIT Margin (%)	-26.92	5.13	4.69
PBT Margin (%)	-50.26	0.08	3.57
Net Profit Margin (%)	-50.59	0.07	3.57
NP After MI And SOA Margin (%)	-50.59	0.05	3.57
Return on Networth / Equity (%)	-291.61	0.27	18.90
Return on Capital Employeed (%)	-25.83	9.88	21.57
Return On Assets (%)	-16.76	0.05	6.86
Long Term Debt / Equity (X)	4.01	1.04	0.09
Total Debt / Equity (X)	9.90	2.09	0.66
Asset Turnover Ratio (%)	0.30	1.26	0.00
Current Ratio (X)	0.80	1.07	1.33
Quick Ratio (X)	0.48	0.58	0.50
Interest Coverage Ratio (X)	-0.21	2.09	4.64
Interest Coverage Ratio (Post Tax) (X)	-1.17	1.01	4.19
Enterprise Value (Cr.)	13071.82	12759.74	25096.38
EV / Net Operating Revenue (X)	2.07	0.62	1.23
EV / EBITDA (X)	-41.54	5.96	23.69
MarketCap / Net Operating Revenue (X)	0.36	0.20	1.12
Price / BV (X)	2.12	0.99	5.93
Price / Net Operating Revenue (X)	0.36	0.20	1.12
EarningsYield	-1.38	0.00	0.03

Future Retail Ltd Profitability Ratios (%)

Future Retail Ltd Liquidity Ratios

Future Retail Ltd Liquidity Ratios (%)

Future Retail Ltd Interest Coverage Ratios (%)

Future Retail Ltd Valuation Ratios

Fair Value

Fair Value: 422.34

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: 16,593.33% compared to the current price 2.53

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

Intrinsic Value: 174.43

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: 6,794.58% compared to the current price 2.53

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

Last 5 Year EPS CAGR: -58.70%

*Investments are subject to market risks

Strength and Weakness of Future Retail Ltd Stock

Strength	Weakness
	The stock has a low average ROCE of -25.11%, which may not be favorable. The stock has a high average Working Capital Days of 57.89, which may not be favorable. The stock has a high average Cash Conversion Cycle of 12.33, which may not be favorable. The company has higher borrowings (4,124.00) compared to reserves (971.30), which may suggest financial risk. The company has not shown consistent growth in sales (9.90) and profit (-7.80).

Strength

Weakness

The stock has a low average ROCE of -25.11%, which may not be favorable.
The stock has a high average Working Capital Days of 57.89, which may not be favorable.
The stock has a high average Cash Conversion Cycle of 12.33, which may not be favorable.
The company has higher borrowings (4,124.00) compared to reserves (971.30), which may suggest financial risk.
The company has not shown consistent growth in sales (9.90) and profit (-7.80).

FAQ

What is the latest fair value of Future Market Networks Ltd?

The latest fair value of Future Market Networks Ltd is ₹422.34.

What is the Market Cap of Future Market Networks Ltd?

The Market Cap of Future Market Networks Ltd is 137 Cr..

What is the current Stock Price of Future Market Networks Ltd as on 27 July 2024?

The current stock price of Future Market Networks Ltd as on 27 July 2024 is 2.53.

What is the High / Low of Future Market Networks Ltd stocks in FY 2024?

In FY 2024, the High / Low of Future Market Networks Ltd stocks is 3.86/1.90.

What is the Stock P/E of Future Market Networks Ltd?

The Stock P/E of Future Market Networks Ltd is .

What is the Book Value of Future Market Networks Ltd?

The Book Value of Future Market Networks Ltd is 20.6.

What is the Dividend Yield of Future Market Networks Ltd?

The Dividend Yield of Future Market Networks Ltd is 0.00 %.

What is the ROCE of Future Market Networks Ltd?

The ROCE of Future Market Networks Ltd is 13.7 %.

What is the ROE of Future Market Networks Ltd?

The ROE of Future Market Networks Ltd is 134 %.

What is the Face Value of Future Market Networks Ltd?

The Face Value of Future Market Networks Ltd is 2.00.