Hemscott: Log in | Register

Ratios

Report ratios section

Along with company overview section of the Facts Report the Ratios box is intended to give a quick overview of a company's investment potential. The twelve ratios are from a combination of the profit and loss account, balance sheet and cashflow statement and provide a detailed insight into the company's current performance. With any figure or ratio it's a good idea to put it into context.The sector and market average figures allow you to do exactly this.

Technical Definitions

Sector and Market Calculations

The calculation of both of these figures comes in three stages. We will use Price to Sales Ratio (PSR) as an example:

  1. Firstly we calculate a PSR for all companies within the Hemscott universe;

  2. Next we eliminate all of those companies with a statistically significant PSR. The reason we do this is to remove any company that has an above average or below average figure that in turn skews the overall ratio for the market or sector.

    We do this by taking our population of companies (P) and turn it into a normal distribution by applying the natural log:

    P' = ln ( abs (p) )

    Now we calculate the mean standard deviation (std dev) of P':

    Mean = m' = av (P')

    Std Dev = s' = std dev (P')

    Finally we form a subset of P' denoted by:

    M' ± 1.96.s'

    Overall this means that we remove any company that falls outside of 95% of the populations standard deviation.

  3. Finally we take our population of PSR's and give them a weighting by market capitalisation. We do this by:

    From the above box BOC Group (BOC) has a PSR of 1.21. Using the Chemicals sector (which BOC in included) as an example we take all of those PSR's (column B) and multiply them by the company's market capitalisation (column C) to give a PSR x Mkt Cap figure (column D).

    Sector PSR

    The numbers in column F, above, are the weighting of a company's PSR within its sector. These are calculated by dividing the PSR x Mkt Cap figures in column E by the sum of the Market Capitalisations for that sector (bold figure at the bottom of column D).

    Finally all of the figures in column F are added together to give the sector average PSR, in this case 1.36.

    To calculate the figure for the market as a whole we use exactly the same process but we use all companies in the Hemscott universe and not just a specific sector.

Prospective Figures/Time Apportionment/Rolling 12 Month Ahead Basis

All growth statistics are calculated on a rolling 12 months ahead basis. The reason we do this is to make all our figures comparable, so for example, for a company with 31st October financial year its necessary to take a quarter of the current year's brokers' consensus forecast and three quarters of the consensus forecast for the following financial year. By adopting this approach for all companies, chalk and cheese are converted into chalk and chalk, enabling tables to be prepared and meaningful comparisons to be made. The diagram below explains the concept more fully:

Calculation of Time Apportionment

Notation
Symbol Meaning Use
x multiple
% percentage
f factor
p pence
pr prospective we calculate PER, Dividend
ar historic historic/annual report
The Ratios
PER (pr) Price Earnings Ratio (x) = Share Price (Close on Last Trading Day) / EPS Prospective
DY (pr) Dividend Yield (%) = (Dividend (Total Dividend Per Share For Last Financial Year) / Last Closing Share Price) x 100
PEG (pr) Price Earnings Growth Factor (f) = PER (Price Earnings Ratio) (pr) / Normalised EPS Growth (pr)
ROCE Return on Capital Employed (%) = (Return / Capital Employed) x 100

Return = Normalised Pre Tax Profit + Interest Paid

Capital Employed = Share Capital & Reserves + Preference Capital + Minority Interests + Provisions + Total Borrowings - Intangible Assets (Net)
Op. Margin Operating Margin (%) = (Trading Profit / Turnover) x 100

Trading Profit = Normalised Pre Tax Profit + Share of Associates Profit + Net Interest + Rental Income
EPS Growth Prospective Normalised EPS Growth (%)

This is calculated on a 12 month rolling basis. See above for an explanation of how to calculate time apportionment.
EV/EBITDA Enterprise Value/Earnings Before Interest Tax Depreciation & Amortisation

EV = Market Capitalisation (At last close) + Total Borrowings - Cash & Equivalents

EBITDA = Normalised Earnings + Net Interest + Tax + Depreciation + Amortisation
Net Gearing ((Total Borrowings - Cash & Near Cash) / Shareholders Funds) x 100
NTAV PS Net Tangible Asset Value Per Share (p) = Net Tangible Assets / Shares In Issue At Year End (diluted)

Net Tangible Assets = Equity Interest in Shareholders Funds - Intangible Assets
PTBV Price to Tangible Book Value (x) = Latest Share Price / Tangible Book Value PS

Tangible Book Value PS = Tangible Book Value / Shares In Issue At Year End (Diluted)

Tangible Book Value = Share Capital & Reserves - Intangible Assets
PCF Price to Cashflow Ratio (x) = Share Price (Close on Last Trading Day) / Cashflow Per Share

Cashflow Per Share = Cashflow / Average Shares In Issue (Last Financial Year)

Cashflow = Cash From Operating Activities + Return On Investments + Servicing Of Finance - Taxation
PSR Price to Sales Ratio = Share Price (Close on Last Trading Day) / Sales Per Share

Sales Per Share = Turnover / Average Shares In Issue (Last Financial Year)

Terms of Use | Privacy Policy | Sources & Disclaimer Copyright 2009 Hemscott Group Limited.
Hemscott is the UK registered trademark of Hemscott Group Limited.
Prices displayed on Hemscott.com are delayed by at least 15 minutes unless otherwise stated.