Price
Financials
Consolidated, Rs crore| Mar 2012 | Jun 2012 | Sep 2012 | Dec 2012 | Mar 2013 | Jun 2013 | Sep 2013 | Dec 2013 | Mar 2014 | Jun 2014 | Sep 2014 | Dec 2014 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Sales | 3,781 | 3,259 | 2,708 | 2,711 | 2,472 | 2,634 | 2,802 | 2,894 | 2,467 | 2,416 | 3,260 | 2,619 |
| Expenses | 2,690 | 2,998 | 2,372 | 2,658 | 2,317 | 2,511 | 2,602 | 2,624 | 2,413 | 2,286 | 2,555 | 2,506 |
| Operating Profit | 1,091 | 261 | 336 | 53 | 155 | 123 | 199 | 270 | 54 | 130 | 705 | 113 |
| OPM % | 29% | 8% | 12% | 1.9% | 6% | 4.7% | 7% | 9% | 2.2% | 5% | 22% | 4.3% |
| Other Income | 405 | -530 | 459 | -289 | 144 | -451 | -346 | -119 | 89 | -181 | -5 | -5 |
| Interest | 19 | 165 | -16 | 136 | 53 | 159 | 111 | 121 | 114 | 142 | 137 | 147 |
| Depreciation | 80 | 78 | 0 | 80 | 80 | 0 | 133 | 92 | 0 | 0 | 0 | 97 |
| Profit before tax | 1,398 | -512 | 811 | -453 | 167 | -487 | -391 | -60 | 30 | -192 | 563 | -135 |
| Tax % | 10% | 13% | 7% | 8% | 21% | 6% | 15% | 163% | 371% | -3% | 15% | 656% |
| Net Profit | 1,248 | -584 | 757 | -489 | 130 | -523 | -453 | -162 | -79 | -189 | 477 | -1,024 |
| EPS in Rs | 29.54 | -13.88 | 17.86 | -11.64 | 2.97 | -12.39 | -10.73 | -3.75 | -1.74 | -4.39 | 11.27 | -24.23 |
| Dec 2005 | Dec 2006 | Dec 2007 | Dec 2008 | Dec 2009 | Dec 2010 | Dec 2011 | Dec 2012 | Mar 2014 15m | TTM | |
|---|---|---|---|---|---|---|---|---|---|---|
| Sales | 5,134 | 6,057 | 6,684 | 7,296 | 7,515 | 8,876 | 10,315 | 12,452 | 13,259 | 10,762 |
| Expenses | 5,022 | 5,276 | 6,143 | 8,756 | 6,924 | 7,806 | 8,861 | 10,647 | 12,281 | 9,760 |
| Operating Profit | 112 | 781 | 540 | -1,460 | 591 | 1,070 | 1,455 | 1,805 | 977 | 1,002 |
| OPM % | 2.2% | 13% | 8% | -20% | 8% | 12% | 14% | 14% | 7% | 9% |
| Other Income | 259 | 123 | 771 | 448 | 758 | 1,463 | -3,441 | 64 | -686 | -100 |
| Interest | 67 | 104 | 141 | 206 | 71 | 61 | 306 | 304 | 557 | 540 |
| Depreciation | 109 | 149 | 172 | 282 | 268 | 372 | 394 | 320 | 476 | 97 |
| Profit before tax | 194 | 651 | 999 | -1,500 | 1,010 | 2,100 | -2,686 | 1,245 | -742 | 265 |
| Tax % | -36% | 21% | 21% | -38% | 69% | 28% | 7% | 24% | 45% | |
| Net Profit | 264 | 515 | 787 | -943 | 307 | 1,509 | -2,890 | 932 | -1,087 | -815 |
| EPS in Rs | 13.69 | 20.76 | -22.63 | 7.05 | 35.55 | -68.71 | 21.82 | -25.61 | -19.09 | |
| Dividend Payout % | 121% | 62% | 41% | 0% | 0% | 6% | 0% | 0% | 0% |
| 10 Years | 5 Years | 3 Years | TTM | 1 Year | Last Year | |
|---|---|---|---|---|---|---|
| Compounded Sales Growth | % | 13% | 14% | 0% | ||
| Compounded Profit Growth | % | 7% | % | -157% | ||
| Stock Price CAGR | % | % | % | % | ||
| Return on Equity | % | 13% | 9% | -18% |
| 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,261 | 2,400 | 2,617 | 4,086 | 4,133 | 5,394 | 2,658 | 3,873 | 3,091 |
| Borrowings | 2,004 | 3,956 | 4,142 | 4,285 | 3,630 | 4,335 | 4,491 | 4,901 | 6,598 |
| Other Liabilities | 1,517 | 1,891 | 2,333 | 4,656 | 4,165 | 4,205 | 8,352 | 7,466 | 4,077 |
| Total Liabilities | 5,969 | 8,432 | 9,278 | 13,237 | 12,137 | 14,144 | 15,712 | 16,452 | 13,978 |
| Fixed Assets | 2,059 | 3,895 | 4,205 | 4,490 | 4,490 | 4,548 | 4,830 | 5,008 | 5,081 |
| CWIP | 560 | 358 | 357 | 471 | 623 | 382 | 227 | 208 | 303 |
| Investments | 17 | 36 | 240 | 543 | 541 | 498 | 98 | 79 | 72 |
| Other Assets | 3,333 | 4,143 | 4,476 | 7,733 | 6,483 | 8,716 | 10,557 | 11,157 | 8,522 |
| Total Assets | 5,969 | 8,432 | 9,278 | 13,237 | 12,137 | 14,144 | 15,712 | 16,452 | 13,978 |
| Dec 2005 | Dec 2006 | Dec 2007 | Dec 2008 | Dec 2009 | Dec 2010 | Dec 2011 | Dec 2012 | Mar 2014 | |
|---|---|---|---|---|---|---|---|---|---|
| Cash from Operating Activity | 204 | 529 | 1,023 | -152 | -162 | 1,539 | 639 | 1,582 | -3,562 |
| Cash from Investing Activity | -838 | -1,993 | -841 | -1,776 | 54 | -2,196 | 1,781 | -1,871 | 1,958 |
| Cash from Financing Activity | 746 | 1,513 | -39 | 2,676 | -522 | 791 | -1,218 | 237 | 1,016 |
| Net Cash Flow | 112 | 49 | 143 | 749 | -631 | 134 | 1,202 | -52 | -588 |
| Free Cash Flow | -704 | 109 | 587 | -586 | -653 | 1,112 | 190 | 1,117 | -4,335 |
| CFO/OP | 213% | 59% | 215% | 1% | 14% | 202% | 59% | 105% | -323% |
| Dec 2005 | Dec 2006 | Dec 2007 | Dec 2008 | Dec 2009 | Dec 2010 | Dec 2011 | Dec 2012 | Mar 2014 | |
|---|---|---|---|---|---|---|---|---|---|
| Debtor Days | 81 | 95 | 82 | 67 | 89 | 66 | 106 | 60 | 57 |
| Inventory Days | 224 | 248 | 220 | 234 | 219 | 266 | 286 | 246 | 209 |
| Days Payable | 127 | 130 | 116 | 133 | 171 | 230 | 156 | 146 | 111 |
| Cash Conversion Cycle | 178 | 213 | 186 | 168 | 137 | 102 | 236 | 159 | 154 |
| Working Capital Days | 113 | 124 | 104 | -24 | 32 | 53 | 1 | -18 | 56 |
| ROCE % | 14% | 16% | -18% | 12% | 21% | 15% | 21% | 7% |
Fundamentals
Market Cap₹ Cr.
Current Price₹ 860
Book Value₹ 86.0
ROCE7.18 %
ROE-17.5 %
Dividend Yield0.00 %
Face Value₹ 5.00
Compounded Sales Growth (TTM)0%
Compounded Profit Growth (TTM)-157%
Consolidated figures.
Valuation
Market capRs 36,362 Cr
Enterprise valueRs 36,663 Cr
Price to book8.90x
Price to sales3.38x
EV / EBITDA32.58x
EV / EBIT45.53x
EV / sales3.41x
Price to cash flow22.98x
Earnings yield-2.23%
P/E, 3-year average19.95x
P/B, 3-year average5.22x
P/E, 5-year average37.78x
P/B, 5-year average4.63x
Profitability
Operating margin (excl. other income)14.50%
Operating margin (incl. other income)15.01%
EBITDA margin10.46%
Pre-tax margin2.46%
Net profit margin-7.54%
Net margin, latest quarter-39.32%
ROE26.54%
ROCE18.95%
ROA5.74%
ROE, 3-year average-3.94%
ROCE, 3-year average5.19%
ROA, 3-year average-0.77%
ROE, 5-year average-6.35%
ROCE, 5-year average2.39%
ROA, 5-year average-1.68%
ROIC (approx.)14.03%
Tax rate23.61%
Other income / net worth1.56%
Growth
Sales growth (latest year)20.71%
Sales CAGR, 3 years18.33%
Sales CAGR, 5 years13.25%
Profit CAGR, 3 years46.00%
Profit CAGR, 5 years3.56%
Sales growth QoQ-19.68%
Profit growth QoQ-315.53%
Sales growth YoY (latest quarter)-9.51%
Per share
EPS (TTM)Rs -19.19
EPS (latest year)Rs 21.82
EPS (latest quarter)Rs -24.35
EPS, 3-year averageRs -3.78
EPS, 5-year averageRs -5.38
Book value per shareRs 96.58
Sales per shareRs 254.48
Cash flow per shareRs 37.41
Free cash flow per shareRs -102.50
Dividend per share, 3-year averageRs 2.00
Dividend per share, 5-year averageRs 2.00
Dividends
Dividend payout, 3-year average5.63%
Dividend payout, 5-year average5.63%
Efficiency
Asset turnover0.76x
Fixed asset turnover2.49x
Inventory turnover1.76x
Inventory days207 days
Debtor days60 days
Debtors turnover6.11x
Creditor days111 days
Cash conversion cycle154 days
Working capital days56 days
Leverage
Total debtRs 4,901 Cr
Cash and bankRs 4,600 Cr
Net debtRs 301 Cr
Debt to equity1.20x
Net debt / EBITDA0.27x
Interest coverage1.49x
Owners' fund to total sources24.83%
Debt to assets29.79%
Cash flow
Cash from Operating Activity (latest year)Rs 1,582 Cr
Cash from Investing Activity (latest year)Rs -1,871 Cr
Cash from Financing Activity (latest year)Rs 237 Cr
Net Cash Flow (latest year)Rs -52 Cr
Free cash flow (latest year)Rs -4,335 Cr
FCFE (approx.: FCF + change in debt)Rs -3,924 Cr
Sales to cash flow7.87x
Statement figures
Net sales (TTM)Rs 10,762 Cr
Net sales (latest year)Rs 12,452 Cr
Sales (latest quarter)Rs 2,619 Cr
Operating profit excl. other income (latest year)Rs 1,805 Cr
Operating profit (latest quarter)Rs 113 Cr
Other income (TTM)Rs -100 Cr
EBITDA (TTM)Rs 1,125 Cr
PBDT (TTM)Rs 585 Cr
Profit before tax (TTM)Rs 265 Cr
Tax (latest year)Rs 294 Cr
Net profit (TTM)Rs -812 Cr
Net profit (latest year)Rs 923 Cr
Net profit (latest quarter)Rs -1,030 Cr
Depreciation (TTM)Rs 320 Cr
Depreciation (latest quarter)Rs 97 Cr
Interest (TTM)Rs 540 Cr
Cost of goods sold (latest year)Rs 4,817 Cr
Total expenditure (latest year)Rs 10,647 Cr
Total income (latest year)Rs 12,516 Cr
Share capitalRs 211 Cr
ReservesRs 3,873 Cr
Shareholders' fundsRs 4,084 Cr
Total assetsRs 16,452 Cr
Net blockRs 5,008 Cr
Capital work in progressRs 208 Cr
InvestmentsRs 79 Cr
ReceivablesRs 2,037 Cr
InventoryRs 2,731 Cr
Other liabilitiesRs 7,466 Cr
Shares outstanding (crore)42.29
Computed by MarketFriction from the consolidated statements. Returns use average balances.
Not enough history to build valuation bands (needs two years of profits and prices).
| Period | RANBAXY | Nifty 50 | Difference |
|---|---|---|---|
| 1 week | +3.4% | -2.8% | +6.2 pts |
| 1 month | +19.1% | -6.8% | +25.9 pts |
| 3 months | +38.3% | -7.6% | +45.9 pts |
| 6 months | +44.6% | +0.4% | +44.2 pts |
| 1 year | +147.0% | -9.9% | +156.9 pts |
| 2 years | +98.7% | -13.6% | +112.3 pts |
| 3 years | +83.2% | +14.2% | +69.0 pts |
| 5 years | +80.6% | +27.9% | +52.7 pts |
Red flags
F-score 7 of 8No red flags in the latest statements and filings.
Checks on the latest reported years: cash vs profit, accruals, receivables and inventory vs sales, dilution, debt, interest cover, equity, other income, losses, and auditor, top-management, insolvency and regulator filings in the last 12 months. A flag asks for an explanation; it is not a verdict.
Latest quarter
Dec 2014Sales ₹2,619 Cr -9.5% vs Dec 2013.
Net loss ₹1,024 Cr.
Activity
Compare| Company | Mcap (Cr) | P/E | ROCE |
|---|---|---|---|
| Sun Pharmaceutical Industries Ltd | 447,476 | 35.4 | 20.5 % |
| Divis Laboratories Ltd | 250,363 | 84.0 | 22.0 % |
| Torrent Pharmaceuticals Ltd | 186,152 | 83.4 | 15.2 % |
| Zydus Lifesciences Ltd | 119,750 | 24.6 | 21.1 % |
| Cipla Ltd | 111,430 | 31.1 | 15.5 % |
| Laurus Labs Ltd | 106,928 | 97.8 | 17.8 % |
| Mankind Pharma Ltd | 105,120 | 49.3 | 13.5 % |
| Dr Reddys Laboratories Ltd | 104,494 | 32.4 | 13.0 % |
| Aurobindo Pharma Ltd | 97,682 | 25.8 | 12.9 % |
| Lupin Ltd | 93,840 | 15.8 | 29.9 % |
| Glenmark Pharmaceuticals Ltd | 68,905 | 22.1 | 39.8 % |
| Alkem Laboratories Ltd | 62,772 | 27.6 | 21.2 % |
| Biocon Ltd | 61,439 | 84.5 | 3.61 % |
| Abbott India Ltd | 57,949 | 35.9 | 44.8 % |
| Gland Pharma Ltd | 49,333 | 43.1 | 15.1 % |
No bulk or block deals on record.
| Ex-date | Action | Factor |
|---|---|---|
| 2014-07-17 | Annual General Meeting | |
| 2013-04-25 | Annual General Meeting | |
| 2012-04-26 | Annual General Meeting | |
| 2011-04-28 | Dividend - Rs. 2 Per Share | |
| 2010-04-29 | Annual General Meeting | |
| 2009-05-20 | Annual General Meeting | |
| 2008-05-21 | Agm/Div-Rs.6/- Per Share | |
| 2007-11-01 | Int Div-Rs.2.50 Per Share | |
| 2007-05-23 | Agm | |
| 2007-04-04 | 2nd Int Div-Rs.6/- Per Shpurpose Revised | |
| 2006-11-02 | Interim Dividend-50% | |
| 2006-06-15 | Agm/Fin Div-Rs.6/- Per Sh |
No announcements in our files yet.
Company filings to NSE, newest first. Routine notices (trading window, newspaper copies) are left out. Click a row for the filing.
No short selling reported to NSE in our files.
Short sales disclosed by brokers to NSE, by trade date. Collected since late September 2026.
Not on any NSE surveillance list in the latest file.
Quick answers
What is the market cap of Ranbaxy Laboratories Ltd (Merged)?
Ranbaxy Laboratories Ltd (Merged) (RANBAXY) has a market capitalisation of Rs Cr. at the 2015-04-01 close.
What were Ranbaxy Laboratories Ltd (Merged)'s latest quarterly results?
In the Dec 2014 quarter, Ranbaxy Laboratories Ltd (Merged) sales was Rs 2,619 Cr (-9.5% vs Dec 2013) with a net loss of Rs 1,024 Cr.