BHARTI AIRTEL LTD.
Financial ratio
Particulars | Mar 2023 | Mar 2022 | Mar 2021 | Mar 2020 | Mar 2019 |
---|---|---|---|---|---|
Operational & Financial Ratios | |||||
Earnings Per Share (Rs) | 14.71 | 7.61 | -27.46 | -58.99 | 1.02 |
CEPS(Rs) | 85.88 | 74.05 | 10.69 | -11.73 | 51.90 |
DPS(Rs) | 4.00 | 3.00 | 0.00 | 2.00 | 2.50 |
Book NAV/Share(Rs) | 136.41 | 118.88 | 107.18 | 141.28 | 178.49 |
Tax Rate(%) | 25.80 | 33.47 | -61.65 | 27.12 | 197.44 |
Margin Ratios | |||||
Core EBITDA Margin(%) | 51.22 | 49.37 | 45.09 | 40.45 | 29.90 |
EBIT Margin(%) | 25.77 | 24.97 | 0.60 | -37.86 | 11.01 |
Pre Tax Margin(%) | 11.90 | 10.71 | -14.40 | -54.48 | -2.14 |
PAT Margin (%) | 8.83 | 7.13 | -23.28 | -39.70 | 2.09 |
Cash Profit Margin (%) | 35.01 | 35.52 | 5.95 | -7.70 | 28.52 |
Performance Ratios | |||||
ROA(%) | 3.19 | 2.48 | -7.10 | -11.21 | 0.66 |
ROE(%) | 17.08 | 13.25 | -34.46 | -45.30 | 2.40 |
ROCE(%) | 16.21 | 14.99 | 0.31 | -16.57 | 4.77 |
Asset Turnover(x) | 0.36 | 0.35 | 0.31 | 0.28 | 0.31 |
Sales/Fixed Asset(x) | 0.31 | 0.29 | 0.27 | 0.24 | 0.26 |
Working Capital/Sales(x) | -2.16 | -1.88 | -1.76 | -1.54 | -1.34 |
Efficiency Ratios | |||||
Fixed Capital/Sales(x) | 3.26 | 3.45 | 3.77 | 4.16 | 3.85 |
Receivable days | 10.54 | 12.05 | 14.96 | 19.20 | 23.01 |
Inventory Days | 0.83 | 1.00 | 0.77 | 0.53 | 0.36 |
Payable days | 3379.84 | 4074.38 | 5246.73 | 7137.84 | 8938.78 |
Valuation Parameters | |||||
PER(x) | 50.91 | 99.24 | 0.00 | 0.00 | 292.69 |
PCE(x) | 8.72 | 10.20 | 47.48 | -36.85 | 5.78 |
Price/Book(x) | 5.49 | 6.35 | 4.83 | 3.12 | 1.87 |
Yield(%) | 0.53 | 0.40 | 0.00 | 0.45 | 0.75 |
EV/Net Sales(x) | 4.15 | 4.65 | 3.98 | 4.04 | 3.04 |
EV/Core EBITDA(x) | 7.99 | 9.33 | 8.70 | 9.56 | 9.12 |
EV/EBIT(x) | 16.09 | 18.62 | 664.27 | -10.67 | 27.63 |
EV/CE(x) | 1.35 | 1.58 | 1.23 | 1.02 | 0.92 |
M Cap / Sales | 3.05 | 3.62 | 2.82 | 2.84 | 1.65 |
Growth Ratio | |||||
Net Sales Growth(%) | 19.39 | 15.83 | 18.82 | 4.82 | -2.25 |
Core EBITDA Growth(%) | 24.35 | 26.20 | 28.57 | 32.78 | -14.62 |
EBIT Growth(%) | 23.24 | 4727.36 | 101.88 | -460.58 | -29.40 |
PAT Growth(%) | 47.95 | 135.46 | 30.33 | -2092.18 | -22.72 |
EPS Growth(%) | 93.27 | 127.71 | 53.44 | -5858.60 | -62.74 |
Financial Stability Ratios | |||||
Total Debt/Equity(x) | 2.14 | 2.00 | 2.20 | 1.53 | 1.69 |
Current Ratio(x) | 0.47 | 0.46 | 0.49 | 0.58 | 0.35 |
Quick Ratio(x) | 0.47 | 0.45 | 0.49 | 0.58 | 0.35 |
Interest Cover(x) | 1.86 | 1.75 | 0.04 | -2.28 | 0.84 |
Total Debt/Mcap(x) | 0.37 | 0.30 | 0.46 | 0.49 | 0.91 |