Tulip Telecom Financials

NSE: TULIP | BSE: 532691

₹1.53

₹0.05 (3.38%)

As on 30-Mar-2015IST

Market cap

₹22 Cr

Revenue (TTM)

₹1,839 Cr

P/E Ratio

P/B Ratio

Div. Yield

0 %

Income Statement (₹ Cr)	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09
Operating Revenue	1,839.46	946.22	4,060.76	2,351.05	1,966.40	1,614.40
Total Income	1,830.77	949.63	4,067.03	2,355.18	1,991.43	1,709.83
Total Expenditure	1,711.48	983.50	2,969.89	1,693.09	1,462.99	1,338.69
EBITDA	127.98	-37.28	1,090.87	657.96	503.41	275.71
Depreciation	295.10	136.92	340.96	171.38	135.29	41.43
EBIT	-167.12	-174.20	749.91	486.58	368.13	234.28
Interest	269.98	140.67	279.90	85.32	71.59	46.21
Other Income	-8.69	3.41	6.27	4.13	25.03	95.43
Exceptional Items	--	-482.49	68.46	--	--	--
Profit before Tax	-928.27	-793.95	544.75	405.40	321.57	283.50
Provision for Tax	-30.99	-45.51	117.51	100.07	89.94	32.97
Profit after Tax	-897.28	-748.44	427.24	305.33	231.63	250.53
Minority Interest	--	--	--	--	--	--
Share of Associate	--	--	--	--	--	--
Consolidated Profit	-897.28	-748.44	427.24	305.33	231.63	250.53

Liabilities (₹ Cr)	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09
Shareholder's Funds	644.31	644.31	1,389.20	1,212.53	927.86	681.93
Minority Interest	--	--	--	--	--	--
Non-Current Liabilities	1,927.66	1,921.95	1,451.14	936.91	1,222.01	1,123.37
Current Liabilities	1,836.06	1,836.06	2,067.32	1,142.12	283.85	282.14
Total Liabilities	4,408.02	4,408.02	4,907.66	3,291.56	2,433.72	2,087.44

Assets (₹ Cr)	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09
Non-Current Assets	3,168.01	3,175.92	3,091.51	2,066.38	1,329.68	1,214.82
Current Assets	1,226.39	1,226.39	1,815.75	1,224.76	1,103.69	872.21
Total Assets	4,408.02	4,408.02	4,907.66	3,291.56	2,433.72	2,087.44
Total Debt*	--	3,346.79	3,032.17	1,824.66	1,219.09	1,122.45
Net Current Assets	-609.67	-609.66	-251.57	82.63	819.84	590.07
Contingent Liabilities	--	1,484.22	1,596.13	122.65	92.27	221.21

Cashflow (₹ Cr)	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09
Cash From Operating Activities	--	9.80	428.77	342.06	184.90	288.49
Cash Flow from Investing Activities	--	-186.59	-1,314.21	-813.77	-134.16	-267.87
Cash from Financing Activities	--	173.95	678.34	445.40	95.22	67.56
Net Cash Inflow / Outflow	--	-2.85	-207.10	-26.31	145.96	88.18

Financials Ratios	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09
Adjusted EPS (₹)	-29.64	-51.62	29.46	21.06	15.97	17.28
Cash EPS (₹)	--	-42.17	52.98	32.88	25.30	20.14
Adjusted Book Value (₹)	--	44.43	95.78	83.59	63.97	47.00
Dividend per Share (₹)	--	--	--	1.60	1.60	0.80
Cash Flow per Share (₹)	--	0.68	29.57	23.59	63.76	99.48
Free Cash Flow per Share (₹)	--	-57.52	-89.03	-32.55	-39.46	-159.28

Profitability Ratios	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09
ROCE (%)	--	-15.53	22.12	18.93	19.90	20.98
ROE (%)	--	-73.63	32.85	28.54	28.79	44.47
ROA (%)	-40.71	-16.08	10.42	10.67	10.25	14.31
EBIT Margin (%)	-9.09	-18.41	18.47	20.70	18.72	14.51
Net Margin (%)	-49.01	-78.81	10.50	12.96	11.63	14.65
Cash Profit Margin (%)	--	-64.63	18.92	20.28	18.66	18.08

Growth Ratios	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09
Revenue Growth (%)	-33.54	-76.70	72.72	19.56	21.80	32.44
EBIT Growth (%)	-131.10	--	--	32.18	57.13	14.94
Net Profit Growth (%)	-250.73	-275.18	39.93	31.82	-7.54	33.78
EPS Growth (%)	-414.72	-275.18	39.93	31.82	-7.54	33.78
Book Value Growth (%)	--	-53.61	14.58	30.68	36.09	53.04

Valuation Ratios	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09
Price / Earnings	--	--	1.57	6.69	2.10	0.81
Price / Book Value	--	0.20	0.48	1.68	2.63	1.49
Dividend Yield (%)	--	--	--	1.14	0.95	1.14
EV/EBITDA	26.52	-101.71	3.31	5.46	6.26	4.82
Close Price (₹)	7.25	8.70	45.60	140.45	168.17	69.77
High Price (₹)	129.00	129.00	164.95	201.40	250.00	233.40
Low Price (₹)	6.66	8.50	41.30	132.00	69.60	51.61
Market Cap (₹ Cr)	22.19	126.73	672.80	2,041.60	2,434.84	1,014.86

Solvency Ratios	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09
Debt to Equity	2.98	5.19	2.18	1.51	1.31	1.65
Short term debt to equity ratio	2.85	0.57	0.32	0.22	--	--
Current Ratio	0.67	0.67	0.88	1.07	3.89	3.09
Quick Ratio	0.59	0.59	0.74	0.99	3.65	2.77
Interest Coverage	-2.44	-4.64	2.95	5.75	5.49	7.13

Operating Efficiency Ratios	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09
Debtors to sales (%)	48.92	95.11	23.98	26.98	27.06	20.08
Asset Turnover	0.83	0.20	0.99	0.82	0.87	0.92
Receivable days	--	361.36	72.27	90.54	79.47	59.33
Inventory Days	--	84.51	17.72	13.04	14.89	18.30
Payable days	--	98.28	29.79	24.63	36.24	31.90
Cash Conversion Cycle	--	347.59	60.19	78.95	58.12	45.72

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

Income Statement (₹ Cr)