BHARTI AIRTEL LTD.
NSE : BHARTIARTLBSE : 532454ISIN
CODE : INE397D01024Industry : Telecommunication - Service ProviderHouse
: Bharti
BSE540.551.35 (+0.25 % )
PREV CLOSE (Rs.) 539.20
OPEN PRICE (Rs.) 540.00
BID PRICE (QTY) 0.00 (0 )
OFFER PRICE (QTY) 0.00 (0 )
VOLUME 911363
TODAY'S LOW / HIGH (Rs.)
52 WK LOW / HIGH (Rs.)
NSE540.75 1.4 (+0.26 % )
PREV CLOSE(Rs.) 539.35
OPEN PRICE (Rs.) 540.05
BID PRICE (QTY) 0.00 (0 )
OFFER PRICE (QTY) 540.75 (10214 )
VOLUME 6157781
TODAY'S LOW / HIGH(Rs.)
52 WK LOW / HIGH (Rs.)
Balance Sheet
(Rs in Million)
| Particulars | Mar 2020 | Mar 2019 | Mar 2018 | Mar 2017 | Mar 2016 |
|---|---|---|---|---|---|
| EQUITY AND LIABILITIES | NA | NA | NA | NA | NA |
| Share Capital | 27278.00 | 19987.00 | 19987.00 | 19987.00 | 19987.00 |
| Equity - Authorised | 147780.00 | 147530.00 | 27500.00 | 27500.00 | 25000.00 |
| Equity - Issued | 27278.00 | 19987.00 | 19987.00 | 19987.00 | 19987.00 |
| Equity Paid Up | 27278.00 | 19987.00 | 19987.00 | 19987.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 | 673.00 | 744.00 | 782.00 | 4065.00 | 5169.00 |
| Total Reserves | 743497.00 | 693491.00 | 674575.00 | 650511.00 | 642537.00 |
| Securities Premium | 508319.00 | 123456.00 | 123456.00 | 123456.00 | 123456.00 |
| Capital Reserves | 18227.00 | 5315.00 | 0.00 | 0.00 | 0.00 |
| Profit & Loss Account Balance | 112401.00 | 454730.00 | 475481.00 | 483638.00 | 453279.00 |
| General Reserves | 23185.00 | 23052.00 | 23040.00 | 27030.00 | 27030.00 |
| Other Reserves | 81365.00 | 86938.00 | 52598.00 | 16387.00 | 38772.00 |
| Reserve excluding Revaluation Reserve | 743497.00 | 693491.00 | 674575.00 | 650511.00 | 642537.00 |
| Revaluation reserve | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Shareholder's Funds | 771448.00 | 714222.00 | 695344.00 | 674563.00 | 667693.00 |
| Minority Interest | 249847.00 | 135258.00 | 88139.00 | 68750.00 | 54981.00 |
| Long-Term Borrowings | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Secured Loans | 0.00 | 3.00 | 2256.00 | 7053.00 | 18756.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 | 0.00 | 1379.00 | 16725.00 | 11474.00 | 26279.00 |
| Term Loans - Institutions | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Other Secured | 0.00 | -1376.00 | -14469.00 | -4421.00 | -7523.00 |
| Unsecured Loans | 910792.00 | 824898.00 | 847164.00 | 889320.00 | 873930.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 | 69856.00 | 0.00 | 71011.00 | 69067.00 | 126402.00 |
| Other Unsecured Loan | 840936.00 | 824898.00 | 776153.00 | 820253.00 | 747528.00 |
| Deferred Tax Assets / Liabilities | -253283.00 | -78082.00 | -18724.00 | -16766.00 | -34226.00 |
| Deferred Tax Assets | 325080.00 | 179711.00 | 118833.00 | 95617.00 | 87907.00 |
| Deferred Tax Liability | 71797.00 | 101629.00 | 100109.00 | 78851.00 | 53681.00 |
| Other Long Term Liabilities | 336402.00 | 128925.00 | 72696.00 | 41469.00 | 35406.00 |
| Long Term Trade Payables | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Long Term Provisions | 7548.00 | 6823.00 | 7212.00 | 7471.00 | 7350.00 |
| Total Non-Current Liabilities | 1001459.00 | 882567.00 | 910604.00 | 928547.00 | 901216.00 |
| Current Liabilities | NA | NA | NA | NA | NA |
| Trade Payables | 250199.00 | 263138.00 | 268536.00 | 268537.00 | 255806.00 |
| Sundry Creditors | 250199.00 | 263138.00 | 268536.00 | 268537.00 | 255806.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 | 433031.00 | 341970.00 | 370852.00 | 223164.00 | 261932.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 | 8874.00 | 33419.00 | 28341.00 | 0.00 | 6599.00 |
| Share Application Money | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Current maturity of Debentures & Bonds | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Current maturity - Others | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Other Liabilities | 424157.00 | 308551.00 | 342511.00 | 223164.00 | 255333.00 |
| Short Term Borrowings | 167034.00 | 310097.00 | 129569.00 | 129442.00 | 57238.00 |
| Secured ST Loans repayable on Demands | 280.00 | 1682.00 | 5060.00 | 663.00 | 17678.00 |
| Working Capital Loans- Sec | 280.00 | 1682.00 | 5060.00 | 663.00 | 513.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 | 166474.00 | 306733.00 | 119449.00 | 128116.00 | 39047.00 |
| Short Term Provisions | 464612.00 | 14929.00 | 13443.00 | 13454.00 | 14340.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 | 13519.00 | 8228.00 | 11059.00 | 11239.00 | 9296.00 |
| Provision for post retirement benefits | 1454.00 | 1501.00 | 1602.00 | 1599.00 | 0.00 |
| Preference Dividend | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Other Provisions | 449639.00 | 5200.00 | 782.00 | 616.00 | 5044.00 |
| Total Current Liabilities | 1314876.00 | 930134.00 | 782400.00 | 634597.00 | 589316.00 |
| Total Liabilities | 3337630.00 | 2662181.00 | 2476487.00 | 2306457.00 | 2213206.00 |
| ASSETS | NA | NA | NA | NA | NA |
| Gross Block | 3753349.00 | 3284411.00 | 2942676.00 | 2715182.00 | 2596368.00 |
| Less: Accumulated Depreciation | 1460794.00 | 1276096.00 | 1070672.00 | 932831.00 | 873440.00 |
| Less: Impairment of Assets | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Net Block | 2292555.00 | 2008315.00 | 1872004.00 | 1782351.00 | 1722928.00 |
| Lease Adjustment A/c | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Capital Work in Progress | 39972.00 | 88433.00 | 52089.00 | 23942.00 | 47304.00 |
| Non Current Investments | 117086.00 | 110878.00 | 92608.00 | 126464.00 | 89612.00 |
| Long Term Investment | 117086.00 | 110878.00 | 92608.00 | 126464.00 | 89612.00 |
| Quoted | 17002.00 | 18424.00 | 2779.00 | 41222.00 | 0.00 |
| Unquoted | 100084.00 | 92454.00 | 89829.00 | 85242.00 | 89612.00 |
| Long Term Loans & Advances | 67269.00 | 91025.00 | 68622.00 | 83379.00 | 80034.00 |
| Other Non Current Assets | 51465.00 | 26979.00 | 10750.00 | 23840.00 | 32348.00 |
| Total Non-Current Assets | 2571198.00 | 2333539.00 | 2141496.00 | 2124419.00 | 1981942.00 |
| Current Assets Loans & Advances | NA | NA | NA | NA | NA |
| Currents Investments | 137679.00 | 46232.00 | 68978.00 | 16923.00 | 16159.00 |
| Quoted | 137679.00 | 46232.00 | 65074.00 | 15212.00 | 0.00 |
| Unquoted | 0.00 | 0.00 | 3904.00 | 1711.00 | 16159.00 |
| Inventories | 1569.00 | 884.00 | 693.00 | 488.00 | 4404.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 | 1569.00 | 884.00 | 693.00 | 488.00 | 4404.00 |
| Sundry Debtors | 46058.00 | 43006.00 | 58830.00 | 47402.00 | 55039.00 |
| Debtors more than Six months | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Debtors Others | 91986.00 | 80856.00 | 110409.00 | 89660.00 | 90119.00 |
| Cash and Bank | 158927.00 | 80640.00 | 66706.00 | 50983.00 | 50987.00 |
| Cash in hand | 1632.00 | 1084.00 | 820.00 | 398.00 | 808.00 |
| Balances at Bank | 157193.00 | 79431.00 | 64900.00 | 50569.00 | 49995.00 |
| Other cash and bank balances | 102.00 | 125.00 | 986.00 | 16.00 | 184.00 |
| Other Current Assets | 229809.00 | 31841.00 | 122142.00 | 35664.00 | 77210.00 |
| Interest accrued on Investments | 296.00 | 602.00 | 870.00 | 1447.00 | 1554.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 | 9635.00 | 8201.00 | 9275.00 | 11490.00 | 15590.00 |
| Other current_assets | 219878.00 | 23038.00 | 111997.00 | 22727.00 | 60066.00 |
| Short Term Loans and Advances | 192390.00 | 126039.00 | 17642.00 | 30578.00 | 27465.00 |
| Advances recoverable in cash or in kind | 6725.00 | 20436.00 | 17642.00 | 17054.00 | 15895.00 |
| Advance income tax and TDS | 135665.00 | 105603.00 | 0.00 | 13524.00 | 11570.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 | 50000.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Total Current Assets | 766432.00 | 328642.00 | 334991.00 | 182038.00 | 231264.00 |
| Net Current Assets (Including Current Investments) | -548444.00 | -601492.00 | -447409.00 | -452559.00 | -358052.00 |
| Miscellaneous Expenses not written off | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Total Assets | 3337630.00 | 2662181.00 | 2476487.00 | 2306457.00 | 2213206.00 |
| Contingent Liabilities | 261303.00 | 273276.00 | 255828.00 | 134820.00 | 208236.00 |
| Total Debt | 1176190.00 | 1206730.00 | 1113335.00 | 1072877.00 | 1004526.00 |
| Book Value | 141.28 | 178.49 | 173.75 | 167.73 | 165.74 |
| Adjusted Book Value | 141.28 | 163.85 | 159.51 | 153.98 | 152.15 |
