Airtel Africa Fundamentals and Key Ratios

Airtel Africa Key Figures

Key Figures
(at previous day's close)
Market Cap.	4,017.46	m
Shares In Issue	3,758.15	m
Prev. Close	105.20
PE Ratio	7.82
Dividend Yield	3.56	%
EPS - basic	13.66	p
Dividend PS	3.81	p
Dividend Cover	-
Cash Flow PS	40.73	p
Return On Equity (ROE)	18.02	%
Operating Margin	25.91	%
PEG Factor	0.09
EPS Growth Rate	86.67	%
Dividends PS Growth Rate	25.00	%
Net Debt	4,625.69	m
Gross Gearing	64.79	%
Quick Assets	1,703.52	m
Net Working Capital	-635.59	m
Intangibles / Fixed Assets	54.90	%
Turnover PS	95.68	p
Pre-Tax Profit PS	24.79	p
Retained Profit PS	9.36	p
Cash PS	12.92	p
Net Cash PS	-49.32	p
Net Tangible Asset Value PS *	-19.42	p
Net Asset Value PS	73.91	p
Spread	0.20 (0.19%)
* Calculation based on Ordinary Capital figure as contained in last annual report, and the most recent shares in issue figure. Therefore the ratio might be exposed to inaccuracies.

%1$s Balance Sheet

%1$s Historic Returns
Giorni da oggi ^†	Open	Change	%	Open Avg.	Avg. Daily Vol [m]	Total Vol [m]	VWAP
1 week	108.00	-1.10	-1.02	104.30	2.62		105.88
4 weeks	120.40	-13.50	-11.21	104.10	3.00		113.07
12 weeks	115.90	-9.00	-7.77	104.10	3.42		116.58
26 weeks	132.80	-25.90	-19.50	104.10	3.76		119.01
1 year	140.40	-33.50	-23.86	104.10	3.98		132.62
3 years	46.68	60.22	129.01	33.50	2.96		111.48
5 years	77.00	29.90	38.83	25.74	2.83		103.90
† periods calculated are whole weeks rather than calendar months

DEEPER ANALYSIS

%1$s Investment Ratios
(Market value analysis) at previous day's close
PQ Ratio	5.17
PE Ratio	7.82
Tobin's Q Ratio	0.39
Tobin's Q Ratio (excl. intangibles)	0.76
Dividend Yield	3.56	%
Market-to-Book Ratio	1.51
Price-to-Pre-Tax Profit PS	4.31
Price-to-Retained Profit PS	11.42
Price-to-Cash Flow PS	2.62
Price-to-Sales PS	1.12
Price-to-Net Tangible Asset Value PS	-6.50
Price-to-Cash PS	8.27
Net Working Capital PS	-16.91
Price Pct to Working Capital PS	-6.32	%
Earnings Yield	12.78	%
Average PE	6.96
Years in average	3
PE to PE average	112.40	%

%1$s Financial Ratios
(Leverage Ratios)
Debt Ratio	49.95	%
Debt-to-Equity Ratio	1.00
Debt-to-Equity Ratio (excl. Intgbl)	-4.49
Debt-to-Equity Market Value	0.69
Net Gearing	58.64	%
Net Gearing (excl. Intangibles)	102.95	%
Gross Gearing	64.79	%
Gross Gearing (excl. Intangibles)	113.76	%
Gearing Under 1 Year	29.65	%
Gearing Under 1 Year (excl. Intgbl)	52.06	%
Assets/Equity	2.84
Cash/Equity	17.48
(Liquidity Ratios)
Net Working Capital to Total Assets	-8.06	%
Current Ratio	0.73
Quick Ratio (Acid Test)	0.73
Liquidity Ratio	0.21
Cash & Equiv/Current Assets	28.51	%
(Solvency Ratios)
Enterprise Value	6,415.94	m
CFO/Sales	0.43
CFO/Attributable Profit	3.19
CFO/Assets	0.19
CFO/Debt	0.30
Total Debt/Equity Market Value	1.27
Total Debt/Sales	1.42
Total Debt/Pre-Tax Profit	5.49
Total Debt	5,111.32	m
Total Debt/Net Current Assets	-8.04	%
(Dodds - Graham Ratios)
3 yr Compound Earnings Growth	17.67	%
5 yr Compound Earnings Growth	-	%
10 yr Compound Earnings Growth	-	%
Earn drops > 5% in 10yrs	1

%1$s Operating Ratios
(Profitability Ratios)
Return On Capital Employed (ROCE)	16.79	%
Return On Assets (ROA)	4.72	%
Net Profit Margin	13.36	%
Assets Turnover	0.35
Return On Equity (ROE)	18.02	%
Return On Investment (ROI)	6.97	%
Dividend Payout Ratio	29.76	%
Plowback Ratio	70.24	%
Growth from Plowback Ratio	9.77	%
Net Income Of Revenues	9.78	%
(Asset Utilisation Multiples)
Shareholders Equity Turnover	1.04
Fixed Assets Turnover	0.45
Current Assets Turnover	1.60
Net Working Capital Turnover
Inventory Turnover	-
(Other Operating Ratios)
Total Assets-to-Sales	2.83
Debtors-to-Sales	34.07	%
Debt Collection Period	124.35	Days

Broker infomation is not available for this class of share.