Ranbaxy Laboratories Ltd (Merged)

Ranbaxy Laboratories Ltd (Merged)

₹ 860 5.63%
01 Apr 2015
About

Ranbaxy Laboratories Limited,Incorporated in India, listed on the Bombay Stock Exchange Limited, and National Stock Exchange Limited, the company is engaged in Pharmaceutical

  • Market Cap Cr.
  • Current Price 860
  • High / Low /
  • Stock P/E
  • Book Value 35.2
  • Dividend Yield 0.00 %
  • ROCE 2.39 %
  • ROE -28.3 %
  • Face Value 5.00

Pros

  • Debtor days have improved from 107 to 65.8 days.

Cons

  • Stock is trading at 24.4 times its book value
  • Company has low interest coverage ratio.
  • The company has delivered a poor sales growth of 9.37% over past five years.
  • Company has a low return on equity of 7.04% over last 3 years.
  • Earnings include an other income of Rs.1,147 Cr.

* The pros and cons are machine generated. Pros / cons are based on a checklist to highlight important points. Please exercise caution and do your own analysis.

Loading peers table ...

Quarterly Results

Standalone Figures in Rs. Crores / View Consolidated

Dec 2011 Mar 2012 Jun 2012 Sep 2012 Dec 2012 Mar 2013 Jun 2013 Sep 2013 Dec 2013 Mar 2014 Jun 2014 Sep 2014 Dec 2014
3,896 1,866 1,526 1,470 1,442 1,382 1,439 1,426 1,367 1,252 2,168 1,319 1,010
2,935 1,374 1,702 1,283 1,529 1,350 1,590 1,528 1,433 1,290 1,242 1,475 1,361
Operating Profit 961 493 -176 187 -88 32 -151 -102 -66 -38 926 -156 -351
OPM % 25% 26% -12% 13% -6% 2% -10% -7% -5% -3% 43% -12% -35%
-3,451 398 -538 348 -350 134 -257 -535 -166 1,127 46 -16 -10
Interest 88 17 163 -17 134 51 156 111 118 111 142 137 149
Depreciation 132 47 49 0 46 45 45 94 46 50 66 60 55
Profit before tax -2,710 827 -926 552 -618 70 -609 -842 -396 928 764 -368 -565
Tax % 0% 0% 0% 0% -0% 0% 0% 0% 0% 3% 1% 0% 151%
-2,710 827 -926 552 -616 70 -609 -842 -396 898 755 -368 -1,420
EPS in Rs -64.23 19.60 -21.93 13.08 -14.57 1.66 -14.39 -19.91 -9.35 21.19 17.82 -8.69 -33.42
Raw PDF

Profit & Loss

Standalone Figures in Rs. Crores / View Consolidated

Dec 2005 Dec 2006 Dec 2007 Dec 2008 Dec 2009 Dec 2010 Dec 2011 Dec 2012 Mar 2014 15m TTM
3,444 3,907 4,063 4,386 4,723 5,592 7,799 6,304 6,865 5,749
3,422 3,414 3,832 6,174 4,198 5,126 6,725 5,861 7,185 5,368
Operating Profit 22 493 231 -1,788 524 466 1,074 443 -320 382
OPM % 1% 13% 6% -41% 11% 8% 14% 7% -5% 7%
282 100 740 469 725 1,382 -3,550 -124 299 1,147
Interest 26 58 93 146 39 54 299 297 547 539
Depreciation 76 92 103 154 148 228 274 186 280 231
Profit before tax 201 443 774 -1,619 1,062 1,565 -3,049 -164 -848 759
Tax % -11% 14% 20% -35% 46% 27% 0% -1% 4%
224 381 618 -1,045 572 1,149 -3,052 -162 -879 -136
EPS in Rs 10.21 16.56 -24.85 13.61 27.29 -72.32 -3.84 -20.74 -3.10
Dividend Payout % 142% 83% 51% 0% 0% 7% 0% 0% 0%
Compounded Sales Growth
10 Years: %
5 Years: 9%
3 Years: 7%
TTM: 2%
Compounded Profit Growth
10 Years: %
5 Years: 10%
3 Years: %
TTM: 24%
Stock Price CAGR
10 Years: 0%
5 Years: %
3 Years: %
1 Year: %
Return on Equity
10 Years: %
5 Years: 13%
3 Years: 7%
Last Year: -28%

Balance Sheet

Standalone Figures in Rs. Crores / View Consolidated

Dec 2005 Dec 2006 Dec 2007 Dec 2008 Dec 2009 Dec 2010 Dec 2011 Dec 2012 Mar 2014
Equity Capital 186 186 187 210 210 211 211 211 212
Reserves 2,191 2,164 2,352 3,507 3,924 4,922 1,714 1,711 885
1,030 3,179 3,503 3,699 3,348 4,261 4,334 4,810 6,183
1,259 1,396 1,823 4,118 3,419 3,419 8,063 6,238 5,825
Total Liabilities 4,666 6,925 7,865 11,533 10,902 12,812 14,321 12,970 13,105
1,200 1,434 1,470 1,457 1,593 1,712 1,867 1,994 2,012
CWIP 433 302 327 429 415 330 209 160 184
Investments 763 2,680 3,238 3,618 3,834 3,804 3,411 3,131 4,081
2,270 2,509 2,830 6,030 5,060 6,965 8,834 7,686 6,828
Total Assets 4,666 6,925 7,865 11,533 10,902 12,812 14,321 12,970 13,105

Cash Flows

Standalone Figures in Rs. Crores / View Consolidated

Dec 2005 Dec 2006 Dec 2007 Dec 2008 Dec 2009 Dec 2010 Dec 2011 Dec 2012 Mar 2014
107 315 686 -390 -665 1,169 128 662 -1,217
-563 -2,104 -708 -1,711 86 -2,067 1,766 -1,691 921
536 1,740 132 2,791 -214 991 -1,275 315 717
Net Cash Flow 81 -49 110 690 -793 93 619 -715 421

Ratios

Standalone Figures in Rs. Crores / View Consolidated

Dec 2005 Dec 2006 Dec 2007 Dec 2008 Dec 2009 Dec 2010 Dec 2011 Dec 2012 Mar 2014
Debtor Days 85 95 79 85 119 84 172 83 66
Inventory Days 216 214 200 224 231 262 264 276 215
Days Payable 136 101 104 112 163 188 157 137 124
Cash Conversion Cycle 166 207 176 197 186 159 279 222 157
Working Capital Days 107 111 97 -90 36 54 -13 -64 -28
ROCE % 11% 14% -23% 14% 16% 13% 8% 2%

Shareholding Pattern

Numbers in percentages

Shareholding pattern is currently not available for this company.

Documents