Financial Ratios for Different Sectors
❖ Telecom Sector
❖ Engineering Sector
❖ Banking Sector
❖ Pharma Sector
❖ Information Technology Sector
❖ Cement Sector
❖ Oil & Gas Sector
❖ Power Sector
❖ Engineering Sector
❖ Banking Sector
❖ Pharma Sector
❖ Information Technology Sector
❖ Cement Sector
❖ Oil & Gas Sector
❖ Power Sector
Over the last couple of lectures, we have discussed some of the most important financial ratios used to evaluate the financial health of a company. In this monthly e-letter, we will delve into some sector-specific ratios that will come in handy when you study companies from particular sectors.
Telecom Sector: Key Ratios
- Average Revenue Per User (ARPU)
This is the total revenue earned by a telecom company from its wireless or wireline operations per user for a specific period of time. The time period is usually a month. This is calculated using the following formula:
ARPU = Total Revenue / (Average Number of Subscribers during the period/12)
The measure gives a relatively good idea on how the trend of revenues has been on a per subscriber basis. Investors can use this ratio to understand whether subscribers being added by the telecom company over time are high or low revenue generators. - Minutes of Usage per subscriber per month (MOU)
This is the average time spent by a subscriber per month (or year) on the network of the telecom operator.
MOU = Total Minutes on the Network (on an absolute basis) / (Average Number of Subscribers during the period/12)
It is a performance indicator that shows how long an average user uses the services of the operator in a month. It provides an understanding of the volumes of an operator. - Realized Rate Per Minute (RPM)
This is the measure of the realizations earned by the telecom operator.
RPM = Total Service Revenues / Total Minutes on the Network
OR,
RPM = ARPU / MOU - Subscriber Acquisition Costs (SAC)
These are the costs related to acquiring a subscriber. It includes costs related to acquisition; costs incurred at the point of sale; free minutes or other benefits being offered to woo subscribers on the network; discounts, etc. - Enterprise Value Per Subscriber (EV/Subscriber)
This is a less commonly used valuation ratio for telecom companies. It is defined as Enterprise Value divided by Total (or average) subscribers.
Enterprise Value in turn is defined as Total Market Cap + Total Debt - Cash and Cash Equivalents + Minority Interest
Engineering Sector: Key Ratios
- Book to Bill Ratio
Book to Bill ratio is the ratio of orders taken to invoices sent (sales) during a set period of time. A high ratio indicates a strong order backlog that should generate sales and profits in future periods while a low ratio indicates falling demand. It is one of the most important measures used to analyze the health of engineering companies. Thus, higher the ratio better it is.
Book to Bill ratio = Order Book / Trailing Twelve Month Sales - Working Capital Cycle
Engineering is a working capital intensive business. Engineering projects typically have a high gestation period, prolonging the overall working capital cycle. Increasing working capital requirements increases the dependence on debt. This threatens the balance sheet strength. Hence, analyzing the working capital cycle of engineering companies is of utmost importance. Lower the working capital cycle better it is. - Working Capital Cycle = Working Capital / Net Sales*365
Working Capital = Current Assets - Current Liabilities - Capacity Utilization Rate
For power equipment manufacturers - Boiler, Turbine, Generator (BTG) - capacity utilization levels is a key metric to gauge the industry competitiveness. Lower utilization signals that there is an overcapacity in the industry or demand is low. This may impact margins and return ratios. On the other hand, higher utilization levels signify that brownfield/greenfield expansions are likely to take place.
Capacity Utilization Rate = Operational power capacity / Total power capacity x 100 - Realization per MW
Amidst strong competition in the power equipment space realization per MW of critical power equipments like BTG have gone down in recent times. Realization per MW is a critical measure that helps us gauge the overall pricing scenario. If the company resorted to predatory pricing its realization per MW would be significantly lower than what prevailed in the past.
Realization per MW: Value of the Order/ Size of the Order in MW
Banking Sector: Key Ratios
- Net interest Margin (NIM)
Just as we calculate and measure performances of non-financial companies on the basis of their operating performance (EBITDA margins), the performance of banks is largely dependent on the NIM for the year. The difference between interest income and interest expense is known as net interest income. It is the income, which the bank earns from its core business of lending.
As such, NIM is the net interest income earned by the bank on its average earning assets. These assets comprise of advances, investments, balance with the RBI and money at call. As such it is calculated as,
NIM = (Interest Income - Interest Expenses) / Average Earnings Assets - Cost to Income Ratio
Be it a bank or a manufacturing firm, controlling overhead costs is a critical part of any organisation. In case of banks, keeping a close watch on overheads would enable it to enhance its return on equity. Salaries, branch rationalisation and technology upgradation account for a major part of operating expenses for new generation banks. Even though these expenses result in higher cost to income ratio, in the long term they help the bank in improving its return on equity. The ratio is calculated as a proportion of operating profit including non-interest income (fee based income).
Cost to Income Ratio = Operating Expenses / (Net Interest Income + Non-Interest Income) - Credit to Deposit Ratio
This ratio indicates how much of the advances lent by banks have been done through deposits. It is the proportion of loan-assets created by banks from the deposits received. The higher the ratio, the higher the loan-assets created from deposits. Deposits would be in the form of current and saving account as well as term deposits. The outcome of this ratio reflects the ability of the bank to make optimal use of the available resources.
Credit to Deposit Ratio = Advances / Deposits - Capital Adequacy Ratio (CAR)
It is a measure of how well-protected a bank is against risks. It is ratio of capital fund to risk weighted assets expressed in percentage terms. The main objective behind the norms is to ensure stability of the banking system.
The capital adequacy ratio is the sum of Tier 1 and Tier 2 capital, divided by the sum of risk-weighted assets. A bank's Tier 1 capital ratio takes a bank's equity capital and disclosed reserves and Tier II comprises of the subordinated debt. Total risk weighted assets take into account credit risk, market risk and operational risk. The capital adequacy ratio speaks of the strength of a bank in the light of risky assets.
CAR = Tier I Capital + Tier II Capital / Risk Weighted Assets - Non-Performing Asset Ratio
The net NPA to loans (advances) ratio is used as a measure of the overall quality of the bank's loan book. NPAs are those assets for which interest is overdue for more than 90 days (or 3 months). Net NPAs are calculated by reducing cumulative balance of provisions outstanding at a period end from gross NPAs. Higher ratio reflects rising bad quality of loans.
The NPA ratio is one of the most important ratios in the banking sector. It helps identify the quality of assets that a bank possesses.
NPA ratio = Net Non-Performing Assets / Loans Given - Provision Coverage Ratio
The key relationship in analysing asset quality of the bank is between the cumulative provision balances of the bank as on a particular date to gross NPAs. It is a measure that indicates the extent to which the bank has provided against the troubled part of its loan portfolio. A high ratio suggests that additional provisions to be made by the bank in the coming years would be relatively low (if gross non-performing assets do not rise at a faster clip).
Provision Coverage Ratio = Cumulative Provisions / Gross NPAs - Return on Assets Ratio
Return on Assets (ROA) ratio is the net income (profits) generated by the bank on its total assets (including fixed assets). The higher the proportion of average earnings assets, the better would be the resulting returns on total assets.
ROA = Net Profits / Average Total Assets
Pharma Sector: Key Ratios
- Formulation Sales as % of Total sales
Most of the Indian pharma companies generate their revenues from formulations (finished drug) or API (Active Pharmaceutical Ingredient - Important ingredient of a drug). The latter one has lower margins compared to the former one. Thus the companies which have large part of revenues coming from formulations segment will have better margins as compared to those selling more of APIs.
Formulations Sales (%) = Total formulations Sales / Total Sales - Domestic Formulations as % of Total Sales
The Indian pharma companies have well established themselves in the global markets. Thus, various companies generate revenues from international segment as well. This ratio helps to understand how much exposure the company has in the domestic market and in international market.
Domestic Formulations (%) = Domestic Formulations Sales / Total Sales - Domestic Sales Force Productivity
Indian markets are known as branded markets. This means companies need sales force (known as medical representatives (MRs)) to promote their brands. Through this ratio, one can know how much revenues are generated per MR. Thus, higher the ratio better is the productivity.
Domestic Sales Force Productivity = Revenues from Domestic Formulations / Sales Force - Chronic Sales as % of Domestic Sales
There are mainly two types of disease - one is chronic, and other is acute. The disease falling under acute category is mostly manageable and curable. However, chronic diseases, by nature, are not completely curable and so its treatment is more for managing the disease and hence is long lasting. The patients have to take drugs for longer duration as compared to acute. The margins of chronic drugs are much higher compared to drugs used for treatment of acute diseases. Thus, a company having larger part of its domestic revenues coming from chronic segment will have better margins. Higher the ratio, better the margins and even better sales force productivity can be expected.
Chronic Sales as % of Domestic Sales = Revenues from Chronic Segment / Total Revenues from Domestic Formulation Sales - Research &Development (R&D) as (%) of sales
Pharma companies spend some part of their revenues in the research and development (R&D) of drugs. This ratio indicates how much a company is spending in order to develop new compounds for its future sales.
R&D as (%) of Sales = R&D Costs / Total Revenues
Information Technology Sector: Key Ratios
- Utilization Rate
This is a measure of employee productivity in an IT firm. It measures the number of employees actually working on projects to the total employee base.
Utilisation Rate (%) = Number of Employees Engaged in Projects/ Total Employee Base
It is reported in 2 ways:- Utilisation including trainees where the denominator will include the employees undergoing training.
- Utilisation excluding trainees where the denominator will not include the number of trainees.
- Utilisation including trainees where the denominator will include the employees undergoing training.
- Man Hours
Man hours, also known as 'volumes' or 'effort' is a measure of revenue in a software business. Since IT companies derives most of its revenues in a 'linear' manner i.e. as per number of hours worked by employees, man hours indicate how much of the revenue is due to the amount of time worked by employees.
It is usually reported in 'person months'. The formula is as follows:
Man Hours (Person Months) = Number of Employees * Utilization Rate * Number of Working Hours in a Day * Number of Working Days in a Month - Billing Rate
The billing (pricing) rate is the hourly rate billed to the client for the work done by the employees of the IT company on that particular project.
The formula is,
Billing Rate = Final Amount Billed to the Client/ Number of Hours Worked
The total revenue earned by the company will be the billing rate * man hours
The billing rate is always in the currency of the client's country (e.g. US$/hour)
The billing rate is a function of various factors. The main ones are:- The competition for the project.
- The company's position in the value chain i.e. high end work like R&D and consulting command higher pricing power while low end work like application development and maintenance do not have high pricing power.
- Onsite or offshore: For work done at the client's location (onsite) the billing rate is higher than for the work done at the company's location (offshore).
- The competition for the project.
- Onsite / Offshore Mix
This tells us the amount of revenues that has been earned from onsite/offshore work to the total revenues of the company. It is a measure of the management's ability to maintain the company's margins. Offshore work provides higher margins due to the lower expenses involved but it comes at a cost of pricing. Generally high end work like consulting is almost completely onsite and therefore command higher pricing. However, since the costs involved in onsite work is very high, the operating margin in lower than offshore work. Thus, managing the onsite/offshore mix in such a way that the margins are not compromised while growing the business is a test of the management's capability.
The formula is,
Onsite/Offshore Mix = Onsite Revenues (as a percentage of Total Revenues) / Offshore Revenues (as a percentage of Total Revenues) - Attrition rate
This is a measure of the company's ability to retain the best talent. It measures the number of employees that have left the firm in the last one year to the total employee base.The formula is,
Attrition Rate (%, on trailing twelve month basis) = Number of Employees that have Left the firm in the last one year/ Current Employee Base
A company which is unable to bring down the attrition and keep it at low levels will struggle to deploy the best talent to handle crucial projects, thereby risking the overall quality of its solutions.
Cement Sector: Key Ratios
- Enterprise Value Per Tonne (EV/Tonne)
Commodity stocks like cement are valued at their replacement cost, which is the cost of setting up a cement plant. The EV/tonne ratio is a measure that indicates set up or replacement cost of the asset in place. If the company were to be bought over, this is the likely price at which one would be interested in acquiring a company). The replacement cost of cement is about US$ 130 per tonne.
EV Per Tonne = EV / Cement Capacity
EV = Market Capitalisation + Total Debt - Cash & Cash Equivalents + Minority Interest
Market Capitalisation = Share Price x Number of Outstanding Equity Shares
Cement Capacity = Total Installed Cement Capacity in Tonnes
Being a cyclical commodity, cement profit margins tend to be quite volatile. As a result, it is difficult to assign a valuation multiple based on earnings. Evaluating a cement company on the basis of EV/tonne may bring in a lot of clarity as compared to other valuation metrics. However, there are several factors that determine whether the company would be valued at a premium to replacement cost or at a discount. Companies with integrated cement plants, captive power plants, efficient technology, wide distribution network and geographical reach, healthy balance sheet and profit margins command a premium over replacement cost. On the other hand, small, regional companies with old cement plants, inefficient management, excess debt and poor margins may trade at a significant discount to replacement cost. - Capacity Utilization Rate
This ratio shows how much of the installed capacity the company is able to utilise in a given year.
Capacity Utilization Rate = Cement Production / Installed Capacity (in tonnes)
Cement has a limited shelf life because of its tendency to absorb moisture. As a result, cement production closely follows demand. Hence, a sub-optimal capacity utilisation rate is often an indicator of poor demand in relation to supply. - Cement Realization Per Tonne
This is the measure of the per tonne realization earned by the cement players.
Realization Per Tonne = Net Cement Sales / Sales Volume
This metric indicates for how much the company is able to sell the cement. A study of the past trend of cement realisations may give an idea about the cyclicality of cement demand and whether manufacturers are able to pass on costs to consumers. - EBITDA Per Tonne
This ratio measures the per-tonne operating profits of a cement company.
EBITDA Per Tonne = Earnings Before Interest, Taxes, Depreciation and Amortization / Cement Sales Volume
This metric helps to gauge the profitability of a cement firm relative to industry peers. A higher EBITDA per tonne reflects the efficiency of the company's operations.
Oil & Gas Sector: Key Ratios
- Gross Refining Margins (GRM)
Refining is primarily a margin-based business in which a refiner's goal is to optimize the refining processes and yield of all products in relation to feedstock used. GRMs are the major indicators of a refinery's operational efficiency. Gross refining margins (GRMs) are weighted average prices of petroleum products minus cost of crude and other feedstock. Here, weights are assigned on the basis of volumes of products sold. GRMs are usually measured in terms of US dollars per barrels. Upturn in refining margins signal increase in the profitability of the refineries. GRMs for the Indian refineries are benchmarked to Singapore GRMs, (current pricing policy at the refinery gate level is trade parity pricing, 80% import parity pricing and 20% export parity pricing).
Gross Refining Margins (US$ Per barrel) = Sum of Weighted Average Price of each Refined Product Extracted Per Barrel of Crude Oil - Per Barrel Cost of Crude Oil - Capacity Utilization
Refineries procure crude oil from various sources and refine it into petroleum products, thus earning profit on refined products. Higher capacity utilization leads to lower fixed cost per unit of refined products (though the fixed cost is not a significant part of the total cost). Lower demand for end products pushes the refining capacity utilization lower. Thus, higher utilization generally leads to higher margins.
Capacity Utilization = Operational Refining Capacity / Total Refining Capacity - Reserve Replacement Ratio (RRR)
This metric helps to judge the operating performance of an oil and gas exploration and production company. The reserve replacement ratio measures the amount of proved reserves added to a company's reserve base during the year relative to the amount of oil and gas produced. If the demand remains stable, a company's reserve replacement ratio must be at least 100% to stay in business long-term. Otherwise, it will eventually run out of oil.
RRR = amount of Proved Reserves Added/ Amount of Oil and Gas Produced - Enterprise Value / Daily Production
This metric takes the enterprise value (market cap + debt - cash & cash equivalents + minority interest) and divides it by barrels of oil equivalent per day (BOE/D). All oil and gas companies report production in BOE. If the multiple is high compared to the firm's peers, it is trading at a premium, and if the multiple is low amongst its peers it is trading at a discount. A key drawback of this metric is that it does not take into account the potential production from undeveloped fields.
Enterprise Value / Daily Production = EV / Barrel of Oil Equivalent per day - Enterprise Value / 2P
This metric helps in analyzing how well resources will support the company's operations. However, it should not be used in isolation as not all reserves are the same. Oil and gas reserves can be proven, probable or possible reserves. Proven reserves are typically known as 1P, having 90% probability of being produced. Probable reserves are referred to as P50, or having a 50% certainty of being produced. When used in conjunction with one another it is referred to as 2P. A high multiple for a company suggests that it might be trading at a premium for a given amount of oil in the ground. A low value would suggest a potentially undervalued firm.
EV / 2P = Enterprise Value / (Proven + Probable Reserves)
Power Sector: Key Ratios
- Plant Load Factor (PLF) - Generation of electricity is a function of PLF and the capacity installed. PLF, in simple words, is like capacity utilization. The level of PLF varies depending upon the kind of generation plant. Generally, a hydro power plant or a wind energy plant would have low PLFs (industry average 35%-50%). Thermal and nuclear power plants have higher PLFs (industry average 60%-70%), which ultimately results in higher production.
PLF = Amount of units actually generated / Total capacity in terms of units*
*A ballpark figure that one could take to calculate the number of units (kilowatt-hour or kWh) is by multiplying every megawatt (MW) of capacity available with 8.76 million. In other words, 1 MW of capacity has the ability to produce approximately 8.76 m units. - Plant Availability Factor (PAF) - The plant availability factor or PAF of a plant is the maximum time that it can produce electricity over a given period and is mainly linked to fuel availability. Higher the availability of fuel, higher will be the PAF.
PAF = Total hours a plant is able to produce electricity over a certain period / Total hours in the period. - Net Asset Value (NAV) per share
As a cross check, for a generation company, one can value the stock based on the replacement cost ( approximate cost of setting up a thermal power plant with capacity of 1 MW) of Rs 60 m per megawatt (if a company has 100 MW, the asset value is Rs 6,000 m). Reduce the amount of total debt and add cash. Divide the figure derived by the number of shares to get an indicative net asset value.
NAV per share = [(Total Capacity (in MW) x 60 (Rs million)) - Total Debt - Cash & Cash Equivalents] / Total number of Outstanding Shares
