BHARTI AIRTEL LTD.
NSE : BHARTIARTLBSE : 532454ISIN
CODE : INE397D01024Industry : Telecommunication - Service ProviderHouse
: Bharti
BSE1330.304.8 (+0.36 % )
PREV CLOSE (Rs.) 1325.50
OPEN PRICE (Rs.) 1329.35
BID PRICE (QTY) 1329.05 (95 )
OFFER PRICE (QTY) 1329.95 (10 )
VOLUME 10562
TODAY'S LOW / HIGH (Rs.)
52 WK LOW / HIGH (Rs.)
NSE1329.20 3.2 (+0.24 % )
PREV CLOSE(Rs.) 1326.00
OPEN PRICE (Rs.) 1324.50
BID PRICE (QTY) 1328.60 (20 )
OFFER PRICE (QTY) 1329.20 (309 )
VOLUME 726650
TODAY'S LOW / HIGH(Rs.)
52 WK LOW / HIGH (Rs.)
Balance Sheet
(Rs in Million)
| Particulars | Mar 2023 | Mar 2022 | Mar 2021 | Mar 2020 | Mar 2019 |
|---|---|---|---|---|---|
| EQUITY AND LIABILITIES | NA | NA | NA | NA | NA |
| Share Capital | 28366.00 | 27950.00 | 27460.00 | 27278.00 | 19987.00 |
| Equity - Authorised | 148730.00 | 147780.00 | 147780.00 | 147780.00 | 147530.00 |
| Equity - Issued | 29837.00 | 29421.00 | 27460.00 | 27278.00 | 19987.00 |
| Equity Paid Up | 28366.00 | 27950.00 | 27460.00 | 27278.00 | 19987.00 |
| Equity Shares Forfeited | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Adjustments to Equity | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Preference Capital Paid Up | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Face Value | 5.00 | 5.00 | 5.00 | 5.00 | 5.00 |
| Share Warrants & Outstandings | 1748.00 | 1006.00 | 877.00 | 673.00 | 744.00 |
| Total Reserves | 745515.00 | 636587.00 | 561190.00 | 743497.00 | 693491.00 |
| Securities Premium | 640511.00 | 581755.00 | 530019.00 | 508319.00 | 123456.00 |
| Capital Reserves | 18227.00 | 18227.00 | 18227.00 | 18227.00 | 5315.00 |
| Profit & Loss Account Balance | 64497.00 | -1429.00 | -44366.00 | 112401.00 | 454730.00 |
| General Reserves | 22997.00 | 23142.00 | 23232.00 | 23185.00 | 23052.00 |
| Other Reserves | -717.00 | 14892.00 | 34078.00 | 81365.00 | 86938.00 |
| Reserve excluding Revaluation Reserve | 745515.00 | 636587.00 | 561190.00 | 743497.00 | 693491.00 |
| Revaluation reserve | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Shareholder's Funds | 775629.00 | 665543.00 | 589527.00 | 771448.00 | 714222.00 |
| Minority Interest | 288814.00 | 253807.00 | 222739.00 | 249847.00 | 135258.00 |
| Long-Term Borrowings | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Secured Loans | 2888.00 | 0.00 | 0.00 | 0.00 | 3.00 |
| Non Convertible Debentures | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Converible Debentures & Bonds | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Packing Credit - Bank | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Inter Corporate & Security Deposit | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Term Loans - Banks | 3516.00 | 3796.00 | 3669.00 | 0.00 | 1379.00 |
| Term Loans - Institutions | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Other Secured | -628.00 | -3796.00 | -3669.00 | 0.00 | -1376.00 |
| Unsecured Loans | 1512798.00 | 1135350.00 | 1105603.00 | 910792.00 | 824898.00 |
| Fixed Deposits - Public | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Loans and advances from subsidiaries | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Inter Corporate Deposits (Unsecured) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Foreign Currency Convertible Notes | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Long Term Loan in Foreign Currency | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Loans - Banks | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Loans - Govt. | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Loans - Others | 151108.00 | 95554.00 | 127562.00 | 222746.00 | 175551.00 |
| Other Unsecured Loan | 1361690.00 | 1039796.00 | 978041.00 | 688046.00 | 649347.00 |
| Deferred Tax Assets / Liabilities | -168757.00 | -174762.00 | -184757.00 | -253283.00 | -78082.00 |
| Deferred Tax Assets | 234586.00 | 244638.00 | 242134.00 | 326876.00 | 179711.00 |
| Deferred Tax Liability | 65829.00 | 69876.00 | 57377.00 | 73593.00 | 101629.00 |
| Other Long Term Liabilities | 641059.00 | 412473.00 | 404923.00 | 336402.00 | 128925.00 |
| Long Term Trade Payables | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Long Term Provisions | 4744.00 | 4639.00 | 5020.00 | 7548.00 | 6823.00 |
| Total Non-Current Liabilities | 1992732.00 | 1377700.00 | 1330789.00 | 1001459.00 | 882567.00 |
| Current Liabilities | NA | NA | NA | NA | NA |
| Trade Payables | 328946.00 | 292741.00 | 278849.00 | 243668.00 | 263138.00 |
| Sundry Creditors | 328946.00 | 292741.00 | 278849.00 | 243668.00 | 263138.00 |
| Acceptances | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Due to Subsidiaries- Trade Payables | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Other Current Liabilities | 562014.00 | 410402.00 | 505613.00 | 439562.00 | 341970.00 |
| Bank Overdraft / Short term credit | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Advances received from customers | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Interest Accrued But Not Due | 8063.00 | 5920.00 | 38979.00 | 8613.00 | 33419.00 |
| Share Application Money | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Current maturity of Debentures & Bonds | 44968.00 | 0.00 | 79523.00 | 0.00 | 0.00 |
| Current maturity - Others | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Other Liabilities | 508983.00 | 404482.00 | 387111.00 | 430949.00 | 308551.00 |
| Short Term Borrowings | 53414.00 | 172943.00 | 80823.00 | 167034.00 | 310097.00 |
| Secured ST Loans repayable on Demands | 82.00 | 0.00 | 0.00 | 280.00 | 1682.00 |
| Working Capital Loans- Sec | 0.00 | 0.00 | 0.00 | 280.00 | 1682.00 |
| Buyers Credits - Unsec | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Commercial Borrowings- Unsec | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Other Unsecured Loans | 53332.00 | 172943.00 | 80823.00 | 166474.00 | 306733.00 |
| Short Term Provisions | 275264.00 | 264174.00 | 250359.00 | 464612.00 | 14929.00 |
| Proposed Equity Dividend | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Provision for Corporate Dividend Tax | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Provision for Tax | 17972.00 | 20725.00 | 15199.00 | 13890.00 | 8228.00 |
| Provision for post retirement benefits | 0.00 | 0.00 | 1679.00 | 1454.00 | 1501.00 |
| Preference Dividend | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Other Provisions | 257292.00 | 243449.00 | 233481.00 | 449268.00 | 5200.00 |
| Total Current Liabilities | 1219638.00 | 1140260.00 | 1115644.00 | 1314876.00 | 930134.00 |
| Total Liabilities | 4276813.00 | 3437310.00 | 3259414.00 | 3337630.00 | 2662181.00 |
| ASSETS | NA | NA | NA | NA | NA |
| Gross Block | 4853649.00 | 4215126.00 | 3823680.00 | 3753349.00 | 3284411.00 |
| Less: Accumulated Depreciation | 2079711.00 | 1774293.00 | 1588884.00 | 1460794.00 | 1276096.00 |
| Less: Impairment of Assets | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Net Block | 2773938.00 | 2440833.00 | 2234796.00 | 2292555.00 | 2008315.00 |
| Lease Adjustment A/c | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Capital Work in Progress | 110293.00 | 42386.00 | 43665.00 | 39972.00 | 88433.00 |
| Non Current Investments | 282494.00 | 284877.00 | 234723.00 | 117086.00 | 110878.00 |
| Long Term Investment | 282494.00 | 284877.00 | 234723.00 | 117086.00 | 110878.00 |
| Quoted | 0.00 | 0.00 | 103.00 | 17002.00 | 18424.00 |
| Unquoted | 282494.00 | 284877.00 | 234620.00 | 100084.00 | 92454.00 |
| Long Term Loans & Advances | 67704.00 | 62335.00 | 111341.00 | 53760.00 | 69287.00 |
| Other Non Current Assets | 83410.00 | 69439.00 | 73760.00 | 64974.00 | 48717.00 |
| Total Non-Current Assets | 3701800.00 | 2917031.00 | 2711885.00 | 2571198.00 | 2333539.00 |
| Current Assets Loans & Advances | NA | NA | NA | NA | NA |
| Currents Investments | 47045.00 | 8614.00 | 40781.00 | 137679.00 | 46232.00 |
| Quoted | 47045.00 | 8614.00 | 40781.00 | 137679.00 | 46232.00 |
| Unquoted | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Inventories | 2576.00 | 3750.00 | 2660.00 | 1569.00 | 884.00 |
| Raw Materials | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Work-in Progress | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Finished Goods | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Packing Materials | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Stores  and Spare | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Other Inventory | 2576.00 | 3750.00 | 2660.00 | 1569.00 | 884.00 |
| Sundry Debtors | 39815.00 | 40562.00 | 36402.00 | 46058.00 | 43006.00 |
| Debtors more than Six months | 51218.00 | 48426.00 | 44711.00 | 0.00 | 0.00 |
| Debtors Others | 38694.00 | 37092.00 | 35215.00 | 91986.00 | 80856.00 |
| Cash and Bank | 134186.00 | 134943.00 | 134707.00 | 158927.00 | 80640.00 |
| Cash in hand | 228.00 | 174.00 | 3399.00 | 1632.00 | 1084.00 |
| Balances at Bank | 133665.00 | 134566.00 | 131240.00 | 157193.00 | 79431.00 |
| Other cash and bank balances | 293.00 | 203.00 | 68.00 | 102.00 | 125.00 |
| Other Current Assets | 249695.00 | 230421.00 | 300337.00 | 346253.00 | 120372.00 |
| Interest accrued on Investments | 375.00 | 220.00 | 102.00 | 296.00 | 602.00 |
| Interest accrued on Debentures | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Deposits with Government | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Interest accrued and or due on loans | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Prepaid Expenses | 11758.00 | 10487.00 | 9088.00 | 9635.00 | 8201.00 |
| Other current_assets | 237562.00 | 219714.00 | 291147.00 | 336322.00 | 111569.00 |
| Short Term Loans and Advances | 101696.00 | 101989.00 | 30638.00 | 75946.00 | 37508.00 |
| Advances recoverable in cash or in kind | 24427.00 | 24765.00 | 19646.00 | 25946.00 | 20436.00 |
| Advance income tax and TDS | 0.00 | 0.00 | 0.00 | 0.00 | 17072.00 |
| Amounts due from directors | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Due From Subsidiaries | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Inter corporate deposits | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Corporate Deposits | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Other Loans & Advances | 77269.00 | 77224.00 | 10992.00 | 50000.00 | 0.00 |
| Total Current Assets | 575013.00 | 520279.00 | 545525.00 | 766432.00 | 328642.00 |
| Net Current Assets (Including Current Investments) | -644625.00 | -619981.00 | -570119.00 | -548444.00 | -601492.00 |
| Miscellaneous Expenses not written off | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Total Assets | 4276813.00 | 3437310.00 | 3259414.00 | 3337630.00 | 2662181.00 |
| Contingent Liabilities | 149589.00 | 138877.00 | 99274.00 | 139676.00 | 273276.00 |
| Total Debt | 1655448.00 | 1329145.00 | 1297899.00 | 1176190.00 | 1206730.00 |
| Book Value | 136.41 | 118.88 | 107.18 | 141.28 | 178.49 |
| Adjusted Book Value | 136.41 | 118.88 | 105.16 | 138.62 | 160.76 |
