Celestial Biolabs Key Ratios
NSE: CELESTIAL | BSE: 532871
₹1.75
As on 11-Mar-2020IST
Market cap
₹5 Cr
Revenue (TTM)
₹0 Cr
P/E Ratio
--
P/B Ratio
0
Div. Yield
0 %
Key Ratios and Highlights
| Growth Score (%) | Quarterly | Annual (TTM) | |||
|---|---|---|---|---|---|
| Particulars | QoQ | YoY | 1-Year | 3-Years | 5-Years |
| Revenue | 2.78 | 8.82 | -30.93 | -68.16 | -70.73 |
| EBIT | -6.25 | 77.78 | 34.59 | -10.49 | -161.06 |
| Net Profit | -9.38 | 77.27 | 34.64 | -182.79 | -163.73 |
| EPS | -9.15 | 77.27 | 34.65 | -182.79 | -163.73 |
| Book Value | -- | -- | -17.07 | -10.92 | -51.38 |
| Key Ratios (%) | Average | Annual (TTM) | |||
|---|---|---|---|---|---|
| Particulars | 3-Years | 5-Years | TTM | Mar-23 | Mar-22 |
| EBIT-Margin
| -293.67 | -615.99 | -302.99 | -339.72 | -249.69 |
| Net Margin
| -- | -932.62 | -308.96 | -- | -- |
| Return on equity
| -11.55 | -43.97 | -15.00 | -18.99 | -12.22 |
| Return on Capital
| -2.48 | -31.06 | -- | -3.86 | -2.47 |
| Return on Assets
| -2.24 | -30.15 | -4.82 | -3.38 | -2.38 |
| Debt to Equity (x)
| -- | -- | 3.40 | 4.34 | 3.44 |
Profitability
ROCE
--
--
Earning before interest and taxes / (Average net worth + Average total Debt) * 100
|
Company Name
|
TTM
|
Mar-23
|
Mar-22
|
Mar-21
|
Mar-20
|
|---|---|---|---|---|---|
|
Celestial Biolabs
|
--
|
-3.86
|
-2.47
|
--
|
--
|
|
Peer Median
|
--
|
18.85
|
11.60
|
11.89
|
12.20
|
ROE
-15.00
Lower than Peers by 25.85
Profit after tax / Average Net worth * 100
|
Company Name
|
TTM
|
Mar-23
|
Mar-22
|
Mar-21
|
Mar-20
|
|---|---|---|---|---|---|
|
Celestial Biolabs
|
-15.00
|
-18.99
|
-12.22
|
--
|
--
|
|
Peer Median
|
10.86
|
14.92
|
11.46
|
13.43
|
10.09
|
ROA
-4.82
Lower than Peers by 11.56
Profit after tax / Average Total assets * 100
|
Company Name
|
TTM
|
Mar-23
|
Mar-22
|
Mar-21
|
Mar-20
|
|---|---|---|---|---|---|
|
Celestial Biolabs
|
-4.82
|
-3.38
|
-2.38
|
--
|
--
|
|
Peer Median
|
6.74
|
9.06
|
6.44
|
7.03
|
5.74
|
EBIT Margin
-302.99
Lower than Peers by 315.68
Operating profit (EBIT) / Net Sales * 100
|
Company Name
|
TTM
|
Mar-23
|
Mar-22
|
Mar-21
|
Mar-20
|
|---|---|---|---|---|---|
|
Celestial Biolabs
|
-302.99
|
-339.72
|
-249.69
|
--
|
--
|
|
Peer Median
|
12.69
|
14.71
|
12.37
|
16.50
|
13.87
|
Net Margin
-308.96
Lower than Peers by 317.82
Net profit / Total Income (Net sales plus other income) * 100
|
Company Name
|
TTM
|
Mar-23
|
Mar-22
|
Mar-21
|
Mar-20
|
|---|---|---|---|---|---|
|
Celestial Biolabs
|
-308.96
|
-344.64
|
-277.63
|
--
|
--
|
|
Peer Median
|
8.86
|
8.49
|
10.02
|
10.49
|
8.84
|
Cash Profit Margin
0.00
--
(Net profit + Depreciation) / Gross Sales * 100
|
Company Name
|
TTM
|
Mar-23
|
Mar-22
|
Mar-21
|
Mar-20
|
|---|---|---|---|---|---|
|
Celestial Biolabs
|
0.00
|
-327.86
|
-257.15
|
--
|
--
|
|
Peer Median
|
--
|
--
|
--
|
--
|
--
|
Revenue Growth
-30.93
Lower than Peers by 39.07
Year on year growth in net sales
|
Company Name
|
TTM
|
Mar-23
|
Mar-22
|
Mar-21
|
Mar-20
|
|---|---|---|---|---|---|
|
Celestial Biolabs
|
-30.93
|
14.37
|
--
|
--
|
--
|
|
Peer Median
|
8.14
|
11.85
|
9.08
|
13.45
|
3.43
|
EBIT Growth
33.44
Higher than Peers by 16.20
Year on year growth in operating profit (EBIT)
|
Company Name
|
TTM
|
Mar-23
|
Mar-22
|
Mar-21
|
Mar-20
|
|---|---|---|---|---|---|
|
Celestial Biolabs
|
33.44
|
-55.61
|
--
|
--
|
--
|
|
Peer Median
|
17.24
|
28.00
|
-3.12
|
18.27
|
3.48
|
Net Profit Growth
34.64
Higher than Peers by 17.79
Year on year growth in profit after tax
|
Company Name
|
TTM
|
Mar-23
|
Mar-22
|
Mar-21
|
Mar-20
|
|---|---|---|---|---|---|
|
Celestial Biolabs
|
34.64
|
-41.98
|
--
|
--
|
--
|
|
Peer Median
|
16.85
|
36.51
|
-0.85
|
27.20
|
-8.07
|
EPS Growth
34.65
Higher than Peers by 24.05
Year on year growth in earnings per share
|
Company Name
|
TTM
|
Mar-23
|
Mar-22
|
Mar-21
|
Mar-20
|
|---|---|---|---|---|---|
|
Celestial Biolabs
|
34.65
|
-40.82
|
--
|
--
|
--
|
|
Peer Median
|
10.60
|
--
|
-6.82
|
16.28
|
-5.54
|
Book Value Growth
--
--
Year on year growth in book value per share
|
Company Name
|
TTM
|
Mar-23
|
Mar-22
|
Mar-21
|
Mar-20
|
|---|---|---|---|---|---|
|
Celestial Biolabs
|
--
|
-17.21
|
--
|
--
|
--
|
|
Peer Median
|
--
|
--
|
--
|
--
|
--
|
Solvency
Debt to Equity
3.40
Higher than Peers by 3.36
Total debt / Net worth
|
Company Name
|
TTM
|
Mar-23
|
Mar-22
|
Mar-21
|
Mar-20
|
|---|---|---|---|---|---|
|
Celestial Biolabs
|
3.40
|
4.34
|
3.44
|
--
|
--
|
|
Peer Median
|
0.04
|
0.20
|
0.15
|
0.15
|
0.26
|
Short term debt to equity ratio
--
--
(Short term borrowings / Net worth)
|
Company Name
|
TTM
|
Mar-23
|
Mar-22
|
Mar-21
|
Mar-20
|
|---|---|---|---|---|---|
|
Celestial Biolabs
|
--
|
1.10
|
0.91
|
--
|
--
|
|
Peer Median
|
--
|
--
|
--
|
--
|
--
|
Current Ratio
0.77
Lower than Peers by 0.95
Current Assets / Current Liabilities and Provisions
|
Company Name
|
TTM
|
Mar-23
|
Mar-22
|
Mar-21
|
Mar-20
|
|---|---|---|---|---|---|
|
Celestial Biolabs
|
0.77
|
0.79
|
0.80
|
--
|
--
|
|
Peer Median
|
1.72
|
1.96
|
2.08
|
1.89
|
1.74
|
Quick Ratio
0.77
Lower than Peers by 0.41
(Current Assets - Inventory) / Current Liabilities and Provisions
|
Company Name
|
TTM
|
Mar-23
|
Mar-22
|
Mar-21
|
Mar-20
|
|---|---|---|---|---|---|
|
Celestial Biolabs
|
0.77
|
0.78
|
0.79
|
--
|
--
|
|
Peer Median
|
1.17
|
1.44
|
1.58
|
1.64
|
1.32
|
Interest Coverage
-50.75
Lower than Peers by 58.61
Earning before interest and taxes (EBIT) / Interest Expenses
|
Company Name
|
TTM
|
Mar-23
|
Mar-22
|
Mar-21
|
Mar-20
|
|---|---|---|---|---|---|
|
Celestial Biolabs
|
-50.75
|
-69.05
|
-8.94
|
--
|
--
|
|
Peer Median
|
7.86
|
8.58
|
15.41
|
15.38
|
12.04
|
Operating Efficiency
Debtors to sales
2,738.06
Higher than Peers by 2,712.27
Debtors outstanding / Net Sales * 100
|
Company Name
|
TTM
|
Mar-23
|
Mar-22
|
Mar-21
|
Mar-20
|
|---|---|---|---|---|---|
|
Celestial Biolabs
|
2,738.06
|
2,197.75
|
2,598.51
|
--
|
--
|
|
Peer Median
|
25.79
|
26.12
|
22.96
|
20.72
|
22.06
|
Asset Turnover
0.02
Lower than Peers by 0.65
Sales / Average Total Assets
|
Company Name
|
TTM
|
Mar-23
|
Mar-22
|
Mar-21
|
Mar-20
|
|---|---|---|---|---|---|
|
Celestial Biolabs
|
0.02
|
0.01
|
0.01
|
--
|
--
|
|
Peer Median
|
0.67
|
0.77
|
0.65
|
0.61
|
0.51
|
Receivable days
--
--
Average Debtors / Sales * 365
|
Company Name
|
TTM
|
Mar-23
|
Mar-22
|
Mar-21
|
Mar-20
|
|---|---|---|---|---|---|
|
Celestial Biolabs
|
--
|
8,157.22
|
9,484.56
|
--
|
--
|
|
Peer Median
|
--
|
--
|
--
|
--
|
--
|
Inventory Days
--
--
Average Inventory / Sales * 365
|
Company Name
|
TTM
|
Mar-23
|
Mar-22
|
Mar-21
|
Mar-20
|
|---|---|---|---|---|---|
|
Celestial Biolabs
|
--
|
89.36
|
120.76
|
--
|
--
|
|
Peer Median
|
--
|
--
|
--
|
--
|
--
|
Payable days
--
--
Average Creditors / Cost of goods sold * 365
|
Company Name
|
TTM
|
Mar-23
|
Mar-22
|
Mar-21
|
Mar-20
|
|---|---|---|---|---|---|
|
Celestial Biolabs
|
--
|
1,398.94
|
1,528.77
|
--
|
--
|
|
Peer Median
|
--
|
--
|
--
|
--
|
--
|
Cash Conversion Cycle
--
--
Receivable Days + Inventory Days - Payable Days
|
Company Name
|
TTM
|
Mar-23
|
Mar-22
|
Mar-21
|
Mar-20
|
|---|---|---|---|---|---|
|
Celestial Biolabs
|
--
|
6,847.64
|
8,076.55
|
--
|
--
|
|
Peer Median
|
--
|
--
|
--
|
--
|
--
|
Valuation
Price / Earnings
--
--
Current share price divided by earning per share in the last twelve months
|
Company Name
|
TTM
|
Mar-23
|
Mar-22
|
Mar-21
|
Mar-20
|
|---|---|---|---|---|---|
|
Celestial Biolabs
|
--
|
--
|
--
|
--
|
--
|
|
Peer Median
|
39.76
|
33.48
|
37.74
|
60.11
|
64.03
|
Price / Book Value
0.05
Lower than Peers by 4.17
Current share price divided by book value per share in the latest financial year
|
Company Name
|
TTM
|
Mar-23
|
Mar-22
|
Mar-21
|
Mar-20
|
|---|---|---|---|---|---|
|
Celestial Biolabs
|
0.05
|
--
|
--
|
--
|
--
|
|
Peer Median
|
4.21
|
4.21
|
3.22
|
3.92
|
3.87
|
Dividend Yield
--
--
Dividend per share in the past twelve months divided by current share price
|
Company Name
|
TTM
|
Mar-23
|
Mar-22
|
Mar-21
|
Mar-20
|
|---|---|---|---|---|---|
|
Celestial Biolabs
|
--
|
--
|
--
|
--
|
--
|
|
Peer Median
|
0.10
|
0.21
|
0.57
|
0.56
|
0.61
|
EV/EBITDA
1.36
--
Enterprise Value (Current Market Capitalisation + Total Debt - Cash & Equivalents) / Earnings before interest, taxes, depreciation and taxes (EBITDA)
|
Company Name
|
TTM
|
Mar-23
|
Mar-22
|
Mar-21
|
Mar-20
|
|---|---|---|---|---|---|
|
Celestial Biolabs
|
1.36
|
-63.50
|
-100.93
|
--
|
--
|
|
Peer Median
|
--
|
29.90
|
28.81
|
25.94
|
28.78
|
Market Cap
5
Lower than Peers by 7,379
Current Share price multiplied by latest total number of shares outstanding
|
Company Name
|
TTM
|
Mar-23
|
Mar-22
|
Mar-21
|
Mar-20
|
|---|---|---|---|---|---|
|
Celestial Biolabs
|
5
|
--
|
--
|
--
|
--
|
|
Peer Median
|
7,384
|
2,099
|
15,272
|
13,501
|
14,139
|