Loading...
Welspun India Limited manufactures and sells home textile products in India and internationally. The last earnings update was 15 days ago. More info.
7 Day | 30 Day | 90 Day | 1 Year | 3 Year | 5 Year | |
---|---|---|---|---|---|---|
Welspun India (514162) | -7.2% | -21.4% | -24.3% | -27.1% | -45.6% | 381% |
IN Luxury | -2.5% | -2% | -3.9% | -8.9% | 47.6% | 187.3% |
IN Market | -2.1% | -4.5% | -3.5% | -8.6% | 40.3% | 78.7% |
Is Welspun India undervalued based on future cash flows and its price relative to the stock market?
Below are the data sources, inputs and calculation used to determine the intrinsic value for Welspun India.
Data Point | Source | Value |
---|---|---|
Valuation Model | 2 Stage Free Cash Flow to Equity | |
Levered Free Cash Flow | Average of 2 Analyst Estimates (S&P Global) | See below |
Discount Rate (Cost of Equity) | See below | 14% |
Perpetual Growth Rate | 10-Year IN Government Bond Rate | 7.6% |
An important part of a discounted cash flow is the discount rate, below we explain how it has been calculated.
Data Point | Calculation/ Source | Result |
---|---|---|
Risk-Free Rate | 10-Year IN Govt Bond Rate | 7.6% |
Equity Risk Premium | S&P Global | 7.5% |
Luxury Unlevered Beta | Simply Wall St/ S&P Global | 0.57 |
Re-levered Beta | = Unlevered beta (1 + (1- tax rate) (Debt/Equity))
= 0.574 (1 + (1- 35%) (76.57%)) |
0.86 |
Levered Beta | Levered Beta limited to 0.8 to 2.0 (practical range for a stable firm) |
0.86 |
Discount Rate/ Cost of Equity |
= Cost of Equity = Risk Free Rate + (Levered Beta * Equity Risk Premium)
= 7.55% + (0.86 * 7.45%) |
13.95% |
Discounted Cash Flow Calculation for BSE:514162 using 2 Stage Free Cash Flow to Equity Model
The calculations below outline how an intrinsic value for Welspun India is arrived at by discounting future cash flows to their present value using the 2 stage method. We use analyst's estimates of cash flows going forward 5 years for the 1st stage, the 2nd stage assumes the company grows at a stable rate into perpetuity.
2019 | 2020 | 2021 | 2022 | 2023 | |
Levered FCF (INR, Millions) | 3,999.00 | 4,017.00 | 2,224.00 | 2,389.23 | 2,566.73 |
Source | Analyst x1 | Analyst x1 | Analyst x1 | Est @ 7.43% | Est @ 7.43% |
Present Value Discounted (@ 13.95%) |
3,509.28 | 3,093.40 | 1,502.92 | 1,416.86 | 1,335.72 |
Present value of next 5 years cash flows | ₹10,858.18 |
Calculation | Result | |
---|---|---|
Terminal Value |
= FCF2023
× (1 + g) ÷ (Discount Rate – g)
= ₹2,566.73 × (1 + 7.55%) ÷ (13.95% – 7.55%) |
₹43,100.23 |
Present Value of Terminal Value |
= Terminal Value ÷ (1 + r)5
= ₹43,100.23 ÷ (1 + 13.95%)5 |
₹22,429.25 |
Calculation | Result | |
---|---|---|
Total Equity Value |
= Present value of next 5 years cash flows +
Terminal Value
= ₹10,858.18 + ₹22,429.25 |
₹33,287.43 |
Equity Value per Share (INR) |
= Total value / Shares Outstanding
= ₹33,287.43 / 1,004.73 |
₹33.13 |
Calculation | Result | |
---|---|---|
Value per share (INR) | From above. | ₹33.13 |
Current discount | Discount to share price of
₹47.40
= -1 x (₹47.40 - ₹33.13) / ₹33.13 |
-43.1% |
Learn more about our DCF calculations in Simply Wall St’s analysis model .
Data Point | Source | Value |
---|---|---|
Earnings Per Share * | Company Filings (2018-12-31) in INR | ₹3.74 |
BSE:514162 Share Price ** | BSE (2019-02-19) in INR | ₹47.4 |
India Luxury Industry PE Ratio | Median Figure of 237 Publicly-Listed Luxury Companies | 11.54x |
India Market PE Ratio | Median Figure of 2,715 Publicly-Listed Companies | 15.16x |
* Trailing twelve months (TTM) annual GAAP earnings per share excluding extraordinary items.
** Primary Listing of Welspun India.
Calculation | Outcome | |
---|---|---|
PE Ratio | = BSE:514162 Share Price ÷ EPS (both in INR) = 47.4 ÷ 3.74 |
12.67x |
Learn more about our ratios and growth rates in Simply Wall St’s analysis model >
Data Point | Source | Value |
---|---|---|
PE Ratio | See PE Ratio Section | 12.67x |
Net Income Annual Growth Rate | See Future Growth Section. Line of Best Fit* through Consensus Estimate Earnings of 2 Analysts |
26.6%per year |
India Luxury Industry PEG Ratio | Median Figure of 27 Publicly-Listed Luxury Companies | 1.09x |
India Market PEG Ratio | Median Figure of 606 Publicly-Listed Companies | 1.1x |
*Line of best fit is calculated by linear regression .
Calculation | Outcome | |
---|---|---|
PEG Ratio | = PE Ratio ÷ Net Income Annual Growth Rate = 12.67x ÷ 26.6% |
0.48x |
Learn more about our ratios and growth rates in Simply Wall St’s analysis model >
Data Point | Source | Value |
---|---|---|
Book Value per Share | Company Filings (2018-12-31) in INR | ₹26.21 |
BSE:514162 Share Price * | BSE (2019-02-19) in INR | ₹47.4 |
India Luxury Industry PB Ratio | Median Figure of 307 Publicly-Listed Luxury Companies | 0.69x |
India Market PB Ratio | Median Figure of 3,587 Publicly-Listed Companies | 1.04x |
Calculation | Outcome | |
---|---|---|
PB Ratio | = BSE:514162 Share Price ÷ Book Value per Share (both in INR) = 47.4 ÷ 26.21 |
1.81x |
* Primary Listing of Welspun India.
Learn more about our ratios and growth rates in Simply Wall St’s analysis model >
Data Point | Source | Value (per year) |
---|---|---|
BSE:514162 Future Earnings Growth Rate | Line of Best Fit* through Consensus Estimate Earnings of 2 Analysts | 26.6% |
BSE:514162 Future Revenue Growth Rate | Line of Best Fit* through Consensus Estimate Revenue of 2 Analysts | 13.9% |
India Luxury Industry Earnings Growth Rate | Market Cap Weighted Average | 18.3% |
India Luxury Industry Revenue Growth Rate | Market Cap Weighted Average | 15% |
India Market Earnings Growth Rate | Market Cap Weighted Average | 18.5% |
India Market Revenue Growth Rate | Market Cap Weighted Average | 11.7% |
*Line of best fit is calculated by linear regression .
Industry and Market average data is calculated daily.
Learn more about our growth rate calculations in Simply Wall St’s analysis model.
Data Point | Source | Value |
---|---|---|
Past Financials | Company Filings (1 month ago) | See Below |
Future Estimates | Average of up to 2 Analyst Estimates (S&P Global) | See Below |
Date (Data in INR Millions) | Revenue | Cash Flow | Net Income * | Avg. No. Analysts |
---|---|---|---|---|
2021-03-31 | 88,329 | 7,224 | 6,739 | 1 |
2020-03-31 | 74,816 | 9,617 | 5,549 | 2 |
2019-03-31 | 66,462 | 13,599 | 4,119 | 1 |
Date (Data in INR Millions) | Revenue | Cash Flow | Net Income * |
---|---|---|---|
2018-12-31 | 64,757 | 3,758 | |
2018-09-30 | 62,333 | 4,061 | |
2018-06-30 | 60,604 | 3,879 | |
2018-03-31 | 60,506 | 5,450 | 3,850 |
2017-12-31 | 59,407 | 4,522 | |
2017-09-30 | 60,436 | 5,241 | |
2017-06-30 | 65,874 | 2,800 | |
2017-03-31 | 66,385 | 8,322 | 3,576 |
2016-12-31 | 65,558 | 3,659 | |
2016-09-30 | 65,001 | 3,948 | |
2016-06-30 | 61,790 | 7,217 | |
2016-03-31 | 57,470 | 13,280 | 7,365 |
*GAAP earnings excluding extraordinary items.
Data Point | Source | Value |
---|---|---|
Past Financials | Company Filings (1 month ago) | See Below |
Future Estimates | Average of up to 2 Analyst Estimates (S&P Global) | See Below |
All data from Welspun India Company Filings, last reported 1 month ago, and in Trailing twelve months (TTM) annual period rather than quarterly.
Date (Data in INR Millions) | EPS * | EPS High Estimate | EPS Low Estimate | Avg. No. Analysts |
---|---|---|---|---|
2021-03-31 | 6.70 | 6.70 | 6.70 | 1.00 |
2020-03-31 | 5.55 | 5.90 | 5.19 | 2.00 |
2019-03-31 | 4.10 | 4.10 | 4.10 | 1.00 |
Date (Data in INR Millions) | EPS * |
---|---|
2018-12-31 | 3.74 |
2018-09-30 | 4.04 |
2018-06-30 | 3.86 |
2018-03-31 | 3.83 |
2017-12-31 | 4.50 |
2017-09-30 | 5.22 |
2017-06-30 | 2.79 |
2017-03-31 | 3.56 |
2016-12-31 | 3.65 |
2016-09-30 | 3.93 |
2016-06-30 | 7.19 |
2016-03-31 | 7.33 |
*GAAP earnings excluding extraordinary items.
How has Welspun India performed over the past 5 years?
All data from Welspun India Company Filings, last reported 1 month ago, and in Trailing twelve months (TTM) annual period rather than quarterly.
Date (Data in INR Millions) | Revenue | Net Income * | G+A Expenses | R&D Expenses |
---|---|---|---|---|
2018-12-31 | 64,757.05 | 3,757.57 | 8,533.79 | |
2018-09-30 | 62,333.25 | 4,060.67 | 8,398.49 | |
2018-06-30 | 60,603.55 | 3,879.07 | 8,315.69 | |
2018-03-31 | 60,506.25 | 3,849.67 | 8,233.79 | |
2017-12-31 | 59,406.78 | 4,521.82 | 8,074.46 | |
2017-09-30 | 60,435.78 | 5,241.42 | 8,030.86 | |
2017-06-30 | 65,873.70 | 2,799.80 | 6,493.60 | |
2017-03-31 | 66,385.45 | 3,575.62 | 7,706.56 | |
2016-12-31 | 65,558.15 | 3,659.35 | 7,225.68 | |
2016-09-30 | 65,000.95 | 3,948.15 | 7,003.38 | |
2016-06-30 | 61,789.60 | 7,217.10 | 5,664.70 | |
2016-03-31 | 57,470.19 | 7,365.00 | 6,206.49 | |
2015-12-31 | 57,175.71 | 6,709.60 | 8,832.69 | 65.39 |
2015-09-30 | 55,731.01 | 6,404.40 | 8,543.69 | 65.39 |
2015-06-30 | 49,341.01 | 5,979.70 | 4,694.73 | |
2015-03-31 | 53,031.51 | 5,397.90 | 5,290.47 | |
2014-12-31 | 51,327.61 | 4,601.18 | 7,300.52 | 58.70 |
2014-09-30 | 49,095.29 | 4,260.38 | 7,041.14 | 58.70 |
2014-06-30 | 46,581.60 | 1,071.64 | 3,682.92 | |
2014-03-31 | 43,736.65 | 920.22 | 6,446.62 | 58.70 |
2013-12-31 | 40,021.88 | 735.07 | 5,524.35 | 47.91 |
2013-09-30 | 41,221.11 | 406.65 | 5,829.96 | 47.91 |
2013-06-30 | 37,912.96 | 2,770.00 | 3,039.53 | |
2013-03-31 | 36,481.12 | 2,247.31 | 5,203.89 | 47.91 |
2012-12-31 | 41,127.95 | 908.01 | 7,071.26 | 54.05 |
2012-09-30 | 35,831.46 | 322.85 | 3,168.94 | |
2012-06-30 | 34,443.58 | 61.71 | 3,106.16 | |
2012-03-31 | 32,205.46 | -133.72 | 5,658.45 | 54.05 |
*GAAP earnings excluding extraordinary items.
How is Welspun India's financial health and their level of debt?
All data from Welspun India Company Filings, last reported 1 month ago.
Date (Data in INR Millions) | Total Equity | Total Debt | Cash & Short Term Investments |
---|---|---|---|
2018-12-31 | 26,956.40 | 36,079.70 | 9,090.70 |
2018-09-30 | 26,956.40 | 36,079.70 | 9,090.70 |
2018-06-30 | 26,523.72 | 32,807.11 | 2,243.22 |
2018-03-31 | 26,523.72 | 32,807.11 | 2,243.22 |
2017-12-31 | 25,288.80 | 33,119.60 | 6,667.90 |
2017-09-30 | 25,288.80 | 33,119.60 | 6,667.90 |
2017-06-30 | 24,326.80 | 31,881.00 | 5,091.40 |
2017-03-31 | 24,326.75 | 33,113.70 | 2,720.92 |
2016-12-31 | 20,809.00 | 31,763.40 | 9,116.50 |
2016-09-30 | 20,809.00 | 31,763.40 | 9,116.50 |
2016-06-30 | 20,379.50 | 25,608.70 | 1,776.50 |
2016-03-31 | 20,112.45 | 32,481.55 | 1,415.98 |
2015-12-31 | 17,661.40 | 26,719.50 | 5,395.30 |
2015-09-30 | 17,661.40 | 26,719.50 | 5,395.30 |
2015-06-30 | 14,696.69 | 25,980.47 | 4,657.24 |
2015-03-31 | 14,696.69 | 30,880.81 | 4,657.24 |
2014-12-31 | 13,097.79 | 25,386.72 | 3,171.20 |
2014-09-30 | 13,097.79 | 25,386.72 | 3,171.20 |
2014-06-30 | 11,412.94 | 28,143.54 | 2,973.52 |
2014-03-31 | 11,412.95 | 30,622.11 | 2,973.52 |
2013-12-31 | 7,719.89 | 23,142.56 | 2,370.45 |
2013-09-30 | 7,719.89 | 23,142.56 | 2,370.45 |
2013-06-30 | 10,151.72 | 21,200.31 | 2,118.33 |
2013-03-31 | 10,151.72 | 20,410.12 | 2,118.33 |
2012-12-31 | 8,612.72 | 15,830.18 | 1,867.05 |
2012-09-30 | 8,612.72 | 15,830.18 | 1,867.05 |
2012-06-30 | |||
2012-03-31 | 7,678.02 | 19,783.06 | 2,678.88 |
What is Welspun India's current dividend yield, its reliability and sustainability?
Data Point | Source | Value |
---|---|---|
Past Annualized Dividend Yield | S&P Global Market Data | See Below |
Past Dividends per Share | Company Filings/ Annualized Dividend Payments | See Below |
Future Dividends per Share Estimates | Average of up to 2 Analyst Estimates (S&P Global) | See Below |
India Luxury Industry Average Dividend Yield | Market Cap Weighted Average of 109 Stocks | 0.7% |
India Market Average Dividend Yield | Market Cap Weighted Average of 1397 Stocks | 1.4% |
India Minimum Threshold Dividend Yield | 10th Percentile | 0.3% |
India Bottom 25% Dividend Yield | 25th Percentile | 0.6% |
India Top 25% Dividend Yield | 75th Percentile | 2.1% |
Industry and Market average data is calculated daily.
Note all dividend per share amounts are annualized and not quarterly or other period.
Date (Data in ₹) | Dividend per Share (annual) | Avg. No. Analysts |
---|---|---|
2021-03-31 | 1.60 | 1.00 |
2020-03-31 | 1.20 | 1.00 |
2019-03-31 | 1.00 | 1.00 |
Date (Data in ₹) | Dividend per share (annual) | Avg. Yield (%) |
---|---|---|
2018-05-16 | 0.650 | 1.091 |
2017-08-29 | 0.650 | 0.977 |
2016-07-28 | 1.300 | 1.746 |
2016-03-10 | 0.710 | 0.701 |
2015-10-20 | 1.400 | 1.698 |
2015-08-05 | 1.500 | 1.854 |
2015-01-29 | 0.600 | 1.292 |
2014-11-05 | 0.600 | 1.726 |
2014-09-25 | 0.300 | 1.020 |
2013-09-24 | 0.400 | 3.871 |
2013-02-07 | 0.400 | 6.503 |
2012-11-08 | 0.400 | 6.087 |
2011-05-30 | 0.000 | 0.000 |
2010-05-13 | 0.100 | 1.712 |
2010-05-12 | 0.100 | 1.117 |
Learn more about our ratios and growth rates in Simply Wall St’s analysis model >
Mrs. Dipali Goenka has been a Joint-Managing Director of Welspun India Ltd. since April 2002 and has been its Chief Executive Officer since April 2002. Mrs. Goenka serves as Managing Director at Welspun Global Brands Limited since January 4, 2011. She has been an Executive Director of Welspun India Ltd. since April 1, 2013. She serves as a Director of Welspun Retail Limited. She served as a Director of Welspun Global Brands Limited since April 1, 2011.
Average tenure and age of the Welspun India management team in years:
Average tenure and age of the Welspun India board of directors in years:
Welspun India Limited manufactures and sells home textile products in India and internationally. The company offers towels, including wash cloths, face towels, hand towels, bath towels, bath sheets, terry, and beach towels; bath rugs/mats, such as cotton, nylon, polyethylene terephthalate, and polyester filament-based Drylon and Resilon yarn rugs; area and bi-component fibre rugs; bathrobes; and bed sheets and carpets. It also provides utility bedding products comprising pillow fillers, mattress pads, and down-alternative filled comforters; and fashion bedding products for the bedroom. The company offers its products under the Christy, Kingsley Home, Crowning Touch, Spaces, Welhome, Amy Butler, and Spun brands. In addition, it generates power. The company was formerly known as Welspun Winilon Silk Mills Pvt. Ltd. and changed its name to Welspun India Limited in 1995. The company was founded in 1985 and is based in Mumbai, India. Welspun India Limited is a subsidiary of Prasert Multiventure Private Limited.
Name: | Welspun India Limited |
514162 | |
Exchange: | BSE |
Founded: | 1985 |
₹47,121,609,535 | |
1,004,725,150 | |
Website: | http://www.welspunindia.com |
Address: |
Welspun India Limited Welspun House, 6th Floor, Mumbai, Maharashtra, 400013, India |
Exchange Symbol | Ticker Symbol | Security | Exchange | Country | Currency | Listed on | |
---|---|---|---|---|---|---|---|
BSE | 514162 | Equity Shares | Mumbai Stock Exchange | IN | INR | 02. Jan 1996 | |
NSEI | WELSPUNIND | Equity Shares | National Stock Exchange of India | IN | INR | 02. Jan 1996 |
Textiles | |
Consumer Durables |
Area | Date (UTC time) |
---|---|
Company Analysis updated: | 2019/02/19 12:40 |
End of day share price update: | 2019/02/19 00:00 |
Last estimates confirmation: | 2019/02/05 |
Last earnings filing: | 2019/02/04 |
Last earnings reported: | 2018/12/31 |
Last annual earnings reported: | 2018/03/31 |
All dates and times in UTC. All financial data provided by Standard & Poor’s Capital IQ.
Unless specified all financial data is based on a yearly period but updated quarterly. This is known as Trailing Twelve Month (TTM) or Last Twelve Month (LTM) Data. Learn more here.