Management Efficiency Ratios of Bharti Airtel Ltd. (BHARTIARTL)
Valuation Ratio Profitability Ratio Solvency Ratio Efficiency Ratio
Efficiency Ratios of Bharti Airtel Ltd.
| Year | Mar-25 | Mar-24 | Mar-23 | Mar-22 | Mar-21 | Mar-20 | Mar-19 | Mar-18 | Mar-17 | Mar-16 | Mar-15 | Mar-14 | Mar-13 | Mar-12 | Mar-11 | Mar-10 | Mar-09 | Mar-08 | Mar-07 | Mar-06 | Mar-05 | Mar-04 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Cash ratio | 0.093 | 0.118 | 0.110 | 0.118 | 0.121 | 0.121 | 0.087 | 0.085 | 0.080 | 0.087 | 0.0316 | 0.088 | 0.0384 | 0.0415 | 0.0259 | 0.150 | 0.138 | 0.0412 | 0.073 | 0.0379 | 0.079 | 0.062 |
| Quick ratio | 0.372 | 0.418 | 0.469 | 0.453 | 0.488 | 0.582 | 0.352 | 0.427 | 0.286 | 0.387 | 0.330 | 0.392 | 0.448 | 0.300 | 0.297 | 0.665 | 0.591 | 0.478 | 0.453 | 0.356 | 0.460 | 0.668 |
| Current ratio | 0.375 | 0.420 | 0.471 | 0.456 | 0.490 | 0.583 | 0.353 | 0.428 | 0.287 | 0.390 | 0.333 | 0.394 | 0.450 | 0.303 | 0.303 | 0.668 | 0.595 | 0.485 | 0.461 | 0.361 | 0.470 | 0.682 |
| Inventory Turnover | 133.66 | 303.89 | 151.49 | 133.68 | 204.59 | 284.67 | 456.09 | 573.84 | 333.48 | 239.06 | 326.81 | 341.14 | 305.36 | 183.38 | 169.05 | 146.37 | 96.61 | 66.44 | 75.19 | 69.41 | 54.65 | 0 |
| Days In Working Capital | -238.12 | -195.64 | -169.10 | -194.16 | -206.35 | -228.68 | -271.78 | -194.56 | -172.81 | -135.38 | -147.58 | -87.12 | -87.75 | -80.56 | -134.62 | -72.27 | -76.21 | -129.80 | -126.43 | -137.13 | -105.47 | 0 |
| Cash Turnover Ratio | 10.35 | 9.18 | 10.37 | 8.64 | 7.47 | 5.51 | 10.02 | 12.58 | 18.75 | 18.93 | 46.13 | 17.24 | 46.46 | 35.22 | 62.25 | 16.22 | 13.50 | 38.40 | 21.62 | 33.23 | 19.80 | 36.94 |
| Accruals Ratio | -0.0073 | -0.0132 | -0.0407 | -0.0163 | -0.086 | -0.082 | 0.0367 | -0.0098 | -0.0093 | 0.0249 | -0.0433 | -0.064 | 0.0136 | 0.0271 | 0.0403 | 0.131 | 0.126 | 0.0132 | 0.142 | 0.102 | 0.0094 | 0.052 |
| Account Receivable Turnover Ratio | 28.40 | 31.72 | 31.95 | 26.54 | 24.06 | 18.76 | 17.89 | 15.82 | 20.19 | 18.87 | 19.35 | 15.65 | 14.13 | 12.88 | 11.66 | 10.58 | 9.79 | 7.14 | 5.58 | 3.99 | 2.97 | 1.90 |
| Account Receivable Day | 12.85 | 11.51 | 11.42 | 13.75 | 15.17 | 19.46 | 20.40 | 23.07 | 18.08 | 19.34 | 18.87 | 23.32 | 25.82 | 28.33 | 31.30 | 34.51 | 37.27 | 51.13 | 65.38 | 91.40 | 123.04 | 191.85 |
| Inventory day | 2.73 | 1.20 | 2.41 | 2.73 | 1.78 | 1.28 | 0.800 | 0.636 | 1.09 | 1.53 | 1.12 | 1.07 | 1.20 | 1.99 | 2.16 | 2.49 | 3.78 | 5.49 | 4.85 | 5.26 | 6.68 | 0 |
| Operating Cycle Ratio | 15.58 | 12.71 | 13.83 | 16.49 | 16.96 | 20.74 | 21.20 | 23.71 | 19.17 | 20.87 | 19.98 | 24.39 | 27.02 | 30.32 | 33.45 | 37.01 | 41.05 | 56.62 | 70.23 | 96.66 | 129.72 | 0 |
| Operating Ratio (opex) | 0.851 | 0.893 | 0.888 | 0.933 | 0.991 | 1.06 | 1.08 | 0.964 | 0.918 | 0.901 | 0.903 | 0.909 | 0.938 | 0.909 | 0.871 | 0.769 | 0.736 | 0.734 | 0.755 | 0.805 | 0.819 | 0.896 |
CAGR of Efficiency ratios of Bharti Airtel Ltd.
| Period | 1 Year | 3 Year | 5 Year | 7 Year | 10 Year |
|---|---|---|---|---|---|
| Cash ratio | -21.36 % | -7.83 % | -5.18 % | 1.20 % | 11.35 % |
| Quick ratio | -10.91 % | -6.35 % | -8.55 % | -1.96 % | 1.19 % |
| Current ratio | -10.87 % | -6.37 % | -8.46 % | -1.89 % | 1.20 % |
| Inventory Turnover | -56.02 % | -0.0068 % | -14.03 % | -18.79 % | -8.55 % |
| Days In Working Capital | -21.71 % | -7.04 % | -0.812 % | -2.93 % | -4.90 % |
| Cash Turnover Ratio | 12.72 % | 6.20 % | 13.44 % | -2.76 % | -13.89 % |
| Accruals Ratio | 44.85 % | 23.48 % | 38.38 % | 4.14 % | 16.33 % |
| Account Receivable Turnover Ratio | -10.49 % | 2.28 % | 8.65 % | 8.72 % | 3.91 % |
| Account Receivable Day | 11.72 % | -2.23 % | -7.96 % | -8.02 % | -3.77 % |
| Inventory day | 127.37 % | 0.0068 % | 16.32 % | 23.14 % | 9.35 % |
| Operating Cycle Ratio | 22.65 % | -1.86 % | -5.56 % | -5.82 % | -2.46 % |
| Operating Ratio (opex) | -4.70 % | -3.03 % | -4.29 % | -1.78 % | -0.598 % |
About TSR TECH Strength / Valuation / Growth
TSR Tech Strength is based on Deep Analysis, Back Testing and Historical Trend Analysis using Machine Learning. Overall Technical Strength is based on 50+ indicators including Technicals, Moving Avg, Chart Patterns, Candlestick and proprietary algorithms.Technical Strength is calculate from 1 Min Tick to One Month Tick.
TSR Growth analyses dozen of Historical , MRQ, TTM Parameters, Returns of Individual Stocks vis-a-vis sector , broad based Index to access Growth Potential.
TSR Value analyses dozen of Historical , MRQ, TTM Parameters, Returns of Individual Stocks vis-a-vis sector , broad based Index to access its value.
This is an automated process and in NO WAY should be considered as a tip as its based on past data. We strongly recommend to use these signals for information only and seek advise from a certified professional for any trading decision.If you like it then please share.
Birds's Eye
Fundamentals
Fundamentals
Technicals
MovingAverage
Candlestick
PivotPoint
Beta&Vols
Tech Charts
Future/Option