-
Our goal is to provide the primary Telecom KPIs to our customers so that they can understand the performance of individual companies compared to their peers.
Our focus is on both operational and financial KPIs - company health and peer benchmarking requires both to fully understand the market dynamics.
-
There are 3 primary sources for the data that we compile.
Quarterly and annual results published by Telcos.
Regulator publications within each country where available
Our own estimates based on the experience of our analysts - where we do not have sufficient information then we do not provide an estimate - we review the available information each quarter and update any new data that is available.
-
We typically update the data within 24 hours of the data becoming available or published by the individual companies. As results for companies can be staggered over a 2 month period some of the comparative analysis for the most recent quarter will be compromised until all of the results are out. For Telcos who only publish annual or bi-annual results we will typically provide revenue and subscriber estimates for the interim periods.
-
You may subscribe to our trial system www.kpilog.com/subscribe which gives you 7 days free access to a subset of the data.
After the trial period the annual subscription for your preferred dataset will be debited and you will receive full access to the latest data with regular updates for a one year period.
You may cancel your subscription at any stage during the 7 day trial.
Please use the contact form if you have any queries in this regard.
-
We add new companies and KPIs on a regular basis - primarily based on customer demand. Please contact us if there is a particular KPI that you would recommend.
We also offer customized solutions on request for companies who may wish to establish their own private internal benchmarking service and incorporate our data.
-
Revenue and profit KPIs
Total revenue and revenue share are based on $US using quarter end exchange rate.
QoQ% and YoY% are based on local currency in order to remove impact of exchange rates.
Operating income and Pretax profit margins exclude any once off gains during the period.
EBITDA margins vary depending on the available data as follows; a) EBITDA = Operating income - D&A b) EBITDA AL = EBITDA after leases c) EBITDA adjusted - excludes once off costs. The tooltip will show which EBITDA is being displayed.
Capex includes Capital lease and ROU costs where available.
Operating free cash flow OFCF = EBITDA-Capex-ROU/Lease costs
FCF Free cash flow = CFFO-Capex-ROU/Lease costs-interest costs-Spectrum costs
Net income margin = Net income/Net income continuing/ Total revenue
ROCE = 12 month EBIT/ 12 month average (Total Assets-Current Liabilities)
ROIC = 12 month NOPAT(Net operating income after tax)/Invested capital(Total debt + Shareholder equity)
Market cap = Total outstanding shares at end of quarter x Share price in $US
Enterprise value = Market cap + Net debt + Minority interest - this is only available for listed companies.
Net debt = Total debt + Capital Lease debt - Cash - short term investments
ROA(Return on Assets) = 12m Net income/12m Average Total assets
ROE(Return on Equity) = 12m Net income/12m Average Shareholder funds - note we do not calculate this for companies in negative equity.
Wireless, Wireline and TV KPIs
Wireless count methodology varies significantly by operator and we try and present the most accurate data available to facilitate comparison within each market. Our terminology is as follows; Total wireless = Total active SIMs excluding M2M/IoT. Total wireless incl M2M/IoT - where M2M detail is not verifiable or available. Total wireless regulator - used where companies have different methodologies for counting within a market - regulator data is more accurate from a comparative perspective.
Fixed broadband - excludes mobile broadband but includes Fixed wireless access.
ARPU calculation methodology varies significantly and comparison can be difficult as a result - we include the ARPU type in the chart/tooltip for better understanding.
Please contact us if there are any additional clarifications required.
-
Ranking provides a method of including a number of KPIs in order to identify the top performers during a financial year - not an exact science but a useful indicator we believe.
Ranking is based on the cumulative rank that each company achieved for the KPIs which are included. This rank is based on the financial year - mid year or quarterly rankings are not appropriate we believe.
Users can select/de-select KPIs to reflect their preference in this analysis.
-
Yes - the charts and data are customised to ensure optimum performance on your preferred device.
Some of the more complex filtering is not available on the mobile version due to space limitations and are best viewed on a desktop or tablet.
The Tableau App is significantly quicker than the performance on this website
-
Yes - we use Tableau as our preferred application - the Tableau App is much quicker than this website.
We can also integrate with other BI platforms on request.