November 17, 2014 Result Update CMP : INR 461 Rating : Buy Target : INR 784 Raymond Ltd. KEY DATA Market Cap (INR bn) 28.3 Market Cap (USD mn) 463.9 52 WK High / Low 518 / 255 Avg Daily Volume (NSE) 44877 Face Value (INR) 10 BSE Sensex 27940 Nifty 8357 BSE Code 500330 NSE Code RAYMOND Reuters Code RYMD.BO Bloomberg Code Shareholding % RW IN 2Q 1Q 4Q Promoter 40.20 40.20 39.89 Indian 40.20 40.20 39.89 Public 58.48 58.46 58.77 Institutions 22.22 24.69 24.61 FII 8.91 9.98 9.15 DII 13.31 14.71 15.46 Non Institutions 36.26 33.77 34.16 Bodies Corporate 8.40 8.10 7.58 Custodians 1.32 1.34 1.34 Performance Chart Is the tide turning around for Raymond limited (RYMD)? We believe it is! After a patchy performance off late RYMD has come up with a decent set of numbers in Q2FY15. This alone doesn't make us bullish, but it stems from the fact that the bookings this season are up 18-20% Y-o-Y while the management has given a more optimistic outlook this time than a more cautious one in the previous quarter and not to forget the price of key raw materials for RYMD, Cotton, Wool and Poly Viscose have declined significantly in Q3FY15 (till date) and trend is expected to continue. The company's continued push for top line growth led RYMD to post sales of Rs 14.61bn in Q2FY15, up 19% Y-o-Y but PAT declined 27% Y-o-Y to Rs 681mn. EBITDA margin contracted 370 bps Y-o-Y to 11.8% due to growth related investment coupled with products mix issues and some down trading but it expanded sharply by 823 bps. On the bottom-line front, the company came back to green in Q2FY15 after reporting a loss in Q1FY15. Coming to the business highlights, the Textile segment which has been the cash cow for the company performed better on the top line posting a growth of 24% Y-o-Y to Rs6.94bn driven by volume growth in exports, combo packs and penetration of shirting fabric across the B2C channel, while EBITDA margins which had suffered in Q1 recovered by a good 924bps sequentially even though it contracted by 793 bps Y-o-Y owing to the high mix of shirting business. Excluding B2C shirting the textile segment grew by 6% Y-o-Y. Exports continued to do well as they grew by 32% Y-o-Y during the quarter and contributed to 16% of the sales compared to 12% in the last year. Apparel segment's topline which continued to grow in double digits over the past four quarters delivered this time as well posting sales of sales of Rs 2.9bn, up 15% Y-o-Y in Q2FY15 while EBITDA margin was back to profitability after posting a dismal loss in Q1FY15, however the margins were lower Y-o-Y due to higher brand building cost & store rollouts. The company mentioned that they had been able to reduce discount sales and average discount percentage as well. The company stepped up advertising cost considerably which grew by 72% and impacting its margins; had the advertisement cost been maintained at the same level as Q2FY14, EBIDTA margin would have increased to 8.6% during the quarter compared to 7.9% in the last year. Garmenting segment continued its stellar run as it reported a top-line growth of 28% Y-o-Y, driven by increase in volumes while EBITDA margin at 10% was impacted by ~290 bps sequentially and Y-o-Y to due to rupee appreciation against dollar and higher employment cost. Management Outlook In the recent Q2FY15's results concall the company was fairly optimistic about its businesses in Q3 and remained confident about the strategic directions for the business. It plans to invest in brand building, modernization and expansion of retail network and also capacity expansion in the export driven businesses. The company mentioned that with respect to monetization of non-core assets, the progress was slow compared to its expectation. Our take Mahantesh Marilinga Senior Research Analyst Tel. : 4000 2666 mahantesh@finquestonline.com The company's aggressive investments (advertising and renovation of stores) and the market sluggishness had taken a toll on the apparel business offlate but times are changing and we could expect the bottom-line recovery to continue. The core textile business has continued to do well while recovering from the sub-par margin performance in Q1FY15. Garmenting again has benefitted from the increased competitiveness of the Indian garmenting sector globally. The decline in cotton and wool prices should benefit the textile, apparel and denim businesses of RYMD in Q3FY15 in a big way. We believe the continued traction in most of RYMD's businesses on the back of domestic economic recovery and an expected sharp fall in raw material costs Y-o-Y could spring a positive surprise in Q3FY15 numbers. FINQUEST research also available on BLOOMBERG FSPL <GO> and REUTERS. For Private Circulation Only Valuations On the back of good set of numbers in Q2FY15 and a visibility of better performance going ahead we value the core equity of RYMD at a P/E of 15x FY15E earnings, which gives us a value of Rs 440/share while we value the land bank at Thane at 25% discount to the expected market value which comes to Rs 344/share giving a combined price target of Rs 784 for FY15E. We expect a good set of results from RYMD in the current quarter i.e Q3FY15 which could lead to a re-rating of the stock and take it new levels. Any stake sale of its non-core businesses like the Tools and hardware business or the auto components or any new development on the land parcel development/sale could be a major positive for the stock price. SOTP Valuation of Raymond (RYMD) Company Basis of Valuation Raymond's core equity value No. of acres Valn. Parameter (CMP/EPS) 100 Rs 280 P/E Land Value / Share Total Value / Share Value/Mcap (Rs.mn) RYMD's Shares (in mn) Value/ RYMD's Share (Rs.) 25% Discount on Land bank 61 440 440 61 459 344 784 16.0x Rsmn/Acre 18,000 CMP Upside 461 70% Comparative Valuation Company PAGE Industries Arvind Ltd Trent Ltd Shoppers Stop Bom Fash Ray Raymond Kewal Kiran Bombay Dyeing Alok Industries Pantaloons Fashns. & Retls. Zodiac clothing Siyaram silk mills Mafatlal industries Maxwell Industries Skumars Nationwide Rs Rs bn Rs bn Sales Rs Bn (x) Price Mcap Cash Net D/E FY15E 9,580 281 1,436 487 140 459 1,695 69 12 121 361 860 162 38 5 107 72 48 40 19 28 21 14 16 11 7 8 2 2 1 0.0 1.4 1.5 0.2 1.0 4.7 4.8 0.3 6.8 0.2 0.3 0.1 0.2 0.0 0.2 0.6 1.1 0.2 1.3 1.9 0.9 -4.0 1.0 5.4 1.8 0.1 0.8 0.3 0.8 0.9 15 80 24 45 30 54 4 28 98 17 4 13 9 3 50 EPS Rs FY16E FY15E P/E (x) P/S (x) EV/EBITDA (x) FY16E FY15E FY16E FY15E FY16E FY15E FY16E 19 179.2 230.5 94 16.1 19.8 28 20.3 45.8 53 2.8 8.2 NA -10.0 NA 61 27.6 48.3 5 60.4 74.5 30 2.0 1.9 202 1.1 4.4 NA -20.2 NA NA 11.4 NA NA 67.8 NA NA 16.2 NA NA 0.8 NA NA -12.4 NA 53.5 17.5 70.7 172.0 -14.1 16.6 28.1 34.5 10.1 -6.0 31.8 12.7 10.0 45.2 -0.4 41.6 14.2 31.4 59.7 NA 9.5 22.8 36.3 2.6 NA NA NA NA NA NA 7.0 0.9 2.0 0.9 0.6 0.5 4.8 0.5 0.2 0.7 1.8 0.6 0.2 0.9 0.0 5.6 0.8 1.7 0.8 NA 0.5 4.1 0.5 0.1 NA NA NA NA NA NA 33.9 9.7 1.0 24.1 16.6 8.6 15.3 10.0 7.1 63.3 16.7 7.6 11.6 13.9 3.7 26.5 8.0 0.9 16.8 NA 7.7 12.6 10.4 2.5 NA NA NA NA NA NA EBIDTA (%) FY15E 20.9 13.2 1.5 4.3 13.1 10.2 24.6 10.1 24.4 2.1 10.8 11.3 3.1 9.0 18.0 Annual Annual RoE EPS Sales (%) Growth Growth FY15E (%) (%) (16E/15E) (16E/15E) Div. Yield (%) 58.3 15.2 5.6 3.9 -18.1 10.3 24.0 8.4 3.3 -27.8 8.8 18.6 6.4 5.3 -13.4 0.8 1.0 NA 0.2 NA 0.3 1.4 1.2 2.6 0.0 1.2 1.2 1.8 0.7 22.0 28.7 23.0 126 188 NA 74.6 23.4 -5.0 281.6 NA 56.3 15.5 -39.4 135.2 17.8 26.7 17.4 17.9 17.1 -9.3 13.9 19.3 6.7 107.1 29.3 14.1 25.2 15.3 2.7 -21.1 NA - Not Available November 17, 2014 For Private Circulation Only 2 Q2FY15 Highlights Particulars (Mn. Rs) Q2 FY15 Total Income 14,607 Q2 Y-o-Y Q4 FY14 change FY14 % 12,267 19.1% 10,968 Q-o-Q change % 33.2% 6M FY15 25,575 6M FY14 Y-o-Y change % 21,006 21.8% Less: COGS 6,451 4,744 36.0% 4,716 36.8% 11,167 8,002 39.5% Manufacturing & operating costs 2,328 2,118 9.9% 2,064 12.8% 4,392 3,953 11.1% Employee benefit expenses 1,630 1474.9 10.5% 1568.1 4.0% 3,198 2913.2 9.8% Other Expenses Total Expenditure EBIDTA Less: Depreciation & Amortization EBIT 2,479 2032.3 22.0% 2230.7 11.1% 4,709 3935.3 19.7% 12,888 10,369 24.3% 10,579 21.8% 23,467 18,804 24.8% 1,720 1,898 (9.4%) 389 342.7% 2,108 2,203 (4.3%) 396 486 (18.7%) 390 1.5% 785 961 (18.3%) 1,324 1,411 (6.2%) 1,323 1,242 6.5% Less: Interest 521 483 7.8% 483 7.8% 1,004 939 7.0% Add: Other income 108 150 (28.1%) 237 (54.5%) 344 267 28.9% (1) (11) (95.2%) (35) (98.6%) (36) (111) (68.1%) Extraordinary Expense (Net) Forex loss & Other one offs (1) (120472.7%) 52 (54) 131 (152) Profit Before Tax 910 1,068 (14.7%) (283) (422.3%) 628 459 36.8% Profit Before Extraordinary items and Tax 859 1,132 (24.1%) (327) (363.2%) 533 722 (26.2%) 158 179 (11.9%) 32 391.3% 190 101 87.4% 753 889 358 22.5% Less: Total Tax Profit After Tax before Minority Interest 79 (15.3%) (315) (339.3%) 438 Minority Interest (41) (2) 2431.3% (17) 144.0% (57) (5) 1042.0% Profit share of associates (31) 39 (180.7%) 3 (1259.3%) (29) 76 (137.5%) Profit After Tax 681 926 (26.5%) (329) (307.3%) 352 429 (17.9%) Profit After Tax Excl. extra-ordinaries 639 980 (34.8%) (377) (269.2%) 261 656 (60.2%) 61 61 61 61 Reported EPS (Rs.) 11.09 15.08 (26.5%) (5.35) (307.3%) 5.76 6.99 (17.6%) Proforma EPS (Rs.) 10.41 15.96 (34.8%) (6.15) (269.2%) 4.27 10.68 (60.0%) Shares Outstanding (Diluted) (mn) Margin Analysis 61 Change in bps EBIDTA Margin Change in bps Change in bps 11.8% 15.5% -370 3.5% 823 8.2% 10.5% -224 EBIT margin 9.1% 11.5% -244 0.0% 907 5.2% 5.9% -74 Proforma NPM 4.4% 8.0% -361 -3.4% 781 1.0% 3.1% -210 17.3% 16.8% 56 -11.4% 2,868 30.2% 22.1% 816 Effective Tax Rate Margin Analysis Change in bps Change in bps Cost of Material consumed/Net Sales 44.2% 38.7% 549 43.0% 116 43.7% 38.1% 557 Manufacturing & operating costs/Net Sales 15.9% 17.3% -133 18.8% -288 17.2% 18.8% -164 Employee benefit expenses/Net Sales 11.2% 12.0% -86 14.3% -314 12.5% 13.9% -136 Other Expenses/Net Sales 17.0% 16.6% 40 20.3% -337 18.4% 18.7% -32 Raymond Ltd. (RYMD) reported a decent set of numbers for Q2FY15. Sales grew by a good 19% Y-oY to Rs 14.61bn while the proforma PAT declined 35% Y-o-Y to Rs 639mn. However, there was a very good recovery in terms of profitability sequentially. The company benefitted from the robust performance of its textile and apparel business, both of which beat our expectations for the quarter. The textile business's top line grew 24% Y-o-Y and 43% sequentially while the EBIDTA margins even though contracted 793 bps Y-o-Y expanded by a massive 924 bps sequentially to 18.7%. On the other hand Apparel business's topline grew by 15% Y-o-Y and a massive 63% sequentially while EBITDA margins at 6.5% even though contracted 793 bps Y-o-Y and came back to profitability compared to a loss the previous quarter. November 17, 2014 For Private Circulation Only 3 Business wise Analysis 1 ] Textile Division (Fabric) Particulars (In Rs. mn) Q2 FY14 Q3 FY14 Q4 FY14 Q1 FY15 Q2 FY15 Net Sales Y-o-Y growth (%) % of total sales EBIDTA EBIDTA margin (%) % of total EBITDA 5,587 7.4% 44.4% 1,490 26.7% 67.0% 5,433 7.9% 44.2% 1,160 21.4% 62.3% 5,342 3.9% 43.1% 1,040 19.5% 67.3% 4,842 26.6% 43.1% 460 9.5% 54.1% 6,936 24.1% 46.7% 1,300 18.7% 65.3% Revenue from the Textile division grew by a massive 24% Y-o-Y to Rs 6.94bn. The rise in sales was led by the growth in export markets and penetration of shirting fabric across B2C channels while the margins were impacted due to adverse product mix, higher input cost and stores renovation. Excluding B2C shirting the textile segment grew by 6% Y-o-Y. Exports continued to do well as they grew by 32% Y-o-Y during the quarter and contributed to 16% of the sales compared to 12% in the last year. Combo packs continued to witness good traction and grew by 15% Y-o-Y in Q2FY15. The company also mentioned that there were few concerns in the domestic fabric business in Q2FY15 which it expects to ease in the next quarter. Increased B2C shirting and exports having lower margin impacted RYMD's textile segment margin by around 2% Y-o-Y. 2 ] Branded Apparel Particulars (In Rs. mn) Q2 FY14 Q3 FY14 Q4 FY14 Q1 FY15 Q2 FY15 Net Sales Y-o-Y growth (%) % of total sales EBIDTA EBIDTA margin (%) % of total EBITDA 2,544 8.6% 20.2% 200 7.9% 9.0% 2,503 14.6% 20.4% 210 8.4% 11.3% 2,344 21.4% 18.9% 0 0.0% 0.0% 1,793 13.5% 16.0% -60 -3.3% -7.1% 2,925 15.0% 19.7% 190 6.5% 9.5% The increase in sales led by double digit growth across all brands. Blended sales across secondary channels i.e Exclusive Brand Outlets (EBOs) and Large Format Stores (LFS) during the quarter grew by 15% Y-o-Y on blended basis. EBITDA margin came in lower Y-o-Y due to higher brand building cost & store rollouts. The company also launched the e-commerce portal RaymondNext.com during the quarter. RYMD's e-commerce sales through the online channel partners clocked in excess of 1.5 Crores per month during the quarter. The company added 16 new stores and closed 6 stores in Q2FY15. It also completed the renovation of 18 stores and 12 were undergoing renovation which impacted EBITDA margins by about 1% Y-o-Y. Blended same store sales growth across formats grew by 6% Y-o-Y while total sales growth across the exclusive network grew by 7% Y-o-Y. In addition to these there had been increase in input cost besides higher power rates per unit which also collectively impacted EBITDA margins by 3.5%. The company mentioned that they had been able to reduce discount sales and average discount percentage as well. The company stepped up advertising cost considerably which grew 72% y-o-yand impacting its margins; had the advertisement cost been maintained at the same level as Q2FY14 EBIDTA margin would have increased to 8.6% during the quarter compared to 7.9% in the last year. The Company mentioned that they had received good response at the recently concluded SS15 season bookings and initial booking data indicated 18-20% growth Y-o-Y. The company's retail channel exclusive network stores stood at 964, like to like secondary sales growth was 6% during the quarter, total secondary sales throughput across the entire exclusive network of stores grew by 7%. Same stores sales growth for stores post renovation was in excess of 10%. The company mentioned that it was increasing the pace of stores rollout renovation for in H2FY15 and expects to open 100-120 stores in FY15 including those under renovation. The company had planned to open ~50 stores during FY15; and by the end of September it had completed the renovation of 18 stores. November 17, 2014 For Private Circulation Only 4 3 ] B2B Luxury Cotton Shirting Fabric Particulars (In Rs. mn) Q2 FY14 Q3 FY14 Q4 FY14 Q1 FY15 Q2 FY15 Net Sales Y-o-Y growth (%) % of total sales EBIDTA EBIDTA margin (%) % of total EBITDA 880 11.4% 7.0% 100 11.4% 4.5% 860 7.5% 7.0% 90 10.5% 4.8% 920 31.4% 7.4% 90 9.8% 5.8% 914 28.7% 8.1% 86 9.4% 10.1% 1,070 21.6% 7.2% 180 16.8% 9.0% The sales growth was driven by increase in sales driven by combination of volumes and realizations in domestic market. EBITDA margin improved Y-o-Y due to better realizations and one-off income of Rs 65 mn. The one off income was related to the refund of power charge in the earlier period by MSEB which relates to the commercial taxes that they charge on the power tariff. The company mentioned that discussions are in progress to acquire the stake of JV partners. 4 ] Denim (Raymond Uco Denim JV)- 50% share Particulars (In Rs. mn) Q2 FY14 Q3 FY14 Q4 FY14 Q1 FY15 Q2 FY15 Net Sales Y-o-Y growth (%) % of total sales EBIDTA EBIDTA margin (%) % of total EBITDA 2,360 10.8% 18.7% 230 9.7% 10.3% 2,350 8.3% 19.1% 230 9.8% 12.4% 2,520 26.6% 20.3% 220 8.7% 14.2% 2,460 6.0% 21.9% 230 9.3% 27.0% 2,330 -1.3% 15.7% 230 9.9% 11.6% Sales de-grew marginally while EBITDA margins improved 13bps Y-o-Y due to higher export mix and lower raw material cost. 5 ] Garmenting Particulars (In Rs. mn) Q2 FY14 Q3 FY14 Q4 FY14 Q1 FY15 Q2 FY15 Net Sales Y-o-Y growth (%) % of total sales EBIDTA EBIDTA margin (%) % of total EBITDA 1,177 16.8% 9.3% 150 12.7% 6.7% 1,045 44.8% 8.5% 150 14.4% 8.1% 1,145 28.0% 9.2% 188 16.4% 12.2% 1,240 50.3% 11.0% 160 12.9% 18.8% 1,503 27.7% 10.1% 150 10.0% 7.5% The company's garmenting sales growth was driven by increase in volumes while EBITDA margins were impacted due to rupee appreciation against dollar and higher employment cost. Sales in hybrid segment grew marginally due to subdued demand for the product in the export market. 6 ] Tools & Hardware Particulars (In Rs. mn) Q2 FY14 Q3 FY14 Q4 FY14 Q1 FY15 Q2 FY15 Net Sales Y-o-Y growth (%) % of total sales EBIDTA EBIDTA margin (%) % of total EBITDA 1,136 22.3% 9.0% 80 8.5% 12.3% 1,103 15.1% 9.0% 150 13.2% 6.7% 1,121 5.0% 9.0% 110 10.0% 5.9% 948 0.6% 8.4% 100 8.9% 6.5% 1,147 0.9% 7.7% 40 4.2% 4.7% Tools and hardware segment grew marginally by 1% Y-o-Y to Rs 1,147mn while the contraction in the EBITDA margin was mainly due to unfavorable product mix. November 17, 2014 For Private Circulation Only 5 7 ] Auto Components Particulars (In Rs. mn) Q2 FY14 Q3 FY14 Q4 FY14 Q1 FY15 Q2 FY15 Net Sales Y-o-Y growth (%) % of total sales EBIDTA EBIDTA margin (%) % of total EBITDA 506 -5.2% 4.0% 66 13.0% 3.0% 565 12.5% 4.6% 69 12.2% 3.7% 703 21.4% 5.7% 60 8.5% 3.9% 704 8.0% 6.3% 90 12.8% 10.6% 600 18.6% 4.0% 40 6.7% 2.0% The growth in the Auto component segment was driven by domestic and export market. EBITDA margin nearly halved owing to higher input cost and to some extent the lower exports particularly in the European segment of the market. Outlook The company mentioned that with respect to monetization of non-core assets, the progress was slow compared to their expectation. The company was fairly optimistic about its businesses in Q3 and remained confident about the strategic directions for the business. It plans to invest in brand building, modernization and expansion of retail network and also capacity expansion in the export driven business. Segment Analysis Particulars (Mn. Rs) Q2 FY15 Q2 FY14 Y-o-Y change % Q4 FY14 Q-o-Q change % 6M FY15 6M FY14 Y-o-Y change % Textiles 6,936 5,587 24.1% 4,842 43.3% 11,778 9,412 25.1% Denim 2,234 1,782 25.4% 2,136 4.6% 4,369 3,297 32.5% Apparel 2,925 2,544 15.0% 1,793 63.1% 4,719 4,124 14.4% Garmenting 1,503 1,177 27.7% 1,240 21.2% 2,743 2,002 37.0% Tools & Hardware 1,147 1,136 0.9% 948 20.9% 2,095 2,079 0.8% Auto Components 600 506 18.6% 704 (14.8%) 1,305 1,158 12.6% 10 15 (32.0%) 18 (43.5%) 29 49 (41.1%) 816 512 59.5% 721 13.3% 1,537 1,147 34.0% 14,539 12,236 18.8% 10,961 32.6% 25,500 20,974 21.6% Textiles 1,127 1,266 (11.0%) 298 277.8% 1,425 1,380 3.3% Denim 202 93 117.8% 140 44.3% 342 199 71.6% Apparel 141 136 4.1% (109) (230.1%) 33 (28) (216.0%) Garmenting Segment Revenue Others Inter segment revenue Net Sales/ Income from operation Operating Profit 127 121 4.7% 132 (3.9%) 259 168 54.5% Tools & Hardware 79 129 (38.7%) 17 371.9% 96 191 (50.1%) Auto Components 13 37 (66.5%) 64 (80.3%) 76 91 (16.3%) (55) (62) (11.8%) (66) (17.2%) (121) (118) 2.9% Others Inter segment revenue 7 -10 (166.3%) -13 (151.6%) -6 -24 (74.8%) 1,640 1,709 (4.1%) 463 254.3% 2,103 1,859 13.1% 521 483 7.8% 483 7.8% 1,004 939 7.0% Add/(Less): Unallocable Income / (Exp) -248 -150 65.7% -244 1.8% -492 -355 38.6% Total Less: Finance Costs Add/(Less): Exceptional Items -1 -11 (95.2%) -35 (98.6%) -36 -111 (68.1%) Add/(Less): Provision for taxes -158 -179 (11.9%) -32 391.3% -190 -101 87.4% Add/(Less): Share of profit in associate companies -31 36 (187.4%) 3 (1259.3%) -29 73 (139.0%) 681 923 (26.2%) 353 426 (17.2%) Net Profit November 17, 2014 For Private Circulation Only (329) (307.4%) 6 Raw Material Trend Domestic Cotton Index Source: Company, FQ Research Currency adjusted Australian Wool Index Source: Company, FQ Research * Q3FY15 data till Nov. 12, 2014 November 17, 2014 For Private Circulation Only 7 Segmental Sales Contribution (%) - Quarterly Trend Segmental EBIT Contribution (%) - Quarterly Trend Source: Company, FQ Research Source: Company, FQ Research Segmental EBIT Margin (%) - Quarterly Trend Segmental RoCE (%) - Quarterly Trend Source: Company, FQ Research Source: Company, FQ Research November 17, 2014 For Private Circulation Only 8 Consolidated Financials Profit and Loss Statement Balance Sheet FY12 Total Revenues 36,424 Net Sales Growth (Y-oY) 20% Total Expenditure 31,888 EBIDTA 4,536 EBIDTA Margin (%) 12.5% EBIDTA Growth (Y-o-Y) 10% Interest 1,651 Depreciation/Amortization 1,658 Other Income 817 PBT 2,044 PBT Margin (%) 5.6% Net Profit 1,558 Net Profit Excl. extra-ordinaries 1,558 Net Profit Excl. extra-ordinaries (Y-o-Y %) -40% FY13 40,692 12% 36,978 3,714 9.1% -18% 1,906 1,890 739 367 0.9% 287 380 -76% FY14 45,577 12% 40,680 4,897 10.7% 32% 1,968 1,958 629 1,600 3.5% 1,433 1,433 277% FY15E 53,634 18% 48,145 5,489 10.2% 12.1% 2,116 1,618 589 2,344 4.4% 1,686 1,686 18% FY16E 61,094 14% 54,145 6,949 11.4% 27% 2,366 1,740 877 3,720 6.1% 2,944 2,944 75% Profit and Loss Statement FY12 FY13 FY14 FY15E FY16E 18.2 18.2 2.1 8.8 8.5 0.8 0.5% 98.5 74.5 2.0 13.0 10.0 0.7 0.2% 19.7 19.7 1.8 8.3 9.3 0.6 0.3% 16.8 16.8 1.6 8.6 8.3 0.5 0.3% 9.6 9.6 1.4 6.0 6.5 0.5 0.3% 0.8 2.7 0.7 1.9 0.8 2.5 0.8 2.6 0.7 2.9 25.4 25.4 52.4 224 4.7 6.2 35.5 227 23.3 23.3 55.2 250 27.5 27.5 53.8 283 48.0 48.0 76.3 332 Returns (%) RoE (%) RoE (%)- Excl. extra-ordinaries RoCE (%) RoCE (%)-Excl. extra-ordinaries Dividend Payout 11.9% 11.9% 11.2% 11.2% 11.3% 2.1% 2.7% 3.7% 4.1% 24.6% 9.8% 9.8% 11.8% 11.8% 5.9% 10.3% 10.3% 11.1% 11.1% 5.9% 15.6% 15.6% 14.3% 14.3% 3.4% Du-Pont Analysis EBIDTA/Sales (%) Sales/Operating assets (x) EBIDTA/Operating Assets (%) Operating Assets/Net Assets (x) Net Earnings/EBIDTA (%) Net Assets/Net Worth (x) RoE (%) 12.5% 1.4 17.2% 1.1 34.3% 1.8 11.9% 9.1% 1.5 13.4% 1.2 10.2% 1.7 2.7% 10.7% 1.5 16.3% 1.2 29.3% 1.7 9.8% 10.2% 1.6 16.7% 1.1 30.7% 1.8 10.3% 11.4% 1.8 20.0% 1.1 42.4% 1.7 15.6% Margins (%) EBIDTA margin PBT margin PAT margin 12.5% 5.6% 4.3% 9.1% 0.9% 0.7% 10.7% 3.5% 3.1% 10.2% 4.4% 3.1% 11.4% 6.1% 4.8% Growth (%) Revenue EBIDTA PAT APAT 20% 10% 190% -40% 12% -18% -82% -76% 12% 32% 399% 277% 18% 12% 18% 18% 14% 27% 75% 75% 64 48 105 121 66 52 94 108 68 39 98 127 60 37 90 113 60 37 90 112 Valuation Ratios P/E (x) P/E Excl. Extra-ordinaries (x) P/BV (x) P/CEPS (x) EV/EBITDA (x) Market Cap. / Sales (x) Div.Yield (%) Leverage Ratios Debt/Equity (x) Interest Coverage (x) Per Share Data Diluted EPS Fully Diluted EPS Excl. extra-ordinaries Diluted Cash EPS Book Value Per share (Rs.) Operating Cycle Debtors Creditors I nventory Cash conversion Cycle November 17, 2014 FY12 FY13 FY14 FY15E FY16E Liabilities Equity Capital Reserves & Surplus Equity Minority Interest Net Worth Other Liabilities Total Loans Capital Employed 614 13,010 13,623 141 13,764 2,049 8,839 24,653 614 13,175 13,789 123 13,912 1,341 8,165 23,418 614 14,047 14,661 706 15,367 1,388 11,178 27,933 614 15,908 16,522 832 17,354 1,661 11,892 30,907 614 18,852 19,466 915 20,382 1,837 12,995 35,213 Assets Net Block Capital WIP Investments Others - Assets 13,482 1,260 962 2,716 13,067 1,743 1,114 2,934 12,564 1,740 1,106 3,038 13,289 939 1,031 3,057 13,998 886 1,031 3,193 Current Assets Inventories Sundry Debtors Cash and cash equivalents Loans and Advances Other Current Assets Total Current Assets 9,171 6,352 4,461 1,085 564 21,634 9,477 7,384 4,508 991 611 22,972 10,925 8,499 4,851 1,007 695 25,977 11,871 8,886 9,219 1,234 751 31,961 13,351 9,994 12,176 1,405 855 37,781 Less:Current Liabilities & Provisions Short Term borrwing Sundry Creditors Provisions Other Current Liabilities Total Current Liabilities & Provisions Capital Applied 5,426 4,174 4,902 899 15,401 24,653 5,680 5,246 6,773 712 18,412 23,418 5,455 5,930 4,346 760 16,491 27,933 7,077 6,515 4,911 867 19,370 30,907 7,851 7,327 5,523 975 21,676 35,213 FY12 2,878 864 2,014 1,658 3,672 128 1,947 1,853 2,756 (904) (164) (740) (740) FY13 1,824 1,240 583 1,890 2,474 170 (308) 2,951 1,959 993 152 841 (93) 748 FY14 2,939 547 2,392 1,958 4,350 131 5,139 (658) 1,451 (10) (2,100) (8) (2,092) (2,092) FY15E 3,871 965 2,905 1,618 4,524 (74) 1,105 3,345 1,543 (55) 1,857 (75) 1,932 1,932 FY16E 5,209 1,258 3,951 1,740 5,691 123 2,292 3,522 2,396 1,126 1,126 1,126 Cash Flow Statement EBITDA Less: Adjusted Taxes NOPLAT Plus: Depreciation Gross Cashflow Minority Interest/ Profit share of associates Less: Increase in Working Capital Operating Cashflow Less: Net Capex Less: Increase in Net Other Assets FCF From Operation Less: Inc./(Dec.) in Investment FCF after Investment Plus: Gain/(loss) on Extraordinary Items Total FCF Recommendation Summary Event Date Price Rating Target Initiating Coverage 11-05-2012 377 Buy 506 Result Update (Q1FY13) 01-08-2012 355 Buy 480 Result Update (Q2FY13) 26-10-2012 376 Buy 480 Result Update (Q3FY13) 28-01-2013 386 Buy 460 Result Update (Q3FY14) 14-03-2014 280 Buy 515 Result Update (Q1FY15) 04-08-2014 419 Buy 500 Result Update (Q2FY15) 17-11-2014 461 Buy 784 For Private Circulation Only 9 ANALYST DISCLAIMER: Each analyst of FINQUEST Securities (P) Ltd. whose name appears on page 1 of the research reports accessible on this website hereby certifies that (i) the recommendations and opinions expressed in the research report accurately reflect the research analyst's personal views about any and all of the securities or issuers discussed herein that are within the analyst’s coverage universe and (ii) no part of the research analyst's compensation was, is, or will be, directly or indirectly, related to the provision of specific recommendations or views expressed by the research analyst in the research report. FINQUEST Securities (P) Ltd. 602 Boston House, Next to Cinemax, Suren Road, Andheri (East) Mumbai 400 093. Tel.: 91-22-4000 2600 z Fax: 91-22-4000 2605 z Email: info@finquestonline.com Website: www.finquestonline.com DISCLAIMER: This document is not for public distribution and has been furnished to you solely for your information and must not be reproduced or redistributed to any other person. Persons into whose possession this document may come are required to observe these restrictions. Opinion expressed is our current opinion as of the date appearing on this material only. While we endeavor to update on a reasonable basis the information discussed in this material, there may be regulatory, compliance, or other reasons that prevent us from doing so. Prospective investors and others are cautioned that any forward-looking statements are not predictions and may be subject to change without notice. Our proprietary trading and investment businesses may make investment decisions that are inconsistent with the recommendations expressed herein. The information in this document has been printed on the basis of publicly available information, internal data and other reliable sources believed to be true and are for general guidance only. While every effort is made to ensure the accuracy and completeness of information contained, the company takes no guarantee and assumes no liability for any errors or omissions of the information. No one can use the information as the basis for any claim, demand or cause of action. Recipients of this material should rely on their own investigations and take their own professional advice. Each recipient of this document should make such investigations as it deems necessary to arrive at an independent evaluation of an investment in the securities of companies referred to in this document (including the merits and risks involved), and should consult their own advisors to determine the merits and risks of such an investment. Price and value of the investments referred to in this material may go up or down. Past performance is not a guide for future performance. Certain transactions - futures, options and other derivatives as well as non-investment grade securities - involve substantial risks and are not suitable for all investors. Reports based on technical analysis centers on studying charts of a stock’s price movement and trading volume, as opposed to focusing on a company’s fundamentals and as such, may not match with a report on a company’s fundamentals. We do not undertake to advise you as to any change of our views expressed in this document. While we would endeavor to update the information herein on a reasonable basis, FINQUEST, its subsidiaries and associated companies, their directors and employees are under no obligation to update or keep the information current. Also there may be regulatory, compliance, or other reasons that may prevent FINQUEST and affiliates from doing so. Prospective investors and others are cautioned that any forward-looking statements are not predictions and may be subject to change without notice. FINQUEST and affiliates, including the analyst who has issued this report, may, on the date of this report, and from time to time, have long or short positions in, and buy or sell the securities of the companies mentioned herein or engage in any other transaction involving such securities and earn brokerage or compensation or act as advisor or have other potential conflict of interest with respect to company/ies mentioned herein or inconsistent with any recommendation and related information and opinions. FINQUEST and affiliates may seek to provide or have engaged in providing corporate finance, investment banking or other advisory services in a merger or specific transaction to the companies referred to in this report, as on the date of this report or in the past. BUY HOLD SELL More than 10% return Between 5-10% return Less than 5% return November 17, 2014 For Private Circulation Only 10
© Copyright 2024