Company Profile

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.)462.60 490.95
52 WK LOW / HIGH (Rs.)305.69 568.6
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.) 462.25 491.10
52 WK LOW / HIGH (Rs.)305.43 568.85

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