Bharti Airtel Limited

52-week high

2174.70 INR

52-week low

1745.00 INR

1-year performanceiPrice performanceWhat it is:The change in the share price over the period (1 year or year to date), in percent.How to read it:Above 0 the share gained value over the period; below 0 it lost value. Example: +15% means 100 euros invested at the start of the period are worth 115 today; -15%, that they are worth only 85.Rating bandsDeclining< 0%Rising> 0%

-2.60%

Declining

Year-to-date performanceiPrice performanceWhat it is:The change in the share price over the period (1 year or year to date), in percent.How to read it:Above 0 the share gained value over the period; below 0 it lost value. Example: +15% means 100 euros invested at the start of the period are worth 115 today; -15%, that they are worth only 85.Rating bandsDeclining< 0%Rising> 0%

-13.09%

Declining

DrawdowniDrawdownWhat it is:The fall from the recent high: how deep the current drawdown runs.How to read it:-20% means the share lost a fifth since its peak. A deep gap is an opportunity when the company is doing well, and an alarm when it is not.Rating bandsMajor drawdown< -30%Marked drawdown-30% - -15%Mild pullback-15% - -5%Near its high> -5%

-17.90%

Marked drawdown

Position in the 52-week rangeiWhere the price sits between its 52-week low and high.

9% of range

Net marginiNet marginWhat it is:What is left of sales once everything is paid, production, overheads, interest and tax (net income divided by sales).How to read it:Of every 100 euros sold, this is what really comes back to the shareholder. A net margin well below the operating margin points to heavy debt or a high tax bill. The higher the margin, the better for the company.Rating bandspeer median 11.62%Negative< 0%Low0% - 8.14%Fair8.14% - 13.95%High13.95% - 16.27%Exceptional16.27% - 232.46%

13.14%

Fair

Gross marginiGross marginWhat it is:What is left of sales after the cost of making what was sold (sales minus cost of production, divided by sales).How to read it:It says how much pricing power the company has. It only compares within one line of business: 12% is normal in heavy industry and low in software. The higher the margin, the better for the company.Rating bandspeer median 33.21%Negative< 0%Low0% - 23.25%Fair23.25% - 39.86%High39.86% - 46.50%Exceptional46.50% - 664.28%

43.10%

High

Return on equity (ROE)iReturn on equity (ROE)What it is:The year's profit against shareholders' equity, the money shareholders put in and left in the company (capital plus retained earnings): a book value, not the share price.How to read it:The higher it is, the more the company grows its shareholders' money. But debt inflates it: a high ROE on a heavily indebted company is not real performance. Read it with the gearing (and with the ROIC, which debt does not flatter).Rating bandspeer median 17.25%Negative< 0%Low0% - 12.08%Fair12.08% - 20.70%High20.70% - 24.16%Exceptional24.16% - 345.08%

20.54%

Fair

Return on invested capital (ROIC)iReturn on invested capital (ROIC)What it is:Operating profit (after tax) against all the capital used to run the business, the shareholders' AND the borrowed. All the money goes in one pot, wherever it came from, to measure what the business really produces.How to read it:The best judge of how good a business is, because debt does not flatter it, unlike the ROE (which swells when the company borrows). Above 15% the company creates value; below its cost of capital (about 8%, the rent on money) it destroys value even while profitable, because it earns less than its money costs it.Rating bandspeer median 8.16%Negative< 0%Low0% - 5.71%Fair5.71% - 9.79%High9.79% - 11.43%Exceptional11.43% - 163.24%

9.49%

Fair

Free cash flow margin (FCF)iFree cash flow margin (FCF)What it is:The share of sales that turns into cash really available once capital spending is paid (free cash flow divided by sales).How to read it:The hardest figure to dress up. A company profitable on its income statement but with negative cash flow is burning cash to grow.Rating bandspeer median 16.75%Negative< 0%Low0% - 11.72%Fair11.72% - 20.10%High20.10% - 23.45%Exceptional23.45% - 334.98%

28.80%

Exceptional

Profit-to-cash conversion (FCF conversion)iProfit-to-cash conversion (FCF conversion)What it is:The share of the accounting profit that ends up as free cash (free cash flow divided by net income).How to read it:Around 1, profits really turn into cash. Lastingly below 0.7, the reported profit is largely on paper.Rating bandspeer median 1.47xLow< 0.73xFair0.73x - 1.32xHigh1.32x - 2.05xExceptional2.05x - 29.32x

2.19x

Exceptional

Margin stabilityiMargin stabilityWhat it is:How steady the margin stays from one year to the next, measured by its variation over several years (low variation = high stability).How to read it:A stable margin makes profit predictable and often reveals a real competitive advantage: a company that defends its prices and its costs. A saw-toothed margin, on the contrary, points to a cyclical or fragile business where one good year misleads; judge the average margin over a whole cycle rather than the snapshot of the moment.Rating bandsVery steady< 2%Steady2% - 5%Uneven5% - 10%Very uneven> 10%

16.3 pts

Very uneven

Revenue (trailing 12 months)

2.2T INR

Revenue growth (1y)iRevenue growth (YoY)What it is:The change in sales over the last 12 months against the 12 before.How to read it:Compare it with the growth of the other companies in the sector: the higher it is, and the further above the sector, the better for the company.Rating bandspeer median 6.05%Declining< 0%Moderate0% - 4.23%Solid4.23% - 7.26%Strong7.26% - 8.47%Hyper-growth8.47% - 120.93%

18.35%

Hyper-growth

Revenue growth (3y)iRevenue growth (3y)What it is:The average growth in sales per year over 3 years.How to read it:It smooths the jolts of a single year. A wide gap between the 3 years and the past year says the pace is changing, for better or for worse.Rating bandsDeclining< 0%Moderate0% - 15%Solid15% - 50%Strong50% - 120%Hyper-growth> 120%

51.62%

Strong

EPS growth (1y)iEPS growth (1y)What it is:The change in earnings per share over one year.How to read it:Far less stable than sales growth: one exceptional item is enough to triple it or collapse it. Read it with the 5-year growth.Rating bandspeer median 5.31%Declining< 0%Moderate0% - 3.72%Solid3.72% - 6.38%Strong6.38% - 7.44%Hyper-growth7.44% - 106.29%

34.04%

Hyper-growth

EPS CAGR (5y)iEPS CAGR (5y)What it is:The average growth in earnings per share per year over 5 years.How to read it:The underlying trend of profit. Well above sales growth, margins have widened; below it, they have eroded.Rating bandsDeclining< 0%Low0% - 5%Fair5% - 12%Strong12% - 20%Exceptional> 20%

—

EPS revisions (3 months)iEstimate revisionsWhat it is:The 3-month move in consensus EPS: fundamental momentum, the most predictive of them.How to read it:Positive, analysts are raising their profit expectations; negative, they are lowering them. A few percent is enough: prices often follow the direction of revisions over the following months.Rating bandsSharply revised down< -5%Revised down-5% - 0%Revised up0% - 5%Sharply revised up> 5%

—

P/E (TTM)iP/E (TTM)What it is:The share price divided by earnings per share: how many years of today's profit you pay for one share.How to read it:A P/E of 15 is like paying 15 years of profit up front. The lower it is, the cheaper the share, but cheap is not always a bargain: the market often expects profits to fall. It only compares between companies in the same line of business.Rating bandspeer median 14.99xCheap< 8.99xFair8.99x - 17.99xExpensive17.99x - 29.98xVery expensive29.98x - 299.81x

37.9x

Very expensive

Forward P/EiForward P/EWhat it is:The share price divided by the profit analysts expect for the coming fiscal year.How to read it:Well below the current P/E, it says the market expects a strong rise in profits. It rests on a forecast, so it can be proven wrong.Reported earnings, no adjustments. The basis Zonebourse and the press use.Rating bandspeer median 20.73xCheap< 12.44xFair12.44x - 24.87xExpensive24.87x - 41.45xVery expensive41.45x - 414.55x

27.9x

Expensive

EV / EBITDAiEV / EBITDAWhat it is:The value of the company, debt included, against its operating profit before depreciation and amortisation (EBITDA).How to read it:It includes the debt, unlike the P/E: it is the multiple to watch on an indebted company, and it compares two companies financed differently.Rating bandspeer median 6.53xCheap< 3.92xFair3.92x - 7.83xExpensive7.83x - 13.05xVery expensive13.05x - 130.51x

10.8x

Expensive

PEGiPEGWhat it is:The P/E divided by the expected growth in earnings.How to read it:Below 1 the price paid stays reasonable given the growth; above 2 the growth is already dearly paid for. Useless on a company with no growth.Rating bandsGrowth unpriced< 1xFair1x - 1.50xExpensive1.50x - 2xVery expensive> 2x

1.11

Fair

Fair value (reverse DCF)iFair value vs priceWhat it is:The median P/E this share itself carried over its recent fiscal years, against its P/E today. Above 1 = undervalued.How to read it:At 1.2 the stock trades 20% below its own history; at 0.8, 20% above. It compares the stock with itself: it says whether the moment is cheap, not whether the company is good.Where the DCF, the comparables and the analyst targets overlap. Methods agreeing: 0Rating bandsDeeply overvalued< 0.70xOvervalued0.70x - 0.90xFairly priced0.90x - 1.10xUndervalued1.10x - 1.40xDeeply undervalued> 1.40x

1483.57 INR

Overvalued

P/E vs its own 5-year historyiP/E vs its own 5-year historyWhat it is:Where today's P/E sits against the last 5 years.How to read it:At 10%, the share sits among the 10% lowest valuations of its last 5 years: it has been this cheap only 10% of the time. It is a comparison with its own past, not with the sector.Rating bandsFar cheaper than usual< 20%Cheaper than usual20% - 40%In line with its history40% - 60%Pricier than usual60% - 80%At its historical high> 80%

among the 24% lowest valuations

Cheaper than usual

Market cap

11.7T INR

Net debt / EBITDAiNet debt / EBITDAWhat it is:How many years of operating profit it would take to repay the net debt.How to read it:Below 1 the debt is comfortable; above 3 it weighs, and leaves the company exposed to a rate rise or an air pocket.Rating bandspeer median 1.94xNet cash< -0.50xVery solid-0.50x - 1.56xSolid1.56x - 2.92xTight2.92x - 3.89xStretched3.89x - 38.88x

1.3x

Very solid

Gearing (net debt / equity)iGearingWhat it is:Net debt against shareholders' equity.How to read it:It says how far the company is financed by debt rather than by its shareholders. Negative, it holds more cash than debt.Rating bandsNet cash< 0%Very solid0% - 30%Solid30% - 60%Tight60% - 100%Stretched> 100%

71.30%

Tight

CashiCash on hand: the safety buffer and the ability to invest.

578Md INR

Cash / market capiCash / market capWhat it is:The share of the price already covered by cash on hand: the safety cushion.How to read it:At 15%, a sixth of what the company is worth on the market is already in cash. The higher the share, the less a bad year threatens the company; above 50%, the market barely pays for the business itself.Rating bandsStretched< 3%Tight3% - 8%Solid8% - 15%Very solid> 15%

4.95%

Tight

Cash / total debtiCash / debtWhat it is:The share of the debt that cash on hand would cover immediately.How to read it:At 100% the company could settle its debt with the cash in its till. It measures short-term resilience, not profitability.Rating bandsStretched< 15%Tight15% - 30%Solid30% - 60%Very solid60% - 100%Net cash> 100%

28.99%

Tight

Net debt

1.4T INR

Equity

2.0T INR

FCF yieldiFCF yieldWhat it is:The free cash against the market value (free cash flow divided by market capitalisation).How to read it:Read it as a rate. 6% means the company produces 6% of its own value in real cash every year. It is the P/E turned upside down, and harder to dress up.Rating bandspeer median 8.93%Negative< 0%Low0% - 6.25%Fair6.25% - 10.71%High10.71% - 12.50%Very high12.50% - 178.51%

5.43%

Low

Dividend yieldiDividend yieldWhat it is:The dividend paid each year against the share price: the cash you receive just for holding the share, before any rise or fall in the price.How to read it:Compare it first with a risk-free investment (a 3% dividend appeals less when a bond pays 4%). A dividend is only good when earnings cover it, and it is only one part of the return, beside share buybacks.Rating bandsNone< 0.01%Low0.01% - 1%Fair1% - 3%High3% - 6%Very high> 6%

1.34%

Fair

Free cash flow (trailing 12 months)iWhat it is:The money left after running the business and investing (operating cash flow minus capital spending).How to read it:This is what the company can freely return to shareholders, repay or reinvest. The figure closest to real money.

634Md INR

Profitable years in a rowiWhat it is:The number of consecutive fiscal years, counting back from the latest one published, with a positive net income.How to read it:A long streak says the company makes money through the cycles, not only in one good year; it makes the future return more reliable and the dividend more sustainable.

5 years