Tulip Telecom Key Ratios

Stock Card

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 %

Key Ratios and Highlights

Growth Score (%)	Quarterly		Annual (TTM)
Particulars	QoQ	YoY	1-Year	3-Years	5-Years
Revenue	-39.15	-64.54	-33.54	-3.51	6.56
EBIT	14.50	-170.24	-131.10	-173.52	-194.38
Net Profit	16.93	-386.88	-250.73	-222.09	-216.12
EPS	76.08	-386.88	-414.72	-256.04	-234.53
Book Value	--	--	--	-11.44	7.67

Key Ratios (%)	Average		Annual (TTM)
Particulars	3-Years	5-Years	TTM	Mar-13	Mar-12
EBIT-Margin	--	--	-9.09	-18.41	--
Net Margin	--	--	-49.01	-78.81	--
Return on equity	--	--	--	-73.63	--
Return on Capital	--	--	--	-15.53	--
Return on Assets	--	--	-40.71	-16.08	--
Debt to Equity (x)	--	--	2.98	5.19	--

Profitability

View Detailed Peer Comparison

ROCE

Earning before interest and taxes / (Average net worth + Average total Debt) * 100

Company Name	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09	Mar-08	Mar-07	Mar-06	Mar-05	Mar-04
Tulip Telecom	--	-15.53	22.12	18.93	19.90	20.98
Peer Median

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

ROE

Profit after tax / Average Net worth * 100

Company Name	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09	Mar-08	Mar-07	Mar-06	Mar-05	Mar-04
Tulip Telecom	--	-73.63	32.85	28.54	28.79	44.47
Peer Median	10.85	--	--	--	--	--

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

ROA

-40.71

Lower than Peers by 46.44

Profit after tax / Average Total assets * 100

Company Name	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09	Mar-08	Mar-07	Mar-06	Mar-05	Mar-04
Tulip Telecom	-40.71	-16.08	10.42	10.67	10.25	14.31
Peer Median	5.73	--	--	--	--	--

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

EBIT Margin

-9.09

Lower than Peers by 18.09

Operating profit (EBIT) / Net Sales * 100

Company Name	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09	Mar-08	Mar-07	Mar-06	Mar-05	Mar-04
Tulip Telecom	-9.09	-18.41	18.47	20.70	18.72	14.51
Peer Median	9.01	--	--	--	--	--

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

Net Margin

-49.01

Lower than Peers by 57.70

Net profit / Total Income (Net sales plus other income) * 100

Company Name	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09	Mar-08	Mar-07	Mar-06	Mar-05	Mar-04
Tulip Telecom	-49.01	-78.81	10.50	12.96	11.63	14.65
Peer Median	8.69	--	--	--	--	--

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

Cash Profit Margin

(Net profit + Depreciation) / Gross Sales * 100

Company Name	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09	Mar-08	Mar-07	Mar-06	Mar-05	Mar-04
Tulip Telecom	--	-64.63	18.92	20.28	18.66	18.08
Peer Median	--	--	--	--	--	--

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

Growth

View Detailed Peer Comparison

Revenue Growth

-33.54

Lower than Peers by 40.38

Year on year growth in net sales

Company Name	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09	Mar-08	Mar-07	Mar-06	Mar-05	Mar-04
Tulip Telecom	-33.54	-76.70	72.72	19.56	21.80	32.44
Peer Median	6.84	--	--	--	--	--

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

EBIT Growth

-131.10

Lower than Peers by 138.44

Year on year growth in operating profit (EBIT)

Company Name	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09	Mar-08	Mar-07	Mar-06	Mar-05	Mar-04
Tulip Telecom	-131.10	--	--	32.18	57.13	14.94
Peer Median	7.34	--	--	--	--	--

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

Net Profit Growth

-250.73

Lower than Peers by 259.36

Year on year growth in profit after tax

Company Name	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09	Mar-08	Mar-07	Mar-06	Mar-05	Mar-04
Tulip Telecom	-250.73	-275.18	39.93	31.82	-7.54	33.78
Peer Median	8.63	--	--	--	--	--

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

EPS Growth

-414.72

Lower than Peers by 427.27

Year on year growth in earnings per share

Company Name	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09	Mar-08	Mar-07	Mar-06	Mar-05	Mar-04
Tulip Telecom	-414.72	-275.18	39.93	31.82	-7.54	33.78
Peer Median	12.55	--	--	--	--	--

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

Book Value Growth

Year on year growth in book value per share

Company Name	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09	Mar-08	Mar-07	Mar-06	Mar-05	Mar-04
Tulip Telecom	--	-53.61	14.58	30.68	36.09	53.04
Peer Median

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

Solvency

View Detailed Peer Comparison

Debt to Equity

2.98

Higher than Peers by 2.98

Total debt / Net worth

Company Name	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09	Mar-08	Mar-07	Mar-06	Mar-05	Mar-04
Tulip Telecom	2.98	5.19	2.18	1.51	1.31	1.65
Peer Median	0.00	--	--	--	--	--

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

Short term debt to equity ratio

2.85

(Short term borrowings / Net worth)

Company Name	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09	Mar-08	Mar-07	Mar-06	Mar-05	Mar-04
Tulip Telecom	2.85	0.57	0.32	0.22	--	--
Peer Median

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

Current Ratio

0.67

Lower than Peers by 1.39

Current Assets / Current Liabilities and Provisions

Company Name	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09	Mar-08	Mar-07	Mar-06	Mar-05	Mar-04
Tulip Telecom	0.67	0.67	0.88	1.07	3.89	3.09
Peer Median	2.06	--	--	--	--	--

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

Quick Ratio

0.59

Lower than Peers by 1.47

(Current Assets - Inventory) / Current Liabilities and Provisions

Company Name	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09	Mar-08	Mar-07	Mar-06	Mar-05	Mar-04
Tulip Telecom	0.59	0.59	0.74	0.99	3.65	2.77
Peer Median	2.06	--	--	--	--	--

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

Interest Coverage

-2.44

Lower than Peers by 65.85

Earning before interest and taxes (EBIT) / Interest Expenses

Company Name	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09	Mar-08	Mar-07	Mar-06	Mar-05	Mar-04
Tulip Telecom	-2.44	-4.64	2.95	5.75	5.49	7.13
Peer Median	63.41	--	--	--	--	--

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

Operating Efficiency

View Detailed Peer Comparison

Debtors to sales

48.92

Higher than Peers by 30.40

Debtors outstanding / Net Sales * 100

Company Name	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09	Mar-08	Mar-07	Mar-06	Mar-05	Mar-04
Tulip Telecom	48.92	95.11	23.98	26.98	27.06	20.08
Peer Median	18.52	--	--	--	--	--

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

Asset Turnover

0.83

Higher than Peers by 0.33

Sales / Average Total Assets

Company Name	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09	Mar-08	Mar-07	Mar-06	Mar-05	Mar-04
Tulip Telecom	0.83	0.20	0.99	0.82	0.87	0.92
Peer Median	0.51	--	--	--	--	--

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

Receivable days

Average Debtors / Sales * 365

Company Name	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09	Mar-08	Mar-07	Mar-06	Mar-05	Mar-04
Tulip Telecom	--	361.36	72.27	90.54	79.47	59.33
Peer Median

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

Inventory Days

Average Inventory / Sales * 365

Company Name	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09	Mar-08	Mar-07	Mar-06	Mar-05	Mar-04
Tulip Telecom	--	84.51	17.72	13.04	14.89	18.30
Peer Median

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

Payable days

Average Creditors / Cost of goods sold * 365

Company Name	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09	Mar-08	Mar-07	Mar-06	Mar-05	Mar-04
Tulip Telecom	--	98.28	29.79	24.63	36.24	31.90
Peer Median

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

Cash Conversion Cycle

Receivable Days + Inventory Days - Payable Days

Company Name	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09	Mar-08	Mar-07	Mar-06	Mar-05	Mar-04
Tulip Telecom	--	347.59	60.19	78.95	58.12	45.72
Peer Median

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

Valuation

View Detailed Peer Comparison

Price / Earnings

Current share price divided by earning per share in the last twelve months

Company Name	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09	Mar-08	Mar-07	Mar-06	Mar-05	Mar-04
Tulip Telecom	--	--	1.57	6.69	2.10	0.81
Peer Median	24.67	--	--	--	--	--

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

Price / Book Value

Current share price divided by book value per share in the latest financial year

Company Name	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09	Mar-08	Mar-07	Mar-06	Mar-05	Mar-04
Tulip Telecom	--	0.20	0.48	1.68	2.63	1.49
Peer Median	0.99	--	--	--	--	--

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

Dividend Yield

Dividend per share in the past twelve months divided by current share price

Company Name	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09	Mar-08	Mar-07	Mar-06	Mar-05	Mar-04
Tulip Telecom	--	--	--	1.14	0.95	1.14
Peer Median	0.99	--	--	--	--	--

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

EV/EBITDA

26.52

Enterprise Value (Current Market Capitalisation + Total Debt - Cash & Equivalents) / Earnings before interest, taxes, depreciation and taxes (EBITDA)

Company Name	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09	Mar-08	Mar-07	Mar-06	Mar-05	Mar-04
Tulip Telecom	26.52	-101.71	3.31	5.46	6.26	4.82
Peer Median

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

Market Cap

Lower than Peers by 2,860

Current Share price multiplied by latest total number of shares outstanding

Company Name	TTM	Mar-13	Sep-12	Mar-11	Mar-10	Mar-09	Mar-08	Mar-07	Mar-06	Mar-05	Mar-04
Tulip Telecom	22	127	673	2,042	2,435	1,015
Peer Median	2,882	--	--	--	--	--

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