FullReport of FairValue can be seen:
Bhartiartl | Price | Marketcap in cr | Customerbase | Sales | Profit | Equity | FV | Reserve | Debt-long | Debt-Current | Lease | F-EPS | Div% | Trade_Receiv | Assets | Liabilities | ||
Telecom | 698 | 411244 | 47.13 Cr | 112,690 | 6,761 | 2746 | 5 | 57441 | 129886 | 15599 | 26407 | 6 | 25% | 5035 | 365836 | 282285 | ||
PROFITABILITY | GROWTH | SOLVENCY | VALUE | |||||||||||||||
PR_MARGIN | ICR | ROE | ROPE | Growth20Year | D|E (TOTAL) | DEBTOR TURNOVER | DEBT RATIO | F-PE | F-YIELD | |||||||||
5.3% | 39 | 11.2% | 2.5 | 12% | 242% | 8 | 130% | 118 | 0.8% | |||||||||
Customer | Years | Total Income | Expenditure | Interest | Net Profit | Equity | Reserves | EPS | NPM % | 52 wk High | 52 wk Low | High P/E | Low P/E | |||||
2002 | 1,504 | -924 | -109 | -181 | 1853 | 2971 | -1.1 | -12 | 55 | 38 | -52 | -36 | ||||||
2003 | 3,055 | -1954 | -273 | -205 | 1853 | 2973 | -1.1 | -7 | 42 | 21 | -38 | -19 | ||||||
2004 | 5,037 | -2775 | -269 | 585 | 1853 | 3061 | 3.1 | 12 | 167 | 28 | 53 | 9 | ||||||
2005 | 8,156 | -4311 | -244 | 1224 | 1856 | 3464 | 6.5 | 15 | 241 | 115 | 37 | 18 | ||||||
2006 | 11,664 | -6387 | -224 | 2055 | 1894 | 5456 | 10.8 | 18 | 430 | 192 | 40 | 18 | ||||||
2007 | 18,420 | -9284 | -249 | 4110 | 1896 | 9562 | 21.4 | 22 | 850 | 310 | 40 | 14 | ||||||
2008 | 27,012 | -12920 | -528 | 6495 | 1898 | 19769 | 34.2 | 24 | 1149 | 700 | 34 | 20 | ||||||
2009 | 37,352 | -18239 | -1861 | 7859 | 1898 | 27089 | 41.4 | 21 | 950 | 484 | 23 | 12 | ||||||
2010 | 41,847 | -25084 | -1756 | 9164 | 1899 | 37718 | 23.7 | 22 | 467 | 230 | 20 | 10 | ||||||
2011 | 59,538 | -39530 | -2535 | 5899 | 1899 | 46868 | 15.9 | 10 | 377 | 254 | 24 | 16 | ||||||
2012 | 71,451 | -47794 | -4083 | 4258 | 1899 | 48712 | 11.2 | 6 | 445 | 320 | 40 | 28 | ||||||
2013 | 76,905 | -53689 | -4519 | 2267 | 1899 | 48423 | 6.0 | 3 | 370 | 239 | 62 | 40 | ||||||
2014 | 85,746 | -58021 | -5879 | 3019 | 1999 | 57757 | 7.0 | 4 | 374 | 267 | 53 | 38 | ||||||
2015 | 98,197 | -62499 | -4447 | 5053 | 1999 | 37778 | 11.6 | 5 | 420 | 304 | 36 | 26 | ||||||
2016 | 96,619 | -62548 | -8546 | 6893 | 1999 | 64771 | 15.2 | 7 | 452 | 282 | 30 | 19 | ||||||
2017 | 95,589 | -60139 | -9547 | 4241 | 1999 | 65458 | 9.5 | 4 | 401 | 284 | 42 | 30 | ||||||
2018 | 82,888 | -52560 | -9326 | 2184 | 1999 | 67536 | 2.8 | 3 | 565 | 333 | 205 | 121 | ||||||
40.4 | 2019 | 81,127 | -55016 | -10622 | 1688 | 1999 | 69424 | 1.0 | 2 | 427 | 277 | 445 | 289 | |||||
42.3 | 2020 | 84,677 | -50423 | -14073 | -30664 | 2728 | 74417 | -63.4 | -36 | 569 | 313 | -9 | -5 | |||||
47.1 | 2021 | 100616 | -55244 | -15091 | -12364 | 2746 | 56207 | -27.7 | -12 | 623 | 394 | -22 | -14 | |||||
Growth | Total Income | Expenditure | Interest | Net Profit | Equity | Reserves | EPS | NPM % | 52 wk High | 52 wk Low | High P/E | Low P/E | ||||||
Historial Growth | 25% | 24% | 30% | 17% | 5.6 | 14% | 13% | 36.6 | 17.7 | 27.2 | ||||||||
15 Year Growth | 15% | 15% | 32% | 3% | 17% | 6.4 | 3% | 5% | 66.3 | 41.4 | 53.8 | |||||||
10 Year Growth | 5% | 3% | 20% | 4% | 2% | -0.4 | 5% | 4% | 82.3 | 53.4 | 67.8 | |||||||
5 Year Growth | 1% | -2% | 12% | 7% | -3% | -5.4 | 7% | 7% | 115.1 | 73.2 | 94.1 | |||||||
Average Growth | 12% | 10% | 23% | 4% | 8% | 1.5 | 7% | 7% | 75.1 | 46.4 | 60.8 | |||||||
CustomerBase | H1 | Sales | Finance | Cost | EBITDA | Profit | EPS | Margin | ICR | Q1 | Sales | Finance | Cost | Profit | EPS | Margin | ICR | |
42.3 | 2021 | 48351 | 7259 | 27364 | 21496 | -15225 | -30.47 | -31% | 3.0 | 2021 | 23290 | -3467 | -13373 | -15191 | -29.22 | -65 | 3.0 | |
47.1 | 2022 | 55180 | 8190 | 28389 | 27109 | 2940 | 2.57 | 5% | 3.3 | 2022 | 26854 | -4226 | -13873 | 941 | 0.52 | 4 | 3.1 | |
11% | Growth | 14.1% | 12.8% | 3.7% | 26.1% | -119.3% | -108.4% | -116.9% | 11.8% | Growth | 15.3% | 21.9% | 3.7% | 106.0% | 102.0% | 105.0% | 38.4% | |
Expectation | Sales | Margin | CURRENT TREND | YEAR | 9M | ANNUAL | Q1 | H1 | EST_2022 | |||||||||
Cy year | 12% | 6% | SALES | 21% | 19% | 15% | 14% | 12% | ||||||||||
Long Term | 12% | 7% | PROFIT | -46% | 60% | 106% | 119% | |||||||||||
MARGIN | -41% | -12% | 4% | 5% | 6% | |||||||||||||
Estimates | Sales | Profit | EPS | Fairvalue | ||||||||||||||
2022 | 112,690 | 6,761 | 6 | 359 | YEAR | Q3 | Q4 | Q1 | Q2 | E-2022 | ||||||||
2030 | 271,185 | 18,983 | 17 | 1,008 | TRAILEPS | 1.57 | 1.39 | 0.51 | 2.06 | 5.53 | ||||||||
2035 | 469,492 | 32,864 | 29 | 1,745 | ||||||||||||||
Segment Sales | 2022 | 2021 | Share | Growth | Cost | 2022 | 2021 | Share | Growth | |||||||||
India-Mobile | 29497 | 26709 | 52% | 10% | D&A | 15961 | 14399 | 30% | 11% | |||||||||
Africa=Mobile | 16769 | 13617 | 29% | 23% | Network Operating | 11976 | 10516 | 23% | 14% | |||||||||
SouthAsia-Mobile | 191 | 220 | 0% | -13% | Finance | 8190 | 7259 | 16% | 13% | |||||||||
Airetl Business | 7785 | 7084 | 14% | 10% | Access Charges | 3287 | 5724 | 6% | -43% | |||||||||
Others | 18 | 3 | 0% | 500% | Spectrum liscense | 5325 | 4312 | 10% | 23% | |||||||||
Homes Services | 1366 | 1166 | 2% | 17% | Other exp | 3337 | 3122 | 6% | 7% |