Search Column	Comments	Calculation
AS_Month AS_3Month AS_6Month AS_9Month AS_Year AS_2Year AS_3Year AS_4Year AS_5Year	Absolute Strength (i.e. price change) of the share over one month, 3 months, 6 months and 9 months, one year, 2 years, 3 years, 4 years and 5 years.	ASY=((P - PY) / PY) x 100 ASY =Absolute Strength over 1 Year P =Current Price PY =Price one year ago
CashFlow_EPS_Ratio	Ratio of Net Cash Flow to Net Profit. It is a good sign if the ratio of Net Cash Flow to Earnings is consistently above 1.	Net Cash Flow / Net Profit
CashFlow_Growth_Historic CashFlow_Growth_3Yr CashFlow_Growth_5Yr	Growth in Net Cash Flow. A good investment normally has good cash flow, though it can be a volatile measure.	(Net Cashflow – Previous Net Cashflow) x100 / Previous Net Cashflow
Current_Ratio	Ratio of Current Assets to Current Liabilities. Current Assets are as Cash + Debtors + Stock + Other Current Assets. A ratio of two or more is a sign of financial strength. A ratio of under 1.2 can be a sign of weakness.	Current Assets / Creditors Short
Div_Cover Div_Cover_Historic Div_Cover_Projected Div_Cover_Rolling Div_Cover_Projected2 Div_Cover_Rolling2	Ratio of Adjusted EPS to Dividend Per Share. Shows how sustainable a Dividend is. A Dividend Cover of less than 1.5 may indicate a danger of a dividend cut unless it is in a very stable industry such as a Utility. Above 2 is regarded as healthy.	Adjusted EPS / Dividend Per Share
Div_Growth_Projected Div_Growth_Historic Div_Growth_3Yr Div_Growth_5Yr	Dividend Growth as a Percentage. A steady dividend growth shows the Directors’ confidence in the state of the business.	Div Per Share – Previous Div Per Share x 100/ Previous Div Per Share
Earnings_Quality	The ratio of the Basic EPS to the Adjusted EPS. This shows how much of the EPS has been adjusted for Exceptional and Goodwill. Ideally the ratio should be 1.	Basic EPS / Adjusted EPS
Earnings_Yield	Earnings before Interest and Tax (EBIT) to Enterprise Value (EV) ratio. EV is Market Capitalisation + Net Debt. Used in Joel Greenblatt’s method in "The Little Book that Beats the Market".	Profit Before Tax + Interest /(Market Cap + Net Debt + Preferred + Minorities)
EV_Sales	Enterprise Value (EV) to Sales ratio. EV is Market Capitalisation + Net Debt. EV/Sales is similar to PSR but takes account of the fact that to buy a company you would also have to take on its debt.	(Market Cap + Net Debt + Preferred + Minorities) / Turnover
EV_EBITDA	Enterprise Value (EV) to Earnings before Interest, Taxes, Depreciation and Amortisation (and Exceptionals). EV is Market Capitalisation + Net Debt. Often used to value loss making companies. Became a popular measure in the Tech boom.	(Market Cap + Net Debt + Preferred + Minorities) / Profit Before Tax – Interest -Exceptionals + Depreciation
Final_Ex_Div_Date	The last date that a shareholder is eligible to receive the Final Dividend.
FTSE_Index	The FTSE index of the Share. Either FTSE100, FTSE250, AIM or nothing
Gearing	Net Debt as a Percentage of Net Assets (or Shareholders’ Funds). A gearing of over 100% is regarded as high. If Gearing is negative it denotes Net Cash. If AR is shown next to Gearing it means it is calculated from the last final result as no interim net debt can be obtained. If the Gearing shows “-“ and the company is not a financial then the net debt could not be obtained. An approximate value can be derived from Cash + Debtors – Short Creditors – Long Creditors.	Net Debt/(Equity Funds + Preferred Funds)
Gearing_Tangible	Net Debt as a Percentage of Tangible Net Assets. A gearing of over 100% is regarded as high. If Tangible Gearing is negative it denotes Net Cash. Regarded by many Value Investors as the preferred measure of Gearing as it strips out potentially worthless Intangible Assets such as Goodwill from Acquisitions.	Net Debt/(Equity Funds- Intangible Assets + Preferred Funds)
EPS_Growth EPS_Growth_Projected EPS_Growth_Projected2 EPS_Growth_Historic EPS_Growth_Rolling EPS_Growth_Rolling2 EPS_Growth_3Yr EPS_Growth_5Yr	EPS Growth as a Percentage. EPS_Growth shows the Rolling EPS Growth calculated in a similar way to PER_Rolling. EPS_Growth_Projected2 And EPS_Growth_Rolling2 are based on 2 Year forecasts. EPS_Growth_3Yr is the 3 year historic growth. EPS_Growth_5Yr is the 5 year historic growth.	((Adjusted EPS-Prev EPS) / PrevEPS)*100
Forecast_Change_Week Forecast_Change_Month Forecast_Change_3Month Forecast2_Change_Week Forecast2_Change_Month Forecast2_Change_3Month	Percentage change in the EPS Forecast over one week, one month and three months. The Forecast2_xxxx columns show the change of 2 Year forecasts.	EPS Forecast – Previous EPS Forecast x 100/ Previous EPS Forecast
Graham_Ratio	A Ratio used by Ben Graham the famous Value Investor. It is defined as the ratio of Net Current Assets minus non current liabilities to the Market Capitalisation. Graham was looking for companies with a ratio of less than two thirds. Very few shares meet his criteria these days.	Market Capitalisation /(Net Current Assets – Creditors Long – Provisions)
Interest_Cover	Ratio of Group Operating Profit to Interest Payments. Shows how easily a company can support its interest payments. An interest cover of over four would usually be regarded a reasonably safe. Note that Interest is defined as Group Interest and does not include subsidiary payments. Operating Profit will exclude Goodwill Amortisation and Exceptional Items.	Operating Profit / Interest
Interim_Ex_Div_Date	The last date that a shareholder is eligible to receive the Interim Dividend.
Last_Price_Change	The percentage price change over the previous closing price.	(Last Price – Previous Price) x 100 / Previous Price
NAV_Growth_Historic NAV_Growth_3Yr NAV_Growth_5Yr	Growth in Net Asset Value. This is particularly useful for property companies, which are normally valued by their Net Assets.	(NAV – Previous NAV) x100 / Previous NAV
NTAV_Growth_Historic NTAV_Growth_3Yr NTAV_Growth_5Yr	Growth in Net Tangible Asset Value ie Net Assets minus Intangible Assets. This is particularly useful for property companies, which are normally valued by their Net Assets.	(NTAV – Previous NTAV) x100 / Previous NTAV
Net_Profit_Margin	Ratio of Net Profit to Turnover as a percentage. The Net Profit includes Exceptional Items and Goodwill Amortisation. Compare the Net Profit Margin to others in the Sector.	(Net Profit/Turnover ) x 100
Operating_Margin	Ratio of Operating Profit to Turnover as a percentage. The Operating Profit excludes Exceptional Items and Goodwill Amortisation. Compare the Operating Margin to others in the Sector. A decreasing Operating Margin is a potential sign of problems.	(Operating Profit/Turnover ) x 100
Oper_Cashflow_Yield	Percentage of Operating Cashflow to Enterprise Value (EV). This ratio is often used by Private Equity firms looking for companies with strong cash flow characteristics. A company with a Yield of over 20% may indicate a possible buy out.	Operating Cash Flow / EV EV = Marketcap + Prefs + Minorities + Net Debt
PBV	Price to Book Value. Ratio of Market Capitalisation to Equity Shareholders’ Funds. Used by Value Investors to compare the value of a company to its Assets. A PBV of less than 1 is usually cheap but the quality of the assets (especially Intangibles such as Goodwill) must be examined. Many Value investors prefer to use PTBV.	Market Cap / Equity Shareholder Funds
PBV_Hist_Avg_Ratio	Ratio of the PBV to the historical average PBV of a company back to 03/2000	PBV / Historical Average PBV
PBV_Sector_Ratio	Ratio of the PBV to the PBV of the Sector a company is in.	PBV / Sector PBV
PTBV	Price to Tangible Book Value. Ratio of Market Capitalisation to Tangible Equity Shareholders’ Funds. Used by Value Investors to compare the value of a company to its Assets. A PTBV of less than 1 is usually cheap but examine the quality of the assets. Cash is the best asset but the value of stocks, property and machinery can vary widely from their quoted value.	Market Cap / (Equity Shareholder Funds – Intangible Assets)
PCF	Price to Cash Flow ratio. Ratio of Market Cap to Net Cash Flow. In a healthy company the PCF should normally be lower than the PER. If PCF is consistently higher than PER or is negative, the reasons should be examined closely.	Market Cap / Net Cash Flow
PCF_Avg_Cashflow_5Yr	Price to Cash flow ratio based on 5 years average cash flow per share. Cash flow can be quite volatile and erratic, so if you are looking for good sustainable cash flow it makes sense to average over a number of years.	Price / 5 year Average Cash flow per Share
PEG PEG_Historic PEG_Projected PEG_Rolling PEG_Projected2 PEG_Rolling2	Price Earnings Growth Ratio. Only calculated for Growth companies with these requirements: Available EPS forecasts. A four year EPS growth record, including forecasts. No losses in the last five years. Not a property company A PEG of less than one indicates a good growth stock candidate.	PER/ EPS Growth
PEG_All	Price Earnings Growth Ratio. The same as PEG but without any growth requirements.	Rolling PER/ Rolling EPS Growth
PFCF	Price to Free Cash Flow ratio. Ratio of Market Cap to Net Cash Flow – Capital Expenditure. Positive Free Cash Flow is a good sign. Free Cash Flow can support dividends or share buy backs.	Market Cap / (Net Cash Flow – Capital Expenditure)
PER	Price Earnings Ratio. A PER of over 20 is regarded as relatively expensive, and under 10 cheap. The PER is based on the Adjusted Diluted Rolling EPS, which strips out exceptional items, allows for Share Option Dilution and uses both the historic EPS and Forecast EPS. See PER_Rolling.	PER_Rolling
PER_Avg_EPS_5Yr	PER based upon the average Earnings per share over the last five years. Can be useful for cyclical shares that have erratic earnings. Also some cautious investors prefer to use average earnings over a long period to make sure earnings power is really sustainable.	Price / 5 year Average Earnings per Share
PER_Projected PER_Historic PER_Projected2	PER_Historic is based on the Adjusted Diluted EPS from the last Final Results. PER_Projected is based to the next forecast EPS. PER_Projected2 is based to the 2 year forecast EPS.	Price Per Share/Adjusted EPS (forecast or historic)
PER_Rolling	Rolling Price Earnings Ratio. If both forecast and historic PE ratios are available then the rolling PER will be based on both, as a ratio of the time passed since the results year end date. e.g. If the date is 30 April and year end for a company was 31 December, the historical EPS is 4p, the forecast EPS is 6p and the price is 100p then: Rolling PER = 100 /(((12-4)/12) x 4 + ((4/12) x 6)) = 100 / 4.66 = 21.4	Rolling PER = Price /(((12 - Mon)/12) x HistEPS + ((Mon/12) x ForEPS)) Mon = Months since last Year End Date HistEPS = Historical EPS ForEPS = Forecast EPS Price = Share Price
PER_Rolling2	Rolling 2 Year Price Earnings Ratio. If both forecast and 2 year forecast ratios are available then the rolling 2 year PER will be based on both, as a ratio of the time passed since the results year end date. eg. If the date is 30 April and year end for a company was 31 December, the forecast EPS is 4p, the 2 year forecast EPS is 6p and the price is 100p then: Rolling PER = 100 /(((12-4)/12) x 4 + ((4/12) x 6)) = 100 / 4.66 = 21.4	Rolling PER = Price /(((12 - Mon)/12) x ForEPS + ((Mon/12) x For2EPS)) Mon = Months since last Year End Date ForEPS = Forecast EPS For2EPS = Forecast 2 Year EPS Price = Share Price
PER_Hist_Avg_Ratio	Ratio of the PER to the historical average PER of a company back to 03/2000	PER / Historical Average PER
PER_Sector_Ratio	Ratio of the PER to the PER of the Sector a company is in.	PER / Sector PER
Piotroski_Score	A scoring system used for measuring the health of low Price to Book companies. It varies from 0 to 9, 9 being healthiest. Property companies and Financials are excluded. See: http://boards.fool.co.uk/Message.asp?mid=8523931 for further details.
Price_High_Yr	The Highest Share Price attained in the last 52 week period.
Price_Low_Yr	The Lowest Share Price attained in the last 52 week period.
Price_NCA	Price to Net Current Assets ratio. Net Current assets are the Current Assets (Stocks, Debtors and Cash) minus the Current Liabilities (less than one year). A ratio of less than one is extremely cheap.	Market Cap / Net Current Assets
Price_NetDebt	Price to Net Debt (or Cash) ratio. Is negative if the company has net debt and positive if it has net cash. A company priced less than net cash ( i.e. >0 and <1 ) is extremely cheap although the cash flow should be examined to make sure there is not a high “cash burn”. Financials may give misleading results as some of the cash may belong to customers.	Market Cap / Net Debt
PSR	Price to Sales ( Turnover) Ratio. A low PSR (< 0.5 ) is often used as an indicator of Value. It should be compared with the average for the sector as some sectors eg Distributors have naturally low PSRs. A low PSR and positive Relative Strength is one of the most successful investment strategies historically. See also EV / Sales.	Market Cap / Turnover
Quick_Ratio	Ratio of Quick Assets to Current Liabilities. Quick Assets are those that can be disposed of quickly and are defined as Cash + Debtors but excluding stock and work in progress. A healthy quick ratio would be above one.	Cash + Debtors / Creditors Short
ROC	Return On Capital. Defined as EBIT (Earnings before Interest and Tax) * 100 / (Net Working Capital + Tangible Assets) where Net Working Capital is defined as Inventory + Receivables + Other Current Assets - Current Liabilities. Similar to ROCE. Used in Joel Greenblatt’s method in "The Little Book that Beats the Market".	(Profit Before Tax + Interest) x 100 / (Inventory + Receivables + Other Current Assets - Current Liabilities + Tangible Assets)
ROCE