Company Profile

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.)538.30 544.30
52 WK LOW / HIGH (Rs.)394.05 623
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.) 538.00 544.15
52 WK LOW / HIGH (Rs.)394 623

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