BHARTI AIRTEL LTD.
NSE : BHARTIARTLBSE : 532454ISIN
CODE : INE397D01024Industry : Telecommunication - Service ProviderHouse
: Bharti
BSE474.654.6 (+0.98 % )
PREV CLOSE (Rs.) 470.05
OPEN PRICE (Rs.) 470.50
BID PRICE (QTY) 474.40 (48 )
OFFER PRICE (QTY) 474.85 (43 )
VOLUME 158167
TODAY'S LOW / HIGH (Rs.)
52 WK LOW / HIGH (Rs.)
NSE473.00 2.8 (+0.6 % )
PREV CLOSE(Rs.) 470.20
OPEN PRICE (Rs.) 474.35
BID PRICE (QTY) 472.80 (237 )
OFFER PRICE (QTY) 473.00 (99 )
VOLUME 6315398
TODAY'S LOW / HIGH(Rs.)
52 WK LOW / HIGH (Rs.)
Balance Sheet
(Rs in Million)
| Particulars | Mar 2019 | Mar 2018 | Mar 2017 | Mar 2016 | Mar 2015 |
|---|---|---|---|---|---|
| EQUITY AND LIABILITIES | NA | NA | NA | NA | NA |
| Share Capital | 19987.00 | 19987.00 | 19987.00 | 19987.00 | 19987.00 |
| Equity - Authorised | 147530.00 | 27500.00 | 27500.00 | 25000.00 | 25000.00 |
| Equity - Issued | 19987.00 | 19987.00 | 19987.00 | 19987.00 | 19987.00 |
| Equity Paid Up | 19987.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 | 744.00 | 782.00 | 4065.00 | 5169.00 | 1343.00 |
| Total Reserves | 693491.00 | 674575.00 | 650511.00 | 642537.00 | 376440.00 |
| Securities Premium | 123456.00 | 123456.00 | 123456.00 | 123456.00 | 107967.00 |
| Capital Reserves | 5315.00 | 0.00 | 0.00 | 0.00 | 1513.00 |
| Profit & Loss Account Balance | 454730.00 | 475481.00 | 483638.00 | 453279.00 | 251589.00 |
| General Reserves | 23052.00 | 23040.00 | 27030.00 | 27030.00 | 82176.00 |
| Other Reserves | 86938.00 | 52598.00 | 16387.00 | 38772.00 | -66805.00 |
| Reserve excluding Revaluation Reserve | 693491.00 | 674575.00 | 650511.00 | 642537.00 | 376419.00 |
| Revaluation reserve | 0.00 | 0.00 | 0.00 | 0.00 | 21.00 |
| Shareholder's Funds | 714222.00 | 695344.00 | 674563.00 | 667693.00 | 397770.00 |
| Minority Interest | 135258.00 | 88139.00 | 68750.00 | 54981.00 | 68906.00 |
| Long-Term Borrowings | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Secured Loans | 3.00 | 2256.00 | 7053.00 | 18756.00 | 93569.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 | 1379.00 | 16725.00 | 11474.00 | 26279.00 | 79944.00 |
| Term Loans - Institutions | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Other Secured | -1376.00 | -14469.00 | -4421.00 | -7523.00 | 13625.00 |
| Unsecured Loans | 872451.00 | 847164.00 | 889320.00 | 873930.00 | 517592.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 | 155448.00 |
| Loans - Govt. | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Loans - Others | 175551.00 | 71011.00 | 69067.00 | 126402.00 | 56774.00 |
| Other Unsecured Loan | 696900.00 | 776153.00 | 820253.00 | 747528.00 | 305370.00 |
| Deferred Tax Assets / Liabilities | -78082.00 | -18724.00 | -16766.00 | -34226.00 | 20640.00 |
| Deferred Tax Assets | 179711.00 | 118833.00 | 95617.00 | 87907.00 | 23604.00 |
| Deferred Tax Liability | 101629.00 | 100109.00 | 78851.00 | 53681.00 | 44244.00 |
| Other Long Term Liabilities | 81372.00 | 72696.00 | 41469.00 | 35406.00 | 43919.00 |
| Long Term Trade Payables | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Long Term Provisions | 6823.00 | 7212.00 | 7471.00 | 7350.00 | 17970.00 |
| Total Non-Current Liabilities | 882567.00 | 910604.00 | 928547.00 | 901216.00 | 693690.00 |
| Current Liabilities | NA | NA | NA | NA | NA |
| Trade Payables | 280031.00 | 268536.00 | 268537.00 | 255806.00 | 160774.00 |
| Sundry Creditors | 280031.00 | 268536.00 | 268537.00 | 255806.00 | 160774.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 | 329996.00 | 370852.00 | 223164.00 | 261932.00 | 389752.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 | 69354.00 |
| Interest Accrued But Not Due | 33419.00 | 28341.00 | 0.00 | 6599.00 | 6835.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 | 657.00 |
| Other Liabilities | 296577.00 | 342511.00 | 223164.00 | 255333.00 | 312906.00 |
| Short Term Borrowings | 310097.00 | 129569.00 | 129442.00 | 57238.00 | 88138.00 |
| Secured ST Loans repayable on Demands | 1682.00 | 5060.00 | 663.00 | 17678.00 | 11383.00 |
| Working Capital Loans- Sec | 1682.00 | 5060.00 | 663.00 | 513.00 | 987.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 | 306733.00 | 119449.00 | 128116.00 | 39047.00 | 75768.00 |
| Short Term Provisions | 10425.00 | 13443.00 | 13454.00 | 14340.00 | 206643.00 |
| Proposed Equity Dividend | 0.00 | 0.00 | 0.00 | 0.00 | 8874.00 |
| Provision for Corporate Dividend Tax | 0.00 | 0.00 | 0.00 | 0.00 | 2591.00 |
| Provision for Tax | 8228.00 | 11059.00 | 11239.00 | 9296.00 | 190706.00 |
| Provision for post retirement benefits | 1501.00 | 1602.00 | 1599.00 | 0.00 | 0.00 |
| Preference Dividend | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Other Provisions | 696.00 | 782.00 | 616.00 | 5044.00 | 4472.00 |
| Total Current Liabilities | 930549.00 | 782400.00 | 634597.00 | 589316.00 | 845307.00 |
| Total Liabilities | 2662596.00 | 2476487.00 | 2306457.00 | 2213206.00 | 2005673.00 |
| ASSETS | NA | NA | NA | NA | NA |
| Gross Block | 3284411.00 | 2942676.00 | 2715182.00 | 2596368.00 | 2083103.00 |
| Less: Accumulated Depreciation | 1276096.00 | 1070672.00 | 932831.00 | 873440.00 | 840317.00 |
| Less: Impairment of Assets | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Net Block | 2008315.00 | 1872004.00 | 1782351.00 | 1722928.00 | 1242786.00 |
| Lease Adjustment A/c | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Capital Work in Progress | 88433.00 | 52089.00 | 23942.00 | 47304.00 | 49553.00 |
| Non Current Investments | 110878.00 | 92608.00 | 126464.00 | 89612.00 | 27434.00 |
| Long Term Investment | 110878.00 | 92608.00 | 126464.00 | 89612.00 | 27434.00 |
| Quoted | 18424.00 | 2779.00 | 41222.00 | 0.00 | 27382.00 |
| Unquoted | 92454.00 | 89829.00 | 85242.00 | 89612.00 | 52.00 |
| Long Term Loans & Advances | 91025.00 | 68622.00 | 83379.00 | 80034.00 | 137621.00 |
| Other Non Current Assets | 26979.00 | 10750.00 | 23840.00 | 32348.00 | 13971.00 |
| Total Non-Current Assets | 2333539.00 | 2141496.00 | 2124419.00 | 1981942.00 | 1595960.00 |
| Current Assets Loans & Advances | NA | NA | NA | NA | NA |
| Currents Investments | 46232.00 | 68978.00 | 16923.00 | 16159.00 | 80086.00 |
| Quoted | 46232.00 | 65074.00 | 15212.00 | 0.00 | 80069.00 |
| Unquoted | 0.00 | 3904.00 | 1711.00 | 16159.00 | 17.00 |
| Inventories | 884.00 | 693.00 | 488.00 | 4404.00 | 3754.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 | 884.00 | 693.00 | 488.00 | 4404.00 | 3754.00 |
| Sundry Debtors | 43006.00 | 58830.00 | 47402.00 | 55039.00 | 52072.00 |
| Debtors more than Six months | 0.00 | 0.00 | 0.00 | 0.00 | 23300.00 |
| Debtors Others | 80856.00 | 110409.00 | 89660.00 | 90119.00 | 58954.00 |
| Cash and Bank | 81055.00 | 66706.00 | 50983.00 | 50987.00 | 20831.00 |
| Cash in hand | 1084.00 | 820.00 | 398.00 | 808.00 | 931.00 |
| Balances at Bank | 79846.00 | 64900.00 | 50569.00 | 49995.00 | 19475.00 |
| Other cash and bank balances | 125.00 | 986.00 | 16.00 | 184.00 | 425.00 |
| Other Current Assets | 31841.00 | 48138.00 | 35664.00 | 77210.00 | 20281.00 |
| Interest accrued on Investments | 602.00 | 870.00 | 1447.00 | 1554.00 | 0.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 | 8201.00 | 9275.00 | 11490.00 | 15590.00 | 0.00 |
| Other current_assets | 23038.00 | 37993.00 | 22727.00 | 60066.00 | 20281.00 |
| Short Term Loans and Advances | 126039.00 | 91646.00 | 30578.00 | 27465.00 | 228402.00 |
| Advances recoverable in cash or in kind | 20436.00 | 17642.00 | 17054.00 | 15895.00 | 28073.00 |
| Advance income tax and TDS | 105603.00 | 74004.00 | 13524.00 | 11570.00 | 189856.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 | 722.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 | 0.00 | 0.00 | 0.00 | 0.00 | 9751.00 |
| Total Current Assets | 329057.00 | 334991.00 | 182038.00 | 231264.00 | 405426.00 |
| Net Current Assets (Including Current Investments) | -601492.00 | -447409.00 | -452559.00 | -358052.00 | -439881.00 |
| Miscellaneous Expenses not written off | 0.00 | 0.00 | 0.00 | 0.00 | 4287.00 |
| Total Assets | 2662596.00 | 2476487.00 | 2306457.00 | 2213206.00 | 2005673.00 |
| Contingent Liabilities | 273276.00 | 255828.00 | 134820.00 | 101981.00 | 205738.00 |
| Total Debt | 1254283.00 | 1113335.00 | 1072877.00 | 1004526.00 | 834151.00 |
| Book Value | 178.49 | 173.75 | 167.73 | 165.74 | 98.09 |
| Adjusted Book Value | 163.85 | 159.51 | 153.98 | 152.15 | 90.05 |
