Ranbaxy Lab Financials

NSE: RANBAXY | BSE: 500359

₹859.80

₹45.80 (5.63%)

As on 01-Apr-2015IST

Market cap

₹36,603 Cr

Revenue (TTM)

₹5,759 Cr

P/E Ratio

P/B Ratio

Div. Yield

0 %

Income Statement (₹ Cr)	TTM	Mar-14	Dec-12	Dec-11	Dec-10	Dec-09
Operating Revenue	5,759.40	6,864.94	6,303.54	7,799.06	5,669.54	4,780.29
Total Income	6,523.26	7,649.76	6,560.71	8,021.71	6,032.93	5,385.03
Total Expenditure	5,698.84	7,189.42	5,860.62	6,725.02	4,439.72	4,135.44
EBITDA	60.56	-324.48	442.92	1,074.04	1,229.82	644.85
Depreciation	230.59	280.17	186.16	274.08	228.35	148.20
EBIT	-170.03	-604.66	256.76	799.96	1,001.47	496.64
Interest	281.71	547.05	296.98	299.00	54.19	39.47
Other Income	763.86	784.82	257.16	222.66	363.38	604.74
Exceptional Items	447.28	-481.54	-381.23	-3,772.29	254.59	--
Profit before Tax	759.40	-848.43	-164.28	-3,048.67	1,565.25	1,061.92
Provision for Tax	895.16	30.57	-1.94	3.38	416.52	489.93
Profit after Tax	-135.76	-879.00	-162.34	-3,052.05	1,148.73	571.98

Liabilities (₹ Cr)	TTM	Mar-14	Dec-12	Dec-11	Dec-10	Dec-09
Shareholder's Funds	1,496.54	1,096.99	1,922.08	1,924.83	5,132.39	4,134.61
Minority Interest	--	--	--	--	--	--
Non-Current Liabilities	2,203.81	3,803.85	4,095.33	3,624.47	4,260.72	2,928.47
Current Liabilities	9,505.05	9,860.73	8,609.06	9,616.17	4,238.05	3,694.90
Total Liabilities	13,205.39	14,761.57	14,626.47	15,165.48	13,631.15	11,177.88

Assets (₹ Cr)	TTM	Mar-14	Dec-12	Dec-11	Dec-10	Dec-09
Non-Current Assets	7,275.31	8,355.13	7,141.81	7,270.14	5,450.49	5,838.48
Current Assets	5,812.07	6,406.44	7,484.66	7,895.34	8,180.66	4,919.50
Total Assets	13,205.39	14,761.57	14,626.47	15,165.48	13,631.15	11,177.88
Total Debt*	--	6,182.85	4,809.82	4,333.53	4,260.72	3,348.38
Net Current Assets	-3,692.98	-3,454.28	-1,124.40	-1,720.84	3,942.61	1,224.60
Contingent Liabilities	--	1,147.88	624.69	616.55	553.77	749.57

Cashflow (₹ Cr)	TTM	Mar-14	Dec-12	Dec-11	Dec-10	Dec-09
Cash From Operating Activities	--	-1,217.10	662.08	128.38	1,168.89	-665.43
Cash Flow from Investing Activities	--	922.04	-1,691.73	1,765.14	-2,067.80	86.12
Cash from Financing Activities	--	717.28	314.55	-1,275.14	991.48	-214.14
Net Cash Inflow / Outflow	--	422.22	-715.10	618.39	92.57	-793.46

Financials Ratios	TTM	Mar-14	Dec-12	Dec-11	Dec-10	Dec-09
Adjusted EPS (₹)	-3.10	-20.76	-3.84	-72.32	27.28	13.61
Cash EPS (₹)	--	-14.15	0.56	-65.83	32.71	17.13
Adjusted Book Value (₹)	--	25.42	44.93	45.32	121.63	94.03
Dividend per Share (₹)	--	--	--	--	2.00	--
Cash Flow per Share (₹)	--	-28.75	15.66	3.04	27.76	-15.83
Free Cash Flow per Share (₹)	--	-24.65	21.92	-31.45	33.59	2.50

Profitability Ratios	TTM	Mar-14	Dec-12	Dec-11	Dec-10	Dec-09
ROCE (%)	--	-4.30	2.04	-35.14	19.19	14.79
ROE (%)	-10.47	-59.07	-8.52	-86.78	25.32	15.28
ROA (%)	-2.06	-5.98	-1.09	-21.20	9.42	5.34
EBIT Margin (%)	-2.95	-8.81	4.07	10.26	17.66	10.39
Net Margin (%)	-2.08	-11.49	-2.47	-38.05	19.04	10.62
Cash Profit Margin (%)	--	-8.67	0.38	-35.53	24.21	15.01

Growth Ratios	TTM	Mar-14	Dec-12	Dec-11	Dec-10	Dec-09
Revenue Growth (%)	2.61	8.91	-19.18	37.56	18.60	6.93
EBIT Growth (%)	78.63	--	-67.90	-20.12	101.65	129.53
Net Profit Growth (%)	92.36	-441.46	94.68	-365.69	100.83	154.75
EPS Growth (%)	92.61	-440.93	94.69	-365.08	100.54	154.74
Book Value Growth (%)	--	-43.38	-0.64	-62.66	29.55	11.85

Valuation Ratios	TTM	Mar-14	Dec-12	Dec-11	Dec-10	Dec-09
Price / Earnings	--	--	--	--	21.94	38.03
Price / Book Value	13.98	14.36	11.19	8.94	4.92	5.50
Dividend Yield (%)	--	--	--	--	0.33	--
EV/EBITDA	36.82	45.28	33.19	15.04	16.79	19.49
Close Price (₹)	627.95	364.90	503.00	404.90	598.65	517.95
High Price (₹)	698.30	490.15	578.40	611.75	624.90	538.45
Low Price (₹)	305.20	253.65	395.00	365.50	364.20	133.10
Market Cap (₹ Cr)	36,602.80	15,453.30	21,262.00	17,101.55	25,205.56	21,754.53

Solvency Ratios	TTM	Mar-14	Dec-12	Dec-11	Dec-10	Dec-09
Debt to Equity	1.32	5.75	2.53	2.27	0.83	0.85
Short term debt to equity ratio	2.50	3.21	1.46	1.52	--	--
Current Ratio	0.61	0.65	0.87	0.82	1.93	1.33
Quick Ratio	0.46	0.48	0.67	0.65	1.59	1.00
Interest Coverage	3.70	-0.55	0.45	-9.20	29.88	27.91

Operating Efficiency Ratios	TTM	Mar-14	Dec-12	Dec-11	Dec-10	Dec-09
Debtors to sales (%)	41.76	18.03	22.78	47.22	22.80	32.10
Asset Turnover	0.87	0.47	0.43	0.54	0.47	0.45
Receivable days	--	70.62	147.54	116.14	90.72	97.35
Inventory Days	--	90.52	97.63	73.42	87.29	92.40
Payable days	--	53.65	70.24	82.17	85.46	84.88
Cash Conversion Cycle	--	107.49	174.93	107.39	92.56	104.88

*TTM (Trailing Twelve Months) data based on income statement of last 4 quarters and interim half yearly balance sheet.

Income Statement (₹ Cr)