equitymaster.comFalseFalseBHARTI AIRTEL |
|
Price History |
Price | Rs | 1,229.1 | | % ch | % | 0.4 |
Mkt Cap | Rs m | 7,432,526 | | No. of
shares | m | 6,047.37 |
Vol | '000 | 92.2 | | % ch week | % | -0.2 |
P/E | X | 90.2 | | % ch 1-mth | % | 9.0 |
P/CF | X | 15.3 | | % ch 12-mth | % | 61.3 |
EPS (TTM) | Rs | 13.6 | | 52 week H/L | Rs | 1,245.0/738.7 |
(As on Mar 28, 2024 (Close)) |
|
Financials |
* Results Consolidated | No. of Months
Year Ending | 12
Mar-19* | 12
Mar-20* | 12
Mar-21* | 12
Mar-22* | 12
Mar-23* |
EQUITY SHARE DATA |
High | Rs | 348 | 569 | 623 | 782 | 877 |
Low | Rs | 242 | 313 | 394 | 514 | 629 |
Sales per share (Unadj.) | Rs | 202.1 | 155.2 | 183.2 | 198.1 | 233.2 |
Earnings per share (Unadj.) | Rs | 4.2 | -61.6 | -42.6 | 14.1 | 20.6 |
Diluted earnings per share | Rs | 2.8 | -55.6 | -38.7 | 13.7 | 20.3 |
Cash flow per share (Unadj.) | Rs | 57.6 | -12.0 | 10.9 | 70.3 | 81.6 |
Dividends per share (Unadj.) | Rs | 2.50 | 2.00 | 0 | 3.00 | 4.00 |
Adj. dividends per share | Rs | 1.65 | 1.80 | 0.00 | 2.92 | 3.95 |
Avg Dividend yield | % | 0.8 | 0.5 | 0 | 0.5 | 0.5 |
Book value per share (Unadj.) | Rs | 178.5 | 141.3 | 107.2 | 112.9 | 129.7 |
Adj. book value per share | Rs | 118.0 | 127.5 | 97.3 | 109.9 | 128.0 |
Shares outstanding (eoy) | m | 3,997.40 | 5,455.56 | 5,492.03 | 5,884.31 | 5,967.42 |
Bonus / Rights / Conversions | | 0 | 0 | 0 | 0 | 0 |
Price / Sales ratio | x | 1.5 | 2.8 | 2.8 | 3.3 | 3.2 |
Avg P/E ratio | x | 70.0 | -7.2 | -11.9 | 45.9 | 36.6 |
P/CF ratio (eoy) | x | 5.1 | -36.9 | 46.7 | 9.2 | 9.2 |
Price / Book Value ratio | x | 1.7 | 3.1 | 4.7 | 5.7 | 5.8 |
Dividend payout | % | 59.2 | -3.2 | 0 | 21.3 | 19.4 |
Avg Mkt Cap | Rs m | 1,180,632 | 2,404,810 | 2,792,833 | 3,813,477 | 4,493,917 |
No. of employees | `000 | NA | NA | NA | NA | NA |
Total wages/salary | Rs m | 37,975 | 35,137 | 41,146 | 44,333 | 48,308 |
Avg. sales/employee | Rs Th | 0 | 0 | 0 | 0 | 0 |
Avg. wages/employee | Rs Th | 0 | 0 | 0 | 0 | 0 |
Avg. net profit/employee | Rs Th | 0 | 0 | 0 | 0 | 0 |
INCOME DATA |
Net Sales | Rs m | 807,802 | 846,765 | 1,006,158 | 1,165,469 | 1,391,448 |
Other income | Rs m | 27,991 | 15,357 | 6,428 | 5,343 | 9,366 |
Total revenues | Rs m | 835,793 | 862,122 | 1,012,586 | 1,170,812 | 1,400,814 |
Gross profit | Rs m | 274,388 | -64,985 | 293,644 | 616,557 | 713,558 |
Depreciation | Rs m | 213,475 | 270,944 | 294,044 | 330,907 | 364,318 |
Interest | Rs m | 106,222 | 140,732 | 150,910 | 166,162 | 192,999 |
Profit before tax | Rs m | -17,318 | -461,304 | -144,882 | 124,831 | 165,607 |
Minority Interest | Rs m | 0 | 0 | 0 | 0 | 0 |
Prior Period Items | Rs m | 0 | 0 | 0 | 0 | 0 |
Extraordinary Inc (Exp) | Rs m | 0 | 0 | 0 | 0 | 0 |
Tax | Rs m | -34,193 | -125,124 | 89,325 | 41,779 | 42,733 |
Profit after tax | Rs m | 16,875 | -336,180 | -234,207 | 83,052 | 122,874 |
Gross profit margin | % | 34.0 | -7.7 | 29.2 | 52.9 | 51.3 |
Effective tax rate | % | 197.4 | 27.1 | -61.7 | 33.5 | 25.8 |
Net profit margin | % | 2.1 | -39.7 | -23.3 | 7.1 | 8.8 |
BALANCE SHEET DATA |
Current assets | Rs m | 328,642 | 766,432 | 545,525 | 520,279 | 575,013 |
Current liabilities | Rs m | 930,134 | 1,314,876 | 1,115,644 | 1,140,260 | 1,219,638 |
Net working cap to sales | % | -74.5 | -64.8 | -56.7 | -53.2 | -46.3 |
Current ratio | x | 0.4 | 0.6 | 0.5 | 0.5 | 0.5 |
Inventory Days | Days | 124 | 161 | 167 | 133 | 126 |
Debtors Days | Days | 19 | 20 | 13 | 13 | 10 |
Net fixed assets | Rs m | 2,333,539 | 2,571,198 | 2,711,885 | 2,917,031 | 3,701,800 |
Share capital | Rs m | 19,987 | 27,278 | 27,460 | 27,950 | 28,366 |
"Free" reserves | Rs m | 693,491 | 743,497 | 561,190 | 636,587 | 745,515 |
Net worth | Rs m | 713,478 | 770,775 | 588,650 | 664,537 | 773,881 |
Long term debt | Rs m | 824,901 | 910,792 | 1,105,603 | 1,135,350 | 1,515,686 |
Total assets | Rs m | 2,662,181 | 3,337,630 | 3,259,414 | 3,437,310 | 4,276,813 |
Interest coverage | x | 0.8 | -2.3 | 0 | 1.8 | 1.9 |
Debt to equity ratio | x | 1.2 | 1.2 | 1.9 | 1.7 | 2.0 |
Sales to assets ratio | x | 0.3 | 0.3 | 0.3 | 0.3 | 0.3 |
Return on assets | % | 4.6 | -5.9 | -2.6 | 7.3 | 7.4 |
Return on equity | % | 2.4 | -43.6 | -39.8 | 12.5 | 15.9 |
Return on capital | % | 5.8 | -19.1 | 0.4 | 16.2 | 15.7 |
Exports to sales | % | 0 | 0 | 0 | 0 | 0 |
Imports to sales | % | 0 | 0 | 0 | 0 | 0 |
Exports (fob) | Rs m | 0 | 0 | 0 | 0 | 0 |
Imports (cif) | Rs m | 0 | 0 | 0 | 0 | 0 |
Fx inflow | Rs m | 45,929 | 45,060 | 48,970 | 29,479 | 36,515 |
Fx outflow | Rs m | 226,775 | 119,694 | 107,677 | 86,122 | 106,635 |
Net fx | Rs m | -180,846 | -74,634 | -58,707 | -56,643 | -70,120 |
CASH FLOW |
From Operations | Rs m | 200,702 | 181,287 | 482,050 | 550,166 | 653,246 |
From Investments | Rs m | -285,009 | -304,919 | -268,884 | -418,696 | -390,802 |
From Financial Activity | Rs m | 94,638 | 191,444 | -249,103 | -152,032 | -244,695 |
Net Cashflow | Rs m | 12,484 | 76,746 | -39,909 | -16,643 | 16,227 |
* Results Consolidated | Source: Company Annual Reports, Regulatory Filings, Equitymaster |
|
Share Holding |
Indian Promoters: | 39.6% |
Foreign collaborators: | 15.0% |
Indian inst/Mut Fund: | 42.3% |
FIIs: | 22.7% |
ADR/GDR: | 0.0% |
Free float: | 45.4% |
Shareholders: | 677,690 |
Pledged promoter(s) holding: | 0.0% |
|
Company Information |
REGD OFF: | Airtel Center, Plot No. 16 Udyog Vihar, Phase - I V, Gurugram - 122015 |
E-MAIL: | compliance.officer@bharti.in |
WEB: | www.airtel.com |
TELEPHONE: | 0124-4222222 |
FAX: | 0124-4248063 |
SECTOR: | TELECOM |
GROUP: | Bharti Telecom Group |
TR AGENT: | K FIN Technologies Ltd.-(Karvy Fintech Pvt Ltd.), Karvy Selenium Tower B Plot 31-32, Gachibowli Financial District, Nanakramguda |
AUDITOR: | S. R. Batliboi & Assoc. |
CHM: | Sunil Bharti Mittal |
COMP SEC: | Pankaj Tewari |
YEAR OF INC: | 1995 |
BSE CODE: | 532454 |
FV (Rs): | 5 |
DIV YIELD (%): | 0.3 |