Tulip Telecom Key Ratios
NSE: TULIP | BSE: 532691
₹1.53
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
ROCE
--
--
Earning before interest and taxes / (Average net worth + Average total Debt) * 100
|
Company Name
|
TTM
|
Mar-13
|
Sep-12
|
Mar-11
|
Mar-10
|
|---|---|---|---|---|---|
|
Tulip Telecom
|
--
|
-15.53
|
22.12
|
18.93
|
19.90
|
|
Peer Median
|
--
|
--
|
--
|
--
|
--
|
ROE
--
--
Profit after tax / Average Net worth * 100
|
Company Name
|
TTM
|
Mar-13
|
Sep-12
|
Mar-11
|
Mar-10
|
|---|---|---|---|---|---|
|
Tulip Telecom
|
--
|
-73.63
|
32.85
|
28.54
|
28.79
|
|
Peer Median
|
15.20
|
--
|
--
|
--
|
--
|
ROA
-40.71
Lower than Peers by 45.67
Profit after tax / Average Total assets * 100
|
Company Name
|
TTM
|
Mar-13
|
Sep-12
|
Mar-11
|
Mar-10
|
|---|---|---|---|---|---|
|
Tulip Telecom
|
-40.71
|
-16.08
|
10.42
|
10.67
|
10.25
|
|
Peer Median
|
4.95
|
--
|
--
|
--
|
--
|
EBIT Margin
-9.09
Lower than Peers by 18.19
Operating profit (EBIT) / Net Sales * 100
|
Company Name
|
TTM
|
Mar-13
|
Sep-12
|
Mar-11
|
Mar-10
|
|---|---|---|---|---|---|
|
Tulip Telecom
|
-9.09
|
-18.41
|
18.47
|
20.70
|
18.72
|
|
Peer Median
|
9.11
|
--
|
--
|
--
|
--
|
Net Margin
-49.01
Lower than Peers by 57.55
Net profit / Total Income (Net sales plus other income) * 100
|
Company Name
|
TTM
|
Mar-13
|
Sep-12
|
Mar-11
|
Mar-10
|
|---|---|---|---|---|---|
|
Tulip Telecom
|
-49.01
|
-78.81
|
10.50
|
12.96
|
11.63
|
|
Peer Median
|
8.54
|
--
|
--
|
--
|
--
|
Cash Profit Margin
--
--
(Net profit + Depreciation) / Gross Sales * 100
|
Company Name
|
TTM
|
Mar-13
|
Sep-12
|
Mar-11
|
Mar-10
|
|---|---|---|---|---|---|
|
Tulip Telecom
|
--
|
-64.63
|
18.92
|
20.28
|
18.66
|
|
Peer Median
|
--
|
--
|
--
|
--
|
--
|
Revenue Growth
-33.54
Lower than Peers by 39.96
Year on year growth in net sales
|
Company Name
|
TTM
|
Mar-13
|
Sep-12
|
Mar-11
|
Mar-10
|
|---|---|---|---|---|---|
|
Tulip Telecom
|
-33.54
|
-76.70
|
72.72
|
19.56
|
21.80
|
|
Peer Median
|
6.42
|
--
|
--
|
--
|
--
|
EBIT Growth
-131.10
Lower than Peers by 149.03
Year on year growth in operating profit (EBIT)
|
Company Name
|
TTM
|
Mar-13
|
Sep-12
|
Mar-11
|
Mar-10
|
|---|---|---|---|---|---|
|
Tulip Telecom
|
-131.10
|
--
|
--
|
32.18
|
57.13
|
|
Peer Median
|
17.93
|
--
|
--
|
--
|
--
|
Net Profit Growth
-250.73
Lower than Peers by 262.81
Year on year growth in profit after tax
|
Company Name
|
TTM
|
Mar-13
|
Sep-12
|
Mar-11
|
Mar-10
|
|---|---|---|---|---|---|
|
Tulip Telecom
|
-250.73
|
-275.18
|
39.93
|
31.82
|
-7.54
|
|
Peer Median
|
12.08
|
--
|
--
|
--
|
--
|
EPS Growth
-414.72
Lower than Peers by 431.05
Year on year growth in earnings per share
|
Company Name
|
TTM
|
Mar-13
|
Sep-12
|
Mar-11
|
Mar-10
|
|---|---|---|---|---|---|
|
Tulip Telecom
|
-414.72
|
-275.18
|
39.93
|
31.82
|
-7.54
|
|
Peer Median
|
16.33
|
--
|
--
|
--
|
--
|
Book Value Growth
--
--
Year on year growth in book value per share
|
Company Name
|
TTM
|
Mar-13
|
Sep-12
|
Mar-11
|
Mar-10
|
|---|---|---|---|---|---|
|
Tulip Telecom
|
--
|
-53.61
|
14.58
|
30.68
|
36.09
|
|
Peer Median
|
--
|
--
|
--
|
--
|
--
|
Solvency
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
|
|---|---|---|---|---|---|
|
Tulip Telecom
|
2.98
|
5.19
|
2.18
|
1.51
|
1.31
|
|
Peer Median
|
0.00
|
--
|
--
|
--
|
--
|
Short term debt to equity ratio
2.85
--
(Short term borrowings / Net worth)
|
Company Name
|
TTM
|
Mar-13
|
Sep-12
|
Mar-11
|
Mar-10
|
|---|---|---|---|---|---|
|
Tulip Telecom
|
2.85
|
0.57
|
0.32
|
0.22
|
--
|
|
Peer Median
|
--
|
--
|
--
|
--
|
--
|
Current Ratio
0.67
Higher than Peers by 0.05
Current Assets / Current Liabilities and Provisions
|
Company Name
|
TTM
|
Mar-13
|
Sep-12
|
Mar-11
|
Mar-10
|
|---|---|---|---|---|---|
|
Tulip Telecom
|
0.67
|
0.67
|
0.88
|
1.07
|
3.89
|
|
Peer Median
|
0.62
|
--
|
--
|
--
|
--
|
Quick Ratio
0.59
Lower than Peers by 0.01
(Current Assets - Inventory) / Current Liabilities and Provisions
|
Company Name
|
TTM
|
Mar-13
|
Sep-12
|
Mar-11
|
Mar-10
|
|---|---|---|---|---|---|
|
Tulip Telecom
|
0.59
|
0.59
|
0.74
|
0.99
|
3.65
|
|
Peer Median
|
0.60
|
--
|
--
|
--
|
--
|
Interest Coverage
-2.44
Lower than Peers by 7.07
Earning before interest and taxes (EBIT) / Interest Expenses
|
Company Name
|
TTM
|
Mar-13
|
Sep-12
|
Mar-11
|
Mar-10
|
|---|---|---|---|---|---|
|
Tulip Telecom
|
-2.44
|
-4.64
|
2.95
|
5.75
|
5.49
|
|
Peer Median
|
4.63
|
--
|
--
|
--
|
--
|
Operating Efficiency
Debtors to sales
48.92
Higher than Peers by 38.56
Debtors outstanding / Net Sales * 100
|
Company Name
|
TTM
|
Mar-13
|
Sep-12
|
Mar-11
|
Mar-10
|
|---|---|---|---|---|---|
|
Tulip Telecom
|
48.92
|
95.11
|
23.98
|
26.98
|
27.06
|
|
Peer Median
|
10.36
|
--
|
--
|
--
|
--
|
Asset Turnover
0.83
Higher than Peers by 0.43
Sales / Average Total Assets
|
Company Name
|
TTM
|
Mar-13
|
Sep-12
|
Mar-11
|
Mar-10
|
|---|---|---|---|---|---|
|
Tulip Telecom
|
0.83
|
0.20
|
0.99
|
0.82
|
0.87
|
|
Peer Median
|
0.40
|
--
|
--
|
--
|
--
|
Receivable days
--
--
Average Debtors / Sales * 365
|
Company Name
|
TTM
|
Mar-13
|
Sep-12
|
Mar-11
|
Mar-10
|
|---|---|---|---|---|---|
|
Tulip Telecom
|
--
|
361.36
|
72.27
|
90.54
|
79.47
|
|
Peer Median
|
--
|
--
|
--
|
--
|
--
|
Inventory Days
--
--
Average Inventory / Sales * 365
|
Company Name
|
TTM
|
Mar-13
|
Sep-12
|
Mar-11
|
Mar-10
|
|---|---|---|---|---|---|
|
Tulip Telecom
|
--
|
84.51
|
17.72
|
13.04
|
14.89
|
|
Peer Median
|
--
|
--
|
--
|
--
|
--
|
Payable days
--
--
Average Creditors / Cost of goods sold * 365
|
Company Name
|
TTM
|
Mar-13
|
Sep-12
|
Mar-11
|
Mar-10
|
|---|---|---|---|---|---|
|
Tulip Telecom
|
--
|
98.28
|
29.79
|
24.63
|
36.24
|
|
Peer Median
|
--
|
--
|
--
|
--
|
--
|
Cash Conversion Cycle
--
--
Receivable Days + Inventory Days - Payable Days
|
Company Name
|
TTM
|
Mar-13
|
Sep-12
|
Mar-11
|
Mar-10
|
|---|---|---|---|---|---|
|
Tulip Telecom
|
--
|
347.59
|
60.19
|
78.95
|
58.12
|
|
Peer Median
|
--
|
--
|
--
|
--
|
--
|
Valuation
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
|
|---|---|---|---|---|---|
|
Tulip Telecom
|
--
|
--
|
1.57
|
6.69
|
2.10
|
|
Peer Median
|
24.73
|
--
|
--
|
--
|
--
|
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
|
|---|---|---|---|---|---|
|
Tulip Telecom
|
--
|
0.20
|
0.48
|
1.68
|
2.63
|
|
Peer Median
|
1.14
|
--
|
--
|
--
|
--
|
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
|
|---|---|---|---|---|---|
|
Tulip Telecom
|
--
|
--
|
--
|
1.14
|
0.95
|
|
Peer Median
|
1.04
|
--
|
--
|
--
|
--
|
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
|
|---|---|---|---|---|---|
|
Tulip Telecom
|
26.52
|
-101.71
|
3.31
|
5.46
|
6.26
|
|
Peer Median
|
--
|
--
|
--
|
--
|
--
|
Market Cap
22
Lower than Peers by 48,126
Current Share price multiplied by latest total number of shares outstanding
|
Company Name
|
TTM
|
Mar-13
|
Sep-12
|
Mar-11
|
Mar-10
|
|---|---|---|---|---|---|
|
Tulip Telecom
|
22
|
127
|
673
|
2,042
|
2,435
|
|
Peer Median
|
48,148
|
--
|
--
|
--
|
--
|